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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = XLC×

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

2c71eeaa-036e-4670-9ceb-1948d68b9fe5	2026-09-28 11:53	2026-09-28 11:52	2026-09-28 11:52	XLC	XLC261218P00110000	put	110.0000	2026-12-18	3.1000	2.8500	3.2000	111.0000	26040.00	19220.00	4960.00	84	15	164	480	0.341666666666667	0.195239510517024	0.195239510517024	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	22981390368.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T15:53:41.284908Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
999f5e2e-7fdb-4ad0-bd68-7e2d091e1674	2026-09-24 14:56	2026-09-24 14:56	2026-09-24 14:56	XLC	XLC261120C00120000	call	120.0000	2026-11-20	1.2500	1.0500	1.2500	113.9300	10750.00	10750.00	0.00	86	26	362	475	0.762105263157895	0.175987308709068	0.175987308709068	false	false	false	true	false
f959355a-83fc-4139-b7b3-27c85501f233	2026-09-24 13:05	2026-09-24 13:05	2026-09-24 13:05	XLC	XLC261120C00120000	call	120.0000	2026-11-20	1.2500	1.0500	1.2500	113.8900	21115.00	21115.00	0.00	169	28	274	475	0.576842105263158	0.176709463745044	0.176709463745044	false	false	false	true	false
b259bf09-89ba-4bce-a278-bba8764074d1	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	XLC	XLC261120C00120000	call	120.0000	2026-11-20	1.1500	0.9500	1.1500	113.0000	12075.00	12075.00	0.00	105	25	105	475	0.221052631578947	0.174845551561049	0.174845551561049	false	false	false	true	false
8453e77d-4210-484f-acb4-39bf793c18bd	2026-09-23 14:38	2026-09-23 14:38	2026-09-23 14:38	XLC	XLC261030P00117000	put	117.0000	2026-10-30	4.7000	4.5000	4.7000	112.8950	14570.00	14570.00	0.00	31	8	31	0	0	0.170279703907989	0.170279703907989	false	false	false	true	false
d9297ce7-650b-4b65-9a3d-a32261da5ec8	2026-09-23 13:25	2026-09-23 13:25	2026-09-23 13:25	XLC	XLC261016C00118000	call	118.0000	2026-10-16	0.3500	0.3000	0.4000	112.0000	26040.00	25970.00	70.00	744	30	752	526	1.42965779467681	0.158237553563034	0.158237553563034	false	false	false	true	false
81948c82-b53c-4675-82e8-d268ffa2fda9	2026-09-22 14:18	2026-09-22 14:18	2026-09-22 14:18	XLC	XLC290119C00106000	call	106.0000	2029-01-19	23.8500	23.5000	25.3000	113.7501	71549.00	2380.00	69169.00	30	8	492	0	0	0.191625018929837	0.192979360588405	false	false	false	true	false
0d537dc4-3b10-4c56-8ee5-1d30dcce1636	2026-09-22 14:04	2026-09-22 14:04	2026-09-22 14:04	XLC	XLC261002C00117000	call	117.0000	2026-10-02	0.2500	0.1500	0.2500	113.8300	14350.00	14350.00	0.00	574	13	586	656	0.893292682926829	0.158629298402433	0.158629298402433	false	false	false	true	false
b8113545-df52-4fbb-9ce6-25fe9d148482	2026-09-22 11:29	2026-09-22 11:29	2026-09-22 11:29	XLC	XLC261120C00120000	call	120.0000	2026-11-20	1.5000	1.3000	1.5000	114.0000	67500.00	27450.00	0.00	450	5	452	29	15.5862068965517	0.173989398195519	0.173989398195519	false	false	false	true	false
1fdd9d92-f5c0-46c1-9ff7-05bc51bf4de7	2026-09-21 15:30	2026-09-21 15:30	2026-09-21 15:30	XLC	XLC261218C00117000	call	117.0000	2026-12-18	3.7000	3.5000	3.7000	115.2000	42550.00	42550.00	0.00	115	25	119	115	1.03478260869565	0.177306244434717	0.177306244434717	false	false	false	true	false
552181ff-4bdc-45a0-9b5f-79400c43e487	2026-09-21 14:32	2026-09-21 14:32	2026-09-21 14:32	XLC	XLC261218C00123000	call	123.0000	2026-12-18	1.2500	1.2500	1.5500	115.0000	11502.00	0.00	11502.00	92	10	162	199	0.814070351758794	0.157564677704855	0.157564677704855	false	false	false	true	false
05233ef8-1eba-4e82-9892-f0ca775ea401	2026-09-21 14:28	2026-09-21 14:28	2026-09-21 14:28	XLC	XLC261002C00117000	call	117.0000	2026-10-02	0.6500	0.4500	0.6500	115.2300	36530.00	36530.00	0.00	562	34	568	86	6.6046511627907	0.162566140555242	0.162566140555242	false	false	false	true	false
463df8ca-0e9f-49df-9df3-7af00f015e89	2026-09-21 13:57	2026-09-21 13:56	2026-09-21 13:56	XLC	XLC260925P00115000	put	115.0000	2026-09-25	0.8500	0.6500	0.8500	114.9950	25500.00	25500.00	0.00	300	42	400	31	12.9032258064516	0.181676122360295	0.181676122360295	true	false	false	true	false
d443d808-6002-428b-9808-929d5b8fb53f	2026-09-21 13:38	2026-09-21 13:38	2026-09-21 13:38	XLC	XLC261218C00120000	call	120.0000	2026-12-18	2.3000	2.0500	2.3500	114.0000	115431.00	114281.00	0.00	502	46	676	559	1.2093023255814	0.171617250400864	0.171617250400864	false	false	false	true	false
2dba2fd8-66dc-4f0c-9a33-0aa9ebc91677	2026-09-21 12:55	2026-09-21 12:55	2026-09-21 12:55	XLC	XLC261016C00118000	call	118.0000	2026-10-16	0.7500	0.6500	0.8000	114.0000	34350.00	33975.00	375.00	458	10	458	15	30.5333333333333	0.159194821508199	0.159194821508199	false	false	false	true	false
2715de43-01ef-40e4-aef6-c02cf8c3d092	2026-09-21 11:36	2026-09-21 11:36	2026-09-21 11:36	XLC	XLC261002C00115000	call	115.0000	2026-10-02	0.8000	0.6500	0.9500	113.0000	12385.00	11355.00	1030.00	155	28	155	4	38.75	0.15062579575307	0.14930575573562	false	false	false	true	false
b27a118e-9ff0-40bd-aaf8-c49f35716630	2026-09-18 15:22	2026-09-18 15:22	2026-09-18 15:22	XLC	XLC260918P00115000	put	115.0000	2026-09-18	2.6000	2.3500	3.9000	111.3600	13012.00	3610.00	9402.00	50	12	53	1066	0.049718574108818	3.62931268001484	3.62931268001484	false	false	false	true	false
b3889cfd-7aa8-4d09-b788-49b27a218190	2026-09-18 14:18	2026-09-18 14:18	2026-09-18 14:18	XLC	XLC270115P00096000	put	96.0000	2027-01-15	0.7500	0.7500	1.0500	111.3100	23720.00	0.00	23720.00	316	43	316	186	1.6989247311828	0.233849556220116	0.233849556220116	false	false	false	true	false
59b8b268-96e1-4b15-85a9-2eaba72634d4	2026-09-18 14:18	2026-09-18 14:18	2026-09-18 14:18	XLC	XLC270115P00100000	put	100.0000	2027-01-15	1.1500	1.1500	1.4500	111.3100	31165.00	0.00	31165.00	271	27	411	3321	0.123757904245709	0.218316575732359	0.218316575732359	false	false	false	true	false
671dddc6-28ab-4e1b-8e54-11a6c79b4b97	2026-09-18 13:47	2026-09-18 13:47	2026-09-18 13:47	XLC	XLC270115P00100000	put	100.0000	2027-01-15	1.2000	1.2000	1.4500	111.3100	16825.00	0.00	16825.00	140	24	140	3321	0.0421559771153267	0.221653369800818	0.221653369800818	false	false	false	true	false
247551a9-20dc-4623-b913-15bd7967f886	2026-09-16 13:35	2026-09-16 13:35	2026-09-16 13:35	XLC	XLC260918P00115000	put	115.0000	2026-09-18	1.3000	1.2000	1.3000	113.9600	11180.00	11180.00	0.00	86	26	239	1076	0.222118959107807	0.199469464029467	0.199469464029467	false	false	false	true	false
b3be8b4c-3bfe-4fc9-a6c1-02124da342c7	2026-09-16 11:24	2026-09-16 11:24	2026-09-16 11:24	XLC	XLC260918P00115000	put	115.0000	2026-09-18	1.1500	1.0500	1.1500	114.2000	17595.00	17595.00	0.00	153	29	153	1076	0.142193308550186	0.205283393042411	0.205283393042411	false	false	false	true	false
ffdea510-55ec-46c8-b512-953369f1a717	2026-09-10 10:32	2026-09-10 10:32	2026-09-10 10:32	XLC	XLC261023P00110000	put	110.0000	2026-10-23	2.0000	2.0000	2.3500	111.8100	13800.00	0.00	13800.00	69	21	69	3	23	0.199267526737401	0.199267526737401	false	false	false	true	false
216ca231-a8fa-4b10-bd95-0d948285a113	2026-09-08 15:49	2026-09-08 15:49	2026-09-08 15:49	XLC	XLC261016C00116000	call	116.0000	2026-10-16	0.8000	0.6500	0.8000	111.7300	18860.00	18860.00	0.00	236	36	242	16	15.125	0.150212396124447	0.150212396124447	false	false	false	true	false
096ef924-0266-4310-a7f9-30305c59dcde	2026-09-08 14:00	2026-09-08 13:59	2026-09-08 13:59	XLC	XLC261218P00104000	put	104.0000	2026-12-18	1.6000	1.6000	1.8000	111.4300	29280.00	0.00	29280.00	183	13	184	7	26.2857142857143	0.208938082772328	0.208938082772328	false	false	false	true	false
181b55b1-ca23-4f0d-a6cb-9fa8548c36fb	2026-09-03 14:47	2026-09-03 14:47	2026-09-03 14:47	XLC	XLC261016C00117000	call	117.0000	2026-10-16	1.1000	0.9500	1.1000	113.5950	13090.00	13090.00	0.00	119	14	146	47	3.1063829787234	0.142856531925699	0.142856531925699	false	false	false	true	false
ddc6a48a-744e-4b1a-b157-f7dee933a8b4	2026-09-03 13:13	2026-09-03 13:13	2026-09-03 13:13	XLC	XLC261218P00106000	put	106.0000	2026-12-18	1.6500	1.6500	1.9000	113.3400	93225.00	0.00	93225.00	565	30	572	30	19.0666666666667	0.20308577270479	0.20308577270479	false	false	false	true	false
6cea6dfe-91b7-4950-81c3-212a18519c76	2026-09-03 10:58	2026-09-03 10:58	2026-09-03 10:58	XLC	XLC260918P00113500	put	113.5000	2026-09-18	1.5500	1.4500	1.6000	112.9550	23095.00	23095.00	0.00	149	11	149	0	0	0.148519617596714	0.148519617596714	false	false	false	true	false
1098b430-138e-44df-a607-f0818a06bb49	2026-09-01 13:29	2026-09-01 13:29	2026-09-01 13:29	XLC	XLC260918P00107000	put	107.0000	2026-09-18	0.3500	0.3000	0.4500	111.1450	17338.00	210.00	17128.00	494	38	497	1021	0.486777668952008	0.182431126370621	0.182431126370621	false	false	false	true	false
0026f8d6-a96a-4224-9a80-30f4d61b1c5e	2026-08-31 14:28	2026-08-31 14:27	2026-08-31 14:27	XLC	XLC280121P00095000	put	95.0000	2028-01-21	4.2000	3.2000	5.0000	111.5350	294000.00	294000.00	0.00	700	1	700	1050	0.666666666666667	0.25258919063923	0.25258919063923	false	true	false	true	false
52fd4784-7699-4050-aaa7-e7a724503ac1	2026-08-27 14:29	2026-08-27 14:29	2026-08-27 14:29	XLC	XLC260918P00108000	put	108.0000	2026-09-18	0.6500	0.5000	0.7000	111.4950	12870.00	12740.00	0.00	198	27	231	328	0.704268292682927	0.184872307468075	0.184872307468075	true	false	false	true	false
d8b502b8-a282-41b4-bd82-f35cd9ea3040	2026-08-27 13:54	2026-08-27 13:54	2026-08-27 13:54	XLC	XLC260918P00110000	put	110.0000	2026-09-18	1.1000	1.0000	1.1000	111.5250	16935.00	16830.00	0.00	154	26	251	1272	0.197327044025157	0.171157364301877	0.166181517491077	true	false	false	true	false
07d84c80-b08f-4e82-b552-17c7be753b28	2026-08-25 15:49	2026-08-25 15:49	2026-08-25 15:49	XLC	XLC260918P00113000	put	113.0000	2026-09-18	1.6000	1.6000	1.7000	113.2450	13600.00	0.00	13600.00	85	20	85	11	7.72727272727273	0.160182321450424	0.160182321450424	false	false	false	true	false
b51238c2-f85f-494e-bc44-eb0e60da4d00	2026-08-21 15:39	2026-08-21 15:39	2026-08-21 15:39	XLC	XLC261218C00122000	call	122.0000	2026-12-18	1.4500	1.2500	1.4500	111.4600	16385.00	16385.00	0.00	113	25	122	285	0.428070175438596	0.17518268650007	0.17518268650007	false	false	false	true	false
f7265d9e-2572-4228-aefd-c606273edbc0	2026-08-21 11:52	2026-08-21 11:52	2026-08-21 11:52	XLC	XLC261218C00120000	call	120.0000	2026-12-18	2.0000	1.7500	2.0000	111.8000	16400.00	16400.00	0.00	82	21	82	444	0.184684684684685	0.175147091298646	0.175147091298646	false	false	false	true	false
f5e2d13c-082a-46cb-bab7-04c81144a76f	2026-08-20 14:41	2026-08-20 14:41	2026-08-20 14:41	XLC	XLC260918P00110000	put	110.0000	2026-09-18	1.7000	1.7000	1.9000	110.5350	30770.00	0.00	30770.00	181	22	268	997	0.268806419257773	0.169938363724264	0.169938363724264	true	false	false	true	false
e597a0b3-98f1-434d-b197-5540fcab72e4	2026-08-19 15:56	2026-08-19 15:56	2026-08-19 15:56	XLC	XLC260918C00115000	call	115.0000	2026-09-18	0.7500	0.7000	0.9000	111.2400	17325.00	75.00	17250.00	231	24	247	83	2.97590361445783	0.155603759358085	0.155603759358085	true	false	false	true	false
6aec8b5f-26dc-4588-a9e3-31ae0c2983fd	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	XLC	XLC261218C00120000	call	120.0000	2026-12-18	2.0000	1.5500	2.1500	111.9700	43389.00	43389.00	0.00	217	31	217	235	0.923404255319149	0.170840976898674	0.170840976898674	false	false	false	true	false
bc8f439f-f554-4edf-b129-a7918cd1ebe5	2026-08-18 15:27	2026-08-18 15:27	2026-08-18 15:27	XLC	XLC280121P00110000	put	110.0000	2028-01-21	8.7500	7.6000	10.2000	110.8601	700000.00	0.00	700000.00	800	2	800	19	42.1052631578947	0.236181284281002	0.236181284281002	false	true	true	false	true
a597eeaf-868a-417d-aa6b-7cb3b9ca72d9	2026-08-17 14:23	2026-08-17 14:23	2026-08-17 14:23	XLC	XLC261218C00117000	call	117.0000	2026-12-18	2.7500	2.4500	2.7500	110.8200	20075.00	20075.00	0.00	73	11	81	29	2.79310344827586	0.179804746609857	0.179804746609857	false	false	false	true	false
396fdac7-5460-4d08-b6b5-ef74fec6052a	2026-08-17 13:01	2026-08-17 13:01	2026-08-17 13:01	XLC	XLC260821P00111000	put	111.0000	2026-08-21	0.8000	0.5500	0.8000	110.9850	16000.00	16000.00	0.00	200	31	405	54	7.5	0.175957453822119	0.175957453822119	true	false	false	true	false
9efde821-20f4-4a31-a2a7-1fdfb79bf8eb	2026-08-17 13:01	2026-08-17 13:01	2026-08-17 13:01	XLC	XLC260821P00111000	put	111.0000	2026-08-21	0.8000	0.7000	0.8000	111.0150	15999.00	15999.00	0.00	200	40	205	54	3.7962962962963	0.179113186209286	0.179113186209286	true	false	false	true	false