rajsNear Transactions
Updated 2022-11-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with txs as
(
SELECT
-- date_trunc('week', block_timestamp) as date,
tx_signer,
count(*) as no_of_txs
-- row_number() over (order by count(*) desc) as rank
from near.core.fact_transactions
group by 1
order by 2 desc
-- limit 3
)
select
*
-- case when rank <= 100 then 'Top 100' else 'Others' end as category
from txs
Run a query to Download Data