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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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

0daeb7d3-bb27-48ae-865d-5841ddae9df4	2026-08-26 12:44	2026-08-26 12:44	2026-08-26 12:44	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.6700	0.6500	0.6700	58.2000	97954.00	97686.00	0.00	1462	14	11613	92553	0.125474052704937	0.14251919207587	0.14251919207587	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	54976867713.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1508bd3c-00af-4b69-ba92-0d123d9bc687	2026-08-26 11:34	2026-08-26 11:34	2026-08-26 11:34	XLF	XLF270319P00058000	put	58.0000	2027-03-19	2.5100	2.5000	2.5500	58.1650	75300.00	251.00	75049.00	300	6	309	12965	0.0238333976089472	0.185659780712747	0.185659780712747	false	false	false	true
43fd7617-bb5f-4e43-b32d-fbffb7ee77df	2026-08-25 14:02	2026-08-25 14:01	2026-08-25 14:01	XLF	XLF271217C00061000	call	61.0000	2027-12-17	4.7000	4.5500	4.7000	58.0000	66270.00	66270.00	0.00	141	8	171	1369	0.12490869247626	0.167244016519039	0.167244016519039	false	false	false	true
463ff99d-97da-44d9-b698-47fd7dec3f29	2026-08-25 12:25	2026-08-25 12:25	2026-08-25 12:25	XLF	XLF260925P00057500	put	57.5000	2026-09-25	0.6800	0.6700	0.7200	58.1350	105060.00	1088.00	103972.00	1545	54	1548	71	21.8028169014085	0.154833044278913	0.154833044278913	false	false	false	true
fc79c14d-829d-4d0b-95fc-7e9ac3e565d5	2026-08-25 11:35	2026-08-25 11:35	2026-08-25 11:35	XLF	XLF280121C00055000	call	55.0000	2028-01-21	8.2500	8.0000	8.4000	58.0700	67648.00	67648.00	0.00	82	5	88	4890	0.0179959100204499	0.171051369791155	0.171051369791155	false	false	false	true
6be21723-0378-46d4-856f-1d0f4017c96f	2026-08-25 11:19	2026-08-25 11:19	2026-08-25 11:19	XLF	XLF270617C00058000	call	58.0000	2027-06-17	4.6000	4.4500	4.6000	58.1700	51980.00	51980.00	0.00	113	15	113	8185	0.0138057422113622	0.16995666067547	0.16995666067547	false	false	false	true
6e705581-8592-433c-ba83-597830b6d897	2026-08-25 10:37	2026-08-25 10:37	2026-08-25 10:37	XLF	XLF261218P00058000	put	58.0000	2026-12-18	1.8800	1.8500	1.9200	58.0950	65612.00	5828.00	51136.00	349	7	970	1608	0.603233830845771	0.174925484977345	0.174925484977345	false	false	false	true
2d65ba20-fae5-4b91-8ef1-479bb5f02757	2026-08-25 10:28	2026-08-25 10:28	2026-08-25 10:28	XLF	XLF260918C00059000	call	59.0000	2026-09-18	0.5300	0.5200	0.5600	58.1200	181949.00	0.00	178451.00	3433	31	3447	27767	0.124140166384557	0.141499257468954	0.141499257468954	false	false	false	true
322f89ec-377d-41a8-a378-ccdfc4ea893b	2026-08-25 09:55	2026-08-25 09:55	2026-08-25 09:55	XLF	XLF261218P00058000	put	58.0000	2026-12-18	1.9200	1.8900	1.9900	57.9450	57600.00	192.00	57408.00	300	7	301	1608	0.187189054726368	0.173017766027103	0.173017766027103	false	false	false	true
5d747a13-3b87-4dd0-b958-f1fb07232097	2026-08-25 09:52	2026-08-25 09:52	2026-08-25 09:52	XLF	XLF260925C00058000	call	58.0000	2026-09-25	0.9400	0.9300	0.9700	57.8900	54050.00	940.00	53110.00	575	15	625	267	2.34082397003745	0.133970581225741	0.133970581225741	false	false	false	true
ad3c93de-a830-4943-8868-970869942970	2026-08-25 09:51	2026-08-25 09:51	2026-08-25 09:51	XLF	XLF260918C00059500	call	59.5000	2026-09-18	0.3400	0.3100	0.3600	57.8900	51000.00	51000.00	0.00	1500	6	1500	2	750	0.147686968519586	0.147686968519586	false	false	false	true
34cb18d8-47a5-4274-a461-31f7bccb5fd5	2026-08-24 10:00	2026-08-24 10:00	2026-08-24 10:00	XLF	XLF270115C00062000	call	62.0000	2027-01-15	1.0700	1.0200	1.1000	58.2550	74900.00	58101.00	1819.00	700	22	2117	3283	0.644837039293329	0.14636832370887	0.14636832370887	true	false	false	true
9eeabcac-f80d-444c-95b5-e2f7bb4f5ecf	2026-08-24 10:00	2026-08-24 10:00	2026-08-24 10:00	XLF	XLF270115C00062000	call	62.0000	2027-01-15	1.0500	1.0000	1.0500	58.2400	58695.00	58695.00	0.00	559	9	1400	3283	0.426439232409382	0.145208319531459	0.145208319531459	true	false	false	true
f3196089-9511-45db-b80f-a78dc9851a6b	2026-08-24 09:54	2026-08-24 09:54	2026-08-24 09:54	XLF	XLF261120C00060000	call	60.0000	2026-11-20	1.1800	1.1500	1.2300	58.3268	59000.00	0.00	59000.00	500	5	2177	6170	0.352836304700162	0.145573851469149	0.145573851469149	false	false	false	true
d66a84b2-f44c-4bbb-99eb-1b543f2a8c1b	2026-08-21 14:40	2026-08-21 14:40	2026-08-21 14:40	XLF	XLF260925P00055000	put	55.0000	2026-09-25	0.3000	0.2900	0.3100	57.4450	78750.00	0.00	54690.00	2625	19	2632	757	3.47688243064729	0.170182064913738	0.170182064913738	false	false	false	true
ff91674f-6f12-4152-87c0-19f648bf1ecf	2026-08-21 12:38	2026-08-21 12:38	2026-08-21 12:38	XLF	XLF260918P00056000	put	56.0000	2026-09-18	0.3700	0.3600	0.3700	57.4550	58645.00	58645.00	0.00	1585	12	2027	96708	0.02096000330893	0.155359291849113	0.155359291849113	false	false	false	true
917abb20-7e0a-4b7f-9daf-02f50b3a5381	2026-08-21 11:38	2026-08-21 11:38	2026-08-21 11:38	XLF	XLF260918C00059000	call	59.0000	2026-09-18	0.3600	0.3500	0.3600	57.4950	72000.00	72000.00	0.00	2000	33	2230	27421	0.0813245322927683	0.135186494869981	0.135186494869981	true	false	false	true
298a318e-890e-4c6f-870d-2c176584d142	2026-08-21 11:20	2026-08-21 11:20	2026-08-21 11:20	XLF	XLF270319P00053000	put	53.0000	2027-03-19	1.2200	1.2200	1.2500	57.4150	89670.00	0.00	89670.00	735	18	1252	1744	0.717889908256881	0.199758120240833	0.199758120240833	false	false	false	true
e4eaa241-f6bb-4431-9e65-e97254c0a1e7	2026-08-21 11:20	2026-08-21 11:19	2026-08-21 11:19	XLF	XLF270319P00054000	put	54.0000	2027-03-19	1.4400	1.3700	1.4600	57.4250	59328.00	30240.00	29088.00	412	14	413	4250	0.0971764705882353	0.195189653564383	0.195189653564383	false	false	false	true
1430a88c-9b6a-4720-8fe6-a1163f4b9577	2026-08-21 10:44	2026-08-21 10:44	2026-08-21 10:44	XLF	XLF270319P00057000	put	57.0000	2027-03-19	2.3500	2.3500	2.4000	57.4440	97525.00	0.00	97525.00	415	26	2043	2182	0.936296975252062	0.183731108618257	0.183731108618257	false	false	false	true
ffccaed0-5100-4d07-abbc-a331b71101e3	2026-08-21 10:43	2026-08-21 10:42	2026-08-21 10:42	XLF	XLF270319P00057000	put	57.0000	2027-03-19	2.3500	2.3300	2.3900	57.4550	67445.00	28670.00	38775.00	287	11	554	2182	0.253895508707608	0.183985661072179	0.183985661072179	false	false	false	true
80dc761c-bb10-4634-9077-cd2fbc645d80	2026-08-20 15:54	2026-08-20 15:53	2026-08-20 15:53	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.7800	0.7800	0.8100	57.0550	135408.00	0.00	135018.00	1736	34	8726	61060	0.142908614477563	0.138719003100042	0.138719003100042	false	false	false	true
d7d76b63-5c2a-475f-8db3-f9ce76f75874	2026-08-20 15:47	2026-08-20 15:47	2026-08-20 15:47	XLF	XLF260930P00057000	put	57.0000	2026-09-30	1.0700	0.9700	1.0700	57.0350	107000.00	107000.00	0.00	1000	24	1002	196	5.11224489795918	0.158298130372163	0.158298130372163	false	false	false	true
b738ea57-6625-4b90-8721-2d8922232a67	2026-08-20 15:46	2026-08-20 15:45	2026-08-20 15:45	XLF	XLF260828P00058000	put	58.0000	2026-08-28	1.1000	1.0500	1.1000	57.0200	79090.00	79090.00	0.00	719	25	3321	991	3.35116044399596	0.147936760744759	0.147936760744759	false	false	false	true
8020660d-78f0-4431-a614-86d2f388e89c	2026-08-20 15:45	2026-08-20 15:45	2026-08-20 15:45	XLF	XLF260828P00058000	put	58.0000	2026-08-28	1.1000	1.0500	1.1000	57.0150	217800.00	217800.00	0.00	1980	59	2390	991	2.4117053481332	0.146440850160211	0.146440850160211	false	false	false	true
3088a5b9-e0f0-48d6-a961-d16f6e762d08	2026-08-20 15:38	2026-08-20 15:37	2026-08-20 15:37	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.5400	0.5400	0.5700	57.0400	158220.00	0.00	158166.00	2930	38	6357	52743	0.120527842557306	0.135921529585332	0.135921529585332	false	false	false	true
bb64dff4-7329-4864-af13-dfce731e0809	2026-08-20 14:36	2026-08-20 14:36	2026-08-20 14:36	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.6400	0.6000	0.6400	57.2400	135552.00	135552.00	0.00	2118	50	2320	52743	0.0439868797755152	0.139603385617112	0.139603385617112	true	false	false	true
25467f69-f773-49b5-a78b-c11a8af1267e	2026-08-20 14:36	2026-08-20 14:36	2026-08-20 14:36	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.6400	0.6000	0.6400	57.2400	55168.00	55168.00	0.00	862	7	3202	52743	0.0607094780349999	0.139603385617112	0.139603385617112	true	false	false	true
7787d977-7a60-4b80-bf62-58197ac481f3	2026-08-20 14:36	2026-08-20 14:36	2026-08-20 14:36	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.7200	0.6900	0.7200	57.2400	135360.00	135360.00	0.00	1880	64	5518	61060	0.0903701277432034	0.141982288764099	0.141982288764099	true	false	false	true
95c87027-de2f-4b5a-82b9-69de429329e6	2026-08-20 12:23	2026-08-20 12:23	2026-08-20 12:23	XLF	XLF261120P00058000	put	58.0000	2026-11-20	1.9500	1.8900	1.9500	57.3312	83850.00	83850.00	0.00	430	12	529	1270	0.416535433070866	0.165132909456711	0.165132909456711	true	false	false	true
c3aa900c-669a-4a4c-9eaf-f88bf073be10	2026-08-19 15:45	2026-08-19 15:45	2026-08-19 15:45	XLF	XLF260821P00057500	put	57.5000	2026-08-21	0.2700	0.2300	0.2700	57.4950	130274.00	130248.00	26.00	4825	80	6112	8809	0.693835849699171	0.162507616475873	0.155167618623789	true	false	false	true
c375850f-e740-430a-ba6a-861f7ac1bb05	2026-08-19 15:24	2026-08-19 15:24	2026-08-19 15:24	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.7300	0.7300	0.7500	57.5300	115778.00	0.00	115778.00	1586	9	4230	59417	0.0711917464698655	0.131492162854899	0.131492162854899	false	false	false	true
8aa8ba04-c2c8-4c07-a998-b23260dd9c25	2026-08-19 12:34	2026-08-19 12:34	2026-08-19 12:34	XLF	XLF260918C00060000	call	60.0000	2026-09-18	0.2200	0.2200	0.2400	57.8300	53372.00	0.00	53372.00	2426	40	5187	35035	0.148051948051948	0.130424900073131	0.130424900073131	true	false	false	true
b542553c-d70b-4d6c-82d0-b31475d27fb6	2026-08-19 12:15	2026-08-19 12:15	2026-08-19 12:15	XLF	XLF270319P00056000	put	56.0000	2027-03-19	1.8800	1.8800	1.9900	57.9400	93624.00	0.00	93624.00	498	14	1558	351	4.43874643874644	0.189375848058907	0.189375848058907	false	false	false	true
740c5c15-51d5-4a0b-812d-96f8a27975e1	2026-08-19 12:13	2026-08-19 12:13	2026-08-19 12:13	XLF	XLF270319P00054000	put	54.0000	2027-03-19	1.3700	1.3600	1.4300	57.9200	91105.00	13837.00	77268.00	665	22	1729	1223	1.41373671300082	0.198415706029621	0.198415706029621	false	false	false	true
aa15a4b5-2962-42e7-a208-3843e4bc4ab4	2026-08-19 12:04	2026-08-19 12:04	2026-08-19 12:04	XLF	XLF270319P00056000	put	56.0000	2027-03-19	1.9100	1.9100	1.9700	57.8500	94163.00	0.00	94163.00	493	21	948	351	2.7008547008547	0.189442698124625	0.189442698124625	false	false	false	true
914d38dd-3075-4b2f-8e1c-ddac8ec6c7b7	2026-08-19 11:58	2026-08-19 11:58	2026-08-19 11:58	XLF	XLF270319P00054000	put	54.0000	2027-03-19	1.4100	1.3800	1.4500	57.7900	50619.00	18894.00	31725.00	359	16	527	1223	0.43090760425184	0.198982944075242	0.198982944075242	false	false	false	true
e75808bb-638d-465e-a7f8-ba68e028b4bb	2026-08-18 15:23	2026-08-18 15:23	2026-08-18 15:23	XLF	XLF270319P00057000	put	57.0000	2027-03-19	2.2700	2.2700	2.3000	57.9500	87849.00	0.00	87849.00	387	38	545	1307	0.416985462892119	0.189547685301654	0.189547685301654	false	false	false	true
27905bec-13e9-4dd0-976f-82152095d133	2026-08-18 12:58	2026-08-18 12:58	2026-08-18 12:58	XLF	XLF270630C00058000	call	58.0000	2027-06-30	4.5000	4.3500	4.6000	57.8150	837450.00	13950.00	823500.00	1861	121	1861	5	372.2	0.167422230372943	0.167422230372943	true	false	false	true
12401863-9325-4577-a212-1948c0e9a4eb	2026-08-18 12:36	2026-08-18 12:36	2026-08-18 12:36	XLF	XLF270319C00058000	call	58.0000	2027-03-19	3.4500	3.4500	3.5000	57.7700	60720.00	0.00	60720.00	176	11	177	571	0.309982486865149	0.164237203705626	0.164237203705626	false	false	false	true
909027aa-e8f6-4d41-8adf-8e31a1faa025	2026-08-18 12:03	2026-08-18 12:03	2026-08-18 12:03	XLF	XLF270115C00053000	call	53.0000	2027-01-15	6.2000	6.0500	6.2000	57.7700	500340.00	500340.00	0.00	807	22	1597	7575	0.210825082508251	0.172082680703298	0.172082680703298	true	false	false	true
a8fbbdb2-2d0a-4568-bc30-d24d2967b6be	2026-08-18 11:38	2026-08-18 11:38	2026-08-18 11:38	XLF	XLF260918C00059000	call	59.0000	2026-09-18	0.5000	0.4700	0.5100	57.8350	67800.00	150.00	67650.00	1356	13	1387	21136	0.0656226343679031	0.133727411394864	0.133446277216534	false	false	false	true
94eb8d96-c9bb-4d77-af03-b93291896201	2026-08-18 10:55	2026-08-18 10:55	2026-08-18 10:55	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.9500	0.9500	0.9800	57.8450	278445.00	0.00	278445.00	2931	11	3169	56872	0.0557216204810803	0.138849593951266	0.138849593951266	false	false	false	true
5fce5685-f8fe-4701-99a0-5cbd54b6ace5	2026-08-18 10:12	2026-08-18 10:12	2026-08-18 10:12	XLF	XLF261120C00058000	call	58.0000	2026-11-20	2.0600	2.0200	2.0900	57.9150	70452.00	20188.00	50264.00	342	6	342	12236	0.0279503105590062	0.154444299791002	0.154444299791002	false	false	false	true
fdb79fe8-92e1-47a6-8500-a53b817ea1ba	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	XLF	XLF270319P00058000	put	58.0000	2027-03-19	2.7500	2.7100	2.7500	57.8700	55000.00	55000.00	0.00	200	7	285	11460	0.024869109947644	0.190360476986664	0.190360476986664	false	false	false	true
2ec3dc11-2f9b-449b-a796-89141bca5eec	2026-08-18 09:40	2026-08-18 09:40	2026-08-18 09:40	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5500	0.5500	0.5700	57.0000	55000.00	0.00	55000.00	1000	6	1021	47182	0.0216396083252088	0.141031109775953	0.141031109775953	false	false	false	true
a86290bd-0027-4abb-be0f-39f960e4a492	2026-08-17 15:58	2026-08-17 15:58	2026-08-17 15:58	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5900	0.5700	0.5900	57.6150	10561.00	10561.00	0.00	179	8	12677	35440	0.35770316027088	0.138819947518205	0.138819947518205	false	false	false	true
b0eae1f7-0d85-495c-9d5e-36149ee7a0e1	2026-08-17 15:58	2026-08-17 15:58	2026-08-17 15:58	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5900	0.5700	0.6000	57.6150	68440.00	68440.00	0.00	1160	40	11466	35440	0.323532731376975	0.138819947518205	0.138819947518205	false	false	false	true
2e46347b-298f-487c-9fc9-330aefc65f75	2026-08-17 15:58	2026-08-17 15:58	2026-08-17 15:58	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5900	0.5700	0.6000	57.6150	51743.00	41359.00	10384.00	877	21	12343	35440	0.348278781038375	0.138819947518205	0.138819947518205	false	false	false	true
a8e43712-945e-426c-9da4-64f2547135de	2026-08-17 15:44	2026-08-17 15:44	2026-08-17 15:44	XLF	XLF260918C00056000	call	56.0000	2026-09-18	2.1700	2.1600	2.2000	57.6251	601524.00	0.00	601524.00	2772	11	18011	43749	0.411689410043658	0.151915131752816	0.151915131752816	false	false	false	true