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_alerts474,253 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 | price |
|---|
| 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 |
|---|
| 6629f5a7-f054-4d26-a42f-c3134b8e98ed | 2026-09-23 09:58 | 2026-09-23 09:58 | 2026-09-23 09:58 | RDW | RDW261002P00010500 | put | 10.5000 | 2026-10-02 | 0.2000 | 0.1500 | 0.2500 | 11.5050 | 103280.00 | 20.00 | 103260.00 | 5164 | 45 | 5168 | 326 | 15.8527607361963 | 0.827594720490997 | 0.827594720490997 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Other | Industrials | 2817416703.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T13:58:49.832976Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| d4799c2f-374a-4a32-8305-eba5db7f52df | 2026-09-23 10:46 | 2026-09-23 10:46 | 2026-09-23 10:46 | RDW | RDW270115C00020000 | call | 20.0000 | 2027-01-15 | 0.6000 | 0.5500 | 0.6500 | 11.4900 | 78300.00 | 78180.00 | 60.00 | 1305 | 13 | 1314 | 10609 | 0.123857102460175 | 0.93526335921418 | 0.93526335921418 | false | false | false | true | false | |||||||||||||||
| 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 | false | |||||||||||||||
| a36554c5-4c95-4d30-80a9-af0eaacffc07 | 2026-09-24 11:21 | 2026-09-24 11:20 | 2026-09-24 11:20 | RDW | RDW261016P00011000 | put | 11.0000 | 2026-10-16 | 0.8000 | 0.7500 | 0.8000 | 11.1950 | 15200.00 | 15200.00 | 0.00 | 190 | 14 | 450 | 5364 | 0.0838926174496644 | 0.836409479879991 | 0.836409479879991 | false | false | false | true | false | |||||||||||||||
| c8e8fb59-711a-4405-9d65-0c3935e42723 | 2026-09-24 11:35 | 2026-09-24 11:35 | 2026-09-24 11:35 | RDW | RDW261016P00011000 | put | 11.0000 | 2026-10-16 | 0.8000 | 0.7000 | 0.8000 | 11.0000 | 23920.00 | 23920.00 | 0.00 | 299 | 5 | 849 | 5364 | 0.1582774049217 | 0.85194309817501 | 0.85194309817501 | false | false | false | true | false | |||||||||||||||
| a96189e6-85e2-4469-9423-61c561e96c13 | 2026-09-24 11:57 | 2026-09-24 11:57 | 2026-09-24 11:57 | RDW | RDW261016P00011000 | put | 11.0000 | 2026-10-16 | 0.7500 | 0.7500 | 0.8000 | 11.3150 | 63300.00 | 0.00 | 63300.00 | 844 | 6 | 1694 | 5364 | 0.315809097688292 | 0.835734125416117 | 0.835734125416117 | false | false | false | true | false | |||||||||||||||
| f3d76f1d-828d-4fe0-ae72-13edc4233f4f | 2026-09-24 12:28 | 2026-09-24 12:28 | 2026-09-24 12:28 | RDW | RDW261016P00011000 | put | 11.0000 | 2026-10-16 | 0.6500 | 0.5500 | 0.6500 | 11.5950 | 13000.00 | 13000.00 | 0.00 | 200 | 8 | 2195 | 5364 | 0.409209545115585 | 0.841160904025524 | 0.841160904025524 | false | false | false | true | false | |||||||||||||||
| 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 | false | |||||||||||||||
| 88555b3b-2ee5-4cf3-b81c-56c635c603b5 | 2026-09-24 13:10 | 2026-09-24 13:10 | 2026-09-24 13:10 | RDW | RDW261016P00011000 | put | 11.0000 | 2026-10-16 | 0.6500 | 0.5500 | 0.6500 | 11.6450 | 13000.00 | 13000.00 | 0.00 | 200 | 6 | 2695 | 5364 | 0.502423564504101 | 0.857796691565175 | 0.857796691565175 | false | false | false | true | false | |||||||||||||||
| 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 | false | |||||||||||||||
| 473111df-96a4-4c78-811e-edbb97b1fda2 | 2026-09-24 13:13 | 2026-09-24 13:13 | 2026-09-24 13:13 | RDW | RDW261016C00012000 | call | 12.0000 | 2026-10-16 | 0.8500 | 0.7500 | 0.8500 | 11.6500 | 73440.00 | 73440.00 | 0.00 | 864 | 12 | 2198 | 3772 | 0.58271474019088 | 0.868254894310577 | 0.868254894310577 | false | false | false | true | false | |||||||||||||||
| a91bc977-92a4-4085-8bab-3f90682eb0be | 2026-09-24 13:26 | 2026-09-24 13:26 | 2026-09-24 13:26 | RDW | RDW261120C00015000 | call | 15.0000 | 2026-11-20 | 0.8500 | 0.7000 | 0.8500 | 11.8050 | 84584.00 | 84584.00 | 0.00 | 1000 | 19 | 1105 | 3524 | 0.313564131668558 | 0.959472702340333 | 0.977063688389834 | true | false | false | true | false | |||||||||||||||
| 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 | false | |||||||||||||||
| 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 | |||||||||||||||
| 1918ebf7-00d6-41cc-85ec-eb98c065d5b5 | 2026-09-24 13:45 | 2026-09-24 13:45 | 2026-09-24 13:45 | RDW | RDW270115P00011000 | put | 11.0000 | 2027-01-15 | 1.7500 | 1.7500 | 1.8500 | 11.0000 | 16975.00 | 0.00 | 16975.00 | 97 | 7 | 107 | 317 | 0.337539432176656 | 0.877531163270969 | 0.877531163270969 | false | false | false | true | false | |||||||||||||||
| 566efd85-7b0f-41ac-91fc-a8182a28da43 | 2026-09-24 14:49 | 2026-09-24 14:49 | 2026-09-24 14:49 | RDW | RDW261120C00016000 | call | 16.0000 | 2026-11-20 | 0.6000 | 0.5500 | 0.6500 | 11.0000 | 10920.00 | 2220.00 | 0.00 | 182 | 9 | 302 | 1246 | 0.242375601926164 | 0.972416580190236 | 0.972416580190236 | false | false | false | true | false | |||||||||||||||
| c2f4e235-c2b8-41ba-88d9-2bea406919b9 | 2026-09-24 14:59 | 2026-09-24 14:59 | 2026-09-24 14:59 | RDW | RDW270115C00010000 | call | 10.0000 | 2027-01-15 | 3.0000 | 3.0000 | 3.1000 | 11.5800 | 32400.00 | 0.00 | 32400.00 | 108 | 6 | 158 | 8826 | 0.0179016542034897 | 0.86283106292889 | 0.86283106292889 | false | false | false | true | false | |||||||||||||||
| 16e33cf7-30e7-448c-b6a6-a25cc59b4335 | 2026-09-25 10:46 | 2026-09-25 10:46 | 2026-09-25 10:46 | RDW | RDW261016P00011000 | put | 11.0000 | 2026-10-16 | 0.6500 | 0.5500 | 0.6500 | 11.6650 | 19499.00 | 19499.00 | 0.00 | 300 | 17 | 309 | 8594 | 0.0359553176634862 | 0.884274080868667 | 0.884274080868667 | false | false | false | true | false | |||||||||||||||
| a130e16b-aa64-4e3c-84fc-e9f9fd422805 | 2026-09-25 11:53 | 2026-09-25 11:53 | 2026-09-25 11:53 | RDW | RDW261016P00011000 | put | 11.0000 | 2026-10-16 | 0.6000 | 0.5500 | 0.6000 | 11.0000 | 24000.00 | 24000.00 | 0.00 | 400 | 10 | 725 | 8594 | 0.0843611822201536 | 0.852310053670328 | 0.849022635275731 | false | false | false | true | false | |||||||||||||||
| 32d86675-2ba5-455f-923d-f37e220ef324 | 2026-09-25 12:23 | 2026-09-25 12:23 | 2026-09-25 12:23 | RDW | RDW270219C00015000 | call | 15.0000 | 2027-02-19 | 1.8000 | 1.6500 | 1.8000 | 11.7850 | 24840.00 | 24840.00 | 0.00 | 138 | 12 | 161 | 1123 | 0.143365983971505 | 0.926088394501322 | 0.926088394501322 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:47:19.358930Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:21:44.336640Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:39:15.853086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:00:52.133329Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| 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 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:47:19.997705Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:51:39.883666Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2817416703.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:02:51.984196Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2904914117.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:47:41.799650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2904914117.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:56:11.622901Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Other |
| Industrials |
| 2904914117.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:27:03.681802Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |