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

df25cb31-b1eb-4674-9f60-7b516dfe4ade	2026-09-14 10:34	2026-09-14 10:34	2026-09-14 10:34	HIMS	HIMS260918C00031000	call	31.0000	2026-09-18	0.3000	0.3000	0.3200	28.7500	16500.00	0.00	16500.00	550	10	1385	2208	0.627264492753623	0.854185822303618	0.854405399684528	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-09-14T14:43:33.165845Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f593840e-9e97-42e6-a6e4-c6f6e7c22569	2026-09-14 10:31	2026-09-14 10:31	2026-09-14 10:31	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	1.2000	1.1700	1.2600	28.4800	60000.00	6600.00	17040.00	500	5	4177	10685	0.390921853065044	0.791844845014897	0.791844845014897	true	false	false	true
4a3d2491-bc45-451c-8289-def592809f29	2026-09-14 10:23	2026-09-14 10:23	2026-09-14 10:23	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	1.1300	1.1100	1.1800	28.0000	34239.00	226.00	34013.00	303	16	3308	10685	0.309592887225082	0.797463212530099	0.797463212530099	true	false	false	true
0192810f-95a3-4500-b518-df74f37432dc	2026-09-14 10:23	2026-09-14 10:23	2026-09-14 10:23	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	1.1300	1.1100	1.1800	28.0000	42940.00	9379.00	33561.00	380	16	3005	10685	0.281235376696303	0.792480747434376	0.797463212530099	false	false	false	true
48a31493-fad2-43c0-955d-6c1301be3eeb	2026-09-14 10:14	2026-09-14 10:14	2026-09-14 10:14	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	1.2000	1.1800	1.2200	28.0000	44400.00	22800.00	13680.00	370	17	2610	10685	0.244267664950866	0.809911549636695	0.81247066186496	true	false	false	true
22ebd863-425b-473b-a74d-a8ec07e9590d	2026-09-14 10:14	2026-09-14 10:14	2026-09-14 10:14	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	1.2000	1.1700	1.2200	28.0000	15600.00	9120.00	6120.00	130	10	2240	10685	0.209639681796912	0.807347095856834	0.807347095856834	true	false	false	true
f4b7b267-4b94-4b42-b731-6856667cca80	2026-09-14 10:01	2026-09-14 10:01	2026-09-14 10:01	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	1.4700	1.4600	1.4700	28.7950	10290.00	10290.00	0.00	70	16	1892	10685	0.177070659803463	0.857102036110837	0.857102036110837	false	false	false	true
c5a4e1a4-b1ef-490c-a306-c931c59f7c51	2026-09-14 09:51	2026-09-14 09:51	2026-09-14 09:51	HIMS	HIMS261120C00028000	call	28.0000	2026-11-20	4.2000	4.1000	4.2500	28.5350	12600.00	12600.00	0.00	30	14	1327	2932	0.452592087312415	0.796787477478003	0.796787477478003	true	false	false	true
e48e0d53-a559-4144-a181-91928554c5ec	2026-09-14 09:48	2026-09-14 09:48	2026-09-14 09:48	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	1.0400	1.0400	1.1400	28.2390	20800.00	0.00	20800.00	200	23	1452	10685	0.135891436593355	0.774387031020066	0.774387031020066	false	false	false	true
58e75358-7623-4008-9277-15320a72f4cf	2026-09-14 09:43	2026-09-14 09:43	2026-09-14 09:43	HIMS	HIMS261120C00028000	call	28.0000	2026-11-20	4.0800	4.0500	4.2000	28.0000	15895.00	8200.00	7695.00	39	9	702	2932	0.239427012278308	0.760671853967245	0.771231325650169	false	false	false	true
ad75b209-f67f-41c0-9182-d4a30cfc2b17	2026-09-14 09:43	2026-09-14 09:43	2026-09-14 09:43	HIMS	HIMS261120C00028000	call	28.0000	2026-11-20	4.1000	4.1000	4.2000	28.0000	13120.00	0.00	13120.00	32	7	649	2932	0.221350613915416	0.772873508175356	0.772873508175356	false	false	false	true
834930c4-aa6d-474d-8395-6b9bb41ca5e8	2026-09-14 09:42	2026-09-14 09:42	2026-09-14 09:42	HIMS	HIMS260925C00030000	call	30.0000	2026-09-25	0.8400	0.7850	0.8400	28.0000	11508.00	11508.00	0.00	137	17	324	1118	0.289803220035778	0.74171755769928	0.74171755769928	false	false	false	true
0e828da4-0ad1-46aa-89ba-c1a5523e1bf2	2026-09-14 09:42	2026-09-14 09:42	2026-09-14 09:42	HIMS	HIMS260918C00030000	call	30.0000	2026-09-18	0.4500	0.4300	0.4500	28.0000	38025.00	38025.00	0.00	845	42	1555	7234	0.214957146806746	0.872652960109693	0.872652960109693	false	false	false	true
fd8ca51a-64e0-4af2-941d-261dbfc9a59f	2026-09-14 09:42	2026-09-14 09:42	2026-09-14 09:42	HIMS	HIMS261120C00028000	call	28.0000	2026-11-20	4.1500	4.1000	4.2000	28.0000	32370.00	27805.00	2490.00	78	8	506	2932	0.172578444747613	0.797560640685365	0.797560640685365	false	false	false	true
342876e2-d982-4d5e-a699-2197b8290392	2026-09-14 09:42	2026-09-14 09:42	2026-09-14 09:42	HIMS	HIMS261120C00028000	call	28.0000	2026-11-20	4.1000	3.8500	4.1500	28.0000	50838.00	50838.00	0.00	124	20	428	2932	0.145975443383356	0.790747532154314	0.786514690022027	false	false	false	true
f1a7344f-633a-4ee6-97a5-4df344774e29	2026-09-14 09:39	2026-09-14 09:39	2026-09-14 09:39	HIMS	HIMS260918C00029500	call	29.5000	2026-09-18	0.5400	0.5400	0.6200	28.0000	40500.00	0.00	40500.00	750	8	1704	656	2.59756097560976	0.833630762735448	0.833630762735448	false	false	false	true
0cb70ab9-bd03-4ac4-9962-08d7ceaf9973	2026-09-14 09:38	2026-09-14 09:38	2026-09-14 09:38	HIMS	HIMS261120C00028000	call	28.0000	2026-11-20	4.1000	3.8000	4.1000	28.0000	26650.00	26650.00	0.00	65	12	134	2932	0.0457025920873124	0.795449297033474	0.792629126107139	false	false	false	true
0a82820e-5cbc-4393-875d-4649bcb528b4	2026-09-14 09:35	2026-09-14 09:34	2026-09-14 09:34	HIMS	HIMS260918C00029500	call	29.5000	2026-09-18	0.5000	0.4700	0.5400	28.1101	33250.00	25850.00	7400.00	665	9	804	656	1.22560975609756	0.868631144281363	0.871621741748821	false	false	false	true
c25d4b35-1998-4b70-9659-94647d0ba37c	2026-09-14 09:34	2026-09-14 09:34	2026-09-14 09:34	HIMS	HIMS261016C00028000	call	28.0000	2026-10-16	2.4000	2.2300	2.5300	28.1600	24000.00	24000.00	0.00	100	5	102	1409	0.0723917672107878	0.686165678963076	0.686165678963076	false	false	false	true
be0234ff-c2d4-4497-aaa7-ee7dc1f9ec81	2026-09-14 09:30	2026-09-14 09:30	2026-09-14 09:30	HIMS	HIMS261030C00027000	call	27.0000	2026-10-30	3.0000	2.7300	3.7000	27.4748	15300.00	0.00	15300.00	51	5	60	3	20	0.699040385671047	0.699040385671047	false	false	false	true
becca530-509b-4a91-a397-5fde278d3e18	2026-09-11 15:59	2026-09-11 15:58	2026-09-11 15:58	HIMS	HIMS261016C00030000	call	30.0000	2026-10-16	1.3000	1.2700	1.3000	27.4550	11050.00	11050.00	0.00	85	12	1489	2875	0.517913043478261	0.655878341606327	0.655878341606327	true	false	false	true
25b1e7c1-8916-41d1-83bb-10b91cb14796	2026-09-11 15:44	2026-09-11 15:44	2026-09-11 15:44	HIMS	HIMS260925C00029000	call	29.0000	2026-09-25	0.7800	0.7800	0.8000	27.4350	35568.00	0.00	35568.00	456	42	906	518	1.74903474903475	0.641660220992611	0.641660220992611	true	false	false	true
634c186d-92b9-466b-9398-b515cbfc0c66	2026-09-11 15:40	2026-09-11 15:39	2026-09-11 15:39	HIMS	HIMS261120P00023000	put	23.0000	2026-11-20	1.5500	1.5500	1.5900	27.3650	22320.00	0.00	22320.00	144	5	154	875	0.176	0.766476671853486	0.766476671853486	false	false	false	true
785d886f-cb35-43e1-b38e-c4a3c4d8dddb	2026-09-11 15:05	2026-09-11 15:05	2026-09-11 15:05	HIMS	HIMS261218C00060000	call	60.0000	2026-12-18	0.4100	0.3800	0.4100	27.2500	12546.00	12546.00	0.00	306	33	344	2950	0.116610169491525	0.923882289903065	0.923882289903065	false	false	false	true
6eb7a5eb-8c9c-4e81-819b-1e865c13f993	2026-09-11 14:38	2026-09-11 14:38	2026-09-11 14:38	HIMS	HIMS261218P00027000	put	27.0000	2026-12-18	3.9500	3.9000	4.0500	27.2450	13825.00	13430.00	395.00	35	5	44	423	0.104018912529551	0.757629725426187	0.757629725426187	false	false	false	true
705fd33d-f5c9-4ae4-aa93-5fd6d758407b	2026-09-11 14:18	2026-09-11 14:18	2026-09-11 14:18	HIMS	HIMS260925P00024000	put	24.0000	2026-09-25	0.2300	0.1800	0.2500	27.2600	13938.00	23.00	13915.00	606	26	638	744	0.85752688172043	0.617548896346893	0.620437341342764	false	false	false	true
a2ab730a-800f-413b-b773-79552efcabab	2026-09-11 12:48	2026-09-11 12:48	2026-09-11 12:48	HIMS	HIMS261120C00028000	call	28.0000	2026-11-20	3.6000	3.5000	3.6500	27.4100	10800.00	1800.00	9000.00	30	6	703	2257	0.311475409836066	0.790337638427004	0.790337638427004	false	false	false	true
0f2bbbc2-684f-446c-be0c-75ed98cb42dd	2026-09-11 12:16	2026-09-11 12:16	2026-09-11 12:16	HIMS	HIMS261218P00025000	put	25.0000	2026-12-18	2.8900	2.8900	2.9800	27.2850	30345.00	0.00	30345.00	105	9	108	3116	0.0346598202824134	0.754478865727413	0.754478865727413	false	false	false	true
726d8b81-216f-484b-8253-ff6bcc7cbc11	2026-09-11 11:32	2026-09-11 11:31	2026-09-11 11:31	HIMS	HIMS260925C00027500	call	27.5000	2026-09-25	1.3300	1.3300	1.3800	27.2900	12369.00	0.00	12369.00	93	19	127	6	21.1666666666667	0.6610129160382	0.6610129160382	true	false	false	true
b0f3b13e-6491-4dde-9749-29b7126f2c2b	2026-09-11 11:22	2026-09-11 11:22	2026-09-11 11:22	HIMS	HIMS260918P00027500	put	27.5000	2026-09-18	1.1000	1.1000	1.1500	27.3000	13860.00	0.00	13860.00	126	28	418	430	0.972093023255814	0.665968712402263	0.665968712402263	true	false	false	true
0091211e-cd3e-40b3-84a0-14fc7c7b5769	2026-09-11 11:16	2026-09-11 11:15	2026-09-11 11:15	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	0.7500	0.7500	0.7600	27.3200	19275.00	0.00	19275.00	257	60	6451	4557	1.41562431424183	0.674271547528705	0.68565093426888	true	false	false	true
51cf4b26-3925-4293-ba37-a14e351177e9	2026-09-11 11:12	2026-09-11 11:12	2026-09-11 11:12	HIMS	HIMS260918P00028000	put	28.0000	2026-09-18	1.3600	1.3600	1.4100	27.3750	14552.00	0.00	14552.00	107	19	305	2350	0.129787234042553	0.67354634816407	0.67354634816407	true	false	false	true
66c7cc09-6bc2-4526-8c8e-4631687b8fd7	2026-09-11 11:11	2026-09-11 11:11	2026-09-11 11:11	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	0.7500	0.7500	0.7800	27.3400	15525.00	0.00	15525.00	207	35	5608	4557	1.23063418915953	0.679970205625292	0.679970205625292	true	false	false	true
ccf26122-76dd-42e4-a6b3-141b1d0c6ee8	2026-09-11 11:05	2026-09-11 11:05	2026-09-11 11:05	HIMS	HIMS260911P00027500	put	27.5000	2026-09-11	0.3000	0.2600	0.3000	27.3500	21030.00	21030.00	0.00	701	46	1508	1573	0.958677685950413	0.837997495535601	0.837997495535601	false	false	false	true
64d98c2f-897a-4a36-b255-d3c7fd4afc8e	2026-09-11 11:05	2026-09-11 11:05	2026-09-11 11:05	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	0.7500	0.7500	0.8000	27.3500	13875.00	0.00	13875.00	185	26	5388	4557	1.18235681369322	0.677123146191778	0.677123146191778	false	false	false	true
981faf8f-7965-41a4-a15d-4741db4d17dc	2026-09-11 10:59	2026-09-11 10:59	2026-09-11 10:59	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	0.7500	0.7000	0.7500	27.3650	36750.00	36750.00	0.00	490	53	5036	4557	1.10511301294711	0.674271547528705	0.6728440278508	true	false	false	true
c15eac9d-c927-417b-b288-b382d038a242	2026-09-11 10:59	2026-09-11 10:59	2026-09-11 10:59	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	0.7200	0.7000	0.7300	27.3150	28224.00	288.00	0.00	392	85	4521	4557	0.992100065832785	0.666747048105026	0.666747048105026	true	false	false	true
7d921578-f9fe-4fe8-b179-04ad65068fe6	2026-09-11 10:57	2026-09-11 10:56	2026-09-11 10:56	HIMS	HIMS261016C00027000	call	27.0000	2026-10-16	2.4600	2.4500	2.6200	27.4150	15990.00	0.00	15990.00	65	17	177	364	0.486263736263736	0.655340032064885	0.655340032064885	true	false	false	true
21501408-38c5-481a-b4d0-787b40961817	2026-09-11 10:57	2026-09-11 10:56	2026-09-11 10:56	HIMS	HIMS261016C00028000	call	28.0000	2026-10-16	2.0200	2.0200	2.1100	27.4150	11918.00	0.00	11918.00	59	14	416	822	0.506082725060827	0.660960196303441	0.660960196303441	false	false	false	true
abadba93-fe1a-40c4-8a8b-696abb54225d	2026-09-11 10:04	2026-09-11 10:04	2026-09-11 10:04	HIMS	HIMS261120C00045000	call	45.0000	2026-11-20	0.6300	0.5900	0.8500	27.2000	13104.00	0.00	13104.00	208	8	615	1091	0.563703024747938	0.884004360850377	0.884004360850377	false	false	false	true
594df2f8-aa25-480c-9977-1cb664ba5e11	2026-09-11 10:03	2026-09-11 10:02	2026-09-11 10:02	HIMS	HIMS261120C00045000	call	45.0000	2026-11-20	0.6300	0.5600	0.7000	27.1483	13608.00	3276.00	2772.00	216	8	407	1091	0.373052245646196	0.886725299246153	0.886725299246153	false	false	false	true
ece2223e-27d1-4bcb-92f1-a7a6b11a2483	2026-09-11 10:00	2026-09-11 10:00	2026-09-11 10:00	HIMS	HIMS261120C00045000	call	45.0000	2026-11-20	0.6300	0.3600	0.6800	27.0900	11466.00	6804.00	4032.00	182	12	191	1091	0.175068744271311	0.88979920488559	0.88979920488559	false	false	false	true
5ebb2fad-7c26-41f0-a6b1-b724d9d39662	2026-09-11 09:58	2026-09-11 09:58	2026-09-11 09:58	HIMS	HIMS261120C00050000	call	50.0000	2026-11-20	0.4400	0.3700	0.4500	26.0000	23761.00	21561.00	2200.00	540	44	546	1581	0.345351043643264	0.935366536333657	0.940206488755081	true	false	false	true
6ba865ef-c202-4b0c-ae3e-b5d4c0befa80	2026-09-10 15:17	2026-09-10 15:17	2026-09-10 15:17	HIMS	HIMS270219C00033000	call	33.0000	2027-02-19	3.9000	3.7500	4.0500	27.6850	11310.00	2730.00	8580.00	29	8	56	616	0.0909090909090909	0.756997069464958	0.756997069464958	false	false	false	true
cb1839b8-7b5a-4076-a9c5-e86f5f5d27ee	2026-09-10 14:44	2026-09-10 14:44	2026-09-10 14:44	HIMS	HIMS261016C00034000	call	34.0000	2026-10-16	0.7000	0.6900	0.7000	27.5000	16100.00	16100.00	0.00	230	15	317	3671	0.0863524925088532	0.73439349721396	0.73439349721396	false	false	false	true
92a76cac-8192-479b-ba5b-fa83d27765f1	2026-09-10 14:19	2026-09-10 14:19	2026-09-10 14:19	HIMS	HIMS260918C00030000	call	30.0000	2026-09-18	0.4000	0.4000	0.4200	27.6100	12880.00	0.00	12880.00	322	31	965	5086	0.189736531655525	0.729871697945587	0.729871697945587	false	false	false	true
31a45069-9bea-4ab4-b5bc-63e6f3d78cca	2026-09-10 14:10	2026-09-10 14:10	2026-09-10 14:10	HIMS	HIMS270219C00036000	call	36.0000	2027-02-19	3.1500	2.9700	3.3500	27.6200	11340.00	2835.00	8505.00	36	6	36	111	0.324324324324324	0.761846272966478	0.761846272966478	false	false	false	true
6eb265c9-7317-46f9-8cc7-2382f1720ae2	2026-09-10 14:01	2026-09-10 14:01	2026-09-10 14:01	HIMS	HIMS270219C00037000	call	37.0000	2027-02-19	2.9700	2.9700	3.1000	27.7000	16929.00	0.00	16929.00	57	5	72	67	1.07462686567164	0.762743905198756	0.762743905198756	false	false	false	true
3279da97-bc9b-4608-909f-393415b3d159	2026-09-10 13:47	2026-09-10 13:46	2026-09-10 13:46	HIMS	HIMS260918C00028000	call	28.0000	2026-09-18	0.9800	0.9500	1.0200	27.6300	44100.00	37436.00	6664.00	450	5	3812	1965	1.93994910941476	0.697571592340222	0.697571592340222	false	false	false	true
6ec06304-9570-4059-a1ca-93d9f577abdd	2026-09-10 11:35	2026-09-10 11:35	2026-09-10 11:35	HIMS	HIMS261016P00027000	put	27.0000	2026-10-16	1.8800	1.8800	1.9200	27.9000	11280.00	0.00	11280.00	60	6	69	761	0.0906701708278581	0.673752836256617	0.685450631575704	true	false	false	true