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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33d03db8-86f9-4a0c-abc8-5a89d1a8a695 | 2026-09-18 09:30 | 2026-09-18 09:30 | 2026-09-18 09:30 | XOP | XOP261120P00185000 | put | 185.0000 | 2026-11-20 | 6.5000 | 6.5000 | 8.7500 | 192.7900 | 64365.00 | 0.00 | 64365.00 | 99 | 5 | 256 | 3 | 85.3333333333333 | 0.33480147173639 | 0.334460040423235 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4169358708.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:31:27.885359Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 5ea0c43e-8090-4a5c-8bdf-bfbc36637aea | 2026-09-17 15:43 | 2026-09-17 15:43 | 2026-09-17 15:43 | XOP | XOP261016C00210000 | call | 210.0000 | 2026-10-16 | 1.7100 | 1.6900 | 1.7200 | 192.5500 | 12678.00 | 9788.00 | 2890.00 | 74 | 11 | 354 | 1749 | 0.202401372212693 | 0.319337224814777 | 0.319337224814777 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4265140147.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 2a7e8090-aa97-41d0-a719-3b380f2ed9b3 | 2026-09-17 14:55 | 2026-09-17 14:55 | 2026-09-17 14:55 | XOP | XOP261016P00190000 | put | 190.0000 | 2026-10-16 | 6.2000 | 6.0500 | 6.2000 | 192.5950 | 309997.00 | 309997.00 | 0.00 | 500 | 51 | 817 | 5150 | 0.158640776699029 | 0.358236257746621 | 0.358236257746621 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4265140147.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| b7fde79c-982e-45ba-a9f6-18bac7753291 | 2026-09-17 12:17 | 2026-09-17 12:17 | 2026-09-17 12:17 | XOP | XOP261218P00174000 | put | 174.0000 | 2026-12-18 | 5.3500 | 4.9000 | 5.4500 | 191.9800 | 103209.00 | 85034.00 | 18175.00 | 193 | 9 | 399 | 44 | 9.06818181818182 | 0.354988006322807 | 0.354988006322807 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4265140147.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 89bc1ad6-d42a-40d2-9764-07817162ce49 | 2026-09-17 10:17 | 2026-09-17 10:17 | 2026-09-17 10:17 | XOP | XOP261016P00186000 | put | 186.0000 | 2026-10-16 | 5.5000 | 4.9500 | 5.5000 | 190.7800 | 549935.00 | 549935.00 | 0.00 | 1000 | 51 | 1000 | 61 | 16.3934426229508 | 0.373396967802564 | 0.373396967802564 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4265140147.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| ca0bf781-2401-48da-949b-2ec8c7aedb50 | 2026-09-15 15:29 | 2026-09-15 15:29 | 2026-09-15 15:29 | XOP | XOP270115C00200000 | call | 200.0000 | 2027-01-15 | 15.5100 | 15.4000 | 15.8000 | 199.2900 | 23262.00 | 0.00 | 23262.00 | 15 | 5 | 39 | 1995 | 0.0195488721804511 | 0.31763885788652 | 0.31763885788652 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| f717bf36-af99-44a3-bc96-90139267bacc | 2026-09-15 09:49 | 2026-09-15 09:49 | 2026-09-15 09:49 | XOP | XOP261218P00175000 | put | 175.0000 | 2026-12-18 | 4.5500 | 4.0500 | 4.5500 | 197.3500 | 45536.00 | 45536.00 | 0.00 | 100 | 7 | 301 | 590 | 0.510169491525424 | 0.356249055834554 | 0.355551086325828 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 0a8fc6d7-1e59-47c7-b65a-d3ed4e419798 | 2026-09-14 09:35 | 2026-09-14 09:35 | 2026-09-14 09:35 | XOP | XOP270319C00210000 | call | 210.0000 | 2027-03-19 | 14.5700 | 14.1000 | 15.0000 | 198.4700 | 14572.00 | 14572.00 | 0.00 | 10 | 6 | 30 | 147 | 0.204081632653061 | 0.316670158307683 | 0.316670158307683 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4238179533.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8e76b9a9-d75b-4edd-bfca-36767840b19b | 2026-09-09 15:13 | 2026-09-09 15:13 | 2026-09-09 15:13 | XOP | XOP261120P00170000 | put | 170.0000 | 2026-11-20 | 2.5900 | 2.5300 | 2.6000 | 195.0100 | 15519.00 | 4135.00 | 0.00 | 60 | 11 | 2254 | 22 | 102.454545454545 | 0.346627140591497 | 0.346140446175939 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4238179533.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b86ea243-146b-43f4-b283-d4f5e93b2cb2 | 2026-09-08 11:32 | 2026-09-08 11:31 | 2026-09-08 11:31 | XOP | XOP260918P00194000 | put | 194.0000 | 2026-09-18 | 3.9000 | 3.5000 | 3.9000 | 194.2100 | 59260.00 | 59260.00 | 0.00 | 152 | 34 | 153 | 5 | 30.6 | 0.320267257255316 | 0.320267257255316 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:43:32.720264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fc1b97b6-ef4b-4f64-a9f2-5e63fa7102a9 | 2026-09-08 11:22 | 2026-09-08 11:22 | 2026-09-08 11:22 | XOP | XOP260918C00195000 | call | 195.0000 | 2026-09-18 | 4.0000 | 3.7500 | 4.0500 | 194.8399 | 252780.00 | 250780.00 | 2000.00 | 632 | 27 | 664 | 952 | 0.697478991596639 | 0.312491215109965 | 0.309320058891583 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a2002265-2cc6-4173-948d-a4b51e770fde | 2026-09-08 11:06 | 2026-09-08 11:05 | 2026-09-08 11:05 | XOP | XOP260918C00196000 | call | 196.0000 | 2026-09-18 | 3.4500 | 3.1000 | 3.4500 | 194.4874 | 61050.00 | 61050.00 | 0.00 | 177 | 37 | 187 | 406 | 0.460591133004926 | 0.315974831685745 | 0.315974831685745 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | 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 |
| cc605c86-be39-4b3c-a5af-7124112f1ac2 | 2026-09-01 13:24 | 2026-09-01 13:24 | 2026-09-01 13:24 | XOP | XOP270319P00195000 | put | 195.0000 | 2027-03-19 | 18.8900 | 18.4000 | 18.9000 | 191.6900 | 18890.00 | 18890.00 | 0.00 | 10 | 6 | 61 | 71 | 0.859154929577465 | 0.345938370699627 | 0.345042956756702 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T17:48:11.364966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 07777f5c-10b0-46ce-8682-b3c2b0d531d5 | 2026-08-31 14:42 | 2026-08-31 14:42 | 2026-08-31 14:42 | XOP | XOP260904C00187500 | call | 187.5000 | 2026-09-04 | 2.2300 | 2.2300 | 2.7300 | 186.7700 | 39255.00 | 0.00 | 39255.00 | 176 | 18 | 543 | 22 | 24.6818181818182 | 0.326666564007027 | 0.325379901781855 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5d7e7934-1375-4cf0-a9ca-264922053fd5 | 2026-08-31 10:03 | 2026-08-31 10:03 | 2026-08-31 10:03 | XOP | XOP281215P00121000 | put | 121.0000 | 2028-12-15 | 6.6800 | 4.8500 | 6.7000 | 188.6400 | 26725.00 | 24760.00 | 1965.00 | 40 | 7 | 40 | 0 | 0 | 0.356949413403308 | 0.355041436842194 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a9b02a4c-ae53-42ad-b16a-849ea9aada19 | 2026-08-27 09:38 | 2026-08-27 09:38 | 2026-08-27 09:38 | XOP | XOP260904P00176000 | put | 176.0000 | 2026-09-04 | 0.8700 | 0.7500 | 1.5000 | 184.4600 | 126717.00 | 0.00 | 126717.00 | 1463 | 14 | 1463 | 2631 | 0.556062333713417 | 0.351484449693466 | 0.351484449693466 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T13:49:05.616113Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e3ea71a4-c4e1-43ad-9eeb-127b1447769e | 2026-08-25 15:57 | 2026-08-25 15:57 | 2026-08-25 15:57 | XOP | XOP260904P00175000 | put | 175.0000 | 2026-09-04 | 1.3500 | 1.1500 | 1.4700 | 183.1600 | 674788.00 | 106885.00 | 33978.00 | 5007 | 37 | 6088 | 34 | 179.058823529412 | 0.363214403354591 | 0.356313093298098 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9224a854-f7c3-45b3-a1f6-733f45724221 | 2026-08-25 11:43 | 2026-08-25 11:43 | 2026-08-25 11:43 | XOP | XOP260904P00183000 | put | 183.0000 | 2026-09-04 | 3.8500 | 3.0000 | 3.8500 | 183.4000 | 43868.00 | 43868.00 | 0.00 | 114 | 17 | 116 | 0 | 0 | 0.342305091687459 | 0.342305091687459 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9a5e4542-568c-4980-8639-924af28f69b8 | 2026-08-20 13:16 | 2026-08-20 13:15 | 2026-08-20 13:15 | XOP | XOP281215P00170000 | put | 170.0000 | 2028-12-15 | 21.8900 | 19.5500 | 21.9000 | 187.5700 | 45975.00 | 43795.00 | 2180.00 | 21 | 5 | 21 | 2004 | 0.0104790419161677 | 0.353255768101993 | 0.352114110197892 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fd09e2da-c5d9-4163-9554-2376fe815063 | 2026-08-19 10:54 | 2026-08-19 10:53 | 2026-08-19 10:53 | XOP | XOP261016P00185000 | put | 185.0000 | 2026-10-16 | 8.4800 | 8.3500 | 8.8500 | 186.8650 | 15260.00 | 4235.00 | 11025.00 | 18 | 5 | 32 | 18 | 1.77777777777778 | 0.336793784907049 | 0.335081511134913 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 532599bb-bdf9-43d7-ba16-0c3c91af7a01 | 2026-08-18 10:25 | 2026-08-18 10:25 | 2026-08-18 10:25 | XOP | XOP260918C00190000 | call | 190.0000 | 2026-09-18 | 4.6500 | 3.9500 | 4.7000 | 184.3600 | 28810.00 | 28360.00 | 450.00 | 62 | 7 | 125 | 3363 | 0.0371691941718704 | 0.316426606800409 | 0.318829910934915 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4f5e5e4e-137b-43c3-95fe-52762f959c7b | 2026-08-17 12:55 | 2026-08-17 12:55 | 2026-08-17 12:55 | XOP | XOP260925P00159000 | put | 159.0000 | 2026-09-25 | 0.9500 | 0.7100 | 2.7900 | 181.7900 | 17398.00 | 8924.00 | 8474.00 | 183 | 9 | 184 | 73 | 2.52054794520548 | 0.340078052891443 | 0.340078052891443 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 33d9c393-7224-4d70-a85a-26704e527ee1 | 2026-08-17 12:55 | 2026-08-17 12:55 | 2026-08-17 12:55 | XOP | XOP260925P00161000 | put | 161.0000 | 2026-09-25 | 1.1600 | 0.8500 | 1.8000 | 181.7900 | 10790.00 | 5500.00 | 5290.00 | 93 | 5 | 94 | 1 | 94 | 0.335977039360791 | 0.334242471333937 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4170340047.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |