select

CONTRACT_NAME ,

CREATED_AT_TIMESTAMP,

MINT as token_id_contract ,

IMAGE_URL ,

TOKEN_ID ,

TOKEN_METADATA

from

solana.core.dim_nft_metadata

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

, SALE as

select date(BLOCK_TIMESTAMP) AS DATE ,

PURCHASER ,

SELLER ,

TX_ID ,

TOKEN_ID ,

CONTRACT_NAME ,

SALES_AMOUNT ,

MINT

from

solana.core.fact_nft_sales as fv

join datas on token_id_contract = MINT

where MARKETPLACE ilike '%magic eden%' and SUCCEEDED = 'TRUE'

AND SALES_AMOUNT >0

),

sol as (

select

block_timestamp::date as date,

median (swap_to_amount/swap_from_amount) as sol_usd_price

from solana.fact_swaps

where swap_from_mint = 'So11111111111111111111111111111111111111112' --DUST