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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Utilities	89018599375.00	2026-11-05	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T16:59:44.374364Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
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
c953273f-deb2-4acb-ab33-e76228838911	2026-09-24 10:10	2026-09-24 10:09	2026-09-24 10:09	DUK	DUK280121P00110000	put	110.0000	2028-01-21	6.9700	5.9000	7.5000	114.9300	34847.00	34847.00	0.00	50	10	50	500	0.1	0.238421640300501	0.238421640300501	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
57b17528-4e7e-4995-a1a8-0b65922ca0fb	2026-09-21 11:37	2026-09-21 11:37	2026-09-21 11:37	DUK	DUK280121C00120000	call	120.0000	2028-01-21	9.7000	8.8000	10.1000	117.0000	14551.00	14551.00	0.00	15	11	34	474	0.0717299578059072	0.131864998741423	0.131864998741423	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
98c0f29d-eb3d-41c9-a94e-465f3c419622	2026-08-27 10:49	2026-08-27 10:49	2026-08-27 10:49	DUK	DUK270416C00120000	call	120.0000	2027-04-16	8.2000	7.2000	8.4000	120.7500	82806.00	82806.00	0.00	101	17	126	0	0	0.162193388915187	0.162193388915187	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
6d2bdbd4-7ef6-40af-98b0-8387d5c6e47d	2026-08-24 11:13	2026-08-24 11:13	2026-08-24 11:13	DUK	DUK261016P00120000	put	120.0000	2026-10-16	2.6500	2.5000	2.6500	120.6550	73650.00	73650.00	0.00	278	37	313	799	0.391739674593242	0.179051039386694	0.179051039386694	false	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