Hadisehliquidity 2
Updated 2022-08-25Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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