nft_to_address,

sum(tx_fee) as fee_volume

from ethereum.core.ez_nft_mints

where block_timestamp::date >= '2023-04-21'

and nft_address = '0xf192502dc0a01728955a82a5b84631bf719c8ee2' --reepz

group by 1

qualify row_number() over (order by fee_volume desc) <=10)

buyer_address,

nft_address,

when nft_address = '0xfeffc0e5c9575576c1922978102afa2d803dc93f' then 'Garden Point: 1st issue'

when nft_address = '0xe70659b717112ac4e14284d0db2f5d5703df8e43' then 'Notable Pepes'

when nft_address = '0x31910cec7b3d1a8a40de7d4101d5e6292ac67287' then 'Pepe Open Editions by Matt Furie'

when nft_address = '0x74211ca76d4cdd26c143e8ffd74469a04ae4e43b' then 'POTHEADZ by Satoshi''s Mom'

when nft_address = '0x08549931c9766c7d7ae59d98cc08ee133fe3db12' then 'Sougen Genesis Collection'

when nft_address = '0x05da517b1bf9999b7762eaefa8372341a1a47559' then 'Keepers'

when nft_address = '0x7509fb53526396937ede6b26d4b2dc8e12e2c376' then 'WhosjiLabs NFT'

when nft_address = '0xe263bb4f5bb8afd6b6cf585209c3e1f9fa2f672c' then 'The Cultist Club'

when nft_address = '0x369443a0e62889646b338498d87316252bb5f8c7' then 'DeadDegens'

when nft_address = '0x5dee90ca7aea1df95075ea8b417bb497a36b3cf3' then 'Planet COCO'

when nft_address = '0x210727b13f631aeef8fc5f9db324efabcb235152' then 'Mamonono2022'

when nft_address = '0xabf66ca534f8a5081303e3873f0f4771c67b7b45' then 'The Walking Dead Official'

when nft_address = '0x2df6c8bf5b3f6caf79219526888474a1071ca4fc' then 'BLVCK HOLES'

else project_name

end as project_name,

count(nft_address) as n_of_nfts

from ethereum.core.ez_nft_sales

where buyer_address in

from minters)

and event_type = 'sale'