banbannardQuix analysis
    Updated 2023-04-13
    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