Query editor
WITHsupply AS (SELECTDay,contract_address,SUM(Daily) AS SupplyFROM(SELECTDATE_TRUNC('day', evt_block_time) AS Day,contract_address,SUM(value / POWER(10, 18)) AS DailyFROMerc20_ethereum.evt_TransferWHEREcontract_address = 0xADE00C28244d5CE17D72E40330B1c318cD12B7c3AND "from" = 0x0000000000000000000000000000000000000000GROUP BY1,2UNION ALLSELECTDATE_TRUNC('day', evt_block_time) AS Day,contract_address,- SUM(value / POWER(10, 18)) AS DailyFROMerc20_ethereum.evt_TransferWHEREcontract_address = 0xADE00C28244d5CE17D72E40330B1c318cD12B7c3AND "to" = 0x0000000000000000000000000000000000000000GROUP BY1,2)GROUP BY1,2),cum AS (SELECTDay,SUM(Supply) OVER (ORDER BYDay) AS TotalFROMSupply),Wallet AS (SELECTtr."from" AS address,- CAST(tr.value AS DOUBLE) / POWER(10, 18) AS amount,contract_addressFROMerc20_ethereum.evt_transfer trWHERE"from" = 0xb6456b57f03352be48bf101b46c1752a0813491aand contract_address = 0xADE00C28244d5CE17D72E40330B1c318cD12B7c3UNION ALLSELECT