binhachon22. [Elite] Network Shutdown - Ethereum holder
    Updated 2021-11-27
    with exit_transactions as(
    select
    tx_id
    from
    (
    select
    tx_id,
    count(tx_id) as count
    from
    thorchain.swap_events
    where
    block_timestamp > '2021-11-17T00:00:00Z'
    and block_timestamp < '2021-11-25T00:00:00Z'
    group by
    tx_id
    )
    where
    count = 1
    ),
    liquidity_remover as(
    select
    distinct from_address
    from
    thorchain.liquidity_actions
    where
    block_timestamp > '2021-11-17T00:00:00Z'
    and block_timestamp < '2021-11-25T00:00:00Z'
    and lp_action = 'remove_liquidity'
    and from_address not like '%thor%'
    ),
    crosschain_address as(
    select
    distinct crosschain_address
    from
    (
    select
    Run a query to Download Data