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:option_symbol = SPX261218C08000000×

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

3ac4a65c-05f4-49fa-a9c9-d26c31137b37	2026-09-22 15:58	2026-09-22 15:58	2026-09-22 15:58	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	125.5000	121.1000	122.0000	7767.2100	6902500.00	0.00	0.00	550	6	11265	285523	0.0394539143956879	0.126129130790836	0.126129130790836	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
55a7023a-5d83-468c-b0d6-c4f39d707fea	2026-09-22 15:56	2026-09-22 15:56	2026-09-22 15:56	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	125.3000	121.6000	122.5000	7768.1600	5638500.00	0.00	0.00	450	6	10715	285523	0.0375276247447666	0.125738103299305	0.125738103299305	false	false	false	true
5398f09b-02fe-4f01-a94c-c9346135ebbf	2026-09-22 11:15	2026-09-22 11:15	2026-09-22 11:15	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	119.5500	119.7000	120.5000	7766.2300	8081580.00	0.00	0.00	676	6	1656	285523	0.00579988302168302	0.122282352957086	0.122282352957086	false	false	false	true
7b7fa8e0-45bd-4fdf-8be6-a80e9f1202ba	2026-09-21 16:09	2026-09-21 16:08	2026-09-21 16:08	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	124.2400	123.5000	124.3000	7745.0000	12424000.00	0.00	0.00	1000	8	6115	280174	0.0218257225866783	0.125128116175646	0.125128116175646	false	false	false	true
9fad0802-5359-4e57-b8d9-8cc51fa38987	2026-09-21 10:19	2026-09-21 10:19	2026-09-21 10:19	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	99.1200	101.2000	102.0000	7714.4200	1239000.00	0.00	0.00	125	7	209	280174	0.00074596500745965	0.120258108163585	0.120258108163585	false	false	false	true
dbc1e536-e47b-4d1e-9177-e78672561a8c	2026-09-18 14:44	2026-09-18 14:44	2026-09-18 14:44	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	74.6500	74.6000	75.3000	7635.1600	4620835.00	0.00	4620835.00	619	2	18666	268395	0.0695467501257475	0.1172631069668	0.1172631069668	false	true	false	true
173b467e-477e-4494-b332-4a052c86d991	2026-09-17 16:22	2026-09-17 16:16	2026-09-17 16:16	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	78.9800	78.0000	78.7000	7615.0000	16980700.00	0.00	0.00	2150	12	8744	259519	0.0336931014684859	0.119174947717355	0.119174947717355	false	false	false	true
6ff58c46-d532-4862-aac6-a6a3e4ba1b91	2026-09-15 10:33	2026-09-15 10:33	2026-09-15 10:33	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	71.0000	70.7000	71.2000	7584.8800	170400.00	170400.00	0.00	24	6	125	249957	0.000500086014794545	0.122752347275321	0.122752347275321	false	false	false	true
8c439122-884f-4879-aa24-4929ac94f476	2026-09-14 16:08	2026-09-14 16:08	2026-09-14 16:08	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	81.7800	81.6000	82.4000	7600.0000	8178000.00	0.00	0.00	1000	8	34575	224345	0.154115313468096	0.123050203393321	0.123050203393321	false	false	false	true	false
49421c80-1fa1-4470-a26e-63c0135b143d	2026-09-14 15:48	2026-09-14 15:48	2026-09-14 15:48	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	84.3000	83.9000	84.4000	7610.0000	143310.00	118020.00	25290.00	17	6	33559	224345	0.149586574249482	0.122874978325233	0.12288586602742	false	false	false	true
28618525-4a98-4042-b142-b730c6e61e06	2026-09-14 15:48	2026-09-14 15:48	2026-09-14 15:48	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	84.3000	84.0000	84.4000	7610.0000	177030.00	118020.00	59010.00	21	6	33482	224345	0.149243352871693	0.122864090352851	0.122864090352851	false	false	false	true
1d8f48ad-f561-4fe0-8451-0709f7653a8d	2026-09-14 15:48	2026-09-14 15:48	2026-09-14 15:48	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	84.3000	84.0000	84.4000	7610.0000	177030.00	151740.00	25290.00	21	6	33514	224345	0.149385990327398	0.122868445574231	0.122868445574231	false	false	false	true
a8c7b8e0-1854-4e0a-8066-6101e5e1044a	2026-09-14 15:48	2026-09-14 15:48	2026-09-14 15:48	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	84.3000	84.0000	84.5000	7610.0000	185460.00	151740.00	33720.00	22	6	33458	224345	0.149136374779915	0.12285973508823	0.12285973508823	false	false	false	true
3708c0ed-9b14-45ba-9408-0fe80124bd20	2026-09-11 15:49	2026-09-11 15:49	2026-09-11 15:49	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	95.6000	95.3000	96.0000	7661.6400	219880.00	95600.00	124280.00	23	7	3831	224214	0.0170863550001338	0.121744080983119	0.121744080983119	false	false	false	true
1f002b05-f363-4f24-92e1-b7a96931f43e	2026-09-11 15:35	2026-09-11 15:35	2026-09-11 15:35	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	96.7900	96.2000	96.9000	7663.5700	11130850.00	0.00	0.00	1150	11	3792	224214	0.016912414033022	0.122152622534795	0.122152622534795	false	false	false	true
e1617138-4b4c-42cc-940e-9b3978da2600	2026-09-11 10:55	2026-09-11 10:55	2026-09-11 10:55	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	94.2600	94.0000	94.5000	7651.8000	150820.00	94300.00	56520.00	16	5	2258	224214	0.0100707359932921	0.122941805312937	0.123013206396482	false	false	false	true
8a654ba1-401f-403f-87ef-0923f75bca84	2026-09-11 10:35	2026-09-11 10:35	2026-09-11 10:35	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	97.5000	97.1000	97.7000	7659.7400	156000.00	126750.00	29250.00	16	5	2110	224214	0.00941065232322692	0.123514042924007	0.123514042924007	false	false	false	true
9e9ebbd8-fd21-47b7-b3b7-2fade30a86f6	2026-09-11 09:37	2026-09-11 09:37	2026-09-11 09:37	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	101.2600	100.9000	101.8000	7670.6000	192400.00	0.00	192400.00	19	6	40	224214	0.000178400991909515	0.123659976441069	0.123729818717742	false	false	false	true
16cadce7-c817-4e74-89fc-23839b093568	2026-09-03 14:09	2026-09-03 14:09	2026-09-03 14:09	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	142.3400	141.7000	142.5000	7754.2300	6391066.00	0.00	0.00	449	6	13907	165748	0.0839044815020392	0.126617285178244	0.126617285178244	false	false	false	true
bf2ff8ed-1a59-4755-afff-e4e431d96ac8	2026-09-03 11:48	2026-09-03 11:48	2026-09-03 11:48	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	139.0000	138.4000	139.3000	7743.3800	69500000.00	0.00	0.00	5000	6	11137	165748	0.0671923643120882	0.127197681827369	0.127180710009689	false	false	false	true
131ddda6-a09e-4d30-bc43-c559da1a435e	2026-09-03 09:39	2026-09-03 09:39	2026-09-03 09:39	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	124.1000	123.3000	125.5000	7712.6900	2109700.00	1414740.00	694960.00	170	13	305	165748	0.00184014286748558	0.125036699358059	0.125036699358059	false	false	false	true
dc551f13-7b1c-409b-833f-53924192545b	2026-09-03 09:39	2026-09-03 09:39	2026-09-03 09:39	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	123.9000	123.9000	124.0000	7713.6700	1003590.00	0.00	1003590.00	81	6	120	165748	0.000723990636387769	0.124680352194914	0.124680352194914	false	false	false	true