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×

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

40cc36d7-04dc-42f4-bc2d-8fd39682973d	2026-09-25 15:42	2026-09-25 15:42	2026-09-25 15:42	IEF	IEF261016C00091500	call	91.5000	2026-10-16	0.1500	0.1300	0.1500	89.0000	45000.00	45000.00	0.00	3000	37	14548	3700	3.93189189189189	0.0675849587729128	0.0675849587729128	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41422981390.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
4681e6b8-2586-4c3e-b0f5-bf69c4acbfb7	2026-09-25 14:47	2026-09-25 14:47	2026-09-25 14:47	IEF	IEF270115P00085000	put	85.0000	2027-01-15	0.2900	0.2900	0.3200	89.0000	28797.00	0.00	28797.00	993	23	2496	12511	0.199504436096235	0.103977774266511	0.103977774266511	false	false	false	true	false
ffe9eea8-7bb1-437b-bb48-1095bcc69057	2026-09-25 14:30	2026-09-25 14:30	2026-09-25 14:30	IEF	IEF261218C00091000	call	91.0000	2026-12-18	0.7600	0.7200	0.7600	89.7124	186580.00	186580.00	0.00	2455	33	2503	10438	0.23979689595708	0.055110599395349	0.055110599395349	false	false	false	true	false
ad664ad8-1a3b-4d44-93dd-c520a2ec1282	2026-09-25 13:31	2026-09-25 13:31	2026-09-25 13:31	IEF	IEF261218P00084000	put	84.0000	2026-12-18	0.1800	0.1700	0.1900	89.7350	11520.00	11052.00	0.00	640	9	7788	59	132	0.1142213360544	0.1142213360544	false	false	false	true	false
111da390-107f-4c89-8fb7-e5bab50663f9	2026-09-25 13:31	2026-09-25 13:31	2026-09-25 13:31	IEF	IEF261218P00084000	put	84.0000	2026-12-18	0.1800	0.1600	0.1800	89.7350	11610.00	11610.00	0.00	645	21	7148	59	121.152542372881	0.1142213360544	0.1142213360544	false	false	false	true	false
80708c01-80fe-4787-b76f-2b6f5f1df00b	2026-09-25 13:31	2026-09-25 13:31	2026-09-25 13:31	IEF	IEF261218P00084000	put	84.0000	2026-12-18	0.1800	0.1600	0.1800	89.7350	11358.00	11358.00	0.00	631	11	5865	59	99.406779661017	0.1142213360544	0.1142213360544	false	false	false	true	false
8273b547-5884-4cc2-a456-5a0e9a8f1f12	2026-09-25 13:20	2026-09-25 13:20	2026-09-25 13:20	IEF	IEF261218P00084000	put	84.0000	2026-12-18	0.1700	0.1600	0.1700	89.0000	14773.00	14773.00	0.00	869	11	4960	59	84.0677966101695	0.112748330194766	0.112748330194766	false	false	false	true	false
b730376c-f3b6-435c-947f-496d6eb101cd	2026-09-25 12:14	2026-09-25 12:13	2026-09-25 12:13	IEF	IEF270115C00095000	call	95.0000	2027-01-15	0.2200	0.1900	0.2200	89.0000	22000.00	22000.00	0.00	1000	25	1502	2714	0.553426676492262	0.0664911176997976	0.0664911176997976	true	false	false	true	false
e4bbf39f-144d-49a6-85c9-97b9efe4b34a	2026-09-25 12:05	2026-09-25 12:05	2026-09-25 12:05	IEF	IEF270115C00095000	call	95.0000	2027-01-15	0.2100	0.1800	0.2100	89.9000	10500.00	10500.00	0.00	500	22	502	2714	0.184966838614591	0.0659844884444328	0.0659844884444328	true	false	false	true	false
423eb2e8-935e-4ffe-898b-de93654c43bb	2026-09-25 10:28	2026-09-25 10:28	2026-09-25 10:28	IEF	IEF261218C00092000	call	92.0000	2026-12-18	0.4700	0.4400	0.4700	89.6150	28200.00	28200.00	0.00	600	9	700	7851	0.0891606164819768	0.0608262847980427	0.0608262847980427	false	false	false	true	false
c043ec6a-3fbd-4236-8e04-3a532303c3ae	2026-09-25 10:12	2026-09-25 10:12	2026-09-25 10:12	IEF	IEF261030P00089000	put	89.0000	2026-10-30	0.6200	0.6200	0.6500	89.6850	10850.00	0.00	10850.00	175	17	663	4593	0.14435009797518	0.0962531647914271	0.0962531647914271	false	false	false	true	false
f4b01a18-1aa4-4fb7-bdeb-2c51309874c6	2026-09-25 10:08	2026-09-25 10:07	2026-09-25 10:07	IEF	IEF270115P00085000	put	85.0000	2027-01-15	0.3200	0.3100	0.3200	89.0000	11776.00	11776.00	0.00	368	18	810	12511	0.0647430261369994	0.105618760072444	0.105618760072444	false	false	false	true	false
e15b98ad-1450-47c4-8df4-5cfc9eec95c8	2026-09-25 10:08	2026-09-25 10:07	2026-09-25 10:07	IEF	IEF270115P00085000	put	85.0000	2027-01-15	0.3200	0.3100	0.3200	89.0000	10592.00	10592.00	0.00	331	21	442	12511	0.0353289105587083	0.105618760072444	0.105618760072444	false	false	false	true	false
eb9f89a7-86ac-4659-889c-0be1bc412791	2026-09-25 10:07	2026-09-25 10:07	2026-09-25 10:07	IEF	IEF261218P00084000	put	84.0000	2026-12-18	0.1700	0.1700	0.1800	89.6400	14909.00	0.00	14909.00	877	18	3877	59	65.7118644067797	0.11144848135925	0.11144848135925	false	false	false	true	false
efe4172b-0b3e-49be-8fcb-da7daa753a27	2026-09-25 10:07	2026-09-25 10:07	2026-09-25 10:07	IEF	IEF261218P00084000	put	84.0000	2026-12-18	0.1800	0.1700	0.1800	89.6358	11556.00	11556.00	0.00	642	19	2297	59	38.9322033898305	0.112982264903594	0.112982264903594	false	false	false	true	false
859fdab5-63a1-476b-9493-a9f2959f457d	2026-09-25 10:07	2026-09-25 10:07	2026-09-25 10:07	IEF	IEF261218P00084000	put	84.0000	2026-12-18	0.1800	0.1700	0.1800	89.6400	11376.00	11376.00	0.00	632	15	2929	59	49.6440677966102	0.113034816514552	0.113034816514552	false	false	false	true	false
bf91ac5b-eac4-44db-a2a3-de59b45f727d	2026-09-25 10:07	2026-09-25 10:07	2026-09-25 10:07	IEF	IEF261218P00084000	put	84.0000	2026-12-18	0.1800	0.1700	0.1800	89.6358	11556.00	11556.00	0.00	642	22	1655	59	28.0508474576271	0.112982264903594	0.112982264903594	false	false	false	true	false
2e9be3f5-577c-4589-b625-87b827bafcdb	2026-09-25 10:07	2026-09-25 10:07	2026-09-25 10:07	IEF	IEF261218P00084000	put	84.0000	2026-12-18	0.1800	0.1700	0.1800	89.6358	11592.00	11592.00	0.00	644	24	1013	59	17.1694915254237	0.112982264903594	0.112982264903594	false	false	false	true	false
297d73cb-dd1b-4243-9606-309c2b53d057	2026-09-25 10:03	2026-09-25 10:03	2026-09-25 10:03	IEF	IEF261120C00090000	call	90.0000	2026-11-20	0.9900	0.9600	0.9900	89.6850	24750.00	24750.00	0.00	250	9	250	7877	0.0317379713088739	0.0609927044558734	0.0609927044558734	false	false	false	true	false
3512bb12-a53b-4039-9c43-a875b5ba9222	2026-09-25 10:02	2026-09-25 10:02	2026-09-25 10:02	IEF	IEF261120P00087000	put	87.0000	2026-11-20	0.3500	0.3500	0.3700	89.0000	43330.00	0.00	43330.00	1238	32	1288	105	12.2666666666667	0.102948109267017	0.102948109267017	false	false	false	true	false
9f1bb491-d309-4f35-b47f-717e38870b40	2026-09-25 09:42	2026-09-25 09:42	2026-09-25 09:42	IEF	IEF261016C00091000	call	91.0000	2026-10-16	0.2400	0.2100	0.2500	89.8250	40704.00	40704.00	0.00	1696	37	1696	94321	0.0179811494789071	0.0698780795163905	0.0698780795163905	false	false	false	true	false
53f3caca-1730-4c7f-a785-475588daae8f	2026-09-25 09:40	2026-09-25 09:40	2026-09-25 09:40	IEF	IEF261016C00091500	call	91.5000	2026-10-16	0.1400	0.1200	0.1450	89.8099	21476.00	21476.00	0.00	1534	22	11534	3700	3.1172972972973	0.0712281910131257	0.0712281910131257	false	false	false	true	false
49dc3432-1980-4e79-a98c-0ff122f3ce91	2026-09-24 15:40	2026-09-24 15:40	2026-09-24 15:40	IEF	IEF261120C00092000	call	92.0000	2026-11-20	0.3100	0.3100	0.3300	89.0000	63612.00	0.00	63612.00	2052	43	2213	1190	1.85966386554622	0.0635994647445462	0.0635994647445462	false	false	false	true	false
a175991e-0280-40a6-b3fc-0bc4674363b3	2026-09-24 14:21	2026-09-24 14:21	2026-09-24 14:21	IEF	IEF260925C00090000	call	90.0000	2026-09-25	0.1300	0.1300	0.1600	89.8900	13000.00	0.00	13000.00	1000	22	10763	391	27.5268542199488	0.0934741867524492	0.0934741867524492	false	false	false	true	false
dc07c08f-87fd-4032-9e53-9423c68d98db	2026-09-24 13:26	2026-09-24 13:26	2026-09-24 13:26	IEF	IEF260925C00090000	call	90.0000	2026-09-25	0.1500	0.1500	0.1700	89.9450	19470.00	0.00	19470.00	1298	32	9411	391	24.0690537084399	0.091360802939408	0.091360802939408	false	false	false	true	false
7a820fa3-af68-42cf-816a-f8276c14cd24	2026-09-24 13:26	2026-09-24 13:26	2026-09-24 13:26	IEF	IEF260925C00090000	call	90.0000	2026-09-25	0.1600	0.1500	0.1900	89.9450	42228.00	0.00	42228.00	2636	42	8113	391	20.7493606138107	0.102059322068399	0.0967115208201504	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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