zakkisyedPre-Merge: Daily average - New contracts created
    Updated 2023-05-11

    select avg(contracts_created)
    from

    (
    select count(*) as contracts_created, date_trunc(day,block_timestamp) as dt
    from
    (
    select *
    from ethereum.core.fact_traces
    where block_number < 15537393

    )

    where type = 'CREATE'
    or type = 'CREATE2'
    group by 2
    order by 1 desc
    )
    Run a query to Download Data