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:endpoint = /api/option-trades/flow-alerts×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

e8f7e83d-4a60-4aba-95de-587fbb1fc857	2026-09-29 11:19	2026-09-29 11:19	2026-09-29 11:19	SOXL	SOXL261030C00155000	call	155.0000	2026-10-30	18.0000	17.4500	19.3500	149.5650	18000.00	0.00	18000.00	10	5	30	178	0.168539325842697	1.15526799392884	1.15694654817167	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	23214622037.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T15:19:13.720895Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
42c21343-02ac-4d77-99d1-cd1bf0f79ac7	2026-09-29 11:18	2026-09-29 11:18	2026-09-29 11:18	SOXL	SOXL261023C00133000	call	133.0000	2026-10-23	26.5000	26.5000	28.7500	149.8100	53000.00	0.00	53000.00	20	6	20	94	0.212765957446809	1.14897665542573	1.14897665542573	true	false	false	true
af62316a-7880-4f3d-9bf5-e3f644f2ebc7	2026-09-29 11:16	2026-09-29 11:16	2026-09-29 11:16	SOXL	SOXL260930P00145000	put	145.0000	2026-09-30	1.9700	1.9400	2.0000	150.7800	39489.00	33121.00	6368.00	200	20	1184	489	2.42126789366053	1.385801539179	1.37829432764555	false	false	false	true
e022a25d-f2c5-4b0f-b772-b613a4736a0c	2026-09-29 11:15	2026-09-29 11:14	2026-09-29 11:14	SOXL	SOXL260930C00152000	call	152.0000	2026-09-30	3.7000	3.6000	3.7000	150.7500	18500.00	18500.00	0.00	50	12	1751	290	6.03793103448276	1.357048383228	1.357048383228	false	false	false	true
e9476cbc-96f1-4d8c-bbfa-b84fd17e652d	2026-09-29 11:13	2026-09-29 11:13	2026-09-29 11:13	SOXL	SOXL261016P00133000	put	133.0000	2026-10-16	7.0000	6.9500	7.0000	149.9950	18900.00	18900.00	0.00	27	12	71	238	0.298319327731092	1.15199847208854	1.15136910531111	true	false	false	true
5b7d134b-da09-4c48-95ac-ee7f4fc645fd	2026-09-29 11:12	2026-09-29 11:12	2026-09-29 11:12	SOXL	SOXL261002P00150000	put	150.0000	2026-10-02	7.0000	6.9500	7.0000	149.9305	72800.00	72800.00	0.00	104	6	666	569	1.17047451669596	1.29362340450863	1.28970615567973	true	false	false	true
1a532475-bb84-45d1-8c9c-75a17d1d63dd	2026-09-29 11:11	2026-09-29 11:11	2026-09-29 11:11	SOXL	SOXL260930P00133000	put	133.0000	2026-09-30	0.3500	0.3500	0.3700	150.0000	19670.00	0.00	19670.00	562	40	713	205	3.4780487804878	1.58759739148301	1.58759739148301	false	false	false	true
3189fa33-09e6-4a7f-b7ad-6bbb2fb4ca7b	2026-09-29 11:10	2026-09-29 11:10	2026-09-29 11:10	SOXL	SOXL261002P00143000	put	143.0000	2026-10-02	3.9000	3.7500	3.9000	150.0000	23400.00	23400.00	0.00	60	21	153	299	0.511705685618729	1.32823368951825	1.32823368951825	false	false	false	true
9fe96869-7e9b-4286-a0fb-a238b186511b	2026-09-29 11:10	2026-09-29 11:09	2026-09-29 11:09	SOXL	SOXL261016C00168000	call	168.0000	2026-10-16	7.7000	7.6500	7.8500	150.0000	11550.00	0.00	11550.00	15	7	53	1817	0.0291689598238855	1.08235848403675	1.08235848403675	false	false	false	true
e8a30af5-b4d1-43c7-84e1-f15fd09ecb66	2026-09-29 11:10	2026-09-29 11:09	2026-09-29 11:09	SOXL	SOXL261009C00185000	call	185.0000	2026-10-09	1.9300	1.7300	1.9400	150.0000	51689.00	8843.00	42846.00	268	32	280	398	0.703517587939699	1.09842470991436	1.09842470991436	true	false	false
d221fb54-85ef-4985-89ac-4630d38bd7ba	2026-09-29 11:09	2026-09-29 11:09	2026-09-29 11:09	SOXL	SOXL261009C00186000	call	186.0000	2026-10-09	1.8500	1.8500	1.8600	150.0000	12395.00	0.00	12395.00	67	14	73	0	0	1.10326526044752	1.10326526044752	true	false	false	true
80e0e6e8-360d-43dd-a264-a48182372add	2026-09-29 11:07	2026-09-29 11:07	2026-09-29 11:07	SOXL	SOXL261002C00160000	call	160.0000	2026-10-02	3.6500	3.6500	3.8500	151.0950	10220.00	0.00	10220.00	28	10	917	2239	0.409557838320679	1.28648863206412	1.28648863206412	false	false	false	true
0f86a45e-69de-43f9-bf3d-48edade78a59	2026-09-29 11:07	2026-09-29 11:07	2026-09-29 11:07	SOXL	SOXL261005C00160000	call	160.0000	2026-10-05	4.6000	4.6000	4.6500	151.0950	17036.00	463.00	16573.00	37	11	142	48	2.95833333333333	1.04022189763022	1.04022189763022	false	false	false	true
fcad000e-41c6-4c58-a480-9329f81d5923	2026-09-29 11:05	2026-09-29 11:05	2026-09-29 11:05	SOXL	SOXL260930C00151000	call	151.0000	2026-09-30	4.4300	4.3500	4.5500	151.1809	22154.00	8417.00	13737.00	50	6	1060	207	5.1207729468599	1.37294307122217	1.37294307122217	true	false	false	true
cfd431c8-a526-4401-8816-23503936d730	2026-09-29 11:05	2026-09-29 11:05	2026-09-29 11:05	SOXL	SOXL261016P00144000	put	144.0000	2026-10-16	11.0500	11.0500	11.2000	151.0905	17681.00	0.00	17681.00	16	9	99	137	0.722627737226277	1.1411199947157	1.14030931495925	false	false	false	true
ba906ef8-215e-4d89-928d-106cf948c7fa	2026-09-29 11:03	2026-09-29 11:03	2026-09-29 11:03	SOXL	SOXL261218P00070000	put	70.0000	2026-12-18	3.6000	3.5000	3.6000	151.4050	135720.00	135720.00	0.00	377	7	459	2222	0.206570657065707	1.38878940004879	1.38878940004879	true	false	false	true
a36e1b4c-b7cd-4523-a490-93ff84d0cb1a	2026-09-29 11:02	2026-09-29 11:02	2026-09-29 11:02	SOXL	SOXL261218P00100000	put	100.0000	2026-12-18	10.3500	10.0500	10.7500	151.5200	621000.00	0.00	621000.00	600	1	1430	5353	0.267139921539324	1.29640475703786	1.29640475703786	false	true	false
115a5f6e-6058-43d1-9b8d-d34bfa3fd9c3	2026-09-29 11:01	2026-09-29 11:00	2026-09-29 11:00	SOXL	SOXL260930P00151000	put	151.0000	2026-09-30	4.2400	4.1500	4.2500	151.2350	21210.00	21210.00	0.00	50	5	602	212	2.83962264150943	1.38672294369535	1.3803787656498	false	false	false	true
19bc89d2-845d-4f5d-8340-a5d412aed1d6	2026-09-29 10:57	2026-09-29 10:57	2026-09-29 10:57	SOXL	SOXL260930C00152000	call	152.0000	2026-09-30	4.4500	4.4000	4.4500	152.0000	29815.00	29815.00	0.00	67	11	1583	290	5.45862068965517	1.36540982676258	1.36540982676258	false	false	false	true
3272077f-4f20-4fd2-ae5a-deb8cfd306f4	2026-09-29 10:56	2026-09-29 10:56	2026-09-29 10:56	SOXL	SOXL261005C00153000	call	153.0000	2026-10-05	7.5500	7.5500	7.6000	151.0000	15100.00	0.00	15100.00	20	6	21	11	1.90909090909091	1.04250103616411	1.04250103616411	false	false	false	true
58aa4b8d-87ab-475a-a9bd-02e2f1fa1d5e	2026-09-29 10:52	2026-09-29 10:52	2026-09-29 10:52	SOXL	SOXL261005C00157000	call	157.0000	2026-10-05	5.7500	5.7500	5.9500	151.4450	12075.00	0.00	12075.00	21	8	29	66	0.439393939393939	1.03925327933959	1.03925327933959	true	false	false	true
10fe280a-7bf3-40d6-988e-c21ff1392ca1	2026-09-29 10:52	2026-09-29 10:51	2026-09-29 10:51	SOXL	SOXL261002C00161000	call	161.0000	2026-10-02	3.5000	3.4500	3.6500	151.4200	11202.00	0.00	8402.00	32	9	159	223	0.713004484304933	1.29257123851645	1.29257123851645	false	false	false	true
fa1a55d2-990f-47dc-b796-8f67eb434150	2026-09-29 10:50	2026-09-29 10:50	2026-09-29 10:50	SOXL	SOXL261002C00158000	call	158.0000	2026-10-02	4.0500	4.0500	4.2500	150.4709	42930.00	0.00	42930.00	106	16	168	351	0.478632478632479	1.28782967575947	1.28782967575947	false	false	false	true
1a5ab536-f0ca-4386-bb4b-14a4ed53259f	2026-09-29 10:50	2026-09-29 10:50	2026-09-29 10:50	SOXL	SOXL261002C00160000	call	160.0000	2026-10-02	3.5000	3.5000	3.5500	150.4709	38172.00	713.00	37459.00	109	15	826	2239	0.368914694059848	1.29758059133467	1.29758059133467	false	false	false
373230cb-77ca-40c2-a4af-a1cde1838a39	2026-09-29 10:49	2026-09-29 10:49	2026-09-29 10:49	SOXL	SOXL260930P00150000	put	150.0000	2026-09-30	4.1400	4.0500	4.1500	150.5650	24851.00	24851.00	0.00	60	17	1175	166	7.07831325301205	1.41357537271746	1.39760858524199	true	false	false	true
8e896a6d-b4fa-4cf8-bce6-979e0692d5fa	2026-09-29 10:48	2026-09-29 10:48	2026-09-29 10:48	SOXL	SOXL261218C00140000	call	140.0000	2026-12-18	38.5000	37.4500	39.5500	151.1000	46200.00	15400.00	11550.00	12	5	30	729	0.0411522633744856	1.19538834109151	1.19538834109151	false	false	false
5c101cba-a8ee-43e0-a563-70d4e7316024	2026-09-29 10:48	2026-09-29 10:48	2026-09-29 10:48	SOXL	SOXL261016P00144000	put	144.0000	2026-10-16	11.0500	11.0000	11.2000	151.1058	12157.00	0.00	12157.00	11	7	47	137	0.343065693430657	1.14158159947932	1.14077090162459	false	false	false	true
4b76d855-2460-4b62-a76a-cca90330e3b2	2026-09-29 10:48	2026-09-29 10:48	2026-09-29 10:48	SOXL	SOXL260930C00149000	call	149.0000	2026-09-30	5.5500	5.5000	5.5500	151.1300	11100.00	11100.00	0.00	20	8	739	172	4.29651162790698	1.40250027545454	1.40250027545454	false	false	false	true
bcc925b8-5653-4acb-8c6d-acaa8c9ac7b4	2026-09-29 10:44	2026-09-29 10:43	2026-09-29 10:43	SOXL	SOXL261005P00150000	put	150.0000	2026-10-05	7.6500	7.6500	7.7000	151.1000	63507.00	768.00	62739.00	83	14	176	34	5.17647058823529	1.07072385312928	1.07072385312928	false	false	false	true
ba7133e3-d47b-4b25-880f-728cdfe7e3f0	2026-09-29 10:42	2026-09-29 10:42	2026-09-29 10:42	SOXL	SOXL261002C00154000	call	154.0000	2026-10-02	6.0500	6.0000	6.2000	151.4504	25413.00	0.00	25413.00	42	7	110	857	0.128354725787631	1.31002498165497	1.31002498165497	false	false	false	true
4e8bf871-a138-4e61-9763-198c5f985ddd	2026-09-29 10:42	2026-09-29 10:41	2026-09-29 10:41	SOXL	SOXL260930P00152000	put	152.0000	2026-09-30	4.6500	4.6500	4.8000	151.2700	25575.00	0.00	25575.00	55	6	291	1651	0.17625681405209	1.35331445400213	1.35331445400213	false	false	false	true
a25a5b13-cc86-414e-9dbf-3381204e6acb	2026-09-29 10:40	2026-09-29 10:40	2026-09-29 10:40	SOXL	SOXL261002C00155000	call	155.0000	2026-10-02	5.7000	5.5500	5.7000	151.4600	11970.00	11970.00	0.00	21	9	358	812	0.440886699507389	1.32048204027718	1.32048204027718	false	false	false	true
83113ed6-48c1-4e94-803b-ad699210eed6	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	SOXL	SOXL260930C00167000	call	167.0000	2026-09-30	0.5300	0.5300	0.5500	151.0300	11759.00	0.00	11759.00	220	8	277	248	1.11693548387097	1.46273261491225	1.45557173239153	true	false	false	true
8d9fe3a6-2a8d-4bcc-8db7-7047e2d46ae3	2026-09-29 10:32	2026-09-29 10:32	2026-09-29 10:32	SOXL	SOXL260930P00151000	put	151.0000	2026-09-30	4.0000	4.0000	4.0500	151.8058	10000.00	0.00	10000.00	25	7	306	212	1.44339622641509	1.39180867803583	1.39180867803583	false	false	false	true
e6a85c62-c9e2-4c30-b704-7297ee154a20	2026-09-29 10:32	2026-09-29 10:31	2026-09-29 10:31	SOXL	SOXL260930C00152000	call	152.0000	2026-09-30	4.2700	4.2000	4.3000	151.6750	20515.00	20515.00	0.00	48	12	855	290	2.94827586206897	1.38887727569066	1.38887727569066	true	false	false	true
18a43a48-6d42-4585-b74f-706b4925c3cc	2026-09-29 10:31	2026-09-29 10:31	2026-09-29 10:31	SOXL	SOXL260930C00154000	call	154.0000	2026-09-30	3.3800	3.3000	3.4000	151.6750	33826.00	33826.00	0.00	100	5	1642	1518	1.08168642951252	1.39764954540897	1.39124249043172	false	false	false	true
55293d13-46f9-4b62-ba41-6415febe9986	2026-09-29 10:29	2026-09-29 10:29	2026-09-29 10:29	SOXL	SOXL261016P00135000	put	135.0000	2026-10-16	7.5500	7.4500	7.7000	150.8900	33993.00	755.00	33238.00	45	8	117	636	0.183962264150943	1.15679032305663	1.15778998470995	false	false	false	true
a594d8d8-3a02-46ba-a86f-404c5cdb4edc	2026-09-29 10:28	2026-09-29 10:28	2026-09-29 10:28	SOXL	SOXL261005P00150000	put	150.0000	2026-10-05	7.5000	7.3500	7.5000	151.4580	17250.00	17250.00	0.00	23	10	54	34	1.58823529411765	1.07199315403281	1.07199315403281	true	false	false	true
4f0eeb52-a789-4335-a0ff-09da45147dfa	2026-09-29 10:26	2026-09-29 10:26	2026-09-29 10:26	SOXL	SOXL261002C00150000	call	150.0000	2026-10-02	8.0000	7.9500	8.0000	151.5800	13600.00	13600.00	0.00	17	8	1260	3885	0.324324324324324	1.31304727046746	1.31304727046746	false	false	false	true
159a26d2-3ecb-4e6f-9ca5-a2ed1116a2ac	2026-09-29 10:23	2026-09-29 10:23	2026-09-29 10:23	SOXL	SOXL260930C00156000	call	156.0000	2026-09-30	2.3200	2.3000	2.3200	150.8270	21344.00	21344.00	0.00	92	11	251	141	1.78014184397163	1.38293675714959	1.38293675714959	true	false	false	true
96a8dcc0-0828-4af8-8388-7c5275c7e496	2026-09-29 10:22	2026-09-29 10:22	2026-09-29 10:22	SOXL	SOXL261016P00137000	put	137.0000	2026-10-16	8.2000	7.9500	8.4000	150.6995	12300.00	4100.00	8200.00	15	6	79	222	0.355855855855856	1.14268027738747	1.14268027738747	false	false	false	true
75d6b73e-06d8-46cb-b714-37ea6d0b7385	2026-09-29 10:22	2026-09-29 10:22	2026-09-29 10:22	SOXL	SOXL261016P00136000	put	136.0000	2026-10-16	7.8500	7.8500	8.0500	150.6995	14915.00	0.00	14915.00	19	12	29	186	0.155913978494624	1.14597843311583	1.14597843311583	false	false	false	true
cf99ef95-0dce-42c6-854c-29e4598b2d1a	2026-09-29 10:22	2026-09-29 10:22	2026-09-29 10:22	SOXL	SOXL260930P00143000	put	143.0000	2026-09-30	1.6100	1.6100	1.6900	150.7150	14013.00	0.00	14013.00	87	6	169	146	1.15753424657534	1.45496711387601	1.45081817502658	true	false	false	true
c9caf77d-1941-4445-8d4f-ac98f0409c8e	2026-09-29 10:22	2026-09-29 10:22	2026-09-29 10:22	SOXL	SOXL261016P00149000	put	149.0000	2026-10-16	13.2000	13.2000	13.2500	151.1300	14520.00	0.00	14520.00	11	6	35	74	0.472972972972973	1.1161970388044	1.1161970388044	false	false	false	true
881beade-d94d-4bd4-868d-8bfa18cc22d2	2026-09-29 10:19	2026-09-29 10:19	2026-09-29 10:19	SOXL	SOXL260930P00150000	put	150.0000	2026-09-30	3.8500	3.7500	3.8500	150.7850	36567.00	36567.00	0.00	95	14	732	166	4.40963855421687	1.33730741650193	1.35008979063918	true	false	false	true
3a8f3ef1-4281-4aa9-ac7e-a76f5342d38b	2026-09-29 10:19	2026-09-29 10:19	2026-09-29 10:19	SOXL	SOXL260930P00151000	put	151.0000	2026-09-30	4.3500	4.2000	4.4500	150.7850	34800.00	24360.00	10440.00	80	8	199	212	0.938679245283019	1.34922466375665	1.34922466375665	false	false	false	true
e6a165af-1a5e-4ff9-98f4-08450f5b5f53	2026-09-29 10:18	2026-09-29 10:18	2026-09-29 10:18	SOXL	SOXL260930P00150000	put	150.0000	2026-09-30	3.9000	3.9000	4.0500	150.4800	19508.00	0.00	19508.00	50	5	584	166	3.51807228915663	1.32110069285019	1.34664633370145	false	false	false	true
d45b435b-6e09-4623-95e3-99c03d966090	2026-09-29 10:18	2026-09-29 10:18	2026-09-29 10:18	SOXL	SOXL260930C00150000	call	150.0000	2026-09-30	4.5000	4.3000	4.5500	150.5900	63905.00	63905.00	0.00	142	6	3046	1152	2.64409722222222	1.34645067113759	1.35129989490746	true	false	false	true
40b9b695-386b-47a0-acdd-2ac60245cad1	2026-09-29 10:16	2026-09-29 10:16	2026-09-29 10:16	SOXL	SOXL261016C00128000	call	128.0000	2026-10-16	26.8500	26.3500	26.8500	148.8950	85919.00	85919.00	0.00	32	11	43	446	0.0964125560538117	1.16235789953834	1.16235789953834	false	false	false
e29a2e83-8faf-4b8d-988c-8b58dd03b79a	2026-09-29 10:16	2026-09-29 10:16	2026-09-29 10:16	SOXL	SOXL261016P00140000	put	140.0000	2026-10-16	9.8500	9.3500	10.0000	148.9550	11820.00	985.00	10835.00	12	8	184	880	0.209090909090909	1.12790969104448	1.12790969104448	true	false	false	true