maybeyonasthorstop_all_first_interaction
    Updated 2021-11-27
    with remover as (
    select distinct from_address as user from thorchain.liquidity_actions
    where
    block_timestamp >= '2021-11-17' and block_timestamp <= '2021-11-27'
    and lp_action = 'remove_liquidity'
    ),
    events as (
    select * from thorchain.liquidity_actions
    where from_address in (select user from remover)
    )


    select
    *
    from (
    select distinct * from (
    select
    from_address,
    last_value(block_timestamp) over (partition by from_address order by block_timestamp desc) as first_interaction
    from events
    )
    )

    Run a query to Download Data