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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 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×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	price

8303d444-662b-4eae-811b-81d7df1b6594	2026-08-17 09:34	2026-08-17 09:33	2026-08-17 09:33	EMR	EMR280121C00150000	call	150.0000	2028-01-21	34.5900	32.1000	35.4000	163.0100	328580.00	3450.00	65630.00	95	25	99	3034	0.0326301911667765	0.306346862372083	0.307861664819387	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Industrials	82721740000.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
32138d2f-8178-441c-a4d1-e1470c3b0053	2026-08-17 09:34	2026-08-17 09:34	2026-08-17 09:34	EMR	EMR280121C00150000	call	150.0000	2028-01-21	34.7900	34.7000	35.2000	163.4050	97420.00	0.00	97420.00	28	14	154	3034	0.0507580751483191	0.305079115040533	0.303560509854243	false	false	false	true
8c2dfc8c-a648-4f27-95b2-25e56146820c	2026-08-17 09:34	2026-08-17 09:34	2026-08-17 09:34	EMR	EMR280121C00150000	call	150.0000	2028-01-21	34.6000	34.6000	35.2000	163.2100	211060.00	0.00	211060.00	61	18	215	3034	0.0708635464733026	0.304170805745711	0.304170805745711	false	false	false	true
b7b63e80-246e-49f6-a2dd-0b1286be5fca	2026-08-17 09:34	2026-08-17 09:34	2026-08-17 09:34	EMR	EMR280121C00150000	call	150.0000	2028-01-21	34.6000	34.6000	35.1000	163.2100	211060.00	0.00	190300.00	61	17	276	3034	0.0909690177982861	0.304170805745711	0.304170805745711	false	false	false	true
090ab721-7a6f-4855-b2d2-f6ba34efc574	2026-08-17 09:34	2026-08-17 09:34	2026-08-17 09:34	EMR	EMR280121C00150000	call	150.0000	2028-01-21	34.5000	34.5000	35.0000	163.2100	241530.00	0.00	241530.00	70	18	346	3034	0.114040870138431	0.304170805745711	0.30265271083757	false	false	false	true
945bb9de-3df2-4656-b127-e7a8db0a01f1	2026-08-17 09:34	2026-08-17 09:34	2026-08-17 09:34	EMR	EMR280121C00150000	call	150.0000	2028-01-21	34.7000	34.7000	35.0000	163.2100	156150.00	0.00	20820.00	45	11	391	3034	0.128872775214239	0.305687963796481	0.305687963796481	false	false	false	true
97a74bcd-6f3d-4515-a296-4af3af138b5a	2026-08-17 09:34	2026-08-17 09:34	2026-08-17 09:34	EMR	EMR280121C00150000	call	150.0000	2028-01-21	34.8000	34.8000	34.9000	163.2100	107880.00	0.00	3480.00	31	18	422	3034	0.139090309822017	0.307204204951541	0.307204204951541	false	false	false	true
ba5cbe37-2556-4427-9fca-68786aa8ad3f	2026-08-17 09:34	2026-08-17 09:34	2026-08-17 09:34	EMR	EMR280121C00150000	call	150.0000	2028-01-21	34.7200	33.1000	34.8000	163.2100	277791.00	277791.00	0.00	80	9	502	3034	0.165458141067897	0.302045205999541	0.302045205999541	true	false	false	true
eddf844b-135c-4cdd-beaa-bf717a64f972	2026-08-17 11:03	2026-08-17 11:03	2026-08-17 11:03	EMR	EMR280121C00150000	call	150.0000	2028-01-21	33.5000	33.5000	36.9000	162.2000	365150.00	0.00	365150.00	109	22	637	3034	0.20995385629532	0.298457073453209	0.298457073453209	true	false	false	true
aa922560-8663-49f1-8afd-624fed5127cf	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.1000	32.1000	34.5000	159.1636	173340.00	0.00	154080.00	54	14	54	4534	0.011910013233348	0.312588564914091	0.309645297179628	false	false	false	true
cabfedb1-c9b5-4148-9731-9ab903db2f02	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.6200	31.4000	32.8000	159.0400	133740.00	13080.00	22860.00	41	13	245	4534	0.0540361711513013	0.319909709835072	0.318414129177897	false	false	false	true
bae79d37-129f-487a-a96d-5e7bc77dba6a	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.7400	32.7000	33.6000	158.9100	451860.00	0.00	212580.00	138	37	204	4534	0.0449933833259815	0.322747584887683	0.321253145053017	false	false	false	true
41f2c25e-3936-4349-938e-e56bdb9dce12	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	32.3000	33.8000	159.0400	184110.00	0.00	184110.00	57	15	370	4534	0.0816056462284958	0.313924788813954	0.313924788813954	false	false	false	true
00a7a968-78c3-43d8-9402-92cdc1894001	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.4000	32.4000	33.8000	159.0400	145800.00	0.00	145800.00	45	18	313	4534	0.0690339655932951	0.315421679890314	0.315421679890314	true	false	false	true
ef872dd5-cdfc-44d4-9d4e-3d020191873e	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.5000	32.5000	33.7000	158.9875	87750.00	0.00	19500.00	27	16	398	4534	0.0877812086457874	0.317461577390036	0.317461577390036	false	false	false	true
709cd10f-7f65-4ea1-908c-08f6090261f9	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	32.3000	34.1000	158.3100	190570.00	0.00	190570.00	59	15	59	6034	0.00977792509115015	0.32189376873978	0.32189376873978	false	false	false	true
b8840cc9-02df-443e-a218-9cb8ad7f529f	2026-08-19 09:54	2026-08-19 09:54	2026-08-19 09:54	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.2000	32.2000	33.8000	158.5300	189980.00	0.00	189980.00	59	14	134	6034	0.0222074908849851	0.318136087453309	0.318136087453309	false	false	false	true
9471c4b8-2f85-4d34-98b3-a67c7f9494ff	2026-08-19 09:54	2026-08-19 09:54	2026-08-19 09:54	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.1000	32.1000	33.7000	158.5900	51360.00	0.00	51360.00	16	16	150	6034	0.0248591315876699	0.31602138307952	0.31602138307952	true	false	false	true
f6973703-c980-424b-a256-b6278c480006	2026-08-19 10:13	2026-08-19 10:13	2026-08-19 10:13	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.1000	30.5000	33.7000	157.7200	256800.00	38520.00	12840.00	80	21	230	6034	0.0381173351010938	0.32494437861676	0.32494437861676	true	false	false	true
37ce3b80-c32c-430b-8de3-9723167655ca	2026-08-19 10:34	2026-08-19 10:34	2026-08-19 10:34	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.6000	31.8000	33.2000	158.9800	244500.00	13040.00	231460.00	75	18	305	6034	0.0505469008949287	0.319474297305804	0.319474297305804	false	false	false	true
5635fcb8-e9af-49e4-ab0b-d553a89dc9cf	2026-08-19 10:50	2026-08-19 10:49	2026-08-19 10:49	EMR	EMR270617P00140000	put	140.0000	2027-06-17	8.9000	7.7000	11.0000	158.9450	53379.00	48929.00	4450.00	60	13	60	46	1.30434782608696	0.344666682893719	0.344666682893719	false	false	false	true
156243bd-0a9e-41e4-ac3e-fce4dfb412c1	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	32.3000	33.7000	158.8500	180880.00	0.00	180880.00	56	18	380	6034	0.0629764666887637	0.316328689428221	0.316328689428221	true	false	false	true
22e908c1-27de-4560-8138-a21b10f7aa56	2026-08-19 11:10	2026-08-19 11:10	2026-08-19 11:10	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.4000	32.4000	33.7000	158.8750	236520.00	0.00	236520.00	73	18	453	6034	0.075074577394763	0.317567062336436	0.317567062336436	false	false	false	true
b03567ac-9cb7-4937-bd75-980cc4e198b7	2026-08-19 11:29	2026-08-19 11:29	2026-08-19 11:29	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.6000	32.6000	33.6000	158.5650	244500.00	0.00	39120.00	75	18	530	6034	0.0878355982764335	0.323755825128186	0.323755825128186	false	false	false	true
afab0c9c-f046-4609-b4ad-5b9250a5d87c	2026-08-19 11:48	2026-08-19 11:48	2026-08-19 11:48	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.1000	32.1000	33.6000	157.9200	189390.00	0.00	189390.00	59	14	589	6034	0.0976135233675837	0.322902322770532	0.322902322770532	false	false	false	true
2eb030f2-2644-4f6a-9b3b-9edb9ff992c1	2026-08-19 11:50	2026-08-19 11:50	2026-08-19 11:50	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.6000	31.2000	33.6000	157.9000	52160.00	3260.00	3260.00	16	16	605	6034	0.100265164070268	0.330567493483441	0.330567493483441	false	false	false	true
bf01cf33-442f-4fa3-8324-c1106f0b9e34	2026-08-19 12:14	2026-08-19 12:14	2026-08-19 12:14	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.5000	32.5000	32.9000	157.9350	230750.00	0.00	9750.00	71	19	680	6034	0.112694729864103	0.328718708441489	0.328718708441489	false	false	false	true
703edbb5-e500-4fed-bfd5-137f41cd1819	2026-08-19 12:28	2026-08-19 12:28	2026-08-19 12:28	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.2000	32.2000	33.1000	158.0400	189980.00	0.00	189980.00	59	14	739	6034	0.122472654955254	0.323167898311393	0.323167898311393	false	false	false	true
4a408e5f-a1b3-4f0f-9de5-b910e952f273	2026-08-19 12:30	2026-08-19 12:30	2026-08-19 12:30	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.6000	32.6000	33.1000	157.8900	52160.00	0.00	13040.00	16	16	755	6034	0.125124295657938	0.330669487475048	0.330669487475048	false	false	false	true
8d1015d0-84a2-44ba-bb00-468e0bfa023e	2026-08-19 12:45	2026-08-19 12:45	2026-08-19 12:45	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.0000	32.0000	33.0000	158.0500	214400.00	0.00	176000.00	67	16	822	6034	0.136228041100431	0.320078360118501	0.320078360118501	false	false	false	true
1f1c24dc-67d0-49df-ae2c-98d428984ff3	2026-08-19 12:46	2026-08-19 12:46	2026-08-19 12:46	EMR	EMR261218C00175000	call	175.0000	2026-12-18	5.3000	5.3000	5.8000	158.1350	55660.00	540.00	55120.00	105	27	105	262	0.400763358778626	0.292772753094381	0.292772753094381	false	false	false	true
d064aa93-0942-4119-a403-ebcbdd7fcac3	2026-08-19 13:10	2026-08-19 13:10	2026-08-19 13:10	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.8000	31.6000	33.6000	158.0451	213200.00	9840.00	29520.00	65	19	905	6034	0.149983427245608	0.33206959546454	0.33206959546454	false	false	false	true
d8ffe3fa-a3c0-4ac2-adb1-5905689b1aa2	2026-08-19 13:27	2026-08-19 13:27	2026-08-19 13:27	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.1000	32.1000	33.0000	158.0500	134820.00	0.00	134820.00	42	18	981	6034	0.162578720583361	0.321572117537104	0.321572117537104	true	false	false	true
d41360eb-e1b8-4209-961e-058833cbce00	2026-08-19 13:44	2026-08-19 13:44	2026-08-19 13:44	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.2000	32.2000	33.0000	158.1600	231840.00	0.00	193200.00	72	18	1053	6034	0.174511103745442	0.321938703881871	0.321938703881871	true	false	false	true
2c5fff92-cd2d-4367-8e03-63518d91a793	2026-08-19 14:01	2026-08-19 14:01	2026-08-19 14:01	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.2000	32.2000	32.9000	158.1000	241500.00	0.00	12880.00	75	18	1131	6034	0.187437852171031	0.322553545988538	0.322553545988538	false	false	false	true
5b9c2386-e2ea-4b61-8647-4d5954bae745	2026-08-19 14:20	2026-08-19 14:20	2026-08-19 14:20	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.8000	31.8000	32.8000	157.9400	187620.00	0.00	187620.00	59	14	1190	6034	0.197215777262181	0.318217111558046	0.318217111558046	false	false	false	true
29badb51-8e63-4eac-a4f2-9ecca7854058	2026-08-19 14:41	2026-08-19 14:41	2026-08-19 14:41	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	31.5000	32.8000	157.8300	242250.00	12920.00	12920.00	75	18	1281	6034	0.212296983758701	0.326806473579425	0.326806473579425	false	false	false	true
68a756b3-411b-4062-bde1-627881752633	2026-08-19 14:58	2026-08-19 14:57	2026-08-19 14:57	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.1000	31.7000	32.5000	157.5500	240750.00	0.00	176550.00	75	18	1358	6034	0.225058004640371	0.326676022293316	0.326676022293316	false	false	false	true
43403fee-59a9-46f3-8a8c-24d157ebc688	2026-08-19 15:17	2026-08-19 15:16	2026-08-19 15:16	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.0000	31.5000	32.4000	157.2450	240000.00	12800.00	51200.00	75	18	1433	6034	0.237487570434206	0.328283214508423	0.328283214508423	false	false	false	true
f86fe5ae-ea61-4315-ba80-8f0c6eb6a9ff	2026-08-19 15:36	2026-08-19 15:35	2026-08-19 15:35	EMR	EMR280121C00150000	call	150.0000	2028-01-21	32.3000	32.3000	32.8000	157.7000	242250.00	0.00	25840.00	75	19	1508	6034	0.249917136228041	0.328131792135561	0.328131792135561	false	false	false	true
6487f02e-bf5d-483b-9f28-ee724109b1c7	2026-08-20 09:35	2026-08-20 09:35	2026-08-20 09:35	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.8000	31.8000	33.0000	156.1000	114480.00	0.00	12720.00	36	9	36	7534	0.00477833820015928	0.337292471039738	0.337292471039738	false	false	false	true
eca37e54-a445-4f7e-ba64-d3403d4e6b3e	2026-08-20 09:35	2026-08-20 09:35	2026-08-20 09:35	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.6000	30.7000	32.8000	156.4550	123240.00	0.00	123240.00	39	19	77	7534	0.010220334483674	0.330747948862269	0.330747948862269	false	false	false	true
bc24f43c-705b-45fd-93ad-7f0dbf7de372	2026-08-20 09:54	2026-08-20 09:54	2026-08-20 09:54	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.7000	30.5000	32.8000	155.6950	237750.00	12680.00	25360.00	75	18	152	7534	0.0201752057340058	0.33985435599585	0.33985435599585	false	false	false	true
8f624d3a-27b4-43aa-a601-8c8461644b92	2026-08-20 10:13	2026-08-20 10:13	2026-08-20 10:13	EMR	EMR280121C00150000	call	150.0000	2028-01-21	31.2000	31.2000	31.7000	155.5900	221520.00	0.00	12480.00	71	18	223	7534	0.0295991505176533	0.33345926024247	0.33345926024247	false	false	false	true
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
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
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
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
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
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