MLDZMNfNFT6
    Updated 2022-09-17
    with price AS (
    select
    BLOCK_TIMESTAMP::date as day1,
    (sum(SWAP_TO_AMOUNT)/sum(SWAP_FROM_AMOUNT)) as price_usd
    from solana.core.fact_swaps
    where SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'
    and SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and day1>='2022-05-01'
    group by 1)
    select
    CONTRACT_NAME as NFT_project,
    count(distinct PURCHASER) as number_purchasers,
    sum(SALES_AMOUNT*price_usd) as volume
    from solana.core.fact_nft_sales x join solana.core.dim_nft_metadata y on x.mint=y.mint
    inner join price on price.day1=date_trunc('day',BLOCK_TIMESTAMP)
    where SUCCEEDED='TRUE'
    and tx_id is not NULL
    group by 1
    order by 3 desc
    limit 10
    Run a query to Download Data