SYMBOL_OUT | SWAPS | SWAPPERS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|---|
1 | USD₮0 | 3839 | 1514 | 1539003.14266978 | 400.886465921 |
2 | XVELO | 4883 | 925 | 909506.012208487 | 186.259678929 |
3 | CAT | 503 | 125 | 299517.99929093 | 595.463219266 |
4 | WETH | 1546 | 523 | 280973.617308614 | 181.742313912 |
5 | kBTC | 620 | 88 | 229646.289708927 | 370.397241466 |
6 | iETH | 26486 | 19449 | 134379.250735152 | 5.073595512 |
7 | DINERO | 292 | 104 | 12194.83226831 | 41.763124207 |
8 | PURPLE | 40 | 29 | 9078.716087452 | 226.967902186 |
9 | Kraken | 145 | 30 | 3638.724634618 | 25.094652653 |
10 | MYST | 4 | 2 | 2907.901352917 | 726.975338229 |
11 | PRL | 9 | 6 | 1179.522359112 | 131.058039901 |
12 | PENK | 4 | 2 | 381.41253125 | 95.353132812 |
13 | ADUX | 1 | 1 | 327.56475 | 327.56475 |
14 | GRAPE | 5 | 1 | 172.9921875 | 34.5984375 |
15 | SHROOMY | 16 | 15 | 149.303556272 | 9.331472267 |
16 | KRILL | 4 | 1 | 86.494787917 | 21.623696979 |
17 | Worm | 1 | 1 | 81.8911875 | 81.8911875 |
18 | VIOLET | 47 | 8 | 70.444733894 | 1.498824125 |
19 | LIT | 2 | 1 | 45.329347324 | 22.664673662 |
20 | AK47 | 9 | 9 | 10.28518545 | 1.142798383 |
Afonso_DiazBy symbol out
Updated 2025-04-08
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
pricet as (
select
hour::date as date,
token_address,
avg(price) as token_price_usd
from
ink.price.ez_prices_hourly
group by 1, 2
),
txns as (
select
tx_hash,
block_timestamp,
origin_from_address as swapper,
a.contract_address as token_out,
b.contract_address as token_in,
nvl(a.decoded_log:value, a.decoded_log:wad) as amount_out_unadj,
nvl(b.decoded_log:value, b.decoded_log:wad) as amount_in_unadj
from
ink.core.ez_decoded_event_logs a
join
ink.core.ez_decoded_event_logs b using (tx_hash, block_timestamp, event_name)
where
a.event_name = 'Transfer'
and nvl(a.decoded_log:from, a.decoded_log:src) = swapper
and nvl(b.decoded_log:to, b.decoded_log:dst) = swapper
and tx_succeeded
and origin_to_address = '0x652e53c6a4fe39b6b30426d9c96376a105c89a95'
and tx_hash in (select distinct tx_hash from ink.core.ez_decoded_event_logs where event_name = 'Swap')
union all
select
Last run: about 2 months ago
24
1KB
27s