Osmo_FT as (

SELECT

date_trunc('day', block_timestamp) as datee,

COUNT(DISTINCT RECEIVER) as bridgers,

COUNT(DISTINCT TX_ID) as transactions,

sum(amount / power(10, decimal)) as coin_bridge_valume

FROM

osmosis.core.fact_transfers as FT

LEFT outer JOIN osmosis.core.dim_labels as DL ON DL.address = FT.currency

WHERE

project_name LIKE '%BNB%'

AND sender LIKE 'axelar%'

AND receiver LIKE 'osmo%'

GROUP BY

datee

)

datee,

bridgers,

coin_bridge_valume,

transactions

Osmo_FT