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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×er_time = unknown×ticker = WSM×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

249d059d-7eb7-44d1-972a-160cf2573358	2026-09-23 13:35	2026-09-23 13:35	2026-09-23 13:35	WSM	WSM270115C00280000	call	280.0000	2027-01-15	5.0000	5.0000	6.8000	228.4450	11500.00	0.00	11500.00	23	7	25	159	0.157232704402516	0.369601539907725	0.369601539907725	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	26833628985.00	2026-11-18	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T17:39:01.188751Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
74633620-6889-47d3-839a-e8e783e2029c	2026-09-18 14:37	2026-09-18 14:37	2026-09-18 14:37	WSM	WSM261016P00210000	put	210.0000	2026-10-16	4.1000	3.7000	4.1000	222.0700	40180.00	40180.00	0.00	98	26	98	627	0.156299840510367	0.380960719911071	0.380960719911071	false	false	false	true
782d8969-6978-4aca-8f2b-7eb30ae63abb	2026-09-17 13:59	2026-09-17 13:59	2026-09-17 13:59	WSM	WSM261218P00200000	put	200.0000	2026-12-18	8.9000	8.6000	8.9000	220.3250	30260.00	30260.00	0.00	34	19	34	43	0.790697674418605	0.429470010812645	0.429470010812645	false	false	false	true
dc91e928-ea03-4b40-bb6c-ca8354e1cc82	2026-09-11 15:28	2026-09-11 15:27	2026-09-11 15:27	WSM	WSM270115C00230000	call	230.0000	2027-01-15	20.0000	19.2000	20.0000	226.4200	108000.00	108000.00	0.00	54	19	54	41	1.31707317073171	0.380815798256016	0.380815798256016	false	false	false	true
49a122f5-791d-4882-8e0f-52f60b86d31e	2026-09-08 10:53	2026-09-08 10:53	2026-09-08 10:53	WSM	WSM261218C00260000	call	260.0000	2026-12-18	8.3000	8.0000	8.5000	228.3950	64740.00	63080.00	1660.00	78	24	78	194	0.402061855670103	0.381361571497295	0.381361571497295	false	false	false	true
529e321b-e1db-40c7-8a85-d5584268143c	2026-09-03 14:47	2026-09-03 14:47	2026-09-03 14:47	WSM	WSM261218C00230000	call	230.0000	2026-12-18	15.4000	14.5000	15.4000	221.3400	161700.00	161700.00	0.00	105	9	105	60	1.75	0.378846981151666	0.378846981151666	false	false	false	true
839fd216-719e-4d3f-bbf0-63d994a83668	2026-09-03 12:50	2026-09-03 12:50	2026-09-03 12:50	WSM	WSM261120C00250000	call	250.0000	2026-11-20	6.3000	5.9000	6.3000	221.5631	39690.00	39690.00	0.00	63	20	67	34	1.97058823529412	0.374489831287835	0.374489831287835	false	false	false	true
bac7b965-e1f3-4a62-bfe7-30e76a6a043f	2026-09-02 13:44	2026-09-02 13:44	2026-09-02 13:44	WSM	WSM261120P00240000	put	240.0000	2026-11-20	25.6000	24.8000	25.6000	222.8850	153600.00	153600.00	0.00	60	24	60	29	2.06896551724138	0.398253476543715	0.398253476543715	false	false	false	true
b4c13225-0d7c-46b6-aecf-ff3e2fd4517e	2026-09-01 11:29	2026-09-01 11:29	2026-09-01 11:29	WSM	WSM261218C00260000	call	260.0000	2026-12-18	6.6000	6.1000	6.6000	222.0800	64020.00	64020.00	0.00	97	12	100	85	1.17647058823529	0.370910059781599	0.370910059781599	false	false	false	true
38b69b75-4c9a-41cb-a255-11b3365fb39d	2026-08-28 13:03	2026-08-28 13:03	2026-08-28 13:03	WSM	WSM261120P00195000	put	195.0000	2026-11-20	4.0000	4.0000	4.5000	232.8200	25600.00	0.00	25600.00	64	21	64	24	2.66666666666667	0.416316801426616	0.416316801426616	false	false	false	true
09722db9-be39-4315-a46b-348db81e3619	2026-08-28 10:31	2026-08-28 10:31	2026-08-28 10:31	WSM	WSM261218P00220000	put	220.0000	2026-12-18	12.5000	12.5000	13.6000	232.7950	28750.00	0.00	27500.00	23	7	23	23	1	0.387396344576604	0.387396344576604	false	false	false	true
477eae6f-83c0-42dc-ab37-1c4612f48afb	2026-08-27 13:12	2026-08-27 13:12	2026-08-27 13:12	WSM	WSM261016C00250000	call	250.0000	2026-10-16	10.1000	9.6000	10.1000	244.1600	76760.00	76760.00	0.00	76	25	79	57	1.3859649122807	0.336848844915874	0.336848844915874	false	false	false	true
ba7749bc-30a4-4c18-bbef-8d551c055815	2026-08-27 11:13	2026-08-27 11:12	2026-08-27 11:12	WSM	WSM260918P00260000	put	260.0000	2026-09-18	18.0000	16.7000	18.0000	245.0100	421194.00	421194.00	0.00	234	29	234	126	1.85714285714286	0.365930609176737	0.365930609176737	false	false	false	true
33f5fadb-10c2-4b49-8751-94a78d275fb1	2026-08-26 12:39	2026-08-26 12:39	2026-08-26 12:39	WSM	WSM260918P00240000	put	240.0000	2026-09-18	10.6000	10.0000	10.6000	235.4950	108120.00	108120.00	0.00	102	28	117	781	0.149807938540333	0.357109398277477	0.357109398277477	false	false	false	true
94659bd2-b9ad-4ba9-9923-fbc3568da484	2026-08-26 11:22	2026-08-26 11:22	2026-08-26 11:22	WSM	WSM261120P00250000	put	250.0000	2026-11-20	26.5000	26.5000	27.8000	232.0400	31800.00	0.00	31800.00	12	7	12	19	0.631578947368421	0.378373239756002	0.378373239756002	true	false	false	true
09a2174b-51d6-45ab-ba1e-7d15bd757c5d	2026-08-25 15:34	2026-08-25 15:34	2026-08-25 15:34	WSM	WSM260918P00230000	put	230.0000	2026-09-18	10.0000	10.0000	10.2000	233.5200	12000.00	0.00	12000.00	12	5	587	345	1.70144927536232	0.504377273577947	0.504377273577947	false	false	false	true
d478a02d-74e5-4fb3-aa1d-e84fb72fb643	2026-08-25 14:40	2026-08-25 14:40	2026-08-25 14:40	WSM	WSM260918P00230000	put	230.0000	2026-09-18	9.6000	9.6000	10.0000	233.6900	41282.00	0.00	41282.00	43	17	458	345	1.32753623188406	0.490324418646395	0.490324418646395	false	false	false	true
676b6e45-6cca-4136-a9cb-168620e42ad4	2026-08-25 11:40	2026-08-25 11:39	2026-08-25 11:39	WSM	WSM260918P00230000	put	230.0000	2026-09-18	9.2000	8.1000	9.4000	236.2250	180318.00	164678.00	15640.00	196	50	206	345	0.597101449275362	0.516878702044112	0.516878702044112	true	false	false	true
5cfc9e01-0faa-498f-9550-ed13c1e9d214	2026-08-24 14:50	2026-08-24 14:49	2026-08-24 14:49	WSM	WSM260918P00240000	put	240.0000	2026-09-18	11.1000	11.1000	12.4000	239.8250	25530.00	0.00	25530.00	23	11	2128	1808	1.17699115044248	0.452891905229562	0.452891905229562	false	false	false	true
34b9d192-a604-4cd0-8c4a-e015272585cc	2026-08-24 14:29	2026-08-24 14:29	2026-08-24 14:29	WSM	WSM260918P00240000	put	240.0000	2026-09-18	12.4000	12.4000	14.4000	238.0800	54560.00	0.00	54560.00	44	7	1726	1808	0.954646017699115	0.471332271071015	0.471332271071015	false	false	false	true
999a3b22-4bb0-4216-8316-66a5bcc681c7	2026-08-24 14:11	2026-08-24 14:11	2026-08-24 14:11	WSM	WSM260918C00230000	call	230.0000	2026-09-18	16.8000	15.7000	16.8000	237.9400	10080.00	10080.00	0.00	6	6	26	886	0.0293453724604966	0.494432443341809	0.494432443341809	false	false	false	true
d5aff1d2-c377-4b69-80dc-f537a3b0b224	2026-08-24 13:07	2026-08-24 13:07	2026-08-24 13:07	WSM	WSM260918P00240000	put	240.0000	2026-09-18	12.0000	12.0000	13.5000	238.1150	67200.00	0.00	67200.00	56	5	1134	1808	0.627212389380531	0.455934270970967	0.455934270970967	false	false	false	true
2b029e6e-d64b-4610-836c-2116d5d864e7	2026-08-24 12:54	2026-08-24 12:54	2026-08-24 12:54	WSM	WSM260918P00240000	put	240.0000	2026-09-18	12.1000	12.1000	14.3000	238.1150	87121.00	0.00	87121.00	72	26	1047	1808	0.579092920353982	0.45995712403006	0.45995712403006	false	false	false	true
4bd34143-8dec-46b4-a6bd-82529461d158	2026-08-24 12:42	2026-08-24 12:41	2026-08-24 12:41	WSM	WSM260918P00240000	put	240.0000	2026-09-18	12.0000	12.0000	13.7000	238.5750	85200.00	0.00	85200.00	71	11	955	1808	0.52820796460177	0.464999622505404	0.464999622505404	false	false	false	true
492b0540-c17d-43b6-8e7e-84201b13256e	2026-08-24 12:09	2026-08-24 12:09	2026-08-24 12:09	WSM	WSM260918P00240000	put	240.0000	2026-09-18	11.5000	11.5000	14.1000	239.1500	89701.00	0.00	89701.00	78	21	757	1808	0.418694690265487	0.456080179353673	0.456080179353673	false	false	false	true
4b05e79b-5cf7-424f-a488-6c9724b356d7	2026-08-24 11:54	2026-08-24 11:54	2026-08-24 11:54	WSM	WSM260918P00240000	put	240.0000	2026-09-18	12.4000	12.3000	13.8000	239.0900	12400.00	0.00	12400.00	10	6	669	1808	0.370022123893805	0.491028329175146	0.491028329175146	false	false	false	true
679131f8-56dd-4198-8743-9f79553320b9	2026-08-24 11:54	2026-08-24 11:54	2026-08-24 11:54	WSM	WSM260918P00240000	put	240.0000	2026-09-18	12.0000	12.0000	13.8000	239.2400	81602.00	0.00	81602.00	68	20	649	1808	0.35896017699115	0.477856933113573	0.477856933113573	false	false	false	true
46d50d36-7a74-4f9d-aad5-e795c917a6ea	2026-08-24 11:40	2026-08-24 11:40	2026-08-24 11:40	WSM	WSM260918P00240000	put	240.0000	2026-09-18	11.8000	11.8000	14.3000	239.2100	76700.00	0.00	76700.00	65	13	539	1808	0.298119469026549	0.469262359371142	0.469262359371142	false	false	false	true
3c19a4cd-ec44-4837-8f29-26371130310f	2026-08-24 10:22	2026-08-24 10:22	2026-08-24 10:22	WSM	WSM260918P00240000	put	240.0000	2026-09-18	10.9000	10.9000	12.5000	241.5750	73030.00	0.00	73030.00	67	5	168	1808	0.0929203539823009	0.476953444204131	0.476953444204131	false	false	false	true
245ca38b-447f-4d5f-8d57-5ff546997bc6	2026-08-21 15:44	2026-08-21 15:44	2026-08-21 15:44	WSM	WSM261218P00220000	put	220.0000	2026-12-18	13.3000	13.3000	14.4000	237.9200	21280.00	0.00	21280.00	16	7	16	8	2	0.428074290685836	0.428074290685836	false	false	false	true
c6a7a392-d4c2-4a21-9b3f-9e6977402954	2026-08-21 12:47	2026-08-21 12:47	2026-08-21 12:47	WSM	WSM260918C00240000	call	240.0000	2026-09-18	10.5000	10.0000	10.5000	235.5950	11550.00	4200.00	0.00	11	9	251	437	0.574370709382151	0.467777349162541	0.467777349162541	false	false	false	true
c81c01b9-decb-493a-adcc-ce723c9c78fb	2026-08-21 12:47	2026-08-21 12:47	2026-08-21 12:47	WSM	WSM260918C00240000	call	240.0000	2026-09-18	10.8000	10.0000	10.8000	235.8950	52920.00	44280.00	0.00	49	19	240	437	0.549199084668192	0.473771253617039	0.473771253617039	false	false	false	true
8fc90ad6-9b88-4e27-a273-fda938935d23	2026-08-21 12:45	2026-08-21 12:44	2026-08-21 12:44	WSM	WSM260918C00240000	call	240.0000	2026-09-18	11.0000	9.7000	11.0000	236.0900	71500.00	66000.00	0.00	65	12	191	437	0.437070938215103	0.477823911168448	0.477823911168448	false	false	false	true
c707f1e0-bdb6-4887-bc9d-f77e63edc68c	2026-08-21 12:44	2026-08-21 12:44	2026-08-21 12:44	WSM	WSM260918C00240000	call	240.0000	2026-09-18	11.2000	10.8000	11.2000	236.5500	140000.00	5600.00	0.00	125	24	126	437	0.288329519450801	0.476876424082142	0.476876424082142	false	false	false	true
17756170-745e-4be2-9c61-8c944c398a96	2026-08-21 10:49	2026-08-21 10:49	2026-08-21 10:49	WSM	WSM261218C00300000	call	300.0000	2026-12-18	5.4000	4.4000	5.6000	236.7350	34560.00	34560.00	0.00	64	20	64	13	4.92307692307692	0.405452458725785	0.405452458725785	false	false	false	true
68285c4b-552a-4e7e-b1bd-14b39f902d38	2026-08-19 15:47	2026-08-19 15:47	2026-08-19 15:47	WSM	WSM260918C00240000	call	240.0000	2026-09-18	14.2000	13.8000	14.2000	241.2050	28400.00	28400.00	0.00	20	20	38	444	0.0855855855855856	0.480889931869442	0.480889931869442	true	false	false	true
cb1e179a-b948-4a8b-a9eb-c8d06962bef2	2026-08-18 15:24	2026-08-18 15:23	2026-08-18 15:23	WSM	WSM261120C00260000	call	260.0000	2026-11-20	14.4000	14.4000	15.0000	241.8000	252005.00	0.00	252005.00	175	36	176	9	19.5555555555556	0.42245609168153	0.42245609168153	false	false	false	true
3e511eb1-7f75-45aa-a6d3-b538252408fe	2026-08-18 10:15	2026-08-18 10:14	2026-08-18 10:14	WSM	WSM260918P00240000	put	240.0000	2026-09-18	11.4100	11.3000	11.5000	242.9250	38800.00	18460.00	20340.00	34	7	35	1812	0.0193156732891832	0.473804836422926	0.473804836422926	true	false	false	true
05e7e021-f3a3-4334-9ac2-b45928a87af6	2026-08-18 10:14	2026-08-18 10:14	2026-08-18 10:14	WSM	WSM260821P00240000	put	240.0000	2026-08-21	2.5500	1.8500	2.5500	243.1750	119085.00	119085.00	0.00	467	45	470	817	0.575275397796818	0.453862419731527	0.453862419731527	false	false	false	true