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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6a52a8ad-1213-476b-9c28-74bdb359b67a | 2026-08-17 11:25 | 2026-08-17 11:25 | 2026-08-17 11:25 | TSLA | TSLA260918C00340000 | call | 340.0000 | 2026-09-18 | 16.1500 | 16.1500 | 16.3500 | 340.1200 | 314930.00 | 1620.00 | 313310.00 | 195 | 23 | 1254 | 4141 | 0.302825404491669 | 0.3880349410338 | 0.388347978797454 | 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-17T15:40:30.458422Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0e9c7b87-3636-4bee-bfb1-53ba3101b0fe | 2026-08-17 12:09 | 2026-08-17 12:09 | 2026-08-17 12:09 | TSLA | TSLA260918C00340000 | call | 340.0000 | 2026-09-18 | 16.4500 | 16.3500 | 16.6000 | 340.7900 | 500095.00 | 14810.00 | 485285.00 | 304 | 30 | 2145 | 4141 | 0.517990823472591 | 0.385976373583021 | 0.385569905708772 | 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-17T16:27:21.112559Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4fb389dd-5edd-4ec4-9046-6e2f3175ab50 | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | TSLA | TSLA260918C00340000 | call | 340.0000 | 2026-09-18 | 12.0500 | 11.7000 | 12.0500 | 331.3200 | 118090.00 | 118090.00 | 0.00 | 98 | 22 | 224 | 4361 | 0.0513643659711075 | 0.399262546699314 | 0.399262546699314 | 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-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b2b8d8eb-ca3e-48cc-83e8-fa6cf38de5ba | 2026-09-01 11:09 | 2026-09-01 11:09 | 2026-09-01 11:09 | TSLA | TSLA260918C00340000 | call | 340.0000 | 2026-09-18 | 24.2000 | 23.7500 | 24.3000 | 358.5750 | 604960.00 | 522680.00 | 77440.00 | 250 | 51 | 382 | 4535 | 0.0842337375964719 | 0.410994683941297 | 0.409637080530733 | 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-01T15:18:08.991662Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5db75a43-3e6c-46ed-8531-f411f8451885 | 2026-09-01 11:10 | 2026-09-01 11:10 | 2026-09-01 11:10 | TSLA | TSLA260918C00340000 | call | 340.0000 | 2026-09-18 | 23.7500 | 23.7500 | 24.1500 | 358.0950 | 197125.00 | 0.00 | 197125.00 | 83 | 9 | 465 | 4535 | 0.102535832414553 | 0.405924947254037 | 0.405924947254037 | 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-01T15:18:08.991662Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b24c9e75-fc00-42d6-a9b6-c56f228f3e10 | 2026-09-04 09:44 | 2026-09-04 09:44 | 2026-09-04 09:44 | TSLA | TSLA260918C00340000 | call | 340.0000 | 2026-09-18 | 21.8000 | 21.8000 | 22.3500 | 357.2100 | 669280.00 | 0.00 | 669280.00 | 307 | 40 | 320 | 4383 | 0.0730093543235227 | 0.393046241758671 | 0.393046241758671 | 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-04T13:45:37.268469Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dc896275-c96a-4e49-b4ea-e814888b2e2a | 2026-09-16 11:33 | 2026-09-16 11:32 | 2026-09-16 11:32 | TSLA | TSLA260918C00340000 | call | 340.0000 | 2026-09-18 | 22.9600 | 22.9000 | 23.2500 | 362.3400 | 137772.00 | 0.00 | 137772.00 | 60 | 5 | 241 | 4408 | 0.0546733212341198 | 0.616135309458648 | 0.600303561180262 | 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-16T15:39:18.643032Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 68bd7ccc-ade1-4083-aa91-b93c91a93ff5 | 2026-09-17 11:59 | 2026-09-17 11:59 | 2026-09-17 11:59 | TSLA | TSLA260918C00340000 | call | 340.0000 | 2026-09-18 | 29.4000 | 29.0500 | 29.9000 | 369.2050 | 123480.00 | 88200.00 | 35280.00 | 42 | 6 | 291 | 4344 | 0.0669889502762431 | 0.819676316862528 | 0.819676316862528 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1446324255683.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 57f052cd-c681-43fa-9950-85d9371f2330 | 2026-09-18 15:48 | 2026-09-18 15:48 | 2026-09-18 15:48 | TSLA | TSLA260918C00340000 | call | 340.0000 | 2026-09-18 | 23.7500 | 23.6000 | 23.8000 | 363.7150 | 358625.00 | 358625.00 | 0.00 | 151 | 6 | 698 | 3705 | 0.188394062078273 | 6.11630919220158 | 6.11630919220158 | 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-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |