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 = TSM×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

58ffb6f4-8d8a-4b1a-95c1-b70ed36e4603	2026-08-28 11:18	2026-08-28 11:18	2026-08-28 11:18	TSM	TSM280616C00600000	call	600.0000	2028-06-16	56.1800	55.9500	58.2500	424.9800	213490.00	61885.00	151605.00	38	14	39	65	0.6	0.42574668791632	0.424852793600656	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ADR	Technology	2168010914921.00	2026-10-15	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
17b92d17-b1c5-4a29-8bd5-02a37ece675b	2026-08-28 11:19	2026-08-28 11:19	2026-08-28 11:19	TSM	TSM281215P00380000	put	380.0000	2028-12-15	66.2600	66.2500	67.9500	425.5950	165641.00	0.00	165641.00	25	11	26	545	0.0477064220183486	0.445202326419426	0.445202326419426	false	false	false	true	false
97258d79-becf-42c7-8097-09c8afca7282	2026-08-28 11:28	2026-08-28 11:28	2026-08-28 11:28	TSM	TSM281215C00410000	call	410.0000	2028-12-15	130.0000	128.4500	131.9500	425.3900	416005.00	13000.00	403005.00	32	19	219	1186	0.184654300168634	0.427288737272199	0.427288737272199	false	false	false	true	false
eb098548-85e5-45c7-8940-caa3adf5c915	2026-08-28 11:47	2026-08-28 11:47	2026-08-28 11:47	TSM	TSM281215C00410000	call	410.0000	2028-12-15	129.0500	129.0500	131.0000	423.0000	400055.00	0.00	12905.00	31	18	251	1186	0.211635750421585	0.429308720150929	0.429308720150929	false	false	false	true	false
d1a48c0c-2ac1-4ee9-84e5-d0a6f96f8432	2026-08-28 12:06	2026-08-28 12:06	2026-08-28 12:06	TSM	TSM281215C00410000	call	410.0000	2028-12-15	127.0500	127.0500	128.9500	421.0000	317625.00	0.00	317625.00	25	16	276	1186	0.232715008431703	0.426638170193561	0.426638170193561	false	false	false	true	false
d8fc38f4-021c-46cb-b567-95c47a154e37	2026-08-28 12:26	2026-08-28 12:26	2026-08-28 12:26	TSM	TSM281215C00410000	call	410.0000	2028-12-15	127.1500	125.2500	129.0000	420.9100	394165.00	12715.00	25430.00	31	18	313	1186	0.263912310286678	0.428552571985805	0.428552571985805	false	false	false	true	false
37370306-ca3e-43d2-b837-00ad94d572ee	2026-08-28 12:48	2026-08-28 12:47	2026-08-28 12:47	TSM	TSM281215C00410000	call	410.0000	2028-12-15	128.2000	128.2000	129.2500	422.3400	397420.00	0.00	12820.00	31	19	344	1186	0.290050590219224	0.428789039650019	0.428789039650019	false	false	false	true	false
8ce2bb61-1317-421f-ab02-f07bea7e06d1	2026-08-28 13:05	2026-08-28 13:04	2026-08-28 13:04	TSM	TSM281215C00410000	call	410.0000	2028-12-15	127.2000	126.2750	129.0000	420.7126	394320.00	38160.00	12720.00	31	18	375	1186	0.316188870151771	0.429392537169641	0.429392537169641	false	false	false	true	false
9f715c64-65f0-439b-bdd9-5dbead48a922	2026-08-28 13:08	2026-08-28 13:08	2026-08-28 13:08	TSM	TSM260918C00410000	call	410.0000	2026-09-18	18.3500	17.9000	18.3500	420.1300	579860.00	396360.00	0.00	316	73	334	4740	0.0704641350210971	0.303580219996925	0.303580219996925	true	false	false	true	false
2175b30b-d01f-44db-8898-14750756f1e6	2026-08-28 13:29	2026-08-28 13:29	2026-08-28 13:29	TSM	TSM281215C00410000	call	410.0000	2028-12-15	127.3500	125.6000	128.5000	421.1800	394785.00	12735.00	25470.00	31	19	406	1186	0.342327150084317	0.428605969824619	0.428605969824619	false	false	false	true	false
fc66b44f-a984-4062-8a43-0f77ee82fd95	2026-08-28 13:46	2026-08-28 13:46	2026-08-28 13:46	TSM	TSM281215C00410000	call	410.0000	2028-12-15	127.2000	125.4500	128.6000	421.1050	394320.00	12720.00	63600.00	31	19	437	1186	0.368465430016863	0.428168094078353	0.428168094078353	false	false	false	true	false
9f6b2a50-cb23-4009-b0ec-2f54439b6119	2026-08-28 14:04	2026-08-28 14:04	2026-08-28 14:04	TSM	TSM281215C00410000	call	410.0000	2028-12-15	126.9500	126.9500	128.4500	420.8950	393545.00	0.00	393545.00	31	19	468	1186	0.39460370994941	0.427703367262581	0.427703367262581	false	false	false	true	false
d8792a25-529c-42b1-8389-516e3219a668	2026-08-28 14:29	2026-08-28 14:29	2026-08-28 14:29	TSM	TSM281215C00410000	call	410.0000	2028-12-15	126.6500	126.6500	127.3500	420.4950	215305.00	0.00	215305.00	17	17	499	1186	0.420741989881956	0.427606678795992	0.427606678795992	false	false	false	true	false
d9c84bc8-42e2-4e63-99f3-449eea38ec31	2026-08-28 14:38	2026-08-28 14:38	2026-08-28 14:38	TSM	TSM281215C00680000	call	680.0000	2028-12-15	55.7900	54.3000	56.2000	420.0175	223150.00	217570.00	5580.00	40	7	71	475	0.149473684210526	0.431984162047295	0.431780689029545	false	false	false	true	false
f7e1f147-7e3c-4a40-9d55-d100a4f6b2a4	2026-08-28 14:39	2026-08-28 14:38	2026-08-28 14:38	TSM	TSM271217P00330000	put	330.0000	2027-12-17	28.1100	28.1000	28.6500	420.1700	168631.00	0.00	168631.00	60	9	75	222	0.337837837837838	0.420538605243275	0.420538605243275	false	false	false	true	false
2d21820c-d722-486b-8e53-e9a8787f0bca	2026-08-28 14:42	2026-08-28 14:42	2026-08-28 14:42	TSM	TSM281215C00410000	call	410.0000	2028-12-15	126.0500	126.0500	127.3500	419.6000	390755.00	0.00	25210.00	31	18	530	1186	0.446880269814503	0.427706247897676	0.427706247897676	false	false	false	true	false
599a123f-3230-4e77-ab4f-a6b31ab6aba9	2026-08-28 14:57	2026-08-28 14:56	2026-08-28 14:56	TSM	TSM270115C00500000	call	500.0000	2027-01-15	15.5000	14.8000	15.5000	418.6600	341000.00	341000.00	0.00	220	5	269	17258	0.0155869741569127	0.380419528578618	0.380419528578618	false	false	false	true	false
c215ccb9-e989-456b-b78b-94c376dfc64c	2026-08-28 15:01	2026-08-28 15:01	2026-08-28 15:01	TSM	TSM281215C00410000	call	410.0000	2028-12-15	125.3000	125.3000	126.7500	418.5200	375900.00	0.00	50120.00	30	17	560	1186	0.472175379426644	0.427703848476435	0.427703848476435	false	false	false	true	false
e9d141a2-f912-413f-8d02-19471109caf8	2026-08-28 15:07	2026-08-28 15:07	2026-08-28 15:07	TSM	TSM261120C00380000	call	380.0000	2026-11-20	53.8500	52.9500	54.6500	418.5800	1243935.00	177705.00	1066230.00	231	7	824	9919	0.08307289041234	0.369348867090698	0.369348867090698	false	false	false	true	false
0e5e6112-05d7-44c6-941d-1334a1619e94	2026-08-28 15:21	2026-08-28 15:21	2026-08-28 15:21	TSM	TSM281215C00410000	call	410.0000	2028-12-15	125.3500	125.3500	126.6000	418.7100	363515.00	0.00	50140.00	29	16	590	1186	0.497470489038786	0.427337274628562	0.427337274628562	false	false	false	true	false
1a476b25-bd0e-44f1-8f38-3aba16581983	2026-08-28 15:24	2026-08-28 15:23	2026-08-28 15:23	TSM	TSM270115C00380000	call	380.0000	2027-01-15	62.7500	62.3500	62.8000	418.3950	131765.00	125495.00	6270.00	21	7	26	1980	0.0131313131313131	0.374451684126296	0.374451684126296	false	false	false	true	false
5cfff1ee-a46e-4620-b8e8-9c24934eedb5	2026-08-28 15:27	2026-08-28 15:27	2026-08-28 15:27	TSM	TSM261120C00400000	call	400.0000	2026-11-20	41.0800	41.0000	42.0500	418.8595	291650.00	36990.00	254660.00	71	8	235	4294	0.0547275267815557	0.366164761439047	0.366164761439047	false	false	false	true	false
625f601b-0ca3-4380-b350-cbac8a136915	2026-08-28 15:43	2026-08-28 15:42	2026-08-28 15:42	TSM	TSM281215C00410000	call	410.0000	2028-12-15	125.1500	125.1500	126.2000	418.4400	387965.00	0.00	350420.00	31	18	623	1186	0.525295109612142	0.427155457630506	0.427279800844594	false	false	false	true	false
15e4a847-7c0b-4d1a-af97-2b28d5fa49a9	2026-08-28 15:47	2026-08-28 15:47	2026-08-28 15:47	TSM	TSM260918P00410000	put	410.0000	2026-09-18	8.5400	8.3000	8.6500	417.9950	261230.00	227380.00	33850.00	306	32	446	11759	0.0379283952717068	0.316205634570887	0.31454460099234	false	false	false	true	false
7a823700-9549-4d01-bb80-12acbe58ce76	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	TSM	TSM270416C00420000	call	420.0000	2027-04-16	55.6100	55.6000	58.0000	420.0000	100100.00	11135.00	88965.00	18	8	18	29	0.620689655172414	0.383790670235424	0.385051664925361	false	false	false	true	false
840fe93e-097e-4ec7-abe4-2b33c203d0ca	2026-08-31 10:15	2026-08-31 10:15	2026-08-31 10:15	TSM	TSM260918C00437500	call	437.5000	2026-09-18	5.6200	5.5000	6.0000	421.0450	169110.00	38530.00	130580.00	301	60	301	69	4.36231884057971	0.310792573931261	0.310792573931261	false	false	false	true	false
fa08f7e4-be1b-46f8-9fd4-9c09a2e02dc9	2026-08-31 13:07	2026-08-31 13:07	2026-08-31 13:07	TSM	TSM280121C00530000	call	530.0000	2028-01-21	52.1500	52.1500	52.2000	417.4850	104301.00	0.00	104301.00	20	7	20	1101	0.0181653042688465	0.407768616098479	0.407768616098479	false	false	false	true	false
880caa0f-f065-42c9-9b8b-18c09bd3d6e6	2026-08-31 13:07	2026-08-31 13:07	2026-08-31 13:07	TSM	TSM271217C00490000	call	490.0000	2027-12-17	58.7000	58.7000	58.7500	417.4850	252410.00	0.00	252410.00	43	10	43	391	0.10997442455243	0.401233200395431	0.401233200395431	false	false	false	true	false
85e1a231-3d28-4c5a-aea2-c4ec7aee27ae	2026-08-31 13:07	2026-08-31 13:07	2026-08-31 13:07	TSM	TSM271217C00550000	call	550.0000	2027-12-17	43.4000	43.3000	44.7000	417.4850	416665.00	4340.00	412325.00	96	16	96	539	0.178107606679035	0.404356439934247	0.404356439934247	false	false	false	true	false
6430c61e-f39e-4e4a-b47f-225f88a0c1e3	2026-08-31 13:07	2026-08-31 13:07	2026-08-31 13:07	TSM	TSM271217P00450000	put	450.0000	2027-12-17	83.8500	83.8500	84.8500	417.4850	427635.00	0.00	427635.00	51	7	69	121	0.570247933884298	0.421137204848041	0.421137204848041	true	false	false	true	false
42cebae4-4228-46f7-bcc3-8952dd24ac21	2026-08-31 13:07	2026-08-31 13:07	2026-08-31 13:07	TSM	TSM280121C00550000	call	550.0000	2028-01-21	47.5000	47.5000	47.5500	417.4850	261251.00	0.00	261251.00	55	14	55	3674	0.0149700598802395	0.408845421485036	0.408897396879986	false	false	false	true	false
290c24d0-b36c-4e4f-adfc-0006072827cf	2026-08-31 13:07	2026-08-31 13:07	2026-08-31 13:07	TSM	TSM271217C00500000	call	500.0000	2027-12-17	55.8600	55.8500	56.9500	417.4850	229009.00	0.00	229009.00	41	14	43	1348	0.0318991097922849	0.401972989814531	0.401972989814531	false	false	false	true	false
54f8f55f-189f-4fef-bd00-33859224407e	2026-08-31 13:07	2026-08-31 13:07	2026-08-31 13:07	TSM	TSM280121C00500000	call	500.0000	2028-01-21	60.0000	60.0000	62.2000	417.5450	354000.00	0.00	354000.00	59	7	79	4659	0.0169564284181155	0.405754506983405	0.405754506983405	false	false	false	true	false
930e2f1c-5494-44fe-811d-6f41cf206e2b	2026-08-31 13:41	2026-08-31 13:41	2026-08-31 13:41	TSM	TSM270115C00500000	call	500.0000	2027-01-15	13.8000	13.7000	13.9000	416.7050	106260.00	99360.00	6900.00	77	7	1309	17282	0.0757435482004398	0.370997647061252	0.370997647061252	false	false	false	true	false
02f190ec-da81-41f7-8b4d-4ad035ad3c79	2026-08-31 15:15	2026-08-31 15:15	2026-08-31 15:15	TSM	TSM261016P00420000	put	420.0000	2026-10-16	21.5600	21.5500	22.0500	415.6800	2156087.00	0.00	2156087.00	1000	42	1096	1967	0.557193695983732	0.343330079800139	0.3467882943874	true	false	false	true	false
947ea9fe-035b-4470-9d03-57b14fc52e5b	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	TSM	TSM261016C00440000	call	440.0000	2026-10-16	11.1600	10.5000	12.0000	414.2000	104935.00	2230.00	38965.00	94	81	94	3137	0.0299649346509404	0.352317659723899	0.348597259798672	true	false	false	true	false
fc0c0ace-aaf2-455c-9502-21d064e0f8b0	2026-09-01 10:10	2026-09-01 10:10	2026-09-01 10:10	TSM	TSM261016C00400000	call	400.0000	2026-10-16	29.1000	29.1000	30.3000	415.1000	293916.00	0.00	293916.00	101	26	117	2081	0.0562229697260932	0.341261824855107	0.341261824855107	false	false	false	true	false
ff2f4ed3-123d-437f-ba90-353a10b934fa	2026-09-01 10:37	2026-09-01 10:37	2026-09-01 10:37	TSM	TSM260918P00450000	put	450.0000	2026-09-18	36.6600	36.2500	38.1000	415.0400	487638.00	417808.00	69830.00	133	18	134	1709	0.0784084259801053	0.357407580478017	0.357564654678247	true	false	false	true	false
6c5e722c-1cda-47b9-a6c1-869ec58fb8e7	2026-09-01 10:49	2026-09-01 10:49	2026-09-01 10:49	TSM	TSM260918C00430000	call	430.0000	2026-09-18	5.8000	5.5500	5.8000	416.4950	118320.00	118320.00	0.00	204	16	646	16815	0.0384180790960452	0.302659094959323	0.302659094959323	false	false	false	true	false
279e3696-d648-4dfd-b483-6e7a1c62b2aa	2026-09-01 12:34	2026-09-01 12:33	2026-09-01 12:33	TSM	TSM261009P00400000	put	400.0000	2026-10-09	10.2500	9.7000	10.5000	413.7500	512500.00	307500.00	205000.00	500	8	509	73	6.97260273972603	0.322286048284245	0.322112720086434	false	false	false	true	false
d8e32729-747c-46f1-aff2-e9a124f4edb4	2026-09-01 13:55	2026-09-01 13:55	2026-09-01 13:55	TSM	TSM261218C00420000	call	420.0000	2026-12-18	30.3000	29.8500	30.9500	413.0200	1030242.00	27310.00	1002932.00	340	58	343	4483	0.0765112647780504	0.349227324890077	0.349227324890077	false	false	false	true	false
f94b8d96-846d-4650-9cb1-56f6ee538369	2026-09-01 14:12	2026-09-01 14:11	2026-09-01 14:11	TSM	TSM261002C00430000	call	430.0000	2026-10-02	8.4500	8.4000	8.9500	413.0700	263727.00	15275.00	241692.00	312	64	321	2707	0.118581455485778	0.304454475900437	0.305565793986646	true	false	false	true	false
d0346ea3-edb0-4931-9cfb-10dce30d82c7	2026-09-01 14:25	2026-09-01 14:25	2026-09-01 14:25	TSM	TSM261218C00460000	call	460.0000	2026-12-18	16.1000	16.0500	16.4500	413.1400	178725.00	1625.00	177100.00	111	30	116	1451	0.0799448656099242	0.348349279025247	0.350457386359282	false	false	false	true	false
84ab0198-7bb3-4343-bf22-2c123f17ceaa	2026-09-01 14:28	2026-09-01 14:28	2026-09-01 14:28	TSM	TSM261218C00490000	call	490.0000	2026-12-18	9.6500	9.4000	9.9500	412.9000	246085.00	975.00	245110.00	255	52	275	1779	0.154581225407532	0.35153258537983	0.352996327872411	false	false	false	true	false
03d75120-f876-4ed7-a0b5-a6282c1ca274	2026-09-01 14:52	2026-09-01 14:51	2026-09-01 14:51	TSM	TSM260918C00440000	call	440.0000	2026-09-18	2.7200	2.6900	2.8700	412.4350	102276.00	37160.00	65116.00	376	14	565	7475	0.0755852842809365	0.312369636402229	0.314053676373018	false	false	false	true	false
f456f0b2-403b-4ec4-bc59-ba3bff223bc6	2026-09-01 15:22	2026-09-01 15:22	2026-09-01 15:22	TSM	TSM261218P00380000	put	380.0000	2026-12-18	15.0500	15.0500	15.5500	414.4900	127925.00	0.00	127925.00	85	27	103	2545	0.0404715127701375	0.358503175957659	0.358503175957659	false	false	false	true	false
4fbeee29-9274-48d2-a032-9ef4ae0a7d00	2026-09-02 10:18	2026-09-02 10:18	2026-09-02 10:18	TSM	TSM270617P00420000	put	420.0000	2027-06-17	52.0000	51.6000	53.8000	414.3000	119595.00	5190.00	114405.00	23	6	23	830	0.027710843373494	0.385911715008235	0.385441998294437	false	false	false	true	false
58d67b24-1631-49e3-ba9a-fef9cbee09a9	2026-09-02 10:46	2026-09-02 10:46	2026-09-02 10:46	TSM	TSM260918P00415000	put	415.0000	2026-09-18	11.0000	10.7000	11.0000	414.1400	107800.00	107800.00	0.00	98	5	100	213	0.469483568075117	0.315671465929587	0.315671465929587	true	false	false	true	false
dc5f6262-112f-4afd-89a1-1bb0379766e8	2026-09-02 10:46	2026-09-02 10:46	2026-09-02 10:46	TSM	TSM260918P00415000	put	415.0000	2026-09-18	10.6700	10.6000	10.7000	414.6100	257190.00	257190.00	0.00	241	5	939	213	4.40845070422535	0.312153627657807	0.313598834947159	false	false	false	true	false
70474b80-eae1-470e-ba89-646a4543d082	2026-09-02 11:30	2026-09-02 11:30	2026-09-02 11:30	TSM	TSM261016P00390000	put	390.0000	2026-10-16	8.7000	8.7000	8.9500	414.4350	227072.00	0.00	227072.00	261	51	367	4220	0.0869668246445498	0.342402480741283	0.342402480741283	false	false	false	true	false