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_alerts728,802 rows| 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 |
|---|
| 95dd58ff-f704-4d33-8098-fda3710c7839 | 2026-08-19 11:13 | 2026-08-19 11:13 | 2026-08-19 11:13 | CHTR | CHTR260821P00155000 | put | 155.0000 | 2026-08-21 | 2.7500 | 2.7500 | 2.9000 | 157.5400 | 20900.00 | 0.00 | 20900.00 | 76 | 16 | 189 | 712 | 0.265449438202247 | 0.845759810032543 | 0.845759810032543 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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 |
| 0882f687-12e9-419d-a51f-34edc82ff995 | 2026-08-19 10:34 | 2026-08-19 10:34 | 2026-08-19 10:34 | CHTR | CHTR261120C00165000 | call | 165.0000 | 2026-11-20 | 17.5000 | 16.9000 | 18.1000 | 158.8900 | 19250.00 | 17500.00 | 1750.00 | 11 | 11 | 37 | 110 | 0.336363636363636 | 0.608371379730757 | 0.608371379730757 | true | false | false | |||||||||||||||||
| b1aa3c6d-b87e-4b74-a600-10f03ba1c1e0 | 2026-08-19 10:34 | 2026-08-19 10:34 | 2026-08-19 10:34 | CHTR | CHTR261120C00165000 | call | 165.0000 | 2026-11-20 | 17.2000 | 16.0000 | 17.4000 | 158.6200 | 15480.00 | 15480.00 | 0.00 | 9 | 9 | 26 | 110 | 0.236363636363636 | 0.603400431835444 | 0.603400431835444 | false | false | false | true | ||||||||||||||||
| 73b9aca9-9f29-437e-b7f3-5a5bdc853406 | 2026-08-19 10:34 | 2026-08-19 10:34 | 2026-08-19 10:34 | CHTR | CHTR260821C00165000 | call | 165.0000 | 2026-08-21 | 2.1000 | 1.9000 | 2.1000 | 158.5300 | 40110.00 | 40110.00 | 0.00 | 191 | 14 | 212 | 2320 | 0.0913793103448276 | 0.96811166268008 | 0.96811166268008 | false | false | false | |||||||||||||||||
| 4f2fc3ef-4a11-4660-904a-b5711ee2255e | 2026-08-19 10:34 | 2026-08-19 10:34 | 2026-08-19 10:34 | CHTR | CHTR270115C00135000 | call | 135.0000 | 2027-01-15 | 37.4900 | 33.0000 | 37.5000 | 158.5300 | 29990.00 | 26250.00 | 3740.00 | 8 | 8 | 16 | 112 | 0.142857142857143 | 0.607200583274626 | 0.607200583274626 | false | false | false | |||||||||||||||||
| 4389fde0-95a0-40f6-8329-96d449ef2117 | 2026-08-19 10:31 | 2026-08-19 10:31 | 2026-08-19 10:31 | CHTR | CHTR260821P00160000 | put | 160.0000 | 2026-08-21 | 4.5000 | 3.6000 | 4.5000 | 158.3050 | 10800.00 | 10800.00 | 0.00 | 24 | 6 | 426 | 431 | 0.988399071925754 | 0.767930451858137 | 0.767930451858137 | true | false | false | true | ||||||||||||||||
| cc7e43ca-ef39-406b-b8c6-fd891cc972a5 | 2026-08-19 10:23 | 2026-08-19 10:23 | 2026-08-19 10:23 | CHTR | CHTR270115C00165000 | call | 165.0000 | 2027-01-15 | 21.2000 | 18.6000 | 21.2000 | 156.8700 | 16959.00 | 16959.00 | 0.00 | 8 | 7 | 9 | 191 | 0.0471204188481675 | 0.589678765632075 | 0.589678765632075 | false | false | false | true | ||||||||||||||||
| aef378d9-6452-4fa7-95c1-d0e9bf1ebe79 | 2026-08-19 10:20 | 2026-08-19 10:20 | 2026-08-19 10:20 | CHTR | CHTR260821C00160000 | call | 160.0000 | 2026-08-21 | 2.3000 | 1.6000 | 2.6000 | 156.5203 | 12420.00 | 1380.00 | 11040.00 | 54 | 18 | 577 | 4793 | 0.120383893177551 | 0.808106849328349 | 0.808106849328349 | true | false | false | |||||||||||||||||
| 6593d816-7ef3-4d20-8f5f-0f47a3b7745c | 2026-08-18 15:22 | 2026-08-18 15:22 | 2026-08-18 15:22 | CHTR | CHTR261218C00160000 | call | 160.0000 | 2026-12-18 | 17.9000 | 17.9000 | 18.4000 | 151.5500 | 153940.00 | 0.00 | 153940.00 | 86 | 8 | 87 | 641 | 0.135725429017161 | 0.589201255349274 | 0.589201255349274 | false | false | false | |||||||||||||||||
| 5656771a-d15c-4279-b2ed-6b1e07a09444 | 2026-08-18 14:32 | 2026-08-18 14:31 | 2026-08-18 14:31 | CHTR | CHTR260821C00150000 | call | 150.0000 | 2026-08-21 | 4.5000 | 4.5000 | 5.0000 | 151.9400 | 22950.00 | 0.00 | 22950.00 | 51 | 10 | 95 | 636 | 0.14937106918239 | 0.601459363869656 | 0.625629723913355 | true | false | false | true | ||||||||||||||||
| e75b678a-4b18-4cc5-ae9b-b6aa0f5f179c | 2026-08-18 14:28 | 2026-08-18 14:28 | 2026-08-18 14:28 | CHTR | CHTR260821P00155000 | put | 155.0000 | 2026-08-21 | 5.6000 | 5.0000 | 5.7000 | 151.7900 | 35840.00 | 34160.00 | 1120.00 | 64 | 18 | 65 | 713 | 0.091164095371669 | 0.687404319293168 | 0.687404319293168 | true | false | false | true | ||||||||||||||||
| 284d060b-80ea-4952-b05e-1ae32a04e164 | 2026-08-18 13:18 | 2026-08-18 13:17 | 2026-08-18 13:17 | CHTR | CHTR260918C00165000 | call | 165.0000 | 2026-09-18 | 4.5000 | 4.5000 | 4.6000 | 151.2900 | 32850.00 | 0.00 | 32850.00 | 73 | 8 | 137 | 267 | 0.51310861423221 | 0.529124197168647 | 0.529124197168647 | false | false | false | true | ||||||||||||||||
| 8ce3597f-816e-4288-a8b9-451b4804aec6 | 2026-08-17 15:45 | 2026-08-17 15:45 | 2026-08-17 15:45 | CHTR | CHTR261016C00160000 | call | 160.0000 | 2026-10-16 | 7.0000 | 7.0000 | 7.4000 | 144.7600 | 11200.00 | 0.00 | 11200.00 | 16 | 8 | 154 | 470 | 0.327659574468085 | 0.526006901510833 | 0.526006901510833 | false | false | false | true | ||||||||||||||||
| 7c457476-fe71-4463-92eb-938df3136421 | 2026-08-17 15:36 | 2026-08-17 15:35 | 2026-08-17 15:35 | CHTR | CHTR261218P00150000 | put | 150.0000 | 2026-12-18 | 21.1000 | 21.1000 | 21.8000 | 145.1450 | 84400.00 | 0.00 | 84400.00 | 40 | 12 | 94 | 354 | 0.265536723163842 | 0.581049703910156 | 0.581049703910156 | false | false | false | true | ||||||||||||||||
| b90ba8a6-3f8f-4e5b-9a00-dee2558cccb5 | 2026-08-17 14:57 | 2026-08-17 14:57 | 2026-08-17 14:57 | CHTR | CHTR261218P00150000 | put | 150.0000 | 2026-12-18 | 20.8000 | 20.8000 | 21.3000 | 146.0300 | 66570.00 | 2090.00 | 64480.00 | 32 | 9 | 47 | 354 | 0.132768361581921 | 0.584042671490919 | 0.584042671490919 | false | false | false | |||||||||||||||||
| 221fbeda-b12f-4136-b7b8-1473f9e13022 | 2026-08-17 12:55 | 2026-08-17 12:54 | 2026-08-17 12:54 | CHTR | CHTR260918C00150000 | call | 150.0000 | 2026-09-18 | 7.4000 | 6.7000 | 7.4000 | 146.0000 | 232354.00 | 232354.00 | 0.00 | 314 | 34 | 362 | 740 | 0.489189189189189 | 0.518633749746654 | 0.518633749746654 | false | false | false | |||||||||||||||||
| daffd7b3-2272-41ec-bf8a-c97e103efebd | 2026-08-17 12:42 | 2026-08-17 12:41 | 2026-08-17 12:41 | CHTR | CHTR261016C00160000 | call | 160.0000 | 2026-10-16 | 7.3000 | 7.3000 | 7.4000 | 145.8550 | 12410.00 | 0.00 | 2190.00 | 17 | 17 | 123 | 470 | 0.261702127659574 | 0.521046140088653 | 0.521046140088653 | false | false | false | true | ||||||||||||||||
| fc2eaaba-dc66-4495-b381-a136b8d3d46b | 2026-08-17 11:21 | 2026-08-17 11:21 | 2026-08-17 11:21 | CHTR | CHTR261016C00140000 | call | 140.0000 | 2026-10-16 | 16.2000 | 15.8000 | 20.9000 | 146.5700 | 11340.00 | 0.00 | 11340.00 | 7 | 5 | 7 | 50 | 0.14 | 0.525482231710239 | 0.525482231710239 | true | false | false | true | ||||||||||||||||
| 3b981d8a-3e05-49b0-8b20-a5c63af8507e | 2026-08-17 10:52 | 2026-08-17 10:51 | 2026-08-17 10:51 | CHTR | CHTR261218P00165000 | put | 165.0000 | 2026-12-18 | 28.9100 | 28.9000 | 30.4000 | 148.5200 | 26020.00 | 0.00 | 26020.00 | 9 | 7 | 13 | 2 | 6.5 | 0.58516739458259 | 0.58516739458259 | false | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |