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 = 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
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
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
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
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
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
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
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
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
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
3d458cd5-30f1-4e6b-8d73-42f1c5ba1b0a	2026-09-01 11:46	2026-09-01 11:45	2026-09-01 11:45	ALNY	ALNY260918P00230000	put	230.0000	2026-09-18	4.5000	4.2000	4.5000	239.7700	11250.00	11250.00	0.00	25	5	28	847	0.0330578512396694	0.428571731324565	0.428571731324565	false	false	false	true
c066caa1-bb4d-4334-9101-80290deacd26	2026-09-01 15:34	2026-09-01 15:34	2026-09-01 15:34	ALNY	ALNY261016P00220000	put	220.0000	2026-10-16	4.5000	3.7000	4.5000	246.8900	10800.00	10800.00	0.00	24	8	513	3	171	0.44062752534111	0.44062752534111	true	false	false	true
ac6118a5-5522-42a4-84a5-163c9a2aae9c	2026-09-01 15:53	2026-09-01 15:53	2026-09-01 15:53	ALNY	ALNY261016C00250000	call	250.0000	2026-10-16	12.9000	12.9000	13.0000	246.4550	20640.00	0.00	20640.00	16	5	502	380	1.32105263157895	0.405233729583539	0.405233729583539	false	false	false	true
25a3839c-0c31-41ea-9592-463c0bb87c1f	2026-09-02 09:49	2026-09-02 09:49	2026-09-02 09:49	ALNY	ALNY271217C00310000	call	310.0000	2027-12-17	41.0000	41.0000	42.8000	254.9300	102500.00	0.00	102500.00	25	5	30	2	15	0.473865166440989	0.473865166440989	false	false	false	true
85fa9a0e-7bea-4b6b-861e-15a56b77af66	2026-09-02 09:57	2026-09-02 09:57	2026-09-02 09:57	ALNY	ALNY260918P00250000	put	250.0000	2026-09-18	6.7900	5.5000	7.8000	255.2000	46840.00	40120.00	6040.00	69	10	71	918	0.0773420479302832	0.443364657241161	0.443364657241161	false	false	false	true
e7cee666-375c-44e8-ac70-0adab73491f2	2026-09-02 10:17	2026-09-02 10:17	2026-09-02 10:17	ALNY	ALNY260918C00270000	call	270.0000	2026-09-18	2.6000	2.6000	3.2000	251.8300	18980.00	0.00	18980.00	73	19	156	270	0.577777777777778	0.402058089216777	0.402058089216777	false	false	false	true
10b34000-0d83-4620-aa52-98010e9e54a1	2026-09-02 11:20	2026-09-02 11:20	2026-09-02 11:20	ALNY	ALNY260918C00270000	call	270.0000	2026-09-18	4.5000	4.1000	5.6000	259.6800	12150.00	9000.00	1350.00	27	7	306	270	1.13333333333333	0.386603655163411	0.386603655163411	true	false	false	true
5039c39f-a50c-4f09-8b25-95a596d67a4d	2026-09-02 11:30	2026-09-02 11:29	2026-09-02 11:29	ALNY	ALNY261016C00270000	call	270.0000	2026-10-16	15.9000	15.6000	15.9000	267.7200	14310.00	14310.00	0.00	9	6	9	38	0.236842105263158	0.441942470021171	0.441942470021171	false	false	false	true
9fea07fe-324d-4d67-8aed-4a0b57756b36	2026-09-02 14:51	2026-09-02 14:51	2026-09-02 14:51	ALNY	ALNY260918C00250000	call	250.0000	2026-09-18	19.0000	19.0000	20.7000	265.9800	38000.00	0.00	1900.00	20	20	164	1467	0.111792774369461	0.388614918610179	0.388614918610179	false	false	false	true
c356cba8-014b-4133-a2ee-ecc7cf02549d	2026-09-03 10:31	2026-09-03 10:31	2026-09-03 10:31	ALNY	ALNY260918C00260000	call	260.0000	2026-09-18	12.4000	12.3000	14.0000	265.1450	64482.00	0.00	64482.00	52	20	57	2786	0.02045944005743	0.44152924287088	0.44152924287088	false	false	false	true
15f92b6e-1113-4fb9-851c-1ae8869674e0	2026-09-03 12:17	2026-09-03 12:17	2026-09-03 12:17	ALNY	ALNY261218P00240000	put	240.0000	2026-12-18	14.5000	14.5000	15.5000	264.7100	134850.00	0.00	134850.00	93	37	97	56	1.73214285714286	0.481174845378654	0.481174845378654	false	false	false	true
a8249d70-fcf3-49ec-8266-c8231cc1afcc	2026-09-04 13:30	2026-09-04 13:29	2026-09-04 13:29	ALNY	ALNY260918P00250000	put	250.0000	2026-09-18	3.6000	3.4000	3.6000	262.8350	21600.00	18000.00	0.00	60	6	160	567	0.282186948853616	0.432010273475738	0.432010273475738	false	false	false	true