alitaslimiAvalanche Protocols Transfers
    Updated 6 hours 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 6 hours agoAuto-refreshes every 6 hours
    Date
    Label
    Transfers
    Receivers
    Volume
    1
    2025-03-14 00:00:00.000circle10430242588.078331
    2
    2025-03-14 00:00:00.000dexalot32128159.131441
    3
    2025-03-14 00:00:00.000odos18788965.441147
    4
    2025-03-13 00:00:00.000odos299901054.790962
    5
    2025-03-13 00:00:00.000circle8515449125.68
    6
    2025-03-13 00:00:00.000dexalot62222363.911645
    7
    2025-03-12 00:00:00.000odos205467306.870657
    8
    2025-03-12 00:00:00.000circle6416230832.230576
    9
    2025-03-12 00:00:00.000dexalot4289399.470584
    10
    2025-03-11 00:00:00.000odos6711483762.02096
    11
    2025-03-11 00:00:00.000dexalot123188547.68441
    12
    2025-03-11 00:00:00.000circle8822155744.868975
    13
    2025-03-10 00:00:00.000odos275436575.651947
    14
    2025-03-10 00:00:00.000circle8123393430.185953
    15
    2025-03-10 00:00:00.000dexalot5289774.43641
    16
    2025-03-09 00:00:00.000odos84178236.447778
    17
    2025-03-09 00:00:00.000kyberswap1192271.94552
    18
    2025-03-09 00:00:00.000dexalot2150999.316365
    19
    2025-03-08 00:00:00.000odos7556022.580536
    20
    2025-03-08 00:00:00.000dexalot3226833.654507
    92
    5KB
    8s