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 | 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 |
|---|
| 5d2ea8d8-016a-4dd9-b223-417b1dc155c1 | 2026-09-28 11:55 | 2026-09-28 11:55 | 2026-09-28 11:55 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.8800 | 0.8800 | 0.8900 | 69.1500 | 29480.00 | 0.00 | 29480.00 | 335 | 11 | 10163 | 3099 | 3.27944498225234 | 0.335502818868583 | 0.335502818868583 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 288269543769.00 | 2026-10-20 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T15:58:21.684493Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 3033f2b6-843c-47d3-befa-97c7bd7f9df4 | 2026-09-28 11:20 | 2026-09-28 11:19 | 2026-09-28 11:19 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.6800 | 0.6800 | 0.6900 | 69.0000 | 11832.00 | 0.00 | 11832.00 | 174 | 9 | 8863 | 3099 | 2.85995482413682 | 0.33128867159949 | 0.33128867159949 | false | false | false | true | false | |||||||||||||||
| c1c44411-4aa5-4b37-b79b-d273c0580c37 | 2026-09-28 11:01 | 2026-09-28 11:01 | 2026-09-28 11:01 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.6700 | 0.6700 | 0.6900 | 69.6380 | 14673.00 | 0.00 | 14673.00 | 219 | 7 | 8417 | 3099 | 2.71603743142949 | 0.334378500097219 | 0.334378500097219 | false | false | false | true | false | |||||||||||||||
| e65336a2-bb33-44c9-84d4-b5e6b36f2ee9 | 2026-09-28 10:58 | 2026-09-28 10:58 | 2026-09-28 10:58 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.7100 | 0.7000 | 0.7100 | 69.5650 | 14200.00 | 14200.00 | 0.00 | 200 | 12 | 7956 | 3099 | 2.56727976766699 | 0.338473270790979 | 0.338473270790979 | false | false | false | true | false | |||||||||||||||
| cbc676f5-b310-42d7-8920-b641f7f76d70 | 2026-09-28 10:03 | 2026-09-28 10:03 | 2026-09-28 10:03 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.6000 | 0.5900 | 0.6100 | 69.9050 | 21960.00 | 60.00 | 21900.00 | 366 | 11 | 5215 | 3099 | 1.68280090351726 | 0.343818178018385 | 0.344461356241695 | false | false | false | true | false | |||||||||||||||
| addfa373-2cc4-4653-93b6-5448958d7636 | 2026-09-28 09:59 | 2026-09-28 09:59 | 2026-09-28 09:59 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.6000 | 0.5800 | 0.6000 | 69.0000 | 12000.00 | 12000.00 | 0.00 | 200 | 10 | 4489 | 3099 | 1.4485317844466 | 0.350095092291094 | 0.350095092291094 | false | false | false | true | false | |||||||||||||||
| c445e161-4a86-43e9-879f-b750462a19f5 | 2026-09-28 09:58 | 2026-09-28 09:58 | 2026-09-28 09:58 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.5900 | 0.5800 | 0.6000 | 69.0000 | 22774.00 | 22243.00 | 0.00 | 386 | 10 | 4205 | 3099 | 1.3568893191352 | 0.343958577477397 | 0.343958577477397 | true | false | false | true | false | |||||||||||||||
| dc81e1be-ee65-416f-8467-3620e6442ba6 | 2026-09-28 09:57 | 2026-09-28 09:56 | 2026-09-28 09:56 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.6100 | 0.5900 | 0.6200 | 69.0000 | 16410.00 | 62.00 | 16348.00 | 269 | 18 | 3544 | 3099 | 1.14359470797031 | 0.344706519811605 | 0.354851491186979 | true | false | false | true | false | |||||||||||||||
| c4e76e25-b2de-4525-9716-6b4f790504f3 | 2026-09-28 09:37 | 2026-09-28 09:37 | 2026-09-28 09:37 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.5100 | 0.4900 | 0.5100 | 70.1900 | 17697.00 | 17697.00 | 0.00 | 347 | 16 | 1232 | 3099 | 0.397547595998709 | 0.345711667761623 | 0.345711667761623 | false | false | false | true | false | |||||||||||||||
| 5a5a5a85-e9be-4093-b8df-f8368dfe3e6d | 2026-09-24 13:35 | 2026-09-24 13:35 | 2026-09-24 13:35 | NFLX | NFLX261002P00069000 | put | 69.0000 | 2026-10-02 | 0.3300 | 0.3300 | 0.3500 | 71.7600 | 15180.00 | 0.00 | 15180.00 | 460 | 26 | 1108 | 1509 | 0.734261100066269 | 0.306421507091759 | 0.306421507091759 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 288269543769.00 |
| 2026-10-20 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:21:41.621308Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 288269543769.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:01:52.060675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 288269543769.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:01:52.060675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 288269543769.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:05:57.750889Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 288269543769.00 |
| 2026-10-20 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:59:44.308303Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 288269543769.00 |
| 2026-10-20 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:59:44.308303Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 288269543769.00 |
| 2026-10-20 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:59:44.308303Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 288269543769.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:37:13.633320Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 297138735279.00 |
| 2026-10-20 |
| postmarket |
| — |
| 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 |