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

609daf45-07c8-43a6-aefb-1fc530a96aec	2026-09-02 14:23	2026-09-02 14:23	2026-09-02 14:23	IEF	IEF261016P00094000	put	94.0000	2026-10-16	1.9700	1.9700	2.0200	92.1050	98500.00	0.00	98500.00	500	6	513	3796	0.135142255005269	0.0848925986464251	0.0848925986464251	false	false	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-02T18:39:55.300995Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c69acb2e-2bf3-47e0-a237-4a29405c8ab2	2026-09-02 15:29	2026-09-02 15:29	2026-09-02 15:29	IEF	IEF261016P00094000	put	94.0000	2026-10-16	1.9600	1.9600	1.9900	92.1150	116032.00	0.00	116032.00	592	18	1805	3796	0.47550052687039	0.0846213808863932	0.0846213808863932	false	false	false	true	false
aba5d588-8ff7-49da-bfe4-a3806a6e7045	2026-09-03 09:32	2026-09-03 09:32	2026-09-03 09:32	IEF	IEF260918C00093000	call	93.0000	2026-09-18	0.2300	0.2300	0.2500	92.4450	23023.00	0.00	23023.00	1001	21	1001	30063	0.0332967435053055	0.053707734698829	0.053707734698829	false	false	false	true	false
17923e0a-34ce-4ad4-ae22-52b70c74647c	2026-09-03 09:47	2026-09-03 09:47	2026-09-03 09:47	IEF	IEF260918C00093000	call	93.0000	2026-09-18	0.2300	0.2300	0.2400	92.4310	17549.00	0.00	17549.00	763	23	1856	30063	0.0617370189269201	0.0544040320946407	0.0544040320946407	false	false	false	true	false
161dd73a-3d52-45a1-8d7b-ce9e08f3ed08	2026-09-03 10:00	2026-09-03 10:00	2026-09-03 10:00	IEF	IEF261002C00093000	call	93.0000	2026-10-02	0.3800	0.3600	0.3800	92.4000	53618.00	53618.00	0.00	1411	16	1411	711	1.9845288326301	0.0504403777667677	0.0504403777667677	false	false	false	true	false
9822c23a-2ea5-4417-a8b9-bd9680f9bff7	2026-09-03 10:05	2026-09-03 10:05	2026-09-03 10:05	IEF	IEF260918C00093000	call	93.0000	2026-09-18	0.2200	0.2200	0.2300	92.3950	21978.00	0.00	21978.00	999	25	2888	30063	0.0960649303130093	0.0547052334431109	0.0547052334431109	false	false	false	true	false
2c54d122-7267-4424-baa9-1a122104d7cc	2026-09-03 10:54	2026-09-03 10:53	2026-09-03 10:53	IEF	IEF260904C00092500	call	92.5000	2026-09-04	0.1100	0.1100	0.1200	92.3850	14311.00	0.00	14311.00	1301	20	1308	3626	0.360728075013789	0.0813963744737278	0.0813963744737278	false	false	false	true	false
7630ab4e-92fa-4d25-9000-6e7dd0b00cb5	2026-09-03 11:13	2026-09-03 11:12	2026-09-03 11:12	IEF	IEF260904C00092500	call	92.5000	2026-09-04	0.1300	0.1300	0.1400	92.4450	15665.00	0.00	15665.00	1205	23	2513	3626	0.693050193050193	0.0785288179318583	0.0785288179318583	false	false	false	true	false
9ca93b14-dca9-4d89-b145-6e4003479b37	2026-09-03 12:31	2026-09-03 12:31	2026-09-03 12:31	IEF	IEF260904C00092500	call	92.5000	2026-09-04	0.1200	0.1200	0.1300	92.4300	13932.00	0.00	13932.00	1161	21	3676	3626	1.01378929950359	0.0767877525486448	0.0767877525486448	false	false	false	true	false
8619b723-e9ac-4075-95a2-8bf448ff43de	2026-09-03 13:13	2026-09-03 13:13	2026-09-03 13:13	IEF	IEF261002C00093000	call	93.0000	2026-10-02	0.3700	0.3500	0.3700	92.3650	75665.00	75665.00	0.00	2045	22	3456	711	4.86075949367089	0.0508432106164167	0.0508432106164167	false	false	false	true	false
43314ff0-4f3d-4a8f-afa5-c54caaf61b41	2026-09-03 14:28	2026-09-03 14:28	2026-09-03 14:28	IEF	IEF260904C00092500	call	92.5000	2026-09-04	0.0900	0.0900	0.1000	92.3700	10521.00	0.00	10521.00	1169	17	5654	3626	1.55929398786542	0.0736598555472178	0.0736598555472178	false	false	false	true	false
ea0420ab-b498-4c36-80ff-32000aa79202	2026-09-03 14:44	2026-09-03 14:44	2026-09-03 14:44	IEF	IEF261016C00094000	call	94.0000	2026-10-16	0.2100	0.1900	0.2100	92.3450	42000.00	42000.00	0.00	2000	34	2306	25570	0.0901838091513492	0.0511905930135894	0.0511905930135894	false	false	false	true	false
13f87036-b7f1-4182-836f-3fce3c4224b0	2026-09-04 09:30	2026-09-04 09:30	2026-09-04 09:30	IEF	IEF261016C00094000	call	94.0000	2026-10-16	0.1700	0.1600	0.1900	92.2750	34000.00	1054.00	31348.00	2000	21	2000	27306	0.0732439756830001	0.0487941834505115	0.0487941834505115	false	false	false	true	false
443013ea-2979-4462-9b2e-9e07a6a2e52a	2026-09-04 11:54	2026-09-04 11:53	2026-09-04 11:53	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.5600	0.5300	0.5600	92.3200	202160.00	202160.00	0.00	3610	52	3622	35282	0.10265857944561	0.0418017906685174	0.0418017906685174	false	false	false	true	false
0ff85ab6-26f0-4b9e-9d64-cd9053d985e6	2026-09-04 11:54	2026-09-04 11:53	2026-09-04 11:53	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.5600	0.5300	0.5600	92.3200	77840.00	77840.00	0.00	1390	5	5012	35282	0.142055439034068	0.0418017906685174	0.0418017906685174	false	false	false	true	false
a53d99f4-f845-49bd-b570-1dcaaa554e48	2026-09-08 12:26	2026-09-08 12:26	2026-09-08 12:26	IEF	IEF281215P00095000	put	95.0000	2028-12-15	4.0500	4.0500	4.4000	92.1739	13770.00	0.00	13770.00	34	8	34	26	1.30769230769231	0.112846183672448	0.112846183672448	false	false	false	true	false
4e29c169-86c4-4072-ad66-d5ddc11b7a91	2026-09-08 13:56	2026-09-08 13:55	2026-09-08 13:55	IEF	IEF260918C00092500	call	92.5000	2026-09-18	0.2500	0.2500	0.2600	92.1700	14400.00	0.00	14400.00	576	14	603	56631	0.0106478783705038	0.0582195269861904	0.0582195269861904	false	false	false	true	false
b82b076b-fc04-4737-8b79-1aa5cf285bd0	2026-09-08 14:23	2026-09-08 14:23	2026-09-08 14:23	IEF	IEF260911P00092000	put	92.0000	2026-09-11	0.1400	0.1400	0.1500	92.1299	12222.00	0.00	12222.00	873	20	1233	418	2.94976076555024	0.0630117021749842	0.0630117021749842	false	false	false	true	false
be9ad2fe-4ee7-429f-bb6d-ca1d5c338a77	2026-09-08 14:55	2026-09-08 14:54	2026-09-08 14:54	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.4900	0.4500	0.4900	92.0692	147000.00	147000.00	0.00	3000	11	3004	38152	0.0787376808555253	0.0445653455454499	0.0445653455454499	false	false	false	true	false
2c8e849b-02a1-44d7-8cc7-86b4d7586ab6	2026-09-09 10:10	2026-09-09 10:10	2026-09-09 10:10	IEF	IEF260918C00092500	call	92.5000	2026-09-18	0.2400	0.2200	0.2400	92.1200	288000.00	288000.00	0.00	12000	7	12251	57412	0.213387445133422	0.0636940190034322	0.0636940190034322	false	false	false	true	false
e3e0b8b0-8298-4025-b002-88a81b3a58e8	2026-09-09 10:11	2026-09-09 10:11	2026-09-09 10:11	IEF	IEF260918C00092500	call	92.5000	2026-09-18	0.2400	0.2300	0.2400	92.1150	60936.00	60936.00	0.00	2539	23	14794	57412	0.257681320978193	0.0640368413712422	0.0640368413712422	false	false	false	true	false
d8fae46c-adc3-412f-b287-93d90641f10f	2026-09-09 10:26	2026-09-09 10:26	2026-09-09 10:26	IEF	IEF260918C00092500	call	92.5000	2026-09-18	0.2200	0.2100	0.2200	92.0000	18524.00	18524.00	0.00	842	17	15652	57412	0.272625931860935	0.0650311451439685	0.0650311451439685	false	false	false	true	false
73bb3cb3-62b3-4e56-81a7-60ac77b6782e	2026-09-09 11:39	2026-09-09 11:39	2026-09-09 11:39	IEF	IEF260911P00092000	put	92.0000	2026-09-11	0.2600	0.2600	0.2800	91.8708	24102.00	0.00	24102.00	927	19	942	1648	0.571601941747573	0.0737523356340606	0.0737523356340606	false	false	false	true	false
327a1b0d-17bd-43db-ba30-8b3b331833c8	2026-09-09 11:47	2026-09-09 11:47	2026-09-09 11:47	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.6700	0.6400	0.6700	91.8700	26800.00	26800.00	0.00	400	12	411	93	4.41935483870968	0.046770229937772	0.046770229937772	false	false	false	true	false
94705900-8122-49a3-8603-6f97c9670774	2026-09-09 13:02	2026-09-09 13:02	2026-09-09 13:02	IEF	IEF261120C00092000	call	92.0000	2026-11-20	1.0100	0.9700	1.0100	91.0000	11918.00	11918.00	0.00	118	5	118	31	3.80645161290323	0.0422945241113446	0.0422945241113446	false	false	false	true	false
44653242-73c4-4d36-a55a-e2452a6ba5c7	2026-09-09 13:02	2026-09-09 13:02	2026-09-09 13:02	IEF	IEF261023C00092000	call	92.0000	2026-10-23	0.7500	0.7200	0.7500	91.0000	37725.00	37725.00	0.00	503	8	503	10	50.3	0.0466194693624885	0.0466194693624885	false	false	false	true	false
c2a5ebbc-dfa6-4c72-b2c7-39fdb1f1d011	2026-09-09 15:52	2026-09-09 15:52	2026-09-09 15:52	IEF	IEF281215C00105000	call	105.0000	2028-12-15	0.9100	0.9100	1.0000	91.8750	19565.00	0.00	19565.00	215	14	216	176	1.22727272727273	0.0379552466441642	0.0379552466441642	false	false	false	true	false
80b3da79-50a4-4b0f-a4a9-9c98072ca82e	2026-09-10 09:33	2026-09-10 09:33	2026-09-10 09:33	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.3800	0.3500	0.3800	91.3901	113620.00	113620.00	0.00	2990	25	3000	42152	0.0711710001897893	0.050793115321382	0.050793115321382	false	false	false	true	false
f57acf18-ce9c-45d5-864e-0df583ef31d9	2026-09-10 09:38	2026-09-10 09:38	2026-09-10 09:38	IEF	IEF261120C00092000	call	92.0000	2026-11-20	0.8000	0.7700	0.8100	91.3750	40000.00	32000.00	0.00	500	6	500	133	3.7593984962406	0.0472768889413009	0.0472768889413009	false	false	false	true	false
e5cd74c0-0d0e-47c1-b594-36c0cbdf05e2	2026-09-10 10:03	2026-09-10 10:03	2026-09-10 10:03	IEF	IEF260911C00091500	call	91.5000	2026-09-11	0.1400	0.1400	0.1500	91.3450	14574.00	0.00	14574.00	1041	16	1217	1	1217	0.107152985891262	0.107152985891262	false	false	false	true	false
1a0cfa9d-bcc8-450c-86a6-fe2424cbde38	2026-09-10 10:28	2026-09-10 10:28	2026-09-10 10:28	IEF	IEF261016P00091000	put	91.0000	2026-10-16	0.4800	0.4700	0.5100	91.4000	375120.00	0.00	375120.00	7815	1	7884	16514	0.477413104032942	0.070189544902068	0.070189544902068	false	true	false	true	false
ba5976ba-1d03-4fbc-9f24-56509fd02ebd	2026-09-10 11:14	2026-09-10 11:13	2026-09-10 11:13	IEF	IEF260911C00091500	call	91.5000	2026-09-11	0.1100	0.1100	0.1300	91.2950	12111.00	0.00	12111.00	1101	24	2329	1	2329	0.100666936568751	0.100666936568751	false	false	false	true	false
427f4fea-13af-425b-88fd-6bfbdb70b7a1	2026-09-10 11:44	2026-09-10 11:44	2026-09-10 11:44	IEF	IEF260911C00091500	call	91.5000	2026-09-11	0.1300	0.1100	0.1300	91.3300	19214.00	19214.00	0.00	1478	49	3807	1	3807	0.104816030279523	0.104816030279523	false	false	false	true	false
2098ff48-017e-4dc2-9c57-088d31cc3920	2026-09-10 11:48	2026-09-10 11:47	2026-09-10 11:47	IEF	IEF261030P00089000	put	89.0000	2026-10-30	0.1800	0.1700	0.1800	91.3150	10818.00	10818.00	0.00	601	24	1146	0	0	0.0770907107026208	0.0770907107026208	false	false	false	true	false
e139a5f8-a776-45d3-9e48-811441b56fa9	2026-09-10 11:59	2026-09-10 11:59	2026-09-10 11:59	IEF	IEF260911C00091500	call	91.5000	2026-09-11	0.1300	0.1300	0.1400	91.3450	21411.00	0.00	21411.00	1647	25	41466	1	41466	0.101687598653514	0.101687598653514	false	false	false	true	false
f7c8f235-a48f-4bfe-896f-a36db10a4594	2026-09-10 12:49	2026-09-10 12:49	2026-09-10 12:49	IEF	IEF260918C00092500	call	92.5000	2026-09-18	0.0600	0.0600	0.0700	91.0000	18000.00	0.00	18000.00	3000	28	26075	71890	0.362706913339825	0.0677190169670148	0.0677190169670148	false	false	false	true	false
e2de4db0-539a-4b6a-8aa4-0784c6a0928d	2026-09-10 12:53	2026-09-10 12:53	2026-09-10 12:53	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.4700	0.4500	0.4700	91.0000	62181.00	62181.00	0.00	1323	26	41606	460	90.4478260869565	0.0516950380850307	0.0516950380850307	false	false	false	true	false
03ee2074-13df-40a7-b92b-54367575d40c	2026-09-10 12:53	2026-09-10 12:53	2026-09-10 12:53	IEF	IEF261016C00092000	call	92.0000	2026-10-16	0.4800	0.4600	0.4800	91.0000	18576.00	18576.00	0.00	387	17	42283	460	91.9195652173913	0.0527728500608516	0.0527728500608516	false	false	false	true	false
28df19da-3d3e-49b9-b3e3-0e86804a02d0	2026-09-10 13:10	2026-09-10 13:10	2026-09-10 13:10	IEF	IEF260918C00092000	call	92.0000	2026-09-18	0.1600	0.1400	0.1600	91.3450	32000.00	32000.00	0.00	2000	33	2029	15321	0.132432608837543	0.0704720630356133	0.0704720630356133	false	false	false	true	false
f305dee8-1514-4f06-9089-6f9fd2e3281c	2026-09-10 13:43	2026-09-10 13:43	2026-09-10 13:43	IEF	IEF260918P00091000	put	91.0000	2026-09-18	0.2500	0.2400	0.2600	91.2500	14325.00	275.00	14050.00	573	9	2789	10092	0.276357510899723	0.0727884422620307	0.0727884422620307	false	false	false	true	false
ee029df5-5175-40ea-b4ef-4711bb0a76c7	2026-09-10 13:43	2026-09-10 13:43	2026-09-10 13:43	IEF	IEF260918P00091000	put	91.0000	2026-09-18	0.2500	0.2300	0.2500	91.2500	15125.00	15125.00	0.00	605	22	2216	10092	0.219579865239794	0.0727884422620307	0.0727884422620307	false	false	false	true	false
2842a7ac-0fbf-46a9-8ea5-dd848d4551aa	2026-09-10 13:43	2026-09-10 13:43	2026-09-10 13:43	IEF	IEF260918P00091000	put	91.0000	2026-09-18	0.2500	0.2300	0.2500	91.2500	39575.00	39575.00	0.00	1583	35	1611	10092	0.159631391200951	0.0727884422620307	0.0727884422620307	false	false	false	true	false
f55d99ef-5a27-4cdb-bce8-90eafde8c68f	2026-09-10 14:02	2026-09-10 14:02	2026-09-10 14:02	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.3900	0.3400	0.3900	91.1801	115011.00	115011.00	0.00	2949	40	6022	42152	0.142863921047637	0.0549705167510831	0.0549705167510831	false	false	false	true	false
c088119c-d21e-41ed-a21d-021e80d4adb5	2026-09-10 14:13	2026-09-10 14:12	2026-09-10 14:12	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.4200	0.3700	0.4200	91.1750	63000.00	63000.00	0.00	1500	12	7522	42152	0.178449421142532	0.0570164418243631	0.0570164418243631	false	false	false	true	false
dbff92df-72c0-4d81-ad4b-b7147be197ef	2026-09-10 14:15	2026-09-10 14:15	2026-09-10 14:15	IEF	IEF260918P00090500	put	90.5000	2026-09-18	0.1500	0.1400	0.1500	91.1650	12000.00	12000.00	0.00	800	21	2742	4	685.5	0.0784287898873951	0.0784287898873951	false	false	false	true	false
6ed225c8-1843-47b1-ba9d-4fc0b98ece5a	2026-09-10 14:15	2026-09-10 14:15	2026-09-10 14:15	IEF	IEF260918P00090500	put	90.5000	2026-09-18	0.1500	0.1400	0.1500	91.1650	29100.00	29100.00	0.00	1940	32	1942	4	485.5	0.0784287898873951	0.0784287898873951	false	false	false	true	false
c6f81250-5977-447f-9943-a385fde97b52	2026-09-10 14:17	2026-09-10 14:17	2026-09-10 14:17	IEF	IEF260918P00090500	put	90.5000	2026-09-18	0.1700	0.1600	0.1800	91.1750	24072.00	3417.00	14297.00	1416	6	8665	4	2166.25	0.0837198500729184	0.0837198500729184	false	false	false	true	false
a60e0c8c-f68a-42e5-b643-b73302421d0a	2026-09-10 14:17	2026-09-10 14:17	2026-09-10 14:17	IEF	IEF260918P00090500	put	90.5000	2026-09-18	0.1700	0.1500	0.1700	91.1750	41803.00	41803.00	0.00	2459	35	7249	4	1812.25	0.0837198500729184	0.0837198500729184	false	false	false	true	false
a369a3a9-8e8a-42cf-a78d-75ec3cc4d3e5	2026-09-10 14:17	2026-09-10 14:17	2026-09-10 14:17	IEF	IEF260918P00090500	put	90.5000	2026-09-18	0.1600	0.1500	0.1600	91.1750	16384.00	16384.00	0.00	1024	16	4790	4	1197.5	0.0813757428987992	0.0813757428987992	false	false	false	true	false
4ce9f10b-1eff-423e-ab92-9b98fb7b68e4	2026-09-10 14:20	2026-09-10 14:20	2026-09-10 14:20	IEF	IEF260918P00090500	put	90.5000	2026-09-18	0.1700	0.1700	0.1900	91.1700	24582.00	0.00	24582.00	1446	6	11549	4	2887.25	0.0834279996572989	0.0834279996572989	false	false	false	true	false