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_alerts474,253 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 |
|---|
| 8d46a139-5129-422c-8a1b-397d7712ed68 | 2026-09-21 12:22 | 2026-09-21 12:22 | 2026-09-21 12:22 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 3.7800 | 3.7000 | 3.8000 | 374.6000 | 26489.00 | 26489.00 | 0.00 | 70 | 9 | 1332 | 765 | 1.74117647058824 | 0.440539196184614 | 0.439125801497756 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 1482265136968.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4f84d979-de61-49ef-9251-0e670bb41a49 | 2026-09-21 15:00 | 2026-09-21 15:00 | 2026-09-21 15:00 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 3.4500 | 3.4500 | 3.5000 | 375.0000 | 16564.00 | 0.00 | 16564.00 | 48 | 14 | 1764 | 765 | 2.30588235294118 | 0.437869288658758 | 0.437144710830133 | true | false | false | |||||||||||||||||
| e25b083f-6762-4b32-962f-d6893d6c06c4 | 2026-09-22 09:46 | 2026-09-22 09:46 | 2026-09-22 09:46 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 3.5300 | 3.4500 | 3.5500 | 374.1200 | 17635.00 | 9585.00 | 0.00 | 50 | 5 | 436 | 1386 | 0.314574314574315 | 0.475216380566935 | 0.470248519661442 | false | false | false | |||||||||||||||||
| 753c124a-5838-4c95-a4c6-8e3a0df2a484 | 2026-09-24 10:23 | 2026-09-24 10:23 | 2026-09-24 10:23 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.8500 | 0.7800 | 0.8700 | 376.9100 | 17885.00 | 0.00 | 17885.00 | 211 | 12 | 6245 | 1979 | 3.15563415866599 | 0.480408101546008 | 0.483573702644029 | true | false | false | |||||||||||||||||
| a3923f55-3d29-49d1-b9c1-3a1262b1d768 | 2026-09-25 09:33 | 2026-09-25 09:33 | 2026-09-25 09:33 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.5400 | 1.4700 | 1.5800 | 371.0000 | 36106.00 | 30953.00 | 5153.00 | 235 | 11 | 2221 | 4129 | 0.537902639864374 | 0.763519623098353 | 0.746585095963312 | false | false | false | |||||||||||||||||
| 955de03d-4aba-4253-a106-af8a0a303135 | 2026-09-25 09:38 | 2026-09-25 09:38 | 2026-09-25 09:38 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.9300 | 0.9000 | 0.9700 | 373.0000 | 10008.00 | 738.00 | 8433.00 | 108 | 24 | 5802 | 4129 | 1.40518285299104 | 0.740511762151663 | 0.727445853960944 | true | false | false | |||||||||||||||||
| f318283f-df68-4baf-bc46-2a44539f088b | 2026-09-25 09:41 | 2026-09-25 09:41 | 2026-09-25 09:41 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.5800 | 1.5600 | 1.6150 | 370.7000 | 17996.00 | 795.00 | 17044.00 | 114 | 11 | 8446 | 4129 | 2.04553160571567 | 0.722438443249445 | 0.733338940543202 | true | false | false | |||||||||||||||||
| 2c6a48e6-2e11-4637-b437-38f19a671ee4 | 2026-09-25 09:50 | 2026-09-25 09:50 | 2026-09-25 09:50 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.9100 | 0.8500 | 0.9800 | 372.7100 | 17309.00 | 1042.00 | 15362.00 | 191 | 27 | 15270 | 4129 | 3.69823201743764 | 0.704066728523535 | 0.687542426579244 | true | false | false | |||||||||||||||||
| abc9ad81-9887-4c9f-a69c-554494be820d | 2026-09-25 09:59 | 2026-09-25 09:59 | 2026-09-25 09:59 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.7800 | 0.7700 | 0.8200 | 372.0000 | 16023.00 | 4380.00 | 7431.00 | 206 | 22 | 21445 | 4129 | 5.1937515136837 | 0.691038504962871 | 0.683060093350144 | true | false | false | |||||||||||||||||
| 52523584-c0e8-4fcb-9d33-52b3a4054fb9 | 2026-09-25 10:04 | 2026-09-25 10:04 | 2026-09-25 10:04 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.1600 | 1.1300 | 1.1800 | 371.0000 | 13294.00 | 9810.00 | 1989.00 | 115 | 20 | 25284 | 4129 | 6.12351658997336 | 0.671275562121209 | 0.677775810340256 | true | false | false | |||||||||||||||||
| 8cdeabef-2045-44d4-8d3d-44a93ccc6bc6 | 2026-09-25 10:28 | 2026-09-25 10:28 | 2026-09-25 10:28 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.2500 | 1.2100 | 1.2600 | 370.2500 | 14798.00 | 7053.00 | 7745.00 | 118 | 8 | 39197 | 4129 | 9.49309760232502 | 0.646541080545903 | 0.63750632305977 | false | false | false | |||||||||||||||||
| ec83a7c3-a42b-47d2-ba13-237fc3d3e04d | 2026-09-25 10:43 | 2026-09-25 10:43 | 2026-09-25 10:43 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.7300 | 1.7200 | 1.7600 | 368.5900 | 13843.00 | 5890.00 | 7953.00 | 80 | 12 | 47770 | 4129 | 11.569387260838 | 0.621208827468433 | 0.617647741314378 | false | false | false | |||||||||||||||||
| 44dcbee6-9c0a-4ef4-bee5-d262efb4b153 | 2026-09-25 10:43 | 2026-09-25 10:43 | 2026-09-25 10:43 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.8100 | 1.7900 | 1.8500 | 368.4420 | 11575.00 | 913.00 | 7039.00 | 64 | 27 | 48487 | 4129 | 11.743037054977 | 0.618121143801939 | 0.622724629202358 | true | false | false | |||||||||||||||||
| 864fbc4a-4691-4417-9a90-76402731e3c7 | 2026-09-25 10:43 | 2026-09-25 10:43 | 2026-09-25 10:43 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 2.0500 | 2.0500 | 2.0700 | 367.8550 | 20528.00 | 3307.00 | 17221.00 | 100 | 20 | 49501 | 4129 | 11.9886170985711 | 0.621903479863645 | 0.621903479863645 | false | false | false | |||||||||||||||||
| 789dc240-3719-46ae-a96c-4305b228271b | 2026-09-25 10:44 | 2026-09-25 10:43 | 2026-09-25 10:43 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.9900 | 1.9300 | 2.0600 | 368.0640 | 36231.00 | 4392.00 | 31839.00 | 182 | 36 | 49693 | 4129 | 12.0351174618552 | 0.621450524754215 | 0.623850902782389 | true | false | false | |||||||||||||||||
| c1f908d5-574a-4b21-9590-59cfe5d6e4ec | 2026-09-25 10:44 | 2026-09-25 10:44 | 2026-09-25 10:44 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 2.1100 | 2.1000 | 2.1400 | 367.8199 | 22800.00 | 1278.00 | 21522.00 | 108 | 19 | 51308 | 4129 | 12.4262533301041 | 0.637751458227227 | 0.632173745649491 | false | false | false | |||||||||||||||||
| b01b4f74-d10e-47d5-b76d-b5f81a29b2a7 | 2026-09-25 10:48 | 2026-09-25 10:48 | 2026-09-25 10:48 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.4100 | 1.4000 | 1.4500 | 369.2500 | 10591.00 | 0.00 | 10591.00 | 75 | 24 | 53976 | 4129 | 13.0724146282393 | 0.606575471805075 | 0.605417167174454 | false | false | false |
| 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-21T19:06:05.917319Z"} |
| 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 |
| 1496483507587.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:48:39.949749Z"} |
| 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-24T14:24:55.986256Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:34:45.543817Z"} |
| 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-25T13:39:47.971768Z"} |
| 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:43:32.172352Z"} |
| 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:52:56.276610Z"} |
| 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-25T14:01:14.001980Z"} |
| 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-25T14:05:23.720155Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:43:48.295772Z"} |
| 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:43:48.295772Z"} |
| 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:47:41.799650Z"} |
| 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:47:41.799650Z"} |
| 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:47:41.799650Z"} |
| 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:52:00.220874Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |