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_alerts609,118 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 |
|---|
| 83b25efe-fa0d-4481-8d43-910a1841142d | 2026-09-30 09:40 | 2026-09-30 09:40 | 2026-09-30 09:40 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.8600 | 0.8500 | 0.8900 | 69.8100 | 10750.00 | 0.00 | 10750.00 | 125 | 5 | 984 | 7639 | 0.128812671815683 | 0.368969083603634 | 0.372855519106696 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 292724959223.00 | 2026-10-20 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T13:41:13.731534Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| d97fb935-1b8f-4f57-bb60-e049a4324f64 | 2026-09-30 09:36 | 2026-09-30 09:36 | 2026-09-30 09:36 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.7400 | 0.7000 | 0.7400 | 70.1350 | 20498.00 | 20498.00 | 0.00 | 277 | 17 | 716 | 7639 | 0.0937295457520618 | 0.392984590258643 | 0.392984590258643 | true | false | false | true | ||||||||||||||||
| 7a1e3632-2b03-4853-9c87-aa0c60bebb5e | 2026-09-29 09:47 | 2026-09-29 09:47 | 2026-09-29 09:47 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.7400 | 0.7000 | 0.7500 | 70.4650 | 278758.00 | 278684.00 | 74.00 | 3767 | 75 | 5303 | 7118 | 0.745012644001124 | 0.379790022933089 | 0.379790022933089 | false | false | false | true | ||||||||||||||||
| 2d146e01-6ded-484b-b28b-d41aa410d25b | 2026-09-29 09:34 | 2026-09-29 09:34 | 2026-09-29 09:34 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.7000 | 0.7000 | 0.7300 | 70.5800 | 22330.00 | 0.00 | 22330.00 | 319 | 9 | 960 | 7118 | 0.13486934532172 | 0.382415053295468 | 0.382415053295468 | true | false | false | true | ||||||||||||||||
| 8b5b6f81-cf73-4c93-9eeb-cf372ba20287 | 2026-09-29 09:34 | 2026-09-29 09:34 | 2026-09-29 09:34 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.7100 | 0.7100 | 0.7600 | 70.5250 | 11360.00 | 0.00 | 11360.00 | 160 | 7 | 628 | 7118 | 0.0882270300646249 | 0.377571467543276 | 0.377571467543276 | false | false | false | true | ||||||||||||||||
| 1470d0e9-61ec-4ec8-841f-f40287cd13eb | 2026-09-29 09:31 | 2026-09-29 09:31 | 2026-09-29 09:31 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.6200 | 0.6200 | 0.6900 | 70.8750 | 10292.00 | 0.00 | 10292.00 | 166 | 29 | 331 | 7118 | 0.0465018263557179 | 0.394960528305738 | 0.394960528305738 | false | false | false | true | ||||||||||||||||
| ec033dea-0587-4c8a-9cde-b30bad61945e | 2026-09-28 13:22 | 2026-09-28 13:22 | 2026-09-28 13:22 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 1.1900 | 1.1900 | 1.2100 | 69.5450 | 12733.00 | 0.00 | 12733.00 | 107 | 17 | 7488 | 5838 | 1.28263103802672 | 0.330633899446728 | 0.330633899446728 | true | false | false | true | ||||||||||||||||
| 4ce9b41d-7128-4f95-8312-47f87943f635 | 2026-09-28 12:55 | 2026-09-28 12:54 | 2026-09-28 12:54 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 1.1800 | 1.1800 | 1.2000 | 69.5700 | 19234.00 | 0.00 | 19234.00 | 163 | 15 | 7194 | 5838 | 1.23227132579651 | 0.332033048425109 | 0.332033048425109 | false | false | false | true | ||||||||||||||||
| cb1c7f92-8737-4992-911e-e5e050edaf2c | 2026-09-28 12:38 | 2026-09-28 12:38 | 2026-09-28 12:38 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 1.2500 | 1.2500 | 1.2800 | 69.4250 | 12500.00 | 0.00 | 12500.00 | 100 | 6 | 6834 | 5838 | 1.17060637204522 | 0.327558703966428 | 0.327558703966428 | false | false | false | true | ||||||||||||||||
| e5950abc-383b-4861-a041-0d3c86cbc38e | 2026-09-28 11:53 | 2026-09-28 11:53 | 2026-09-28 11:53 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 1.4000 | 1.3900 | 1.4100 | 69.2300 | 19321.00 | 19321.00 | 0.00 | 138 | 5 | 6147 | 5838 | 1.05292908530319 | 0.341716642946174 | 0.343100235899224 | false | false | false | true | ||||||||||||||||
| 4cbb1735-c279-4fda-8e62-83bb6097228b | 2026-09-28 11:21 | 2026-09-28 11:21 | 2026-09-28 11:21 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 1.2000 | 1.1800 | 1.2000 | 69.0000 | 11760.00 | 11760.00 | 0.00 | 98 | 7 | 5540 | 5838 | 0.948955121616992 | 0.336717445564466 | 0.336717445564466 | true | false | false | true | ||||||||||||||||
| d39edaa0-8303-4dcf-a46a-586c841fdedb | 2026-09-28 11:02 | 2026-09-28 11:02 | 2026-09-28 11:02 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 1.1300 | 1.1300 | 1.1500 | 69.7082 | 15142.00 | 0.00 | 15142.00 | 134 | 19 | 5015 | 5838 | 0.859027064063035 | 0.34086883460287 | 0.34086883460287 | true | false | false | true | ||||||||||||||||
| c9a97e4c-c867-4731-bed1-dbb206a1b2d6 | 2026-09-28 10:55 | 2026-09-28 10:55 | 2026-09-28 10:55 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 1.1300 | 1.1100 | 1.1300 | 69.7001 | 11300.00 | 11300.00 | 0.00 | 100 | 5 | 4616 | 5838 | 0.790681740322028 | 0.339373366373837 | 0.339373366373837 | false | false | false | true | ||||||||||||||||
| 2f187a63-f11e-4222-ac90-a0870e8207a5 | 2026-09-28 10:26 | 2026-09-28 10:25 | 2026-09-28 10:25 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.9300 | 0.9300 | 0.9500 | 70.0000 | 12369.00 | 0.00 | 12369.00 | 133 | 17 | 3814 | 5838 | 0.653305926687222 | 0.337473853366865 | 0.337473853366865 | false | false | false | true | ||||||||||||||||
| a3fda7b2-d721-452e-9f43-f7525ec63cf2 | 2026-09-28 09:45 | 2026-09-28 09:45 | 2026-09-28 09:45 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.9100 | 0.8700 | 0.9100 | 70.2000 | 12649.00 | 12649.00 | 0.00 | 139 | 29 | 1875 | 5838 | 0.321171634121274 | 0.348962262029923 | 0.348962262029923 | false | false | false | true | ||||||||||||||||
| c2bef851-0c6e-42b7-a8db-90b387479f41 | 2026-09-24 15:39 | 2026-09-24 15:39 | 2026-09-24 15:39 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.5600 | 0.5500 | 0.5600 | 71.0000 | 11200.00 | 11200.00 | 0.00 | 200 | 18 | 1643 | 4141 | 0.396764066650568 | 0.297198890253274 | 0.297198890253274 | true | false | false | true | ||||||||||||||||
| e50a952b-2ea4-4720-ac0b-e1aeab3534b5 | 2026-09-23 15:26 | 2026-09-23 15:26 | 2026-09-23 15:26 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.7300 | 0.7200 | 0.7300 | 71.0000 | 20075.00 | 20075.00 | 0.00 | 275 | 34 | 2788 | 3361 | 0.829515025290092 | 0.314188281882601 | 0.314188281882601 | false | false | false | true | ||||||||||||||||
| 01625a05-97cc-4947-80a4-dec975fce26f | 2026-09-22 14:35 | 2026-09-22 14:35 | 2026-09-22 14:35 | NFLX | NFLX261002P00070000 | put | 70.0000 | 2026-10-02 | 0.7500 | 0.7500 | 0.7700 | 71.7100 | 64200.00 | 0.00 | 64200.00 | 856 | 53 | 1772 | 2044 | 0.86692759295499 | 0.314901532067915 | 0.315268595294224 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 292724959223.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:36:52.270461Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 292724959223.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:48:49.550855Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 292724959223.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:35:17.817749Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 292724959223.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:35:17.817749Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 292724959223.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:31:56.202644Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-28T17:25:25.188359Z"} |
| 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-28T16:56:37.183860Z"} |
| 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-28T16:39:53.834597Z"} |
| 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:58:21.684493Z"} |
| 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-28T15:26:10.967927Z"} |
| 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:04:58.148934Z"} |
| 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:55:24.203019Z"} |
| 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-28T14:26:39.560401Z"} |
| 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:45:28.249714Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 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-23T19:31:17.816750Z"} |
| 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:36:42.386317Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |