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:option_symbol = EMR280121C00150000×

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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	82721740000.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
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	false
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	false
6c779e90-ff18-40c5-aeb9-dade8b80db11	2026-08-21 12:16	2026-08-21 12:16	2026-08-21 12:16	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.4000	32.4000	32.7000	156.1550	103680.00	0.00	12960.00	32	13	691	9034	0.0764888200132832	0.346131350197442	0.346131350197442	false	false	false	true	false
8df3a8e7-7ca4-42ad-9086-1905bdc56fa4	2026-08-21 12:12	2026-08-21 12:12	2026-08-21 12:12	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	31.1000	32.9000	156.1900	87210.00	19380.00	67830.00	27	9	659	9034	0.0729466460039849	0.344290722660474	0.344290722660474	false	false	false	true	false
4730cf48-18ba-4cb8-99cc-e102fb36e393	2026-08-21 11:49	2026-08-21 11:49	2026-08-21 11:49	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.5000	31.8000	33.1000	156.3100	243750.00	13000.00	13000.00	75	18	628	9034	0.0695151649324773	0.346066320014735	0.346066320014735	false	false	false	true
4271882c-3551-4092-9fa3-5d8dae73017b	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	31.5000	33.1000	156.1800	242250.00	12920.00	125970.00	75	18	553	9034	0.0612131945981846	0.34439100428592	0.34439100428592	false	false	false	true
6ba07002-f30b-4d06-8a44-1dc1464d0d97	2026-08-21 11:18	2026-08-21 11:18	2026-08-21 11:18	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.0000	32.0000	32.5000	155.9100	153600.00	0.00	6400.00	48	18	476	9034	0.0526898383883108	0.342626271408184	0.342626271408184	false	false	false	true	false
b550d99b-aefe-4bc1-9a24-7634aeb673df	2026-08-21 11:16	2026-08-21 11:16	2026-08-21 11:16	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.8000	31.2500	32.0000	155.9300	79500.00	79500.00	0.00	25	6	428	9034	0.0473765773743635	0.339446519540792	0.339446519540792	true	false	false	true	false
e07fc445-07c3-4b06-8135-8986c4487123	2026-08-21 10:54	2026-08-21 10:54	2026-08-21 10:54	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.6000	31.6000	32.0000	156.0900	176960.00	0.00	12640.00	56	14	382	9034	0.0422847022359973	0.33486276074603	0.33486276074603	false	false	false	true	false
47de3475-1d3c-4481-a9ef-390de4970037	2026-08-21 10:43	2026-08-21 10:43	2026-08-21 10:43	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.6000	31.3000	31.8000	155.9800	53720.00	6320.00	44240.00	17	16	324	9034	0.0358645118441443	0.335965570531636	0.335965570531636	false	false	false	true	false
4a7c800d-8d33-40a6-9081-891816d3b9e7	2026-08-21 10:40	2026-08-21 10:40	2026-08-21 10:40	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.4000	31.4000	31.7000	155.6950	122460.00	0.00	25120.00	39	9	289	9034	0.0319902590214744	0.335837127211735	0.335837127211735	false	false	false	true	false
d54b75ed-63ce-48f3-8617-6072a80ffa7e	2026-08-21 10:27	2026-08-21 10:27	2026-08-21 10:27	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.3000	31.3000	31.6000	155.7900	234750.00	0.00	234750.00	75	18	232	9034	0.025680761567412	0.33339706533879	0.33339706533879	false	false	false	true	false
5197d3c1-23bb-459e-a89f-19ae05c44931	2026-08-21 10:00	2026-08-21 10:00	2026-08-21 10:00	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.2000	29.4000	31.7000	155.7150	152870.00	9350.00	81120.00	49	19	151	9034	0.0167146336063759	0.332656935833179	0.332656935833179	false	false	false	true