(select

SALES_AMOUNT as volume ,

MINT as NFT_address ,

SELLER as sellers ,

PURCHASER as buyers ,

TX_ID as sale_tx ,

BLOCK_TIMESTAMP ::date as date

from

solana.core.fact_nft_sales

where MARKETPLACE ='opensea' and SUCCEEDED ='true'

, sol_metadata as (

select CONTRACT_NAME as name , CREATED_AT_TIMESTAMP::date as created_time , MINT as NFT_created , solana.*

from solana.core.dim_nft_metadata right join solana on NFT_address = CONTRACT_ADDRESS where CONTRACT_ADDRESS=lower('3GdiRw48fHLdaeXvQZmvoP5fn1KdgZQM7G1fmamgMEop')

select * from

limit 3