maybeyonasmsol_march_2_sus
Updated 2022-03-08
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
stakes as (
select
block_timestamp,
tx_id,
value:parsed:info:source::string as user,
value:parsed:info:lamports/pow(10,9) as sol_staked,
value:parsed:info:destination::string as destination
-- value
from solana.events e,
lateral flatten(input => e.inner_instruction:instructions)
where value:parsed:info:destination::string in (
'UefNb6z6yvArqe4cJHTXCqStRsKmWhGxnZzuHbikP5Q',
'Du3Ysj1wKbxPKkuPPnvzQLQh8oMSVifs3jGZjJWXFmHN'
)
and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
and sol_staked is not null
and succeeded = 'TRUE'
)
select * from stakes
order by sol_staked desc
limit 100
Run a query to Download Data