FatemeTheLadynear cl13
Updated 2022-11-08
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc (week,block_timestamp) as date,
action,
count (distinct tx_hash) as TX_Count,
count (distinct tx_signer) as Users_Count,
count (distinct pool_address) as Validators_Count,
sum (stake_amount/1e24) as Volume
from near.core.dim_staking_actions where date>='2022-01-01' and date<CURRENT_DATE
group by 1,2
order by 1
Run a query to Download Data