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

d9ee2021-9c85-4128-ac51-d62c58fbf341	2026-08-21 11:46	2026-08-21 11:46	2026-08-21 11:46	HIMS	HIMS281215P00018000	put	18.0000	2028-12-15	4.3000	4.3000	4.3500	33.6900	43000.00	0.00	43000.00	100	7	1652	121	13.6528925619835	0.788806948082414	0.788806948082414	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-21T15:55:19.311132Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
50f56ad2-2325-4aec-a865-594be343292c	2026-08-21 11:46	2026-08-21 11:46	2026-08-21 11:46	HIMS	HIMS281215P00018000	put	18.0000	2028-12-15	4.3000	4.3000	4.3500	33.6800	43000.00	0.00	43000.00	100	12	1452	121	12	0.788691650063775	0.788691650063775	false	false	false	true
838e285c-10ed-435b-b399-16cd09bd1e06	2026-08-21 11:46	2026-08-21 11:46	2026-08-21 11:46	HIMS	HIMS281215P00018000	put	18.0000	2028-12-15	4.3000	4.3000	4.3500	33.6800	25800.00	0.00	25800.00	60	13	1252	121	10.3471074380165	0.788691650063775	0.788691650063775	false	false	false	true
bafdc487-3f91-4b39-893f-34b743bb356b	2026-08-21 11:34	2026-08-21 11:34	2026-08-21 11:34	HIMS	HIMS281215P00018000	put	18.0000	2028-12-15	4.3000	4.3000	4.3500	33.4700	43000.00	0.00	43000.00	100	19	882	121	7.28925619834711	0.786259220024924	0.786259220024924	false	false	false	true
6b8cad0b-5bee-4788-a839-f4d0cda51f5f	2026-08-21 11:33	2026-08-21 11:33	2026-08-21 11:33	HIMS	HIMS281215P00018000	put	18.0000	2028-12-15	4.3000	4.3000	4.3500	33.4700	43000.00	0.00	43000.00	100	16	482	121	3.98347107438017	0.786259220024924	0.786259220024924	false	false	false	true
12ddc89b-0a88-4c60-a702-01297638eed8	2026-08-21 11:10	2026-08-21 11:10	2026-08-21 11:10	HIMS	HIMS260828C00032500	call	32.5000	2026-08-28	2.0000	1.9700	2.1000	33.5000	10000.00	0.00	10000.00	50	5	215	600	0.358333333333333	0.785217549530904	0.785217549530904	false	false	false	true
1e8fb1d7-379c-40b7-9795-e98f6cc1ba89	2026-08-21 11:04	2026-08-21 11:04	2026-08-21 11:04	HIMS	HIMS261218C00045000	call	45.0000	2026-12-18	3.1500	3.1500	3.3000	33.5150	16695.00	0.00	16695.00	53	13	130	1018	0.12770137524558	0.842108973668534	0.842108973668534	false	false	false	true
a0d3f618-af64-46d9-8846-c0e77597fed2	2026-08-21 11:04	2026-08-21 11:04	2026-08-21 11:04	HIMS	HIMS261218C00045000	call	45.0000	2026-12-18	3.1500	3.1500	3.3500	33.5200	20160.00	0.00	2520.00	64	17	77	1018	0.0756385068762279	0.841855439180269	0.841855439180269	false	false	false	true
b698ad0c-9444-4065-bd19-c2a642ed3431	2026-08-21 10:56	2026-08-21 10:56	2026-08-21 10:56	HIMS	HIMS270219C00042000	call	42.0000	2027-02-19	5.0000	4.5500	5.0000	33.3300	34500.00	34500.00	0.00	69	6	69	28	2.46428571428571	0.80867163187975	0.80867163187975	false	false	false	true
1402bfc8-8836-40a9-b125-b0b93a4863d4	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	HIMS	HIMS270115C00040000	call	40.0000	2027-01-15	4.7500	4.5500	4.8000	33.3800	142975.00	142975.00	0.00	301	18	526	10586	0.0496882675231438	0.809891653177744	0.809891653177744	true	false	false	true
bbd82f09-ffa0-4396-b39b-3ac54fbc0df6	2026-08-21 10:50	2026-08-21 10:50	2026-08-21 10:50	HIMS	HIMS260918C00038000	call	38.0000	2026-09-18	1.3000	1.2400	1.3100	33.3400	30030.00	25740.00	0.00	231	28	384	1252	0.306709265175719	0.777627506962065	0.777627506962065	false	false	false	true
656f9ec2-09eb-4754-9c05-e98e746bced9	2026-08-21 10:46	2026-08-21 10:46	2026-08-21 10:46	HIMS	HIMS280121C00045000	call	45.0000	2028-01-21	9.7000	9.4000	9.7000	33.0360	24250.00	24250.00	0.00	25	7	27	1205	0.0224066390041494	0.808679583293877	0.808679583293877	false	false	false	true
c11cb413-43f3-4aa6-9a08-13e7c9b91ee9	2026-08-21 10:46	2026-08-21 10:46	2026-08-21 10:46	HIMS	HIMS261218C00055000	call	55.0000	2026-12-18	1.7200	1.5000	1.7200	32.9350	27176.00	27176.00	0.00	158	34	160	819	0.195360195360195	0.874565761905189	0.874565761905189	false	false	false	true
d6fe96ad-11fd-461b-9c80-9b9806b356bf	2026-08-21 10:42	2026-08-21 10:42	2026-08-21 10:42	HIMS	HIMS260828C00033000	call	33.0000	2026-08-28	1.3100	1.2800	1.3400	32.7690	14541.00	8777.00	524.00	111	6	1293	3463	0.373375685821542	0.779845553508093	0.77734347652621	false	false	false	true
e770e31c-16b0-43b0-b466-c47f80e9d19d	2026-08-21 10:42	2026-08-21 10:42	2026-08-21 10:42	HIMS	HIMS260828C00033000	call	33.0000	2026-08-28	1.3100	1.3000	1.3400	32.7500	11397.00	2620.00	8777.00	87	13	1137	3463	0.328328039272307	0.782563405731718	0.782563405731718	false	false	false	true
0ce39b29-9236-488b-80ed-99c725cb6928	2026-08-21 10:26	2026-08-21 10:25	2026-08-21 10:25	HIMS	HIMS261120P00033000	put	33.0000	2026-11-20	5.1500	4.9500	5.7500	33.0900	22660.00	22145.00	515.00	44	9	46	91	0.505494505494505	0.822655030456287	0.822655030456287	true	false	false	true
cab0a9ec-d2bf-4e19-a3e5-48a6df6ac270	2026-08-21 10:25	2026-08-21 10:25	2026-08-21 10:25	HIMS	HIMS260828C00036000	call	36.0000	2026-08-28	0.4700	0.4000	0.4800	32.8100	23500.00	23359.00	141.00	500	56	1130	1613	0.700557966522009	0.827468451640749	0.827468451640749	false	false	false	true
a5da8776-d104-49fe-acbe-42e7e9096100	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	HIMS	HIMS260911C00034000	call	34.0000	2026-09-11	1.6300	1.5800	1.8000	32.0500	16300.00	14507.00	1793.00	100	5	155	254	0.610236220472441	0.760724968759443	0.760724968759443	false	false	false	true
1ba4e8e4-91d0-4a3f-aa93-6e00eb7a9850	2026-08-20 15:28	2026-08-20 15:28	2026-08-20 15:28	HIMS	HIMS260918C00030000	call	30.0000	2026-09-18	4.0500	4.0500	4.1500	32.4220	18225.00	0.00	18225.00	45	5	1020	2857	0.357017850892545	0.744682415412028	0.744682415412028	false	false	false	true
c890964f-3955-498b-9f38-dcb4b8088158	2026-08-20 15:12	2026-08-20 15:12	2026-08-20 15:12	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	2.3100	2.2900	2.3600	32.2700	11550.00	0.00	11550.00	50	7	3005	7834	0.383584375797804	0.893120257415824	0.893120257415824	false	false	false	true
aa1d3de8-8814-4065-b700-5882ae8737da	2026-08-20 14:12	2026-08-20 14:11	2026-08-20 14:11	HIMS	HIMS260918C00040000	call	40.0000	2026-09-18	0.7900	0.7200	0.7900	31.9800	23700.00	23700.00	0.00	300	28	1181	11104	0.106358069164265	0.83749786230241	0.83749786230241	true	false	false	true
e2458fae-8391-4908-a732-a00dbea9f0e6	2026-08-20 13:16	2026-08-20 13:16	2026-08-20 13:16	HIMS	HIMS260821C00032000	call	32.0000	2026-08-21	0.7900	0.7300	0.7900	32.1800	10349.00	10349.00	0.00	131	9	3394	5884	0.57681849082257	1.0366122455331	1.0366122455331	true	false	false	true
1f33a2fa-9b3d-4101-8624-312d76cab709	2026-08-20 13:16	2026-08-20 13:16	2026-08-20 13:16	HIMS	HIMS260821C00031000	call	31.0000	2026-08-21	1.4400	1.3500	1.4400	32.1800	11808.00	11808.00	0.00	82	16	1585	4544	0.34881161971831	1.05197350018112	1.05197350018112	true	false	false	true
43c9b419-c82c-47ef-82f3-c934b3ffdd7d	2026-08-20 12:48	2026-08-20 12:48	2026-08-20 12:48	HIMS	HIMS260918P00028000	put	28.0000	2026-09-18	0.8000	0.8000	0.8400	32.8000	14080.00	0.00	14080.00	176	24	381	1853	0.205612520237453	0.740471783377132	0.742750173995037	false	false	false	true
a78c7bca-d98c-49c0-9e97-a11bc7052fcb	2026-08-20 12:31	2026-08-20 12:31	2026-08-20 12:31	HIMS	HIMS260821C00031500	call	31.5000	2026-08-21	1.1500	1.0500	1.1500	32.2400	10005.00	10005.00	0.00	87	17	846	2525	0.335049504950495	1.07914518889228	1.07914518889228	true	false	false	true
114197d0-b980-4a7f-809e-a6264a39d9ea	2026-08-20 12:14	2026-08-20 12:14	2026-08-20 12:14	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	2.0500	2.0400	2.1800	31.9601	10250.00	0.00	10250.00	50	5	2540	7834	0.324227725299974	0.993386147625788	0.993386147625788	false	false	false	true
697e33d6-2c37-4fd7-8def-bc4812d211df	2026-08-20 12:06	2026-08-20 12:05	2026-08-20 12:05	HIMS	HIMS280121P00020000	put	20.0000	2028-01-21	3.9500	3.7500	4.0500	32.1500	24885.00	395.00	24490.00	63	7	73	3589	0.0203399275564224	0.796664639216472	0.796664639216472	false	false	false	true
8adecbbc-1dfc-4b94-b3c1-44b242980535	2026-08-20 11:23	2026-08-20 11:23	2026-08-20 11:23	HIMS	HIMS260918C00030000	call	30.0000	2026-09-18	3.8000	3.8000	4.0000	32.0700	95001.00	0.00	45601.00	250	5	942	2857	0.329716485824291	0.738189795154675	0.744310161485637	false	false	false	true
b567c0db-2198-42fe-a1af-d67b6318ec05	2026-08-20 10:20	2026-08-20 10:20	2026-08-20 10:20	HIMS	HIMS260821C00035000	call	35.0000	2026-08-21	0.1600	0.1500	0.1800	32.4700	33776.00	0.00	33776.00	2111	46	4888	7791	0.627390578873059	1.29658553322536	1.30784578999565	false	false	false	true
bf45d394-2f55-4ad4-add8-c539bd8a4391	2026-08-20 10:03	2026-08-20 10:03	2026-08-20 10:03	HIMS	HIMS260821C00033500	call	33.5000	2026-08-21	0.7200	0.6600	0.7600	33.0500	17424.00	1152.00	16272.00	242	16	1116	886	1.25959367945824	1.33332453464599	1.33332453464599	true	false	false	true
ac2ca8f7-e52b-4dba-83c0-f3646fdf182f	2026-08-20 10:01	2026-08-20 10:01	2026-08-20 10:01	HIMS	HIMS260828C00038000	call	38.0000	2026-08-28	0.4400	0.3900	0.4400	33.0400	11132.00	11132.00	0.00	253	23	614	587	1.04599659284497	0.96283977505112	0.96283977505112	true	false	false	true
7288b05d-19a4-41a1-aa9f-0dd0538c8b02	2026-08-20 09:59	2026-08-20 09:59	2026-08-20 09:59	HIMS	HIMS260821C00032500	call	32.5000	2026-08-21	1.2200	1.1400	1.2200	32.9800	24400.00	24400.00	0.00	200	14	898	2360	0.380508474576271	1.40314966230478	1.40314966230478	false	false	false	true
f160881f-b03d-47a9-b5b7-26e4e7ad14ef	2026-08-20 09:55	2026-08-20 09:55	2026-08-20 09:55	HIMS	HIMS260918C00040000	call	40.0000	2026-09-18	1.0000	0.9500	1.0000	32.9800	15500.00	15500.00	0.00	155	17	422	11104	0.0380043227665706	0.83326235369012	0.831922963941194	true	false	false	true
2fa43f09-c1ae-4aa9-a373-50a8eeb2aff0	2026-08-20 09:55	2026-08-20 09:55	2026-08-20 09:55	HIMS	HIMS260821C00033000	call	33.0000	2026-08-21	0.9000	0.8700	0.9000	32.9800	18180.00	18180.00	0.00	202	10	2868	2857	1.00385019250963	1.3409607635521	1.31879869075871	false	false	false	true
5737515a-0c9c-4a1f-bd15-72b6a1f522a9	2026-08-20 09:54	2026-08-20 09:53	2026-08-20 09:53	HIMS	HIMS260821C00033000	call	33.0000	2026-08-21	0.8100	0.7300	0.8100	32.7450	14742.00	14742.00	0.00	182	16	2484	2857	0.869443472173609	1.35576074765245	1.35576074765245	false	false	false	true
8581b3b2-d35e-4054-adfc-25a661031434	2026-08-20 09:50	2026-08-20 09:50	2026-08-20 09:50	HIMS	HIMS261016C00040000	call	40.0000	2026-10-16	1.8500	1.5000	1.9000	32.8509	25715.00	4995.00	20720.00	139	19	163	2486	0.0655671761866452	0.788909755771953	0.788909755771953	false	false	false	true
9c07a483-90bf-4bb0-a341-da1c7699c470	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	HIMS	HIMS260821C00029500	call	29.5000	2026-08-21	3.4000	3.1000	3.5000	32.8400	20400.00	14280.00	6120.00	60	5	236	3194	0.073888541014402	1.62044863351697	1.32666725437559	false	false	false	true
4efdc962-aaf1-4089-90b8-ca481400f8cc	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	HIMS	HIMS260821C00030000	call	30.0000	2026-08-21	2.8300	2.8000	2.9800	32.7300	28281.00	0.00	28281.00	100	7	472	7834	0.0602501914730661	1.28591677661832	1.28591677661832	false	false	false	true
5682d1bf-624c-4f94-b9e5-91190cb1fdfe	2026-08-20 09:45	2026-08-20 09:44	2026-08-20 09:44	HIMS	HIMS260821C00034000	call	34.0000	2026-08-21	0.4700	0.4200	0.4700	32.6800	18800.00	18800.00	0.00	400	38	746	5026	0.148428173497811	1.42609921871796	1.42609921871796	true	false	false	true
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
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
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
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
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
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
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
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
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
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
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