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

f2e041eb-17b5-4f87-9e5b-33de5563b7e1	2026-08-24 13:25	2026-08-24 13:25	2026-08-24 13:25	RKT	RKT260904C00014000	call	14.0000	2026-09-04	0.5600	0.5600	0.5700	13.9595	10976.00	0.00	10976.00	196	6	15296	226	67.6814159292035	0.591553553180298	0.591553553180298	false	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-24T17:47:44.554262Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
44ab7637-12d8-44e9-9949-d6dbd84b2e32	2026-08-24 12:17	2026-08-24 12:17	2026-08-24 12:17	RKT	RKT260911C00014500	call	14.5000	2026-09-11	0.4400	0.4100	0.4400	13.9250	22000.00	22000.00	0.00	500	17	639	2062	0.309893307468477	0.543535598543547	0.540210346751706	false	false	false	true
f0351438-867a-41bb-974a-2ef3c8412e8c	2026-08-24 12:02	2026-08-24 12:02	2026-08-24 12:02	RKT	RKT261120C00015000	call	15.0000	2026-11-20	1.1700	1.1100	1.1700	13.9050	103779.00	103779.00	0.00	887	23	1380	2947	0.468272819816763	0.570886533022834	0.570886533022834	false	false	false	true
8ffd7326-c79a-4270-af53-fa8bc7178e4b	2026-08-24 12:02	2026-08-24 12:02	2026-08-24 12:02	RKT	RKT260918P00013500	put	13.5000	2026-09-18	0.5700	0.5700	0.6100	13.9050	18297.00	0.00	18297.00	321	13	592	0	0	0.539484118276882	0.539484118276882	false	false	false	true
4a5f2917-e35f-4de2-b80d-1ac4d243557e	2026-08-24 12:02	2026-08-24 12:02	2026-08-24 12:02	RKT	RKT260828C00014000	call	14.0000	2026-08-28	0.3400	0.3000	0.3400	13.9050	35904.00	35904.00	0.00	1056	20	2060	1314	1.56773211567732	0.657440654479434	0.657440654479434	false	false	false	true
b4a99a1f-0f4e-4859-87d6-53867f392938	2026-08-24 09:50	2026-08-24 09:49	2026-08-24 09:49	RKT	RKT260918P00013000	put	13.0000	2026-09-18	0.3900	0.2700	0.4400	13.8550	10897.00	3588.00	7309.00	277	6	278	7851	0.0354095019742708	0.537970215396564	0.537970215396564	false	false	false	true
79c08405-0169-404c-b09a-f434a66fad49	2026-08-21 15:48	2026-08-21 15:48	2026-08-21 15:48	RKT	RKT260918C00013000	call	13.0000	2026-09-18	1.3200	1.2800	1.3500	13.8550	66000.00	49500.00	16500.00	500	12	947	5244	0.180587337909992	0.537353009924015	0.537353009924015	false	false	false	true
6ef021c3-e0d6-4a84-b5c0-8d2538127961	2026-08-21 15:36	2026-08-21 15:36	2026-08-21 15:36	RKT	RKT260918C00014000	call	14.0000	2026-09-18	0.7000	0.6500	0.7000	13.7550	11130.00	11130.00	0.00	159	14	517	8896	0.0581160071942446	0.521620812139969	0.521620812139969	false	false	false	true
dbdd2a1f-80ed-4999-bad2-3c6815033cb4	2026-08-21 15:35	2026-08-21 15:35	2026-08-21 15:35	RKT	RKT260918C00013000	call	13.0000	2026-09-18	1.2100	1.2100	1.2500	13.7350	18755.00	0.00	18755.00	155	12	423	5244	0.0806636155606407	0.51724391067184	0.51724391067184	false	false	false	true
f55de088-c7f7-4299-be0e-ca93df24de0d	2026-08-21 15:35	2026-08-21 15:35	2026-08-21 15:35	RKT	RKT260918C00013000	call	13.0000	2026-09-18	1.2000	1.2000	1.2000	13.7350	18600.00	0.00	0.00	155	5	268	5244	0.0511060259344012	0.509856329845203	0.509856329845203	false	false	false	true
a754b94f-213b-4e75-8ecb-6096938d2286	2026-08-21 15:28	2026-08-21 15:28	2026-08-21 15:28	RKT	RKT260828C00015000	call	15.0000	2026-08-28	0.1000	0.1000	0.1200	13.8350	10010.00	0.00	10010.00	1001	6	1686	19166	0.0879682771574663	0.5866248662789	0.5866248662789	false	false	false	true
332acafe-3887-4e4c-a051-08f886078d12	2026-08-21 15:20	2026-08-21 15:20	2026-08-21 15:20	RKT	RKT260918P00010000	put	10.0000	2026-09-18	0.0700	0.0400	0.0700	13.8650	35000.00	35000.00	0.00	5000	41	5003	9137	0.547553901718288	0.780435629473272	0.780435629473272	false	false	false	true
aa4aee59-f87d-451f-ad47-3831aa2a61ad	2026-08-21 15:01	2026-08-21 15:01	2026-08-21 15:01	RKT	RKT260828C00014500	call	14.5000	2026-08-28	0.2200	0.2000	0.2200	13.9200	29084.00	29084.00	0.00	1322	5	2970	8704	0.341222426470588	0.571559382857288	0.571559382857288	false	false	false	true
de52e3d3-8f66-43e1-9883-1ceeab181c6a	2026-08-21 15:01	2026-08-21 15:01	2026-08-21 15:01	RKT	RKT260828C00014500	call	14.5000	2026-08-28	0.2000	0.1900	0.2000	13.8850	23560.00	23560.00	0.00	1178	11	1648	8704	0.189338235294118	0.558244086139606	0.558244086139606	false	false	false	true
f151b6ae-d238-449c-8c97-30d3d7b4937f	2026-08-20 13:58	2026-08-20 13:57	2026-08-20 13:57	RKT	RKT270617C00020000	call	20.0000	2027-06-17	1.2200	1.2100	1.2200	14.0150	19032.00	19032.00	0.00	156	6	17484	18316	0.954575234767416	0.540438736121266	0.540438736121266	false	false	false	true
6d028185-0b6c-4f2d-b58b-379ec5ca1a63	2026-08-20 13:58	2026-08-20 13:57	2026-08-20 13:57	RKT	RKT270617C00020000	call	20.0000	2027-06-17	1.2200	1.2100	1.2500	14.0150	40992.00	5368.00	35624.00	336	5	17820	18316	0.97291985149596	0.540438736121266	0.540438736121266	false	false	false	true
c06ac3f5-41af-4311-858b-315e630f198a	2026-08-20 13:58	2026-08-20 13:57	2026-08-20 13:57	RKT	RKT270617C00020000	call	20.0000	2027-06-17	1.2200	1.2100	1.3000	14.0150	176534.00	139812.00	36600.00	1447	12	17226	18316	0.940489189779428	0.540438736121266	0.540438736121266	true	false	false	true
2ad7cd2f-6c97-45eb-ae77-cbdea18f583a	2026-08-20 13:55	2026-08-20 13:55	2026-08-20 13:55	RKT	RKT270617C00020000	call	20.0000	2027-06-17	1.2300	1.2300	1.3100	14.0500	221646.00	0.00	221646.00	1802	28	15779	18316	0.861487224284778	0.540024885875415	0.540024885875415	false	false	false	true
13e91ee1-374a-42d0-ba35-6c7032b4abd6	2026-08-20 13:43	2026-08-20 13:43	2026-08-20 13:43	RKT	RKT280121C00018000	call	18.0000	2028-01-21	2.7500	2.6500	2.7500	14.0650	17875.00	17875.00	0.00	65	5	85	3466	0.0245239469128679	0.558234201396999	0.558234201396999	false	false	false	true
bb92868b-1c38-43a1-bc96-f9ab06e98f3d	2026-08-20 13:38	2026-08-20 13:38	2026-08-20 13:38	RKT	RKT270617C00020000	call	20.0000	2027-06-17	1.2600	1.2300	1.2600	14.1200	151200.00	151200.00	0.00	1200	8	8927	18316	0.487388075999126	0.540915935560412	0.541281869631408	true	false	false	true
f817888c-cdc1-4cc3-9161-0d723a162b2c	2026-08-20 13:16	2026-08-20 13:16	2026-08-20 13:16	RKT	RKT270617C00020000	call	20.0000	2027-06-17	1.2500	1.2300	1.3000	14.0850	63498.00	0.00	63498.00	508	14	2327	18316	0.127047390259882	0.540993525270606	0.53960080418394	true	false	false	true
5b41a983-c1d3-4c4f-9505-a429a8fa011a	2026-08-20 13:15	2026-08-20 13:15	2026-08-20 13:15	RKT	RKT270617C00020000	call	20.0000	2027-06-17	1.2700	1.2600	1.3400	14.0650	216027.00	0.00	216027.00	1701	22	1801	18316	0.0983293295479362	0.546332115233605	0.547435492640275	false	false	false	true
22fd162e-380f-49ed-abbd-b659962b99c6	2026-08-20 13:15	2026-08-20 13:15	2026-08-20 13:15	RKT	RKT270115C00019200	call	19.2000	2027-01-15	0.5900	0.5800	0.6000	14.0900	28261.00	0.00	59.00	479	9	652	30967	0.0210546711014951	0.533717814583557	0.533717814583557	true	false	false	true
02c22d8c-18b8-4d30-9ec2-1ca9b17b5b03	2026-08-20 13:07	2026-08-20 13:07	2026-08-20 13:07	RKT	RKT261016C00016000	call	16.0000	2026-10-16	0.5300	0.5300	0.5700	14.0950	25970.00	0.00	25970.00	490	21	1450	20815	0.0696613019457122	0.521154943435018	0.521154943435018	false	false	false	true
c307ea3b-2cb7-4356-bf61-292c15dff9b0	2026-08-20 11:32	2026-08-20 11:32	2026-08-20 11:32	RKT	RKT261016C00016000	call	16.0000	2026-10-16	0.5800	0.5800	0.6200	14.2500	33698.00	0.00	33698.00	581	27	957	20815	0.0459764592841701	0.521060441101677	0.521060441101677	false	false	false	true
36a80db0-79ee-4467-984c-0d91ab385714	2026-08-20 11:28	2026-08-20 11:28	2026-08-20 11:28	RKT	RKT261016C00015000	call	15.0000	2026-10-16	0.9200	0.9200	0.9800	14.3350	23000.00	0.00	23000.00	250	5	1593	7666	0.207800678319854	0.515328381317264	0.515328381317264	false	false	false	true
0a79af88-b7e5-4782-840c-5246a71177dd	2026-08-20 11:27	2026-08-20 11:27	2026-08-20 11:27	RKT	RKT260828C00015000	call	15.0000	2026-08-28	0.2200	0.2200	0.2300	14.3100	52646.00	0.00	52646.00	2393	25	8987	11063	0.812347464521378	0.561318414057195	0.561318414057195	false	false	false	true
f3dcd368-1e6b-4a64-b611-a2fe7de1bddb	2026-08-20 10:02	2026-08-20 10:01	2026-08-20 10:01	RKT	RKT260821C00014000	call	14.0000	2026-08-21	0.3100	0.3100	0.3300	14.1600	40362.00	0.00	10757.00	1302	18	2359	15648	0.15075408997955	0.780675700385023	0.7480619132034	false	false	false	true
57be193b-98c9-40e6-a0bf-8a825fb8598f	2026-08-20 10:01	2026-08-20 10:01	2026-08-20 10:01	RKT	RKT260821C00014000	call	14.0000	2026-08-21	0.3100	0.3100	0.3200	14.0801	32550.00	0.00	2914.00	1050	29	1057	15648	0.0675485685071575	0.911694324767846	0.911694324767846	false	false	false	true
45a48031-4d63-4063-adf6-74eded072a48	2026-08-20 09:34	2026-08-20 09:34	2026-08-20 09:34	RKT	RKT261016C00015000	call	15.0000	2026-10-16	0.8900	0.7600	0.8900	14.1396	44500.00	44500.00	0.00	500	5	901	7666	0.117531959300809	0.54162542643328	0.54162542643328	false	false	false	true
a5027faf-d645-4ad2-835b-92eb33d8ec70	2026-08-19 15:51	2026-08-19 15:50	2026-08-19 15:50	RKT	RKT260918C00015000	call	15.0000	2026-09-18	0.7100	0.7000	0.7100	14.6050	36423.00	36423.00	0.00	513	17	2468	35232	0.0700499545867393	0.517071937171834	0.517071937171834	false	false	false	true
805c5c56-84a2-4e15-ac2c-52bc749465c0	2026-08-19 15:37	2026-08-19 15:37	2026-08-19 15:37	RKT	RKT261218C00017000	call	17.0000	2026-12-18	1.0500	1.0500	1.0700	14.6100	10500.00	0.00	1890.00	100	6	125	1654	0.0755743651753325	0.542664389794894	0.542664389794894	false	false	false	true
2b4ac1d6-559d-46c7-af62-3eb4274f6424	2026-08-19 14:45	2026-08-19 14:45	2026-08-19 14:45	RKT	RKT261120P00015000	put	15.0000	2026-11-20	1.7100	1.7100	1.7700	14.6750	104842.00	3268.00	101574.00	613	48	655	97	6.75257731958763	0.546541721455106	0.546541721455106	false	false	false	true
baaebd20-2408-41a8-91bd-5868c14cc99e	2026-08-19 13:56	2026-08-19 13:56	2026-08-19 13:56	RKT	RKT270115C00021200	call	21.2000	2027-01-15	0.4900	0.4700	0.5200	14.7201	46844.00	4116.00	23177.00	956	36	1315	11227	0.117128351295983	0.539659133454261	0.54041275639338	false	false	false	true
c74d3d00-ab89-451f-b4c6-368bed3ecc60	2026-08-19 13:56	2026-08-19 13:56	2026-08-19 13:56	RKT	RKT270115C00021200	call	21.2000	2027-01-15	0.5000	0.4700	0.5000	14.7350	10500.00	10500.00	0.00	210	10	327	11227	0.029126213592233	0.543044536769395	0.543044536769395	false	false	false	true
b147f07d-ffa9-44c4-9c69-eb744b0c93a7	2026-08-19 13:55	2026-08-19 13:55	2026-08-19 13:55	RKT	RKT270115C00016200	call	16.2000	2027-01-15	1.5700	1.5700	1.6000	14.7350	45373.00	0.00	45373.00	289	21	665	24948	0.02665544332211	0.544973623254148	0.544973623254148	false	false	false	true
efb6ab67-96ba-45fe-9d2e-4e88a5826c36	2026-08-19 13:55	2026-08-19 13:55	2026-08-19 13:55	RKT	RKT270115C00016200	call	16.2000	2027-01-15	1.5700	1.5600	1.5900	14.7250	25277.00	0.00	25277.00	161	14	244	24948	0.00978034311367645	0.546251401479023	0.546251401479023	false	false	false	true
3c3ec278-0e5b-42f6-8209-fb514a1b2068	2026-08-19 13:45	2026-08-19 13:45	2026-08-19 13:45	RKT	RKT261120C00018000	call	18.0000	2026-11-20	0.6300	0.6300	0.6900	14.6900	121905.00	0.00	121905.00	1935	40	2000	16314	0.122594090964815	0.545117472390881	0.545117472390881	false	false	false	true
014fad4d-25d1-403a-a332-8d84c581a319	2026-08-19 12:45	2026-08-19 12:44	2026-08-19 12:44	RKT	RKT261016C00015000	call	15.0000	2026-10-16	1.1700	1.1700	1.2200	14.7750	452088.00	0.00	452088.00	3864	34	5021	4843	1.03675407805079	0.524592411599596	0.524592411599596	false	false	false	true
3f44bf7f-94ae-4c91-8ef7-896b46aea696	2026-08-19 11:47	2026-08-19 11:47	2026-08-19 11:47	RKT	RKT260918P00011000	put	11.0000	2026-09-18	0.0600	0.0400	0.0600	14.8450	11358.00	11358.00	0.00	1893	32	2004	11891	0.168530821629804	0.670123267344362	0.670123267344362	false	false	false	true
5d7eca18-7b70-42e4-9fa1-0412ef07e5ad	2026-08-19 11:42	2026-08-19 11:42	2026-08-19 11:42	RKT	RKT260828C00015000	call	15.0000	2026-08-28	0.4600	0.4300	0.4600	14.8150	132986.00	132986.00	0.00	2891	17	6336	4741	1.33642691415313	0.580017150743174	0.580017150743174	false	false	false	true
7e2ae4e2-815e-455c-9fd3-4599c07a9938	2026-08-19 11:41	2026-08-19 11:41	2026-08-19 11:41	RKT	RKT260828C00015000	call	15.0000	2026-08-28	0.4500	0.4200	0.4600	14.8100	44190.00	44190.00	0.00	982	28	3336	4741	0.703649019194263	0.574241623279245	0.571726202157944	false	false	false	true
2fd4e486-838f-433d-a5a3-5b853837c860	2026-08-19 11:41	2026-08-19 11:41	2026-08-19 11:41	RKT	RKT260828C00015000	call	15.0000	2026-08-28	0.4300	0.4000	0.4400	14.7950	34787.00	34787.00	0.00	809	9	2144	4741	0.452225268930605	0.557572738167164	0.557572738167164	false	false	false	true
bed872ea-d14b-4305-962b-dd6d43957bcf	2026-08-19 11:21	2026-08-19 11:20	2026-08-19 11:20	RKT	RKT260918C00015000	call	15.0000	2026-09-18	0.8100	0.8100	0.8400	14.8000	16201.00	0.00	16201.00	200	23	663	35232	0.0188181198910082	0.52039105017742	0.52039105017742	true	false	false	true
1c77ac0e-c297-417c-ab67-a96afdaa1c7a	2026-08-19 11:20	2026-08-19 11:20	2026-08-19 11:20	RKT	RKT261016C00015000	call	15.0000	2026-10-16	1.1700	1.1700	1.2500	14.8100	23166.00	0.00	23166.00	198	6	1143	4843	0.236010737146397	0.516745291410157	0.516745291410157	false	false	false	true
237fcac7-7739-423e-bd88-f1cfb171a3e1	2026-08-19 11:10	2026-08-19 11:10	2026-08-19 11:10	RKT	RKT261218C00014000	call	14.0000	2026-12-18	2.4400	2.3300	2.4400	14.9150	30500.00	30500.00	0.00	125	5	273	608	0.449013157894737	0.560235085059394	0.560235085059394	false	false	false	true
87366007-fc73-4955-b3bb-cf161c866588	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	RKT	RKT261016C00015000	call	15.0000	2026-10-16	1.2900	1.2900	1.3300	14.9650	14706.00	0.00	14706.00	114	7	914	4843	0.188725996283295	0.532231413946949	0.532231413946949	false	false	false	true
480ab286-b4b5-45f4-b50c-0d7526b92cbf	2026-08-19 10:36	2026-08-19 10:36	2026-08-19 10:36	RKT	RKT261120P00013000	put	13.0000	2026-11-20	0.7700	0.7700	0.8200	14.9900	22176.00	0.00	22176.00	288	9	291	1944	0.149691358024691	0.57795075041503	0.57795075041503	false	false	false	true
ab6e1182-1313-4193-af0f-ed291ea7fb0c	2026-08-19 10:18	2026-08-19 10:18	2026-08-19 10:18	RKT	RKT260821C00014500	call	14.5000	2026-08-21	0.5500	0.5100	0.5900	14.9050	25740.00	25685.00	55.00	468	7	762	4828	0.157829328914664	0.698861854336518	0.698861854336518	false	false	false	true
3df697c9-b3dd-4490-872f-9bd65af6cce3	2026-08-18 14:49	2026-08-18 14:48	2026-08-18 14:48	RKT	RKT261218C00017000	call	17.0000	2026-12-18	0.8600	0.8600	0.9200	14.0550	25456.00	0.00	25456.00	296	9	306	1368	0.223684210526316	0.54424770154759	0.54424770154759	false	false	false	true