TOTAL_TX_HASHES | TOTAL_MAKERS | TOTAL_TAKERS | TOTAL_TAKER_AMOUNT_FILLED | TRADERS | |
---|---|---|---|---|---|
1 | 7231 | 379 | 439 | 689321.193388 | 19831 |
datavortexTrades
Updated 2025-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
COUNT(DISTINCT tx_hash) AS total_tx_hashes,
COUNT(DISTINCT decoded_log:"maker") AS total_makers,
COUNT(DISTINCT decoded_log:"taker") AS total_takers,
SUM(decoded_log:"takerAmountFilled") / 1e6 AS total_taker_amount_filled,
(SELECT COUNT(DISTINCT decoded_log:"proxy")
FROM ronin.core.ez_decoded_event_logs
WHERE origin_to_address = '0x02f376fe3e11634a866d2087f01427b09a235599') AS traders
FROM ronin.core.ez_decoded_event_logs
WHERE event_name = 'OrderFilled'
AND decoded_log:"taker" <> '0x520fe655590e6fee13656590f1be3edf31fe099c'
AND origin_from_address = '0x8962cde7ac43de7d55e8b61c80ee8d148fc7a201'
AND origin_to_address = '0x520fe655590e6fee13656590f1be3edf31fe099c';
Last run: about 2 months ago
1
36B
12s