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:alert_rule = RepeatedHits×ticker = SNOW×sorted by created_at ↑×

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

df2ce057-c5e9-4abe-a519-b862ab48b198	2026-08-17 10:25	2026-08-17 10:25	2026-08-17 10:25	SNOW	SNOW260918C00320000	call	320.0000	2026-09-18	32.5000	31.3000	32.9000	330.2650	195000.00	9750.00	162500.00	60	35	62	3142	0.0197326543602801	0.691061498480436	0.691061498480436	true	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-17T14:42:42.502476Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a3f9b3c8-f1b4-42c7-b0b2-f5a8d1736c42	2026-08-17 11:24	2026-08-17 11:24	2026-08-17 11:24	SNOW	SNOW260918P00330000	put	330.0000	2026-09-18	25.7000	25.2500	25.7000	331.1450	454890.00	454890.00	0.00	177	29	238	460	0.517391304347826	0.688862641927729	0.688862641927729	false	false	false	true
98c17d8c-4805-4370-9d76-633816c6bf0a	2026-08-17 11:32	2026-08-17 11:32	2026-08-17 11:32	SNOW	SNOW270219P00330000	put	330.0000	2027-02-19	50.5100	50.5000	54.8500	332.7850	50510.00	0.00	50510.00	10	6	10	17	0.588235294117647	0.593945584065877	0.594494209927275	false	false	false	true
e8c38e16-9839-4554-91c1-517de9421a05	2026-08-17 11:33	2026-08-17 11:33	2026-08-17 11:33	SNOW	SNOW270319P00280000	put	280.0000	2027-03-19	32.3000	31.8000	32.3000	332.9500	83975.00	80750.00	3225.00	26	18	29	110	0.263636363636364	0.624951319004822	0.624344048449207	false	false	false	true
943033fd-ef4f-4eeb-8566-618ca67424a7	2026-08-17 14:04	2026-08-17 14:04	2026-08-17 14:04	SNOW	SNOW260918P00330000	put	330.0000	2026-09-18	24.6000	24.4000	24.7000	333.0000	61500.00	2460.00	59040.00	25	6	315	460	0.684782608695652	0.69023463487404	0.69023463487404	false	false	false	true
0d5a98b1-8c96-4c7b-8936-ee8979018c8b	2026-08-17 15:16	2026-08-17 15:16	2026-08-17 15:16	SNOW	SNOW260918P00330000	put	330.0000	2026-09-18	24.5500	24.4000	24.7500	333.8550	81015.00	2455.00	78560.00	33	5	416	460	0.904347826086957	0.689834228346221	0.689834228346221	false	false	false	true
4f50938e-7486-4e3d-b247-f088247193a0	2026-08-18 10:45	2026-08-18 10:45	2026-08-18 10:45	SNOW	SNOW261120C00380000	call	380.0000	2026-11-20	19.9000	19.9000	20.2000	322.6200	256710.00	0.00	97510.00	129	7	139	559	0.24865831842576	0.586845175710183	0.586845175710183	true	false	false	true
bf7eef1d-453e-48e2-a4ef-4d3b2c027d60	2026-08-18 11:05	2026-08-18 11:05	2026-08-18 11:05	SNOW	SNOW260918C00350000	call	350.0000	2026-09-18	16.4000	15.9500	16.4000	324.0600	118080.00	118080.00	0.00	72	5	120	1353	0.0886917960088692	0.691194361113348	0.691955538367567	false	false	false	true
ad0fe82e-7fee-4b9f-ab8d-3fb9f7e8eb1c	2026-08-18 11:49	2026-08-18 11:49	2026-08-18 11:49	SNOW	SNOW261218C00370000	call	370.0000	2026-12-18	30.0000	30.0000	30.9500	322.9600	168000.00	0.00	168000.00	56	12	58	151	0.384105960264901	0.611124723965248	0.611124723965248	false	false	false	true
8553386f-6323-487b-be6e-3cd0f731756f	2026-08-18 13:08	2026-08-18 13:08	2026-08-18 13:08	SNOW	SNOW261120C00380000	call	380.0000	2026-11-20	19.6500	19.6500	20.4000	323.3900	84495.00	0.00	84495.00	43	19	182	559	0.325581395348837	0.578263315877183	0.578263315877183	false	false	false	true
d3abae5e-632f-4b89-ad3f-c8a4e7d56fed	2026-08-18 13:23	2026-08-18 13:23	2026-08-18 13:23	SNOW	SNOW280121P00300000	put	300.0000	2028-01-21	68.8000	66.2500	68.8000	324.1700	130715.00	130715.00	0.00	19	5	89	148	0.601351351351351	0.623921797367688	0.623921797367688	false	false	false	true
fd99b15c-38c8-4ea8-8746-0698b5a6caaf	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	SNOW	SNOW260821P00315000	put	315.0000	2026-08-21	4.0000	3.2500	4.0500	319.2900	57590.00	54035.00	3555.00	144	31	385	1252	0.307507987220447	0.632729302535298	0.638302668538339	true	false	false	true
27488658-c83d-44b7-b9db-5dafeadc391c	2026-08-19 10:24	2026-08-19 10:24	2026-08-19 10:24	SNOW	SNOW261218C00340000	call	340.0000	2026-12-18	37.3500	36.0500	37.3500	317.4000	448200.00	250245.00	0.00	120	21	120	660	0.181818181818182	0.615015825042755	0.615015825042755	false	false	false	true
4f6f7783-e884-4ac5-8ed2-917ad1e0b34c	2026-08-19 10:26	2026-08-19 10:26	2026-08-19 10:26	SNOW	SNOW270115C00340000	call	340.0000	2027-01-15	41.7500	40.8000	41.7500	318.0100	100200.00	100200.00	0.00	24	11	53	2085	0.0254196642685851	0.600070981081317	0.600070981081317	false	false	false	true
181b2129-6a3c-40b0-a075-f3dcfd356b43	2026-08-19 10:26	2026-08-19 10:26	2026-08-19 10:26	SNOW	SNOW270115C00340000	call	340.0000	2027-01-15	41.7500	40.6500	41.7500	318.0100	121075.00	121075.00	0.00	29	10	29	2085	0.0139088729016787	0.600070981081317	0.600070981081317	false	false	false	true
af595c1c-f82a-470d-9bf9-21eb3cb984fb	2026-08-19 15:24	2026-08-19 15:23	2026-08-19 15:23	SNOW	SNOW260821P00360000	put	360.0000	2026-08-21	34.5000	33.9500	34.5000	325.5650	155250.00	155250.00	0.00	45	18	113	212	0.533018867924528	0.67311489577881	0.67311489577881	false	false	false	true
1f5515f5-241a-4465-a871-0c615055cd7d	2026-08-20 10:59	2026-08-20 10:59	2026-08-20 10:59	SNOW	SNOW260821C00322500	call	322.5000	2026-08-21	3.8500	3.8500	4.7500	322.3100	98945.00	0.00	98945.00	257	5	281	63	4.46031746031746	0.583483563973369	0.583483563973369	true	false	false	true
9e0ef823-b70d-4ded-a8e1-6f3e4b7562ba	2026-08-21 09:56	2026-08-21 09:56	2026-08-21 09:56	SNOW	SNOW260918C00330000	call	330.0000	2026-09-18	22.1500	19.8500	22.1500	320.5450	62012.00	62012.00	0.00	28	5	30	1023	0.0293255131964809	0.7307295205709	0.7307295205709	false	false	false	true
4b3abe0b-8bba-4b8a-84d0-db9358a424be	2026-08-21 11:41	2026-08-21 11:41	2026-08-21 11:41	SNOW	SNOW260918P00330000	put	330.0000	2026-09-18	27.5000	26.4500	27.5000	326.0800	340997.00	340997.00	0.00	124	29	203	567	0.358024691358025	0.71936962514374	0.71936962514374	false	false	false	true
b7a50d90-4435-44d1-a7dd-c62e11993fb4	2026-08-21 12:13	2026-08-21 12:13	2026-08-21 12:13	SNOW	SNOW271217C00360000	call	360.0000	2027-12-17	85.1000	83.1500	85.1000	326.8175	3940130.00	3940130.00	0.00	463	17	673	242	2.78099173553719	0.612060898673905	0.612060898673905	false	false	false	true
d6e2c940-a718-4a6a-888f-5141c96efb90	2026-08-24 12:24	2026-08-24 12:24	2026-08-24 12:24	SNOW	SNOW270319P00370000	put	370.0000	2027-03-19	81.7500	78.9500	81.7500	326.5600	138975.00	138975.00	0.00	17	5	26	27	0.962962962962963	0.611955130164275	0.611955130164275	false	false	false	true
0de8d12e-0dfe-432b-a3a7-0b04037de432	2026-08-24 15:03	2026-08-24 15:03	2026-08-24 15:03	SNOW	SNOW280121C00450000	call	450.0000	2028-01-21	62.2600	61.1500	64.0000	325.6900	56035.00	0.00	56035.00	9	6	9	19	0.473684210526316	0.601838357711343	0.602486325341562	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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