mlhUntitled Query
Updated 2022-11-03
9
1
2
3
4
5
6
7
8
›
⌄
select date_trunc('hour', BLOCK_TIMESTAMP) as time,
count(DISTINCT tx_hash) as mints,
count(DISTINCT NFT_TO_ADDRESS) as Minters,
sum(NFT_COUNT)
from ethereum.core.ez_nft_mints
where NFT_ADDRESS = lower ('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')
and EVENT_TYPE = 'nft_mint'
group by 1
Run a query to Download Data