banbannardQuix analysis
Updated 2023-04-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date_trunc('hour', block_timestamp) as hour,
count(distinct(tx_hash)) as mint_count,
count(distinct(event_inputs:to)) as minter_count,
sum(mint_count) over (order by hour) as cumulative_mint_count,
sum(minter_count) over (order by hour) as cumulative_minter_count
from optimism.core.fact_event_logs
where contract_address = '0x0110bb5739a6f82eafc748418e572fc67d854a0f'
and event_inputs:from = '0x0000000000000000000000000000000000000000'
and tx_status = 'SUCCESS'
group by 1
order by 1 desc
Run a query to Download Data