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

e38e107b-9bf5-4009-a615-7ab7e9319f76	2026-09-29 09:33	2026-09-29 09:33	2026-09-29 09:33	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	0.9600	0.9600	0.9900	146.3250	24000.00	0.00	24000.00	250	35	473	10655	0.0443923040825903	0.575477048024304	0.575477048024304	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	1148594867162.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T13:35:17.817749Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
9c383fc5-91fa-412c-ad05-7071ee2bb408	2026-09-29 09:35	2026-09-29 09:35	2026-09-29 09:35	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.0300	1.0100	1.0500	146.6600	11800.00	102.00	4488.00	115	5	715	10655	0.0671046457062412	0.571289994403792	0.57373298010517	false	false	false	true
aaba2666-e89b-4a37-bbf9-c6c9334c5080	2026-09-29 09:42	2026-09-29 09:42	2026-09-29 09:42	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	0.9400	0.9400	0.9500	146.4050	27730.00	0.00	27730.00	295	10	1407	10655	0.132050680431722	0.565921302864194	0.565921302864194	true	false	false	true
45c9ca76-8c61-4680-aa2d-0b7a0a440672	2026-09-29 10:32	2026-09-29 10:32	2026-09-29 10:32	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.0100	1.0000	1.0100	147.1400	11514.00	11514.00	0.00	114	6	4028	10655	0.378038479587048	0.542847769571267	0.541103819731133	false	false	false	true
9a7ab701-a242-499f-8cb7-ccc4f5c03413	2026-09-29 10:32	2026-09-29 10:32	2026-09-29 10:32	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.0300	1.0100	1.0300	147.1600	51500.00	51500.00	0.00	500	27	4538	10655	0.425903331769122	0.544719947364437	0.544719947364437	true	false	false	true
2a6ae83d-7f74-4d95-8dd6-9d8238900387	2026-09-29 10:46	2026-09-29 10:46	2026-09-29 10:46	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.2500	1.2400	1.2600	148.0200	26751.00	2626.00	0.00	214	12	5914	10655	0.555044580009385	0.548141223990775	0.545363442753964	false	false	false	true
c4b7a302-d62c-4971-8a7e-e43622a81636	2026-09-29 10:47	2026-09-29 10:47	2026-09-29 10:47	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7800	1.7800	1.8000	149.3600	35600.00	0.00	35600.00	200	12	6629	10655	0.622149225715626	0.564663406140678	0.564663406140678	false	false	false	true
20ae8b34-f73d-49d6-90fe-e18e87551ab8	2026-09-29 10:48	2026-09-29 10:47	2026-09-29 10:47	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.9100	1.8800	1.9200	149.6400	17190.00	16999.00	191.00	90	19	6833	10655	0.641295166588456	0.57212367387672	0.570321430508451	true	false	false	true
eadc8357-40ef-4193-82ad-0abbc92392d0	2026-09-29 10:48	2026-09-29 10:48	2026-09-29 10:48	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.9100	1.9100	1.9300	149.6600	23516.00	772.00	22552.00	123	19	7382	10655	0.692820272172689	0.57278093357813	0.570829917452877	true	false	false	true
360f7303-7f1f-403a-bcf3-f9d581bde949	2026-09-29 10:48	2026-09-29 10:48	2026-09-29 10:48	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.9400	1.9400	1.9600	149.7100	47535.00	781.00	46754.00	245	12	7863	10655	0.737963397465978	0.571135767940974	0.574998226697288	false	false	false	true
41d18447-98d2-4758-a01a-b3aacd86707f	2026-09-29 10:48	2026-09-29 10:48	2026-09-29 10:48	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.9900	1.9600	2.0100	149.8600	155899.00	155499.00	0.00	784	19	8648	10655	0.811637728765838	0.571840186606107	0.57178751719438	false	false	false	true
6d41af4b-73bf-403b-b900-ae2d360ca1f1	2026-09-29 10:49	2026-09-29 10:48	2026-09-29 10:48	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0000	1.9900	2.0200	149.8056	18000.00	0.00	18000.00	90	5	8899	10655	0.835194744251525	0.575780679492545	0.575780679492545	false	false	false	true
ca7e74ba-c395-4150-9e9e-156909500623	2026-09-29 10:52	2026-09-29 10:52	2026-09-29 10:52	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6500	1.6200	1.6600	148.9450	11382.00	0.00	11382.00	69	12	10285	10655	0.965274519005162	0.565341707842573	0.561156870807379	true	false	false	true
7ec4baba-a21c-40d4-9ea0-f67e3fd0f820	2026-09-29 10:53	2026-09-29 10:53	2026-09-29 10:53	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5900	1.5800	1.6000	148.8762	23346.00	0.00	13965.00	147	8	10476	10655	0.983200375410605	0.559682103454902	0.557633501442698	false	false	false	true
bbbd49ee-d5d7-4816-80be-6db87e8d39a6	2026-09-29 10:56	2026-09-29 10:56	2026-09-29 10:56	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5000	1.4900	1.5000	148.0000	25800.00	25800.00	0.00	172	5	11050	10655	1.03707179727827	0.551565357093484	0.551565357093484	false	false	false	true
f027746e-0966-40e9-a0f2-57cf955c2f05	2026-09-29 11:17	2026-09-29 11:17	2026-09-29 11:17	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.3000	1.2900	1.3000	148.2600	18590.00	18590.00	0.00	143	7	12908	10655	1.21145002346316	0.539001422234827	0.539001422234827	false	false	false	true
b2d12207-df62-441b-bd10-12518262f62a	2026-09-29 11:18	2026-09-29 11:18	2026-09-29 11:18	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.3900	1.3700	1.4000	148.4900	28220.00	28220.00	0.00	203	7	13141	10655	1.23331769122478	0.543552094960341	0.545670839595155	false	false	false	true
c9bd53c9-98cb-4bb8-90d0-382347a18871	2026-09-29 11:19	2026-09-29 11:19	2026-09-29 11:19	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.4100	1.3900	1.4200	148.5113	42018.00	41877.00	0.00	298	11	13736	10655	1.28916001877053	0.54583948795056	0.546404572552149	false	false	false	true
7296ab5e-c336-4b4b-b9c9-2f5d756dbf3d	2026-09-29 11:22	2026-09-29 11:22	2026-09-29 11:22	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5200	1.4800	1.5200	148.8800	32661.00	32511.00	0.00	215	11	14478	10655	1.35879868606288	0.540929946517856	0.545052381979592	true	false	false	true
6750d4ae-aa08-4bd2-b9c4-995f5d259306	2026-09-29 11:24	2026-09-29 11:24	2026-09-29 11:24	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6000	1.5300	1.6500	149.2000	20838.00	19238.00	1600.00	130	15	14679	10655	1.3776630689817	0.549880044269363	0.549806966720039	false	false	false	true
1082e7e5-d22b-4d4c-8ce1-e561eb37deea	2026-09-29 11:25	2026-09-29 11:25	2026-09-29 11:25	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.3800	1.3800	1.4100	148.0000	26635.00	139.00	26496.00	193	28	15114	10655	1.41848897231347	0.540791143451063	0.541430997584562	true	false	false	true
98abab32-8f75-4444-9e7c-c897f1886442	2026-09-29 11:27	2026-09-29 11:27	2026-09-29 11:27	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.3800	1.3800	1.3900	148.5150	17235.00	0.00	17235.00	125	19	15323	10655	1.43810417644298	0.539814737865031	0.539814737865031	true	false	false	true
7419928e-e3fd-402e-9d8d-f9cf9d83d305	2026-09-29 11:32	2026-09-29 11:32	2026-09-29 11:32	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5300	1.5200	1.5300	149.0000	11475.00	11475.00	0.00	75	6	15965	10655	1.4983575786016	0.537711443692869	0.537711443692869	false	false	false	true
afb403fd-203e-49e5-bc74-4b3c0c691da2	2026-09-29 11:32	2026-09-29 11:32	2026-09-29 11:32	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5700	1.5700	1.6000	149.0000	78523.00	0.00	74889.00	500	36	16471	10655	1.54584702017832	0.537400992073417	0.539780491068876	true	false	false	true
d08c6648-b064-45ac-9c3a-42cfdc08b133	2026-09-29 11:38	2026-09-29 11:38	2026-09-29 11:38	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7100	1.6900	1.7100	149.3500	25649.00	25649.00	0.00	150	13	17505	10655	1.64289066166119	0.550136480419526	0.551434720403371	false	false	false	true
b502c5c7-56a1-41d0-8465-7a3602241bf2	2026-09-29 12:57	2026-09-29 12:57	2026-09-29 12:57	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.3900	1.3900	1.4000	148.0000	37947.00	0.00	37947.00	273	19	22281	10655	2.09113092444862	0.538691875317462	0.538691875317462	false	false	false	true
88736111-e90a-49c4-bb25-90cc90c0dc5b	2026-09-29 13:36	2026-09-29 13:35	2026-09-29 13:35	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5100	1.5100	1.5300	149.1400	67195.00	0.00	67195.00	445	8	23869	10655	2.24016893477241	0.525533747061436	0.525533747061436	false	false	false	true
3aa3d3d2-2019-4a4d-9e97-87647d8c5a40	2026-09-29 13:36	2026-09-29 13:36	2026-09-29 13:36	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.4800	1.4800	1.5000	149.1100	11100.00	0.00	11100.00	75	5	23950	10655	2.24777099953074	0.521424697996234	0.521424697996234	false	false	false	true
a861a836-e0cc-44b7-a2a7-af8ee8fd24ec	2026-09-29 14:44	2026-09-29 14:44	2026-09-29 14:44	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.1900	1.1800	1.1900	148.1400	11900.00	11900.00	0.00	100	10	25470	10655	2.39042702956359	0.522465698197519	0.522465698197519	false	false	false	true
5e84c728-4c52-41fb-baa5-d8516eeab6e6	2026-09-29 15:48	2026-09-29 15:48	2026-09-29 15:48	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5000	1.4900	1.5100	149.3300	16650.00	7950.00	0.00	111	10	27687	10655	2.5984983575786	0.510622470340721	0.510622470340721	false	false	false	true
695f3e86-deed-4bd6-8480-66c04d25e5dc	2026-09-29 15:51	2026-09-29 15:51	2026-09-29 15:51	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6800	1.6700	1.6900	149.7999	49728.00	49224.00	504.00	296	32	28203	10655	2.6469263256687	0.513808448591944	0.513815560113644	false	false	false	true
fdc464a0-48da-4425-aa5d-7a6c18883007	2026-09-29 15:52	2026-09-29 15:52	2026-09-29 15:52	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7300	1.7200	1.7300	149.9000	83040.00	83040.00	0.00	480	14	28769	10655	2.70004692632567	0.516450354596486	0.516450354596486	false	false	false	true
f271bf4e-3efb-4844-90c8-3e421733effc	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.7500	1.7300	1.7500	149.8700	38489.00	38489.00	0.00	220	5	29274	10655	2.74744251525106	0.520558329408455	0.522511142619104	false	false	false	true
dd10d8ed-fb3f-4ca5-9d4c-7b50381df4bc	2026-09-30 09:55	2026-09-30 09:55	2026-09-30 09:55	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.5800	1.5800	1.6000	150.3650	33970.00	0.00	33970.00	215	6	3726	13776	0.270470383275261	0.557111087797475	0.557111087797475	false	false	false	true
2ccac12e-00fa-4ad2-af41-24e8cca548a1	2026-09-30 10:06	2026-09-30 10:06	2026-09-30 10:06	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.6700	1.6600	1.6700	150.6700	35060.00	33400.00	1660.00	210	20	6283	13776	0.456083042973287	0.548855886547485	0.54836001727399	true	false	false	true
acb00963-5954-44c5-842f-f483acde3300	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.8600	1.8400	1.8600	151.1600	15594.00	11718.00	2026.00	84	22	8173	13776	0.593278164924506	0.546048445914159	0.54833038522897	true	false	false	true
8a6759a7-6db8-4285-a6be-683d9c820383	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.8600	1.8300	1.8700	151.1650	13577.00	13020.00	371.00	73	9	8089	13776	0.587180603948897	0.545564972018295	0.547846568134984	false	false	false	true
9f014454-c625-42d4-b0de-038dcb53b992	2026-09-30 10:12	2026-09-30 10:12	2026-09-30 10:12	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.9000	1.9000	1.9200	151.0000	38199.00	768.00	37240.00	201	18	8723	13776	0.633202671312427	0.546723841777718	0.551268848195735	true	false	false	true
a951ea7a-c768-4069-958e-ef633f2b616c	2026-09-30 10:12	2026-09-30 10:12	2026-09-30 10:12	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.9300	1.9100	1.9300	151.0000	10228.00	10036.00	192.00	53	6	8962	13776	0.650551684088269	0.552559393524864	0.552569212033502	false	false	false	true
290871b7-7a34-43da-9305-d9cebb71058c	2026-09-30 10:13	2026-09-30 10:13	2026-09-30 10:13	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0000	1.9900	2.0100	151.0000	19998.00	18002.00	996.00	100	31	9652	13776	0.700638792102207	0.548272985343443	0.55132562004048	true	false	false	true
15499bce-72fa-48dd-90b9-37936a97a835	2026-09-30 10:17	2026-09-30 10:16	2026-09-30 10:16	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.9800	1.9700	1.9800	151.4700	20790.00	20790.00	0.00	105	5	12714	13776	0.922909407665505	0.54505328521857	0.54505328521857	false	false	false	true
7b36ef79-dbf3-42f2-80eb-e90d6d1502e9	2026-09-30 10:18	2026-09-30 10:18	2026-09-30 10:18	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0400	2.0100	2.0600	151.6350	15875.00	0.00	15875.00	78	7	13161	13776	0.955357142857143	0.540565863464626	0.537398897031418	false	false	false	true
79ae253b-837b-4b97-9de2-cf7277e06f76	2026-09-30 10:20	2026-09-30 10:20	2026-09-30 10:20	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.1000	2.0900	2.1200	151.7900	17010.00	16590.00	210.00	81	8	13677	13776	0.992813588850174	0.540444659883021	0.539406610972529	false	false	false	true
28a18e5a-cc0f-4605-b38c-d8abbf036968	2026-09-30 10:20	2026-09-30 10:20	2026-09-30 10:20	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.1300	2.1000	2.1500	151.8200	12355.00	4046.00	8309.00	58	9	13949	13776	1.01255807200929	0.54001094276356	0.540763852652572	true	false	false	true
a9a90eb7-d6c7-4063-b629-4e75711cc1e6	2026-09-30 10:23	2026-09-30 10:23	2026-09-30 10:23	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.2500	2.1900	2.2600	152.0800	26273.00	26273.00	0.00	117	15	14992	13776	1.08826945412311	0.548807910825027	0.544487529992016	false	false	false	true
9a8af357-8f2b-4ec3-bdf6-6a555ab888b9	2026-09-30 10:26	2026-09-30 10:26	2026-09-30 10:26	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.3000	2.2900	2.3000	152.1800	40710.00	40710.00	0.00	177	9	16374	13776	1.18858885017422	0.542568993350092	0.542568993350092	false	false	false	true
267e325d-480b-48b2-a042-c9ee0b942b81	2026-09-30 10:34	2026-09-30 10:34	2026-09-30 10:34	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0900	2.0800	2.1100	151.8300	10241.00	0.00	10032.00	49	10	18015	13776	1.30770905923345	0.533005366452615	0.533005366452615	true	false	false	true
09ceb8c1-58d2-427a-8179-3b8378cc5113	2026-09-30 10:34	2026-09-30 10:34	2026-09-30 10:34	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	2.0900	2.0800	2.0900	151.8200	22572.00	22572.00	0.00	108	10	18156	13776	1.31794425087108	0.53404719804018	0.53404719804018	true	false	false	true
d46ab8d8-49d0-4c8e-b233-19d6fe0c4110	2026-09-30 10:34	2026-09-30 10:34	2026-09-30 10:34	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.9900	1.9800	2.0200	151.5900	14714.00	1001.00	13713.00	74	14	18306	13776	1.32883275261324	0.534640728307898	0.537472800437408	true	false	false	true
6662b432-95c1-4050-9c18-7f593d203002	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	SPCX	SPCX261002C00152500	call	152.5000	2026-10-02	1.3000	1.2900	1.3100	149.0000	1075230.00	7800.00	1067430.00	8271	24	29562	13776	2.14590592334495	0.526111563906407	0.526111563906407	false	false	false	true