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:alert_rule = RepeatedHits×ticker = SM×

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

e0c46dd3-8d3a-441c-ad6b-815a7650940f	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	SM	SM261120C00035000	call	35.0000	2026-11-20	2.7500	2.7500	2.9000	34.5300	17875.00	0.00	17875.00	65	6	84	756	0.111111111111111	0.516951235920858	0.516951235920858	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	8068009987.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T17:54:09.846029Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
fa3a543f-6481-4957-b37f-555e2c101a84	2026-09-21 13:18	2026-09-21 13:18	2026-09-21 13:18	SM	SM261120P00037500	put	37.5000	2026-11-20	4.4000	4.3000	4.5000	34.0000	13640.00	5720.00	7920.00	31	7	53	184	0.28804347826087	0.529361281901025	0.53196438027659	true	false	false	true
1f1a528e-08c1-48c7-af69-428e6916ebc9	2026-09-17 13:11	2026-09-17 13:11	2026-09-17 13:11	SM	SM260918C00035000	call	35.0000	2026-09-18	2.5500	2.1000	2.5500	37.3700	12750.00	12750.00	0.00	50	5	149	1069	0.139382600561272	1.2060028705777	1.2060028705777	false	false	false	true
5757761a-9f8d-464d-ad9d-42be01884c15	2026-09-15 11:14	2026-09-15 11:14	2026-09-15 11:14	SM	SM261016C00040000	call	40.0000	2026-10-16	2.6000	2.6000	2.9500	40.6400	13001.00	0.00	13001.00	50	9	261	610	0.427868852459016	0.468181445282955	0.468181445282955	true	false	false	true
1758ad37-dc1d-4189-b0ef-7832500d70e9	2026-09-15 11:03	2026-09-15 11:03	2026-09-15 11:03	SM	SM270219C00035000	call	35.0000	2027-02-19	7.7000	7.4000	9.1000	40.0000	77000.00	0.00	77000.00	100	7	100	780	0.128205128205128	0.40368949078881	0.40368949078881	false	true	false	true
b1e3e571-8898-465e-9e85-8cb19cf205b0	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	SM	SM260918C00037500	call	37.5000	2026-09-18	1.7000	1.7000	2.2000	38.9450	48110.00	0.00	48110.00	283	13	514	1811	0.283821093318608	0.473346043658303	0.473346043658303	false	false	false	true
a8f8e74e-6315-46c7-83b6-c8d622c95261	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	SM	SM261120P00040000	put	40.0000	2026-11-20	4.0000	3.8000	4.0000	38.9450	36800.00	36800.00	0.00	92	7	127	92	1.3804347826087	0.537097913940381	0.537097913940381	false	false	false	true
d0486ac7-ba76-4ed2-afd0-d441c72e548a	2026-09-14 13:26	2026-09-14 13:26	2026-09-14 13:26	SM	SM270115C00040000	call	40.0000	2027-01-15	4.4000	4.2000	4.5000	39.1800	10560.00	3960.00	0.00	24	7	38	495	0.0767676767676768	0.49961918777851	0.49961918777851	false	false	false	true
28efa5d9-8b4f-43c2-988e-ae02f4e744af	2026-09-09 15:43	2026-09-09 15:43	2026-09-09 15:43	SM	SM260918C00040000	call	40.0000	2026-09-18	0.5500	0.5500	0.6000	38.0190	13750.00	0.00	13750.00	250	12	1620	3437	0.471341286005237	0.531089776348499	0.531089776348499	false	false	false	true
a386c736-b6fb-46bc-a0cd-e0a1f4342537	2026-09-09 14:21	2026-09-09 14:21	2026-09-09 14:21	SM	SM260918C00037500	call	37.5000	2026-09-18	1.6500	1.6500	1.7000	38.1000	67650.00	0.00	27060.00	410	5	1622	2248	0.72153024911032	0.54764888657821	0.552781467205636	false	false	false	true
6f59ba40-ec07-42e3-878c-1e809d219a83	2026-09-09 14:18	2026-09-09 14:18	2026-09-09 14:18	SM	SM260918C00037500	call	37.5000	2026-09-18	1.6500	1.6500	1.7000	38.2000	35475.00	0.00	35475.00	215	16	1212	2248	0.53914590747331	0.526785198902632	0.526785198902632	false	false	false	true
03131589-7a6c-4019-adea-4706ed146b06	2026-09-09 11:48	2026-09-09 11:47	2026-09-09 11:47	SM	SM260918C00037500	call	37.5000	2026-09-18	1.7000	1.7000	1.8000	38.1900	42500.00	0.00	42500.00	250	10	347	2248	0.154359430604982	0.551090103562351	0.551090103562351	false	false	false	true
7a7b53c4-2834-4b2e-a21e-cc984358975c	2026-09-08 14:49	2026-09-08 14:49	2026-09-08 14:49	SM	SM260918C00040000	call	40.0000	2026-09-18	0.8500	0.7000	0.8500	38.2793	13685.00	13685.00	0.00	161	17	2172	1371	1.58424507658643	0.603493110370603	0.599122083991068	false	false	false	true
4206f189-469a-4991-bd72-7775ab2c04d0	2026-09-08 14:24	2026-09-08 14:24	2026-09-08 14:24	SM	SM260918C00037500	call	37.5000	2026-09-18	1.7000	1.5500	1.7000	38.0300	85000.00	85000.00	0.00	500	11	1272	1035	1.22898550724638	0.560759512367916	0.560759512367916	false	false	false	true
5e9cb043-136c-4be0-a7ed-dbee8fdf78ae	2026-08-27 13:16	2026-08-27 13:16	2026-08-27 13:16	SM	SM270219P00030000	put	30.0000	2027-02-19	2.0000	2.0000	2.5500	36.1350	20000.00	0.00	20000.00	100	7	200	99	2.02020202020202	0.510177895634217	0.510177895634217	false	false	false	true
1e1cb051-12c6-434a-8edd-98c77778d4a0	2026-08-24 15:28	2026-08-24 15:28	2026-08-24 15:28	SM	SM261016C00035000	call	35.0000	2026-10-16	3.7000	3.4000	3.7000	36.5200	25898.00	25898.00	0.00	70	7	90	141	0.638297872340426	0.509890926097205	0.509890926097205	false	false	false	true
9b5664e1-7b55-4c73-a079-e63e2ce1bb47	2026-08-24 13:54	2026-08-24 13:54	2026-08-24 13:54	SM	SM261120C00050000	call	50.0000	2026-11-20	0.5000	0.4500	0.7500	36.4200	53210.00	7000.00	46210.00	1061	39	1061	309	3.4336569579288	0.494152430975147	0.494152430975147	false	false	false	true
ec36e332-9810-43ac-b355-e4e10f5013d3	2026-08-21 12:15	2026-08-21 12:15	2026-08-21 12:15	SM	SM260918P00040000	put	40.0000	2026-09-18	3.7000	3.6000	4.0000	37.3000	19242.00	372.00	18870.00	52	7	52	164	0.317073170731707	0.508958232354353	0.514218841317684	false	false	false	true
be306856-584e-4ea8-a5df-a1422e68201e	2026-08-20 15:11	2026-08-20 15:11	2026-08-20 15:11	SM	SM260918P00042500	put	42.5000	2026-09-18	5.7000	5.3000	5.7000	37.4200	10830.00	10830.00	0.00	19	9	42	1	42	0.552687454904975	0.552687454904975	false	false	false	true	false
29e02054-8a4a-4510-968e-df9666409098	2026-08-20 09:40	2026-08-20 09:40	2026-08-20 09:40	SM	SM260918C00040000	call	40.0000	2026-09-18	1.2500	1.2500	1.3500	37.8550	20375.00	0.00	20375.00	163	10	505	843	0.599051008303677	0.483202342110605	0.483202342110605	false	false	false	true
fe68094a-9df4-4f72-97b7-344797bb2eec	2026-08-19 12:17	2026-08-19 12:17	2026-08-19 12:17	SM	SM260918P00040000	put	40.0000	2026-09-18	4.5000	4.5000	4.8000	36.1800	10800.00	0.00	10800.00	24	5	24	129	0.186046511627907	0.499605752228101	0.499605752228101	false	false	false	true
800a7aa9-6d9e-453f-a82b-bdf949ea0c9a	2026-08-19 10:13	2026-08-19 10:13	2026-08-19 10:13	SM	SM261120C00040000	call	40.0000	2026-11-20	2.3000	2.1500	2.4000	36.0000	11500.00	11500.00	0.00	50	6	85	1007	0.0844091360476663	0.505729423840639	0.505729423840639	false	false	false	true
6544a9e3-b5ef-408d-9355-0cc05379abc2	2026-08-17 13:25	2026-08-17 13:25	2026-08-17 13:25	SM	SM270115C00035000	call	35.0000	2027-01-15	4.4000	4.2000	4.4000	34.5300	11438.00	11438.00	0.00	26	5	79	310	0.254838709677419	0.493848527294033	0.493848527294033	false	false	false	true
70aadf05-0ad0-42cc-a94f-86a23bb99d81	2026-08-17 11:58	2026-08-17 11:58	2026-08-17 11:58	SM	SM260918P00037500	put	37.5000	2026-09-18	4.1000	4.1000	4.6000	34.1850	13949.00	0.00	13949.00	34	9	34	166	0.204819277108434	0.506406933396494	0.506406933396494	false	false	false	true