Query editor
WITH week_dates AS (SELECT CAST(week_date AS timestamp) AS weekFROM UNNEST(SEQUENCE(CAST(DATE_TRUNC('week', DATE '2023-01-01') AS date),CAST(DATE_TRUNC('week', CURRENT_DATE) AS date),INTERVAL '7' DAY)) AS t(week_date)),chains AS (SELECT 'Solana' AS chainUNION ALL SELECT 'Arbitrum'UNION ALL SELECT 'Base'UNION ALL SELECT 'Ethereum'),/* 1. Calculate only native token volume per week, no USD yet */volume_native AS (-- SolanaSELECTDATE_TRUNC('week', tr.block_time) AS week,'Solana' AS chain,SUM(tr.amount / POWER(10, 6)) AS transfer_volume_nativeFROM tokens_solana.transfers trWHERE tr.token_mint_address = 'myrcAs6bpP2g5oGHZ3qpgrfZQAFkbo9KUHdqYDXMjGv'AND tr.block_time >= TIMESTAMP '2023-01-01'AND tr.action NOT IN ('mint', 'burn')GROUP BY 1, 2UNION ALL-- ArbitrumSELECTDATE_TRUNC('week', t.evt_block_time) AS week,'Arbitrum' AS chain,SUM(t.value / POWER(10, 18)) AS transfer_volume_nativeFROM erc20_arbitrum.evt_transfer tWHERE t.contract_address = 0x3ed03e95dd894235090b3d4a49e0c3239edce59eAND t.evt_block_time >= TIMESTAMP '2023-01-01'AND t."from" <> 0x0000000000000000000000000000000000000000AND t."to" <> 0x0000000000000000000000000000000000000000GROUP BY 1, 2UNION ALL-- BaseSELECTDATE_TRUNC('week', t.evt_block_time) AS week,'Base' AS chain,SUM(t.value / POWER(10, 18)) AS transfer_volume_nativeFROM erc20_base.evt_transfer tWHERE t.contract_address = 0x3ed03e95dd894235090b3d4a49e0c3239edce59eAND t.evt_block_time >= TIMESTAMP '2023-01-01'AND t."from" <> 0x0000000000000000000000000000000000000000AND t."to" <> 0x0000000000000000000000000000000000000000GROUP BY 1, 2