count (DISTINCT tx_signer) as USERS,

count (DISTINCT tx_hash) as TRXS,

sum (gas_used/10000000000000000) as GAS,

'PARAS' AS TITLE ,

date_trunc(day, block_timestamp) as DATE

from near.core.fact_transactions where tx_receiver ='x.paras.near'or tx_receiver ='marketplace.paras.near'

group by DATE ,TITLE

union

select

count (DISTINCT tx_hash) as TRXS,

count (DISTINCT BUYER_ADDRESS) as USERS,

SUM(TX_FEE) AS GAS ,

'OPENSEA' AS TITLE ,

date_trunc(day, block_timestamp) as DATE

from ethereum.core.ez_nft_sales

where EVENT_TYPE='sale' and PLATFORM_name ='opensea'

GROUP BY DATE,TITLE