WAVAX_ON_AVAX AS (

SELECT

BLOCK_TIMESTAMP::date as DAY1,

SUM(RAW_AMOUNT) AS VOLOME_WAVAX_AVAXCHAIN

FROM

avalanche.core.fact_token_transfers

WHERE

CONTRACT_ADDRESS = '0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7'

AND DAY1 >= '2023-01-26'

GROUP BY

DAY1

ORDER BY

DAY1 ASC

),

WAVAX_ON_OSMO AS (

SELECT

block_timestamp::date AS DAY2,

(SUM(FROM_AMOUNT) + SUM(TO_AMOUNT)) AS VOLUME_WAVAX_OSMO

FROM

osmosis.core.fact_swaps

WHERE

FROM_CURRENCY = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373'

OR TO_CURRENCY = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373'

AND TX_SUCCEEDED = 'TRUE'

AND DAY2 >= '2023-01-26'

GROUP BY

DAY2

ORDER BY

DAY2 ASC

)

DAY1 AS DAY,

SUM(VOLOME_WAVAX_AVAXCHAIN) AS VOLUME_ON_AXAV,

SUM(VOLUME_WAVAX_OSMO) AS VOLUME_ON_OSMO