Updated 2025-03-13
    with

    pricet as (
    select
    price as token_price_usd
    from
    base.price.ez_prices_hourly
    where
    token_address = '0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4'
    order by hour desc
    limit 1
    ),

    deposits as (
    select
    to_address as receiver,
    sum(amount) as volume
    from
    base.core.ez_token_transfers
    where
    contract_address = '0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4'
    group by 1
    ),

    withdraws as (
    select
    from_address as sender,
    sum(amount) as volume
    from
    base.core.ez_token_transfers
    where
    contract_address = '0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4'
    group by 1
    ),

    main as (
    QueryRunArchived: QueryRun has been archived