flipside

    $Near and $Blackdragon
    feyikemi$Near and $Blackdragon
    Updated 2025-03-23
    WITH Prices AS (
    SELECT
    DATE_TRUNC('hour', Hour) AS Date,
    AVG(CASE WHEN token_address = 'blackdragon.tkn.near' THEN Price END) AS BlackDragon_Price,
    AVG(CASE WHEN symbol ilike 'Near' THEN Price END) AS Near_price
    FROM
    near.price.ez_prices_hourly
    -- WHERE Hour::Date >= '2024-02-26'
    GROUP BY DATE
    )

    SELECT
    Date,
    BlackDragon_Price,
    Near_price
    FROM
    Prices
    WHERE BlackDragon_price IS NOT NULL
    AND Near_price IS NOT NULL
    ORDER BY
    Date DESC

    Last run: 2 months ago
    DATE
    BLACKDRAGON_PRICE
    NEAR_PRICE
    1
    		2025-03-23 21:00:00.0001.9628e-82.74
    2
    		2025-03-23 20:00:00.0001.9224e-82.73
    3
    		2025-03-23 19:00:00.0001.9183e-82.73
    4
    		2025-03-23 18:00:00.0001.9532e-82.75
    5
    		2025-03-23 17:00:00.0001.9556e-82.76
    6
    		2025-03-23 16:00:00.0001.9945e-82.76
    7
    		2025-03-23 15:00:00.0001.976e-82.78
    8
    		2025-03-23 14:00:00.0001.9587e-82.77
    9
    		2025-03-23 13:00:00.0001.9268e-82.77
    10
    		2025-03-23 12:00:00.0001.9461e-82.78
    11
    		2025-03-23 11:00:00.0001.9725e-82.78
    12
    		2025-03-23 10:00:00.0001.9692e-82.78
    13
    		2025-03-23 09:00:00.0001.9673e-82.79
    14
    		2025-03-23 08:00:00.0001.9663e-82.79
    15
    		2025-03-23 07:00:00.0001.9672e-82.78
    16
    		2025-03-23 06:00:00.0001.9623e-82.77
    17
    		2025-03-23 05:00:00.0001.9591e-82.79
    18
    		2025-03-23 04:00:00.0001.9381e-82.77
    19
    		2025-03-23 03:00:00.0001.934e-82.76
    20
    		2025-03-23 02:00:00.0001.9357e-82.74
    ...
    9397
    425KB
    5s