date_trunc('month', block_timestamp) as date,

regexp_substr(sender, '[a-zA-Z]+|\d+') as "Source Chain",

count(distinct tx_id) as "# Transfer",

count(distinct sender) as "# Sender"

osmosis.core.fact_transfers

transfer_type = 'IBC_TRANSFER_IN'

and receiver like 'osmo%'

--and amount / pow(10, decimal) < 10000000

group by

1,

2