lagandispensernumber of new users on Thorchain
    Updated 2022-06-28
    with liquidity as (
    select
    from_address,
    min (BLOCK_TIMESTAMP) as min_date
    from thorchain.liquidity_actions
    group by 1
    ),
    transfers as (
    select
    from_address,
    min (BLOCK_TIMESTAMP) as min_date
    from flipside_prod_db.thorchain.transfers
    where from_address not in (select distinct from_address from thorchain.liquidity_actions)
    group by 1
    ),

    ALL_ as (
    select min_date ,count (DISTINCT from_address) as num_users from liquidity group by 1
    UNION ALL
    select min_date ,count (DISTINCT from_address) as num_users from transfers group by 1
    )

    select
    date_trunc(week,min_date) as date ,
    sum (num_users) as num_new_users ,
    sum (num_new_users) over (order by date) as cum_new_users
    from all_
    group by 1
    Run a query to Download Data