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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3f9070ef-bd6f-4a7c-aaaa-6527fceaa6b9 | 2026-09-15 15:50 | 2026-09-15 15:50 | 2026-09-15 15:50 | QCOM | QCOM260925C00180000 | call | 180.0000 | 2026-09-25 | 10.5200 | 10.2500 | 10.9000 | 187.0000 | 622531.00 | 259195.00 | 363336.00 | 592 | 28 | 1955 | 1339 | 1.46004480955937 | 0.511514263336938 | 0.521920265554149 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 4d469a8c-e00f-4999-b0fa-968d2d08ac94 | 2026-09-15 09:35 | 2026-09-15 09:35 | 2026-09-15 09:35 | QCOM | QCOM260925C00180000 | call | 180.0000 | 2026-09-25 | 10.3500 | 9.7500 | 10.7500 | 186.0700 | 124200.00 | 124200.00 | 0.00 | 120 | 7 | 274 | 1339 | 0.204630321135176 | 0.560398509624528 | 0.560398509624528 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| a36c1436-ff6c-4f72-b15c-0b58e59c301f | 2026-09-14 11:36 | 2026-09-14 11:36 | 2026-09-14 11:36 | QCOM | QCOM260925C00180000 | call | 180.0000 | 2026-09-25 | 5.2000 | 5.2000 | 5.4500 | 178.0000 | 218400.00 | 0.00 | 218400.00 | 420 | 5 | 1437 | 789 | 1.8212927756654 | 0.488878164689215 | 0.488878164689215 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:39:52.032222Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1c701e4d-d675-4d5c-a02b-e4649af83cc3 | 2026-09-14 11:12 | 2026-09-14 11:12 | 2026-09-14 11:12 | QCOM | QCOM260925C00180000 | call | 180.0000 | 2026-09-25 | 4.9000 | 4.8500 | 5.1000 | 177.1501 | 148960.00 | 127400.00 | 21560.00 | 304 | 5 | 820 | 789 | 1.03929024081115 | 0.496257397466557 | 0.496257397466557 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e81e1c27-74a5-47bb-b01d-ece4ed8f9adb | 2026-09-01 14:16 | 2026-09-01 14:16 | 2026-09-01 14:16 | QCOM | QCOM260925C00180000 | call | 180.0000 | 2026-09-25 | 2.1600 | 2.0900 | 2.3400 | 165.4901 | 86400.00 | 0.00 | 86400.00 | 400 | 5 | 456 | 637 | 0.71585557299843 | 0.401282972040191 | 0.401282972040191 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |