On 4/18, StreamSwap launched on Osmosis, and the first streamer to join was OmniFlix Network. With the help of StreamSwap, OmniFlix Network launched its native token, $FLIX, and users could participate in the $FLIX launch by depositing $OSMO tokens in the $OSMO/$FLIX stream pool. As an analyst, I wanted to track the $FLIX launch process and user activity in the first stream of StreamSwap.
To do this, I used the osmosis.core.fact_msg_attributes table and set the ATTRIBUTE_KEY = 'stream_id' and ATTRIBUTE_VALUE to '1'. This helped me track all transactions related to StreamSwap's first stream. Additionally, I used ATTRIBUTE_VALUE = 'action' and ATTRIBUTE_VALUE = 'subscribe_pending' to find $OSMO depositing actions and ATTRIBUTE_VALUE = 'exit_stream' for $FLIX claiming actions.
To track swaps and transfers activity, I used the $FLIX token's contract (ibc/CEE970BB3D26F4B907097B6B660489F13F3B0DA765B83CC7D9A0BC0CE220FA6F) on osmosis.core.fact_swaps and osmosis.core.fact_transfers tables.
Overall, this methodology allowed me to analyze the first few days of the StreamSwap launch and gain insights into user behavior and the $FLIX token launch process.