mohamadreza221166Compare Daily Nft Sales on Genopets vs StepN
    Updated 2022-07-14
    -- SELECT * FROM solana.core.dim_labels WHERE label_type = 'nft' AND lower(LABEL) like 'genopets' limit 100

    -- SELECT * FROM solana.core.dim_labels WHERE label_type = 'nft' AND lower(LABEL) like 'stepn' limit 100

    WITH swaps AS(
    SELECT BLOCK_TIMESTAMP, 'StepN' AS project, SALES_AMOUNT
    FROM solana.core.fact_nft_sales mnt
    JOIN solana.core.dim_labels lb ON lb.ADDRESS = mnt.MINT
    WHERE label_type = 'nft'
    AND lower(LABEL) like '%stepn%'
    -- AND BLOCK_TIMESTAMP::DATE >= '2022-01-01'
    UNION
    SELECT BLOCK_TIMESTAMP, 'Genopets' AS project, SALES_AMOUNT
    FROM solana.core.fact_nft_sales mnt
    JOIN solana.core.dim_labels lb ON lb.ADDRESS = mnt.MINT
    WHERE label_type = 'nft'
    AND lower(LABEL) like '%genopets%'
    -- AND BLOCK_TIMESTAMP::DATE >= '2022-01-01'
    )

    SELECT date_trunc('day', BLOCK_TIMESTAMP) as days, project, sum(SALES_AMOUNT) SALES_AMOUNT
    FROM swaps
    GROUP BY days, project



    Run a query to Download Data