Options flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d07e679a-0a96-46cd-818c-6604340b7948 | 2026-09-18 13:28 | 2026-09-18 13:28 | 2026-09-18 13:28 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 24.0000 | 23.9500 | 24.1000 | 363.0250 | 664800.00 | 2400.00 | 446400.00 | 277 | 12 | 1103 | 35285 | 0.0312597421000425 | 0.438008257034932 | 0.438008257034932 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1438701629212.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 2272cd0c-8fe2-4397-a096-e28d61e96a65 | 2026-09-16 15:24 | 2026-09-16 15:24 | 2026-09-16 15:24 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 21.9500 | 21.9000 | 22.1000 | 355.6700 | 346826.00 | 0.00 | 346826.00 | 158 | 5 | 1096 | 35591 | 0.0307943019302633 | 0.445995397834965 | 0.445995397834965 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 1414253930844.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 4fab5078-2456-4570-acf6-fac75b498a54 | 2026-09-16 13:11 | 2026-09-16 13:11 | 2026-09-16 13:11 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 24.2500 | 24.2000 | 24.2500 | 361.8650 | 113975.00 | 113975.00 | 0.00 | 47 | 17 | 638 | 35591 | 0.0179258801382372 | 0.443332211670664 | 0.443332211670664 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1414253930844.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 2bc353f0-748b-488b-a72a-a92b2bf4211f | 2026-09-14 15:30 | 2026-09-14 15:30 | 2026-09-14 15:30 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 23.5600 | 23.5500 | 23.8000 | 360.1750 | 277957.00 | 0.00 | 277957.00 | 118 | 20 | 1051 | 35197 | 0.029860499474387 | 0.442212728155872 | 0.442212728155872 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3be19637-dc4a-4201-b789-6564746b86c3 | 2026-09-03 14:37 | 2026-09-03 14:37 | 2026-09-03 14:37 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 36.6500 | 36.3000 | 36.7000 | 381.6600 | 102627.00 | 102627.00 | 0.00 | 28 | 6 | 3391 | 36336 | 0.0933234258036107 | 0.458916318676066 | 0.456856513898397 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bf9f2e05-7078-4df8-9d7a-973d6d4e5e48 | 2026-09-03 10:25 | 2026-09-03 10:25 | 2026-09-03 10:25 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 35.6000 | 35.6000 | 35.9000 | 379.0450 | 213600.00 | 0.00 | 213600.00 | 60 | 15 | 1179 | 36336 | 0.0324471598414795 | 0.461244285142037 | 0.461244285142037 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 28cc37bc-ec47-40f0-88be-ec1f2d2f4018 | 2026-09-03 10:22 | 2026-09-03 10:22 | 2026-09-03 10:22 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 35.0000 | 34.7000 | 35.0000 | 378.0900 | 105000.00 | 105000.00 | 0.00 | 30 | 9 | 1019 | 36336 | 0.0280438132981066 | 0.460619072929477 | 0.459862515946133 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e9c95f45-5685-43cd-a498-d5ebb38505c6 | 2026-09-03 09:38 | 2026-09-03 09:37 | 2026-09-03 09:37 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 31.4500 | 31.4500 | 31.8000 | 371.8300 | 157250.00 | 0.00 | 157250.00 | 50 | 6 | 298 | 36336 | 0.00820123293703214 | 0.453917346844254 | 0.453917346844254 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f82c17ab-152b-4975-8f2b-c57ba11a35c1 | 2026-08-31 15:58 | 2026-08-31 15:58 | 2026-08-31 15:58 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 29.8500 | 29.7500 | 29.9500 | 368.0350 | 134325.00 | 71640.00 | 41790.00 | 45 | 6 | 2359 | 35877 | 0.0657524319201717 | 0.447759759431001 | 0.447759759431001 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 383a2592-9198-4dd8-b7ee-390d7a32f91c | 2026-08-31 13:45 | 2026-08-31 13:45 | 2026-08-31 13:45 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 30.0000 | 29.8000 | 30.0000 | 367.0000 | 117000.00 | 117000.00 | 0.00 | 39 | 15 | 1958 | 35877 | 0.0545753546840594 | 0.452115304183397 | 0.452115304183397 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3c19fbbb-d717-4a1b-b0f2-e8b3bbd15048 | 2026-08-31 13:44 | 2026-08-31 13:44 | 2026-08-31 13:44 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 29.8500 | 29.7000 | 30.0000 | 367.2100 | 119400.00 | 77610.00 | 23880.00 | 40 | 9 | 1868 | 35877 | 0.052066783733311 | 0.451962133625861 | 0.451962133625861 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 199a0a50-f89a-4a90-9aa7-7e173e176ea8 | 2026-08-31 11:11 | 2026-08-31 11:11 | 2026-08-31 11:11 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 29.0000 | 28.6500 | 29.0500 | 365.2500 | 246500.00 | 246500.00 | 0.00 | 85 | 8 | 919 | 35877 | 0.0256152967081975 | 0.45232437507488 | 0.45232437507488 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5bca8e7e-e074-4268-bda0-7c86d1181c4f | 2026-08-31 10:17 | 2026-08-31 10:17 | 2026-08-31 10:17 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 27.9000 | 27.6000 | 27.9500 | 362.5872 | 106005.00 | 106005.00 | 0.00 | 38 | 6 | 624 | 35877 | 0.0173927585918555 | 0.453312920016129 | 0.453748786681789 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dd04709c-82a4-42b6-8220-bfcc84b4b34d | 2026-08-31 09:51 | 2026-08-31 09:51 | 2026-08-31 09:51 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 26.7000 | 26.3000 | 26.9000 | 360.2950 | 194910.00 | 98615.00 | 93625.00 | 73 | 6 | 390 | 35877 | 0.0108704741199097 | 0.451375786313453 | 0.451325158119264 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 112aea93-4cc7-425b-9851-da85dc5cc52a | 2026-08-27 11:15 | 2026-08-27 11:15 | 2026-08-27 11:15 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 24.1000 | 23.9500 | 24.2500 | 353.1950 | 122910.00 | 57840.00 | 0.00 | 51 | 5 | 354 | 35877 | 0.00986704573961034 | 0.448079501281569 | 0.447985154367388 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eb577a38-7477-480a-82d3-85217e71d7d5 | 2026-08-26 13:58 | 2026-08-26 13:58 | 2026-08-26 13:58 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 21.9000 | 21.6000 | 21.9000 | 346.6250 | 219000.00 | 219000.00 | 0.00 | 100 | 7 | 647 | 35463 | 0.0182443673688069 | 0.450404545001296 | 0.450404545001296 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 669f9ce9-5009-4be0-b194-fafc893f4604 | 2026-08-21 11:07 | 2026-08-21 11:07 | 2026-08-21 11:07 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 31.5000 | 31.2500 | 31.5000 | 363.7500 | 157500.00 | 157500.00 | 0.00 | 50 | 8 | 1952 | 36628 | 0.0532925630665065 | 0.470208549711683 | 0.470208549711683 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e7e68d6c-7dc2-459e-82b8-915fb438f932 | 2026-08-21 11:07 | 2026-08-21 11:07 | 2026-08-21 11:07 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 31.5000 | 31.1500 | 31.5000 | 363.7900 | 154345.00 | 154345.00 | 0.00 | 49 | 5 | 1802 | 36628 | 0.0491973353718467 | 0.470010094752543 | 0.470010094752543 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 35528266-909d-4b44-bc76-f3bf88d8e1fc | 2026-08-21 11:05 | 2026-08-21 11:05 | 2026-08-21 11:05 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 31.2500 | 31.1500 | 31.2500 | 363.3350 | 156250.00 | 156250.00 | 0.00 | 50 | 5 | 1595 | 36628 | 0.0435459211532161 | 0.469529966546592 | 0.469529966546592 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 907a9164-e41f-45c4-bd15-907a16745b71 | 2026-08-21 10:57 | 2026-08-21 10:57 | 2026-08-21 10:57 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 30.0000 | 29.6500 | 30.0000 | 361.0600 | 126000.00 | 126000.00 | 0.00 | 42 | 22 | 1266 | 36628 | 0.0345637217429289 | 0.466977139576531 | 0.466977139576531 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bd0e2cf4-4e56-4799-b9fd-b57ac7d73b8d | 2026-08-17 13:58 | 2026-08-17 13:58 | 2026-08-17 13:58 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 20.6000 | 20.5000 | 20.7000 | 339.0000 | 103000.00 | 96820.00 | 6180.00 | 50 | 10 | 804 | 37037 | 0.0217080217080217 | 0.450864455843308 | 0.450864455843308 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84ba884a-0b00-4662-867a-dd3cf3fc8aaf | 2026-08-17 12:38 | 2026-08-17 12:38 | 2026-08-17 12:38 | TSLA | TSLA270115C00400000 | call | 400.0000 | 2027-01-15 | 20.8000 | 20.6000 | 20.9500 | 340.4850 | 312000.00 | 62400.00 | 93600.00 | 150 | 6 | 392 | 37037 | 0.0105840105840106 | 0.449506722842458 | 0.449506722842458 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | 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 |