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 = SNOW×

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

6424c178-12f1-4964-8307-c86b0d019e02	2026-08-31 14:49	2026-08-31 14:48	2026-08-31 14:48	SNOW	SNOW260911P00270000	put	270.0000	2026-09-11	2.5600	2.5600	2.8900	329.4150	51976.00	0.00	51976.00	203	39	211	94	2.24468085106383	0.937781858712299	0.939846420842291	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	117253080000.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b0ee92b7-dfce-428c-8863-54101cbc9296	2026-08-31 14:00	2026-08-31 13:59	2026-08-31 13:59	SNOW	SNOW260904C00320000	call	320.0000	2026-09-04	23.7000	23.7000	24.2000	328.0000	75840.00	0.00	75840.00	32	11	147	353	0.41643059490085	1.41977508426398	1.41977508426398	false	false	false	true
d4e9d361-216b-45c7-8028-0918489a8541	2026-08-31 12:36	2026-08-31 12:36	2026-08-31 12:36	SNOW	SNOW261002P00355000	put	355.0000	2026-10-02	42.3500	42.3500	44.0000	326.2650	127050.00	0.00	127050.00	30	16	31	1	31	0.656737285069205	0.656737285069205	false	false	false	true
99cbd4a7-0ff8-47ea-ac3f-17ea89344538	2026-08-28 14:23	2026-08-28 14:23	2026-08-28 14:23	SNOW	SNOW270115P00340000	put	340.0000	2027-01-15	50.7500	48.9500	50.7500	329.2699	55825.00	55825.00	0.00	11	5	11	68	0.161764705882353	0.586800828264471	0.586800828264471	false	false	false	true
651e4267-5be2-4f0d-bba0-346e14821aba	2026-08-28 10:02	2026-08-28 10:02	2026-08-28 10:02	SNOW	SNOW260925C00290000	call	290.0000	2026-09-25	48.0800	47.5000	49.4500	328.0700	120200.00	0.00	120200.00	25	14	35	6	5.83333333333333	0.698149523478336	0.694491799838595	false	false	false	true
f90d192d-41bc-41ca-a8dc-03a9b4471ebb	2026-08-28 09:33	2026-08-28 09:33	2026-08-28 09:33	SNOW	SNOW260918C00360000	call	360.0000	2026-09-18	13.3000	12.5000	13.8000	332.4000	74480.00	5320.00	5320.00	56	24	128	1465	0.0873720136518771	0.738642590912318	0.738642590912318	false	false	false	true
41b909af-c193-4bfb-a230-7839d524c283	2026-08-27 12:26	2026-08-27 12:25	2026-08-27 12:25	SNOW	SNOW260918P00260000	put	260.0000	2026-09-18	2.8700	2.8700	3.2000	332.2101	105903.00	0.00	105903.00	369	34	404	932	0.433476394849785	0.80156004641861	0.80156004641861	false	false	false	true
2939cd50-44af-4eb5-8590-db5398b60737	2026-08-27 12:18	2026-08-27 12:18	2026-08-27 12:18	SNOW	SNOW260904C00375000	call	375.0000	2026-09-04	7.0000	6.6000	7.0000	331.5000	175000.00	175000.00	0.00	250	5	289	1025	0.281951219512195	1.0685481297061	1.0685481297061	false	false	false	true
e36bbde9-dde5-468a-bfb0-5e1973670952	2026-08-27 12:18	2026-08-27 12:17	2026-08-27 12:17	SNOW	SNOW260925C00315000	call	315.0000	2026-09-25	35.4500	32.4000	35.4500	331.4950	77990.00	77990.00	0.00	22	6	46	45	1.02222222222222	0.712117808116676	0.712117808116676	false	false	false	true
0042227a-d548-43d8-8c77-bccf5f339593	2026-08-27 12:01	2026-08-27 12:00	2026-08-27 12:00	SNOW	SNOW260918C00290000	call	290.0000	2026-09-18	49.3500	47.4500	50.7000	330.6700	64155.00	64155.00	0.00	13	10	29	1074	0.0270018621973929	0.793860134386012	0.760286752378538	true	false	false	true
a4c045fa-18ed-41f5-a14e-cb7d6d9edd79	2026-08-27 11:41	2026-08-27 11:41	2026-08-27 11:41	SNOW	SNOW260904P00300000	put	300.0000	2026-09-04	9.3500	8.8000	9.3500	328.7750	55165.00	55165.00	0.00	59	8	116	854	0.135831381733021	1.117665889862	1.117665889862	true	false	false	true
4492e0aa-8a5f-4db1-aabb-d9a0985ed1f0	2026-08-27 11:31	2026-08-27 11:30	2026-08-27 11:30	SNOW	SNOW280121P00370000	put	370.0000	2028-01-21	104.6500	102.6000	107.2000	330.2600	596505.00	345345.00	251160.00	57	6	57	32	1.78125	0.59237282767082	0.59237282767082	true	false	false	true
a281fbec-4bf2-4a07-af40-b86265f63e72	2026-08-27 11:09	2026-08-27 11:09	2026-08-27 11:09	SNOW	SNOW270617P00290000	put	290.0000	2027-06-17	43.1500	41.1000	43.7000	331.1600	69035.00	64720.00	4315.00	16	10	16	62	0.258064516129032	0.600338789844993	0.599196718579586	false	false	false	true
6ade1f85-c382-422a-9e12-a68eae22b0d4	2026-08-27 11:08	2026-08-27 11:08	2026-08-27 11:08	SNOW	SNOW280121C00460000	call	460.0000	2028-01-21	60.8000	60.1000	61.3000	331.4500	85120.00	24320.00	60800.00	14	14	28	19	1.47368421052632	0.596129433813789	0.596129433813789	false	false	false	true
d9476cf8-31de-47e6-a158-98feebfc4b4a	2026-08-27 10:35	2026-08-27 10:35	2026-08-27 10:35	SNOW	SNOW270115C00340000	call	340.0000	2027-01-15	45.6000	44.8500	46.4000	329.4000	164160.00	31920.00	132240.00	36	5	3149	2107	1.49454200284765	0.591740735334298	0.591740735334298	false	false	false	true
a9fd34b1-54a1-4497-b00d-fec687a346c5	2026-08-27 10:22	2026-08-27 10:22	2026-08-27 10:22	SNOW	SNOW260904C00370000	call	370.0000	2026-09-04	9.4500	9.0000	9.6000	332.2150	57640.00	36855.00	20785.00	61	5	396	157	2.52229299363057	1.14127729851306	1.13831447397364	false	false	false	true
0e1ff9b6-1e97-4276-a592-a0a0638f68d4	2026-08-27 10:12	2026-08-27 10:12	2026-08-27 10:12	SNOW	SNOW260918P00330000	put	330.0000	2026-09-18	23.7900	23.3000	24.2000	332.0000	61850.00	47600.00	14250.00	26	8	73	626	0.116613418530351	0.776709999129524	0.77981521106851	false	false	false	true
e82d8784-290e-4b77-b806-7c3c26f973d0	2026-08-27 10:05	2026-08-27 10:05	2026-08-27 10:05	SNOW	SNOW260828C00340000	call	340.0000	2026-08-28	1.5500	1.5500	1.9600	329.9450	69750.00	0.00	69750.00	450	8	708	2081	0.340221047573282	0.723183921290729	0.723183921290729	true	false	false	true
bec600f4-9618-4b98-b8e1-f662d8391bcd	2026-08-27 09:49	2026-08-27 09:49	2026-08-27 09:49	SNOW	SNOW260918C00327500	call	327.5000	2026-09-18	25.3500	23.2500	25.3500	327.7000	86190.00	86190.00	0.00	34	9	34	12	2.83333333333333	0.777241788515947	0.777241788515947	false	false	false	true
2eb87063-b4dd-46af-b4e0-e93a35e73311	2026-08-27 09:43	2026-08-27 09:43	2026-08-27 09:43	SNOW	SNOW261218C00330000	call	330.0000	2026-12-18	43.2000	40.7500	45.6500	326.1500	69120.00	4320.00	4320.00	16	16	16	976	0.0163934426229508	0.598929057472012	0.598929057472012	false	false	false	true
25b4a85c-0b64-4f71-9ef9-3496f39568e7	2026-08-26 15:06	2026-08-26 15:06	2026-08-26 15:06	SNOW	SNOW260828C00330000	call	330.0000	2026-08-28	1.0700	0.9200	1.0700	316.0900	54569.00	54463.00	106.00	510	62	660	674	0.979228486646884	0.564449993563209	0.564449993563209	false	false	false	true
6d0e1f0e-aa81-40b9-a9b0-b9cb82a6c4df	2026-08-26 14:58	2026-08-26 14:58	2026-08-26 14:58	SNOW	SNOW271217C00400000	call	400.0000	2027-12-17	64.7500	63.2500	65.8500	316.5442	194250.00	51800.00	142450.00	30	6	31	534	0.0580524344569288	0.595992377316014	0.595992377316014	true	false	false	true
2a3db420-c9a2-4909-a8ab-0eaabe59a22e	2026-08-26 13:32	2026-08-26 13:32	2026-08-26 13:32	SNOW	SNOW260918C00410000	call	410.0000	2026-09-18	2.4000	2.3000	2.6900	315.1400	126748.00	1228.00	125520.00	528	29	537	95	5.65263157894737	0.738639911877161	0.743859718520254	true	false	false	true
5158eb44-4d87-4a90-9f03-14ac8ed5feb3	2026-08-26 12:46	2026-08-26 12:46	2026-08-26 12:46	SNOW	SNOW270115C00320000	call	320.0000	2027-01-15	45.6500	45.2000	45.6500	314.8000	100430.00	100430.00	0.00	22	5	468	1502	0.311584553928096	0.587790719878536	0.587790719878536	false	false	false	true
6060fc28-be3c-4e69-88c5-9150f7f3ea9b	2026-08-26 12:45	2026-08-26 12:45	2026-08-26 12:45	SNOW	SNOW270115C00320000	call	320.0000	2027-01-15	45.5500	45.2000	45.7500	314.7250	127540.00	127540.00	0.00	28	5	367	1502	0.244340878828229	0.58704924679261	0.58704924679261	false	false	false	true
0909458e-be5a-476f-bcee-637751c064fa	2026-08-26 11:57	2026-08-26 11:57	2026-08-26 11:57	SNOW	SNOW261218P00290000	put	290.0000	2026-12-18	28.2000	27.7000	28.9000	314.9500	1404360.00	0.00	1404360.00	498	8	498	661	0.753403933434191	0.612846083611659	0.612846083611659	false	false	false	true
a7c6ffa3-49f3-4b7f-86f2-6549f6ba7c77	2026-08-26 11:49	2026-08-26 11:49	2026-08-26 11:49	SNOW	SNOW270917C00310000	call	310.0000	2027-09-17	84.2000	82.5500	87.4500	315.1500	151560.00	33680.00	117880.00	18	5	41	392	0.104591836734694	0.603086265036137	0.603086265036137	true	false	false	true
767ede16-670c-4b48-80b0-7f912e65e938	2026-08-26 11:40	2026-08-26 11:40	2026-08-26 11:40	SNOW	SNOW270219C00300000	call	300.0000	2027-02-19	59.9500	59.8500	60.6500	315.5350	671440.00	659450.00	11990.00	112	11	239	44	5.43181818181818	0.577832087884449	0.577832087884449	false	false	false	true
d4c2500e-d76f-4644-8021-079cdff9981d	2026-08-26 11:39	2026-08-26 11:39	2026-08-26 11:39	SNOW	SNOW270917C00310000	call	310.0000	2027-09-17	84.2000	82.3500	87.5500	315.4400	50520.00	25260.00	25260.00	6	6	23	392	0.0586734693877551	0.601483157230434	0.601483157230434	false	false	false	true
2b1b7746-2834-4480-9a68-760e06da2fb9	2026-08-26 11:39	2026-08-26 11:39	2026-08-26 11:39	SNOW	SNOW270219P00320000	put	320.0000	2027-02-19	48.5000	48.5000	51.1500	315.4400	198850.00	0.00	198850.00	41	12	44	35	1.25714285714286	0.567038584630057	0.567038584630057	true	false	false	true
e39be800-07d6-427f-b124-7f43af816124	2026-08-26 11:38	2026-08-26 11:38	2026-08-26 11:38	SNOW	SNOW270115C00320000	call	320.0000	2027-01-15	45.2300	45.2000	47.6500	314.8900	492965.00	0.00	492965.00	109	13	235	1502	0.156458055925433	0.581285992516794	0.581285992516794	true	false	false	true
ca459c59-7436-43d4-906c-7ee0b06324cb	2026-08-26 11:38	2026-08-26 11:38	2026-08-26 11:38	SNOW	SNOW270219C00300000	call	300.0000	2027-02-19	59.3300	59.3000	62.7000	314.8900	350030.00	0.00	350030.00	59	14	78	44	1.77272727272727	0.574968553316988	0.576192229193138	true	false	false	true
c76a7f4f-ed03-4dc9-9ea4-a192421a1f3b	2026-08-26 11:38	2026-08-26 11:38	2026-08-26 11:38	SNOW	SNOW270219P00310000	put	310.0000	2027-02-19	43.7100	42.9500	45.8000	314.8900	450165.00	0.00	450165.00	103	10	110	10	11	0.570716772128794	0.575481158352691	true	false	false	true
c1e31def-ff66-428b-9d7b-4a562a30ae90	2026-08-26 11:38	2026-08-26 11:38	2026-08-26 11:38	SNOW	SNOW270115P00300000	put	300.0000	2027-01-15	34.9600	34.9500	36.7500	314.8900	304175.00	0.00	304175.00	87	17	261	1155	0.225974025974026	0.582832746293539	0.584193108127436	true	false	false	true
aaf8c335-c448-44ea-b767-d2147cccfc8a	2026-08-26 11:38	2026-08-26 11:38	2026-08-26 11:38	SNOW	SNOW270219P00300000	put	300.0000	2027-02-19	38.5300	38.3500	41.0000	314.8900	577915.00	0.00	577915.00	150	14	150	59	2.54237288135593	0.570462647819134	0.578416365954115	true	false	false	true
4160eda2-e62a-4973-b0af-c4dfe4544723	2026-08-26 11:38	2026-08-26 11:38	2026-08-26 11:38	SNOW	SNOW270115C00310000	call	310.0000	2027-01-15	50.0500	50.0500	52.3500	314.8900	65065.00	0.00	65065.00	13	6	159	630	0.252380952380952	0.587546217820837	0.587546217820837	true	false	false	true
58f68809-68c2-43ee-ac04-f1b84a0cac50	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	SNOW	SNOW270115C00310000	call	310.0000	2027-01-15	50.2500	50.2500	52.6000	314.7100	522645.00	5070.00	517575.00	104	20	104	630	0.165079365079365	0.591073537678989	0.591634279846942	true	false	false	true
1a8c9cdd-4892-4351-b28f-727d4ef8d6c3	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	SNOW	SNOW270115P00300000	put	300.0000	2027-01-15	34.9500	34.9500	36.8000	314.7800	604635.00	0.00	604635.00	173	6	174	1155	0.150649350649351	0.582293117116651	0.582293117116651	true	false	false	true
0b746269-c668-4bf8-91ef-1249f1c63ef8	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	SNOW	SNOW270115P00320000	put	320.0000	2027-01-15	45.5000	45.5000	47.5500	314.7100	659750.00	0.00	659750.00	145	15	145	1380	0.105072463768116	0.581580352426669	0.5811904776669	true	false	false	true
744918ea-d76e-466f-a90b-ab026f96dc82	2026-08-25 15:02	2026-08-25 15:02	2026-08-25 15:02	SNOW	SNOW270115C00370000	call	370.0000	2027-01-15	28.7000	27.8500	29.4500	314.6950	229600.00	2870.00	226730.00	80	33	230	633	0.363349131121643	0.589542628740688	0.589542628740688	true	false	false	true
e7c80d93-9e23-4891-bf2e-b942d43b88ea	2026-08-25 15:01	2026-08-25 15:01	2026-08-25 15:01	SNOW	SNOW280121P00240000	put	240.0000	2028-01-21	40.1500	40.1500	41.8000	314.7500	212810.00	0.00	212810.00	53	19	53	1869	0.0283574103798823	0.61595165165606	0.616420554284871	true	false	false	true
e24026f4-9768-4948-96e5-af4e41194531	2026-08-25 14:20	2026-08-25 14:20	2026-08-25 14:20	SNOW	SNOW281215P00220000	put	220.0000	2028-12-15	46.3500	46.3500	47.1500	312.0000	537672.00	0.00	537672.00	116	10	419	7	59.8571428571429	0.625066585676676	0.625066585676676	false	false	false	true
12ccaf0d-18a9-4cbd-a0db-23ddd6852176	2026-08-25 14:16	2026-08-25 14:16	2026-08-25 14:16	SNOW	SNOW281215P00220000	put	220.0000	2028-12-15	46.9500	46.4000	46.9500	311.0000	75120.00	75120.00	0.00	16	5	212	7	30.2857142857143	0.629116004975459	0.628866157968263	false	false	false	true
93f9fa73-8ff1-41ec-ab68-18485dc4eae5	2026-08-25 13:39	2026-08-25 13:39	2026-08-25 13:39	SNOW	SNOW260828P00300000	put	300.0000	2026-08-28	2.0000	1.8700	2.0000	313.5200	100000.00	100000.00	0.00	500	7	750	1284	0.58411214953271	0.606476618697809	0.606476618697809	true	false	false	true
2d1c8ef9-ecd1-483e-84cc-279cb8cdb96c	2026-08-25 11:24	2026-08-25 11:24	2026-08-25 11:24	SNOW	SNOW261218P00290000	put	290.0000	2026-12-18	28.4000	28.4000	29.0500	317.3200	102240.00	0.00	102240.00	36	5	339	364	0.931318681318681	0.625627366682188	0.625627366682188	false	false	false	true
017d3a73-3afb-4880-a0c9-d902d60aef0a	2026-08-25 11:22	2026-08-25 11:22	2026-08-25 11:22	SNOW	SNOW261218P00290000	put	290.0000	2026-12-18	28.4000	28.4000	28.6500	317.3100	107920.00	0.00	59640.00	38	5	285	364	0.782967032967033	0.62557710120648	0.62557710120648	false	false	false	true
6db207e1-2fed-409c-89bb-c726544ee4ea	2026-08-25 11:21	2026-08-25 11:21	2026-08-25 11:21	SNOW	SNOW261218P00290000	put	290.0000	2026-12-18	28.3500	27.8500	28.6500	317.0300	104895.00	22680.00	82215.00	37	5	125	364	0.343406593406593	0.623383359618821	0.623383359618821	false	false	false	true
da90379f-3c29-4ad9-a39d-3d1631d6edb8	2026-08-25 11:21	2026-08-25 11:21	2026-08-25 11:21	SNOW	SNOW261218P00290000	put	290.0000	2026-12-18	28.3000	28.3000	28.6500	317.0300	107540.00	0.00	107540.00	38	5	63	364	0.173076923076923	0.622598712477728	0.622598712477728	false	false	false	true
5d29169c-a6bd-4533-9f13-f748cb2b77ec	2026-08-24 15:49	2026-08-24 15:48	2026-08-24 15:48	SNOW	SNOW270115C00420000	call	420.0000	2027-01-15	19.9000	19.9000	20.9000	322.4300	398000.00	0.00	398000.00	200	5	202	903	0.223698781838317	0.587258187745713	0.587258187745713	false	false	false	true
c753858d-ab8e-4e7d-af6a-67b4e9a62978	2026-08-24 15:40	2026-08-24 15:40	2026-08-24 15:40	SNOW	SNOW260828P00305000	put	305.0000	2026-08-28	1.7800	1.4800	1.7800	322.7250	112139.00	112139.00	0.00	630	58	708	204	3.47058823529412	0.579379837960783	0.579379837960783	false	false	false	true