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

45d4bd24-46ec-42ae-966e-ba8d46a42c13	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	SMR	SMR280121C00008000	call	8.0000	2028-01-21	3.7000	3.6500	3.7000	8.4350	31814.00	31080.00	734.00	86	5	698	5434	0.128450496871549	0.911564179835237	0.911564179835237	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-14T15:20:09.779343Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
78d65175-3cc6-4266-89a4-cffb01c2f656	2026-09-14 10:33	2026-09-14 10:32	2026-09-14 10:32	SMR	SMR261120P00009000	put	9.0000	2026-11-20	1.5200	1.5100	1.5300	8.4100	13224.00	152.00	13072.00	87	15	136	2455	0.0553971486761711	0.842085731680978	0.842085731680978	false	false	false	true	false
465d7f9c-5965-4796-bb8c-9076ee9ea08a	2026-09-14 10:10	2026-09-14 10:10	2026-09-14 10:10	SMR	SMR280121C00008000	call	8.0000	2028-01-21	3.7000	3.6500	3.7500	8.4150	15912.00	742.00	15170.00	43	28	252	5434	0.0463746779536253	0.91619868036107	0.91619868036107	true	false	false	true	false
6b9eaa2e-1e5a-4917-9cbf-cc908a404bdd	2026-09-11 15:51	2026-09-11 15:50	2026-09-11 15:50	SMR	SMR261016P00010000	put	10.0000	2026-10-16	1.6500	1.5900	1.6700	8.7300	44220.00	41085.00	825.00	268	35	685	1308	0.523700305810398	0.78925688120487	0.78590831240063	true	false	false	true	false
8b480341-283b-41fe-a39e-dcb750e5b013	2026-09-11 15:50	2026-09-11 15:50	2026-09-11 15:50	SMR	SMR261016P00010000	put	10.0000	2026-10-16	1.6500	1.5900	1.6500	8.7500	19470.00	19470.00	0.00	118	14	417	1308	0.318807339449541	0.799192716417377	0.799192716417377	false	false	false	true	false
20263d5f-3519-4dac-8d18-991dcd34ec0b	2026-09-11 15:50	2026-09-11 15:50	2026-09-11 15:50	SMR	SMR261016P00010000	put	10.0000	2026-10-16	1.6500	1.5900	1.6500	8.7500	18810.00	18810.00	0.00	114	12	299	1308	0.228593272171254	0.799192716417377	0.799192716417377	false	false	false	true	false
17ed45b4-bb48-4677-93a3-6ca393d59976	2026-09-11 15:46	2026-09-11 15:46	2026-09-11 15:46	SMR	SMR260918P00009000	put	9.0000	2026-09-18	0.4900	0.4800	0.5000	8.7701	142963.00	142963.00	0.00	2917	5	7065	3102	2.27756286266925	0.749724660970658	0.77072370766677	false	false	false	true	false
ae761ec9-8dfa-408f-8205-26553b17f6f8	2026-09-11 15:41	2026-09-11 15:41	2026-09-11 15:41	SMR	SMR280121C00008000	call	8.0000	2028-01-21	3.9500	3.9500	4.0000	8.7850	10665.00	0.00	10665.00	27	8	482	5466	0.0881814855470179	0.916521859463494	0.916521859463494	false	false	false	true	false
1967cadb-7ce4-4c3d-8821-741cf55a3290	2026-09-11 15:41	2026-09-11 15:41	2026-09-11 15:41	SMR	SMR280121C00008000	call	8.0000	2028-01-21	3.9500	3.9500	4.0000	8.7850	36744.00	1194.00	35550.00	93	21	455	5466	0.0832418587632638	0.925704097496872	0.916521859463494	false	false	false	true
4c1a0bfc-a9b3-4053-bcc1-6be1ef0a5df0	2026-09-11 14:17	2026-09-11 14:17	2026-09-11 14:17	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.9400	0.9100	0.9600	8.8650	28200.00	5546.00	7614.00	300	8	695	7512	0.0925186368477103	0.882752294020611	0.882752294020611	false	false	false	true
5159b363-1384-4c7e-88fa-a6c07ecf7ada	2026-09-11 14:04	2026-09-11 14:04	2026-09-11 14:04	SMR	SMR261002P00009000	put	9.0000	2026-10-02	0.7400	0.7200	0.7500	8.7901	11174.00	11174.00	0.00	151	18	279	164	1.70121951219512	0.754631670753853	0.754631670753853	true	false	false	true	false
fe504afa-eaaa-4b8f-b8f1-9f8a53e06918	2026-09-11 13:12	2026-09-11 13:12	2026-09-11 13:12	SMR	SMR261016P00009000	put	9.0000	2026-10-16	0.9300	0.9100	0.9300	8.8101	18600.00	18600.00	0.00	200	5	1424	1175	1.21191489361702	0.776094661478734	0.776094661478734	false	false	false	true	false
338da33f-5aa4-405f-a0b6-06432384cf87	2026-09-11 12:12	2026-09-11 12:11	2026-09-11 12:11	SMR	SMR270115C00025000	call	25.0000	2027-01-15	0.1700	0.1500	0.1700	8.9201	13719.00	13719.00	0.00	807	10	825	7387	0.111682685799377	1.03532948304937	1.03532948304937	false	false	false	true	false
4ad79efd-8809-45ef-bbf2-54b324fe72cb	2026-09-11 12:08	2026-09-11 12:08	2026-09-11 12:08	SMR	SMR261016C00009000	call	9.0000	2026-10-16	0.8300	0.8300	0.8400	8.9450	18758.00	0.00	18758.00	226	6	437	531	0.822975517890772	0.76121600986443	0.76121600986443	false	false	false	true	false
8d699df4-76ae-4fbd-9435-6c0d91784e17	2026-09-11 11:41	2026-09-11 11:40	2026-09-11 11:40	SMR	SMR261016C00008000	call	8.0000	2026-10-16	1.3400	1.3200	1.3800	8.9165	13386.00	0.00	13386.00	100	6	104	14	7.42857142857143	0.724794632903516	0.746623092646836	false	false	false	true	false
dd43cf06-9d97-4af5-aadf-08219c977ec6	2026-09-11 11:31	2026-09-11 11:31	2026-09-11 11:31	SMR	SMR260918P00009000	put	9.0000	2026-09-18	0.4700	0.4300	0.4700	8.8645	15980.00	15980.00	0.00	340	14	2673	3102	0.861702127659574	0.816078327902591	0.816078327902591	false	false	false	true	false
816c7953-c298-45e2-a680-49df18d31860	2026-09-11 11:23	2026-09-11 11:22	2026-09-11 11:22	SMR	SMR261016P00009000	put	9.0000	2026-10-16	0.8300	0.8300	0.8600	8.9600	83000.00	0.00	83000.00	1000	30	1136	1175	0.966808510638298	0.748824503244513	0.748824503244513	false	false	false	true	false
986c247a-3726-4628-b8a6-e2c76ba460b5	2026-09-11 10:51	2026-09-11 10:50	2026-09-11 10:50	SMR	SMR261016C00012000	call	12.0000	2026-10-16	0.1900	0.1900	0.2000	9.1450	14972.00	0.00	14972.00	788	29	3923	3492	1.12342497136312	0.809026841268753	0.809026841268753	false	false	false	true
f440f38b-ffb1-421e-8cfb-36f4ae97dc29	2026-09-11 10:50	2026-09-11 10:50	2026-09-11 10:50	SMR	SMR261016C00012000	call	12.0000	2026-10-16	0.2000	0.2000	0.2200	9.1400	33500.00	0.00	33500.00	1675	32	3131	3492	0.896620847651776	0.823922792147108	0.823922792147108	false	false	false	true
a61e706d-4814-4740-9cfd-2ed1f89f4224	2026-09-11 10:50	2026-09-11 10:50	2026-09-11 10:50	SMR	SMR261016C00012000	call	12.0000	2026-10-16	0.2000	0.2000	0.2200	9.1400	17720.00	0.00	17720.00	886	34	1456	3492	0.416953035509737	0.823922792147108	0.823922792147108	false	false	false	true
6aa8965d-34a2-4d0a-b053-c335b4d5cb8f	2026-09-11 09:31	2026-09-11 09:31	2026-09-11 09:31	SMR	SMR261120C00013000	call	13.0000	2026-11-20	0.5200	0.5200	0.6400	9.0000	10400.00	0.00	10400.00	200	5	207	2829	0.0731707317073171	0.875383212272293	0.875383212272293	false	false	false	true
909837df-5c2b-45de-b1f7-9d3dd93a8fbe	2026-09-10 11:23	2026-09-10 11:22	2026-09-10 11:22	SMR	SMR270115C00015000	call	15.0000	2027-01-15	1.0500	1.0500	1.0800	10.5050	16695.00	0.00	16695.00	159	13	262	16131	0.0162420184737462	0.914112414910455	0.914112414910455	false	false	false	true
005f0f6b-409f-45a0-b72f-ea7a64ac7f9d	2026-09-10 10:13	2026-09-10 10:13	2026-09-10 10:13	SMR	SMR260918C00011000	call	11.0000	2026-09-18	0.2700	0.2700	0.2900	10.2700	16875.00	0.00	16875.00	625	27	2414	10296	0.234459984459984	0.889595078134478	0.889595078134478	false	false	false	true
10adc2c8-ce3b-401e-bd27-8899a107d45f	2026-09-10 10:05	2026-09-10 10:05	2026-09-10 10:05	SMR	SMR261120P00011000	put	11.0000	2026-11-20	1.9800	1.8900	1.9900	10.3099	12672.00	6732.00	5940.00	64	6	77	826	0.0932203389830508	0.89283419734181	0.89283419734181	false	false	false	true	false
9b08f07c-90b7-4eb4-aa0f-3db729f60e8f	2026-09-10 09:36	2026-09-10 09:36	2026-09-10 09:36	SMR	SMR261120C00011000	call	11.0000	2026-11-20	1.4600	1.4600	1.5200	10.4000	10074.00	0.00	10074.00	69	11	84	4984	0.0168539325842697	0.916922391489597	0.916922391489597	true	false	false	true	false
c46ca16a-6db8-4adb-b541-7358ec78be33	2026-09-09 14:45	2026-09-09 14:44	2026-09-09 14:44	SMR	SMR260918C00011500	call	11.5000	2026-09-18	0.3400	0.3300	0.3500	10.8596	23426.00	22780.00	646.00	689	6	1113	1613	0.690018598884067	0.862654880497288	0.862654880497288	false	false	false	true
646facb8-49a0-449a-aa86-c837ceba8586	2026-09-09 14:41	2026-09-09 14:41	2026-09-09 14:41	SMR	SMR260918C00012000	call	12.0000	2026-09-18	0.2300	0.2200	0.2300	10.8500	16100.00	16100.00	0.00	700	37	1778	5462	0.325521786891249	0.909106769289111	0.904370260965313	true	false	false	true
9480ebd5-22e6-4fa7-86e4-fa375fed3870	2026-09-09 11:26	2026-09-09 11:26	2026-09-09 11:26	SMR	SMR260925P00010000	put	10.0000	2026-09-25	0.3900	0.3800	0.4000	10.8000	13650.00	1365.00	12285.00	350	10	362	118	3.06779661016949	0.838492520050832	0.838492520050832	false	false	false	true	false
b645d6a5-63a7-4d76-ab3e-781ef7624050	2026-09-09 11:20	2026-09-09 11:19	2026-09-09 11:19	SMR	SMR260918P00011500	put	11.5000	2026-09-18	1.0300	1.0000	1.0600	10.8300	20497.00	16583.00	3914.00	199	8	248	570	0.435087719298246	0.927627516190085	0.927627516190085	true	false	false	true	false
f3ad6dde-7e64-4dda-9652-65895d78b157	2026-09-09 10:38	2026-09-09 10:38	2026-09-09 10:38	SMR	SMR261120C00011000	call	11.0000	2026-11-20	1.8000	1.7400	1.8100	10.0000	12600.00	10080.00	2520.00	70	5	125	5046	0.0247720967102656	0.922006039752615	0.922006039752615	false	false	false	true
90d86797-ecdd-40d8-8fcf-80e63a44eb2f	2026-09-09 10:19	2026-09-09 10:19	2026-09-09 10:19	SMR	SMR260911C00011000	call	11.0000	2026-09-11	0.3500	0.3500	0.3600	10.9300	55195.00	0.00	55195.00	1577	38	1982	10769	0.184046801002879	1.18299607549644	1.18299607549644	false	false	false	true
5511b661-b784-4443-9a45-a2746eabca59	2026-09-09 09:38	2026-09-09 09:38	2026-09-09 09:38	SMR	SMR261009C00011500	call	11.5000	2026-10-09	0.9400	0.9100	1.1600	11.0850	23524.00	0.00	23524.00	250	5	650	926	0.701943844492441	0.878248918087863	0.878248918087863	false	false	false	true	false
9ebd5cb2-7faf-40cd-8074-eca557b016a7	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	SMR	SMR260911P00011000	put	11.0000	2026-09-11	0.3700	0.3700	0.4000	11.1000	10545.00	0.00	10545.00	285	7	293	5968	0.0490951742627346	1.28515050914718	1.28515050914718	true	false	false	true	false
edffe8b4-35a1-4d05-b083-bff69771268b	2026-09-08 15:49	2026-09-08 15:48	2026-09-08 15:48	SMR	SMR270115C00020000	call	20.0000	2027-01-15	0.7200	0.7100	0.7400	11.2750	13176.00	216.00	12960.00	183	5	1024	25581	0.0400297095500567	0.960787203603784	0.960787203603784	false	false	false	true
ee689edf-dd5e-4dbe-ae55-31306c6e4c2e	2026-09-08 14:59	2026-09-08 14:59	2026-09-08 14:59	SMR	SMR260918C00011000	call	11.0000	2026-09-18	0.7400	0.7400	0.7700	11.1201	14356.00	0.00	14356.00	194	16	4612	10058	0.458540465301253	0.921775612729774	0.921775612729774	false	false	false	true
7468ca11-edbf-41e2-8082-f42cc323515d	2026-09-08 13:55	2026-09-08 13:55	2026-09-08 13:55	SMR	SMR260911P00011000	put	11.0000	2026-09-11	0.3700	0.3600	0.3800	11.1200	18290.00	0.00	18253.00	500	26	6721	351	19.1481481481481	1.07277589607349	1.04757448239309	false	false	false	true	false
14669337-5c97-4423-8759-37efbcf1c3b2	2026-09-08 13:55	2026-09-08 13:55	2026-09-08 13:55	SMR	SMR260911P00011000	put	11.0000	2026-09-11	0.3700	0.3700	0.3900	11.1099	18501.00	0.00	18501.00	500	5	5721	351	16.2991452991453	1.06166148217653	1.06166148217653	false	false	false	true	false
c691916c-4820-4409-ab88-c2d5853294c4	2026-09-08 13:55	2026-09-08 13:54	2026-09-08 13:54	SMR	SMR260911P00011000	put	11.0000	2026-09-11	0.3600	0.3600	0.3800	11.1450	15444.00	0.00	15444.00	429	12	5150	351	14.6723646723647	1.06391097224382	1.07470475334129	false	false	false	true	false
99a354d5-44f4-49d1-b615-aaec9fcde46a	2026-09-08 13:48	2026-09-08 13:48	2026-09-08 13:48	SMR	SMR260911P00011000	put	11.0000	2026-09-11	0.3600	0.3600	0.3900	11.1750	18000.00	0.00	18000.00	500	23	2636	351	7.50997150997151	1.10664198903979	1.10664198903979	false	false	false	true	false
e5384ca2-3f1e-402b-a0ed-04b2b020a9a3	2026-09-08 13:48	2026-09-08 13:48	2026-09-08 13:48	SMR	SMR260911P00011000	put	11.0000	2026-09-11	0.3600	0.3600	0.3900	11.1750	18000.00	0.00	18000.00	500	43	2136	351	6.08547008547009	1.10874830811147	1.10664198903979	false	false	false	true	false
d9430076-4fee-4d4e-a7f7-e03e316e0bd1	2026-09-08 13:28	2026-09-08 13:28	2026-09-08 13:28	SMR	SMR261120C00013000	call	13.0000	2026-11-20	1.2500	1.2500	1.2700	11.1650	25000.00	0.00	10125.00	200	11	579	2466	0.234793187347932	0.939400504600752	0.939400504600752	true	false	false	true
bcb622a9-cdd6-4f34-82a8-4c71f348d59c	2026-09-08 12:16	2026-09-08 12:15	2026-09-08 12:15	SMR	SMR260918C00010000	call	10.0000	2026-09-18	1.4200	1.4000	1.4900	11.1750	382832.00	142.00	382690.00	2696	20	4491	8678	0.517515556579857	0.955318917046643	0.955318917046643	true	false	false	true
1aa6f540-101c-46be-9f6f-a78301544e21	2026-09-08 11:59	2026-09-08 11:58	2026-09-08 11:58	SMR	SMR260911C00011500	call	11.5000	2026-09-11	0.3300	0.3200	0.3300	11.1643	10857.00	10857.00	0.00	329	18	9091	3127	2.90725935401343	1.16658524691381	1.16658524691381	true	false	false	true	false
b2209275-011d-4a2b-af27-f3328228b2c5	2026-09-08 11:33	2026-09-08 11:33	2026-09-08 11:33	SMR	SMR260918P00010000	put	10.0000	2026-09-18	0.2600	0.2300	0.2600	11.0800	15600.00	15600.00	0.00	600	5	1398	1310	1.06717557251908	0.962762441389709	0.962762441389709	false	false	false	true	false
0b6deb2a-aaef-484c-991a-e52019fba610	2026-09-08 11:25	2026-09-08 11:25	2026-09-08 11:25	SMR	SMR261023C00011500	call	11.5000	2026-10-23	1.2400	1.1000	1.2500	11.0500	37172.00	37172.00	0.00	300	12	376	2	188	0.897866082624181	0.897866082624181	false	false	false	true	false
23993333-2e96-48fa-bc47-d1ba78f7fe96	2026-09-08 10:57	2026-09-08 10:57	2026-09-08 10:57	SMR	SMR260911C00011500	call	11.5000	2026-09-11	0.2500	0.2400	0.2600	10.9219	94525.00	0.00	91825.00	3781	26	7625	3127	2.43843939878478	1.19464048355221	1.19464048355221	false	false	false	true
02a363c2-2142-4869-b444-498a6bd42993	2026-09-08 10:53	2026-09-08 10:53	2026-09-08 10:53	SMR	SMR270115C00010000	call	10.0000	2027-01-15	2.7500	2.6300	2.7700	10.8750	275075.00	62501.00	128149.00	1001	20	1515	9525	0.159055118110236	0.907193750687368	0.904348397845174	true	false	false	true
acab0cca-a34e-4d11-89dc-8a791a8ff44e	2026-09-08 10:26	2026-09-08 10:26	2026-09-08 10:26	SMR	SMR260911C00012000	call	12.0000	2026-09-11	0.1300	0.1300	0.1400	10.7620	15457.00	0.00	15457.00	1189	25	5683	1054	5.39184060721063	1.30297646066124	1.30297646066124	true	false	false	true	false
ccc4492c-3e6d-4132-b2b0-5fe1d287f256	2026-09-08 10:15	2026-09-08 10:15	2026-09-08 10:15	SMR	SMR260925P00010500	put	10.5000	2026-09-25	0.6500	0.6500	0.7000	10.9100	10075.00	0.00	10075.00	155	5	258	229	1.12663755458515	0.921492652072124	0.921492652072124	true	false	false	true	false
d62f7ba8-4226-4dc7-b788-ea76bbb75648	2026-09-08 10:14	2026-09-08 10:14	2026-09-08 10:14	SMR	SMR260911C00010500	call	10.5000	2026-09-11	0.6200	0.6200	0.6500	10.8200	12400.00	0.00	12400.00	200	5	3771	2705	1.39408502772643	1.14090893295156	1.14090893295156	false	false	false	true	false