flipside

    Welcome To Axelar Scavenger Hunt (Nov 14)
    pandaWelcome To Axelar Scavenger Hunt (Nov 14)
    Updated 2022-11-17

    SELECT
    'Osmosis' as network,
    date_trunc('day', block_timestamp) as date,
    count(tx_id) as daily_txs
    FROM
    OSMOSIS.CORE.FACT_TRANSACTIONS
    WHERE
    date >= CURRENT_DATE - 90
    GROUP BY
    date

    UNION ALL

    SELECT
    'Axelar' as network,
    date_trunc('day', block_timestamp) as date,
    count(tx_id) as daily_txs
    FROM
    AXELAR.CORE.FACT_TRANSACTIONS
    WHERE
    date >= CURRENT_DATE - 90
    GROUP BY
    date
    ORDER BY
    date ASC
    Run a query to Download Data