flipside

    $TYBG: Prices
    i_dan$TYBG: Prices
    Updated 2024-12-02
    -- forked from Ario / $FWOG Price @ https://flipsidecrypto.xyz/Ario/q/BoGOp2ehYUCK/FWOG-price

    with TYBGPrice as (
    SELECT
    hour AS recorded_Hour
    , price AS TYBG_Price
    FROM base.price.ez_prices_hourly
    WHERE
    token_address = lower('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE')
    ),

    minimum as (
    SELECT
    MIN(TYBG_Price) as Min_Price
    FROM TYBGPrice
    WHERE TYBG_Price > 0
    ),

    maximum as (
    SELECT
    MAX(TYBG_Price) as Max_Price
    FROM TYBGPrice
    ),

    current_priceT as (
    SELECT
    TYBG_Price as current_Price
    FROM TYBGPrice
    ORDER BY recorded_hour DESC
    LIMIT 1
    ),

    last24 as (
    SELECT
    TYBG_Price as last24price
    FROM TYBGPrice
    QueryRunArchived: QueryRun has been archived