hrst79reg volume 1-9 march
    Updated 2025-04-01
    with tokens_tab as (
    select
    DISTINCT token_Address
    from ink.price.ez_prices_hourly

    UNION all
    SELECT
    *
    from values('0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee') as a (token_Address)
    ),

    price_tab as(
    select
    hour,
    token_address,
    symbol,
    price ,
    decimals as decimal
    from
    ink.price.ez_prices_hourly
    union all

    select
    hour,
    '0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' as token_Address,
    'ETH' as symbol,
    price,
    18 as decimal
    from
    ink.price.ez_prices_hourly
    where token_address = '0x4200000000000000000000000000000000000006'
    )
    ,

    tab1 as (
    select
    Last run: 22 days ago
    DATE
    VOLUME_USD
    CUM_VOLUME_USD
    1
    2025-03-04 00:00:00.000507870.4512077121049122.20870777
    2
    2025-03-02 00:00:00.000388881.839878095510606.432214067
    3
    2025-03-07 00:00:00.00038511.1977481931237753.88944055
    4
    2025-03-01 00:00:00.000121724.592335971121724.592335971
    5
    2025-03-05 00:00:00.00031955.2842287371081077.49293651
    6
    2025-03-06 00:00:00.000118165.198755851199242.69169236
    7
    2025-03-08 00:00:00.00025885.3245243941263639.21396494
    8
    2025-03-03 00:00:00.00030645.325285993541251.757500059
    8
    492B
    24s