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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = IYR×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

460ecc6c-968c-4b79-8ffa-0537f0eb0efa	2026-08-19 15:56	2026-08-19 15:56	2026-08-19 15:56	IYR	IYR260918P00102000	put	102.0000	2026-09-18	0.7500	0.7500	0.8500	104.6950	10950.00	0.00	10950.00	146	6	2338	4709	0.496496071352729	0.159775407677228	0.159775407677228	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4635050038.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
342f9b3f-48f9-4a25-b9f5-31128aeec3f8	2026-08-20 15:00	2026-08-20 15:00	2026-08-20 15:00	IYR	IYR260821P00107000	put	107.0000	2026-08-21	1.8500	1.5500	1.9500	105.1600	18500.00	18500.00	0.00	100	10	100	13	7.69230769230769	0.196362216187381	0.196362216187381	false	false	false	true	false
33a54951-7e2f-4267-aa63-5f953f40aca6	2026-08-20 15:07	2026-08-20 15:07	2026-08-20 15:07	IYR	IYR260911P00104000	put	104.0000	2026-09-11	0.9000	0.6000	0.9000	105.1500	945000.00	945000.00	0.00	10500	2	10500	5	2100	0.145813547968164	0.145813547968164	false	true	true	false	true
09995ff8-e212-4855-b095-3604ae9a8389	2026-08-21 11:50	2026-08-21 11:50	2026-08-21 11:50	IYR	IYR260918C00106000	call	106.0000	2026-09-18	0.8500	0.8500	1.0000	104.6950	34425.00	0.00	34000.00	405	11	1430	8595	0.166375799883653	0.11075930365778	0.11075930365778	false	false	false	true	false
00d13925-511e-4399-8d57-15c0c8165b5d	2026-08-21 11:52	2026-08-21 11:52	2026-08-21 11:52	IYR	IYR260918C00106000	call	106.0000	2026-09-18	0.8500	0.8000	1.0000	104.6800	13260.00	85.00	13005.00	156	6	1658	8595	0.192902850494474	0.11127938767912	0.11127938767912	false	false	false	true	false
39e226db-f7db-443c-b4e4-0d9bf41fbc03	2026-08-24 13:19	2026-08-24 13:19	2026-08-24 13:19	IYR	IYR261016P00105000	put	105.0000	2026-10-16	2.3000	2.2500	2.3000	105.0500	10580.00	10580.00	0.00	46	7	69	349	0.197707736389685	0.163438562694011	0.163438562694011	false	false	false	true	false
7b63e124-1792-401b-85dc-1e146c48807d	2026-08-24 15:44	2026-08-24 15:44	2026-08-24 15:44	IYR	IYR261016C00105000	call	105.0000	2026-10-16	2.2000	2.2000	2.3500	105.1450	251460.00	0.00	251460.00	1143	24	1308	435	3.00689655172414	0.113998943555125	0.113998943555125	false	false	false	true	false
21ae9dd3-e9a5-428a-8243-53e5b156e4b9	2026-08-28 10:24	2026-08-28 10:24	2026-08-28 10:24	IYR	IYR261016P00104000	put	104.0000	2026-10-16	2.2100	2.0000	2.4000	103.8950	44146.00	1760.00	16426.00	200	19	250	296	0.844594594594595	0.160155037340104	0.158831544097306	false	false	false	true	false
5ac20f87-eeb8-4546-a39c-f51dd3f9ce0c	2026-08-28 15:14	2026-08-28 15:14	2026-08-28 15:14	IYR	IYR261218P00099000	put	99.0000	2026-12-18	1.8500	1.8500	2.1000	103.5650	23125.00	0.00	23125.00	125	32	128	0	0	0.184147760708906	0.184147760708906	false	false	false	true	false
6601ee12-1697-499b-a6e9-ec4239bc8f3e	2026-08-31 11:04	2026-08-31 11:04	2026-08-31 11:04	IYR	IYR260918P00102000	put	102.0000	2026-09-18	1.3500	1.1500	1.6500	102.5400	13365.00	12825.00	270.00	99	11	99	6829	0.0144969980963538	0.186856451517773	0.186856451517773	false	false	false	true	false
4fd6d461-a5de-4060-90b0-aa48cdc1db86	2026-08-31 13:49	2026-08-31 13:49	2026-08-31 13:49	IYR	IYR260911P00104000	put	104.0000	2026-09-11	1.8000	1.7000	1.9500	102.0000	630000.00	0.00	630000.00	3500	2	3505	10523	0.333079920174855	0.12894972390245	0.12894972390245	false	true	true	false	false
99e2c868-091f-48be-b97d-d251cf64803e	2026-09-01 13:55	2026-09-01 13:54	2026-09-01 13:54	IYR	IYR261218P00096000	put	96.0000	2026-12-18	1.4000	1.4000	1.6500	102.4950	22120.00	0.00	22120.00	158	33	158	38	4.15789473684211	0.193492655558211	0.193492655558211	false	false	false	true	false
b3f87f7a-754d-4015-a5df-9055941d264c	2026-09-02 10:11	2026-09-02 10:11	2026-09-02 10:11	IYR	IYR261120C00105000	call	105.0000	2026-11-20	1.3500	1.3500	1.6000	101.5200	156600.00	0.00	156600.00	1160	24	1173	10	117.3	0.127340001761622	0.127340001761622	false	false	false	true	false
6dd60e31-6b97-4e73-91c5-52e025b133c5	2026-09-03 15:22	2026-09-03 15:22	2026-09-03 15:22	IYR	IYR261218P00097000	put	97.0000	2026-12-18	1.4000	1.1000	1.4000	102.7600	11750.00	11750.00	0.00	84	20	84	2024	0.041501976284585	0.183612482973212	0.183612482973212	true	false	false	true	false
66adccea-190b-41f7-a8fe-e11295863226	2026-09-08 15:14	2026-09-08 15:14	2026-09-08 15:14	IYR	IYR260911C00103000	call	103.0000	2026-09-11	0.3500	0.2500	0.4000	102.4100	13980.00	12580.00	1365.00	400	49	417	30	13.9	0.158125342258082	0.158125342258082	false	false	false	true	false
dd6554f7-aad0-45a9-981d-905df3f3cfb3	2026-09-09 11:17	2026-09-09 11:16	2026-09-09 11:16	IYR	IYR260918P00099000	put	99.0000	2026-09-18	0.5500	0.5000	0.5500	100.9250	19744.00	19744.00	0.00	359	29	1029	7086	0.145215918712955	0.211063965560401	0.211063965560401	false	false	false	true	false
4483b1e9-ed48-4bab-8a41-122f8344b610	2026-09-10 10:41	2026-09-10 10:41	2026-09-10 10:41	IYR	IYR260918P00102000	put	102.0000	2026-09-18	1.9400	1.9000	2.1000	100.9700	29143.00	0.00	29143.00	150	28	203	4979	0.0407712392046596	0.243555977300318	0.229720467126537	false	false	false	true	false
f36bfc35-f0cb-4f84-9912-20702228b2f7	2026-09-10 15:15	2026-09-10 15:15	2026-09-10 15:15	IYR	IYR270115P00098000	put	98.0000	2027-01-15	2.9500	2.1000	2.9500	99.9050	13580.00	13580.00	0.00	46	13	46	203	0.226600985221675	0.187466022742067	0.187466022742067	true	false	false	true	false
a019403c-4fa5-4e67-bc03-9a1799a16da7	2026-09-10 15:15	2026-09-10 15:15	2026-09-10 15:15	IYR	IYR270115P00096000	put	96.0000	2027-01-15	2.2500	1.6000	2.2500	99.9050	14630.00	14630.00	0.00	65	10	65	55	1.18181818181818	0.189225713006055	0.189225713006055	true	false	false	true	false
9d7d1ab5-172a-46f0-93f1-db413afb36b2	2026-09-10 15:15	2026-09-10 15:15	2026-09-10 15:15	IYR	IYR270115P00097000	put	97.0000	2027-01-15	2.6000	2.5500	2.6000	99.9050	54293.00	52751.00	1542.00	209	29	209	1754	0.119156214367161	0.189120919926881	0.189120919926881	true	false	false	true	false
db17c0a2-a125-4217-81be-a6887298f360	2026-09-15 09:30	2026-09-15 09:30	2026-09-15 09:30	IYR	IYR261218P00114000	put	114.0000	2026-12-18	14.8000	12.5000	14.8000	99.4200	23680.00	23680.00	0.00	16	5	133	0	0	0.272743251139818	0.272743251139818	true	false	false	true	false
e4734b9f-636b-46e6-95de-6e130d51125a	2026-09-15 13:21	2026-09-15 13:21	2026-09-15 13:21	IYR	IYR261009P00099500	put	99.5000	2026-10-09	1.6500	1.3500	1.6500	99.0300	18480.00	18480.00	0.00	112	9	112	0	0	0.151997932815353	0.151997932815353	true	false	false	true	false
6aa4dd76-b65c-45cd-a70d-dbcc9cbb3170	2026-09-16 15:19	2026-09-16 15:19	2026-09-16 15:19	IYR	IYR260918P00102000	put	102.0000	2026-09-18	3.4000	3.1000	3.7000	98.3600	170000.00	0.00	0.00	500	1	502	3015	0.166500829187396	0.336643655895526	0.336643655895526	false	true	false	true	false
2f940acc-efeb-4a11-aa49-c87d6f7854ab	2026-09-17 10:26	2026-09-17 10:26	2026-09-17 10:26	IYR	IYR270115P00090000	put	90.0000	2027-01-15	0.9500	0.9500	1.1500	98.9350	18810.00	0.00	3040.00	198	33	198	214	0.925233644859813	0.197168567870886	0.197168567870886	false	false	false	true	false
3df64ed9-8b95-4e9a-93c6-2b5711343ef9	2026-09-17 10:27	2026-09-17 10:27	2026-09-17 10:27	IYR	IYR270115P00090000	put	90.0000	2027-01-15	0.9600	0.9500	1.0500	98.9400	28704.00	0.00	28704.00	299	7	552	214	2.57943925233645	0.19796584817615	0.19796584817615	false	false	false	true	false
2f783a09-527c-455e-ac31-6c862f1c0873	2026-09-17 15:53	2026-09-17 15:53	2026-09-17 15:53	IYR	IYR261016C00100000	call	100.0000	2026-10-16	1.1000	1.1000	1.4500	98.0000	49783.00	0.00	49783.00	451	58	625	134	4.66417910447761	0.129035495706913	0.127210765767943	false	false	false	true	false
e744f750-3dc7-4c20-a213-fe540705af3f	2026-09-17 15:53	2026-09-17 15:53	2026-09-17 15:53	IYR	IYR261016C00100000	call	100.0000	2026-10-16	1.1500	1.1000	1.1500	99.0000	10350.00	10350.00	0.00	90	6	805	134	6.00746268656716	0.130779615860525	0.130779615860525	true	false	false	true	false
523d7d34-0fe7-4228-af02-19f20f8e12ab	2026-09-17 15:53	2026-09-17 15:53	2026-09-17 15:53	IYR	IYR261016C00100000	call	100.0000	2026-10-16	1.1500	1.1000	1.4500	99.0000	93150.00	11385.00	81765.00	810	43	1615	134	12.0522388059701	0.130585685895093	0.130581726675731	true	false	false	true	false
cc32180a-f3e2-4732-aa28-39f0b65bc42a	2026-09-22 09:54	2026-09-22 09:54	2026-09-22 09:54	IYR	IYR270617P00092000	put	92.0000	2027-06-17	2.8000	2.4500	2.8500	98.7600	12320.00	5880.00	2800.00	44	6	64	0	0	0.204079223947939	0.204264679128126	false	false	false	true	false