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:option_symbol = SPCX261002C00152500×sorted by created_at ↑×

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

dbcb844b-5cfc-4a54-a2f6-57b2a164fb92	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.3300	1.3200	1.3300	150.0000	12363.00	11571.00	792.00	93	13	29661	13776	2.15309233449477	0.52828385423119	0.52828385423119	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	1148594867162.00	2026-11-03	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T14:57:30.283739Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
2665d28a-b3a6-45de-95a1-15960249cd14	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.3600	1.3500	1.3600	150.0000	13600.00	13600.00	0.00	100	17	29767	13776	2.1607868757259	0.530504760633063	0.530504760633063	false	false	false	true
f4a32c8c-ddfc-4a15-aa91-8faa7ad21ba2	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.2800	1.2800	1.2800	149.8292	30848.00	0.00	0.00	241	6	30467	13776	2.21159988385598	0.530715532968632	0.530715532968632	true	false	false	true
28e22e74-67d1-4a26-8cd4-cd59af2360cf	2026-09-30 10:59	2026-09-30 10:58	2026-09-30 10:58	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.2800	1.2700	1.2900	149.8597	22784.00	22656.00	0.00	178	8	30993	13776	2.24978222996516	0.532308277807175	0.528181752061507	false	false	false	true
9ab444cd-fc15-4fad-80e4-d42f3664dbf7	2026-09-30 11:06	2026-09-30 11:06	2026-09-30 11:06	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.2100	1.2100	1.2200	149.5912	12222.00	122.00	12100.00	101	6	32161	13776	2.33456736353078	0.5352835470611	0.532765132346854	false	false	false	true
47c750da-087c-4582-b81b-5c88ce251e0c	2026-09-30 11:12	2026-09-30 11:12	2026-09-30 11:12	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.4300	1.4200	1.4400	150.1900	15292.00	0.00	15292.00	107	7	32708	13776	2.37427409988386	0.533229674280389	0.534290233120882	false	false	false	true
11ca721a-6d84-42ff-b756-bbd47f68dda0	2026-09-30 11:30	2026-09-30 11:30	2026-09-30 11:30	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.3500	1.3500	1.3700	150.0800	16200.00	0.00	16200.00	120	12	34588	13776	2.51074332171893	0.527708564095941	0.526798586179345	false	false	false	true
8d74fc54-59d1-4c8f-8b21-f4472f3ec943	2026-09-30 11:31	2026-09-30 11:31	2026-09-30 11:31	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.4400	1.4300	1.4400	150.3100	28800.00	28800.00	0.00	200	13	34907	13776	2.53389953542393	0.528662116916379	0.528662116916379	false	false	false	true
0029b438-f6f7-4f6a-85dd-086ddab74347	2026-09-30 11:35	2026-09-30 11:35	2026-09-30 11:35	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5800	1.5700	1.5900	150.7250	12956.00	4266.00	158.00	82	5	35746	13776	2.59480255516841	0.524665377291078	0.524665377291078	false	false	false	true
6ca9fe94-5568-476b-8298-b2b75de29596	2026-09-30 11:36	2026-09-30 11:36	2026-09-30 11:36	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5700	1.5700	1.5800	150.7136	31400.00	0.00	31400.00	200	10	36165	13776	2.62521777003484	0.523370140945235	0.523370140945235	false	false	false	true
1d3d7a3d-7cdc-49c9-b4f1-a22283b77def	2026-09-30 12:07	2026-09-30 12:06	2026-09-30 12:06	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5900	1.5900	1.6000	150.9171	26076.00	0.00	26076.00	164	22	39823	13776	2.89075203252033	0.509313195877085	0.509313195877085	false	false	false	true
4341fd85-a1a6-4d5a-8501-23578abe9b22	2026-09-30 12:07	2026-09-30 12:07	2026-09-30 12:07	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7100	1.6900	1.7200	151.1150	55399.00	7006.00	48393.00	324	9	40436	13776	2.93524970963995	0.516057628558635	0.51835008247508	true	false	false	true
eb035bda-b3b3-4f8a-b0fb-cfd23d8f3df3	2026-09-30 12:13	2026-09-30 12:13	2026-09-30 12:13	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7800	1.7700	1.7900	151.3150	12805.00	358.00	12447.00	72	8	41880	13776	3.04006968641115	0.515053971229541	0.512779438601195	false	false	false	true
c902e086-e320-4caf-8ddf-e59bf4a00983	2026-09-30 12:34	2026-09-30 12:34	2026-09-30 12:34	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7300	1.7300	1.7400	151.0000	12456.00	0.00	12456.00	72	8	43673	13776	3.17022357723577	0.509972977755285	0.509972977755285	false	false	false	true
b62d06b0-a8f7-45f1-9610-752b7cb90e4d	2026-09-30 12:54	2026-09-30 12:54	2026-09-30 12:54	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7500	1.7200	1.7700	151.0000	12093.00	12093.00	0.00	69	16	44653	13776	3.24136178861789	0.501569596954487	0.509043150614359	true	false	false	true
b817c503-898c-49c3-9729-2104dedb0954	2026-09-30 12:59	2026-09-30 12:59	2026-09-30 12:59	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7600	1.7500	1.7700	151.3650	10902.00	0.00	10726.00	62	19	44995	13776	3.26618757259001	0.505625457015809	0.50335360567138	true	false	false	true
26b868e7-0c28-4742-bb1d-5a36a32bc92e	2026-09-30 13:01	2026-09-30 13:01	2026-09-30 13:01	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.8200	1.8200	1.8300	151.5000	29120.00	0.00	29120.00	160	13	45310	13776	3.28905342624855	0.505906418775923	0.505906418775923	true	false	false	true
122d176d-e4e2-4645-a04b-48f41f9aee56	2026-09-30 13:14	2026-09-30 13:14	2026-09-30 13:14	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7500	1.7500	1.7700	151.3900	14000.00	0.00	14000.00	80	7	46005	13776	3.33950348432056	0.500907285144491	0.500907285144491	false	false	false	true
ddcfa674-9790-43bf-ad87-aedd9010f302	2026-09-30 13:45	2026-09-30 13:45	2026-09-30 13:45	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.8800	1.8700	1.8900	151.6835	29140.00	0.00	28952.00	155	10	47722	13776	3.46414053426249	0.500980870336199	0.500980870336199	false	false	false	true
4d79c075-418a-4c5a-8f41-99e8ef3d51dd	2026-09-30 13:47	2026-09-30 13:47	2026-09-30 13:47	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0000	1.9900	2.0000	151.9400	35400.00	35400.00	0.00	177	27	48029	13776	3.48642566782811	0.501362357020493	0.501362357020493	false	false	false	true
6fca8773-c849-42a5-baab-872e60d52981	2026-09-30 13:47	2026-09-30 13:47	2026-09-30 13:47	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.9900	1.9800	1.9900	151.8900	13134.00	13134.00	0.00	66	5	48115	13776	3.49266840882695	0.504365712867418	0.504365712867418	false	false	false	true
9361aa59-b271-4b8a-87da-0ab290a6738b	2026-09-30 13:49	2026-09-30 13:49	2026-09-30 13:49	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0500	2.0400	2.0500	152.0600	10660.00	10660.00	0.00	52	11	48674	13776	3.5332462253194	0.49981471577843	0.49981471577843	false	false	false	true
938c9846-9f21-4f0a-9556-fb67be56aac3	2026-09-30 13:51	2026-09-30 13:51	2026-09-30 13:51	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0800	2.0700	2.0800	152.1000	20800.00	20800.00	0.00	100	5	48895	13776	3.54928861788618	0.502221412024309	0.502221412024309	false	false	false	true
5832e98c-2feb-4f92-8ebc-5508ed90b63c	2026-09-30 13:54	2026-09-30 13:54	2026-09-30 13:54	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0800	2.0600	2.1000	152.1400	12689.00	209.00	12480.00	61	7	49339	13776	3.58151858304297	0.497917710652542	0.500145207378717	false	false	false	true
35776db8-e2e3-4bb1-a525-8d7b9a4a7027	2026-09-30 13:55	2026-09-30 13:55	2026-09-30 13:55	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0900	2.0700	2.0900	152.1300	10450.00	10450.00	0.00	50	6	49479	13776	3.59168118466899	0.49744419137393	0.501223347376148	false	false	false	true
74be1ba3-b9af-43eb-8d5c-13a64527a441	2026-09-30 13:56	2026-09-30 13:56	2026-09-30 13:56	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.1200	2.1000	2.1200	152.1800	10375.00	10375.00	0.00	49	12	49573	13776	3.59850464576074	0.499187154848987	0.502498675205378	false	false	false	true
e14c0047-b55c-45cf-95e0-c0bc5463fd52	2026-09-30 13:56	2026-09-30 13:56	2026-09-30 13:56	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0900	2.0900	2.1000	152.1600	45353.00	0.00	45353.00	217	10	49819	13776	3.61636178861789	0.497985046306217	0.497985046306217	false	false	false	true
5372dc49-7ce6-4da4-8f6e-3f16e93daeb9	2026-09-30 13:57	2026-09-30 13:57	2026-09-30 13:57	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.1900	2.1800	2.1900	152.3350	10512.00	10512.00	0.00	48	14	49930	13776	3.62441927990708	0.501082118012249	0.501082118012249	false	false	false	true
8d2c93dc-e95b-4449-a0be-98165e5cdff6	2026-09-30 13:57	2026-09-30 13:57	2026-09-30 13:57	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.2100	2.1700	2.2100	152.3300	11703.00	11485.00	0.00	53	8	50089	13776	3.63596109175377	0.499965639040189	0.506081630993755	true	false	false	true
4e30d2e2-fc9a-4cdb-b952-518b0e88928b	2026-09-30 13:59	2026-09-30 13:59	2026-09-30 13:59	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.2900	2.2800	2.3000	152.5400	15802.00	10311.00	1827.00	69	14	50639	13776	3.6758855981417	0.500618991546101	0.500282381239516	true	false	false	true
6dd18fa6-0af7-464f-9d20-089df0927c8e	2026-09-30 14:00	2026-09-30 13:59	2026-09-30 13:59	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.3000	2.2900	2.3000	152.5600	11040.00	11040.00	0.00	48	6	50742	13776	3.68336236933798	0.500223299647925	0.500223299647925	true	false	false	true
b6c653f4-0946-44ac-b62c-fcb3b2447d13	2026-09-30 14:00	2026-09-30 14:00	2026-09-30 14:00	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.2400	2.2400	2.2500	152.4100	32704.00	0.00	32704.00	146	6	51070	13776	3.7071718931475	0.503846435452539	0.503846435452539	false	false	false	true
d520dadd-a665-4f1c-ba99-225d381e0238	2026-09-30 14:04	2026-09-30 14:04	2026-09-30 14:04	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0500	2.0400	2.0600	152.0601	12300.00	12095.00	0.00	60	8	51771	13776	3.7580574912892	0.499804041831615	0.499804041831615	false	false	false	true
2a349e1d-a64e-45f5-8c21-a6adfe78ac1a	2026-09-30 14:12	2026-09-30 14:12	2026-09-30 14:12	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.8100	1.7900	1.8100	151.5899	36200.00	10498.00	0.00	200	18	52626	13776	3.82012195121951	0.494669026872739	0.494669026872739	true	false	false	true
b816ee70-ca64-42c1-bf09-300e9cd6eb77	2026-09-30 14:31	2026-09-30 14:31	2026-09-30 14:31	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7400	1.7300	1.7400	151.4200	17400.00	17400.00	0.00	100	9	54612	13776	3.96428571428571	0.495695595777997	0.495695595777997	false	false	false	true
6aed38b3-a754-4223-8c5d-76beccd9d2a7	2026-09-30 14:34	2026-09-30 14:34	2026-09-30 14:34	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5500	1.5500	1.5600	151.0150	15500.00	0.00	15500.00	100	5	54914	13776	3.98620789779326	0.4910512346021	0.490958065991868	false	false	false	true
d58675fa-d38d-41cd-8705-7b6fdc89bc21	2026-09-30 14:41	2026-09-30 14:41	2026-09-30 14:41	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6100	1.6000	1.6100	151.1800	10787.00	10787.00	0.00	67	7	55300	13776	4.01422764227642	0.48923982706598	0.48923982706598	true	false	false	true
fca7edb5-8326-4d6e-be40-70ac1501c9c4	2026-09-30 14:51	2026-09-30 14:51	2026-09-30 14:51	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6600	1.6600	1.6700	151.0000	11454.00	0.00	11454.00	69	6	56166	13776	4.07709059233449	0.484431550752151	0.484431550752151	false	false	false	true
7b970cd6-29e1-43a1-80f0-dd7bdee07a83	2026-09-30 15:40	2026-09-30 15:40	2026-09-30 15:40	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.8700	1.8600	1.8800	151.8790	143990.00	143242.00	0.00	770	15	59998	13776	4.35525551684088	0.478655988628	0.478655988628	true	false	false	true
b60a8af9-1f29-495f-89e4-daa273c15226	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6200	1.6000	1.6200	151.2700	16200.00	16200.00	0.00	100	10	62015	13776	4.50166957026713	0.482935638466183	0.482935638466183	false	false	false	true
01c39812-f932-4206-b648-b07c24b8a13d	2026-10-01 09:30	2026-10-01 09:30	2026-10-01 09:30	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6500	1.6500	1.7900	151.8300	17663.00	173.00	17490.00	107	23	186	15516	0.0119876256767208	0.636285120899857	0.616688248105844	false	false	false	true
462a7d54-cd5c-4142-9f84-2d3d6c9f0a3d	2026-10-01 09:31	2026-10-01 09:30	2026-10-01 09:30	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6500	1.6200	1.7000	151.5400	10725.00	165.00	10560.00	65	8	324	15516	0.0208816705336427	0.61956507002443	0.657761152104436	false	false	false	true
3c89eccd-8c2e-40c6-b05d-6e0cc9aa8d28	2026-10-01 09:31	2026-10-01 09:31	2026-10-01 09:31	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6000	1.5600	1.6100	151.6734	22240.00	22080.00	160.00	139	5	743	15516	0.0478860531064707	0.623080638549685	0.623080638549685	false	false	false	true
19d05b49-b8c9-4227-8d1f-48385a33f3dc	2026-10-01 09:33	2026-10-01 09:33	2026-10-01 09:33	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5400	1.5400	1.5800	151.6100	10780.00	0.00	10780.00	70	5	1389	15516	0.0895204949729312	0.61278775705318	0.61278775705318	false	false	false	true
6f11bca1-33e2-49f6-8cc9-52cad8277114	2026-10-01 09:36	2026-10-01 09:35	2026-10-01 09:35	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.8800	1.8600	1.8800	152.2700	18800.00	18800.00	0.00	100	9	2620	15516	0.168857953080691	0.622265622525393	0.623806474737888	false	false	false	true
6245fe1f-45da-4789-a418-48501c120dfd	2026-10-01 09:40	2026-10-01 09:40	2026-10-01 09:40	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5100	1.5100	1.5400	151.6400	15705.00	0.00	15705.00	104	5	4195	15516	0.270366073730343	0.603850341945551	0.599005195869923	false	false	false	true
17de1f87-b449-4f1a-858b-3e1252d8f8ae	2026-10-01 09:57	2026-10-01 09:57	2026-10-01 09:57	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6000	1.5900	1.6100	151.8950	32000.00	31520.00	0.00	200	11	8939	15516	0.576114978087136	0.589985819938074	0.591434485044197	false	false	false	true
dfe2a187-5ce3-46ed-9788-d0d5e4cb6d56	2026-10-01 09:59	2026-10-01 09:58	2026-10-01 09:58	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5800	1.5700	1.5800	151.8650	17370.00	15800.00	1570.00	110	10	9782	15516	0.630445991234854	0.589420364398971	0.586245439604366	false	false	false	true
60e3dbb7-408a-4c84-8c3c-496e7d54d9fb	2026-10-01 10:02	2026-10-01 10:02	2026-10-01 10:02	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.4200	1.4000	1.4300	151.6000	29821.00	29821.00	0.00	210	6	10902	15516	0.702629543696829	0.57571451300273	0.578923366282411	false	false	false	true
8f4d5899-da9b-4e6f-ada1-1fb89c432af5	2026-10-01 10:09	2026-10-01 10:09	2026-10-01 10:09	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7900	1.7700	1.7900	152.0000	10740.00	10740.00	0.00	60	8	12715	15516	0.819476669244651	0.592567098172985	0.592567098172985	false	false	false	true