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:alert_rule = RepeatedHits×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	expirydate

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	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-08-18T14:49:07.673043Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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
d16f5db6-60a1-401d-85b5-16c7c1b7c89a	2026-09-10 15:59	2026-09-10 15:58	2026-09-10 15:58	WHR	WHR261218P00032500	put	32.5000	2026-12-18	2.6000	2.5500	2.8000	35.8600	10400.00	0.00	10400.00	40	14	1453	280	5.18928571428571	0.59736111826251	0.59736111826251	false	false	false	true
1880177a-46ce-42f6-afd9-ec676d93fde0	2026-09-11 11:22	2026-09-11 11:21	2026-09-11 11:21	WHR	WHR270115C00055000	call	55.0000	2027-01-15	0.8500	0.7000	0.9000	36.1500	30600.00	30090.00	255.00	360	12	361	3002	0.120253164556962	0.578965816308526	0.578965816308526	false	false	false	true
db6ffb1b-f2d5-4754-9763-c4a5624aa330	2026-09-11 12:24	2026-09-11 12:23	2026-09-11 12:23	WHR	WHR261218C00045000	call	45.0000	2026-12-18	1.7000	1.4500	1.7500	35.8200	68000.00	54570.00	0.00	400	7	403	375	1.07466666666667	0.590697412548145	0.589559396416913	false	false	false	true
4e4e04d9-ad22-46b3-af66-11da41fec0b3	2026-09-11 15:36	2026-09-11 15:36	2026-09-11 15:36	WHR	WHR261218C00050000	call	50.0000	2026-12-18	1.0000	0.7500	1.0000	35.2900	19000.00	19000.00	0.00	190	18	191	2443	0.0781825624232501	0.618598986620883	0.618598986620883	false	false	false	true
0c569de6-0996-4ac0-87b4-2b279a46c9be	2026-09-14 11:37	2026-09-14 11:36	2026-09-14 11:36	WHR	WHR261016C00037500	call	37.5000	2026-10-16	1.1500	0.9500	1.3000	34.5200	11615.00	8625.00	1035.00	101	28	126	165	0.763636363636364	0.542218004097221	0.542218004097221	true	false	false	true
a4bfdd23-2ba4-46b5-9350-b80401ec37ec	2026-09-14 11:37	2026-09-14 11:37	2026-09-14 11:37	WHR	WHR261016C00037500	call	37.5000	2026-10-16	1.1000	1.1000	1.2500	34.4201	20241.00	0.00	20241.00	184	44	326	165	1.97575757575758	0.53778742036606	0.53778742036606	true	false	false	true
398413d4-71e6-4882-bdfc-679f3e5fdfe7	2026-09-14 11:37	2026-09-14 11:37	2026-09-14 11:37	WHR	WHR261016C00037500	call	37.5000	2026-10-16	1.1000	1.0500	1.2500	34.4300	22000.00	4290.00	7920.00	200	28	526	165	3.18787878787879	0.536900030667062	0.536900030667062	true	false	false	true
3362ea75-a360-43e2-8ab5-c58819344000	2026-09-14 11:37	2026-09-14 11:37	2026-09-14 11:37	WHR	WHR261016C00037500	call	37.5000	2026-10-16	1.1000	1.0500	1.2500	34.4400	30260.00	1760.00	28500.00	275	45	801	165	4.85454545454545	0.533312280455983	0.536003446163301	true	false	false	true
c45bec62-b013-4025-b3cc-6ef2d599dfa7	2026-09-14 11:38	2026-09-14 11:38	2026-09-14 11:38	WHR	WHR261016C00037500	call	37.5000	2026-10-16	1.1000	1.0500	1.1000	34.5300	34430.00	34430.00	0.00	313	42	1532	165	9.28484848484849	0.527923433009504	0.527923433009504	false	false	false	true