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:er_time = unknown×ticker = EMR×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

171b570c-9200-46ca-9519-162723ecd964	2026-09-22 10:54	2026-09-22 10:54	2026-09-22 10:54	EMR	EMR261218C00180000	call	180.0000	2026-12-18	1.5500	1.5500	2.7000	152.9838	46035.00	0.00	46035.00	297	5	630	178	3.53932584269663	0.283151078398658	0.283151078398658	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	86007182000.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
9062d955-c76f-409f-9207-e82273af8662	2026-09-21 14:59	2026-09-21 14:59	2026-09-21 14:59	EMR	EMR261120C00175000	call	175.0000	2026-11-20	1.5000	1.3500	1.7000	151.8600	49350.00	150.00	49200.00	329	20	392	0	0	0.311987776940272	0.311987776940272	false	false	false	true	false
2af722d6-98c9-4b7e-bb27-3284a66d8f62	2026-09-21 11:08	2026-09-21 11:08	2026-09-21 11:08	EMR	EMR270115C00170000	call	170.0000	2027-01-15	3.7000	3.7000	4.4000	151.0550	16280.00	0.00	16280.00	44	6	183	333	0.54954954954955	0.276058026376096	0.276058026376096	false	false	false	true	false
0992de50-21f6-40ea-b17f-b9d018ddba19	2026-09-21 11:08	2026-09-21 11:08	2026-09-21 11:08	EMR	EMR261218C00160000	call	160.0000	2026-12-18	5.3600	5.3000	6.0000	151.0700	23600.00	0.00	23600.00	44	10	95	2114	0.0449385052034059	0.279673090082215	0.283181851044211	false	false	false	true
440ac1bc-5932-4648-8850-7703f853201c	2026-09-21 10:27	2026-09-21 10:27	2026-09-21 10:27	EMR	EMR261218P00155000	put	155.0000	2026-12-18	10.7000	10.0000	10.7000	151.1450	23540.00	23540.00	0.00	22	5	23	79	0.291139240506329	0.318668621579569	0.318668621579569	false	false	false	true	false
f9159aad-0f67-4d85-ac47-fde8975a8777	2026-09-15 10:02	2026-09-15 10:02	2026-09-15 10:02	EMR	EMR261218C00160000	call	160.0000	2026-12-18	4.8000	4.8000	5.9000	147.4700	163680.00	0.00	163680.00	341	6	586	513	1.14230019493177	0.298176962439015	0.298176962439015	false	false	false	true
8a7c801d-db31-4913-b376-fb2865c34a7c	2026-09-14 15:35	2026-09-14 15:34	2026-09-14 15:34	EMR	EMR270917P00110000	put	110.0000	2027-09-17	5.8900	3.7000	6.0000	148.4300	131879.00	108419.00	8710.00	224	6	224	214	1.04672897196262	0.41081716925442	0.379143736560827	true	false	false	true	false
11ea4d4f-ea87-49f2-832c-aed0e5df927b	2026-09-14 15:35	2026-09-14 15:34	2026-09-14 15:34	EMR	EMR270917P00145000	put	145.0000	2027-09-17	14.8700	14.2000	18.0000	148.4300	306424.00	0.00	306424.00	206	8	206	208	0.990384615384615	0.336774958481882	0.336774958481882	false	false	false	true
8699f77d-d829-48c1-9688-dfe56cde13ce	2026-09-10 12:00	2026-09-10 12:00	2026-09-10 12:00	EMR	EMR261016C00145000	call	145.0000	2026-10-16	7.9000	7.6000	8.5000	148.2037	135090.00	134300.00	790.00	171	37	171	8	21.375	0.317897287344654	0.317897287344654	false	false	false	true	false
395b1b91-2303-4751-8f43-030474f0897d	2026-08-27 13:42	2026-08-27 13:42	2026-08-27 13:42	EMR	EMR261218C00175000	call	175.0000	2026-12-18	5.0000	4.5000	5.0000	158.2600	127500.00	127500.00	0.00	255	33	256	237	1.08016877637131	0.293758900509662	0.293758900509662	false	false	false	true
4037cc35-1ba1-4e41-946b-05ed5f317df7	2026-08-24 15:46	2026-08-24 15:46	2026-08-24 15:46	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.0000	32.6000	33.3000	157.5350	66000.00	3300.00	62700.00	20	18	1230	10534	0.116764761723942	0.341742486533901	0.341742486533901	false	false	false	true
9cd20384-284c-49cf-abf0-eacaacdce21e	2026-08-24 15:42	2026-08-24 15:42	2026-08-24 15:42	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.8000	32.8000	33.3000	157.5200	124640.00	0.00	124640.00	38	11	1208	10534	0.114676286310993	0.338901621448391	0.338901621448391	false	false	false	true
0b2dcc97-e136-45b8-9381-9b82ad9a9088	2026-08-24 15:27	2026-08-24 15:26	2026-08-24 15:26	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.0000	32.5000	33.3000	157.4900	198000.00	6600.00	49500.00	60	19	1170	10534	0.111068919688627	0.342201186516739	0.342201186516739	false	false	false	true
bc79a1c2-ca55-491b-ac52-99089f8035b4	2026-08-24 15:13	2026-08-24 15:13	2026-08-24 15:13	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.0000	33.0000	33.4000	157.6200	52800.00	0.00	52800.00	16	13	1095	10534	0.103949117144485	0.340875423935521	0.340875423935521	false	false	false	true
c96699e1-8f3f-40ef-b8be-a9fdc9391dec	2026-08-24 15:12	2026-08-24 15:11	2026-08-24 15:11	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.9000	32.9000	33.3000	157.4700	128310.00	0.00	128310.00	39	11	1079	10534	0.102430225935067	0.340908332402639	0.340908332402639	false	false	false	true
a30a0506-4056-4f76-bb19-14676eb35e1d	2026-08-24 14:57	2026-08-24 14:57	2026-08-24 14:57	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.8000	32.1000	33.1000	157.2400	164000.00	6560.00	157440.00	50	28	1020	10534	0.0968293146003417	0.341753160447272	0.341753160447272	false	false	false	true
169231d0-45c2-461f-a8fc-45724af120ca	2026-08-24 14:43	2026-08-24 14:43	2026-08-24 14:43	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.9000	32.1000	33.2000	157.3650	197400.00	9870.00	187530.00	60	18	960	10534	0.0911334725650275	0.341977802213431	0.341977802213431	false	false	false	true
773fb217-4595-47dc-9fed-fd2f4a47f5b8	2026-08-24 14:25	2026-08-24 14:25	2026-08-24 14:25	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.6000	32.6000	32.9000	156.9200	195600.00	0.00	88020.00	60	18	900	10534	0.0854376305297133	0.342010013709978	0.342010013709978	false	false	false	true
16496d77-ef5d-4b10-9f06-80a8a9204b93	2026-08-24 14:13	2026-08-24 14:13	2026-08-24 14:13	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.7000	32.2000	32.9000	156.9700	163500.00	6540.00	13080.00	50	18	840	10534	0.0797417884943991	0.342998852024802	0.342998852024802	false	false	false	true
dd870fda-2a12-4ff3-8b09-b4cec87d3fd3	2026-08-24 13:57	2026-08-24 13:57	2026-08-24 13:57	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.7000	32.7000	33.0000	156.9200	196200.00	0.00	196200.00	60	18	780	10534	0.0740459464590849	0.343505765889154	0.343505765889154	false	false	false	true
3274a13b-d76b-412d-a5d8-ec85b4bd9353	2026-08-24 13:42	2026-08-24 13:42	2026-08-24 13:42	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.6000	32.1000	32.9000	156.8350	195600.00	9780.00	185820.00	60	18	720	10534	0.0683501044237707	0.342871345629016	0.342871345629016	false	false	false	true
8482ae03-9288-495e-90c3-2b74bd3874b5	2026-08-24 13:27	2026-08-24 13:27	2026-08-24 13:27	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.7000	31.7000	33.1000	157.0950	196200.00	9810.00	186390.00	60	28	660	10534	0.0626542623884564	0.341730373613169	0.341730373613169	false	false	false	true
1780bace-15a6-4c88-9ef0-d373e6e1f823	2026-08-24 13:15	2026-08-24 13:15	2026-08-24 13:15	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.8000	31.7000	33.5000	157.1600	55760.00	3280.00	52480.00	17	17	600	10534	0.0569584203531422	0.342566261468199	0.342566261468199	false	false	false	true
01dfdd68-8a68-48a7-9bf7-e9c8d4232e41	2026-08-24 13:14	2026-08-24 13:13	2026-08-24 13:13	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.0000	33.0000	33.2000	157.2050	59400.00	0.00	59400.00	18	6	573	10534	0.0543952914372508	0.345101037827927	0.345101037827927	false	false	false	true
cab733cc-5381-4589-bc8a-b3f5ebb447b2	2026-08-24 12:58	2026-08-24 12:57	2026-08-24 12:57	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.9000	32.1000	33.5000	156.7750	111860.00	3290.00	88830.00	34	18	540	10534	0.051262578317828	0.347964713048481	0.347964713048481	false	false	false	true
5472f248-28df-4c47-bde8-25c65a1c8d82	2026-08-24 12:56	2026-08-24 12:56	2026-08-24 12:56	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.7000	32.7000	33.3000	156.8400	65400.00	0.00	65400.00	20	10	506	10534	0.0480349344978166	0.344316267594119	0.344316267594119	false	false	false	true
7666fea1-0c0a-461d-8675-c1d6836d5dae	2026-08-24 12:42	2026-08-24 12:42	2026-08-24 12:42	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.0000	32.3000	33.4000	156.8150	198000.00	9900.00	19800.00	60	18	480	10534	0.0455667362825138	0.349055071921382	0.349055071921382	false	false	false	true
2b4ebe9c-c386-46bb-955f-8827aa7f37b9	2026-08-24 12:27	2026-08-24 12:27	2026-08-24 12:27	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.0000	33.0000	33.4000	157.0950	198000.00	0.00	69300.00	60	18	420	10534	0.0398708942471995	0.346217905601979	0.346217905601979	false	false	false	true
f1f17146-ab99-4e3b-9531-a474b994a16b	2026-08-24 12:14	2026-08-24 12:14	2026-08-24 12:14	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.2000	32.6000	33.5000	157.3500	199200.00	139440.00	9960.00	60	19	360	10534	0.0341750522118853	0.347127259584073	0.346618889680714	true	false	false	true
7a730522-85e6-4cbd-a0d3-8529cdd1d236	2026-08-24 11:57	2026-08-24 11:57	2026-08-24 11:57	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.0000	32.3000	33.5000	156.8800	198000.00	9900.00	89100.00	60	18	300	10534	0.0284792101765711	0.348397170712321	0.348397170712321	true	false	false	true
aee701b0-8c34-4cd6-b999-c041a191c995	2026-08-24 11:42	2026-08-24 11:42	2026-08-24 11:42	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.9000	32.9000	33.5000	156.6450	98700.00	0.00	19740.00	30	10	210	10534	0.0199354471235998	0.349278932655882	0.349278932655882	false	false	false	true
09017abb-1943-4b64-b32d-eeca5ddf8004	2026-08-24 11:42	2026-08-24 11:42	2026-08-24 11:42	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.9000	32.0000	33.4000	156.6450	98700.00	9870.00	88830.00	30	8	240	10534	0.0227833681412569	0.349278932655882	0.349278932655882	false	false	false	true
731d7805-4f37-4325-afb9-f10b8036d369	2026-08-24 11:27	2026-08-24 11:27	2026-08-24 11:27	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.9000	32.9000	33.3000	156.4700	59220.00	0.00	6580.00	18	18	180	10534	0.0170875261059427	0.351045384608548	0.351045384608548	false	false	false	true
e91b88d2-9bfb-434c-b709-2f9bf9bef9a1	2026-08-24 11:25	2026-08-24 11:25	2026-08-24 11:25	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.5000	32.5000	33.3000	156.3450	136500.00	0.00	9750.00	42	14	162	10534	0.0153787734953484	0.346327030607257	0.346327030607257	false	false	false	true
da48306a-a1dc-4d70-a3f5-5743e7ee4c39	2026-08-24 11:12	2026-08-24 11:12	2026-08-24 11:12	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.0000	32.0000	33.5000	156.5700	198000.00	9900.00	19800.00	60	18	120	10534	0.0113916840706284	0.351531004665865	0.351531004665865	false	false	false	true
263e6ae9-8bde-407e-9a2b-4049a1e1b164	2026-08-24 11:01	2026-08-24 11:01	2026-08-24 11:01	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.2000	33.2000	33.5000	156.9700	142760.00	0.00	13280.00	43	18	60	10534	0.00569584203531422	0.350475882025093	0.350475882025093	false	false	false	true
22ce2aaa-67cd-4c41-8535-225b56c260d7	2026-08-21 15:36	2026-08-21 15:36	2026-08-21 15:36	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.7000	32.7000	33.0000	156.9400	245250.00	0.00	245250.00	75	18	1541	9034	0.170577817135267	0.343511549698325	0.342703981982842	true	false	false	true
e1cfe0c0-ebf5-478e-bfdd-757d838a28ec	2026-08-21 15:22	2026-08-21 15:22	2026-08-21 15:22	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.6000	32.6000	33.0000	156.7900	71721.00	0.00	71721.00	22	19	1466	9034	0.162275846800974	0.342727139278997	0.342727139278997	true	false	false	true
a2c70f9c-9cd7-451c-84dc-d8155aa40057	2026-08-21 15:06	2026-08-21 15:06	2026-08-21 15:06	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.6000	32.6000	32.7000	156.6600	81500.00	0.00	81500.00	25	13	1365	9034	0.151095860084127	0.344037309536564	0.344037309536564	false	false	false	true
a13276f5-745a-4ac8-848a-56471fc8fddc	2026-08-21 15:05	2026-08-21 15:05	2026-08-21 15:05	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.7000	32.7000	33.0000	156.7500	114450.00	0.00	114450.00	35	8	1340	9034	0.148328536639362	0.344620850470818	0.344620850470818	false	false	false	true
6c5dd74b-7e8d-4983-a225-e24583cd0e69	2026-08-21 14:41	2026-08-21 14:41	2026-08-21 14:41	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	32.3000	32.5000	156.1200	177650.00	0.00	177650.00	55	13	1285	9034	0.142240425060881	0.344992482788538	0.344992482788538	false	false	false	true
33ed79d5-28b1-40c4-ba2a-31afe03e3299	2026-08-21 14:30	2026-08-21 14:30	2026-08-21 14:30	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.2000	32.2000	32.6000	156.1500	132020.00	0.00	132020.00	41	18	1229	9034	0.136041620544609	0.343202002798373	0.343202002798373	true	false	false	true
b2ca336a-9cce-41ae-8ad1-f81af9058d84	2026-08-21 14:29	2026-08-21 14:29	2026-08-21 14:29	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	32.3000	32.6000	156.2100	90440.00	0.00	90440.00	28	14	1188	9034	0.131503210095196	0.344090129096828	0.344090129096828	false	false	false	true
1378f4b7-1f42-4f69-a706-78a254feeee1	2026-08-21 14:03	2026-08-21 14:03	2026-08-21 14:03	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.2000	32.2000	32.5000	155.0000	135240.00	0.00	135240.00	42	14	1121	9034	0.124086783263228	0.345055139511475	0.345055139511475	false	false	false	true
a386f1cd-0b24-41e0-a6b3-8a8334ecec9b	2026-08-21 13:52	2026-08-21 13:52	2026-08-21 13:52	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	32.3000	32.5000	155.9750	216410.00	0.00	38760.00	67	16	1071	9034	0.118552136373699	0.346444576490339	0.346444576490339	false	false	false	true
25c856c2-c850-425c-aa1c-c85768c46166	2026-08-21 13:23	2026-08-21 13:23	2026-08-21 13:23	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.8000	32.8000	33.7000	155.9950	246000.00	0.00	39360.00	75	18	1004	9034	0.111135709541731	0.353690855411829	0.353690855411829	false	false	false	true
2825ccc9-fee3-499d-9de9-145001bcb437	2026-08-21 13:04	2026-08-21 13:04	2026-08-21 13:04	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	32.0000	32.5000	155.9450	242250.00	12920.00	167960.00	75	18	929	9034	0.102833739207439	0.346744751404521	0.346744751404521	false	false	false	true
7779a57f-335c-4cd6-9b57-567efae28398	2026-08-21 13:04	2026-08-21 13:03	2026-08-21 13:03	EMR	EMR270617P00170000	put	170.0000	2027-06-17	23.8000	23.4000	24.8000	155.9400	161818.00	2350.00	159468.00	68	5	75	0	0	0.332751779054649	0.327475671853852	false	false	false	true	false
0f2d02e1-2b69-4035-820a-7ff1911fae60	2026-08-21 12:53	2026-08-21 12:53	2026-08-21 12:53	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.4000	32.4000	32.6000	155.8450	210600.00	0.00	9720.00	65	16	848	9034	0.0938676112464025	0.349233968735337	0.349233968735337	false	false	false	true
961820d8-d97b-4519-b746-731dcf276ce8	2026-08-21 12:31	2026-08-21 12:31	2026-08-21 12:31	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.4000	32.4000	32.7000	156.0800	168480.00	0.00	58320.00	52	16	767	9034	0.0849014832853664	0.346882841322872	0.346882841322872	false	false	false	true