greyswanNFT marketplaces_average
    Updated 2023-05-26
    with relevant_trades as (select
    date_trunc('month', block_timestamp) as NFT_month,
    date_trunc('week', block_timestamp) as NFT_week,
    purchaser,
    seller,
    sales_amount,
    CASE
    WHEN marketplace = 'Magic Eden' THEN 'ME'
    WHEN marketplace = 'magic eden v2' THEN 'ME'
    ELSE 'tensorswap'
    end as platform
    from
    solana.core.fact_nft_sales
    WHERE
    marketplace = 'Magic Eden'
    or marketplace = 'magic eden v2'
    or marketplace = 'tensorswap'
    and BLOCK_TIMESTAMP >= (
    CURRENT_DATE - interval ' {{param_no9B}} days'
    )
    AND succeeded = True)

    select
    nft_week,
    platform,
    avg(sales_amount) as avg_trade,
    median(sales_amount) as median_trade,
    sum(sales_amount) as volume,
    count (*) as trades
    from relevant_trades
    group by nft_week, platform
    order by nft_week desc

    -- where marketplace = 'Magic Eden' or 'magic eden v2'
    -- where marketplace = 'tensorswap'
    Run a query to Download Data