binhachon32. [Easy] LP Duration - chart
    Updated 2021-12-18
    with thorchain_liquidity_actions as (
    select
    block_timestamp,
    from_address as address,
    rune_amount_usd + asset_amount_usd as amount
    from
    thorchain.liquidity_actions
    where
    lp_action = 'add_liquidity'
    union all
    select
    block_timestamp,
    from_address as address,
    -(rune_amount_usd + asset_amount_usd) as amount
    from
    thorchain.liquidity_actions
    where
    lp_action = 'remove_liquidity'
    ),
    lpers_list as(
    select
    blocktime,
    address,
    sum(amount) over (partition by address) as latest_net_amount
    from (
    select
    date_trunc('day', block_timestamp) as blocktime,
    address,
    sum(amount) as amount
    from
    thorchain_liquidity_actions
    group by
    blocktime,
    address
    )

    Run a query to Download Data