unc_txs as (

select

block_timestamp

, CASE

when label = 'tensorian' THEN 'Tensorians'

when label is null THEN mint

else label

end as collection

, CASE

when label is null THEN 'Unlabeled'

else 'Labeled'

end as label_type

, purchaser as buyer

, seller

, sales_amount

-- , sales_amount * close as usd_amount

, tx_id

from solana.nft.fact_nft_sales

left join solana.core.dim_labels

on fact_nft_sales.mint = dim_labels.address

-- left join solana.price.ez_token_prices_hourly prices

-- on date_trunc('hour',fact_nft_sales.block_timestamp) = prices.recorded_hour

-- and prices.symbol = 'sol'

where succeeded

and block_timestamp >= '{{start_date}}'

AND block_timestamp < '{{end_date}}'

),

agg as (