zakkisyedPre-Merge: Count of Smart Contracts
    Updated 2023-06-14

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

    )

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