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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×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

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	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-27T14:11:49.813441Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
cbf7188c-8ceb-43e6-9d08-4368fa786d23	2026-08-26 11:56	2026-08-26 11:56	2026-08-26 11:56	SNOW	SNOW270115P00300000	put	300.0000	2027-01-15	35.4800	35.1500	35.5500	314.8100	887100.00	596400.00	141800.00	250	13	533	1155	0.461471861471861	0.589922474959922	0.589922474959922	true	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
5a859bd3-4606-492a-a193-a70e797ae4de	2026-08-26 11:38	2026-08-26 11:38	2026-08-26 11:38	SNOW	SNOW270115P00320000	put	320.0000	2027-01-15	45.6100	45.3000	46.8000	314.8900	200670.00	4620.00	196050.00	44	14	192	1380	0.139130434782609	0.582192410792806	0.591273634095465	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
44d829dd-84c9-4749-886f-bbb1d1ee6f5d	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	SNOW	SNOW270115P00310000	put	310.0000	2027-01-15	40.4600	40.4500	43.3000	314.7800	319621.00	0.00	319621.00	79	7	81	137	0.591240875912409	0.587466680885152	0.587202085593081	true	false	false	true
3dc41b6f-ea2e-4212-9854-81c8ffd0a540	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	SNOW	SNOW270115C00320000	call	320.0000	2027-01-15	45.7100	45.7000	47.8000	314.7100	575995.00	77865.00	498130.00	126	12	126	1502	0.0838881491344873	0.588587895603985	0.589756091138933	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
2b8b3db1-00b6-4452-922b-c55003c5c857	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.0000	40.9000	314.7350	152572.00	20075.00	132497.00	38	14	93	1869	0.0497592295345104	0.615922580208958	0.615922580208958	true	false	false	true
f8eae8ff-fdbe-41c8-ae70-528bf2f811c5	2026-08-25 14:30	2026-08-25 14:30	2026-08-25 14:30	SNOW	SNOW270917C00350000	call	350.0000	2027-09-17	69.3400	67.4500	69.4000	314.2940	69340.00	62405.00	0.00	10	6	206	189	1.08994708994709	0.601516886806092	0.602307597818771	false	false	false	true
884470fb-8924-45cf-a7f1-a5dffd9cb605	2026-08-25 14:29	2026-08-25 14:29	2026-08-25 14:29	SNOW	SNOW260918P00290000	put	290.0000	2026-09-18	13.2900	13.2000	13.8000	314.0000	83700.00	31970.00	38430.00	63	18	156	497	0.313883299798793	0.767361345425916	0.769892930817489	false	false	false	true
9c97d3a2-a25d-4d6e-9c56-17b9ce9950a8	2026-08-25 14:25	2026-08-25 14:25	2026-08-25 14:25	SNOW	SNOW281215P00260000	put	260.0000	2028-12-15	65.8100	63.6500	66.1000	312.0000	92130.00	52655.00	39475.00	14	5	14	3	4.66666666666667	0.625780215958546	0.62542475055088	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
3c411926-3ee6-49d6-9d18-e4cf275b6a7d	2026-08-25 14:16	2026-08-25 14:16	2026-08-25 14:16	SNOW	SNOW260918P00290000	put	290.0000	2026-09-18	14.0000	13.8000	14.6500	311.0000	106425.00	103615.00	2810.00	76	6	93	497	0.187122736418511	0.763907621521039	0.769174476923602	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
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
85ae2740-153c-4d48-8a16-1a06378ed441	2026-08-25 11:36	2026-08-25 11:36	2026-08-25 11:36	SNOW	SNOW260904C00400000	call	400.0000	2026-09-04	2.4000	2.4000	2.9700	317.2500	80407.00	723.00	79684.00	335	46	337	68	4.95588235294118	1.02377046154763	1.02806851213268	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
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
dcd88d24-58b7-465e-b654-0c33f7eb8ac9	2026-08-24 15:44	2026-08-24 15:44	2026-08-24 15:44	SNOW	SNOW260828P00325000	put	325.0000	2026-08-28	8.8000	8.4500	8.9500	322.8000	80065.00	77440.00	2625.00	91	11	215	87	2.47126436781609	0.560031374866694	0.571191986325482	false	false	false	true
ee7ea039-3d39-4326-a49f-b51733e2d414	2026-08-24 15:42	2026-08-24 15:41	2026-08-24 15:41	SNOW	SNOW261002C00310000	call	310.0000	2026-10-02	34.6500	34.1500	36.0500	322.7450	69300.00	34700.00	34600.00	20	6	45	7	6.42857142857143	0.660196890571014	0.657701147117198	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
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
1b8762cb-5635-41bc-b019-09996724a66f	2026-08-24 14:49	2026-08-24 14:49	2026-08-24 14:49	SNOW	SNOW270115C00450000	call	450.0000	2027-01-15	16.3700	16.1000	17.0000	326.5850	55665.00	52395.00	3270.00	34	6	37	48	0.770833333333333	0.593665635144854	0.593665635144854	true	false	false	true