QUINTILE | NUMBER_OF_TRANSACTIONS | MIN_AMOUNT | MAX_AMOUNT | AVG_AMOUNT | |
|---|---|---|---|---|---|
1 | 1 | 229185 | 0 | 0.4 | 0.1060816371 |
2 | 2 | 229185 | 0.4 | 2.85 | 1.68345184 |
3 | 3 | 229185 | 2.85 | 28.82 | 10.701654864 |
4 | 4 | 229185 | 28.82 | 484.18 | 143.806905295 |
5 | 5 | 229184 | 484.19 | 234403.23 | 1209.920592852 |
0xa9d8a579F546522cb3f02F0b2ddBf692A954B89asole-coffee
Updated 2025-03-07
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 dex_list as (
select
distinct address_name as address_name,
address,
label_type,
label_subtype,
label,
SPLIT_PART(address_name, ':', 1) AS protocol_name
from
ink.core.dim_labels
where
label_type = 'dex'
),
dex_txns as (
select
tt.block_timestamp,
case
when tt.from_address in (select address from dex_list) then tt.to_address
when tt.to_address in (select address from dex_list) then tt.from_address
else null
end as user_address,
dl.protocol_name,
tt.token_standard,
tt.name,
tt.symbol,
tt.amount_usd,
ntile(5) over (order by tt.amount_usd) as quintile
from
ink.core.ez_token_transfers tt
left join dex_list dl
on tt.from_address = dl.address
or tt.to_address = dl.address
where
tt.from_address in (select address from dex_list)
or tt.to_address in (select address from dex_list)
and tt.amount_usd is not null
Last run: about 2 months ago
5
178B
5s