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 |
|---|
| 2e6f5e1d-4f57-4c2f-8b8d-2cf8a83bc285 | 2026-09-25 15:35 | 2026-09-25 15:35 | 2026-09-25 15:35 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 2.8800 | 2.8200 | 2.9500 | 340.2002 | 11232.00 | 10080.00 | 1152.00 | 39 | 13 | 2470 | 10229 | 0.24147032945547 | 0.220006449650657 | 0.220006449650657 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4977636972600.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| f47eb367-dcb3-4642-8b8b-62976e6da5f4 | 2026-09-25 15:01 | 2026-09-25 15:01 | 2026-09-25 15:01 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 2.9200 | 2.9000 | 2.9600 | 340.0000 | 18972.00 | 1178.00 | 17794.00 | 65 | 26 | 2230 | 10229 | 0.218007625378825 | 0.22237787441828 | 0.223379505412927 | false | false | false | true | ||||||||||||||||
| a2fcd3c4-c3d2-40f8-a2d0-dabc9fe768cf | 2026-09-25 12:04 | 2026-09-25 12:04 | 2026-09-25 12:04 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 3.1500 | 3.0500 | 3.1500 | 340.0700 | 29293.00 | 29293.00 | 0.00 | 93 | 9 | 795 | 10229 | 0.077720207253886 | 0.228946277268083 | 0.228846440036569 | false | false | false | true | ||||||||||||||||
| 3d4995c7-db7a-4477-85a1-be647d8acf8b | 2026-09-25 10:42 | 2026-09-25 10:42 | 2026-09-25 10:42 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 4.1300 | 4.0500 | 4.2000 | 336.8100 | 31418.00 | 24464.00 | 6954.00 | 76 | 31 | 227 | 10229 | 0.0221918076058266 | 0.231249800904553 | 0.231476976532296 | false | false | false | true | ||||||||||||||||
| 6eddb074-f293-4495-ad61-29c3c23c9367 | 2026-09-24 12:11 | 2026-09-24 12:11 | 2026-09-24 12:11 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 4.2500 | 4.1000 | 4.2500 | 337.0000 | 36550.00 | 36550.00 | 0.00 | 86 | 22 | 577 | 10111 | 0.0570665611710019 | 0.232597925764299 | 0.232597925764299 | false | false | false | true | ||||||||||||||||
| aebda9ba-6ab5-4826-bb37-6adcc6429ac4 | 2026-09-23 14:15 | 2026-09-23 14:15 | 2026-09-23 14:15 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 4.4500 | 4.3000 | 4.5000 | 337.0801 | 10680.00 | 10680.00 | 0.00 | 24 | 7 | 1995 | 9778 | 0.204029453876048 | 0.23298436636173 | 0.23298436636173 | true | false | false | true | ||||||||||||||||
| 594eb7f9-1643-4c39-a00f-26559f3ddcce | 2026-09-23 11:31 | 2026-09-23 11:31 | 2026-09-23 11:31 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 4.8000 | 4.7000 | 4.8500 | 336.1650 | 10560.00 | 10560.00 | 0.00 | 22 | 5 | 1630 | 9778 | 0.166700756800982 | 0.234220876663628 | 0.234220876663628 | false | false | false | true | ||||||||||||||||
| 56628b01-cf87-45fd-9790-e88f56195236 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 4.1500 | 4.1000 | 4.1500 | 338.0000 | 61420.00 | 61420.00 | 0.00 | 148 | 9 | 1438 | 9778 | 0.147064839435467 | 0.235609944511663 | 0.235765741827762 | true | false | false | true | ||||||||||||||||
| c2bd80a7-2563-4ea6-b9dd-752ea26f4c3e | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 4.4500 | 4.4500 | 4.6000 | 337.4500 | 17355.00 | 0.00 | 17355.00 | 39 | 13 | 500 | 9778 | 0.0511352014726938 | 0.236962630754 | 0.236962630754 | true | false | false | true | ||||||||||||||||
| 86c84f19-f775-41ef-947c-6834c4c1eb46 | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 4.5400 | 4.4500 | 4.6000 | 337.3400 | 58615.00 | 34257.00 | 24358.00 | 129 | 31 | 447 | 9778 | 0.0457148701165883 | 0.240673938712178 | 0.237741596638861 | false | false | false | true | ||||||||||||||||
| ee3e0d07-cd42-41bf-a992-acfffc7257a2 | 2026-09-22 15:52 | 2026-09-22 15:51 | 2026-09-22 15:51 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 3.7500 | 3.6500 | 3.7500 | 340.0000 | 18375.00 | 18375.00 | 0.00 | 49 | 8 | 2397 | 9509 | 0.252076979703439 | 0.234950098442368 | 0.234950098442368 | false | false | false | true | ||||||||||||||||
| 2c431d43-ace7-46ba-8e45-704b7bae302e | 2026-09-21 10:46 | 2026-09-21 10:46 | 2026-09-21 10:46 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 5.0000 | 4.8000 | 5.0500 | 336.5000 | 15000.00 | 14500.00 | 500.00 | 30 | 8 | 1237 | 9269 | 0.133455604703852 | 0.235470275424632 | 0.235203286726424 | false | false | false | true | ||||||||||||||||
| 9d1a6768-fa63-4700-bad7-ca029bd3c8a1 | 2026-09-18 14:32 | 2026-09-18 14:32 | 2026-09-18 14:32 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 5.6000 | 5.5500 | 5.6000 | 335.8300 | 140000.00 | 140000.00 | 0.00 | 250 | 8 | 3110 | 7639 | 0.407121350962168 | 0.233853139004349 | 0.233853139004349 | false | false | false | true | ||||||||||||||||
| 240ed344-6286-468e-8b3b-fe968af85652 | 2026-09-18 11:32 | 2026-09-18 11:31 | 2026-09-18 11:31 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 6.0500 | 6.0500 | 6.1000 | 334.8900 | 102850.00 | 0.00 | 102850.00 | 170 | 7 | 1641 | 7639 | 0.214818693546276 | 0.236709119200702 | 0.236709119200702 | false | false | false | true | ||||||||||||||||
| ba89554f-717d-4712-aa84-1490f565fce7 | 2026-09-17 09:38 | 2026-09-17 09:37 | 2026-09-17 09:37 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 7.6000 | 7.5500 | 7.6000 | 331.6700 | 380000.00 | 182400.00 | 0.00 | 500 | 6 | 1022 | 6802 | 0.150249926492208 | 0.239324115551903 | 0.239324115551903 | false | false | false | true | ||||||||||||||||
| 70483860-1b30-4224-8cfe-9d05ef469941 | 2026-09-17 09:32 | 2026-09-17 09:32 | 2026-09-17 09:32 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 6.8500 | 6.8500 | 7.0500 | 333.6705 | 342500.00 | 0.00 | 342500.00 | 500 | 5 | 514 | 6802 | 0.0755660099970597 | 0.241846692469802 | 0.241846692469802 | true | false | false | true | ||||||||||||||||
| 04781852-b4eb-41e0-9e64-fe2b940bf7c1 | 2026-09-14 13:09 | 2026-09-14 13:09 | 2026-09-14 13:09 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 7.2500 | 7.1500 | 7.3500 | 334.3700 | 181202.00 | 135527.00 | 45675.00 | 250 | 13 | 1531 | 5669 | 0.2700652672429 | 0.248451853653072 | 0.248451853653072 | false | false | false | true | ||||||||||||||||
| 64e210ba-8bcf-413c-9c01-b4fd030a8592 | 2026-09-14 10:54 | 2026-09-14 10:54 | 2026-09-14 10:54 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 8.0000 | 7.9000 | 8.0500 | 332.5300 | 195182.00 | 194382.00 | 0.00 | 244 | 45 | 1086 | 5669 | 0.191568177809137 | 0.24868460979035 | 0.248242943816532 | false | false | false | true | ||||||||||||||||
| ad036aa5-de7e-4771-8268-e0da941b95b4 | 2026-09-11 11:08 | 2026-09-11 11:08 | 2026-09-11 11:08 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 7.3000 | 7.2500 | 7.4500 | 335.6850 | 440190.00 | 730.00 | 439460.00 | 603 | 19 | 2099 | 2944 | 0.712975543478261 | 0.252742450286213 | 0.252742450286213 | false | false | false | true | ||||||||||||||||
| 989bb590-1fa1-46f1-a55e-155e9982aef9 | 2026-09-03 11:19 | 2026-09-03 11:19 | 2026-09-03 11:19 | AAPL | AAPL261016P00330000 | put | 330.0000 | 2026-10-16 | 10.2500 | 10.2500 | 10.5500 | 330.0700 | 102500.00 | 0.00 | 102500.00 | 100 | 6 | 373 | 3452 | 0.108053302433372 | 0.243789998041882 | 0.243789998041882 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:03:13.684497Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:05:43.599354Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:43:48.295772Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:13:55.044964Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:19:20.444616Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:35:15.101362Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:47:49.730853Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4905541723400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4905541723400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918238660000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918238660000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:28:46.184785Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |