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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = 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

87ef9141-d2e8-4690-bc47-32c5d2d89908	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SCHW	SCHW261016C00105000	call	105.0000	2026-10-16	0.9700	0.8400	1.0900	98.0000	13678.00	2037.00	11641.00	141	5	517	5765	0.0896790980052038	0.313604848956709	0.313604848956709	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	171256115757.00	2026-10-15	premarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
98028ec5-7a9d-4937-84b3-9818468a065b	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	SCHW	SCHW261218C00125000	call	125.0000	2026-12-18	0.2200	0.2000	0.2700	99.3500	11770.00	0.00	7304.00	535	11	3412	18287	0.186580631049379	0.260833425278294	0.260833425278294	true	false	false	true
427084ec-ab34-4389-aebf-801f8e3b6966	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	SCHW	SCHW261218C00125000	call	125.0000	2026-12-18	0.2200	0.1800	0.2900	99.3600	13618.00	5940.00	2002.00	619	6	2877	18287	0.157324875594685	0.260733796860525	0.260733796860525	false	false	false	true
6c13d7f8-3b8b-49a5-8e89-ef5c4cb0251f	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	SCHW	SCHW261218C00125000	call	125.0000	2026-12-18	0.2400	0.2400	0.2700	99.4300	17472.00	0.00	17472.00	728	20	2164	18287	0.11833542954011	0.264339963622785	0.264339963622785	false	false	false	true
14698dd5-a484-4260-8770-7a810c65a21b	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	SCHW	SCHW261218C00125000	call	125.0000	2026-12-18	0.2400	0.2300	0.2400	99.4599	14136.00	2256.00	0.00	589	6	589	18287	0.0322086728276918	0.264038556460663	0.264038556460663	false	false	false	true
e7d7d423-b291-46ef-a5bd-591da06ced66	2026-09-25 15:25	2026-09-25 15:25	2026-09-25 15:25	SCHW	SCHW261016P00102000	put	102.0000	2026-10-16	4.3900	4.0000	4.4000	99.3800	25490.00	25490.00	0.00	58	12	66	72	0.916666666666667	0.318135524642633	0.318135524642633	false	false	false	true
8511a077-4393-4b1a-a5b2-b59013531e77	2026-09-25 15:20	2026-09-25 15:19	2026-09-25 15:19	SCHW	SCHW261218C00120000	call	120.0000	2026-12-18	0.5000	0.4900	0.5300	99.7400	39300.00	1600.00	35450.00	786	35	1806	4361	0.414125200642055	0.2609691284952	0.2609691284952	false	false	false	true
056c1472-6269-4da5-b6b6-8ea69320bdc1	2026-09-25 14:57	2026-09-25 14:57	2026-09-25 14:57	SCHW	SCHW261016P00100000	put	100.0000	2026-10-16	3.0000	2.9300	3.1000	99.0000	45000.00	44700.00	300.00	150	39	543	5527	0.0982449791930523	0.317115378694431	0.317115378694431	false	false	false	true
6aa64da1-02c3-4650-8918-b1c9515d98f2	2026-09-25 14:19	2026-09-25 14:18	2026-09-25 14:18	SCHW	SCHW261002C00102000	call	102.0000	2026-10-02	0.5700	0.5600	0.6300	99.8000	10146.00	1254.00	6384.00	178	15	237	236	1.00423728813559	0.247474576991934	0.247474576991934	false	false	false	true
51b6bd7d-ef20-411d-b6c9-4fff3f3a0a40	2026-09-25 11:25	2026-09-25 11:25	2026-09-25 11:25	SCHW	SCHW261106C00105000	call	105.0000	2026-11-06	1.7000	1.7000	1.9900	98.0000	15811.00	0.00	15811.00	93	8	442	0	0	0.279955125830373	0.280812068323716	false	false	false	true
e94bd3ef-fdd7-4119-ae6d-a63b8ce9e9a4	2026-09-25 11:16	2026-09-25 11:16	2026-09-25 11:16	SCHW	SCHW260925P00100000	put	100.0000	2026-09-25	1.1000	1.1000	1.1700	98.8882	15840.00	0.00	15840.00	144	30	312	1402	0.222539229671897	0.418623137638472	0.418623137638472	false	false	false	true
975ae75c-351b-4067-b1e4-6934d87bb9b4	2026-09-25 10:38	2026-09-25 10:38	2026-09-25 10:38	SCHW	SCHW261218P00100000	put	100.0000	2026-12-18	5.2000	5.1500	5.3000	99.4800	10400.00	0.00	9880.00	20	8	86	5010	0.0171656686626746	0.28568622257109	0.28568622257109	true	false	false	true
a345ff71-a6cd-4d96-90bc-6101e6e476e7	2026-09-24 14:48	2026-09-24 14:48	2026-09-24 14:48	SCHW	SCHW261218C00100000	call	100.0000	2026-12-18	5.5000	5.4000	5.5000	99.0000	112750.00	112750.00	0.00	205	39	326	2758	0.118201595358956	0.273802495715666	0.273802495715666	false	false	false	true
cc06a2d6-d601-4185-b035-e97ac87bd60c	2026-09-24 13:53	2026-09-24 13:53	2026-09-24 13:53	SCHW	SCHW270115P00097500	put	97.5000	2027-01-15	4.8000	4.7500	4.8000	99.0000	64320.00	64320.00	0.00	134	17	164	1635	0.100305810397554	0.28526882996263	0.28526882996263	false	false	false	true
b452ab14-d889-4124-9da2-c066eecd2592	2026-09-24 12:49	2026-09-24 12:49	2026-09-24 12:49	SCHW	SCHW270115C00105000	call	105.0000	2027-01-15	4.0500	3.9500	4.0500	99.1950	19845.00	19845.00	0.00	49	13	138	7723	0.0178687038715525	0.266912312471277	0.266912312471277	false	false	false	true
65c6fd4c-7597-4001-8e2b-52178b9db01a	2026-09-24 10:51	2026-09-24 10:51	2026-09-24 10:51	SCHW	SCHW261002P00098000	put	98.0000	2026-10-02	1.3200	1.2900	1.3300	98.5350	11352.00	11220.00	132.00	86	12	151	374	0.403743315508021	0.277773950615071	0.277773950615071	false	false	false	true
6e021e09-4cee-479a-b3bd-d0d800ccb917	2026-09-24 10:31	2026-09-24 10:31	2026-09-24 10:31	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	0.3500	0.3100	0.3600	98.4800	13370.00	2730.00	10640.00	382	6	5318	9649	0.551145196393409	0.328801745127246	0.328801745127246	false	false	false	true
9a27c985-4ede-4c42-b920-b010084210ef	2026-09-24 10:31	2026-09-24 10:31	2026-09-24 10:31	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	0.3500	0.3000	0.3600	98.5400	15435.00	10885.00	4550.00	441	8	4732	9649	0.490413514353819	0.327400020165709	0.327400020165709	false	false	false	true
cf7b6857-9c0e-4b1b-9530-b26cde98467a	2026-09-24 10:31	2026-09-24 10:31	2026-09-24 10:31	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	0.3500	0.3000	0.3700	98.5350	20335.00	16170.00	4165.00	581	7	4290	9649	0.444605658617473	0.327516839960949	0.327516839960949	false	false	false	true
dc3761e8-25df-47a5-b53e-c0e457d899a4	2026-09-24 10:26	2026-09-24 10:25	2026-09-24 10:25	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	0.3500	0.3000	0.3900	98.4800	20965.00	7140.00	13125.00	599	14	2509	9649	0.260026945797492	0.328801745127246	0.328801745127246	false	false	false	true
2b866b5d-3f24-4418-9632-a89e1b76cfe9	2026-09-24 10:26	2026-09-24 10:25	2026-09-24 10:25	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	0.3500	0.3000	0.3800	98.4800	20580.00	9625.00	9905.00	588	5	3097	9649	0.320965903202404	0.328801745127246	0.328801745127246	false	false	false	true
971d427e-6e35-43ca-80cf-13cbd646c2ad	2026-09-24 10:25	2026-09-24 10:25	2026-09-24 10:25	SCHW	SCHW261016P00094000	put	94.0000	2026-10-16	1.3000	1.3000	1.3400	98.3800	10400.00	0.00	10400.00	80	21	158	112	1.41071428571429	0.326250790486032	0.326250790486032	false	false	false	true
bfcb08da-f064-4eb3-a4b5-b304d9f43a76	2026-09-24 10:25	2026-09-24 10:25	2026-09-24 10:25	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	0.3500	0.3000	0.3700	98.3800	11900.00	6335.00	5565.00	340	6	1344	9649	0.139289045496943	0.331137422502609	0.331137422502609	false	false	false	true
bc5e54b8-c1cb-4d53-9604-ea0e0ac672bd	2026-09-24 10:25	2026-09-24 10:25	2026-09-24 10:25	SCHW	SCHW261016C00110000	call	110.0000	2026-10-16	0.3500	0.3000	0.4200	98.4500	17430.00	15225.00	2205.00	498	18	607	9649	0.0629080733754793	0.329502516884342	0.329502516884342	false	false	false	true
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
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true