freemartianOn-Chain Summer New Era ETH
Updated 2023-09-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from On-Chain Summer BtB Hourly @ https://flipsidecrypto.xyz/edit/queries/d8aa39bb-d071-485e-bd7a-064566de4ee7
-- forked from Bridge to Base NFT #1 quest Totals @ https://flipsidecrypto.xyz/edit/queries/b1903ab4-23a4-4c2d-b07a-d93fa3b0443b
with mints as (
select * from base.core.ez_nft_transfers
where nft_address = '0xc9cca8e570f81a7476760279b5b19cc1130b7580'
and event_type = 'mint')
select
date_trunc('hour', block_timestamp) as time,
count(distinct nft_to_address) as minters,
count(tx_hash) as mints
from mints
group by time
Run a query to Download Data