ydcny555Stakes over past 90 days
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date_trunc('{{date_range}}', a.block_timestamp) as date,
COUNT(DISTINCT tx_signer) as stakers,
COUNT(DISTINCT a.TX_HASH) as stakes,
SUM(b.tx:actions[0]:FunctionCall:deposit/pow(10,24)) as Staked_NEAR,
Staked_NEAR/stakers as near_per_staker
FROM near.core.fact_actions_events_function_call a
JOIN near.core.fact_transactions b ON a.tx_hash = b.tx_hash and a.block_timestamp=b.block_timestamp
WHERE method_name = 'deposit_and_stake'
and a.block_timestamp::date >= CURRENT_DATE - 90
group by 1
Run a query to Download Data