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:sector = Industrials×source = uw_flow_alerts×

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

fbcbfda5-c859-4458-ab1c-5703c4218675	2026-10-02 10:58	2026-10-02 10:58	2026-10-02 10:58	PL	PL261120C00020000	call	20.0000	2026-11-20	1.0000	0.9500	1.0000	17.6300	25143.00	25143.00	0.00	252	23	377	2716	0.13880706921944	0.703764717711659	0.703764717711659	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	5956198378.00	2026-12-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T14:59:08.432199Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
7a569dff-12d4-4bce-bfab-292aaba7b9d7	2026-10-02 10:58	2026-10-02 10:58	2026-10-02 10:58	OTIS	OTIS261120C00067500	call	67.5000	2026-11-20	1.2500	1.2500	1.3500	64.4300	16650.00	0.00	16520.00	133	12	600	49	12.2448979591837	0.25102468414674	0.245260502730257	false	false	false	true
a2a0e120-d9db-4660-acfd-c14cbdbe61c1	2026-10-02 10:58	2026-10-02 10:58	2026-10-02 10:58	OTIS	OTIS261120C00067500	call	67.5000	2026-11-20	1.3000	1.3000	1.3500	64.4650	16770.00	0.00	16770.00	129	18	467	49	9.53061224489796	0.249636183942728	0.249636183942728	false	false	false	true
7cc903c0-0f11-4c17-8b5d-f832eb5c11f3	2026-10-02 10:58	2026-10-02 10:58	2026-10-02 10:58	OTIS	OTIS261120C00067500	call	67.5000	2026-11-20	1.3500	1.3500	1.4000	64.4850	18902.00	0.00	18902.00	140	17	338	49	6.89795918367347	0.254563860924995	0.254563860924995	false	false	false	true
4afdef51-92b4-4693-99d1-6d3f20662a07	2026-10-02 10:57	2026-10-02 10:57	2026-10-02 10:57	XRPN	XRPN261016P00025000	put	25.0000	2026-10-16	6.9500	6.0000	7.0000	33.0800	36840.00	35460.00	690.00	53	9	418	0	0	4.7132925391878	4.86933633467004	false	false	false	true
c8b54641-7bd1-4ae5-a9fb-09b8bb4c04f6	2026-10-02 10:57	2026-10-02 10:57	2026-10-02 10:57	RKLB	RKLB270115C00080000	call	80.0000	2027-01-15	10.5100	10.5000	10.7500	75.6250	741020.00	54860.00	686160.00	705	18	1562	12309	0.126899016979446	0.735874279466105	0.740799801927541	false	false	false	true
df1dba00-66ae-4d61-a283-d70ba658f356	2026-10-02 10:57	2026-10-02 10:57	2026-10-02 10:57	SPCX	SPCX261009P00157500	put	157.5000	2026-10-09	3.9000	3.9000	3.9500	157.2250	28863.00	0.00	28863.00	74	24	4307	471	9.14437367303609	0.44116080665043	0.440009443830497	false	false	false	true
3d341342-f808-415d-8635-fdf80a24a85e	2026-10-02 10:57	2026-10-02 10:57	2026-10-02 10:57	SPCX	SPCX261009P00157500	put	157.5000	2026-10-09	3.9000	3.9000	3.9500	157.2250	10140.00	0.00	10140.00	26	5	4233	471	8.98726114649681	0.440009443830497	0.440009443830497	false	false	false	true
800db7a7-15dd-434b-a86d-23f00bfd80a1	2026-10-02 10:56	2026-10-02 10:56	2026-10-02 10:56	EOSE	EOSE261009C00003000	call	3.0000	2026-10-09	0.3000	0.2700	0.3000	3.2300	51000.00	51000.00	0.00	1700	23	2043	4134	0.494194484760523	0.915321470404012	0.915321470404012	true	false	false	true
074ed687-9413-4d90-bb88-e40d5276249a	2026-10-02 10:56	2026-10-02 10:56	2026-10-02 10:56	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.4500	0.4500	0.4600	7.8350	22455.00	0.00	22455.00	499	14	2147	12776	0.168049467752035	0.866590560010141	0.866590560010141	false	false	false	true
8cdd821e-a90f-4f84-af27-e5b656fc1fcc	2026-10-02 10:56	2026-10-02 10:56	2026-10-02 10:56	SPCX	SPCX261009P00157500	put	157.5000	2026-10-09	4.0000	3.9500	4.0000	157.1239	40400.00	40400.00	0.00	101	5	4167	471	8.84713375796178	0.445749199624134	0.445749199624134	true	false	false	true
e45eaa67-2fe3-4fd8-9bf4-5154141c5020	2026-10-02 10:56	2026-10-02 10:56	2026-10-02 10:56	ROK	ROK261016C00470000	call	470.0000	2026-10-16	2.6500	1.9500	2.6500	449.1650	10335.00	10335.00	0.00	39	13	42	38	1.10526315789474	0.265006342397299	0.265006342397299	false	false	false	true
9f5bf5a5-ef4c-40f5-adb8-e33ae2ecb380	2026-10-02 10:55	2026-10-02 10:55	2026-10-02 10:55	SPCX	SPCX261016C00150000	call	150.0000	2026-10-16	9.7500	9.6500	9.7500	157.1500	47775.00	47775.00	0.00	49	9	6249	24642	0.253591429267105	0.438377638674248	0.438377638674248	false	false	false	true
83b2114f-bdaf-4595-b515-c04fc0542947	2026-10-02 10:55	2026-10-02 10:55	2026-10-02 10:55	BA	BA261009C00197500	call	197.5000	2026-10-09	1.5100	1.3900	1.5700	191.7399	152361.00	152057.00	304.00	1009	56	1920	1438	1.33518776077886	0.341204544550405	0.342856339359162	true	false	false	true
e8afd1ea-3d22-409c-a291-cd7c0b4038cb	2026-10-02 10:55	2026-10-02 10:55	2026-10-02 10:55	SPCX	SPCX261002P00157500	put	157.5000	2026-10-02	1.1500	1.1500	1.1700	157.2201	11500.00	0.00	11500.00	100	8	18170	119	152.689075630252	0.669462428860881	0.665905895218886	false	false	false	true
fbb7cf9a-047b-400c-9d5a-494725607fec	2026-10-02 10:55	2026-10-02 10:55	2026-10-02 10:55	SPCX	SPCX261002P00155000	put	155.0000	2026-10-02	0.2700	0.2700	0.2900	157.2500	15849.00	0.00	15849.00	587	41	51071	3549	14.3902507748662	0.684848004870493	0.684848004870493	false	false	false	true
7c87e2e8-fd23-4a40-9f0e-276c5b8a2fec	2026-10-02 10:55	2026-10-02 10:55	2026-10-02 10:55	SPCX	SPCX261002P00155000	put	155.0000	2026-10-02	0.2700	0.2700	0.2900	157.2438	21951.00	0.00	21951.00	813	28	51884	3549	14.6193293885602	0.683704449150133	0.683704449150133	false	false	false	true
f6801ce2-9a5b-4827-b238-f0652718f73d	2026-10-02 10:55	2026-10-02 10:55	2026-10-02 10:55	SPCX	SPCX261120P00150000	put	150.0000	2026-11-20	7.6500	7.6000	7.6500	157.5700	21420.00	21420.00	0.00	28	5	1761	11297	0.155882092590953	0.507540312842488	0.507540312842488	false	false	false	true
06e88abc-27cf-45a8-b06a-8add4f8ea7d8	2026-10-02 10:55	2026-10-02 10:55	2026-10-02 10:55	SPCX	SPCX270319P00130000	put	130.0000	2027-03-19	8.1600	8.1500	8.4500	157.5900	18760.00	2460.00	16300.00	23	5	2448	14578	0.167924269447112	0.51375793212008	0.51375793212008	false	false	false	true
48504844-b7ce-40ab-96ca-b1ff452eb75f	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	SPCX	SPCX261016C00160000	call	160.0000	2026-10-16	4.4000	4.4000	4.4500	157.6100	31681.00	0.00	31681.00	72	7	17739	42370	0.418668869483125	0.43676445457757	0.435946991296046	false	false	false	true
d737f966-2594-4291-b99a-addbc18fe8ca	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	SPCX	SPCX261030C00152500	call	152.5000	2026-10-30	10.9000	10.7000	10.9000	157.6300	152600.00	152600.00	0.00	140	31	1011	1222	0.827332242225859	0.455045192678936	0.455045192678936	false	false	false	true
3a80c872-8329-4258-ac4b-3a515d1d72d2	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	SPCX	SPCX270319P00130000	put	130.0000	2027-03-19	8.1700	8.1500	8.2500	157.6001	18780.00	1640.00	17140.00	23	6	2424	14578	0.166277953079984	0.513827691353981	0.515419481954298	false	false	false	true
50d77b47-2a8c-4c18-8acf-4eb9eb4ff210	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPCX	SPCX270115P00140000	put	140.0000	2027-01-15	7.6500	7.6500	7.7500	157.6650	12244.00	0.00	12244.00	16	6	670	10197	0.0657055996861822	0.489752003130634	0.489752003130634	false	false	false	true
409eb79f-01d8-413d-a233-be2f3219336a	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	RKLB	RKLB261023C00073000	call	73.0000	2026-10-23	6.1900	6.1500	6.4500	75.6500	12370.00	0.00	12370.00	20	6	38	173	0.219653179190751	0.648666414148658	0.655938714159378	false	false	false	true
9a47635c-7dd2-49bd-bc58-b61ae0441ee6	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPCX	SPCX261030C00175000	call	175.0000	2026-10-30	2.6000	2.6000	2.6500	157.5899	13000.00	0.00	13000.00	50	14	1133	1706	0.664126611957796	0.46411595824771	0.46411595824771	false	false	false	true
e23d73a6-b02b-4f76-ac61-4276fba127ce	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPCX	SPCX270319C00190000	call	190.0000	2027-03-19	11.1800	11.0000	11.2000	157.6600	25725.00	23495.00	2230.00	23	6	3225	1263	2.55344418052257	0.491173273633012	0.489933835266372	false	false	false	true
176ea11c-ee05-47a6-8a73-cd569422f39c	2026-10-02 10:53	2026-10-02 10:53	2026-10-02 10:53	SPCX	SPCX270319P00130000	put	130.0000	2027-03-19	8.1500	8.1500	8.4500	157.6699	16310.00	0.00	16310.00	20	5	2401	14578	0.164700233228152	0.51430953177282	0.51430953177282	false	false	false	true
d0e7f20d-f97b-4fff-9974-19e547360a6d	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPCX	SPCX261016C00150000	call	150.0000	2026-10-16	10.0500	9.9500	10.0500	157.5378	65303.00	65303.00	0.00	65	7	6185	24642	0.250994237480724	0.439990831553067	0.438007571744994	false	false	false	true
1cd31eeb-7f07-49ce-9238-92834874d473	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	VRT	VRT261016P00255000	put	255.0000	2026-10-16	11.2500	10.7500	12.1000	252.4600	11250.00	0.00	11250.00	10	5	11	615	0.0178861788617886	0.512229638510089	0.512229638510089	false	false	false	true
572f52bf-d6d7-4bea-babd-3d875ca1237d	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPCX	SPCX261002P00155000	put	155.0000	2026-10-02	0.2300	0.2100	0.2400	157.5600	23021.00	23021.00	0.00	1000	61	47963	3549	13.5145111298957	0.700946993119555	0.706349370401739	false	false	false	true
50247e8b-95b0-4783-942d-1a1b90d8b36d	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	LUNR	LUNR261002P00015500	put	15.5000	2026-10-02	0.3100	0.2400	0.3100	15.3250	11253.00	11253.00	0.00	363	42	402	3723	0.107977437550363	1.42053193168815	1.42053193168815	false	false	false	true
e8d0e32f-ed61-4423-951a-3e3534e2501b	2026-10-02 10:52	2026-10-02 10:52	2026-10-02 10:52	SPCX	SPCX261002C00155000	call	155.0000	2026-10-02	2.8400	2.8400	2.8800	157.6200	28400.00	0.00	28400.00	100	7	38351	26239	1.46160295742978	0.691077415953007	0.691077415953007	false	false	false	true
4ca599fd-b4a9-4b50-b574-716daa162b79	2026-10-02 10:51	2026-10-02 10:51	2026-10-02 10:51	CAT	CAT261023P00755000	put	755.0000	2026-10-23	4.0200	2.7500	4.1000	844.9300	20100.00	14075.00	6025.00	50	12	61	64	0.953125	0.392790067607811	0.392790067607811	false	false	false	true
1fc9db1f-d54a-4d44-88ca-c9a8bed7cb58	2026-10-02 10:51	2026-10-02 10:51	2026-10-02 10:51	SPCX	SPCX261016C00150000	call	150.0000	2026-10-16	10.0000	9.9500	10.0000	157.5200	54000.00	54000.00	0.00	54	21	6080	24642	0.246733219706193	0.436331098552439	0.436331098552439	false	false	false	true
0379ab02-b610-4348-96f5-a7d9e1b7d48f	2026-10-02 10:51	2026-10-02 10:51	2026-10-02 10:51	SPCX	SPCX261016C00150000	call	150.0000	2026-10-16	10.0000	9.9500	10.0000	157.5100	70000.00	70000.00	0.00	70	12	6026	24642	0.244541839136434	0.437791798369257	0.437062075056438	false	false	false	true
4762aab8-36fa-4f6c-aa9c-a6585d26cbd2	2026-10-02 10:51	2026-10-02 10:51	2026-10-02 10:51	VRT	VRT261120C00300000	call	300.0000	2026-11-20	8.3000	8.3000	8.7500	252.6906	41500.00	0.00	41500.00	50	5	151	4391	0.0343885219767707	0.616024524840919	0.616024524840919	false	false	false	true
4bacfc08-61cb-4bb5-a7e4-7c2e3855cfd9	2026-10-02 10:51	2026-10-02 10:51	2026-10-02 10:51	SPCX	SPCX261002P00157500	put	157.5000	2026-10-02	1.0500	1.0300	1.0500	157.4750	10500.00	10500.00	0.00	100	5	16544	119	139.025210084034	0.682738077603442	0.682738077603442	false	false	false	true
3c44c088-f756-4d16-9fec-825997c113d5	2026-10-02 10:51	2026-10-02 10:51	2026-10-02 10:51	BE	BE261002P00292500	put	292.5000	2026-10-02	2.8800	2.6200	2.9500	292.2850	29070.00	28788.00	282.00	101	20	599	570	1.05087719298246	1.00591254466762	0.959921994279783	true	false	false	true
a84813d0-f5cb-4f54-8d9f-7f9fa0246771	2026-10-02 10:51	2026-10-02 10:50	2026-10-02 10:50	RKLB	RKLB261002C00076000	call	76.0000	2026-10-02	0.5200	0.5200	0.5800	75.8900	24024.00	0.00	24024.00	462	39	5640	2481	2.273276904474	0.779272693249567	0.779272693249567	false	false	false	true
64f6bcfb-9cef-400b-8b0b-967382cfa850	2026-10-02 10:51	2026-10-02 10:50	2026-10-02 10:50	SPCX	SPCX270917C00345000	call	345.0000	2027-09-17	3.8500	3.7000	3.8500	157.4200	54285.00	54285.00	0.00	141	8	191	56	3.41071428571429	0.526157938280365	0.526157938280365	false	false	false	true
65437e31-0a84-4c6f-a586-2b155ed9f24b	2026-10-02 10:51	2026-10-02 10:50	2026-10-02 10:50	SPCX	SPCX270917C00345000	call	345.0000	2027-09-17	3.8300	3.0500	4.0000	157.4100	19125.00	9625.00	9500.00	50	8	50	56	0.892857142857143	0.526157938280365	0.52455537457248	false	false	false	true
59059277-f921-4cdd-9e5c-f372f0c7c9c4	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPCX	SPCX261002C00160000	call	160.0000	2026-10-02	0.2700	0.2700	0.2800	157.4100	25704.00	0.00	25704.00	952	32	43037	24020	1.79171523730225	0.728163325782635	0.728163325782635	false	false	false	true
af782866-0652-435e-95e6-b6ec33bd4bf1	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPCX	SPCX261002P00157500	put	157.5000	2026-10-02	1.0900	1.0800	1.1000	157.4001	47787.00	4251.00	43536.00	440	26	16160	119	135.798319327731	0.683017621832908	0.676486489029721	false	false	false	true
b70cada5-e747-4fcd-a3b6-d723ca05f8fa	2026-10-02 10:50	2026-10-02 10:50	2026-10-02 10:50	SPCX	SPCX261218C00170000	call	170.0000	2026-12-18	9.5500	9.5000	9.6000	157.5300	20055.00	0.00	19100.00	21	12	993	7693	0.129078382945535	0.482511488978048	0.482511488978048	true	false	false	true
cea035e0-20f9-4e1a-9912-953f837baa1f	2026-10-02 10:50	2026-10-02 10:49	2026-10-02 10:49	BE	BE261002C00295000	call	295.0000	2026-10-02	2.0000	1.8900	2.0000	293.2800	41600.00	41600.00	0.00	208	11	7315	1476	4.9559620596206	0.972942712820341	0.972942712820341	true	false	false	true
2c7be5e5-eded-48cb-af3e-b09fb14091f6	2026-10-02 10:49	2026-10-02 10:49	2026-10-02 10:49	SPCX	SPCX270617C00220000	call	220.0000	2027-06-17	10.5000	10.3000	10.6000	157.4900	10500.00	5250.00	3150.00	10	5	15	8300	0.00180722891566265	0.500156822182175	0.500091062868927	false	false	false	true
954dd76b-6049-4180-97ec-145a8e2c8f4d	2026-10-02 10:49	2026-10-02 10:49	2026-10-02 10:49	SPCX	SPCX261120C00165000	call	165.0000	2026-11-20	8.7500	8.7500	8.8500	157.5700	35000.00	0.00	35000.00	40	6	918	4174	0.219932918064207	0.499375681301449	0.499375681301449	false	false	false	true
bf43e80f-e7e9-49db-a39c-e73e0b334da5	2026-10-02 10:49	2026-10-02 10:49	2026-10-02 10:49	BE	BE261002C00292500	call	292.5000	2026-10-02	3.2500	3.2000	3.4000	293.5500	65325.00	65000.00	325.00	201	5	4701	701	6.70613409415121	0.937253531613428	0.946580795415995	true	false	false	true
7550e093-bba1-42dd-b273-360e000d729e	2026-10-02 10:49	2026-10-02 10:49	2026-10-02 10:49	SPCX	SPCX261030C00172500	call	172.5000	2026-10-30	3.1500	3.1000	3.1500	157.6500	18585.00	18585.00	0.00	59	5	19278	507	38.0236686390533	0.464466081209371	0.464466081209371	false	false	false	true
e8ef2842-46ef-4fb8-ad35-824487856222	2026-10-02 10:49	2026-10-02 10:49	2026-10-02 10:49	ITW	ITW261218P00260000	put	260.0000	2026-12-18	8.3000	7.6000	8.3000	263.4900	54780.00	54780.00	0.00	66	16	97	39	2.48717948717949	0.229268737994315	0.229268737994315	true	false	false	true