Query editor
WITH evm AS (SELECTblock_date AS date,CASE WHEN blockchain = 'ethereum' THEN 'ethereum_l1' ELSE 'ethereum_l2' END AS chain,SUM(tx_fee_usd) AS fees_usdFROM gas.feesWHERE (blockchain = 'ethereum' AND block_date >= DATE '2018-01-01')OR (blockchain IN ('arbitrum', 'optimism', 'base', 'zksync', 'scroll', 'linea', 'blast', 'zora')AND block_date >= DATE '2018-01-01')GROUP BY 1, 2),sol AS (SELECTblock_date AS date,'solana' AS chain,SUM(tx_fee_usd) AS fees_usdFROM gas_solana.feesWHERE block_date >= DATE '2021-01-01'GROUP BY 1, 2)SELECT date, chain, SUM(fees_usd) AS fees_usdFROM (SELECT * FROM evmUNION ALL SELECT * FROM sol)GROUP BY 1, 2ORDER BY 1, 2