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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = SNXX×

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

3f3771ac-d3d8-440d-8565-be928c21afc7	2026-09-16 14:20	2026-09-16 14:20	2026-09-16 14:20	SNXX	SNXX261002P00010000	put	10.0000	2026-10-02	0.2500	0.2500	0.3500	13.3250	25000.00	0.00	25000.00	1000	10	1010	210	4.80952380952381	1.33416016563164	1.33416016563164	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-09-16T18:26:46.257544Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
39b34747-d985-4b00-8763-1141cd4e773b	2026-09-16 09:35	2026-09-16 09:35	2026-09-16 09:35	SNXX	SNXX260918P00013000	put	13.0000	2026-09-18	0.3000	0.3000	0.5500	13.4410	30000.00	0.00	30000.00	1000	12	1000	1122	0.89126559714795	1.25647983576876	1.25647983576876	false	false	false	true
c1f15edc-0996-436f-a50c-b4030f7c6e38	2026-09-15 14:45	2026-09-15 14:45	2026-09-15 14:45	SNXX	SNXX260918C00013000	call	13.0000	2026-09-18	0.7000	0.7000	0.7500	13.0450	31640.00	0.00	31640.00	452	26	966	308	3.13636363636364	1.43460597692641	1.43460597692641	false	false	false	true
0c74d35f-f4a3-4538-a281-637d8b48a333	2026-09-15 12:09	2026-09-15 12:09	2026-09-15 12:09	SNXX	SNXX261002P00014000	put	14.0000	2026-10-02	2.0100	2.0000	2.2000	13.2000	16281.00	0.00	16281.00	81	6	104	203	0.512315270935961	1.367042891432	1.367042891432	false	false	false	true
c49fc0ea-3988-4f81-8c38-2589c0c7358e	2026-09-15 10:39	2026-09-15 10:39	2026-09-15 10:39	SNXX	SNXX260918C00015000	call	15.0000	2026-09-18	0.3000	0.3000	0.3500	13.7547	22500.00	0.00	22500.00	750	16	929	2998	0.309873248832555	1.4746437196626	1.4746437196626	false	false	false	true
ef7f829b-2c00-4289-a2a8-1c1f3d49b89e	2026-09-15 09:36	2026-09-15 09:36	2026-09-15 09:36	SNXX	SNXX260918C00013750	call	13.7500	2026-09-18	0.7500	0.7500	1.4000	13.9400	15000.00	0.00	15000.00	200	6	200	408	0.490196078431373	1.29531710389042	1.29531710389042	false	false	false	true
d8517c60-0509-4b7e-b495-dbb21af5d09d	2026-09-14 13:07	2026-09-14 13:07	2026-09-14 13:07	SNXX	SNXX270115C00011880	call	11.8800	2027-01-15	5.1000	4.8000	5.2000	13.9050	102000.00	102000.00	0.00	200	7	200	1032	0.193798449612403	1.35797324092615	1.35797324092615	false	false	false	true
79d473e4-0b7b-446a-8ff1-365b91d4514f	2026-09-14 11:14	2026-09-14 11:14	2026-09-14 11:14	SNXX	SNXX260918C00013500	call	13.5000	2026-09-18	0.7500	0.7500	0.8000	13.3420	30150.00	0.00	30150.00	402	13	896	129	6.94573643410853	1.47163990582823	1.47163990582823	false	false	false	true
7fb6b30d-1839-48fc-a0e6-c8259af4d971	2026-09-14 10:23	2026-09-14 10:23	2026-09-14 10:23	SNXX	SNXX260925C00016000	call	16.0000	2026-09-25	0.6000	0.6000	0.7000	13.0000	120214.00	0.00	120214.00	2000	18	4087	244	16.75	1.41250704981617	1.40074675417889	false	false	false	true
fcfb996e-acff-48bf-934b-9503aadaab2b	2026-09-14 10:22	2026-09-14 10:22	2026-09-14 10:22	SNXX	SNXX260925C00016000	call	16.0000	2026-09-25	0.6000	0.6000	0.7000	13.0000	120394.00	0.00	120394.00	2000	12	2087	244	8.55327868852459	1.41436243758407	1.41436243758407	false	false	false	true
307d45f5-bee0-4612-93d7-6efa8d14ce69	2026-09-14 10:15	2026-09-14 10:15	2026-09-14 10:15	SNXX	SNXX260918C00013750	call	13.7500	2026-09-18	1.0500	0.9500	1.0500	13.0000	21000.00	21000.00	0.00	200	5	289	131	2.20610687022901	1.74560445991388	1.74560445991388	false	false	false	true
c6c7ce01-d670-4d67-9ff8-9087f10757ca	2026-09-14 09:40	2026-09-14 09:40	2026-09-14 09:40	SNXX	SNXX270319C00015000	call	15.0000	2027-03-19	4.5000	4.4000	5.0000	12.0000	22500.00	18000.00	4500.00	50	5	105	1236	0.0849514563106796	1.41465291200089	1.41465291200089	false	false	false
10d87d9a-07ac-4119-a1ae-3486ad4e8fa1	2026-09-11 11:21	2026-09-11 11:20	2026-09-11 11:20	SNXX	SNXX261002C00019000	call	19.0000	2026-10-02	0.8500	0.8500	0.9500	15.1900	17000.00	0.00	17000.00	200	7	224	619	0.361873990306947	1.38883502602362	1.38883502602362	false	false	false	true
1fb34c9c-dd02-466d-9a1d-2103b70e3718	2026-09-11 11:08	2026-09-11 11:08	2026-09-11 11:08	SNXX	SNXX260918C00013500	call	13.5000	2026-09-18	2.3000	2.1000	2.3000	15.3300	10120.00	10120.00	0.00	44	6	65	68	0.955882352941177	1.45398868470328	1.45398868470328	false	false	false	true
e16589fb-7aa6-4d20-b624-cf0cee5a70fa	2026-09-11 11:05	2026-09-11 11:05	2026-09-11 11:05	SNXX	SNXX261009C00020000	call	20.0000	2026-10-09	1.0200	1.0000	1.2000	15.3801	16500.00	0.00	16500.00	162	5	265	184	1.44021739130435	1.39309603043962	1.41284741186298	false	false	false	true
2c550674-3a38-4462-bd16-28264004321c	2026-09-11 10:07	2026-09-11 10:07	2026-09-11 10:07	SNXX	SNXX261218C00021880	call	21.8800	2026-12-18	2.6700	2.4500	3.3000	14.9800	53487.00	0.00	53487.00	200	8	200	363	0.550964187327824	1.47453552356128	1.47453552356128	false	false	false	true
1bdbee81-7467-4709-a2e0-58bd3a7702ae	2026-09-10 11:49	2026-09-10 11:48	2026-09-10 11:48	SNXX	SNXX261218C00020000	call	20.0000	2026-12-18	3.8000	3.8000	4.0000	16.4300	33820.00	0.00	33820.00	89	6	114	1715	0.0664723032069971	1.44872812206464	1.44872812206464	false	false	false	true
c477742a-b4a5-4b32-a04c-e40847c21c3c	2026-09-10 10:26	2026-09-10 10:26	2026-09-10 10:26	SNXX	SNXX260911C00018000	call	18.0000	2026-09-11	0.1500	0.1500	0.2000	16.6650	12000.00	0.00	12000.00	800	6	6488	1862	3.484425349087	1.639239107249	1.639239107249	false	false	false	true
78b03982-04db-4074-a7cf-7dcd78197639	2026-09-10 10:26	2026-09-10 10:25	2026-09-10 10:25	SNXX	SNXX260911C00018000	call	18.0000	2026-09-11	0.1500	0.1500	0.2000	16.6697	12000.00	0.00	12000.00	800	5	5688	1862	3.05477980665951	1.63541575299044	1.63541575299044	false	false	false	true
887c6f2b-8739-47a8-afc1-3a954baba2f9	2026-09-10 10:25	2026-09-10 10:25	2026-09-10 10:25	SNXX	SNXX260911C00018000	call	18.0000	2026-09-11	0.1500	0.1500	0.2000	16.7099	12001.00	0.00	12001.00	800	13	4888	1862	2.62513426423201	1.60266142212406	1.60266142212406	false	false	false	true
c189c875-9cee-482d-aa47-a78f25d99148	2026-09-09 10:08	2026-09-09 10:08	2026-09-09 10:08	SNXX	SNXX260911C00018000	call	18.0000	2026-09-11	1.3000	1.3000	1.3500	18.5499	11310.00	0.00	11310.00	87	5	1887	1655	1.14018126888218	1.85260574070336	1.85260574070336	false	false	false	true
e8a08e3f-6494-459e-a06b-1216c928a9fb	2026-09-09 09:58	2026-09-09 09:58	2026-09-09 09:58	SNXX	SNXX260911C00018000	call	18.0000	2026-09-11	1.1000	1.1000	1.1500	18.1000	14080.00	0.00	14080.00	128	10	1152	1655	0.69607250755287	1.9667378336934	1.9667378336934	false	false	false	true
89cdf14c-0d72-4ba4-95f1-823ca6389349	2026-09-09 09:55	2026-09-09 09:55	2026-09-09 09:55	SNXX	SNXX260911C00018000	call	18.0000	2026-09-11	1.1000	1.0500	1.1500	18.0900	16170.00	110.00	16060.00	147	12	663	1655	0.400604229607251	1.95132628571254	1.97698018652893	false	false	false
7d2f4a6c-729f-4ac5-a590-5ca33403cd8e	2026-09-08 14:39	2026-09-08 14:39	2026-09-08 14:39	SNXX	SNXX260911P00017000	put	17.0000	2026-09-11	0.5500	0.5000	0.5500	18.5250	16335.00	16335.00	0.00	297	33	997	674	1.47922848664688	1.80563522424703	1.80563522424703	false	false	false	true
010bb639-179a-45c5-8e95-43c30faac3dc	2026-09-08 13:37	2026-09-08 13:36	2026-09-08 13:36	SNXX	SNXX261218C00020000	call	20.0000	2026-12-18	5.4000	5.4000	5.6000	18.2450	37800.00	0.00	37800.00	70	7	376	1785	0.210644257703081	1.58356166651434	1.58356166651434	false	false	false	true
69f717ce-751e-4429-ab07-217c11897f77	2026-09-08 11:34	2026-09-08 11:34	2026-09-08 11:34	SNXX	SNXX260911P00018000	put	18.0000	2026-09-11	0.9500	0.9500	1.0000	18.4400	32775.00	0.00	32775.00	345	6	889	54	16.462962962963	1.76129549125531	1.76129549125531	false	false	false	true
eeabaf39-615e-4327-828a-fa72d316ec76	2026-09-08 11:18	2026-09-08 11:18	2026-09-08 11:18	SNXX	SNXX260911C00018000	call	18.0000	2026-09-11	1.4000	1.2500	1.4500	18.4350	42838.00	42838.00	0.00	306	6	2512	897	2.80044593088071	1.77264436620449	1.77264436620449	false	false	false	true
ec57f3c9-c7f5-4f04-b639-d4212fb05bcd	2026-09-08 10:03	2026-09-08 10:03	2026-09-08 10:03	SNXX	SNXX260911C00018000	call	18.0000	2026-09-11	1.3500	1.3000	1.3500	18.1999	19035.00	19035.00	0.00	141	6	1144	897	1.27536231884058	1.90380780075711	1.90380780075711	false	false	false	true
8329dbb2-ae01-47de-8064-05a9df938f37	2026-09-04 15:55	2026-09-04 15:55	2026-09-04 15:55	SNXX	SNXX260911C00019000	call	19.0000	2026-09-11	0.7500	0.6500	0.7500	17.2850	16460.00	16460.00	0.00	220	22	2161	356	6.07022471910112	1.44459026162434	1.44459026162434	true	false	false	true
d7623cd2-7c41-4dc9-b758-27f43d4aed6e	2026-09-04 15:41	2026-09-04 15:41	2026-09-04 15:41	SNXX	SNXX260911C00016000	call	16.0000	2026-09-11	1.8500	1.7500	1.8500	17.0500	15341.00	15341.00	0.00	83	7	1814	3184	0.569723618090452	1.35822922037685	1.35822922037685	false	false	false	true
698bd1ce-a3ed-4b38-9294-126d4802d0c1	2026-09-04 13:09	2026-09-04 13:09	2026-09-04 13:09	SNXX	SNXX260918C00022000	call	22.0000	2026-09-18	0.6100	0.6000	0.7000	17.0400	42700.00	0.00	42700.00	700	5	766	45	17.0222222222222	1.50504615929622	1.50504615929622	false	false	false	true
7472442f-09f5-4a08-a70b-e232fe2e10a4	2026-09-04 13:04	2026-09-04 13:04	2026-09-04 13:04	SNXX	SNXX260911P00015500	put	15.5000	2026-09-11	0.6300	0.5500	0.6500	17.1401	55440.00	55440.00	0.00	880	5	1967	71	27.7042253521127	1.43614694433739	1.43614694433739	false	false	false	true
04553407-5a55-4e3a-b06e-379152c70333	2026-09-04 13:01	2026-09-04 13:01	2026-09-04 13:01	SNXX	SNXX260911P00015500	put	15.5000	2026-09-11	0.6000	0.5500	0.6500	17.2001	52800.00	180.00	52620.00	880	5	1087	71	15.3098591549296	1.41998383387282	1.41832406372713	false	false	false	true
aa4004fa-f5c1-4e33-980b-353cf8f29148	2026-09-04 12:57	2026-09-04 12:57	2026-09-04 12:57	SNXX	SNXX260911C00016000	call	16.0000	2026-09-11	2.0000	1.9000	2.0000	17.2350	13194.00	13194.00	0.00	66	9	1413	3184	0.443781407035176	1.39895056137752	1.38713377045298	false	false	false	true
89c044bf-6ce3-4f72-82ee-43fb3620a20e	2026-09-04 12:42	2026-09-04 12:42	2026-09-04 12:42	SNXX	SNXX260911C00015000	call	15.0000	2026-09-11	2.3500	2.3000	2.4000	16.9000	28200.00	0.00	24910.00	120	5	848	1035	0.819323671497585	1.31525914471284	1.30977010936738	false	false	false	true
29830be7-46e0-4e1a-bcee-96aa3beac063	2026-09-04 11:47	2026-09-04 11:47	2026-09-04 11:47	SNXX	SNXX260925P00012500	put	12.5000	2026-09-25	0.5200	0.5000	0.6500	16.3617	23586.00	0.00	23586.00	450	5	507	87	5.82758620689655	1.36517484393483	1.36517484393483	false	false	false	true
ac10dfcc-0de7-4914-8704-2063ef063ae0	2026-09-04 11:43	2026-09-04 11:43	2026-09-04 11:43	SNXX	SNXX260918P00014000	put	14.0000	2026-09-18	0.6600	0.6000	0.7000	16.4650	32922.00	27852.00	0.00	500	5	585	76	7.69736842105263	1.35735072479014	1.35735072479014	false	false	false	true
c4c56914-3f5d-495a-b4ba-c38e920ae45b	2026-09-04 11:02	2026-09-04 11:02	2026-09-04 11:02	SNXX	SNXX260904C00015000	call	15.0000	2026-09-04	1.5000	1.5000	1.5500	16.4750	15750.00	0.00	9900.00	105	8	1807	3620	0.499171270718232	2.54133156997001	2.54133156997001	false	false	false	true
141ae7c7-9ca2-47a5-834c-4ff73bbf9b74	2026-09-04 11:02	2026-09-04 11:02	2026-09-04 11:02	SNXX	SNXX261218C00030000	call	30.0000	2026-12-18	2.3000	2.2500	2.4000	16.5050	34500.00	6900.00	27600.00	150	5	283	1412	0.20042492917847	1.49589324061121	1.49589324061121	false	false	false	true
68998caf-d42c-4328-a861-f334460edc79	2026-09-04 10:33	2026-09-04 10:33	2026-09-04 10:33	SNXX	SNXX260911P00016000	put	16.0000	2026-09-11	1.0500	1.0500	1.1000	16.2000	22575.00	0.00	22575.00	215	7	304	93	3.26881720430108	1.29578107332008	1.29824702522733	false	false	false	true
f3208b1b-43d8-4d79-8e06-2757d8c9a347	2026-09-04 10:10	2026-09-04 10:10	2026-09-04 10:10	SNXX	SNXX260918C00016000	call	16.0000	2026-09-18	1.7000	1.5000	1.7000	15.9250	34000.00	34000.00	0.00	200	19	240	333	0.720720720720721	1.38892058309778	1.38892058309778	false	false	false	true
736aed27-d6e5-46b5-8f69-ed3e7937d2c4	2026-09-04 10:05	2026-09-04 10:05	2026-09-04 10:05	SNXX	SNXX260904C00016000	call	16.0000	2026-09-04	0.3500	0.3000	0.4000	15.9200	12775.00	0.00	2275.00	365	5	2183	4617	0.472817847086853	2.34950555660714	2.34950555660714	false	false	false	true
ff4fc9d0-5f52-4760-9d71-82c06357912b	2026-09-04 09:42	2026-09-04 09:42	2026-09-04 09:42	SNXX	SNXX261016C00019000	call	19.0000	2026-10-16	2.0000	1.2000	2.0000	15.6050	17600.00	17600.00	0.00	88	7	90	43	2.09302325581395	1.47615862889195	1.47615862889195	false	false	false	true
2ac54cf8-186a-4d06-b11e-e6ef7ceee85b	2026-09-04 09:42	2026-09-04 09:42	2026-09-04 09:42	SNXX	SNXX260918C00015000	call	15.0000	2026-09-18	1.8000	1.8000	1.9500	15.6050	15840.00	0.00	15840.00	88	7	331	2920	0.113356164383562	1.22949063208393	1.22949063208393	false	false	false	true
27cf0953-c16e-40ac-8735-c194767c7ac1	2026-09-03 15:05	2026-09-03 15:05	2026-09-03 15:05	SNXX	SNXX260904C00014500	call	14.5000	2026-09-04	0.2500	0.2500	0.3000	14.0801	10250.00	0.00	10250.00	410	9	1424	944	1.50847457627119	1.43140016306937	1.43140016306937	false	false	false	true
3e3d8543-0852-4461-a13a-4acb0c9302f3	2026-09-03 12:37	2026-09-03 12:37	2026-09-03 12:37	SNXX	SNXX260911C00013000	call	13.0000	2026-09-11	1.4000	1.4000	1.4500	13.7717	14000.00	0.00	14000.00	100	5	212	437	0.48512585812357	1.21457226978443	1.21457226978443	false	false	false	true
43bbfb1a-956f-4532-8830-54ea4ec01640	2026-09-02 10:40	2026-09-02 10:40	2026-09-02 10:40	SNXX	SNXX260904C00013000	call	13.0000	2026-09-04	1.1500	1.1500	1.3000	13.8600	15525.00	0.00	15525.00	135	5	247	1402	0.176176890156919	1.58096461985758	1.58096461985758	false	false	false	true
1725a8bd-0862-422f-b400-d800c638838b	2026-09-01 13:48	2026-09-01 13:48	2026-09-01 13:48	SNXX	SNXX260904C00015000	call	15.0000	2026-09-04	0.4000	0.4000	0.4500	14.0900	40000.00	0.00	40000.00	1000	15	2752	2822	0.975194897236003	1.46067357632275	1.46433044230674	false	false	false
a3d963b8-6f20-4afd-9c83-992c22a84d79	2026-09-01 11:21	2026-09-01 11:20	2026-09-01 11:20	SNXX	SNXX260918C00015000	call	15.0000	2026-09-18	1.2900	1.1500	1.3000	14.0850	25736.00	25736.00	0.00	200	5	297	2792	0.106375358166189	1.37035654853631	1.3455700641908	false	false	false	true
cf346e61-843f-492d-97a7-f6a1281516ed	2026-09-01 10:45	2026-09-01 10:45	2026-09-01 10:45	SNXX	SNXX260904P00013500	put	13.5000	2026-09-04	0.5000	0.5000	0.6000	13.9850	10000.00	0.00	10000.00	200	10	311	247	1.25910931174089	1.44652498551059	1.44652498551059	false	false	false	true