JimMyersTech2024-01-12 04:56 PM
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
-- select
-- *
-- from crosschain.defi.dim_dex_liquidity_pools lp
-- inner join crosschain.defi.fact_dex_swaps s
-- on s.blockchain = lp.blockchain and s.platform = lp.platform
-- and s.fact_dex_swaps_id = lp.dim_dex_liquidity_pools_id
-- limit 1
-- group by 1
-- -- pools in dex swaps tables at least 100 swaps
with pools as (
select
ez_dex_swaps_id,
count(1) as swap_count
from crosschain.defi.fact_dex_swaps
group by 1
)
select count(1) from pools
where swap_count > 10
-- select count(1) from (
-- select EZ_DEX_SWAPS_ID, count(1) as swap_count
-- from crosschain.defi.ez_dex_swaps
-- group by 1
-- having swap_count > 10
-- ) sq
-- select
Run a query to Download Data