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 | 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 |
|---|
| 1e7c3d73-8901-48dd-a0e0-da94770f1bd7 | 2026-09-21 10:32 | 2026-09-21 10:31 | 2026-09-21 10:31 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.6600 | 0.6400 | 0.6600 | 120.8101 | 13200.00 | 13200.00 | 0.00 | 200 | 14 | 11363 | 79 | 143.835443037975 | 0.957023823075568 | 0.957023823075568 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 614258320000.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 75b40b77-3119-4a1e-b17c-2db293a7e7e8 | 2026-09-21 10:36 | 2026-09-21 10:36 | 2026-09-21 10:36 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.7600 | 0.7400 | 0.7600 | 121.1900 | 34428.00 | 34428.00 | 0.00 | 453 | 15 | 12772 | 79 | 161.670886075949 | 0.92855682608167 | 0.92855682608167 | true | false | false | true | ||||||||||||||||
| d4218a60-4007-4951-918b-e24775f217cf | 2026-09-21 10:38 | 2026-09-21 10:38 | 2026-09-21 10:38 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.6400 | 0.6400 | 0.6600 | 120.9300 | 12800.00 | 0.00 | 12800.00 | 200 | 7 | 13722 | 79 | 173.696202531646 | 0.908863794700734 | 0.910474081138239 | false | false | false | |||||||||||||||||
| ac48595b-5a5a-4ec1-a3ff-25dc2f5b7ece | 2026-09-21 10:40 | 2026-09-21 10:40 | 2026-09-21 10:40 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.5800 | 0.5800 | 0.6100 | 120.8100 | 29000.00 | 0.00 | 29000.00 | 500 | 28 | 14551 | 79 | 184.189873417722 | 0.895919452093323 | 0.895919452093323 | false | false | false | |||||||||||||||||
| 03638e27-35d3-4b6d-ba45-083169f45e7f | 2026-09-21 10:46 | 2026-09-21 10:46 | 2026-09-21 10:46 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.9700 | 0.9600 | 0.9800 | 121.7500 | 12513.00 | 11931.00 | 0.00 | 129 | 5 | 17242 | 79 | 218.253164556962 | 0.91703115061358 | 0.91703115061358 | false | false | false | true | ||||||||||||||||
| 9157c878-aeb0-4811-b5e9-f371df9cc248 | 2026-09-21 10:48 | 2026-09-21 10:48 | 2026-09-21 10:48 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.7800 | 0.7700 | 0.7900 | 121.3896 | 24726.00 | 0.00 | 18564.00 | 317 | 12 | 18409 | 79 | 233.025316455696 | 0.893013397739327 | 0.893013397739327 | false | false | false | |||||||||||||||||
| e3cb585b-ca26-42b9-83a9-4330e19bf959 | 2026-09-21 11:04 | 2026-09-21 11:04 | 2026-09-21 11:04 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 1.3700 | 1.3700 | 1.3900 | 122.6300 | 41100.00 | 0.00 | 41100.00 | 300 | 25 | 26606 | 79 | 336.784810126582 | 0.884187816249464 | 0.884187816249464 | false | false | false | |||||||||||||||||
| 9750d123-783a-4ae9-9112-701e4aff71f5 | 2026-09-21 11:29 | 2026-09-21 11:29 | 2026-09-21 11:29 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 2.1200 | 2.1200 | 2.1500 | 123.7807 | 10388.00 | 0.00 | 10388.00 | 49 | 5 | 29674 | 79 | 375.620253164557 | 0.882252455248403 | 0.882252455248403 | false | false | false | |||||||||||||||||
| c2170c4c-1107-42a5-9f96-edbc0bc3c87a | 2026-09-21 12:15 | 2026-09-21 12:15 | 2026-09-21 12:15 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 1.5600 | 1.5100 | 1.5600 | 123.2900 | 26364.00 | 26364.00 | 0.00 | 169 | 8 | 31513 | 79 | 398.898734177215 | 0.734052229509553 | 0.734052229509553 | false | false | false | |||||||||||||||||
| 631c4bc5-bc13-40e6-a29b-0bd40aec1dcf | 2026-09-21 12:33 | 2026-09-21 12:33 | 2026-09-21 12:33 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 1.3700 | 1.3700 | 1.4000 | 123.0500 | 12878.00 | 0.00 | 12878.00 | 94 | 31 | 33138 | 79 | 419.46835443038 | 0.745422222198232 | 0.749835616531546 | false | false | false | |||||||||||||||||
| 42b1439f-0a8f-4847-9f9f-34756aee1aac | 2026-09-21 12:34 | 2026-09-21 12:34 | 2026-09-21 12:34 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 1.3700 | 1.3300 | 1.3800 | 123.0300 | 164401.00 | 164401.00 | 0.00 | 1200 | 39 | 34761 | 79 | 440.012658227848 | 0.772028902605017 | 0.779768956212887 | true | false | false | |||||||||||||||||
| 88261297-a497-41a1-b5bf-b1a9e908c238 | 2026-09-21 13:35 | 2026-09-21 13:35 | 2026-09-21 13:35 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.4700 | 0.4600 | 0.4700 | 121.0000 | 23487.00 | 22889.00 | 598.00 | 500 | 8 | 44300 | 79 | 560.759493670886 | 0.764483884302734 | 0.747856616189255 | false | false | false | |||||||||||||||||
| cbdaef1e-164f-4132-bd0e-2814f014b067 | 2026-09-21 13:41 | 2026-09-21 13:41 | 2026-09-21 13:41 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.5700 | 0.5700 | 0.5900 | 121.9600 | 11400.00 | 0.00 | 11400.00 | 200 | 6 | 45995 | 79 | 582.215189873418 | 0.748042894347444 | 0.744935544244088 | false | false | false | |||||||||||||||||
| daa3c4e6-519c-465a-b6c6-414c3981b61e | 2026-09-21 13:44 | 2026-09-21 13:44 | 2026-09-21 13:44 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.5300 | 0.5100 | 0.5300 | 121.0000 | 10600.00 | 10600.00 | 0.00 | 200 | 7 | 47613 | 79 | 602.696202531646 | 0.727902520269571 | 0.722646275611704 | false | false | false | |||||||||||||||||
| 635c542f-5d29-49d4-a6ee-a17497fb7ba3 | 2026-09-21 13:49 | 2026-09-21 13:49 | 2026-09-21 13:49 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.4500 | 0.4400 | 0.4500 | 121.8200 | 20340.00 | 20340.00 | 0.00 | 452 | 34 | 48712 | 79 | 616.607594936709 | 0.709342645959092 | 0.697572637096502 | false | false | false | |||||||||||||||||
| f902c3f2-20c0-4509-bd8b-7447cfe33ae3 | 2026-09-21 14:27 | 2026-09-21 14:27 | 2026-09-21 14:27 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.3000 | 0.2800 | 0.3000 | 121.4700 | 15000.00 | 15000.00 | 0.00 | 500 | 30 | 57837 | 79 | 732.113924050633 | 0.811002894863014 | 0.811002894863014 | false | false | false | |||||||||||||||||
| 9839ed3f-d010-4f64-8cea-5d247ae2fe84 | 2026-09-21 14:32 | 2026-09-21 14:31 | 2026-09-21 14:31 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.2300 | 0.2300 | 0.2400 | 121.0000 | 11017.00 | 0.00 | 11017.00 | 479 | 15 | 59085 | 79 | 747.911392405063 | 0.805591912368589 | 0.805591912368589 | false | false | false | |||||||||||||||||
| b225d392-eef4-4fc8-88c0-58566e145574 | 2026-09-21 15:24 | 2026-09-21 15:24 | 2026-09-21 15:24 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.1000 | 0.0800 | 0.1000 | 121.2700 | 10000.00 | 10000.00 | 0.00 | 1000 | 25 | 69698 | 79 | 882.253164556962 | 0.885317716150846 | 0.878105164275257 | true | false | false | |||||||||||||||||
| 48db44e6-48cb-4c37-ba2d-fd8f868aeeeb | 2026-09-21 15:25 | 2026-09-21 15:24 | 2026-09-21 15:24 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.1100 | 0.1000 | 0.1100 | 121.3000 | 10956.00 | 10956.00 | 0.00 | 996 | 17 | 70764 | 79 | 895.746835443038 | 0.904667610916741 | 0.897215505865886 | true | false | false | |||||||||||||||||
| 250f83a4-1cd6-47f2-9260-56adb1281f27 | 2026-09-21 15:25 | 2026-09-21 15:25 | 2026-09-21 15:25 | INTC | INTC260921C00122000 | call | 122.0000 | 2026-09-21 | 0.1100 | 0.0900 | 0.1100 | 121.2800 | 11000.00 | 11000.00 | 0.00 | 1000 | 25 | 71874 | 79 | 909.79746835443 | 0.924365163727634 | 0.916911767098342 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:39:35.705687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:47:49.730853Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:17:17.704519Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:34:45.939712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:34:45.939712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:43:51.748700Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:46:19.788598Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:50:05.863152Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |