(SELECT date(block_timestamp) as day, swap_program,swap_to_asset_id, count(*) as total_transactions

from algorand.swaps

Where year(block_timestamp) = 2022

and swap_from_amount > 0 and swap_to_asset_id != '0'

and swap_from_amount > '0'

and swap_program = 'algofi'

group by 1,swap_program, swap_to_asset_id)

inner join algorand.asset

on asset_id = swap_to_asset_id