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

f0a62592-d5d7-4de6-b97a-98f79f1753d6	2026-09-02 15:55	2026-09-02 15:55	2026-09-02 15:55	SNOW	SNOW260918C00330000	call	330.0000	2026-09-18	13.9000	13.6500	13.9000	307.3000	58380.00	56990.00	0.00	42	13	332	1204	0.275747508305648	0.87798955596826	0.878461199884791	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-02T19:59:06.148248Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
63575534-9801-4c3f-b8be-92a13809a1bb	2026-09-02 15:54	2026-09-02 15:54	2026-09-02 15:54	SNOW	SNOW260904C00310000	call	310.0000	2026-09-04	19.4000	19.4000	19.8000	307.5100	58201.00	0.00	58201.00	30	10	1102	121	9.10743801652893	2.26104873334495	2.26104873334495	false	false	false	true
aa53dc26-beba-4f8b-b98b-7aae8c9693a7	2026-09-02 15:53	2026-09-02 15:53	2026-09-02 15:53	SNOW	SNOW261016P00330000	put	330.0000	2026-10-16	39.4000	39.3500	39.9000	307.5300	133960.00	0.00	133960.00	34	12	255	1254	0.203349282296651	0.630090417561453	0.630090417561453	false	false	false	true
0f022c8e-7778-4aa0-b003-6dadca84c876	2026-09-02 15:44	2026-09-02 15:44	2026-09-02 15:44	SNOW	SNOW261120P00290000	put	290.0000	2026-11-20	22.4000	22.4000	23.1000	307.1100	107520.00	0.00	107520.00	48	5	266	835	0.318562874251497	0.567397853192627	0.567397853192627	false	false	false	true
e5fd2042-6491-4982-9478-c1c7c1a93141	2026-09-02 15:44	2026-09-02 15:43	2026-09-02 15:43	SNOW	SNOW261218C00340000	call	340.0000	2026-12-18	28.0000	27.6500	29.0000	306.8500	89600.00	0.00	89600.00	32	6	179	800	0.22375	0.592855706339033	0.592855706339033	false	false	false	true
8e2a549c-d01b-49b1-acf1-d75c26d510ef	2026-09-02 15:20	2026-09-02 15:20	2026-09-02 15:20	SNOW	SNOW260904C00320000	call	320.0000	2026-09-04	15.5500	15.3000	15.6000	308.5550	66855.00	40430.00	26425.00	43	10	1029	549	1.87431693989071	2.23817549351451	2.23817549351451	false	false	false	true
58a0c488-d90e-4dea-8ff1-f69992ec249a	2026-09-02 15:13	2026-09-02 15:13	2026-09-02 15:13	SNOW	SNOW260918P00250000	put	250.0000	2026-09-18	3.1500	2.8600	3.2000	308.8350	107730.00	30240.00	16380.00	342	26	841	2565	0.327875243664717	0.881849397598026	0.881849397598026	true	false	false	true
e33de3a1-1454-47cd-a063-87373fb4752f	2026-09-02 15:08	2026-09-02 15:08	2026-09-02 15:08	SNOW	SNOW260911C00310000	call	310.0000	2026-09-11	20.6500	20.6500	21.4000	309.4150	278775.00	0.00	278775.00	135	6	481	84	5.72619047619048	1.07360572805058	1.07360572805058	false	false	false	true
be7f4e67-124d-4cca-8052-50f3e92b09d9	2026-09-02 15:06	2026-09-02 15:05	2026-09-02 15:05	SNOW	SNOW260911C00310000	call	310.0000	2026-09-11	21.5500	20.6000	21.5500	309.8600	290925.00	290925.00	0.00	135	13	346	84	4.11904761904762	1.10788446822838	1.10788446822838	false	false	false	true
82f8bafb-5fa6-4206-b75c-f8b5d016b315	2026-09-02 15:02	2026-09-02 15:02	2026-09-02 15:02	SNOW	SNOW261218C00310000	call	310.0000	2026-12-18	40.0000	38.9500	40.0000	308.4300	76000.00	76000.00	0.00	19	14	105	886	0.118510158013544	0.589563358962064	0.589563358962064	false	false	false	true
a2d97b00-fc69-4514-a908-964e97bde028	2026-09-02 14:49	2026-09-02 14:49	2026-09-02 14:49	SNOW	SNOW261218C00310000	call	310.0000	2026-12-18	39.0000	38.9500	39.0000	307.2100	97500.00	3900.00	0.00	25	18	86	886	0.0970654627539503	0.58489077609174	0.58489077609174	false	false	false	true
d20b1238-5fe3-4b58-8a47-2d4e8587ec6f	2026-09-02 14:48	2026-09-02 14:48	2026-09-02 14:48	SNOW	SNOW261218C00310000	call	310.0000	2026-12-18	38.7000	38.4500	38.7000	307.1496	96750.00	3870.00	0.00	25	18	61	886	0.0688487584650113	0.58082904795694	0.58082904795694	false	false	false	true
127ed020-bd49-4560-905a-9d9b61455b10	2026-09-02 14:45	2026-09-02 14:45	2026-09-02 14:45	SNOW	SNOW260918C00315000	call	315.0000	2026-09-18	18.9500	18.9500	19.1000	306.9173	94750.00	0.00	68220.00	50	10	71	97	0.731958762886598	0.869205032971544	0.869205032971544	false	false	false	true
4ad4ed40-6915-41a1-a8b2-34609694f198	2026-09-02 14:33	2026-09-02 14:33	2026-09-02 14:33	SNOW	SNOW270115C00370000	call	370.0000	2027-01-15	22.5000	22.5000	23.9000	306.9500	56250.00	0.00	56250.00	25	5	39	790	0.0493670886075949	0.564388456675562	0.564388456675562	false	false	false	true
63bb69c5-5e7e-4d11-9686-6e3cee68b2b4	2026-09-02 13:36	2026-09-02 13:36	2026-09-02 13:36	SNOW	SNOW261002C00310000	call	310.0000	2026-10-02	23.0000	22.8500	23.8000	306.0000	128800.00	2295.00	126505.00	56	19	82	10	8.2	0.697212073278733	0.695781594819211	false	false	false	true
b1d6b287-7e73-4ca7-9ee5-b64a6b30454c	2026-09-02 13:31	2026-09-02 13:31	2026-09-02 13:31	SNOW	SNOW261120P00340000	put	340.0000	2026-11-20	51.9500	50.3500	52.0000	305.8800	275335.00	20780.00	254555.00	53	12	71	527	0.134724857685009	0.573120858188876	0.573120858188876	false	false	false	true
a4c8d391-abd2-4e11-b235-1a6a1e3239e3	2026-09-02 13:31	2026-09-02 13:31	2026-09-02 13:31	SNOW	SNOW270115C00430000	call	430.0000	2027-01-15	11.5500	11.5500	11.7500	305.8700	75075.00	0.00	75075.00	65	6	129	66	1.95454545454545	0.570454466174281	0.57029412174697	false	false	false	true
d48c840a-f179-408e-afa4-92691098e403	2026-09-02 13:29	2026-09-02 13:29	2026-09-02 13:29	SNOW	SNOW260918P00300000	put	300.0000	2026-09-18	19.3000	19.3000	20.0500	305.5600	67550.00	0.00	67550.00	35	11	247	931	0.26530612244898	0.87986595489964	0.87986595489964	true	false	false	true
581cc6c2-c04b-4bd1-8cb4-aec4d1f1a0b5	2026-09-02 13:01	2026-09-02 13:00	2026-09-02 13:00	SNOW	SNOW260911C00295000	call	295.0000	2026-09-11	25.9000	24.6500	26.7500	304.4450	62159.00	59564.00	2595.00	24	12	28	17	1.64705882352941	1.10310350803823	1.10582537874547	true	false	false	true
2799a04a-e797-4848-b013-4f3c2a7ecf2b	2026-09-02 13:00	2026-09-02 13:00	2026-09-02 13:00	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	6.4000	6.3000	6.5000	305.0850	63360.00	2560.00	44160.00	99	27	2363	1152	2.05121527777778	2.13378432351896	2.13378432351896	false	false	false	true
569d86cc-cf1c-4545-8174-63651bc3139a	2026-09-02 12:59	2026-09-02 12:58	2026-09-02 12:58	SNOW	SNOW270319P00310000	put	310.0000	2027-03-19	50.4500	50.4500	50.9000	305.2250	60540.00	0.00	60540.00	12	5	26	181	0.143646408839779	0.581034829850677	0.581034829850677	false	false	false	true
bfec45c0-1598-491d-884a-ac660a2dee8d	2026-09-02 12:58	2026-09-02 12:58	2026-09-02 12:58	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	6.4000	6.4000	6.6000	305.4450	78720.00	0.00	78720.00	123	32	2105	1152	1.82725694444444	2.11952631131529	2.12141622527941	true	false	false	true
9892467e-8e81-49ef-874b-e9b2b465aeee	2026-09-02 12:05	2026-09-02 12:05	2026-09-02 12:05	SNOW	SNOW261218C00310000	call	310.0000	2026-12-18	39.7000	38.7000	41.1000	307.0500	99250.00	87340.00	11910.00	25	18	30	886	0.0338600451467269	0.596976456405417	0.596976456405417	false	false	false	true
3d832011-e1b0-4841-bf52-f9700003e915	2026-09-02 12:03	2026-09-02 12:03	2026-09-02 12:03	SNOW	SNOW260904P00290000	put	290.0000	2026-09-04	11.6000	11.6000	11.7500	307.0900	145000.00	0.00	1160.00	125	47	771	545	1.41467889908257	2.15293478833538	2.15293478833538	false	false	false	true
b195b6ee-5557-43e8-938a-a9762eec83ec	2026-09-02 11:52	2026-09-02 11:52	2026-09-02 11:52	SNOW	SNOW260918P00307500	put	307.5000	2026-09-18	22.4000	22.2500	22.9000	306.6100	304625.00	197120.00	107505.00	136	31	171	19	9	0.868053889172576	0.868053889172576	false	false	false	true
efb465e9-a192-4337-a10e-bd80fa4fc3a8	2026-09-02 11:51	2026-09-02 11:51	2026-09-02 11:51	SNOW	SNOW260904P00290000	put	290.0000	2026-09-04	11.5000	11.5000	11.8000	306.9700	60950.00	0.00	35650.00	53	21	603	545	1.10642201834862	2.13597328878723	2.13597328878723	false	false	false	true
0bc76d71-135b-4b43-a04e-ade2cf853c89	2026-09-02 11:50	2026-09-02 11:50	2026-09-02 11:50	SNOW	SNOW261120P00320000	put	320.0000	2026-11-20	38.7500	38.2500	38.8000	306.5777	120125.00	93000.00	27125.00	31	7	65	81	0.802469135802469	0.573732736865848	0.573732736865848	false	false	false	true
80d21918-6914-4133-bb8c-4996c89dee8b	2026-09-02 11:50	2026-09-02 11:50	2026-09-02 11:50	SNOW	SNOW261120P00330000	put	330.0000	2026-11-20	44.9500	43.8500	44.9500	306.9250	71920.00	71920.00	0.00	16	7	27	91	0.296703296703297	0.57702401154702	0.57702401154702	true	false	false	true
7d56d276-84c2-4c00-9e3f-8bbce0f0163b	2026-09-02 11:49	2026-09-02 11:49	2026-09-02 11:49	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	6.5000	6.3500	6.6000	307.6600	57850.00	3250.00	35100.00	89	23	1216	1152	1.05555555555556	2.05716070522627	2.05906132599571	false	false	false	true
f1c2d5ef-9c43-4b04-bdf0-b8a87117f6d7	2026-09-02 11:48	2026-09-02 11:48	2026-09-02 11:48	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	6.5000	6.3000	6.6000	307.9000	68250.00	1950.00	43550.00	105	22	886	1152	0.769097222222222	2.04350703111391	2.0507667766392	false	false	false	true
2bddbfcd-9566-4888-9fb4-8ef772d56ce0	2026-09-02 11:45	2026-09-02 11:45	2026-09-02 11:45	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	6.5000	6.2500	6.7000	308.6000	52650.00	3250.00	42900.00	81	18	642	1152	0.557291666666667	2.0265600292496	2.0265600292496	false	false	false	true
508dc926-878f-46a2-a4a9-577ca5f29bbc	2026-09-02 11:44	2026-09-02 11:44	2026-09-02 11:44	SNOW	SNOW260904C00345000	call	345.0000	2026-09-04	6.5000	6.5000	6.6500	308.9590	150150.00	0.00	16250.00	231	14	488	1152	0.423611111111111	2.01413671950572	2.01413671950572	false	false	false	true
06a04b50-b6c8-4ad1-9a84-a297197b3f0e	2026-09-02 11:25	2026-09-02 11:25	2026-09-02 11:25	SNOW	SNOW261120P00290000	put	290.0000	2026-11-20	21.4500	20.9500	21.4500	311.1600	105105.00	105105.00	0.00	49	12	65	835	0.0778443113772455	0.575685828246019	0.575685828246019	false	false	false	true
12db4514-280a-4208-aea3-b4586ee6c7da	2026-09-02 10:06	2026-09-02 10:06	2026-09-02 10:06	SNOW	SNOW260904C00370000	call	370.0000	2026-09-04	3.2000	3.1500	3.6500	313.4500	276816.00	320.00	276496.00	865	65	945	1424	0.663623595505618	1.97635930105242	1.96686509985806	true	false	false	true
9c9b508f-8322-411d-81ba-4a6bd763d95c	2026-09-02 09:38	2026-09-02 09:38	2026-09-02 09:38	SNOW	SNOW260904P00275000	put	275.0000	2026-09-04	6.0500	5.3500	6.3000	308.8700	119790.00	38720.00	81070.00	198	12	684	376	1.81914893617021	2.12777372192288	2.11594248776895	true	false	false	true
d4738f56-bf1f-49dd-912a-905be70046ab	2026-09-02 09:36	2026-09-02 09:36	2026-09-02 09:36	SNOW	SNOW260904P00325000	put	325.0000	2026-09-04	28.0000	27.1500	28.0000	310.9700	280000.00	280000.00	0.00	100	5	157	748	0.209893048128342	2.16022358296861	2.16022358296861	false	false	false	true
7e1d9c71-df8c-4d1e-8f94-90e99938b2a2	2026-09-01 15:58	2026-09-01 15:58	2026-09-01 15:58	SNOW	SNOW260904C00325000	call	325.0000	2026-09-04	18.1000	17.9000	18.5000	319.4101	56110.00	3630.00	52480.00	31	15	258	664	0.38855421686747	1.77671501980976	1.78095651343673	true	false	false	true
d6a3f35b-2675-4e88-83d8-0c33761164c6	2026-09-01 15:45	2026-09-01 15:44	2026-09-01 15:44	SNOW	SNOW260911C00327500	call	327.5000	2026-09-11	17.7500	17.6000	18.1000	319.1350	1072100.00	0.00	1072100.00	604	11	625	36	17.3611111111111	1.00816472098512	1.00985613904936	false	false	false	true
4ad5b009-2cea-43cc-9fac-bf960a152ea3	2026-09-01 15:44	2026-09-01 15:44	2026-09-01 15:44	SNOW	SNOW260911P00300000	put	300.0000	2026-09-11	12.6500	12.1000	12.6500	319.3500	63248.00	63248.00	0.00	50	23	133	199	0.668341708542714	1.03087277483005	1.03087277483005	false	false	false	true
c7155740-ce11-4a90-9698-22d71db9366d	2026-09-01 15:44	2026-09-01 15:44	2026-09-01 15:44	SNOW	SNOW261218C00350000	call	350.0000	2026-12-18	30.7000	30.7000	30.8500	319.3400	79820.00	0.00	79820.00	26	7	123	960	0.128125	0.593764666029437	0.594169468847997	false	false	false	true
8f7ffb6d-99d3-4592-ac1c-84f6ddd5096e	2026-09-01 15:44	2026-09-01 15:43	2026-09-01 15:43	SNOW	SNOW270617P00350000	put	350.0000	2027-06-17	77.3400	77.3000	77.9500	319.5200	54140.00	0.00	46405.00	7	7	48	43	1.11627906976744	0.583135855859583	0.582690236962669	true	false	false	true
f7927ee8-40ff-43a9-850e-29174cf8be49	2026-09-01 15:19	2026-09-01 15:19	2026-09-01 15:19	SNOW	SNOW260904P00310000	put	310.0000	2026-09-04	15.5000	15.3000	15.6500	319.5300	159650.00	7750.00	151900.00	103	5	1028	590	1.74237288135593	1.75424199616402	1.75424199616402	false	false	false	true
a4435d89-47d3-4646-b439-e9991b000894	2026-09-01 15:19	2026-09-01 15:19	2026-09-01 15:19	SNOW	SNOW260904P00310000	put	310.0000	2026-09-04	15.5500	15.3000	15.6000	319.5300	129065.00	129065.00	0.00	83	8	1111	590	1.88305084745763	1.75873120904564	1.75873120904564	false	false	false	true
d97d887c-2a15-4e31-9d2d-9d7e850fa6b0	2026-09-01 12:00	2026-09-01 12:00	2026-09-01 12:00	SNOW	SNOW261016P00330000	put	330.0000	2026-10-16	30.9500	30.1500	30.9500	322.4425	563286.00	563286.00	0.00	182	32	195	1127	0.173025732031943	0.612267673375392	0.612267673375392	false	false	false	true
994514e5-b377-470a-9346-0da4c4917415	2026-09-01 11:25	2026-09-01 11:25	2026-09-01 11:25	SNOW	SNOW260904P00300000	put	300.0000	2026-09-04	9.2500	9.0000	9.4500	322.4700	172975.00	172975.00	0.00	187	7	1053	1345	0.782899628252788	1.63435439249419	1.63435439249419	false	false	false	true
4e461fa7-4c52-4ad1-bb31-acbcf6279334	2026-09-01 11:25	2026-09-01 11:25	2026-09-01 11:25	SNOW	SNOW260904P00310000	put	310.0000	2026-09-04	13.1500	12.8500	13.4500	322.4700	358995.00	198565.00	160430.00	273	25	678	590	1.14915254237288	1.64291699894238	1.64291699894238	false	false	false	true
bd38c909-a0a7-4088-9d7c-b376dc4196bd	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	SNOW	SNOW260904P00300000	put	300.0000	2026-09-04	8.4000	7.9000	8.8500	325.1800	183960.00	183960.00	0.00	219	7	223	1345	0.165799256505576	1.62409826186594	1.62409826186594	true	false	false	true
3da9fde6-730b-4359-a128-db062fb216e1	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	SNOW	SNOW260904P00310000	put	310.0000	2026-09-04	12.1000	12.1000	12.7000	325.1800	169400.00	0.00	169400.00	140	5	149	590	0.252542372881356	1.63504466402083	1.63504466402083	true	false	false	true
cefe6b89-6d82-4c28-8f38-753181fcdc61	2026-08-31 15:57	2026-08-31 15:57	2026-08-31 15:57	SNOW	SNOW260918P00340000	put	340.0000	2026-09-18	27.4500	27.4500	28.7500	331.4300	205875.00	0.00	205875.00	75	22	97	192	0.505208333333333	0.784241788803392	0.784241788803392	false	false	false	true
fd0abbf4-99b6-4dff-ba2d-f1e888465170	2026-08-31 15:23	2026-08-31 15:23	2026-08-31 15:23	SNOW	SNOW260918C00330000	call	330.0000	2026-09-18	23.6500	23.3000	23.9000	330.4350	236500.00	167915.00	68585.00	100	16	163	1283	0.127045985970382	0.791939668529284	0.791939668529284	false	false	false	true