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

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	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-08T17:11:09.796111Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
151e6692-95a4-4748-b0ea-b2418d1d6b54	2026-09-04 12:32	2026-09-04 12:32	2026-09-04 12:32	SNOW	SNOW260904P00342500	put	342.5000	2026-09-04	1.8700	1.8700	1.9800	342.7600	54604.00	0.00	54604.00	292	21	2961	460	6.43695652173913	0.717905118004926	0.736010204747348	true	false	false	true
527db8de-8840-4213-9dbc-908f090da3d3	2026-09-04 12:28	2026-09-04 12:28	2026-09-04 12:28	SNOW	SNOW260904P00347500	put	347.5000	2026-09-04	3.8000	3.6500	4.0000	344.3900	76000.00	32300.00	43700.00	200	10	2180	279	7.81362007168459	0.667682756463374	0.667682756463374	false	false	false	true
81eddf6f-19f5-4a97-abfa-3c00ea60d723	2026-09-04 12:27	2026-09-04 12:26	2026-09-04 12:26	SNOW	SNOW260918C00330000	call	330.0000	2026-09-18	19.9500	19.9500	21.7000	344.4500	57855.00	0.00	57855.00	29	5	98	1229	0.0797396257119609	0.413899872470427	0.413899872470427	false	false	false	true
cc38c150-234e-43bd-8d04-669e8cd6ee66	2026-09-04 12:25	2026-09-04 12:25	2026-09-04 12:25	SNOW	SNOW260918C00360000	call	360.0000	2026-09-18	5.5500	5.3500	5.8000	344.9796	55500.00	0.00	55500.00	100	5	657	1766	0.37202718006795	0.412785058777601	0.412785058777601	false	false	false	true
c8a7ed5d-41fc-4899-82e2-d5ae35c57f66	2026-09-04 11:58	2026-09-04 11:57	2026-09-04 11:57	SNOW	SNOW280121P00260000	put	260.0000	2028-01-21	35.7000	33.4500	36.9500	347.2400	99960.00	60690.00	39270.00	28	10	37	541	0.0683918669131238	0.564784880289792	0.564732840365911	false	false	false	true
2ce09c94-b4fe-4c46-9342-d029ddbaadea	2026-09-04 11:31	2026-09-04 11:31	2026-09-04 11:31	SNOW	SNOW260911C00350000	call	350.0000	2026-09-11	7.0000	6.5500	7.0000	347.3200	135800.00	135800.00	0.00	194	5	1330	872	1.52522935779817	0.423540386389066	0.423540386389066	false	false	false	true
72cf8ee4-d2cc-4b97-a93b-39e0da34b58c	2026-09-04 11:03	2026-09-04 11:03	2026-09-04 11:03	SNOW	SNOW260904C00320000	call	320.0000	2026-09-04	29.8000	28.5500	30.9000	349.9300	98340.00	35760.00	26820.00	33	16	230	653	0.352220520673813	1.23895374015164	1.23895374015164	false	false	false	true
6bbdb74d-36de-4c16-a971-cda1c9152d7e	2026-09-04 11:03	2026-09-04 11:03	2026-09-04 11:03	SNOW	SNOW260904C00320000	call	320.0000	2026-09-04	29.7500	28.3500	30.1000	349.9200	199325.00	151725.00	47600.00	67	9	197	653	0.301684532924962	1.55396735666016	1.97859583593333	false	false	false	true
6b96cda2-8674-4986-b5f2-c12e4348aa18	2026-09-04 10:42	2026-09-04 10:42	2026-09-04 10:42	SNOW	SNOW260904C00330000	call	330.0000	2026-09-04	21.8500	21.1000	22.3750	351.8600	137655.00	137655.00	0.00	63	6	260	954	0.272536687631027	1.81027348486453	1.81027348486453	false	false	false	true
b193878a-2d66-4576-ae90-e5582d17e625	2026-09-04 10:42	2026-09-04 10:41	2026-09-04 10:41	SNOW	SNOW260904C00320000	call	320.0000	2026-09-04	31.7000	29.2000	31.7000	351.9900	72910.00	22190.00	0.00	23	14	110	653	0.168453292496172	1.27865087792848	1.27865087792848	false	false	false	true
fe66a3a5-fe74-4059-b109-15e8e03965b8	2026-09-04 10:01	2026-09-04 10:01	2026-09-04 10:01	SNOW	SNOW260911C00355000	call	355.0000	2026-09-11	5.3000	5.3000	5.6500	347.0700	265000.00	0.00	265000.00	500	8	627	5496	0.114082969432314	0.443477009901915	0.443477009901915	true	false	false	true
ad5945f6-6b83-4d1c-9aaa-a071843ddc00	2026-09-04 10:01	2026-09-04 10:01	2026-09-04 10:01	SNOW	SNOW261016P00370000	put	370.0000	2026-10-16	33.6500	33.0500	33.6500	346.4700	50475.00	50475.00	0.00	15	9	57	760	0.075	0.433100114931739	0.433100114931739	true	false	false	true
4cc942b7-0985-4acc-b439-d962513119f9	2026-09-04 10:00	2026-09-04 10:00	2026-09-04 10:00	SNOW	SNOW261120C00320000	call	320.0000	2026-11-20	44.4000	42.8000	44.8000	346.4300	84360.00	84360.00	0.00	19	9	30	314	0.0955414012738854	0.455547692829546	0.452768389296393	true	false	false	true
e66275c9-bcf1-4069-b9a0-d835110114d1	2026-09-04 10:00	2026-09-04 10:00	2026-09-04 10:00	SNOW	SNOW261016P00350000	put	350.0000	2026-10-16	21.4500	21.4500	21.6000	346.0300	83655.00	0.00	83655.00	39	14	55	765	0.0718954248366013	0.43085913661379	0.43085913661379	true	false	false	true
8baebe6b-a20a-4466-8ada-6bbb37de86a0	2026-09-04 10:00	2026-09-04 09:59	2026-09-04 09:59	SNOW	SNOW260911C00350000	call	350.0000	2026-09-11	6.6300	6.3000	6.9500	346.0000	96798.00	49062.00	47736.00	146	7	491	872	0.563073394495413	0.435505020062061	0.435505020062061	false	false	false	true
2748aadc-6b3c-4b7d-96bd-e1e0a24bcdf8	2026-09-04 09:55	2026-09-04 09:55	2026-09-04 09:55	SNOW	SNOW261002C00355000	call	355.0000	2026-10-02	13.1000	12.2000	15.1000	345.8000	64195.00	1315.00	62880.00	49	7	63	28	2.25	0.436556078483735	0.436556078483735	true	false	false	true
aab2a167-551b-493d-a124-e56021702e55	2026-09-04 09:50	2026-09-04 09:50	2026-09-04 09:50	SNOW	SNOW271217C00450000	call	450.0000	2027-12-17	62.0000	60.0500	63.5000	348.2100	217000.00	37200.00	179800.00	35	6	35	927	0.0377562028047465	0.558308261753292	0.558308261753292	false	false	false	true
62ce6464-04ec-4ef7-bccd-2e9d2a649947	2026-09-04 09:35	2026-09-04 09:35	2026-09-04 09:35	SNOW	SNOW260904P00347500	put	347.5000	2026-09-04	3.6500	3.0000	3.6500	349.7050	73000.00	73000.00	0.00	200	5	264	279	0.946236559139785	1.24269774190233	1.24269774190233	false	false	false	true
675c4e34-302b-439b-81c6-3db33f9183f3	2026-09-03 15:49	2026-09-03 15:49	2026-09-03 15:49	SNOW	SNOW260911C00317500	call	317.5000	2026-09-11	42.0000	42.0000	44.7500	358.6800	71400.00	0.00	71400.00	17	10	58	77	0.753246753246753	0.509562346479673	0.509562346479673	false	false	false	true
e587dbf8-9e9a-4671-ad73-046abd72f693	2026-09-03 15:43	2026-09-03 15:43	2026-09-03 15:43	SNOW	SNOW270917P00340000	put	340.0000	2027-09-17	60.5000	57.0000	60.5000	359.4600	102850.00	102850.00	0.00	17	6	30	40	0.75	0.558358663636619	0.558358663636619	false	false	false	true
e8d576ad-3802-495f-a1f2-4672e2dbd146	2026-09-03 15:42	2026-09-03 15:42	2026-09-03 15:42	SNOW	SNOW270219P00410000	put	410.0000	2027-02-19	76.5000	72.7000	77.3500	359.6850	122400.00	122400.00	0.00	16	5	19	4	4.75	0.50906633749539	0.50906633749539	false	false	false	true
035980c3-582d-4a61-9a7b-d6123a4dac54	2026-09-03 15:37	2026-09-03 15:37	2026-09-03 15:37	SNOW	SNOW260904C00360000	call	360.0000	2026-09-04	5.8500	5.8500	6.2000	361.1250	184279.00	0.00	184279.00	315	7	3466	2356	1.47113752122241	0.697119529613195	0.697119529613195	false	false	false	true
875a8e8c-fe54-44b8-a729-246a1a1984e6	2026-09-03 15:23	2026-09-03 15:23	2026-09-03 15:23	SNOW	SNOW260904C00330000	call	330.0000	2026-09-04	31.9100	31.9000	32.4500	361.8150	57438.00	0.00	57438.00	18	6	1079	1513	0.713152676801058	0.783220580578114	0.783220580578114	false	false	false	true
cc8fb6af-0e2d-484c-8c88-7400e2a7c83a	2026-09-03 15:20	2026-09-03 15:20	2026-09-03 15:20	SNOW	SNOW260904C00315000	call	315.0000	2026-09-04	47.8300	45.3500	47.8500	361.0000	196095.00	196095.00	0.00	41	6	409	4151	0.0985304745844375	2.07157452463997	2.07157452463997	false	false	false	true
f9ae294f-74ba-4b45-afb2-adae142c37ff	2026-09-03 15:02	2026-09-03 15:02	2026-09-03 15:02	SNOW	SNOW260904C00360000	call	360.0000	2026-09-04	6.3000	6.3000	6.6500	360.8525	53552.00	0.00	53552.00	85	17	2917	2356	1.23811544991511	0.776584197124884	0.776584197124884	false	false	false	true
12defc3e-b263-4686-a8ef-10825f389583	2026-09-03 14:55	2026-09-03 14:55	2026-09-03 14:55	SNOW	SNOW260904C00370000	call	370.0000	2026-09-04	3.2000	3.1000	3.2000	363.9489	127360.00	127360.00	0.00	398	12	7543	2909	2.59298728085253	0.745191020219428	0.745191020219428	true	false	false	true
352abbd0-4fc2-4ca0-a15b-e2ef4862d4fd	2026-09-03 14:14	2026-09-03 14:14	2026-09-03 14:14	SNOW	SNOW260904C00365000	call	365.0000	2026-09-04	7.5000	7.5000	8.0000	368.3100	187500.00	0.00	187500.00	250	8	2768	747	3.70548862115127	0.740549292822235	0.740549292822235	false	false	false	true
58416553-0956-4939-bf9f-77f5286b901d	2026-09-03 13:57	2026-09-03 13:57	2026-09-03 13:57	SNOW	SNOW260904C00370000	call	370.0000	2026-09-04	4.8500	4.8500	5.1500	367.8600	139680.00	0.00	139680.00	288	19	5772	2909	1.98418700584393	0.758224430579091	0.758224430579091	false	false	false	true
1123ad62-8a40-4621-9d44-5c56e642c729	2026-09-03 13:54	2026-09-03 13:54	2026-09-03 13:54	SNOW	SNOW260918C00365000	call	365.0000	2026-09-18	16.1400	15.4000	16.8500	369.3000	69415.00	1585.00	67830.00	43	7	237	44	5.38636363636364	0.45688793835675	0.447443748011296	true	false	false	true