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 |
|---|
| 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 |
|---|
| 5c6a5e56-e317-4bca-b54c-ef0a8d555fa4 | 2026-09-24 09:56 | 2026-09-24 09:56 | 2026-09-24 09:56 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 0.3600 | 0.3500 | 0.3800 | 123.6400 | 10980.00 | 6228.00 | 4716.00 | 305 | 22 | 1195 | 2058 | 0.580660835762877 | 0.918580591493298 | 0.919508484144543 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 618394400000.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T13:56:38.298983Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| c4086a87-3efe-45e5-9915-5a14aad26755 | 2026-09-23 13:08 | 2026-09-23 13:08 | 2026-09-23 13:08 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 1.2500 | 1.2500 | 1.3200 | 120.1100 | 33750.00 | 0.00 | 33750.00 | 270 | 20 | 2601 | 1259 | 2.0659253375695 | 0.715943006055066 | 0.717885312552946 | true | false | false | true | ||||||||||||||||
| 802f88cd-f6c9-4b81-89f2-b6f03f391fbe | 2026-09-23 12:57 | 2026-09-23 12:57 | 2026-09-23 12:57 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 1.1700 | 1.1700 | 1.2300 | 120.3300 | 29718.00 | 0.00 | 29718.00 | 254 | 16 | 2322 | 1259 | 1.84432088959492 | 0.712845555889168 | 0.712845555889168 | true | false | false | true | ||||||||||||||||
| ef532f5f-a6c2-4296-9a85-41ad7c7fc697 | 2026-09-23 12:53 | 2026-09-23 12:53 | 2026-09-23 12:53 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 1.2200 | 1.2000 | 1.2200 | 120.1400 | 12322.00 | 12322.00 | 0.00 | 101 | 9 | 2063 | 1259 | 1.63860206513106 | 0.711061196975005 | 0.711061196975005 | false | false | false | true | ||||||||||||||||
| 3c967e27-0f22-4f6e-9bf6-2379734e43a2 | 2026-09-23 12:32 | 2026-09-23 12:32 | 2026-09-23 12:32 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 1.0100 | 1.0100 | 1.0700 | 120.7200 | 25048.00 | 0.00 | 25048.00 | 248 | 21 | 1931 | 1259 | 1.53375694996029 | 0.693654901915804 | 0.695005077675425 | false | false | false | true | ||||||||||||||||
| bf424013-68c2-485e-8746-ddc6ebc0a629 | 2026-09-23 10:31 | 2026-09-23 10:31 | 2026-09-23 10:31 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 1.4500 | 1.4000 | 1.4600 | 119.8250 | 14488.00 | 14488.00 | 0.00 | 100 | 7 | 881 | 1259 | 0.699761715647339 | 0.750165318004166 | 0.750165318004166 | false | false | false | true | ||||||||||||||||
| c1ea322c-4aa9-4842-97d0-29d26c9f42a4 | 2026-09-23 10:17 | 2026-09-23 10:17 | 2026-09-23 10:17 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 1.4700 | 1.4300 | 1.4800 | 119.9240 | 14680.00 | 14680.00 | 0.00 | 100 | 7 | 497 | 1259 | 0.394757744241461 | 0.769611616525172 | 0.769611616525172 | false | false | false | true | ||||||||||||||||
| 2f87e804-0f38-4f54-897a-af89ec2ead99 | 2026-09-22 14:19 | 2026-09-22 14:19 | 2026-09-22 14:19 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 1.0600 | 1.0500 | 1.0700 | 123.1400 | 11765.00 | 4876.00 | 6889.00 | 111 | 10 | 845 | 1245 | 0.678714859437751 | 0.75024280070831 | 0.750901684973751 | false | false | false | true | ||||||||||||||||
| 03e2f050-905a-4973-b653-fb80b32a1f1d | 2026-09-22 12:27 | 2026-09-22 12:27 | 2026-09-22 12:27 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 1.2700 | 1.2600 | 1.2700 | 121.4200 | 14097.00 | 14097.00 | 0.00 | 111 | 18 | 554 | 1245 | 0.444979919678715 | 0.692442264150266 | 0.692442264150266 | false | false | false | true | ||||||||||||||||
| 486ffd08-059b-49ac-a5fe-7267e1073087 | 2026-09-21 15:41 | 2026-09-21 15:41 | 2026-09-21 15:41 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 1.7300 | 1.7100 | 1.7300 | 122.4650 | 34600.00 | 34600.00 | 0.00 | 200 | 19 | 4358 | 12 | 363.166666666667 | 0.776357741330834 | 0.776485543687723 | false | false | false | true | ||||||||||||||||
| c0c3b4d1-d128-4b32-909b-564ab6482c29 | 2026-09-21 10:36 | 2026-09-21 10:36 | 2026-09-21 10:36 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 2.1600 | 2.1400 | 2.1600 | 121.2200 | 21600.00 | 21600.00 | 0.00 | 100 | 15 | 2207 | 12 | 183.916666666667 | 0.790914903512241 | 0.790914903512241 | false | false | false | true | ||||||||||||||||
| 2d188def-e85a-42db-a309-1fc76b4bb1a7 | 2026-09-21 10:27 | 2026-09-21 10:27 | 2026-09-21 10:27 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 2.2300 | 2.2100 | 2.2300 | 120.7672 | 15833.00 | 15833.00 | 0.00 | 71 | 7 | 2013 | 12 | 167.75 | 0.775693958333566 | 0.774048441931856 | true | false | false | true | ||||||||||||||||
| ad40b88f-14c4-4e1f-bdf5-18d9e7816c0c | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | INTC | INTC260925P00117000 | put | 117.0000 | 2026-09-25 | 2.6200 | 2.5900 | 2.6200 | 119.0000 | 39300.00 | 39300.00 | 0.00 | 150 | 9 | 1701 | 12 | 141.75 | 0.77804189090032 | 0.77804189090032 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:11:20.356460Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:56:20.780869Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:33:43.718875Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:18:11.787457Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 624749840000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:23:27.944500Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 624749840000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:27:20.551854Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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 |
| 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:29:33.809340Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T14:16:37.999315Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |