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:sector = Consumer Cyclical×ticker = ULTA×

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

4d550ca9-0731-4d6b-8463-55014236addd	2026-09-22 15:54	2026-09-22 15:54	2026-09-22 15:54	ULTA	ULTA261009C00575000	call	575.0000	2026-10-09	6.9700	6.8000	8.0000	554.0000	27860.00	18110.00	2790.00	40	11	108	40	2.7	0.297503516102199	0.299863156189881	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	23681652888.00	2026-12-03	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
3b482a3e-6811-4f5c-802b-62da59112b87	2026-09-22 15:53	2026-09-22 15:53	2026-09-22 15:53	ULTA	ULTA261009C00575000	call	575.0000	2026-10-09	7.1500	6.5000	7.9000	555.0000	22890.00	12900.00	7150.00	32	10	48	40	1.2	0.299699830176607	0.302042737503696	false	false	false	true
7db01fa9-29cb-4a5e-8848-5716f01e04a3	2026-09-22 15:53	2026-09-22 15:53	2026-09-22 15:53	ULTA	ULTA261009C00575000	call	575.0000	2026-10-09	7.3000	6.5000	7.3000	555.0000	11680.00	6570.00	0.00	16	5	16	40	0.4	0.302216550487413	0.302216550487413	false	false	false	true
2a95f07b-feeb-450d-82bc-98e13a9e3389	2026-09-21 14:05	2026-09-21 14:05	2026-09-21 14:05	ULTA	ULTA261218C00720000	call	720.0000	2026-12-18	4.1700	3.7000	4.7000	560.0000	20850.00	10008.00	10842.00	50	9	95	75	1.26666666666667	0.353664689665985	0.353664689665985	false	false	false	true
2efbe18a-2351-4a8f-909a-746be2fa00e9	2026-09-21 13:59	2026-09-21 13:59	2026-09-21 13:59	ULTA	ULTA261218C00720000	call	720.0000	2026-12-18	3.9700	2.0000	4.9000	560.0800	17848.00	6336.00	11512.00	45	8	45	75	0.6	0.3495370466237	0.351270024181696	true	false	false	true
ea82f36a-2ee1-4819-9369-06ef62919e68	2026-09-18 13:42	2026-09-18 13:42	2026-09-18 13:42	ULTA	ULTA261002C00575000	call	575.0000	2026-10-02	2.7500	0.5000	3.7000	543.9200	19255.00	550.00	12105.00	70	47	70	56	1.25	0.284672862793735	0.286500083412933	true	false	false	true
43cef9dd-0cb1-4f26-b222-9e6eb268ba9a	2026-09-17 14:19	2026-09-17 14:19	2026-09-17 14:19	ULTA	ULTA261218P00460000	put	460.0000	2026-12-18	9.5000	9.4000	10.3000	544.0250	56050.00	2850.00	53200.00	59	24	88	139	0.633093525179856	0.38918395307305	0.38918395307305	true	false	false	true
4323f346-845a-4e02-b8b1-17647986beda	2026-09-17 11:00	2026-09-17 11:00	2026-09-17 11:00	ULTA	ULTA261120C00585000	call	585.0000	2026-11-20	15.5000	13.6000	15.5000	545.7600	62000.00	62000.00	0.00	40	12	40	17	2.35294117647059	0.31691905221833	0.31691905221833	false	false	false	true
307e317b-538f-4d30-b880-39e2c00ea695	2026-09-15 13:56	2026-09-15 13:56	2026-09-15 13:56	ULTA	ULTA261120C00610000	call	610.0000	2026-11-20	9.0000	7.7000	9.0000	542.5800	10798.00	10798.00	0.00	12	8	12	34	0.352941176470588	0.316247326861401	0.316247326861401	false	false	false	true
b0dc36fa-e758-4fbe-96e7-1d6f29b9c64d	2026-09-15 13:07	2026-09-15 13:07	2026-09-15 13:07	ULTA	ULTA261016P00545000	put	545.0000	2026-10-16	21.5000	20.2000	21.5000	540.7150	103200.00	103200.00	0.00	48	8	80	5	16	0.321879469275212	0.321879469275212	false	false	false	true
6f692cdd-f333-4ccd-a6bb-1d1ba63a161f	2026-09-15 12:19	2026-09-15 12:18	2026-09-15 12:18	ULTA	ULTA261009C00575000	call	575.0000	2026-10-09	6.1000	4.9000	6.1000	539.6775	14640.00	14640.00	0.00	24	12	24	5	4.8	0.320507921476191	0.320507921476191	false	false	false	true
d8c80006-013b-40f0-aa81-ef1099775124	2026-09-14 15:14	2026-09-14 15:14	2026-09-14 15:14	ULTA	ULTA260918C00567500	call	567.5000	2026-09-18	3.0000	2.1500	3.0000	551.6400	15300.00	15300.00	0.00	51	13	52	3	17.3333333333333	0.370638562759602	0.370638562759602	false	false	false	true
c3ce1e60-b876-47fd-b75d-29226f694682	2026-09-14 15:14	2026-09-14 15:14	2026-09-14 15:14	ULTA	ULTA260918C00575000	call	575.0000	2026-09-18	1.7500	1.4500	1.7500	551.6400	18719.00	18549.00	170.00	107	29	130	88	1.47727272727273	0.379578133405757	0.379578133405757	false	false	false	true
92a01931-27ea-457b-a94b-639d707e5eca	2026-09-14 13:00	2026-09-14 13:00	2026-09-14 13:00	ULTA	ULTA260925P00522500	put	522.5000	2026-09-25	3.5000	2.9500	3.5000	549.3300	12600.00	12600.00	0.00	36	9	36	0	0	0.345440212431304	0.345440212431304	false	false	false	true
8e88bb7e-5678-4c59-bed5-bbdb333ae9d5	2026-09-14 11:33	2026-09-14 11:32	2026-09-14 11:32	ULTA	ULTA261120C00590000	call	590.0000	2026-11-20	13.9000	12.3000	13.9000	543.6600	70890.00	70890.00	0.00	51	14	51	13	3.92307692307692	0.315149884986353	0.315149884986353	false	false	false	true
7b591f39-9708-4bda-9fd9-f4e6addc7586	2026-09-14 11:33	2026-09-14 11:32	2026-09-14 11:32	ULTA	ULTA261120C00570000	call	570.0000	2026-11-20	20.4000	18.7000	20.4000	543.6600	42840.00	42840.00	0.00	21	12	21	26	0.807692307692308	0.318494037799827	0.318494037799827	false	false	false	true
a02f336a-1eb6-482e-bd14-0b98b33de4a8	2026-09-11 11:03	2026-09-11 11:03	2026-09-11 11:03	ULTA	ULTA261120P00545000	put	545.0000	2026-11-20	31.4000	29.9000	31.4000	539.1150	65940.00	65940.00	0.00	21	10	21	14	1.5	0.323918769961822	0.323918769961822	false	false	false	true
247169cd-37eb-4651-a429-22997b112045	2026-09-11 11:03	2026-09-11 11:03	2026-09-11 11:03	ULTA	ULTA261120P00530000	put	530.0000	2026-11-20	24.2000	22.9000	24.2000	539.1150	26620.00	26620.00	0.00	11	11	11	20	0.55	0.326279940722052	0.326279940722052	false	false	false	true
687e3fc5-fbc8-44ab-948a-c66db7b3a4a2	2026-09-10 11:59	2026-09-10 11:59	2026-09-10 11:59	ULTA	ULTA261016P00540000	put	540.0000	2026-10-16	20.5000	19.1000	21.3000	539.4850	10250.00	8200.00	2050.00	5	5	8	12	0.666666666666667	0.315386980640813	0.315386980640813	false	false	false	true
867c552c-b8a9-4651-ba1d-f0c3d6520413	2026-09-08 12:56	2026-09-08 12:55	2026-09-08 12:55	ULTA	ULTA260918P00530000	put	530.0000	2026-09-18	6.6500	6.6000	7.3000	543.2000	396627.00	75207.00	321420.00	596	30	596	102	5.84313725490196	0.355832152996225	0.346490874790146	true	false	false	true
553d8407-8b59-4b75-829d-87e726b25c5d	2026-09-08 12:53	2026-09-08 12:53	2026-09-08 12:53	ULTA	ULTA261218P00510000	put	510.0000	2026-12-18	25.0000	23.7000	25.0000	542.8000	25000.00	25000.00	0.00	10	5	11	27	0.407407407407407	0.377588004283229	0.377588004283229	false	false	false	true
2b056f56-3639-45f5-b050-e4b0993e67b3	2026-09-08 09:34	2026-09-08 09:33	2026-09-08 09:33	ULTA	ULTA261016P00600000	put	600.0000	2026-10-16	48.0000	45.0000	49.8000	555.0300	96000.00	4800.00	4800.00	20	18	20	0	0	0.268521609487067	0.268521609487067	false	false	false	true
b2247429-4eb7-4acc-958e-152976938f00	2026-09-04 14:02	2026-09-04 14:02	2026-09-04 14:02	ULTA	ULTA270115C00660000	call	660.0000	2027-01-15	18.9000	17.2000	19.0000	566.1750	28350.00	15120.00	13230.00	15	5	19	237	0.080168776371308	0.343910776230868	0.343910776230868	false	false	false	true
5a515f65-e3a2-466d-aa0e-6c06bae40e1d	2026-09-03 12:53	2026-09-03 12:53	2026-09-03 12:53	ULTA	ULTA261016C00555000	call	555.0000	2026-10-16	25.0100	25.0000	26.3000	555.2800	225110.00	27610.00	197500.00	90	8	90	5	18	0.311581449807203	0.311581449807203	false	false	false	true
e3d89d4f-c6ac-425e-ae3a-cfd7f6095c21	2026-09-03 11:03	2026-09-03 11:03	2026-09-03 11:03	ULTA	ULTA260904C00560000	call	560.0000	2026-09-04	5.9500	2.8000	6.0000	558.1200	29750.00	15000.00	14750.00	50	5	51	69	0.739130434782609	0.58876120709559	0.58876120709559	false	false	false	true
d92d6152-3590-454a-8ea9-7a1cd0ffef62	2026-09-02 12:58	2026-09-02 12:57	2026-09-02 12:57	ULTA	ULTA261218C00595000	call	595.0000	2026-12-18	31.1000	31.1000	32.2000	558.4200	111960.00	0.00	111960.00	36	7	36	5	7.2	0.359015226132738	0.359015226132738	false	false	false	true
b4e8eed7-9e3b-4c4d-882d-fb87b9850be2	2026-09-01 14:27	2026-09-01 14:27	2026-09-01 14:27	ULTA	ULTA260918C00550000	call	550.0000	2026-09-18	13.6000	13.5000	14.5000	544.7700	34000.00	0.00	34000.00	25	7	51	367	0.138964577656676	0.33203454341988	0.33203454341988	false	false	false	true
c806589c-fa4a-4e4f-a275-29bb4f14045e	2026-08-31 13:35	2026-08-31 13:34	2026-08-31 13:34	ULTA	ULTA261218P00370000	put	370.0000	2026-12-18	1.8000	1.8000	2.7500	535.9300	18184.00	0.00	18184.00	101	25	103	43	2.3953488372093	0.410957509836103	0.410957509836103	false	false	false	true
18e034d7-2afe-49a4-b410-90597edf9bd7	2026-08-31 12:22	2026-08-31 12:22	2026-08-31 12:22	ULTA	ULTA260911P00517500	put	517.5000	2026-09-11	3.8900	1.0000	8.9000	536.0600	15551.00	11822.00	3729.00	40	13	40	0	0	0.318505058913523	0.284950547108645	false	false	false	true
97b6a5f7-9023-4ab1-b2b6-af6b9ab70545	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	ULTA	ULTA260918P00532500	put	532.5000	2026-09-18	15.4000	13.4000	15.4000	532.7400	127820.00	127820.00	0.00	83	20	107	51	2.09803921568627	0.343221482685934	0.339821280389314	false	false	false	true
f292d40e-4af8-4cd9-9bcd-5b6a684e52e2	2026-08-31 09:31	2026-08-31 09:31	2026-08-31 09:31	ULTA	ULTA260904C00497500	call	497.5000	2026-09-04	33.9000	22.0000	35.9000	531.0000	16950.00	16950.00	0.00	5	5	5	0	0	0.328210757506973	0.328210757506973	false	false	false	true
6d20a784-36d8-4ce8-9f4c-ba123aefc775	2026-08-28 15:23	2026-08-28 15:23	2026-08-28 15:23	ULTA	ULTA260828P00535000	put	535.0000	2026-08-28	17.5000	14.5000	21.3000	516.0701	17500.00	0.00	17500.00	10	6	277	264	1.04924242424242	5.01499510528858	4.40507783779976	false	false	false	true
b5b8b53e-c3d5-4e5d-8d42-28772011d63a	2026-08-28 14:36	2026-08-28 14:36	2026-08-28 14:36	ULTA	ULTA260918C00540000	call	540.0000	2026-09-18	7.5000	7.2000	8.3000	516.9538	20250.00	12750.00	7500.00	27	18	41	216	0.189814814814815	0.319426018895144	0.319426018895144	true	false	false	true
593d2834-1842-4dac-a63a-486bfef05372	2026-08-28 14:32	2026-08-28 14:32	2026-08-28 14:32	ULTA	ULTA261218P00445000	put	445.0000	2026-12-18	12.8000	12.8000	13.5000	515.6650	106240.00	0.00	106240.00	83	28	84	10	8.4	0.378038715021633	0.378038715021633	false	false	false	true
e7db8d5b-fab5-43b8-b6b4-a1e5b6a2d90d	2026-08-28 13:15	2026-08-28 13:15	2026-08-28 13:15	ULTA	ULTA260918P00515000	put	515.0000	2026-09-18	15.0000	15.0000	17.4000	515.4200	46510.00	1510.00	45000.00	31	6	49	32	1.53125	0.320132133319827	0.320132133319827	false	false	false	true
2ddd2bac-330c-401d-bf26-0916f7f5b432	2026-08-28 10:16	2026-08-28 10:16	2026-08-28 10:16	ULTA	ULTA260828P00515000	put	515.0000	2026-08-28	7.2000	7.2000	13.8000	507.0900	43200.00	0.00	43200.00	60	5	114	184	0.619565217391304	1.78992780370413	1.78992780370413	false	false	false	true
eb6ecaaa-801b-47af-af9e-d29919fbf1f2	2026-08-28 09:46	2026-08-28 09:46	2026-08-28 09:46	ULTA	ULTA260828P00517500	put	517.5000	2026-08-28	4.6000	3.6000	4.6000	520.9450	23000.00	23000.00	0.00	50	16	152	152	1	1.11840662873657	1.11840662873657	true	false	false	true
231a37d4-c2c4-4035-9e24-b15d4906997c	2026-08-28 09:45	2026-08-28 09:45	2026-08-28 09:45	ULTA	ULTA260828P00517500	put	517.5000	2026-08-28	6.0000	4.4000	6.0000	517.9100	30000.00	30000.00	0.00	50	5	102	152	0.671052631578947	1.1264785328347	1.1264785328347	false	false	false	true
c4924a56-9617-429b-937a-a155b4605d1d	2026-08-28 09:44	2026-08-28 09:44	2026-08-28 09:44	ULTA	ULTA260828P00517500	put	517.5000	2026-08-28	6.9000	5.1000	8.2000	516.3600	26910.00	26220.00	690.00	39	9	52	152	0.342105263157895	1.14606103133587	1.14606103133587	true	false	false	true
0b5790a8-dc6a-495a-a8b6-edd1c13f1f30	2026-08-28 09:40	2026-08-28 09:40	2026-08-28 09:40	ULTA	ULTA260828P00530000	put	530.0000	2026-08-28	13.8700	13.0000	17.3000	519.0100	13872.00	0.00	13872.00	10	5	37	247	0.149797570850202	1.26017087351748	1.26017087351748	false	false	false	true
6bec4174-4002-4548-aa87-425d073eb081	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	ULTA	ULTA260904C00465000	call	465.0000	2026-09-04	69.0000	69.0000	76.5000	536.4000	89700.00	0.00	89700.00	13	8	14	0	0	0.961898341116762	0.961898341116762	false	false	false	true
72600ea8-3e91-4ad5-8db5-ea10cbec52f0	2026-08-27 15:48	2026-08-27 15:48	2026-08-27 15:48	ULTA	ULTA260828C00540000	call	540.0000	2026-08-28	23.7000	22.1000	27.3000	542.6600	23700.00	18960.00	4740.00	10	5	229	136	1.68382352941176	1.97516014682212	1.97516014682212	false	false	false	true
ca45854a-73e0-4ad3-9163-2d75c0e22e79	2026-08-27 15:47	2026-08-27 15:46	2026-08-27 15:46	ULTA	ULTA260828C00540000	call	540.0000	2026-08-28	22.0000	19.8000	22.0000	539.0150	11000.00	11000.00	0.00	5	5	197	136	1.44852941176471	1.9947897956095	1.9947897956095	false	false	false	true
6e27bcd4-0de7-4abd-96ea-f95d48985924	2026-08-27 15:45	2026-08-27 15:45	2026-08-27 15:45	ULTA	ULTA260828P00470000	put	470.0000	2026-08-28	2.4400	1.9500	2.5500	532.6500	10001.00	2651.00	7350.00	41	7	209	73	2.86301369863014	1.88275134872485	1.88795155065483	false	false	false	true
7a564442-eaf6-4e0c-a17b-74da8794197a	2026-08-27 15:43	2026-08-27 15:43	2026-08-27 15:43	ULTA	ULTA260918C00570000	call	570.0000	2026-09-18	12.3000	12.2000	12.6000	531.1400	115623.00	0.00	99633.00	94	32	104	97	1.07216494845361	0.501496044368229	0.502374172237449	false	false	false	true
a8f61f8b-c7d7-4a5e-baa0-c0e4999e8cfe	2026-08-27 14:37	2026-08-27 14:37	2026-08-27 14:37	ULTA	ULTA270115C00700000	call	700.0000	2027-01-15	10.2000	10.1000	10.5000	531.6750	10200.00	9180.00	1020.00	10	6	15	203	0.0738916256157636	0.385298609515701	0.385298609515701	false	false	false	true
c6ca8332-e4cd-4849-b896-43d48142fee2	2026-08-27 14:33	2026-08-27 14:33	2026-08-27 14:33	ULTA	ULTA261218P00585000	put	585.0000	2026-12-18	77.0000	77.0000	79.8000	530.5400	231000.00	0.00	231000.00	30	15	30	3	10	0.402739196355345	0.402739196355345	false	false	false	true
a4dc48b6-55fb-470d-84fe-5b75ff564eb2	2026-08-27 13:16	2026-08-27 13:16	2026-08-27 13:16	ULTA	ULTA260918P00510000	put	510.0000	2026-09-18	17.1000	17.0000	18.2000	531.7250	13680.00	6840.00	6840.00	8	7	66	147	0.448979591836735	0.530591264146538	0.530591264146538	true	false	false	true
08fe11ad-4c52-4fb7-a459-0f44a34596a1	2026-08-27 12:35	2026-08-27 12:35	2026-08-27 12:35	ULTA	ULTA270115C00540000	call	540.0000	2027-01-15	53.3300	51.2000	55.9000	531.8700	106660.00	0.00	106660.00	20	9	20	460	0.0434782608695652	0.404673549402974	0.404673549402974	false	false	false	true
f8c9cde9-e381-48ce-a7a2-4cb17993ac4f	2026-08-27 11:24	2026-08-27 11:24	2026-08-27 11:24	ULTA	ULTA260828C00615000	call	615.0000	2026-08-28	1.9000	1.4500	2.3000	535.2900	19000.00	13300.00	570.00	100	18	102	26	3.92307692307692	1.85133920898516	1.85133920898516	false	false	false	true