hrst79 by pair 1-16 feb
    Updated 2 days ago


    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: 1 day ago
    DATE
    PAIR
    VOLUME_USD
    CUM_VOLUME_USD
    1
    2025-02-06 00:00:00.000ETH-USDC.E1460.654052782182812.972752574
    2
    2025-02-11 00:00:00.000ETH-USD₮09114.386717761140164.2971422
    3
    2025-02-03 00:00:00.000ETH-Other82554.664589259163049.087367338
    4
    2025-02-11 00:00:00.000USDC.E-USD₮07645.630693184779.733173
    5
    2025-02-14 00:00:00.000Other-PURPLE8672.47459736719090.475508649
    6
    2025-02-04 00:00:00.000SQUIDS-WETH528.530466892528.530466892
    7
    2025-02-15 00:00:00.000CAT-Other
    8
    2025-02-07 00:00:00.000ETH-PURPLE34873.107625483573618.151414835
    9
    2025-02-08 00:00:00.000ETH-WETH8791.199378992262081.650576688
    10
    2025-02-12 00:00:00.000ETH-WETH4318.909727347280290.732713586
    11
    2025-02-09 00:00:00.000ETH-PURPLE18402.112766789614738.001240052
    12
    2025-02-13 00:00:00.000Other-PURPLE426.10895434710418.000911282
    13
    2025-02-15 00:00:00.000ETH-WETH12899.226420155340156.137793147
    14
    2025-02-15 00:00:00.000ETH-Other6003.976995538428211.166578066
    15
    2025-02-10 00:00:00.000ETH-Other4151.90435334310305.22889695
    16
    2025-02-08 00:00:00.000ETH-SQUIDS7239.94594102576152.491327445
    17
    2025-02-06 00:00:00.000KRAKEN-Other1.7291764911.729176491
    18
    2025-02-10 00:00:00.000ETH-USDC.E7518.429528757265000.718812604
    19
    2025-02-09 00:00:00.000ETH-SQUIDS6188.26082753282340.752154977
    20
    2025-02-12 00:00:00.000ETH-SHROOMY29868.695869756273279.047635756
    ...
    305
    21KB
    168s