axelar_usr AS (

SELECT

LOWER(foreign_address) AS axelar_user

FROM

axelar.core.fact_transfers

WHERE

foreign_chain = 'Ethereum'

AND sender LIKE 'osmo%'

),

optimism_txns AS (

SELECT

DATE_TRUNC('month', block_timestamp::DATE) AS date,

COUNT(DISTINCT tx_hash) AS number_txn,

'Optimism' AS

type

FROM

optimism.core.fact_transactions

WHERE

FROM_ADDRESS IN (

SELECT

axelar_user

FROM

axelar_usr

)

AND FROM_ADDRESS IN (

SELECT

FROM_ADDRESS

FROM

ethereum.core.fact_transactions

)

AND date >= '2022-01-01'

GROUP BY

1,

3

),