Pmisha-bmlMdxtop.pools
Updated 2022-05-19
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
TO_ADDRESS_NAME as pool,
count(tx_id) as no_txn,
count(distinct FROM_ADDRESS) as total_users
FROM ethereum.udm_events
where (to_label = 'sushiswap')
AND TO_LABEL_SUBTYPE ilike 'pool'
and ORIGIN_FUNCTION_NAME in ('deposit','addLiquidityETH','addLiquidity')
and BLOCK_TIMESTAMP>=CURRENT_DATE-90
and FROM_ADDRESS_NAME is null
group by 1
order by 2 desc limit 10
Run a query to Download Data