binhachon22. [Elite] Network Shutdown - Address age - Liquidity provider
    Updated 2021-11-26
    with liquidity_remover as(
    select
    distinct from_address as 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%'
    ),
    address_table as(
    select
    block_timestamp,
    address,
    row_number() over (
    partition by address
    order by
    block_timestamp
    ) as row_number
    from
    (
    select
    block_timestamp,
    to_address as address
    from
    thorchain.transfers
    union
    select
    block_timestamp,
    from_address as address
    from
    thorchain.swaps
    union
    select
    block_timestamp,
    to_address as address
    Run a query to Download Data