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_alerts425,429 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 | expiry |
|---|
| 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 |
|---|
| 2d6073cd-2663-42d2-85da-f6e5cb51d8f2 | 2026-09-24 13:34 | 2026-09-24 13:34 | 2026-09-24 13:34 | RDW | RDW261120C00014000 | call | 14.0000 | 2026-11-20 | 1.0500 | 1.0000 | 1.1000 | 11.7801 | 31601.00 | 26036.00 | 4200.00 | 301 | 28 | 365 | 2478 | 0.147296206618241 | 0.961572037421255 | 0.961572037421255 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Other | Industrials | 2817416703.00 | 2026-11-04 | 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 |
| a86823b9-e516-4e5f-9ac7-c7ccbd86116c | 2026-09-24 13:28 | 2026-09-24 13:28 | 2026-09-24 13:28 | RDW | RDW261002C00013000 | call | 13.0000 | 2026-10-02 | 0.2500 | 0.1500 | 0.2500 | 11.8199 | 10349.00 | 10349.00 | 0.00 | 416 | 19 | 617 | 1396 | 0.441977077363897 | 0.930456078351151 | 0.913066393025014 | true | false | false | true | ||||||||||||||||
| f3179775-d8cd-42e1-ac7c-cf773223726e | 2026-09-24 13:11 | 2026-09-24 13:11 | 2026-09-24 13:11 | RDW | RDW261016P00011000 | put | 11.0000 | 2026-10-16 | 0.6500 | 0.5500 | 0.6500 | 11.6250 | 12950.00 | 12950.00 | 0.00 | 200 | 5 | 2895 | 5364 | 0.539709172259508 | 0.851174222399209 | 0.841728804223003 | false | false | false | true | ||||||||||||||||
| 70058e44-3bff-4a48-9dbb-b33868df7e6b | 2026-09-24 12:41 | 2026-09-24 12:41 | 2026-09-24 12:41 | RDW | RDW261016P00011000 | put | 11.0000 | 2026-10-16 | 0.6500 | 0.5500 | 0.6500 | 11.6350 | 12950.00 | 12950.00 | 0.00 | 200 | 6 | 2495 | 5364 | 0.465137956748695 | 0.854490695379532 | 0.845040927097103 | false | false | false | true | ||||||||||||||||
| 34df85e6-47b1-4acc-a46d-bb5aa44878cd | 2026-09-23 13:54 | 2026-09-23 13:54 | 2026-09-23 13:54 | RDW | RDW261002C00011000 | call | 11.0000 | 2026-10-02 | 0.6100 | 0.6000 | 0.7500 | 11.2199 | 18166.00 | 0.00 | 18166.00 | 300 | 6 | 371 | 500 | 0.742 | 0.713637450450008 | 0.684321624098746 | false | false | false | true | ||||||||||||||||
| cc4b145a-465f-45c1-ba9e-49eb96c9a7db | 2026-09-22 10:08 | 2026-09-22 10:08 | 2026-09-22 10:08 | RDW | RDW270115C00015000 | call | 15.0000 | 2027-01-15 | 1.3500 | 1.3500 | 1.4000 | 11.6286 | 13527.00 | 0.00 | 13527.00 | 100 | 6 | 228 | 7373 | 0.0309236403092364 | 0.909385027852803 | 0.909385027852803 | false | false | false | true | ||||||||||||||||
| 47f7376b-66c7-43b7-8d1e-52847fad8a45 | 2026-09-21 15:59 | 2026-09-21 15:59 | 2026-09-21 15:59 | RDW | RDW270219C00010000 | call | 10.0000 | 2027-02-19 | 3.3600 | 3.3000 | 3.5000 | 11.0000 | 20164.00 | 0.00 | 20164.00 | 60 | 5 | 65 | 375 | 0.173333333333333 | 0.878804624478119 | 0.878804624478119 | false | false | false | true | ||||||||||||||||
| 0e109fcb-36c0-40b9-a662-26368b86b8d6 | 2026-09-21 11:55 | 2026-09-21 11:55 | 2026-09-21 11:55 | RDW | RDW261016C00012000 | call | 12.0000 | 2026-10-16 | 0.9500 | 0.8500 | 0.9500 | 11.6478 | 14224.00 | 14224.00 | 0.00 | 150 | 8 | 272 | 1847 | 0.147265836491608 | 0.904580850960005 | 0.896357961623022 | false | false | false | true | ||||||||||||||||
| fab5f736-1022-4e05-9d77-621cd2abffd0 | 2026-09-21 11:06 | 2026-09-21 11:06 | 2026-09-21 11:06 | RDW | RDW270115C00017000 | call | 17.0000 | 2027-01-15 | 0.9800 | 0.9500 | 1.1000 | 11.6400 | 97652.00 | 0.00 | 97652.00 | 1000 | 11 | 2555 | 1951 | 1.30958482829318 | 0.91640500485964 | 0.91640500485964 | false | false | false | true | ||||||||||||||||
| 8ff7afcf-4eaf-4936-92f7-66d2aba35626 | 2026-09-15 13:24 | 2026-09-15 13:24 | 2026-09-15 13:24 | RDW | RDW261030C00010000 | call | 10.0000 | 2026-10-30 | 1.8400 | 0.8000 | 1.9000 | 10.8350 | 77314.00 | 77314.00 | 0.00 | 420 | 25 | 420 | 5 | 84 | 0.981204130083171 | 0.904378431077492 | false | false | false | true | ||||||||||||||||
| b4a89a02-3239-422f-9398-5c255fa4db3b | 2026-09-15 11:16 | 2026-09-15 11:15 | 2026-09-15 11:15 | RDW | RDW280121C00010000 | call | 10.0000 | 2028-01-21 | 4.4000 | 4.4000 | 4.6000 | 10.3150 | 65608.00 | 0.00 | 65608.00 | 149 | 9 | 214 | 8670 | 0.0246828143021915 | 0.903071788374469 | 0.89802567622306 | false | false | false | true | ||||||||||||||||
| 73d9c279-87fa-4311-bf20-3e99960112db | 2026-09-11 15:14 | 2026-09-11 15:14 | 2026-09-11 15:14 | RDW | RDW261016C00011000 | call | 11.0000 | 2026-10-16 | 1.0100 | 1.0000 | 1.1000 | 10.8300 | 16209.00 | 0.00 | 16209.00 | 161 | 7 | 1924 | 802 | 2.39900249376559 | 0.79910102000874 | 0.79910102000874 | false | false | false | true | ||||||||||||||||
| 126983d8-64e2-40a7-965d-cac4cccb588b | 2026-09-11 15:14 | 2026-09-11 15:14 | 2026-09-11 15:14 | RDW | RDW261016C00011000 | call | 11.0000 | 2026-10-16 | 1.0000 | 1.0000 | 1.1000 | 10.8403 | 81163.00 | 0.00 | 81163.00 | 809 | 39 | 1763 | 802 | 2.19825436408978 | 0.809985976884998 | 0.787512230764698 | false | false | false | true | ||||||||||||||||
| f8626959-c2ed-40f4-922a-bb3f3662d9b9 | 2026-09-03 09:30 | 2026-09-03 09:30 | 2026-09-03 09:30 | RDW | RDW260918C00010500 | call | 10.5000 | 2026-09-18 | 0.6500 | 0.6500 | 1.3000 | 10.6300 | 36536.00 | 0.00 | 36536.00 | 562 | 11 | 1000 | 122 | 8.19672131147541 | 0.708103824389097 | 0.672705552974138 | false | false | false | true | ||||||||||||||||
| 51efb7ae-4563-4ea6-b82f-cd7c5f97e39c | 2026-09-02 10:36 | 2026-09-02 10:36 | 2026-09-02 10:36 | RDW | RDW270115C00012000 | call | 12.0000 | 2027-01-15 | 1.7300 | 1.6500 | 1.7500 | 10.3745 | 53254.00 | 53254.00 | 0.00 | 308 | 5 | 308 | 6562 | 0.0469369094788174 | 0.897916766972986 | 0.897916766972986 | false | false | false | true | ||||||||||||||||
| 9cf68308-b6b6-4f4e-b008-7df177be309f | 2026-08-28 11:30 | 2026-08-28 11:30 | 2026-08-28 11:30 | RDW | RDW260828C00010000 | call | 10.0000 | 2026-08-28 | 1.0000 | 1.0000 | 1.0500 | 11.0350 | 10015.00 | 0.00 | 10015.00 | 100 | 18 | 220 | 635 | 0.346456692913386 | 2.7109719083227 | 2.7109719083227 | false | false | false | true | ||||||||||||||||
| 30b65c18-e355-44ae-a080-bf5fc5836988 | 2026-08-21 09:55 | 2026-08-21 09:55 | 2026-08-21 09:55 | RDW | RDW261120C00027000 | call | 27.0000 | 2026-11-20 | 0.3000 | 0.2000 | 0.3000 | 12.1350 | 11983.00 | 11983.00 | 0.00 | 400 | 30 | 401 | 272 | 1.47426470588235 | 1.07984246196766 | 1.07984246196766 | false | false | false | true | ||||||||||||||||
| 309168eb-b86a-4842-a943-1504a4f89901 | 2026-08-17 14:23 | 2026-08-17 14:22 | 2026-08-17 14:22 | RDW | RDW280121C00025000 | call | 25.0000 | 2028-01-21 | 4.1000 | 4.1000 | 4.4000 | 13.4620 | 18867.00 | 0.00 | 18867.00 | 46 | 10 | 136 | 1513 | 0.0898876404494382 | 1.00886656587343 | 1.00729448936964 | false | false | false | true | ||||||||||||||||
| 5e3ed120-3f59-4253-89b7-4309007f67d2 | 2026-08-17 10:28 | 2026-08-17 10:28 | 2026-08-17 10:28 | RDW | RDW260828C00013500 | call | 13.5000 | 2026-08-28 | 1.1600 | 1.1500 | 1.2500 | 14.0110 | 11293.00 | 0.00 | 9733.00 | 97 | 13 | 245 | 522 | 0.469348659003831 | 0.938205888006195 | 0.916523244103462 | false | false | false | true | ||||||||||||||||
| ed27c4c9-b952-416e-81cb-3dc4d7255a08 | 2026-08-17 10:10 | 2026-08-17 10:10 | 2026-08-17 10:10 | RDW | RDW260821C00013000 | call | 13.0000 | 2026-08-21 | 1.2500 | 1.2000 | 1.2500 | 14.0550 | 10974.00 | 10730.00 | 244.00 | 88 | 5 | 560 | 9831 | 0.0569626691079239 | 1.00929615139594 | 0.961916378814876 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:30:31.713908Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:14:36.344002Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:41:33.894916Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:55:17.981841Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2939913082.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2899914264.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2899914264.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:56:02.019393Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2899914264.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:45:33.615815Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Other |
| Industrials |
| 2622422468.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |