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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3888b00a-69d5-4f09-b545-501c9da588d2 | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 5.2700 | 5.0000 | 5.6000 | 7630.0000 | 127070.00 | 72120.00 | 46880.00 | 241 | 93 | 165563 | 2364 | 70.0351099830795 | 0 | 0 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 039997af-1392-4b70-94fe-cfd93e945caa | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 4.8600 | 4.5000 | 5.2000 | 7630.0000 | 114200.00 | 42100.00 | 66750.00 | 235 | 121 | 164910 | 2364 | 69.758883248731 | 0 | 0.155054751470512 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| c9f96a07-5bc3-43d6-96ad-ea707ed862a5 | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 5.0000 | 4.9000 | 5.4000 | 7630.0000 | 151490.00 | 63560.00 | 3430.00 | 303 | 70 | 164621 | 2364 | 69.6366328257191 | 0 | 0.169151401690189 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| b07f6143-f31b-484f-b068-747782f6fb8f | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 3.8400 | 3.6000 | 4.1000 | 7625.0000 | 150850.00 | 26620.00 | 120740.00 | 393 | 133 | 163804 | 2364 | 69.2910321489002 | 0.187926700948059 | 0.161894277878983 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 73eb5636-349c-402c-ae1f-5cf25973d012 | 2026-09-18 15:50 | 2026-09-18 15:50 | 2026-09-18 15:50 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 3.8900 | 2.7000 | 4.7000 | 7643.3400 | 111905.00 | 29430.00 | 82475.00 | 288 | 147 | 154222 | 2364 | 65.2377326565144 | 0.237132981567559 | 0.321749109374154 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | 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 |
| 7e8d6317-93a5-4784-8e39-7a443544f9cd | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 3.7300 | 3.6000 | 3.9000 | 7645.9300 | 140110.00 | 19350.00 | 103980.00 | 376 | 87 | 149794 | 2364 | 63.3646362098139 | 0.227496859266751 | 0.21407181403547 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | — | 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 |
| dc43f6f3-cda3-4ed5-a0ff-26695802d048 | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 3.4000 | 3.3000 | 3.5000 | 7644.8500 | 125800.00 | 36390.00 | 88390.00 | 370 | 61 | 148561 | 2364 | 62.843062605753 | 0.229859192434505 | 0.229859192434505 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | 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 |
| a28f6519-a918-4242-a725-0d1d62928907 | 2026-09-18 15:13 | 2026-09-18 15:12 | 2026-09-18 15:12 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 3.0300 | 2.7000 | 3.3000 | 7642.3800 | 221735.00 | 169910.00 | 50910.00 | 732 | 120 | 109719 | 2364 | 46.4124365482233 | 0.133109574420611 | 0.151656270567432 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| b6edad2d-6186-4854-b095-0c502f0c0ca8 | 2026-09-18 15:04 | 2026-09-18 15:04 | 2026-09-18 15:04 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 2.8400 | 3.7000 | 3.9000 | 7643.7200 | 127100.00 | 1900.00 | 740.00 | 448 | 14 | 102203 | 2364 | 43.2330795262267 | 0.140420366227041 | 0.108855267681106 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 18634acd-555b-4cfe-9c0b-8613de236925 | 2026-09-18 14:53 | 2026-09-18 14:53 | 2026-09-18 14:53 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 5.5000 | 5.2000 | 5.6000 | 7645.2000 | 127020.00 | 53900.00 | 73120.00 | 231 | 63 | 90798 | 2364 | 38.4086294416244 | 0.161697984645322 | 0.156721955285907 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e982855a-8620-4751-bb00-830f917ec173 | 2026-09-18 11:25 | 2026-09-18 11:25 | 2026-09-18 11:25 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 2.9000 | 2.8500 | 2.9000 | 7628.9400 | 116580.00 | 116580.00 | 0.00 | 402 | 60 | 34572 | 2364 | 14.6243654822335 | 0.123419793546604 | 0.123637411771777 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a3056824-9d3e-4816-81ae-6f913a8f2a52 | 2026-09-18 10:31 | 2026-09-18 10:30 | 2026-09-18 10:30 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 3.0000 | 2.9000 | 3.1000 | 7622.9800 | 120000.00 | 119400.00 | 600.00 | 400 | 46 | 22034 | 2364 | 9.32064297800338 | 0.137741301854896 | 0.137741301854896 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 516411d0-6f1c-4aa1-82b6-4bcd2e052a0b | 2026-09-18 10:03 | 2026-09-18 10:03 | 2026-09-18 10:03 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 3.4000 | 3.4000 | 3.5000 | 7622.6400 | 117640.00 | 0.00 | 117640.00 | 346 | 11 | 14246 | 2364 | 6.02622673434856 | 0.140461080185706 | 0.140461080185706 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a4227662-5f59-439f-b525-db6f0eb2d0f3 | 2026-09-18 09:47 | 2026-09-18 09:47 | 2026-09-18 09:47 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 8.3000 | 8.3000 | 8.4000 | 7640.7700 | 136120.00 | 0.00 | 136120.00 | 164 | 34 | 7806 | 2364 | 3.30203045685279 | 0.12537393072602 | 0.12537393072602 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 39ee83e2-ef24-4d11-b0be-655ee0f1c212 | 2026-09-09 16:02 | 2026-09-09 16:00 | 2026-09-09 16:00 | SPXW | SPXW260918C07645000 | call | 7645.0000 | 2026-09-18 | 64.4000 | 64.0000 | 64.6000 | 7636.4900 | 296240.00 | 167440.00 | 32200.00 | 46 | 5 | 183 | 88 | 2.07954545454545 | 0.135996866095499 | 0.135996866095499 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |