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:alert_rule = RepeatedHits×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

5f11683b-5e3d-4396-9cd6-3b16649c6438	2026-09-22 14:34	2026-09-22 14:34	2026-09-22 14:34	AEM	AEM260925P00205000	put	205.0000	2026-09-25	4.7000	4.7000	5.2000	202.4601	61106.00	0.00	61106.00	130	31	201	25	8.04	0.450374029057553	0.450374029057553	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	101784485430.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:36:42.386317Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
63b42104-5bf8-4359-ab1d-335aa04d16e7	2026-09-22 10:38	2026-09-22 10:38	2026-09-22 10:38	AEM	AEM270115C00210000	call	210.0000	2027-01-15	16.2000	16.2000	16.8000	199.0000	66420.00	0.00	66420.00	41	5	44	669	0.0657698056801196	0.441678606059471	0.441678606059471	false	false	false	true
327e381c-74c5-44a0-a90b-c969b4519453	2026-09-22 10:08	2026-09-22 10:08	2026-09-22 10:08	AEM	AEM270617C00195000	call	195.0000	2027-06-17	35.2000	34.1000	36.7000	198.5200	17600.00	10560.00	7040.00	5	5	5	47	0.106382978723404	0.457031202290918	0.457031202290918	false	false	false	true
a70d7b30-1d24-435f-b4eb-63a66afe50f3	2026-09-21 12:51	2026-09-21 12:51	2026-09-21 12:51	AEM	AEM261218C00200000	call	200.0000	2026-12-18	16.5000	16.5000	17.1000	196.6200	85800.00	0.00	85800.00	52	16	52	501	0.103792415169661	0.445573539292427	0.445573539292427	false	false	false	true
022449dc-d195-4381-85a1-5b353c3d01f5	2026-09-21 12:51	2026-09-21 12:51	2026-09-21 12:51	AEM	AEM261218C00190000	call	190.0000	2026-12-18	21.3000	21.3000	21.9000	196.6200	115020.00	0.00	115020.00	54	15	54	190	0.284210526315789	0.444209554119774	0.444209554119774	false	false	false	true
884035b2-8f85-4f8c-81bf-112b954a729f	2026-09-21 12:14	2026-09-21 12:14	2026-09-21 12:14	AEM	AEM261218C00220000	call	220.0000	2026-12-18	9.9000	9.9000	10.1000	197.0300	14850.00	0.00	14850.00	15	6	36	558	0.0645161290322581	0.455682298941156	0.455682298941156	false	false	false	true
d8057d55-b95d-49ff-9bdb-4c480046a6f9	2026-09-21 10:40	2026-09-21 10:40	2026-09-21 10:40	AEM	AEM270115P00200000	put	200.0000	2027-01-15	20.2000	20.2000	20.8000	196.6400	333302.00	0.00	333302.00	165	34	175	142	1.23239436619718	0.449414886093793	0.449414886093793	false	false	false	true
66977803-9c88-4174-bea0-2b4a9226a5b4	2026-09-21 10:40	2026-09-21 10:40	2026-09-21 10:40	AEM	AEM270115P00190000	put	190.0000	2027-01-15	14.9000	14.5000	15.6000	196.7400	146020.00	1490.00	144530.00	98	25	100	259	0.386100386100386	0.444428785524452	0.445321607234564	false	false	false	true
46d12623-b6da-430d-bf0d-29aabb980352	2026-09-21 10:40	2026-09-21 10:40	2026-09-21 10:40	AEM	AEM270115P00210000	put	210.0000	2027-01-15	26.2000	26.2000	26.9000	196.6400	13100.00	0.00	13100.00	5	5	5	192	0.0260416666666667	0.452646497253714	0.452646497253714	false	false	false	true
21fd3f1a-d5d5-4d82-b04a-6c00dbd9851c	2026-09-18 13:12	2026-09-18 13:12	2026-09-18 13:12	AEM	AEM261016C00200000	call	200.0000	2026-10-16	9.5000	9.3000	9.8000	199.6900	57000.00	28500.00	1900.00	60	14	77	1248	0.061698717948718	0.424320809082235	0.424320809082235	false	false	false	true
8767e2cb-0731-4317-956f-652e6b7353e6	2026-09-17 12:15	2026-09-17 12:15	2026-09-17 12:15	AEM	AEM260925C00212500	call	212.5000	2026-09-25	1.7000	1.7000	2.0000	201.1050	51680.00	0.00	51680.00	304	18	307	4	76.75	0.459857340431674	0.459857340431674	false	false	false	true
b1446762-1828-4c93-97c6-040ec078e35f	2026-09-17 10:12	2026-09-17 10:12	2026-09-17 10:12	AEM	AEM270115P00195000	put	195.0000	2027-01-15	16.0000	15.2000	16.0000	203.2150	83200.00	83200.00	0.00	52	14	52	69	0.753623188405797	0.465894615064195	0.465894615064195	false	false	false	true
91f39bee-e27f-49ac-8658-e89962257e66	2026-09-17 10:12	2026-09-17 10:12	2026-09-17 10:12	AEM	AEM270115P00210000	put	210.0000	2027-01-15	24.1000	23.3000	24.1000	203.2150	134960.00	134960.00	0.00	56	16	56	159	0.352201257861635	0.472534406501945	0.472534406501945	false	false	false	true
3026e750-3d7e-4e7a-91ab-4b3ea7be8c36	2026-09-16 15:11	2026-09-16 15:11	2026-09-16 15:11	AEM	AEM260918P00195000	put	195.0000	2026-09-18	4.0000	3.4000	4.0000	193.6200	70400.00	70400.00	0.00	176	30	200	411	0.48661800486618	0.573069168132079	0.573069168132079	false	false	false	true
fcdf50f5-b147-4255-842a-64261374a470	2026-09-16 12:45	2026-09-16 12:45	2026-09-16 12:45	AEM	AEM270219C00270000	call	270.0000	2027-02-19	6.7500	6.5000	7.0000	198.0050	202500.00	102000.00	100500.00	300	2	300	13	23.0769230769231	0.47835145898719	0.47835145898719	false	true	false	true
42f3e59f-eab9-487e-977e-ac650d50c9d5	2026-09-14 11:23	2026-09-14 11:23	2026-09-14 11:23	AEM	AEM261218C00200000	call	200.0000	2026-12-18	17.3000	17.3000	17.8000	195.0100	299290.00	0.00	299290.00	173	17	191	367	0.520435967302452	0.471189268189359	0.471189268189359	false	false	false	true
bf5109f7-4ab5-4b2c-ba23-e353c9883503	2026-09-14 10:22	2026-09-14 10:22	2026-09-14 10:22	AEM	AEM261016P00195000	put	195.0000	2026-10-16	10.7000	10.4000	10.7000	194.0000	78110.00	78110.00	0.00	73	26	444	135	3.28888888888889	0.459668741163192	0.459668741163192	true	false	false	true
735c9ec9-d496-472e-8e12-5af71d1755ce	2026-09-14 10:12	2026-09-14 10:12	2026-09-14 10:12	AEM	AEM261016P00195000	put	195.0000	2026-10-16	10.7000	10.6000	10.7000	193.7550	378770.00	1070.00	1060.00	354	75	354	135	2.62222222222222	0.453686703894886	0.449313334996821	true	false	false	true
a56c8d9c-0204-486c-b2bc-f41de463478d	2026-09-10 15:34	2026-09-10 15:34	2026-09-10 15:34	AEM	AEM260911C00197500	call	197.5000	2026-09-11	2.3000	2.2500	3.0000	196.9000	99130.00	230.00	98900.00	431	32	505	15	33.6666666666667	0.626460347128836	0.626460347128836	false	false	false	true
ae40fd1a-3611-4e29-9716-2a6ba4c4bf06	2026-09-09 09:57	2026-09-09 09:57	2026-09-09 09:57	AEM	AEM261218P00200000	put	200.0000	2026-12-18	16.9000	15.4000	16.9000	204.8600	219700.00	219700.00	0.00	130	6	130	273	0.476190476190476	0.48251755939843	0.48251755939843	false	false	false	true
cadc8a73-20e3-40ff-87b0-171c997dec4b	2026-09-08 15:30	2026-09-08 15:30	2026-09-08 15:30	AEM	AEM261016C00230000	call	230.0000	2026-10-16	4.2000	4.1000	4.6000	202.3450	53340.00	0.00	52920.00	127	36	180	561	0.320855614973262	0.490179766571805	0.490179766571805	false	false	false	true
e84e5d64-dbf8-4a6a-9f40-f48eef668fee	2026-09-08 10:47	2026-09-08 10:47	2026-09-08 10:47	AEM	AEM261218C00240000	call	240.0000	2026-12-18	10.8500	10.1000	10.9000	205.8900	75920.00	34880.00	41040.00	70	6	111	375	0.296	0.504076169731111	0.504076169731111	false	false	false	true
df177917-eb62-4a72-9fb9-c7b3bbba06cd	2026-09-02 11:02	2026-09-02 11:01	2026-09-02 11:01	AEM	AEM260904C00190000	call	190.0000	2026-09-04	7.8000	7.8000	7.8000	197.0300	390000.00	0.00	0.00	500	54	1016	38	26.7368421052632	0.532878286433337	0.532878286433337	false	false	false	true
35c01459-d54a-43b7-8ef9-b019e1ba7dd2	2026-09-02 10:04	2026-09-02 10:04	2026-09-02 10:04	AEM	AEM260904C00190000	call	190.0000	2026-09-04	9.8000	9.8000	10.2000	198.8600	243040.00	0.00	57820.00	248	164	448	38	11.7894736842105	0.662632915231126	0.662632915231126	false	false	false	true
c9ddefe0-9bea-4b91-a70b-885cedddc3a1	2026-09-02 10:04	2026-09-02 10:04	2026-09-02 10:04	AEM	AEM260904C00190000	call	190.0000	2026-09-04	9.7000	9.7000	9.7000	198.8750	154230.00	0.00	0.00	159	44	200	38	5.26315789473684	0.631631487256913	0.631631487256913	false	false	false	true
a79da7a3-58b7-40ca-a2b7-0c971c771618	2026-08-31 10:19	2026-08-31 10:19	2026-08-31 10:19	AEM	AEM261120C00220000	call	220.0000	2026-11-20	11.3000	11.3000	12.3000	201.4400	395500.00	0.00	395500.00	350	25	656	3874	0.169334021683015	0.469959405157577	0.469959405157577	false	false	false	true
d5658b3a-1c22-471f-9653-e49d0ec022f3	2026-08-28 13:48	2026-08-28 13:48	2026-08-28 13:48	AEM	AEM261120C00220000	call	220.0000	2026-11-20	13.9000	13.9000	14.7000	206.1300	54210.00	0.00	54210.00	39	16	533	4091	0.130285993644586	0.476834714322607	0.476834714322607	false	false	false	true
db3f7d96-3f3d-4fc6-a0cf-492d4729e941	2026-08-28 13:48	2026-08-28 13:48	2026-08-28 13:48	AEM	AEM261120C00220000	call	220.0000	2026-11-20	14.1000	13.8000	14.7000	206.0600	56400.00	11280.00	33840.00	40	6	494	4091	0.120752872158396	0.48275077147007	0.48275077147007	false	false	false	true
8b147032-412d-4181-9082-a0f1a01c1dee	2026-08-28 13:47	2026-08-28 13:47	2026-08-28 13:47	AEM	AEM261120C00220000	call	220.0000	2026-11-20	14.2000	14.2000	14.8000	206.1900	230040.00	0.00	46860.00	162	8	195	4091	0.047665607430946	0.483814986103686	0.483814986103686	false	false	false	true
605f3e87-417a-400c-9d87-7113692981fe	2026-08-28 12:16	2026-08-28 12:16	2026-08-28 12:16	AEM	AEM270617C00180000	call	180.0000	2027-06-17	50.9000	50.9000	53.4000	207.9500	371570.00	0.00	371570.00	73	7	74	246	0.300813008130081	0.46123361116995	0.46123361116995	false	false	false	true
96595209-757b-461e-aae7-c36390ce89c3	2026-08-28 12:00	2026-08-28 12:00	2026-08-28 12:00	AEM	AEM261218C00250000	call	250.0000	2026-12-18	9.6000	9.6000	10.1000	208.0000	95040.00	0.00	95040.00	99	9	284	312	0.91025641025641	0.480169035452871	0.480169035452871	false	false	false	true
014d34f7-163b-453a-9174-2018760ff8c0	2026-08-28 10:07	2026-08-28 10:07	2026-08-28 10:07	AEM	AEM261218C00210000	call	210.0000	2026-12-18	23.5000	23.4000	24.5000	210.8100	190360.00	9410.00	178600.00	81	25	81	379	0.213720316622691	0.474642580363356	0.474642580363356	true	false	false	true
cd785a72-19c6-4296-9a24-ac8cdd77aa68	2026-08-27 14:49	2026-08-27 14:49	2026-08-27 14:49	AEM	AEM261120C00220000	call	220.0000	2026-11-20	18.7000	18.3000	19.1000	214.9300	50490.00	41140.00	0.00	27	5	742	4390	0.169020501138952	0.486164664597162	0.486164664597162	false	false	false	true
44a24e51-d168-45fb-a5bf-1b17cd082f42	2026-08-27 14:36	2026-08-27 14:36	2026-08-27 14:36	AEM	AEM261120C00220000	call	220.0000	2026-11-20	18.3000	18.3000	19.0000	214.6500	223260.00	0.00	223260.00	122	19	541	4390	0.123234624145786	0.480009614469968	0.480009614469968	false	false	false	true
64cec56a-c5b1-446f-9b20-9d68933961f0	2026-08-27 14:35	2026-08-27 14:34	2026-08-27 14:34	AEM	AEM261120C00220000	call	220.0000	2026-11-20	18.8000	18.5000	19.2000	214.8750	135360.00	28200.00	80840.00	72	5	369	4390	0.0840546697038724	0.48928108831457	0.48928108831457	false	false	false	true
1688cfc6-7522-44d8-a1a9-9cfe5a11c6fd	2026-08-27 11:25	2026-08-27 11:25	2026-08-27 11:25	AEM	AEM261218P00175000	put	175.0000	2026-12-18	6.4000	6.4000	7.0000	214.4250	56960.00	0.00	56960.00	89	7	108	63	1.71428571428571	0.490135643937	0.490135643937	false	false	false	true
3d77d50d-93f3-4032-bcaa-d3b7ee3061ef	2026-08-27 10:00	2026-08-27 09:59	2026-08-27 09:59	AEM	AEM270319C00240000	call	240.0000	2027-03-19	22.5000	21.8000	22.5000	212.9250	396000.00	396000.00	0.00	176	5	300	394	0.761421319796954	0.485608947536471	0.485608947536471	false	false	false	true
29f225b6-cbdd-4b06-95af-e72d12f7d05f	2026-08-27 09:57	2026-08-27 09:57	2026-08-27 09:57	AEM	AEM261120C00220000	call	220.0000	2026-11-20	18.0000	17.2000	18.8000	212.6700	68400.00	55800.00	0.00	38	5	243	4390	0.0553530751708428	0.497409025028945	0.497409025028945	false	false	false	true
e2ffea6e-cbe8-4b7c-8a02-2d6dea172802	2026-08-27 09:54	2026-08-27 09:53	2026-08-27 09:53	AEM	AEM261120C00220000	call	220.0000	2026-11-20	17.7000	17.2000	18.1000	212.1150	132750.00	26550.00	26550.00	75	5	205	4390	0.0466970387243736	0.496916370084582	0.496916370084582	false	false	false	true
1d86a9a2-dd77-4e31-ab2f-4903aced923d	2026-08-26 15:15	2026-08-26 15:15	2026-08-26 15:15	AEM	AEM260828C00220000	call	220.0000	2026-08-28	1.7500	1.4500	1.9000	215.0100	82075.00	350.00	81725.00	469	5	667	631	1.05705229793978	0.577700352473389	0.577700352473389	false	false	false	true
107f2eea-8b91-44c8-9344-142f5e4e392e	2026-08-26 11:33	2026-08-26 11:33	2026-08-26 11:33	AEM	AEM261120C00220000	call	220.0000	2026-11-20	19.7000	19.4000	20.1000	215.6750	61070.00	51220.00	9850.00	31	16	1008	4730	0.213107822410148	0.498505253486905	0.498505253486905	false	false	false	true
d43fb685-8792-43f9-88a7-78e8f1b15777	2026-08-26 11:32	2026-08-26 11:32	2026-08-26 11:32	AEM	AEM261120C00220000	call	220.0000	2026-11-20	19.7000	19.4000	20.0000	215.5900	116230.00	45310.00	61070.00	59	11	900	4730	0.190274841437632	0.499586341514838	0.499586341514838	false	false	false	true
7c10935b-0fe2-4fca-bb2d-15f6fa19c34a	2026-08-26 11:32	2026-08-26 11:32	2026-08-26 11:32	AEM	AEM261120C00220000	call	220.0000	2026-11-20	19.7000	19.5000	20.0000	215.5450	63040.00	35460.00	5910.00	32	8	774	4730	0.163636363636364	0.500158399131266	0.500158399131266	false	false	false	true
3c2496cd-fab1-4e2b-83ce-0b197120337c	2026-08-26 11:32	2026-08-26 11:32	2026-08-26 11:32	AEM	AEM261120C00220000	call	220.0000	2026-11-20	19.7000	19.6000	20.0000	215.5900	131990.00	76830.00	25610.00	67	14	841	4730	0.177801268498943	0.499586341514838	0.499586341514838	false	false	false	true
44c0736c-6206-4c9e-9c84-a81b76985141	2026-08-26 11:28	2026-08-26 11:28	2026-08-26 11:28	AEM	AEM261120C00220000	call	220.0000	2026-11-20	19.7000	19.2000	20.0000	215.3950	59099.00	59099.00	0.00	30	6	491	4730	0.103805496828753	0.502063856421793	0.502063856421793	false	false	false	true
00a0bf88-ca08-4129-84f5-7a673d600ec7	2026-08-26 11:28	2026-08-26 11:27	2026-08-26 11:27	AEM	AEM261120C00220000	call	220.0000	2026-11-20	19.7000	19.4000	19.7000	215.5500	72890.00	15760.00	0.00	37	5	441	4730	0.0932346723044397	0.50009484680947	0.50009484680947	false	false	false	true
cc685630-d93a-4f8e-8640-20b36ee328f7	2026-08-26 11:27	2026-08-26 11:27	2026-08-26 11:27	AEM	AEM261120C00220000	call	220.0000	2026-11-20	19.8000	19.5000	20.1000	215.5800	59400.00	11880.00	23760.00	30	5	134	4730	0.0283298097251586	0.502115445710546	0.502115445710546	false	false	false	true
50294f93-6c39-449d-9f9d-f0164a93d02c	2026-08-26 11:24	2026-08-26 11:24	2026-08-26 11:24	AEM	AEM261120C00220000	call	220.0000	2026-11-20	20.0000	20.0000	20.5000	216.0700	64000.00	0.00	64000.00	32	6	74	4730	0.0156448202959831	0.500666122640587	0.500666122640587	false	false	false	true
1594ea87-f136-42d4-8452-7ea075cef7de	2026-08-25 14:44	2026-08-25 14:44	2026-08-25 14:44	AEM	AEM261120C00220000	call	220.0000	2026-11-20	24.5000	23.7000	24.8000	223.2250	80850.00	66150.00	14700.00	33	5	1493	5435	0.274701011959522	0.508157247617962	0.508157247617962	false	false	false	true
2a160df2-2d76-4df3-8067-f10147f0829b	2026-08-25 14:44	2026-08-25 14:44	2026-08-25 14:44	AEM	AEM261120C00220000	call	220.0000	2026-11-20	24.5000	23.6000	24.5000	223.2000	107800.00	107800.00	0.00	44	5	1460	5435	0.268629254829807	0.508503001607679	0.508503001607679	false	false	false	true