Afonso_Diazlabels using sAVAX
    Updated 2025-02-03
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address as user,
    project_name,
    label_type
    from
    avalanche.core.fact_event_logs
    join
    avalanche.core.dim_labels on contract_address = address
    where
    tx_hash in (select distinct tx_hash from avalanche.core.ez_token_transfers where contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be')
    and label_type != 'token'
    and label_subtype != 'token_contract'
    )

    select
    label_type,
    count(distinct tx_hash) as transactions,
    count(distinct user) as users
    from
    main
    where
    block_timestamp between '{{ start_date }}' and '{{ end_date }}'
    group by 1
    order by 2 desc





    QueryRunArchived: QueryRun has been archived