Mahroosemantic-violet
Updated 2024-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc (week,block_timestamp) as date,
action,
count (distinct tx_hash) as TX_Count,
count (distinct SIGNER_ID) as Users_Count,
count (distinct ADDRESS) as Validators_Count,
sum (AMOUNT) as Volume
from near.gov.fact_staking_actions
WHERE
DATE(BLOCK_TIMESTAMP) >= '2024-01-01'
AND DATE(BLOCK_TIMESTAMP) < '2024-11-14'
group by 1,2
order by 1
QueryRunArchived: QueryRun has been archived