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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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 = CRM×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

49424de4-f5b9-4371-87a8-9a6ae7aac8bf	2026-08-31 15:51	2026-08-31 15:51	2026-08-31 15:51	CRM	CRM270617P00250000	put	250.0000	2027-06-17	31.7000	31.1000	31.7000	259.2600	177520.00	177520.00	0.00	56	7	131	474	0.276371308016878	0.449637813978621	0.449637813978621	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	213510890000.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0f65462c-cc81-4212-aff4-c4c303da22ed	2026-08-31 15:46	2026-08-31 15:46	2026-08-31 15:46	CRM	CRM270617P00250000	put	250.0000	2027-06-17	31.6500	30.5000	31.6500	259.2700	189900.00	189900.00	0.00	60	7	75	474	0.158227848101266	0.449097535527626	0.449097535527626	false	false	false	true
09167686-3231-4fd4-bad5-8c2c66934190	2026-08-31 15:07	2026-08-31 15:06	2026-08-31 15:06	CRM	CRM270115C00280000	call	280.0000	2027-01-15	20.2500	20.2000	21.0000	260.6500	68865.00	18225.00	50640.00	34	5	85	2351	0.0361548277328796	0.415486255344904	0.415486255344904	false	false	false	true
1c7d84a0-0c76-4875-9bbe-898d3e21d19f	2026-08-31 15:03	2026-08-31 15:03	2026-08-31 15:03	CRM	CRM261218C00280000	call	280.0000	2026-12-18	17.3500	17.3500	17.7500	261.1400	112775.00	0.00	112775.00	65	11	130	1236	0.105177993527508	0.416380564465362	0.416380564465362	false	false	false	true
5c647af5-390e-4a49-856f-84c82545f980	2026-08-31 13:45	2026-08-31 13:45	2026-08-31 13:45	CRM	CRM261016C00260000	call	260.0000	2026-10-16	14.4500	14.4500	14.8000	260.0000	57800.00	0.00	57800.00	40	16	532	1401	0.379728765167737	0.366791484529812	0.366791484529812	true	false	false	true
d93e6d3a-eba2-4e1d-90c0-91176645e1e3	2026-08-31 13:00	2026-08-31 13:00	2026-08-31 13:00	CRM	CRM260918C00250000	call	250.0000	2026-09-18	15.8000	15.7000	16.5000	261.5500	63200.00	0.00	61620.00	40	12	107	7614	0.0140530601523509	0.374081138171004	0.374081138171004	true	false	false	true
b3f35ded-3199-44ce-b742-f1be37533f6f	2026-08-31 12:22	2026-08-31 12:22	2026-08-31 12:22	CRM	CRM270917C00230000	call	230.0000	2027-09-17	66.7200	66.2500	66.8000	261.1900	266890.00	200290.00	66600.00	40	5	138	77	1.79220779220779	0.441987221917353	0.441987221917353	true	false	false	true
0bd9e10f-eb6b-4c9d-a1a1-4d921140e603	2026-08-31 12:14	2026-08-31 12:14	2026-08-31 12:14	CRM	CRM261120C00270000	call	270.0000	2026-11-20	16.4500	16.3500	16.8000	261.3550	80605.00	0.00	80605.00	49	7	323	1825	0.176986301369863	0.391752707502077	0.391752707502077	true	false	false	true
c2aa1bb4-373d-4f4e-8fb6-77f05d1c81dd	2026-08-31 12:13	2026-08-31 12:13	2026-08-31 12:13	CRM	CRM260904P00260000	put	260.0000	2026-09-04	4.0000	4.0000	4.1500	261.8500	114000.00	0.00	114000.00	285	6	1003	826	1.21428571428571	0.445036696221771	0.451425651901771	false	false	false	true
73195c79-9cd6-42e3-98c3-d3985b2b6527	2026-08-31 12:08	2026-08-31 12:08	2026-08-31 12:08	CRM	CRM280121C00250000	call	250.0000	2028-01-21	65.9000	64.8500	65.9000	261.6900	85670.00	85670.00	0.00	13	5	41	2572	0.0159409020217729	0.447244982625621	0.447244982625621	false	false	false	true
cc97eb8d-ab8e-42cd-a71a-846e71b95e97	2026-08-31 11:25	2026-08-31 11:25	2026-08-31 11:25	CRM	CRM270219P00260000	put	260.0000	2027-02-19	27.8500	27.1500	27.8500	260.1302	172670.00	172670.00	0.00	62	7	72	37	1.94594594594595	0.4308816865575	0.4308816865575	false	false	false	true
a08aee0a-021c-45ba-99bb-985b9e76d07b	2026-08-31 11:20	2026-08-31 11:19	2026-08-31 11:19	CRM	CRM270115C00240000	call	240.0000	2027-01-15	39.0000	38.3500	39.0000	260.2400	97500.00	97500.00	0.00	25	18	109	3252	0.0335178351783518	0.418613979120588	0.418613979120588	false	false	false	true
2b01978f-32d3-492a-8342-0f74eb41930b	2026-08-31 11:20	2026-08-31 11:19	2026-08-31 11:19	CRM	CRM270115C00240000	call	240.0000	2027-01-15	39.1000	38.3500	39.1000	260.2600	78200.00	78200.00	0.00	20	15	129	3252	0.0396678966789668	0.421445566243166	0.420150649875551	false	false	false	true
bc42859f-ab2d-4c00-9509-65db8c13e6cd	2026-08-31 11:12	2026-08-31 11:12	2026-08-31 11:12	CRM	CRM270115C00240000	call	240.0000	2027-01-15	39.0000	37.9000	39.0000	260.4000	97500.00	97500.00	0.00	25	18	68	3252	0.020910209102091	0.416262735943961	0.416634545368823	false	false	false	true
2ce31772-ab72-4bb5-9247-f9c315e0bc80	2026-08-31 11:11	2026-08-31 11:10	2026-08-31 11:10	CRM	CRM270115C00240000	call	240.0000	2027-01-15	38.7500	37.8000	39.5500	259.6750	50375.00	50375.00	0.00	13	13	43	3252	0.0132226322263223	0.421612292803185	0.421112387135469	false	false	false	true
81d94dc6-1f86-4103-83ed-1b52d548ceff	2026-08-31 11:10	2026-08-31 11:09	2026-08-31 11:09	CRM	CRM270115C00240000	call	240.0000	2027-01-15	38.7500	37.7500	38.7500	259.6400	50375.00	50375.00	0.00	13	7	28	3252	0.00861008610086101	0.421541250154107	0.421541250154107	false	false	false	true
5b2327c4-7eca-4f4a-95e2-66419e3024f4	2026-08-31 11:00	2026-08-31 11:00	2026-08-31 11:00	CRM	CRM260904C00255000	call	255.0000	2026-09-04	7.5500	7.2500	7.5500	259.3050	60400.00	60400.00	0.00	80	7	647	755	0.856953642384106	0.469407882713829	0.469407882713829	false	false	false	true
02a59da5-291c-425f-814c-df12f0203668	2026-08-31 10:56	2026-08-31 10:56	2026-08-31 10:56	CRM	CRM270115P00220000	put	220.0000	2027-01-15	9.3600	9.3500	9.6500	259.1950	187195.00	36660.00	150535.00	200	7	278	3871	0.0718160681994317	0.433551623369341	0.433551623369341	false	false	false	true
28700ece-294a-4ace-b34b-ce71375a6722	2026-08-31 10:40	2026-08-31 10:40	2026-08-31 10:40	CRM	CRM260911P00260000	put	260.0000	2026-09-11	7.5000	7.0000	7.5000	259.1700	314249.00	314249.00	0.00	419	54	540	700	0.771428571428571	0.402601602669018	0.402601602669018	false	false	false	true
2490b286-e0a2-4838-90ab-da32ab205c7f	2026-08-31 10:38	2026-08-31 10:38	2026-08-31 10:38	CRM	CRM260918P00275000	put	275.0000	2026-09-18	19.0000	18.2500	19.9500	259.5200	98800.00	45600.00	53200.00	52	9	77	0	0	0.409065381041151	0.412364166032651	false	false	false	true
67ca1461-2e8d-43c3-ac30-5241133633a3	2026-08-31 09:57	2026-08-31 09:57	2026-08-31 09:57	CRM	CRM261120P00260000	put	260.0000	2026-11-20	19.8000	19.8000	20.1500	257.9350	71280.00	0.00	71280.00	36	6	1983	463	4.2829373650108	0.410905190780176	0.411048285519898	false	false	false	true
cd4b4e68-0872-4264-88ed-77ace52133bc	2026-08-31 09:38	2026-08-31 09:37	2026-08-31 09:37	CRM	CRM270617C00250000	call	250.0000	2027-06-17	48.0000	46.0500	48.9500	258.1700	254376.00	254376.00	0.00	53	6	53	801	0.066167290886392	0.445366254102326	0.445133604061068	false	false	false	true
8832c365-f357-44f7-8f24-453812c36fa7	2026-08-28 15:59	2026-08-28 15:59	2026-08-28 15:59	CRM	CRM260828C00225000	call	225.0000	2026-08-28	31.1000	31.1000	31.7500	256.0400	164832.00	0.00	164832.00	53	19	726	1542	0.470817120622568	117.812048058208	83.5906083198297	true	false	false	true
863116a2-f9f5-46ab-a48c-a84fec75d5a5	2026-08-28 15:59	2026-08-28 15:59	2026-08-28 15:59	CRM	CRM260828C00230000	call	230.0000	2026-08-28	26.6500	25.1500	26.6500	256.3300	87945.00	87945.00	0.00	33	5	416	1951	0.213223987698616	116.581951183403	98.0392587909708	false	false	false	true
46918bfd-dce5-48c4-ac62-af2918b4c6e9	2026-08-28 15:59	2026-08-28 15:59	2026-08-28 15:59	CRM	CRM260828C00220000	call	220.0000	2026-08-28	36.1000	36.1000	37.5000	256.0400	148010.00	0.00	148010.00	41	14	323	3851	0.0838743183588678	167.861841108679	96.212261936415	true	false	false	true
a5954564-8fdc-4bae-8727-37400588c1a4	2026-08-28 15:56	2026-08-28 15:56	2026-08-28 15:56	CRM	CRM260828C00230000	call	230.0000	2026-08-28	26.7000	26.7000	27.3000	256.7000	82772.00	0.00	82772.00	31	14	377	1951	0.193234238851871	28.3796197400505	28.3796197400505	true	false	false	true
9a561f3e-39c3-4b35-9c37-83c04f54f2b7	2026-08-28 15:34	2026-08-28 15:34	2026-08-28 15:34	CRM	CRM261218P00250000	put	250.0000	2026-12-18	19.3500	19.0000	19.5000	257.3700	58050.00	58050.00	0.00	30	6	313	1025	0.305365853658537	0.433256050770724	0.433256050770724	false	false	false	true
62c01e57-65ae-461b-b347-1d13938ac22e	2026-08-28 15:10	2026-08-28 15:10	2026-08-28 15:10	CRM	CRM260918C00275000	call	275.0000	2026-09-18	4.1000	3.9500	4.1000	259.4840	132430.00	132430.00	0.00	323	10	1528	0	0	0.384148202535033	0.384148202535033	false	false	false	true
3fbbff7e-c8f0-4341-bed3-e0f7d4b58b4b	2026-08-28 14:51	2026-08-28 14:51	2026-08-28 14:51	CRM	CRM260904C00260000	call	260.0000	2026-09-04	5.1500	5.0000	5.4000	258.5211	64890.00	47380.00	17510.00	126	10	5325	4914	1.08363858363858	0.405895673391534	0.403194793734398	false	false	false	true
9b5d49cb-7a84-4adf-813c-420dfb9608a7	2026-08-28 14:18	2026-08-28 14:18	2026-08-28 14:18	CRM	CRM260911P00250000	put	250.0000	2026-09-11	3.4400	3.3000	3.4500	260.1501	143995.00	129375.00	14620.00	418	46	1131	404	2.79950495049505	0.380494732439026	0.380494732439026	false	false	false	true
f0fd85a2-ad13-448b-a59e-95640c410ec5	2026-08-28 13:38	2026-08-28 13:37	2026-08-28 13:37	CRM	CRM260828C00257500	call	257.5000	2026-08-28	2.4000	2.4000	2.6800	259.7050	60000.00	0.00	60000.00	250	5	5315	0	0	0.527489928596555	0.527489928596555	true	false	false	true
ece2b983-6ae4-4869-b82f-52aeca9f47fd	2026-08-28 13:19	2026-08-28 13:19	2026-08-28 13:19	CRM	CRM260911P00257500	put	257.5000	2026-09-11	6.7000	6.4500	6.7500	259.3600	118590.00	117920.00	670.00	177	27	300	0	0	0.386564416300997	0.385030936086031	false	false	false	true
8cb0bb25-5010-46f5-a03c-397f7880dc46	2026-08-28 12:44	2026-08-28 12:44	2026-08-28 12:44	CRM	CRM270319C00270000	call	270.0000	2027-03-19	31.6300	31.6000	33.1000	259.1700	91725.00	3170.00	50635.00	29	6	67	367	0.182561307901907	0.438976409316875	0.438324233384681	true	false	false	true
00832c11-f1bc-459a-9911-b1016d5ed317	2026-08-28 12:21	2026-08-28 12:21	2026-08-28 12:21	CRM	CRM261016P00260000	put	260.0000	2026-10-16	14.2500	14.2500	14.8000	259.9300	128250.00	0.00	128250.00	90	6	741	120	6.175	0.392229978193897	0.392229978193897	false	false	false	true
4eadc7b7-b079-465d-a68b-a632c5980397	2026-08-28 12:18	2026-08-28 12:18	2026-08-28 12:18	CRM	CRM260828P00262500	put	262.5000	2026-08-28	3.3000	3.3000	3.6500	259.3800	56798.00	0.00	56798.00	172	32	1778	0	0	0.520114009044938	0.520114009044938	false	false	false	true
29417663-500e-4a3d-a297-438cf07cf4a6	2026-08-28 11:49	2026-08-28 11:48	2026-08-28 11:48	CRM	CRM260918C00265000	call	265.0000	2026-09-18	8.1000	8.1000	8.5500	260.0000	72900.00	0.00	72900.00	90	6	1969	0	0	0.388870365096358	0.388870365096358	false	false	false	true
f9ed68bd-6274-41ca-9564-e5640a9ba9fb	2026-08-28 11:41	2026-08-28 11:41	2026-08-28 11:41	CRM	CRM260918C00265000	call	265.0000	2026-09-18	8.0000	8.0000	8.3500	260.0000	52800.00	0.00	52800.00	66	5	1852	0	0	0.384474319569461	0.384474319569461	false	false	false	true
b44a2a68-a3e2-439b-9891-55d9f35518e8	2026-08-28 11:26	2026-08-28 11:26	2026-08-28 11:26	CRM	CRM261016C00260000	call	260.0000	2026-10-16	16.2500	16.2500	16.7500	261.7700	81250.00	0.00	81250.00	50	9	582	988	0.589068825910931	0.383955287144884	0.385887192870178	false	false	false	true
f47c6ee7-cb6c-4105-88de-75021259ac55	2026-08-28 11:07	2026-08-28 11:07	2026-08-28 11:07	CRM	CRM261016C00260000	call	260.0000	2026-10-16	15.8500	15.8500	16.4000	261.3950	74495.00	0.00	74495.00	47	13	472	988	0.477732793522267	0.380854755238783	0.380854755238783	false	false	false	true
5c40723e-2521-46c0-91f6-f45c71b8bb5e	2026-08-28 10:56	2026-08-28 10:56	2026-08-28 10:56	CRM	CRM261016P00280000	put	280.0000	2026-10-16	25.7000	25.5500	26.0500	261.6550	61680.00	59110.00	2570.00	24	24	43	118	0.364406779661017	0.400628207973119	0.400628207973119	false	false	false	true
66036e97-8609-4fcc-b915-cf61b152eeac	2026-08-28 10:53	2026-08-28 10:53	2026-08-28 10:53	CRM	CRM261016P00250000	put	250.0000	2026-10-16	9.5000	9.2500	9.8000	260.4300	767594.00	755244.00	12350.00	808	70	1046	319	3.27899686520376	0.392759048588608	0.392759048588608	false	false	false	true
6f7b486a-c867-47ef-a2b8-68069052955e	2026-08-28 10:15	2026-08-28 10:14	2026-08-28 10:14	CRM	CRM270115C00280000	call	280.0000	2027-01-15	19.7500	19.7500	20.9500	258.2000	102705.00	0.00	102705.00	52	12	120	2350	0.051063829787234	0.420685554134358	0.420685554134358	false	false	false	true
daff93a9-a00e-455a-a7a2-f9b3e93275c8	2026-08-28 10:12	2026-08-28 10:12	2026-08-28 10:12	CRM	CRM260918C00265000	call	265.0000	2026-09-18	6.6500	6.6500	7.0000	258.0000	99109.00	0.00	99109.00	149	30	938	0	0	0.380984192628092	0.381814705001281	true	false	false	true
0cbd2d33-0676-40b8-97b5-cbcce6fc1bec	2026-08-28 10:11	2026-08-28 10:11	2026-08-28 10:11	CRM	CRM260904P00255000	put	255.0000	2026-09-04	4.7000	4.4000	4.8500	258.0400	57810.00	21620.00	36190.00	123	29	431	102	4.22549019607843	0.439142783212092	0.436223222299908	false	false	false	true
1996c4c4-c1b6-4880-a3a0-3a6e9cdf776c	2026-08-28 10:11	2026-08-28 10:11	2026-08-28 10:11	CRM	CRM260918C00300000	call	300.0000	2026-09-18	0.8300	0.8300	0.9800	258.3700	83000.00	0.00	83000.00	1000	6	1380	3161	0.436570705472952	0.412698123817469	0.412698123817469	false	false	false	true
ae23b13c-cdc4-44e9-b61b-bf33c8433b38	2026-08-28 10:09	2026-08-28 10:08	2026-08-28 10:08	CRM	CRM260911C00250000	call	250.0000	2026-09-11	13.0000	13.0000	14.0000	258.8550	634400.00	0.00	634400.00	488	8	1493	3192	0.467731829573935	0.378003444710316	0.378003444710316	false	false	false	true
c273d1f2-28ec-496d-b60d-b857aa611964	2026-08-28 09:57	2026-08-28 09:57	2026-08-28 09:57	CRM	CRM260918C00260000	call	260.0000	2026-09-18	10.7500	10.7500	11.2000	261.0006	101052.00	0.00	101052.00	94	14	1886	5836	0.323166552433173	0.399649477281147	0.399649477281147	true	false	false	true
fb3a6268-d8d2-4a8a-83aa-fb1018b1b6ac	2026-08-28 09:51	2026-08-28 09:51	2026-08-28 09:51	CRM	CRM260911C00250000	call	250.0000	2026-09-11	13.3500	13.3500	14.4000	259.3800	607425.00	0.00	607425.00	455	5	496	3192	0.155388471177945	0.376826658776411	0.376826658776411	false	false	false	true
518cc86c-1734-4cb4-b197-967b41cce5a2	2026-08-28 09:48	2026-08-28 09:48	2026-08-28 09:48	CRM	CRM260918C00260000	call	260.0000	2026-09-18	9.9500	9.9000	10.2500	259.9100	254720.00	174125.00	80595.00	256	8	1320	5836	0.226182316655243	0.390941701863317	0.390941701863317	true	false	false	true
365f7c88-3370-4643-a485-ca7425049d05	2026-08-28 09:47	2026-08-28 09:47	2026-08-28 09:47	CRM	CRM260828C00257500	call	257.5000	2026-08-28	3.4500	3.4500	3.5000	259.0751	181470.00	0.00	181470.00	526	15	3121	0	0	0.94168436910138	0.94168436910138	true	false	false	true