Mrftiprice
    Updated 2024-12-26
    -- forked from 2024-03-23 01:31 PM copy copy @ https://flipsidecrypto.xyz/studio/queries/805ffeee-bab8-4e3f-b40a-9e510133a6c8

    with SWELL_tbl as (
    select date_trunc (hour, hour) as date,
    avg(price) as "$SWELL price"
    from ethereum.price.ez_prices_hourly
    where token_address=lower ('0x0a6e7ba5042b38349e437ec6db6214aec7b35676')
    GROUP by 1
    order by 1
    ),

    eth_tbl as (
    select date_trunc (hour, hour) as date,
    avg(price) as "ETH price"
    from ethereum.price.ez_prices_hourly
    where token_address=lower ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')
    GROUP by 1
    order by 1)

    select a.date,
    "$SWELL price",
    "ETH price"
    from SWELL_tbl a join eth_tbl b on a.date = b.date
    order by 1


    Last run: 3 months agoAuto-refreshes every 12 hours
    DATE
    $SWELL price
    ETH price
    1
    2024-11-07 10:00:00.0000.032452282820.58
    2
    2024-11-07 11:00:00.0000.032340482825.85
    3
    2024-11-07 12:00:00.0000.029772082820.65
    4
    2024-11-07 13:00:00.0000.038049872810.12
    5
    2024-11-07 14:00:00.0000.035484822816.03
    6
    2024-11-07 15:00:00.0000.031065672814.49
    7
    2024-11-07 16:00:00.0000.030778242796.8
    8
    2024-11-07 17:00:00.0000.031550742844.06
    9
    2024-11-07 18:00:00.0000.030604762850.09
    10
    2024-11-07 19:00:00.0000.035223572863.07
    11
    2024-11-07 20:00:00.0000.033331182866.76
    12
    2024-11-07 21:00:00.0000.033535842879.13
    13
    2024-11-07 22:00:00.0000.034479972890.14
    14
    2024-11-07 23:00:00.0000.033897292897.3
    15
    2024-11-08 00:00:00.0000.035276692883.48
    16
    2024-11-08 01:00:00.0000.037338742894.89
    17
    2024-11-08 02:00:00.0000.035200872917.56
    18
    2024-11-08 03:00:00.0000.034573192913.21
    19
    2024-11-08 04:00:00.0000.036948322895.33
    20
    2024-11-08 05:00:00.0000.040223732901.18
    ...
    1181
    54KB
    5s