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:er_time = unknown×ticker = SMR×

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

3eed96ae-a47c-4578-90f1-e34a502bc24f	2026-09-08 10:08	2026-09-08 10:08	2026-09-08 10:08	SMR	SMR261016C00010000	call	10.0000	2026-10-16	1.6800	1.6800	1.7300	10.8820	11592.00	0.00	11592.00	69	6	1005	5271	0.190665907797382	0.868839216765003	0.868839216765003	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	3492414832.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T14:14:21.867252Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0a89b275-b061-4841-ae94-65ba4e7dd894	2026-09-08 10:00	2026-09-08 10:00	2026-09-08 10:00	SMR	SMR260911C00012000	call	12.0000	2026-09-11	0.1500	0.1400	0.1500	10.9050	11250.00	11250.00	0.00	750	17	3217	1054	3.05218216318786	1.26864587177998	1.26864587177998	false	false	false	true	false
2e82a1e2-6f50-4543-a902-09be2e092b45	2026-09-08 10:00	2026-09-08 10:00	2026-09-08 10:00	SMR	SMR260911C00012000	call	12.0000	2026-09-11	0.1500	0.1300	0.1500	10.9100	11250.00	11250.00	0.00	750	18	2467	1054	2.34060721062619	1.26864587177998	1.26488653181662	false	false	false	true	false
8fea1dae-7520-42aa-81b6-f7f03f60acaa	2026-09-08 09:57	2026-09-08 09:56	2026-09-08 09:56	SMR	SMR260911C00011000	call	11.0000	2026-09-11	0.3700	0.3700	0.3900	10.7900	11618.00	0.00	11618.00	314	7	11712	2861	4.09367354072003	1.18342783867918	1.18342783867918	false	false	false	true	false
3fddf4dd-36ab-4d0e-b606-59d339e375d6	2026-09-08 09:54	2026-09-08 09:53	2026-09-08 09:53	SMR	SMR270115C00017000	call	17.0000	2027-01-15	0.8700	0.6700	0.8700	10.6401	174000.00	174000.00	0.00	2000	12	2004	2566	0.780982073265783	0.946296316486204	0.946296316486204	false	false	false	true
11bbdfb1-fd0c-4e38-b830-8c1fcbbe89e6	2026-09-08 09:51	2026-09-08 09:51	2026-09-08 09:51	SMR	SMR261016C00013000	call	13.0000	2026-10-16	0.4400	0.3800	0.4500	10.5250	23188.00	22176.00	1012.00	527	14	564	389	1.44987146529563	0.873160773143971	0.873160773143971	true	false	false	true
b91173ca-70e3-4814-ade0-6aa926454c2a	2026-09-08 09:47	2026-09-08 09:47	2026-09-08 09:47	SMR	SMR260918C00009000	call	9.0000	2026-09-18	1.5900	1.5100	1.7500	10.4400	47850.00	39850.00	8000.00	300	11	405	2155	0.187935034802784	0.994340376142301	0.978143965865929	false	false	false	true
1f8a87f6-7422-4163-9bb9-3ee4aad00236	2026-09-08 09:46	2026-09-08 09:46	2026-09-08 09:46	SMR	SMR260918C00011000	call	11.0000	2026-09-18	0.4200	0.4000	0.4400	10.4500	11382.00	2814.00	8568.00	271	7	1120	10058	0.11135414595347	0.925510852072002	0.925510852072002	false	false	false	true
feb25fde-79ee-49fa-8518-85a972590e55	2026-09-08 09:36	2026-09-08 09:36	2026-09-08 09:36	SMR	SMR260911C00010000	call	10.0000	2026-09-11	0.4800	0.4500	0.5000	10.2100	15508.00	15508.00	0.00	326	17	1089	3996	0.272522522522523	1.00957279790856	1.05147255520674	true	false	false	true	false
aaae93c0-88d8-4985-9c63-aab9e339a62f	2026-09-08 09:36	2026-09-08 09:36	2026-09-08 09:36	SMR	SMR260911C00011000	call	11.0000	2026-09-11	0.1300	0.1100	0.1300	10.1850	112385.00	112385.00	0.00	8645	55	9191	2861	3.21251310730514	1.08624407727273	1.08624407727273	false	false	false	true
002c74c2-2e27-43b4-951e-178860f4dff5	2026-09-04 13:00	2026-09-04 13:00	2026-09-04 13:00	SMR	SMR270115C00014000	call	14.0000	2027-01-15	0.8800	0.8000	0.9200	9.5650	87556.00	87556.00	0.00	1000	7	1002	3298	0.303820497271073	0.880283704936531	0.880283704936531	false	false	false	true
55a55c0e-3275-480f-8100-362f82a71a8d	2026-09-04 11:37	2026-09-04 11:37	2026-09-04 11:37	SMR	SMR280121P00008000	put	8.0000	2028-01-21	2.6000	2.5100	2.6000	9.5501	12990.00	12990.00	0.00	50	6	51	3430	0.014868804664723	0.92582878893653	0.922844278746299	false	false	false	true	false
0b3b2728-3db7-4110-8a3c-68aaae15d97e	2026-09-04 11:16	2026-09-04 11:16	2026-09-04 11:16	SMR	SMR261120P00009000	put	9.0000	2026-11-20	1.0800	1.0700	1.0900	9.6200	15660.00	0.00	12204.00	145	7	273	2628	0.103881278538813	0.827917019774169	0.827917019774169	false	false	false	true	false
e4ae8646-4a21-46e3-9a4f-45dca679bca9	2026-09-04 10:25	2026-09-04 10:25	2026-09-04 10:25	SMR	SMR261120C00015000	call	15.0000	2026-11-20	0.3600	0.3600	0.3800	9.5700	31500.00	0.00	27000.00	875	6	880	2792	0.315186246418338	0.90385245970822	0.90385245970822	false	false	false	true	false
55cc1283-0681-4da0-b3cc-317995d0f84e	2026-09-03 15:57	2026-09-03 15:57	2026-09-03 15:57	SMR	SMR260904C00008500	call	8.5000	2026-09-04	1.1800	1.0800	1.3700	9.6800	17936.00	16166.00	1770.00	152	17	188	219	0.858447488584475	1.83235327821457	3.19481045370326	false	false	false	true	false
81be8eb6-4b7b-4d4a-9a03-3185dd775c39	2026-09-03 09:30	2026-09-03 09:30	2026-09-03 09:30	SMR	SMR261120C00010000	call	10.0000	2026-11-20	1.4600	1.3000	1.5500	9.7500	14550.00	14550.00	0.00	100	5	100	2676	0.0373692077727952	0.841760780206574	0.856857066544927	false	false	false	true
951b3318-c5b5-449f-aafb-911e6eeea5a2	2026-09-02 10:27	2026-09-02 10:27	2026-09-02 10:27	SMR	SMR260911C00009000	call	9.0000	2026-09-11	0.5600	0.5300	0.6100	9.2650	142688.00	142632.00	56.00	2548	16	2550	239	10.6694560669456	0.71523013475066	0.71523013475066	false	false	false	true
41d92676-9648-42e9-87b7-4c535979d1d6	2026-09-01 15:50	2026-09-01 15:49	2026-09-01 15:49	SMR	SMR261120C00025000	call	25.0000	2026-11-20	0.0800	0.0400	0.0800	9.1600	15728.00	15728.00	0.00	1966	30	1970	2799	0.703822793854948	1.10777043194171	1.10777043194171	false	false	false	true
49aaf571-e037-4d64-98dd-e3cbe48be377	2026-09-01 09:37	2026-09-01 09:37	2026-09-01 09:37	SMR	SMR260918P00010000	put	10.0000	2026-09-18	1.3600	1.3000	1.3600	8.8500	54264.00	52496.00	0.00	399	10	400	1171	0.341588385994876	0.792791517362356	0.792791517362356	false	false	false	true	false
49780765-868f-4aa4-888b-bcb2e7f6efee	2026-08-31 15:43	2026-08-31 15:43	2026-08-31 15:43	SMR	SMR261120C00020000	call	20.0000	2026-11-20	0.1500	0.1200	0.1600	9.2100	25995.00	25695.00	300.00	1733	38	1849	4646	0.397976754197159	1.02114094304277	1.02114094304277	false	false	false	true
c6a1aafa-576e-4ef7-ae2b-3fbf8db89585	2026-08-31 14:52	2026-08-31 14:51	2026-08-31 14:51	SMR	SMR261009C00012000	call	12.0000	2026-10-09	0.2400	0.2400	0.2800	9.2450	21720.00	0.00	21720.00	905	17	5033	5	1006.6	0.804923005382847	0.804923005382847	false	false	false	true	false
c7c03c40-41c3-4ed7-8563-b21f8d5fbad1	2026-08-31 14:51	2026-08-31 14:50	2026-08-31 14:50	SMR	SMR261009C00012000	call	12.0000	2026-10-09	0.2300	0.2300	0.2800	9.2450	14926.00	0.00	14926.00	643	28	4032	5	806.4	0.804923005382847	0.792995336591837	false	false	false	true	false
2b8621c0-38b0-4abd-8097-b2f00a1343c4	2026-08-31 14:50	2026-08-31 14:50	2026-08-31 14:50	SMR	SMR261009C00012000	call	12.0000	2026-10-09	0.2500	0.2100	0.3000	9.2550	69985.00	0.00	69985.00	2852	22	3142	5	628.4	0.813116421754622	0.802562993451935	false	false	false	true	false
a14bbd21-4fd5-4df8-8276-af4ed06abe44	2026-08-31 10:49	2026-08-31 10:49	2026-08-31 10:49	SMR	SMR280121P00008000	put	8.0000	2028-01-21	2.7100	2.7000	2.9200	9.2850	13821.00	1355.00	3252.00	51	16	52	3396	0.0153121319199058	0.937853283756017	0.937853283756017	false	false	false	true	false
b387e713-1680-4946-b1dc-3e1bf717d23b	2026-08-28 15:33	2026-08-28 15:33	2026-08-28 15:33	SMR	SMR260925C00009500	call	9.5000	2026-09-25	0.6700	0.6700	0.7000	9.2250	20100.00	0.00	20100.00	300	12	613	680	0.901470588235294	0.763792830623374	0.763792830623374	false	false	false	true	false
b3b6b814-ee17-427f-a4af-dcc8d22b8db3	2026-08-28 14:21	2026-08-28 14:21	2026-08-28 14:21	SMR	SMR261120P00008000	put	8.0000	2026-11-20	0.8500	0.8500	0.8600	9.1850	176545.00	0.00	176545.00	2077	18	2102	6139	0.342401042515068	0.855201475546827	0.855201475546827	false	false	false	true
e364291d-9815-46e0-b389-e00a585f91b5	2026-08-28 13:45	2026-08-28 13:45	2026-08-28 13:45	SMR	SMR261120C00010000	call	10.0000	2026-11-20	1.2800	1.2800	1.3100	9.2650	19712.00	0.00	19712.00	154	10	532	2374	0.224094355518113	0.868941410682673	0.868941410682673	false	false	false	true
82c41ea6-9cd2-46e2-aedd-6a8526640685	2026-08-28 13:28	2026-08-28 13:28	2026-08-28 13:28	SMR	SMR261002C00012000	call	12.0000	2026-10-02	0.2200	0.2200	0.2300	9.2850	17116.00	0.00	17116.00	778	34	4911	302	16.2615894039735	0.815471373686068	0.815471373686068	false	false	false	true	false
28fc1605-cbed-43ab-bf04-e91d34499edb	2026-08-28 13:27	2026-08-28 13:27	2026-08-28 13:27	SMR	SMR261002C00012000	call	12.0000	2026-10-02	0.2200	0.2200	0.2300	9.2850	18986.00	0.00	18986.00	863	25	4133	302	13.6854304635762	0.814276443318952	0.815471373686068	false	false	false	true	false
314d76de-c574-4882-89c2-7a9a5d933f91	2026-08-28 13:24	2026-08-28 13:24	2026-08-28 13:24	SMR	SMR261002C00012000	call	12.0000	2026-10-02	0.2300	0.2200	0.2700	9.3000	53291.00	0.00	53268.00	2317	33	2650	302	8.77483443708609	0.82446783617629	0.82446783617629	false	false	false	true	false
bf866149-b028-4c2b-aec2-15fb4122e839	2026-08-28 11:35	2026-08-28 11:35	2026-08-28 11:35	SMR	SMR261120C00010000	call	10.0000	2026-11-20	1.4400	1.4300	1.4900	9.5401	29808.00	4320.00	25488.00	207	7	335	2374	0.141112047177759	0.876380943983684	0.876380943983684	false	false	false	true
a5f95de1-d2e7-4a50-841e-c9c91001ac03	2026-08-28 10:23	2026-08-28 10:23	2026-08-28 10:23	SMR	SMR261016C00010000	call	10.0000	2026-10-16	0.9600	0.9600	1.0200	9.5250	226752.00	0.00	226752.00	2362	57	2478	3874	0.639648941662365	0.817979634859693	0.817979634859693	false	false	false	true
bf506f2f-b67e-4ff2-8d2d-117436d0d1ed	2026-08-28 09:38	2026-08-28 09:38	2026-08-28 09:38	SMR	SMR260904C00009000	call	9.0000	2026-09-04	0.9400	0.8300	0.9600	9.8000	32618.00	32242.00	376.00	347	59	487	3867	0.125937419188001	0.828031504744131	0.807726843910179	true	false	false	true
83a03bfa-a2fc-40bf-8238-352ad1521eca	2026-08-28 09:38	2026-08-28 09:38	2026-08-28 09:38	SMR	SMR260904C00009000	call	9.0000	2026-09-04	0.9400	0.8300	0.9400	9.7900	12596.00	12596.00	0.00	134	10	140	3867	0.0362037755365917	0.837964895809953	0.828031504744131	true	false	false	true	false
1164e773-64de-4644-93a1-3716cc96d17e	2026-08-28 09:36	2026-08-28 09:36	2026-08-28 09:36	SMR	SMR260828C00009000	call	9.0000	2026-08-28	0.8100	0.8100	0.9300	9.7265	38394.00	0.00	36045.00	474	30	479	1811	0.264494754279404	3.22661842518419	3.22661842518419	true	false	false	true	false
67a3222c-c4c2-4247-bf9e-4b527c2335c6	2026-08-27 14:43	2026-08-27 14:43	2026-08-27 14:43	SMR	SMR260904P00010000	put	10.0000	2026-09-04	0.6800	0.6700	0.6800	9.6318	16184.00	16184.00	0.00	238	17	513	1267	0.404893449092344	0.826650999156633	0.826650999156633	false	false	false	true	false
3bdc9e9c-e44d-4f14-9c21-207e9363eef2	2026-08-27 13:57	2026-08-27 13:56	2026-08-27 13:56	SMR	SMR261120P00010000	put	10.0000	2026-11-20	1.7700	1.7500	1.8300	9.6850	17523.00	2832.00	14691.00	99	9	206	4076	0.0505397448478901	0.885099878507776	0.883914777842332	false	false	false	true	false
845d2695-30fb-4206-932a-270ee1537f86	2026-08-27 12:46	2026-08-27 12:46	2026-08-27 12:46	SMR	SMR261016P00011000	put	11.0000	2026-10-16	1.9800	1.9700	2.0100	9.7550	19800.00	198.00	19602.00	100	7	109	20351	0.00535600216205592	0.855677643219142	0.855677643219142	true	false	false	true
8de7b70d-97ed-4370-9026-2cc1cf189d8c	2026-08-27 12:22	2026-08-27 12:22	2026-08-27 12:22	SMR	SMR260911C00011000	call	11.0000	2026-09-11	0.2400	0.2100	0.2400	9.6750	19200.00	19200.00	0.00	800	6	1030	2128	0.484022556390977	0.852768372132948	0.852768372132948	false	false	false	true
3e8f68b4-8132-4671-9b75-5c3b0e5ba2e0	2026-08-27 11:40	2026-08-27 11:40	2026-08-27 11:40	SMR	SMR261120C00020000	call	20.0000	2026-11-20	0.2100	0.1800	0.2100	9.6450	11403.00	11403.00	0.00	543	28	558	5090	0.109626719056974	1.01895114560111	1.01769037287032	false	false	false	true	false
0e0ddcd3-cb4b-4078-ae7d-243d7d783698	2026-08-27 10:55	2026-08-27 10:55	2026-08-27 10:55	SMR	SMR270115P00007000	put	7.0000	2027-01-15	0.7000	0.7000	0.7300	9.6300	18410.00	0.00	18410.00	263	13	316	9758	0.0323836851813896	0.865370238332305	0.865370238332305	false	false	false	true	false
ebe2a32d-950a-4665-a69b-9b89e4296462	2026-08-27 10:20	2026-08-27 10:20	2026-08-27 10:20	SMR	SMR260911P00009000	put	9.0000	2026-09-11	0.3200	0.3000	0.3200	9.6800	45056.00	45056.00	0.00	1408	30	1409	2378	0.592514718250631	0.802420878152929	0.802420878152929	true	false	false	true	false
a56a8e2e-1432-438c-83c6-2c4c09d7b336	2026-08-27 10:14	2026-08-27 10:14	2026-08-27 10:14	SMR	SMR260918C00012000	call	12.0000	2026-09-18	0.1900	0.1700	0.2100	9.6000	19000.00	6498.00	12502.00	1000	6	1007	3348	0.300776583034648	0.889239222256016	0.889239222256016	false	false	false	true
0a84d989-28f5-4f83-a5c0-8496b5b9f150	2026-08-26 14:57	2026-08-26 14:57	2026-08-26 14:57	SMR	SMR260828C00009000	call	9.0000	2026-08-28	0.3600	0.3600	0.3800	9.1900	15336.00	0.00	15336.00	426	11	2077	1473	1.41004752206382	0.940635178578511	0.940635178578511	false	false	false	true	false
e4c1e83e-c946-49c5-afca-cd5988b77bea	2026-08-26 14:31	2026-08-26 14:30	2026-08-26 14:30	SMR	SMR260904P00008500	put	8.5000	2026-09-04	0.2200	0.2000	0.2250	9.0600	17732.00	17732.00	0.00	806	16	2941	1761	1.67007382169222	0.815445893959002	0.815445893959002	false	false	false	true	false
f4ac1fbc-08e8-4cee-8f0d-6f3d068b5fa9	2026-08-26 11:07	2026-08-26 11:07	2026-08-26 11:07	SMR	SMR260918C00010500	call	10.5000	2026-09-18	0.3900	0.3900	0.4300	9.3400	13533.00	0.00	13533.00	347	21	384	586	0.655290102389078	0.847177952020152	0.847177952020152	false	false	false	true	false
44ae66f5-0f5b-4b9f-97be-9d1deffc373f	2026-08-25 15:48	2026-08-25 15:48	2026-08-25 15:48	SMR	SMR260904C00010500	call	10.5000	2026-09-04	0.3200	0.3000	0.3200	9.7350	19168.00	19168.00	0.00	599	8	1514	799	1.89486858573217	0.939083978793373	0.939083978793373	false	false	false	true	false
3201c8d4-3dea-4f8f-9ceb-d7bc25bce585	2026-08-25 15:44	2026-08-25 15:43	2026-08-25 15:43	SMR	SMR261120C00012000	call	12.0000	2026-11-20	1.0700	1.0200	1.0700	9.7899	10662.00	10662.00	0.00	100	6	397	3186	0.124607658505964	0.930660894633209	0.925307926186297	false	false	false	true	false
0970143c-becb-4120-9ae0-b0f2f8fd1f36	2026-08-25 15:30	2026-08-25 15:30	2026-08-25 15:30	SMR	SMR260904C00012500	call	12.5000	2026-09-04	0.0800	0.0800	0.0900	9.8200	15776.00	0.00	15776.00	1972	34	1999	547	3.654478976234	1.07395662900785	1.07395662900785	false	false	false	true	false
346657c3-26f6-4ff1-926b-54653b8a510d	2026-08-25 15:00	2026-08-25 15:00	2026-08-25 15:00	SMR	SMR260828C00010000	call	10.0000	2026-08-28	0.3200	0.3100	0.3300	9.8038	11872.00	9344.00	0.00	371	9	9512	6256	1.52046035805627	1.143647803077	1.143647803077	false	false	false	true	false