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	price

b9446387-069f-48d5-9c09-59ae4b8ef53c	2026-08-21 10:11	2026-08-21 10:11	2026-08-21 10:11	XLV	XLV260904C00179000	call	179.0000	2026-09-04	0.8700	0.5700	0.8700	174.4250	11739.00	11739.00	0.00	135	30	136	75	1.81333333333333	0.177250502429252	0.176320539463622	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	43575325654.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e4500c7e-5ba1-4976-9c00-d4a266c2bbf2	2026-08-21 10:27	2026-08-21 10:26	2026-08-21 10:26	XLV	XLV260918C00180000	call	180.0000	2026-09-18	1.5100	1.5100	1.7300	174.6700	14043.00	0.00	14043.00	93	14	311	4036	0.0770564915758176	0.172978957759278	0.172978957759278	true	false	false	true	false
0ee8acf8-a3d7-4f52-a9a4-8c8c904873a7	2026-08-21 10:27	2026-08-21 10:26	2026-08-21 10:26	XLV	XLV261016C00171000	call	171.0000	2026-10-16	7.1500	7.0500	7.5500	174.6700	20735.00	0.00	20735.00	29	9	29	0	0	0.164722945280332	0.162692303630402	true	false	false	true	false
67c058e4-585b-426d-a23a-21d3a71118d5	2026-08-21 10:33	2026-08-21 10:33	2026-08-21 10:33	XLV	XLV261002C00175000	call	175.0000	2026-10-02	3.9000	3.8500	4.4000	174.5700	31200.00	390.00	30810.00	80	24	100	57	1.75438596491228	0.158137877077707	0.158137877077707	true	false	false	true	false
a94e01c3-4d94-46a7-b58c-18552915e99e	2026-08-21 10:33	2026-08-21 10:33	2026-08-21 10:33	XLV	XLV261002C00175000	call	175.0000	2026-10-02	3.9000	3.8500	4.1500	174.5100	10530.00	3120.00	7410.00	27	7	144	57	2.52631578947368	0.159470091683298	0.159470091683298	false	false	false	true	false
24ab8fbc-595b-4bcc-8cca-1102e73dd615	2026-08-21 10:33	2026-08-21 10:33	2026-08-21 10:33	XLV	XLV261002C00175000	call	175.0000	2026-10-02	3.9500	3.8500	4.2000	174.5300	50955.00	0.00	50955.00	129	5	318	57	5.57894736842105	0.161147258889979	0.161147258889979	false	false	false	true	false
a1f952ac-9be3-4796-9866-b9b22be3bc3e	2026-08-21 11:06	2026-08-21 11:06	2026-08-21 11:06	XLV	XLV260821C00175000	call	175.0000	2026-08-21	0.8000	0.8000	0.8500	175.5600	112080.00	0.00	112080.00	1401	19	2075	2386	0.869656328583403	0.281151089606407	0.281151089606407	false	false	false	true	false
715874a1-7e6a-4353-8240-a09502502bdb	2026-08-21 11:17	2026-08-21 11:17	2026-08-21 11:17	XLV	XLV270115P00180000	put	180.0000	2027-01-15	9.5000	9.3500	9.9500	175.5200	70307.00	0.00	70307.00	74	10	149	0	0	0.193857045997733	0.193913961121588	false	false	false	true	false
6f1d130e-5ebe-448c-8136-3eb5e043a61a	2026-08-21 11:32	2026-08-21 11:32	2026-08-21 11:32	XLV	XLV260918C00175000	call	175.0000	2026-09-18	3.6500	3.5500	3.8500	175.2000	31750.00	365.00	31385.00	87	17	213	8056	0.0264399205561072	0.169670709678636	0.169953402823631	true	false	false	true	false
25838864-f877-48be-be43-90eb966c8788	2026-08-21 11:47	2026-08-21 11:47	2026-08-21 11:47	XLV	XLV260918C00185000	call	185.0000	2026-09-18	0.6600	0.5800	0.7400	175.3300	16921.00	15931.00	990.00	256	23	898	5962	0.150620597115062	0.175626683311784	0.174756442891762	false	false	false	true	false
6ccbb46f-2bae-43b0-b3af-fecc9b72fe2e	2026-08-21 12:06	2026-08-21 12:06	2026-08-21 12:06	XLV	XLV260828C00175000	call	175.0000	2026-08-28	1.7800	1.7100	1.8500	174.9900	37380.00	178.00	37202.00	210	14	241	284	0.848591549295775	0.178039082224125	0.178039082224125	false	false	false	true	false
d4e35e22-f415-4601-8e23-641e81db0e79	2026-08-21 12:36	2026-08-21 12:36	2026-08-21 12:36	XLV	XLV261016C00180000	call	180.0000	2026-10-16	2.8500	2.8500	3.0000	175.0350	10545.00	0.00	10545.00	37	8	87	238	0.365546218487395	0.164328475454609	0.164328475454609	false	false	false	true	false
4d516782-fafe-4122-9104-5ebbe43cbe5a	2026-08-21 12:43	2026-08-21 12:43	2026-08-21 12:43	XLV	XLV260918C00175000	call	175.0000	2026-09-18	3.4500	3.4500	3.5500	175.0400	62445.00	0.00	62445.00	181	16	424	8056	0.0526315789473684	0.164054110070717	0.164054110070717	false	false	false	true	false
63c8f8d0-5573-465d-b661-97a16bb34397	2026-08-21 13:05	2026-08-21 13:05	2026-08-21 13:05	XLV	XLV261120C00175000	call	175.0000	2026-11-20	6.9000	6.9000	7.2500	175.0200	44160.00	0.00	44160.00	64	8	67	3	22.3333333333333	0.173262577058741	0.173262577058741	true	false	false	true	false
874d6bfa-44a6-4806-9ee0-84cb4d17e6fc	2026-08-21 13:06	2026-08-21 13:06	2026-08-21 13:06	XLV	XLV261120C00175000	call	175.0000	2026-11-20	6.9000	6.6500	7.2000	175.0000	41400.00	28290.00	13110.00	60	8	146	3	48.6666666666667	0.173588839436155	0.173588839436155	false	false	false	true	false
4d4f2a8c-342f-446f-a50e-b7caf86beb6c	2026-08-21 13:56	2026-08-21 13:56	2026-08-21 13:56	XLV	XLV261016C00175000	call	175.0000	2026-10-16	4.7500	4.7500	5.0000	174.7000	41800.00	0.00	41800.00	88	22	130	1004	0.129482071713147	0.160925027573784	0.160925027573784	false	false	false	true	false
148f43cc-ce87-471f-9bc7-a4c35073c7c7	2026-08-21 14:25	2026-08-21 14:25	2026-08-21 14:25	XLV	XLV261218C00170000	call	170.0000	2026-12-18	10.6500	10.6500	10.9000	174.8250	96915.00	0.00	96915.00	91	29	93	1416	0.0656779661016949	0.168993744212787	0.168993744212787	false	false	false	true	false
bceca11c-4dc9-4a2e-a646-2ddef8811171	2026-08-21 14:43	2026-08-21 14:43	2026-08-21 14:43	XLV	XLV261218C00185000	call	185.0000	2026-12-18	3.6500	3.5000	3.9500	174.6150	182500.00	0.00	182500.00	500	1	504	1009	0.499504459861249	0.170857391254206	0.170857391254206	false	true	false	true	false
c7feb437-24eb-4e62-b2b6-21d9b424180b	2026-08-21 15:07	2026-08-21 15:07	2026-08-21 15:07	XLV	XLV261218P00185000	put	185.0000	2026-12-18	12.6300	12.6000	12.8500	174.6800	75768.00	0.00	75768.00	60	7	121	26	4.65384615384615	0.197098109778611	0.197098109778611	false	false	false	true	false
9a611480-7821-4e7c-a654-5cc371f6a09b	2026-08-21 15:53	2026-08-21 15:53	2026-08-21 15:53	XLV	XLV270115C00160000	call	160.0000	2027-01-15	18.3000	18.2000	18.6000	174.6550	64050.00	12810.00	51240.00	35	6	36	5796	0.0062111801242236	0.150698924568198	0.150698924568198	false	false	false	true	false
35228138-8852-4c68-9ca1-be812142b7ed	2026-08-24 09:46	2026-08-24 09:45	2026-08-24 09:45	XLV	XLV260911C00171000	call	171.0000	2026-09-11	5.3000	4.1500	5.3000	174.6750	18020.00	18020.00	0.00	34	10	34	6	5.66666666666667	0.187696165705178	0.187696165705178	true	false	false	true	false
33e444ad-8656-4a32-9812-3efc5f33710c	2026-08-24 09:57	2026-08-24 09:57	2026-08-24 09:57	XLV	XLV270115C00175000	call	175.0000	2027-01-15	8.4500	8.1500	8.9000	174.6300	28730.00	13520.00	15210.00	34	6	70	6425	0.0108949416342412	0.166230166964294	0.166230166964294	false	false	false	true	false
6c481f9c-40fb-4241-9ab0-e1b67322d480	2026-08-24 10:19	2026-08-24 10:19	2026-08-24 10:19	XLV	XLV260918P00170000	put	170.0000	2026-09-18	1.2500	1.1300	1.2900	174.5000	36000.00	5000.00	31000.00	288	15	347	1722	0.20150987224158	0.173596468627954	0.173596468627954	true	false	false	true	false
7a8ad520-07be-4376-9c23-c457a5456e19	2026-08-24 10:27	2026-08-24 10:26	2026-08-24 10:26	XLV	XLV261218C00175000	call	175.0000	2026-12-18	7.3500	7.3000	7.5000	173.9900	56595.00	0.00	56595.00	77	11	93	1298	0.0716486902927581	0.173439399997321	0.173439399997321	false	false	false	true	false
710c1b39-e970-4c5b-90bd-5295d15741e0	2026-08-24 10:48	2026-08-24 10:48	2026-08-24 10:48	XLV	XLV260918C00180000	call	180.0000	2026-09-18	1.0000	1.0000	1.0700	173.4400	133900.00	0.00	133900.00	1339	19	1391	4197	0.331427209911842	0.17115167959189	0.17115167959189	false	false	false	true	false
2ab87997-fc29-4678-8644-3e6ba549eebb	2026-08-24 15:27	2026-08-24 15:27	2026-08-24 15:27	XLV	XLV270617P00180000	put	180.0000	2027-06-17	12.2500	12.1500	12.6000	174.4600	13475.00	3675.00	9800.00	11	5	39	41	0.951219512195122	0.197648754640665	0.197648754640665	false	false	false	true	false
18e6c372-e8e6-435c-b640-c3f312b8a598	2026-08-24 15:55	2026-08-24 15:55	2026-08-24 15:55	XLV	XLV260918C00170000	call	170.0000	2026-09-18	6.4200	6.1000	6.5000	174.8550	14114.00	10914.00	640.00	22	5	47	11742	0.00400272525975132	0.170895110954742	0.169482630357132	false	false	false	true	false
5cdfc190-c4dd-46ef-9ed2-15bd3815330a	2026-08-25 10:19	2026-08-25 10:19	2026-08-25 10:19	XLV	XLV261218C00180000	call	180.0000	2026-12-18	5.5500	5.2500	5.7000	175.0800	19425.00	19425.00	0.00	35	16	42	349	0.120343839541547	0.172802228635749	0.172802228635749	false	false	false	true	false
ee53510f-8b24-472f-8447-fb5a7b232caf	2026-08-25 10:20	2026-08-25 10:20	2026-08-25 10:20	XLV	XLV261218C00180000	call	180.0000	2026-12-18	5.5500	5.2500	5.6500	175.1500	19425.00	7215.00	6105.00	35	5	77	349	0.220630372492837	0.171982274153856	0.171982274153856	false	false	false	true	false
75b7e0c0-0e6c-439b-a3be-6ffc7ebb9790	2026-08-25 10:32	2026-08-25 10:32	2026-08-25 10:32	XLV	XLV260918P00174000	put	174.0000	2026-09-18	2.4000	2.4000	3.0500	175.0100	24000.00	0.00	24000.00	100	5	101	101	1	0.172071652750771	0.172071652750771	true	false	false	true	false
6a31a5a7-df35-4934-98df-c9d457bfe96d	2026-08-25 11:43	2026-08-25 11:43	2026-08-25 11:43	XLV	XLV260828C00175000	call	175.0000	2026-08-28	1.4400	1.4400	1.5700	175.2900	46080.00	0.00	46080.00	320	21	356	448	0.794642857142857	0.198981175890038	0.198981175890038	false	false	false	true	false
97d78f6d-7e67-4ad6-a695-a00c92f7bcb4	2026-08-25 12:33	2026-08-25 12:33	2026-08-25 12:33	XLV	XLV260918P00170000	put	170.0000	2026-09-18	0.9600	0.9500	1.0000	175.4800	141312.00	0.00	141312.00	1472	17	1479	2109	0.701280227596017	0.172458381087373	0.172458381087373	false	false	false	true	false
12d8cc5e-a118-4373-b33d-f0eb82eec49e	2026-08-25 13:21	2026-08-25 13:21	2026-08-25 13:21	XLV	XLV260904P00175000	put	175.0000	2026-09-04	1.7000	1.7000	1.8100	175.4300	136850.00	0.00	136850.00	805	5	807	22	36.6818181818182	0.172166817457367	0.172166817457367	false	false	false	true	false
c4bb0251-ac84-4806-8d8f-688ea2cd1d12	2026-08-25 13:26	2026-08-25 13:26	2026-08-25 13:26	XLV	XLV261218C00180000	call	180.0000	2026-12-18	5.5000	5.4500	5.6000	175.3200	215600.00	550.00	215050.00	392	26	687	349	1.96848137535817	0.168704039677274	0.168704039677274	false	false	false	true	false
45e63719-3284-40a0-a882-1b35451a183b	2026-08-25 14:02	2026-08-25 14:02	2026-08-25 14:02	XLV	XLV261016P00169000	put	169.0000	2026-10-16	1.8700	1.6700	2.0900	175.0000	20011.00	188.00	19635.00	107	30	110	0	0	0.18344442413825	0.183919579825077	true	false	false	true	false
6f3f5472-40fc-4d59-b24f-9d04e7a796ae	2026-08-25 14:30	2026-08-25 14:30	2026-08-25 14:30	XLV	XLV261016P00170000	put	170.0000	2026-10-16	2.2200	2.2200	2.3500	175.5800	12654.00	0.00	12654.00	57	14	81	181	0.447513812154696	0.184385478884499	0.184385478884499	false	false	false	true	false
812bc804-8786-44bd-aa99-de0cc91f3b25	2026-08-25 14:45	2026-08-25 14:45	2026-08-25 14:45	XLV	XLV260918C00180000	call	180.0000	2026-09-18	1.2800	1.2200	1.3300	175.2900	65920.00	640.00	65280.00	515	10	582	5582	0.104263704765317	0.161520848407274	0.161520848407274	false	false	false	true	false
276c7c31-e769-44e9-a1a0-214e3eb45837	2026-08-25 14:51	2026-08-25 14:51	2026-08-25 14:51	XLV	XLV260911P00170000	put	170.0000	2026-09-11	0.6100	0.6100	0.6800	175.4050	58804.00	0.00	58804.00	964	17	1001	25	40.04	0.167537973150221	0.167537973150221	false	false	false	true	false
b8aeba7f-f6dc-4517-a0ff-d82722ee6099	2026-08-25 15:07	2026-08-25 15:07	2026-08-25 15:07	XLV	XLV261016C00180000	call	180.0000	2026-10-16	2.7500	2.6500	2.9700	175.3400	23650.00	0.00	23375.00	86	18	105	279	0.376344086021505	0.162977759899471	0.162977759899471	true	false	false	true	false
4615ef68-0de9-44bd-9fc4-4e706e76cd4f	2026-08-25 15:16	2026-08-25 15:16	2026-08-25 15:16	XLV	XLV261016C00175000	call	175.0000	2026-10-16	4.9000	4.9000	5.1500	175.3700	103390.00	0.00	103390.00	211	8	260	995	0.261306532663317	0.160049769735438	0.160049769735438	false	false	false	true	false
9cb57428-52cf-4bad-98ba-c1dc0ddf0677	2026-08-25 15:35	2026-08-25 15:35	2026-08-25 15:35	XLV	XLV261016C00180000	call	180.0000	2026-10-16	2.7000	2.5900	2.9400	175.2100	26460.00	1620.00	24840.00	98	15	219	279	0.78494623655914	0.162937698349161	0.162937698349161	false	false	false	true	false
f0a32578-06d9-4a58-9c35-1feb9ceb101b	2026-08-25 15:35	2026-08-25 15:35	2026-08-25 15:35	XLV	XLV261016P00170000	put	170.0000	2026-10-16	2.2900	2.2900	2.4500	175.1800	226252.00	0.00	226252.00	988	14	1074	181	5.93370165745856	0.182402060263904	0.182402060263904	false	false	false	true	false
40b2fb00-8133-4abb-9471-b784c5cd16e1	2026-08-26 10:15	2026-08-26 10:15	2026-08-26 10:15	XLV	XLV261016C00180000	call	180.0000	2026-10-16	2.4000	2.4000	2.6100	174.6950	54960.00	0.00	54960.00	229	15	231	429	0.538461538461538	0.160181409534773	0.160181409534773	false	false	false	true	false
9a0b9064-db6d-44b0-9011-a9e7f04c5bc3	2026-08-26 11:30	2026-08-26 11:30	2026-08-26 11:30	XLV	XLV260918C00176000	call	176.0000	2026-09-18	2.0700	1.9900	2.1500	173.9000	43264.00	621.00	42643.00	209	8	221	7	31.5714285714286	0.161796584131038	0.161796584131038	false	false	false	true	false
294f90ed-e9df-468f-bb3a-5e092e7d7ffe	2026-08-26 12:46	2026-08-26 12:46	2026-08-26 12:46	XLV	XLV260918P00175000	put	175.0000	2026-09-18	3.2500	3.0500	3.2500	173.5600	16250.00	3250.00	0.00	50	9	50	351	0.142450142450142	0.155357064847581	0.155357064847581	false	false	false	true	false
44d23ec5-5757-43f1-9223-c54c30525ce4	2026-08-26 12:46	2026-08-26 12:46	2026-08-26 12:46	XLV	XLV260918P00175000	put	175.0000	2026-09-18	3.2500	3.2500	3.4000	173.5600	16250.00	0.00	16250.00	50	10	100	351	0.284900284900285	0.155357064847581	0.155357064847581	false	false	false	true	false
b27288b0-5cab-40bb-ab8e-ef7e11a1edfa	2026-08-26 13:06	2026-08-26 13:06	2026-08-26 13:06	XLV	XLV261002C00172000	call	172.0000	2026-10-02	4.8000	4.8000	5.0500	173.9250	101280.00	0.00	101280.00	211	20	270	20	13.5	0.152757853840852	0.152757853840852	false	false	false	true	false
c6fccdc2-407f-4b73-92df-fe1454016968	2026-08-26 15:43	2026-08-26 15:43	2026-08-26 15:43	XLV	XLV260918C00175000	call	175.0000	2026-09-18	2.3900	2.3700	2.6400	173.7100	50428.00	0.00	50428.00	211	15	231	7961	0.0290164552191936	0.161411236813959	0.159677330259476	false	false	false	true	false
f56c2f9f-cd40-45d4-8f94-64cf7b5c2dcb	2026-08-26 15:46	2026-08-26 15:46	2026-08-26 15:46	XLV	XLV261218C00175000	call	175.0000	2026-12-18	6.8500	6.6500	7.0500	173.8150	14390.00	1375.00	10275.00	21	12	34	1346	0.025260029717682	0.165356781651013	0.165005767316154	true	false	false	true	false
b9ac40e2-8af3-4a66-93fa-05463f30db23	2026-08-27 09:43	2026-08-27 09:42	2026-08-27 09:42	XLV	XLV270115P00170000	put	170.0000	2027-01-15	5.9000	5.4500	6.0500	171.9050	83780.00	9440.00	74340.00	142	18	158	925	0.170810810810811	0.188772217283492	0.188772217283492	false	false	false	true	false