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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = SOXL×

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

d3114e2b-badf-4e20-9198-0315af47046d	2026-09-17 15:53	2026-09-17 15:53	2026-09-17 15:53	SOXL	SOXL260918C00120000	call	120.0000	2026-09-18	0.7900	0.7700	0.7900	115.0000	39469.00	39469.00	0.00	500	17	19321	7468	2.58717193358329	1.01608607731535	1.02159630133253	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	18257138238.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
8c83ee35-5fda-4ce0-900a-fa41e78ca824	2026-09-17 15:52	2026-09-17 15:52	2026-09-17 15:52	SOXL	SOXL260918C00120000	call	120.0000	2026-09-18	0.7500	0.7100	0.7600	115.0000	23665.00	18415.00	5250.00	314	47	17929	7468	2.40077664702732	1.00377529339197	1.00377529339197	true	false	false	true
8eca8b36-61b9-4779-ba9a-0aa9507867c5	2026-09-17 15:46	2026-09-17 15:46	2026-09-17 15:46	SOXL	SOXL261016C00150000	call	150.0000	2026-10-16	3.6000	3.6000	3.7500	114.9650	104413.00	363.00	104050.00	290	37	4719	1170	4.03333333333333	1.01315496541917	1.01326925600182	true	false	false	true
fbdf3389-0350-494b-982b-87750eca23a8	2026-09-17 15:44	2026-09-17 15:44	2026-09-17 15:44	SOXL	SOXL261016C00120000	call	120.0000	2026-10-16	11.2900	11.1500	11.3500	114.8350	33882.00	32757.00	0.00	30	11	1426	1026	1.38986354775828	1.02871003255264	1.03625987229668	true	false	false	true
d70844fa-c316-4fe8-887d-917481360196	2026-09-17 15:44	2026-09-17 15:44	2026-09-17 15:44	SOXL	SOXL261016P00100000	put	100.0000	2026-10-16	7.1400	7.0000	7.1500	114.8350	25710.00	25000.00	710.00	36	10	1239	2410	0.514107883817427	1.1111807720847	1.1159643059671	true	false	false	true
7f773af2-4c4b-4628-855b-447ed2cbb19a	2026-09-17 15:44	2026-09-17 15:44	2026-09-17 15:44	SOXL	SOXL261016P00111000	put	111.0000	2026-10-16	11.7000	11.5000	12.0500	114.8350	58480.00	53820.00	4660.00	50	10	162	149	1.08724832214765	1.0759660697919	1.08416414104001	true	false	false	true
56c69f20-47ff-4f28-92f7-3d4dd1540e31	2026-09-17 15:44	2026-09-17 15:44	2026-09-17 15:44	SOXL	SOXL261016P00095000	put	95.0000	2026-10-16	5.6000	5.5000	5.6000	114.8350	46470.00	46470.00	0.00	83	14	510	1744	0.29243119266055	1.13325113769214	1.13854329680986	false	false	false	true
95e40577-63a7-4267-b7e1-34e231b48536	2026-09-17 15:41	2026-09-17 15:41	2026-09-17 15:41	SOXL	SOXL260918C00120000	call	120.0000	2026-09-18	0.7000	0.6700	0.7200	115.2850	28124.00	27982.00	142.00	400	40	15153	7468	2.02905731119443	0.951114381866386	0.962317382210972	true	false	false	true
68ad11da-2ee1-46c6-8acf-a8ab84f1395a	2026-09-17 15:40	2026-09-17 15:40	2026-09-17 15:40	SOXL	SOXL260918C00120000	call	120.0000	2026-09-18	0.6800	0.6600	0.6900	115.2616	27048.00	16304.00	10744.00	400	26	14743	7468	1.97415640064274	0.934147845181024	0.94267997973171	true	false	false	true
2ac958c7-5040-47a6-a40c-2f82ec5513c5	2026-09-17 15:26	2026-09-17 15:26	2026-09-17 15:26	SOXL	SOXL260925C00130000	call	130.0000	2026-09-25	1.5400	1.3700	1.7300	114.7650	15445.00	3388.00	12057.00	100	11	2030	6606	0.307296397214653	0.898570219978116	0.900710732700439	true	false	false	true
2a472940-b50e-483b-b7fc-c3def09c8d03	2026-09-17 15:24	2026-09-17 15:23	2026-09-17 15:23	SOXL	SOXL261016C00125000	call	125.0000	2026-10-16	9.2500	9.1500	9.3000	114.9600	11097.00	10172.00	925.00	12	6	430	1226	0.350734094616639	1.00761180306832	1.00839314578522	false	false	false	true
59344277-e044-4fe0-99a3-d2cb676a99f6	2026-09-17 15:15	2026-09-17 15:15	2026-09-17 15:15	SOXL	SOXL261016P00105000	put	105.0000	2026-10-16	8.9000	8.8000	8.9500	114.9100	44480.00	40940.00	3540.00	50	17	397	1091	0.363886342804766	1.08631391699979	1.09061050118459	true	false	false	true
3eb2cc11-a5a4-4811-93e2-2a6bc6e384c1	2026-09-17 15:15	2026-09-17 15:15	2026-09-17 15:15	SOXL	SOXL261016C00115000	call	115.0000	2026-10-16	13.4600	13.3000	13.5000	114.9100	40380.00	40380.00	0.00	30	14	410	432	0.949074074074074	1.03523185100263	1.0391476187376	false	false	false	true
144bc934-80d9-42b3-885f-e168a6c7649e	2026-09-17 15:15	2026-09-17 15:15	2026-09-17 15:15	SOXL	SOXL261016C00118000	call	118.0000	2026-10-16	12.0900	11.9500	12.1500	114.9100	20560.00	9670.00	6050.00	17	10	137	60	2.28333333333333	1.02627672293159	1.02974673334562	false	false	false	true
232cbd9c-a795-42ae-adbc-a02bb47fd078	2026-09-17 14:42	2026-09-17 14:42	2026-09-17 14:42	SOXL	SOXL260925C00115000	call	115.0000	2026-09-25	6.1100	6.1000	6.7000	114.9200	15880.00	625.00	15255.00	26	10	550	853	0.644783118405627	0.89800338055457	0.920155133469331	true	false	false	true
67ca97f9-2274-46b5-9c3f-536dc14f3399	2026-09-17 14:15	2026-09-17 14:15	2026-09-17 14:15	SOXL	SOXL261016C00150000	call	150.0000	2026-10-16	3.5000	3.4000	3.5000	115.2443	426831.00	426831.00	0.00	1220	43	3472	1170	2.96752136752137	0.995366983292897	0.996419062536524	false	false	false	true
52ca513a-06c2-4c63-9e97-fa504612a6da	2026-09-17 14:13	2026-09-17 14:13	2026-09-17 14:13	SOXL	SOXL261016C00100000	call	100.0000	2026-10-16	21.9800	21.9500	22.1000	115.2750	145080.00	57200.00	61480.00	66	28	466	1120	0.416071428571429	1.05296347717972	1.05768882510747	false	false	false	true
775dd023-caaa-4589-a446-6ddaa61f6f36	2026-09-17 14:13	2026-09-17 14:13	2026-09-17 14:13	SOXL	SOXL261016C00100000	call	100.0000	2026-10-16	22.0300	22.0000	22.1000	115.2783	158632.00	50715.00	61612.00	72	32	400	1120	0.357142857142857	1.05745883455174	1.06218001338079	false	false	false	true
8f567558-82f7-40ac-ab49-8d035bb5d07c	2026-09-17 13:03	2026-09-17 13:03	2026-09-17 13:03	SOXL	SOXL260918C00120000	call	120.0000	2026-09-18	0.7500	0.7200	0.7550	115.1550	52256.00	51745.00	511.00	700	47	6533	7468	0.874799143010177	0.983942098816313	0.995109931501423	true	false	false	true
90f7dc5f-e55c-4f67-a816-65e1bd707fb7	2026-09-17 13:00	2026-09-17 13:00	2026-09-17 13:00	SOXL	SOXL260918P00114000	put	114.0000	2026-09-18	1.9600	1.9300	2.0000	115.1800	14082.00	0.00	14082.00	72	9	1899	567	3.34920634920635	1.04896131847772	1.04969777763591	true	false	false	true
68a4f644-5ed6-4621-9961-0052679b2b9f	2026-09-17 12:32	2026-09-17 12:31	2026-09-17 12:31	SOXL	SOXL261016C00115000	call	115.0000	2026-10-16	13.4500	13.4000	13.5000	114.8950	26896.00	20171.00	0.00	20	7	321	432	0.743055555555556	1.03510784469479	1.0358910194273	false	false	false	true
279b2a17-b101-4e32-b54c-8882b7b54595	2026-09-17 11:10	2026-09-17 11:10	2026-09-17 11:10	SOXL	SOXL261016C00111000	call	111.0000	2026-10-16	15.1500	15.0500	15.2000	114.2400	10602.00	9087.00	1515.00	7	5	40	113	0.353982300884956	1.05280113315121	1.05408894343648	false	false	false	true
f15bd771-14cb-4698-839d-157d1ef4056a	2026-09-17 11:09	2026-09-17 11:08	2026-09-17 11:08	SOXL	SOXL261120C00200000	call	200.0000	2026-11-20	3.9600	3.2000	4.5000	114.5500	11475.00	9500.00	1975.00	29	11	74	712	0.103932584269663	1.10625975045861	1.10625975045861	false	false	false	true
4df088eb-512b-4b52-bcd4-4cd9ecf00a6e	2026-09-17 11:04	2026-09-17 11:04	2026-09-17 11:04	SOXL	SOXL260923C00116000	call	116.0000	2026-09-23	4.5000	4.4000	4.6000	114.0212	13054.00	0.00	12604.00	29	10	58	3	19.3333333333333	0.918516050356051	0.918516050356051	true	false	false	true
a645af2c-270c-4dae-9f0d-23e914b63f96	2026-09-17 11:02	2026-09-17 11:02	2026-09-17 11:02	SOXL	SOXL261016C00110000	call	110.0000	2026-10-16	15.4800	15.3500	15.8000	113.9901	24772.00	20127.00	3095.00	16	12	299	1674	0.178614097968937	1.05041052255584	1.05527717740892	true	false	false	true
7ff70a27-fda7-49b7-99e4-da89db168192	2026-09-17 10:21	2026-09-17 10:21	2026-09-17 10:21	SOXL	SOXL280121C00145000	call	145.0000	2028-01-21	46.9200	46.2500	48.2000	114.2300	46918.00	9382.00	37536.00	10	6	92	800	0.115	1.05125497634397	1.05125497634397	false	false	false	true
edc36de3-943a-4c87-b111-e0dadf444e36	2026-09-17 10:20	2026-09-17 10:20	2026-09-17 10:20	SOXL	SOXL280121C00145000	call	145.0000	2028-01-21	47.0200	45.9000	49.5000	114.3880	47016.00	0.00	47016.00	10	5	72	800	0.09	1.0510991629618	1.0513099069965	false	false	false	true
3eea9f7a-8df1-4365-8c1e-f0f47eaad5a8	2026-09-17 10:12	2026-09-17 10:12	2026-09-17 10:12	SOXL	SOXL260918C00110000	call	110.0000	2026-09-18	5.8000	5.6500	5.9000	114.3700	146147.00	144987.00	1160.00	252	17	1607	6277	0.256014019436036	1.32778062225158	1.33821299061108	false	false	false	true
2e18b50d-167b-4fb6-bddc-d25c89ae917a	2026-09-17 09:55	2026-09-17 09:55	2026-09-17 09:55	SOXL	SOXL260918P00110000	put	110.0000	2026-09-18	1.1900	1.1100	1.2100	115.1300	61856.00	60423.00	600.00	518	57	2843	6575	0.432395437262357	1.31018635923397	1.3278687670573	true	false	false	true
fe9a4d70-084e-4720-a18b-231a92abf3f3	2026-09-17 09:47	2026-09-17 09:46	2026-09-17 09:46	SOXL	SOXL260918P00113000	put	113.0000	2026-09-18	2.5000	2.4300	2.5200	114.0050	10482.00	6495.00	3987.00	42	9	513	324	1.58333333333333	1.25380871181544	1.25806989263995	true	false	false	true
609a9738-8585-4e61-997b-9ce62b5aee05	2026-09-17 09:33	2026-09-17 09:33	2026-09-17 09:33	SOXL	SOXL261016P00105000	put	105.0000	2026-10-16	9.2800	9.2000	9.5500	113.3200	12997.00	9297.00	3700.00	14	6	41	1091	0.0375802016498625	1.07542393304454	1.07884284861858	false	false	false	true
bd791bbb-3324-4afc-9c60-d4147ccfda2c	2026-09-16 15:08	2026-09-16 15:08	2026-09-16 15:08	SOXL	SOXL260918P00095000	put	95.0000	2026-09-18	1.5100	1.3900	1.5100	102.1250	22426.00	22426.00	0.00	149	6	2139	6171	0.346621293145357	1.41869577926662	1.42306314491771	false	false	false	true
c4271051-6928-4e70-acda-66a0a55daa0d	2026-09-16 12:33	2026-09-16 12:33	2026-09-16 12:33	SOXL	SOXL260925C00117000	call	117.0000	2026-09-25	3.7100	3.6500	4.2000	107.9013	13740.00	7030.00	6340.00	37	8	71	80	0.8875	1.04329904670581	1.04329904670581	true	false	false	true
dbb9d0ed-cbb3-4b57-a2ff-b0cf6ec2e445	2026-09-16 10:32	2026-09-16 10:32	2026-09-16 10:32	SOXL	SOXL260918P00105000	put	105.0000	2026-09-18	2.9600	2.8000	2.9600	107.0000	36099.00	36099.00	0.00	122	7	521	4698	0.110898254576416	1.35969644977928	1.36300613085229	true	false	false	true
bf9b278d-f2b9-4e8c-be8d-20582b16b243	2026-09-16 09:58	2026-09-16 09:58	2026-09-16 09:58	SOXL	SOXL261218C00110000	call	110.0000	2026-12-18	23.3900	22.2500	24.2500	108.5300	46775.00	0.00	39800.00	20	5	23	532	0.0432330827067669	1.08254483596872	1.09440731493326	false	false	false	true
4af98781-f15b-49f7-b203-f3fa610bf897	2026-09-16 09:47	2026-09-16 09:47	2026-09-16 09:47	SOXL	SOXL260918C00105000	call	105.0000	2026-09-18	5.6400	5.4000	6.0000	107.7600	28200.00	0.00	28200.00	50	5	650	2324	0.279690189328744	1.22606382314211	1.30890831476615	false	false	false	true
55ed1286-441b-440a-a01c-96452b5dca21	2026-09-16 09:45	2026-09-16 09:45	2026-09-16 09:45	SOXL	SOXL260916C00105000	call	105.0000	2026-09-16	3.6100	3.5000	3.7000	107.5800	12260.00	12260.00	0.00	34	5	710	2853	0.248860848229933	1.81720798474643	1.81720798474643	false	false	false	true
03cab8e1-3262-4153-9fa3-fc77a3877148	2026-09-16 09:36	2026-09-16 09:36	2026-09-16 09:36	SOXL	SOXL261016C00120000	call	120.0000	2026-10-16	7.9000	7.6500	8.1000	107.3200	66356.00	66356.00	0.00	84	7	100	975	0.102564102564103	1.01558137124196	1.0172530830321	true	false	false	true
24b62050-bd02-43f5-bed7-b9024776447c	2026-09-16 09:34	2026-09-16 09:34	2026-09-16 09:34	SOXL	SOXL260918C00112000	call	112.0000	2026-09-18	2.0000	1.8500	2.0000	106.8100	12199.00	12199.00	0.00	61	10	84	706	0.118980169971671	1.2588928210446	1.26128020529764	false	false	false	true
f07defdc-cef0-4581-a509-4c89459e7e17	2026-09-16 09:31	2026-09-16 09:31	2026-09-16 09:31	SOXL	SOXL261016P00100000	put	100.0000	2026-10-16	9.5000	9.4000	10.0500	107.1600	76958.00	1905.00	75053.00	81	43	110	2191	0.0502053856686445	1.09010229283172	1.09533581002923	true	false	false	true
aa6cc097-c8b1-4418-8019-c0be794f659e	2026-09-16 09:31	2026-09-16 09:31	2026-09-16 09:31	SOXL	SOXL261016P00105000	put	105.0000	2026-10-16	11.8200	11.5500	12.5500	107.1600	44925.00	18960.00	25965.00	38	6	39	1109	0.0351668169522092	1.07638966758924	1.07844651061411	true	false	false	true
db4eadae-8048-49f1-8b53-684ee8956e4c	2026-09-16 09:31	2026-09-16 09:30	2026-09-16 09:30	SOXL	SOXL260918P00101000	put	101.0000	2026-09-18	1.8000	1.7200	2.6000	107.3800	14900.00	2451.00	12273.00	83	45	83	1099	0.0755232029117379	1.37569043238751	1.35734904727779	true	false	false	true
28ecdaec-6729-4b46-98c8-784cde987833	2026-09-16 09:31	2026-09-16 09:30	2026-09-16 09:30	SOXL	SOXL260918P00102000	put	102.0000	2026-09-18	2.0800	1.6100	2.9100	107.3900	24922.00	11993.00	12929.00	120	10	120	1432	0.0837988826815642	1.3631943768198	1.36794677753308	true	false	false	true
8e5d070a-936c-43d0-9804-ad0629ff0d97	2026-09-15 14:39	2026-09-15 14:39	2026-09-15 14:39	SOXL	SOXL261016C00114000	call	114.0000	2026-10-16	7.6500	7.6500	7.8000	101.6350	158359.00	0.00	158359.00	207	41	269	23	11.695652173913	1.02399144938995	1.02399144938995	false	false	false	true
a33dce38-b6b3-4745-a78c-50cd99992a1f	2026-09-15 14:03	2026-09-15 14:03	2026-09-15 14:03	SOXL	SOXL270115P00040000	put	40.0000	2027-01-15	2.2800	2.2600	2.4900	102.0500	17134.00	0.00	17134.00	75	6	501	4930	0.101622718052738	1.3050974663344	1.31798633503455	false	false	false	true
b233628b-0ead-4b2d-859e-4813579664d0	2026-09-15 13:22	2026-09-15 13:22	2026-09-15 13:22	SOXL	SOXL260916C00102000	call	102.0000	2026-09-16	2.4700	2.4600	2.4900	101.4400	24715.00	0.00	24715.00	100	12	3824	308	12.4155844155844	1.28828081191438	1.28828081191438	false	false	false	true
b7269573-0dc9-42e2-ad10-037e98d5d131	2026-09-15 13:21	2026-09-15 13:20	2026-09-15 13:20	SOXL	SOXL260916C00102000	call	102.0000	2026-09-16	2.5500	2.5100	2.5500	101.6500	25459.00	25459.00	0.00	100	14	3709	308	12.0422077922078	1.27301248968493	1.27772430294679	true	false	false	true
fb9c9d40-fa80-40d0-aa19-4616b12fd5fa	2026-09-15 13:15	2026-09-15 13:15	2026-09-15 13:15	SOXL	SOXL260916P00101000	put	101.0000	2026-09-16	2.6100	2.6100	2.6400	101.2750	26120.00	0.00	26120.00	100	23	1824	290	6.28965517241379	1.30273859780219	1.30273859780219	false	false	false	true
362d630b-00d0-4a25-bd02-79ceef19935c	2026-09-15 12:42	2026-09-15 12:41	2026-09-15 12:41	SOXL	SOXL260916P00101000	put	101.0000	2026-09-16	2.4400	2.4200	2.4900	101.0000	24436.00	0.00	24436.00	100	6	1035	290	3.56896551724138	1.3069618944453	1.304833916912	false	false	false	true
7afb1c97-a9bf-4d40-aef5-154be54913c8	2026-09-15 12:20	2026-09-15 12:20	2026-09-15 12:20	SOXL	SOXL280121C00100000	call	100.0000	2028-01-21	48.4900	48.0000	50.0000	101.0000	48488.00	0.00	48488.00	10	5	133	2322	0.0572782084409991	1.03939708189929	1.03992773646645	false	false	false	true