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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×ticker = CAT×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	expiry

f9fa1060-d1d8-4173-a309-c7983ae01543	2026-08-17 10:45	2026-08-17 10:45	2026-08-17 10:45	CAT	CAT270319C00960000	call	960.0000	2027-03-19	87.1500	86.3000	88.3500	873.3100	87145.00	17435.00	34870.00	10	10	13	52	0.25	0.423874061510237	0.42331084586329	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Industrials	360385112976.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6c764c85-f39e-42ac-b022-11873b9a8486	2026-08-19 15:08	2026-08-19 15:08	2026-08-19 15:08	CAT	CAT261218P00840000	put	840.0000	2026-12-18	87.8300	85.8500	88.0500	810.9950	158100.00	96710.00	61390.00	18	6	37	224	0.165178571428571	0.418659822733283	0.41678020564538	false	false	false	true
c1939680-6b41-4532-8b3d-822c3ee38768	2026-08-20 10:48	2026-08-20 10:48	2026-08-20 10:48	CAT	CAT260918P00770000	put	770.0000	2026-09-18	14.6000	13.2000	14.6000	816.1000	150371.00	150371.00	0.00	103	37	103	289	0.356401384083045	0.374963905716451	0.374963905716451	false	false	false	true
0895cd44-5b33-4339-9bf6-a481a1c92524	2026-08-21 11:12	2026-08-21 11:12	2026-08-21 11:12	CAT	CAT261016C00730000	call	730.0000	2026-10-16	107.0200	103.8500	109.4000	817.8600	181930.00	74930.00	107000.00	17	8	18	8	2.25	0.397097421019868	0.393732200672861	false	false	false	true
00b9718a-9204-4d66-9d87-4d93ceb6a98c	2026-08-21 14:35	2026-08-21 14:35	2026-08-21 14:35	CAT	CAT270115P00760000	put	760.0000	2027-01-15	48.4600	48.0500	50.0500	829.6950	576615.00	285920.00	285855.00	119	8	132	279	0.473118279569892	0.416986250837231	0.416713205416288	true	false	false	true
214a5aee-d330-470b-ae04-8a904d8f84a4	2026-08-24 11:18	2026-08-24 11:18	2026-08-24 11:18	CAT	CAT261120P00660000	put	660.0000	2026-11-20	13.5500	12.3500	13.9000	806.5200	108365.00	89430.00	17585.00	80	28	83	151	0.549668874172185	0.437712491013036	0.434283290535972	true	false	false	true
fed7cccd-ce48-4292-bff3-d28254e3c710	2026-08-24 14:58	2026-08-24 14:58	2026-08-24 14:58	CAT	CAT261016P00750000	put	750.0000	2026-10-16	19.8400	19.2000	20.3000	811.1600	228121.00	146886.00	81235.00	115	12	171	936	0.182692307692308	0.382381508289316	0.382381508289316	false	false	false	true
bca8a440-775f-4950-8b1c-afb0c0d28294	2026-08-25 09:47	2026-08-25 09:47	2026-08-25 09:47	CAT	CAT261016P00930000	put	930.0000	2026-10-16	124.0500	121.4000	126.8500	815.7400	136455.00	74545.00	61910.00	11	5	23	17	1.35294117647059	0.402188534632431	0.39839587435594	false	false	false	true
74692654-5910-4d20-b9ef-116bee12b5c3	2026-08-27 14:04	2026-08-27 14:04	2026-08-27 14:04	CAT	CAT260904C00820000	call	820.0000	2026-09-04	15.6500	15.0500	16.5000	815.8100	81355.00	72055.00	9300.00	52	7	412	39	10.5641025641026	0.361374600871309	0.357217726946425	false	false	false	true
03bd1f0d-7bce-43e8-9798-9a14e0fdc13a	2026-08-28 10:59	2026-08-28 10:59	2026-08-28 10:59	CAT	CAT261016P00890000	put	890.0000	2026-10-16	94.5300	92.2000	96.5000	807.0400	56720.00	56720.00	0.00	6	6	6	65	0.0923076923076923	0.364663865623957	0.362597068754928	true	false	false	true
55ada164-94ef-4831-85e5-8470db106bb3	2026-08-28 11:04	2026-08-28 11:03	2026-08-28 11:03	CAT	CAT261016P00880000	put	880.0000	2026-10-16	86.8600	84.0000	88.0500	807.5100	182400.00	182400.00	0.00	21	11	52	160	0.325	0.366427218669073	0.366915903897945	true	false	false	true
daa4c8c8-dfc8-4684-a523-11dcf7c2353e	2026-08-28 13:27	2026-08-28 13:27	2026-08-28 13:27	CAT	CAT261016P00870000	put	870.0000	2026-10-16	83.1400	80.9000	83.6500	801.7150	133030.00	133030.00	0.00	16	6	55	124	0.443548387096774	0.362535550878659	0.361076481835531	true	false	false	true
db86e2ba-9f79-412f-9f16-b632b9e3ec1b	2026-08-28 13:55	2026-08-28 13:55	2026-08-28 13:55	CAT	CAT271217C00960000	call	960.0000	2027-12-17	113.3300	107.9000	113.5500	802.5500	340000.00	204145.00	135855.00	30	15	32	54	0.592592592592593	0.417825962327909	0.417005246876205	false	false	false
de531e58-9ea8-40b8-a15c-26b9fd3b6bcb	2026-08-28 15:38	2026-08-28 15:38	2026-08-28 15:38	CAT	CAT280121C00800000	call	800.0000	2028-01-21	176.5800	174.1000	176.6000	801.6450	176580.00	176580.00	0.00	10	10	51	174	0.293103448275862	0.417595324701661	0.417595324701661	false	false	false	true
dfecb6c0-b964-44b2-a508-96592aa9bc28	2026-08-31 09:38	2026-08-31 09:38	2026-08-31 09:38	CAT	CAT270115C00720000	call	720.0000	2027-01-15	122.7700	122.2500	127.4000	793.8150	1350470.00	1227520.00	122950.00	110	9	1610	145	11.1034482758621	0.399059094660469	0.397225415317629	false	false	false
d42d2751-d226-4383-935e-546c373b7e76	2026-09-01 09:57	2026-09-01 09:57	2026-09-01 09:57	CAT	CAT270115C00850000	call	850.0000	2027-01-15	51.4400	51.4000	54.0500	781.3400	66870.00	5150.00	61720.00	13	8	29	687	0.0422125181950509	0.386716278052016	0.387618730201793	false	false	false	true
1a552886-f683-4059-8057-022244a87ed1	2026-09-01 15:08	2026-09-01 15:08	2026-09-01 15:08	CAT	CAT260918C00700000	call	700.0000	2026-09-18	83.3500	79.2000	86.0000	779.3850	83352.00	83352.00	0.00	10	6	12	378	0.0317460317460317	0.387831516778646	0.385979640940401	false	false	false	true
3359861e-9c83-4136-8be8-4e0572e8c598	2026-09-01 15:09	2026-09-01 15:08	2026-09-01 15:08	CAT	CAT260904P00790000	put	790.0000	2026-09-04	17.2800	17.2000	18.4000	779.4400	103695.00	0.00	103695.00	60	7	678	790	0.858227848101266	0.405817742677416	0.403938700908394	false	false	false	true
027a00a2-b18a-4a2a-ae6f-65f176566ade	2026-09-02 13:00	2026-09-02 13:00	2026-09-02 13:00	CAT	CAT270917P00840000	put	840.0000	2027-09-17	146.1300	145.4500	152.8500	784.7300	160738.00	0.00	160738.00	11	8	11	0	0	0.428225540069827	0.428225540069827	false	false	false	true
fb73079f-f650-4528-af89-3ce952c75d33	2026-09-02 13:03	2026-09-02 13:03	2026-09-02 13:03	CAT	CAT270917P00840000	put	840.0000	2027-09-17	145.6000	145.4500	152.8500	785.2100	160158.00	0.00	160158.00	11	6	22	0	0	0.427171934515712	0.427171934515712	false	false	false	true
d049a320-9248-46f1-8a11-a1a4aec71c82	2026-09-03 09:35	2026-09-03 09:35	2026-09-03 09:35	CAT	CAT261120P00730000	put	730.0000	2026-11-20	30.5900	29.2500	31.1500	786.8100	110135.00	58580.00	51555.00	36	11	38	239	0.158995815899582	0.409926610705667	0.403767304719436	false	false	false	true
2ee96406-05b0-4cfa-a6fd-f5e78c0f9a02	2026-09-04 09:43	2026-09-04 09:43	2026-09-04 09:43	CAT	CAT260925P00770000	put	770.0000	2026-09-25	11.0700	10.7500	12.9500	812.5450	78605.00	22010.00	56595.00	71	10	82	83	0.987951807228916	0.369352446946224	0.362049025409557	true	false	false	true
c53c1459-f7f8-4a5a-a8a7-e3801fda83c0	2026-09-04 09:58	2026-09-04 09:58	2026-09-04 09:58	CAT	CAT270115C01000000	call	1000.0000	2027-01-15	26.2400	25.5000	26.8000	820.1751	68230.00	50025.00	18205.00	26	6	55	1475	0.0372881355932203	0.389965678046712	0.393112497716361	true	false	false	true
af78dde1-baa6-4d06-a7c9-3bb29c0f98a1	2026-09-04 09:59	2026-09-04 09:59	2026-09-04 09:59	CAT	CAT260911P00805000	put	805.0000	2026-09-11	9.7900	9.3000	10.7500	820.4500	67560.00	25900.00	31660.00	69	11	102	58	1.75862068965517	0.374735115132388	0.374735115132388	true	false	false	true
db59651f-ac1c-4209-a12d-15db91bc8a42	2026-09-04 10:04	2026-09-04 10:04	2026-09-04 10:04	CAT	CAT261023P00695000	put	695.0000	2026-10-23	5.3200	5.1000	6.7500	817.9350	95690.00	31575.00	63075.00	180	8	316	0	0	0.36988018372852	0.368894008095723	true	false	false	true
1bf61e60-cf87-4e2c-806e-689b53698aaf	2026-09-04 15:53	2026-09-04 15:53	2026-09-04 15:53	CAT	CAT280121C01360000	call	1360.0000	2028-01-21	45.5400	45.1000	51.8000	811.8300	414395.00	13740.00	400655.00	91	8	319	626	0.509584664536741	0.414986611787109	0.412980524312146	false	false	false
413d9bfe-51d8-4aae-9c6c-3445d62055e9	2026-09-08 11:40	2026-09-08 11:40	2026-09-08 11:40	CAT	CAT261120C00820000	call	820.0000	2026-11-20	68.0600	63.5000	68.1500	826.4500	217805.00	156515.00	61290.00	32	5	34	76	0.447368421052632	0.420768643790074	0.420424172771089	false	false	false	true
0eeb654c-62e0-44dd-9afa-2f3210e20c88	2026-09-08 13:57	2026-09-08 13:56	2026-09-08 13:56	CAT	CAT270115C00920000	call	920.0000	2027-01-15	48.6900	46.1500	49.3000	827.8200	993270.00	779060.00	214210.00	204	15	207	965	0.214507772020725	0.401529418839639	0.400738213579813	false	false	false
939cbaac-cf7b-4c3b-8c49-56e683c7678a	2026-09-10 09:48	2026-09-10 09:48	2026-09-10 09:48	CAT	CAT261016P00860000	put	860.0000	2026-10-16	71.8300	70.8000	73.3500	803.6375	122115.00	79065.00	43050.00	17	5	29	139	0.20863309352518	0.383984088773447	0.381208846946121	false	false	false	true
8e238201-b4fe-45f8-b802-a1b15e8f1628	2026-09-10 09:52	2026-09-10 09:52	2026-09-10 09:52	CAT	CAT261016P00830000	put	830.0000	2026-10-16	53.5800	52.1000	54.3500	799.5500	107150.00	32130.00	75020.00	20	6	24	106	0.226415094339623	0.377195065427875	0.378218472481375	false	false	false	true
99d24197-a6bb-4ab7-81be-4ea7d2c0ccd4	2026-09-10 14:41	2026-09-10 14:41	2026-09-10 14:41	CAT	CAT280121C00940000	call	940.0000	2028-01-21	122.3700	119.0500	124.9500	804.4350	611870.00	611870.00	0.00	50	6	50	96	0.520833333333333	0.418632502099033	0.418632502099033	false	false	false	true
64c49359-b991-4e7c-9fdd-57a7cb4558c8	2026-09-10 14:41	2026-09-10 14:41	2026-09-10 14:41	CAT	CAT280121C00940000	call	940.0000	2028-01-21	121.8000	119.0500	124.9500	803.5710	608998.00	244060.00	218538.00	50	6	150	96	1.5625	0.418100213483433	0.418100213483433	false	false	false	true
dea88034-fff7-4b7b-8554-59df839a61fb	2026-09-10 14:41	2026-09-10 14:41	2026-09-10 14:41	CAT	CAT280121C00940000	call	940.0000	2028-01-21	121.4400	119.0500	124.9000	803.4600	607180.00	243980.00	363200.00	50	10	200	96	2.08333333333333	0.418144406166848	0.418144406166848	false	false	false
8e509414-932b-477a-8650-ede315beec90	2026-09-11 15:41	2026-09-11 15:41	2026-09-11 15:41	CAT	CAT270917P00580000	put	580.0000	2027-09-17	28.0100	25.3500	28.1000	819.9200	327695.00	179320.00	148375.00	117	8	117	18	6.5	0.42697842059375	0.426405815156195	false	false	false	true
7697e157-a869-469d-a6f4-e3880ef4dc91	2026-09-14 09:45	2026-09-14 09:45	2026-09-14 09:45	CAT	CAT270617P00790000	put	790.0000	2027-06-17	100.0300	99.7500	109.7500	789.0000	200058.00	0.00	200058.00	20	10	20	217	0.0921658986175115	0.419902141805241	0.419902141805241	false	false	false	true
00b5eae9-2455-4f6f-9af8-d98ced5d0d8b	2026-09-14 10:49	2026-09-14 10:49	2026-09-14 10:49	CAT	CAT280121P00450000	put	450.0000	2028-01-21	15.9800	15.9000	25.9000	785.2000	121430.00	52740.00	67095.00	76	14	115	123	0.934959349593496	0.441965252659066	0.440765127258084	true	false	false	true
afd47cde-1d0e-4d31-9d9b-143e9999bdc5	2026-09-15 10:26	2026-09-15 10:26	2026-09-15 10:26	CAT	CAT261120C00760000	call	760.0000	2026-11-20	67.3300	65.6000	69.1000	780.6900	80790.00	40440.00	40350.00	12	6	14	67	0.208955223880597	0.40920680245336	0.408027514460581	false	false	false	true
fac1f704-d97f-49ff-9a0d-c502a27af566	2026-09-16 10:44	2026-09-16 10:43	2026-09-16 10:43	CAT	CAT280121C00940000	call	940.0000	2028-01-21	108.5400	104.4500	108.8500	784.8900	162815.00	97705.00	54225.00	15	8	17	248	0.0685483870967742	0.399624368588417	0.398523825080404	false	false	false
af704f12-f4db-422a-9a72-cfd53b484159	2026-09-17 10:00	2026-09-17 10:00	2026-09-17 10:00	CAT	CAT261120C00810000	call	810.0000	2026-11-20	53.1900	53.0500	54.5000	799.5000	101055.00	58485.00	42570.00	19	8	21	148	0.141891891891892	0.416290353776304	0.414040917804445	true	false	false	true
549d272d-2d7b-4560-923a-712f1c71ce49	2026-09-17 10:30	2026-09-17 10:30	2026-09-17 10:30	CAT	CAT280121P00680000	put	680.0000	2028-01-21	74.0500	71.3000	74.1000	802.2150	96266.00	88911.00	7355.00	13	5	15	94	0.159574468085106	0.430310697071792	0.428405652257169	false	false	false	true
987a7060-2bf6-4b31-97de-890bc25e2a1f	2026-09-17 10:36	2026-09-17 10:36	2026-09-17 10:36	CAT	CAT260925C00812500	call	812.5000	2026-09-25	13.8700	12.7000	17.7500	800.6100	76267.00	9575.00	66692.00	55	25	57	0	0	0.401883300827007	0.393925452875028	true	false	false	true
a719d9f7-495d-46f5-be24-9880813a7a1a	2026-09-17 11:25	2026-09-17 11:25	2026-09-17 11:25	CAT	CAT261016P00840000	put	840.0000	2026-10-16	56.9100	54.5500	57.4500	797.5250	96750.00	56950.00	39800.00	17	10	36	223	0.161434977578475	0.362613758237296	0.361392454856245	true	false	false	true
565a59bd-0cf6-4e9a-9774-0334ba1108eb	2026-09-17 12:04	2026-09-17 12:04	2026-09-17 12:04	CAT	CAT261023P00740000	put	740.0000	2026-10-23	13.5300	13.2500	14.3000	799.9700	68985.00	6850.00	62135.00	51	8	57	41	1.39024390243902	0.384869154313026	0.381586843141844	true	false	false	true
f7f40c39-d1a0-4e5b-89bb-114091fefdae	2026-09-18 14:30	2026-09-18 14:30	2026-09-18 14:30	CAT	CAT270219P00720000	put	720.0000	2027-02-19	41.1000	38.8000	41.2000	801.8200	65765.00	41150.00	24615.00	16	6	18	88	0.204545454545455	0.408954196296804	0.408665256501151	false	false	false	true
dfa9e317-1647-4507-b865-d50273e0956c	2026-09-21 10:31	2026-09-21 10:31	2026-09-21 10:31	CAT	CAT261023C00905000	call	905.0000	2026-10-23	8.7500	4.7500	9.6000	818.0650	47250.00	23895.00	23355.00	54	6	78	18	4.33333333333333	0.358384149485859	0.355365229300432	false	false	false	true
68b7881b-379e-4ef3-80bf-e1df9b948ab3	2026-09-21 10:41	2026-09-21 10:41	2026-09-21 10:41	CAT	CAT270319P00720000	put	720.0000	2027-03-19	41.5400	41.5000	44.8000	816.3800	62305.00	0.00	62305.00	15	8	15	159	0.0943396226415094	0.406736326349598	0.406192361603831	false	false	false	true
46ddd220-1446-4db3-84c0-1b2e17c20ff9	2026-09-21 10:41	2026-09-21 10:41	2026-09-21 10:41	CAT	CAT270319P00720000	put	720.0000	2027-03-19	42.1400	40.2500	42.2500	816.2700	63205.00	54915.00	8290.00	15	5	30	159	0.188679245283019	0.410114482037147	0.405767344517792	false	false	false	true
1db2bdcd-71c8-49dd-95ce-9afcd65986fc	2026-09-21 10:43	2026-09-21 10:43	2026-09-21 10:43	CAT	CAT270319C01040000	call	1040.0000	2027-03-19	29.4200	29.3000	31.1000	817.0000	44135.00	8835.00	35300.00	15	5	15	92	0.16304347826087	0.389627350268715	0.389353347899746	false	false	false	true
33b46829-d417-4ea4-a74a-0f08ad2231e6	2026-09-21 14:32	2026-09-21 14:32	2026-09-21 14:32	CAT	CAT270521C00900000	call	900.0000	2027-05-21	81.5100	78.2500	82.2500	818.0000	537980.00	318165.00	219815.00	66	13	68	1	68	0.391771558401913	0.39026498121021	false	false	false	true