maybeyonasthordrop_eth_first_action
    Updated 2021-11-27
    WITH
    eth_removers as (
    select distinct from_address from thorchain.liquidity_actions
    where
    lp_action = 'remove_liquidity'
    -- and split(pool_name,'.')[0]::string = 'ETH'
    and split(from_address,'x')[0]::string = '0'
    and block_timestamp >= '2021-11-17'
    and block_timestamp <= '2021-11-27'
    ),
    events as (
    select *
    from ethereum.udm_events
    where origin_address in (select from_address from eth_removers)
    and contract_address in (
    '0x69fa0fee221ad11012bab0fdb45d444d3d2ce71c',
    '0xebcd3922a199cd1358277c6458439c13a93531ed',
    '0xa5f2211b9b8170f694421f2046281775e8468044'
    )
    )

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



    Run a query to Download Data