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

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

345acff4-9f77-444f-ac7f-5d1066919ee6	2026-08-24 14:05	2026-08-24 14:05	2026-08-24 14:05	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.5000	20.0000	20.9000	215.6800	53300.00	10250.00	22550.00	26	5	2096	7352	0.285092491838955	0.510310587606194	0.510310587606194	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	98784205830.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
71163069-20ef-4c41-9b38-c13f3ed45b6f	2026-08-24 14:05	2026-08-24 14:05	2026-08-24 14:05	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.6000	20.2000	20.9000	215.7750	51500.00	22660.00	10300.00	25	7	2025	7352	0.275435255712731	0.511481397491267	0.511481397491267	false	false	false	true
8e185628-1876-40a3-9b02-95e66578338b	2026-08-24 14:05	2026-08-24 14:05	2026-08-24 14:05	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.5000	20.1000	20.9000	215.7750	55350.00	12300.00	10250.00	27	5	2000	7352	0.272034820457018	0.509106903493951	0.509106903493951	false	false	false	true
a2d7cbfa-cb47-4d2f-82d8-5784e811e67a	2026-08-24 14:05	2026-08-24 14:05	2026-08-24 14:05	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.5400	20.5000	21.1000	215.7750	73930.00	0.00	53330.00	36	6	1973	7352	0.268362350380849	0.509106903493951	0.511481397491267	false	false	false	true
e3e8eddf-e3a7-45dd-b81b-f08fa0220b02	2026-08-24 14:05	2026-08-24 14:05	2026-08-24 14:05	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.5000	20.5000	20.8000	215.7750	53300.00	0.00	20500.00	26	5	1937	7352	0.263465723612622	0.509106903493951	0.509106903493951	false	false	false	true
67dd3fa1-494d-4c3c-a1b6-298b1ef5072f	2026-08-24 14:04	2026-08-24 14:04	2026-08-24 14:04	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.5000	20.3000	21.0000	215.8000	59450.00	12300.00	12300.00	29	5	1849	7352	0.251496191512514	0.50879000543353	0.50879000543353	false	false	false	true
f1985cd0-78e1-44ba-971d-5e4f2e3c9bfd	2026-08-24 14:04	2026-08-24 14:04	2026-08-24 14:04	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.5000	20.0000	20.9000	215.7700	57400.00	12300.00	12300.00	28	5	1801	7352	0.244967355821545	0.509170276129574	0.509170276129574	false	false	false	true
5b586b2f-4176-4edc-b01d-ea05e06a4408	2026-08-24 14:04	2026-08-24 14:03	2026-08-24 14:03	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.6000	19.9000	20.9000	215.6600	57680.00	14420.00	10300.00	28	7	1714	7352	0.233133841131665	0.512939318119888	0.512939318119888	false	false	false	true
91fbbe73-39fc-441a-b720-5d960f1aec74	2026-08-24 14:03	2026-08-24 14:03	2026-08-24 14:03	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.6000	19.8000	20.8000	215.7450	55620.00	12360.00	20600.00	27	5	1605	7352	0.218307943416757	0.511861841601179	0.511861841601179	false	false	false	true
9fa1641e-f679-4f59-87d3-6ae387db7a87	2026-08-24 14:03	2026-08-24 14:03	2026-08-24 14:03	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.5200	20.5000	20.8000	215.7302	385782.00	24762.00	326000.00	188	34	1578	7352	0.214635473340588	0.513711989594686	0.50967463958613	false	false	false	true
8fc65139-8b5a-4c20-b72d-8032dd2d8f42	2026-08-24 14:02	2026-08-24 14:02	2026-08-24 14:02	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.5000	20.0000	20.9000	215.8300	51250.00	10250.00	10250.00	25	5	1283	7352	0.174510337323177	0.508409650855873	0.508409650855873	false	false	false	true
8736503f-fe08-4f63-984f-a4005568946b	2026-08-24 14:00	2026-08-24 14:00	2026-08-24 14:00	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.6600	20.6000	21.1000	216.0550	57840.00	0.00	57840.00	28	5	1138	7352	0.154787812840044	0.51267153749157	0.507926547128133	false	false	false	true
56bae08b-8a3a-41b6-a725-358d6eb30dba	2026-08-24 14:00	2026-08-24 14:00	2026-08-24 14:00	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.7000	20.4000	21.2000	216.0550	51750.00	20700.00	10350.00	25	5	1110	7352	0.150979325353645	0.510298962456711	0.510298962456711	false	false	false	true
c3af0872-a9fd-4d3e-bfae-67dc5af1e792	2026-08-24 13:09	2026-08-24 13:09	2026-08-24 13:09	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.0000	20.4000	21.0000	216.3100	77700.00	77700.00	0.00	37	5	1079	7352	0.146762785636561	0.514165312187992	0.514165312187992	false	false	false	true
ac9270ca-a2a9-4b8e-b0c1-5daf699c76d0	2026-08-24 10:00	2026-08-24 10:00	2026-08-24 10:00	AEM	AEM261120C00220000	call	220.0000	2026-11-20	22.1000	21.7000	22.3000	218.3300	72930.00	72930.00	0.00	33	5	969	7352	0.131800870511425	0.514112406207532	0.514112406207532	false	false	false	true
1b5092db-ce1b-4ce6-868a-5ba18bfe8a87	2026-08-24 10:00	2026-08-24 10:00	2026-08-24 10:00	AEM	AEM261120C00220000	call	220.0000	2026-11-20	22.0000	21.7000	22.3000	218.3900	145200.00	59400.00	57200.00	66	5	936	7352	0.127312295973885	0.510971030071849	0.510971030071849	false	false	false	true
9aa27a1f-a0f4-4afe-acc1-ef885c093da6	2026-08-24 09:59	2026-08-24 09:59	2026-08-24 09:59	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.9000	21.5000	22.2000	218.3500	289080.00	59130.00	61320.00	132	10	869	7352	0.118199129488575	0.509134092553443	0.509134092553443	false	false	false	true
8055d43e-aa7b-497e-a3f2-d5b985ba705b	2026-08-24 09:59	2026-08-24 09:59	2026-08-24 09:59	AEM	AEM261120C00220000	call	220.0000	2026-11-20	22.0000	22.0000	22.2000	218.3847	319000.00	0.00	63800.00	145	8	552	7352	0.0750816104461371	0.511040163317809	0.511040163317809	false	false	false	true
af72424e-ba01-47d7-ac66-6a7238773c0a	2026-08-24 09:58	2026-08-24 09:58	2026-08-24 09:58	AEM	AEM261120C00220000	call	220.0000	2026-11-20	22.1000	21.3000	22.5000	218.1900	530400.00	530400.00	0.00	240	5	407	7352	0.0553590859630033	0.515937494067391	0.515937494067391	false	false	false	true
7a39abcb-789e-461b-a6c6-576f3c4f0390	2026-08-24 09:58	2026-08-24 09:58	2026-08-24 09:58	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.9000	21.0000	22.5000	218.0900	365730.00	116070.00	113880.00	167	6	167	7352	0.022714907508161	0.512519244193424	0.512519244193424	false	false	false	true
60d9574f-e79e-4c4d-b83e-f9ee8337592d	2026-08-24 09:55	2026-08-24 09:55	2026-08-24 09:55	AEM	AEM270617C00250000	call	250.0000	2027-06-17	29.0000	29.0000	30.7000	218.1500	290000.00	0.00	246500.00	100	8	200	1736	0.115207373271889	0.484610574346606	0.484610574346606	false	false	false	true
e0c20e93-a187-4263-9134-d383cc19e4b7	2026-08-24 09:31	2026-08-24 09:31	2026-08-24 09:31	AEM	AEM280121C00270000	call	270.0000	2028-01-21	37.5000	36.5000	39.0000	219.2800	150000.00	131250.00	18750.00	40	7	40	1444	0.0277008310249307	0.481383896113835	0.481383896113835	false	false	false	true
07e57e19-2b46-4840-9a81-fa4c662e12fe	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	AEM	AEM260918C00220000	call	220.0000	2026-09-18	10.9000	9.8000	11.2000	217.9841	106820.00	57770.00	0.00	98	63	128	919	0.139281828073993	0.508715407029133	0.508715407029133	false	false	false	true
175b0c34-506c-486f-909b-e7ade16abc59	2026-08-21 14:46	2026-08-21 14:46	2026-08-21 14:46	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.0000	20.8000	21.4000	216.1000	239400.00	12600.00	37800.00	114	19	553	7819	0.0707251566696508	0.507545138973707	0.507545138973707	false	false	false	true
aa8d36f6-ba4d-4ab5-a4d5-4b62cc24b5c6	2026-08-21 14:46	2026-08-21 14:46	2026-08-21 14:46	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.1000	20.9000	21.4000	216.0000	386130.00	59080.00	236320.00	183	46	439	7819	0.0561452871211152	0.509627590895576	0.511133312131068	false	false	false	true
bd1b64fb-3247-42dd-b398-b7f78d46ccb6	2026-08-21 14:45	2026-08-21 14:45	2026-08-21 14:45	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.2000	20.8000	21.5000	216.1050	212000.00	53000.00	97520.00	100	23	253	7819	0.0323570789103466	0.512149497444733	0.512149497444733	false	false	false	true
3e1aee08-f189-4f7d-9da3-1bd10cc55bcd	2026-08-21 13:18	2026-08-21 13:18	2026-08-21 13:18	AEM	AEM261120C00220000	call	220.0000	2026-11-20	22.0000	21.6000	22.0000	217.3100	118800.00	118800.00	0.00	54	11	104	7819	0.0133009336232255	0.515552748105523	0.515552748105523	false	false	false	true
6d03420f-af84-4b8f-8b46-8ab030191bcf	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	AEM	AEM260918C00210000	call	210.0000	2026-09-18	15.0000	15.0000	15.7000	216.7400	69000.00	0.00	69000.00	46	10	517	1146	0.451134380453752	0.464775792875706	0.464775792875706	false	false	false	true
facedde1-dd18-499a-b66c-2fca734577d2	2026-08-21 10:23	2026-08-21 10:23	2026-08-21 10:23	AEM	AEM261218C00240000	call	240.0000	2026-12-18	18.2000	16.9000	18.2000	217.3400	182000.00	182000.00	0.00	100	5	140	450	0.311111111111111	0.521861486263685	0.521861486263685	false	false	false	true
262dcb0d-cf20-4abc-8a7d-a882151d088e	2026-08-21 09:32	2026-08-21 09:32	2026-08-21 09:32	AEM	AEM260828C00220000	call	220.0000	2026-08-28	5.0000	5.0000	5.5000	216.5550	83000.00	0.00	83000.00	166	6	226	319	0.70846394984326	0.540245179359196	0.540245179359196	false	false	false	true
386121ec-1c3c-4725-9333-16cb8d2873d4	2026-08-20 15:42	2026-08-20 15:41	2026-08-20 15:41	AEM	AEM261016C00210000	call	210.0000	2026-10-16	16.4000	16.1000	16.7000	209.3400	52480.00	1640.00	50840.00	32	5	138	343	0.402332361516035	0.489444816692873	0.489444816692873	false	false	false	true
ccc4467f-0d85-43bd-ab23-40700c8a0052	2026-08-20 12:17	2026-08-20 12:17	2026-08-20 12:17	AEM	AEM261218P00240000	put	240.0000	2026-12-18	40.6000	39.3000	40.6000	212.4400	259840.00	259840.00	0.00	64	12	66	0	0	0.5191653082292	0.5191653082292	false	false	false	true	false
a05567b2-c385-4ad7-a180-52e2cf3affe9	2026-08-20 11:16	2026-08-20 11:16	2026-08-20 11:16	AEM	AEM261120C00220000	call	220.0000	2026-11-20	18.6000	18.2000	19.1000	212.1700	93000.00	18600.00	37200.00	50	5	458	8304	0.0551541425818882	0.496464167522646	0.496464167522646	false	false	false	true
93358b42-58da-4148-b5ab-88f638ae4004	2026-08-20 11:16	2026-08-20 11:15	2026-08-20 11:15	AEM	AEM261120C00220000	call	220.0000	2026-11-20	18.8000	18.0000	19.7000	212.0200	114680.00	92120.00	22560.00	61	5	271	8304	0.0326348747591522	0.502965021977422	0.502965021977422	false	false	false	true
5c8b76cf-16c3-4870-8f70-4ef4da69b8cf	2026-08-20 11:15	2026-08-20 11:15	2026-08-20 11:15	AEM	AEM261120C00220000	call	220.0000	2026-11-20	18.6000	17.9000	19.1000	212.0400	98580.00	20460.00	20460.00	53	5	194	8304	0.0233622350674374	0.498015940787576	0.498015940787576	false	false	false	true
00872cd7-d5eb-4cc3-9e0c-a1c9682ee28a	2026-08-20 11:15	2026-08-20 11:15	2026-08-20 11:15	AEM	AEM261120C00220000	call	220.0000	2026-11-20	18.9000	18.5000	19.2000	212.3750	139860.00	28350.00	28350.00	74	5	141	8304	0.0169797687861272	0.501069280046721	0.501069280046721	false	false	false	true
e92bf4cb-9ce3-408f-a33c-c20ec47ba175	2026-08-20 11:14	2026-08-20 11:14	2026-08-20 11:14	AEM	AEM261120C00220000	call	220.0000	2026-11-20	18.9000	18.9000	18.9000	212.3400	113400.00	0.00	0.00	60	8	67	8304	0.00806840077071291	0.50148879437686	0.50148879437686	true	false	false	true	false
a82dff39-fc9f-4a79-8663-8a26344fd094	2026-08-20 11:14	2026-08-20 11:14	2026-08-20 11:14	AEM	AEM261016C00250000	call	250.0000	2026-10-16	6.2000	5.2000	6.2000	212.2500	163673.00	163673.00	0.00	264	36	658	355	1.85352112676056	0.527964613087785	0.527964613087785	false	false	false	true
70af4cb7-c43c-49db-a22b-2225c44e4a9c	2026-08-20 10:13	2026-08-20 10:13	2026-08-20 10:13	AEM	AEM261016C00250000	call	250.0000	2026-10-16	4.9900	4.4000	5.0000	208.2300	186008.00	161998.00	24010.00	373	39	374	355	1.05352112676056	0.518923083388967	0.514845272487884	false	false	false	true
b6e65da9-2f84-4bad-8b0a-6f27212c38c3	2026-08-20 09:33	2026-08-20 09:33	2026-08-20 09:33	AEM	AEM270115C00220000	call	220.0000	2027-01-15	21.0000	20.0000	21.0000	208.0000	159600.00	159600.00	0.00	76	59	162	1085	0.149308755760369	0.465900572968788	0.465900572968788	false	false	false	true
6d847380-2bbb-4371-a9fe-4db1ef5a5a26	2026-08-20 09:33	2026-08-20 09:33	2026-08-20 09:33	AEM	AEM270115C00220000	call	220.0000	2027-01-15	21.0000	20.0000	21.0000	207.8600	117600.00	117600.00	0.00	56	19	74	1085	0.0682027649769585	0.467239001430109	0.467239001430109	false	false	false	true
3df17ec0-6085-4a5c-8377-1cbf49570da8	2026-08-20 09:32	2026-08-20 09:32	2026-08-20 09:32	AEM	AEM261218C00220000	call	220.0000	2026-12-18	18.0000	17.5000	18.0000	207.3000	91800.00	91800.00	0.00	51	9	172	699	0.246065808297568	0.467174825367823	0.467174825367823	false	false	false	true
0ea38815-6fe8-4252-8fde-6b9d724c385b	2026-08-20 09:30	2026-08-20 09:30	2026-08-20 09:30	AEM	AEM261218C00220000	call	220.0000	2026-12-18	17.0100	16.4000	17.5000	204.9195	62920.00	8520.00	40800.00	37	29	86	699	0.123032904148784	0.469989135452109	0.472129433412452	true	false	false	true
fda9a3cf-bb85-49f1-944d-0ad8c430cfc5	2026-08-19 15:31	2026-08-19 15:31	2026-08-19 15:31	AEM	AEM261218C00240000	call	240.0000	2026-12-18	13.3300	12.7000	13.5000	207.8650	93303.00	93303.00	0.00	70	6	165	661	0.249621785173979	0.500056234789989	0.495437541917013	false	false	false	true
926d369b-b6b6-408f-b6bd-bdc6d92cf50b	2026-08-19 14:31	2026-08-19 14:31	2026-08-19 14:31	AEM	AEM260918P00200000	put	200.0000	2026-09-18	8.5000	8.5000	8.7000	203.9700	86700.00	0.00	86700.00	102	16	167	317	0.526813880126183	0.461549273794125	0.461549273794125	false	false	false	true	false
afe194e5-6bea-4215-95b0-108ca0b77378	2026-08-19 11:07	2026-08-19 11:07	2026-08-19 11:07	AEM	AEM261120C00220000	call	220.0000	2026-11-20	15.0000	14.8000	15.5000	204.4850	58500.00	46500.00	12000.00	39	5	838	9302	0.090088153085358	0.495396238351384	0.495396238351384	false	false	false	true
cd0d7407-8f8b-4be4-97fd-05edb1e38cdc	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	AEM	AEM261120C00220000	call	220.0000	2026-11-20	15.0000	14.8000	15.3000	204.9150	91500.00	18000.00	19500.00	61	5	764	9302	0.0821328746506128	0.490664209516031	0.490664209516031	false	false	false	true
f10d3ee1-4daa-470a-b802-be59ecb5fc9e	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	AEM	AEM261120C00220000	call	220.0000	2026-11-20	15.0000	14.8000	15.4000	204.9150	52500.00	31500.00	10500.00	35	5	703	9302	0.0755751451300796	0.490664209516031	0.490664209516031	false	false	false	true
f349daa8-512c-4cf7-9a4d-4674322601db	2026-08-19 10:58	2026-08-19 10:57	2026-08-19 10:57	AEM	AEM261120C00220000	call	220.0000	2026-11-20	15.0000	14.9000	15.3000	204.9600	84000.00	49500.00	18000.00	56	5	570	9302	0.0612771447000645	0.490168567319103	0.490168567319103	false	false	false	true
a9a17f68-a1d6-42fc-b6f8-cc4d2dd2dbb2	2026-08-19 10:57	2026-08-19 10:57	2026-08-19 10:57	AEM	AEM261120C00220000	call	220.0000	2026-11-20	15.0000	15.0000	15.5000	205.0400	55500.00	0.00	15000.00	37	7	514	9302	0.0552569339926897	0.489287219808351	0.489287219808351	false	false	false	true