Delamir-6014E04 number new users per day of week
    Updated 2022-11-17
    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