DATE | RON_VOLUME | VOLUME_USD | LAND_SALES | |
|---|---|---|---|---|
1 | 2025-03-18 00:00:00.000 | 450 | 349.64 | 2 |
2 | 2025-03-17 00:00:00.000 | 568 | 446.2 | 3 |
3 | 2025-03-16 00:00:00.000 | 944 | 741.32 | 4 |
4 | 2025-03-15 00:00:00.000 | 174 | 147.38 | 1 |
5 | 2025-03-14 00:00:00.000 | 9188.88 | 7759.16 | 4 |
6 | 2025-03-13 00:00:00.000 | 279.98 | 228.98 | 2 |
7 | 2025-03-12 00:00:00.000 | 2057.94 | 1569.08 | 9 |
8 | 2025-03-11 00:00:00.000 | 1848.98 | 1319.28508 | 9 |
9 | 2025-03-10 00:00:00.000 | 2142 | 1686.52 | 5 |
10 | 2025-03-09 00:00:00.000 | 1770.86 | 1498.78038 | 9 |
11 | 2025-03-08 00:00:00.000 | 641.8 | 570.94 | 4 |
12 | 2025-03-07 00:00:00.000 | 1307.4 | 1191.95995 | 6 |
13 | 2025-03-06 00:00:00.000 | 1939.9 | 1843.74 | 9 |
14 | 2025-03-05 00:00:00.000 | 465.46 | 424.56 | 3 |
15 | 2025-03-04 00:00:00.000 | 645.8 | 577.28 | 3 |
16 | 2025-03-03 00:00:00.000 | 725.354 | 722.62 | 3 |
17 | 2025-03-02 00:00:00.000 | 1270.9 | 1247.42 | 7 |
18 | 2025-03-01 00:00:00.000 | 180 | 170.66 | 1 |
19 | 2025-02-28 00:00:00.000 | 939.2 | 882.201668 | 3 |
20 | 2025-02-26 00:00:00.000 | 192 | 195.46 | 1 |
permaryyeasty-olive
Updated 2025-03-19
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
›
⌄
⌄
SELECT
DATE_TRUNC('day', n.block_timestamp) AS date, -- Truncates to day level
SUM(n.amount) AS ron_volume,
SUM(n.amount_usd) AS volume_usd,
COUNT(distinct n.tx_hash) AS pet_sales
FROM ronin.core.ez_native_transfers n
JOIN ronin.core.fact_event_logs e
ON n.tx_hash = e.tx_hash
WHERE e.contract_address = '0xb806028b6ebc35926442770a8a8a7aeab6e2ce5c'
AND n.to_address = '0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3'
GROUP BY DATE_TRUNC('day', n.block_timestamp) -- Groups all transactions per day
ORDER BY date desc;
select *
from ronin.core.fact_event_logs e
join ronin.core.fact_transactions f
on e.tx_hash = f.tx_hash
where e.tx_hash ='0x25ba5f50c681b854e35382374f055d43e2302e2711e0799a5c17fe040d2b917e'
SELECT
f.amount,
e.tx_hash,
e.contract_address,
-- e.event_name,
e.origin_from_address AS event_from_address,
e.origin_to_address AS event_to_address,
f.block_timestamp,
f.from_address AS tx_from_address,
f.to_address AS tx_to_address,
-- f.tx_succeeded
FROM ronin.core.fact_event_logs e
JOIN ronin.core.ez_token_transfers f
Last run: about 1 month ago
...
166
7KB
12s