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 = 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	price

77df0f2f-5020-4e06-8b6d-e7a961945e9b	2026-09-22 12:13	2026-09-22 12:13	2026-09-22 12:13	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.5600	0.5600	0.6400	54.8298	28224.00	0.00	28224.00	504	6	11995	18191	0.659392007036447	0.153105803995334	0.153105803995334	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-22T16:20:35.100506Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
b49ed66f-3101-442e-95f8-2b7dce606404	2026-09-22 11:55	2026-09-22 11:55	2026-09-22 11:55	XLF	XLF260930C00055000	call	55.0000	2026-09-30	0.3800	0.3700	0.4400	54.6950	38304.00	37126.00	1178.00	1008	49	1381	2371	0.58245466048081	0.153834414664226	0.153834414664226	false	false	false	true	false
6c8fb4cd-b488-43b6-9263-0f957ec60965	2026-09-22 11:55	2026-09-22 11:54	2026-09-22 11:55	XLF	XLF260930P00056000	put	56.0000	2026-09-30	1.3500	0.0000	0.0000	54.7000	1044053.00	0.00	1044053.00	7732	17	15006	15490	0.968754034861201	0	0	true	true	false	true	false
e4cea3c6-9a65-45b3-b661-32413251b4ce	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.4200	54.7000	54128.00	0.00	54128.00	398	14	7434	15490	0.479922530664945	0.154958680738035	0.154958680738035	true	false	false	true	false
b5137ad3-d05b-496a-b894-79416c738689	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.4200	54.7000	202096.00	0.00	202096.00	1486	12	7036	15490	0.454228534538412	0.154958680738035	0.154958680738035	true	false	false	true	false
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
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	false
fae320b1-b2a7-41dd-84a3-020d31294b13	2026-09-22 11:53	2026-09-22 11:53	2026-09-22 11:53	XLF	XLF260930P00056000	put	56.0000	2026-09-30	1.3600	1.3600	1.5100	54.6667	340782.00	0.00	340782.00	2500	53	2506	15490	0.161781794706262	0.150137881098721	0.145490491222235	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
971bdb88-44c6-4e64-ad78-5f7c35e28a63	2026-09-22 11:29	2026-09-22 11:29	2026-09-22 11:29	XLF	XLF270115C00055000	call	55.0000	2027-01-15	2.1300	2.1300	2.2100	54.0000	11930.00	0.00	11930.00	56	6	210	83795	0.00250611611671341	0.162179951743172	0.160533678220491	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
ec956393-5585-4fce-b1bb-ae3a63d77abd	2026-09-22 09:58	2026-09-22 09:58	2026-09-22 09:58	XLF	XLF270617C00075000	call	75.0000	2027-06-17	0.1800	0.1700	0.2400	55.3850	122961.00	117198.00	5763.00	6850	47	8738	1478	5.91204330175913	0.184893011111594	0.182872843382516	false	false	false	true	false
c5cd04e4-6a32-4517-8d6f-6145aa8ebfd7	2026-09-22 09:57	2026-09-22 09:57	2026-09-22 09:57	XLF	XLF270617C00075000	call	75.0000	2027-06-17	0.1800	0.1000	0.1900	55.3950	17668.00	17668.00	0.00	1000	6	1888	1478	1.27740189445196	0.182770827414798	0.182770827414798	false	false	false	true	false
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	false
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	false
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	false
eb405533-9d6c-4f48-8375-bca97f9ce1fb	2026-09-22 09:50	2026-09-22 09:50	2026-09-22 09:50	XLF	XLF260922P00055500	put	55.5000	2026-09-22	0.2000	0.1800	0.2200	55.4200	78048.00	77481.00	567.00	3858	83	7973	288	27.6840277777778	0.26877824608655	0.286142921795384	true	false	false	true	false
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	false
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	false
61500978-543d-4226-8586-e58ec4a1d8d7	2026-09-22 09:50	2026-09-22 09:49	2026-09-22 09:49	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.6300	0.5500	0.6600	55.4893	50190.00	39054.00	11136.00	793	28	9610	715	13.4405594405594	0.281565065786263	0.271113942465106	false	false	false	true	false
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	false
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	false
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	false