datavortexPrice 2
    Updated 2024-09-11


    SELECT
    date_trunc('day', hour) AS day,
    symbol,
    price AS close_price
    FROM
    solana.price.ez_prices_hourly
    WHERE
    symbol = '{{token2}}'
    AND EXTRACT(hour FROM hour) = 23
    AND hour BETWEEN '{{start_date2}}' AND '{{end_date2}}'
    GROUP BY
    date_trunc('day', hour),
    symbol,
    price
    ORDER BY
    day;

    Last run: about 1 month ago
    DAY
    SYMBOL
    CLOSE_PRICE
    1
    2024-08-01 00:00:00.000USDT0.999186
    2
    2024-08-02 00:00:00.000USDT0.998736
    3
    2024-08-03 00:00:00.000USDT0.999328
    4
    2024-08-04 00:00:00.000USDT0.999348
    5
    2024-08-05 00:00:00.000USDT0.999549
    6
    2024-08-06 00:00:00.000USDT1
    7
    2024-08-07 00:00:00.000USDT0.999095
    8
    2024-08-08 00:00:00.000USDT1
    9
    2024-08-09 00:00:00.000USDT1.001
    10
    2024-08-10 00:00:00.000USDT1.001
    11
    2024-08-11 00:00:00.000USDT0.999145
    12
    2024-08-12 00:00:00.000USDT0.999735
    13
    2024-08-13 00:00:00.000USDT0.999831
    14
    2024-08-14 00:00:00.000USDT1
    15
    2024-08-15 00:00:00.000USDT1.001
    16
    2024-08-16 00:00:00.000USDT0.999703
    17
    2024-08-17 00:00:00.000USDT1
    18
    2024-08-18 00:00:00.000USDT0.99971
    19
    2024-08-19 00:00:00.000USDT1
    20
    2024-08-20 00:00:00.000USDT1
    29
    1KB
    1s