ethereum.core.dim_nft_metadata.token_metadata:{{ trait }} as trait,

COUNT(*),

avg(price_usd)

FROM ethereum.core.ez_nft_sales

LEFT outer JOIN ethereum.core.dim_nft_metadata

on NFT_ADDRESS = contract_address

AND ethereum.core.dim_nft_metadata.token_id = ethereum.core.ez_nft_sales.TOKENID

WHERE not price_usd is NULL

AND ethereum.core.ez_nft_sales.project_name LIKE '{{collection}}'

AND block_timestamp > CURRENT_DATE - {{fist_day}}

GROUP BY 1