Query editor
WITH rave AS (SELECT * FROM (VALUES('bnb', 0x97693439ea2f0ecdeb9135881e49f354656a911c),('base', 0x1aa8fd5bcce2231c6100d55bf8b377cff33acfc3)) AS t(blockchain, token)),t AS (SELECTdate_add('minute', -(minute(d.block_time) % 5),date_trunc('minute', d.block_time)) AS bucket,d.blockchain, d.amount_usd,d.token_bought_address = r.token AS is_buyFROM dex.trades dJOIN rave rON d.blockchain = r.blockchainAND (d.token_bought_address = r.token OR d.token_sold_address = r.token)WHERE d.block_time >= TIMESTAMP '2026-04-01 00:00:00'AND d.block_time < TIMESTAMP '2026-05-01 00:00:00'),agg AS (SELECT bucket,SUM(amount_usd) AS volume_usd,SUM(IF(is_buy, amount_usd)) AS buy_usd,SUM(IF(blockchain = 'bnb', amount_usd)) AS bsc_usd,SUM(IF(blockchain = 'base', amount_usd)) AS base_usd,COUNT(*) AS tradesFROM tGROUP BY 1),buckets AS (SELECT b AS bucketFROM UNNEST(sequence(TIMESTAMP '2026-04-01 00:00:00',TIMESTAMP '2026-04-30 23:55:00',INTERVAL '5' MINUTE)) AS s(b))SELECTb.bucket,COALESCE(a.volume_usd, 0) AS volume_usd,COALESCE(a.buy_usd, 0) AS taker_buy_usd,a.buy_usd / NULLIF(a.volume_usd, 0) AS taker_buy_ratio,COALESCE(a.bsc_usd, 0) AS bsc_usd,COALESCE(a.base_usd, 0) AS base_usd,COALESCE(a.trades, 0) AS tradesFROM buckets bLEFT JOIN agg a ON a.bucket = b.bucketORDER BY 1