sum(total_addr) over (partition by wallet_name order by day) as cum_wallets

from

(SELECT authorizers[0] as user_addr,wallet_name, min(block_timestamp) as first_use

from

(SELECT *, case when payer = '0x18eb4ee6b3c026d2' then 'Dapper Wallet'

when payer = '0x55ad22f01ef568a1' then 'Blocto'

when payer = '0x1b65c33d7a352c61' then 'FanCraze Wallet'

when payer='0x1b65c33d7a352c61' then 'CricketMoments'

when payer='0x6f649aee955bef6d' then 'RCRDSHP'

when payer='0x18eb4ee6b3c026d2' then 'NBA TopShot'

when payer='0x94bb84386cfc3b5d' then 'Everbloom'

when payer='0x55ad22f01ef568a1' then 'Blocto'

when payer='0xecfad18ba9582d4f' then 'Joyride'

when payer='0x9b00972a3ecb364b' then 'Seussibles'

end as wallet_name

from flow.core.fact_transactions

where wallet_name is not NULL)

GROUP by 1, 2 )

GROUP by 1,2

-- LIMIT 100