alleria50. Swap n' Slippage Categorized
Updated 2022-01-30
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
›
⌄
WITH
slippages as (
SELECT
from_amount_usd,
CASE
WHEN from_amount_usd < 10 THEN 'a. Less than 10 USD'
WHEN from_amount_usd >= 10 AND from_amount_usd < 100 THEN 'b. 10 to 100 USD'
WHEN from_amount_usd >= 100 AND from_amount_usd < 1000 THEN 'c. 100 to 1000 USD'
WHEN from_amount_usd >= 1000 AND from_amount_usd < 10000 THEN 'd. 1000 to 10000 USD'
WHEN from_amount_usd >= 10000 AND from_amount_usd < 100000 THEN 'e. 10000 to 100000 USD'
WHEN from_amount_usd >= 100000 THEN 'f. More than 100000 USD'
END as category,
swap_slip_bp / 100 as slippage_percentage
FROM thorchain.swaps
WHERE block_timestamp > CURRENT_DATE - 7
)
SELECT
category,
count(from_amount_usd) as total_transactions,
avg(slippage_percentage) as average_slippage
FROM slippages
GROUP BY category
ORDER BY category ASC
Run a query to Download Data