Afonso_DiazOvertime
    Updated 2025-04-03
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address as user,
    contract_address
    from
    boba.core.fact_event_logs
    )

    select
    date_trunc('month', block_timestamp) as date,
    count(distinct contract_address) as contracts,
    count(distinct tx_hash) as transactions,
    sum(transactions) over (order by date) as cumulative_transactions
    from
    main
    group by 1
    order by 1

    QueryRunArchived: QueryRun has been archived