flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Total Users
0xHaM-d
Total Users
Updated 2024-10-05
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with
txs
as
(
select
block_timestamp
,
TX_HASH
,
tx_signer
from
near
.
core
.
fact_transactions
-- WHERE block_timestamp >= '2023-01-01'
)
SELECT
count
(
DISTINCT
tx_signer
)
as
address
FROM
txs
Results
QueryRunArchived: QueryRun has been archived