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:sector = Healthcare×ticker = BMRN×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

d2596710-e017-42a5-b805-a45cb5972286	2026-08-18 12:38	2026-08-18 12:38	2026-08-18 12:38	BMRN	BMRN260821P00067500	put	67.5000	2026-08-21	1.1500	1.1500	1.2500	68.0350	23230.00	0.00	7360.00	202	50	1030	295	3.49152542372881	0.57567753835131	0.57567753835131	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	12855233335.00	2026-10-26	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
093d9f4a-9398-488f-bc4e-d8117b492bcb	2026-08-18 13:17	2026-08-18 13:17	2026-08-18 13:17	BMRN	BMRN260821P00065000	put	65.0000	2026-08-21	0.4500	0.3000	0.6500	67.6300	44998.00	44728.00	225.00	1000	47	1011	1757	0.575412635173591	0.596644526897522	0.580507839957485	true	false	false	true
66e1afc6-65c9-4a1b-bc86-eabe4d9d2f2c	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	1.9500	1.9500	2.2000	64.5500	86598.00	0.00	86598.00	444	39	444	330	1.34545454545455	0.339303595965775	0.339303595965775	false	false	false	true
8adaa32d-db15-426b-b232-736d0a66e927	2026-08-28 13:27	2026-08-28 13:27	2026-08-28 13:27	BMRN	BMRN261016P00060000	put	60.0000	2026-10-16	1.5500	1.5500	1.9000	64.2550	16585.00	0.00	16585.00	107	34	118	413	0.285714285714286	0.370019342850863	0.370019342850863	false	false	false	true
514f66f2-b54d-4001-bf46-cc02f93e5b6b	2026-08-28 15:24	2026-08-28 15:24	2026-08-28 15:24	BMRN	BMRN261016P00060000	put	60.0000	2026-10-16	1.4500	1.4500	1.9000	64.4400	18995.00	0.00	18995.00	131	30	249	413	0.602905569007264	0.363443634071917	0.363443634071917	false	false	false	true
1e6daa94-6c99-4cef-9a3d-93a4ac6024eb	2026-08-28 15:43	2026-08-28 15:43	2026-08-28 15:43	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.0000	1.7500	2.0500	64.4500	14400.00	14400.00	0.00	72	21	798	330	2.41818181818182	0.355351139828977	0.355351139828977	false	false	false	true
c3d6a60c-0116-4ecd-bc61-c94332146eb9	2026-08-28 15:43	2026-08-28 15:43	2026-08-28 15:43	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.0000	1.8500	2.0000	64.4700	13200.00	13200.00	0.00	66	16	864	330	2.61818181818182	0.353767770981134	0.353767770981134	false	false	false	true
843c15e0-cd6f-438b-a0de-1d2c2617dfaa	2026-08-28 15:43	2026-08-28 15:43	2026-08-28 15:43	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.0000	1.6000	2.0000	64.4500	13199.00	13199.00	0.00	66	17	941	330	2.85151515151515	0.355351139828977	0.355351139828977	false	false	false	true
afeb6721-5e57-4c43-a0de-492f3eed345a	2026-08-28 15:50	2026-08-28 15:50	2026-08-28 15:50	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.1500	1.6000	2.1500	64.4300	11610.00	11610.00	0.00	54	9	1090	330	3.3030303030303	0.381271800280144	0.381271800280144	false	false	false	true
d84aa105-a3c9-445e-928a-1f686177932c	2026-08-28 15:55	2026-08-28 15:55	2026-08-28 15:55	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.3500	1.5500	2.8500	64.5100	14330.00	14095.00	235.00	61	19	1206	330	3.65454545454545	0.408502784935743	0.407294639583486	false	false	false	true
a9df0b9e-d5b3-4761-ab0b-2c99d273fd59	2026-08-28 15:55	2026-08-28 15:55	2026-08-28 15:55	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.3500	1.5500	2.3500	64.4900	14100.00	14100.00	0.00	60	6	1282	330	3.88484848484848	0.40890512241574	0.40890512241574	false	false	false	true
c3cc6380-b70f-4b0a-986e-02a281027be5	2026-08-28 15:55	2026-08-28 15:55	2026-08-28 15:55	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.3500	1.5500	2.3500	64.5050	14100.00	14100.00	0.00	60	5	1342	330	4.06666666666667	0.407697544109445	0.407697544109445	false	false	false	true
742d8d55-88de-474a-88a5-e74af9ee3e47	2026-08-28 15:55	2026-08-28 15:55	2026-08-28 15:55	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.3500	1.5500	2.3500	64.4700	14100.00	14100.00	0.00	60	5	1402	330	4.24848484848485	0.410512599749836	0.410512599749836	false	false	false	true
3a21e3b6-bffb-493c-869a-a7b5d207af58	2026-08-28 15:55	2026-08-28 15:55	2026-08-28 15:55	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.3500	1.5500	2.3500	64.4700	14100.00	14100.00	0.00	60	6	1522	330	4.61212121212121	0.410512599749836	0.410512599749836	false	false	false	true
1099506c-0d0b-4742-ba72-c40059d53b8b	2026-08-28 15:55	2026-08-28 15:55	2026-08-28 15:55	BMRN	BMRN260918C00065000	call	65.0000	2026-09-18	2.3500	1.5500	2.3500	64.4700	14100.00	14100.00	0.00	60	5	1462	330	4.43030303030303	0.410512599749836	0.410512599749836	false	false	false	true
c184bcf2-b95d-4924-89e9-9330e6d88d74	2026-09-04 13:01	2026-09-04 13:01	2026-09-04 13:01	BMRN	BMRN261016P00065000	put	65.0000	2026-10-16	2.5000	2.2000	2.9000	66.3200	13500.00	0.00	13500.00	54	5	59	441	0.133786848072562	0.365962490454232	0.365962490454232	false	false	false	true
492b65e8-77f7-4d92-a3ff-18c1d0df6819	2026-09-04 15:45	2026-09-04 15:44	2026-09-04 15:44	BMRN	BMRN261016P00065000	put	65.0000	2026-10-16	2.3000	2.3000	2.7500	66.5500	16100.00	0.00	16100.00	70	19	135	441	0.306122448979592	0.353237506591621	0.353237506591621	false	false	false	true
8769447f-aee1-48d2-9822-3511fd8e622f	2026-09-09 14:44	2026-09-09 14:44	2026-09-09 14:44	BMRN	BMRN261016C00070000	call	70.0000	2026-10-16	1.2000	0.9500	1.4500	65.2500	24840.00	11520.00	13320.00	207	66	211	288	0.732638888888889	0.339191015443967	0.339191015443967	true	false	false	true
dd15728c-554d-4221-9577-8dd1ba0ac545	2026-09-10 14:02	2026-09-10 14:01	2026-09-10 14:01	BMRN	BMRN270115P00062500	put	62.5000	2027-01-15	4.0000	4.0000	4.3000	65.3000	14400.00	0.00	14400.00	36	14	36	96	0.375	0.376183420722223	0.376183420722223	false	false	false	true
377934a7-4cd4-4f08-8fcf-2727e723ab34	2026-09-10 14:55	2026-09-10 14:55	2026-09-10 14:55	BMRN	BMRN270115C00077500	call	77.5000	2027-01-15	2.0500	1.8500	2.0500	65.4000	62925.00	49610.00	400.00	307	15	308	383	0.804177545691906	0.36415845062784	0.360198981574213	false	false	false	true
e5a560ac-858a-4ee1-9088-36a48281a796	2026-09-10 14:56	2026-09-10 14:55	2026-09-10 14:55	BMRN	BMRN270115C00077500	call	77.5000	2027-01-15	2.0000	1.9500	2.0000	65.2900	19600.00	19600.00	0.00	98	5	451	383	1.17754569190601	0.36249827209635	0.36249827209635	false	false	false	true
e976faf1-d004-438f-aa91-105d02e9337e	2026-09-14 10:13	2026-09-14 10:13	2026-09-14 10:13	BMRN	BMRN270115P00070000	put	70.0000	2027-01-15	7.5000	6.5000	8.0000	65.9500	41250.00	6000.00	35250.00	55	7	55	115	0.478260869565217	0.373666146519023	0.373666146519023	false	false	false	true
f378ca77-b8d0-4eef-9b05-eb525276a15c	2026-09-14 15:49	2026-09-14 15:49	2026-09-14 15:49	BMRN	BMRN270115P00060000	put	60.0000	2027-01-15	2.5500	2.5500	2.7500	66.0000	101506.00	0.00	101506.00	398	45	411	1020	0.402941176470588	0.373024976201351	0.373024976201351	false	false	false	true
05aa1269-cbe7-4c27-906c-e6617afd97f8	2026-09-16 10:18	2026-09-16 10:18	2026-09-16 10:18	BMRN	BMRN270115P00057500	put	57.5000	2027-01-15	2.3500	2.3500	2.6000	64.0000	35720.00	0.00	35720.00	152	18	152	133	1.14285714285714	0.392085374578022	0.392085374578022	false	false	false	true
edc72a34-2602-444f-9520-9048d3a28340	2026-09-18 13:34	2026-09-18 13:34	2026-09-18 13:34	BMRN	BMRN261016C00072500	call	72.5000	2026-10-16	0.4000	0.2500	0.4000	64.6300	13518.00	13518.00	0.00	338	23	401	83	4.83132530120482	0.347954044032111	0.342699975136972	false	false	false	true
15910632-b59e-4c4e-a9d5-19f497ee6512	2026-09-22 09:40	2026-09-22 09:40	2026-09-22 09:40	BMRN	BMRN261120P00070000	put	70.0000	2026-11-20	7.5000	6.8000	7.6000	63.8400	11250.00	11250.00	0.00	15	12	15	0	0	0.376979349863282	0.376979349863282	true	false	false	true
a0083bae-218c-4439-ad97-c2fc226fdb3a	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	BMRN	BMRN261016C00062500	call	62.5000	2026-10-16	1.9000	1.9000	2.1000	61.9150	44089.00	0.00	44089.00	232	29	235	1354	0.173559822747415	0.346885125136737	0.346885125136737	false	false	false	true
d06b5867-e27c-40fd-9eb6-1ba18604f01c	2026-09-24 11:43	2026-09-24 11:43	2026-09-24 11:43	BMRN	BMRN261016C00065000	call	65.0000	2026-10-16	0.9000	0.7500	0.9000	61.4100	17910.00	17910.00	0.00	199	23	404	463	0.872570194384449	0.356747059344821	0.356747059344821	false	false	false	true
0fcfd3ba-0c4b-4bbb-a2a0-fc959d566e0c	2026-09-24 14:29	2026-09-24 14:28	2026-09-24 14:28	BMRN	BMRN270115P00057500	put	57.5000	2027-01-15	2.9000	2.9000	3.2000	61.4100	27550.00	0.00	27550.00	95	9	96	278	0.345323741007194	0.373319593441582	0.373319593441582	false	false	false	true
b89f4394-92d4-4e9d-8726-f1afe9cb091a	2026-09-25 12:43	2026-09-25 12:43	2026-09-25 12:43	BMRN	BMRN261016C00062500	call	62.5000	2026-10-16	1.2000	1.2000	1.6000	60.5900	12960.00	0.00	12960.00	108	12	445	1504	0.295877659574468	0.332891314657761	0.332891314657761	false	false	false	true
3c30f3c0-15e1-478f-8ca1-c4d78ab87884	2026-09-25 12:49	2026-09-25 12:48	2026-09-25 12:48	BMRN	BMRN270115P00052500	put	52.5000	2027-01-15	1.5500	1.5500	1.7000	60.5100	14105.00	0.00	14105.00	91	21	134	115	1.16521739130435	0.377433157187349	0.377433157187349	false	false	false	true