SELECT

SOURCE_CHAIN , DESTINATION_CHAIN,

TO_VARCHAR(count(DISTINCT tx_hash), 'FM999,999,999,999') as swaps,

TO_VARCHAR(count(DISTINCT tx_hash)/count(DISTINCT BLOCK_TIMESTAMP::date) , 'FM999,999,999,999') as "Avg swaps per day",

TO_VARCHAR(count(DISTINCT tx_hash)/count(DISTINCT sender) , 'FM999,999,999,999') as "Avg swaps per user"

from axelar.defi.ez_bridge_squid

where

BLOCK_TIMESTAMP::date >= current_date - 365

and DESTINATION_CHAIN in ('assetmantle','osmosis','evmos','secret','archway','axelarnet','c4e','celestia','cosmoshub',

'chihuahu','chihuahua','comdex','crescentb','carbon','kujira','juno','dymensio','evmos','sei',

'terra2','stargaze','umee','agoric','injectiv','injective','kava','neutron','regen','secrets',

'teritori','terra')

GROUP by

order by count(DISTINCT tx_hash)

desc