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_alerts474,253 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 |
|---|
| eb294885-3e1c-4631-9cd5-bbbe3115a6cc | 2026-09-23 11:48 | 2026-09-23 11:48 | 2026-09-23 11:48 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 4.9000 | 4.8500 | 4.9500 | 225.0000 | 24500.00 | 0.00 | 0.00 | 50 | 5 | 5973 | 3262 | 1.83108522378909 | 0.463654912596571 | 0.463654912596571 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 5434791000000.00 | 2026-11-18 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T15:51:01.874824Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 27efc60f-1ed9-4116-9d7f-8796558401ed | 2026-09-22 15:59 | 2026-09-22 15:59 | 2026-09-22 15:59 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.1300 | 2.1000 | 2.1300 | 228.0000 | 82644.00 | 82644.00 | 0.00 | 388 | 28 | 26132 | 491 | 53.2219959266802 | 0.317305594935132 | 0.317305594935132 | false | false | false | true | ||||||||||||||||
| 4fa5f0f1-2fca-4f56-8183-7fffc5f6b54d | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.1500 | 2.1000 | 2.1500 | 228.7100 | 13317.00 | 13317.00 | 0.00 | 62 | 8 | 25431 | 491 | 51.7942973523422 | 0.304614155084911 | 0.298453978033137 | false | false | false | true | ||||||||||||||||
| bfea5ed8-2274-4083-8c1d-66faa3bf4e9c | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.1000 | 2.0900 | 2.1300 | 228.0000 | 48069.00 | 213.00 | 47856.00 | 229 | 15 | 25206 | 491 | 51.3360488798371 | 0.299247145057352 | 0.305849907682641 | true | false | false | true | ||||||||||||||||
| cfca9ca0-79b9-4b2a-bb07-fe14c1eaa2f2 | 2026-09-22 15:46 | 2026-09-22 15:46 | 2026-09-22 15:46 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 1.8600 | 1.8400 | 1.8600 | 229.1400 | 13018.00 | 12648.00 | 0.00 | 70 | 11 | 23884 | 491 | 48.6435845213849 | 0.292713167995646 | 0.290566873880659 | false | false | false | true | ||||||||||||||||
| 0c751ab3-87b9-4ba6-aadc-441aa18b4cec | 2026-09-22 15:45 | 2026-09-22 15:45 | 2026-09-22 15:45 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 1.8100 | 1.8000 | 1.8200 | 229.2150 | 13575.00 | 3801.00 | 0.00 | 75 | 6 | 23513 | 491 | 47.887983706721 | 0.292054494816681 | 0.291432582486209 | false | false | false | true | ||||||||||||||||
| f0decb58-a07b-4b3f-b31d-df9085529d18 | 2026-09-22 15:14 | 2026-09-22 15:14 | 2026-09-22 15:14 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 1.6300 | 1.6300 | 1.6600 | 229.5700 | 13239.00 | 0.00 | 13239.00 | 81 | 7 | 21289 | 491 | 43.3584521384929 | 0.297129244704583 | 0.295600309616181 | true | false | false | true | ||||||||||||||||
| 0983fc83-4fab-47bd-ac3c-87d96f263919 | 2026-09-22 14:00 | 2026-09-22 14:00 | 2026-09-22 14:00 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 1.9700 | 1.9400 | 2.0300 | 228.9800 | 11620.00 | 11620.00 | 0.00 | 59 | 9 | 17549 | 491 | 35.7413441955193 | 0.298549953633626 | 0.308765039673214 | true | false | false | true | ||||||||||||||||
| 1fe269eb-12e3-4031-b733-90d774377452 | 2026-09-22 13:57 | 2026-09-22 13:57 | 2026-09-22 13:57 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 1.9800 | 1.9800 | 2.0000 | 229.0800 | 13860.00 | 0.00 | 13860.00 | 70 | 20 | 17381 | 491 | 35.3991853360489 | 0.310857572022599 | 0.310857572022599 | true | false | false | true | ||||||||||||||||
| e008a449-b921-42ec-8aca-027c16d5b825 | 2026-09-22 13:27 | 2026-09-22 13:27 | 2026-09-22 13:27 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 1.7800 | 1.7800 | 1.7900 | 229.4200 | 30082.00 | 0.00 | 30082.00 | 169 | 5 | 13969 | 491 | 28.4501018329939 | 0.309817775630174 | 0.309817775630174 | false | false | false | true | ||||||||||||||||
| 24656f6c-af05-44a3-b784-b83b30394e21 | 2026-09-22 13:18 | 2026-09-22 13:18 | 2026-09-22 13:18 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 1.6600 | 1.6400 | 1.6600 | 229.7600 | 28054.00 | 28054.00 | 0.00 | 169 | 5 | 12130 | 491 | 24.7046843177189 | 0.322941885887958 | 0.322941885887958 | false | false | false | true | ||||||||||||||||
| 90ef3be4-e08d-4670-8955-beffefb49e0f | 2026-09-22 12:51 | 2026-09-22 12:51 | 2026-09-22 12:51 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.0000 | 1.9900 | 2.0100 | 229.0550 | 16200.00 | 0.00 | 15400.00 | 81 | 7 | 8834 | 491 | 17.9918533604888 | 0.310051126638992 | 0.311971358206434 | false | false | false | true | ||||||||||||||||
| 6498a584-b5b9-4895-94de-db85e2976f97 | 2026-09-22 11:08 | 2026-09-22 11:07 | 2026-09-22 11:07 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.3200 | 2.3000 | 2.3300 | 228.0000 | 24389.00 | 24389.00 | 0.00 | 105 | 6 | 5695 | 491 | 11.5987780040733 | 0.34887542543481 | 0.346701799388161 | false | false | false | true | ||||||||||||||||
| 24ab5c8f-7703-4b6f-9347-38510da55d67 | 2026-09-22 10:54 | 2026-09-22 10:54 | 2026-09-22 10:54 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.8000 | 2.7700 | 2.8000 | 228.0600 | 15400.00 | 15400.00 | 0.00 | 55 | 11 | 5415 | 491 | 11.0285132382892 | 0.355573568783545 | 0.34937851859335 | false | false | false | true | ||||||||||||||||
| cb26229d-b9d9-4433-8d75-faf6b4fca89d | 2026-09-22 10:35 | 2026-09-22 10:35 | 2026-09-22 10:35 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.5000 | 2.4700 | 2.5000 | 228.6150 | 21000.00 | 21000.00 | 0.00 | 84 | 16 | 4400 | 491 | 8.96130346232179 | 0.362547379950152 | 0.362547379950152 | false | false | false | true | ||||||||||||||||
| 9172a682-8996-4447-9549-30a2285e325f | 2026-09-22 10:35 | 2026-09-22 10:35 | 2026-09-22 10:35 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.3900 | 2.3600 | 2.3900 | 228.6900 | 11950.00 | 11950.00 | 0.00 | 50 | 6 | 4308 | 491 | 8.77393075356416 | 0.348602600616246 | 0.348602600616246 | false | false | false | true | ||||||||||||||||
| 52b81193-20b7-420d-a161-a41a0951f162 | 2026-09-22 09:46 | 2026-09-22 09:46 | 2026-09-22 09:46 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 3.5500 | 3.4500 | 3.5500 | 227.0000 | 21295.00 | 20945.00 | 0.00 | 60 | 6 | 2976 | 491 | 6.06109979633401 | 0.404692009412398 | 0.392449199924752 | false | false | false | true | ||||||||||||||||
| 6bddc549-af41-4c81-80a7-b24881a18a3f | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.5600 | 2.5600 | 2.5900 | 228.7750 | 13058.00 | 258.00 | 12800.00 | 51 | 5 | 2227 | 491 | 4.53564154786151 | 0.400995373025232 | 0.396686299533486 | false | false | false | true | ||||||||||||||||
| 5de83492-6dd7-43b9-86d0-1fabd92f08e5 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.7300 | 2.7300 | 2.7500 | 228.5400 | 14196.00 | 0.00 | 14196.00 | 52 | 8 | 1846 | 491 | 3.75967413441955 | 0.40276506274766 | 0.40276506274766 | false | false | false | true | ||||||||||||||||
| ff11998e-dc8b-4ab3-aa28-cb1f8720f884 | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.5800 | 2.5800 | 2.6100 | 228.8000 | 25542.00 | 0.00 | 25542.00 | 99 | 12 | 1600 | 491 | 3.25865580448065 | 0.404185250614655 | 0.404185250614655 | false | false | false | true | ||||||||||||||||
| f3a2797f-63b0-4b3d-880f-382ba034f9bd | 2026-09-22 09:37 | 2026-09-22 09:37 | 2026-09-22 09:37 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.6000 | 2.5700 | 2.6100 | 228.8300 | 21358.00 | 21358.00 | 0.00 | 82 | 13 | 1283 | 491 | 2.61303462321792 | 0.413533508524054 | 0.412275804622479 | false | false | false | true | ||||||||||||||||
| b9e4c567-bd06-459a-972a-3de4885fdfcf | 2026-09-22 09:37 | 2026-09-22 09:37 | 2026-09-22 09:37 | NVDA | NVDA260923P00230000 | put | 230.0000 | 2026-09-23 | 2.5900 | 2.5600 | 2.5900 | 228.8700 | 11137.00 | 11137.00 | 0.00 | 43 | 10 | 1121 | 491 | 2.28309572301426 | 0.415149001313206 | 0.415149001313206 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:30:55.056187Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:23:35.118331Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:52:20.560244Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:35:47.926453Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:35:47.926453Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:46:43.807773Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 5515767000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |