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 | strike |
|---|
| 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 |
|---|
| 8ecd2da6-9cfa-43ae-b897-6f2a4f57196c | 2026-09-29 10:31 | 2026-09-29 10:31 | 2026-09-29 10:31 | OWL | OWL261120P00007000 | put | 7.0000 | 2026-11-20 | 0.0700 | 0.0500 | 0.1500 | 9.2164 | 14136.00 | 0.00 | 14136.00 | 2000 | 6 | 2000 | 4925 | 0.406091370558376 | 0.57567986127407 | 0.57567986127407 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 6346671771.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T14:32:52.206353Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 2668d7bb-22ec-4f3c-9b21-9e44c1b6c867 | 2026-09-29 09:54 | 2026-09-29 09:54 | 2026-09-29 09:54 | OWL | OWL270115P00008000 | put | 8.0000 | 2027-01-15 | 0.5500 | 0.4000 | 0.5500 | 9.1500 | 109700.00 | 109700.00 | 0.00 | 2000 | 18 | 2000 | 27266 | 0.073351426685249 | 0.576669268329559 | 0.539665274373871 | false | false | ||||||||||||||||||
| e1df48a9-f226-4c71-8916-20619ffe2e29 | 2026-09-24 14:14 | 2026-09-24 14:14 | 2026-09-24 14:14 | OWL | OWL270115P00008000 | put | 8.0000 | 2027-01-15 | 0.5000 | 0.4000 | 0.5000 | 9.1750 | 124972.00 | 124972.00 | 0.00 | 2500 | 57 | 5138 | 26068 | 0.197099892588614 | 0.538446992028173 | 0.538446992028173 | false | false | ||||||||||||||||||
| 2d14ab25-1f6b-47f5-871a-ce82289be3dc | 2026-09-22 12:32 | 2026-09-22 12:32 | 2026-09-22 12:32 | OWL | OWL270115C00009000 | call | 9.0000 | 2027-01-15 | 1.4500 | 1.3500 | 1.5500 | 9.9350 | 14452.00 | 0.00 | 6912.00 | 100 | 7 | 100 | 1149 | 0.0870322019147084 | 0.388692410899579 | 0.388692410899579 | false | false | ||||||||||||||||||
| ba55bc3f-ab4b-4aeb-bdf9-e2ca2093b448 | 2026-09-10 15:20 | 2026-09-10 15:20 | 2026-09-10 15:20 | OWL | OWL280121C00013000 | call | 13.0000 | 2028-01-21 | 1.3500 | 1.2500 | 1.3500 | 10.4900 | 13480.00 | 13480.00 | 0.00 | 100 | 7 | 118 | 26732 | 0.00441418524614694 | 0.403332078413538 | 0.398746168739347 | false | false | ||||||||||||||||||
| 5806587c-c955-4340-92ec-8fa6802fc9c9 | 2026-09-09 13:02 | 2026-09-09 13:02 | 2026-09-09 13:02 | OWL | OWL270219C00013000 | call | 13.0000 | 2027-02-19 | 0.5500 | 0.5500 | 0.6000 | 10.0000 | 20426.00 | 0.00 | 20426.00 | 371 | 10 | 1120 | 2388 | 0.469011725293132 | 0.415482154832792 | 0.411657441986159 | false | false | ||||||||||||||||||
| 3f317612-24c1-427c-969f-b645839dbfd5 | 2026-09-09 13:02 | 2026-09-09 13:02 | 2026-09-09 13:02 | OWL | OWL270219C00013000 | call | 13.0000 | 2027-02-19 | 0.5600 | 0.5500 | 0.6000 | 10.0000 | 17776.00 | 0.00 | 17776.00 | 316 | 6 | 652 | 2388 | 0.273031825795645 | 0.419295403003525 | 0.419295403003525 | false | false | ||||||||||||||||||
| cdb86a9f-ce58-4ca8-8351-3a852b608695 | 2026-09-04 10:40 | 2026-09-04 10:40 | 2026-09-04 10:40 | OWL | OWL260904C00012000 | call | 12.0000 | 2026-09-04 | 0.1000 | 0.1000 | 0.1500 | 11.8550 | 49965.00 | 18905.00 | 31060.00 | 5001 | 63 | 5011 | 901 | 5.56159822419534 | 1.47123082104601 | 1.38292315737521 | true | false | ||||||||||||||||||
| f2cc7889-c35a-46cd-bfcf-347fd01d4897 | 2026-08-27 09:45 | 2026-08-27 09:45 | 2026-08-27 09:45 | OWL | OWL261120P00011000 | put | 11.0000 | 2026-11-20 | 0.6100 | 0.6000 | 0.7000 | 12.0902 | 24299.00 | 0.00 | 24299.00 | 400 | 15 | 500 | 51339 | 0.00973918463546232 | 0.505441084408294 | 0.505441084408294 | false | false | ||||||||||||||||||
| 85d6eaec-faa6-4ead-9540-d0df419e687f | 2026-08-25 11:42 | 2026-08-25 11:42 | 2026-08-25 11:42 | OWL | OWL270115C00017000 | call | 17.0000 | 2027-01-15 | 0.1600 | 0.1500 | 0.2000 | 11.6653 | 15705.00 | 0.00 | 15705.00 | 1000 | 9 | 1001 | 3886 | 0.257591353576943 | 0.433072727779844 | 0.425945547542308 | false | false | ||||||||||||||||||
| 125d665e-e067-46f0-b6a7-ef4c71b8058b | 2026-08-24 09:39 | 2026-08-24 09:39 | 2026-08-24 09:39 | OWL | OWL270115P00009000 | put | 9.0000 | 2027-01-15 | 0.3500 | 0.3000 | 0.4500 | 11.6200 | 21522.00 | 0.00 | 21522.00 | 610 | 6 | 610 | 6229 | 0.0979290415797078 | 0.511646490068468 | 0.511646490068468 | false | false | ||||||||||||||||||
| 84263d86-df17-4510-9f43-4707852031df | 2026-08-19 11:09 | 2026-08-19 11:09 | 2026-08-19 11:09 | OWL | OWL260918C00013000 | call | 13.0000 | 2026-09-18 | 0.2500 | 0.2000 | 0.3000 | 11.8700 | 26038.00 | 25988.00 | 50.00 | 1042 | 62 | 1062 | 3425 | 0.31007299270073 | 0.462521404171984 | 0.462497160775363 | true | false | ||||||||||||||||||
| aa8c5b01-9377-447b-8960-85b1544f2770 | 2026-08-18 13:12 | 2026-08-18 13:11 | 2026-08-18 13:11 | OWL | OWL280121C00013000 | call | 13.0000 | 2028-01-21 | 2.0300 | 1.9500 | 2.0500 | 11.6150 | 20330.00 | 20330.00 | 0.00 | 100 | 5 | 146 | 26965 | 0.00541442610791767 | 0.417975938499867 | 0.414326499179054 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 6346671771.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:56:35.860979Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 6565522522.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:15:40.223371Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 6757016928.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:35:05.886735Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7133166656.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:25:57.950009Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7133166656.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7133166656.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7133166656.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7133166656.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T13:49:05.616113Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7133166656.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7133166656.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7133166656.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7133166656.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |