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×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	expiry

830eafa3-a3b2-473a-8a91-1d494cafd98b	2026-09-23 15:44	2026-09-23 15:44	2026-09-23 15:44	SCHW	SCHW261016P00097500	put	97.5000	2026-10-16	2.0300	1.9400	2.0300	99.0000	32276.00	32276.00	0.00	159	38	201	1599	0.125703564727955	0.316334254452212	0.316334254452212	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	172068903543.00	2026-10-15	premarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
a982d7e7-3a5c-4029-8b36-a16e4f829c1e	2026-09-23 13:37	2026-09-23 13:37	2026-09-23 13:37	SCHW	SCHW281215C00115000	call	115.0000	2028-12-15	14.9000	14.9000	15.5000	100.2700	77480.00	0.00	77480.00	52	16	52	54	0.962962962962963	0.273369957214747	0.273369957214747	false	false	false
c0d99487-24ad-4678-b8f2-31192867e99b	2026-09-23 12:32	2026-09-23 12:32	2026-09-23 12:32	SCHW	SCHW270115P00095000	put	95.0000	2027-01-15	3.3500	3.3000	3.4000	100.3800	10720.00	5360.00	5360.00	32	5	40	3096	0.0129198966408269	0.282396422002009	0.282396422002009	false	false	false
63cc13b9-ebdc-4cfe-9319-756207264967	2026-09-23 12:32	2026-09-23 12:32	2026-09-23 12:32	SCHW	SCHW270115P00095000	put	95.0000	2027-01-15	3.3500	3.3000	3.3750	100.3850	11055.00	11055.00	0.00	33	5	100	3096	0.0322997416020672	0.282551391257828	0.28247391395179	false	false	false
27ecd845-b212-4e40-82ac-2474f02d6df2	2026-09-23 12:21	2026-09-23 12:21	2026-09-23 12:21	SCHW	SCHW270115C00105000	call	105.0000	2027-01-15	4.4500	4.2000	4.5500	100.2900	182450.00	172660.00	9345.00	410	11	729	7253	0.100510133737764	0.262857356415684	0.262657996420683	false	false	false
b9551280-3e6c-427b-bdeb-df4ff6767d37	2026-09-23 11:06	2026-09-23 11:05	2026-09-23 11:05	SCHW	SCHW270115C00110000	call	110.0000	2027-01-15	2.9600	2.8800	3.0500	100.7200	29600.00	0.00	29600.00	100	5	117	3307	0.0353794980344723	0.26140019814792	0.26140019814792	false	false	false
ad92bf08-a64b-48e1-9baa-1947c4ad6a30	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	SCHW	SCHW270115C00105000	call	105.0000	2027-01-15	4.7500	4.6000	4.9000	101.0000	102120.00	63650.00	37520.00	215	21	223	7253	0.0307458982490004	0.26095255499277	0.26095255499277	false	false	false
db0842a6-6f1c-4e1f-8039-19956efc2ad0	2026-09-22 15:33	2026-09-22 15:33	2026-09-22 15:33	SCHW	SCHW261120P00095000	put	95.0000	2026-11-20	2.0200	1.9200	2.0200	101.0000	16968.00	16968.00	0.00	84	5	296	425	0.696470588235294	0.296975675037123	0.296975675037123	false	false	false
61ae126d-4834-444c-a2e9-359f2f87d788	2026-09-22 15:11	2026-09-22 15:11	2026-09-22 15:11	SCHW	SCHW261016P00100000	put	100.0000	2026-10-16	2.5700	2.4900	2.5700	101.0850	25700.00	25700.00	0.00	100	21	2163	7088	0.305163656884876	0.31137922285255	0.31137922285255	false	false	false
f2a87a72-e9bd-44f8-8709-59b575d2d234	2026-09-22 15:07	2026-09-22 15:07	2026-09-22 15:07	SCHW	SCHW260925C00102000	call	102.0000	2026-09-25	0.8100	0.8100	0.9600	100.9800	25515.00	0.00	25515.00	315	34	834	11	75.8181818181818	0.338292159823715	0.338292159823715	false	false	false
43498225-5740-4e69-ae2e-f90701702c1a	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	SCHW	SCHW261016C00101000	call	101.0000	2026-10-16	3.5500	3.0500	3.7000	101.3050	26625.00	19880.00	6745.00	75	14	108	0	0	0.315377219945083	0.315377219945083	false	false	false	true
98c04269-9ff5-4c81-a090-2453825f6b8a	2026-09-22 13:53	2026-09-22 13:53	2026-09-22 13:53	SCHW	SCHW261218C00100000	call	100.0000	2026-12-18	6.4500	6.3000	6.5000	101.2350	15480.00	10965.00	4515.00	24	8	609	2858	0.213086074177747	0.270109789669568	0.270109789669568	true	false	false
58a40466-83a6-4e03-b9e4-7bbc3ae3e2eb	2026-09-22 13:51	2026-09-22 13:51	2026-09-22 13:51	SCHW	SCHW261016P00104000	put	104.0000	2026-10-16	4.5500	4.4500	4.5500	101.2046	68250.00	68250.00	0.00	150	6	359	508	0.706692913385827	0.298368912589172	0.298368912589172	true	false	false
a36dbecf-b34b-4e47-8e19-944ee897a629	2026-09-22 13:41	2026-09-22 13:41	2026-09-22 13:41	SCHW	SCHW261218C00095000	call	95.0000	2026-12-18	9.2500	9.2500	9.4500	100.9500	46250.00	0.00	46250.00	50	5	1473	1700	0.866470588235294	0.26775139030001	0.26775139030001	false	false	false
82663f29-7e5a-4ead-8f68-3b71ac669b3c	2026-09-22 13:41	2026-09-22 13:41	2026-09-22 13:41	SCHW	SCHW261218C00095000	call	95.0000	2026-12-18	9.0500	9.0500	9.4500	100.8950	28056.00	0.00	28056.00	31	7	1323	1700	0.778235294117647	0.257938923327885	0.257938923327885	false	false	false
7bd81331-6d99-4e05-bb45-9e0c030b2e0e	2026-09-22 13:40	2026-09-22 13:40	2026-09-22 13:40	SCHW	SCHW261218C00095000	call	95.0000	2026-12-18	9.2000	9.2000	9.7500	100.9400	46000.00	0.00	46000.00	50	15	1273	1700	0.748823529411765	0.265137604527114	0.265137604527114	false	false	false
6f834e17-ce96-4efc-8bd4-d720866aa2fc	2026-09-22 13:40	2026-09-22 13:40	2026-09-22 13:40	SCHW	SCHW261218C00095000	call	95.0000	2026-12-18	9.2000	9.2000	9.7500	100.0000	46000.00	0.00	46000.00	50	7	1223	1700	0.719411764705882	0.264690565502646	0.264690565502646	false	false	false
83c5700e-66f0-4683-92ec-d7fbdb1feb7c	2026-09-22 13:40	2026-09-22 13:40	2026-09-22 13:40	SCHW	SCHW261218C00100000	call	100.0000	2026-12-18	6.3000	6.2000	6.4000	101.0000	27720.00	0.00	18270.00	44	8	291	2858	0.101819454163751	0.269509724014976	0.269509724014976	false	false	false
6f72b551-b66f-4030-ae96-b6991dd0f03a	2026-09-22 13:39	2026-09-22 13:39	2026-09-22 13:39	SCHW	SCHW261218C00095000	call	95.0000	2026-12-18	9.3000	9.3000	9.7500	101.0000	46516.00	0.00	46516.00	50	15	1123	1700	0.660588235294118	0.26679425608673	0.272578736566925	false	false	false
a0136218-a119-4229-8a8b-d7a643cc2b67	2026-09-22 12:28	2026-09-22 12:28	2026-09-22 12:28	SCHW	SCHW261218C00100000	call	100.0000	2026-12-18	6.3000	6.3000	6.3500	100.9500	10080.00	0.00	10080.00	16	10	147	2858	0.0514345696291113	0.271031851021199	0.271031851021199	false	false	false
9c206c64-da22-482e-8c95-98636be58e42	2026-09-22 12:14	2026-09-22 12:14	2026-09-22 12:14	SCHW	SCHW261023P00114000	put	114.0000	2026-10-23	13.4500	13.2000	14.4500	100.5800	24205.00	1335.00	22870.00	18	6	18	0	0	0.312314702999588	0.295315977819356	false	false	false	true
5713d0ea-30b9-491b-ad76-c75cbe41fb68	2026-09-22 12:11	2026-09-22 12:11	2026-09-22 12:11	SCHW	SCHW261016P00100000	put	100.0000	2026-10-16	2.8800	2.7700	3.1000	100.5950	17280.00	16128.00	1152.00	60	5	1975	7088	0.278639954853273	0.321148537269658	0.321148537269658	false	false	false
e349b169-39ca-480c-a950-6fadf24f0cda	2026-09-22 11:34	2026-09-22 11:34	2026-09-22 11:34	SCHW	SCHW261016P00100000	put	100.0000	2026-10-16	3.1500	3.1000	3.3000	99.9152	166320.00	77175.00	8820.00	528	6	890	7088	0.125564334085779	0.317047861683168	0.317047861683168	false	false	false
948caa1e-a2d0-46b1-b504-937daf217af9	2026-09-22 11:34	2026-09-22 11:33	2026-09-22 11:33	SCHW	SCHW261120C00110000	call	110.0000	2026-11-20	1.3600	1.3600	1.3800	99.0000	26112.00	0.00	26112.00	192	39	1632	1334	1.22338830584708	0.275253975063651	0.275253975063651	false	false	false
781cc92c-3861-4159-b16d-20248edd8b19	2026-09-22 11:34	2026-09-22 11:33	2026-09-22 11:33	SCHW	SCHW261120C00110000	call	110.0000	2026-11-20	1.3800	1.3200	1.3900	99.0000	18768.00	5106.00	8970.00	136	21	1924	1334	1.44227886056972	0.275413912331111	0.275413912331111	true	false	false
7a46bb80-e079-49a4-aec0-d3e0d161c356	2026-09-22 10:55	2026-09-22 10:54	2026-09-22 10:54	SCHW	SCHW261120P00100000	put	100.0000	2026-11-20	4.5000	4.4000	4.5500	99.9100	51345.00	44595.00	6750.00	114	22	305	1036	0.294401544401544	0.299309966565405	0.302448278635168	false	false	false
3f2e5697-ca81-4dd1-aa41-fd11aa3f10b1	2026-09-22 10:48	2026-09-22 10:47	2026-09-22 10:47	SCHW	SCHW280121P00090000	put	90.0000	2028-01-21	6.8000	6.8000	7.6000	100.6250	102000.00	0.00	102000.00	150	5	150	303	0.495049504950495	0.31589951302722	0.31589951302722	false	false	false
b88bc978-5ebb-4e52-bc67-49ce9142ac12	2026-09-22 10:46	2026-09-22 10:46	2026-09-22 10:46	SCHW	SCHW261016P00110000	put	110.0000	2026-10-16	9.9500	9.7500	9.9500	100.3200	10945.00	10945.00	0.00	11	11	459	1832	0.250545851528384	0.306160693721401	0.312263466036223	false	false	false
2719d200-cb07-497b-84f9-378a88ad9851	2026-09-22 10:46	2026-09-22 10:46	2026-09-22 10:46	SCHW	SCHW261016P00110000	put	110.0000	2026-10-16	9.9500	9.7500	9.9500	100.3050	10945.00	10945.00	0.00	11	11	436	1832	0.237991266375546	0.31075946423591	0.310002176107305	false	false	false
15e3e2b5-a723-46a4-b03c-f5c0f42e7d7f	2026-09-22 10:45	2026-09-22 10:45	2026-09-22 10:45	SCHW	SCHW261016P00110000	put	110.0000	2026-10-16	9.9000	9.7000	10.1000	100.4250	17820.00	13860.00	0.00	18	8	346	1832	0.188864628820961	0.31905329049576	0.31905329049576	false	false	false
b96b5fa9-014f-4b54-acb5-b3545b5a3709	2026-09-22 10:45	2026-09-22 10:45	2026-09-22 10:45	SCHW	SCHW261016P00110000	put	110.0000	2026-10-16	9.9000	9.7000	9.9000	100.4100	25740.00	25740.00	0.00	26	10	328	1832	0.179039301310044	0.32117483904771	0.316905251235408	false	false	false
24def7a8-5d05-40f9-ab19-bed443132dde	2026-09-22 10:45	2026-09-22 10:45	2026-09-22 10:45	SCHW	SCHW261016P00110000	put	110.0000	2026-10-16	9.9000	9.3000	9.9000	100.4200	203940.00	203940.00	0.00	206	9	302	1832	0.164847161572052	0.318340272958768	0.318340272958768	false	false	false
dfc08541-f2cf-44ec-8454-a74726ea42f8	2026-09-22 10:40	2026-09-22 10:40	2026-09-22 10:40	SCHW	SCHW261218C00095000	call	95.0000	2026-12-18	9.5500	9.2000	9.5500	100.6700	48705.00	48705.00	0.00	51	7	881	1700	0.518235294117647	0.297772605174742	0.297772605174742	false	false	false
7f156591-523b-426d-9b05-6cd1b70fd2b6	2026-09-22 10:40	2026-09-22 10:40	2026-09-22 10:40	SCHW	SCHW261218C00095000	call	95.0000	2026-12-18	9.7400	9.3000	9.7500	100.8000	49691.00	49691.00	0.00	51	6	728	1700	0.428235294117647	0.30415874179976	0.30415874179976	false	false	false
5ff34179-6b2e-45bd-a0f8-3a69dc01f351	2026-09-22 10:32	2026-09-22 10:32	2026-09-22 10:32	SCHW	SCHW261016C00105000	call	105.0000	2026-10-16	1.6800	1.6400	1.6900	100.4000	16632.00	10416.00	6216.00	99	17	327	5463	0.0598572213069742	0.326459151907716	0.325762243342478	false	false	false
9f130c4a-b980-428e-a96c-f8a212076732	2026-09-22 10:30	2026-09-22 10:30	2026-09-22 10:30	SCHW	SCHW261218C00100000	call	100.0000	2026-12-18	6.0000	5.8500	6.2500	100.3950	10800.00	8400.00	2400.00	18	9	18	2858	0.00629811056682995	0.272055767909597	0.272055767909597	false	false	false
d6eb7fc7-8a36-43b9-b9e6-1095023c63d5	2026-09-22 10:20	2026-09-22 10:20	2026-09-22 10:20	SCHW	SCHW261218C00105000	call	105.0000	2026-12-18	4.1000	3.9500	4.2000	101.0700	15170.00	14760.00	410.00	37	7	40	18215	0.0021959923140269	0.271842258752733	0.271842258752733	false	false	false
2c81220c-a2da-4b40-96e9-cd1ab91d5780	2026-09-22 10:08	2026-09-22 10:08	2026-09-22 10:08	SCHW	SCHW261120C00105000	call	105.0000	2026-11-20	3.7000	3.5500	3.9000	102.3000	45135.00	44030.00	1105.00	122	36	155	504	0.307539682539683	0.279846030808209	0.279846030808209	false	false	false
68575edd-d66d-4037-8f0f-549831a279f7	2026-09-22 09:50	2026-09-22 09:50	2026-09-22 09:50	SCHW	SCHW261016P00101000	put	101.0000	2026-10-16	2.1300	1.9300	2.1300	103.2100	13632.00	13632.00	0.00	64	15	71	12	5.91666666666667	0.309322054930365	0.308406241402547	false	false	false
242a240a-5bb7-42a0-bb2a-aff3d7a1931e	2026-09-22 09:50	2026-09-22 09:50	2026-09-22 09:50	SCHW	SCHW261016P00097500	put	97.5000	2026-10-16	1.1100	0.7600	1.1400	103.2100	62826.00	51171.00	11655.00	566	28	568	1149	0.494342906875544	0.318861906492659	0.318159662001833	false	false	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
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
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
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
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
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
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
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
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
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