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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×sector = Industrials×ticker = JCI×

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

79c3024a-2304-4246-9a2a-0a24ea4fd8bc	2026-09-29 12:57	2026-09-29 12:57	2026-09-29 12:57	JCI	JCI261218P00145000	put	145.0000	2026-12-18	7.1000	6.6000	7.2000	149.0000	240690.00	239270.00	1420.00	339	34	440	70	6.28571428571429	0.3513220161989	0.3513220161989	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	90509890447.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T17:01:16.214882Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
fe7c5427-069e-4c71-8bb3-552e34538503	2026-09-28 14:45	2026-09-28 14:45	2026-09-28 14:45	JCI	JCI261016C00150000	call	150.0000	2026-10-16	3.4400	3.3000	3.9000	148.6900	16178.00	0.00	16178.00	47	5	800	1101	0.72661217075386	0.301570670878024	0.300048879959406	false	false	false	true
7f7bdca4-42cc-4a9a-83d6-8bef5ef4b363	2026-09-28 14:40	2026-09-28 14:40	2026-09-28 14:40	JCI	JCI261016C00150000	call	150.0000	2026-10-16	3.6000	3.6000	3.8000	148.0000	16200.00	0.00	16200.00	45	10	475	1101	0.431425976385104	0.300640731647625	0.300640731647625	false	false	false	true
e0ecc2d1-58f7-4455-adf5-7d54b3cacbfb	2026-09-28 14:39	2026-09-28 14:39	2026-09-28 14:39	JCI	JCI261016C00150000	call	150.0000	2026-10-16	3.6000	3.6000	4.0000	149.0000	17280.00	0.00	17280.00	48	15	430	1101	0.3905540417802	0.297338649691738	0.297338649691738	false	false	false	true
1d33db50-c1ff-4669-addc-d5b5094a5617	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	JCI	JCI261016C00150000	call	150.0000	2026-10-16	3.6000	3.6000	3.9000	149.0300	17640.00	0.00	17640.00	49	5	336	1101	0.305177111716621	0.296786491997257	0.296786491997257	false	false	false	true
bab92185-acd7-4717-b705-3015b68478ae	2026-09-28 14:37	2026-09-28 14:37	2026-09-28 14:37	JCI	JCI261016C00150000	call	150.0000	2026-10-16	3.6000	3.6000	3.9000	149.1000	17655.00	0.00	17280.00	49	7	287	1101	0.260672116257947	0.305562654495031	0.294202763846356	false	false	false	true
9ebab09e-9326-4965-bf03-b3301d698082	2026-09-24 13:35	2026-09-24 13:35	2026-09-24 13:35	JCI	JCI261120P00140000	put	140.0000	2026-11-20	5.2000	5.0000	5.3000	145.5750	525720.00	525720.00	0.00	1011	2	1264	2	632	0.357874633711671	0.357874633711671	false	true	true	false
c7bdcee0-2c58-4ee9-a61e-f8b4d38cb9de	2026-09-24 13:32	2026-09-24 13:32	2026-09-24 13:32	JCI	JCI261016P00135000	put	135.0000	2026-10-16	0.9000	0.8500	1.0000	145.7200	53010.00	990.00	52020.00	589	26	642	1507	0.426011944260119	0.318687724460662	0.318687724460662	false	false	false	true
6f475534-b310-4d5b-befc-461c57f847c8	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	JCI	JCI261120C00140000	call	140.0000	2026-11-20	11.5000	11.2000	12.3000	145.0000	14950.00	0.00	14950.00	13	8	14	1	14	0.354203012144067	0.354203012144067	false	false	false	true
ae5cf4e2-c26b-48c6-97d2-cf2efb58ad54	2026-09-21 12:52	2026-09-21 12:52	2026-09-21 12:52	JCI	JCI261016C00140000	call	140.0000	2026-10-16	8.2000	7.9000	8.6000	145.0000	244360.00	0.00	244360.00	298	23	300	249	1.20481927710843	0.306687506319052	0.306687506319052	false	false	false	true
8f8f888f-fa30-4771-9204-d8018e7b8368	2026-09-16 11:00	2026-09-16 11:00	2026-09-16 11:00	JCI	JCI270917C00170000	call	170.0000	2027-09-17	10.9000	9.8000	11.5000	141.0800	132980.00	63220.00	69760.00	122	15	488	0	0	0.327026153706162	0.327026153706162	true	false	false	true
d33ae093-58b8-4fd7-9edc-5465c0dbfc65	2026-09-16 11:00	2026-09-16 11:00	2026-09-16 11:00	JCI	JCI270917C00170000	call	170.0000	2027-09-17	10.9000	9.7000	11.6000	141.1050	191843.00	66490.00	125353.00	176	22	236	0	0	0.3274629792714	0.326844151220882	true	false	false	true
fa295a9f-86a4-45ba-97d7-2d42754656d2	2026-09-14 11:04	2026-09-14 11:04	2026-09-14 11:04	JCI	JCI261016P00135000	put	135.0000	2026-10-16	4.6000	4.5000	4.9000	135.9700	52437.00	46917.00	5520.00	114	39	166	1478	0.112313937753721	0.331433197524583	0.331433197524583	false	false	false	true
f033b869-675c-48b7-83cc-a4a3ac69e11e	2026-08-21 14:05	2026-08-21 14:05	2026-08-21 14:05	JCI	JCI261016P00130000	put	130.0000	2026-10-16	2.0500	1.8000	2.0500	143.0000	55555.00	55555.00	0.00	271	33	272	388	0.701030927835051	0.324989581418417	0.324989581418417	false	false	false	true
6db07475-bd38-43da-9e92-cea44dac4571	2026-08-17 14:58	2026-08-17 14:58	2026-08-17 14:58	JCI	JCI260918P00145000	put	145.0000	2026-09-18	2.1900	1.7000	2.2500	153.5000	297699.00	297699.00	0.00	1357	6	1520	296	5.13513513513514	0.308710251157903	0.308710251157903	false	false	false	true