hrst79 by pair 1-15 feb
    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
    from
    ink.price.ez_prices_hourly
    union all

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

    Last run: 25 days ago
    DATE
    PAIR
    VOLUME_USD
    CUM_VOLUME_USD
    1
    2025-02-01 00:00:00.000PURPLE-USDC.E3902.93453902.9345
    2
    2025-02-03 00:00:00.000ETH-KRAKEN21.743263376461.527368518
    3
    2025-02-11 00:00:00.000ETH-USD₮09114.386717761140164.2971422
    4
    2025-02-03 00:00:00.000ETH-Other82554.664589259163049.087367338
    5
    2025-02-06 00:00:00.000ETH-USDC.E1460.654052782182812.972752574
    6
    2025-02-11 00:00:00.000USDC.E-USD₮07645.630693184779.733173
    7
    2025-02-04 00:00:00.000SQUIDS-WETH528.530466892528.530466892
    8
    2025-02-14 00:00:00.000Other-PURPLE8672.47459736719090.475508649
    9
    2025-02-12 00:00:00.000ETH-Other18163.323653205379102.669832417
    10
    2025-02-04 00:00:00.000USDC.E-USD₮02536.6688277957.706432
    11
    2025-02-06 00:00:00.000SHROOMY-USD₮01.09046412.57226673
    12
    2025-02-03 00:00:00.000PURPLE-USD₮03738.8745327833748.874532783
    13
    2025-02-07 00:00:00.000ETH-USDC.E25888.589582308208701.562334883
    14
    2025-02-03 00:00:00.000ETH-USD₮04784.652616339332.311420609
    15
    2025-02-02 00:00:00.000ETH-Other51485.77723794980494.422778078
    16
    2025-02-09 00:00:00.000PURPLE-USD₮0154131.524416783
    17
    2025-02-09 00:00:00.000Other-USDC.E2005.56849.436087803
    18
    2025-02-12 00:00:00.000Other-USD₮015.8589442233.528164622
    19
    2025-02-07 00:00:00.000Other-PURPLE224.9869537.508097152
    20
    2025-02-02 00:00:00.000Other-PURPLE184.698000502184.698000502
    ...
    276
    19KB
    52s