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.
Simplify Analyticsuw_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 |
|---|
| 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 |
|---|
| dbff7810-47bd-4dcf-876e-17ec4dc46547 | 2026-09-02 10:22 | 2026-09-02 10:22 | 2026-09-02 10:22 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 5.3500 | 5.2500 | 5.3500 | 222.8200 | 2933305.00 | 2933305.00 | 0.00 | 5483 | 59 | 6049 | 4209 | 1.43715846994536 | 0.316316126055848 | 0.316316126055848 | 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-09-02T14:25:30.485375Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ef009f54-bea1-46f3-a4a8-da9fdced2e0f | 2026-09-02 11:49 | 2026-09-02 11:49 | 2026-09-02 11:49 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 7.9500 | 7.8500 | 8.0000 | 227.8100 | 151834.00 | 101749.00 | 48495.00 | 191 | 37 | 8930 | 4209 | 2.12164409598479 | 0.331507777818285 | 0.331507777818285 | false | false | false | |||||||||||||||||
| 752b9a02-ecd4-4ede-8bc1-7841339a538b | 2026-09-21 13:33 | 2026-09-21 13:33 | 2026-09-21 13:33 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 3.7800 | 3.7500 | 3.8500 | 227.0450 | 73801.00 | 73421.00 | 380.00 | 195 | 5 | 12044 | 14208 | 0.847691441441441 | 0.317846103870794 | 0.316552099376344 | false | false | false | |||||||||||||||||
| 69a82523-dca8-4fd0-b5df-375cd412b683 | 2026-09-22 09:33 | 2026-09-22 09:33 | 2026-09-22 09:33 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 4.7100 | 4.7000 | 4.8500 | 229.3500 | 15550.00 | 0.00 | 14600.00 | 33 | 10 | 553 | 17428 | 0.0317305485425752 | 0.32644988821809 | 0.323148364690692 | false | false | false | |||||||||||||||||
| cb75a200-593b-4400-a640-5ddb39dbc77d | 2026-09-22 10:06 | 2026-09-22 10:06 | 2026-09-22 10:06 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 3.4900 | 3.4500 | 3.5500 | 227.0900 | 10476.00 | 355.00 | 10121.00 | 30 | 6 | 2558 | 17428 | 0.146775304108331 | 0.316071978010071 | 0.311704433141925 | false | false | false | |||||||||||||||||
| 2d90f1a1-efe6-4813-abd9-1c57314ec2df | 2026-09-28 09:30 | 2026-09-28 09:30 | 2026-09-28 09:30 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 3.4200 | 3.3750 | 3.7000 | 229.8050 | 64639.00 | 24054.00 | 40585.00 | 189 | 10 | 257 | 25521 | 0.010070138317464 | 0.374675388976435 | 0.369465424638861 | true | false | false | |||||||||||||||||
| 2292ff33-8962-4979-8ac9-674c17907b28 | 2026-09-28 09:30 | 2026-09-28 09:30 | 2026-09-28 09:30 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 3.8500 | 3.8000 | 3.9500 | 230.4000 | 15799.00 | 2735.00 | 13064.00 | 41 | 12 | 598 | 25521 | 0.0234316837114533 | 0.377354720090543 | 0.371806749721336 | false | false | false | |||||||||||||||||
| 4c7b85e8-a498-40d2-9210-f820a3d585b0 | 2026-09-28 09:30 | 2026-09-28 09:30 | 2026-09-28 09:30 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 3.7900 | 3.7000 | 3.9500 | 230.2799 | 19353.00 | 6155.00 | 13198.00 | 51 | 9 | 680 | 25521 | 0.0266447239528232 | 0.375274949708978 | 0.37528041567969 | false | false | false | |||||||||||||||||
| 99b1810b-c5b5-4a81-ae18-bb0bfd328fc3 | 2026-09-28 09:31 | 2026-09-28 09:31 | 2026-09-28 09:31 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 4.3700 | 4.2750 | 4.4500 | 230.7800 | 22700.00 | 22700.00 | 0.00 | 52 | 6 | 3204 | 25521 | 0.12554366991889 | 0.404307694243881 | 0.402655437638729 | false | false | false | |||||||||||||||||
| 14b67528-a1fc-4508-a834-85c8161eb556 | 2026-09-28 09:31 | 2026-09-28 09:31 | 2026-09-28 09:31 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 4.6700 | 4.6000 | 4.7500 | 231.4750 | 27570.00 | 6600.00 | 20970.00 | 59 | 5 | 4065 | 25521 | 0.159280592453274 | 0.398748559784602 | 0.399682012763874 | false | false | false | |||||||||||||||||
| 4b10dfa1-b1d4-4f9c-8f72-c90a43a3bf9b | 2026-09-28 09:32 | 2026-09-28 09:32 | 2026-09-28 09:32 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 4.5400 | 4.4500 | 4.6500 | 231.3200 | 22720.00 | 0.00 | 22720.00 | 50 | 7 | 5404 | 25521 | 0.211747188589789 | 0.391719671463704 | 0.389006201440195 | false | false | false | |||||||||||||||||
| 3694c54c-05f7-4cda-b354-6a5935ef80f1 | 2026-09-28 09:32 | 2026-09-28 09:32 | 2026-09-28 09:32 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 4.8900 | 4.8500 | 4.9500 | 231.8500 | 12703.00 | 5908.00 | 6305.00 | 26 | 5 | 6220 | 25521 | 0.243720857333177 | 0.397544432315014 | 0.393565430358749 | false | false | false | |||||||||||||||||
| 5d7953c4-c934-4761-8eeb-2b3153cf705e | 2026-09-28 09:33 | 2026-09-28 09:32 | 2026-09-28 09:32 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 5.0600 | 4.9500 | 5.2000 | 232.0000 | 44065.00 | 0.00 | 44065.00 | 87 | 5 | 6649 | 25521 | 0.260530543474002 | 0.38954477018482 | 0.405367694266381 | true | false | false | |||||||||||||||||
| 3d68f12d-86ce-41ab-a836-b6daa5d4009b | 2026-09-28 09:36 | 2026-09-28 09:36 | 2026-09-28 09:36 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 5.0600 | 5.0500 | 5.2000 | 232.2901 | 24291.00 | 0.00 | 21231.00 | 48 | 7 | 9320 | 25521 | 0.365189451823988 | 0.386268461493671 | 0.39428358848264 | false | false | false | |||||||||||||||||
| da96758f-0adc-4fc9-b0c7-c431a85f14bc | 2026-09-28 09:41 | 2026-09-28 09:41 | 2026-09-28 09:41 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 5.5000 | 5.5000 | 5.6000 | 233.0100 | 47865.00 | 0.00 | 46200.00 | 87 | 5 | 12072 | 25521 | 0.473022216997767 | 0.388915748829052 | 0.386937529108334 | false | false | false | |||||||||||||||||
| f597137c-cc1c-4174-9247-0fee83ae9520 | 2026-09-28 10:04 | 2026-09-28 10:04 | 2026-09-28 10:04 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 4.3900 | 4.3000 | 4.4000 | 231.4250 | 20212.00 | 20212.00 | 0.00 | 46 | 11 | 15669 | 25521 | 0.613964970024686 | 0.372174180142088 | 0.367959986215524 | false | false | false | |||||||||||||||||
| d546cf22-d7d0-4eb0-81d0-7d845a2d6afa | 2026-09-28 12:32 | 2026-09-28 12:32 | 2026-09-28 12:32 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 4.3500 | 4.3000 | 4.3500 | 231.4650 | 21742.00 | 21742.00 | 0.00 | 50 | 7 | 30134 | 25521 | 1.18075310528584 | 0.364472792029531 | 0.363417977930827 | false | false | false | |||||||||||||||||
| 65142874-425c-4ca1-a5b1-fb54cd6003ab | 2026-09-28 13:13 | 2026-09-28 13:13 | 2026-09-28 13:13 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 3.9300 | 3.8500 | 3.9500 | 230.8600 | 98138.00 | 98138.00 | 0.00 | 250 | 6 | 31680 | 25521 | 1.24133066886094 | 0.35951938923613 | 0.355228234184132 | false | false | false | |||||||||||||||||
| 3e7bb074-414c-4959-9f34-8f066aa5928a | 2026-09-28 14:36 | 2026-09-28 14:36 | 2026-09-28 14:36 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 3.3200 | 3.3000 | 3.3500 | 229.7950 | 33224.00 | 4672.00 | 28552.00 | 100 | 7 | 34151 | 25521 | 1.33815289369539 | 0.354359558163386 | 0.351233509766333 | false | false | false | |||||||||||||||||
| 2fb69efa-80c4-4b82-9e8a-c480fba3f5f6 | 2026-09-28 15:36 | 2026-09-28 15:36 | 2026-09-28 15:36 | NVDA | NVDA261002C00230000 | call | 230.0000 | 2026-10-02 | 2.8500 | 2.8500 | 2.8800 | 228.7900 | 11982.00 | 0.00 | 11982.00 | 42 | 8 | 36986 | 25521 | 1.44923788252811 | 0.352493124483371 | 0.352404581136443 | 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-09-02T16:19:14.278097Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5479858000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:34:20.106500Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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:33:30.058722Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:30:13.759670Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:30:57.841770Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:30:57.841770Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:31:55.658450Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:31:55.658450Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:33:12.079590Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:33:12.079590Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:33:12.079590Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:37:13.633320Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:43:35.547112Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:05:57.750889Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:34:48.281149Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:15:39.910905Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 5515526000000.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:36:53.342339Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |