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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 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	pricenumeric

468f47aa-ff79-4fa0-9427-a7af1231efac	2026-08-27 11:27	2026-08-27 11:26	2026-08-27 11:26	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	425.0200	205350.00	205350.00	0.00	37	7	1233	5151	0.239370995923122	0.449880420468981	0.449880420468981	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Technology	2168010914921.00	2026-10-15	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4e54852d-6a88-45c2-bb5b-f9ea22b69094	2026-08-27 11:27	2026-08-27 11:27	2026-08-27 11:27	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.3500	55.5000	425.0200	149850.00	149850.00	0.00	27	6	1441	5151	0.279751504562221	0.449880420468981	0.449880420468981	false	false	false	true	false
0b2c69ed-145c-44e1-b7d9-d43a5b3da895	2026-08-27 11:27	2026-08-27 11:27	2026-08-27 11:27	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	54.0500	55.5000	424.9900	410700.00	410700.00	0.00	74	14	1515	5151	0.294117647058824	0.451744432741787	0.460582244571201	false	false	false	true	false
49fbb287-d7dc-495e-928e-f4ef783b6f2a	2026-08-27 11:27	2026-08-27 11:27	2026-08-27 11:27	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	54.1000	55.5000	424.9750	821400.00	821400.00	0.00	148	44	1663	5151	0.322849932052029	0.465547386058398	0.465547386058398	true	false	false	true	false
75da240c-e3b9-420b-a8b9-08eaea819b93	2026-08-27 11:27	2026-08-27 11:27	2026-08-27 11:27	TSM	TSM260918C00440000	call	440.0000	2026-09-18	7.5600	7.5000	8.1500	424.8450	175289.00	0.00	175289.00	232	9	657	7276	0.0902968664101154	0.320595462689445	0.318013422110159	false	false	false	true	false
6a178354-2cd4-47d9-841c-3ad2e6ed3803	2026-08-27 11:48	2026-08-27 11:48	2026-08-27 11:48	TSM	TSM261218P00390000	put	390.0000	2026-12-18	17.9000	17.3500	18.2500	423.6700	485109.00	7175.00	477934.00	271	53	325	2076	0.15655105973025	0.37457058336563	0.37457058336563	false	false	false	true	false
7874273b-801f-4266-be23-e24eab3e6c24	2026-08-27 11:54	2026-08-27 11:54	2026-08-27 11:54	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	53.6000	55.5000	424.8000	227550.00	227550.00	0.00	41	6	1753	5151	0.34032226752087	0.511855160069877	0.511855160069877	false	false	false	true	false
f9923fd7-e7e6-417e-bf46-4f1ba7b418d3	2026-08-27 11:55	2026-08-27 11:55	2026-08-27 11:55	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	53.7500	55.5000	424.9300	327450.00	327450.00	0.00	59	13	1826	5151	0.354494272956707	0.479230588377544	0.479230588377544	false	false	false	true	false
7f6471b1-95b9-48db-8898-1491a9e0a648	2026-08-27 11:57	2026-08-27 11:57	2026-08-27 11:57	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	54.5000	55.5000	424.9600	238650.00	238650.00	0.00	43	13	1927	5151	0.374102116093962	0.470295428421326	0.470295428421326	false	false	false	true	false
fa9b247f-1c6a-4602-9288-a58cff4f24c4	2026-08-27 11:57	2026-08-27 11:57	2026-08-27 11:57	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	54.9500	55.5000	424.9900	172050.00	172050.00	0.00	31	8	1959	5151	0.380314502038439	0.460582244571201	0.460582244571201	false	false	false	true	false
d23eeadf-0f1b-4406-aef1-f57a318f8d19	2026-08-27 11:58	2026-08-27 11:58	2026-08-27 11:58	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	54.9500	55.5000	425.0000	266400.00	266400.00	0.00	48	7	2015	5151	0.391186177441274	0.457137731744488	0.457137731744488	false	false	false	true	false
32b8aa11-42c0-4a0e-8bb6-dc82110b81ce	2026-08-27 11:58	2026-08-27 11:58	2026-08-27 11:58	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	425.0000	222000.00	222000.00	0.00	40	5	2085	5151	0.404775771694817	0.457137731744488	0.457137731744488	false	false	false	true	false
1fb38971-b00f-4431-ae07-e6333930b8ea	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	54.0500	55.5000	424.9300	249750.00	249750.00	0.00	45	9	2214	5151	0.429819452533489	0.479230588377544	0.479230588377544	false	false	false	true	false
a30030c2-9e58-4257-b8cd-bff9c4223949	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	54.5000	55.5000	425.0100	172050.00	172050.00	0.00	31	5	2266	5151	0.439914579693263	0.453574276505737	0.453574276505737	false	false	false	true	false
14e34b55-2736-41eb-a56b-6e14808076ba	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	54.5000	55.5000	425.0001	238650.00	238650.00	0.00	43	6	2309	5151	0.448262473306154	0.457102703693288	0.457102703693288	false	false	false	true	false
d4e3557f-9947-4616-b90d-ae6cbc53969b	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	425.1000	754800.00	754800.00	0.00	136	22	2529	5151	0.490972626674432	0.413354709262965	0.413354709262965	false	false	false	true	false
afe0153c-daeb-42cb-af48-c9236d2cddc3	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	425.1300	471750.00	471750.00	0.00	85	12	2614	5151	0.507474276839449	0.390002647177577	0.393854075334742	false	false	false	true	false
693fc1ee-4317-43c3-b05a-71e9d7213706	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	425.0500	499500.00	499500.00	0.00	90	12	2838	5151	0.550960978450786	0.437871230115017	0.437871230115017	false	false	false	true	false
5e3a89af-384a-4ae6-9e64-90748b3e39c4	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	425.0500	410700.00	410700.00	0.00	74	10	2748	5151	0.533488642981945	0.437871230115017	0.437871230115017	false	false	false	true	false
29292df9-5caa-4842-8e33-c1462df88177	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	425.0250	183150.00	183150.00	0.00	33	7	2393	5151	0.464569986410406	0.447980514575196	0.447980514575196	false	false	false	true	false
ee3ef60e-ba79-4f80-abe0-2aff782a8023	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.3500	55.5000	425.1100	222000.00	222000.00	0.00	40	8	2998	5151	0.58202290817317	0.407414793766918	0.407414793766918	false	false	false	true	false
b158b64d-faf8-4cb3-9ef8-e8a509ef4bc8	2026-08-27 12:02	2026-08-27 12:02	2026-08-27 12:02	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.2000	55.5000	425.0700	333000.00	333000.00	0.00	60	8	2958	5151	0.574257425742574	0.429131047195608	0.428895107375827	false	false	false	true	false
55c4a4c1-fa05-49d6-bdab-7135d2e24e20	2026-08-27 12:03	2026-08-27 12:03	2026-08-27 12:03	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	425.0100	1814850.00	1814850.00	0.00	327	14	3682	5151	0.714812657736362	0.453574276505737	0.453574276505737	false	false	false	true	false
1917b01d-4189-4d79-b3b0-68552fc3a64e	2026-08-27 12:03	2026-08-27 12:03	2026-08-27 12:03	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	424.9900	1814850.00	1814850.00	0.00	327	14	3325	5151	0.645505727043293	0.460582244571201	0.460582244571201	false	false	false	true	false
fd41ff49-0258-4794-91d9-5d4d09a7091e	2026-08-27 12:03	2026-08-27 12:03	2026-08-27 12:03	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4000	55.5500	424.9500	2164500.00	1809300.00	160950.00	390	22	4459	5151	0.865657153950689	0.473351974768666	0.473351974768666	true	false	false	true	false
de663c98-2ede-425d-aa04-dfbb07d28f5e	2026-08-27 12:03	2026-08-27 12:03	2026-08-27 12:03	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.5000	425.0550	1814850.00	1814850.00	0.00	327	14	4039	5151	0.784119588429431	0.435710444012427	0.435710444012427	false	false	false	true	false
927b28ce-5302-4ab7-90bd-fb077021d687	2026-08-27 12:03	2026-08-27 12:03	2026-08-27 12:03	TSM	TSM260904C00370000	call	370.0000	2026-09-04	55.5000	55.4500	55.7500	425.0600	3013650.00	2225550.00	788100.00	543	35	5002	5151	0.97107357794603	0.433496565735587	0.433496565735587	true	false	false	true	false
0564ec4f-cb00-40aa-a1a5-9927d90959d0	2026-08-27 12:05	2026-08-27 12:05	2026-08-27 12:05	TSM	TSM260925P00400000	put	400.0000	2026-09-25	5.4500	5.3500	5.7000	425.6500	148816.00	3300.00	145516.00	273	53	628	343	1.83090379008746	0.329547181713214	0.329547181713214	false	false	false	true	false
2833aeb2-9f20-4795-bb7d-69d5d1385281	2026-08-27 12:31	2026-08-27 12:31	2026-08-27 12:31	TSM	TSM261120C00410000	call	410.0000	2026-11-20	41.6000	40.8000	41.6000	427.9050	166400.00	166400.00	0.00	40	6	95	1120	0.0848214285714286	0.369931867465713	0.369931867465713	false	false	false	true	false
eb7af9a2-99d4-4f32-8e25-c21dc4a97f5e	2026-08-27 15:09	2026-08-27 15:09	2026-08-27 15:09	TSM	TSM261120C00380000	call	380.0000	2026-11-20	59.0500	58.0000	59.8000	424.4400	2279330.00	324775.00	1954555.00	386	8	10094	428	23.5841121495327	0.379758500415272	0.379758500415272	false	false	false	true	false
37500af6-02d6-4501-9150-da2d1e873778	2026-08-27 15:11	2026-08-27 15:11	2026-08-27 15:11	TSM	TSM260918C00430000	call	430.0000	2026-09-18	11.1000	11.1000	11.6000	424.5300	512867.00	0.00	512867.00	462	40	1680	16243	0.103429169488395	0.316459451231388	0.316459451231388	false	false	false	true	false
516ba40e-4111-4458-9ef1-b1fb71de1ef3	2026-08-27 15:34	2026-08-27 15:34	2026-08-27 15:34	TSM	TSM261120P00370000	put	370.0000	2026-11-20	8.4500	8.3000	8.6500	426.0000	419965.00	0.00	419965.00	497	7	729	3911	0.186397340833546	0.379946362034422	0.379946362034422	false	false	false	true	false
a3950692-479e-4857-8744-828509748a0b	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	TSM	TSM281215C00410000	call	410.0000	2028-12-15	131.5000	131.5000	134.0000	426.5600	302450.00	0.00	276150.00	23	10	23	1186	0.0193929173693086	0.430317946642799	0.430317946642799	false	false	false	true	false
da27ff67-4060-4f9a-9a7d-6b1b52f46785	2026-08-28 09:34	2026-08-28 09:34	2026-08-28 09:34	TSM	TSM270219C00500000	call	500.0000	2027-02-19	23.2500	23.2500	23.5500	427.0500	102300.00	0.00	20925.00	44	11	280	164	1.70731707317073	0.384921243718378	0.384921243718378	true	false	false	true	false
7ad82d73-8464-4715-9ea9-13f5546a8450	2026-08-28 09:34	2026-08-28 09:34	2026-08-28 09:34	TSM	TSM270219C00500000	call	500.0000	2027-02-19	23.2000	23.2000	23.5000	427.2000	116000.00	0.00	69600.00	50	5	330	164	2.01219512195122	0.383985912402891	0.383985912402891	false	false	false	true	false
1fe755fe-a91d-4761-9248-272888e574ef	2026-08-28 09:34	2026-08-28 09:34	2026-08-28 09:34	TSM	TSM270219C00500000	call	500.0000	2027-02-19	23.2800	22.9000	24.2000	426.9100	475005.00	16310.00	95395.00	204	25	236	164	1.4390243902439	0.385825018578754	0.385367949231781	false	false	false	true	false
e10686ab-c96e-4360-8d7e-4852b8420631	2026-08-28 09:34	2026-08-28 09:34	2026-08-28 09:34	TSM	TSM270219C00500000	call	500.0000	2027-02-19	23.2000	23.2000	23.4000	427.4600	327120.00	0.00	327120.00	141	13	471	164	2.8719512195122	0.383156771307833	0.383156771307833	false	false	false	true	false
50cc31a3-d9e1-4a60-ac2e-b38af51596ce	2026-08-28 09:34	2026-08-28 09:34	2026-08-28 09:34	TSM	TSM270219C00500000	call	500.0000	2027-02-19	23.5200	23.1500	24.1500	427.8065	896275.00	25905.00	274915.00	381	46	852	164	5.19512195121951	0.385238969454467	0.384329019870325	false	false	false	true	false
311a0c19-5062-4802-a670-306fa1cd8af2	2026-08-28 09:35	2026-08-28 09:35	2026-08-28 09:35	TSM	TSM260904C00435000	call	435.0000	2026-09-04	4.4000	4.3000	4.9000	427.1900	170725.00	440.00	170285.00	388	13	401	1968	0.203760162601626	0.317700908001771	0.317700908001771	true	false	false	true	false
e0919d9b-2a2a-4432-aadc-07d71f9c83d5	2026-08-28 09:40	2026-08-28 09:40	2026-08-28 09:40	TSM	TSM261120C00390000	call	390.0000	2026-11-20	54.2000	54.2000	54.8000	427.6300	395665.00	0.00	395665.00	73	9	73	1041	0.0701248799231508	0.375588363560051	0.375476305382072	true	false	false	true	false
cb92969f-d949-489b-a27f-14246f6385d0	2026-08-28 09:40	2026-08-28 09:40	2026-08-28 09:40	TSM	TSM261120C00380000	call	380.0000	2026-11-20	61.3500	61.3500	62.4500	427.6200	2202470.00	0.00	2202470.00	359	13	360	9919	0.0362939812481097	0.378154498814539	0.378154498814539	true	false	false	true	false
112d3cea-7938-4ce7-8a45-9adca7e3cbbc	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	TSM	TSM281215C00410000	call	410.0000	2028-12-15	132.6000	132.6000	134.3000	427.6500	411060.00	0.00	13260.00	31	18	63	1186	0.0531197301854975	0.431802386362926	0.431802386362926	false	false	false	true	false
bb92c9f5-0156-4899-85a1-975229ebd7c4	2026-08-28 10:07	2026-08-28 10:07	2026-08-28 10:07	TSM	TSM270115C00400000	call	400.0000	2027-01-15	55.9600	55.9500	58.9500	426.5800	167885.00	0.00	128685.00	30	5	32	3987	0.00802608477552044	0.370195249161505	0.370195249161505	false	false	false	true	false
c1519a3e-c90a-4ee5-8ec3-212be5aa0912	2026-08-28 10:10	2026-08-28 10:09	2026-08-28 10:09	TSM	TSM281215C00410000	call	410.0000	2028-12-15	131.6500	131.6500	133.5000	426.3868	408115.00	0.00	223805.00	31	18	94	1186	0.0792580101180438	0.431533355513108	0.431533355513108	true	false	false	true	false
85106e96-c2da-4e68-9421-c34cdd19e89f	2026-08-28 10:31	2026-08-28 10:31	2026-08-28 10:31	TSM	TSM281215C00410000	call	410.0000	2028-12-15	131.0000	131.0000	132.3500	425.5000	301300.00	0.00	301300.00	23	18	125	1186	0.10539629005059	0.431414743633494	0.431414743633494	false	false	false	true	false
b7111a94-9eb4-45fa-9b6a-ffafa41a4b6b	2026-08-28 10:49	2026-08-28 10:49	2026-08-28 10:49	TSM	TSM281215C00410000	call	410.0000	2028-12-15	131.1500	129.7500	132.5000	426.0700	327875.00	13115.00	314760.00	25	18	156	1186	0.131534569983137	0.430294127578418	0.430294127578418	false	false	false	true	false
356d960e-a74c-4aab-8d6e-913c91304dca	2026-08-28 11:06	2026-08-28 11:06	2026-08-28 11:06	TSM	TSM261120C00380000	call	380.0000	2026-11-20	59.7500	59.7500	60.3000	425.8400	352525.00	0.00	352525.00	59	6	425	9919	0.0428470611956851	0.374719069906179	0.374719069906179	false	false	false	true	false
51eb790a-6178-45ad-b986-a420df992a79	2026-08-28 11:08	2026-08-28 11:08	2026-08-28 11:08	TSM	TSM281215C00410000	call	410.0000	2028-12-15	131.3000	129.6000	133.0000	425.1900	407030.00	13130.00	65650.00	31	18	187	1186	0.157672849915683	0.433731055392926	0.433731055392926	false	false	false	true	false
c99b1ab8-43a0-40ea-aa49-36b7bebb4a46	2026-08-28 11:13	2026-08-28 11:13	2026-08-28 11:13	TSM	TSM281215P00430000	put	430.0000	2028-12-15	92.4700	91.8500	93.9000	424.9850	462365.00	166730.00	295635.00	50	7	99	153	0.647058823529412	0.449702193365073	0.449702193365073	true	false	false	true	false
8070b769-40db-41fa-8b5c-0bfbe4a25bd7	2026-08-28 11:18	2026-08-28 11:18	2026-08-28 11:18	TSM	TSM281215C00600000	call	600.0000	2028-12-15	72.4500	72.4500	74.5500	425.1300	108675.00	0.00	108675.00	15	7	15	1063	0.0141110065851364	0.42909969436683	0.42909969436683	false	false	false	true	false