datavortexBy time of the week
Updated 2024-12-17
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
›
⌄
SELECT
CASE
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 1 THEN 1
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 2 THEN 2
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 3 THEN 3
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 4 THEN 4
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 5 THEN 5
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 6 THEN 6
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 0 THEN 7
END AS day_of_week_number,
CASE
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 1 THEN 'Sunday'
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 2 THEN 'Monday'
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 3 THEN 'Tuesday'
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 4 THEN 'Wednesday'
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 5 THEN 'Thursday'
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 6 THEN 'Friday'
WHEN EXTRACT(DAYOFWEEK FROM block_timestamp) = 0 THEN 'Saturday'
END AS day_of_week_name,
COUNT(DISTINCT tx_hash) AS total_swaps
FROM
kaia.defi.ez_dex_swaps
WHERE
platform = 'capybara'
GROUP BY
day_of_week_number, day_of_week_name
ORDER BY
day_of_week_number;
QueryRunArchived: QueryRun has been archived