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:alert_rule = RepeatedHits×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	expirydate

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
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
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
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