0xHaM-dTotal Users
Updated 2024-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from Total Users @ https://flipsidecrypto.xyz/edit/queries/36f0fd91-3fb3-4ae0-aad0-4ee5130530e3
-- forked from Total Users copy @ https://flipsidecrypto.xyz/edit/queries/b60e6248-9aec-4fb1-9888-d7b7bec27e96
with txs as (
SELECT DISTINCT
block_timestamp,
tx_hash,
TX_SIGNER
FROM near.core.fact_transactions
)
SELECT
count(DISTINCT TX_SIGNER) as address
FROM txs
QueryRunArchived: QueryRun has been archived