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

3f076e60-252c-4a71-93e8-1adbdf994011	2026-08-17 09:33	2026-08-17 09:33	2026-08-17 09:33	SOXS	SOXS260828C00039500	call	39.5000	2026-08-28	3.0000	3.0000	3.6000	38.4850	46500.00	0.00	45000.00	155	11	155	18	8.61111111111111	1.2859720890674	1.2859720890674	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1795976211.00	—	—	—	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
ec339de7-cbf8-4a2d-887a-cffd7bd3c7b6	2026-08-17 09:33	2026-08-17 09:33	2026-08-17 09:33	SOXS	SOXS260911C00040000	call	40.0000	2026-09-11	4.2500	4.2500	4.8500	38.3000	22955.00	430.00	22525.00	54	32	55	24	2.29166666666667	1.23222034986644	1.24473216763242	true	false	false	true
9a456496-3028-4167-9a9b-27c53129c92f	2026-08-17 12:54	2026-08-17 12:54	2026-08-17 12:54	SOXS	SOXS260918P00037000	put	37.0000	2026-09-18	5.3500	5.2000	5.5000	37.2300	45475.00	29425.00	5350.00	85	9	119	207	0.57487922705314	1.26973562491431	1.26973562491431	false	false	false	true
6250935f-cd69-48c2-929d-aaa3a0f588b8	2026-08-17 13:10	2026-08-17 13:10	2026-08-17 13:10	SOXS	SOXS260821C00038000	call	38.0000	2026-08-21	1.9000	1.6300	1.9000	37.4250	38000.00	38000.00	0.00	200	9	871	522	1.66858237547893	1.37811078847326	1.37811078847326	false	false	false	true
0c519fa0-23c2-4599-89a6-e30b1b1df108	2026-08-17 13:12	2026-08-17 13:12	2026-08-17 13:12	SOXS	SOXS260918C00045000	call	45.0000	2026-09-18	3.1000	2.9200	3.2500	37.5450	71920.00	71920.00	0.00	232	20	314	556	0.564748201438849	1.25690407928778	1.25690407928778	true	false	false	true
a78e5538-ccca-456e-ad7c-3d7e5624f505	2026-08-17 13:18	2026-08-17 13:18	2026-08-17 13:18	SOXS	SOXS260821C00038000	call	38.0000	2026-08-21	1.9200	1.8500	2.0000	37.6650	38400.00	4608.00	33792.00	200	14	1092	522	2.09195402298851	1.31505190311954	1.31505190311954	false	false	false	true
ec132ef8-4eb8-4ab3-ab32-102af35b8f8a	2026-08-17 14:11	2026-08-17 14:11	2026-08-17 14:11	SOXS	SOXS260821C00040000	call	40.0000	2026-08-21	1.3900	1.3800	1.3900	38.0000	14873.00	14873.00	0.00	107	5	915	1186	0.77150084317032	1.33696665656414	1.33696665656414	false	false	false	true
4ccd9c94-b259-44b6-9009-8c8583a61a64	2026-08-18 09:54	2026-08-18 09:54	2026-08-18 09:54	SOXS	SOXS260821C00045000	call	45.0000	2026-08-21	2.0000	1.9400	2.0700	43.9800	43800.00	43600.00	200.00	219	9	593	1541	0.384815055158988	1.5368455267998	1.5368455267998	true	false	false	true
05b28958-8fc4-4dc8-a8cf-51ae20748944	2026-08-18 10:02	2026-08-18 10:02	2026-08-18 10:02	SOXS	SOXS260918C00045000	call	45.0000	2026-09-18	6.1500	6.1500	6.4000	43.9100	361620.00	0.00	361620.00	588	32	629	900	0.698888888888889	1.28667175811296	1.28885390411232	true	false	false	true
e5ff3318-46c5-4525-af56-d44cb2fc3882	2026-08-18 10:03	2026-08-18 10:03	2026-08-18 10:03	SOXS	SOXS260828C00045500	call	45.5000	2026-08-28	3.1500	3.0500	3.7000	43.5450	26460.00	2205.00	24255.00	84	17	84	5	16.8	1.37543736659016	1.37543736659016	true	false	false	true
503696dc-aec1-4c10-9b67-666f134807b5	2026-08-18 10:10	2026-08-18 10:09	2026-08-18 10:09	SOXS	SOXS260821C00040000	call	40.0000	2026-08-21	5.0000	4.6500	5.0000	44.1600	97500.00	97500.00	0.00	195	12	1449	1707	0.848857644991213	1.54489108655641	1.54489108655641	true	false	false	true
27de5de7-0a90-45a2-a0cd-d95127e733d3	2026-08-18 10:19	2026-08-18 10:18	2026-08-18 10:18	SOXS	SOXS260821C00045000	call	45.0000	2026-08-21	2.1000	2.0900	2.3000	44.1912	126210.00	0.00	126210.00	601	9	1727	1541	1.12070084360805	1.53731604133619	1.53731604133619	true	false	false	true
5762bfd8-088c-4e76-b4fe-a324daba0097	2026-08-18 10:30	2026-08-18 10:30	2026-08-18 10:30	SOXS	SOXS260828C00047000	call	47.0000	2026-08-28	2.7300	2.7300	3.1000	43.7950	51324.00	0.00	51324.00	188	18	197	405	0.48641975308642	1.3776511408065	1.3776511408065	true	false	false	true
e90339cf-c7c5-4d37-8a8f-ce452e9173b0	2026-08-18 10:41	2026-08-18 10:40	2026-08-18 10:40	SOXS	SOXS260918C00045000	call	45.0000	2026-09-18	6.4000	6.0500	6.5500	44.2450	32000.00	32000.00	0.00	50	9	739	900	0.821111111111111	1.3013779035364	1.3013779035364	false	false	false	true
f7cb2046-1794-48f5-91f0-debba839d3aa	2026-08-18 10:44	2026-08-18 10:44	2026-08-18 10:44	SOXS	SOXS260828C00039000	call	39.0000	2026-08-28	7.3000	6.4500	7.3000	44.5706	13140.00	13140.00	0.00	18	18	62	265	0.233962264150943	1.40618138769962	1.40618138769962	false	false	false	true
e7abf281-121d-4663-9c91-03355a82477d	2026-08-18 11:08	2026-08-18 11:08	2026-08-18 11:08	SOXS	SOXS260821C00045000	call	45.0000	2026-08-21	2.7000	2.6100	2.7000	45.4100	23490.00	23490.00	0.00	87	7	2318	1541	1.50421804023361	1.51965592128865	1.51965592128865	true	false	false	true
de1268df-7c11-43c7-9f23-4f56304e0b63	2026-08-18 11:10	2026-08-18 11:10	2026-08-18 11:10	SOXS	SOXS260828P00041000	put	41.0000	2026-08-28	2.1000	2.0200	2.3400	45.7950	74340.00	53130.00	21210.00	354	6	357	28	12.75	1.42557022418474	1.42557022418474	false	false	false	true
266da04e-a128-487e-9304-3055531afda8	2026-08-18 11:30	2026-08-18 11:30	2026-08-18 11:30	SOXS	SOXS260821C00051000	call	51.0000	2026-08-21	0.6500	0.6500	0.7300	44.8800	34060.00	0.00	33410.00	524	9	679	326	2.08282208588957	1.53695233724165	1.53695233724165	true	false	false	true
78302cbe-692e-4ad9-ad88-21ee85bf33dd	2026-08-18 11:49	2026-08-18 11:49	2026-08-18 11:49	SOXS	SOXS260821P00045000	put	45.0000	2026-08-21	2.5300	2.4500	2.5400	44.6950	25300.00	20240.00	5060.00	100	5	458	488	0.938524590163934	1.46964117968924	1.46964117968924	false	false	false	true
55fa259e-c6a0-429e-a244-f1caadfae4fe	2026-08-18 11:59	2026-08-18 11:58	2026-08-18 11:58	SOXS	SOXS260821C00046000	call	46.0000	2026-08-21	1.8000	1.7500	1.9000	44.7100	10260.00	180.00	10080.00	57	7	633	626	1.0111821086262	1.45450998695535	1.45450998695535	false	false	false	true
634fa599-1476-4b1d-961a-9ee254faab5f	2026-08-18 12:17	2026-08-18 12:17	2026-08-18 12:17	SOXS	SOXS280121P00030000	put	30.0000	2028-01-21	16.5000	16.2000	16.6500	44.8400	64350.00	23100.00	41250.00	39	9	295	574	0.513937282229965	1.61317714105529	1.61317714105529	false	false	false	true
d5d721dc-049e-47e2-82b8-153c1d9fbdde	2026-08-18 13:46	2026-08-18 13:46	2026-08-18 13:46	SOXS	SOXS261120C00040000	call	40.0000	2026-11-20	14.1000	13.7000	14.2500	44.9700	11280.00	11280.00	0.00	8	5	1268	121	10.4793388429752	1.33658072218691	1.33658072218691	false	false	false	true
bcf33f8e-3dd9-45e2-86b8-316b2b0e2869	2026-08-18 14:08	2026-08-18 14:08	2026-08-18 14:08	SOXS	SOXS260828C00043500	call	43.5000	2026-08-28	4.9500	4.4000	4.9500	45.3600	17325.00	17325.00	0.00	35	17	92	25	3.68	1.34330205227288	1.34113651955191	true	false	false	true
8f703379-bee8-45bb-91d1-b026d0c9295d	2026-08-18 14:10	2026-08-18 14:10	2026-08-18 14:10	SOXS	SOXS260918P00037000	put	37.0000	2026-09-18	2.7000	2.5800	2.8500	45.5399	26190.00	0.00	26190.00	97	7	117	344	0.340116279069767	1.27956497301878	1.27956497301878	false	false	false	true
108b7913-6ee2-40bf-86cc-ead92b724fc1	2026-08-18 14:59	2026-08-18 14:59	2026-08-18 14:59	SOXS	SOXS261120C00105000	call	105.0000	2026-11-20	2.8000	2.6700	2.8000	44.9800	16800.00	280.00	0.00	60	20	183	677	0.270310192023634	1.41121183061714	1.41121183061714	false	false	false	true
fc401f57-e145-47fa-aa74-2d0d92c1c21f	2026-08-18 15:30	2026-08-18 15:30	2026-08-18 15:30	SOXS	SOXS261120P00050000	put	50.0000	2026-11-20	15.9500	15.9500	16.2500	44.6000	14355.00	0.00	14355.00	9	5	104	43	2.41860465116279	1.43446287406205	1.43446287406205	true	false	false	true
22901a85-7d44-4d01-b324-f773cd41657f	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	SOXS	SOXS260828P00043000	put	43.0000	2026-08-28	3.2500	3.2500	3.5000	43.7183	13650.00	0.00	13650.00	42	15	42	172	0.244186046511628	1.33454302123515	1.33454302123515	true	false	false	true
8cf3d044-e724-46f6-9347-bda621adf166	2026-08-19 09:40	2026-08-19 09:39	2026-08-19 09:39	SOXS	SOXS260821C00046500	call	46.5000	2026-08-21	1.7800	1.5100	1.8000	45.5900	15486.00	15486.00	0.00	87	9	92	213	0.431924882629108	1.61981829251006	1.61981829251006	true	false	false	true
7bae7bdd-b9b6-4b36-9f93-eb5bb417e279	2026-08-19 09:40	2026-08-19 09:39	2026-08-19 09:39	SOXS	SOXS260821C00048500	call	48.5000	2026-08-21	1.0700	0.5500	1.0700	45.5900	15621.00	15621.00	0.00	146	22	146	75	1.94666666666667	1.6038194856196	1.6038194856196	true	false	false	true
2e1a3628-2d39-48b9-807f-ba7f9c851ed4	2026-08-19 09:44	2026-08-19 09:44	2026-08-19 09:44	SOXS	SOXS260821C00041500	call	41.5000	2026-08-21	4.1000	3.9000	5.1000	44.7700	22550.00	6970.00	15580.00	55	5	165	972	0.169753086419753	1.61800344844781	1.61800344844781	false	false	false	true
f5a46dbe-047a-401e-af24-eededce0add6	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	SOXS	SOXS260828C00048500	call	48.5000	2026-08-28	3.5500	1.9100	3.5500	47.1200	10650.00	10650.00	0.00	30	10	34	13	2.61538461538462	1.4003947571805	1.4003947571805	true	false	false	true
090b10a9-6041-4222-ac02-8857ccc509df	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	SOXS	SOXS260828C00049000	call	49.0000	2026-08-28	3.3500	2.0100	3.3500	47.1200	14065.00	13735.00	0.00	42	11	44	119	0.369747899159664	1.39987519400869	1.39987519400869	true	false	false	true
f0223e71-5fce-4d1c-a99d-a262274182ec	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	SOXS	SOXS260904C00053000	call	53.0000	2026-09-04	3.5000	1.2500	3.6000	47.7889	14000.00	9800.00	4200.00	40	5	40	15	2.66666666666667	1.36079143048828	1.36086589008812	true	false	false	true
bfb09e5f-711e-4281-b14d-ca10d60a9379	2026-08-19 12:03	2026-08-19 12:03	2026-08-19 12:03	SOXS	SOXS260828C00047500	call	47.5000	2026-08-28	3.3500	3.3500	4.1000	46.1618	104185.00	0.00	104185.00	311	17	318	457	0.695842450765864	1.35425868633655	1.35425868633655	false	false	false	true
63940dd0-289c-4b1b-b634-f58390279b3b	2026-08-19 12:28	2026-08-19 12:28	2026-08-19 12:28	SOXS	SOXS260821C00043500	call	43.5000	2026-08-21	3.7500	3.5000	3.8000	46.3510	168750.00	6375.00	162375.00	450	12	565	791	0.714285714285714	1.5116899004813	1.5116899004813	false	false	false	true
3e249039-7e2c-415b-93fd-c497eb975394	2026-08-19 13:16	2026-08-19 13:16	2026-08-19 13:16	SOXS	SOXS260828P00040500	put	40.5000	2026-08-28	1.3600	1.3600	1.5000	46.7300	27200.00	0.00	21760.00	200	10	234	20	11.7	1.35027650574102	1.35027650574102	false	false	false	true
16740715-9fbe-4c78-93c6-c3b9ebc04639	2026-08-19 13:16	2026-08-19 13:16	2026-08-19 13:16	SOXS	SOXS260828P00040500	put	40.5000	2026-08-28	1.3500	1.2800	1.4000	46.7450	27000.00	3510.00	23490.00	200	9	434	20	21.7	1.34712854005238	1.34712854005238	false	false	false	true
b56a5ba0-2ad9-4b0f-b918-8e20bf4cc96a	2026-08-19 13:23	2026-08-19 13:23	2026-08-19 13:23	SOXS	SOXS260821C00047000	call	47.0000	2026-08-21	2.1200	1.7500	2.1200	46.8600	14840.00	14840.00	0.00	70	6	557	361	1.54293628808864	1.57731267022411	1.57731267022411	false	false	false	true
9441940f-4f21-444e-8b2c-c69a13c70e52	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	SOXS	SOXS260821C00046000	call	46.0000	2026-08-21	2.2000	2.0000	2.4300	46.9991	12100.00	4180.00	5940.00	55	10	239	758	0.315303430079156	1.71211326218777	1.69971228099609	false	false	false	true
d39d835c-bca9-4a02-a2d4-5dfca042249e	2026-08-20 11:34	2026-08-20 11:34	2026-08-20 11:34	SOXS	SOXS260821C00047000	call	47.0000	2026-08-21	1.5000	1.4100	1.5000	47.0700	10800.00	10200.00	0.00	72	21	534	448	1.19196428571429	1.47927476495079	1.48927407464316	true	false	false	true
8d1f3206-59b7-40b4-b350-03d05c327db0	2026-08-20 11:46	2026-08-20 11:46	2026-08-20 11:46	SOXS	SOXS260821P00048000	put	48.0000	2026-08-21	1.7500	1.7500	3.2000	47.4950	17500.00	0.00	17500.00	100	9	105	213	0.492957746478873	1.4914915687381	1.4914915687381	true	false	false	true
85b0994c-50f7-4633-b794-821014e22c22	2026-08-20 14:59	2026-08-20 14:59	2026-08-20 14:59	SOXS	SOXS260828P00045000	put	45.0000	2026-08-28	2.5500	2.3700	2.6000	46.9550	78540.00	5355.00	73185.00	308	9	410	302	1.35761589403974	1.27494556268739	1.27494556268739	false	false	false	true
84b8a677-8bbd-4160-8a3f-80bbd98991d0	2026-08-20 15:30	2026-08-20 15:30	2026-08-20 15:30	SOXS	SOXS260821C00043500	call	43.5000	2026-08-21	3.2500	2.9700	3.2500	46.5000	17225.00	17225.00	0.00	53	12	109	709	0.153737658674189	1.36700836027009	1.26786534193367	true	false	false	true
779afd3b-ac68-4d43-89c9-d655e3aafd06	2026-08-21 09:37	2026-08-21 09:37	2026-08-21 09:37	SOXS	SOXS260828C00049000	call	49.0000	2026-08-28	2.1100	1.4100	2.1100	46.1399	62666.00	62666.00	0.00	297	9	299	171	1.74853801169591	1.27738810864387	1.2709090106906	true	false	false	true
6ef13350-144e-4ef3-9295-3e985f80ee7e	2026-08-21 10:14	2026-08-21 10:14	2026-08-21 10:14	SOXS	SOXS260904C00054000	call	54.0000	2026-09-04	2.4900	1.4500	2.6500	47.7200	50895.00	31775.00	19120.00	204	8	206	9	22.8888888888889	1.26136534538651	1.26136534538651	true	false	false	true
7f7bd2e2-7b99-49b7-9813-59560ed780dc	2026-08-21 10:26	2026-08-21 10:26	2026-08-21 10:26	SOXS	SOXS260828C00048000	call	48.0000	2026-08-28	3.1000	3.0500	3.2000	47.4450	50220.00	0.00	49910.00	162	5	178	270	0.659259259259259	1.26724983339963	1.27409567801522	false	false	false	true
2da62d7e-ca32-4354-8c99-42fbcc0abbf7	2026-08-21 10:26	2026-08-21 10:26	2026-08-21 10:26	SOXS	SOXS260828C00050000	call	50.0000	2026-08-28	2.2900	2.1700	2.6400	47.4222	14657.00	0.00	14657.00	64	16	176	1294	0.136012364760433	1.26620699571353	1.26991956174167	true	false	false	true
a6ad2e6a-aa3d-4202-b7f8-db21b12bdedd	2026-08-21 11:33	2026-08-21 11:33	2026-08-21 11:33	SOXS	SOXS260828C00050000	call	50.0000	2026-08-28	2.2100	2.2100	2.4900	47.3501	134810.00	0.00	134810.00	610	10	852	1294	0.658423493044822	1.25032077058237	1.25032077058237	true	false	false	true
5185132f-1be0-4a14-b7a6-f2a03db4d877	2026-08-21 13:23	2026-08-21 13:23	2026-08-21 13:23	SOXS	SOXS260828P00045000	put	45.0000	2026-08-28	1.9500	1.9000	2.0900	47.9487	15990.00	0.00	15990.00	82	7	225	657	0.342465753424658	1.25802506848581	1.25802506848581	false	false	false	true
f156ca69-ce98-4b9c-a556-5a1395badb3a	2026-08-21 13:45	2026-08-21 13:45	2026-08-21 13:45	SOXS	SOXS260904C00048000	call	48.0000	2026-09-04	4.3000	4.1500	4.8500	47.2100	86000.00	0.00	86000.00	200	18	209	37	5.64864864864865	1.25458826300157	1.25458826300157	true	false	false	true