BLOCK_TIMESTAMP::date as day,

'ethereum' as Chain,

count(distinct TX_HASH) as Total_Sales,

count(distinct BUYER_ADDRESS) as Total_Unique_Buyers,

sum(PRICE_USD) as Total_Volume ,

count(distinct TX_HASH)/1908 as Average_Sales_Day ,

count(distinct BUYER_ADDRESS) /1908 as Average_Unique_Buyers_Day,

sum(PRICE_USD)/1908 as Average_Sales_Price_Day

from ethereum.core.ez_nft_sales

where day >= current_date -90

and day < current_date

group by 1,2

BLOCK_TIMESTAMP::date as day,

'solana' as Chain,

count(distinct TX_ID) as Total_Sales,

count(distinct PURCHASER) as Total_Unique_Buyers,

sum(SALES_AMOUNT) as Total_Volume ,

count(distinct TX_ID)/286 as Average_Sales_Day ,

count(distinct PURCHASER) /286 as Average_Unique_Buyers_Day,

sum(SALES_AMOUNT)/286 as Average_Sales_Price_Day

from solana.core.fact_nft_sales

where SUCCEEDED='TRUE'

and day >= current_date - 90

and day < current_date

group by 1,2

order by 1 asc