Options flow alerts (market-wide)
core.flow_alerts
Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 rowsrestricted — hover for the licence
| iduuid | created_at ↓timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric | expirydate | pricenumeric | bidnumeric | asknumeric | underlying_pricenumeric | total_premiumnumeric | total_ask_side_premnumeric | total_bid_side_premnumeric | total_sizebigint | trade_countinteger | volumebigint | open_interestbigint | volume_oi_rationumeric | iv_startnumeric | iv_endnumeric | has_sweepboolean | has_floorboolean | has_multilegboolean | has_singlelegboolean | all_opening_tradesboolean | alert_ruletext | rule_iduuid | expiry_countinteger | issue_typetext | sectortext | marketcapnumeric | next_earnings_datedate | er_timetext | missing_periscopeboolean | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3773e8c0-2e57-4e00-9d14-3b21e4341cdf | 2026-09-18 11:38 | 2026-09-18 11:38 | 2026-09-18 11:38 | SIMO | SIMO261218C00260000 | call | 260.0000 | 2026-12-18 | 47.1100 | 46.7000 | 48.2000 | 265.9800 | 230830.00 | 23600.00 | 65630.00 | 49 | 15 | 54 | 509 | 0.106090373280943 | 0.825310890538178 | 0.815479661057081 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 9132340853.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a46dc9b6-0503-4fe0-a357-db1333a2ca66 | 2026-09-17 13:05 | 2026-09-17 13:05 | 2026-09-17 13:05 | SIMO | SIMO261016C00270000 | call | 270.0000 | 2026-10-16 | 15.5000 | 14.4000 | 17.1000 | 254.0800 | 57350.00 | 27630.00 | 29720.00 | 37 | 5 | 248 | 272 | 0.911764705882353 | 0.764289436882308 | 0.75010155040947 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 8501054493.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| b5ec8fd7-b093-4a9c-aadf-a9299fc5496f | 2026-09-16 15:08 | 2026-09-16 15:08 | 2026-09-16 15:08 | SIMO | SIMO261218C00260000 | call | 260.0000 | 2026-12-18 | 31.5700 | 31.5000 | 34.0000 | 238.1750 | 22100.00 | 0.00 | 22100.00 | 7 | 7 | 71 | 379 | 0.187335092348285 | 0.81887275899725 | 0.814339970824815 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 8092950179.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 841b6a1d-4ce1-4f9e-83e9-f0683f89e59e | 2026-09-16 11:57 | 2026-09-16 11:57 | 2026-09-16 11:57 | SIMO | SIMO260918P00240000 | put | 240.0000 | 2026-09-18 | 5.9800 | 5.0000 | 7.1000 | 240.6800 | 13763.00 | 7335.00 | 6428.00 | 23 | 13 | 33 | 317 | 0.10410094637224 | 0.918813397418377 | 0.904699994676316 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 8092950179.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| edf78d72-9f2b-45ca-b753-765c2880a0cb | 2026-09-16 11:44 | 2026-09-16 11:43 | 2026-09-16 11:43 | SIMO | SIMO261218C00260000 | call | 260.0000 | 2026-12-18 | 33.9800 | 32.7000 | 35.0000 | 241.8600 | 81540.00 | 20400.00 | 50940.00 | 24 | 7 | 25 | 379 | 0.0659630606860158 | 0.828148469042826 | 0.826746456136914 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 8092950179.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 8ae87638-c01e-495f-8e64-85c73893b1ab | 2026-08-26 15:50 | 2026-08-26 15:50 | 2026-08-26 15:50 | SIMO | SIMO260918C00280000 | call | 280.0000 | 2026-09-18 | 13.8000 | 13.8000 | 15.0000 | 261.4300 | 24841.00 | 0.00 | 24841.00 | 18 | 5 | 279 | 1245 | 0.224096385542169 | 0.798995684804366 | 0.798603482739689 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 7947630140.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |