freemartianTortuga Stake
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
›
⌄
SELECT
block_number,
block_timestamp,
version,
tx_hash,
event_data:delegator AS staker,
success,
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:amount AS apt_amount_unadj,
event_data:amount/pow(10,8) AS apt_amount,
event_data:t_apt_coins AS tapt_amount_unadj,
event_data:t_apt_coins/pow(10,8) AS tapt_amount,
FROM aptos.core.fact_events
WHERE event_type = '0x8f396e4246b2ba87b51c0739ef5ea4f26515a98375308c31ac2ec1e42142a57f::stake_router::StakeEvent'
ORDER BY 2 DESC
LIMIT 100