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_alerts658,639 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 |
|---|
| 37060b9a-4808-42bb-981b-00f83f4f65af | 2026-08-17 09:34 | 2026-08-17 09:34 | 2026-08-17 09:34 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 10.7000 | 10.5500 | 10.7000 | 225.5700 | 426886.00 | 426886.00 | 0.00 | 399 | 48 | 915 | 16539 | 0.0553237801559949 | 0.481952493727704 | 0.481952493727704 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5084136000000.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3032119a-fcc9-443b-93be-8cc59e55b790 | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 7.1400 | 7.0000 | 7.2500 | 219.6101 | 177856.00 | 167996.00 | 9860.00 | 249 | 30 | 327 | 16714 | 0.0195644369989231 | 0.498558412436415 | 0.495108732082533 | true | false | false | |||||||||||||||||
| 1359a4ce-9c40-4e61-88c8-2f5f165a2fd4 | 2026-08-18 09:44 | 2026-08-18 09:44 | 2026-08-18 09:44 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 7.5000 | 7.4500 | 7.5500 | 220.0000 | 380240.00 | 0.00 | 5240.00 | 507 | 5 | 2663 | 16714 | 0.159327509871964 | 0.48768547811626 | 0.484240067125736 | false | false | false | |||||||||||||||||
| 1d3b99e5-b236-4eb2-bf9f-114b3ba66b25 | 2026-08-19 10:08 | 2026-08-19 10:08 | 2026-08-19 10:08 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 6.1500 | 6.1000 | 6.1500 | 218.3000 | 122900.00 | 122900.00 | 0.00 | 200 | 7 | 5080 | 20445 | 0.248471508926388 | 0.500900719518475 | 0.500168650347605 | false | false | false | |||||||||||||||||
| 20b74ba9-a167-4f7d-b8c8-4d9c8ed77001 | 2026-08-20 09:43 | 2026-08-20 09:43 | 2026-08-20 09:43 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 6.6000 | 6.6000 | 6.6500 | 219.1900 | 331981.00 | 0.00 | 331981.00 | 503 | 5 | 2285 | 22719 | 0.100576609885999 | 0.533100905699986 | 0.53310710689869 | true | false | false | |||||||||||||||||
| 32a78afc-d395-4b73-8c6a-1cb2edfca114 | 2026-08-21 14:49 | 2026-08-21 14:49 | 2026-08-21 14:49 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 4.6500 | 4.6000 | 4.6500 | 215.2100 | 232427.00 | 232427.00 | 0.00 | 500 | 14 | 41118 | 25446 | 1.61589247818911 | 0.558698213746323 | 0.557833273437802 | false | false | false | |||||||||||||||||
| 1560c378-88b4-471f-a46d-6420ce58faaa | 2026-08-25 10:53 | 2026-08-25 10:53 | 2026-08-25 10:53 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 3.0500 | 3.0500 | 3.1500 | 211.8200 | 487819.00 | 0.00 | 487819.00 | 1599 | 41 | 25080 | 57140 | 0.438921946097305 | 0.81044291401504 | 0.806056860440567 | false | false | false | |||||||||||||||||
| f0ec0ae6-c926-49d1-9d3f-28fb99d9f5c7 | 2026-08-26 09:44 | 2026-08-26 09:44 | 2026-08-26 09:44 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 3.5000 | 3.5000 | 3.5500 | 212.6800 | 158210.00 | 0.00 | 158210.00 | 452 | 22 | 4461 | 60397 | 0.0738612845008858 | 1.01956807194115 | 1.01783748730282 | false | false | false | |||||||||||||||||
| fca7a66c-cc2a-4cd9-b89c-31bd7bd3c58a | 2026-08-26 11:59 | 2026-08-26 11:58 | 2026-08-26 11:58 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 2.8000 | 2.8000 | 2.8200 | 210.8150 | 138881.00 | 0.00 | 138881.00 | 496 | 71 | 30987 | 60397 | 0.513055284202858 | 1.00071431173006 | 0.998859469022509 | true | false | false | |||||||||||||||||
| 9166e837-3728-48a6-8721-7b2fd20aa445 | 2026-08-26 15:36 | 2026-08-26 15:36 | 2026-08-26 15:36 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 2.7700 | 2.7500 | 2.7800 | 210.4800 | 138585.00 | 138585.00 | 0.00 | 501 | 44 | 75096 | 60397 | 1.24337301521599 | 1.01157977052206 | 1.01157977052206 | true | false | false | |||||||||||||||||
| a02d9f75-394f-4a70-8839-cbec6bcf6214 | 2026-08-27 09:40 | 2026-08-27 09:40 | 2026-08-27 09:40 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 6.1000 | 6.0000 | 6.1500 | 224.7299 | 162255.00 | 162255.00 | 0.00 | 266 | 8 | 28887 | 96107 | 0.300571238307303 | 0.683532377717386 | 0.680955507297235 | false | false | false | |||||||||||||||||
| 9595a813-f907-4871-99b2-cb969515689c | 2026-08-27 10:10 | 2026-08-27 10:10 | 2026-08-27 10:10 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 6.1800 | 6.1000 | 6.2000 | 225.3101 | 138940.00 | 51660.00 | 0.00 | 225 | 7 | 48935 | 96107 | 0.509172068631837 | 0.573167162989193 | 0.576706758322723 | false | false | false | |||||||||||||||||
| b1ece228-0c67-447e-adb8-df808809eeb8 | 2026-08-27 10:16 | 2026-08-27 10:16 | 2026-08-27 10:16 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 6.4600 | 6.4500 | 6.6000 | 225.8300 | 143970.00 | 0.00 | 128370.00 | 223 | 11 | 53693 | 96107 | 0.558679388598125 | 0.550181719025404 | 0.555495457291682 | false | false | false | |||||||||||||||||
| b8d4958f-2716-43c6-a5d3-3e68ef4fb155 | 2026-08-27 10:16 | 2026-08-27 10:16 | 2026-08-27 10:16 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 6.2700 | 6.2000 | 6.3500 | 225.5100 | 100287.00 | 63447.00 | 36840.00 | 160 | 16 | 54129 | 96107 | 0.563215998834632 | 0.5871850776287 | 0.543164744649692 | true | false | false | |||||||||||||||||
| 80a62390-d5d1-4e86-9ffa-5461b9b91b3a | 2026-08-27 10:17 | 2026-08-27 10:17 | 2026-08-27 10:17 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 6.2000 | 6.2000 | 6.3500 | 225.5700 | 124065.00 | 0.00 | 124065.00 | 200 | 7 | 54491 | 96107 | 0.566982633939255 | 0.541692323001635 | 0.527476113749427 | false | false | false | |||||||||||||||||
| 42aff0c9-7afa-4b71-b87b-90f6a4bb64e9 | 2026-08-27 14:49 | 2026-08-27 14:49 | 2026-08-27 14:49 | NVDA | NVDA260828C00220000 | call | 220.0000 | 2026-08-28 | 6.4000 | 6.4000 | 6.5500 | 225.8000 | 602886.00 | 0.00 | 602886.00 | 942 | 47 | 117418 | 96107 | 1.22174243291332 | 0.49660788113092 | 0.530774654080103 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T13:49:05.616113Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5084136000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |