PapasotTinyman 1.1 pools
    Updated 2022-01-28
    with tinymanpool as (

    select
    address,
    asset_name
    from algorand.account_asset
    where (asset_name like '%Tinyman' and asset_name like '%-ALGO%')
    ),

    asa_name as (
    select
    asset_id,
    asset_name,
    decimals
    from algorand.asset
    where decimals is not null )

    select
    asset_received,
    SUM(asset_amount) as swap_count
    from (
    select
    tx_id,
    t.asset_name as tinyman_pool,
    asset_receiver as users,
    n.asset_id ,
    n.asset_name as asset_received
    -- n.decimals,
    -- asset_amount,
    --asset_amount/ pow (10,n.decimals)

    from algorand.asset_transfer_transaction

    inner join tinymanpool t
    on sender = t.address

    Run a query to Download Data