Yousefi_1994Number of stack amount and address for all goBTC and goETH pools
    Updated 2022-05-22
    with algoFi_lp as (
    select asset_name, asset_id from algorand.asset
    where lower(asset_name) like any ('%goeth-stbl%', '%gobtc-stbl%')
    and lower(asset_name) like '%af-pool%'
    group by asset_name, asset_id
    ),
    pact_lp as (
    select asset_name, asset_id from algorand.asset
    where lower(asset_name) like any ('%algo/gobtc%', '%algo/goeth%')
    and lower(asset_name) like '%pact lp%'
    group by asset_name, asset_id
    ),
    tinyman_lp as (
    select asset_name, asset_id from algorand.asset
    where lower(asset_name) like any ('%algo-gobtc%', '%algo-goeth%')
    and lower(asset_name) like '%tinyman%'
    group by asset_name, asset_id
    ),
    folks_lp as (
    select asset_name, asset_id from algorand.asset
    where lower(asset_name) like any ('%folks gobtc%', '%folks goeth%')
    and lower(asset_name) like '%folks%'
    group by asset_name, asset_id
    ),
    all_goBTC_and_goETH_pools as (
    select * from algoFi_lp
    union
    select * from pact_lp
    union
    select * from tinyman_lp
    union
    select * from folks_lp
    )
    select
    all_goBTC_and_goETH_pools.asset_name as asset_pool_name,
    count(distinct(address)) as pool_address,
    Run a query to Download Data