Pools Performance

0xHaM-dPools Performance

Updated 8 days ago

-- 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

where HOUR::date>=current_date-30

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'

Last run: 8 days ago

	Rank	Pair	Total Volume ($)	Swapper Count	7D 🢒🢐 % Change	7D 🢒🢐 Vol	14D 🢒🢐 Vol	30D 🢒🢐 Vol	90D 🢒🢐 Vol	7D Swappers % Change	7D Swappers	14D Swappers	30D Swappers	90D Swappers	7D Tx	14D Tx	30D Tx	90D Tx	7D 🢒🢐 %
1	1	USDC/WRON	9741804.82	596	-42.7% 🔴	592876.4	1627117.3	9245942.9	9741804.8	85.7% 🟢	26	40	98	433	796	2039	9988	33316	-42.7
2	2	WRON/USDC	9386505.91	880	-48% 🔴	563394.6	1646145.2	9134244.6	9386505.9	26.1% 🟢	29	52	186	404	778	2048	9843	33578	-48
3	3	WETH/WRON	7631749.32	278	28.2% 🟢	1062404.1	1890855.4	7441552.8	7631749.3	130.0% 🟢	23	33	68	151	533	990	4495	17754	28.2
4	4	WRON/WETH	7557088.03	196	-19.1% 🔴	1064394.8	2380172.9	7419110.7	7557088	18.8% 🟢	19	35	75	120	703	1547	5038	21850	-19.1
5	5	USDC/WETH	4742412.98	5527	-30.2% 🔴	352696.7	857967.6	4570408.9	4742413	14.8% 🟢	209	391	945	2901	1347	3157	13285	37849	-30.2
6	6	WRON/AXS	4124725.41	147	-22.1% 🔴	588448.8	1344256	4079980.7	4124725.4	150.0% 🟢	15	21	45	85	495	1086	3620	13930	-22.1
7	7	WETH/USDC	3945239.26	11227	-25.9% 🔴	242163.2	568903.2	3871003.1	3945239.3	20.0% 🟢	617	1131	2069	5458	1667	3699	13931	37404	-25.9
8	8	AXS/WRON	3171195.81	346	-2.7% 🔴	458031	928844.6	3094474	3171195.8	7.1% 🟢	15	29	61	206	365	731	2791	12178	-2.7
9	9	WRON/WRON	2277414.21	14	22.7% 🟢	8955.5	16254.2	2204587.5	2277414.2	50.0% 🟢	3	5	8	9	179	432	6295	29828	22.7
10	10	WETH/AXS	1710305.24	20180	-12.5% 🔴	170494.6	365441.5	1674173.6	1710305.2	75.9% 🟢	2245	3521	5800	12537	4737	9060	20454	58333	-12.5

1KB

14s