binhachonTinyman 1.1 Launch Pools - liquidity
    Updated 2022-01-28
    with tinyman_pool_address as (
    select distinct address from algorand.account_app where app_id = 552635992
    ),
    lp_mint_tx as (
    select
    distinct tx_group_id
    from algorand.application_call_transaction
    where tx_message:txn:apaa[0]::string = 'bWludA=='
    and app_id = 552635992
    ),
    lp_mint_tx_with_count as (
    select
    tx_group_id,
    count(tx_group_id) as txs_count
    from algorand.asset_transfer_transaction
    where tx_group_id in (select tx_group_id from lp_mint_tx)
    group by tx_group_id
    ),
    lp_burn_tx as (
    select
    distinct tx_group_id
    from algorand.application_call_transaction
    where tx_message:txn:apaa[0]::string = 'YnVybg=='
    and app_id = 552635992
    ),
    lp_burn_tx_with_count as (
    select
    tx_group_id,
    count(tx_group_id) as txs_count
    from algorand.asset_transfer_transaction
    where tx_group_id in (select tx_group_id from lp_burn_tx)
    group by tx_group_id
    ),
    tinyman_lp_algo_transactions as (
    select
    algorand.payment_transaction.block_id,
    Run a query to Download Data