0xaimanSwap to, by Terra LP-ers
    Updated 2022-06-21


    select to_asset, count(from_address) as n_address
    from (with terralp as (select from_address
    from thorchain.liquidity_actions
    where lp_action='add_liquidity' and asset_amount>0 and pool_name like 'TERRA.%'),


    swap as (select block_timestamp, from_address, to_asset, to_amount
    from thorchain.swaps

    where from_asset='THOR.RUNE')

    select block_timestamp, terralp.from_address, to_asset, to_amount
    from terralp inner join swap on terralp.from_address=swap.from_address

    where block_timestamp>='2022-05-09')

    group by 1 order by 1

    Run a query to Download Data