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:endpoint = /api/option-trades/flow-alerts×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	expiry

93ca367e-ea30-4da1-bc8c-da931d237e92	2026-09-23 12:31	2026-09-23 12:31	2026-09-23 12:31	TSM	TSM261023P00445000	put	445.0000	2026-10-23	15.3600	15.3000	15.5500	446.1600	27640.00	1535.00	26105.00	18	12	23	220	0.104545454545455	0.327038858393824	0.326818652061329	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ADR	Technology	2316137494979.00	2026-10-15	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
5dfac1a6-a189-46e4-ae36-a39a6ad979b4	2026-09-23 12:29	2026-09-23 12:29	2026-09-23 12:29	TSM	TSM270115C00550000	call	550.0000	2027-01-15	8.5500	8.5500	8.8000	446.0250	193232.00	0.00	193232.00	226	53	251	16371	0.0153319894936168	0.359060414402367	0.359060414402367	false	false	false	true
fb8fcf58-dc35-4aeb-a318-f5137fbfb3b0	2026-09-23 12:26	2026-09-23 12:26	2026-09-23 12:26	TSM	TSM261016C00440000	call	440.0000	2026-10-16	18.9000	18.9000	19.0000	446.2100	22680.00	0.00	22680.00	12	7	445	7372	0.060363537710255	0.33770412610285	0.33770412610285	true	false	false	true
538e2cbf-ef57-46f9-8087-01104b830e52	2026-09-23 12:23	2026-09-23 12:23	2026-09-23 12:23	TSM	TSM261016P00405000	put	405.0000	2026-10-16	2.4700	2.4400	2.4700	446.1122	15067.00	7410.00	0.00	61	47	103	254	0.405511811023622	0.352441731195704	0.352441731195704	true	false	false	true
7dea2b7a-42bd-4095-9152-99965c4ceb9e	2026-09-23 12:23	2026-09-23 12:23	2026-09-23 12:23	TSM	TSM290119C00540000	call	540.0000	2029-01-19	93.3800	93.1000	95.8500	446.1158	93380.00	9360.00	84020.00	10	7	10	3	3.33333333333333	0.39949718531673	0.400431862614753	false	false	false	true
1dfde168-6fa4-49ed-847a-a3e15ad8faa1	2026-09-23 12:07	2026-09-23 12:07	2026-09-23 12:07	TSM	TSM270115C00620000	call	620.0000	2027-01-15	2.9700	2.9700	3.1500	447.1050	42174.00	0.00	42174.00	142	45	152	996	0.152610441767068	0.368109543647545	0.368109543647545	false	false	false	true
867cfe9a-51bc-4cbc-8d5d-eb2702cdfbea	2026-09-23 12:01	2026-09-23 12:01	2026-09-23 12:01	TSM	TSM270617P00320000	put	320.0000	2027-06-17	8.3000	7.9500	8.3500	447.2600	16604.00	16604.00	0.00	20	13	20	3439	0.00581564408258215	0.388719648268399	0.388131424095688	true	false	false	true
9238e01b-640b-4658-b53d-92326eb00bdb	2026-09-23 11:57	2026-09-23 11:57	2026-09-23 11:57	TSM	TSM261120P00440000	put	440.0000	2026-11-20	19.0500	18.7000	19.0500	447.6000	74277.00	74277.00	0.00	39	5	123	600	0.205	0.34003852727165	0.34003852727165	false	false	false	true
4cf03766-5d10-47bb-953a-8428d3ae4b6b	2026-09-23 11:55	2026-09-23 11:55	2026-09-23 11:55	TSM	TSM270115C00600000	call	600.0000	2027-01-15	4.2000	3.9500	4.2000	447.7850	12180.00	12180.00	0.00	29	13	70	3656	0.0191466083150985	0.36712476505982	0.36712476505982	false	false	false	true
76cc5cbd-73da-49fc-b0f1-06fc8db5fc80	2026-09-23 11:54	2026-09-23 11:54	2026-09-23 11:54	TSM	TSM261120P00400000	put	400.0000	2026-11-20	6.2000	6.2000	6.3500	447.3600	10540.00	0.00	10540.00	17	5	230	4815	0.0477673935617861	0.344047567390393	0.344047567390393	false	false	false	true
68d0b3f2-a731-44cf-a4b8-580cdb5c172c	2026-09-23 11:54	2026-09-23 11:54	2026-09-23 11:54	TSM	TSM261120C00510000	call	510.0000	2026-11-20	6.6000	6.3500	6.6000	447.0000	25080.00	25080.00	0.00	38	13	57	1184	0.0481418918918919	0.347293479635845	0.347293479635845	false	false	false	true
b2bc5ab7-2d57-4399-afd5-792195d01f5f	2026-09-23 11:54	2026-09-23 11:54	2026-09-23 11:54	TSM	TSM261218P00450000	put	450.0000	2026-12-18	29.0500	29.0500	29.3000	447.0000	46480.00	0.00	46480.00	16	6	77	876	0.0878995433789954	0.344694544768496	0.344694544768496	false	false	false	true
3b76648f-e6c2-47a3-9036-d7c06e5bbf51	2026-09-23 11:53	2026-09-23 11:53	2026-09-23 11:53	TSM	TSM261218P00440000	put	440.0000	2026-12-18	24.0000	23.4500	24.0500	446.0000	12000.00	4800.00	7200.00	5	5	496	1281	0.3871975019516	0.343045799198438	0.343045799198438	false	false	false	true
8e5a188c-cdfb-4f98-93e7-b4c14697cfc0	2026-09-23 11:52	2026-09-23 11:52	2026-09-23 11:52	TSM	TSM270115P00410000	put	410.0000	2027-01-15	16.1400	15.8000	16.1500	447.0000	69395.00	61370.00	8025.00	43	9	80	1306	0.0612557427258806	0.351653507124352	0.350299849594695	false	false	false	true
75f28ee5-b0db-4c58-a510-7a315da32cc8	2026-09-23 11:52	2026-09-23 11:52	2026-09-23 11:52	TSM	TSM261218C00450000	call	450.0000	2026-12-18	30.4500	30.3000	30.5000	447.0000	15225.00	15225.00	0.00	5	5	98	5911	0.016579259008628	0.341167781642684	0.341167781642684	false	false	false	true
9d1feec9-b250-4050-b08c-1dee51e96c31	2026-09-23 11:49	2026-09-23 11:48	2026-09-23 11:48	TSM	TSM261218P00430000	put	430.0000	2026-12-18	19.3900	18.9000	19.4500	447.0000	32961.00	13561.00	19400.00	17	5	31	2327	0.0133218736570692	0.341599874514151	0.34296481294531	false	false	false	true
67e22f3b-3bff-4565-8aea-2daca3b70efc	2026-09-23 11:42	2026-09-23 11:42	2026-09-23 11:42	TSM	TSM260925C00452500	call	452.5000	2026-09-25	2.6000	2.5900	2.6300	448.0000	16640.00	0.00	16640.00	64	7	1028	1024	1.00390625	0.320149739135212	0.320149739135212	false	false	false	true
c5a7ae97-59d2-4389-93d3-8759565e8ad0	2026-09-23 11:42	2026-09-23 11:42	2026-09-23 11:42	TSM	TSM260925C00452500	call	452.5000	2026-09-25	2.5700	2.5500	2.6100	448.0000	31297.00	0.00	31297.00	122	5	768	1024	0.75	0.321076365965089	0.320270354218343	false	false	false	true
2eaef4e3-6fb1-40ac-9366-0346aa9aabbf	2026-09-23 11:42	2026-09-23 11:42	2026-09-23 11:42	TSM	TSM260925C00452500	call	452.5000	2026-09-25	2.5700	2.5600	2.6100	448.0000	13600.00	2080.00	11520.00	53	8	821	1024	0.8017578125	0.32349272894435	0.320270354218343	false	false	false	true
b1525e90-3cb1-48a2-b394-f7028f5e4ff3	2026-09-23 11:41	2026-09-23 11:41	2026-09-23 11:41	TSM	TSM260925P00452500	put	452.5000	2026-09-25	6.4000	6.0500	6.4000	448.5600	19200.00	19200.00	0.00	30	13	64	105	0.60952380952381	0.315937130994664	0.315937130994664	false	false	false	true
ba9cdbd8-f29a-40dd-b8a4-a2a6bf268d1d	2026-09-23 11:36	2026-09-23 11:36	2026-09-23 11:36	TSM	TSM270115P00390000	put	390.0000	2027-01-15	10.2500	10.0000	10.3000	448.8750	19475.00	16400.00	3075.00	19	9	71	2399	0.0295956648603585	0.354068255445466	0.354068255445466	false	false	false	true
36d16b26-c86f-4ec2-a968-27d9349e1d82	2026-09-23 11:35	2026-09-23 11:35	2026-09-23 11:35	TSM	TSM261016P00430000	put	430.0000	2026-10-16	6.8500	6.8500	7.2500	449.1100	14385.00	0.00	14385.00	21	5	429	4598	0.0933014354066986	0.336896802924034	0.336896802924034	false	false	false	true
b31f20e4-14a6-4775-a9a3-24384c4d6605	2026-09-23 11:32	2026-09-23 11:32	2026-09-23 11:32	TSM	TSM260925C00447500	call	447.5000	2026-09-25	5.8000	5.8000	6.0000	450.2300	20300.00	0.00	20300.00	35	9	182	507	0.358974358974359	0.3196912914451	0.3196912914451	false	false	false	true
a169a0c9-91d0-45fd-9907-8a7dc269d3b2	2026-09-23 11:29	2026-09-23 11:28	2026-09-23 11:28	TSM	TSM270115C00540000	call	540.0000	2027-01-15	11.0000	11.0000	11.1500	450.0000	44000.00	0.00	44000.00	40	13	75	14771	0.00507751675580529	0.358643649191177	0.358643649191177	false	false	false	true
d6693dba-7da4-4550-9475-3bda0d90d56e	2026-09-23 11:27	2026-09-23 11:27	2026-09-23 11:27	TSM	TSM261016C00450000	call	450.0000	2026-10-16	15.6000	15.4500	15.8000	449.8950	15600.00	6240.00	9360.00	10	5	706	9214	0.0766225309311917	0.335291842762561	0.335291842762561	false	false	false	true
7d535dfe-a7f6-46f6-9f76-b1b2c65ef503	2026-09-23 11:26	2026-09-23 11:26	2026-09-23 11:26	TSM	TSM261016P00447500	put	447.5000	2026-10-16	13.0600	12.6500	13.1000	450.2400	11750.00	11750.00	0.00	9	5	57	131	0.435114503816794	0.331968196600168	0.333088803961475	false	false	false	true
c03f1560-63a1-4813-b56a-f51026454655	2026-09-23 11:20	2026-09-23 11:19	2026-09-23 11:19	TSM	TSM261120P00380000	put	380.0000	2026-11-20	2.9700	2.9700	3.1000	450.0600	30889.00	0.00	30889.00	104	36	179	4522	0.0395842547545334	0.354085496659799	0.354085496659799	false	false	false	true
802e210b-e107-4a1d-bfa6-a13454e032d0	2026-09-23 11:12	2026-09-23 11:11	2026-09-23 11:11	TSM	TSM270617C00500000	call	500.0000	2027-06-17	43.8000	42.8000	44.1500	449.3250	87600.00	4380.00	4380.00	20	19	293	2547	0.115037298782882	0.37582326636785	0.37582326636785	false	false	false	true
3b3efa96-01a7-4d28-8028-06911c2619d7	2026-09-23 11:08	2026-09-23 11:08	2026-09-23 11:08	TSM	TSM261218C00450000	call	450.0000	2026-12-18	31.4800	30.9000	31.6000	449.4000	44065.00	25220.00	18845.00	14	6	73	5911	0.0123498562003045	0.342224601140101	0.341000360137052	false	false	false	true
1c898c19-4ddc-44d8-b35e-2e7b17377823	2026-09-23 11:07	2026-09-23 11:07	2026-09-23 11:07	TSM	TSM270115C00500000	call	500.0000	2027-01-15	19.3500	19.3000	19.6000	449.3200	13545.00	0.00	13545.00	7	7	727	17914	0.0405827844144245	0.355956947878863	0.355956947878863	false	false	false	true
eabd68f0-cc50-4997-a4d8-034116bb8be2	2026-09-23 11:07	2026-09-23 11:07	2026-09-23 11:07	TSM	TSM270115C00510000	call	510.0000	2027-01-15	16.7000	16.7000	17.0500	449.2600	63460.00	0.00	63460.00	38	10	87	5835	0.0149100257069409	0.356087267180097	0.356087267180097	false	false	false	true
7f2aa3c9-4eeb-4d90-98dd-83e02ab8641c	2026-09-23 11:07	2026-09-23 11:07	2026-09-23 11:07	TSM	TSM261002C00450000	call	450.0000	2026-10-02	8.2000	8.0000	8.2000	449.0000	13120.00	13120.00	0.00	16	6	335	945	0.354497354497354	0.301214908310233	0.301214908310233	false	false	false	true
4f7ea6f7-6b0c-408f-b400-a4c5b295c95b	2026-09-23 11:07	2026-09-23 11:07	2026-09-23 11:07	TSM	TSM270319C00680000	call	680.0000	2027-03-19	4.2500	3.8500	4.4000	449.1900	19550.00	19120.00	430.00	46	12	48	1377	0.0348583877995643	0.378658753480855	0.379529708796255	false	false	false	true
725daed5-1dcf-4d96-9a6a-806e14b28c4b	2026-09-23 11:04	2026-09-23 11:04	2026-09-23 11:04	TSM	TSM261120C00450000	call	450.0000	2026-11-20	25.0000	24.4000	25.7500	448.1900	82510.00	2505.00	80005.00	33	9	151	3560	0.0424157303370786	0.343183856990104	0.344339742629437	true	false	false	true
47da9de1-279b-43af-9864-d620e0e60c72	2026-09-23 11:04	2026-09-23 11:04	2026-09-23 11:04	TSM	TSM261002C00452500	call	452.5000	2026-10-02	6.6500	6.6000	6.7000	448.3500	15295.00	7315.00	7980.00	23	7	141	301	0.46843853820598	0.296925390860868	0.296925390860868	false	false	false	true
e7620ba1-b83a-4041-90cf-2449ccf7a06d	2026-09-23 11:04	2026-09-23 11:04	2026-09-23 11:04	TSM	TSM261002C00452500	call	452.5000	2026-10-02	6.6500	6.6000	6.7000	448.3500	13965.00	5320.00	8645.00	21	5	118	301	0.39202657807309	0.296925390860868	0.296925390860868	false	false	false	true
7f98d18a-5f59-4653-b028-3c6fb2d521ae	2026-09-23 11:04	2026-09-23 11:04	2026-09-23 11:04	TSM	TSM261002C00452500	call	452.5000	2026-10-02	6.6500	6.5500	7.0000	448.3500	10640.00	1330.00	9310.00	16	10	47	301	0.156146179401993	0.296925390860868	0.296925390860868	false	false	false	true
647ca1b4-9733-46dc-ac96-bdff6ba91fa3	2026-09-23 11:03	2026-09-23 11:03	2026-09-23 11:03	TSM	TSM261016C00500000	call	500.0000	2026-10-16	2.1700	2.1600	2.2500	448.5050	49491.00	0.00	49491.00	228	43	307	7481	0.0410372944793477	0.344724071787531	0.344274959027574	true	false	false	true
d4eccbf4-60f8-41ce-9dd8-96cb9ee95cd2	2026-09-23 11:02	2026-09-23 11:01	2026-09-23 11:01	TSM	TSM261023C00465000	call	465.0000	2026-10-23	10.8000	10.7000	10.8500	448.3933	15120.00	11880.00	0.00	14	7	48	202	0.237623762376238	0.332085942040705	0.332085942040705	false	false	false	true
986e9c3e-e8af-43d1-9df6-59e8aa070dab	2026-09-23 11:02	2026-09-23 11:01	2026-09-23 11:01	TSM	TSM261120C00460000	call	460.0000	2026-11-20	20.6500	20.3500	20.7000	448.4300	14455.00	8260.00	6195.00	7	6	90	3343	0.0269219264134011	0.343457768702354	0.343457768702354	true	false	false	true
9014d368-473d-4d5e-bbb7-51d500552d79	2026-09-23 11:02	2026-09-23 11:01	2026-09-23 11:01	TSM	TSM270115C00500000	call	500.0000	2027-01-15	19.0000	18.6500	19.0500	448.3933	233699.00	142499.00	91200.00	123	28	304	17914	0.0169699676230881	0.355715173138841	0.355715173138841	false	false	false
713c08cb-027d-4ac0-87e6-67cdcf705800	2026-09-23 11:02	2026-09-23 11:01	2026-09-23 11:01	TSM	TSM261023C00475000	call	475.0000	2026-10-23	7.7500	7.4500	7.8500	448.3929	19370.00	17825.00	1545.00	25	15	32	308	0.103896103896104	0.332151246658795	0.332153933048663	true	false	false	true
0da1f1d9-0edc-462a-a7aa-64b25ef6efc8	2026-09-23 11:02	2026-09-23 11:01	2026-09-23 11:01	TSM	TSM261120C00530000	call	530.0000	2026-11-20	4.2000	4.0000	4.2000	448.4300	19738.00	19738.00	0.00	47	15	59	784	0.0752551020408163	0.350179652666282	0.350179652666282	false	false	false	true
7d6ec01d-e056-49c4-87cb-2cabc5ae2c46	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	TSM	TSM261218C00460000	call	460.0000	2026-12-18	26.1000	25.7500	26.2500	447.9750	52195.00	52195.00	0.00	20	8	104	1739	0.0598044853364002	0.339521448281092	0.340097921693077	false	false	false	true
0d0d0e03-cae2-4809-8446-56c11acca633	2026-09-23 10:55	2026-09-23 10:55	2026-09-23 10:55	TSM	TSM261023P00450000	put	450.0000	2026-10-23	17.2000	16.8000	17.8000	447.3700	18920.00	13760.00	5160.00	11	5	20	575	0.0347826086956522	0.325788605088433	0.324346744258618	false	false	false	true
bc1ebb7c-d35c-450f-a354-9ec76fc98918	2026-09-23 10:55	2026-09-23 10:54	2026-09-23 10:54	TSM	TSM270115P00360000	put	360.0000	2027-01-15	5.0300	4.9000	5.0500	447.0000	139290.00	85290.00	54000.00	277	27	334	7346	0.0454669207732099	0.361520731477906	0.362174406763204	false	false	false	true
fa8a4780-041a-423b-9e62-a954a36b9e4c	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	TSM	TSM260925C00450000	call	450.0000	2026-09-25	3.0000	2.9500	3.1000	447.0300	24000.00	23400.00	600.00	80	5	377	2441	0.154444899631299	0.323463592448919	0.323463592448919	true	false	false	true
96996b08-4e33-4deb-84e0-5c79189a8751	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	TSM	TSM261002C00420000	call	420.0000	2026-10-02	29.1000	27.2000	29.1000	447.2800	826440.00	826440.00	0.00	284	22	398	644	0.618012422360248	0.347715231105468	0.347715231105468	true	false	false	true
22ef844d-9b0d-4cb0-824b-677bcd348bb2	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	TSM	TSM261218C00400000	call	400.0000	2026-12-18	60.9300	58.4500	60.9500	447.2800	542245.00	505885.00	36360.00	89	5	102	1554	0.0656370656370656	0.347350515047702	0.34173956481484	true	false	false
0bc3c9d4-081c-4486-8a1e-09ae0a8e89f6	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	TSM	TSM261120C00400000	call	400.0000	2026-11-20	56.6000	54.3000	56.6000	447.2800	503730.00	492420.00	11310.00	89	8	110	4347	0.0253048079135036	0.355076628491359	0.354015907473887	true	false	false