Query editor
WITH evm AS (SELECTdate_trunc('month', block_date) AS date,CASE WHEN blockchain = 'ethereum' THEN 'ethereum' ELSE 'other_l1' END AS chain,SUM(tx_fee_usd) AS fees_usdFROM gas.feesWHERE block_date >= DATE '2024-01-01'AND blockchain IN ('ethereum', 'bnb', 'avalanche_c', 'tron', 'polygon', 'fantom', 'gnosis', 'sei')GROUP BY 1, 2),apt AS (SELECTdate_trunc('month', block_date) AS date,'other_l1' AS chain,SUM(tx_fee_usd) AS fees_usdFROM gas_aptos.feesWHERE block_date >= DATE '2024-01-01'GROUP BY 1, 2),sol AS (SELECTdate_trunc('month', block_date) AS date,'solana' AS chain,SUM(tx_fee_usd) AS fees_usdFROM gas_solana.feesWHERE block_date >= DATE '2024-01-01'GROUP BY 1, 2)SELECT date, chain, SUM(fees_usd) AS fees_usdFROM (SELECT * FROM evmUNION ALL SELECT * FROM aptUNION ALL SELECT * FROM sol)GROUP BY 1, 2ORDER BY 1, 2