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 |
|---|
| 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 |
|---|
| 1236e5fc-0b8d-4c89-8495-940ef8d5bae6 | 2026-09-25 13:35 | 2026-09-25 13:35 | 2026-09-25 13:35 | SCHW | SCHW261016P00100000 | put | 100.0000 | 2026-10-16 | 3.1000 | 3.0000 | 3.1500 | 99.0000 | 62292.00 | 61982.00 | 310.00 | 201 | 49 | 392 | 5527 | 0.0709245521982993 | 0.317126130503963 | 0.317126130503963 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 171256115757.00 | 2026-10-15 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 69669a3f-d017-4e39-9d55-b73936497021 | 2026-09-24 11:12 | 2026-09-24 11:12 | 2026-09-24 11:12 | SCHW | SCHW261016P00095000 | put | 95.0000 | 2026-10-16 | 1.5900 | 1.4600 | 1.6800 | 98.0000 | 131011.00 | 130698.00 | 155.00 | 824 | 52 | 850 | 3270 | 0.259938837920489 | 0.327950713889874 | 0.323020619144951 | false | false | false | |||||||||||||||||
| ac6b3cb4-59f9-4100-b64b-516f32d28ea8 | 2026-09-23 11:00 | 2026-09-23 11:00 | 2026-09-23 11:00 | SCHW | SCHW261016P00099000 | put | 99.0000 | 2026-10-16 | 2.1900 | 2.0700 | 2.2200 | 100.0000 | 57809.00 | 57593.00 | 216.00 | 264 | 30 | 267 | 70 | 3.81428571428571 | 0.311425055517225 | 0.308312945744596 | false | false | false | |||||||||||||||||
| a3a111c5-eb7b-484f-a815-73d793303761 | 2026-09-22 15:52 | 2026-09-22 15:52 | 2026-09-22 15:52 | SCHW | SCHW261016C00102000 | call | 102.0000 | 2026-10-16 | 2.8000 | 2.7900 | 3.2500 | 100.8700 | 12869.00 | 0.00 | 12869.00 | 46 | 7 | 105 | 1 | 105 | 0.309521777880773 | 0.309240066772591 | true | false | false | |||||||||||||||||
| 66fad4dd-f9ac-4b1f-b63e-3243233143d5 | 2026-09-22 15:21 | 2026-09-22 15:20 | 2026-09-22 15:20 | SCHW | SCHW261016P00100000 | put | 100.0000 | 2026-10-16 | 2.4400 | 2.3900 | 2.5600 | 101.3650 | 13426.00 | 2904.00 | 10522.00 | 55 | 7 | 2255 | 7088 | 0.318143340857788 | 0.310890223991749 | 0.307910157006765 | false | false | false | |||||||||||||||||
| 308f220a-b29d-46c0-99c3-4f3b3d0e3a5c | 2026-09-22 13:41 | 2026-09-22 13:41 | 2026-09-22 13:41 | SCHW | SCHW261218C00095000 | call | 95.0000 | 2026-12-18 | 9.2000 | 9.2000 | 9.4500 | 100.9995 | 34050.00 | 1850.00 | 32200.00 | 37 | 13 | 1373 | 1700 | 0.807647058823529 | 0.265541212260481 | 0.265541212260481 | false | false | false | |||||||||||||||||
| 265f69fc-496a-4da1-960c-743f03a810cb | 2026-09-22 13:39 | 2026-09-22 13:39 | 2026-09-22 13:39 | SCHW | SCHW261218C00095000 | call | 95.0000 | 2026-12-18 | 8.7100 | 8.7000 | 9.7500 | 101.0000 | 43540.00 | 1750.00 | 41790.00 | 50 | 19 | 1072 | 1700 | 0.630588235294118 | 0.232766903167067 | 0.232766903167067 | false | false | false | |||||||||||||||||
| c2e2c90a-6e22-4a5a-9f32-f230dffb4455 | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | SCHW | SCHW270319P00092500 | put | 92.5000 | 2027-03-19 | 4.2500 | 3.7000 | 4.2500 | 100.2000 | 266792.00 | 266377.00 | 415.00 | 628 | 51 | 630 | 744 | 0.846774193548387 | 0.30857814324984 | 0.304045512164274 | true | false | false | |||||||||||||||||
| 8cccabca-d781-4c62-8568-ec535b687c7e | 2026-09-22 10:23 | 2026-09-22 10:23 | 2026-09-22 10:23 | SCHW | SCHW261120C00110000 | call | 110.0000 | 2026-11-20 | 1.5800 | 1.4500 | 1.5800 | 100.5900 | 213694.00 | 202522.00 | 10540.00 | 1355 | 44 | 1369 | 1334 | 1.02623688155922 | 0.279550324982035 | 0.277201084698515 | false | false | false | |||||||||||||||||
| 016cae68-f1be-4634-a761-450fef6977e1 | 2026-09-22 09:50 | 2026-09-22 09:50 | 2026-09-22 09:50 | SCHW | SCHW261016P00100000 | put | 100.0000 | 2026-10-16 | 1.8000 | 1.5700 | 1.8600 | 103.2100 | 23191.00 | 16740.00 | 6451.00 | 129 | 26 | 155 | 7088 | 0.0218679458239278 | 0.313466027763203 | 0.312620848856472 | false | false | false | |||||||||||||||||
| 7bab1f53-86a6-4cac-b5db-28a03a93cde1 | 2026-09-21 13:27 | 2026-09-21 13:27 | 2026-09-21 13:27 | SCHW | SCHW261218P00115000 | put | 115.0000 | 2026-12-18 | 9.9300 | 9.7500 | 10.0000 | 107.0800 | 30796.00 | 30796.00 | 0.00 | 31 | 6 | 468 | 297 | 1.57575757575758 | 0.278183548182751 | 0.273562088414893 | false | false | false | |||||||||||||||||
| baed197d-77c5-4674-8117-b6f64c6f147d | 2026-09-21 13:25 | 2026-09-21 13:25 | 2026-09-21 13:25 | SCHW | SCHW261218P00115000 | put | 115.0000 | 2026-12-18 | 9.9900 | 9.7000 | 10.0000 | 107.2800 | 50959.00 | 50959.00 | 0.00 | 51 | 7 | 211 | 297 | 0.71043771043771 | 0.284745479006392 | 0.28423846337402 | false | false | false | |||||||||||||||||
| 61a9cc3a-7e13-477d-b69f-98c66b4bdf2e | 2026-09-21 13:25 | 2026-09-21 13:25 | 2026-09-21 13:25 | SCHW | SCHW261218P00115000 | put | 115.0000 | 2026-12-18 | 9.7300 | 9.7000 | 9.8000 | 107.3250 | 39912.00 | 1960.00 | 37952.00 | 41 | 7 | 160 | 297 | 0.538720538720539 | 0.276052207424977 | 0.271974454910783 | false | false | false | |||||||||||||||||
| 28ea4e71-ed2a-4458-8e71-d36bfdf61fe3 | 2026-08-28 11:28 | 2026-08-28 11:28 | 2026-08-28 11:28 | SCHW | SCHW260828C00110000 | call | 110.0000 | 2026-08-28 | 0.6200 | 0.5600 | 0.7600 | 110.5750 | 59999.00 | 9407.00 | 50592.00 | 965 | 67 | 1057 | 3075 | 0.343739837398374 | 0.335371457957637 | 0.158167550600798 | true | false | false | |||||||||||||||||
| 44d9dcf9-692b-4616-9028-23a09ce78262 | 2026-08-21 11:54 | 2026-08-21 11:54 | 2026-08-21 11:54 | SCHW | SCHW281215C00110000 | call | 110.0000 | 2028-12-15 | 24.5800 | 22.8000 | 25.1500 | 111.6800 | 76210.00 | 66370.00 | 0.00 | 31 | 7 | 31 | 149 | 0.208053691275168 | 0.292368222199713 | 0.281643907324453 | true | false | false | |||||||||||||||||
| 8f5c3ad0-d69b-4feb-988c-3a3ab3a4cba8 | 2026-08-19 11:49 | 2026-08-19 11:49 | 2026-08-19 11:49 | SCHW | SCHW261120P00115000 | put | 115.0000 | 2026-11-20 | 7.2100 | 7.0500 | 7.2500 | 111.3297 | 55514.00 | 55514.00 | 0.00 | 77 | 11 | 852 | 765 | 1.11372549019608 | 0.260121012255738 | 0.257877928002111 | false | false | false | |||||||||||||||||
| 9f51a5bc-3d9d-4a89-91b8-1f9d4f4e1107 | 2026-08-19 11:49 | 2026-08-19 11:48 | 2026-08-19 11:48 | SCHW | SCHW261120P00115000 | put | 115.0000 | 2026-11-20 | 7.1400 | 7.0500 | 7.1500 | 111.3800 | 54965.00 | 54965.00 | 0.00 | 77 | 10 | 753 | 765 | 0.984313725490196 | 0.256859407206269 | 0.256411055198243 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 172068903543.00 |
| 2026-10-15 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:14:35.650072Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 172068903543.00 |
| 2026-10-15 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:00:57.901243Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 173538838900.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 173538838900.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 173538838900.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:49:14.593703Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 173538838900.00 |
| 2026-10-15 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 173538838900.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:34:01.762519Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 173538838900.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:23:46.275389Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 173538838900.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:52:22.219586Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 184831401112.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:29:25.525905Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 184831401112.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:29:25.525905Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 184831401112.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:29:25.525905Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 185575015469.00 |
| 2026-10-15 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 185575015469.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 185575015469.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 185575015469.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |