mohamadreza221166Buyers Of Degods on Last Month
    Updated 2022-07-18
    SELECT
    BLOCK_TIMESTAMP,
    TX_ID,
    purchaser,
    sales_amount
    FROM solana.fact_nft_sales b
    JOIN solana.dim_nft_metadata a ON a.mint = b.mint
    WHERE lower(contract_name) LIKE '%degods%'
    AND BLOCK_TIMESTAMP::DATE >= DATEADD(MONTH, -1, CURRENT_DATE)
    AND sales_amount > 0


    SELECT
    BLOCK_TIMESTAMP,
    TX_ID,
    l.LABEL,
    sales_amount
    FROM solana.fact_nft_sales b
    JOIN solana.dim_nft_metadata a ON a.mint = b.mint
    JOIN solana.core.dim_labels l on l.ADDRESS = b.PROGRAM_ID
    WHERE lower(contract_name) LIKE '%degods%'
    AND BLOCK_TIMESTAMP::DATE >= DATEADD(MONTH, -1, CURRENT_DATE)
    AND sales_amount > 0

    Run a query to Download Data