Assets Swapped to $KET by Volume [USD]

SniperAssets Swapped to $KET by Volume [USD]

Updated 3 days ago

select

TOKEN_in,

SYMBOL_in,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users,

count(DISTINCT TX_HASH) as transactions,

count(*) as swap,

sum(AMOUNT_IN) as volume_avax,

sum(AMOUNT_IN_USD) as volume_usd,

avg(AMOUNT_IN_USD) as avg_volume_usd,

from avalanche.defi.ez_dex_swaps

where AMOUNT_IN_USD is NOT NULL

and

--TOKEN_in = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')

--OR

TOKEN_out = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')

group by 1,2

Last run: 3 days ago

	TOKEN_IN	SYMBOL_IN	USERS	TRANSACTIONS	SWAP	VOLUME_AVAX	VOLUME_USD	AVG_VOLUME_USD
1	0xd036414fa2bcbb802691491e323bff1348c5f4ba	MU	1069	6679	6681	478370.360526564	33533.29	5.019202215
2	0x4d6ec47118f807ace03d3b3a4ee6aa96cb2ab677	BNZ	441	5930	5932	293259982.906829	43795.45	7.3829147
3	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	USDC	1080	4009	6076	1376077.194024	1375928.48	226.453008558
4	0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd	BLUB	1	1	1	90.658362856	0.22	0.22
5	0x7698a5311da174a95253ce86c21ca7272b9b05f8	WINK	100	347	347	85416.664303431	7685.86	22.14945245
6	0x41cbfd7c8709d1e459ce816703a1fc882daa77d3	LOK	2	4	4	96.531030751	0.03	0.0075
7	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	WAVAX	19660	316274	406942	14652925.2003971	346052242.75	850.372393978
8	0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b	PHAR	335	1214	1214	44.735701253	20908.67	17.222957166
9	0xfc6da929c031162841370af240dec19099861d3b	DOMI	7	11	11	32564.746542683	319.53	29.048181818
10	0x24de8771bc5ddb3362db529fc3358f2df3a0e346	avUSD	70	1097	1097	5039.169047151	5032.26	4.587292616
11	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	sAVAX	290	792	797	3845.226335154	111750.79	140.214291092
12	0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5	NOCHILL	1099	9110	9117	105837378.778563	336349.27	36.892538116
13	0x420fca0121dc28039145009570975747295f2329	COQ	143	784	784	163939042763.485	88360.01	112.704094388

1KB

flipside