StangFAST04 - 1 - Jupiter V.3 [ token ]
    Updated 2023-09-03
    -- forked from 04 - 1 - Jupiter V.3 [ token ] @ https://flipsidecrypto.xyz/edit/queries/027ee63d-085f-4076-81ee-a76937b2b388

    -- forked from 03 - Jupiter V.3 [ swap volume ] @ https://flipsidecrypto.xyz/edit/queries/ccce0d9e-2bc1-46aa-8e8b-914614b633f6

    -- forked from 02 - Jupiter V.3 [ numeric ] @ https://flipsidecrypto.xyz/edit/queries/f0dbd696-f375-443a-9e31-b0472420e288

    -- forked from 01 - Jupiter V.3 @ https://flipsidecrypto.xyz/edit/queries/2dd99fd8-0090-4fd4-b6b0-bed8ed375d52

    --- JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB -- jupiter swap v4
    --- JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph -- jupiter aggregator v3
    --- JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo -- jupiter aggregator v2

    --- JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4 -- jupiter v3

    with

    tkn_price AS
    (
    SELECT
    date_trunc( 'day' , a.recorded_hour ) AS day
    , avg( a.close ) AS price
    , a.token_address AS tkn_id
    , a.symbol AS token
    FROM
    solana.core.ez_token_prices_hourly a
    GROUP BY 1 , 3 , 4
    ORDER BY 1 DESC
    )
    ,
    jupiter AS
    (
    SELECT

    a.block_timestamp AS time
    , a.signers[0] AS uss
    , a.tx_id AS txs
    Run a query to Download Data