ACTION_TYPE | PROGRAM_ID | COUNT(*) | |
|---|---|---|---|
1 | deposit | MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD | 11761217 |
2 | claim | MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD | 27609 |
3 | orderUnstake | MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD | 28703 |
4 | depositStakeAccount | MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD | 46394 |
0xHaM-dpresidential-bronze
Updated 2025-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with mende_price as (
select
date_trunc('day', hour) as dt,
symbol,
avg(price) as price
from solana.price.ez_prices_hourly
where token_address = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'
and hour > '2025-01-01'
group by 1,2
)
-- ,
-- stakeTb as (
select
ACTION_TYPE,
PROGRAM_ID,
count(*)
from solana.marinade.ez_liquid_staking_actions
-- where
group by all
-- )
Last run: 2 months ago
4
275B
1s