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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = HRL×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

239b89f4-4da6-4bf4-bdd1-d118d3db9d25	2026-09-18 15:31	2026-09-18 15:30	2026-09-18 15:30	HRL	HRL261218P00021000	put	21.0000	2026-12-18	1.1100	1.1000	1.1500	20.9300	68709.00	0.00	68709.00	619	16	1000	253	3.95256916996047	0.285163735697803	0.285163735697803	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	11463807164.00	2026-12-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
c991fb4b-55d9-40ce-8a10-aa15e3721efd	2026-09-18 15:26	2026-09-18 15:26	2026-09-18 15:26	HRL	HRL261218P00021000	put	21.0000	2026-12-18	1.1100	1.1000	1.1500	20.9350	10878.00	0.00	10878.00	98	6	381	253	1.50592885375494	0.285708849289115	0.285708849289115	false	false	false	true
01d4e52d-38c9-47b8-9f21-e2c335264251	2026-09-18 15:25	2026-09-18 15:25	2026-09-18 15:25	HRL	HRL261218P00021000	put	21.0000	2026-12-18	1.1300	1.1500	1.1500	20.9250	13560.00	0.00	13560.00	120	6	203	253	0.802371541501976	0.289450839933467	0.289450839933467	false	false	false	true
11a2d201-597c-4d59-b853-f76b868edc54	2026-09-14 14:59	2026-09-14 14:59	2026-09-14 14:59	HRL	HRL261009P00021000	put	21.0000	2026-10-09	0.5500	0.4500	0.6000	21.0150	11165.00	10780.00	385.00	203	5	1403	654	2.14525993883792	0.267143085192135	0.267143085192135	false	false	false	true
ffd5392a-7b7f-470d-8a21-d6b61608bad2	2026-09-10 14:43	2026-09-10 14:43	2026-09-10 14:43	HRL	HRL270115C00020000	call	20.0000	2027-01-15	1.9500	1.3000	1.9500	20.7850	107250.00	107250.00	0.00	550	5	550	625	0.88	0.284298788395957	0.284298788395957	false	false	false	true
06a0115a-e39f-4756-92a5-78af88e3e883	2026-09-09 10:14	2026-09-09 10:14	2026-09-09 10:14	HRL	HRL261009P00022000	put	22.0000	2026-10-09	1.1000	1.1000	1.4500	21.2200	44241.00	0.00	44241.00	402	15	502	223	2.25112107623318	0.278331463728211	0.278331463728211	true	false	false	true
af830787-5747-457e-9a88-4cc69e9acde9	2026-09-04 11:27	2026-09-04 11:27	2026-09-04 11:27	HRL	HRL261009P00023000	put	23.0000	2026-10-09	1.4000	1.2500	1.4000	21.8650	14420.00	14420.00	0.00	103	6	103	641	0.160686427457098	0.274962145351338	0.274962145351338	false	false	false	true
323d50c0-dc0b-4f14-b7f5-bebc29f8d4be	2026-09-03 10:22	2026-09-03 10:22	2026-09-03 10:22	HRL	HRL270115P00022000	put	22.0000	2027-01-15	1.5000	1.1500	1.5500	21.7700	27900.00	8400.00	19500.00	186	5	186	576	0.322916666666667	0.29458929850501	0.29458929850501	false	false	false	true
b9c4e552-4ae5-4b65-b470-513c1ea33caf	2026-08-28 14:56	2026-08-28 14:56	2026-08-28 14:56	HRL	HRL270115P00021000	put	21.0000	2027-01-15	1.2000	1.2000	1.3000	21.4150	10322.00	0.00	10322.00	86	24	268	347	0.772334293948127	0.29606255812885	0.29606255812885	false	false	false	true
498cccd4-b19d-4cd8-81f9-ece0a7000bc3	2026-08-28 14:49	2026-08-28 14:49	2026-08-28 14:49	HRL	HRL270115P00021000	put	21.0000	2027-01-15	1.2000	1.2000	1.3000	21.4050	10800.00	0.00	10800.00	90	13	182	347	0.524495677233429	0.295296162764846	0.295296162764846	false	false	false	true
65d374b2-9fbc-4e2c-9d9c-a5b831e8a541	2026-08-28 11:09	2026-08-28 11:09	2026-08-28 11:09	HRL	HRL270115P00021000	put	21.0000	2027-01-15	1.2000	1.2000	1.3500	21.4200	10800.00	0.00	10800.00	90	12	91	347	0.262247838616715	0.296445157265209	0.296445157265209	false	false	false	true
9b08ff78-8f41-4c77-9be7-0e226452625c	2026-08-27 12:58	2026-08-27 12:58	2026-08-27 12:58	HRL	HRL270115P00022000	put	22.0000	2027-01-15	1.7000	1.7000	1.8000	21.5200	14790.00	0.00	14790.00	87	9	175	85	2.05882352941176	0.30396299950412	0.30396299950412	true	false	false	true
5de9b655-3d2d-4828-b01f-fcf0bc1f939b	2026-08-27 12:33	2026-08-27 12:33	2026-08-27 12:33	HRL	HRL270115P00021000	put	21.0000	2027-01-15	1.2000	1.2000	1.3000	21.5300	10440.00	0.00	10440.00	87	8	204	49	4.16326530612245	0.303880105521391	0.303880105521391	true	false	false	true
f95bd304-32c7-4e80-81f0-967a8b9f8370	2026-08-27 12:13	2026-08-27 12:12	2026-08-27 12:12	HRL	HRL260828P00023500	put	23.5000	2026-08-28	1.9000	1.9000	2.0000	21.5600	19000.00	0.00	19000.00	100	8	1334	1642	0.812423873325213	1.23756621835261	1.23756621835261	false	false	false	true
61b6f68f-c44f-4841-9290-d739d0fdd2b8	2026-08-27 11:28	2026-08-27 11:28	2026-08-27 11:28	HRL	HRL270115P00022000	put	22.0000	2027-01-15	1.6500	1.6500	1.8500	21.6700	14025.00	0.00	14025.00	85	9	87	85	1.02352941176471	0.307780218573341	0.307780218573341	true	false	false	true
45d1edb2-c938-4bc1-8399-91500dff7ae5	2026-08-27 11:19	2026-08-27 11:19	2026-08-27 11:19	HRL	HRL260828P00021000	put	21.0000	2026-08-28	0.1500	0.0500	0.1500	21.5050	14999.00	14999.00	0.00	1000	37	3025	45	67.2222222222222	0.794456475547174	0.779938845685286	false	false	false	true
0844301b-ccf9-4601-b963-85cdbea24efb	2026-08-27 10:19	2026-08-27 10:19	2026-08-27 10:19	HRL	HRL270115P00021000	put	21.0000	2027-01-15	1.2500	1.2500	1.3500	21.5250	10500.00	0.00	10500.00	84	11	92	49	1.87755102040816	0.313318833766669	0.313318833766669	true	false	false	true
e9c50113-8f9b-44b0-846d-d062e6216819	2026-08-27 10:06	2026-08-27 10:06	2026-08-27 10:06	HRL	HRL260828P00024000	put	24.0000	2026-08-28	2.3500	2.2000	3.0000	21.6100	47000.00	8460.00	7050.00	200	6	243	649	0.37442218798151	0.519498779335863	3.19156648404728	false	false	false	true
e73f5a71-3f4d-42a1-97c7-e2eacd7623b3	2026-08-27 10:02	2026-08-27 10:02	2026-08-27 10:02	HRL	HRL260828P00021500	put	21.5000	2026-08-28	0.2500	0.2000	0.2500	21.6550	14774.00	8049.00	0.00	591	26	777	150	5.18	0.748390239750006	0.715911749774136	true	false	false	true
f5d3c2a5-7c43-4737-8772-e04c56e48ae6	2026-08-26 15:45	2026-08-26 15:45	2026-08-26 15:45	HRL	HRL260828P00022000	put	22.0000	2026-08-28	0.1500	0.1000	0.1500	23.7450	14925.00	14925.00	0.00	995	27	1728	109	15.8532110091743	1.05184977284193	1.04451058148451	false	false	false	true
93b3b857-8d7b-4a01-b32c-69a8b60f2554	2026-08-26 14:02	2026-08-26 14:02	2026-08-26 14:02	HRL	HRL260918C00025000	call	25.0000	2026-09-18	0.3000	0.3000	0.4000	23.8140	43530.00	0.00	43530.00	1451	8	1631	5087	0.320621191271869	0.298699681119781	0.298699681119781	false	false	false	true
a245e3ef-6d53-4cc0-a400-946781af3908	2026-08-24 14:46	2026-08-24 14:46	2026-08-24 14:46	HRL	HRL260918C00022000	call	22.0000	2026-09-18	2.2500	2.1500	2.3500	24.0300	71325.00	11250.00	56250.00	317	13	317	1311	0.241800152555301	0.339595869544423	0.339595869544423	false	false	false	true
2221e18b-39c7-4f89-8956-3a64158e673b	2026-08-18 09:50	2026-08-18 09:50	2026-08-18 09:50	HRL	HRL280121C00030000	call	30.0000	2028-01-21	1.5500	1.2000	1.6000	24.0000	20305.00	7750.00	12555.00	131	16	131	1453	0.0901582931865107	0.248472495803272	0.248472495803272	false	false	false	true