flipside

    tab4
    sunshine-juliatab4
    Updated 2022-12-30
    SELECT date(block_timestamp) as day, INITCAP (regexp_substr (sender,'[a-zA-Z]+|\d+')) as original_chain,
    COUNT(DISTINCT tx_id) as count_transaction
    FROM osmosis.core.fact_transfers
    WHERE receiver ilike 'osmo%' AND not sender ilike 'osmo%'
    GROUP BY 1,2
    Run a query to Download Data