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

a21e676f-3298-4b8b-b440-7d15a2806fe0	2026-08-27 10:38	2026-08-27 10:38	2026-08-27 10:38	CRM	CRM280121C00220000	call	220.0000	2028-01-21	71.0000	69.8500	71.0000	248.7900	284000.00	284000.00	0.00	40	5	209	2085	0.100239808153477	0.446976781414609	0.446976781414609	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-27T14:49:52.356548Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f4144d09-3734-4fd7-a017-4126f47434ac	2026-08-27 10:35	2026-08-27 10:35	2026-08-27 10:35	CRM	CRM260904P00242500	put	242.5000	2026-09-04	4.0500	4.0500	4.3500	248.0000	89111.00	0.00	89111.00	220	31	1245	0	0	0.449537668378689	0.449537668378689	true	false	false	true
afca6e16-b3ab-42e6-ab62-f0f9f3752abe	2026-08-27 10:32	2026-08-27 10:32	2026-08-27 10:32	CRM	CRM260918C00220000	call	220.0000	2026-09-18	29.0000	28.2000	29.0000	246.9000	89900.00	89900.00	0.00	31	6	941	8828	0.106592659719076	0.426657498288767	0.426657498288767	true	false	false	true
d1434fb1-83cb-4576-9e9a-ebd56876b6cd	2026-08-27 10:30	2026-08-27 10:30	2026-08-27 10:30	CRM	CRM260925C00250000	call	250.0000	2026-09-25	10.3000	10.3000	10.9500	247.4700	451164.00	0.00	451164.00	438	29	540	167	3.23353293413174	0.40001509137321	0.40001509137321	true	false	false	true
12abd938-4b52-4ffb-99bd-91adae85bfd2	2026-08-27 10:29	2026-08-27 10:29	2026-08-27 10:29	CRM	CRM260828C00250000	call	250.0000	2026-08-28	3.0500	3.0500	3.1000	247.7400	79300.00	0.00	79300.00	260	5	12922	2614	4.9433817903596	0.783234988880301	0.783234988880301	false	false	false	true
029fd755-d6d5-41c5-bf79-d0b12ee1ef2d	2026-08-27 10:27	2026-08-27 10:27	2026-08-27 10:27	CRM	CRM260904P00242500	put	242.5000	2026-09-04	4.2000	3.9500	4.2000	248.6350	69300.00	69300.00	0.00	165	5	1009	0	0	0.480885280346933	0.476830774899829	false	false	false	true
068d8672-b9c4-4fc9-a8ad-4c4841284623	2026-08-27 10:24	2026-08-27 10:24	2026-08-27 10:24	CRM	CRM260904P00242500	put	242.5000	2026-09-04	3.9000	3.9000	4.1500	249.3700	107640.00	0.00	107640.00	276	34	794	0	0	0.471732264859169	0.472886071563871	true	false	false	true
ff193edc-8225-4719-b5bb-939ab3e67e24	2026-08-27 10:23	2026-08-27 10:23	2026-08-27 10:23	CRM	CRM261218P00250000	put	250.0000	2026-12-18	23.3000	22.4500	23.4500	249.2900	93200.00	69900.00	23300.00	40	11	110	804	0.13681592039801	0.444472197615105	0.444472197615105	false	false	false	true
877c620d-05bf-4c66-9b1c-498bb4d53a50	2026-08-27 10:19	2026-08-27 10:19	2026-08-27 10:19	CRM	CRM260828C00247500	call	247.5000	2026-08-28	4.5000	4.5000	4.7000	248.0200	68850.00	0.00	68850.00	153	5	3400	401	8.4788029925187	0.816071302239747	0.816071302239747	false	false	false	true
dd66b2d2-3351-4e0f-9f82-11c6232ee8fc	2026-08-27 10:18	2026-08-27 10:18	2026-08-27 10:18	CRM	CRM271217C00260000	call	260.0000	2027-12-17	51.2000	50.5000	51.3500	247.9899	102400.00	56320.00	40960.00	20	5	449	278	1.61510791366906	0.451113412690288	0.451113412690288	true	false	false	true
64581f62-356f-4052-a641-ba350339e3dd	2026-08-27 10:17	2026-08-27 10:17	2026-08-27 10:17	CRM	CRM260918C00250000	call	250.0000	2026-09-18	9.3500	9.2500	9.7500	247.5500	101910.00	935.00	100975.00	109	20	7292	8758	0.832610184973738	0.419795308467431	0.419762654561502	true	false	false	true
2d4cb3d7-6e80-4bc4-928f-1fa59858a6aa	2026-08-27 10:16	2026-08-27 10:16	2026-08-27 10:16	CRM	CRM260918P00230000	put	230.0000	2026-09-18	3.4500	3.4000	3.6000	247.9500	82800.00	0.00	82800.00	240	6	649	454	1.4295154185022	0.433065256599033	0.433065256599033	false	false	false	true
4d12dd81-5263-4d15-964f-3aaa09bc1d4c	2026-08-27 10:16	2026-08-27 10:16	2026-08-27 10:16	CRM	CRM260918P00240000	put	240.0000	2026-09-18	6.7500	6.5500	6.7500	247.8700	58725.00	58725.00	0.00	87	7	1311	90	14.5666666666667	0.439810511093716	0.437003159352015	false	false	false	true
24284301-28c9-43b9-b31b-87bf6a384415	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	CRM	CRM271217C00330000	call	330.0000	2027-12-17	30.0500	27.6500	30.0500	247.9000	54090.00	54090.00	0.00	18	7	19	674	0.0281899109792285	0.449458723850197	0.449458723850197	false	false	false	true
4cd73b8c-fc48-421b-b194-b4b8bca543c4	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	CRM	CRM260918P00240000	put	240.0000	2026-09-18	7.0000	7.0000	7.0500	247.5400	107800.00	0.00	107800.00	154	24	1187	90	13.1888888888889	0.442840276369514	0.442840276369514	true	false	false	true
6852759d-1569-43bb-9dd8-5d1d812d9a60	2026-08-27 10:14	2026-08-27 10:14	2026-08-27 10:14	CRM	CRM270917C00390000	call	390.0000	2027-09-17	14.0500	12.1000	14.0500	247.6500	110995.00	110995.00	0.00	79	23	83	485	0.171134020618557	0.447316603793436	0.447316603793436	false	false	false	true
9acbd5bc-2083-4c40-aa73-0ead210048da	2026-08-27 10:13	2026-08-27 10:13	2026-08-27 10:13	CRM	CRM271217P00185000	put	185.0000	2027-12-17	16.8100	16.8000	18.9000	247.0100	68906.00	6760.00	62146.00	41	5	71	690	0.102898550724638	0.463147123122596	0.464494522483299	false	false	false	true
dba75d84-2e46-4ca2-96da-510cd4fd69f5	2026-08-27 10:11	2026-08-27 10:11	2026-08-27 10:11	CRM	CRM260918C00260000	call	260.0000	2026-09-18	5.6500	5.6500	6.2000	247.2099	66670.00	0.00	66670.00	118	11	3333	2200	1.515	0.429784835887229	0.429784835887229	false	false	false	true
566273b7-4834-413d-aadc-5029a6fdbcfb	2026-08-27 10:10	2026-08-27 10:10	2026-08-27 10:10	CRM	CRM260904C00245000	call	245.0000	2026-09-04	8.3500	7.9000	8.4000	246.8000	299765.00	159485.00	0.00	359	6	1129	771	1.46433203631647	0.503262855405421	0.503262855405421	false	false	false	true
dda13c96-aec1-415b-83f3-5ef2262cd17b	2026-08-27 10:10	2026-08-27 10:10	2026-08-27 10:10	CRM	CRM270617C00440000	call	440.0000	2027-06-17	5.0000	4.6000	5.2500	246.1300	100000.00	18000.00	82000.00	200	20	1681	3141	0.535179879019421	0.445992496311677	0.445992496311677	false	false	false	true
d6f85c0c-c6fb-449e-97d4-32f091cf9be6	2026-08-27 10:10	2026-08-27 10:09	2026-08-27 10:09	CRM	CRM270219C00310000	call	310.0000	2027-02-19	10.9500	9.9500	11.0000	245.8900	50365.00	6570.00	43795.00	46	10	64	17	3.76470588235294	0.422435595743107	0.423022169981433	false	false	false	true
caed08c4-79ba-44d8-a80d-854dec784cd2	2026-08-27 10:09	2026-08-27 10:09	2026-08-27 10:09	CRM	CRM260918C00260000	call	260.0000	2026-09-18	5.7000	5.3500	5.7000	246.3100	282720.00	282720.00	0.00	496	7	3020	2200	1.37272727272727	0.445831923147014	0.445831923147014	false	false	false	true
ecae874f-d94b-4b9a-8596-fa866920cffe	2026-08-27 10:08	2026-08-27 10:08	2026-08-27 10:08	CRM	CRM260918C00250000	call	250.0000	2026-09-18	9.1000	9.1000	9.2000	246.6600	276640.00	0.00	276640.00	304	30	5008	8758	0.571820050239781	0.426558808798018	0.429341331656875	true	false	false	true
f0a510a7-4781-44bb-870b-025714b3e0d3	2026-08-27 10:08	2026-08-27 10:08	2026-08-27 10:08	CRM	CRM261120P00230000	put	230.0000	2026-11-20	10.8500	10.6000	10.8500	247.2150	244125.00	244125.00	0.00	225	12	314	102	3.07843137254902	0.415133646890127	0.415133646890127	true	false	false	true
48723f00-7142-4480-8b54-5414313e506f	2026-08-27 10:07	2026-08-27 10:07	2026-08-27 10:07	CRM	CRM260828C00247500	call	247.5000	2026-08-28	4.3500	4.1500	4.3500	247.0300	51330.00	51330.00	0.00	118	5	2074	401	5.17206982543641	0.884964905106172	0.884964905106172	false	false	false	true
1509e14e-67bf-4d9a-a061-1d9827f30a44	2026-08-27 10:07	2026-08-27 10:07	2026-08-27 10:07	CRM	CRM260828C00250000	call	250.0000	2026-08-28	3.2000	3.1500	3.2500	247.0550	98240.00	97920.00	0.00	307	5	8645	2614	3.30719204284621	0.869163219403983	0.869163219403983	false	false	false	true
ae51c7f9-206b-4d1f-bf34-4f365c4d9dfa	2026-08-27 10:06	2026-08-27 10:06	2026-08-27 10:06	CRM	CRM260918C00245000	call	245.0000	2026-09-18	11.2000	11.1500	11.6000	246.3500	101925.00	2245.00	99680.00	91	8	1081	2187	0.494284407864655	0.425259468421544	0.427348424531263	true	false	false	true
08f26ed2-42f7-4194-83de-e64462ba7d36	2026-08-27 10:06	2026-08-27 10:06	2026-08-27 10:06	CRM	CRM260911C00250000	call	250.0000	2026-09-11	7.3500	7.1500	7.3500	246.3800	115395.00	115395.00	0.00	157	6	3697	673	5.49331352154532	0.442484805871202	0.442484805871202	true	false	false	true
eb07a9f0-b0f5-4418-8735-69a076c39b92	2026-08-27 10:05	2026-08-27 10:05	2026-08-27 10:05	CRM	CRM270115C00300000	call	300.0000	2027-01-15	10.0000	9.7500	10.0000	245.1500	63000.00	63000.00	0.00	63	9	594	6463	0.0919077827634226	0.425148950176175	0.425148950176175	false	false	false	true
c0dedeb1-e0ec-442d-9a08-243fc957fc30	2026-08-27 10:05	2026-08-27 10:05	2026-08-27 10:05	CRM	CRM260904P00245000	put	245.0000	2026-09-04	7.0500	7.0000	7.5500	245.1015	148000.00	0.00	148000.00	210	5	273	20	13.65	0.488189215611122	0.494449812566109	false	false	false	true
5ff40736-74c1-4a7e-83a6-bede1f725a5f	2026-08-27 10:04	2026-08-27 10:04	2026-08-27 10:04	CRM	CRM260904C00245000	call	245.0000	2026-09-04	7.2500	7.1000	7.3000	244.8701	145725.00	145725.00	0.00	201	5	694	771	0.900129701686122	0.498919190003482	0.498919190003482	true	false	false	true
3b367865-cf48-46ba-bed5-a580db094229	2026-08-27 10:03	2026-08-27 10:03	2026-08-27 10:03	CRM	CRM261218P00185000	put	185.0000	2026-12-18	3.4000	3.0500	3.7000	244.5200	76160.00	5100.00	71060.00	224	8	230	1036	0.222007722007722	0.458671504248377	0.458671504248377	false	false	false	true
40ca2a01-6ab2-4e59-a4b5-d2c22e2b84fc	2026-08-27 10:01	2026-08-27 10:01	2026-08-27 10:01	CRM	CRM261016C00240000	call	240.0000	2026-10-16	16.9000	16.6500	16.9000	243.8450	82810.00	6760.00	0.00	49	18	313	1127	0.277728482697427	0.399196368133255	0.399196368133255	false	false	false	true
e9439795-0f55-4caa-9aeb-fbda57b4c8b6	2026-08-27 09:55	2026-08-27 09:55	2026-08-27 09:55	CRM	CRM270115P00250000	put	250.0000	2027-01-15	28.1500	27.5000	28.3000	242.3550	61930.00	59115.00	2815.00	22	6	71	3085	0.0230145867098865	0.433359582103621	0.433359582103621	false	false	false	true
48d11890-c316-4548-b866-009a88745527	2026-08-27 09:55	2026-08-27 09:55	2026-08-27 09:55	CRM	CRM280121C00300000	call	300.0000	2028-01-21	35.3000	35.0000	35.3000	241.4538	137670.00	102370.00	0.00	39	6	308	3074	0.100195185426155	0.437464395536473	0.437464395536473	false	false	false	true
d8dced3e-ca47-43ed-af77-d6d75c2ddf52	2026-08-27 09:55	2026-08-27 09:54	2026-08-27 09:54	CRM	CRM260918C00250000	call	250.0000	2026-09-18	7.2000	7.0500	7.3500	242.5200	52560.00	47520.00	5040.00	73	5	3673	8758	0.419387988125143	0.43292842747892	0.427223102762305	false	false	false	true
d3dd0cdf-e89c-4ad6-8c2b-58f172546f1f	2026-08-27 09:55	2026-08-27 09:54	2026-08-27 09:54	CRM	CRM280121C00300000	call	300.0000	2028-01-21	35.8500	35.2000	36.2000	241.8100	143400.00	143400.00	0.00	40	6	172	3074	0.0559531554977228	0.440778350116573	0.440778350116573	false	false	false	true
bd8c7cf1-870d-4064-b8b0-4a6ab1fd8755	2026-08-27 09:51	2026-08-27 09:51	2026-08-27 09:51	CRM	CRM260918C00245000	call	245.0000	2026-09-18	10.0500	9.6000	10.1000	243.2001	50250.00	50250.00	0.00	50	8	345	2187	0.157750342935528	0.446539084700693	0.446539084700693	false	false	false	true
48e71ab2-04f7-43b3-9f7c-f35dff60e611	2026-08-27 09:49	2026-08-27 09:49	2026-08-27 09:49	CRM	CRM260911C00250000	call	250.0000	2026-09-11	6.1600	5.8000	6.2000	243.0000	61590.00	36580.00	25010.00	100	8	2808	673	4.17236255572065	0.458363531060395	0.458363531060395	false	false	false	true
077bf21a-8bc7-4413-9eee-e3f0e8dc70ee	2026-08-27 09:45	2026-08-27 09:45	2026-08-27 09:45	CRM	CRM260828C00237500	call	237.5000	2026-08-28	8.2500	7.4000	8.5000	243.3500	189750.00	5775.00	183975.00	230	58	2458	1629	1.50890116635973	0.895392207629997	0.945397895689471	false	false	false	true
2de57240-cfa6-4bcb-a5aa-acab7c567175	2026-08-27 09:45	2026-08-27 09:45	2026-08-27 09:45	CRM	CRM271217C00210000	call	210.0000	2027-12-17	70.4400	69.8500	71.9000	243.6850	133835.00	84565.00	49270.00	19	5	25	478	0.0523012552301255	0.446872914343729	0.447471411334549	false	false	false	true
d55cd06e-0488-406e-93e1-38ca6579565e	2026-08-27 09:45	2026-08-27 09:45	2026-08-27 09:45	CRM	CRM260828C00237500	call	237.5000	2026-08-28	8.2500	8.2500	8.5000	243.6450	130350.00	0.00	130350.00	158	7	1912	1629	1.17372621240025	0.897875921865896	0.897875921865896	false	false	false	true
4facdbb6-b0f8-45f8-af27-c0fb838302d8	2026-08-27 09:45	2026-08-27 09:45	2026-08-27 09:45	CRM	CRM260828C00237500	call	237.5000	2026-08-28	8.2500	8.2500	8.5000	243.6450	239250.00	0.00	239250.00	290	14	2202	1629	1.35174953959484	0.897875921865896	0.897875921865896	false	false	false	true
d2e62aa0-3ed5-4599-84e6-93dbd95a9aae	2026-08-27 09:45	2026-08-27 09:45	2026-08-27 09:45	CRM	CRM260828C00240000	call	240.0000	2026-08-28	6.7000	6.7000	6.8000	243.9300	161470.00	0.00	161470.00	241	32	5638	2277	2.47606499780413	0.868989424475332	0.879965185884511	false	false	false	true
84634af3-dc15-49cb-aed3-7d4a3f5e24ed	2026-08-27 09:45	2026-08-27 09:45	2026-08-27 09:45	CRM	CRM260828C00240000	call	240.0000	2026-08-28	6.7000	6.7000	6.8000	243.8150	91790.00	0.00	91790.00	137	67	5776	2277	2.53667105841019	0.88098827750208	0.895545745652677	false	false	false	true
fd8ff9f2-7a4f-499e-a609-14dcdc021e96	2026-08-27 09:44	2026-08-27 09:44	2026-08-27 09:44	CRM	CRM260828C00237500	call	237.5000	2026-08-28	8.0000	8.0000	8.4000	243.4800	123200.00	0.00	123200.00	154	12	1464	1629	0.898710865561694	0.86735933676416	0.86735933676416	false	false	false	true
07a67807-d583-4e62-91ff-12a8d46f70ed	2026-08-27 09:41	2026-08-27 09:41	2026-08-27 09:41	CRM	CRM261218C00300000	call	300.0000	2026-12-18	6.5000	6.5000	6.5500	239.4000	128700.00	0.00	68900.00	198	17	278	2259	0.123063302346171	0.431111048554633	0.431111048554633	false	false	false	true
44c7ad64-ba61-42e4-89e9-1c143f73120e	2026-08-27 09:41	2026-08-27 09:41	2026-08-27 09:41	CRM	CRM261218C00240000	call	240.0000	2026-12-18	23.7500	22.6500	24.0000	239.8100	323000.00	323000.00	0.00	136	19	242	2304	0.105034722222222	0.423897075792598	0.423897075792598	false	false	false	true
e4d2acbc-41f0-4b73-8433-3498bf0b2ba9	2026-08-27 09:39	2026-08-27 09:39	2026-08-27 09:39	CRM	CRM260911C00250000	call	250.0000	2026-09-11	4.8000	4.1500	4.8000	239.2200	239520.00	239520.00	0.00	499	7	1146	673	1.70282317979198	0.45874337764301	0.458745293365372	false	false	false	true
c6f5562c-adcd-4cbe-94d7-5f790997da88	2026-08-27 09:39	2026-08-27 09:38	2026-08-27 09:38	CRM	CRM261120C00250000	call	250.0000	2026-11-20	14.9000	14.3000	14.9000	238.9900	81950.00	81950.00	0.00	55	5	142	950	0.149473684210526	0.405488600151357	0.405488600151357	false	false	false	true