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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	3648362851.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
bb367a21-815a-4679-9877-476b5c6aa0f4	2026-09-18 12:43	2026-09-18 12:43	2026-09-18 12:43	SMR	SMR261002P00008500	put	8.5000	2026-10-02	0.5800	0.5800	0.6100	8.2800	10450.00	0.00	10450.00	180	28	293	353	0.830028328611898	0.716959568462606	0.716959568462606	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
5209a979-2431-4894-8538-1aa0c3e54417	2026-09-18 10:03	2026-09-18 10:03	2026-09-18 10:03	SMR	SMR270219C00012000	call	12.0000	2027-02-19	1.0200	0.8600	1.1500	8.6050	10177.00	10075.00	0.00	100	7	100	430	0.232558139534884	0.875871199907666	0.871218630440925	false	false	false	true	false
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	false
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	false
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	false
151981e2-2297-4142-95a0-1e2d081db5d1	2026-09-17 11:09	2026-09-17 11:09	2026-09-17 11:09	SMR	SMR261016P00008000	put	8.0000	2026-10-16	0.3500	0.3400	0.3500	8.8600	24675.00	24675.00	0.00	705	24	1439	2529	0.568999604586793	0.748003920221637	0.748003920221637	false	false	false	true	false
88560a35-0242-45a3-88fb-e08a2cb503d6	2026-09-16 14:58	2026-09-16 14:58	2026-09-16 14:58	SMR	SMR260918C00009000	call	9.0000	2026-09-18	0.0400	0.0300	0.0500	8.1250	20384.00	0.00	19652.00	5096	25	5961	5145	1.15860058309038	1.1426661694608	1.1426661694608	false	false	false	true	false
7f39bad2-221f-4f20-af9d-377f8d466aa5	2026-09-16 13:04	2026-09-16 13:04	2026-09-16 13:04	SMR	SMR270115P00007000	put	7.0000	2027-01-15	0.8300	0.8200	0.8300	8.2099	12948.00	12948.00	0.00	156	16	168	10493	0.0160106737825217	0.807825098657799	0.807825098657799	false	false	false	true	false
46feef4b-bb33-4ce9-9da9-eeb8bbbf2af4	2026-09-16 12:33	2026-09-16 12:33	2026-09-16 12:33	SMR	SMR261016C00008000	call	8.0000	2026-10-16	0.8500	0.8100	0.8500	8.2150	17000.00	17000.00	0.00	200	17	449	346	1.29768786127168	0.782887526524005	0.782887526524005	false	false	false	true	false
3995006f-9b59-4f81-b607-fffd1aaaba43	2026-09-16 10:35	2026-09-16 10:35	2026-09-16 10:35	SMR	SMR280121C00015000	call	15.0000	2028-01-21	2.0800	2.0000	2.0800	8.1200	15590.00	15590.00	0.00	75	5	91	5680	0.0160211267605634	0.927916129030585	0.925256361047562	false	false	false	true	false
e1c093e8-7519-47e4-b511-65c17e2baa55	2026-09-15 14:59	2026-09-15 14:58	2026-09-15 14:58	SMR	SMR261016P00009000	put	9.0000	2026-10-16	1.0000	0.9900	1.0000	8.5550	15300.00	15300.00	0.00	153	14	453	2299	0.197042192257503	0.76293826565246	0.76293826565246	false	false	false	true	false
b15318a8-8255-4dc5-8e06-3baef9de890c	2026-09-15 13:04	2026-09-15 13:04	2026-09-15 13:04	SMR	SMR261009P00008000	put	8.0000	2026-10-09	0.3600	0.3500	0.3600	8.6250	53352.00	53352.00	0.00	1482	20	1531	291	5.26116838487973	0.742475348226059	0.742475348226059	false	false	false	true	false
2cc445e6-fe16-4141-92af-8fb7f0fe6e05	2026-09-15 12:31	2026-09-15 12:30	2026-09-15 12:30	SMR	SMR280121C00015000	call	15.0000	2028-01-21	2.2200	2.1300	2.2200	8.0000	221778.00	221778.00	0.00	999	5	1594	7243	0.22007455474251	0.909816334959377	0.909816334959377	false	false	false	true
b8cae635-13cf-4f30-a564-2ef36f74e54d	2026-09-15 12:00	2026-09-15 12:00	2026-09-15 12:00	SMR	SMR261016P00008000	put	8.0000	2026-10-16	0.5200	0.5100	0.5200	8.3700	20436.00	20436.00	0.00	393	25	669	1497	0.44689378757515	0.739351190979843	0.739351190979843	false	false	false	true	false
792d14b4-853d-478f-a0c2-8ce9e93c5cba	2026-09-14 13:10	2026-09-14 13:10	2026-09-14 13:10	SMR	SMR261120C00010000	call	10.0000	2026-11-20	0.8300	0.8100	0.8300	8.7050	11039.00	11039.00	0.00	133	8	308	3104	0.0992268041237113	0.856162073821424	0.856162073821424	false	false	false	true
fe35a2e4-79b5-49e2-8b7c-8e1d8599b0b3	2026-09-14 12:15	2026-09-14 12:15	2026-09-14 12:15	SMR	SMR261009C00009500	call	9.5000	2026-10-09	0.3900	0.3600	0.3900	8.6650	26091.00	26091.00	0.00	669	8	754	196	3.8469387755102	0.76621166926672	0.76621166926672	false	false	false	true	false
b4927517-cf4d-4517-b9da-52830d6b3d1c	2026-09-14 12:15	2026-09-14 12:15	2026-09-14 12:15	SMR	SMR261009C00008500	call	8.5000	2026-10-09	0.7800	0.7200	0.7800	8.6650	19500.00	19500.00	0.00	250	6	570	261	2.18390804597701	0.763361479462508	0.763361479462508	false	false	false	true	false
39aaec2a-f731-4c15-9f80-6d4f191d6faa	2026-09-14 12:15	2026-09-14 12:15	2026-09-14 12:15	SMR	SMR261002C00008500	call	8.5000	2026-10-02	0.6800	0.6500	0.6800	8.6650	13192.00	13192.00	0.00	194	6	222	61	3.63934426229508	0.770821188368919	0.770821188368919	false	false	false	true	false
013171e4-95f3-44d1-a5fd-fb1cec4c176b	2026-09-14 12:15	2026-09-14 12:15	2026-09-14 12:15	SMR	SMR261002C00009500	call	9.5000	2026-10-02	0.3000	0.2900	0.3000	8.6700	18690.00	18690.00	0.00	623	21	702	438	1.6027397260274	0.779406436621987	0.777028641444368	false	false	false	true	false
0d7465c8-5dcf-440e-aaa5-a82148c83bcc	2026-09-14 11:46	2026-09-14 11:46	2026-09-14 11:46	SMR	SMR261009C00008000	call	8.0000	2026-10-09	1.0700	1.0000	1.0700	8.6650	10673.00	10673.00	0.00	100	5	226	12	18.8333333333333	0.774816262085501	0.762221436283133	false	false	false	true	false