DATE | NEW_TRADERS | CUMULATIVE_TRADERS | |
|---|---|---|---|
1 | 2025-05-27 00:00:00.000 | 12 | 23140 |
2 | 2025-05-26 00:00:00.000 | 24 | 23128 |
3 | 2025-05-25 00:00:00.000 | 23 | 23104 |
4 | 2025-05-24 00:00:00.000 | 19 | 23081 |
5 | 2025-05-23 00:00:00.000 | 27 | 23062 |
6 | 2025-05-22 00:00:00.000 | 67 | 23035 |
7 | 2025-05-21 00:00:00.000 | 27 | 22968 |
8 | 2025-05-20 00:00:00.000 | 28 | 22941 |
9 | 2025-05-19 00:00:00.000 | 15 | 22913 |
10 | 2025-05-18 00:00:00.000 | 28 | 22898 |
11 | 2025-05-17 00:00:00.000 | 26 | 22870 |
12 | 2025-05-16 00:00:00.000 | 48 | 22844 |
13 | 2025-05-15 00:00:00.000 | 51 | 22796 |
14 | 2025-05-14 00:00:00.000 | 39 | 22745 |
15 | 2025-05-13 00:00:00.000 | 41 | 22706 |
16 | 2025-05-12 00:00:00.000 | 99 | 22665 |
17 | 2025-05-11 00:00:00.000 | 21 | 22566 |
18 | 2025-05-10 00:00:00.000 | 43 | 22545 |
19 | 2025-05-09 00:00:00.000 | 59 | 22502 |
20 | 2025-05-08 00:00:00.000 | 43 | 22443 |
Ali3NNew & Total $KET Traders in Avalanche DEXs Over Time
Updated 1 day ago
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 date_trunc (day,block_timestamp) as day,
'0xffff003a6bad9b743d658048742935fffe2b6ed7' as token_address,
'KET' as symbol,
'18' as decimals,
avg (amount_in_usd/amount_out) as USDPrice
from avalanche.defi.ez_dex_swaps
where (symbol_in = 'WAVAX' or symbol_in ilike 'USDC')
and (symbol_out = 'KET' or token_out = '0xffff003a6bad9b743d658048742935fffe2b6ed7')
and block_timestamp >= '2025-02-05'
group by 1,2,3,4 having USDPrice < 10
union all
select hour::date as day,
token_address,
'USDC' as symbol,
decimals,
avg (price) as usdprice
from avalanche.price.ez_prices_hourly
where token_address ilike '0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E'
group by 1,2,3,4),
SimpleSwap as (
SELECT
block_timestamp,
tx_hash,
decoded_log:maker as maker,
decoded_log:makerAsset as makerAsset,
decoded_log:makerAmountReceived as makerAmountReceived,
decoded_log:taker as taker,
decoded_log:takerAsset as takerAsset,
decoded_log:takerAmountReceived as takerAmountReceived,
decoded_log
FROM
avalanche.core.ez_decoded_event_logs
Last run: 1 day agoAuto-refreshes every 24 hours
...
133
5KB
117s