SELECT

mint, sales_amount, purchaser, tx_id, date_trunc('day', block_timestamp) AS date

FROM solana.fact_nft_sales

WHERE marketplace like 'magic eden v%'

AND succeeded = 'TRUE'

AND block_timestamp >= '2022-01-01'

)

SELECT date, --token_metadata, f.path,

avg(f.value) as avg_attributes

from

(SELECT *

FROM me

LEFT JOIN solana.dim_nft_metadata dnm

ON me.mint = dnm.mint

WHERE dnm.project_name = 'DeGods') l, table(flatten(l.token_metadata)) f

WHERE path like '%Attribute%'

GROUP by DATE