MLDZMNstars 2
    Updated 2022-05-28
    SELECT
    date_trunc('hour',BLOCK_TIMESTAMP) as hour,
    count(distinct tx_id) as no_swaps

    from osmosis.core.fact_msg_attributes
    where MSG_TYPE='token_swapped'
    and ATTRIBUTE_VALUE ilike '%ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4%'
    and BLOCK_TIMESTAMP>='2022-05-20'
    and (ATTRIBUTE_KEY='tokens_in' or ATTRIBUTE_KEY='tokens_out')
    group by 1
    Run a query to Download Data