flipside

    Top contracts
    Afonso_DiazTop contracts
    Updated 2025-01-15
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    contract_address
    from
    flow.core_evm.fact_event_logs
    )

    select
    contract_address,
    count(distinct tx_hash) as transactions
    from main
    group by 1
    order by 2 desc
    limit 10


    QueryRunArchived: QueryRun has been archived