Query editor
WITH all_revenue AS (SELECT 'base' AS chain, CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0) AS tx_usdFROM base.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'ink', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM ink.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'unichain', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM unichain.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'optimism', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM optimism.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'linea', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM linea.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'abstract', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM abstract.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'worldchain', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM worldchain.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'zksync', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM zksync.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'zora', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM zora.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'scroll', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM scroll.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'hemi', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM hemi.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'blast', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM blast.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'mode', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM mode.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'taiko', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM taiko.traces t LEFT JOIN prices.day p ON p.symbol='WETH' AND p.blockchain='ethereum' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'sonic', CAST(t.value AS DOUBLE)/1e18 * COALESCE(p.price,0)FROM sonic.traces t LEFT JOIN prices.day p ON p.symbol='WS' AND p.blockchain='sonic' AND p.timestamp=date_trunc('day',t.block_time)WHERE t."to"=0x7500a83df2af99b2755c47b6b321a8217d876a85 AND t.value>UINT256 '0' AND t.block_time>=TIMESTAMP '2025-02-01' AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5