ValiMohammadiinto osmo monthly
    Updated 2023-02-13
    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS days,
    SUM(amount / 1e18) AS transfer_amount,
    COUNT(*) AS number_of_tranfers,
    currency AS currency_transfer
    FROM
    axelar.core.fact_transfers
    WHERE
    currency IN ('wbnb-wei', 'wmatic-wei', 'wavax-wei', 'weth-wei')
    AND receiver LIKE 'osmo%'
    GROUP BY
    currency_transfer,
    days
    Run a query to Download Data