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 = HAL×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

2ed70b4e-54e8-4f3a-9f37-c73f5290c3be	2026-08-17 09:30	2026-08-17 09:30	2026-08-17 09:30	HAL	HAL280121P00035000	put	35.0000	2028-01-21	5.3800	5.4000	5.6500	34.4800	16150.00	0.00	16150.00	30	6	30	292	0.102739726027397	0.383982555068573	0.383982555068573	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	29167894149.00	2026-10-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8b52fa0d-c4b1-477f-94cf-e090a331e520	2026-08-17 10:57	2026-08-17 10:57	2026-08-17 10:57	HAL	HAL260918C00033000	call	33.0000	2026-09-18	2.0400	2.0400	2.1600	34.3175	14280.00	0.00	14280.00	70	7	71	7545	0.00941020543406229	0.300641087044205	0.300641087044205	false	false	false	true
4b162c3c-bbdc-4589-89dc-a640b7dcae05	2026-08-17 13:01	2026-08-17 13:01	2026-08-17 13:01	HAL	HAL261016P00035000	put	35.0000	2026-10-16	2.2300	2.2300	2.3200	34.3201	10927.00	0.00	10927.00	49	13	52	245	0.212244897959184	0.35654673217485	0.35654673217485	false	false	false	true
a7a3e4ea-a88f-498b-95c2-d4ceedacc606	2026-08-17 13:17	2026-08-17 13:17	2026-08-17 13:17	HAL	HAL261016C00040000	call	40.0000	2026-10-16	0.3900	0.3500	0.4000	34.3700	37089.00	35607.00	858.00	951	38	1085	697	1.55667144906743	0.343248970036418	0.342534851661485	false	false	false	true
48fb5801-5a20-4adb-8d63-67f2c9af971c	2026-08-18 09:51	2026-08-18 09:51	2026-08-18 09:51	HAL	HAL260918P00034000	put	34.0000	2026-09-18	0.9100	0.8800	0.9100	34.9450	11102.00	11102.00	0.00	122	5	275	4648	0.0591652323580034	0.343432897069617	0.343432897069617	false	false	false	true
4b450804-a5a4-4bab-9a63-3583572780bc	2026-08-18 09:51	2026-08-18 09:51	2026-08-18 09:51	HAL	HAL260918P00034000	put	34.0000	2026-09-18	0.9000	0.9000	0.9500	34.9489	65161.00	91.00	65070.00	724	65	1052	4648	0.226333907056799	0.341177681194076	0.341177681194076	true	false	false	true
91a7c44a-d422-44b0-a89d-d4f71c610106	2026-08-18 11:08	2026-08-18 11:08	2026-08-18 11:08	HAL	HAL260918C00035000	call	35.0000	2026-09-18	1.2400	1.2400	1.2700	34.8300	11532.00	0.00	11532.00	93	13	241	28896	0.00834025470653378	0.313009912048769	0.313009912048769	true	false	false	true
d5391b23-aaf5-46be-8f8a-7a94b761ca45	2026-08-18 11:08	2026-08-18 11:08	2026-08-18 11:08	HAL	HAL260918C00035000	call	35.0000	2026-09-18	1.2100	1.2100	1.2500	34.8350	15004.00	0.00	15004.00	124	30	563	28896	0.019483665559247	0.304967956503512	0.304967956503512	true	false	false	true
ffeb3a54-2983-4b00-9f47-d9b56237933c	2026-08-18 13:17	2026-08-18 13:17	2026-08-18 13:17	HAL	HAL270319C00037000	call	37.0000	2027-03-19	2.8900	2.8900	2.9500	34.6550	17629.00	0.00	17629.00	61	14	120	363	0.330578512396694	0.333375764828208	0.333375764828208	false	false	false	true
ee8c2945-f64f-4bd1-bcec-aa733f2ef397	2026-08-19 10:19	2026-08-19 10:19	2026-08-19 10:19	HAL	HAL260828C00034000	call	34.0000	2026-08-28	1.4800	1.4400	1.5600	35.1200	20128.00	19832.00	296.00	136	20	424	883	0.480181200453001	0.358478806244479	0.356459819412913	true	false	false	true
9d0b2695-1c43-4656-8d9d-a459ffa034f4	2026-08-19 11:47	2026-08-19 11:47	2026-08-19 11:47	HAL	HAL260918P00035000	put	35.0000	2026-09-18	1.3500	1.2800	1.3500	35.0250	106515.00	106515.00	0.00	789	19	821	6551	0.125324377957564	0.354250337034532	0.354250337034532	false	false	false	true
02f61386-e858-4180-93fc-9deb761c3ddc	2026-08-19 15:45	2026-08-19 15:45	2026-08-19 15:45	HAL	HAL280121P00025000	put	25.0000	2028-01-21	1.5600	1.4300	1.5600	34.9100	15600.00	15600.00	0.00	100	27	420	1651	0.254391278013325	0.401102573607352	0.401102573607352	false	false	false	true
82d3b4c6-0720-4d8e-bcab-3fb71ee10e4b	2026-08-20 09:34	2026-08-20 09:34	2026-08-20 09:34	HAL	HAL260828C00036000	call	36.0000	2026-08-28	0.5900	0.5800	0.5900	35.6400	29382.00	29382.00	0.00	498	5	505	7208	0.0700610432852386	0.351619131380249	0.351619131380249	false	false	false	true
d1ced628-3802-4cc1-a2a6-842784c4f018	2026-08-20 15:07	2026-08-20 15:07	2026-08-20 15:07	HAL	HAL261016P00035000	put	35.0000	2026-10-16	1.6200	1.6000	1.6700	35.5050	13770.00	13446.00	324.00	85	11	130	285	0.456140350877193	0.353228918774262	0.353228918774262	false	false	false	true
7a16d4de-6c74-4c95-b366-68294bacf331	2026-08-21 11:57	2026-08-21 11:57	2026-08-21 11:57	HAL	HAL261218C00037000	call	37.0000	2026-12-18	2.1200	2.1200	2.2100	35.3250	29515.00	0.00	29515.00	139	5	185	1134	0.163139329805996	0.328156328518179	0.328156328518179	false	false	false	true
84324183-cfb1-4582-bc70-bbf814da802e	2026-08-21 12:38	2026-08-21 12:38	2026-08-21 12:38	HAL	HAL261016C00032000	call	32.0000	2026-10-16	4.1000	3.8500	4.1000	35.3250	40180.00	40180.00	0.00	98	10	189	3177	0.0594900849858357	0.350351118650765	0.350351118650765	false	false	false	true
be86c7b0-1860-4567-a426-697b83e64352	2026-08-24 11:01	2026-08-24 11:01	2026-08-24 11:01	HAL	HAL270115P00034000	put	34.0000	2027-01-15	2.6400	2.3800	2.7500	34.4050	15312.00	8184.00	7128.00	58	6	58	96	0.604166666666667	0.363324889204369	0.363324889204369	false	false	false	true
aeb6900f-dcd7-4395-a6d7-c0eb43c889db	2026-08-24 11:46	2026-08-24 11:46	2026-08-24 11:46	HAL	HAL260918P00033000	put	33.0000	2026-09-18	0.6300	0.6200	0.6500	34.3400	16569.00	0.00	15813.00	263	17	416	5563	0.0747797950746	0.34531684133598	0.34531684133598	true	false	false	true
52132ad4-f55f-4d88-ac0d-78b13d022c9a	2026-08-24 14:29	2026-08-24 14:29	2026-08-24 14:29	HAL	HAL261218C00045000	call	45.0000	2026-12-18	0.3800	0.3300	0.5200	34.5350	16895.00	9994.00	6901.00	447	43	491	953	0.515215110178384	0.353336849967153	0.353336849967153	false	false	false	true
5d4d1b43-5678-46f4-bd7e-f94f5eb0f7ee	2026-08-24 14:51	2026-08-24 14:51	2026-08-24 14:51	HAL	HAL270917C00045000	call	45.0000	2027-09-17	2.0000	2.0000	2.4600	34.5750	10401.00	0.00	10401.00	52	8	52	0	0	0.325615730024682	0.326403918037422	false	false	false	true
85e76342-88f2-4b3e-a2fd-3fc642e77c78	2026-08-25 09:56	2026-08-25 09:56	2026-08-25 09:56	HAL	HAL260918C00035000	call	35.0000	2026-09-18	0.7700	0.7200	0.8200	34.1450	19250.00	308.00	18942.00	250	9	267	29391	0.00908441359599878	0.314914566484655	0.314914566484655	false	false	false	true
e26e3c79-8241-4d4c-95d1-208ef1cfdae1	2026-08-25 10:28	2026-08-25 10:28	2026-08-25 10:28	HAL	HAL260918P00033000	put	33.0000	2026-09-18	0.6700	0.6300	0.6700	34.2050	14338.00	14338.00	0.00	214	5	215	5731	0.0375152678415634	0.35138820068911	0.35138820068911	false	false	false	true
89e4c1bb-388a-42d3-9695-27e6daa91ccb	2026-08-25 12:48	2026-08-25 12:48	2026-08-25 12:48	HAL	HAL270115C00038000	call	38.0000	2027-01-15	1.5700	1.5700	1.6200	34.1750	12089.00	0.00	12089.00	77	14	81	92	0.880434782608696	0.326051672608597	0.326051672608597	false	false	false	true
f4ff1519-9ca2-43d0-b681-1c4fb6da0a18	2026-08-25 13:21	2026-08-25 13:21	2026-08-25 13:21	HAL	HAL270617P00035000	put	35.0000	2027-06-17	4.5000	4.3000	4.5000	34.0450	22500.00	22500.00	0.00	50	5	238	19	12.5263157894737	0.377720840092562	0.377720840092562	false	false	false	true
bfff8804-5f06-45b1-8391-8a8d5525fde0	2026-08-25 15:19	2026-08-25 15:18	2026-08-25 15:18	HAL	HAL270617P00035000	put	35.0000	2027-06-17	4.6000	4.4500	4.6000	33.8300	23000.00	23000.00	0.00	50	13	569	19	29.9473684210526	0.378346376360658	0.378346376360658	false	false	false	true
d72186d2-c0de-4930-88ff-1459a217f5b8	2026-08-25 15:48	2026-08-25 15:48	2026-08-25 15:48	HAL	HAL270115C00036000	call	36.0000	2027-01-15	2.0400	2.0400	2.2200	33.8000	17340.00	0.00	17340.00	85	9	85	49	1.73469387755102	0.322840111999153	0.322840111999153	false	false	false	true
668e3c07-519a-4316-ac9c-f74ecc66ecd0	2026-08-26 12:31	2026-08-26 12:31	2026-08-26 12:31	HAL	HAL270416C00035000	call	35.0000	2027-04-16	3.4000	2.9500	3.4500	33.9750	38080.00	37740.00	0.00	112	11	112	0	0	0.320618999674537	0.320618999674537	false	false	false	true
8a219d87-a071-4a4a-83a8-ff7f53dad69f	2026-08-26 14:11	2026-08-26 14:11	2026-08-26 14:11	HAL	HAL261016C00036000	call	36.0000	2026-10-16	0.9700	0.9500	0.9700	34.1000	15811.00	15811.00	0.00	163	7	188	2244	0.0837789661319073	0.32425544624317	0.32425544624317	true	false	false	true
c50ba932-b898-4bf0-a4dc-26ac47559ee4	2026-08-26 14:14	2026-08-26 14:14	2026-08-26 14:14	HAL	HAL261016C00036000	call	36.0000	2026-10-16	0.9900	0.9600	0.9900	34.1550	14751.00	14652.00	0.00	149	9	360	2244	0.160427807486631	0.324201962244058	0.324201962244058	true	false	false	true
8d5a79e7-964b-4489-9317-256678facf6a	2026-08-26 14:14	2026-08-26 14:14	2026-08-26 14:14	HAL	HAL261016C00036000	call	36.0000	2026-10-16	1.0000	0.9900	1.0000	34.1700	21000.00	21000.00	0.00	210	9	616	2244	0.274509803921569	0.325118137967793	0.325118137967793	true	false	false	true
db2d8a3c-ab04-40b2-a138-43f0e01932f2	2026-08-26 14:20	2026-08-26 14:20	2026-08-26 14:20	HAL	HAL261016C00036000	call	36.0000	2026-10-16	1.0300	0.9800	1.0400	34.2350	15656.00	15553.00	0.00	152	14	769	2244	0.342691622103387	0.32626535601477	0.32626535601477	false	false	false	true
40815022-0cce-4a05-80be-108042be7133	2026-08-26 14:20	2026-08-26 14:20	2026-08-26 14:20	HAL	HAL261016C00036000	call	36.0000	2026-10-16	1.0400	0.9900	1.0500	34.2200	66248.00	65208.00	0.00	637	56	1406	2244	0.626559714795009	0.329877483380542	0.329487855924717	false	false	false	true
651f40d4-3880-4a1a-8ac9-49eb4a5000e9	2026-08-26 15:24	2026-08-26 15:24	2026-08-26 15:24	HAL	HAL280121C00040000	call	40.0000	2028-01-21	3.9000	3.8500	3.9500	34.2600	22230.00	0.00	18720.00	57	14	71	914	0.0776805251641138	0.323111588750995	0.322817304011731	false	false	false	true
a7f2d071-7c00-42c1-ab57-238bb3e87853	2026-08-26 15:35	2026-08-26 15:35	2026-08-26 15:35	HAL	HAL260828C00035500	call	35.5000	2026-08-28	0.0400	0.0300	0.0400	34.2200	10136.00	10136.00	0.00	2534	7	2592	2676	0.968609865470852	0.368875167687384	0.368875167687384	false	false	false	true
1dd82719-f05d-49c2-967f-d687af1e3232	2026-08-26 15:59	2026-08-26 15:59	2026-08-26 15:59	HAL	HAL261016C00035000	call	35.0000	2026-10-16	1.5400	1.3900	1.5400	34.3900	46200.00	46200.00	0.00	300	6	364	1488	0.244623655913978	0.338231214286678	0.338231214286678	false	false	false	true
c3a21029-9741-47d2-bea6-29bd8ed152ea	2026-08-27 10:02	2026-08-27 10:02	2026-08-27 10:02	HAL	HAL260918C00035000	call	35.0000	2026-09-18	0.7400	0.7100	0.7800	34.2200	19536.00	1036.00	18500.00	264	12	264	29567	0.00892887340616228	0.311178946822477	0.311178946822477	false	false	false	true
11c66363-29c0-432e-91e6-73003276eb8d	2026-08-27 10:45	2026-08-27 10:45	2026-08-27 10:45	HAL	HAL261016C00035000	call	35.0000	2026-10-16	1.4300	1.3900	1.4800	34.3700	226655.00	858.00	225797.00	1585	21	1585	1791	0.884980457844779	0.32245235804225	0.32245235804225	false	false	false	true
e810e868-07f5-43b1-b302-7ab24113cd02	2026-08-27 11:35	2026-08-27 11:35	2026-08-27 11:35	HAL	HAL270617P00035000	put	35.0000	2027-06-17	4.2500	4.1000	4.2500	34.4700	35275.00	35275.00	0.00	83	5	175	429	0.407925407925408	0.372460538029701	0.372460538029701	false	false	false	true
9914f202-e5d6-4cf7-bea1-a56f4fe14ccf	2026-08-27 11:35	2026-08-27 11:35	2026-08-27 11:35	HAL	HAL270617P00035000	put	35.0000	2027-06-17	4.2500	4.1000	4.2500	34.4600	41225.00	41225.00	0.00	97	7	432	429	1.00699300699301	0.372117181330442	0.372117181330442	false	false	false	true
0d6bdd62-dfd2-490a-9d38-f41bd690ca49	2026-08-27 13:07	2026-08-27 13:07	2026-08-27 13:07	HAL	HAL260828C00033000	call	33.0000	2026-08-28	1.7600	1.7600	1.8000	34.6501	14090.00	1242.00	12848.00	80	5	116	511	0.227005870841487	0.883107637054643	0.9544110624425	false	false	false	true
f067d634-7778-4363-9a4a-bee8906ddce5	2026-08-27 13:09	2026-08-27 13:09	2026-08-27 13:09	HAL	HAL261016P00035000	put	35.0000	2026-10-16	1.8000	1.7200	1.8000	34.8650	52920.00	52560.00	0.00	294	32	346	421	0.821852731591449	0.354273318375615	0.354273318375615	false	false	false	true
f4af858e-3904-4956-90a4-f089ea325ef8	2026-08-27 13:17	2026-08-27 13:17	2026-08-27 13:17	HAL	HAL260918C00035500	call	35.5000	2026-09-18	0.8800	0.6300	0.8900	35.0100	70488.00	70224.00	176.00	801	5	801	13	61.6153846153846	0.309613005185616	0.310948697660415	false	false	false	true
5d05631e-ae72-498c-86cc-5cfcfb55f89d	2026-08-27 13:24	2026-08-27 13:24	2026-08-27 13:24	HAL	HAL260904P00034000	put	34.0000	2026-09-04	0.3300	0.2700	0.3700	35.0850	10593.00	7293.00	3300.00	321	6	324	94	3.4468085106383	0.372987442120538	0.372987442120538	false	false	false	true
0e91a8e2-1d65-427b-87ab-e567e2771c92	2026-08-27 14:47	2026-08-27 14:47	2026-08-27 14:47	HAL	HAL261016C00037000	call	37.0000	2026-10-16	1.3500	1.2400	1.3500	35.8300	38880.00	38880.00	0.00	288	39	367	1157	0.317199654278306	0.335585305500764	0.335585305500764	false	false	false	true
e8335f66-b878-4aad-b11e-4647ed9bcf3e	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL260918C00034500	call	34.5000	2026-09-18	1.9600	1.4600	1.9700	35.6550	18792.00	18124.00	668.00	96	5	111	32	3.46875	0.414322589149653	0.276786277435417	true	false	false	true
dcf62b89-b61a-4743-97a1-85cc9fbddd4c	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL260918C00036000	call	36.0000	2026-09-18	1.1300	0.7500	1.1300	35.6550	34013.00	34013.00	0.00	301	9	301	4018	0.0749128919860627	0.393488684360706	0.367639294145488	true	false	false	true
48edc299-2e08-404d-a69c-b7053f259c42	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL260828C00035500	call	35.5000	2026-08-28	0.4000	0.1200	0.4500	35.6800	14085.00	14045.00	40.00	352	13	360	1867	0.192822710230316	1.08982438291932	0.923449486753768	true	false	false	true
0552851a-8c69-4ee5-ae03-aa1095052d33	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL261016C00039000	call	39.0000	2026-10-16	0.9000	0.5200	0.9100	35.6800	12760.00	12103.00	657.00	142	7	142	638	0.22257053291536	0.402816797611834	0.34869320192563	true	false	false	true
035aeb5f-d894-46b4-87d1-a4f1bdc83560	2026-08-28 09:41	2026-08-28 09:40	2026-08-28 09:40	HAL	HAL260918C00035000	call	35.0000	2026-09-18	1.5500	1.1700	1.5500	35.6800	139491.00	139035.00	456.00	900	20	903	29867	0.030234037566545	0.373593020273886	0.325885730048381	true	false	false	true
b0f98b68-08e4-4e2d-aa7a-d61a27f02559	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	HAL	HAL261120C00038000	call	38.0000	2026-11-20	1.6600	1.6600	1.8300	36.0500	10458.00	0.00	7802.00	63	10	169	16	10.5625	0.337982009076238	0.337982009076238	false	false	false	true