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:endpoint = /api/option-trades/flow-alerts×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	expiry

d679871a-5371-4a85-aef8-2f138b971210	2026-10-02 10:21	2026-10-02 10:21	2026-10-02 10:21	SPCX	SPCX270917C00150000	call	150.0000	2027-09-17	36.7300	36.0500	36.7500	157.0000	36730.00	33065.00	3665.00	10	6	30	2696	0.0111275964391691	0.510088118891949	0.509195403275094	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Industrials	1223402841624.00	2026-11-03	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T14:21:45.747207Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
54eac81a-ce4c-4491-a56f-e26f94ec6a4d	2026-10-02 10:21	2026-10-02 10:21	2026-10-02 10:21	SPCX	SPCX261030C00172500	call	172.5000	2026-10-30	3.0600	3.0000	3.1000	157.0000	611504.00	604280.00	7224.00	2000	75	17759	507	35.0276134122288	0.465282755766361	0.470873768518568	false	false	false
eec69b4c-7a88-4478-a36a-420e33cf6ae0	2026-10-02 10:20	2026-10-02 10:20	2026-10-02 10:20	SPCX	SPCX261009P00152500	put	152.5000	2026-10-09	1.9300	1.9200	1.9500	157.0000	26055.00	0.00	26055.00	135	5	3999	3970	1.00730478589421	0.449274660399193	0.449274660399193	false	false	false	true
1dab13c3-156d-4bbc-a636-1a5137f3db54	2026-10-02 10:19	2026-10-02 10:19	2026-10-02 10:19	SPCX	SPCX261009C00160000	call	160.0000	2026-10-09	2.7700	2.7500	2.7800	157.0000	13850.00	13850.00	0.00	50	5	10864	8277	1.31255285731545	0.454488774434704	0.455165589276912	false	false	false
7c512226-cda9-444b-9b2c-68fd91bf713a	2026-10-02 10:19	2026-10-02 10:18	2026-10-02 10:18	SPCX	SPCX261016C00185000	call	185.0000	2026-10-16	0.3400	0.3300	0.3400	157.0000	17000.00	17000.00	0.00	500	12	1407	5494	0.25609756097561	0.498562506041134	0.498562506041134	false	false	false
e9c7745f-f52f-4b1c-982e-04eb11c00c54	2026-10-02 10:18	2026-10-02 10:18	2026-10-02 10:18	SPCX	SPCX270115P00180000	put	180.0000	2027-01-15	29.6500	29.6000	30.2000	157.1000	14825.00	5930.00	8895.00	5	5	14	3191	0.00438733939204011	0.486714456947757	0.486714456947757	false	false	false
2c610b62-9576-4052-96cf-67282f804079	2026-10-02 10:18	2026-10-02 10:18	2026-10-02 10:18	SPCX	SPCX261120C00180000	call	180.0000	2026-11-20	4.3500	4.3500	4.4500	157.0927	36540.00	0.00	36540.00	84	20	3363	4963	0.677614346161596	0.503423659461514	0.503423659461514	false	false	false
e91a2a04-a8d2-46b0-be9b-312493e444c6	2026-10-02 10:18	2026-10-02 10:18	2026-10-02 10:18	SPCX	SPCX261030C00172500	call	172.5000	2026-10-30	3.0500	2.9900	3.1000	157.0850	609953.00	588039.00	17644.00	2001	87	15691	507	30.9487179487179	0.464238399633863	0.468010771363904	false	false	false
8fbc7ca2-b68b-4725-b1ef-1a50982b14de	2026-10-02 10:18	2026-10-02 10:18	2026-10-02 10:18	SPCX	SPCX261016C00157500	call	157.5000	2026-10-16	5.3000	5.2500	5.3500	157.1000	47700.00	47170.00	0.00	90	8	1508	1109	1.35978358881876	0.43798964592117	0.43798964592117	true	false	false	true
dfd2b70a-9f46-4843-8159-c585630ef21d	2026-10-02 10:18	2026-10-02 10:18	2026-10-02 10:18	SPCX	SPCX261023P00144000	put	144.0000	2026-10-23	1.9200	1.8800	1.9200	156.9100	12672.00	12672.00	0.00	66	12	111	248	0.44758064516129	0.453062949235368	0.453062949235368	false	false	false	true
2649be37-95bc-4daf-a517-3fa5be62692c	2026-10-02 10:18	2026-10-02 10:18	2026-10-02 10:18	SPCX	SPCX261009C00160000	call	160.0000	2026-10-09	2.6700	2.6600	2.6800	156.9532	15222.00	804.00	0.00	57	5	10748	8277	1.29853811767549	0.453517005413174	0.452645287640924	false	false	false	true
b12ffa9f-64af-485f-bd00-5698a2a909d6	2026-10-02 10:18	2026-10-02 10:18	2026-10-02 10:18	SPCX	SPCX261009P00144000	put	144.0000	2026-10-09	0.4300	0.4300	0.4400	156.9400	12900.00	0.00	12900.00	300	13	811	1093	0.7419945105215	0.474684393215838	0.474684393215838	false	false	false	true
f12438e1-ee99-4511-b366-256ed5dc7f9b	2026-10-02 10:17	2026-10-02 10:17	2026-10-02 10:17	SPCX	SPCX261002P00160000	put	160.0000	2026-10-02	3.4000	3.3000	3.4000	156.9350	68000.00	68000.00	0.00	200	19	1455	77	18.8961038961039	0.839070686088173	0.839070686088173	false	false	false	true
178cb556-0dca-48bc-adf0-da87e05519f6	2026-10-02 10:17	2026-10-02 10:17	2026-10-02 10:17	SPCX	SPCX261016C00160000	call	160.0000	2026-10-16	4.2500	4.2500	4.3000	157.1700	158950.00	0.00	158950.00	374	6	15708	42370	0.370734009912674	0.439811693378425	0.439811693378425	false	false	false
1e8e33c4-d396-4e30-8aff-32ecabe3c7d8	2026-10-02 10:17	2026-10-02 10:17	2026-10-02 10:17	SPCX	SPCX261016C00165000	call	165.0000	2026-10-16	2.6400	2.6400	2.6500	157.2700	14784.00	0.00	14784.00	56	6	3051	13835	0.220527647271413	0.445493255190652	0.445493255190652	false	false	false
6fe48b1e-a199-4e63-83a8-fcee35cb95e4	2026-10-02 10:17	2026-10-02 10:17	2026-10-02 10:17	SPCX	SPCX270319C00190000	call	190.0000	2027-03-19	10.9000	10.5000	10.9000	157.2114	101370.00	101370.00	0.00	93	23	116	1263	0.0918448139350752	0.487801770266945	0.487801770266945	false	false	false
5177d51b-1cc6-444b-b08f-c8ad691766f6	2026-10-02 10:17	2026-10-02 10:17	2026-10-02 10:17	SPCX	SPCX270115C00175000	call	175.0000	2027-01-15	9.8500	9.7500	9.8500	157.2114	28565.00	28565.00	0.00	29	5	118	2697	0.0437523173896922	0.469131224767964	0.469131224767964	false	false	false
28395dfe-92f0-4cc8-b0b2-38767c2e9888	2026-10-02 10:17	2026-10-02 10:17	2026-10-02 10:17	SPCX	SPCX261009P00150000	put	150.0000	2026-10-09	1.2500	1.2500	1.2600	157.2614	16500.00	0.00	16500.00	132	5	8515	4131	2.06124425078673	0.456400140881801	0.456400140881801	false	false	false	true
043b27e3-6dec-4068-a1af-212f4334ee2a	2026-10-02 10:17	2026-10-02 10:17	2026-10-02 10:17	SPCX	SPCX261016C00162500	call	162.5000	2026-10-16	3.3500	3.3500	3.4000	157.2000	13735.00	0.00	13735.00	41	7	2333	10144	0.229988170347003	0.441674298577495	0.441674298577495	false	false	false
726fecc7-0f39-4537-b43f-671ec7560c32	2026-10-02 10:16	2026-10-02 10:16	2026-10-02 10:16	SPCX	SPCX261016C00162500	call	162.5000	2026-10-16	3.3000	3.2750	3.3500	157.0600	10890.00	0.00	10890.00	33	9	2279	10144	0.224664826498423	0.442009593509642	0.441850351665978	false	false	false
022c5416-bfeb-4273-958f-e41513c5eb47	2026-10-02 10:16	2026-10-02 10:16	2026-10-02 10:16	SPCX	SPCX261016C00162500	call	162.5000	2026-10-16	3.3000	3.3000	3.3500	157.0500	22440.00	0.00	22440.00	68	5	2246	10144	0.22141167192429	0.443123763957564	0.442168816654779	false	false	false
ab9ac807-cdd5-4b3b-8e32-6419e71773fd	2026-10-02 10:16	2026-10-02 10:16	2026-10-02 10:16	SPCX	SPCX261016C00160000	call	160.0000	2026-10-16	4.1500	4.1000	4.1500	156.9300	52705.00	52705.00	0.00	127	17	15238	42370	0.359641255605381	0.440243819438755	0.440243819438755	true	false	false
a73b237f-0f90-4c73-9409-1678210a4bb0	2026-10-02 10:16	2026-10-02 10:16	2026-10-02 10:16	SPCX	SPCX261016C00162500	call	162.5000	2026-10-16	3.2500	3.2500	3.3000	156.9393	25675.00	0.00	25675.00	79	8	2141	10144	0.21106072555205	0.441369728118797	0.441369728118797	false	false	false
30bab8a2-09ae-47a1-bd63-2afdd83eb851	2026-10-02 10:16	2026-10-02 10:16	2026-10-02 10:16	SPCX	SPCX261009P00150000	put	150.0000	2026-10-09	1.3100	1.3000	1.3200	156.9000	19627.00	0.00	2990.00	150	5	8317	4131	2.01331396756233	0.452227573358079	0.453425046002311	false	false	false	true
f2dc368a-9d21-4b8e-a15b-ee7eb8b87416	2026-10-02 10:16	2026-10-02 10:16	2026-10-02 10:16	SPCX	SPCX261009C00150000	call	150.0000	2026-10-09	8.1500	8.1500	8.2500	156.7531	24450.00	0.00	24450.00	30	18	4526	6755	0.670022205773501	0.443765455675817	0.443765455675817	false	false	false
883caf00-520f-47bf-8ae9-9759b24b538d	2026-10-02 10:16	2026-10-02 10:15	2026-10-02 10:15	SPCX	SPCX261120C00175000	call	175.0000	2026-11-20	5.3000	5.3000	5.4000	156.7800	65720.00	0.00	65720.00	124	10	1561	8106	0.192573402417962	0.497698724991019	0.497698724991019	true	false	false
684cea47-ab44-4efc-a5c4-f67fc4853f0c	2026-10-02 10:16	2026-10-02 10:15	2026-10-02 10:15	SPCX	SPCX261120C00250000	call	250.0000	2026-11-20	0.2600	0.2400	0.2600	156.7900	19500.00	19500.00	0.00	750	15	903	1774	0.50901916572717	0.59300484314832	0.59300484314832	false	false	false	true
aeb90aa2-5093-45d3-a450-5d010a337a05	2026-10-02 10:15	2026-10-02 10:15	2026-10-02 10:15	SPCX	SPCX261016C00162500	call	162.5000	2026-10-16	3.2000	3.2000	3.2500	156.8050	23680.00	0.00	23680.00	74	5	2050	10144	0.202089905362776	0.441278490019359	0.441278490019359	false	false	false
f27b76fc-e18f-48fa-b2d4-6007055e23be	2026-10-02 10:15	2026-10-02 10:15	2026-10-02 10:15	SPCX	SPCX270319C00170000	call	170.0000	2027-03-19	16.6000	16.2500	16.9500	156.8391	43170.00	3325.00	1665.00	26	5	41	6193	0.00662037784595511	0.48686129790663	0.485683198730746	false	false	false
f4be1e88-09e2-4cf5-bb7f-add4648166ca	2026-10-02 10:15	2026-10-02 10:15	2026-10-02 10:15	SPCX	SPCX261009C00155000	call	155.0000	2026-10-09	4.9000	4.8500	4.9000	156.8065	21070.00	21070.00	0.00	43	11	13560	8715	1.55593803786575	0.448411012565471	0.448411012565471	false	false	false
7e48392f-fc63-4033-ae38-0fdd36fa9806	2026-10-02 10:14	2026-10-02 10:14	2026-10-02 10:14	SPCX	SPCX270617C00300000	call	300.0000	2027-06-17	3.2500	3.1000	3.2500	156.4600	81245.00	80925.00	320.00	250	12	3755	8546	0.439386847648022	0.518592548877649	0.520549967191873	false	false	false
3e372126-4412-4cae-af85-d2f9b7f8ba37	2026-10-02 10:14	2026-10-02 10:14	2026-10-02 10:14	SPCX	SPCX270617C00300000	call	300.0000	2027-06-17	3.2500	3.1000	3.2500	156.4600	81250.00	81250.00	0.00	250	8	3505	8546	0.410133395740697	0.520549967191873	0.520549967191873	false	false	false
5e0873df-25cf-4649-8120-982d5a08de94	2026-10-02 10:14	2026-10-02 10:14	2026-10-02 10:14	SPCX	SPCX270617C00300000	call	300.0000	2027-06-17	3.2500	3.2000	3.2500	156.6400	81197.00	80875.00	322.00	250	8	3136	8546	0.366955300725486	0.519303453297645	0.518567081034647	false	false	false
73f06bac-28b9-4bfe-8e4c-16f7a39da3bd	2026-10-02 10:14	2026-10-02 10:14	2026-10-02 10:14	SPCX	SPCX270617C00300000	call	300.0000	2027-06-17	3.2500	3.1500	3.2500	156.6360	81250.00	81250.00	0.00	250	7	2885	8546	0.337584835010531	0.519756359593395	0.519756359593395	false	false	false
e0bc653f-e83d-4994-8da1-54c78ce60160	2026-10-02 10:14	2026-10-02 10:14	2026-10-02 10:14	SPCX	SPCX261030P00150000	put	150.0000	2026-10-30	4.8000	4.6500	4.8000	156.5300	14400.00	14400.00	0.00	30	6	369	2418	0.152605459057072	0.461938864564285	0.461938864564285	false	false	false	true
b98770da-82d9-476b-8fa2-60a1e1baf066	2026-10-02 10:14	2026-10-02 10:13	2026-10-02 10:13	SPCX	SPCX261023C00180000	call	180.0000	2026-10-23	1.0500	1.0300	1.0500	156.6750	10395.00	10395.00	0.00	99	7	360	1072	0.335820895522388	0.471619110114504	0.471619110114504	false	false	false
73791183-67d5-484e-9c3e-7efda03721e8	2026-10-02 10:13	2026-10-02 10:13	2026-10-02 10:13	SPCX	SPCX261002P00157500	put	157.5000	2026-10-02	1.7100	1.7100	1.7300	156.6450	10433.00	173.00	10260.00	61	5	5313	119	44.6470588235294	0.782998487529493	0.770092939118434	true	false	false	true
c4bc38dd-8b59-4c52-b4ff-62fd40b16d15	2026-10-02 10:13	2026-10-02 10:13	2026-10-02 10:13	SPCX	SPCX270617C00300000	call	300.0000	2027-06-17	3.2500	3.1500	3.2500	156.6000	81250.00	81250.00	0.00	250	24	2634	8546	0.308214369295577	0.519918618296379	0.519918618296379	false	false	false
b00c001a-cb06-471d-9e5b-428b83265538	2026-10-02 10:13	2026-10-02 10:13	2026-10-02 10:13	SPCX	SPCX270115P00115000	put	115.0000	2027-01-15	2.3700	2.3200	2.3800	156.6100	11139.00	9006.00	474.00	47	18	65	10929	0.00594747918382286	0.525405716191813	0.525473600479451	false	false	false
950c8ccc-4c2a-4435-919e-e8194231481b	2026-10-02 10:13	2026-10-02 10:13	2026-10-02 10:13	SPCX	SPCX261030P00150000	put	150.0000	2026-10-30	4.7000	4.6000	4.7000	156.7100	46999.00	46999.00	0.00	100	11	339	2418	0.140198511166253	0.459423981493607	0.459423981493607	true	false	false	true
bf4cda17-4757-4fb6-9a13-0cf618748a9a	2026-10-02 10:13	2026-10-02 10:13	2026-10-02 10:13	SPCX	SPCX261002C00157500	call	157.5000	2026-10-02	0.8700	0.8700	0.8900	156.6850	28627.00	89.00	28362.00	329	6	36564	17160	2.13076923076923	0.772732042204436	0.779158120476406	false	false	false
6b38f0e1-68d4-4397-af6d-1c72eaa7cb8e	2026-10-02 10:13	2026-10-02 10:13	2026-10-02 10:13	SPCX	SPCX270617C00300000	call	300.0000	2027-06-17	3.2200	3.0500	3.2500	156.6950	16114.00	9714.00	6400.00	50	8	2384	8546	0.278960917388252	0.519490513498254	0.517536275405928	false	false	false
c4089074-6479-425e-87b9-fc6b48525992	2026-10-02 10:13	2026-10-02 10:13	2026-10-02 10:13	SPCX	SPCX261120P00130000	put	130.0000	2026-11-20	2.3200	2.3200	2.3600	156.5500	63800.00	0.00	51040.00	275	8	515	12204	0.0421992789249426	0.526954979639779	0.526954979639779	false	false	false
2af9965f-b4d9-499a-9f7e-2b6af28d632e	2026-10-02 10:13	2026-10-02 10:13	2026-10-02 10:13	SPCX	SPCX261120C00195000	call	195.0000	2026-11-20	2.1100	2.1100	2.1600	156.3600	42250.00	0.00	42250.00	200	16	496	2938	0.168822328114364	0.51810072599661	0.518627043451881	false	false	false
a21d397f-8d7b-428b-8339-7a3299a15630	2026-10-02 10:13	2026-10-02 10:12	2026-10-02 10:12	SPCX	SPCX261023C00152500	call	152.5000	2026-10-23	8.8000	8.7500	9.0000	156.3700	87120.00	0.00	74800.00	99	6	980	1596	0.614035087719298	0.438452335994701	0.438452335994701	true	false	false	true
df2fd4f2-1e46-4fc5-bde7-d0b5b25fcdb7	2026-10-02 10:13	2026-10-02 10:12	2026-10-02 10:12	SPCX	SPCX261023C00152500	call	152.5000	2026-10-23	8.8000	8.7000	8.8000	156.3300	91520.00	91520.00	0.00	104	5	881	1596	0.552005012531328	0.438889376003555	0.440198700450612	false	false	false
a0f0f985-614f-48e9-9b87-165cd562aadd	2026-10-02 10:12	2026-10-02 10:12	2026-10-02 10:12	SPCX	SPCX261120C00140000	call	140.0000	2026-11-20	21.5500	21.4500	21.9000	156.3200	32325.00	0.00	32325.00	15	7	100	2893	0.0345661942620118	0.503654945314988	0.507984311242938	false	false	false
0fed6f4d-799a-4259-b2a6-8fec7ee4930d	2026-10-02 10:12	2026-10-02 10:12	2026-10-02 10:12	SPCX	SPCX261009P00150000	put	150.0000	2026-10-09	1.4300	1.4200	1.4400	156.4202	21592.00	15158.00	142.00	151	13	7814	4131	1.89155168240136	0.45584992472291	0.453301055384525	false	false	false
baa1a3cd-0b17-41c3-a174-3daee71f5a9a	2026-10-02 10:12	2026-10-02 10:12	2026-10-02 10:12	SPCX	SPCX270617C00300000	call	300.0000	2027-06-17	3.2400	3.1000	3.2500	156.4050	32443.00	32443.00	0.00	100	6	2233	8546	0.261291832436228	0.520798146515798	0.520798146515798	false	false	false
b01eed87-424f-4368-9546-1252892636fa	2026-10-02 10:12	2026-10-02 10:12	2026-10-02 10:12	SPCX	SPCX261120C00170000	call	170.0000	2026-11-20	6.6000	6.6000	6.7000	156.4200	16500.00	0.00	16500.00	25	7	1166	7473	0.156028368794326	0.499698976479831	0.499698976479831	false	false	false