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 |
|---|
| 35796856-da9d-48cd-9ca2-3c93c122d824 | 2026-09-29 13:25 | 2026-09-29 13:25 | 2026-09-29 13:25 | SPOT | SPOT261009C00480000 | call | 480.0000 | 2026-10-09 | 22.2400 | 19.8500 | 22.2500 | 494.7000 | 15565.00 | 13345.00 | 2220.00 | 7 | 6 | 7 | 19 | 0.368421052631579 | 0.423408808903327 | 0.410862232115313 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 101611285279.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T17:28:10.749874Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 09fbb560-4043-4e00-b03e-fd9db6b5f1db | 2026-09-29 13:25 | 2026-09-29 13:25 | 2026-09-29 13:25 | SPOT | SPOT261002C00485000 | call | 485.0000 | 2026-10-02 | 14.1200 | 11.0000 | 14.1500 | 494.2400 | 21185.00 | 18365.00 | 2820.00 | 15 | 7 | 15 | 4 | 3.75 | 0.488532999358662 | 0.488532999358662 | true | false | false | |||||||||||||||||
| f7758ba3-03ab-4721-9a2d-f765d3fcb709 | 2026-09-29 13:23 | 2026-09-29 13:23 | 2026-09-29 13:23 | SPOT | SPOT261218C00500000 | call | 500.0000 | 2026-12-18 | 40.1300 | 38.1500 | 40.1500 | 494.2300 | 44140.00 | 24090.00 | 20050.00 | 11 | 8 | 24 | 255 | 0.0941176470588235 | 0.448296789529882 | 0.44119178665552 | false | false | false | |||||||||||||||||
| ae736450-67cc-4868-a32e-d5e3c97063c8 | 2026-09-29 13:23 | 2026-09-29 13:23 | 2026-09-29 13:23 | SPOT | SPOT261016C00482500 | call | 482.5000 | 2026-10-16 | 23.7600 | 21.2500 | 23.8000 | 494.2300 | 47510.00 | 42840.00 | 4670.00 | 20 | 7 | 22 | 0 | 0 | 0.417322700533444 | 0.387109091319356 | true | false | false | |||||||||||||||||
| 683c67d9-b6cc-4a40-84c3-1eca04dcf3c2 | 2026-09-29 13:23 | 2026-09-29 13:23 | 2026-09-29 13:23 | SPOT | SPOT261002C00495000 | call | 495.0000 | 2026-10-02 | 7.9500 | 6.5000 | 7.9500 | 493.0100 | 62773.00 | 61983.00 | 790.00 | 79 | 23 | 96 | 38 | 2.52631578947368 | 0.494484655380048 | 0.491675469393344 | false | false | false | |||||||||||||||||
| 2f985592-2ee1-47a3-a9dd-46c248c5cdaa | 2026-09-29 13:23 | 2026-09-29 13:23 | 2026-09-29 13:23 | SPOT | SPOT261002C00487500 | call | 487.5000 | 2026-10-02 | 11.8800 | 10.2000 | 12.0500 | 494.2300 | 26125.00 | 18040.00 | 8085.00 | 22 | 5 | 22 | 0 | 0 | 0.503692471515137 | 0.428914333566388 | false | false | false | |||||||||||||||||
| bd73b769-f7a2-4a6c-97e1-92a55cbc4535 | 2026-09-29 10:03 | 2026-09-29 10:03 | 2026-09-29 10:03 | SPOT | SPOT261016C00475000 | call | 475.0000 | 2026-10-16 | 26.3500 | 24.5500 | 26.4000 | 490.3900 | 26345.00 | 21095.00 | 5250.00 | 10 | 7 | 10 | 18 | 0.555555555555556 | 0.415765399174396 | 0.410449869918382 | true | false | false | |||||||||||||||||
| 9b77696e-dc23-487f-a365-efee084c00c3 | 2026-09-29 10:01 | 2026-09-29 10:01 | 2026-09-29 10:01 | SPOT | SPOT261016C00470000 | call | 470.0000 | 2026-10-16 | 29.1000 | 27.6000 | 29.9500 | 489.8800 | 49465.00 | 20385.00 | 29080.00 | 17 | 11 | 18 | 49 | 0.36734693877551 | 0.40622007657864 | 0.40622007657864 | false | false | false | |||||||||||||||||
| 79ebcddc-5fbf-463b-982a-a1e27cded0b3 | 2026-09-28 14:57 | 2026-09-28 14:57 | 2026-09-28 14:57 | SPOT | SPOT261030C00575000 | call | 575.0000 | 2026-10-30 | 8.6500 | 8.5000 | 9.0000 | 500.8050 | 70900.00 | 870.00 | 35320.00 | 82 | 11 | 703 | 939 | 0.748668796592119 | 0.520484114828764 | 0.518160613571643 | false | false | false | |||||||||||||||||
| f18f1b12-8c46-4534-b1c6-cbab92aa76bb | 2026-09-28 14:57 | 2026-09-28 14:57 | 2026-09-28 14:57 | SPOT | SPOT261030C00555000 | call | 555.0000 | 2026-10-30 | 12.5100 | 12.4000 | 12.9500 | 500.8050 | 27520.00 | 5010.00 | 13795.00 | 22 | 7 | 737 | 278 | 2.65107913669065 | 0.516904070367086 | 0.514913028789392 | true | false | false | |||||||||||||||||
| 6c3f1adf-f3a0-41a5-9d01-88ca8613955f | 2026-09-28 14:46 | 2026-09-28 14:46 | 2026-09-28 14:46 | SPOT | SPOT261030C00555000 | call | 555.0000 | 2026-10-30 | 12.7400 | 12.3000 | 13.1500 | 501.5025 | 38225.00 | 21650.00 | 0.00 | 30 | 10 | 167 | 278 | 0.600719424460432 | 0.51691943811103 | 0.514941455470087 | true | false | false | |||||||||||||||||
| f05d9606-e901-47ab-95cb-a5f2968dc9d1 | 2026-09-25 15:59 | 2026-09-25 15:59 | 2026-09-25 15:59 | SPOT | SPOT261218C00580000 | call | 580.0000 | 2026-12-18 | 20.1600 | 19.0500 | 20.2500 | 510.0000 | 46365.00 | 38365.00 | 8000.00 | 23 | 11 | 27 | 111 | 0.243243243243243 | 0.438516880539556 | 0.437120887649422 | false | false | false | |||||||||||||||||
| 363ed8f5-a1ab-4436-adbb-cdc88a2d587b | 2026-09-25 15:09 | 2026-09-25 15:09 | 2026-09-25 15:09 | SPOT | SPOT261120C00590000 | call | 590.0000 | 2026-11-20 | 12.2900 | 11.2500 | 12.3000 | 508.0000 | 29500.00 | 27050.00 | 2450.00 | 24 | 7 | 25 | 12 | 2.08333333333333 | 0.464499245260235 | 0.463700032721574 | false | false | false | |||||||||||||||||
| 2551015e-d8e2-4861-acaa-e093afafb490 | 2026-09-25 09:41 | 2026-09-25 09:40 | 2026-09-25 09:40 | SPOT | SPOT261218C00620000 | call | 620.0000 | 2026-12-18 | 12.0800 | 11.4500 | 13.8000 | 507.0050 | 67620.00 | 33950.00 | 33670.00 | 56 | 6 | 56 | 229 | 0.244541484716157 | 0.450728622224463 | 0.445125375380652 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 101611285279.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:28:10.749874Z"} |
| 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 |
| 101611285279.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:23:13.824260Z"} |
| 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 |
| 101611285279.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:23:13.824260Z"} |
| 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 |
| 101611285279.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:23:13.824260Z"} |
| 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 |
| 101611285279.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:23:13.824260Z"} |
| 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 |
| 101611285279.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:06:19.717900Z"} |
| 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 |
| 101611285279.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:02:34.176265Z"} |
| 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 |
| 102403740508.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:00:50.307488Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 102403740508.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:00:50.307488Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 102403740508.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:52:01.773916Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 104976647095.00 |
| 2026-10-22 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 104976647095.00 |
| 2026-10-22 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:10:45.993353Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 104976647095.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |