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

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

f3bb44a8-140c-429e-9620-b6fa20b239a7	2026-08-26 15:44	2026-08-26 15:44	2026-08-26 15:44	XE	XE260918C00035000	call	35.0000	2026-09-18	0.1500	0.1000	0.2000	18.3200	76165.00	76120.00	0.00	5079	46	15156	23587	0.642557340908127	1.47034512041086	1.47034512041086	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Industrials	4495854600.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
78d93948-1a6d-4cd3-9dab-19ea18ac56ff	2026-08-26 13:35	2026-08-26 13:35	2026-08-26 13:35	XE	XE260918C00030000	call	30.0000	2026-09-18	0.1500	0.1000	0.2500	18.3300	19435.00	15.00	19420.00	1294	28	1980	8097	0.244535012967766	1.26638529785798	1.19620083638687	false	false	false	true	false
e5b64986-6d2d-4a6a-a21d-e29492b442aa	2026-08-26 13:15	2026-08-26 13:15	2026-08-26 13:15	XE	XE270115C00022500	call	22.5000	2027-01-15	3.0000	3.0000	3.2000	18.3500	18000.00	0.00	18000.00	60	5	206	1561	0.1319666880205	0.940298521489221	0.940298521489221	false	false	false	true	false
dfe744bb-3536-49ba-a092-7d4d40bae09e	2026-08-26 10:27	2026-08-26 10:26	2026-08-26 10:26	XE	XE260918C00035000	call	35.0000	2026-09-18	0.1000	0.0500	0.2500	18.9500	77154.00	0.00	76864.00	7712	51	7833	23587	0.332089710433713	1.30330471061429	1.30330471061429	false	false	false	true	false
37c09e3e-7c91-4281-a629-1b30ba7c4360	2026-08-26 09:46	2026-08-26 09:46	2026-08-26 09:46	XE	XE260918C00020000	call	20.0000	2026-09-18	2.2500	2.1000	2.2500	20.2776	22500.00	22500.00	0.00	100	6	168	15181	0.0110664646597721	1.03714897172938	1.03714897172938	false	false	false	true	false
13c1e8a8-7463-4dd7-a4c9-fde53fd826fd	2026-08-25 15:53	2026-08-25 15:53	2026-08-25 15:53	XE	XE260918C00035000	call	35.0000	2026-09-18	0.2500	0.2000	0.2500	19.2900	84275.00	84275.00	0.00	3371	36	27306	13	2100.46153846154	1.4849019570954	1.4849019570954	false	false	false	true	false
c5ba0d2c-21a3-4365-9339-f29b1643f0bf	2026-08-25 15:44	2026-08-25 15:44	2026-08-25 15:44	XE	XE261016C00025000	call	25.0000	2026-10-16	1.2500	1.2000	1.3000	19.1650	78500.00	78375.00	125.00	628	18	830	2302	0.360556038227628	1.02511355348228	1.02511355348228	false	false	false	true	false
bd39364c-436b-4bcb-a37d-27a38b19291f	2026-08-25 15:42	2026-08-25 15:42	2026-08-25 15:42	XE	XE270115C00020000	call	20.0000	2027-01-15	4.2000	4.2000	4.5000	19.2258	44100.00	0.00	44100.00	105	5	144	876	0.164383561643836	0.924321004336996	0.924321004336996	false	false	false	true	false
e9e3a026-589b-4043-bb56-d14170e56792	2026-08-25 15:37	2026-08-25 15:37	2026-08-25 15:37	XE	XE260918C00035000	call	35.0000	2026-09-18	0.2000	0.1500	0.2000	19.1500	84988.00	84988.00	0.00	4250	63	23139	13	1779.92307692308	1.43150782932188	1.43150782932188	false	false	false	true	false
3f5bee45-a9a2-4375-86f3-cd950af4f8f1	2026-08-25 14:56	2026-08-25 14:56	2026-08-25 14:56	XE	XE260918C00030000	call	30.0000	2026-09-18	0.2000	0.2000	0.2500	18.9700	42410.00	0.00	42410.00	2120	37	8089	10637	0.760458775970668	1.17161961581662	1.17161961581662	false	false	false	true	false
93004165-684c-422c-855c-d22054c9182b	2026-08-25 14:04	2026-08-25 14:04	2026-08-25 14:04	XE	XE260918C00035000	call	35.0000	2026-09-18	0.2000	0.1000	0.2000	19.0000	47896.00	47896.00	0.00	2396	50	18351	13	1411.61538461538	1.40114883245343	1.40114883245343	false	false	false	true	false
cc068bd0-8a1b-49c4-b9d7-ae2d389dd2a1	2026-08-25 13:51	2026-08-25 13:51	2026-08-25 13:51	XE	XE260918C00030000	call	30.0000	2026-09-18	0.2500	0.2000	0.3500	19.7500	112287.00	25.00	112262.00	4490	61	5777	10637	0.543104258719564	1.13701774934598	1.14379647421103	false	false	false	true	false
5c787d4f-2477-45de-86ad-f88eceb076c9	2026-08-25 13:37	2026-08-25 13:37	2026-08-25 13:37	XE	XE260918C00020000	call	20.0000	2026-09-18	1.8000	1.6500	1.8000	19.7000	18000.00	18000.00	0.00	100	24	10952	5180	2.11428571428571	0.95030959508397	0.95030959508397	false	false	false	true	false
d621a2b3-5cae-442f-bc73-f1aae46ba04a	2026-08-25 12:53	2026-08-25 12:53	2026-08-25 12:53	XE	XE260918C00035000	call	35.0000	2026-09-18	0.2000	0.2000	0.2500	19.3450	32640.00	0.00	32640.00	1632	7	14862	13	1143.23076923077	1.41069013013912	1.41069013013912	false	false	false	true	false
c5754993-d86a-4e3e-8bec-6c7580ed8922	2026-08-25 12:50	2026-08-25 12:50	2026-08-25 12:50	XE	XE260918C00035000	call	35.0000	2026-09-18	0.2500	0.1500	0.2500	19.1200	98301.00	98301.00	0.00	3933	47	12619	13	970.692307692308	1.5037931960204	1.5037931960204	false	false	false	true	false
16778dd6-f345-4d66-81af-db618ddb9672	2026-08-25 11:40	2026-08-25 11:40	2026-08-25 11:40	XE	XE261016C00017500	call	17.5000	2026-10-16	3.1000	3.1000	3.3000	18.7700	21700.00	0.00	21700.00	70	9	246	1972	0.12474645030426	0.868987799594864	0.868987799594864	false	false	false	true	false
8fe27a4e-468e-465f-9634-751312a86441	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	XE	XE261016C00017500	call	17.5000	2026-10-16	3.4000	3.4000	3.5000	19.1800	22780.00	0.00	22780.00	67	8	156	1972	0.0791075050709939	0.879456979109061	0.879456979109061	false	false	false	true	false
095850aa-85bd-4b5d-bb28-e867c959014c	2026-08-25 11:03	2026-08-25 11:02	2026-08-25 11:02	XE	XE270115P00015000	put	15.0000	2027-01-15	2.1500	2.0000	2.1500	18.9500	22790.00	22790.00	0.00	106	7	306	5197	0.05888012314797	0.941775056037677	0.941775056037677	false	false	false	true	false
c35b89e6-7806-4a6c-a683-a0c95bdcdd88	2026-08-25 10:44	2026-08-25 10:44	2026-08-25 10:44	XE	XE260918C00035000	call	35.0000	2026-09-18	0.2000	0.1250	0.4000	18.6100	101388.00	100278.00	1110.00	5078	60	6273	13	482.538461538462	1.50128101300733	1.49022801889051	false	false	false	true	false
cdf59594-b071-4fe3-b07e-33f1c391f48d	2026-08-25 09:47	2026-08-25 09:47	2026-08-25 09:47	XE	XE260918P00020000	put	20.0000	2026-09-18	2.6500	2.6500	3.2000	18.1800	15900.00	0.00	15900.00	60	7	63	2261	0.0278637770897833	0.829029330384817	0.829029330384817	false	false	false	true	false
d9af30da-c2a3-45c5-a808-15fc1670feca	2026-08-24 15:26	2026-08-24 15:26	2026-08-24 15:26	XE	XE270115C00022500	call	22.5000	2027-01-15	2.9000	2.9000	3.2000	18.1100	22040.00	0.00	22040.00	76	6	126	1480	0.0851351351351351	0.937049384308147	0.937049384308147	false	false	false	true	false
7d50d3d2-7118-4499-ba74-3fba21143ea8	2026-08-24 11:39	2026-08-24 11:39	2026-08-24 11:39	XE	XE270115C00020000	call	20.0000	2027-01-15	3.6000	3.6000	3.9000	18.1900	35280.00	0.00	35280.00	98	5	134	803	0.166874221668742	0.921036601763837	0.921036601763837	false	false	false	true	false
8c819fc0-e664-4c2f-b0f9-11e3003a0522	2026-08-24 10:13	2026-08-24 10:13	2026-08-24 10:13	XE	XE260918C00025000	call	25.0000	2026-09-18	0.2500	0.2500	0.3250	17.6400	89545.00	0.00	89545.00	3581	63	3692	4916	0.751017087062653	1.0144185667117	1.0144185667117	false	false	false	true	false
7ef0b297-4745-4eae-add6-1e7b5f625f99	2026-08-24 10:04	2026-08-24 10:04	2026-08-24 10:04	XE	XE261016C00022500	call	22.5000	2026-10-16	1.1200	1.0000	1.2500	17.5850	20930.00	0.00	20930.00	187	16	189	2935	0.0643952299829642	0.957555485583698	0.959547126345926	false	false	false	true	false
e0c49039-45bb-484c-8038-ed88be40fa71	2026-08-21 13:02	2026-08-21 13:02	2026-08-21 13:02	XE	XE261016P00012500	put	12.5000	2026-10-16	0.3000	0.3000	0.4000	19.0400	10500.00	0.00	10500.00	350	15	354	465	0.761290322580645	0.903819977428495	0.904549680793246	false	false	false	true	false
71143713-1d97-4fc3-9224-cef702d3e358	2026-08-21 11:54	2026-08-21 11:53	2026-08-21 11:53	XE	XE260918C00030000	call	30.0000	2026-09-18	0.3000	0.2500	0.3500	19.1200	36660.00	27150.00	7080.00	1222	24	7212	2984	2.41689008042895	1.17644413955714	1.17644413955714	false	false	false	true	false
5307b3c5-2b62-42a9-af63-ed8e992d8794	2026-08-21 11:43	2026-08-21 11:42	2026-08-21 11:42	XE	XE260918C00025000	call	25.0000	2026-09-18	0.6000	0.4000	0.6500	19.1950	71460.00	120.00	71340.00	1191	21	1333	3506	0.380205362236167	1.02696855582663	1.02696855582663	false	false	false	true	false
83bb02b7-a04f-4833-aa9f-735df3679c18	2026-08-21 11:38	2026-08-21 11:38	2026-08-21 11:38	XE	XE261016C00022500	call	22.5000	2026-10-16	1.6000	1.6000	1.7000	19.1400	38335.00	2640.00	35200.00	239	6	251	2676	0.093796711509716	0.929372078928805	0.929372078928805	false	false	false	true	false
fc74cbe7-a089-45a7-bab0-c0b275b41c6d	2026-08-21 11:38	2026-08-21 11:38	2026-08-21 11:38	XE	XE260918C00030000	call	30.0000	2026-09-18	0.3000	0.1000	0.3500	18.9100	147847.00	146257.00	1200.00	4937	67	4960	2984	1.66219839142091	1.19993332554161	1.14779082947761	false	false	false	true	false
fe88c0e2-a540-4e45-93a5-72363bb09097	2026-08-21 11:37	2026-08-21 11:37	2026-08-21 11:37	XE	XE261016C00040000	call	40.0000	2026-10-16	0.2000	0.1000	0.4000	18.7899	83840.00	81340.00	2500.00	4193	56	4194	1055	3.97535545023697	1.10879901501848	1.10879901501848	false	false	false	true	false
63110297-711f-4dd2-8238-85374b69c64c	2026-08-20 14:26	2026-08-20 14:26	2026-08-20 14:26	XE	XE270115C00025000	call	25.0000	2027-01-15	2.2000	2.2000	2.5500	17.9932	48643.00	0.00	48643.00	221	7	255	644	0.395962732919255	0.906470798694246	0.906470798694246	false	false	false	true	false
fc3be1a0-929a-4ae3-a6ed-070282d5d80c	2026-08-20 11:52	2026-08-20 11:52	2026-08-20 11:52	XE	XE260918P00017500	put	17.5000	2026-09-18	1.4500	1.4000	1.4500	18.2100	21740.00	20290.00	0.00	150	14	552	899	0.614015572858732	0.903187595270575	0.903187595270575	true	false	false	true	false
a8c7be98-e861-4189-8e8e-d5022fa95749	2026-08-20 11:43	2026-08-20 11:43	2026-08-20 11:43	XE	XE270115P00017500	put	17.5000	2027-01-15	3.6000	3.5000	3.7000	18.2100	29160.00	28800.00	360.00	81	10	136	1531	0.0888308295231875	0.916486190641598	0.918523412372587	false	false	false	true	false
bf69528b-0d47-4f51-854a-0ec73e519ce8	2026-08-20 09:56	2026-08-20 09:56	2026-08-20 09:56	XE	XE270115C00022500	call	22.5000	2027-01-15	3.0000	3.0000	3.2000	18.5900	20420.00	0.00	19505.00	68	13	142	1159	0.122519413287317	0.905773463604942	0.895184093131405	false	false	false	true	false
dda56744-5b65-40c9-9a56-050f85415060	2026-08-20 09:38	2026-08-20 09:38	2026-08-20 09:38	XE	XE270115C00030000	call	30.0000	2027-01-15	2.1000	1.8500	2.2500	19.7400	16800.00	16800.00	0.00	80	6	80	1825	0.0438356164383562	0.969968111757365	0.92734270585357	false	false	false	true	false
74518a4f-df4d-40dd-82c3-60b0afd7682f	2026-08-19 13:04	2026-08-19 13:04	2026-08-19 13:04	XE	XE270115C00022500	call	22.5000	2027-01-15	3.5000	3.5000	3.7000	19.6300	22750.00	0.00	22750.00	65	7	287	816	0.35171568627451	0.885830233078655	0.885830233078655	false	false	false	true	false
e700c0b6-7757-4536-beea-ed665f3e66b0	2026-08-18 14:01	2026-08-18 14:01	2026-08-18 14:01	XE	XE260918P00020000	put	20.0000	2026-09-18	2.5500	2.5000	2.6000	19.1000	243290.00	255.00	243035.00	954	43	1141	3415	0.33411420204978	0.919577157411517	0.931113266562065	false	false	false	true	false
8cc0047a-4b35-4fd6-8b0d-13aff78f7b03	2026-08-18 10:44	2026-08-18 10:44	2026-08-18 10:44	XE	XE261016P00017500	put	17.5000	2026-10-16	1.8000	1.5000	1.9500	19.0800	41040.00	540.00	30780.00	228	31	246	1409	0.174591909155429	0.87891922368691	0.87891922368691	false	false	false	true	false
e53f2bdf-5e97-4927-a626-c5ff301c4481	2026-08-18 09:57	2026-08-18 09:57	2026-08-18 09:57	XE	XE260821P00020000	put	20.0000	2026-08-21	1.1500	0.9500	1.1500	19.5300	216755.00	216755.00	0.00	1885	49	1937	1437	1.34794711203897	1.25873132256146	1.25873132256146	false	false	false	true	false
f58ca9c0-e810-4ec4-b8cb-deed5b128fb6	2026-08-17 10:58	2026-08-17 10:58	2026-08-17 10:58	XE	XE270115P00017500	put	17.5000	2027-01-15	2.8500	2.5000	3.0000	20.8900	11970.00	11970.00	0.00	42	6	43	1539	0.0279402209226771	0.92633901072708	0.926037008923576	false	false	false	true	false
34a9ef4a-5dac-4b2f-800b-703163fc22c0	2026-08-17 10:14	2026-08-17 10:14	2026-08-17 10:14	XE	XE261016P00020000	put	20.0000	2026-10-16	2.6000	2.3000	2.6000	20.7500	10660.00	4680.00	0.00	41	13	42	1502	0.0279627163781625	0.92386881076526	0.92386881076526	false	false	false	true	false