alitaslimiHolders Overview
    Updated 2024-07-23
    with
    -------------------- Arbitrum --------------------
    arbitrum_receivers as (
    select
    to_address as address,
    project_name as name,
    sum(amount) as volume
    from
    arbitrum.core.ez_token_transfers transfers
    left join arbitrum.core.dim_labels labels on transfers.to_address = labels.address
    where
    block_timestamp::date < current_date
    and contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3'
    and to_address != '0x0000000000000000000000000000000000000000'
    group by
    to_address,
    name
    ),
    arbitrum_senders as (
    select
    from_address as address,
    project_name as name,
    sum(amount) as volume
    from
    arbitrum.core.ez_token_transfers transfers
    left join arbitrum.core.dim_labels labels on transfers.from_address = labels.address
    where
    block_timestamp::date < current_date
    and contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3'
    and from_address != '0x0000000000000000000000000000000000000000'
    group by
    from_address,
    name
    ),
    arbitrum_holders as (
    select
    QueryRunArchived: QueryRun has been archived