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:ticker = XLV×sorted by created_at ↑×

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

acd47312-29cb-4a05-96ac-563ebdacbb31	2026-08-19 10:12	2026-08-19 10:12	2026-08-19 10:12	XLV	XLV261016C00185000	call	185.0000	2026-10-16	2.1000	1.9300	2.1400	176.1850	113660.00	42922.00	57298.00	542	22	554	11	50.3636363636364	0.17612241338681	0.174013803179599	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	43575325654.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9e52ced5-d367-4094-8fe1-f1e3e4e4648e	2026-08-19 10:20	2026-08-19 10:20	2026-08-19 10:20	XLV	XLV261016C00175000	call	175.0000	2026-10-16	6.2000	5.8000	6.2000	176.4000	54555.00	54555.00	0.00	88	14	390	924	0.422077922077922	0.174931122170563	0.173097975418778	true	false	false	true	false
9836f898-2e55-4117-881d-adaff7a17502	2026-08-19 10:20	2026-08-19 10:20	2026-08-19 10:20	XLV	XLV260904C00180000	call	180.0000	2026-09-04	1.4100	0.5900	1.4600	176.2700	15064.00	11514.00	3550.00	107	6	111	0	0	0.188948536403582	0.188948536403582	true	false	false	true	false
e1ce00f3-0069-4bad-a548-454ec58355fc	2026-08-19 10:30	2026-08-19 10:29	2026-08-19 10:29	XLV	XLV270115C00195000	call	195.0000	2027-01-15	2.8700	2.5200	2.8700	176.2900	59671.00	59671.00	0.00	208	31	333	145	2.29655172413793	0.181020753364503	0.181020753364503	true	false	false	true	false
529a5b86-0fcf-446e-b64d-1359f210f842	2026-08-19 10:30	2026-08-19 10:30	2026-08-19 10:30	XLV	XLV260918C00180000	call	180.0000	2026-09-18	2.4200	2.4200	2.5200	176.0101	13552.00	0.00	13552.00	56	10	173	978	0.176891615541922	0.191784282552466	0.191784282552466	false	false	false	true	false
4511b60a-ce51-4067-8c45-22e492bff2ff	2026-08-19 10:36	2026-08-19 10:35	2026-08-19 10:35	XLV	XLV260821P00175000	put	175.0000	2026-08-21	0.6700	0.5900	0.7200	176.0200	109210.00	109143.00	67.00	1630	14	1638	40	40.95	0.212565685345213	0.216070101879813	false	false	false	true	false
28f0c787-47ed-43c1-ab85-74ffb8c2efe6	2026-08-19 10:37	2026-08-19 10:37	2026-08-19 10:37	XLV	XLV261218C00200000	call	200.0000	2026-12-18	1.2800	0.9700	1.2800	175.9500	16512.00	16512.00	0.00	129	11	1669	178	9.37640449438202	0.179227278559689	0.179227278559689	false	false	false	true	false
a1198bc8-5656-4af8-9f4d-c6f0573f9fac	2026-08-19 10:44	2026-08-19 10:44	2026-08-19 10:44	XLV	XLV260918C00160000	call	160.0000	2026-09-18	16.3000	16.3000	16.4500	175.5800	48900.00	0.00	48900.00	30	5	44	6684	0.00658288450029922	0.207503520733024	0.207503520733024	true	false	false	true	false
9ae18fea-a873-4b68-81d3-3d2b5c3ccf26	2026-08-19 10:53	2026-08-19 10:53	2026-08-19 10:53	XLV	XLV270115C00180000	call	180.0000	2027-01-15	6.9100	6.9000	7.2000	175.2400	29702.00	0.00	29702.00	43	9	345	9290	0.0371367061356297	0.175968352664012	0.175072145079055	true	false	false	true	false
99cadfa9-543a-443a-8d90-695ad2a07b10	2026-08-19 10:53	2026-08-19 10:53	2026-08-19 10:53	XLV	XLV270115C00190000	call	190.0000	2027-01-15	3.6000	3.5500	3.8500	175.2000	27019.00	720.00	26299.00	75	9	733	2922	0.250855578370979	0.177346819066012	0.177192008538175	true	false	false	true	false
546e024f-9ac0-4467-933e-74324650923e	2026-08-19 10:53	2026-08-19 10:53	2026-08-19 10:53	XLV	XLV270115C00180000	call	180.0000	2027-01-15	6.9100	6.9000	7.2000	175.2101	28340.00	0.00	28340.00	41	7	302	9290	0.032508073196986	0.174275775827029	0.175396322834351	true	false	false	true	false
3a6c8e7b-a66e-4f3f-8707-f003db35fbb4	2026-08-19 10:53	2026-08-19 10:53	2026-08-19 10:53	XLV	XLV270115C00190000	call	190.0000	2027-01-15	3.5500	3.4500	3.8000	175.2300	21300.00	355.00	20945.00	60	13	798	2922	0.273100616016427	0.175755162566216	0.175678731076922	true	false	false	true	false
175a4b92-7cfd-4827-91dc-55c06e8aec29	2026-08-19 10:53	2026-08-19 10:53	2026-08-19 10:53	XLV	XLV261218C00180000	call	180.0000	2026-12-18	6.1600	6.1500	6.7500	175.2300	26486.00	625.00	25861.00	43	16	71	304	0.233552631578947	0.180264848672044	0.181511108504628	true	false	false	true	false
7a5c5441-c329-4667-a28d-866dc6d35847	2026-08-19 10:58	2026-08-19 10:57	2026-08-19 10:57	XLV	XLV260821C00176000	call	176.0000	2026-08-21	0.7100	0.7100	0.9200	175.1000	50836.00	0.00	50836.00	716	42	1058	0	0	0.209829688010414	0.209829688010414	true	false	false	true	false
e03daf22-ae90-4f1f-a4ac-dd625485233c	2026-08-19 10:58	2026-08-19 10:57	2026-08-19 10:57	XLV	XLV260821C00176000	call	176.0000	2026-08-21	0.7100	0.7100	0.8700	175.1200	20093.00	0.00	20093.00	283	13	1343	0	0	0.208290863431357	0.208290863431357	true	false	false	true	false
ccaab253-ca93-48b5-92d1-1ec8fcc9b562	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	XLV	XLV270617C00180000	call	180.0000	2027-06-17	11.0000	10.5500	11.2500	174.9300	16500.00	12100.00	4400.00	15	7	19	1609	0.0118085767557489	0.167640685004625	0.167640685004625	false	false	false	true	false
9a3a983d-85b0-426f-bf8b-417326fd46ee	2026-08-19 11:32	2026-08-19 11:32	2026-08-19 11:32	XLV	XLV260918C00170000	call	170.0000	2026-09-18	6.8500	6.8000	7.0000	174.7750	691850.00	2740.00	689110.00	1010	27	1967	13284	0.148072869617585	0.182579105948258	0.182579105948258	false	false	false	true	false
999e4233-ef68-41a3-b3bf-99a43bb1047f	2026-08-19 11:34	2026-08-19 11:34	2026-08-19 11:34	XLV	XLV260918C00180000	call	180.0000	2026-09-18	1.7600	1.7600	1.7700	174.7300	14961.00	177.00	14784.00	85	19	310	978	0.316973415132924	0.179805491734642	0.179805491734642	false	false	false	true	false
2c57da22-041f-4934-962a-c995a3f07b69	2026-08-19 11:34	2026-08-19 11:34	2026-08-19 11:34	XLV	XLV260918C00185000	call	185.0000	2026-09-18	0.7100	0.7000	0.7100	174.7300	38114.00	27264.00	10850.00	539	27	2129	6814	0.312444966245964	0.179526182361141	0.179526182361141	false	false	false	true	false
5a758e5d-9cd0-4ffb-a7df-1f71f57d223d	2026-08-19 12:04	2026-08-19 12:04	2026-08-19 12:04	XLV	XLV260918C00171000	call	171.0000	2026-09-18	6.0000	6.0000	6.1500	174.5800	38400.00	0.00	38400.00	64	18	169	846	0.199763593380615	0.181212920143821	0.181212920143821	false	false	false	true	false
e6a2330a-0248-4abc-9fca-4cca7efb14df	2026-08-19 12:11	2026-08-19 12:10	2026-08-19 12:10	XLV	XLV280121C00170000	call	170.0000	2028-01-21	20.9000	20.4500	21.3500	174.5600	31350.00	14630.00	10450.00	15	6	53	1456	0.0364010989010989	0.155715997907477	0.155715997907477	false	false	false	true	false
40728d7c-30f1-4b79-abb1-2adfb095a8e8	2026-08-19 12:33	2026-08-19 12:33	2026-08-19 12:33	XLV	XLV260918C00171000	call	171.0000	2026-09-18	5.7500	5.6500	5.7500	174.1800	20125.00	20125.00	0.00	35	7	235	846	0.277777777777778	0.182387845770596	0.182387845770596	false	false	false	true	false
759f7bb5-5c75-4f93-93f4-a08f0c983169	2026-08-19 12:49	2026-08-19 12:49	2026-08-19 12:49	XLV	XLV280121P00175000	put	175.0000	2028-01-21	12.1000	11.2000	12.9500	174.3300	123420.00	112530.00	10890.00	102	9	102	24	4.25	0.203658312352821	0.203658312352821	false	false	false	true	false
0c6e7294-f910-4e02-be56-27ce5069bef1	2026-08-19 13:19	2026-08-19 13:19	2026-08-19 13:19	XLV	XLV260911C00172000	call	172.0000	2026-09-11	5.0500	4.4000	5.0500	174.9200	17170.00	17170.00	0.00	34	6	39	6	6.5	0.179014424470124	0.179014424470124	false	false	false	true	false
d0dd46c1-dad3-4663-aaa5-0a05bba12fd6	2026-08-19 13:19	2026-08-19 13:19	2026-08-19 13:19	XLV	XLV260918P00168000	put	168.0000	2026-09-18	0.9600	0.9600	1.0200	174.9200	28032.00	0.00	28032.00	292	38	309	80	3.8625	0.178210452596685	0.178210452596685	true	false	false	true	false
3c4e9edf-a903-446c-a67a-07a2169b2b60	2026-08-19 13:24	2026-08-19 13:24	2026-08-19 13:24	XLV	XLV260911C00174000	call	174.0000	2026-09-11	3.8500	3.2500	3.8500	174.9900	22330.00	22330.00	0.00	58	22	58	4	14.5	0.177483114821885	0.177483114821885	false	false	false	true	false
7df083dd-03cd-43e5-a8fe-8ddaa89999e8	2026-08-19 13:43	2026-08-19 13:43	2026-08-19 13:43	XLV	XLV270617P00180000	put	180.0000	2027-06-17	12.1500	11.9500	12.8500	175.0400	19440.00	4860.00	14580.00	16	5	16	5	3.2	0.198946167430935	0.198946167430935	false	false	false	true	false
2884ce87-a22b-46e7-a89f-bbcb71abb192	2026-08-19 14:22	2026-08-19 14:22	2026-08-19 14:22	XLV	XLV260911C00182000	call	182.0000	2026-09-11	0.9600	0.8000	0.9700	175.4600	16700.00	15936.00	764.00	174	28	215	0	0	0.173627875070189	0.173627875070189	true	false	false	true	false
9e8f0195-efdb-4f76-81ea-f03a5af1dd9e	2026-08-19 14:39	2026-08-19 14:39	2026-08-19 14:39	XLV	XLV261218C00205000	call	205.0000	2026-12-18	0.8500	0.6800	0.8500	175.7403	20909.00	20909.00	0.00	246	37	255	18	14.1666666666667	0.183914854343655	0.183914854343655	false	false	false	true	false
1085b9b3-13df-43e4-a2b2-63595e0ae2e8	2026-08-19 15:16	2026-08-19 15:16	2026-08-19 15:16	XLV	XLV261218C00195000	call	195.0000	2026-12-18	2.0300	1.8700	2.0300	175.9400	11571.00	10556.00	0.00	57	12	78	11	7.09090909090909	0.179847237595315	0.179847237595315	false	false	false	true	false
a94a4387-c3ce-40df-b822-b3c6537d9e3b	2026-08-19 15:19	2026-08-19 15:18	2026-08-19 15:18	XLV	XLV270115P00170000	put	170.0000	2027-01-15	5.0000	4.8000	5.1500	175.9750	59500.00	8500.00	51000.00	119	22	130	723	0.179806362378976	0.198111133629401	0.198111133629401	false	false	false	true	false
a938c6db-c62d-4bc1-8cec-19ae62670c49	2026-08-19 15:35	2026-08-19 15:35	2026-08-19 15:35	XLV	XLV270617P00160000	put	160.0000	2027-06-17	4.4500	4.2500	4.9000	175.8700	400500.00	0.00	400500.00	900	1	904	1601	0.564647095565272	0.203856129790185	0.203856129790185	false	true	false	true	false
a4cef593-1df3-4a6a-82ea-5a76e2f0a9b6	2026-08-19 15:38	2026-08-19 15:38	2026-08-19 15:38	XLV	XLV261218C00200000	call	200.0000	2026-12-18	1.3300	1.2300	1.4600	175.7900	10773.00	1463.00	9310.00	81	5	2141	178	12.0280898876404	0.182397867902523	0.182397867902523	false	false	false	true	false
9788c129-1801-4338-a75e-8ea6e1218630	2026-08-19 15:42	2026-08-19 15:42	2026-08-19 15:42	XLV	XLV270319C00200000	call	200.0000	2027-03-19	2.9900	2.7400	3.0500	175.8500	47561.00	6000.00	41561.00	159	5	170	4	42.5	0.174395073715919	0.174638648626242	false	false	false	true	false
9e87d143-4c3f-44a4-a4ec-667438fd5e37	2026-08-19 15:59	2026-08-19 15:59	2026-08-19 15:59	XLV	XLV260821C00167000	call	167.0000	2026-08-21	8.7500	8.7500	9.3500	175.6300	452375.00	0.00	452375.00	517	7	634	2053	0.308816366293229	0.395356430784562	0.395356430784562	false	false	false	true	false
595b688c-4d44-4cce-9ca3-d9fb2d0e3c79	2026-08-19 15:59	2026-08-19 15:59	2026-08-19 15:59	XLV	XLV260918C00180000	call	180.0000	2026-09-18	1.9800	1.8900	2.1400	175.6300	119394.00	19404.00	99990.00	603	20	1034	978	1.05725971370143	0.175667265591186	0.175667265591186	false	false	false	true	false
07c990a7-7e36-4ae3-9bc1-51ff179c565b	2026-08-19 15:59	2026-08-19 15:59	2026-08-19 15:59	XLV	XLV260821C00172000	call	172.0000	2026-08-21	3.8000	3.8000	4.2000	175.6300	22420.00	0.00	22420.00	59	5	230	1075	0.213953488372093	0.22188165908147	0.22188165908147	false	false	false	true	false
087a8491-19ff-4382-9f4c-8d8514c4ce05	2026-08-19 16:00	2026-08-19 15:59	2026-08-19 15:59	XLV	XLV260918C00180000	call	180.0000	2026-09-18	1.9900	1.9800	2.2600	175.6850	131933.00	0.00	131933.00	664	30	1716	978	1.75460122699387	0.175183365319328	0.174644924622173	false	false	false	true	false
5c763250-845c-4e45-ad06-dc97a1416427	2026-08-20 10:11	2026-08-20 10:11	2026-08-20 10:11	XLV	XLV260918C00161000	call	161.0000	2026-09-18	13.8500	13.8500	14.5500	174.0700	24930.00	0.00	24930.00	18	9	22	2261	0.00973020787262273	0.19707043600331	0.19707043600331	true	false	false	true	false
1f520f1b-d940-40c7-b843-090a790b2409	2026-08-20 10:35	2026-08-20 10:35	2026-08-20 10:35	XLV	XLV270115P00170000	put	170.0000	2027-01-15	5.6000	5.1500	5.7000	173.8370	18480.00	5600.00	12880.00	33	7	33	856	0.0385514018691589	0.19559913795342	0.195573259863032	true	false	false	true	false
027160f9-4930-4874-a2bf-448d3cd38287	2026-08-20 10:40	2026-08-20 10:40	2026-08-20 10:40	XLV	XLV260918C00180000	call	180.0000	2026-09-18	1.2600	1.2600	1.4000	173.7500	44856.00	0.00	44856.00	356	33	447	2143	0.208586094260383	0.169947476164114	0.169947476164114	false	false	false	true	false
7b3b6e1c-10fb-49a2-9d60-10f20b61cbd3	2026-08-20 12:31	2026-08-20 12:31	2026-08-20 12:31	XLV	XLV260918P00170000	put	170.0000	2026-09-18	1.4000	1.2800	1.4200	174.3450	16240.00	5320.00	10920.00	116	18	580	178	3.25842696629213	0.169152470831462	0.169152470831462	false	false	false	true	false
67acf845-f14b-4d33-91c3-6d0ca3f5ea3c	2026-08-20 12:52	2026-08-20 12:51	2026-08-20 12:51	XLV	XLV270319C00170000	call	170.0000	2027-03-19	13.8700	13.1500	13.9000	174.4900	773900.00	719880.00	54020.00	558	29	559	731	0.764705882352941	0.1770655782544	0.176442986472943	true	false	false	true	false
d421964f-8175-4222-9f36-b93154844347	2026-08-20 13:28	2026-08-20 13:28	2026-08-20 13:28	XLV	XLV270617C00180000	call	180.0000	2027-06-17	10.2000	10.1500	11.5000	173.6800	13260.00	12240.00	1020.00	13	6	34	1629	0.0208717004297115	0.16581677779492	0.16581677779492	false	false	false	true	false
a3d694fa-87b1-48c2-93f3-fc6ba61efa81	2026-08-20 13:45	2026-08-20 13:45	2026-08-20 13:45	XLV	XLV260821C00160000	call	160.0000	2026-08-21	13.8500	13.8500	15.0000	173.7450	13850.00	0.00	2770.00	10	10	16	1630	0.0098159509202454	0.84404859539246	0.84404859539246	false	false	false	true	false
ffdf53bd-1761-4254-8e1e-c461c156acc4	2026-08-20 14:09	2026-08-20 14:09	2026-08-20 14:09	XLV	XLV260918C00180000	call	180.0000	2026-09-18	1.2400	1.2400	1.3500	173.7900	213776.00	0.00	213776.00	1724	33	2234	2143	1.04246383574428	0.168030036700268	0.168030036700268	false	false	false	true	false
17f686f0-267f-4214-bea3-29da7dffb1bd	2026-08-20 14:24	2026-08-20 14:24	2026-08-20 14:24	XLV	XLV260904P00169000	put	169.0000	2026-09-04	0.7700	0.7700	0.8000	173.6100	14399.00	0.00	14399.00	187	18	215	246	0.873983739837398	0.179264005690359	0.179264005690359	false	false	false	true	false
6dd8ae8d-9778-48a8-adfa-1f3fafa548a8	2026-08-20 15:23	2026-08-20 15:23	2026-08-20 15:23	XLV	XLV261218C00159000	call	159.0000	2026-12-18	17.3500	17.3500	17.4000	173.0200	588328.00	0.00	588328.00	339	28	340	14	24.2857142857143	0.166857639192076	0.166857639192076	false	false	false	true	false
57b9e96e-c077-4a77-8b58-001182f1035a	2026-08-21 09:34	2026-08-21 09:34	2026-08-21 09:34	XLV	XLV260911C00170000	call	170.0000	2026-09-11	4.7000	3.9500	4.7000	172.7800	13630.00	13630.00	0.00	29	9	29	31	0.935483870967742	0.174081384322402	0.174081384322402	true	false	false	true	false
238d0ceb-8dd3-49f8-bbb1-f252d34eec2b	2026-08-21 10:07	2026-08-21 10:07	2026-08-21 10:07	XLV	XLV260904C00173000	call	173.0000	2026-09-04	3.2000	2.1000	3.2000	174.2500	10875.00	10875.00	0.00	34	21	34	15	2.26666666666667	0.175122241141795	0.175122241141795	true	false	false	true	false