Query editor
WITH drops AS (SELECT 'ethereum' AS chain, block_date, value/1e18 AS amt FROM ethereum.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'arbitrum', block_date, value/1e18 FROM arbitrum.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'optimism', block_date, value/1e18 FROM optimism.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'base', block_date, value/1e18 FROM base.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'bnb', block_date, value/1e18 FROM bnb.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'opbnb', block_date, value/1e18 FROM opbnb.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'polygon', block_date, value/1e18 FROM polygon.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'avalanche_c', block_date, value/1e18 FROM avalanche_c.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'zksync', block_date, value/1e18 FROM zksync.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'linea', block_date, value/1e18 FROM linea.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'scroll', block_date, value/1e18 FROM scroll.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'mantle', block_date, value/1e18 FROM mantle.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'blast', CAST(DATE_TRUNC('day', block_time) AS date), value/1e18 FROM blast.traces WHERE block_time >= CURRENT_TIMESTAMP - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'taiko', block_date, value/1e18 FROM taiko.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'sei', block_date, value/1e18 FROM sei.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'abstract', block_date, value/1e18 FROM abstract.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'berachain', block_date, value/1e18 FROM berachain.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'unichain', block_date, value/1e18 FROM unichain.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'sonic', block_date, value/1e18 FROM sonic.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'celo', block_date, value/1e18 FROM celo.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'cronos', block_date, value/1e18 FROM cronos.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'bob', block_date, value/1e18 FROM bob.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'ink', block_date, value/1e18 FROM ink.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'nova', block_date, value/1e18 FROM nova.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'katana', block_date, value/1e18 FROM katana.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'gnosis', block_date, value/1e18 FROM gnosis.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'hyperevm', block_date, value/1e18 FROM hyperevm.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'ronin', block_date, value/1e18 FROM ronin.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'plume', block_date, value/1e18 FROM plume.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'flare', block_date, value/1e18 FROM flare.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'morph', block_date, value/1e18 FROM morph.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'mode', block_date, value/1e18 FROM mode.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'boba', block_date, value/1e18 FROM boba.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'viction', block_date, value/1e18 FROM viction.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'worldchain', block_date, value/1e18 FROM worldchain.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'apechain', block_date, value/1e18 FROM apechain.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'kaia', block_date, value/1e18 FROM kaia.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'UNION ALL SELECT 'zkevm', block_date, value/1e18 FROM zkevm.traces WHERE block_date >= CURRENT_DATE - INTERVAL '90' DAY AND "from" = 0x2a37D63EAdFe4b4682a3c28C1c2cD4F109Cc2762 AND value > 0 AND success = true AND call_type = 'call'),chain_symbols AS (SELECT 'ethereum' AS chain, 'ETH' AS symbol UNION ALL SELECT 'arbitrum', 'ETH' UNION ALL SELECT 'optimism', 'ETH' UNION ALLSELECT 'base', 'ETH' UNION ALL SELECT 'scroll', 'ETH' UNION ALL SELECT 'linea', 'ETH' UNION ALLSELECT 'zksync', 'ETH' UNION ALL SELECT 'blast', 'ETH' UNION ALL SELECT 'taiko', 'ETH' UNION ALLSELECT 'abstract', 'ETH' UNION ALL SELECT 'unichain', 'ETH' UNION ALL SELECT 'bob', 'ETH' UNION ALLSELECT 'ink', 'ETH' UNION ALL SELECT 'nova', 'ETH' UNION ALL SELECT 'zkevm', 'ETH' UNION ALLSELECT 'katana', 'ETH' UNION ALL SELECT 'morph', 'ETH' UNION ALL SELECT 'mode', 'ETH' UNION ALLSELECT 'boba', 'ETH' UNION ALL SELECT 'worldchain','ETH' UNION ALL SELECT 'flare', 'FLR' UNION ALLSELECT 'bnb', 'BNB' UNION ALL SELECT 'opbnb', 'BNB' UNION ALL SELECT 'polygon', 'POL' UNION ALLSELECT 'avalanche_c','AVAX' UNION ALL SELECT 'gnosis', 'XDAI' UNION ALL SELECT 'mantle', 'MNT' UNION ALLSELECT 'sei', 'SEI' UNION ALL SELECT 'berachain', 'BERA' UNION ALL SELECT 'sonic', 'S' UNION ALLSELECT 'celo', 'CELO' UNION ALL SELECT 'cronos', 'CRO' UNION ALL SELECT 'hyperevm', 'HYPE' UNION ALLSELECT 'ronin', 'RON' UNION ALL SELECT 'plume', 'PLUME' UNION ALL SELECT 'viction', 'VIC' UNION ALLSELECT 'apechain', 'APE' UNION ALL SELECT 'kaia', 'KAIA'),native_prices AS (SELECT p.blockchain AS chain, DATE_TRUNC('day', p.timestamp) AS day, AVG(p.price) AS priceFROM prices.day p