Query editor
WITH all_deposits AS (-- EthereumSELECT'ethereum' AS blockchain,DATE(tr.evt_block_time) AS date,tr.contract_address AS token_address,tok.symbol,SUM(CAST(tr.value AS DECIMAL(38, 0)) / POW(10, tok.decimals)) AS token_amount,SUM(CAST(tr.value AS DECIMAL(38, 0)) * pr.price / POW(10, tok.decimals)) AS amount_usd,COUNT(DISTINCT tr.evt_tx_hash) AS tx_countFROM erc20_ethereum.evt_transfer trLEFT JOIN tokens.erc20 tokON tok.contract_address = tr.contract_addressAND tok.blockchain = 'ethereum'LEFT JOIN prices.usd prON pr.contract_address = tr.contract_addressAND pr.blockchain = 'ethereum'AND DATE_TRUNC('minute', tr.evt_block_time) = pr.minuteWHERE tr."to" = 0xFA7093CDD9EE6932B4eb2c9e1cde7CE00B1FA4b9AND tr.evt_block_time >= CURRENT_DATE - INTERVAL '24' MONTHGROUP BY 1, 2, 3, 4UNION ALL-- PolygonSELECT'polygon' AS blockchain,DATE(tr.evt_block_time) AS date,tr.contract_address AS token_address,tok.symbol,SUM(CAST(tr.value AS DECIMAL(38, 0)) / POW(10, tok.decimals)) AS token_amount,SUM(CAST(tr.value AS DECIMAL(38, 0)) * pr.price / POW(10, tok.decimals)) AS amount_usd,COUNT(DISTINCT tr.evt_tx_hash) AS tx_countFROM erc20_polygon.evt_transfer trLEFT JOIN tokens.erc20 tokON tok.contract_address = tr.contract_addressAND tok.blockchain = 'polygon'LEFT JOIN prices.usd prON pr.contract_address = tr.contract_addressAND pr.blockchain = 'polygon'AND DATE_TRUNC('minute', tr.evt_block_time) = pr.minuteWHERE tr."to" = 0x19B620929f97b7b990801496c3b361CA5dEf8C71AND tr.evt_block_time >= CURRENT_DATE - INTERVAL '24' MONTHGROUP BY 1, 2, 3, 4UNION ALL-- ArbitrumSELECT'arbitrum' AS blockchain,DATE(tr.evt_block_time) AS date,tr.contract_address AS token_address,tok.symbol,SUM(CAST(tr.value AS DECIMAL(38, 0)) / POW(10, tok.decimals)) AS token_amount,SUM(CAST(tr.value AS DECIMAL(38, 0)) * pr.price / POW(10, tok.decimals)) AS amount_usd,COUNT(DISTINCT tr.evt_tx_hash) AS tx_countFROM erc20_arbitrum.evt_transfer trLEFT JOIN tokens.erc20 tokON tok.contract_address = tr.contract_address