Query editor
WITH bonk_tokens AS (SELECT DISTINCT account_arguments[7] AS token_mint_addressFROM solana.instruction_callsWHERE executing_account = 'LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj'AND (varbinary_starts_with(data, 0xafaf6d1f0d989bed)OR varbinary_starts_with(data, 0x4399af27))AND tx_success = TRUEAND account_arguments[4] IN ('FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1','BuM6KDpWiTcxvrpXywWFiw45R2RNH8WURdvqoTDV1BW4')),bonk_volume_old AS (SELECTDATE_TRUNC('week', block_time) AS dt,'bonk' AS category,SUM(amount_usd) AS volume_usdFROM dex_solana.tradesWHERE block_time >= DATE_ADD('week', -100, NOW())AND DATE_TRUNC('week', block_time) < DATE_TRUNC('week', DATE '2025-08-27')AND project = 'raydium_launchlab'AND (token_bought_mint_address IN (SELECT token_mint_address FROM bonk_tokens)OR token_sold_mint_address IN (SELECT token_mint_address FROM bonk_tokens))GROUP BY 1, 2),bonk_volume_new AS (SELECTDATE_TRUNC('week', block_time) AS dt,'bonk' AS category,SUM(volume_usd) AS volume_usdFROM query_5808441WHERE block_time >= DATE '2025-08-27'AND block_time >= DATE_ADD('week', -100, NOW())AND DATE_TRUNC('week', block_time) < DATE_TRUNC('week', NOW())GROUP BY 1, 2),bonk_volume AS (SELECT * FROM bonk_volume_oldUNION ALLSELECT * FROM bonk_volume_new),raydium_launchlab_volume AS (SELECTDATE_TRUNC('week', block_time) AS dt,'raydium_launchlab' AS category,SUM(amount_usd) AS volume_usdFROM dex_solana.tradesWHERE block_time >= DATE_ADD('week', -100, NOW())AND DATE_TRUNC('week', block_time) < DATE_TRUNC('week', NOW())AND project = 'raydium_launchlab'AND token_bought_mint_address NOT IN (SELECT token_mint_address FROM bonk_tokens)AND token_sold_mint_address NOT IN (SELECT token_mint_address FROM bonk_tokens)GROUP BY 1, 2),pumpdotfun_volume AS (SELECT