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 = RepeatedHitsAscendingFill×ticker = CRM×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	expiry

3313d6f9-c52c-4533-80c9-b653e690a180	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	CRM	CRM260828P00192500	put	192.5000	2026-08-28	4.8300	4.4500	4.8500	201.9200	238208.00	238208.00	0.00	493	46	606	1699	0.356680400235433	0.704155461961723	0.715758823319681	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	213510890000.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
27e58306-2e92-497f-a586-c6253ddcea20	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	CRM	CRM260828P00192500	put	192.5000	2026-08-28	4.8400	4.4500	4.8500	201.8550	244841.00	237716.00	7125.00	506	45	1121	1699	0.659799882283696	0.708601090611155	0.70503181410147	true	false	false	true
0df867df-0a18-4b22-bccf-796a4115705c	2026-08-19 11:44	2026-08-19 11:44	2026-08-19 11:44	CRM	CRM260821C00207500	call	207.5000	2026-08-21	2.8400	2.7650	2.8900	207.0000	81791.00	27356.00	54435.00	288	5	1317	1074	1.22625698324022	0.497285759633369	0.502197546271613	true	false	false	true
cb68f67a-6440-4e41-a711-9b644daf95eb	2026-08-19 13:07	2026-08-19 13:07	2026-08-19 13:07	CRM	CRM260918P00200000	put	200.0000	2026-09-18	8.5500	8.5500	8.8500	206.5600	461719.00	0.00	461719.00	540	59	768	4714	0.162918964785745	0.507967004177158	0.50855298481152	false	false	false	true
906e9abc-551b-4a7c-b732-68366bf1006b	2026-08-20 09:59	2026-08-20 09:59	2026-08-20 09:59	CRM	CRM260918P00200000	put	200.0000	2026-09-18	8.6500	8.6000	9.0500	205.7400	161795.00	20800.00	140995.00	187	11	611	5304	0.115196078431373	0.507216522469093	0.507216522469093	true	false	false	true
ba62dfcb-4297-41ab-9d73-fd169092989a	2026-08-20 11:13	2026-08-20 11:13	2026-08-20 11:13	CRM	CRM260918C00210000	call	210.0000	2026-09-18	10.4500	10.4000	10.7500	207.3900	313510.00	1050.00	312460.00	300	28	3854	8492	0.453838907206783	0.487468070636825	0.487468070636825	true	false	false	true
e9fc23e8-f289-4c16-bb42-4e1752cb8d96	2026-08-20 11:24	2026-08-20 11:24	2026-08-20 11:24	CRM	CRM260918P00200000	put	200.0000	2026-09-18	7.8600	7.8000	8.1500	206.7300	202873.00	21390.00	181483.00	258	38	3187	5304	0.600867269984917	0.48795354368734	0.492496325044409	true	false	false	true
96b7c7a7-5156-41f3-ba26-53564ff377b2	2026-08-20 11:38	2026-08-20 11:38	2026-08-20 11:38	CRM	CRM260918P00200000	put	200.0000	2026-09-18	7.7000	7.7000	7.8500	206.9750	81623.00	0.00	81623.00	106	35	3460	5304	0.652337858220211	0.485236210360361	0.485236210360361	true	false	false	true
3804aa10-57d8-4121-96b2-0e4afea1d421	2026-08-20 11:39	2026-08-20 11:39	2026-08-20 11:39	CRM	CRM260918P00200000	put	200.0000	2026-09-18	7.7000	7.7000	7.9000	206.9550	168633.00	0.00	168633.00	219	52	3702	5304	0.697963800904977	0.484902274411318	0.484902274411318	true	false	false	true
df7d1c0f-5e6c-4d73-87ac-8335f885ada9	2026-08-21 10:45	2026-08-21 10:45	2026-08-21 10:45	CRM	CRM261218P00210000	put	210.0000	2026-12-18	21.0100	20.6500	21.0500	209.0000	90345.00	84090.00	6255.00	43	12	46	938	0.0490405117270789	0.461250058800314	0.461250058800314	true	false	false	true
762ca3ec-46bf-4e98-9a32-cfb82dfa3f80	2026-08-24 15:41	2026-08-24 15:41	2026-08-24 15:41	CRM	CRM260918C00180000	call	180.0000	2026-09-18	32.1500	32.1000	33.4000	210.1900	99659.00	0.00	99659.00	31	6	54	3604	0.0149833518312986	0.505277670986947	0.508282347569997	false	false	false	true
94fe7a70-707c-47c2-ab41-fbdf9684b234	2026-08-25 12:46	2026-08-25 12:46	2026-08-25 12:46	CRM	CRM261218C00200000	call	200.0000	2026-12-18	25.5300	25.3500	25.8000	207.1600	127640.00	10215.00	58660.00	50	30	431	3856	0.111773858921162	0.450123264029445	0.451255599893361	false	false	false	true
e8302318-b4d3-4cca-817a-e4649745b6b3	2026-08-25 13:58	2026-08-25 13:58	2026-08-25 13:58	CRM	CRM260918P00195000	put	195.0000	2026-09-18	6.1700	5.8500	6.2000	205.2800	123352.00	123352.00	0.00	200	6	627	3415	0.183601756954612	0.523350698501967	0.523882085711655	false	false	false	true
f2eb34b5-2a7d-4425-94ca-8c08eb5262eb	2026-08-26 10:05	2026-08-26 10:05	2026-08-26 10:05	CRM	CRM260828P00180000	put	180.0000	2026-08-28	0.8300	0.7700	0.8400	204.3950	218374.00	147604.00	68638.00	2639	85	5382	1556	3.45886889460154	1.30864628359804	1.31282690154187	false	false	false	true
f6fbc2ca-3769-4876-8869-fc878c290a82	2026-08-26 13:50	2026-08-26 13:50	2026-08-26 13:50	CRM	CRM260904P00202500	put	202.5000	2026-09-04	7.9400	7.5500	7.9500	203.7700	143670.00	142880.00	790.00	181	5	267	22	12.1363636363636	0.677231938502938	0.677231938502938	false	false	false	true
12ca9da9-57f1-48b8-8a3f-6cf411d19dc8	2026-08-26 15:30	2026-08-26 15:30	2026-08-26 15:30	CRM	CRM260828P00195000	put	195.0000	2026-08-28	3.2100	3.2000	3.3500	205.0000	54000.00	3250.00	50750.00	168	13	1338	1866	0.717041800643087	1.20674786410483	1.21666412659175	true	false	false	true
f11508d2-a1ee-4cda-9035-e9224a14a03e	2026-08-27 09:31	2026-08-27 09:31	2026-08-27 09:31	CRM	CRM260828C00220000	call	220.0000	2026-08-28	15.0400	14.7500	16.8000	235.6500	109784.00	12284.00	97500.00	73	6	149	5741	0.0259536666086048	1.38053908623658	0.836243922355773	false	false	false	true
a155cf87-b1d1-4361-841d-1e4d4da398d2	2026-08-27 09:31	2026-08-27 09:31	2026-08-27 09:31	CRM	CRM260828C00210000	call	210.0000	2026-08-28	24.1800	18.8000	26.3500	234.9900	174077.00	81862.00	92215.00	72	12	74	4424	0.0167269439421338	2.40239223358247	1.4333540111055	true	false	false	true
20b66a6f-fec6-4ef2-a232-d00d92949d4f	2026-08-27 09:31	2026-08-27 09:31	2026-08-27 09:31	CRM	CRM270115C00240000	call	240.0000	2027-01-15	23.2600	21.9000	25.2500	235.6500	67465.00	45315.00	22150.00	29	6	30	3391	0.00884694780300796	0.38558179458422	0.414859370675547	false	false	false	true
04f4cc36-df90-4d74-bfb9-f5748cbd72fe	2026-08-27 09:31	2026-08-27 09:31	2026-08-27 09:31	CRM	CRM260828C00220000	call	220.0000	2026-08-28	14.0600	12.2750	16.4250	234.9900	80158.00	25683.00	54475.00	57	12	61	5741	0.0106253265981536	0.76701672590548	1.22137574549977	true	false	false	true
bb1b6499-3234-4430-a667-5ad92af3579c	2026-08-27 09:33	2026-08-27 09:33	2026-08-27 09:33	CRM	CRM260918C00210000	call	210.0000	2026-09-18	25.7400	24.8000	26.3500	233.9600	597140.00	594575.00	2565.00	232	6	333	11448	0.0290880503144654	0.380907712137393	0.39885389675799	false	false	false	true
d024c65f-9b32-4a70-b292-8256c05e7fd7	2026-08-27 09:41	2026-08-27 09:41	2026-08-27 09:41	CRM	CRM260911C00250000	call	250.0000	2026-09-11	5.3000	4.7000	5.3000	240.2855	258625.00	258625.00	0.00	488	21	1646	673	2.44576523031204	0.464654483889606	0.46300861158566	false	false	false	true
279b5fa2-c673-460b-a383-ec2bf4320e93	2026-08-27 10:29	2026-08-27 10:29	2026-08-27 10:29	CRM	CRM260911P00240000	put	240.0000	2026-09-11	4.8000	4.8000	5.3000	247.7000	53780.00	490.00	53290.00	112	25	1018	1	1018	0.418240888592402	0.422447326039044	true	false	false	true
565d0b53-4e0a-40bd-a84a-d51e63821c90	2026-08-27 10:36	2026-08-27 10:36	2026-08-27 10:36	CRM	CRM260918C00245000	call	245.0000	2026-09-18	11.8500	11.8000	12.1500	248.2500	209767.00	4755.00	205012.00	177	40	1414	2187	0.646547782350251	0.407483721719187	0.407483721719187	true	false	false	true
ccdea0d9-d244-480b-bf92-1956b2448794	2026-08-27 10:37	2026-08-27 10:37	2026-08-27 10:37	CRM	CRM260918P00240000	put	240.0000	2026-09-18	6.1200	6.0750	6.4000	248.7900	67275.00	21525.00	45750.00	110	14	2080	90	23.1111111111111	0.422212022481392	0.424453246345322	true	false	false	true
8befec1f-53ae-479b-81d8-d1558fc3ab0b	2026-08-27 10:43	2026-08-27 10:42	2026-08-27 10:42	CRM	CRM260828C00240000	call	240.0000	2026-08-28	10.9000	10.4500	11.2500	250.2499	284580.00	284580.00	0.00	261	5	9943	2277	4.36671058410189	0.815611834508428	0.757624631841904	true	false	false	true
d7ac867b-6d28-494c-b5e1-48f7d8790599	2026-08-27 10:46	2026-08-27 10:46	2026-08-27 10:46	CRM	CRM260925P00240000	put	240.0000	2026-09-25	7.0000	7.0000	7.5500	248.5700	483827.00	1450.00	482377.00	691	53	1011	0	0	0.402096244046803	0.412014442010809	true	false	false	true
8b3de06f-ccec-4657-9bb5-f786db353f13	2026-08-27 12:17	2026-08-27 12:17	2026-08-27 12:17	CRM	CRM270319C00210000	call	210.0000	2027-03-19	54.4700	52.8000	55.0000	246.5550	185205.00	119925.00	65280.00	34	8	149	553	0.269439421338156	0.437821267949802	0.440467363470557	false	false	false	true
1fa292af-ab6a-403a-9dd6-f2c6ec013f90	2026-08-27 12:26	2026-08-27 12:26	2026-08-27 12:26	CRM	CRM271217C00260000	call	260.0000	2027-12-17	51.2300	50.6000	52.4500	248.3900	112705.00	25650.00	87055.00	22	5	559	278	2.01079136690647	0.448425370243201	0.448883651704289	false	false	false	true
bb9e88f9-ec64-4f94-988b-9696e71a6636	2026-08-27 12:33	2026-08-27 12:32	2026-08-27 12:32	CRM	CRM260828C00245000	call	245.0000	2026-08-28	6.4400	6.1500	6.5000	249.5850	128768.00	128768.00	0.00	200	5	14051	904	15.5431415929204	0.711518765418456	0.711518765418456	false	false	false	true
47a8c082-5214-4cb0-bed7-b18b9b8d9959	2026-08-27 13:33	2026-08-27 13:33	2026-08-27 13:33	CRM	CRM271217C00260000	call	260.0000	2027-12-17	52.6300	51.5500	52.8500	250.0000	126315.00	73665.00	52650.00	24	7	670	278	2.41007194244604	0.452921374842113	0.453611413683309	false	false	false	true
399c9194-54fa-48f8-ae74-1afbdeea14e6	2026-08-27 13:40	2026-08-27 13:40	2026-08-27 13:40	CRM	CRM271217C00260000	call	260.0000	2027-12-17	53.8600	53.3000	53.9500	251.4050	226225.00	177750.00	48475.00	42	6	887	278	3.19064748201439	0.456209358971508	0.456665711653484	true	false	false	true
0e8febc6-7a74-4cac-b6c9-af60d2f71fb1	2026-08-27 13:40	2026-08-27 13:40	2026-08-27 13:40	CRM	CRM271217C00260000	call	260.0000	2027-12-17	53.7800	53.3000	53.9000	251.4000	118320.00	86040.00	32280.00	22	6	845	278	3.03956834532374	0.455142442550138	0.455781251065644	false	false	false	true
cbe755e8-f27e-429f-9da3-155dd6c0d2d5	2026-08-27 13:40	2026-08-27 13:40	2026-08-27 13:40	CRM	CRM260828C00252500	call	252.5000	2026-08-28	3.3500	3.2000	3.3500	251.5450	149551.00	149551.00	0.00	447	13	7916	128	61.84375	0.717506935060257	0.721448827278053	false	false	false	true
8a1e2982-fc92-4561-ab9d-4f19779bcf9b	2026-08-27 15:00	2026-08-27 15:00	2026-08-27 15:00	CRM	CRM260828C00250000	call	250.0000	2026-08-28	4.2200	4.2000	4.5000	250.8001	97143.00	0.00	90343.00	230	41	29667	2614	11.349273144606	0.721582063394463	0.721582063394463	true	false	false	true
83684165-bd02-4f95-af36-b3327e851d53	2026-08-27 15:09	2026-08-27 15:09	2026-08-27 15:09	CRM	CRM271217C00250000	call	250.0000	2027-12-17	58.5800	56.5000	58.6000	251.8500	87864.00	82034.00	5830.00	15	9	823	872	0.943807339449541	0.460000474755097	0.457285928777245	false	false	false	true
69df48b7-faae-471b-8286-4827cb5a0429	2026-08-27 15:09	2026-08-27 15:09	2026-08-27 15:09	CRM	CRM271217C00240000	call	240.0000	2027-12-17	62.7800	62.2000	63.2500	251.8500	50220.00	37695.00	12525.00	8	6	351	282	1.24468085106383	0.456391149536906	0.45784170662031	false	false	false	true
5a8ef272-98a1-4d90-8223-ab86bcb8045d	2026-08-27 15:09	2026-08-27 15:09	2026-08-27 15:09	CRM	CRM271217C00220000	call	220.0000	2027-12-17	72.5300	72.0000	72.9500	251.8800	268350.00	130665.00	115950.00	37	13	249	728	0.342032967032967	0.459250798642624	0.45977978187343	false	false	false	true
0174c406-95fb-4f8a-ac6b-29a5aa5e15c3	2026-08-28 09:35	2026-08-28 09:35	2026-08-28 09:35	CRM	CRM260828C00260000	call	260.0000	2026-08-28	1.8000	1.6700	1.8500	257.3800	163616.00	163616.00	0.00	909	5	7364	8816	0.83529945553539	1.05021740358041	1.04747085104722	false	false	false	true
9278420f-db96-43e3-8aff-d67acbd22f21	2026-08-28 09:46	2026-08-28 09:46	2026-08-28 09:46	CRM	CRM260828C00260000	call	260.0000	2026-08-28	2.0000	1.9200	2.0000	259.1150	55572.00	55572.00	0.00	278	22	14082	8816	1.59732304900181	0.875656284601524	0.874452535797884	true	false	false	true
87c56ae8-fe03-43be-82d8-6d559e5836cc	2026-08-28 10:09	2026-08-28 10:09	2026-08-28 10:09	CRM	CRM260911C00250000	call	250.0000	2026-09-11	12.6500	12.5500	13.6000	258.5900	271924.00	0.00	271924.00	215	16	2206	3192	0.691102756892231	0.366564100015824	0.386737551907782	false	false	false	true
efe12ee9-1f0c-4e77-8f21-79170446aac5	2026-08-28 10:23	2026-08-28 10:22	2026-08-28 10:22	CRM	CRM260918C00265000	call	265.0000	2026-09-18	6.6100	6.6000	7.0500	258.3514	102412.00	0.00	102412.00	155	24	1500	0	0	0.37289057691311	0.377028685809151	true	false	false	true
f90d28eb-2562-4b78-a496-cc93a4b8b8d3	2026-08-28 11:53	2026-08-28 11:53	2026-08-28 11:53	CRM	CRM260918P00225000	put	225.0000	2026-09-18	0.8000	0.7150	0.9000	261.0000	50132.00	81.00	47216.00	626	50	919	1540	0.596753246753247	0.429980944526171	0.431232323287666	false	false	false	true
153dad36-00e9-42c5-9c2e-42d66dd85a02	2026-08-28 14:26	2026-08-28 14:26	2026-08-28 14:26	CRM	CRM260904C00270000	call	270.0000	2026-09-04	2.5300	2.3700	2.5300	260.3950	115347.00	115095.00	0.00	456	56	2127	643	3.30793157076205	0.413684377807057	0.417815238195097	false	false	false	true
cb5c7545-4b8f-478f-908e-62423c94fdc1	2026-08-31 11:50	2026-08-31 11:50	2026-08-31 11:50	CRM	CRM261120C00260000	call	260.0000	2026-11-20	20.5600	20.3500	20.6000	260.7400	162395.00	162395.00	0.00	79	11	827	974	0.849075975359343	0.390987889274574	0.392020515354615	false	false	false	true
7d5ee133-cc6c-4126-a1a9-19150aa21398	2026-08-31 11:59	2026-08-31 11:59	2026-08-31 11:59	CRM	CRM270115P00200000	put	200.0000	2027-01-15	4.9000	4.7500	4.9000	261.4300	263521.00	263521.00	0.00	538	28	1060	8400	0.126190476190476	0.448238179573695	0.449165475572887	false	false	false	true
e4a5c285-9d5b-4262-b061-0014231d158f	2026-08-31 12:13	2026-08-31 12:13	2026-08-31 12:13	CRM	CRM261120C00260000	call	260.0000	2026-11-20	21.2600	20.9500	22.2500	261.8900	174360.00	74300.00	100060.00	82	5	2269	974	2.32956878850103	0.393320229701169	0.393031203151654	false	false	false	true
c5069613-2cdb-4542-8ef7-11d0a844fb79	2026-08-31 12:22	2026-08-31 12:22	2026-08-31 12:22	CRM	CRM270917C00230000	call	230.0000	2027-09-17	66.7800	66.5000	66.9500	261.1900	607710.00	301050.00	306660.00	91	6	98	77	1.27272727272727	0.439729879049049	0.441422989546252	false	false	false	true
6e1e02c8-a56b-4daf-8019-f1a3c3c88e7e	2026-08-31 13:11	2026-08-31 13:11	2026-08-31 13:11	CRM	CRM260904C00262500	call	262.5000	2026-09-04	4.0000	4.0000	4.2000	260.5900	137224.00	0.00	137224.00	343	49	1295	310	4.17741935483871	0.44593547744606	0.443852832440849	false	false	false	true
eb2f23a0-c527-49e0-a1bb-bd78848179b5	2026-08-31 13:36	2026-08-31 13:36	2026-08-31 13:36	CRM	CRM261218C00400000	call	400.0000	2026-12-18	1.3300	1.3300	1.4400	260.3900	83943.00	548.00	83395.00	631	46	921	383	2.40469973890339	0.443007822867027	0.445535382155214	false	false	false	true