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:alert_rule = RepeatedHits×ticker = TE×

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

551beebd-4ad2-4f5d-b872-ad5f5fb64d1d	2026-09-22 10:26	2026-09-22 10:26	2026-09-22 10:26	TE	TE261002C00005000	call	5.0000	2026-10-02	0.1000	0.1000	0.1500	4.0000	50000.00	0.00	50000.00	5000	6	6518	18664	0.349228461208744	1.01580855097503	1.01580855097503	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	1284138008.00	2026-11-13	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T14:27:42.600893Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
3fd502a8-bcb9-406a-9c64-b715a6b3cecd	2026-09-21 16:00	2026-09-21 15:59	2026-09-21 15:59	TE	TE261002C00005000	call	5.0000	2026-10-02	0.2000	0.1500	0.2000	4.0000	88100.00	88100.00	0.00	4405	32	21805	784	27.8125	1.25425346113936	1.25425346113936	true	false	false	true
786bdd35-069b-4d84-8af1-3ae379e41ea4	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	TE	TE261002C00005000	call	5.0000	2026-10-02	0.2000	0.1500	0.2000	4.0000	100000.00	100000.00	0.00	5000	17	17400	784	22.1938775510204	1.27232851194336	1.27232851194336	true	false	false	true
feeafda9-c2eb-4bce-b78a-4d3ee3a441e5	2026-09-21 15:45	2026-09-21 15:45	2026-09-21 15:45	TE	TE261218C00005000	call	5.0000	2026-12-18	0.8000	0.8000	0.8500	4.4550	10800.00	0.00	3280.00	135	22	354	2586	0.136890951276102	1.13220561377653	1.13220561377653	false	false	false	true
b3da27c9-35aa-4ac5-bee7-2f2f00e49eed	2026-09-21 15:27	2026-09-21 15:27	2026-09-21 15:27	TE	TE261016C00005000	call	5.0000	2026-10-16	0.3500	0.3000	0.3500	4.4900	32760.00	32760.00	0.00	936	7	2222	7961	0.279110664489386	1.14951474519749	1.14493739612321	false	false	false	true
f6eaa248-ae0a-4324-8807-75996544a2b4	2026-09-21 11:53	2026-09-21 11:52	2026-09-21 11:52	TE	TE261016C00004500	call	4.5000	2026-10-16	0.5300	0.4500	0.5500	4.5150	26500.00	26500.00	0.00	500	6	565	0	0	1.10231794095672	1.10231794095672	false	false	false	true	false
4bd83fc6-fec4-4e5a-ad80-e3f4a17e16ee	2026-09-21 10:16	2026-09-21 10:16	2026-09-21 10:16	TE	TE261002C00005000	call	5.0000	2026-10-02	0.1500	0.1000	0.1500	4.0000	30000.00	30000.00	0.00	2000	5	8798	784	11.2219387755102	1.19954023549339	1.19954023549339	false	false	false	true
e725d2bd-d399-40db-8b00-20f493481505	2026-09-16 13:59	2026-09-16 13:59	2026-09-16 13:59	TE	TE270115P00003000	put	3.0000	2027-01-15	0.4000	0.4000	0.4500	4.0000	42200.00	0.00	42200.00	1055	7	1055	10898	0.0968067535327583	1.10225456749024	1.10225456749024	false	false	false	true
fa08858a-c663-46f9-a2e3-dd69ee884b9c	2026-09-15 13:22	2026-09-15 13:21	2026-09-15 13:21	TE	TE280121C00010000	call	10.0000	2028-01-21	1.4000	1.4000	1.4500	4.3150	23660.00	0.00	23660.00	169	19	496	9449	0.0524923272303948	1.19321564523389	1.19321564523389	false	false	false	true
8c8b7062-d318-4c01-b017-6cd69307c125	2026-09-15 13:22	2026-09-15 13:21	2026-09-15 13:21	TE	TE280121C00010000	call	10.0000	2028-01-21	1.4000	1.4000	1.4500	4.3109	23660.00	0.00	23660.00	169	16	665	9449	0.070377817758493	1.19435918470162	1.19435918470162	false	false	false	true
faa592d5-5589-4907-8284-d21b3ce2476c	2026-09-15 13:21	2026-09-15 13:21	2026-09-15 13:21	TE	TE280121C00010000	call	10.0000	2028-01-21	1.4000	1.4000	1.4500	4.3200	21700.00	0.00	21700.00	155	21	327	9449	0.0346068367022965	1.19182323059496	1.19182323059496	false	false	false	true
ef02d14a-8db6-4918-990d-d9486aa7b76c	2026-09-15 13:21	2026-09-15 13:21	2026-09-15 13:21	TE	TE280121C00010000	call	10.0000	2028-01-21	1.4000	1.4000	1.4500	4.3250	23100.00	0.00	23100.00	165	6	172	9449	0.0182029844427982	1.19043316601458	1.19043316601458	false	false	false	true
2cb40baf-58f8-484f-8952-0081ed1e8e67	2026-09-14 15:05	2026-09-14 15:05	2026-09-14 15:05	TE	TE261016P00004000	put	4.0000	2026-10-16	0.3500	0.3000	0.4000	4.3600	15330.00	15295.00	0.00	438	6	1233	4757	0.259196972882069	1.05099780067889	1.05099780067889	false	false	false	true
88332cb6-f8b6-4523-8930-85b6c53b8ee8	2026-09-14 14:08	2026-09-14 14:08	2026-09-14 14:08	TE	TE261016P00004000	put	4.0000	2026-10-16	0.3500	0.3500	0.4000	4.3750	17501.00	0.00	17501.00	500	19	714	4757	0.150094597435358	1.0615062074715	1.0615062074715	false	false	false	true
ef9eadba-739b-48a3-9418-d3206ad84038	2026-09-14 10:15	2026-09-14 10:15	2026-09-14 10:15	TE	TE260918P00004000	put	4.0000	2026-09-18	0.0500	0.0500	0.1000	4.0000	23495.00	0.00	23495.00	4699	22	5401	5398	1.00055576139311	1.08947910099624	1.08947910099624	true	false	false	true
4709f7ba-26c4-4a44-bfb6-06aff3deaa66	2026-09-14 10:07	2026-09-14 10:07	2026-09-14 10:07	TE	TE261218C00005000	call	5.0000	2026-12-18	0.8500	0.7500	0.9000	4.3786	25500.00	25500.00	0.00	300	6	583	1793	0.325153374233129	1.1900822970309	1.1900822970309	false	false	false	true
419725fd-4fe4-45dd-a7b3-ae52fa544af2	2026-09-11 14:48	2026-09-11 14:48	2026-09-11 14:48	TE	TE261016P00004000	put	4.0000	2026-10-16	0.2700	0.2500	0.3000	4.5850	13500.00	0.00	13500.00	500	5	561	4193	0.133794419270212	0.979235534642191	0.979235534642191	false	false	false	true
bb440ab9-c1b9-4b08-b848-602c2ad1017c	2026-09-11 10:02	2026-09-11 10:02	2026-09-11 10:02	TE	TE280121C00010000	call	10.0000	2028-01-21	1.6000	1.6000	1.7500	4.6600	40000.00	0.00	40000.00	250	16	321	9683	0.0331508829908086	1.19134188886727	1.19134188886727	false	false	false	true
d7c77d2c-a914-4577-9250-a1f9f8a66ee3	2026-09-10 15:33	2026-09-10 15:33	2026-09-10 15:33	TE	TE270115C00007000	call	7.0000	2027-01-15	0.6500	0.6500	0.7000	4.6150	155610.00	0.00	155610.00	2394	26	2410	6617	0.364213389753665	1.16631363310618	1.16631363310618	false	false	false	true
3ff62f02-6ce3-4889-be74-a79754d5b958	2026-09-10 15:33	2026-09-10 15:33	2026-09-10 15:33	TE	TE270115C00006000	call	6.0000	2027-01-15	0.8500	0.8500	0.9500	4.6150	224912.00	0.00	224912.00	2646	28	2699	4881	0.552960458922352	1.16290039541633	1.16290039541633	false	false	false	true
c32b2762-8458-4792-bbe2-94637828e3d1	2026-09-10 15:21	2026-09-10 15:21	2026-09-10 15:21	TE	TE270617C00005000	call	5.0000	2027-06-17	1.8000	1.8000	1.9000	4.6450	18000.00	0.00	18000.00	100	5	148	2327	0.0636012032660077	1.19739743987228	1.19739743987228	false	false	false	true
5487bcc5-b083-427d-bfff-8b8a131586d1	2026-09-10 14:48	2026-09-10 14:48	2026-09-10 14:48	TE	TE261023C00004000	call	4.0000	2026-10-23	1.0700	1.0000	1.1000	4.6550	10700.00	10700.00	0.00	100	5	101	0	0	1.16157634333171	1.16157634333171	false	false	false	true	false
0b611548-5dd5-4822-97a8-971dd2269d7a	2026-09-09 11:01	2026-09-09 11:01	2026-09-09 11:01	TE	TE280121C00010000	call	10.0000	2028-01-21	1.9000	1.7500	1.9000	4.8250	28500.00	28500.00	0.00	150	5	193	9116	0.0211715664765248	1.28391767426212	1.28391767426212	false	false	false	true
90ade50f-25cb-45e0-b958-4458061bafa6	2026-09-08 15:20	2026-09-08 15:20	2026-09-08 15:20	TE	TE270617C00005000	call	5.0000	2027-06-17	2.1500	2.1500	2.2000	5.0900	25585.00	0.00	25585.00	119	8	626	2269	0.27589246364037	1.21825374106913	1.21825374106913	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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