alitaslimiAvalanche | List of BTC.b Top Holders
    Updated 2025-03-04
    with
    transfers as (
    select
    to_address as address,
    sum(amount) as volume
    from
    avalanche.core.ez_token_transfers
    where
    contract_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'
    group by
    address
    union all
    select
    from_address as address,
    -sum(amount) as volume
    from
    avalanche.core.ez_token_transfers
    where
    contract_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'
    group by
    address
    )
    select
    transfers.address as "Address",
    labels.project_name as "Label",
    sum(transfers.volume) as "Balance"
    from
    transfers
    left join avalanche.core.dim_labels labels on transfers.address = labels.address
    where
    transfers.address != '0x0000000000000000000000000000000000000000'
    group by
    "Address",
    "Label"
    having
    "Balance" > 0
    Last run: 11 days agoAuto-refreshes every 12 hours
    Address
    Label
    Balance
    1
    0x8ffdf2de812095b1d19cb146e4c004587c0a0692aave3087.02016116
    2
    0x89a415b3d20098e6a6c8f7a59001c67bd3129821benqi finance839.12534219
    3
    0x9ab2de34a33fb459b538c43f251eb825645e8595gmx307.5613208
    4
    0x4bb7f4c3d47c4b431cb0658f44287d52006fb50661.7233282
    5
    0x3ce7bcdb37bf587d1c17b930fa0a7000a0648d1250.32528223
    6
    0xe0ab5950124e083f9b6786e1ec207215cc4955d240.09644547
    7
    0x2297aebd383787a160dd0d9f71508148769342e3layerzero26.19736367
    8
    0x55c211bbe9f63059a4a5a5e0c558c7e410412d98trader22.16885315
    9
    0xa03bb24bf4b761a9478606296c9c7b318ce0aece17
    10
    0x4382e9fee6222922541661fbc54bc4a670e64cbc15.53883118
    11
    0x945e0cf79de586244b97fa229cb8188993d9be1013.5984384
    12
    0xa465900f5eb9aacdbac1b956fd7045d02b4370d413.23171829
    13
    0xe20a21b450ed2adac39d64ae14bd4e5c74511f4c13.00404925
    14
    0x709a7818770470f2abc6532b28ef26151f3cfa6ctrader12.3801301
    15
    0x82e8936b187d83fd6eb2b7dab5b19556e9deff1c11.7470465
    16
    0xfb02132333a79c8b5bd0b64e3abcca5f7faf293711.2036739
    17
    0x0b1f9c2211f77ec3fa2719671c5646cf6e59b77510.96333859
    18
    0x1322c309c9a24b672c6da5bd75b99c76a3a749bb10.62102519
    19
    0xf3371c838c0afe0a09ff928339c85d4c2320407010.5571189
    20
    0x8147a84ad9b3b9a05cfc45681ab54378b449de2210.55251903
    100
    6KB
    17s