greyswanMarginNew
Updated 2024-04-24
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 liquidations as (
select
a.block_timestamp,
TX_ID,
decoded_args as arg_liq,
a.SIGNERS [0] as liquidator1,
a.DECODED_ARGS:assetAmount as amount_liq
from
solana.core.ez_events_decoded a
where
a.PROGRAM_ID = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'
and a.succeeded = 'true'
and a.BLOCK_TIMESTAMP >= current_date - 30
and a.event_type = 'lendingAccountLiquidate'
),
withdraws as (
select
TX_ID,
a.SIGNERS [0] as liquidator2,
decoded_args as arg_withdraw,
a.DECODED_ARGS:amount as amount_withdraw,
DECODED_ACCOUNTS [5] :pubkey as vault_from
from
solana.core.ez_events_decoded a
where
a.PROGRAM_ID = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'
and a.succeeded = 'true'
and a.BLOCK_TIMESTAMP >= current_date - 30
and a.event_type = 'lendingAccountWithdraw'
),
merged as (
select
block_timestamp,
amount_liq,
amount_withdraw,
a.tx_id,
QueryRunArchived: QueryRun has been archived