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: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	expirydate	price

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	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Industrials	371872388452.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T13:40:42.153741Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
a279a377-d3c3-45fe-858c-70a4ec3f2a3d	2026-09-16 11:36	2026-09-16 11:35	2026-09-16 11:35	CAT	CAT280121C00920000	call	920.0000	2028-01-21	114.1500	114.1500	118.9500	788.2700	57075.00	0.00	57075.00	5	5	41	674	0.0608308605341246	0.392830698224106	0.392830698224106	false	false	false	true	false
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	true	false
8b16872c-30a2-4f7f-84f8-cff993271ddc	2026-09-16 10:27	2026-09-16 10:27	2026-09-16 10:27	CAT	CAT261002C00800000	call	800.0000	2026-10-02	17.2500	16.9500	18.6000	782.0000	53480.00	0.00	53480.00	31	5	72	37	1.94594594594595	0.3682389281931	0.3682389281931	true	false	false	true	false
a187f50e-200a-40e1-b8ca-885b6156275c	2026-09-16 09:40	2026-09-16 09:40	2026-09-16 09:40	CAT	CAT261002C00815000	call	815.0000	2026-10-02	14.1000	14.1000	16.2000	789.8336	60635.00	0.00	60635.00	43	5	55	12	4.58333333333333	0.360663404286328	0.360663404286328	false	false	false	true	false
3d53ce93-07e3-49ac-ab51-1062dc31a859	2026-09-15 15:55	2026-09-15 15:54	2026-09-15 15:54	CAT	CAT260918C00785000	call	785.0000	2026-09-18	11.1000	10.3500	11.1000	782.0000	83250.00	83250.00	0.00	75	22	299	56	5.33928571428571	0.433425206379738	0.435698233116209	true	false	false	true	false
7c404642-f59f-4788-bb79-79367594af55	2026-09-15 15:54	2026-09-15 15:54	2026-09-15 15:54	CAT	CAT260918C00785000	call	785.0000	2026-09-18	11.1000	10.3500	11.1000	781.0000	83250.00	83250.00	0.00	75	14	224	56	4	0.446223220775158	0.446223220775158	true	false	false	true	false
a5021023-96e6-4124-b13a-f8ae7a2c8d3a	2026-09-15 15:08	2026-09-15 15:08	2026-09-15 15:08	CAT	CAT290119C00800000	call	800.0000	2029-01-19	210.8500	210.8500	212.3500	782.0900	105425.00	0.00	105425.00	5	5	87	10	8.7	0.408752465374526	0.408752465374526	false	false	false	true	false
2dbf478a-b651-417f-81e8-7d67062cacb4	2026-09-15 15:05	2026-09-15 15:05	2026-09-15 15:05	CAT	CAT290119C00800000	call	800.0000	2029-01-19	211.7000	211.7000	215.8000	781.9300	127020.00	0.00	127020.00	6	5	47	10	4.7	0.410928845716375	0.410928845716375	false	false	false	true	false
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	false
33461879-a034-4077-b061-08203402c3d0	2026-09-15 10:24	2026-09-15 10:24	2026-09-15 10:24	CAT	CAT261016C00760000	call	760.0000	2026-10-16	46.0800	44.4000	47.9500	781.0601	105980.00	27680.00	78300.00	23	8	24	14	1.71428571428571	0.367090817254067	0.367674392043399	true	false	false	true	false
703b7c81-57e6-404b-95e3-bc4f614f0a59	2026-09-15 09:41	2026-09-15 09:41	2026-09-15 09:41	CAT	CAT260918C00780000	call	780.0000	2026-09-18	14.0200	12.3500	18.1000	783.4900	294475.00	15825.00	7050.00	210	52	210	715	0.293706293706294	0.423605602398366	0.456084339305208	false	false	false	true	false
caadb356-6ec1-494a-8575-f807cd14ae5a	2026-09-14 14:46	2026-09-14 14:46	2026-09-14 14:46	CAT	CAT261218P00810000	put	810.0000	2026-12-18	72.5000	72.5000	73.9500	787.5400	384255.00	7255.00	377000.00	53	8	61	179	0.340782122905028	0.40156233911975	0.40156233911975	false	false	false	true	false
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	false
d7b88582-902f-4f13-b04b-835e91470103	2026-09-14 10:09	2026-09-14 10:09	2026-09-14 10:09	CAT	CAT270319P00860000	put	860.0000	2027-03-19	122.1000	118.8000	124.9500	792.4800	61050.00	61050.00	0.00	5	5	8	44	0.181818181818182	0.413480437582504	0.413480437582504	false	false	false	true	false
0c3684ca-7809-485f-a65c-3700d5e68923	2026-09-14 09:54	2026-09-14 09:54	2026-09-14 09:54	CAT	CAT270319P00680000	put	680.0000	2027-03-19	38.5500	36.6000	40.0000	786.2500	53970.00	19275.00	34695.00	14	7	15	109	0.137614678899083	0.418044850871003	0.418044850871003	false	false	false	true	false
b85d4728-92f6-42d7-bddc-de530cc598fb	2026-09-14 09:49	2026-09-14 09:49	2026-09-14 09:49	CAT	CAT270115P00760000	put	760.0000	2027-01-15	50.7500	50.2500	58.5500	792.9400	2537343.00	443520.00	2093823.00	500	51	500	355	1.40845070422535	0.390468703847607	0.403486434006408	false	false	false	true	false
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	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	false
df515e61-c1bc-435c-983b-4b624def0798	2026-09-11 14:42	2026-09-11 14:41	2026-09-11 14:41	CAT	CAT261120P00750000	put	750.0000	2026-11-20	26.4000	25.7000	26.9000	821.1750	105600.00	18480.00	87120.00	40	6	52	207	0.251207729468599	0.414764379952897	0.414764379952897	false	false	false	true	false
23cd1bba-a327-4b2b-909b-a9631007174d	2026-09-11 12:38	2026-09-11 12:38	2026-09-11 12:38	CAT	CAT270917P00680000	put	680.0000	2027-09-17	55.9600	52.8500	56.2500	821.6601	61554.00	61554.00	0.00	11	8	12	9	1.33333333333333	0.422115767784893	0.422115767784893	false	false	false	true	false
4f93b280-ea27-4111-beb7-7e30c2c4490e	2026-09-11 12:19	2026-09-11 12:19	2026-09-11 12:19	CAT	CAT261218C00800000	call	800.0000	2026-12-18	83.2500	78.5000	83.2500	821.5400	208125.00	108225.00	0.00	25	7	26	139	0.18705035971223	0.405751616098907	0.405751616098907	false	false	false	true	false
55a87938-0ea0-4905-ac3b-3639d28e7d2b	2026-09-11 10:41	2026-09-11 10:41	2026-09-11 10:41	CAT	CAT260918C00720000	call	720.0000	2026-09-18	99.1500	99.1500	99.8500	818.3500	257790.00	0.00	257790.00	26	6	501	1553	0.322601416613007	0.437041054251403	0.437041054251403	false	false	false	true	false
538a162e-e2f1-486d-a1b9-ed4b5d2cb3c3	2026-09-11 10:41	2026-09-11 10:41	2026-09-11 10:41	CAT	CAT260918C00720000	call	720.0000	2026-09-18	99.2000	98.9000	99.7000	818.3500	386880.00	0.00	386880.00	39	6	475	1553	0.305859626529298	0.447780080283063	0.447780080283063	false	false	false	true	false
6903c581-eaff-485f-b93e-3bffefbfb7c3	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	CAT	CAT260918C00720000	call	720.0000	2026-09-18	99.1000	98.6500	99.7000	818.1800	178380.00	0.00	178380.00	18	5	433	1553	0.278815196394076	0.460550929994074	0.460550929994074	false	false	false	true	false
a307a30a-bb44-40c4-adce-de1f81150338	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	CAT	CAT260918C00720000	call	720.0000	2026-09-18	99.1000	99.1000	99.9000	818.1800	277480.00	0.00	277480.00	28	6	373	1553	0.240180296200901	0.460550929994074	0.460550929994074	false	false	false	true	false
9338b815-f180-46b9-8bce-73040475c8d6	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	CAT	CAT260918C00720000	call	720.0000	2026-09-18	99.1000	98.6000	99.9500	818.3700	336940.00	0.00	336940.00	34	6	338	1553	0.217643271088216	0.419691380284343	0.419691380284343	false	false	false	true	false
890d1cfa-70e1-4100-8d5d-177c2a25b7b6	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	CAT	CAT260918C00720000	call	720.0000	2026-09-18	99.0500	99.0500	99.4750	818.1800	118860.00	0.00	118860.00	12	6	400	1553	0.25756600128783	0.451167048130987	0.451167048130987	false	false	false	true	false
80e1ca5b-cf0f-40dd-aae0-2aea33d8765c	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	CAT	CAT260918C00720000	call	720.0000	2026-09-18	99.0500	99.0500	99.8500	818.1800	148575.00	0.00	148575.00	15	11	388	1553	0.249839021249195	0.451167048130987	0.451167048130987	false	false	false	true	false
723aa9e7-fc4d-4f30-8ba4-de34bdf02f9f	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	CAT	CAT260918C00720000	call	720.0000	2026-09-18	99.1000	99.1000	100.0000	818.4350	257660.00	0.00	257660.00	26	6	296	1553	0.190598840952994	0.399736816484403	0.399736816484403	false	false	false	true	false