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×

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

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	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-20T14:05:52.049536Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
e5506375-19a1-40b5-a8cc-827c31be0dfd	2026-08-20 09:58	2026-08-20 09:58	2026-08-20 09:58	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.1100	10.1000	10.2000	110.8400	132420.00	22330.00	110090.00	131	9	2574	4686	0.549295774647887	0.251349503139803	0.253071094207616	false	false	false	true	false
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	false
6e45714e-ae1a-4d19-9024-9fd1eda5b788	2026-08-20 09:57	2026-08-20 09:57	2026-08-20 09:57	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.1300	10.1000	10.2500	110.8500	445505.00	85260.00	221190.00	440	27	2149	4686	0.458600085360649	0.251349503139803	0.252886350018003	false	false	false	true	false
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	false
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	false
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	false
75f8e20f-2ada-4090-bd27-bfb55922f77a	2026-08-20 09:57	2026-08-20 09:57	2026-08-20 09:57	SCHW	SCHW270319C00110000	call	110.0000	2027-03-19	10.1900	10.1000	10.2000	110.8400	187585.00	168300.00	10150.00	184	13	784	4686	0.167306871532224	0.253071094207616	0.25460772406154	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
8f5c3ad0-d69b-4feb-988c-3a3ab3a4cba8	2026-08-19 11:49	2026-08-19 11:49	2026-08-19 11:49	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	7.2100	7.0500	7.2500	111.3297	55514.00	55514.00	0.00	77	11	852	765	1.11372549019608	0.260121012255738	0.257877928002111	false	false	false	true	false
9f51a5bc-3d9d-4a89-91b8-1f9d4f4e1107	2026-08-19 11:49	2026-08-19 11:48	2026-08-19 11:48	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	7.1400	7.0500	7.1500	111.3800	54965.00	54965.00	0.00	77	10	753	765	0.984313725490196	0.256859407206269	0.256411055198243	false	false	false	true	false
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	false
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	false
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	false
52bdeb2a-e9b8-4e66-a870-145fb99b3236	2026-08-17 15:13	2026-08-17 15:08	2026-08-17 15:13	SCHW	SCHW260918P00110000	put	110.0000	2026-09-18	2.2200	0.0000	0.0000	110.8600	135954.00	0.00	135954.00	612	11	3240	1149	2.81984334203655	0	0	true	true	true	true	false