maybeyonasthorchain_daily_remove
    Updated 2021-11-11
    with lp_actions as (
    select
    date(block_timestamp) as date,
    lp_action,
    count(distinct from_address) as users
    from thorchain.liquidity_actions
    group by 1,2
    ),
    add_liq as (
    select * from lp_actions
    where lp_action = 'add_liquidity'
    ),
    remove_liq as (
    select * from lp_actions
    where lp_action = 'remove_liquidity'
    )

    select
    a.date,
    a.users as add_users,
    -r.users as rem_users,
    r.users*100/a.users as remove_percent
    from add_liq a join remove_liq r on a.date=r.date

    Run a query to Download Data