Yousefi_1994Number of stack amount and address for all goBTC and goETH pools
Updated 2022-05-22
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
31
32
33
34
35
36
›
⌄
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