with inn as (select trunc(BLOCK_TIMESTAMP, 'day') as date, sum(amount/ pow(10,decimal)) as inlet

from axelar.core.fact_transfers

where TRANSFER_TYPE = 'IBC_TRANSFER_IN'

and TX_SUCCEEDED = 'TRUE'

and CURRENCY = 'uaxl'

and date >= CURRENT_DATE-60

group by 1

order by 1),

outt as (select trunc(BLOCK_TIMESTAMP, 'day') as date, sum(amount/ pow(10,decimal)) as outlet

from axelar.core.fact_transfers

where TRANSFER_TYPE = 'IBC_TRANSFER_OUT'

and TX_SUCCEEDED = 'TRUE'

and CURRENCY = 'uaxl'

and date >= CURRENT_DATE-60

group by 1

order by 1),

onn as (select trunc(BLOCK_TIMESTAMP, 'day') as date, sum(amount/ pow(10,decimal)) as axelar

from axelar.core.fact_transfers

where TRANSFER_TYPE = 'AXELAR'

and TX_SUCCEEDED = 'TRUE'

and CURRENCY = 'uaxl'

and date >= CURRENT_DATE-60

group by 1

order by 1),

osmo as (select trunc(date, 'day') as date, sum(BALANCE/ pow(10, DECIMAL)) as amount

from osmosis.core.fact_daily_balances

where CURRENCY = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'

and date >= CURRENT_DATE-60 and balance > 0

group by 1

order by 1),