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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = CMI×

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

c3bfcea4-e5a5-4135-b45a-02d5a07b4d26	2026-10-02 12:01	2026-10-02 12:01	2026-10-02 12:01	CMI	CMI261016C00480000	call	480.0000	2026-10-16	49.6000	49.6000	49.9000	528.3500	64480.00	0.00	64480.00	13	6	13	39	0.333333333333333	0.290234478103778	0.290234478103778	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	72730901772.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T16:01:58.422047Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
55db6dfe-1348-4719-9092-3892267f4bae	2026-10-02 12:01	2026-10-02 12:01	2026-10-02 12:01	CMI	CMI261016C00520000	call	520.0000	2026-10-16	16.7000	15.7000	16.7000	528.2900	177020.00	177020.00	0.00	106	7	108	146	0.73972602739726	0.282208131645781	0.28318537401626	false	false	false	true
3c253f2c-d7c9-45bc-a975-cbc3bf7df317	2026-10-02 12:01	2026-10-02 12:01	2026-10-02 12:01	CMI	CMI261218C00460000	call	460.0000	2026-12-18	79.5700	79.3000	79.6000	528.3500	843400.00	79600.00	95160.00	106	23	106	65	1.63076923076923	0.337037231429084	0.337037231429084	false	false	false	true
2a76edc7-8b4e-4355-8dbb-7e8110d3a46b	2026-10-02 12:01	2026-10-02 12:01	2026-10-02 12:01	CMI	CMI261016C00540000	call	540.0000	2026-10-16	7.3000	6.6000	9.3000	528.2900	116800.00	94900.00	21900.00	160	6	233	159	1.46540880503145	0.286781319173173	0.286781319173173	false	false	false	true
d0ebf096-78fe-451b-9fcf-c7df96cb99a0	2026-10-02 11:03	2026-10-02 11:03	2026-10-02 11:03	CMI	CMI261016C00540000	call	540.0000	2026-10-16	7.1000	6.3000	7.1000	527.0000	39760.00	25560.00	0.00	56	10	62	159	0.389937106918239	0.291001582113481	0.291001582113481	false	false	false	true
10560eeb-f4a8-4e9c-a678-bb1337bded98	2026-10-01 14:37	2026-10-01 14:37	2026-10-01 14:37	CMI	CMI261016C00520000	call	520.0000	2026-10-16	10.5000	9.7000	10.9000	514.1750	131250.00	130200.00	1050.00	125	22	130	17	7.64705882352941	0.307120527332575	0.307120527332575	false	false	false	true
ee722e29-deca-4189-a284-a6137ee256ca	2026-10-01 10:03	2026-10-01 10:03	2026-10-01 10:03	CMI	CMI261120P00520000	put	520.0000	2026-11-20	32.0000	30.0000	32.0000	512.6033	16000.00	9600.00	0.00	5	5	5	23	0.217391304347826	0.391394964802564	0.391394964802564	false	false	false	true
ad3bb323-6ee6-4eb9-b7a7-a455a1ea8a6e	2026-09-28 13:42	2026-09-28 13:41	2026-09-28 13:41	CMI	CMI261120C00560000	call	560.0000	2026-11-20	15.3000	13.8000	15.3000	518.3100	32130.00	32130.00	0.00	21	6	24	8	3	0.376502190970001	0.376502190970001	false	false	false	true
3d17523d-0089-4fd1-823b-03b3aa6bd578	2026-09-23 11:25	2026-09-23 11:25	2026-09-23 11:25	CMI	CMI261218C00630000	call	630.0000	2026-12-18	7.4000	7.2000	7.4000	522.7500	18500.00	18500.00	0.00	25	12	37	40	0.925	0.349096538356853	0.349096538356853	false	false	false	true
19118ac8-5710-406f-ada4-793805b3b868	2026-09-21 13:30	2026-09-21 13:30	2026-09-21 13:30	CMI	CMI261016P00530000	put	530.0000	2026-10-16	14.9000	14.5000	15.0000	534.9050	141550.00	141550.00	0.00	95	30	98	688	0.142441860465116	0.322403473190395	0.322403473190395	false	false	false	true
699dc146-110e-4e91-94b9-075a2862bfaa	2026-09-21 09:30	2026-09-21 09:30	2026-09-21 09:30	CMI	CMI261016C00560000	call	560.0000	2026-10-16	11.6900	8.0000	11.9000	536.9622	11690.00	10710.00	980.00	10	5	10	45	0.222222222222222	0.366040716404239	0.366040716404239	false	false	false	true
6bf5844b-47b4-4bfe-a4ca-355033b61c6c	2026-09-18 13:06	2026-09-18 13:06	2026-09-18 13:06	CMI	CMI261218P00490000	put	490.0000	2026-12-18	20.7900	20.7000	20.8000	526.7650	74829.00	64479.00	10350.00	36	12	38	24	1.58333333333333	0.378076032970956	0.378076032970956	false	false	false	true
c11b9a84-c55c-4cc3-97db-59f9de0ac349	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	CMI	CMI260918P00580000	put	580.0000	2026-09-18	42.0000	42.0000	45.1000	536.7000	105000.00	0.00	105000.00	25	11	28	112	0.25	0.617572332507337	0.617572332507337	false	false	false	true
2275d424-3a00-4c61-971c-22ed86f35739	2026-09-08 13:30	2026-09-08 13:30	2026-09-08 13:30	CMI	CMI261016C00580000	call	580.0000	2026-10-16	19.7300	18.3000	19.8000	565.4800	57220.00	33580.00	23640.00	29	8	31	83	0.373493975903614	0.344951531332765	0.346338266486322	false	false	false	true
76a1950f-c549-4688-a395-6f557f5b25bb	2026-09-04 10:39	2026-09-04 10:39	2026-09-04 10:39	CMI	CMI260918C00570000	call	570.0000	2026-09-18	9.4000	8.7000	9.7000	558.3700	206799.00	201159.00	940.00	220	40	228	118	1.93220338983051	0.321219219597589	0.321219219597589	false	false	false	true
5d2d34fa-384f-4513-8fe5-24930732f8e1	2026-09-02 14:38	2026-09-02 14:38	2026-09-02 14:38	CMI	CMI261016C00480000	call	480.0000	2026-10-16	75.4000	75.4000	78.0000	549.9950	294060.00	0.00	294060.00	39	16	39	0	0	0.327007070083811	0.327007070083811	false	false	false	true
ff2b3cad-edfb-47dd-80b4-a246dacc8aa0	2026-09-01 10:27	2026-09-01 10:26	2026-09-01 10:26	CMI	CMI261218C00640000	call	640.0000	2026-12-18	16.4000	15.5000	16.4000	554.8950	121350.00	119720.00	0.00	74	28	74	30	2.46666666666667	0.349940453009369	0.348949788688716	false	false	false	true
65b970bf-878f-4845-8ae1-d7816201fadb	2026-09-01 09:43	2026-09-01 09:43	2026-09-01 09:43	CMI	CMI260918P00550000	put	550.0000	2026-09-18	14.4000	12.2000	14.4000	551.8900	70560.00	70560.00	0.00	49	6	50	483	0.10351966873706	0.333376610696849	0.333376610696849	false	false	false	true
bb7ebdcc-8ce1-48fc-937b-50f3126c6fd8	2026-08-24 11:19	2026-08-24 11:19	2026-08-24 11:19	CMI	CMI261016P00500000	put	500.0000	2026-10-16	6.6000	5.4000	6.6000	569.6700	50160.00	50160.00	0.00	76	31	85	29	2.93103448275862	0.368468036252812	0.368468036252812	false	false	false	true
67a16a7c-a803-4c6a-8957-4559da9cb08f	2026-08-21 11:24	2026-08-21 11:24	2026-08-21 11:24	CMI	CMI260821P00620000	put	620.0000	2026-08-21	27.3200	25.9000	29.1000	592.6400	336036.00	0.00	0.00	123	5	125	221	0.565610859728507	1.80560595933594	1.80560595933594	false	false	false	true
2adf8a56-fc65-4624-96a5-5afe0e1f02e8	2026-08-21 11:24	2026-08-21 11:24	2026-08-21 11:24	CMI	CMI260918P00610000	put	610.0000	2026-09-18	31.2200	29.5000	32.6000	592.6400	384006.00	0.00	0.00	123	5	124	311	0.398713826366559	0.34044509106933	0.34044509106933	false	false	false	true
e21714bd-dac0-4d97-8bf5-66a62eac524c	2026-08-21 10:46	2026-08-21 10:46	2026-08-21 10:46	CMI	CMI261218C00540000	call	540.0000	2026-12-18	82.2900	79.3000	82.3000	591.1500	460850.00	460850.00	0.00	56	23	56	7	8	0.374737960590529	0.374737960590529	false	false	false	true
0765a1be-c9c3-4729-93f8-9d7de960836b	2026-08-17 11:37	2026-08-17 11:37	2026-08-17 11:37	CMI	CMI261218P00630000	put	630.0000	2026-12-18	46.8000	46.8000	49.8000	638.9100	351000.00	0.00	351000.00	75	29	75	221	0.339366515837104	0.377509107575146	0.377509107575146	false	false	false	true