DATE | Daily Trading Volume (LRON) | Daily Transaction Count | Total Pool Liquidity (LRON) | Daily Active Traders | |
|---|---|---|---|---|---|
1 | 2025-04-01 00:00:00.000 | 0 | 67 | 49 | |
2 | 2025-03-31 00:00:00.000 | 0 | 94 | 55 | |
3 | 2025-03-30 00:00:00.000 | 0 | 61 | 46 | |
4 | 2025-03-29 00:00:00.000 | 0 | 98 | 73 | |
5 | 2025-03-28 00:00:00.000 | 0 | 236 | 179 | |
6 | 2025-03-27 00:00:00.000 | 0 | 131 | 104 | |
7 | 2025-03-26 00:00:00.000 | 0 | 185 | 147 | |
8 | 2025-03-25 00:00:00.000 | 0 | 357 | 296 | |
9 | 2025-03-24 00:00:00.000 | 0 | 715 | 412 | |
10 | 2025-03-23 00:00:00.000 | 0 | 94 | 64 | |
11 | 2025-03-22 00:00:00.000 | 0 | 110 | 81 | |
12 | 2025-03-21 00:00:00.000 | 0 | 457 | 270 | |
13 | 2025-03-20 00:00:00.000 | 0 | 10 | 8 | |
14 | 2025-03-15 00:00:00.000 | 0 | 1 | 1 |
superflyenvious-cyan
Updated 2025-04-02
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
29
30
31
32
33
34
35
36
›
⌄
WITH
lron_trades AS (
SELECT
date_trunc('day', block_timestamp) as date,
tx_hash,
contract_address,
event_name,
decoded_log:amount::int / 1e18 as trade_amount,
origin_from_address as trader
FROM ronin.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')
AND event_name IN ('Transfer', 'Swap', 'Deposit', 'Withdraw')
),
liquidity_pools AS (
SELECT
date_trunc('day', block_timestamp) as date,
contract_address,
SUM(decoded_log:amount::int / 1e18) as pool_liquidity
FROM ronin.core.ez_decoded_event_logs
WHERE
contract_address IN (
LOWER('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2'), -- LRON Pool
LOWER('0xe514d9deb7966c8be0ca922de8a064264ea6bcd4') -- Wrapped RON Pool
)
AND event_name IN ('AddLiquidity', 'RemoveLiquidity')
GROUP BY 1, 2
)
SELECT
t.date,
SUM(CASE WHEN t.event_name IN ('Transfer', 'Swap') THEN t.trade_amount ELSE 0 END) as "Daily Trading Volume (LRON)",
COUNT(DISTINCT CASE WHEN t.event_name IN ('Transfer', 'Swap') THEN t.tx_hash END) as "Daily Transaction Count",
SUM(lp.pool_liquidity) as "Total Pool Liquidity (LRON)",
Last run: 24 days ago
14
585B
10s