Metiocrethorchain liquidity added [Asset-only] Daily by pool
    Updated 2022-05-27
    select
    block_timestamp::date as date,
    pool_name,
    sum(rune_amount_usd + asset_amount_usd) as usd_amount,
    sum(1) as count,
    avg(rune_amount_usd + asset_amount_usd) as average
    from flipside_prod_db.thorchain.liquidity_actions
    where lp_action='add_liquidity'
    and rune_amount = 0 and asset_amount > 0
    and block_timestamp::date >='2022-01-01'
    group by 1,2

    Run a query to Download Data