N_TRADES | N_TRADERS | N_PAIRS | VOLUME_IN | VOLUME_OUT | FEE_AMOUNT_USD | AVG_VOL_PER_SWAP | AVG_FEE_PER_SWAP | |
|---|---|---|---|---|---|---|---|---|
1 | 1187780 | 110744 | 6433 | 316575757.896737 | 222740828.841372 | 239244.714985575 | 266.527267589 | 0.2014217405 |
0xHaM-dIn total
Updated 2025-02-14
999
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 priceTB as (
select
HOUR::date as p_date,
SYMBOL,
avg(PRICE) as price
from ronin.price.ez_prices_hourly
group by 1,2
)
, swap_from as (
SELECT
BLOCK_TIMESTAMP,
'Swap From' as swap_type,
TX_HASH,
ORIGIN_FROM_ADDRESS as trader,
t.SYMBOL as SYMBOL_in,
AMOUNT_USD,
AMOUNT*price as AMOUNT_USD_IN
FROM ronin.core.ez_token_transfers t
LEFT JOIN priceTB p on t.SYMBOL=p.SYMBOL and trunc(t.BLOCK_TIMESTAMP, 'd')=p.p_date
where ORIGIN_TO_ADDRESS in (
'0x30a6a80fed6d0d6c7412b82ef0ad03343f76b45f'
,'0xa35a88753a6a32fde5738c26644a383d29684b03'
,'0x41c7778f7472c0f3177732a1d71c3f0613074401'
,'0xa650570c41ee2f8448a40e2b45c92f5d2ba13d2f'
,'0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef5'
,'0x69e2099fbc9020f8dd29c2d959ca15e5d529f041'
,'0xca11bde05977b3631167028862be2a173976ca11'
,'0x77f96cf7b98b963fb8a9b84787806d396d953b2b'
,'0x8417ac6838be147ab0e201496b2e5edf90a48cc5'
,'0xf8cdefa80fa07e0f38dad87cb8c2679d3e00b227'
,'0x3bf61bac291e999813332340947942b74ab0dd92'
,'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3'
,'0x9d381565d0bfe916360a7e92f1cb686fb67f8902'
,'0x133fa77dea36b311292201efddfc58cbe3a140b7'
,'0x3f85806aebb32c7404b4fb606413434cd830d7e1'
,'0x53085f09d0ae92d20c175ccc3c7a6545eeaccabb'
Last run: about 1 month ago
1
101B
8s