superflyUntitled Query
Updated 2022-08-24
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with MONOR as (SELECT * from ethereum.core.dim_dex_liquidity_pools ----I US GENERAL TABEL
where PLATFORM='sushiswap'),---ADDRESS contract platfrotm
KOJO as (SELECT distinct ORIGIN_FROM_ADDRESS as LP_providers,
count(distinct tx_hash) as positions---number of transactions by lp
from ethereum.core.ez_token_transfers
where TO_ADDRESS in (select POOL_ADDRESS from MONOR)
and ORIGIN_TO_ADDRESS='0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f'----native addres contract
and origin_function_signature in ('0xe8e33700', '0xded9382a', '0xf305d719')
group by 1)
select Avg(positions) as AVG from KOJO
Run a query to Download Data