select

distinct address

from algorand.account_app

where app_id = 552635992

),

algoasset1 as (

select

distinct tx_group_id,

asset_id,

sender

from algorand.asset_transfer_transaction

where tx_group_id is not null and sender in (

select address from tinyman_pool_address)

),

algoasset2 as (

select

x.block_id,

y.block_timestamp,

sender as address,

receiver as pool,

tx_id,

tx_group_id,

sum(amount) as amount

from algorand.payment_transaction x

left join algorand.block y on y.block_id = x.block_id

where x.block_id > 18718200 and amount > 0.1 and pool in (

select address from tinyman_pool_address) and tx_group_id is not null

group by 1,2,3,4,5,6

),

tinyman_swap_algo_for_asset as (

select

x.tx_group_id,

block_timestamp,

address,

sender,