t1 AS (

SELECT y.tx_hash, event_name, origin_from_address,

CASE

WHEN y.contract_address = '0x5c0401e81bc07ca70fad469b451682c0d747ef1c' THEN 'AVAX'

WHEN y.contract_address = '0xf362fea9659cf036792c9cb02f8ff8198e21b4cb' THEN 'sAVAX'

WHEN y.contract_address = '0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce' THEN 'QI'

WHEN y.contract_address = '0x89a415b3d20098e6a6c8f7a59001c67bd3129821' THEN 'BTC.b'

WHEN y.contract_address = '0xe194c4c5ac32a3c9ffdb358d9bfd523a0b6d1568' THEN 'WBTC.e'

WHEN y.contract_address = '0x334ad834cd4481bb02d09615e7c11a00579a7909' THEN 'WETH.e'

WHEN y.contract_address = '0x4e9f683a27a6bdad3fc2764003759277e93696e6' THEN 'Link.e'

WHEN y.contract_address = '0xd8fcda6ec4bdc547c0827b8804e89acd817d56ef' THEN 'USDt'

WHEN y.contract_address = '0xc9e5999b8e75c3feb117f6f73e664b9f3c8ca65c' THEN 'USDT.e'

WHEN y.contract_address = '0xb715808a78f6041e46d61cb123c9b4a27056ae9c' THEN 'USDC'

WHEN y.contract_address = '0xbeb5d47a3f720ec0a390d04b4d41ed7d9688bc7f' THEN 'USDC.e'

WHEN y.contract_address = '0x835866d37afb8cb8f8334dccdaf66cf01832ff5d' THEN 'DAI.e'

END AS token,

CASE WHEN token IN ('AVAX', 'sAVAX', 'QI', 'WETH.e', 'Link.e', 'DAI.e') THEN 18

WHEN token IN ('BTC.b', 'WBTC.e') THEN 8

WHEN token IN ('USDt', 'USDT.e', 'USDC', 'USDC.e') THEN 6

END AS decimals

FROM

avalanche.core.fact_decoded_event_logs x

join avalanche.core.fact_event_logs y on x.tx_hash=y.tx_hash

WHERE y.block_timestamp > current_date - INTERVAL '{{n_months}} MONTHS' and event_removed = FALSE AND tx_status = 'SUCCESS' AND y.contract_address = origin_to_address

AND event_name IN ('Mint', 'Borrow', 'RepayBorrow', 'Redeem')

AND y.contract_address IN ('0x5c0401e81bc07ca70fad469b451682c0d747ef1c', '0xf362fea9659cf036792c9cb02f8ff8198e21b4cb', '0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce',

'0x89a415b3d20098e6a6c8f7a59001c67bd3129821', '0xe194c4c5ac32a3c9ffdb358d9bfd523a0b6d1568', '0x334ad834cd4481bb02d09615e7c11a00579a7909',

'0x4e9f683a27a6bdad3fc2764003759277e93696e6', '0xd8fcda6ec4bdc547c0827b8804e89acd817d56ef', '0xc9e5999b8e75c3feb117f6f73e664b9f3c8ca65c', '0xb715808a78f6041e46d61cb123c9b4a27056ae9c',

'0xbeb5d47a3f720ec0a390d04b4d41ed7d9688bc7f', '0x835866d37afb8cb8f8334dccdaf66cf01832ff5d')

),

t2 AS (

SELECT

logs.block_timestamp::date AS date,