SELECT
date_trunc(hour, block_timestamp) as date,
sales_amount,
-- sales_amount > 0,
token_metadata:Type,
token_metadata:"Attribute Count",
token_metadata:Hat,
token_metadata:Eyes
FROM solana.core.dim_nft_metadata
JOIN solana.core.fact_nft_sales
ON solana.core.dim_nft_metadata.mint = solana.core.fact_nft_sales.mint
JOIN ethereum.core.fact_hourly_token_prices
ON ethereum.core.fact_hourly_token_prices.Hour = solana.core.fact_nft_sales.block_timestamp