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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = VAL×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

6d248df7-8750-422e-80c1-866ccfdfe0b9	2026-08-17 10:56	2026-08-17 10:55	2026-08-17 10:55	VAL	VAL280121C00135000	call	135.0000	2028-01-21	9.9000	7.4000	11.8000	86.0400	17820.00	5940.00	11880.00	18	6	32	611	0.0523731587561375	0.512271975970127	0.512271975970127	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	5643048035.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
15795385-8542-4f8e-bf58-11e166b5a9ef	2026-08-18 14:09	2026-08-18 14:09	2026-08-18 14:09	VAL	VAL280121C00135000	call	135.0000	2028-01-21	9.9000	8.2000	10.8000	86.9400	11880.00	3960.00	7920.00	12	6	106	554	0.191335740072202	0.504125659574681	0.504125659574681	false	false	false	true
781906bb-28bd-43ca-bed4-24d9024e10ed	2026-08-19 10:57	2026-08-19 10:57	2026-08-19 10:57	VAL	VAL261218C00080000	call	80.0000	2026-12-18	13.3800	11.9000	14.9000	87.4000	2676000.00	0.00	2676000.00	2000	2	2000	6	333.333333333333	0.446651261037015	0.446651261037015	false	true	true	false
193d9122-c608-41ad-a0ca-c5681684a891	2026-08-19 12:54	2026-08-19 12:54	2026-08-19 12:54	VAL	VAL280121C00135000	call	135.0000	2028-01-21	9.7000	7.0000	11.1000	87.1525	14550.00	14550.00	0.00	15	12	28	441	0.0634920634920635	0.497571927770628	0.497571927770628	true	false	false	true
0ac7bda4-9b60-421d-bd0f-583a2a6724f1	2026-08-20 12:58	2026-08-20 12:58	2026-08-20 12:58	VAL	VAL271217P00050000	put	50.0000	2027-12-17	3.7000	2.5000	3.7000	88.6675	15160.00	13680.00	0.00	41	10	81	42	1.92857142857143	0.569377833521793	0.569377833521793	true	false	false	true
c1ecefa9-1831-4f38-a6d4-81dc3dcfedf0	2026-08-20 13:00	2026-08-20 13:00	2026-08-20 13:00	VAL	VAL271217P00057500	put	57.5000	2027-12-17	5.7700	3.8000	5.8000	88.5300	20777.00	20777.00	0.00	36	8	76	0	0	0.566876013473283	0.553251030753466	true	false	false	true
e1aec518-899d-4c57-995f-c22492423f7b	2026-08-20 13:01	2026-08-20 13:01	2026-08-20 13:01	VAL	VAL271217P00060000	put	60.0000	2027-12-17	6.5000	4.7000	6.5000	88.4450	13642.00	13642.00	0.00	21	9	81	21	3.85714285714286	0.559525690196763	0.561165363454178	false	false	false	true
f0d920e1-38fa-4dd2-a792-e2595ccfdeb7	2026-08-20 13:07	2026-08-20 13:07	2026-08-20 13:07	VAL	VAL271217P00055000	put	55.0000	2027-12-17	3.5000	3.5000	5.3000	88.4450	14000.00	0.00	14000.00	40	5	120	8	15	0.49099964010193	0.49099964010193	false	false	false	true
97d08f16-6959-4b96-9f50-3b1a73cc10e9	2026-08-20 15:37	2026-08-20 15:37	2026-08-20 15:37	VAL	VAL280121P00060000	put	60.0000	2028-01-21	5.7000	5.7000	8.1000	89.0600	11400.00	0.00	11400.00	20	7	61	9	6.77777777777778	0.516715344032982	0.516715344032982	true	false	false	true
5b9419a1-7a20-4537-b9bf-a5b297d2368e	2026-08-20 15:45	2026-08-20 15:45	2026-08-20 15:45	VAL	VAL271217P00070000	put	70.0000	2027-12-17	8.6000	8.6000	10.0000	88.9000	17200.00	0.00	11180.00	20	5	60	32	1.875	0.506725728609843	0.506725728609843	true	false	false	true
3a0b6688-a157-455b-813c-16562f3fe21f	2026-08-21 11:49	2026-08-21 11:49	2026-08-21 11:49	VAL	VAL280121P00042500	put	42.5000	2028-01-21	2.5500	1.6500	2.5500	89.1650	22950.00	22950.00	0.00	90	11	200	17	11.7647058823529	0.589223466817801	0.589223466817801	false	false	false	true
3ea6f33d-f786-40e9-b451-0d543ce0e4b2	2026-08-21 11:52	2026-08-21 11:52	2026-08-21 11:52	VAL	VAL280121P00050000	put	50.0000	2028-01-21	3.8900	2.7000	3.9000	89.2800	23750.00	23750.00	0.00	61	14	204	40	5.1	0.567554506761297	0.567126677217087	true	false	false	true
a13a0609-caac-4b53-9f5d-5827b75dec51	2026-08-21 11:52	2026-08-21 11:52	2026-08-21 11:52	VAL	VAL271217P00045000	put	45.0000	2027-12-17	2.6800	1.4500	3.1000	89.2800	26770.00	26770.00	0.00	100	24	200	18	11.1111111111111	0.575250335951187	0.595791721791918	true	false	false	true
514e2117-8aeb-4927-93c6-a7e524bea26a	2026-08-21 12:04	2026-08-21 12:04	2026-08-21 12:04	VAL	VAL280121P00052500	put	52.5000	2028-01-21	4.8000	3.3000	4.8000	89.3600	15358.00	15358.00	0.00	32	7	101	20	5.05	0.577903932612572	0.578874588142775	false	false	false	true
58ba740b-8971-494f-9a98-4a6a18fd39bf	2026-08-24 10:39	2026-08-24 10:39	2026-08-24 10:39	VAL	VAL271217P00050000	put	50.0000	2027-12-17	3.9000	2.7000	6.1000	84.9500	21450.00	3900.00	13650.00	55	9	55	149	0.369127516778524	0.561505233646119	0.561505233646119	true	false	false	true
69cecdab-e874-4547-bbc1-0bd58d594dfe	2026-08-24 10:40	2026-08-24 10:40	2026-08-24 10:40	VAL	VAL271217P00050000	put	50.0000	2027-12-17	3.8000	2.7000	4.5000	84.9500	17100.00	3800.00	9500.00	45	6	100	149	0.671140939597315	0.555991495202328	0.555991495202328	true	false	false	true
cebea53a-0875-4e6b-b212-13207938fa06	2026-08-28 11:26	2026-08-28 11:26	2026-08-28 11:26	VAL	VAL280121C00135000	call	135.0000	2028-01-21	9.7000	7.0000	11.1000	86.2200	14550.00	14550.00	0.00	15	7	17	410	0.0414634146341463	0.511302416264544	0.511302416264544	false	false	false	true
ee9fef1a-a12f-4e52-96a7-4061b747761a	2026-08-31 11:03	2026-08-31 11:03	2026-08-31 11:03	VAL	VAL260918P00085000	put	85.0000	2026-09-18	2.6000	2.0500	2.6000	86.4450	37440.00	37440.00	0.00	144	8	144	4	36	0.440620352746317	0.440620352746317	false	false	false	true
923a052e-46da-43c5-8a62-96f1b06cf19d	2026-08-31 11:11	2026-08-31 11:10	2026-08-31 11:10	VAL	VAL260918P00085000	put	85.0000	2026-09-18	2.6000	2.1000	3.1000	86.2200	26000.00	20800.00	5200.00	100	5	250	4	62.5	0.428255793710668	0.428255793710668	false	false	false	true
c3cec9ab-602c-4cb0-a13c-15d2e7a38b7a	2026-09-02 10:52	2026-09-02 10:52	2026-09-02 10:52	VAL	VAL261016C00092500	call	92.5000	2026-10-16	4.2000	4.2000	4.6000	89.6300	14700.00	0.00	14700.00	35	10	262	3	87.3333333333333	0.423986633401546	0.423986633401546	false	false	false	true
8782728c-968c-4f8d-8c6a-ee5759956c7a	2026-09-02 12:40	2026-09-02 12:40	2026-09-02 12:40	VAL	VAL261218C00105000	call	105.0000	2026-12-18	4.3500	4.0000	4.8000	90.9800	326250.00	0.00	161250.00	750	2	753	6	125.5	0.451270460979468	0.451270460979468	false	true	false	true
dd4f4029-e94e-4ed6-b74a-89945efebc1a	2026-09-04 11:20	2026-09-04 11:20	2026-09-04 11:20	VAL	VAL261218P00075000	put	75.0000	2026-12-18	3.5000	3.3000	5.4000	86.2700	350000.00	0.00	350000.00	1000	4	1005	3	335	0.478350797114792	0.478350797114792	false	true	false	true
bf10c9cb-1e2f-473f-ad68-349d0c339c78	2026-09-04 15:43	2026-09-04 15:43	2026-09-04 15:43	VAL	VAL280121C00135000	call	135.0000	2028-01-21	9.4000	7.0000	11.4000	86.1300	15040.00	14100.00	940.00	16	7	37	187	0.197860962566845	0.507164427903277	0.507164427903277	true	false	false	true
ba8eb785-e00c-4d2e-8e61-7c897b742fb8	2026-09-09 12:07	2026-09-09 12:07	2026-09-09 12:07	VAL	VAL280121C00110000	call	110.0000	2028-01-21	13.1000	13.0000	17.0000	86.0250	655000.00	0.00	655000.00	500	1	500	20	25	0.475675949073932	0.475675949073932	false	true	true	false
9264df5b-4f01-4705-87b1-10e1a878d9d3	2026-09-15 12:34	2026-09-15 12:34	2026-09-15 12:34	VAL	VAL261016C00090000	call	90.0000	2026-10-16	3.6000	3.5000	3.9000	87.0000	21600.00	1080.00	20520.00	60	7	87	1	87	0.438737138941905	0.438737138941905	true	false	false	true
599aedc8-a4f5-4a63-ba9e-fe60ec2ec5e1	2026-09-15 15:04	2026-09-15 15:04	2026-09-15 15:04	VAL	VAL261016P00085000	put	85.0000	2026-10-16	3.9000	3.0000	4.3000	87.2900	58110.00	58110.00	0.00	149	12	150	5	30	0.509312023317197	0.509312023317197	false	false	false	true