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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = premarket×sector = Consumer Defensive×

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

43dac1f9-f6ef-498d-b6b5-01af29e1d451	2026-09-22 10:18	2026-09-22 10:18	2026-09-22 10:18	PM	PM261002P00190000	put	190.0000	2026-10-02	5.1000	5.1000	6.5000	188.2100	10710.00	0.00	10710.00	21	5	21	29	0.724137931034483	0.341481151506558	0.341481151506558	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	296495034501.00	2026-10-20	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T14:20:22.518739Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
c5370cc7-84ea-4cf9-be49-16c1843b61d4	2026-09-22 10:17	2026-09-22 10:17	2026-09-22 10:17	PEP	PEP260925C00128000	call	128.0000	2026-09-25	3.1000	2.2200	3.1000	130.7850	46500.00	46500.00	0.00	150	6	205	302	0.678807947019868	0.254012569744978	0.254012569744978	false	false	false	true
a469c351-0803-4c25-8646-c2ef0552c4b9	2026-09-22 09:41	2026-09-22 09:40	2026-09-22 09:40	PEP	PEP261016C00130000	call	130.0000	2026-10-16	3.5500	3.5500	3.7000	130.0800	35500.00	0.00	35500.00	100	5	339	1631	0.207847946045371	0.251202966644696	0.251202966644696	false	false	false	true
1a9a1fb1-7e39-4d67-a3cf-9c6cacbb3dec	2026-09-21 15:52	2026-09-21 15:52	2026-09-21 15:52	MO	MO261016P00069000	put	69.0000	2026-10-16	1.6900	1.5600	1.7300	68.6000	69290.00	67431.00	1859.00	410	7	602	0	0	0.220482782992329	0.220482782992329	false	false	false	true
59f7f786-8a17-4ea1-ad12-a3b7e1bd6121	2026-09-21 15:51	2026-09-21 15:51	2026-09-21 15:51	MO	MO261016P00069000	put	69.0000	2026-10-16	1.6700	1.5300	1.9300	68.5900	27752.00	671.00	2365.00	166	6	192	0	0	0.220126513146852	0.218372885968659	true	false	false	true
df2be21f-35ad-48dd-b3ff-1b387e39c84d	2026-09-21 15:49	2026-09-21 15:49	2026-09-21 15:49	PEP	PEP270115P00110000	put	110.0000	2027-01-15	0.8900	0.8500	0.9700	129.0000	11038.00	180.00	10858.00	124	28	151	880	0.171590909090909	0.256433018471121	0.258040134718722	false	false	false	true
44ff4451-40f0-48f4-9c3c-50668b8243ec	2026-09-21 15:48	2026-09-21 15:48	2026-09-21 15:48	PEP	PEP280121C00130000	call	130.0000	2028-01-21	14.7500	14.3500	14.9500	129.0000	14750.00	7375.00	7375.00	10	5	369	448	0.823660714285714	0.179838783037955	0.179838783037955	false	false	false	true
45747d97-6633-4cc4-8ad1-0fd9ae8c1001	2026-09-21 15:43	2026-09-21 15:43	2026-09-21 15:43	PEP	PEP280121C00130000	call	130.0000	2028-01-21	14.7400	14.6500	14.8000	129.8200	26535.00	26535.00	0.00	18	5	178	448	0.397321428571429	0.178277538799656	0.18009100713605	false	false	false	true
95069a01-e086-4030-bf72-5d1df33caf0f	2026-09-21 15:36	2026-09-21 15:36	2026-09-21 15:36	GIS	GIS261120C00032500	call	32.5000	2026-11-20	3.8200	3.7000	4.5000	35.6750	38150.00	0.00	38150.00	100	9	100	0	0	0.284302983720956	0.284302983720956	false	false	false	true
e6ed8bd7-dda5-4cd2-8120-32345b6551b6	2026-09-21 15:31	2026-09-21 15:31	2026-09-21 15:31	GIS	GIS270115P00030000	put	30.0000	2027-01-15	0.6500	0.6500	0.7000	35.0000	15276.00	0.00	15276.00	235	30	248	2747	0.0902803057881325	0.363680134189241	0.363680134189241	false	false	false	true
e2e1bc43-90be-4084-b285-e0b8e81ac07f	2026-09-21 15:28	2026-09-21 15:28	2026-09-21 15:28	PEP	PEP270617C00130000	call	130.0000	2027-06-17	11.1000	10.9000	11.1000	129.9750	11100.00	11100.00	0.00	10	5	37	72	0.513888888888889	0.202663445909997	0.202663445909997	false	false	false	true
6f1805a7-80c8-494c-bad4-edd4f43f7601	2026-09-21 15:11	2026-09-21 15:11	2026-09-21 15:11	PEP	PEP270319C00140000	call	140.0000	2027-03-19	4.8000	4.8000	4.9000	130.0200	23040.00	0.00	23040.00	48	6	290	637	0.455259026687598	0.210435025263318	0.210435025263318	false	false	false	true
7a117598-3c1b-42b5-9bdc-d162b5e3a284	2026-09-21 15:11	2026-09-21 15:11	2026-09-21 15:11	PEP	PEP270319C00140000	call	140.0000	2027-03-19	4.8000	4.8000	4.9000	130.0200	20160.00	0.00	20160.00	42	6	242	637	0.379905808477237	0.210490538812067	0.210435025263318	false	false	false	true
c96100a9-bee0-4bbb-8e56-d684d659581f	2026-09-21 13:51	2026-09-21 13:50	2026-09-21 13:50	PEP	PEP270115C00150000	call	150.0000	2027-01-15	1.1300	1.1300	1.1500	129.5400	16498.00	0.00	16498.00	146	5	1489	3327	0.447550345656748	0.213635755315714	0.213635755315714	false	false	false	true
4a9fd0e0-d1bf-44d9-89d0-339d92623e61	2026-09-21 13:20	2026-09-21 13:20	2026-09-21 13:20	PEP	PEP261009P00130000	put	130.0000	2026-10-09	2.9400	2.8300	2.9400	130.0000	74969.00	74676.00	293.00	255	36	312	440	0.709090909090909	0.267702720264951	0.267702720264951	false	false	false	true
3438baa1-e202-428d-93ab-18d6af394167	2026-09-21 13:11	2026-09-21 13:10	2026-09-21 13:10	PEP	PEP260925C00125000	call	125.0000	2026-09-25	5.2000	4.4000	5.2000	130.0400	92040.00	92040.00	0.00	177	5	212	402	0.527363184079602	0.25798125207166	0.25798125207166	true	false	false	true
11af18cb-5d03-4844-9bf8-76171d15729d	2026-09-21 13:01	2026-09-21 13:01	2026-09-21 13:01	PEP	PEP261009C00123000	call	123.0000	2026-10-09	8.0000	7.5000	8.0000	129.9200	20000.00	20000.00	0.00	25	6	404	0	0	0.289074861119297	0.289074861119297	false	false	false	true
8231c3c6-6902-4aa6-9dda-96a69cff137e	2026-09-21 12:56	2026-09-21 12:55	2026-09-21 12:55	PEP	PEP270115C00150000	call	150.0000	2027-01-15	1.1900	1.1800	1.2300	129.0000	12138.00	0.00	12138.00	102	8	543	3327	0.163210099188458	0.214501303496074	0.214501303496074	false	false	false	true
69379bfe-2141-4be8-b379-6e6ea674ab86	2026-09-21 12:55	2026-09-21 12:55	2026-09-21 12:55	GIS	GIS261218P00030000	put	30.0000	2026-12-18	0.4000	0.4000	0.4500	36.0000	11922.00	0.00	11922.00	298	31	320	2425	0.131958762886598	0.360559395758485	0.360559395758485	false	false	false	true
adf389bb-d5b3-47a3-bf21-a025959e4bcb	2026-09-21 12:39	2026-09-21 12:39	2026-09-21 12:39	MO	MO261023C00072000	call	72.0000	2026-10-23	0.6300	0.5900	0.6700	68.6600	35217.00	1260.00	33957.00	559	7	577	100	5.77	0.211822442292498	0.212016705045084	false	false	false	true
a2e2aff5-1261-405f-b07d-ee90a3697dca	2026-09-21 12:26	2026-09-21 12:26	2026-09-21 12:26	CALM	CALM261016C00075000	call	75.0000	2026-10-16	2.1500	2.0000	2.3500	72.1400	20205.00	19560.00	645.00	94	20	171	213	0.802816901408451	0.431785864028951	0.431785864028951	false	false	false	true
4740b5bf-d42d-4d9a-aa5d-a329fbc89eda	2026-09-21 12:21	2026-09-21 12:21	2026-09-21 12:21	LW	LW270115P00040000	put	40.0000	2027-01-15	1.3200	1.3000	1.6500	47.2600	33000.00	0.00	33000.00	250	6	500	1704	0.293427230046948	0.417056069020176	0.425539346254753	false	false	false	true
41c2aee6-98c6-4731-a358-1aad5243d97c	2026-09-21 12:21	2026-09-21 12:21	2026-09-21 12:21	LW	LW270115P00040000	put	40.0000	2027-01-15	1.3200	1.2500	1.6500	47.0000	33000.00	3900.00	29100.00	250	15	250	1704	0.146713615023474	0.415739498563257	0.43079222972524	false	false	false	true
666d9e16-c584-448a-b1c9-5cb09bf99cbf	2026-09-21 11:30	2026-09-21 11:30	2026-09-21 11:30	PEP	PEP261120C00130000	call	130.0000	2026-11-20	4.5500	4.5500	4.7000	128.4412	55965.00	0.00	55965.00	123	6	445	534	0.833333333333333	0.23460662288333	0.23460662288333	false	false	false	true
bfe78d51-e386-47f7-8ab8-3d4a55a132af	2026-09-21 11:30	2026-09-21 11:30	2026-09-21 11:30	PEP	PEP261120C00130000	call	130.0000	2026-11-20	4.5500	4.5500	4.6500	128.4650	91455.00	0.00	91455.00	201	5	321	534	0.601123595505618	0.234037312596447	0.234037312596447	false	false	false	true
72cec851-a2df-4f32-b411-81574fe09738	2026-09-21 11:27	2026-09-21 11:27	2026-09-21 11:27	MO	MO261016C00067500	call	67.5000	2026-10-16	2.2000	2.2000	2.2500	68.4650	50160.00	0.00	50160.00	228	19	305	712	0.428370786516854	0.219978066973803	0.219978066973803	false	false	false	true
b205ad59-fa1c-4a7a-8ceb-5c18c9e18d29	2026-09-21 11:25	2026-09-21 11:25	2026-09-21 11:25	CAG	CAG261218C00016000	call	16.0000	2026-12-18	0.6000	0.5000	0.6000	15.0900	55800.00	55800.00	0.00	930	24	1158	5924	0.195476029709656	0.309330216088382	0.306527090402142	false	false	false	true
3311b375-f875-4aaa-a46d-e6854588f383	2026-09-21 11:25	2026-09-21 11:25	2026-09-21 11:25	MO	MO261120P00065000	put	65.0000	2026-11-20	1.1300	1.1200	1.1300	68.4901	11300.00	113.00	0.00	100	20	154	58	2.6551724137931	0.245706869653748	0.245706869653748	false	false	false	true
d86f3c56-424e-4f30-9138-97836d764341	2026-09-21 11:16	2026-09-21 11:16	2026-09-21 11:16	CALM	CALM261016P00075000	put	75.0000	2026-10-16	4.4500	3.9000	4.5000	72.6100	22266.00	22266.00	0.00	50	7	108	391	0.276214833759591	0.425211112499819	0.419953933997562	false	false	false	true
b330c618-be8c-4406-93f4-1b966e291c58	2026-09-21 10:43	2026-09-21 10:43	2026-09-21 10:43	CAG	CAG261016C00016000	call	16.0000	2026-10-16	0.2500	0.2000	0.3000	15.0000	18750.00	1500.00	14325.00	750	43	810	952	0.850840336134454	0.347419064914647	0.349614570682875	true	false	false	true
57e8a561-39e5-4d5c-85c2-1d61c2bc97eb	2026-09-21 10:36	2026-09-21 10:36	2026-09-21 10:36	PEP	PEP270115P00140000	put	140.0000	2027-01-15	13.8000	13.8000	13.9000	128.6850	13800.00	0.00	1380.00	10	10	42	2484	0.0169082125603865	0.274778740190483	0.274778740190483	false	false	false	true
4e13bed2-1105-4922-9b8c-f5614fff5a01	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	PEP	PEP261016C00130000	call	130.0000	2026-10-16	2.9500	2.9500	3.0000	128.5600	14752.00	0.00	14752.00	50	9	693	981	0.706422018348624	0.257960664247742	0.257212553118499	false	false	false	true
3b371f1d-a99d-4652-afe9-70dea1a87056	2026-09-18 15:46	2026-09-18 15:46	2026-09-18 15:46	GIS	GIS261016C00037500	call	37.5000	2026-10-16	0.9500	0.9000	0.9500	36.4950	37430.00	37430.00	0.00	394	30	1206	9725	0.12401028277635	0.330608979750787	0.330608979750787	false	false	false	true
93746721-2644-4d45-b48c-6ce28d5e1f74	2026-09-18 14:26	2026-09-18 14:26	2026-09-18 14:26	GIS	GIS261016P00037500	put	37.5000	2026-10-16	2.1000	2.0000	2.1000	36.7650	45764.00	45764.00	0.00	218	34	13985	14669	0.953371054604949	0.432873197318137	0.432873197318137	false	false	false	true
b6309627-0c6c-4211-bfd0-7e0cca46324b	2026-09-18 14:19	2026-09-18 14:19	2026-09-18 14:19	PEP	PEP260918P00145000	put	145.0000	2026-09-18	14.7900	14.7500	15.0000	130.1600	167134.00	0.00	167134.00	113	5	259	1142	0.226795096322242	4.56998501610046	4.59671567126774	false	false	false	true
be60b681-361a-4c58-a338-33d2897eea71	2026-09-18 13:52	2026-09-18 13:52	2026-09-18 13:52	CAG	CAG270115P00016000	put	16.0000	2027-01-15	1.5500	1.5500	1.6500	15.2050	106020.00	0.00	106020.00	684	22	684	1196	0.57190635451505	0.350687665682959	0.352237114765867	false	false	false	true
593a967f-62ff-4b41-8761-30eae4a14a56	2026-09-18 13:39	2026-09-18 13:39	2026-09-18 13:39	GIS	GIS270115C00037500	call	37.5000	2027-01-15	2.4500	2.4500	2.5500	36.9400	18375.00	0.00	18375.00	75	14	111	2774	0.0400144196106705	0.294069161587291	0.294069161587291	false	false	false	true
522e7bd0-8ed7-401b-86b6-2ef2bfe90f11	2026-09-18 12:44	2026-09-18 12:44	2026-09-18 12:44	GIS	GIS261016P00037500	put	37.5000	2026-10-16	2.0000	1.9500	2.0500	36.8800	48800.00	45200.00	0.00	244	22	13669	14669	0.931829027200218	0.423179492167592	0.423179492167592	false	false	false	true
611c87a4-2f79-461c-9b10-160e04f45ec3	2026-09-18 11:46	2026-09-18 11:46	2026-09-18 11:46	PEP	PEP270115C00140000	call	140.0000	2027-01-15	3.2000	3.2000	3.3500	130.0300	98240.00	0.00	98240.00	307	17	396	4363	0.0907632363052945	0.211129236966534	0.211129236966534	false	false	false	true
d105fa91-7dd2-4365-a8b8-1ae9bc124720	2026-09-18 10:53	2026-09-18 10:52	2026-09-18 10:52	CALM	CALM261016C00075000	call	75.0000	2026-10-16	3.0000	2.7500	3.0000	73.7775	45596.00	45596.00	0.00	152	29	153	118	1.29661016949153	0.423619534152388	0.423619534152388	false	false	false	true
b4135f25-f8d4-4e8f-9314-b22c63966b94	2026-09-18 09:52	2026-09-18 09:52	2026-09-18 09:52	LW	LW261016P00037500	put	37.5000	2026-10-16	0.2100	0.2000	0.3500	46.1200	296730.00	0.00	296730.00	14130	2	14130	240	58.875	0.524699014693951	0.524699014693951	false	true	false	true
3bef91ff-8c41-45bf-b1bc-03810c89b783	2026-09-18 09:52	2026-09-18 09:52	2026-09-18 09:52	LW	LW261016P00037500	put	37.5000	2026-10-16	0.2100	0.2000	0.3500	46.1200	296730.00	0.00	296730.00	14130	2	14130	240	58.875	0.524699014693951	0.524699014693951	false	true	false	true
90e9242d-3677-4138-b5c5-4e45e8e7efa4	2026-09-18 09:38	2026-09-18 09:38	2026-09-18 09:38	MKC	MKC261016C00050000	call	50.0000	2026-10-16	1.6000	1.4000	1.6500	49.1000	24160.00	19360.00	4800.00	151	5	151	530	0.284905660377358	0.354528419450571	0.357082962909146	false	false	false	true
686c90c1-ad92-441b-8f3d-eb6219393633	2026-09-17 15:25	2026-09-17 15:25	2026-09-17 15:25	GIS	GIS270115P00030000	put	30.0000	2027-01-15	0.6000	0.6000	0.6500	36.7950	32651.00	0.00	32651.00	544	41	636	2854	0.222845129642607	0.380979013721801	0.380979013721801	false	false	false	true
684fa173-66ee-4413-9da6-08b72a57c518	2026-09-17 14:39	2026-09-17 14:39	2026-09-17 14:39	CALM	CALM260918P00085000	put	85.0000	2026-09-18	11.1000	10.0000	11.2000	74.5400	129870.00	129870.00	0.00	117	2	118	78	1.51282051282051	2.27717977717747	2.27717977717747	false	true	true	false
0c2af9dc-db16-430e-a8c5-f5b0a854f613	2026-09-17 13:06	2026-09-17 13:06	2026-09-17 13:06	CALM	CALM261120C00080000	call	80.0000	2026-11-20	2.8500	2.6000	3.2000	74.7750	10260.00	9975.00	285.00	36	5	36	327	0.110091743119266	0.374827724888782	0.374827724888782	false	false	false	true
039f74dd-cae5-4668-895e-6bfbbf2fab51	2026-09-17 12:21	2026-09-17 12:21	2026-09-17 12:21	GIS	GIS261016P00035000	put	35.0000	2026-10-16	0.9000	0.9000	0.9500	36.6599	10800.00	0.00	10800.00	120	14	177	5039	0.0351260170668783	0.406669815633055	0.406669815633055	true	false	false	true
df87a575-8984-42ce-9828-533ab60a3d99	2026-09-17 12:11	2026-09-17 12:10	2026-09-17 12:10	GIS	GIS280121C00035000	call	35.0000	2028-01-21	6.3000	6.1000	6.3000	36.6350	14490.00	14490.00	0.00	23	6	25	1737	0.0143926309729419	0.2579557064239	0.2579557064239	false	false	false	true
7ed61b1e-ed12-49fb-9e01-ac73ef4842a2	2026-09-17 11:37	2026-09-17 11:36	2026-09-17 11:36	GIS	GIS261218P00035000	put	35.0000	2026-12-18	1.7500	1.7500	1.8500	36.6400	108675.00	0.00	108675.00	621	33	837	3461	0.241837619185207	0.369782588778734	0.369782588778734	false	false	false	true
db85d3a4-5f40-40d3-a9d8-81d473792c4d	2026-09-17 11:02	2026-09-17 11:02	2026-09-17 11:02	PEP	PEP261009C00132000	call	132.0000	2026-10-09	4.0500	4.0500	4.2500	132.9350	82215.00	0.00	82215.00	203	32	208	0	0	0.261530925752137	0.261530925752137	false	false	false	true