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_alerts566,287 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 |
|---|
| 12893d1f-8e9c-4089-a053-9828742934f7 | 2026-09-29 15:23 | 2026-09-29 15:23 | 2026-09-29 15:23 | MSI | MSI261218C00480000 | call | 480.0000 | 2026-12-18 | 11.8000 | 11.0000 | 11.8000 | 446.0000 | 82600.00 | 82600.00 | 0.00 | 70 | 25 | 229 | 1005 | 0.227860696517413 | 0.273476895856333 | 0.273213265720879 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 73830088703.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T19:28:18.151130Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| af65761a-16ab-4c0b-b85a-015a057eb551 | 2026-09-29 15:22 | 2026-09-29 15:22 | 2026-09-29 15:22 | MSI | MSI261218C00480000 | call | 480.0000 | 2026-12-18 | 11.7000 | 11.0000 | 11.7000 | 446.0000 | 24570.00 | 24570.00 | 0.00 | 21 | 9 | 137 | 1005 | 0.136318407960199 | 0.272161848316819 | 0.272161848316819 | false | false | false | |||||||||||||||||
| 97dac74f-89b1-4699-916e-8886f4d2b625 | 2026-09-29 15:19 | 2026-09-29 15:19 | 2026-09-29 15:19 | MSI | MSI261218C00480000 | call | 480.0000 | 2026-12-18 | 11.8000 | 11.2000 | 11.8000 | 446.8650 | 27140.00 | 27140.00 | 0.00 | 23 | 10 | 112 | 1005 | 0.111442786069652 | 0.271784322256181 | 0.271784322256181 | false | false | false | |||||||||||||||||
| 4ce44171-6a43-4047-b266-e0fe8cea43e6 | 2026-09-28 11:30 | 2026-09-28 11:30 | 2026-09-28 11:30 | MSI | MSI270115C00520000 | call | 520.0000 | 2027-01-15 | 7.0000 | 6.2000 | 7.0000 | 455.6500 | 18900.00 | 18900.00 | 0.00 | 27 | 9 | 30 | 11 | 2.72727272727273 | 0.250463496677586 | 0.250463496677586 | false | false | false | |||||||||||||||||
| d8708a3f-4aef-47af-b16e-384f42d2a497 | 2026-09-25 10:22 | 2026-09-25 10:22 | 2026-09-25 10:22 | MSI | MSI261016C00460000 | call | 460.0000 | 2026-10-16 | 10.0000 | 9.2000 | 10.0000 | 458.7800 | 69000.00 | 69000.00 | 0.00 | 69 | 23 | 69 | 270 | 0.255555555555556 | 0.229589542960689 | 0.229589542960689 | false | false | false | |||||||||||||||||
| 0533be2f-9776-419f-9cc7-10db37067562 | 2026-09-22 10:51 | 2026-09-22 10:51 | 2026-09-22 10:51 | MSI | MSI261016P00460000 | put | 460.0000 | 2026-10-16 | 11.5000 | 10.2000 | 11.5000 | 456.5000 | 77050.00 | 77050.00 | 0.00 | 67 | 11 | 67 | 81 | 0.827160493827161 | 0.220187581700542 | 0.220187581700542 | false | false | false | |||||||||||||||||
| 6e43adfc-7f6a-40a2-b534-42e161fb53df | 2026-09-21 14:55 | 2026-09-21 14:55 | 2026-09-21 14:55 | MSI | MSI261016C00470000 | call | 470.0000 | 2026-10-16 | 6.6000 | 6.2000 | 7.3000 | 460.6600 | 109560.00 | 69300.00 | 40260.00 | 166 | 13 | 261 | 133 | 1.96240601503759 | 0.20876184680199 | 0.208720018362497 | false | false | false | |||||||||||||||||
| 77141c01-697a-4673-b790-e035246a2bfb | 2026-09-18 11:20 | 2026-09-18 11:20 | 2026-09-18 11:20 | MSI | MSI261016C00450000 | call | 450.0000 | 2026-10-16 | 18.2000 | 17.1000 | 18.2000 | 460.2900 | 105560.00 | 105560.00 | 0.00 | 58 | 18 | 58 | 98 | 0.591836734693878 | 0.227828034423938 | 0.227828034423938 | false | false | false | |||||||||||||||||
| 4ef9fe83-b985-49ff-b747-b1102689a8c4 | 2026-09-16 13:48 | 2026-09-16 13:48 | 2026-09-16 13:48 | MSI | MSI260918P00470000 | put | 470.0000 | 2026-09-18 | 5.4000 | 4.5000 | 5.4000 | 467.0000 | 88020.00 | 88020.00 | 0.00 | 163 | 31 | 163 | 16 | 10.1875 | 0.279348259780479 | 0.279348259780479 | false | false | false | |||||||||||||||||
| 9071bfa0-af82-41d7-89b4-95ac85290cab | 2026-09-10 11:02 | 2026-09-10 11:02 | 2026-09-10 11:02 | MSI | MSI270115C00500000 | call | 500.0000 | 2027-01-15 | 15.3000 | 14.1000 | 15.3000 | 464.7500 | 100980.00 | 100980.00 | 0.00 | 66 | 19 | 66 | 162 | 0.407407407407407 | 0.241115661304488 | 0.241115661304488 | false | false | false | |||||||||||||||||
| 0dc27c2b-47f0-4582-bc4e-f5d4b1871d20 | 2026-09-02 11:26 | 2026-09-02 11:26 | 2026-09-02 11:26 | MSI | MSI261120P00480000 | put | 480.0000 | 2026-11-20 | 20.4000 | 20.4000 | 21.9000 | 483.4300 | 130560.00 | 0.00 | 130560.00 | 64 | 20 | 64 | 2 | 32 | 0.269268429433948 | 0.269268429433948 | false | false | false | |||||||||||||||||
| a0abf8dd-40c8-482e-8ec8-04a425475b03 | 2026-08-20 10:38 | 2026-08-20 10:38 | 2026-08-20 10:38 | MSI | MSI270115C00480000 | call | 480.0000 | 2027-01-15 | 33.7000 | 33.6000 | 33.7000 | 482.0805 | 60660.00 | 60660.00 | 0.00 | 18 | 18 | 698 | 1240 | 0.562903225806452 | 0.236096091907293 | 0.236096091907293 | true | false | false | |||||||||||||||||
| fd7b511f-b0b2-438b-b5a0-efaade3aa17e | 2026-08-20 10:38 | 2026-08-20 10:38 | 2026-08-20 10:38 | MSI | MSI270115C00480000 | call | 480.0000 | 2027-01-15 | 33.3600 | 32.5000 | 34.5000 | 481.8500 | 583720.00 | 437200.00 | 13320.00 | 175 | 40 | 538 | 1240 | 0.433870967741936 | 0.233148670803173 | 0.235547683035778 | true | false | false | |||||||||||||||||
| b53bab18-87d3-40ad-8a0c-c8877269ac7a | 2026-08-20 10:38 | 2026-08-20 10:38 | 2026-08-20 10:38 | MSI | MSI270115C00480000 | call | 480.0000 | 2027-01-15 | 33.6000 | 32.6000 | 33.7000 | 482.2550 | 477170.00 | 477170.00 | 0.00 | 142 | 21 | 680 | 1240 | 0.548387096774194 | 0.235190658332676 | 0.235245636821963 | true | false | false | |||||||||||||||||
| d7f45e51-92a5-4b96-98ef-2ba26ec36ece | 2026-08-20 10:38 | 2026-08-20 10:38 | 2026-08-20 10:38 | MSI | MSI270115C00480000 | call | 480.0000 | 2027-01-15 | 33.9000 | 32.5000 | 33.9000 | 482.0700 | 420360.00 | 420360.00 | 0.00 | 124 | 15 | 363 | 1240 | 0.292741935483871 | 0.237816713691032 | 0.237816713691032 | false | false | false | |||||||||||||||||
| 7594d4f5-0791-49f5-b575-530b8c5db506 | 2026-08-20 10:38 | 2026-08-20 10:38 | 2026-08-20 10:38 | MSI | MSI270115C00480000 | call | 480.0000 | 2027-01-15 | 34.0000 | 33.8000 | 34.9000 | 482.1300 | 340000.00 | 289000.00 | 17000.00 | 100 | 18 | 223 | 1240 | 0.179838709677419 | 0.238359372184918 | 0.238359372184918 | false | false | false | |||||||||||||||||
| 073e1aa4-ea43-49eb-bb6a-02d67817597b | 2026-08-20 10:38 | 2026-08-20 10:38 | 2026-08-20 10:38 | MSI | MSI270115C00480000 | call | 480.0000 | 2027-01-15 | 34.5000 | 33.4000 | 34.5000 | 483.0000 | 303600.00 | 55200.00 | 0.00 | 88 | 11 | 123 | 1240 | 0.0991935483870968 | 0.238280197474568 | 0.238280197474568 | false | false | false | |||||||||||||||||
| 40c55918-b11f-4336-aefa-8dc2ec04036b | 2026-08-18 09:55 | 2026-08-18 09:54 | 2026-08-18 09:54 | MSI | MSI261016C00480000 | call | 480.0000 | 2026-10-16 | 12.4000 | 10.5000 | 12.4000 | 467.9300 | 80600.00 | 80600.00 | 0.00 | 65 | 21 | 65 | 93 | 0.698924731182796 | 0.218590840548743 | 0.218590840548743 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 73830088703.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:28:18.151130Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 73830088703.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:19:47.796405Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74816431679.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:32:36.194150Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 75610801861.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:22:54.159476Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 75581012980.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 76352214032.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:56:46.399450Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 75907035742.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 76214854188.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 78465569704.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 78465569704.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 78465569704.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 78465569704.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 78465569704.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 78465569704.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 78465569704.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 78465569704.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 78465569704.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |