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

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

80a68f11-50c2-4187-b954-cf7b313c3df8	2026-09-25 13:06	2026-09-25 13:06	2026-09-25 13:06	SOXL	SOXL261002C00145000	call	145.0000	2026-10-02	13.5000	13.3000	13.5000	153.1350	213300.00	213300.00	0.00	158	12	315	1078	0.292207792207792	1.0661142835827	1.0661142835827	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	24320054780.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T17:13:31.947650Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
b49a8b6d-0965-4ba3-b927-509b9a086a4f	2026-09-25 13:03	2026-09-25 13:03	2026-09-25 13:03	SOXL	SOXL261002C00170000	call	170.0000	2026-10-02	3.2500	3.2500	3.3000	153.2000	13000.00	0.00	13000.00	40	16	595	1148	0.518292682926829	1.04441932187589	1.04441554017869	true	false	false	true
8254a5c5-fa49-442a-8536-af1dde200f14	2026-09-25 13:03	2026-09-25 13:03	2026-09-25 13:03	SOXL	SOXL261002C00170000	call	170.0000	2026-10-02	3.2500	3.2000	3.2500	153.1800	46475.00	46475.00	0.00	143	9	555	1148	0.483449477351916	1.04668053788741	1.04517185299947	true	false	false	true
d4713c03-3034-4d3e-a634-2dc189dab88b	2026-09-25 13:03	2026-09-25 13:03	2026-09-25 13:03	SOXL	SOXL260925C00140000	call	140.0000	2026-09-25	13.1000	11.2000	13.8000	152.9201	206980.00	178160.00	28820.00	158	26	1200	3883	0.309039402523822	2.97521585618333	2.97521585618333	false	false	false	true
f2332564-6ea6-4f61-89f5-0810447ebbe0	2026-09-25 13:02	2026-09-25 13:01	2026-09-25 13:01	SOXL	SOXL261002C00163000	call	163.0000	2026-10-02	4.9500	4.9250	5.1000	152.9250	13365.00	0.00	13365.00	27	13	254	486	0.522633744855967	1.04094182658677	1.04094182658677	true	false	false	true
2d871685-470e-4287-956b-1fb9579ed6cb	2026-09-25 12:58	2026-09-25 12:58	2026-09-25 12:58	SOXL	SOXL261016P00160000	put	160.0000	2026-10-16	20.4000	20.3500	20.6000	152.2300	12240.00	0.00	8160.00	6	6	21	253	0.08300395256917	1.10487053842789	1.10487053842789	false	false	false	true
1e663780-6acc-4f65-93c5-686626d70fd8	2026-09-25 12:56	2026-09-25 12:56	2026-09-25 12:56	SOXL	SOXL260925C00154000	call	154.0000	2026-09-25	0.6000	0.6000	0.6200	152.6600	11101.00	0.00	11040.00	185	8	2849	571	4.98949211908932	1.0038766226966	1.0038766226966	true	false	false	true
7b3bfa3a-b166-4775-ab96-be2192fe4a53	2026-09-25 12:56	2026-09-25 12:56	2026-09-25 12:56	SOXL	SOXL260925C00154000	call	154.0000	2026-09-25	0.6000	0.6000	0.6200	152.7300	12900.00	0.00	12900.00	215	8	2663	571	4.66374781085814	0.981196410302987	0.981196410302987	true	false	false	true
b495e3f5-770c-4f78-91d3-d40f9f8364e7	2026-09-25 12:50	2026-09-25 12:50	2026-09-25 12:50	SOXL	SOXL261120P00041000	put	41.0000	2026-11-20	0.3900	0.3900	0.4000	152.7500	11700.00	0.00	11700.00	300	17	1023	1093	0.935956084172004	1.66498136961807	1.66498136961807	false	false	false	true
4c8a9ab2-77dd-4d1f-83c3-0933eef74820	2026-09-25 12:48	2026-09-25 12:48	2026-09-25 12:48	SOXL	SOXL260925P00149000	put	149.0000	2026-09-25	0.2000	0.1900	0.2000	152.8200	11880.00	11880.00	0.00	594	6	3023	54	55.9814814814815	1.14160123026468	1.14160123026468	true	false	false	true
b116e2ca-f94a-4d5a-a41f-e209537b1443	2026-09-25 12:40	2026-09-25 12:40	2026-09-25 12:40	SOXL	SOXL261002P00147000	put	147.0000	2026-10-02	6.3000	6.2500	6.4000	152.7750	16380.00	630.00	15120.00	26	10	99	53	1.86792452830189	1.07963780385396	1.08079177420532	true	false	false	true
f851be09-a631-407b-8d92-751f1e82fab9	2026-09-25 12:36	2026-09-25 12:36	2026-09-25 12:36	SOXL	SOXL260928C00161000	call	161.0000	2026-09-28	1.2900	1.2900	1.3600	152.7040	16383.00	0.00	16383.00	127	23	266	12	22.1666666666667	0.737430550225748	0.737430550225748	false	false	false	true
cc5fcf4f-8011-4c5b-ac3c-e5efd765e300	2026-09-25 12:36	2026-09-25 12:35	2026-09-25 12:35	SOXL	SOXL261030P00100000	put	100.0000	2026-10-30	3.6000	3.6000	4.0000	152.6800	37080.00	0.00	37080.00	103	8	556	1764	0.315192743764172	1.29665404502057	1.29665404502057	false	false	false	true
7f6eb9ad-3f28-4f2b-a068-06ab386a828c	2026-09-25 12:35	2026-09-25 12:35	2026-09-25 12:35	SOXL	SOXL260930C00157000	call	157.0000	2026-09-30	5.0000	4.9500	5.1000	152.7693	16500.00	0.00	16000.00	33	5	171	39	4.38461538461539	0.951362752901627	0.951362752901627	false	false	false	true
b9c3ec1d-ab48-4e13-ac53-cd43d45c22f8	2026-09-25 12:35	2026-09-25 12:34	2026-09-25 12:34	SOXL	SOXL260925P00152000	put	152.0000	2026-09-25	1.1200	1.1200	1.1500	152.4800	37968.00	0.00	37968.00	339	5	1953	88	22.1931818181818	1.12328727998442	1.12328727998442	true	false	false	true
02ecf2fe-c9c2-41be-8e7c-99db7ec27714	2026-09-25 12:33	2026-09-25 12:33	2026-09-25 12:33	SOXL	SOXL261030P00090000	put	90.0000	2026-10-30	2.6500	2.3100	2.6500	153.0032	30475.00	30475.00	0.00	115	12	241	1602	0.15043695380774	1.4049419063365	1.4049419063365	false	false	false	true
562b69f0-86e5-4bba-90ec-c4596ac5dba7	2026-09-25 12:31	2026-09-25 12:31	2026-09-25 12:31	SOXL	SOXL260930P00145000	put	145.0000	2026-09-30	3.6000	3.6000	3.6500	152.9950	25200.00	0.00	25200.00	70	11	391	277	1.4115523465704	0.992657210400317	0.992657210400317	false	false	false	true
3a9b1723-b025-495e-a7d4-009776128018	2026-09-25 12:31	2026-09-25 12:31	2026-09-25 12:31	SOXL	SOXL261016C00143000	call	143.0000	2026-10-16	21.2000	21.2000	21.3000	153.0100	10600.00	0.00	10600.00	5	5	32	678	0.0471976401179941	1.09811850470277	1.09811850470277	false	false	false	true
330f6722-fb41-40de-9222-ea620e7f5b68	2026-09-25 12:31	2026-09-25 12:31	2026-09-25 12:31	SOXL	SOXL260930P00152000	put	152.0000	2026-09-30	6.4500	6.4000	6.5500	152.9100	993945.00	852045.00	141900.00	1541	14	1726	1	1726	0.97507542305373	0.97507542305373	true	false	false	true
3ec44f58-69a6-4056-a879-f600680f0768	2026-09-25 12:30	2026-09-25 12:30	2026-09-25 12:30	SOXL	SOXL260930C00157500	call	157.5000	2026-09-30	4.9000	4.8500	5.0500	152.0000	12745.00	495.00	12250.00	26	10	58	10	5.8	0.953593051301832	0.953593051301832	true	false	false	true
07efbfe9-9f5e-4a42-b0d8-f235e476c2dc	2026-09-25 12:30	2026-09-25 12:30	2026-09-25 12:30	SOXL	SOXL260930C00157000	call	157.0000	2026-09-30	5.1100	5.1000	5.3500	152.0000	27582.00	0.00	27582.00	54	15	138	39	3.53846153846154	0.952110048452921	0.952110048452921	false	false	false	true
968e901d-43ef-47c5-aa8c-4fb068d42305	2026-09-25 12:29	2026-09-25 12:29	2026-09-25 12:29	SOXL	SOXL261120P00150000	put	150.0000	2026-11-20	27.1000	26.4000	27.8500	153.0000	97560.00	89430.00	8130.00	36	13	228	1180	0.193220338983051	1.2439799153339	1.2439799153339	false	false	false	true
da5551e7-c09c-4759-b4c6-ddc3cd5f0079	2026-09-25 12:22	2026-09-25 12:21	2026-09-25 12:21	SOXL	SOXL261002P00114000	put	114.0000	2026-10-02	0.6000	0.6000	0.6400	152.2600	21000.00	0.00	21000.00	350	34	366	634	0.577287066246057	1.33215366485237	1.33215366485237	false	false	false	true
cc39c0c7-3dfb-414b-98ee-8b0e1ebb6ffc	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	SOXL	SOXL261016P00140000	put	140.0000	2026-10-16	10.4000	9.9500	10.5000	151.9300	26000.00	10400.00	15600.00	25	5	294	838	0.350835322195704	1.1348075388707	1.1348075388707	false	false	false	true
d8cfb5fc-d9f4-4ba2-ad62-5c96f0e34197	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	SOXL	SOXL261016C00163000	call	163.0000	2026-10-16	11.6500	11.4000	11.6500	152.0800	57085.00	57085.00	0.00	49	17	70	86	0.813953488372093	1.09170745303685	1.09170745303685	true	false	false	true
bcad1bae-b4a0-4891-bf17-e2cfd41be77f	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	SOXL	SOXL261016C00154000	call	154.0000	2026-10-16	15.2000	14.4500	15.2000	152.0800	36477.00	36477.00	0.00	24	6	60	98	0.612244897959184	1.09494080040482	1.09494080040482	true	false	false	true
7ffdd601-91b5-4720-a32c-3c755e575d75	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	SOXL	SOXL261016C00160000	call	160.0000	2026-10-16	12.7500	12.1000	12.7500	152.0800	43340.00	43340.00	0.00	34	12	209	745	0.280536912751678	1.0927178987616	1.0927178987616	true	false	false	true
1982ba6e-0924-4da4-8098-658bc4535e35	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	SOXL	SOXL261016P00122000	put	122.0000	2026-10-16	4.6500	4.6000	4.8000	152.1070	11625.00	10695.00	465.00	25	6	48	125	0.384	1.17414804195458	1.17414804195458	true	false	false	true
30bfb3a0-2e73-488b-a796-afe200f01146	2026-09-25 12:18	2026-09-25 12:18	2026-09-25 12:18	SOXL	SOXL260925C00153000	call	153.0000	2026-09-25	1.1700	1.1600	1.2100	152.0000	10520.00	0.00	10520.00	90	5	2266	436	5.19724770642202	1.09446091030587	1.08640371995381	true	false	false	true
2f330fe2-7116-444c-8ce7-2eea38943c63	2026-09-25 12:18	2026-09-25 12:18	2026-09-25 12:18	SOXL	SOXL260930P00147000	put	147.0000	2026-09-30	4.5000	4.4000	4.5500	152.0000	16200.00	450.00	15750.00	36	12	59	9	6.55555555555556	0.999288590090551	0.999288590090551	false	false	false	true
1358d9f0-7f57-47fa-9ee9-abd1686b41c4	2026-09-25 12:18	2026-09-25 12:18	2026-09-25 12:18	SOXL	SOXL261030P00065000	put	65.0000	2026-10-30	0.6300	0.6300	0.8000	152.0000	12727.00	0.00	12727.00	202	5	278	1295	0.214671814671815	1.52712823968015	1.52712823968015	false	false	false	true
a571396e-113c-4a83-b0a4-385f0e15051c	2026-09-25 12:18	2026-09-25 12:18	2026-09-25 12:18	SOXL	SOXL261002P00139000	put	139.0000	2026-10-02	3.7500	3.7500	3.8000	152.0000	10500.00	0.00	10500.00	28	11	185	102	1.81372549019608	1.12910035518789	1.12910035518789	true	false	false	true
f55ad28c-1794-4110-b2ed-850514e48b90	2026-09-25 12:17	2026-09-25 12:17	2026-09-25 12:17	SOXL	SOXL261002C00155000	call	155.0000	2026-10-02	8.2500	8.1000	8.3000	153.3400	10724.00	9899.00	0.00	13	8	435	607	0.7166392092257	1.05794369396808	1.05794369396808	false	false	false	true
f5078c9b-6763-453c-ac39-0317a375c51a	2026-09-25 12:17	2026-09-25 12:17	2026-09-25 12:17	SOXL	SOXL260930P00152500	put	152.5000	2026-09-30	6.4500	6.1000	6.9500	153.4499	26445.00	25800.00	645.00	41	10	48	1	48	0.974449192635593	0.974449192635593	false	false	false	true
a75d0084-9333-42b6-b500-4a3d272d20cb	2026-09-25 12:17	2026-09-25 12:17	2026-09-25 12:17	SOXL	SOXL260930C00158000	call	158.0000	2026-09-30	4.9000	4.7000	4.9500	153.4259	12250.00	11760.00	0.00	25	7	130	42	3.0952380952381	0.950218971797224	0.951654087833506	false	false	false	true
8e6f25bc-e7e5-4c4f-b2cb-19b4ed22ad68	2026-09-25 12:17	2026-09-25 12:17	2026-09-25 12:17	SOXL	SOXL260930P00149000	put	149.0000	2026-09-30	4.9000	4.6500	4.9500	153.4499	15190.00	14210.00	490.00	31	8	84	41	2.04878048780488	0.982515002257506	0.982515002257506	false	false	false	true
83106755-6e50-42b3-be38-70ce9f0add02	2026-09-25 12:17	2026-09-25 12:17	2026-09-25 12:17	SOXL	SOXL260930P00150000	put	150.0000	2026-09-30	5.3000	5.1500	5.3000	153.4499	22790.00	22790.00	0.00	43	13	198	36	5.5	0.978085679630507	0.978085679630507	true	false	false	true
62853759-488a-460a-83f4-51903489e1a4	2026-09-25 12:17	2026-09-25 12:17	2026-09-25 12:17	SOXL	SOXL260930P00151000	put	151.0000	2026-09-30	5.7500	5.4000	5.7500	153.4259	56925.00	56925.00	0.00	99	18	248	0	0	0.977639492963948	0.976203734388578	true	false	false	true
14c40cc7-34da-4ede-806b-c7a9ef2cea3f	2026-09-25 12:17	2026-09-25 12:17	2026-09-25 12:17	SOXL	SOXL260930P00152000	put	152.0000	2026-09-30	6.2000	6.0000	6.2000	153.4499	34720.00	34720.00	0.00	56	15	156	1	156	0.973962360939342	0.973962360939342	true	false	false	true
ea8ecf6c-9f50-4f35-a6ba-ee0eda87e7d1	2026-09-25 12:16	2026-09-25 12:15	2026-09-25 12:15	SOXL	SOXL260930C00157000	call	157.0000	2026-09-30	5.1500	5.1000	5.1500	153.2000	11845.00	11845.00	0.00	23	8	70	39	1.79487179487179	0.946275089951701	0.946275089951701	true	false	false	true
40fd3ab3-d510-4b0c-879f-fa7254575225	2026-09-25 12:13	2026-09-25 12:13	2026-09-25 12:13	SOXL	SOXL261030P00060000	put	60.0000	2026-10-30	0.4700	0.4700	0.5500	152.0000	14194.00	0.00	14194.00	302	8	658	2019	0.325903912828133	1.57529523747133	1.57529523747133	false	false	false	true
96eb86d2-85bd-4040-acfa-546bc3be3ebf	2026-09-25 12:12	2026-09-25 12:12	2026-09-25 12:12	SOXL	SOXL260928C00153000	call	153.0000	2026-09-28	4.1500	4.0000	4.1500	152.0000	83000.00	83000.00	0.00	200	8	1241	563	2.20426287744227	0.752484398512322	0.752484398512322	false	false	false	true
1ba453d8-b6cc-4c6e-ac9a-bb9edaafca66	2026-09-25 12:11	2026-09-25 12:11	2026-09-25 12:11	SOXL	SOXL261120P00045000	put	45.0000	2026-11-20	0.5200	0.5200	0.6000	153.0000	10400.00	0.00	10400.00	200	5	921	3627	0.253928866832093	1.62923556394353	1.62923556394353	false	false	false	true
74157431-24be-4e1d-9106-b060641cf262	2026-09-25 12:10	2026-09-25 12:10	2026-09-25 12:10	SOXL	SOXL261120P00045000	put	45.0000	2026-11-20	0.5300	0.5200	0.5400	153.0000	15900.00	0.00	7473.00	300	20	721	3627	0.198786876206231	1.63860979957892	1.63860979957892	false	false	false	true
dd1f9dd6-eae1-4a6d-ace7-6aa608e3f6ea	2026-09-25 12:10	2026-09-25 12:10	2026-09-25 12:10	SOXL	SOXL260925C00150000	call	150.0000	2026-09-25	4.0000	3.9000	4.0000	153.0000	37200.00	37200.00	0.00	93	8	12716	3898	3.26218573627501	1.15284477910765	1.15284477910765	false	false	false	true
f6111e7e-c2ea-4916-a78e-8ac0866213c3	2026-09-25 12:09	2026-09-25 12:09	2026-09-25 12:09	SOXL	SOXL261120P00150000	put	150.0000	2026-11-20	27.0800	27.0000	28.5000	153.3463	13540.00	0.00	13540.00	5	5	167	1180	0.141525423728814	1.24842353138675	1.24842353138675	true	false	false	true
9755aaf2-3b4e-41c6-9ab4-5ae0717b0d94	2026-09-25 12:09	2026-09-25 12:09	2026-09-25 12:09	SOXL	SOXL261002C00175000	call	175.0000	2026-10-02	2.2500	2.2200	2.2500	153.1550	112500.00	112500.00	0.00	500	5	639	447	1.42953020134228	1.03557290019603	1.03557290019603	false	false	false	true
6baaf566-58e0-428e-a8ad-76c3eb645956	2026-09-25 12:09	2026-09-25 12:09	2026-09-25 12:09	SOXL	SOXL260925C00150000	call	150.0000	2026-09-25	3.5000	3.4000	3.5000	153.0400	125650.00	125650.00	0.00	359	7	12590	3898	3.22986146741919	1.19933427404144	1.19933427404144	false	false	false	true
0d2f86d2-99b2-431b-82f6-2a96fa78aabc	2026-09-25 12:07	2026-09-25 12:07	2026-09-25 12:07	SOXL	SOXL261120C00180000	call	180.0000	2026-11-20	19.4000	18.3000	19.8000	152.8000	19400.00	7760.00	11640.00	10	5	73	1465	0.0498293515358362	1.19736799896432	1.19736799896432	false	false	false	true
1838811c-abad-4a68-b4f7-046a26d431b3	2026-09-25 12:07	2026-09-25 12:07	2026-09-25 12:07	SOXL	SOXL261023P00090000	put	90.0000	2026-10-23	1.4500	1.4400	1.6200	152.7405	96281.00	145.00	96136.00	664	33	746	3788	0.196937697993664	1.33750073868533	1.33750073868533	false	false	false	true