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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = RH×

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

f089892a-f8c1-4cb8-86fa-400343d15c0c	2026-10-02 13:38	2026-10-02 13:38	2026-10-02 13:38	RH	RH261120P00120000	put	120.0000	2026-11-20	9.8000	9.6000	10.5000	120.8300	56840.00	4900.00	47040.00	58	7	209	215	0.972093023255814	0.601121718105465	0.601121718105465	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2280688333.00	2026-12-10	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T17:38:30.068984Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
8da3b757-5f91-4590-8e03-cf1745de2273	2026-10-02 13:37	2026-10-02 13:37	2026-10-02 13:37	RH	RH261120P00120000	put	120.0000	2026-11-20	9.9000	9.5000	10.6000	120.7700	78210.00	8910.00	40590.00	79	15	151	215	0.702325581395349	0.605367455757084	0.605367455757084	false	false	false
e1ad7c94-dd0b-4353-99a0-abe1a66a235a	2026-10-02 13:37	2026-10-02 13:37	2026-10-02 13:37	RH	RH261016P00130000	put	130.0000	2026-10-16	11.6000	11.6000	12.3000	120.3700	116000.00	0.00	116000.00	100	8	100	166	0.602409638554217	0.582353365031296	0.582353365031296	false	false	false
25cb1613-f27d-4f46-ae7d-597bf18e19e0	2026-10-02 13:37	2026-10-02 13:37	2026-10-02 13:37	RH	RH261120P00120000	put	120.0000	2026-11-20	10.0000	9.5000	10.5000	120.3700	70000.00	9000.00	30000.00	70	14	72	215	0.334883720930233	0.601056412839128	0.601056412839128	false	false	false
e358b685-6144-479d-955d-8f5a97084fbc	2026-10-02 13:03	2026-10-02 13:03	2026-10-02 13:03	RH	RH270115C00200000	call	200.0000	2027-01-15	1.9000	1.6500	2.1500	121.0200	11400.00	760.00	760.00	60	22	71	1347	0.052709725315516	0.647469316872443	0.647469316872443	false	false	false
89021053-dd19-4fa5-ba41-e788e11e261f	2026-10-02 10:41	2026-10-02 10:41	2026-10-02 10:41	RH	RH261016P00110000	put	110.0000	2026-10-16	1.3000	1.3000	1.5500	122.6700	89445.00	135.00	89310.00	688	49	719	496	1.44959677419355	0.605386268415601	0.605386268415601	false	false	false
c0eb9e06-ff05-474e-9ef7-8db1de6e1275	2026-10-01 10:09	2026-10-01 10:09	2026-10-01 10:09	RH	RH261120P00110000	put	110.0000	2026-11-20	6.5000	4.7000	7.0000	119.0000	52000.00	650.00	51350.00	80	5	80	585	0.136752136752137	0.641489215002409	0.641489215002409	false	false	false
d25d18e2-2fc5-4d51-8064-b7636d26e41b	2026-10-01 09:39	2026-10-01 09:39	2026-10-01 09:39	RH	RH261218P00120000	put	120.0000	2026-12-18	13.8000	12.4000	13.8000	122.0000	11040.00	11040.00	0.00	8	8	12	127	0.094488188976378	0.694490527477546	0.694490527477546	false	false	false
4972d058-fd6a-4829-839a-a39b7df8244c	2026-09-29 15:14	2026-09-29 15:13	2026-09-29 15:13	RH	RH270617P00120000	put	120.0000	2027-06-17	23.9000	23.2000	23.9000	123.2400	141010.00	141010.00	0.00	59	6	88	18	4.88888888888889	0.686105557282117	0.686105557282117	false	false	false
62724c91-2cee-4e3f-9a11-9337cf4f0706	2026-09-29 10:06	2026-09-29 10:06	2026-09-29 10:06	RH	RH261009C00130000	call	130.0000	2026-10-09	2.5000	1.5000	3.0000	122.3500	12500.00	12500.00	0.00	50	6	50	137	0.364963503649635	0.655080208851311	0.655080208851311	false	false	false
4490c994-0b00-4925-99d0-2f850e7c96df	2026-09-28 12:33	2026-09-28 12:32	2026-09-28 12:32	RH	RH261002C00130000	call	130.0000	2026-10-02	1.2500	0.9000	1.3000	122.7100	25240.00	3375.00	21865.00	202	10	218	72	3.02777777777778	0.725832631321279	0.725832631321279	false	false	false
bb912f0a-763e-4f26-ae4c-b4ab9e4ddf69	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	RH	RH261120C00135000	call	135.0000	2026-11-20	7.5000	5.9000	7.6000	124.1100	30000.00	23250.00	750.00	40	6	41	58	0.706896551724138	0.605785487437226	0.611216096726238	true	false	false
bd4d4b2b-114c-4e6e-9b72-f410e54851fb	2026-09-25 14:36	2026-09-25 14:36	2026-09-25 14:36	RH	RH290119P00065000	put	65.0000	2029-01-19	12.7000	12.7000	13.8000	124.1950	19050.00	0.00	19050.00	15	7	15	3	5	0.729371318359338	0.729371318359338	false	false	false
f4a5a531-5a86-4d59-8e73-5c922d2550e8	2026-09-25 14:18	2026-09-25 14:18	2026-09-25 14:18	RH	RH261009P00125000	put	125.0000	2026-10-09	6.2000	5.4000	6.3000	123.9500	27900.00	27900.00	0.00	45	17	47	9	5.22222222222222	0.593145377053039	0.593145377053039	false	false	false
a3e207b6-3f2e-43ef-8047-d04bb9f1abd9	2026-09-25 14:18	2026-09-25 14:18	2026-09-25 14:18	RH	RH261023C00125000	call	125.0000	2026-10-23	7.8000	6.3000	7.8000	123.9500	13260.00	13260.00	0.00	17	6	19	0	0	0.592590214156887	0.592590214156887	false	false	false
681baaf7-467e-4c2b-a6d6-8f0f448f55ce	2026-09-25 14:18	2026-09-25 14:18	2026-09-25 14:18	RH	RH261023P00130000	put	130.0000	2026-10-23	11.3000	10.2000	11.3000	123.9500	46330.00	46330.00	0.00	41	13	41	15	2.73333333333333	0.583640770184924	0.583640770184924	false	false	false
1cbd29ba-8bc9-427d-a38f-f990da69dcd8	2026-09-25 14:18	2026-09-25 14:18	2026-09-25 14:18	RH	RH261009P00124000	put	124.0000	2026-10-09	5.6000	4.3000	5.6000	123.9500	22960.00	22960.00	0.00	41	11	41	0	0	0.586130693439435	0.586130693439435	false	false	false
30a60509-782f-4606-8aa0-88b38630c24d	2026-09-24 15:45	2026-09-24 15:45	2026-09-24 15:45	RH	RH261016P00120000	put	120.0000	2026-10-16	6.3000	6.2000	6.3000	121.0200	28980.00	28980.00	0.00	46	17	51	121	0.421487603305785	0.588733065651594	0.588733065651594	false	false	false
6a869c50-7bc0-43f6-85fa-1dba978fdf10	2026-09-24 11:54	2026-09-24 11:54	2026-09-24 11:54	RH	RH261016P00115000	put	115.0000	2026-10-16	4.1000	3.9000	4.1000	121.5050	25400.00	25010.00	390.00	62	26	351	257	1.36575875486381	0.603409065977772	0.603409065977772	false	false	false
9f265738-0518-4eb3-b515-54b786658610	2026-09-24 11:54	2026-09-24 11:54	2026-09-24 11:54	RH	RH261016P00110000	put	110.0000	2026-10-16	2.5000	1.7500	2.5000	121.5880	43750.00	43750.00	0.00	175	13	179	204	0.877450980392157	0.606444769818017	0.606444769818017	false	false	false
6cf18cad-4c9b-4360-9e60-c53b0e185408	2026-09-24 11:54	2026-09-24 11:54	2026-09-24 11:54	RH	RH261120P00115000	put	115.0000	2026-11-20	7.9000	7.1000	7.9000	121.5880	25280.00	25280.00	0.00	32	10	66	372	0.17741935483871	0.603053252727808	0.603053252727808	false	false	false
f46db2fd-7483-45c1-96e7-954ed0dffb1e	2026-09-23 10:57	2026-09-23 10:57	2026-09-23 10:57	RH	RH260925C00126000	call	126.0000	2026-09-25	2.7000	2.7000	3.2000	126.0750	15390.00	0.00	15390.00	57	5	183	30	6.1	0.711731260071778	0.711731260071778	false	false	false
af8c80f8-5dc5-4a5e-ae25-f8c98bc3c136	2026-09-18 14:55	2026-09-18 14:54	2026-09-18 14:54	RH	RH260925P00122000	put	122.0000	2026-09-25	2.2000	2.2000	2.3000	126.0800	13420.00	0.00	8800.00	61	6	415	8	51.875	0.575340996031199	0.575340996031199	false	false	false
984df90f-8baf-4301-b3d9-5cc37d7c871c	2026-09-18 12:43	2026-09-18 12:43	2026-09-18 12:43	RH	RH261023P00100000	put	100.0000	2026-10-23	0.9000	0.9000	1.1500	127.1056	10800.00	0.00	10800.00	120	27	122	4	30.5	0.595708873061846	0.595708873061846	false	false	false
f8642cec-4253-431b-8556-0d51cf03980b	2026-09-18 11:12	2026-09-18 11:11	2026-09-18 11:11	RH	RH260918P00126000	put	126.0000	2026-09-18	0.5000	0.1500	0.5000	127.8250	16700.00	16700.00	0.00	334	19	369	414	0.891304347826087	1.01133640867289	1.01133640867289	false	false	false
45c6b160-277b-4d80-9038-52a85c70a88f	2026-09-18 10:07	2026-09-18 10:07	2026-09-18 10:07	RH	RH261218C00130000	call	130.0000	2026-12-18	16.0000	14.9000	16.0000	127.7750	46400.00	46400.00	0.00	29	5	29	82	0.353658536585366	0.646023902550493	0.646023902550493	true	false	false
e31e79ba-aaf6-414c-9198-6f9c3d0760c0	2026-09-17 11:27	2026-09-17 11:26	2026-09-17 11:26	RH	RH261009C00125000	call	125.0000	2026-10-09	9.2000	9.2000	9.6000	128.8000	39560.00	0.00	39560.00	43	11	46	1	46	0.561119675927949	0.561119675927949	false	false	false
bb3f9371-f6f3-45c2-bff8-a9c07af6d5e5	2026-09-16 13:59	2026-09-16 13:59	2026-09-16 13:59	RH	RH260918P00132000	put	132.0000	2026-09-18	3.6000	2.9000	3.6000	131.0000	11880.00	11880.00	0.00	33	9	34	5	6.8	0.810467245532224	0.810467245532224	false	false	false
58588fc8-bfa1-47d3-8b6e-e717c730ccdc	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	RH	RH261120P00130000	put	130.0000	2026-11-20	12.6000	12.3000	13.1000	129.9400	126000.00	3780.00	7560.00	100	10	101	163	0.619631901840491	0.599699425489529	0.599699425489529	false	false	false
858e1d1e-3677-4fa5-82f7-3118b91689cf	2026-09-16 11:03	2026-09-16 11:03	2026-09-16 11:03	RH	RH261120P00120000	put	120.0000	2026-11-20	8.2000	8.1000	9.0000	128.6800	53300.00	12300.00	41000.00	65	24	116	39	2.97435897435897	0.597141253577677	0.596130236355196	false	false	false
84a4525f-57f1-4f35-8a16-bde48bc990d7	2026-09-16 11:03	2026-09-16 11:03	2026-09-16 11:03	RH	RH261120P00120000	put	120.0000	2026-11-20	8.2000	8.1000	9.0000	128.7400	41000.00	0.00	41000.00	50	21	51	39	1.30769230769231	0.597141253577677	0.597141253577677	false	false	false
8ac62f7f-053d-4ce6-a774-e09446d4c164	2026-09-15 13:30	2026-09-15 13:29	2026-09-15 13:29	RH	RH261016P00115000	put	115.0000	2026-10-16	3.3000	3.3000	3.5000	128.4600	10230.00	0.00	8580.00	31	12	43	80	0.5375	0.602231315859025	0.602231315859025	false	false	false
f4e8c501-4c92-46b6-a6ba-29a9ced38edc	2026-09-15 09:46	2026-09-15 09:46	2026-09-15 09:46	RH	RH260918P00126000	put	126.0000	2026-09-18	0.8500	0.8500	2.3500	131.4700	28390.00	0.00	28390.00	334	17	334	71	4.70422535211268	0.596948621306336	0.596948621306336	false	false	false
1d4bd53f-dfe4-432f-8fc1-fd75efc0ba1e	2026-09-14 12:30	2026-09-14 12:29	2026-09-14 12:29	RH	RH261009P00135000	put	135.0000	2026-10-09	6.7000	6.1000	6.7000	139.0086	92460.00	92460.00	0.00	138	14	139	1	139	0.610538360158166	0.610538360158166	false	false	false
260f9dec-6683-4175-b05c-fb39d2aded3c	2026-09-14 11:51	2026-09-14 11:51	2026-09-14 11:51	RH	RH260925C00141000	call	141.0000	2026-09-25	4.3000	3.5000	4.3000	136.4300	23220.00	23220.00	0.00	54	15	54	2	27	0.65205251926129	0.65205251926129	false	false	false
0c3bd96c-de20-4c27-bbc1-bdcc0c6b3376	2026-09-14 11:51	2026-09-14 11:51	2026-09-14 11:51	RH	RH260925C00140000	call	140.0000	2026-09-25	4.6000	4.0000	4.6000	136.4300	22080.00	22080.00	0.00	48	8	59	9	6.55555555555556	0.643531976603969	0.643531976603969	false	false	false
691af47e-1a8c-4ae8-9004-ae4b36a507f8	2026-09-14 10:35	2026-09-14 10:35	2026-09-14 10:35	RH	RH261120C00135000	call	135.0000	2026-11-20	14.1000	10.7000	14.8000	134.1500	56400.00	5640.00	50760.00	40	8	40	3	13.3333333333333	0.613666578618939	0.613666578618939	false	false	false
f3c5424c-a309-4f2d-ac1b-6ecd4276c385	2026-09-11 14:43	2026-09-11 14:43	2026-09-11 14:43	RH	RH260918P00130000	put	130.0000	2026-09-18	2.5000	2.2500	2.5000	135.1300	14250.00	14250.00	0.00	57	21	565	695	0.81294964028777	0.635998395052201	0.635998395052201	true	false	false
321617f9-df60-4a9a-a66a-720e501ae684	2026-09-11 13:44	2026-09-11 13:44	2026-09-11 13:44	RH	RH260911C00135000	call	135.0000	2026-09-11	2.5000	1.5000	2.7000	137.2000	12500.00	12500.00	0.00	50	14	165	70	2.35714285714286	1.6673710179434	1.20662189012126	false	false	false
f67ddfeb-49e8-4058-a26e-434da1e784d3	2026-09-11 12:24	2026-09-11 12:24	2026-09-11 12:24	RH	RH261030C00125000	call	125.0000	2026-10-30	18.5000	15.5000	21.4000	135.8200	51800.00	49940.00	1860.00	28	10	28	0	0	0.626655170271594	0.632358867231022	true	false	false
94eea7ba-083d-4b8c-ac25-aab87ac7a909	2026-09-11 11:56	2026-09-11 11:56	2026-09-11 11:56	RH	RH260918C00140000	call	140.0000	2026-09-18	2.6000	2.2000	2.6000	133.0550	42120.00	42120.00	0.00	162	31	216	335	0.644776119402985	0.708300570188324	0.708300570188324	false	false	false
4b59ea54-9090-4d27-a7ed-c29939fc11cf	2026-09-11 11:51	2026-09-11 11:51	2026-09-11 11:51	RH	RH260918C00138000	call	138.0000	2026-09-18	2.4500	2.4500	3.6000	132.9150	36750.00	0.00	36750.00	150	11	151	1	151	0.603096848206275	0.603096848206275	false	false	false
ec5f9f27-a792-4d67-9a7e-d26bc08c459a	2026-09-11 11:07	2026-09-11 11:07	2026-09-11 11:07	RH	RH261016P00130000	put	130.0000	2026-10-16	8.2000	7.7000	8.2000	133.2600	82000.00	82000.00	0.00	100	6	114	32	3.5625	0.61505679480682	0.61505679480682	false	false	false
99d7ebc0-d167-4c3e-b122-5fddbcd19ee7	2026-09-11 10:53	2026-09-11 10:53	2026-09-11 10:53	RH	RH260911P00135000	put	135.0000	2026-09-11	2.4500	1.5500	2.4500	133.9350	13965.00	13965.00	0.00	57	23	492	347	1.4178674351585	1.44466331873049	1.44466331873049	true	false	false
afa753e5-cd2c-4987-83cc-fd722e431ae5	2026-09-11 10:53	2026-09-11 10:53	2026-09-11 10:53	RH	RH260911P00135000	put	135.0000	2026-09-11	2.2500	1.5500	2.8000	134.2400	13945.00	13725.00	220.00	62	25	435	347	1.2536023054755	1.42368015948459	1.384600887098	false	false	false
1b8285fa-f0e1-49cc-92a1-f6b9c281c710	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	RH	RH260911P00135000	put	135.0000	2026-09-11	2.0500	1.3000	3.7000	137.0000	10660.00	205.00	7175.00	52	15	53	347	0.152737752161383	2.24020394938932	2.24020394938932	false	false	false
93a2d1bf-49ee-4748-9223-a91a788c8a00	2026-09-10 15:50	2026-09-10 15:50	2026-09-10 15:50	RH	RH260911C00140000	call	140.0000	2026-09-11	5.0000	4.4000	5.0000	132.9150	37500.00	37500.00	0.00	75	5	214	69	3.10144927536232	2.82697902152999	2.82697902152999	false	false	false
19320d78-945b-41ed-b88f-4efc7c98b0b1	2026-09-10 15:02	2026-09-10 15:02	2026-09-10 15:02	RH	RH270917P00115000	put	115.0000	2027-09-17	23.7000	21.1000	24.2000	131.5200	16590.00	9480.00	7110.00	7	7	7	0	0	0.703131666186004	0.703131666186004	false	false	false
7571be79-b4c5-43c4-bca6-7946690963c2	2026-09-10 14:34	2026-09-10 14:34	2026-09-10 14:34	RH	RH260911P00149000	put	149.0000	2026-09-11	15.8000	13.2000	15.8000	137.4600	20540.00	20540.00	0.00	13	7	22	126	0.174603174603175	2.97129504262428	2.97129504262428	true	false	false
ba5ef5da-701b-4e76-915e-866cb8069b3d	2026-09-10 14:31	2026-09-10 14:31	2026-09-10 14:31	RH	RH260911C00146000	call	146.0000	2026-09-11	5.1000	4.2000	5.1000	137.4250	18870.00	18870.00	0.00	37	5	96	50	1.92	2.95061629427523	2.95061629427523	true	false	false