Simplify Analytics
← Data Explorer

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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

created_at (ET days)to
column equals (exact text)
sort
chart against created_at
reset
active:er_time = unknown×sector = Consumer Defensive×ticker = HRL×
iduuidcreated_attimestamp with time zonestart_timetimestamp with time zoneend_timetimestamp with time zonetickertextoption_symboltextoption_typetextstrikenumericexpirydatepricenumericbidnumericasknumericunderlying_pricenumerictotal_premiumnumerictotal_ask_side_premnumerictotal_bid_side_premnumerictotal_sizebiginttrade_countintegervolumebigintopen_interestbigintvolume_oi_rationumericiv_startnumericiv_endnumerichas_sweepbooleanhas_floorbooleanhas_multilegbooleanhas_singlelegbooleanall_opening_tradesbooleanalert_ruletextrule_iduuidexpiry_countintegerissue_typetextsectortextmarketcapnumericnext_earnings_datedateer_timetextmissing_periscopebooleansourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
239b89f4-4da6-4bf4-bdd1-d118d3db9d252026-09-18 15:312026-09-18 15:302026-09-18 15:30HRLHRL261218P00021000put21.00002026-12-181.11001.10001.150020.930068709.000.0068709.006191610002533.952569169960470.2851637356978030.285163735697803falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11463807164.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"}2026-09-182026-09-18 21:152026-09-18 21:15
c991fb4b-55d9-40ce-8a10-aa15e3721efd2026-09-18 15:262026-09-18 15:262026-09-18 15:26HRLHRL261218P00021000put21.00002026-12-181.11001.10001.150020.935010878.000.0010878.009863812531.505928853754940.2857088492891150.285708849289115falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11463807164.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"}2026-09-182026-09-18 21:152026-09-18 21:15
01d4e52d-38c9-47b8-9f21-e2c3352642512026-09-18 15:252026-09-18 15:252026-09-18 15:25HRLHRL261218P00021000put21.00002026-12-181.13001.15001.150020.925013560.000.0013560.0012062032530.8023715415019760.2894508399334670.289450839933467falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11463807164.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"}2026-09-182026-09-18 21:152026-09-18 21:15
11a2d201-597c-4d59-b853-f76b868edc542026-09-14 14:592026-09-14 14:592026-09-14 14:59HRLHRL261009P00021000put21.00002026-10-090.55000.45000.600021.015011165.0010780.00385.00203514036542.145259938837920.2671430851921350.267143085192135falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"}2026-09-152026-09-15 08:452026-09-15 08:45
ffd5392a-7b7f-470d-8a21-d6b61608bad22026-09-10 14:432026-09-10 14:432026-09-10 14:43HRLHRL270115C00020000call20.00002027-01-151.95001.30001.950020.7850107250.00107250.000.0055055506250.880.2842987883959570.284298788395957falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"}2026-09-152026-09-15 08:452026-09-15 08:45
06a0115a-e39f-4756-92a5-78af88e3e8832026-09-09 10:142026-09-09 10:142026-09-09 10:14HRLHRL261009P00022000put22.00002026-10-091.10001.10001.450021.220044241.000.0044241.00402155022232.251121076233180.2783314637282110.278331463728211truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"}2026-09-152026-09-15 08:452026-09-15 08:45
af830787-5747-457e-9a88-4cc69e9acde92026-09-04 11:272026-09-04 11:272026-09-04 11:27HRLHRL261009P00023000put23.00002026-10-091.40001.25001.400021.865014420.0014420.000.0010361036410.1606864274570980.2749621453513380.274962145351338falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-04T15:46:11.944585Z"}2026-09-152026-09-15 08:452026-09-15 08:45
323d50c0-dc0b-4f14-b7f5-bebc29f8d4be2026-09-03 10:222026-09-03 10:222026-09-03 10:22HRLHRL270115P00022000put22.00002027-01-151.50001.15001.550021.770027900.008400.0019500.0018651865760.3229166666666670.294589298505010.29458929850501falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"}2026-09-152026-09-15 08:452026-09-15 08:45
b9c4e552-4ae5-4b65-b470-513c1ea33caf2026-08-28 14:562026-08-28 14:562026-08-28 14:56HRLHRL270115P00021000put21.00002027-01-151.20001.20001.300021.415010322.000.0010322.0086242683470.7723342939481270.296062558128850.29606255812885falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-28T19:10:32.565799Z"}2026-09-152026-09-15 08:452026-09-15 08:45
498cccd4-b19d-4cd8-81f9-ece0a7000bc32026-08-28 14:492026-08-28 14:492026-08-28 14:49HRLHRL270115P00021000put21.00002027-01-151.20001.20001.300021.405010800.000.0010800.0090131823470.5244956772334290.2952961627648460.295296162764846falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-28T19:10:32.565799Z"}2026-09-152026-09-15 08:452026-09-15 08:45
65d374b2-9fbc-4e2c-9d9c-a5b831e8a5412026-08-28 11:092026-08-28 11:092026-08-28 11:09HRLHRL270115P00021000put21.00002027-01-151.20001.20001.350021.420010800.000.0010800.009012913470.2622478386167150.2964451572652090.296445157265209falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"}2026-09-152026-09-15 08:452026-09-15 08:45
49888fae-df33-451b-87aa-8faac213495a2026-08-27 14:592026-08-27 14:592026-08-27 14:59HRLHRL260828P00024000put24.00002026-08-282.55002.35002.550021.5000248370.00248370.000.00974212376491.90600924499231.423556967384061.42355696738406falsetruetruefalsetrueFloorTradeLargeCap85cc2f90-fef8-4e3c-8c5c-01d1ead51af12Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"}2026-09-152026-09-15 08:452026-09-15 08:45
9b08ff78-8f41-4c77-9be7-0e226452625c2026-08-27 12:582026-08-27 12:582026-08-27 12:58HRLHRL270115P00022000put22.00002027-01-151.70001.70001.800021.520014790.000.0014790.00879175852.058823529411760.303962999504120.30396299950412truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"}2026-09-152026-09-15 08:452026-09-15 08:45
5de9b655-3d2d-4828-b01f-fcf0bc1f939b2026-08-27 12:332026-08-27 12:332026-08-27 12:33HRLHRL270115P00021000put21.00002027-01-151.20001.20001.300021.530010440.000.0010440.00878204494.163265306122450.3038801055213910.303880105521391truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"}2026-09-152026-09-15 08:452026-09-15 08:45
f95bd304-32c7-4e80-81f0-967a8b9f83702026-08-27 12:132026-08-27 12:122026-08-27 12:12HRLHRL260828P00023500put23.50002026-08-281.90001.90002.000021.560019000.000.0019000.001008133416420.8124238733252131.237566218352611.23756621835261falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"}2026-09-152026-09-15 08:452026-09-15 08:45
7bb1fbdc-ec9f-4009-a2ef-6b02e528a6cb2026-08-27 12:122026-08-27 12:122026-08-27 12:12HRLHRL260828P00023500put23.50002026-08-281.91001.90002.050021.550019127.000.0019127.0010014123416420.7515225334957371.408006074578671.42635064053623falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"}2026-09-152026-09-15 08:452026-09-15 08:45
61b6f68f-c44f-4841-9290-d739d0fdd2b82026-08-27 11:282026-08-27 11:282026-08-27 11:28HRLHRL270115P00022000put22.00002027-01-151.65001.65001.850021.670014025.000.0014025.0085987851.023529411764710.3077802185733410.307780218573341truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"}2026-09-152026-09-15 08:452026-09-15 08:45
45d1edb2-c938-4bc1-8399-91500dff7ae52026-08-27 11:192026-08-27 11:192026-08-27 11:19HRLHRL260828P00021000put21.00002026-08-280.15000.05000.150021.505014999.0014999.000.0010003730254567.22222222222220.7944564755471740.779938845685286falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"}2026-09-152026-09-15 08:452026-09-15 08:45
c4ccbbc6-7793-4eda-b777-f5b161b4f5512026-08-27 11:182026-08-27 11:182026-08-27 11:18HRLHRL260828P00021000put21.00002026-08-280.15000.05000.150021.525014935.0014935.000.00100054202545450.8088558265676910.767373217310682falsefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"}2026-09-152026-09-15 08:452026-09-15 08:45
0844301b-ccf9-4601-b963-85cdbea24efb2026-08-27 10:192026-08-27 10:192026-08-27 10:19HRLHRL270115P00021000put21.00002027-01-151.25001.25001.350021.525010500.000.0010500.00841192491.877551020408160.3133188337666690.313318833766669truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"}2026-09-152026-09-15 08:452026-09-15 08:45
e9c50113-8f9b-44b0-846d-d062e62168192026-08-27 10:062026-08-27 10:062026-08-27 10:06HRLHRL260828P00024000put24.00002026-08-282.35002.20003.000021.610047000.008460.007050.0020062436490.374422187981510.5194987793358633.19156648404728falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"}2026-09-152026-09-15 08:452026-09-15 08:45
a0f8a3e0-547b-43e4-9637-ff8cc8a4b7282026-08-27 10:042026-08-27 10:042026-08-27 10:04HRLHRL260828P00021000put21.00002026-08-280.15000.10000.200021.615013938.0013923.000.00932509364520.80.8792242760044090.858383750795025falsefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"}2026-09-152026-09-15 08:452026-09-15 08:45
e73f5a71-3f4d-42a1-97c7-e2eacd7623b32026-08-27 10:022026-08-27 10:022026-08-27 10:02HRLHRL260828P00021500put21.50002026-08-280.25000.20000.250021.655014774.008049.000.00591267771505.180.7483902397500060.715911749774136truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"}2026-09-152026-09-15 08:452026-09-15 08:45
f5d3c2a5-7c43-4737-8772-e04c56e48ae62026-08-26 15:452026-08-26 15:452026-08-26 15:45HRLHRL260828P00022000put22.00002026-08-280.15000.10000.150023.745014925.0014925.000.0099527172810915.85321100917431.051849772841931.04451058148451falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"}2026-09-152026-09-15 08:452026-09-15 08:45
93b3b857-8d7b-4a01-b32c-69a8b60f25542026-08-26 14:022026-08-26 14:022026-08-26 14:02HRLHRL260918C00025000call25.00002026-09-180.30000.30000.400023.814043530.000.0043530.0014518163150870.3206211912718690.2986996811197810.298699681119781falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"}2026-09-152026-09-15 08:452026-09-15 08:45
a245e3ef-6d53-4cc0-a400-946781af39082026-08-24 14:462026-08-24 14:462026-08-24 14:46HRLHRL260918C00022000call22.00002026-09-182.25002.15002.350024.030071325.0011250.0056250.003171331713110.2418001525553010.3395958695444230.339595869544423falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"}2026-09-152026-09-15 08:452026-09-15 08:45
2221e18b-39c7-4f89-8956-3a64158e673b2026-08-18 09:502026-08-18 09:502026-08-18 09:50HRLHRL280121C00030000call30.00002028-01-211.55001.20001.600024.000020305.007750.0012555.001311613114530.09015829318651070.2484724958032720.248472495803272falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive11535352768.002026-12-03unknowntrueuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"}2026-09-152026-09-15 08:452026-09-15 08:45