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: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

0dfedd74-7c45-42e2-875c-19b5f9b2ebbf	2026-09-09 11:35	2026-09-09 11:35	2026-09-09 11:35	SNOW	SNOW280121C00310000	call	310.0000	2028-01-21	105.6400	103.9000	107.5000	335.8500	538780.00	21150.00	517630.00	51	6	77	1894	0.0406546990496304	0.570897615066431	0.569047862713266	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-09T15:51:30.246262Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
dd1d46f2-8851-4ffc-b45a-88e4d696e796	2026-09-09 11:21	2026-09-09 11:21	2026-09-09 11:21	SNOW	SNOW260911C00345000	call	345.0000	2026-09-11	2.0000	2.0000	2.1000	333.3400	100000.00	0.00	100000.00	500	7	805	1558	0.516688061617458	0.612055487548809	0.612055487548809	false	false	false	true
1a7f8da9-9378-42b0-8ee6-a6efccc2a608	2026-09-09 11:17	2026-09-09 11:17	2026-09-09 11:17	SNOW	SNOW260911C00335000	call	335.0000	2026-09-11	5.0000	5.0000	5.0000	333.1300	100000.00	0.00	0.00	200	73	363	918	0.395424836601307	0.593713979100145	0.593713979100145	false	false	false	true
55bc7b7f-3c82-42d3-a241-fc7ce2c84269	2026-09-09 11:13	2026-09-09 11:13	2026-09-09 11:13	SNOW	SNOW270115P00220000	put	220.0000	2027-01-15	4.3500	3.7500	4.3500	332.4100	154852.00	154422.00	430.00	356	54	384	1976	0.194331983805668	0.567979967560643	0.567979967560643	false	false	false	true
123f9fdd-7bbe-430c-8bcf-00958225d54d	2026-09-09 10:39	2026-09-09 10:39	2026-09-09 10:39	SNOW	SNOW270319P00280000	put	280.0000	2027-03-19	23.3900	23.3000	24.7000	337.0000	135665.00	0.00	135665.00	58	13	59	188	0.313829787234043	0.560041822892336	0.557383037413612	false	false	false	true
ef04b1f3-6ab1-4cd6-9f29-4b0d66cfca67	2026-09-09 10:27	2026-09-09 10:27	2026-09-09 10:27	SNOW	SNOW260911C00337500	call	337.5000	2026-09-11	4.8000	4.0000	4.8000	334.0000	314857.00	314857.00	0.00	656	61	753	279	2.6989247311828	0.61499426832702	0.61499426832702	false	false	false	true
bdea4454-2a14-4914-85f5-2b678b9b0e70	2026-09-09 10:27	2026-09-09 10:27	2026-09-09 10:27	SNOW	SNOW260911C00330000	call	330.0000	2026-09-11	8.0000	8.0000	8.0000	334.0000	160000.00	0.00	0.00	200	86	214	9159	0.0233649961786221	0.572031443328314	0.572031443328314	false	false	false	true
6c1c1a5e-c6dc-4a1c-a4cc-2d21f5e3d405	2026-09-08 14:47	2026-09-08 14:47	2026-09-08 14:47	SNOW	SNOW260911C00335000	call	335.0000	2026-09-11	7.9500	7.5500	7.9500	338.1800	198750.00	198750.00	0.00	250	56	1085	209	5.19138755980861	0.506902533596248	0.506902533596248	true	false	false	true
9e66d4b8-f79b-4ebc-97d6-33621e38bb59	2026-09-08 14:47	2026-09-08 14:46	2026-09-08 14:46	SNOW	SNOW260911C00345000	call	345.0000	2026-09-11	3.5000	3.5000	3.6500	337.5300	87500.00	0.00	87500.00	250	32	1605	1263	1.270783847981	0.529356559160657	0.529356559160657	false	false	false	true
a7842091-5caa-4a00-97ae-03104cd6c2be	2026-09-08 14:45	2026-09-08 14:45	2026-09-08 14:45	SNOW	SNOW261120P00380000	put	380.0000	2026-11-20	53.8500	51.7000	53.8500	337.5100	183088.00	183088.00	0.00	34	14	35	47	0.74468085106383	0.474482941657088	0.472597365179754	false	false	false	true
813230bb-c7aa-48d3-8385-fe6ca56eb3c9	2026-09-08 13:59	2026-09-08 13:59	2026-09-08 13:59	SNOW	SNOW261120P00260000	put	260.0000	2026-11-20	3.5000	3.2500	3.5000	338.8050	54946.00	54946.00	0.00	157	34	173	421	0.410926365795724	0.49791116399835	0.49791116399835	false	false	false	true
92fd5482-e1c6-4892-b33e-8f55eed21866	2026-09-08 13:50	2026-09-08 13:49	2026-09-08 13:49	SNOW	SNOW261120P00310000	put	310.0000	2026-11-20	14.1000	13.6500	14.4500	339.1800	396195.00	394785.00	1410.00	281	45	336	81	4.14814814814815	0.469353684116305	0.469353684116305	false	false	false	true
e0c62ecc-c1e6-4a6a-9c61-5652ebca144f	2026-09-08 13:49	2026-09-08 13:48	2026-09-08 13:48	SNOW	SNOW260911P00350000	put	350.0000	2026-09-11	12.7500	12.2000	12.7500	339.8850	86700.00	86700.00	0.00	68	11	271	770	0.351948051948052	0.526795319936824	0.526795319936824	false	false	false	true
a24c4b05-e726-478c-b2c4-26b63bf561d7	2026-09-08 13:47	2026-09-08 13:47	2026-09-08 13:47	SNOW	SNOW260911P00350000	put	350.0000	2026-09-11	12.5000	12.1000	13.2000	339.8950	187500.00	106250.00	81250.00	150	81	171	770	0.222077922077922	0.503183261664819	0.503183261664819	false	false	false	true
8bd6adb4-c877-4a46-8257-d019fef0cd35	2026-09-08 13:33	2026-09-08 13:33	2026-09-08 13:33	SNOW	SNOW270617P00380000	put	380.0000	2027-06-17	84.0400	82.7000	84.2000	337.9800	67230.00	42075.00	16740.00	8	6	9	11	0.818181818181818	0.546351222485795	0.542126861717786	false	false	false	true
2c478c7a-8d7e-4095-ab2b-3aef631466ea	2026-09-08 13:31	2026-09-08 13:31	2026-09-08 13:31	SNOW	SNOW260911C00340000	call	340.0000	2026-09-11	5.0000	4.8500	5.0000	337.3100	62000.00	62000.00	0.00	124	68	1110	898	1.23608017817372	0.511622821742638	0.506863394104337	true	false	false	true
ddb31c03-05a1-47d0-a817-ad9b21f573d8	2026-09-08 12:50	2026-09-08 12:50	2026-09-08 12:50	SNOW	SNOW260918C00350000	call	350.0000	2026-09-18	4.8000	4.6000	5.0500	335.2200	101280.00	0.00	101280.00	211	5	1078	1922	0.560874089490114	0.463073362896914	0.463073362896914	false	false	false	true
bb38ba67-63d1-4bd4-9e8d-7e3537a054b0	2026-09-08 12:49	2026-09-08 12:48	2026-09-08 12:48	SNOW	SNOW261120P00280000	put	280.0000	2026-11-20	6.7000	6.4000	6.7000	335.2700	54270.00	54270.00	0.00	81	28	98	211	0.464454976303318	0.47579582650911	0.47579582650911	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
aeb84dd1-d563-4275-a1f1-d486295ffcac	2026-09-08 12:06	2026-09-08 12:06	2026-09-08 12:06	SNOW	SNOW270617P00180000	put	180.0000	2027-06-17	5.8000	5.5000	6.0500	334.7100	110200.00	63800.00	46400.00	190	5	190	413	0.460048426150121	0.578548231240181	0.578548231240181	false	false	false	true
4c296f3b-94b7-4ce0-b4ec-e15aab3e9561	2026-09-08 11:41	2026-09-08 11:41	2026-09-08 11:41	SNOW	SNOW261120C00400000	call	400.0000	2026-11-20	8.5500	8.5500	9.1000	335.3099	150484.00	0.00	150484.00	176	33	209	518	0.403474903474904	0.457021043359912	0.457021043359912	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
26ce74ed-960e-4a38-a7cb-ec2253627d27	2026-09-08 11:27	2026-09-08 11:26	2026-09-08 11:26	SNOW	SNOW260911C00335000	call	335.0000	2026-09-11	6.3000	6.3000	6.6500	334.7500	340205.00	0.00	340205.00	540	5	612	209	2.92822966507177	0.512394782617388	0.526290264466749	false	false	false	true
dc0532d1-c907-40a5-b081-7db11a448b6c	2026-09-08 11:26	2026-09-08 11:25	2026-09-08 11:25	SNOW	SNOW261023P00335000	put	335.0000	2026-10-23	20.2500	19.9000	20.8500	334.6553	101250.00	0.00	101250.00	50	8	52	9	5.77777777777778	0.445777777284218	0.445777777284218	false	false	false	true
d00516cd-17ee-423b-a487-5dd489055178	2026-09-08 11:13	2026-09-08 11:13	2026-09-08 11:13	SNOW	SNOW270115C00400000	call	400.0000	2027-01-15	21.2800	20.8500	21.7500	336.7700	72360.00	17060.00	55300.00	34	9	280	3706	0.0755531570426336	0.515479722617842	0.514810093807963	false	false	false	true
2bcbfc1c-cd1b-44f6-97d0-dbfe38980b59	2026-09-08 11:13	2026-09-08 11:13	2026-09-08 11:13	SNOW	SNOW270115C00400000	call	400.0000	2027-01-15	21.4800	20.7500	21.6000	336.7700	126705.00	25800.00	100905.00	59	15	246	3706	0.0663788451160281	0.518156102785202	0.518156102785202	false	false	false	true
05f34773-a0ed-4121-b310-9e3c5779d558	2026-09-08 11:13	2026-09-08 11:13	2026-09-08 11:13	SNOW	SNOW270115C00400000	call	400.0000	2027-01-15	21.5000	20.7500	21.7500	336.7700	90300.00	12900.00	77400.00	42	6	187	3706	0.0504587155963303	0.518156102785202	0.518156102785202	false	false	false	true
3bb61a3f-079e-4b9f-9983-ad5f9664185b	2026-09-08 11:13	2026-09-08 11:12	2026-09-08 11:12	SNOW	SNOW270115C00400000	call	400.0000	2027-01-15	21.4600	20.6000	21.5000	336.8500	306939.00	214999.00	91940.00	143	16	145	3706	0.0391257420399352	0.517772828286547	0.516435514706585	false	false	false	true
156cd8e2-3c53-4ec5-a3a6-c90f1e5e3bb4	2026-09-08 10:59	2026-09-08 10:59	2026-09-08 10:59	SNOW	SNOW261009P00340000	put	340.0000	2026-10-09	17.6500	16.9500	18.4500	338.8750	210035.00	8825.00	201210.00	119	25	120	28	4.28571428571429	0.447598297466279	0.447598297466279	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
b1b7293e-2059-408f-a4c6-567251ba5de8	2026-09-08 10:35	2026-09-08 10:35	2026-09-08 10:35	SNOW	SNOW260911C00350000	call	350.0000	2026-09-11	2.8000	2.8000	3.0000	339.3500	70000.00	0.00	70000.00	250	7	844	2675	0.315514018691589	0.546648045907258	0.546648045907258	false	false	false	true
e5e55edb-3423-480b-a510-3e1c4a713988	2026-09-08 10:28	2026-09-08 10:28	2026-09-08 10:28	SNOW	SNOW261016C00320000	call	320.0000	2026-10-16	30.7500	30.4500	31.6500	337.9000	119940.00	12275.00	107665.00	39	11	61	821	0.074299634591961	0.460879364146359	0.463702696590259	true	false	false	true
5ccb1545-8950-4773-9db2-086a5848e79a	2026-09-08 10:21	2026-09-08 10:21	2026-09-08 10:21	SNOW	SNOW260918P00340000	put	340.0000	2026-09-18	11.5000	11.3000	11.9500	338.4388	67850.00	11500.00	56350.00	59	8	85	458	0.185589519650655	0.486333296677614	0.486333296677614	true	false	false	true
59f4267e-0dbc-4135-a782-8de79b02efcf	2026-09-08 10:15	2026-09-08 10:15	2026-09-08 10:15	SNOW	SNOW260911C00345000	call	345.0000	2026-09-11	4.2000	3.9500	4.2000	338.6600	63420.00	63420.00	0.00	151	24	747	1263	0.59144893111639	0.57318453988533	0.555948152890581	true	false	false	true
15a65269-18ef-484a-b344-0313d48428e3	2026-09-08 09:57	2026-09-08 09:57	2026-09-08 09:57	SNOW	SNOW260918C00350000	call	350.0000	2026-09-18	6.7500	6.7500	6.9500	339.6100	113400.00	0.00	113400.00	168	21	529	1922	0.275234131113424	0.485604358307203	0.485604358307203	true	false	false	true
605a65c4-4395-4c93-9ac6-4535d2c214e4	2026-09-08 09:56	2026-09-08 09:56	2026-09-08 09:56	SNOW	SNOW261120P00300000	put	300.0000	2026-11-20	11.0900	10.5000	11.1500	339.0650	89865.00	88775.00	1090.00	81	35	101	163	0.619631901840491	0.474801402956254	0.474801402956254	false	false	false	true
787a9abd-0ace-4a3a-8cb9-7c74420c618d	2026-09-08 09:39	2026-09-08 09:39	2026-09-08 09:39	SNOW	SNOW260911C00345000	call	345.0000	2026-09-11	5.0000	4.5000	5.0000	339.8000	87500.00	87500.00	0.00	175	15	240	1263	0.190023752969121	0.586748549726284	0.586748549726284	true	false	false	true
aab3605a-0e56-4739-a6f1-5dbdf5aac8f3	2026-09-08 09:35	2026-09-08 09:35	2026-09-08 09:35	SNOW	SNOW260911P00325000	put	325.0000	2026-09-11	2.4400	2.1400	2.4500	338.4850	81004.00	80032.00	0.00	332	45	339	464	0.730603448275862	0.609596003158298	0.609596003158298	false	false	false	true
97fedd3e-22ac-4b44-8a93-9c21c348c37f	2026-09-04 15:59	2026-09-04 15:59	2026-09-04 15:59	SNOW	SNOW260911P00330000	put	330.0000	2026-09-11	4.2000	3.8000	4.2000	337.4900	209160.00	209160.00	0.00	498	54	2206	495	4.45656565656566	0.406569952244118	0.403462620257374	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
466c1718-873b-4f52-a316-d1e6a31832ba	2026-09-04 15:49	2026-09-04 15:49	2026-09-04 15:49	SNOW	SNOW260911C00340000	call	340.0000	2026-09-11	6.5000	6.4000	6.8500	337.4550	152750.00	120250.00	32500.00	235	52	1253	232	5.40086206896552	0.411763811598384	0.40592138635326	false	false	false	true
0454da73-6c0e-4f97-86fd-d7aaf02804fb	2026-09-04 15:49	2026-09-04 15:49	2026-09-04 15:49	SNOW	SNOW260911C00340000	call	340.0000	2026-09-11	6.5000	6.5000	6.5000	337.2500	116350.00	0.00	0.00	179	95	932	232	4.01724137931035	0.411020240259686	0.411020240259686	false	false	false	true
872cb0c9-4372-46a4-a2ae-aec29127a606	2026-09-04 15:45	2026-09-04 15:45	2026-09-04 15:45	SNOW	SNOW260911C00340000	call	340.0000	2026-09-11	6.7500	6.3500	6.7500	337.7300	54000.00	54000.00	0.00	80	6	626	232	2.69827586206897	0.415117579129349	0.412470649761051	false	false	false	true
299ad413-66b0-47de-9249-4a4344386ab7	2026-09-04 15:45	2026-09-04 15:45	2026-09-04 15:45	SNOW	SNOW260911P00330000	put	330.0000	2026-09-11	4.2000	4.1000	4.2000	337.5600	115080.00	115080.00	0.00	274	36	1635	495	3.3030303030303	0.41034013896686	0.40482362990738	true	false	false	true
3ab8e49a-0e01-44f9-bd83-6608003bcbd8	2026-09-04 14:32	2026-09-04 14:32	2026-09-04 14:32	SNOW	SNOW260911P00330000	put	330.0000	2026-09-11	3.7500	3.6000	3.7500	339.2500	76500.00	76500.00	0.00	204	37	910	495	1.83838383838384	0.413249716096385	0.409594739725201	true	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
794f3f4a-b77a-4ad3-b3b4-af6a3e6572ae	2026-09-04 13:32	2026-09-04 13:32	2026-09-04 13:32	SNOW	SNOW261002P00375000	put	375.0000	2026-10-02	36.9900	33.8500	37.2000	342.6999	66575.00	33255.00	33320.00	18	5	19	11	1.72727272727273	0.42947614258775	0.432781509259407	true	false	false	true
47223d70-6bef-4dc4-975f-518f50696332	2026-09-04 13:32	2026-09-04 13:32	2026-09-04 13:32	SNOW	SNOW261002P00365000	put	365.0000	2026-10-02	29.2800	27.8500	29.4500	342.6999	111255.00	61500.00	49755.00	38	10	50	15	3.33333333333333	0.424723364529398	0.420329908101319	true	false	false	true
4ef64f94-a124-47b9-b550-0c1684e86763	2026-09-04 12:37	2026-09-04 12:36	2026-09-04 12:36	SNOW	SNOW261120C00380000	call	380.0000	2026-11-20	14.8000	14.6500	14.9000	342.8180	68085.00	34155.00	33930.00	46	6	58	769	0.0754226267880364	0.43677665954581	0.435069907569268	false	false	false	true