shreexTotal NFT Sales OF Collections
Updated 2022-09-02
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
case
when nft_address='0xb8df6cc3050cc02f967db1ee48330ba23276a492' then 'optipunks'
when nft_address='0x51e5426ede4e2d4c2586371372313b5782387222' then 'apetimism'
when nft_address='0x5c9d55b78febcc2061715ba4f57ecf8ea2711f2c' then 'motorheads' end as nft_collection,
count(*) as total_nft_sales
from optimism.core.ez_nft_sales where nft_address in ('0x51e5426ede4e2d4c2586371372313b5782387222','0xb8df6cc3050cc02f967db1ee48330ba23276a492','0x5c9d55b78febcc2061715ba4f57ecf8ea2711f2c')
GROUP BY nft_collection
Run a query to Download Data