select

x.block_timestamp,

y.contract_name,

x.tx_id,

x.purchaser,

x.sales_amount,

y.token_metadata

from solana.core.fact_nft_sales x

join solana.dim_nft_metadata y on x.mint = y.mint and y.contract_name = 'DeGods'

where block_timestamp >= '2022-01-01'

and marketplace like '%magic eden%'

trunc(block_timestamp,'day') as date,

--token_metadata:Eyes AS Eyes,

--token_metadata:Head AS Head,

--token_metadata:Neck AS Neck,

--token_metadata:Skin AS Skin,

token_metadata:Mouth AS Mouth,

--token_metadata:Clothes AS Clothes,

--token_metadata:Specialty AS Background,

--token_metadata:Background AS Specialty,

count(distinct tx_id) as counts

from transactions

group by 1,2

order by 1 asc, 3 desc