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:source = uw_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	expirydate

7d801817-aea3-4a5a-a88c-14a4b277a008	2026-09-23 11:32	2026-09-23 11:32	2026-09-23 11:32	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.2200	0.1900	0.2200	90.3500	43934.00	43934.00	0.00	1997	9	4603	55544	0.0828712372173412	0.0606784622614487	0.0606784622614487	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42221335971.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T15:35:15.101362Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
d058db74-b1a8-41c5-bf62-cbed0a378c2a	2026-09-23 10:55	2026-09-23 10:55	2026-09-23 10:55	IEF	IEF261002C00091000	call	91.0000	2026-10-02	0.1700	0.1700	0.1900	90.5200	26282.00	0.00	26282.00	1546	28	1600	160	10	0.0579306605612602	0.0579306605612602	false	false	false	true
28b5e578-24a4-4c54-8e73-5436969a94dd	2026-09-23 10:26	2026-09-23 10:26	2026-09-23 10:26	IEF	IEF261218C00092000	call	92.0000	2026-12-18	0.5900	0.5800	0.5900	90.4962	17641.00	17641.00	0.00	299	14	4001	351	11.3988603988604	0.0488774087361728	0.0488774087361728	false	false	false	true
9b9eecf1-ced2-4d21-9f89-7734fbf65972	2026-09-23 10:26	2026-09-23 10:26	2026-09-23 10:26	IEF	IEF261218C00092000	call	92.0000	2026-12-18	0.5900	0.5800	0.5900	90.4962	25429.00	25429.00	0.00	431	6	3682	351	10.4900284900285	0.0488774087361728	0.0488774087361728	true	false	false	true
290070df-16e0-41d1-adfd-cf4dccb88f50	2026-09-23 10:18	2026-09-23 10:17	2026-09-23 10:17	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.3500	0.3500	0.3600	90.5299	53095.00	0.00	53095.00	1517	17	2040	28273	0.0721536448201464	0.0508075119160785	0.0508075119160785	false	false	false	true
223a7c41-41ac-456b-917a-8f582f941089	2026-09-23 10:12	2026-09-23 10:12	2026-09-23 10:12	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.3600	0.3600	0.3800	90.5550	16992.00	0.00	16992.00	472	10	523	28273	0.0184982138435964	0.0507366250502131	0.0507366250502131	false	false	false	true
0848ede3-ec5f-47ab-a800-a9e79465ee88	2026-09-23 10:12	2026-09-23 10:12	2026-09-23 10:12	IEF	IEF261016C00091500	call	91.5000	2026-10-16	0.2100	0.2100	0.2200	90.5550	17346.00	0.00	17346.00	826	9	861	3784	0.227536997885835	0.0534464329142131	0.0534464329142131	false	false	false	true
97ff84e3-b359-43be-a6c3-7dd309e1202a	2026-09-23 09:55	2026-09-23 09:55	2026-09-23 09:55	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.2300	0.2100	0.2300	90.5800	36823.00	36823.00	0.00	1601	20	2601	55544	0.0468277401699553	0.0581162688534087	0.0581162688534087	false	false	false	true
5e749a1e-5745-4bf6-a106-c56f0d959551	2026-09-23 09:49	2026-09-23 09:49	2026-09-23 09:49	IEF	IEF261016P00090000	put	90.0000	2026-10-16	0.3200	0.3100	0.3400	90.6800	336448.00	0.00	336448.00	10514	1	10514	31369	0.33517166629475	0.0751053521089046	0.0751053521089046	false	true	false	true
7de80b5c-8b9b-4e19-b8ac-17739e9fef73	2026-09-23 09:45	2026-09-23 09:45	2026-09-23 09:45	IEF	IEF260925P00091000	put	91.0000	2026-09-25	0.2700	0.2400	0.2700	90.0000	16686.00	16686.00	0.00	618	21	620	1159	0.534943917169974	0.0737718535192727	0.0737718535192727	false	false	false	true
4582db9e-0cd9-40f7-97fe-ac2cc2ec5ad7	2026-09-23 09:45	2026-09-23 09:45	2026-09-23 09:45	IEF	IEF261030C00090500	call	90.5000	2026-10-30	0.9600	0.9600	1.2000	90.0000	14208.00	0.00	14208.00	148	5	148	2	74	0.045197009627874	0.045197009627874	false	false	false	true
d0895375-5e77-4dbb-8138-de8a340364b1	2026-09-22 15:14	2026-09-22 15:14	2026-09-22 15:14	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.5900	0.5700	0.5900	91.0750	59000.00	59000.00	0.00	1000	10	3539	26050	0.135854126679463	0.0446977492695778	0.0446977492695778	false	false	false	true
390e20df-b639-4915-87f8-0ea168769241	2026-09-22 13:27	2026-09-22 13:26	2026-09-22 13:26	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.5300	0.5300	0.5500	90.9800	56975.00	0.00	56975.00	1075	21	1929	26050	0.0740499040307102	0.0443914333021145	0.0443914333021145	false	false	false	true
9927617c-0eda-4976-8dfe-6bff4503b1f1	2026-09-22 12:55	2026-09-22 12:55	2026-09-22 12:55	IEF	IEF261218C00093000	call	93.0000	2026-12-18	0.4600	0.4400	0.4600	91.0350	18997.00	18997.00	0.00	417	10	470	23829	0.019723865877712	0.0497016924260011	0.0490743589720986	true	false	false	true
f9774be3-027f-4b83-bc99-6874d896feea	2026-09-22 10:35	2026-09-22 10:35	2026-09-22 10:35	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.2200	0.2200	0.2300	91.1250	44198.00	0.00	44198.00	2009	29	2044	94155	0.0217088842865488	0.050374720197648	0.050374720197648	false	false	false	true
9b53a5cf-5fbd-4f5c-a5bb-dd4238b43e9e	2026-09-22 10:15	2026-09-22 10:15	2026-09-22 10:15	IEF	IEF261016P00091000	put	91.0000	2026-10-16	0.5200	0.4900	0.5200	91.1850	407940.00	407940.00	0.00	7845	1	7845	26585	0.295091216851608	0.0764010381564227	0.0764010381564227	false	true	false	true
7729e981-9aa9-4f43-aaf4-5771f06ce12d	2026-09-22 10:15	2026-09-22 10:15	2026-09-22 10:15	IEF	IEF270319P00092000	put	92.0000	2027-03-19	1.9200	1.8700	1.9500	91.1850	462720.00	462720.00	0.00	2410	1	2410	7336	0.328516902944384	0.0959355910940934	0.0959355910940934	false	true	false	true
bb4b2c3f-b9dd-43f3-abcc-1e1dc2796870	2026-09-22 10:13	2026-09-22 10:13	2026-09-22 10:13	IEF	IEF261002C00091500	call	91.5000	2026-10-02	0.2200	0.2200	0.2300	91.1800	25080.00	0.00	25080.00	1140	23	1140	2606	0.437452033768227	0.0527987699641088	0.0527987699641088	false	false	false	true
4663d6d1-f6f1-46df-831d-3db73e0a8a4a	2026-09-22 10:13	2026-09-22 10:13	2026-09-22 10:13	IEF	IEF261016C00092500	call	92.5000	2026-10-16	0.1400	0.1300	0.1400	91.1800	17500.00	17500.00	0.00	1250	13	1250	6260	0.199680511182109	0.0540496710896795	0.0540496710896795	false	false	false	true
644476ad-c279-4928-93ba-74091b3c769f	2026-09-22 09:46	2026-09-22 09:46	2026-09-22 09:46	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.6400	0.6300	0.6700	91.0000	54272.00	64.00	54208.00	848	36	848	26050	0.032552783109405	0.0419190892468975	0.0419190892468975	false	false	false	true
91f623b5-838c-4999-8302-d5dc1dd4e7a2	2026-09-22 09:41	2026-09-22 09:41	2026-09-22 09:41	IEF	IEF261009C00092000	call	92.0000	2026-10-09	0.1600	0.1600	0.1700	91.1800	14544.00	0.00	14544.00	909	17	909	2008	0.452689243027888	0.0513810433055612	0.0513810433055612	false	false	false	true
4f9de34d-bd5f-46e5-9bd2-fd3803d2aa01	2026-09-21 12:17	2026-09-21 12:17	2026-09-21 12:17	IEF	IEF261016C00092500	call	92.5000	2026-10-16	0.1600	0.1500	0.1700	91.0000	17408.00	17392.00	0.00	1088	27	6098	0	0	0.0568021611255926	0.0568021611255926	true	false	false	true
e54bc1f9-e7e3-4b75-a1d4-b042cd33fd41	2026-09-21 12:15	2026-09-21 12:15	2026-09-21 12:15	IEF	IEF261016C00092500	call	92.5000	2026-10-16	0.1600	0.1500	0.1600	91.1300	22688.00	22688.00	0.00	1418	17	5000	0	0	0.057107476861886	0.057107476861886	true	false	false	true
d594c247-2029-4a4a-a146-7d8ba4c2de8b	2026-09-21 12:15	2026-09-21 12:15	2026-09-21 12:15	IEF	IEF261016C00092500	call	92.5000	2026-10-16	0.1500	0.1400	0.1500	91.1200	19305.00	19305.00	0.00	1287	31	3582	0	0	0.055937866382973	0.055937866382973	true	false	false	true
ba4aa613-c25d-4852-a61e-64128f364a8d	2026-09-21 12:14	2026-09-21 12:14	2026-09-21 12:14	IEF	IEF261016C00092500	call	92.5000	2026-10-16	0.1400	0.1300	0.1400	91.1150	19376.00	19376.00	0.00	1384	21	2295	0	0	0.0545838143482139	0.0545838143482139	true	false	false	true
a18c95b1-02e0-43a6-8a5c-913865011c22	2026-09-21 12:13	2026-09-21 12:13	2026-09-21 12:13	IEF	IEF261016C00092500	call	92.5000	2026-10-16	0.1400	0.1300	0.1400	91.1100	12754.00	12754.00	0.00	911	13	911	0	0	0.0547321433201595	0.0547321433201595	true	false	false	true
0676e9c2-9179-4851-a825-c4c629a5e082	2026-09-21 10:27	2026-09-21 10:27	2026-09-21 10:27	IEF	IEF261002P00090000	put	90.0000	2026-10-02	0.1100	0.1100	0.1200	91.0900	10153.00	0.00	10153.00	923	19	924	1572	0.587786259541985	0.078881798489689	0.078881798489689	false	false	false	true
c241e032-42b2-4e2b-b58a-bc7d407f112c	2026-09-18 15:57	2026-09-18 15:57	2026-09-18 15:57	IEF	IEF260925P00090000	put	90.0000	2026-09-25	0.0500	0.0300	0.0500	90.0000	25000.00	25000.00	0.00	5000	49	5093	133	38.2932330827068	0.0617793851590901	0.0617793851590901	false	false	false	true
adddd033-a1cf-41de-bce6-445c34007d01	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	IEF	IEF261016P00089000	put	89.0000	2026-10-16	0.1200	0.1200	0.1300	90.8290	10308.00	0.00	10308.00	859	17	872	6440	0.135403726708075	0.074705590200467	0.074705590200467	false	false	false	true
20da1b01-0949-4784-8791-85900c0fd5b9	2026-09-18 15:36	2026-09-18 15:36	2026-09-18 15:36	IEF	IEF261002C00090500	call	90.5000	2026-10-02	0.6200	0.6200	0.6400	90.8250	12400.00	0.00	12400.00	200	15	201	12	16.75	0.0479914061083962	0.0479914061083962	false	false	false	true
c6647a6d-a540-4314-be49-d855b1b7ec2c	2026-09-18 15:34	2026-09-18 15:34	2026-09-18 15:34	IEF	IEF260925C00090000	call	90.0000	2026-09-25	0.9300	0.9300	0.9700	90.8250	18600.00	0.00	18600.00	200	11	252	7	36	0.0572611225461237	0.0572611225461237	false	false	false	true
1774ba8f-166c-42d7-81a0-764c0972d920	2026-09-18 14:13	2026-09-18 14:13	2026-09-18 14:13	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.2900	0.2600	0.2900	90.8550	34191.00	34191.00	0.00	1179	25	2672	53015	0.0504008299537867	0.0561670426986412	0.0561670426986412	false	false	false	true
cc0d4f38-1dd7-44c4-bdde-126da0be2cd6	2026-09-18 13:45	2026-09-18 13:45	2026-09-18 13:45	IEF	IEF261120C00091000	call	91.0000	2026-11-20	0.9000	0.9000	0.9100	90.8450	26100.00	0.00	26100.00	290	25	310	38	8.1578947368421	0.0416070078804359	0.0416070078804359	false	false	false	true
8a0f98fe-7712-4d96-8ae4-c9e860d4b78d	2026-09-18 13:21	2026-09-18 13:21	2026-09-18 13:21	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.1900	0.1850	0.2000	90.8400	12521.00	0.00	12521.00	659	19	15598	102806	0.151722662101434	0.0510400995208463	0.0510400995208463	false	false	false	true
b3dc55c5-935c-4a07-a0cc-bc0b92eb4dab	2026-09-18 12:27	2026-09-18 12:26	2026-09-18 12:26	IEF	IEF270115C00091000	call	91.0000	2027-01-15	1.2700	1.2600	1.3000	90.8300	1270000.00	0.00	1270000.00	10000	1	10000	1747	5.72409845449342	0.0281837531494314	0.0281837531494314	false	true	false	true
90db3374-3fc1-4cfe-8cb7-800da0c627d6	2026-09-18 11:25	2026-09-18 11:25	2026-09-18 11:25	IEF	IEF261002P00090500	put	90.5000	2026-10-02	0.3400	0.3400	0.3600	90.8400	35802.00	0.00	35802.00	1053	16	1053	45	23.4	0.077121183852073	0.077121183852073	false	false	false	true
6d402718-31fd-4b7f-ac0c-6916dd10f2a9	2026-09-18 10:56	2026-09-18 10:56	2026-09-18 10:56	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.2000	0.1900	0.2100	90.8700	32920.00	0.00	29120.00	1646	24	14476	102806	0.140808902204152	0.0513345592478988	0.0513345592478988	false	false	false	true
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
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	false
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	true
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