DATE | EVENT | PLATFORM | Volume | TXs | INITCAP(EVENT) | |
|---|---|---|---|---|---|---|
1 | 2023-01-01 00:00:00.000 | unstake | Linear | -60754.739070049 | 84 | Unstake |
2 | 2024-10-01 00:00:00.000 | unstake | Linear | -205523.15275471 | 88 | Unstake |
3 | 2022-04-01 00:00:00.000 | unstake | Linear | -41190.791148094 | 186 | Unstake |
4 | 2023-08-01 00:00:00.000 | stake | Linear | 4610320.27132471 | 153 | Stake |
5 | 2024-02-01 00:00:00.000 | unstake | Linear | -153552.990850752 | 153 | Unstake |
6 | 2023-03-01 00:00:00.000 | stake | Linear | 1132204.14856675 | 120 | Stake |
7 | 2022-05-01 00:00:00.000 | unstake | Linear | -170013.587633468 | 190 | Unstake |
8 | 2022-11-01 00:00:00.000 | stake | Linear | 591527.833152929 | 617 | Stake |
9 | 2022-07-01 00:00:00.000 | stake | Linear | 768483.215481725 | 1222 | Stake |
10 | 2023-06-01 00:00:00.000 | stake | Linear | 3435304.3805063 | 240 | Stake |
11 | 2025-01-01 00:00:00.000 | stake | Linear | 168736.33296 | 2720 | Stake |
12 | 2023-01-01 00:00:00.000 | stake | Linear | 1652303.83490091 | 387 | Stake |
13 | 2022-06-01 00:00:00.000 | stake | Linear | 2075725.1956147 | 370 | Stake |
14 | 2022-07-01 00:00:00.000 | unstake | Linear | -276851.409649844 | 220 | Unstake |
15 | 2023-06-01 00:00:00.000 | unstake | Linear | -28317.138083066 | 27 | Unstake |
16 | 2024-05-01 00:00:00.000 | stake | Linear | 7262927.84647 | 2221 | Stake |
17 | 2023-10-01 00:00:00.000 | stake | Linear | 2751179.91972562 | 131 | Stake |
18 | 2024-11-01 00:00:00.000 | stake | Linear | 474163.616442813 | 13436 | Stake |
19 | 2022-10-01 00:00:00.000 | unstake | Linear | -1543410.38454194 | 219 | Unstake |
20 | 2024-05-01 00:00:00.000 | unstake | Linear | -5185229.52116921 | 251 | Unstake |
MoDeFinear lst - stake linear
Updated 2025-01-19
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
linear_staking as (
select BLOCK_TIMESTAMP, try_parse_json(CLEAN_LOG) as log,
log:data[0]:account_id as account,
case when try_parse_json(CLEAN_LOG):event='stake' then 'stake' else 'unstake' end as event,
coalesce(log:data[0]:staked_amount::double/1e24, log:data[0]:unstaked_amount::double/1e24) as amount,
log:data[0]:new_stake_shares::double/1e24 as new_stake_shares
from near.core.fact_logs
where RECEIVER_ID='linear-protocol.near'
and try_parse_json(CLEAN_LOG):standard='linear'
and try_parse_json(CLEAN_LOG):event in ('instant_unstake','stake','unstake')),
linear_staking_rewards as (
select BLOCK_TIMESTAMP, try_parse_json(CLEAN_LOG) as log,
log:data[0]:validator_id as validator_id,
'reward' as event,
log:data[0]:rewards::double/1e24 as amount,
log:data[0]:new_stake_shares::double/1e24 as new_stake_shares
from near.core.fact_logs
where RECEIVER_ID='linear-protocol.near'
and try_parse_json(CLEAN_LOG):standard='linear'
and try_parse_json(CLEAN_LOG):event in ('epoch_update_rewards')),
metapool_staking as (
select BLOCK_TIMESTAMP, try_parse_json(CLEAN_LOG) as log,
coalesce(log:account_id, log:account) as account,
case when try_parse_json(CLEAN_LOG):event='STAKE' then 'stake' else 'unstake' end as event,
coalesce(log:amount::double/1e24, log:near::double/1e24, log:near::double/1e24) as amount
from near.core.fact_logs
where RECEIVER_ID='meta-pool.near'
and try_parse_json(CLEAN_LOG):event in ('STAKE','D-UNSTK','LIQ.U')),
metapool_staking_rewards as (
select *, REGEXP_SUBSTR(CLEAN_LOG, 'rewards:(\\d+)', 1, 1, 'e', 1)::double/1e24 as amount, 'reward' as event
from near.core.fact_logs
where RECEIVER_ID='meta-pool.near'
Last run: 3 months ago
70
5KB
110s