freemartianTortuga Unstake Instantly
Updated 2024-07-10
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
›
⌄
SELECT
block_number,
block_timestamp,
version,
tx_hash,
success,
event_data:sender_addr AS staker,
tx_type,
payload_function,
split_part(payload_function,'::',1) AS platform_address,
'Tortuga' AS platform_name,
event_type,
event_address,
event_module,
event_resource,
event_data,
event_data:out_au AS apt_amount_unadj,
event_data:out_au/pow(10,8) AS apt_amount,
event_data:in_au AS tapt_amount_unadj,
event_data:in_au/pow(10,8) AS tapt_amount
FROM aptos.core.fact_events
WHERE event_type = '0xbd35135844473187163ca197ca93b2ab014370587bb0ed3befff9e902d6bb541::amm::SwapEvent'
AND event_data:in_coin_type = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin'
ORDER BY 2 DESC
LIMIT 100
QueryRunArchived: QueryRun has been archived