date_trunc(week,block_timestamp)::date as date ,

case when payer='0x55ad22f01ef568a1' then 'Blocto'

when payer='0xecfad18ba9582d4f' then 'Joyride'

when payer='0x1b65c33d7a352c61' then 'CricketMoments'

when payer='0x6f649aee955bef6d' then 'RCRDSHP'

when payer='0x18eb4ee6b3c026d2' then 'TopShot'

end as wallet_provider,

count(DISTINCT tx_id) as num_transactions,

sum (num_transactions) over (partition by wallet_provider order by date ) as cum_transactions ,

sum(EVENT_DATA:amount) as volume,

count (DISTINCT proposer) as num_wallets ,

sum (volume) over (partition by wallet_provider order by date) as cum_volume

from flow.core.fact_transactions

join flow.core.fact_events using (tx_id)

where TX_SUCCEEDED=true

and authorizers[0] != payer

and EVENT_TYPE='TokensWithdrawn'

group by 1,2 having wallet_provider is not NULL

order by num_transactions DESC