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:alert_rule = RepeatedHits×ticker = ULTA×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

95c1909f-5eef-48fd-ac31-7038fc8ddf2e	2026-08-17 09:37	2026-08-17 09:37	2026-08-17 09:37	ULTA	ULTA260911P00500000	put	500.0000	2026-09-11	24.5000	21.7000	24.5000	504.0100	188650.00	188650.00	0.00	77	23	127	48	2.64583333333333	0.517547309749183	0.517547309749183	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	23458886464.00	2026-12-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
300a867c-9c4a-47ec-a6ce-eca2bdf5dc6d	2026-08-17 11:18	2026-08-17 11:18	2026-08-17 11:18	ULTA	ULTA270115P00450000	put	450.0000	2027-01-15	26.8000	25.6000	28.0000	500.7000	13400.00	10720.00	0.00	5	5	5	280	0.0178571428571429	0.419830716107422	0.419830716107422	false	false	false	true
4a43144e-1468-4896-86c6-a3bd21b05729	2026-08-19 10:45	2026-08-19 10:45	2026-08-19 10:45	ULTA	ULTA260918P00450000	put	450.0000	2026-09-18	3.9000	3.8000	4.6000	537.4350	18330.00	390.00	17940.00	47	15	48	201	0.238805970149254	0.516255848284915	0.516255848284915	false	false	false	true
eb783bfb-9506-4cab-bc86-01b357c5b2d5	2026-08-19 12:23	2026-08-19 12:23	2026-08-19 12:23	ULTA	ULTA260918P00515000	put	515.0000	2026-09-18	20.7000	20.4000	21.2000	533.9800	33120.00	24840.00	8280.00	16	5	27	29	0.931034482758621	0.499146192593373	0.499146192593373	false	false	false	true
322fecff-2f34-4f8b-a8d3-0f1bb07cf774	2026-08-19 15:44	2026-08-19 15:44	2026-08-19 15:44	ULTA	ULTA260904C00530000	call	530.0000	2026-09-04	27.2000	27.2000	29.9000	528.5100	19040.00	0.00	5440.00	7	7	8	3	2.66666666666667	0.623152010764002	0.623152010764002	false	false	false	true
6ed886c3-4900-4301-bcfb-c6b3a8444353	2026-08-20 12:49	2026-08-20 12:49	2026-08-20 12:49	ULTA	ULTA280121P00380000	put	380.0000	2028-01-21	28.0000	28.0000	32.3000	522.1000	25200.00	0.00	25200.00	9	7	13	46	0.282608695652174	0.421772627289094	0.421772627289094	false	false	false	true
329c8fff-282f-4dc7-9867-1b295b1717f9	2026-08-21 11:41	2026-08-21 11:41	2026-08-21 11:41	ULTA	ULTA260828C00540000	call	540.0000	2026-08-28	19.4000	18.4000	19.4000	527.1850	91177.00	91177.00	0.00	47	12	48	88	0.545454545454545	0.853085934866301	0.852046029334736	false	false	false	true
bb322389-45e6-47db-b866-1fbdd3ad8d18	2026-08-21 14:55	2026-08-21 14:55	2026-08-21 14:55	ULTA	ULTA260911P00515000	put	515.0000	2026-09-11	22.7000	22.7000	23.5000	523.5450	88530.00	0.00	88530.00	39	18	49	18	2.72222222222222	0.549658296603736	0.549658296603736	false	false	false	true
f0280050-11f1-4b31-836f-109a7650d0d1	2026-08-26 10:10	2026-08-26 10:10	2026-08-26 10:10	ULTA	ULTA260828P00517500	put	517.5000	2026-08-28	16.0000	14.7000	19.0000	533.7500	16000.00	1600.00	14400.00	10	5	10	102	0.0980392156862745	1.50015322803277	1.50015322803277	true	false	false	true
ff9490a6-e352-4b20-887d-1102dabf405f	2026-08-26 10:33	2026-08-26 10:33	2026-08-26 10:33	ULTA	ULTA261016C00540000	call	540.0000	2026-10-16	32.1000	31.0000	35.5000	533.3300	86680.00	19270.00	67410.00	27	7	28	4	7	0.426407509409191	0.427665605840433	true	false	false	true
8d4352fe-362f-4774-9a97-c267a6a8a99f	2026-08-26 12:40	2026-08-26 12:40	2026-08-26 12:40	ULTA	ULTA261218P00455000	put	455.0000	2026-12-18	15.8000	15.8000	17.5000	533.7100	88480.00	0.00	88480.00	56	18	56	9	6.22222222222222	0.422526590333194	0.422526590333194	false	false	false	true
9c6aea4d-5d58-4a9b-8b18-19db5018e0b0	2026-08-26 14:45	2026-08-26 14:45	2026-08-26 14:45	ULTA	ULTA260828P00520000	put	520.0000	2026-08-28	14.6000	14.6000	16.2000	539.1800	17520.00	0.00	17520.00	12	6	38	153	0.248366013071895	1.46956197773041	1.46956197773041	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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