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 = ILMN×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

615bc0fb-1feb-4803-8190-3b6eec7c0300	2026-09-15 14:42	2026-09-15 14:42	2026-09-15 14:42	ILMN	ILMN260918C00230000	call	230.0000	2026-09-18	2.1000	1.8000	3.2000	224.9400	10500.00	4200.00	6300.00	50	10	449	751	0.597869507323569	0.501172264228755	0.501172264228755	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	31439710000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
816bf78c-a102-4afe-aee7-dbb13ac78c45	2026-09-16 09:52	2026-09-16 09:52	2026-09-16 09:52	ILMN	ILMN260918C00230000	call	230.0000	2026-09-18	5.8900	5.3000	7.1000	232.6300	11200.00	9430.00	1770.00	19	5	99	887	0.111612175873732	0.648940354976488	0.633852595169259	true	false	false	true	false
85f1d05e-b184-4e5c-8a6a-498919b72db6	2026-09-16 15:30	2026-09-16 15:30	2026-09-16 15:30	ILMN	ILMN270115C00230000	call	230.0000	2027-01-15	27.8000	26.8000	29.5000	227.3600	606050.00	8340.00	594920.00	218	27	253	1427	0.17729502452698	0.527267476849696	0.528062576767511	false	false	false	true	false
493e2754-e6ac-445e-a48f-5b5bee86b070	2026-09-17 10:21	2026-09-17 10:20	2026-09-17 10:20	ILMN	ILMN261218P00260000	put	260.0000	2026-12-18	36.8000	35.7000	36.8000	239.7800	154550.00	150880.00	3670.00	42	16	42	0	0	0.548119199581311	0.548119199581311	false	false	false	true	false
8c7d8cb2-c1e3-4dec-a51a-ae9e77a964ca	2026-09-17 10:50	2026-09-17 10:50	2026-09-17 10:50	ILMN	ILMN270115C00340000	call	340.0000	2027-01-15	6.8000	6.0000	6.8000	240.7400	34000.00	34000.00	0.00	50	20	87	2	43.5	0.552160941076443	0.552160941076443	true	false	false	true	false
35b4080a-2bd9-4051-8abd-1009d862fee3	2026-09-17 10:51	2026-09-17 10:51	2026-09-17 10:51	ILMN	ILMN270115P00190000	put	190.0000	2027-01-15	8.2000	8.2000	9.4000	241.0800	54950.00	830.00	54120.00	67	14	67	173	0.38728323699422	0.555458835697187	0.555458835697187	false	false	false	true	false
1ad860be-e64a-4b0b-a2f4-4b90180f7901	2026-09-17 11:37	2026-09-17 11:36	2026-09-17 11:36	ILMN	ILMN261218C00320000	call	320.0000	2026-12-18	7.8000	6.5000	7.8000	245.9800	105300.00	105300.00	0.00	135	29	141	8	17.625	0.558230460939386	0.558230460939386	false	false	false	true	false
ecde2c43-437d-4ac6-bdd1-20ae73a8241b	2026-09-17 12:05	2026-09-17 12:05	2026-09-17 12:05	ILMN	ILMN270115C00300000	call	300.0000	2027-01-15	14.5100	14.5000	15.8000	244.2300	33370.00	1470.00	31900.00	23	6	40	59	0.677966101694915	0.55643338208599	0.563430484958129	false	false	false	true	false
4893adc6-bc2c-4e47-ab68-961060db68bc	2026-09-17 13:26	2026-09-17 13:25	2026-09-17 13:25	ILMN	ILMN260918C00240000	call	240.0000	2026-09-18	5.8000	5.8000	7.4000	243.1350	47560.00	0.00	47560.00	82	6	167	812	0.205665024630542	0.79773409153634	0.79773409153634	false	false	false	true	false
e9c95b97-077c-4634-9487-06bb94cfbd71	2026-09-17 15:50	2026-09-17 15:50	2026-09-17 15:50	ILMN	ILMN260918C00220000	call	220.0000	2026-09-18	23.5000	21.9000	23.5000	243.0000	58750.00	58750.00	0.00	25	6	42	375	0.112	1.10850324835312	1.10850324835312	false	false	false	true	false
262b986d-ec3e-41e8-8e38-3efb3a24a991	2026-09-18 14:18	2026-09-18 14:18	2026-09-18 14:18	ILMN	ILMN260918C00240000	call	240.0000	2026-09-18	1.4000	1.4000	1.6000	237.9000	61740.00	0.00	44800.00	441	56	720	787	0.914866581956798	1.73744035594214	1.73744035594214	false	false	false	true	false
7fdceb5d-ecf4-4772-90f9-306986241e23	2026-09-18 15:39	2026-09-18 15:38	2026-09-18 15:38	ILMN	ILMN260918C00240000	call	240.0000	2026-09-18	2.1000	1.5500	2.1000	238.5700	228056.00	228056.00	0.00	1086	41	2146	787	2.72681067344346	4.56580195913363	4.56580195913363	false	false	false	true	false
7c86e494-9c14-4d8c-8902-5f8b5fcc3854	2026-09-18 15:45	2026-09-18 15:45	2026-09-18 15:45	ILMN	ILMN260918C00240000	call	240.0000	2026-09-18	2.9500	2.9500	3.0000	239.7150	25075.00	0.00	18880.00	85	40	2336	787	2.96823379923761	6.11733770424828	6.11733770424828	false	false	false	true	false
6faf96d0-4e9e-4180-aaf3-a11457819868	2026-09-21 12:12	2026-09-21 12:12	2026-09-21 12:12	ILMN	ILMN261016C00300000	call	300.0000	2026-10-16	1.1500	1.1500	1.3000	243.5300	10120.00	0.00	10120.00	88	28	94	144	0.652777777777778	0.531461678502439	0.531461678502439	false	false	false	true	false
398e5ccc-2fc9-4245-8b8c-9fb040815b83	2026-09-22 09:46	2026-09-22 09:46	2026-09-22 09:46	ILMN	ILMN261016P00240000	put	240.0000	2026-10-16	13.0000	12.5000	13.2000	238.0000	13000.00	11700.00	1300.00	10	6	80	146	0.547945205479452	0.511116525132083	0.511116525132083	false	false	false	true	false
2a203401-f725-45b6-ba0d-a4fd803d17e6	2026-09-22 09:49	2026-09-22 09:49	2026-09-22 09:49	ILMN	ILMN261016P00240000	put	240.0000	2026-10-16	12.6000	11.4000	13.1000	238.8100	12600.00	7560.00	2520.00	10	5	120	146	0.821917808219178	0.503848572054408	0.503848572054408	false	false	false	true	false