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×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

12141aa9-2855-4c13-ae65-ea7ccf306fb0	2026-08-17 13:57	2026-08-17 13:57	2026-08-17 13:57	IEF	IEF260904C00093500	call	93.5000	2026-09-04	0.1800	0.1700	0.1800	92.0000	26280.00	26280.00	0.00	1460	18	1569	277	5.66425992779783	0.0442473596339832	0.0442473596339832	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41741256328.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f303afb5-c886-4777-8d8a-5b6bf96131e5	2026-08-17 14:58	2026-08-17 14:58	2026-08-17 14:58	IEF	IEF260828C00093500	call	93.5000	2026-08-28	0.1200	0.1100	0.1200	92.8491	13404.00	13404.00	0.00	1117	14	1132	983	1.15157680569685	0.049841663376792	0.049841663376792	false	false	false	true
6eda1a63-20ba-40d4-b198-90f623eeade2	2026-08-18 13:52	2026-08-18 13:52	2026-08-18 13:52	IEF	IEF280121P00089000	put	89.0000	2028-01-21	1.2000	1.1000	1.2300	92.9650	24000.00	24000.00	0.00	200	5	200	2818	0.07097232079489	0.10250828714972	0.10250828714972	false	false	false	true
05107ee1-901d-45e6-a482-263cc14a6a59	2026-08-19 13:18	2026-08-19 13:18	2026-08-19 13:18	IEF	IEF260828C00093500	call	93.5000	2026-08-28	0.1600	0.1600	0.1700	93.1201	16672.00	0.00	16672.00	1042	16	1049	1253	0.837190742218675	0.0483675071701392	0.0483675071701392	false	false	false	true
ca985227-6203-4e2c-bee4-7148ae598112	2026-08-20 12:56	2026-08-20 12:56	2026-08-20 12:56	IEF	IEF260918C00094000	call	94.0000	2026-09-18	0.1900	0.1700	0.2000	92.9900	30466.00	30466.00	0.00	1590	29	1707	39040	0.0437243852459016	0.0444538566180758	0.0456048948252559	false	false	false	true
009681db-1838-445e-bbd3-3b87d93d3e10	2026-08-20 14:46	2026-08-20 14:46	2026-08-20 14:46	IEF	IEF260821P00093000	put	93.0000	2026-08-21	0.0900	0.0800	0.1000	93.0001	16101.00	13851.00	0.00	1789	30	4072	20778	0.195976513620175	0.0488048386993442	0.0488048386993442	false	false	false	true
82064c12-881f-42f6-843a-5b89a2e3fd56	2026-08-20 15:09	2026-08-20 15:09	2026-08-20 15:09	IEF	IEF261016C00093000	call	93.0000	2026-10-16	0.8500	0.8300	0.8500	93.0450	13855.00	13855.00	0.00	163	7	166	10372	0.0160046278441959	0.0338918464651154	0.0338918464651154	false	false	false	true
3eb2fc42-d879-40fa-a044-86e00d84e753	2026-08-21 10:12	2026-08-21 10:12	2026-08-21 10:12	IEF	IEF261218P00093000	put	93.0000	2026-12-18	1.3200	1.2800	1.3200	92.9200	11616.00	11616.00	0.00	88	8	109	1174	0.0928449744463373	0.0861549405787387	0.0861549405787387	false	false	false	true
96e22476-d904-46a0-98ff-b4c35507cd7c	2026-08-21 15:02	2026-08-21 15:02	2026-08-21 15:02	IEF	IEF260918C00094000	call	94.0000	2026-09-18	0.1600	0.1400	0.1600	92.8077	32000.00	32000.00	0.00	2000	31	2172	38877	0.0558685083725596	0.0473328682584544	0.0473328682584544	false	false	false	true
0157ff8d-99cc-4115-90bf-6216d620ebea	2026-08-21 15:08	2026-08-21 15:08	2026-08-21 15:08	IEF	IEF260918C00093000	call	93.0000	2026-09-18	0.4700	0.4500	0.4800	92.8150	470000.00	470000.00	0.00	10000	1	30044	6773	4.43584822087701	0.0415357300555106	0.0415357300555106	false	true	false	true
f915cac7-c5d3-46a0-953d-1db0fc19fb68	2026-08-25 11:22	2026-08-25 11:22	2026-08-25 11:22	IEF	IEF260918C00093000	call	93.0000	2026-09-18	0.7200	0.7100	0.7200	93.3900	72000.00	72000.00	0.00	1000	21	21124	36843	0.573351790027956	0.0332868095840543	0.0332868095840543	false	false	false	true
3f598aee-75f1-42f5-bbc6-cb96de14db4d	2026-08-25 12:41	2026-08-25 12:41	2026-08-25 12:41	IEF	IEF260925C00093500	call	93.5000	2026-09-25	0.5200	0.5200	0.5500	93.3900	15600.00	0.00	15600.00	300	17	605	258	2.34496124031008	0.0384823826055862	0.0384823826055862	true	false	false	true
cb3d13a8-f199-4559-81b5-0c9bbbd94dee	2026-08-25 12:42	2026-08-25 12:41	2026-08-25 12:41	IEF	IEF260925C00093500	call	93.5000	2026-09-25	0.5200	0.5200	0.5500	93.3900	15600.00	0.00	15600.00	300	17	905	258	3.5077519379845	0.0384823826055862	0.0384823826055862	true	false	false	true
6861979f-75c9-42cb-8851-14083d50c005	2026-08-25 12:42	2026-08-25 12:42	2026-08-25 12:42	IEF	IEF260925C00093500	call	93.5000	2026-09-25	0.5200	0.5200	0.5500	93.3900	31200.00	0.00	31200.00	600	15	1505	258	5.83333333333333	0.0384823826055862	0.0384823826055862	true	false	false	true
6608fd0f-60c3-4a53-ae0c-09ed395e3642	2026-08-25 12:42	2026-08-25 12:42	2026-08-25 12:42	IEF	IEF260925C00093500	call	93.5000	2026-09-25	0.5200	0.5100	0.5400	93.3900	20644.00	260.00	7852.00	397	13	1902	258	7.37209302325581	0.0384823826055862	0.0384823826055862	true	false	false	true
a193aa55-ddf9-4c01-b744-8d6845bf9982	2026-08-25 15:54	2026-08-25 15:54	2026-08-25 15:54	IEF	IEF261016C00095000	call	95.0000	2026-10-16	0.2400	0.2200	0.2500	93.5200	24194.00	24194.00	0.00	1000	27	1188	42244	0.0281223368999148	0.042701426854023	0.042701426854023	true	false	false	true
19741fab-946a-4c1c-a731-2ca8903f593c	2026-08-26 13:19	2026-08-26 13:19	2026-08-26 13:19	IEF	IEF260918C00093000	call	93.0000	2026-09-18	0.6300	0.6100	0.6300	93.2650	63000.00	63000.00	0.00	1000	30	1000	37622	0.0265801924405933	0.0355547998099209	0.0355547998099209	false	false	false	true
3d0a0519-8364-4d34-8136-016e20ceb4b7	2026-08-26 15:53	2026-08-26 15:53	2026-08-26 15:53	IEF	IEF261218P00095000	put	95.0000	2026-12-18	2.3400	2.3300	2.4000	93.2750	135720.00	0.00	135720.00	580	1	600	1038	0.578034682080925	0.0977136344306737	0.0977136344306737	false	true	false	true
0f2724fb-39a5-4516-9080-19bfd1270c21	2026-08-27 09:57	2026-08-27 09:56	2026-08-27 09:56	IEF	IEF260828C00093500	call	93.5000	2026-08-28	0.1000	0.0900	0.1000	93.3250	13400.00	13400.00	0.00	1340	33	8273	1122	7.37344028520499	0.087160405211553	0.087160405211553	false	false	false	true
6656152b-5c09-471e-ae6c-915c0c7a44f8	2026-08-27 10:24	2026-08-27 10:24	2026-08-27 10:24	IEF	IEF260828C00093500	call	93.5000	2026-08-28	0.0700	0.0700	0.0800	93.2650	12768.00	0.00	12768.00	1824	23	11271	1122	10.0454545454545	0.0808757475906456	0.0808757475906456	false	false	false	true
87085588-e1f7-4d52-ac80-d32cfba00981	2026-08-27 10:52	2026-08-27 10:52	2026-08-27 10:52	IEF	IEF260828C00093500	call	93.5000	2026-08-28	0.0900	0.0900	0.1000	93.3500	10791.00	0.00	10791.00	1199	22	12470	1122	11.1140819964349	0.0767913405980961	0.0767913405980961	false	false	false	true
210a7ed7-7a83-468d-986e-3d5b7a6b1269	2026-08-27 11:39	2026-08-27 11:39	2026-08-27 11:39	IEF	IEF280121C00098000	call	98.0000	2028-01-21	1.5000	1.5000	1.5400	93.3250	16500.00	0.00	16500.00	110	6	110	14113	0.00779423226812159	0.022157971643973	0.022157971643973	false	false	false	true
3d857817-9af9-446a-b79f-d02cb1eae9ab	2026-08-27 13:04	2026-08-27 13:03	2026-08-27 13:03	IEF	IEF260925C00093000	call	93.0000	2026-09-25	0.6900	0.6900	0.7200	93.2700	11523.00	0.00	11523.00	167	8	267	301	0.887043189368771	0.0332509232578817	0.0332509232578817	false	false	false	true
e9ca30f3-5d23-4f8c-83e4-c74dbcdc9683	2026-08-27 15:24	2026-08-27 15:24	2026-08-27 15:24	IEF	IEF260918P00093000	put	93.0000	2026-09-18	0.4300	0.4100	0.4300	93.0000	43000.00	43000.00	0.00	1000	21	1228	20807	0.0590185995097804	0.0685707718397573	0.0685707718397573	false	false	false	true
63c2dee8-9e76-4e5c-a74f-0fd5e346c2b0	2026-08-28 09:54	2026-08-28 09:53	2026-08-28 09:53	IEF	IEF280121C00100000	call	100.0000	2028-01-21	1.0000	1.0000	1.0300	93.2399	16000.00	0.00	16000.00	160	8	166	32685	0.00507878231604712	0.0321591270495063	0.0321591270495063	false	false	false	true
05e9a9e6-4368-4909-b74d-1b96991c5e6e	2026-08-28 10:20	2026-08-28 10:20	2026-08-28 10:20	IEF	IEF261016C00095000	call	95.0000	2026-10-16	0.1500	0.1500	0.1800	93.0650	15000.00	0.00	15000.00	1000	6	1000	42813	0.0233573914465233	0.0455850650232955	0.0455850650232955	false	false	false	true
2df6fc6f-9874-4e80-b5d0-1401337373ee	2026-08-28 10:23	2026-08-28 10:23	2026-08-28 10:23	IEF	IEF260918C00093500	call	93.5000	2026-09-18	0.2600	0.2600	0.2800	93.0650	45760.00	0.00	45760.00	1760	29	1860	27	68.8888888888889	0.0407771967397103	0.0407771967397103	false	false	false	true
95765ef0-a3d3-44ce-bd9a-e4c91da6c2ed	2026-08-28 10:43	2026-08-28 10:43	2026-08-28 10:43	IEF	IEF260918C00094000	call	94.0000	2026-09-18	0.1500	0.1500	0.1600	93.1800	24225.00	0.00	24225.00	1615	8	1653	40678	0.0406362161364866	0.0425769259886958	0.0425769259886958	false	false	false	true
cce1af4c-c5ad-4bff-9217-febf72b5bd77	2026-08-28 11:11	2026-08-28 11:10	2026-08-28 11:10	IEF	IEF261002C00093500	call	93.5000	2026-10-02	0.3800	0.3800	0.4100	93.0818	101688.00	0.00	101688.00	2676	39	2676	325	8.23384615384615	0.0362905047849182	0.0362905047849182	false	false	false	true
3784a8c2-544b-4e51-b7be-2719fdd18105	2026-08-28 12:00	2026-08-28 12:00	2026-08-28 12:00	IEF	IEF280121C00089000	call	89.0000	2028-01-21	6.0000	6.0000	6.3000	92.0000	30000.00	0.00	30000.00	50	6	75	3904	0.0192110655737705	0.0889580508759565	0.0889580508759565	false	false	false	true
5eefef4c-a45a-4203-b1cf-983973efe224	2026-08-28 12:24	2026-08-28 12:23	2026-08-28 12:23	IEF	IEF260918P00093000	put	93.0000	2026-09-18	0.6400	0.6100	0.6400	92.8550	64000.00	64000.00	0.00	1000	34	1009	21909	0.0460541330047013	0.0753064399971442	0.0753064399971442	false	false	false	true
25c5029a-540c-4a45-81df-226c71580eb2	2026-08-28 12:25	2026-08-28 12:24	2026-08-28 12:24	IEF	IEF260918P00093000	put	93.0000	2026-09-18	0.6500	0.6300	0.6600	92.8450	52585.00	42835.00	0.00	809	13	1868	21909	0.0852617645716372	0.0758880534165801	0.0758880534165801	false	false	false	true
5f059c66-64ad-4a91-aa8e-d7caf3f38b10	2026-08-28 15:09	2026-08-28 15:09	2026-08-28 15:09	IEF	IEF261002C00093000	call	93.0000	2026-10-02	0.5300	0.5000	0.5300	92.8831	13250.00	13250.00	0.00	250	5	371	353	1.05099150141643	0.0357141394609409	0.0357141394609409	false	false	false	true
63b4821a-46b4-4ba7-beb4-859ee8624187	2026-08-31 09:53	2026-08-31 09:53	2026-08-31 09:53	IEF	IEF260918P00092500	put	92.5000	2026-09-18	0.4700	0.4400	0.4800	92.6750	206847.00	197494.00	9353.00	4401	48	4401	4633	0.949924454996762	0.0768272156995037	0.0768272156995037	false	false	false	true
24818961-427d-4d62-b24f-ec3d74ed229d	2026-08-31 09:57	2026-08-31 09:57	2026-08-31 09:57	IEF	IEF260918P00092500	put	92.5000	2026-09-18	0.4800	0.4600	0.4800	92.6750	24000.00	24000.00	0.00	500	24	4902	4633	1.05806173105979	0.0780774313479181	0.0780774313479181	false	false	false	true
000b5594-2382-4b6e-94c5-b1e85f0bfe37	2026-08-31 09:59	2026-08-31 09:58	2026-08-31 09:58	IEF	IEF260904P00092000	put	92.0000	2026-09-04	0.1200	0.1000	0.1200	92.6601	41472.00	41472.00	0.00	3456	42	3456	45	76.8	0.096034439514469	0.0956569434351644	false	false	false	true
d8c91b03-2049-4c20-80b3-2ce8a43eb49f	2026-08-31 10:57	2026-08-31 10:57	2026-08-31 10:57	IEF	IEF260918C00093500	call	93.5000	2026-09-18	0.1500	0.1500	0.1600	92.7100	16560.00	0.00	16560.00	1104	13	1126	1861	0.605051047823751	0.0461796081100428	0.0461796081100428	false	false	false	true
ddccabd1-0f54-4204-8256-c981ab9dbcdb	2026-08-31 11:08	2026-08-31 11:08	2026-08-31 11:08	IEF	IEF261218C00094000	call	94.0000	2026-12-18	0.6100	0.5700	0.6100	92.6750	12200.00	12200.00	0.00	200	6	230	35272	0.0065207530052166	0.0354503988873168	0.0354503988873168	false	false	false	true
f40a0a43-fa60-47ce-832d-d6157a7185ef	2026-08-31 11:14	2026-08-31 11:14	2026-08-31 11:14	IEF	IEF260918P00092500	put	92.5000	2026-09-18	0.4700	0.4500	0.4700	92.6950	164500.00	164500.00	0.00	3500	45	8570	4633	1.84977336499029	0.0778464282731359	0.0778464282731359	false	false	false	true
82a3b694-d6df-400c-90aa-e63b0265f91e	2026-08-31 11:41	2026-08-31 11:41	2026-08-31 11:41	IEF	IEF260911C00092500	call	92.5000	2026-09-11	0.3500	0.3500	0.3700	92.6750	53235.00	0.00	53235.00	1521	25	1540	2	770	0.0271237982762401	0.0271237982762401	false	false	false	true
cbef1ccd-2254-4673-acb6-56034e90c8af	2026-08-31 13:15	2026-08-31 13:15	2026-08-31 13:15	IEF	IEF260911C00092500	call	92.5000	2026-09-11	0.3500	0.3500	0.3600	92.6900	11690.00	0.00	11690.00	334	22	2175	2	1087.5	0.0248701413518936	0.0248701413518936	false	false	false	true
9d101b54-b258-44d7-a74d-490491487ccf	2026-08-31 15:13	2026-08-31 15:13	2026-08-31 15:13	IEF	IEF270319C00095000	call	95.0000	2027-03-19	0.7900	0.7400	0.7900	92.6869	11850.00	11850.00	0.00	150	15	152	209	0.727272727272727	0.0319652649716646	0.0319652649716646	true	false	false	true
07513430-3411-410b-a20e-d09e8e4404a4	2026-09-01 09:51	2026-09-01 09:51	2026-09-01 09:51	IEF	IEF260918C00093000	call	93.0000	2026-09-18	0.2100	0.2000	0.2200	92.2290	23310.00	0.00	20979.00	1110	20	1160	38342	0.0302540295237598	0.0563553823524418	0.0563553823524418	false	false	false	true
9847aded-1724-422e-a199-4f9853c341e7	2026-09-01 10:31	2026-09-01 10:31	2026-09-01 10:31	IEF	IEF261002C00093000	call	93.0000	2026-10-02	0.4000	0.3800	0.4000	92.3350	20000.00	20000.00	0.00	500	7	579	514	1.12645914396887	0.0521889584661714	0.0521889584661714	false	false	false	true
a37b2c8d-b9db-4594-9bbf-c92b38b5d574	2026-09-01 11:52	2026-09-01 11:52	2026-09-01 11:52	IEF	IEF260918C00092500	call	92.5000	2026-09-18	0.4100	0.4100	0.4200	92.2650	18368.00	0.00	18368.00	448	13	530	35254	0.0150337550348897	0.0558448204175815	0.0558448204175815	false	false	false	true
076b8d8e-6479-4daa-96e8-ae784440b18d	2026-09-02 09:55	2026-09-02 09:55	2026-09-02 09:55	IEF	IEF260904C00092500	call	92.5000	2026-09-04	0.0800	0.0800	0.0900	92.1450	11416.00	0.00	11416.00	1427	26	1427	1170	1.21965811965812	0.0754450877750733	0.0754450877750733	false	false	false	true
0c7bb9ff-d3be-4f5f-8f84-f817aa7c214f	2026-09-02 10:14	2026-09-02 10:14	2026-09-02 10:14	IEF	IEF260904P00092000	put	92.0000	2026-09-04	0.1100	0.1100	0.1300	92.1692	14047.00	0.00	14047.00	1277	24	1277	4242	0.301037246581801	0.0697163232050897	0.0697163232050897	false	false	false	true
5ec63d2c-55d7-43c3-bd0d-2449ccddbed2	2026-09-02 10:37	2026-09-02 10:37	2026-09-02 10:37	IEF	IEF260904P00092000	put	92.0000	2026-09-04	0.1200	0.1200	0.1400	92.1190	12288.00	0.00	12288.00	1024	21	2301	4242	0.542432814710042	0.0665257026641979	0.0665257026641979	false	false	false	true
8b00ca6f-cd54-481b-ae92-e0f7b1040c93	2026-09-02 10:54	2026-09-02 10:53	2026-09-02 10:53	IEF	IEF260904P00092000	put	92.0000	2026-09-04	0.1200	0.1200	0.1400	92.0997	14928.00	0.00	14928.00	1244	24	3547	4242	0.836162187647336	0.0636749618821382	0.0636749618821382	false	false	false	true
9aaa238c-4c1d-456a-a96d-865469aa6742	2026-09-02 11:24	2026-09-02 11:23	2026-09-02 11:23	IEF	IEF260904C00092000	call	92.0000	2026-09-04	0.2400	0.2400	0.2500	92.0600	27864.00	0.00	27864.00	1161	24	1161	113	10.2743362831858	0.0727759818378812	0.0727759818378812	false	false	false	true