flipside

    Based Rekt Chickens
    piperBased Rekt Chickens
    Updated 2024-03-25
    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS "Date",
    COUNT(BLOCK_TIMESTAMP) AS "Number of sold Rekt Chickens"
    FROM
    base.nft.ez_nft_sales
    WHERE
    NFT_ADDRESS = lower('0xc16706AE5eED1805990d92241aDd1662724E50F2')
    GROUP BY 1
    ORDER BY 1 ASC
    QueryRunArchived: QueryRun has been archived