TX_HASH | DECODED_LOG | |
---|---|---|
1 | 0xc2aacbc896265660508a538fc38a221b0e6f52687e316ff841388f5ec6473fb9 | {"amount0":"309082774726897940","amount1":"1600516279743473120","liquidi... |
2 | 0xbb1500a4a37ff03f0e132e8ed46d293690d75c70e749ab70ae4f953da955c94d | {"amount0":"5018484177317807742813","amount1":0,"liquidity":"11297693301... |
3 | 0xc973989268a9a32a9ea038f764050bb8b618b1e65026562de8f198ffe6f56414 | {"amount0":"9175139239284268491089990","amount1":0,"liquidity":"83680362... |
4 | 0x99a5e6e6a4486533f74854c865d43148fe321e2b4f7716cca7f7fe381b92ba1f | {"amount0":0,"amount1":"9299999999999999973538","liquidity":"61290849970... |
5 | 0x1102d027ef325a1b69dc21956c38229c7c781cb39dd202bc6fc5607bc84405a5 | {"amount0":"113999999999999999999","amount1":0,"liquidity":"327527866065... |
6 | 0x8e6953693662494a82637c417b03e2a0947127e43c512286881dffb0ea7c50a9 | {"amount0":"131262338298398351094727","amount1":"1662224449545081272923"... |
7 | 0xbe2d0d4eebfe7d3185724ab739d4cd83fbcc740786c504a362646200500d0907 | {"amount0":"1328234049999999999999999","amount1":0,"liquidity":"62292240... |
8 | 0xa770e47ac287a108394f33b84905ce6a992e5712489bbeb5dbfd586b0b8c984e | {"amount0":0,"amount1":"6395263738157762523177","liquidity":"20132484518... |
9 | 0xa0cdcf685122688e598c6bcc02bae94508b40f5075d4de116582030f23a542c2 | {"amount0":"30627323884320649192","amount1":"107579096171168777282","liq... |
10 | 0x829bd2f35c6a20961b9040bf1463bd77c6ee4da4de9a51d019d7b1ece59ae52a | {"amount0":"522000066447283529165477","amount1":0,"liquidity":"341272049... |
11 | 0xb7479d2a57704d5dd050c9217659e31afed8a2bd94f4e99d4cdee10c02be02ed | {"amount0":"512459375714302059936174","amount1":0,"liquidity":"369990221... |
12 | 0x2ca5f93359703bc166fe9cc8df9dd9c6032d75d26cb8de596ae3ae1eaef95bdf | {"amount0":"7357475677188869081634417","amount1":0,"liquidity":"61166998... |
13 | 0x64a6422532a29dd01dcfc665e55a59fed46a0751b51ea08d020413c401660955 | {"amount0":370148532,"amount1":"498516248227582247411","liquidity":14669... |
14 | 0xc052e134891db719701bc595348a5881048cf741daeb9b369485aa664edf0fa3 | {"amount0":"1343862751621803739829","amount1":"2188824677234862367286530... |
15 | 0x1aba91e4ee4dbb1341fdbfb9fa73884b5c1009416be368b542a33fd51475a026 | {"amount0":"1855556308856942713804921","amount1":0,"liquidity":"17341236... |
16 | 0xc5d9c6351e8de0ccbf2697932444c6c0d968db5b8cd2429ad01c40c97bbc8838 | {"amount0":"99999999999999999","amount1":"313201032469791213","liquidity... |
17 | 0xe42b845466c93950aac718785e577011db71eff13a8b25cfc88fc5e233c13766 | {"amount0":35296,"amount1":"72025074246989800302","liquidity":1594449449... |
18 | 0xa5d1a2889df491fec95a026ac9e3d84c29789bd4eca20988e31e75b4a5841144 | {"amount0":"126404631469665164151076","amount1":"393234573882967898","li... |
19 | 0x8210a7fca66f96074cbdfaae505a2e1e81f7de59e6164732d346855712e373bb | {"amount0":"1515187430047898269","amount1":"4921447249607592923","liquid... |
20 | 0x57ad330988b15c898039b9467e4a09e6f682e641f59e18bb0de9e09c14daffa6 | {"amount0":"10041553052566930285951908","amount1":"619530242794508184689... |
Updated 2025-04-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
›
⌄
⌄
SELECT
distinct tx_hash,
decoded_log
FROM ronin.core.ez_decoded_event_logs
WHERE contract_address = '0x7cf0fb64d72b733695d77d197c664e90d07cf45a'
and event_name in ('DecreaseLiquidity')
and ORIGIN_FUNCTION_SIGNATURE = '0xac9650d8'
and origin_to_address = '0x7cf0fb64d72b733695d77d197c664e90d07cf45a'
limit 50;
/*
SELECT COUNT(DISTINCT tx_hash) AS total_tx_hashes
FROM (
SELECT tx_hash
FROM ronin.core.ez_decoded_event_logs
WHERE contract_address IN (
'0x7cf0fb64d72b733695d77d197c664e90d07cf45a',
'0x0b7007c13325c48911f73a2dad5fa5dcbf808adc',
'0xe514d9deb7966c8be0ca922de8a064264ea6bcd4'
)
GROUP BY tx_hash
HAVING COUNT(DISTINCT contract_address) = 3
) AS matching_transactions;
*/
Last run: 27 days ago
50
9KB
2s