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

uw_flow_alerts281,039 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

de33a130-fd7e-458f-9919-c6fecf302511	2026-08-17 10:04	2026-08-17 10:04	2026-08-17 10:04	XLV	XLV260828P00167000	put	167.0000	2026-08-28	1.5300	1.5200	2.3700	167.2300	18817.00	156.00	18661.00	123	26	123	35	3.51428571428571	0.149755223352611	0.152360982650259	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-17T14:09:25.911404Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4ee958c7-3f46-4b5e-aa43-6b78f1de981e	2026-08-17 10:59	2026-08-17 10:59	2026-08-17 10:59	XLV	XLV260918C00171000	call	171.0000	2026-09-18	1.6400	1.6400	1.8000	167.4500	21649.00	0.00	21649.00	132	11	176	687	0.256186317321689	0.144768083962166	0.144768083962166	true	false	false	true	false
8729f2ae-a0a1-4fbc-93b7-0a98c44775d3	2026-08-17 11:12	2026-08-17 11:12	2026-08-17 11:12	XLV	XLV260918P00164000	put	164.0000	2026-09-18	1.4000	1.3100	1.4000	167.3600	18900.00	18900.00	0.00	135	26	138	205	0.673170731707317	0.151063295763091	0.151063295763091	false	false	false	true	false
03c4168f-4aa7-42bc-ac25-511c99d47352	2026-08-17 11:23	2026-08-17 11:23	2026-08-17 11:23	XLV	XLV260918P00164000	put	164.0000	2026-09-18	1.3700	1.3000	1.3700	167.5150	13837.00	13837.00	0.00	101	26	239	205	1.16585365853659	0.151928580527007	0.151928580527007	false	false	false	true	false
81f57b36-f804-4704-bfeb-6714d20309e1	2026-08-17 11:33	2026-08-17 11:33	2026-08-17 11:33	XLV	XLV260821C00168000	call	168.0000	2026-08-21	0.9400	0.7600	1.1400	167.5800	12785.00	94.00	12691.00	136	31	141	4581	0.0307793058284217	0.155948444723196	0.157910587708627	true	false	false	true	false
74a84946-791c-4f3a-9cf5-06a953fd923e	2026-08-17 11:52	2026-08-17 11:52	2026-08-17 11:52	XLV	XLV260918P00162000	put	162.0000	2026-09-18	0.9100	0.8100	0.9100	167.4300	13195.00	13195.00	0.00	145	29	231	503	0.459244532803181	0.154212589128606	0.154212589128606	false	false	false	true	false
529271ac-0e40-4ac7-9a15-4affe927b587	2026-08-17 12:00	2026-08-17 12:00	2026-08-17 12:00	XLV	XLV260918P00160000	put	160.0000	2026-09-18	0.5900	0.5300	0.5900	167.3300	13688.00	13688.00	0.00	232	31	311	2454	0.126731866340668	0.156911166227816	0.156911166227816	false	false	false	true	false
04d00e3f-c31a-46ac-8878-ffd21dd0ba4d	2026-08-17 12:07	2026-08-17 12:07	2026-08-17 12:07	XLV	XLV261218P00150000	put	150.0000	2026-12-18	1.1600	1.1600	1.3000	167.4700	13688.00	0.00	13688.00	118	31	123	13041	0.00943179204048769	0.190761161623167	0.190761161623167	false	false	false	true	false
86c33263-2d6a-485d-88d1-b5b6ae37087d	2026-08-17 12:38	2026-08-17 12:37	2026-08-17 12:37	XLV	XLV270115C00175000	call	175.0000	2027-01-15	4.7000	4.5500	4.8000	167.7100	11750.00	2350.00	9400.00	25	7	54	6413	0.00842039607048183	0.153545646961247	0.153545646961247	false	false	false	true	false
c41d7cce-e896-462c-83e0-eafa64e79171	2026-08-17 12:52	2026-08-17 12:52	2026-08-17 12:52	XLV	XLV270115C00169000	call	169.0000	2027-01-15	7.3500	7.2000	7.4500	167.6800	11760.00	2940.00	8820.00	16	6	39	795	0.0490566037735849	0.154488969542783	0.154488969542783	false	false	false	true	false
c6425104-43c2-42f5-a474-d348f0da0b77	2026-08-17 13:24	2026-08-17 13:24	2026-08-17 13:24	XLV	XLV260821C00160000	call	160.0000	2026-08-21	7.5000	7.5000	7.9000	167.4100	10500.00	0.00	10500.00	14	12	18	1554	0.0115830115830116	0.208526035155763	0.208526035155763	true	false	false	true	false
9194105f-70e4-47c9-9eeb-70358e9ebdeb	2026-08-17 13:37	2026-08-17 13:37	2026-08-17 13:37	XLV	XLV260925C00169000	call	169.0000	2026-09-25	2.5900	2.3900	2.8600	167.1450	17094.00	259.00	16835.00	66	20	76	1	76	0.143555657583212	0.143555657583212	true	false	false	true	false
bd243d9c-f721-42ab-8275-45f051d52294	2026-08-17 13:58	2026-08-17 13:58	2026-08-17 13:58	XLV	XLV260918P00166000	put	166.0000	2026-09-18	2.1300	2.0100	2.1300	167.0000	19596.00	19596.00	0.00	92	28	92	79	1.16455696202532	0.149645638247184	0.149645638247184	false	false	false	true	false
9754fe77-24ad-43d0-bdde-face1b5024f8	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	XLV	XLV260918P00166000	put	166.0000	2026-09-18	2.1100	2.0100	2.1100	167.2800	27008.00	27008.00	0.00	128	28	220	79	2.78481012658228	0.149423605741794	0.149423605741794	false	false	false	true	false
6edd9987-a944-4448-94e7-32fdb48471e5	2026-08-17 14:52	2026-08-17 14:51	2026-08-17 14:51	XLV	XLV260918P00171000	put	171.0000	2026-09-18	5.0000	4.7000	5.0500	166.9900	15500.00	15500.00	0.00	31	7	35	19	1.84210526315789	0.148971154988481	0.148971154988481	false	false	false	true	false
5398e135-9571-48aa-b5c1-eb4d161372e8	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	XLV	XLV260918C00175000	call	175.0000	2026-09-18	1.2000	1.0600	1.2000	169.0000	130800.00	130800.00	0.00	1090	33	1105	7006	0.157721952612047	0.152085665796771	0.152085665796771	false	false	false	true	false
ae5b1f0d-ad57-40cd-a66b-b0448bd62539	2026-08-18 09:58	2026-08-18 09:58	2026-08-18 09:58	XLV	XLV260821C00166000	call	166.0000	2026-08-21	4.1000	4.1000	4.6000	170.1200	41000.00	0.00	41000.00	100	10	104	427	0.243559718969555	0.294993247110256	0.294993247110256	false	false	false	true	false
b54e1b97-fc38-48a3-8e79-17ca5a6ed692	2026-08-18 10:03	2026-08-18 10:03	2026-08-18 10:03	XLV	XLV261002C00167500	call	167.5000	2026-10-02	5.0500	5.0000	5.6500	169.5800	39900.00	10610.00	29290.00	79	17	80	0	0	0.144669763447182	0.145534381243494	false	false	false	true	false
2866cf6c-f6b8-45b7-a382-f4540b1f7b17	2026-08-18 10:44	2026-08-18 10:44	2026-08-18 10:44	XLV	XLV260904C00165000	call	165.0000	2026-09-04	5.8000	5.4500	5.8000	169.7900	12760.00	12760.00	0.00	22	6	23	13	1.76923076923077	0.171697210187754	0.171697210187754	true	false	false	true	false
89057ca9-ceab-470f-90a7-df135c1bc938	2026-08-18 11:05	2026-08-18 11:04	2026-08-18 11:04	XLV	XLV270115C00180000	call	180.0000	2027-01-15	3.6000	3.3500	3.8000	169.9400	45000.00	7560.00	37440.00	125	18	193	9204	0.0209691438504998	0.148105762095439	0.148105762095439	false	false	false	true	false
4bf072af-12e8-4c0a-bd54-8eb711b76310	2026-08-18 11:33	2026-08-18 11:33	2026-08-18 11:33	XLV	XLV260904P00169000	put	169.0000	2026-09-04	1.8000	1.7500	1.8000	169.8000	14220.00	14220.00	0.00	79	18	225	1	225	0.158364850670331	0.158364850670331	false	false	false	true	false
c712f323-f3f7-497e-89a3-28a9e8f95c5f	2026-08-18 11:52	2026-08-18 11:52	2026-08-18 11:52	XLV	XLV261218P00163000	put	163.0000	2026-12-18	3.2500	3.2500	3.4000	170.0400	10075.00	0.00	10075.00	31	10	120	290	0.413793103448276	0.180631825991711	0.180631825991711	false	false	false	true	false
8c62fb52-3f0e-4065-9011-e56f52836c1e	2026-08-18 11:58	2026-08-18 11:58	2026-08-18 11:58	XLV	XLV261218P00170000	put	170.0000	2026-12-18	5.9800	5.7000	6.2500	169.8300	149500.00	149500.00	0.00	250	2	252	404	0.623762376237624	0.1788875906589	0.1788875906589	false	true	true	false	false
94283ee9-d36c-423c-ba3b-1ae6385c8edc	2026-08-18 12:00	2026-08-18 12:00	2026-08-18 12:00	XLV	XLV260918P00175000	put	175.0000	2026-09-18	6.0500	5.7000	6.0500	169.8200	18755.00	18755.00	0.00	31	6	31	12	2.58333333333333	0.161594907785223	0.161594907785223	false	false	false	true	false
e144af90-ceed-438e-82ec-823706dd9eee	2026-08-18 12:24	2026-08-18 12:24	2026-08-18 12:24	XLV	XLV260821P00168000	put	168.0000	2026-08-21	0.4000	0.3500	0.4100	169.8950	11792.00	11512.00	0.00	295	18	321	124	2.58870967741935	0.182184345762755	0.182184345762755	false	false	false	true	false
a71fb2d4-a4cc-4d3c-9089-d62179edb9f5	2026-08-18 12:36	2026-08-18 12:36	2026-08-18 12:36	XLV	XLV261218P00158000	put	158.0000	2026-12-18	2.1000	2.1000	2.2000	170.0200	26880.00	0.00	26880.00	128	19	1015	6	169.166666666667	0.186521522355539	0.186521522355539	false	false	false	true	false
dec263cb-e933-449f-bc0d-9465f7db85bf	2026-08-18 13:47	2026-08-18 13:47	2026-08-18 13:47	XLV	XLV260918C00170000	call	170.0000	2026-09-18	3.4000	3.3500	3.4000	169.7800	28560.00	28560.00	0.00	84	6	420	12969	0.0323849178811011	0.163908906784777	0.163908906784777	false	false	false	true	false
c222de46-2fb0-41b9-94ab-7cc0823a19b1	2026-08-18 14:00	2026-08-18 13:59	2026-08-18 13:59	XLV	XLV261016C00170000	call	170.0000	2026-10-16	4.6000	4.6000	4.7000	169.7750	98900.00	0.00	98900.00	215	32	289	432	0.668981481481482	0.153766422436912	0.153766422436912	false	false	false	true	false
cf4478a0-defd-4573-b5c6-61536083db28	2026-08-18 14:22	2026-08-18 14:22	2026-08-18 14:22	XLV	XLV261218P00150000	put	150.0000	2026-12-18	0.9200	0.9200	1.0500	169.9100	23184.00	0.00	23184.00	252	31	361	13043	0.0276776815149889	0.192879644721748	0.192879644721748	false	false	false	true	false
3f32e729-649b-45c3-84ea-a213bcc0ea42	2026-08-18 14:27	2026-08-18 14:27	2026-08-18 14:27	XLV	XLV261218P00150000	put	150.0000	2026-12-18	0.9400	0.9400	1.0500	169.9550	14946.00	0.00	14946.00	159	28	520	13043	0.0398681284980449	0.19431036968527	0.19431036968527	false	false	false	true	false
42810e0a-83e2-4b2e-8b18-8d906079ae7e	2026-08-18 14:54	2026-08-18 14:54	2026-08-18 14:54	XLV	XLV261218P00158000	put	158.0000	2026-12-18	2.0000	2.0000	2.1800	170.0101	81800.00	0.00	81800.00	409	38	1837	6	306.166666666667	0.182747435387218	0.182747435387218	false	false	false	true	false
e5f17131-020f-4b51-8697-babcd82448bd	2026-08-18 15:43	2026-08-18 15:43	2026-08-18 15:43	XLV	XLV261218P00160000	put	160.0000	2026-12-18	2.4900	2.4900	2.5300	169.8050	62001.00	0.00	62001.00	249	17	269	7285	0.0369251887439945	0.181707851780379	0.181707851780379	false	false	false	true	false
e64dab77-2f37-4eed-a5f9-b39903c3141f	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	XLV	XLV260904C00174000	call	174.0000	2026-09-04	2.2900	1.3700	2.4800	173.4600	12824.00	12824.00	0.00	56	14	56	9	6.22222222222222	0.166493640023388	0.166493640023388	true	false	false	true	false
24cf07ae-b5b2-452c-a5db-68d61c10406a	2026-08-19 09:38	2026-08-19 09:38	2026-08-19 09:38	XLV	XLV260828C00175000	call	175.0000	2026-08-28	1.5700	0.8200	1.6100	174.1600	35986.00	35830.00	0.00	229	36	231	22	10.5	0.172829575235312	0.17652589478386	true	false	false	true	false
755f90db-8ac7-4092-9acd-788dececb5ee	2026-08-19 09:44	2026-08-19 09:44	2026-08-19 09:44	XLV	XLV261002P00172500	put	172.5000	2026-10-02	3.1000	2.6700	3.1000	174.6100	103230.00	103230.00	0.00	333	22	333	0	0	0.18347559406765	0.18347559406765	true	false	false	true	false
494392ae-64c0-4428-b90c-6cb7304ce030	2026-08-19 09:47	2026-08-19 09:47	2026-08-19 09:47	XLV	XLV261016C00190000	call	190.0000	2026-10-16	0.6900	0.0700	0.6900	175.1900	19113.00	19113.00	0.00	277	27	277	3	92.3333333333333	0.160576925320413	0.160576925320413	true	false	false	true	false
502d4d2d-725a-43ed-844d-46a14798069e	2026-08-19 09:47	2026-08-19 09:47	2026-08-19 09:47	XLV	XLV270115C00190000	call	190.0000	2027-01-15	3.1000	2.7800	3.1500	175.1800	108495.00	108495.00	0.00	350	12	372	2922	0.127310061601643	0.164374540342995	0.164374540342995	false	false	false	true	false
89f14642-b775-4116-8805-16b7dc2cca1a	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	XLV	XLV260904C00181000	call	181.0000	2026-09-04	0.6900	0.6800	0.8900	175.4500	18078.00	16353.00	1725.00	262	16	264	1	264	0.166725271761218	0.166725271761218	false	false	false	true	false
2acc36f9-9809-4206-b730-86d3c3832dce	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	XLV	XLV270115C00190000	call	190.0000	2027-01-15	3.1000	2.8500	3.3000	175.2000	56730.00	29760.00	26970.00	183	31	579	2922	0.198151950718686	0.163774890709983	0.164224481119616	true	false	false	true	false
cf557cd3-e62c-4e81-98bf-eae0276be931	2026-08-19 09:50	2026-08-19 09:50	2026-08-19 09:50	XLV	XLV270115C00190000	call	190.0000	2027-01-15	3.1000	2.8400	3.1500	175.2100	23870.00	1550.00	22320.00	77	5	656	2922	0.224503764544832	0.164149441314275	0.164149441314275	true	false	false	true	false
1a030772-5b1c-489d-a5f8-c527aa0ca54d	2026-08-19 09:54	2026-08-19 09:54	2026-08-19 09:54	XLV	XLV270115C00157000	call	157.0000	2027-01-15	22.0200	21.0000	22.5500	175.9400	574838.00	574838.00	0.00	261	17	301	14281	0.0210769553952804	0.151658910063591	0.151658910063591	false	false	false	true	false
0b6cedbe-f547-4721-8d2e-2c7358f26322	2026-08-19 09:55	2026-08-19 09:55	2026-08-19 09:55	XLV	XLV261218C00185000	call	185.0000	2026-12-18	4.3100	3.6000	4.4000	176.2200	11210.00	4325.00	6450.00	26	6	49	218	0.224770642201835	0.170779615604262	0.172076057291811	true	false	false	true	false
ee0bddd8-ac2b-44d3-904f-b8e0bf8b6ed1	2026-08-19 09:56	2026-08-19 09:56	2026-08-19 09:56	XLV	XLV270115C00195000	call	195.0000	2027-01-15	2.3800	2.2100	2.4100	176.1100	19029.00	18791.00	238.00	80	25	85	145	0.586206896551724	0.168223065194447	0.168223065194447	false	false	false	true	false
0468272e-9444-429a-ab64-46134ae64828	2026-08-19 09:57	2026-08-19 09:57	2026-08-19 09:57	XLV	XLV261218C00200000	call	200.0000	2026-12-18	1.2000	0.8000	1.3900	176.1700	179306.00	176160.00	3146.00	1494	50	1500	178	8.42696629213483	0.174337956505953	0.174781741103623	true	false	false	true	false
994d95d2-1de1-44e4-b5b1-f1b89c9b9d8b	2026-08-19 10:03	2026-08-19 10:03	2026-08-19 10:03	XLV	XLV260918P00175000	put	175.0000	2026-09-18	2.9600	2.9300	3.0500	175.7300	23680.00	4736.00	4736.00	80	5	129	43	3	0.177802596803045	0.177802596803045	false	false	false	true	false
e563d343-0e86-446e-bb3f-cc9a66784b32	2026-08-19 10:06	2026-08-19 10:06	2026-08-19 10:06	XLV	XLV260918C00170000	call	170.0000	2026-09-18	7.5000	7.4500	7.5000	175.6700	12750.00	2250.00	0.00	17	6	153	13284	0.0115176151761518	0.181419047794652	0.181419047794652	false	false	false	true	false
e55f0f43-0b1a-47e0-a783-c99281e4dfa8	2026-08-19 10:06	2026-08-19 10:06	2026-08-19 10:06	XLV	XLV260918C00170000	call	170.0000	2026-09-18	7.5000	7.5000	7.6000	175.6700	512291.00	0.00	512291.00	683	22	836	13284	0.0629328515507377	0.181419047794652	0.181419047794652	true	false	false	true	false
878906ed-f12d-46d4-b25f-dcfb5df7b516	2026-08-19 10:07	2026-08-19 10:07	2026-08-19 10:07	XLV	XLV261016C00175000	call	175.0000	2026-10-16	5.7000	5.4500	5.8500	175.7700	23370.00	10260.00	0.00	41	5	49	924	0.053030303030303	0.170108627274325	0.170108627274325	false	false	false	true	false
76bceef8-9c45-46e3-823b-71cb6289afa1	2026-08-19 10:07	2026-08-19 10:07	2026-08-19 10:07	XLV	XLV261016C00175000	call	175.0000	2026-10-16	5.7500	5.6500	5.7500	175.8105	28175.00	28175.00	0.00	49	5	117	924	0.126623376623377	0.171081237181294	0.171081237181294	false	false	false	true	false
404e3f72-16b8-4bed-9f6f-4a9ad7efec51	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	XLV	XLV260918C00190000	call	190.0000	2026-09-18	0.3500	0.3200	0.3500	176.3100	14035.00	14035.00	0.00	401	37	405	31	13.0645161290323	0.179464873612615	0.179464873612615	true	false	false	true	false