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_alerts523,327 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 |
|---|
| 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 |
|---|
| b0a5310a-46e7-46ad-ada3-5c49057bcb03 | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.8600 | 0.8400 | 0.8700 | 226.8300 | 11044.00 | 7486.00 | 2365.00 | 129 | 28 | 21383 | 58388 | 0.366222511474961 | 0.484764923550145 | 0.4695161513849 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5424187000000.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T13:35:49.891887Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 4bd14890-5252-458c-9c87-25eb0a01a0fa | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.8400 | 0.8200 | 0.8600 | 226.7100 | 16816.00 | 11897.00 | 4581.00 | 200 | 47 | 21645 | 58388 | 0.37070973487703 | 0.475528574848458 | 0.477317632198685 | false | false | false | true | ||||||||||||||||
| 7fafb177-d394-46a2-8e19-ff7fbf36c313 | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.7300 | 0.7200 | 0.7700 | 226.5250 | 19203.00 | 385.00 | 18818.00 | 264 | 45 | 23366 | 58388 | 0.400184969514284 | 0.473392879638783 | 0.473685783455731 | true | false | false | true | ||||||||||||||||
| 0766e151-0518-48b9-87c8-09bf5e6a278e | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.7100 | 0.6600 | 0.7500 | 226.3300 | 19718.00 | 1273.00 | 18445.00 | 278 | 39 | 24341 | 58388 | 0.416883606220456 | 0.469695842222455 | 0.469337571542066 | true | false | false | true | ||||||||||||||||
| c8ffcce6-a1f5-4990-a1aa-1674dbac5c7f | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.7200 | 0.7100 | 0.7400 | 226.4700 | 12127.00 | 1109.00 | 10872.00 | 168 | 16 | 25687 | 58388 | 0.439936288278413 | 0.477909398094962 | 0.474017513568862 | true | false | false | true | ||||||||||||||||
| 0507ec67-84ba-4889-a917-a780e69480c7 | 2026-09-25 09:36 | 2026-09-25 09:36 | 2026-09-25 09:36 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.6500 | 0.6300 | 0.6600 | 226.3600 | 14217.00 | 198.00 | 13891.00 | 219 | 9 | 26898 | 58388 | 0.460676851407824 | 0.454507643680801 | 0.451800918938384 | false | false | false | true | ||||||||||||||||
| ce06a6e6-93f6-427b-a945-ffec2a7a06ff | 2026-09-25 09:36 | 2026-09-25 09:36 | 2026-09-25 09:36 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.6400 | 0.6200 | 0.6500 | 226.3975 | 15704.00 | 13750.00 | 1954.00 | 246 | 8 | 27794 | 58388 | 0.476022470370624 | 0.448910083955056 | 0.450652785152013 | false | false | false | true | ||||||||||||||||
| cf20d440-c5c8-4b9e-977f-8b257ba8b497 | 2026-09-25 09:36 | 2026-09-25 09:36 | 2026-09-25 09:36 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.6300 | 0.6000 | 0.6400 | 226.3600 | 14186.00 | 1575.00 | 12240.00 | 226 | 22 | 28229 | 58388 | 0.483472631362609 | 0.449936517971754 | 0.44316953853981 | true | false | false | true | ||||||||||||||||
| 9b1d413c-b2a5-4545-90a6-75a3b5b01f80 | 2026-09-25 09:38 | 2026-09-25 09:37 | 2026-09-25 09:37 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.4500 | 0.4400 | 0.4600 | 225.0000 | 10702.00 | 0.00 | 10702.00 | 238 | 10 | 32660 | 58388 | 0.559361512639583 | 0.444954103113271 | 0.446696231256908 | false | false | false | true | ||||||||||||||||
| 7dba942d-e141-449d-b105-1622a4081d85 | 2026-09-25 09:38 | 2026-09-25 09:38 | 2026-09-25 09:38 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.3500 | 0.3300 | 0.3600 | 225.0000 | 102011.00 | 0.00 | 102011.00 | 2915 | 11 | 40711 | 58388 | 0.697249434815373 | 0.453600319300866 | 0.446871871925994 | true | false | false | true | ||||||||||||||||
| c8e2e93b-c58a-4e9c-aa15-9f4f091ed52e | 2026-09-25 09:41 | 2026-09-25 09:41 | 2026-09-25 09:41 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.2900 | 0.2800 | 0.3000 | 225.2300 | 11389.00 | 30.00 | 11359.00 | 394 | 18 | 47653 | 58388 | 0.816143728163321 | 0.434808051280415 | 0.430608663342728 | false | false | false | true | ||||||||||||||||
| 6dc6d8dd-336a-41f8-bc73-204095b184ab | 2026-09-25 09:48 | 2026-09-25 09:48 | 2026-09-25 09:48 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.2400 | 0.2300 | 0.2400 | 225.1900 | 24554.00 | 24048.00 | 506.00 | 1024 | 21 | 62287 | 58388 | 1.06677742001781 | 0.408610306554144 | 0.414464023050628 | false | false | false | true | ||||||||||||||||
| 3def8a96-cba6-4d36-a25c-107e521d70c7 | 2026-09-25 09:49 | 2026-09-25 09:49 | 2026-09-25 09:49 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.2000 | 0.1900 | 0.2000 | 224.9800 | 11500.00 | 11500.00 | 0.00 | 575 | 5 | 64475 | 58388 | 1.10425087346715 | 0.411996871173239 | 0.411996871173239 | false | false | false | true | ||||||||||||||||
| 48d9fc52-cea4-45d2-aaea-2a299deaa59e | 2026-09-25 09:51 | 2026-09-25 09:51 | 2026-09-25 09:51 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.1600 | 0.1500 | 0.1600 | 224.8204 | 16000.00 | 16000.00 | 0.00 | 1000 | 13 | 67219 | 58388 | 1.15124683154073 | 0.400482548110614 | 0.400482548110614 | false | false | false | true | ||||||||||||||||
| 74fdb10b-0db3-4f40-9f2d-f00e76cfd471 | 2026-09-25 09:55 | 2026-09-25 09:55 | 2026-09-25 09:55 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.2300 | 0.2200 | 0.2400 | 225.3750 | 13224.00 | 1012.00 | 12212.00 | 575 | 8 | 74631 | 58388 | 1.27819072412139 | 0.388869660897742 | 0.384224910650979 | false | false | false | true | ||||||||||||||||
| 14abf222-6aac-4443-91fd-34b600489053 | 2026-09-25 11:09 | 2026-09-25 11:09 | 2026-09-25 11:09 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.0600 | 0.0600 | 0.0700 | 224.3500 | 12870.00 | 0.00 | 12870.00 | 2145 | 5 | 180887 | 58388 | 3.09801671576351 | 0.391574960471006 | 0.392561221552569 | false | false | false | true | ||||||||||||||||
| 3e2d5c1d-b707-45a3-8627-a7423d34e994 | 2026-09-25 11:58 | 2026-09-25 11:58 | 2026-09-25 11:58 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.0700 | 0.0600 | 0.0700 | 224.9400 | 10360.00 | 10360.00 | 0.00 | 1480 | 32 | 206886 | 58388 | 3.5432965677879 | 0.380917993316353 | 0.380917993316353 | false | false | false | true | ||||||||||||||||
| ace32810-8e05-45d2-9a26-657ae3776e4d | 2026-09-25 12:02 | 2026-09-25 12:02 | 2026-09-25 12:02 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.1300 | 0.1200 | 0.1400 | 225.5800 | 18954.00 | 18915.00 | 39.00 | 1458 | 16 | 225235 | 58388 | 3.85755634719463 | 0.372895667908033 | 0.371588407552826 | false | false | false | true | ||||||||||||||||
| 99539310-ad70-4229-a072-3614235e7f2b | 2026-09-25 12:04 | 2026-09-25 12:04 | 2026-09-25 12:04 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.1700 | 0.1600 | 0.1700 | 225.7350 | 17000.00 | 17000.00 | 0.00 | 1000 | 24 | 236408 | 58388 | 4.04891416044393 | 0.386619798061648 | 0.386619798061648 | true | false | false | true | ||||||||||||||||
| 55e119b0-70b0-4bce-b75c-5bd8cdce819f | 2026-09-25 12:04 | 2026-09-25 12:04 | 2026-09-25 12:04 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.1700 | 0.1600 | 0.1700 | 225.7150 | 17000.00 | 17000.00 | 0.00 | 1000 | 21 | 237492 | 58388 | 4.06747961909981 | 0.389511077251194 | 0.389511077251194 | true | false | false | true | ||||||||||||||||
| b317f5fd-07f8-4d64-b562-49f7b1ddd0df | 2026-09-25 12:35 | 2026-09-25 12:35 | 2026-09-25 12:35 | NVDA | NVDA260925C00227500 | call | 227.5000 | 2026-09-25 | 0.0700 | 0.0600 | 0.0700 | 224.9100 | 14000.00 | 14000.00 | 0.00 | 2000 | 19 | 268544 | 58388 | 4.59930122627937 | 0.417771190521175 | 0.417771190521175 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:35:49.891887Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:35:49.891887Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:35:49.891887Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:39:47.971768Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:39:47.971768Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:50:07.736084Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:50:07.736084Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:52:56.276610Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:56:09.661998Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:11:41.812883Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:59:16.361510Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:03:52.208373Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:05:43.599354Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:05:43.599354Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5424187000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |