MONTH_ | PROJECT | COUNT(DISTINCT TX_SIGNER) | COUNT(*) | COUNT(DISTINCT IFNULL(TX:ACTIONS[0]:DELEGATE:DELEGATE_ACTION:SENDER_ID::STRING, TX_SIGNER)) | |
|---|---|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | here wallet | 765237 | 99677497 | 2907289 |
2 | 2025-03-01 00:00:00.000 | kaikai | 7 | 60506895 | 38069969 |
3 | 2025-03-01 00:00:00.000 | sweat | 38841 | 8551160 | 989409 |
4 | 2025-03-01 00:00:00.000 | playember | 121004 | 3091414 | 508769 |
5 | 2025-03-01 00:00:00.000 | hot near wallet | 121170 | 2302311 | 286188 |
6 | 2025-03-01 00:00:00.000 | harvest moon | 26410 | 1607853 | 39502 |
7 | 2025-03-01 00:00:00.000 | wnear | 41514 | 1546298 | 46438 |
8 | 2025-03-01 00:00:00.000 | ref finance | 1891 | 941102 | 1906 |
9 | 2025-03-01 00:00:00.000 | aurora | 17401 | 785820 | 18204 |
10 | 2025-03-01 00:00:00.000 | coin.abound.near | 1 | 592715 | 1 |
11 | 2025-03-01 00:00:00.000 | usdc | 15828 | 420489 | 17915 |
12 | 2025-03-01 00:00:00.000 | USDt | 21549 | 334029 | 27073 |
13 | 2025-03-01 00:00:00.000 | proximity | 8402 | 273249 | 8538 |
14 | 2025-03-01 00:00:00.000 | meme-priceoracle.ref-labs.near | 16 | 206738 | 16 |
15 | 2025-03-01 00:00:00.000 | USDT.e | 376 | 152075 | 1306 |
16 | 2025-03-01 00:00:00.000 | pyth | 4 | 134586 | 4 |
17 | 2025-03-01 00:00:00.000 | near | 712 | 116267 | 712 |
18 | 2025-03-01 00:00:00.000 | d23b40a6ff05b1008a64828db142e4f79e3f5e0ffb048356c3cea3b266c7e79e | 27175 | 87629 | 27175 |
19 | 2025-03-01 00:00:00.000 | score.aidols.near | 1332 | 87171 | 1332 |
20 | 2025-03-01 00:00:00.000 | acc.toalice.near | 2 | 85961 | 2 |
MoDeFinear signers comp - 1
Updated 2025-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
DATE_TRUNC('month', block_timestamp) as month_,
ifnull(PROJECT_NAME,TX_RECEIVER) as project,
-- COUNT(DISTINCT tx_signer) as n_active_signers,
-- tx_signer,
-- ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER) as receiver,
-- count(*),
count(distinct TX_SIGNER),
count(*),
count(distinct ifnull(tx:actions[0]:Delegate:delegate_action:sender_id::string, TX_SIGNER)),
-- count(distinct ifnull(tx:actions[0]:Delegate:delegate_action:sender_id::string, TX_SIGNER))
FROM near.core.fact_transactions
left join near.core.dim_address_labels
on address=ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER)
WHERE DATE_TRUNC('month', block_timestamp) = '2025-03-01' -- Setting a reasonable start date for NEAR)
-- and receiver='reserve.kaiching'
group by 1,2
order by 4 desc
limit 1000
Last run: 11 days ago
...
1000
68KB
15s