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_alerts708,051 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 |
|---|
| a5007598-d891-4e2c-bd87-919c34ac652b | 2026-09-03 11:52 | 2026-09-03 11:52 | 2026-09-03 11:52 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 4.6500 | 4.6000 | 4.7000 | 90.3028 | 232500.00 | 17205.00 | 14880.00 | 500 | 11 | 3634 | 27924 | 0.130138948574703 | 0.642375362497122 | 0.642688266974239 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 490226360000.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 00dfacec-f0ef-410a-b4a8-0ca1e8a00ea5 | 2026-09-04 10:22 | 2026-09-04 10:22 | 2026-09-04 10:22 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 6.3500 | 6.3000 | 6.3500 | 94.9867 | 190500.00 | 190500.00 | 0.00 | 300 | 5 | 1578 | 31127 | 0.0506955376361358 | 0.651788690947363 | 0.651788690947363 | false | false | false | |||||||||||||||||
| 7d0f1e88-87fa-400b-b630-2ca62125493a | 2026-09-08 11:14 | 2026-09-08 11:14 | 2026-09-08 11:14 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 11.2000 | 11.0000 | 11.2000 | 103.6800 | 243040.00 | 243040.00 | 0.00 | 217 | 32 | 6408 | 31774 | 0.201674324919746 | 0.728104469744575 | 0.728104469744575 | false | false | false | |||||||||||||||||
| f4fed5aa-f0ac-4557-92a2-e4f8ccf4cc8b | 2026-09-10 14:30 | 2026-09-10 14:30 | 2026-09-10 14:30 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 9.1000 | 9.0000 | 9.2000 | 101.1900 | 185640.00 | 43680.00 | 141960.00 | 204 | 12 | 4166 | 40135 | 0.103799676093185 | 0.688592615075338 | 0.688592615075338 | true | false | false | |||||||||||||||||
| 61cb5b53-1dae-4eb6-897c-abcd9496d954 | 2026-09-16 09:30 | 2026-09-16 09:30 | 2026-09-16 09:30 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 8.8500 | 8.6000 | 8.9500 | 102.3450 | 78760.00 | 65490.00 | 4420.00 | 89 | 16 | 92 | 37683 | 0.00244141920760024 | 0.674459860928941 | 0.674459860928941 | true | false | false | |||||||||||||||||
| 6492f05a-7dae-467a-93a9-8286ffc40486 | 2026-09-16 09:48 | 2026-09-16 09:48 | 2026-09-16 09:48 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 8.8500 | 8.7500 | 8.9000 | 102.1400 | 62835.00 | 36285.00 | 26550.00 | 71 | 6 | 476 | 37683 | 0.0126316906828013 | 0.680021265795391 | 0.680021265795391 | false | false | false | |||||||||||||||||
| 0ec4b2f4-2926-4d2f-8fb8-9d0781e8c400 | 2026-09-21 10:19 | 2026-09-21 10:19 | 2026-09-21 10:19 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 20.0000 | 19.8500 | 20.0000 | 120.5550 | 58000.00 | 58000.00 | 0.00 | 29 | 8 | 1880 | 31772 | 0.0591715976331361 | 0.737768129055878 | 0.735802598529228 | false | false | false | |||||||||||||||||
| c07762d2-462d-4df6-ae67-ccf834813434 | 2026-09-21 11:36 | 2026-09-21 11:36 | 2026-09-21 11:36 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 22.7500 | 22.6500 | 22.8500 | 123.0000 | 59150.00 | 2275.00 | 56875.00 | 26 | 6 | 5743 | 31772 | 0.180756641067607 | 0.756781420744958 | 0.756781420744958 | false | false | false | |||||||||||||||||
| 49709c15-200f-4326-8161-c140fabb89e2 | 2026-09-21 11:51 | 2026-09-21 11:51 | 2026-09-21 11:51 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 23.0500 | 22.9500 | 23.2000 | 124.3400 | 16135.00 | 2305.00 | 13830.00 | 7 | 6 | 6402 | 31772 | 0.201498174493265 | 0.758850804964066 | 0.758850804964066 | false | false | false | |||||||||||||||||
| cf087771-8898-4cfa-b80d-3329804d2746 | 2026-09-21 13:09 | 2026-09-21 13:09 | 2026-09-21 13:09 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 21.0500 | 21.0500 | 21.1000 | 122.1300 | 10525.00 | 0.00 | 10525.00 | 5 | 5 | 9542 | 31772 | 0.300327332242226 | 0.733515284282164 | 0.733515284282164 | false | false | false | |||||||||||||||||
| 6f534177-a0e1-47dc-a667-1919baff2a74 | 2026-09-22 09:45 | 2026-09-22 09:45 | 2026-09-22 09:45 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 20.5500 | 20.4000 | 20.6000 | 122.0000 | 304140.00 | 12330.00 | 291810.00 | 148 | 6 | 174 | 26997 | 0.00644516057339704 | 0.715746374481679 | 0.715746374481679 | false | false | false | |||||||||||||||||
| c8730134-9431-4728-ba2b-926e1f9fb37b | 2026-09-25 09:47 | 2026-09-25 09:47 | 2026-09-25 09:47 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 22.9000 | 22.9000 | 22.9500 | 125.9214 | 36640.00 | 0.00 | 36640.00 | 16 | 16 | 66 | 23375 | 0.00282352941176471 | 0.70655101463941 | 0.70655101463941 | false | false | false | |||||||||||||||||
| 03b0b0f6-059e-4e29-9112-fb890859529b | 2026-09-25 09:47 | 2026-09-25 09:47 | 2026-09-25 09:47 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 22.9500 | 22.8500 | 23.0000 | 125.9700 | 22950.00 | 2295.00 | 20655.00 | 10 | 10 | 50 | 23375 | 0.00213903743315508 | 0.707425195624706 | 0.707425195624706 | false | false | false | |||||||||||||||||
| c5f0ff9d-6e41-4abd-b36e-3a682e9832d2 | 2026-09-25 13:48 | 2026-09-25 13:48 | 2026-09-25 13:48 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 21.8200 | 21.7500 | 21.8500 | 124.3400 | 21820.00 | 21820.00 | 0.00 | 10 | 6 | 198 | 23375 | 0.00847058823529412 | 0.711606272003608 | 0.711606272003608 | false | false | false | |||||||||||||||||
| 7479ceb5-3d1d-471f-ba57-f0b7b1abd506 | 2026-09-28 09:40 | 2026-09-28 09:40 | 2026-09-28 09:40 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 17.1000 | 16.9500 | 17.1500 | 118.3250 | 27360.00 | 27360.00 | 0.00 | 16 | 6 | 31 | 23296 | 0.00133070054945055 | 0.700379816618631 | 0.700176713763221 | false | false | false | |||||||||||||||||
| 24169a5f-90b1-462f-a1a3-a369fb4561fe | 2026-09-28 09:54 | 2026-09-28 09:54 | 2026-09-28 09:54 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 16.8500 | 16.8500 | 16.9500 | 118.0300 | 84250.00 | 0.00 | 84250.00 | 50 | 18 | 197 | 23296 | 0.00845638736263736 | 0.696891972836097 | 0.696891972836097 | false | false | false | |||||||||||||||||
| 082f5545-b38c-45bb-96fb-04cf1bb04b18 | 2026-09-28 11:05 | 2026-09-28 11:05 | 2026-09-28 11:05 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 14.9500 | 14.9000 | 15.0000 | 115.3800 | 13455.00 | 11960.00 | 1495.00 | 9 | 9 | 389 | 23296 | 0.0166981456043956 | 0.685962003478392 | 0.685771397367189 | false | false | false | |||||||||||||||||
| 7a4ec201-6ef1-4d32-abdb-01d49e63fccd | 2026-09-30 15:48 | 2026-09-30 15:47 | 2026-09-30 15:47 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 18.3000 | 18.2500 | 18.3500 | 120.3150 | 91500.00 | 20130.00 | 0.00 | 50 | 9 | 315 | 23719 | 0.0132804924322273 | 0.705481643322612 | 0.705481643322612 | false | false | false | |||||||||||||||||
| 79a0fc66-5b33-4ba1-a57e-5d53f8bcc115 | 2026-09-30 15:54 | 2026-09-30 15:54 | 2026-09-30 15:54 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 18.2500 | 18.2500 | 18.4500 | 120.2100 | 12775.00 | 0.00 | 12775.00 | 7 | 5 | 327 | 23719 | 0.013786415953455 | 0.706885567884262 | 0.706885567884262 | false | false | false | |||||||||||||||||
| ceae0676-218a-4664-b6c2-328b013d644a | 2026-10-02 09:38 | 2026-10-02 09:38 | 2026-10-02 09:38 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 20.5500 | 20.4500 | 20.5500 | 124.1150 | 20550.00 | 10275.00 | 0.00 | 10 | 10 | 49 | 23645 | 0.00207231972932967 | 0.693373370874989 | 0.691270220495223 | false | false | false | |||||||||||||||||
| 69b71e5d-fd2e-47a9-b3c3-983ef1e9c092 | 2026-10-02 12:49 | 2026-10-02 12:49 | 2026-10-02 12:49 | INTC | INTC261120C00110000 | call | 110.0000 | 2026-11-20 | 18.1500 | 18.1000 | 18.3000 | 121.4000 | 70785.00 | 52635.00 | 18150.00 | 39 | 5 | 244 | 23645 | 0.0103193064072743 | 0.661168296358765 | 0.662098732183487 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 490226360000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 490226360000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 490226360000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 509696200000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:33:11.249350Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 509696200000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 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:20:57.602674Z"} |
| 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-21T15:36:47.844885Z"} |
| 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:52:20.515056Z"} |
| 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:12:05.796133Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 624749840000.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 620412000000.00 |
| 2026-10-22 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 620412000000.00 |
| 2026-10-22 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 620412000000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:50:01.932714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 585255320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:41:17.796982Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 585255320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:56:17.476262Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 585255320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:07:49.778831Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 584750920000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:50:15.606466Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 584750920000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:56:14.102421Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 601900520000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T13:38:48.083458Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 601900520000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T16:49:57.851482Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |