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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79879aeb-faaa-47c5-a1f3-7c2df432cd8f | 2026-08-17 09:48 | 2026-08-17 09:47 | 2026-08-17 09:47 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 122.1700 | 118.3000 | 127.3000 | 949.9900 | 244345.00 | 134365.00 | 109980.00 | 20 | 6 | 20 | 694 | 0.0288184438040346 | 0.857526779544698 | 0.858000986492402 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7458dd9a-02d5-40f8-bdc3-5d2e5d586474 | 2026-08-25 13:12 | 2026-08-25 13:12 | 2026-08-25 13:12 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 46.9000 | 46.0000 | 46.9000 | 849.2950 | 79730.00 | 79730.00 | 0.00 | 17 | 17 | 77 | 714 | 0.107843137254902 | 0.767077478902842 | 0.767077478902842 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 65ad4b8b-ad4f-46bb-9932-df7f3aac4bb1 | 2026-08-27 11:35 | 2026-08-27 11:34 | 2026-08-27 11:34 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 81.4700 | 80.4000 | 85.0000 | 927.3617 | 65179.00 | 57000.00 | 8179.00 | 8 | 7 | 48 | 683 | 0.0702781844802343 | 0.73548789061348 | 0.739939271023156 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a4575ca5-775c-4eb3-a743-bd6bd625d36b | 2026-08-27 14:32 | 2026-08-27 14:31 | 2026-08-27 14:31 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 97.0000 | 95.9000 | 97.0000 | 948.7850 | 77600.00 | 77600.00 | 0.00 | 8 | 6 | 69 | 683 | 0.101024890190337 | 0.75991173505573 | 0.75991173505573 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6401b9b9-203e-4015-9c61-21dd3e4cb12a | 2026-09-04 12:17 | 2026-09-04 12:17 | 2026-09-04 12:17 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 35.5000 | 35.5000 | 37.7000 | 877.5100 | 117150.00 | 0.00 | 117150.00 | 33 | 5 | 88 | 677 | 0.129985228951256 | 0.653315769452512 | 0.653315769452512 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | 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 |
| e59b9b65-d155-41b0-ac05-bccedd814a47 | 2026-09-14 09:37 | 2026-09-14 09:37 | 2026-09-14 09:37 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 14.0000 | 13.9000 | 15.5000 | 847.0000 | 159600.00 | 151200.00 | 8400.00 | 114 | 10 | 214 | 601 | 0.356073211314476 | 0.933726847723652 | 0.933726847723652 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 336304a2-740f-4856-b17a-6acdb9747e6a | 2026-09-14 09:37 | 2026-09-14 09:37 | 2026-09-14 09:37 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 14.0100 | 13.9000 | 15.5000 | 847.0600 | 128920.00 | 11320.00 | 77000.00 | 92 | 20 | 100 | 601 | 0.166389351081531 | 0.933158616498533 | 0.933158616498533 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84089ec7-9491-43a3-8865-3e4b23d853fd | 2026-09-14 15:38 | 2026-09-14 15:38 | 2026-09-14 15:38 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 8.2000 | 8.2000 | 9.1000 | 834.8900 | 53300.00 | 0.00 | 53300.00 | 65 | 22 | 1091 | 601 | 1.8153078202995 | 0.832448601196154 | 0.832448601196154 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | 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 |
| 2b9b9683-5f9b-404a-9520-69e597e3127d | 2026-09-15 09:45 | 2026-09-15 09:45 | 2026-09-15 09:45 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 9.0000 | 8.6000 | 9.0000 | 850.8800 | 62100.00 | 62100.00 | 0.00 | 69 | 10 | 279 | 1107 | 0.252032520325203 | 0.844431589199107 | 0.840000088239499 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 4390f544-1dfe-4d85-a8cb-9c5c64ea47d2 | 2026-09-15 09:46 | 2026-09-15 09:46 | 2026-09-15 09:46 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 9.0000 | 8.5000 | 10.0000 | 850.7182 | 117900.00 | 113400.00 | 3600.00 | 131 | 18 | 410 | 1107 | 0.37037037037037 | 0.839295639479844 | 0.841630231733583 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 86e1b7f1-d54b-4810-a663-510583e2ac74 | 2026-09-15 09:46 | 2026-09-15 09:46 | 2026-09-15 09:46 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 9.4400 | 8.8000 | 9.7000 | 853.6400 | 116140.00 | 48730.00 | 65530.00 | 123 | 28 | 539 | 1107 | 0.486901535682023 | 0.828398897910306 | 0.828301516563203 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 207edb43-a212-47fa-ac9d-7246613eb7dc | 2026-09-15 09:46 | 2026-09-15 09:46 | 2026-09-15 09:46 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 9.9300 | 9.3000 | 10.2000 | 853.0900 | 167810.00 | 113310.00 | 54500.00 | 169 | 27 | 761 | 1107 | 0.687443541102078 | 0.85403952932981 | 0.848431693111642 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 18411af1-537e-42a4-b62e-c30aeadb8c67 | 2026-09-15 09:49 | 2026-09-15 09:48 | 2026-09-15 09:48 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 10.4000 | 10.2000 | 10.4000 | 853.9988 | 65520.00 | 65520.00 | 0.00 | 63 | 7 | 1641 | 1107 | 1.48238482384824 | 0.86443366645065 | 0.86443366645065 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 25df6b19-0989-47f8-86c5-b0914649aecb | 2026-09-15 10:21 | 2026-09-15 10:21 | 2026-09-15 10:21 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 10.0000 | 9.7000 | 10.3000 | 855.0600 | 147000.00 | 136000.00 | 0.00 | 147 | 18 | 2881 | 1107 | 2.60252935862692 | 0.835293241642342 | 0.837584020598558 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| a03118e5-6d49-4e88-8724-4e48e49e93de | 2026-09-16 10:47 | 2026-09-16 10:47 | 2026-09-16 10:47 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 24.0000 | 22.3000 | 24.1000 | 899.3300 | 93590.00 | 93590.00 | 0.00 | 39 | 6 | 1165 | 2022 | 0.576162215628091 | 0.908780409786873 | 0.912546991679071 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 82470180000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 05d8d50d-0793-4f71-ae3a-696ebca742ef | 2026-09-16 10:49 | 2026-09-16 10:49 | 2026-09-16 10:49 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 21.4200 | 20.7000 | 22.5000 | 895.8400 | 85696.00 | 0.00 | 85696.00 | 40 | 5 | 1213 | 2022 | 0.599901088031652 | 0.88384362863564 | 0.88384362863564 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 82470180000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 5a721055-c54c-46a6-942a-4eaf4fe78b68 | 2026-09-16 11:51 | 2026-09-16 11:51 | 2026-09-16 11:51 | LITE | LITE260918C00900000 | call | 900.0000 | 2026-09-18 | 30.0000 | 29.0000 | 31.0000 | 912.9996 | 240000.00 | 9000.00 | 201000.00 | 80 | 8 | 1598 | 2022 | 0.790306627101879 | 0.851891757433455 | 0.851891757433455 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 82470180000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |