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

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

f32c0711-d168-4707-86ba-2e4b9c959402	2026-08-21 12:45	2026-08-21 12:44	2026-08-21 12:44	TMC	TMC261120C00007000	call	7.0000	2026-11-20	0.4400	0.4200	0.4400	4.7658	24420.00	24420.00	0.00	555	11	4457	2994	1.48864395457582	1.08274713396679	1.08274713396679	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	1689548896.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
51bd4990-d61f-4a52-902c-6bdc42418c40	2026-08-21 12:25	2026-08-21 12:25	2026-08-21 12:25	TMC	TMC270219C00006000	call	6.0000	2027-02-19	1.0000	0.9200	1.0000	4.6550	129000.00	129000.00	0.00	1290	20	1437	208	6.90865384615385	1.06421707979312	1.06421707979312	false	false	false	true
906e00c6-73ab-45db-b415-585ebf89db55	2026-08-21 12:03	2026-08-21 12:03	2026-08-21 12:03	TMC	TMC270219C00004000	call	4.0000	2027-02-19	1.6000	1.5200	1.6000	4.5800	100800.00	100800.00	0.00	630	20	1216	685	1.77518248175182	1.0646165432393	1.0646165432393	false	false	false	true
fd9e59fd-fb3d-4b75-ba0f-60b88ac4299d	2026-08-21 12:03	2026-08-21 12:03	2026-08-21 12:03	TMC	TMC270219C00004000	call	4.0000	2027-02-19	1.5700	1.4400	1.7300	4.5600	89485.00	88386.00	1099.00	570	56	586	685	0.855474452554745	1.05026530104851	1.05026530104851	false	false	false	true
77a055f1-7c63-4f32-8889-9087cd7ea623	2026-08-21 12:02	2026-08-21 12:02	2026-08-21 12:02	TMC	TMC260918C00005000	call	5.0000	2026-09-18	0.3300	0.3300	0.3600	4.5900	16500.00	0.00	16500.00	500	34	925	1110	0.833333333333333	0.945904568573682	0.954494348005992	false	false	false	true
6067213c-be79-4663-8002-ac2fafeaf87b	2026-08-21 11:57	2026-08-21 11:57	2026-08-21 11:57	TMC	TMC280121C00012000	call	12.0000	2028-01-21	1.2100	1.2100	1.2100	4.5850	12221.00	0.00	0.00	101	6	2379	7071	0.336444633008061	1.09568976226042	1.09568976226042	false	false	false	true
ca5fb240-a37d-49a8-85f3-7960e0014967	2026-08-21 11:55	2026-08-21 11:54	2026-08-21 11:54	TMC	TMC280121C00012000	call	12.0000	2028-01-21	1.2100	0.9900	1.2100	4.6150	26377.00	18634.00	120.00	218	19	2277	7071	0.322019516334323	1.09125296627282	1.08904451494331	true	false	false	true
c1c44955-366c-4b20-a7e3-baf601666628	2026-08-21 11:53	2026-08-21 11:53	2026-08-21 11:53	TMC	TMC280121C00012000	call	12.0000	2028-01-21	1.1900	1.1000	1.1900	4.5850	24276.00	12138.00	0.00	204	15	1763	7071	0.249328242115684	1.08650230529579	1.08650230529579	true	false	false	true
0b53379c-d38d-461c-b515-8d765b90c03d	2026-08-21 11:53	2026-08-21 11:53	2026-08-21 11:53	TMC	TMC280121C00012000	call	12.0000	2028-01-21	1.1900	1.1000	1.2400	4.5950	59500.00	2261.00	0.00	500	13	1559	7071	0.220478008768208	1.08430013939126	1.08430013939126	false	false	false	true
81c89a9f-e107-454a-9c46-62514b0bc205	2026-08-21 11:48	2026-08-21 11:48	2026-08-21 11:48	TMC	TMC280121C00005000	call	5.0000	2028-01-21	2.1000	2.1000	2.1000	4.5650	98700.00	0.00	0.00	470	12	3489	14665	0.237913399249915	1.05025636934538	1.05025636934538	false	false	false	true
0087b151-739d-4475-afbd-b7b64a879fdf	2026-08-21 11:44	2026-08-21 11:44	2026-08-21 11:44	TMC	TMC280121C00005000	call	5.0000	2028-01-21	2.1000	2.1000	2.1800	4.5800	73500.00	0.00	10500.00	350	7	2869	14665	0.19563586771224	1.04426006372417	1.04426006372417	false	false	false	true
adbd0e92-f9e6-4956-9498-f442261123e3	2026-08-21 11:41	2026-08-21 11:41	2026-08-21 11:41	TMC	TMC261120C00006000	call	6.0000	2026-11-20	0.5200	0.4900	0.5200	4.5686	13520.00	2600.00	0.00	260	8	4451	3246	1.37122612446087	1.03893034446201	1.03893034446201	true	false	false	true
2227a28a-d268-490b-8dae-f8581e7aea08	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	TMC	TMC280121C00012000	call	12.0000	2028-01-21	1.1500	1.0600	1.1500	4.4950	57500.00	5750.00	0.00	500	10	550	7071	0.077782491868194	1.08787402379799	1.08787402379799	false	false	false	true
7d12f7aa-8644-4fbb-90d2-f1f422574e1d	2026-08-21 11:11	2026-08-21 11:11	2026-08-21 11:11	TMC	TMC261120C00006000	call	6.0000	2026-11-20	0.4800	0.4300	0.4800	4.4600	192000.00	192000.00	0.00	4000	50	4151	3246	1.27880468268638	1.04213063397111	1.04213063397111	false	false	false	true
7c88ac27-56b8-41da-8bf9-516be96a9f35	2026-08-20 15:52	2026-08-20 15:52	2026-08-20 15:52	TMC	TMC270115C00008000	call	8.0000	2027-01-15	0.3000	0.2400	0.3000	3.9200	10020.00	10020.00	0.00	334	7	1998	3441	0.580645161290323	1.08194668048211	1.08194668048211	true	false	false	true
49da0c93-1092-48f8-936c-f7ade189f41f	2026-08-20 15:43	2026-08-20 15:43	2026-08-20 15:43	TMC	TMC280121C00015000	call	15.0000	2028-01-21	0.7000	0.6500	0.7100	3.9100	124250.00	0.00	0.00	1775	7	3010	5990	0.502504173622704	1.08029554417959	1.07822550163092	false	false	false	true
b604af9b-1efb-4b55-a6b5-96580bcadcee	2026-08-20 15:42	2026-08-20 15:42	2026-08-20 15:42	TMC	TMC270115C00008000	call	8.0000	2027-01-15	0.2800	0.2600	0.3000	3.8814	24752.00	24668.00	56.00	884	38	989	3441	0.287416448706771	1.06861634358105	1.06861634358105	true	false	false	true
cd3c1a34-ff5d-486f-8e4c-79af63622e07	2026-08-20 15:25	2026-08-20 15:25	2026-08-20 15:25	TMC	TMC261120C00007000	call	7.0000	2026-11-20	0.1700	0.1600	0.1700	3.8550	16830.00	16830.00	0.00	990	25	994	2044	0.486301369863014	1.03482097229807	1.03482097229807	true	false	false	true
36430ab4-3259-4fd8-a13f-c33810733e0e	2026-08-20 15:13	2026-08-20 15:13	2026-08-20 15:13	TMC	TMC280121C00020000	call	20.0000	2028-01-21	0.5000	0.5000	0.5200	3.8350	15000.00	0.00	2500.00	300	6	307	6145	0.0499593165174939	1.08294523305726	1.08294523305726	false	false	false	true
28736989-dc2b-4ae8-82f1-04ea2537f875	2026-08-20 11:39	2026-08-20 11:39	2026-08-20 11:39	TMC	TMC280121C00012000	call	12.0000	2028-01-21	0.7900	0.7900	0.8400	3.8300	13825.00	0.00	13825.00	175	7	377	4258	0.0885392202912165	1.05294835323862	1.05294835323862	false	false	false	true
2248dc01-70b1-459e-9764-a709babeeda5	2026-08-20 11:29	2026-08-20 11:29	2026-08-20 11:29	TMC	TMC280121C00012000	call	12.0000	2028-01-21	0.7900	0.7900	0.8100	3.8100	11850.00	0.00	11850.00	150	6	152	4258	0.0356975105683419	1.05756040241599	1.05756040241599	false	false	false	true
ee2dd80b-40d7-4338-975f-b78dc8b1076d	2026-08-20 11:27	2026-08-20 11:27	2026-08-20 11:27	TMC	TMC280121C00007000	call	7.0000	2028-01-21	1.2000	1.1800	1.2700	3.7950	24000.00	21000.00	2880.00	200	9	202	6112	0.0330497382198953	1.03139177837874	1.03139177837874	true	false	false	true
2d1af470-7342-41e7-b5db-b2a6e8592911	2026-08-19 14:20	2026-08-19 14:20	2026-08-19 14:20	TMC	TMC261120C00006000	call	6.0000	2026-11-20	0.2800	0.2700	0.3000	3.8900	33404.00	31108.00	896.00	1193	9	1961	1543	1.27090084251458	1.01947761051956	1.01947761051956	false	false	false	true
a001f9f5-e2e2-4ed2-a5d3-efaad79b3340	2026-08-19 14:02	2026-08-19 14:02	2026-08-19 14:02	TMC	TMC270115C00005000	call	5.0000	2027-01-15	0.6800	0.6300	0.6800	3.8900	34067.00	34067.00	0.00	501	34	510	20300	0.0251231527093596	1.02035380113867	1.02035380113867	false	false	false	true
afdf8370-e2e7-433a-95af-6e2ba701e79f	2026-08-19 12:16	2026-08-19 12:16	2026-08-19 12:16	TMC	TMC260828C00003500	call	3.5000	2026-08-28	0.5200	0.4300	0.5200	3.9350	10400.00	10400.00	0.00	200	15	200	171	1.16959064327485	1.03254580406152	1.03254580406152	false	false	false	true
ad73716d-0c07-4e7f-a9b5-8d34e32dcb8a	2026-08-19 12:09	2026-08-19 12:09	2026-08-19 12:09	TMC	TMC270115C00010000	call	10.0000	2027-01-15	0.1700	0.1500	0.1700	3.9200	10149.00	10149.00	0.00	597	20	606	15996	0.0378844711177794	1.07454614126814	1.07323586618051	false	false	false	true
58ec22e0-677a-4d30-835a-2ed901545e5d	2026-08-19 10:12	2026-08-19 10:11	2026-08-19 10:11	TMC	TMC280121C00012000	call	12.0000	2028-01-21	0.7900	0.7900	0.8100	3.7850	19355.00	0.00	3555.00	245	16	1791	1059	1.69121813031161	1.06229814216077	1.06229814216077	false	false	false	true
58e294b2-84e9-4bd9-b20c-104504cfd301	2026-08-19 10:11	2026-08-19 10:11	2026-08-19 10:11	TMC	TMC280121C00012000	call	12.0000	2028-01-21	0.7900	0.7900	0.8400	3.7850	30731.00	0.00	12482.00	389	15	1322	1059	1.24834749763928	1.06229814216077	1.06229814216077	false	false	false	true
29a2fbc0-f56f-4837-8703-06ffc9e7184b	2026-08-19 10:07	2026-08-19 10:07	2026-08-19 10:07	TMC	TMC280121C00012000	call	12.0000	2028-01-21	0.8000	0.8000	0.8700	3.8350	47600.00	0.00	3040.00	595	16	903	1059	0.852691218130312	1.05636269270281	1.05636269270281	false	false	false	true
97c3b376-3968-44df-9e9f-269495864a09	2026-08-19 10:07	2026-08-19 10:07	2026-08-19 10:07	TMC	TMC280121C00012000	call	12.0000	2028-01-21	0.7900	0.7900	0.8800	3.8101	18960.00	0.00	9480.00	240	6	308	1059	0.290840415486308	1.0564701485924	1.0564701485924	false	false	false	true
677e912d-9bd0-4fe4-93d8-e8c8f49510ab	2026-08-18 13:01	2026-08-18 13:01	2026-08-18 13:01	TMC	TMC280121C00005000	call	5.0000	2028-01-21	1.6900	1.6600	1.6900	4.0350	13520.00	13520.00	0.00	80	8	1323	12664	0.104469361970941	1.02704193804658	1.02704193804658	false	false	false	true
c1a8e7f5-d234-4f9c-b558-2f6c2711525a	2026-08-18 13:01	2026-08-18 13:01	2026-08-18 13:01	TMC	TMC270115C00005000	call	5.0000	2027-01-15	0.7400	0.6400	0.7400	4.0200	14800.00	14800.00	0.00	200	11	424	19961	0.0212414207705025	1.0123535858339	1.0123535858339	false	false	false	true
5b0418dd-7ef0-40ed-a0e9-ce8235971714	2026-08-18 12:59	2026-08-18 12:59	2026-08-18 12:59	TMC	TMC280121C00005000	call	5.0000	2028-01-21	1.6900	1.6200	1.6900	4.0050	30420.00	30420.00	0.00	180	10	1123	12664	0.0886765634870499	1.0412068948796	1.03917296779138	false	false	false	true
418bb49e-86f2-4d0a-8fc6-b276e7202e50	2026-08-18 12:59	2026-08-18 12:59	2026-08-18 12:59	TMC	TMC280121C00005000	call	5.0000	2028-01-21	1.6900	1.6200	1.6900	4.0050	20280.00	20280.00	0.00	120	6	1243	12664	0.0981522425773847	1.03917296779138	1.03917296779138	false	false	false	true
e3c4b7a2-b922-4a1c-9fb2-7e701491a0fd	2026-08-18 12:56	2026-08-18 12:56	2026-08-18 12:56	TMC	TMC280121C00005000	call	5.0000	2028-01-21	1.6700	1.6000	1.6700	3.9800	33564.00	33564.00	0.00	201	20	893	12664	0.0705148452305749	1.04361228093343	1.03750000257029	true	false	false	true
7eadfd28-3f8c-4016-bb97-42b75cc81cd8	2026-08-18 12:48	2026-08-18 12:47	2026-08-18 12:47	TMC	TMC280121C00010000	call	10.0000	2028-01-21	0.9900	0.8900	0.9900	3.9500	10989.00	10989.00	0.00	111	5	566	14296	0.0395914941242306	1.04900197195597	1.04900197195597	false	false	false	true
e2b165c5-af72-4926-be35-5c42d6844680	2026-08-18 12:47	2026-08-18 12:47	2026-08-18 12:47	TMC	TMC270115C00005500	call	5.5000	2027-01-15	0.5700	0.5200	0.5700	3.9150	27588.00	27588.00	0.00	484	12	550	5611	0.098021743004812	1.0059099337106	1.0059099337106	false	false	false	true