JimMyersTech2024-01-12 04:56 PM

    -- 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