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: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	price

0b8a81ee-b6fa-44b8-9282-19154ef9aeea	2026-09-01 10:43	2026-09-01 10:43	2026-09-01 10:43	SNOW	SNOW270219P00270000	put	270.0000	2027-02-19	21.8400	21.5500	22.2000	323.3100	69895.00	2180.00	65530.00	32	8	41	135	0.303703703703704	0.567383517897496	0.566656616229155	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	117253080000.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bd38c909-a0a7-4088-9d7c-b376dc4196bd	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	SNOW	SNOW260904P00300000	put	300.0000	2026-09-04	8.4000	7.9000	8.8500	325.1800	183960.00	183960.00	0.00	219	7	223	1345	0.165799256505576	1.62409826186594	1.62409826186594	true	false	false	true	false
3da9fde6-730b-4359-a128-db062fb216e1	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	SNOW	SNOW260904P00310000	put	310.0000	2026-09-04	12.1000	12.1000	12.7000	325.1800	169400.00	0.00	169400.00	140	5	149	590	0.252542372881356	1.63504466402083	1.63504466402083	true	false	false	true	false
cefe6b89-6d82-4c28-8f38-753181fcdc61	2026-08-31 15:57	2026-08-31 15:57	2026-08-31 15:57	SNOW	SNOW260918P00340000	put	340.0000	2026-09-18	27.4500	27.4500	28.7500	331.4300	205875.00	0.00	205875.00	75	22	97	192	0.505208333333333	0.784241788803392	0.784241788803392	false	false	false	true	false
fd0abbf4-99b6-4dff-ba2d-f1e888465170	2026-08-31 15:23	2026-08-31 15:23	2026-08-31 15:23	SNOW	SNOW260918C00330000	call	330.0000	2026-09-18	23.6500	23.3000	23.9000	330.4350	236500.00	167915.00	68585.00	100	16	163	1283	0.127045985970382	0.791939668529284	0.791939668529284	false	false	false	true	false
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
b5a1e2d4-7db9-44d5-9412-9a767f19e11f	2026-08-31 14:00	2026-08-31 13:59	2026-08-31 13:59	SNOW	SNOW260904C00322500	call	322.5000	2026-09-04	22.2500	22.2500	22.9000	328.0000	293736.00	0.00	293736.00	132	30	166	43	3.86046511627907	1.41036423706519	1.41036423706519	false	false	false	true	false
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	false
87f53501-36ae-41ea-ba37-d2b06971a2a6	2026-08-31 14:00	2026-08-31 13:59	2026-08-31 13:59	SNOW	SNOW260904C00317500	call	317.5000	2026-09-04	25.0100	25.0000	25.5000	328.0000	112540.00	2525.00	110015.00	45	14	46	36	1.27777777777778	1.41400485589094	1.43308728864021	false	false	false	true	false
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	false
ce58ed53-bf1a-4380-ac31-8841ad480554	2026-08-31 10:02	2026-08-31 10:02	2026-08-31 10:02	SNOW	SNOW260918P00335000	put	335.0000	2026-09-18	28.0900	27.9500	29.1500	325.1100	98300.00	25415.00	72885.00	35	23	49	15	3.26666666666667	0.790679214943921	0.792780425422128	true	false	false	true	false
40a257b7-8b17-4939-ba79-8307ddfaaca5	2026-08-31 09:48	2026-08-31 09:48	2026-08-31 09:48	SNOW	SNOW270219P00250000	put	250.0000	2027-02-19	15.6000	13.9500	16.1500	324.5950	112335.00	110780.00	1555.00	72	6	72	110	0.654545454545455	0.577838390285955	0.574462162117427	false	false	false	true	false
1f412d23-088b-4f4a-8513-13c6aece7851	2026-08-31 09:48	2026-08-31 09:48	2026-08-31 09:48	SNOW	SNOW270219P00270000	put	270.0000	2027-02-19	22.4700	20.0000	22.5000	324.5950	51685.00	49495.00	2190.00	23	15	23	99	0.232323232323232	0.577163572451419	0.577163572451419	false	false	false	true	false
3d9847ad-0546-4595-ac57-be44c47e441e	2026-08-31 09:43	2026-08-31 09:43	2026-08-31 09:43	SNOW	SNOW260911C00330000	call	330.0000	2026-09-11	20.9500	20.9500	21.8000	328.0200	303777.00	0.00	303777.00	145	33	165	315	0.523809523809524	0.9466433217496	0.955854538573841	false	false	false	true	false
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	false
9316c810-21ff-44a3-9704-dd415ff2e5af	2026-08-28 13:50	2026-08-28 13:50	2026-08-28 13:50	SNOW	SNOW261120C00430000	call	430.0000	2026-11-20	9.3200	9.3000	9.5000	329.7150	65270.00	7600.00	57670.00	70	9	161	131	1.22900763358779	0.56612044170071	0.565019953137905	true	false	false	true	false
aae73811-0044-4428-978d-0ae1980f7392	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	SNOW	SNOW260911P00335000	put	335.0000	2026-09-11	23.7500	23.3500	24.8500	331.8250	71250.00	0.00	71250.00	30	8	42	55	0.763636363636364	0.858893442118377	0.862753130102681	true	false	false	true	false
dacb2f27-0162-4f74-865d-9501ada303f1	2026-08-28 10:56	2026-08-28 10:56	2026-08-28 10:56	SNOW	SNOW260904P00270000	put	270.0000	2026-09-04	2.0900	2.0900	2.4500	331.0960	74828.00	0.00	74828.00	358	51	380	341	1.11436950146628	1.1302663825197	1.13169362040329	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
be4b55da-fc65-4e09-ae74-cc6375337c0e	2026-08-27 11:54	2026-08-27 11:54	2026-08-27 11:54	SNOW	SNOW260828C00330000	call	330.0000	2026-08-28	3.9000	3.9000	4.4000	329.3500	69429.00	0.00	69429.00	178	36	394	1187	0.331929233361415	0.610249616660551	0.610249616660551	false	false	false	true	false
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	false
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	false
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	false
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	false
eae04d2f-c446-465b-9564-8ef3a1d6766b	2026-08-27 10:35	2026-08-27 10:35	2026-08-27 10:35	SNOW	SNOW271217P00280000	put	280.0000	2027-12-17	52.9000	50.6500	54.9500	329.6800	100510.00	63540.00	36970.00	19	5	69	8	8.625	0.604599585427556	0.604641954892773	false	false	false	true	false
42ee150e-c904-416a-8ad9-552115ae9dd5	2026-08-27 10:35	2026-08-27 10:35	2026-08-27 10:35	SNOW	SNOW271217P00290000	put	290.0000	2027-12-17	57.7700	57.1500	58.8000	329.6600	155980.00	63675.00	92305.00	27	9	158	11	14.3636363636364	0.602814423425731	0.602416551257201	false	false	false	true	false
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	false
1053f736-86aa-4733-a1a5-8605a60e9cec	2026-08-27 10:31	2026-08-27 10:31	2026-08-27 10:31	SNOW	SNOW270115C00340000	call	340.0000	2027-01-15	47.2800	46.4500	48.4500	332.1600	676150.00	434920.00	241230.00	143	10	3040	2107	1.44280968201234	0.595759589077493	0.594306494430345	false	false	false	true	false
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	false
f04c8460-7bf5-4eb9-9766-29a92c24e0c9	2026-08-27 10:13	2026-08-27 10:13	2026-08-27 10:13	SNOW	SNOW261016P00350000	put	350.0000	2026-10-16	40.7000	39.5500	40.7000	332.7500	2165191.00	2165191.00	0.00	532	56	532	134	3.97014925373134	0.646153245628367	0.646153245628367	false	false	false	true	false
a840b941-c948-438c-9539-5e126d2f6f8c	2026-08-27 10:13	2026-08-27 10:13	2026-08-27 10:13	SNOW	SNOW261016P00320000	put	320.0000	2026-10-16	23.5400	23.5000	24.5000	332.9800	65925.00	2375.00	63550.00	28	14	31	65	0.476923076923077	0.630807021218646	0.636140486102598	false	false	false	true	false
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	false
2359a213-fdf8-4b39-90ff-ad9e6de9505a	2026-08-27 10:12	2026-08-27 10:12	2026-08-27 10:12	SNOW	SNOW260918P00330000	put	330.0000	2026-09-18	23.7800	23.2000	23.8500	332.0000	66590.00	40465.00	26125.00	28	6	47	626	0.0750798722044728	0.779504685842052	0.777952073166388	false	false	false	true	false
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	false
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	false
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	false
f014f203-c73a-4fbe-9928-941f81f0107d	2026-08-26 15:41	2026-08-26 15:41	2026-08-26 15:41	SNOW	SNOW270115C00370000	call	370.0000	2027-01-15	27.9600	27.3000	28.0500	315.6450	53120.00	30805.00	22315.00	19	7	141	698	0.202005730659026	0.577534477506061	0.576230400681551	false	false	false	true	false
e51fe31a-0d14-487b-acbb-ed91d2009421	2026-08-26 15:06	2026-08-26 15:06	2026-08-26 15:06	SNOW	SNOW261016C00320000	call	320.0000	2026-10-16	28.1900	27.4000	28.5500	316.0900	135290.00	70395.00	64895.00	48	26	95	548	0.173357664233577	0.62176307338177	0.62176307338177	true	false	false	true	false
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	false
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	false
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	false
3fa55c3c-e7b8-4ef8-b9fa-e35f43fee61e	2026-08-26 12:48	2026-08-26 12:47	2026-08-26 12:47	SNOW	SNOW270115C00320000	call	320.0000	2027-01-15	45.6100	45.2000	45.6500	314.7800	168770.00	168770.00	0.00	37	8	532	1502	0.354194407456724	0.587290259306945	0.587939065422525	true	false	false	true	false
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	false
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	false
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	false