freemartianDay 8 NFTs
Updated 2023-08-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with mints as (
select * from base.core.ez_nft_transfers
where nft_address in (
'0x0651996b6a6eebd1fc697e5735a2dca541bbe06b',
'0xbd52c54ab5116b1d9326352f742e6544ffdeb2cb',
'0x6ee6e88eb8ae143bb9b4b4b0a2269a080a45ef7e',
'0xb999ec5e57000540cbf821addbc69c37bf506f9f')
and event_type = 'mint')
select
case
when project_name != 'SS23' then project_name
when project_name = 'SS23' then 'Zorb On-chain Summer'
end as Quest_NFT,
count(distinct nft_to_address) as Unique_minters,
count(tx_hash) as Total_mints,
Total_mints * 0.000777 as Earnings
from mints
group by 1
Run a query to Download Data