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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	expirydate	price

a81f9901-7475-4e4d-9010-1a3d9accafba	2026-08-20 09:41	2026-08-20 09:41	2026-08-20 09:41	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	2.4900	2.4100	2.4900	32.3350	10209.00	10209.00	0.00	41	17	328	7834	0.041868777125351	1.32074390949163	1.32074390949163	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	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-20T13:45:25.718532Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c8435058-d24b-4e02-ab55-d6b101b0cf5a	2026-08-20 09:39	2026-08-20 09:39	2026-08-20 09:39	HIMS	HIMS260828P00030000	put	30.0000	2026-08-28	0.6000	0.5800	0.6600	32.3850	19620.00	16440.00	3180.00	327	7	405	565	0.716814159292035	0.821825849156078	0.820062769404921	false	false	false	true	false
d55ecf19-34ba-45d3-8928-4ebb207b6217	2026-08-20 09:32	2026-08-20 09:31	2026-08-20 09:31	HIMS	HIMS260918C00030000	call	30.0000	2026-09-18	3.2500	3.0000	3.2500	31.3700	25350.00	25350.00	0.00	78	8	78	2857	0.0273013650682534	0.746489936770595	0.712775845086997	false	false	false	true	false
03f923da-135e-4eb6-9b94-ddf4a10e7880	2026-08-20 09:30	2026-08-20 09:30	2026-08-20 09:30	HIMS	HIMS270115C00027000	call	27.0000	2027-01-15	8.1000	7.9500	8.5000	31.2700	17010.00	0.00	17010.00	21	5	21	1246	0.0168539325842697	0.747827140657157	0.747827140657157	false	false	false	true	false
cfe7d740-e5a1-40b3-8766-b7e83d955bbc	2026-08-19 15:51	2026-08-19 15:51	2026-08-19 15:51	HIMS	HIMS260828C00032000	call	32.0000	2026-08-28	1.2400	1.2300	1.2400	31.2477	22066.00	21328.00	738.00	178	19	953	697	1.36728837876614	0.795923631221426	0.795923631221426	false	false	false	true	false
9403be2d-1f7b-460d-8193-550910633698	2026-08-19 15:51	2026-08-19 15:51	2026-08-19 15:51	HIMS	HIMS260828C00033000	call	33.0000	2026-08-28	0.9100	0.9000	0.9200	31.2477	47484.00	19044.00	28440.00	523	21	1128	726	1.55371900826446	0.815568777042835	0.815568777042835	false	false	false	true	false
814cc1de-0567-4aa7-9f67-6cd10aad8f09	2026-08-19 15:49	2026-08-19 15:49	2026-08-19 15:49	HIMS	HIMS260918C00032000	call	32.0000	2026-09-18	2.3000	2.1800	2.3000	30.9843	23000.00	23000.00	0.00	100	13	267	1164	0.229381443298969	0.761762130368614	0.761762130368614	false	false	false	true	false
8b79e18b-036a-4bb3-8cc1-0cd73e13f3d3	2026-08-19 15:47	2026-08-19 15:46	2026-08-19 15:46	HIMS	HIMS260821C00028500	call	28.5000	2026-08-21	2.7500	2.3800	2.7500	30.9948	13740.00	13740.00	0.00	50	5	1260	1405	0.896797153024911	1.21140408381579	1.21140408381579	false	false	false	true	false
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	false
88ce0a0a-dc2c-4746-af34-7262ba6efd4d	2026-08-19 15:26	2026-08-19 15:26	2026-08-19 15:26	HIMS	HIMS261016C00030000	call	30.0000	2026-10-16	4.0500	4.0500	4.1000	30.9200	20250.00	0.00	20250.00	50	8	801	1365	0.586813186813187	0.721341179934093	0.721341179934093	false	false	false	true	false
6c2f2fb7-9ef8-49e9-b89a-b4d40798a645	2026-08-19 15:26	2026-08-19 15:26	2026-08-19 15:26	HIMS	HIMS260828C00032500	call	32.5000	2026-08-28	0.9000	0.8900	0.9900	30.8700	15660.00	14130.00	1530.00	174	24	551	185	2.97837837837838	0.793074238614822	0.793074238614822	false	false	false	true	false
f02b5e2d-a54f-458a-8d41-6590c26e4b72	2026-08-19 15:25	2026-08-19 15:25	2026-08-19 15:25	HIMS	HIMS260821C00032000	call	32.0000	2026-08-21	0.4100	0.3800	0.4200	30.7250	30750.00	30750.00	0.00	750	7	2291	5146	0.445200155460552	0.979236286220149	0.979236286220149	false	false	false	true	false
36630705-86d6-439e-b19b-c4aeb27ed7eb	2026-08-19 15:23	2026-08-19 15:23	2026-08-19 15:23	HIMS	HIMS260821P00028000	put	28.0000	2026-08-21	0.0600	0.0600	0.0700	30.6950	27000.00	0.00	27000.00	4500	6	11336	4061	2.79143068209801	0.854523132632025	0.854523132632025	false	false	false	true	false
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	false
208b2f20-c5f1-4e7d-b8f3-b749c2d06550	2026-08-19 14:55	2026-08-19 14:54	2026-08-19 14:54	HIMS	HIMS261120C00035000	call	35.0000	2026-11-20	3.4500	3.4500	3.5500	30.5450	10695.00	0.00	10695.00	31	12	543	2088	0.260057471264368	0.806510161732128	0.806510161732128	false	false	false	true	false
4a5097b5-dc85-4bdd-ba9c-be7dafb8285e	2026-08-19 14:54	2026-08-19 14:54	2026-08-19 14:54	HIMS	HIMS260918C00035000	call	35.0000	2026-09-18	1.1500	1.1100	1.1600	30.5250	15525.00	15525.00	0.00	135	7	1226	3812	0.321615949632739	0.753708149152764	0.753708149152764	true	false	false	true	false
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	false
7f15ec4b-39c6-4361-a3c0-02d14438272a	2026-08-19 14:53	2026-08-19 14:53	2026-08-19 14:53	HIMS	HIMS261120C00035000	call	35.0000	2026-11-20	3.4500	3.4500	3.5500	30.5620	28635.00	0.00	28635.00	83	5	438	2088	0.209770114942529	0.805238456679869	0.805238456679869	false	false	false	true	false
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	false
52cd3eaa-6686-40ba-9c9f-39e4e888292b	2026-08-19 14:51	2026-08-19 14:51	2026-08-19 14:51	HIMS	HIMS271217P00005000	put	5.0000	2027-12-17	0.1500	0.0900	0.1500	30.6550	15120.00	15120.00	0.00	1008	15	3238	516	6.27519379844961	0.888995100023282	0.888995100023282	false	false	false	true	false
4f09c8b8-cafd-4b3d-bb94-73274eff38e0	2026-08-19 14:49	2026-08-19 14:49	2026-08-19 14:49	HIMS	HIMS261016C00031000	call	31.0000	2026-10-16	3.4500	3.3500	3.4500	30.6600	16560.00	16560.00	0.00	48	12	621	1880	0.33031914893617	0.724939722547442	0.723801643117212	false	false	false	true	false
6d5538c9-f6c2-4799-9a08-f6c607ea4573	2026-08-19 14:31	2026-08-19 14:30	2026-08-19 14:30	HIMS	HIMS261120C00027000	call	27.0000	2026-11-20	6.5500	6.1500	6.5500	30.2400	16375.00	16375.00	0.00	25	5	26	109	0.238532110091743	0.8058847997298	0.8058847997298	false	false	false	true	false
f0725d31-1601-4ca7-8e4d-4a9341077053	2026-08-19 14:29	2026-08-19 14:29	2026-08-19 14:29	HIMS	HIMS260918C00031000	call	31.0000	2026-09-18	2.0600	1.9700	2.0600	30.1400	12978.00	12978.00	0.00	63	17	406	707	0.574257425742574	0.70514019407575	0.69521472029915	false	false	false	true	false
89b45e26-4db9-40c9-9cc9-3da8daa6e679	2026-08-19 14:02	2026-08-19 14:02	2026-08-19 14:02	HIMS	HIMS281215P00015000	put	15.0000	2028-12-15	3.3500	3.3500	3.4000	29.7300	33835.00	0.00	33835.00	101	19	699	365	1.91506849315068	0.78182529612967	0.78182529612967	false	false	false	true	false
2a2e4ac2-6e11-4398-ba6e-94be63bbec60	2026-08-19 13:59	2026-08-19 13:59	2026-08-19 13:59	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	0.6000	0.5800	0.6100	29.6800	13800.00	13320.00	480.00	230	38	7518	8699	0.864237268651569	0.847279392442629	0.847279392442629	true	false	false	true	false
6ddf9359-03e5-4071-93c1-17d6c6320a35	2026-08-19 12:37	2026-08-19 12:36	2026-08-19 12:36	HIMS	HIMS260828P00027500	put	27.5000	2026-08-28	0.4600	0.4600	0.4600	29.6156	13846.00	0.00	0.00	301	5	334	451	0.740576496674058	0.699412299983003	0.699412299983003	false	false	false	true	false
f19e0f30-cc42-47e9-9f39-f0ca7b9bc9d5	2026-08-19 12:35	2026-08-19 12:34	2026-08-19 12:34	HIMS	HIMS260828P00027000	put	27.0000	2026-08-28	0.3400	0.3400	0.3600	29.6000	11288.00	0.00	11288.00	332	26	441	1165	0.378540772532189	0.696432084304903	0.696432084304903	false	false	false	true	false
3df044b3-863c-475b-a1fa-1d98f31c916e	2026-08-19 12:15	2026-08-19 12:14	2026-08-19 12:14	HIMS	HIMS270219P00023000	put	23.0000	2027-02-19	2.6000	2.6000	2.7700	29.4300	27820.00	0.00	27820.00	107	6	108	22	4.90909090909091	0.740100493061036	0.740100493061036	false	false	false	true	false
8d13fe0e-ff00-4f32-83da-f1b31f5a4be4	2026-08-19 12:05	2026-08-19 12:05	2026-08-19 12:05	HIMS	HIMS260911C00033000	call	33.0000	2026-09-11	0.9100	0.8500	0.9100	29.5022	63700.00	63700.00	0.00	700	19	819	839	0.976162097735399	0.709279058899658	0.709279058899658	false	false	false	true	false
19787321-35bd-4126-84b1-13e6b741f7f6	2026-08-19 12:05	2026-08-19 12:05	2026-08-19 12:05	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	0.5500	0.5400	0.5500	29.4850	12155.00	12155.00	0.00	221	6	6168	8699	0.709047016898494	0.886124475154455	0.886124475154455	false	false	false	true	false
1e9189d1-9e68-4ea2-aa1a-0bd8a4595d3e	2026-08-19 11:59	2026-08-19 11:59	2026-08-19 11:59	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	0.4800	0.4800	0.5100	29.3300	24000.00	0.00	24000.00	500	24	4974	8699	0.571789860903552	0.879931664987432	0.875363169416172	false	false	false	true	false
7b9a9cf4-812b-47a8-b660-bd8d54164484	2026-08-19 11:15	2026-08-19 11:15	2026-08-19 11:15	HIMS	HIMS261016C00030000	call	30.0000	2026-10-16	3.0500	3.0500	3.1500	29.1304	150398.00	0.00	150398.00	493	33	577	1365	0.422710622710623	0.718044927379338	0.724254693783718	false	false	false	true	false
d2c9ad54-62b6-485b-99d0-5dd64ed3a42f	2026-08-19 10:18	2026-08-19 10:18	2026-08-19 10:18	HIMS	HIMS261016C00031000	call	31.0000	2026-10-16	2.4900	2.4200	2.5000	28.7480	24900.00	24900.00	0.00	100	8	267	1880	0.142021276595745	0.725714614934311	0.725714614934311	false	false	false	true	false
b4113ae0-94d6-413a-a60d-f84617588f93	2026-08-19 10:01	2026-08-19 10:01	2026-08-19 10:01	HIMS	HIMS260918C00030000	call	30.0000	2026-09-18	2.0000	1.9200	2.0000	29.1750	17800.00	17800.00	0.00	89	8	323	2572	0.125583203732504	0.696082807266754	0.696082807266754	true	false	false	true	false
89227a3f-f468-4e99-84e8-beeadccb8bce	2026-08-19 10:01	2026-08-19 10:01	2026-08-19 10:01	HIMS	HIMS260904C00027500	call	27.5000	2026-09-04	2.5500	2.3800	2.6200	29.0400	24225.00	16575.00	7650.00	95	5	95	35	2.71428571428571	0.69440140050483	0.69440140050483	false	false	false	true	false
10c34aa0-cf84-42b2-9343-181eeaa9a0ec	2026-08-19 09:59	2026-08-19 09:58	2026-08-19 09:58	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	0.4800	0.4600	0.4900	29.1000	18912.00	14112.00	4656.00	394	33	1751	8699	0.20128750431084	0.978425031430936	0.978425031430936	false	false	false	true	false
43726f21-f11e-43ad-aa3a-cbe9466e82a5	2026-08-19 09:48	2026-08-19 09:48	2026-08-19 09:48	HIMS	HIMS260821C00029000	call	29.0000	2026-08-21	0.6500	0.5900	0.6500	28.7300	50646.00	50646.00	0.00	780	47	1134	4790	0.236743215031315	0.909280611273224	0.909280611273224	true	false	false	true	false
d16534a2-aa20-4c63-95db-3f8cf0e0541b	2026-08-19 09:44	2026-08-19 09:44	2026-08-19 09:44	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	0.2500	0.2500	0.2900	28.4740	10000.00	0.00	10000.00	400	7	729	8699	0.0838027359466605	0.912369069435281	0.912369069435281	false	false	false	true	false
c2d2026a-a7ac-4dcd-a3df-d5ca2d4d11f1	2026-08-18 15:59	2026-08-18 15:59	2026-08-18 15:59	HIMS	HIMS260821C00028500	call	28.5000	2026-08-21	0.3500	0.3500	0.3700	27.0000	32550.00	0.00	12565.00	930	15	3503	882	3.97165532879819	0.756503208832345	0.756503208832345	true	false	false	true	false
7d508c69-0553-4327-87be-82ae7830392c	2026-08-18 15:22	2026-08-18 15:22	2026-08-18 15:22	HIMS	HIMS261016P00027000	put	27.0000	2026-10-16	2.5300	2.5300	2.6500	27.7500	24541.00	0.00	24541.00	97	11	107	209	0.511961722488038	0.679642254697147	0.679642254697147	true	false	false	true	false
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	false
89117a72-e640-4e17-bf3a-c92f2d741557	2026-08-18 15:17	2026-08-18 15:17	2026-08-18 15:17	HIMS	HIMS271217C00090000	call	90.0000	2027-12-17	2.8000	2.8000	3.6000	27.7850	952546.00	0.00	952546.00	3402	33	3404	2882	1.18112421929216	0.85155984489051	0.85155984489051	true	false	false	true	false
7ac25c90-cda7-4337-b800-00e180aeab17	2026-08-18 15:17	2026-08-18 15:17	2026-08-18 15:17	HIMS	HIMS271217C00075000	call	75.0000	2027-12-17	3.5500	3.5500	4.1000	27.7850	228975.00	0.00	228975.00	645	10	682	428	1.59345794392523	0.840280027235068	0.840280027235068	false	false	false	true	false
3ef76f9f-6f9e-4bf2-8390-18f9f472e0e8	2026-08-18 15:17	2026-08-18 15:17	2026-08-18 15:17	HIMS	HIMS280121C00080000	call	80.0000	2028-01-21	3.6000	3.6000	3.9000	27.7850	106654.00	0.00	106654.00	296	7	297	1117	0.265890778871979	0.842253105534818	0.842253105534818	false	false	false	true	false
322839ac-42cc-4e99-b033-9dcfb9dbab5d	2026-08-18 15:17	2026-08-18 15:17	2026-08-18 15:17	HIMS	HIMS271217C00100000	call	100.0000	2027-12-17	2.5000	2.5000	3.1000	27.7850	24749.00	0.00	24749.00	99	7	100	4207	0.0237699072973615	0.865507046382216	0.865507046382216	true	false	false	true	false
9225ecba-7086-4ec9-9787-2754e21ad832	2026-08-18 15:13	2026-08-18 15:13	2026-08-18 15:13	HIMS	HIMS261016C00028000	call	28.0000	2026-10-16	3.1000	2.9900	3.1500	27.8000	18290.00	17360.00	930.00	59	8	65	408	0.159313725490196	0.694625695888499	0.700282016518252	true	false	false	true	false
f8961426-752c-427f-acbe-ce86e2c5801d	2026-08-18 15:02	2026-08-18 15:01	2026-08-18 15:01	HIMS	HIMS270219C00028000	call	28.0000	2027-02-19	6.1500	6.1500	6.4000	27.8700	57195.00	0.00	57195.00	93	5	135	206	0.655339805825243	0.764542552358993	0.764542552358993	false	false	false	true	false
cb563bd7-d778-4922-b769-01bf5e2c3666	2026-08-18 14:35	2026-08-18 14:35	2026-08-18 14:35	HIMS	HIMS260821C00028500	call	28.5000	2026-08-21	0.5000	0.4800	0.5100	27.9150	20000.00	20000.00	0.00	400	10	1632	882	1.85034013605442	0.73862548486394	0.73862548486394	false	false	false	true	false
4a3f3a68-5f6a-4605-9a6b-c7d3c9063ed6	2026-08-18 14:11	2026-08-18 14:11	2026-08-18 14:11	HIMS	HIMS260821P00025000	put	25.0000	2026-08-21	0.0400	0.0300	0.0500	27.8200	10000.00	8700.00	1300.00	2500	9	3099	6012	0.515469061876248	0.735011488676501	0.735011488676501	false	false	false	true	false
130bcf67-5dab-4f9f-9115-dc0d236531be	2026-08-18 13:44	2026-08-18 13:44	2026-08-18 13:44	HIMS	HIMS261120P00022000	put	22.0000	2026-11-20	1.5000	1.4400	1.5700	27.8450	48900.00	150.00	48750.00	326	8	334	331	1.00906344410876	0.761776970733543	0.761776970733543	false	false	false	true	false