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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = RKT×

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

46121773-52bf-4800-9b72-2ed79a9e327a	2026-08-31 09:46	2026-08-31 09:45	2026-08-31 09:45	RKT	RKT260904C00014000	call	14.0000	2026-09-04	0.1000	0.1000	0.1200	13.3100	11220.00	0.00	11220.00	1122	72	1322	20334	0.0650142618274811	0.591794453907504	0.591794453907504	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	25622320765.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c86db786-caa2-4d22-a327-dcad64b357d2	2026-08-31 09:34	2026-08-31 09:34	2026-08-31 09:34	RKT	RKT261016C00013000	call	13.0000	2026-10-16	1.2500	1.2200	1.3000	13.3900	12500.00	0.00	12500.00	100	11	500	2686	0.186150409530901	0.541188870113297	0.541188870113297	false	false	false	true
2797e3f8-4209-47e6-9598-be246523cc66	2026-08-28 15:46	2026-08-28 15:46	2026-08-28 15:46	RKT	RKT260828P00014000	put	14.0000	2026-08-28	0.1700	0.1700	0.2600	13.8150	21760.00	0.00	21760.00	1280	19	17137	15680	1.09292091836735	5.3529119305561	5.3529119305561	false	false	false	true
cfade464-8a65-411a-bdde-c87567770077	2026-08-28 15:45	2026-08-28 15:45	2026-08-28 15:45	RKT	RKT260828P00014000	put	14.0000	2026-08-28	0.1700	0.1600	0.1900	13.8150	13838.00	10013.00	3825.00	814	22	14393	15680	0.917920918367347	0	1.8201010816947	false	false	false	true
ac46019f-bcf7-4752-925f-b1578b6ac701	2026-08-28 15:45	2026-08-28 15:45	2026-08-28 15:45	RKT	RKT260828P00014000	put	14.0000	2026-08-28	0.1700	0.1600	0.2000	13.8135	10438.00	272.00	10166.00	614	28	13567	15680	0.865242346938776	0	2.41520552746454	false	false	false	true
5ac69647-ca29-4cff-82a7-8f68bbf5d13b	2026-08-28 14:38	2026-08-28 14:38	2026-08-28 14:38	RKT	RKT260828P00014000	put	14.0000	2026-08-28	0.1100	0.1000	0.1100	13.9100	16269.00	16269.00	0.00	1479	52	5304	15680	0.338265306122449	0.768885676946466	0.768885676946466	true	false	false	true
9419bd8f-b1c4-4641-9fe5-e03d08f1a3e1	2026-08-28 14:23	2026-08-28 14:23	2026-08-28 14:23	RKT	RKT260828P00014000	put	14.0000	2026-08-28	0.1200	0.1100	0.1200	13.8950	13404.00	13404.00	0.00	1117	18	3279	15680	0.209119897959184	0.681292321642716	0.681292321642716	true	false	false	true
c66676e1-4bbe-450f-8921-d0e58c900c8a	2026-08-28 14:07	2026-08-28 14:06	2026-08-28 14:06	RKT	RKT260918C00014000	call	14.0000	2026-09-18	0.6800	0.6600	0.7100	13.9001	13600.00	2312.00	10200.00	200	36	1458	9696	0.150371287128713	0.53401372750569	0.535895399808725	false	false	false	true
c201d26a-102b-4491-9720-b408f3fea809	2026-08-28 14:05	2026-08-28 14:05	2026-08-28 14:05	RKT	RKT260918C00014000	call	14.0000	2026-09-18	0.6900	0.6800	0.7000	13.9150	13800.00	10419.00	3381.00	200	20	1256	9696	0.12953795379538	0.537678578721045	0.537678578721045	false	false	false	true
87b904da-3e2f-4619-bccb-bbf5561ad9e7	2026-08-28 13:51	2026-08-28 13:51	2026-08-28 13:51	RKT	RKT261218P00013000	put	13.0000	2026-12-18	1.1600	1.1600	1.2200	13.8550	72875.00	3159.00	69716.00	628	20	833	6239	0.133514986376022	0.549607480256049	0.549607480256049	false	false	false	true
ba34d4fd-6fab-4dee-afd5-e2975b4b5e38	2026-08-28 12:15	2026-08-28 12:15	2026-08-28 12:15	RKT	RKT261016C00015000	call	15.0000	2026-10-16	0.6600	0.6600	0.7100	13.9150	27588.00	0.00	27588.00	418	7	3045	15875	0.191811023622047	0.518563255831631	0.518563255831631	false	false	false	true
9a7ad826-f994-44f5-90f4-ed1bff9f33df	2026-08-28 12:14	2026-08-28 12:14	2026-08-28 12:14	RKT	RKT261016C00015000	call	15.0000	2026-10-16	0.6700	0.6700	0.7200	13.9250	53600.00	0.00	53600.00	800	47	2545	15875	0.160314960629921	0.519643516279176	0.521654266394779	false	false	false	true
5bc9805f-b432-4730-9e11-a6c8c0fe4dd4	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	RKT	RKT261218C00015000	call	15.0000	2026-12-18	1.3800	1.3700	1.4100	14.0000	13248.00	0.00	12420.00	96	7	97	3435	0.0282387190684134	0.552837569061001	0.552837569061001	false	false	false	true
33a765b1-022e-4923-9530-bb164313d4ec	2026-08-28 11:44	2026-08-28 11:44	2026-08-28 11:44	RKT	RKT280121C00015000	call	15.0000	2028-01-21	3.7000	3.6000	3.9000	14.0000	96200.00	52910.00	43290.00	260	5	419	4873	0.0859839934332034	0.571372734179561	0.571873264180776	false	false	false	true
3d5f7f9c-48b7-4fc3-8fc2-3b27494c182c	2026-08-28 10:07	2026-08-28 10:07	2026-08-28 10:07	RKT	RKT260828C00014000	call	14.0000	2026-08-28	0.3100	0.2500	0.3500	14.2479	10757.00	10757.00	0.00	347	7	3112	4617	0.674030755902101	1.06430246916278	1.06430246916278	true	false	false	true
6f355449-9a38-438d-981c-38b5ef682289	2026-08-28 10:06	2026-08-28 10:06	2026-08-28 10:06	RKT	RKT260828C00014000	call	14.0000	2026-08-28	0.2600	0.2100	0.4100	14.2200	10480.00	2004.00	8476.00	403	31	2510	4617	0.543643058262941	0.879809758763035	0.813384825728794	true	false	false	true
f0fc907d-a6b4-4515-8cfa-b0d050c14cef	2026-08-28 10:06	2026-08-28 10:06	2026-08-28 10:06	RKT	RKT260828C00014000	call	14.0000	2026-08-28	0.2600	0.2000	0.3000	14.2250	12532.00	11726.00	806.00	482	15	2107	4617	0.456356941737059	0.77743870335001	0.77743870335001	true	false	false	true
594077c4-d8e4-47d1-bd72-7e4675de0abd	2026-08-28 10:05	2026-08-28 10:05	2026-08-28 10:05	RKT	RKT260828C00014000	call	14.0000	2026-08-28	0.4500	0.3900	0.5200	14.3650	17595.00	3555.00	14040.00	391	20	661	4617	0.143166558371237	1.50436954409904	1.50436954409904	true	false	false	true
0b84c414-16b1-4aba-aacf-049198ad8282	2026-08-28 09:56	2026-08-28 09:56	2026-08-28 09:56	RKT	RKT260828C00015000	call	15.0000	2026-08-28	0.0500	0.0200	0.0600	14.3900	28680.00	9590.00	5180.00	5736	14	13839	13820	1.00137481910275	1.58620235004206	1.56876090944604	false	false	false	true
dcc9f7a7-5286-4aaf-bc70-1eacf5137c4c	2026-08-27 15:36	2026-08-27 15:36	2026-08-27 15:36	RKT	RKT280121C00015000	call	15.0000	2028-01-21	3.8000	3.6500	3.8000	14.1250	56960.00	56960.00	0.00	150	22	535	4663	0.114733004503538	0.581702234361391	0.575350792864067	false	false	false	true
33d0536d-a7e7-420c-868d-9811f0a68819	2026-08-27 15:32	2026-08-27 15:32	2026-08-27 15:32	RKT	RKT260918C00016000	call	16.0000	2026-09-18	0.2300	0.1800	0.2300	14.0000	29008.00	28106.00	902.00	1263	28	6223	26536	0.234511606873681	0.580179400787456	0.56920469348424	false	false	false	true
d546b0b2-6863-4126-8e00-658c218f1085	2026-08-27 14:00	2026-08-27 14:00	2026-08-27 14:00	RKT	RKT261016C00017000	call	17.0000	2026-10-16	0.2700	0.2600	0.2900	14.1200	14121.00	27.00	14094.00	523	66	584	15220	0.0383705650459921	0.514049613241945	0.51472900022929	false	false	false	true
fc9f10fc-3107-4476-bf20-b6f7145987b6	2026-08-27 12:07	2026-08-27 12:07	2026-08-27 12:07	RKT	RKT260828C00014500	call	14.5000	2026-08-28	0.2000	0.2000	0.2400	14.2750	17620.00	0.00	17620.00	881	28	11943	10089	1.18376449598573	0.993853673789662	0.993853673789662	false	false	false	true
cf65a8c8-8277-4292-af97-8f1656e5a6a3	2026-08-27 12:05	2026-08-27 12:05	2026-08-27 12:05	RKT	RKT260828C00014500	call	14.5000	2026-08-28	0.2200	0.2200	0.2300	14.2950	25366.00	0.00	25366.00	1153	15	8918	10089	0.88393299633264	1.03538042384126	1.03538042384126	true	false	false	true
11209968-61f0-4c50-ba1a-76c61f62dab6	2026-08-27 12:05	2026-08-27 12:05	2026-08-27 12:05	RKT	RKT260904C00015500	call	15.5000	2026-09-04	0.1400	0.1000	0.1400	14.2800	12068.00	12068.00	0.00	862	41	915	710	1.2887323943662	0.619938413272725	0.618248429223438	true	false	false	true
70cfe842-ca92-4b4a-8666-272630c47bf2	2026-08-27 12:04	2026-08-27 12:04	2026-08-27 12:04	RKT	RKT260828C00014500	call	14.5000	2026-08-28	0.1800	0.1600	0.1900	14.2650	11358.00	5958.00	5400.00	631	7	6283	10089	0.622757458618297	0.937381542897725	0.937381542897725	true	false	false	true
8c631152-7a9b-42b0-904f-bd28f93194f0	2026-08-27 11:35	2026-08-27 11:35	2026-08-27 11:35	RKT	RKT261120C00019000	call	19.0000	2026-11-20	0.3300	0.3200	0.3300	14.1850	16830.00	16830.00	0.00	510	6	574	8407	0.0682764363030808	0.558536651493731	0.558536651493731	false	false	false	true
f8824979-f8e0-4df9-8edb-ec1f141e6301	2026-08-27 11:20	2026-08-27 11:20	2026-08-27 11:20	RKT	RKT270319C00015000	call	15.0000	2027-03-19	2.1500	2.1100	2.1800	14.1350	16327.00	3440.00	6222.00	76	5	92	990	0.0929292929292929	0.564528671430996	0.562138633556785	false	false	false	true
6989b552-0ea6-4d28-ae94-b33f0b26479f	2026-08-27 10:34	2026-08-27 10:33	2026-08-27 10:33	RKT	RKT261016P00014000	put	14.0000	2026-10-16	1.0500	1.0400	1.1000	14.0000	10500.00	0.00	10500.00	100	5	105	848	0.123820754716981	0.527146435099593	0.527146435099593	false	false	false	true
c20f1e7b-0c56-40a1-a994-f4645a8838e3	2026-08-26 14:40	2026-08-26 14:40	2026-08-26 14:40	RKT	RKT261016C00015000	call	15.0000	2026-10-16	0.7500	0.7500	0.7600	14.0250	10800.00	0.00	10800.00	144	14	1295	14997	0.0863506034540241	0.530338408915639	0.530338408915639	false	false	false	true
b2c760e8-e6dd-483c-9b54-85af1453e2e9	2026-08-26 14:40	2026-08-26 14:40	2026-08-26 14:40	RKT	RKT261016C00015000	call	15.0000	2026-10-16	0.7500	0.7400	0.7700	14.0250	15225.00	0.00	15225.00	203	7	1151	14997	0.0767486830699473	0.530338408915639	0.530338408915639	false	false	false	true
3cdbdac5-540a-4a5d-94b1-c2093823a539	2026-08-26 14:29	2026-08-26 14:29	2026-08-26 14:29	RKT	RKT260918C00015500	call	15.5000	2026-09-18	0.2800	0.2500	0.2900	13.9850	28140.00	27748.00	0.00	1005	46	2075	287	7.22996515679443	0.552526669609304	0.553230002775054	false	false	false	true
cb4b00a4-766f-4635-a1c8-3c3661ad5afd	2026-08-26 13:44	2026-08-26 13:44	2026-08-26 13:44	RKT	RKT260918C00015000	call	15.0000	2026-09-18	0.3800	0.3700	0.3800	13.9450	13072.00	13072.00	0.00	344	22	2320	35883	0.0646545718028036	0.54420370227014	0.54420370227014	false	false	false	true
546dfb89-61dd-4a46-8a3b-30d0d4a76d8a	2026-08-26 12:50	2026-08-26 12:50	2026-08-26 12:50	RKT	RKT270115P00014200	put	14.2000	2027-01-15	1.8600	1.8600	1.9100	14.0250	14136.00	0.00	14136.00	76	8	481	5468	0.087966349670812	0.542274263211967	0.542274263211967	false	false	false	true
18424f3c-2a4d-4716-acb0-8647b7b487d6	2026-08-26 12:27	2026-08-26 12:27	2026-08-26 12:27	RKT	RKT260918C00015000	call	15.0000	2026-09-18	0.3800	0.3800	0.4100	13.9750	15200.00	0.00	15200.00	400	12	1487	35883	0.0414402363236073	0.5364254086103	0.5364254086103	false	false	false	true
106c0d42-9e96-4a25-b157-a1906b8c4b5c	2026-08-26 11:29	2026-08-26 11:29	2026-08-26 11:29	RKT	RKT261016C00015000	call	15.0000	2026-10-16	0.6900	0.6800	0.7400	13.8600	34530.00	2277.00	32253.00	500	45	849	14997	0.0566113222644529	0.532697972707802	0.533685683466466	true	false	false	true
01032910-4a4d-479c-b684-18231a9a8f90	2026-08-26 11:25	2026-08-26 11:25	2026-08-26 11:25	RKT	RKT260828C00014000	call	14.0000	2026-08-28	0.2200	0.2100	0.2600	13.8899	15334.00	814.00	12716.00	697	26	886	2727	0.324899156582325	0.656313777952246	0.656313777952246	false	false	false	true
df097030-e4ce-4e12-9b4d-423db1a93ed4	2026-08-26 11:21	2026-08-26 11:21	2026-08-26 11:21	RKT	RKT270115P00014200	put	14.2000	2027-01-15	1.9500	1.9500	1.9900	13.8981	22620.00	0.00	22620.00	116	13	248	5468	0.0453547915142648	0.552466489849899	0.552466489849899	false	false	false	true
bff010b8-735f-4e05-bd1c-34f4c45bc210	2026-08-26 10:25	2026-08-26 10:25	2026-08-26 10:25	RKT	RKT260918P00014000	put	14.0000	2026-09-18	0.7600	0.7500	0.8000	14.0050	15732.00	0.00	15732.00	207	8	257	11628	0.0221018231854145	0.556675666597984	0.556675666597984	false	false	false	true
169ca4d9-4fa7-4668-9ec3-d40464cee749	2026-08-25 11:59	2026-08-25 11:58	2026-08-25 11:58	RKT	RKT261218C00015000	call	15.0000	2026-12-18	1.5800	1.5500	1.5800	14.2400	72364.00	72364.00	0.00	458	31	668	2707	0.246767639453269	0.573254692062307	0.572447026932396	false	false	false	true
fa5f6a01-ce4d-449a-8bd9-d84702c5d595	2026-08-25 11:58	2026-08-25 11:58	2026-08-25 11:58	RKT	RKT261218C00015000	call	15.0000	2026-12-18	1.5600	1.5300	1.5700	14.2250	25584.00	23556.00	1560.00	164	10	206	2707	0.0760990025858884	0.570197403552897	0.568587371354531	false	false	false	true
e7826392-3cda-49e2-9c04-06a6cd2ac013	2026-08-25 11:23	2026-08-25 11:23	2026-08-25 11:23	RKT	RKT261016C00015000	call	15.0000	2026-10-16	0.8200	0.8000	0.8300	14.0750	16400.00	16154.00	246.00	200	8	982	13709	0.0716317747465169	0.548500396929364	0.548500396929364	true	false	false	true
a7d193e6-3513-4ed7-a012-7f64103fed3e	2026-08-25 11:13	2026-08-25 11:13	2026-08-25 11:13	RKT	RKT261120P00012000	put	12.0000	2026-11-20	0.6700	0.6500	0.6700	13.9650	14807.00	14807.00	0.00	221	9	222	451	0.492239467849224	0.59200020299989	0.59200020299989	false	false	false	true
cda80b11-cf04-4a00-921c-e908ce475446	2026-08-25 10:07	2026-08-25 10:07	2026-08-25 10:07	RKT	RKT260918C00014500	call	14.5000	2026-09-18	0.6200	0.5600	0.6200	13.8950	15500.00	15500.00	0.00	250	7	251	167	1.50299401197605	0.604040064230214	0.604040064230214	false	false	false	true
065359da-e27d-47bb-ac91-d947360ed13c	2026-08-24 15:58	2026-08-24 15:58	2026-08-24 15:58	RKT	RKT261016C00016000	call	16.0000	2026-10-16	0.5500	0.5200	0.5500	14.0900	51260.00	51260.00	0.00	932	35	1643	21222	0.0774196588445952	0.552641839780536	0.552641839780536	false	false	false	true
08dfb5ab-8bb0-4120-99f0-be964c8c86e2	2026-08-24 15:25	2026-08-24 15:24	2026-08-24 15:24	RKT	RKT261016C00015000	call	15.0000	2026-10-16	0.8000	0.7800	0.8000	14.0500	26160.00	26160.00	0.00	327	9	1653	13374	0.123598026020637	0.53861008140012	0.53861008140012	false	false	false	true
15137310-5275-4314-8cf0-21192ae803a6	2026-08-24 14:54	2026-08-24 14:54	2026-08-24 14:54	RKT	RKT261218P00014000	put	14.0000	2026-12-18	1.6700	1.6300	1.6700	13.9898	13861.00	13861.00	0.00	83	10	83	5032	0.0164944356120827	0.561770488911315	0.561770488911315	false	false	false	true
2b628c7c-6fca-4ec9-af97-d58d385c098c	2026-08-24 14:33	2026-08-24 14:33	2026-08-24 14:33	RKT	RKT260918C00014000	call	14.0000	2026-09-18	0.8200	0.7800	0.8300	13.9550	28372.00	28372.00	0.00	346	20	507	9144	0.0554461942257218	0.566087462312737	0.566087462312737	false	false	false	true
0341c162-ff5b-4f8b-9fed-3f83bb434724	2026-08-24 13:28	2026-08-24 13:28	2026-08-24 13:28	RKT	RKT260904C00014000	call	14.0000	2026-09-04	0.5600	0.5500	0.5700	13.9450	149632.00	149240.00	0.00	2672	12	18975	226	83.9601769911504	0.599237817482154	0.599237817482154	false	false	false	true
7391dde9-5f39-4a1b-8685-9be2d6978217	2026-08-24 13:27	2026-08-24 13:27	2026-08-24 13:27	RKT	RKT260904C00014000	call	14.0000	2026-09-04	0.5600	0.5600	0.5700	13.9550	16688.00	0.00	16688.00	298	26	15980	226	70.7079646017699	0.593943539068122	0.593943539068122	false	false	false	true