SELECT

buyer_address,

seller_address,

price_usd,

tx_hash,

block_timestamp

FROM

arbitrum.nft.ez_nft_sales

WHERE

block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 DAY'

),

DistinctAddresses AS (

SELECT DISTINCT

buyer_address,

seller_address

FROM

SalesData

),

TotalVolume AS (

SELECT

SUM(price_usd) AS "Total Volume",

COUNT(DISTINCT buyer_address) AS "Total Buyers",

COUNT(DISTINCT seller_address) AS "Total Sellers",

COUNT(DISTINCT tx_hash) AS "Total Transactions"

FROM

SalesData

WHERE

buyer_address NOT IN (SELECT seller_address FROM DistinctAddresses)

AND seller_address NOT IN (SELECT buyer_address FROM DistinctAddresses)

),

AverageValues AS (

SELECT