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:ticker = IEF×sorted by created_at ↑×

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

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	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-21T16:17:17.704519Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
d38993ec-d0b3-4356-a99c-116a3e817fb7	2026-09-23 11:43	2026-09-23 11:43	2026-09-23 11:43	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.3300	0.3100	0.3300	90.0000	1146250.00	866250.00	0.00	35000	2	37059	28273	1.31075584479892	0.0560104145838075	0.0560104145838075	false	true	false	true	false
d7aa47f5-94f5-4a97-9a1e-a9ecbc36a786	2026-09-23 12:33	2026-09-23 12:33	2026-09-23 12:33	IEF	IEF261030P00090500	put	90.5000	2026-10-30	0.8600	0.8600	0.9100	90.2700	17200.00	0.00	17200.00	200	5	851	1857	0.458266020463113	0.0812153598396326	0.0812153598396326	false	false	false	true	false
2a6ad26f-24f1-4c5f-a5a9-6a1e49cd08d9	2026-09-23 12:33	2026-09-23 12:33	2026-09-23 12:33	IEF	IEF261030P00090500	put	90.5000	2026-10-30	0.8600	0.8600	0.9100	90.2750	17200.00	0.00	17200.00	200	18	1051	1857	0.565966612816371	0.0814207968978695	0.0814207968978695	false	false	false	true	false
668bb26f-eb2a-4316-931a-d030a3afa45b	2026-09-23 12:36	2026-09-23 12:36	2026-09-23 12:36	IEF	IEF270319P00091000	put	91.0000	2027-03-19	1.9400	1.8500	1.9400	90.2750	30652.00	30652.00	0.00	158	11	158	23	6.8695652173913	0.0989831838739259	0.0989831838739259	false	false	false	true	false
e1a6a04d-1581-4053-ad38-b05a8cdbedc3	2026-09-23 12:40	2026-09-23 12:40	2026-09-23 12:40	IEF	IEF260925C00090500	call	90.5000	2026-09-25	0.1400	0.1400	0.1500	90.0000	16198.00	0.00	16198.00	1157	24	1432	347	4.12680115273775	0.0869045680754832	0.0869045680754832	false	false	false	true	false
226837cf-92d1-46e1-a425-6ba322b1645a	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.2200	0.2000	0.2200	90.2100	44000.00	44000.00	0.00	2000	12	6606	55544	0.118932738009506	0.0627671114537905	0.0627671114537905	false	false	false	true	false
bd6e8ecf-3073-4fbf-8020-f375648f0d41	2026-09-23 13:15	2026-09-23 13:15	2026-09-23 13:15	IEF	IEF261218C00096000	call	96.0000	2026-12-18	0.0900	0.0900	0.1300	90.0000	19782.00	0.00	19782.00	2198	41	2208	22958	0.0961756250544473	0.0730796890625906	0.0730796890625906	false	false	false	true	false
13fa6298-6064-4f77-b2c3-e14fcc3dc012	2026-09-23 13:21	2026-09-23 13:20	2026-09-23 13:20	IEF	IEF260925P00090000	put	90.0000	2026-09-25	0.2300	0.2300	0.2500	90.0300	27945.00	0.00	27945.00	1215	19	3770	5100	0.73921568627451	0.0955696100968067	0.0955696100968067	false	false	false	true	false
feb7f2d3-5652-4b06-b3a7-3325b443a60c	2026-09-23 13:28	2026-09-23 13:28	2026-09-23 13:28	IEF	IEF261016C00090000	call	90.0000	2026-10-16	0.6800	0.6600	0.6800	90.0000	18020.00	18020.00	0.00	265	6	382	144	2.65277777777778	0.0590049438143591	0.0590049438143591	true	false	false	true	false
b54a7b3d-835c-4e02-8d24-d6aa6dd3bb0f	2026-09-23 13:28	2026-09-23 13:28	2026-09-23 13:28	IEF	IEF261016C00090000	call	90.0000	2026-10-16	0.6800	0.6600	0.6800	90.0000	27608.00	27608.00	0.00	406	5	788	144	5.47222222222222	0.0590115765216521	0.0590115765216521	true	false	false	true	false
7a60097d-d544-411b-a357-634b6fdaa26c	2026-09-23 13:37	2026-09-23 13:37	2026-09-23 13:37	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.2800	0.2500	0.2800	90.0201	825000.00	825000.00	0.00	30000	2	69738	28273	2.46659356983695	0.0628365747050443	0.0628365747050443	false	true	false	true	false
b6488e22-175e-4b7e-9687-db0477474a47	2026-09-23 13:58	2026-09-23 13:58	2026-09-23 13:58	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.2900	0.2800	0.2900	90.1050	13746.00	13746.00	0.00	474	11	71984	28273	2.54603331800658	0.0620350819005861	0.0620350819005861	false	false	false	true	false
7a792c19-7aa3-4407-a07c-592195130dad	2026-09-23 14:32	2026-09-23 14:32	2026-09-23 14:32	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.2100	0.2000	0.2100	90.0850	52500.00	52500.00	0.00	2500	31	9135	55544	0.16446420855538	0.0636390859586663	0.0636390859586663	false	false	false	true	false
bf518db7-648e-4fa6-869d-0f89267f79ed	2026-09-23 15:47	2026-09-23 15:47	2026-09-23 15:47	IEF	IEF270115C00095000	call	95.0000	2027-01-15	0.2200	0.1900	0.2200	90.1850	11000.00	11000.00	0.00	500	14	512	2341	0.218709953011534	0.062787124940669	0.062787124940669	false	false	false	true	false
13e065c3-ed49-4eb1-9676-4e79198e30a3	2026-09-24 09:43	2026-09-24 09:43	2026-09-24 09:43	IEF	IEF261002C00090000	call	90.0000	2026-10-02	0.5600	0.5600	0.5800	90.2800	11200.00	0.00	11200.00	200	23	200	40	5	0.066141513436322	0.066141513436322	false	false	false	true	false
8ec2c325-906d-46cd-8d6f-4dfd5f2ba57b	2026-09-24 10:03	2026-09-24 10:02	2026-09-24 10:02	IEF	IEF261218C00092000	call	92.0000	2026-12-18	0.5500	0.5500	0.5800	90.3050	127820.00	0.00	127820.00	2324	42	2334	5312	0.439382530120482	0.0512109870655406	0.0512109870655406	false	false	false	true	false
71efa192-64cf-4542-bd4c-ab7f20d71bae	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	IEF	IEF260925C00090000	call	90.0000	2026-09-25	0.2400	0.2200	0.2400	90.0000	23688.00	23688.00	0.00	987	28	987	391	2.52429667519182	0.105064822795601	0.105064822795601	false	false	false	true	false
196f54b0-763e-40ce-a849-bb0e15ab15bd	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	IEF	IEF260925C00090000	call	90.0000	2026-09-25	0.2500	0.2300	0.2500	90.0000	37825.00	37825.00	0.00	1513	42	2500	391	6.39386189258312	0.105841404914926	0.105841404914926	false	false	false	true	false
7ce9e379-0ba4-4d4d-9086-08d13cb81795	2026-09-24 11:14	2026-09-24 11:13	2026-09-24 11:13	IEF	IEF261030P00089000	put	89.0000	2026-10-30	0.5000	0.4800	0.5000	89.0000	10000.00	10000.00	0.00	200	9	400	2600	0.153846153846154	0.08980863607605	0.08980863607605	false	false	false	true	false
57d6e1c2-e701-412f-8b51-bc3e7acfd1c0	2026-09-24 11:14	2026-09-24 11:14	2026-09-24 11:14	IEF	IEF261030P00089000	put	89.0000	2026-10-30	0.5000	0.4900	0.5000	89.9100	10000.00	10000.00	0.00	200	12	600	2600	0.230769230769231	0.0903287226987098	0.0903287226987098	false	false	false	true	false
18ee8964-e4f4-4365-a224-8d6dbd3147a3	2026-09-24 11:15	2026-09-24 11:15	2026-09-24 11:15	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.2100	0.2000	0.2100	89.9050	42000.00	42000.00	0.00	2000	38	2010	64617	0.0311063651980129	0.0667113767763075	0.0667113767763075	false	false	false	true	false
d47749e5-5c95-4528-b914-038508b87121	2026-09-24 11:55	2026-09-24 11:54	2026-09-24 11:54	IEF	IEF260925C00090000	call	90.0000	2026-09-25	0.1600	0.1600	0.1700	89.8800	13296.00	0.00	13296.00	831	10	5367	391	13.7263427109974	0.112093617168339	0.112093617168339	false	false	false	true	false
a80a3e96-fe0d-4055-8b1d-ea6a5525f58e	2026-09-24 12:15	2026-09-24 12:15	2026-09-24 12:15	IEF	IEF261218C00092000	call	92.0000	2026-12-18	0.5000	0.5000	0.5200	89.8950	13250.00	0.00	13250.00	265	15	2876	5312	0.541415662650602	0.0568310986589316	0.0568310986589316	false	false	false	true	false
71008b8f-eb52-4011-a10c-55193919f51d	2026-09-24 12:45	2026-09-24 12:45	2026-09-24 12:45	IEF	IEF261030P00090000	put	90.0000	2026-10-30	0.8000	0.7800	0.8300	90.0150	10880.00	800.00	10080.00	136	11	1001	1601	0.625234228607121	0.0868574126789497	0.0868574126789497	false	false	false	true	false