where dt >= '2022-6-27'

group by dt)

, algofi as (select count(1) as cnt ,sum(swap_from_amount) as sm ,date_trunc('day', block_timestamp) as dt from algorand.swaps

where dt >= '2022-6-27' and swap_program='algofi'

group by dt)

, pactfi as (select count(1) as cnt ,sum(swap_from_amount) as sm ,date_trunc('day', block_timestamp) as dt from algorand.swaps

where dt >= '2022-6-27' and swap_program='pactfi'

group by dt)

, tinyman as (select count(1) as cnt ,sum(swap_from_amount) as sm ,date_trunc('day', block_timestamp) as dt from algorand.swaps

where dt >= '2022-6-27' and swap_program='tinyman'

group by dt)

, wagmiswap as (select count(1) as cnt ,sum(swap_from_amount) as sm ,date_trunc('day', block_timestamp) as dt from algorand.swaps

where dt >= '2022-6-27' and swap_program='wagmiswap'

group by dt)

, Alammex as (select count(1) as cnt , sum(tx_message:txn:amt/1e6) as sm ,date_trunc('day', block_timestamp) as dt

from algorand.transactions

where TRY_BASE64_DECODE_STRING(tx_message:txn:note) like '%group%'

group by dt)

select * from tinyman