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

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

a57fa90a-2281-4ec3-9f30-3f9fb1a891a3	2026-09-16 13:41	2026-09-16 13:41	2026-09-16 13:41	W	W261120C00105000	call	105.0000	2026-11-20	12.5000	12.3500	12.5000	106.0000	28750.00	28750.00	0.00	23	9	25	182	0.137362637362637	0.650734246905248	0.650734246905248	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	11974824738.00	2026-10-27	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
b8d4aa31-87d0-4c35-a1f2-35f5cd60fe5d	2026-09-16 13:16	2026-09-16 13:16	2026-09-16 13:16	W	W270115P00097500	put	97.5000	2027-01-15	9.4500	9.4500	9.7000	105.4800	44415.00	0.00	44415.00	47	13	47	1928	0.0243775933609959	0.590710039046773	0.590710039046773	false	false	false	true
e562c1d6-8f6c-435b-b917-cea1994aefdd	2026-09-16 12:30	2026-09-16 12:30	2026-09-16 12:30	W	W261016C00120000	call	120.0000	2026-10-16	2.2100	2.2100	2.4100	106.0200	48632.00	675.00	47957.00	220	27	220	127	1.73228346456693	0.544241896147478	0.544241896147478	false	false	false	true
78194a75-2bc0-4b84-a9f8-84ec5d64b2c1	2026-09-16 10:42	2026-09-16 10:42	2026-09-16 10:42	W	W260918P00100000	put	100.0000	2026-09-18	0.6000	0.6000	0.7100	105.1400	12480.00	0.00	12480.00	208	47	218	517	0.421663442940039	0.767511300808215	0.767511300808215	false	false	false	true
d261fcdd-2dd3-407f-8910-1295f8e92bcb	2026-09-15 14:48	2026-09-15 14:48	2026-09-15 14:48	W	W270319P00087500	put	87.5000	2027-03-19	9.2500	8.9000	9.3000	103.8000	12025.00	3700.00	4625.00	13	11	219	1117	0.196060877350045	0.632656696004586	0.632333426556886	false	false	false	true
c6eb86d2-cb0f-4427-9198-274c3f43e340	2026-09-15 13:49	2026-09-15 13:49	2026-09-15 13:49	W	W270319P00087500	put	87.5000	2027-03-19	9.0000	8.8500	9.0500	104.7500	10800.00	900.00	9900.00	12	12	33	1117	0.0295434198746643	0.631941732460666	0.631941732460666	false	false	false	true
9d228171-acdf-486c-b561-03ce189372c6	2026-09-15 12:21	2026-09-15 12:21	2026-09-15 12:21	W	W261120P00105000	put	105.0000	2026-11-20	11.7000	11.3500	12.0000	104.0000	22230.00	7020.00	15210.00	19	5	20	801	0.0249687890137328	0.660825249096523	0.660825249096523	true	false	false	true
f5872861-5757-4575-9a0e-1e53bfe888fc	2026-09-15 11:33	2026-09-15 11:32	2026-09-15 11:32	W	W261120P00110000	put	110.0000	2026-11-20	15.6500	15.1500	15.9000	101.7800	21910.00	3130.00	18780.00	14	8	14	519	0.0269749518304432	0.649010115738049	0.649010115738049	true	false	false	true
fd80b836-bbdb-4db1-9da4-11a2df752a07	2026-09-14 15:59	2026-09-14 15:59	2026-09-14 15:59	W	W261016C00105000	call	105.0000	2026-10-16	6.9000	6.7000	7.5500	104.0000	14490.00	0.00	14490.00	21	5	56	72	0.777777777777778	0.55320004046709	0.55320004046709	false	false	false	true
0d3cc616-c678-45e6-86f2-127ea448baca	2026-09-14 13:16	2026-09-14 13:16	2026-09-14 13:16	W	W270115C00115000	call	115.0000	2027-01-15	10.8500	10.5500	10.8500	104.0125	75950.00	75950.00	0.00	70	19	76	896	0.0848214285714286	0.605405668272246	0.605405668272246	false	false	false	true
51b53831-a857-43af-8bc0-e84d12f7a093	2026-09-14 12:44	2026-09-14 12:44	2026-09-14 12:44	W	W261120P00115000	put	115.0000	2026-11-20	18.1000	17.7000	18.1000	103.7700	14480.00	14480.00	0.00	8	7	39	2415	0.0161490683229814	0.658774141077535	0.658774141077535	false	false	false	true
2f8505f1-db54-4aa2-aae6-c10bb924027a	2026-09-14 12:40	2026-09-14 12:40	2026-09-14 12:40	W	W261120P00110000	put	110.0000	2026-11-20	14.9000	14.6000	14.9000	103.6400	10430.00	10430.00	0.00	7	6	48	474	0.10126582278481	0.657973802924673	0.657973802924673	false	false	false	true
2cdfd760-1e54-426e-b4e7-1eb50cc35db2	2026-09-14 12:36	2026-09-14 12:36	2026-09-14 12:36	W	W261120P00115000	put	115.0000	2026-11-20	18.0500	17.6500	18.0500	103.8325	14440.00	14440.00	0.00	8	7	31	2415	0.0128364389233954	0.657975454624302	0.657975454624302	false	false	false	true
560a1449-b60a-4154-9e24-6dbbd87d48d9	2026-09-14 12:31	2026-09-14 12:31	2026-09-14 12:31	W	W261120P00115000	put	115.0000	2026-11-20	18.2000	17.7500	18.2000	103.7100	14560.00	14560.00	0.00	8	6	16	2415	0.00662525879917184	0.662530381001274	0.662530381001274	false	false	false	true
9ab06057-6b47-472f-934a-52be186d9e60	2026-09-14 12:28	2026-09-14 12:28	2026-09-14 12:28	W	W261120P00115000	put	115.0000	2026-11-20	18.2500	17.6500	18.2500	103.6600	14600.00	14600.00	0.00	8	6	8	2415	0.00331262939958592	0.663744771529101	0.663744771529101	false	false	false	true
8ef3083b-c1bc-4944-962d-7e3464ffd54d	2026-09-14 12:26	2026-09-14 12:26	2026-09-14 12:26	W	W261120P00110000	put	110.0000	2026-11-20	15.0000	14.6000	15.0000	103.6500	10500.00	10500.00	0.00	7	6	35	474	0.0738396624472574	0.663915652207414	0.663915652207414	false	false	false	true
c715ca19-42df-4f18-8285-8a9c2de956ec	2026-09-14 11:46	2026-09-14 11:46	2026-09-14 11:46	W	W260918C00110000	call	110.0000	2026-09-18	0.7100	0.6300	0.7100	102.6700	10863.00	10863.00	0.00	153	7	2274	3871	0.587445104624128	0.692109377239596	0.692109377239596	true	false	false	true
e931afe4-869a-42c4-b183-fa118dc8c7dd	2026-09-14 11:35	2026-09-14 11:35	2026-09-14 11:35	W	W260918C00110000	call	110.0000	2026-09-18	0.7200	0.6100	0.8100	102.5800	10922.00	6862.00	4060.00	152	12	1397	3871	0.360888659261173	0.69431681493499	0.704921720633484	false	false	false	true
119afb0c-b231-4428-a55d-d9e0efef1584	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	W	W260918C00099000	call	99.0000	2026-09-18	4.6000	3.7500	4.6000	101.7800	13800.00	13800.00	0.00	30	5	40	175	0.228571428571429	0.710733381422634	0.710733381422634	false	false	false	true
899eef2f-4ae0-4404-9914-74753fff1818	2026-09-11 13:18	2026-09-11 13:17	2026-09-11 13:17	W	W260918C00102000	call	102.0000	2026-09-18	1.9900	1.9900	2.2100	99.5250	57909.00	0.00	57909.00	291	15	300	42	7.14285714285714	0.546433095578837	0.546433095578837	false	false	false	true
bc97e6d9-6dd5-45cc-af4c-ab643779b3a3	2026-09-11 12:28	2026-09-11 12:28	2026-09-11 12:28	W	W261016P00100000	put	100.0000	2026-10-16	6.6000	6.6000	6.8000	99.5200	58740.00	0.00	58740.00	89	22	105	124	0.846774193548387	0.533254505057216	0.533254505057216	false	false	false	true
93187684-34a8-442a-a059-7b82f943db48	2026-09-11 11:48	2026-09-11 11:48	2026-09-11 11:48	W	W261002P00100000	put	100.0000	2026-10-02	5.3000	5.2500	5.5000	99.4900	11665.00	2125.00	9540.00	22	5	122	3	40.6666666666667	0.54119186910326	0.54119186910326	false	false	false	true
c0ae635e-4010-4be3-9b84-9d860f363759	2026-09-11 11:16	2026-09-11 11:16	2026-09-11 11:16	W	W260918C00110000	call	110.0000	2026-09-18	0.4700	0.4700	0.6200	99.0500	18519.00	0.00	18471.00	394	40	1174	3132	0.374840357598978	0.612854276626326	0.612854276626326	false	false	false	true
f28ed52e-5432-4ddb-a9ec-0d0ce1753be4	2026-09-11 10:04	2026-09-11 10:04	2026-09-11 10:04	W	W260911P00100000	put	100.0000	2026-09-11	1.6200	1.2600	1.6200	98.8450	46980.00	46980.00	0.00	290	8	291	121	2.40495867768595	0.90444104777681	0.90444104777681	true	false	false	true
45322f32-778b-45ad-831c-ac63af030243	2026-09-10 11:29	2026-09-10 11:29	2026-09-10 11:29	W	W270115C00165000	call	165.0000	2027-01-15	1.4800	1.3500	1.4800	97.6100	19684.00	19684.00	0.00	133	25	136	73	1.86301369863014	0.601229021636486	0.601229021636486	false	false	false	true
32ae0904-123e-4502-8a91-f9b133a60a53	2026-09-09 11:50	2026-09-09 11:49	2026-09-09 11:49	W	W271217C00135000	call	135.0000	2027-12-17	18.2000	17.7500	18.4000	98.2800	63700.00	61880.00	0.00	35	10	435	4	108.75	0.626365735472166	0.626365735472166	false	false	false	true	false
b924f58e-4e90-4e07-a4de-788b1398cbfc	2026-09-09 11:49	2026-09-09 11:49	2026-09-09 11:49	W	W271217C00135000	call	135.0000	2027-12-17	18.2000	17.7000	18.2000	98.3550	109200.00	109200.00	0.00	60	15	364	4	91	0.625538698880117	0.625538698880117	false	false	false	true	false
b89678fe-eac4-4851-a39e-fb3d849bcb1a	2026-09-09 11:42	2026-09-09 11:41	2026-09-09 11:41	W	W271217C00135000	call	135.0000	2027-12-17	18.6000	17.9000	18.6000	99.1600	111600.00	111600.00	0.00	60	10	304	4	76	0.625667739558917	0.625667739558917	false	false	false	true	false
a712379a-e435-46ad-83f7-cc5dc69d0d7b	2026-09-09 11:41	2026-09-09 11:41	2026-09-09 11:41	W	W271217C00135000	call	135.0000	2027-12-17	18.6000	17.9000	18.6000	99.1900	111600.00	111600.00	0.00	60	10	244	4	61	0.625998843934668	0.625336723526582	false	false	false	true	false
cce6d5ff-9a82-4323-9b0c-d000af69cd63	2026-09-09 11:36	2026-09-09 11:36	2026-09-09 11:36	W	W280121C00135000	call	135.0000	2028-01-21	19.3600	19.0500	19.8000	99.4200	11615.00	5805.00	5810.00	6	5	29	19	1.52631578947368	0.614473990705954	0.614473990705954	true	false	false	true
19d72c82-14a1-4325-b2f5-02eb751b5a2b	2026-09-09 10:07	2026-09-09 10:07	2026-09-09 10:07	W	W260918C00110000	call	110.0000	2026-09-18	0.8500	0.7800	1.2200	98.8500	80665.00	680.00	79985.00	949	31	1043	3195	0.326447574334898	0.656931214918825	0.656931214918825	true	false	false	true
e0f99069-2621-4f4c-9425-b41d8ed4feb2	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	W	W260911C00100000	call	100.0000	2026-09-11	2.4000	1.5900	3.1500	99.3100	13680.00	960.00	12720.00	57	9	100	168	0.595238095238095	0.92506318806396	0.92506318806396	false	false	false	true
ba6cf0ef-f06d-4e09-8412-5ff3767632b0	2026-09-08 13:58	2026-09-08 13:58	2026-09-08 13:58	W	W260911C00099000	call	99.0000	2026-09-11	3.0000	3.0000	3.5500	100.1300	10800.00	0.00	10800.00	36	10	91	843	0.107947805456702	0.659627544289075	0.659627544289075	true	false	false	true
bb6464bd-864a-4a7e-aa8b-48d84fdc301c	2026-09-08 13:58	2026-09-08 13:58	2026-09-08 13:58	W	W260911C00099000	call	99.0000	2026-09-11	3.0000	2.6700	3.0000	100.1300	13500.00	6000.00	0.00	45	5	55	843	0.0652431791221827	0.656285786079424	0.659627544289075	false	false	false	true
adf60b29-ee54-4063-8feb-f5040882d3e5	2026-09-08 10:57	2026-09-08 10:56	2026-09-08 10:56	W	W261120C00100000	call	100.0000	2026-11-20	11.5500	11.1500	11.5500	99.2100	157080.00	157080.00	0.00	136	22	136	105	1.2952380952381	0.65514298728979	0.65514298728979	false	false	false	true
c3ef9afa-b01d-45fd-bab3-b31f9db59c85	2026-09-04 15:59	2026-09-04 15:59	2026-09-04 15:59	W	W261002P00085000	put	85.0000	2026-10-02	1.0000	1.0000	1.6100	99.4350	24900.00	0.00	24900.00	249	17	250	11	22.7272727272727	0.539871888334888	0.539871888334888	false	false	false	true
c48cc6ea-4efb-4f39-8d9b-c45b24c998bd	2026-09-04 15:22	2026-09-04 15:22	2026-09-04 15:22	W	W260911P00095000	put	95.0000	2026-09-11	1.1900	1.1900	1.2200	99.3000	30702.00	0.00	30702.00	258	38	292	38	7.68421052631579	0.531677475914635	0.53313296111302	false	false	false	true
caf509d3-a952-4bdf-9fb2-9c905684f164	2026-09-04 13:53	2026-09-04 13:53	2026-09-04 13:53	W	W260918C00110000	call	110.0000	2026-09-18	1.1400	1.0400	1.2200	99.2400	17784.00	4446.00	13338.00	156	7	1246	3664	0.340065502183406	0.568081681508033	0.568081681508033	false	false	false	true
b6d71a14-5c1b-414f-ac3b-b5b538dd992e	2026-09-04 13:50	2026-09-04 13:49	2026-09-04 13:49	W	W260918C00110000	call	110.0000	2026-09-18	1.1000	1.0000	1.1200	99.0850	16060.00	12320.00	3740.00	146	12	1090	3664	0.297489082969432	0.566204210804682	0.566204210804682	false	false	false	true
81e5b04a-30c7-45ac-ad8c-bca0a4c59398	2026-09-04 09:41	2026-09-04 09:41	2026-09-04 09:41	W	W260904P00098000	put	98.0000	2026-09-04	0.9500	0.5900	0.9500	98.3600	18144.00	18144.00	0.00	191	9	191	95	2.01052631578947	0.96499561037945	1.0680449496635	true	false	false	true	false
70e0d617-7f69-4b12-b3ec-175c0b7609c7	2026-09-04 09:41	2026-09-04 09:41	2026-09-04 09:41	W	W260904C00096000	call	96.0000	2026-09-04	2.4000	0.7300	2.4000	98.3600	62645.00	62645.00	0.00	261	7	266	105	2.53333333333333	0.95748629139628	0.576796329661604	false	false	false	true
3ca86670-7206-44bd-aafd-f1c5a389c699	2026-09-04 09:41	2026-09-04 09:41	2026-09-04 09:41	W	W260904C00099000	call	99.0000	2026-09-04	0.6300	0.0100	0.6300	98.1250	27845.00	27845.00	0.00	442	5	443	93	4.76344086021505	0.954423899885483	0.944351162475416	true	false	false	true
12c08cfe-ed1e-4a54-8c50-0cce4971edf8	2026-09-04 09:41	2026-09-04 09:41	2026-09-04 09:41	W	W260904C00097000	call	97.0000	2026-09-04	1.6600	0.3900	1.6600	98.1250	56274.00	56274.00	0.00	339	5	339	214	1.58411214953271	0.954350700410313	0.954350700410313	false	false	false	true
59a3620d-d6ba-4d5f-a385-0a69c1530e64	2026-09-03 15:59	2026-09-03 15:59	2026-09-03 15:59	W	W261016C00095000	call	95.0000	2026-10-16	8.3000	8.0000	8.7500	96.9250	13280.00	12450.00	830.00	16	6	38	49	0.775510204081633	0.539120266652	0.539120266652	false	false	false	true
11c0106f-e034-422d-b6e9-299af2ef8b47	2026-09-03 15:55	2026-09-03 15:55	2026-09-03 15:55	W	W260904C00097000	call	97.0000	2026-09-04	1.3200	1.1600	1.3200	96.7500	13200.00	13200.00	0.00	100	7	133	313	0.424920127795527	0.710308226821799	0.710308226821799	true	false	false	true
7ec48447-9a46-4286-b616-8486c4e69f05	2026-09-03 12:57	2026-09-03 12:57	2026-09-03 12:57	W	W260918C00104000	call	104.0000	2026-09-18	1.8100	1.8100	1.8400	96.6100	10136.00	0.00	10136.00	56	13	56	16	3.5	0.560273372158361	0.560273372158361	false	false	false	true	false
bbacac22-2bd5-4a52-9b0c-20d0169e8e31	2026-09-03 11:32	2026-09-03 11:32	2026-09-03 11:32	W	W270319C00145000	call	145.0000	2027-03-19	5.7000	5.4250	6.3500	98.3000	59850.00	0.00	59850.00	105	19	105	2	52.5	0.594266332222141	0.594266332222141	false	false	false	true	false
8c451f4c-be66-41e8-a21a-b3b8f59432f6	2026-09-03 11:30	2026-09-03 11:30	2026-09-03 11:30	W	W270820C00165000	call	165.0000	2027-08-20	8.6500	7.6500	9.4500	98.2450	92555.00	66605.00	25950.00	107	6	107	9	11.8888888888889	0.607267890148426	0.607267890148426	false	false	false	true
c3cf4725-7880-4c4a-8620-acc347e2c435	2026-09-03 10:08	2026-09-03 10:08	2026-09-03 10:08	W	W260918C00110000	call	110.0000	2026-09-18	0.8500	0.8500	0.9500	95.9350	17000.00	0.00	17000.00	200	5	313	2766	0.113159797541576	0.60315784301901	0.60315784301901	true	false	false	true
44840f71-3fef-47be-aab6-ea7334dda254	2026-09-03 10:07	2026-09-03 10:07	2026-09-03 10:07	W	W261120C00100000	call	100.0000	2026-11-20	9.7500	9.3000	9.7500	95.8950	32175.00	32175.00	0.00	33	13	34	69	0.492753623188406	0.631100491293502	0.631100491293502	false	false	false	true