adambalaUntitled Query
Updated 2022-10-22
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT *
-- count (DISTINCT tx_signer) as USERS,
-- count (DISTINCT tx_hash) as TRXS,
-- sum (gas_used/10000000000000000) as GAS
-- 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,PLATFORM
--order by DATE
limit 1
Run a query to Download Data