select distinct

date_trunc('day',block_timestamp) as date,

tx_id,

--ifnull(solana.nft_metadata.creator_address,'contract_na') as contract_address,

mint as token_id, -- mint address

MARKETPLACE as project_name,

PURCHASER as buyer,

'MagicEden' as marketplace

from flipside_prod_db.solana.fact_nft_sales nfts

where program_id in ('MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8',

'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')

and block_timestamp >= '2021-09-01'

),

opensea_sales as (

select distinct

date_trunc('day',block_timestamp) as date,

tx_id,

contract_address,

token_id,

ifnull(project_name,'unlabeled') as project_name,

event_to as buyer,

'OpenSea' as marketplace

from ethereum.nft_events

where event_platform = 'opensea'

and event_type = 'sale'

and event_from != '0x0000000000000000000000000000000000000000'