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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = AMZN×

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

392a85f0-83c9-4259-b24b-8cf58c8e8698	2026-09-24 15:27	2026-09-24 15:27	2026-09-24 15:27	AMZN	AMZN260928C00250000	call	250.0000	2026-09-28	2.2400	2.2000	2.2400	249.4600	44800.00	44800.00	0.00	200	5	4289	1344	3.19122023809524	0.234903238652645	0.234903238652645	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2688704384092.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:29:28.297700Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
eefdcf34-20dd-4861-ae0a-f7a58ebe279e	2026-09-24 15:27	2026-09-24 15:27	2026-09-24 15:27	AMZN	AMZN270115C00250000	call	250.0000	2027-01-15	20.4000	20.4000	20.4000	249.4150	102000.00	0.00	0.00	50	5	1306	33286	0.0392357147148951	0.345757445694704	0.345757445694704	false	false	false	true
e5cb21e5-80b2-4f16-91b8-f03f8064eb82	2026-09-24 15:24	2026-09-24 15:24	2026-09-24 15:24	AMZN	AMZN260925C00252500	call	252.5000	2026-09-25	0.5900	0.5900	0.6100	249.6144	29500.00	0.00	29500.00	500	5	23579	8407	2.80468657071488	0.312338722111475	0.312338722111475	false	false	false	true
59fe3b23-a2dc-49d4-a8c8-ba5583a7cbdd	2026-09-24 15:23	2026-09-24 15:23	2026-09-24 15:23	AMZN	AMZN270319P00210000	put	210.0000	2027-03-19	7.3500	7.3000	7.4000	249.5220	48510.00	0.00	47775.00	66	8	166	9909	0.0167524472701584	0.365262517990404	0.365262517990404	false	false	false	true
0c51222e-2345-4a37-ad47-9b7c63484831	2026-09-24 15:21	2026-09-24 15:21	2026-09-24 15:21	AMZN	AMZN261218C00255000	call	255.0000	2026-12-18	15.6500	15.6000	15.8000	249.0000	10955.00	0.00	10955.00	7	5	927	5181	0.178922987840185	0.355012500837832	0.355012500837832	false	false	false	true
b8ff9d64-5218-4cc7-aa07-d1272438c528	2026-09-24 15:20	2026-09-24 15:20	2026-09-24 15:20	AMZN	AMZN270115P00265000	put	265.0000	2027-01-15	26.0500	26.0000	26.1000	249.0000	85965.00	26050.00	10420.00	33	10	449	1969	0.228034535297105	0.344497557626632	0.344038382283691	true	false	false	true
aa18eba1-3091-4148-837b-77f8a469b76b	2026-09-24 15:20	2026-09-24 15:20	2026-09-24 15:20	AMZN	AMZN270115P00265000	put	265.0000	2027-01-15	26.0500	25.9500	26.1000	249.0000	237055.00	237055.00	0.00	91	13	398	1969	0.202133062468258	0.345007015361461	0.345007015361461	false	false	false	true
607421b9-d11c-48d1-85b6-066ccdb3f688	2026-09-24 15:20	2026-09-24 15:20	2026-09-24 15:20	AMZN	AMZN261030P00245000	put	245.0000	2026-10-30	9.5000	9.3000	9.7500	249.0000	96900.00	950.00	73150.00	102	34	284	689	0.412191582002903	0.39201961009972	0.39201961009972	true	false	false	true
650763a6-64f5-41cf-80fe-12b46fa3ba2c	2026-09-24 15:20	2026-09-24 15:20	2026-09-24 15:20	AMZN	AMZN261030P00250000	put	250.0000	2026-10-30	11.8500	11.6500	11.9500	249.0000	84135.00	7110.00	71100.00	71	17	2081	780	2.66794871794872	0.390204555516073	0.390204555516073	true	false	false	true
df84b6ed-360c-4ab7-bc7d-39b1cc8bb685	2026-09-24 15:20	2026-09-24 15:20	2026-09-24 15:20	AMZN	AMZN261030P00250000	put	250.0000	2026-10-30	11.8500	11.6000	12.0000	249.0000	93606.00	49770.00	43836.00	79	37	2010	780	2.57692307692308	0.39005476292582	0.39005476292582	true	false	false	true
5516a407-9f40-4c76-835d-7b39777379b0	2026-09-24 15:20	2026-09-24 15:20	2026-09-24 15:20	AMZN	AMZN261016C00245000	call	245.0000	2026-10-16	10.0000	9.9500	10.1000	249.0000	100002.00	31000.00	53002.00	100	11	1950	3638	0.536008796041781	0.292731797451982	0.293163710276838	false	false	false	true
b55c0560-7d5f-4189-93f3-a66ef56806ee	2026-09-24 15:19	2026-09-24 15:19	2026-09-24 15:19	AMZN	AMZN270115P00265000	put	265.0000	2027-01-15	26.0500	26.0000	26.0500	249.0000	390750.00	390750.00	0.00	150	22	300	1969	0.152361604875571	0.344650476250412	0.344650476250412	false	false	false	true
b3a530ba-6da6-4319-a349-ba152e92a4df	2026-09-24 15:19	2026-09-24 15:19	2026-09-24 15:19	AMZN	AMZN270115P00265000	put	265.0000	2027-01-15	26.0000	25.5000	26.2500	249.0000	390000.00	96200.00	7800.00	150	21	150	1969	0.0761808024377857	0.343533983650704	0.343533983650704	true	false	false	true
5bb5f357-7232-44e0-b21e-b6b7d868957b	2026-09-24 15:18	2026-09-24 15:18	2026-09-24 15:18	AMZN	AMZN261016C00270000	call	270.0000	2026-10-16	1.4900	1.4500	1.4900	249.0000	38144.00	38144.00	0.00	256	7	4073	30185	0.134934570150737	0.3007481976102	0.3007481976102	false	false	false	true
1ce318b5-7b39-4d0b-ba10-ce15ffea7b6c	2026-09-24 15:17	2026-09-24 15:17	2026-09-24 15:17	AMZN	AMZN260925P00250000	put	250.0000	2026-09-25	1.7300	1.7300	1.7700	249.0000	19895.00	0.00	19895.00	115	5	8583	7330	1.17094133697135	0.292508203301721	0.292508203301721	false	false	false	true
0e1ee36d-c73a-4362-b343-e42eb79cda40	2026-09-24 15:14	2026-09-24 15:14	2026-09-24 15:14	AMZN	AMZN280616P00240000	put	240.0000	2028-06-16	32.1500	31.8500	32.2000	249.6800	128600.00	125385.00	0.00	40	5	52	996	0.0522088353413655	0.370228593783375	0.370228593783375	false	false	false	true
d8ed2ce5-3504-46f0-b5ca-6b88ced5579a	2026-09-24 15:05	2026-09-24 15:05	2026-09-24 15:05	AMZN	AMZN261016P00232500	put	232.5000	2026-10-16	1.5100	1.4600	1.5100	249.7200	21442.00	21442.00	0.00	142	7	787	358	2.19832402234637	0.302901265657056	0.302901265657056	false	false	false	true
f4628eef-1a3b-477d-9347-efebd2024e70	2026-09-24 15:05	2026-09-24 15:05	2026-09-24 15:05	AMZN	AMZN260928C00250000	call	250.0000	2026-09-28	2.3800	2.3300	2.3800	249.6900	43316.00	43316.00	0.00	182	9	3911	1344	2.90997023809524	0.237645292182166	0.237645292182166	true	false	false	true
84fc6d8b-404c-4ddc-a0a6-2e9f0b660f50	2026-09-24 15:05	2026-09-24 15:04	2026-09-24 15:04	AMZN	AMZN260928C00250000	call	250.0000	2026-09-28	2.3800	2.2700	2.3800	249.6200	21896.00	21896.00	0.00	92	16	3727	1344	2.77306547619048	0.240935899407746	0.240935899407746	true	false	false	true
57334a3e-9e09-46c2-a6c5-325cf938936f	2026-09-24 15:04	2026-09-24 15:04	2026-09-24 15:04	AMZN	AMZN260928C00250000	call	250.0000	2026-09-28	2.3000	2.2600	2.3200	249.6200	147200.00	147200.00	0.00	640	46	3635	1344	2.7046130952381	0.23558926298149	0.233258232374321	true	false	false	true
c563aaf3-907c-4b99-b849-a4b77fd6e886	2026-09-24 15:04	2026-09-24 15:04	2026-09-24 15:04	AMZN	AMZN260925P00247500	put	247.5000	2026-09-25	0.6800	0.6600	0.6800	249.6301	12920.00	12920.00	0.00	190	6	13491	4429	3.046060058704	0.293152916214099	0.293152916214099	false	false	false	true
0c5c2e5e-461b-4d2d-b5d8-414a559137a1	2026-09-24 15:02	2026-09-24 15:02	2026-09-24 15:02	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	5.3500	5.3500	5.4000	249.8300	10700.00	0.00	10700.00	20	7	2744	65773	0.0417192464993234	0.344175494711467	0.344175494711467	false	false	false	true
6528e6f8-e12b-418e-a961-c73c4e0dc016	2026-09-24 15:01	2026-09-24 15:01	2026-09-24 15:01	AMZN	AMZN261120C00300000	call	300.0000	2026-11-20	2.4100	2.4100	2.4700	249.9300	71818.00	0.00	71818.00	298	13	3124	18191	0.171733274696278	0.379374084288822	0.379374084288822	false	false	false	true
c7494db9-5831-472b-8e16-41dca56900b2	2026-09-24 15:01	2026-09-24 15:00	2026-09-24 15:00	AMZN	AMZN260925C00252500	call	252.5000	2026-09-25	0.7300	0.7200	0.7300	250.0900	14381.00	14381.00	0.00	197	12	22278	8407	2.64993457832758	0.315538501647352	0.315538501647352	true	false	false	true
a7fa9ec9-b4a5-46e9-99bc-e1c5f5c9ae2d	2026-09-24 15:00	2026-09-24 15:00	2026-09-24 15:00	AMZN	AMZN261002C00255000	call	255.0000	2026-10-02	2.3700	2.3300	2.3700	250.0700	31284.00	31284.00	0.00	132	6	3947	4229	0.933317569165287	0.289921392708765	0.289921392708765	false	false	false	true
445f8072-94fe-49dc-a2be-254d1d042f7d	2026-09-24 14:58	2026-09-24 14:58	2026-09-24 14:58	AMZN	AMZN270617C00260000	call	260.0000	2027-06-17	30.1000	30.1000	30.3500	250.2000	42140.00	0.00	42140.00	14	5	151	4862	0.0310571781160016	0.361978999730356	0.361978999730356	false	false	false	true
49ba5bbc-9c9b-46bb-8a60-14a2ebae562c	2026-09-24 14:58	2026-09-24 14:57	2026-09-24 14:57	AMZN	AMZN281215P00220000	put	220.0000	2028-12-15	26.9000	26.7000	27.1500	250.2542	166780.00	153330.00	13450.00	62	13	69	2460	0.0280487804878049	0.372724203992559	0.372724203992559	false	false	false	true
3e415bdf-478e-4e01-a22e-ae32abd7eb36	2026-09-24 14:55	2026-09-24 14:55	2026-09-24 14:55	AMZN	AMZN260925C00250000	call	250.0000	2026-09-25	1.6500	1.6300	1.6500	250.0500	15180.00	15180.00	0.00	92	5	38298	8012	4.78007988017973	0.308594361448065	0.308594361448065	false	false	false	true
865fee24-4a1d-4098-9558-9ff2f9503050	2026-09-24 14:53	2026-09-24 14:53	2026-09-24 14:53	AMZN	AMZN261120C00300000	call	300.0000	2026-11-20	2.4300	2.4300	2.4500	249.9550	20898.00	0.00	20898.00	86	5	2681	18191	0.147380572810731	0.380144534084925	0.380144534084925	false	false	false	true
8e73ba4d-c3de-42f4-9c9c-5a00d748b60b	2026-09-24 14:53	2026-09-24 14:53	2026-09-24 14:53	AMZN	AMZN260925P00250000	put	250.0000	2026-09-25	1.5100	1.5100	1.5300	249.9550	11627.00	0.00	11627.00	77	8	7223	7330	0.985402455661664	0.287598443702719	0.287598443702719	false	false	false	true
3ecd2abb-fbf3-4b8c-ac11-596eb63ff92b	2026-09-24 14:52	2026-09-24 14:52	2026-09-24 14:52	AMZN	AMZN281215P00175000	put	175.0000	2028-12-15	12.4000	12.0500	12.4500	249.9900	54560.00	53320.00	0.00	44	7	94	6110	0.0153846153846154	0.375696275469677	0.375696275469677	false	false	false	true
4a5bfe77-725c-47a0-989b-dacba517cd27	2026-09-24 14:52	2026-09-24 14:52	2026-09-24 14:52	AMZN	AMZN261016P00232500	put	232.5000	2026-10-16	1.4700	1.4700	1.5100	249.9300	17199.00	0.00	17199.00	117	8	605	358	1.68994413407821	0.301834657356024	0.302304891360401	false	false	false	true
c49b583d-f1b3-442c-9cde-0fd8cdf9c6b9	2026-09-24 14:48	2026-09-24 14:47	2026-09-24 14:47	AMZN	AMZN260925P00247500	put	247.5000	2026-09-25	0.6100	0.6000	0.6100	249.0000	15250.00	15250.00	0.00	250	15	12916	4429	2.91623391284714	0.30063318892774	0.2978989823235	true	false	false	true
137e97d4-dc39-46a5-bb66-fa4e03ee1593	2026-09-24 14:47	2026-09-24 14:47	2026-09-24 14:47	AMZN	AMZN261120C00270000	call	270.0000	2026-11-20	7.9000	7.8500	7.9000	249.0000	51350.00	51350.00	0.00	65	5	4594	42415	0.108310739125309	0.376057628207476	0.376057628207476	false	false	false	true
2d55df41-8675-42ad-8ad3-ec723e562847	2026-09-24 14:47	2026-09-24 14:47	2026-09-24 14:47	AMZN	AMZN261120C00270000	call	270.0000	2026-11-20	7.9000	7.8000	7.9000	249.0000	48190.00	48190.00	0.00	61	6	4529	42415	0.106778262407167	0.376199610323142	0.376199610323142	false	false	false	true
ca3d747f-894d-4092-8464-dc735c272111	2026-09-24 14:42	2026-09-24 14:42	2026-09-24 14:42	AMZN	AMZN260925C00252500	call	252.5000	2026-09-25	0.7000	0.7000	0.7200	250.0200	10500.00	0.00	10500.00	150	19	21079	8407	2.50731533246104	0.31322083615907	0.31322083615907	true	false	false	true
c1ef326d-323c-4b51-81a3-d0c2649b0424	2026-09-24 14:40	2026-09-24 14:39	2026-09-24 14:39	AMZN	AMZN261120C00250000	call	250.0000	2026-11-20	15.6000	15.5000	15.6500	250.1200	28080.00	17160.00	0.00	18	6	1574	20122	0.0782228406719014	0.375684843279592	0.375090153008862	true	false	false	true
a0ee38f8-ea8b-42fc-87cb-971493f5a491	2026-09-24 14:39	2026-09-24 14:39	2026-09-24 14:39	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	4.5500	4.5000	4.6500	250.2150	22750.00	19110.00	3640.00	50	12	5900	3611	1.63389642758239	0.293261032791384	0.293261032791384	false	false	false	true
dc9684fa-508e-45f6-8d27-45d22c9981b6	2026-09-24 14:39	2026-09-24 14:39	2026-09-24 14:39	AMZN	AMZN260925C00252500	call	252.5000	2026-09-25	0.8100	0.7900	0.8100	250.2100	16038.00	16038.00	0.00	198	13	20660	8407	2.4574759129297	0.325465520835791	0.325465520835791	false	false	false	true
0f9a1085-8ae1-400a-833f-208775d073ef	2026-09-24 14:38	2026-09-24 14:38	2026-09-24 14:38	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	11.3000	11.1500	11.3000	250.2000	11300.00	11300.00	0.00	10	5	996	14012	0.071081929774479	0.3750804073576	0.3750804073576	false	false	false	true
0f04b67c-4f65-43fb-8c69-50840dc83982	2026-09-24 14:38	2026-09-24 14:38	2026-09-24 14:38	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	7.5000	7.3500	7.5500	250.0500	26246.00	25500.00	746.00	35	6	3562	11560	0.308131487889273	0.293210530082268	0.291572999218834	false	false	false	true
35229794-f31e-45c3-b716-12aaecdd91d9	2026-09-24 14:38	2026-09-24 14:38	2026-09-24 14:38	AMZN	AMZN260928P00247500	put	247.5000	2026-09-28	1.3400	1.3100	1.3400	249.9400	116178.00	116178.00	0.00	867	35	2044	808	2.52970297029703	0.231314940366343	0.231314940366343	false	false	false	true
2020f83f-1569-4ef0-b9f1-0c8c2f02209e	2026-09-24 14:37	2026-09-24 14:36	2026-09-24 14:36	AMZN	AMZN260928C00250000	call	250.0000	2026-09-28	2.4500	2.4400	2.4500	249.9500	10044.00	9800.00	244.00	41	16	2847	1344	2.11830357142857	0.231885520818944	0.231885520818944	false	false	false	true
da44cc03-985e-402e-ba10-e345a00edf24	2026-09-24 14:36	2026-09-24 14:36	2026-09-24 14:36	AMZN	AMZN261007C00245000	call	245.0000	2026-10-07	8.3500	8.0000	8.7000	249.9100	373245.00	326485.00	835.00	447	17	3517	0	0	0.285375843649997	0.285375843649997	false	false	false	true
745ff3a3-01e5-4f40-815b-200ac1da79e6	2026-09-24 14:35	2026-09-24 14:35	2026-09-24 14:35	AMZN	AMZN261023C00260000	call	260.0000	2026-10-23	4.6000	4.5000	4.6500	249.9500	20240.00	1380.00	14260.00	44	6	899	1825	0.492602739726027	0.29431223896825	0.29431223896825	false	false	false	true
1a4d7dff-6c8d-43f2-8f03-7810633060da	2026-09-24 14:35	2026-09-24 14:35	2026-09-24 14:35	AMZN	AMZN260925C00250000	call	250.0000	2026-09-25	1.6000	1.6000	1.6500	249.9350	16000.00	0.00	16000.00	100	8	36645	8012	4.5737643534698	0.310145556209167	0.310145556209167	false	false	false	true
b93ce564-a909-4138-9025-0cdd1f8a0ca4	2026-09-24 14:34	2026-09-24 14:34	2026-09-24 14:34	AMZN	AMZN290119P00200000	put	200.0000	2029-01-19	20.1500	19.8500	20.2000	249.9401	112840.00	102765.00	0.00	56	13	65	335	0.194029850746269	0.373007403187924	0.373007403187924	false	false	false	true
f5c119e6-8336-40a0-b8f8-73430f7fd5e8	2026-09-24 14:33	2026-09-24 14:33	2026-09-24 14:33	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	7.4500	7.4000	7.4500	249.9900	11175.00	11175.00	0.00	15	8	3501	11560	0.302854671280277	0.292460800673823	0.292460800673823	false	false	false	true
28a74c88-2dd4-47e7-8023-a8dfa1aa9677	2026-09-24 14:33	2026-09-24 14:33	2026-09-24 14:33	AMZN	AMZN270219C00350000	call	350.0000	2027-02-19	2.6400	2.4700	2.6400	249.9900	37752.00	37752.00	0.00	143	12	153	2101	0.0728224654926226	0.364973128393163	0.364973128393163	false	false	false	true
33c08a9b-ca38-4beb-b47f-3db93ddda3e1	2026-09-24 14:24	2026-09-24 14:24	2026-09-24 14:24	AMZN	AMZN261120C00280000	call	280.0000	2026-11-20	5.3000	5.3000	5.3500	249.6850	31800.00	0.00	31800.00	60	12	1243	11892	0.104524049781366	0.375198163706838	0.375198163706838	false	false	false	true