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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = 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

948051c7-21c7-4a21-b9bf-7d14f9dbe31d	2026-09-22 14:50	2026-09-22 14:50	2026-09-22 14:50	TSM	TSM261030P00450000	put	450.0000	2026-10-30	18.2500	17.9000	18.6000	449.9300	65703.00	0.00	63878.00	36	17	47	26	1.80769230769231	0.331647695263979	0.331647695263979	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Technology	2344300216608.00	2026-10-15	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
5b311e2d-cd87-4916-8946-ff179ecdd2ba	2026-09-22 14:46	2026-09-22 14:46	2026-09-22 14:46	TSM	TSM261016C00435000	call	435.0000	2026-10-16	24.5500	23.8500	24.5500	449.6400	14730.00	14730.00	0.00	6	6	151	49	3.08163265306122	0.340842602456557	0.340842602456557	false	false	false	true
7cb0fbd7-22e4-4392-a7e7-5271a91c3a3a	2026-09-22 14:45	2026-09-22 14:45	2026-09-22 14:45	TSM	TSM261023P00425000	put	425.0000	2026-10-23	6.9500	6.9500	7.1500	449.6100	84790.00	0.00	84790.00	122	32	152	221	0.687782805429864	0.332872942455096	0.332872942455096	false	false	false	true
2bdecbfb-a7a5-429c-9c06-00f7b60b5d47	2026-09-22 14:41	2026-09-22 14:41	2026-09-22 14:41	TSM	TSM260925P00440000	put	440.0000	2026-09-25	1.6900	1.6850	1.7400	449.6099	28561.00	507.00	27716.00	169	44	895	664	1.34789156626506	0.320069527288399	0.321256536143125	false	false	false	true
cf61b827-57c0-4228-af19-b425e1813c92	2026-09-22 14:39	2026-09-22 14:39	2026-09-22 14:39	TSM	TSM260925C00445000	call	445.0000	2026-09-25	7.8500	7.8000	7.9000	449.4900	19625.00	1570.00	15700.00	25	5	1107	1840	0.601630434782609	0.322434354243114	0.322010337061128	false	false	false	true
3cc09a61-14d0-4ed8-9caa-0b71f49f3e9d	2026-09-22 14:35	2026-09-22 14:35	2026-09-22 14:35	TSM	TSM261030C00455000	call	455.0000	2026-10-30	17.9000	17.5500	17.9000	449.5100	12530.00	12530.00	0.00	7	5	73	32	2.28125	0.337999845066382	0.337999845066382	false	false	false	true
c1572468-6e36-448a-a3d6-41804921ce74	2026-09-22 14:34	2026-09-22 14:34	2026-09-22 14:34	TSM	TSM261030P00450000	put	450.0000	2026-10-30	18.6500	18.3500	19.0000	449.4550	16785.00	14920.00	1865.00	9	7	11	26	0.423076923076923	0.334751516760142	0.334751516760142	false	false	false	true
d995618c-bd29-4517-8d6c-6f47758210e3	2026-09-22 14:20	2026-09-22 14:20	2026-09-22 14:20	TSM	TSM270115C00490000	call	490.0000	2027-01-15	22.1000	22.1000	22.3000	449.5100	22100.00	0.00	22100.00	10	5	59	7741	0.00762175429531068	0.351089805298472	0.351089805298472	false	false	false	true
328ef23d-e7b2-41a6-9c5c-23c4f3b098d4	2026-09-22 14:16	2026-09-22 14:16	2026-09-22 14:16	TSM	TSM261120C00460000	call	460.0000	2026-11-20	21.4000	21.4000	21.7500	449.5500	25680.00	0.00	25680.00	12	8	218	3330	0.0654654654654655	0.343205353422337	0.343205353422337	false	false	false	true
25e5c2fc-5649-4a15-b716-04b3de760b00	2026-09-22 14:12	2026-09-22 14:12	2026-09-22 14:12	TSM	TSM261016C00475000	call	475.0000	2026-10-16	6.7000	6.7000	6.9000	449.6950	16753.00	0.00	16753.00	25	8	129	77	1.67532467532468	0.337317465778427	0.337317465778427	false	false	false	true
8c1f51d3-5fd1-4919-b825-915530577a5e	2026-09-22 14:09	2026-09-22 14:09	2026-09-22 14:09	TSM	TSM261120C00500000	call	500.0000	2026-11-20	9.0500	8.8500	9.1500	449.7300	19910.00	19910.00	0.00	22	5	131	2628	0.0498477929984779	0.344128150781652	0.344128150781652	false	false	false	true
c64d079a-4c6a-4613-a739-fc2c734b537d	2026-09-22 14:08	2026-09-22 14:08	2026-09-22 14:08	TSM	TSM270115C00500000	call	500.0000	2027-01-15	19.0000	18.4000	19.0000	449.4300	15200.00	15200.00	0.00	8	5	530	18067	0.0293352521171196	0.350086976817632	0.350086976817632	false	false	false	true
bf8a6242-0eea-46de-88cf-88ae813847d7	2026-09-22 14:08	2026-09-22 14:08	2026-09-22 14:08	TSM	TSM270115C00450000	call	450.0000	2027-01-15	37.5000	37.0000	37.7000	449.4300	56250.00	56250.00	0.00	15	8	1756	15017	0.116934141306519	0.347617323853463	0.347617323853463	false	false	false	true
0b4b2201-daa7-4758-aaa8-235e19b76c1d	2026-09-22 14:08	2026-09-22 14:07	2026-09-22 14:07	TSM	TSM261030P00440000	put	440.0000	2026-10-30	13.8500	13.8500	14.1500	449.1800	15235.00	0.00	15235.00	11	5	38	552	0.0688405797101449	0.330492435388185	0.330492435388185	false	false	false	true
2ce0b32e-e22c-4d58-9d7c-9e924a7d8564	2026-09-22 13:53	2026-09-22 13:53	2026-09-22 13:53	TSM	TSM261009C00460000	call	460.0000	2026-10-09	7.4000	7.3000	7.5000	448.8850	24420.00	0.00	23680.00	33	15	89	504	0.176587301587302	0.302746667491209	0.302746667491209	false	false	false	true
9b111385-c79b-4c65-a20a-751d5088064e	2026-09-22 13:53	2026-09-22 13:53	2026-09-22 13:53	TSM	TSM261120C00470000	call	470.0000	2026-11-20	17.1900	17.0500	17.8000	448.9700	10315.00	3440.00	6875.00	6	5	181	3208	0.0564214463840399	0.343354178449791	0.342054162163703	false	false	false	true
b9940316-10f2-4e89-9910-c61f840dce65	2026-09-22 13:53	2026-09-22 13:53	2026-09-22 13:53	TSM	TSM261002C00440000	call	440.0000	2026-10-02	14.2000	14.1500	14.9500	448.5800	21300.00	0.00	21300.00	15	7	95	886	0.107223476297968	0.303114282576679	0.303488320400327	false	false	false	true
e4e917ee-71cd-484c-bf90-f1094159fa54	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	TSM	TSM270115C00450000	call	450.0000	2027-01-15	37.0000	36.7000	37.0000	448.8400	133200.00	133200.00	0.00	36	10	1699	15017	0.113138443097822	0.345922957778632	0.345922957778632	false	false	false	true
0bf09a3e-48a7-40a6-8457-3d0007b85ca9	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	TSM	TSM261002P00445000	put	445.0000	2026-10-02	6.7500	6.4500	6.7500	448.7950	119470.00	66825.00	670.00	177	5	885	56	15.8035714285714	0.295762998724	0.295762998724	false	false	false	true
a47eb0cb-e953-491a-a65b-5e8f56fcb018	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	TSM	TSM261002C00442500	call	442.5000	2026-10-02	12.7500	12.2000	12.7500	448.3400	446230.00	441150.00	5080.00	350	37	493	251	1.96414342629482	0.315523170205364	0.314651900979772	true	false	false	true
3b79cf7f-e0da-4a00-b188-9c9f3c4b342c	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	TSM	TSM261002C00450000	call	450.0000	2026-10-02	8.4500	8.1500	8.4500	448.3000	26195.00	26195.00	0.00	31	5	396	881	0.449489216799092	0.305101684897881	0.305101684897881	false	false	false	true
ef5c04c8-43f0-466b-986b-e07b94c0d0c1	2026-09-22 13:50	2026-09-22 13:50	2026-09-22 13:50	TSM	TSM261218P00460000	put	460.0000	2026-12-18	33.8500	33.6000	33.8500	448.0500	40620.00	30465.00	0.00	12	12	62	516	0.12015503875969	0.341411879429876	0.341411879429876	false	false	false	true
f90d5e59-a8e5-464a-bab9-ad097d6ce069	2026-09-22 13:49	2026-09-22 13:49	2026-09-22 13:49	TSM	TSM261218C00490000	call	490.0000	2026-12-18	15.8000	15.5000	15.8000	448.0844	11060.00	11060.00	0.00	7	7	22	1962	0.0112130479102956	0.340093654162307	0.340093654162307	false	false	false	true
49ce3cf1-18b3-4016-9856-12406d62788c	2026-09-22 13:49	2026-09-22 13:49	2026-09-22 13:49	TSM	TSM261023P00425000	put	425.0000	2026-10-23	7.3000	7.3000	7.5000	448.1386	10950.00	0.00	10950.00	15	5	30	221	0.135746606334842	0.332159246376578	0.332159246376578	false	false	false	true
d239e345-6023-44e1-b44d-8a8cb046c208	2026-09-22 13:45	2026-09-22 13:45	2026-09-22 13:45	TSM	TSM261218C00500000	call	500.0000	2026-12-18	13.2000	12.8500	13.2000	447.9400	18480.00	18480.00	0.00	14	11	81	26720	0.0030314371257485	0.34121678727211	0.34121678727211	false	false	false	true
0fd5d698-3b48-4745-80d5-c60f7b9848c4	2026-09-22 13:43	2026-09-22 13:43	2026-09-22 13:43	TSM	TSM261030C00475000	call	475.0000	2026-10-30	9.7000	9.7000	10.0000	447.7500	18430.00	0.00	18430.00	19	5	24	50	0.48	0.334551021450612	0.334551021450612	false	false	false	true
b880062a-320c-42f5-8887-244ab6fd12a4	2026-09-22 13:36	2026-09-22 13:36	2026-09-22 13:36	TSM	TSM261023P00450000	put	450.0000	2026-10-23	17.6000	17.4000	17.6000	447.0000	353760.00	353760.00	0.00	201	11	286	100	2.86	0.329554912340091	0.329554912340091	false	false	false	true
8c17f21b-125f-456d-9a87-22d83fee2d86	2026-09-22 13:36	2026-09-22 13:36	2026-09-22 13:36	TSM	TSM261023P00450000	put	450.0000	2026-10-23	17.6000	17.3500	17.6000	447.0000	42240.00	42240.00	0.00	24	8	85	100	0.85	0.329554912340091	0.329554912340091	true	false	false	true
91f5a65c-ef63-4890-80e0-5e36e00096b8	2026-09-22 13:31	2026-09-22 13:31	2026-09-22 13:31	TSM	TSM261016P00430000	put	430.0000	2026-10-16	7.4000	7.2500	7.4500	447.0000	20720.00	19980.00	0.00	28	12	91	4617	0.0197097682477799	0.334058139512654	0.334058139512654	false	false	false	true
11c7cccd-2a63-4a63-ad99-4336ee63d54a	2026-09-22 13:31	2026-09-22 13:31	2026-09-22 13:31	TSM	TSM261009P00442500	put	442.5000	2026-10-09	8.6000	8.4500	8.6000	447.0000	12040.00	12040.00	0.00	14	8	31	16	1.9375	0.297389598690338	0.297389598690338	false	false	false	true
aa961ca8-643a-4f5b-ba70-250f14cbb74d	2026-09-22 13:30	2026-09-22 13:30	2026-09-22 13:30	TSM	TSM261120P00480000	put	480.0000	2026-11-20	42.4500	42.2000	42.6000	447.7600	84900.00	76410.00	8490.00	20	5	76	398	0.190954773869347	0.341726650664656	0.341627837452007	false	false	false	true
403ddfff-cdc8-4a72-b059-1239ee6852cb	2026-09-22 13:26	2026-09-22 13:26	2026-09-22 13:26	TSM	TSM261016P00437500	put	437.5000	2026-10-16	9.9500	9.6000	10.0000	447.7000	10943.00	10943.00	0.00	11	7	15	13	1.15384615384615	0.33049308423354	0.33049308423354	false	false	false	true
44055f6e-bcd8-44a4-a662-0157a97aade5	2026-09-22 13:24	2026-09-22 13:24	2026-09-22 13:24	TSM	TSM261218P00430000	put	430.0000	2026-12-18	19.1500	18.7500	19.2000	447.6600	19150.00	19150.00	0.00	10	5	52	2314	0.0224719101123595	0.338927338594179	0.338927338594179	false	false	false	true
ef0aee0b-5139-436f-9de0-ec8e2735638d	2026-09-22 13:17	2026-09-22 13:17	2026-09-22 13:17	TSM	TSM270319P00370000	put	370.0000	2027-03-19	11.2500	11.0500	11.2500	447.9700	11250.00	11250.00	0.00	10	7	45	2130	0.0211267605633803	0.360418772567747	0.360418772567747	false	false	false	true
1fb95c91-3e04-4081-8421-2b59d686b445	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	TSM	TSM261120C00490000	call	490.0000	2026-11-20	10.8500	10.6500	11.1000	448.4300	131285.00	130200.00	1085.00	121	24	216	926	0.233261339092873	0.341474481401378	0.341474481401378	true	false	false	true
916e46c4-8f5c-410b-bdc5-31d584bddd2c	2026-09-22 13:05	2026-09-22 13:05	2026-09-22 13:05	TSM	TSM261120C00460000	call	460.0000	2026-11-20	20.3600	20.3000	20.6500	448.0000	20363.00	6153.00	14210.00	10	7	160	3330	0.048048048048048	0.336627367257277	0.339786171859547	false	false	false	true
d3b3cb0f-80c0-488f-b1fd-5300dbfc9ee2	2026-09-22 13:01	2026-09-22 13:01	2026-09-22 13:01	TSM	TSM270917P00290000	put	290.0000	2027-09-17	7.5500	7.5500	7.7000	448.0000	15100.00	0.00	15100.00	20	5	1136	1187	0.957034540859309	0.398370732856754	0.398431070917055	false	false	false	true
5462de83-887e-4633-b1ef-3926890d58bc	2026-09-22 12:53	2026-09-22 12:53	2026-09-22 12:53	TSM	TSM270115C00590000	call	590.0000	2027-01-15	4.6500	4.6500	4.7500	447.7350	51615.00	0.00	51615.00	111	33	134	592	0.226351351351351	0.359183863242391	0.359183863242391	false	false	false	true
d9a49607-cb01-495a-abdd-f81544baf76e	2026-09-22 12:49	2026-09-22 12:49	2026-09-22 12:49	TSM	TSM261120P00420000	put	420.0000	2026-11-20	11.2000	11.0000	11.2000	447.5500	17920.00	17920.00	0.00	16	10	912	1835	0.49700272479564	0.33619624496024	0.33619624496024	false	false	false	true
ad229ae9-0a3a-4c51-b83e-44dbc578562a	2026-09-22 12:42	2026-09-22 12:42	2026-09-22 12:42	TSM	TSM270115C00450000	call	450.0000	2027-01-15	36.0000	35.5000	36.1000	447.1850	100796.00	100796.00	0.00	28	10	1470	15017	0.0978890590663914	0.345135630670478	0.344934112590713	false	false	false	true
07530c83-92c8-432a-ac7b-1066597ecfc3	2026-09-22 12:16	2026-09-22 12:16	2026-09-22 12:16	TSM	TSM270115C00550000	call	550.0000	2027-01-15	8.5000	8.5000	8.7000	446.6900	46750.00	0.00	46750.00	55	15	305	16324	0.0186841460426366	0.354771037768232	0.354771037768232	false	false	false	true
aa52fa0c-7f8c-4761-b0c2-4e6b1b2d610c	2026-09-22 11:59	2026-09-22 11:59	2026-09-22 11:59	TSM	TSM270115C00450000	call	450.0000	2027-01-15	36.0000	35.5500	36.0000	447.1400	21599.00	21599.00	0.00	6	5	1213	15017	0.0807751215289339	0.345386423564993	0.345386423564993	false	false	false	true
70d0b8b7-91b4-4cf4-81f2-d55f688a4422	2026-09-22 11:57	2026-09-22 11:57	2026-09-22 11:57	TSM	TSM280121C00610000	call	610.0000	2028-01-21	40.3500	40.0500	40.4500	446.3600	250170.00	246135.00	4035.00	62	16	100	225	0.444444444444444	0.387527603494284	0.387527603494284	false	false	false	true
903796d8-245e-4a74-89de-a7c602c63198	2026-09-22 11:54	2026-09-22 11:54	2026-09-22 11:54	TSM	TSM270115C00450000	call	450.0000	2027-01-15	35.6000	35.6000	36.0000	446.4400	751165.00	0.00	747600.00	211	54	1183	15017	0.0787773856296198	0.345245191145304	0.345245191145304	false	false	false	true
e9aa7d78-494c-413a-bb48-60bae0659fbb	2026-09-22 11:48	2026-09-22 11:47	2026-09-22 11:47	TSM	TSM270115C00450000	call	450.0000	2027-01-15	36.1000	35.8500	36.2000	447.0299	28880.00	28880.00	0.00	8	5	950	15017	0.0632616368116135	0.347007446107663	0.347007446107663	false	false	false	true
40ba78c3-f1b0-4a11-a957-cf413fa96dcd	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	TSM	TSM270115C00450000	call	450.0000	2027-01-15	36.0000	35.8000	36.0000	446.8275	72000.00	72000.00	0.00	20	10	940	15017	0.0625957248451755	0.347125960121941	0.347125960121941	false	false	false	true
9259fec2-8f7e-49b7-b632-c6497d76b462	2026-09-22 11:41	2026-09-22 11:41	2026-09-22 11:41	TSM	TSM270115C00450000	call	450.0000	2027-01-15	35.6500	35.5000	35.8000	446.3600	267375.00	71300.00	196075.00	75	13	875	15017	0.0582672970633282	0.346040246420927	0.346192622165929	false	false	false	true
f296071f-14c3-4501-b934-8a0c1ac24ab9	2026-09-22 11:34	2026-09-22 11:34	2026-09-22 11:34	TSM	TSM261218P00350000	put	350.0000	2026-12-18	2.5000	2.5000	2.5900	445.8700	22500.00	0.00	22500.00	90	15	545	8879	0.0613807861245636	0.365660354429253	0.365660354429253	false	false	false	true
b31c41bd-eaf6-4e78-8fa0-26111a8401f9	2026-09-22 11:32	2026-09-22 11:32	2026-09-22 11:32	TSM	TSM261218P00350000	put	350.0000	2026-12-18	2.4900	2.4500	2.5000	445.0000	20667.00	4731.00	15189.00	83	23	455	8879	0.0512445095168375	0.365091681480866	0.365091681480866	false	false	false	true
6a87f547-d373-4374-ae0d-cde34a2c3fcc	2026-09-22 11:32	2026-09-22 11:32	2026-09-22 11:32	TSM	TSM261218P00350000	put	350.0000	2026-12-18	2.4800	2.4500	2.4900	445.0000	15872.00	8184.00	7688.00	64	16	372	8879	0.0418966099786012	0.364735522935798	0.364735522935798	false	false	false	true