HosseinGrouping fee($ETH)
Updated 2023-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
CASE
WHEN tx_fee <= 0.00001 THEN '1. <= 0.00001'
WHEN tx_fee <= 0.000025 THEN '2. <= 0.00001 - 0.000025'
WHEN tx_fee <= 0.00005 THEN '3. <= 0.000025 - 0.00005'
WHEN tx_fee <= 0.000075 THEN '4. <= 0.00005 - 0.000075'
WHEN tx_fee <= 0.0001 THEN '5. <= 0.0000675 - 0.0001'
WHEN tx_fee <= 0.0002 THEN '6. <= 0.0001 - 0.0002'
ELSE '7. >= 0.0002'
END as FeeTypeETH,
COUNT(DISTINCT t1.tx_hash) as Txns
FROM
base.defi.ez_dex_swaps t1
JOIN base.core.fact_transactions t2 on t1.tx_hash = t2.tx_hash
WHERE
platform ilike 'curve'
GROUP BY
1
ORDER BY
1
Run a query to Download Data