BUY_COUNT | SELL_COUNT | BUY_RATE_PERCENT | SELL_RATE_PERCENT | |
---|---|---|---|---|
1 | 36606 | 50078 | 42.23 | 57.77 |
gigiokobaBUY AND SELL
Updated 2025-02-09
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
›
⌄
WITH buy_sell_data AS (
SELECT
CASE
WHEN TOKEN_OUT = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b' THEN 'buy'
WHEN TOKEN_IN = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b' THEN 'sell'
ELSE 'other'
END AS transaction_type
FROM
avalanche.defi.ez_dex_swaps
WHERE
TOKEN_OUT = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
OR TOKEN_IN = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
),
transaction_counts AS (
SELECT
COUNT(CASE WHEN transaction_type = 'buy' THEN 1 END) AS buy_count,
COUNT(CASE WHEN transaction_type = 'sell' THEN 1 END) AS sell_count,
COUNT(*) AS total_transactions
FROM
buy_sell_data
)
SELECT
buy_count,
sell_count,
ROUND((buy_count * 100.0 / total_transactions), 2) AS buy_rate_percent,
ROUND((sell_count * 100.0 / total_transactions), 2) AS sell_rate_percent
FROM
transaction_counts;
Last run: 14 days ago
1
27B
3s