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.
Simplify Analyticsuw_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 | expiry |
|---|
| 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 |
|---|
| 1ef19f19-352b-4a2f-a10e-a722e4689bbb | 2026-09-22 10:58 | 2026-09-22 10:58 | 2026-09-22 10:58 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 9.0000 | 8.9000 | 9.0500 | 376.5970 | 10800.00 | 10800.00 | 0.00 | 12 | 5 | 329 | 84 | 3.91666666666667 | 0.391312089669976 | 0.391312089669976 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-22T15:00:53.883267Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 9edb57ec-291d-41ec-aa2a-a0568b97e313 | 2026-09-22 11:57 | 2026-09-22 11:57 | 2026-09-22 11:57 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 9.0000 | 9.0000 | 9.1000 | 376.0500 | 645376.00 | 0.00 | 645376.00 | 717 | 52 | 1326 | 84 | 15.7857142857143 | 0.378896868894881 | 0.378896868894881 | false | false | false | |||||||||||||||||
| 774ebde6-d150-4fb8-bfac-8e91c144b61a | 2026-09-22 12:14 | 2026-09-22 12:14 | 2026-09-22 12:14 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 8.7000 | 8.7000 | 8.8500 | 376.6250 | 342785.00 | 0.00 | 342785.00 | 394 | 32 | 1736 | 84 | 20.6666666666667 | 0.378453143070225 | 0.378453143070225 | false | false | false | |||||||||||||||||
| 85b9c39b-d2df-4634-b056-f02f21dfc668 | 2026-09-22 13:41 | 2026-09-22 13:41 | 2026-09-22 13:41 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 8.1500 | 8.1000 | 8.2000 | 377.7000 | 54605.00 | 0.00 | 30155.00 | 67 | 11 | 2177 | 84 | 25.9166666666667 | 0.377362029907086 | 0.377362029907086 | true | false | false | true | ||||||||||||||||
| 3f3142c7-8e76-4ad8-a3fd-dd39234c76ae | 2026-09-22 14:28 | 2026-09-22 14:28 | 2026-09-22 14:28 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 7.5000 | 7.4500 | 7.5000 | 379.4200 | 112500.00 | 112500.00 | 0.00 | 150 | 6 | 2814 | 84 | 33.5 | 0.383929019318058 | 0.383929019318058 | true | false | false | true | ||||||||||||||||
| a3a3eaa3-9279-4e18-9254-1a52cb8e0fdc | 2026-09-22 14:31 | 2026-09-22 14:30 | 2026-09-22 14:30 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 7.6000 | 7.5500 | 7.6000 | 379.1310 | 57760.00 | 57760.00 | 0.00 | 76 | 7 | 2891 | 84 | 34.4166666666667 | 0.384185482093204 | 0.382580383984551 | false | false | false | true | ||||||||||||||||
| 56e5cc81-ac82-4bee-8dd5-c7128a0668bc | 2026-09-22 15:33 | 2026-09-22 15:33 | 2026-09-22 15:33 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 7.4500 | 7.4500 | 7.5500 | 379.4500 | 14900.00 | 0.00 | 14900.00 | 20 | 7 | 3027 | 84 | 36.0357142857143 | 0.381877113462273 | 0.382281299482939 | false | false | false | true | ||||||||||||||||
| 0b8f8230-dc9e-4af2-8d7e-58fe1757291c | 2026-09-22 15:34 | 2026-09-22 15:34 | 2026-09-22 15:34 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 7.3500 | 7.3500 | 7.4500 | 379.6359 | 38955.00 | 0.00 | 38955.00 | 53 | 21 | 3081 | 84 | 36.6785714285714 | 0.381500617316959 | 0.381500617316959 | false | false | false | |||||||||||||||||
| 2c2b8f92-5152-4c58-9ccd-454c3fcff235 | 2026-09-22 15:59 | 2026-09-22 15:59 | 2026-09-22 15:59 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 7.5500 | 7.5000 | 7.6000 | 378.0000 | 18120.00 | 0.00 | 14345.00 | 24 | 5 | 3395 | 84 | 40.4166666666667 | 0.376023339031234 | 0.376023339031234 | false | false | false | true | ||||||||||||||||
| 8dc2870a-b3fe-4707-b061-ead99777642a | 2026-09-23 10:03 | 2026-09-23 10:03 | 2026-09-23 10:03 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 5.1900 | 5.1000 | 5.2000 | 384.4200 | 15575.00 | 13000.00 | 2575.00 | 30 | 7 | 340 | 1546 | 0.219922380336352 | 0.395442754190546 | 0.392570618862463 | false | false | false | |||||||||||||||||
| 57875328-4025-42a8-9ef8-8341038acd34 | 2026-09-23 13:03 | 2026-09-23 13:03 | 2026-09-23 13:03 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 7.5500 | 7.4000 | 7.5500 | 377.8850 | 12080.00 | 12080.00 | 0.00 | 16 | 5 | 624 | 1546 | 0.403622250970246 | 0.37790074420752 | 0.37790074420752 | true | false | false | true | ||||||||||||||||
| 9ab041c0-53e0-4ad3-97e9-982daf1081e7 | 2026-09-23 14:51 | 2026-09-23 14:51 | 2026-09-23 14:51 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 6.8600 | 6.8000 | 6.9000 | 379.5250 | 34276.00 | 17836.00 | 10960.00 | 50 | 6 | 888 | 1546 | 0.574385510996119 | 0.380486134398531 | 0.380967907161602 | false | false | false | |||||||||||||||||
| bc18f304-75b6-41ec-9058-71f039f1839f | 2026-09-23 15:07 | 2026-09-23 15:07 | 2026-09-23 15:07 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 6.7000 | 6.7000 | 6.8000 | 379.9550 | 15410.00 | 0.00 | 15410.00 | 23 | 10 | 964 | 1546 | 0.623544631306598 | 0.382361478337897 | 0.382361478337897 | true | false | false | |||||||||||||||||
| af6992b3-7256-474c-8183-b517d2c900dd | 2026-09-24 09:47 | 2026-09-24 09:47 | 2026-09-24 09:47 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 6.7200 | 6.7000 | 6.8000 | 378.4750 | 33592.00 | 0.00 | 33592.00 | 50 | 6 | 432 | 1529 | 0.282537606278613 | 0.378515097453464 | 0.378515097453464 | false | false | false | |||||||||||||||||
| 29fa524d-0690-40e7-af8f-2a072f80f835 | 2026-09-24 11:12 | 2026-09-24 11:12 | 2026-09-24 11:12 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 7.4800 | 7.3000 | 7.5000 | 376.0000 | 22436.00 | 22436.00 | 0.00 | 30 | 7 | 985 | 1529 | 0.644211903204709 | 0.367142027744131 | 0.362985784018679 | false | false | false | |||||||||||||||||
| 72bf0e09-fc85-4c38-98e7-a08b8c81be2b | 2026-09-24 11:33 | 2026-09-24 11:33 | 2026-09-24 11:33 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 7.3000 | 7.3000 | 7.4500 | 376.5401 | 27740.00 | 0.00 | 27740.00 | 38 | 13 | 1032 | 1529 | 0.674950948332243 | 0.359924268167031 | 0.359924268167031 | true | false | false | |||||||||||||||||
| 40bb8831-881f-4e8c-b601-d43af0f43de3 | 2026-09-24 12:25 | 2026-09-24 12:25 | 2026-09-24 12:25 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 5.9000 | 5.9000 | 6.0500 | 379.4022 | 37760.00 | 0.00 | 37760.00 | 64 | 22 | 1303 | 1529 | 0.852190974493133 | 0.357726507544426 | 0.357726507544426 | false | false | false | |||||||||||||||||
| f7ad4c71-57cb-4e3a-afe8-e3b60f16ab0f | 2026-09-24 13:03 | 2026-09-24 13:02 | 2026-09-24 13:02 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 4.8500 | 4.7500 | 4.8500 | 382.1600 | 395735.00 | 395735.00 | 0.00 | 816 | 57 | 2602 | 1529 | 1.70176586003924 | 0.362158538373028 | 0.362158538373028 | false | false | false | |||||||||||||||||
| d86a6452-8726-4410-943b-085e612a79ad | 2026-09-24 14:01 | 2026-09-24 14:01 | 2026-09-24 14:01 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 5.8500 | 5.7500 | 5.8500 | 379.3900 | 178425.00 | 178425.00 | 0.00 | 305 | 7 | 3079 | 1529 | 2.01373446697188 | 0.355531039477324 | 0.35484137521662 | false | false | false | |||||||||||||||||
| 0808d868-5b3b-47be-b108-e968e715813d | 2026-09-24 15:40 | 2026-09-24 15:40 | 2026-09-24 15:40 | TSLA | TSLA260930P00377500 | put | 377.5000 | 2026-09-30 | 5.6500 | 5.6500 | 5.7500 | 379.0000 | 197814.00 | 0.00 | 197814.00 | 350 | 35 | 3599 | 1529 | 2.35382603008502 | 0.353749190086308 | 0.353071685545761 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-22T16:00:55.569269Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-22T16:20:35.100506Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-22T17:49:14.593703Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-22T18:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-22T18:36:42.386317Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1496483507587.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T14:04:12.048624Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T17:06:21.638399Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T18:58:18.142602Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T19:12:23.721983Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:14:35.650072Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:27:48.650295Z"} |
| 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-24T17:03:43.722265Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T18:01:57.698805Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |