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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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	expirydate

a6495c01-d99f-4c14-810f-04d6b735b49a	2026-08-17 10:32	2026-08-17 10:32	2026-08-17 10:32	CAT	CAT260918C00880000	call	880.0000	2026-09-18	37.8500	37.8500	39.8500	874.2700	246035.00	7580.00	238455.00	65	11	69	356	0.193820224719101	0.37948092192465	0.37948092192465	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	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:42:42.502476Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0233eb0b-5d7d-440b-b59c-d07621529c29	2026-08-17 10:48	2026-08-17 10:48	2026-08-17 10:48	CAT	CAT260821P00875000	put	875.0000	2026-08-21	14.5000	14.3000	17.8000	876.1100	604650.00	166750.00	437900.00	417	10	418	123	3.39837398373984	0.401860161482293	0.416499308850614	false	false	false	true
b61d5837-8f4e-47c9-905a-51f32913b142	2026-08-17 12:09	2026-08-17 12:09	2026-08-17 12:09	CAT	CAT261016C00920000	call	920.0000	2026-10-16	41.4500	41.4500	43.1500	882.9300	136800.00	0.00	136800.00	33	12	45	26	1.73076923076923	0.383768846999172	0.384122715357026	false	false	false	true
c24db55c-59ad-41dc-900c-8f1712f427bc	2026-08-17 13:10	2026-08-17 13:10	2026-08-17 13:10	CAT	CAT260821P00880000	put	880.0000	2026-08-21	12.3500	11.3000	12.3500	885.0701	56810.00	56810.00	0.00	46	7	65	879	0.0739476678043231	0.404656216085665	0.404656216085665	false	false	false	true
852d21a3-135e-4516-802f-7fab9511a4f0	2026-08-17 13:16	2026-08-17 13:16	2026-08-17 13:16	CAT	CAT260821P00885000	put	885.0000	2026-08-21	14.8000	13.8500	14.8000	885.1800	66600.00	66600.00	0.00	45	7	66	29	2.27586206896552	0.407866320185465	0.407866320185465	false	false	false	true
966b86db-23a7-4f5f-ac5e-9a6fd03de6f3	2026-08-18 10:10	2026-08-18 10:10	2026-08-18 10:10	CAT	CAT260918P00910000	put	910.0000	2026-09-18	73.6900	69.1500	74.8000	850.4600	117900.00	117900.00	0.00	16	6	18	22	0.818181818181818	0.382002207309339	0.385475758895375	false	false	false	true
e452a56b-2e3b-4ae1-8940-64a6159d37a0	2026-08-18 10:30	2026-08-18 10:30	2026-08-18 10:30	CAT	CAT280121C01140000	call	1140.0000	2028-01-21	102.5500	98.4000	106.9500	849.1500	71785.00	61530.00	10255.00	7	7	7	402	0.0174129353233831	0.431308947765258	0.431308947765258	false	false	false	true
26567cff-ad33-4c39-8293-baa857eaee78	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	CAT	CAT260918C00920000	call	920.0000	2026-09-18	12.0600	11.4500	14.5000	840.4620	102525.00	79625.00	22900.00	85	8	104	1801	0.0577456968350916	0.373382962289	0.373382962289	false	false	false	true
d6ba3268-c8ec-44c9-975b-c9957f6a053f	2026-08-18 11:37	2026-08-18 11:37	2026-08-18 11:37	CAT	CAT260918C00840000	call	840.0000	2026-09-18	37.5000	36.2000	39.7500	838.8100	75000.00	0.00	75000.00	20	5	32	291	0.109965635738832	0.377156843753089	0.377156843753089	false	false	false	true
5d2e304c-c4c8-473b-ab7a-59eac91322b1	2026-08-18 14:33	2026-08-18 14:33	2026-08-18 14:33	CAT	CAT280121P00880000	put	880.0000	2028-01-21	175.3400	169.3500	175.4000	837.1700	122740.00	105205.00	17535.00	7	5	11	86	0.127906976744186	0.457590225143323	0.457590225143323	false	false	false	true
9d2209f1-ea20-493f-a731-82804aa5a883	2026-08-18 15:43	2026-08-18 15:43	2026-08-18 15:43	CAT	CAT261120C01000000	call	1000.0000	2026-11-20	25.3400	23.1000	26.4500	842.2500	73495.00	43375.00	30120.00	29	7	33	150	0.22	0.422714250787366	0.423436586471112	false	false	false	true
7925c71d-46db-4516-b8e2-413f16c29e75	2026-08-19 10:30	2026-08-19 10:30	2026-08-19 10:30	CAT	CAT260911C00830000	call	830.0000	2026-09-11	26.3900	23.9500	28.5500	814.9900	73900.00	45070.00	28830.00	28	6	30	23	1.30434782608696	0.394011297874961	0.398325574736667	false	false	false	true
bb9690dd-6cb3-4fa4-9525-7f8f170014e4	2026-08-19 10:33	2026-08-19 10:32	2026-08-19 10:32	CAT	CAT260911C00780000	call	780.0000	2026-09-11	54.5300	53.6500	56.1500	815.8800	119975.00	54600.00	65375.00	22	5	37	0	0	0.403333796531131	0.403333796531131	true	false	false	true
63790f93-e69e-4ca5-8fa7-600d72276b98	2026-08-19 10:51	2026-08-19 10:51	2026-08-19 10:51	CAT	CAT261016P00700000	put	700.0000	2026-10-16	9.8000	9.8000	11.4000	812.1200	490000.00	0.00	490000.00	500	12	517	154	3.35714285714286	0.389771220709343	0.389771220709343	false	false	false	true
78a66c66-ab3b-4e38-98ea-79f8481fe178	2026-08-19 11:00	2026-08-19 10:59	2026-08-19 10:59	CAT	CAT260821P00820000	put	820.0000	2026-08-21	15.1100	15.1000	17.2500	813.6300	96705.00	19695.00	77010.00	64	22	195	1926	0.101246105919003	0.486796853227161	0.488916593902118	false	false	false	true
c097fe39-1dda-46db-ba59-42543f4c93bc	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	CAT	CAT261016C00910000	call	910.0000	2026-10-16	20.3500	20.3500	22.0000	812.7700	158730.00	0.00	158730.00	78	26	155	180	0.861111111111111	0.398720422409278	0.398720422409278	false	false	false	true
1a5d9800-afe9-462a-b713-9396fb9051e1	2026-08-19 11:40	2026-08-19 11:40	2026-08-19 11:40	CAT	CAT261120P00810000	put	810.0000	2026-11-20	65.2400	63.2000	65.9500	811.4600	52190.00	45665.00	6525.00	8	7	15	81	0.185185185185185	0.430888566333057	0.430888566333057	false	false	false	true
bcce24a6-9e95-4f28-a01a-0fdf4629730c	2026-08-19 12:29	2026-08-19 12:29	2026-08-19 12:29	CAT	CAT261120P00800000	put	800.0000	2026-11-20	60.9000	60.9000	62.0000	809.1400	231420.00	0.00	231420.00	38	9	54	253	0.213438735177866	0.429266174892292	0.429266174892292	false	false	false	true
273e14ff-5574-4d0f-a74d-e32c6beecf60	2026-08-19 13:30	2026-08-19 13:30	2026-08-19 13:30	CAT	CAT261120P00800000	put	800.0000	2026-11-20	59.3000	59.3000	60.3500	811.1050	296505.00	0.00	296505.00	50	15	104	253	0.411067193675889	0.424360990868698	0.424674442663115	false	false	false	true
aa4a3f6f-c495-4616-8c2c-7461f9d74389	2026-08-19 14:59	2026-08-19 14:58	2026-08-19 14:58	CAT	CAT261120P00810000	put	810.0000	2026-11-20	64.2500	64.2500	65.6500	809.8200	334100.00	0.00	334100.00	52	7	167	81	2.06172839506173	0.4202358361953	0.4202358361953	false	false	false	true
6bc50a43-8d41-46ef-a2de-23ef10eb0af2	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	CAT	CAT270617P00870000	put	870.0000	2027-06-17	149.5000	142.0000	153.1500	803.3877	119600.00	74750.00	0.00	8	5	8	39	0.205128205128205	0.437165799534997	0.437165799534997	false	false	false	true
364356fb-3cfc-45dd-bc45-59d287771650	2026-08-21 09:56	2026-08-21 09:56	2026-08-21 09:56	CAT	CAT261016P00670000	put	670.0000	2026-10-16	4.7500	3.4000	4.7500	824.5608	53200.00	53200.00	0.00	112	33	112	68	1.64705882352941	0.402884395039378	0.402884395039378	false	false	false	true
26ac22d8-ff4b-4a02-8949-e00089768f80	2026-08-21 10:07	2026-08-21 10:06	2026-08-21 10:06	CAT	CAT280616P00780000	put	780.0000	2028-06-16	144.0000	142.5000	144.0000	819.2050	72000.00	72000.00	0.00	5	5	38	265	0.143396226415094	0.461639714800966	0.461639714800966	false	false	false	true
cc90256b-eb8a-4479-b0d0-2e560677ccd6	2026-08-21 10:46	2026-08-21 10:45	2026-08-21 10:45	CAT	CAT261120C00800000	call	800.0000	2026-11-20	80.0000	77.0000	81.4500	816.6000	376000.00	216000.00	160000.00	47	5	149	136	1.09558823529412	0.419850746194514	0.419850746194514	false	false	false	true
0637002c-178c-47fa-b6bc-e4fc30d41e08	2026-08-21 10:46	2026-08-21 10:45	2026-08-21 10:45	CAT	CAT261120C00800000	call	800.0000	2026-11-20	80.0000	78.3000	80.0000	816.6000	320000.00	320000.00	0.00	40	5	189	136	1.38970588235294	0.419850746194514	0.419850746194514	false	false	false	true
17ca2b10-6a7c-4415-a225-dda52c9b12a2	2026-08-21 11:41	2026-08-21 11:41	2026-08-21 11:41	CAT	CAT261016C00720000	call	720.0000	2026-10-16	118.6500	116.4000	119.8000	822.4100	71190.00	59330.00	11860.00	6	6	17	3	5.66666666666667	0.395652251870886	0.399386421046507	false	false	false	true
90270b0d-3ece-43ce-adc9-c120d776b33e	2026-08-21 14:30	2026-08-21 14:30	2026-08-21 14:30	CAT	CAT260828C00830000	call	830.0000	2026-08-28	17.4000	16.6500	17.4000	831.2200	59160.00	59160.00	0.00	34	6	294	51	5.76470588235294	0.359111022870321	0.359111022870321	false	false	false	true
76ce7575-20b8-4216-afac-3ff5bcf61ea0	2026-08-21 14:49	2026-08-21 14:49	2026-08-21 14:49	CAT	CAT270319P00740000	put	740.0000	2027-03-19	58.0000	58.0000	61.0000	831.1750	145000.00	0.00	11600.00	25	10	28	102	0.274509803921569	0.441216422193348	0.441216422193348	true	false	false	true
31d1bb4b-ad31-4f52-9d2e-e39c32961b0c	2026-08-21 15:45	2026-08-21 15:45	2026-08-21 15:45	CAT	CAT260828C00830000	call	830.0000	2026-08-28	14.9500	14.9500	17.3500	827.9100	50830.00	0.00	50830.00	34	7	472	51	9.25490196078431	0.342564713152334	0.342564713152334	false	false	false	true
3dd18ea1-84e3-401a-8f53-c2ddbc39ce43	2026-08-24 09:58	2026-08-24 09:58	2026-08-24 09:58	CAT	CAT260828P00810000	put	810.0000	2026-08-28	14.8500	14.6500	17.7500	809.1100	742500.00	594000.00	148500.00	500	5	509	161	3.16149068322981	0.431126922629038	0.431126922629038	false	false	false	true
33a0c706-6321-4978-bc1b-1fd5859f6b79	2026-08-24 10:57	2026-08-24 10:57	2026-08-24 10:57	CAT	CAT261016P00760000	put	760.0000	2026-10-16	22.5000	22.1000	22.5000	810.8700	67500.00	11250.00	0.00	30	28	43	182	0.236263736263736	0.376187158867891	0.376187158867891	false	false	false	true
8205be08-2348-4593-bc64-86f7bd54cfde	2026-08-24 12:21	2026-08-24 12:21	2026-08-24 12:21	CAT	CAT270115P00660000	put	660.0000	2027-01-15	21.2500	20.6000	21.9500	811.0500	53125.00	38250.00	14875.00	25	5	25	328	0.0762195121951219	0.419450915881166	0.419450915881166	false	false	false	true
54b6beca-d7d2-46ea-838f-ea4d715aaf1f	2026-08-24 15:22	2026-08-24 15:22	2026-08-24 15:22	CAT	CAT260918C00810000	call	810.0000	2026-09-18	33.1000	32.3500	33.1000	811.1000	112540.00	49650.00	0.00	34	6	46	116	0.396551724137931	0.372510018779495	0.372510018779495	false	false	false	true
ed0c6c65-acc3-41f0-9355-e200bacaafd4	2026-08-24 15:23	2026-08-24 15:22	2026-08-24 15:22	CAT	CAT260918C00810000	call	810.0000	2026-09-18	32.5000	32.5000	32.8000	810.6100	55250.00	0.00	9750.00	17	6	76	116	0.655172413793103	0.368500677305366	0.368500677305366	false	false	false	true
e398409c-85dd-4e26-9892-3cf45602cbea	2026-08-25 11:05	2026-08-25 11:05	2026-08-25 11:05	CAT	CAT270115C00940000	call	940.0000	2027-01-15	43.1500	39.3500	44.7000	812.2000	51780.00	25890.00	25890.00	12	5	12	319	0.0376175548589342	0.40966063656486	0.40966063656486	false	false	false	true
81dc59e6-ffb2-4a83-915f-e0c154c48b65	2026-08-25 11:17	2026-08-25 11:17	2026-08-25 11:17	CAT	CAT270219P00740000	put	740.0000	2027-02-19	54.5000	51.0000	57.4000	810.4800	87200.00	10900.00	76300.00	16	6	16	99	0.161616161616162	0.425324649929715	0.425324649929715	false	false	false	true
de089ae1-1878-482a-8f0d-62d966b60438	2026-08-25 12:22	2026-08-25 12:22	2026-08-25 12:22	CAT	CAT260925C00815000	call	815.0000	2026-09-25	35.4000	33.8500	35.4000	811.6300	53100.00	53100.00	0.00	15	5	16	3	5.33333333333333	0.379094108982851	0.379094108982851	true	false	false	true
d2402564-7724-4e7f-a255-a2e7a055f9af	2026-08-25 14:01	2026-08-25 14:01	2026-08-25 14:01	CAT	CAT261120P00830000	put	830.0000	2026-11-20	73.6500	72.2500	73.6500	809.0000	368250.00	368250.00	0.00	50	5	84	104	0.807692307692308	0.421502816788912	0.421502816788912	false	false	false	true
fd6d9200-2e74-4ae8-bab8-b7e04482306a	2026-08-25 14:32	2026-08-25 14:32	2026-08-25 14:32	CAT	CAT261016P00680000	put	680.0000	2026-10-16	5.9500	5.6000	5.9500	811.3600	160650.00	160650.00	0.00	270	5	270	281	0.96085409252669	0.39550333941885	0.39550333941885	false	false	false	true
fc0b0082-8a7f-4ccd-a84a-a55042dafba9	2026-08-25 14:44	2026-08-25 14:44	2026-08-25 14:44	CAT	CAT260828C00820000	call	820.0000	2026-08-28	9.0000	8.1500	9.2000	811.4600	136800.00	136800.00	0.00	152	5	418	114	3.66666666666667	0.430930487863637	0.431072545193695	false	false	false	true
cec9ca12-ce4b-4b87-9d49-7d085083e93a	2026-08-25 14:59	2026-08-25 14:59	2026-08-25 14:59	CAT	CAT260828C00850000	call	850.0000	2026-08-28	2.0000	1.5000	2.4700	811.3276	59600.00	8200.00	43600.00	298	8	923	167	5.52694610778443	0.438848868325589	0.438848868325589	false	false	false	true
6523f092-6e9d-4e97-b388-7d89829c5712	2026-08-26 13:56	2026-08-26 13:56	2026-08-26 13:56	CAT	CAT280121C00840000	call	840.0000	2028-01-21	177.0600	176.3000	180.2000	823.7100	336405.00	124100.00	212305.00	19	5	24	14	1.71428571428571	0.425037642845295	0.424902145752968	false	false	false	true
b3aecf84-98eb-4962-b590-01b60fe9be26	2026-08-26 13:58	2026-08-26 13:58	2026-08-26 13:58	CAT	CAT280121C00850000	call	850.0000	2028-01-21	172.0000	168.1000	175.7500	823.2150	120400.00	34400.00	86000.00	7	6	100	158	0.632911392405063	0.423357649361482	0.423357649361482	false	false	false	true
9204aa11-a04f-4e7c-9902-5d843f0c6bc0	2026-08-26 14:58	2026-08-26 14:58	2026-08-26 14:58	CAT	CAT260911C00830000	call	830.0000	2026-09-11	22.0500	21.3500	22.0500	823.2300	156555.00	156555.00	0.00	71	12	72	26	2.76923076923077	0.357433800433805	0.357433800433805	false	false	false	true
48a9053c-188a-4925-8104-dc862a96ecb5	2026-08-26 15:43	2026-08-26 15:43	2026-08-26 15:43	CAT	CAT260918C00825000	call	825.0000	2026-09-18	30.5000	30.2000	30.5000	824.5750	85400.00	45750.00	0.00	28	26	65	9	7.22222222222222	0.360393869391781	0.360393869391781	true	false	false	true
f3594a5d-40e4-4175-a046-16bde355ef06	2026-08-27 09:46	2026-08-27 09:46	2026-08-27 09:46	CAT	CAT260904P00810000	put	810.0000	2026-09-04	13.3500	13.3500	15.6500	819.6150	560700.00	0.00	560700.00	420	7	422	156	2.70512820512821	0.374851068663958	0.374851068663958	false	false	false	true
eeb980a0-0ece-4206-a687-214e35f84f8e	2026-08-27 12:12	2026-08-27 12:12	2026-08-27 12:12	CAT	CAT260911C00830000	call	830.0000	2026-09-11	17.2000	16.6000	17.2000	816.3600	724120.00	724120.00	0.00	421	10	421	98	4.29591836734694	0.343477214484593	0.343477214484593	false	false	false	true
e7cfb2db-ce33-46f7-824d-1b76831fbb8c	2026-08-27 13:08	2026-08-27 13:08	2026-08-27 13:08	CAT	CAT261120P00850000	put	850.0000	2026-11-20	76.6200	76.1500	82.0000	819.8650	76622.00	0.00	76622.00	10	6	10	152	0.0657894736842105	0.402175160452793	0.417138146824642	false	false	false	true
4afee5d0-0a14-41ae-b39c-c7875bc70725	2026-08-28 10:53	2026-08-28 10:53	2026-08-28 10:53	CAT	CAT261016C00840000	call	840.0000	2026-10-16	31.5900	30.1500	31.6000	808.0500	88440.00	85320.00	3120.00	28	9	40	106	0.377358490566038	0.367039445373882	0.363594693935651	false	false	false	true
56fa224e-1e7b-4b9b-9834-23467b02b0d1	2026-08-28 14:07	2026-08-28 14:07	2026-08-28 14:07	CAT	CAT260918P00880000	put	880.0000	2026-09-18	80.7700	78.5000	82.7000	802.8300	56540.00	48480.00	8060.00	7	5	13	190	0.068421052631579	0.358690266753155	0.358690266753155	true	false	false	true