binhachonTinyman Pool Health Score Card - Improved Stats - #2
    Updated 2022-06-23
    with pool_addresses as (
    select
    address,
    asset_id as lp_asset_id,
    address_name
    from flipside_prod_db.algorand.labels
    left join flipside_prod_db.algorand.asset on (creator_address = address)
    where label_subtype = 'pool'
    and label = 'tinyman'
    ),
    pool_asset as (
    select
    pool_addresses.address,
    address_name,
    lp_asset_id,
    asset_id,
    asset_name,
    amount
    from flipside_prod_db.algorand.account_asset
    inner join pool_addresses on (pool_addresses.address = flipside_prod_db.algorand.account_asset.address)
    and asset_closed = 'FALSE'
    and frozen = 'FALSE'
    union all
    select
    pool_addresses.address,
    address_name,
    lp_asset_id,
    0 as asset_id,
    'ALGO' as asset_name,
    balance
    from flipside_prod_db.algorand.account
    inner join pool_addresses on (pool_addresses.address = flipside_prod_db.algorand.account.address)
    where account_closed = 'FALSE'
    ),
    latest_price as (
    select
    Run a query to Download Data