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:alert_rule = RepeatedHits×ticker = XLF×sorted by created_at ↑×

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

328c214d-0ef3-4b1d-9c56-95dc12ea2b07	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	XLF	XLF261016C00060000	call	60.0000	2026-10-16	0.6200	0.5600	0.6900	58.0300	31000.00	3720.00	27280.00	500	21	500	39802	0.0125621828048842	0.132475973331665	0.132475973331665	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-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5148308f-ff61-4856-bb2e-0ac1b6c4d0ca	2026-08-17 09:49	2026-08-17 09:49	2026-08-17 09:49	XLF	XLF280121C00050000	call	50.0000	2028-01-21	12.0000	11.6500	12.0000	58.1800	102000.00	15600.00	0.00	85	5	85	542	0.156826568265683	0.177072920671161	0.177072920671161	false	false	false	true
08ed113c-70bc-4e7a-9f70-a5ff416497a1	2026-08-17 09:52	2026-08-17 09:52	2026-08-17 09:52	XLF	XLF260918C00060000	call	60.0000	2026-09-18	0.3000	0.3000	0.3300	58.1500	10530.00	0.00	10530.00	351	29	451	35225	0.0128034066713982	0.128163549048288	0.128163549048288	false	false	false	true
04ce20dd-fc2c-4b81-91e3-281ee955b1dc	2026-08-17 10:25	2026-08-17 10:24	2026-08-17 10:24	XLF	XLF260918C00058000	call	58.0000	2026-09-18	1.0600	1.0600	1.0700	58.0900	26500.00	0.00	26500.00	250	27	269	56220	0.00478477410174315	0.13313909931439	0.13313909931439	false	false	false	true
b799a1d0-7216-480d-8342-2e7135f0bf68	2026-08-17 10:58	2026-08-17 10:57	2026-08-17 10:57	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.9300	0.9300	0.9600	57.8850	22320.00	0.00	22320.00	240	19	584	56220	0.0103877623621487	0.13029438445845	0.13029438445845	false	false	false	true
46ada6d3-9006-497f-85b9-2767f5abb461	2026-08-17 11:22	2026-08-17 11:22	2026-08-17 11:22	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.4500	0.4400	0.4600	57.9800	23445.00	23355.00	0.00	521	23	588	35440	0.0165914221218962	0.135560357317071	0.135560357317071	false	false	false	true
00617611-34ed-4a6d-abda-d64365ff188c	2026-08-17 11:23	2026-08-17 11:23	2026-08-17 11:23	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.4600	0.4500	0.4600	57.9600	22034.00	22034.00	0.00	479	9	1067	35440	0.030107223476298	0.136227733474316	0.136227733474316	false	false	false	true
aa1d9062-87d8-4704-aa17-6057f0a08539	2026-08-17 11:50	2026-08-17 11:50	2026-08-17 11:50	XLF	XLF270115P00057000	put	57.0000	2027-01-15	1.8100	1.8100	1.8300	57.8695	10498.00	0.00	10498.00	58	8	151	13991	0.0107926524194125	0.178592556837698	0.178592556837698	false	false	false	true
70ec72a0-9e87-4029-b1b7-27a137e4656c	2026-08-17 11:56	2026-08-17 11:56	2026-08-17 11:56	XLF	XLF261120P00058000	put	58.0000	2026-11-20	1.7100	1.6700	1.7500	57.9000	32490.00	24111.00	8379.00	190	8	282	852	0.330985915492958	0.165522123263027	0.165522123263027	false	false	false	true
3da92788-eecc-41ec-8f2e-2cf3eed4cc2a	2026-08-17 12:13	2026-08-17 12:13	2026-08-17 12:13	XLF	XLF270115C00054000	call	54.0000	2027-01-15	5.4500	5.4000	5.5500	57.9600	18530.00	0.00	18530.00	34	5	75	18272	0.00410464098073555	0.158308632611491	0.158308632611491	false	false	false	true
1d065abe-ed76-41c5-89a7-6a51ec102696	2026-08-17 12:33	2026-08-17 12:33	2026-08-17 12:33	XLF	XLF270115C00054000	call	54.0000	2027-01-15	5.4500	5.4000	5.5000	57.9450	10355.00	3815.00	0.00	19	7	119	18272	0.00651269702276708	0.15954569974244	0.15954569974244	false	false	false	true
4acc2ac8-6836-49ef-bad0-d0a9e4c2147c	2026-08-17 13:31	2026-08-17 13:31	2026-08-17 13:31	XLF	XLF270319P00053000	put	53.0000	2027-03-19	1.2500	1.2200	1.2500	57.8900	25000.00	25000.00	0.00	200	16	204	781	0.261203585147247	0.208591276866819	0.208591276866819	false	false	false	true
050a2c26-68ce-47f5-bb9a-a7ef7460813a	2026-08-17 14:49	2026-08-17 14:49	2026-08-17 14:49	XLF	XLF270319P00058000	put	58.0000	2027-03-19	2.7400	2.7400	2.7500	57.8050	15344.00	0.00	1644.00	56	19	1095	11001	0.0995364057812926	0.187761288236303	0.187761288236303	false	false	false	true
8a100ad1-2078-487d-9f2d-9c8603985636	2026-08-17 14:56	2026-08-17 14:56	2026-08-17 14:56	XLF	XLF260918P00052000	put	52.0000	2026-09-18	0.0600	0.0500	0.0700	57.7500	17400.00	17394.00	6.00	2900	25	13881	40389	0.343682685879819	0.212547911381975	0.212547911381975	true	false	false	true
a0b0924f-1785-43b8-b390-7dbeff806e6b	2026-08-17 15:00	2026-08-17 15:00	2026-08-17 15:00	XLF	XLF260918P00056000	put	56.0000	2026-09-18	0.3100	0.2800	0.3100	57.7615	10850.00	10850.00	0.00	350	11	7858	85844	0.0915381389497227	0.148377641582214	0.148377641582214	false	false	false	true
b1cc41ed-4f59-4adc-9de8-7bf041a273f8	2026-08-17 15:11	2026-08-17 15:11	2026-08-17 15:11	XLF	XLF270115C00065000	call	65.0000	2027-01-15	0.4200	0.4100	0.4300	57.7450	25494.00	0.00	25158.00	607	5	1025	46083	0.0222424755332769	0.148066416166656	0.148066416166656	false	false	false	true
4d4580c2-1532-4264-bec7-5e29882f52df	2026-08-17 15:26	2026-08-17 15:26	2026-08-17 15:26	XLF	XLF260918P00055000	put	55.0000	2026-09-18	0.1900	0.1800	0.1900	57.7300	11077.00	11077.00	0.00	583	23	3783	16190	0.233662754786905	0.161263346055859	0.161263346055859	false	false	false	true
a63e5729-a472-4dd4-8d8e-2ce6a1855ce8	2026-08-17 15:28	2026-08-17 15:28	2026-08-17 15:28	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.9500	0.9300	0.9500	57.7450	28310.00	28310.00	0.00	298	22	30453	62001	0.491169497266173	0.134648666392123	0.134648666392123	false	false	false	true
c86464fc-e7d4-4aab-81b0-ae4286993e35	2026-08-17 15:30	2026-08-17 15:30	2026-08-17 15:30	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5600	0.5500	0.5600	57.7150	13552.00	13552.00	0.00	242	13	9582	35440	0.270372460496614	0.139623647017604	0.139623647017604	false	false	false	true
67bf812f-a8f4-4bd7-a9a3-3817a2a972d4	2026-08-17 15:30	2026-08-17 15:30	2026-08-17 15:30	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5600	0.5500	0.5600	57.7250	13384.00	13384.00	0.00	239	17	9340	35440	0.263544018058691	0.140169523394037	0.140169523394037	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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