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:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = PEP×

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

a2b4ba37-a4bf-4457-9894-4fa8e2ec8611	2026-10-02 15:44	2026-10-02 15:44	2026-10-02 15:44	PEP	PEP270917P00125000	put	125.0000	2027-09-17	10.9000	10.7500	10.9000	125.0000	31610.00	31610.00	0.00	29	8	75	383	0.195822454308094	0.285446800337901	0.285446800337901	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	171826198237.00	2026-10-08	premarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:49:29.839373Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
e36b67f2-a40d-47a9-8328-80c588c3343f	2026-10-02 15:18	2026-10-02 15:18	2026-10-02 15:18	PEP	PEP261106P00129000	put	129.0000	2026-11-06	5.3000	5.1500	5.4000	125.7950	15900.00	15370.00	530.00	30	5	78	8	9.75	0.242086515927834	0.242086515927834	false	false	false
38bdfb9a-2199-414e-a961-d72caaa5dcbd	2026-10-02 11:19	2026-10-02 11:19	2026-10-02 11:19	PEP	PEP270319C00120000	call	120.0000	2027-03-19	11.3500	11.3000	11.4500	125.0000	15890.00	13620.00	2270.00	14	5	88	2076	0.0423892100192678	0.207231451857125	0.207231451857125	false	false	false
39183d2a-9cb9-4d4e-8311-412b8559a814	2026-10-02 10:47	2026-10-02 10:47	2026-10-02 10:47	PEP	PEP290119C00130000	call	130.0000	2029-01-19	16.6500	16.0000	16.7000	125.7800	111555.00	111555.00	0.00	67	13	113	549	0.205828779599271	0.155781226428735	0.155781226428735	true	false	false
483528cd-4d12-4037-bf8e-c860f87e5748	2026-10-02 10:45	2026-10-02 10:45	2026-10-02 10:45	PEP	PEP270319C00145000	call	145.0000	2027-03-19	2.3000	2.2800	2.3400	125.6750	17710.00	0.00	17710.00	77	10	114	1193	0.0955574182732607	0.220626266035909	0.220626266035909	false	false	false
a4b78f6c-48fc-4035-b852-ecd8c2e64175	2026-10-02 10:28	2026-10-02 10:28	2026-10-02 10:28	PEP	PEP270115C00140000	call	140.0000	2027-01-15	1.7500	1.7500	1.8400	125.5374	43050.00	0.00	43050.00	246	6	284	6848	0.0414719626168224	0.217435360046278	0.217435360046278	false	false	false
880028a1-c682-47a3-8169-de59ec1a4548	2026-10-02 10:09	2026-10-02 10:08	2026-10-02 10:08	PEP	PEP261009C00123000	call	123.0000	2026-10-09	4.1500	3.8000	4.1500	125.9300	20750.00	20750.00	0.00	50	10	110	359	0.306406685236769	0.339229947628648	0.339229947628648	false	false	false
343e7646-ea98-460a-873e-c2063b81bd91	2026-10-02 10:09	2026-10-02 10:08	2026-10-02 10:08	PEP	PEP261009C00123000	call	123.0000	2026-10-09	4.2000	3.8000	4.2000	125.9300	21000.00	21000.00	0.00	50	10	60	359	0.167130919220056	0.34752348877721	0.34752348877721	false	false	false
ff933ca0-04aa-4276-9647-087a30fbcab1	2026-10-02 09:55	2026-10-02 09:55	2026-10-02 09:55	PEP	PEP261016C00134000	call	134.0000	2026-10-16	0.5200	0.5200	0.5400	125.6600	12584.00	0.00	12584.00	242	17	242	78	3.1025641025641	0.293388764043755	0.293388764043755	false	false	false
3fefce58-2329-49b7-b365-3f1fd2b79f77	2026-10-02 09:54	2026-10-02 09:54	2026-10-02 09:54	PEP	PEP290119C00165000	call	165.0000	2029-01-19	6.7000	6.6500	6.7000	125.0000	20770.00	20770.00	0.00	31	6	31	181	0.171270718232044	0.184741453103899	0.184741453103899	true	false	false
06d4d468-204a-450d-9165-2b152a00b80e	2026-10-02 09:52	2026-10-02 09:52	2026-10-02 09:52	PEP	PEP261009C00135000	call	135.0000	2026-10-09	0.2700	0.1200	0.3600	126.0000	10233.00	594.00	9639.00	379	29	404	713	0.566619915848527	0.36349228909081	0.36349228909081	false	false	false
db38d1dd-f333-4a32-a65c-f13f4e71932a	2026-10-01 15:47	2026-10-01 15:47	2026-10-01 15:47	PEP	PEP261002C00126000	call	126.0000	2026-10-02	0.5900	0.4800	0.5900	125.9450	26904.00	26904.00	0.00	456	7	1260	17	74.1176470588235	0.232038446608119	0.232038446608119	true	false	false
6a8df820-b44d-4caa-b3bd-1717eab366d2	2026-10-01 15:23	2026-10-01 15:23	2026-10-01 15:23	PEP	PEP261218P00125000	put	125.0000	2026-12-18	5.0000	4.9500	5.0000	125.0000	87499.00	87499.00	0.00	175	35	344	1883	0.182687201274562	0.25885485035409	0.25885485035409	false	false	false
13834584-c1dc-4615-a29a-5d481ae68c71	2026-10-01 13:41	2026-10-01 13:41	2026-10-01 13:41	PEP	PEP270319P00125000	put	125.0000	2027-03-19	7.6500	7.6000	7.6500	125.0000	86443.00	86443.00	0.00	113	19	131	1329	0.0985703536493604	0.273236987813932	0.273236987813932	false	false	false
004beab3-5c79-4e43-a377-b9745bca76ed	2026-10-01 12:51	2026-10-01 12:51	2026-10-01 12:51	PEP	PEP270917P00125000	put	125.0000	2027-09-17	10.7500	10.6500	10.8500	126.0100	34400.00	21500.00	12900.00	32	5	68	314	0.21656050955414	0.285904733221121	0.285904733221121	false	false	false
6c9758f4-d02a-43d4-bd2b-7bf522c7f587	2026-10-01 12:35	2026-10-01 12:35	2026-10-01 12:35	PEP	PEP261030P00128000	put	128.0000	2026-10-30	4.3500	4.1500	4.3500	126.1350	95265.00	95265.00	0.00	219	36	226	133	1.69924812030075	0.250613449997991	0.250613449997991	false	false	false
2cc0a618-a1b8-4d02-b92d-c54cf5041541	2026-10-01 12:27	2026-10-01 12:26	2026-10-01 12:26	PEP	PEP270319P00115000	put	115.0000	2027-03-19	3.6000	3.6000	3.6500	126.2950	12960.00	0.00	12960.00	36	5	106	1113	0.0952380952380952	0.270906617816227	0.270906617816227	false	false	false
3109cc5d-2d01-4867-88ed-016784822a14	2026-10-01 12:20	2026-10-01 12:19	2026-10-01 12:19	PEP	PEP270115P00145000	put	145.0000	2027-01-15	19.8500	19.6000	19.8500	126.0000	39695.00	39695.00	0.00	20	5	397	2933	0.135356290487555	0.308746940840212	0.308746940840212	true	false	false
f71bb3d3-019c-4483-bb3a-43614cae6306	2026-10-01 12:18	2026-10-01 12:18	2026-10-01 12:18	PEP	PEP280121C00170000	call	170.0000	2028-01-21	2.7300	2.6300	2.7300	126.2800	40950.00	40950.00	0.00	150	5	151	703	0.214793741109531	0.203780276916045	0.203780276916045	false	false	false
8adc6d89-366c-412c-b829-84d7f289355b	2026-10-01 11:43	2026-10-01 11:43	2026-10-01 11:43	PEP	PEP261016P00129000	put	129.0000	2026-10-16	4.3000	4.0500	4.4000	126.3900	59765.00	59340.00	425.00	139	26	141	237	0.594936708860759	0.285716536089064	0.280601939331897	false	false	false
245a53ad-3608-4152-b4b4-446503fa420e	2026-10-01 11:02	2026-10-01 11:01	2026-10-01 11:01	PEP	PEP261218P00135000	put	135.0000	2026-12-18	11.0000	10.8500	11.3000	126.3400	22000.00	8800.00	13200.00	20	5	34	1870	0.0181818181818182	0.276072813128384	0.276072813128384	false	false	false
2e3545c6-a038-4757-b4bd-558554d96546	2026-10-01 10:35	2026-10-01 10:35	2026-10-01 10:35	PEP	PEP290119C00170000	call	170.0000	2029-01-19	6.0500	6.0500	6.3500	126.2700	90750.00	0.00	90750.00	150	6	152	320	0.475	0.186862965505434	0.186862965505434	false	false	false
622b4f20-00cb-43b8-ab41-734d4ff4e942	2026-10-01 10:17	2026-10-01 10:17	2026-10-01 10:17	PEP	PEP270115P00145000	put	145.0000	2027-01-15	18.9500	18.9500	19.1000	127.2350	20845.00	0.00	20845.00	11	5	160	2933	0.0545516535969997	0.301357666249813	0.301357666249813	false	false	false
bd31af2c-46ce-4a84-930f-db244c3831b9	2026-10-01 10:13	2026-10-01 10:13	2026-10-01 10:13	PEP	PEP261009P00131000	put	131.0000	2026-10-09	4.8500	4.8000	5.2500	127.1600	20860.00	490.00	20370.00	43	7	54	224	0.241071428571429	0.337268761217252	0.344998182090817	false	false	false
6320f215-0a29-4e0f-aeca-c37ecc16ea50	2026-10-01 09:58	2026-10-01 09:58	2026-10-01 09:58	PEP	PEP261218C00135000	call	135.0000	2026-12-18	2.3700	2.3700	2.5100	126.6500	11850.00	0.00	11850.00	50	5	52	1323	0.0393046107331822	0.215694069396019	0.215694069396019	false	false	false
1f1470c4-f2f7-400b-bd8c-324bb347df8f	2026-09-30 15:45	2026-09-30 15:45	2026-09-30 15:45	PEP	PEP261120C00130000	call	130.0000	2026-11-20	3.5000	3.4500	3.6500	127.0700	10150.00	0.00	10150.00	29	5	186	991	0.187689202825429	0.235717391110182	0.235717391110182	false	false	false
4607de69-6c6f-48f9-bb0a-e0d730ad1b9a	2026-09-30 14:33	2026-09-30 14:32	2026-09-30 14:32	PEP	PEP290119P00115000	put	115.0000	2029-01-19	10.4500	10.4500	10.8000	127.1800	79420.00	0.00	79420.00	76	12	130	25	5.2	0.296232096979401	0.296232096979401	false	false	false
0365bf51-a2d6-4ff0-a3d6-e81771106878	2026-09-30 12:19	2026-09-30 12:19	2026-09-30 12:19	PEP	PEP261002C00130000	call	130.0000	2026-10-02	0.2500	0.2100	0.2800	127.9300	23125.00	450.00	22450.00	925	48	1354	1068	1.26779026217228	0.246238714995492	0.246238714995492	false	false	false
02f119fc-a38c-41d3-b1a8-5482d0d2fa54	2026-09-30 12:02	2026-09-30 12:02	2026-09-30 12:02	PEP	PEP270115C00140000	call	140.0000	2027-01-15	2.3000	2.2000	2.3000	127.8500	69000.00	69000.00	0.00	300	6	577	6532	0.0883343539497857	0.214241024466537	0.214241024466537	false	false	false
78d6e53a-ac23-4a63-beed-1cdf105894de	2026-09-30 11:08	2026-09-30 11:08	2026-09-30 11:08	PEP	PEP261030P00126000	put	126.0000	2026-10-30	2.6000	2.4800	2.6600	127.8300	21839.00	21580.00	259.00	84	24	94	23	4.08695652173913	0.24938325214758	0.248671089903707	false	false	false
f5cd7131-326c-4c31-95bc-568f3b0a8876	2026-09-30 11:02	2026-09-30 11:02	2026-09-30 11:02	PEP	PEP261016C00130000	call	130.0000	2026-10-16	2.2000	2.2000	2.3400	128.0300	16280.00	0.00	16280.00	74	5	898	2039	0.440411966650319	0.277733728600533	0.277733728600533	false	false	false
bba6472e-7972-443b-8e12-7588ddbe1fbe	2026-09-30 10:22	2026-09-30 10:22	2026-09-30 10:22	PEP	PEP261218C00140000	call	140.0000	2026-12-18	1.8900	1.8900	1.9500	129.0900	12663.00	0.00	12663.00	67	8	101	21348	0.00473112235338205	0.217092779139608	0.217092779139608	false	false	false
4ac2e6f8-7653-4285-952f-e87413bcc6d4	2026-09-30 10:10	2026-09-30 10:10	2026-09-30 10:10	PEP	PEP261016C00130000	call	130.0000	2026-10-16	2.5900	2.5900	2.8300	128.8900	19425.00	0.00	19425.00	75	6	601	2039	0.29475232957332	0.278637847225109	0.278637847225109	false	false	false
243e908c-e0ad-40f5-ab0b-a6800872946f	2026-09-30 10:04	2026-09-30 10:04	2026-09-30 10:04	PEP	PEP270115C00140000	call	140.0000	2027-01-15	2.5300	2.5200	2.6000	128.9800	13662.00	0.00	13408.00	54	9	148	6532	0.0226576852418861	0.21056245505562	0.21014439290733	false	false	false
0a2ca1a5-e84b-43d2-b1da-4aea38a221fd	2026-09-29 14:58	2026-09-29 14:57	2026-09-29 14:57	PEP	PEP280121C00160000	call	160.0000	2028-01-21	4.6000	4.6000	5.8000	128.3200	45540.00	0.00	45540.00	99	13	143	864	0.165509259259259	0.19858662508707	0.19858662508707	false	false	false
06e1f5f8-22d9-442d-972c-501054e854c5	2026-09-29 09:36	2026-09-29 09:36	2026-09-29 09:36	PEP	PEP261009P00115000	put	115.0000	2026-10-09	0.1100	0.1100	0.2200	127.4150	11496.00	0.00	11484.00	1045	29	1067	15	71.1333333333333	0.354317374515947	0.354317374515947	false	false	false
8d82a043-9a9c-4d10-8e16-17625b738442	2026-09-29 09:34	2026-09-29 09:34	2026-09-29 09:34	PEP	PEP270115C00140000	call	140.0000	2027-01-15	2.0800	2.0800	2.2200	126.8600	10401.00	209.00	10192.00	50	5	88	6286	0.0139993636652879	0.21459233103208	0.215048625544683	false	false	false
4f7ccee9-789c-4380-9d72-d7547e80f849	2026-09-28 15:28	2026-09-28 15:28	2026-09-28 15:28	PEP	PEP261016C00130000	call	130.0000	2026-10-16	2.7500	2.6700	2.7500	128.6600	24192.00	24192.00	0.00	88	7	662	1362	0.486049926578561	0.285045629348679	0.285045629348679	false	false	false
7c95d8c0-9472-448d-bbf9-ef3b2d3a071d	2026-09-28 15:10	2026-09-28 15:09	2026-09-28 15:09	PEP	PEP270319C00145000	call	145.0000	2027-03-19	3.0000	2.8100	3.0000	128.6000	12000.00	12000.00	0.00	40	5	118	895	0.131843575418994	0.216164013664153	0.216070641675087	false	false	false
042ac29c-6899-4e9c-bf0b-b07368572601	2026-09-28 13:16	2026-09-28 13:16	2026-09-28 13:16	PEP	PEP261120C00145000	call	145.0000	2026-11-20	0.6600	0.6600	0.6800	128.2400	13134.00	0.00	13134.00	199	8	409	2417	0.169218038891187	0.246987601645089	0.246987601645089	false	false	false
bf393491-d230-4d6b-aee0-b178f88e2474	2026-09-28 10:54	2026-09-28 10:54	2026-09-28 10:54	PEP	PEP261016C00145000	call	145.0000	2026-10-16	0.1400	0.1200	0.1700	128.3700	10626.00	364.00	10262.00	759	24	984	5319	0.184997179921038	0.304075996700137	0.304075996700137	false	false	false
e7ece412-5cee-4e84-9d7f-c29c48f179f9	2026-09-25 15:35	2026-09-25 15:35	2026-09-25 15:35	PEP	PEP270917P00130000	put	130.0000	2027-09-17	12.2500	12.1500	12.3500	128.5400	47775.00	23275.00	24500.00	39	6	186	1937	0.096024780588539	0.286143420323738	0.286143420323738	false	false	false
09f10410-7efb-4ee4-a345-ac562fa91487	2026-09-25 14:36	2026-09-25 14:36	2026-09-25 14:36	PEP	PEP270917P00130000	put	130.0000	2027-09-17	12.3000	12.3000	12.5500	128.2800	81180.00	0.00	81180.00	66	23	144	1937	0.0743417656169334	0.285043652030225	0.285043652030225	false	false	false
ab51273a-9ae1-44e5-8f4b-0980565e3119	2026-09-25 13:49	2026-09-25 13:49	2026-09-25 13:49	PEP	PEP270917P00125000	put	125.0000	2027-09-17	9.9500	9.8000	10.0500	128.1550	57694.00	28839.00	28855.00	58	7	116	161	0.720496894409938	0.28349210869431	0.28349210869431	false	false	false
530b1507-8b0b-4c53-83f1-efc4338d9fb4	2026-09-25 13:12	2026-09-25 13:12	2026-09-25 13:12	PEP	PEP290119C00125000	call	125.0000	2029-01-19	20.3500	20.2000	20.5500	128.0900	20350.00	0.00	16280.00	10	5	173	523	0.330783938814532	0.138561281365554	0.138561281365554	false	false	false
4077bbbd-b7a0-47fc-92e4-a5c673850a6d	2026-09-25 11:41	2026-09-25 11:41	2026-09-25 11:41	PEP	PEP261030C00128000	call	128.0000	2026-10-30	4.1000	4.0500	4.1500	127.0000	27471.00	411.00	27060.00	67	16	406	82	4.95121951219512	0.246686285824987	0.247321231393649	false	false	false
44023e30-5774-44bc-9450-0dfc0db18992	2026-09-25 10:27	2026-09-25 10:27	2026-09-25 10:27	PEP	PEP290119C00125000	call	125.0000	2029-01-19	20.3500	20.0500	20.8000	127.9400	10175.00	2035.00	8140.00	5	5	71	523	0.135755258126195	0.140536791055845	0.140536791055845	false	false	false
15ca6429-833d-4343-8666-7505c145cf8d	2026-09-25 10:26	2026-09-25 10:25	2026-09-25 10:25	PEP	PEP261030P00138000	put	138.0000	2026-10-30	10.5000	10.1500	10.5000	127.8750	10500.00	3150.00	0.00	10	10	10	6	1.66666666666667	0.245887073441754	0.245887073441754	false	false	false
0d613f7d-9322-4d7b-b825-3a47f5e732ca	2026-09-25 09:30	2026-09-25 09:30	2026-09-25 09:30	PEP	PEP261016P00135000	put	135.0000	2026-10-16	8.0000	7.9000	8.2000	127.7700	29600.00	2400.00	24800.00	37	11	138	3373	0.0409131337088645	0.279401201246449	0.279401201246449	false	false	false
b40efed7-5aa7-488d-9e2d-e1feec6547bc	2026-09-24 12:14	2026-09-24 12:14	2026-09-24 12:14	PEP	PEP261030C00110000	call	110.0000	2026-10-30	19.6000	19.3000	19.9500	128.9100	29400.00	0.00	29400.00	15	5	17	18	0.944444444444444	0.315108773853531	0.315108773853531	true	false	false