datavortexVolume Traded Per Market NFT Place
    Updated 2025-03-25
    WITH volume_in_sol AS (
    SELECT
    marketplace,
    SUM(sales_amount) AS volume_in_sol
    FROM
    solana.nft.fact_nft_sales
    WHERE
    block_timestamp BETWEEN '2024-09-01' AND '2024-09-30'
    GROUP BY
    marketplace
    ),

    sol_price AS (
    SELECT
    AVG(price) AS average_price
    FROM
    solana.price.ez_prices_hourly
    WHERE
    hour BETWEEN '2024-08-31 00:00:00' AND '2024-09-18 23:59:59'
    AND
    token_address = 'So11111111111111111111111111111111111111112'
    )

    SELECT
    v.marketplace,
    v.volume_in_sol * p.average_price AS volume_in_usd
    FROM
    volume_in_sol v,
    sol_price p
    ORDER BY
    volume_in_usd DESC
    LIMIT 15;

    Last run: 3 months ago
    MARKETPLACE
    VOLUME_IN_USD
    1
    magic eden v2706187007.636416
    2
    tensorswap16905792.3555291
    3
    Magic Eden8565202.95025108
    4
    hadeswap1188922.69329437
    5
    tensor512585.472857166
    6
    hyperspace441847.193921135
    7
    solsniper223469.585027013
    8
    magic eden v3178714.453296549
    9
    exchange art24190.971129467
    10
    solanart19762.147310946
    11
    Coral Cube261.196033446
    11
    347B
    3s