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×

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

55c43f2c-11c8-4a23-96cf-ee8bcafd5836	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2900	0.3000	54.0000	22500.00	22500.00	0.00	750	19	9320	33080	0.28174123337364	0.177331868555782	0.177331868555782	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	51547946728.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
eca1148d-6871-449f-b386-bc5b4f9e13bc	2026-09-22 15:58	2026-09-22 15:58	2026-09-22 15:58	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2900	0.3000	54.0000	22500.00	22500.00	0.00	750	8	8570	33080	0.25906892382104	0.17745596041011	0.17745596041011	true	false	false	true
729d8888-0d4b-4747-8bcc-a649f47c398e	2026-09-22 15:58	2026-09-22 15:58	2026-09-22 15:58	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2800	0.3000	54.8000	22500.00	22500.00	0.00	750	8	7820	33080	0.23639661426844	0.177714371685996	0.177714371685996	true	false	false	true
282c120b-621e-4017-8567-7f36fec56495	2026-09-22 15:56	2026-09-22 15:56	2026-09-22 15:56	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2900	0.3000	54.8150	22500.00	22500.00	0.00	750	24	7070	33080	0.21372430471584	0.178488689739037	0.178488689739037	true	false	false	true
68a43275-47df-4065-b323-9b61ba2b6c96	2026-09-22 15:56	2026-09-22 15:56	2026-09-22 15:56	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2900	0.3000	54.8150	22050.00	22050.00	0.00	735	8	6315	33080	0.19090084643289	0.178488689739037	0.178488689739037	true	false	false	true
a5ebffff-5a8c-4e04-9f70-e74bdaeb1f77	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	XLF	XLF261016C00057000	call	57.0000	2026-10-16	0.2200	0.2000	0.2200	54.8155	16346.00	16346.00	0.00	743	30	7749	42113	0.184004939092442	0.15615065593508	0.15615065593508	true	false	false	true
0206fb1b-56bb-41c1-b74e-e91039fdc1a3	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	XLF	XLF261016C00057000	call	57.0000	2026-10-16	0.2200	0.2000	0.2300	54.8151	90926.00	87824.00	1694.00	4133	99	6882	42113	0.163417472039513	0.156170438744295	0.156170438744295	false	false	false	true
f0b06bb8-92c8-4fef-a190-432181a8d470	2026-09-22 15:54	2026-09-22 15:53	2026-09-22 15:53	XLF	XLF261016C00056500	call	56.5000	2026-10-16	0.3200	0.3200	0.3300	54.0000	48000.00	0.00	48000.00	1500	7	4416	358	12.3351955307263	0.152731286209614	0.152731286209614	true	false	false	true
27ef32b7-933c-4ae3-bfca-695e0a826e9e	2026-09-22 15:53	2026-09-22 15:53	2026-09-22 15:53	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2900	0.2800	0.2900	54.0000	21750.00	21750.00	0.00	750	14	5565	33080	0.16822853688029	0.178036434779847	0.178036434779847	true	false	false	true
120e8a73-984b-4887-9087-b022f63f4552	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2800	0.2700	0.2800	54.9000	15456.00	15456.00	0.00	552	6	4815	33080	0.14555622732769	0.177778042418407	0.177778042418407	true	false	false	true
3f2621bc-01d2-431d-b837-f1d2fd5f19b5	2026-09-22 15:49	2026-09-22 15:48	2026-09-22 15:48	XLF	XLF261120C00059000	call	59.0000	2026-11-20	0.2700	0.2700	0.2900	54.9250	27000.00	0.00	27000.00	1000	29	1455	3280	0.44359756097561	0.154691562483559	0.154691562483559	false	false	false	true
d2ccb99c-64c0-42ba-8039-9bc3ccf37ae3	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	XLF	XLF261218C00055000	call	55.0000	2026-12-18	1.9800	1.9800	2.0100	54.9350	53262.00	0.00	53262.00	269	14	326	18020	0.0180910099889012	0.162435877970616	0.162435877970616	true	false	false	true
0a176542-6aa0-4775-9c8b-5d611fc45d68	2026-09-22 15:45	2026-09-22 15:45	2026-09-22 15:45	XLF	XLF260922P00055000	put	55.0000	2026-09-22	0.1000	0.1000	0.1200	54.9050	17330.00	0.00	17330.00	1733	33	47680	1254	38.0223285486443	0.281384843447749	0.281384843447749	false	false	false	true
f542f480-2d22-4f2a-837b-b1f0a2b41795	2026-09-22 15:44	2026-09-22 15:44	2026-09-22 15:44	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2800	0.2700	0.2800	54.9050	15708.00	15708.00	0.00	561	8	4065	33080	0.122883917775091	0.178030161642526	0.178030161642526	true	false	false	true
ae66faa8-4bdf-4033-8ab3-a01fdc86977d	2026-09-22 15:39	2026-09-22 15:38	2026-09-22 15:38	XLF	XLF260925C00055000	call	55.0000	2026-09-25	0.3200	0.3000	0.3200	54.9499	18848.00	18848.00	0.00	589	26	1504	32	47	0.170142769516102	0.168942071962895	true	false	false	true
70b1a646-facb-49ff-9808-1336babd8b6e	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2800	0.2700	0.2800	54.9650	20748.00	20748.00	0.00	741	22	3296	33080	0.0996372430471584	0.181044610811969	0.181044610811969	true	false	false	true
ced73bc5-517c-479d-9000-52cac1283adf	2026-09-22 15:33	2026-09-22 15:33	2026-09-22 15:33	XLF	XLF260924C00055000	call	55.0000	2026-09-24	0.2500	0.2200	0.2500	54.9550	17975.00	17975.00	0.00	719	20	940	1	940	0.163985416617789	0.163985416617789	true	false	false	true
b4898c02-29a3-401f-a450-81c5187cac5c	2026-09-22 15:28	2026-09-22 15:28	2026-09-22 15:28	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2900	0.2800	0.2900	54.0000	21750.00	21750.00	0.00	750	5	2555	33080	0.0772370012091898	0.181087219664153	0.181087219664153	true	false	false	true
2c48c9e7-6050-4c2e-afbe-96330723b042	2026-09-22 14:59	2026-09-22 14:59	2026-09-22 14:59	XLF	XLF270331P00056000	put	56.0000	2027-03-31	2.7500	2.6700	2.7800	54.9100	13475.00	275.00	13200.00	49	15	99	111	0.891891891891892	0.180457950838789	0.180457950838789	true	false	false	true
66912965-abfe-4133-b32f-b205de3e5557	2026-09-22 14:19	2026-09-22 14:19	2026-09-22 14:19	XLF	XLF271217P00051000	put	51.0000	2027-12-17	2.3000	2.3000	2.3500	54.8950	11270.00	0.00	11270.00	49	7	147	12398	0.0118567510888853	0.219015633029217	0.219015633029217	false	false	false	true
06179942-7dfa-4446-a7af-5b26bbf264ab	2026-09-22 14:14	2026-09-22 14:14	2026-09-22 14:14	XLF	XLF271217C00055000	call	55.0000	2027-12-17	5.7500	5.7000	5.8500	54.8950	15525.00	575.00	14950.00	27	7	90	7346	0.0122515654778111	0.171489366322493	0.171489366322493	false	false	false	true
c2dbfd3f-f74e-4861-b271-144c33ec4545	2026-09-22 14:09	2026-09-22 14:09	2026-09-22 14:09	XLF	XLF270319C00075000	call	75.0000	2027-03-19	0.1000	0.0400	0.1100	54.9200	10000.00	10000.00	0.00	1000	7	16268	97044	0.167635299451795	0.216620102140726	0.216620102140726	false	false	false	true
d9425c5f-94b1-4312-8afd-8518b51d8c22	2026-09-22 14:01	2026-09-22 14:01	2026-09-22 14:01	XLF	XLF270115C00058000	call	58.0000	2027-01-15	0.9400	0.9100	0.9400	54.9550	34592.00	34592.00	0.00	368	14	1465	12421	0.117945415022945	0.148087371456061	0.148087371456061	false	false	false	true
0a34d6e6-2093-4089-a63f-be0dd8b13f92	2026-09-22 13:56	2026-09-22 13:56	2026-09-22 13:56	XLF	XLF261009P00055500	put	55.5000	2026-10-09	0.9100	0.9100	1.0000	55.0200	16380.00	0.00	16380.00	180	5	2390	975	2.45128205128205	0.14834378308815	0.14834378308815	false	false	false	true
64bbc4f4-1400-4d88-a5c7-5b7724266a7f	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	XLF	XLF270115C00057000	call	57.0000	2027-01-15	1.2900	1.2800	1.2900	55.0000	11481.00	11481.00	0.00	89	15	677	17975	0.037663421418637	0.148107133172659	0.148107133172659	false	false	false	true
da1ee8ad-ea83-4801-abe6-71b464d960f9	2026-09-22 13:46	2026-09-22 13:46	2026-09-22 13:46	XLF	XLF261016C00055000	call	55.0000	2026-10-16	0.9200	0.9000	0.9400	54.9400	134596.00	134044.00	0.00	1463	8	3968	31679	0.125256479055526	0.156324198828105	0.156324198828105	false	false	false	true
5aae5d2a-1fd0-40df-8f75-14cff9a7d2fb	2026-09-22 13:43	2026-09-22 13:43	2026-09-22 13:43	XLF	XLF261016P00055000	put	55.0000	2026-10-16	0.8700	0.8300	0.8900	54.9250	43250.00	21750.00	0.00	500	2	1535	41473	0.0370120319243845	0.160930782951202	0.160930782951202	false	true	false	true
50aef50a-ff66-4a3a-8fc0-0859427d85e0	2026-09-22 13:31	2026-09-22 13:31	2026-09-22 13:31	XLF	XLF261016C00056500	call	56.5000	2026-10-16	0.3200	0.3000	0.3200	54.0000	30048.00	30048.00	0.00	939	27	2573	358	7.18715083798883	0.149060267823344	0.149060267823344	false	false	false	true
eb0886ef-7693-4d34-94df-7d8f267bc0b6	2026-09-22 13:30	2026-09-22 13:30	2026-09-22 13:30	XLF	XLF261005P00053000	put	53.0000	2026-10-05	0.1200	0.1200	0.1400	54.0000	14880.00	0.00	14880.00	1240	31	1287	9	143	0.176207211060308	0.176207211060308	false	false	false	true
70eea684-d76f-4445-a38d-63e3ba3dfb9b	2026-09-22 13:13	2026-09-22 13:12	2026-09-22 13:12	XLF	XLF261016P00052000	put	52.0000	2026-10-16	0.1800	0.1700	0.1800	54.8550	13842.00	13842.00	0.00	769	19	1025	30564	0.0335361863630415	0.196537290967836	0.196537290967836	true	false	false	true
842aeb4a-68a6-4edd-a66a-55701f66012e	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLF	XLF261016P00056000	put	56.0000	2026-10-16	1.4800	1.4000	1.4800	54.8200	15836.00	15836.00	0.00	107	6	1495	204189	0.00732164808094461	0.153055435228329	0.153055435228329	false	false	false	true
e611514e-c092-43d2-bec7-b152cbaee3a8	2026-09-22 13:01	2026-09-22 13:01	2026-09-22 13:01	XLF	XLF261016C00056000	call	56.0000	2026-10-16	0.4600	0.4500	0.4600	54.0000	36478.00	36478.00	0.00	793	13	3402	21179	0.160630813541716	0.151355769801269	0.151355769801269	false	false	false	true
ba866219-c53c-4036-9ef1-09210854573b	2026-09-22 12:43	2026-09-22 12:43	2026-09-22 12:43	XLF	XLF261002C00055000	call	55.0000	2026-10-02	0.5300	0.5300	0.5600	54.8950	41128.00	0.00	41128.00	776	17	1205	152	7.92763157894737	0.152327013198922	0.152327013198922	false	false	false	true
d24562ae-ae6a-4b23-9bb7-b1a096ab2381	2026-09-22 12:36	2026-09-22 12:36	2026-09-22 12:36	XLF	XLF260925P00054000	put	54.0000	2026-09-25	0.0900	0.0900	0.1000	54.9050	27000.00	0.00	27000.00	3000	42	9977	3841	2.59750065087217	0.197623118683268	0.197623118683268	false	false	false	true
3c982054-bf17-4496-9d14-1b5ecc5fbeb1	2026-09-22 12:36	2026-09-22 12:36	2026-09-22 12:36	XLF	XLF261218P00048000	put	48.0000	2026-12-18	0.2400	0.2300	0.2800	54.9050	28944.00	6336.00	22608.00	1206	51	4106	26268	0.156311862342013	0.223150426718868	0.223150426718868	false	false	false	true
2907cd13-4c70-494d-8793-659acd5fa0b8	2026-09-22 12:36	2026-09-22 12:35	2026-09-22 12:35	XLF	XLF261218P00048000	put	48.0000	2026-12-18	0.2400	0.2400	0.2800	54.9150	30120.00	0.00	30120.00	1255	38	2900	26268	0.110400487284909	0.223353495191541	0.223353495191541	false	false	false	true
2d518906-7cca-47b4-8ec4-f5a59ed599ce	2026-09-22 12:35	2026-09-22 12:35	2026-09-22 12:35	XLF	XLF261218P00048000	put	48.0000	2026-12-18	0.2400	0.2300	0.2900	54.9150	37344.00	1584.00	35760.00	1556	59	1645	26268	0.0626237246840262	0.223353495191541	0.223353495191541	false	false	false	true
6f526dff-1831-4607-a830-3e4afe34686e	2026-09-22 12:32	2026-09-22 12:31	2026-09-22 12:31	XLF	XLF260925P00054000	put	54.0000	2026-09-25	0.1000	0.0900	0.1000	54.9101	30000.00	30000.00	0.00	3000	34	6975	3841	1.81593335068992	0.206133444080979	0.206133444080979	false	false	false	true
9bfc307b-0811-40b9-afce-6d25a0d03a1d	2026-09-22 12:31	2026-09-22 12:31	2026-09-22 12:31	XLF	XLF260925P00054000	put	54.0000	2026-09-25	0.1000	0.0900	0.1000	54.9100	30000.00	30000.00	0.00	3000	27	3975	3841	1.03488674824265	0.206119706841383	0.206119706841383	false	false	false	true
f8a59fe6-5a6f-46a7-bef9-f0beea5bff81	2026-09-22 12:29	2026-09-22 12:29	2026-09-22 12:29	XLF	XLF261009P00055500	put	55.5000	2026-10-09	0.9900	0.9900	1.0300	54.8800	46431.00	0.00	42471.00	469	9	1546	975	1.58564102564103	0.147653798495909	0.147653798495909	true	false	false	true
f4459401-003d-4cce-bad2-9d7fdfcfe052	2026-09-22 12:27	2026-09-22 12:27	2026-09-22 12:27	XLF	XLF270617P00048000	put	48.0000	2027-06-17	1.0300	1.0300	1.1000	54.8650	11639.00	0.00	11639.00	113	5	122	22081	0.00552511208731489	0.223894249585122	0.223894249585122	false	false	false	true
b357daa0-0835-4237-b2a7-0c5ef80a50a5	2026-09-22 12:26	2026-09-22 12:26	2026-09-22 12:26	XLF	XLF261030P00054000	put	54.0000	2026-10-30	0.7100	0.7100	0.7800	54.8600	10863.00	0.00	10863.00	153	17	172	30	5.73333333333333	0.16815360575862	0.16815360575862	true	false	false	true
5dae2d8c-013b-42b6-a461-b0c4c47d4550	2026-09-22 12:21	2026-09-22 12:21	2026-09-22 12:21	XLF	XLF261120P00054000	put	54.0000	2026-11-20	0.9600	0.9600	0.9900	54.8650	38400.00	0.00	38400.00	400	13	1380	24644	0.0559974030189904	0.171487633449003	0.171487633449003	false	false	false	true
95708ea0-4539-47d4-8961-fbf5b180783a	2026-09-22 12:19	2026-09-22 12:19	2026-09-22 12:19	XLF	XLF261218P00045000	put	45.0000	2026-12-18	0.1500	0.1500	0.1700	54.8450	25005.00	0.00	25005.00	1667	44	1675	9571	0.175007836171769	0.266386287191487	0.266386287191487	false	false	false	true
6c6954e5-8d84-43cb-b166-8a0cfb0ca02a	2026-09-22 12:19	2026-09-22 12:18	2026-09-22 12:18	XLF	XLF260922P00055000	put	55.0000	2026-09-22	0.2200	0.2000	0.2300	54.8500	31504.00	24310.00	7194.00	1432	7	10745	1254	8.56858054226475	0.294388973196192	0.294388973196192	false	false	false	true
d11d16f6-3bc8-42e9-81ba-b06626dfe825	2026-09-22 12:17	2026-09-22 12:17	2026-09-22 12:17	XLF	XLF260922P00055000	put	55.0000	2026-09-22	0.2200	0.2000	0.2600	54.8401	52184.00	43692.00	8492.00	2372	32	6336	1254	5.05263157894737	0.276658947250787	0.276658947250787	false	false	false	true
faa1f3dd-9f7b-445c-8f17-7e035ce5ed37	2026-09-22 12:17	2026-09-22 12:17	2026-09-22 12:17	XLF	XLF261009P00054500	put	54.5000	2026-10-09	0.5600	0.5500	0.6200	54.8450	17584.00	0.00	17528.00	314	9	397	285	1.39298245614035	0.162058677744522	0.162058677744522	true	false	false	true
59540067-e845-4ba5-b1fc-581a80c1d7f6	2026-09-22 12:15	2026-09-22 12:14	2026-09-22 12:14	XLF	XLF270115P00054000	put	54.0000	2027-01-15	1.4900	1.4900	1.5600	54.8450	10430.00	0.00	10430.00	70	7	103	11146	0.00924098331239907	0.180478847412785	0.180478847412785	false	false	false	true
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
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