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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 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 = 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

fb2a3bc7-2a45-476a-9e26-b974a5a8226c	2026-09-23 13:45	2026-09-23 13:45	2026-09-23 13:45	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7600	0.7400	0.7600	8.0000	34200.00	34200.00	0.00	450	7	10053	8308	1.21003851709196	0.85606451424273	0.85606451424273	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	3562181051.00	2026-11-05	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T17:48:41.957434Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
478c5861-2c51-4e11-8833-0fd71328a436	2026-09-23 13:23	2026-09-23 13:23	2026-09-23 13:23	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7500	0.7400	0.7700	8.7150	23925.00	20100.00	2475.00	319	21	9407	8308	1.1322821376986	0.853368538025471	0.853368538025471	false	false	false	true
8f8895e9-46d4-4891-8d2c-6861d7e4b8d5	2026-09-23 13:06	2026-09-23 13:06	2026-09-23 13:06	SMR	SMR261120P00009000	put	9.0000	2026-11-20	1.3000	1.2700	1.3700	8.6750	36530.00	2730.00	33800.00	281	15	467	3017	0.154789526019224	0.833256776449228	0.833256776449228	true	false	false	true
28fe29a5-130a-4d7a-b8e9-fbdbbe025e48	2026-09-23 13:06	2026-09-23 13:06	2026-09-23 13:06	SMR	SMR261016P00008500	put	8.5000	2026-10-16	0.5300	0.5000	0.5400	8.6850	62911.00	62752.00	159.00	1187	64	1212	333	3.63963963963964	0.731470037585439	0.731470037585439	true	false	false	true
9a1c801a-b405-496a-ab3e-50038cfc64a1	2026-09-23 13:04	2026-09-23 13:04	2026-09-23 13:04	SMR	SMR261120C00010000	call	10.0000	2026-11-20	0.7000	0.7000	0.7100	8.6735	14000.00	0.00	14000.00	200	9	290	4044	0.0717111770524233	0.835411782077719	0.835864930964798	false	false	false	true
f7b656f7-8994-4181-b1ff-c6a4b9861bb6	2026-09-23 12:30	2026-09-23 12:30	2026-09-23 12:30	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7300	0.7300	0.7400	8.7100	32850.00	0.00	32850.00	450	9	6943	8308	0.835700529610014	0.843122729620914	0.843122729620914	false	false	false	true
c376fdde-3535-400d-aeb1-8720ea0fdefc	2026-09-23 12:30	2026-09-23 12:30	2026-09-23 12:30	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7300	0.7300	0.7400	8.7250	28543.00	0.00	28543.00	391	11	6493	8308	0.781535869041887	0.840272272780849	0.840272272780849	false	false	false	true
40649620-51dd-4722-a1db-b2752c6aba05	2026-09-23 12:30	2026-09-23 12:30	2026-09-23 12:30	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7300	0.7300	0.7600	8.7250	14016.00	0.00	14016.00	192	5	6043	8308	0.72737120847376	0.839322932520255	0.840272272780849	false	false	false	true
5757aea6-85fd-4ed0-a12a-0b37bcc90e41	2026-09-23 12:29	2026-09-23 12:29	2026-09-23 12:29	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7400	0.7400	0.7600	8.7401	29600.00	0.00	29600.00	400	13	5643	8308	0.679224843524314	0.842992747958848	0.842992747958848	false	false	false	true
de02c597-be20-4c27-85ad-91d61a3d4f44	2026-09-23 11:48	2026-09-23 11:48	2026-09-23 11:48	SMR	SMR270115C00013000	call	13.0000	2027-01-15	0.6200	0.6200	0.6400	8.0000	12028.00	0.00	12028.00	194	15	210	2235	0.0939597315436242	0.86139396550294	0.862261266277835	false	false	false	true
87e98344-e51d-4cdb-9fa2-16b0bb4fc468	2026-09-23 11:47	2026-09-23 11:47	2026-09-23 11:47	SMR	SMR270115C00020000	call	20.0000	2027-01-15	0.2000	0.2000	0.2100	8.0000	12100.00	0.00	12100.00	605	7	1036	26584	0.0389708095094794	0.96020302644381	0.96020302644381	false	false	false	true
ed0b3a3b-af06-41a9-b551-56663adab6f2	2026-09-23 10:46	2026-09-23 10:46	2026-09-23 10:46	SMR	SMR270115P00008000	put	8.0000	2027-01-15	1.1200	1.0900	1.1200	8.6800	22176.00	22176.00	0.00	198	10	252	5172	0.0487238979118329	0.808324773117239	0.808324773117239	false	false	false	true
af599350-e902-4c98-bfb0-42360afe3088	2026-09-23 10:38	2026-09-23 10:38	2026-09-23 10:38	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7400	0.7400	0.7600	8.7100	29600.00	0.00	29600.00	400	10	4841	8308	0.582691381800674	0.846823185939193	0.848731334642879	false	false	false	true
c5559d0b-dcd4-405e-8c32-0b43dfc8e794	2026-09-23 10:24	2026-09-23 10:24	2026-09-23 10:24	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7100	0.6700	0.7100	8.5650	28400.00	28400.00	0.00	400	24	4277	8308	0.514805007221955	0.859391658590105	0.859391658590105	false	false	false	true
6f28539e-a75b-477e-b472-5ea24a17b8c6	2026-09-23 10:21	2026-09-23 10:20	2026-09-23 10:20	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7100	0.6800	0.7200	8.5699	11360.00	11360.00	0.00	160	5	3237	8308	0.389624458353394	0.858455603549676	0.858455603549676	false	false	false	true
a6545693-0f1d-499a-a0a4-686983b07c8c	2026-09-23 10:20	2026-09-23 10:20	2026-09-23 10:20	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7100	0.6800	0.7200	8.5650	26838.00	20732.00	3053.00	378	8	3055	8308	0.367717862301396	0.859391658590105	0.859391658590105	false	false	false	true
c3bc69d4-8dd3-45d1-b765-d190b975a827	2026-09-23 10:12	2026-09-23 10:12	2026-09-23 10:12	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.7400	0.7300	0.7400	8.6400	14873.00	14800.00	73.00	201	7	1602	8308	0.192826191622533	0.862134874807208	0.862134874807208	false	false	false	true
991ab93e-0051-41f4-a10c-1a5cb2706f75	2026-09-22 15:40	2026-09-22 15:40	2026-09-22 15:40	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.8400	0.8300	0.8600	8.9150	37800.00	84.00	37716.00	450	12	3595	8124	0.442516001969473	0.859964089181438	0.859964089181438	false	false	false	true
e9efc7a1-f63c-40e9-9c99-2a192022661d	2026-09-22 15:38	2026-09-22 15:38	2026-09-22 15:38	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.8400	0.8200	0.8600	8.9000	24696.00	0.00	17808.00	294	9	2519	8124	0.310068931560808	0.86190362640445	0.862873987070165	false	false	false	true
78e49c11-72a1-4a16-a985-ffc630c18fe7	2026-09-22 13:20	2026-09-22 13:20	2026-09-22 13:20	SMR	SMR270115C00012000	call	12.0000	2027-01-15	0.8600	0.8300	0.8600	8.9001	16254.00	16254.00	0.00	189	8	1085	8124	0.1335548990645	0.873494307218049	0.873494307218049	false	false	false	true
fdebded2-119e-4a6e-9a0f-a22163de31e5	2026-09-22 11:44	2026-09-22 11:44	2026-09-22 11:44	SMR	SMR261120P00008000	put	8.0000	2026-11-20	0.7200	0.7200	0.7300	8.9300	16920.00	0.00	16920.00	235	10	1126	8502	0.132439426017408	0.850992788731603	0.850992788731603	true	false	false	true
67cf6081-64ac-49a0-9a90-3668aa3620d3	2026-09-22 11:40	2026-09-22 11:40	2026-09-22 11:40	SMR	SMR261120P00008000	put	8.0000	2026-11-20	0.7200	0.7200	0.7400	8.9050	14040.00	0.00	14040.00	195	10	652	8502	0.0766878381557281	0.84491455352078	0.84491455352078	true	false	false	true
e8b895e2-888e-4f1f-805b-b1305f8cd1f7	2026-09-22 11:38	2026-09-22 11:38	2026-09-22 11:38	SMR	SMR261120P00008000	put	8.0000	2026-11-20	0.7200	0.7000	0.7200	8.9100	16416.00	16416.00	0.00	228	10	456	8502	0.0536344389555399	0.846133752056273	0.846133752056273	false	false	false	true
136f5e7b-0645-4834-81a7-90a6c08867f0	2026-09-22 11:14	2026-09-22 11:14	2026-09-22 11:14	SMR	SMR261002C00009000	call	9.0000	2026-10-02	0.4500	0.4100	0.4500	8.9397	24975.00	24975.00	0.00	555	6	637	1375	0.463272727272727	0.802707887906233	0.802707887906233	false	false	false	true
f674266b-3f28-4ffa-bfc0-bd34deadd622	2026-09-22 10:21	2026-09-22 10:21	2026-09-22 10:21	SMR	SMR270115C00011000	call	11.0000	2027-01-15	0.8900	0.8900	0.9400	8.6600	17800.00	0.00	17800.00	200	11	200	4364	0.0458295142071494	0.823272269473082	0.823272269473082	false	false	false	true
31b921d9-3674-4a76-8056-243bab423254	2026-09-22 09:52	2026-09-22 09:52	2026-09-22 09:52	SMR	SMR261016C00009000	call	9.0000	2026-10-16	0.6100	0.5600	0.6000	8.7200	18300.00	18300.00	0.00	300	5	334	2317	0.144151920586966	0.809250010657577	0.809250010657577	false	false	false	true
4b8ac771-f435-4d56-95a9-c6fefcf80591	2026-09-21 15:01	2026-09-21 15:01	2026-09-21 15:01	SMR	SMR270115P00009000	put	9.0000	2027-01-15	1.6600	1.6500	1.6600	8.0000	37018.00	37018.00	0.00	223	18	388	1066	0.363977485928705	0.828537605971546	0.828537605971546	false	false	false	true
6b9de7f3-8fff-4702-9fdb-fe0f864acf58	2026-09-21 14:48	2026-09-21 14:48	2026-09-21 14:48	SMR	SMR270115C00010000	call	10.0000	2027-01-15	1.2800	1.2800	1.3000	8.0000	12288.00	0.00	12288.00	96	19	381	11733	0.0324725134236768	0.834480793358959	0.834480793358959	false	false	false	true
ee077680-2d98-4b2b-a03e-6c3d5e1fc56c	2026-09-21 12:43	2026-09-21 12:43	2026-09-21 12:43	SMR	SMR261016C00009500	call	9.5000	2026-10-16	0.4800	0.4700	0.4900	8.8550	10032.00	9936.00	0.00	209	14	621	0	0	0.784700576593316	0.784700576593316	false	false	false	true
a91dd902-c70b-4670-82da-09a3d021fefa	2026-09-21 12:21	2026-09-21 12:21	2026-09-21 12:21	SMR	SMR261120C00009000	call	9.0000	2026-11-20	1.1900	1.1800	1.1900	8.8850	11186.00	11186.00	0.00	94	12	1507	1633	0.922841396203307	0.848456148564453	0.848456148564453	true	false	false	true
07ae2817-e944-4cc5-8eaf-90bf6f099b7b	2026-09-21 12:19	2026-09-21 12:19	2026-09-21 12:19	SMR	SMR261120C00009000	call	9.0000	2026-11-20	1.1900	1.1700	1.1900	8.0000	17969.00	17969.00	0.00	151	24	1409	1633	0.862829148805879	0.847981852228431	0.847981852228431	true	false	false	true
614a2be6-da46-4bf3-8462-ddf2a1361924	2026-09-21 11:55	2026-09-21 11:55	2026-09-21 11:55	SMR	SMR261016P00009000	put	9.0000	2026-10-16	0.7600	0.7200	0.7600	8.9050	108908.00	108908.00	0.00	1433	27	1445	2447	0.590519002860646	0.777155012695835	0.777155012695835	false	false	false	true
ae670957-f4d0-4736-859c-8c188e71898e	2026-09-21 11:22	2026-09-21 11:22	2026-09-21 11:22	SMR	SMR261016C00009500	call	9.5000	2026-10-16	0.5000	0.4900	0.5100	8.8850	16800.00	1300.00	250.00	336	62	388	0	0	0.793061897479965	0.793061897479965	true	false	false	true
8bbdd2ca-170d-4675-bd93-644ef4abb07e	2026-09-21 11:22	2026-09-21 11:21	2026-09-21 11:21	SMR	SMR261120C00009000	call	9.0000	2026-11-20	1.2000	1.1800	1.2100	8.8900	19080.00	12000.00	0.00	159	8	1036	1633	0.634415186772811	0.853519298234365	0.853519298234365	true	false	false	true
87ff023f-16cf-4b1c-9ea2-65899601a7c4	2026-09-21 10:22	2026-09-21 10:22	2026-09-21 10:22	SMR	SMR260925C00008500	call	8.5000	2026-09-25	0.4500	0.4300	0.4500	8.7224	19395.00	19395.00	0.00	431	10	960	3347	0.286824021511802	0.902881248716308	0.902881248716308	true	false	false	true
6a3a8f18-1e27-4258-8951-629c0c4d325a	2026-09-21 10:20	2026-09-21 10:20	2026-09-21 10:20	SMR	SMR261016C00010000	call	10.0000	2026-10-16	0.3200	0.3000	0.3200	8.7050	64992.00	64992.00	0.00	2031	43	2487	6968	0.356917336394948	0.822243634769807	0.822243634769807	false	false	false	true
3632cc29-1769-4482-a919-facdc372a990	2026-09-21 10:14	2026-09-21 10:13	2026-09-21 10:13	SMR	SMR261016C00011000	call	11.0000	2026-10-16	0.1700	0.1600	0.1700	8.6900	75446.00	75446.00	0.00	4438	45	4604	1996	2.30661322645291	0.860765401096145	0.859263853791268	false	false	false	true
bf15150a-15dc-44a2-9622-26ea4179308b	2026-09-21 10:12	2026-09-21 10:12	2026-09-21 10:12	SMR	SMR261120P00008000	put	8.0000	2026-11-20	0.8000	0.7900	0.8200	8.6651	10640.00	0.00	10640.00	133	7	177	8346	0.0212077641984184	0.840492162876011	0.840492162876011	true	false	false	true
e486ac2e-27ec-484c-9d90-38c694c073e8	2026-09-21 10:10	2026-09-21 10:09	2026-09-21 10:09	SMR	SMR261016C00009000	call	9.0000	2026-10-16	0.5800	0.5800	0.6200	8.6850	20126.00	0.00	20126.00	347	17	407	1920	0.211979166666667	0.777934396019548	0.777934396019548	false	false	false	true
13f91381-e25a-4b7d-92e5-ff3ec51d4d2e	2026-09-18 13:37	2026-09-18 13:37	2026-09-18 13:37	SMR	SMR261023C00011000	call	11.0000	2026-10-23	0.1700	0.1700	0.2400	8.3159	11033.00	0.00	11033.00	649	5	5574	169	32.9822485207101	0.819964494859945	0.819964494859945	false	false	false	true
98c3a93b-e4ab-4dcd-98dd-ab2016dc70cf	2026-09-18 12:45	2026-09-18 12:45	2026-09-18 12:45	SMR	SMR270115P00007000	put	7.0000	2027-01-15	0.8000	0.7800	0.8000	8.2750	17360.00	17360.00	0.00	217	21	382	10466	0.0364991400726161	0.806510227859068	0.806510227859068	false	false	false	true
47383035-e109-4f25-993a-d11652de4b12	2026-09-18 12:38	2026-09-18 12:38	2026-09-18 12:38	SMR	SMR261009C00008000	call	8.0000	2026-10-09	0.7400	0.7400	0.7700	8.2750	18500.00	0.00	18500.00	250	7	398	323	1.23219814241486	0.748882913050005	0.748882913050005	true	false	false	true
870e03a2-de8b-4c9b-b83d-e4f533766fff	2026-09-18 12:29	2026-09-18 12:29	2026-09-18 12:29	SMR	SMR261023C00011000	call	11.0000	2026-10-23	0.1700	0.1700	0.2000	8.3250	28509.00	0.00	28509.00	1677	32	1787	169	10.5739644970414	0.817597731400331	0.817597731400331	false	false	false	true
c2383330-2e66-437b-9fd0-565da1e2fdce	2026-09-18 12:23	2026-09-18 12:23	2026-09-18 12:23	SMR	SMR260925P00008000	put	8.0000	2026-09-25	0.1700	0.1600	0.1700	8.0000	21046.00	21046.00	0.00	1238	20	6798	1197	5.67919799498747	0.682738007918784	0.682738007918784	true	false	false	true
df118355-b21f-489f-8e09-63a2d2229b48	2026-09-18 11:46	2026-09-18 11:46	2026-09-18 11:46	SMR	SMR270115C00019000	call	19.0000	2027-01-15	0.2200	0.1900	0.2200	8.3500	16522.00	16522.00	0.00	751	26	751	58	12.948275862069	0.973703485844403	0.973703485844403	false	false	false	true
d1185d6d-0422-4cbb-8a67-2ced348aa735	2026-09-18 11:45	2026-09-18 11:45	2026-09-18 11:45	SMR	SMR260925P00008000	put	8.0000	2026-09-25	0.1700	0.1600	0.1700	8.3400	14076.00	14076.00	0.00	828	18	4373	1197	3.65329991645781	0.694257314107773	0.694257314107773	true	false	false	true
21a09165-6a23-40b8-851e-89718be4e080	2026-09-18 11:01	2026-09-18 11:01	2026-09-18 11:01	SMR	SMR261120C00008000	call	8.0000	2026-11-20	1.4600	1.4600	1.5000	8.5550	36500.00	0.00	36500.00	250	10	513	1260	0.407142857142857	0.829382042370099	0.829382042370099	true	false	false	true
a339ca25-9e7b-41de-9e3b-fd47cb967f36	2026-09-17 12:54	2026-09-17 12:54	2026-09-17 12:54	SMR	SMR270115P00010000	put	10.0000	2027-01-15	2.2100	2.1900	2.2100	9.1555	88253.00	55913.00	0.00	400	26	477	4100	0.116341463414634	0.852645417479476	0.852645417479476	false	false	false	true
52f0fbae-615b-4b89-99f2-df1d288f6327	2026-09-17 12:17	2026-09-17 12:17	2026-09-17 12:17	SMR	SMR261002C00009000	call	9.0000	2026-10-02	0.6500	0.6300	0.6800	9.1600	13000.00	0.00	13000.00	200	7	419	859	0.487776484284051	0.761727783245879	0.761727783245879	false	false	false	true
5dec7a34-8d8c-4a00-a512-2a85fda9ae72	2026-09-17 12:13	2026-09-17 12:13	2026-09-17 12:13	SMR	SMR261016C00010000	call	10.0000	2026-10-16	0.4600	0.4600	0.4800	9.0699	10948.00	0.00	10948.00	238	7	988	6031	0.163820261979771	0.780697953688925	0.780697953688925	false	false	false	true