ramishoowUntitled Query
    Updated 2022-10-20
    with ramishow as (select date_trunc('hour', block_timestamp) as hour,
    count(distinct(tx_hash)) as mint_count,
    sum(mint_count) over (order by hour) as cumu_mint_count
    from optimism.core.fact_event_logs
    where block_timestamp >= '2022-09-22'
    and event_inputs:from = '0x0000000000000000000000000000000000000000'
    and contract_address = '0xac3b9b3f5956b52c448158c0a07ddfa9d5c53a3b'
    group by 1)

    select hour,
    mint_count,
    cumu_mint_count,
    (select sum(mint_count) from ramishow) as total_minted,
    (total_minted / 25000) * 100 as mint_percentage
    from ramishow
    order by 1 desc
    Run a query to Download Data