The plume.dex_trades table contains all DEX trades in the Plume blockchain.

​
Table Schema

Column NameData TypeDescription
block_timetimestampBlock timestamp
token_bought_symbolstringSymbol of bought token
token_sold_symbolstringSymbol of sold token
token_bought_amountdoubleAmount of bought token
token_sold_amountdoubleAmount of sold token
token_bought_addressstringAddress of bought token
token_sold_addressstringAddress of sold token
takerstringTaker address
makerstringMaker address
projectstringDEX project name
versionstringDEX version
categorystringTrade category
usd_amountdoubleUSD value of trade
token_pairstringToken pair
tx_hashstringTransaction hash
tx_fromstringTransaction sender
tx_tostringTransaction recipient
trace_addressarrayTrace address
evt_indexdecimal(38,0)Event index
block_numberdecimal(38,0)Block number

​
Sample Query

-- Get the top DEXs by trading volume in the last 24 hours
SELECT 
    project,
    COUNT(*) as trade_count,
    SUM(usd_amount) as total_volume_usd
FROM plume.dex_trades
WHERE block_time >= NOW() - INTERVAL '24' HOUR
GROUP BY project
ORDER BY total_volume_usd DESC
LIMIT 10;