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

392c77d1-6424-4bd5-8162-1f93700bd00f	2026-09-03 13:47	2026-09-03 13:47	2026-09-03 13:47	SNOW	SNOW260904C00370000	call	370.0000	2026-09-04	5.1500	5.0500	5.5000	368.6800	59740.00	0.00	59740.00	116	11	5342	2909	1.83636988655896	0.74796812219598	0.74796812219598	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-03T17:55:09.170571Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
df6610c6-87db-4c50-8f6f-22d379e50550	2026-09-03 13:24	2026-09-03 13:24	2026-09-03 13:24	SNOW	SNOW260904C00370000	call	370.0000	2026-09-04	5.5000	5.3500	5.5000	368.6050	229350.00	229350.00	0.00	417	5	5101	2909	1.75352354761086	0.798158702773476	0.798158702773476	false	false	false	true
758fec50-1eb5-4fc1-bc88-3a49f57ed126	2026-09-03 12:30	2026-09-03 12:30	2026-09-03 12:30	SNOW	SNOW260918C00360000	call	360.0000	2026-09-18	23.0000	22.2500	23.7500	374.7100	50600.00	0.00	43700.00	22	7	312	1760	0.177272727272727	0.473917246365069	0.473917246365069	false	false	false	true
11ce6af2-0e68-43ea-8aef-d486fed5d0c8	2026-09-03 11:57	2026-09-03 11:57	2026-09-03 11:57	SNOW	SNOW260911C00370000	call	370.0000	2026-09-11	12.2000	11.8000	12.2500	371.7650	91525.00	90310.00	1215.00	75	5	858	213	4.02816901408451	0.50850319901965	0.50850319901965	false	false	false	true
1fca0ad1-2567-4ec0-af77-58f9abd37439	2026-09-03 11:52	2026-09-03 11:52	2026-09-03 11:52	SNOW	SNOW260918C00370000	call	370.0000	2026-09-18	14.1000	13.6500	14.2000	369.3600	69090.00	40890.00	28200.00	49	7	720	877	0.820980615735462	0.473135321382128	0.473135321382128	true	false	false	true
a1457fb5-ad26-41ab-8905-1cd0c21ae765	2026-09-03 11:42	2026-09-03 11:42	2026-09-03 11:42	SNOW	SNOW260904P00370000	put	370.0000	2026-09-04	8.7500	8.4500	8.8500	366.4850	84000.00	84000.00	0.00	96	6	2343	8	292.875	0.893882913651501	0.893882913651501	true	false	false	true
f2bd90f5-523f-4ddc-9212-44c0b7055fb6	2026-09-03 11:37	2026-09-03 11:37	2026-09-03 11:37	SNOW	SNOW260918C00320000	call	320.0000	2026-09-18	48.3500	47.4500	48.3500	366.4700	72525.00	72525.00	0.00	15	6	964	3018	0.319416832339298	0.497235536730323	0.497235536730323	false	false	false	true
2d63edc2-193d-4214-a984-dc362e54eab5	2026-09-03 11:36	2026-09-03 11:36	2026-09-03 11:36	SNOW	SNOW260918C00320000	call	320.0000	2026-09-18	48.1000	47.4500	48.1000	366.1900	57720.00	57720.00	0.00	12	7	829	3018	0.274685222001325	0.510029726298116	0.497930695897066	true	false	false	true
3b5158fa-8cdd-4aec-a665-777ae02f2da5	2026-09-03 11:32	2026-09-03 11:32	2026-09-03 11:32	SNOW	SNOW261016C00400000	call	400.0000	2026-10-16	11.0000	11.0000	11.5000	365.5000	59400.00	0.00	59400.00	54	16	548	1088	0.503676470588235	0.457129127596604	0.457129127596604	false	false	false	true
527dea61-42fd-4594-982a-e4c6609cceaf	2026-09-03 11:25	2026-09-03 11:25	2026-09-03 11:25	SNOW	SNOW261016P00370000	put	370.0000	2026-10-16	24.0000	23.5000	24.0000	367.0100	50400.00	50400.00	0.00	21	6	707	26	27.1923076923077	0.464207942261195	0.464207942261195	true	false	false	true
c04b685a-ebf1-4cc2-ad80-24676d055350	2026-09-03 11:24	2026-09-03 11:24	2026-09-03 11:24	SNOW	SNOW260904C00365000	call	365.0000	2026-09-04	8.4000	8.1500	8.4000	367.9500	336000.00	336000.00	0.00	400	5	978	747	1.30923694779116	0.888934815050408	0.888934815050408	false	false	false	true
b2be832e-5288-4abc-8822-ba06d752aabf	2026-09-03 11:16	2026-09-03 11:16	2026-09-03 11:16	SNOW	SNOW260911C00375000	call	375.0000	2026-09-11	9.2000	9.2000	9.6000	370.8300	175720.00	0.00	175720.00	191	9	740	169	4.37869822485207	0.495515167001765	0.500691193242746	false	false	false	true
dcb1d821-b7f4-4589-851f-76ff45954915	2026-09-03 11:12	2026-09-03 11:12	2026-09-03 11:12	SNOW	SNOW261016P00350000	put	350.0000	2026-10-16	13.4000	13.1000	13.7000	371.4999	107200.00	13400.00	53600.00	80	5	209	632	0.330696202531646	0.47013311655688	0.47013311655688	false	false	false	true
5b73b753-c3f3-4ceb-b3dc-7124c59e5b4a	2026-09-03 10:59	2026-09-03 10:59	2026-09-03 10:59	SNOW	SNOW260904C00325000	call	325.0000	2026-09-04	45.5500	45.5500	46.9500	370.2317	168535.00	0.00	168535.00	37	16	784	1231	0.636880584890333	1.79222105168804	1.32863829563896	false	false	false	true
5b9b429e-1090-4eef-ba02-4916b34b3182	2026-09-03 10:59	2026-09-03 10:59	2026-09-03 10:59	SNOW	SNOW261016C00360000	call	360.0000	2026-10-16	29.7500	29.7500	30.5000	370.8350	98175.00	0.00	98175.00	33	7	159	461	0.344902386117137	0.460664709760603	0.460664709760603	false	false	false	true
e40eae5d-f006-4365-b58d-3d1115bc442a	2026-09-03 10:55	2026-09-03 10:55	2026-09-03 10:55	SNOW	SNOW281215C00380000	call	380.0000	2028-12-15	133.7500	131.8000	133.7500	370.6650	200620.00	200620.00	0.00	15	6	35	34	1.02941176470588	0.573935730704802	0.573935730704802	false	false	false	true
6d306f37-4007-4dff-bfd8-31fff792691b	2026-09-03 10:51	2026-09-03 10:50	2026-09-03 10:50	SNOW	SNOW280121C00500000	call	500.0000	2028-01-21	66.3000	64.1000	66.3000	371.1000	59670.00	59670.00	0.00	9	5	251	239	1.05020920502092	0.564078273631049	0.564078273631049	false	false	false	true
64d37b6d-eab6-4f9c-89f4-2f59efc555d9	2026-09-03 10:49	2026-09-03 10:49	2026-09-03 10:49	SNOW	SNOW280121C00500000	call	500.0000	2028-01-21	65.6300	64.3500	65.7500	370.1100	78750.00	78750.00	0.00	12	8	240	239	1.00418410041841	0.562833515593923	0.563697609314881	true	false	false	true
ee4d767d-8f1c-46bf-9151-4895917b307a	2026-09-03 10:48	2026-09-03 10:48	2026-09-03 10:48	SNOW	SNOW260918C00340000	call	340.0000	2026-09-18	34.0500	32.4500	35.0000	369.7150	102150.00	51075.00	51075.00	30	6	214	2228	0.0960502692998205	0.48988124753348	0.48988124753348	true	false	false	true
1dc23bd9-071a-4dff-9d87-5a779b84d466	2026-09-03 10:47	2026-09-03 10:46	2026-09-03 10:46	SNOW	SNOW280121C00500000	call	500.0000	2028-01-21	65.4000	64.0000	66.5500	369.5300	91560.00	91560.00	0.00	14	8	221	239	0.924686192468619	0.5633090541381	0.5633090541381	true	false	false	true
217051cb-3b64-4c37-bb32-28e372e07179	2026-09-03 10:35	2026-09-03 10:35	2026-09-03 10:35	SNOW	SNOW270917P00330000	put	330.0000	2027-09-17	53.4500	52.6500	54.7000	371.2600	368820.00	272590.00	96230.00	69	8	71	3	23.6666666666667	0.570030937697888	0.571591391873351	false	false	false	true
d0fd79cc-dee5-4a63-a546-372335262f47	2026-09-03 10:24	2026-09-03 10:24	2026-09-03 10:24	SNOW	SNOW260904P00375000	put	375.0000	2026-09-04	9.7000	9.7000	10.5000	370.6400	194000.00	0.00	194000.00	200	5	2570	203	12.6600985221675	0.9427488018285	0.9427488018285	false	false	false	true
d95aa8e3-5ace-4a7f-bf61-91b59c0ef629	2026-09-03 10:22	2026-09-03 10:21	2026-09-03 10:21	SNOW	SNOW260918C00320000	call	320.0000	2026-09-18	54.8000	52.7000	55.6500	373.1250	65760.00	21920.00	43840.00	12	6	629	3018	0.208416169648774	0.523797144122383	0.523797144122383	false	false	false	true
7937577f-f44e-485e-a5c1-63fc2e329aeb	2026-09-03 10:16	2026-09-03 10:16	2026-09-03 10:16	SNOW	SNOW260918C00320000	call	320.0000	2026-09-18	54.1500	52.3000	54.1500	372.3500	54150.00	54150.00	0.00	10	6	425	3018	0.140821736249172	0.516945486984939	0.531168143580999	false	false	false	true
6d4cb898-0b36-4a9b-9752-6cc865b4a9a3	2026-09-03 10:15	2026-09-03 10:15	2026-09-03 10:15	SNOW	SNOW261120C00420000	call	420.0000	2026-11-20	17.2500	17.2500	19.2500	371.9800	62105.00	0.00	62105.00	36	10	137	771	0.17769130998703	0.483772270289591	0.484428407918506	true	false	false	true
c9fa7170-61c4-4a9d-9c30-96bac9ee9b6d	2026-09-03 10:08	2026-09-03 10:08	2026-09-03 10:08	SNOW	SNOW260904C00375000	call	375.0000	2026-09-04	9.4100	8.5000	9.4500	375.3622	117575.00	117575.00	0.00	125	5	2153	6815	0.315920763022744	1.18066745393167	1.18066745393167	false	false	false	true
8bb914cb-29fe-46d3-8089-091bfa7a0586	2026-09-03 10:05	2026-09-03 10:05	2026-09-03 10:05	SNOW	SNOW260904C00375000	call	375.0000	2026-09-04	11.2200	10.7500	11.3000	378.5000	76289.00	76289.00	0.00	68	6	1856	6815	0.272340425531915	1.18422832861485	1.16094576436147	false	false	false	true
8b5163f7-8545-47cd-92da-630b335024f4	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904P00375000	put	375.0000	2026-09-04	8.3500	7.8000	8.3500	376.4550	167000.00	167000.00	0.00	200	5	1742	203	8.58128078817734	1.15724244991039	1.15724244991039	false	false	false	true
dae0f1d4-ce8e-420b-9e35-1fcee8205a2f	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.9000	31.3000	32.4500	376.2900	216920.00	169070.00	47850.00	68	6	2071	3169	0.653518460082045	1.09131381319239	1.09131381319239	false	false	false	true
c6b27cd8-a8bc-4609-a4d9-254652899aeb	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.6000	31.2500	31.6500	375.8100	132735.00	132735.00	0.00	42	6	1952	3169	0.615967182076365	1.14941957484446	1.16746020022958	true	false	false	true
bbe82fee-4c06-433a-8c58-384092a3fe09	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.5000	30.8500	31.5000	375.6150	166950.00	166950.00	0.00	53	6	1867	3169	0.589144840643736	1.17792316538266	1.17792316538266	false	false	false	true
5d75fd15-11ae-4cfc-97a4-a039be85a0e4	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.5000	31.1000	31.5000	375.6800	126000.00	126000.00	0.00	40	5	1907	3169	0.601767118964973	1.15680917327632	1.15680917327632	false	false	false	true
e2c2ff47-c214-4d70-be40-d55f9b93de28	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.2500	30.3500	31.2500	375.2550	134375.00	121875.00	0.00	43	8	1814	3169	0.572420321868097	1.20478692921968	1.20478692921968	true	false	false	true
1c4b392f-34a4-48f7-9038-289ed42d8906	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.1500	30.2500	31.1500	375.2700	133945.00	133945.00	0.00	43	6	1715	3169	0.541180183023036	1.16677451807635	1.16677451807635	true	false	false	true
69d9a4eb-141c-4139-8e29-7ff750f0993e	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.2000	30.0500	31.6000	375.7500	146640.00	18720.00	6240.00	47	7	1572	3169	0.496055538024613	1.00454153563679	1.00454153563679	false	false	false	true
8a3ace82-27c3-4b9d-a7f0-5993ab6f8edb	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.0000	30.0500	31.0000	375.1800	170500.00	158100.00	0.00	55	6	1524	3169	0.480908804039129	1.14000209354454	1.14000209354454	true	false	false	true
dec02755-6815-4c19-87bf-0673e038cf8f	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.0500	30.0000	31.0500	375.1700	180090.00	180090.00	0.00	58	6	1467	3169	0.462922057431366	1.16403914800394	1.16403914800394	false	false	false	true
af3fff56-0268-49d3-9c8c-d019e9f454dc	2026-09-03 10:04	2026-09-03 10:03	2026-09-03 10:03	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	30.7000	29.5500	31.3500	374.4600	267090.00	267090.00	0.00	87	6	1292	3169	0.407699589775955	1.25714292160441	1.25714292160441	false	false	false	true
2e4cdecb-04fb-4ccd-a6e9-94fd999ece8f	2026-09-03 10:04	2026-09-03 10:03	2026-09-03 10:03	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.1000	29.7500	31.1000	375.1600	149280.00	149280.00	0.00	48	6	1409	3169	0.444619753865573	1.18406975158782	1.18406975158782	false	false	false	true
8ba0e053-9f31-47c4-aa39-1a4da885abd7	2026-09-03 10:04	2026-09-03 10:03	2026-09-03 10:03	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	30.5000	28.5500	30.5000	374.6300	271450.00	271450.00	0.00	89	11	1180	3169	0.372357210476491	1.27554849928737	1.14580647176017	true	false	false	true
1686bed5-93b2-4765-b14a-7b45de30722a	2026-09-03 10:03	2026-09-03 10:03	2026-09-03 10:03	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	30.5000	29.7000	30.7500	374.5300	344650.00	344650.00	0.00	113	6	870	3169	0.274534553486904	1.17642892615191	1.17642892615191	false	false	false	true
e9ae1e79-8eaa-434c-8a47-89c046a085a5	2026-09-03 10:03	2026-09-03 10:02	2026-09-03 10:02	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	30.5000	29.1000	31.3000	374.5000	298900.00	298900.00	0.00	98	10	654	3169	0.206374250552225	1.18526990978953	1.18526990978953	false	false	false	true
9d2e25e1-790b-4e75-896d-6a6a09d2936e	2026-09-03 10:03	2026-09-03 10:02	2026-09-03 10:02	SNOW	SNOW260925C00355000	call	355.0000	2026-09-25	30.0000	28.7000	30.0000	374.5000	554995.00	554995.00	0.00	185	11	185	386	0.479274611398964	0.506293214949195	0.506293214949195	true	false	false	true
d7461b41-bfaf-4a66-81f3-14e6f2575c0c	2026-09-03 09:50	2026-09-03 09:50	2026-09-03 09:50	SNOW	SNOW260904C00375000	call	375.0000	2026-09-04	5.0000	4.7000	5.0000	366.0000	150000.00	150000.00	0.00	300	7	1264	6815	0.18547322083639	1.13268117580956	1.13268117580956	false	false	false	true
cbe37de8-f318-4550-9ee7-ee8b0068600c	2026-09-03 09:48	2026-09-03 09:48	2026-09-03 09:48	SNOW	SNOW270319C00380000	call	380.0000	2027-03-19	56.7500	55.3000	56.7500	367.5106	698025.00	698025.00	0.00	123	6	161	260	0.619230769230769	0.5461254610329	0.5461254610329	false	false	false	true
7039659f-5ea9-491b-bf39-ac057f800862	2026-09-03 09:41	2026-09-03 09:40	2026-09-03 09:40	SNOW	SNOW260904C00335000	call	335.0000	2026-09-04	39.2500	39.2500	42.0000	373.1700	54950.00	0.00	54950.00	14	6	368	1278	0.287949921752739	1.90729937616033	1.49008422393798	false	false	false	true
40a8be50-d12b-4b3e-81e9-3ea320c639a1	2026-09-03 09:38	2026-09-03 09:38	2026-09-03 09:38	SNOW	SNOW260904P00370000	put	370.0000	2026-09-04	8.0000	8.0000	8.5000	372.0000	88000.00	0.00	88000.00	110	8	384	8	48	1.14944073878311	1.15972641204301	true	false	false	true
ed05e8f8-3a36-42a9-977b-0548b6d11646	2026-09-03 09:36	2026-09-03 09:36	2026-09-03 09:36	SNOW	SNOW261218P00380000	put	380.0000	2026-12-18	44.5000	39.9000	46.8500	371.0300	89000.00	89000.00	0.00	20	6	61	2	30.5	0.532656537528992	0.527346830164419	false	false	false	true
fbe37d28-39d1-4308-a785-10eededabda7	2026-09-03 09:32	2026-09-03 09:32	2026-09-03 09:32	SNOW	SNOW260904C00360000	call	360.0000	2026-09-04	23.9000	20.1000	23.9000	380.5100	71700.00	71700.00	0.00	30	10	81	2356	0.0343803056027165	1.6887260202283	1.37267974389088	true	false	false	true
864f9423-1216-4166-b879-98789dbe8889	2026-09-02 15:58	2026-09-02 15:58	2026-09-02 15:58	SNOW	SNOW260918P00300000	put	300.0000	2026-09-18	18.5000	18.5000	18.9000	307.8900	99900.00	0.00	99900.00	54	7	563	931	0.604726100966702	0.886300550920146	0.886300550920146	true	false	false	true