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

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	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-08-25T15:37:01.391907Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
67571a6f-c98a-40b3-9bdb-f65e196bf7e7	2026-08-20 09:59	2026-08-20 09:58	2026-08-20 09:58	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.1000	10.1000	10.2000	110.8050	142410.00	0.00	142410.00	141	6	3630	4686	0.774647887323944	0.252180599396727	0.252180599396727	false	false	false	true
1688dc81-21e4-4408-917f-5534904375dd	2026-08-20 09:58	2026-08-20 09:58	2026-08-20 09:58	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.1500	10.1000	10.2000	110.8100	311605.00	295365.00	0.00	307	19	3489	4686	0.744558258642766	0.253624914541043	0.253624914541043	false	false	false	true
7834132a-460a-4b64-b183-c91a91c525b6	2026-08-20 09:58	2026-08-20 09:58	2026-08-20 09:58	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.1500	10.1000	10.3000	110.7900	179655.00	170520.00	9135.00	177	22	2917	4686	0.622492530943235	0.253993786410506	0.253993786410506	false	false	false	true
c74d6a35-2a14-45b3-95de-94839f857607	2026-08-20 09:58	2026-08-20 09:58	2026-08-20 09:58	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.2000	10.1500	10.2000	110.9000	104040.00	104040.00	0.00	102	7	2267	4686	0.483781476739223	0.253498611405243	0.253498611405243	false	false	false	true
50da84c5-154e-4196-87f5-1d41da2005ce	2026-08-20 09:57	2026-08-20 09:57	2026-08-20 09:57	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.2000	10.1500	10.2000	110.8980	222360.00	222360.00	0.00	218	14	1646	4686	0.351259069568929	0.253535621736912	0.253535621736912	false	false	false	true
b950cadf-0d2e-4b83-a913-fde6c7b414d0	2026-08-20 09:57	2026-08-20 09:57	2026-08-20 09:57	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.2000	10.1500	10.2000	110.8980	102000.00	102000.00	0.00	100	8	1426	4686	0.304310712761417	0.253535621736912	0.253535621736912	false	false	false	true
1054f039-cc1b-4adc-b5c3-0f198a83a776	2026-08-20 09:57	2026-08-20 09:57	2026-08-20 09:57	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.2000	10.1500	10.3000	110.8700	478380.00	451860.00	26520.00	469	18	1326	4686	0.282970550576184	0.254053476600899	0.254053476600899	false	false	false	true
4915d7cd-7eaa-4120-ba1f-f2dfbedb9c69	2026-08-20 09:57	2026-08-20 09:56	2026-08-20 09:56	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.1500	10.1000	10.1500	110.8350	292320.00	54810.00	0.00	288	17	549	4686	0.117157490396927	0.253163440479862	0.253163440479862	false	false	false	true
c7979961-848d-44ee-bc20-b8a00516a63a	2026-08-20 09:56	2026-08-20 09:56	2026-08-20 09:56	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.3500	10.3000	10.3500	111.0400	189405.00	189405.00	0.00	183	14	247	4686	0.0527102005975245	0.255513942707504	0.255513942707504	false	false	false	true
66dcdb50-09be-4f1a-9ab1-ec7fca591c71	2026-08-20 09:56	2026-08-20 09:56	2026-08-20 09:56	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.3500	10.3500	10.5000	111.0950	63135.00	0.00	63135.00	61	16	62	4686	0.0132309005548442	0.254490856069019	0.254490856069019	false	false	false	true
53b9a7c5-e09a-408f-8629-e0b0304208db	2026-08-20 09:39	2026-08-20 09:39	2026-08-20 09:39	SCHW	SCHW260918P00110000	put	110.0000	2026-09-18	2.2200	2.2200	2.2500	110.9450	67710.00	0.00	67710.00	305	33	1110	4004	0.277222777222777	0.226671679833201	0.226671679833201	false	false	false	true
d338dba1-0b50-4a28-8acf-3bd84518bde6	2026-08-19 15:59	2026-08-19 15:59	2026-08-19 15:59	SCHW	SCHW280121P00095000	put	95.0000	2028-01-21	6.6500	6.6500	6.9000	110.7500	66500.00	0.00	66500.00	100	24	101	611	0.165302782324059	0.316262856990689	0.316262856990689	false	false	false	true
28f19d8f-dc31-4a98-bf38-9697f81dbf36	2026-08-19 12:00	2026-08-19 12:00	2026-08-19 12:00	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	7.2500	7.2500	7.4000	110.9200	55825.00	0.00	55825.00	77	15	1519	765	1.98562091503268	0.249974844132898	0.249974844132898	false	false	false	true
c5ec4d6f-4c53-465b-b7c3-762844f6bd24	2026-08-19 11:59	2026-08-19 11:59	2026-08-19 11:59	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	7.2000	7.2000	7.4000	110.9900	55444.00	0.00	55444.00	77	8	1365	765	1.7843137254902	0.249476099290109	0.249476099290109	false	false	false	true
9d381255-a582-4053-8240-b673ca6c6f6e	2026-08-19 11:59	2026-08-19 11:59	2026-08-19 11:59	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	7.2500	7.2000	7.4000	111.0100	55825.00	0.00	55825.00	77	6	1211	765	1.58300653594771	0.251358740008666	0.252235754111963	false	false	false	true
c9e71886-4a61-402b-80aa-96ca520a67b4	2026-08-19 11:59	2026-08-19 11:58	2026-08-19 11:58	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	7.2500	7.2500	7.4000	110.9500	55825.00	0.00	55825.00	77	11	1134	765	1.48235294117647	0.250730570510161	0.250730570510161	false	false	false	true
eba86244-2610-4032-8027-3d48ce998328	2026-08-19 11:58	2026-08-19 11:58	2026-08-19 11:58	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	7.2500	7.2500	7.4000	110.9500	55827.00	0.00	55827.00	77	18	1057	765	1.38169934640523	0.250730570510161	0.250730570510161	false	false	false	true
8419696e-ac93-4e34-b893-e1d61984de3d	2026-08-18 15:04	2026-08-18 15:04	2026-08-18 15:04	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	6.8500	6.6000	6.9500	111.7000	481555.00	95900.00	385655.00	703	32	1920	17	112.941176470588	0.250201069156054	0.250201069156054	false	false	false	true
f7cc268f-8622-4e53-98a2-f380a86a7de0	2026-08-18 15:02	2026-08-18 15:02	2026-08-18 15:02	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	6.9000	6.9000	7.1000	111.5600	53130.00	0.00	53130.00	77	9	832	17	48.9411764705882	0.249083446560319	0.249083446560319	false	false	false	true
06b84f42-0096-4ec9-aec9-85d6c4d2ef87	2026-08-18 11:53	2026-08-18 11:53	2026-08-18 11:53	SCHW	SCHW261016P00115000	put	115.0000	2026-10-16	5.5000	5.5000	5.6000	111.9750	124860.00	0.00	124860.00	227	31	327	183	1.78688524590164	0.233815947841659	0.233815947841659	false	false	false	true