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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = premarket×ticker = TSM×

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

c9d2bde7-8808-48e2-983c-ee98b83e163b	2026-10-01 15:37	2026-10-01 15:37	2026-10-01 15:37	TSM	TSM270416P00450000	put	450.0000	2027-04-16	40.4000	40.4000	40.7000	458.0500	355520.00	0.00	319160.00	88	6	119	111	1.07207207207207	0.376180386384481	0.376180386384481	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Technology	2381643051917.00	2026-10-15	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:42:36.719976Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
0f75f6e3-50a0-4ffa-b859-1c6edd7cab0a	2026-10-01 15:20	2026-10-01 15:20	2026-10-01 15:20	TSM	TSM261120P00440000	put	440.0000	2026-11-20	13.3100	13.1000	13.3500	458.0000	37265.00	10665.00	26600.00	28	7	108	1003	0.107676969092722	0.335042859100823	0.335855165323058	false	false	false	true
baac500b-c6bc-4722-951c-1643ce870569	2026-10-01 15:17	2026-10-01 15:17	2026-10-01 15:17	TSM	TSM261106P00445000	put	445.0000	2026-11-06	12.0000	12.0000	12.2500	458.0000	88800.00	0.00	88800.00	74	38	175	28	6.25	0.328184028967961	0.328184028967961	false	false	false	true	false
17f041ca-c372-4bc1-b496-5ae71712b6f9	2026-10-01 15:02	2026-10-01 15:02	2026-10-01 15:02	TSM	TSM261009P00455000	put	455.0000	2026-10-09	6.1000	6.1000	6.2000	458.8700	51850.00	0.00	20130.00	85	54	203	541	0.375231053604436	0.298660570437555	0.298660570437555	true	false	false	true
66fe289b-033f-4398-b050-994a9f3f44a9	2026-10-01 14:43	2026-10-01 14:43	2026-10-01 14:43	TSM	TSM270416P00370000	put	370.0000	2027-04-16	12.1400	11.8500	12.2000	459.1650	37640.00	20655.00	16985.00	31	7	45	398	0.113065326633166	0.379637517909669	0.379023715576477	false	false	false	true
3e97f3ed-a094-4ff1-8b1f-710a86695b08	2026-10-01 14:38	2026-10-01 14:38	2026-10-01 14:38	TSM	TSM261120C00470000	call	470.0000	2026-11-20	19.3500	19.3500	19.5000	459.5350	137385.00	0.00	137385.00	71	14	186	3553	0.0523501266535322	0.336894555194553	0.336894555194553	false	false	false	true
67e38d74-26d0-472c-bf46-eaf7ce59d8a4	2026-10-01 14:29	2026-10-01 14:28	2026-10-01 14:28	TSM	TSM261016P00425000	put	425.0000	2026-10-16	2.5900	2.5800	2.8500	459.0350	10882.00	0.00	10882.00	42	15	108	501	0.215568862275449	0.373460064573337	0.374900681662298	false	false	false	true
68885847-43a4-4f31-b5c4-4c3e3c0e5707	2026-10-01 14:14	2026-10-01 14:14	2026-10-01 14:14	TSM	TSM261016C00455000	call	455.0000	2026-10-16	15.2500	15.2500	15.5500	457.9500	211975.00	0.00	211975.00	139	16	605	391	1.54731457800512	0.361126895331721	0.361126895331721	false	false	false	true
287c1477-0338-4ce6-bf6c-3702700e9246	2026-10-01 13:55	2026-10-01 13:54	2026-10-01 13:54	TSM	TSM270617C00490000	call	490.0000	2027-06-17	52.0000	52.0000	52.5000	459.0000	46800.00	0.00	46800.00	9	5	33	5468	0.00603511338697879	0.377917008822893	0.377917008822893	false	false	false	true
04d81915-cc52-4e1c-9f7e-a8e70f5a1402	2026-10-01 13:54	2026-10-01 13:54	2026-10-01 13:54	TSM	TSM261120P00440000	put	440.0000	2026-11-20	13.1500	12.8000	13.1500	459.0000	11835.00	11835.00	0.00	9	5	72	1003	0.0717846460618146	0.339180815318298	0.339180815318298	false	false	false	true
775fd517-a409-4c8d-a627-5f45b8fa628b	2026-10-01 13:49	2026-10-01 13:49	2026-10-01 13:49	TSM	TSM261106P00465000	put	465.0000	2026-11-06	20.7400	20.4500	21.0500	460.0000	468720.00	186750.00	95220.00	226	20	366	27	13.5555555555556	0.331704017394949	0.332571387087509	false	false	false	true
46ec4804-c436-47fc-9e67-e322109bfd4e	2026-10-01 13:39	2026-10-01 13:39	2026-10-01 13:39	TSM	TSM261120P00450000	put	450.0000	2026-11-20	17.0000	16.8000	17.0000	459.6950	20400.00	20400.00	0.00	12	8	498	1334	0.373313343328336	0.33768842688368	0.33768842688368	false	false	false	true
4da023f3-3968-43dc-865c-eed1abc31cdf	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	TSM	TSM261120C00460000	call	460.0000	2026-11-20	23.9900	23.2500	24.2500	459.2600	33580.00	19190.00	4790.00	14	8	139	3892	0.0357142857142857	0.343654674394463	0.34010393523622	false	false	false	true
9de86234-840f-4daf-b534-0bbae6a98fe8	2026-10-01 13:24	2026-10-01 13:24	2026-10-01 13:24	TSM	TSM261120C00440000	call	440.0000	2026-11-20	34.2200	34.0500	34.3000	457.9200	37640.00	34220.00	3420.00	11	5	93	2590	0.0359073359073359	0.341953937897729	0.341144873071422	false	false	false	true
67aefe6a-5e83-49b6-b162-e28581aa562a	2026-10-01 13:19	2026-10-01 13:19	2026-10-01 13:19	TSM	TSM261120P00430000	put	430.0000	2026-11-20	10.4500	10.3000	10.4500	456.3900	18810.00	18810.00	0.00	18	8	46	3746	0.0122797650827549	0.336153888217963	0.336153888217963	false	false	false	true
a416cb94-ce37-496c-93e0-f251960fc968	2026-10-01 13:11	2026-10-01 13:11	2026-10-01 13:11	TSM	TSM261009C00455000	call	455.0000	2026-10-09	8.7500	8.7500	8.8500	455.0000	19250.00	0.00	19250.00	22	5	851	578	1.47231833910035	0.301239444565971	0.301239444565971	false	false	false	true
87744db0-aeb7-416a-bb80-47ed3e5918fb	2026-10-01 13:05	2026-10-01 13:05	2026-10-01 13:05	TSM	TSM261218C00550000	call	550.0000	2026-12-18	5.1000	4.9000	5.1500	455.9025	15300.00	2550.00	8160.00	30	22	93	6356	0.0146318439269981	0.342338379779165	0.342338379779165	false	false	false	true
ead0a1f8-5c5d-4aad-a7fc-f60415228ad2	2026-10-01 12:59	2026-10-01 12:59	2026-10-01 12:59	TSM	TSM261106P00445000	put	445.0000	2026-11-06	13.0300	12.9500	13.2500	455.2650	114655.00	66555.00	48100.00	88	14	97	28	3.46428571428571	0.327365699228671	0.328286239001613	false	false	false	true
63e8231d-57a7-4df1-b9e2-b6e2fc713a82	2026-10-01 12:55	2026-10-01 12:55	2026-10-01 12:55	TSM	TSM261023C00455000	call	455.0000	2026-10-23	15.4500	15.3500	15.6000	455.1300	135960.00	125145.00	10815.00	88	5	422	347	1.21613832853026	0.33314350588903	0.33314350588903	false	false	false	true
34652d7b-9fad-4a6c-8b37-d60e3573a642	2026-10-01 12:54	2026-10-01 12:54	2026-10-01 12:54	TSM	TSM261009C00470000	call	470.0000	2026-10-09	2.9100	2.8600	2.9300	455.3750	19801.00	18345.00	0.00	68	21	411	743	0.553162853297443	0.296991718293354	0.297926100092566	true	false	false	true
7acb76f3-8ff5-4b96-a937-bc89c0c8ede1	2026-10-01 12:54	2026-10-01 12:53	2026-10-01 12:53	TSM	TSM261106C00465000	call	465.0000	2026-11-06	15.5600	15.5500	15.9000	456.0400	12445.00	0.00	12445.00	8	8	33	55	0.6	0.327846896626798	0.32872614394215	false	false	false	true	false
749fb00b-9813-4a0d-a69a-728633345e35	2026-10-01 12:54	2026-10-01 12:53	2026-10-01 12:53	TSM	TSM261106C00460000	call	460.0000	2026-11-06	17.7500	17.7000	18.0500	456.0400	106505.00	1780.00	104725.00	60	27	280	11861	0.0236067785178316	0.327906934101855	0.327906934101855	false	false	false	true
01f13517-d555-4e39-a8d9-6daf1938f2fb	2026-10-01 12:50	2026-10-01 12:50	2026-10-01 12:50	TSM	TSM270319C00520000	call	520.0000	2027-03-19	25.5500	25.5500	25.9000	456.0150	30660.00	0.00	30660.00	12	7	2480	1228	2.01954397394137	0.364812040172727	0.364859669973732	false	false	false	true
d0072e49-0a5c-46c8-923c-e508a8f3b0bd	2026-10-01 12:44	2026-10-01 12:44	2026-10-01 12:44	TSM	TSM270115P00400000	put	400.0000	2027-01-15	10.8000	10.7000	10.9000	455.8050	16200.00	12960.00	0.00	15	5	41	7437	0.00551297566222939	0.357026658146231	0.357026658146231	false	false	false	true
748d00bb-1705-46c7-978c-5fb417f1dd7a	2026-10-01 12:19	2026-10-01 12:19	2026-10-01 12:19	TSM	TSM270617C00580000	call	580.0000	2027-06-17	25.0600	24.8500	25.3000	455.0000	140355.00	62645.00	75200.00	56	5	231	2864	0.0806564245810056	0.380635713688634	0.382477637332167	true	false	false	true
b1bc67c6-7914-4b09-9655-bff9f63e1a88	2026-10-01 12:18	2026-10-01 12:18	2026-10-01 12:18	TSM	TSM270617C00620000	call	620.0000	2027-06-17	18.3800	16.3500	18.6000	455.6299	16540.00	9200.00	7340.00	9	5	11	2318	0.00474547023295945	0.384254040691143	0.384254040691143	false	false	false	true
a87663be-2ca4-42cb-87f5-710a45faed5e	2026-10-01 12:18	2026-10-01 12:18	2026-10-01 12:18	TSM	TSM270617C00570000	call	570.0000	2027-06-17	27.3000	25.1500	27.3000	455.5800	131039.00	131039.00	0.00	48	20	48	805	0.0596273291925466	0.382750550843797	0.382750550843797	false	false	false	true
8a727bab-f3a7-4c74-84eb-2442880e2a59	2026-10-01 12:18	2026-10-01 12:18	2026-10-01 12:18	TSM	TSM270617C00580000	call	580.0000	2027-06-17	25.2000	23.8000	25.2000	455.5800	314972.00	314972.00	0.00	125	32	157	2864	0.0548184357541899	0.382742025549834	0.382742025549834	false	false	false	true
9900828b-635b-4673-af9b-4454415b6935	2026-10-01 12:18	2026-10-01 12:18	2026-10-01 12:18	TSM	TSM261120C00440000	call	440.0000	2026-11-20	32.5400	32.3000	32.6500	455.6200	58570.00	55320.00	3250.00	18	10	65	2590	0.0250965250965251	0.339371651290575	0.339724264277906	false	false	false	true
233fc6d3-69bd-4f3e-9c2b-1dc4f829776a	2026-10-01 12:17	2026-10-01 12:17	2026-10-01 12:17	TSM	TSM270319C00520000	call	520.0000	2027-03-19	25.1500	25.1500	25.6500	455.1300	103115.00	0.00	103115.00	41	11	2434	1228	1.98208469055375	0.364250442286357	0.364250442286357	false	false	false	true
63716842-1606-4213-92b8-14a8a0d49717	2026-10-01 12:16	2026-10-01 12:16	2026-10-01 12:16	TSM	TSM270617P00440000	put	440.0000	2027-06-17	43.1000	42.7500	43.3500	454.8250	56025.00	21530.00	34495.00	13	8	39	452	0.086283185840708	0.381947619420974	0.382646666380749	false	false	false	true
45e6989a-d9a9-4ab9-985a-9897255be852	2026-10-01 12:16	2026-10-01 12:16	2026-10-01 12:16	TSM	TSM270617P00410000	put	410.0000	2027-06-17	30.1900	29.7000	30.5000	454.9200	48300.00	30125.00	18175.00	16	9	24	1764	0.0136054421768707	0.381523538609872	0.381285104935985	false	false	false	true
735f1f3d-96da-4a0a-8ab4-5a8ba44bddfd	2026-10-01 12:15	2026-10-01 12:15	2026-10-01 12:15	TSM	TSM261218C00470000	call	470.0000	2026-12-18	23.3500	22.5000	23.7500	455.1000	49035.00	44360.00	2340.00	21	17	382	1520	0.251315789473684	0.334780005679916	0.335152308414215	false	false	false	true
4485b75a-17b8-40fc-9c49-62fe89db6658	2026-10-01 12:15	2026-10-01 12:14	2026-10-01 12:14	TSM	TSM261030P00455000	put	455.0000	2026-10-30	16.0000	15.5500	16.6500	455.0900	35205.00	33600.00	1605.00	22	10	38	99	0.383838383838384	0.328159033541668	0.329139434109834	true	false	false	true
2895e85c-e738-4bfe-9e18-de7ae00d8afd	2026-10-01 12:15	2026-10-01 12:14	2026-10-01 12:14	TSM	TSM261120P00450000	put	450.0000	2026-11-20	18.5000	18.2000	18.5500	455.0900	14800.00	11100.00	3700.00	8	6	459	1334	0.34407796101949	0.331004145809125	0.332091923037851	false	false	false	true
e5cccd10-07a4-4dcd-acaa-6effb7ea447f	2026-10-01 12:14	2026-10-01 12:14	2026-10-01 12:14	TSM	TSM270319C00590000	call	590.0000	2027-03-19	11.6000	11.5000	11.7000	454.9250	42920.00	24360.00	18560.00	37	12	37	317	0.116719242902208	0.368879517900411	0.368879517900411	false	false	false	true
994ff780-6591-4fc9-a2c3-d0ad6b3b4a8e	2026-10-01 12:14	2026-10-01 12:14	2026-10-01 12:14	TSM	TSM270319C00600000	call	600.0000	2027-03-19	10.3200	10.3000	10.3500	454.9250	44365.00	15525.00	28840.00	43	13	43	1383	0.0310918293564714	0.368860172883799	0.369465301475675	true	false	false	true
e4613ca7-2783-48d3-a6db-8f7970ab9944	2026-10-01 12:14	2026-10-01 12:14	2026-10-01 12:14	TSM	TSM270416C00550000	call	550.0000	2027-04-16	22.4500	22.3000	23.1500	454.9050	307535.00	264910.00	40380.00	137	24	137	200	0.685	0.371740293684753	0.371740293684753	false	false	false	true
88649f01-68c8-49da-9900-f49b47b5d2f1	2026-10-01 12:12	2026-10-01 12:12	2026-10-01 12:12	TSM	TSM270319C00520000	call	520.0000	2027-03-19	25.1500	24.3000	25.5500	454.9050	1005832.00	1003352.00	2480.00	400	5	400	1228	0.325732899022801	0.361963014610422	0.361963014610422	false	false	false	true
245c4adf-c857-47d2-9d1b-edf2636fbee1	2026-10-01 12:10	2026-10-01 12:09	2026-10-01 12:09	TSM	TSM270319P00430000	put	430.0000	2027-03-19	28.4900	28.4500	28.6000	454.6299	37040.00	0.00	37040.00	13	5	24	848	0.0283018867924528	0.363259563497629	0.363259563497629	false	false	false	true
cb367c7d-3d06-4974-937b-476f7d7720d4	2026-10-01 12:09	2026-10-01 12:09	2026-10-01 12:09	TSM	TSM261218C00470000	call	470.0000	2026-12-18	22.8500	22.5000	23.0000	454.4900	756335.00	143955.00	612380.00	331	6	361	1520	0.2375	0.331995677016796	0.331995677016796	false	false	false	true
c79acd06-bbf1-402e-886c-70f5f13fa51e	2026-10-01 12:09	2026-10-01 12:09	2026-10-01 12:09	TSM	TSM261218C00480000	call	480.0000	2026-12-18	19.1500	19.0500	19.1500	454.4650	109154.00	109154.00	0.00	57	16	70	2679	0.0261291526689063	0.332928528390743	0.332928528390743	false	false	false	true
94592e90-f89a-4e04-9a3e-6d19a6e4ee36	2026-10-01 12:09	2026-10-01 12:09	2026-10-01 12:09	TSM	TSM270115C00490000	call	490.0000	2027-01-15	22.2900	22.1500	22.3000	454.4650	180571.00	180571.00	0.00	81	16	95	7642	0.0124313007066213	0.348416066350159	0.348416066350159	false	false	false	true
880941cf-db13-4ee3-a415-f2110e00d01c	2026-10-01 12:09	2026-10-01 12:09	2026-10-01 12:09	TSM	TSM270115C00500000	call	500.0000	2027-01-15	19.1500	19.0500	19.2000	454.4900	222172.00	147877.00	74295.00	116	19	1326	18628	0.0711831651277647	0.348516327878103	0.348417407670273	true	false	false	true
57ac7462-d35b-4c60-a074-26302d8b46b2	2026-10-01 12:09	2026-10-01 12:09	2026-10-01 12:09	TSM	TSM261120C00480000	call	480.0000	2026-11-20	13.3000	13.2000	13.3500	454.4900	14630.00	7980.00	6650.00	11	5	390	6037	0.0646016233228425	0.333492288605018	0.333346946381401	false	false	false	true
1757b89a-3e62-4ece-a87f-03c15097bad2	2026-10-01 12:09	2026-10-01 12:09	2026-10-01 12:09	TSM	TSM261218C00500000	call	500.0000	2026-12-18	13.1500	13.0500	13.2000	454.4900	46025.00	44710.00	1315.00	35	13	88	26877	0.00327417494512036	0.333931303595793	0.333825885380392	false	false	false	true
c14e67df-4564-4ccc-ac80-534aad8bceeb	2026-10-01 12:09	2026-10-01 12:09	2026-10-01 12:09	TSM	TSM261030C00445000	call	445.0000	2026-10-30	22.7500	22.5500	22.8000	454.4750	25025.00	9100.00	0.00	11	5	12	166	0.072289156626506	0.331704346120619	0.331704346120619	false	false	false	true
f921ee5d-8932-4bfe-b55b-96367644f453	2026-10-01 12:09	2026-10-01 12:09	2026-10-01 12:09	TSM	TSM270416P00390000	put	390.0000	2027-04-16	17.6500	17.2000	17.6500	454.4000	24710.00	24710.00	0.00	14	11	21	333	0.0630630630630631	0.372513991896005	0.372513991896005	false	false	false	true
a6d1c66f-5a3d-4392-b401-7f99f48153d6	2026-10-01 12:05	2026-10-01 12:05	2026-10-01 12:05	TSM	TSM261030P00445000	put	445.0000	2026-10-30	11.5500	11.2500	11.6000	454.6750	11550.00	9240.00	0.00	10	5	11	97	0.11340206185567	0.326976909081991	0.326976909081991	false	false	false	true
934dd28d-9503-4f08-b202-5a46d38dcd58	2026-10-01 12:03	2026-10-01 12:03	2026-10-01 12:03	TSM	TSM270416C00480000	call	480.0000	2027-04-16	43.3000	43.3000	43.4500	455.1500	77940.00	0.00	77940.00	18	5	262	700	0.374285714285714	0.367892925863184	0.367892925863184	false	false	false	true