rw2023Collection - Marketplace trade volume
    Updated 2023-04-23
    -- forked from Aurory - Marketplace trade volume @ https://flipsidecrypto.xyz/edit/queries/93d98034-114c-4561-8721-8b3e85b3939d

    -- forked from crypto_edgar / NFT Trades @ https://flipsidecrypto.xyz/crypto_edgar/q/2023-04-20-07-50-am-GEYhMz

    with
    aurory AS (
    SELECT
    ADDRESS AS MINT
    FROM
    solana.core.dim_labels
    WHERE
    label = '{{collection_label}}'
    ),
    ME_TRADES as (
    select
    DATE_TRUNC('Day', BLOCK_TIMESTAMP) as DAY,
    CASE
    WHEN MARKETPLACE = 'tensorswap' THEN 'Tensorswap'
    WHEN MARKETPLACE = 'magic eden v1' THEN 'Magic Eden'
    WHEN MARKETPLACE = 'magic eden v2' THEN 'Magic Eden'
    WHEN MARKETPLACE = 'hyperspace' THEN 'Hyperspace'
    WHEN MARKETPLACE = 'opensea' THEN 'OpenSea'
    WHEN MARKETPLACE = 'solanart' THEN 'Other'
    WHEN MARKETPLACE = 'yawww' THEN 'Other'
    WHEN MARKETPLACE = 'coral cube' THEN 'Other'
    WHEN MARKETPLACE = 'Coral Cube' THEN 'Other'
    WHEN MARKETPLACE = 'hadeswap' THEN 'HadeSwap'

    ELSE MARKETPLACE
    END AS MARKETPLACE,
    SALES_AMOUNT,
    CLOSE,
    TX_ID,
    SALES.MINT
    from
    solana.core.fact_nft_sales SALES
    Run a query to Download Data