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:endpoint = /api/option-trades/flow-alerts×ticker = W×sorted by created_at ↑×

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

bc3e9825-8aec-4e6a-aedb-1f0d90eec475	2026-08-17 12:11	2026-08-17 12:11	2026-08-17 12:11	W	W271217P00070000	put	70.0000	2027-12-17	10.4000	10.3500	11.2000	101.4300	28080.00	0.00	28080.00	27	11	27	392	0.0688775510204082	0.64366735044351	0.645685081253612	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	12154609495.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
910c47d9-6ca1-4832-8c1c-65b4d80c2be8	2026-08-17 12:11	2026-08-17 12:11	2026-08-17 12:11	W	W271217P00070000	put	70.0000	2027-12-17	10.3500	10.3500	10.7500	101.5100	36225.00	0.00	36225.00	35	18	62	392	0.158163265306122	0.644473791390282	0.644473791390282	false	false	false	true
d781ca11-dcff-49ac-8ae6-4c4a005aabe2	2026-08-17 12:12	2026-08-17 12:12	2026-08-17 12:12	W	W280121P00072500	put	72.5000	2028-01-21	11.7500	11.7500	12.1000	101.5800	12925.00	0.00	12925.00	11	5	18	4	4.5	0.63854499112808	0.63854499112808	false	false	false	true
73308c15-5819-4e02-97d3-e709fec0e8cd	2026-08-17 12:12	2026-08-17 12:12	2026-08-17 12:12	W	W271217P00075000	put	75.0000	2027-12-17	12.3500	12.2500	13.3000	101.5450	18530.00	1230.00	17300.00	15	12	15	0	0	0.640878111348789	0.642417444236874	false	false	false	true
47d2da71-f257-4d89-8731-b3882d791bbf	2026-08-17 12:12	2026-08-17 12:12	2026-08-17 12:12	W	W271217P00070000	put	70.0000	2027-12-17	10.3500	10.3000	10.7000	101.5450	120100.00	33160.00	86940.00	116	19	236	392	0.602040816326531	0.644099596973807	0.644675119745066	false	false	false
50ce097c-8b1d-43a0-9181-889faf5153a3	2026-08-17 14:52	2026-08-17 14:52	2026-08-17 14:52	W	W260911C00112000	call	112.0000	2026-09-11	2.7400	2.4500	2.7400	103.2600	46854.00	46854.00	0.00	171	21	171	0	0	0.539758079002785	0.539758079002785	false	false	false	true
3630667c-40ed-4ca0-aa1c-20133afbc90c	2026-08-17 14:57	2026-08-17 14:57	2026-08-17 14:57	W	W270115P00085000	put	85.0000	2027-01-15	6.3500	6.0500	6.5500	103.1200	13335.00	635.00	12700.00	21	6	42	114	0.368421052631579	0.589590684529323	0.589590684529323	false	false	false	true
3d87b2a2-c8bf-4c2d-b03c-262d892aae29	2026-08-18 09:59	2026-08-18 09:59	2026-08-18 09:59	W	W260821C00102000	call	102.0000	2026-08-21	1.8700	1.8700	2.1700	100.7200	11595.00	0.00	11595.00	62	18	101	1002	0.100798403193613	0.666760633018237	0.666760633018237	true	false	false	true
254390d8-c67b-44a8-aff1-6f1e77b9324b	2026-08-18 10:45	2026-08-18 10:45	2026-08-18 10:45	W	W260904P00098000	put	98.0000	2026-09-04	2.8400	2.6300	2.8400	102.5300	17608.00	17608.00	0.00	62	23	62	19	3.26315789473684	0.560632881339256	0.560632881339256	false	false	false	true
accd530d-fe1f-4902-80fa-b38979a18436	2026-08-18 15:40	2026-08-18 15:40	2026-08-18 15:40	W	W260821C00100000	call	100.0000	2026-08-21	3.6500	3.6500	3.8000	102.4800	50010.00	0.00	50010.00	137	39	201	2508	0.0801435406698565	0.598046874596463	0.591971922480949	false	false	false
f4d88ee7-8778-4e18-9ff2-af4eb264c043	2026-08-19 09:31	2026-08-19 09:31	2026-08-19 09:31	W	W260918C00105000	call	105.0000	2026-09-18	6.7500	5.3500	7.2500	105.1500	37125.00	37125.00	0.00	55	5	55	2545	0.0216110019646365	0.550274186086598	0.543035936782041	false	false	false
c223a0f6-f81a-4a92-b99f-2885e10ec571	2026-08-19 09:45	2026-08-19 09:45	2026-08-19 09:45	W	W260821C00102000	call	102.0000	2026-08-21	5.0300	4.9000	5.4500	106.4100	30660.00	0.00	22590.00	61	7	224	955	0.23455497382199	0.719704741884179	0.674008436881976	false	false	false	true
d243459f-2ed8-4f90-a2ef-94d9b02dc040	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	W	W260918C00105000	call	105.0000	2026-09-18	7.7500	7.3000	8.0000	107.1400	24805.00	13950.00	10855.00	32	6	193	2545	0.0758349705304519	0.542717660004585	0.536572232772219	true	false	false
2fb847aa-01a1-46dc-86ee-55aa2adfc3ac	2026-08-19 10:34	2026-08-19 10:34	2026-08-19 10:34	W	W260828C00102000	call	102.0000	2026-08-28	7.0000	5.6000	8.0000	107.1400	63000.00	51800.00	11200.00	90	13	92	104	0.884615384615385	0.57693746200554	0.584685917611837	false	false	false
79c8632c-02da-44f4-bf9a-926e8219788e	2026-08-19 12:00	2026-08-19 12:00	2026-08-19 12:00	W	W260821C00102000	call	102.0000	2026-08-21	5.2000	4.8000	5.5000	106.6700	187200.00	520.00	186680.00	360	7	696	955	0.728795811518325	0.668003606147427	0.668003606147427	false	false	false
81c9c92d-93da-45e2-84cf-3496905ab9bb	2026-08-20 09:46	2026-08-20 09:46	2026-08-20 09:46	W	W270115C00105000	call	105.0000	2027-01-15	17.3000	17.3000	17.8500	107.2300	437690.00	0.00	176460.00	253	7	253	8204	0.0308386153096051	0.574333983210978	0.574333983210978	true	false	false
e2e8152d-c492-4575-9904-278549b62e8c	2026-08-20 09:47	2026-08-20 09:46	2026-08-20 09:46	W	W270115C00105000	call	105.0000	2027-01-15	17.2000	16.7500	17.6500	106.9100	302720.00	211560.00	0.00	176	5	897	8204	0.109336908824963	0.577978315890069	0.577978315890069	false	false	false
cc7ac452-7fc2-4c23-b394-3cb970285976	2026-08-20 09:47	2026-08-20 09:46	2026-08-20 09:46	W	W270115C00105000	call	105.0000	2027-01-15	17.4000	17.3000	17.6500	107.2100	480240.00	234900.00	245340.00	276	6	529	8204	0.0644807411019015	0.578624256901381	0.578624256901381	false	false	false
8bc5e4ff-8ed8-4382-9842-1fda3731a07e	2026-08-20 09:47	2026-08-20 09:46	2026-08-20 09:46	W	W270115C00105000	call	105.0000	2027-01-15	17.1000	16.7500	17.7000	106.9100	328320.00	169290.00	1710.00	192	7	721	8204	0.0878839590443686	0.572523055152028	0.574153227460617	false	false	false
53034c16-17ea-4e8f-ba79-d8d68fd25035	2026-08-20 09:47	2026-08-20 09:46	2026-08-20 09:46	W	W270115C00105000	call	105.0000	2027-01-15	17.0000	16.9500	17.6000	106.9050	402900.00	86700.00	130900.00	237	6	1299	8204	0.158337396392004	0.57044510196955	0.57044510196955	false	false	false
5296268d-9ddf-4f86-9ac6-ff5b85022b5e	2026-08-20 09:47	2026-08-20 09:46	2026-08-20 09:46	W	W270115C00105000	call	105.0000	2027-01-15	17.1500	16.9500	17.6000	106.9100	282985.00	248690.00	34295.00	165	8	1062	8204	0.129449049244271	0.581337894852046	0.576065692154718	false	false	false
0c22486d-893b-4076-964c-c73eab9cfa59	2026-08-20 09:47	2026-08-20 09:46	2026-08-20 09:46	W	W270115C00105000	call	105.0000	2027-01-15	17.0000	16.9000	17.7000	107.1700	351940.00	20460.00	323005.00	207	19	1506	8204	0.183568990736226	0.569630647150621	0.564270738771228	false	false	false
40022883-1dbe-449d-a809-f761bea8f92c	2026-08-20 09:47	2026-08-20 09:47	2026-08-20 09:47	W	W270115C00105000	call	105.0000	2027-01-15	17.0000	16.8500	17.6500	107.1600	47600.00	42500.00	5100.00	28	5	1592	8204	0.19405168210629	0.56450406419658	0.56450406419658	false	false	false
ebede24b-80d0-4c18-b040-c0287878fec7	2026-08-20 10:16	2026-08-20 10:16	2026-08-20 10:16	W	W260918P00105000	put	105.0000	2026-09-18	5.5500	5.5500	5.9000	106.0600	31080.00	0.00	31080.00	56	11	56	502	0.111553784860558	0.524808932277476	0.524808932277476	false	false	false	true
29a0f1e5-4972-40eb-b5d3-f8c524e3598c	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	W	W261120C00110000	call	110.0000	2026-11-20	11.2000	11.2000	11.3500	105.1891	10080.00	0.00	10080.00	9	9	15	358	0.0418994413407821	0.607955809932273	0.607955809932273	true	false	false
0bdc9d4d-610c-4e5f-8e0d-67fcc2e3bef4	2026-08-20 10:41	2026-08-20 10:41	2026-08-20 10:41	W	W261120C00110000	call	110.0000	2026-11-20	11.0000	11.0000	11.1500	104.8300	14300.00	0.00	14300.00	13	10	35	358	0.0977653631284916	0.607203525715957	0.607203525715957	false	false	false
a1c3340c-a39d-4290-968b-b6f492d6badb	2026-08-20 10:55	2026-08-20 10:55	2026-08-20 10:55	W	W261120P00110000	put	110.0000	2026-11-20	14.9000	14.9000	15.2500	105.4800	11920.00	0.00	11920.00	8	6	35	469	0.0746268656716418	0.612700722391138	0.612700722391138	false	false	false	true
49d6a5e2-bc21-4ce3-8d2a-fb5c70b2c6c2	2026-08-20 13:53	2026-08-20 13:53	2026-08-20 13:53	W	W261218P00105000	put	105.0000	2026-12-18	14.1500	14.1500	14.5000	102.7250	12735.00	0.00	12735.00	9	6	15	37	0.405405405405405	0.58189994566731	0.58189994566731	false	false	false	true
07cddcd1-2d9f-4f63-b797-6f64fcbd141a	2026-08-20 14:09	2026-08-20 14:09	2026-08-20 14:09	W	W261016C00115000	call	115.0000	2026-10-16	4.1000	4.1000	4.3500	102.4700	62320.00	0.00	62320.00	152	7	152	0	0	0.515297098963439	0.515297098963439	false	false	false	true
32fdf4c2-8538-4634-9d7b-108b8913d2cc	2026-08-20 14:41	2026-08-20 14:41	2026-08-20 14:41	W	W260828C00103000	call	103.0000	2026-08-28	3.0500	3.0500	3.1500	101.9050	10065.00	0.00	10065.00	33	19	273	18	15.1666666666667	0.5841302288477	0.5841302288477	false	false	false	true
771642e6-3b65-469a-a704-03485ef1abd5	2026-08-20 14:54	2026-08-20 14:54	2026-08-20 14:54	W	W261218P00105000	put	105.0000	2026-12-18	14.5500	14.5500	14.8500	102.2650	11640.00	0.00	11640.00	8	5	33	37	0.891891891891892	0.590272724430596	0.590272724430596	false	false	false	true
21dcbbb1-a21b-43cf-a456-bdfed35283bc	2026-08-21 10:09	2026-08-21 10:09	2026-08-21 10:09	W	W261218P00095000	put	95.0000	2026-12-18	9.7500	9.5000	9.7500	101.4800	38025.00	38025.00	0.00	39	11	39	192	0.203125	0.598221198492663	0.598221198492663	false	false	false	true
fbf9f621-0216-405d-8532-ffc41c493ffe	2026-08-21 10:30	2026-08-21 10:30	2026-08-21 10:30	W	W261120C00110000	call	110.0000	2026-11-20	9.3500	9.3500	9.7000	101.8200	10285.00	0.00	10285.00	11	6	11	415	0.0265060240963855	0.598367388738157	0.602322045570446	false	false	false	true
8f763dd4-0ff9-4a31-926a-faa3e6007ea5	2026-08-21 11:18	2026-08-21 11:17	2026-08-21 11:17	W	W261218P00087500	put	87.5000	2026-12-18	6.6000	6.5000	6.6500	101.4000	10560.00	10560.00	0.00	16	7	106	63	1.68253968253968	0.599012358237604	0.598734838685626	false	false	false	true
37229f89-3f3d-4e28-a967-91b3f8541ac3	2026-08-21 12:38	2026-08-21 12:38	2026-08-21 12:38	W	W270617P00082500	put	82.5000	2027-06-17	10.7200	10.7000	12.0000	101.6500	27864.00	0.00	27864.00	26	6	145	15	9.66666666666667	0.612083870500194	0.611382528715212	false	false	false	true
7a472c91-b398-4820-bf68-5d35b94ec16d	2026-08-21 12:39	2026-08-21 12:38	2026-08-21 12:38	W	W270617P00082500	put	82.5000	2027-06-17	10.8100	10.7000	12.0000	101.6500	25937.00	0.00	25937.00	24	7	169	15	11.2666666666667	0.615939651386709	0.613135713925079	true	false	false	true
45e5ad64-e9af-4621-ac26-a339b4883622	2026-08-21 14:50	2026-08-21 14:50	2026-08-21 14:50	W	W280121P00062500	put	62.5000	2028-01-21	8.0000	7.5000	9.3000	101.3200	39205.00	6400.00	32805.00	49	11	49	2	24.5	0.643103422094711	0.643103422094711	false	false	false	true
80edd023-1ffb-47b4-9eb5-b70e06e2fa9b	2026-08-21 15:19	2026-08-21 15:19	2026-08-21 15:19	W	W261016P00095000	put	95.0000	2026-10-16	4.9000	4.6500	4.9000	101.5900	32830.00	32830.00	0.00	67	18	69	13	5.30769230769231	0.521239942284297	0.521239942284297	false	false	false	true
8551c5d4-7775-498f-a0da-8a15c35fbe6b	2026-08-21 15:47	2026-08-21 15:46	2026-08-21 15:46	W	W260918C00120000	call	120.0000	2026-09-18	1.0200	1.0200	1.1000	101.5400	14688.00	0.00	14688.00	144	60	172	549	0.313296903460838	0.522344675946904	0.522344675946904	true	false	false
e13b7af1-91e2-4bc2-a4b0-a3cc221c3198	2026-08-21 15:58	2026-08-21 15:57	2026-08-21 15:57	W	W260828C00108000	call	108.0000	2026-08-28	0.8500	0.8500	0.9400	101.4200	12750.00	0.00	12750.00	150	15	151	74	2.04054054054054	0.530148380380438	0.530148380380438	false	false	false	true
87749e19-e53c-4cf4-a9e8-1c05664316d3	2026-08-24 10:25	2026-08-24 10:25	2026-08-24 10:25	W	W261120C00145000	call	145.0000	2026-11-20	2.3900	2.1700	2.3900	102.7600	52341.00	52341.00	0.00	219	34	219	412	0.531553398058252	0.610009373689654	0.610009373689654	false	false	false
9f3cd5cf-357b-4c13-9f2f-6b5b5a1af88e	2026-08-24 10:39	2026-08-24 10:39	2026-08-24 10:39	W	W261120C00110000	call	110.0000	2026-11-20	10.2500	10.2500	10.5000	103.8050	11275.00	0.00	11275.00	11	8	12	432	0.0277777777777778	0.610241718087582	0.610241718087582	false	false	false
26627663-2961-4303-9eff-f97e29fd68b0	2026-08-24 11:29	2026-08-24 11:29	2026-08-24 11:29	W	W261120C00145000	call	145.0000	2026-11-20	2.6400	2.4700	2.6400	103.3600	30888.00	30888.00	0.00	117	23	336	412	0.815533980582524	0.62140943366282	0.62140943366282	false	false	false	true
02f15098-dd7d-4826-91ed-a70973ac810b	2026-08-24 15:37	2026-08-24 15:37	2026-08-24 15:37	W	W261218C00140000	call	140.0000	2026-12-18	4.3000	4.0500	4.3000	103.6050	24068.00	24068.00	0.00	56	10	61	91	0.67032967032967	0.595263274767266	0.595263274767266	false	false	false	true
d58c1296-6e25-47bf-9108-f5006beb376d	2026-08-24 15:48	2026-08-24 15:48	2026-08-24 15:48	W	W260925P00090000	put	90.0000	2026-09-25	1.5000	1.3100	1.9300	103.7450	15000.00	9450.00	5550.00	100	7	102	7	14.5714285714286	0.537512765401846	0.537512765401846	false	false	false	true
bb004423-4c62-43a0-8ce3-1969fd3a6388	2026-08-24 15:49	2026-08-24 15:49	2026-08-24 15:49	W	W261016P00095000	put	95.0000	2026-10-16	4.2800	4.0000	4.3000	103.7800	68440.00	54160.00	14280.00	160	10	160	72	2.22222222222222	0.532591580680509	0.532591580680509	false	false	false	true
85edc560-3ae0-451b-8b0e-f8d090c5a486	2026-08-24 15:49	2026-08-24 15:49	2026-08-24 15:49	W	W261016P00097500	put	97.5000	2026-10-16	5.1700	5.0000	5.2000	103.8100	103440.00	77940.00	25500.00	200	13	203	0	0	0.529587277206441	0.529587277206441	false	false	false	true
83602d40-d842-4a80-9e7c-69192a294fa7	2026-08-25 10:15	2026-08-25 10:15	2026-08-25 10:15	W	W260904C00105000	call	105.0000	2026-09-04	3.6000	3.5500	4.8000	104.0750	43200.00	5400.00	32400.00	120	8	120	12	10	0.57922798064149	0.57922798064149	false	false	false	true
092c9af7-b10d-4386-9ffa-f40e9795c47f	2026-08-25 10:15	2026-08-25 10:15	2026-08-25 10:15	W	W260904C00105000	call	105.0000	2026-09-04	3.6500	3.6500	3.8000	104.2500	28835.00	0.00	28835.00	79	12	200	12	16.6666666666667	0.574030934576961	0.574030934576961	true	false	false	true
1a096aa6-706a-4fdd-b0ae-689fea895c00	2026-08-25 10:26	2026-08-25 10:26	2026-08-25 10:26	W	W260918C00110000	call	110.0000	2026-09-18	3.6000	3.5000	3.8000	104.5000	10440.00	0.00	8280.00	29	5	31	1274	0.0243328100470958	0.533960418648274	0.533960418648274	false	false	false	true