SELECT

sum(amount / pow(10, 6)) AS received_amount,

date(block_timestamp) as date1

FROM axelar.core.fact_transfers

WHERE receiver LIKE 'axelar%' AND

currency = 'uaxl' AND

tx_succeeded = TRUE

GROUP BY 2

),

axelar_sent AS (

SELECT

SUM(amount / pow(10, 6)) AS send_amount,

date(block_timestamp ) as date2

FROM axelar.core.fact_transfers

WHERE sender LIKE 'axelar%' AND

currency = 'uaxl' AND

tx_succeeded = TRUE

GROUP BY 2

SELECT * FROM axelar_received join axelar_sent on axelar_received.date1=axelar_sent.date2

order by date2 DESC

limit 1000