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.
uw_flow_alerts658,639 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 |
|---|
| 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 |
|---|
| b2eb578a-aeec-4641-b6af-2dd6f19a60c9 | 2026-09-14 15:59 | 2026-09-14 15:59 | 2026-09-14 15:59 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 8.7500 | 8.7500 | 8.8500 | 358.0000 | 190768.00 | 0.00 | 190768.00 | 218 | 25 | 935 | 1711 | 0.546464056107539 | 0.412050113665653 | 0.411399051241326 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4a2b991c-d0f4-4574-b0ce-67df55d1384e | 2026-09-16 09:36 | 2026-09-16 09:36 | 2026-09-16 09:36 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 8.6500 | 8.6000 | 8.7500 | 358.3600 | 337267.00 | 326926.00 | 10341.00 | 390 | 37 | 438 | 2273 | 0.192696876374835 | 0.443098441918122 | 0.442448697212813 | false | false | false | |||||||||||||||||
| 6f9f20d1-f46b-4fc7-99ce-7e1d66a77608 | 2026-09-18 10:11 | 2026-09-18 10:11 | 2026-09-18 10:11 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 8.7900 | 8.6500 | 8.8000 | 361.9500 | 105470.00 | 105470.00 | 0.00 | 120 | 19 | 996 | 3515 | 0.283357041251778 | 0.425643747137211 | 0.426393460812399 | true | false | false | |||||||||||||||||
| d2c29d25-3198-4162-bbd0-0ec8494087bc | 2026-09-21 12:54 | 2026-09-21 12:54 | 2026-09-21 12:54 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 13.4600 | 13.3500 | 13.5000 | 373.0000 | 134622.00 | 49950.00 | 84672.00 | 100 | 7 | 5432 | 5265 | 1.03171889838556 | 0.441837608729386 | 0.438019442045686 | false | false | false | |||||||||||||||||
| 445a7ec9-523a-4e36-adb6-8008b625f50a | 2026-09-25 09:44 | 2026-09-25 09:44 | 2026-09-25 09:44 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 10.0000 | 9.9500 | 10.2000 | 370.9400 | 35008.00 | 0.00 | 35008.00 | 35 | 6 | 866 | 3873 | 0.223599277046217 | 0.462215793888762 | 0.458298406615086 | true | false | false | |||||||||||||||||
| 39fbac93-7598-4136-8a17-cabc45a12c3d | 2026-09-25 10:28 | 2026-09-25 10:28 | 2026-09-25 10:28 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 10.0300 | 10.0500 | 10.2000 | 370.7800 | 21065.00 | 0.00 | 21065.00 | 21 | 7 | 2214 | 3873 | 0.571649883810999 | 0.464914521439166 | 0.462466447980875 | true | false | false | |||||||||||||||||
| 085e150f-cc01-4e1a-93ad-707f6d809ec9 | 2026-09-25 15:39 | 2026-09-25 15:39 | 2026-09-25 15:39 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 9.5000 | 9.4000 | 9.5000 | 371.0000 | 160530.00 | 160530.00 | 0.00 | 169 | 38 | 7080 | 3873 | 1.8280402788536 | 0.42961778658855 | 0.42961778658855 | false | false | false | |||||||||||||||||
| 4e85c188-8a79-4bb5-a68a-232e54a8b5a5 | 2026-09-28 09:39 | 2026-09-28 09:39 | 2026-09-28 09:39 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 6.1500 | 6.1500 | 6.2500 | 365.5601 | 32605.00 | 0.00 | 31365.00 | 53 | 5 | 1033 | 3700 | 0.279189189189189 | 0.531480183731662 | 0.528150474464828 | false | false | false | |||||||||||||||||
| 96c457fb-7a36-4bd0-8775-f50fdab02394 | 2026-09-28 11:08 | 2026-09-28 11:08 | 2026-09-28 11:08 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 4.2000 | 4.1000 | 4.2000 | 360.6700 | 258275.00 | 258275.00 | 0.00 | 615 | 64 | 8632 | 3700 | 2.33297297297297 | 0.522229601368421 | 0.521744529562396 | false | false | false | |||||||||||||||||
| ddceb0aa-58d7-4c8b-9d55-0480c2f3c7ce | 2026-10-01 09:42 | 2026-10-01 09:42 | 2026-10-01 09:42 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 1.2200 | 1.2000 | 1.2300 | 356.3450 | 12223.00 | 12223.00 | 0.00 | 100 | 11 | 5646 | 10606 | 0.532340184801056 | 0.736883709898749 | 0.734764916418701 | false | false | false | |||||||||||||||||
| d56da6cd-1966-4f55-850d-2e4ff1d0e1c5 | 2026-10-01 10:10 | 2026-10-01 10:10 | 2026-10-01 10:10 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 1.0400 | 1.0400 | 1.0900 | 356.0000 | 10847.00 | 0.00 | 9787.00 | 104 | 33 | 12138 | 10606 | 1.14444653969451 | 0.708845129169277 | 0.705137886328112 | true | false | false | |||||||||||||||||
| 09ae985c-5156-4431-bb42-0ab8322b8ad0 | 2026-10-01 11:01 | 2026-10-01 11:01 | 2026-10-01 11:01 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 1.3300 | 1.3300 | 1.3600 | 358.7200 | 42837.00 | 0.00 | 19562.00 | 322 | 24 | 21728 | 10606 | 2.04865170658118 | 0.67359795212641 | 0.667794726560854 | true | false | false | |||||||||||||||||
| 25c62410-c633-4630-99b3-0368286160ff | 2026-10-01 11:25 | 2026-10-01 11:25 | 2026-10-01 11:25 | TSLA | TSLA261002C00370000 | call | 370.0000 | 2026-10-02 | 1.1300 | 1.1300 | 1.1500 | 358.0000 | 28487.00 | 0.00 | 28373.00 | 251 | 20 | 26170 | 10606 | 2.46747124269282 | 0.640472026641514 | 0.64042329514641 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1414253930844.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1438701629212.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1482265136968.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:45:37.818098Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:29:28.038338Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1411765715985.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:41:17.796982Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1411765715985.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:10:00.248263Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1398574227689.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:44:24.931446Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1398574227689.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:10:48.155850Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1398574227689.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T15:03:17.920227Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1398574227689.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T15:29:11.927963Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |