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:ticker = AMZN×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

64545ce1-a44c-4c76-9d51-1f8963a0cf3e	2026-08-27 14:43	2026-08-27 14:43	2026-08-27 14:43	AMZN	AMZN260918P00260000	put	260.0000	2026-09-18	9.2000	9.2000	9.3000	255.4750	234600.00	0.00	234600.00	255	9	890	11668	0.0762769969146383	0.280119556057826	0.280119556057826	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2734761943045.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e8a41568-80db-438f-aa74-053813bd0145	2026-08-27 15:12	2026-08-27 15:12	2026-08-27 15:12	AMZN	AMZN270617C00280000	call	280.0000	2027-06-17	26.4000	26.4000	26.6000	255.6600	261360.00	0.00	261360.00	99	14	203	8610	0.0235772357723577	0.357382796760126	0.357382796760126	false	false	false	true	false
179593c6-2d1a-4dab-bc9e-1fc8d117318c	2026-08-27 15:17	2026-08-27 15:17	2026-08-27 15:17	AMZN	AMZN260918P00250000	put	250.0000	2026-09-18	4.2000	4.1500	4.3000	255.0000	572880.00	2940.00	569940.00	1364	67	2094	13259	0.157930462327476	0.280775889063136	0.280775889063136	false	false	false	true	false
84f95b71-9032-4a40-82cb-a50ba460e959	2026-08-27 15:18	2026-08-27 15:18	2026-08-27 15:18	AMZN	AMZN271217C00285000	call	285.0000	2027-12-17	37.0000	37.0000	37.2000	255.0000	2035000.00	0.00	2035000.00	550	22	555	4308	0.12883008356546	0.367078314987821	0.367078314987821	false	false	false	true	false
55da6d47-c8ce-465c-bfc6-8efcd8b8721e	2026-08-27 15:18	2026-08-27 15:18	2026-08-27 15:18	AMZN	AMZN271217C00285000	call	285.0000	2027-12-17	37.0000	36.7500	37.1000	255.0000	492100.00	29600.00	462500.00	133	8	838	4308	0.194521819870009	0.367078314987821	0.367078314987821	true	false	false	true	false
024d5fd2-6dc7-411c-a6f3-b8abaf5a5407	2026-08-27 15:19	2026-08-27 15:19	2026-08-27 15:19	AMZN	AMZN271217C00285000	call	285.0000	2027-12-17	37.0500	36.9000	37.0500	255.0000	807690.00	715065.00	0.00	218	20	1056	4308	0.245125348189415	0.367416723147589	0.367416723147589	true	false	false	true	false
8770b51b-c041-4093-9a96-a9bad0863f18	2026-08-27 15:28	2026-08-27 15:28	2026-08-27 15:28	AMZN	AMZN260918P00275000	put	275.0000	2026-09-18	20.2000	19.8500	20.6000	255.0000	202000.00	189880.00	12120.00	100	18	340	3016	0.112732095490716	0.287292571186421	0.287292571186421	true	false	false	true	false
bb2542fc-b3c2-444c-9a56-1fb3d23d6d76	2026-08-27 15:41	2026-08-27 15:41	2026-08-27 15:41	AMZN	AMZN260904C00255000	call	255.0000	2026-09-04	5.1000	4.9500	5.1500	256.4300	130050.00	82620.00	6120.00	255	5	4454	789	5.64512040557668	0.280131536762696	0.280093336145381	false	false	false	true	false
33c42c5a-82a0-4175-b470-31e79a77518e	2026-08-27 15:43	2026-08-27 15:43	2026-08-27 15:43	AMZN	AMZN260918C00260000	call	260.0000	2026-09-18	5.7000	5.6500	5.7000	256.6800	136800.00	136800.00	0.00	240	6	8651	20915	0.413626583791537	0.276156911425552	0.276156911425552	false	false	false	true	false
ed2621fb-10c8-4d95-bc25-3de8c74da0dd	2026-08-27 15:47	2026-08-27 15:47	2026-08-27 15:47	AMZN	AMZN260831C00255000	call	255.0000	2026-08-31	3.6000	3.5000	3.6000	256.9601	326880.00	326880.00	0.00	908	5	2637	252	10.4642857142857	0.227196337151857	0.227196337151857	false	false	false	true	false
ce8bc68e-4d50-45db-94ac-701276bdf4a1	2026-08-28 09:30	2026-08-28 09:30	2026-08-28 09:30	AMZN	AMZN260918C00260000	call	260.0000	2026-09-18	6.5000	6.1000	6.5000	258.4600	937300.00	937300.00	0.00	1442	5	1470	22714	0.0647177951923924	0.281527457438668	0.281527457438668	false	false	false	true	false
00337c5c-3924-445e-954c-0feffaa86591	2026-08-28 09:49	2026-08-28 09:49	2026-08-28 09:49	AMZN	AMZN261016C00265000	call	265.0000	2026-10-16	9.2500	9.1500	9.2500	259.5100	254275.00	254275.00	0.00	275	7	361	11088	0.0325577200577201	0.293005641329083	0.292740856202153	false	false	false	true	false
c77a8b4e-918d-4a06-af93-1d45107fc3db	2026-08-28 09:49	2026-08-28 09:49	2026-08-28 09:49	AMZN	AMZN260904C00257500	call	257.5000	2026-09-04	5.0500	5.0500	5.2000	259.4600	546948.00	0.00	546948.00	1083	50	1620	1943	0.833762223365929	0.271940440298349	0.272658323175471	false	false	false	true	false
0f5960a4-a5b7-49fa-b1a5-3aa4da2e0f51	2026-08-28 09:49	2026-08-28 09:49	2026-08-28 09:49	AMZN	AMZN260904C00255000	call	255.0000	2026-09-04	6.6500	6.6500	6.9000	259.2700	225435.00	0.00	225435.00	339	17	1078	1754	0.614595210946408	0.274118526310961	0.284274191051652	false	false	false	true	false
5386c7c1-2d96-4f9c-9dcc-bd93e9bdcaac	2026-08-28 10:01	2026-08-28 10:01	2026-08-28 10:01	AMZN	AMZN261016C00280000	call	280.0000	2026-10-16	4.5000	4.3000	4.5000	260.1100	103040.00	103040.00	0.00	229	15	428	16606	0.0257738166927617	0.290783730447236	0.290783730447236	false	false	false	true	false
7690960d-b284-4a51-b3bb-d3fc8f51db8e	2026-08-28 10:18	2026-08-28 10:18	2026-08-28 10:18	AMZN	AMZN270716C00290000	call	290.0000	2027-07-16	26.8000	26.3500	26.8000	260.1748	166155.00	163480.00	2675.00	62	5	63	1002	0.062874251497006	0.355430555623412	0.355430555623412	false	false	false	true	false
e9fd2e4c-b0cb-4bf7-befe-31fe2086fcbc	2026-08-28 10:19	2026-08-28 10:19	2026-08-28 10:19	AMZN	AMZN270716C00315000	call	315.0000	2027-07-16	19.3400	18.9500	19.5000	260.3450	191512.00	189577.00	1935.00	99	14	99	336	0.294642857142857	0.353798028462185	0.353798028462185	false	false	false	true	false
ac2c31a6-0bdd-4a4d-ae91-6ef707dace5c	2026-08-28 10:20	2026-08-28 10:19	2026-08-28 10:19	AMZN	AMZN270716C00315000	call	315.0000	2027-07-16	19.5000	19.2500	19.5000	260.5200	130650.00	130650.00	0.00	67	13	166	336	0.494047619047619	0.354687439495054	0.354687439495054	false	false	false	true	false
0a0909ea-8e5f-4030-b8f5-be82dc79550e	2026-08-28 10:21	2026-08-28 10:21	2026-08-28 10:21	AMZN	AMZN260918P00260000	put	260.0000	2026-09-18	6.0500	6.0000	6.2500	260.8200	497310.00	287980.00	209330.00	822	42	1024	11463	0.089330890691791	0.269722894865461	0.270089510813163	false	false	false	true	false
1238d621-f1ac-4301-b053-5ca5f6ea12bf	2026-08-28 10:25	2026-08-28 10:25	2026-08-28 10:25	AMZN	AMZN260828C00262500	call	262.5000	2026-08-28	0.5700	0.5500	0.6000	261.1400	114495.00	114495.00	0.00	2007	34	31146	11933	2.61007290706444	0.424393299044093	0.437119478795156	true	false	false	true	false
0d7745ab-9fbc-4beb-8e66-2fb0212ec13b	2026-08-28 10:42	2026-08-28 10:42	2026-08-28 10:42	AMZN	AMZN260831P00265000	put	265.0000	2026-08-31	3.5000	3.4500	3.5000	262.6300	353850.00	353850.00	0.00	1011	7	1857	138	13.4565217391304	0.227173204651781	0.227173204651781	true	false	false	true	false
d4f96263-331f-4346-9666-98680c85afec	2026-08-28 10:45	2026-08-28 10:45	2026-08-28 10:45	AMZN	AMZN271217C00320000	call	320.0000	2027-12-17	30.4000	29.9500	30.5000	263.5500	100320.00	63890.00	36430.00	33	8	335	3692	0.0907367280606717	0.372277388687819	0.372048969604832	false	false	false	true	false
99372b57-0582-4a17-bc6c-1ce95cfa3cef	2026-08-28 10:46	2026-08-28 10:46	2026-08-28 10:46	AMZN	AMZN280616C00310000	call	310.0000	2028-06-16	44.4500	43.8000	44.4500	263.5300	106670.00	106670.00	0.00	24	5	53	340	0.155882352941176	0.380958490781777	0.38060296431897	false	false	false	true	false
939cd5b0-89b4-49a1-be67-b2511049f86b	2026-08-28 10:48	2026-08-28 10:48	2026-08-28 10:48	AMZN	AMZN280616C00290000	call	290.0000	2028-06-16	52.3800	51.8000	52.4000	264.3801	146660.00	130985.00	15675.00	28	11	134	320	0.41875	0.386681943988099	0.385595113033029	false	false	false	true	false
5ec062a9-5a4a-494e-bb1b-70513404f719	2026-08-28 10:48	2026-08-28 10:48	2026-08-28 10:48	AMZN	AMZN280616C00290000	call	290.0000	2028-06-16	52.3100	51.9000	52.4000	264.3801	115085.00	57590.00	57495.00	22	6	168	320	0.525	0.38631964451475	0.385957367538134	false	false	false	true	false
4e4ad7fb-565a-4638-ba37-97e784bf2e8c	2026-08-28 10:48	2026-08-28 10:48	2026-08-28 10:48	AMZN	AMZN280616C00290000	call	290.0000	2028-06-16	52.5300	51.5500	52.6000	264.4100	173340.00	36760.00	136580.00	33	5	272	320	0.85	0.387278741164051	0.387641077289407	false	false	false	true	false
ff3aacd4-cf5f-4161-ada9-9ed07ecc64c9	2026-08-28 10:48	2026-08-28 10:48	2026-08-28 10:48	AMZN	AMZN280616C00290000	call	290.0000	2028-06-16	52.6000	52.2500	52.6000	264.4300	110460.00	110460.00	0.00	21	7	295	320	0.921875	0.387917863633791	0.387917863633791	false	false	false	true	false
caaa31f9-e591-4b15-b82e-3350f5ba6ae8	2026-08-28 10:48	2026-08-28 10:48	2026-08-28 10:48	AMZN	AMZN280616C00270000	call	270.0000	2028-06-16	60.5200	59.5500	60.5500	264.4100	139205.00	66605.00	72600.00	23	5	180	1078	0.166975881261596	0.390088450833316	0.390088450833316	false	false	false	true	false
84eeede7-0825-413c-8721-1c0495d8f79d	2026-08-28 10:48	2026-08-28 10:48	2026-08-28 10:48	AMZN	AMZN260925C00260000	call	260.0000	2026-09-25	11.4400	11.0500	11.4500	264.4250	114411.00	114411.00	0.00	100	6	452	907	0.498346196251378	0.297729020349119	0.297372933906344	false	false	false	true	false
d3c39928-5042-42cb-b2be-836846f518d4	2026-08-28 10:48	2026-08-28 10:48	2026-08-28 10:48	AMZN	AMZN280616C00280000	call	280.0000	2028-06-16	56.3800	56.0500	56.4000	264.4250	287540.00	231190.00	56350.00	51	6	156	628	0.248407643312102	0.388759096824479	0.388759096824479	false	false	false	true	false
3cde9373-deab-4a06-b942-37e5a23c8853	2026-08-28 10:49	2026-08-28 10:49	2026-08-28 10:49	AMZN	AMZN270617P00200000	put	200.0000	2027-06-17	7.3000	7.0500	7.3000	264.4400	112401.00	112401.00	0.00	154	9	164	10332	0.0158730158730159	0.377100078551694	0.377100078551694	false	false	false	true	false
246c2b9a-69e9-4d35-bdef-e03e0e25bc68	2026-08-28 10:49	2026-08-28 10:49	2026-08-28 10:49	AMZN	AMZN270917P00225000	put	225.0000	2027-09-17	16.9500	16.3000	17.0500	264.3800	210200.00	107100.00	103100.00	124	6	196	380	0.515789473684211	0.374186400334606	0.372983422142078	false	false	false	true	false
de436403-37e7-424c-b403-4f654a393c02	2026-08-28 10:51	2026-08-28 10:50	2026-08-28 10:50	AMZN	AMZN280616C00290000	call	290.0000	2028-06-16	52.8800	52.4000	53.0000	264.6950	158625.00	79350.00	79275.00	30	6	569	320	1.778125	0.388946209587462	0.388594721017666	false	false	false	true	false
70cc7171-6e3e-43d7-a6b1-b18461febd7d	2026-08-28 10:51	2026-08-28 10:51	2026-08-28 10:51	AMZN	AMZN280616C00290000	call	290.0000	2028-06-16	52.9300	52.4000	53.1000	264.8200	121740.00	63550.00	58190.00	23	5	592	320	1.85	0.389274161951086	0.389145565492632	false	false	false	true	false
b8f1bd98-a1f1-42ad-b812-98f1cc9f7a6e	2026-08-28 10:52	2026-08-28 10:52	2026-08-28 10:52	AMZN	AMZN260918P00270000	put	270.0000	2026-09-18	9.7000	9.7000	10.0000	264.6600	3618183.00	0.00	3618183.00	3730	76	3782	6098	0.620203345359134	0.276872143041611	0.276872143041611	false	false	false	true	false
2f90de01-3148-44d1-9feb-6e40576037f5	2026-08-28 10:52	2026-08-28 10:52	2026-08-28 10:52	AMZN	AMZN260918C00265000	call	265.0000	2026-09-18	7.3700	7.3500	7.4500	264.9500	157000.00	65860.00	91140.00	213	12	2558	14278	0.179156744642107	0.279859208873963	0.281627741170163	true	false	false	true	false
37838556-893e-4b12-88a1-e33a616dd81f	2026-08-28 10:52	2026-08-28 10:52	2026-08-28 10:52	AMZN	AMZN280121C00300000	call	300.0000	2028-01-21	39.8700	39.3500	39.9000	264.9450	107655.00	103685.00	3970.00	27	6	177	13286	0.013322294144212	0.376987549732741	0.37706774243746	true	false	false	true	false
2286f7ca-71fa-4c50-ba02-8e3866003138	2026-08-28 10:53	2026-08-28 10:53	2026-08-28 10:53	AMZN	AMZN260918C00265000	call	265.0000	2026-09-18	7.1600	7.1500	7.3000	264.6650	215630.00	0.00	165950.00	301	18	3490	14278	0.244431993276369	0.278418102789792	0.27960397419023	true	false	false	true	false
ba594cf1-6631-4909-ac2a-01feea0886f3	2026-08-28 10:54	2026-08-28 10:54	2026-08-28 10:54	AMZN	AMZN270115C00250000	call	250.0000	2027-01-15	32.9000	32.5500	32.9000	264.9100	164500.00	164500.00	0.00	50	9	200	31777	0.00629386033923907	0.354665780809684	0.354665780809684	false	false	false	true	false
c4242919-85dc-4d12-844d-6739e499fe13	2026-08-28 10:55	2026-08-28 10:55	2026-08-28 10:55	AMZN	AMZN260831C00262500	call	262.5000	2026-08-31	3.3000	3.3000	3.4000	264.6342	132000.00	0.00	132000.00	400	34	8173	1306	6.25803981623277	0.209780223752247	0.209780223752247	false	false	false	true	false
af5ae959-483f-4b80-8a4e-1e136fd181db	2026-08-28 10:55	2026-08-28 10:55	2026-08-28 10:55	AMZN	AMZN260904C00267500	call	267.5000	2026-09-04	3.0500	3.0500	3.1000	264.7500	106750.00	0.00	106750.00	350	10	2885	5540	0.520758122743682	0.28608535835429	0.28608535835429	false	false	false	true	false
3872a752-863b-4335-b244-bb329b163b8e	2026-08-28 10:57	2026-08-28 10:57	2026-08-28 10:57	AMZN	AMZN260831C00260000	call	260.0000	2026-08-31	5.6000	5.4000	5.6000	265.0700	728000.00	728000.00	0.00	1300	5	13483	3931	3.42991605189519	0.222666053067398	0.219821484229309	false	false	false	true	false
330f8034-f358-4bd0-9d5b-c366446fa87a	2026-08-28 10:59	2026-08-28 10:58	2026-08-28 10:58	AMZN	AMZN260904P00265000	put	265.0000	2026-09-04	4.0000	3.9500	4.1000	265.1799	317610.00	0.00	317610.00	794	49	1702	946	1.79915433403805	0.283197102773691	0.285812264521891	false	false	false	true	false
77cd8183-c55a-4616-b96d-7e0703c203c0	2026-08-28 11:00	2026-08-28 10:59	2026-08-28 10:59	AMZN	AMZN260918C00275000	call	275.0000	2026-09-18	3.6500	3.5500	3.6500	265.2150	546597.00	546597.00	0.00	1498	80	4787	18652	0.256648080634784	0.284629595939746	0.284629595939746	true	false	false	true	false
f9cc87e6-6fea-4c9c-8453-8105ed024fc0	2026-08-28 11:00	2026-08-28 11:00	2026-08-28 11:00	AMZN	AMZN261120C00295000	call	295.0000	2026-11-20	8.5500	8.2500	8.5500	265.4400	1282100.00	1282100.00	0.00	1500	41	26934	3235	8.3258114374034	0.358690648382227	0.357876484134572	false	false	false	true	false
986b582a-fde2-4043-8d11-944d9c6c921f	2026-08-28 11:03	2026-08-28 11:03	2026-08-28 11:03	AMZN	AMZN260918C00270000	call	270.0000	2026-09-18	5.6100	5.6000	5.7500	265.9200	134520.00	0.00	134520.00	240	14	4109	26171	0.157005846165603	0.281571727887696	0.281969715646949	false	false	false	true	false
9dc479d8-6074-44c8-88c5-a7bfa1dde847	2026-08-28 11:04	2026-08-28 11:04	2026-08-28 11:04	AMZN	AMZN270319C00300000	call	300.0000	2027-03-19	18.2000	17.8500	18.2000	266.2800	107380.00	107380.00	0.00	59	8	303	7364	0.0411461162411733	0.359239580495992	0.359239580495992	false	false	false	true	false
07944adb-e5f1-499f-9cfd-63873208acc2	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	AMZN	AMZN270617C00325000	call	325.0000	2027-06-17	18.6400	17.9500	18.6500	266.7100	188295.00	175280.00	11155.00	101	12	102	1183	0.0862214708368555	0.367195605352732	0.367134344819551	false	false	false	true	false
2ba455c7-c1da-454d-8245-fa2a27acf871	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	AMZN	AMZN261120P00260000	put	260.0000	2026-11-20	14.0500	13.8000	14.0500	266.5700	389167.00	389167.00	0.00	277	20	331	4245	0.0779740871613663	0.361976368537082	0.361976368537082	false	false	false	true	false
aee08247-3e2a-463a-be2a-5a162703f8ba	2026-08-28 11:08	2026-08-28 11:08	2026-08-28 11:08	AMZN	AMZN261218C00290000	call	290.0000	2026-12-18	12.8000	12.6500	12.8000	266.4900	165120.00	66560.00	0.00	129	5	325	5018	0.0647668393782383	0.350136679685661	0.350136679685661	false	false	false	true	false