DATE | TOTAL_STAKES | TOTAL_AMOUNT_STAKED_USD | |
|---|---|---|---|
1 | 2024-10-03 00:00:00.000 | 225 | 2825230.89 |
2 | 2024-11-05 00:00:00.000 | 199 | 825170.43 |
3 | 2024-11-15 00:00:00.000 | 146 | 348820.4 |
4 | 2024-01-18 00:00:00.000 | 31739 | 5117732.56 |
5 | 2024-02-11 00:00:00.000 | 24730 | 5785008.67 |
6 | 2024-04-18 00:00:00.000 | 359 | 436225.72 |
7 | 2024-05-30 00:00:00.000 | 268 | 1029952.51 |
8 | 2024-03-24 00:00:00.000 | 2414 | 8603462.61 |
9 | 2024-01-22 00:00:00.000 | 21071 | 881885.81 |
10 | 2024-09-15 00:00:00.000 | 77 | 537370.39 |
11 | 2024-02-05 00:00:00.000 | 23236 | 3312899.32 |
12 | 2024-04-08 00:00:00.000 | 282 | 727066.81 |
13 | 2024-06-16 00:00:00.000 | 736 | 383270.28 |
14 | 2024-03-05 00:00:00.000 | 10404 | 1416091.55 |
15 | 2024-07-02 00:00:00.000 | 573 | 2943735.81 |
16 | 2024-11-09 00:00:00.000 | 161 | 180805.38 |
17 | 2024-12-19 00:00:00.000 | 198 | 614939.13 |
18 | 2024-12-25 00:00:00.000 | 750 | 6296281.81 |
19 | 2024-05-28 00:00:00.000 | 351 | 284901.36 |
20 | 2024-02-22 00:00:00.000 | 11664 | 3210331.59 |
kingnedustaking
Updated 2025-01-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with stakes as (
select
date_trunc('day',block_timestamp::date) as date,
tx_id,
action_type,
provider_address,
deposit_amount_usd
from solana.marinade.ez_liquid_staking_actions
where block_timestamp::date between '2024-01-01' and '2025-01-01'
)
select
date,
count(tx_id) as total_stakes,
sum(deposit_amount_usd) as total_amount_staked_usd
from stakes
where action_type = 'deposit'
group by 1
Last run: 5 days ago
...
367
15KB
4s