Query editor
WITH solana_addresses (address) AS (VALUES(TRY_CAST('{{Address}}' AS VARCHAR))), dex_volume AS (SELECTDATE_TRUNC('day', tr.block_time) AS day,tr.block_time, tr.trader_id AS wallet, 'Sell' AS direction, tr.token_sold_mint_address as token_address, tr.token_sold_symbol as token_symbol, -tr.token_sold_amount AS trade_qty, tr.amount_usd, tr.amount_usd AS volume_usd, tr.amount_usd / tr.token_sold_amount AS tx_pxFROM dex_solana.trades trINNER JOIN solana_addresses sa ON tr.trader_id = sa.addressWHERE token_sold_mint_address <> 'So11111111111111111111111111111111111111112'UNION ALLSELECTDATE_TRUNC('day', tr.block_time) AS day, tr.block_time, tr.trader_id AS wallet, 'Buy' AS direction, tr.token_bought_mint_address as token_address, tr.token_bought_symbol as token_symbol, tr.token_bought_amount AS trade_qty, tr.amount_usd, -tr.amount_usd AS volume_usd, tr.amount_usd / tr.token_bought_amount AS tx_pxFROM dex_solana.trades trINNER JOIN solana_addresses sa ON tr.trader_id = sa.addressWHERE token_bought_mint_address <> 'So11111111111111111111111111111111111111112'ORDER BY block_time DESC, token_address DESC)SELECT day, direction ,SUM(amount_usd) AS volumeFROM dex_volumeWHERE block_time >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY day, direction-- ORDER BY day DESC, direction DESC