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 | strike |
|---|
| 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 |
|---|
| a9cc1fdf-cf92-4837-9646-adfc69d5350f | 2026-10-01 15:46 | 2026-10-01 15:46 | 2026-10-01 15:46 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 0.7900 | 0.7800 | 0.8000 | 727.0600 | 11085.00 | 6321.00 | 4525.00 | 141 | 15 | 36499 | 6095 | 5.98835110746514 | 0.454840190726971 | 0.453325637482353 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 1600768938538.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T19:48:34.387970Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| d7fd69cb-cc97-4601-b470-2ed30b4e7e44 | 2026-10-01 15:33 | 2026-10-01 15:33 | 2026-10-01 15:33 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 1.0200 | 1.0100 | 1.0400 | 728.7600 | 10156.00 | 0.00 | 10156.00 | 100 | 14 | 34512 | 6095 | 5.66234618539787 | 0.461033137447115 | 0.458404950081562 | false | false | false | |||||||||||||||||
| b2ac3757-baf5-4dc5-9be3-87cd89a8c54d | 2026-10-01 13:16 | 2026-10-01 13:16 | 2026-10-01 13:16 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 1.0900 | 1.0800 | 1.1000 | 727.0000 | 21787.00 | 0.00 | 21787.00 | 200 | 19 | 28165 | 6095 | 4.62100082034454 | 0.493538155059367 | 0.492217437785104 | false | false | false | |||||||||||||||||
| f4b87ced-324d-41d4-b887-a35861ddb7b5 | 2026-10-01 11:57 | 2026-10-01 11:57 | 2026-10-01 11:57 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 1.3800 | 1.3800 | 1.4200 | 728.5050 | 19602.00 | 0.00 | 19182.00 | 142 | 20 | 24318 | 6095 | 3.98982772764561 | 0.510702684618566 | 0.508365091868698 | false | false | false | |||||||||||||||||
| e58b2757-6b3b-4bb1-b130-f501e5a366fd | 2026-10-01 10:32 | 2026-10-01 10:32 | 2026-10-01 10:32 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 1.2000 | 1.1700 | 1.2100 | 725.1300 | 11977.00 | 6577.00 | 5400.00 | 100 | 8 | 13797 | 6095 | 2.2636587366694 | 0.54059884679647 | 0.54059884679647 | false | false | false | |||||||||||||||||
| 93e58b6c-6722-427a-bc69-5f60f7b5bb22 | 2026-10-01 10:16 | 2026-10-01 10:16 | 2026-10-01 10:16 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 1.1500 | 1.1400 | 1.2200 | 723.4400 | 120010.00 | 50951.00 | 67449.00 | 1040 | 76 | 9981 | 6095 | 1.63757178014766 | 0.561333027219338 | 0.560383465487686 | true | false | false | |||||||||||||||||
| 303bb271-74a6-403a-89c5-f10839b4a03c | 2026-10-01 09:49 | 2026-10-01 09:49 | 2026-10-01 09:49 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 2.0000 | 1.9600 | 2.0200 | 728.3150 | 16780.00 | 0.00 | 16780.00 | 84 | 14 | 6520 | 6095 | 1.06972928630025 | 0.579450623599629 | 0.575312478860146 | false | false | false | |||||||||||||||||
| a4eaeff9-0c18-495b-906b-e1d656615046 | 2026-09-30 15:49 | 2026-09-30 15:48 | 2026-09-30 15:48 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 3.6500 | 3.6500 | 3.8000 | 731.4600 | 46360.00 | 0.00 | 46360.00 | 127 | 5 | 10515 | 5342 | 1.96836390864845 | 0.47587037419829 | 0.472935686668421 | true | false | false | |||||||||||||||||
| d5cf2465-b460-4d0e-a894-aea0e7cc9c46 | 2026-09-29 15:33 | 2026-09-29 15:33 | 2026-09-29 15:33 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 6.3500 | 6.3500 | 6.4500 | 734.1350 | 10164.00 | 0.00 | 10164.00 | 16 | 9 | 15147 | 4659 | 3.25112685125563 | 0.472478916833884 | 0.471637553413417 | true | false | false | |||||||||||||||||
| c00f7eb9-5461-46b5-8f43-0dfa2a4992c5 | 2026-09-29 13:51 | 2026-09-29 13:51 | 2026-09-29 13:51 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 4.9100 | 4.8500 | 5.0000 | 727.3700 | 12287.00 | 0.00 | 12287.00 | 25 | 6 | 9933 | 4659 | 2.13200257566001 | 0.494272289657603 | 0.493801458269647 | false | false | false | |||||||||||||||||
| 79efe685-8623-4f09-b17a-9b1390f1161d | 2026-09-29 09:39 | 2026-09-29 09:39 | 2026-09-29 09:39 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 4.5900 | 4.5500 | 4.6500 | 725.0300 | 23865.00 | 0.00 | 23865.00 | 52 | 5 | 2503 | 4659 | 0.537239751019532 | 0.504193608536137 | 0.504327630277271 | true | false | false | |||||||||||||||||
| 6d6bc52b-30e2-43d9-9957-dee3e67b3b5a | 2026-09-22 12:42 | 2026-09-22 12:42 | 2026-09-22 12:42 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 20.3300 | 20.3000 | 20.9000 | 742.2900 | 24400.00 | 0.00 | 24400.00 | 12 | 5 | 2161 | 1075 | 2.01023255813953 | 0.483228945409167 | 0.479136746051891 | false | false | false | |||||||||||||||||
| 3d465927-2518-4ee3-a9b1-49ae8f8fcf72 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 18.1400 | 18.0000 | 19.7000 | 733.8900 | 29020.00 | 0.00 | 29020.00 | 16 | 7 | 19 | 1075 | 0.0176744186046512 | 0.504655909611327 | 0.50877156802769 | true | false | false | |||||||||||||||||
| b9f84e2f-92fe-41f1-bb64-59955f1e69dd | 2026-09-21 12:00 | 2026-09-21 12:00 | 2026-09-21 12:00 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 12.7000 | 12.2000 | 12.9500 | 721.4800 | 12695.00 | 5080.00 | 7615.00 | 10 | 7 | 1216 | 782 | 1.55498721227621 | 0.473120374380971 | 0.472028838740243 | true | false | false | |||||||||||||||||
| 880f3ee7-7d27-42c2-b934-1f26955a28c1 | 2026-09-21 11:14 | 2026-09-21 11:14 | 2026-09-21 11:14 | META | META261002C00750000 | call | 750.0000 | 2026-10-02 | 8.0500 | 7.8000 | 8.2000 | 708.5100 | 16108.00 | 16108.00 | 0.00 | 20 | 9 | 1023 | 782 | 1.30818414322251 | 0.453105642843524 | 0.453105642843524 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T19:36:48.028615Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T17:19:17.986160Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T15:59:11.726372Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:33:19.556143Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:17:16.073634Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:50:07.772259Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:50:15.606466Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:36:36.492519Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:52:12.020508Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:42:07.664429Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:48:50.097062Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| 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 |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:04:05.802260Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:16:13.769524Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |