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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2b52ec46-3f6e-4291-8aa7-4659090e3396 | 2026-09-18 14:21 | 2026-09-18 14:21 | 2026-09-18 14:21 | FDS | FDS261120P00240000 | put | 240.0000 | 2026-11-20 | 6.6000 | 6.6000 | 7.9000 | 283.5275 | 36300.00 | 0.00 | 36300.00 | 55 | 17 | 56 | 3 | 18.6666666666667 | 0.516228440719859 | 0.516228440719859 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 10094568070.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e178e31a-5573-4429-9f3f-8ca3f8a3f6de | 2026-09-18 11:10 | 2026-09-18 11:09 | 2026-09-18 11:09 | FDS | FDS261016P00230000 | put | 230.0000 | 2026-10-16 | 1.9000 | 1.9000 | 2.7500 | 284.5650 | 11590.00 | 0.00 | 11590.00 | 61 | 20 | 61 | 49 | 1.24489795918367 | 0.597140682526428 | 0.597140682526428 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 10094568070.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 04911f1c-b58b-4413-9220-1c7fd3511d50 | 2026-09-17 12:38 | 2026-09-17 12:38 | 2026-09-17 12:38 | FDS | FDS261218C00320000 | call | 320.0000 | 2026-12-18 | 12.7500 | 9.6000 | 12.8000 | 279.4700 | 63750.00 | 63750.00 | 0.00 | 50 | 5 | 50 | 12 | 4.16666666666667 | 0.460737791527548 | 0.460737791527548 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9917451666.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 01d81f26-2c86-4efa-8145-120030154959 | 2026-09-15 11:12 | 2026-09-15 11:12 | 2026-09-15 11:12 | FDS | FDS261016C00300000 | call | 300.0000 | 2026-10-16 | 10.8000 | 9.9000 | 10.8000 | 280.0200 | 55080.00 | 55080.00 | 0.00 | 51 | 16 | 53 | 86 | 0.616279069767442 | 0.558550117764216 | 0.558550117764216 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 14f017df-dc2a-48fb-beb1-ff167b5625ff | 2026-09-14 11:02 | 2026-09-14 11:01 | 2026-09-14 11:01 | FDS | FDS270219P00240000 | put | 240.0000 | 2027-02-19 | 16.6000 | 15.3000 | 17.7000 | 281.4550 | 14940.00 | 11620.00 | 3320.00 | 9 | 8 | 9 | 11 | 0.818181818181818 | 0.51290198501443 | 0.51290198501443 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 54c9ecec-48e8-439a-80db-7b23a6d2f1a9 | 2026-09-14 10:53 | 2026-09-14 10:53 | 2026-09-14 10:53 | FDS | FDS270115C00310000 | call | 310.0000 | 2027-01-15 | 22.4000 | 20.5000 | 22.4000 | 281.3699 | 80640.00 | 80640.00 | 0.00 | 36 | 15 | 37 | 16 | 2.3125 | 0.492471168965863 | 0.492471168965863 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d0e12ff5-613f-4cb6-96bd-6a6651f39b02 | 2026-09-10 15:45 | 2026-09-10 15:45 | 2026-09-10 15:45 | FDS | FDS261016C00300000 | call | 300.0000 | 2026-10-16 | 6.3500 | 5.3000 | 7.2000 | 264.7350 | 15240.00 | 12090.00 | 0.00 | 24 | 6 | 61 | 56 | 1.08928571428571 | 0.527586658948725 | 0.531300244962806 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e390220d-e87d-44be-b054-6c2af98dcbbb | 2026-09-10 15:35 | 2026-09-10 15:35 | 2026-09-10 15:35 | FDS | FDS260918P00260000 | put | 260.0000 | 2026-09-18 | 6.0000 | 6.0000 | 6.7000 | 265.1600 | 16200.00 | 0.00 | 16200.00 | 27 | 6 | 397 | 17 | 23.3529411764706 | 0.543099320989279 | 0.543099320989279 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| adb6a9e8-3381-4185-9812-c61375c7c15c | 2026-09-10 15:34 | 2026-09-10 15:34 | 2026-09-10 15:34 | FDS | FDS260918P00260000 | put | 260.0000 | 2026-09-18 | 5.8000 | 5.8000 | 6.5000 | 265.4800 | 13340.00 | 0.00 | 13340.00 | 23 | 6 | 346 | 17 | 20.3529411764706 | 0.537875645931205 | 0.537875645931205 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8f071d7e-61af-4297-aac3-f8e68198a96f | 2026-09-10 15:33 | 2026-09-10 15:33 | 2026-09-10 15:33 | FDS | FDS260918P00260000 | put | 260.0000 | 2026-09-18 | 5.7000 | 5.7000 | 6.7000 | 264.9100 | 15390.00 | 0.00 | 15390.00 | 27 | 11 | 271 | 17 | 15.9411764705882 | 0.516677359464328 | 0.516677359464328 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e0ee0f11-9beb-4507-a9d8-a5fef9b26076 | 2026-09-10 15:31 | 2026-09-10 15:31 | 2026-09-10 15:31 | FDS | FDS260918P00270000 | put | 270.0000 | 2026-09-18 | 11.2000 | 9.7000 | 12.2000 | 264.5600 | 32470.00 | 31360.00 | 1110.00 | 29 | 12 | 366 | 141 | 2.59574468085106 | 0.528331465419793 | 0.528331465419793 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bd29f17b-d8c7-4bf0-8616-0854cee5320b | 2026-09-10 14:50 | 2026-09-10 14:50 | 2026-09-10 14:50 | FDS | FDS260918P00270000 | put | 270.0000 | 2026-09-18 | 8.9000 | 8.9000 | 9.7000 | 268.1500 | 45390.00 | 0.00 | 45390.00 | 51 | 5 | 328 | 141 | 2.32624113475177 | 0.507606577216805 | 0.507606577216805 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1ded41f2-db1f-47c1-ab59-5aae6292b7bb | 2026-09-10 14:50 | 2026-09-10 14:50 | 2026-09-10 14:50 | FDS | FDS260918P00270000 | put | 270.0000 | 2026-09-18 | 8.8000 | 8.8000 | 9.1000 | 268.5400 | 48400.00 | 0.00 | 48400.00 | 55 | 5 | 272 | 141 | 1.9290780141844 | 0.513922883320922 | 0.513922883320922 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 49a9b936-86f5-4d31-8295-3a213bcf0e5e | 2026-09-03 12:03 | 2026-09-03 12:03 | 2026-09-03 12:03 | FDS | FDS261016P00250000 | put | 250.0000 | 2026-10-16 | 3.0000 | 2.6000 | 3.3000 | 310.7800 | 14100.00 | 300.00 | 13800.00 | 47 | 9 | 879 | 3380 | 0.260059171597633 | 0.545903743025889 | 0.545903743025889 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d46da7e3-f522-4a19-acda-2408402141ef | 2026-09-02 15:17 | 2026-09-02 15:17 | 2026-09-02 15:17 | FDS | FDS261016P00300000 | put | 300.0000 | 2026-10-16 | 16.4000 | 16.3000 | 16.8000 | 307.7400 | 13120.00 | 1640.00 | 11480.00 | 8 | 5 | 248 | 68 | 3.64705882352941 | 0.49239841150502 | 0.49239841150502 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cf70c8ef-0728-4cf2-9760-7cc5eb66a80e | 2026-09-02 13:42 | 2026-09-02 13:42 | 2026-09-02 13:42 | FDS | FDS270319P00290000 | put | 290.0000 | 2027-03-19 | 31.4000 | 30.1000 | 31.5000 | 306.1500 | 65940.00 | 62800.00 | 3140.00 | 21 | 7 | 26 | 1 | 26 | 0.484764497084126 | 0.484764497084126 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 721c3c83-3bdd-46f3-b03b-0b1a5ca967f4 | 2026-08-31 11:41 | 2026-08-31 11:41 | 2026-08-31 11:41 | FDS | FDS270319C00300000 | call | 300.0000 | 2027-03-19 | 48.0000 | 47.3000 | 50.3000 | 309.1950 | 24000.00 | 0.00 | 24000.00 | 5 | 5 | 5 | 13 | 0.384615384615385 | 0.4463909216728 | 0.4463909216728 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 67860d7a-03ba-4265-938e-0e7f809972ef | 2026-08-21 13:40 | 2026-08-21 13:39 | 2026-08-21 13:39 | FDS | FDS260918C00310000 | call | 310.0000 | 2026-09-18 | 9.4000 | 9.4000 | 9.8000 | 298.4099 | 37600.00 | 0.00 | 37600.00 | 40 | 8 | 50 | 79 | 0.632911392405063 | 0.420509629816485 | 0.420509629816485 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 9849165823.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |