sol_daily_price AS (

SELECT block_timestamp::date AS utc_date

, 'SOL' AS symbol

, median(swap_to_amount / swap_from_amount) AS price_usd

FROM solana.core.fact_swaps

WHERE swap_to_amount > 10

AND swap_from_mint = 'So11111111111111111111111111111111111111112'

AND swap_to_mint IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')

AND succeeded = True

GROUP BY 1,2

),

solana_nft_metadata AS (

SELECT mint, project_name

FROM solana.core.dim_nft_metadata

QUALIFY row_number() OVER (partition by mint order by created_at_timestamp desc) = 1

),

nft_sales__magic_eden AS (

SELECT s.tx_id

, s.block_timestamp

, 'Magic Eden' AS marketplace

, s.purchaser AS buyer

, s.seller

, s.mint AS nft_address

, m.project_name

, 'SOL' AS currency_symbol

, s.sales_amount AS price

, s.sales_amount * p.price_usd AS price_usd

FROM solana.core.fact_nft_sales AS s

LEFT JOIN sol_daily_price AS p