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_name,

a.proposer,

COUNT(DISTINCT(a.proposer)) AS n_users,

COUNT(a.tx_id) AS n_txs

FROM flow.core.fact_transactions a JOIN flow.core.fact_events b ON a.tx_id = b.tx_id

WHERE a.TX_SUCCEEDED = 'TRUE' AND (a.block_timestamp >= CURRENT_DATE - 30)

AND b.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')

GROUP BY 1, 2, 3, 4

ORDER BY 1 ASC, 2)

SELECT date_trunc('day', block_timestamp),

payer_name,

COUNT(tx_id) AS n_sales, COUNT(DISTINCT(buyer)) AS n_nft_buyers, COUNT(DISTINCT(nft_id)) AS n_nft_tokens, COUNT(DISTINCT(nft_collection)) AS n_nft_Col