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

710a2a02-b13a-45a9-aa44-bb26d8107e44	2026-10-02 11:35	2026-10-02 11:35	2026-10-02 11:35	TSM	TSM270115C00450000	call	450.0000	2027-01-15	50.0000	49.0000	50.0500	472.0000	110000.00	60000.00	0.00	22	10	374	13860	0.026984126984127	0.35046732959348	0.35046732959348	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Technology	2452075788513.00	2026-10-15	premarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T15:38:49.827146Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
a2913367-5b3b-4c54-a178-36c341c63ac5	2026-10-02 11:35	2026-10-02 11:35	2026-10-02 11:35	TSM	TSM261016C00485000	call	485.0000	2026-10-16	8.1100	7.9500	8.1500	472.0000	16220.00	16220.00	0.00	20	5	244	326	0.748466257668712	0.355616677913214	0.355616677913214	false	false	false	true
eb115bb9-0835-4e21-9e71-9d0294217af0	2026-10-02 11:35	2026-10-02 11:35	2026-10-02 11:35	TSM	TSM270219C00440000	call	440.0000	2027-02-19	62.6500	62.0500	63.0500	472.0000	62650.00	56385.00	6265.00	10	10	102	595	0.171428571428571	0.358928405275744	0.358423648726231	false	false	false	true
4390fa14-ef40-494a-a9d1-0ced129679c2	2026-10-02 11:34	2026-10-02 11:34	2026-10-02 11:34	TSM	TSM261120P00410000	put	410.0000	2026-11-20	3.5000	3.4000	3.5500	471.0000	20300.00	17500.00	2800.00	58	5	197	3897	0.0505517064408519	0.348150330337153	0.348150330337153	false	false	false	true
f428f698-dcf9-4ce4-b1b1-c87e7c68599b	2026-10-02 11:33	2026-10-02 11:33	2026-10-02 11:33	TSM	TSM270115C00450000	call	450.0000	2027-01-15	49.5000	48.9500	49.5000	471.0000	49500.00	49500.00	0.00	10	8	343	13860	0.0247474747474747	0.351193610405735	0.351122771089679	false	false	false	true
a532802b-335c-4e37-af1b-24a5add3ad32	2026-10-02 11:33	2026-10-02 11:33	2026-10-02 11:33	TSM	TSM270219C00440000	call	440.0000	2027-02-19	62.0000	61.7500	62.4000	471.0000	99200.00	93000.00	6200.00	16	10	85	595	0.142857142857143	0.35761397954413	0.357346065595333	false	false	false	true
44cb562b-2db6-4721-8efb-aa553624e6f2	2026-10-02 11:33	2026-10-02 11:33	2026-10-02 11:33	TSM	TSM270219C00440000	call	440.0000	2027-02-19	62.0000	61.7000	63.2500	471.0000	37200.00	24800.00	12400.00	6	6	69	595	0.115966386554622	0.35788175758797	0.35761397954413	false	false	false	true
1f054253-367c-4137-ac21-0f348dea7071	2026-10-02 11:33	2026-10-02 11:33	2026-10-02 11:33	TSM	TSM270219C00440000	call	440.0000	2027-02-19	62.0500	61.6000	62.1500	471.0000	68255.00	62050.00	6205.00	11	11	49	595	0.0823529411764706	0.357630547898247	0.357630547898247	false	false	false	true
5ee5b291-5b9d-45ed-b6d2-d2d3aaf818c4	2026-10-02 11:32	2026-10-02 11:32	2026-10-02 11:32	TSM	TSM270115C00500000	call	500.0000	2027-01-15	26.0000	25.4000	26.3000	471.0000	15600.00	10400.00	5200.00	6	6	302	18954	0.0159333122296085	0.350568584045725	0.350568584045725	false	false	false	true
62140f70-f9dd-457f-b034-5d8fcfae1cf0	2026-10-02 11:31	2026-10-02 11:31	2026-10-02 11:31	TSM	TSM270219C00440000	call	440.0000	2027-02-19	61.5500	61.3000	62.0500	470.0000	49240.00	43085.00	6155.00	8	8	35	595	0.0588235294117647	0.356056332125035	0.355655200662227	false	false	false	true
c91d2ec9-1da2-4139-ad14-144c5fa8bed6	2026-10-02 11:31	2026-10-02 11:31	2026-10-02 11:31	TSM	TSM270219C00440000	call	440.0000	2027-02-19	61.5000	60.5000	62.0000	470.0000	73800.00	6150.00	67650.00	12	12	27	595	0.0453781512605042	0.356306048796169	0.35557116035491	false	false	false	true
04b5c0d6-b941-4ecf-b2e1-6d397a8da805	2026-10-02 11:25	2026-10-02 11:24	2026-10-02 11:24	TSM	TSM261016P00462500	put	462.5000	2026-10-16	9.2000	8.9500	9.2500	470.0800	13800.00	12880.00	920.00	15	7	22	157	0.140127388535032	0.355210860092873	0.355210860092873	false	false	false	true
78486755-dcdd-4aaa-8be3-39684db536bc	2026-10-02 11:22	2026-10-02 11:21	2026-10-02 11:21	TSM	TSM261016P00450000	put	450.0000	2026-10-16	5.1300	5.0500	5.1500	469.8700	35920.00	31840.00	3060.00	70	13	325	2069	0.157080715321411	0.359706941891895	0.357999861053062	false	false	false	true
c3b73e21-99d0-4b47-b545-044d8034aade	2026-10-02 11:17	2026-10-02 11:17	2026-10-02 11:17	TSM	TSM270115C00680000	call	680.0000	2027-01-15	1.6800	1.5100	1.6800	470.0000	49224.00	49224.00	0.00	293	41	323	1394	0.231707317073171	0.373244530283331	0.373244530283331	false	false	false	true
c3705400-d4b5-44a8-8c2f-31019fae91e0	2026-10-02 11:16	2026-10-02 11:16	2026-10-02 11:16	TSM	TSM261120C00460000	call	460.0000	2026-11-20	29.8000	29.8000	30.1000	470.3350	14900.00	0.00	14900.00	5	5	251	3929	0.0638839399338254	0.336240605797854	0.336240605797854	false	false	false	true
41976c02-3460-41d0-b397-1bbf8569ba89	2026-10-02 11:15	2026-10-02 11:15	2026-10-02 11:15	TSM	TSM261009C00465000	call	465.0000	2026-10-09	10.7000	10.4000	10.7000	470.1950	18190.00	18190.00	0.00	17	8	258	1536	0.16796875	0.294347826296907	0.294347826296907	false	false	false	true
87c4a0ac-0fa2-4ffd-ab42-6aea7b19f584	2026-10-02 11:14	2026-10-02 11:14	2026-10-02 11:14	TSM	TSM280121P00330000	put	330.0000	2028-01-21	18.4000	18.1000	18.4500	470.0400	112210.00	3670.00	11020.00	61	25	329	539	0.61038961038961	0.413278777411578	0.412842631286397	true	false	false	true
7e450fec-0de1-4637-9b4f-86ed9ac085ba	2026-10-02 11:14	2026-10-02 11:14	2026-10-02 11:14	TSM	TSM280121P00330000	put	330.0000	2028-01-21	18.3500	18.3500	18.4000	470.0400	18350.00	0.00	18350.00	10	10	341	539	0.63265306122449	0.412842631286397	0.412842631286397	false	false	false	true
9e96e7f6-e649-4be6-b2d9-9beacc5f1c59	2026-10-02 11:14	2026-10-02 11:14	2026-10-02 11:14	TSM	TSM280121P00330000	put	330.0000	2028-01-21	18.3500	18.3500	18.4500	469.9300	64225.00	0.00	18350.00	35	17	266	539	0.493506493506494	0.41271615697555	0.41271615697555	false	false	false	true
e028d9ba-cb37-4357-91d9-51a1da31b976	2026-10-02 11:14	2026-10-02 11:14	2026-10-02 11:14	TSM	TSM280121P00330000	put	330.0000	2028-01-21	18.3500	18.1500	18.3500	469.9700	64224.00	64224.00	0.00	35	19	231	539	0.428571428571429	0.412762153252839	0.412762153252839	false	false	false	true
0b1972ff-8217-45b9-8477-9c180d047f24	2026-10-02 11:14	2026-10-02 11:13	2026-10-02 11:13	TSM	TSM280121P00330000	put	330.0000	2028-01-21	18.2500	18.2500	18.5000	470.0200	114975.00	0.00	60225.00	63	18	196	539	0.363636363636364	0.411946360974383	0.411946360974383	false	false	false	true
1db57bba-7e63-41ac-aac2-f66d607e01a8	2026-10-02 11:13	2026-10-02 11:13	2026-10-02 11:13	TSM	TSM280121P00330000	put	330.0000	2028-01-21	18.2000	18.2000	18.3000	470.1800	49140.00	0.00	21840.00	27	9	133	539	0.246753246753247	0.411692915760597	0.411692915760597	false	false	false	true
b45a0eeb-10c3-4439-b3e2-5c247bb73fab	2026-10-02 11:13	2026-10-02 11:13	2026-10-02 11:13	TSM	TSM280121P00330000	put	330.0000	2028-01-21	18.2100	18.2000	18.3000	469.9900	25490.00	0.00	25490.00	14	5	106	539	0.196660482374768	0.411911894150418	0.411474762357682	false	false	false	true
a8da23a4-04de-4ed9-b0b3-c88ce734adab	2026-10-02 11:13	2026-10-02 11:13	2026-10-02 11:13	TSM	TSM280121P00330000	put	330.0000	2028-01-21	18.2500	18.2500	18.4000	469.9895	89425.00	0.00	3650.00	49	17	90	539	0.166975881261596	0.411911319672779	0.411911319672779	false	false	false	true
43139e3f-d9b7-4bf1-9067-5905fc72a4b0	2026-10-02 11:13	2026-10-02 11:13	2026-10-02 11:13	TSM	TSM280121P00330000	put	330.0000	2028-01-21	18.1500	18.1500	18.4500	469.8600	63525.00	0.00	41745.00	35	14	35	539	0.0649350649350649	0.410887997728599	0.410887997728599	false	false	false	true
2529d181-b1b3-4748-97e6-9658f02a0992	2026-10-02 11:11	2026-10-02 11:11	2026-10-02 11:11	TSM	TSM261120C00460000	call	460.0000	2026-11-20	29.8400	29.7000	30.1000	470.5450	29844.00	0.00	29844.00	10	5	245	3929	0.0623568337999491	0.335044507778305	0.335044507778305	false	false	false	true
c77ee35e-7e45-4a40-8823-4fda14c78e3f	2026-10-02 11:08	2026-10-02 11:08	2026-10-02 11:08	TSM	TSM261106C00460000	call	460.0000	2026-11-06	26.2900	25.9000	26.3500	471.2500	21029.00	21029.00	0.00	8	6	250	11836	0.021122000675904	0.332622058418146	0.333025148858823	false	false	false	true
1c18633e-8805-4b1b-9602-6c4c84393252	2026-10-02 11:08	2026-10-02 11:08	2026-10-02 11:08	TSM	TSM261030C00480000	call	480.0000	2026-10-30	13.9500	13.6000	13.9500	471.2500	30685.00	29295.00	1390.00	22	14	71	430	0.165116279069767	0.330537724139866	0.330537724139866	true	false	false	true
7dcf0d18-228e-492b-a3c3-8b38f790426c	2026-10-02 10:59	2026-10-02 10:58	2026-10-02 10:58	TSM	TSM261009P00457500	put	457.5000	2026-10-09	2.7400	2.5450	2.7600	469.6100	10686.00	2740.00	7946.00	39	20	108	261	0.413793103448276	0.287233334876975	0.287233334876975	false	false	false	true
9d574caf-3451-430c-aaec-586d826da58c	2026-10-02 10:58	2026-10-02 10:58	2026-10-02 10:58	TSM	TSM261120C00500000	call	500.0000	2026-11-20	12.2500	12.2500	12.5000	470.0450	84525.00	0.00	84525.00	69	5	255	3027	0.0842418235877106	0.330899802135583	0.330899802135583	false	false	false	true
3eaa9aab-c1e3-47fd-a64a-aa7c75ecb7f3	2026-10-02 10:54	2026-10-02 10:54	2026-10-02 10:54	TSM	TSM261002C00460000	call	460.0000	2026-10-02	9.5400	8.7000	9.5500	468.8700	28614.00	28614.00	0.00	30	6	609	3508	0.173603192702395	0.766992020300788	0.766992020300788	false	false	false	true
0f183131-6d92-4de4-9749-7ad8f44e3199	2026-10-02 10:49	2026-10-02 10:49	2026-10-02 10:49	TSM	TSM261120C00490000	call	490.0000	2026-11-20	15.6500	15.4500	15.7000	469.9900	10955.00	9390.00	1565.00	7	6	29	1750	0.0165714285714286	0.333057810144266	0.333057810144266	false	false	false	true
63216ab1-08f0-4c7d-a128-0b3f5e76c72e	2026-10-02 10:48	2026-10-02 10:48	2026-10-02 10:48	TSM	TSM290119C00400000	call	400.0000	2029-01-19	164.5000	164.5000	165.6500	469.3700	263200.00	0.00	263200.00	16	14	102	847	0.120425029515939	0.40496872707302	0.40496872707302	false	false	false	true
ae7625e8-0c68-48e7-8bf4-6943f4ee7b27	2026-10-02 10:46	2026-10-02 10:46	2026-10-02 10:46	TSM	TSM261120P00450000	put	450.0000	2026-11-20	13.1000	12.9000	13.1000	469.4100	15720.00	15720.00	0.00	12	5	167	2103	0.0794103661436044	0.333996111368063	0.333996111368063	false	false	false	true
a9dca320-dbbb-4224-8849-fde80e8dbf08	2026-10-02 10:39	2026-10-02 10:39	2026-10-02 10:39	TSM	TSM270115C00520000	call	520.0000	2027-01-15	18.9000	18.5500	18.9500	470.0000	30240.00	30240.00	0.00	16	14	2033	9808	0.207279771615008	0.349199752219668	0.349734209836208	false	false	false	true
af29b5ce-0bbf-448e-a910-240fe2d64110	2026-10-02 10:38	2026-10-02 10:38	2026-10-02 10:38	TSM	TSM261009P00460000	put	460.0000	2026-10-09	3.2500	3.2500	3.3500	470.0250	14306.00	0.00	14306.00	44	18	205	815	0.251533742331288	0.28414414894721	0.28414414894721	true	false	false	true
6b788f45-45dd-4097-87cd-9d395989440e	2026-10-02 10:28	2026-10-02 10:28	2026-10-02 10:28	TSM	TSM290119C00400000	call	400.0000	2029-01-19	164.7000	164.7000	166.2500	470.0500	362345.00	0.00	362345.00	22	20	85	847	0.100354191263282	0.403454183700308	0.403454183700308	false	false	false	true
8e4b0b35-5f14-4c35-81ac-9f8dfd7cf503	2026-10-02 10:23	2026-10-02 10:23	2026-10-02 10:23	TSM	TSM261106C00500000	call	500.0000	2026-11-06	8.7000	8.3500	9.0000	469.0000	11310.00	10440.00	870.00	13	8	103	113	0.911504424778761	0.330261695744949	0.330261695744949	false	false	false	true
d8ab65ff-0d94-47ba-a8e1-17df03760412	2026-10-02 10:18	2026-10-02 10:18	2026-10-02 10:18	TSM	TSM261002C00472500	call	472.5000	2026-10-02	0.9200	0.9200	1.0200	470.2800	22172.00	0.00	22172.00	241	46	1794	2452	0.731647634584013	0.377554709229351	0.37829493436419	false	false	false	true
77e5e0e7-30da-4e04-ac9d-742f9ef5235b	2026-10-02 10:13	2026-10-02 10:13	2026-10-02 10:13	TSM	TSM261120C00550000	call	550.0000	2026-11-20	3.6000	3.5000	3.6000	470.5900	70560.00	70560.00	0.00	196	27	355	1385	0.256317689530686	0.343083002954647	0.343083002954647	false	false	false	true
22a13d20-e082-40f2-aa70-1dd51d9d80d8	2026-10-02 10:11	2026-10-02 10:11	2026-10-02 10:11	TSM	TSM261016C00462500	call	462.5000	2026-10-16	17.2000	17.0500	17.4500	469.7310	17200.00	1720.00	15480.00	10	5	35	503	0.0695825049701789	0.352774595471249	0.352774595471249	true	false	false	true
178f3eb8-5fb2-4233-ae99-d614c7646e2f	2026-10-02 10:09	2026-10-02 10:09	2026-10-02 10:09	TSM	TSM290119C00400000	call	400.0000	2029-01-19	165.3000	165.3000	167.0000	469.6450	347130.00	0.00	49590.00	21	19	63	847	0.0743801652892562	0.407701331833722	0.407701331833722	false	false	false	true
dc12d203-6373-4407-b4a2-1e07ef652154	2026-10-02 10:08	2026-10-02 10:08	2026-10-02 10:08	TSM	TSM261009C00475000	call	475.0000	2026-10-09	5.4500	5.4500	5.6500	470.0800	10900.00	0.00	10900.00	20	9	329	1741	0.1889718552556	0.287674194179149	0.287674194179149	true	false	false	true
f3279fdc-9428-456b-90c5-0101a6cb3427	2026-10-02 10:03	2026-10-02 10:03	2026-10-02 10:03	TSM	TSM261120P00400000	put	400.0000	2026-11-20	2.5600	2.3800	2.5800	471.2950	92490.00	39960.00	52530.00	361	56	424	4972	0.085277554304103	0.355346506593498	0.355346506593498	false	false	false	true
e1d9946e-d80e-405a-a16d-60a68c9017fb	2026-10-02 10:02	2026-10-02 10:02	2026-10-02 10:02	TSM	TSM261106C00505000	call	505.0000	2026-11-06	8.2500	7.9500	8.3500	471.9895	15675.00	14025.00	825.00	19	8	25	47	0.531914893617021	0.333309090870887	0.333309090870887	false	false	false	true
ced55987-1992-47bf-b563-a4443f282e0e	2026-10-02 10:02	2026-10-02 10:02	2026-10-02 10:02	TSM	TSM261023P00440000	put	440.0000	2026-10-23	4.0400	4.0000	4.0500	471.6950	10905.00	8505.00	2400.00	27	7	28	146	0.191780821917808	0.346637493490011	0.344964245637763	false	false	false	true
751d0012-647a-4fcf-bb2d-cf5e043d7b6e	2026-10-02 10:01	2026-10-02 10:01	2026-10-02 10:01	TSM	TSM261120C00500000	call	500.0000	2026-11-20	13.1000	12.8500	13.1000	471.0000	24890.00	24890.00	0.00	19	8	121	3027	0.0399735711925999	0.337515277218417	0.337515277218417	false	false	false	true
09c19732-e038-4944-9e7f-a7010d561a6e	2026-10-02 10:01	2026-10-02 10:01	2026-10-02 10:01	TSM	TSM270319P00400000	put	400.0000	2027-03-19	14.4200	13.9500	15.0000	470.0000	21624.00	0.00	21624.00	15	7	32	2404	0.0133111480865225	0.367657537868444	0.367997616400123	false	false	false	true
f377df5f-ee4d-4993-ae17-2926e5e92436	2026-10-02 10:00	2026-10-02 10:00	2026-10-02 10:00	TSM	TSM261030C00530000	call	530.0000	2026-10-30	2.4800	2.4600	2.6800	471.0000	14657.00	3328.00	11329.00	59	20	59	93	0.634408602150538	0.338318922506083	0.341144388680519	false	false	false	true
4d72e06d-310d-4eb2-b65c-bb4f0ed8130a	2026-10-02 09:58	2026-10-02 09:57	2026-10-02 09:57	TSM	TSM261023C00475000	call	475.0000	2026-10-23	13.9000	13.5500	14.7500	471.1600	11120.00	9730.00	1390.00	8	5	93	416	0.223557692307692	0.336846220285647	0.336846220285647	false	false	false	true