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

49472f69-1971-408e-88c7-0c6eb14cf4cb	2026-09-30 11:43	2026-09-30 11:43	2026-09-30 11:43	AMZN	AMZN261120P00250000	put	250.0000	2026-11-20	12.9500	12.7500	12.9500	251.0000	23310.00	23310.00	0.00	18	6	211	22201	0.00950407639295527	0.38089539286607	0.38089539286607	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2660659968805.00	2026-10-29	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T15:45:01.724605Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
5e1bc5b1-96de-42f1-bb2f-e947708d2fb1	2026-09-30 11:43	2026-09-30 11:43	2026-09-30 11:43	AMZN	AMZN261016P00245000	put	245.0000	2026-10-16	3.4000	3.3000	3.4500	251.0000	20400.00	14620.00	0.00	60	10	413	14036	0.0294243374180678	0.296389991191815	0.296389991191815	true	false	false	true
464da600-0dbe-40da-aafe-44e484760a4b	2026-09-30 11:42	2026-09-30 11:42	2026-09-30 11:42	AMZN	AMZN261218C00315000	call	315.0000	2026-12-18	2.1200	2.0600	2.1200	251.0000	22048.00	22048.00	0.00	104	8	227	5132	0.04423226812159	0.358393868039697	0.358393868039697	false	false	false	true
27ae23e6-4dfe-4a3f-b49c-d46b531d2d38	2026-09-30 11:42	2026-09-30 11:42	2026-09-30 11:42	AMZN	AMZN261120C00270000	call	270.0000	2026-11-20	7.6500	7.5500	7.6500	251.0000	23715.00	23715.00	0.00	31	6	1433	29021	0.0493780365941904	0.37925608554532	0.37925608554532	false	false	false
3b693db3-ebfa-4b28-8649-6e825039d793	2026-09-30 11:42	2026-09-30 11:42	2026-09-30 11:42	AMZN	AMZN261005C00252500	call	252.5000	2026-10-05	2.6800	2.6000	2.6800	251.0000	12060.00	12060.00	0.00	45	5	2229	848	2.62853773584906	0.275276184388079	0.274504341273998	false	false	false	true
c25712ff-d54e-4755-8e8b-61aa0ff8c358	2026-09-30 11:42	2026-09-30 11:42	2026-09-30 11:42	AMZN	AMZN270115P00260000	put	260.0000	2027-01-15	21.9000	21.6500	21.9500	251.0000	50370.00	50370.00	0.00	23	5	33	6764	0.00487876995860438	0.346399519868067	0.346399519868067	false	false	false
3876d04e-4f35-4072-971d-b12babdb16fd	2026-09-30 11:42	2026-09-30 11:42	2026-09-30 11:42	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	2.9300	2.9300	2.9800	251.0000	14963.00	0.00	14963.00	51	7	4653	35943	0.129454970369752	0.293630757194169	0.293363529772067	true	false	false
43494228-35ad-4c3e-b291-24231c76c0c4	2026-09-30 11:41	2026-09-30 11:41	2026-09-30 11:41	AMZN	AMZN260930P00250000	put	250.0000	2026-09-30	0.3200	0.3100	0.3200	251.0000	14400.00	14400.00	0.00	450	5	34721	4255	8.16004700352526	0.377105844011587	0.377105844011587	false	false	false	true
cb27b1ef-0f96-4c6a-a2af-c3249c2c8d52	2026-09-30 11:40	2026-09-30 11:40	2026-09-30 11:40	AMZN	AMZN261002P00250000	put	250.0000	2026-10-02	1.9500	1.9500	1.9800	251.0000	16770.00	0.00	16770.00	86	7	4976	5994	0.830163496830164	0.345113006135996	0.345113006135996	true	false	false	true
1a63a6b7-2161-4032-af07-ac5a54ab7097	2026-09-30 11:40	2026-09-30 11:40	2026-09-30 11:40	AMZN	AMZN270115P00240000	put	240.0000	2027-01-15	12.0500	12.0000	12.1500	251.0000	10845.00	4820.00	6025.00	9	6	350	6972	0.0502008032128514	0.348166718756146	0.348166718756146	false	false	false
4a75fafa-bed6-4c8f-934c-664dc960d5fd	2026-09-30 11:38	2026-09-30 11:38	2026-09-30 11:38	AMZN	AMZN261002P00262500	put	262.5000	2026-10-02	11.4000	11.0500	11.4000	251.3500	22790.00	22790.00	0.00	20	6	507	150	3.38	0.422805152761983	0.422805152761983	false	false	false	true
9081fee4-37a5-4a46-b90e-5071d0a50542	2026-09-30 11:38	2026-09-30 11:38	2026-09-30 11:38	AMZN	AMZN261002P00260000	put	260.0000	2026-10-02	8.8500	8.8500	9.0000	251.3900	17700.00	0.00	17700.00	20	7	463	1130	0.409734513274336	0.347054024731653	0.347054024731653	false	false	false	true
7f767d52-3c0b-46f9-9ead-f770ab56d2ae	2026-09-30 11:36	2026-09-30 11:36	2026-09-30 11:36	AMZN	AMZN261009P00230000	put	230.0000	2026-10-09	0.2500	0.2400	0.2600	251.4400	12150.00	10825.00	0.00	486	23	658	1283	0.512860483242401	0.342181030485389	0.342306872057618	false	false	false	true
cf7faa43-8859-48c7-9d16-6b6b24f3d723	2026-09-30 11:35	2026-09-30 11:35	2026-09-30 11:35	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	7.0900	7.0000	7.3000	251.4100	14180.00	0.00	14180.00	20	5	2644	3740	0.706951871657754	0.371020577700875	0.371020577700875	false	false	false
59fe0920-768a-4f6e-8c0a-9ce93e9f3260	2026-09-30 11:33	2026-09-30 11:33	2026-09-30 11:33	AMZN	AMZN261016C00255000	call	255.0000	2026-10-16	4.9000	4.8000	4.9000	251.5600	37240.00	37240.00	0.00	76	10	4940	11313	0.436665782727835	0.297239244302026	0.297239244302026	false	false	false
c18ff31d-0444-4b4f-bae2-a5384b40d406	2026-09-30 11:29	2026-09-30 11:29	2026-09-30 11:29	AMZN	AMZN261218C00290000	call	290.0000	2026-12-18	5.2800	5.1000	5.3500	251.4800	35379.00	35379.00	0.00	67	5	1111	5807	0.191320819700362	0.35559813608016	0.35559813608016	false	false	false	true
de83e56c-2cc1-4aed-af41-00bc0119e6e1	2026-09-30 11:28	2026-09-30 11:28	2026-09-30 11:28	AMZN	AMZN270319C00260000	call	260.0000	2027-03-19	23.0000	22.8000	23.1500	251.4100	18400.00	13800.00	4600.00	8	6	59	4002	0.0147426286856572	0.358554657658906	0.358554657658906	false	false	false
e99632a6-58d6-425e-84ab-275d4b789ec4	2026-09-30 11:26	2026-09-30 11:26	2026-09-30 11:26	AMZN	AMZN260930P00250000	put	250.0000	2026-09-30	0.4000	0.3900	0.4000	251.1900	10760.00	10760.00	0.00	269	11	29907	4255	7.02867215041128	0.381679489761008	0.381679489761008	true	false	false	true
8310a74d-7ddc-48d7-bbd9-f76cbf06a47f	2026-09-30 11:26	2026-09-30 11:26	2026-09-30 11:26	AMZN	AMZN270115P00230000	put	230.0000	2027-01-15	8.5000	8.5000	8.5500	251.3600	104550.00	0.00	104550.00	123	7	132	9927	0.0132970686007857	0.351014640979626	0.351014640979626	false	false	false
f28f6d72-5745-4777-9bb6-63f290a5ac2e	2026-09-30 11:26	2026-09-30 11:26	2026-09-30 11:26	AMZN	AMZN260930P00250000	put	250.0000	2026-09-30	0.3500	0.3300	0.3500	251.3700	14942.00	14942.00	0.00	427	14	28877	4255	6.78660399529965	0.381338175382233	0.381126480693962	true	false	false	true
179d1e81-3147-4707-b3d2-dd43b61c265a	2026-09-30 11:25	2026-09-30 11:25	2026-09-30 11:25	AMZN	AMZN261218P00260000	put	260.0000	2026-12-18	20.1500	19.9500	20.2500	251.5803	30225.00	30225.00	0.00	15	7	67	6312	0.0106147021546261	0.359562742970754	0.359341672026136	true	false	false	true
3e1cbba6-0058-421a-ad9e-b6fa229681eb	2026-09-30 11:25	2026-09-30 11:25	2026-09-30 11:25	AMZN	AMZN270115P00240000	put	240.0000	2027-01-15	11.9500	11.9000	12.0500	251.6800	10755.00	2390.00	7170.00	9	7	271	6972	0.0388697647733792	0.348385210103175	0.348623535581563	false	false	false
f1983a16-294b-4b9e-a933-bb5b509523f1	2026-09-30 11:24	2026-09-30 11:24	2026-09-30 11:24	AMZN	AMZN261002C00255000	call	255.0000	2026-10-02	1.4000	1.4000	1.4200	251.6900	24500.00	0.00	24500.00	175	5	18545	14814	1.25185635209937	0.364041420220876	0.364041420220876	false	false	false
3e3952af-ff4f-4261-9806-aa0b59f1aec5	2026-09-30 11:23	2026-09-30 11:23	2026-09-30 11:23	AMZN	AMZN261023P00240000	put	240.0000	2026-10-23	2.8700	2.8700	3.1000	251.6400	36162.00	0.00	36162.00	126	8	259	3318	0.0780590717299578	0.303002948615933	0.303002948615933	false	false	false	true
5b2ad3b9-86ed-47bd-a45c-284872aebbe1	2026-09-30 11:21	2026-09-30 11:21	2026-09-30 11:21	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.5500	0.5200	0.5600	251.6450	11705.00	280.00	11371.00	213	14	66176	10577	6.25659449749456	0.394338181010066	0.380413727447227	true	false	false
4a408219-8919-46b1-9c16-606bd90099b4	2026-09-30 11:20	2026-09-30 11:20	2026-09-30 11:20	AMZN	AMZN260930P00252500	put	252.5000	2026-09-30	1.3100	1.3100	1.3500	251.7500	50700.00	134.00	50566.00	387	6	6442	1132	5.69081272084806	0.402617229011859	0.383312360542149	false	false	false
36711fab-81b6-459f-a46d-7da736bd2626	2026-09-30 11:20	2026-09-30 11:20	2026-09-30 11:20	AMZN	AMZN270416C00270000	call	270.0000	2027-04-16	21.1000	21.0500	21.3000	251.7500	308060.00	244760.00	63300.00	146	16	155	862	0.179814385150812	0.351298354746462	0.351298354746462	false	false	false
08fe2f03-32e9-4caf-8553-c42f4469ca2e	2026-09-30 11:20	2026-09-30 11:20	2026-09-30 11:20	AMZN	AMZN261016P00250000	put	250.0000	2026-10-16	5.0500	4.9500	5.1000	251.9850	57570.00	57065.00	505.00	114	5	737	14444	0.0510246469122127	0.295478237225246	0.295478237225246	false	false	false
7864993e-d6d6-4e2d-9b34-206348d8160d	2026-09-30 11:18	2026-09-30 11:18	2026-09-30 11:18	AMZN	AMZN270319C00250000	call	250.0000	2027-03-19	28.2000	27.7500	28.4500	252.1100	36660.00	36660.00	0.00	13	5	117	5890	0.0198641765704584	0.362514736050984	0.362514736050984	false	false	false
603f0a59-271e-4e51-80ad-e6728de5c8f0	2026-09-30 11:18	2026-09-30 11:18	2026-09-30 11:18	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	11.4500	11.4000	11.6000	252.1050	13740.00	1145.00	12595.00	12	9	1211	32795	0.0369263607257204	0.379006749003195	0.379006749003195	false	false	false
598bd8b0-636f-46c6-9050-1288808f27c3	2026-09-30 11:17	2026-09-30 11:17	2026-09-30 11:17	AMZN	AMZN260930P00252500	put	252.5000	2026-09-30	1.0900	1.0400	1.1000	252.2850	11112.00	11006.00	0.00	102	10	5520	1132	4.87632508833922	0.40734485266059	0.420247569393931	false	false	false	true
c55b3f55-97a6-4f62-a487-6de95597bc20	2026-09-30 11:16	2026-09-30 11:16	2026-09-30 11:16	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	2.5800	2.5100	2.5800	252.3550	12900.00	12900.00	0.00	50	6	39416	9228	4.27134807108799	0.420607649483927	0.420607649483927	false	false	false
6fbe96e1-5071-477c-a3b6-a98fb58dd757	2026-09-30 11:16	2026-09-30 11:16	2026-09-30 11:16	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	2.5500	2.4800	2.5600	252.3500	15806.00	15806.00	0.00	62	5	39357	9228	4.2649544863459	0.392116080360737	0.409647670768513	false	false	false
05cc9c86-d4fd-4c8c-b2f0-9cf32bd8b561	2026-09-30 11:16	2026-09-30 11:16	2026-09-30 11:16	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.8600	0.8500	0.8700	252.3500	11275.00	4051.00	0.00	131	5	64120	10577	6.06221045665122	0.397857275747447	0.402141335518694	false	false	false
c748ca4d-6c7b-477b-865b-94531c807a0e	2026-09-30 11:16	2026-09-30 11:16	2026-09-30 11:16	AMZN	AMZN270115P00270000	put	270.0000	2027-01-15	27.5000	27.5000	28.1000	252.2200	27500.00	0.00	27500.00	10	8	10	3838	0.00260552371026576	0.347877258285278	0.347877258285278	false	false	false
ae1ba8ca-9f23-45a2-8e98-3660d0d4191f	2026-09-30 11:16	2026-09-30 11:16	2026-09-30 11:16	AMZN	AMZN261002C00255000	call	255.0000	2026-10-02	1.5500	1.5100	1.5500	252.0600	15965.00	15965.00	0.00	103	7	17909	14814	1.2089239908195	0.368032346393723	0.368032346393723	false	false	false
40831d05-87a8-44d3-a58a-1567e1037574	2026-09-30 11:16	2026-09-30 11:16	2026-09-30 11:16	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.7000	0.6800	0.7200	252.0400	16800.00	16520.00	140.00	240	13	63148	10577	5.97031294317859	0.392728334667151	0.388683624902398	false	false	false
30a36454-d9f7-4477-ae60-a511a7f5c4e8	2026-09-30 11:16	2026-09-30 11:16	2026-09-30 11:16	AMZN	AMZN261002C00252500	call	252.5000	2026-10-02	2.5400	2.4500	2.5400	252.0600	27940.00	27940.00	0.00	110	17	13229	6559	2.01692331148041	0.366188687085382	0.366188687085382	false	false	false
e1b13bd4-caad-4bb8-9d97-089c77f5e63e	2026-09-30 11:13	2026-09-30 11:12	2026-09-30 11:12	AMZN	AMZN260930P00252500	put	252.5000	2026-09-30	1.4700	1.4300	1.5000	251.5600	19499.00	146.00	19353.00	133	5	5020	1132	4.43462897526502	0.395342599159428	0.39072569196185	false	false	false	true
000012f9-2ef0-4ff8-b03c-a752fc95698a	2026-09-30 11:12	2026-09-30 11:12	2026-09-30 11:12	AMZN	AMZN260930P00252500	put	252.5000	2026-09-30	1.3200	1.3200	1.3800	251.7400	11880.00	0.00	11880.00	90	12	4788	1132	4.22968197879859	0.379437915945155	0.379448823655561	false	false	false	true
9bef134e-872c-4de7-8ef0-2d153534d565	2026-09-30 11:12	2026-09-30 11:12	2026-09-30 11:12	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	18.7500	18.6000	19.0000	251.6500	24375.00	1875.00	22500.00	13	9	536	14280	0.0375350140056022	0.360948387891472	0.360948387891472	false	false	false
d0c62a94-36fc-4ea2-b166-7a65c65db321	2026-09-30 11:12	2026-09-30 11:12	2026-09-30 11:12	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	1.9400	1.9000	1.9600	251.6100	38917.00	38529.00	388.00	201	9	38684	9228	4.19202427394885	0.377511311494215	0.384778127417506	false	false	false
3cfce2f4-9148-4769-a2ec-dafcfca954a1	2026-09-30 11:11	2026-09-30 11:11	2026-09-30 11:11	AMZN	AMZN270115C00245000	call	245.0000	2027-01-15	23.9500	23.9000	24.1500	251.6701	1046620.00	2400.00	1044220.00	437	25	552	3491	0.158120882268691	0.350940612317671	0.351903466867335	false	false	false
d3de36e2-fc3e-4694-84b0-28d72ec01062	2026-09-30 11:11	2026-09-30 11:11	2026-09-30 11:11	AMZN	AMZN261030P00255000	put	255.0000	2026-10-30	12.9000	12.9000	12.9500	251.7350	19350.00	0.00	19350.00	15	5	46	710	0.0647887323943662	0.402928513838893	0.402928513838893	true	false	false	true
d216711f-1656-427d-ab67-94a42c28be8e	2026-09-30 11:11	2026-09-30 11:11	2026-09-30 11:11	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	1.9700	1.9700	2.0300	251.7200	22120.00	0.00	21920.00	112	12	38361	9228	4.15702210663199	0.37574962077103	0.358132165791114	true	false	false
ac4c542a-ed03-41fe-93b4-7385eb07b109	2026-09-30 11:11	2026-09-30 11:11	2026-09-30 11:11	AMZN	AMZN261009C00252500	call	252.5000	2026-10-09	4.5100	4.5000	4.7000	251.8500	54100.00	0.00	54100.00	120	7	799	869	0.919447640966628	0.297476900295448	0.300646217715049	false	false	false
fd966eaa-2925-4318-801c-33592a4a73f4	2026-09-30 11:10	2026-09-30 11:10	2026-09-30 11:10	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.6600	0.6400	0.6700	251.8400	13853.00	0.00	13528.00	210	7	59353	10577	5.61151555261416	0.399756765627011	0.398827065639477	true	false	false
e6ed8c2f-8955-40cb-8aef-317b256c20d6	2026-09-30 11:10	2026-09-30 11:10	2026-09-30 11:10	AMZN	AMZN261120C00250000	call	250.0000	2026-11-20	16.0000	15.9000	16.2000	251.8600	48000.00	0.00	48000.00	30	5	1487	21897	0.0679088459606339	0.38308158906213	0.38308158906213	false	false	false
24742aea-139c-4c46-a06e-47e68576c08a	2026-09-30 11:10	2026-09-30 11:10	2026-09-30 11:10	AMZN	AMZN261218C00265000	call	265.0000	2026-12-18	12.2400	12.2000	12.4000	252.0300	122392.00	0.00	122392.00	100	12	186	5900	0.0315254237288136	0.355444525193947	0.356528021734581	false	false	false
9213f0d7-8679-476f-bb62-26ca1bd222a4	2026-09-30 11:10	2026-09-30 11:10	2026-09-30 11:10	AMZN	AMZN261120C00275000	call	275.0000	2026-11-20	6.5000	6.4500	6.5000	251.9725	80600.00	80600.00	0.00	124	6	873	10605	0.0823196605374823	0.378671253020621	0.378671253020621	true	false	false