alitaslimiArbitrum | List of BTC.b Top Holders
    Updated 2025-03-04
    with
    transfers as (
    select
    to_address as address,
    sum(amount) as volume
    from
    arbitrum.core.ez_token_transfers
    where
    contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3'
    group by
    address
    union all
    select
    from_address as address,
    -sum(amount) as volume
    from
    arbitrum.core.ez_token_transfers
    where
    contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3'
    group by
    address
    )
    select
    transfers.address as "Address",
    labels.project_name as "Label",
    sum(transfers.volume) as "Balance"
    from
    transfers
    left join arbitrum.core.dim_labels labels on transfers.address = labels.address
    where
    transfers.address != '0x0000000000000000000000000000000000000000'
    group by
    "Address",
    "Label"
    having
    "Balance" > 0
    Last run: 12 days agoAuto-refreshes every 12 hours
    Address
    Label
    Balance
    1
    0x6a08d518b9f51e20caceada238fc105cf20b84164.34624019
    2
    0x989252fe804c3c1b15908c364aa5cda7910300671.953014
    3
    0x13c1b28e38c6fd4621e2f913fb92b1ab6826a20c0.41539113
    4
    0xa5f2099b8113ad10367408cb49f4043cd1e92ea30.20055097
    5
    0xb7ef83fcae46d78bca4bba1f018343e5cdfc384a0.19407217
    6
    0xd873627e9f2c4ed425d833152327e6a8f3a49b950.17497759
    7
    0x7e1e2d9291e62770005522bfb9ecfc63888a41d20.15391356
    8
    0xd9d9502e723e504838e33d25e61724736a55d15c0.1419716
    9
    0x8fd4f5c4ceba008bfb7e3b5a9c1fadcaad5bd2d50.13174543
    10
    0x298c3f1f5dfebe925e1696a63127fefa31d83e2b0.11130336
    11
    0x5301b6a0cbcc34e1fd76c029018e05b824d069e10.1080457
    12
    0x52ee5c1b7530dae3989d067cb8d132ddea9ac66a0.10631584
    13
    0xdf4192c852511e386196aa10cb6ff634c93ee49f0.10168321
    14
    0xd21580bae6f0099cb002aacc1c9d461073c16ac10.09551691
    15
    0xcf2f020eeee1c1774c86ea70691913ae5e8affcbuniswap0.09515249
    16
    0xc7e3d5239c3592a5518fa49236d408bdd6c653560.09247449
    17
    0x7b141908ef72519619b7cfe895c30a9e14d96f7c0.09164214
    18
    0x71e5de9043403a1d49dc1ca307c7116dc07f0c3a0.08942135
    19
    0x2586c7029673dfe09c4a448975e4ece4eeafa4f40.08705678
    20
    0x8678f58ac6c4748b5289d0db70e627eef395dead0.07862636
    100
    6KB
    394s