gigiokobaintegrated-scarlet
    Updated 2025-02-09
    WITH price_data AS (
    SELECT
    PRICE,
    HOUR,
    TOKEN_ADDRESS
    FROM avalanche.price.ez_prices_hourly
    WHERE TOKEN_ADDRESS = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
    ORDER BY HOUR DESC
    LIMIT 1
    ),
    one_hour_ago AS (
    SELECT
    PRICE AS price_one_hour_ago
    FROM avalanche.price.ez_prices_hourly
    WHERE TOKEN_ADDRESS = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
    AND HOUR = DATEADD(hour, -1, (SELECT MAX(HOUR) FROM avalanche.price.ez_prices_hourly WHERE TOKEN_ADDRESS = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'))
    LIMIT 1
    ),
    twenty_four_hours_ago AS (
    SELECT
    PRICE AS price_24_hours_ago
    FROM avalanche.price.ez_prices_hourly
    WHERE TOKEN_ADDRESS = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
    AND HOUR = DATEADD(hour, -24, (SELECT MAX(HOUR) FROM avalanche.price.ez_prices_hourly WHERE TOKEN_ADDRESS = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'))
    LIMIT 1
    ),
    seven_days_ago AS (
    SELECT
    PRICE AS price_7_days_ago
    FROM avalanche.price.ez_prices_hourly
    WHERE TOKEN_ADDRESS = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
    AND HOUR = DATEADD(day, -7, (SELECT MAX(HOUR) FROM avalanche.price.ez_prices_hourly WHERE TOKEN_ADDRESS = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'))
    LIMIT 1
    ),
    fourteen_days_ago AS (
    SELECT
    Last run: 14 days ago
    CURRENT_PRICE
    PRICE_ONE_HOUR_AGO
    PRICE_24_HOURS_AGO
    PRICE_7_DAYS_AGO
    PRICE_14_DAYS_AGO
    PRICE_30_DAYS_AGO
    PERCENT_CHANGE_1_HOUR
    PERCENT_CHANGE_24_HOURS
    PERCENT_CHANGE_7_DAYS
    PERCENT_CHANGE_14_DAYS
    PERCENT_CHANGE_30_DAYS
    1
    347.33345.58331.9590.4497.78206.360.514.65-41.17-30.2268.31
    1
    73B
    3s