Delamir-6014E04 number new users per day of week
Updated 2022-11-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
29
30
31
32
33
34
35
36
›
⌄
with user_list as (
select
from_address as users,
min(block_timestamp) as min_date,
count(tx_hash) as txs
from ethereum_core.fact_transactions
group by 1
)
, U_2016 as (
select
dayname(to_date(min_date)) as Day_Of_Week ,
count(users) as User_2016
from user_list
where min_date >= '2016-01-01' and min_date < '2017-01-01'
group by 1
)
, U_2017 as (
select
dayname(to_date(min_date)) as Day_Of_Week ,
count(users) as User_2017
from user_list
where min_date >= '2017-01-01' and min_date < '2018-01-01'
group by 1
)
, U_2018 as (
select
dayname(to_date(min_date)) as Day_Of_Week ,
count(users) as User_2018
from user_list
where min_date >= '2018-01-01' and min_date < '2019-01-01'
group by 1
)
, U_2019 as (
select
dayname(to_date(min_date)) as Day_Of_Week ,
count(users) as User_2019
Run a query to Download Data