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:endpoint = /api/option-trades/flow-alerts×ticker = IRM×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	expiry

b936dc0c-be67-42e0-9a62-c42200e84fef	2026-08-17 09:42	2026-08-17 09:42	2026-08-17 09:42	IRM	IRM261016C00130000	call	130.0000	2026-10-16	5.1000	4.7000	5.7000	127.6800	15300.00	6630.00	3060.00	30	5	30	133	0.225563909774436	0.280462136282918	0.280462136282918	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	33360577113.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2c788377-3860-400d-b62b-3e4730c17fcb	2026-08-17 11:15	2026-08-17 11:15	2026-08-17 11:15	IRM	IRM261016C00130000	call	130.0000	2026-10-16	4.8000	4.5000	4.8000	127.2200	14400.00	9600.00	0.00	30	5	101	133	0.759398496240602	0.27649274266714	0.27649274266714	false	false	false
3bb6fb45-be76-4c3f-a068-825fb6a508b6	2026-08-17 14:21	2026-08-17 14:20	2026-08-17 14:20	IRM	IRM261016C00130000	call	130.0000	2026-10-16	5.5000	5.3000	5.9000	128.6900	18700.00	4400.00	3850.00	34	5	223	133	1.67669172932331	0.275643713439699	0.275643713439699	false	false	false
c876331f-5ae6-4cb0-883d-41a56e9a25ab	2026-08-17 15:39	2026-08-17 15:39	2026-08-17 15:39	IRM	IRM260821C00132000	call	132.0000	2026-08-21	0.7000	0.5500	0.7000	129.0300	10780.00	10780.00	0.00	154	31	168	27	6.22222222222222	0.32907030084255	0.32907030084255	false	false	false
2f9bdc6a-2804-46ab-9b0c-0a56ca5fdbc4	2026-08-17 15:47	2026-08-17 15:47	2026-08-17 15:47	IRM	IRM261016C00130000	call	130.0000	2026-10-16	5.8000	5.2000	6.0000	129.2100	22620.00	9860.00	4640.00	39	5	303	133	2.2781954887218	0.277169704732427	0.277169704732427	false	false	false
af9a1a81-ddb1-4bd8-8191-71b00d915cce	2026-08-19 10:32	2026-08-19 10:32	2026-08-19 10:32	IRM	IRM260918P00120000	put	120.0000	2026-09-18	4.4000	3.6000	4.7000	120.7600	374000.00	374000.00	0.00	850	1	853	156	5.46794871794872	0.359915155632997	0.359915155632997	false	true	false
94ea7d7a-b942-4adf-ba71-15d17d9a8cb2	2026-08-19 11:05	2026-08-19 11:04	2026-08-19 11:04	IRM	IRM260821C00122000	call	122.0000	2026-08-21	1.2500	0.9000	1.2500	121.4100	20250.00	20250.00	0.00	162	31	163	1	163	0.42177048672662	0.42177048672662	false	false	false	true
e7f7959c-2cbb-4786-a9f4-ef5a629c4191	2026-08-20 13:29	2026-08-20 13:29	2026-08-20 13:29	IRM	IRM261016P00125000	put	125.0000	2026-10-16	7.1000	7.0000	8.2000	122.7200	10650.00	0.00	10650.00	15	15	15	117	0.128205128205128	0.323872360182862	0.323872360182862	false	false	false
d6f69fc7-73d6-4178-9bdb-0be7a3a00817	2026-08-20 13:29	2026-08-20 13:29	2026-08-20 13:29	IRM	IRM261016P00125000	put	125.0000	2026-10-16	7.1000	7.0000	8.2000	122.6700	66740.00	15620.00	51120.00	94	74	109	117	0.931623931623932	0.322542716307292	0.322542716307292	false	false	false
0731a34f-e375-471c-b3bd-7353289ba9b9	2026-08-24 14:12	2026-08-24 14:12	2026-08-24 14:12	IRM	IRM260918P00120000	put	120.0000	2026-09-18	4.2000	4.2000	4.7000	120.1700	20160.00	0.00	20160.00	48	5	199	898	0.221603563474388	0.354460459474789	0.354460459474789	false	false	false
a04a9791-a1e0-435b-b713-1f444e598078	2026-08-25 14:53	2026-08-25 14:53	2026-08-25 14:53	IRM	IRM261016C00135000	call	135.0000	2026-10-16	1.3900	1.3000	2.1500	121.6550	91605.00	0.00	91605.00	659	2	660	105	6.28571428571429	0.290000330577407	0.290000330577407	false	true	false
396d0ba5-910f-401b-b24f-d2297e8f6232	2026-08-26 11:39	2026-08-26 11:39	2026-08-26 11:39	IRM	IRM261016C00135000	call	135.0000	2026-10-16	1.5000	1.3000	1.5000	121.6250	45750.00	45750.00	0.00	305	34	307	765	0.401307189542484	0.301504059576064	0.301504059576064	false	false	false
acccab63-4e44-4098-b7f4-6a0c57cfa004	2026-08-27 11:03	2026-08-27 11:03	2026-08-27 11:03	IRM	IRM261218P00115000	put	115.0000	2026-12-18	5.8000	5.5000	5.8000	122.4700	11020.00	5800.00	0.00	19	8	57	274	0.208029197080292	0.366369358789166	0.366369358789166	false	false	false
0f9c6e1b-03e6-428a-a6a6-139d884bdc44	2026-08-28 11:42	2026-08-28 11:42	2026-08-28 11:42	IRM	IRM260918C00125000	call	125.0000	2026-09-18	1.5000	1.3500	1.5000	120.0000	24750.00	6450.00	0.00	165	9	165	289	0.570934256055363	0.279958692569441	0.279958692569441	false	false	false
a572e5e3-285c-4eac-8b7f-910491855d40	2026-08-28 12:34	2026-08-28 12:34	2026-08-28 12:34	IRM	IRM260911P00114000	put	114.0000	2026-09-11	1.0500	1.0500	1.3500	118.5100	13860.00	0.00	13860.00	132	6	146	22	6.63636363636364	0.307014943207731	0.307014943207731	false	false	false
5f830812-87cc-4824-bf3a-54f5379c0526	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	IRM	IRM261218P00110000	put	110.0000	2026-12-18	6.4100	6.1000	6.8000	114.5000	24350.00	6460.00	640.00	38	38	43	107	0.401869158878505	0.366288124637283	0.37482854696223	false	false	false
c220e9d4-4140-454e-b075-6efe7e6f5274	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	IRM	IRM261218P00110000	put	110.0000	2026-12-18	6.4600	6.3000	6.6000	114.5000	29050.00	16890.00	0.00	45	34	88	107	0.822429906542056	0.370559697531524	0.37482854696223	false	false	false
6b0c3b6d-2c96-49e0-8c34-62cadbeb5eda	2026-08-31 11:39	2026-08-31 11:39	2026-08-31 11:39	IRM	IRM260918P00115000	put	115.0000	2026-09-18	3.9000	3.6000	3.9000	114.4000	38220.00	38220.00	0.00	98	24	116	4842	0.0239570425444031	0.365116850749098	0.365116850749098	false	false	false
3f6f9a3b-f6ea-4626-acd9-adcf37dd7f6f	2026-08-31 13:14	2026-08-31 13:13	2026-08-31 13:13	IRM	IRM261016C00130000	call	130.0000	2026-10-16	0.8500	0.7500	0.8500	114.2200	12325.00	12325.00	0.00	145	19	187	660	0.283333333333333	0.308778020701476	0.308778020701476	false	false	false
e5b2939a-f208-476b-bd77-9884f5e4635a	2026-08-31 13:32	2026-08-31 13:32	2026-08-31 13:32	IRM	IRM261016P00115000	put	115.0000	2026-10-16	5.5000	5.5000	5.6000	114.3500	45102.00	0.00	45102.00	82	24	101	27	3.74074074074074	0.336832389507253	0.336832389507253	false	false	false
d3d8ad3c-5062-4a48-a1fa-c1e3b07f1df4	2026-09-01 11:35	2026-09-01 11:35	2026-09-01 11:35	IRM	IRM261218P00110000	put	110.0000	2026-12-18	6.2000	5.9000	7.3000	115.0400	31620.00	17980.00	13640.00	51	14	61	196	0.311224489795918	0.373141597064658	0.370114759799397	false	false	false
843306af-ba51-4a6d-a13b-af24d4d4a7de	2026-09-01 14:09	2026-09-01 14:09	2026-09-01 14:09	IRM	IRM260904C00115000	call	115.0000	2026-09-04	1.2000	1.0000	1.2000	114.1600	20277.00	20277.00	0.00	169	33	170	1	170	0.37879677611749	0.37879677611749	false	false	false	true
fcb41e15-61a8-4221-92d1-2e016ac080a7	2026-09-01 14:23	2026-09-01 14:23	2026-09-01 14:23	IRM	IRM261016C00120000	call	120.0000	2026-10-16	2.5000	2.0000	2.8500	113.9400	515935.00	512750.00	3185.00	2064	6	2117	26	81.4230769230769	0.287728394439331	0.291141391370966	false	false	false
a3d949e5-5c53-445f-9deb-b8b19f3f8888	2026-09-03 11:18	2026-09-03 11:18	2026-09-03 11:18	IRM	IRM261016C00120000	call	120.0000	2026-10-16	2.3500	2.3500	2.5500	114.2200	16220.00	0.00	16220.00	69	21	84	2358	0.0356234096692112	0.280753745931535	0.280753745931535	false	false	false
46cbfa93-2868-4bcb-8415-3b96f2ce651f	2026-09-10 15:11	2026-09-10 15:11	2026-09-10 15:11	IRM	IRM270115C00120000	call	120.0000	2027-01-15	5.9000	5.6000	6.1000	112.8150	18290.00	17700.00	590.00	31	10	31	82	0.378048780487805	0.308338181509851	0.308338181509851	false	false	false
3b48b406-d268-45bb-8d76-362e92faf01f	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	IRM	IRM261218C00120000	call	120.0000	2026-12-18	5.1000	4.6000	5.1000	113.6300	23460.00	23460.00	0.00	46	14	47	200	0.235	0.314153473998047	0.314153473998047	false	false	false
4ec31f49-3078-492e-bd3c-f8d2d1d4eca8	2026-09-14 15:34	2026-09-14 15:34	2026-09-14 15:34	IRM	IRM261218C00125000	call	125.0000	2026-12-18	3.3000	3.0000	3.3000	113.1700	16500.00	16500.00	0.00	50	13	67	75	0.893333333333333	0.309101552845791	0.309101552845791	false	false	false
ec2f8da5-9014-4a63-a8ce-ccb871156da3	2026-09-15 12:53	2026-09-15 12:53	2026-09-15 12:53	IRM	IRM261016P00110000	put	110.0000	2026-10-16	2.8000	2.7000	3.1000	112.8050	109200.00	108640.00	560.00	390	27	410	87	4.71264367816092	0.32506808486984	0.32506808486984	false	false	false
971e37d7-94e8-4c6f-a7fc-37668bc54ace	2026-09-15 15:35	2026-09-15 15:35	2026-09-15 15:35	IRM	IRM261218C00120000	call	120.0000	2026-12-18	4.8000	4.5000	4.8000	112.0700	24480.00	24480.00	0.00	51	15	51	246	0.207317073170732	0.328737405623494	0.328737405623494	false	false	false
33305049-66a9-4223-84ca-b14240d914d3	2026-09-15 15:40	2026-09-15 15:40	2026-09-15 15:40	IRM	IRM270115C00115000	call	115.0000	2027-01-15	7.6000	7.2000	8.2000	111.9400	18240.00	15200.00	3040.00	24	7	24	82	0.292682926829268	0.320299098241401	0.320299098241401	false	false	false
5a6d13c9-ab58-42f2-8c7b-9de56401fa36	2026-09-16 14:27	2026-09-16 14:27	2026-09-16 14:27	IRM	IRM260918P00114000	put	114.0000	2026-09-18	1.3000	1.0500	1.3000	114.0475	11570.00	11570.00	0.00	89	20	89	75	1.18666666666667	0.396736251529116	0.396736251529116	false	false	false
c7d25756-d2f2-40e1-96d1-84fb73ef6079	2026-09-17 12:30	2026-09-17 12:30	2026-09-17 12:30	IRM	IRM261016C00125000	call	125.0000	2026-10-16	0.8500	0.8000	0.9500	114.3000	12070.00	170.00	11900.00	142	9	152	247	0.615384615384615	0.305328292728258	0.305328292728258	false	false	false
793c57a7-2ca0-423b-ba88-ae5680eeb601	2026-09-17 15:47	2026-09-17 15:47	2026-09-17 15:47	IRM	IRM261120C00115000	call	115.0000	2026-11-20	6.9000	6.5000	7.3000	114.3800	126960.00	126270.00	690.00	184	37	184	0	0	0.358168705358614	0.356204990728755	false	false	false
b8d911b7-941b-4aee-a8d5-d1050e36b60b	2026-09-18 12:03	2026-09-18 12:03	2026-09-18 12:03	IRM	IRM260918P00120000	put	120.0000	2026-09-18	6.1000	6.0000	6.6000	113.0000	21960.00	14030.00	4880.00	36	20	45	333	0.135135135135135	0.30215445000241	0.30215445000241	false	false	false
2562bd45-6375-4a0c-9c5a-fabd6d1ce480	2026-09-18 12:31	2026-09-18 12:30	2026-09-18 12:30	IRM	IRM260918P00120000	put	120.0000	2026-09-18	6.2000	5.9000	6.2000	113.6100	12400.00	6200.00	0.00	20	9	68	333	0.204204204204204	0.311167378424041	0.311167378424041	false	false	false
7baac0a9-a774-4d79-8f53-31a1261eab54	2026-09-18 13:54	2026-09-18 13:54	2026-09-18 13:54	IRM	IRM260918P00120000	put	120.0000	2026-09-18	5.5000	5.4000	5.5000	114.4850	12650.00	9350.00	0.00	23	10	123	333	0.369369369369369	1.40047287245773	1.40047287245773	false	false	false
557b596c-2aeb-4e50-935d-685b1e51d0f0	2026-09-18 14:11	2026-09-18 14:11	2026-09-18 14:11	IRM	IRM260918P00120000	put	120.0000	2026-09-18	5.7000	5.7000	5.7000	114.1200	15390.00	0.00	0.00	27	11	150	333	0.45045045045045	0.999143108842864	0.999143108842864	false	false	false
4946c454-303e-489f-9edb-39b39f29f2e8	2026-09-18 15:07	2026-09-18 15:07	2026-09-18 15:07	IRM	IRM260925P00110000	put	110.0000	2026-09-25	0.5000	0.4500	0.6500	114.0700	13700.00	2300.00	2700.00	274	36	326	851	0.383078730904818	0.306375346737475	0.306375346737475	false	false	false
6a10464d-ec15-4f70-a663-1690964ee81d	2026-09-18 15:07	2026-09-18 15:07	2026-09-18 15:07	IRM	IRM260925P00110000	put	110.0000	2026-09-25	0.4500	0.3500	0.7000	114.1900	13725.00	6435.00	7290.00	305	65	695	851	0.81668625146886	0.294773007150379	0.299494452467784	false	false	false
5be09fee-2560-4adf-b75a-d5320e0a8b34	2026-09-18 15:08	2026-09-18 15:07	2026-09-18 15:07	IRM	IRM260918P00120000	put	120.0000	2026-09-18	5.7000	5.3000	6.1000	114.1800	22800.00	11400.00	1710.00	40	16	211	333	0.633633633633634	1.26756396721781	1.26756396721781	false	false	false
0eb871d1-2075-48a5-a683-731f91aed6de	2026-09-21 12:55	2026-09-21 12:55	2026-09-21 12:55	IRM	IRM270115C00130000	call	130.0000	2027-01-15	3.5000	3.4000	3.8000	115.0000	28000.00	0.00	28000.00	80	5	87	211	0.412322274881517	0.299980249507868	0.299980249507868	false	false	false
2409c36e-dcf0-4bcc-87d1-da45b6b192b1	2026-09-21 13:18	2026-09-21 13:18	2026-09-21 13:18	IRM	IRM270115C00140000	call	140.0000	2027-01-15	1.8000	1.5000	1.8000	116.0000	14400.00	14400.00	0.00	80	8	83	225	0.368888888888889	0.306018390323483	0.306018390323483	false	false	false