payer,

CASE WHEN payer = '0x18eb4ee6b3c026d2' THEN 'Dapper'

WHEN payer = '0xecfad18ba9582d4f' THEN 'Joyride'

WHEN payer = '0x55ad22f01ef568a1' THEN 'Blocto'

WHEN payer = '0x8234007b36f8113c' THEN 'Monsoon'

WHEN payer = '0x1b65c33d7a352c61' THEN 'CricketMoments'

WHEN payer = '0x6f649aee955bef6d' THEN 'RCRDSHP'

WHEN payer = '0x4bbff461fa8f6192' THEN 'Fantastec'

WHEN payer = '0x93615d25d14fa337' THEN 'ChainMonsters'

WHEN payer = '0x94bb84386cfc3b5d' THEN 'Everbloom'

WHEN payer = '0x39e42c67cc851cfb' THEN 'Lilico'

END AS "Payer",

COUNT(DISTINCT(x.proposer)) AS "Number of users",

COUNT(x.tx_id) AS "Number of transactions",

sum(EVENT_DATA:amount) AS Volume,

sum("Number of transactions") over (partition BY "Payer" ORDER BY date) AS "Cumulative number of transactions"

FROM flow.core.fact_transactions x JOIN flow.core.fact_events y ON x.tx_id = y.tx_id

WHERE x.TX_SUCCEEDED = 'TRUE'

AND y.event_type = 'TokensWithdrawn'

AND (payer = '0x18eb4ee6b3c026d2'

OR payer = '0xecfad18ba9582d4f'

OR payer = '0x55ad22f01ef568a1'

OR payer = '0x8234007b36f8113c'

OR payer = '0x1b65c33d7a352c61'

OR payer = '0x6f649aee955bef6d'

OR payer = '0x4bbff461fa8f6192'

OR payer = '0x93615d25d14fa337'

OR payer = '0x94bb84386cfc3b5d'

OR payer = '0x39e42c67cc851cfb')

AND x.block_timestamp >= '2023-01-01'

GROUP BY 1, 2, 3

ORDER BY 1 ASC, 2