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

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	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	41437222647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T17:30:31.713908Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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