flipside

    Claynosaurz_txn
    feyikemiClaynosaurz_txn
    Updated 2024-03-12
    SELECT
    COUNT(DISTINCT tx_id) AS Txn_Count,

    from solana.nft.fact_nft_sales s
    LEFT JOIN solana.nft.dim_nft_metadata l
    ON s.mint = l.mint

    WHERE
    -- NFT_Name LIKE '%Clayno'
    NFT_COLLECTION_NAME = 'Claynosaurz'
    AND block_timestamp >= '2024-01-01'
    QueryRunArchived: QueryRun has been archived