asset.asset_name as SWAP_FROM_ASSET_NAME, asset2.asset_name as SWAP_TO_ASSET_NAME,

count(case when swap_from_amount > 0 then 1 else 0 end) as swaps,

sum(swap_from_amount), sum(swap_to_amount)

from algorand.swaps swaps

left join algorand.asset asset on swaps.swap_from_asset_id = asset.asset_id

left join algorand.asset asset2 on swaps.swap_to_asset_id = asset2.asset_id

where

swaps.block_timestamp::Date > dateadd(day, -30, current_date())

and swaps.swap_to_asset_id = {{ASA_ID}}

group by date, --dex,

SWAP_FROM_ASSET_NAME, SWAP_TO_ASSET_NAME