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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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 = WHR×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

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	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	2216778852.00	2026-10-26	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
c18c9cde-99a1-4ed5-af47-a58dddb40ca3	2026-09-09 12:07	2026-09-09 12:07	2026-09-09 12:07	WHR	WHR261120C00040000	call	40.0000	2026-11-20	2.4500	2.3500	2.4500	35.8967	132545.00	132545.00	0.00	541	31	626	961	0.651404786680541	0.609931386231275	0.609931386231275	false	false	false
10e4938c-2744-4a46-b570-32b71bd73304	2026-09-09 12:42	2026-09-09 12:42	2026-09-09 12:42	WHR	WHR270617C00032500	call	32.5000	2027-06-17	9.9000	9.2000	9.9000	36.0700	422730.00	422730.00	0.00	427	9	427	19	22.4736842105263	0.639673510727747	0.639673510727747	false	false	false
dbb10158-155c-4857-a4bf-02e245de0d39	2026-09-09 14:17	2026-09-09 14:17	2026-09-09 14:17	WHR	WHR270115C00050000	call	50.0000	2027-01-15	1.5000	1.5000	1.5500	36.5200	45150.00	0.00	45150.00	301	6	321	5610	0.0572192513368984	0.57827011556166	0.57827011556166	true	false	false
fcafa471-ecb7-4a54-9012-f9556e6c5355	2026-09-09 14:21	2026-09-09 14:20	2026-09-09 14:20	WHR	WHR270115C00050000	call	50.0000	2027-01-15	1.5500	1.4000	1.7500	36.5200	27590.00	16740.00	10850.00	178	7	599	5610	0.106773618538324	0.585687384730625	0.585687384730625	false	false	false
5c7401c6-5d15-4374-b4db-8221641312c0	2026-09-09 14:21	2026-09-09 14:20	2026-09-09 14:20	WHR	WHR270115C00050000	call	50.0000	2027-01-15	1.5500	1.4000	1.6000	36.5800	12865.00	12865.00	0.00	83	7	682	5610	0.12156862745098	0.583533504073264	0.583533504073264	false	false	false
4ffe37e2-b013-4988-978c-084efb9b47dc	2026-09-09 14:22	2026-09-09 14:22	2026-09-09 14:22	WHR	WHR270115C00050000	call	50.0000	2027-01-15	1.5500	1.4500	1.6000	36.7000	41075.00	41075.00	0.00	265	5	1298	5610	0.231372549019608	0.579232846994537	0.579232846994537	false	false	false
9cb4f98e-df23-43f2-ae60-333ac42166f3	2026-09-09 14:25	2026-09-09 14:24	2026-09-09 14:24	WHR	WHR270115C00050000	call	50.0000	2027-01-15	1.6000	1.5500	1.6500	36.6900	100800.00	100320.00	0.00	630	10	1928	5610	0.34367201426025	0.586893612574791	0.586893612574791	false	false	false
e74cc661-c689-4b4e-94e6-c99134f36c93	2026-09-09 14:35	2026-09-09 14:35	2026-09-09 14:35	WHR	WHR261016P00035000	put	35.0000	2026-10-16	1.5000	1.5000	1.6500	36.8000	150000.00	0.00	150000.00	1000	1	1320	1134	1.16402116402116	0.515460643905596	0.515460643905596	false	true	false
1df0de0b-8a8d-4957-8025-c3edea467295	2026-09-10 10:59	2026-09-10 10:59	2026-09-10 10:59	WHR	WHR270115C00047500	call	47.5000	2027-01-15	1.8500	1.7500	1.8500	36.0800	10175.00	10175.00	0.00	55	9	55	240	0.229166666666667	0.588592842215448	0.588592842215448	false	false	false
b52294be-292c-4523-96de-7e12caaa6aef	2026-09-10 11:12	2026-09-10 11:12	2026-09-10 11:12	WHR	WHR261016C00040000	call	40.0000	2026-10-16	1.0000	0.9500	1.0000	36.0400	10000.00	500.00	0.00	100	6	115	1497	0.0768203072812291	0.51555371483259	0.51555371483259	false	false	false
62713c84-7095-4b5f-979d-0ca55446ec1d	2026-09-10 11:50	2026-09-10 11:50	2026-09-10 11:50	WHR	WHR270115C00052500	call	52.5000	2027-01-15	1.1500	1.1000	1.2000	36.0850	20010.00	18860.00	0.00	174	10	274	414	0.661835748792271	0.589041786686163	0.589041786686163	false	false	false
e182cdf6-38ee-4992-bf1f-93c851ff75c5	2026-09-10 13:10	2026-09-10 13:10	2026-09-10 13:10	WHR	WHR270115P00040000	put	40.0000	2027-01-15	7.3000	7.2000	7.3000	35.6850	36500.00	36500.00	0.00	50	5	150	503	0.298210735586481	0.592274185604322	0.592274185604322	false	false	false
ad953ca5-859a-4301-96aa-e48ecf18f524	2026-09-10 14:21	2026-09-10 14:21	2026-09-10 14:21	WHR	WHR261016C00040000	call	40.0000	2026-10-16	0.9500	0.9000	0.9500	35.6100	20425.00	20425.00	0.00	215	26	398	1497	0.265865063460254	0.534706793803691	0.534706793803691	false	false	false
de800422-e845-4ce8-929a-8b39ded75027	2026-09-10 14:22	2026-09-10 14:22	2026-09-10 14:22	WHR	WHR270115C00045000	call	45.0000	2027-01-15	2.1500	1.6500	2.3000	35.6600	33110.00	8815.00	1720.00	154	30	169	480	0.352083333333333	0.5819162039094	0.5819162039094	true	false	false
9f2eb203-9d46-4674-b60b-c47d5793709b	2026-09-10 14:46	2026-09-10 14:46	2026-09-10 14:46	WHR	WHR261016C00040000	call	40.0000	2026-10-16	0.9500	0.9000	0.9500	35.5700	12540.00	12540.00	0.00	132	12	566	1497	0.378089512358049	0.537676829258859	0.537676829258859	false	false	false
c49524d8-af71-48a9-b1c7-018983240adb	2026-09-10 14:59	2026-09-10 14:59	2026-09-10 14:59	WHR	WHR261218P00032500	put	32.5000	2026-12-18	2.6600	2.6500	2.9000	35.7200	10640.00	0.00	10640.00	40	5	112	280	0.4	0.599926309849041	0.599926309849041	false	false	false	true
f510456d-bd90-4cc3-a5ab-8d62236cc8db	2026-09-10 15:22	2026-09-10 15:22	2026-09-10 15:22	WHR	WHR261218P00032500	put	32.5000	2026-12-18	2.6100	2.6000	2.7500	35.9000	10440.00	0.00	10440.00	40	5	328	280	1.17142857142857	0.600753489935417	0.600753489935417	false	false	false
dea5d6cc-5d0b-40f5-88dd-dbc18d592688	2026-09-10 15:53	2026-09-10 15:53	2026-09-10 15:53	WHR	WHR261218P00032500	put	32.5000	2026-12-18	2.5600	2.5500	2.7500	36.0100	10240.00	0.00	10240.00	40	5	1253	280	4.475	0.598210431210159	0.598210431210159	false	false	false	true