'osmosis_pool' AS pool,

count(*) AS swaps_volume,

sum(from_amount/1e18) AS swapped_wavax,

sum(from_amount/1e18 * 20) AS swapped_wavax_usd,

count(DISTINCT trader) AS traders

FROM osmosis.core.fact_swaps

WHERE pool_ids = ['899']

AND from_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373'

GROUP BY 1,2),

sushi_ava AS ( SELECT date_trunc('day', block_timestamp) AS date2,

'sushi_pools' AS pool2,

count(*) AS swaps_volume2,

sum(amount_in) AS swapped_wavax2,

sum(amount_in_usd) AS swapped_wavax_usd2,

count(DISTINCT sender) AS traders2

FROM avalanche.sushi.ez_swaps

WHERE symbol_in = 'WAVAX'

AND event_name = 'Swap'

GROUP BY 1,2

SELECT date1 AS period,

swapped_wavax AS osmosis_wavax,

swapped_wavax2 AS sushi_wavax,

swaps_volume AS osmosis_swaps_volume,

swaps_volume2 AS sushi_swaps_volume,

FROM osmosis

INNER JOIN sushi_ava

ON osmosis.date1 = sushi_ava.date2

ORDER BY 1 ASC;