flipside

    thorchain lp provide
    boomer77thorchain lp provide
    Updated 2021-11-30
    with claim as (select event_inputs:to::string as claimer, sum(event_inputs:value/1e18) as THOR_claimed
    from ethereum.events_emitted
    where event_inputs:from::string = '0x8526cec1d97a68c0e69420488d04dec5f101b46e' and tx_succeeded = 'TRUE'
    group by 1),

    lp as (select asset_address, sum(asset_amount) as THOR_LP, sum(rune_amount) as RUNE_LP
    from thorchain.liquidity_actions
    where pool_name = 'ETH.THOR-0XA5F2211B9B8170F694421F2046281775E8468044'
    and lp_action = 'add_liquidity'
    and asset_amount is not null
    and asset_address in (select claimer from claim)
    group by 1)

    select a.claimer, a.THOR_claimed, b.THOR_LP, b.rune_lp
    from claim a
    left outer join lp b on a.claimer = b.asset_address
    Run a query to Download Data