CrypticylSolana NFT trading activity
    Updated 2024-10-31
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS sale_date,
    COUNT(DISTINCT TX_ID) AS total_sales_transactions,
    SUM(SALES_AMOUNT) AS total_sales_volume,
    COUNT(DISTINCT PURCHASER) AS unique_purchasers,
    COUNT(DISTINCT SELLER) AS unique_sellers,
    AVG(SALES_AMOUNT) AS avg_sales_amount,
    MARKETPLACE AS top_marketplace,
    COUNT(CASE WHEN IS_COMPRESSED = TRUE THEN 1 END) AS compressed_nft_sales,
    COUNT(CASE WHEN IS_COMPRESSED = FALSE THEN 1 END) AS uncompressed_nft_sales
    FROM
    solana.nft.fact_nft_sales
    WHERE
    BLOCK_TIMESTAMP >= '2024-10-01'
    AND BLOCK_TIMESTAMP < '2024-11-01'
    AND SUCCEEDED = TRUE
    GROUP BY
    sale_date, MARKETPLACE
    ORDER BY
    sale_date, total_sales_volume DESC
    LIMIT 100;

    Last run: 3 months ago
    SALE_DATE
    TOTAL_SALES_TRANSACTIONS
    TOTAL_SALES_VOLUME
    UNIQUE_PURCHASERS
    UNIQUE_SELLERS
    AVG_SALES_AMOUNT
    TOP_MARKETPLACE
    COMPRESSED_NFT_SALES
    UNCOMPRESSED_NFT_SALES
    1
    2024-10-01 00:00:00.00022963075.7142722329839461.339596808magic eden v202296
    2
    2024-10-01 00:00:00.00051713010.253179092135416790.5815790531tensorswap18243352
    3
    2024-10-01 00:00:00.0001072232.985955604151720.869027622hadeswap0107
    4
    2024-10-01 00:00:00.00038161864.3297063635587460.4885560027Magic Eden03816
    5
    2024-10-01 00:00:00.0006444.76530499829320.6994578906solsniper856
    6
    2024-10-01 00:00:00.00039912.4455845781381620.0311919413magic eden v33990
    7
    2024-10-01 00:00:00.00085.17201064770.64650133exchange art08
    8
    2024-10-01 00:00:00.00050.07289536340.014579072solanart05
    9
    2024-10-02 00:00:00.00057273103.507797539128415370.5413409729tensorswap22863447
    10
    2024-10-02 00:00:00.00020192811.1402032748848341.392342845magic eden v202019
    11
    2024-10-02 00:00:00.00024421799.7376416085366200.7369933012Magic Eden02442
    12
    2024-10-02 00:00:00.00015129.79788966711138.653192644hadeswap015
    13
    2024-10-02 00:00:00.0005166.7756790526311.30932704solsniper744
    14
    2024-10-02 00:00:00.000813.5545892551.69432365exchange art08
    15
    2024-10-02 00:00:00.0002429.033018886111890.03732652432magic eden v32420
    16
    2024-10-02 00:00:00.00010.00144768110.00144768solanart01
    17
    2024-10-03 00:00:00.00048953191.408354834120815090.6505112831tensorswap21432763
    18
    2024-10-03 00:00:00.00016692590.7036383177347711.552249034magic eden v201669
    19
    2024-10-03 00:00:00.00029861687.7097689245305770.5652075582Magic Eden02986
    20
    2024-10-03 00:00:00.000741.750993564775.964427652hadeswap07
    100
    8KB
    4s