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:ticker = KMI×

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

979e3b5f-30be-4082-8981-43f5b7e4b8ca	2026-09-22 14:08	2026-09-22 14:08	2026-09-22 14:08	KMI	KMI261016C00033000	call	33.0000	2026-10-16	0.2600	0.2300	0.2700	31.3800	23998.00	23348.00	650.00	923	11	1053	9461	0.111299017017229	0.24487591943512	0.24487591943512	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	69632101323.00	2026-10-28	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:10:48.215993Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
ea16d402-439e-4a93-bfd7-bb545f9094f7	2026-09-21 14:52	2026-09-21 14:52	2026-09-21 14:52	KMI	KMI261016C00032000	call	32.0000	2026-10-16	0.7500	0.7400	0.7800	31.8350	10357.00	150.00	9675.00	138	15	330	1326	0.248868778280543	0.239963565947149	0.236954888480327	true	false	false	true	false
f6bb229a-d994-4d62-9846-4ec45019dd22	2026-09-21 12:43	2026-09-21 12:42	2026-09-21 12:42	KMI	KMI261016P00032000	put	32.0000	2026-10-16	0.8700	0.8400	0.8800	31.7750	17574.00	17487.00	87.00	202	15	292	584	0.5	0.240371931579711	0.240371931579711	false	false	false	true	false
d1fab7d5-c76d-4229-b971-e129df5d68ae	2026-09-21 11:12	2026-09-21 11:12	2026-09-21 11:12	KMI	KMI270115P00030000	put	30.0000	2027-01-15	1.0500	1.0000	1.0500	31.0000	33600.00	33600.00	0.00	320	9	401	2439	0.164411644116441	0.275614610290869	0.275614610290869	false	false	false	true	false
2118d1f4-dc30-49ff-8cc7-1276a38f673b	2026-09-18 15:34	2026-09-18 15:34	2026-09-18 15:34	KMI	KMI260918C00031000	call	31.0000	2026-09-18	1.1500	1.0000	1.1500	32.0550	95680.00	95680.00	0.00	832	8	1361	4373	0.311227989938258	5.0978131412313	4.94720373208325	false	true	false	true	false
7d44c19b-8490-42d6-814c-3e7c9e7211f6	2026-09-17 15:19	2026-09-17 15:19	2026-09-17 15:19	KMI	KMI270115C00033000	call	33.0000	2027-01-15	1.1200	1.1200	1.2000	31.3150	174832.00	0.00	174832.00	1561	46	1575	773	2.03751617076326	0.227801892842247	0.227801892842247	false	false	false	true	false
6e26dfc3-5a4f-4a40-becd-a7ff3502551a	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	KMI	KMI260918C00029000	call	29.0000	2026-09-18	1.7200	1.7200	1.9200	30.7650	284144.00	0.00	284144.00	1652	24	1655	812	2.03817733990148	0.561149854322003	0.402081615045538	false	false	false	true	false
c00fbb30-d05a-492c-bcd9-98abe1a1e02f	2026-09-14 11:30	2026-09-14 11:30	2026-09-14 11:30	KMI	KMI261218C00031000	call	31.0000	2026-12-18	1.5700	1.5600	1.6000	30.8950	134392.00	101579.00	157.00	856	5	866	774	1.11886304909561	0.232088202154046	0.232088202154046	false	false	false	true	false
d59a0169-ce5b-448e-a5aa-8e65b645f0df	2026-09-11 11:41	2026-09-11 11:40	2026-09-11 11:40	KMI	KMI261218C00030000	call	30.0000	2026-12-18	2.1100	2.1100	2.1500	30.8700	51062.00	0.00	51062.00	242	5	314	952	0.329831932773109	0.227214503160672	0.228877374663053	true	false	false	true	false
4664b3ee-b2b4-49bc-8895-6d2017375b94	2026-09-03 15:19	2026-09-03 15:19	2026-09-03 15:19	KMI	KMI260918C00031000	call	31.0000	2026-09-18	1.1900	1.1700	1.2800	31.8700	204204.00	0.00	204204.00	1716	58	1717	1895	0.906068601583113	0.234348405244202	0.246602331142465	false	false	false	true	false
67acf2d1-613a-4efa-9334-b223dd1cf4a9	2026-08-27 11:31	2026-08-27 11:31	2026-08-27 11:31	KMI	KMI261016C00031000	call	31.0000	2026-10-16	1.4400	1.4300	1.5600	31.3850	72720.00	72288.00	432.00	505	29	512	54	9.48148148148148	0.249645423538926	0.249645423538926	false	false	false	true	false
16c3937b-cf4a-430c-be95-01d0286e7ed2	2026-08-27 11:31	2026-08-27 11:31	2026-08-27 11:31	KMI	KMI261218C00031000	call	31.0000	2026-12-18	1.9800	1.9800	1.9900	31.3850	79730.00	26666.00	53064.00	402	17	419	319	1.31347962382445	0.230285886877471	0.230285886877471	false	false	false	true	false
d69030fd-0574-4f79-a96b-8ec360063e75	2026-08-27 11:28	2026-08-27 11:28	2026-08-27 11:28	KMI	KMI261016P00031000	put	31.0000	2026-10-16	0.8800	0.8400	0.8800	31.3550	179432.00	179432.00	0.00	2039	38	2042	493	4.1419878296146	0.24381383487106	0.24381383487106	false	false	false	true	false
d059f032-42ec-41bd-bf57-c6095ebd7e01	2026-08-26 10:51	2026-08-26 10:51	2026-08-26 10:51	KMI	KMI260828C00032000	call	32.0000	2026-08-28	0.3300	0.2600	0.3700	32.0500	106161.00	105039.00	1122.00	3217	59	3281	475	6.90736842105263	0.318132086804858	0.318132086804858	false	false	false	true	false
00e9bef9-7379-4cc5-8a77-9f3b87074b39	2026-08-25 14:14	2026-08-25 14:14	2026-08-25 14:14	KMI	KMI261016C00034000	call	34.0000	2026-10-16	0.2600	0.2400	0.3000	31.0000	122850.00	0.00	122850.00	4725	92	4729	1100	4.29909090909091	0.22686045940451	0.229213543402671	false	false	false	true	false
ec332e07-524b-427b-b144-c78e328190b4	2026-08-24 13:31	2026-08-24 13:31	2026-08-24 13:31	KMI	KMI261016C00033000	call	33.0000	2026-10-16	0.4500	0.4400	0.5000	31.0750	93915.00	4725.00	89190.00	2087	76	2102	69	30.463768115942	0.227094014549008	0.228852195136867	true	false	false	true	false
2e3b19ee-5d3b-462f-a583-c848f1de8741	2026-08-24 12:09	2026-08-24 12:09	2026-08-24 12:09	KMI	KMI261218C00033000	call	33.0000	2026-12-18	0.8600	0.8300	0.8600	30.7550	56501.00	56501.00	0.00	657	28	663	1256	0.527866242038217	0.225447898497725	0.22700878733745	false	false	false	true	false
a01375f9-e572-468b-af43-9e474f58897e	2026-08-21 12:44	2026-08-21 12:43	2026-08-21 12:43	KMI	KMI270917P00035000	put	35.0000	2027-09-17	5.2500	4.8500	5.3000	31.0850	75075.00	50400.00	24675.00	143	5	143	0	0	0.297308108210827	0.297308108210827	false	false	false	true	false
5f715698-7a0d-4c93-b963-82c4d0473cea	2026-08-21 12:35	2026-08-21 12:35	2026-08-21 12:35	KMI	KMI261218P00031000	put	31.0000	2026-12-18	1.6100	1.5600	1.6100	31.0698	81949.00	81949.00	0.00	509	40	512	942	0.543524416135881	0.260821105322836	0.260821105322836	false	false	false	true	false
a1269fec-99b2-4ee1-b36e-e7d8712d8bf3	2026-08-21 10:54	2026-08-21 10:54	2026-08-21 10:54	KMI	KMI260918P00031000	put	31.0000	2026-09-18	0.6900	0.6300	0.6900	31.1050	240810.00	240810.00	0.00	3490	67	3614	2587	1.39698492462312	0.228793841559499	0.228793841559499	false	false	false	true	false
937ff91b-3318-4eef-8621-3fa1fea4a06f	2026-08-20 12:06	2026-08-20 12:05	2026-08-20 12:05	KMI	KMI270917C00028000	call	28.0000	2027-09-17	5.1000	5.1000	5.6000	31.4900	52048.00	0.00	52048.00	102	9	102	0	0	0.153031942998477	0.154246808862977	true	false	false	true	false
c0a348f8-fdee-4fbb-991b-9dd235b2e0be	2026-08-19 10:53	2026-08-19 10:52	2026-08-19 10:52	KMI	KMI260828P00032500	put	32.5000	2026-08-28	0.6900	0.6000	0.7000	32.0900	183057.00	181263.00	0.00	2653	49	2658	20	132.9	0.235529573142055	0.235529573142055	false	false	false	true	false
9068d05a-8bf6-4c8a-b874-da25cbfce02c	2026-08-17 13:04	2026-08-17 13:04	2026-08-17 13:04	KMI	KMI260828P00033500	put	33.5000	2026-08-28	1.0400	0.9600	1.0400	32.6300	159848.00	159848.00	0.00	1537	45	1537	0	0	0.228146141077041	0.228146141077041	false	false	false	true	false