flipside

    Copy of Thor liq pct
    mohammadhCopy of Thor liq pct
    Updated 2021-11-16
    WITH liquidity_add as (SELECT block_timestamp as add_timestamp, from_address FROM thorchain.liquidity_actions
    WHERE lp_action = 'add_liquidity'),

    liquidity_remove as (SELECT block_timestamp as remove_timestamp, from_address FROM thorchain.liquidity_actions
    WHERE lp_action = 'remove_liquidity')

    SELECT
    COUNT (DISTINCT a.from_address) as add_liquidity_count,
    COUNT (DISTINCT r.from_address) as remove_liquidity_count,
    (remove_liquidity_count / add_liquidity_count) * 100 as remove_to_add_percent
    FROM
    liquidity_add a,
    liquidity_remove r
    Run a query to Download Data