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 = RepeatedHitsAscendingFill×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	expiry

22ff4e0f-a114-4e73-ba97-72bd5c0d3ed5	2026-09-18 11:19	2026-09-18 11:19	2026-09-18 11:19	SNOW	SNOW280121P00240000	put	240.0000	2028-01-21	30.9900	30.8500	32.4000	334.3500	185946.00	0.00	185946.00	60	23	62	1929	0.0321410057024365	0.579670052631116	0.581419863462897	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	117281304000.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
b9bb3b11-3ad2-491f-b546-1d31250545f7	2026-09-18 10:57	2026-09-18 10:57	2026-09-18 10:57	SNOW	SNOW260925C00335000	call	335.0000	2026-09-25	6.8100	6.7000	7.2000	333.3250	52410.00	4110.00	48300.00	77	16	118	633	0.186413902053712	0.405839060427171	0.408557208352796	true	false	false	true
cd1da97e-e192-422e-8c09-42723b2ea1b0	2026-09-18 09:59	2026-09-18 09:59	2026-09-18 09:59	SNOW	SNOW270521C00420000	call	420.0000	2027-05-21	35.6200	35.6000	39.2500	334.2100	185205.00	42780.00	138865.00	52	10	52	0	0	0.550377064560737	0.550377064560737	false	false	false	true
78fa90d5-0b6a-4c43-a361-29eab806f31d	2026-09-17 13:00	2026-09-17 13:00	2026-09-17 13:00	SNOW	SNOW261030C00330000	call	330.0000	2026-10-30	26.2400	25.5000	27.0000	337.6350	55095.00	26220.00	28875.00	21	5	23	25	0.92	0.467551919848761	0.468221849481804	false	false	false	true
96da8484-0ab5-47cd-ba67-a880635d50f0	2026-09-17 12:42	2026-09-17 12:42	2026-09-17 12:42	SNOW	SNOW261016P00340000	put	340.0000	2026-10-16	17.1300	17.0000	17.7000	338.5100	104510.00	48075.00	56435.00	61	19	213	763	0.27916120576671	0.443671394253355	0.443671394253355	true	false	false	true
2a11e54e-7627-42df-9baf-78c36f1ef97a	2026-09-17 11:23	2026-09-17 11:22	2026-09-17 11:22	SNOW	SNOW281215P00240000	put	240.0000	2028-12-15	44.5800	43.1500	45.0000	343.7500	89156.00	35636.00	26760.00	20	9	20	19	1.05263157894737	0.597288548562884	0.598998132477914	false	false	false	true
d75594d3-ff7d-48a2-a280-c5975b8b9f0d	2026-09-17 10:47	2026-09-17 10:47	2026-09-17 10:47	SNOW	SNOW260925C00350000	call	350.0000	2026-09-25	6.8100	6.5500	7.5500	344.6600	68080.00	30745.00	37335.00	100	11	812	2181	0.372306281522237	0.431234913549132	0.461227995027233	false	false	false	true
0e4acd4b-5e5b-480d-8842-d9df72073fc5	2026-09-15 11:44	2026-09-15 11:44	2026-09-15 11:44	SNOW	SNOW270319P00290000	put	290.0000	2027-03-19	30.5600	30.2500	31.5500	323.6300	186400.00	137520.00	48880.00	61	12	62	165	0.375757575757576	0.560041486558384	0.560041486558384	false	false	false	true
eac5581a-fb52-4b9e-b4f2-bd2e02cc972e	2026-09-14 13:50	2026-09-14 13:50	2026-09-14 13:50	SNOW	SNOW260925P00342500	put	342.5000	2026-09-25	15.2500	15.1500	16.0000	334.3600	62537.00	1530.00	61007.00	41	17	70	13	5.38461538461539	0.467214564784141	0.469437506348999	true	false	false	true
4d5523ad-db3e-4969-a557-1bdcea7dbfa4	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	SNOW	SNOW261016C00340000	call	340.0000	2026-10-16	17.3700	17.3500	17.8000	336.0117	104190.00	10440.00	93750.00	60	20	200	537	0.37243947858473	0.469793856989069	0.469793856989069	false	false	false	true
6f82e16b-491e-41fc-b714-03cfa0ba9f0a	2026-09-14 11:24	2026-09-14 11:24	2026-09-14 11:24	SNOW	SNOW261016C00330000	call	330.0000	2026-10-16	21.4500	20.6000	21.9500	334.0251	60070.00	6440.00	40760.00	28	8	76	725	0.104827586206897	0.479040088311523	0.480328324755596	true	false	false	true
9907baa8-f1f2-4c25-8af2-4e77cfd286ea	2026-09-11 15:08	2026-09-11 15:08	2026-09-11 15:08	SNOW	SNOW270617C00470000	call	470.0000	2027-06-17	26.8700	26.8000	28.1000	324.7975	112850.00	61765.00	45715.00	42	14	43	330	0.13030303030303	0.558689775529519	0.558689775529519	false	false	false	true
234019b7-45b1-4ad1-b57a-b2854910274a	2026-09-10 12:06	2026-09-10 12:06	2026-09-10 12:06	SNOW	SNOW260911C00330000	call	330.0000	2026-09-11	6.2500	6.2500	6.7000	333.7250	235040.00	0.00	233780.00	376	49	488	9171	0.053211209246538	0.591549193393157	0.599258703261206	false	false	false	true
141f30aa-a81a-44bb-a2ae-66b630387971	2026-09-10 10:38	2026-09-10 10:38	2026-09-10 10:38	SNOW	SNOW270319C00490000	call	490.0000	2027-03-19	16.2900	15.6500	18.4000	334.5000	131945.00	32540.00	99405.00	81	5	81	33	2.45454545454545	0.559197660042591	0.559856589545476	false	false	false	true
9ac24d38-11c5-402b-9444-0ae652f39d77	2026-09-10 10:16	2026-09-10 10:16	2026-09-10 10:16	SNOW	SNOW260918C00337500	call	337.5000	2026-09-18	9.8000	9.7000	10.1000	337.5200	87180.00	0.00	87180.00	89	56	133	678	0.196165191740413	0.481810581678868	0.484321702899308	true	false	false	true
c996b194-1e91-43df-a90c-7f6c7e83ed26	2026-09-10 10:12	2026-09-10 10:12	2026-09-10 10:12	SNOW	SNOW260911C00340000	call	340.0000	2026-09-11	4.7800	4.5000	4.8500	339.1600	119908.00	96958.00	22950.00	251	9	859	1315	0.653231939163498	0.73515651304339	0.73939623970354	false	false	false	true
8aa79ede-1ed6-4191-94c2-690550302a21	2026-09-10 09:47	2026-09-10 09:47	2026-09-10 09:47	SNOW	SNOW270115C00370000	call	370.0000	2027-01-15	31.2500	30.1500	32.0000	337.3148	515610.00	290705.00	134425.00	165	17	368	839	0.438617401668653	0.530141126343387	0.531406532216972	false	false	false	true
e14e6c51-6349-4130-9383-50646ec0293f	2026-09-10 09:47	2026-09-10 09:47	2026-09-10 09:47	SNOW	SNOW270115C00370000	call	370.0000	2027-01-15	31.4400	29.1500	32.8500	337.6300	584755.00	339670.00	135185.00	186	17	187	839	0.222884386174017	0.529447874408253	0.532088880275285	true	false	false	true
a972c103-e484-4fcf-bed1-3d913080f627	2026-09-09 14:46	2026-09-09 14:46	2026-09-09 14:46	SNOW	SNOW271217P00310000	put	310.0000	2027-12-17	60.6200	60.2000	62.5500	333.6600	333430.00	212725.00	120705.00	55	9	67	76	0.881578947368421	0.569317225650673	0.573518810056878	false	false	false	true
c6eb4a73-cd34-4a77-9aeb-d54a0f8ce02b	2026-09-09 14:46	2026-09-09 14:46	2026-09-09 14:46	SNOW	SNOW270917P00310000	put	310.0000	2027-09-17	53.9600	53.9000	55.9000	333.5750	53960.00	0.00	53960.00	10	5	10	331	0.0302114803625378	0.566773658862803	0.567612954224527	false	false	false	true
36884b62-e4a5-41c1-abef-b2b2d8ed313e	2026-09-09 11:36	2026-09-09 11:36	2026-09-09 11:36	SNOW	SNOW261120C00350000	call	350.0000	2026-11-20	23.7500	23.7000	24.2000	335.6900	178110.00	0.00	178110.00	75	9	1026	2011	0.510193933366484	0.481846936343139	0.484977571178383	false	false	false	true
54150a51-4f50-428e-bc29-ae11e4d687e6	2026-09-09 11:35	2026-09-09 11:35	2026-09-09 11:35	SNOW	SNOW280121C00330000	call	330.0000	2028-01-21	97.3400	95.4500	99.2000	335.8500	165475.00	58445.00	107030.00	17	5	31	208	0.149038461538462	0.56869383940392	0.56869383940392	false	false	false	true
bcf5aa40-15ce-4b07-8634-dd1241fb1730	2026-09-08 12:12	2026-09-08 12:12	2026-09-08 12:12	SNOW	SNOW260911P00342500	put	342.5000	2026-09-11	10.7000	10.7000	11.3500	334.6500	398047.00	0.00	398047.00	372	50	416	112	3.71428571428571	0.494771660135273	0.494771660135273	false	false	false	true
15c526aa-f850-4998-9db6-afc2d153161b	2026-09-08 11:41	2026-09-08 11:41	2026-09-08 11:41	SNOW	SNOW270917P00270000	put	270.0000	2027-09-17	34.3900	33.4500	34.5000	335.4750	96284.00	96284.00	0.00	28	11	28	31	0.903225806451613	0.55192411911637	0.55192411911637	false	false	false	true
cd179fd4-7899-40dc-a5ef-f3b44b3f41fa	2026-09-08 11:30	2026-09-08 11:30	2026-09-08 11:30	SNOW	SNOW261009C00325000	call	325.0000	2026-10-09	23.3200	22.9500	25.8000	334.9700	51305.00	18645.00	32660.00	22	16	22	12	1.83333333333333	0.446898598417879	0.446572470747625	true	false	false	true
5fee6447-672b-4e8a-84e2-da17674d49a2	2026-09-08 10:46	2026-09-08 10:46	2026-09-08 10:46	SNOW	SNOW261016C00370000	call	370.0000	2026-10-16	8.8600	8.5000	9.3000	339.2550	93942.00	9800.00	84142.00	106	37	119	612	0.194444444444444	0.444283485658109	0.443924548381079	false	false	false	true
fe9d5654-8545-4e1f-9d67-42bd13defef2	2026-09-04 15:49	2026-09-04 15:49	2026-09-04 15:49	SNOW	SNOW260904P00340000	put	340.0000	2026-09-04	3.0500	2.2200	3.2500	337.3550	76169.00	76169.00	0.00	250	9	6840	1385	4.93862815884477	1.55974050065555	1.55974050065555	false	false	false	true
c1a0b49f-c640-455c-b257-4527153e83c2	2026-09-04 14:21	2026-09-04 14:21	2026-09-04 14:21	SNOW	SNOW260904P00345000	put	345.0000	2026-09-04	4.0000	3.8500	4.4500	341.1699	67608.00	0.00	67608.00	169	24	3801	631	6.02377179080824	0.922729626765681	0.670533070861066	false	false	false	true
5509679d-2565-4975-b55e-3544045576c6	2026-09-04 10:49	2026-09-04 10:48	2026-09-04 10:48	SNOW	SNOW270115C00310000	call	310.0000	2027-01-15	67.4300	66.2500	68.5000	351.9607	53940.00	27000.00	26940.00	8	5	73	714	0.102240896358543	0.507308266195657	0.509445122800126	false	false	false	true
c9a7f0be-b4a4-4e9f-a2df-a9e9ac9c62e3	2026-09-04 10:31	2026-09-04 10:31	2026-09-04 10:31	SNOW	SNOW261218C00350000	call	350.0000	2026-12-18	39.6000	37.6500	39.7500	348.4100	178220.00	7940.00	170280.00	45	6	219	1071	0.204481792717087	0.514949872467084	0.519708017243408	false	false	false	true
ab78b787-451f-46b3-a321-227bb66b2a99	2026-09-04 10:03	2026-09-04 10:03	2026-09-04 10:03	SNOW	SNOW261002C00335000	call	335.0000	2026-10-02	23.4000	22.9500	24.6000	347.2400	51480.00	25795.00	25685.00	22	6	30	61	0.491803278688525	0.421939977977624	0.424751950318335	false	false	false	true
33bf10e9-d532-4608-a7f2-145138f58eca	2026-09-04 09:43	2026-09-04 09:43	2026-09-04 09:43	SNOW	SNOW260904P00350000	put	350.0000	2026-09-04	2.8000	2.8000	3.3000	352.4100	146442.00	0.00	146161.00	523	54	1081	1361	0.79426891991183	1.00148559701514	1.03773704158194	false	false	false	true
89764f9a-b5fe-43ad-a99b-fdea34bd2caf	2026-09-04 09:31	2026-09-04 09:31	2026-09-04 09:31	SNOW	SNOW270115P00320000	put	320.0000	2027-01-15	24.3100	24.2500	25.3500	354.9300	55915.00	7335.00	36435.00	23	21	24	1304	0.0184049079754601	0.510676163024946	0.513377955823658	true	false	false	true
ab5ed44f-ae87-45eb-99dd-6e734af1d28b	2026-09-03 15:41	2026-09-03 15:41	2026-09-03 15:41	SNOW	SNOW261016C00350000	call	350.0000	2026-10-16	27.8100	27.6000	28.5500	360.2000	88985.00	30590.00	58395.00	32	16	289	932	0.310085836909871	0.441235003645806	0.442293985552037	true	false	false	true
ac8e4182-786c-4aca-b9b9-c21d98666fc5	2026-09-03 15:04	2026-09-03 15:04	2026-09-03 15:04	SNOW	SNOW260904P00362500	put	362.5000	2026-09-04	5.7900	5.7000	6.2500	362.0000	269748.00	575.00	212038.00	466	29	1684	12	140.333333333333	0.722571331010839	0.729283983737238	true	false	false	true
3011da0c-42c1-40a6-a245-8ea1d1d8596b	2026-09-03 11:57	2026-09-03 11:57	2026-09-03 11:57	SNOW	SNOW260925C00375000	call	375.0000	2026-09-25	16.6400	16.3000	17.0500	373.0000	64885.00	44965.00	19920.00	39	9	100	27	3.7037037037037	0.467198600118221	0.469305962487135	true	false	false	true
85ee8ac8-f227-4381-b079-679367c9de87	2026-09-03 11:57	2026-09-03 11:57	2026-09-03 11:57	SNOW	SNOW260925C00380000	call	380.0000	2026-09-25	14.4200	13.6000	14.9000	373.1500	59115.00	39015.00	20100.00	41	19	94	45	2.08888888888889	0.466380881951235	0.469126007752716	true	false	false	true
9e94394a-0efa-4af5-8c62-a0065a59cb42	2026-09-03 11:32	2026-09-03 11:31	2026-09-03 11:31	SNOW	SNOW260925C00355000	call	355.0000	2026-09-25	23.7300	23.3500	24.3000	367.1850	436710.00	71100.00	320485.00	184	9	369	386	0.955958549222798	0.46408031008487	0.465570783856164	false	false	false	true
45fde493-d146-4356-b2a6-d565358b97ac	2026-09-03 11:04	2026-09-03 11:04	2026-09-03 11:04	SNOW	SNOW260911P00375000	put	375.0000	2026-09-11	13.5800	12.6000	14.0500	370.3750	73356.00	59831.00	1330.00	54	12	452	2	226	0.513905143960204	0.500557717847606	false	false	false	true
9ca3e497-c419-42a5-acb6-e368fda286b0	2026-09-03 10:40	2026-09-03 10:40	2026-09-03 10:40	SNOW	SNOW260911P00370000	put	370.0000	2026-09-11	10.7300	10.6000	11.2000	370.4600	56850.00	26880.00	29970.00	53	17	344	1	344	0.507086252813439	0.507086252813439	false	false	false	true
b79330a9-641b-4381-930b-3cb8cd759bcd	2026-09-03 10:07	2026-09-03 10:07	2026-09-03 10:07	SNOW	SNOW260918C00340000	call	340.0000	2026-09-18	39.9900	38.2500	41.0000	375.5200	127955.00	56005.00	71950.00	32	17	153	2228	0.0686714542190305	0.52801340204711	0.541578584902743	true	false	false	true
841275b4-0d41-4270-a8be-0e2703e786cd	2026-09-03 10:07	2026-09-03 10:07	2026-09-03 10:07	SNOW	SNOW260918C00340000	call	340.0000	2026-09-18	40.2100	38.9500	43.3500	375.9100	56300.00	4035.00	52265.00	14	6	121	2228	0.0543087971274686	0.562638294416535	0.550790874338004	true	false	false	true
12cd9c15-c51f-4891-ab3e-71de9ccd1a0f	2026-09-03 10:07	2026-09-03 10:07	2026-09-03 10:07	SNOW	SNOW260904C00350000	call	350.0000	2026-09-04	26.9500	26.9500	28.6500	375.4544	1266662.00	0.00	1266662.00	470	56	1887	2135	0.88384074941452	1.1890435494594	1.1890435494594	false	false	false	true
61eace3f-d544-4f8e-b19b-8bf9606305ba	2026-09-03 10:05	2026-09-03 10:05	2026-09-03 10:05	SNOW	SNOW261002C00395000	call	395.0000	2026-10-02	13.9800	13.4500	15.0500	377.2600	50320.00	21095.00	29225.00	36	12	54	3	18	0.48712172022582	0.491927197167193	true	false	false	true
4328954a-de6d-411e-bd3d-6275340aa8b3	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	31.1600	30.1000	31.2000	375.7200	162025.00	162025.00	0.00	52	10	1624	3169	0.512464499842222	0.993696425170134	1.01848108004344	false	false	false	true
2e222cb9-b8b5-4921-beb9-95ccf533abd1	2026-09-03 10:01	2026-09-03 10:01	2026-09-03 10:01	SNOW	SNOW261016C00330000	call	330.0000	2026-10-16	53.1300	53.1000	54.3500	374.1700	69070.00	10655.00	58415.00	13	5	66	488	0.135245901639344	0.490565956136624	0.496184985426261	true	false	false	true
8614da5f-216f-41d0-8e66-62b9999de014	2026-09-03 09:59	2026-09-03 09:59	2026-09-03 09:59	SNOW	SNOW260904P00375000	put	375.0000	2026-09-04	10.4400	10.0500	10.8000	371.4600	83500.00	83500.00	0.00	80	5	1115	203	5.49261083743842	1.09542710141557	1.10843512283776	true	false	false	true
0c72ea7e-cf23-426a-9e48-9d6d43cb2c55	2026-09-03 09:34	2026-09-03 09:34	2026-09-03 09:34	SNOW	SNOW260904P00380000	put	380.0000	2026-09-04	9.3700	9.2000	10.6500	381.2900	105890.00	20680.00	85210.00	113	6	300	8	37.5	1.2459004745735	1.26480994173882	true	false	false	true
9b75bd02-243b-40e5-a4ea-b634c5e08d9f	2026-09-03 09:32	2026-09-03 09:32	2026-09-03 09:32	SNOW	SNOW260911C00362500	call	362.5000	2026-09-11	24.2200	23.6000	25.0000	379.7650	55700.00	14610.00	41090.00	23	6	28	31	0.903225806451613	0.618326583973236	0.615712778653671	true	false	false	true
4af01234-de8b-4848-8559-01283ab7e2c9	2026-09-02 15:59	2026-09-02 15:59	2026-09-02 15:59	SNOW	SNOW261120C00270000	call	270.0000	2026-11-20	54.0000	53.9000	56.4000	306.8000	91805.00	37840.00	53965.00	17	13	17	469	0.0362473347547974	0.572655372483717	0.580249234969532	true	false	false	true