'near' as chain,

count(distinct tx_hash) as "count of transaction",

count(distinct TX_SIGNER) as "count of buyers",

SUM(tx:actions[0]:FunctionCall:deposit*PRICE_USD / POW(10, 24)) as "sales volume (USD)"

from near.core.fact_transactions a join near.core.fact_prices b on a.block_timestamp = b.timestamp and symbol ilike 'wNEAR'

where block_timestamp::date >= current_date - 90

and tx:actions[0]:FunctionCall:method_name = 'nft_buy'

group by 1

select

'ethereum' as chain,

count(TX_hash) as "count of transaction",

count(distinct BUYER_ADDRESS) as "count of buyers",

sum(PRICE_USD) as "sales volume (USD)"

from ethereum.core.ez_nft_sales

where block_timestamp >= CURRENT_DATE - 90

group by 1

union

select

'solana' as chain,

count(TX_ID) as "count of transaction",

count(distinct PURCHASER) as "count of buyers",

sum(SALES_AMOUNT*close) as "sales volume (USD)"

from solana.core.fact_nft_sales a join solana.core.fact_token_prices_hourly b on a.block_timestamp = b.recorded_hour and symbol='SOL'

where block_timestamp >= CURRENT_DATE - 90

group by 1