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 |
|---|
| 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 |
|---|
| bc8b3642-baaf-4306-aa64-58daa13c0263 | 2026-08-31 10:36 | 2026-08-31 10:35 | 2026-08-31 10:35 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 10.4800 | 10.3000 | 11.1000 | 175.3150 | 115280.00 | 0.00 | 115280.00 | 110 | 6 | 123 | 3303 | 0.0372388737511353 | 0.516940492141966 | 0.516940492141966 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 220923995537.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 95444c40-9229-4e2c-ab20-a0d5bef2d27b | 2026-09-09 13:55 | 2026-09-09 13:54 | 2026-09-09 13:54 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 5.6000 | 5.6000 | 5.9000 | 182.1100 | 375760.00 | 0.00 | 375760.00 | 671 | 31 | 690 | 3144 | 0.219465648854962 | 0.592288288355523 | 0.589244587052478 | false | false | false | true | ||||||||||||||||
| d30e7885-cada-4fe2-b230-d55305778113 | 2026-09-09 13:55 | 2026-09-09 13:55 | 2026-09-09 13:55 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 5.7000 | 5.3000 | 5.8000 | 181.8900 | 83790.00 | 36480.00 | 47310.00 | 147 | 30 | 857 | 3144 | 0.272582697201018 | 0.592222053027653 | 0.589721209979031 | true | false | false | true | ||||||||||||||||
| 283f9a20-8da3-4e44-aeb9-f34d0e93383b | 2026-09-09 13:59 | 2026-09-09 13:59 | 2026-09-09 13:59 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 5.8000 | 5.5000 | 5.8000 | 181.9100 | 70758.00 | 70758.00 | 0.00 | 122 | 40 | 1008 | 3144 | 0.320610687022901 | 0.599394069156415 | 0.599394069156415 | false | false | false | true | ||||||||||||||||
| 8018b526-e79c-414a-a888-98d8dc5c5e58 | 2026-09-09 15:05 | 2026-09-09 15:05 | 2026-09-09 15:05 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 5.7000 | 5.7000 | 5.8000 | 181.8300 | 177840.00 | 0.00 | 177840.00 | 312 | 38 | 1323 | 3144 | 0.420801526717557 | 0.590491488484521 | 0.58740613877217 | false | false | false | true | ||||||||||||||||
| 13752de8-b477-46b2-8622-3b7ae6fc6e60 | 2026-09-14 13:02 | 2026-09-14 13:02 | 2026-09-14 13:02 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 11.4000 | 11.0000 | 12.3000 | 169.6950 | 84360.00 | 69540.00 | 14820.00 | 74 | 6 | 288 | 4009 | 0.0718383636817161 | 0.627660316586135 | 0.627660316586135 | false | false | false | true | ||||||||||||||||
| e2798fe6-c288-496f-acaa-02ac3b07d20b | 2026-09-17 15:46 | 2026-09-17 15:46 | 2026-09-17 15:46 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 10.6000 | 10.2000 | 10.6000 | 169.4600 | 84800.00 | 84800.00 | 0.00 | 80 | 8 | 286 | 3762 | 0.0760233918128655 | 0.63382621952505 | 0.63382621952505 | false | false | false | true | ||||||||||||||||
| a3b223ca-7479-4787-aec8-796a4da1a29e | 2026-09-17 15:46 | 2026-09-17 15:46 | 2026-09-17 15:46 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 10.5000 | 10.3000 | 10.5000 | 169.4500 | 88200.00 | 88200.00 | 0.00 | 84 | 10 | 370 | 3762 | 0.0983519404572036 | 0.928065975501086 | 0.928065975501086 | true | false | false | true | ||||||||||||||||
| 4c4e9e2b-7358-49f9-8937-0d135ef2a627 | 2026-09-17 15:46 | 2026-09-17 15:46 | 2026-09-17 15:46 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 10.5000 | 10.4000 | 10.5000 | 169.5100 | 126000.00 | 126000.00 | 0.00 | 120 | 6 | 526 | 3762 | 0.139819245082403 | 0.538330529335689 | 0.538330529335689 | false | false | false | true | ||||||||||||||||
| efc483c7-47d0-42d2-8532-0c8920aa4c1e | 2026-09-17 15:46 | 2026-09-17 15:46 | 2026-09-17 15:46 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 10.5000 | 10.4000 | 10.5000 | 169.5000 | 327600.00 | 327600.00 | 0.00 | 312 | 8 | 838 | 3762 | 0.222753854332802 | 0.508761238608622 | 0.508761238608622 | true | false | false | true | ||||||||||||||||
| 928b5622-be52-4212-957c-cc77cfea5169 | 2026-09-17 15:49 | 2026-09-17 15:49 | 2026-09-17 15:49 | KLAC | KLAC260918P00180000 | put | 180.0000 | 2026-09-18 | 10.4000 | 10.2000 | 10.4000 | 169.5100 | 76960.00 | 76960.00 | 0.00 | 74 | 8 | 1006 | 3762 | 0.267410951621478 | 0.629246197372345 | 0.629246197372345 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220923995537.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220923995537.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220923995537.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220923995537.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220923995537.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220780275391.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220780275391.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220780275391.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220780275391.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220780275391.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |