select

CONTRACT_NAME ,

CREATED_AT_TIMESTAMP,

MINT as token_id_contract ,

IMAGE_URL ,

TOKEN_ID ,

TOKEN_METADATA

from

solana.core.dim_nft_metadata

where (CONTRACT_NAME) ilike '%Dapper Ape High Society%'

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

, SALE as

select MIN(BLOCK_TIMESTAMP) AS DATE ,

SELLER ,

TX_ID ,

TOKEN_ID ,

TOKEN_METADATA ,

SALES_AMOUNT ,

MINT

from

solana.core.fact_nft_sales as fv

join datas on token_id_contract = MINT

where fv.SUCCEEDED ='TRUE'

-- AND SALES_AMOUNT >0

GROUP BY 2,3,4,5,6,7 having count(distinct TX_ID) <2 )

, MINT as

select MINT ,

PURCHASER as minter ,

MINT_PRICE ,