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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×sector = Consumer Cyclical×ticker = RCL×

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

f2dc3955-1155-4525-a7f0-48e9ae3f00ca	2026-09-23 15:46	2026-09-23 15:46	2026-09-23 15:46	RCL	RCL270917P00230000	put	230.0000	2027-09-17	37.8000	36.5000	37.8000	228.0000	34020.00	34020.00	0.00	9	5	57	37	1.54054054054054	0.47690197593846	0.47690197593846	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	61594214945.00	2026-10-27	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
13f356b3-bc5e-417e-884e-1239c83c4dba	2026-09-23 15:36	2026-09-23 15:36	2026-09-23 15:36	RCL	RCL270319C00270000	call	270.0000	2027-03-19	14.7000	14.4000	15.3000	229.5956	14700.00	2940.00	11760.00	10	5	66	94	0.702127659574468	0.422574585762689	0.422574585762689	false	false	false
76e8236f-ddd7-4991-94bf-ce1b97daf0ee	2026-09-23 15:18	2026-09-23 15:18	2026-09-23 15:18	RCL	RCL261030P00235000	put	235.0000	2026-10-30	17.8000	16.4000	19.3000	227.8350	30260.00	26700.00	3560.00	17	5	32	32	1	0.494656278784955	0.494656278784955	false	false	false	true
bb28715b-87a6-4e85-b79d-f9f16d3e98d2	2026-09-23 14:45	2026-09-23 14:45	2026-09-23 14:45	RCL	RCL270917P00230000	put	230.0000	2027-09-17	38.0000	37.4000	39.1000	227.4950	125400.00	57000.00	68400.00	33	12	36	37	0.972972972972973	0.473492935353036	0.473492935353036	false	false	false
85873f18-82a3-4e0b-a2c6-d1baaa2d3743	2026-09-23 14:23	2026-09-23 14:23	2026-09-23 14:23	RCL	RCL270617C00250000	call	250.0000	2027-06-17	27.2000	26.6000	27.2000	227.0000	27200.00	27200.00	0.00	10	9	51	61	0.836065573770492	0.428009646471858	0.428009646471858	false	false	false
88cf97ac-8cc3-4ed9-9a66-4cc726105fdd	2026-09-23 13:48	2026-09-23 13:48	2026-09-23 13:48	RCL	RCL270917C00280000	call	280.0000	2027-09-17	23.9000	23.4000	23.9000	226.8850	76480.00	76480.00	0.00	32	7	37	265	0.139622641509434	0.425516383430209	0.425516383430209	false	false	false
02158b3e-c481-44e1-83ae-2065410bd405	2026-09-23 13:20	2026-09-23 13:20	2026-09-23 13:20	RCL	RCL270319C00310000	call	310.0000	2027-03-19	6.7000	6.6000	6.7000	227.1800	10720.00	10720.00	0.00	16	5	38	57	0.666666666666667	0.425561884873836	0.425561884873836	false	false	false
21a3fb1f-d1ff-4fe3-b2ce-2131476297df	2026-09-23 13:08	2026-09-23 13:08	2026-09-23 13:08	RCL	RCL280121C00330000	call	330.0000	2028-01-21	19.3500	17.9000	20.6000	226.2300	19350.00	15480.00	3870.00	10	5	11	23	0.478260869565217	0.417560706390503	0.417560706390503	false	false	false
1820003f-9efc-423e-a016-c777f0b6548c	2026-09-23 13:07	2026-09-23 13:07	2026-09-23 13:07	RCL	RCL261002C00235000	call	235.0000	2026-10-02	3.2000	2.8500	3.7000	226.0700	26880.00	8640.00	4160.00	84	7	175	115	1.52173913043478	0.461988263742619	0.461988263742619	false	false	false
823b02fe-9545-4baf-b506-e6d65fb43da9	2026-09-23 13:07	2026-09-23 13:07	2026-09-23 13:07	RCL	RCL261002C00230000	call	230.0000	2026-10-02	5.0000	4.7000	5.0000	226.0700	49500.00	2000.00	0.00	99	32	264	224	1.17857142857143	0.468654163304159	0.468654163304159	false	false	false
48d913f5-29de-4dfd-9f03-d9d6262d7abd	2026-09-23 11:59	2026-09-23 11:59	2026-09-23 11:59	RCL	RCL280121C00300000	call	300.0000	2028-01-21	25.5000	25.5000	26.3000	228.1550	40800.00	0.00	40800.00	16	5	50	212	0.235849056603774	0.411184452693697	0.411184452693697	false	false	false
bb8c8533-4f2c-4aff-9758-146c6219966d	2026-09-23 11:07	2026-09-23 11:07	2026-09-23 11:07	RCL	RCL270917P00165000	put	165.0000	2027-09-17	11.6300	11.6000	12.1000	228.1500	22090.00	1210.00	20880.00	19	13	19	11	1.72727272727273	0.487025850346003	0.496138745069318	false	false	false
cc2caad6-83a1-41e5-b825-d697bfa95049	2026-09-23 11:07	2026-09-23 11:07	2026-09-23 11:07	RCL	RCL270917P00150000	put	150.0000	2027-09-17	8.2300	8.2000	9.3000	227.9600	37880.00	0.00	37880.00	46	13	113	7	16.1428571428571	0.496978349331147	0.496978349331147	false	false	false
8dc51b5e-8871-44f6-ab38-6c7b9db862b6	2026-09-23 11:07	2026-09-23 11:07	2026-09-23 11:07	RCL	RCL270917P00150000	put	150.0000	2027-09-17	8.2000	8.1000	9.5000	227.9600	26240.00	0.00	26240.00	32	16	67	7	9.57142857142857	0.497875459069558	0.496978349331147	false	false	false
4d5b32cc-f390-4d77-856a-3b6ef39ec2b8	2026-09-23 11:07	2026-09-23 11:07	2026-09-23 11:07	RCL	RCL270917P00150000	put	150.0000	2027-09-17	8.2000	8.2000	9.3000	227.9100	27060.00	0.00	27060.00	33	13	33	7	4.71428571428571	0.49654222299805	0.496846242673224	false	false	false	true
bbd519ff-5b15-4fd2-8cc9-7c4a7c25bd6f	2026-09-23 10:58	2026-09-23 10:58	2026-09-23 10:58	RCL	RCL290119P00210000	put	210.0000	2029-01-19	43.7500	41.0000	45.5000	227.0000	21875.00	21875.00	0.00	5	5	15	5	3	0.499882960274267	0.499882960274267	false	false	false	true
7496c0b9-4305-44bf-b986-40152f2350f9	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	RCL	RCL260925C00220000	call	220.0000	2026-09-25	8.0000	7.0000	8.0000	225.7350	24000.00	24000.00	0.00	30	9	56	1	56	0.689083469265732	0.689083469265732	false	false	false	true
9bc13b93-37c5-4c46-8e14-88e09ff2ca39	2026-09-23 10:48	2026-09-23 10:48	2026-09-23 10:48	RCL	RCL270319P00190000	put	190.0000	2027-03-19	12.2500	11.1000	12.4000	225.6664	245000.00	245000.00	0.00	200	2	212	29	7.31034482758621	0.486003601252116	0.486003601252116	false	true	false
a1a205ad-1596-4f11-835c-d06fba087237	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	RCL	RCL261120P00220000	put	220.0000	2026-11-20	13.9000	13.6000	14.5000	224.0000	13900.00	8340.00	5560.00	10	6	17	171	0.0994152046783626	0.473509150734562	0.472187225547863	true	false	false
97f77a2e-bcfd-4858-9fad-ff1975668a1f	2026-09-23 09:46	2026-09-23 09:46	2026-09-23 09:46	RCL	RCL270115C00250000	call	250.0000	2027-01-15	13.0000	12.2000	14.3000	225.0000	53300.00	46800.00	6500.00	41	12	116	561	0.206773618538324	0.423091720225733	0.423091720225733	false	false	false
ddb9ea18-de44-4a16-8d09-464fefb6515a	2026-09-22 15:50	2026-09-22 15:50	2026-09-22 15:50	RCL	RCL260925C00232500	call	232.5000	2026-09-25	8.0000	6.7000	8.0000	237.2000	69600.00	69600.00	0.00	87	16	190	0	0	0.620824198714609	0.620824198714609	false	false	false	true
74be5a3d-2229-4363-8b65-9788e876db1c	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	RCL	RCL261016C00250000	call	250.0000	2026-10-16	5.5000	5.5000	5.9000	236.7000	55000.00	0.00	55000.00	100	5	163	78	2.08974358974359	0.428744548800931	0.428744548800931	false	false	false
8789de0e-6109-4e26-af8b-fb2fc24fd9ce	2026-09-22 15:41	2026-09-22 15:41	2026-09-22 15:41	RCL	RCL261120P00230000	put	230.0000	2026-11-20	13.5000	13.5000	14.5000	236.1400	12150.00	0.00	12150.00	9	5	50	146	0.342465753424658	0.458447497123181	0.458447497123181	false	false	false
8d833dc5-943d-405b-92b8-51ea7490b4f2	2026-09-22 15:31	2026-09-22 15:31	2026-09-22 15:31	RCL	RCL261120C00270000	call	270.0000	2026-11-20	5.9000	5.9000	6.6000	234.0000	72572.00	0.00	72572.00	123	31	772	315	2.45079365079365	0.442136477854938	0.442136477854938	false	false	false
139775a8-49a8-4fed-9f6d-232de39107c5	2026-09-22 15:30	2026-09-22 15:30	2026-09-22 15:30	RCL	RCL261016C00240000	call	240.0000	2026-10-16	8.5000	7.6000	9.0000	235.0000	12750.00	2550.00	10200.00	15	5	139	354	0.392655367231638	0.434112536256638	0.434112536256638	false	false	false
3ccd9a8c-f729-47c0-b244-753482505f80	2026-09-22 15:23	2026-09-22 15:23	2026-09-22 15:23	RCL	RCL261002C00230000	call	230.0000	2026-10-02	9.8000	9.0000	9.8000	233.2100	34300.00	34300.00	0.00	35	5	145	1	145	0.520327327951178	0.520327327951178	false	false	false	true
dbdb9528-036f-4fd0-a66d-4bce2cca5108	2026-09-22 15:23	2026-09-22 15:23	2026-09-22 15:23	RCL	RCL261002C00230000	call	230.0000	2026-10-02	9.8000	9.0000	9.8000	233.3363	34300.00	20580.00	0.00	35	5	110	1	110	0.51539427592386	0.51539427592386	false	false	false	true
3d846bee-04fc-42c5-a51c-49d52d82889a	2026-09-22 15:18	2026-09-22 15:18	2026-09-22 15:18	RCL	RCL270319P00220000	put	220.0000	2027-03-19	20.0000	20.0000	21.2000	232.4850	200000.00	0.00	180000.00	100	6	103	281	0.366548042704626	0.445619679478189	0.445619679478189	false	false	false
45222fae-c831-45a0-beb9-f27500513340	2026-09-22 15:16	2026-09-22 15:15	2026-09-22 15:15	RCL	RCL261002C00230000	call	230.0000	2026-10-02	9.1000	8.6000	9.3000	231.9700	10010.00	3640.00	1820.00	11	5	29	1	29	0.5210743757001	0.5210743757001	false	false	false	true
7ed31ece-577e-424a-9ce7-91dcb69b59e6	2026-09-22 14:58	2026-09-22 14:58	2026-09-22 14:58	RCL	RCL261016C00240000	call	240.0000	2026-10-16	8.5000	7.8000	9.3000	234.8500	15300.00	3400.00	2550.00	18	5	118	354	0.333333333333333	0.437641744989106	0.437641744989106	false	false	false
8a1bf20d-660b-4e13-93ab-009b98b513f5	2026-09-22 14:57	2026-09-22 14:57	2026-09-22 14:57	RCL	RCL261002C00240000	call	240.0000	2026-10-02	6.5000	6.0000	7.0000	236.2800	12350.00	1950.00	5200.00	19	5	717	3	239	0.516356008543626	0.516356008543626	false	false	false	true
977bdc38-c645-4808-b672-c71d8c495b24	2026-09-22 14:57	2026-09-22 14:57	2026-09-22 14:57	RCL	RCL261002C00240000	call	240.0000	2026-10-02	6.3000	5.8000	6.6000	236.2400	20160.00	3780.00	8190.00	32	5	698	3	232.666666666667	0.504584602899216	0.504584602899216	false	false	false
93c14ac5-022f-43ba-a939-ee981c0ef89f	2026-09-22 14:52	2026-09-22 14:52	2026-09-22 14:52	RCL	RCL261002C00235000	call	235.0000	2026-10-02	8.2000	8.2000	8.7000	235.4950	26240.00	0.00	26240.00	32	10	71	0	0	0.503784139898945	0.503784139898945	false	false	false	true
9d94e34b-665f-45e9-ab44-f609a9e2da68	2026-09-22 14:52	2026-09-22 14:52	2026-09-22 14:52	RCL	RCL261002C00235000	call	235.0000	2026-10-02	8.3000	7.7000	9.0000	235.3998	27390.00	5810.00	9960.00	33	5	36	0	0	0.513496216303212	0.513496216303212	false	false	false	true
11173610-6cfb-4c4f-b335-e259e8c3f8af	2026-09-22 14:49	2026-09-22 14:49	2026-09-22 14:49	RCL	RCL261002C00240000	call	240.0000	2026-10-02	5.3000	5.3000	6.0000	234.2900	10070.00	0.00	10070.00	19	6	659	3	219.666666666667	0.49347060730975	0.49347060730975	false	false	false
8e965e8a-c3ec-4809-baa0-c5b0687a8799	2026-09-22 14:49	2026-09-22 14:49	2026-09-22 14:49	RCL	RCL261002C00240000	call	240.0000	2026-10-02	5.3000	5.1000	6.0000	234.2900	10600.00	2120.00	4240.00	20	5	640	3	213.333333333333	0.49347060730975	0.49347060730975	false	false	false
d892b6e5-d2af-4722-a8d6-b4992c8fd5a3	2026-09-22 14:49	2026-09-22 14:49	2026-09-22 14:49	RCL	RCL261002C00240000	call	240.0000	2026-10-02	5.4000	5.3000	6.0000	234.2800	16740.00	3240.00	3240.00	31	5	620	3	206.666666666667	0.500391055834364	0.500391055834364	false	false	false
ea5729db-3d02-4a5b-b53f-d6d067b5ff83	2026-09-22 14:49	2026-09-22 14:49	2026-09-22 14:49	RCL	RCL261002C00240000	call	240.0000	2026-10-02	5.8000	5.3000	6.1000	234.8200	27260.00	27260.00	0.00	47	5	589	3	196.333333333333	0.512089753922529	0.512089753922529	false	false	false
28da3c1a-8800-4725-8444-c9012099a52e	2026-09-22 14:36	2026-09-22 14:36	2026-09-22 14:36	RCL	RCL260925P00235000	put	235.0000	2026-09-25	3.9000	3.4000	4.0000	238.6000	108810.00	780.00	108030.00	279	22	397	200	1.985	0.647691063328569	0.647691063328569	false	false	false	true
ce5f6531-670e-42bc-b458-86ed25f16542	2026-09-22 14:35	2026-09-22 14:35	2026-09-22 14:35	RCL	RCL261218P00230000	put	230.0000	2026-12-18	14.4000	14.4000	15.3000	240.0500	86400.00	0.00	86400.00	60	8	74	167	0.44311377245509	0.439093941704325	0.439093941704325	false	false	false
c7c2dd85-ba50-454b-8018-5194d66d0540	2026-09-22 14:34	2026-09-22 14:34	2026-09-22 14:34	RCL	RCL261009C00247500	call	247.5000	2026-10-09	5.4500	5.4000	6.4000	237.5300	37080.00	2850.00	34230.00	68	6	68	0	0	0.466485183285882	0.466485183285882	false	false	false	true
1c61e419-5f3a-423c-a4f6-21f5c30ba7cf	2026-09-22 14:34	2026-09-22 14:34	2026-09-22 14:34	RCL	RCL261009C00252500	call	252.5000	2026-10-09	4.1000	3.9000	5.5000	237.5300	51250.00	47560.00	1230.00	125	21	125	0	0	0.459209634945986	0.459209634945986	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
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
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
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
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
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
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
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