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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

fefaccd2-be6f-4f3e-99be-98dfb0936691	2026-09-02 15:28	2026-09-02 15:28	2026-09-02 15:28	CAT	CAT260911C00790000	call	790.0000	2026-09-11	17.8600	17.4000	18.7000	790.3700	71450.00	26800.00	44650.00	40	9	70	68	1.02941176470588	0.349383115565635	0.349383115565635	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Industrials	360385112976.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5d8c3d8f-ebfc-4b16-9621-de7c614e9155	2026-09-02 11:20	2026-09-02 11:20	2026-09-02 11:20	CAT	CAT261002C00800000	call	800.0000	2026-10-02	29.7900	24.6500	29.8000	784.7200	74486.00	74486.00	0.00	25	5	27	11	2.45454545454545	0.395835748825351	0.395835748825351	false	false	false	true
0659f465-1c9e-45d0-bd7f-d8b1ff188cf9	2026-09-02 11:09	2026-09-02 11:09	2026-09-02 11:09	CAT	CAT261016P00850000	put	850.0000	2026-10-16	78.5700	78.4000	80.7500	784.2950	196425.00	0.00	196425.00	25	8	180	326	0.552147239263804	0.357219206538217	0.359323785374561	false	false	false	true
ceb0c902-1d60-433d-a021-d40f12d77db1	2026-09-01 15:09	2026-09-01 15:08	2026-09-01 15:08	CAT	CAT260904P00790000	put	790.0000	2026-09-04	17.3100	17.1000	19.4500	779.3950	147165.00	29495.00	117670.00	85	11	556	790	0.70379746835443	0.393444459412666	0.400984064289258	false	false	false	true
a578c6ad-2b8c-46d4-bb3f-a9657e08229e	2026-08-31 15:42	2026-08-31 15:42	2026-08-31 15:42	CAT	CAT260904C00800000	call	800.0000	2026-09-04	10.7500	10.7500	11.7500	797.5600	224705.00	0.00	222545.00	209	10	769	98	7.8469387755102	0.352970919131764	0.352970919131764	false	false	false	true
bc8be591-bccc-4d58-8dd1-b58b6e203f5f	2026-08-31 14:58	2026-08-31 14:58	2026-08-31 14:58	CAT	CAT261016C00810000	call	810.0000	2026-10-16	35.5200	35.1000	36.2500	795.8150	177600.00	35550.00	142050.00	50	5	96	320	0.3	0.356575321704544	0.356575321704544	false	false	false	true
aa09ac3a-8a1f-4c92-b3f9-a6a98b4ffbf1	2026-08-31 11:54	2026-08-31 11:54	2026-08-31 11:54	CAT	CAT270219P00680000	put	680.0000	2027-02-19	34.4000	34.3000	36.0000	791.6550	75685.00	24180.00	41200.00	22	8	22	107	0.205607476635514	0.412419522112297	0.416067963924947	true	false	false	true
2130a14f-9bfb-4a2d-9b1b-60509ccb1c91	2026-08-31 10:30	2026-08-31 10:30	2026-08-31 10:30	CAT	CAT280616P00480000	put	480.0000	2028-06-16	31.9900	31.6000	36.0000	789.6450	118365.00	0.00	118365.00	37	9	37	47	0.787234042553192	0.450660564253396	0.453778467349366	false	false	false	true
857212ec-90b8-4684-b84f-54ee903d93e1	2026-08-31 10:22	2026-08-31 10:22	2026-08-31 10:22	CAT	CAT270115P00700000	put	700.0000	2027-01-15	32.9900	32.9000	33.7000	790.8900	92360.00	6625.00	85735.00	28	8	37	1318	0.0280728376327769	0.403299567614577	0.403625180012126	false	false	false	true
8b89f169-9b25-408e-b1e3-c6f92e7c9c49	2026-08-31 10:22	2026-08-31 10:21	2026-08-31 10:21	CAT	CAT261218P00760000	put	760.0000	2026-12-18	50.0700	49.0500	51.0500	791.3900	115160.00	50175.00	64985.00	23	8	34	140	0.242857142857143	0.406573757224903	0.407189140470331	false	false	false	true
dd0f8765-a2b0-405c-921b-417472b2aaee	2026-08-31 09:38	2026-08-31 09:38	2026-08-31 09:38	CAT	CAT270115C00720000	call	720.0000	2027-01-15	123.1200	123.0000	131.0000	794.3100	6155850.00	618750.00	5537100.00	500	13	1500	145	10.3448275862069	0.39190641967073	0.401462806437227	false	false	false	true
632e1925-db66-461b-9b7d-6996de6f3bda	2026-08-28 15:24	2026-08-28 15:24	2026-08-28 15:24	CAT	CAT270115P00780000	put	780.0000	2027-01-15	61.8700	61.1000	63.0000	801.6300	61872.00	0.00	61872.00	10	6	16	194	0.0824742268041237	0.400086322096815	0.400086322096815	false	false	false	true
9d180056-9c41-400f-ae89-499529fd50a3	2026-08-28 10:55	2026-08-28 10:55	2026-08-28 10:55	CAT	CAT270115C01000000	call	1000.0000	2027-01-15	27.0200	27.0000	27.4500	808.3700	121590.00	0.00	121590.00	45	6	742	1056	0.702651515151515	0.40276957902811	0.4033949187985	false	false	false	true
e5a2cd14-2830-437e-8876-2a7249aa4880	2026-08-27 15:45	2026-08-27 15:45	2026-08-27 15:45	CAT	CAT270219C00920000	call	920.0000	2027-02-19	58.1600	58.1500	60.1000	815.9500	273375.00	0.00	273375.00	47	15	47	8	5.875	0.401991752620774	0.402671896111649	false	false	false	true
e1709e30-66bc-4dee-8e27-aa68a463181f	2026-08-27 11:34	2026-08-27 11:34	2026-08-27 11:34	CAT	CAT261016P00780000	put	780.0000	2026-10-16	25.1500	25.0000	26.3000	818.1400	113185.00	30320.00	82865.00	45	45	52	215	0.241860465116279	0.364286069839878	0.364746136622997	true	false	false	true
5e8d69a4-710c-4607-8187-187229b271ae	2026-08-25 12:31	2026-08-25 12:31	2026-08-25 12:31	CAT	CAT270115C00940000	call	940.0000	2027-01-15	43.0200	42.6500	44.7000	812.0200	111845.00	51560.00	60285.00	26	10	42	319	0.13166144200627	0.408934981367632	0.408934981367632	false	false	false	true
3f039bcc-0f1a-4e8b-b246-63c9ab0d2d70	2026-08-25 09:40	2026-08-25 09:40	2026-08-25 09:40	CAT	CAT261002P00860000	put	860.0000	2026-10-02	62.1200	61.0500	65.4000	819.5500	62120.00	0.00	62120.00	10	5	20	12	1.66666666666667	0.379226988261978	0.380218432894182	true	false	false	true
2a93fffe-4536-4e82-9d0c-423df3019794	2026-08-24 10:47	2026-08-24 10:47	2026-08-24 10:47	CAT	CAT270917C01020000	call	1020.0000	2027-09-17	87.0700	82.0500	87.8500	812.4600	121900.00	113205.00	8695.00	14	6	16	0	0	0.425007631935684	0.42622604482996	false	false	false	true
05987e2f-b421-4ea2-aa3b-9135fc672a32	2026-08-21 14:33	2026-08-21 14:33	2026-08-21 14:33	CAT	CAT270115C00940000	call	940.0000	2027-01-15	50.5700	50.5000	53.2000	830.6700	60680.00	5125.00	55555.00	12	5	13	304	0.0427631578947368	0.406316132777381	0.406316132777381	false	false	false	true
f9cf3033-6802-4d2b-825f-0ca23ee85159	2026-08-21 13:38	2026-08-21 13:38	2026-08-21 13:38	CAT	CAT270115C00900000	call	900.0000	2027-01-15	63.9100	63.1500	64.1000	829.4700	51130.00	6400.00	44730.00	8	6	16	730	0.0219178082191781	0.410713199950637	0.411218000446633	false	false	false	true
caacc223-0f9b-4bb4-b91e-7de42770bb73	2026-08-20 12:32	2026-08-20 12:31	2026-08-20 12:31	CAT	CAT261016C00870000	call	870.0000	2026-10-16	26.2000	25.6500	28.0000	806.9361	222712.00	7865.00	214847.00	85	30	89	272	0.327205882352941	0.379152309455062	0.379152309455062	false	false	false	true
ad2b8291-ca22-489f-b3cc-a618a03d1027	2026-08-19 10:28	2026-08-19 10:27	2026-08-19 10:27	CAT	CAT260904P00800000	put	800.0000	2026-09-04	20.0700	19.1000	21.3000	814.0600	140465.00	74785.00	65680.00	70	16	240	97	2.47422680412371	0.397153990043899	0.401729779816782	true	false	false	true
a1a26ceb-2e59-4f05-a5b8-5a160292c0ad	2026-08-19 10:28	2026-08-19 10:27	2026-08-19 10:27	CAT	CAT260904P00800000	put	800.0000	2026-09-04	19.7900	19.2000	23.0000	814.0600	207760.00	83365.00	124395.00	105	13	160	97	1.64948453608247	0.395628134775144	0.396391099948339	true	false	false	true
cac7b370-d057-40d9-9f36-1ba94a4d864d	2026-08-19 09:37	2026-08-19 09:37	2026-08-19 09:37	CAT	CAT270617P00700000	put	700.0000	2027-06-17	59.5100	59.5000	61.6000	827.0800	71406.00	5955.00	65451.00	12	7	15	1777	0.0084411930219471	0.443348035329308	0.443560445983479	false	false	false	true
789b1d47-b258-4d2c-a1f1-a54f832cbe4d	2026-08-17 14:14	2026-08-17 14:13	2026-08-17 14:13	CAT	CAT280121C01580000	call	1580.0000	2028-01-21	46.4700	46.0000	49.6500	884.3400	269497.00	246265.00	23232.00	58	7	170	801	0.212234706616729	0.428295988676822	0.428327637802815	true	false	false	true
9b3dd1be-af43-41a4-b68f-e4c7f7305b1a	2026-08-17 10:39	2026-08-17 10:39	2026-08-17 10:39	CAT	CAT261016C00890000	call	890.0000	2026-10-16	49.6000	49.6000	51.4500	873.0400	729125.00	0.00	729125.00	147	38	153	32	4.78125	0.388164405050242	0.388164405050242	false	false	false	true