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_alerts658,639 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 |
|---|
| expirydate |
|---|
| 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 |
|---|
| 06046586-e1fa-4e35-955c-bd35fa691dba | 2026-09-30 12:26 | 2026-09-30 12:26 | 2026-09-30 12:26 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 1.4400 | 1.4400 | 1.4700 | 336.7800 | 12111.00 | 0.00 | 12111.00 | 84 | 7 | 30816 | 14358 | 2.14625992478061 | 0.273872873871164 | 0.273124677313266 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 4807322892000.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T16:28:12.605453Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 225a3590-9392-4071-a16e-b371700f4f85 | 2026-09-30 10:42 | 2026-09-30 10:42 | 2026-09-30 10:42 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 2.4400 | 2.3900 | 2.4500 | 338.7200 | 48861.00 | 48861.00 | 0.00 | 200 | 28 | 22063 | 14358 | 1.53663462877838 | 0.300802006122182 | 0.299791180991919 | true | false | false | |||||||||||||||||
| 60ee8e20-4c6e-48ed-aee3-30d9d77864b5 | 2026-09-30 10:42 | 2026-09-30 10:41 | 2026-09-30 10:41 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 2.6700 | 2.6200 | 2.6700 | 339.0601 | 39985.00 | 39985.00 | 0.00 | 150 | 10 | 21704 | 14358 | 1.51163114639922 | 0.307067923057947 | 0.307525203105111 | false | false | false | |||||||||||||||||
| 255f7150-1ec8-4706-aea1-e208aef67dde | 2026-09-30 10:28 | 2026-09-30 10:28 | 2026-09-30 10:28 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 2.1600 | 2.1600 | 2.1800 | 338.0500 | 16417.00 | 0.00 | 16417.00 | 76 | 5 | 18167 | 14358 | 1.26528764451874 | 0.301194441088154 | 0.300164118194931 | true | false | false | |||||||||||||||||
| bbf224ad-bb35-4f77-bb29-7a0c267c1f01 | 2026-09-30 10:14 | 2026-09-30 10:13 | 2026-09-30 10:13 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 2.0900 | 2.0600 | 2.1100 | 337.0000 | 10445.00 | 3165.00 | 7280.00 | 50 | 5 | 15540 | 14358 | 1.08232344337651 | 0.306276262867459 | 0.303157344172999 | false | false | false | |||||||||||||||||
| 6cc33432-5093-40d8-bea7-d0cf1eec08d3 | 2026-09-30 10:13 | 2026-09-30 10:13 | 2026-09-30 10:13 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 2.0800 | 2.0000 | 2.2500 | 337.0000 | 14353.00 | 3858.00 | 10495.00 | 69 | 13 | 15485 | 14358 | 1.07849282629893 | 0.305081740226648 | 0.298432515161342 | false | false | false | |||||||||||||||||
| 853e51f6-abfe-449c-86b2-02804f5f33ce | 2026-09-30 10:10 | 2026-09-30 10:10 | 2026-09-30 10:10 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 2.5700 | 2.5700 | 2.6300 | 338.8500 | 22109.00 | 261.00 | 21848.00 | 86 | 6 | 14859 | 14358 | 1.03489343919766 | 0.310321282396339 | 0.307072450317048 | false | false | false | |||||||||||||||||
| 7f008a10-02bc-4d61-b705-50cc649572f0 | 2026-09-30 10:03 | 2026-09-30 10:03 | 2026-09-30 10:03 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 2.2400 | 2.2000 | 2.3000 | 338.1400 | 13244.00 | 224.00 | 12795.00 | 59 | 6 | 11522 | 14358 | 0.802479453962948 | 0.303511872003142 | 0.300497866171087 | false | false | false | |||||||||||||||||
| cd061ef1-4beb-46fc-bac1-f399f4209f8a | 2026-09-30 10:03 | 2026-09-30 10:03 | 2026-09-30 10:03 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 2.1500 | 2.1500 | 2.2000 | 338.0300 | 33562.00 | 1094.00 | 32468.00 | 156 | 10 | 11352 | 14358 | 0.790639364814041 | 0.302015058401726 | 0.304092233237165 | false | false | false | |||||||||||||||||
| d203ea4d-51fc-492d-a598-54416da551e5 | 2026-09-30 10:01 | 2026-09-30 10:01 | 2026-09-30 10:01 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 1.8300 | 1.7500 | 1.8800 | 337.2100 | 12255.00 | 1454.00 | 6774.00 | 67 | 12 | 10494 | 14358 | 0.730881738403677 | 0.300191903064674 | 0.296211350350419 | false | false | false | |||||||||||||||||
| 473f2ff5-7174-4ad7-ac73-8a4899ec381a | 2026-09-30 09:50 | 2026-09-30 09:50 | 2026-09-30 09:50 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 0.7400 | 0.7400 | 0.7700 | 333.0000 | 11177.00 | 76.00 | 11101.00 | 151 | 8 | 4633 | 14358 | 0.322677253099317 | 0.285817026156298 | 0.287831681053039 | false | false | false | |||||||||||||||||
| 3deb929e-8ed6-4689-b676-c57afd734b07 | 2026-09-29 10:25 | 2026-09-29 10:25 | 2026-09-29 10:25 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 0.7900 | 0.7900 | 0.8100 | 332.2800 | 13154.00 | 0.00 | 13154.00 | 166 | 15 | 5252 | 10626 | 0.494259363824581 | 0.271340785028759 | 0.270081853361265 | false | false | false | |||||||||||||||||
| a1b96e61-18a8-4393-842f-9bc2a012e199 | 2026-09-24 15:55 | 2026-09-24 15:55 | 2026-09-24 15:55 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 3.0000 | 3.0000 | 3.3500 | 336.7100 | 36610.00 | 0.00 | 36610.00 | 122 | 6 | 5757 | 7382 | 0.779869953942021 | 0.222122645479833 | 0.216926612799552 | false | false | false | |||||||||||||||||
| 2724685d-f6d5-4ea9-920b-702f3f1a6a32 | 2026-09-24 13:35 | 2026-09-24 13:35 | 2026-09-24 13:35 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 3.4500 | 3.4500 | 3.5000 | 337.3200 | 24165.00 | 0.00 | 24165.00 | 70 | 6 | 4723 | 7382 | 0.639799512327283 | 0.227714835370304 | 0.227714835370304 | false | false | false | |||||||||||||||||
| 6f79e472-99c1-4459-b055-0c85be77052d | 2026-09-24 09:53 | 2026-09-24 09:53 | 2026-09-24 09:53 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 3.2600 | 3.3000 | 3.4500 | 336.5950 | 16276.00 | 0.00 | 16276.00 | 50 | 7 | 714 | 7382 | 0.0967217556217827 | 0.233859751415391 | 0.232301076489367 | false | false | false | |||||||||||||||||
| 447ef97b-b783-45ce-ac26-60352234cf94 | 2026-09-22 10:18 | 2026-09-22 10:18 | 2026-09-22 10:18 | AAPL | AAPL261002C00340000 | call | 340.0000 | 2026-10-02 | 5.0500 | 5.0500 | 5.2500 | 339.0300 | 103550.00 | 0.00 | 103550.00 | 205 | 7 | 1864 | 6102 | 0.305473615208128 | 0.240801995854215 | 0.238567898270812 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:46:23.879003Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:42:27.796047Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:31:08.759375Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:14:21.800901Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:14:21.800901Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:11:55.859186Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:03:52.520300Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:03:52.520300Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:01:58.194953Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:52:36.034936Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4807322892000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:27:05.819137Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-24T19:58:08.680508Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T17:37:15.785672Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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:20:22.518739Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |