TOTAL_USDC | TOTAL_RON | TOTAL_TX_HASHES | TOTAL_ORIGIN_FROM_ADDRESSES | |
|---|---|---|---|---|
1 | 2275000.429026 | 3564529.71796571 | 1585 | 668 |
Updated 2025-04-08
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,
decoded_log,
CASE
WHEN contract_address = '0xe514d9deb7966c8be0ca922de8a064264ea6bcd4' THEN decoded_log:_value::FLOAT / 1e18
Last run: 27 days ago
1
44B
35s