RayyykL2StateOfMind 2
    Updated 2022-09-02
    with table_1 as (select date_trunc('hour', block_timestamp) as hour,
    count(distinct(event_inputs:tokenId)) as nft_minted,
    sum(nft_minted) over (order by hour) as cumu_nft_minted,
    count(distinct(origin_from_address)) as wallets_minted,
    sum(wallets_minted) over (order by hour) as cumu_wallets_minted
    from optimism.core.fact_event_logs
    where contract_address ilike '0x66Deb6cC4d65dc9CB02875DC5E8751d71Fa5D50E'
    and tx_status = 'SUCCESS'
    and event_name = 'Transfer'
    group by 1)

    select hour,
    nft_minted,
    cumu_nft_minted,
    wallets_minted,
    cumu_wallets_minted,
    (select sum(nft_minted) from table_1) as nft,
    (select sum(wallets_minted) from table_1) as wallet,
    nft/wallet as avg
    from table_1
    order by 1 desc
    Run a query to Download Data