rw2023HadeSwap ranking volumen colecciones
    Updated 2023-10-16
    -- forked from HadeSwap collection volume @ https://flipsidecrypto.xyz/edit/queries/24bd3016-a948-48e0-8e30-d97c1a85b243

    -- forked from UW Marketplace trade volume @ https://flipsidecrypto.xyz/edit/queries/4fc55011-d597-4828-a2b0-679fdfa611f6

    -- forked from Collection - Marketplace trade volume @ https://flipsidecrypto.xyz/edit/queries/d284e672-9c55-4f10-938a-644d135fd434

    -- 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
    ME_TRADES AS (
    SELECT
    DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS DAY,
    MARKETPLACE,
    SALES_AMOUNT,
    CLOSE,
    TX_ID,
    SALES.MINT,
    COALESCE(LABELS.label, 'Other') AS label
    FROM
    solana.core.fact_nft_sales SALES
    LEFT JOIN solana.core.ez_token_prices_hourly prices ON DATE_TRUNC('hour', SALES.BLOCK_TIMESTAMP) = prices.recorded_hour
    AND prices.symbol = 'sol'
    LEFT JOIN solana.core.dim_labels LABELS ON SALES.MINT = LABELS.address
    WHERE
    DAY >= TIMESTAMP '2021-04-26'
    AND SUCCEEDED
    AND MARKETPLACE ILIKE 'hadeswap'
    ),
    ME_TRADES_EDITED AS (
    SELECT
    DAY,
    MARKETPLACE,
    label AS MINT_LABEL,
    SUM(SALES_AMOUNT) AS VOLUME_SOL,
    Run a query to Download Data