maybeyonasthor_net_lp_add
    Updated 2021-12-18
    with events as (
    select
    block_timestamp,
    lp_action,
    split(pool_name,'-')[0]::string as pool_name,
    from_address,
    -- to_address,
    rune_amount_usd+asset_amount_usd as usd_moved
    from thorchain.liquidity_actions
    )
    -- limit 100

    select
    date(block_timestamp) as date,
    -- pool_name,
    sum(usd_moved) as liq_added,
    count(distinct from_address) as lp_adders
    from events
    where lp_action = 'add_liquidity'
    group by 1--,2
    -- limit 100
    Run a query to Download Data