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 |
|---|
| 3c25bc58-1f5d-4b2c-a310-081f82e4df78 | 2026-09-29 09:33 | 2026-09-29 09:33 | 2026-09-29 09:33 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8500 | 0.7200 | 0.9000 | 24.8096 | 23094.00 | 4290.00 | 18804.00 | 272 | 5 | 531 | 25968 | 0.0204482439926063 | 0.436207791006788 | 0.448516382872717 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 33763160339.00 | 2026-09-29 | premarket | — | 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 |
| e049b8d3-24b5-4699-b63d-d8280d5cbff9 | 2026-09-15 15:49 | 2026-09-15 15:49 | 2026-09-15 15:49 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.4200 | 0.4200 | 0.4500 | 22.0000 | 10626.00 | 0.00 | 10626.00 | 253 | 12 | 387 | 19621 | 0.0197237653534478 | 0.44426547062957 | 0.44426547062957 | false | false | false | true | ||||||||||||||||
| b3e07178-daac-4991-8553-ed20f465ea58 | 2026-09-04 12:30 | 2026-09-04 12:30 | 2026-09-04 12:30 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.7700 | 0.7400 | 0.7700 | 23.5900 | 34650.00 | 34650.00 | 0.00 | 450 | 17 | 573 | 18649 | 0.0307255080701378 | 0.440856455058499 | 0.440856455058499 | false | false | false | true | ||||||||||||||||
| b72ce351-651d-4c2d-a517-e44826144977 | 2026-09-01 12:53 | 2026-09-01 12:53 | 2026-09-01 12:53 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.7500 | 0.7000 | 0.7500 | 23.4600 | 33750.00 | 33750.00 | 0.00 | 450 | 17 | 1155 | 14520 | 0.0795454545454545 | 0.439360392412377 | 0.439360392412377 | false | false | false | true | ||||||||||||||||
| 6d887818-a50f-4551-8593-0fb1f10b981e | 2026-08-31 15:42 | 2026-08-31 15:42 | 2026-08-31 15:42 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8500 | 0.8400 | 0.8500 | 23.9500 | 38250.00 | 38250.00 | 0.00 | 450 | 23 | 5897 | 8976 | 0.656974153297683 | 0.431788260066435 | 0.431788260066435 | false | false | false | true | ||||||||||||||||
| 223da36c-5d55-447e-87be-b0ff21173bc2 | 2026-08-31 15:41 | 2026-08-31 15:40 | 2026-08-31 15:40 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8400 | 0.8300 | 0.8500 | 23.9250 | 33012.00 | 27888.00 | 5040.00 | 393 | 16 | 5447 | 8976 | 0.60684046345811 | 0.43100498917044 | 0.43100498917044 | false | false | false | true | ||||||||||||||||
| dc59df8b-cbf9-4388-a3b4-fd9dfd44d080 | 2026-08-31 15:40 | 2026-08-31 15:40 | 2026-08-31 15:40 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8400 | 0.8300 | 0.8500 | 23.9300 | 37800.00 | 37716.00 | 0.00 | 450 | 35 | 4604 | 8976 | 0.512923351158645 | 0.43100498917044 | 0.430735553955385 | false | false | false | true | ||||||||||||||||
| 206a3f2c-f738-473c-807f-e1fe63f46838 | 2026-08-31 15:26 | 2026-08-31 15:25 | 2026-08-31 15:25 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8600 | 0.8400 | 0.8600 | 23.9900 | 64500.00 | 64500.00 | 0.00 | 750 | 50 | 4032 | 8976 | 0.449197860962567 | 0.43201691438469 | 0.43174626926714 | false | false | false | true | ||||||||||||||||
| ff086a02-490b-4c57-92ff-f9701a7d2c09 | 2026-08-31 15:24 | 2026-08-31 15:24 | 2026-08-31 15:24 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8500 | 0.8400 | 0.8500 | 23.9550 | 63750.00 | 63750.00 | 0.00 | 750 | 22 | 3282 | 8976 | 0.365641711229947 | 0.431518195445127 | 0.431518195445127 | false | false | false | true | ||||||||||||||||
| 81b61e3c-aa88-46da-9314-56aac8a435d7 | 2026-08-31 15:23 | 2026-08-31 15:23 | 2026-08-31 15:23 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8500 | 0.8400 | 0.8500 | 23.9450 | 14960.00 | 14960.00 | 0.00 | 176 | 6 | 2532 | 8976 | 0.282085561497326 | 0.432058347129506 | 0.432058347129506 | false | false | false | true | ||||||||||||||||
| 598ba1ae-d4f0-4a94-b5d1-80ece69fec4f | 2026-08-31 15:23 | 2026-08-31 15:23 | 2026-08-31 15:23 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8500 | 0.8400 | 0.8500 | 23.9450 | 48790.00 | 48790.00 | 0.00 | 574 | 24 | 2356 | 8976 | 0.262477718360071 | 0.432058347129506 | 0.432058347129506 | false | false | false | true | ||||||||||||||||
| acd49443-63dc-4b3e-a03a-5b0da4b0e312 | 2026-08-31 15:21 | 2026-08-31 15:21 | 2026-08-31 15:21 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8400 | 0.8000 | 0.8400 | 23.9300 | 23016.00 | 23016.00 | 0.00 | 274 | 16 | 1367 | 8976 | 0.152295008912656 | 0.43100498917044 | 0.430735553955385 | false | false | false | true | ||||||||||||||||
| 32d22dec-ba19-4561-9297-4c1dc4ceb339 | 2026-08-31 15:20 | 2026-08-31 15:20 | 2026-08-31 15:20 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 0.8400 | 0.8000 | 0.8400 | 23.9250 | 42000.00 | 42000.00 | 0.00 | 500 | 29 | 1043 | 8976 | 0.116198752228164 | 0.43100498917044 | 0.43100498917044 | false | false | false | true | ||||||||||||||||
| d76077b5-b2c4-4804-bf48-5f311c1e3a77 | 2026-08-19 15:37 | 2026-08-19 15:37 | 2026-08-19 15:37 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 1.8800 | 1.8600 | 1.9300 | 26.8000 | 36631.00 | 11520.00 | 25111.00 | 195 | 5 | 264 | 7847 | 0.0336434306104244 | 0.424373907685331 | 0.432473077099132 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |