N_TRADES | N_TRADERS | N_PAIRS | VOLUME_IN | VOLUME_OUT | FEE_AMOUNT_USD | AVG_VOL_PER_SWAP | AVG_FEE_PER_SWAP | |
|---|---|---|---|---|---|---|---|---|
1 | 84606765 | 84606765 | 8545 | 3947129998.50493 | 3947129998.50492 | 13234126.7531986 | 46.652652403 | 0.1564192503 |
0xHaM-dIn total copy
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
›
⌄
-- forked from In total @ https://flipsidecrypto.xyz/studio/queries/812266ce-e30a-46fd-b008-e1ba3d221c70
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='0x7d0556d55ca1a92708681e2e231733ebd922597d'
where ORIGIN_TO_ADDRESS in (
'0x30a6a80fed6d0d6c7412b82ef0ad03343f76b45f'
,'0xa35a88753a6a32fde5738c26644a383d29684b03'
,'0x41c7778f7472c0f3177732a1d71c3f0613074401'
,'0xa650570c41ee2f8448a40e2b45c92f5d2ba13d2f'
,'0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef5'
,'0x69e2099fbc9020f8dd29c2d959ca15e5d529f041'
,'0xca11bde05977b3631167028862be2a173976ca11'
,'0x77f96cf7b98b963fb8a9b84787806d396d953b2b'
,'0x8417ac6838be147ab0e201496b2e5edf90a48cc5'
,'0xf8cdefa80fa07e0f38dad87cb8c2679d3e00b227'
,'0x3bf61bac291e999813332340947942b74ab0dd92'
,'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3'
,'0x9d381565d0bfe916360a7e92f1cb686fb67f8902'
Last run: 2 months ago
1
103B
27s