princefarzamThe time of creation wallet for wildlife warrior NFT owners
    Updated 2022-06-23
    WITH Asset_id AS (
    select
    ASSET_ID,
    ASSET_NAME
    from algorand.asset
    where asset_name like 'Warrior Croc%'
    and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU'
    or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ'))

    SELECT
    DATE_trunc('month',D.BLOCK_TIMESTAMP)::DATE AS MONTH,
    COUNT(DISTINCT A.ADDRESS) AS Number_of_NFT_owners
    FROM flipside_prod_db.algorand.account_asset A INNER JOIN Asset_id B ON A.ASSET_ID=B.ASSET_ID
    INNER JOIN flipside_prod_db.algorand.account C ON A.ADDRESS=C.ADDRESS
    INNER JOIN flipside_prod_db.algorand.block D ON C.CREATED_AT=D.BLOCK_ID
    GROUP BY 1
    ORDER BY 1 ASC
    Run a query to Download Data