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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = XLF×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

477f8e30-468f-46fc-95f1-2d462285bef6	2026-09-22 11:54	2026-09-22 11:54	2026-09-22 11:54	XLF	XLF260930P00056000	put	56.0000	2026-09-30	1.3600	1.3600	1.4300	54.6999	73984.00	0.00	73984.00	544	18	5550	15490	0.358295674628793	0.154917111768608	0.154917111768608	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	51547946728.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T15:56:22.412787Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
851a23c0-0ad0-4b32-81e2-6a1fddd019e2	2026-09-22 11:54	2026-09-22 11:54	2026-09-22 11:54	XLF	XLF260930P00056000	put	56.0000	2026-09-30	1.3700	1.3700	1.4300	54.6850	342363.00	0.00	342363.00	2499	29	5005	15490	0.323111684958037	0.153669607537634	0.153669607537634	false	false	false	true
57ef303c-e297-4f5e-9492-9b473266f96a	2026-09-22 11:48	2026-09-22 11:48	2026-09-22 11:48	XLF	XLF261030P00056000	put	56.0000	2026-10-30	1.8400	1.7500	1.8400	54.6100	20240.00	20240.00	0.00	110	5	125	283	0.441696113074205	0.165523411165215	0.165523411165215	false	false	false	true
4f49865c-3c89-41ea-8494-a68fcd4be07a	2026-09-22 11:46	2026-09-22 11:46	2026-09-22 11:46	XLF	XLF261016C00055000	call	55.0000	2026-10-16	0.8000	0.8000	0.8300	54.6651	64000.00	0.00	64000.00	800	25	848	31679	0.0267685217336406	0.159358290073578	0.159358290073578	false	false	false	true
d82660e0-f296-4fc5-b2de-347a0d40dd19	2026-09-22 11:38	2026-09-22 11:38	2026-09-22 11:38	XLF	XLF271217C00059000	call	59.0000	2027-12-17	3.5500	3.5500	3.6500	54.6500	14555.00	0.00	14555.00	41	8	82	1426	0.0575035063113604	0.16467679049817	0.16467679049817	false	false	false	true
2df6a486-3298-4fe6-bede-3b99e7d5d110	2026-09-22 11:38	2026-09-22 11:38	2026-09-22 11:38	XLF	XLF271217C00060000	call	60.0000	2027-12-17	3.1500	3.1000	3.2000	54.6300	12915.00	10080.00	2835.00	41	5	347	13045	0.0266002299731698	0.164395688615374	0.164395688615374	false	false	false	true
65b395a2-2afb-4074-944b-0560284b1446	2026-09-22 11:32	2026-09-22 11:32	2026-09-22 11:32	XLF	XLF261009P00054000	put	54.0000	2026-10-09	0.4900	0.4500	0.5000	54.0000	10633.00	10584.00	0.00	217	19	460	228	2.01754385964912	0.168152528552521	0.168152528552521	true	false	false	true
ac6b31cb-6f15-4026-8c8b-e3d84b16a7f4	2026-09-22 11:12	2026-09-22 11:12	2026-09-22 11:12	XLF	XLF261120P00053000	put	53.0000	2026-11-20	0.7700	0.7700	0.7800	54.6900	16170.00	0.00	16170.00	210	20	2808	19847	0.141482339900237	0.183875397510065	0.184261680287157	true	false	false	true
52e92a13-4a73-4281-a49a-2fab00fcb414	2026-09-22 11:12	2026-09-22 11:12	2026-09-22 11:12	XLF	XLF261120P00053000	put	53.0000	2026-11-20	0.7700	0.7600	0.7700	54.6850	102564.00	102564.00	0.00	1332	6	2598	19847	0.130901395676928	0.184068592399988	0.184068592399988	true	false	false	true
3cafc241-49e3-4297-a00a-ff3a80048e2b	2026-09-22 11:12	2026-09-22 11:12	2026-09-22 11:12	XLF	XLF261120P00053000	put	53.0000	2026-11-20	0.7700	0.7400	0.7700	54.6850	89936.00	89936.00	0.00	1168	45	1266	19847	0.0637879780319444	0.184068592399988	0.184068592399988	true	false	false	true
51795e39-bea4-4127-a77c-426100e23a72	2026-09-22 11:12	2026-09-22 11:12	2026-09-22 11:12	XLF	XLF270115C00058000	call	58.0000	2027-01-15	0.9500	0.9500	1.0000	54.7050	47500.00	0.00	47500.00	500	14	708	12421	0.0570002415264471	0.156306965303303	0.156306965303303	false	false	false	true
f7501a2d-3b4d-4913-b960-9d6c1aa690f8	2026-09-22 11:04	2026-09-22 11:04	2026-09-22 11:04	XLF	XLF271217C00058000	call	58.0000	2027-12-17	4.1000	4.0500	4.1500	54.8050	11070.00	2050.00	9020.00	27	10	68	3467	0.0196134987020479	0.166678891183345	0.166678891183345	false	false	false	true
da2bd530-e5bc-4545-9711-d2a63dd9c405	2026-09-22 10:59	2026-09-22 10:58	2026-09-22 10:58	XLF	XLF271217C00057000	call	57.0000	2027-12-17	4.6000	4.6000	4.7000	54.7750	18400.00	0.00	18400.00	40	12	40	1350	0.0296296296296296	0.169144498300368	0.169144498300368	false	false	false	true
b8d21b81-749f-4ab8-9b06-2b0ae6e4c9fe	2026-09-22 10:58	2026-09-22 10:58	2026-09-22 10:58	XLF	XLF261016C00056000	call	56.0000	2026-10-16	0.4800	0.4800	0.5200	54.7850	39120.00	0.00	39120.00	815	27	2388	21179	0.112753198923462	0.162095545303844	0.162095545303844	false	false	false	true
68dc22b1-a178-4a38-88e9-943e2591be92	2026-09-22 10:58	2026-09-22 10:58	2026-09-22 10:58	XLF	XLF261016C00055500	call	55.5000	2026-10-16	0.6600	0.6500	0.7100	54.7850	187110.00	46200.00	140910.00	2835	50	2846	0	0	0.162826567066964	0.162826567066964	false	false	false	true
e89ca1ed-1b61-46f3-ab1c-920983b9feea	2026-09-22 10:57	2026-09-22 10:57	2026-09-22 10:57	XLF	XLF260923P00055000	put	55.0000	2026-09-23	0.3900	0.3900	0.4500	54.8100	40131.00	0.00	40131.00	1029	43	3895	205	19	0.251822879662911	0.251822879662911	false	false	false	true
b4ecac1a-aaa3-4849-8f66-5c912ad77317	2026-09-22 10:55	2026-09-22 10:55	2026-09-22 10:55	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.6200	0.6100	0.6400	54.7800	119846.00	3844.00	116002.00	1933	60	7977	18191	0.438513550656918	0.163289322739247	0.163374438428123	false	false	false	true
e99868bd-e458-49cb-bbb5-0015fd10b47b	2026-09-22 10:47	2026-09-22 10:47	2026-09-22 10:47	XLF	XLF271217P00052000	put	52.0000	2027-12-17	2.6200	2.6200	2.7600	54.7950	12314.00	0.00	12314.00	47	12	47	12339	0.0038090607018397	0.217108296533684	0.217108296533684	false	false	false	true
584363e8-f420-4416-86b3-7970daa04d38	2026-09-22 10:47	2026-09-22 10:47	2026-09-22 10:47	XLF	XLF261218P00051000	put	51.0000	2026-12-18	0.5500	0.5500	0.5700	54.7750	56540.00	0.00	56540.00	1028	22	1135	11313	0.10032705736763	0.195586581994157	0.195586581994157	false	false	false	true
39aca319-55c2-49ca-ae23-299feb6e251c	2026-09-22 10:43	2026-09-22 10:42	2026-09-22 10:42	XLF	XLF260922C00055000	call	55.0000	2026-09-22	0.1400	0.1400	0.1600	54.8750	20930.00	0.00	20930.00	1495	53	1828	240	7.61666666666667	0.363488880359543	0.363488880359543	false	false	false	true
a7ebfa0d-a4e8-4ac1-8d8f-32a205d843e8	2026-09-22 10:39	2026-09-22 10:38	2026-09-22 10:38	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.5800	0.5800	0.6100	54.8950	20880.00	0.00	20880.00	360	21	5971	18191	0.328239239184212	0.169825864226649	0.169825864226649	false	false	false	true
265e2336-bb09-460a-8b93-b85de49363f5	2026-09-22 10:32	2026-09-22 10:32	2026-09-22 10:32	XLF	XLF260923C00055000	call	55.0000	2026-09-23	0.2600	0.2400	0.2600	54.8250	13000.00	13000.00	0.00	500	21	1059	6	176.5	0.294620834375584	0.294620834375584	false	false	false	true
462ac37d-00d4-4181-a003-15c6eb42d74b	2026-09-22 10:28	2026-09-22 10:28	2026-09-22 10:28	XLF	XLF261016P00053500	put	53.5000	2026-10-16	0.4300	0.4200	0.4300	54.9201	90601.00	90601.00	0.00	2107	14	3902	550	7.09454545454545	0.185413371223375	0.185413371223375	true	false	false	true
26d0a0d5-56d3-4498-940d-1ffbb122f48f	2026-09-22 10:23	2026-09-22 10:22	2026-09-22 10:22	XLF	XLF261016C00054500	call	54.5000	2026-10-16	1.3400	1.3400	1.4200	55.0100	14874.00	0.00	14874.00	111	17	111	10	11.1	0.175173202806869	0.175173202806869	false	false	false	true
23560392-d558-4e49-9a92-bbe28deaeb23	2026-09-22 10:22	2026-09-22 10:22	2026-09-22 10:22	XLF	XLF261016P00053500	put	53.5000	2026-10-16	0.3900	0.3900	0.4100	55.0300	58500.00	0.00	58500.00	1500	49	1574	550	2.86181818181818	0.18280553444727	0.18280553444727	false	false	false	true
3603812f-b945-44be-8d4f-8fa8bcd16478	2026-09-22 10:22	2026-09-22 10:22	2026-09-22 10:22	XLF	XLF261016C00056500	call	56.5000	2026-10-16	0.4200	0.4200	0.4600	55.0500	38388.00	0.00	38388.00	914	21	927	358	2.58938547486034	0.163211235513926	0.163211235513926	false	false	false	true
3d19062a-05a8-43c5-aa42-b593c071afc3	2026-09-22 10:22	2026-09-22 10:22	2026-09-22 10:22	XLF	XLF261016C00056000	call	56.0000	2026-10-16	0.5900	0.5900	0.6300	55.0500	88500.00	0.00	88500.00	1500	26	1536	21179	0.0725246706643373	0.165336685678343	0.165336685678343	false	false	false	true
a231daf6-7f71-4133-9439-bad53e30dd7d	2026-09-22 10:20	2026-09-22 10:20	2026-09-22 10:20	XLF	XLF270319C00075000	call	75.0000	2027-03-19	0.0900	0.0500	0.0900	55.0750	18000.00	18000.00	0.00	2000	6	5560	97044	0.0572935987799349	0.211127964642871	0.211127964642871	false	false	false	true
2a4b4016-99f3-494b-a7af-a5381b7056b2	2026-09-22 10:06	2026-09-22 10:06	2026-09-22 10:06	XLF	XLF270331P00053000	put	53.0000	2027-03-31	1.4800	1.3700	1.4800	55.4250	22200.00	22200.00	0.00	150	10	162	44	3.68181818181818	0.191358983017402	0.191358983017402	false	false	false	true
21cbd5b0-227b-4b3d-8efa-d20ef6d26bb6	2026-09-22 10:02	2026-09-22 10:02	2026-09-22 10:02	XLF	XLF260922C00055500	call	55.5000	2026-09-22	0.1900	0.1700	0.1900	55.4750	19000.00	19000.00	0.00	1000	33	1179	103	11.4466019417476	0.349158533463077	0.349158533463077	false	false	false	true
ab5cf3ff-8a65-4948-9f5c-0eb9ade9fe24	2026-09-22 10:02	2026-09-22 10:02	2026-09-22 10:02	XLF	XLF260922P00055500	put	55.5000	2026-09-22	0.2300	0.2000	0.2400	55.4450	225000.00	115000.00	0.00	10000	2	24429	288	84.8229166666667	0.332575990864671	0.332575990864671	false	true	false	true
63f09004-8388-436c-849d-9b0718e66c68	2026-09-22 09:57	2026-09-22 09:57	2026-09-22 09:57	XLF	XLF270115C00054000	call	54.0000	2027-01-15	3.2500	3.1500	3.2500	55.4050	14950.00	14950.00	0.00	46	7	47	18260	0.00257393209200438	0.165377826277172	0.165377826277172	false	false	false	true
5111cf69-ac4f-439d-9c8f-334a290295e9	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	XLF	XLF260922P00055500	put	55.5000	2026-09-22	0.2800	0.2500	0.2800	55.3750	80611.00	80611.00	0.00	2879	58	14120	288	49.0277777777778	0.363065975903679	0.363065975903679	false	false	false	true
2c577a35-34d8-487e-9cb3-78419c68e8da	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	XLF	XLF260922P00055500	put	55.5000	2026-09-22	0.2700	0.2300	0.2800	55.3750	55809.00	54162.00	1512.00	2067	21	11186	288	38.8402777777778	0.345475914441711	0.345475914441711	false	false	false	true
dadb287c-4e26-43dd-85c7-2b06cd098c08	2026-09-22 09:50	2026-09-22 09:50	2026-09-22 09:50	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.6400	0.5700	0.6600	55.4850	27264.00	25344.00	1920.00	426	23	10036	715	14.0363636363636	0.278294991178121	0.278294991178121	false	false	false	true
955e439c-58b1-4582-b3de-44041591a9b5	2026-09-22 09:50	2026-09-22 09:49	2026-09-22 09:49	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.6200	0.5900	0.6600	55.4893	100006.00	90148.00	9796.00	1613	17	8817	715	12.3314685314685	0.260495925407109	0.260495925407109	true	false	false	true
9caf552e-11ea-46b2-ac24-5a32733e33d1	2026-09-22 09:49	2026-09-22 09:49	2026-09-22 09:49	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5600	0.4900	0.6300	55.5500	88312.00	79800.00	4704.00	1577	11	7074	715	9.89370629370629	0.244425493813521	0.244425493813521	false	false	false	true
be114772-0fff-4f40-bed5-20d00443ab40	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF261120P00054000	put	54.0000	2026-11-20	0.7400	0.6900	0.7400	55.5101	32560.00	32560.00	0.00	440	17	526	24644	0.0213439376724558	0.170398309144059	0.170398309144059	true	false	false	true
b6893db4-8b80-46fd-ad2b-aa359579b439	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.2500	0.2100	0.2600	55.5101	46781.00	46781.00	0.00	1868	9	1948	18191	0.107085921609587	0.149952694802013	0.149952694802013	false	false	false	true
a4125c96-4c7c-4522-b76a-7f642be5a7f2	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5700	0.5200	0.5800	55.5101	32034.00	7011.00	25023.00	562	10	3877	715	5.42237762237762	0.222834663421613	0.222834663421613	true	false	false	true
e8e2e904-0d7e-4dd5-b8af-db2a27a523a4	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5700	0.5300	0.5800	55.5101	13452.00	3762.00	9405.00	236	32	3187	715	4.45734265734266	0.222834663421613	0.222834663421613	false	false	false	true
b60d0ce1-7643-4726-b641-419ec829abe6	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5700	0.5400	0.5800	55.5150	23997.00	4503.00	19494.00	421	13	2701	715	3.77762237762238	0.227056297445596	0.227056297445596	true	false	false	true
c845ab82-e9e6-46fd-a3c3-4be72898beea	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5600	0.5200	0.5800	55.5150	35168.00	4256.00	30912.00	628	8	1631	715	2.28111888111888	0.215749561385855	0.215749561385855	true	false	false	true
9abbc1f3-920a-473b-933f-eb2819d8dcf6	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5600	0.5600	0.5800	55.5150	17416.00	0.00	17416.00	311	9	2022	715	2.82797202797203	0.215749561385855	0.215749561385855	true	false	false	true
00c381c5-b8a3-402f-a2d9-a200c99fee50	2026-09-22 09:47	2026-09-22 09:47	2026-09-22 09:47	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5300	0.5200	0.5900	55.5501	28090.00	0.00	28090.00	530	8	708	715	0.99020979020979	0.212323065889986	0.212323065889986	true	false	false	true
6b2c68f9-107f-46f7-af36-dededf2777a8	2026-09-22 09:46	2026-09-22 09:46	2026-09-22 09:46	XLF	XLF260923P00055500	put	55.5000	2026-09-23	0.2000	0.1700	0.2000	55.5399	38000.00	38000.00	0.00	1900	29	2369	668	3.54640718562874	0.191676115666543	0.191676115666543	false	false	false	true
cd11bcb2-4436-48cf-a9b0-ad632d139d84	2026-09-22 09:44	2026-09-22 09:44	2026-09-22 09:44	XLF	XLF260922P00055500	put	55.5000	2026-09-22	0.1100	0.1000	0.1200	55.0000	13810.00	0.00	13810.00	1260	36	2423	288	8.41319444444444	0.26921799718119	0.251631844992396	false	false	false	true
66839209-a1f3-4cf3-9d20-4388a9e81c72	2026-09-22 09:43	2026-09-22 09:43	2026-09-22 09:43	XLF	XLF260923P00055000	put	55.0000	2026-09-23	0.0600	0.0300	0.0600	55.0000	15558.00	15558.00	0.00	2593	39	2595	205	12.6585365853659	0.220227480866424	0.220297238333175	false	false	false	true
33c7f1bd-93d1-46f2-8fd9-3085e78dd971	2026-09-22 09:43	2026-09-22 09:43	2026-09-22 09:43	XLF	XLF260922P00055500	put	55.5000	2026-09-22	0.1100	0.1000	0.1100	55.0000	12056.00	12056.00	0.00	1096	22	1151	288	3.99652777777778	0.255329802555513	0.255539849952067	false	false	false	true
44d21060-98f6-4585-bd37-b510c9ec7fef	2026-09-21 15:29	2026-09-21 15:29	2026-09-21 15:29	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1200	0.0800	0.1200	55.9550	84000.00	84000.00	0.00	7000	47	18000	58141	0.309592198276603	0.339327979627338	0.339327979627338	false	false	false	true