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 = 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	price

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	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-21T16:17:50.496167Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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
a8606611-31ec-4a18-9fb0-ae2a3de865e0	2026-08-21 10:44	2026-08-21 10:43	2026-08-21 10:43	EMR	EMR270319C00175000	call	175.0000	2027-03-19	8.3000	6.7000	9.8000	156.0400	101260.00	1660.00	99600.00	122	18	122	100	1.22	0.29556251257878	0.29556251257878	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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
83d37e62-7980-457b-bde4-ca25cf489532	2026-08-20 13:57	2026-08-20 13:57	2026-08-20 13:57	EMR	EMR280121C00145000	call	145.0000	2028-01-21	32.9000	32.9000	33.9000	155.0100	75670.00	0.00	75670.00	23	5	297	29	10.2413793103448	0.327096603573184	0.327096603573184	false	false	false	true	false
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	false
5c1099fe-ab99-4e44-81e2-b1924ef6283c	2026-08-20 13:33	2026-08-20 13:33	2026-08-20 13:33	EMR	EMR280121C00145000	call	145.0000	2028-01-21	32.9000	32.9000	34.6000	154.9800	72380.00	0.00	72380.00	22	5	274	29	9.44827586206897	0.327421469075209	0.327421469075209	false	false	false	true	false
5e967c84-395e-42ac-a12d-a85b2ef742bf	2026-08-20 13:27	2026-08-20 13:27	2026-08-20 13:27	EMR	EMR280121C00145000	call	145.0000	2028-01-21	33.0000	33.0000	34.8000	155.1300	72600.00	0.00	72600.00	22	5	239	29	8.24137931034483	0.327347819121369	0.327347819121369	false	false	false	true	false
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	false
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	false
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	false
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	false
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
a0f0cd35-8a59-4781-bb3c-c06d1e2d60fc	2026-08-20 11:48	2026-08-20 11:48	2026-08-20 11:48	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.5000	31.5000	32.5000	155.7600	100800.00	0.00	12600.00	32	8	664	7534	0.0881337934696045	0.336228091499093	0.336228091499093	false	false	false	true	false
7fa0758b-e6e9-4e73-b1a9-56febfd5b100	2026-08-20 11:48	2026-08-20 11:48	2026-08-20 11:48	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.5000	31.5000	31.6000	155.7600	122850.00	0.00	122850.00	39	9	707	7534	0.0938412529864614	0.336228091499093	0.336228091499093	false	false	false	true	false
c2a2e54b-62ad-4cf8-89cd-f3ab1bc2a727	2026-08-20 11:29	2026-08-20 11:29	2026-08-20 11:29	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.0000	32.0000	32.5000	156.7875	240000.00	0.00	25600.00	75	18	632	7534	0.0838863817361295	0.333357551598693	0.333357551598693	false	false	false	true	false
cebabb26-46b0-4d7a-8701-e7541be8276b	2026-08-20 11:10	2026-08-20 11:10	2026-08-20 11:10	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.8000	31.3000	32.2000	156.5100	238500.00	12720.00	25440.00	75	18	538	7534	0.071409609769047	0.333885864370346	0.333174428057107	true	false	false	true	false
a3b31c22-a62e-43a1-9fc3-14cb016f8d0a	2026-08-20 11:08	2026-08-20 11:08	2026-08-20 11:08	EMR	EMR280121C00155000	call	155.0000	2028-01-21	28.9000	28.9000	30.4000	156.4950	63581.00	0.00	63581.00	22	5	79	18	4.38888888888889	0.326070266828557	0.326070266828557	false	false	false	true	false
93df5056-79b8-4a42-8202-b0edd8a3addb	2026-08-20 10:53	2026-08-20 10:53	2026-08-20 10:53	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.1000	31.0000	32.2000	156.0150	55981.00	0.00	52871.00	18	8	450	7534	0.059729227501991	0.327718502670919	0.327718502670919	false	false	false	true	false
ede62716-75c8-4ef0-ba82-a225b1e16db4	2026-08-20 10:51	2026-08-20 10:51	2026-08-20 10:51	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.4000	31.4000	32.0000	155.7100	235500.00	0.00	12560.00	75	19	432	7534	0.0573400584019113	0.335238817335109	0.335238817335109	false	false	false	true	false
b3d134ec-9d66-4816-b8a4-4a2ded29a76b	2026-08-20 10:49	2026-08-20 10:49	2026-08-20 10:49	EMR	EMR280121C00145000	call	145.0000	2028-01-21	33.5000	33.5000	35.1000	155.9000	127300.00	0.00	127300.00	38	13	77	29	2.6551724137931	0.326730071434182	0.326730071434182	false	false	false	true	false
37c744ab-5148-4cb7-8b61-01e38cd4d47b	2026-08-20 10:43	2026-08-20 10:42	2026-08-20 10:42	EMR	EMR280121C00145000	call	145.0000	2028-01-21	33.6000	33.6000	35.2000	155.9600	124321.00	0.00	124321.00	37	13	37	29	1.27586206896552	0.327628694766452	0.327628694766452	false	false	false	true	false
03e9f4f2-90bd-42fb-89ee-3fc207d6fad2	2026-08-20 10:42	2026-08-20 10:42	2026-08-20 10:42	EMR	EMR280121C00155000	call	155.0000	2028-01-21	28.7000	28.7000	30.4000	156.1124	114802.00	0.00	114802.00	40	12	40	18	2.22222222222222	0.326594299915333	0.326594299915333	false	false	false	true	false
f1a644d2-7eb6-45a4-9830-6d3ac476339d	2026-08-20 10:42	2026-08-20 10:42	2026-08-20 10:42	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.1100	30.5000	32.3000	155.9800	164861.00	9360.00	155501.00	53	20	356	7534	0.0472524555349084	0.327467756940295	0.329559155700133	true	false	false	true	false
6efc6b11-b1d7-46d3-b5e0-d429b05faa25	2026-08-20 10:42	2026-08-20 10:42	2026-08-20 10:42	EMR	EMR270115C00165000	call	165.0000	2027-01-15	8.6000	8.3000	9.0000	155.7800	129860.00	0.00	20640.00	151	18	1619	1824	0.887609649122807	0.287595288168169	0.287595288168169	false	false	false	true	false
9cc6bc09-8232-45d3-80ac-8bec4797d3c0	2026-08-20 10:42	2026-08-20 10:41	2026-08-20 10:41	EMR	EMR270115C00165000	call	165.0000	2027-01-15	8.6000	8.4000	8.6000	156.1089	292400.00	292400.00	0.00	340	19	1468	1824	0.804824561403509	0.283846019060658	0.283846019060658	false	false	false	true	false
7b6e0185-8d62-4d4a-a07c-4a9d0a9afba9	2026-08-20 10:41	2026-08-20 10:41	2026-08-20 10:41	EMR	EMR270115C00165000	call	165.0000	2027-01-15	8.6000	8.5000	8.6000	156.1089	149640.00	149640.00	0.00	174	13	1128	1824	0.618421052631579	0.283846019060658	0.283846019060658	false	false	false	true	false
9846c9b8-3178-4841-87b4-13280f363f69	2026-08-20 10:41	2026-08-20 10:41	2026-08-20 10:41	EMR	EMR270115C00165000	call	165.0000	2027-01-15	8.7000	8.4000	8.7000	155.8900	96570.00	96570.00	0.00	111	11	954	1824	0.523026315789474	0.288889828131894	0.288889828131894	false	false	false	true	false
7b6617b9-8780-41f5-923f-da2fed0dfc8b	2026-08-20 10:41	2026-08-20 10:41	2026-08-20 10:41	EMR	EMR270115C00165000	call	165.0000	2027-01-15	8.7000	8.4000	8.7000	155.8900	76560.00	76560.00	0.00	88	8	843	1824	0.462171052631579	0.288889828131894	0.288889828131894	false	false	false	true	false
aec15f83-eb41-4908-83a2-36a489e59c8f	2026-08-20 10:41	2026-08-20 10:41	2026-08-20 10:41	EMR	EMR270115C00165000	call	165.0000	2027-01-15	8.7000	8.3000	8.7000	155.8900	187920.00	31320.00	0.00	216	14	635	1824	0.348135964912281	0.288889828131894	0.288889828131894	false	false	false	true	false
35555cdb-b86a-499b-8c59-1c62ac2f5de0	2026-08-20 10:41	2026-08-20 10:41	2026-08-20 10:41	EMR	EMR270115C00165000	call	165.0000	2027-01-15	8.7000	8.4000	8.7000	155.8900	104400.00	104400.00	0.00	120	6	755	1824	0.413925438596491	0.288889828131894	0.288889828131894	false	false	false	true	false
17ea1614-0e0b-4d20-a07a-905a4657f1bd	2026-08-20 10:41	2026-08-20 10:41	2026-08-20 10:41	EMR	EMR270115C00165000	call	165.0000	2027-01-15	8.9000	8.1000	9.3000	156.1000	165530.00	71200.00	880.00	186	19	419	1824	0.229714912280702	0.29157113846345	0.289030823464123	false	false	false	true	false
bdf034b6-cea8-45ab-91e3-127009f48ffc	2026-08-20 10:41	2026-08-20 10:41	2026-08-20 10:41	EMR	EMR270115C00165000	call	165.0000	2027-01-15	9.2000	7.6000	9.2000	156.2800	205160.00	83720.00	0.00	223	16	233	1824	0.127741228070175	0.297105106451168	0.297105106451168	false	false	false	true	false
2d0c49ec-3ba9-42de-93b0-5b2d37eb7f6d	2026-08-20 10:32	2026-08-20 10:32	2026-08-20 10:32	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.4000	31.4000	31.9000	155.8900	222940.00	0.00	97340.00	71	17	299	7534	0.0396867533846562	0.333439234507696	0.333439234507696	false	false	false	true	false