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

3dd0f868-1f68-4ebe-928b-98684f114896	2026-10-02 09:56	2026-10-02 09:56	2026-10-02 09:56	TSM	TSM261002C00467500	call	467.5000	2026-10-02	3.5200	3.4500	3.7000	470.2099	10920.00	5320.00	5600.00	31	13	508	2257	0.225077536552946	0.367115852731719	0.382737543275168	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ADR	Technology	2452075788513.00	2026-10-15	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T13:56:19.835734Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
ef5ab9b3-4029-41f6-ac35-9607d3cd6716	2026-10-02 09:55	2026-10-02 09:55	2026-10-02 09:55	TSM	TSM261030C00485000	call	485.0000	2026-10-30	11.5100	11.4500	11.8500	469.7900	10355.00	3455.00	6900.00	9	9	11	198	0.0555555555555556	0.331988789897811	0.332501460568567	true	false	false	true
08abf779-8a99-4109-8752-64e1d4e11bb6	2026-10-02 09:55	2026-10-02 09:55	2026-10-02 09:55	TSM	TSM261030C00475000	call	475.0000	2026-10-30	15.5500	15.3000	15.9500	469.7900	77750.00	1555.00	43540.00	50	7	66	353	0.186968838526912	0.332475695442352	0.333082712128452	true	false	false	true
5d7239ab-ece1-4046-8b96-01fe926e9408	2026-10-02 09:55	2026-10-02 09:55	2026-10-02 09:55	TSM	TSM261009P00480000	put	480.0000	2026-10-09	13.3200	13.1000	13.3500	470.4800	10655.00	8000.00	2655.00	8	8	21	30	0.7	0.30366819030459	0.303102050644486	false	false	false	true	false
c414caef-0b0d-4662-8282-a606ec6629be	2026-10-02 09:54	2026-10-02 09:54	2026-10-02 09:54	TSM	TSM261030C00505000	call	505.0000	2026-10-30	6.1800	6.0000	6.3500	470.0000	12362.00	0.00	12362.00	20	8	32	470	0.0680851063829787	0.335153927676199	0.335638341229551	false	false	false	true
9e768273-fea2-4357-9fd7-5c81923bc732	2026-10-02 09:54	2026-10-02 09:54	2026-10-02 09:54	TSM	TSM261016P00432500	put	432.5000	2026-10-16	2.0600	1.8500	2.0700	470.0000	34566.00	22326.00	12240.00	168	27	176	66	2.66666666666667	0.378361573425532	0.378361573425532	false	false	false	true
a633c50c-5c90-4afc-bffd-6b55d4084ae3	2026-10-02 09:54	2026-10-02 09:54	2026-10-02 09:54	TSM	TSM270115C00460000	call	460.0000	2027-01-15	43.6000	42.9000	43.6000	470.0000	361880.00	361880.00	0.00	83	8	105	4796	0.0218932443703086	0.354777113209165	0.354777113209165	false	false	false	true
96644cc4-df2c-412e-a8d1-91aeba30b524	2026-10-02 09:51	2026-10-02 09:51	2026-10-02 09:51	TSM	TSM261218C00400000	call	400.0000	2026-12-18	78.0000	77.2000	78.5000	469.0000	132600.00	85800.00	46800.00	17	6	22	1659	0.0132610006027728	0.347258780867772	0.347258780867772	false	false	false	true
041d8222-9cc8-4aa9-a4b1-d5a4283f7c2a	2026-10-02 09:51	2026-10-02 09:51	2026-10-02 09:51	TSM	TSM290119C00400000	call	400.0000	2029-01-19	164.1500	164.1500	166.5000	468.9700	344715.00	0.00	344715.00	21	19	42	847	0.0495867768595041	0.404777340525949	0.404777340525949	false	false	false	true
e9e378ee-7e86-48c8-84f2-12edd8d48158	2026-10-02 09:50	2026-10-02 09:50	2026-10-02 09:50	TSM	TSM261106C00500000	call	500.0000	2026-11-06	8.7500	8.5000	8.8000	469.5200	15750.00	14875.00	0.00	18	9	23	113	0.20353982300885	0.332008297439699	0.332008297439699	false	false	false	true
b0df3941-2bdc-43ed-898b-a4919223d4f5	2026-10-02 09:48	2026-10-02 09:48	2026-10-02 09:48	TSM	TSM261016C00450000	call	450.0000	2026-10-16	25.3300	25.3000	26.0000	469.6700	70910.00	5120.00	65790.00	28	13	120	9515	0.0126116657908565	0.349036858362123	0.360703629184383	false	false	false	true
8a07b1a5-8f5f-47d3-bec2-71ba6f60017a	2026-10-02 09:48	2026-10-02 09:48	2026-10-02 09:48	TSM	TSM261002C00457500	call	457.5000	2026-10-02	11.7500	11.7500	12.6000	469.7250	98704.00	0.00	98704.00	84	22	184	594	0.30976430976431	0.730984788575488	0.730984788575488	false	false	false	true
e4383599-552d-4075-a294-1da440629e78	2026-10-02 09:48	2026-10-02 09:47	2026-10-02 09:47	TSM	TSM261002C00470000	call	470.0000	2026-10-02	1.8500	1.7400	1.8500	469.0000	18500.00	18500.00	0.00	100	9	720	2551	0.282242257938064	0.404281585399487	0.404281585399487	false	false	false	true
4829f3b3-8428-4e55-a21b-df071bfc30e3	2026-10-02 09:46	2026-10-02 09:46	2026-10-02 09:46	TSM	TSM270115C00450000	call	450.0000	2027-01-15	48.0000	47.0500	48.0000	469.0000	57600.00	57600.00	0.00	12	10	99	13860	0.00714285714285714	0.351494012875281	0.351494012875281	false	false	false	true
61896c1d-f6fd-454e-a461-701ff04a7d9d	2026-10-02 09:46	2026-10-02 09:46	2026-10-02 09:46	TSM	TSM270115C00500000	call	500.0000	2027-01-15	25.0000	23.5500	25.1000	468.0000	112510.00	112510.00	0.00	45	9	70	18954	0.00369315184129999	0.351063086119078	0.352075955511592	false	false	false	true
90ac916b-e2d9-4cfc-9870-3830eeaa73fd	2026-10-02 09:45	2026-10-02 09:45	2026-10-02 09:45	TSM	TSM270115C00450000	call	450.0000	2027-01-15	47.0000	46.1000	47.0000	467.6350	47000.00	47000.00	0.00	10	9	76	13860	0.00548340548340548	0.351111309201047	0.351111309201047	false	false	false	true
78830977-c3f6-4c8e-bc42-2e2646e1a173	2026-10-02 09:40	2026-10-02 09:40	2026-10-02 09:40	TSM	TSM261009C00460000	call	460.0000	2026-10-09	11.0000	11.0000	11.2500	465.7700	33000.00	0.00	33000.00	30	8	119	869	0.136939010356732	0.295105653101623	0.295105653101623	true	false	false	true
0ae3227f-10b6-4366-a05f-8d1e0f87743f	2026-10-02 09:40	2026-10-02 09:40	2026-10-02 09:40	TSM	TSM261113C00470000	call	470.0000	2026-11-13	20.0300	19.3000	20.9000	465.7700	10015.00	6015.00	4000.00	5	5	5	11	0.454545454545455	0.332400227637391	0.333193613019606	false	false	false	true
4b19bbfb-41b9-47b3-a056-d5f395b6d07a	2026-10-02 09:40	2026-10-02 09:40	2026-10-02 09:40	TSM	TSM261106C00460000	call	460.0000	2026-11-06	22.9100	22.8500	23.2500	465.8200	20615.00	4585.00	16030.00	9	9	88	11836	0.00743494423791822	0.330159479947303	0.330159479947303	true	false	false	true
b477c4a1-af1e-4c77-887a-91192fd9fb9d	2026-10-02 09:39	2026-10-02 09:39	2026-10-02 09:39	TSM	TSM261016C00460000	call	460.0000	2026-10-16	16.6300	16.3000	17.0000	466.1300	23275.00	11645.00	11630.00	14	6	44	5247	0.00838574423480084	0.35801090245537	0.356595691605513	true	false	false	true
4d668360-8fb4-4d70-81c5-1e21bb91c9c3	2026-10-02 09:39	2026-10-02 09:39	2026-10-02 09:39	TSM	TSM261016C00465000	call	465.0000	2026-10-16	13.9400	13.7500	14.2500	466.1300	23690.00	4175.00	19515.00	17	17	43	413	0.104116222760291	0.356417558031351	0.356417558031351	true	false	false	true
1e96955f-9e41-46b7-8e90-142f3666490a	2026-10-02 09:39	2026-10-02 09:39	2026-10-02 09:39	TSM	TSM261023C00465000	call	465.0000	2026-10-23	16.1000	16.0000	16.4000	466.1300	28985.00	9690.00	19295.00	18	10	24	301	0.079734219269103	0.33530023112213	0.33642674185874	true	false	false	true
965f2946-b5f9-4123-9fe6-0ec61b7c0d55	2026-10-02 09:38	2026-10-02 09:38	2026-10-02 09:38	TSM	TSM261002C00420000	call	420.0000	2026-10-02	45.5000	45.0000	45.5000	465.9700	1820001.00	59151.00	31850.00	400	83	400	505	0.792079207920792	1.18235647955725	1.18235647955725	true	false	false	true
0063a0ad-8d51-4998-9786-31d160a151aa	2026-10-02 09:38	2026-10-02 09:38	2026-10-02 09:38	TSM	TSM261016C00440000	call	440.0000	2026-10-16	30.7500	30.7500	31.1000	466.2900	27675.00	0.00	27675.00	9	9	303	6791	0.0446178766013842	0.369495717122877	0.369495717122877	true	false	false	true
23c32bf1-8716-4546-bac3-dbeacbc32784	2026-10-02 09:38	2026-10-02 09:38	2026-10-02 09:38	TSM	TSM261016C00440000	call	440.0000	2026-10-16	30.7500	30.7500	31.2000	466.3480	89175.00	0.00	89175.00	29	16	294	6791	0.0432925931379767	0.367634996615913	0.367634996615913	false	false	false	true
a2d0e5f2-facc-4dc4-8762-99691554f7db	2026-10-02 09:38	2026-10-02 09:38	2026-10-02 09:38	TSM	TSM261016C00440000	call	440.0000	2026-10-16	30.7500	30.7500	31.2500	466.3250	187575.00	0.00	187575.00	61	36	258	6791	0.0379914592843469	0.368374373304142	0.368374373304142	false	false	false	true
9f1e0fe7-802f-4cfe-8415-7ab1fd2ba26e	2026-10-02 09:38	2026-10-02 09:37	2026-10-02 09:37	TSM	TSM261016C00440000	call	440.0000	2026-10-16	30.7500	30.7500	30.9500	466.2715	399750.00	0.00	399750.00	130	28	184	6791	0.0270946841407746	0.370086597470343	0.370086597470343	false	false	false	true
3588580a-784e-4e81-bf39-4b4625a6e033	2026-10-02 09:38	2026-10-02 09:37	2026-10-02 09:37	TSM	TSM261016C00440000	call	440.0000	2026-10-16	30.7500	30.7500	31.0000	466.2715	144525.00	0.00	18450.00	47	34	54	6791	0.00795170078044471	0.370086597470343	0.370086597470343	false	false	false	true
a2286ae3-a3ce-460a-b992-75596df9cc85	2026-10-02 09:37	2026-10-02 09:37	2026-10-02 09:37	TSM	TSM261218C00500000	call	500.0000	2026-12-18	16.9700	16.1000	17.1000	466.0100	10185.00	6800.00	3385.00	6	6	19	27104	0.000701003541912633	0.334920675562515	0.335537606500151	false	false	false	true
cbf34673-6e47-4dfd-9dd3-6656f2ff6d9c	2026-10-02 09:36	2026-10-02 09:36	2026-10-02 09:36	TSM	TSM261016P00452500	put	452.5000	2026-10-16	7.4000	7.2000	7.6000	464.8400	22200.00	740.00	17020.00	30	6	35	478	0.0732217573221757	0.359930929772672	0.359930929772672	true	false	false	true
53ab3846-db3d-467a-bd4f-c8a8dcfa09ab	2026-10-02 09:33	2026-10-02 09:33	2026-10-02 09:33	TSM	TSM261016C00470000	call	470.0000	2026-10-16	10.8500	10.5500	10.8500	464.9400	10850.00	10850.00	0.00	10	5	41	3197	0.0128245229903034	0.353509534340712	0.353509534340712	false	false	false	true
498c3674-beaf-4f2e-9a72-513a222ddad0	2026-10-02 09:32	2026-10-02 09:32	2026-10-02 09:32	TSM	TSM261009P00452500	put	452.5000	2026-10-09	2.7400	2.6200	3.2500	464.6400	10413.00	10138.00	275.00	38	8	43	119	0.361344537815126	0.290679844888919	0.291176370338285	true	false	false	true
3c22fd5f-2706-452c-915a-af6564ddd615	2026-10-02 09:32	2026-10-02 09:32	2026-10-02 09:32	TSM	TSM261016P00455000	put	455.0000	2026-10-16	8.1100	7.7000	8.2000	464.6400	10545.00	6515.00	4030.00	13	8	13	500	0.026	0.349707672100579	0.351178482800493	true	false	false	true	false
4a7ba3a4-5bf1-435b-a20f-7f6f2db2c250	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	TSM	TSM261009C00480000	call	480.0000	2026-10-09	2.3200	2.2300	2.4700	464.7516	10224.00	5054.00	5170.00	44	6	69	2042	0.0337904015670911	0.286130416740354	0.286751084019455	true	false	false	true
513ca2f9-4488-4d6d-8023-619e78dca507	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	TSM	TSM261016C00470000	call	470.0000	2026-10-16	10.6200	10.5500	11.0500	464.9750	15935.00	1065.00	14870.00	15	8	23	3197	0.00719424460431655	0.346147549519367	0.347530935706236	false	false	false	true
4c7a12e8-9e81-4013-b11d-6d90486b311b	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	TSM	TSM290119C00400000	call	400.0000	2029-01-19	160.6000	160.6000	163.0000	464.6700	337260.00	0.00	337260.00	21	19	21	847	0.0247933884297521	0.403660919116348	0.403660919116348	false	false	false	true
e4428f3c-7077-421e-94db-78f15dd5ca36	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TSM	TSM261002C00467500	call	467.5000	2026-10-02	1.4200	1.3000	2.3000	465.1000	17832.00	145.00	17687.00	126	8	170	2257	0.0753212228622065	0.475341925720074	0.481963263018088	false	false	false	true
58333b8d-87a7-4fa7-a259-6e8ad7709cab	2026-10-01 15:56	2026-10-01 15:56	2026-10-01 15:56	TSM	TSM270617P00420000	put	420.0000	2027-06-17	33.0600	32.9500	34.3000	459.3987	128940.00	75980.00	52960.00	39	10	54	965	0.0559585492227979	0.383651991360384	0.382903019499843	true	false	false	true
a78d2e16-7061-4d74-a0f6-642a8e2d0d64	2026-10-01 15:56	2026-10-01 15:56	2026-10-01 15:56	TSM	TSM270617P00410000	put	410.0000	2027-06-17	29.2500	28.9000	30.4500	459.3000	20475.00	8775.00	11700.00	7	5	32	1764	0.018140589569161	0.383646477150539	0.383646477150539	false	false	false	true
37c33933-cbed-4282-96f3-d982b5580cd6	2026-10-01 15:55	2026-10-01 15:55	2026-10-01 15:55	TSM	TSM261009C00477500	call	477.5000	2026-10-09	2.1900	1.8000	2.2700	459.0700	10311.00	5730.00	4581.00	47	12	181	99	1.82828282828283	0.299006300347761	0.29847792759946	true	false	false	true
e2685ec6-e9c2-4eeb-ac89-7512c6a8027a	2026-10-01 15:53	2026-10-01 15:53	2026-10-01 15:53	TSM	TSM261016C00430000	call	430.0000	2026-10-16	33.7600	32.1500	34.0500	459.7800	351070.00	351070.00	0.00	104	5	143	11807	0.0121114593038028	0.383726641913695	0.368074243026954	false	false	false	true
e111431d-24ce-4581-8de5-ed0b1eaaa271	2026-10-01 15:51	2026-10-01 15:51	2026-10-01 15:51	TSM	TSM261120P00450000	put	450.0000	2026-11-20	16.8400	16.4500	16.8500	459.2150	15160.00	13480.00	1680.00	9	5	1312	1334	0.983508245877061	0.33251508441046	0.33251508441046	false	false	false	true
1896abaa-1376-4f4e-9da1-c4956153f6d3	2026-10-01 15:51	2026-10-01 15:51	2026-10-01 15:51	TSM	TSM261030C00460000	call	460.0000	2026-10-30	17.5200	17.3000	18.0000	459.2150	24526.00	7006.00	15770.00	14	13	50	230	0.217391304347826	0.332615007138669	0.330674687610844	true	false	false	true
3bd0325c-03d5-4de0-bb82-d5a3d08b030a	2026-10-01 15:50	2026-10-01 15:50	2026-10-01 15:50	TSM	TSM270617P00440000	put	440.0000	2027-06-17	41.8000	41.5000	42.5500	459.1500	96140.00	37620.00	54340.00	23	14	84	452	0.185840707964602	0.383868564861381	0.383868564861381	true	false	false	true
a169129d-98a4-432c-8161-1348ad5f2f39	2026-10-01 15:50	2026-10-01 15:50	2026-10-01 15:50	TSM	TSM270617P00440000	put	440.0000	2027-06-17	41.8500	41.8500	43.1500	459.1550	20925.00	0.00	20925.00	5	5	61	452	0.134955752212389	0.384230778665251	0.384230778665251	false	false	false	true
3538a5f0-f363-41ff-9ca7-71de37364bf0	2026-10-01 15:46	2026-10-01 15:46	2026-10-01 15:46	TSM	TSM261002P00455000	put	455.0000	2026-10-02	1.5900	1.4900	1.5900	458.7800	10653.00	10653.00	0.00	67	26	584	357	1.63585434173669	0.32919647971212	0.32919647971212	false	false	false	true
12032003-d8cf-4a0c-b114-62090fe9b762	2026-10-01 15:44	2026-10-01 15:44	2026-10-01 15:44	TSM	TSM270416P00460000	put	460.0000	2027-04-16	45.0700	45.0500	45.5000	458.6500	67604.00	0.00	67604.00	15	10	130	336	0.386904761904762	0.375966310986496	0.375966310986496	false	false	false	true
84efa619-3afa-45ca-867b-24ce331aecab	2026-10-01 15:44	2026-10-01 15:44	2026-10-01 15:44	TSM	TSM270416P00460000	put	460.0000	2027-04-16	45.0700	45.0500	45.5000	458.6500	63095.00	22550.00	40545.00	14	5	100	336	0.297619047619048	0.375585563663049	0.375966310986496	false	false	false	true
2a503eaf-f683-4925-8dc0-20526ea99041	2026-10-01 15:42	2026-10-01 15:42	2026-10-01 15:42	TSM	TSM270319C00520000	call	520.0000	2027-03-19	26.4500	26.0000	26.7500	458.6050	37030.00	10580.00	15870.00	14	6	2756	1228	2.2442996742671	0.364210489450889	0.364210489450889	false	false	false	true
dca59c1c-2768-472b-9f1f-09da64e910e5	2026-10-01 15:38	2026-10-01 15:38	2026-10-01 15:38	TSM	TSM261106P00460000	put	460.0000	2026-11-06	18.6500	18.6500	18.9000	458.1550	80195.00	0.00	80195.00	43	18	59	215	0.274418604651163	0.325391971937767	0.325391971937767	false	false	false	true