Simplify AnalyticsOptions 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2b09d170-f4d6-4cca-8a02-cb575480d820 | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | SWK | SWK261016C00087500 | call | 87.5000 | 2026-10-16 | 4.1600 | 4.2000 | 4.4000 | 89.3000 | 439108.00 | 0.00 | 439108.00 | 1055 | 18 | 1062 | 70 | 15.1714285714286 | 0.31350109223611 | 0.31350109223611 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13528070701.00 | 2026-11-03 | unknown | — | 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 |
| 6bc96757-7b63-489d-a4b7-1f9c624de112 | 2026-09-16 13:31 | 2026-09-16 13:31 | 2026-09-16 13:31 | SWK | SWK290119P00085000 | put | 85.0000 | 2029-01-19 | 14.6000 | 14.5000 | 15.1000 | 90.1450 | 144540.00 | 7300.00 | 135780.00 | 99 | 12 | 179 | 0 | 0 | 0.418200036726568 | 0.418200036726568 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13448031881.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 6e035a23-8a18-4a5a-9f33-17c0627af050 | 2026-09-16 13:31 | 2026-09-16 13:31 | 2026-09-16 13:31 | SWK | SWK290119P00085000 | put | 85.0000 | 2029-01-19 | 14.6000 | 14.6000 | 15.2000 | 90.0700 | 29200.00 | 0.00 | 29200.00 | 20 | 8 | 66 | 0 | 0 | 0.417747798985907 | 0.417747798985907 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13448031881.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| d8b7f7ff-a4fa-4beb-85d8-0d689aeb3fee | 2026-09-16 13:30 | 2026-09-16 13:30 | 2026-09-16 13:30 | SWK | SWK290119P00085000 | put | 85.0000 | 2029-01-19 | 14.6000 | 14.6000 | 15.2000 | 90.0700 | 59861.00 | 0.00 | 59861.00 | 41 | 18 | 46 | 0 | 0 | 0.417963018725287 | 0.417747798985907 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 13448031881.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| f1ba31f3-227d-4069-ab2c-71e4a099a3e0 | 2026-09-14 10:22 | 2026-09-14 10:22 | 2026-09-14 10:22 | SWK | SWK270219P00092500 | put | 92.5000 | 2027-02-19 | 10.2000 | 9.8000 | 11.6000 | 88.0000 | 15300.00 | 8160.00 | 7140.00 | 15 | 5 | 15 | 0 | 0 | 0.381860930468537 | 0.381860930468537 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bc2cfe70-fc44-40be-ae9f-6d3efeddbcef | 2026-09-11 10:59 | 2026-09-11 10:58 | 2026-09-11 10:58 | SWK | SWK270115C00095000 | call | 95.0000 | 2027-01-15 | 5.4000 | 5.4000 | 5.9000 | 89.9600 | 20520.00 | 0.00 | 20520.00 | 38 | 5 | 41 | 346 | 0.11849710982659 | 0.330618291275737 | 0.330618291275737 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4510111a-0815-4cd2-b2dd-9c6aaaba461f | 2026-09-10 15:02 | 2026-09-10 15:02 | 2026-09-10 15:02 | SWK | SWK261016C00085000 | call | 85.0000 | 2026-10-16 | 5.8000 | 4.9000 | 5.9000 | 88.0700 | 90480.00 | 45820.00 | 44660.00 | 156 | 15 | 337 | 459 | 0.734204793028322 | 0.36008642992368 | 0.358474250911505 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | 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 |
| d3a64768-909c-4f5c-95b4-383bed16990f | 2026-09-08 11:08 | 2026-09-08 11:08 | 2026-09-08 11:08 | SWK | SWK260918P00097500 | put | 97.5000 | 2026-09-18 | 3.9000 | 3.6000 | 4.2000 | 94.6650 | 105691.00 | 780.00 | 104911.00 | 271 | 58 | 737 | 1300 | 0.566923076923077 | 0.359112118342189 | 0.359112118342189 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e2647ea9-3d1b-41c7-8b17-04e6fd5abc9e | 2026-09-08 11:08 | 2026-09-08 11:07 | 2026-09-08 11:07 | SWK | SWK260918P00097500 | put | 97.5000 | 2026-09-18 | 4.1000 | 3.9000 | 4.1000 | 94.3400 | 186550.00 | 2460.00 | 0.00 | 455 | 39 | 458 | 1300 | 0.352307692307692 | 0.355052117351445 | 0.355052117351445 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7d3a0d65-04d0-46bd-915c-7e85281d5fc1 | 2026-09-04 12:17 | 2026-09-04 12:17 | 2026-09-04 12:17 | SWK | SWK270416C00100000 | call | 100.0000 | 2027-04-16 | 9.6000 | 9.0000 | 10.1000 | 97.7650 | 153597.00 | 95037.00 | 58560.00 | 160 | 16 | 160 | 47 | 3.40425531914894 | 0.311167262866441 | 0.311167262866441 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.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 |
| eba557f9-6f6f-4bb9-9e5a-931bd135ccbd | 2026-09-02 14:30 | 2026-09-02 14:30 | 2026-09-02 14:30 | SWK | SWK270416C00105000 | call | 105.0000 | 2027-04-16 | 7.9000 | 7.7000 | 7.9000 | 97.8993 | 14220.00 | 14220.00 | 0.00 | 18 | 8 | 20 | 10 | 2 | 0.317600279643949 | 0.317600279643949 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b6b7b1b6-49a3-406d-8ba0-839d69c13903 | 2026-08-25 15:19 | 2026-08-25 15:19 | 2026-08-25 15:19 | SWK | SWK270115C00100000 | call | 100.0000 | 2027-01-15 | 7.6000 | 7.5000 | 7.6000 | 98.0750 | 73720.00 | 73720.00 | 0.00 | 97 | 25 | 313 | 790 | 0.39620253164557 | 0.318039595785003 | 0.318039595785003 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2c92d092-65ab-44b2-9bb9-0a3cff34f9da | 2026-08-25 15:12 | 2026-08-25 15:12 | 2026-08-25 15:12 | SWK | SWK270115C00100000 | call | 100.0000 | 2027-01-15 | 7.6000 | 7.4000 | 7.6000 | 98.0450 | 21280.00 | 21280.00 | 0.00 | 28 | 9 | 207 | 790 | 0.262025316455696 | 0.318692889094043 | 0.318692889094043 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cf64ee77-72a8-4270-b009-2eaa98a08671 | 2026-08-24 12:25 | 2026-08-24 12:25 | 2026-08-24 12:25 | SWK | SWK260918P00097500 | put | 97.5000 | 2026-09-18 | 3.2000 | 3.2000 | 3.3000 | 98.5000 | 11520.00 | 0.00 | 11520.00 | 36 | 7 | 284 | 341 | 0.832844574780059 | 0.371411055055733 | 0.371411055055733 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:44:07.615841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 58258dce-15f1-47e6-8035-10bf76c454d6 | 2026-08-24 12:25 | 2026-08-24 12:24 | 2026-08-24 12:24 | SWK | SWK260918P00097500 | put | 97.5000 | 2026-09-18 | 3.1000 | 3.1000 | 3.2000 | 98.6900 | 26350.00 | 0.00 | 1550.00 | 85 | 61 | 150 | 341 | 0.439882697947214 | 0.369496461544148 | 0.369496461544148 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:44:07.615841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aa702639-4792-42e1-aa87-a0705f75dc5e | 2026-08-24 12:24 | 2026-08-24 12:24 | 2026-08-24 12:24 | SWK | SWK260918P00097500 | put | 97.5000 | 2026-09-18 | 3.0000 | 3.0000 | 3.1000 | 98.7100 | 19200.00 | 0.00 | 12000.00 | 64 | 15 | 65 | 341 | 0.190615835777126 | 0.360421479316351 | 0.360421479316351 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:44:07.615841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8d1fc368-e57f-457b-9150-0078bb673247 | 2026-08-20 11:48 | 2026-08-20 11:48 | 2026-08-20 11:48 | SWK | SWK260821C00095000 | call | 95.0000 | 2026-08-21 | 3.7500 | 3.1000 | 4.2000 | 98.2950 | 10867.00 | 6599.00 | 1428.00 | 29 | 13 | 50 | 357 | 0.140056022408964 | 0.882513798275025 | 0.545196379155753 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 417808fe-7806-4f43-b09e-813d3b4b842c | 2026-08-20 09:45 | 2026-08-20 09:45 | 2026-08-20 09:45 | SWK | SWK261016C00085000 | call | 85.0000 | 2026-10-16 | 14.0000 | 13.2000 | 14.3000 | 97.9450 | 406000.00 | 406000.00 | 0.00 | 290 | 26 | 326 | 166 | 1.96385542168675 | 0.300174453943619 | 0.300174453943619 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 90cb5a30-ce87-4e13-911a-287e2c1797b6 | 2026-08-17 11:49 | 2026-08-17 11:49 | 2026-08-17 11:49 | SWK | SWK261016P00097500 | put | 97.5000 | 2026-10-16 | 4.2000 | 4.2000 | 4.4000 | 99.9300 | 11340.00 | 0.00 | 11340.00 | 27 | 7 | 27 | 60 | 0.45 | 0.351404480603035 | 0.351404480603035 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f03c2ba3-9b98-4417-88c2-fe671600f1e4 | 2026-08-17 11:18 | 2026-08-17 11:18 | 2026-08-17 11:18 | SWK | SWK270115P00095000 | put | 95.0000 | 2027-01-15 | 6.6000 | 6.6000 | 6.8000 | 99.7100 | 21780.00 | 0.00 | 21780.00 | 33 | 11 | 33 | 41 | 0.804878048780488 | 0.380642937313332 | 0.380201635025162 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 13423869218.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |