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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = WHR×

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

d59c886c-64d1-4bf7-b9d6-bf138f19b581	2026-09-09 10:43	2026-09-09 10:43	2026-09-09 10:43	WHR	WHR270115C00052500	call	52.5000	2027-01-15	1.1500	1.1000	1.4000	36.6650	14375.00	14260.00	115.00	125	19	125	290	0.431034482758621	0.569011540072996	0.569011540072996	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2216778852.00	2026-10-26	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6fd9b9d9-f21b-4f92-a235-fdf98600f82b	2026-09-09 10:06	2026-09-09 10:06	2026-09-09 10:06	WHR	WHR270115P00037500	put	37.5000	2027-01-15	4.7600	4.7000	5.1000	37.1450	476000.00	0.00	476000.00	1000	12	1000	834	1.19904076738609	0.552366489791555	0.552366489791555	false	true	true	false	false
ad92ed3f-de0f-44bb-b17a-62be1af554a0	2026-09-08 13:58	2026-09-08 13:57	2026-09-08 13:57	WHR	WHR261016C00042500	call	42.5000	2026-10-16	1.0500	1.0000	1.1500	38.2500	10500.00	9135.00	1365.00	100	7	120	127	0.94488188976378	0.501359443807977	0.501359443807977	false	false	false	true	false
3ade5e67-8e3e-4d5a-99e4-f4d2d61bdd5d	2026-09-04 13:42	2026-09-04 13:42	2026-09-04 13:42	WHR	WHR270115P00032500	put	32.5000	2027-01-15	1.9600	1.6000	2.0000	40.0100	37827.00	37827.00	0.00	193	6	236	698	0.33810888252149	0.577396341114425	0.575651554554355	false	false	false	true	false
ad614219-9af4-478e-9068-551a2f81526b	2026-09-03 11:44	2026-09-03 11:44	2026-09-03 11:44	WHR	WHR260918P00037500	put	37.5000	2026-09-18	1.0500	1.0000	1.0500	38.2700	36330.00	735.00	0.00	346	56	1390	2120	0.655660377358491	0.459493491656858	0.466076458705363	true	false	false	true	false
db2ab4b2-66f5-4269-98fe-f6c2cae1c284	2026-09-02 12:10	2026-09-02 12:10	2026-09-02 12:10	WHR	WHR261016C00040000	call	40.0000	2026-10-16	2.1500	2.1000	2.1500	38.7550	61695.00	61695.00	0.00	287	31	288	187	1.54010695187166	0.486765104900275	0.486765104900275	false	false	false	true	false
6f91d2bb-15fa-4b63-8c59-f23bdb0f4cd2	2026-09-01 15:21	2026-09-01 15:21	2026-09-01 15:21	WHR	WHR260918P00037500	put	37.5000	2026-09-18	1.1000	1.1000	1.4000	38.2600	11770.00	0.00	11770.00	107	10	416	2020	0.205940594059406	0.453442110335698	0.453442110335698	false	false	false	true	false
18856fc8-d9e8-47b7-b42b-0efdaf4920ee	2026-09-01 11:31	2026-09-01 11:31	2026-09-01 11:31	WHR	WHR260918P00037500	put	37.5000	2026-09-18	0.9500	0.9000	0.9500	38.8950	13585.00	13585.00	0.00	143	12	203	2020	0.100495049504951	0.479375535974712	0.479375535974712	false	false	false	true	false
a801ac26-8058-43a3-ac4c-0e22d3d087a1	2026-08-31 14:01	2026-08-31 14:01	2026-08-31 14:01	WHR	WHR270917C00092500	call	92.5000	2027-09-17	1.3500	0.1000	3.3000	40.0000	21195.00	1485.00	19710.00	157	9	157	17	9.23529411764706	0.557625261416537	0.557625261416537	false	false	false	true	false
0bbcab89-a97f-4994-aeec-e71ea78bbacf	2026-08-31 13:27	2026-08-31 13:27	2026-08-31 13:27	WHR	WHR260918P00037500	put	37.5000	2026-09-18	0.5000	0.5000	0.6500	40.6400	15000.00	0.00	15000.00	300	6	307	1657	0.185274592637296	0.470450408019199	0.470450408019199	false	false	false	true	false
d086acd4-618c-4914-8071-712c424d40f6	2026-08-28 14:49	2026-08-28 14:49	2026-08-28 14:49	WHR	WHR260918P00040000	put	40.0000	2026-09-18	1.3000	1.0000	1.4000	40.8950	11310.00	9750.00	1560.00	87	6	190	1360	0.139705882352941	0.452230370548081	0.452230370548081	false	false	false	true	false
7b5db522-852b-4e8d-ab8b-81a011f850db	2026-08-28 14:31	2026-08-28 14:31	2026-08-28 14:31	WHR	WHR281215P00020000	put	20.0000	2028-12-15	2.9000	2.4000	3.5000	40.7950	435000.00	0.00	435000.00	1500	1	1500	127	11.8110236220472	0.650660466180788	0.650660466180788	false	true	false	true	true
6a75d551-09e8-4231-8113-f9747e010bad	2026-08-27 11:07	2026-08-27 11:07	2026-08-27 11:07	WHR	WHR260918C00040000	call	40.0000	2026-09-18	1.7000	1.6500	1.8000	39.5200	43520.00	1360.00	42160.00	256	14	265	844	0.313981042654028	0.485695942865832	0.485695942865832	false	false	false	true	false
34009c81-767b-4653-b8c0-223a005a99c3	2026-08-27 10:08	2026-08-27 10:08	2026-08-27 10:08	WHR	WHR260918P00035000	put	35.0000	2026-09-18	0.3500	0.3500	0.5000	39.6000	10500.00	0.00	10500.00	300	7	900	1840	0.489130434782609	0.494163402254698	0.494163402254698	false	false	false	true	false
44d2cfa8-93a0-4b15-868c-7e9591b297fb	2026-08-25 15:08	2026-08-25 15:08	2026-08-25 15:08	WHR	WHR281215C00035000	call	35.0000	2028-12-15	19.0200	18.5000	19.3000	40.6900	114100.00	57400.00	56700.00	60	6	192	172	1.11627906976744	0.67898372561861	0.66695469749857	false	false	false	true	false
497758ad-8344-4404-b6ab-391d510acc7d	2026-08-25 13:50	2026-08-25 13:50	2026-08-25 13:50	WHR	WHR261016C00050000	call	50.0000	2026-10-16	0.5500	0.5500	0.7000	40.6500	11000.00	0.00	11000.00	200	14	296	18	16.4444444444444	0.481787351185562	0.481787351185562	false	false	false	true	false
a7a42eb5-edbe-44b3-ba1e-01e610b429f6	2026-08-25 13:49	2026-08-25 13:49	2026-08-25 13:49	WHR	WHR261120C00042500	call	42.5000	2026-11-20	4.1000	4.0000	4.2000	40.7500	13940.00	0.00	12710.00	34	8	45	187	0.240641711229947	0.590609699549869	0.590609699549869	false	false	false	true	false
aaaf424f-6843-4412-b1a0-32b61b349054	2026-08-25 11:21	2026-08-25 11:21	2026-08-25 11:21	WHR	WHR270115P00042500	put	42.5000	2027-01-15	6.6000	6.6000	6.8000	40.2550	1320000.00	0.00	1320000.00	2000	2	2002	176	11.375	0.56588748347752	0.56588748347752	false	true	true	false	true
8b2189ae-2862-44ea-a2c0-4eb5d2dc8029	2026-08-24 09:41	2026-08-24 09:41	2026-08-24 09:41	WHR	WHR261120C00052500	call	52.5000	2026-11-20	1.2000	1.0500	1.2000	39.9300	10680.00	10680.00	0.00	89	56	92	265	0.347169811320755	0.574797416976472	0.574797416976472	true	false	false	true	false
ab1006ba-9179-428c-ab1e-3fac16f9c850	2026-08-21 14:53	2026-08-21 14:53	2026-08-21 14:53	WHR	WHR270319P00040000	put	40.0000	2027-03-19	6.5000	5.9000	6.5000	40.7500	27300.00	27300.00	0.00	42	12	87	362	0.240331491712707	0.609681672765219	0.609681672765219	false	false	false	true	false
d1454ced-f779-424b-afa2-78a91e85ae3b	2026-08-21 12:47	2026-08-21 12:47	2026-08-21 12:47	WHR	WHR270115P00045000	put	45.0000	2027-01-15	7.8000	7.7000	8.0000	41.3700	14820.00	14040.00	780.00	19	15	20	517	0.0386847195357834	0.578020174156028	0.578020174156028	false	false	false	true	false
df14d791-6055-410a-a39b-a8e848ecc740	2026-08-20 11:53	2026-08-20 11:53	2026-08-20 11:53	WHR	WHR270319P00035000	put	35.0000	2027-03-19	4.1000	4.0000	4.5000	40.1600	42230.00	1640.00	40590.00	103	34	287	49	5.85714285714286	0.596909402195552	0.596909402195552	false	false	false	true	false
fa509c06-f752-4574-8385-54212a4f7b7e	2026-08-20 11:53	2026-08-20 11:52	2026-08-20 11:52	WHR	WHR270319P00035000	put	35.0000	2027-03-19	4.1000	4.1000	4.5000	40.1400	20500.00	0.00	20500.00	50	12	101	49	2.06122448979592	0.596090500399452	0.596363618848958	false	false	false	true	false
b108338a-8537-466a-89e7-a06689daf276	2026-08-20 11:53	2026-08-20 11:53	2026-08-20 11:53	WHR	WHR270319P00035000	put	35.0000	2027-03-19	4.1000	4.0000	4.5000	40.1600	33210.00	6970.00	26240.00	81	13	182	49	3.71428571428571	0.596363618848958	0.596909402195552	false	false	false	true	false
0f989bf4-099c-457d-b904-b3cf3c8cd202	2026-08-20 11:53	2026-08-20 11:52	2026-08-20 11:52	WHR	WHR270319P00035000	put	35.0000	2027-03-19	4.1000	4.0000	4.6000	40.1350	20500.00	0.00	20500.00	50	16	51	49	1.04081632653061	0.596090500399452	0.596227078542577	false	false	false	true	false
319eba79-0e93-48e5-989f-068e71b39524	2026-08-19 15:59	2026-08-19 15:59	2026-08-19 15:59	WHR	WHR261218P00040000	put	40.0000	2026-12-18	4.9000	4.4000	4.9000	40.1000	19109.00	19109.00	0.00	39	6	366	2014	0.181727904667329	0.570818189161294	0.570818189161294	false	false	false	true	false
cc8079c2-3967-4663-9739-e747e926825e	2026-08-19 15:58	2026-08-19 15:58	2026-08-19 15:58	WHR	WHR260918P00040000	put	40.0000	2026-09-18	2.1700	2.0500	2.2000	40.1600	31045.00	31045.00	0.00	143	9	302	828	0.364734299516908	0.500594110606688	0.511560312817735	false	false	false	true	false
4a520514-42aa-4247-b6c2-190fdaafc431	2026-08-19 10:14	2026-08-19 10:13	2026-08-19 10:13	WHR	WHR281215P00020000	put	20.0000	2028-12-15	2.8500	2.1000	5.1000	40.8900	28500.00	285.00	25365.00	100	32	100	29	3.44827586206897	0.643790008055674	0.643790008055674	false	false	false	true	false
529b8e7b-25dc-469e-9a01-26abb803a451	2026-08-18 11:11	2026-08-18 11:11	2026-08-18 11:11	WHR	WHR260821C00037500	call	37.5000	2026-08-21	2.6000	2.6000	2.8000	40.0500	219191.00	0.00	219191.00	843	54	843	537	1.56983240223464	0.458538148827988	0.458538148827988	false	false	false	true	false
f386da0e-0ead-4f0e-bc85-c7fc777d4bf4	2026-08-18 11:04	2026-08-18 11:04	2026-08-18 11:04	WHR	WHR281215C00060000	call	60.0000	2028-12-15	10.3000	9.4000	10.3000	40.0750	10300.00	1030.00	0.00	10	10	11	1186	0.00927487352445194	0.597823680296165	0.597823680296165	false	false	false	true	false
33495725-2617-4bac-a734-1193d2733328	2026-08-18 10:39	2026-08-18 10:39	2026-08-18 10:39	WHR	WHR281215C00045000	call	45.0000	2028-12-15	13.8000	13.8000	16.2000	39.9500	27600.00	0.00	22080.00	20	8	20	9	2.22222222222222	0.599003746930848	0.599003746930848	false	false	false	true	false
a5d97fa9-57a5-4ffc-b9fe-66e69b4566a2	2026-08-17 10:01	2026-08-17 10:01	2026-08-17 10:01	WHR	WHR261120C00045000	call	45.0000	2026-11-20	3.0000	2.9500	3.3000	39.6900	13792.00	6000.00	2392.00	46	8	105	522	0.201149425287356	0.592193697256034	0.593464960721389	false	false	false	true	false