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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = CMG×

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

bdf31c1e-5d30-45cc-85ba-629fb8a41290	2026-09-02 10:38	2026-09-02 10:38	2026-09-02 10:38	CMG	CMG260918P00038500	put	38.5000	2026-09-18	1.0300	0.9500	1.0300	38.4200	18643.00	18643.00	0.00	181	9	184	308	0.597402597402597	0.32164397140879	0.318605479144849	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	46858428540.00	2026-10-28	postmarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6562184f-55a0-4216-bb10-129159decdef	2026-09-02 10:16	2026-09-02 10:16	2026-09-02 10:16	CMG	CMG260918C00037500	call	37.5000	2026-09-18	1.5600	1.5000	1.5600	38.3250	11856.00	11856.00	0.00	76	6	8173	13644	0.599017883318675	0.334160436554933	0.334160436554933	false	false	false	true
60b42812-67a3-44bb-99a6-abb602f663be	2026-09-02 10:15	2026-09-02 10:15	2026-09-02 10:15	CMG	CMG260918C00037500	call	37.5000	2026-09-18	1.5500	1.4900	1.5500	38.3500	13950.00	13950.00	0.00	90	30	7176	13644	0.5259454705365	0.325372633529466	0.325372633529466	true	false	false	true
c35fe736-a433-4415-8450-e02cfbe4f8e6	2026-09-02 10:00	2026-09-02 10:00	2026-09-02 10:00	CMG	CMG260925C00037000	call	37.0000	2026-09-25	2.2400	2.0900	2.2400	38.4900	22400.00	22400.00	0.00	100	6	124	919	0.134929270946681	0.34458983149825	0.34458983149825	false	false	false	true
c47f85d4-42a9-4a8e-a0a7-95b42afe1f2e	2026-09-02 09:52	2026-09-02 09:52	2026-09-02 09:52	CMG	CMG260918C00037500	call	37.5000	2026-09-18	1.7400	1.6700	1.7400	38.6000	14964.00	14964.00	0.00	86	19	1184	13644	0.0867780709469364	0.333338102890392	0.333338102890392	false	false	false	true
e8b5508d-01f5-4253-88a3-6325b65029aa	2026-09-02 09:49	2026-09-02 09:49	2026-09-02 09:49	CMG	CMG260918C00037500	call	37.5000	2026-09-18	1.7000	1.6100	1.7000	38.5150	138720.00	138720.00	0.00	816	8	1018	13644	0.074611550864849	0.339323366152824	0.339323366152824	false	false	false	true
bb3e88d1-5281-493c-9d35-912bec00f79a	2026-09-01 15:03	2026-09-01 15:03	2026-09-01 15:03	CMG	CMG260904P00037500	put	37.5000	2026-09-04	0.4900	0.4700	0.5100	37.5450	33565.00	11221.00	22344.00	685	8	1368	2349	0.582375478927203	0.381724564741716	0.381724564741716	false	false	false	true
34264c54-20b8-4c73-a8fb-0eaa2785102a	2026-09-01 11:00	2026-09-01 11:00	2026-09-01 11:00	CMG	CMG260911P00038500	put	38.5000	2026-09-11	1.1600	1.1200	1.1600	37.8350	17168.00	17168.00	0.00	148	8	1071	3	357	0.321320946853594	0.321320946853594	true	false	false	true
c400616a-a6e9-415a-ab84-bbe345a52016	2026-09-01 10:53	2026-09-01 10:53	2026-09-01 10:53	CMG	CMG260911P00038500	put	38.5000	2026-09-11	1.1400	1.0900	1.1400	37.8850	11286.00	11286.00	0.00	99	6	102	3	34	0.325575511872803	0.325575511872803	true	false	false	true
6f458cf9-db67-43ba-a90b-a872c307ff2b	2026-09-01 10:53	2026-09-01 10:53	2026-09-01 10:53	CMG	CMG260918C00035000	call	35.0000	2026-09-18	3.1000	3.1000	3.2000	37.8850	124000.00	0.00	124000.00	400	12	415	15039	0.0275949198749917	0.322138261711209	0.322138261711209	true	false	false	true
db5ca932-fceb-4b08-8734-9877f7eb0870	2026-09-01 10:13	2026-09-01 10:13	2026-09-01 10:13	CMG	CMG261218C00040000	call	40.0000	2026-12-18	2.4000	2.3800	2.4000	37.6300	24000.00	24000.00	0.00	100	5	101	4081	0.0247488360695908	0.390659658240842	0.390659658240842	false	false	false	true
a7389599-db83-4e97-a2de-612dc82bbd81	2026-09-01 10:08	2026-09-01 10:08	2026-09-01 10:08	CMG	CMG270115P00040000	put	40.0000	2027-01-15	4.5000	4.4500	4.6000	37.6650	11250.00	3150.00	8100.00	25	5	37	4794	0.00771798080934501	0.376432348029879	0.376432348029879	false	false	false	true
687ba33d-ebca-4d5d-8bfb-f1c87f779d6c	2026-08-31 15:44	2026-08-31 15:44	2026-08-31 15:44	CMG	CMG261218C00038000	call	38.0000	2026-12-18	3.5500	3.4500	3.5500	38.0000	14906.00	14906.00	0.00	42	20	87	3540	0.0245762711864407	0.404304189944288	0.404304189944288	false	false	false	true
9deec779-270b-48c8-b354-7caf1689134d	2026-08-31 14:01	2026-08-31 14:01	2026-08-31 14:01	CMG	CMG260904C00038500	call	38.5000	2026-09-04	0.4500	0.3700	0.4500	38.0000	10620.00	10620.00	0.00	236	8	474	319	1.4858934169279	0.374834139645732	0.374834139645732	true	false	false	true
9a89052d-649b-48be-a166-1f48784ca252	2026-08-31 14:01	2026-08-31 14:01	2026-08-31 14:01	CMG	CMG260918C00039000	call	39.0000	2026-09-18	0.8000	0.7500	0.8000	38.0000	28080.00	28080.00	0.00	351	5	368	413	0.891041162227603	0.336523821005102	0.336523821005102	false	false	false	true
66d9df75-6f38-4b7e-86d9-936a784db06e	2026-08-31 12:53	2026-08-31 12:53	2026-08-31 12:53	CMG	CMG261218P00034400	put	34.4000	2026-12-18	1.5200	1.5200	1.5700	38.0700	19304.00	0.00	19304.00	127	7	127	279	0.455197132616487	0.401670466335968	0.401670466335968	false	false	false	true
ae7b0c93-eb09-41f5-8d55-efee560842ff	2026-08-31 11:42	2026-08-31 11:42	2026-08-31 11:42	CMG	CMG261218P00031600	put	31.6000	2026-12-18	0.8200	0.8200	0.8700	37.9600	27306.00	0.00	27306.00	333	7	398	790	0.50379746835443	0.411219748102197	0.411219748102197	false	false	false	true
c4a84c28-7649-4739-bd01-25f418dd71c3	2026-08-28 15:42	2026-08-28 15:42	2026-08-28 15:42	CMG	CMG270115C00040000	call	40.0000	2027-01-15	3.0000	2.9000	3.0500	38.0400	22800.00	300.00	22500.00	76	5	208	8986	0.0231471177387047	0.383724295706042	0.383465489449666	false	false	false	true
a2c85522-d47d-4fdf-8e81-27224d94aa24	2026-08-28 15:37	2026-08-28 15:37	2026-08-28 15:37	CMG	CMG270617P00040000	put	40.0000	2027-06-17	5.8500	5.7500	5.9000	38.0450	12870.00	12870.00	0.00	22	5	28	1107	0.025293586269196	0.396391670836062	0.396391670836062	false	false	false	true
4c483464-4181-4841-b607-88ca9942baef	2026-08-28 13:19	2026-08-28 13:19	2026-08-28 13:19	CMG	CMG270115C00040000	call	40.0000	2027-01-15	2.9000	2.8100	2.9000	37.8750	29000.00	290.00	0.00	100	18	120	8986	0.0133541063877142	0.381285358038651	0.381285358038651	false	false	false	true
bfa5feea-3e7d-4c61-8529-fff904662346	2026-08-28 12:42	2026-08-28 12:42	2026-08-28 12:42	CMG	CMG261016C00037500	call	37.5000	2026-10-16	2.3000	2.3000	2.3200	37.9850	24610.00	0.00	24610.00	107	24	169	817	0.206854345165239	0.353369374958943	0.353369374958943	false	false	false	true
e28b90d0-b7ff-4aed-b462-4d6e0adbdc0b	2026-08-28 12:24	2026-08-28 12:24	2026-08-28 12:24	CMG	CMG260918P00038000	put	38.0000	2026-09-18	1.1500	1.0800	1.1600	38.0101	29325.00	29325.00	0.00	255	24	398	546	0.728937728937729	0.331264465580545	0.329330796574642	false	false	false	true
5b132976-c3b1-4ff6-b47f-e8c3327b2a1d	2026-08-28 12:10	2026-08-28 12:09	2026-08-28 12:09	CMG	CMG260918C00035000	call	35.0000	2026-09-18	3.4200	3.4000	3.5500	38.1300	10260.00	0.00	10260.00	30	5	124	15136	0.0081923890063425	0.3399334347166	0.3399334347166	false	false	false	true
221cacab-5d47-490b-b736-10ce72e02f2c	2026-08-28 11:46	2026-08-28 11:46	2026-08-28 11:46	CMG	CMG260918C00040000	call	40.0000	2026-09-18	0.4900	0.4900	0.5500	38.0000	24500.00	0.00	24500.00	500	57	1333	35629	0.037413343063235	0.31945281488009	0.321734239431033	true	false	false	true
2b9b2c2d-2d25-4278-a539-32176843f047	2026-08-28 11:25	2026-08-28 11:24	2026-08-28 11:24	CMG	CMG260918C00040000	call	40.0000	2026-09-18	0.5700	0.4900	0.5700	38.1400	16872.00	16872.00	0.00	296	28	812	35629	0.022790423531393	0.338440961273782	0.338440961273782	true	false	false	true
28f2c499-2f38-415b-bde1-f91f428d2dcb	2026-08-28 10:14	2026-08-28 10:14	2026-08-28 10:14	CMG	CMG260925P00038000	put	38.0000	2026-09-25	1.4000	1.3100	1.4000	37.9700	36120.00	36120.00	0.00	258	39	258	11	23.4545454545455	0.343636250387002	0.343636250387002	false	false	false	true
41a1f248-d784-4ae7-aaf1-708fb0a2c075	2026-08-27 15:48	2026-08-27 15:48	2026-08-27 15:48	CMG	CMG280121P00042500	put	42.5000	2028-01-21	8.9000	8.9000	9.3000	37.3000	251870.00	0.00	251870.00	283	28	283	407	0.695331695331695	0.410692495538117	0.410692495538117	false	false	false	true
ebe91dad-a72e-4954-a58d-019acafddb28	2026-08-27 11:17	2026-08-27 11:16	2026-08-27 11:16	CMG	CMG261016P00035000	put	35.0000	2026-10-16	1.0000	1.0000	1.0200	37.0450	10500.00	0.00	10500.00	105	6	207	1156	0.179065743944637	0.360475911716901	0.360475911716901	true	false	false	true
d4433947-9567-4fae-a88b-4680da04d419	2026-08-27 11:14	2026-08-27 11:13	2026-08-27 11:13	CMG	CMG270617P00025000	put	25.0000	2027-06-17	0.8200	0.8200	0.8900	37.0400	15088.00	0.00	15088.00	184	14	807	2235	0.361073825503356	0.43711918427224	0.437033465244705	false	false	false	true
74b4b7b9-6574-483c-9e1d-5708ac92858e	2026-08-27 11:14	2026-08-27 11:13	2026-08-27 11:13	CMG	CMG270617P00025000	put	25.0000	2027-06-17	0.8100	0.8100	0.8200	37.0400	14419.00	82.00	14337.00	178	12	623	2235	0.278747203579418	0.435402460055003	0.437033465244705	false	false	false	true
e532a8fe-a1a7-40a6-a867-eb318b84b587	2026-08-27 11:02	2026-08-27 11:02	2026-08-27 11:02	CMG	CMG260918C00037500	call	37.5000	2026-09-18	1.0600	1.0300	1.0900	37.0550	22260.00	0.00	22154.00	210	8	285	13964	0.0204096247493555	0.337723111538176	0.337723111538176	false	false	false	true
84ecd2f8-7d9a-4751-97de-dc2f5deb7d86	2026-08-27 10:59	2026-08-27 10:59	2026-08-27 10:59	CMG	CMG261016C00040000	call	40.0000	2026-10-16	0.9500	0.9200	0.9600	37.1900	117800.00	117800.00	0.00	1240	18	1289	894	1.44183445190157	0.349779227023803	0.349779227023803	false	false	false	true
482e03d0-82c5-467c-9bba-5bb729ab29aa	2026-08-26 09:40	2026-08-26 09:40	2026-08-26 09:40	CMG	CMG260828C00035500	call	35.5000	2026-08-28	1.5000	1.4500	1.5000	36.9000	75000.00	75000.00	0.00	500	19	500	1434	0.348675034867504	0.485796551596973	0.485796551596973	true	false	false	true
de03cf88-b71e-4336-a657-b56f5ecf777b	2026-08-26 09:30	2026-08-26 09:30	2026-08-26 09:30	CMG	CMG260828P00038000	put	38.0000	2026-08-28	0.9500	0.7100	1.2000	37.2100	18050.00	0.00	18050.00	190	5	190	936	0.202991452991453	0.410893370147284	0.410893370147284	false	false	false	true
ca109d43-0f03-4b28-b92b-b18c49621e7e	2026-08-25 14:45	2026-08-25 14:45	2026-08-25 14:45	CMG	CMG260828C00036000	call	36.0000	2026-08-28	1.9500	1.5400	2.0100	37.8900	21840.00	21840.00	0.00	112	5	365	1981	0.184250378596668	0.403598422774843	0.403598422774843	true	false	false	true
d68a70c0-2d1a-4d36-802b-33639bca5c16	2026-08-25 14:45	2026-08-25 14:45	2026-08-25 14:45	CMG	CMG280121P00040000	put	40.0000	2028-01-21	7.2000	7.2000	7.5000	37.8800	61200.00	0.00	61200.00	85	14	226	2576	0.0877329192546584	0.41214204267265	0.41214204267265	false	false	false	true
7f71a76e-f07d-4588-8af8-7a73b3d06d04	2026-08-25 14:34	2026-08-25 14:34	2026-08-25 14:34	CMG	CMG280121P00040000	put	40.0000	2028-01-21	7.2500	7.2500	7.5000	37.7500	102225.00	0.00	102225.00	141	9	141	2576	0.0547360248447205	0.412022052223704	0.412022052223704	false	false	false	true
0988aa8d-6c39-4c6c-afa7-54deb00e496d	2026-08-25 10:44	2026-08-25 10:44	2026-08-25 10:44	CMG	CMG270319P00035000	put	35.0000	2027-03-19	2.7900	2.7900	2.8500	37.8800	20088.00	0.00	20088.00	72	15	255	548	0.465328467153285	0.407590064502244	0.407590064502244	false	false	false	true
8f971c0f-ab3a-4bac-a5b6-e80605fb89b0	2026-08-25 10:44	2026-08-25 10:44	2026-08-25 10:44	CMG	CMG270319P00035000	put	35.0000	2027-03-19	2.8100	2.7100	2.8100	37.8825	23885.00	23885.00	0.00	85	6	183	548	0.333941605839416	0.40964968886169	0.40964968886169	false	false	false	true
f2496676-b737-4374-bd56-33877dd25eda	2026-08-25 10:44	2026-08-25 10:44	2026-08-25 10:44	CMG	CMG270319P00035000	put	35.0000	2027-03-19	2.8100	2.6800	2.8100	37.8800	27538.00	27538.00	0.00	98	9	98	548	0.178832116788321	0.409727405460775	0.409571958069035	false	false	false	true
f8511e39-a075-4261-9726-ba38e48c630c	2026-08-24 14:55	2026-08-24 14:55	2026-08-24 14:55	CMG	CMG260918P00037500	put	37.5000	2026-09-18	1.2100	1.1800	1.2100	37.8100	30250.00	30250.00	0.00	250	8	616	5236	0.117647058823529	0.357800811875032	0.357800811875032	false	false	false	true
749b2c26-c157-4040-985f-8dbd44416d32	2026-08-24 12:22	2026-08-24 12:22	2026-08-24 12:22	CMG	CMG260918C00040000	call	40.0000	2026-09-18	0.7000	0.6600	0.7000	37.9000	11830.00	11830.00	0.00	169	14	3318	33263	0.0997504734990831	0.367146382789959	0.367146382789959	true	false	false	true
058bf747-7151-4914-bf48-39151fb616bd	2026-08-24 12:19	2026-08-24 12:19	2026-08-24 12:19	CMG	CMG270115C00040000	call	40.0000	2027-01-15	3.1100	3.1000	3.2000	38.0000	31148.00	0.00	31148.00	100	6	158	9111	0.0173416748984744	0.387567114439099	0.389925575630867	false	false	false	true
061df9be-94ab-4498-96fe-abc56eefe65c	2026-08-24 11:32	2026-08-24 11:32	2026-08-24 11:32	CMG	CMG270319C00032500	call	32.5000	2027-03-19	8.2200	8.0000	8.4000	38.0450	41100.00	41100.00	0.00	50	5	51	390	0.130769230769231	0.420876506095135	0.420876506095135	false	false	false	true
a2ce45f1-4dba-4905-ad3e-4e80ec96d284	2026-08-24 10:57	2026-08-24 10:57	2026-08-24 10:57	CMG	CMG260828P00040000	put	40.0000	2026-08-28	2.2000	2.0700	2.2700	37.8650	15400.00	15400.00	0.00	70	6	128	1	128	0.41049587671548	0.41049587671548	false	false	false	true
d4719390-ee5d-4863-aaec-c73b505f348a	2026-08-24 10:57	2026-08-24 10:57	2026-08-24 10:57	CMG	CMG260828P00040000	put	40.0000	2026-08-28	2.2000	2.0700	2.6100	37.8700	12760.00	3080.00	9680.00	58	5	58	1	58	0.416533480932773	0.416533480932773	true	false	false	true
7118ef5d-205f-488a-abdb-a3607cd264ee	2026-08-24 10:40	2026-08-24 10:40	2026-08-24 10:40	CMG	CMG261218C00040000	call	40.0000	2026-12-18	2.6400	2.4700	2.6500	37.6250	11880.00	11880.00	0.00	45	6	164	3809	0.043055920189026	0.404584575168219	0.404584575168219	false	false	false	true
84ab6a18-4912-427c-9e0a-bd648244e879	2026-08-24 10:37	2026-08-24 10:37	2026-08-24 10:37	CMG	CMG260918C00040000	call	40.0000	2026-09-18	0.5900	0.5900	0.6200	37.6200	11800.00	0.00	11800.00	200	5	2138	33263	0.0642756215614948	0.359353981053405	0.359353981053405	false	false	false	true
c81c1164-150f-441b-a96a-ea72c09ee10d	2026-08-24 10:10	2026-08-24 10:10	2026-08-24 10:10	CMG	CMG260918C00040000	call	40.0000	2026-09-18	0.5300	0.5300	0.5500	37.3507	12349.00	0.00	12349.00	233	12	1464	33263	0.0440128671496858	0.362131074836181	0.363302287969339	true	false	false	true
3c1d4c39-5c9f-429c-86d7-f224b145e318	2026-08-24 10:10	2026-08-24 10:10	2026-08-24 10:10	CMG	CMG260918C00040000	call	40.0000	2026-09-18	0.5300	0.5300	0.5500	37.3700	12349.00	0.00	12349.00	233	8	1214	33263	0.0364970086883324	0.361721390853516	0.361721390853516	true	false	false	true