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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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

e626ee22-cc6a-4923-b680-c6a23995f800	2026-09-28 14:59	2026-09-28 14:59	2026-09-28 14:59	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.8100	1.7900	1.8100	246.5150	17557.00	17557.00	0.00	97	16	10340	810	12.7654320987654	0.30774342233829	0.30774342233829	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2655051085748.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T19:00:50.307488Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
de4d5ad7-116f-4ad7-8771-c2df2d65e3c9	2026-09-28 14:59	2026-09-28 14:59	2026-09-28 14:59	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.8000	1.7700	1.8000	246.5150	18540.00	18540.00	0.00	103	17	10243	810	12.6456790123457	0.306353306400682	0.306353306400682	true	false	false	true
a1b40599-0615-4403-8ddf-5da2cb445ae1	2026-09-28 14:59	2026-09-28 14:59	2026-09-28 14:59	AMZN	AMZN261016C00275000	call	275.0000	2026-10-16	0.4800	0.4800	0.4900	246.5200	11664.00	0.00	11664.00	243	22	1947	36084	0.0539574326571334	0.313217888528056	0.313217888528056	true	false	false	true
5666f634-641f-4d94-8736-f495c11f0b4e	2026-09-28 14:58	2026-09-28 14:58	2026-09-28 14:58	AMZN	AMZN270917P00245000	put	245.0000	2027-09-17	27.6800	27.3500	28.2000	246.5500	1384000.00	0.00	1384000.00	500	2	503	193	2.60621761658031	0.354894430271088	0.354894430271088	false	true	false	true
3d703de3-84cb-4615-9df9-ef48cde545b4	2026-09-28 14:56	2026-09-28 14:56	2026-09-28 14:56	AMZN	AMZN261120C00250000	call	250.0000	2026-11-20	13.0500	13.0000	13.1500	246.6400	33930.00	5220.00	23490.00	26	6	974	20998	0.0463853700352415	0.371002652651048	0.371002652651048	false	false	false	true
c4baa2f5-f047-4b1b-b01b-a2afc9e8c297	2026-09-28 14:55	2026-09-28 14:55	2026-09-28 14:55	AMZN	AMZN261023C00250000	call	250.0000	2026-10-23	6.2500	6.2500	6.4000	246.6700	41875.00	0.00	41875.00	67	11	1031	1719	0.599767306573589	0.289572170114875	0.289572170114875	false	false	false	true
e4aa1303-a59d-4272-b102-17f808a27ba0	2026-09-28 14:54	2026-09-28 14:54	2026-09-28 14:54	AMZN	AMZN261120C00320000	call	320.0000	2026-11-20	0.7300	0.7300	0.7600	246.6800	33434.00	0.00	33434.00	458	11	18084	24415	0.740692197419619	0.388843271521886	0.388843271521886	false	false	false	true
89bb875d-bd9b-41e5-8e7a-9da234a0be99	2026-09-28 14:54	2026-09-28 14:54	2026-09-28 14:54	AMZN	AMZN261120C00310000	call	310.0000	2026-11-20	1.1200	1.1200	1.1500	246.6800	115024.00	0.00	115024.00	1027	32	1181	7397	0.159659321346492	0.383405670347061	0.383405670347061	false	false	false	true
4a62cbab-1e4d-4c05-8acb-86d2c1fc77c8	2026-09-28 14:53	2026-09-28 14:53	2026-09-28 14:53	AMZN	AMZN270416P00210000	put	210.0000	2027-04-16	8.4000	8.4000	8.5000	246.7241	17640.00	0.00	17640.00	21	11	1026	993	1.03323262839879	0.35695701597721	0.35695701597721	false	false	false	true
45aec8c9-7cbd-4c65-bcbf-34a167bb7082	2026-09-28 14:53	2026-09-28 14:53	2026-09-28 14:53	AMZN	AMZN270416P00185000	put	185.0000	2027-04-16	3.7500	3.7500	3.8000	246.7250	17625.00	0.00	17625.00	47	11	148	266	0.556390977443609	0.373691465804147	0.373691465804147	false	false	false	true
fbbdb344-553e-467c-8997-19b1ac4a2b5f	2026-09-28 14:53	2026-09-28 14:52	2026-09-28 14:52	AMZN	AMZN270416C00300000	call	300.0000	2027-04-16	10.5000	10.4000	10.5000	246.7100	25200.00	25200.00	0.00	24	5	290	679	0.427098674521355	0.348498911505309	0.348498911505309	true	false	false	true
ceb6036d-8b3b-4bca-8313-115e1305735f	2026-09-28 14:53	2026-09-28 14:52	2026-09-28 14:52	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.9600	1.9400	1.9600	246.6900	37044.00	37044.00	0.00	189	27	10549	11289	0.934449464080078	0.31991333101583	0.31991333101583	true	false	false	true
6bc22633-8c0c-43fe-9e71-8d12d3f19452	2026-09-28 14:53	2026-09-28 14:52	2026-09-28 14:52	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.9100	1.8800	1.9100	246.6900	38200.00	38200.00	0.00	200	20	9926	810	12.2543209876543	0.310803745377402	0.310803745377402	true	false	false	true
f098c2e5-7f18-40a1-9e05-96a88a4caf77	2026-09-28 14:52	2026-09-28 14:52	2026-09-28 14:52	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.9200	1.8600	1.9200	246.7250	57600.00	57600.00	0.00	300	41	9725	810	12.0061728395062	0.309995152235488	0.309995152235488	true	false	false	true
d2840a33-bfc7-4abd-82a7-90ff4f10e904	2026-09-28 14:52	2026-09-28 14:52	2026-09-28 14:52	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.9000	1.8500	1.9000	246.6950	28500.00	28500.00	0.00	150	22	9425	810	11.6358024691358	0.309108618082364	0.309108618082364	true	false	false	true
229613c0-f770-4abc-bd72-cec341a70d0a	2026-09-28 14:52	2026-09-28 14:51	2026-09-28 14:51	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.9300	1.9200	1.9500	246.6300	45741.00	10036.00	35705.00	237	8	10325	11289	0.914607139693507	0.319007340961948	0.319007340961948	false	false	false	true
3e952b3e-e54c-4fa3-96fd-bfe240c0ceb3	2026-09-28 14:48	2026-09-28 14:47	2026-09-28 14:47	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	4.3500	4.3000	4.4000	246.8350	43935.00	0.00	1740.00	101	6	1506	67339	0.0223644544766035	0.340495882070812	0.340495882070812	false	false	false	true
f8269453-582b-495f-a25c-0dfe8a0bdfe9	2026-09-28 14:47	2026-09-28 14:47	2026-09-28 14:47	AMZN	AMZN261030P00245000	put	245.0000	2026-10-30	9.9000	9.8000	9.9000	246.8300	17820.00	17820.00	0.00	18	5	387	861	0.449477351916376	0.387367874860396	0.386911319844205	false	false	false	true
62334c51-84df-405f-a417-320add4662a6	2026-09-28 14:45	2026-09-28 14:45	2026-09-28 14:45	AMZN	AMZN270319P00210000	put	210.0000	2027-03-19	7.5500	7.5000	7.6500	246.8900	12839.00	755.00	12084.00	17	14	133	10806	0.0123079770497872	0.362497675749357	0.362497675749357	false	false	false	true
feb7e09a-7406-4902-80f4-0ce1473e8242	2026-09-28 14:44	2026-09-28 14:44	2026-09-28 14:44	AMZN	AMZN261030P00245000	put	245.0000	2026-10-30	9.8500	9.8500	9.9000	246.9060	166465.00	0.00	166465.00	169	21	347	861	0.403019744483159	0.386331531618154	0.386331531618154	false	false	false	true
5b064e57-f474-442d-8367-b0c0c82dd4ca	2026-09-28 14:44	2026-09-28 14:44	2026-09-28 14:44	AMZN	AMZN261030P00200000	put	200.0000	2026-10-30	0.6300	0.6300	0.6800	246.9060	10647.00	0.00	10647.00	169	29	208	695	0.299280575539568	0.444105530339892	0.444105530339892	false	false	false	true
0ce2b7f4-a2fc-4fbd-b054-4d868b6d382e	2026-09-28 14:42	2026-09-28 14:42	2026-09-28 14:42	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.3900	1.3900	1.4300	246.0000	14595.00	0.00	14595.00	105	8	4813	1489	3.23237071860309	0.306341423621095	0.306341423621095	false	false	false	true
a7314adc-b6e0-4be9-bebd-8ee49e8b950f	2026-09-28 14:42	2026-09-28 14:41	2026-09-28 14:41	AMZN	AMZN270319P00210000	put	210.0000	2027-03-19	7.6000	7.4000	7.6500	246.0000	10640.00	5320.00	5320.00	14	9	116	10806	0.0107347769757542	0.363396901370742	0.363396901370742	false	false	false	true
5e8c29d9-befb-4a03-992c-d539611927cf	2026-09-28 14:41	2026-09-28 14:41	2026-09-28 14:41	AMZN	AMZN270319P00190000	put	190.0000	2027-03-19	3.8500	3.8500	3.9500	246.0000	71255.00	0.00	71255.00	185	32	427	6324	0.0675205566097407	0.376566953636379	0.376566953636379	false	false	false	true
1f667e38-e32f-492e-9995-175d77510591	2026-09-28 14:41	2026-09-28 14:41	2026-09-28 14:41	AMZN	AMZN270319P00210000	put	210.0000	2027-03-19	7.6000	7.5500	7.6500	246.0000	10640.00	0.00	9880.00	14	13	98	10806	0.0090690357208958	0.363229454566401	0.363229454566401	false	false	false	true
9c5303c5-379d-4cc6-aebc-011e7139e2c9	2026-09-28 14:41	2026-09-28 14:41	2026-09-28 14:41	AMZN	AMZN261002C00260000	call	260.0000	2026-10-02	0.3100	0.3000	0.3100	246.0000	17391.00	17360.00	0.00	561	31	16717	10314	1.62080667054489	0.343655125685364	0.343655125685364	false	false	false	true
5039f887-a28b-42bc-ba33-c0957ae3b126	2026-09-28 14:41	2026-09-28 14:41	2026-09-28 14:41	AMZN	AMZN261002C00255000	call	255.0000	2026-10-02	0.7800	0.7500	0.7800	246.0000	13572.00	13572.00	0.00	174	23	7311	10884	0.671719955898567	0.323786985877539	0.323786985877539	false	false	false	true
5c41ca7b-31b5-4d05-b396-47e0dd383e11	2026-09-28 14:39	2026-09-28 14:39	2026-09-28 14:39	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.4500	24.7500	246.0000	234650.00	200070.00	32110.00	95	20	1595	2073	0.769416304872166	0.360177362638743	0.360177362638743	true	false	false	true
f97444e2-8409-4193-aea9-48f93046acba	2026-09-28 14:39	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN261120P00265000	put	265.0000	2026-11-20	24.2500	24.1500	24.4000	246.0000	21825.00	19400.00	2425.00	9	5	80	6548	0.0122174709835064	0.373339359407941	0.373339359407941	false	false	false	true
b558215f-f110-4e4b-ab86-b220206391d3	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.5000	24.7500	246.0000	106210.00	2470.00	103740.00	43	5	1368	2073	0.659913169319826	0.360197299926451	0.360197299926451	false	false	false	true
c7d10ff3-24dd-41e6-878c-42f9fdde03fe	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.4500	24.7500	246.6950	456947.00	350737.00	106210.00	185	22	1325	2073	0.639170284611674	0.360237174898342	0.360237174898342	true	false	false	true
3f344e3c-c73b-487a-8554-2db1a10a16be	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.7000	24.7500	246.6950	172900.00	0.00	172900.00	70	6	1056	2073	0.509406657018813	0.360237174898342	0.360237174898342	false	false	false	true
2e6e5462-a268-4410-b16f-5630b97ad94e	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.7000	24.7500	246.6950	207480.00	0.00	207480.00	84	8	1140	2073	0.549927641099855	0.360237174898342	0.360237174898342	false	false	false	true
f4f08206-edc5-4dc5-8228-b1f147e94c9a	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.4500	25.1500	246.7000	321097.00	66687.00	254410.00	130	31	136	2073	0.0656054027978775	0.360217237346302	0.360217237346302	true	false	false	true
f1c1d67c-dc37-4b56-9377-a13a8e56fd76	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.7000	24.8000	246.7000	815100.00	0.00	815100.00	330	7	466	2073	0.224794983116257	0.360217237346302	0.360217237346302	false	false	false	true
33a6d212-31eb-48c1-ad6b-01839a00f378	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	1.0000	1.0000	1.0200	246.7400	10000.00	0.00	10000.00	100	7	7766	1348	5.76112759643917	0.306580966105893	0.306580966105893	false	false	false	true
79237f9a-b91e-45b6-98dc-f0060b1a8e84	2026-09-28 14:36	2026-09-28 14:36	2026-09-28 14:36	AMZN	AMZN261002P00257500	put	257.5000	2026-10-02	11.1000	10.7000	11.3000	246.7500	11100.00	11100.00	0.00	10	7	943	457	2.06345733041575	0.329366955819409	0.329366955819409	false	false	false	true
01ab8c71-48ea-4d51-93d4-474cb4402403	2026-09-28 14:36	2026-09-28 14:36	2026-09-28 14:36	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	2.0200	2.0200	2.0600	246.7400	10100.00	0.00	10100.00	50	9	5741	34706	0.165418083328531	0.289910174771606	0.289910174771606	false	false	false	true
51d4145d-0f94-45df-9c28-5502865dadff	2026-09-28 14:34	2026-09-28 14:34	2026-09-28 14:34	AMZN	AMZN261002C00255000	call	255.0000	2026-10-02	0.7800	0.7800	0.7900	246.7500	72384.00	0.00	72228.00	928	55	7065	10884	0.649117971334068	0.325627708256272	0.325627708256272	false	false	false	true
785ffb33-3940-472a-8596-b526c4696bdb	2026-09-28 14:31	2026-09-28 14:31	2026-09-28 14:31	AMZN	AMZN260930P00247500	put	247.5000	2026-09-30	2.6700	2.5900	2.6700	246.6300	17889.00	17889.00	0.00	67	16	2249	1818	1.23707370737074	0.30689189614779	0.30689189614779	true	false	false	true
d4065f75-86c0-411b-a03d-0c9a366a9537	2026-09-28 14:31	2026-09-28 14:31	2026-09-28 14:31	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.4800	1.4100	1.4900	246.7056	10508.00	10064.00	444.00	71	21	4582	1489	3.07723304231028	0.310129779941888	0.310129779941888	true	false	false	true
f160f272-8c76-471a-b99c-2a0b8630af07	2026-09-28 14:30	2026-09-28 14:30	2026-09-28 14:30	AMZN	AMZN260930P00247500	put	247.5000	2026-09-30	2.6400	2.5500	2.6600	246.6726	12671.00	12407.00	264.00	48	16	2176	1818	1.1969196919692	0.308074867334486	0.305993094029622	true	false	false	true
e330ecfc-607f-4562-acd2-8774be16bf26	2026-09-28 14:30	2026-09-28 14:30	2026-09-28 14:30	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.4500	1.4100	1.4500	246.7300	11890.00	11890.00	0.00	82	20	4477	1489	3.00671591672263	0.307099788282577	0.307099788282577	true	false	false	true
34259b22-8284-4821-8c60-dbc4364f157f	2026-09-28 14:30	2026-09-28 14:30	2026-09-28 14:30	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.4100	2.3500	2.4300	246.7300	11086.00	11086.00	0.00	46	9	3018	4018	0.751119960179194	0.316281572296829	0.316281572296829	false	false	false	true
fe011fd5-f261-4e52-af22-61f29c3736e2	2026-09-28 14:29	2026-09-28 14:28	2026-09-28 14:28	AMZN	AMZN260928P00247500	put	247.5000	2026-09-28	0.7200	0.6800	0.7200	246.9500	27360.00	27360.00	0.00	380	27	14760	2151	6.86192468619247	0.296903527536469	0.296903527536469	false	false	false	true
48104da0-88ba-4165-b9ef-8efd77c6239a	2026-09-28 14:22	2026-09-28 14:21	2026-09-28 14:21	AMZN	AMZN260928P00247500	put	247.5000	2026-09-28	0.7200	0.7200	0.7800	246.9300	11664.00	0.00	11664.00	162	5	13863	2151	6.44490934449093	0.273402675755309	0.273402675755309	false	false	false	true
fb2b9f39-9853-4c28-886f-2d5282f50ff1	2026-09-28 14:20	2026-09-28 14:20	2026-09-28 14:20	AMZN	AMZN261002C00242500	call	242.5000	2026-10-02	6.1700	6.1000	6.3500	247.0250	11106.00	0.00	11106.00	18	5	1754	318	5.51572327044025	0.32857625253901	0.32857625253901	false	false	false	true
719ca44c-1b5c-4fa6-9cc5-1092a990550a	2026-09-28 14:19	2026-09-28 14:18	2026-09-28 14:18	AMZN	AMZN260928C00247500	call	247.5000	2026-09-28	0.2300	0.2300	0.2600	247.0900	29256.00	0.00	29256.00	1272	48	59097	1076	54.9228624535316	0.293540283174223	0.293540283174223	false	false	false	true
103cdbf9-b307-4619-8546-39f54a6545a8	2026-09-28 14:08	2026-09-28 14:08	2026-09-28 14:08	AMZN	AMZN270416P00230000	put	230.0000	2027-04-16	14.8000	14.5500	14.8500	247.0000	11840.00	1480.00	8880.00	8	8	12	847	0.0141676505312869	0.353004923685838	0.353028895604945	false	false	false	true
dcf7415b-dae8-48af-8298-0f9759e7236d	2026-09-28 14:08	2026-09-28 14:08	2026-09-28 14:08	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	16.0500	16.0500	16.1000	247.0000	146055.00	0.00	146055.00	91	17	558	13921	0.0400833273471733	0.352175553572503	0.352175553572503	false	false	false	true