StangFASTtop 10 NFTs based on the most expensive
    Updated 2023-10-15
    -- forked from 003 - max min avg price @ https://flipsidecrypto.xyz/edit/queries/c9b20605-b62d-4d8f-ab9c-5699ec6f9c07

    -- forked from 001 - overview @ https://flipsidecrypto.xyz/edit/queries/21618bc0-5214-4ac6-89d2-1393c8223b7c

    with

    degen_ape AS
    (
    SELECT
    a.contract_address AS ca
    , a.token_name AS tn
    , a.token_id AS ti
    FROM
    solana.nft.dim_nft_metadata a
    WHERE
    a.token_name = 'Degen Apes'
    )
    ,
    price AS
    (
    SELECT
    date_trunc( 'day' , a.recorded_hour ) AS dt
    , avg( a.close ) AS pr
    , a.symbol AS sb
    FROM
    solana.price.fact_token_prices_hourly a
    WHERE
    a.symbol = 'SOL'
    GROUP BY 1 , 3
    ORDER BY 1 DESC
    )
    ,
    max AS
    (
    SELECT
    a.block_timestamp AS dt
    Run a query to Download Data