select block_timestamp::date as fecha,

sum(swap_to_amount) as swap_to_goBTC

from algorand.swaps

where swap_to_asset_id in (386192725)

and fecha >= '2021-10-01'

group by 1

order by 1

),

SWAPPEDFROM_BTC as (

select block_timestamp::date as fecha,

sum(swap_from_amount) as swap_from_goBTC

from algorand.swaps

where swap_from_asset_id in (386192725)

and fecha >= '2021-10-01'

group by 1

order by 1

),

SWAPPEDTO_ETH as (

select block_timestamp::date as fecha,

sum(swap_to_amount) as swap_to_goETH

from algorand.swaps

where swap_to_asset_id in (386195940)

and fecha >= '2021-10-01'

group by 1

order by 1

),

SWAPPEDFROM_ETH as (

select block_timestamp::date as fecha,

sum(swap_from_amount) as swap_from_goETH

from algorand.swaps

where swap_from_asset_id in (386195940)

and fecha >= '2021-10-01'