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 = RepeatedHitsAscendingFill×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	expiry

590e3c35-ff73-45e5-810f-fdccb2e0438a	2026-08-17 14:49	2026-08-17 14:49	2026-08-17 14:49	SOXS	SOXS260918C00040000	call	40.0000	2026-09-18	4.7000	4.7000	4.8000	37.7250	26815.00	0.00	26815.00	57	18	133	657	0.202435312024353	1.25278561946331	1.25278561946331	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	1795976211.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
63a6060b-ad79-426f-ad42-4d02ab7e36a9	2026-08-18 10:17	2026-08-18 10:17	2026-08-18 10:17	SOXS	SOXS261002C00060000	call	60.0000	2026-10-02	3.5100	3.2000	3.9000	44.4488	12651.00	355.00	10496.00	36	10	53	76	0.697368421052632	1.27884078748768	1.27884078748768	false	false	false	true
0c013e52-1c90-4bdd-bd00-017cee9bc926	2026-08-18 10:30	2026-08-18 10:30	2026-08-18 10:30	SOXS	SOXS261120C00040000	call	40.0000	2026-11-20	13.3400	13.1500	14.0500	43.8400	28020.00	8040.00	19980.00	21	9	1251	121	10.3388429752066	1.33460092103518	1.34095922942104	true	false	false	true
d2a8be4e-58c9-4c8f-aaba-22b6ae06c003	2026-08-18 11:32	2026-08-18 11:32	2026-08-18 11:32	SOXS	SOXS260904C00045500	call	45.5000	2026-09-04	4.8700	4.8500	5.7500	44.8300	17525.00	0.00	17525.00	36	21	51	11	4.63636363636364	1.32741070735375	1.32741070735375	true	false	false	true
32e77780-9df9-4bac-95c6-4294e5a2194d	2026-08-18 13:07	2026-08-18 13:07	2026-08-18 13:07	SOXS	SOXS261120P00050000	put	50.0000	2026-11-20	15.9700	15.7000	16.3000	44.8499	12776.00	4796.00	7980.00	8	8	65	43	1.51162790697674	1.44516361434994	1.44721452342317	true	false	false	true
b02669b6-dd4e-4e92-9b2a-a5e2ef3665ae	2026-08-18 15:27	2026-08-18 15:27	2026-08-18 15:27	SOXS	SOXS261120C00042000	call	42.0000	2026-11-20	13.0000	12.9000	13.2500	44.5750	23392.00	7800.00	15592.00	18	6	163	188	0.867021276595745	1.33392745731747	1.33759206905947	true	false	false	true
ce9c7eb2-c3ac-4ff9-8bf0-bd5cd03f3fd3	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	SOXS	SOXS260821C00046000	call	46.0000	2026-08-21	2.2300	1.6100	2.4400	46.9950	10458.00	4840.00	5618.00	47	7	65	758	0.0857519788918206	1.7047840934597	1.7765992640407	true	false	false	true
02a3e916-d5b8-4378-972c-2f19f02faede	2026-08-24 12:00	2026-08-24 12:00	2026-08-24 12:00	SOXS	SOXS260828P00045000	put	45.0000	2026-08-28	0.8700	0.8000	1.0000	50.8200	28447.00	28275.00	172.00	327	5	682	990	0.688888888888889	1.44668841977332	1.45362694871668	false	false	false	true
81ffa813-d89d-4534-bfc2-f3bc5a0b166a	2026-08-25 09:45	2026-08-25 09:45	2026-08-25 09:45	SOXS	SOXS280121C00100000	call	100.0000	2028-01-21	20.0700	20.0000	21.0000	47.5000	10035.00	0.00	10035.00	5	5	5	219	0.0228310502283105	1.33528155933627	1.33528155933627	false	false	false	true
3740bc54-c4c2-4b92-b443-8dbae58d48c9	2026-08-26 09:43	2026-08-26 09:43	2026-08-26 09:43	SOXS	SOXS260911C00048000	call	48.0000	2026-09-11	4.8100	4.8000	5.8000	48.2700	31245.00	1470.00	29775.00	65	14	65	64	1.015625	1.15361437547463	1.16615860651407	true	false	false	true
f504b73d-9e72-49dd-bc8d-9d4d91be221e	2026-08-26 15:59	2026-08-26 15:59	2026-08-26 15:59	SOXS	SOXS260828C00048500	call	48.5000	2026-08-28	1.9500	1.9400	2.1500	48.2600	14615.00	0.00	1940.00	75	14	395	187	2.11229946524064	1.43773063533302	1.43773063533302	false	false	false	true
e7852c53-56f7-40ae-910b-e02ef12e55d7	2026-08-28 10:17	2026-08-28 10:17	2026-08-28 10:17	SOXS	SOXS260918C00060000	call	60.0000	2026-09-18	1.4800	1.0500	1.5000	47.3400	22666.00	11324.00	11342.00	153	17	158	692	0.228323699421965	1.10896739862179	1.11771263271448	true	false	false	true
6ae5e4ed-09c3-444d-8ceb-c6ba5f837c35	2026-08-28 10:35	2026-08-28 10:35	2026-08-28 10:35	SOXS	SOXS260828P00046000	put	46.0000	2026-08-28	0.4100	0.3100	0.4100	46.4650	11243.00	10363.00	0.00	275	12	560	341	1.64222873900293	1.31951260786605	1.34237461677847	false	false	false	true
78ca1274-a550-4eb0-81a4-e714ac34c819	2026-08-28 11:40	2026-08-28 11:40	2026-08-28 11:40	SOXS	SOXS260904C00050000	call	50.0000	2026-09-04	1.8300	1.6800	1.8500	47.0000	17385.00	8280.00	9105.00	95	7	404	846	0.477541371158392	0.994489005983666	1.00609497376453	true	false	false	true
76cf1d9b-cda7-4af7-b8c7-6afcc37faf55	2026-08-28 11:40	2026-08-28 11:40	2026-08-28 11:40	SOXS	SOXS260904C00049500	call	49.5000	2026-09-04	2.0200	1.8800	2.1200	47.0000	20157.00	11127.00	9030.00	100	20	110	18	6.11111111111111	0.996117294928176	1.00588386524247	true	false	false	true
8878c75c-b026-4da5-902b-a64d0b5ebb1d	2026-08-28 11:58	2026-08-28 11:57	2026-08-28 11:57	SOXS	SOXS260828C00050000	call	50.0000	2026-08-28	0.3500	0.3200	0.3500	49.0000	10533.00	10500.00	0.00	301	23	1366	3041	0.449194343965801	1.37529911502991	1.42640314392697	true	false	false	true
0d3b0d34-91a6-4bc9-b936-675aff3e71a6	2026-08-28 14:08	2026-08-28 14:08	2026-08-28 14:08	SOXS	SOXS280121C00105000	call	105.0000	2028-01-21	19.1800	18.8000	19.8000	49.4300	13426.00	3830.00	9596.00	7	6	86	656	0.13109756097561	1.26757790798559	1.27070528039128	false	false	false	true
f6e90562-fef5-4285-b33d-f0b8999bb799	2026-08-28 14:58	2026-08-28 14:58	2026-08-28 14:58	SOXS	SOXS270219C00100000	call	100.0000	2027-02-19	7.6800	6.3000	7.9500	49.9150	76798.00	76798.00	0.00	100	14	103	24	4.29166666666667	1.28759259812144	1.28759259812144	false	false	false	true
1d074b1b-8737-4444-b998-3e0b3bbed2a5	2026-08-31 09:32	2026-08-31 09:32	2026-08-31 09:32	SOXS	SOXS260904C00050000	call	50.0000	2026-09-04	1.8300	1.6500	1.8500	48.2773	88810.00	88810.00	0.00	484	10	607	1852	0.327753779697624	1.26458263821607	1.27469100119632	true	false	false	true
bdd7546e-f11a-4bd6-87ef-50801868e2b6	2026-08-31 15:57	2026-08-31 15:56	2026-08-31 15:56	SOXS	SOXS280121C00100000	call	100.0000	2028-01-21	18.9900	18.7500	20.0000	49.0601	56974.00	0.00	56974.00	30	5	44	273	0.161172161172161	1.25103370343756	1.25464836363945	false	false	false	true
01b1a53a-b51e-4c61-9560-8f079a2d27f2	2026-09-01 10:19	2026-09-01 10:19	2026-09-01 10:19	SOXS	SOXS260904C00052000	call	52.0000	2026-09-04	3.0700	2.9000	3.3000	53.5250	15059.00	4034.00	11025.00	49	31	221	1754	0.12599771949829	1.06817616378748	1.17756964188712	false	false	false	true
8e1bbb0c-1edb-4f6b-a6d5-d1ab327f9b35	2026-09-02 13:13	2026-09-02 13:13	2026-09-02 13:13	SOXS	SOXS260904C00052000	call	52.0000	2026-09-04	1.8700	1.8700	1.9900	52.0650	17211.00	0.00	17023.00	92	25	1037	1906	0.544071353620147	1.1926232864313	1.19913922622127	true	false	false	true
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
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
5f9148e5-b0ff-4134-933b-ba8af3abacc3	2026-09-11 11:01	2026-09-11 11:00	2026-09-11 11:00	SOXS	SOXS261016P00035000	put	35.0000	2026-10-16	1.8200	1.7400	2.1000	44.2750	12763.00	0.00	12763.00	70	8	74	791	0.0935524652338812	1.05898009714311	1.11809211582938	false	false	false	true
2994d4b9-1c85-44c7-b6d1-b94d48df40e0	2026-09-15 09:42	2026-09-15 09:42	2026-09-15 09:42	SOXS	SOXS270115P00051000	put	51.0000	2027-01-15	14.4800	14.0000	15.5500	50.0200	36202.00	0.00	36202.00	25	5	25	20	1.25	1.26678015731363	1.26955378724071	false	false	false	true
9247ff67-e337-43ff-a008-40da3aa072ec	2026-09-15 13:32	2026-09-15 13:32	2026-09-15 13:32	SOXS	SOXS270115C00080000	call	80.0000	2027-01-15	6.8000	6.5000	7.4500	51.4700	33988.00	0.00	33988.00	50	18	82	682	0.120234604105572	1.17661162050844	1.17661162050844	false	false	false	true
1463c7f4-a8a6-479d-b7cb-3639a2eca6c4	2026-09-15 13:37	2026-09-15 13:37	2026-09-15 13:37	SOXS	SOXS261009C00045000	call	45.0000	2026-10-09	8.7700	8.7000	9.3000	51.4300	15790.00	7920.00	7870.00	18	5	18	32	0.5625	0.962532969995145	0.986320488152137	false	false	false	true
4949e61f-e18e-4434-ac30-39a041119a69	2026-09-15 15:25	2026-09-15 15:25	2026-09-15 15:25	SOXS	SOXS261016P00049000	put	49.0000	2026-10-16	5.3000	5.3000	5.4500	51.3550	144226.00	0.00	144226.00	272	22	273	2	136.5	1.11845719379648	1.11845719379648	true	false	false	true
54806a0a-2c1a-4edb-83bf-1453d5f8b206	2026-09-15 15:41	2026-09-15 15:41	2026-09-15 15:41	SOXS	SOXS261023C00052000	call	52.0000	2026-10-23	6.7200	6.5000	7.0500	51.1499	30260.00	2680.00	27580.00	45	18	46	0	0	1.06349146199446	1.06349146199446	true	false	false	true
3864337a-7c4d-4222-8c9e-d128762e57de	2026-09-16 15:47	2026-09-16 15:47	2026-09-16 15:47	SOXS	SOXS261016C00050000	call	50.0000	2026-10-16	6.4900	6.4500	7.1000	50.0000	18835.00	0.00	18835.00	29	12	272	407	0.668304668304668	1.07578387749808	1.08461481647452	false	false	false	true
fcd76388-6c15-4e82-82e8-734d6bc6cedf	2026-09-17 09:50	2026-09-17 09:50	2026-09-17 09:50	SOXS	SOXS280121C00050000	call	50.0000	2028-01-21	22.8100	22.8000	22.9500	45.0000	41056.00	0.00	41056.00	18	7	54	755	0.071523178807947	1.20889876503737	1.21010241905292	false	false	false	true
d203d5d1-f1ed-465f-a83c-9fa476c3b2ea	2026-09-21 11:26	2026-09-21 11:26	2026-09-21 11:26	SOXS	SOXS260925C00035000	call	35.0000	2026-09-25	2.1500	2.0300	2.3500	36.4000	45030.00	0.00	45030.00	209	15	226	140	1.61428571428571	0.888505919092061	0.910526814650824	true	false	false	true
34138af0-dfb4-48a1-8db3-05fdad98a9cb	2026-09-21 14:11	2026-09-21 14:11	2026-09-21 14:11	SOXS	SOXS261016C00043000	call	43.0000	2026-10-16	1.8000	1.7500	1.9500	35.9564	34289.00	0.00	34289.00	190	12	604	154	3.92207792207792	1.0822747531871	1.0822747531871	true	false	false	true
da04f63c-3b04-45c3-a3f3-1ae83cf53c0b	2026-09-21 15:42	2026-09-21 15:42	2026-09-21 15:42	SOXS	SOXS260925C00035000	call	35.0000	2026-09-25	1.2700	1.2600	1.3900	34.8199	12708.00	0.00	12708.00	100	5	2130	140	15.2142857142857	0.920222046097689	0.947728782198582	false	false	false	true
81dd25b6-ee74-4eb7-a2a0-0fe5a61104a6	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SOXS	SOXS260925C00041000	call	41.0000	2026-09-25	0.1600	0.1600	0.3800	35.5600	11852.00	0.00	11852.00	730	12	730	1467	0.497614178595774	1.1529847666116	1.17098078562254	true	false	false	true
61c6106b-8a73-4723-bfb9-c01d2894b5e2	2026-09-22 09:53	2026-09-22 09:53	2026-09-22 09:53	SOXS	SOXS261002C00031000	call	31.0000	2026-10-02	4.4200	4.3500	5.1000	34.3800	16803.00	0.00	16803.00	38	7	39	111	0.351351351351351	1.0413070760503	1.09679795780589	true	false	false	true
95c2a227-11d5-4d0d-a8d4-7f0ace33a1c7	2026-09-22 14:24	2026-09-22 14:24	2026-09-22 14:24	SOXS	SOXS270115C00044000	call	44.0000	2027-01-15	5.8100	5.7000	6.0000	32.9550	38318.00	4060.00	34258.00	66	5	219	142	1.54225352112676	1.2223971439538	1.22511184315695	false	false	false	true