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:er_time = unknown×source = uw_flow_alerts×ticker = CAT×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

fcfd9317-226e-4301-8bdb-f59dca383421	2026-09-21 15:53	2026-09-21 15:53	2026-09-21 15:53	CAT	CAT261016C00860000	call	860.0000	2026-10-16	13.5000	13.1000	13.5000	815.0000	27000.00	6750.00	0.00	20	7	50	497	0.100603621730382	0.342286265835871	0.342286265835871	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	375324546869.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
d9f06490-5fe2-4212-a19e-dd173fc4f93b	2026-09-21 15:53	2026-09-21 15:53	2026-09-21 15:53	CAT	CAT261016C00860000	call	860.0000	2026-10-16	14.0400	13.9500	14.8500	815.0000	75835.00	23885.00	51950.00	54	14	104	497	0.209255533199195	0.348965651952752	0.349528924280737	true	false	false	true
d7413b1b-9102-4be8-a9c8-62b617cd50df	2026-09-21 15:51	2026-09-21 15:51	2026-09-21 15:51	CAT	CAT270319P00680000	put	680.0000	2027-03-19	29.8500	29.8500	30.2000	816.9850	17910.00	0.00	17910.00	6	6	15	123	0.121951219512195	0.412229601087119	0.412229601087119	false	false	false	true
9abc011b-7592-44b7-ac70-c9f807d6a10d	2026-09-21 15:43	2026-09-21 15:43	2026-09-21 15:43	CAT	CAT261016C00840000	call	840.0000	2026-10-16	21.6500	21.6500	22.0000	818.5550	12990.00	0.00	12990.00	6	5	200	205	0.975609756097561	0.350244827393324	0.350244827393324	false	false	false	true
ee467a72-321e-4689-b325-f3197972a1b0	2026-09-21 15:40	2026-09-21 15:40	2026-09-21 15:40	CAT	CAT261016C00840000	call	840.0000	2026-10-16	21.8000	21.7000	22.2500	818.7700	13080.00	8720.00	4360.00	6	5	124	205	0.604878048780488	0.350961115391057	0.350961115391057	false	false	false	true
331549ed-945d-4205-a48b-1164761865a2	2026-09-21 15:36	2026-09-21 15:35	2026-09-21 15:35	CAT	CAT270115C00940000	call	940.0000	2027-01-15	31.8500	31.8500	32.1000	818.3600	162440.00	3190.00	159250.00	51	15	72	352	0.204545454545455	0.377818228158138	0.377818228158138	false	false	false	true
1a063d52-f8ea-4b15-b776-411ef62d12bb	2026-09-21 14:53	2026-09-21 14:53	2026-09-21 14:53	CAT	CAT261016C00830000	call	830.0000	2026-10-16	25.5500	25.4000	25.8500	818.3700	48545.00	33215.00	5110.00	19	8	111	290	0.382758620689655	0.349291980985088	0.349291980985088	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
cb36fa7b-14fc-49aa-8b15-a1cf016a626d	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	CAT	CAT270319P00740000	put	740.0000	2027-03-19	47.5000	47.4000	48.5500	818.1000	33250.00	14265.00	18985.00	7	6	12	146	0.0821917808219178	0.401661648655733	0.402264401301689	false	false	false	true
86ef927a-2a9d-4e94-b135-0b3fb8c3fcef	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	CAT	CAT270319P00740000	put	740.0000	2027-03-19	47.5000	47.4000	48.5500	818.1000	80755.00	14255.00	66500.00	17	6	29	146	0.198630136986301	0.402006914761618	0.401749400955697	false	false	false	true
4998272c-74a5-4337-837c-82b398a291f9	2026-09-21 12:38	2026-09-21 12:38	2026-09-21 12:38	CAT	CAT261030P00820000	put	820.0000	2026-10-30	43.5000	41.4500	43.7000	820.4800	65250.00	65250.00	0.00	15	7	22	2	11	0.42668657424835	0.42668657424835	false	false	false	true
8ee3610f-3833-4e88-a549-2be3898daac8	2026-09-21 11:14	2026-09-21 11:14	2026-09-21 11:14	CAT	CAT261016C00810000	call	810.0000	2026-10-16	35.3000	35.3000	37.3500	819.7550	70600.00	0.00	70600.00	20	5	110	593	0.185497470489039	0.340618619737438	0.340618619737438	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
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
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
cf8b1edf-eb23-4333-8468-7c8848c1e57a	2026-09-21 10:32	2026-09-21 10:32	2026-09-21 10:32	CAT	CAT261030C00970000	call	970.0000	2026-10-30	6.9500	6.7500	8.1500	818.0600	30585.00	700.00	29885.00	44	15	44	20	2.2	0.424273833468974	0.424273833468974	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
41010115-1160-4fcb-8a45-530d5c48d0f0	2026-09-21 10:30	2026-09-21 10:30	2026-09-21 10:30	CAT	CAT261023P00875000	put	875.0000	2026-10-23	69.6000	68.3000	72.3500	818.0000	83520.00	0.00	83520.00	12	5	12	6	2	0.366268277718851	0.366268277718851	false	false	false	true
7d35b285-4cb1-46d4-a233-26f500d59555	2026-09-21 10:27	2026-09-21 10:27	2026-09-21 10:27	CAT	CAT261016P00830000	put	830.0000	2026-10-16	35.6500	34.3500	35.6500	817.5100	303025.00	303025.00	0.00	85	18	85	110	0.772727272727273	0.35380609831192	0.352407285576494	false	false	false	true
e6ad16d9-07a7-41f8-9196-679702c7b903	2026-09-21 10:24	2026-09-21 10:24	2026-09-21 10:24	CAT	CAT260925C00800000	call	800.0000	2026-09-25	24.0000	19.4000	24.4000	816.0000	21600.00	21600.00	0.00	9	5	34	118	0.288135593220339	0.408505751003247	0.408505751003247	false	false	false	true
9ad9fd61-882d-459f-996a-323444510f98	2026-09-21 10:24	2026-09-21 10:24	2026-09-21 10:24	CAT	CAT261016P00880000	put	880.0000	2026-10-16	70.8800	68.9000	74.4000	817.0000	42525.00	7090.00	35435.00	6	6	98	217	0.451612903225806	0.360741120604207	0.358474591862167	true	false	false	true
aab9a834-3c5d-4aef-ad80-f180799836b7	2026-09-21 10:12	2026-09-21 10:12	2026-09-21 10:12	CAT	CAT261002P00785000	put	785.0000	2026-10-02	9.6400	9.6000	11.2500	811.0000	44345.00	2000.00	42345.00	46	10	47	44	1.06818181818182	0.370862615922471	0.370862615922471	true	false	false	true
6e4176df-a698-45cc-8aee-ea96470f728e	2026-09-21 10:08	2026-09-21 10:08	2026-09-21 10:08	CAT	CAT261120P00890000	put	890.0000	2026-11-20	101.7600	98.2000	103.2500	809.2100	50880.00	30530.00	20350.00	5	5	5	167	0.029940119760479	0.416718941603986	0.414522136448392	false	false	false	true
8982b919-eac8-432b-843a-2faad3120ef3	2026-09-18 15:52	2026-09-18 15:52	2026-09-18 15:52	CAT	CAT270319P00660000	put	660.0000	2027-03-19	26.9500	26.9500	27.4000	807.0000	59299.00	0.00	59299.00	22	9	37	346	0.106936416184971	0.414627658090138	0.414627658090138	false	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
2f28eced-eff3-457f-a277-71133b3e13b7	2026-09-18 14:30	2026-09-18 14:30	2026-09-18 14:30	CAT	CAT270219P00720000	put	720.0000	2027-02-19	41.1700	38.8000	41.2000	801.8200	255246.00	255246.00	0.00	62	5	83	88	0.943181818181818	0.407971629563798	0.409243094239127	true	false	false	true
29146c27-2f58-403f-8d09-5406d31027bb	2026-09-18 11:06	2026-09-18 11:06	2026-09-18 11:06	CAT	CAT261120C00830000	call	830.0000	2026-11-20	43.8500	42.9500	45.7500	801.6700	52615.00	26365.00	26250.00	12	6	19	94	0.202127659574468	0.403050169389675	0.404937821759606	true	false	false	true
f4f34bd8-6619-49c3-bc72-c4adb7605234	2026-09-18 09:43	2026-09-18 09:43	2026-09-18 09:43	CAT	CAT261002C00845000	call	845.0000	2026-10-02	8.4600	7.8000	9.4500	808.7525	50750.00	26000.00	24750.00	60	6	62	151	0.410596026490066	0.331413894798708	0.338096728699142	true	false	false	true
68f02dfb-187c-45b9-a9a0-d4fa3c26dac8	2026-09-18 09:43	2026-09-18 09:43	2026-09-18 09:43	CAT	CAT261002C00845000	call	845.0000	2026-10-02	8.4600	7.8000	9.4500	808.7525	50750.00	25850.00	24900.00	60	6	122	151	0.80794701986755	0.331413894798708	0.337145402512731	true	false	false	true
09facdc1-7859-4217-9f87-202462dca61f	2026-09-18 09:35	2026-09-18 09:35	2026-09-18 09:35	CAT	CAT261120C00940000	call	940.0000	2026-11-20	14.3400	14.1000	15.8000	803.5150	93210.00	44965.00	48245.00	65	5	65	256	0.25390625	0.396951861750044	0.401157414240717	false	false	false	true
0daf726a-848d-4830-8134-7e8019c30ac8	2026-09-17 13:49	2026-09-17 13:49	2026-09-17 13:49	CAT	CAT261016C00770000	call	770.0000	2026-10-16	48.5700	48.5500	53.6000	796.7600	150565.00	0.00	131125.00	31	11	31	58	0.53448275862069	0.362394984808954	0.363003495653384	false	false	false	true
6e77633f-9afa-4712-a32a-05973280b3a3	2026-09-17 12:14	2026-09-17 12:14	2026-09-17 12:14	CAT	CAT261009P00830000	put	830.0000	2026-10-09	45.5600	43.6500	46.9000	799.1700	50120.00	22885.00	27235.00	11	5	12	4	3	0.36027386779752	0.360954520259678	false	false	false	true
52522bf7-466e-4b14-9334-4d55286df60a	2026-09-17 12:09	2026-09-17 12:09	2026-09-17 12:09	CAT	CAT261030P00730000	put	730.0000	2026-10-30	18.8400	18.3000	19.6000	799.7400	75375.00	9475.00	65900.00	40	6	61	7	8.71428571428571	0.446694961997537	0.447863555211381	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
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
2d38393a-d74c-4296-9809-8757cb30e544	2026-09-17 10:40	2026-09-17 10:40	2026-09-17 10:40	CAT	CAT261016P00770000	put	770.0000	2026-10-16	18.8100	18.8000	19.9000	801.9300	60195.00	1890.00	58305.00	32	10	52	904	0.0575221238938053	0.376281836497293	0.376281836497293	true	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
93f1ecd6-f8a8-4399-833d-5543bd6a4e45	2026-09-17 10:36	2026-09-17 10:36	2026-09-17 10:36	CAT	CAT261002C00815000	call	815.0000	2026-10-02	18.8800	18.7500	20.7500	800.5900	362575.00	49590.00	303535.00	192	36	274	66	4.15151515151515	0.380732710916339	0.388566058850379	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
2fb414b9-41f0-4f4d-90c1-f4fdb576adf9	2026-09-17 10:27	2026-09-17 10:27	2026-09-17 10:27	CAT	CAT261009C00825000	call	825.0000	2026-10-09	20.4100	19.9000	22.6500	802.4300	116360.00	32720.00	83640.00	57	15	65	9	7.22222222222222	0.371577986123462	0.371577986123462	false	false	false	true
77c2bd5c-e9d8-4af0-80d0-f35c73029a9b	2026-09-17 10:12	2026-09-17 10:12	2026-09-17 10:12	CAT	CAT270115P00800000	put	800.0000	2027-01-15	68.5500	67.9000	69.6000	798.7200	322200.00	253600.00	68600.00	47	7	70	508	0.137795275590551	0.405169087989818	0.403708956637889	true	false	false	true
9b670780-2c32-48c4-ac17-80cd4db91553	2026-09-17 10:04	2026-09-17 10:04	2026-09-17 10:04	CAT	CAT260925P00810000	put	810.0000	2026-09-25	24.2500	21.1000	24.2500	797.9600	400125.00	400125.00	0.00	165	28	165	63	2.61904761904762	0.383589710425933	0.379641230198233	false	false	false	true
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
dc87639e-50e5-4754-a554-234065792faa	2026-09-17 09:50	2026-09-17 09:50	2026-09-17 09:50	CAT	CAT261016P00730000	put	730.0000	2026-10-16	7.6500	6.9500	8.2000	806.0000	71910.00	1530.00	55845.00	94	15	97	1057	0.0917691579943236	0.383692057999608	0.383692057999608	false	false	false	true
2390fcea-1200-4590-b8e6-1c8996b9a2de	2026-09-17 09:34	2026-09-17 09:34	2026-09-17 09:34	CAT	CAT261218C00880000	call	880.0000	2026-12-18	41.3100	39.0500	46.5000	809.4200	53700.00	24915.00	28785.00	13	5	14	94	0.148936170212766	0.401034666310614	0.401034666310614	false	false	false	true
32b43584-aa75-40ab-bcba-836949676131	2026-09-16 15:26	2026-09-16 15:26	2026-09-16 15:26	CAT	CAT270115C00840000	call	840.0000	2027-01-15	47.9200	46.9500	49.2000	775.2400	143745.00	24095.00	71550.00	30	5	47	340	0.138235294117647	0.387346759478333	0.389631845890035	false	false	false	true
d68698a5-294c-427f-8810-4c505c97519f	2026-09-16 15:24	2026-09-16 15:24	2026-09-16 15:24	CAT	CAT261016P00750000	put	750.0000	2026-10-16	20.7500	20.7500	20.8500	775.8950	53950.00	0.00	51875.00	26	12	225	1350	0.166666666666667	0.378913882890302	0.378913882890302	false	false	false	true
1551d344-1066-4883-a4fb-5f0841dc8bfd	2026-09-16 15:24	2026-09-16 15:24	2026-09-16 15:24	CAT	CAT261016P00750000	put	750.0000	2026-10-16	20.7000	20.7000	20.8500	775.6850	53820.00	0.00	53820.00	26	7	174	1350	0.128888888888889	0.377418535768309	0.377418535768309	false	false	false	true
f50864dd-e3f0-4656-b2dd-4de83269efb3	2026-09-16 15:24	2026-09-16 15:24	2026-09-16 15:24	CAT	CAT261016P00750000	put	750.0000	2026-10-16	20.3500	20.1000	20.4000	776.0400	52910.00	8140.00	20350.00	26	6	125	1350	0.0925925925925926	0.374643616278018	0.374643616278018	false	false	false	true
767d08fc-43a0-499d-bad4-93757d258d81	2026-09-16 15:11	2026-09-16 15:11	2026-09-16 15:11	CAT	CAT261023P00850000	put	850.0000	2026-10-23	81.8900	77.4000	83.1500	777.6150	204725.00	163875.00	40850.00	25	5	29	3	9.66666666666667	0.369158779206698	0.369789355752082	false	false	false	true