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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×sector = Industrials×

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

31077c84-4761-4f7a-8a64-22892c6a8b1d	2026-10-01 15:50	2026-10-01 15:50	2026-10-01 15:50	BE	BE261016P00290000	put	290.0000	2026-10-16	23.3300	23.2000	23.6000	276.8500	27995.00	4670.00	23325.00	12	8	96	1132	0.0848056537102474	0.708708920496534	0.707247238700755	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Industrials	81754900703.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:52:25.884700Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
53fc283b-017b-43e3-bb49-6193f2191055	2026-10-01 15:48	2026-10-01 15:48	2026-10-01 15:48	DAL	DAL261009C00087000	call	87.0000	2026-10-09	1.7400	1.5800	1.8100	83.9500	270888.00	197961.00	20252.00	1560	51	7655	354	21.6242937853107	0.603655315419694	0.595886232469226	true	false	false
2bf10f6c-28aa-4fff-9072-07b01f5f0227	2026-10-01 15:48	2026-10-01 15:47	2026-10-01 15:47	FPS	FPS261016P00030000	put	30.0000	2026-10-16	0.1000	0.1000	0.1500	37.1200	10021.00	0.00	10021.00	1000	46	1015	1431	0.709294199860238	0.669848565745809	0.656559992489152	false	false	false
9d1a36f0-c1f3-48e3-b674-a14a1592ce93	2026-10-01 15:39	2026-10-01 15:39	2026-10-01 15:39	BA	BA261002C00195000	call	195.0000	2026-10-02	2.1400	2.0200	2.1600	194.3650	19063.00	18859.00	204.00	89	7	6814	2693	2.5302636464909	0.601374631160087	0.574169053914707	false	false	false	true
589bcc65-5ce0-4cda-84cf-d241efe183f6	2026-10-01 15:37	2026-10-01 15:37	2026-10-01 15:37	BA	BA261009C00192500	call	192.5000	2026-10-09	4.3500	3.7500	4.5000	192.5300	23905.00	21300.00	2605.00	55	10	746	429	1.73892773892774	0.380306666378877	0.373946955111865	true	false	false	true
e1d1630a-04f9-4619-ab1a-2b9bdb5036cd	2026-10-01 15:36	2026-10-01 15:36	2026-10-01 15:36	SPCX	SPCX261120P00150000	put	150.0000	2026-11-20	10.5500	10.4500	10.5500	149.3900	266893.00	266893.00	0.00	253	38	4780	7771	0.615107450778536	0.484796348830825	0.484796348830825	false	false	false
ca2db8a8-c0c7-4215-b958-0d9fae7f130d	2026-10-01 15:29	2026-10-01 15:29	2026-10-01 15:29	AEIS	AEIS261120P00280000	put	280.0000	2026-11-20	20.2800	19.0000	23.2000	294.0000	50694.00	0.00	50694.00	25	6	25	27	0.925925925925926	0.653229715785302	0.653229715785302	false	false	false
1e841208-821e-4c75-a132-8b7213a3d478	2026-10-01 15:29	2026-10-01 15:29	2026-10-01 15:29	BA	BA261002C00190000	call	190.0000	2026-10-02	1.8700	1.8200	2.1000	189.0000	18671.00	0.00	18671.00	100	7	11292	4994	2.2611133360032	0.512345945628537	0.507290478875592	false	false	false	true
58fabee3-876c-41bc-99d4-55232108e8a7	2026-10-01 15:26	2026-10-01 15:26	2026-10-01 15:26	BA	BA261002C00192500	call	192.5000	2026-10-02	1.1700	1.0900	1.3200	190.0000	12994.00	356.00	12638.00	111	15	8339	3741	2.22908313285218	0.49963614907531	0.490038353776278	false	false	false
9c9d4308-48dc-4fcc-8af4-e3235c4b03d3	2026-10-01 15:26	2026-10-01 15:25	2026-10-01 15:25	SPCX	SPCX261002C00150000	call	150.0000	2026-10-02	1.3400	1.3200	1.3500	149.0000	13498.00	11122.00	2376.00	101	6	35252	18143	1.94300832276911	0.483520423340048	0.477097328277808	true	false	false
c08d1b8f-5a97-4194-a79c-74b5fd3ed11a	2026-10-01 15:24	2026-10-01 15:24	2026-10-01 15:24	SPCX	SPCX261002C00150000	call	150.0000	2026-10-02	1.3000	1.3000	1.3200	149.0000	65066.00	0.00	65066.00	500	6	35067	18143	1.93281155266494	0.484311571316108	0.481093222579676	false	false	false
8d8509d5-2320-4f39-b431-50e42f3e33e7	2026-10-01 15:22	2026-10-01 15:22	2026-10-01 15:22	GE	GE270917P00180000	put	180.0000	2027-09-17	2.6100	2.6000	3.2500	313.0000	10162.00	0.00	10162.00	39	9	70	1	70	0.404958238226954	0.404958238226954	false	false	false	true
36adbca9-41c2-459f-9096-855af6ae90e8	2026-10-01 15:20	2026-10-01 15:20	2026-10-01 15:20	BA	BA261002C00195000	call	195.0000	2026-10-02	0.5100	0.5000	0.6700	190.0000	49058.00	48297.00	761.00	960	16	4654	2693	1.72818418121055	0.554787784526256	0.518023248474924	false	false	false
b5357c1a-e73a-4399-bf97-a632f6a0031b	2026-10-01 15:19	2026-10-01 15:19	2026-10-01 15:19	BA	BA261002C00192500	call	192.5000	2026-10-02	1.0600	0.9900	1.6100	190.0000	58684.00	20529.00	38155.00	552	23	6596	3741	1.76316492916333	0.534744352051658	0.518496756037551	false	false	false
d1aba78b-f7d8-4951-90e5-c5236ec8f0e0	2026-10-01 15:18	2026-10-01 15:18	2026-10-01 15:18	BE	BE261002C00275000	call	275.0000	2026-10-02	5.2700	5.2000	5.3000	275.0000	42680.00	41630.00	1050.00	81	6	1438	1199	1.19933277731443	0.833495393886746	0.824771484467629	false	false	false
37c52fd0-7de8-486e-a7b0-da84280132e7	2026-10-01 15:17	2026-10-01 15:17	2026-10-01 15:17	BA	BA261002C00195000	call	195.0000	2026-10-02	0.7500	0.6900	1.0100	190.0000	15605.00	686.00	14919.00	208	18	2580	2693	0.958039361307092	0.588062139244036	0.561559610571599	true	false	false
868b2c7d-4732-4772-8b5b-e625b6a0fc9f	2026-10-01 15:17	2026-10-01 15:17	2026-10-01 15:17	BA	BA261218C00195000	call	195.0000	2026-12-18	11.0800	10.0500	11.1500	189.0000	23270.00	22185.00	1085.00	21	8	75	625	0.12	0.373240410949356	0.361937035585519	true	false	false	true
d80f1d7e-d374-41b9-9f87-6ba47b9b0555	2026-10-01 15:16	2026-10-01 15:16	2026-10-01 15:16	BA	BA261009C00200000	call	200.0000	2026-10-09	0.9400	0.7600	1.2000	188.9400	30886.00	13132.00	17754.00	328	23	1417	1722	0.822880371660859	0.392549605039787	0.381674669330905	true	false	false
40a05c43-54f9-4065-b78a-5d8d7fc81a70	2026-10-01 15:16	2026-10-01 15:16	2026-10-01 15:16	BA	BA261009C00195000	call	195.0000	2026-10-09	1.9700	1.9000	2.3800	188.6100	30949.00	0.00	30949.00	157	20	1966	2031	0.967996061053668	0.382385455441967	0.381160542290874	true	false	false
53d07e6b-c446-4de6-a0ba-f8cb448ad76d	2026-10-01 15:16	2026-10-01 15:16	2026-10-01 15:16	BE	BE261009C00277500	call	277.5000	2026-10-09	10.7500	10.2000	11.4000	275.5600	109630.00	58035.00	51595.00	102	6	589	504	1.16865079365079	0.70954079742403	0.706468570235736	true	false	false
68026111-0eea-46e1-b7dd-2e87ca4ad46e	2026-10-01 15:16	2026-10-01 15:16	2026-10-01 15:16	BA	BA261120C00220000	call	220.0000	2026-11-20	2.2000	1.9600	2.4000	189.2100	28155.00	27939.00	216.00	128	5	512	7895	0.0648511716276124	0.380051126740829	0.375375640268132	false	false	false
cd90d3c1-4ea0-4e21-925c-d7ecfc3037dc	2026-10-01 15:13	2026-10-01 15:13	2026-10-01 15:13	BE	BE261009C00285000	call	285.0000	2026-10-09	7.9300	7.0000	8.2000	276.3000	123755.00	73680.00	50075.00	156	15	382	345	1.10724637681159	0.713347182917499	0.709205512379014	true	false	false
811c8128-1113-470d-9c34-9bdc82baa17c	2026-10-01 15:13	2026-10-01 15:13	2026-10-01 15:13	BE	BE261023C00285000	call	285.0000	2026-10-23	16.1600	15.1000	16.3500	276.3000	14540.00	9725.00	4815.00	9	5	35	239	0.146443514644351	0.729528046367287	0.725823560395289	true	false	false
4b418f97-81a4-420c-8ed6-616056540a4c	2026-10-01 15:13	2026-10-01 15:13	2026-10-01 15:13	BE	BE261009C00275000	call	275.0000	2026-10-09	12.1600	11.0000	12.5000	276.3000	92435.00	51290.00	41145.00	76	13	528	432	1.22222222222222	0.711095111311034	0.704689221173783	true	false	false
3293ad62-6e82-42a1-a579-91861ef94fdf	2026-10-01 15:13	2026-10-01 15:13	2026-10-01 15:13	BE	BE261016C00272500	call	272.5000	2026-10-16	17.7100	17.4500	17.9000	276.3000	15940.00	7100.00	7065.00	9	7	546	231	2.36363636363636	0.708491539921177	0.701104153867044	true	false	false
17c4805c-2c84-453b-a266-4042c8acab4a	2026-10-01 15:13	2026-10-01 15:13	2026-10-01 15:13	BE	BE261016C00275000	call	275.0000	2026-10-16	16.4700	16.2000	16.6000	276.3000	62570.00	36310.00	26260.00	38	12	1421	501	2.83632734530938	0.708267739673503	0.703524904555101	true	false	false
25170acd-f9da-4087-ab53-bdcd76468227	2026-10-01 15:09	2026-10-01 15:09	2026-10-01 15:09	NOC	NOC270219P00420000	put	420.0000	2027-02-19	10.1800	7.6000	10.6000	482.0200	180120.00	145740.00	34380.00	177	36	177	24	7.375	0.30904642252208	0.305267663485378	true	false	false	true
92ad8354-5ae6-4907-aa62-d72e16187557	2026-10-01 15:01	2026-10-01 15:00	2026-10-01 15:00	BE	BE261016P00287500	put	287.5000	2026-10-16	22.5800	22.4000	22.7000	274.9125	45165.00	22600.00	22565.00	20	7	81	122	0.663934426229508	0.696486915395225	0.694174848595825	true	false	false
59060b6d-f64f-4590-8fdd-51e3491c0355	2026-10-01 15:01	2026-10-01 15:00	2026-10-01 15:00	BE	BE261016P00282500	put	282.5000	2026-10-16	19.4000	19.1500	19.4750	274.9125	128036.00	120306.00	5790.00	66	13	163	127	1.28346456692913	0.692446967460996	0.694257323230042	true	false	false
ba0ef7f4-8663-4233-ab41-92ea08231752	2026-10-01 14:50	2026-10-01 14:50	2026-10-01 14:50	BA	BA270115C00195000	call	195.0000	2027-01-15	11.6600	11.6500	12.0000	187.3650	16322.00	1170.00	15152.00	14	8	84	1598	0.0525657071339174	0.346165777580983	0.345917160313622	false	false	false
0eceddd3-c4de-4827-9acd-98a2c6d96782	2026-10-01 14:42	2026-10-01 14:42	2026-10-01 14:42	BA	BA261009P00185000	put	185.0000	2026-10-09	2.4700	2.4600	2.6900	187.8750	52611.00	4233.00	48378.00	213	9	669	803	0.833125778331258	0.346949221862723	0.346949221862723	false	false	false	true
ddd2a953-de34-44eb-9389-d6477760f6cb	2026-10-01 14:35	2026-10-01 14:35	2026-10-01 14:35	BA	BA261009P00185000	put	185.0000	2026-10-09	2.4800	2.3100	2.5400	187.0000	29013.00	28767.00	246.00	117	26	450	803	0.560398505603985	0.340733018076481	0.332750686399237	true	false	false	true
4569c467-a06c-43a6-9d4f-3c3c7bb342e2	2026-10-01 14:35	2026-10-01 14:35	2026-10-01 14:35	BA	BA261009P00182500	put	182.5000	2026-10-09	1.6300	1.4600	1.6500	187.0000	29651.00	27059.00	2592.00	182	28	553	276	2.0036231884058	0.340359839737692	0.33260257780262	true	false	false	true
f1a0fb19-49e4-4b4b-88ff-01f4fdad9597	2026-10-01 14:30	2026-10-01 14:29	2026-10-01 14:29	JCI	JCI270115C00175000	call	175.0000	2027-01-15	3.3000	2.9500	3.3000	150.6500	82070.00	79190.00	2880.00	249	32	249	975	0.255384615384615	0.317699389960924	0.313691344047608	true	false	false
d804fb2e-7646-465c-9da5-5254fbcd1e6f	2026-10-01 14:15	2026-10-01 14:15	2026-10-01 14:15	RKLB	RKLB261002C00071000	call	71.0000	2026-10-02	1.0900	1.0500	1.1000	70.7200	16403.00	9615.00	1728.00	150	9	4753	2070	2.29613526570048	0.832261712379905	0.825474921025177	true	false	false
8e8e697a-6f00-4e30-bb59-745ff2eac148	2026-10-01 14:08	2026-10-01 14:08	2026-10-01 14:08	SPCX	SPCX261002P00150000	put	150.0000	2026-10-02	1.6000	1.5900	1.6400	149.8600	13802.00	10400.00	3402.00	86	13	44361	13441	3.30042407558961	0.497515665103232	0.491123349999024	false	false	false
a5081886-ed66-467f-987c-48a139f4e8d4	2026-10-01 14:07	2026-10-01 14:07	2026-10-01 14:07	BE	BE261016C00277500	call	277.5000	2026-10-16	14.3700	14.2500	14.4500	273.8650	18675.00	8610.00	8630.00	13	6	164	137	1.1970802919708	0.715634287522236	0.713828256032293	false	false	false
d46a3b5b-b0e2-43f0-b977-c4462fc0455f	2026-10-01 14:01	2026-10-01 14:01	2026-10-01 14:01	BE	BE261023P00200000	put	200.0000	2026-10-23	0.8500	0.7400	0.8500	275.5000	15298.00	15214.00	84.00	180	29	1037	908	1.1420704845815	0.780292785412183	0.77847914374842	true	false	false	true
8cac5dd4-133b-4e2a-8175-62a6f2e2e457	2026-10-01 13:55	2026-10-01 13:55	2026-10-01 13:55	SPCX	SPCX261002P00150000	put	150.0000	2026-10-02	1.3500	1.3300	1.3500	150.4400	15654.00	15252.00	0.00	116	37	43093	13441	3.20608585670709	0.499811357497601	0.499811357497601	true	false	false
dabd3768-dcf6-4819-9913-417c5e759744	2026-10-01 13:36	2026-10-01 13:36	2026-10-01 13:36	BE	BE261002P00272500	put	272.5000	2026-10-02	2.9700	2.9400	3.0000	277.0000	28486.00	295.00	27011.00	96	12	390	974	0.40041067761807	0.855229542522288	0.851496462729764	true	false	false	true
fbcd9819-2059-495a-b4d9-74d68508d077	2026-10-01 13:36	2026-10-01 13:35	2026-10-01 13:35	RDW	RDW270115C00025000	call	25.0000	2027-01-15	0.2300	0.1500	0.2500	10.8399	10031.00	10031.00	0.00	434	7	502	2570	0.195330739299611	1.0128119779336	0.984313825546553	false	false	false
2646711f-ca4f-418f-84a2-e29dc0332104	2026-10-01 13:27	2026-10-01 13:27	2026-10-01 13:27	BE	BE270416P00160000	put	160.0000	2027-04-16	10.0200	9.9000	10.6500	278.7350	25050.00	15000.00	10050.00	25	9	56	607	0.0922570016474465	0.795674234291209	0.794277835962359	false	false	false
26e19c13-4444-462b-b9dc-2556301ab82f	2026-10-01 13:27	2026-10-01 13:27	2026-10-01 13:27	RDW	RDW280121C00010000	call	10.0000	2028-01-21	4.7000	4.7000	4.8000	10.8850	40898.00	0.00	40898.00	87	5	210	8590	0.0244470314318976	0.884455951212868	0.884455951212868	false	false	false
a3638889-69c4-4feb-9459-76dad3dcee5c	2026-10-01 13:21	2026-10-01 13:21	2026-10-01 13:21	BE	BE261016P00280000	put	280.0000	2026-10-16	17.4400	17.3500	17.7000	276.7300	143002.00	1752.00	141250.00	82	19	492	818	0.601466992665037	0.713856957167533	0.710004234355018	true	false	false
882e2296-eafb-4591-b50c-a19e41b274b6	2026-10-01 13:21	2026-10-01 13:21	2026-10-01 13:21	BE	BE261016P00285000	put	285.0000	2026-10-16	20.4300	20.4000	20.7000	276.7358	16345.00	2045.00	14300.00	8	8	75	580	0.129310344827586	0.716136769644295	0.714709580078441	true	false	false	true
49d0c9de-4ba7-43ff-9c74-2193cdecf287	2026-10-01 13:21	2026-10-01 13:21	2026-10-01 13:21	BE	BE261016P00270000	put	270.0000	2026-10-16	12.2800	12.2000	12.5000	276.7300	17186.00	6145.00	11041.00	14	10	147	1685	0.0872403560830861	0.709838015947097	0.705731480821704	true	false	false
e26f8d6e-6923-4b1b-b79d-3d2a0e7e4378	2026-10-01 13:08	2026-10-01 13:08	2026-10-01 13:08	VRT	VRT261120P00240000	put	240.0000	2026-11-20	18.4800	18.1500	19.3500	246.0000	55434.00	0.00	55434.00	30	6	1041	1885	0.552254641909814	0.618482941342045	0.618482941342045	false	false	false
b4842243-28d9-471e-816c-90991e6e78bd	2026-10-01 13:06	2026-10-01 13:06	2026-10-01 13:06	SPCX	SPCX261009C00150000	call	150.0000	2026-10-09	3.7200	3.6500	3.7500	149.9400	21972.00	21972.00	0.00	59	9	4109	4867	0.844257242654613	0.419537496165257	0.41614733424342	false	false	false
c95894b1-88d7-4f69-90db-f8028e72342d	2026-10-01 13:04	2026-10-01 13:04	2026-10-01 13:04	SPCX	SPCX261016P00145000	put	145.0000	2026-10-16	2.7700	2.7700	2.8100	149.9800	11094.00	0.00	11094.00	40	8	3315	11653	0.284476100574959	0.416230129876255	0.415312678260294	false	false	false
835e93a0-26d4-411d-8980-d3d1ac8964fd	2026-10-01 12:56	2026-10-01 12:56	2026-10-01 12:56	SPCX	SPCX261009C00147000	call	147.0000	2026-10-09	5.2000	5.2000	5.3000	149.6700	78015.00	0.00	76440.00	150	33	288	682	0.422287390029326	0.420558096656276	0.414572710751432	false	false	false