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:ticker = HIMS×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	expirydate	price

a3ce2089-b70c-4970-9af4-fd542f0247e1	2026-08-20 10:59	2026-08-20 10:59	2026-08-20 10:59	HIMS	HIMS260904C00039000	call	39.0000	2026-09-04	0.5800	0.4500	0.5800	32.7000	28472.00	28418.00	54.00	491	42	562	106	5.30188679245283	0.896371455030289	0.874024864926561	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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-20T15:02:58.462752Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
df175fe8-0302-4ed1-b4b6-175093a415a5	2026-08-21 10:26	2026-08-21 10:25	2026-08-21 10:25	HIMS	HIMS260828C00033000	call	33.0000	2026-08-28	1.4800	1.4300	1.5300	33.0200	17482.00	5428.00	12054.00	118	11	870	3463	0.251227259601502	0.834798308477666	0.805590211786951	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
2a31e987-716a-4874-b98d-9901b0796f0a	2026-08-21 11:33	2026-08-21 11:33	2026-08-21 11:33	HIMS	HIMS281215P00018000	put	18.0000	2028-12-15	4.3100	4.3000	4.3500	33.4501	43084.00	868.00	42216.00	100	10	682	121	5.63636363636364	0.790057666496177	0.786027604957258	false	false	false	true	false
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	false
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	false
06a5479d-537b-403e-8c2c-67711d49c431	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.6884	15912.00	0.00	15912.00	37	11	1142	121	9.43801652892562	0.790803522889885	0.788788503630569	false	false	false	true	false
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	false
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	false
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
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	false
ac1d51ab-2ef8-44fe-9e60-dfa4592340cb	2026-08-21 11:53	2026-08-21 11:53	2026-08-21 11:53	HIMS	HIMS260828C00033000	call	33.0000	2026-08-28	1.8200	1.8200	1.8700	33.7083	32942.00	0.00	32942.00	181	12	2386	3463	0.688997978631245	0.773423758557613	0.773423758557613	false	false	false	true	false
2e7ebfa9-471f-4138-a694-205ffee0c048	2026-08-21 12:06	2026-08-21 12:06	2026-08-21 12:06	HIMS	HIMS260918C00034000	call	34.0000	2026-09-18	2.7500	2.5900	2.7500	33.6400	165000.00	165000.00	0.00	600	5	708	1568	0.451530612244898	0.772923871812211	0.772923871812211	false	false	false	true	false
1a4a665c-72f6-4c62-8881-e27b97c81b3f	2026-08-21 12:09	2026-08-21 12:09	2026-08-21 12:09	HIMS	HIMS260918C00034000	call	34.0000	2026-09-18	2.7900	2.6500	2.8000	33.7021	223495.00	85111.00	0.00	800	48	1508	1568	0.961734693877551	0.777527208359337	0.777527208359337	false	false	false	true	false
f0343654-71d6-42f3-9217-06f52cbbda6a	2026-08-21 12:09	2026-08-21 12:09	2026-08-21 12:09	HIMS	HIMS260918C00034000	call	34.0000	2026-09-18	2.8700	2.7000	2.8800	33.8550	229904.00	87552.00	142352.00	800	33	2308	1568	1.4719387755102	0.776993879729384	0.776993879729384	false	false	false	true	false
7c7de50d-1733-4948-8c87-18737ad03f37	2026-08-21 12:11	2026-08-21 12:11	2026-08-21 12:11	HIMS	HIMS260925C00040000	call	40.0000	2026-09-25	1.2700	1.2700	1.4000	33.9800	21082.00	0.00	21082.00	166	16	243	1905	0.12755905511811	0.757196533784771	0.757196533784771	false	false	false	true	false
6a32fc3b-069d-4d91-b673-86d6f8cb7f9d	2026-08-21 12:11	2026-08-21 12:11	2026-08-21 12:11	HIMS	HIMS260925C00039000	call	39.0000	2026-09-25	1.4400	1.4400	1.6000	33.9650	23907.00	0.00	579.00	166	8	177	171	1.03508771929825	0.743141295596268	0.7458010981293	false	false	false	true	false
2b19c815-c0dc-43f1-a31e-9e92c43ad117	2026-08-21 12:11	2026-08-21 12:11	2026-08-21 12:11	HIMS	HIMS260925C00041000	call	41.0000	2026-09-25	1.0500	1.0500	1.2100	33.9650	17430.00	0.00	17430.00	166	12	216	102	2.11764705882353	0.75144480291332	0.75144480291332	false	false	false	true	false
e8f0261a-96c1-466d-a65f-e422150e65e3	2026-08-21 12:12	2026-08-21 12:12	2026-08-21 12:12	HIMS	HIMS260918C00032000	call	32.0000	2026-09-18	3.8500	3.7500	3.9000	33.9400	13090.00	13090.00	0.00	34	6	227	1346	0.168647845468054	0.74735541293619	0.74735541293619	false	false	false	true	false
bc56067a-a0ab-4d5f-8556-a3d9d51835f6	2026-08-21 12:31	2026-08-21 12:31	2026-08-21 12:31	HIMS	HIMS280121C00045000	call	45.0000	2028-01-21	10.4000	10.0500	10.6000	34.1600	10400.00	9360.00	1040.00	10	6	43	1205	0.0356846473029046	0.810678339646643	0.810678339646643	false	false	false	true	false
16986b13-4c79-460e-9b3b-bd4f2f8c52b4	2026-08-21 12:33	2026-08-21 12:33	2026-08-21 12:33	HIMS	HIMS261016C00045000	call	45.0000	2026-10-16	1.4000	1.3200	1.4000	34.2400	38499.00	38360.00	0.00	275	37	337	1908	0.176624737945493	0.816470952129899	0.814119277723818	false	false	false	true	false
8dc97923-8d62-4014-a5ae-39aafa056ad2	2026-08-21 12:34	2026-08-21 12:34	2026-08-21 12:34	HIMS	HIMS261016C00045000	call	45.0000	2026-10-16	1.4400	1.3200	1.4400	34.2800	14084.00	14084.00	0.00	98	9	436	1908	0.228511530398323	0.824069325012847	0.823473885117071	true	false	false	true	false
ddb64455-5fda-4434-b551-aa5a9cb7cf2f	2026-08-21 12:37	2026-08-21 12:37	2026-08-21 12:37	HIMS	HIMS260911C00035000	call	35.0000	2026-09-11	2.3300	2.1700	2.3300	34.4250	139662.00	119014.00	0.00	600	17	667	2425	0.275051546391753	0.783075139865461	0.776168302698957	false	false	false	true	false
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	false