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:ticker = SCHW×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	pricenumeric

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	185575015469.00	2026-10-15	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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