AS (SELECT CASE

WHEN payer = '0xecfad18ba9582d4f' THEN 'JoyRide'

WHEN payer = '0x18eb4ee6b3c026d2' THEN

'Dapper'

WHEN payer = '0x55ad22f01ef568a1' THEN 'Blocto'

WHEN payer = '0x1b65c33d7a352c61' THEN 'Cricket Moments'

WHEN payer = '0x6f649aee955bef6d' THEN 'RCRDSHP'

WHEN payer = '0x94bb84386cfc3b5d' THEN 'Everbloom'

WHEN payer = '0x9b00972a3ecb364b' THEN 'Seussibles'

WHEN payer = '0x93615d25d14fa337' THEN 'ChainMonsters'

WHEN payer = '0x8234007b36f8113c' THEN 'Monsoon'

WHEN payer = '0x4bbff461fa8f6192' THEN 'Fantastec'

WHEN payer = '0x39e42c67cc851cfb' THEN 'lilico'

END AS wallet_type,

proposer

FROM flow.core.fact_transactions v

JOIN flow.core.fact_events n

ON v.tx_id = n.tx_id

WHERE event_type = 'TokensWithdrawn'

AND v.tx_succeeded = 'TRUE'

AND v.block_timestamp >= CURRENT_DATE - 90

GROUP BY 1,

2

HAVING wallet_type IS NOT NULL)

SELECT Date_trunc('day', v.block_timestamp) AS date,

wallet_type,

Count (DISTINCT tx_id) AS tx,

Count (DISTINCT buyer) AS buyers,

tx / buyers AS avg_buyer,

Sum(tx)

OVER (

partition BY wallet_type

ORDER BY date) AS cum_tx,

Sum(buyers)

OVER (