Select Date_trunc('day',block_timestamp) AS Date, sum(to_amount)/1e6 AS Swap_to_scrt_amount

FROM osmosis.core.fact_swaps

WHERE Date >= CURRENT_DATE - 90

AND Date < CURRENT_DATE

AND TO_CURRENCY = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A'

Group by 1),

Swap_counts AS (

Select Date_trunc('day',block_timestamp) AS Dt, count(tx_id) AS Swap_to_scrt_tx_counts

FROM osmosis.core.fact_swaps

WHERE Dt >= CURRENT_DATE - 90

AND dt < CURRENT_DATE

AND TO_CURRENCY = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A'

Group by 1)

SELECT DATE, Swap_to_scrt_amount, Swap_to_scrt_tx_counts

FROM swap_amount

JOIN Swap_counts

ON swap_amount.date = Swap_counts.dt