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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 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

a692076b-7775-47e0-9c32-501a116cd61c	2026-09-23 10:21	2026-09-23 10:21	2026-09-23 10:21	XLF	XLF261030P00054000	put	54.0000	2026-10-30	0.6800	0.6800	0.7500	55.0250	16796.00	0.00	16796.00	247	10	248	268	0.925373134328358	0.174059616286935	0.174059616286935	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	51561995189.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T14:22:47.791063Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
72a94da6-4e24-4120-9ebc-52dda0b078e1	2026-09-23 10:21	2026-09-23 10:21	2026-09-23 10:21	XLF	XLF261016C00056500	call	56.5000	2026-10-16	0.3800	0.3800	0.4100	55.0250	38457.00	39.00	38418.00	1012	24	1097	3153	0.347922613384079	0.160113078582814	0.162250041790599	false	false	false	true
58e2eac5-33ef-4cb6-b609-bb925d73e351	2026-09-23 10:21	2026-09-23 10:21	2026-09-23 10:21	XLF	XLF261120C00056000	call	56.0000	2026-11-20	1.1500	1.1500	1.2100	55.0250	48875.00	0.00	48875.00	425	9	483	35011	0.0137956642198166	0.163155510481889	0.163155510481889	false	false	false	true
c3a6aae2-7515-4210-af93-fbd14f9afc84	2026-09-23 10:19	2026-09-23 10:19	2026-09-23 10:19	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1100	0.1100	0.1300	55.0000	15279.00	0.00	15279.00	1389	9	5000	74555	0.0670645831936155	0.324427746502162	0.324427746502162	false	false	false	true
70b2748d-293d-4f4d-9a11-c18b54038993	2026-09-23 10:19	2026-09-23 10:19	2026-09-23 10:19	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1100	0.1100	0.1300	55.0000	31438.00	0.00	31438.00	2858	38	3611	74555	0.0484340419824291	0.324286895312363	0.324286895312363	false	false	false	true
22d9faf5-f6c2-4a9b-a4d2-62705a52c49d	2026-09-23 10:14	2026-09-23 10:14	2026-09-23 10:14	XLF	XLF260923C00055000	call	55.0000	2026-09-23	0.1700	0.1700	0.1800	54.0000	15062.00	0.00	15062.00	886	27	1584	3262	0.485591661557327	0.305225279806078	0.305225279806078	false	false	false	true
f216146a-7d60-4613-81ce-02eecb276047	2026-09-23 10:06	2026-09-23 10:06	2026-09-23 10:06	XLF	XLF261023C00055500	call	55.5000	2026-10-23	0.7900	0.7400	0.7900	54.0000	33891.00	33891.00	0.00	429	33	439	125	3.512	0.160643337212332	0.160643337212332	false	false	false	true
8e055bf0-4301-41d4-843e-bd00030ced9b	2026-09-23 09:54	2026-09-23 09:53	2026-09-23 09:53	XLF	XLF261023P00054500	put	54.5000	2026-10-23	0.8100	0.7300	0.8200	54.7600	36369.00	36369.00	0.00	449	24	450	77	5.84415584415584	0.162531243035783	0.162531243035783	false	false	false	true
bfe5259a-89db-4e89-a3e9-c1fac01c5232	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	XLF	XLF270115C00056000	call	56.0000	2027-01-15	1.6700	1.6700	1.7400	54.7850	13026.00	0.00	13026.00	78	8	300	5185	0.0578592092574735	0.154765079959883	0.154765079959883	false	false	false	true
e91d3b73-2c4a-4563-8eea-4bbffd9c2a9c	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	XLF	XLF261002P00057000	put	57.0000	2026-10-02	2.2600	2.1300	2.2600	54.0000	394822.00	394822.00	0.00	1747	34	2012	198	10.1616161616162	0.2125440667562	0.2125440667562	false	false	false	true
c5bd86df-eadb-4780-8b27-950c8cdda48a	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.2600	1.0900	1.2600	54.0000	123732.00	123732.00	0.00	982	21	1374	20012	0.0686588047171697	0.696678042721908	0.696678042721908	false	false	false	true
3e5f7794-7092-42b8-8d3f-d28d6dd0e74d	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	XLF	XLF260930C00055000	call	55.0000	2026-09-30	0.3700	0.3600	0.4100	54.0000	15503.00	0.00	15318.00	419	11	623	3403	0.183073758448428	0.146642351316767	0.146642351316767	false	false	false	true
609e5ef7-15e4-4b6e-99e6-d73a133331f6	2026-09-23 09:47	2026-09-23 09:47	2026-09-23 09:47	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.2600	1.0900	1.2600	54.0000	49392.00	49392.00	0.00	392	8	392	20012	0.0195882470517689	0.745706117764162	0.745706117764162	false	false	false	true
5dfc7230-4976-45bd-a4a8-0933cbb2923a	2026-09-23 09:47	2026-09-23 09:47	2026-09-23 09:47	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.5500	0.4800	0.5500	54.0000	25795.00	25795.00	0.00	469	8	3123	17809	0.175360772643046	0.157188959601973	0.156647967843463	false	false	false	true
37730de8-6de7-4e0b-af16-f2d35904b8e8	2026-09-23 09:47	2026-09-23 09:47	2026-09-23 09:47	XLF	XLF260924P00055500	put	55.5000	2026-09-24	0.8000	0.6700	0.8000	54.0000	113840.00	113840.00	0.00	1423	23	1425	234	6.08974358974359	0.318847821458045	0.316220657920172	false	false	false	true
287be9e7-586c-4dcb-a88c-a773104a4003	2026-09-23 09:47	2026-09-23 09:47	2026-09-23 09:47	XLF	XLF261002P00055500	put	55.5000	2026-10-02	0.9600	0.8300	0.9600	54.0000	16800.00	16800.00	0.00	175	9	205	2014	0.101787487586892	0.172038187958957	0.171412042217338	false	false	false	true
87b6b3d3-3c44-44fa-a399-cff12be65601	2026-09-23 09:47	2026-09-23 09:47	2026-09-23 09:47	XLF	XLF270115C00056000	call	56.0000	2027-01-15	1.7100	1.6300	1.7100	54.0000	37962.00	37962.00	0.00	222	26	222	5185	0.0428158148505304	0.154890610574579	0.154890610574579	false	false	false	true
8b142937-f449-4a0a-ae90-f6d52d16ffca	2026-09-23 09:47	2026-09-23 09:46	2026-09-23 09:46	XLF	XLF260923C00054500	call	54.5000	2026-09-23	0.3500	0.3500	0.4200	54.0000	30065.00	0.00	30065.00	859	31	862	12	71.8333333333333	0.337343669439959	0.168472922544563	false	false	false	true
3dd22e4e-ef66-4857-83b4-9826ae0d6bac	2026-09-23 09:47	2026-09-23 09:46	2026-09-23 09:46	XLF	XLF260923P00055000	put	55.0000	2026-09-23	0.2800	0.2200	0.2800	54.0000	66976.00	66976.00	0.00	2392	51	2418	2925	0.826666666666667	0.337481510978241	0.337481510978241	false	false	false	true
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
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