StangFAST004 - marketplace
    Updated 2023-10-15
    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
    )

    SELECT

    date_trunc( '{{period}}' , a.block_timestamp ) AS "date"
    , count( distinct a.purchaser ) AS "purchasers"
    , count( distinct a.seller ) AS "sellers"
    , count( distinct a.tx_id ) AS "sale count"
    , sum( a.sales_amount * c.pr ) AS "sale volume"
    Run a query to Download Data