Query editor
WITHdetails as (select0x18084fba666a33d37592fa2633fd49a74dd93a88 as token,18 as dec),multiplier AS (SELECTdecimals as decFROMtokens.erc20,detailsWHEREcontract_address = token),transfers AS (SELECTDAY,address,token_address,sum(amount) AS amountFROM(SELECTdate_trunc('day', evt_block_time) AS DAY,to AS address,tr.contract_address AS token_address,cast(value as int256) AS amountFROMerc20_ethereum.evt_Transfer tr,detailsWHEREcontract_address = tokenUNION ALLSELECTdate_trunc('day', evt_block_time) AS DAY,"from" AS address,tr.contract_address AS token_address,- cast(value as INT256) AS amountFROMerc20_ethereum.evt_Transfer tr,detailsWHEREcontract_address = token) as tGROUP BY1,2,3),balances_with_gap_days AS (SELECTt.day as day,address,SUM(amount) OVER (PARTITION BYaddressORDER BYt.day asc) AS balance,