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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = CF×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	expirydate	pricenumeric

c1afc98d-98a6-4328-8fae-276ac7c8738d	2026-09-04 11:07	2026-09-04 11:07	2026-09-04 11:07	CF	CF280121C00120000	call	120.0000	2028-01-21	37.0000	36.3000	37.0000	134.1900	55500.00	55500.00	0.00	15	5	50	64	0.78125	0.437299909009765	0.437299909009765	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	19861616181.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e23147bb-8d1c-4938-aa6b-9c47d1a0161b	2026-09-04 11:34	2026-09-04 11:34	2026-09-04 11:34	CF	CF261016C00130000	call	130.0000	2026-10-16	10.6000	10.4000	10.8000	134.3400	15900.00	14840.00	0.00	15	15	27	165	0.163636363636364	0.442849612591572	0.442849612591572	false	false	false	true	false
bda0503a-df96-4745-bf54-cb1459249c47	2026-09-04 14:09	2026-09-04 14:09	2026-09-04 14:09	CF	CF280121C00120000	call	120.0000	2028-01-21	37.0000	36.8000	37.6000	134.6900	22200.00	0.00	22200.00	6	6	252	64	3.9375	0.430440554017783	0.430440554017783	false	false	false	true	false
c62f8330-5474-45cc-9d15-52049c9e1082	2026-09-04 14:20	2026-09-04 14:20	2026-09-04 14:20	CF	CF261016C00140000	call	140.0000	2026-10-16	5.8000	5.8000	5.9000	134.3650	16820.00	0.00	16820.00	29	6	56	518	0.108108108108108	0.435434812665781	0.435434812665781	false	false	false	true	false
6b9986b3-72ce-4ee3-a234-bd2cf154ef2c	2026-09-04 14:20	2026-09-04 14:20	2026-09-04 14:20	CF	CF261016C00140000	call	140.0000	2026-10-16	6.0000	5.8000	6.0000	134.4100	30586.00	30586.00	0.00	51	19	109	518	0.21042471042471	0.439929534136304	0.445503762142908	false	false	false	true	false
2d150e52-0009-4837-a446-58f618adf2eb	2026-09-04 14:21	2026-09-04 14:20	2026-09-04 14:20	CF	CF261016C00140000	call	140.0000	2026-10-16	5.9900	5.8000	6.1000	134.4100	31770.00	31770.00	0.00	53	8	162	518	0.312741312741313	0.439929534136304	0.445503762142908	false	false	false	true	false
059f6a98-d80a-40b0-a712-2d9b633d7ce3	2026-09-04 14:21	2026-09-04 14:20	2026-09-04 14:20	CF	CF261016C00140000	call	140.0000	2026-10-16	6.0800	5.8000	6.1000	134.4100	17010.00	17010.00	0.00	28	7	227	518	0.438223938223938	0.445503762142908	0.451074377351778	false	false	false	true	false
c8f04829-803f-44b0-8c7f-279c2cb68dab	2026-09-04 15:50	2026-09-04 15:49	2026-09-04 15:49	CF	CF280121C00120000	call	120.0000	2028-01-21	36.6700	36.3000	37.1000	133.6000	645452.00	0.00	80272.00	176	6	520	64	8.125	0.435324225051321	0.435324225051321	false	false	false	true	false
737477c4-3abe-4eee-a1b0-b750dafab1f8	2026-09-04 15:51	2026-09-04 15:51	2026-09-04 15:51	CF	CF280121C00120000	call	120.0000	2028-01-21	36.2800	35.0000	36.4000	133.3450	21765.00	14505.00	3630.00	6	5	536	64	8.375	0.435578385270258	0.43463250846165	true	false	false	true	false
cb4feddb-55ea-499e-90d3-c361c06afee6	2026-09-04 15:53	2026-09-04 15:53	2026-09-04 15:53	CF	CF260911C00140000	call	140.0000	2026-09-11	1.0000	0.8500	1.1500	133.5900	44668.00	44468.00	200.00	447	31	543	243	2.23456790123457	0.425117688206129	0.425930212346896	false	false	false	true	false
68986fbf-94b3-4a96-b701-9a9f31208842	2026-09-04 15:53	2026-09-04 15:53	2026-09-04 15:53	CF	CF260911C00137000	call	137.0000	2026-09-11	1.7000	1.4000	1.7000	133.6100	13090.00	13090.00	0.00	77	21	140	3	46.6666666666667	0.410685537178269	0.410685537178269	true	false	false	true	false
2b15121c-2fec-4398-9f69-409e3f5f979b	2026-09-04 15:53	2026-09-04 15:53	2026-09-04 15:53	CF	CF260911C00136000	call	136.0000	2026-09-11	2.0500	1.7500	2.0500	133.6100	15986.00	15986.00	0.00	78	17	315	5	63	0.41104135168916	0.41104135168916	false	false	false	true	false
f14002a3-d7d6-4698-a60c-e675f3ec1def	2026-09-08 10:15	2026-09-08 10:15	2026-09-08 10:15	CF	CF270115C00140000	call	140.0000	2027-01-15	13.8500	13.3000	14.3000	135.9750	27700.00	27700.00	0.00	20	6	22	2059	0.0106847984458475	0.457857748041465	0.457857748041465	false	false	false	true	false
4af7e281-9d27-4b86-bc90-4e3afe9a821b	2026-09-09 12:20	2026-09-09 12:20	2026-09-09 12:20	CF	CF270319P00135000	put	135.0000	2027-03-19	15.5000	15.3500	16.4000	138.3000	55800.00	0.00	55800.00	36	10	51	86	0.593023255813954	0.474874165384817	0.474874165384817	false	false	false	true	false
fd830020-04c0-411f-962e-86378b631f26	2026-09-09 12:23	2026-09-09 12:23	2026-09-09 12:23	CF	CF261016C00145000	call	145.0000	2026-10-16	5.8000	5.5000	5.9000	138.2800	37700.00	37120.00	580.00	65	20	154	601	0.256239600665557	0.475224925565236	0.475224925565236	false	false	false	true	false
75e6492e-6f90-49d4-a1ba-b3f1164d7adb	2026-09-09 12:24	2026-09-09 12:24	2026-09-09 12:24	CF	CF261016C00145000	call	145.0000	2026-10-16	5.8000	5.6000	6.0000	138.3600	24360.00	10440.00	9280.00	42	11	231	601	0.384359400998336	0.473285426062116	0.473285426062116	false	false	false	true	false
18e82d92-2842-4d90-aebd-f261bea8ce36	2026-09-09 12:30	2026-09-09 12:30	2026-09-09 12:30	CF	CF261016C00145000	call	145.0000	2026-10-16	6.3000	6.3000	6.4000	139.1230	54180.00	0.00	27090.00	86	23	334	601	0.555740432612313	0.483408411833489	0.483408411833489	false	false	false	true	false
978a1d3c-5615-4e00-8fe7-21845b0e683e	2026-09-09 12:40	2026-09-09 12:40	2026-09-09 12:40	CF	CF260911P00150000	put	150.0000	2026-09-11	11.5000	10.1000	11.5000	138.5700	11500.00	11500.00	0.00	10	9	20	0	0	0.60585739655371	0.60585739655371	false	false	false	true	false
60b49b3d-9015-4e32-b643-a87f6fd952a5	2026-09-10 09:52	2026-09-10 09:52	2026-09-10 09:52	CF	CF261120C00140000	call	140.0000	2026-11-20	11.1000	10.8000	11.2000	138.5400	17760.00	16650.00	1110.00	16	8	51	296	0.172297297297297	0.464702596060804	0.464702596060804	true	false	false	true	false
e6788e85-e90d-42a6-9428-5195cb757db3	2026-09-10 11:51	2026-09-10 11:50	2026-09-10 11:50	CF	CF270115P00125000	put	125.0000	2027-01-15	8.3000	8.2000	8.6000	137.1900	44820.00	0.00	43990.00	54	18	54	177	0.305084745762712	0.464842628440597	0.464842628440597	false	false	false	true	false
956198fb-df3f-4430-924c-733856196bd7	2026-09-10 14:21	2026-09-10 14:21	2026-09-10 14:21	CF	CF270115P00135000	put	135.0000	2027-01-15	13.6000	13.6000	13.9000	135.2800	87040.00	0.00	87040.00	64	15	64	52	1.23076923076923	0.465349959792239	0.465349959792239	false	false	false	true	false
0f97b8d4-3808-4dbb-9434-b8396774c2fd	2026-09-10 14:21	2026-09-10 14:21	2026-09-10 14:21	CF	CF270115P00140000	put	140.0000	2027-01-15	16.4000	16.4000	16.7000	135.2800	191880.00	0.00	191880.00	117	24	117	13	9	0.466911570788832	0.466911570788832	false	false	false	true	false
da563488-3d8b-4f57-bbf0-81982264d9b2	2026-09-11 12:08	2026-09-11 12:07	2026-09-11 12:07	CF	CF261016C00135000	call	135.0000	2026-10-16	7.4500	7.3000	7.7000	134.3650	18625.00	7450.00	3725.00	25	5	33	393	0.083969465648855	0.452505927048579	0.452505927048579	false	false	false	true	false
9e973e41-c80f-493c-b006-bd3b6b7c097e	2026-09-15 12:24	2026-09-15 12:24	2026-09-15 12:24	CF	CF261218P00150000	put	150.0000	2026-12-18	21.4000	21.1500	22.0000	134.0000	10700.00	0.00	10700.00	5	5	5	0	0	0.476500756589301	0.477997762589927	false	false	false	true	false
a29b8dcd-1951-4a98-bc68-718a7b65df98	2026-09-15 14:23	2026-09-15 14:23	2026-09-15 14:23	CF	CF260918C00145000	call	145.0000	2026-09-18	0.4800	0.3000	0.9500	136.5500	48014.00	150.00	47864.00	1000	11	1008	1499	0.672448298865911	0.590119470049117	0.590119470049117	true	false	false	true	false
46e1c19f-1092-45c3-936c-957cffa6333e	2026-09-15 14:26	2026-09-15 14:26	2026-09-15 14:26	CF	CF260918P00137000	put	137.0000	2026-09-18	2.7500	2.4000	2.7500	136.7600	36566.00	36566.00	0.00	133	32	143	39	3.66666666666667	0.535628344498438	0.535628344498438	false	false	false	true	false
052b3d8b-795c-409b-9494-ea8f8e93d905	2026-09-16 15:02	2026-09-16 15:02	2026-09-16 15:02	CF	CF261016C00140000	call	140.0000	2026-10-16	4.3000	4.3000	4.4000	133.1250	10750.00	0.00	10750.00	25	6	124	1151	0.107732406602954	0.452592639160351	0.452592639160351	true	false	false	true	false
d331bf14-0182-4c61-a3a2-9df35d3ff53d	2026-09-16 15:08	2026-09-16 15:08	2026-09-16 15:08	CF	CF261016C00140000	call	140.0000	2026-10-16	4.3000	4.3000	4.4000	133.0550	16340.00	0.00	16340.00	38	5	220	1151	0.191138140747176	0.454431299644938	0.454431299644938	false	false	false	true	false
baf44199-7d5e-4f5c-a940-6f50a9b9df22	2026-09-17 10:31	2026-09-17 10:30	2026-09-17 10:30	CF	CF261016P00125000	put	125.0000	2026-10-16	2.8500	2.7500	3.1000	133.8300	22800.00	7980.00	6555.00	80	55	80	1161	0.0689061154177433	0.441799592818256	0.443511459495694	false	false	false	true	false
c9c66eeb-dab2-4beb-8287-19aec84c0cee	2026-09-18 14:27	2026-09-18 14:27	2026-09-18 14:27	CF	CF260925P00130000	put	130.0000	2026-09-25	3.4000	2.9500	3.7000	129.2500	34000.00	32300.00	1700.00	100	8	126	20	6.3	0.427998158112259	0.427998158112259	false	false	false	true	false
2dc5bc80-86cf-4e8e-903b-fc3c0eabcc9c	2026-09-18 15:46	2026-09-18 15:46	2026-09-18 15:46	CF	CF270115C00150000	call	150.0000	2027-01-15	5.8600	5.6000	6.0000	127.7150	20514.00	20514.00	0.00	35	8	43	889	0.0483689538807649	0.436535540604645	0.436535540604645	false	false	false	true	false
58ddecbf-3de8-4249-9add-191b16e928e1	2026-09-21 10:22	2026-09-21 10:22	2026-09-21 10:22	CF	CF261218C00160000	call	160.0000	2026-12-18	2.2500	2.2500	2.5500	125.0000	17550.00	0.00	17550.00	78	18	78	245	0.318367346938775	0.443994395083211	0.443994395083211	false	false	false	true	false
4193fa37-1036-4bd4-8cfa-93a803ca5a34	2026-09-21 10:45	2026-09-21 10:45	2026-09-21 10:45	CF	CF261120P00110000	put	110.0000	2026-11-20	2.9500	2.8000	2.9500	125.4600	29500.00	29500.00	0.00	100	10	415	98	4.23469387755102	0.463453394989414	0.463453394989414	true	false	false	true	false
6f4f238d-548c-411d-9589-75d2ff732383	2026-09-21 10:45	2026-09-21 10:45	2026-09-21 10:45	CF	CF261120P00110000	put	110.0000	2026-11-20	2.9000	2.8000	2.9000	125.4350	14500.00	14500.00	0.00	50	5	465	98	4.74489795918367	0.459617603579554	0.459617603579554	false	false	false	true	false
97501b76-b9cc-4546-b9dc-0703fe018621	2026-09-21 11:20	2026-09-21 11:20	2026-09-21 11:20	CF	CF261120P00110000	put	110.0000	2026-11-20	3.0000	2.9000	3.0000	125.4000	23700.00	23700.00	0.00	79	9	544	98	5.55102040816327	0.466071612792482	0.466071612792482	true	false	false	true	false
412b7b04-7137-4280-b370-e27e67a537a7	2026-09-21 11:46	2026-09-21 11:46	2026-09-21 11:46	CF	CF261120P00110000	put	110.0000	2026-11-20	2.9500	2.9500	3.7000	125.2000	26550.00	0.00	26550.00	90	63	770	98	7.85714285714286	0.459767450178193	0.459767450178193	false	false	false	true	false
2b92577e-ad45-4b1c-a0cb-22aab335b2ad	2026-09-21 12:20	2026-09-21 12:20	2026-09-21 12:20	CF	CF261120P00110000	put	110.0000	2026-11-20	3.0000	2.9500	3.0000	125.0000	45000.00	45000.00	0.00	150	59	920	98	9.38775510204082	0.462085668166637	0.463298161537708	true	false	false	true	false
5e97e9ac-37c6-4c25-b6d5-5dac03f8cd95	2026-09-21 12:45	2026-09-21 12:45	2026-09-21 12:45	CF	CF261120P00110000	put	110.0000	2026-11-20	3.0200	3.0000	3.4000	124.8800	36798.00	0.00	36798.00	122	31	1070	98	10.9183673469388	0.464822628119441	0.458650388332119	false	false	false	true	false
2ee3c981-d5a9-4628-a3ef-d16908093329	2026-09-21 13:27	2026-09-21 13:26	2026-09-21 13:26	CF	CF261120P00110000	put	110.0000	2026-11-20	3.0000	2.9000	3.0000	125.0101	45000.00	45000.00	0.00	150	17	1220	98	12.4489795918367	0.460514762307654	0.460514762307654	true	false	false	true	false
42073f8a-cffd-40f8-9617-04d1a1efb430	2026-09-21 14:15	2026-09-21 14:15	2026-09-21 14:15	CF	CF261120P00110000	put	110.0000	2026-11-20	3.2000	3.1000	3.2000	124.5300	26240.00	26240.00	0.00	82	9	1303	98	13.2959183673469	0.467218947390624	0.467218947390624	false	false	false	true	false
fabc8434-e01c-483e-86b0-3c28dee2da56	2026-09-21 14:15	2026-09-21 14:15	2026-09-21 14:15	CF	CF261120P00110000	put	110.0000	2026-11-20	3.1000	3.0000	3.1000	124.6650	20770.00	20770.00	0.00	67	7	1370	98	13.9795918367347	0.462397418257183	0.462397418257183	false	false	false	true	false
526ccb18-eda4-4703-b6bd-7201d6012793	2026-09-21 14:48	2026-09-21 14:48	2026-09-21 14:48	CF	CF261120P00110000	put	110.0000	2026-11-20	3.2000	3.1000	3.2000	124.0000	38400.00	38400.00	0.00	120	15	1520	98	15.5102040816327	0.463337064449765	0.463337064449765	true	false	false	true	false
90673d1d-32d0-4d5c-807e-df8b9230cc80	2026-09-21 15:15	2026-09-21 15:15	2026-09-21 15:15	CF	CF261120P00110000	put	110.0000	2026-11-20	3.4000	3.4000	4.0000	123.1700	48620.00	0.00	48620.00	143	39	1670	98	17.0408163265306	0.460288206707574	0.460288206707574	false	false	false	true	false
14952b79-bd35-4c06-9011-fcca51517ceb	2026-09-21 15:43	2026-09-21 15:43	2026-09-21 15:43	CF	CF261120P00110000	put	110.0000	2026-11-20	3.5000	3.4000	3.5000	122.9100	78050.00	78050.00	0.00	223	13	1894	98	19.3265306122449	0.461636474422731	0.462866281156389	true	false	false	true	false