TYPE | TX_TYPE | TRANSACTIONS | |
|---|---|---|---|
1 | Buy | Crab ($50 - $100) | 80416 |
2 | Buy | Dolphin ($1,000 - $5,000) | 56944 |
3 | Buy | Fish ($500 - $1,000) | 50069 |
4 | Buy | Giant Squid (More than $100,000) | 28488 |
5 | Buy | Octopus ($100 - $500) | 139757 |
6 | Buy | Plankton (Less than $10) | 370728 |
7 | Buy | Shark ($5,000 - $10,000) | 7361 |
8 | Buy | Shrimp ($10 - $50) | 207116 |
9 | Buy | Whale ($10,000 - $100,000) | 2805 |
10 | Sell | Crab ($50 - $100) | 70742 |
11 | Sell | Dolphin ($1,000 - $5,000) | 51745 |
12 | Sell | Fish ($500 - $1,000) | 42962 |
13 | Sell | Giant Squid (More than $100,000) | 27698 |
14 | Sell | Octopus ($100 - $500) | 119205 |
15 | Sell | Plankton (Less than $10) | 223015 |
16 | Sell | Shark ($5,000 - $10,000) | 7841 |
17 | Sell | Shrimp ($10 - $50) | 188363 |
18 | Sell | Whale ($10,000 - $100,000) | 3411 |
Afonso_DiazSwaps Breakdown
Updated 2025-03-29
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
main as (
select
tx_hash,
block_timestamp,
origin_from_address as user,
iff(token_in = lower('0x9a26f5433671751c3276a065f57e5a02d2817973'), 'Sell', 'Buy') as type,
nvl(amount_in_usd, amount_out_usd) as amount_usd,
symbol_in,
symbol_out
from
base.defi.ez_dex_swaps
where
lower('0x9a26f5433671751c3276a065f57e5a02d2817973') in (token_in, token_out)
)
select
type,
case
when amount_usd < 10 then 'Plankton (Less than $10)'
when amount_usd <= 50 then 'Shrimp ($10 - $50)'
when amount_usd <= 100 then 'Crab ($50 - $100)'
when amount_usd <= 500 then 'Octopus ($100 - $500)'
when amount_usd <= 1000 then 'Fish ($500 - $1,000)'
when amount_usd <= 5000 then 'Dolphin ($1,000 - $5,000)'
when amount_usd <= 10000 then 'Shark ($5,000 - $10,000)'
when amount_usd <= 100000 then 'Whale ($10,000 - $100,000)'
else 'Giant Squid (More than $100,000)'
end as tx_type,
count(distinct tx_hash) as transactions
from
main
group by 1, 2
order by 1, 2
Last run: 28 days ago
18
732B
7s