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×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

a203d338-8f73-4eba-a1a4-1f7f06c6600d	2026-08-20 12:07	2026-08-20 12:07	2026-08-20 12:07	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.5000	30.4000	32.5000	155.7500	236250.00	12600.00	198450.00	75	18	782	7534	0.103796124236793	0.336328001315813	0.336328001315813	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-20T16:19:11.314726Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6e011461-aedb-40b9-98fd-13c7e676366e	2026-08-20 12:26	2026-08-20 12:26	2026-08-20 12:26	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.5000	30.3000	32.7000	155.6156	236250.00	12600.00	37800.00	75	18	918	7534	0.121847624104062	0.337669775861647	0.337669775861647	false	false	false	true
2f5fca6f-ae08-4f4e-b109-5c580a2fbbce	2026-08-20 12:45	2026-08-20 12:45	2026-08-20 12:45	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.2000	30.5000	31.9000	155.7750	234000.00	12480.00	49920.00	75	18	993	7534	0.131802495354393	0.331611291718146	0.331611291718146	false	false	false	true
50266c5b-94d9-4672-8b2a-62bce3cfc877	2026-08-20 13:04	2026-08-20 13:04	2026-08-20 13:04	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.1000	30.2000	31.2000	155.4700	183490.00	12440.00	171050.00	59	14	1068	7534	0.141757366604725	0.333167335410406	0.333167335410406	false	false	false	true
fd9906e6-4cc6-40f7-8ca0-84ffcb20c876	2026-08-20 13:23	2026-08-20 13:23	2026-08-20 13:23	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.0000	31.0000	31.8000	155.2000	232500.00	0.00	12400.00	75	19	1143	7534	0.151712237855057	0.334366596947447	0.334366596947447	false	false	false	true
d033a5cb-a4bd-48df-a978-216029872629	2026-08-20 13:42	2026-08-20 13:42	2026-08-20 13:42	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.4000	30.1000	32.6000	154.9650	235500.00	12560.00	37680.00	75	20	1218	7534	0.161667109105389	0.342651620431918	0.342651620431918	false	false	false	true
38731772-e456-4f7a-aea0-b870737aa14f	2026-08-20 14:01	2026-08-20 14:01	2026-08-20 14:01	EMR	EMR280121C00150000	call	150.0000	2028-01-21	30.6000	30.6000	31.2000	155.0350	229500.00	0.00	229500.00	75	18	1293	7534	0.171621980355721	0.330052263679497	0.330052263679497	true	false	false	true
05afb6c8-e0c5-4e29-a411-d7a1be3956e2	2026-08-20 14:20	2026-08-20 14:20	2026-08-20 14:20	EMR	EMR280121C00150000	call	150.0000	2028-01-21	30.4000	30.4000	31.0000	155.0500	228000.00	0.00	228000.00	75	18	1368	7534	0.181576851606053	0.326925946089211	0.326925946089211	false	false	false	true
a848cbcc-ed23-40ee-906a-aa668cc6cc63	2026-08-20 14:39	2026-08-20 14:38	2026-08-20 14:38	EMR	EMR280121C00150000	call	150.0000	2028-01-21	30.4000	30.4000	31.0000	154.8700	228000.00	0.00	228000.00	75	19	1443	7534	0.191531722856384	0.328861389392508	0.328712653802003	true	false	false	true
1606bb65-b441-4818-95f6-3d39fe2515ad	2026-08-20 15:00	2026-08-20 15:00	2026-08-20 15:00	EMR	EMR280121C00150000	call	150.0000	2028-01-21	30.0000	30.0000	30.9000	154.5100	222000.00	0.00	222000.00	74	18	1568	7534	0.208123174940271	0.326323272271814	0.326323272271814	true	false	false	true
0d353292-9542-4f91-9c28-28ea7efa4481	2026-08-20 15:19	2026-08-20 15:19	2026-08-20 15:19	EMR	EMR280121C00150000	call	150.0000	2028-01-21	30.4000	30.4000	30.8000	154.8300	209770.00	0.00	30410.00	69	18	1637	7534	0.217281656490576	0.329109229046367	0.330597588636069	true	false	false	true
6c294a94-a096-4d85-a557-fb41e9a2fe17	2026-08-20 15:36	2026-08-20 15:35	2026-08-20 15:35	EMR	EMR280121C00150000	call	150.0000	2028-01-21	30.0000	29.1000	30.8000	154.4200	225000.00	12000.00	96000.00	75	18	1719	7534	0.228165649057606	0.327804778943078	0.327212459293021	true	false	false	true
8bc9e524-d6be-470a-bf4c-f5019087d677	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.8000	31.8000	32.9000	155.1800	238500.00	0.00	25440.00	75	19	75	9034	0.00830197033429267	0.346926344810027	0.346926344810027	false	false	false	true
5ab1e874-d976-46c9-bb57-8defea66fbaf	2026-08-21 09:55	2026-08-21 09:55	2026-08-21 09:55	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.1000	31.1000	31.7000	155.6900	83970.00	0.00	83970.00	27	6	102	9034	0.011290679654638	0.331416576824387	0.331416576824387	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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