SELECT
count (swap_to_asset_id) as total_asset_swap,
asset_name
from algorand.swaps
-- inner join algorand.asset on algorand.swaps.swap_to_asset_id = algorand.asset.asset_id
-- where block_timestamp >= '2022-01-01 00:00:00.000'
-- and swap_from_amount > '0'
-- and swap_program = 'tinyman'
-- group by asset_name
-- order by total_asset_swap desc
-- limit 10