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 = RepeatedHitsDescendingFill×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	expiry

5e7d4b6b-63a8-4d27-86a2-6f02b50be756	2026-08-24 14:51	2026-08-24 14:51	2026-08-24 14:51	HAL	HAL270917C00045000	call	45.0000	2027-09-17	2.0100	2.0100	2.3200	34.5650	11279.00	205.00	11074.00	56	10	108	0	0	0.329799364473558	0.326652722748418	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Energy	29167894149.00	2026-10-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0890c314-f9dd-4429-a314-a7141a7033f6	2026-08-25 11:34	2026-08-25 11:34	2026-08-25 11:34	HAL	HAL260918C00030000	call	30.0000	2026-09-18	4.5000	4.3500	4.5000	34.3450	89984.00	89984.00	0.00	200	29	222	3474	0.0639032815198618	0.352499814482576	0.352499814482576	false	false	false	true
c0111fdd-26a3-427e-84cb-c279f366bd78	2026-08-27 13:07	2026-08-27 13:07	2026-08-27 13:07	HAL	HAL261120C00036000	call	36.0000	2026-11-20	1.8400	1.8300	1.8400	34.6501	14154.00	11592.00	2562.00	77	10	86	31	2.7741935483871	0.343572711922154	0.343572711922154	false	false	false	true
53b0d41c-1e42-4b35-9f6d-e852cdf46b14	2026-08-28 11:18	2026-08-28 11:18	2026-08-28 11:18	HAL	HAL280121P00032000	put	32.0000	2028-01-21	3.7000	3.4500	3.7000	36.0250	361610.00	346280.00	15330.00	978	29	989	1908	0.518343815513627	0.401026716026665	0.401026716026665	false	false	false	true
26c3dacd-bd12-4cb2-847d-d23cfde81b3d	2026-08-31 13:07	2026-08-31 13:07	2026-08-31 13:07	HAL	HAL270617P00033000	put	33.0000	2027-06-17	2.7800	2.6400	2.7800	36.7300	28627.00	28353.00	274.00	103	6	103	421	0.244655581947743	0.396357945687372	0.394358589963002	false	false	false	true
76d56108-b807-42a2-8c0e-908a36f1bf86	2026-09-16 12:42	2026-09-16 12:42	2026-09-16 12:42	HAL	HAL261120C00032000	call	32.0000	2026-11-20	4.4200	4.3500	4.4000	35.2400	22090.00	22090.00	0.00	50	10	1528	2	764	0.41037280534922	0.41037280534922	true	false	false	true
cb5d2b11-b52b-4c6f-b06e-4dab67c529c9	2026-09-16 13:39	2026-09-16 13:39	2026-09-16 13:39	HAL	HAL261120C00032000	call	32.0000	2026-11-20	4.2900	4.2500	4.3000	35.0450	12862.00	12862.00	0.00	30	5	4059	2	2029.5	0.409523645584641	0.405316575449534	false	false	false	true
0faddfe2-7a03-480b-aa33-039b5634329a	2026-09-16 15:39	2026-09-16 15:39	2026-09-16 15:39	HAL	HAL261120C00032000	call	32.0000	2026-11-20	3.8400	3.7500	3.8500	34.3550	10369.00	10369.00	0.00	27	5	5706	2	2853	0.419517813619342	0.415532773068951	false	false	false	true
c3531eea-f95d-4303-8e8b-fe35ff83594a	2026-09-17 09:30	2026-09-17 09:30	2026-09-17 09:30	HAL	HAL261120C00032000	call	32.0000	2026-11-20	3.8900	3.8000	3.9000	34.3600	21405.00	17940.00	1540.00	55	7	71	4655	0.0152524167561762	0.432334435964147	0.422322066377267	true	false	false	true
931f7f82-3228-4531-8801-1fcea607f00d	2026-09-17 09:30	2026-09-17 09:30	2026-09-17 09:30	HAL	HAL261120C00032000	call	32.0000	2026-11-20	3.8100	3.7500	3.9500	34.3100	14465.00	385.00	6860.00	38	5	146	4655	0.0313641245972073	0.429326972322443	0.429326972322443	false	false	false	true
d5d6f62d-caad-4552-9d7f-a86c3c7b1298	2026-09-18 14:32	2026-09-18 14:32	2026-09-18 14:32	HAL	HAL261016C00034000	call	34.0000	2026-10-16	1.2500	1.2500	1.2700	33.7850	37922.00	0.00	32000.00	303	23	410	1705	0.240469208211144	0.351829083609956	0.349150041850173	false	false	false	true