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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = AMZN×

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

010db30c-2d89-4a8d-af6e-bee574b78a9f	2026-09-30 12:11	2026-09-30 12:11	2026-09-30 12:11	AMZN	AMZN261023C00275000	call	275.0000	2026-10-23	1.2700	1.2700	1.2800	251.8600	18415.00	0.00	18415.00	145	19	1084	2355	0.460297239915074	0.299971515982981	0.299971515982981	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2660659968805.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T16:13:44.335833Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
ef183e1f-5242-41f4-9d62-608d5d05d602	2026-09-30 12:11	2026-09-30 12:11	2026-09-30 12:11	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.8500	27.0500	251.9100	462680.00	94150.00	368530.00	172	20	1745	1065	1.63849765258216	0.359817351675417	0.359817351675417	true	false	false
d71589c2-082e-48dd-aac9-a96b0aa2bc4a	2026-09-30 12:10	2026-09-30 12:10	2026-09-30 12:10	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.7000	27.2000	251.9000	704780.00	279760.00	425020.00	262	11	809	1065	0.75962441314554	0.359898741787663	0.359858046536258	true	false	false
5c4999b2-6438-447b-802a-5dab13e23547	2026-09-30 12:10	2026-09-30 12:10	2026-09-30 12:10	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.8500	27.2000	251.8900	831213.00	94150.00	737063.00	309	24	1118	1065	1.04976525821596	0.359898741787663	0.359898741787663	true	false	false
433d3cde-1bb5-4bad-8641-5ad327470cb4	2026-09-30 12:09	2026-09-30 12:09	2026-09-30 12:09	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.6500	26.9000	251.8600	564900.00	564900.00	0.00	210	6	372	1065	0.349295774647887	0.360224317909365	0.360020829889447	false	false	false
cc6cfd12-153f-4a0c-b2ac-a664b9dedf18	2026-09-30 12:09	2026-09-30 12:08	2026-09-30 12:08	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.5500	27.3500	251.7600	435780.00	430400.00	5380.00	162	6	162	1065	0.152112676056338	0.360427815787336	0.360427815787336	true	false	false
0fd26e5a-282c-49c4-93cf-5de388688bc7	2026-09-30 12:08	2026-09-30 12:08	2026-09-30 12:08	AMZN	AMZN261005C00257500	call	257.5000	2026-10-05	1.2000	1.2000	1.2600	251.8400	11880.00	0.00	11880.00	99	8	1470	800	1.8375	0.272413408377148	0.272413408377148	false	false	false	true
0b83b2a7-83c0-4379-9b82-63f9fef3726b	2026-09-30 12:07	2026-09-30 12:07	2026-09-30 12:07	AMZN	AMZN261002P00250000	put	250.0000	2026-10-02	1.7500	1.7100	1.7500	251.8700	17500.00	17500.00	0.00	100	5	5743	5994	0.958124791458125	0.350914129569183	0.350914129569183	false	false	false	true
40eb789c-45c5-457d-8b9b-5c43b44d4377	2026-09-30 12:03	2026-09-30 12:02	2026-09-30 12:02	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.4500	0.4400	0.4500	251.6750	11059.00	6615.00	4444.00	248	38	79012	10577	7.47017112602817	0.370722675462844	0.366489815593102	false	false	false
091ab4ee-71bc-4a43-8855-ca728a03b180	2026-09-30 12:01	2026-09-30 12:01	2026-09-30 12:01	AMZN	AMZN261030C00255000	call	255.0000	2026-10-30	10.3000	10.1500	10.3500	251.3800	17510.00	15450.00	0.00	17	7	233	1497	0.15564462257849	0.402676251439593	0.402676251439593	false	false	false
c8abe554-ffe7-4035-b986-dc57b140b9db	2026-09-30 12:01	2026-09-30 12:01	2026-09-30 12:01	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.3600	0.3600	0.3700	251.3550	18468.00	0.00	18468.00	513	23	78316	10577	7.40436796823296	0.375915002642759	0.375915002642759	true	false	false
06e1e2a8-2fa6-4142-9448-1fe6e250451a	2026-09-30 12:01	2026-09-30 12:00	2026-09-30 12:00	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	7.0400	6.9000	7.0500	251.2950	14085.00	14085.00	0.00	20	5	3509	3740	0.938235294117647	0.382549840846876	0.372165353463947	false	false	false
7601b4d2-5e2c-4f30-a577-82a8b9e9af8d	2026-09-30 12:00	2026-09-30 12:00	2026-09-30 12:00	AMZN	AMZN261120C00265000	call	265.0000	2026-11-20	9.2000	9.1000	9.2000	251.2857	13800.00	920.00	0.00	15	15	401	21518	0.0186355609257366	0.377631920735512	0.377631920735512	false	false	false
755ed9ec-bf9b-475f-97d7-5d08229f4756	2026-09-30 11:59	2026-09-30 11:59	2026-09-30 11:59	AMZN	AMZN280616P00210000	put	210.0000	2028-06-16	19.6000	19.2000	19.6500	251.2000	143080.00	131320.00	5880.00	73	6	75	1700	0.0441176470588235	0.371907505641564	0.371907505641564	true	false	false
0468d167-5cb7-44c7-9881-4b7a9ab89d88	2026-09-30 11:59	2026-09-30 11:59	2026-09-30 11:59	AMZN	AMZN261002C00255000	call	255.0000	2026-10-02	1.2300	1.2300	1.2500	251.2050	14883.00	0.00	14883.00	121	7	20035	14814	1.35243688402862	0.360902232697882	0.360902232697882	false	false	false
82a67eff-8aad-417d-a2d1-d53d1272b720	2026-09-30 11:59	2026-09-30 11:59	2026-09-30 11:59	AMZN	AMZN261002P00257500	put	257.5000	2026-10-02	6.9600	6.8500	7.1000	251.0000	13920.00	0.00	13920.00	20	5	4827	459	10.516339869281	0.363563217239528	0.363563217239528	false	false	false	true
0b7a079f-abd0-43c1-a0ed-5c07893b59a6	2026-09-30 11:59	2026-09-30 11:59	2026-09-30 11:59	AMZN	AMZN261002P00257500	put	257.5000	2026-10-02	6.9600	6.8500	7.1000	251.0000	27840.00	0.00	27840.00	40	5	4667	459	10.1677559912854	0.352123719749576	0.356318720056559	false	false	false	true
da4400b5-bd5b-46f6-8359-c8b7f510f95f	2026-09-30 11:59	2026-09-30 11:59	2026-09-30 11:59	AMZN	AMZN261002P00260000	put	260.0000	2026-10-02	9.2300	9.1500	9.3000	251.0000	18460.00	18460.00	0.00	20	5	2898	1130	2.5646017699115	0.369644331075711	0.369644331075711	false	false	false	true
9f034bd1-6b5d-41d3-869f-918751308ccd	2026-09-30 11:59	2026-09-30 11:58	2026-09-30 11:58	AMZN	AMZN261002P00260000	put	260.0000	2026-10-02	9.2100	9.1500	9.2500	251.0000	26702.00	20262.00	0.00	29	5	2718	1130	2.40530973451327	0.372662306778976	0.375559319371254	false	false	false	true
05404e28-3b2d-4d8c-83de-340c2d71a983	2026-09-30 11:57	2026-09-30 11:57	2026-09-30 11:57	AMZN	AMZN261002P00260000	put	260.0000	2026-10-02	9.2000	9.1000	9.3000	251.0000	22092.00	4650.00	17442.00	24	6	2238	1130	1.98053097345133	0.403674551963468	0.370732803028585	false	false	false
f4d52dae-aead-479c-ae16-3aaf436f8097	2026-09-30 11:57	2026-09-30 11:57	2026-09-30 11:57	AMZN	AMZN261002P00260000	put	260.0000	2026-10-02	9.1800	9.1500	9.3000	251.0000	18350.00	0.00	18350.00	20	5	2214	1130	1.95929203539823	0.35332067099293	0.368714117092767	false	false	false	true
f450e5f8-ab76-4208-b32d-9c40b95bb02d	2026-09-30 11:57	2026-09-30 11:57	2026-09-30 11:57	AMZN	AMZN261002P00260000	put	260.0000	2026-10-02	9.2100	9.1500	9.3000	251.0000	22097.00	3692.00	18405.00	24	8	2130	1130	1.88495575221239	0.350400526659221	0.37197960230453	false	false	false	true
98e4dfa0-e4fa-48d7-a74e-c1b04218f4b3	2026-09-30 11:56	2026-09-30 11:56	2026-09-30 11:56	AMZN	AMZN261002C00242500	call	242.5000	2026-10-02	9.0200	8.8500	9.2500	251.0000	18040.00	0.00	18040.00	20	5	4209	926	4.54535637149028	0.391548527822401	0.391548527822401	false	false	false	true
12de3cc8-cd70-4cb1-8af6-a6896296793c	2026-09-30 11:56	2026-09-30 11:56	2026-09-30 11:56	AMZN	AMZN261002P00262500	put	262.5000	2026-10-02	11.4300	11.4000	11.7000	251.0000	22854.00	0.00	22854.00	20	6	1878	150	12.52	0.347341394252831	0.377601578761446	false	false	false	true
f6124a0b-48f2-430b-a9c8-003eef97e88c	2026-09-30 11:56	2026-09-30 11:56	2026-09-30 11:56	AMZN	AMZN270115C00260000	call	260.0000	2027-01-15	16.2500	16.1000	16.3000	251.0000	13000.00	1625.00	8125.00	8	6	191	10450	0.0182775119617225	0.345173065440129	0.345173065440129	false	false	false
752cb3b9-2ddf-4acf-acd3-6e326007fae3	2026-09-30 11:55	2026-09-30 11:55	2026-09-30 11:55	AMZN	AMZN261002P00262500	put	262.5000	2026-10-02	11.5100	11.4000	11.6500	251.0000	23020.00	0.00	23020.00	20	5	1730	150	11.5333333333333	0.3831651334081	0.3831651334081	false	false	false	true
5ced7e47-a726-4fee-a195-f3b931492b55	2026-09-30 11:55	2026-09-30 11:55	2026-09-30 11:55	AMZN	AMZN261002P00262500	put	262.5000	2026-10-02	11.4500	11.4000	11.6000	251.0000	22905.00	0.00	22905.00	20	7	1584	150	10.56	0.335874708391672	0.373530266753153	false	false	false	true
91c7e1ce-268c-4a8a-96d8-9cc780f9c7a3	2026-09-30 11:55	2026-09-30 11:55	2026-09-30 11:55	AMZN	AMZN261002P00262500	put	262.5000	2026-10-02	11.5300	11.4000	11.6000	251.0000	46100.00	46100.00	0.00	40	5	1442	150	9.61333333333333	0.397487771585877	0.393396918052819	false	false	false	true
d918efc0-e1c8-464f-b2b0-e1ce01db1f08	2026-09-30 11:55	2026-09-30 11:54	2026-09-30 11:54	AMZN	AMZN261002P00257500	put	257.5000	2026-10-02	6.7900	6.7500	7.0000	251.0000	13582.00	2082.00	11500.00	20	7	4227	459	9.20915032679738	0.317233800619177	0.358631078731693	false	false	false	true
7bf5a513-cc25-483d-8587-a16c25909adc	2026-09-30 11:55	2026-09-30 11:54	2026-09-30 11:54	AMZN	AMZN261002P00262500	put	262.5000	2026-10-02	11.5600	11.4000	11.6000	251.0000	23112.00	23112.00	0.00	20	5	1402	150	9.34666666666667	0.422271529646005	0.391492127271614	false	false	false	true
4a33bcba-8940-44ce-9fdf-99a5a16dbbdd	2026-09-30 11:54	2026-09-30 11:54	2026-09-30 11:54	AMZN	AMZN260930P00252500	put	252.5000	2026-09-30	1.5900	1.5500	1.5900	251.0000	15900.00	15900.00	0.00	100	7	8873	1132	7.83833922261484	0.397988734511695	0.397988734511695	true	false	false	true
0984aa28-709e-4952-98f9-8f679bfb0f03	2026-09-30 11:54	2026-09-30 11:54	2026-09-30 11:54	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	1.5600	1.5600	1.6000	251.0000	17472.00	0.00	17472.00	112	8	41859	9228	4.53608582574772	0.337656450783571	0.337656450783571	true	false	false
493bbd1b-9950-4c2d-a99e-cacec27e47f8	2026-09-30 11:54	2026-09-30 11:54	2026-09-30 11:54	AMZN	AMZN290119C00220000	call	220.0000	2029-01-19	83.4700	82.3000	84.9000	251.0000	100158.00	91798.00	8360.00	12	7	17	56	0.303571428571429	0.38837586753924	0.386091119179004	false	false	false
ce1784fd-9732-4882-9e82-9ea115b06907	2026-09-30 11:54	2026-09-30 11:54	2026-09-30 11:54	AMZN	AMZN261002P00257500	put	257.5000	2026-10-02	6.8200	6.7500	7.0000	251.0000	13644.00	0.00	13644.00	20	5	4087	459	8.9041394335512	0.33060072715546	0.356052977629572	false	false	false	true
4cf0a806-3f33-4d35-8a63-a0cab68c6251	2026-09-30 11:54	2026-09-30 11:53	2026-09-30 11:53	AMZN	AMZN261218C00285000	call	285.0000	2026-12-18	6.2000	6.1500	6.2500	251.0000	636120.00	113460.00	479880.00	1026	20	2210	9218	0.239748318507268	0.355108670249291	0.355108670249291	false	false	false
ea027a59-d0e5-4bed-9f32-5acd6d96c39f	2026-09-30 11:51	2026-09-30 11:51	2026-09-30 11:51	AMZN	AMZN261002P00257500	put	257.5000	2026-10-02	6.8600	6.6000	6.9500	251.0000	13714.00	13714.00	0.00	20	6	3067	459	6.68191721132898	0.368389532519931	0.368389532519931	false	false	false	true
7130dcb5-b181-4e94-9385-0f8565155468	2026-09-30 11:50	2026-09-30 11:49	2026-09-30 11:49	AMZN	AMZN261002C00242500	call	242.5000	2026-10-02	9.4500	9.1500	9.5000	251.0000	18904.00	18904.00	0.00	20	5	3609	926	3.89740820734341	0.416723676278426	0.393513585903983	false	false	false	true
7ad761a6-8bc2-4362-a288-abf87aa8fe56	2026-09-30 11:49	2026-09-30 11:49	2026-09-30 11:49	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.4000	0.3900	0.4000	251.0000	20320.00	20320.00	0.00	508	5	75939	10577	7.17963505719958	0.373269490328407	0.373269490328407	false	false	false
b548d250-5259-4d16-b193-71b51158ab00	2026-09-30 11:48	2026-09-30 11:48	2026-09-30 11:48	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.3500	0.3400	0.3600	251.2800	21281.00	21211.00	0.00	608	8	74729	10577	7.06523588919353	0.371923704194192	0.377329861236976	true	false	false
6c62d88f-7ec7-4850-8ae3-aa97b7689caf	2026-09-30 11:48	2026-09-30 11:48	2026-09-30 11:48	AMZN	AMZN261002P00250000	put	250.0000	2026-10-02	1.9700	1.9700	2.0500	251.2800	26398.00	0.00	26398.00	134	9	5438	5994	0.907240573907241	0.349014894679854	0.349014894679854	true	false	false	true
c1662bb2-e332-420f-8d71-ee9fec7ba0aa	2026-09-30 11:47	2026-09-30 11:47	2026-09-30 11:47	AMZN	AMZN261030C00245000	call	245.0000	2026-10-30	15.2000	15.0000	15.3000	250.9500	45600.00	18240.00	27360.00	30	5	1642	1577	1.04121750158529	0.406539473139537	0.406539473139537	false	false	false
957948be-960e-483b-9cc2-275f65e7ed9a	2026-09-30 11:47	2026-09-30 11:47	2026-09-30 11:47	AMZN	AMZN280616C00270000	call	270.0000	2028-06-16	49.0900	48.1000	49.1500	250.9650	112918.00	58920.00	49088.00	23	14	35	1203	0.029093931837074	0.370083277712645	0.370083277712645	true	false	false
d837a7a9-3161-492b-bf98-1c97823be2ad	2026-09-30 11:47	2026-09-30 11:47	2026-09-30 11:47	AMZN	AMZN261002C00242500	call	242.5000	2026-10-02	8.9000	8.6500	8.9000	250.8700	17800.00	17800.00	0.00	20	5	3287	926	3.54967602591793	0.40687978176317	0.40687978176317	false	false	false	true
c3cd5c81-e73f-4ec3-b1cd-07a89ad24404	2026-09-30 11:46	2026-09-30 11:46	2026-09-30 11:46	AMZN	AMZN261002C00240000	call	240.0000	2026-10-02	11.1500	11.0000	11.2500	250.8900	22300.00	22300.00	0.00	20	5	2640	1796	1.46993318485523	0.398693317707304	0.398693317707304	false	false	false
a6897320-b3d2-443b-a080-08482bf472e2	2026-09-30 11:46	2026-09-30 11:46	2026-09-30 11:46	AMZN	AMZN261002C00255000	call	255.0000	2026-10-02	1.1300	1.1000	1.1300	250.8400	22600.00	22600.00	0.00	200	5	19432	14814	1.31173214526799	0.361576096723281	0.361576096723281	false	false	false
443e9559-fe2f-4720-8ea8-665b9986fbed	2026-09-30 11:45	2026-09-30 11:45	2026-09-30 11:45	AMZN	AMZN260930P00252500	put	252.5000	2026-09-30	1.8500	1.8500	1.9100	250.9100	36075.00	0.00	36075.00	195	8	8354	1132	7.37985865724382	0.374313293946361	0.374313293946361	false	false	false	true
e887cef6-5b9b-4784-aa33-b2815da80696	2026-09-30 11:44	2026-09-30 11:44	2026-09-30 11:44	AMZN	AMZN280616P00240000	put	240.0000	2028-06-16	31.9500	31.3000	31.9500	250.0000	44725.00	44725.00	0.00	14	5	23	1073	0.0214352283317801	0.373446476892242	0.373012474265142	false	false	false
b9873cbf-6288-4d50-b789-d28c62e5db19	2026-09-30 11:44	2026-09-30 11:44	2026-09-30 11:44	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	18.3000	18.3000	18.4000	250.0000	12810.00	0.00	12810.00	7	6	599	14280	0.0419467787114846	0.359675964464015	0.359675964464015	false	false	false
66ca3ab4-a5ff-4ec4-81b3-249b1aeae196	2026-09-30 11:44	2026-09-30 11:44	2026-09-30 11:44	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.3100	0.2900	0.3200	250.0000	20730.00	0.00	20430.00	671	19	72991	10577	6.90091708423939	0.387833691367459	0.38274617474576	true	false	false
7e48a672-c611-475c-913f-0f95ce205be7	2026-09-30 11:44	2026-09-30 11:44	2026-09-30 11:44	AMZN	AMZN260930P00250000	put	250.0000	2026-09-30	0.4000	0.3900	0.4000	250.0000	10280.00	10280.00	0.00	257	6	36064	4255	8.47567567567568	0.362902469931078	0.362902469931078	false	false	false	true