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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = HIMS×

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

b777410f-87ed-46e4-85a0-1d55c25ce23e	2026-08-27 11:18	2026-08-27 11:18	2026-08-27 11:18	HIMS	HIMS260828C00031500	call	31.5000	2026-08-28	0.4100	0.4000	0.4200	31.0250	20669.00	19931.00	738.00	504	11	3536	3862	0.915587778353185	0.945929918011445	0.945929918011445	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Defensive	6480400110.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f4eee2fd-d534-4dd7-9c64-e0c0ae22716f	2026-08-26 12:35	2026-08-26 12:35	2026-08-26 12:35	HIMS	HIMS281215C00030000	call	30.0000	2028-12-15	14.1100	14.1000	14.9000	29.9500	47975.00	0.00	47975.00	34	8	100	64	1.5625	0.776348609862208	0.783254911785836	false	false	false	true
8fc7ccb8-5a49-4855-8553-292088176f4b	2026-08-26 11:51	2026-08-26 11:51	2026-08-26 11:51	HIMS	HIMS281215P00015000	put	15.0000	2028-12-15	3.3600	3.3500	3.4000	30.0900	33586.00	0.00	33586.00	100	6	613	700	0.875714285714286	0.788644180621224	0.789857822388815	false	false	false	true
533d1232-1d20-4eb1-95eb-d87e4d604504	2026-08-26 11:50	2026-08-26 11:50	2026-08-26 11:50	HIMS	HIMS281215P00015000	put	15.0000	2028-12-15	3.3600	3.3500	3.4000	30.1100	33591.00	0.00	33591.00	100	5	153	700	0.218571428571429	0.788895943834536	0.790109596991236	false	false	false	true
3fef49b4-6603-4d47-9e83-bc521348e4ff	2026-08-25 14:35	2026-08-25 14:35	2026-08-25 14:35	HIMS	HIMS260911C00034000	call	34.0000	2026-09-11	1.0900	1.0800	1.1600	31.6301	12161.00	6322.00	5839.00	112	5	179	722	0.24792243767313	0.71992444603595	0.71992444603595	false	false	false	true
0bda7c34-930a-4b51-a045-80f0b5c9488b	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	HIMS	HIMS260918C00037000	call	37.0000	2026-09-18	1.0300	0.9700	1.0400	32.3250	28948.00	28846.00	102.00	282	37	329	3107	0.105889925973608	0.766591714565386	0.770158178455659	true	false	false	true
0c64f168-5a7a-4bcd-afec-6b0554922cac	2026-08-25 11:43	2026-08-25 11:43	2026-08-25 11:43	HIMS	HIMS261016C00035000	call	35.0000	2026-10-16	2.7900	2.7500	2.8000	32.4350	55896.00	55896.00	0.00	200	9	466	2304	0.202256944444444	0.765829580439486	0.765829580439486	false	false	false	true
f01ddeff-72b6-4dcc-aef7-bdfe623ca700	2026-08-24 15:11	2026-08-24 15:11	2026-08-24 15:11	HIMS	HIMS270115C00048000	call	48.0000	2027-01-15	2.2200	2.1900	2.3200	30.6500	11094.00	7771.00	3323.00	50	9	57	44	1.29545454545455	0.829383400019784	0.829383400019784	false	false	false	true
c2e2da19-890c-4d4e-b875-408a23f44769	2026-08-24 15:00	2026-08-24 15:00	2026-08-24 15:00	HIMS	HIMS270219C00033000	call	33.0000	2027-02-19	5.8200	5.8000	6.1500	30.5600	145546.00	0.00	145546.00	250	8	279	727	0.383768913342503	0.767191532130518	0.775836109569556	false	false	false	true
b925d118-8e0d-4cef-9c28-6d31f827d6d8	2026-08-24 09:43	2026-08-24 09:43	2026-08-24 09:43	HIMS	HIMS260828P00029500	put	29.5000	2026-08-28	0.5900	0.5900	0.6200	30.8300	28512.00	3968.00	24544.00	480	9	532	275	1.93454545454545	0.908847613757592	0.930048956743831	false	false	false	true
fc19db55-9061-4dc9-bc95-1463410c9178	2026-08-21 15:58	2026-08-21 15:58	2026-08-21 15:58	HIMS	HIMS260828C00035000	call	35.0000	2026-08-28	0.8200	0.8200	0.8700	33.6900	24650.00	0.00	24650.00	300	6	3286	3752	0.875799573560768	0.719315772968243	0.726918889466165	false	false	false	true
0690d0ed-9a0b-493b-bbac-4660f03ddb2b	2026-08-21 13:39	2026-08-21 13:39	2026-08-21 13:39	HIMS	HIMS261218C00046000	call	46.0000	2026-12-18	3.0700	3.0500	3.7500	33.8350	47258.00	0.00	47258.00	154	5	154	23	6.69565217391304	0.834147367542781	0.839720152195196	false	false	false	true
952c0641-3e9d-4d87-a3f1-136b89f969ff	2026-08-21 12:37	2026-08-21 12:37	2026-08-21 12:37	HIMS	HIMS260918C00035000	call	35.0000	2026-09-18	2.7100	2.5600	2.7500	34.4099	163140.00	137125.00	270.00	603	57	2093	5143	0.406960917752285	0.773309901959352	0.771287394808338	true	false	false	true
3568d7de-9586-4887-ba69-71ed3dd5aca3	2026-08-21 11:49	2026-08-21 11:49	2026-08-21 11:49	HIMS	HIMS270219C00042000	call	42.0000	2027-02-19	5.3000	5.0000	5.3000	33.6800	26499.00	26499.00	0.00	50	7	171	28	6.10714285714286	0.822429643100667	0.822980905270254	false	false	false	true
5f807cf7-fd72-467a-8109-be1cd6347b59	2026-08-21 11:40	2026-08-21 11:40	2026-08-21 11:40	HIMS	HIMS270219C00042000	call	42.0000	2027-02-19	5.1900	4.9000	5.2750	33.5600	26982.00	26982.00	0.00	52	5	121	28	4.32142857142857	0.817330757203622	0.818446667281087	false	false	false	true
57b997a7-51dd-46a5-a853-e26931848623	2026-08-20 15:15	2026-08-20 15:15	2026-08-20 15:15	HIMS	HIMS281215C00032000	call	32.0000	2028-12-15	15.4800	15.4500	16.0000	32.3200	99079.00	21700.00	77379.00	64	9	115	13	8.84615384615385	0.779355442300684	0.784505715773804	true	false	false	true
2c317462-6fe6-49b4-836f-7e7c6882fc09	2026-08-20 11:22	2026-08-20 11:22	2026-08-20 11:22	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	2.1400	2.1300	2.2700	32.0700	21402.00	0.00	21402.00	100	9	2441	7834	0.31159050293592	0.862395322568364	1.03155936789306	false	false	false	true
d9bc4970-6f2f-43a0-b76c-5d4a8a28b8dc	2026-08-20 11:22	2026-08-20 11:22	2026-08-20 11:22	HIMS	HIMS260828P00030000	put	30.0000	2026-08-28	0.5600	0.5600	0.6100	32.1700	11237.00	0.00	11237.00	199	17	1074	565	1.90088495575221	0.758373134887119	0.765018876155616	true	false	false	true
d0ca2cb3-c5bd-43a9-b5a0-66bed1d5ef51	2026-08-20 09:55	2026-08-20 09:55	2026-08-20 09:55	HIMS	HIMS260918C00043000	call	43.0000	2026-09-18	0.6700	0.5700	0.7000	32.8750	84340.00	61975.00	21260.00	1260	35	1636	1105	1.48054298642534	0.868707480789062	0.878298495298689	true	false	false	true
cf9afc88-9216-43ba-89c4-0f0e154431de	2026-08-20 09:47	2026-08-20 09:47	2026-08-20 09:47	HIMS	HIMS271217C00040000	call	40.0000	2027-12-17	10.3300	9.7000	10.9000	32.9250	13428.00	5180.00	8248.00	13	6	125	1355	0.0922509225092251	0.804584280263969	0.805278689790371	false	false	false	true
c506548b-15b9-4cb3-9130-9631d5885262	2026-08-20 09:43	2026-08-20 09:43	2026-08-20 09:43	HIMS	HIMS260828C00034000	call	34.0000	2026-08-28	1.0500	1.0500	1.1400	32.5400	47300.00	0.00	47300.00	450	25	527	1454	0.362448418156809	0.846501851111202	0.850493126781144	false	false	false	true
b453a541-6be1-4b06-bcd4-1f767a447f36	2026-08-19 15:26	2026-08-19 15:26	2026-08-19 15:26	HIMS	HIMS260821C00032000	call	32.0000	2026-08-21	0.4800	0.4500	0.5000	30.9300	34667.00	34522.00	48.00	722	18	3071	5146	0.596774193548387	0.989233830955495	0.997200366952418	false	false	false	true
fcfe2869-66c6-42a9-b897-d0f6c5eec7ff	2026-08-19 14:59	2026-08-19 14:59	2026-08-19 14:59	HIMS	HIMS260828C00031000	call	31.0000	2026-08-28	1.1500	1.1500	1.2400	30.4200	13958.00	236.00	13722.00	121	15	773	1219	0.634126333059885	0.732870378832156	0.748686029563692	true	false	false	true
eb98559b-114b-464c-a33d-fa5b3722b2df	2026-08-19 14:54	2026-08-19 14:53	2026-08-19 14:53	HIMS	HIMS270115C00040000	call	40.0000	2027-01-15	3.5000	3.4000	3.5000	30.5700	112959.00	108500.00	4459.00	323	11	655	8997	0.0728020451261532	0.793537215176751	0.802784796369968	false	false	false	true
2a2dc074-c639-48e4-bc28-ffdc9825233b	2026-08-19 14:52	2026-08-19 14:52	2026-08-19 14:52	HIMS	HIMS260918C00034000	call	34.0000	2026-09-18	1.4200	1.3200	1.4600	30.6750	52396.00	52253.00	0.00	369	16	583	1021	0.571008814887365	0.739231344489834	0.745319313469467	true	false	false	true
ffa55795-e47b-4315-b155-586387f87f93	2026-08-18 15:17	2026-08-18 15:17	2026-08-18 15:17	HIMS	HIMS271217C00085000	call	85.0000	2027-12-17	3.0500	3.0000	4.3000	27.7400	206255.00	1550.00	204705.00	676	21	676	307	2.20195439739414	0.850788159738845	0.856600897176685	false	false	false	true
5910bc11-eff9-442c-bf0b-bbdc2c09fd1a	2026-08-18 12:30	2026-08-18 12:30	2026-08-18 12:30	HIMS	HIMS280121P00013000	put	13.0000	2028-01-21	1.7500	1.7500	1.7800	27.7500	43800.00	0.00	35925.00	250	9	1260	1154	1.09185441941075	0.792609129974139	0.792609129974139	false	false	false	true
5bd2ed87-9648-463e-b1a4-20ba925a5773	2026-08-18 10:18	2026-08-18 10:18	2026-08-18 10:18	HIMS	HIMS261120P00028000	put	28.0000	2026-11-20	4.2000	4.0000	4.3000	28.1700	19318.00	418.00	18900.00	46	7	48	276	0.173913043478261	0.783001312477271	0.786610172139793	false	false	false	true
96741833-6493-4810-9b02-c8d3c7ab5d4f	2026-08-18 09:45	2026-08-18 09:45	2026-08-18 09:45	HIMS	HIMS260821C00029000	call	29.0000	2026-08-21	0.5900	0.5700	0.6400	28.0000	31172.00	20384.00	10788.00	532	15	1286	4685	0.274493062966916	0.786465494388336	0.812190950328323	false	false	false	true
ef5249c3-0c2d-4efa-b2f5-400b03498c9d	2026-08-17 15:30	2026-08-17 15:30	2026-08-17 15:30	HIMS	HIMS260821C00026000	call	26.0000	2026-08-21	2.6200	2.6200	2.7100	28.5300	14437.00	0.00	14437.00	55	8	322	537	0.599627560521415	0.66498639915549	0.685989646365396	false	false	false	true