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 |
|---|
| 2cc933e1-45c4-4c68-8cf6-f27b91213429 | 2026-09-29 13:28 | 2026-09-29 13:28 | 2026-09-29 13:28 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.8100 | 1.7900 | 1.8100 | 70.5600 | 26054.00 | 26054.00 | 0.00 | 144 | 5 | 1550 | 2904 | 0.533746556473829 | 0.36038842372681 | 0.363365550593776 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-29T17:35:56.522795Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| c6d07248-338d-4508-9203-1fb51dc15238 | 2026-09-29 10:20 | 2026-09-29 10:20 | 2026-09-29 10:20 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.5300 | 1.5300 | 1.5600 | 71.0050 | 18972.00 | 0.00 | 18972.00 | 124 | 10 | 684 | 2904 | 0.235537190082645 | 0.374372293628519 | 0.374372293628519 | false | false | false | true | ||||||||||||||||
| 0fc2f8d5-c75d-4217-aeb0-6d7cdcc11ad0 | 2026-09-29 10:11 | 2026-09-29 10:11 | 2026-09-29 10:11 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.6300 | 1.6300 | 1.6700 | 70.0000 | 11573.00 | 0.00 | 11573.00 | 71 | 12 | 516 | 2904 | 0.177685950413223 | 0.380503750097343 | 0.380503750097343 | false | false | false | true | ||||||||||||||||
| 53738ccc-1132-4adb-9d21-4494795f5ea5 | 2026-09-29 10:00 | 2026-09-29 10:00 | 2026-09-29 10:00 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 2.0200 | 2.0100 | 2.0500 | 70.3400 | 22422.00 | 0.00 | 22422.00 | 111 | 10 | 343 | 2904 | 0.118112947658402 | 0.38675762554191 | 0.38675762554191 | false | false | false | true | ||||||||||||||||
| 5c226ae5-56d0-4e56-8dfe-d62ef19c0548 | 2026-09-29 09:31 | 2026-09-29 09:31 | 2026-09-29 09:31 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.6800 | 1.5500 | 1.6800 | 70.9700 | 17976.00 | 17976.00 | 0.00 | 107 | 6 | 111 | 2904 | 0.0382231404958678 | 0.427430606954218 | 0.427430606954218 | false | false | false | true | ||||||||||||||||
| f0c775c2-8a66-4607-aca2-56df3e8f4ddf | 2026-09-25 14:44 | 2026-09-25 14:44 | 2026-09-25 14:44 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.5600 | 1.5600 | 1.6000 | 71.1250 | 111540.00 | 0.00 | 111540.00 | 715 | 35 | 1608 | 1947 | 0.825885978428351 | 0.278861689898971 | 0.278861689898971 | false | false | false | true | ||||||||||||||||
| b9559bf3-8c33-446d-b613-017c041f479e | 2026-09-25 13:34 | 2026-09-25 13:34 | 2026-09-25 13:34 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.5700 | 1.5300 | 1.5700 | 71.0000 | 15543.00 | 15543.00 | 0.00 | 99 | 6 | 778 | 1947 | 0.399589111453518 | 0.284703281081543 | 0.284703281081543 | false | false | false | true | ||||||||||||||||
| b8af2e84-1dc9-4e1a-ad84-9d5f714eb132 | 2026-09-24 09:48 | 2026-09-24 09:48 | 2026-09-24 09:48 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.5200 | 1.5200 | 1.5800 | 71.5900 | 31008.00 | 0.00 | 31008.00 | 204 | 25 | 286 | 1588 | 0.180100755667506 | 0.316018058885518 | 0.316018058885518 | false | false | false | true | ||||||||||||||||
| e193ebcf-901e-4a35-8756-7c49f9eaf635 | 2026-09-23 10:40 | 2026-09-23 10:40 | 2026-09-23 10:40 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.3000 | 1.3000 | 1.3400 | 72.1900 | 11050.00 | 0.00 | 11050.00 | 85 | 6 | 710 | 1294 | 0.548686244204019 | 0.316024664402448 | 0.316024664402448 | false | false | false | true | ||||||||||||||||
| 323205ed-efe9-472d-bc40-11970253c1e7 | 2026-09-22 11:17 | 2026-09-22 11:16 | 2026-09-22 11:16 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.5300 | 1.5300 | 1.5600 | 71.8700 | 12087.00 | 0.00 | 12087.00 | 79 | 7 | 860 | 1063 | 0.809031044214487 | 0.316809916354079 | 0.316809916354079 | false | false | false | true | ||||||||||||||||
| c212dec3-77d1-406b-b89b-c9defbd5a0e0 | 2026-09-22 11:06 | 2026-09-22 11:05 | 2026-09-22 11:05 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.6400 | 1.6200 | 1.6500 | 71.0000 | 10660.00 | 8692.00 | 0.00 | 65 | 13 | 727 | 1063 | 0.683913452492945 | 0.319776381956543 | 0.320320261177461 | true | false | false | true | ||||||||||||||||
| 7923e08b-666c-49da-9604-a7f0f3fd970c | 2026-09-22 09:59 | 2026-09-22 09:59 | 2026-09-22 09:59 | NFLX | NFLX261002P00072000 | put | 72.0000 | 2026-10-02 | 1.4600 | 1.4100 | 1.4750 | 71.0000 | 22630.00 | 13578.00 | 9052.00 | 155 | 8 | 312 | 1063 | 0.293508936970837 | 0.312892297842131 | 0.312892297842131 | 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-29T14:20:45.817132Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:13:29.737020Z"} |
| 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-29T14:02:34.176265Z"} |
| 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 |
| 296243488249.00 |
| 2026-10-20 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:46:04.686299Z"} |
| 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-25T17:41:26.046305Z"} |
| 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-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-23T14:43:13.868883Z"} |
| 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-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 300469887020.00 |
| 2026-10-20 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 300469887020.00 |
| 2026-10-20 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |