flipside

    Top 100 users
    Afonso_DiazTop 100 users
    Updated 2025-01-19
    with

    main as (
    select
    tx_id,
    block_timestamp,
    signers[0] as user,
    from
    eclipse.core.fact_transactions
    where
    succeeded

    )

    select
    user,
    count(distinct tx_id) as transactions,
    from
    main
    group by 1
    order by 2 desc
    limit 100

    QueryRunArchived: QueryRun has been archived