BURN_AMOUNT0 | BURN_AMOUNT1 | MINT_AMOUNT0 | MINT_AMOUNT1 | |
---|---|---|---|---|
1 | 14897689.641101 | 10324190.4278186 | 10395056.647731 | 6856944.6488928 |
datavortexdull-magenta
Updated 2025-04-09
999
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 usdc_transfer_hashes AS (
SELECT DISTINCT tx_hash
FROM ronin.core.ez_decoded_event_logs
WHERE event_name = 'Transfer'
AND contract_address = '0x0b7007c13325c48911f73a2dad5fa5dcbf808adc' -- USDC (1e6)
),
ron_transfer_hashes AS (
SELECT DISTINCT tx_hash
FROM ronin.core.ez_decoded_event_logs
WHERE event_name = 'Transfer'
AND contract_address = '0xe514d9deb7966c8be0ca922de8a064264ea6bcd4' -- RON (1e18)
),
increase_liquidity_hashes AS (
SELECT DISTINCT tx_hash
FROM ronin.core.ez_decoded_event_logs
WHERE event_name = 'DecreaseLiquidity'
AND contract_address = '0x7cf0fb64d72b733695d77d197c664e90d07cf45a'
),
valid_hashes AS (
SELECT u.tx_hash
FROM usdc_transfer_hashes u
INNER JOIN ron_transfer_hashes r ON u.tx_hash = r.tx_hash
INNER JOIN increase_liquidity_hashes i ON u.tx_hash = i.tx_hash
),
normalized_events AS (
SELECT
tx_hash,
block_timestamp,
contract_address,
contract_name,
origin_from_address,
origin_to_address,
event_name,
Last run: 27 days ago
1
68B
8s