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 = ETHA×

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

cd714c93-68de-4032-9a8f-12b7bb0398a4	2026-09-18 09:39	2026-09-18 09:38	2026-09-18 09:38	ETHA	ETHA261016C00021000	call	21.0000	2026-10-16	0.3900	0.3600	0.4100	18.9800	58535.00	58497.00	38.00	1501	48	1746	11030	0.158295557570263	0.501339923996981	0.501339923996981	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	6944643005.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T13:40:42.153741Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
dfaf87c0-0a2e-4528-b88d-ae0eeb570125	2026-09-18 09:38	2026-09-18 09:38	2026-09-18 09:38	ETHA	ETHA261016C00022000	call	22.0000	2026-10-16	0.2400	0.2200	0.2400	18.9600	47040.00	47040.00	0.00	1960	29	2026	41254	0.0491103892955835	0.521043039540154	0.521043039540154	false	false	false
9536ebc3-ee2d-4244-b2f6-46d591c895dd	2026-09-18 09:36	2026-09-18 09:36	2026-09-18 09:36	ETHA	ETHA261218C00019000	call	19.0000	2026-12-18	2.0600	2.0300	2.0600	18.9250	206000.00	206000.00	0.00	1000	6	1256	6630	0.189441930618401	0.536324283806596	0.536324283806596	false	false	false
5536d64c-b799-463f-825a-850ea3823f3c	2026-09-18 09:31	2026-09-18 09:31	2026-09-18 09:31	ETHA	ETHA261030C00022000	call	22.0000	2026-10-30	0.3900	0.2700	0.4000	18.9400	49413.00	38805.00	10608.00	1267	10	1277	1082	1.18022181146026	0.508450376166399	0.508450376166399	true	false	false
f0d91436-6c2b-4f98-a574-c44e274997ba	2026-09-17 15:48	2026-09-17 15:47	2026-09-17 15:47	ETHA	ETHA261120C00018000	call	18.0000	2026-11-20	1.8500	1.8500	1.8700	18.4400	10915.00	0.00	10915.00	59	13	1794	13	138	0.511506533791436	0.511506533791436	false	false	false	true
26556b5c-6a21-4e68-b653-f44fe508a5d9	2026-09-17 15:24	2026-09-17 15:24	2026-09-17 15:24	ETHA	ETHA260925C00018500	call	18.5000	2026-09-25	0.4900	0.4800	0.5000	18.5001	76146.00	0.00	65268.00	1554	25	2617	11275	0.232106430155211	0.441290715388404	0.441290715388404	false	false	false
bf026db7-666b-4ed5-84ff-d57e6a097858	2026-09-17 15:19	2026-09-17 15:19	2026-09-17 15:19	ETHA	ETHA261218C00019000	call	19.0000	2026-12-18	1.8000	1.8000	1.8200	18.4650	100620.00	0.00	100620.00	559	7	1844	6393	0.288440481776944	0.527321321049571	0.527321321049571	false	false	false
9d7b76f6-e02e-42fc-bb74-706235807728	2026-09-17 15:19	2026-09-17 15:19	2026-09-17 15:19	ETHA	ETHA261218C00019000	call	19.0000	2026-12-18	1.8000	1.8000	1.8200	18.4650	22320.00	0.00	22320.00	124	15	2085	6393	0.326137963397466	0.527321321049571	0.527321321049571	false	false	false
c6dd5427-b3e1-4eee-b696-0f1c4223a83a	2026-09-17 15:08	2026-09-17 15:08	2026-09-17 15:08	ETHA	ETHA261016C00023000	call	23.0000	2026-10-16	0.1200	0.1200	0.1300	18.5050	14388.00	0.00	14388.00	1199	15	1414	7561	0.187012299960323	0.548352434223144	0.548352434223144	false	false	false
24795a8b-d1ad-4ee2-bf21-f319682fb2c5	2026-09-17 14:36	2026-09-17 14:36	2026-09-17 14:36	ETHA	ETHA260925C00018500	call	18.5000	2026-09-25	0.5000	0.5000	0.5200	18.5101	24650.00	0.00	24650.00	493	8	966	11275	0.0856762749445676	0.445687748226815	0.445687748226815	false	false	false
13059202-2e64-4913-8343-389de6a3d0b3	2026-09-17 14:36	2026-09-17 14:36	2026-09-17 14:36	ETHA	ETHA260925C00019000	call	19.0000	2026-09-25	0.3000	0.2900	0.3100	18.5101	37800.00	0.00	36570.00	1260	24	6898	5404	1.27646188008882	0.453100234761637	0.453100234761637	false	false	false
93255d0b-5e93-4d48-8770-4b9fc2f014f2	2026-09-17 14:31	2026-09-17 14:31	2026-09-17 14:31	ETHA	ETHA261218C00020000	call	20.0000	2026-12-18	1.4700	1.4600	1.4800	18.5301	45717.00	0.00	43365.00	311	6	999	17085	0.0584723441615452	0.532671440173696	0.532671440173696	false	false	false
c6a96881-2cfa-4350-b872-3f3975ed235f	2026-09-17 14:02	2026-09-17 14:02	2026-09-17 14:02	ETHA	ETHA270115P00020000	put	20.0000	2027-01-15	2.9600	2.9400	2.9600	18.5550	19832.00	19832.00	0.00	67	11	561	5961	0.0941117262204328	0.534334059142835	0.534334059142835	false	false	false	true
4248b594-b4fc-484c-91ba-26d6056f4641	2026-09-17 14:02	2026-09-17 14:02	2026-09-17 14:02	ETHA	ETHA270115P00019000	put	19.0000	2027-01-15	2.3500	2.3300	2.3500	18.5550	188235.00	188235.00	0.00	801	15	1907	668	2.85479041916168	0.531416036325474	0.531416036325474	false	false	false	true
a4211a32-5e09-42d7-88a1-394f26335492	2026-09-17 13:45	2026-09-17 13:45	2026-09-17 13:45	ETHA	ETHA260925C00019000	call	19.0000	2026-09-25	0.3300	0.3300	0.3400	18.5750	16764.00	0.00	16764.00	508	21	5467	5404	1.01165803108808	0.458438334367094	0.458438334367094	false	false	false
332cca7e-8695-488d-8e76-a8ccde09bb7b	2026-09-17 13:05	2026-09-17 13:05	2026-09-17 13:05	ETHA	ETHA261016C00021000	call	21.0000	2026-10-16	0.3300	0.3100	0.3300	18.6600	33000.00	33000.00	0.00	1000	30	4897	5052	0.969319081551861	0.503101467083536	0.503101467083536	true	false	false
6125c3a4-2eac-45e5-a552-db7b0039a5ac	2026-09-17 13:05	2026-09-17 13:04	2026-09-17 13:04	ETHA	ETHA261016C00020000	call	20.0000	2026-10-16	0.5400	0.5100	0.5400	18.6650	54000.00	54000.00	0.00	1000	28	7048	54021	0.130467781048111	0.48731776355981	0.48731776355981	true	false	false
9b80cc3c-1330-4a7f-9972-fb5f1aba13a4	2026-09-17 13:04	2026-09-17 13:03	2026-09-17 13:03	ETHA	ETHA260925C00018500	call	18.5000	2026-09-25	0.6000	0.5800	0.6000	18.6499	18000.00	18000.00	0.00	300	8	382	11275	0.033880266075388	0.46768405598125	0.46768405598125	false	false	false	true
356560f6-952b-4ab6-9521-0ceaaa00b0c5	2026-09-17 13:03	2026-09-17 13:03	2026-09-17 13:03	ETHA	ETHA260925C00019000	call	19.0000	2026-09-25	0.3600	0.3600	0.3700	18.6499	48816.00	0.00	48816.00	1356	19	4442	5404	0.821983715766099	0.458571090631375	0.458571090631375	false	false	false
9ab8eada-7101-4f18-b960-a30157079983	2026-09-17 12:58	2026-09-17 12:58	2026-09-17 12:58	ETHA	ETHA261016P00017000	put	17.0000	2026-10-16	0.3800	0.3800	0.4000	18.6100	47918.00	0.00	47918.00	1261	13	2053	25378	0.0808968397824888	0.500519727769455	0.500519727769455	true	false	false
0b4f4e65-6ecd-4d5a-a320-86eea9645e7c	2026-09-17 12:34	2026-09-17 12:34	2026-09-17 12:34	ETHA	ETHA280616C00025000	call	25.0000	2028-06-16	4.5500	4.5500	4.7000	18.5123	127855.00	0.00	127855.00	281	11	299	1543	0.193778353856124	0.617745534543398	0.617745534543398	false	false	false
7a405877-f897-4201-8218-3fbf077bfef5	2026-09-17 12:28	2026-09-17 12:28	2026-09-17 12:28	ETHA	ETHA260925C00019500	call	19.5000	2026-09-25	0.2100	0.2000	0.2300	18.6050	90720.00	0.00	89691.00	4320	33	8883	2411	3.68436333471589	0.479446232572971	0.479446232572971	false	false	false
6fc3325d-d11a-43dd-8e5d-b75e552fc111	2026-09-17 11:50	2026-09-17 11:50	2026-09-17 11:50	ETHA	ETHA261120C00018000	call	18.0000	2026-11-20	1.9900	1.9700	2.0000	18.5961	69687.00	69687.00	0.00	350	13	1531	13	117.769230769231	0.530025308377625	0.526667359702176	false	false	false	true
15363c32-1895-4c05-8200-c58845d06477	2026-09-17 11:50	2026-09-17 11:50	2026-09-17 11:50	ETHA	ETHA260925P00019000	put	19.0000	2026-09-25	0.7400	0.7100	0.7500	18.5950	12506.00	11840.00	0.00	169	16	646	13137	0.0491740884524625	0.471342028835949	0.471342028835949	false	false	false	true
eaae1c5d-3ac5-453c-a90f-2c0822ea423b	2026-09-17 11:49	2026-09-17 11:49	2026-09-17 11:49	ETHA	ETHA261120C00018000	call	18.0000	2026-11-20	2.0000	1.9700	2.0000	18.6050	72000.00	72000.00	0.00	360	10	1180	13	90.7692307692308	0.528188050481106	0.528188050481106	false	false	false	true
0ba159f0-07dd-42f9-b116-fdddf6d5c31f	2026-09-17 11:47	2026-09-17 11:46	2026-09-17 11:46	ETHA	ETHA261002C00019000	call	19.0000	2026-10-02	0.5600	0.5600	0.5700	18.6050	19656.00	0.00	19656.00	351	22	757	3219	0.235166200683442	0.47908168084965	0.47908168084965	false	false	false	true
102b04cf-1250-40c8-baa1-6ac4210f8a17	2026-09-17 11:46	2026-09-17 11:46	2026-09-17 11:46	ETHA	ETHA261218C00019000	call	19.0000	2026-12-18	1.9100	1.9000	1.9100	18.6150	11460.00	11460.00	0.00	60	8	121	6393	0.0189269513530424	0.535461691515961	0.535461691515961	false	false	false	true
c3b14c0e-55d8-4c17-b062-f744020c43d2	2026-09-17 11:44	2026-09-17 11:44	2026-09-17 11:44	ETHA	ETHA261120C00018000	call	18.0000	2026-11-20	2.0100	1.9800	2.0100	18.6250	24522.00	24522.00	0.00	122	6	778	13	59.8461538461538	0.527407782525403	0.527407782525403	false	false	false	true
440833f1-107f-481a-a85c-1de137672815	2026-09-17 11:44	2026-09-17 11:44	2026-09-17 11:44	ETHA	ETHA261120C00018000	call	18.0000	2026-11-20	2.0100	1.9800	2.0100	18.6250	37989.00	37989.00	0.00	189	14	617	13	47.4615384615385	0.527407782525403	0.527407782525403	false	false	false	true
13571878-74a0-430c-9bed-65b3a28d99af	2026-09-17 11:44	2026-09-17 11:44	2026-09-17 11:44	ETHA	ETHA260925P00018500	put	18.5000	2026-09-25	0.4400	0.4300	0.4450	18.6250	20020.00	20020.00	0.00	455	6	3076	4426	0.694984184365115	0.463113227112569	0.463113227112569	false	false	false	true
ffd57dcf-5451-4423-91c8-43b97df635f1	2026-09-17 11:35	2026-09-17 11:35	2026-09-17 11:35	ETHA	ETHA260925P00018500	put	18.5000	2026-09-25	0.4700	0.4600	0.4800	18.5350	81780.00	0.00	79947.00	1740	26	2619	4426	0.591730682331676	0.452978180872813	0.452978180872813	false	false	false	true
8b1d7736-cd67-4f04-b4be-ddf7443766f3	2026-09-17 11:08	2026-09-17 11:08	2026-09-17 11:08	ETHA	ETHA261002P00018000	put	18.0000	2026-10-02	0.4900	0.4800	0.5100	18.4750	11270.00	0.00	11270.00	230	5	238	1676	0.14200477326969	0.484687402799695	0.484687402799695	false	false	false	true
a0ce60ad-d9da-4705-ad7c-f3a12a9358b7	2026-09-17 10:32	2026-09-17 10:32	2026-09-17 10:32	ETHA	ETHA260918C00018000	call	18.0000	2026-09-18	0.6900	0.6600	0.7000	18.6621	13800.00	3174.00	10626.00	200	17	2465	24929	0.0988808215331542	0.54845106421459	0.54845106421459	false	false	false
66544055-ed29-493f-85b6-9ec6366cb348	2026-09-17 10:28	2026-09-17 10:28	2026-09-17 10:28	ETHA	ETHA261030C00020000	call	20.0000	2026-10-30	0.8000	0.7500	0.8100	18.7050	45440.00	45440.00	0.00	568	8	2023	1597	1.26675015654352	0.497654455779626	0.497654455779626	false	false	false	true
d54f0ea0-6c83-4e40-8958-299de4f15c1d	2026-09-17 10:28	2026-09-17 10:28	2026-09-17 10:28	ETHA	ETHA260918C00016000	call	16.0000	2026-09-18	2.7000	2.6800	2.7300	18.7050	14850.00	0.00	14850.00	55	7	102	91840	0.00111062717770035	1.68413613382285	1.68413613382285	false	false	false	true
fb9920a7-ddbc-4c4a-849b-ba54474a6069	2026-09-17 10:27	2026-09-17 10:27	2026-09-17 10:27	ETHA	ETHA270617C00021000	call	21.0000	2027-06-17	3.0500	2.8300	3.0500	18.7050	45750.00	45750.00	0.00	150	10	154	1291	0.119287374128582	0.570581844681546	0.570581844681546	false	false	false
3e43b8c7-689e-419a-924e-1fb177b7c500	2026-09-17 10:26	2026-09-17 10:25	2026-09-17 10:25	ETHA	ETHA261016C00021000	call	21.0000	2026-10-16	0.3400	0.3300	0.3400	18.6600	45526.00	45526.00	0.00	1339	24	3033	5052	0.600356294536817	0.50934307240266	0.50934307240266	false	false	false
aaddb7c2-40ae-43b0-9f06-c8c0b890e0f4	2026-09-17 10:25	2026-09-17 10:25	2026-09-17 10:25	ETHA	ETHA261016C00019000	call	19.0000	2026-10-16	0.9100	0.8800	0.9100	18.7100	18200.00	637.00	0.00	200	9	217	7112	0.030511811023622	0.48269824301075	0.48269824301075	false	false	false	true
b121a8a8-9189-407d-82d4-3c0b549917f2	2026-09-17 10:15	2026-09-17 10:14	2026-09-17 10:14	ETHA	ETHA261030C00021000	call	21.0000	2026-10-30	0.5400	0.4600	0.5500	18.6900	23921.00	20627.00	0.00	443	11	449	390	1.15128205128205	0.506873674462571	0.506873674462571	true	false	false	true
6efff05e-d6fc-4603-9172-6a3792349710	2026-09-17 10:12	2026-09-17 10:12	2026-09-17 10:12	ETHA	ETHA260918C00019000	call	19.0000	2026-09-18	0.1000	0.0900	0.1100	18.6250	33310.00	30880.00	0.00	3331	33	6548	24103	0.271667427291209	0.616491076953297	0.616491076953297	false	false	false
19f08307-1f79-47aa-8750-1d0b2f4ecd48	2026-09-17 10:06	2026-09-17 10:06	2026-09-17 10:06	ETHA	ETHA260918C00018500	call	18.5000	2026-09-18	0.2300	0.2200	0.2300	18.5100	10189.00	10189.00	0.00	443	22	903	7588	0.1190036900369	0.579601344141707	0.579601344141707	false	false	false	true
928de49e-f426-4702-998f-08cb35728a1d	2026-09-17 09:49	2026-09-17 09:49	2026-09-17 09:49	ETHA	ETHA260918C00018000	call	18.0000	2026-09-18	0.5200	0.5200	0.5300	18.4550	35464.00	0.00	35464.00	682	8	1449	24929	0.0581250752136066	0.57822727554831	0.57822727554831	true	false	false	true
59413097-fcb0-4650-a15f-566e69b70cce	2026-09-17 09:49	2026-09-17 09:48	2026-09-17 09:48	ETHA	ETHA260925C00019500	call	19.5000	2026-09-25	0.1900	0.1800	0.1900	18.4577	13167.00	13167.00	0.00	693	11	959	2411	0.397760265450021	0.499563762362878	0.499563762362878	false	false	false
5637a27e-2200-466b-88f6-56fb7b3f33c3	2026-09-17 09:48	2026-09-17 09:48	2026-09-17 09:48	ETHA	ETHA270115C00023000	call	23.0000	2027-01-15	0.9700	0.9300	1.0100	18.4400	28033.00	27063.00	970.00	289	8	1036	1892	0.547568710359408	0.546096706534525	0.546096706534525	true	false	false
1eca8b45-ffaa-46a2-a9b7-4d5963e8a1be	2026-09-17 09:47	2026-09-17 09:47	2026-09-17 09:47	ETHA	ETHA261030C00020000	call	20.0000	2026-10-30	0.7000	0.7000	0.7100	18.4200	86590.00	0.00	86590.00	1237	6	1388	1597	0.869129618033813	0.500363478602768	0.500363478602768	true	false	false
e7ac08a1-00b6-4820-8fd3-aff6052bdaf3	2026-09-17 09:45	2026-09-17 09:44	2026-09-17 09:44	ETHA	ETHA261023C00019000	call	19.0000	2026-10-23	0.8900	0.8700	0.8900	18.3650	42720.00	42720.00	0.00	480	8	672	194	3.4639175257732	0.491911373235331	0.491911373235331	false	false	false	true
6520f852-a19c-4582-b262-4f09006cb916	2026-09-17 09:43	2026-09-17 09:42	2026-09-17 09:42	ETHA	ETHA261030C00019000	call	19.0000	2026-10-30	1.0300	0.8900	1.0300	18.3900	53560.00	53560.00	0.00	520	7	521	687	0.758369723435226	0.49903860181133	0.49903860181133	false	false	false	true
c965d89e-d906-4ca3-ab8e-89655fbeee06	2026-09-17 09:40	2026-09-17 09:40	2026-09-17 09:40	ETHA	ETHA261218C00028000	call	28.0000	2026-12-18	0.2800	0.2700	0.2800	18.3450	53200.00	53200.00	0.00	1900	36	2000	6720	0.297619047619048	0.608562364186403	0.608562364186403	false	false	false
90c926d9-26fd-4927-a9e8-b2c0d50798ce	2026-09-17 09:39	2026-09-17 09:39	2026-09-17 09:39	ETHA	ETHA270115P00019000	put	19.0000	2027-01-15	2.4800	2.3100	2.4800	18.3200	13888.00	13888.00	0.00	56	6	56	668	0.0838323353293413	0.536636442028038	0.536636442028038	false	false	false	true
2b00fee1-b81c-4599-8e0e-8777dec4e294	2026-09-17 09:38	2026-09-17 09:38	2026-09-17 09:38	ETHA	ETHA261030P00019500	put	19.5000	2026-10-30	1.9000	1.7300	1.9000	18.3350	100510.00	100510.00	0.00	529	22	529	2	264.5	0.50158697563157	0.50158697563157	false	false	false	true