messariNEAR Delegators 2022
Updated 2022-11-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with base as (
select
tx_signer as signer,
QUARTER(DATE(block_timestamp)) as quarter,
YEAR(DATE(block_timestamp)) as year,
action as actions,
stake_amount as amt
from near.core.dim_staking_actions
where year = 2022 and quarter < 4
)
SELECT
year as year,
quarter as quarter,
signer as sig,
actions,
SUM(amt) as amt
from base
GROUP by year, quarter, signer, actions
order by year, quarter asc
limit 100000
Run a query to Download Data