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

26595574-f105-4209-a48b-dd1b53daf283	2026-09-28 15:51	2026-09-28 15:51	2026-09-28 15:51	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.8300	0.8200	0.8300	245.9450	11288.00	11288.00	0.00	136	10	10187	1348	7.55712166172107	0.31370139675718	0.31370139675718	false	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:53:15.788869Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
06cca765-2ade-4791-bfd9-d76d87ae524a	2026-09-28 15:51	2026-09-28 15:51	2026-09-28 15:51	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5600	1.5500	1.5600	245.8300	10920.00	10920.00	0.00	70	8	12647	810	15.6135802469136	0.312639017130849	0.312639017130849	true	false	false	true
878b7542-37e8-41f1-94a1-3cb732be218c	2026-09-28 15:50	2026-09-28 15:50	2026-09-28 15:50	AMZN	AMZN261218C00260000	call	260.0000	2026-12-18	11.4000	11.4000	11.5000	245.8900	23940.00	0.00	23940.00	21	6	528	14995	0.0352117372457486	0.351096651152035	0.351096651152035	false	false	false	true
38f3cb92-ea14-48e4-bc02-9d1acb29148a	2026-09-28 15:44	2026-09-28 15:44	2026-09-28 15:44	AMZN	AMZN261002C00262500	call	262.5000	2026-10-02	0.1900	0.1900	0.2000	246.0600	17100.00	0.00	17100.00	900	23	3704	3472	1.0668202764977	0.366581426803814	0.366581426803814	false	false	false	true
0370484a-7844-4876-8b7c-e26e55a1ed8d	2026-09-28 15:41	2026-09-28 15:41	2026-09-28 15:41	AMZN	AMZN270319P00230000	put	230.0000	2027-03-19	14.0000	14.0000	14.3000	246.1303	155400.00	0.00	155400.00	111	15	140	6809	0.0205610221765311	0.355888099956333	0.355888099956333	false	false	false	true
4cd17b53-4322-4356-b27e-d5e39384ecef	2026-09-28 15:39	2026-09-28 15:39	2026-09-28 15:39	AMZN	AMZN261030P00205000	put	205.0000	2026-10-30	0.9100	0.7500	0.9200	246.0000	11375.00	11375.00	0.00	125	14	278	1095	0.253881278538813	0.431023074393227	0.431023074393227	false	false	false	true
f9406fe4-5a67-4ad7-985c-32ab4a0c5d7b	2026-09-28 15:38	2026-09-28 15:38	2026-09-28 15:38	AMZN	AMZN260928P00250000	put	250.0000	2026-09-28	3.3500	3.3500	3.7500	246.0000	47570.00	0.00	47570.00	142	6	2371	2839	0.835153222965833	1.88172582659287	1.88172582659287	false	false	false	true
de20bd69-c5aa-432e-b59d-d5bc473170d9	2026-09-28 15:37	2026-09-28 15:37	2026-09-28 15:37	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.7000	1.6900	1.7100	246.0000	18190.00	14110.00	170.00	107	17	11872	810	14.6567901234568	0.309165044660968	0.309165044660968	true	false	false	true
5b421f1d-4f40-47d5-b8a8-a21eb9081251	2026-09-28 15:37	2026-09-28 15:37	2026-09-28 15:37	AMZN	AMZN270115C00260000	call	260.0000	2027-01-15	13.8500	13.8500	13.9500	246.0000	142655.00	0.00	142655.00	103	6	453	10217	0.0443378682587844	0.339923736954025	0.339923736954025	false	false	false	true
1590dece-55cc-403e-8134-925966d9c202	2026-09-28 15:35	2026-09-28 15:35	2026-09-28 15:35	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	3.0200	2.9500	3.0500	246.3400	11476.00	11476.00	0.00	38	6	6792	1082	6.27726432532348	0.310814701699661	0.310814701699661	false	false	false	true
2c0431f9-e1db-4dc9-b97d-2afdb93fc7bd	2026-09-28 15:33	2026-09-28 15:33	2026-09-28 15:33	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	4.8000	4.8000	4.9000	246.1700	143524.00	0.00	143524.00	299	7	7669	13626	0.562821077352121	0.2882153483705	0.2882153483705	false	false	false	true
37c97da1-9a98-4772-a6d5-e04f71617bee	2026-09-28 15:33	2026-09-28 15:33	2026-09-28 15:33	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	4.8000	4.8000	4.9500	246.2750	144000.00	0.00	144000.00	300	7	7370	13626	0.540877733744312	0.286111925758764	0.286111925758764	false	false	false	true
5edb0706-237c-4eba-8d12-efea68dd0e49	2026-09-28 15:32	2026-09-28 15:32	2026-09-28 15:32	AMZN	AMZN261016P00235000	put	235.0000	2026-10-16	2.1700	2.1500	2.2000	246.1400	21700.00	16275.00	5425.00	100	6	826	11358	0.0727240711392851	0.29873487526514	0.29873487526514	false	false	false	true
8fdbbedb-fa52-4249-9b0a-a1285b93ec19	2026-09-28 15:32	2026-09-28 15:32	2026-09-28 15:32	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.4400	0.4300	0.4400	246.1700	10076.00	10076.00	0.00	229	16	10094	6498	1.55340104647584	0.320918147274667	0.320918147274667	false	false	false	true
93171ae1-24a3-4900-8f3a-c962007a9e21	2026-09-28 15:29	2026-09-28 15:29	2026-09-28 15:29	AMZN	AMZN270917P00235000	put	235.0000	2027-09-17	23.2500	23.0500	23.7000	246.1300	511500.00	374325.00	137175.00	220	10	298	521	0.571976967370441	0.355945679646926	0.355945679646926	false	false	false	true
b6b156c3-a92e-4672-83e7-2c3f1a232c5d	2026-09-28 15:29	2026-09-28 15:29	2026-09-28 15:29	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.7000	1.6400	1.7000	246.1300	17000.00	17000.00	0.00	100	6	11478	810	14.1703703703704	0.315320631798636	0.315320631798636	false	false	false	true
cd3ee2b7-d598-4a83-b9df-5cfce3b7898b	2026-09-28 15:26	2026-09-28 15:26	2026-09-28 15:26	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	2.8900	2.8900	2.9100	246.0500	22542.00	0.00	11560.00	78	16	6530	1082	6.03512014787431	0.316671297769256	0.316671297769256	false	false	false	true
02753d58-0974-4ee9-bad5-431e96cb7c74	2026-09-28 15:26	2026-09-28 15:25	2026-09-28 15:25	AMZN	AMZN260930P00247500	put	247.5000	2026-09-30	3.0000	3.0000	3.1000	246.1100	16200.00	0.00	16200.00	54	20	2491	1818	1.37018701870187	0.311520940628535	0.311520940628535	true	false	false	true
6e70132b-e364-49c5-bfec-49fdd74a2e41	2026-09-28 15:25	2026-09-28 15:25	2026-09-28 15:25	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.7500	1.7500	1.7600	246.0850	21700.00	0.00	21700.00	124	16	5703	1489	3.83008730691739	0.313697782886689	0.313697782886689	false	false	false	true
63253e43-8ed9-472d-921d-0fe056c65d19	2026-09-28 15:24	2026-09-28 15:24	2026-09-28 15:24	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.6600	1.6400	1.6600	246.0700	16600.00	16600.00	0.00	100	21	11301	810	13.9518518518519	0.313164276123782	0.313164276123782	false	false	false	true
6bcdee6d-2e9c-49fa-bc1b-eb9c6a1fb23d	2026-09-28 15:24	2026-09-28 15:24	2026-09-28 15:24	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.8600	0.8500	0.8600	246.0700	17114.00	17114.00	0.00	199	23	9246	1348	6.85905044510386	0.313471229828471	0.313471229828471	false	false	false	true
fa25cb35-727f-4010-8651-d7dd68b62a67	2026-09-28 15:24	2026-09-28 15:24	2026-09-28 15:24	AMZN	AMZN260930P00242500	put	242.5000	2026-09-30	0.9100	0.9000	0.9100	246.0568	13650.00	13650.00	0.00	150	21	2267	2474	0.916329830234438	0.31523071256193	0.31523071256193	false	false	false	true
677ce30d-3f54-481c-bfb1-c2d3f31130f3	2026-09-28 15:24	2026-09-28 15:24	2026-09-28 15:24	AMZN	AMZN260930P00240000	put	240.0000	2026-09-30	0.4300	0.4200	0.4300	246.0644	14792.00	14792.00	0.00	344	41	3453	1736	1.98905529953917	0.321262508219719	0.321262508219719	false	false	false	true
fa41068e-d5cd-4e53-a911-d478f64347f6	2026-09-28 15:22	2026-09-28 15:22	2026-09-28 15:22	AMZN	AMZN261120C00255000	call	255.0000	2026-11-20	10.7700	10.7000	10.8000	246.1100	34464.00	20463.00	14001.00	32	6	505	19165	0.0263501174015132	0.372661434183971	0.372661434183971	false	false	false	true
13e4a82b-dd2d-48da-876b-2f2ae5096a6b	2026-09-28 15:21	2026-09-28 15:21	2026-09-28 15:21	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	8.9500	8.9000	9.0000	246.1100	66230.00	0.00	43855.00	74	10	19064	15010	1.27008660892738	0.372433399374037	0.372433399374037	false	false	false	true
b5cf0a03-ec9a-485e-9743-f9a5a1199d6c	2026-09-28 15:20	2026-09-28 15:20	2026-09-28 15:20	AMZN	AMZN261030C00290000	call	290.0000	2026-10-30	1.3000	1.3000	1.3500	246.1100	26000.00	0.00	26000.00	200	12	469	1234	0.380064829821718	0.401772231116867	0.401772231116867	false	false	false	true
a363a876-11a0-4c29-86a9-56a9ce2b3a25	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	AMZN	AMZN261218P00245000	put	245.0000	2026-12-18	14.5000	14.4500	14.5500	246.0300	46400.00	2900.00	43500.00	32	9	457	5055	0.0904055390702275	0.351285964979395	0.351143104088391	false	false	false	true
5fe874c1-5600-43cc-8092-37ba3532f998	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	AMZN	AMZN261218P00245000	put	245.0000	2026-12-18	14.5000	14.5000	14.5500	246.0450	20300.00	0.00	20300.00	14	5	425	5055	0.0840751730959446	0.351144056652362	0.351285964979395	false	false	false	true
94032de3-970e-497d-8162-e6026f63f2a3	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	AMZN	AMZN261218P00245000	put	245.0000	2026-12-18	14.5000	14.5000	14.5500	246.0300	47850.00	0.00	47850.00	33	12	411	5055	0.0813056379821959	0.351143104088391	0.351143104088391	false	false	false	true
0346568c-7651-486f-b373-f67bd73e44c6	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	AMZN	AMZN261218P00245000	put	245.0000	2026-12-18	14.5000	14.4000	14.5500	246.0300	24650.00	17400.00	7250.00	17	5	378	5055	0.0747774480712166	0.351143104088391	0.351143104088391	false	false	false	true
f6e86fa8-093b-4780-bd7c-8bfc05d2dd70	2026-09-28 15:15	2026-09-28 15:15	2026-09-28 15:15	AMZN	AMZN261009C00247500	call	247.5000	2026-10-09	4.4500	4.4000	4.5000	245.8600	16465.00	11125.00	4895.00	37	5	2087	289	7.22145328719723	0.298236449699428	0.298236449699428	false	false	false	true
7a443c3a-0593-4e2c-be95-2adf82b3ca43	2026-09-28 15:15	2026-09-28 15:15	2026-09-28 15:15	AMZN	AMZN261009C00247500	call	247.5000	2026-10-09	4.4500	4.3500	4.5000	245.8500	10235.00	9345.00	445.00	23	12	2049	289	7.08996539792388	0.29851239783366	0.29851239783366	false	false	false	true
e43204fc-4e51-4d2c-be7e-bc79acb48e6e	2026-09-28 15:15	2026-09-28 15:15	2026-09-28 15:15	AMZN	AMZN260928C00245000	call	245.0000	2026-09-28	0.9300	0.8800	0.9300	245.8800	24645.00	24645.00	0.00	265	19	18719	574	32.6114982578397	0.341211396787377	0.341211396787377	false	false	false	true
963753b4-8f1f-4b0f-bc2e-62b033e92166	2026-09-28 15:15	2026-09-28 15:15	2026-09-28 15:15	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	3.9000	3.8000	3.9000	245.8800	15990.00	15990.00	0.00	41	5	5353	1118	4.78801431127013	0.330109416272213	0.330109416272213	false	false	false	true
a1a949c8-f345-4485-9ef1-9ee8841e59a2	2026-09-28 15:14	2026-09-28 15:14	2026-09-28 15:14	AMZN	AMZN261016C00245000	call	245.0000	2026-10-16	7.0500	7.0000	7.1000	245.7500	12690.00	11280.00	0.00	18	8	1369	4654	0.294155565105286	0.295315458159746	0.295315458159746	true	false	false	true
af9afb85-25de-45df-90f1-5b646a3b38b3	2026-09-28 15:12	2026-09-28 15:12	2026-09-28 15:12	AMZN	AMZN261016C00245000	call	245.0000	2026-10-16	7.0500	7.0000	7.1000	245.8100	14100.00	9165.00	4935.00	20	5	1348	4654	0.289643317576278	0.293805693194509	0.293805693194509	false	false	false	true
d292dd5d-d135-4cdf-a3c5-2f537fe40d16	2026-09-28 15:11	2026-09-28 15:11	2026-09-28 15:11	AMZN	AMZN261016C00247500	call	247.5000	2026-10-16	5.8000	5.7000	5.8500	245.7800	15658.00	15658.00	0.00	27	13	1726	388	4.44845360824742	0.29301219670798	0.29301219670798	true	false	false	true
7e5dbbc8-5e4e-4119-93c8-53fcd7d986b3	2026-09-28 15:10	2026-09-28 15:10	2026-09-28 15:10	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	4.2000	4.2000	4.2500	245.8000	43260.00	0.00	43260.00	103	9	1866	67339	0.0277105392120465	0.341657532652543	0.341657532652543	false	false	false	true
3f89a466-0e25-49a2-97db-cdb890c14570	2026-09-28 15:10	2026-09-28 15:10	2026-09-28 15:10	AMZN	AMZN261218C00260000	call	260.0000	2026-12-18	11.3000	11.2500	11.4000	245.7500	169500.00	0.00	169500.00	150	7	499	14995	0.0332777592530844	0.350189159356448	0.350189159356448	false	false	false	true
806949c2-8c02-4302-ba42-418cd1b20575	2026-09-28 15:09	2026-09-28 15:09	2026-09-28 15:09	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.6000	1.5900	1.6000	245.9400	12640.00	12640.00	0.00	79	13	10861	810	13.4086419753086	0.312121114884325	0.312121114884325	true	false	false	true
e2aa2cd2-f244-476e-b2eb-b9238dfc1ba5	2026-09-28 15:09	2026-09-28 15:09	2026-09-28 15:09	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5900	1.5800	1.5900	245.9250	27030.00	27030.00	0.00	170	22	10782	810	13.3111111111111	0.311551648621606	0.311551648621606	true	false	false	true
3e854f52-d6fc-4c50-baa1-cfdac7417caf	2026-09-28 15:08	2026-09-28 15:08	2026-09-28 15:08	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.6000	1.5900	1.6000	245.9550	10560.00	10560.00	0.00	66	9	10605	810	13.0925925925926	0.311267011243564	0.311267011243564	true	false	false	true
1f578859-182e-416d-ac21-2d39b926629e	2026-09-28 15:08	2026-09-28 15:08	2026-09-28 15:08	AMZN	AMZN261016P00220000	put	220.0000	2026-10-16	0.4700	0.4600	0.4700	245.9500	12831.00	12831.00	0.00	273	5	883	10110	0.0873392680514342	0.333814291767733	0.333814291767733	true	false	false	true
4a3123ef-3168-425b-98ab-6480cdca16cb	2026-09-28 15:06	2026-09-28 15:06	2026-09-28 15:06	AMZN	AMZN261002P00242500	put	242.5000	2026-10-02	1.7600	1.7200	1.7600	246.0700	14432.00	14432.00	0.00	82	9	2858	2645	1.08052930056711	0.321154648336078	0.321154648336078	false	false	false	true
c4f52b57-fe35-4c37-bb1f-bade30c66aa5	2026-09-28 15:02	2026-09-28 15:02	2026-09-28 15:02	AMZN	AMZN260928P00247500	put	247.5000	2026-09-28	1.5000	1.3500	1.5000	246.0900	14999.00	14999.00	0.00	100	9	16219	2151	7.54021385402139	0.502720373303752	0.48475849319408	false	false	false	true
f0474a90-d2f6-4d2b-97c9-4909525cb3ca	2026-09-28 15:02	2026-09-28 15:02	2026-09-28 15:02	AMZN	AMZN270115C00275000	call	275.0000	2027-01-15	9.0000	9.0000	9.2000	246.0850	20700.00	0.00	20700.00	23	7	675	64045	0.0105394644390663	0.338702260608603	0.338702260608603	false	false	false	true
f2021d5e-fb85-44f2-9704-67a9b55dfefb	2026-09-28 15:01	2026-09-28 15:01	2026-09-28 15:01	AMZN	AMZN261009P00245000	put	245.0000	2026-10-09	4.2000	4.0000	4.2500	246.2100	11760.00	10500.00	0.00	28	16	356	1665	0.213813813813814	0.289555868249723	0.289294260750256	true	false	false	true
2503d1d3-2005-415e-940a-3339f8454188	2026-09-28 15:01	2026-09-28 15:01	2026-09-28 15:01	AMZN	AMZN261120C00305000	call	305.0000	2026-11-20	1.3700	1.3300	1.3700	246.2650	54389.00	54389.00	0.00	397	47	18326	13964	1.31237467774277	0.38203736547038	0.38203736547038	false	false	false	true
1c453098-1e24-437d-8dc4-05011f2e9add	2026-09-28 15:01	2026-09-28 15:01	2026-09-28 15:01	AMZN	AMZN260928P00247500	put	247.5000	2026-09-28	1.2300	1.2300	1.3600	246.2300	10332.00	0.00	10332.00	84	6	16068	2151	7.47001394700139	0.461479863524025	0.461479863524025	false	false	false	true
25a261d8-3ed9-4d76-88a7-a3cda6aed8c6	2026-09-28 15:00	2026-09-28 15:00	2026-09-28 15:00	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.5600	1.5200	1.5700	246.4100	19188.00	19188.00	0.00	123	24	5145	1489	3.45533915379449	0.305384980588671	0.305384980588671	true	false	false	true