Query editor
WITH all_revenue AS (SELECT 'base' AS chain, date_trunc('day', t.block_time) AS day, 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'ink', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'unichain', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'optimism', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'linea', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'abstract', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'worldchain', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'zksync', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'zora', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'scroll', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'hemi', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'blast', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'mode', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'taiko', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5UNION ALLSELECT 'sonic', date_trunc('day', t.block_time), 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>=NOW()-INTERVAL '60' DAY AND t.success=true AND t.tx_success=true AND CAST(t.value AS DOUBLE)/1e18*COALESCE(p.price,0)<=0.5