dayvidjoshUntitled Query
Updated 2023-02-21
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 T1 AS (
SELECT * FROM ethereum.core.ez_dex_swaps
WHERE date(block_timestamp) BETWEEN '2023-01-01' AND '2023-01-31'
)
SELECT
date(BLOCK_TIMESTAMP) AS "Date",
CASE
WHEN platform = 'uniswap-v2' THEN 'Uniswap'
WHEN platform = 'uniswap-v3' THEN 'Uniswap'
WHEN platform = 'sushiswap' THEN 'Sushiswap'
ELSE 'Others'
END AS "DEX",
SUM(amount_in_usd - amount_out_usd) AS "Daily Transactions Volume in USD",
COUNT (DISTINCT sender) AS "Daily Unique Users",
COUNT (_LOG_ID) AS "No of Transactions in a day"
FROM T1
WHERE PLATFORM = 'uniswap-v2' OR PLATFORM = 'uniswap-v3' OR PLATFORM = 'sushiswap'
GROUP BY 1,2
ORDER BY 1
;
WITH T2 AS (
SELECT * FROM ethereum.core.ez_dex_swaps
WHERE DATE(block_timestamp) BETWEEN '2023-01-01' AND '2023-01-31'
)
SELECT
DATE(BLOCK_TIMESTAMP) AS "Date",
CASE
WHEN PLATFORM = 'uniswap-v2' THEN 'Uniswap'
WHEN PLATFORM = 'uniswap-v3' THEN 'Uniswap'
WHEN PLATFORM = 'sushiswap' THEN 'Sushiswap'
ELSE 'Others'
END AS "DEX",
Run a query to Download Data