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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = IEF×

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

b78a1421-2c6a-4755-a716-e02268c4107f	2026-09-18 10:10	2026-09-18 10:10	2026-09-18 10:10	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.2300	0.2000	0.2300	90.9050	23000.00	23000.00	0.00	1000	20	1015	102806	0.00987296461296033	0.05382235193467	0.05382235193467	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42079995839.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
314e08f1-38a0-4860-9fcf-f5b14c4e24ac	2026-09-17 15:48	2026-09-17 15:48	2026-09-17 15:48	IEF	IEF260918P00094000	put	94.0000	2026-09-18	2.7500	2.7300	2.7800	91.2450	1376136.00	313536.00	1062600.00	5000	2	10000	8152	1.22669283611384	0.251869214727565	0.251869214727565	false	true	false	true
0ad869a0-de3d-4835-89d7-6c2ff846e904	2026-09-17 15:12	2026-09-17 15:12	2026-09-17 15:12	IEF	IEF280121P00094000	put	94.0000	2028-01-21	3.6100	3.5500	3.7500	91.2200	12648.00	2520.00	10128.00	35	6	35	1597	0.0219160926737633	0.119778494381288	0.12027596994427	false	false	false	true
1c4bf92b-b610-4591-b5f9-77b6ac4d218e	2026-09-17 11:14	2026-09-17 11:13	2026-09-17 11:13	IEF	IEF260925C00091000	call	91.0000	2026-09-25	0.4700	0.4500	0.4800	91.1750	34921.00	34921.00	0.00	743	18	743	1087	0.683532658693652	0.0608982965289081	0.0608982965289081	false	false	false	true
d0532200-0260-4a08-9232-7cb02fd3cab6	2026-09-17 11:07	2026-09-17 11:07	2026-09-17 11:07	IEF	IEF260925C00091500	call	91.5000	2026-09-25	0.1900	0.1800	0.2000	91.1140	65816.00	65797.00	0.00	3464	36	3467	164	21.140243902439	0.059406535865625	0.059406535865625	false	false	false	true
50c95735-b252-4dae-b7c9-c3f8cd7c51ab	2026-09-17 10:16	2026-09-17 10:16	2026-09-17 10:16	IEF	IEF261023P00092000	put	92.0000	2026-10-23	1.1800	1.1700	1.2100	91.1800	49560.00	0.00	49560.00	420	6	420	5	84	0.0818236409245013	0.0818236409245013	false	false	false	true
ab26c474-17c1-4b8d-893c-843f89a700a9	2026-09-17 09:56	2026-09-17 09:55	2026-09-17 09:55	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.7100	0.7000	0.7300	91.1850	238915.00	8875.00	230040.00	3365	37	9947	10303	0.965446957196933	0.0424933766911824	0.0424933766911824	false	false	false
347ae0d7-5d67-43b6-88fc-c828cb76c1e5	2026-09-17 09:39	2026-09-17 09:39	2026-09-17 09:39	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.6900	0.6900	0.7200	91.1501	44850.00	0.00	44850.00	650	13	6582	10303	0.638843055420751	0.0428278385327659	0.0428278385327659	false	false	false	true
958ccd2e-d6dc-4c0c-a1ee-a83f31d93fd0	2026-09-17 09:39	2026-09-17 09:39	2026-09-17 09:39	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.6900	0.6900	0.7200	91.1550	66999.00	0.00	66999.00	971	14	5932	10303	0.575754634572455	0.0424861298444209	0.0424861298444209	false	false	false	true
8904252f-5509-4f51-a0ee-36cda361df6e	2026-09-17 09:39	2026-09-17 09:39	2026-09-17 09:39	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.6900	0.6900	0.7200	91.1550	189957.00	0.00	189957.00	2753	38	4961	10303	0.481510239735999	0.0424861298444209	0.0424861298444209	false	false	false	true
17ffbb4c-31f5-4351-81c2-dd2599fd62c2	2026-09-17 09:38	2026-09-17 09:38	2026-09-17 09:38	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.7100	0.7100	0.7200	91.1500	112251.00	0.00	112251.00	1581	30	2207	10303	0.214209453557216	0.0449433018779705	0.0449433018779705	false	false	false	true
e48959bc-ffb6-4ef8-bcdd-96ae47135db6	2026-09-17 09:38	2026-09-17 09:37	2026-09-17 09:37	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.7200	0.7200	0.7500	91.1500	45072.00	0.00	18144.00	626	25	626	10303	0.0607590022323595	0.0459921412123309	0.0459921412123309	true	false	false	true
d3e600ab-7d34-4add-8975-da4f9409a29e	2026-09-17 09:35	2026-09-17 09:35	2026-09-17 09:35	IEF	IEF260918C00091000	call	91.0000	2026-09-18	0.2400	0.2400	0.2800	91.1700	162240.00	0.00	162240.00	6760	91	6851	7363	0.930463126443026	0.0730079019108134	0.0688096597284343	false	false	false	true
47718bf5-2474-4fc2-9965-ac332df1cd00	2026-09-16 15:35	2026-09-16 15:34	2026-09-16 15:34	IEF	IEF260918C00091000	call	91.0000	2026-09-18	0.1300	0.1100	0.1400	90.7509	59644.00	59644.00	0.00	4588	46	6662	2265	2.94128035320088	0.0844073802944842	0.0844073802944842	false	false	false	true
621856b6-d6a5-4455-8871-4ff940686aff	2026-09-16 15:31	2026-09-16 15:31	2026-09-16 15:31	IEF	IEF260918C00091000	call	91.0000	2026-09-18	0.1200	0.1000	0.1200	90.7500	10188.00	3168.00	0.00	849	19	2073	2265	0.91523178807947	0.0804701954230707	0.0804701954230707	true	false	false	true
0b61a302-fdbb-4fb5-84cc-49ae024c289f	2026-09-16 15:18	2026-09-16 15:18	2026-09-16 15:18	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.6000	0.6000	0.6100	90.7600	103140.00	0.00	103140.00	1719	5	8244	198	41.6363636363636	0.0552037921641429	0.0552037921641429	false	false	false	true
0a1d1aa8-7ba8-4a12-bb44-1b98fc114050	2026-09-16 15:18	2026-09-16 15:18	2026-09-16 15:18	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.6000	0.5700	0.6100	90.7550	113040.00	113040.00	0.00	1884	5	10188	198	51.4545454545455	0.0554531961028642	0.0554531961028642	false	false	false	true
7721fa9d-0b10-4d4b-8102-915ef027733e	2026-09-16 15:16	2026-09-16 15:16	2026-09-16 15:16	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.5900	0.5600	0.6000	90.7750	375830.00	352938.00	0.00	6370	59	6404	198	32.3434343434343	0.053486487700441	0.053486487700441	false	false	false	true
22c2361b-f095-4b41-bcda-9e276a13f78c	2026-09-16 15:14	2026-09-16 15:14	2026-09-16 15:14	IEF	IEF260925C00091000	call	91.0000	2026-09-25	0.2800	0.2800	0.3100	90.7700	21000.00	0.00	21000.00	750	9	905	1088	0.831801470588235	0.0608566288685008	0.0608566288685008	false	false	false	true
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
71f43a55-3abb-4887-85c7-07ac48c0204f	2026-09-16 14:45	2026-09-16 14:45	2026-09-16 14:45	IEF	IEF261218C00093000	call	93.0000	2026-12-18	0.5600	0.5100	0.5600	91.0200	30123.00	26768.00	3355.00	539	15	1815	20843	0.0870795950678885	0.0524307027060628	0.0530203532437122	false	false	false
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
1044e36e-eaac-4895-ba41-4575a39b96e7	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.9600	91.0900	120378.00	2457.00	99630.00	1335	58	2763	38654	0.0714803125161691	0.0776460004966347	0.0902507524331344	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
f466fb91-940d-47a7-a83a-a36b24ba5b22	2026-09-16 13:52	2026-09-16 13:52	2026-09-16 13:52	IEF	IEF280121C00095000	call	95.0000	2028-01-21	1.8600	1.7600	1.9200	91.0000	930000.00	930000.00	0.00	5000	2	5026	2704	1.85872781065089	0.0791992516301686	0.0791992516301686	false	true	true	false
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
926047b3-f400-4bae-b8f2-40a0b83bfc9c	2026-09-16 12:40	2026-09-16 12:40	2026-09-16 12:40	IEF	IEF280121P00080000	put	80.0000	2028-01-21	0.3300	0.2600	0.3300	91.1250	1734150.00	1734150.00	0.00	52550	1	52550	797	65.9347553324969	0.112359468902375	0.112359468902375	false	true	false	true
04cf9cc7-c38d-40ad-a8fd-9398ffd30227	2026-09-16 12:40	2026-09-16 12:40	2026-09-16 12:40	IEF	IEF280121P00092000	put	92.0000	2028-01-21	2.5800	2.4900	2.6600	91.1250	1355790.00	1355790.00	0.00	5255	1	5255	447	11.7561521252796	0.111097341635283	0.111097341635283	false	true	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
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
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
f92164bc-9e5b-4783-8937-a271b9f590c9	2026-09-15 13:33	2026-09-15 13:32	2026-09-15 13:32	IEF	IEF260918C00091500	call	91.5000	2026-09-18	0.0600	0.0600	0.0800	90.7850	13735.00	0.00	13714.00	2258	38	2356	4567	0.515874753667615	0.0891888480964154	0.0843967497127175	false	false	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