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 |
|---|
| 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 |
|---|
| b4d30216-4abb-45ca-9671-65b797d8c58a | 2026-09-22 09:32 | 2026-09-22 09:31 | 2026-09-22 09:31 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.7600 | 2.7600 | 2.9000 | 504.2639 | 42787.00 | 278.00 | 42509.00 | 155 | 23 | 225 | 1626 | 0.138376383763838 | 0.323946646310435 | 0.323316863080496 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3697921654518.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T13:32:27.895939Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| ba41a2f8-4a88-4cab-8015-d65e02380740 | 2026-09-23 11:55 | 2026-09-23 11:55 | 2026-09-23 11:55 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 1.0600 | 0.9600 | 1.0700 | 499.5799 | 42334.00 | 42334.00 | 0.00 | 400 | 16 | 4639 | 1671 | 2.77618192698983 | 0.341213794747651 | 0.340105877634525 | false | false | false | |||||||||||||||||
| 1e140710-b4fc-41a7-9330-af4de478bd0c | 2026-09-23 15:47 | 2026-09-23 15:46 | 2026-09-23 15:46 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 0.8600 | 0.8700 | 0.9300 | 499.0000 | 25914.00 | 0.00 | 25914.00 | 300 | 15 | 8973 | 1671 | 5.36983842010772 | 0.317921189474145 | 0.317921189474145 | false | false | false | |||||||||||||||||
| d04e9707-8c89-4877-bde3-509e1ec3578c | 2026-09-25 09:36 | 2026-09-25 09:36 | 2026-09-25 09:36 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.4300 | 2.3700 | 2.6300 | 511.5400 | 12378.00 | 3743.00 | 8635.00 | 51 | 14 | 4495 | 3421 | 1.31394329143525 | 0.546056067717674 | 0.534157592379331 | true | false | false | |||||||||||||||||
| 4502660b-45d1-4772-b698-a316d99525cb | 2026-09-25 09:37 | 2026-09-25 09:37 | 2026-09-25 09:37 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.4700 | 2.3000 | 2.6100 | 511.0000 | 12374.00 | 6387.00 | 5987.00 | 50 | 14 | 6942 | 3421 | 2.02923121894183 | 0.507544430740785 | 0.512632952445148 | false | false | false | |||||||||||||||||
| 136760fa-eafc-4c19-88eb-e780617c7a19 | 2026-09-25 09:41 | 2026-09-25 09:41 | 2026-09-25 09:41 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.7800 | 2.7200 | 2.9000 | 512.6450 | 16121.00 | 3655.00 | 12466.00 | 58 | 20 | 9986 | 3421 | 2.91902952353113 | 0.49248493738922 | 0.480890165209669 | true | false | false | |||||||||||||||||
| dd61367d-8cb7-4c79-9823-226e7ff432bb | 2026-09-25 09:41 | 2026-09-25 09:41 | 2026-09-25 09:41 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.6200 | 2.5300 | 2.7900 | 512.4450 | 10472.00 | 3535.00 | 6937.00 | 40 | 11 | 10040 | 3421 | 2.93481438175972 | 0.508451931012428 | 0.502995760576437 | true | false | false | |||||||||||||||||
| a4be902c-b4de-44ba-8475-22e785806208 | 2026-09-25 09:41 | 2026-09-25 09:41 | 2026-09-25 09:41 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.5200 | 2.3300 | 2.6600 | 511.7200 | 31056.00 | 7112.00 | 21484.00 | 123 | 20 | 10188 | 3421 | 2.97807658579363 | 0.49235272368062 | 0.491570084478606 | true | false | false | |||||||||||||||||
| 9bd0e015-703f-49b8-ba93-bf6f6a5e1ac4 | 2026-09-25 09:42 | 2026-09-25 09:42 | 2026-09-25 09:42 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.9800 | 2.8900 | 3.0000 | 513.0400 | 10128.00 | 7200.00 | 2928.00 | 34 | 9 | 11001 | 3421 | 3.2157263957907 | 0.486880269752762 | 0.494765059944861 | false | false | false | |||||||||||||||||
| 1d15304d-d15e-4102-8cd6-807770ab6792 | 2026-09-25 09:47 | 2026-09-25 09:47 | 2026-09-25 09:47 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 4.0500 | 4.0000 | 4.2500 | 515.0100 | 10922.00 | 405.00 | 10517.00 | 27 | 11 | 15145 | 3421 | 4.42706810874013 | 0.479233484335073 | 0.475285638712882 | false | false | false | |||||||||||||||||
| 2f5ea924-ceb4-4335-bc82-7522f84e2c45 | 2026-09-25 10:09 | 2026-09-25 10:09 | 2026-09-25 10:09 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.3000 | 2.3000 | 2.3800 | 512.0000 | 12902.00 | 0.00 | 12194.00 | 56 | 13 | 21506 | 3421 | 6.28646594562993 | 0.484265845644746 | 0.47287347016187 | true | false | false | |||||||||||||||||
| ae2f46a9-4a43-44ca-ae7b-9f72244a96f8 | 2026-09-25 10:10 | 2026-09-25 10:10 | 2026-09-25 10:10 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.1500 | 2.1000 | 2.1750 | 511.7050 | 10300.00 | 425.00 | 9875.00 | 48 | 14 | 23065 | 3421 | 6.74218064893306 | 0.468394221600662 | 0.47681096890588 | false | false | false | |||||||||||||||||
| b81d7ddf-62f1-48d1-825c-a4c463b88c68 | 2026-09-25 10:28 | 2026-09-25 10:27 | 2026-09-25 10:27 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.6900 | 2.5000 | 2.8500 | 513.4700 | 12356.00 | 7402.00 | 4954.00 | 46 | 24 | 32389 | 3421 | 9.46769950306928 | 0.441623378547187 | 0.432329233560106 | false | false | false | |||||||||||||||||
| 1677d35f-ec92-40d3-99db-e319937c3332 | 2026-09-25 10:29 | 2026-09-25 10:29 | 2026-09-25 10:29 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 3.0700 | 3.0500 | 3.2000 | 514.0450 | 10426.00 | 640.00 | 9786.00 | 34 | 5 | 33026 | 3421 | 9.65390236772874 | 0.455767622642518 | 0.427440482459575 | false | false | false | |||||||||||||||||
| a1a321bd-ae62-48ed-b0b1-a4794aaf1359 | 2026-09-25 10:34 | 2026-09-25 10:34 | 2026-09-25 10:34 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 3.0000 | 3.0000 | 3.1000 | 514.1100 | 15305.00 | 305.00 | 15000.00 | 51 | 6 | 34564 | 3421 | 10.1034785150541 | 0.420489779458752 | 0.410201456164531 | false | false | false | |||||||||||||||||
| 690fb00e-72e9-47fe-b50b-64ae71ea7416 | 2026-09-25 10:44 | 2026-09-25 10:44 | 2026-09-25 10:44 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.7600 | 2.6200 | 2.9000 | 513.8100 | 17386.00 | 16834.00 | 552.00 | 63 | 14 | 36228 | 3421 | 10.5898859982461 | 0.411849001922061 | 0.409161266160137 | true | false | false | |||||||||||||||||
| 9f506930-1922-48cb-8724-8f1b5b17ec8f | 2026-09-25 11:14 | 2026-09-25 11:14 | 2026-09-25 11:14 | MSFT | MSFT260925C00512500 | call | 512.5000 | 2026-09-25 | 2.9900 | 2.9300 | 3.2000 | 514.4000 | 79839.00 | 305.00 | 79534.00 | 267 | 26 | 38432 | 3421 | 11.2341420637241 | 0.407721996903932 | 0.394120112255587 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:00:35.931587Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:43:32.172352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:47:32.064714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:09:41.700516Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:11:57.153448Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:33:57.900979Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:37:32.022295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:47:41.799650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:15:19.758010Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |