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:endpoint = /api/option-trades/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

7fd49824-1e1f-4378-90ef-5d7451007785	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	CAT	CAT261002P00795000	put	795.0000	2026-10-02	12.7400	12.3000	14.8500	808.2253	112156.00	16725.00	95431.00	88	27	92	60	1.53333333333333	0.356854387156641	0.359366185580795	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Industrials	371421907061.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
4644c831-a5e1-4ba3-ae94-da1b47ad874d	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	CAT	CAT261016P00790000	put	790.0000	2026-10-16	19.6300	19.1500	20.6500	808.2253	27475.00	13815.00	13660.00	14	6	88	393	0.223918575063613	0.352395795697316	0.351757924621413	true	false	false	true
15cb1be4-93d3-42c8-b8f4-489dec05da23	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	CAT	CAT261016P00790000	put	790.0000	2026-10-16	19.6000	19.3000	20.7500	808.2600	76450.00	1965.00	74485.00	39	18	72	393	0.183206106870229	0.350646435940271	0.351284535548118	true	false	false	true
f8867399-7b17-4e87-b36a-acb704d262ba	2026-09-22 15:37	2026-09-22 15:37	2026-09-22 15:37	CAT	CAT261120C00920000	call	920.0000	2026-11-20	17.7800	17.2000	17.8500	807.1600	10665.00	7125.00	3540.00	6	5	20	541	0.0369685767097967	0.404474991848982	0.403010887900077	true	false	false	true
25c693c9-cd05-444b-ad4e-2ceae2190a70	2026-09-22 15:35	2026-09-22 15:35	2026-09-22 15:35	CAT	CAT261016C00855000	call	855.0000	2026-10-16	12.2500	11.2500	12.2500	806.4550	13475.00	13475.00	0.00	11	9	27	3	9	0.352167494945974	0.352167494945974	false	false	false	true
5888a273-3822-4370-be4b-d6e20fa2e07d	2026-09-22 14:23	2026-09-22 14:23	2026-09-22 14:23	CAT	CAT270917P00580000	put	580.0000	2027-09-17	26.8500	25.6000	26.9000	806.5500	24165.00	21480.00	0.00	9	5	12	80	0.15	0.414061481960569	0.414061481960569	false	false	false	true
1efe64f6-44f3-4eeb-9a03-e3f421f07cfe	2026-09-22 13:43	2026-09-22 13:43	2026-09-22 13:43	CAT	CAT261016P00745000	put	745.0000	2026-10-16	7.8500	7.8500	8.1000	803.9650	21980.00	0.00	14915.00	28	6	33	7	4.71428571428571	0.36101418504601	0.36101418504601	false	false	false	true
93250e4c-a66a-4569-8c0e-642d7384fcc9	2026-09-22 13:40	2026-09-22 13:40	2026-09-22 13:40	CAT	CAT261218P00800000	put	800.0000	2026-12-18	55.8600	55.4000	56.4500	803.0000	27930.00	16765.00	11165.00	5	5	24	310	0.0774193548387097	0.395994659348007	0.395022109380154	false	false	false	true
8ecf3551-4859-4fec-bb63-7b58d1d3ce20	2026-09-22 13:39	2026-09-22 13:39	2026-09-22 13:39	CAT	CAT261016C00840000	call	840.0000	2026-10-16	15.0000	14.4500	15.6500	803.0000	112500.00	111000.00	1500.00	75	7	94	353	0.26628895184136	0.344688109718605	0.344688109718605	false	false	false	true
78f5b37a-fb06-4871-a1c5-ee88fc6eaa6f	2026-09-22 12:33	2026-09-22 12:33	2026-09-22 12:33	CAT	CAT270917C00940000	call	940.0000	2027-09-17	88.9500	86.7000	88.9500	806.5550	151215.00	151215.00	0.00	17	6	19	16	1.1875	0.38807588322694	0.38807588322694	false	false	false	true
f6851688-bdcd-40d3-b2fc-e8ba8f67a069	2026-09-22 12:27	2026-09-22 12:27	2026-09-22 12:27	CAT	CAT261030P00720000	put	720.0000	2026-10-30	11.8000	10.8000	14.8500	805.9750	24780.00	5900.00	18880.00	21	5	38	77	0.493506493506494	0.431292653216723	0.431292653216723	false	false	false	true
9ebb118b-b236-4fe6-b12a-d48f631eeb52	2026-09-22 12:22	2026-09-22 12:22	2026-09-22 12:22	CAT	CAT261016P00805000	put	805.0000	2026-10-16	27.4100	27.0000	27.7500	806.2300	30149.00	21959.00	8190.00	11	7	40	3	13.3333333333333	0.351628103820105	0.353454340294267	false	false	false	true
458bdfe1-b461-4008-bf7f-c3d0310c417e	2026-09-22 11:49	2026-09-22 11:48	2026-09-22 11:48	CAT	CAT261002P00790000	put	790.0000	2026-10-02	11.7100	11.5250	12.8500	805.5601	15220.00	0.00	15220.00	13	9	20	42	0.476190476190476	0.353672023745507	0.354682560679695	false	false	false	true
1e564d7a-3316-4f46-9712-48464d70e5cc	2026-09-22 11:49	2026-09-22 11:48	2026-09-22 11:48	CAT	CAT261002P00797500	put	797.5000	2026-10-02	14.9100	14.0500	16.7500	805.5601	10440.00	2990.00	7450.00	7	6	10	29	0.344827586206897	0.363652332632741	0.354028226622082	true	false	false	true
e8e4fafa-9e32-47f6-b707-2b12ec5d6337	2026-09-22 11:46	2026-09-22 11:46	2026-09-22 11:46	CAT	CAT261002C00805000	call	805.0000	2026-10-02	20.0000	19.8000	21.6500	805.8550	58010.00	10025.00	47985.00	29	14	46	33	1.39393939393939	0.360757244916282	0.35887394198006	true	false	false	true
e4b656f9-8fe8-4f84-84e1-48dee9294af7	2026-09-22 11:43	2026-09-22 11:43	2026-09-22 11:43	CAT	CAT261002C00790000	call	790.0000	2026-10-02	28.5700	28.5500	31.7000	805.6100	17140.00	0.00	17140.00	6	6	6	11	0.545454545454545	0.364790995495345	0.364790995495345	true	false	false	true
cd383cb0-4b7f-4f6a-8006-6ebee9273009	2026-09-22 11:14	2026-09-22 11:14	2026-09-22 11:14	CAT	CAT260925P00800000	put	800.0000	2026-09-25	7.7500	7.1000	8.8000	807.3100	15500.00	0.00	15500.00	20	5	113	178	0.634831460674157	0.382923482247119	0.382923482247119	false	false	false	true
ad278c16-0412-429e-a46b-1e73599d9db0	2026-09-22 10:57	2026-09-22 10:57	2026-09-22 10:57	CAT	CAT261002C00800000	call	800.0000	2026-10-02	22.6000	21.9000	23.6500	806.0250	56505.00	4520.00	51985.00	25	24	42	144	0.291666666666667	0.35770988886961	0.35770988886961	true	false	false	true
e72025ca-f878-44fb-996d-10d2f2ac7711	2026-09-22 10:53	2026-09-22 10:53	2026-09-22 10:53	CAT	CAT261218C00820000	call	820.0000	2026-12-18	58.3500	56.8500	59.9000	806.0350	134205.00	29175.00	105030.00	23	19	40	82	0.48780487804878	0.389214065555125	0.389214065555125	false	false	false	true
ca0ea84a-ed83-447e-ac12-d0476789f9c8	2026-09-22 10:53	2026-09-22 10:53	2026-09-22 10:53	CAT	CAT261120P00770000	put	770.0000	2026-11-20	34.2500	34.0500	35.2000	805.9400	30825.00	10290.00	20535.00	9	9	13	224	0.0580357142857143	0.415083010038453	0.414664565700395	true	false	false	true
57433fce-c83e-4f6a-9023-83161839e338	2026-09-22 10:46	2026-09-22 10:46	2026-09-22 10:46	CAT	CAT261030P00720000	put	720.0000	2026-10-30	12.0400	10.0500	12.2500	806.0650	16858.00	6088.00	10770.00	14	7	16	77	0.207792207792208	0.434443192492933	0.430800299402503	true	false	false	true
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
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