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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×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	strike

b480ac29-c897-4aca-93f0-36256339843d	2026-09-23 14:08	2026-09-23 14:08	2026-09-23 14:08	MO	MO261016C00067500	call	67.5000	2026-10-16	2.6000	2.6000	2.9400	69.2500	17692.00	0.00	17692.00	68	6	136	839	0.162097735399285	0.21091744779928	0.217624601258123	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Defensive	115128843698.00	2026-10-29	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T18:11:21.793472Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
b17b76dc-87bf-4c9c-abc6-4910a68f0b49	2026-09-23 13:06	2026-09-23 13:06	2026-09-23 13:06	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.4800	2.4600	2.6300	129.4500	77750.00	0.00	77750.00	314	27	18836	3266	5.76729944886712	0.229757803994057	0.230756877201365	true	false	false
6763bcdb-094d-497a-b7d2-bcfd37158ce9	2026-09-23 13:04	2026-09-23 13:04	2026-09-23 13:04	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.5500	2.3900	2.5500	129.6000	16558.00	16558.00	0.00	65	5	18189	3266	5.56919779546846	0.231513232463217	0.231974937441711	false	false	false
471a747b-e57f-4ce7-9d49-95f135b2eacf	2026-09-23 13:04	2026-09-23 13:04	2026-09-23 13:04	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.5500	2.5200	2.6100	129.6000	61437.00	12732.00	44370.00	241	19	18036	3266	5.52235150030619	0.231513232463217	0.231974937441711	false	false	false
33bd6888-c04d-41fe-ac1a-10f2ff15a44d	2026-09-23 13:04	2026-09-23 13:04	2026-09-23 13:04	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.5500	2.5200	2.5800	129.6400	14777.00	8912.00	5610.00	58	6	17575	3266	5.38120024494795	0.230971054036699	0.231432313159475	false	false	false
c0acba39-5acc-439f-b452-ba710bebd222	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.6400	2.6000	2.6900	129.9900	39650.00	13250.00	26400.00	150	7	16054	3266	4.91549295774648	0.230775947532707	0.231230276309305	false	false	false
7a2294ad-7855-4632-bd4b-a41c4d318039	2026-09-23 12:10	2026-09-23 12:10	2026-09-23 12:10	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.5400	2.4600	2.5600	129.6602	108602.00	108347.00	0.00	427	23	14497	3266	4.43876301285977	0.230697159841784	0.23115819379372	false	false	false
81d06a2e-e0aa-4ff4-831d-bb00aa0c4a0a	2026-09-23 12:02	2026-09-23 12:02	2026-09-23 12:02	PG	PG261120C00160000	call	160.0000	2026-11-20	0.9500	0.9500	1.0600	147.3300	45416.00	196.00	45220.00	478	46	1205	5026	0.23975328292877	0.188595189689356	0.191426290890813	true	false	false
1be18fc4-685d-4776-b67f-1e58db6d60b9	2026-09-23 12:01	2026-09-23 12:01	2026-09-23 12:01	LW	LW261016P00045000	put	45.0000	2026-10-16	2.2900	2.1000	2.3000	45.0900	57260.00	57260.00	0.00	250	25	274	571	0.479859894921191	0.521934171216685	0.533062808028765	false	false	false
c0597ec7-3933-44f5-81b5-7fa8f1f270e2	2026-09-23 11:42	2026-09-23 11:42	2026-09-23 11:42	PEP	PEP280121P00095000	put	95.0000	2028-01-21	2.4600	2.4500	2.8400	130.0000	12299.00	0.00	12299.00	50	12	100	318	0.314465408805031	0.294846421768668	0.295224456023523	false	false	false
38668230-05af-4b30-b013-820b6d047631	2026-09-23 11:42	2026-09-23 11:42	2026-09-23 11:42	PEP	PEP280121P00095000	put	95.0000	2028-01-21	2.4800	2.4400	2.8400	130.0000	28809.00	10410.00	18399.00	116	22	216	318	0.679245283018868	0.294998700268907	0.296921729795996	false	false	false
7053d06d-e0f8-440d-a81c-69a9268e0b61	2026-09-23 11:42	2026-09-23 11:42	2026-09-23 11:42	PEP	PEP280121P00095000	put	95.0000	2028-01-21	2.3300	2.2700	2.8400	130.0000	11662.00	0.00	11662.00	50	6	50	318	0.157232704402516	0.288013093943591	0.294164285061644	false	false	false
f9b9b3ed-1e3c-42ed-97b7-262adf412f0e	2026-09-23 11:32	2026-09-23 11:31	2026-09-23 11:31	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.4700	2.4100	2.5300	129.8150	63344.00	2728.00	42512.00	256	14	8409	3266	2.57470912431108	0.223058616683949	0.225833401596482	false	false	false
842aa425-8ee5-4552-a636-b851981857bf	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	PG	PG261016C00155000	call	155.0000	2026-10-16	0.5900	0.5700	0.6500	147.9900	15491.00	1215.00	14276.00	262	20	499	14358	0.0347541440312021	0.176386493671788	0.177459838816263	true	false	false
886bd5a9-f5fc-437f-a164-6648771ace34	2026-09-23 10:29	2026-09-23 10:28	2026-09-23 10:28	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.7500	2.6600	2.7600	130.6400	78834.00	51334.00	7150.00	287	20	6618	3266	2.0263319044703	0.225721687436974	0.226724368310538	false	false	false
a3fbee88-98e3-4937-80dd-3abf6c565429	2026-09-23 09:56	2026-09-23 09:56	2026-09-23 09:56	GIS	GIS261120C00032500	call	32.5000	2026-11-20	2.8400	2.7500	2.9500	34.6250	13897.00	0.00	11902.00	49	6	49	107	0.457943925233645	0.254624508247597	0.254624508247597	false	false	false
ada8efff-06a6-4192-bb14-461a7419489d	2026-09-22 15:54	2026-09-22 15:54	2026-09-22 15:54	PEP	PEP270115C00145000	call	145.0000	2027-01-15	2.2600	2.1900	2.3100	131.0000	25568.00	14218.00	11350.00	113	10	181	1598	0.113266583229036	0.212306306487076	0.213151961141257	false	false	false
e2f87bdd-00ba-4ed8-b4b3-77165a5e55bf	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	PM	PM261120C00200000	call	200.0000	2026-11-20	5.4000	5.4000	5.8000	191.9300	90209.00	0.00	90209.00	167	46	209	1813	0.115278543849972	0.266509013547869	0.266509013547869	true	false	false
546258fb-3614-4afd-8ff6-d8590d60f027	2026-09-22 15:15	2026-09-22 15:15	2026-09-22 15:15	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.6700	2.6700	2.7300	131.0650	25629.00	0.00	5337.00	96	9	1009	940	1.07340425531915	0.21532043558249	0.21532043558249	false	false	false
25e54a76-141e-4a51-a393-44c87319e131	2026-09-22 15:12	2026-09-22 15:12	2026-09-22 15:12	PEP	PEP261218C00140000	call	140.0000	2026-12-18	2.6200	2.6200	2.6900	130.9900	10496.00	0.00	9707.00	40	6	198	940	0.21063829787234	0.214596462221653	0.215037782045299	false	false	false
1bd35f45-f0b5-4ea1-bd17-d24cffe263f2	2026-09-22 14:51	2026-09-22 14:51	2026-09-22 14:51	PEP	PEP261120C00135000	call	135.0000	2026-11-20	3.4500	3.4000	3.4500	130.7300	13099.00	13099.00	0.00	38	8	669	1218	0.549261083743842	0.232999017125329	0.233488171296347	false	false	false
ff38a7a1-8c8b-4a42-a2f1-70c6c2a15834	2026-09-22 14:09	2026-09-22 14:09	2026-09-22 14:09	GIS	GIS261016C00040000	call	40.0000	2026-10-16	0.1500	0.1500	0.2000	35.5950	52484.00	0.00	52484.00	3498	49	4573	7674	0.595908261662757	0.341923335405324	0.341923335405324	false	false	false
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
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
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
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
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
ce7d5992-b360-4650-b251-6e5866746965	2026-09-15 15:27	2026-09-15 15:27	2026-09-15 15:27	CCEP	CCEP270219P00100000	put	100.0000	2027-02-19	4.5800	4.3000	4.6000	103.4300	32026.00	30226.00	0.00	70	21	303	26	11.6538461538462	0.253783885057329	0.257752000510563	false	false	false
0a84efb4-ea10-4397-b188-6001a6f5b641	2026-09-15 09:38	2026-09-15 09:37	2026-09-15 09:37	GIS	GIS261218C00037500	call	37.5000	2026-12-18	1.9500	1.7500	1.9500	35.9300	27283.00	27283.00	0.00	140	6	156	2244	0.0695187165775401	0.337241690384588	0.337241690384588	false	false	false
60282e73-a363-43a7-8bb6-e7f7eebcde55	2026-09-14 15:49	2026-09-14 15:49	2026-09-14 15:49	MKC	MKC261016P00050000	put	50.0000	2026-10-16	2.1000	2.1000	2.1500	50.0000	21002.00	0.00	21002.00	100	9	187	1590	0.117610062893082	0.392424977317067	0.395637154683038	false	false	false
559fac80-799a-45cd-9f15-e79d7a87a2df	2026-09-14 13:47	2026-09-14 13:47	2026-09-14 13:47	GIS	GIS270115C00042500	call	42.5000	2027-01-15	1.0500	0.9500	1.0500	36.5500	15434.00	15434.00	0.00	147	11	1541	1411	1.0921332388377	0.329725111056867	0.331155070425047	false	false	false
95f4b581-bb7d-4ab6-a7ce-70101d5aa056	2026-09-11 10:06	2026-09-11 10:06	2026-09-11 10:06	CAG	CAG270319C00015000	call	15.0000	2027-03-19	1.1500	1.0500	1.4000	14.5300	12700.00	5340.00	7360.00	110	7	113	947	0.119324181626188	0.290810068630183	0.291438804314858	false	false	false
23f339c7-dd95-4c9b-ad4a-0f25d28c5221	2026-09-11 10:03	2026-09-11 10:03	2026-09-11 10:03	MKC	MKC261016C00050000	call	50.0000	2026-10-16	3.3300	2.6000	3.5000	51.0000	13670.00	13670.00	0.00	41	9	41	356	0.115168539325843	0.439409921923613	0.460469994453739	true	false	false
2db4f0ef-c95c-4bb4-9400-afd52e7d9aca	2026-09-09 10:27	2026-09-09 10:27	2026-09-09 10:27	CAG	CAG270115C00015000	call	15.0000	2027-01-15	1.4000	1.4000	1.5000	15.0000	351840.00	0.00	351840.00	2513	45	2514	7547	0.333112495031138	0.301709936756686	0.310618685360701	false	false	false
13741c19-b0c6-4493-a372-183c0f03a6d2	2026-09-09 09:36	2026-09-09 09:36	2026-09-09 09:36	MO	MO270115C00077500	call	77.5000	2027-01-15	0.7300	0.6100	1.0000	67.4400	54083.00	10753.00	17501.00	745	95	7212	14383	0.501425293749565	0.207487390938937	0.211414398310653	true	false	false
127d7a13-a7a0-4d8b-a9e6-f9115aa32044	2026-09-09 09:35	2026-09-09 09:35	2026-09-09 09:35	MO	MO270115C00077500	call	77.5000	2027-01-15	0.7900	0.7300	0.8000	67.5600	80578.00	49320.00	0.00	1021	56	3021	14383	0.21003963011889	0.212257947360187	0.21415879701004	false	false	false
6d665783-8f11-4941-90fc-7e45eb916f78	2026-09-09 09:34	2026-09-09 09:34	2026-09-09 09:34	MO	MO270115C00077500	call	77.5000	2027-01-15	0.8100	0.7300	0.8200	67.6599	76666.00	38677.00	0.00	941	35	1302	14383	0.0905235347284989	0.213379253711634	0.214315658859736	false	false	false
c8accace-521f-4b6e-bfe7-839e44438541	2026-09-08 10:31	2026-09-08 10:31	2026-09-08 10:31	GIS	GIS260918C00040000	call	40.0000	2026-09-18	0.1500	0.1500	0.2000	37.2300	25866.00	18.00	25848.00	1720	49	2036	12048	0.168990703851262	0.373630072479518	0.373630072479518	false	false	false
c3dbc5f0-3904-4222-874f-942b012c41b2	2026-09-08 09:34	2026-09-08 09:34	2026-09-08 09:34	MKC	MKC270115C00060000	call	60.0000	2027-01-15	1.0100	0.9000	1.0500	51.4000	51810.00	15445.00	6000.00	511	31	3745	6951	0.53877139979859	0.279664147377001	0.285145582680227	false	false	false
0d8d2f85-5636-479d-a95f-76b44478f067	2026-09-04 10:02	2026-09-04 10:02	2026-09-04 10:02	PEP	PEP270115C00160000	call	160.0000	2027-01-15	1.5600	1.5100	1.5700	138.6500	71690.00	10342.00	0.00	459	33	2573	4696	0.547913117546848	0.21224978947542	0.212715774258679	false	false	false
9db70d43-cf7d-47b6-a3ca-50dbcdea5845	2026-09-03 09:55	2026-09-03 09:55	2026-09-03 09:55	GIS	GIS260918C00037500	call	37.5000	2026-09-18	1.7400	1.5000	1.7500	38.7100	15276.00	15276.00	0.00	88	6	253	5086	0.0497443963822257	0.313717257043662	0.313717257043662	false	false	false
d2c25d9c-6caf-4c2a-ae81-27a0da438609	2026-09-01 14:32	2026-09-01 14:32	2026-09-01 14:32	GIS	GIS270319C00045000	call	45.0000	2027-03-19	2.1600	2.1500	2.3000	41.0550	29143.00	0.00	29143.00	135	8	154	627	0.245614035087719	0.273546080328419	0.273546080328419	false	false	false
f394fd1b-2dae-4dc4-b53a-738ae67be4ec	2026-09-01 11:34	2026-09-01 11:34	2026-09-01 11:34	GIS	GIS260918P00037500	put	37.5000	2026-09-18	0.1400	0.1000	0.1500	41.3600	40132.00	39872.00	260.00	2870	8	2972	6598	0.450439527129433	0.328006635501808	0.328006635501808	false	false	false
1a05e0a5-7fa5-4c41-8a10-b358c8825335	2026-09-01 10:15	2026-09-01 10:15	2026-09-01 10:15	CAG	CAG270115C00016000	call	16.0000	2027-01-15	1.5000	1.2500	1.5000	16.2100	40188.00	40188.00	0.00	268	12	500	2256	0.221631205673759	0.314912308536909	0.325342845088796	false	false	false
eef9e2a7-69d8-4537-a1d6-088c72e13c2d	2026-08-27 15:29	2026-08-27 15:29	2026-08-27 15:29	PEP	PEP261016C00140000	call	140.0000	2026-10-16	4.5000	4.5000	4.6000	140.0000	227294.00	0.00	227294.00	505	44	540	1259	0.428911834789516	0.195661117759242	0.195661117759242	false	false	false
67ce3c45-4491-47d8-91b3-d5f8cd73e9ba	2026-08-27 12:15	2026-08-27 12:15	2026-08-27 12:15	GIS	GIS261016P00040000	put	40.0000	2026-10-16	1.8500	1.8000	1.9000	40.3600	167592.00	163724.00	3683.00	906	24	912	1130	0.807079646017699	0.357126582974811	0.358829961600821	false	false	false
357c1836-1201-41e2-a3e4-70624b10902f	2026-08-26 13:45	2026-08-26 13:44	2026-08-26 13:44	GIS	GIS280121C00040000	call	40.0000	2028-01-21	5.9000	5.8000	6.1000	40.2300	22412.00	0.00	22412.00	38	5	38	2463	0.0154283394234673	0.24144637700628	0.248192085247569	false	false	false
56c9c68b-11eb-433f-97ef-f6816235540e	2026-08-25 15:15	2026-08-25 15:15	2026-08-25 15:15	GIS	GIS261016C00037500	call	37.5000	2026-10-16	3.3900	3.3000	3.5000	39.9300	13224.00	0.00	12204.00	39	5	444	2136	0.207865168539326	0.30491340338006	0.30491340338006	false	false	false
fefc84f6-66d8-4885-971b-3a8ca03b4c42	2026-08-25 11:41	2026-08-25 11:41	2026-08-25 11:41	CCEP	CCEP261016C00115000	call	115.0000	2026-10-16	1.5200	1.2500	1.5500	110.0300	24925.00	6175.00	0.00	164	32	164	0	0	0.190515663302092	0.193931958603291	false	false	false
3b20cec6-c814-43a3-b74e-9949e3a5e04e	2026-08-24 15:16	2026-08-24 15:16	2026-08-24 15:16	PEP	PEP261218C00155000	call	155.0000	2026-12-18	3.4000	3.4000	3.5500	144.5500	239072.00	0.00	239072.00	703	42	1132	3010	0.376079734219269	0.204492487556854	0.204492487556854	false	false	false