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 |
|---|
| 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 |
|---|
| 499a6c36-f17d-45dd-ba4e-87983cc56d40 | 2026-09-21 11:26 | 2026-09-21 11:26 | 2026-09-21 11:26 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 3.0600 | 3.0500 | 3.1000 | 224.7600 | 15295.00 | 0.00 | 15295.00 | 50 | 5 | 5552 | 2984 | 1.86058981233244 | 0.317213959723955 | 0.318279300550902 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 5479858000000.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:27:55.894324Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| c8a7c4a4-3645-4203-8efd-b45bb10afe5a | 2026-09-21 12:39 | 2026-09-21 12:39 | 2026-09-21 12:39 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 2.6500 | 2.6300 | 2.6500 | 225.8450 | 14839.00 | 14839.00 | 0.00 | 56 | 5 | 7331 | 2984 | 2.45676943699732 | 0.329107888665863 | 0.329227024181911 | true | false | false | |||||||||||||||||
| 99abe263-c5de-4561-851d-cce85b39f8e7 | 2026-09-22 09:33 | 2026-09-22 09:33 | 2026-09-22 09:33 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.3800 | 1.3600 | 1.3900 | 229.1000 | 40691.00 | 40691.00 | 0.00 | 294 | 6 | 1856 | 6232 | 0.297817715019255 | 0.367699343961993 | 0.369116733318143 | false | false | false | |||||||||||||||||
| 7a1a8234-2dd3-4684-b5de-cd5ffdb6a4f2 | 2026-09-23 10:14 | 2026-09-23 10:14 | 2026-09-23 10:14 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.7500 | 1.7300 | 1.7700 | 226.2300 | 10674.00 | 10324.00 | 350.00 | 61 | 9 | 9222 | 10853 | 0.84971897171289 | 0.350746700327966 | 0.350348207837116 | true | false | false | |||||||||||||||||
| 3a1f890c-6336-4c7f-83df-775f05bba32c | 2026-09-23 11:37 | 2026-09-23 11:37 | 2026-09-23 11:37 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 2.0700 | 2.0400 | 2.1200 | 225.2000 | 14273.00 | 14062.00 | 0.00 | 69 | 16 | 22702 | 10853 | 2.09177186031512 | 0.335365337062517 | 0.337359162431695 | true | false | false | |||||||||||||||||
| 411ceb00-5c08-451c-aecc-9a524edc6b14 | 2026-09-24 15:57 | 2026-09-24 15:57 | 2026-09-24 15:57 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.7200 | 1.7000 | 1.7300 | 224.5600 | 51746.00 | 47454.00 | 2400.00 | 300 | 50 | 17778 | 10614 | 1.67495760316563 | 0.318705531491466 | 0.322413461917571 | true | false | false | |||||||||||||||||
| 99157184-ece2-4304-ad4b-ef42d2e24ce2 | 2026-09-25 09:38 | 2026-09-25 09:38 | 2026-09-25 09:38 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 0.7400 | 0.7100 | 0.7600 | 225.0000 | 12474.00 | 12474.00 | 0.00 | 168 | 8 | 8726 | 10531 | 0.828601272433767 | 0.432199891188818 | 0.435839833558156 | false | false | false | |||||||||||||||||
| 5a0e0646-88d8-4f39-9c53-c27960f20931 | 2026-09-25 10:05 | 2026-09-25 10:05 | 2026-09-25 10:05 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.1100 | 1.0900 | 1.1300 | 224.0000 | 11275.00 | 11165.00 | 0.00 | 102 | 17 | 25704 | 10531 | 2.4407938467382 | 0.363900473880934 | 0.369357654576145 | true | false | false | |||||||||||||||||
| 1da14842-9e80-46a7-be49-431352a2229b | 2026-09-25 10:06 | 2026-09-25 10:06 | 2026-09-25 10:06 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.3000 | 1.3000 | 1.3200 | 224.1800 | 10550.00 | 1320.00 | 9230.00 | 81 | 8 | 27107 | 10531 | 2.57401956129522 | 0.357143977657263 | 0.366411941191284 | false | false | false | |||||||||||||||||
| d5330603-8bcf-40fa-a6ad-b2bf489bd44e | 2026-09-25 10:14 | 2026-09-25 10:14 | 2026-09-25 10:14 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.2100 | 1.1700 | 1.2400 | 224.3350 | 21271.00 | 19672.00 | 1599.00 | 176 | 18 | 31995 | 10531 | 3.03817301300921 | 0.368963135300984 | 0.374540373626568 | true | false | false | |||||||||||||||||
| 272b4cd7-fb16-4fdb-9aeb-ceeed9cf34b2 | 2026-09-25 10:15 | 2026-09-25 10:15 | 2026-09-25 10:15 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.4600 | 1.4600 | 1.4900 | 223.9976 | 36797.00 | 0.00 | 36797.00 | 252 | 6 | 33465 | 10531 | 3.1777608964011 | 0.383222117141548 | 0.380815826778752 | false | false | false | |||||||||||||||||
| 743b9397-5a94-4f13-82f6-0e8e1959a900 | 2026-09-25 10:28 | 2026-09-25 10:28 | 2026-09-25 10:28 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.8800 | 1.8000 | 1.9700 | 223.2800 | 11100.00 | 10913.00 | 187.00 | 59 | 12 | 36717 | 10531 | 3.48656347925173 | 0.386625768548879 | 0.37964909791696 | true | false | false | |||||||||||||||||
| b5e9bbd0-8c42-445a-9a0a-3bc79a47c2b3 | 2026-09-25 10:56 | 2026-09-25 10:56 | 2026-09-25 10:56 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.0800 | 1.0700 | 1.1000 | 224.0000 | 17267.00 | 0.00 | 1391.00 | 160 | 10 | 41873 | 10531 | 3.97616560630519 | 0.32519500680652 | 0.325203831448033 | false | false | false | |||||||||||||||||
| 01566fab-8f64-4b53-a13e-a7cdf4252916 | 2026-09-25 11:20 | 2026-09-25 11:20 | 2026-09-25 11:20 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.0700 | 1.0500 | 1.0700 | 224.2610 | 10912.00 | 10700.00 | 0.00 | 102 | 15 | 47635 | 10531 | 4.52331212610388 | 0.309424799470814 | 0.30792688278684 | false | false | false | |||||||||||||||||
| 704fd5e3-ba9a-4c06-a067-f17c9f3cf895 | 2026-09-25 12:20 | 2026-09-25 12:20 | 2026-09-25 12:20 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 0.5400 | 0.5300 | 0.5700 | 225.0000 | 29778.00 | 29778.00 | 0.00 | 551 | 8 | 74405 | 10531 | 7.06533092773716 | 0.337076428619782 | 0.348036486863121 | true | false | false | |||||||||||||||||
| 26f21eaa-1a64-477e-9810-428862e689d8 | 2026-09-25 12:21 | 2026-09-25 12:21 | 2026-09-25 12:21 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 0.6800 | 0.6700 | 0.7000 | 224.8550 | 10685.00 | 10549.00 | 136.00 | 157 | 23 | 76312 | 10531 | 7.2464153451714 | 0.338822957640158 | 0.331530246231236 | true | false | false | |||||||||||||||||
| 7f5a1fbd-49c9-4a1f-bcf3-0f9187591ab7 | 2026-09-25 12:23 | 2026-09-25 12:23 | 2026-09-25 12:23 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 1.0000 | 0.9800 | 1.0100 | 224.3933 | 28003.00 | 28003.00 | 0.00 | 280 | 16 | 80307 | 10531 | 7.62577153166841 | 0.370122750121542 | 0.366038324308653 | false | false | false | |||||||||||||||||
| a1a832e6-578a-447c-9baa-e9d039b32713 | 2026-09-25 12:30 | 2026-09-25 12:30 | 2026-09-25 12:30 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 0.6100 | 0.5900 | 0.6100 | 225.0000 | 12102.00 | 12102.00 | 0.00 | 200 | 18 | 84950 | 10531 | 8.06666033615041 | 0.335852425392053 | 0.341433297577364 | false | false | false | |||||||||||||||||
| 8a20fe30-d9e2-43a4-a154-e34efe51ce2a | 2026-09-25 12:34 | 2026-09-25 12:34 | 2026-09-25 12:34 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 0.6800 | 0.6700 | 0.6800 | 224.8800 | 10062.00 | 9928.00 | 134.00 | 148 | 5 | 86881 | 10531 | 8.25002373943595 | 0.343831369625413 | 0.349484136415357 | false | false | false | |||||||||||||||||
| 3e0f5df2-9a99-401a-b7a8-dccda253b349 | 2026-09-25 12:36 | 2026-09-25 12:36 | 2026-09-25 12:36 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 0.6900 | 0.6700 | 0.7000 | 224.7900 | 10118.00 | 10118.00 | 0.00 | 146 | 5 | 87968 | 10531 | 8.35324280695091 | 0.35222766086253 | 0.334397822866489 | false | false | false | |||||||||||||||||
| cf6d945a-26aa-4806-93ec-f04ddeb24d2c | 2026-09-25 13:49 | 2026-09-25 13:49 | 2026-09-25 13:49 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 0.5200 | 0.5000 | 0.5300 | 224.8200 | 52051.00 | 32915.00 | 0.00 | 1001 | 59 | 112515 | 10531 | 10.6841705441079 | 0.301144322693156 | 0.300283953606503 | true | false | false | |||||||||||||||||
| e2d3582c-e9c6-4e05-a787-66f90deed42e | 2026-09-25 14:30 | 2026-09-25 14:30 | 2026-09-25 14:30 | NVDA | NVDA260925P00225000 | put | 225.0000 | 2026-09-25 | 0.8000 | 0.7800 | 0.8100 | 224.3600 | 12897.00 | 8577.00 | 0.00 | 161 | 16 | 126467 | 10531 | 12.0090209856614 | 0.35113402563368 | 0.353922744363102 | true | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5479858000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:41:29.676906Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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:35:07.797098Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:16:29.786516Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:41:14.023510Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5434791000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:58:08.680508Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-25T14:05:23.720155Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T14:06:13.706447Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T14:15:34.282180Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T14:17:27.635758Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T14:29:28.038338Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-25T14:56:21.812618Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T15:25:06.221939Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-25T16:20:53.748346Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T16:23:36.031471Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T16:27:03.681802Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-25T16:31:25.590153Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T17:50:01.932714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T18:31:26.314014Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |