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 = RepeatedHits×ticker = SPCX×

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

94edf2f6-a322-46e0-95b1-3b877f27fe5e	2026-10-02 13:49	2026-10-02 13:49	2026-10-02 13:49	SPCX	SPCX261016C00160000	call	160.0000	2026-10-16	4.5000	4.4500	4.5000	158.0300	10350.00	10350.00	0.00	23	5	22238	42370	0.524852489969318	0.428361685178872	0.428361685178872	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	1223402841624.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T17:52:28.142762Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
c65465ba-201e-4c81-b6c9-6a1b19095459	2026-10-02 13:49	2026-10-02 13:49	2026-10-02 13:49	SPCX	SPCX261002P00157500	put	157.5000	2026-10-02	0.4600	0.4500	0.4600	157.9930	11730.00	11730.00	0.00	255	5	75907	119	637.873949579832	0.685345015794023	0.685345015794023	false	false	false	true
4e071406-c1e1-4d8a-9b16-1b427f2b406e	2026-10-02 13:49	2026-10-02 13:49	2026-10-02 13:49	SPCX	SPCX261016C00155000	call	155.0000	2026-10-16	7.0000	6.9500	7.0000	158.0000	12600.00	12600.00	0.00	18	7	16082	10921	1.4725757714495	0.427377432906849	0.427377432906849	false	false	false	true
af38a1d7-eb27-47f1-a45f-27a8211a514b	2026-10-02 13:48	2026-10-02 13:48	2026-10-02 13:48	SPCX	SPCX261030C00162500	call	162.5000	2026-10-30	5.9000	5.8500	5.9500	157.7500	12390.00	0.00	11800.00	21	6	623	523	1.19120458891013	0.443619246237833	0.444128711977804	false	false	false	true
2bf608c4-a429-42e3-93f3-a8381f8a84ec	2026-10-02 13:48	2026-10-02 13:48	2026-10-02 13:48	SPCX	SPCX261002C00157500	call	157.5000	2026-10-02	0.7900	0.7900	0.8100	157.7650	15721.00	0.00	15721.00	199	27	83911	17160	4.88991841491841	0.651824649075959	0.651824649075959	true	false	false	true
73b1c23a-3137-47c9-b545-d7064a4cb9ac	2026-10-02 13:48	2026-10-02 13:47	2026-10-02 13:47	SPCX	SPCX261002C00157500	call	157.5000	2026-10-02	0.8800	0.8600	0.9000	157.9100	23936.00	0.00	19008.00	272	8	82427	17160	4.80343822843823	0.655333603699634	0.655333603699634	false	false	false	true
7bae106d-31e2-4e3e-99d2-4a3251b2e754	2026-10-02 13:47	2026-10-02 13:47	2026-10-02 13:47	SPCX	SPCX261016C00165000	call	165.0000	2026-10-16	2.7100	2.6900	2.7100	157.9300	13550.00	13550.00	0.00	50	7	7329	13835	0.529743404409107	0.432771674892826	0.432771674892826	false	false	false	true
cd981044-fb47-445e-b9c7-7b9b1ec1b47c	2026-10-02 13:47	2026-10-02 13:47	2026-10-02 13:47	SPCX	SPCX261002C00157500	call	157.5000	2026-10-02	0.8800	0.8800	0.9000	157.9018	10384.00	0.00	1232.00	118	11	81910	17160	4.77331002331002	0.658463625750956	0.658463625750956	true	false	false	true
ca22fe63-e791-4899-b1ce-72c4f208331c	2026-10-02 13:46	2026-10-02 13:46	2026-10-02 13:46	SPCX	SPCX261009P00146000	put	146.0000	2026-10-09	0.4900	0.4900	0.5000	157.7959	10045.00	0.00	10045.00	205	18	2301	3487	0.659879552624032	0.455490303980987	0.455490303980987	false	false	false	true
5e8dcf46-309d-403b-81b6-8ceb0b4368dd	2026-10-02 13:45	2026-10-02 13:45	2026-10-02 13:45	SPCX	SPCX261016C00160000	call	160.0000	2026-10-16	4.3500	4.3500	4.4000	157.7400	11745.00	0.00	11745.00	27	6	22185	42370	0.523601604909134	0.427028559393429	0.427028559393429	true	false	false	true
9d18d1cf-6722-4bf3-a3e6-cbb4144bc9af	2026-10-02 13:44	2026-10-02 13:44	2026-10-02 13:44	SPCX	SPCX261016C00185000	call	185.0000	2026-10-16	0.3200	0.3200	0.3300	157.8350	12640.00	0.00	12640.00	395	19	5609	5494	1.02093192573717	0.482008310963845	0.482008310963845	false	false	false	true
4aeea225-17b4-43c2-b5ed-e1fcc2f20bb6	2026-10-02 13:44	2026-10-02 13:44	2026-10-02 13:44	SPCX	SPCX261016C00190000	call	190.0000	2026-10-16	0.2000	0.2000	0.2100	157.8350	43400.00	0.00	43400.00	2170	33	2857	7798	0.366375993844576	0.500852609820629	0.500852609820629	false	false	false	true
f08171de-c9cb-4d8e-8312-2a1d98d60696	2026-10-02 13:44	2026-10-02 13:44	2026-10-02 13:44	SPCX	SPCX261016P00152500	put	152.5000	2026-10-16	2.8900	2.8700	2.8900	157.8500	17918.00	17918.00	0.00	62	5	2118	896	2.36383928571429	0.430584678531181	0.430584678531181	false	false	false	true
ef329915-bf0a-4bfc-9ff3-a11e5894a08d	2026-10-02 13:44	2026-10-02 13:44	2026-10-02 13:44	SPCX	SPCX261009C00160000	call	160.0000	2026-10-09	2.8500	2.8400	2.8500	157.8500	13110.00	13110.00	0.00	46	6	24965	8277	3.01618944061858	0.430366516937039	0.430366516937039	false	false	false	true
3bcc852b-03e6-4afd-9f96-4312791b740c	2026-10-02 13:41	2026-10-02 13:41	2026-10-02 13:41	SPCX	SPCX261009C00160000	call	160.0000	2026-10-09	2.7300	2.7300	2.7500	157.6200	10920.00	0.00	10920.00	40	11	24859	8277	3.00338286818896	0.427678278816669	0.427678278816669	true	false	false	true
0e10ac54-b2ea-4e7c-8016-c18eb3fcd0f1	2026-10-02 13:41	2026-10-02 13:41	2026-10-02 13:41	SPCX	SPCX261002C00157500	call	157.5000	2026-10-02	0.7300	0.7300	0.7400	157.6300	15330.00	0.00	15330.00	210	13	80823	17160	4.70996503496503	0.648888788172527	0.648888788172527	false	false	false	true
9ae38aab-f0ac-4690-8c4c-5e43a7af1a44	2026-10-02 13:38	2026-10-02 13:38	2026-10-02 13:38	SPCX	SPCX261016P00160000	put	160.0000	2026-10-16	6.4500	6.4500	6.5000	157.6700	31605.00	0.00	31605.00	49	8	1946	2889	0.673589477327795	0.431182236213858	0.431182236213858	false	false	false	true
601d9139-a179-438b-a651-4b11496e3ebb	2026-10-02 13:35	2026-10-02 13:35	2026-10-02 13:35	SPCX	SPCX261002P00155000	put	155.0000	2026-10-02	0.0700	0.0600	0.0700	157.7200	14000.00	14000.00	0.00	2000	36	130938	3549	36.894336432798	0.749093260302722	0.747041736545168	false	false	false	true
e19de683-6d24-47d9-b1fe-7b99f2093177	2026-10-02 13:33	2026-10-02 13:33	2026-10-02 13:33	SPCX	SPCX261218C00155000	call	155.0000	2026-12-18	15.7500	15.6000	15.7500	157.7100	20475.00	20475.00	0.00	13	7	1897	12329	0.153864871441317	0.478446180598396	0.478446180598396	false	false	false	true
6c31163a-4965-4792-a96f-6ce53f7fbf74	2026-10-02 13:32	2026-10-02 13:32	2026-10-02 13:32	SPCX	SPCX261009P00148000	put	148.0000	2026-10-09	0.7000	0.7000	0.7200	157.0000	14000.00	0.00	14000.00	200	7	7848	2766	2.83731019522777	0.438739609751319	0.439315290439734	false	false	false	true
1a929bf2-35d4-4931-bf69-e2f338d6aa43	2026-10-02 13:32	2026-10-02 13:32	2026-10-02 13:32	SPCX	SPCX261002P00157500	put	157.5000	2026-10-02	0.6100	0.6000	0.6100	157.0000	11102.00	11102.00	0.00	182	5	70665	119	593.823529411765	0.657376601272631	0.657376601272631	true	false	false	true
59acbf94-b440-4865-a75a-451065c0ee22	2026-10-02 13:32	2026-10-02 13:32	2026-10-02 13:32	SPCX	SPCX261009P00160000	put	160.0000	2026-10-09	5.0000	5.0000	5.0500	157.0000	13000.00	0.00	13000.00	26	6	2951	610	4.83770491803279	0.428288394003142	0.428288394003142	false	false	false	true
0769904b-6b7e-4ec1-b71d-7098096bfd65	2026-10-02 13:30	2026-10-02 13:30	2026-10-02 13:30	SPCX	SPCX261016C00160000	call	160.0000	2026-10-16	4.2000	4.1500	4.2000	157.0000	21000.00	21000.00	0.00	50	5	21991	42370	0.519022893556762	0.426576513447479	0.426576513447479	false	false	false	true
6d8df982-4edd-4195-af23-c9bb5e83abfe	2026-10-02 13:28	2026-10-02 13:28	2026-10-02 13:28	SPCX	SPCX261009C00160000	call	160.0000	2026-10-09	2.5500	2.5500	2.5700	157.0000	25500.00	0.00	25500.00	100	5	24531	8277	2.96375498368974	0.425699048248883	0.425699048248883	false	false	false	true
fba88c9d-04fd-4155-9608-b2c42d28d69a	2026-10-02 13:27	2026-10-02 13:27	2026-10-02 13:27	SPCX	SPCX261113C00220000	call	220.0000	2026-11-13	0.5000	0.5000	0.5100	157.0000	11850.00	0.00	11850.00	237	7	3021	0	0	0.544113359818459	0.544113359818459	true	false	false	true
3d1f10f6-d431-4245-8462-9cb11bffe646	2026-10-02 13:25	2026-10-02 13:25	2026-10-02 13:25	SPCX	SPCX261113C00220000	call	220.0000	2026-11-13	0.5300	0.5300	0.5400	157.0000	12296.00	0.00	12296.00	232	23	2334	0	0	0.548307972900028	0.548307972900028	false	false	false	true
333384aa-e690-442c-a8c2-e8cd4f7a6cd1	2026-10-02 13:25	2026-10-02 13:25	2026-10-02 13:25	SPCX	SPCX261113C00220000	call	220.0000	2026-11-13	0.5300	0.5300	0.5400	157.0000	12084.00	0.00	12084.00	228	6	2562	0	0	0.548218458209634	0.548218458209634	false	false	false	true
5d7dccc2-39ef-4c8a-8570-e9620fdff20d	2026-10-02 13:25	2026-10-02 13:25	2026-10-02 13:25	SPCX	SPCX261113C00220000	call	220.0000	2026-11-13	0.5300	0.5300	0.5700	157.0000	12561.00	0.00	12561.00	237	21	2102	0	0	0.548666074747222	0.548666074747222	false	false	false	true
757151bd-5044-4498-ab26-568eb23b534f	2026-10-02 13:22	2026-10-02 13:22	2026-10-02 13:22	SPCX	SPCX281215C00200000	call	200.0000	2028-12-15	41.0000	40.7500	41.5500	157.4800	123001.00	0.00	123001.00	30	19	156	8064	0.0193452380952381	0.528945478109894	0.528945478109894	false	false	false	true
7ac70bff-73d5-4176-b80f-d8f136735aa1	2026-10-02 13:22	2026-10-02 13:22	2026-10-02 13:22	SPCX	SPCX270319P00155000	put	155.0000	2027-03-19	18.1000	18.1000	18.2500	157.5500	94125.00	1815.00	92310.00	52	7	196	437	0.448512585812357	0.498029647428815	0.49812501695642	false	false	false	true
67acd3e3-0803-4dc2-98dd-30281043fd95	2026-10-02 13:22	2026-10-02 13:22	2026-10-02 13:22	SPCX	SPCX270319P00150000	put	150.0000	2027-03-19	15.6500	15.6500	15.8500	157.5500	1036035.00	1570.00	1034465.00	662	34	785	8944	0.0877683363148479	0.498771511213096	0.498860698186587	false	false	false	true
9c51f19d-c94c-4a23-85ad-0334d425a601	2026-10-02 13:20	2026-10-02 13:20	2026-10-02 13:20	SPCX	SPCX261009P00152500	put	152.5000	2026-10-09	1.6600	1.6600	1.6800	157.5100	16602.00	0.00	16602.00	100	6	9789	3970	2.46574307304786	0.428594143533174	0.428594143533174	true	false	false	true
692bc1f6-740a-4fb1-91eb-c8281ed8d3e6	2026-10-02 13:20	2026-10-02 13:20	2026-10-02 13:20	SPCX	SPCX261002P00155000	put	155.0000	2026-10-02	0.0700	0.0600	0.0700	157.6173	10808.00	10808.00	0.00	1544	9	123586	3549	34.8227669766131	0.689547000448954	0.689547000448954	false	false	false	true
77036874-7162-4fcc-b9ee-71a4e3144f2f	2026-10-02 13:19	2026-10-02 13:19	2026-10-02 13:19	SPCX	SPCX261009P00150000	put	150.0000	2026-10-09	1.0500	1.0400	1.0500	157.6700	10500.00	10500.00	0.00	100	6	18669	4131	4.51924473493101	0.437481861069655	0.437481861069655	false	false	false	true
f07b32cb-95ab-49ed-b529-f07940717b5b	2026-10-02 13:16	2026-10-02 13:16	2026-10-02 13:16	SPCX	SPCX261002P00157500	put	157.5000	2026-10-02	0.6000	0.5950	0.6100	157.0000	144900.00	0.00	144900.00	2415	11	65545	119	550.798319327731	0.648597520454275	0.668561312730565	true	false	false	true
1cfb55c4-86ba-4c43-9b36-0630b9966bb5	2026-10-02 13:16	2026-10-02 13:16	2026-10-02 13:16	SPCX	SPCX261016P00155000	put	155.0000	2026-10-16	3.9000	3.8500	3.9500	157.0000	27690.00	27300.00	390.00	71	5	4537	10975	0.413394077448747	0.432714082043264	0.432714082043264	false	false	false	true
8a1745e0-85fd-441a-858d-1f3f1991ef63	2026-10-02 13:16	2026-10-02 13:16	2026-10-02 13:16	SPCX	SPCX261002C00157500	call	157.5000	2026-10-02	0.8500	0.8500	0.8700	157.0000	12750.00	0.00	12750.00	150	7	78775	17160	4.59061771561772	0.641393946143949	0.636301787637124	false	false	false	true
71b9bc26-5346-484c-b37b-e70916d136dc	2026-10-02 13:16	2026-10-02 13:15	2026-10-02 13:15	SPCX	SPCX261009C00180000	call	180.0000	2026-10-09	0.1600	0.1600	0.1700	157.0000	10560.00	0.00	10560.00	660	16	4917	15854	0.310142550775829	0.518798011399089	0.518798011399089	false	false	false	true
3b89a8c4-017d-4bef-9d1d-ad05d6c26877	2026-10-02 13:13	2026-10-02 13:13	2026-10-02 13:13	SPCX	SPCX261002C00150000	call	150.0000	2026-10-02	7.6500	7.6000	7.7000	157.0000	466650.00	462825.00	3825.00	610	54	15534	17030	0.912155020551967	1.50581969005781	1.48095018196886	true	false	false	true
fc079bc0-bbb5-4c67-b7bd-433d3f2a9722	2026-10-02 13:12	2026-10-02 13:12	2026-10-02 13:12	SPCX	SPCX261009P00155000	put	155.0000	2026-10-09	2.5300	2.5300	2.5400	157.0000	14674.00	0.00	14674.00	58	9	18674	1391	13.4248741912293	0.429900348932454	0.429900348932454	true	false	false	true
2ff46b14-1136-415c-a69f-e48afcb88dd5	2026-10-02 13:12	2026-10-02 13:12	2026-10-02 13:12	SPCX	SPCX261009P00155000	put	155.0000	2026-10-09	2.5300	2.5300	2.5400	157.0000	16951.00	0.00	16951.00	67	7	18616	1391	13.3831775700935	0.42913241871739	0.42913241871739	true	false	false	true
b7520206-b78a-450f-8e30-6324a0a4b8b5	2026-10-02 13:08	2026-10-02 13:08	2026-10-02 13:08	SPCX	SPCX271217C00160000	call	160.0000	2027-12-17	37.6500	37.1000	37.6500	157.7900	22590.00	22590.00	0.00	6	6	56	745	0.0751677852348993	0.511225196192152	0.511225196192152	false	false	false	true
61b70aad-8c85-4798-9e39-ed74ece52ccc	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPCX	SPCX261016C00155000	call	155.0000	2026-10-16	6.8500	6.8500	6.9000	157.7200	23975.00	0.00	23975.00	35	5	15893	10921	1.45526966395019	0.429123116725097	0.429123116725097	true	false	false	true
0f9ccdb7-0847-4fa9-ab57-119406364810	2026-10-02 13:06	2026-10-02 13:06	2026-10-02 13:06	SPCX	SPCX261016C00155000	call	155.0000	2026-10-16	7.0000	6.9500	7.0000	157.8800	20998.00	20998.00	0.00	30	5	15849	10921	1.45124072887098	0.433568882663773	0.431883668286193	false	false	false	true
f594dd50-3328-4508-bc00-0326faad7b0e	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPCX	SPCX261002P00157500	put	157.5000	2026-10-02	0.5700	0.5600	0.5700	157.9200	11400.00	11400.00	0.00	200	10	58796	119	494.084033613445	0.663744301068761	0.663744301068761	false	false	false	true
0a5c7956-4a3b-4a42-8c90-009f6dfd24fd	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPCX	SPCX261002C00155000	call	155.0000	2026-10-02	3.0000	2.9600	3.0000	157.8900	13500.00	13500.00	0.00	45	6	48776	26239	1.85891230610923	0.791705868118254	0.791705868118254	false	false	false	true
caeb7459-e899-4ff7-86da-45503359e038	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPCX	SPCX261016C00155000	call	155.0000	2026-10-16	6.9800	6.9500	7.0000	157.8999	98418.00	98418.00	0.00	141	13	12949	10921	1.18569728046882	0.430860495276371	0.430860495276371	false	false	false	true
366a6857-ee85-4929-81ec-4e05029fb47b	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPCX	SPCX261002C00160000	call	160.0000	2026-10-02	0.1700	0.1600	0.1700	157.8650	13889.00	13889.00	0.00	817	19	66651	24020	2.7748126561199	0.723348961785458	0.723348961785458	false	false	false	true
9a4bf779-1610-42b9-9a47-0bfaee86c838	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPCX	SPCX261016C00155000	call	155.0000	2026-10-16	6.9000	6.9000	6.9500	157.7640	28290.00	0.00	28290.00	41	7	12808	10921	1.1727863748741	0.431086384145034	0.431086384145034	false	false	false	true
9160a494-e3f5-4ff2-988a-68c7d933f8dc	2026-10-02 13:03	2026-10-02 13:02	2026-10-02 13:02	SPCX	SPCX261002C00157500	call	157.5000	2026-10-02	0.9400	0.9400	0.9600	157.8200	14664.00	0.00	14664.00	156	12	75720	17160	4.41258741258741	0.665435719931957	0.665435719931957	false	false	false	true