adambalaPP
Updated 2022-06-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
date( block_timestamp )as date,
count(distinct nft_to_address) as minters,
sum(mint_price_eth) as mint_volume_eth,
sum(mint_price_usd) as mint_volume_usd,
case when nft_address = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' then 'Supporter Token -- Pooly 1'
when nft_address = '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' then 'Lawyer Token -- Pooly 2'
when nft_address = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' then 'JUDGE Token -- Pooly 3'
end as nft_type,
count(nft_count) as nft
from ethereum.core.ez_nft_mints
where nft_address = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' or nft_address ='0x3545192b340f50d77403dc0a64cf2b32f03d00a9' or nft_address ='0x5663e3e096f1743e77b8f71b5de0cf9dfd058523'
and nft_from_address = '0x0000000000000000000000000000000000000000'
and event_type = 'nft_mint'
group by date ,nft_type
Run a query to Download Data