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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Basic Materials×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

4dfb9dc5-cf7a-4c5d-ab52-9ac19dcb6c6d	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.9000	20.8000	21.9000	218.7700	54750.00	54750.00	0.00	25	6	335	5435	0.0616375344986201	0.50684326238444	0.50684326238444	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-25T14:42:01.576369Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
697dfcd1-e116-4c92-b700-7b3303818b13	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.8000	21.5000	21.8000	218.9450	67580.00	13080.00	0.00	31	5	297	5435	0.0546458141674333	0.502171741463233	0.502171741463233	false	false	false	true
b80077ea-6b1e-48e5-9d91-73eedccd39ac	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.8000	21.4000	22.2000	218.9500	58860.00	13080.00	23980.00	27	5	266	5435	0.0489420423183073	0.502105912491689	0.502105912491689	false	false	false	true
475a1980-2ab2-44c0-9efd-c12066eef116	2026-08-25 10:30	2026-08-25 10:29	2026-08-25 10:29	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.8000	21.8000	22.4000	218.9500	56680.00	0.00	21800.00	26	5	239	5435	0.0439742410303588	0.502105912491689	0.502105912491689	false	false	false	true
7b74d66b-ec43-44bb-bb4c-7416c98be989	2026-08-25 10:29	2026-08-25 10:29	2026-08-25 10:29	AEM	AEM261120C00220000	call	220.0000	2026-11-20	21.9000	21.5000	22.3000	219.0950	72270.00	15330.00	2190.00	33	8	197	5435	0.0362465501379945	0.502563133855104	0.502563133855104	false	false	false	true
719969ee-43cd-45df-a5f8-f134f6f25834	2026-08-25 10:29	2026-08-25 10:28	2026-08-25 10:28	AEM	AEM261120C00220000	call	220.0000	2026-11-20	22.0000	21.3000	22.0000	219.1050	63800.00	26400.00	0.00	29	5	164	5435	0.0301747930082797	0.504798900784235	0.504798900784235	false	false	false	true
009dc6ad-07eb-4e60-b585-a0733f275aa2	2026-08-25 10:28	2026-08-25 10:28	2026-08-25 10:28	AEM	AEM261120C00220000	call	220.0000	2026-11-20	22.0000	20.9000	22.0000	219.2555	68200.00	13200.00	0.00	31	5	127	5435	0.0233670653173873	0.502811664301211	0.502811664301211	false	false	false	true
abaace80-0aab-4924-88d3-072d44479177	2026-08-25 10:28	2026-08-25 10:27	2026-08-25 10:27	AEM	AEM261120C00220000	call	220.0000	2026-11-20	22.1000	20.8000	22.8000	219.0400	55250.00	55250.00	0.00	25	5	96	5435	0.0176632934682613	0.508024523885385	0.508024523885385	false	false	false	true
0d976472-9f47-491f-8bba-23965178eba1	2026-08-25 09:46	2026-08-25 09:46	2026-08-25 09:46	AEM	AEM270319C00240000	call	240.0000	2027-03-19	24.6900	23.1000	26.0000	216.7700	61724.00	61724.00	0.00	25	6	25	452	0.0553097345132743	0.489482437408584	0.489482437408584	false	false	false	true
f3fe80a0-59ce-4e64-861f-cea3e5e681d0	2026-08-25 09:37	2026-08-25 09:36	2026-08-25 09:36	AEM	AEM270219C00210000	call	210.0000	2027-02-19	34.0600	32.5000	35.1000	216.4700	71536.00	71536.00	0.00	21	8	21	206	0.101941747572816	0.48813960572582	0.48813960572582	false	false	false	true
fb5ba533-f90a-4610-a213-89a359660198	2026-08-24 15:16	2026-08-24 15:16	2026-08-24 15:16	AEM	AEM270617C00250000	call	250.0000	2027-06-17	27.8300	27.7000	28.9000	216.2000	556524.00	138229.00	335195.00	200	22	400	1736	0.230414746543779	0.478624003861406	0.486705787505372	false	false	false	true
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
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
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
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