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 |
|---|
| 37d461ee-23a7-4685-a63e-b679621e0ab6 | 2026-09-21 10:08 | 2026-09-21 10:07 | 2026-09-21 10:07 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 1.6100 | 1.6000 | 1.6300 | 337.3950 | 16079.00 | 0.00 | 16079.00 | 100 | 7 | 5639 | 7099 | 0.794337230595859 | 0.268786316799726 | 0.267712961987917 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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:08:15.762043Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 1f3e460b-44f9-4a36-b4fc-9e55e0fb93c3 | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 1.3700 | 1.3300 | 1.3900 | 336.9400 | 13714.00 | 13714.00 | 0.00 | 100 | 5 | 8953 | 7099 | 1.26116354416115 | 0.261797779181975 | 0.258463608402943 | false | false | false | |||||||||||||||||
| 07e2a7e5-28b6-49a6-a782-4fce75f52c0c | 2026-09-21 15:28 | 2026-09-21 15:28 | 2026-09-21 15:28 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 2.1100 | 2.0800 | 2.1200 | 339.3000 | 18104.00 | 4876.00 | 208.00 | 86 | 8 | 30893 | 7099 | 4.3517396816453 | 0.241315232672855 | 0.237305034083635 | false | false | false | |||||||||||||||||
| da0ba538-42ae-4b1e-a023-222bec13c57b | 2026-09-21 15:40 | 2026-09-21 15:40 | 2026-09-21 15:40 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 2.0600 | 2.0600 | 2.1200 | 339.2600 | 14219.00 | 0.00 | 14219.00 | 69 | 19 | 32229 | 7099 | 4.53993520214115 | 0.237688358077539 | 0.237145950339552 | true | false | false | |||||||||||||||||
| fb10a430-c556-4183-911a-1920dc98e51a | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 2.9300 | 2.8300 | 3.0000 | 341.0396 | 15819.00 | 8801.00 | 7018.00 | 54 | 18 | 522 | 7166 | 0.072843985487022 | 0.333109764821309 | 0.330890417647969 | true | false | false | |||||||||||||||||
| 63ef5953-d8bf-47c1-a787-8c9b2023f883 | 2026-09-22 09:31 | 2026-09-22 09:31 | 2026-09-22 09:31 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 4.6600 | 4.6000 | 4.8000 | 343.5350 | 10715.00 | 5655.00 | 5060.00 | 23 | 9 | 1883 | 7166 | 0.262768629639967 | 0.363323213423764 | 0.336823661015873 | false | false | false | |||||||||||||||||
| 9aea6a23-c750-4ba9-9db8-554768e4e835 | 2026-09-22 09:35 | 2026-09-22 09:35 | 2026-09-22 09:35 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 3.6200 | 3.6000 | 3.9000 | 342.2922 | 21749.00 | 14157.00 | 7227.00 | 60 | 7 | 3629 | 7166 | 0.506419201786213 | 0.319883792077123 | 0.319883792077123 | false | false | false | |||||||||||||||||
| 4effd603-4d05-470b-aa42-718e1bce767a | 2026-09-22 09:46 | 2026-09-22 09:46 | 2026-09-22 09:46 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 3.3900 | 3.3500 | 3.4500 | 341.0000 | 13578.00 | 1035.00 | 12543.00 | 40 | 5 | 6151 | 7166 | 0.858358917108568 | 0.324800642424403 | 0.316319993869616 | false | false | false | |||||||||||||||||
| cecd2bf7-4340-46c7-80ed-c116ccd7ef85 | 2026-09-22 09:59 | 2026-09-22 09:59 | 2026-09-22 09:59 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 2.4400 | 2.3900 | 2.4400 | 340.0000 | 14882.00 | 14396.00 | 0.00 | 61 | 11 | 8879 | 7166 | 1.23904549260396 | 0.309128460955181 | 0.307715530995404 | true | false | false | |||||||||||||||||
| c5ce8b13-6b56-4ee2-b287-a507f2fe279a | 2026-09-22 10:05 | 2026-09-22 10:05 | 2026-09-22 10:05 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 1.8800 | 1.8000 | 1.9600 | 339.2500 | 30216.00 | 2301.00 | 27345.00 | 161 | 18 | 10224 | 7166 | 1.42673737091822 | 0.301983169513076 | 0.30144106097487 | true | false | false | |||||||||||||||||
| 88d997ff-6b80-4b84-b501-b368f40d1452 | 2026-09-22 10:09 | 2026-09-22 10:09 | 2026-09-22 10:09 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 1.9400 | 1.8500 | 1.9800 | 339.4100 | 11804.00 | 190.00 | 11051.00 | 61 | 11 | 11898 | 7166 | 1.6603404967904 | 0.301074338355258 | 0.302436462769898 | true | false | false | |||||||||||||||||
| 7b198ca8-6fea-4488-ab81-73d52a134645 | 2026-09-22 10:12 | 2026-09-22 10:12 | 2026-09-22 10:12 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 1.8300 | 1.8200 | 1.9000 | 339.4550 | 25102.00 | 0.00 | 20402.00 | 137 | 8 | 12521 | 7166 | 1.74727881663411 | 0.299480604082781 | 0.290982376249062 | true | false | false | |||||||||||||||||
| bcb5ae72-3f68-4f1c-b869-7872f44df2e3 | 2026-09-22 10:13 | 2026-09-22 10:13 | 2026-09-22 10:13 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 1.8100 | 1.7800 | 1.8400 | 339.3000 | 10676.00 | 0.00 | 1446.00 | 59 | 8 | 13045 | 7166 | 1.82040189785096 | 0.301071380453268 | 0.298229296431033 | true | false | false | |||||||||||||||||
| fbe68b67-a7c7-4f60-a23e-02e608f8faf9 | 2026-09-22 10:24 | 2026-09-22 10:24 | 2026-09-22 10:24 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 2.0200 | 2.0100 | 2.0900 | 339.0000 | 12698.00 | 205.00 | 12493.00 | 63 | 7 | 17342 | 7166 | 2.42003907340218 | 0.293231002628983 | 0.293228185632231 | false | false | false | |||||||||||||||||
| a461ea7e-aab4-4b56-9ccb-fc7839cd07ef | 2026-09-22 10:28 | 2026-09-22 10:28 | 2026-09-22 10:28 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 2.4000 | 2.3700 | 2.4400 | 340.5800 | 14402.00 | 0.00 | 14402.00 | 60 | 6 | 19907 | 7166 | 2.77797934691599 | 0.293731753127874 | 0.292314466832316 | true | false | false | |||||||||||||||||
| dc075512-91a3-41d4-a911-6657768abc1b | 2026-09-22 10:54 | 2026-09-22 10:54 | 2026-09-22 10:54 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 3.2400 | 3.1000 | 3.3500 | 341.9250 | 23346.00 | 13296.00 | 10050.00 | 72 | 11 | 28112 | 7166 | 3.92296957856545 | 0.285324759403516 | 0.291182718056021 | false | false | false | |||||||||||||||||
| adb04761-81bb-41a7-84bd-046a0baea442 | 2026-09-22 13:17 | 2026-09-22 13:17 | 2026-09-22 13:17 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 2.7800 | 2.7800 | 2.8300 | 341.5100 | 13346.00 | 0.00 | 13346.00 | 48 | 8 | 35222 | 7166 | 4.91515489813006 | 0.271067739127937 | 0.268107432679418 | false | false | false | |||||||||||||||||
| 806db4e9-7f3c-47e9-94f5-c995d89450a2 | 2026-09-22 14:21 | 2026-09-22 14:21 | 2026-09-22 14:21 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 2.4600 | 2.4300 | 2.4800 | 341.1450 | 12038.00 | 2728.00 | 0.00 | 49 | 6 | 37248 | 7166 | 5.19787887245325 | 0.257142286385062 | 0.252778452685567 | false | false | false | |||||||||||||||||
| 4c21b64f-9660-4b3c-8437-f184b6bd7f4e | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 1.5600 | 1.5600 | 1.6200 | 339.0000 | 62373.00 | 0.00 | 62373.00 | 400 | 9 | 45204 | 7166 | 6.30812168573821 | 0.249227784666204 | 0.248241623392677 | false | false | false | |||||||||||||||||
| 18ca0740-c39b-48d3-8f87-a59b6ea15c2d | 2026-09-23 09:47 | 2026-09-23 09:47 | 2026-09-23 09:47 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 0.7500 | 0.7400 | 0.7700 | 338.0000 | 10904.00 | 1500.00 | 9404.00 | 146 | 17 | 15123 | 8337 | 1.81396185678302 | 0.386797664479306 | 0.383727718765838 | false | false | false | |||||||||||||||||
| 068ff01d-a211-4b24-a171-375701710bde | 2026-09-23 09:54 | 2026-09-23 09:54 | 2026-09-23 09:54 | AAPL | AAPL260923C00340000 | call | 340.0000 | 2026-09-23 | 0.5000 | 0.4800 | 0.5200 | 337.7520 | 14824.00 | 149.00 | 13145.00 | 296 | 22 | 20800 | 8337 | 2.49490224301307 | 0.362354242339952 | 0.365956433298161 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:36:05.660724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:46:43.807773Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| 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 |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:10:05.607073Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:13:22.184869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:15:02.242582Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:27:42.600893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:31:31.654153Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:23:35.118331Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:23:27.944500Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-23T13:49:25.662048Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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:55:29.867504Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |