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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = XLV×

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

a3c65bea-2499-47cc-a21e-9dbfcba8ddbf	2026-09-25 15:17	2026-09-25 15:17	2026-09-25 15:17	XLV	XLV270115C00180000	call	180.0000	2027-01-15	3.2000	3.1000	3.3000	170.5300	18560.00	18240.00	0.00	58	8	92	11006	0.00835907686716337	0.158701555423992	0.158701555423992	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	43586075154.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:24:28.165724Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
f92eeb8c-72d5-4851-af08-70ceacfafd14	2026-09-25 12:47	2026-09-25 12:47	2026-09-25 12:47	XLV	XLV261016P00165000	put	165.0000	2026-10-16	0.9300	0.8800	0.9400	169.8300	11253.00	10044.00	1209.00	121	22	149	2297	0.064867218110579	0.17477199504419	0.17477199504419	false	false	false	true
3f348a94-9497-4c33-a533-5c827a655e2c	2026-09-25 10:52	2026-09-25 10:52	2026-09-25 10:52	XLV	XLV280121C00150000	call	150.0000	2028-01-21	30.3900	30.3500	30.4500	169.0000	21275.00	0.00	21275.00	7	6	93	313	0.297124600638978	0.143825665672657	0.142486168214326	false	false	false	true
e488eff9-d85f-4342-a71a-998bcd62e3bb	2026-09-25 10:48	2026-09-25 10:48	2026-09-25 10:48	XLV	XLV280121C00150000	call	150.0000	2028-01-21	30.4500	30.4500	30.8000	169.4800	42631.00	0.00	42631.00	14	9	69	313	0.220447284345048	0.142547740276118	0.142547740276118	false	false	false	true
fe3cfac7-1cb9-4ff2-aaf3-a4c5d8d02293	2026-09-25 10:39	2026-09-25 10:39	2026-09-25 10:39	XLV	XLV261009P00168000	put	168.0000	2026-10-09	1.4100	1.4100	1.5500	169.4950	17907.00	0.00	17907.00	127	33	129	183	0.704918032786885	0.165108907522132	0.165108907522132	false	false	false	true
8b54ecca-6354-49bc-86c2-038c4f58fe78	2026-09-24 15:34	2026-09-24 15:34	2026-09-24 15:34	XLV	XLV261016C00165000	call	165.0000	2026-10-16	6.6000	6.5500	6.7000	170.3150	73920.00	0.00	73920.00	112	28	336	1434	0.234309623430962	0.176227960995675	0.176227960995675	false	false	false	true
52780a5e-b39c-4d34-b72d-2dc404d2de2f	2026-09-24 15:02	2026-09-24 15:02	2026-09-24 15:02	XLV	XLV270115P00167000	put	167.0000	2027-01-15	4.4500	4.2000	4.4500	170.0700	21360.00	21360.00	0.00	48	14	73	257	0.284046692607004	0.182091715968515	0.182091715968515	false	false	false	true
4e8bbab8-2e41-4f7c-be7a-96bca5a04418	2026-09-24 14:25	2026-09-24 14:24	2026-09-24 14:24	XLV	XLV261023C00172000	call	172.0000	2026-10-23	2.5800	2.1800	2.6700	170.1800	12125.00	12125.00	0.00	47	14	89	7	12.7142857142857	0.165417249917791	0.165417249917791	true	false	false	true
e0524a2a-2839-47d8-8cd5-a14e7786ffcc	2026-09-24 11:55	2026-09-24 11:55	2026-09-24 11:55	XLV	XLV261002C00170000	call	170.0000	2026-10-02	1.7200	1.7200	1.8400	169.8400	55728.00	0.00	11008.00	324	9	712	509	1.39882121807466	0.17203305825571	0.17203305825571	false	false	false	true
970c3201-37c2-4144-9613-b8485a924d31	2026-09-24 11:32	2026-09-24 11:32	2026-09-24 11:32	XLV	XLV261106C00162000	call	162.0000	2026-11-06	9.8500	9.8500	10.3000	169.7600	113275.00	0.00	113275.00	115	27	115	0	0	0.189606360379968	0.189606360379968	false	false	false	true
5ef6b1b7-57d7-4f59-abfc-e8af9720339f	2026-09-24 11:21	2026-09-24 11:20	2026-09-24 11:20	XLV	XLV261120C00165000	call	165.0000	2026-11-20	8.5500	8.5500	8.9000	170.1500	60705.00	0.00	60705.00	71	11	78	77	1.01298701298701	0.183377264699451	0.183377264699451	false	false	false	true
205bcc8d-30de-4228-921d-c680e689d4f0	2026-09-24 11:02	2026-09-24 11:01	2026-09-24 11:01	XLV	XLV261023C00167000	call	167.0000	2026-10-23	5.7000	5.7000	5.9500	170.4400	43320.00	0.00	43320.00	76	11	78	4	19.5	0.176778543455605	0.176778543455605	false	false	false	true
26f27aaa-5f45-4c56-9c71-206cf7ac8c8a	2026-09-24 10:30	2026-09-24 10:30	2026-09-24 10:30	XLV	XLV270115P00168000	put	168.0000	2027-01-15	4.7500	4.6500	4.7500	170.8900	48450.00	48450.00	0.00	102	23	120	96	1.25	0.187739916516136	0.187739916516136	false	false	false	true
fdf88460-8086-4730-b57c-c7cb4d7f15e1	2026-09-24 10:14	2026-09-24 10:14	2026-09-24 10:14	XLV	XLV261016C00175000	call	175.0000	2026-10-16	1.5300	1.3800	1.5800	171.4000	24327.00	23409.00	918.00	159	25	250	1478	0.16914749661705	0.167710423809378	0.167710423809378	false	false	false	true
a1785f23-c2bb-4834-9527-72bf04546763	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	XLV	XLV261009C00171000	call	171.0000	2026-10-09	2.5500	2.5000	2.8400	171.0500	36464.00	254.00	36210.00	143	8	208	90	2.31111111111111	0.172313389904092	0.171588586406588	true	false	false	true
545a80bd-2c01-47fb-ac76-67ebeb257aa5	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	XLV	XLV261009C00171000	call	171.0000	2026-10-09	2.6400	1.2000	2.6400	171.1050	10823.00	10823.00	0.00	41	7	41	90	0.455555555555556	0.176721961158642	0.176721961158642	true	false	false	true
c7a78ab6-58cd-4f22-ab78-9dcf226c4ce9	2026-09-24 09:59	2026-09-24 09:58	2026-09-24 09:58	XLV	XLV261030C00175000	call	175.0000	2026-10-30	2.2700	1.8900	2.2700	170.8200	10214.00	10214.00	0.00	45	20	58	8	7.25	0.173663745679343	0.173663745679343	true	false	false	true
2d8eb067-f926-41b3-a4b8-44c219fcf765	2026-09-24 09:59	2026-09-24 09:58	2026-09-24 09:58	XLV	XLV261009C00165000	call	165.0000	2026-10-09	6.7500	4.7000	6.9500	170.8600	27675.00	26995.00	680.00	41	14	41	0	0	0.193996444052224	0.198683347229185	true	false	false	true
865d6c92-562b-4d87-95be-80a8f2e310e2	2026-09-24 09:57	2026-09-24 09:57	2026-09-24 09:57	XLV	XLV261030C00169000	call	169.0000	2026-10-30	5.1500	3.4500	5.1500	170.7300	11840.00	11840.00	0.00	23	9	23	10	2.3	0.180046355757211	0.180046355757211	true	false	false	true
8ac90cd6-643d-4b34-9140-0897b7ad36a2	2026-09-24 09:55	2026-09-24 09:55	2026-09-24 09:55	XLV	XLV261023C00162500	call	162.5000	2026-10-23	9.5500	7.4500	9.6500	170.7200	72580.00	71620.00	960.00	76	10	76	1	76	0.193942201505891	0.198144032970984	true	false	false	true
d8c44f18-89ad-43c7-80c8-f08bb01ee953	2026-09-24 09:49	2026-09-24 09:49	2026-09-24 09:49	XLV	XLV261218C00180000	call	180.0000	2026-12-18	2.6300	1.6100	2.6300	170.5100	10256.00	10256.00	0.00	39	10	39	1421	0.0274454609429979	0.169313809588966	0.16896805709633	true	false	false	true
20f87b1c-ace7-4a02-a277-c362495adf40	2026-09-24 09:49	2026-09-24 09:49	2026-09-24 09:49	XLV	XLV261002C00169000	call	169.0000	2026-10-02	2.7900	1.4600	2.7900	170.5100	44639.00	44639.00	0.00	160	18	161	214	0.752336448598131	0.183986040993989	0.183986040993989	true	false	false	true
fc44793f-8071-4227-b25d-5333fc010e05	2026-09-24 09:47	2026-09-24 09:47	2026-09-24 09:47	XLV	XLV261218C00156000	call	156.0000	2026-12-18	17.1500	15.0500	17.1500	170.4600	22295.00	22295.00	0.00	13	5	13	236	0.0550847457627119	0.195591978712422	0.195591978712422	true	false	false	true
8417b6df-c47d-4d20-b06b-955b4f9460fc	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	XLV	XLV261120C00176000	call	176.0000	2026-11-20	2.1500	1.8900	2.1500	168.7200	32680.00	32680.00	0.00	152	5	152	1110	0.136936936936937	0.167698310867736	0.167698310867736	false	false	false	true
510e23ad-cfbd-4425-940a-e62a045b5a3c	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	XLV	XLV270115C00180000	call	180.0000	2027-01-15	2.6700	2.4300	2.6700	168.7200	37380.00	37380.00	0.00	140	29	150	10965	0.0136798905608755	0.158544858368802	0.158544858368802	false	false	false	true
78c98283-012d-4509-b088-eb4cd2da148e	2026-09-23 14:48	2026-09-23 14:48	2026-09-23 14:48	XLV	XLV270115C00175000	call	175.0000	2027-01-15	4.1500	4.0000	4.3000	168.4300	37765.00	36935.00	0.00	91	27	222	6739	0.0329425730820597	0.158931659548326	0.158931659548326	false	false	false	true
c36e5ef1-578d-4c71-b2ff-d9428f4389e4	2026-09-23 13:36	2026-09-23 13:36	2026-09-23 13:36	XLV	XLV270115C00175000	call	175.0000	2027-01-15	4.1500	4.0000	4.1500	168.4600	35690.00	35690.00	0.00	86	23	104	6739	0.0154325567591631	0.158597580560236	0.158597580560236	false	false	false	true
d8752de8-3783-4a6c-b145-31b4ba5ac1f6	2026-09-23 13:25	2026-09-23 13:25	2026-09-23 13:25	XLV	XLV261120C00163000	call	163.0000	2026-11-20	8.8000	8.4500	10.1500	168.0000	168960.00	880.00	168080.00	192	67	250	0	0	0.190307052468419	0.190307052468419	true	false	false	true
5bd3106b-b313-498e-825a-2f0bc249277c	2026-09-23 12:16	2026-09-23 12:16	2026-09-23 12:16	XLV	XLV261002C00170000	call	170.0000	2026-10-02	1.2700	1.2700	1.4000	168.7100	39624.00	0.00	39624.00	312	37	394	148	2.66216216216216	0.167446379806721	0.167446379806721	false	false	false	true
6e697161-482f-4e5e-a7f1-632c96d45ff3	2026-09-23 10:44	2026-09-23 10:44	2026-09-23 10:44	XLV	XLV261002C00169000	call	169.0000	2026-10-02	2.4100	2.4000	3.0000	169.9400	62901.00	0.00	62901.00	261	8	261	305	0.855737704918033	0.169984466465836	0.169984466465836	true	false	false	true
4b5e553d-5367-4048-8642-7ce34d0f1f0d	2026-09-23 10:42	2026-09-23 10:42	2026-09-23 10:42	XLV	XLV260925C00169000	call	169.0000	2026-09-25	1.6500	1.6500	1.8500	170.0200	25410.00	0.00	25410.00	154	29	162	129	1.25581395348837	0.207203055185182	0.207203055185182	false	false	false	true
81a71847-1ae0-4d07-89b1-4b95df92ed43	2026-09-23 10:14	2026-09-23 10:14	2026-09-23 10:14	XLV	XLV261016C00167500	call	167.5000	2026-10-16	4.9000	4.1500	4.9500	170.0000	13720.00	13720.00	0.00	28	6	28	0	0	0.170440485453931	0.170440485453931	false	false	false	true
9b71d3a6-0722-409e-8658-703e36f528c2	2026-09-23 10:09	2026-09-23 10:09	2026-09-23 10:09	XLV	XLV261002C00171000	call	171.0000	2026-10-02	1.4700	1.1900	1.4700	170.1250	29547.00	29547.00	0.00	201	32	206	88	2.34090909090909	0.168716422459794	0.168716422459794	true	false	false	true
dc17bf05-0cb2-4c4c-9749-22bf4b0ece4a	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	XLV	XLV261016C00165000	call	165.0000	2026-10-16	6.2000	6.2000	6.3500	169.8000	81220.00	0.00	81220.00	131	12	145	1308	0.11085626911315	0.171582813858727	0.171582813858727	false	false	false	true
f8695ec7-63d6-4370-8910-4c5a3362474d	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	XLV	XLV261016C00160000	call	160.0000	2026-10-16	10.5500	10.5500	12.0000	169.8200	12660.00	0.00	12660.00	12	8	12	139	0.0863309352517986	0.186233975783734	0.186233975783734	false	false	false	true
4703499f-d0f3-44dc-a110-be6f93cf5aeb	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	XLV	XLV261002C00170000	call	170.0000	2026-10-02	1.9000	1.9000	2.1900	169.0000	10070.00	0.00	9120.00	53	5	59	148	0.398648648648649	0.176380568695818	0.176380568695818	false	false	false	true
e80c97ee-e641-4c43-a7bf-dde2ff438338	2026-09-23 09:47	2026-09-23 09:47	2026-09-23 09:47	XLV	XLV261016C00168000	call	168.0000	2026-10-16	4.2500	4.2500	5.1000	169.0000	11900.00	0.00	11900.00	28	8	30	186	0.161290322580645	0.1709848055774	0.1709848055774	false	false	false	true
667c0788-6942-4cd7-9832-b89362410588	2026-09-22 16:00	2026-09-22 15:59	2026-09-22 15:59	XLV	XLV261120C00176000	call	176.0000	2026-11-20	2.6500	2.6500	2.8300	169.0000	24910.00	0.00	24910.00	94	5	1135	0	0	0.170307286105573	0.170307286105573	false	false	false	true
c8989929-8c95-49a3-a3a1-9c23f5e34710	2026-09-22 15:58	2026-09-22 15:58	2026-09-22 15:58	XLV	XLV261120C00176000	call	176.0000	2026-11-20	2.6500	2.6100	2.7000	169.9900	10601.00	0.00	10601.00	40	8	974	0	0	0.169267080931884	0.169267080931884	true	false	false	true
516bb43f-693f-4924-9af4-6b46a3ac4aaf	2026-09-22 15:39	2026-09-22 15:39	2026-09-22 15:39	XLV	XLV261120C00176000	call	176.0000	2026-11-20	2.7500	2.6500	2.7500	170.3200	150425.00	150425.00	0.00	547	19	897	0	0	0.168565808930116	0.168565808930116	false	false	false	true
e4cf7c93-d0ef-4b5c-a658-9a8be557caee	2026-09-22 14:42	2026-09-22 14:42	2026-09-22 14:42	XLV	XLV261120C00176000	call	176.0000	2026-11-20	2.6500	2.5900	2.7200	170.1950	12190.00	0.00	12190.00	46	5	347	0	0	0.166412707069367	0.166412707069367	false	false	false	true
ae96800b-4dd0-42fe-b7fb-3c3a05d83a33	2026-09-22 14:34	2026-09-22 14:34	2026-09-22 14:34	XLV	XLV261218P00175000	put	175.0000	2026-12-18	7.4500	7.2500	7.4500	170.2400	55875.00	55875.00	0.00	75	22	90	511	0.176125244618395	0.173739429076629	0.173739429076629	false	false	false	true
295a783b-79b2-4fc7-b2fb-45518f856e67	2026-09-22 13:04	2026-09-22 13:04	2026-09-22 13:04	XLV	XLV261218P00170000	put	170.0000	2026-12-18	4.8000	4.6000	4.8000	170.0000	80640.00	80640.00	0.00	168	29	169	778	0.217223650385604	0.17083456574033	0.17083456574033	false	false	false	true
4935c345-9bdf-4efa-8db7-805424278a9e	2026-09-22 12:27	2026-09-22 12:27	2026-09-22 12:27	XLV	XLV261120P00167000	put	167.0000	2026-11-20	2.6800	2.6500	2.8600	170.0750	32962.00	17269.00	15693.00	123	7	152	0	0	0.165613729378212	0.166409887338641	true	false	false	true
67dfa859-a1b4-4be0-9ae5-59f259518cda	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	XLV	XLV261218C00180000	call	180.0000	2026-12-18	2.4000	2.3000	2.5800	170.0100	155040.00	153360.00	1680.00	646	24	651	978	0.665644171779141	0.164277531286706	0.164277531286706	false	false	false	true
f97bb14e-616b-4704-84dd-4445eaa41d38	2026-09-22 11:56	2026-09-22 11:55	2026-09-22 11:55	XLV	XLV261030P00169000	put	169.0000	2026-10-30	2.6900	2.4500	2.6900	170.0900	41695.00	41695.00	0.00	155	27	155	1	155	0.161703929969456	0.161703929969456	false	false	false	true
7bb8ed6b-5b78-4490-a00b-ab1d6cefee4c	2026-09-22 11:54	2026-09-22 11:54	2026-09-22 11:54	XLV	XLV261120P00170000	put	170.0000	2026-11-20	3.9000	3.5500	3.9000	170.1500	11700.00	11700.00	0.00	30	5	30	433	0.069284064665127	0.16582957680907	0.16582957680907	false	false	false	true
064bd2e2-0dc9-4bbe-81aa-b6ea0fe5886b	2026-09-22 11:53	2026-09-22 11:53	2026-09-22 11:53	XLV	XLV261023P00171000	put	171.0000	2026-10-23	3.2500	2.9500	3.2500	170.2200	19499.00	19499.00	0.00	60	16	60	0	0	0.159415784487233	0.159415784487233	true	false	false	true
4e63ef41-9c5d-4d79-8779-4f32fe023662	2026-09-22 11:44	2026-09-22 11:44	2026-09-22 11:44	XLV	XLV261120C00175000	call	175.0000	2026-11-20	3.0000	2.8400	3.0500	170.4900	50372.00	49200.00	1172.00	168	28	204	455	0.448351648351648	0.16221614348802	0.159562120042928	false	false	false	true
65e2edde-2907-46fe-9ca7-5c792cb3c5c7	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	XLV	XLV261002P00170000	put	170.0000	2026-10-02	1.5700	1.4200	1.7700	170.3000	16171.00	16013.00	158.00	103	24	113	27	4.18518518518519	0.160863513019013	0.161354622262262	true	false	false	true