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:ticker = TPR×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	price

a155cab3-71a8-43fe-a385-7b3a6042110a	2026-08-17 10:55	2026-08-17 10:54	2026-08-17 10:54	TPR	TPR260828P00128000	put	128.0000	2026-08-28	2.7000	2.5000	2.7000	128.5350	13500.00	13500.00	0.00	50	17	52	47	1.1063829787234	0.341149809877274	0.341149809877274	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	23510272753.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
72e4e20c-3a7c-47c7-99a2-b53e1475598e	2026-08-17 13:01	2026-08-17 13:01	2026-08-17 13:01	TPR	TPR260821P00126000	put	126.0000	2026-08-21	1.1000	0.9500	1.1000	128.4800	37603.00	37603.00	0.00	342	49	397	0	0	0.401162331160454	0.401162331160454	false	false	false	true	false
4677b628-1d89-467c-87ec-4d4cf6b695ed	2026-08-17 14:05	2026-08-17 14:05	2026-08-17 14:05	TPR	TPR260828P00122000	put	122.0000	2026-08-28	0.8000	0.6500	0.8000	128.0000	16000.00	16000.00	0.00	200	11	202	0	0	0.354177496357222	0.354177496357222	false	false	false	true	false
ed169ff5-fe3c-4545-97b7-7c6f1339032f	2026-08-17 14:37	2026-08-17 14:37	2026-08-17 14:37	TPR	TPR260828P00131000	put	131.0000	2026-08-28	4.5000	4.2000	4.5000	128.3900	12600.00	12600.00	0.00	28	10	35	5	7	0.347221530913553	0.347221530913553	false	false	false	true	false
dd3b26a8-cf39-495c-a6a1-ed87fbf5c2f5	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	TPR	TPR260821C00134000	call	134.0000	2026-08-21	2.3000	1.4000	2.3000	133.0000	30588.00	30588.00	0.00	133	30	156	535	0.291588785046729	0.488112214974893	0.488112214974893	false	false	false	true	false
1270432c-80ca-4ecb-ab12-76eaf89e3be5	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	TPR	TPR260821C00134000	call	134.0000	2026-08-21	2.3000	1.4500	2.6500	133.0000	29440.00	25300.00	4140.00	128	6	284	535	0.530841121495327	0.488112214974893	0.488112214974893	false	false	false	true	false
d4515dda-820d-4946-9e96-49b0f2a9f819	2026-08-18 09:45	2026-08-18 09:45	2026-08-18 09:45	TPR	TPR260821C00134000	call	134.0000	2026-08-21	2.9000	1.5000	2.9000	134.0000	69310.00	69310.00	0.00	239	6	530	535	0.990654205607477	0.553684458550141	0.553684458550141	false	false	false	true	false
85436fcf-0a90-4943-b591-69a1a3d82679	2026-08-18 10:24	2026-08-18 10:24	2026-08-18 10:24	TPR	TPR260821P00130000	put	130.0000	2026-08-21	0.6000	0.6000	0.6500	134.3400	12780.00	0.00	12780.00	213	12	324	1527	0.212180746561886	0.440128040936537	0.440128040936537	false	false	false	true	false
06927ad9-806e-48f0-a64d-e98cc7899ba7	2026-08-18 11:31	2026-08-18 11:30	2026-08-18 11:30	TPR	TPR270115C00160000	call	160.0000	2027-01-15	5.2000	5.0000	5.5000	133.8900	16120.00	13520.00	2600.00	31	8	31	124	0.25	0.3752454024735	0.3752454024735	false	false	false	true	false
d0b66db5-fb7b-4c2e-a23e-fa54260acd11	2026-08-18 12:31	2026-08-18 12:31	2026-08-18 12:31	TPR	TPR270319P00130000	put	130.0000	2027-03-19	13.7000	13.2000	14.3000	134.2750	26030.00	20550.00	5480.00	19	7	19	11	1.72727272727273	0.431348956935356	0.431348956935356	false	false	false	true	false
1ba6629e-33aa-42c3-828f-1d4117d4e5eb	2026-08-18 12:31	2026-08-18 12:31	2026-08-18 12:31	TPR	TPR270319P00130000	put	130.0000	2027-03-19	13.7000	13.3000	13.8000	134.2750	53429.00	52059.00	1370.00	39	9	58	11	5.27272727272727	0.431348956935356	0.431090585276609	false	false	false	true	false
38c75c51-b401-4ed3-8ff4-34f5e5992756	2026-08-18 12:31	2026-08-18 12:31	2026-08-18 12:31	TPR	TPR270319P00120000	put	120.0000	2027-03-19	9.5000	8.9000	9.5000	134.1800	19950.00	19950.00	0.00	21	6	42	28	1.5	0.436436243509721	0.436436243509721	false	false	false	true	false
63847e6c-603c-46e5-a932-2fce1434a409	2026-08-18 13:45	2026-08-18 13:45	2026-08-18 13:45	TPR	TPR260828P00132000	put	132.0000	2026-08-28	2.1500	2.0000	2.1500	134.0800	12255.00	12255.00	0.00	57	24	57	7	8.14285714285714	0.357046257451175	0.357046257451175	false	false	false	true	false
4a13156c-c9c0-48f8-94e0-58d63e7a4732	2026-08-20 11:24	2026-08-20 11:23	2026-08-20 11:23	TPR	TPR261120P00140000	put	140.0000	2026-11-20	16.4000	16.0000	16.5000	129.2900	255775.00	249255.00	6520.00	156	30	156	18	8.66666666666667	0.414832647254691	0.414832647254691	false	false	false	true	false
4b72b68a-c0ae-472c-919f-5d3980c99583	2026-08-20 11:25	2026-08-20 11:25	2026-08-20 11:25	TPR	TPR261120C00135000	call	135.0000	2026-11-20	8.4000	8.1000	8.4000	129.1000	21000.00	21000.00	0.00	25	13	39	41	0.951219512195122	0.401019231729824	0.401019231729824	true	false	false	true	false
2421a8b6-94c0-439e-b9a2-ed927806bef2	2026-08-20 12:45	2026-08-20 12:45	2026-08-20 12:45	TPR	TPR260828P00130000	put	130.0000	2026-08-28	2.8500	2.6500	2.8500	129.5600	45594.00	45594.00	0.00	160	28	160	12	13.3333333333333	0.349874456040062	0.349874456040062	false	false	false	true	false
e6a00b36-b4c7-445d-972e-4610cf8f5433	2026-08-21 13:29	2026-08-21 13:28	2026-08-21 13:28	TPR	TPR270219P00135000	put	135.0000	2027-02-19	16.1000	15.8000	16.2000	130.6050	24150.00	4830.00	19320.00	15	5	27	0	0	0.412301490515261	0.412301490515261	false	false	false	true	false
7059f487-fe60-4fdf-a75e-cbe038f7933e	2026-08-24 10:58	2026-08-24 10:58	2026-08-24 10:58	TPR	TPR261218P00130000	put	130.0000	2026-12-18	10.0000	9.6000	10.1000	132.3100	59000.00	54000.00	5000.00	59	23	59	43	1.37209302325581	0.405219488280115	0.405219488280115	false	false	false	true	false
9a8a338b-9315-4f51-ad59-0d4a2be8bdb3	2026-08-24 12:19	2026-08-24 12:19	2026-08-24 12:19	TPR	TPR261120C00135000	call	135.0000	2026-11-20	9.9000	9.7000	9.9000	132.4200	23760.00	23760.00	0.00	24	24	43	73	0.589041095890411	0.405303194324426	0.405303194324426	true	false	false	true	false
1fb8fc3e-2a0f-4a84-bfea-17b491a0699c	2026-08-24 12:20	2026-08-24 12:20	2026-08-24 12:20	TPR	TPR261120C00130000	call	130.0000	2026-11-20	12.3000	12.0000	12.3000	132.4500	25830.00	25830.00	0.00	21	21	33	76	0.434210526315789	0.405755332839616	0.405873352072569	true	false	false	true	false
ef6e0214-c4d5-4b10-b247-6b6fc89f5559	2026-08-25 14:08	2026-08-25 14:08	2026-08-25 14:08	TPR	TPR270115C00155000	call	155.0000	2027-01-15	5.1000	4.6000	5.1000	131.0000	18360.00	18360.00	0.00	36	9	40	91	0.43956043956044	0.371373040034546	0.371373040034546	true	false	false	true	false
dcbe890e-b027-4438-95e8-993aaa3da691	2026-08-25 14:52	2026-08-25 14:52	2026-08-25 14:52	TPR	TPR261016P00130000	put	130.0000	2026-10-16	6.0000	5.8000	6.0000	130.9100	124188.00	124188.00	0.00	207	35	344	0	0	0.346095599253603	0.346095599253603	false	false	false	true	false
fedcdb17-7194-4562-85cb-eed1aacaad43	2026-08-25 15:09	2026-08-25 15:09	2026-08-25 15:09	TPR	TPR270115P00120000	put	120.0000	2027-01-15	7.2000	6.2000	7.2000	130.3750	97200.00	97200.00	0.00	135	12	135	19	7.10526315789474	0.399749414864511	0.399749414864511	false	false	false	true	false
5274e97a-13b7-4034-bb78-c3d477321f17	2026-08-27 10:40	2026-08-27 10:40	2026-08-27 10:40	TPR	TPR261016P00120000	put	120.0000	2026-10-16	3.9900	3.8000	4.0000	124.8200	15950.00	14000.00	1950.00	40	6	96	230	0.417391304347826	0.352753818997882	0.352753818997882	false	false	false	true	false
c0c18c2d-dc76-44d9-a34b-f0c4e3163861	2026-08-27 12:06	2026-08-27 12:06	2026-08-27 12:06	TPR	TPR261016P00120000	put	120.0000	2026-10-16	3.8000	3.6000	3.9000	124.9400	85120.00	85120.00	0.00	224	28	339	230	1.47391304347826	0.343341512993346	0.343341512993346	false	false	false	true	false
857183fc-1979-4c37-a762-1c51b0b4e965	2026-08-27 13:39	2026-08-27 13:39	2026-08-27 13:39	TPR	TPR261120P00120000	put	120.0000	2026-11-20	7.4000	7.0000	7.4000	124.1400	34780.00	34780.00	0.00	47	7	48	26	1.84615384615385	0.41900380154945	0.41900380154945	false	false	false	true	false
19fffd63-8bec-467f-94c3-3420297510f3	2026-08-27 15:17	2026-08-27 15:17	2026-08-27 15:17	TPR	TPR261120P00135000	put	135.0000	2026-11-20	16.5000	16.2000	16.5000	123.0000	34650.00	34650.00	0.00	21	6	22	14	1.57142857142857	0.419659990747956	0.419659990747956	false	false	false	true	false
531549c4-bb60-4ee1-87bc-6b5ca1d6f2df	2026-08-28 10:54	2026-08-28 10:54	2026-08-28 10:54	TPR	TPR261218P00125000	put	125.0000	2026-12-18	10.3000	10.0000	10.3000	125.1900	12360.00	12360.00	0.00	12	9	15	97	0.154639175257732	0.405303780606788	0.405303780606788	false	false	false	true	false
ae557830-a235-472d-b404-1559d59e1614	2026-08-28 12:02	2026-08-28 12:01	2026-08-28 12:01	TPR	TPR270219P00120000	put	120.0000	2027-02-19	10.6000	10.3000	10.8000	124.0000	21200.00	2120.00	19080.00	20	5	20	5	4	0.409832060978379	0.409832060978379	false	false	false	true	false
960773ce-77d0-4fde-b26b-20c82f3a54c5	2026-08-28 15:27	2026-08-28 15:26	2026-08-28 15:26	TPR	TPR270115P00110000	put	110.0000	2027-01-15	5.1000	4.9000	5.1000	125.2350	29070.00	29070.00	0.00	57	12	57	364	0.156593406593407	0.403538070073885	0.403538070073885	false	false	false	true	false
111fb2a8-7b4d-4f95-8787-986673c38a24	2026-08-31 13:08	2026-08-31 13:08	2026-08-31 13:08	TPR	TPR261120C00135000	call	135.0000	2026-11-20	4.8000	4.8000	5.0000	122.1900	10081.00	0.00	10081.00	21	21	42	169	0.248520710059172	0.396155756575837	0.396155756575837	true	false	false	true	false
01c27289-de24-4427-b16f-3758a6e0e657	2026-09-01 13:27	2026-09-01 13:27	2026-09-01 13:27	TPR	TPR261016P00120000	put	120.0000	2026-10-16	4.7700	4.7000	4.8000	121.6400	20050.00	12480.00	2820.00	42	12	53	445	0.119101123595506	0.346094408959508	0.343093149443617	false	false	false	true	false
57cbdc82-06a3-47a8-ad43-fb8696b341ef	2026-09-02 15:36	2026-09-02 15:35	2026-09-02 15:35	TPR	TPR261218C00130000	call	130.0000	2026-12-18	7.6000	7.1000	7.6000	122.1800	19000.00	19000.00	0.00	25	5	26	57	0.456140350877193	0.386993878824256	0.386993878824256	false	false	false	true	false
f9bac522-45a0-4537-808f-b159d1b4d385	2026-09-03 11:19	2026-09-03 11:19	2026-09-03 11:19	TPR	TPR261218C00130000	call	130.0000	2026-12-18	7.5100	7.5000	7.9000	122.8400	18780.00	2280.00	16500.00	25	8	25	81	0.308641975308642	0.373586065677209	0.373586065677209	false	false	false	true	false
19b6f7bc-89e5-40f2-8ab6-e9e209eb18c6	2026-09-08 10:47	2026-09-08 10:47	2026-09-08 10:47	TPR	TPR260918C00117000	call	117.0000	2026-09-18	3.1000	2.7000	3.1000	117.3250	97340.00	97340.00	0.00	314	6	318	0	0	0.371377137987019	0.371377137987019	false	false	false	true	false
5dd5d59c-5de9-46c0-ae4a-5f3005d5ec41	2026-09-08 11:20	2026-09-08 11:20	2026-09-08 11:20	TPR	TPR261218C00135000	call	135.0000	2026-12-18	4.3000	4.0000	4.3000	117.0800	206830.00	206830.00	0.00	481	22	491	42	11.6904761904762	0.402224656314657	0.402224656314657	false	false	false	true	false
a6a68a18-e810-4bc6-b768-dbf2b8d7689f	2026-09-09 10:38	2026-09-09 10:38	2026-09-09 10:38	TPR	TPR261016P00115000	put	115.0000	2026-10-16	4.5000	4.3000	4.5000	116.0000	60300.00	60300.00	0.00	134	39	139	146	0.952054794520548	0.361082728568493	0.361082728568493	false	false	false	true	false
38a07893-db12-4153-a582-436e6ecd246b	2026-09-09 12:13	2026-09-09 12:12	2026-09-09 12:12	TPR	TPR270115P00115000	put	115.0000	2027-01-15	10.0000	9.6000	10.0000	115.6200	569984.00	569984.00	0.00	570	58	570	115	4.95652173913043	0.410427202371771	0.410427202371771	false	false	false	true	false
d2ff3a3a-e42e-4795-b4f0-f96f74abdb39	2026-09-09 15:11	2026-09-09 15:11	2026-09-09 15:11	TPR	TPR260925C00115000	call	115.0000	2026-09-25	3.3000	3.1000	3.3000	114.5050	21430.00	21430.00	0.00	65	6	103	83	1.24096385542169	0.358178627323115	0.358178627323115	false	false	false	true	false
49a27461-b7c8-4303-827f-e572299bb6ae	2026-09-10 10:09	2026-09-10 10:09	2026-09-10 10:09	TPR	TPR260918P00120000	put	120.0000	2026-09-18	5.2900	4.8000	5.3000	115.6800	74100.00	61910.00	0.00	140	16	140	305	0.459016393442623	0.393664717995366	0.381367391615906	false	false	false	true	false
d01dec16-0e1b-41dc-98dd-f9b3a1ef0d3d	2026-09-10 10:35	2026-09-10 10:35	2026-09-10 10:35	TPR	TPR260918P00120000	put	120.0000	2026-09-18	4.6000	4.2000	4.8000	116.5800	23000.00	23000.00	0.00	50	8	257	305	0.842622950819672	0.373896118439687	0.373896118439687	false	false	false	true	false
1b84c0a8-ec94-40c3-a8bb-772d5227ad3d	2026-09-10 13:17	2026-09-10 13:16	2026-09-10 13:16	TPR	TPR260918P00120000	put	120.0000	2026-09-18	5.3000	5.2000	5.5000	115.5500	15370.00	6360.00	5300.00	29	6	302	305	0.99016393442623	0.367880820936808	0.367880820936808	false	false	false	true	false
fd58e8d5-bf87-4ce3-8131-63593308f13a	2026-09-11 13:43	2026-09-11 13:43	2026-09-11 13:43	TPR	TPR260918C00116000	call	116.0000	2026-09-18	3.1000	2.8500	3.1000	117.3800	34720.00	34720.00	0.00	112	35	112	0	0	0.355730765253183	0.355730765253183	false	false	false	true	false
33591120-bfc9-45f2-83e9-a1252a04c6fa	2026-09-11 15:18	2026-09-11 15:18	2026-09-11 15:18	TPR	TPR261016C00115000	call	115.0000	2026-10-16	6.8000	6.6000	6.8000	117.7250	50994.00	50994.00	0.00	75	20	76	17	4.47058823529412	0.352861368023709	0.352141176224921	false	false	false	true	false
8ea4b7e4-e223-4d0e-8b72-53179d64f939	2026-09-11 15:47	2026-09-11 15:47	2026-09-11 15:47	TPR	TPR260918P00120000	put	120.0000	2026-09-18	3.4000	3.1000	3.4000	117.8700	34000.00	34000.00	0.00	100	5	220	416	0.528846153846154	0.340047671279412	0.340047671279412	false	false	false	true	false
d8eb8dfa-debb-4de3-9b8f-60759ddcad36	2026-09-11 15:49	2026-09-11 15:49	2026-09-11 15:49	TPR	TPR270115C00145000	call	145.0000	2027-01-15	3.4000	3.2000	3.4000	117.9350	35360.00	35360.00	0.00	104	18	106	33	3.21212121212121	0.393917626307523	0.393917626307523	false	false	false	true	false
91b23921-85a1-4ace-a27d-169ff127c6a7	2026-09-14 10:13	2026-09-14 10:12	2026-09-14 10:12	TPR	TPR261016C00130000	call	130.0000	2026-10-16	1.3000	1.3000	1.4500	117.7000	16770.00	0.00	16770.00	129	19	129	60	2.15	0.357653572598763	0.357653572598763	false	false	false	true	false
a5cb6cb7-0a5c-4faf-92e6-c9b02d52f24a	2026-09-14 10:37	2026-09-14 10:37	2026-09-14 10:37	TPR	TPR260925C00115000	call	115.0000	2026-09-25	5.3000	5.3000	5.7000	118.8050	26502.00	0.00	26502.00	50	8	64	233	0.274678111587983	0.363773254089869	0.360918573176669	false	false	false	true	false
8e649510-bc29-4406-8eb8-7a5daf378a3d	2026-09-16 10:16	2026-09-16 10:16	2026-09-16 10:16	TPR	TPR261218P00120000	put	120.0000	2026-12-18	9.9000	9.5000	9.9000	119.0000	13860.00	13860.00	0.00	14	5	24	183	0.131147540983607	0.426338824184447	0.426338824184447	false	false	false	true	false
3095fd1a-8d79-4486-9b11-f351c732ef4f	2026-09-16 10:31	2026-09-16 10:31	2026-09-16 10:31	TPR	TPR270219P00120000	put	120.0000	2027-02-19	12.6000	11.9000	12.6000	119.0000	12600.00	12600.00	0.00	10	6	10	79	0.126582278481013	0.4342213146462	0.431926473382327	false	false	false	true	false