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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c294f024-1d94-4722-ba23-23c3d52812f0 | 2026-09-18 16:13 | 2026-09-18 16:13 | 2026-09-18 16:13 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 9.3000 | 9.2000 | 9.5000 | 7630.0000 | 465000.00 | 426870.00 | 38130.00 | 500 | 13 | 4455 | 1083 | 4.11357340720222 | 0.0894347878847731 | 0.0894347878847731 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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 |
| 071ed6db-ef9a-49df-84fb-63f57aa3dac6 | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 11.7000 | 11.6000 | 11.9000 | 7645.3900 | 153270.00 | 85410.00 | 67860.00 | 131 | 16 | 3712 | 1083 | 3.4275161588181 | 0.0941367040399471 | 0.0941367040399471 | 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 |
| 0221ebce-aed5-4e53-8e55-cf1de122a24f | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 11.8000 | 11.7000 | 12.0000 | 7644.5500 | 106200.00 | 31860.00 | 74340.00 | 90 | 12 | 3579 | 1083 | 3.30470914127424 | 0.0936850862505849 | 0.0936850862505849 | 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 |
| 33a7cdeb-471a-4813-a4b4-cd0ce2967469 | 2026-09-18 15:46 | 2026-09-18 15:46 | 2026-09-18 15:46 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 12.1000 | 12.0000 | 12.3000 | 7643.8200 | 114950.00 | 81070.00 | 33880.00 | 95 | 10 | 3372 | 1083 | 3.11357340720222 | 0.0941044315181986 | 0.0941044315181986 | 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 |
| 125b431f-ef55-454a-a0d7-58d6ce15423b | 2026-09-18 14:43 | 2026-09-18 14:43 | 2026-09-18 14:43 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 14.8000 | 14.7000 | 15.1000 | 7634.2100 | 370000.00 | 251600.00 | 118400.00 | 250 | 16 | 3008 | 1083 | 2.77746999076639 | 0.0939708165152941 | 0.0939708165152941 | 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:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 10f69b4f-41bb-4b38-b7cb-9f124955d088 | 2026-09-18 14:29 | 2026-09-18 14:29 | 2026-09-18 14:29 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 15.0000 | 14.9000 | 15.2000 | 7634.3900 | 375000.00 | 303000.00 | 72000.00 | 250 | 17 | 2477 | 1083 | 2.28716528162512 | 0.09488004857328 | 0.09488004857328 | 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-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 2c080c74-e7a4-4c31-aac0-d9383f68310f | 2026-09-18 14:23 | 2026-09-18 14:23 | 2026-09-18 14:23 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 15.4000 | 15.2000 | 15.5000 | 7634.9000 | 154000.00 | 137060.00 | 16940.00 | 100 | 10 | 1761 | 1083 | 1.62603878116343 | 0.0968613760365217 | 0.0968613760365217 | 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-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| d4ce755a-55ec-453d-a928-a72a30921815 | 2026-09-18 14:22 | 2026-09-18 14:22 | 2026-09-18 14:22 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 15.2000 | 15.1000 | 15.4000 | 7634.1300 | 228000.00 | 193040.00 | 34960.00 | 150 | 9 | 1539 | 1083 | 1.42105263157895 | 0.0953060271117061 | 0.0953060271117061 | 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-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 11ea0847-43c8-4101-a278-62a2cf8f5552 | 2026-09-18 13:34 | 2026-09-18 13:34 | 2026-09-18 13:34 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 18.7100 | 18.6000 | 19.0000 | 7623.9800 | 280670.00 | 160820.00 | 119850.00 | 150 | 16 | 646 | 1083 | 0.596491228070175 | 0.0960327463182903 | 0.095697375799718 | 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-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| cb6d790b-4033-4984-803e-4fe003881eef | 2026-09-18 13:11 | 2026-09-18 13:11 | 2026-09-18 13:11 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 20.0000 | 19.8000 | 20.1000 | 7622.7800 | 100000.00 | 100000.00 | 0.00 | 50 | 7 | 424 | 1083 | 0.391505078485688 | 0.0985832258347302 | 0.0985832258347302 | 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-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a3b18c15-03f0-465a-a04e-d85d960f5d86 | 2026-09-18 13:11 | 2026-09-18 13:11 | 2026-09-18 13:11 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 20.0000 | 19.8000 | 20.1000 | 7622.9600 | 100000.00 | 98000.00 | 2000.00 | 50 | 9 | 374 | 1083 | 0.34533702677747 | 0.0988033210637772 | 0.0988033210637772 | 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-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |