USER_ADDRESS | NUMBER_OF_TRANSACTIONS | TOTAL_TRANSACTION_AMOUNT_RON | AVERAGE_TRANSACTION_AMOUNT_RON | LARGEST_TRANSACTION_AMOUNT_RON | SMALLEST_TRANSACTION_AMOUNT_RON | TOTAL_VALUE_USD | AVG_VALUE_USD | MEDIAN_AMOUNT_RON | |
|---|---|---|---|---|---|---|---|---|---|
1 | 0x58935a1e2c1bd67ae2f12b2fd30642db4eb3fdb2 | 1 | 2500000 | 2500000 | 2500000 | 2500000 | 1763835 | 1763835 | 2500000 |
2 | 0x7b779d1bf9f57d241d273f1cb156f1b679f6d037 | 1 | 362500 | 362500 | 362500 | 362500 | 255756.075 | 255756.075 | 362500 |
3 | 0x11111111111fc7a46edf8c8d04ab853702a4e54a | 3 | 230101 | 76700.33333333333 | 230000 | 1 | 162344.078934 | 54114.692978 | 100 |
4 | 0x92d3739608c990b4d2ff067419d192c55e414e9b | 3 | 200600 | 66866.66666666667 | 200000 | 100 | 141530.1204 | 47176.7068 | 500 |
5 | 0x5441b0c743278aa1502dee65263e0de122040f86 | 3 | 160000 | 53333.333333333336 | 90000 | 10000 | 112885.44 | 37628.48 | 60000 |
6 | 0x048de4485191a040096bd03e9995f0d34d8c0d8e | 3 | 154197.188 | 51399.062666666665 | 103798.188 | 15999 | 108791.358838392 | 36263.786279464 | 34400 |
7 | 0x4b03275b26586b7e1f922ff18438c8583ca469a3 | 6 | 140020 | 23336.666666666668 | 90000 | 10 | 98788.87068 | 16464.81178 | 15000 |
8 | 0x2a034843a995f532f5390447f43bcac6c24ad777 | 6 | 86473 | 14412.166666666668 | 15405 | 10000 | 61009.641582 | 10168.273597 | 15348 |
9 | 0x1a84b052c241f4db1f801a025adb1b5e0f7c31f1 | 1 | 70000 | 70000 | 70000 | 70000 | 49387.38 | 49387.38 | 70000 |
10 | 0x3e112270cde41d90c4a6b9e1b09626d8bbc6709c | 2 | 50000 | 25000 | 45000 | 5000 | 35276.7 | 17638.35 | 25000 |
ellerydurwintop 10 transaction volume
Updated 2025-04-01
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
transactions AS (
SELECT
block_timestamp,
tx_hash,
contract_address,
event_name,
CASE
WHEN event_name = 'Deposit' THEN decoded_log:assets::int
WHEN event_name = 'Withdraw' THEN decoded_log:assets::int
END AS amount,
origin_from_address AS user_address
FROM ronin.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')
AND event_name IN ('Deposit', 'Withdraw')
),
wron_prices AS (
SELECT
wron_price
FROM (
SELECT
hour::date AS date,
median(price) AS wron_price,
ROW_NUMBER() OVER (ORDER BY hour::date DESC) as rn
FROM
ronin.price.ez_prices_hourly
WHERE
SYMBOL = 'WRON'
GROUP BY
hour::date
)
WHERE rn = 1
),
Last run: 27 days ago
10
1KB
4s