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

9d405d9f-283b-4b43-91f0-96e17c131567	2026-08-17 12:09	2026-08-17 12:09	2026-08-17 12:09	CAVA	CAVA260821P00071000	put	71.0000	2026-08-21	1.3400	1.3100	1.8400	71.3900	22111.00	11524.00	10587.00	165	19	356	82	4.34146341463415	0.518332695575208	0.52171766219677	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	6411492208.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
65bc2f4f-dbaf-49a6-9720-52bc9e3fd949	2026-08-17 13:21	2026-08-17 13:21	2026-08-17 13:21	CAVA	CAVA270319C00100000	call	100.0000	2027-03-19	4.5500	4.4000	4.5500	71.9250	23205.00	23205.00	0.00	51	7	83	70	1.18571428571429	0.539247144314753	0.539247144314753	false	false	false	true
ba84a2aa-12ac-4a73-9aa0-9947aefdc1a8	2026-08-18 10:25	2026-08-18 10:25	2026-08-18 10:25	CAVA	CAVA260918P00070000	put	70.0000	2026-09-18	3.5500	3.5500	3.7000	70.4430	12780.00	0.00	12780.00	36	5	68	5063	0.0134307722694055	0.475865668534671	0.475865668534671	true	false	false	true
8557755f-5452-4bed-b011-9bff61becfd8	2026-08-18 10:25	2026-08-18 10:25	2026-08-18 10:25	CAVA	CAVA261016P00075000	put	75.0000	2026-10-16	7.9000	7.9000	8.1500	70.4430	73470.00	0.00	73470.00	93	6	94	428	0.219626168224299	0.483931643086367	0.483931643086367	true	false	false	true
04c537d8-2564-4afc-b289-fc09ad2f11f5	2026-08-18 13:18	2026-08-18 13:18	2026-08-18 13:18	CAVA	CAVA270115C00060000	call	60.0000	2027-01-15	15.3500	15.3500	16.2500	69.7650	23025.00	0.00	23025.00	15	5	15	424	0.035377358490566	0.549526503400961	0.549526503400961	false	false	false	true
55cbfdea-4571-4692-974f-6e098f0310d5	2026-08-18 14:48	2026-08-18 14:48	2026-08-18 14:48	CAVA	CAVA270115C00080000	call	80.0000	2027-01-15	5.7000	5.7000	6.0000	68.9900	71830.00	0.00	71830.00	126	11	131	1051	0.124643196955281	0.520094801231392	0.522242654054744	false	false	false	true
6cbe8811-2123-462e-98f4-47786189920a	2026-08-19 09:48	2026-08-19 09:48	2026-08-19 09:48	CAVA	CAVA260918C00075000	call	75.0000	2026-09-18	3.2000	2.8200	3.4000	72.8300	22400.00	21120.00	1280.00	70	17	71	1070	0.0663551401869159	0.485690423983403	0.485690423983403	false	false	false	true
0d4d9d4c-fa08-4306-8042-f870bf237aeb	2026-08-19 13:57	2026-08-19 13:57	2026-08-19 13:57	CAVA	CAVA260918P00065000	put	65.0000	2026-09-18	1.1000	1.1000	1.1300	73.2100	16500.00	0.00	16500.00	150	5	201	1365	0.147252747252747	0.503419395190074	0.503419395190074	false	false	false	true
570f2e22-c21b-4b01-a0b9-db225b1b746e	2026-08-20 11:39	2026-08-20 11:39	2026-08-20 11:39	CAVA	CAVA260918P00065000	put	65.0000	2026-09-18	1.2600	1.0700	1.4400	72.0000	14869.00	126.00	14616.00	118	27	118	1266	0.0932069510268562	0.498691953529149	0.498691953529149	true	false	false	true
d45c663c-1736-4f1c-b317-8c16e9f3bf56	2026-08-20 13:01	2026-08-20 13:01	2026-08-20 13:01	CAVA	CAVA261218P00075000	put	75.0000	2026-12-18	9.8500	9.8500	10.1500	72.3300	415670.00	0.00	415670.00	422	32	460	2121	0.216878830740217	0.537574259630912	0.537574259630912	false	false	false	true
8cf45a35-8a04-4220-8c4b-192d01cb0398	2026-08-20 14:39	2026-08-20 14:39	2026-08-20 14:39	CAVA	CAVA260828C00072000	call	72.0000	2026-08-28	2.4500	2.4200	2.5600	72.3200	10290.00	0.00	10290.00	42	7	104	63	1.65079365079365	0.529503019171718	0.529503019171718	false	false	false	true
b7443e87-b897-4a01-841b-14c4b438f7bd	2026-08-20 15:53	2026-08-20 15:52	2026-08-20 15:52	CAVA	CAVA260821C00064000	call	64.0000	2026-08-21	8.4500	7.4000	8.4500	72.4250	12675.00	12675.00	0.00	15	5	32	156	0.205128205128205	1.07228174490598	1.07228174490598	true	false	false	true
2bf2f877-fcd3-434a-aecb-a2fff09dd9ec	2026-08-21 12:33	2026-08-21 12:33	2026-08-21 12:33	CAVA	CAVA260821C00066000	call	66.0000	2026-08-21	7.3000	7.3000	7.6500	73.3100	51100.00	0.00	51100.00	70	18	71	214	0.331775700934579	4.40532627367808	4.40532627367808	false	false	false	true
388da7e0-4514-4f1f-a011-8cf444f49722	2026-08-21 15:52	2026-08-21 15:52	2026-08-21 15:52	CAVA	CAVA261016P00075000	put	75.0000	2026-10-16	6.1000	5.3000	6.1000	73.8062	12200.00	12200.00	0.00	20	5	20	524	0.0381679389312977	0.493546555243499	0.493546555243499	false	false	false	true
f8bf9d4c-8b7f-4086-ba36-04ca03a1c559	2026-08-25 10:06	2026-08-25 10:06	2026-08-25 10:06	CAVA	CAVA260904P00071000	put	71.0000	2026-09-04	2.0000	1.8800	2.3700	71.7200	42597.00	0.00	42597.00	213	11	214	65	3.29230769230769	0.504593416487621	0.496015805894302	true	false	false	true
1ecef514-ae8a-43a2-b289-7ace6b6e2543	2026-08-25 15:59	2026-08-25 15:59	2026-08-25 15:59	CAVA	CAVA270115C00110000	call	110.0000	2027-01-15	1.2000	1.2000	1.3200	69.2300	10560.00	0.00	10560.00	88	9	257	5203	0.0493945800499712	0.533937036801274	0.533937036801274	false	false	false	true
411d867f-3e30-4bca-aab6-f41d5fde88be	2026-08-27 13:23	2026-08-27 13:22	2026-08-27 13:22	CAVA	CAVA260918C00080000	call	80.0000	2026-09-18	0.3000	0.2500	0.3200	66.9099	19860.00	30.00	19830.00	662	17	685	1608	0.425995024875622	0.498946149353242	0.498946149353242	false	false	false	true
076eff30-e388-4fb7-9a49-5134bd54eba4	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	CAVA	CAVA260904C00066000	call	66.0000	2026-09-04	2.3000	2.0000	3.2000	67.1800	14034.00	234.00	13800.00	61	16	105	91	1.15384615384615	0.535755697335657	0.599648208235924	true	false	false	true
d7af73fb-3db5-41f7-a824-8a148ac1e0b5	2026-08-31 10:13	2026-08-31 10:13	2026-08-31 10:13	CAVA	CAVA260911P00064000	put	64.0000	2026-09-11	1.2100	1.2100	1.5000	66.1700	45375.00	0.00	45375.00	375	21	410	98	4.18367346938776	0.477014493297037	0.477014493297037	false	false	false	true
a98c7aa8-fec5-4e52-bbf2-e54689445469	2026-08-31 12:51	2026-08-31 12:51	2026-08-31 12:51	CAVA	CAVA260918C00064000	call	64.0000	2026-09-18	3.9100	3.9000	4.1000	65.9200	12522.00	0.00	12522.00	32	5	32	0	0	0.480334402873906	0.480334402873906	false	false	false	true
4c53f7a8-4ffd-411d-8750-258c47ff6b3d	2026-08-31 15:40	2026-08-31 15:40	2026-08-31 15:40	CAVA	CAVA271217C00070000	call	70.0000	2027-12-17	16.1000	16.1000	17.0000	65.6050	54740.00	0.00	54740.00	34	9	35	140	0.25	0.556646217564341	0.556646217564341	false	false	false	true
0ed05d51-0633-439a-ac98-b27805881ff9	2026-09-01 12:23	2026-09-01 12:23	2026-09-01 12:23	CAVA	CAVA261016P00060000	put	60.0000	2026-10-16	3.0000	2.8500	3.0000	62.0450	104399.00	104100.00	299.00	348	42	383	982	0.390020366598778	0.476022770903324	0.476022770903324	false	false	false	true
2bf9bd00-ccd5-418b-aaf4-1e79c78ac6f4	2026-09-01 14:31	2026-09-01 14:30	2026-09-01 14:30	CAVA	CAVA260904P00063000	put	63.0000	2026-09-04	2.0600	1.8600	2.0600	61.6850	85902.00	85902.00	0.00	417	41	574	263	2.18250950570342	0.581951133819667	0.581951133819667	false	false	false	true
dccb3c3d-165e-49cd-8ef2-85a75fd6583e	2026-09-02 11:39	2026-09-02 11:39	2026-09-02 11:39	CAVA	CAVA261218P00055000	put	55.0000	2026-12-18	3.8000	3.7000	3.8000	62.0000	21280.00	21280.00	0.00	56	9	61	692	0.088150289017341	0.556882708241011	0.556882708241011	false	false	false	true
1a0685b2-b342-4ae0-972d-9aa2f409d94b	2026-09-02 11:51	2026-09-02 11:51	2026-09-02 11:51	CAVA	CAVA261218C00065000	call	65.0000	2026-12-18	6.5000	6.2500	6.5000	61.8800	19500.00	19500.00	0.00	30	7	57	590	0.0966101694915254	0.562026256107473	0.562026256107473	false	false	false	true
93f225e1-c586-4bb7-b0bf-f24991156939	2026-09-02 15:22	2026-09-02 15:22	2026-09-02 15:22	CAVA	CAVA270617P00070000	put	70.0000	2027-06-17	15.8500	15.8500	16.1000	61.3750	63400.00	0.00	63400.00	40	8	80	1507	0.053085600530856	0.548545918421088	0.548545918421088	false	false	false	true
679173dc-b4c7-40d8-812a-b242703e30a1	2026-09-03 09:43	2026-09-03 09:43	2026-09-03 09:43	CAVA	CAVA260911C00064000	call	64.0000	2026-09-11	1.4000	0.7400	1.4000	61.9228	14000.00	14000.00	0.00	100	7	102	22	4.63636363636364	0.610876074895715	0.610876074895715	false	false	false	true
f174c375-bb4e-41d1-ae59-15fb62fadd65	2026-09-03 10:52	2026-09-03 10:52	2026-09-03 10:52	CAVA	CAVA261218P00055000	put	55.0000	2026-12-18	4.1000	4.0000	4.1000	61.1400	31157.00	31157.00	0.00	76	20	85	725	0.117241379310345	0.564288536608646	0.564288536608646	false	false	false	true
5875a387-095d-42c3-82b8-2a9d9b613eb2	2026-09-03 14:09	2026-09-03 14:09	2026-09-03 14:09	CAVA	CAVA261016P00065000	put	65.0000	2026-10-16	5.6500	5.5000	5.8000	61.9550	10735.00	8475.00	1695.00	19	7	30	554	0.0541516245487365	0.477048694937918	0.477048694937918	false	false	false	true
42202ca4-2484-47b8-b862-58555c403d1d	2026-09-08 11:37	2026-09-08 11:37	2026-09-08 11:37	CAVA	CAVA260918C00062000	call	62.0000	2026-09-18	1.4500	1.4500	1.5700	60.5300	18415.00	0.00	18415.00	127	28	200	584	0.342465753424658	0.514001837992268	0.514001837992268	false	false	false	true
4d435385-2baf-4de1-aae0-c394c1f0e8ab	2026-09-08 14:56	2026-09-08 14:56	2026-09-08 14:56	CAVA	CAVA261016P00060000	put	60.0000	2026-10-16	3.6500	3.6000	3.7500	60.0600	60590.00	36135.00	1460.00	166	6	236	1447	0.16309606081548	0.493239384784796	0.493239384784796	false	false	false	true
9af98b7d-24cb-4a46-8e1a-d9f24b59a244	2026-09-09 15:52	2026-09-09 15:52	2026-09-09 15:52	CAVA	CAVA270617C00070000	call	70.0000	2027-06-17	7.4000	7.0500	7.7000	56.9000	14800.00	11100.00	740.00	20	6	62	241	0.257261410788382	0.560273935809582	0.560273935809582	false	false	false	true
12eeba82-7b37-4306-97d6-d65de3b320f7	2026-09-09 15:53	2026-09-09 15:53	2026-09-09 15:53	CAVA	CAVA260911C00050000	call	50.0000	2026-09-11	6.8500	6.3500	7.3500	56.8500	10275.00	3425.00	5480.00	15	7	73	28	2.60714285714286	0.745665465322675	1.1692670654728	false	false	false	true
964621f6-d74a-4bbe-8f3c-95c94e71c150	2026-09-10 09:41	2026-09-10 09:40	2026-09-10 09:40	CAVA	CAVA270115C00075000	call	75.0000	2027-01-15	2.2000	2.0000	2.2000	55.2531	80960.00	80960.00	0.00	368	26	369	587	0.628620102214651	0.564454344341256	0.564454344341256	false	false	false	true
d5645e5d-9be7-40c0-b59d-38b42cc10365	2026-09-10 13:26	2026-09-10 13:26	2026-09-10 13:26	CAVA	CAVA261016C00070000	call	70.0000	2026-10-16	0.3800	0.3800	0.4400	54.8600	19836.00	0.00	19836.00	522	33	541	658	0.822188449848024	0.542877045425825	0.542877045425825	false	false	false	true
afd4c718-20dc-4e4e-8629-19b604ce40c0	2026-09-10 13:51	2026-09-10 13:51	2026-09-10 13:51	CAVA	CAVA270319P00050000	put	50.0000	2027-03-19	5.9000	5.9000	6.0500	55.2100	17110.00	0.00	17110.00	29	7	57	86	0.662790697674419	0.578876165599437	0.578876165599437	false	false	false	true
f92223e7-a17b-424f-a512-9a1e36d34332	2026-09-10 13:52	2026-09-10 13:52	2026-09-10 13:52	CAVA	CAVA270319P00050000	put	50.0000	2027-03-19	5.9500	5.8500	6.0500	55.0800	14875.00	0.00	10710.00	25	7	97	86	1.12790697674419	0.579536415203249	0.579536415203249	false	false	false	true
baefb562-eb92-43e4-a7ad-01179194e45a	2026-09-10 14:00	2026-09-10 14:00	2026-09-10 14:00	CAVA	CAVA270115P00060000	put	60.0000	2027-01-15	9.8000	9.6500	10.0000	54.9900	424340.00	423360.00	980.00	433	7	638	789	0.808618504435995	0.559034365343553	0.559034365343553	false	false	false	true
12d04940-fa8a-4633-99f0-6f450cb545b0	2026-09-10 14:07	2026-09-10 14:07	2026-09-10 14:07	CAVA	CAVA271217C00075000	call	75.0000	2027-12-17	8.9000	8.6000	9.1000	54.8700	35600.00	35600.00	0.00	40	6	40	128	0.3125	0.572531065753749	0.572531065753749	false	false	false	true
003b565f-1b86-48a7-8374-86e61fa35b81	2026-09-10 15:35	2026-09-10 15:35	2026-09-10 15:35	CAVA	CAVA270115P00035000	put	35.0000	2027-01-15	0.7900	0.7000	0.7900	54.6400	10823.00	10823.00	0.00	137	13	157	298	0.526845637583893	0.619761499191553	0.619761499191553	false	false	false	true
34875914-bd02-4c92-9e0d-4f74554d562a	2026-09-10 15:42	2026-09-10 15:42	2026-09-10 15:42	CAVA	CAVA261016C00055000	call	55.0000	2026-10-16	3.4500	3.4000	3.5000	54.4650	30015.00	25185.00	4830.00	87	5	172	194	0.88659793814433	0.527896468598387	0.527896468598387	false	false	false	true
27294f45-b903-4faa-a7ba-e9d23ad19d99	2026-09-11 10:00	2026-09-11 10:00	2026-09-11 10:00	CAVA	CAVA261016C00055000	call	55.0000	2026-10-16	3.9100	3.9000	3.9500	55.5900	25010.00	0.00	21060.00	64	13	129	325	0.396923076923077	0.512803157372894	0.512803157372894	false	false	false	true
5bceb346-f828-46d6-962c-fb6d4f1d9dd4	2026-09-11 13:45	2026-09-11 13:45	2026-09-11 13:45	CAVA	CAVA270617P00060000	put	60.0000	2027-06-17	12.6000	12.3500	12.6000	55.7500	49140.00	49140.00	0.00	39	14	44	57	0.771929824561403	0.580734199808246	0.580734199808246	false	false	false	true
14d5506d-74de-4336-b107-9323e2219193	2026-09-11 14:33	2026-09-11 14:32	2026-09-11 14:32	CAVA	CAVA270617C00070000	call	70.0000	2027-06-17	7.1000	6.8500	7.1000	55.7500	20590.00	20590.00	0.00	29	8	32	244	0.131147540983607	0.572744366750048	0.572744366750048	false	false	false	true
ac9f1772-7a38-43f9-9076-670cd80129f7	2026-09-14 09:42	2026-09-14 09:42	2026-09-14 09:42	CAVA	CAVA260918C00049000	call	49.0000	2026-09-18	6.4500	6.4500	7.5000	55.0000	18705.00	0.00	18705.00	29	6	30	1	30	1.52923352602997	0.806683540770256	true	false	false	true
05a9e334-2569-4d77-9e68-75a96b3dcbf9	2026-09-14 10:18	2026-09-14 10:17	2026-09-14 10:17	CAVA	CAVA270115C00100000	call	100.0000	2027-01-15	0.4500	0.3900	0.4600	55.0000	23130.00	540.00	22590.00	514	27	526	1775	0.296338028169014	0.577165775511811	0.577165775511811	false	false	false	true
356ea6a8-f77c-4c51-b495-927f112e228c	2026-09-14 11:12	2026-09-14 11:12	2026-09-14 11:12	CAVA	CAVA270617P00040000	put	40.0000	2027-06-17	3.5000	3.2500	3.6000	55.4500	11900.00	9100.00	2450.00	34	6	35	88	0.397727272727273	0.603940390911571	0.603940390911571	true	false	false	true
0abbacd1-6390-487d-9629-ab50f8a5f498	2026-09-14 11:25	2026-09-14 11:25	2026-09-14 11:25	CAVA	CAVA270617C00070000	call	70.0000	2027-06-17	6.9000	6.4500	6.9000	55.0100	38640.00	38640.00	0.00	56	11	70	272	0.257352941176471	0.582336844165917	0.582336844165917	false	false	false	true
be6b1503-dd88-49dc-92d2-d68a014b89d9	2026-09-14 11:51	2026-09-14 11:51	2026-09-14 11:51	CAVA	CAVA260918P00055000	put	55.0000	2026-09-18	1.5300	1.3500	1.5300	54.7000	83844.00	83844.00	0.00	548	50	646	1326	0.487179487179487	0.60570975031069	0.60570975031069	false	false	false	true
f23bcf27-75b5-4e5f-b614-df9fc011ede3	2026-09-14 13:34	2026-09-14 13:34	2026-09-14 13:34	CAVA	CAVA270617C00070000	call	70.0000	2027-06-17	7.1000	5.9500	7.3000	55.3000	32660.00	22720.00	9940.00	46	6	116	272	0.426470588235294	0.586160220812559	0.586160220812559	false	false	false	true