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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = SCHW×

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

479acd1a-b6cc-4df4-ace6-0cb6cfe88854	2026-09-21 15:12	2026-09-21 15:12	2026-09-21 15:12	SCHW	SCHW261218C00115000	call	115.0000	2026-12-18	2.7300	2.6600	2.7300	107.0800	14742.00	14742.00	0.00	54	13	176	13255	0.0132780082987552	0.25270166177262	0.25270166177262	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	184831401112.00	2026-10-15	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
1d94f48a-ecba-4e88-9e78-cc83c1a92d21	2026-09-21 14:51	2026-09-21 14:51	2026-09-21 14:51	SCHW	SCHW280121C00120000	call	120.0000	2028-01-21	10.7500	10.7500	10.9500	107.0950	25800.00	0.00	25800.00	24	12	31	355	0.0873239436619718	0.264373910999128	0.264373910999128	false	false	false	true
200ecce3-a292-498f-8b77-648c47ca8d74	2026-09-21 13:53	2026-09-21 13:53	2026-09-21 13:53	SCHW	SCHW261016P00104000	put	104.0000	2026-10-16	1.7800	1.7300	1.8100	107.0550	11214.00	890.00	8010.00	63	6	160	0	0	0.288502702329281	0.288502702329281	false	false	false	true
7bab1f53-86a6-4cac-b5db-28a03a93cde1	2026-09-21 13:27	2026-09-21 13:27	2026-09-21 13:27	SCHW	SCHW261218P00115000	put	115.0000	2026-12-18	9.9300	9.7500	10.0000	107.0800	30796.00	30796.00	0.00	31	6	468	297	1.57575757575758	0.278183548182751	0.273562088414893	false	false	false	true
e4c35bdd-864d-4aef-8b17-1a7734bbe2cb	2026-09-21 13:26	2026-09-21 13:26	2026-09-21 13:26	SCHW	SCHW261218P00115000	put	115.0000	2026-12-18	9.9500	9.7500	9.9500	107.1650	40795.00	40795.00	0.00	41	9	324	297	1.09090909090909	0.278440263025457	0.278440263025457	false	false	false	true
baed197d-77c5-4674-8117-b6f64c6f147d	2026-09-21 13:25	2026-09-21 13:25	2026-09-21 13:25	SCHW	SCHW261218P00115000	put	115.0000	2026-12-18	9.9900	9.7000	10.0000	107.2800	50959.00	50959.00	0.00	51	7	211	297	0.71043771043771	0.284745479006392	0.28423846337402	false	false	false	true
61a9cc3a-7e13-477d-b69f-98c66b4bdf2e	2026-09-21 13:25	2026-09-21 13:25	2026-09-21 13:25	SCHW	SCHW261218P00115000	put	115.0000	2026-12-18	9.7300	9.7000	9.8000	107.3250	39912.00	1960.00	37952.00	41	7	160	297	0.538720538720539	0.276052207424977	0.271974454910783	false	false	false	true
7a0270db-9500-4b38-b621-b168a5724971	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	SCHW	SCHW261218P00115000	put	115.0000	2026-12-18	9.8000	9.6000	9.8000	107.0000	39199.00	39199.00	0.00	40	14	89	297	0.2996632996633	0.276869899123332	0.276869899123332	false	false	false	true
94c2a8b2-a860-47a6-9f5c-1e4516f41f01	2026-09-21 13:08	2026-09-21 13:08	2026-09-21 13:08	SCHW	SCHW261016C00115000	call	115.0000	2026-10-16	0.7400	0.6600	0.7400	107.0400	14504.00	14504.00	0.00	196	41	255	11694	0.0218060543868651	0.27802863666255	0.27802863666255	false	false	false	true
2efaba5a-30a5-41f9-b904-b597d72bffda	2026-09-21 11:48	2026-09-21 11:48	2026-09-21 11:48	SCHW	SCHW280121C00125000	call	125.0000	2028-01-21	9.0000	8.8000	9.0000	106.7350	72895.00	72000.00	895.00	81	25	85	954	0.0890985324947589	0.265453788949188	0.265453788949188	false	false	false	true
48c085ca-61a0-4e2c-92b7-ab49fcce40b2	2026-09-21 10:34	2026-09-21 10:33	2026-09-21 10:33	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	1.7300	1.7300	1.9100	106.3300	43250.00	0.00	43250.00	250	47	270	9843	0.0274306613837245	0.277725003552318	0.277725003552318	true	false	false	true
1d9ec549-01d7-4b98-96b9-4b13928e13ad	2026-09-18 15:07	2026-09-18 15:06	2026-09-18 15:06	SCHW	SCHW280121C00097500	call	97.5000	2028-01-21	20.2000	20.2000	20.8000	105.3400	107060.00	0.00	107060.00	53	6	53	542	0.0977859778597786	0.267185114436243	0.267185114436243	false	false	false	true
b83b5db1-027e-45ca-a1c6-9d751cc90456	2026-09-18 14:08	2026-09-18 14:08	2026-09-18 14:08	SCHW	SCHW261016C00105000	call	105.0000	2026-10-16	3.3500	3.2000	3.3500	104.9850	64990.00	64990.00	0.00	194	30	1078	3322	0.324503311258278	0.275938024432849	0.275938024432849	false	false	false	true
583f07e1-32f4-4899-b46d-13885711b4ff	2026-09-18 14:08	2026-09-18 14:08	2026-09-18 14:08	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	1.3500	1.2900	1.3500	104.9850	51840.00	51840.00	0.00	384	46	607	9501	0.0638880117882328	0.265974085593721	0.265974085593721	false	false	false	true
4b67e380-20a6-4cd6-8edd-ab7624a87180	2026-09-18 11:07	2026-09-18 11:07	2026-09-18 11:07	SCHW	SCHW270115P00097500	put	97.5000	2027-01-15	2.9700	2.9600	3.1000	104.8400	51084.00	0.00	50787.00	172	27	172	1692	0.101654846335697	0.279723943644171	0.279723943644171	false	false	false	true
c5b9e082-822b-4cc9-89a8-ddb70df96319	2026-09-17 10:07	2026-09-17 10:07	2026-09-17 10:07	SCHW	SCHW261016P00105000	put	105.0000	2026-10-16	3.8000	3.6000	3.9500	103.7500	156940.00	78280.00	78660.00	413	38	1406	4496	0.312722419928826	0.283359369057545	0.283359369057545	false	false	false	true
ba040e02-95ca-45e8-84c2-ef29b7dc195e	2026-09-16 10:35	2026-09-16 10:35	2026-09-16 10:35	SCHW	SCHW260918P00107000	put	107.0000	2026-09-18	1.0600	1.0300	1.0600	106.7400	65720.00	64660.00	0.00	620	9	620	1624	0.381773399014778	0.303628008270224	0.296856577011589	false	false	false	true
2bc9bc58-8f0c-4159-b0ed-5e6ca9f8990d	2026-09-16 10:35	2026-09-16 10:35	2026-09-16 10:35	SCHW	SCHW260918P00108000	put	108.0000	2026-09-18	1.6600	1.6400	1.6700	106.7400	90398.00	65798.00	24600.00	544	7	550	1741	0.315910396323952	0.301073394649755	0.29106944672913	false	false	false	true
d601a196-426d-4e4d-8c6c-f6d4dae66ab2	2026-09-15 11:42	2026-09-15 11:41	2026-09-15 11:41	SCHW	SCHW261120C00110000	call	110.0000	2026-11-20	4.5500	4.4000	4.5500	108.2100	85085.00	85085.00	0.00	187	37	202	1104	0.182971014492754	0.27253773742079	0.27253773742079	false	false	false	true
c3914026-0152-4deb-9722-86c928dbed58	2026-09-15 09:32	2026-09-15 09:32	2026-09-15 09:32	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	3.0700	2.1700	3.7500	108.6378	88899.00	46330.00	42569.00	290	9	302	5613	0.0538036700516658	0.271311573685858	0.285439268217435	false	false	false	true
b4ce62e2-91d3-4319-bcff-9e693e4f5edc	2026-09-14 14:14	2026-09-14 14:14	2026-09-14 14:14	SCHW	SCHW261016P00105000	put	105.0000	2026-10-16	2.5900	2.5500	2.7000	106.4750	54390.00	53613.00	777.00	210	10	282	4644	0.0607235142118863	0.27501925040457	0.27501925040457	false	false	false	true
80d0a226-65d7-465a-8097-fef458338a5f	2026-09-11 12:10	2026-09-11 12:10	2026-09-11 12:10	SCHW	SCHW261002P00108000	put	108.0000	2026-10-02	3.0000	2.8900	3.1000	106.5900	60000.00	1500.00	0.00	200	6	203	396	0.512626262626263	0.231198077933018	0.231198077933018	false	false	false	true
a0d91f2d-ac89-464d-b9e0-a04cf9dcfcca	2026-09-10 14:18	2026-09-10 14:18	2026-09-10 14:18	SCHW	SCHW260918C00108000	call	108.0000	2026-09-18	1.0800	0.9800	1.1200	106.8700	54648.00	648.00	54000.00	506	14	581	1213	0.478977741137675	0.243532065747512	0.243532065747512	true	false	false	true
e1d96f99-f953-4e13-914f-3e94396fd5a8	2026-09-09 10:07	2026-09-09 10:07	2026-09-09 10:07	SCHW	SCHW261120C00105000	call	105.0000	2026-11-20	6.8000	6.6500	6.8000	107.1600	65280.00	65280.00	0.00	96	24	96	390	0.246153846153846	0.276754477374162	0.276754477374162	false	false	false	true
1c390cb3-dbea-451d-8f98-30917b4cd5d6	2026-09-08 15:22	2026-09-08 15:22	2026-09-08 15:22	SCHW	SCHW261002P00108000	put	108.0000	2026-10-02	2.6400	2.5600	2.7600	107.7000	79200.00	5280.00	68112.00	300	12	336	17	19.7647058823529	0.238201985888387	0.238201985888387	false	false	false	true
e345ca8b-b29a-41ea-b297-25c4bcbfe04d	2026-09-08 10:42	2026-09-08 10:42	2026-09-08 10:42	SCHW	SCHW270917C00110000	call	110.0000	2027-09-17	13.1000	13.1000	14.1500	108.2250	53715.00	0.00	53715.00	41	17	41	72	0.569444444444444	0.277469975348798	0.27864051617797	false	false	false	true
c82732f4-c543-4029-816f-83227dfc0f65	2026-09-04 15:30	2026-09-04 15:30	2026-09-04 15:30	SCHW	SCHW261120P00105000	put	105.0000	2026-11-20	3.1000	2.9000	3.2000	109.5200	60760.00	2170.00	58590.00	196	22	235	1176	0.199829931972789	0.274347748531638	0.274347748531638	true	false	false	true
d89e740b-6ba7-4c01-8fb0-2b371d352d03	2026-09-03 10:21	2026-09-03 10:21	2026-09-03 10:21	SCHW	SCHW261016C00115000	call	115.0000	2026-10-16	1.9900	1.9700	1.9900	109.9800	53106.00	48555.00	4551.00	267	9	273	8195	0.0333129957291031	0.248245684325258	0.247517899207887	true	false	false	true
d00dff2e-cac0-4778-a797-c6ea3648af67	2026-09-03 10:21	2026-09-03 10:21	2026-09-03 10:21	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	4.0600	4.0500	4.1000	109.9800	51975.00	11070.00	40905.00	128	13	134	5263	0.0254607638229147	0.253209867551537	0.253209867551537	true	false	false	true
c6c9a8f0-8602-4ef1-a4d5-884823795b24	2026-09-03 10:17	2026-09-03 10:16	2026-09-03 10:16	SCHW	SCHW270115C00120000	call	120.0000	2027-01-15	3.5000	3.1000	3.6500	109.9500	463750.00	463050.00	700.00	1325	31	1329	7660	0.173498694516971	0.249886179331127	0.249326831600973	false	false	false	true
1a675186-7d20-4dbc-af3f-0ce04878dc78	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SCHW	SCHW261218C00115000	call	115.0000	2026-12-18	4.4000	4.3000	4.4000	110.1100	66000.00	66000.00	0.00	150	38	370	12242	0.0302238196373142	0.250102243437787	0.250102243437787	false	false	false	true
e629440c-b57e-481c-9a6e-c44e179e71ce	2026-09-01 11:21	2026-09-01 11:21	2026-09-01 11:21	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	8.4000	8.4000	8.5500	109.0700	190680.00	0.00	190680.00	227	47	228	1281	0.177985948477752	0.268061948878643	0.268061948878643	false	false	false	true
437a5a0b-7fad-43ca-94e4-1c9963e2fe21	2026-08-28 11:39	2026-08-28 11:39	2026-08-28 11:39	SCHW	SCHW260918C00111000	call	111.0000	2026-09-18	2.1700	2.1000	2.1700	110.0000	160122.00	154938.00	5184.00	738	28	952	161	5.91304347826087	0.225914580907043	0.225914580907043	false	false	false	true
28ea4e71-ed2a-4458-8e71-d36bfdf61fe3	2026-08-28 11:28	2026-08-28 11:28	2026-08-28 11:28	SCHW	SCHW260828C00110000	call	110.0000	2026-08-28	0.6200	0.5600	0.7600	110.5750	59999.00	9407.00	50592.00	965	67	1057	3075	0.343739837398374	0.335371457957637	0.158167550600798	true	false	false	true
d7e362d1-0fce-4c4c-9998-954169cd1084	2026-08-27 11:43	2026-08-27 11:42	2026-08-27 11:42	SCHW	SCHW270617P00100000	put	100.0000	2027-06-17	6.3000	6.1500	6.3000	107.9900	58585.00	57960.00	625.00	93	25	254	2007	0.126557050323866	0.301130572808483	0.299634412711969	false	false	false	true
c203fb1b-d3c9-46f9-958c-f7e8feaabc14	2026-08-27 11:43	2026-08-27 11:42	2026-08-27 11:42	SCHW	SCHW270617P00100000	put	100.0000	2027-06-17	6.3000	6.1500	6.3500	107.9900	56065.00	55440.00	625.00	89	12	161	2007	0.0802192326856004	0.301130572808483	0.301130572808483	false	false	false	true
6660f7b0-e03b-44f2-bc07-2fe4cb709dc7	2026-08-27 10:46	2026-08-27 10:46	2026-08-27 10:46	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	12.9000	12.7500	12.9000	108.0300	113520.00	113520.00	0.00	88	10	88	280	0.314285714285714	0.271491895565636	0.271491895565636	true	false	false	true
0646f86b-d0b5-4871-b7ae-a370d094fc17	2026-08-26 11:42	2026-08-26 11:42	2026-08-26 11:42	SCHW	SCHW260911P00104000	put	104.0000	2026-09-11	0.4300	0.4300	0.4300	108.9700	67897.00	0.00	0.00	1579	5	1584	1594	0.993726474278545	0.231206231009148	0.231206231009148	false	false	false	true
f8276bfb-006e-4c60-ba6e-5c56d3c44686	2026-08-26 11:20	2026-08-26 11:20	2026-08-26 11:20	SCHW	SCHW261218P00110000	put	110.0000	2026-12-18	6.4500	6.4000	6.5500	108.5895	103200.00	645.00	102555.00	160	23	206	326	0.631901840490798	0.264855131548426	0.264855131548426	false	false	false	true
4d7fd53f-1bd2-40ef-aeeb-98a2edee210f	2026-08-25 12:49	2026-08-25 12:48	2026-08-25 12:48	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	9.5500	9.5500	9.8000	112.5350	52539.00	0.00	52539.00	55	9	738	189	3.9047619047619	0.258789374343114	0.25863166640312	false	false	false	true
a0d41a68-d99e-46c8-8b8a-660426c3d939	2026-08-25 12:48	2026-08-25 12:48	2026-08-25 12:48	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	9.5500	9.5500	9.9000	112.5500	52525.00	0.00	52525.00	55	11	683	189	3.61375661375661	0.258473853192265	0.259104475394989	false	false	false	true
48cbb3b3-adb4-416f-be9b-8ec38fa2ac28	2026-08-25 12:47	2026-08-25 12:46	2026-08-25 12:46	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	9.4500	9.4500	10.2000	112.5350	51975.00	0.00	51975.00	55	5	463	189	2.44973544973545	0.253732820188422	0.253732820188422	false	false	false	true
d4b5bfc4-c56b-4b0b-abb6-6d9bf179ecd0	2026-08-25 11:33	2026-08-25 11:33	2026-08-25 11:33	SCHW	SCHW280121P00110000	put	110.0000	2028-01-21	11.9000	11.9000	12.0500	112.5600	66640.00	0.00	66640.00	56	10	143	420	0.34047619047619	0.314098892475313	0.314098892475313	false	false	false	true
29bccaf9-e4b5-42ee-8f04-91d9e9f6c6d5	2026-08-24 13:36	2026-08-24 13:36	2026-08-24 13:36	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	9.2000	9.2000	9.6500	113.1255	50600.00	0.00	50600.00	55	7	165	270	0.611111111111111	0.258914767097357	0.258914767097357	false	false	false	true
8378470f-689e-47b8-9630-56a0d7a7aba3	2026-08-24 13:35	2026-08-24 13:35	2026-08-24 13:35	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	9.1300	9.1000	9.7000	113.0400	50220.00	0.00	19110.00	55	7	55	270	0.203703703703704	0.251556922515484	0.251556922515484	false	false	false	true
dba92f40-99a9-48e5-8446-c4a74d296378	2026-08-24 10:10	2026-08-24 10:10	2026-08-24 10:10	SCHW	SCHW261218C00120000	call	120.0000	2026-12-18	4.6500	4.4500	4.7000	114.3050	66025.00	65100.00	925.00	142	25	142	1876	0.0756929637526653	0.250156392122036	0.250156392122036	false	false	false	true
44d9dcf9-692b-4616-9028-23a09ce78262	2026-08-21 11:54	2026-08-21 11:54	2026-08-21 11:54	SCHW	SCHW281215C00110000	call	110.0000	2028-12-15	24.5800	22.8000	25.1500	111.6800	76210.00	66370.00	0.00	31	7	31	149	0.208053691275168	0.292368222199713	0.281643907324453	true	false	false	true
9e320dc6-f200-4c5e-b52b-41b40616537c	2026-08-21 09:43	2026-08-21 09:43	2026-08-21 09:43	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	7.3500	7.0500	7.3500	111.3150	56593.00	56593.00	0.00	77	6	249	1106	0.225135623869801	0.266485168706325	0.266485168706325	false	false	false	true
2afbd023-1d06-469a-b51f-d2bb55a3684c	2026-08-20 12:36	2026-08-20 12:36	2026-08-20 12:36	SCHW	SCHW261016P00110000	put	110.0000	2026-10-16	3.3500	3.1000	3.4500	111.0000	59973.00	335.00	59638.00	179	38	201	1070	0.18785046728972	0.237505504228963	0.237505504228963	false	false	false	true
6346b80d-f516-4f58-9a16-7b1080a4d704	2026-08-20 10:29	2026-08-20 10:29	2026-08-20 10:29	SCHW	SCHW270617P00100000	put	100.0000	2027-06-17	5.5000	5.4000	5.5000	111.0900	72050.00	72050.00	0.00	131	14	312	1770	0.176271186440678	0.300080957309835	0.300041230190077	false	false	false	true