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

414cc6a3-47b9-446c-89d3-062187ee702f	2026-09-14 14:21	2026-09-14 14:21	2026-09-14 14:21	SNOW	SNOW261016C00350000	call	350.0000	2026-10-16	11.7500	11.3000	12.4500	333.5400	119855.00	1175.00	118680.00	102	11	811	1775	0.456901408450704	0.455112415454006	0.456154063271261	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-09-14T18:49:41.095224Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3c5c077d-5256-45ae-a35d-dd2c8fcafe0f	2026-09-14 14:20	2026-09-14 14:20	2026-09-14 14:20	SNOW	SNOW260918P00330000	put	330.0000	2026-09-18	5.4000	5.1000	5.4000	334.3450	156060.00	156060.00	0.00	289	31	470	1200	0.391666666666667	0.540517455308903	0.535703329327043	false	false	false	true
5b1ed498-da81-4c21-aedd-a82385e23b57	2026-09-14 14:17	2026-09-14 14:17	2026-09-14 14:17	SNOW	SNOW261218P00310000	put	310.0000	2026-12-18	24.1000	24.1000	24.6000	334.3000	60250.00	0.00	60250.00	25	7	37	132	0.28030303030303	0.558000615866809	0.558000615866809	false	false	false	true
fcd2fc5d-7dad-4048-92ed-10cc99b14434	2026-09-14 14:14	2026-09-14 14:14	2026-09-14 14:14	SNOW	SNOW281215P00270000	put	270.0000	2028-12-15	58.9000	57.6000	59.5000	334.6400	300395.00	141365.00	88350.00	51	19	123	19	6.47368421052632	0.568259338443037	0.568932052811675	false	false	false	true
d653165b-bc0e-428f-9242-d91e92ed58f4	2026-09-14 13:10	2026-09-14 13:10	2026-09-14 13:10	SNOW	SNOW260925P00350000	put	350.0000	2026-09-25	20.5000	19.7500	22.1500	334.3400	53305.00	2045.00	47150.00	26	15	30	34	0.882352941176471	0.467556675844634	0.473304206132876	false	false	false	true
25615794-0526-4e1b-9c10-e0328cf61797	2026-09-14 13:02	2026-09-14 13:02	2026-09-14 13:02	SNOW	SNOW261016C00340000	call	340.0000	2026-10-16	17.2000	16.9500	17.8000	335.7193	173710.00	24070.00	149640.00	101	10	368	537	0.685288640595903	0.469963067022042	0.467197313364717	false	false	false	true
d7c4dade-989c-43a1-9a42-c84300f7702d	2026-09-14 12:47	2026-09-14 12:47	2026-09-14 12:47	SNOW	SNOW261016P00330000	put	330.0000	2026-10-16	15.4000	15.1000	16.1500	335.8300	118570.00	27710.00	90860.00	77	8	222	1939	0.114492006188757	0.476556919026473	0.473974328160211	false	false	false	true
2bb3ccb3-4d39-43da-8349-54751bf06c67	2026-09-14 11:25	2026-09-14 11:25	2026-09-14 11:25	SNOW	SNOW261016P00330000	put	330.0000	2026-10-16	16.7500	16.7000	17.4500	332.7852	61975.00	0.00	61975.00	37	8	46	1939	0.0237235688499226	0.479244297007884	0.475375367970832	true	false	false	true
7168474a-9ef0-4ab1-8e66-5c562ea1e279	2026-09-14 11:09	2026-09-14 11:09	2026-09-14 11:09	SNOW	SNOW260918P00340000	put	340.0000	2026-09-18	11.9000	11.0500	11.9000	332.9580	618800.00	618800.00	0.00	520	54	554	622	0.890675241157556	0.568302367515965	0.568302367515965	false	false	false	true
8c37fcbb-9b54-4726-abda-f97d1da12b72	2026-09-14 11:01	2026-09-14 11:01	2026-09-14 11:01	SNOW	SNOW261016C00330000	call	330.0000	2026-10-16	21.1000	20.0500	21.8500	333.8400	61190.00	61190.00	0.00	29	10	40	725	0.0551724137931034	0.472747189724369	0.472747189724369	false	false	false	true
f561f60b-d763-44ce-ad61-8fc2edc165b1	2026-09-14 10:44	2026-09-14 10:44	2026-09-14 10:44	SNOW	SNOW260918P00337500	put	337.5000	2026-09-18	11.8500	11.3500	12.5000	329.4258	50965.00	1195.00	49770.00	43	8	69	89	0.775280898876405	0.517335109238509	0.525236348784857	true	false	false	true
a84448a2-a303-41db-a258-2107340d279d	2026-09-14 09:47	2026-09-14 09:47	2026-09-14 09:47	SNOW	SNOW261016P00300000	put	300.0000	2026-10-16	8.0500	7.3000	8.0500	323.0000	161800.00	161800.00	0.00	201	8	205	1406	0.145803698435277	0.485237801610335	0.485237801610335	true	false	false	true
8fc5bfb4-c9b8-47a5-b14e-dfb843364ca9	2026-09-11 15:59	2026-09-11 15:58	2026-09-11 15:58	SNOW	SNOW261016P00300000	put	300.0000	2026-10-16	7.2000	7.2000	7.2000	327.2900	144000.00	0.00	0.00	200	40	1056	610	1.73114754098361	0.464815563098511	0.464815563098511	false	false	false	true
572317b4-dd0a-471b-aa8d-2a2bd002f251	2026-09-11 15:39	2026-09-11 15:38	2026-09-11 15:38	SNOW	SNOW261016P00340000	put	340.0000	2026-10-16	26.0000	25.9000	26.3000	325.2490	65000.00	0.00	65000.00	25	5	44	524	0.083969465648855	0.45164696073241	0.45164696073241	false	false	false	true
ad3a8fbe-ff02-4054-b8f1-27a5019f832f	2026-09-11 14:49	2026-09-11 14:48	2026-09-11 14:48	SNOW	SNOW261016C00360000	call	360.0000	2026-10-16	6.6000	6.5000	6.6000	325.0600	143880.00	143880.00	0.00	218	39	360	629	0.572337042925278	0.446016753781826	0.446016753781826	false	false	false	true
1363f7bf-a045-4658-b26b-1d26ac5b5664	2026-09-11 13:07	2026-09-11 13:07	2026-09-11 13:07	SNOW	SNOW270219C00370000	call	370.0000	2027-02-19	31.0000	30.6000	32.7000	326.5050	58900.00	3100.00	55800.00	19	7	23	474	0.0485232067510548	0.519203922805957	0.519203922805957	false	false	false	true
0a75d64d-a459-4ec1-9665-82b1c414ec1c	2026-09-11 12:10	2026-09-11 12:10	2026-09-11 12:10	SNOW	SNOW270115P00240000	put	240.0000	2027-01-15	7.7000	7.2500	7.7500	330.8300	93930.00	89320.00	2300.00	122	7	283	4850	0.0583505154639175	0.569159086270006	0.569159086270006	true	false	false	true
32f4fa6f-aada-4485-a114-a04977988665	2026-09-11 12:06	2026-09-11 12:06	2026-09-11 12:06	SNOW	SNOW260918C00332500	call	332.5000	2026-09-18	7.4500	7.4500	7.8500	330.4900	52150.00	0.00	52150.00	70	15	97	75	1.29333333333333	0.453481518068367	0.453481518068367	false	false	false	true
886d86c4-5ad3-426e-8150-8cdf24e3ef6c	2026-09-11 11:32	2026-09-11 11:32	2026-09-11 11:32	SNOW	SNOW260911C00325000	call	325.0000	2026-09-11	4.0000	3.6500	4.0000	328.4390	80000.00	80000.00	0.00	200	33	1927	220	8.75909090909091	0.618619255748939	0.601289249467701	false	false	false	true
5af0d8de-b2ae-4f44-af4c-b108dab1115f	2026-09-11 11:25	2026-09-11 11:25	2026-09-11 11:25	SNOW	SNOW261120P00310000	put	310.0000	2026-11-20	18.2000	17.3000	18.3000	326.7150	276640.00	242060.00	34580.00	152	26	694	420	1.65238095238095	0.482199075047706	0.482199075047706	false	false	false	true
071e2cb0-27af-448e-b6d7-86cbf86f9b77	2026-09-11 11:22	2026-09-11 11:22	2026-09-11 11:22	SNOW	SNOW260918C00330000	call	330.0000	2026-09-18	6.6500	6.1000	6.8000	325.9800	54525.00	53860.00	665.00	82	20	308	1261	0.244250594766059	0.463923290789344	0.463923290789344	true	false	false	true
e46f6c5d-6dfc-49a0-bf0f-e79ad8e2acce	2026-09-11 11:16	2026-09-11 11:16	2026-09-11 11:16	SNOW	SNOW261120P00330000	put	330.0000	2026-11-20	28.1500	26.7500	28.2000	325.8350	92895.00	92895.00	0.00	33	9	37	170	0.217647058823529	0.479605220873534	0.479605220873534	false	false	false	true
b9b2762d-9749-42b4-8734-cd5f1d531cdc	2026-09-11 11:16	2026-09-11 11:16	2026-09-11 11:16	SNOW	SNOW261120P00310000	put	310.0000	2026-11-20	18.6000	17.1500	19.5500	325.0000	1008078.00	985758.00	20465.00	542	50	542	420	1.29047619047619	0.483927807949435	0.478341599474341	false	false	false	true
e30ee0ae-69fa-40a2-a446-46aaf69ac4ff	2026-09-11 10:49	2026-09-11 10:49	2026-09-11 10:49	SNOW	SNOW260911C00325000	call	325.0000	2026-09-11	3.5000	3.3500	3.5000	327.5600	175000.00	146650.00	0.00	500	88	1666	220	7.57272727272727	0.617883497852378	0.617883497852378	false	false	false	true
f5663c33-c581-4e7b-949a-3c5364eed56c	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	SNOW	SNOW261120P00320000	put	320.0000	2026-11-20	22.7500	20.4000	22.7500	327.5750	170625.00	170625.00	0.00	75	7	96	224	0.428571428571429	0.488414619122284	0.488414619122284	false	false	false	true
09e42ee3-865c-4c5d-a322-77603940e25e	2026-09-11 10:11	2026-09-11 10:10	2026-09-11 10:10	SNOW	SNOW260911P00335000	put	335.0000	2026-09-11	5.0000	4.6500	5.0000	331.2150	83000.00	83000.00	0.00	166	11	259	679	0.381443298969072	0.78914977556003	0.78914977556003	false	false	false	true
7f16184e-9c8b-498b-9575-581604eda7f9	2026-09-11 10:08	2026-09-11 10:08	2026-09-11 10:08	SNOW	SNOW261016P00330000	put	330.0000	2026-10-16	17.5500	16.4000	17.5500	331.2453	207090.00	207090.00	0.00	118	20	134	1534	0.0873533246414602	0.461051430054185	0.461051430054185	false	false	false	true
2aec2df1-ed19-42aa-b5fd-73142f0b49ae	2026-09-11 10:08	2026-09-11 10:08	2026-09-11 10:08	SNOW	SNOW261016P00300000	put	300.0000	2026-10-16	6.4500	5.7500	6.5500	331.2453	459895.00	448920.00	10975.00	713	42	730	610	1.19672131147541	0.469869758891662	0.471524752407091	true	false	false	true
0e4abc70-68bc-4fcb-befb-a8d57df43e76	2026-09-11 10:04	2026-09-11 10:04	2026-09-11 10:04	SNOW	SNOW260911P00345000	put	345.0000	2026-09-11	12.3000	11.0500	12.3000	332.8500	97170.00	97170.00	0.00	79	6	91	272	0.334558823529412	0.842803919591209	0.842803919591209	false	false	false	true
37545d06-2e04-4201-b865-62a061743546	2026-09-11 09:46	2026-09-11 09:46	2026-09-11 09:46	SNOW	SNOW260911C00325000	call	325.0000	2026-09-11	3.5000	3.1500	3.5000	326.7400	59850.00	59850.00	0.00	171	46	569	220	2.58636363636364	0.791217877954193	0.729896743524329	false	false	false	true
596fa9d4-01d9-4bc1-b46f-14bb84e0da84	2026-09-10 14:15	2026-09-10 14:15	2026-09-10 14:15	SNOW	SNOW260911C00330000	call	330.0000	2026-09-11	3.7000	3.7000	3.7000	330.1551	74000.00	0.00	0.00	200	70	1241	9171	0.135317849743757	0.522990432541322	0.522990432541322	false	false	false	true
14f84dd9-a5fa-4ba9-b14f-4f6586aa09b2	2026-09-10 14:06	2026-09-10 14:05	2026-09-10 14:05	SNOW	SNOW260911C00330000	call	330.0000	2026-09-11	3.9000	3.9000	4.2500	330.2850	78000.00	0.00	21060.00	200	78	1029	9171	0.112201504743212	0.530517025632981	0.54228020355706	false	false	false	true
12311627-a094-4270-b2b8-8d2993d6102a	2026-09-10 12:44	2026-09-10 12:44	2026-09-10 12:44	SNOW	SNOW260911C00340000	call	340.0000	2026-09-11	2.0000	2.0000	2.0100	333.0000	194000.00	12000.00	400.00	970	83	2398	1315	1.82357414448669	0.619240678408971	0.619240678408971	false	false	false	true
84a5dc02-30cc-4b3c-b9cc-dccdbbb5f75d	2026-09-10 11:55	2026-09-10 11:55	2026-09-10 11:55	SNOW	SNOW260918P00325000	put	325.0000	2026-09-18	5.7500	5.5000	5.7500	333.0650	173646.00	173646.00	0.00	302	36	332	209	1.58851674641148	0.480516322752438	0.480516322752438	false	false	false	true
a057d9e7-e99d-4f4a-9e4a-2dc6720a95a0	2026-09-10 11:28	2026-09-10 11:28	2026-09-10 11:28	SNOW	SNOW260911P00350000	put	350.0000	2026-09-11	18.5000	18.5000	19.6000	331.7600	925000.00	0.00	925000.00	500	6	522	806	0.647642679900744	0.653594566740409	0.653594566740409	false	false	false	true
525e10f1-d992-49e1-9a74-bd053b3c0de8	2026-09-10 10:49	2026-09-10 10:49	2026-09-10 10:49	SNOW	SNOW260918C00330000	call	330.0000	2026-09-18	11.9500	11.9500	12.3000	334.0300	125480.00	1200.00	124280.00	105	10	249	1246	0.19983948635634	0.492159638820178	0.492159638820178	false	false	false	true
6e2b2171-c331-4020-8573-46fdd084b122	2026-09-10 10:11	2026-09-10 10:11	2026-09-10 10:11	SNOW	SNOW261016C00350000	call	350.0000	2026-10-16	15.7000	15.0000	16.4500	339.0200	97340.00	0.00	97340.00	62	50	115	1596	0.0720551378446115	0.468156955372855	0.468156955372855	false	false	false	true
e6a93188-8514-476a-914e-d114ecbbb2c9	2026-09-09 14:29	2026-09-09 14:28	2026-09-09 14:28	SNOW	SNOW261120P00330000	put	330.0000	2026-11-20	25.7900	25.4500	25.8000	332.1700	85110.00	69660.00	15450.00	33	7	94	136	0.691176470588235	0.48176920892151	0.48176920892151	false	false	false	true
81d2ab7e-c3d4-482b-b138-63303e75b795	2026-09-09 13:35	2026-09-09 13:35	2026-09-09 13:35	SNOW	SNOW260911P00327500	put	327.5000	2026-09-11	2.6700	2.4300	2.6700	334.2398	58206.00	58206.00	0.00	218	50	253	404	0.626237623762376	0.55336391918159	0.55336391918159	false	false	false	true
0dfedd74-7c45-42e2-875c-19b5f9b2ebbf	2026-09-09 11:35	2026-09-09 11:35	2026-09-09 11:35	SNOW	SNOW280121C00310000	call	310.0000	2028-01-21	105.6400	103.9000	107.5000	335.8500	538780.00	21150.00	517630.00	51	6	77	1894	0.0406546990496304	0.570897615066431	0.569047862713266	false	false	false	true
dd1d46f2-8851-4ffc-b45a-88e4d696e796	2026-09-09 11:21	2026-09-09 11:21	2026-09-09 11:21	SNOW	SNOW260911C00345000	call	345.0000	2026-09-11	2.0000	2.0000	2.1000	333.3400	100000.00	0.00	100000.00	500	7	805	1558	0.516688061617458	0.612055487548809	0.612055487548809	false	false	false	true
1a7f8da9-9378-42b0-8ee6-a6efccc2a608	2026-09-09 11:17	2026-09-09 11:17	2026-09-09 11:17	SNOW	SNOW260911C00335000	call	335.0000	2026-09-11	5.0000	5.0000	5.0000	333.1300	100000.00	0.00	0.00	200	73	363	918	0.395424836601307	0.593713979100145	0.593713979100145	false	false	false	true
bdea4454-2a14-4914-85f5-2b678b9b0e70	2026-09-09 10:27	2026-09-09 10:27	2026-09-09 10:27	SNOW	SNOW260911C00330000	call	330.0000	2026-09-11	8.0000	8.0000	8.0000	334.0000	160000.00	0.00	0.00	200	86	214	9159	0.0233649961786221	0.572031443328314	0.572031443328314	false	false	false	true
6c1c1a5e-c6dc-4a1c-a4cc-2d21f5e3d405	2026-09-08 14:47	2026-09-08 14:47	2026-09-08 14:47	SNOW	SNOW260911C00335000	call	335.0000	2026-09-11	7.9500	7.5500	7.9500	338.1800	198750.00	198750.00	0.00	250	56	1085	209	5.19138755980861	0.506902533596248	0.506902533596248	true	false	false	true
9e66d4b8-f79b-4ebc-97d6-33621e38bb59	2026-09-08 14:47	2026-09-08 14:46	2026-09-08 14:46	SNOW	SNOW260911C00345000	call	345.0000	2026-09-11	3.5000	3.5000	3.6500	337.5300	87500.00	0.00	87500.00	250	32	1605	1263	1.270783847981	0.529356559160657	0.529356559160657	false	false	false	true
a7842091-5caa-4a00-97ae-03104cd6c2be	2026-09-08 14:45	2026-09-08 14:45	2026-09-08 14:45	SNOW	SNOW261120P00380000	put	380.0000	2026-11-20	53.8500	51.7000	53.8500	337.5100	183088.00	183088.00	0.00	34	14	35	47	0.74468085106383	0.474482941657088	0.472597365179754	false	false	false	true
813230bb-c7aa-48d3-8385-fe6ca56eb3c9	2026-09-08 13:59	2026-09-08 13:59	2026-09-08 13:59	SNOW	SNOW261120P00260000	put	260.0000	2026-11-20	3.5000	3.2500	3.5000	338.8050	54946.00	54946.00	0.00	157	34	173	421	0.410926365795724	0.49791116399835	0.49791116399835	false	false	false	true
e0c62ecc-c1e6-4a6a-9c61-5652ebca144f	2026-09-08 13:49	2026-09-08 13:48	2026-09-08 13:48	SNOW	SNOW260911P00350000	put	350.0000	2026-09-11	12.7500	12.2000	12.7500	339.8850	86700.00	86700.00	0.00	68	11	271	770	0.351948051948052	0.526795319936824	0.526795319936824	false	false	false	true
a24c4b05-e726-478c-b2c4-26b63bf561d7	2026-09-08 13:47	2026-09-08 13:47	2026-09-08 13:47	SNOW	SNOW260911P00350000	put	350.0000	2026-09-11	12.5000	12.1000	13.2000	339.8950	187500.00	106250.00	81250.00	150	81	171	770	0.222077922077922	0.503183261664819	0.503183261664819	false	false	false	true
2c478c7a-8d7e-4095-ab2b-3aef631466ea	2026-09-08 13:31	2026-09-08 13:31	2026-09-08 13:31	SNOW	SNOW260911C00340000	call	340.0000	2026-09-11	5.0000	4.8500	5.0000	337.3100	62000.00	62000.00	0.00	124	68	1110	898	1.23608017817372	0.511622821742638	0.506863394104337	true	false	false	true