alitaslimiAvalanche Protocols Transfers
    Updated 1 hour ago
    select
    block_timestamp::date as "Date",
    project_name as "Label",
    count(distinct tx_hash) as "Transfers",
    count(distinct origin_from_address) as "Receivers",
    sum(decoded_log:value) / pow(10, 6) as "Volume"
    from
    avalanche.core.ez_decoded_event_logs logs
    join avalanche.core.dim_labels labels on logs.origin_to_address = labels.address
    where
    block_timestamp::date between (current_date - 31) and (current_date - 1)
    and contract_address = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'
    and decoded_log:from != '0x0000000000000000000000000000000000000000'
    and decoded_log:to != '0x0000000000000000000000000000000000000000'
    and event_name = 'Transfer'
    group by
    "Date",
    "Label"
    qualify
    row_number() over (partition by "Date" order by "Volume" desc) <= 3
    order by
    "Date" desc,
    "Volume" desc
    Last run: about 1 hour agoAuto-refreshes every 6 hours
    Date
    Label
    Transfers
    Receivers
    Volume
    1
    2025-03-17 00:00:00.000circle7718422910.535566
    2
    2025-03-17 00:00:00.000odos16760836.46925
    3
    2025-03-17 00:00:00.000trader joe22321108.087764
    4
    2025-03-16 00:00:00.000okx219083.85456
    5
    2025-03-16 00:00:00.000dexalot114597.654243
    6
    2025-03-16 00:00:00.000odos333009.358039
    7
    2025-03-15 00:00:00.000odos624072.439454
    8
    2025-03-15 00:00:00.000circle8783546.89
    9
    2025-03-15 00:00:00.000trader joe211894.478012
    10
    2025-03-14 00:00:00.000circle10430242588.078331
    11
    2025-03-14 00:00:00.000dexalot32128159.131441
    12
    2025-03-14 00:00:00.000odos18788965.441147
    13
    2025-03-13 00:00:00.000odos299901054.790962
    14
    2025-03-13 00:00:00.000circle8515449125.68
    15
    2025-03-13 00:00:00.000dexalot62222363.911645
    16
    2025-03-12 00:00:00.000odos205467306.870657
    17
    2025-03-12 00:00:00.000circle6416230832.230576
    18
    2025-03-12 00:00:00.000dexalot4289399.470584
    19
    2025-03-11 00:00:00.000odos6711483762.02096
    20
    2025-03-11 00:00:00.000dexalot123188547.68441
    92
    5KB
    8s