maybeyonasmoonbird_mint_dist
Updated 2022-04-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with
moon_mints as (
select
block_timestamp,
tx_hash,
event_inputs:to::string as user,
event_inputs:tokenId::string as token
from ethereum_core.fact_event_logs
where contract_address = '0x23581767a106ae21c074b2276d25e5c3e136a68b'
and event_name = 'Transfer'
and event_inputs:from::string = '0x0000000000000000000000000000000000000000'
)
select
block_timestamp,
count(token) as mints
from moon_mints
group by 1
Run a query to Download Data