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:er_time = unknown×ticker = ALNY×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

b49fd93c-cb4c-401f-9ac1-255afb571fee	2026-08-17 14:51	2026-08-17 14:51	2026-08-17 14:51	ALNY	ALNY260918C00250000	call	250.0000	2026-09-18	3.2000	2.5000	3.2000	224.9000	17600.00	17600.00	0.00	55	10	205	1090	0.188073394495413	0.410470036783087	0.410470036783087	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	33450941409.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
fb580709-2f04-44ce-b4b1-4ba6d7256ed5	2026-08-18 15:40	2026-08-18 15:40	2026-08-18 15:40	ALNY	ALNY260918P00210000	put	210.0000	2026-09-18	3.4000	3.1000	3.9000	230.1350	54062.00	1360.00	52702.00	159	37	160	46	3.47826086956522	0.421422504829806	0.421422504829806	false	false	false	true
3b729d08-cf6d-49a0-988f-2a1156a63155	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	ALNY	ALNY261218C00290000	call	290.0000	2026-12-18	9.7000	9.2000	9.7000	239.4850	42680.00	42680.00	0.00	44	14	50	30	1.66666666666667	0.447025404429302	0.447025404429302	false	false	false	true
6dd90fcb-db32-4a13-8540-9d9e4d2e1aa2	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	ALNY	ALNY261218P00200000	put	200.0000	2026-12-18	9.2000	8.7000	9.2000	239.4850	33120.00	33120.00	0.00	36	9	56	25	2.24	0.49661650447766	0.49661650447766	false	false	false	true
ef4bbfbb-e87e-4ed3-a978-06c3366b35e9	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	ALNY	ALNY261218C00290000	call	290.0000	2026-12-18	9.6000	8.5000	9.6000	237.5800	111315.00	111315.00	0.00	116	42	171	30	5.7	0.456501259969493	0.456501259969493	false	false	false	true
f5f10dca-5afb-49fa-b520-1f82df8f72d6	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	ALNY	ALNY261218P00200000	put	200.0000	2026-12-18	10.0000	9.3000	10.1000	237.8400	10000.00	10000.00	0.00	10	10	80	25	3.2	0.507977973174997	0.507977973174997	false	false	false	true
52844220-13e8-4f15-af99-b7b63b814258	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	ALNY	ALNY261218P00200000	put	200.0000	2026-12-18	10.1000	6.5000	10.1000	237.9300	106050.00	106050.00	0.00	105	27	185	25	7.4	0.510949084301407	0.510949084301407	false	false	false	true
2bb53755-68bf-461c-81f6-106acf9b3786	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	ALNY	ALNY261218C00290000	call	290.0000	2026-12-18	9.8000	8.6000	9.8000	237.8400	28420.00	28420.00	0.00	29	6	201	30	6.7	0.459227389084293	0.459227389084293	false	false	false	true
42890a4b-67f0-4923-8e77-71aa612b6645	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	ALNY	ALNY261218P00200000	put	200.0000	2026-12-18	10.3000	7.7000	10.3000	237.9800	17510.00	17510.00	0.00	17	6	202	25	8.08	0.51617793577014	0.51617793577014	false	false	false	true
805eeb75-1f48-4125-bf85-8a7b410deb2b	2026-08-19 13:53	2026-08-19 13:53	2026-08-19 13:53	ALNY	ALNY260918C00270000	call	270.0000	2026-09-18	2.9600	2.5000	3.3000	241.2100	10080.00	8280.00	1800.00	34	5	40	26	1.53846153846154	0.419653727134667	0.413796605775521	false	false	false	true
6aeec0be-fc77-448a-98a0-549aaf491a0a	2026-08-19 14:15	2026-08-19 14:15	2026-08-19 14:15	ALNY	ALNY260918C00250000	call	250.0000	2026-09-18	8.4000	8.2000	8.8000	241.6500	25200.00	4200.00	21000.00	30	11	51	1278	0.039906103286385	0.417926126490201	0.420733855615068	true	false	false	true
04d3f349-984c-4963-b4d1-25bba607152b	2026-08-19 14:15	2026-08-19 14:15	2026-08-19 14:15	ALNY	ALNY260918C00250000	call	250.0000	2026-09-18	8.3000	8.2000	9.5000	241.7150	18260.00	0.00	11620.00	22	15	73	1278	0.0571205007824726	0.416033708736129	0.416033708736129	true	false	false	true
60d5a460-004c-4b96-8b92-78ca29625a41	2026-08-20 11:28	2026-08-20 11:28	2026-08-20 11:28	ALNY	ALNY261218P00185000	put	185.0000	2026-12-18	6.8000	6.8000	8.2000	233.8550	42160.00	0.00	42160.00	62	20	62	436	0.142201834862385	0.514164429596602	0.514164429596602	false	false	false	true
e5e836cb-f87a-4010-84d4-8ee43e489fc1	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	ALNY	ALNY260918P00220000	put	220.0000	2026-09-18	5.3000	5.3000	6.2000	234.1500	102293.00	0.00	102293.00	193	40	193	140	1.37857142857143	0.438839537158624	0.438839537158624	false	false	false	true
a92bc2fd-9707-454e-bd6a-3e96ba4dc446	2026-08-20 14:09	2026-08-20 14:09	2026-08-20 14:09	ALNY	ALNY261016C00250000	call	250.0000	2026-10-16	9.4000	9.4000	10.5000	233.3500	345922.00	0.00	345922.00	368	43	374	0	0	0.417678583430559	0.417678583430559	false	false	false	true
e3f8c328-1b69-4cf5-8093-445ca2b71055	2026-08-20 14:29	2026-08-20 14:29	2026-08-20 14:29	ALNY	ALNY270319C00250000	call	250.0000	2027-03-19	29.8600	28.0000	29.9000	231.9100	104520.00	74630.00	2980.00	35	10	135	12	11.25	0.499195694293296	0.498046762334661	false	false	false	true
7124ea99-21a4-497a-a440-34569ef37092	2026-08-20 14:36	2026-08-20 14:36	2026-08-20 14:36	ALNY	ALNY270319P00240000	put	240.0000	2027-03-19	37.2000	36.9000	37.3000	231.0300	81839.00	81839.00	0.00	22	7	40	13	3.07692307692308	0.505795029657071	0.505795029657071	false	false	false	true
aa693d13-b9f9-4544-a89d-92546cf8c681	2026-08-20 15:55	2026-08-20 15:55	2026-08-20 15:55	ALNY	ALNY260918C00230000	call	230.0000	2026-09-18	11.5000	11.5000	13.3000	229.4300	23000.00	0.00	23000.00	20	5	64	767	0.0834419817470665	0.443858149139531	0.443858149139531	true	false	false	true
facde944-626b-4791-9fa2-d1aa6efed044	2026-08-21 10:52	2026-08-21 10:52	2026-08-21 10:52	ALNY	ALNY261218P00195000	put	195.0000	2026-12-18	9.4600	6.7000	10.8000	235.0250	148566.00	144766.00	3800.00	157	37	157	0	0	0.512339545420224	0.522294997671103	true	false	false	true
ba23d607-7242-43e1-813f-405cf6171551	2026-08-21 10:52	2026-08-21 10:52	2026-08-21 10:52	ALNY	ALNY261218P00195000	put	195.0000	2026-12-18	9.5000	9.5000	10.8000	235.0250	15200.00	0.00	15200.00	16	6	173	0	0	0.522294997671103	0.522294997671103	false	false	false	true
3eee15aa-cced-4227-bb2c-e6ca1b895ef9	2026-08-21 10:52	2026-08-21 10:52	2026-08-21 10:52	ALNY	ALNY261218P00195000	put	195.0000	2026-12-18	9.5000	9.5000	9.7000	235.0250	21850.00	0.00	21850.00	23	5	202	0	0	0.522294997671103	0.522294997671103	false	false	false	true
3c997cb7-fae5-4f8a-bced-f152c88bc22b	2026-08-21 11:58	2026-08-21 11:58	2026-08-21 11:58	ALNY	ALNY261218P00195000	put	195.0000	2026-12-18	9.0000	9.0000	9.7000	237.5800	60301.00	0.00	60301.00	67	21	402	0	0	0.522701335858025	0.522701335858025	false	false	false	true
ccac29fa-7ebc-4af0-9106-203e41aac57a	2026-08-21 12:33	2026-08-21 12:33	2026-08-21 12:33	ALNY	ALNY261218P00195000	put	195.0000	2026-12-18	9.0000	9.0000	9.4000	238.3700	23400.00	0.00	23400.00	26	6	428	0	0	0.526819935358727	0.526819935358727	false	false	false	true
d550a570-a474-41f1-bec1-55d8be069d54	2026-08-21 14:44	2026-08-21 14:44	2026-08-21 14:44	ALNY	ALNY270115C00270000	call	270.0000	2027-01-15	18.8000	18.7000	18.8000	236.7200	48880.00	48880.00	0.00	26	11	26	12	2.16666666666667	0.492890238639965	0.492890238639965	false	false	false	true
5709b2b1-9a82-49e5-b484-053ff1aafc31	2026-08-21 14:44	2026-08-21 14:44	2026-08-21 14:44	ALNY	ALNY270115C00230000	call	230.0000	2027-01-15	35.4000	35.3000	35.4000	236.7200	130980.00	130980.00	0.00	37	13	37	41	0.902439024390244	0.513166933937928	0.513166933937928	false	false	false	true
488c8e84-5495-417d-bad1-5b96081d9ce5	2026-08-21 14:44	2026-08-21 14:44	2026-08-21 14:44	ALNY	ALNY270115C00280000	call	280.0000	2027-01-15	15.9000	15.7000	16.4000	236.7200	23850.00	17490.00	6360.00	15	6	15	3643	0.00411748558880044	0.490261442588993	0.490261442588993	false	false	false	true
486e5ab2-b40f-4d7a-b8b9-d5c88620d87b	2026-08-21 14:44	2026-08-21 14:44	2026-08-21 14:44	ALNY	ALNY270115C00240000	call	240.0000	2027-01-15	30.4400	30.3000	31.3000	236.7200	164400.00	85400.00	72940.00	54	17	58	100	0.58	0.507460507904649	0.507460507904649	false	false	false	true
26f4e411-b09d-4a57-9480-69eee1b64dcc	2026-08-25 10:00	2026-08-25 10:00	2026-08-25 10:00	ALNY	ALNY260918C00240000	call	240.0000	2026-09-18	10.2000	9.5000	10.2000	238.1500	12240.00	12240.00	0.00	12	12	12	511	0.0234833659491194	0.44298771194066	0.44298771194066	false	false	false	true
19b0f67b-05f0-48c0-984c-ef5b7400d321	2026-08-25 10:05	2026-08-25 10:05	2026-08-25 10:05	ALNY	ALNY260918C00240000	call	240.0000	2026-09-18	10.2000	9.8000	10.2000	238.3500	13260.00	13260.00	0.00	13	13	25	511	0.0489236790606654	0.438839009546204	0.438839009546204	false	false	false	true
65502c74-2afe-4e62-b5e8-b5f55ee95574	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	ALNY	ALNY260918C00240000	call	240.0000	2026-09-18	10.7000	9.9000	10.7000	239.6300	60970.00	1070.00	1050.00	57	10	99	511	0.193737769080235	0.432262189009505	0.424087027579958	false	false	false	true
13f3fe8c-cdc0-4e1f-9c31-33e2e0e29b0b	2026-08-25 11:42	2026-08-25 11:42	2026-08-25 11:42	ALNY	ALNY261016P00175000	put	175.0000	2026-10-16	0.8500	0.8500	1.2500	238.5200	16154.00	0.00	16154.00	190	41	191	2	95.5	0.51217304111513	0.51217304111513	false	false	false	true
21f6037f-6dd8-45de-b20a-e0ef808f87c6	2026-08-25 13:57	2026-08-25 13:57	2026-08-25 13:57	ALNY	ALNY260918P00250000	put	250.0000	2026-09-18	15.7200	14.6000	16.4000	240.0150	193330.00	34760.00	158570.00	123	33	448	185	2.42162162162162	0.41805998301873	0.41805998301873	false	false	false	true
ff3f0dd6-22d1-4208-988a-e0bea8569168	2026-08-26 10:16	2026-08-26 10:16	2026-08-26 10:16	ALNY	ALNY260918C00260000	call	260.0000	2026-09-18	3.3000	3.1000	3.8000	239.3400	130020.00	0.00	130020.00	394	1	396	333	1.18918918918919	0.416333576082742	0.416333576082742	false	true	false	true
f4b4d479-21d9-46c5-b6dc-4b3f3b3ab42b	2026-08-26 11:13	2026-08-26 11:12	2026-08-26 11:12	ALNY	ALNY261218P00270000	put	270.0000	2026-12-18	40.4000	40.4000	42.7000	241.4200	480760.00	0.00	480760.00	119	22	119	245	0.485714285714286	0.456825144155211	0.456825144155211	false	false	false	true
639cf3f3-bbf7-4fe4-b0fc-0f2f1331fd76	2026-08-26 11:19	2026-08-26 11:19	2026-08-26 11:19	ALNY	ALNY260918C00260000	call	260.0000	2026-09-18	4.1100	3.2000	5.4000	242.1900	18080.00	16820.00	1260.00	44	14	451	333	1.35435435435435	0.422443740758748	0.424922074833755	false	false	false	true
58c0a372-0324-4886-b693-7b0c9e9bc0af	2026-08-26 12:22	2026-08-26 12:22	2026-08-26 12:22	ALNY	ALNY260918P00220000	put	220.0000	2026-09-18	3.3000	3.1000	3.3000	241.3850	16498.00	16498.00	0.00	50	13	55	364	0.151098901098901	0.474575530413722	0.474575530413722	false	false	false	true
95c7ac61-1557-454b-be04-cc0d0156e294	2026-08-26 14:05	2026-08-26 14:05	2026-08-26 14:05	ALNY	ALNY260918C00260000	call	260.0000	2026-09-18	4.7000	4.4000	4.7000	241.4350	19740.00	19740.00	0.00	42	7	926	333	2.78078078078078	0.459687854110611	0.459687854110611	false	false	false	true
5eb88684-bb36-42fc-93d0-0eff1f793ada	2026-08-26 14:06	2026-08-26 14:06	2026-08-26 14:06	ALNY	ALNY260918C00270000	call	270.0000	2026-09-18	2.8500	1.8000	2.9000	241.3701	24791.00	24506.00	285.00	87	32	107	139	0.76978417266187	0.469602289930888	0.469602289930888	false	false	false	true
e332e3e9-8a3f-4da9-9fd2-57964a3024ff	2026-08-26 14:36	2026-08-26 14:36	2026-08-26 14:36	ALNY	ALNY261218P00200000	put	200.0000	2026-12-18	8.6000	8.6000	9.5000	241.5600	99762.00	0.00	99762.00	116	35	126	209	0.602870813397129	0.505453476700572	0.505453476700572	false	false	false	true
cc3ca17f-4e60-4275-87ab-8bb02eac6cd6	2026-08-26 15:33	2026-08-26 15:32	2026-08-26 15:32	ALNY	ALNY260918P00210000	put	210.0000	2026-09-18	2.5000	2.3500	2.5500	238.6100	27748.00	27498.00	0.00	111	21	122	212	0.575471698113208	0.524157935943033	0.524157935943033	false	false	false	true
d55d3f71-7108-4242-a991-92b326c04489	2026-08-26 15:39	2026-08-26 15:39	2026-08-26 15:39	ALNY	ALNY260918C00260000	call	260.0000	2026-09-18	4.3000	3.7000	4.3000	238.5000	16340.00	16340.00	0.00	38	9	1326	333	3.98198198198198	0.479851903497433	0.479851903497433	false	false	false	true
ef49e753-b5b5-419c-bd81-42a19bf4adf9	2026-08-27 10:32	2026-08-27 10:32	2026-08-27 10:32	ALNY	ALNY260918C00260000	call	260.0000	2026-09-18	3.3000	2.7500	3.4000	232.2800	24419.00	24089.00	330.00	74	24	172	1631	0.105456774984672	0.517006797080189	0.517006797080189	false	false	false	true
a56e54b1-7746-4ed8-ab1c-400f21252b7a	2026-08-27 10:33	2026-08-27 10:32	2026-08-27 10:32	ALNY	ALNY260918C00260000	call	260.0000	2026-09-18	3.4000	2.8500	3.5000	232.2800	40119.00	40119.00	0.00	118	32	294	1631	0.180257510729614	0.523066134251009	0.523066134251009	false	false	false	true
b85c8584-02ec-4dec-ab37-39fb563a9486	2026-08-27 10:33	2026-08-27 10:32	2026-08-27 10:32	ALNY	ALNY260918C00260000	call	260.0000	2026-09-18	3.4000	2.9500	3.6000	232.2800	12920.00	12920.00	0.00	38	14	333	1631	0.204169221336603	0.523066134251009	0.523066134251009	false	false	false	true
1d5b9fa3-455b-41da-8071-f49edca351cc	2026-08-27 11:35	2026-08-27 11:34	2026-08-27 11:34	ALNY	ALNY261218P00210000	put	210.0000	2026-12-18	14.2000	14.2000	14.7000	232.3100	53960.00	0.00	53960.00	38	9	82	37	2.21621621621622	0.507135083925199	0.507135083925199	false	false	false	true
0a41727a-d8bf-4cf4-8103-420883353ae0	2026-08-27 12:21	2026-08-27 12:21	2026-08-27 12:21	ALNY	ALNY260918C00240000	call	240.0000	2026-09-18	8.9000	8.9000	9.1000	232.9600	52510.00	0.00	52510.00	59	10	75	822	0.0912408759124088	0.513192177701334	0.513192177701334	false	false	false	true
cf5edd9a-959b-4412-b6df-99ae9ceeac16	2026-08-27 13:04	2026-08-27 13:04	2026-08-27 13:04	ALNY	ALNY260918C00260000	call	260.0000	2026-09-18	3.5000	3.0000	3.5000	232.6700	35000.00	35000.00	0.00	100	35	647	1631	0.396689147762109	0.524029172018733	0.524029172018733	false	false	false	true
f8079e71-172c-4807-9777-21d8bd2d581f	2026-08-28 09:32	2026-08-28 09:32	2026-08-28 09:32	ALNY	ALNY270319C00210000	call	210.0000	2027-03-19	45.2800	43.2000	47.0000	226.8900	226414.00	187534.00	38880.00	50	6	50	71	0.704225352112676	0.488662648712867	0.530364395523866	false	false	false	true
04186d95-232c-4837-8cb2-fea41032ca4a	2026-08-28 11:58	2026-08-28 11:58	2026-08-28 11:58	ALNY	ALNY261016P00190000	put	190.0000	2026-10-16	1.7600	1.7500	2.5000	237.0000	32827.00	0.00	32827.00	187	38	197	1	197	0.510410817755765	0.486076440266656	false	false	false	true
6f01d73c-98a4-4e30-8dfc-b2f2990be297	2026-08-28 15:24	2026-08-28 15:24	2026-08-28 15:24	ALNY	ALNY270319P00250000	put	250.0000	2027-03-19	39.2000	39.2000	40.1000	235.8700	129360.00	0.00	129360.00	33	7	33	219	0.150684931506849	0.489486384127019	0.489486384127019	false	false	false	true