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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a61e305f-026a-4a4c-84fa-17ec29a0af31 | 2026-09-18 16:00 | 2026-09-18 15:59 | 2026-09-18 15:59 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.2000 | 12.1000 | 12.2000 | 931.0000 | 143960.00 | 143960.00 | 0.00 | 118 | 7 | 6306 | 803 | 7.85305105853051 | 0.684262168564956 | 0.684262168564956 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 186e0d6d-36b1-4327-aa1e-2c9dfd3f5c76 | 2026-09-18 16:00 | 2026-09-18 15:59 | 2026-09-18 15:59 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.2200 | 12.0000 | 12.6000 | 931.0000 | 656410.00 | 397740.00 | 258670.00 | 537 | 68 | 6177 | 803 | 7.69240348692403 | 0.692821367775549 | 0.687820531043809 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 9e2cc93f-bc72-4008-8491-a5a4b7defb70 | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.5000 | 13.0000 | 931.0000 | 225280.00 | 225280.00 | 0.00 | 176 | 6 | 5222 | 803 | 6.50311332503113 | 0.697711612065377 | 0.697711612065377 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 5e6e4051-a517-4b55-9e37-b8eabf1c77cb | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.5000 | 12.8000 | 931.0000 | 136960.00 | 136960.00 | 0.00 | 107 | 8 | 5045 | 803 | 6.2826899128269 | 0.701458665265164 | 0.701458665265164 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 5c480fcf-bac3-480e-918c-73116fb56b0e | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.7000 | 12.8000 | 931.0000 | 89600.00 | 89600.00 | 0.00 | 70 | 11 | 4936 | 803 | 6.14694894146949 | 0.697589697705384 | 0.697589697705384 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 061d70f4-72aa-4a1e-89b9-d12c39372aa3 | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.7000 | 12.8000 | 931.0000 | 52480.00 | 52480.00 | 0.00 | 41 | 18 | 4840 | 803 | 6.02739726027397 | 0.699631271808726 | 0.699631271808726 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 232acbed-04df-42ce-97a2-166ef2ba1845 | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.6000 | 12.5000 | 12.6000 | 931.0000 | 317520.00 | 317520.00 | 0.00 | 252 | 5 | 4762 | 803 | 5.93026151930261 | 0.696104112287348 | 0.696104112287348 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 3f5933d7-345c-48f3-a7f7-f7360c67850e | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.6000 | 12.2000 | 13.2000 | 930.0000 | 75600.00 | 3780.00 | 60480.00 | 60 | 6 | 4491 | 803 | 5.59277708592777 | 0.700594092951237 | 0.700594092951237 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 0735299b-27bf-41e5-ac14-9ad1d972db29 | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.5000 | 13.2000 | 930.0000 | 226550.00 | 93440.00 | 104950.00 | 177 | 23 | 4430 | 803 | 5.51681195516812 | 0.700605984846798 | 0.700439875550775 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| b00e7d7d-58de-4d29-a51b-c16e525c94f2 | 2026-09-18 12:53 | 2026-09-18 12:53 | 2026-09-18 12:53 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 9.0000 | 8.5000 | 9.5000 | 912.5000 | 166500.00 | 163800.00 | 2700.00 | 185 | 32 | 3470 | 803 | 4.32129514321295 | 0.721838681784734 | 0.709338172136242 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 127c2a9f-9707-4374-9de1-7aa1d776acf9 | 2026-09-18 12:08 | 2026-09-18 12:07 | 2026-09-18 12:07 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 9.5000 | 9.4000 | 9.9000 | 914.0000 | 190950.00 | 121600.00 | 65550.00 | 201 | 46 | 3122 | 803 | 3.8879202988792 | 0.714670557428629 | 0.714670557428629 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 4bfae61f-3beb-4498-b385-01e3f846b27c | 2026-09-18 11:51 | 2026-09-18 11:50 | 2026-09-18 11:50 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 9.2000 | 8.8000 | 9.4000 | 910.5392 | 126960.00 | 126960.00 | 0.00 | 138 | 13 | 2705 | 803 | 3.36861768368618 | 0.726055406910714 | 0.726055406910714 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |