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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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×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

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	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-18T16:18:52.426930Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
48cbb3b3-adb4-416f-be9b-8ec38fa2ac28	2026-08-25 12:47	2026-08-25 12:46	2026-08-25 12:46	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	9.4500	9.4500	10.2000	112.5350	51975.00	0.00	51975.00	55	5	463	189	2.44973544973545	0.253732820188422	0.253732820188422	false	false	false	true
a0d41a68-d99e-46c8-8b8a-660426c3d939	2026-08-25 12:48	2026-08-25 12:48	2026-08-25 12:48	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	9.5500	9.5500	9.9000	112.5500	52525.00	0.00	52525.00	55	11	683	189	3.61375661375661	0.258473853192265	0.259104475394989	false	false	false	true
4d7fd53f-1bd2-40ef-aeeb-98a2edee210f	2026-08-25 12:49	2026-08-25 12:48	2026-08-25 12:48	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	9.5500	9.5500	9.8000	112.5350	52539.00	0.00	52539.00	55	9	738	189	3.9047619047619	0.258789374343114	0.25863166640312	false	false	false	true
f8276bfb-006e-4c60-ba6e-5c56d3c44686	2026-08-26 11:20	2026-08-26 11:20	2026-08-26 11:20	SCHW	SCHW261218P00110000	put	110.0000	2026-12-18	6.4500	6.4000	6.5500	108.5895	103200.00	645.00	102555.00	160	23	206	326	0.631901840490798	0.264855131548426	0.264855131548426	false	false	false	true
0646f86b-d0b5-4871-b7ae-a370d094fc17	2026-08-26 11:42	2026-08-26 11:42	2026-08-26 11:42	SCHW	SCHW260911P00104000	put	104.0000	2026-09-11	0.4300	0.4300	0.4300	108.9700	67897.00	0.00	0.00	1579	5	1584	1594	0.993726474278545	0.231206231009148	0.231206231009148	false	false	false	true
6660f7b0-e03b-44f2-bc07-2fe4cb709dc7	2026-08-27 10:46	2026-08-27 10:46	2026-08-27 10:46	SCHW	SCHW261120P00120000	put	120.0000	2026-11-20	12.9000	12.7500	12.9000	108.0300	113520.00	113520.00	0.00	88	10	88	280	0.314285714285714	0.271491895565636	0.271491895565636	true	false	false	true
d7e362d1-0fce-4c4c-9998-954169cd1084	2026-08-27 11:43	2026-08-27 11:42	2026-08-27 11:42	SCHW	SCHW270617P00100000	put	100.0000	2027-06-17	6.3000	6.1500	6.3000	107.9900	58585.00	57960.00	625.00	93	25	254	2007	0.126557050323866	0.301130572808483	0.299634412711969	false	false	false	true
c203fb1b-d3c9-46f9-958c-f7e8feaabc14	2026-08-27 11:43	2026-08-27 11:42	2026-08-27 11:42	SCHW	SCHW270617P00100000	put	100.0000	2027-06-17	6.3000	6.1500	6.3500	107.9900	56065.00	55440.00	625.00	89	12	161	2007	0.0802192326856004	0.301130572808483	0.301130572808483	false	false	false	true
437a5a0b-7fad-43ca-94e4-1c9963e2fe21	2026-08-28 11:39	2026-08-28 11:39	2026-08-28 11:39	SCHW	SCHW260918C00111000	call	111.0000	2026-09-18	2.1700	2.1000	2.1700	110.0000	160122.00	154938.00	5184.00	738	28	952	161	5.91304347826087	0.225914580907043	0.225914580907043	false	false	false	true
e629440c-b57e-481c-9a6e-c44e179e71ce	2026-09-01 11:21	2026-09-01 11:21	2026-09-01 11:21	SCHW	SCHW261120P00115000	put	115.0000	2026-11-20	8.4000	8.4000	8.5500	109.0700	190680.00	0.00	190680.00	227	47	228	1281	0.177985948477752	0.268061948878643	0.268061948878643	false	false	false	true
1a675186-7d20-4dbc-af3f-0ce04878dc78	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SCHW	SCHW261218C00115000	call	115.0000	2026-12-18	4.4000	4.3000	4.4000	110.1100	66000.00	66000.00	0.00	150	38	370	12242	0.0302238196373142	0.250102243437787	0.250102243437787	false	false	false	true
c6c9a8f0-8602-4ef1-a4d5-884823795b24	2026-09-03 10:17	2026-09-03 10:16	2026-09-03 10:16	SCHW	SCHW270115C00120000	call	120.0000	2027-01-15	3.5000	3.1000	3.6500	109.9500	463750.00	463050.00	700.00	1325	31	1329	7660	0.173498694516971	0.249886179331127	0.249326831600973	false	false	false	true
d89e740b-6ba7-4c01-8fb0-2b371d352d03	2026-09-03 10:21	2026-09-03 10:21	2026-09-03 10:21	SCHW	SCHW261016C00115000	call	115.0000	2026-10-16	1.9900	1.9700	1.9900	109.9800	53106.00	48555.00	4551.00	267	9	273	8195	0.0333129957291031	0.248245684325258	0.247517899207887	true	false	false	true
c82732f4-c543-4029-816f-83227dfc0f65	2026-09-04 15:30	2026-09-04 15:30	2026-09-04 15:30	SCHW	SCHW261120P00105000	put	105.0000	2026-11-20	3.1000	2.9000	3.2000	109.5200	60760.00	2170.00	58590.00	196	22	235	1176	0.199829931972789	0.274347748531638	0.274347748531638	true	false	false	true
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
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
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
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
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
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
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
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
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