Hadisehliquidity 2
    Updated 2022-08-25
    with t1 as (
    select distinct tx_hash, origin_from_address
    from ethereum.core.ez_token_transfers
    where origin_function_signature in ( '0xded9382a','0xe8e33700', '0xf305d719')
    and origin_to_address = '0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f'
    ),
    t2 as (
    select origin_from_address, count(*) as number_of_position
    from t1
    group by 1
    ),
    t3 as (
    select avg(number_of_position) as average_lp_position
    from t2
    )
    select average_lp_position
    from t3
    Run a query to Download Data