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 | 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 |
|---|
| 14a1d60c-70e4-435a-a56f-8a95ca5e1db4 | 2026-09-28 12:06 | 2026-09-28 12:06 | 2026-09-28 12:06 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 1.9900 | 1.9900 | 2.0300 | 69.3750 | 12736.00 | 0.00 | 12736.00 | 64 | 7 | 1781 | 5278 | 0.33743842364532 | 0.340286227052641 | 0.340286227052641 | true | 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-28T16:11:09.473635Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 7404220d-a399-4d83-86a3-6a21fafb448a | 2026-09-28 09:42 | 2026-09-28 09:41 | 2026-09-28 09:41 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 1.5200 | 1.4700 | 1.5200 | 70.1300 | 10184.00 | 10184.00 | 0.00 | 67 | 17 | 523 | 5278 | 0.099090564607806 | 0.355634083140482 | 0.355634083140482 | true | false | false | true | ||||||||||||||||
| b4c8d243-4f57-42d0-af1d-e2ebeb5f7595 | 2026-09-25 14:24 | 2026-09-25 14:24 | 2026-09-25 14:24 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 1.0500 | 1.0300 | 1.0500 | 71.0350 | 29400.00 | 29400.00 | 0.00 | 280 | 24 | 3030 | 3785 | 0.800528401585205 | 0.279007201073814 | 0.279007201073814 | false | false | false | true | ||||||||||||||||
| 57a9bd4c-7a23-4d95-a948-a945393272f3 | 2026-09-25 14:00 | 2026-09-25 14:00 | 2026-09-25 14:00 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 1.0100 | 1.0100 | 1.0200 | 71.0000 | 26260.00 | 0.00 | 26260.00 | 260 | 18 | 2683 | 3785 | 0.70885072655218 | 0.279061948934011 | 0.279061948934011 | false | false | false | true | ||||||||||||||||
| e247cd08-7c05-4db7-a2fe-548d7e5b36c0 | 2026-09-24 15:28 | 2026-09-24 15:28 | 2026-09-24 15:28 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 0.8700 | 0.8600 | 0.8800 | 71.7950 | 33234.00 | 1305.00 | 31929.00 | 382 | 23 | 3150 | 1663 | 1.89416716776909 | 0.297090633979912 | 0.297090633979912 | true | false | false | true | ||||||||||||||||
| 034a11fc-6474-42c0-bcf1-da51799d908f | 2026-09-24 13:35 | 2026-09-24 13:35 | 2026-09-24 13:35 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 0.9000 | 0.9000 | 0.9200 | 71.7600 | 41220.00 | 0.00 | 41220.00 | 458 | 29 | 2624 | 1663 | 1.57787131689717 | 0.301138677835012 | 0.301138677835012 | false | false | false | true | ||||||||||||||||
| a51b800d-4f65-473a-b469-39a511777a64 | 2026-09-24 13:06 | 2026-09-24 13:06 | 2026-09-24 13:06 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 0.8500 | 0.8400 | 0.8600 | 71.9050 | 16915.00 | 0.00 | 16830.00 | 199 | 15 | 2144 | 1663 | 1.28923631990379 | 0.30243406893512 | 0.30243406893512 | false | false | false | true | ||||||||||||||||
| 937802f8-1760-4fce-97cc-a83bc76e49c2 | 2026-09-24 09:48 | 2026-09-24 09:48 | 2026-09-24 09:48 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 1.0300 | 1.0300 | 1.0800 | 71.5900 | 70452.00 | 0.00 | 70452.00 | 684 | 52 | 1148 | 1663 | 0.690318701142513 | 0.316183720497127 | 0.316183720497127 | false | false | false | true | ||||||||||||||||
| 21235b03-3e94-4871-bc61-64d66dd9b63f | 2026-09-24 09:45 | 2026-09-24 09:45 | 2026-09-24 09:45 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 1.1800 | 1.1800 | 1.2200 | 71.3001 | 11800.00 | 0.00 | 11800.00 | 100 | 12 | 225 | 1663 | 0.135297654840649 | 0.322230407824138 | 0.322230407824138 | true | false | false | true | ||||||||||||||||
| bc615b9f-b474-444c-820a-2799b4ede880 | 2026-09-23 13:12 | 2026-09-23 13:12 | 2026-09-23 13:12 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 1.0600 | 1.0500 | 1.0700 | 71.0000 | 14416.00 | 11872.00 | 0.00 | 136 | 19 | 660 | 1355 | 0.487084870848708 | 0.312724289836427 | 0.310387457253555 | true | false | false | true | ||||||||||||||||
| 70b2b73c-9e10-46e7-93b3-ede22720da93 | 2026-09-22 14:50 | 2026-09-22 14:50 | 2026-09-22 14:50 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 1.0500 | 1.0500 | 1.0700 | 71.8750 | 42945.00 | 0.00 | 42840.00 | 409 | 35 | 1524 | 786 | 1.93893129770992 | 0.31340895707717 | 0.31340895707717 | false | false | false | true | ||||||||||||||||
| fac794ea-e2fd-4587-9ee7-d854af242e71 | 2026-09-21 13:36 | 2026-09-21 13:36 | 2026-09-21 13:36 | NFLX | NFLX261002P00071000 | put | 71.0000 | 2026-10-02 | 0.6600 | 0.6300 | 0.6600 | 73.0000 | 13184.00 | 13184.00 | 0.00 | 200 | 8 | 799 | 480 | 1.66458333333333 | 0.319523914594597 | 0.317103200152802 | false | false | false | true |
| 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:43:35.547112Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 296243488249.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:27:02.000981Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 296243488249.00 |
| 2026-10-20 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-24T19:29:28.297700Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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 |
| 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:08:54.073871Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T13:48:47.718536Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T13:47:07.799094Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 297138735279.00 |
| 2026-10-20 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:17:19.986908Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 300469887020.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 305466614631.00 |
| 2026-10-20 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |