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 = DUK×

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

f8a36692-fe11-482f-8a38-c055632cca03	2026-09-25 14:35	2026-09-25 14:35	2026-09-25 14:35	DUK	DUK270115C00120000	call	120.0000	2027-01-15	2.1000	2.0000	2.3000	113.1600	12600.00	12390.00	210.00	60	16	68	867	0.0784313725490196	0.164899017883757	0.164899017883757	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Utilities	88379243577.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T18:38:37.498256Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
85083287-909f-4b6b-ba82-56766cc32d1a	2026-09-25 13:58	2026-09-25 13:57	2026-09-25 13:57	DUK	DUK261218P00115000	put	115.0000	2026-12-18	5.0000	5.0000	5.3000	113.1300	12000.00	0.00	12000.00	24	6	58	1204	0.0481727574750831	0.212471755378264	0.212471755378264	false	false	false	true
b89b0f89-5e00-44e0-b68b-0635f7b1b7fc	2026-09-25 12:45	2026-09-25 12:45	2026-09-25 12:45	DUK	DUK261120P00110000	put	110.0000	2026-11-20	2.2500	2.1500	2.2500	112.9800	29925.00	29925.00	0.00	133	34	151	91	1.65934065934066	0.219577009015655	0.219577009015655	false	false	false	true
a0b7d8b1-dbc7-43b4-91af-516a6e5a6fa7	2026-09-25 11:31	2026-09-25 11:31	2026-09-25 11:31	DUK	DUK261016C00110000	call	110.0000	2026-10-16	3.8500	3.8000	4.0000	112.0000	17710.00	0.00	13860.00	46	5	47	202	0.232673267326733	0.187451924439465	0.187451924439465	false	false	false	true
774bf053-e51d-4566-8fe6-d93116c88f3b	2026-09-25 10:58	2026-09-25 10:58	2026-09-25 10:58	DUK	DUK261218P00110000	put	110.0000	2026-12-18	2.8500	2.8000	2.8500	112.8950	35055.00	35055.00	0.00	123	29	152	1429	0.106368089573128	0.214948705367432	0.214948705367432	false	false	false	true
ea7cfbd7-5b4a-4756-9174-8b32beb49403	2026-09-24 12:58	2026-09-24 12:58	2026-09-24 12:58	DUK	DUK261218C00120000	call	120.0000	2026-12-18	1.8000	1.7500	1.8000	114.0000	12240.00	12240.00	0.00	68	17	78	1449	0.0538302277432712	0.16517401957982	0.16517401957982	false	false	false	true
883e8537-f518-4beb-a7fe-503560518685	2026-09-24 11:48	2026-09-24 11:48	2026-09-24 11:48	DUK	DUK261218P00110000	put	110.0000	2026-12-18	2.5000	2.4000	2.5000	113.8000	28250.00	28250.00	0.00	113	24	133	1383	0.0961677512653651	0.211105491218448	0.211105491218448	false	false	false	true
97b7d4ec-bce0-4fcb-b4c6-f88533c0011d	2026-09-24 11:17	2026-09-24 11:17	2026-09-24 11:17	DUK	DUK290119C00140000	call	140.0000	2029-01-19	5.1000	5.0000	6.0000	113.9800	10200.00	4080.00	6120.00	20	7	20	23	0.869565217391304	0.133117120270804	0.133117120270804	false	false	false	true
f33a5f68-514b-4c33-8aa7-647d3dd8f8e1	2026-09-23 14:04	2026-09-23 14:04	2026-09-23 14:04	DUK	DUK270319P00120000	put	120.0000	2027-03-19	8.4000	8.1000	8.7000	114.8308	34440.00	30240.00	4200.00	41	7	43	225	0.191111111111111	0.215773652159222	0.215773652159222	true	false	false	true
3fac037a-1c6e-4d43-a078-9990c1d645b1	2026-09-23 13:05	2026-09-23 13:05	2026-09-23 13:05	DUK	DUK261120P00115000	put	115.0000	2026-11-20	3.4000	3.2000	3.4000	114.9700	41140.00	41140.00	0.00	121	28	121	46	2.6304347826087	0.205615147194743	0.205615147194743	false	false	false	true
ebbd0bfb-b1bc-45d3-9224-0a6452e49fb1	2026-09-22 10:41	2026-09-22 10:41	2026-09-22 10:41	DUK	DUK261016C00120000	call	120.0000	2026-10-16	0.8000	0.7000	0.8000	116.8900	64000.00	64000.00	0.00	800	5	887	3879	0.22866718226347	0.155084128019524	0.155084128019524	false	false	false	true
48fbb768-8c45-47b8-ab98-b43a65c83d17	2026-09-22 10:37	2026-09-22 10:37	2026-09-22 10:37	DUK	DUK261218C00120000	call	120.0000	2026-12-18	2.7000	2.5000	2.7000	116.7650	22410.00	22410.00	0.00	83	20	104	1218	0.0853858784893268	0.158381790610724	0.158381790610724	false	false	false	true
36131f41-43e9-427b-b027-77982fed7611	2026-09-22 10:24	2026-09-22 10:24	2026-09-22 10:24	DUK	DUK261218C00125000	call	125.0000	2026-12-18	1.1000	1.0000	1.2000	116.0000	19030.00	2530.00	16500.00	173	11	178	977	0.182190378710338	0.153612266036367	0.153612266036367	false	false	false	true
cc93f526-59f6-4d44-8443-a932ea33aaad	2026-09-21 13:49	2026-09-21 13:49	2026-09-21 13:49	DUK	DUK270115C00120000	call	120.0000	2027-01-15	3.6000	3.5000	3.9000	117.2100	21600.00	18720.00	1080.00	60	17	115	783	0.146871008939974	0.157265619880873	0.157265619880873	false	false	false	true
a10715d2-1976-4073-9057-45ed30443c30	2026-09-21 11:52	2026-09-21 11:52	2026-09-21 11:52	DUK	DUK270416C00130000	call	130.0000	2027-04-16	2.1000	2.1000	2.3000	117.5400	13440.00	0.00	11340.00	64	9	65	491	0.132382892057026	0.150898224399891	0.150898224399891	false	false	false	true
0667c6b0-0ea5-4a64-97b6-7745a732f1fc	2026-09-15 13:06	2026-09-15 13:05	2026-09-15 13:05	DUK	DUK280121C00120000	call	120.0000	2028-01-21	10.1000	9.5000	10.5000	117.7900	77770.00	61610.00	0.00	77	5	136	342	0.39766081871345	0.153365265227725	0.153365265227725	false	false	false	true
f895e501-9d6a-4b01-82ac-d5200bcca3aa	2026-09-14 12:21	2026-09-14 12:21	2026-09-14 12:21	DUK	DUK270416C00130000	call	130.0000	2027-04-16	2.9000	2.4000	2.9000	118.8750	66670.00	66670.00	0.00	230	36	231	234	0.987179487179487	0.161052738725984	0.160904309999187	true	false	false	true
ce64ba69-158c-43b6-a30d-750d7eb9c820	2026-09-10 15:10	2026-09-10 15:10	2026-09-10 15:10	DUK	DUK270917P00125000	put	125.0000	2027-09-17	11.2000	10.9000	11.2000	119.6800	117600.00	117600.00	0.00	105	29	109	0	0	0.235155454652015	0.235155454652015	true	false	false	true
5546b910-5725-4a23-9056-fa322dead3c3	2026-08-26 12:50	2026-08-26 12:50	2026-08-26 12:50	DUK	DUK261016C00125000	call	125.0000	2026-10-16	2.2000	2.0000	2.2000	122.1100	109986.00	109986.00	0.00	500	43	535	2494	0.214514835605453	0.174600923547958	0.173689824567519	true	false	false	true
42b9f425-81e8-41d1-a345-5a3163a0ce21	2026-08-21 15:13	2026-08-21 15:13	2026-08-21 15:13	DUK	DUK260918P00120000	put	120.0000	2026-09-18	2.0000	1.8000	2.0000	120.1700	54590.00	54590.00	0.00	273	40	722	2779	0.259805685498381	0.169842699656593	0.169842699656593	false	false	false	true
7527bffa-ad53-4ebc-b99a-ce896b9973f1	2026-08-20 15:19	2026-08-20 15:19	2026-08-20 15:19	DUK	DUK280121C00125000	call	125.0000	2028-01-21	11.4000	10.8000	11.4000	123.1350	68400.00	68400.00	0.00	60	9	150	470	0.319148936170213	0.147645299197086	0.147645299197086	false	false	false	true