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:source = uw_flow_alerts×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

ad464d2e-caf3-475d-9784-4f6d21c451be	2026-09-22 14:25	2026-09-22 14:25	2026-09-22 14:25	CCI	CCI261120P00070000	put	70.0000	2026-11-20	2.1500	2.0500	2.1500	72.9000	44930.00	44930.00	0.00	209	35	210	6	35	0.31392791606036	0.31392791606036	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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-22T18:29:55.439380Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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
f5b3427f-a9e0-49a5-a878-1d55724c5fcf	2026-09-18 14:08	2026-09-18 14:08	2026-09-18 14:08	CCI	CCI261218P00080000	put	80.0000	2026-12-18	8.6400	8.6000	8.7000	73.7000	21591.00	0.00	17266.00	25	6	150	350	0.428571428571429	0.360023608277637	0.360023608277637	false	false	false	true
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
192249c4-1ffe-4290-914e-f0e81fc54ee5	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
ced1072c-4624-4292-a74e-2ab21fcc5e37	2026-09-09 15:25	2026-09-09 15:24	2026-09-09 15:24	CCI	CCI260918C00075000	call	75.0000	2026-09-18	1.2000	1.2000	1.6500	75.2500	114364.00	0.00	114364.00	953	7	4553	5257	0.866083317481453	0.220132977685733	0.219374034972861	false	false	false	true
6de8ef10-6f0b-48da-a0ba-6686ed4401ad	2026-09-09 15:25	2026-09-09 15:24	2026-09-09 15:24	CCI	CCI260918C00075000	call	75.0000	2026-09-18	1.2200	1.2000	1.6500	75.2100	14000.00	0.00	14000.00	115	7	4668	5257	0.887958911926955	0.220563360371519	0.234797228431762	true	false	false	true
eafaa9b7-db10-434d-b1af-21e1f8e5e8fa	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.5500	75.3800	110290.00	71640.00	38525.00	881	30	3067	5257	0.583412592733498	0.214287248986136	0.214287248986136	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
118425b1-02ce-4052-8c8e-54ea25cebc39	2026-08-28 13:58	2026-08-28 13:58	2026-08-28 13:58	CCI	CCI260918C00075000	call	75.0000	2026-09-18	2.0300	1.8000	2.0500	75.4700	203150.00	203150.00	0.00	1000	10	1003	153	6.55555555555556	0.246335063858831	0.22714916783301	false	false	false	true
25658256-5e38-4e16-82f0-4b709a68eca1	2026-08-28 11:04	2026-08-28 11:04	2026-08-28 11:04	CCI	CCI270917P00075000	put	75.0000	2027-09-17	8.9000	8.8000	10.7000	76.1800	3651670.00	0.00	3651670.00	4103	1	4512	0	0	0.364303401673533	0.364303401673533	false	true	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	false
3d845f3c-c014-4084-a24d-ee47238da2fe	2026-08-27 09:55	2026-08-27 09:55	2026-08-27 09:55	CCI	CCI260918P00085000	put	85.0000	2026-09-18	10.9600	9.9000	12.1000	75.1200	16444.00	0.00	16444.00	15	7	15	266	0.056390977443609	0.583725089228049	0.583725089228049	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	false
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