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×

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

ea34881a-90fb-4f29-b342-83b15d1051eb	2026-09-03 15:24	2026-09-03 15:24	2026-09-03 15:24	XLV	XLV261009C00170000	call	170.0000	2026-10-09	5.1000	5.1000	5.5500	173.0001	20400.00	0.00	20400.00	40	12	40	0	0	0.13609055791524	0.13609055791524	true	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-09-03T19:29:59.445996Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6c0954c0-1b3a-4b99-ae17-b5aa6ca19f10	2026-09-03 14:52	2026-09-03 14:52	2026-09-03 14:52	XLV	XLV260918C00177000	call	177.0000	2026-09-18	0.7900	0.7500	0.8200	173.1900	31047.00	31047.00	0.00	393	8	395	94	4.20212765957447	0.14843983965299	0.14843983965299	false	false	false	true	false
2751fdd7-9780-4194-892c-afa287b94944	2026-09-03 12:18	2026-09-03 12:18	2026-09-03 12:18	XLV	XLV260904C00172500	call	172.5000	2026-09-04	0.8100	0.8100	1.2200	172.8300	32400.00	0.00	32400.00	400	8	804	39	20.6153846153846	0.172099624052149	0.172099624052149	false	false	false	true	false
90b9f0fa-6f18-4694-9283-ff3efca9df84	2026-09-03 11:40	2026-09-03 11:40	2026-09-03 11:40	XLV	XLV261016P00166000	put	166.0000	2026-10-16	1.3200	1.2800	1.3200	172.7192	89628.00	89628.00	0.00	679	6	701	82	8.54878048780488	0.172662326607252	0.172662326607252	false	false	false	true	false
85bc9e43-136c-4595-9a24-ebba5bf24f98	2026-09-03 11:10	2026-09-03 11:10	2026-09-03 11:10	XLV	XLV261002C00169000	call	169.0000	2026-10-02	5.2000	4.9000	5.5000	172.6650	104529.00	103999.00	530.00	201	24	201	0	0	0.135175430380364	0.141528209404901	true	false	false	true	false
2f72af72-e1ac-4520-b3a0-6e1c2823c18b	2026-09-03 10:44	2026-09-03 10:44	2026-09-03 10:44	XLV	XLV260911C00172500	call	172.5000	2026-09-11	1.3900	1.1800	1.3900	172.2000	19876.00	19876.00	0.00	143	20	149	27	5.51851851851852	0.14411176082219	0.14411176082219	true	false	false	true	false
172b7995-377d-407a-9d23-a3966c915e79	2026-09-02 15:43	2026-09-02 15:43	2026-09-02 15:43	XLV	XLV260904C00175000	call	175.0000	2026-09-04	0.2300	0.1800	0.2400	173.0500	39100.00	31280.00	7820.00	1700	15	2234	93	24.0215053763441	0.169795975573895	0.169795975573895	true	false	false	true	false
b7bbd8b8-b6a0-4451-aa86-df8c0e81d2f1	2026-09-02 15:10	2026-09-02 15:10	2026-09-02 15:10	XLV	XLV260904P00171000	put	171.0000	2026-09-04	0.1700	0.1300	0.1700	172.9400	39100.00	31280.00	0.00	2300	20	2312	288	8.02777777777778	0.156982466108312	0.156982466108312	false	false	false	true	false
e992b2fe-22b9-40b0-8954-7550c30b364f	2026-09-02 14:01	2026-09-02 14:00	2026-09-02 14:00	XLV	XLV261218P00175000	put	175.0000	2026-12-18	6.6000	6.6000	6.7500	173.0200	36300.00	0.00	36300.00	55	15	439	102	4.30392156862745	0.177291102343677	0.177291102343677	false	false	false	true	false
80380b1c-3640-41ce-93bc-1ffac2dd7689	2026-09-02 13:56	2026-09-02 13:56	2026-09-02 13:56	XLV	XLV261218P00175000	put	175.0000	2026-12-18	6.6000	6.6000	6.7500	173.0000	28380.00	0.00	28380.00	43	11	384	102	3.76470588235294	0.177033872147171	0.177033872147171	false	false	false	true	false
d48e5e91-efd3-466f-979f-ee2c6ae073c1	2026-09-02 13:11	2026-09-02 13:11	2026-09-02 13:11	XLV	XLV261218P00175000	put	175.0000	2026-12-18	6.5500	6.5500	6.7500	173.0600	108731.00	0.00	108731.00	166	35	339	102	3.32352941176471	0.176465252461696	0.176465252461696	false	false	false	true	false
35f11813-7ed1-44f0-a7aa-bfd8fc4b4201	2026-09-02 13:03	2026-09-02 13:03	2026-09-02 13:03	XLV	XLV261218P00175000	put	175.0000	2026-12-18	6.5500	6.5500	6.6500	173.0500	76635.00	0.00	76635.00	117	27	171	102	1.67647058823529	0.176336923750612	0.176336923750612	false	false	false	true	false
6339cc83-ddac-4c02-8c2f-7390ad67d686	2026-09-02 12:48	2026-09-02 12:48	2026-09-02 12:48	XLV	XLV261218P00175000	put	175.0000	2026-12-18	6.6500	6.6500	6.8000	172.9000	33915.00	0.00	33915.00	51	15	53	102	0.519607843137255	0.177083476360114	0.177083476360114	false	false	false	true	false
fd5044e1-24ea-4d38-add5-b6828936079e	2026-09-02 12:27	2026-09-02 12:26	2026-09-02 12:26	XLV	XLV270115P00166000	put	166.0000	2027-01-15	3.7100	3.3500	3.7500	172.8450	12245.00	3365.00	8880.00	33	10	33	246	0.134146341463415	0.180238565431524	0.180238565431524	true	false	false	true	false
d5f4d095-a536-4607-99ed-6e68a9778a83	2026-09-02 12:17	2026-09-02 12:17	2026-09-02 12:17	XLV	XLV261120P00155000	put	155.0000	2026-11-20	0.5600	0.5600	0.6000	172.8800	47376.00	0.00	47376.00	846	31	1667	2792	0.597063037249284	0.185556320251414	0.185623214572631	false	false	false	true	false
a93c9d96-ec21-4cfc-b9a1-b8e2039fc5b9	2026-09-02 11:39	2026-09-02 11:38	2026-09-02 11:38	XLV	XLV261120P00155000	put	155.0000	2026-11-20	0.5700	0.4200	0.7000	173.1700	46626.00	57.00	46569.00	818	22	818	2792	0.29297994269341	0.188397610394895	0.188397610394895	false	false	false	true	false
56f7e4e6-3599-44e0-ab8b-960b24a5bb1c	2026-09-02 11:28	2026-09-02 11:28	2026-09-02 11:28	XLV	XLV260918C00175000	call	175.0000	2026-09-18	1.6000	1.4700	1.6000	173.3800	14879.00	14720.00	159.00	93	18	386	7621	0.0506495210602283	0.151291376501179	0.151291376501179	true	false	false	true	false
ed9e3c32-c57c-4cc9-a493-26f01db794fd	2026-09-02 11:23	2026-09-02 11:23	2026-09-02 11:23	XLV	XLV261218P00165000	put	165.0000	2026-12-18	2.6200	2.6200	2.8700	173.3050	12576.00	0.00	12576.00	48	14	199	1901	0.104681746449237	0.17870229274411	0.17870229274411	false	false	false	true	false
ee0c4298-ed5e-40a9-8b64-e12941657ee8	2026-09-02 11:05	2026-09-02 11:05	2026-09-02 11:05	XLV	XLV261218P00165000	put	165.0000	2026-12-18	2.6600	2.6600	2.9100	173.2300	40166.00	0.00	40166.00	151	31	151	1901	0.079431877958969	0.1794129740638	0.1794129740638	false	false	false	true	false
9bb0833e-c950-4278-b76a-3e656cc96cfd	2026-09-02 10:55	2026-09-02 10:55	2026-09-02 10:55	XLV	XLV260918C00175000	call	175.0000	2026-09-18	1.5700	1.5500	1.7000	173.1401	10833.00	315.00	10518.00	69	20	265	7621	0.0347723395879806	0.156139887426483	0.156060247645869	true	false	false	true	false
a1ff4cea-f0a0-4769-81f0-ff1e1f74eba1	2026-09-02 10:03	2026-09-02 10:03	2026-09-02 10:03	XLV	XLV261016P00165000	put	165.0000	2026-10-16	1.0300	0.9500	1.1300	174.2900	115257.00	103.00	115154.00	1119	27	1120	2583	0.43360433604336	0.184313686645036	0.184313686645036	false	false	false	true	false
273ea979-e0f7-453f-adac-467e2ba1a75f	2026-09-02 09:47	2026-09-02 09:47	2026-09-02 09:47	XLV	XLV260918C00174000	call	174.0000	2026-09-18	2.4400	2.4400	2.7500	173.8000	16593.00	0.00	16593.00	68	18	75	3	25	0.164895476629736	0.165584701190871	true	false	false	true	false
cd1d8579-6f96-4ad8-b8c8-b6b05c3f34ab	2026-09-02 09:36	2026-09-02 09:36	2026-09-02 09:36	XLV	XLV261016C00175000	call	175.0000	2026-10-16	3.4500	2.7100	3.5000	173.8200	10350.00	8650.00	1700.00	30	5	50	921	0.0542888165038002	0.152616250831973	0.148462404017659	false	false	false	true	false
e60611e1-b950-4e97-9f71-56aee53b356e	2026-09-02 09:35	2026-09-02 09:35	2026-09-02 09:35	XLV	XLV260918C00175000	call	175.0000	2026-09-18	1.8000	1.5600	1.8000	173.6500	14219.00	14219.00	0.00	79	10	100	7621	0.01312163758037	0.157335575157794	0.157335575157794	true	false	false	true	false
a729d56c-f5f2-4157-b339-76cb3b86c1bd	2026-09-02 09:35	2026-09-02 09:35	2026-09-02 09:35	XLV	XLV260904C00175000	call	175.0000	2026-09-04	0.4500	0.0700	0.4700	173.5700	19587.00	19587.00	0.00	435	28	435	93	4.67741935483871	0.193402129142839	0.197928072406556	true	false	false	true	false
356efe63-f90e-4e6b-8d00-266c0386029d	2026-09-01 14:32	2026-09-01 14:32	2026-09-01 14:32	XLV	XLV270319C00190000	call	190.0000	2027-03-19	2.9200	2.6300	2.9200	171.5250	58399.00	58399.00	0.00	200	19	1515	657	2.30593607305936	0.154570686830412	0.154570686830412	false	false	false	true	false
685c39c9-6dea-42e0-b257-7786804d7fd0	2026-09-01 14:31	2026-09-01 14:31	2026-09-01 14:31	XLV	XLV270319C00190000	call	190.0000	2027-03-19	2.9400	2.6200	2.9400	171.6000	58800.00	58800.00	0.00	200	17	1146	657	1.74429223744292	0.154579989735188	0.154579989735188	false	false	false	true	false
f61ac0e4-991a-46e5-9193-2424027a11dd	2026-09-01 14:30	2026-09-01 14:30	2026-09-01 14:30	XLV	XLV270319C00190000	call	190.0000	2027-03-19	2.9500	2.6200	2.9500	171.5850	59000.00	59000.00	0.00	200	23	846	657	1.28767123287671	0.15491751215151	0.15491751215151	false	false	false	true	false
fb4ca5ed-a895-4ad4-9e20-4eff468a1e2b	2026-09-01 14:29	2026-09-01 14:28	2026-09-01 14:28	XLV	XLV270319C00190000	call	190.0000	2027-03-19	2.9600	2.7000	2.9600	171.6000	29562.00	29562.00	0.00	100	25	405	657	0.616438356164384	0.155064168845517	0.154822169467747	true	false	false	true	false
def73369-c160-454a-8e60-4e97b2c9dfce	2026-09-01 14:28	2026-09-01 14:28	2026-09-01 14:28	XLV	XLV270319C00190000	call	190.0000	2027-03-19	3.0000	2.6400	3.0000	171.6100	29980.00	29980.00	0.00	100	25	301	657	0.458143074581431	0.155966593620015	0.155483929086465	true	false	false	true	false
ca8378b3-ed1b-435f-918e-9d583d5a2390	2026-09-01 14:27	2026-09-01 14:27	2026-09-01 14:27	XLV	XLV270319C00190000	call	190.0000	2027-03-19	3.0000	2.6000	3.0000	171.6200	14994.00	14994.00	0.00	50	16	100	657	0.15220700152207	0.15590279814637	0.155420223089234	false	false	false	true	false
04f2ecb0-ed7d-4637-a501-8ba72e456048	2026-09-01 13:42	2026-09-01 13:42	2026-09-01 13:42	XLV	XLV261120P00150000	put	150.0000	2026-11-20	0.3300	0.3100	0.5100	171.5100	16072.00	33.00	16039.00	487	40	488	8	61	0.190275199020791	0.190275199020791	false	false	false	true	false
e49d16c8-4a8c-40a7-82c7-ca08609fb2cd	2026-09-01 13:30	2026-09-01 13:30	2026-09-01 13:30	XLV	XLV261016P00165000	put	165.0000	2026-10-16	1.5500	1.3600	1.5500	171.3000	15035.00	15035.00	0.00	97	10	347	2282	0.152059596844873	0.177521847417731	0.177521847417731	false	false	false	true	false
ec264e1c-d4e7-4c9d-82ca-67a7c17e1d07	2026-09-01 11:36	2026-09-01 11:36	2026-09-01 11:36	XLV	XLV261120P00165000	put	165.0000	2026-11-20	2.2700	2.2000	2.2900	171.8500	15665.00	15665.00	0.00	69	7	1220	2474	0.493128536782538	0.17339231947217	0.17339231947217	true	false	false	true	false
eecda1e8-8251-4ac0-8836-4e0bccb1a914	2026-09-01 11:31	2026-09-01 11:31	2026-09-01 11:31	XLV	XLV261120P00165000	put	165.0000	2026-11-20	2.4000	2.3500	2.6500	171.7900	120249.00	239.00	120010.00	501	7	566	2474	0.228779304769604	0.178997477490473	0.177378315974466	false	false	false	true	false
76762ff3-d593-4cee-a3bb-953043beb80f	2026-09-01 11:13	2026-09-01 11:12	2026-09-01 11:12	XLV	XLV260904P00170000	put	170.0000	2026-09-04	0.4400	0.4200	0.4400	171.5600	11176.00	11176.00	0.00	254	18	256	385	0.664935064935065	0.171090482848432	0.171090482848432	false	false	false	true	false
64c7b1a5-fb9b-418d-ada8-af2ce97255f8	2026-09-01 11:01	2026-09-01 11:01	2026-09-01 11:01	XLV	XLV261120C00170000	call	170.0000	2026-11-20	6.5500	6.5500	6.9000	171.4400	23580.00	0.00	23580.00	36	12	56	35	1.6	0.156622113926482	0.156622113926482	false	false	false	true	false
7dba1d80-807f-4dd2-ae84-0408dd537045	2026-09-01 10:52	2026-09-01 10:52	2026-09-01 10:52	XLV	XLV270319C00180000	call	180.0000	2027-03-19	6.2000	5.8000	6.5500	171.5800	49600.00	4960.00	620.00	80	18	83	3504	0.0236872146118721	0.160414691465889	0.160414691465889	false	false	false	true	false
b21cab74-924b-4993-8495-f79b98b52e64	2026-09-01 10:39	2026-09-01 10:38	2026-09-01 10:38	XLV	XLV261120P00170000	put	170.0000	2026-11-20	4.1000	4.1000	4.3500	171.9300	69700.00	0.00	69700.00	170	33	379	29	13.0689655172414	0.177109630531481	0.177109630531481	false	false	false	true	false
8a49feb5-7c29-4fc2-9e24-48a0f9931a6f	2026-09-01 10:25	2026-09-01 10:25	2026-09-01 10:25	XLV	XLV261120P00170000	put	170.0000	2026-11-20	4.0500	4.0000	4.2500	172.1700	21060.00	0.00	21060.00	52	16	208	29	7.17241379310345	0.178496580536203	0.178496580536203	false	false	false	true	false
78db56a8-6cca-43dc-bd57-8222b66efa25	2026-09-01 10:21	2026-09-01 10:21	2026-09-01 10:21	XLV	XLV261120P00170000	put	170.0000	2026-11-20	4.1000	4.1000	4.3500	172.1900	63960.00	0.00	63960.00	156	33	156	29	5.37931034482759	0.180370195893296	0.180370195893296	false	false	false	true	false
b7864f94-a879-49e8-95af-0b046f68ebef	2026-09-01 10:13	2026-09-01 10:13	2026-09-01 10:13	XLV	XLV261016P00160000	put	160.0000	2026-10-16	0.6100	0.4400	0.8700	172.0450	57708.00	63.00	57645.00	946	21	952	4194	0.226990939437291	0.184633394424655	0.186380815065884	false	false	false	true	false
679e7a46-2582-4042-9bb1-5bb09c0b0214	2026-09-01 10:03	2026-09-01 10:03	2026-09-01 10:03	XLV	XLV260918C00170000	call	170.0000	2026-09-18	3.5500	3.5500	3.6500	171.7899	30530.00	0.00	22365.00	86	7	560	11852	0.0472494093823827	0.160286983959478	0.160286983959478	true	false	false	true	false
54e7b6b3-97e1-4483-b735-c3da5f906b18	2026-09-01 10:03	2026-09-01 10:03	2026-09-01 10:03	XLV	XLV260918C00170000	call	170.0000	2026-09-18	3.5500	3.5000	3.6500	171.8050	30543.00	3550.00	23443.00	86	6	474	11852	0.0399932500843739	0.159579990812626	0.159579990812626	true	false	false	true	false
75398f01-8813-47f5-98f6-29d404a4bf1c	2026-09-01 10:03	2026-09-01 10:03	2026-09-01 10:03	XLV	XLV260918C00170000	call	170.0000	2026-09-18	3.5500	3.3000	3.7000	171.7700	31595.00	4970.00	21300.00	89	9	388	11852	0.0327370907863652	0.16121469977978	0.16121469977978	false	false	false	true	false
2cc12564-2635-444c-844d-78f0b5f2cc26	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	XLV	XLV261016C00170000	call	170.0000	2026-10-16	4.3500	4.3500	4.8000	170.8100	13492.00	440.00	13052.00	31	27	111	690	0.160869565217391	0.144206295557342	0.144206295557342	true	false	false	true	false
fc429eb4-8a52-4fdf-bf8a-4245a0703449	2026-08-31 14:01	2026-08-31 14:01	2026-08-31 14:01	XLV	XLV260918C00180000	call	180.0000	2026-09-18	0.2000	0.1800	0.2000	170.0000	13560.00	13560.00	0.00	678	5	715	6257	0.114272015342816	0.159765207921383	0.159765207921383	false	false	false	true	false
d179e035-e3ad-4476-a063-d92ed3a917b0	2026-08-31 13:54	2026-08-31 13:54	2026-08-31 13:54	XLV	XLV270115C00180000	call	180.0000	2027-01-15	3.8500	3.6500	3.8500	170.0000	76998.00	76998.00	0.00	200	35	544	9494	0.0572993469559722	0.159213920598441	0.159213920598441	true	false	false	true	false
28b255a0-59a8-4736-8705-1accd640bdae	2026-08-31 13:53	2026-08-31 13:53	2026-08-31 13:53	XLV	XLV270115C00180000	call	180.0000	2027-01-15	3.8500	3.6500	3.8500	170.0000	115490.00	115490.00	0.00	300	50	344	9494	0.0362334105751001	0.159259851556722	0.159259851556722	true	false	false	true	false
f7e57760-7367-42ef-82c3-a30bbfe15ed1	2026-08-31 11:44	2026-08-31 11:44	2026-08-31 11:44	XLV	XLV261002P00158000	put	158.0000	2026-10-02	0.3400	0.3400	0.4000	170.4250	14960.00	0.00	14824.00	440	25	442	1	442	0.190887122776654	0.190887122776654	false	false	false	true	false