median(open) as price

FROM crosschain.core.fact_hourly_prices

LEFT outer JOIN crosschain.core.dim_asset_metadata

ON crosschain.core.fact_hourly_prices.id LIKE crosschain.core.dim_asset_metadata.id

WHERE symbol ilike '%axl%' and RECORDED_HOUR>='2022-07-01')

select

count(a.tx_id) as number_of_bridge,count(distinct b.TX_FROM) as number_unique_users,sum(b.FEE) as axl_fee,sum(b.FEE*(select price from price)) as usd_fee

FROM axelar.core.fact_msg_attributes a join axelar.core.fact_transactions b on a.TX_ID=b.TX_ID

WHERE attribute_key = 'destinationChain' and a.TX_SUCCEEDED='TRUE' and FEE_DENOM='uaxl'