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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

8fa9e5a8-b645-4734-aed2-868029559272	2026-09-09 09:56	2026-09-09 09:56	2026-09-09 09:56	CAT	CAT261218C00740000	call	740.0000	2026-12-18	121.7500	116.4000	124.5500	822.3550	73050.00	12175.00	60875.00	6	6	7	45	0.155555555555556	0.414360502929372	0.414360502929372	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-09-09T13:57:31.693440Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
48394c2e-5df3-4318-aacf-59a085356402	2026-09-09 09:39	2026-09-09 09:39	2026-09-09 09:39	CAT	CAT270115C00980000	call	980.0000	2027-01-15	30.4100	27.9500	31.6000	821.4548	63865.00	30705.00	33160.00	21	7	23	284	0.0809859154929577	0.396271596262393	0.399305651554609	false	false	false	true
4dcc9989-79ba-412a-aee0-d7c397946281	2026-09-08 14:40	2026-09-08 14:39	2026-09-08 14:39	CAT	CAT270115P00780000	put	780.0000	2027-01-15	51.0500	51.0500	51.8000	827.8700	51050.00	0.00	45945.00	10	6	25	215	0.116279069767442	0.407168459434699	0.407168459434699	false	false	false	true
0eeb654c-62e0-44dd-9afa-2f3210e20c88	2026-09-08 13:57	2026-09-08 13:56	2026-09-08 13:56	CAT	CAT270115C00920000	call	920.0000	2027-01-15	48.6900	46.1500	49.3000	827.8200	993270.00	779060.00	214210.00	204	15	207	965	0.214507772020725	0.401529418839639	0.400738213579813	false	false	false	true
626c498b-c8e5-4c92-a66b-18d3973f0ab0	2026-09-08 12:32	2026-09-08 12:31	2026-09-08 12:31	CAT	CAT260918P00750000	put	750.0000	2026-09-18	1.9500	1.9500	2.2300	825.4100	97500.00	0.00	97500.00	500	5	573	970	0.590721649484536	0.415659842199006	0.415659842199006	false	false	false	true
ffb9b9c9-7e70-450b-a0a2-1a9d7dd3dba4	2026-09-08 11:41	2026-09-08 11:41	2026-09-08 11:41	CAT	CAT270219P00860000	put	860.0000	2027-02-19	102.7500	99.4000	106.1000	826.5834	267150.00	51375.00	215775.00	26	6	26	39	0.666666666666667	0.419261642209934	0.419261642209934	false	false	false	true
413d9bfe-51d8-4aae-9c6c-3445d62055e9	2026-09-08 11:40	2026-09-08 11:40	2026-09-08 11:40	CAT	CAT261120C00820000	call	820.0000	2026-11-20	68.0600	63.5000	68.1500	826.4500	217805.00	156515.00	61290.00	32	5	34	76	0.447368421052632	0.420768643790074	0.420424172771089	false	false	false	true
0991ea9a-aa63-48fe-8c95-06dc285a21c4	2026-09-08 11:30	2026-09-08 11:30	2026-09-08 11:30	CAT	CAT280616C01340000	call	1340.0000	2028-06-16	75.0500	67.4000	83.8000	827.6600	67545.00	45030.00	22515.00	9	7	15	2	7.5	0.417344174450365	0.417344174450365	false	false	false	true
fd42ab9e-508c-4135-aad8-12f04b8b183c	2026-09-08 11:12	2026-09-08 11:12	2026-09-08 11:12	CAT	CAT270617C01260000	call	1260.0000	2027-06-17	26.0600	22.4000	27.7000	826.7000	96415.00	62760.00	33655.00	37	5	38	41	0.926829268292683	0.411428413440603	0.413484506275964	false	false	false	true
a7792c1e-c23d-425d-93f1-aa0eeba1d58d	2026-09-08 10:20	2026-09-08 10:20	2026-09-08 10:20	CAT	CAT270219C00940000	call	940.0000	2027-02-19	52.1500	49.8000	54.7500	821.8100	119945.00	114730.00	5215.00	23	6	24	30	0.8	0.404963726173037	0.40606118150375	false	false	false	true
fe4833e0-d709-4c13-9f9b-dbbe7211f417	2026-09-08 10:12	2026-09-08 10:12	2026-09-08 10:12	CAT	CAT261002C00770000	call	770.0000	2026-10-02	66.1900	62.7000	68.8000	821.1600	52950.00	6625.00	46325.00	8	8	8	3	2.66666666666667	0.408447375323519	0.400864721300988	false	false	false	true
582946ea-877a-48af-afab-b3e8bc3083e1	2026-09-08 10:12	2026-09-08 10:12	2026-09-08 10:12	CAT	CAT261002C00790000	call	790.0000	2026-10-02	51.9300	49.6000	57.7000	821.1600	77900.00	0.00	77900.00	15	7	15	7	2.14285714285714	0.400178805768681	0.393575998607179	false	false	false	true
1bf61e60-cf87-4e2c-806e-689b53698aaf	2026-09-04 15:53	2026-09-04 15:53	2026-09-04 15:53	CAT	CAT280121C01360000	call	1360.0000	2028-01-21	45.5400	45.1000	51.8000	811.8300	414395.00	13740.00	400655.00	91	8	319	626	0.509584664536741	0.414986611787109	0.412980524312146	false	false	false	true
2adc42d5-8609-43bf-a598-2340ff17e67f	2026-09-04 13:28	2026-09-04 13:28	2026-09-04 13:28	CAT	CAT270115C00800000	call	800.0000	2027-01-15	87.2500	85.0500	89.1000	810.3300	52350.00	8725.00	43625.00	6	6	122	1137	0.107299912049252	0.395058002183911	0.395058002183911	false	false	false	true
db59651f-ac1c-4209-a12d-15db91bc8a42	2026-09-04 10:04	2026-09-04 10:04	2026-09-04 10:04	CAT	CAT261023P00695000	put	695.0000	2026-10-23	5.3200	5.1000	6.7500	817.9350	95690.00	31575.00	63075.00	180	8	316	0	0	0.36988018372852	0.368894008095723	true	false	false	true
af78dde1-baa6-4d06-a7c9-3bb29c0f98a1	2026-09-04 09:59	2026-09-04 09:59	2026-09-04 09:59	CAT	CAT260911P00805000	put	805.0000	2026-09-11	9.7900	9.3000	10.7500	820.4500	67560.00	25900.00	31660.00	69	11	102	58	1.75862068965517	0.374735115132388	0.374735115132388	true	false	false	true
c53c1459-f7f8-4a5a-a8a7-e3801fda83c0	2026-09-04 09:58	2026-09-04 09:58	2026-09-04 09:58	CAT	CAT270115C01000000	call	1000.0000	2027-01-15	26.2400	25.5000	26.8000	820.1751	68230.00	50025.00	18205.00	26	6	55	1475	0.0372881355932203	0.389965678046712	0.393112497716361	true	false	false	true
90a1f0bc-6527-4772-bb42-8c57f59aad62	2026-09-04 09:45	2026-09-04 09:45	2026-09-04 09:45	CAT	CAT260918C00850000	call	850.0000	2026-09-18	9.8500	8.3000	10.2000	815.4300	59115.00	30865.00	28250.00	60	6	154	1793	0.0858895705521472	0.351579051099133	0.355219009874012	true	false	false	true
704006fc-374b-4df5-9645-1d6b92d5dbda	2026-09-04 09:45	2026-09-04 09:45	2026-09-04 09:45	CAT	CAT260918C00850000	call	850.0000	2026-09-18	9.8200	8.3000	10.0000	815.4300	80540.00	39600.00	40940.00	82	5	94	1793	0.0524261015058561	0.347011111662005	0.347926340120344	true	false	false	true
2ee96406-05b0-4cfa-a6fd-f5e78c0f9a02	2026-09-04 09:43	2026-09-04 09:43	2026-09-04 09:43	CAT	CAT260925P00770000	put	770.0000	2026-09-25	11.0700	10.7500	12.9500	812.5450	78605.00	22010.00	56595.00	71	10	82	83	0.987951807228916	0.369352446946224	0.362049025409557	true	false	false	true
54b61907-3e86-4e05-a092-c92efd525aa9	2026-09-03 11:29	2026-09-03 11:29	2026-09-03 11:29	CAT	CAT260925C00800000	call	800.0000	2026-09-25	30.5900	30.3000	31.2000	803.1150	171319.00	83254.00	88065.00	56	16	64	20	3.2	0.353985954583748	0.359104610926808	true	false	false	true
5347d3f4-ea79-4995-ac44-9ec33c69a086	2026-09-03 11:26	2026-09-03 11:26	2026-09-03 11:26	CAT	CAT270219C00910000	call	910.0000	2027-02-19	52.9400	43.4000	53.3000	802.1475	121760.00	121760.00	0.00	23	8	23	26	0.884615384615385	0.397766683273521	0.397766683273521	false	false	false	true
85c5e16b-8403-45cb-add4-c661aa572102	2026-09-03 10:51	2026-09-03 10:50	2026-09-03 10:50	CAT	CAT271217C00920000	call	920.0000	2027-12-17	115.6500	111.9000	121.4000	792.0700	57825.00	11565.00	46260.00	5	5	5	187	0.0267379679144385	0.405870729969476	0.405870729969476	false	false	false	true
d049a320-9248-46f1-8a11-a1a4aec71c82	2026-09-03 09:35	2026-09-03 09:35	2026-09-03 09:35	CAT	CAT261120P00730000	put	730.0000	2026-11-20	30.5900	29.2500	31.1500	786.8100	110135.00	58580.00	51555.00	36	11	38	239	0.158995815899582	0.409926610705667	0.403767304719436	false	false	false	true
94b9dcb3-f155-4fe0-b096-8a236d1c06d6	2026-09-03 09:33	2026-09-03 09:32	2026-09-03 09:32	CAT	CAT260918P00780000	put	780.0000	2026-09-18	18.9500	17.5500	19.7000	785.9400	58755.00	43440.00	15315.00	31	20	32	1074	0.0297951582867784	0.350135395864164	0.357310469152195	true	false	false	true
da13d30e-7586-4908-8c6e-8b2e011736cd	2026-09-02 15:45	2026-09-02 15:45	2026-09-02 15:45	CAT	CAT260918C00845000	call	845.0000	2026-09-18	6.7000	5.5500	7.0500	792.3100	67000.00	6030.00	60970.00	100	11	407	12	33.9166666666667	0.353791972819384	0.353791972819384	false	false	false	true
dcfad989-0c3d-45c0-af9b-4e640c370f6d	2026-09-02 15:39	2026-09-02 15:39	2026-09-02 15:39	CAT	CAT260918C00845000	call	845.0000	2026-09-18	6.7000	5.5500	7.0000	792.0600	67000.00	5360.00	61640.00	100	12	307	12	25.5833333333333	0.354887976339553	0.354887976339553	false	false	false	true
433fafa8-879e-41ea-85c6-cd149358f047	2026-09-02 15:39	2026-09-02 15:38	2026-09-02 15:38	CAT	CAT260918C00680000	call	680.0000	2026-09-18	114.2500	111.4000	114.2500	792.0300	411300.00	411300.00	0.00	36	12	36	189	0.19047619047619	0.42302530976313	0.42302530976313	false	false	false	true
0f9ac993-e99d-4936-85d4-5757dbe133b5	2026-09-02 15:35	2026-09-02 15:35	2026-09-02 15:35	CAT	CAT260918C00845000	call	845.0000	2026-09-18	6.5300	5.2000	6.8500	791.6300	65260.00	65260.00	0.00	100	14	207	12	17.25	0.349986857047711	0.349986857047711	false	false	false	true
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
b448539d-5aac-4a47-8ab6-1294cc72abad	2026-09-02 13:21	2026-09-02 13:21	2026-09-02 13:21	CAT	CAT271217C01000000	call	1000.0000	2027-12-17	88.2400	88.2000	91.8000	783.9150	88235.00	8855.00	79380.00	10	6	16	85	0.188235294117647	0.401907493239617	0.402908802411677	false	false	false	true
fb73079f-f650-4528-af89-3ce952c75d33	2026-09-02 13:03	2026-09-02 13:03	2026-09-02 13:03	CAT	CAT270917P00840000	put	840.0000	2027-09-17	145.6000	145.4500	152.8500	785.2100	160158.00	0.00	160158.00	11	6	22	0	0	0.427171934515712	0.427171934515712	false	false	false	true
027a00a2-b18a-4a2a-ae6f-65f176566ade	2026-09-02 13:00	2026-09-02 13:00	2026-09-02 13:00	CAT	CAT270917P00840000	put	840.0000	2027-09-17	146.1300	145.4500	152.8500	784.7300	160738.00	0.00	160738.00	11	8	11	0	0	0.428225540069827	0.428225540069827	false	false	false	true
5936553d-2234-4152-8d2c-0f0ec760d3ef	2026-09-02 12:15	2026-09-02 12:15	2026-09-02 12:15	CAT	CAT270617C01100000	call	1100.0000	2027-06-17	35.5000	32.0000	35.5000	787.3150	53250.00	53250.00	0.00	15	5	15	312	0.0480769230769231	0.399859583138494	0.399859583138494	false	false	false	true
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
3359861e-9c83-4136-8be8-4e0572e8c598	2026-09-01 15:09	2026-09-01 15:08	2026-09-01 15:08	CAT	CAT260904P00790000	put	790.0000	2026-09-04	17.2800	17.2000	18.4000	779.4400	103695.00	0.00	103695.00	60	7	678	790	0.858227848101266	0.405817742677416	0.403938700908394	false	false	false	true
1a552886-f683-4059-8057-022244a87ed1	2026-09-01 15:08	2026-09-01 15:08	2026-09-01 15:08	CAT	CAT260918C00700000	call	700.0000	2026-09-18	83.3500	79.2000	86.0000	779.3850	83352.00	83352.00	0.00	10	6	12	378	0.0317460317460317	0.387831516778646	0.385979640940401	false	false	false	true
bd78aa31-91ee-497f-9a63-2c0084bd5e3f	2026-09-01 14:48	2026-09-01 14:48	2026-09-01 14:48	CAT	CAT260904P00790000	put	790.0000	2026-09-04	19.3500	19.3500	20.1000	776.4800	121905.00	0.00	121905.00	63	12	341	790	0.431645569620253	0.398798391219947	0.4066186316013	false	false	false	true
2e5f1daa-4d21-4785-918b-f8853b56cbd8	2026-09-01 14:35	2026-09-01 14:35	2026-09-01 14:35	CAT	CAT271217P00580000	put	580.0000	2027-12-17	46.2500	41.9000	46.2500	776.5600	171120.00	171120.00	0.00	37	5	70	50	1.4	0.440262111099345	0.440262111099345	false	false	false	true
7c93000c-da7f-4c74-aba5-c6b4b02647e7	2026-09-01 12:49	2026-09-01 12:49	2026-09-01 12:49	CAT	CAT280616P00600000	put	600.0000	2028-06-16	66.9000	66.9000	66.9500	776.7300	93660.00	0.00	93660.00	14	5	174	137	1.27007299270073	0.429959094307342	0.429959094307342	false	false	false	true
d42d2751-d226-4383-935e-546c373b7e76	2026-09-01 09:57	2026-09-01 09:57	2026-09-01 09:57	CAT	CAT270115C00850000	call	850.0000	2027-01-15	51.4400	51.4000	54.0500	781.3400	66870.00	5150.00	61720.00	13	8	29	687	0.0422125181950509	0.386716278052016	0.387618730201793	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
3f913fda-b84e-471d-96fb-db774fa4bf1f	2026-08-31 15:42	2026-08-31 15:42	2026-08-31 15:42	CAT	CAT260904C00800000	call	800.0000	2026-09-04	10.8500	10.8500	11.7500	797.7300	59689.00	0.00	59689.00	55	11	473	98	4.8265306122449	0.353523345448702	0.353523345448702	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
e1727210-20ba-4835-812d-f25b3aa48621	2026-08-31 13:44	2026-08-31 13:44	2026-08-31 13:44	CAT	CAT270917C00780000	call	780.0000	2027-09-17	153.5000	147.9500	157.4500	793.4900	153500.00	153500.00	0.00	10	5	10	2	5	0.410746216663254	0.410746216663254	false	false	false	true
1d99134e-a1a1-4fb2-a474-9d2464233617	2026-08-31 12:54	2026-08-31 12:54	2026-08-31 12:54	CAT	CAT280121P00740000	put	740.0000	2028-01-21	108.9500	104.7500	111.0500	792.3050	54474.00	54474.00	0.00	5	5	10	346	0.0289017341040462	0.439499439283163	0.438706384418772	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