PapasotTinyman 1.1 Launch Swaps (Algo volume)
    Updated 2023-01-03
    with tinymanpool as (

    select
    address,
    asset_name
    from algorand.account_asset
    where (asset_name like '%TinymanPool1.1' 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,
    count(distinct tx_id) 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