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 |
|---|
| e3de7c05-998a-47a1-b1f0-1c384017be4c | 2026-09-25 12:25 | 2026-09-25 12:25 | 2026-09-25 12:25 | CHTR | CHTR261016C00130000 | call | 130.0000 | 2026-10-16 | 1.5300 | 1.5000 | 1.8500 | 115.2800 | 61107.00 | 0.00 | 61107.00 | 400 | 10 | 415 | 2676 | 0.1550822122571 | 0.531948502138267 | 0.54002515989327 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 13467621622.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T16:27:03.681802Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 4f42bde0-1c3b-4ff5-9b30-2eb264c10365 | 2026-09-23 10:09 | 2026-09-23 10:09 | 2026-09-23 10:09 | CHTR | CHTR261120P00110000 | put | 110.0000 | 2026-11-20 | 9.2000 | 9.0000 | 9.9000 | 114.0525 | 69008.00 | 1848.00 | 67160.00 | 75 | 5 | 78 | 138 | 0.565217391304348 | 0.645200143096958 | 0.647503209870907 | false | false | false | true | ||||||||||||||||
| 22c7b0a9-7db1-4378-a712-9d451fc3a534 | 2026-09-21 12:39 | 2026-09-21 12:39 | 2026-09-21 12:39 | CHTR | CHTR261009P00115000 | put | 115.0000 | 2026-10-09 | 1.4400 | 1.4500 | 1.8000 | 126.4550 | 21085.00 | 0.00 | 20795.00 | 146 | 6 | 170 | 5 | 34 | 0.504052489766705 | 0.505416203434077 | true | false | false | true | ||||||||||||||||
| 9200ec5b-fc5b-4eee-a051-f9953d2f4a88 | 2026-09-17 11:42 | 2026-09-17 11:42 | 2026-09-17 11:42 | CHTR | CHTR271217C00165000 | call | 165.0000 | 2027-12-17 | 27.9600 | 27.2000 | 29.0000 | 135.4400 | 39140.00 | 30760.00 | 8380.00 | 14 | 6 | 735 | 122 | 6.02459016393443 | 0.58257182349706 | 0.584238435719044 | false | false | false | true | ||||||||||||||||
| 488f742e-d047-459a-9737-c41362ecc303 | 2026-09-15 15:45 | 2026-09-15 15:45 | 2026-09-15 15:45 | CHTR | CHTR261023P00140000 | put | 140.0000 | 2026-10-23 | 10.2400 | 8.8000 | 10.5000 | 139.0000 | 18440.00 | 8240.00 | 10200.00 | 18 | 9 | 158 | 70 | 2.25714285714286 | 0.56739213989991 | 0.56739213989991 | true | false | false | true | ||||||||||||||||
| c7e9cf96-8d46-4444-b55c-7bdff0910b06 | 2026-09-03 09:45 | 2026-09-03 09:45 | 2026-09-03 09:45 | CHTR | CHTR261016C00165000 | call | 165.0000 | 2026-10-16 | 7.9800 | 7.1000 | 10.0000 | 157.1350 | 47876.00 | 0.00 | 47876.00 | 60 | 8 | 60 | 399 | 0.150375939849624 | 0.507766407721494 | 0.507766407721494 | false | false | false | true | ||||||||||||||||
| 07073e90-8614-4abd-9629-ee1ae3fba1a6 | 2026-08-28 12:31 | 2026-08-28 12:31 | 2026-08-28 12:31 | CHTR | CHTR261016C00175000 | call | 175.0000 | 2026-10-16 | 4.1000 | 4.0000 | 4.5000 | 152.7600 | 88984.00 | 0.00 | 88574.00 | 217 | 38 | 217 | 310 | 0.7 | 0.49406337928539 | 0.496810816226257 | false | false | false | true | ||||||||||||||||
| a46b9ba1-e8d9-4853-b08f-72913ee9afae | 2026-08-26 15:44 | 2026-08-26 15:44 | 2026-08-26 15:44 | CHTR | CHTR270115C00155000 | call | 155.0000 | 2027-01-15 | 23.0300 | 20.8000 | 23.7000 | 154.9200 | 230330.00 | 230330.00 | 0.00 | 100 | 10 | 100 | 142 | 0.704225352112676 | 0.576715462501515 | 0.572462660475498 | false | false | false | true | ||||||||||||||||
| 5102db17-b9f0-4157-9782-2b4fdc829eb6 | 2026-08-21 14:26 | 2026-08-21 14:26 | 2026-08-21 14:26 | CHTR | CHTR261016P00155000 | put | 155.0000 | 2026-10-16 | 13.8000 | 13.7000 | 14.1000 | 150.7400 | 158706.00 | 0.00 | 158706.00 | 115 | 20 | 123 | 652 | 0.188650306748466 | 0.506554892064574 | 0.506554892064574 | false | false | false | true | ||||||||||||||||
| 0c654b45-047e-46bb-abc9-bb37f977de8e | 2026-08-19 11:16 | 2026-08-19 11:16 | 2026-08-19 11:16 | CHTR | CHTR260918P00150000 | put | 150.0000 | 2026-09-18 | 6.2200 | 5.9000 | 6.3000 | 157.0000 | 18657.00 | 18657.00 | 0.00 | 30 | 6 | 38 | 929 | 0.0409041980624327 | 0.541365744734849 | 0.541365744734849 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 13908948342.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 14712878638.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:41:29.676906Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 15908039108.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 17098428478.00 |
| 2026-10-30 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 17098428478.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 17098428478.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 17098428478.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 17098428478.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 17098428478.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |