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

bb9a296b-8069-405c-a6e2-0fa17f124cce	2026-09-21 15:56	2026-09-21 15:56	2026-09-21 15:56	SOXL	SOXL261016C00125000	call	125.0000	2026-10-16	26.3900	26.3500	26.5500	143.1100	18475.00	5280.00	2635.00	7	7	679	1558	0.43581514762516	1.10721681534095	1.11127372092815	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	21580422420.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
62f03ad9-d7f0-4600-98b0-c1b553b29611	2026-09-21 15:56	2026-09-21 15:56	2026-09-21 15:56	SOXL	SOXL261016C00125000	call	125.0000	2026-10-16	26.4000	26.3500	26.6000	143.1400	153100.00	47520.00	26380.00	58	19	672	1558	0.431322207958922	1.10543148139388	1.10949070182008	true	false	false	true
4ea03fcd-33b4-485a-83df-7bca0998bf16	2026-09-21 15:56	2026-09-21 15:56	2026-09-21 15:56	SOXL	SOXL261016C00125000	call	125.0000	2026-10-16	26.3500	26.0000	26.6000	143.0900	500705.00	7875.00	351005.00	190	72	573	1558	0.367779204107831	1.10028599309348	1.11246128502681	true	false	false	true
90b91b32-1902-4aaa-b17f-4463c98649aa	2026-09-21 15:50	2026-09-21 15:50	2026-09-21 15:50	SOXL	SOXL261016C00150000	call	150.0000	2026-10-16	13.0500	12.9500	13.9000	142.7000	40450.00	32500.00	7950.00	31	7	4150	5053	0.821294280625371	1.06556911993207	1.08301063049863	false	false	false	true
0ef12a66-8ace-48ce-b8c7-26f580b99e6f	2026-09-21 15:46	2026-09-21 15:46	2026-09-21 15:46	SOXL	SOXL260923C00150000	call	150.0000	2026-09-23	1.7700	1.7100	1.7700	143.2400	35304.00	9462.00	0.00	200	8	9457	406	23.2931034482759	0.994262797109955	0.999873103574902	true	false	false	true
81bd9b6a-6bbf-419e-b4b8-5578bd32665d	2026-09-21 15:46	2026-09-21 15:46	2026-09-21 15:46	SOXL	SOXL260923C00150000	call	150.0000	2026-09-23	1.7600	1.7600	1.8200	143.3200	29420.00	0.00	26076.00	167	8	9127	406	22.4802955665025	0.990796880723134	0.990796880723134	true	false	false	true
2a82590f-00d8-43fc-9e35-8ca93e4b8158	2026-09-21 15:46	2026-09-21 15:46	2026-09-21 15:46	SOXL	SOXL260923C00150000	call	150.0000	2026-09-23	1.7500	1.7300	1.8100	143.3000	22809.00	9103.00	13706.00	130	8	9257	406	22.8004926108374	0.987997414535841	0.989564686866821	false	false	false	true
d3d33259-dcb5-4960-85cb-530f242baf67	2026-09-21 15:33	2026-09-21 15:33	2026-09-21 15:33	SOXL	SOXL260923C00150000	call	150.0000	2026-09-23	1.5600	1.5200	1.5600	142.0000	14542.00	14542.00	0.00	93	5	8384	406	20.6502463054187	0.974396546851578	0.983177299127677	true	false	false	true
fdd92189-d853-4b56-b172-27753b5705f6	2026-09-21 15:31	2026-09-21 15:31	2026-09-21 15:31	SOXL	SOXL260925C00152000	call	152.0000	2026-09-25	2.7200	2.6800	2.7300	142.0000	27177.00	6233.00	20944.00	100	5	313	30	10.4333333333333	1.04264847122461	1.04459889978994	true	false	false	true
5d08d947-6df3-45ad-baf8-eaa80c6266ed	2026-09-21 15:11	2026-09-21 15:11	2026-09-21 15:11	SOXL	SOXL260923C00150000	call	150.0000	2026-09-23	1.3600	1.3200	1.3800	141.7900	16330.00	16058.00	137.00	120	13	7855	406	19.3472906403941	0.9853578311089	0.991591385739959	true	false	false	true
769bd345-3ed6-4ba1-bed4-0135356786f6	2026-09-21 14:40	2026-09-21 14:40	2026-09-21 14:40	SOXL	SOXL261120P00090000	put	90.0000	2026-11-20	6.0200	6.0000	6.3000	141.1201	275575.00	0.00	275575.00	458	13	1786	2619	0.681939671630393	1.28402332801674	1.29320098059721	false	false	false	true
f5fbe48a-54c2-4252-9192-43dd45a41e25	2026-09-21 14:36	2026-09-21 14:36	2026-09-21 14:36	SOXL	SOXL261120P00085000	put	85.0000	2026-11-20	5.1600	5.0000	5.2000	140.8600	23752.00	23752.00	0.00	46	15	2097	3479	0.602759413624605	1.31692478210715	1.32342232813432	false	false	false	true
74c2fb67-157f-418f-8193-feba992834f4	2026-09-21 14:36	2026-09-21 14:36	2026-09-21 14:36	SOXL	SOXL261120P00085000	put	85.0000	2026-11-20	5.1500	5.0000	5.2000	140.8600	57161.00	57161.00	0.00	111	26	2051	3479	0.58953722334004	1.31692478210715	1.32342232813432	true	false	false	true
62c8f48c-550b-4d5b-9bf4-f8cda4bfac55	2026-09-21 14:36	2026-09-21 14:36	2026-09-21 14:36	SOXL	SOXL261120P00085000	put	85.0000	2026-11-20	5.1900	5.0000	5.2000	140.8600	25420.00	22330.00	3090.00	49	14	2146	3479	0.616843920666858	1.31878397909024	1.32342232813432	false	false	false	true
78102481-fe60-4017-8204-f9b4b1a5fb3e	2026-09-21 14:31	2026-09-21 14:30	2026-09-21 14:30	SOXL	SOXL260921P00141000	put	141.0000	2026-09-21	0.7400	0.7000	0.7500	140.0000	22276.00	22276.00	0.00	300	46	950	0	0	0.983746683934837	0.980377548640543	true	false	false	true
6128a232-03bc-4e70-9a84-7f1a85a4a965	2026-09-21 13:40	2026-09-21 13:39	2026-09-21 13:39	SOXL	SOXL261023P00080000	put	80.0000	2026-10-23	1.5000	1.4500	1.5000	139.5950	61036.00	48900.00	12136.00	408	11	3486	3056	1.14070680628272	1.34150689800744	1.34592013060414	false	false	false	true
c8855ba8-3dc3-4e8e-b23a-53c9ded11fd6	2026-09-21 13:19	2026-09-21 13:19	2026-09-21 13:19	SOXL	SOXL261005C00133000	call	133.0000	2026-10-05	14.7500	14.1000	15.8500	139.0000	16230.00	1470.00	14760.00	11	7	48	0	0	1.03513167435039	1.04486700712298	false	false	false	true
a0f29e1e-54e2-421a-a875-096d082187d8	2026-09-21 13:11	2026-09-21 13:11	2026-09-21 13:11	SOXL	SOXL261016P00123000	put	123.0000	2026-10-16	8.7900	8.7500	8.8000	139.7500	177655.00	159280.00	18375.00	202	9	216	63	3.42857142857143	1.16302306739308	1.16302306739308	true	false	false	true
c4a779f3-453d-411c-b338-02c0dc33b681	2026-09-21 13:00	2026-09-21 13:00	2026-09-21 13:00	SOXL	SOXL261030P00090000	put	90.0000	2026-10-30	3.4200	3.4000	3.6000	140.1850	157877.00	0.00	157877.00	462	33	717	532	1.34774436090226	1.28399054167638	1.29014907829764	false	false	false	true
630317bd-c6cc-40f2-a1f9-437e9c1e7936	2026-09-21 12:40	2026-09-21 12:39	2026-09-21 12:39	SOXL	SOXL261023P00080000	put	80.0000	2026-10-23	1.3500	1.3000	1.4200	139.8300	37803.00	137.00	37666.00	280	27	1820	3056	0.595549738219895	1.31485765857525	1.31947387218894	true	false	false	true
b7490fa7-5ae1-40ed-b1bc-3a1f1b161360	2026-09-21 12:33	2026-09-21 12:33	2026-09-21 12:33	SOXL	SOXL270115C00200000	call	200.0000	2027-01-15	18.9900	18.1500	19.2500	140.3400	11395.00	9495.00	1900.00	6	5	236	2279	0.103554190434401	1.11757232171957	1.11919717417586	false	false	false	true
acd45a04-aed9-4b74-902c-c91460498a58	2026-09-21 12:10	2026-09-21 12:10	2026-09-21 12:10	SOXL	SOXL261023P00080000	put	80.0000	2026-10-23	1.5500	1.4000	1.6100	139.2800	64313.00	46601.00	17712.00	415	48	1505	3056	0.492473821989529	1.35521381892725	1.33108655581879	false	false	false	true
b0c2e263-6105-42d9-9b07-fa1d65b53357	2026-09-21 11:55	2026-09-21 11:55	2026-09-21 11:55	SOXL	SOXL261016P00109000	put	109.0000	2026-10-16	4.7000	4.7000	5.0500	138.9800	55939.00	0.00	55939.00	119	30	129	0	0	1.19444016982554	1.19444016982554	false	false	false	true
7aba4540-d795-462c-a4f6-c467cfa4898c	2026-09-21 11:48	2026-09-21 11:48	2026-09-21 11:48	SOXL	SOXL280121C00145000	call	145.0000	2028-01-21	65.3500	64.0500	66.5000	139.4701	65346.00	13066.00	52280.00	10	6	256	865	0.295953757225434	1.06574867001249	1.06612952036923	true	false	false	true
3e356161-c9e7-4410-ba8c-5fe56ea02558	2026-09-21 11:41	2026-09-21 11:41	2026-09-21 11:41	SOXL	SOXL261009P00085000	put	85.0000	2026-10-09	0.9300	0.7900	0.9300	139.7700	21217.00	20367.00	850.00	229	6	687	2146	0.320130475302889	1.43008988251571	1.45831357814027	false	false	false	true
400d235f-9e48-432c-971a-cec519a4f278	2026-09-21 11:30	2026-09-21 11:29	2026-09-21 11:29	SOXL	SOXL261120C00200000	call	200.0000	2026-11-20	10.0000	9.4000	10.0500	139.5900	24994.00	24994.00	0.00	25	7	268	788	0.34010152284264	1.15162655403728	1.15720191002603	false	false	false	true
97ca7389-3f6f-426d-a299-397a5c554959	2026-09-21 11:19	2026-09-21 11:19	2026-09-21 11:19	SOXL	SOXL260921C00136000	call	136.0000	2026-09-21	3.0500	2.8000	3.1500	138.7000	60925.00	1200.00	59725.00	200	9	2506	0	0	0.960470207464167	0.99933929103554	false	false	false	true
cc4ee255-3003-4c71-8629-77f774bd772c	2026-09-21 11:16	2026-09-21 11:16	2026-09-21 11:16	SOXL	SOXL261016P00115000	put	115.0000	2026-10-16	6.3900	6.3000	6.4000	138.9873	63905.00	63905.00	0.00	100	11	462	1643	0.28119293974437	1.18460095727374	1.18924968832224	true	false	false	true
e9560859-70ce-44a3-baa4-c000d22109af	2026-09-21 11:15	2026-09-21 11:15	2026-09-21 11:15	SOXL	SOXL260925P00114000	put	114.0000	2026-09-25	0.5900	0.5900	0.6500	139.0966	10744.00	0.00	10444.00	182	7	323	306	1.05555555555556	1.32600894569764	1.32600894569764	true	false	false	true
5b4c54ed-381c-4b62-b7f1-95546c63addd	2026-09-21 11:00	2026-09-21 11:00	2026-09-21 11:00	SOXL	SOXL261002C00150000	call	150.0000	2026-10-02	5.5600	5.0000	5.6000	137.3400	10555.00	10555.00	0.00	19	7	575	2723	0.211164157179581	1.07371390446081	1.07855323793027	false	false	false	true
01d097a8-3b62-4149-a56f-7945aab02e4b	2026-09-21 10:49	2026-09-21 10:49	2026-09-21 10:49	SOXL	SOXL260925C00156000	call	156.0000	2026-09-25	0.9500	0.9500	1.1600	136.3800	10660.00	0.00	10660.00	112	7	220	80	2.75	1.07907882561255	1.07907882561255	true	false	false	true
31e6e722-f79e-44a1-be53-a41af2ceab7e	2026-09-21 10:32	2026-09-21 10:31	2026-09-21 10:31	SOXL	SOXL260921C00135000	call	135.0000	2026-09-21	2.1700	2.1600	2.2900	136.2900	26969.00	0.00	24799.00	124	8	2483	69	35.9855072463768	1.05871800049577	1.05871800049577	false	false	false	true
6103204e-f4bd-40a7-8020-e8e39509dfdb	2026-09-21 10:15	2026-09-21 10:15	2026-09-21 10:15	SOXL	SOXL261218C00225000	call	225.0000	2026-12-18	9.5000	8.5500	9.8000	135.0000	169095.00	169095.00	0.00	178	9	186	354	0.525423728813559	1.13265650045306	1.13274357833554	true	false	false	true
16e18e66-fca1-41de-864b-53a3b23936c7	2026-09-21 10:02	2026-09-21 10:02	2026-09-21 10:02	SOXL	SOXL261016C00150000	call	150.0000	2026-10-16	9.5000	9.5000	9.6000	134.7450	73155.00	0.00	73155.00	77	17	1690	5053	0.334454779339007	1.07080220212426	1.07080220212426	false	false	false	true
cac43f6a-a72d-45b2-8781-74c15fea3a32	2026-09-21 09:50	2026-09-21 09:50	2026-09-21 09:50	SOXL	SOXL261030P00100000	put	100.0000	2026-10-30	6.0100	5.9000	6.2500	134.1317	48120.00	0.00	20060.00	80	7	163	779	0.209242618741977	1.21072200754373	1.2286239299649	false	false	false	true
1ca222db-5bc7-486b-a249-2626373a2722	2026-09-21 09:34	2026-09-21 09:34	2026-09-21 09:34	SOXL	SOXL260921C00131000	call	131.0000	2026-09-21	1.1100	1.0600	1.1100	130.0722	12647.00	12540.00	107.00	114	9	164	635	0.258267716535433	1.0635546332223	1.06128828597314	false	false	false	true
439c1bb1-f21e-4d41-a0e7-097dbb00c6c8	2026-09-21 09:34	2026-09-21 09:34	2026-09-21 09:34	SOXL	SOXL270115P00100000	put	100.0000	2027-01-15	16.6400	16.6000	17.1000	130.2950	16642.00	3326.00	13316.00	10	5	20	2040	0.00980392156862745	1.18726521208739	1.18726521208739	false	false	false	true
132dbbb9-deed-4588-b48e-8cca2b540c93	2026-09-21 09:33	2026-09-21 09:33	2026-09-21 09:33	SOXL	SOXL260925C00125000	call	125.0000	2026-09-25	8.2700	8.4000	8.5500	130.2400	20670.00	0.00	20670.00	25	7	94	2202	0.0426884650317893	0.972262545131581	0.972262545131581	true	false	false	true
f5f41f24-f85a-4660-b7f3-f9b6cf0a88c0	2026-09-18 15:57	2026-09-18 15:56	2026-09-18 15:56	SOXL	SOXL260918C00120000	call	120.0000	2026-09-18	3.0000	3.0000	3.4500	123.0000	60021.00	1521.00	58500.00	200	7	15324	9878	1.55132617938854	11.0480407425543	11.0480407425543	false	false	false	true
635d3ad4-aa4f-432e-938d-b41c75b357d2	2026-09-18 15:36	2026-09-18 15:36	2026-09-18 15:36	SOXL	SOXL260925C00126000	call	126.0000	2026-09-25	3.0200	2.8200	3.1000	119.3500	15076.00	11137.00	3939.00	50	6	186	269	0.691449814126394	0.841637897311916	0.844922875088041	false	false	false	true
76764f6e-b1da-4964-8245-40dd6fd47475	2026-09-18 15:13	2026-09-18 15:12	2026-09-18 15:12	SOXL	SOXL261023C00160000	call	160.0000	2026-10-23	4.4000	4.0500	4.5000	119.1300	29020.00	28580.00	440.00	66	5	121	122	0.991803278688525	1.03628886477719	1.0407702408574	true	false	false	true
c518baf6-dde5-40e8-a2e1-785d0cce3f14	2026-09-18 14:53	2026-09-18 14:53	2026-09-18 14:53	SOXL	SOXL261009P00105000	put	105.0000	2026-10-09	5.7600	5.7000	6.0500	118.4900	31125.00	2900.00	28225.00	54	13	104	306	0.339869281045752	1.06301520558932	1.0581314375636	true	false	false	true
c6dfa728-f0d2-43ad-8a04-51fd5436c981	2026-09-18 14:50	2026-09-18 14:50	2026-09-18 14:50	SOXL	SOXL261016C00150000	call	150.0000	2026-10-16	4.3000	4.2000	4.4500	118.2750	113149.00	0.00	113149.00	263	5	1505	4346	0.346295444086516	1.02343916108559	1.02537404624362	false	false	false	true
c71eb6de-c2e1-482e-af71-ebdb99e07634	2026-09-18 14:34	2026-09-18 14:34	2026-09-18 14:34	SOXL	SOXL260925C00125000	call	125.0000	2026-09-25	2.8600	2.8200	2.9100	117.8700	48310.00	6555.00	41755.00	169	37	916	1838	0.498367791077258	0.849006756210952	0.850693818614789	false	false	false	true
65c9b067-53fc-4a0a-a4c2-5930a6221ed6	2026-09-18 14:28	2026-09-18 14:27	2026-09-18 14:27	SOXL	SOXL280121P00030000	put	30.0000	2028-01-21	6.2800	6.1500	6.3000	118.0700	35188.00	30192.00	2496.00	56	16	234	3444	0.0679442508710801	1.26756777418719	1.27151756171835	true	false	false	true
9ac618fe-a00e-45ab-a3f4-140bfa5eff64	2026-09-18 12:29	2026-09-18 12:29	2026-09-18 12:29	SOXL	SOXL261002P00100000	put	100.0000	2026-10-02	3.1500	3.0000	3.3500	116.9750	13563.00	13563.00	0.00	43	43	510	1825	0.279452054794521	1.10403242130861	1.10403242130861	false	false	false	true
0bb11831-d117-4df0-8616-35bee2098f85	2026-09-18 12:20	2026-09-18 12:20	2026-09-18 12:20	SOXL	SOXL261030P00085000	put	85.0000	2026-10-30	4.7800	4.7500	5.0500	117.0000	384356.00	38800.00	345556.00	804	10	1396	339	4.11799410029499	1.2054604883443	1.20965363573733	false	false	false	true
5d68a985-b9ad-4d85-8ae6-5e294498218c	2026-09-18 09:34	2026-09-18 09:33	2026-09-18 09:33	SOXL	SOXL260918P00116000	put	116.0000	2026-09-18	0.7900	0.7800	1.0000	117.7400	12405.00	80.00	12325.00	157	27	242	731	0.331053351573187	1.18717876580285	1.18996450619481	true	false	false	true
935c6bdb-8101-4a52-b4e6-a6321576b009	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	SOXL	SOXL260925P00120000	put	120.0000	2026-09-25	9.4400	6.4500	9.4500	117.1150	19814.00	19814.00	0.00	21	7	21	1087	0.0193192272309108	1.21804573982347	1.21185396071401	false	false	false	true
b05ae2e5-f977-46c3-98dc-0af46cf7c01a	2026-09-17 16:16	2026-09-17 16:14	2026-09-17 16:14	SOXL	SOXL260918P00112000	put	112.0000	2026-09-18	1.4000	1.1700	1.5900	114.0000	40347.00	40347.00	0.00	288	9	2490	218	11.4220183486239	1.01347878955043	1.018048571131	false	false	false	true