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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

02334803-91a7-4c15-859d-49fadef09dbf	2026-09-29 15:44	2026-09-29 15:44	2026-09-29 15:44	XLV	XLV270115P00175000	put	175.0000	2027-01-15	8.2000	7.9500	8.2000	170.5000	138580.00	138580.00	0.00	169	34	376	410	0.917073170731707	0.188165860360003	0.188165860360003	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	44105057022.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T19:48:27.886669Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
878b564a-4ed6-45d5-aa9c-d8ad3e1c952a	2026-09-29 15:36	2026-09-29 15:36	2026-09-29 15:36	XLV	XLV270115P00170000	put	170.0000	2027-01-15	5.5500	5.3500	5.7500	170.5800	63270.00	59940.00	0.00	114	28	351	1329	0.26410835214447	0.186213499430664	0.186213499430664	false	false	false	true
4dc6397d-9265-41e7-9adc-1bf2388e494e	2026-09-29 15:06	2026-09-29 15:06	2026-09-29 15:06	XLV	XLV270115P00175000	put	175.0000	2027-01-15	8.2000	7.9500	8.2000	170.3800	131200.00	131200.00	0.00	160	32	207	410	0.504878048780488	0.186431159149893	0.186431159149893	false	false	false	true
6ffbe5f9-30fc-436b-aed3-6a3bc9e9b6bf	2026-09-29 14:57	2026-09-29 14:57	2026-09-29 14:57	XLV	XLV270115C00175000	call	175.0000	2027-01-15	4.8500	4.7000	4.8500	170.2586	16490.00	16490.00	0.00	34	13	594	6818	0.0871223232619537	0.161889884287609	0.161889884287609	false	false	false	true
abb06154-9fdc-41f9-b544-edbdb857f8e8	2026-09-29 14:21	2026-09-29 14:21	2026-09-29 14:21	XLV	XLV261218C00150000	call	150.0000	2026-12-18	22.3500	21.9500	22.3500	170.0000	17879.00	17879.00	0.00	8	5	13	594	0.0218855218855219	0.198989841697083	0.198989841697083	true	false	false	true
55e077cf-72dd-45ee-8415-1a0d11c18f8e	2026-09-29 14:13	2026-09-29 14:13	2026-09-29 14:13	XLV	XLV261218C00150000	call	150.0000	2026-12-18	22.1600	21.4500	22.2000	170.2700	11080.00	11080.00	0.00	5	5	5	594	0.00841750841750842	0.199548602695526	0.204300622802939	true	false	false	true
546cce4f-c3fc-40ef-8fff-dbacf06d5441	2026-09-29 13:54	2026-09-29 13:54	2026-09-29 13:54	XLV	XLV280121P00180000	put	180.0000	2028-01-21	15.7800	14.2500	15.8000	169.9200	12624.00	12624.00	0.00	8	5	42	15	2.8	0.211801485514954	0.211801485514954	false	false	false	true
d1e024ad-4c9c-418c-a98d-586f6d51bb36	2026-09-29 13:31	2026-09-29 13:31	2026-09-29 13:31	XLV	XLV270115P00175000	put	175.0000	2027-01-15	8.4000	8.3000	8.4000	169.8950	36960.00	36960.00	0.00	44	15	45	410	0.109756097560976	0.18473884506274	0.18473884506274	false	false	false	true
5d0a96e0-de60-453d-aae3-2bb539378b64	2026-09-29 13:31	2026-09-29 13:31	2026-09-29 13:31	XLV	XLV270115P00170000	put	170.0000	2027-01-15	5.7500	5.6500	5.7500	169.8950	35650.00	35650.00	0.00	62	21	120	1329	0.090293453724605	0.18371839000651	0.18371839000651	false	false	false	true
60b9032b-d0b2-42df-8e4c-0327cbaea26d	2026-09-29 13:12	2026-09-29 13:12	2026-09-29 13:12	XLV	XLV261218C00170000	call	170.0000	2026-12-18	6.2500	6.0000	6.3000	169.9200	21875.00	16250.00	625.00	35	8	76	1602	0.0474406991260924	0.172963279106814	0.172963279106814	false	false	false	true
362abc98-6275-4680-87e5-e12e17495178	2026-09-29 13:12	2026-09-29 13:12	2026-09-29 13:12	XLV	XLV261218C00175000	call	175.0000	2026-12-18	3.9000	3.5500	3.9000	169.9200	15600.00	15600.00	0.00	40	12	91	8302	0.0109612141652614	0.170072915464363	0.170072915464363	false	false	false	true
06b6b88c-44bf-4e32-949d-340b657af9d1	2026-09-29 13:11	2026-09-29 13:11	2026-09-29 13:11	XLV	XLV261016P00160000	put	160.0000	2026-10-16	0.2000	0.2000	0.2900	169.8400	19980.00	0.00	19980.00	999	54	1008	6146	0.164009111617312	0.190597601766471	0.190597601766471	false	false	false	true
4530f289-66ba-4dcb-8262-725d2b635cd7	2026-09-29 13:09	2026-09-29 13:09	2026-09-29 13:09	XLV	XLV270115C00175000	call	175.0000	2027-01-15	4.6500	4.5500	4.6500	169.8400	28830.00	28830.00	0.00	62	17	84	6818	0.0123203285420945	0.161522130935336	0.161522130935336	false	false	false	true
df5b0594-e097-467a-ae28-2add3ee3b676	2026-09-29 12:58	2026-09-29 12:58	2026-09-29 12:58	XLV	XLV270115P00169000	put	169.0000	2027-01-15	5.3500	5.2000	5.4000	169.0000	26750.00	26215.00	0.00	50	15	50	97	0.515463917525773	0.183270840407556	0.183270840407556	false	false	false	true
8efbd03d-91cd-47ff-b46c-670ab973a5d6	2026-09-29 12:58	2026-09-29 12:58	2026-09-29 12:58	XLV	XLV270115P00170000	put	170.0000	2027-01-15	5.8000	5.6500	5.8500	169.0000	27260.00	26680.00	0.00	47	16	49	1329	0.036869826937547	0.183065649857095	0.183065649857095	false	false	false	true
fa277793-f8cb-472c-8caa-3487837d8289	2026-09-29 11:25	2026-09-29 11:25	2026-09-29 11:25	XLV	XLV270115P00150000	put	150.0000	2027-01-15	0.8600	0.8500	0.9000	169.0000	11116.00	0.00	10060.00	130	15	415	23027	0.0180223216224432	0.196231002972154	0.198132016619358	false	false	false	true
726e610a-9ea4-4d54-8042-337608a6d556	2026-09-29 11:21	2026-09-29 11:21	2026-09-29 11:21	XLV	XLV261016P00170000	put	170.0000	2026-10-16	2.8000	2.7900	2.8800	169.1400	19601.00	0.00	19601.00	70	7	73	1610	0.0453416149068323	0.172133104385451	0.172133104385451	true	false	false	true
a3b231f8-ccd0-4728-a69d-01e516ea4ba2	2026-09-29 11:19	2026-09-29 11:19	2026-09-29 11:19	XLV	XLV261009C00170000	call	170.0000	2026-10-09	1.6900	1.6900	1.7500	169.1700	24675.00	0.00	24505.00	146	35	268	72	3.72222222222222	0.178217873863873	0.178217873863873	false	false	false	true
44108c71-dff0-419d-85e2-36c2973a6e97	2026-09-29 11:04	2026-09-29 11:04	2026-09-29 11:04	XLV	XLV261009C00170000	call	170.0000	2026-10-09	1.7200	1.7200	1.8000	169.2100	19780.00	0.00	19780.00	115	24	119	72	1.65277777777778	0.179274950818185	0.179274950818185	false	false	false	true
ef6bb4e6-68af-461d-ad6e-6ec73c2dad3c	2026-09-29 10:39	2026-09-29 10:39	2026-09-29 10:39	XLV	XLV280121P00180000	put	180.0000	2028-01-21	16.0500	15.0500	16.3500	169.0601	17655.00	12840.00	4815.00	11	6	31	15	2.06666666666667	0.210466925052229	0.210466925052229	false	false	false	true
9cb81e4a-9445-4220-9789-128646e355c2	2026-09-29 10:23	2026-09-29 10:23	2026-09-29 10:23	XLV	XLV261218P00185000	put	185.0000	2026-12-18	15.9000	14.2000	15.9000	169.3200	12720.00	12720.00	0.00	8	7	31	267	0.116104868913858	0.205197865059275	0.205197865059275	true	false	false	true
88c07459-16fc-4e45-8686-cfbffa07d7ea	2026-09-29 10:23	2026-09-29 10:23	2026-09-29 10:23	XLV	XLV270115P00180000	put	180.0000	2027-01-15	12.0500	11.7000	12.0500	169.4500	33740.00	33740.00	0.00	28	8	28	158	0.177215189873418	0.190669018804498	0.190669018804498	false	false	false	true
24da84e1-91b9-4cae-839a-cb6120ceacaf	2026-09-29 10:22	2026-09-29 10:22	2026-09-29 10:22	XLV	XLV261218P00185000	put	185.0000	2026-12-18	15.6500	14.2000	15.6500	169.5750	10955.00	10955.00	0.00	7	6	23	267	0.0861423220973783	0.20302360065017	0.20302360065017	false	false	false	true
57aa3dcd-56da-4d93-b01b-ff5d3e61e251	2026-09-29 10:06	2026-09-29 10:06	2026-09-29 10:06	XLV	XLV261120C00170000	call	170.0000	2026-11-20	4.9000	4.9000	5.4000	169.9200	12250.00	0.00	12250.00	25	7	41	641	0.0639625585023401	0.173145599463119	0.173145599463119	true	false	false	true
c6f59662-4cb0-4c0e-aadd-287e41e9936b	2026-09-29 10:03	2026-09-29 10:02	2026-09-29 10:02	XLV	XLV261218P00185000	put	185.0000	2026-12-18	15.0000	13.7500	15.0000	170.3050	16500.00	16500.00	0.00	11	8	11	267	0.0411985018726592	0.199486334963637	0.199486334963637	true	false	false	true
00ae951a-aa86-4ee8-b660-3e4e0e9483d5	2026-09-29 09:48	2026-09-29 09:48	2026-09-29 09:48	XLV	XLV261016P00172000	put	172.0000	2026-10-16	3.2000	3.0000	3.4000	170.4200	17920.00	17600.00	320.00	56	13	56	303	0.184818481848185	0.171263759377926	0.171263759377926	true	false	false	true
d08b40ff-1cf7-4ea1-9b96-17d11aea91c1	2026-09-29 09:39	2026-09-29 09:39	2026-09-29 09:39	XLV	XLV261016P00171000	put	171.0000	2026-10-16	2.2500	2.2000	2.5000	171.4100	17101.00	225.00	16650.00	76	6	170	1682	0.101070154577883	0.176521611458862	0.176521611458862	false	false	false	true
8c1f24be-5976-45d9-8b37-f497aa3c3116	2026-09-28 15:41	2026-09-28 15:41	2026-09-28 15:41	XLV	XLV261016P00171000	put	171.0000	2026-10-16	2.2800	2.2300	2.3500	171.2300	132924.00	131100.00	1824.00	583	24	826	70	11.8	0.168721070543921	0.168721070543921	true	false	false	true
37178662-fc95-4fb8-8cc3-6aa0c37b8587	2026-09-28 15:12	2026-09-28 15:12	2026-09-28 15:12	XLV	XLV270115P00170000	put	170.0000	2027-01-15	5.2500	5.0500	5.4500	171.2300	22050.00	19425.00	0.00	42	13	140	1212	0.115511551155116	0.184599433348225	0.184599433348225	false	false	false	true
4e857017-17b0-4b2d-80f7-d320a6d4120c	2026-09-28 14:29	2026-09-28 14:29	2026-09-28 14:29	XLV	XLV270617P00175000	put	175.0000	2027-06-17	10.0000	9.9000	10.3000	171.1200	29985.00	0.00	29985.00	30	5	32	161	0.198757763975155	0.186458933168396	0.18977709595592	false	false	false	true
b7478f55-c00a-4b6f-9ec0-60fb689eff45	2026-09-28 14:23	2026-09-28 14:23	2026-09-28 14:23	XLV	XLV270115C00169000	call	169.0000	2027-01-15	8.3500	8.3500	8.6000	171.1500	25885.00	0.00	25885.00	31	13	32	741	0.0431848852901484	0.161404443282601	0.161404443282601	false	false	false	true
6a4cb3ad-dfb3-409f-a2ce-05b8252da82d	2026-09-28 13:54	2026-09-28 13:54	2026-09-28 13:54	XLV	XLV261120C00180000	call	180.0000	2026-11-20	1.6800	1.5700	1.6800	171.2350	24360.00	24360.00	0.00	145	26	153	1347	0.11358574610245	0.169760198411754	0.169760198411754	false	false	false	true
4d096ba4-a3f7-4507-a343-0c158a799cac	2026-09-28 13:13	2026-09-28 13:12	2026-09-28 13:12	XLV	XLV270115P00170000	put	170.0000	2027-01-15	5.0000	4.6500	5.0000	171.7300	45000.00	45000.00	0.00	90	27	90	1212	0.0742574257425743	0.183152413833269	0.183152413833269	false	false	false	true
517a07e3-d030-440d-ac05-1b5fd3c13c2e	2026-09-28 13:12	2026-09-28 13:11	2026-09-28 13:11	XLV	XLV270617C00190000	call	190.0000	2027-06-17	4.7700	3.7500	4.8000	171.7900	56765.00	48380.00	8385.00	119	16	119	34	3.5	0.161684560806367	0.160486827808685	true	false	false	true
2cdb4681-cea6-4b9a-bd9f-49ad24445c29	2026-09-28 13:12	2026-09-28 13:11	2026-09-28 13:11	XLV	XLV270617C00190000	call	190.0000	2027-06-17	4.7000	4.0000	4.9000	171.7900	14575.00	14100.00	475.00	31	12	153	34	4.5	0.159539390851053	0.159539390851053	true	false	false	true
e77c5ff1-a42b-4142-a116-28751dd73c52	2026-09-28 13:00	2026-09-28 13:00	2026-09-28 13:00	XLV	XLV261016C00170000	call	170.0000	2026-10-16	3.4500	3.4000	3.5000	171.4300	38295.00	37605.00	345.00	111	17	138	2224	0.0620503597122302	0.163194297973744	0.163194297973744	false	false	false	true
d2f5d81d-0a31-4eb8-94a6-707deef98088	2026-09-28 12:48	2026-09-28 12:48	2026-09-28 12:48	XLV	XLV261016P00169000	put	169.0000	2026-10-16	1.4200	1.2400	1.4200	171.0000	17466.00	17466.00	0.00	123	31	123	161	0.763975155279503	0.168308077918507	0.168308077918507	false	false	false	true
60667ecb-8635-48c3-8ce2-a06a33dff04b	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	XLV	XLV261016P00172000	put	172.0000	2026-10-16	2.6200	2.4700	2.6200	171.4050	41920.00	41920.00	0.00	160	24	259	48	5.39583333333333	0.163970031732471	0.163970031732471	false	false	false	true
04faabd3-74a7-4e89-9bed-b5620f8e3c90	2026-09-28 12:20	2026-09-28 12:20	2026-09-28 12:20	XLV	XLV270319C00147000	call	147.0000	2027-03-19	27.5500	27.5000	28.1500	171.1000	826560.00	0.00	667060.00	300	6	300	659	0.455235204855842	0.159956440736112	0.167493965207485	false	false	false	true
9b4e794d-92f9-49e4-88a4-63dd86af36ae	2026-09-28 12:10	2026-09-28 12:10	2026-09-28 12:10	XLV	XLV261016P00171000	put	171.0000	2026-10-16	2.3300	2.2200	2.3300	171.0700	42173.00	42173.00	0.00	181	27	202	70	2.88571428571429	0.167136947875362	0.167136947875362	false	false	false	true
7234c19d-0ece-457f-96d9-6a2766fb2ecc	2026-09-28 12:06	2026-09-28 12:06	2026-09-28 12:06	XLV	XLV270115C00157000	call	157.0000	2027-01-15	17.0000	15.9500	17.2500	171.0200	348500.00	348500.00	0.00	205	7	300	13955	0.0214976710856324	0.162118132071159	0.162118132071159	false	false	false
855fe698-b45a-40a3-9474-570fde34f72a	2026-09-28 12:05	2026-09-28 12:05	2026-09-28 12:05	XLV	XLV270115C00157000	call	157.0000	2027-01-15	17.0000	15.9000	17.5000	171.0200	161500.00	161500.00	0.00	95	5	95	13955	0.00680759584378359	0.162118132071159	0.162118132071159	false	false	false	true
73b8e1af-46f5-4ba6-aaca-446948c4d871	2026-09-28 11:25	2026-09-28 11:25	2026-09-28 11:25	XLV	XLV261218C00170000	call	170.0000	2026-12-18	6.9500	6.9500	7.4000	171.0000	49351.00	0.00	49351.00	71	19	168	1688	0.0995260663507109	0.174337824925739	0.173945739047946	true	false	false	true
9ead4a55-966b-44cc-a079-ae576393b9e9	2026-09-28 11:18	2026-09-28 11:18	2026-09-28 11:18	XLV	XLV261016C00175000	call	175.0000	2026-10-16	1.2300	1.1300	1.2300	171.0000	10947.00	10947.00	0.00	89	23	179	1514	0.118229854689564	0.168887321209385	0.168887321209385	false	false	false	true
8c5c0000-3ad7-4659-bb71-578ae19730f5	2026-09-28 10:55	2026-09-28 10:55	2026-09-28 10:55	XLV	XLV261016P00172000	put	172.0000	2026-10-16	3.0500	2.8500	3.0500	170.8800	28670.00	28670.00	0.00	94	24	99	48	2.0625	0.174198260047199	0.174198260047199	false	false	false	true
51504cb0-59f0-4943-8119-c99455b56900	2026-09-28 10:25	2026-09-28 10:24	2026-09-28 10:24	XLV	XLV261016C00172000	call	172.0000	2026-10-16	2.0500	1.9600	2.2500	170.0000	33620.00	1640.00	31980.00	164	23	171	1858	0.0920344456404736	0.170745733678494	0.170745733678494	true	false	false	true
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
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
c090d099-7f8f-43a0-ad46-d6a938e32575	2026-09-25 12:34	2026-09-25 12:34	2026-09-25 12:34	XLV	XLV280121C00170000	call	170.0000	2028-01-21	17.4800	16.4500	17.5000	169.6900	10486.00	10486.00	0.00	6	5	7	1633	0.00428658909981629	0.154151061887456	0.153584636396028	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