(select

dateadd(

day,

'-' || row_number() over (order by null),

dateadd(day, '+1', current_date())

) as date

from table (generator(rowcount => 500))

),

data_with_gap as

(select datetime,

user,

balance,

lead(datetime,1,current_date) over (partition by user order by datetime) as next_day

(select date(BLOCK_TIMESTAMP) as datetime,

user,

sum(sum(amt)) over (partition by user order by date(BLOCK_TIMESTAMP)) as balance

from

(select BLOCK_TIMESTAMP,

FROM_ADDRESS as user,

-AMOUNT as amt

from bsc.core.ez_token_transfers

where contract_address = lower('0x4aae823a6a0b376De6A78e74eCC5b079d38cBCf7')

union all

select BLOCK_TIMESTAMP,

TO_ADDRESS,

AMOUNT

from bsc.core.ez_token_transfers

where contract_address = lower('0x4aae823a6a0b376De6A78e74eCC5b079d38cBCf7'))

group by 1,2)

where user != '0x0000000000000000000000000000000000000000'

having balance > 0),

prices as (