SELECT
BLOCK_TIMESTAMP::DATE as DATE,
CURRENCY,
TRANSFER_TYPE,
COUNT(DISTINCT TX_ID) as count
FROM
osmosis.core.fact_transfers
WHERE
RECEIVER LIKE 'axelar%'
AND
BLOCK_TIMESTAMP::DATE = '2022-10-20'
AND
TX_STATUS = 'SUCCEEDED'
GROUP BY DATE, CURRENCY ,TRANSFER_TYPE