SELECT distinct from_currency as ibc, project_name AS symbol, from_decimal AS decimals from osmosis.core.fact_swaps a

left join osmosis.core.dim_labels b

on a.from_currency = b.address

),

dau_cosmos as (

select date_trunc('day',block_timestamp) as date,

'Cosmos' as chain,

count(distinct a.tx_id) as num_tx

from cosmos.core.fact_transfers a

where tx_succeeded = 'TRUE'

and date_trunc('day',block_timestamp) >= '2022-01-01'

and transfer_type in ('IBC_TRANSFER_OUT','IBC_TRANSFER_IN')

group by 1, 2

),

dau_osmosis as (

select date_trunc('day',block_timestamp) as date,

'Osmosis' as chain,

count(distinct a.tx_id) as num_tx

from osmosis.core.fact_transfers a

where tx_succeeded = 'TRUE'

and date_trunc('day',block_timestamp) >= '2022-01-01'

and transfer_type in ('IBC_TRANSFER_OUT','IBC_TRANSFER_IN')

group by 1, 2

),

dau_axelar as (

select date_trunc('day',block_timestamp) as date,

'Axelar' as chain,

count(distinct a.tx_id) as num_tx

from axelar.core.fact_transfers a

where tx_succeeded = 'TRUE'

and date_trunc('day',block_timestamp) >= '2022-01-01'