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 = 0x88800092ff476844f74dc2fc427974bbee2794aeAND "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 = 0x88800092ff476844f74dc2fc427974bbee2794aeAND "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" = 0x47cd7e91c3cbaaf266369fe8518345fc4fc12935and contract_address = 0x88800092ff476844f74dc2fc427974bbee2794aeUNION ALLSELECT