RON_VOLUME | VOLUME_USD | PET_SALES | |
|---|---|---|---|
1 | 58275.934175754 | 193881.727228082 | 974 |
permarydecisive-emerald
Updated 2025-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
SUM(DISTINCT n.amount) AS ron_volume,
SUM(DISTINCT 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 IN (
'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3',
'0x3ef234bc2a04d86f6041e419458d9acbd077f2c1',
'0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc'
);
Last run: 19 days ago
1
40B
6s