SELECT

address AS "Trader Address",

MIN(block_timestamp) AS "First Transaction Date"

FROM (

SELECT

buyer_address AS address,

block_timestamp

FROM

arbitrum.nft.ez_nft_sales

WHERE

buyer_address NOT IN (SELECT DISTINCT seller_address FROM arbitrum.nft.ez_nft_sales)

UNION ALL

SELECT

seller_address AS address,

block_timestamp

FROM

arbitrum.nft.ez_nft_sales

WHERE

seller_address NOT IN (SELECT DISTINCT buyer_address FROM arbitrum.nft.ez_nft_sales)

) AS transactions

GROUP BY

address

),

TraderActivity AS (

SELECT

address AS "Trader Address",

DATE_TRUNC('day', block_timestamp) AS "Transaction Date"

FROM (

SELECT

buyer_address AS address,

block_timestamp

FROM