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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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 = RCL×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	expirydate

ce253cde-aa47-4e59-a7b3-2dbc7a7c9b46	2026-08-17 11:53	2026-08-17 11:53	2026-08-17 11:53	RCL	RCL261120P00300000	put	300.0000	2026-11-20	22.7000	22.7000	23.6000	303.4100	145280.00	0.00	145280.00	64	18	66	21	3.14285714285714	0.422854115268939	0.422854115268939	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	68291215129.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
314c3097-a636-4fe7-ae7c-2c35e4dfd154	2026-08-17 15:03	2026-08-17 15:02	2026-08-17 15:02	RCL	RCL261016P00310000	put	310.0000	2026-10-16	22.8000	22.8000	23.6000	301.4600	129960.00	0.00	129960.00	57	17	59	80	0.7375	0.392322993592599	0.392322993592599	false	false	false	true
6da3477c-3bca-40a6-a2d8-c1aaf6ce66ae	2026-08-18 12:28	2026-08-18 12:28	2026-08-18 12:28	RCL	RCL261016P00300000	put	300.0000	2026-10-16	16.8000	16.8000	17.7000	302.0000	63840.00	0.00	63840.00	38	16	46	137	0.335766423357664	0.388099496262152	0.388099496262152	false	false	false	true
8e20936b-7054-44c2-a656-e2857c1e3b88	2026-08-19 12:06	2026-08-19 12:06	2026-08-19 12:06	RCL	RCL261016P00300000	put	300.0000	2026-10-16	16.9000	16.9000	17.2000	301.7200	81120.00	0.00	81120.00	48	6	53	184	0.28804347826087	0.390626551162376	0.390626551162376	false	false	false	true
ddd189e2-684c-4ee1-80f1-a83eae878057	2026-08-20 11:38	2026-08-20 11:38	2026-08-20 11:38	RCL	RCL270917C00260000	call	260.0000	2027-09-17	69.2000	69.2000	72.5000	291.4900	76120.00	0.00	76120.00	11	5	11	4	2.75	0.401469993770897	0.401469993770897	false	false	false	true
53273109-d8de-4ce8-b89d-685d6b7f59af	2026-08-20 13:52	2026-08-20 13:52	2026-08-20 13:52	RCL	RCL260918P00290000	put	290.0000	2026-09-18	12.3000	11.6000	12.4000	289.3650	73800.00	49200.00	24600.00	60	8	80	1114	0.0718132854578097	0.381901315229262	0.381901315229262	false	false	false	true
4efc1171-c3d1-4ddb-b7e1-8fa1dd75dd14	2026-08-21 15:55	2026-08-21 15:55	2026-08-21 15:55	RCL	RCL260821C00280000	call	280.0000	2026-08-21	12.0000	10.8000	12.0000	292.3900	357600.00	163200.00	0.00	298	5	300	317	0.946372239747634	4.06165388695519	4.06165388695519	false	false	false	true
14ea0568-6b2c-466d-ac82-6d6aed8c569d	2026-08-26 09:31	2026-08-26 09:31	2026-08-26 09:31	RCL	RCL261120C00330000	call	330.0000	2026-11-20	11.1000	11.1000	11.8000	293.7750	136530.00	0.00	124320.00	123	12	123	7	17.5714285714286	0.4031432557806	0.4031432557806	false	false	false	true
ad6487de-2c71-41aa-ae77-62471d549d86	2026-08-26 09:31	2026-08-26 09:31	2026-08-26 09:31	RCL	RCL261120C00330000	call	330.0000	2026-11-20	11.4000	11.4000	12.7000	294.7650	102600.00	0.00	34200.00	90	5	213	7	30.4285714285714	0.402638933501302	0.402638933501302	false	false	false	true
d3d77b56-7fe5-4768-bcd2-b75efd7fb8a5	2026-08-26 09:31	2026-08-26 09:31	2026-08-26 09:31	RCL	RCL261120C00330000	call	330.0000	2026-11-20	12.1000	12.1000	12.3000	295.7200	254100.00	0.00	254100.00	210	9	1084	7	154.857142857143	0.409856131768331	0.409856131768331	false	false	false	true
6ef5ee02-0dd4-4459-aa95-6d200bcc6c30	2026-08-26 09:31	2026-08-26 09:31	2026-08-26 09:31	RCL	RCL261120C00330000	call	330.0000	2026-11-20	12.1000	12.1000	12.4000	296.2350	250470.00	0.00	194810.00	207	9	874	7	124.857142857143	0.406511494767978	0.406511494767978	false	false	false	true
f26b0c84-0bfc-4f36-9213-a851c7bb77f4	2026-08-27 14:59	2026-08-27 14:59	2026-08-27 14:59	RCL	RCL261120P00290000	put	290.0000	2026-11-20	25.1000	24.1000	25.1000	285.1550	253510.00	253510.00	0.00	101	19	343	35	9.8	0.434414933141139	0.434414933141139	false	false	false	true
bc7670a0-6751-419d-b9d3-17f9ca9208b4	2026-08-28 10:55	2026-08-28 10:55	2026-08-28 10:55	RCL	RCL280121P00195000	put	195.0000	2028-01-21	17.8000	17.8000	19.3000	284.1000	80100.00	0.00	80100.00	45	27	45	14	3.21428571428571	0.500836073643718	0.500836073643718	false	false	false	true
2ee45326-cea0-4ee1-bec8-d6d4669486dc	2026-08-31 10:53	2026-08-31 10:53	2026-08-31 10:53	RCL	RCL260918P00280000	put	280.0000	2026-09-18	12.9000	12.9000	14.1000	272.1600	356040.00	0.00	356040.00	276	25	288	1041	0.276657060518732	0.358779588367156	0.358779588367156	false	false	false	true
f17e9075-ef77-423e-83de-899a6eebb12c	2026-08-31 15:43	2026-08-31 15:43	2026-08-31 15:43	RCL	RCL270115P00250000	put	250.0000	2027-01-15	17.8000	17.4000	17.8000	268.0813	231399.00	231399.00	0.00	130	13	147	342	0.429824561403509	0.43374973190188	0.43374973190188	false	false	false	true
14a50a30-85a2-498f-8ebc-33e6e6c1a692	2026-09-01 14:29	2026-09-01 14:29	2026-09-01 14:29	RCL	RCL261218C00280000	call	280.0000	2026-12-18	18.7000	18.3000	18.8000	266.6350	78540.00	76670.00	0.00	42	15	62	111	0.558558558558559	0.397804750800029	0.397804750800029	false	false	false	true
1c93edf2-067c-42cd-bd95-75bd796b32e1	2026-09-03 13:52	2026-09-03 13:52	2026-09-03 13:52	RCL	RCL270917P00230000	put	230.0000	2027-09-17	27.1500	27.1000	28.1000	264.6047	176475.00	0.00	176475.00	65	5	65	70	0.928571428571429	0.474703130479565	0.474703130479565	false	false	false	true
ba71c6ff-8fe9-4145-b8b4-6bb128c31868	2026-09-09 09:34	2026-09-09 09:34	2026-09-09 09:34	RCL	RCL261120C00330000	call	330.0000	2026-11-20	2.6500	2.4000	2.6500	261.3800	73935.00	55915.00	0.00	279	16	781	2230	0.350224215246637	0.405451378063871	0.405451378063871	false	false	false	true
bb1a622b-a97c-47a0-a951-69e21a8b09a6	2026-09-09 09:35	2026-09-09 09:35	2026-09-09 09:35	RCL	RCL261120C00330000	call	330.0000	2026-11-20	2.6000	2.5000	2.6000	261.3580	67600.00	50440.00	0.00	260	12	1063	2230	0.476681614349776	0.403437675571273	0.403437675571273	false	false	false	true
54543521-2f01-424e-89a2-63a9f9661736	2026-09-09 09:35	2026-09-09 09:35	2026-09-09 09:35	RCL	RCL261120C00330000	call	330.0000	2026-11-20	2.5500	2.5500	2.6500	261.3700	89620.00	5980.00	83640.00	351	16	1414	2230	0.634080717488789	0.401229701458318	0.403375464090138	false	false	false	true
19bb9d25-49ac-47f5-934d-d8fd5cd25c5c	2026-09-09 09:35	2026-09-09 09:35	2026-09-09 09:35	RCL	RCL261120C00330000	call	330.0000	2026-11-20	2.4000	2.3500	2.4000	260.6150	53520.00	8640.00	0.00	223	20	2212	2230	0.991928251121076	0.398539614971942	0.398539614971942	false	false	false	true
95a6cdd1-06a2-4693-bfac-c75496aac8d2	2026-09-09 15:20	2026-09-09 15:20	2026-09-09 15:20	RCL	RCL270617P00185000	put	185.0000	2027-06-17	9.9500	9.9000	10.2000	259.1100	124375.00	0.00	124375.00	125	6	126	1	126	0.490888738688415	0.490888738688415	false	false	false	true
83ec54f5-7fd4-40d8-a2aa-3746d29ed7ec	2026-09-09 15:20	2026-09-09 15:20	2026-09-09 15:20	RCL	RCL270617C00350000	call	350.0000	2027-06-17	12.8500	11.9000	13.5000	259.1250	96375.00	16705.00	79670.00	75	7	77	57	1.35087719298246	0.395874128403624	0.395874128403624	false	false	false	true
63e85f2f-a52f-4393-92a8-4e3a95759287	2026-09-15 14:28	2026-09-15 14:28	2026-09-15 14:28	RCL	RCL270617P00240000	put	240.0000	2027-06-17	29.6200	29.6000	30.8000	250.4500	59240.00	3000.00	56240.00	20	10	20	34	0.588235294117647	0.458142560606503	0.458142560606503	false	false	false	true
ef4a7c66-dc85-49ee-9400-8f33d332edf1	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	RCL	RCL270319P00260000	put	260.0000	2027-03-19	33.1000	32.6500	33.2000	250.0000	76130.00	23170.00	0.00	23	15	92	180	0.511111111111111	0.436299512685248	0.436299512685248	false	false	false	true
19540352-11d7-4db5-a8a8-1401744307f6	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	RCL	RCL270319P00260000	put	260.0000	2027-03-19	33.0000	32.1000	33.3000	250.0000	75900.00	3300.00	69300.00	23	17	69	180	0.383333333333333	0.434872822950032	0.434872822950032	true	false	false	true
1e6adace-de69-44c1-8c5c-f13ac49dcb95	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	RCL	RCL270319P00260000	put	260.0000	2027-03-19	32.7000	32.4000	32.7000	250.6050	111180.00	94830.00	0.00	34	18	139	180	0.772222222222222	0.434561118523583	0.434561118523583	false	false	false	true
9dafc058-e445-4851-8298-cb53b2e2cf9d	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	RCL	RCL270319P00260000	put	260.0000	2027-03-19	32.4000	32.3000	32.4000	250.8700	113400.00	32400.00	0.00	35	18	256	180	1.42222222222222	0.432016930990627	0.432016930990627	false	false	false	true
da9ce13e-251d-488d-9bc9-b26f5a551073	2026-09-18 09:38	2026-09-18 09:38	2026-09-18 09:38	RCL	RCL261016C00260000	call	260.0000	2026-10-16	6.4000	6.4000	7.0000	248.2600	76800.00	0.00	76800.00	120	24	131	313	0.4185303514377	0.393319865870516	0.393319865870516	true	false	false	true
acd13c72-5692-4f67-b1f6-fb6d527ec894	2026-09-18 11:19	2026-09-18 11:19	2026-09-18 11:19	RCL	RCL280121P00170000	put	170.0000	2028-01-21	14.1000	14.1000	15.3000	248.1500	71910.00	0.00	71910.00	51	15	51	14	3.64285714285714	0.494210122759781	0.494210122759781	false	false	false	true
0caa86a6-f7e7-4d87-b943-1bcef75f131a	2026-09-21 10:34	2026-09-21 10:34	2026-09-21 10:34	RCL	RCL261218P00250000	put	250.0000	2026-12-18	19.9000	18.9000	19.9000	248.9350	13930.00	13930.00	0.00	7	6	12	12848	0.000933997509339975	0.424450264549501	0.424450264549501	false	false	false	true
d959193e-f2ae-4a0d-af61-2c0ac9e6bdf1	2026-09-21 10:48	2026-09-21 10:48	2026-09-21 10:48	RCL	RCL261218P00210000	put	210.0000	2026-12-18	5.7000	5.2000	6.1000	248.9200	24510.00	24510.00	0.00	43	8	49	376	0.13031914893617	0.444739629397795	0.444740185174756	false	false	false	true
9f75d355-7857-4fda-a594-5efc1272adae	2026-09-21 11:07	2026-09-21 11:07	2026-09-21 11:07	RCL	RCL261218P00230000	put	230.0000	2026-12-18	11.4000	11.3000	11.8000	248.3750	34200.00	33060.00	1140.00	30	7	33	189	0.174603174603175	0.431269195204152	0.431269195204152	false	false	false	true
d2d115c8-125b-4c6a-bc30-7555b6f75717	2026-09-22 09:38	2026-09-22 09:38	2026-09-22 09:38	RCL	RCL261002C00270000	call	270.0000	2026-10-02	3.2000	2.6000	3.2000	259.4200	51513.00	51513.00	0.00	161	29	166	951	0.174553101997897	0.412578596814837	0.412578596814837	false	false	false	true
662e72ba-cb56-48fb-a7a7-65304820b7db	2026-09-22 09:39	2026-09-22 09:38	2026-09-22 09:38	RCL	RCL261120P00260000	put	260.0000	2026-11-20	17.0000	17.0000	18.5000	260.3700	85000.00	0.00	85000.00	50	6	50	147	0.340136054421769	0.433889629623283	0.433889629623283	false	false	false	true
4f10b29d-6d26-4519-8f7d-a921982d2da1	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	RCL	RCL261002P00267500	put	267.5000	2026-10-02	15.6000	15.6000	17.5000	253.2950	20280.00	0.00	20280.00	13	6	23	0	0	0.370458504124222	0.370458504124222	false	false	false	true
e10289c8-c01c-4a34-8b72-90bfff2f541c	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	RCL	RCL261002C00255000	call	255.0000	2026-10-02	7.7000	6.9000	7.7000	255.5800	30800.00	30800.00	0.00	40	14	104	72	1.44444444444444	0.431210121578813	0.431210121578813	false	false	false	true
0d32f1b1-4f3c-46c8-a757-e938826d4f29	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	RCL	RCL261002C00257500	call	257.5000	2026-10-02	6.6000	5.2000	6.6000	255.5800	28380.00	28380.00	0.00	43	17	44	0	0	0.436658465281201	0.436658465281201	false	false	false	true
d90abb46-d48c-4284-825d-800989946891	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	RCL	RCL261002C00255000	call	255.0000	2026-10-02	8.0000	7.1000	8.0000	255.9100	72800.00	72800.00	0.00	91	26	195	72	2.70833333333333	0.438521959916791	0.438521959916791	false	false	false	true
14916dcb-c0cc-4b01-9b45-a35cbe9cf763	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	RCL	RCL261002C00257500	call	257.5000	2026-10-02	6.8000	5.9000	6.8000	255.9100	29919.00	29919.00	0.00	44	19	88	0	0	0.43906962894786	0.43906962894786	false	false	false	true
5323a20e-d568-4d62-b214-7ca49f7a0905	2026-09-22 14:15	2026-09-22 14:14	2026-09-22 14:14	RCL	RCL260925C00240000	call	240.0000	2026-09-25	11.6100	10.9000	14.2000	250.6900	23220.00	0.00	23220.00	20	7	21	13	1.61538461538462	0.455502862015084	0.473923454094044	false	false	false	true
47e441b0-aa8a-43f3-8a8e-73d980d343e8	2026-09-22 14:16	2026-09-22 14:16	2026-09-22 14:16	RCL	RCL261120C00230000	call	230.0000	2026-11-20	28.0000	28.0000	30.8000	249.0300	84000.00	0.00	84000.00	30	6	31	4	7.75	0.4086603245944	0.4086603245944	false	false	false	true
41482f44-be46-482c-97f8-b2b0233dab07	2026-09-22 14:16	2026-09-22 14:16	2026-09-22 14:16	RCL	RCL260925C00215000	call	215.0000	2026-09-25	31.4000	31.2000	35.5000	246.1100	91060.00	12560.00	78500.00	29	8	29	0	0	0.945883273919437	0.813197742553741	false	false	false	true
be42c015-f4b1-4f29-9b48-8fd53a6c030a	2026-09-22 14:27	2026-09-22 14:27	2026-09-22 14:27	RCL	RCL261218P00260000	put	260.0000	2026-12-18	32.0000	29.5000	32.0000	238.0100	64000.00	64000.00	0.00	20	6	40	247	0.161943319838057	0.433565131800977	0.433565131800977	false	false	false	true
c1cb7d93-7ac2-4b67-a198-dfaeee217d93	2026-09-22 14:32	2026-09-22 14:32	2026-09-22 14:32	RCL	RCL270115C00260000	call	260.0000	2027-01-15	14.2000	13.7000	15.0000	237.3500	18460.00	15620.00	2840.00	13	12	58	227	0.255506607929515	0.40803388996369	0.40803388996369	false	false	false	true
b319dfb6-f08d-40c5-8e32-4a9c70152605	2026-09-22 14:33	2026-09-22 14:32	2026-09-22 14:32	RCL	RCL261002C00240000	call	240.0000	2026-10-02	7.3000	6.9500	7.7000	237.7800	144540.00	0.00	127020.00	198	19	219	3	73	0.522985076153251	0.522985076153251	false	false	false	true
372908b6-c9bd-4f6d-95a5-bf6785b4bd15	2026-09-22 14:33	2026-09-22 14:33	2026-09-22 14:33	RCL	RCL261002C00240000	call	240.0000	2026-10-02	7.3000	6.2000	8.0000	237.3000	18980.00	4380.00	8030.00	26	5	266	3	88.6666666666667	0.537567820373837	0.537567820373837	false	false	false	true
57d8b71f-4eb7-4021-9071-1ee54fbb3231	2026-09-22 14:33	2026-09-22 14:33	2026-09-22 14:33	RCL	RCL260925P00230000	put	230.0000	2026-09-25	2.7000	2.7000	3.8000	237.2135	10800.00	0.00	10800.00	40	5	68	37	1.83783783783784	0.663844408185883	0.663844408185883	false	false	false	true
6a599559-f73e-4656-975b-aab8a5e42850	2026-09-22 14:33	2026-09-22 14:33	2026-09-22 14:33	RCL	RCL261002C00240000	call	240.0000	2026-10-02	7.2000	7.2000	7.7000	237.1525	108000.00	0.00	18000.00	150	15	416	3	138.666666666667	0.535607990932763	0.535607990932763	false	false	false	true
3fdea4ed-6aa8-4457-80da-1bd72153bfba	2026-09-22 14:33	2026-09-22 14:33	2026-09-22 14:33	RCL	RCL261002C00240000	call	240.0000	2026-10-02	7.2000	7.2000	7.6000	237.2200	62640.00	0.00	62640.00	87	8	503	3	167.666666666667	0.532375020993721	0.533579019253544	false	false	false	true