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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

09947084-1988-4e32-ac38-e0de76e6742a	2026-09-02 11:50	2026-09-02 11:50	2026-09-02 11:50	ILMN	ILMN261016C00190000	call	190.0000	2026-10-16	25.3300	24.8000	25.8000	208.3765	37990.00	17750.00	0.00	15	8	30	24	1.25	0.49680713427483	0.49680713427483	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-09-02T16:19:14.278097Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f3b02cbd-bc68-434a-8108-19484da8e827	2026-09-01 14:24	2026-09-01 14:24	2026-09-01 14:24	ILMN	ILMN270115C00250000	call	250.0000	2027-01-15	12.5000	12.3000	13.1000	208.1800	38750.00	0.00	38750.00	31	9	41	83	0.493975903614458	0.50019411765978	0.499236551546305	true	false	false	true
e7bfe6ed-8902-45fd-b2dc-2689d67051ee	2026-08-31 15:32	2026-08-31 15:32	2026-08-31 15:32	ILMN	ILMN260918P00210000	put	210.0000	2026-09-18	7.9000	7.9000	8.5000	212.8500	10270.00	0.00	10270.00	13	5	62	40	1.55	0.504455164574545	0.504455164574545	false	false	false	true
35107461-38ad-4d06-8a74-8af673237856	2026-08-31 15:32	2026-08-31 15:31	2026-08-31 15:31	ILMN	ILMN260918P00210000	put	210.0000	2026-09-18	8.0000	8.0000	8.5000	212.4400	10400.00	0.00	10400.00	13	5	49	40	1.225	0.500409443069949	0.500409443069949	false	false	false	true
84e8b387-1ef9-4c6d-9216-47b23581ea81	2026-08-28 14:04	2026-08-28 14:04	2026-08-28 14:04	ILMN	ILMN260918P00220000	put	220.0000	2026-09-18	11.5000	10.2000	11.5000	216.7900	31044.00	31044.00	0.00	27	17	72	109	0.660550458715596	0.483002082206243	0.483002082206243	false	false	false	true
61f6cbab-aa08-4d38-b080-44a3c8194a45	2026-08-27 13:43	2026-08-27 13:43	2026-08-27 13:43	ILMN	ILMN260918C00230000	call	230.0000	2026-09-18	11.8000	10.2000	12.2000	231.8100	21240.00	21240.00	0.00	18	5	44	591	0.0744500846023689	0.469098730863069	0.469098730863069	false	false	false
0ef1ece5-caf4-4cec-b378-67aff8516280	2026-08-27 13:42	2026-08-27 13:42	2026-08-27 13:42	ILMN	ILMN260918C00240000	call	240.0000	2026-09-18	7.2100	6.3000	7.4000	231.2700	72085.00	72085.00	0.00	100	10	110	647	0.170015455950541	0.47113318610198	0.469769000793616	false	false	false	true
bdf47360-9ab9-471b-bad8-ac31d98776da	2026-08-26 15:45	2026-08-26 15:45	2026-08-26 15:45	ILMN	ILMN260918C00240000	call	240.0000	2026-09-18	5.1300	4.4000	5.4000	224.4600	51310.00	51310.00	0.00	100	9	205	522	0.39272030651341	0.472097844685271	0.47459843918646	false	false	false	true
b77d5304-a04e-4a2a-9781-60e9da176f29	2026-08-26 15:21	2026-08-26 15:21	2026-08-26 15:21	ILMN	ILMN260918C00230000	call	230.0000	2026-09-18	8.7000	8.2000	10.1000	224.6000	12180.00	870.00	11310.00	14	6	160	427	0.374707259953162	0.482167459511623	0.482167459511623	false	false	false
bbd2335d-6575-418d-9e1c-212a519a7077	2026-08-25 11:49	2026-08-25 11:49	2026-08-25 11:49	ILMN	ILMN260918P00230000	put	230.0000	2026-09-18	13.7000	13.2000	13.7000	224.4700	63020.00	63020.00	0.00	46	20	46	4	11.5	0.476036804960594	0.476036804960594	false	false	false	true
8a27a0b5-7e01-405c-818e-1e0a97b2288b	2026-08-21 15:38	2026-08-21 15:38	2026-08-21 15:38	ILMN	ILMN260918C00250000	call	250.0000	2026-09-18	2.5000	2.4000	2.8000	219.0900	23750.00	250.00	22750.00	95	20	205	508	0.403543307086614	0.465369000109106	0.465369000109106	true	false	false
c8daa313-1364-4cce-9226-c13b9f464683	2026-08-21 11:29	2026-08-21 11:28	2026-08-21 11:28	ILMN	ILMN261016P00200000	put	200.0000	2026-10-16	8.4000	8.4000	9.0000	216.4500	206642.00	0.00	206642.00	246	40	247	5	49.4	0.483465131176096	0.483465131176096	false	false	false	true
eea15bf8-57b8-44c4-991c-0c5d1f90b40c	2026-08-21 10:20	2026-08-21 10:20	2026-08-21 10:20	ILMN	ILMN260918P00200000	put	200.0000	2026-09-18	5.5000	5.5000	6.4000	211.6900	23100.00	0.00	23100.00	42	12	42	70	0.6	0.463484031003667	0.463484031003667	false	false	false	true
75041ba0-0d13-4dda-9e36-213e53cedc92	2026-08-20 15:32	2026-08-20 15:32	2026-08-20 15:32	ILMN	ILMN261218C00260000	call	260.0000	2026-12-18	10.9500	9.5000	12.5000	213.7150	10954.00	2202.00	8752.00	10	6	12	11	1.09090909090909	0.508299675191427	0.508299675191427	false	false	false
e54790b5-bde3-42fa-82fb-5c40815bc168	2026-08-20 14:05	2026-08-20 14:05	2026-08-20 14:05	ILMN	ILMN270115P00195000	put	195.0000	2027-01-15	16.2400	16.2000	16.5000	214.6700	38970.00	4950.00	34020.00	24	5	24	1	24	0.512647142611157	0.512647142611157	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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