Heminpools cotract
Updated 2022-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with pools as (
SELECT PLATFORM,
POOL_ADDRESS,
POOL_NAME
FROM ethereum.core.dim_dex_liquidity_pools
GROUP by 1,2,3
)
SELECT EVENT_NAME
FROM ethereum.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS in (SELECT pool_address from pools)
GROUP BY 1
-- SELECT COUNT(POOL_ADDRESS),
-- COUNT(POOL_NAME)
-- FROM ethereum.core.dim_dex_liquidity_pools
Run a query to Download Data