ErsvanF - Genopets Staking - Trends Genopets NFT collection
    Updated 2022-06-01
    --What trends are you seeing with the Genopets NFT collection?
    WITH RECURSIVE w_address_nft (address) AS (
    SELECT
    flipside_prod_db.solana.dim_labels.address AS address
    FROM
    flipside_prod_db.solana.dim_labels
    WHERE
    flipside_prod_db.solana.dim_labels.address_name='genopets token'
    AND flipside_prod_db.solana.dim_labels.label='genopets'
    GROUP BY flipside_prod_db.solana.dim_labels.address
    )

    SELECT
    DATE_TRUNC('day', block_timestamp) AS DATE_DAY
    ,COUNT (*) AS Total_sales
    FROM
    flipside_prod_db.solana.fact_nft_sales
    JOIN w_address_nft ON solana.fact_nft_sales.mint = w_address_nft.address
    WHERE PROGRAM_ID = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K' OR PROGRAM_ID = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'
    GROUP BY DATE_DAY ORDER BY DATE_DAY

    Run a query to Download Data