select

block_timestamp,

tx_hash,

'OpenSea' as marketplace,

seller_address as seller,

buyer_address as purchaser

from ethereum.core.ez_nft_sales

where PLATFORM_NAME = 'opensea'

, sol_nft_tx AS (

block_timestamp,

tx_id,

'Magic Eden' as marketplace,

seller,

purchaser

from Solana.fact_nft_sales

where marketplace = 'magic eden v2'

and SUCCEEDED = 'TRUE'

),

eth_address_stats AS (

SELECT

FROM_ADDRESS,

count(tx_hash) as tx_counts,

count(distinct date(block_timestamp)) as days_active,

min(date(block_timestamp)) as first_tx,

max(date(block_timestamp)) as last_tx,

datediff('day', last_tx, getdate()) as last_active_days,

datediff('day', first_tx, getdate()) as age_today_days

FROM ethereum.core.fact_transactions

GROUP BY 1

),

eth_NFT_TRANSACTIONS AS (

SELECT

FROM_ADDRESS as nft_tx_signer,