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_alerts566,287 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 |
|---|
| 2d734712-bd81-49cc-8a48-37b5f7460b86 | 2026-09-08 10:00 | 2026-09-08 10:00 | 2026-09-08 10:00 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 30.8900 | 30.0000 | 31.0000 | 276.4293 | 864880.00 | 772780.00 | 92100.00 | 280 | 18 | 1551 | 8359 | 0.185548510587391 | 0.90426100757788 | 0.895774034233351 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 75708254289.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2aca53d7-bcdc-4932-945d-221236b6bf0f | 2026-09-08 12:12 | 2026-09-08 12:12 | 2026-09-08 12:12 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 33.4200 | 32.9000 | 33.9500 | 280.5201 | 190504.00 | 170494.00 | 20010.00 | 57 | 5 | 2347 | 8359 | 0.280775212345974 | 0.908598233480029 | 0.904968468451926 | false | false | false | |||||||||||||||||
| d960a3f8-9c70-4a0d-a62d-2507b6a7a14e | 2026-09-17 09:37 | 2026-09-17 09:37 | 2026-09-17 09:37 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 27.8700 | 27.5500 | 28.2500 | 284.0000 | 440301.00 | 217950.00 | 222351.00 | 158 | 5 | 395 | 9938 | 0.0397464278526867 | 0.80094100651075 | 0.792972037796945 | false | false | false | |||||||||||||||||
| a5381b50-248c-4ecf-a032-4abc73cc21fb | 2026-09-17 12:22 | 2026-09-17 12:22 | 2026-09-17 12:22 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 24.8300 | 24.7000 | 24.9500 | 279.2150 | 124145.00 | 17395.00 | 106750.00 | 50 | 6 | 2261 | 9938 | 0.227510565506138 | 0.792302901497892 | 0.792302901497892 | false | false | false | |||||||||||||||||
| 57824957-594a-4298-ad0e-2237e634fd10 | 2026-09-17 13:11 | 2026-09-17 13:11 | 2026-09-17 13:11 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 24.5300 | 24.5000 | 25.0000 | 278.6400 | 110365.00 | 22095.00 | 88270.00 | 45 | 16 | 2351 | 9938 | 0.236566713624472 | 0.792694653578279 | 0.792694653578279 | false | false | false | |||||||||||||||||
| e540d0c8-1927-4be1-8b51-ddc6b96db4c0 | 2026-09-18 12:48 | 2026-09-18 12:48 | 2026-09-18 12:48 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 20.9400 | 19.9000 | 21.0000 | 274.0700 | 77490.00 | 62855.00 | 14635.00 | 37 | 13 | 473 | 8912 | 0.0530745062836625 | 0.774911641500331 | 0.768774768474156 | true | false | false | |||||||||||||||||
| a5696d69-0a5c-4f40-bf7f-d695f8acebc0 | 2026-09-22 10:05 | 2026-09-22 10:05 | 2026-09-22 10:05 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 22.4300 | 21.8000 | 23.0000 | 279.0850 | 78520.00 | 67330.00 | 11190.00 | 35 | 13 | 52 | 8238 | 0.00631221170186939 | 0.790696896233743 | 0.790696896233743 | false | false | false | |||||||||||||||||
| 28b38b15-91c2-448f-958a-a7fe3aef493a | 2026-09-24 09:39 | 2026-09-24 09:39 | 2026-09-24 09:39 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 12.2600 | 12.0000 | 12.7500 | 259.9159 | 78470.00 | 8610.00 | 69860.00 | 64 | 5 | 234 | 8243 | 0.0283877229164139 | 0.781951867761116 | 0.776179426511968 | false | false | false | |||||||||||||||||
| 28754106-2265-4960-a38e-cbe139196067 | 2026-09-29 09:30 | 2026-09-29 09:30 | 2026-09-29 09:30 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 16.3300 | 16.0000 | 16.5000 | 275.3600 | 65305.00 | 32700.00 | 32605.00 | 40 | 6 | 56 | 7528 | 0.00743889479277365 | 0.768471825235041 | 0.768471825235041 | true | false | false | |||||||||||||||||
| e71629bd-c64b-4234-a5e8-775c35de378b | 2026-09-29 11:19 | 2026-09-29 11:18 | 2026-09-29 11:18 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 30.3400 | 30.3000 | 30.7500 | 297.0100 | 87985.00 | 0.00 | 87985.00 | 29 | 6 | 1199 | 7528 | 0.159272051009564 | 0.818946829541077 | 0.820949623144958 | false | false | false | |||||||||||||||||
| dcb88d4c-fe66-4bcf-9439-1fc4c96f6962 | 2026-09-29 13:54 | 2026-09-29 13:54 | 2026-09-29 13:54 | BE | BE261016C00280000 | call | 280.0000 | 2026-10-16 | 26.8000 | 26.7500 | 27.0500 | 292.7600 | 514563.00 | 511888.00 | 2675.00 | 192 | 10 | 1777 | 7528 | 0.236052072263549 | 0.791892436571535 | 0.788085975094324 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 82691497663.00 |
| 2026-10-27 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 82691497663.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 82691497663.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 78235298918.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 81445646989.00 |
| 2026-10-27 |
| 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 |
| Industrials |
| 81050980346.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:40:59.800251Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85781089523.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:31:03.669649Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85781089523.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:19:13.720895Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85781089523.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:58:05.042752Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |