day | event name | number of events | number of unique liquidity providers | |
|---|---|---|---|---|
1 | 2025-05-16 00:00:00.000 | Mint | 1 | 1 |
2 | 2025-05-15 00:00:00.000 | Burn | 4 | 3 |
3 | 2025-05-15 00:00:00.000 | Mint | 3 | 3 |
4 | 2025-05-14 00:00:00.000 | Burn | 1 | 1 |
5 | 2025-05-11 00:00:00.000 | Burn | 2 | 2 |
6 | 2025-05-11 00:00:00.000 | Mint | 1 | 1 |
7 | 2025-05-10 00:00:00.000 | Burn | 1 | 1 |
8 | 2025-05-09 00:00:00.000 | Burn | 2 | 2 |
9 | 2025-05-09 00:00:00.000 | Mint | 1 | 1 |
10 | 2025-05-08 00:00:00.000 | Burn | 1 | 1 |
11 | 2025-05-07 00:00:00.000 | Burn | 2 | 1 |
12 | 2025-05-07 00:00:00.000 | Mint | 1 | 1 |
13 | 2025-05-01 00:00:00.000 | Mint | 1 | 1 |
14 | 2025-04-30 00:00:00.000 | Burn | 1 | 1 |
15 | 2025-04-29 00:00:00.000 | Burn | 1 | 1 |
16 | 2025-04-27 00:00:00.000 | Burn | 1 | 1 |
17 | 2025-04-27 00:00:00.000 | Mint | 1 | 1 |
18 | 2025-04-26 00:00:00.000 | Burn | 2 | 2 |
19 | 2025-04-25 00:00:00.000 | Burn | 1 | 1 |
20 | 2025-04-24 00:00:00.000 | Burn | 1 | 1 |
defi__joshDaily liquidity provision/removal activity (30 days)
Updated 6 days ago
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 lp_activity AS (
SELECT
block_timestamp,
tx_hash,
origin_from_address,
origin_to_address,
contract_address,
-- symbol,
event_name,
decoded_log
FROM ronin.core.ez_decoded_event_logs
WHERE block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP)
AND contract_address IN (
-- Katana LP token contracts
'0x7d0556d55ca1a92708681e2e231733ebd922597d', -- Router
'0xc6344bc1604fcab1a5aad712d766796e2b7a70b9' -- AXS-WETH LP token as example
)
AND event_name IN ('Mint', 'Burn') -- LP token minting and burning events
)
SELECT
DATE_TRUNC('day', block_timestamp) as "day",
event_name as "event name",
COUNT(DISTINCT tx_hash) as "number of events",
COUNT(DISTINCT origin_from_address) as "number of unique liquidity providers"
FROM lp_activity
GROUP BY 1, 2
ORDER BY 1 DESC, 2;
Last run: 6 days ago
26
1015B
4s