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_alerts609,118 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 |
|---|
| e47936e4-b335-4447-9b92-1998394c0a3e | 2026-09-22 09:31 | 2026-09-22 09:30 | 2026-09-22 09:30 | TSLA | TSLA261002C00385000 | call | 385.0000 | 2026-10-02 | 8.3300 | 8.3000 | 8.4000 | 377.4300 | 244010.00 | 0.00 | 122935.00 | 293 | 10 | 2927 | 1427 | 2.05115627189909 | 0.462729838890245 | 0.458199876948346 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 1496483507587.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T13:31:35.812482Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 1e19bf22-855f-4076-b897-fcd1dc0c5861 | 2026-09-22 15:52 | 2026-09-22 15:52 | 2026-09-22 15:52 | TSLA | TSLA261002C00385000 | call | 385.0000 | 2026-10-02 | 9.1000 | 9.0000 | 9.1500 | 380.0000 | 19100.00 | 11820.00 | 0.00 | 21 | 6 | 9244 | 1427 | 6.47792571829012 | 0.44176545341328 | 0.440676246979807 | true | false | false | |||||||||||||||||
| 12b89653-5703-490a-82df-c600afee5a1d | 2026-09-23 09:43 | 2026-09-23 09:42 | 2026-09-23 09:42 | TSLA | TSLA261002C00385000 | call | 385.0000 | 2026-10-02 | 9.7400 | 9.5000 | 9.7500 | 381.9400 | 24349.00 | 24349.00 | 0.00 | 25 | 5 | 563 | 5985 | 0.0940685045948204 | 0.459890211447286 | 0.457377835745549 | true | false | false | |||||||||||||||||
| dd0604e0-a445-4b57-8a9e-daf11dfe3b0b | 2026-09-23 09:46 | 2026-09-23 09:45 | 2026-09-23 09:45 | TSLA | TSLA261002C00385000 | call | 385.0000 | 2026-10-02 | 10.6600 | 10.6500 | 10.8000 | 384.0000 | 15985.00 | 0.00 | 15985.00 | 15 | 6 | 773 | 5985 | 0.129156223893066 | 0.456423130925935 | 0.454344631075295 | false | false | false | |||||||||||||||||
| cae805a0-749c-4cb2-9081-2cc80929fc20 | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | TSLA | TSLA261002C00385000 | call | 385.0000 | 2026-10-02 | 9.4600 | 9.4500 | 9.5500 | 381.0000 | 13250.00 | 0.00 | 13250.00 | 14 | 5 | 1817 | 5985 | 0.30359231411863 | 0.453587147311654 | 0.453789926698669 | true | false | false | |||||||||||||||||
| 3d3d9d20-0d4d-4f56-bde6-4ad6e617c2e7 | 2026-09-24 09:47 | 2026-09-24 09:47 | 2026-09-24 09:47 | TSLA | TSLA261002C00385000 | call | 385.0000 | 2026-10-02 | 7.4900 | 7.4500 | 7.5500 | 378.3800 | 13486.00 | 1500.00 | 2236.00 | 18 | 7 | 204 | 9121 | 0.0223659686437891 | 0.457413951833339 | 0.457112792711565 | true | false | false | |||||||||||||||||
| c6085043-865d-4d7f-b073-3a8e8801a6ef | 2026-09-24 12:50 | 2026-09-24 12:49 | 2026-09-24 12:49 | TSLA | TSLA261002C00385000 | call | 385.0000 | 2026-10-02 | 9.0900 | 9.0000 | 9.1000 | 382.7300 | 36344.00 | 36344.00 | 0.00 | 40 | 5 | 2712 | 9121 | 0.29733581844096 | 0.442986490009462 | 0.442100860265822 | false | false | false | |||||||||||||||||
| c63beaa7-db63-441f-9477-37c1eac0920e | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | TSLA | TSLA261002C00385000 | call | 385.0000 | 2026-10-02 | 10.5400 | 10.1500 | 10.7500 | 385.7500 | 109630.00 | 54870.00 | 54760.00 | 104 | 14 | 257 | 9418 | 0.0272881715863241 | 0.473159716667474 | 0.470807119025425 | true | false | false | |||||||||||||||||
| 27cd8739-3c52-4c38-95a1-681dfcf229c3 | 2026-09-25 09:46 | 2026-09-25 09:45 | 2026-09-25 09:45 | TSLA | TSLA261002C00385000 | call | 385.0000 | 2026-10-02 | 6.2700 | 6.1500 | 6.3000 | 376.1300 | 62664.00 | 62664.00 | 0.00 | 100 | 8 | 2150 | 9418 | 0.228286260352516 | 0.476199965517135 | 0.473266133413517 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1496483507587.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:46:41.730175Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:11:43.770446Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:48:47.718536Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:51:44.270939Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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:30:25.838480Z"} |
| 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-25T13:47:32.064714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |