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

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

b7e263f3-529c-4502-b84f-24c6c156f0f3	2026-09-10 11:02	2026-09-10 11:02	2026-09-10 11:02	SOXS	SOXS261002C00050000	call	50.0000	2026-10-02	3.4700	3.2000	3.7500	45.8750	23228.00	5578.00	17650.00	67	9	338	217	1.55760368663594	1.12445394406008	1.12445394406008	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	1497152526.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9bdc150a-b728-4f84-8e1e-5ed432439a82	2026-09-10 09:58	2026-09-10 09:58	2026-09-10 09:58	SOXS	SOXS260918C00047500	call	47.5000	2026-09-18	3.3000	3.3000	3.6500	47.4150	120780.00	0.00	120780.00	366	5	583	32	18.21875	1.18743110865427	1.18743110865427	false	false	false	true	false
4062733d-6312-42df-9f6e-238c0c95b57e	2026-09-10 09:58	2026-09-10 09:58	2026-09-10 09:58	SOXS	SOXS260918C00044000	call	44.0000	2026-09-18	5.2000	5.0000	5.3500	47.4000	15600.00	8320.00	7280.00	30	9	137	399	0.343358395989975	1.18500054281283	1.18500054281283	false	false	false	true	false
782f99d6-fb28-4e04-b8e0-9fa46d53d9fa	2026-09-10 09:58	2026-09-10 09:58	2026-09-10 09:58	SOXS	SOXS260918C00044000	call	44.0000	2026-09-18	5.2000	5.0000	5.2000	47.3705	33800.00	33800.00	0.00	65	10	107	399	0.268170426065163	1.1933756108067	1.1933756108067	false	false	false	true	false
0d0c43dd-f5c0-4252-bee8-cd0c47610e25	2026-09-10 09:53	2026-09-10 09:53	2026-09-10 09:53	SOXS	SOXS261002C00055000	call	55.0000	2026-10-02	2.7500	2.0800	2.7500	47.3900	24730.00	24730.00	0.00	90	13	90	67	1.34328358208955	1.15030167207092	1.15030167207092	true	false	false	true	false
db6d3919-bc00-4d62-b84b-3e53b97381a6	2026-09-10 09:49	2026-09-10 09:49	2026-09-10 09:49	SOXS	SOXS260911C00045000	call	45.0000	2026-09-11	2.4900	2.4900	2.7000	46.8700	43326.00	0.00	43326.00	174	11	460	1045	0.440191387559809	1.4087758032247	1.4087758032247	false	false	false	true	false
73425dc1-1e22-4bad-a94c-17081c79a6cd	2026-09-10 09:49	2026-09-10 09:49	2026-09-10 09:49	SOXS	SOXS260918C00045000	call	45.0000	2026-09-18	4.2000	4.2000	4.5000	46.8700	15540.00	0.00	15540.00	37	10	269	1928	0.139522821576763	1.16495254024627	1.16495254024627	false	false	false	true	false
26eaf3d0-a1ec-4586-b334-cc596f69b62c	2026-09-10 09:36	2026-09-10 09:36	2026-09-10 09:36	SOXS	SOXS270115C00052000	call	52.0000	2027-01-15	11.3900	10.4500	12.6000	46.6400	56968.00	0.00	56968.00	50	8	50	65	0.769230769230769	1.20477242637688	1.20477242637688	false	false	false	true	false
1e5aa197-95a4-4a92-83a1-21edcc0ab47d	2026-09-09 15:59	2026-09-09 15:59	2026-09-09 15:59	SOXS	SOXS280121P00040000	put	40.0000	2028-01-21	21.6000	20.8000	22.0000	43.3099	10800.00	4320.00	6480.00	5	5	12	562	0.0213523131672598	1.44421095503946	1.44421095503946	false	false	false	true	false
31c2ee80-feb3-4211-ba6f-a01256d23375	2026-09-09 15:22	2026-09-09 15:22	2026-09-09 15:22	SOXS	SOXS260911P00045000	put	45.0000	2026-09-11	2.6600	2.6600	2.9400	43.2010	24206.00	0.00	24206.00	91	10	235	896	0.262276785714286	1.23650211381321	1.23650211381321	true	false	false	true	false
03ff6815-2fad-4980-bad1-d2230af40fa3	2026-09-09 12:23	2026-09-09 12:23	2026-09-09 12:23	SOXS	SOXS260911P00047500	put	47.5000	2026-09-11	4.3000	3.7000	4.9000	43.7000	53750.00	0.00	30100.00	125	5	128	372	0.344086021505376	1.34318277813737	1.34318277813737	false	false	false	true	false
23e33d74-a7bd-4bab-b797-f4c9a3df0a5a	2026-09-09 11:23	2026-09-09 11:23	2026-09-09 11:23	SOXS	SOXS260918C00043500	call	43.5000	2026-09-18	3.8000	3.2000	4.2500	44.1200	28500.00	28500.00	0.00	75	6	182	442	0.411764705882353	1.26741091227087	1.26322869630015	true	false	false	true	false
637e53e6-2d28-4186-8010-4dd3351f9519	2026-09-09 10:13	2026-09-09 10:13	2026-09-09 10:13	SOXS	SOXS260911C00043000	call	43.0000	2026-09-11	1.4900	1.4900	1.5000	42.4610	62307.00	3750.00	58557.00	418	7	1041	299	3.48160535117057	1.38939860524816	1.38939860524816	false	false	false	true	false
54c9d1fb-9a10-4cf7-8392-33712d316ee7	2026-09-09 10:13	2026-09-09 10:13	2026-09-09 10:13	SOXS	SOXS260911C00043000	call	43.0000	2026-09-11	1.5000	1.5000	1.6000	42.4610	11700.00	0.00	11700.00	78	26	218	299	0.729096989966555	1.38939860524816	1.38939860524816	false	false	false	true	false
2094e86e-c32d-4daf-a8a4-dc1d4cca6251	2026-09-09 09:52	2026-09-09 09:52	2026-09-09 09:52	SOXS	SOXS260911C00044000	call	44.0000	2026-09-11	1.6100	1.6100	1.6500	43.4920	10787.00	0.00	10787.00	67	5	173	522	0.331417624521073	1.43187402353324	1.43187402353324	false	false	false	true	false
0bd969a4-06ec-48aa-8275-29f6aa2cd86a	2026-09-09 09:49	2026-09-09 09:49	2026-09-09 09:49	SOXS	SOXS260911C00045000	call	45.0000	2026-09-11	1.3000	1.3000	1.5700	43.6900	11310.00	0.00	11310.00	87	7	180	774	0.232558139534884	1.429312298472	1.43586182290808	false	false	false	true	false
be575a7f-4667-4a3a-9f34-f8046fea9ccc	2026-09-08 15:54	2026-09-08 15:54	2026-09-08 15:54	SOXS	SOXS261023C00044000	call	44.0000	2026-10-23	7.5000	6.2500	8.7500	44.5000	119250.00	97500.00	21750.00	159	6	161	0	0	1.16320940457157	1.16320940457157	false	false	false	true	false
9b746b0d-f47d-4274-8210-068482ac6fae	2026-09-08 15:54	2026-09-08 15:54	2026-09-08 15:54	SOXS	SOXS260911C00040000	call	40.0000	2026-09-11	5.0000	4.3500	5.0000	44.4500	10000.00	10000.00	0.00	20	6	226	171	1.32163742690058	1.43788517873465	1.33591558535579	false	false	false	true	false
12adcb71-f040-482d-a5a3-cc9225fd1892	2026-09-08 15:54	2026-09-08 15:54	2026-09-08 15:54	SOXS	SOXS260925C00044000	call	44.0000	2026-09-25	4.5500	4.3000	4.5500	44.3150	54145.00	54145.00	0.00	119	11	195	5	39	1.1483892538972	1.1483892538972	false	false	false	true	false
9406db54-a484-4497-9db4-1f548798c16d	2026-09-08 15:48	2026-09-08 15:48	2026-09-08 15:48	SOXS	SOXS260911C00043500	call	43.5000	2026-09-11	2.5000	2.4100	2.6000	44.2998	12500.00	11500.00	1000.00	50	5	417	0	0	1.30341363863879	1.30341363863879	false	false	false	true	false
f5399efc-d9a9-447e-9543-fe30abaa997a	2026-09-08 15:42	2026-09-08 15:42	2026-09-08 15:42	SOXS	SOXS260911C00044000	call	44.0000	2026-09-11	2.1500	2.0800	2.2500	44.1100	10750.00	215.00	10535.00	50	50	547	117	4.67521367521368	1.31776618932734	1.31113548429774	false	false	false	true	false
fed4ef52-09e0-45f4-9bcf-403a4f4bd7b1	2026-09-08 14:51	2026-09-08 14:51	2026-09-08 14:51	SOXS	SOXS261120C00043000	call	43.0000	2026-11-20	9.7300	9.2500	10.0500	43.5238	14600.00	14600.00	0.00	15	6	51	439	0.116173120728929	1.22534870626181	1.22534870626181	false	false	false	true	false
ec6c1aa8-5d00-4a1a-aa2f-bb652516c60e	2026-09-08 14:13	2026-09-08 14:13	2026-09-08 14:13	SOXS	SOXS260918C00043500	call	43.5000	2026-09-18	3.6000	3.5000	3.7000	43.3400	146520.00	0.00	144720.00	407	6	438	2	219	1.27856885413644	1.27856885413644	false	false	false	true	false
96be322f-f11b-406a-9e7f-47002934bc58	2026-09-08 13:32	2026-09-08 13:32	2026-09-08 13:32	SOXS	SOXS260911P00040500	put	40.5000	2026-09-11	1.0500	1.0000	1.1000	43.2150	18795.00	0.00	14595.00	179	13	329	26	12.6538461538462	1.41747246979945	1.41747246979945	false	false	false	true	false
a68289db-0dc8-439b-92da-20ba93c22ed4	2026-09-08 12:49	2026-09-08 12:48	2026-09-08 12:48	SOXS	SOXS260911C00038000	call	38.0000	2026-09-11	5.9500	5.3000	6.2000	43.5450	23783.00	23783.00	0.00	40	7	210	451	0.465631929046563	1.43831368936879	1.43831368936879	false	false	false	true	false
4a238023-3567-4321-9ec9-3d295c2023c0	2026-09-08 12:10	2026-09-08 12:09	2026-09-08 12:09	SOXS	SOXS260911C00044000	call	44.0000	2026-09-11	1.7300	1.6400	1.7300	42.9610	15570.00	15570.00	0.00	90	7	300	117	2.56410256410256	1.40325817962724	1.40325817962724	false	false	false	true	false
004d79e2-ffac-4ff2-b1dd-a15d0ca47a65	2026-09-08 11:54	2026-09-08 11:54	2026-09-08 11:54	SOXS	SOXS260911C00038000	call	38.0000	2026-09-11	5.3300	5.3000	5.5000	42.7999	31980.00	6396.00	25584.00	60	7	170	451	0.376940133037694	1.44340628467935	1.44340628467935	false	false	false	true	false
f0e4eacf-c664-4e65-b859-421e3e8b0778	2026-09-08 11:53	2026-09-08 11:53	2026-09-08 11:53	SOXS	SOXS260918C00043000	call	43.0000	2026-09-18	3.6000	3.3000	3.6000	42.9000	18360.00	18360.00	0.00	51	11	114	226	0.504424778761062	1.28213885317628	1.28213885317628	false	false	false	true	false
c89c4790-a023-4d4c-ace3-847085a3a561	2026-09-08 11:26	2026-09-08 11:26	2026-09-08 11:26	SOXS	SOXS261023P00040000	put	40.0000	2026-10-23	5.8300	5.1000	6.2000	42.6750	14578.00	14578.00	0.00	25	7	30	0	0	1.25660959311225	1.25660959311225	false	false	false	true	false
f83af8d7-a7c7-4288-85d0-495cfce22e5a	2026-09-08 11:18	2026-09-08 11:18	2026-09-08 11:18	SOXS	SOXS270219P00041000	put	41.0000	2027-02-19	12.6000	12.4500	12.8500	42.6301	22680.00	0.00	22680.00	18	5	28	32	0.875	1.27424289151411	1.27424289151411	false	false	false	true	false
3af798f1-8c44-4a9e-a1b0-097c8ccb45dd	2026-09-08 11:14	2026-09-08 11:14	2026-09-08 11:14	SOXS	SOXS280121C00050000	call	50.0000	2028-01-21	21.3500	21.3500	21.5000	42.9700	10675.00	0.00	10675.00	5	5	30	630	0.0476190476190476	1.21079687841171	1.21079687841171	false	false	false	true	false
4ce4faa4-9df8-4e78-b447-5adb0b513805	2026-09-08 10:16	2026-09-08 10:16	2026-09-08 10:16	SOXS	SOXS260918C00040000	call	40.0000	2026-09-18	5.9700	5.4500	6.0000	44.0600	11930.00	8930.00	0.00	20	6	21	739	0.0284167794316644	1.29472386729578	1.29069504544199	false	false	false	true	false
2bd8d825-d3df-4e2d-ada5-086c3a324212	2026-09-08 09:38	2026-09-08 09:37	2026-09-08 09:37	SOXS	SOXS260911C00045000	call	45.0000	2026-09-11	1.4700	1.4200	1.8200	43.2771	29401.00	147.00	29254.00	200	21	246	321	0.766355140186916	1.39156274048887	1.39233336364809	true	false	false	true	false
c7eae9ff-4db7-41bc-b630-3e377cfcff4b	2026-09-04 14:46	2026-09-04 14:45	2026-09-04 14:45	SOXS	SOXS260911C00040000	call	40.0000	2026-09-11	7.4500	7.3000	7.5500	47.0201	14900.00	5215.00	6705.00	20	5	51	112	0.455357142857143	1.03667525898093	1.03667525898093	false	false	false	true	false
81938110-cf0f-4d2d-8ff3-f47c71e26b53	2026-09-04 13:46	2026-09-04 13:46	2026-09-04 13:46	SOXS	SOXS260904P00054000	put	54.0000	2026-09-04	6.5000	6.5000	8.0500	47.5100	65000.00	0.00	65000.00	100	9	108	256	0.421875	12.3576108679686	3.49983273862121	false	false	false	true	false
29c5dbd1-4746-4364-96d3-219d37f2fe8d	2026-09-04 13:31	2026-09-04 13:31	2026-09-04 13:31	SOXS	SOXS260911P00048500	put	48.5000	2026-09-11	3.1500	3.1000	3.2000	47.3150	10395.00	0.00	8820.00	33	5	64	29	2.20689655172414	0.95847197802872	0.95847197802872	false	false	false	true	false
def11d46-88a7-42b0-afdf-b4a3ba3115de	2026-09-04 13:05	2026-09-04 13:05	2026-09-04 13:05	SOXS	SOXS280121C00070000	call	70.0000	2028-01-21	20.7400	20.2000	21.3500	46.6950	41480.00	12472.00	29008.00	20	14	51	950	0.0536842105263158	1.21793432315407	1.21793432315407	false	false	false	true	false
fe861212-739a-4818-bbf3-cbc6c9171ff5	2026-09-04 12:49	2026-09-04 12:49	2026-09-04 12:49	SOXS	SOXS260911P00049000	put	49.0000	2026-09-11	3.9000	3.4000	3.9000	46.5200	62352.00	62352.00	0.00	160	20	175	32	5.46875	0.951119200754306	0.936490902700184	false	false	false	true	false
f4a0ae92-452f-4a71-808e-2a949accffbf	2026-09-04 12:49	2026-09-04 12:49	2026-09-04 12:49	SOXS	SOXS260904P00052000	put	52.0000	2026-09-04	5.5500	4.9500	5.5500	46.5200	58819.00	58819.00	0.00	106	9	320	318	1.0062893081761	3.7865497401612	3.56555071881558	false	false	false	true	false
bc38397c-7af4-485c-bb01-8d3ba991ac41	2026-09-04 12:49	2026-09-04 12:49	2026-09-04 12:49	SOXS	SOXS260904P00048500	put	48.5000	2026-09-04	2.0800	1.5800	2.0800	46.5200	37440.00	37440.00	0.00	180	12	241	144	1.67361111111111	1.98165393507001	1.86811911982371	false	false	false	true	false
853e8bbe-99de-4b77-8dc2-8677ba94c0b6	2026-09-04 12:49	2026-09-04 12:49	2026-09-04 12:49	SOXS	SOXS260904P00049000	put	49.0000	2026-09-04	2.5800	2.0900	2.5800	46.5200	14964.00	14964.00	0.00	58	9	208	434	0.47926267281106	2.30856113011618	2.18252807959015	false	false	false	true	false
954892bd-d3e4-4f55-965f-78e07f6337ab	2026-09-04 11:30	2026-09-04 11:30	2026-09-04 11:30	SOXS	SOXS260918P00052000	put	52.0000	2026-09-18	6.7000	6.7000	7.8500	47.3350	80410.00	0.00	80410.00	120	16	124	124	1	1.03231143564686	1.03231143564686	true	false	false	true	false
c769ede8-06af-4c7f-9ba5-c4d8eb3fd69e	2026-09-04 10:49	2026-09-04 10:49	2026-09-04 10:49	SOXS	SOXS260911P00043000	put	43.0000	2026-09-11	0.8000	0.8000	1.1200	47.6890	24481.00	0.00	24481.00	306	13	394	110	3.58181818181818	0.990757739358599	0.990757739358599	true	false	false	true	false
66917693-22ca-4922-9b1e-443e01945e79	2026-09-04 10:48	2026-09-04 10:48	2026-09-04 10:48	SOXS	SOXS260918P00046500	put	46.5000	2026-09-18	3.4000	3.3500	3.8000	47.3150	35700.00	0.00	31960.00	105	16	110	1	110	1.04639766505207	1.04639766505207	true	false	false	true	false
0af7491f-ed43-4e82-8617-b1dcef135844	2026-09-04 10:30	2026-09-04 10:29	2026-09-04 10:29	SOXS	SOXS260904C00045000	call	45.0000	2026-09-04	1.9500	1.9500	2.5600	46.7710	36855.00	0.00	36855.00	189	8	298	868	0.34331797235023	1.64674360945063	1.64674360945063	false	false	false	true	false
382b0b72-e9c0-455a-a3ef-9901a9177c7a	2026-09-04 10:15	2026-09-04 10:15	2026-09-04 10:15	SOXS	SOXS261120P00046000	put	46.0000	2026-11-20	9.4500	9.2500	9.7500	46.7600	20790.00	16065.00	4725.00	22	5	38	2	19	1.19736392449108	1.19736392449108	true	false	false	true	false
a200a31f-1638-4d66-a97c-d2cde50400c2	2026-09-04 09:53	2026-09-04 09:53	2026-09-04 09:53	SOXS	SOXS261016P00040000	put	40.0000	2026-10-16	3.6500	3.4500	3.7000	46.9650	26280.00	730.00	25550.00	72	8	110	209	0.526315789473684	1.13651312174411	1.13651312174411	false	false	false	true	false
013b3c3f-2479-4018-8f72-0e928f959427	2026-09-04 09:44	2026-09-04 09:44	2026-09-04 09:44	SOXS	SOXS260904P00052000	put	52.0000	2026-09-04	4.2000	4.2000	4.6000	47.6300	50400.00	0.00	50400.00	120	32	155	318	0.487421383647799	2.83936079816991	2.83936079816991	false	false	false	true	false
5a45b502-200d-4940-bbe9-6a5cdbc31c66	2026-09-04 09:42	2026-09-04 09:42	2026-09-04 09:42	SOXS	SOXS260911C00042000	call	42.0000	2026-09-11	6.3000	6.2000	6.5000	47.6800	15750.00	9450.00	6300.00	25	12	25	116	0.21551724137931	1.00524398351062	0.994858701588464	false	false	false	true	false
263d3c91-30d8-42e5-b394-652bd1b1d0c2	2026-09-04 09:30	2026-09-04 09:30	2026-09-04 09:30	SOXS	SOXS260911P00051000	put	51.0000	2026-09-11	5.8300	3.0500	5.9000	49.5050	48980.00	6860.00	42120.00	84	7	84	236	0.355932203389831	1.8566981199665	1.06918223931319	false	false	false	true	false