StangFAST9. $USD volume
    Updated 2023-04-13
    with price AS
    (

    SELECT
    date_trunc( 'week' , a.block_timestamp ) AS p_date
    , a.token_in
    , ( sum( a.amount_out ) / sum( a.amount_in ) ) AS price

    FROM
    near.core.ez_dex_swaps a

    WHERE
    a.token_out IN ( 'USDC.e' , 'USDT.e' , 'DAI.e' )
    AND a.amount_out > 0
    AND a.amount_in > 0

    GROUP BY
    1 , 2

    )

    ,

    conclus AS
    (

    SELECT
    -- p_date
    -- ,
    token_in
    , avg( price ) AS price

    FROM
    price
    WHERE
    Run a query to Download Data