emferonsActive Addresses (Signer ONLY) copy
Updated 2025-01-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
⌄
-- forked from charliemarketplace / Active Addresses (Signer ONLY) @ https://flipsidecrypto.xyz/charliemarketplace/q/z3l1YVvbxfNW/active-addresses-signer-only
/*
Identifies the first instance of an address being the tx_signer OR tx_receiver. So in the case
of meta transactions/account abstraction, where an abstract wallet (e.g., Kaiching) sends funds to
a subaccount (e.g., billy44.users.kaiching), the subaccount would take the first_seen as when billy44
was the receiver. But for typical addresses, expect it to be tx_signer based.
*/
select
month_,
n_active_signers
from datascience_public_misc.near_analytics.monthly_active_signers
order by month_ asc;
QueryRunArchived: QueryRun has been archived