StangFASTtrader
    Updated 2024-01-29

    with

    price1 AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS date
    , avg( a.price ) AS price
    , a.token_address AS token
    , a.symbol AS symbol
    , a.decimals AS decimal
    FROM
    avalanche.price.ez_hourly_token_prices a
    WHERE
    a.symbol = 'WAVAX'
    GROUP BY 1 , 3 , 4 , 5
    ORDER BY 1 DESC
    )
    ,
    --- mint
    tab1 AS
    (
    SELECT
    a.block_timestamp
    , a.tx_hash
    , b.origin_to_address
    , b.avax_from_address
    , b.avax_to_address
    , a.nft_from_address
    , a.nft_to_address
    , a.project_name
    , a.tokenid
    , b.amount_precise
    , b.amount_usd
    FROM
    avalanche.nft.ez_nft_transfers a
    Last run: about 1 year ago
    AVG( A.SALE_VOLUME - A.BUY_VOLUME )
    AVG( ( ( A.SALE_VOLUME - A.BUY_VOLUME ) / A.BUY_VOLUME ) * 100 )
    AVG( A.SALE_VOLUME )
    MAX( A.SALE_VOLUME )
    MIN( A.SALE_VOLUME )
    AVG( A.TOTAL_USDVOLUME - A.BUY_VOLUME )
    AVG( ( ( A.TOTAL_USDVOLUME - A.BUY_VOLUME ) / A.BUY_VOLUME ) * 100 )
    1
    154.525375133.16699565007231746.207347231837348-40893.029703262.823345214521
    1
    86B
    114s