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 = RepeatedHits×ticker = W×

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

6af8f929-81c8-4dab-a5b2-12ba249f79ef	2026-09-03 09:54	2026-09-03 09:54	2026-09-03 09:54	W	W260911C00098000	call	98.0000	2026-09-11	3.2000	3.2000	3.3500	97.7100	16960.00	0.00	16960.00	53	15	138	23	6	0.571885130763987	0.571885130763987	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	12154609495.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0403d6ae-c2a1-4d1b-9fe6-8cf398c30613	2026-09-03 09:54	2026-09-03 09:53	2026-09-03 09:53	W	W260911C00098000	call	98.0000	2026-09-11	3.2500	2.8000	4.4000	97.7300	11050.00	9750.00	1300.00	34	7	66	23	2.8695652173913	0.57879085689236	0.57879085689236	false	false	false	true
5ace7fdb-930b-4231-a71e-6d9c5e28e4ef	2026-09-03 09:31	2026-09-03 09:31	2026-09-03 09:31	W	W260918C00092000	call	92.0000	2026-09-18	7.4500	6.4000	8.5000	97.5450	32791.00	32046.00	745.00	44	13	44	349	0.126074498567335	0.627131441055599	0.519272934850414	true	false	false	true
656ac6df-56c1-460d-8907-59d0b2a83650	2026-09-02 14:29	2026-09-02 14:29	2026-09-02 14:29	W	W260918C00097500	call	97.5000	2026-09-18	2.9500	2.9500	3.0000	94.1200	64018.00	888.00	63130.00	217	7	217	155	1.4	0.546997720491737	0.548305556575778	false	false	false	true	false
c373b014-aadb-437b-b399-865c3adf6e76	2026-09-01 15:52	2026-09-01 15:52	2026-09-01 15:52	W	W261016P00100000	put	100.0000	2026-10-16	10.6500	10.2500	10.8500	93.2050	38340.00	15975.00	22365.00	36	6	38	21	1.80952380952381	0.522831489538315	0.522831489538315	true	false	false	true
f3d51317-743d-4d65-a55b-07c4c5a8d0de	2026-09-01 15:49	2026-09-01 15:49	2026-09-01 15:49	W	W261218P00065000	put	65.0000	2026-12-18	1.8600	1.6300	1.8600	93.0700	37200.00	37200.00	0.00	200	12	210	173	1.21387283236994	0.629211456967115	0.629211456967115	false	false	false	true
141e3312-6c7e-45d1-b2e3-9f98b31abbfc	2026-09-01 14:52	2026-09-01 14:52	2026-09-01 14:52	W	W260911P00096000	put	96.0000	2026-09-11	4.3000	4.3000	4.6000	93.9400	196940.00	0.00	196940.00	458	51	458	10	45.8	0.514932702917036	0.514932702917036	false	false	false	true	false
ceaf4fce-1fe9-4bec-b6fe-616a89cf5832	2026-09-01 14:25	2026-09-01 14:24	2026-09-01 14:24	W	W261016P00085000	put	85.0000	2026-10-16	2.8600	2.6600	2.8600	94.2700	10868.00	10868.00	0.00	38	6	46	10	4.6	0.528126855449951	0.528126855449951	true	false	false	true	false
e15fdfba-2946-48d9-af86-89dd4ff38ea4	2026-09-01 14:06	2026-09-01 14:05	2026-09-01 14:05	W	W270319P00080000	put	80.0000	2027-03-19	8.6500	8.4000	8.6500	94.2050	110717.00	110717.00	0.00	128	18	128	13	9.84615384615385	0.610992597917742	0.610992597917742	false	false	false	true
3c53b6ca-c112-48aa-bf72-1a2152411d92	2026-09-01 14:06	2026-09-01 14:05	2026-09-01 14:05	W	W270820P00090000	put	90.0000	2027-08-20	17.9500	16.1000	17.9500	94.2050	28720.00	28720.00	0.00	16	7	16	1	16	0.619500318278683	0.619500318278683	false	false	false	true	false
fa5e7455-6c75-4e3b-932c-6cc06cb997a1	2026-09-01 13:57	2026-09-01 13:57	2026-09-01 13:57	W	W261120P00100000	put	100.0000	2026-11-20	13.6500	13.6500	13.7000	94.0650	13650.00	0.00	13650.00	10	5	16	966	0.0165631469979296	0.607482618425755	0.607482618425755	false	false	false	true
a1750aa6-94f6-4e68-b387-9737362cc52d	2026-09-01 13:36	2026-09-01 13:36	2026-09-01 13:36	W	W261218C00110000	call	110.0000	2026-12-18	7.2500	7.0000	7.2500	95.2900	54375.00	54375.00	0.00	75	9	76	70	1.08571428571429	0.584466519550197	0.584466519550197	false	false	false	true
6dc28df0-ec56-4acb-a9ad-97fa26fa212a	2026-09-01 13:23	2026-09-01 13:23	2026-09-01 13:23	W	W270319P00095000	put	95.0000	2027-03-19	15.1500	14.8500	15.1500	95.5850	10605.00	10605.00	0.00	7	5	233	28	8.32142857142857	0.598318217489819	0.598318217489819	false	false	false	true
03195728-1caa-4769-9b54-5ed491c275c2	2026-09-01 13:06	2026-09-01 13:06	2026-09-01 13:06	W	W260904P00095000	put	95.0000	2026-09-04	1.6300	1.6300	1.6600	95.8500	21232.00	2324.00	18908.00	130	6	133	321	0.414330218068536	0.600037211889535	0.600037211889535	true	false	false	true
13ab83e7-2a91-4106-92ed-16ea0150f14b	2026-09-01 12:56	2026-09-01 12:56	2026-09-01 12:56	W	W260904P00096000	put	96.0000	2026-09-04	2.0000	2.0000	2.1000	96.1350	16000.00	0.00	16000.00	80	7	96	198	0.484848484848485	0.599276591039234	0.599276591039234	false	false	false	true
c995f79b-5978-424b-a8d9-b4461fd67b12	2026-09-01 12:45	2026-09-01 12:45	2026-09-01 12:45	W	W261218C00105000	call	105.0000	2026-12-18	9.3000	8.7500	9.3000	96.4050	30690.00	30690.00	0.00	33	14	33	192	0.171875	0.584911486360468	0.584911486360468	false	false	false	true	false
3e62278e-626f-4ae0-b1e9-701802807247	2026-09-01 12:44	2026-09-01 12:44	2026-09-01 12:44	W	W270319P00095000	put	95.0000	2027-03-19	14.8000	14.4000	14.8000	96.4500	85840.00	85840.00	0.00	58	9	99	28	3.53571428571429	0.597643767813012	0.597643767813012	false	false	false	true
6c2f60c7-7c08-4568-bdde-6d92d9989299	2026-09-01 12:32	2026-09-01 12:31	2026-09-01 12:31	W	W270820P00100000	put	100.0000	2027-08-20	22.5500	22.0000	22.6000	96.0300	22550.00	20295.00	0.00	10	10	12	12	1	0.606990145318332	0.606990145318332	false	false	false	true	false
733a6b99-34b9-4f02-8011-8dd1ba43ff25	2026-09-01 11:41	2026-09-01 11:41	2026-09-01 11:41	W	W261120C00105000	call	105.0000	2026-11-20	8.0000	7.7500	8.3500	96.7300	17600.00	16000.00	1600.00	22	7	26	162	0.160493827160494	0.605139563924794	0.605139563924794	false	false	false	true
36d2b864-517d-40ab-afad-4aa31f48f597	2026-09-01 11:10	2026-09-01 11:10	2026-09-01 11:10	W	W260904P00100000	put	100.0000	2026-09-04	4.3500	3.9500	4.7000	96.5900	164422.00	860.00	163562.00	378	54	378	134	2.82089552238806	0.602224907079012	0.605570893361634	false	false	false	true
d24bf1ce-7f6a-479e-8c2e-0f3f13bd71b4	2026-09-01 10:39	2026-09-01 10:39	2026-09-01 10:39	W	W270115C00105000	call	105.0000	2027-01-15	11.2500	11.1500	11.3500	97.9400	10125.00	0.00	7875.00	9	9	11	9657	0.00113907010458735	0.566996667152658	0.566996667152658	false	false	false	true
33041717-f029-4019-a205-ac7ad26ed3f4	2026-08-31 15:51	2026-08-31 15:51	2026-08-31 15:51	W	W260918C00110000	call	110.0000	2026-09-18	1.2400	1.2400	1.4400	99.2000	38316.00	0.00	38316.00	309	33	1020	2607	0.391254315304948	0.517215847843708	0.517215847843708	false	false	false	true
295b2712-0a35-4734-a373-aea409a94374	2026-08-31 15:33	2026-08-31 15:33	2026-08-31 15:33	W	W261016P00075000	put	75.0000	2026-10-16	0.5900	0.5100	0.5900	98.2800	26904.00	26904.00	0.00	456	40	596	179	3.32960893854749	0.548089640959158	0.548089640959158	false	false	false	true
7cf9d524-a1b3-4de8-b820-22f239799f38	2026-08-31 15:08	2026-08-31 15:08	2026-08-31 15:08	W	W260911C00099000	call	99.0000	2026-09-11	3.3500	3.3500	3.4000	98.2150	11055.00	0.00	11055.00	33	9	350	0	0	0.538717352729971	0.538717352729971	false	false	false	true	false
c859c8f8-6428-43e6-a58e-142193620753	2026-08-31 15:07	2026-08-31 15:07	2026-08-31 15:07	W	W260911C00099000	call	99.0000	2026-09-11	3.1000	3.0500	3.1000	97.8100	24800.00	24800.00	0.00	80	11	106	0	0	0.530538461153174	0.530538461153174	false	false	false	true	false
d540121b-1b4d-4ea2-b928-32be897c42d7	2026-08-31 14:54	2026-08-31 14:53	2026-08-31 14:53	W	W270115C00095000	call	95.0000	2027-01-15	15.7500	14.9500	15.7500	98.0700	114975.00	114975.00	0.00	73	18	77	147	0.523809523809524	0.576280722443704	0.574513883925079	false	false	false	true
9dc245ab-f691-49af-9dee-6c4cb6c0859a	2026-08-31 14:22	2026-08-31 14:22	2026-08-31 14:22	W	W270319P00075000	put	75.0000	2027-03-19	5.9000	5.6500	5.9000	97.0000	50145.00	49560.00	585.00	85	8	2188	11	198.909090909091	0.605896322752061	0.603374821640277	false	false	false	true
e37d6536-2f2a-4faf-93d8-89a0b7b46e7d	2026-08-31 09:57	2026-08-31 09:56	2026-08-31 09:56	W	W260904C00098000	call	98.0000	2026-09-04	3.0000	3.0000	4.6500	98.8800	21000.00	0.00	21000.00	70	5	76	2	38	0.611389865786818	0.611389865786818	true	false	false	true	false
911e8bf4-ff0c-452b-88b3-4f96f930807c	2026-08-31 09:57	2026-08-31 09:56	2026-08-31 09:56	W	W260904C00097000	call	97.0000	2026-09-04	3.6000	3.6000	5.5500	98.8800	81720.00	0.00	81720.00	227	15	227	0	0	0.617367336902819	0.617367336902819	true	false	false	true	false
75d6bedd-3314-4a8a-bce1-a6fb04c38bde	2026-08-31 09:57	2026-08-31 09:56	2026-08-31 09:56	W	W260904C00096000	call	96.0000	2026-09-04	4.2500	4.2500	5.8000	98.8800	40800.00	0.00	40800.00	96	6	96	2	48	0.620955691385242	0.620955691385242	true	false	false	true	false
d6f951ac-8384-49f1-a3b5-1362a4648eff	2026-08-28 15:57	2026-08-28 15:57	2026-08-28 15:57	W	W260828C00103000	call	103.0000	2026-08-28	0.5700	0.1500	0.5700	103.5600	12255.00	12255.00	0.00	215	13	216	185	1.16756756756757	1.54818494732007	1.54818494732007	true	false	false	true
a63ef08a-4cec-4e30-8bf6-93550bc31bb8	2026-08-28 15:57	2026-08-28 15:57	2026-08-28 15:57	W	W260828P00104000	put	104.0000	2026-08-28	0.5900	0.0100	0.6000	103.5600	12449.00	12449.00	0.00	211	6	269	25	10.76	3.41628647838372	3.41628647838372	true	false	false	true	false
1e4fdc2e-6167-4cc0-ba97-e2948ecec43e	2026-08-28 14:46	2026-08-28 14:46	2026-08-28 14:46	W	W270219P00115000	put	115.0000	2027-02-19	22.3500	20.4000	22.4000	103.4300	29050.00	13410.00	13405.00	13	11	13	0	0	0.581157191340621	0.581157191340621	false	false	false	true	false
71383f4e-bbe6-4f5c-a232-1072a5c2b6c0	2026-08-28 13:03	2026-08-28 13:03	2026-08-28 13:03	W	W260918P00110000	put	110.0000	2026-09-18	8.4500	8.4500	8.7000	104.2050	110695.00	0.00	110695.00	131	16	133	1212	0.10973597359736	0.509219248503247	0.509219248503247	false	false	false	true
1a3dcfef-5b72-4d30-9080-ee3d6b0f5533	2026-08-27 13:57	2026-08-27 13:57	2026-08-27 13:57	W	W261016C00105000	call	105.0000	2026-10-16	9.0000	8.5500	9.6000	105.9300	11695.00	10795.00	900.00	13	13	13	43	0.302325581395349	0.531829459757953	0.531829459757953	false	false	false	true
d119e47c-1691-4a3e-84e2-5e0b10215e83	2026-08-27 10:29	2026-08-27 10:29	2026-08-27 10:29	W	W260828C00103000	call	103.0000	2026-08-28	2.6200	2.2600	2.6200	104.7550	19912.00	19912.00	0.00	76	10	250	290	0.862068965517241	0.72987658340836	0.72987658340836	true	false	false	true
d842290e-06c3-4a3a-8a02-8ced01a14532	2026-08-27 10:26	2026-08-27 10:26	2026-08-27 10:26	W	W260911C00111000	call	111.0000	2026-09-11	2.2400	2.2400	2.5800	105.1150	25314.00	0.00	25314.00	113	20	113	1	113	0.519734569703862	0.522335728630641	true	false	false	true	false
78d96472-70fb-46e2-89c7-3cafea1b8497	2026-08-26 14:31	2026-08-26 14:31	2026-08-26 14:31	W	W260904C00101000	call	101.0000	2026-09-04	6.3000	6.3000	6.5500	105.5150	14490.00	0.00	14490.00	23	18	25	14	1.78571428571429	0.545679070024835	0.545679070024835	true	false	false	true
37557f04-80f8-4734-a0f5-486911f80ad6	2026-08-26 14:18	2026-08-26 14:18	2026-08-26 14:18	W	W261016P00097500	put	97.5000	2026-10-16	4.4500	4.4500	4.5000	105.4950	22695.00	0.00	22695.00	51	9	51	203	0.251231527093596	0.530766205322057	0.530766205322057	false	false	false	true
89e1240f-8dd2-4c97-a40a-8985bc25f82d	2026-08-26 12:43	2026-08-26 12:42	2026-08-26 12:42	W	W261218P00115000	put	115.0000	2026-12-18	19.5500	19.5500	20.0500	104.3300	15640.00	0.00	15640.00	8	6	18	162	0.111111111111111	0.597469138283165	0.597353657343668	false	false	false	true
e8bc6015-a442-45ce-be36-f2db8e0584f2	2026-08-25 15:16	2026-08-25 15:15	2026-08-25 15:15	W	W260904C00105000	call	105.0000	2026-09-04	3.3500	3.3500	3.5000	103.8700	16415.00	0.00	16415.00	49	21	333	12	27.75	0.557165062039909	0.557165062039909	false	false	false	true	false
af579dc8-e97a-466a-bea6-bf10395f49cd	2026-08-25 13:53	2026-08-25 13:53	2026-08-25 13:53	W	W260918C00110000	call	110.0000	2026-09-18	3.3000	3.2500	3.4500	103.5350	17490.00	1320.00	16170.00	53	5	110	1274	0.0863422291993721	0.54006437490765	0.54006437490765	true	false	false	true
4638cca7-a69e-4321-8fc2-c3684bf826d8	2026-08-25 13:49	2026-08-25 13:49	2026-08-25 13:49	W	W260918P00110000	put	110.0000	2026-09-18	9.4500	9.4500	9.7500	103.4900	99225.00	0.00	99225.00	105	19	109	1323	0.0823885109599395	0.533028495210575	0.533028495210575	false	false	false	true
7526d74a-d2b7-4007-accc-4a7fa903c9f3	2026-08-25 12:50	2026-08-25 12:50	2026-08-25 12:50	W	W260918C00092000	call	92.0000	2026-09-18	13.9000	13.8500	14.4500	104.2650	12510.00	0.00	12510.00	9	6	408	0	0	0.555307817005754	0.555307817005754	false	false	false	true	false
78b72615-e33f-4378-8233-9411f60a8422	2026-08-25 12:01	2026-08-25 12:01	2026-08-25 12:01	W	W270115C00135000	call	135.0000	2027-01-15	6.3000	5.9500	6.3500	104.3000	14490.00	14490.00	0.00	23	5	303	41	7.39024390243902	0.57623240481826	0.57623240481826	false	false	false	true
e1dfc40e-c29c-4432-a5fe-7d4dc78d6306	2026-08-25 11:58	2026-08-25 11:58	2026-08-25 11:58	W	W260918C00092000	call	92.0000	2026-09-18	13.9000	13.9000	14.5500	104.3900	23630.00	0.00	23630.00	17	6	378	0	0	0.53939252659426	0.53939252659426	false	false	false	true	false
cd373a42-fda5-461e-9cb1-70462ec43cc5	2026-08-25 11:50	2026-08-25 11:49	2026-08-25 11:49	W	W270115C00135000	call	135.0000	2027-01-15	6.3500	6.0500	6.5500	104.4400	12700.00	12700.00	0.00	20	5	240	41	5.85365853658537	0.57650523478297	0.57650523478297	false	false	false	true
1a096aa6-706a-4fdd-b0ae-689fea895c00	2026-08-25 10:26	2026-08-25 10:26	2026-08-25 10:26	W	W260918C00110000	call	110.0000	2026-09-18	3.6000	3.5000	3.8000	104.5000	10440.00	0.00	8280.00	29	5	31	1274	0.0243328100470958	0.533960418648274	0.533960418648274	false	false	false	true
092c9af7-b10d-4386-9ffa-f40e9795c47f	2026-08-25 10:15	2026-08-25 10:15	2026-08-25 10:15	W	W260904C00105000	call	105.0000	2026-09-04	3.6500	3.6500	3.8000	104.2500	28835.00	0.00	28835.00	79	12	200	12	16.6666666666667	0.574030934576961	0.574030934576961	true	false	false	true
83602d40-d842-4a80-9e7c-69192a294fa7	2026-08-25 10:15	2026-08-25 10:15	2026-08-25 10:15	W	W260904C00105000	call	105.0000	2026-09-04	3.6000	3.5500	4.8000	104.0750	43200.00	5400.00	32400.00	120	8	120	12	10	0.57922798064149	0.57922798064149	false	false	false	true	false