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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 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 = TE×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

69f57d5e-508c-4f6b-9325-5eb45d7b7d90	2026-08-17 09:30	2026-08-17 09:30	2026-08-17 09:30	TE	TE270115C00010000	call	10.0000	2027-01-15	0.7500	0.7500	0.7500	5.1500	19275.00	0.00	0.00	257	8	263	11501	0.022867576732458	1.33078493548626	1.33078493548626	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	1287083278.00	2026-11-13	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
929008eb-131e-482f-a54d-a6e944489c63	2026-08-17 12:21	2026-08-17 12:21	2026-08-17 12:21	TE	TE280121C00020000	call	20.0000	2028-01-21	1.3500	1.3500	1.4500	4.9600	63450.00	0.00	35775.00	470	34	610	4901	0.124464395021424	1.29487222650182	1.29585890950747	false	false	false	true
185e7935-42a7-4741-af92-5ce65134cc63	2026-08-18 14:07	2026-08-18 14:06	2026-08-18 14:06	TE	TE270115C00004000	call	4.0000	2027-01-15	1.6500	1.6500	1.8000	4.5800	42570.00	0.00	42570.00	258	6	287	1746	0.164375715922108	1.22953696968997	1.22953696968997	false	false	false	true
439b1080-5627-4468-95e1-bfc5d38c792a	2026-08-19 11:31	2026-08-19 11:31	2026-08-19 11:31	TE	TE261016C00005000	call	5.0000	2026-10-16	0.7000	0.6000	0.7000	4.4700	13930.00	13930.00	0.00	199	6	429	3111	0.137897782063645	1.25108025102469	1.25108025102469	false	false	false	true
25defd66-de2a-4ae4-86e7-df46299fafbc	2026-08-19 11:33	2026-08-19 11:33	2026-08-19 11:33	TE	TE261218P00005000	put	5.0000	2026-12-18	1.5500	1.5500	1.6000	4.4750	14260.00	0.00	14260.00	92	5	138	3159	0.043684710351377	1.23597938142208	1.23597938142208	false	false	false	true
ada61e77-ef75-418b-bf8b-4fa83040a822	2026-08-20 15:56	2026-08-20 15:56	2026-08-20 15:56	TE	TE270115P00004000	put	4.0000	2027-01-15	1.1000	0.9000	1.2000	4.3450	55000.00	54890.00	0.00	500	16	1118	1929	0.579574909279419	1.26443436360981	1.26443436360981	false	false	false	true
c82555fb-e4c2-4180-add9-5cd09642e42d	2026-08-21 11:16	2026-08-21 11:16	2026-08-21 11:16	TE	TE270115P00004000	put	4.0000	2027-01-15	1.0000	1.0000	1.1000	4.4850	66900.00	0.00	66900.00	669	10	2000	3252	0.615006150061501	1.20773468168553	1.20773468168553	false	false	false	true
9e03cd85-e1db-4250-b795-4bb14de380b5	2026-08-21 11:16	2026-08-21 11:16	2026-08-21 11:16	TE	TE270115P00004000	put	4.0000	2027-01-15	1.0000	1.0000	1.1000	4.4800	16500.00	0.00	16500.00	165	8	1248	3252	0.383763837638376	1.20624464968739	1.20624464968739	false	false	false	true
654f9778-c4da-4e33-a379-018fd5fcb763	2026-08-21 11:19	2026-08-21 11:19	2026-08-21 11:19	TE	TE260918C00006000	call	6.0000	2026-09-18	0.1900	0.1500	0.2000	4.5150	19000.00	19000.00	0.00	1000	8	1050	13095	0.0801832760595647	1.20129937464001	1.20129937464001	false	false	false	true
c209a7a8-5843-4ade-81c5-efbca4fa5deb	2026-08-21 13:43	2026-08-21 13:42	2026-08-21 13:42	TE	TE280121C00020000	call	20.0000	2028-01-21	1.1000	1.0500	1.1500	4.4438	47080.00	0.00	46970.00	428	19	430	4838	0.0888797023563456	1.29286206403531	1.29286206403531	false	false	false	true
571a4d05-6536-4dbd-8fad-c4224becb058	2026-08-21 14:11	2026-08-21 14:11	2026-08-21 14:11	TE	TE280121C00020000	call	20.0000	2028-01-21	1.0500	1.0500	1.1500	4.0000	99750.00	0.00	99750.00	950	7	1954	4838	0.403885903265812	1.27466194797506	1.27466194797506	false	false	false	true
97724b05-0a4f-43f1-8d30-708b494e29fc	2026-08-24 09:35	2026-08-24 09:35	2026-08-24 09:35	TE	TE260828C00004000	call	4.0000	2026-08-28	0.4000	0.3000	0.4000	4.3200	180000.00	180000.00	0.00	4500	5	4500	293	15.358361774744	1.14810523431063	1.14810523431063	false	false	false	true
a740e708-c010-42d3-ba5b-fe3c8e353a9c	2026-08-24 09:37	2026-08-24 09:37	2026-08-24 09:37	TE	TE261218C00005000	call	5.0000	2026-12-18	0.9500	0.9500	1.1000	4.3550	10450.00	0.00	10450.00	110	13	110	1160	0.0948275862068965	1.19049222263368	1.19049222263368	false	false	false	true
c9724cfb-1054-43fb-bd74-98b768c99a77	2026-08-24 11:45	2026-08-24 11:45	2026-08-24 11:45	TE	TE261016P00005000	put	5.0000	2026-10-16	1.0500	1.0500	1.2000	4.3950	10500.00	0.00	10500.00	100	5	300	1952	0.153688524590164	1.0259484369296	1.0259484369296	false	false	false	true
ffffba6a-8c97-4a68-a3fa-8e9314091259	2026-08-24 11:51	2026-08-24 11:50	2026-08-24 11:50	TE	TE280121C00010000	call	10.0000	2028-01-21	1.6500	1.6500	1.7500	4.4000	32836.00	0.00	32836.00	199	5	278	8134	0.0341775264322597	1.26664333145293	1.27306908658331	false	false	false	true
7be375d7-8795-41e1-bf9d-c4a4669ae9fc	2026-08-24 15:06	2026-08-24 15:06	2026-08-24 15:06	TE	TE261016P00005000	put	5.0000	2026-10-16	1.1000	1.1000	1.2000	4.3499	11000.00	0.00	11000.00	100	5	552	1952	0.282786885245902	1.06419539177812	1.06419539177812	false	false	false	true
b456abbb-2c8b-4e08-a160-417209b8db51	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	TE	TE260828C00004000	call	4.0000	2026-08-28	0.6500	0.6000	0.7000	4.6450	292629.00	157820.00	134809.00	4502	18	4766	4846	0.98349153941395	1.5448373090366	0.869699766369311	true	false	false	true
a359c115-0ce2-479b-91b1-6208a80033cb	2026-08-25 13:22	2026-08-25 13:22	2026-08-25 13:22	TE	TE280121C00005000	call	5.0000	2028-01-21	2.6500	2.5500	2.6500	4.7150	10070.00	10070.00	0.00	38	5	303	5756	0.052640722724114	1.30659519076129	1.30659519076129	false	false	false	true
d6a8bc67-6bef-4d29-ab61-23ca924b6719	2026-08-25 13:23	2026-08-25 13:23	2026-08-25 13:23	TE	TE270115C00005000	call	5.0000	2027-01-15	1.3000	1.3000	1.3500	4.7150	47840.00	0.00	47840.00	368	8	1158	5303	0.218366962096926	1.19197742488686	1.19197742488686	false	false	false	true
6bed722c-9605-4d22-8e7f-318b6fc148a3	2026-08-25 15:05	2026-08-25 15:05	2026-08-25 15:05	TE	TE280121C00010000	call	10.0000	2028-01-21	1.8000	1.7500	1.9000	4.6500	37440.00	0.00	37260.00	208	8	823	8370	0.0983273596176822	1.26881777658275	1.26881777658275	false	false	false	true
14a6a44d-7068-4146-bab1-0fc033f28077	2026-08-26 11:16	2026-08-26 11:16	2026-08-26 11:16	TE	TE260918C00006000	call	6.0000	2026-09-18	0.1500	0.1000	0.1500	4.4699	15000.00	15000.00	0.00	1000	9	1025	14222	0.0720714386162284	1.24125364350595	1.24125364350595	false	false	false	true
848219ce-95c6-4882-829f-98af74540b70	2026-08-26 13:38	2026-08-26 13:38	2026-08-26 13:38	TE	TE260911C00006000	call	6.0000	2026-09-11	0.1000	0.0500	0.1000	4.5500	10000.00	10000.00	0.00	1000	19	1014	977	1.03787103377687	1.23910331649261	1.23910331649261	false	false	false	true
5a504aca-bf65-4e30-a51c-a126390ef7ec	2026-08-27 11:15	2026-08-27 11:15	2026-08-27 11:15	TE	TE261002C00006000	call	6.0000	2026-10-02	0.4000	0.3500	0.4000	4.9650	20000.00	20000.00	0.00	500	20	583	108	5.39814814814815	1.18787247790765	1.18787247790765	false	false	false	true
88a66248-de0d-4228-a0ed-40a08532f7d0	2026-08-27 11:15	2026-08-27 11:15	2026-08-27 11:15	TE	TE260918P00005000	put	5.0000	2026-09-18	0.5500	0.5500	0.6000	4.9899	14795.00	0.00	14795.00	269	6	649	6727	0.096476884198008	1.13051006322378	1.13051006322378	false	false	false	true
4002ced8-940d-45a4-aa0f-188d03dda081	2026-08-27 11:15	2026-08-27 11:15	2026-08-27 11:15	TE	TE280121C00012000	call	12.0000	2028-01-21	1.7500	1.7500	1.9500	4.9750	15615.00	0.00	15615.00	89	9	140	2826	0.0495399858457183	1.25065966557715	1.25065966557715	false	false	false	true
db754ccd-9c0b-45fb-9fba-73c6d20cca77	2026-08-27 11:17	2026-08-27 11:17	2026-08-27 11:17	TE	TE280121P00003000	put	3.0000	2028-01-21	1.1500	1.1500	1.2000	4.9900	30825.00	0.00	30825.00	268	31	269	949	0.28345626975764	1.24436928936025	1.24436928936025	true	false	false	true
4f7005dc-42bc-41fd-9b37-accfbbb0075a	2026-08-28 09:45	2026-08-28 09:45	2026-08-28 09:45	TE	TE261016C00006000	call	6.0000	2026-10-16	0.5500	0.5000	0.5500	5.0700	55000.00	55000.00	0.00	1000	10	1166	2859	0.407834907310248	1.16580760845744	1.16580760845744	false	false	false	true
b08b4075-87ff-4077-b753-85420505e60c	2026-08-28 15:07	2026-08-28 15:07	2026-08-28 15:07	TE	TE260904C00005000	call	5.0000	2026-09-04	0.2000	0.1500	0.2000	4.7850	10000.00	10000.00	0.00	500	12	2355	2600	0.905769230769231	1.08800145697377	1.08800145697377	false	false	false	true
6b2acb66-d9e5-42da-9d49-19364aa23572	2026-08-31 09:39	2026-08-31 09:39	2026-08-31 09:39	TE	TE261218C00008000	call	8.0000	2026-12-18	0.4500	0.4500	0.5000	4.6321	22500.00	0.00	22500.00	500	10	524	1556	0.336760925449871	1.20028500636917	1.20028500636917	false	false	false	true
c61ffe4a-9190-45da-83df-eb2ccd873ec0	2026-08-31 13:03	2026-08-31 13:03	2026-08-31 13:03	TE	TE280121C00007000	call	7.0000	2028-01-21	2.0000	1.9500	2.0500	4.4550	90000.00	50400.00	0.00	450	8	1326	12528	0.105842911877395	1.25266099580168	1.25266099580168	false	false	false	true
00029266-3353-4a0c-8d7c-6a386f0b1823	2026-08-31 13:04	2026-08-31 13:03	2026-08-31 13:03	TE	TE280121C00007000	call	7.0000	2028-01-21	2.0000	1.9500	2.0000	4.4550	35400.00	35400.00	0.00	177	14	1553	12528	0.123962324393359	1.25266099580168	1.25266099580168	false	false	false	true
f54d5d1a-6bae-4fd0-bca7-51a3488906d1	2026-08-31 13:29	2026-08-31 13:29	2026-08-31 13:29	TE	TE260911C00005000	call	5.0000	2026-09-11	0.1500	0.1000	0.1500	4.4250	14999.00	14999.00	0.00	1000	24	1636	1900	0.861052631578947	1.1265273488785	1.1265273488785	false	false	false	true
726fc72c-9962-49e4-8d5a-96818a279f25	2026-08-31 14:01	2026-08-31 14:01	2026-08-31 14:01	TE	TE260904P00004500	put	4.5000	2026-09-04	0.2500	0.2000	0.2500	4.0000	14550.00	14550.00	0.00	582	18	1578	1308	1.20642201834862	1.06122251226374	1.04270838620039	false	false	false	true
e8b38b81-bfb2-49fb-aef0-d049282f22f9	2026-08-31 15:27	2026-08-31 15:27	2026-08-31 15:27	TE	TE260918C00005500	call	5.5000	2026-09-18	0.1500	0.1000	0.1500	4.4150	14490.00	14490.00	0.00	966	17	1037	644	1.61024844720497	1.19321458475559	1.19321458475559	false	false	false	true
a4d64aa7-cdec-43e9-827a-a5f5a5634985	2026-08-31 15:49	2026-08-31 15:49	2026-08-31 15:49	TE	TE260925C00006000	call	6.0000	2026-09-25	0.1500	0.1000	0.1500	4.3700	15000.00	15000.00	0.00	1000	5	1123	990	1.13434343434343	1.2535920335694	1.2535920335694	false	false	false	true
2b9f83ba-d131-4b60-b318-4c8f4fd0cc71	2026-08-31 15:54	2026-08-31 15:54	2026-08-31 15:54	TE	TE261009C00006000	call	6.0000	2026-10-09	0.2500	0.2000	0.2500	4.4150	34575.00	34575.00	0.00	1383	23	1429	89	16.0561797752809	1.19641860887191	1.19641860887191	false	false	false	true
0ea4e64d-1d70-4fe3-a82b-82848e740a48	2026-09-01 09:39	2026-09-01 09:39	2026-09-01 09:39	TE	TE261218C00011000	call	11.0000	2026-12-18	0.1500	0.1500	0.2000	4.2699	26865.00	0.00	26865.00	1791	27	1791	512	3.498046875	1.20722489515797	1.20722489515797	false	false	false	true
1899c3f8-edf5-41f6-acf9-ce49696a2304	2026-09-01 10:34	2026-09-01 10:34	2026-09-01 10:34	TE	TE260925C00006000	call	6.0000	2026-09-25	0.1500	0.1000	0.1500	4.3750	15000.00	15000.00	0.00	1000	9	1003	1555	0.645016077170418	1.27640637132798	1.27640637132798	false	false	false	true
6b247e30-61c3-425c-82b8-5440fc523ed8	2026-09-02 11:46	2026-09-02 11:46	2026-09-02 11:46	TE	TE260918C00004000	call	4.0000	2026-09-18	0.4000	0.3500	0.4000	4.1000	15080.00	15080.00	0.00	377	11	556	5467	0.101701115785623	1.01972858560401	1.01972858560401	true	false	false	true
ed22a58f-eb76-4bac-bc33-28449ff758c1	2026-09-02 11:47	2026-09-02 11:47	2026-09-02 11:47	TE	TE260918C00004000	call	4.0000	2026-09-18	0.4400	0.4000	0.4500	4.1100	167816.00	167816.00	0.00	3814	5	4370	5467	0.799341503566856	1.12188211227571	1.12188211227571	false	false	false	true
a2fac926-83b9-4f2e-a2b1-7fa5d31a8eb4	2026-09-02 12:17	2026-09-02 12:17	2026-09-02 12:17	TE	TE260925C00004000	call	4.0000	2026-09-25	0.5000	0.4500	0.5500	4.1150	25050.00	24950.00	50.00	501	19	518	66	7.84848484848485	1.07469058862066	1.07469058862066	false	false	false	true
676213a4-010c-4a36-8d2c-6d2eca005025	2026-09-04 12:38	2026-09-04 12:38	2026-09-04 12:38	TE	TE260911C00004500	call	4.5000	2026-09-11	0.3000	0.2500	0.3500	4.6250	38970.00	28260.00	0.00	1299	9	1497	1272	1.17688679245283	0.914172324766329	0.914172324766329	false	false	false	true
efdd6112-2458-4a57-8cb5-84f4a9cf1c35	2026-09-04 13:45	2026-09-04 13:45	2026-09-04 13:45	TE	TE260918C00006000	call	6.0000	2026-09-18	0.1000	0.0500	0.1000	4.6000	15460.00	15460.00	0.00	1546	13	13800	14452	0.954885137005259	1.28718776499998	1.28718776499998	false	false	false	true
d6c3a7a2-c4f3-4744-a69c-72fc2a61ab3c	2026-09-04 13:45	2026-09-04 13:45	2026-09-04 13:45	TE	TE260911C00005000	call	5.0000	2026-09-11	0.1500	0.0500	0.1500	4.6000	18750.00	18750.00	0.00	1250	31	1958	3135	0.624561403508772	1.16574368748288	1.16574368748288	false	false	false	true
46c9fb57-910a-4df9-ab8d-01b17c4fd7de	2026-09-08 09:43	2026-09-08 09:43	2026-09-08 09:43	TE	TE270115C00006000	call	6.0000	2027-01-15	1.0500	1.0000	1.1000	4.9250	41160.00	10500.00	0.00	392	6	557	4589	0.121377206363042	1.18931938632397	1.18931938632397	false	false	false	true
7d7df5f3-13fa-43a6-8f98-0037ae747b4d	2026-09-08 10:30	2026-09-08 10:30	2026-09-08 10:30	TE	TE270115P00005000	put	5.0000	2027-01-15	1.3000	1.2500	1.3000	5.1750	21320.00	21320.00	0.00	164	17	166	1093	0.151875571820677	1.21003316971733	1.21003316971733	false	false	false	true
5464d927-a459-4f06-b633-d1924f070f2e	2026-09-08 10:30	2026-09-08 10:30	2026-09-08 10:30	TE	TE270115C00005000	call	5.0000	2027-01-15	1.5500	1.5000	1.5500	5.1750	207845.00	207845.00	0.00	1341	30	1459	5368	0.271795827123696	1.21464058114847	1.21464058114847	false	false	false	true
7400307f-51fb-4b0f-8260-bec99a142d8a	2026-09-08 11:44	2026-09-08 11:43	2026-09-08 11:43	TE	TE270115C00005000	call	5.0000	2027-01-15	1.6000	1.5500	1.6000	5.2450	31840.00	31840.00	0.00	199	11	1832	5368	0.341281669150522	1.22043829499802	1.21744923644366	false	false	false	true
a6b1602d-111d-4e16-94bb-83a5fd76e9b0	2026-09-08 12:03	2026-09-08 12:03	2026-09-08 12:03	TE	TE261218C00006000	call	6.0000	2026-12-18	1.0800	1.0500	1.1000	5.2750	11448.00	11448.00	0.00	106	5	299	1974	0.151469098277609	1.19813152334557	1.19813152334557	false	false	false	true
047cf12e-01d7-425f-8da1-f9a045bb8b12	2026-09-08 13:57	2026-09-08 13:56	2026-09-08 13:56	TE	TE260918P00005000	put	5.0000	2026-09-18	0.3500	0.3000	0.3500	5.1050	12985.00	12985.00	0.00	371	10	1265	6343	0.199432445215198	1.20969084349221	1.20969084349221	false	false	false	true