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 = RepeatedHits×ticker = CCI×

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

2a25fcc6-08b3-4cae-85fc-f79dba47b706	2026-09-22 10:42	2026-09-22 10:42	2026-09-22 10:42	CCI	CCI270917C00082500	call	82.5000	2027-09-17	4.9000	4.9000	5.5000	72.9800	10780.00	0.00	10780.00	22	6	25	446	0.0560538116591928	0.250397118947004	0.250397118947004	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	30790210120.00	2026-10-28	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T14:42:44.065275Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
323f80ed-fa8d-445c-8415-18f85b447acd	2026-09-17 13:23	2026-09-17 13:23	2026-09-17 13:23	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.7500	1.6500	1.7500	73.8001	17500.00	17500.00	0.00	100	12	409	16142	0.0253376285466485	0.296279101393698	0.296279101393698	false	false	false	true
e9095685-825f-4b72-8be4-f5e09da271c7	2026-09-17 10:34	2026-09-17 10:34	2026-09-17 10:34	CCI	CCI280121P00075000	put	75.0000	2028-01-21	11.8000	10.0000	11.8000	72.9750	35400.00	35400.00	0.00	30	5	30	350	0.0857142857142857	0.397428671100477	0.397428671100477	false	false	false	true
4b984ebb-ced1-4c94-b1eb-55e4326b76ee	2026-09-16 14:37	2026-09-16 14:36	2026-09-16 14:36	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.8500	1.8000	1.9000	74.3200	84175.00	83250.00	925.00	455	7	18639	544	34.2628676470588	0.292699545916264	0.292699545916264	true	false	false	true
2b41f137-59d2-4623-bcee-73333faa87f6	2026-09-16 11:31	2026-09-16 11:31	2026-09-16 11:31	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.8500	1.8000	1.9000	74.5200	86950.00	82325.00	1480.00	470	12	17385	544	31.9577205882353	0.288922257715278	0.288922257715278	false	false	false	true
5057f9df-2397-4808-a0f5-fbd7988d1664	2026-09-16 11:31	2026-09-16 11:30	2026-09-16 11:30	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.8500	1.8000	1.8500	74.5150	21275.00	21275.00	0.00	115	7	16912	544	31.0882352941176	0.289016727115569	0.289016727115569	false	false	false	true
4c0aa07c-d428-44de-853a-92fcaa465896	2026-09-16 11:14	2026-09-16 11:14	2026-09-16 11:14	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.7500	1.7000	1.8000	74.3600	17675.00	350.00	17325.00	101	6	15514	544	28.5183823529412	0.284762281964675	0.284762281964675	false	false	false	true
f6fd7c69-ea79-43d0-ae7f-1b0f0c40523c	2026-09-16 11:13	2026-09-16 11:13	2026-09-16 11:13	CCI	CCI270115C00085000	call	85.0000	2027-01-15	1.9100	1.3000	1.9500	74.3450	2865000.00	2865000.00	0.00	15000	2	15000	544	27.5735294117647	0.295786826110548	0.295786826110548	false	true	false	true
91739b7b-de77-4580-af1a-c19914839947	2026-09-14 11:19	2026-09-14 11:19	2026-09-14 11:19	CCI	CCI260918C00075000	call	75.0000	2026-09-18	0.4000	0.3000	0.4000	74.3000	10040.00	10040.00	0.00	251	19	403	1869	0.215623327982879	0.219124209335838	0.219124209335838	false	false	false	true
60c2ad6f-6b71-40a5-9407-8d0b5c835f79	2026-09-09 15:24	2026-09-09 15:24	2026-09-09 15:24	CCI	CCI260918C00075000	call	75.0000	2026-09-18	1.2500	1.2000	1.7500	75.2700	53875.00	0.00	53875.00	431	5	3498	5257	0.665398516264029	0.227701820434381	0.227701820434381	false	false	false	true
e834f1da-aa55-4839-922b-856bdad17caa	2026-09-09 15:20	2026-09-09 15:19	2026-09-09 15:19	CCI	CCI261016P00070000	put	70.0000	2026-10-16	1.2000	1.2000	1.3500	75.1950	51360.00	0.00	51360.00	428	21	477	637	0.748822605965463	0.350632631435583	0.350632631435583	false	false	false	true
d7ecc13d-319d-4c74-a995-5b773d139e0b	2026-08-28 15:06	2026-08-28 15:05	2026-08-28 15:05	CCI	CCI260918C00075000	call	75.0000	2026-09-18	2.3000	2.1000	2.3000	75.8600	230000.00	69000.00	0.00	1000	6	2004	153	13.0980392156863	0.2413824594858	0.2413824594858	false	false	false	true
2341aefd-abc2-4b0c-9e69-8dbd6a2324c3	2026-08-28 10:59	2026-08-28 10:59	2026-08-28 10:59	CCI	CCI270917P00075000	put	75.0000	2027-09-17	9.0000	9.0000	10.7000	76.2100	315000.00	0.00	241200.00	350	11	350	0	0	0.36807793900445	0.36807793900445	false	false	false	true
6407d5d4-2c4f-439f-ac5d-62c2a0334dd2	2026-08-24 12:32	2026-08-24 12:32	2026-08-24 12:32	CCI	CCI270617P00075000	put	75.0000	2027-06-17	7.8000	7.7000	8.5000	76.6900	28080.00	0.00	26520.00	36	19	105	20	5.25	0.363486324213556	0.363486324213556	true	false	false	true
2651164b-43b4-4358-ade5-5d86c03f0d03	2026-08-19 15:41	2026-08-19 15:41	2026-08-19 15:41	CCI	CCI261016P00072500	put	72.5000	2026-10-16	2.6500	2.6500	2.9000	74.7800	30750.00	0.00	30750.00	116	21	119	126	0.944444444444444	0.330689021055191	0.330689021055191	false	false	false	true
b91b4fdb-c2bb-4c7e-a621-7fd00a3be655	2026-08-18 15:31	2026-08-18 15:31	2026-08-18 15:31	CCI	CCI270115C00075000	call	75.0000	2027-01-15	5.3000	5.0000	5.7000	74.3250	24380.00	19080.00	5300.00	46	8	59	122	0.483606557377049	0.265852204084057	0.265852204084057	false	false	false	true
82515ab6-4b88-4859-b7e7-d7ebd2027eec	2026-08-18 15:31	2026-08-18 15:31	2026-08-18 15:31	CCI	CCI270115C00077500	call	77.5000	2027-01-15	4.2000	4.0000	4.7000	74.3250	19320.00	15120.00	4200.00	46	6	62	192	0.322916666666667	0.26550437897109	0.26550437897109	false	false	false	true
d8f801c1-7fd2-42ca-aee2-48ee4fb2d01c	2026-08-18 15:05	2026-08-18 15:05	2026-08-18 15:05	CCI	CCI270115C00082500	call	82.5000	2027-01-15	2.5500	2.5000	2.6000	74.3500	18361.00	255.00	18106.00	72	27	75	149	0.503355704697987	0.265679524551559	0.265679524551559	false	false	false	true