FlorentGAmnis arb
Updated 2024-06-11
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
›
⌄
WITH hash as (
SELECT tx_hash
FROM aptos.core.fact_transactions
WHERE BLOCK_TIMESTAMP > current_date() - INTERVAL '7 DAYS'
AND SENDER = '0xff6cddaed038bb97db75ca0ffcf80297321ac670927b5df63e9a3c2c999c1a29'
-- AND PAYLOAD["multisig_address"] = '0xa42bb9fb49996d28605685ee93a5bd5de5b2399a466686d93727607fad610360'
)
SELECT e.*
-- sum(EVENT_DATA['amount_out'] - EVENT_DATA['amount_in']) as apt_profit
FROM aptos.core.fact_events e
JOIN hash h ON e.tx_hash = h.tx_hash
WHERE EVENT_TYPE = '0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::stable_pool::SwapEvent<0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt, 0x1::aptos_coin::AptosCoin, 0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::base_pool::Null, 0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::base_pool::Null>'
AND EVENT_DATA['idx_in'] = 1
AND BLOCK_TIMESTAMP > current_date() - INTERVAL '7 DAYS'
LIMIT 10
SELECT *
-- sum(EVENT_DATA['amount_out'] - EVENT_DATA['amount_in']) as apt_profit
FROM aptos.core.fact_events
WHERE EVENT_TYPE = '0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::stable_pool::SwapEvent<0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt, 0x1::aptos_coin::AptosCoin, 0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::base_pool::Null, 0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::base_pool::Null>'
AND EVENT_DATA['idx_in'] = 1
AND BLOCK_TIMESTAMP > current_date() - INTERVAL '7 DAYS'
LIMIT 10
QueryRunArchived: QueryRun has been archived