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

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

e3ebc11c-3060-4ab2-808d-eafead19800a	2026-08-20 14:05	2026-08-20 14:05	2026-08-20 14:05	ILMN	ILMN270115P00175000	put	175.0000	2027-01-15	9.8000	9.5000	9.9000	214.6700	22536.00	21556.00	980.00	23	11	23	14	1.64285714285714	0.525928593182922	0.525928593182922	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Healthcare	31439710000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
dec892ec-dc37-45af-9b7b-d655c3bad31f	2026-08-20 14:05	2026-08-20 14:05	2026-08-20 14:05	ILMN	ILMN270115P00170000	put	170.0000	2027-01-15	8.2000	8.1000	8.4000	214.6700	91020.00	82000.00	9020.00	111	29	113	30	3.76666666666667	0.522062114629195	0.522062114629195	false	false	false	true
d0459308-560b-4225-ac2f-cd92b41ab344	2026-08-20 14:05	2026-08-20 14:05	2026-08-20 14:05	ILMN	ILMN270115P00190000	put	190.0000	2027-01-15	14.3400	14.3000	14.5000	214.6700	243738.00	92158.00	151580.00	170	21	170	0	0	0.50899988437904	0.511178933917318	false	false	false	true	false
4b14cb50-126e-4e1c-8b26-34e89c4d435f	2026-08-20 14:05	2026-08-20 14:05	2026-08-20 14:05	ILMN	ILMN270115P00200000	put	200.0000	2027-01-15	18.5000	18.3000	18.5000	214.6700	103600.00	103600.00	0.00	56	9	62	4	15.5	0.508942707003334	0.508942707003334	false	false	false	true	false
1c3e2513-681f-43dc-8c99-9b1b7bdf1d20	2026-08-20 12:42	2026-08-20 12:42	2026-08-20 12:42	ILMN	ILMN261218C00220000	call	220.0000	2026-12-18	23.6000	23.6000	24.4000	215.3100	108560.00	0.00	106200.00	46	25	733	21	34.9047619047619	0.497736827140341	0.497736827140341	false	false	false	true
792a2aa2-c57c-4f51-86d0-6dc0c8855c52	2026-08-20 12:42	2026-08-20 12:41	2026-08-20 12:41	ILMN	ILMN261218C00220000	call	220.0000	2026-12-18	23.6000	23.6000	24.4000	215.6400	11800.00	0.00	11800.00	5	5	683	21	32.5238095238095	0.49406176339879	0.49406176339879	false	false	false	true
132d398a-4171-4ef6-b7e8-d0ed7f4d5c07	2026-08-20 12:41	2026-08-20 12:41	2026-08-20 12:41	ILMN	ILMN261218C00220000	call	220.0000	2026-12-18	23.6000	23.6000	24.4000	215.7500	21240.00	0.00	21240.00	9	7	663	21	31.5714285714286	0.492835146156514	0.492835146156514	false	false	false	true
4d2dfc38-36a3-4bd3-b92c-4d73e0618826	2026-08-20 12:40	2026-08-20 12:39	2026-08-20 12:39	ILMN	ILMN261218C00220000	call	220.0000	2026-12-18	23.6000	23.6000	24.5000	215.8050	101480.00	0.00	99120.00	43	43	640	21	30.4761904761905	0.492221532987428	0.492221532987428	false	false	false	true
902351d6-7913-4415-b25a-f8ba8ddef201	2026-08-20 12:39	2026-08-20 12:38	2026-08-20 12:38	ILMN	ILMN261218C00220000	call	220.0000	2026-12-18	23.2000	23.2000	24.0000	215.4800	32480.00	0.00	32480.00	14	13	597	21	28.4285714285714	0.487677698863304	0.487677698863304	false	false	false	true
a2a53b97-1035-4ab0-b5fd-fc2c3c4d86f1	2026-08-20 11:54	2026-08-20 11:54	2026-08-20 11:54	ILMN	ILMN270617P00210000	put	210.0000	2027-06-17	30.8000	29.3000	30.8000	217.8300	21560.00	12320.00	0.00	7	7	8	0	0	0.498365940895185	0.498365940895185	false	false	false	true	false
2324003f-b027-4865-89db-993bef70c7db	2026-08-20 11:29	2026-08-20 11:29	2026-08-20 11:29	ILMN	ILMN261218C00300000	call	300.0000	2026-12-18	5.2000	4.1000	5.2000	219.3200	37960.00	37960.00	0.00	73	24	76	0	0	0.490497735276121	0.490497735276121	false	false	false	true	false
76a34d2a-8fae-4721-8420-6eb790315bc1	2026-08-20 10:45	2026-08-20 10:45	2026-08-20 10:45	ILMN	ILMN261218P00195000	put	195.0000	2026-12-18	13.9300	13.8000	14.1000	211.5650	236859.00	105750.00	131109.00	170	30	170	7	24.2857142857143	0.478325899314184	0.47855786000222	false	false	false	true
486ff6bf-45be-4369-bfdb-12442faf742a	2026-08-20 10:45	2026-08-20 10:45	2026-08-20 10:45	ILMN	ILMN261218C00220000	call	220.0000	2026-12-18	20.6000	20.2000	20.7000	211.5650	80340.00	78280.00	2060.00	39	15	39	21	1.85714285714286	0.476922072456179	0.476922072456179	false	false	false	true
4dc1b2c9-22e3-4fe9-9947-84a6876964bd	2026-08-19 14:08	2026-08-19 14:08	2026-08-19 14:08	ILMN	ILMN260918C00190000	call	190.0000	2026-09-18	17.3700	17.0000	19.0000	202.2200	26055.00	14000.00	12055.00	15	9	224	301	0.744186046511628	0.437628613188523	0.418017459496564	false	false	false	true
d8933d49-4cb5-4052-9389-c80b6e6391a9	2026-08-19 12:26	2026-08-19 12:26	2026-08-19 12:26	ILMN	ILMN260918C00230000	call	230.0000	2026-09-18	2.8500	2.5000	2.9000	204.1200	22228.00	21943.00	285.00	78	25	215	190	1.13157894736842	0.453435302788564	0.453435302788564	false	false	false	true
29f5ddfd-395f-4852-aef1-f3ac55dd2830	2026-08-18 12:49	2026-08-18 12:49	2026-08-18 12:49	ILMN	ILMN260821P00190000	put	190.0000	2026-08-21	4.0000	3.0000	4.1000	188.3900	22010.00	2410.00	19600.00	55	7	55	667	0.0824587706146927	0.462535947664895	0.462535947664895	false	false	false	true