SELECT

BLOCK_TIMESTAMP::date AS date,

TX_ID as ID,

CASE

WHEN TRANSFER_TYPE = 'IBC_TRANSFER_IN' THEN 'Incoming TXN'

WHEN TRANSFER_TYPE = 'IBC_TRANSFER_OUT' THEN 'Outgoing TXN'

END AS transaction_type

FROM

axelar.core.fact_transfers

WHERE

TX_SUCCEEDED = 'TRUE'

AND TRANSFER_TYPE = 'IBC_TRANSFER_IN' OR TRANSFER_TYPE = 'IBC_TRANSFER_OUT'

), txns AS (

SELECT

transfers.date,

transfers.transaction_type,

transactions.FEE/POW(10, 6) AS fee

FROM transfers

LEFT JOIN (

SELECT TX_ID, FEE FROM axelar.core.fact_transactions

) transactions

ON transfers.id = transactions.TX_ID

), incoming AS (

SELECT

date,

SUM(fee) AS fee

FROM txns

WHERE transaction_type = 'Incoming TXN'

AND date > CURRENT_DATE - (SELECT 30 * {{Months}})

GROUP BY date

), outgoing AS (

SELECT

date,

SUM(fee) AS fee

FROM txns