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

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

a9da71f0-5f03-45ab-9391-8f89952b520c	2026-09-16 14:54	2026-09-16 14:54	2026-09-16 14:54	IEF	IEF260918P00092000	put	92.0000	2026-09-18	1.0900	1.1100	1.1500	90.8700	41202.00	0.00	41202.00	378	5	3654	38654	0.0945309670409272	0.126987297475486	0.126987297475486	false	true	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41741256328.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
136a9904-4733-46c1-acef-b4388c9f3db6	2026-09-16 14:31	2026-09-16 14:31	2026-09-16 14:31	IEF	IEF260918P00092000	put	92.0000	2026-09-18	0.9000	0.9000	0.9600	91.0900	46170.00	0.00	46170.00	513	36	3276	38654	0.0847519014849692	0.0776460004966347	0.0776460004966347	false	false	false	true
b3b52ae7-8d7c-496b-903f-f0581d8bacd8	2026-09-16 14:31	2026-09-16 14:31	2026-09-16 14:31	IEF	IEF260918P00092000	put	92.0000	2026-09-18	0.9100	0.8900	0.9200	91.1000	22386.00	21476.00	0.00	246	6	1428	38654	0.0369431365447302	0.0990394758773288	0.0990394758773288	false	false	false	true
6ff88abb-f676-47c5-9459-7d0807983f34	2026-09-16 14:31	2026-09-16 14:31	2026-09-16 14:31	IEF	IEF260918P00092000	put	92.0000	2026-09-18	0.9000	0.8900	0.9200	91.1000	22680.00	21780.00	900.00	252	11	1170	38654	0.0302685362446319	0.0894688602606056	0.0894688602606056	false	false	false	true
e98f3367-0d83-4d77-978d-31172d4e9180	2026-09-16 14:31	2026-09-16 14:31	2026-09-16 14:31	IEF	IEF260918P00092000	put	92.0000	2026-09-18	0.9000	0.8800	0.9000	91.1000	21780.00	21780.00	0.00	242	6	918	38654	0.0237491592073265	0.0894688602606056	0.0894688602606056	false	false	false	true
98fa1e89-bd75-478a-a6c1-683f0d6eb915	2026-09-16 14:28	2026-09-16 14:28	2026-09-16 14:28	IEF	IEF260918P00092000	put	92.0000	2026-09-18	0.9000	0.8600	0.9000	91.1000	17460.00	990.00	0.00	194	8	676	38654	0.0174884876080095	0.0894688602606056	0.0894688602606056	false	false	false	true
2d69f599-72f0-4f46-b1a9-ccd71b4c4d02	2026-09-16 14:28	2026-09-16 14:28	2026-09-16 14:28	IEF	IEF260918P00092000	put	92.0000	2026-09-18	0.9000	0.8500	0.9000	91.1100	21510.00	21510.00	0.00	239	7	482	38654	0.0124696021110364	0.0982042171811732	0.0982042171811732	false	false	false	true
34e14daf-571a-4ca1-978a-21819c6f0616	2026-09-16 14:27	2026-09-16 14:26	2026-09-16 14:26	IEF	IEF260918P00092000	put	92.0000	2026-09-18	0.9000	0.8400	0.9000	91.1100	21690.00	21690.00	0.00	241	6	243	38654	0.00628654214311585	0.0982042171811732	0.0982042171811732	false	false	false	true
cd5d6a8c-b84c-4a5e-9166-05a176f63d81	2026-09-16 13:39	2026-09-16 13:39	2026-09-16 13:39	IEF	IEF260918C00091500	call	91.5000	2026-09-18	0.1500	0.1300	0.1500	91.1800	87240.00	87240.00	0.00	5816	44	6371	5641	1.12940967913491	0.101742013596276	0.101742013596276	false	false	false	true
480e592b-0fed-4c52-b69f-b41f60539dff	2026-09-16 13:18	2026-09-16 13:18	2026-09-16 13:18	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.3500	0.3500	0.3800	91.1450	17500.00	0.00	17500.00	500	22	18908	89373	0.211562776229958	0.05617898395066	0.05617898395066	false	false	false	true
f9da2c1a-a521-4395-a7ba-01d3701e1b3a	2026-09-16 13:06	2026-09-16 13:05	2026-09-16 13:05	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.3700	0.3700	0.3800	91.1450	24309.00	0.00	24309.00	657	27	18408	89373	0.205968245443255	0.0582291065495077	0.0582291065495077	false	false	false	true
a9d5e852-4bda-4387-bed2-14fc0635d4bd	2026-09-16 13:06	2026-09-16 13:05	2026-09-16 13:05	IEF	IEF261016P00091000	put	91.0000	2026-10-16	0.6400	0.6000	0.6400	91.1450	256000.00	256000.00	0.00	4000	48	4030	10191	0.395446963006574	0.0808820669547635	0.0808820669547635	false	false	false	true
8b35f556-ee6d-4ec4-b89d-529fa03e9f79	2026-09-16 12:41	2026-09-16 12:40	2026-09-16 12:40	IEF	IEF261218C00093000	call	93.0000	2026-12-18	0.5700	0.5400	0.5700	91.1250	64866.00	64866.00	0.00	1138	20	1202	20843	0.057669241471957	0.051433959049881	0.051433959049881	false	false	false	true
a0447938-17d1-4add-8c35-171808f99dc7	2026-09-16 12:27	2026-09-16 12:27	2026-09-16 12:27	IEF	IEF261002C00092000	call	92.0000	2026-10-02	0.2100	0.2100	0.2300	91.1099	39417.00	0.00	39417.00	1877	17	3015	295	10.2203389830508	0.064349814646463	0.064349814646463	false	false	false	true
01028f70-b03b-42ed-b895-6c662cc960c2	2026-09-16 10:56	2026-09-16 10:56	2026-09-16 10:56	IEF	IEF261009C00092000	call	92.0000	2026-10-09	0.2700	0.2500	0.2700	91.1000	27000.00	27000.00	0.00	1000	24	1001	156	6.41666666666667	0.0590873643206743	0.0590873643206743	true	false	false	true
3c202fae-70e8-4f8a-a44c-7c9fbbb73370	2026-09-16 10:10	2026-09-16 10:10	2026-09-16 10:10	IEF	IEF260918C00091000	call	91.0000	2026-09-18	0.3000	0.3000	0.3100	91.0400	29460.00	0.00	29460.00	982	15	1033	2265	0.4560706401766	0.100145756598147	0.100145756598147	false	false	false	true
ee7f262f-7790-488a-b48a-9a23f23cd180	2026-09-16 10:08	2026-09-16 10:08	2026-09-16 10:08	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.3300	0.3100	0.3300	91.0350	156684.00	156684.00	0.00	4748	48	16425	89373	0.183780336343191	0.0580358096846457	0.0580358096846457	false	false	false	true
dd9aed67-16d0-4de4-a4a8-c1dab8d0ddb8	2026-09-16 10:06	2026-09-16 10:06	2026-09-16 10:06	IEF	IEF261030P00090500	put	90.5000	2026-10-30	0.5500	0.5300	0.5500	91.0450	11000.00	11000.00	0.00	200	27	1000	0	0	0.0768727073359926	0.0768727073359926	false	false	false	true
bf4119b6-b5b1-4c17-b036-9239c1882c8c	2026-09-16 10:04	2026-09-16 10:04	2026-09-16 10:04	IEF	IEF261030P00090500	put	90.5000	2026-10-30	0.5500	0.5400	0.5500	91.0350	11000.00	11000.00	0.00	200	11	400	0	0	0.0765806811600569	0.0765806811600569	false	false	false	true
9d6ab1bc-47ed-41a3-aa23-89181ff21f9c	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.3300	0.3100	0.3300	91.0500	382800.00	382800.00	0.00	11600	5	11617	89373	0.129983328298256	0.0575081325554767	0.0575081325554767	false	false	false	true
52cb7b2c-a497-424e-8b90-cc161aad8cb5	2026-09-15 16:10	2026-09-15 16:09	2026-09-15 16:09	IEF	IEF260918P00095000	put	95.0000	2026-09-18	4.2100	4.1000	4.2500	90.0000	21050.00	21050.00	0.00	50	2	50	100	0.5	0.317500438222908	0.317500438222908	false	true	false	true
91ec4c94-e159-4d9a-ad56-e7bc215cfb05	2026-09-15 10:20	2026-09-15 10:20	2026-09-15 10:20	IEF	IEF261002C00091500	call	91.5000	2026-10-02	0.2800	0.2600	0.2800	90.8000	41496.00	41496.00	0.00	1482	26	2502	6	417	0.0640094376532202	0.0640094376532202	false	false	false	true
99ecf98d-2fde-4ddd-a58c-b0f21e2400bc	2026-09-15 10:19	2026-09-15 10:19	2026-09-15 10:19	IEF	IEF261002C00091500	call	91.5000	2026-10-02	0.2700	0.2500	0.2800	90.8050	27486.00	27459.00	0.00	1018	27	1019	6	169.833333333333	0.062376900645471	0.062376900645471	false	false	false	true
2f7baa25-94ac-46c6-8e5d-d78e3267c062	2026-09-15 09:44	2026-09-15 09:44	2026-09-15 09:44	IEF	IEF280121C00087000	call	87.0000	2028-01-21	6.2000	6.0500	6.2000	90.8000	52700.00	52700.00	0.00	85	10	100	76	1.31578947368421	0.0983294695952366	0.0983294695952366	false	false	false	true
c87a1f8d-e1fc-4ae2-afa1-9cf31567cf08	2026-09-15 09:36	2026-09-15 09:36	2026-09-15 09:36	IEF	IEF260925C00091000	call	91.0000	2026-09-25	0.4000	0.3700	0.4000	90.8400	30000.00	30000.00	0.00	750	7	750	210	3.57142857142857	0.0716950433809418	0.0716950433809418	false	false	false	true
a2dcdce9-dd4d-4330-bcda-0f3765ec935b	2026-09-14 14:46	2026-09-14 14:46	2026-09-14 14:46	IEF	IEF261218C00091000	call	91.0000	2026-12-18	1.2500	1.2500	1.3000	91.0800	125750.00	0.00	125750.00	1006	24	11839	4	2959.75	0.0365911564415849	0.0365911564415849	false	false	false	true
9a8e1086-b039-4c1c-94f6-12db83b6984d	2026-09-14 14:46	2026-09-14 14:46	2026-09-14 14:46	IEF	IEF261218P00091000	put	91.0000	2026-12-18	1.1600	1.1500	1.1700	91.0800	116696.00	116580.00	0.00	1006	20	4826	6555	0.736231884057971	0.0861190963489509	0.0861190963489509	false	false	false	true
72925457-2462-44be-ba69-33583d53c3a6	2026-09-14 14:45	2026-09-14 14:45	2026-09-14 14:45	IEF	IEF261218P00091000	put	91.0000	2026-12-18	1.1500	1.1200	1.1500	91.0950	115000.00	115000.00	0.00	1000	15	1098	6555	0.167505720823799	0.0858931793766965	0.0858931793766965	false	false	false	true
7b5e31ca-2202-4c77-8312-495f154e9e66	2026-09-14 14:41	2026-09-14 14:41	2026-09-14 14:41	IEF	IEF261218C00091000	call	91.0000	2026-12-18	1.3200	1.3200	1.3600	91.1097	297660.00	0.00	297660.00	2255	33	7367	4	1841.75	0.0396671295515444	0.0396671295515444	false	false	false	true
51826efe-6864-433f-9598-a42268d33aad	2026-09-14 13:54	2026-09-14 13:53	2026-09-14 13:53	IEF	IEF261218P00091000	put	91.0000	2026-12-18	1.1200	1.1200	1.1400	91.1350	10976.00	0.00	10976.00	98	22	98	6555	0.0149504195270786	0.085096093735809	0.085096093735809	false	false	false	true
031db83b-57dc-472a-8f7a-d746c7e42427	2026-09-14 11:16	2026-09-14 11:16	2026-09-14 11:16	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.3200	0.3100	0.3300	90.9700	13440.00	10720.00	64.00	420	25	876	53532	0.0163640439363371	0.0572576535086365	0.0572576535086365	true	false	false	true
62325085-7c1c-493a-93b5-9b94c6bb4ecd	2026-09-14 10:57	2026-09-14 10:57	2026-09-14 10:57	IEF	IEF260918C00091000	call	91.0000	2026-09-18	0.2900	0.2900	0.3000	90.9100	13514.00	0.00	13514.00	466	10	715	1531	0.467015022860875	0.0830659880047966	0.0830659880047966	false	false	false	true
4d2f51c3-122d-4dd5-b6fd-d90129a6750f	2026-09-11 15:20	2026-09-11 15:20	2026-09-11 15:20	IEF	IEF260918P00091000	put	91.0000	2026-09-18	0.3000	0.2900	0.3100	91.0248	28560.00	24060.00	0.00	952	22	4113	11339	0.362730399506129	0.0683329168140621	0.0683329168140621	false	false	false	true
8c70c888-d061-44f2-8a18-7dee9e2699c0	2026-09-11 15:01	2026-09-11 15:00	2026-09-11 15:00	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.3700	0.3200	0.3700	91.0000	74000.00	74000.00	0.00	2000	24	2022	49439	0.0408988854952568	0.0585625168552251	0.0585625168552251	false	false	false	true
1444395c-b970-48ac-937f-c52bd4110ba6	2026-09-11 14:42	2026-09-11 14:42	2026-09-11 14:42	IEF	IEF260918C00091500	call	91.5000	2026-09-18	0.1800	0.1600	0.1800	91.0236	18000.00	18000.00	0.00	1000	24	4950	75	66	0.0688868150784134	0.0688868150784134	false	false	false	true
9869cd64-5a91-41ed-97e7-7404cfaf017a	2026-09-11 14:41	2026-09-11 14:41	2026-09-11 14:41	IEF	IEF260918P00091000	put	91.0000	2026-09-18	0.2900	0.2600	0.3000	91.0200	22011.00	17661.00	0.00	759	27	3161	11339	0.278772378516624	0.0658940933676419	0.0658940933676419	false	false	false	true
88559916-09bd-47ad-94aa-30664fa9f861	2026-09-11 13:24	2026-09-11 13:24	2026-09-11 13:24	IEF	IEF261002P00090000	put	90.0000	2026-10-02	0.1900	0.1900	0.2000	91.1800	29678.00	0.00	29678.00	1562	18	1562	10	156.2	0.0765333356231817	0.0765333356231817	false	false	false	true
5b303861-116b-4ba2-b34c-90436d1c5dab	2026-09-11 12:08	2026-09-11 12:08	2026-09-11 12:08	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.4000	0.3700	0.4100	91.1635	40000.00	40000.00	0.00	1000	31	1034	52379	0.0197407357910613	0.0550403505344962	0.0550403505344962	false	false	false	true
914c3b7b-9ff3-48e1-b51c-1155ada13937	2026-09-11 12:01	2026-09-11 12:01	2026-09-11 12:01	IEF	IEF260918C00091500	call	91.5000	2026-09-18	0.2200	0.2000	0.2200	91.1750	22000.00	22000.00	0.00	1000	37	3376	75	45.0133333333333	0.0661148825720902	0.0661148825720902	false	false	false	true
360017c8-7bd9-45a5-a6e6-c133a144f8e3	2026-09-11 11:02	2026-09-11 11:02	2026-09-11 11:02	IEF	IEF260918C00091500	call	91.5000	2026-09-18	0.2400	0.2200	0.2400	91.2450	48000.00	48000.00	0.00	2000	44	2093	75	27.9066666666667	0.0645400277793692	0.0645400277793692	false	false	false	true
56dffd69-b81c-427d-8656-f830cf4f37b2	2026-09-11 10:29	2026-09-11 10:28	2026-09-11 10:28	IEF	IEF261218C00096000	call	96.0000	2026-12-18	0.1600	0.1500	0.1900	91.2550	73984.00	4000.00	69984.00	4624	49	4624	326	14.1840490797546	0.0637337443560077	0.0637337443560077	false	false	false	true
52a6ef7d-9909-49f0-a619-f6377b27b0cc	2026-09-11 10:27	2026-09-11 10:27	2026-09-11 10:27	IEF	IEF260918C00091000	call	91.0000	2026-09-18	0.5200	0.5200	0.5400	91.2650	34424.00	0.00	34424.00	662	17	1269	408	3.11029411764706	0.0652363392322751	0.0652363392322751	false	false	false	true
0d5ec363-e8cb-4a60-8d7c-43d2246483ef	2026-09-11 10:19	2026-09-11 10:19	2026-09-11 10:19	IEF	IEF260918P00091000	put	91.0000	2026-09-18	0.1800	0.1700	0.2000	91.3050	15534.00	0.00	13806.00	863	18	2358	11339	0.207954846106359	0.0661752862077937	0.0661752862077937	false	false	false	true
d993e034-b69a-488d-8fe6-388d56bd9197	2026-09-11 10:03	2026-09-11 10:03	2026-09-11 10:03	IEF	IEF260925P00091000	put	91.0000	2026-09-25	0.2700	0.2700	0.2900	91.2650	29592.00	0.00	29592.00	1096	27	1100	29	37.9310344827586	0.0621218875980189	0.0621218875980189	false	false	false	true
332d5760-d441-47cf-a306-4dd36b0ddcc0	2026-09-11 09:56	2026-09-11 09:56	2026-09-11 09:56	IEF	IEF260918P00091000	put	91.0000	2026-09-18	0.1900	0.1900	0.2100	91.0000	27246.00	0.00	27246.00	1434	17	1486	11339	0.131052120998324	0.0694416740259988	0.0694416740259988	false	false	false	true
97c3f182-f2e5-4f58-870f-63d87cbb5e9c	2026-09-11 09:31	2026-09-11 09:30	2026-09-11 09:30	IEF	IEF270115C00091000	call	91.0000	2027-01-15	1.7400	1.6800	1.7400	91.0000	32538.00	32538.00	0.00	187	12	1500	104	14.4230769230769	0.0296367213551656	0.0296367213551656	false	false	false	true
67af1d4d-07da-4b16-81e9-eca927ba2d6a	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	IEF	IEF270115C00091000	call	91.0000	2027-01-15	1.7300	1.7300	1.7400	91.0000	35811.00	0.00	35811.00	207	18	823	104	7.91346153846154	0.0284739666619062	0.0284739666619062	false	false	false	true
6e1527f3-2082-4631-85bf-8790b2dabe7f	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	IEF	IEF270115C00091000	call	91.0000	2027-01-15	1.7400	1.7400	1.7500	91.0000	34974.00	0.00	2436.00	201	15	564	104	5.42307692307692	0.0289470125539498	0.0289470125539498	false	false	false	true
6a284586-6007-4db9-9629-451c99edec5c	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	IEF	IEF270115C00091000	call	91.0000	2027-01-15	1.7300	1.6800	1.7300	91.0000	24739.00	24739.00	0.00	143	12	363	104	3.49038461538462	0.0281112239661114	0.0281112239661114	false	false	false	true
fd5369dc-8a50-4007-bc55-3fe4334cb43d	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	IEF	IEF270115C00091000	call	91.0000	2027-01-15	1.7300	1.6800	1.7300	91.0000	28199.00	28199.00	0.00	163	6	220	104	2.11538461538462	0.0284739666619062	0.0284739666619062	false	false	false	true