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

9da36dcd-c1c1-4b67-90b4-b95ee5c6f95b	2026-08-17 09:33	2026-08-17 09:32	2026-08-17 09:32	SNXX	SNXX260904C00020000	call	20.0000	2026-09-04	1.9500	1.8000	2.2500	17.5900	11700.00	0.00	11700.00	60	11	77	544	0.141544117647059	1.80761638426853	1.81055325319104	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	13229825.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
65e8caf8-8a57-45f9-bad1-12256b5f7a17	2026-08-17 09:36	2026-08-17 09:35	2026-08-17 09:35	SNXX	SNXX260918C00020000	call	20.0000	2026-09-18	3.0000	2.9000	3.0000	18.0900	15300.00	15300.00	0.00	51	5	164	2228	0.0736086175942549	1.73534896018625	1.73534896018625	false	false	false	true
4b15bf37-ddfe-4e7c-bcc3-2cd83cc40499	2026-08-17 09:36	2026-08-17 09:36	2026-08-17 09:36	SNXX	SNXX260821C00016000	call	16.0000	2026-08-21	2.8000	2.4500	2.8000	18.1700	84000.00	84000.00	0.00	300	5	448	2762	0.162201303403331	2.05464260107373	2.05464260107373	false	false	false	true
fea73da3-ea30-406b-83bc-206c86412d9c	2026-08-17 09:43	2026-08-17 09:43	2026-08-17 09:43	SNXX	SNXX260821C00020000	call	20.0000	2026-08-21	1.0000	0.9500	1.0000	18.3550	11000.00	11000.00	0.00	110	6	668	4360	0.153211009174312	2.12123883765314	2.12123883765314	false	false	false	true
be2f5a61-568b-4dea-8aab-194e8e46957b	2026-08-17 09:54	2026-08-17 09:53	2026-08-17 09:53	SNXX	SNXX260821C00020000	call	20.0000	2026-08-21	1.1500	1.1000	1.1500	18.7499	23000.00	23000.00	0.00	200	6	1368	4360	0.313761467889908	2.10536253672662	2.10536253672662	false	false	false	true
8e2f6482-6837-497b-9215-7c18ad990360	2026-08-17 10:07	2026-08-17 10:07	2026-08-17 10:07	SNXX	SNXX260828C00020000	call	20.0000	2026-08-28	1.8500	1.8500	1.9000	18.5950	18315.00	0.00	18315.00	99	7	337	690	0.488405797101449	1.86567014154012	1.86567014154012	false	false	false	true
0e6b2cc5-8683-44e2-b5ff-b8368126b482	2026-08-17 10:09	2026-08-17 10:09	2026-08-17 10:09	SNXX	SNXX260821C00018000	call	18.0000	2026-08-21	1.7500	1.7500	1.8500	18.5401	14005.00	0.00	13825.00	80	6	1039	1966	0.528484231943032	1.91715531079418	1.98368266332121	false	false	false	true
445392a4-c36b-490e-bda5-18c8f104efe9	2026-08-17 10:09	2026-08-17 10:09	2026-08-17 10:09	SNXX	SNXX260821C00017000	call	17.0000	2026-08-21	2.3500	2.3500	2.4000	18.5425	12220.00	0.00	12220.00	52	5	510	1567	0.325462667517549	1.95192212372476	1.95192212372476	false	false	false	true
17656aa2-be2a-466a-885c-b3819588de8a	2026-08-17 10:09	2026-08-17 10:09	2026-08-17 10:09	SNXX	SNXX260821C00017000	call	17.0000	2026-08-21	2.3500	2.3500	2.4000	18.5400	14805.00	0.00	14805.00	63	16	573	1567	0.365666879387364	1.95452664652567	1.95452664652567	false	false	false	true
c50369a2-1c17-4d5f-b5c0-0c1efc4536bd	2026-08-17 10:09	2026-08-17 10:09	2026-08-17 10:09	SNXX	SNXX260821C00017000	call	17.0000	2026-08-21	2.3500	2.3500	2.4000	18.5400	47940.00	0.00	47940.00	204	15	863	1567	0.550733886407147	1.95452664652567	1.95452664652567	false	false	false	true
938470ff-1223-4c5c-9f63-55c04249b9d8	2026-08-17 10:37	2026-08-17 10:37	2026-08-17 10:37	SNXX	SNXX260821C00019500	call	19.5000	2026-08-21	1.4800	1.4000	1.5000	19.1301	13912.00	13912.00	0.00	94	6	2500	23	108.695652173913	2.05564049334303	2.05564049334303	false	false	false	true
a2f3f182-1693-43eb-85e7-5b7f7ba6fb0c	2026-08-17 10:42	2026-08-17 10:41	2026-08-17 10:41	SNXX	SNXX260821P00020000	put	20.0000	2026-08-21	2.1900	2.1500	2.2000	19.0682	10731.00	10731.00	0.00	49	6	239	894	0.267337807606264	2.07427081115687	2.07427081115687	false	false	false	true
032998aa-f8ae-433f-bd52-f90333339e8e	2026-08-17 10:45	2026-08-17 10:45	2026-08-17 10:45	SNXX	SNXX260821C00017000	call	17.0000	2026-08-21	2.7500	2.7500	2.8000	19.1273	21180.00	280.00	20900.00	77	5	1089	1567	0.694958519463944	1.91168911830026	1.99064234203572	false	false	false	true
8ad279f8-799b-406f-a9d4-5b61daf286b2	2026-08-17 10:47	2026-08-17 10:47	2026-08-17 10:47	SNXX	SNXX260821C00018500	call	18.5000	2026-08-21	2.1000	2.0000	2.1000	19.4351	12180.00	12180.00	0.00	58	7	1382	117	11.8119658119658	2.00441634532129	2.00433356239405	false	false	false	true
50e18aec-a169-40b9-8153-2ab11e0cb9c8	2026-08-17 10:48	2026-08-17 10:48	2026-08-17 10:48	SNXX	SNXX260821C00020000	call	20.0000	2026-08-21	1.5000	1.4500	1.5500	19.6098	16800.00	15300.00	0.00	112	8	2960	4360	0.678899082568807	2.04042643356316	2.04042643356316	false	false	false	true
5b4d73a8-bb71-4bae-986b-c7c4599036cf	2026-08-17 10:58	2026-08-17 10:58	2026-08-17 10:58	SNXX	SNXX260828P00017000	put	17.0000	2026-08-28	1.2500	1.2500	1.4000	19.6350	125001.00	0.00	125001.00	1000	14	1084	36	30.1111111111111	1.85819007644738	1.86705217125832	true	false	false	true
e177e54b-2d07-41a8-84ef-897ee802e609	2026-08-17 11:13	2026-08-17 11:13	2026-08-17 11:13	SNXX	SNXX260821C00020000	call	20.0000	2026-08-21	1.5000	1.5000	1.5500	19.5850	16950.00	0.00	16950.00	113	11	3726	4360	0.854587155963303	2.05575141221896	2.05575141221896	false	false	false	true
6a335ce0-89bb-4aa7-a2f5-d42f5737ee4c	2026-08-17 11:13	2026-08-17 11:13	2026-08-17 11:13	SNXX	SNXX260821C00020000	call	20.0000	2026-08-21	1.5000	1.4500	1.5500	19.5699	13200.00	8700.00	4500.00	88	5	3841	4360	0.880963302752294	2.06506547777541	2.06506547777541	false	false	false	true
ad365b97-cba9-4779-b098-d10cd1a4da30	2026-08-17 11:29	2026-08-17 11:29	2026-08-17 11:29	SNXX	SNXX260821P00018000	put	18.0000	2026-08-21	1.0000	0.9500	1.0500	19.4100	80500.00	0.00	5500.00	805	6	5638	674	8.36498516320475	2.06700168541084	2.06700168541084	false	false	false	true
56029fbd-bb21-4133-bd48-70869fa19ffd	2026-08-17 11:29	2026-08-17 11:29	2026-08-17 11:29	SNXX	SNXX260821C00018000	call	18.0000	2026-08-21	2.4000	2.4000	2.5500	19.4400	21840.00	0.00	21840.00	91	5	1432	1966	0.728382502543235	2.0150086366318	2.0150086366318	false	false	false	true
0c82132b-cfff-4a02-adfe-198d4dac9ad9	2026-08-17 11:29	2026-08-17 11:29	2026-08-17 11:29	SNXX	SNXX260821P00018000	put	18.0000	2026-08-21	1.0000	0.9500	1.0000	19.4400	15090.00	15090.00	0.00	151	23	4828	674	7.16320474777448	2.08025698099387	2.08025698099387	false	false	false	true
b0367e00-8702-4281-b24b-920e48ee85c1	2026-08-17 11:30	2026-08-17 11:30	2026-08-17 11:30	SNXX	SNXX260821P00018000	put	18.0000	2026-08-21	1.0000	0.9500	1.0000	19.4400	124500.00	124500.00	0.00	1245	27	6919	674	10.2655786350148	2.08025698099387	2.08025698099387	false	false	false	true
1f8c0b37-8f25-425f-9c29-9d5df6190818	2026-08-17 11:48	2026-08-17 11:48	2026-08-17 11:48	SNXX	SNXX260821P00018000	put	18.0000	2026-08-21	1.0500	1.0500	1.1000	19.0801	105000.00	0.00	105000.00	1000	18	7964	674	11.8160237388724	1.98412595483044	1.98412595483044	false	false	false	true
b6ec2d0e-b24b-428b-aeea-12b86c839899	2026-08-17 11:49	2026-08-17 11:49	2026-08-17 11:49	SNXX	SNXX260821P00018000	put	18.0000	2026-08-21	1.0500	1.0000	1.0500	19.1000	105000.00	105000.00	0.00	1000	6	8964	674	13.299703264095	1.99351528340779	1.99351528340779	false	false	false	true
611bd4f6-b44c-449a-b776-5e43791921f5	2026-08-17 11:50	2026-08-17 11:50	2026-08-17 11:50	SNXX	SNXX260821P00018000	put	18.0000	2026-08-21	1.0500	1.0500	1.1500	18.9600	105000.00	0.00	105000.00	1000	5	9975	674	14.799703264095	1.92667480684833	1.92667480684833	false	false	false	true
11369790-3fb1-42a9-b2fe-8baf0678d803	2026-08-17 11:51	2026-08-17 11:51	2026-08-17 11:51	SNXX	SNXX260821P00018000	put	18.0000	2026-08-21	1.0500	1.0500	1.1500	18.9800	105000.00	0.00	105000.00	1000	6	10979	674	16.2893175074184	1.93633779617223	1.93633779617223	false	false	false	true
77502822-2fe0-4a0e-b9d0-be8a91fb58b9	2026-08-17 11:52	2026-08-17 11:52	2026-08-17 11:52	SNXX	SNXX260821P00018000	put	18.0000	2026-08-21	1.0500	1.0000	1.1000	19.0900	15750.00	14595.00	735.00	150	7	13434	674	19.9317507418398	1.98880152909928	1.98880152909928	false	false	false	true
45872126-d525-4f64-850a-4e3a71640686	2026-08-17 12:22	2026-08-17 12:22	2026-08-17 12:22	SNXX	SNXX260828C00022000	call	22.0000	2026-08-28	1.5000	1.4000	1.6000	19.2550	15000.00	12000.00	0.00	100	7	577	696	0.829022988505747	1.85987103739925	1.85987103739925	false	false	false	true
ef45b9e9-e924-431b-81f2-f072566122cc	2026-08-17 12:40	2026-08-17 12:40	2026-08-17 12:40	SNXX	SNXX260821C00019500	call	19.5000	2026-08-21	1.4000	1.3500	1.4500	19.1400	16800.00	1960.00	14840.00	120	5	3701	23	160.913043478261	1.95555742297684	1.94924145631671	false	false	false	true
63b1de77-c49e-4393-885c-93d1f20899c5	2026-08-17 14:01	2026-08-17 14:01	2026-08-17 14:01	SNXX	SNXX260821C00020000	call	20.0000	2026-08-21	1.1500	1.1000	1.2000	18.0000	19655.00	0.00	19655.00	171	6	5531	4360	1.26857798165138	1.9710479395367	1.90727242049862	false	false	false	true
0ddf1e90-d99a-4c2e-ab05-bdf9eff22ee6	2026-08-17 14:02	2026-08-17 14:01	2026-08-17 14:01	SNXX	SNXX260828C00023000	call	23.0000	2026-08-28	1.1500	1.1500	1.2500	18.0000	12075.00	0.00	12075.00	105	6	708	52	13.6153846153846	1.86953193850649	1.86953193850649	false	false	false	true
f6f61ca2-7e7d-4f70-bd3d-67c827e10e8e	2026-08-18 09:38	2026-08-18 09:38	2026-08-18 09:38	SNXX	SNXX260821P00017000	put	17.0000	2026-08-21	1.3500	1.2000	1.3500	17.0600	27000.00	27000.00	0.00	200	12	638	2404	0.265391014975042	2.2486144235707	2.2486144235707	false	false	false	true
e372ac59-8d3f-4de0-be91-ff61c257857d	2026-08-18 09:41	2026-08-18 09:41	2026-08-18 09:41	SNXX	SNXX260821C00017500	call	17.5000	2026-08-21	1.2500	1.2000	1.4000	17.0000	12500.00	9250.00	3250.00	100	6	202	858	0.235431235431235	2.13686251112623	2.13686251112623	false	false	false	true
efb02825-c0d4-4aaf-995f-63dc922fd770	2026-08-18 10:03	2026-08-18 10:02	2026-08-18 10:02	SNXX	SNXX260828C00016000	call	16.0000	2026-08-28	2.4400	2.3000	2.4500	16.7699	11956.00	11956.00	0.00	49	5	89	144	0.618055555555556	1.87810526351432	1.87810526351432	false	false	false	true
0f7320d4-6418-4af2-ba96-ac5069c33a8d	2026-08-18 10:39	2026-08-18 10:39	2026-08-18 10:39	SNXX	SNXX260911C00016000	call	16.0000	2026-09-11	3.0600	2.6000	3.3000	16.3750	16218.00	11934.00	4284.00	53	5	70	85	0.823529411764706	1.73616349272624	1.73616349272624	false	false	false	true
ba64c873-f7ea-42da-a5d9-7360eae0890e	2026-08-18 10:56	2026-08-18 10:56	2026-08-18 10:56	SNXX	SNXX260821P00016000	put	16.0000	2026-08-21	1.3000	1.2500	1.3000	15.7150	13000.00	13000.00	0.00	100	6	736	708	1.03954802259887	2.01629142398298	2.01629142398298	false	false	false	true
20b7f347-0840-4c93-b3f9-bb28efb641c3	2026-08-18 11:23	2026-08-18 11:23	2026-08-18 11:23	SNXX	SNXX260821C00020000	call	20.0000	2026-08-21	0.2500	0.1500	0.2500	15.7950	10000.00	10000.00	0.00	400	5	1903	5594	0.340185913478727	2.33390283200251	2.33390283200251	false	false	false	true
a3fd84f9-56a0-46a1-b95f-ec862f1a9c0d	2026-08-18 13:16	2026-08-18 13:16	2026-08-18 13:16	SNXX	SNXX260821C00017500	call	17.5000	2026-08-21	0.4500	0.4000	0.5000	15.3550	15840.00	13995.00	0.00	352	9	1316	858	1.53379953379953	2.07934522604498	2.08717499289603	false	false	false	true
a451bb06-6598-43e8-a609-2e4db44bf5bc	2026-08-18 14:46	2026-08-18 14:46	2026-08-18 14:46	SNXX	SNXX260828C00016000	call	16.0000	2026-08-28	1.6500	1.5000	1.6500	15.3700	33000.00	33000.00	0.00	200	7	1132	144	7.86111111111111	1.88314551045831	1.88314551045831	false	false	false	true
459c8efd-7d6b-4cb3-a926-8f61abb846dc	2026-08-18 15:33	2026-08-18 15:32	2026-08-18 15:32	SNXX	SNXX260821C00016000	call	16.0000	2026-08-21	0.9500	0.9000	1.0000	15.6100	19000.00	18905.00	0.00	200	8	1869	2091	0.893830703012912	1.99097514903489	1.98354718224534	false	false	false	true
e698f68c-9d4a-4b9a-a0ac-83aea30bf977	2026-08-19 10:07	2026-08-19 10:07	2026-08-19 10:07	SNXX	SNXX261218C00020000	call	20.0000	2026-12-18	4.2000	4.2000	4.8000	14.6000	46200.00	0.00	46200.00	110	5	130	1282	0.101404056162246	1.71400825449477	1.71400825449477	false	false	false	true
60f6380e-c4e3-4424-a9cf-d1e6e444fe69	2026-08-19 11:42	2026-08-19 11:42	2026-08-19 11:42	SNXX	SNXX260904C00021000	call	21.0000	2026-09-04	0.6600	0.6500	0.8000	14.7700	33000.00	0.00	33000.00	500	5	522	69	7.56521739130435	1.8380967048291	1.8380967048291	false	false	false	true
8a587a22-b637-43aa-993f-0edd4193536c	2026-08-19 11:48	2026-08-19 11:48	2026-08-19 11:48	SNXX	SNXX260904P00010000	put	10.0000	2026-09-04	0.3000	0.3000	0.4000	14.9001	30000.00	0.00	30000.00	1000	10	1001	129	7.75968992248062	1.73619651899928	1.73619651899928	false	false	false	true
bf9227b9-7f47-4bac-b08c-6669c86e1e32	2026-08-19 13:24	2026-08-19 13:24	2026-08-19 13:24	SNXX	SNXX260918C00015000	call	15.0000	2026-09-18	2.5400	2.5000	2.7000	14.5300	10160.00	0.00	6000.00	40	8	365	1942	0.187950566426365	1.61801461298667	1.68085934661221	false	false	false	true
7d8097d7-1756-4aab-b490-949eed410045	2026-08-19 13:42	2026-08-19 13:42	2026-08-19 13:42	SNXX	SNXX260821C00017500	call	17.5000	2026-08-21	0.1500	0.1000	0.1500	14.3101	14850.00	14850.00	0.00	990	19	5007	898	5.57572383073497	2.27032232115705	2.27032232115705	false	false	false	true
c979b963-b905-46ab-a529-c8ffe6274773	2026-08-20 09:56	2026-08-20 09:56	2026-08-20 09:56	SNXX	SNXX260925C00013000	call	13.0000	2026-09-25	4.4000	3.3000	4.4000	14.9750	17600.00	17600.00	0.00	40	7	40	220	0.181818181818182	1.91198186900935	1.91198186900935	false	false	false	true
a176ed1f-3c82-4969-b959-6de72960b2dc	2026-08-20 10:49	2026-08-20 10:49	2026-08-20 10:49	SNXX	SNXX260828C00016000	call	16.0000	2026-08-28	1.4000	1.4000	1.5500	15.4300	18200.00	0.00	18200.00	130	5	511	1321	0.386828160484481	1.79858765400055	1.79858765400055	false	false	false	true
e6c551a0-7ca6-4f84-a133-03411c441c12	2026-08-20 11:36	2026-08-20 11:36	2026-08-20 11:36	SNXX	SNXX260821C00015500	call	15.5000	2026-08-21	0.4500	0.4500	0.5000	15.0402	15840.00	0.00	15840.00	352	11	1151	1593	0.722536095417451	2.05136000939134	2.05136000939134	false	false	false	true
afcaa0c4-866a-400a-ae61-58519d19947e	2026-08-20 11:39	2026-08-20 11:39	2026-08-20 11:39	SNXX	SNXX260821C00015500	call	15.5000	2026-08-21	0.4000	0.4000	0.5000	15.0096	18000.00	0.00	18000.00	450	10	3509	1593	2.20276208411802	1.92758140189697	1.92758140189697	false	false	false	true
c727bdc1-af99-4955-9e7a-d903b83bbca2	2026-08-20 11:40	2026-08-20 11:40	2026-08-20 11:40	SNXX	SNXX260821C00015500	call	15.5000	2026-08-21	0.4000	0.4000	0.5000	15.0250	12040.00	0.00	12040.00	301	11	4260	1593	2.67419962335217	1.90744989391602	1.90744989391602	false	false	false	true