SYMBOL_OUT | CONTRACT_OUT | TRADING_VOLUME | TOTAL_SWAPPER | |
|---|---|---|---|---|
1 | WETH | 0x4200000000000000000000000000000000000006 | 5666372.72 | 351 |
2 | USDC.e | 0xf1815bd50389c46847f0bda824ec8da914045d14 | 4506364.36 | 234 |
3 | USD₮0 | 0x0200c29006150606b650577bbe7b6248f58470c1 | 4285962.23 | 120 |
4 | kBTC | 0x73e0c0d45e048d25fc26fa3159b0aa04bfa4db98 | 883772.09 | 47 |
5 | XVELO | 0x7f9adfbd38b669f03d1d11000bc76b9aaea28a81 | 14458.43 | 16 |
6 | iETH | 0x11476323d8dfcbafac942588e2f38823d2dd308e | 3537.78 | 207 |
7 | PURPLE | 0xd642b49d10cc6e1bc1c6945725667c35e0875f22 | 2084.78 | 13 |
8 | PSD | 0xcea0f8ed85e4eb981406e84ddca7062946093089 | 383.62 | 3 |
9 | MYST | 0xee73d2f34d66f0f07af6ab37b42713520e33119c | 250.54 | 4 |
10 | Kraken | 0xca5f2ccbd9c40b32657df57c716de44237f80f05 | 219.49 | 12 |
11 | CAT | 0x20c69c12abf2b6f8d8ca33604dd25c700c7e70a5 | 218.73 | 3 |
12 | Arch | 0xb816f5951a2e568d6eae351443c789c4f9fb55a7 | 197.02 | 7 |
13 | PPR | 0xa7f8eb24a006ed524054a2f8075280d0e6d380c4 | 180.22 | 1 |
14 | SHROOMY | 0x0c5e2d1c98cd265c751e02f8f3293bc5764f9111 | 149.38 | 4 |
15 | POKE | 0x03792f3c7841c901916cb76882fb5a9e1902ab69 | 111.92 | 1 |
16 | SQUIDS | 0xbf0cafcbaaf0be8221ae8d630500984edc908861 | 99.69 | 8 |
17 | AK47 | 0x2a1bce657f919ac3f9ab50b2584cfc77563a02ec | 60.79 | 2 |
18 | Worm | 0x2dc2b752f4c6dffe2dbcf60b848b8357a8879a01 | 28.91 | 7 |
19 | GMINKY | 0x44c497597aa32f5f2b7edb91522f321f04f03cd7 | 10.63 | 1 |
20 | VIOLET | 0x487efe1c71712c45e493a9b5d60dddf852ddd48c | 0.99 | 1 |
tkvresearchez_dex_swap_ink
Updated 2025-04-01
99
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 list_contract_1 as
(select *
from $query('8eb7caf1-bd6d-4ee1-963b-c96fa111d91e')),
list_contract_2 as
(select *
from $query('c98c2c80-e1bf-42a7-83bc-0bdcfda77afe')),
user_buy as
(select date(block_timestamp) as datetime,
tx_hash,
-- from_address,
to_address,
contract_address as contract_out,
symbol as symbol_out,
max(amount) as amount_out,
max(amount_usd) as amount_usd_out
from ink.core.ez_token_transfers
where from_address in (select pool_contract from list_contract_1)
or
from_address in (select pair from list_contract_2)
group by 1,2,3,4,5
),
user_sell as
(select date(block_timestamp) as datetime,
tx_hash,
from_address,
--to_address,
contract_address as contract_in,
symbol as symbol_in,
max(amount) as amount_in,
max(amount_usd) as amount_usd_in
from ink.core.ez_token_transfers
where to_address in (select pool_contract from list_contract_1)
or
Last run: 27 days ago
27
2KB
3s