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:endpoint = /api/option-trades/flow-alerts×ticker = RSI×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

9c265ad3-1fe3-47a8-a8b1-4e2e038fbd3a	2026-08-18 15:17	2026-08-18 15:17	2026-08-18 15:17	RSI	RSI261016P00022500	put	22.5000	2026-10-16	0.8000	0.6000	0.8500	24.7700	24374.00	24374.00	0.00	305	30	305	163	1.87116564417178	0.460005624596269	0.463102695235082	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	3031722818.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
599aac25-e402-43f1-983d-9a32dd0fa54f	2026-08-18 15:29	2026-08-18 15:28	2026-08-18 15:28	RSI	RSI261016P00022500	put	22.5000	2026-10-16	0.8000	0.6000	0.8000	24.7900	15440.00	15440.00	0.00	193	21	498	163	3.05521472392638	0.464711308696179	0.464711308696179	true	false	false
f0c32d46-5a93-4c6c-98a9-48e5f5b31b83	2026-08-24 12:23	2026-08-24 12:23	2026-08-24 12:23	RSI	RSI260918C00025000	call	25.0000	2026-09-18	2.1000	1.8500	2.2500	26.2800	88402.00	66772.00	21630.00	421	64	433	1534	0.282268578878748	0.494140037298944	0.494140037298944	false	false	false
cd48d39f-d4e5-4324-a563-e56e15e6f024	2026-08-24 15:49	2026-08-24 15:49	2026-08-24 15:49	RSI	RSI260918C00025000	call	25.0000	2026-09-18	2.0500	1.8000	2.1500	26.2300	164183.00	146553.00	15170.00	801	53	1314	1534	0.856584093872229	0.487620335018717	0.487620335018717	false	false	false
deae614b-03e3-496f-83b7-532b715daea7	2026-08-26 09:42	2026-08-26 09:42	2026-08-26 09:42	RSI	RSI261016C00022500	call	22.5000	2026-10-16	4.1000	3.8000	4.1000	25.7600	11480.00	11480.00	0.00	28	8	28	91	0.307692307692308	0.549409532267615	0.549409532267615	false	false	false
b4a19526-ab26-4545-895d-fde1ee676ce8	2026-08-26 09:42	2026-08-26 09:42	2026-08-26 09:42	RSI	RSI260918C00025000	call	25.0000	2026-09-18	1.6600	1.4000	1.8500	25.7600	151625.00	118305.00	33320.00	913	13	913	2861	0.319119189094722	0.47132793488886	0.491780882327933	false	false	false
42f74e6c-61e0-40b5-8878-54f87938ab89	2026-08-26 12:44	2026-08-26 12:44	2026-08-26 12:44	RSI	RSI260918C00025000	call	25.0000	2026-09-18	1.8200	1.6500	2.5000	26.1650	334656.00	251586.00	83070.00	1835	47	3335	2861	1.16567633694512	0.493693953226978	0.464865290591856	false	false	false
75933b07-20e4-42f0-884d-348140d5a99c	2026-08-27 09:48	2026-08-27 09:48	2026-08-27 09:48	RSI	RSI260918C00025000	call	25.0000	2026-09-18	1.9000	1.6500	2.0000	26.0500	110006.00	48066.00	26790.00	579	9	581	6301	0.0922075860974449	0.509209516889809	0.509209516889809	false	false	false
41f48b36-2fa3-409d-9bbd-e8959a8f2c2b	2026-08-27 10:38	2026-08-27 10:38	2026-08-27 10:38	RSI	RSI260918C00025000	call	25.0000	2026-09-18	1.9500	1.5500	2.0000	26.1800	194976.00	194976.00	0.00	1000	60	2006	6301	0.318362164735756	0.510750440454189	0.493371977162585	false	false	false
0e0b6482-49fc-4f4d-ac84-0e8c06ce5201	2026-08-27 12:08	2026-08-27 12:08	2026-08-27 12:08	RSI	RSI260918C00025000	call	25.0000	2026-09-18	1.9500	1.6000	2.0000	26.1100	62984.00	49139.00	11505.00	323	40	2339	6301	0.371210918901762	0.517858584196454	0.513602613882188	false	false	false
3463a4a0-7fd1-403e-87be-63e0be34d387	2026-08-27 12:08	2026-08-27 12:08	2026-08-27 12:08	RSI	RSI260918C00025000	call	25.0000	2026-09-18	2.0000	2.0000	2.0500	26.1800	40000.00	0.00	10000.00	200	9	2616	6301	0.4151721948897	0.514978260705988	0.514978260705988	false	false	false
2052111b-532b-49ad-9224-3fc73e9b6ede	2026-08-28 09:57	2026-08-28 09:57	2026-08-28 09:57	RSI	RSI261016C00025000	call	25.0000	2026-10-16	2.7500	2.3000	2.8000	26.5400	206250.00	7150.00	199100.00	750	16	2000	309	6.47249190938511	0.49456969782635	0.478301935621036	true	false	false
6b8521c0-acdd-49e5-bde5-e9de27842cdb	2026-08-28 13:12	2026-08-28 13:12	2026-08-28 13:12	RSI	RSI260918C00025000	call	25.0000	2026-09-18	2.0500	1.7000	2.1000	26.3000	176094.00	148829.00	27265.00	859	30	863	8893	0.0970426177892725	0.516727425457077	0.513650210895864	false	false	false
dcbd709e-6ed0-419d-965c-4d8c44d3eee7	2026-08-28 13:43	2026-08-28 13:43	2026-08-28 13:43	RSI	RSI260918C00025000	call	25.0000	2026-09-18	2.4000	2.0500	2.4500	26.6700	87119.00	76319.00	10800.00	363	38	1226	8893	0.137861239176881	0.55462418954664	0.55462418954664	false	false	false
6c2f4141-a4cd-4c47-83d2-abc0fc0ed2dd	2026-08-28 14:18	2026-08-28 14:18	2026-08-28 14:18	RSI	RSI261016C00025000	call	25.0000	2026-10-16	3.1000	2.7500	3.2000	27.0400	549627.00	319917.00	229710.00	1773	44	3805	309	12.3139158576052	0.499794942949725	0.478991000405929	false	false	false
bc30ddd6-e9d7-4ddc-8998-4f4162256f0f	2026-08-28 14:34	2026-08-28 14:33	2026-08-28 14:33	RSI	RSI261016C00025000	call	25.0000	2026-10-16	3.0000	2.7000	3.1000	26.8900	19800.00	19800.00	0.00	66	7	5102	309	16.5113268608414	0.480814378032334	0.480814378032334	false	false	false
eb95de28-1907-4cc2-bfb2-ab7951a352f8	2026-08-28 14:34	2026-08-28 14:34	2026-08-28 14:34	RSI	RSI261016C00025000	call	25.0000	2026-10-16	3.1000	2.8000	3.2000	27.0400	465000.00	59830.00	390600.00	1500	27	6602	309	21.3656957928803	0.489480514579643	0.478991000405929	true	false	false
9ac3037c-a736-43df-b2e0-383ab722bb27	2026-08-28 14:41	2026-08-28 14:41	2026-08-28 14:41	RSI	RSI261016C00025000	call	25.0000	2026-10-16	2.9000	2.7000	3.0000	26.7500	362500.00	139490.00	184150.00	1250	33	7852	309	25.411003236246	0.484117190575372	0.480115276060184	true	false	false
87055ea3-139c-41c7-ad89-f1631a098d12	2026-08-28 15:52	2026-08-28 15:52	2026-08-28 15:52	RSI	RSI261016C00025000	call	25.0000	2026-10-16	2.6500	2.5500	2.7000	26.2600	745180.00	522050.00	223130.00	2812	30	10666	309	34.5177993527508	0.502595205226503	0.502595205226503	false	false	false
e8d9f6de-bae4-4da0-9a6c-e8b31255ef93	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	RSI	RSI261016C00025000	call	25.0000	2026-10-16	2.6000	2.2000	2.8000	26.1300	262339.00	262079.00	260.00	1009	38	1030	10769	0.0956449066765716	0.529515282035976	0.529515282035976	false	false	false
7c131890-284b-41e3-a230-b1a54f33c55c	2026-08-31 10:02	2026-08-31 10:02	2026-08-31 10:02	RSI	RSI261016C00025000	call	25.0000	2026-10-16	2.6000	2.6000	2.9000	26.3150	127660.00	0.00	127660.00	491	6	1521	10769	0.141238740830161	0.494795640054676	0.494795640054676	true	false	false
eb1c739a-3cf5-44aa-9109-0e53ca116bae	2026-08-31 10:13	2026-08-31 10:13	2026-08-31 10:13	RSI	RSI261016C00025000	call	25.0000	2026-10-16	2.7000	2.2000	2.8500	26.3600	203580.00	203580.00	0.00	754	30	2275	10769	0.211254526882719	0.515297856090487	0.515297856090487	false	false	false
4f50a467-239f-4437-b3fc-d3c230abf8cc	2026-09-01 10:23	2026-09-01 10:23	2026-09-01 10:23	RSI	RSI261016C00025000	call	25.0000	2026-10-16	2.2500	1.9000	2.3000	25.6800	574200.00	540225.00	33975.00	2552	34	2558	13552	0.188754427390791	0.515405017387172	0.515405017387172	false	false	false
af52d64f-dbe4-4f53-b8bd-2d14f9b319a0	2026-09-02 10:04	2026-09-02 10:04	2026-09-02 10:04	RSI	RSI261016C00025000	call	25.0000	2026-10-16	2.9000	2.7500	3.0000	26.7600	142680.00	42340.00	99470.00	492	14	609	16550	0.036797583081571	0.506576139323352	0.506576139323352	false	false	false
f60dd86a-2cd0-4098-95a0-8c1f148940a8	2026-09-02 14:42	2026-09-02 14:42	2026-09-02 14:42	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.5000	3.4000	3.7000	27.0100	14700.00	0.00	14700.00	42	8	172	51825	0.00331886155330439	0.435133971572527	0.435133971572527	false	false	false
6fc28f5d-b02b-4af0-9dc5-1e6e9bbb5612	2026-09-02 14:45	2026-09-02 14:45	2026-09-02 14:45	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.5000	3.5000	3.7000	27.0500	29750.00	0.00	29750.00	85	10	337	51825	0.00650265315967197	0.444184610392622	0.444184610392622	false	false	false
9398c112-2530-4c35-84e0-d69778fced76	2026-09-02 14:49	2026-09-02 14:49	2026-09-02 14:49	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.5000	3.5000	3.7000	27.0000	29750.00	0.00	29750.00	85	10	472	51825	0.00910757356488181	0.432831755148027	0.432831755148027	false	false	false
b86236cb-94fa-425d-b881-abb50e1cb537	2026-09-03 09:46	2026-09-03 09:46	2026-09-03 09:46	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.9000	3.6000	4.0000	26.5700	39000.00	23400.00	7800.00	100	9	107	49455	0.0021635830553028	0.463400787792588	0.463400787792588	false	false	false
a0262df3-e504-4b21-b6f3-1b36861f34f1	2026-09-03 09:57	2026-09-03 09:57	2026-09-03 09:57	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.9000	3.9000	4.1000	26.5650	14430.00	0.00	14430.00	37	17	167	49455	0.00337680719846325	0.462129828260056	0.462129828260056	true	false	false
2b1532fb-a878-4a99-91dc-905e118143a5	2026-09-03 09:57	2026-09-03 09:57	2026-09-03 09:57	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.9900	3.7000	4.0000	26.5650	45088.00	45088.00	0.00	113	20	280	49455	0.0056617126680821	0.468937895685419	0.495684093097989	false	false	false
da1069ba-7a55-4bbc-9eef-0f2531735b05	2026-09-03 12:45	2026-09-03 12:45	2026-09-03 12:45	RSI	RSI260918C00025000	call	25.0000	2026-09-18	2.3500	1.9500	2.4000	26.7500	226540.00	208445.00	17860.00	964	44	970	10154	0.0955288556233996	0.602476144807831	0.602476144807831	false	false	false
9e229299-4ea9-42b7-8739-75c1c5c0fecd	2026-09-03 12:46	2026-09-03 12:46	2026-09-03 12:46	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.5900	3.3000	3.6000	27.0950	89829.00	89829.00	0.00	250	22	1092	49455	0.0220806794055202	0.460289448295363	0.488027126015307	false	false	false
8643e85f-f8d9-4ab5-9ee3-e83a650a11fa	2026-09-03 12:47	2026-09-03 12:46	2026-09-03 12:46	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.6000	3.6000	3.7000	27.0000	19440.00	0.00	18000.00	54	19	1146	49455	0.0231725811343646	0.467447681236078	0.467447681236078	false	false	false
66f295a1-292b-4467-8b08-c69ed3fb29a7	2026-09-03 12:49	2026-09-03 12:49	2026-09-03 12:49	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.6900	3.4000	3.7000	26.9500	45398.00	45398.00	0.00	123	25	1269	49455	0.0256596906278435	0.462513499474276	0.487721842077807	false	false	false
1345d6b0-e5a2-4ddd-bd42-884d649066be	2026-09-03 13:57	2026-09-03 13:57	2026-09-03 13:57	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.7000	3.7000	3.8000	26.8600	23680.00	0.00	21460.00	64	24	1699	49455	0.0343544636538267	0.467457456943712	0.467457456943712	false	false	false
d1467c4b-bedb-4b99-a328-5672f420022f	2026-09-03 13:58	2026-09-03 13:58	2026-09-03 13:58	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.7000	3.7000	3.8000	26.8200	20350.00	0.00	19980.00	55	16	1754	49455	0.0354665857850571	0.458062646905916	0.458062646905916	false	false	false
4af01878-6992-44b2-a873-888c459e9b22	2026-09-03 14:00	2026-09-03 14:00	2026-09-03 14:00	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.8000	3.6000	3.9000	26.7400	11400.00	7980.00	2280.00	30	6	1784	49455	0.0360731978566373	0.471753594281897	0.471753594281897	false	false	false
75f35250-5e46-4d9d-8620-459aab3df9ef	2026-09-03 14:07	2026-09-03 14:07	2026-09-03 14:07	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.8000	3.5000	3.9000	26.7050	47120.00	8360.00	28500.00	124	44	1976	49455	0.0399555151147508	0.463323219289196	0.463323219289196	false	false	false
0b1c110b-20d5-4e79-907a-126f2cb00f88	2026-09-03 14:26	2026-09-03 14:26	2026-09-03 14:26	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.8000	3.8000	3.9000	26.7050	27740.00	0.00	15580.00	73	28	2185	49455	0.0441815792134263	0.463323219289196	0.463323219289196	false	false	false
9dbc1b7c-9e3e-4527-88e9-4b3a14c04d5b	2026-09-03 14:34	2026-09-03 14:34	2026-09-03 14:34	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.8000	3.8000	3.9000	26.7150	10640.00	0.00	10640.00	28	14	2263	49455	0.0457587705995349	0.465753432930566	0.465753432930566	false	false	false
6918cfad-3c3c-43cb-be14-494ecb87ec99	2026-09-03 14:34	2026-09-03 14:34	2026-09-03 14:34	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.9000	3.7000	3.9000	26.6200	67080.00	67080.00	0.00	172	19	2435	49455	0.0492366798099282	0.48548727030725	0.475847896766921	false	false	false
c3d5817b-ec44-4c65-add6-f36908fce148	2026-09-03 14:46	2026-09-03 14:46	2026-09-03 14:46	RSI	RSI261016C00025000	call	25.0000	2026-10-16	2.8000	2.8000	2.9000	26.5900	169960.00	0.00	169680.00	607	6	613	18046	0.0339687465366286	0.518918818070578	0.518918818070578	true	false	false
e9c4f637-0475-4fd3-919e-0f58e0921b49	2026-09-03 14:46	2026-09-03 14:46	2026-09-03 14:46	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.8000	3.5000	3.9000	26.7550	34580.00	30020.00	4560.00	91	8	2622	49455	0.0530178950561116	0.475303974376245	0.475303974376245	false	false	false
b76e78b1-e3cc-431b-8703-2b9ce8ec57c8	2026-09-03 14:48	2026-09-03 14:48	2026-09-03 14:48	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.8000	3.6000	3.9000	26.7700	30400.00	18240.00	6840.00	80	27	2702	49455	0.0546355272469922	0.479982385702878	0.478818590855157	true	false	false
49311e19-3518-4c60-b9a3-49397baf1ada	2026-09-03 14:52	2026-09-03 14:52	2026-09-03 14:52	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.8000	3.6000	3.9000	26.7400	28500.00	16720.00	5700.00	75	9	2812	49455	0.056859771509453	0.478818590855157	0.471753594281897	false	false	false
95de5d37-6aea-4c5c-9881-c39ac52e89df	2026-09-03 14:56	2026-09-03 14:56	2026-09-03 14:56	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.8000	3.6000	3.9000	26.7700	30400.00	18240.00	6080.00	80	9	2892	49455	0.0584774037003336	0.478818590855157	0.478818590855157	false	false	false
3c97b3d3-e3cd-4685-b5b2-dabdfda638ba	2026-09-03 15:03	2026-09-03 15:03	2026-09-03 15:03	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.7000	3.7000	3.8000	26.8450	34410.00	0.00	34410.00	93	36	3010	49455	0.0608634111818825	0.463964599215704	0.463964599215704	true	false	false
40c95e0a-64eb-4047-80a3-b43f9f35c80c	2026-09-03 15:11	2026-09-03 15:11	2026-09-03 15:11	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.7000	3.5000	3.8000	26.8300	28120.00	13320.00	11840.00	76	6	3093	49455	0.0625417045799211	0.468613960043948	0.460435784886919	false	false	false
4572cd43-4c0b-4d46-8752-83d90d4f794b	2026-09-03 15:41	2026-09-03 15:41	2026-09-03 15:41	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.7000	3.5000	3.8000	26.8400	67710.00	67710.00	0.00	183	7	3536	49455	0.0714993428369225	0.469766643102067	0.462792383674756	false	false	false
6123dd18-e8fc-46cd-bf57-b6c0e15e7c51	2026-09-03 15:42	2026-09-03 15:42	2026-09-03 15:42	RSI	RSI261016P00030000	put	30.0000	2026-10-16	3.8000	3.6000	3.9000	26.7600	269037.00	261437.00	3040.00	708	67	4250	49455	0.0859367101405318	0.490290202698884	0.476479427979643	false	false	false