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

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

eb147ce9-9aee-4786-a4e5-26c19954f011	2026-09-18 14:16	2026-09-18 14:16	2026-09-18 14:16	SPX	SPX270917P06100000	put	6100.0000	2027-09-17	116.6000	116.6000	116.8000	7630.2200	1644060.00	0.00	1644060.00	141	6	331	1016	0.325787401574803	0.24760735215724	0.24760735215724	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-18T18:22:45.408265Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
851be926-313d-4df7-bad1-138fb3975e53	2026-09-18 14:01	2026-09-18 14:01	2026-09-18 14:01	SPX	SPX270319C07650000	call	7650.0000	2027-03-19	392.8000	392.6000	393.3000	7629.1900	196400.00	0.00	196400.00	5	5	560	3615	0.154910096818811	0.147992432027211	0.147992432027211	false	false	false	true	false
de4a3b3c-83ce-483c-abf9-4e535e40a5b0	2026-09-18 13:49	2026-09-18 13:49	2026-09-18 13:49	SPX	SPX261120P07340000	put	7340.0000	2026-11-20	79.8000	79.8000	80.4000	7627.0600	119700.00	0.00	119700.00	15	6	84	411	0.204379562043796	0.16717936076243	0.16717936076243	false	false	false	true	false
5c318f6f-ab83-4590-9206-ff9ea9bb09a9	2026-09-18 13:49	2026-09-18 13:49	2026-09-18 13:49	SPX	SPX261120P07335000	put	7335.0000	2026-11-20	79.0000	79.0000	79.5000	7627.2100	118500.00	0.00	118500.00	15	6	148	1593	0.0929064657878217	0.167741679153651	0.167741679153651	false	false	false	true	false
f19714ad-53a7-4850-a5a0-d41def6d1f50	2026-09-18 13:43	2026-09-18 13:43	2026-09-18 13:43	SPX	SPX261218P07690000	put	7690.0000	2026-12-18	209.0000	208.6000	209.3000	7626.8200	1421200.00	0.00	0.00	68	7	4101	5461	0.750961362387841	0.143446951406983	0.143446951406983	false	false	false	true	false
9a85f62c-e909-422a-aae3-58b4a3da2507	2026-09-18 13:43	2026-09-18 13:43	2026-09-18 13:43	SPX	SPX261218C07690000	call	7690.0000	2026-12-18	211.0000	211.0000	211.7000	7626.8200	1434800.00	0.00	0.00	68	7	4099	5376	0.762462797619048	0.133225783284118	0.133225783284118	false	false	false	true	false
933df9fd-f9bd-4488-9b4e-f26443b966d6	2026-09-18 13:41	2026-09-18 13:41	2026-09-18 13:41	SPX	SPX261120P07000000	put	7000.0000	2026-11-20	42.5000	42.1000	42.5000	7626.8600	212500.00	212500.00	0.00	50	5	5774	70338	0.0820893400437886	0.203749836240652	0.203749836240652	false	false	false	true	false
2c23975c-4013-462c-af6a-bcb0326c1bee	2026-09-18 13:25	2026-09-18 13:24	2026-09-18 13:24	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	110.0000	109.8000	110.3000	7625.2500	2057000.00	0.00	2057000.00	187	6	6496	151	43.0198675496689	0.119436069421715	0.119436069421715	false	true	false	true	false
f834ea7e-583f-4e56-bff1-43b9b6852b30	2026-09-18 13:06	2026-09-18 13:05	2026-09-18 13:05	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	109.5000	109.6000	110.1000	7625.0000	2003850.00	0.00	2003850.00	183	3	5606	151	37.1258278145695	0.118999813395216	0.118999813395216	false	true	false	true	false
bd91a6de-353c-4d54-97d5-99d61dc2e00d	2026-09-18 13:02	2026-09-18 13:02	2026-09-18 13:02	SPX	SPX261218P07690000	put	7690.0000	2026-12-18	211.0000	210.8000	211.6000	7623.2000	8102400.00	0.00	0.00	384	10	3681	5461	0.674052371360557	0.143633776924328	0.143633776924328	false	false	false	true	false
b9edca64-83bd-42d8-b123-7ae1b05d4c47	2026-09-18 13:02	2026-09-18 13:02	2026-09-18 13:02	SPX	SPX261218C07900000	call	7900.0000	2026-12-18	107.1800	106.5000	107.2000	7623.2000	12861600.00	0.00	0.00	1200	10	2804	25015	0.112092744353388	0.122589731212141	0.122589731212141	false	false	false	true	false
44a5d70b-4883-4a3f-bdcc-6975e0cde9e8	2026-09-18 13:02	2026-09-18 13:02	2026-09-18 13:02	SPX	SPX261218C07690000	call	7690.0000	2026-12-18	211.0000	209.9000	210.7000	7623.2000	8102400.00	0.00	0.00	384	8	3679	5376	0.684337797619048	0.134481063520429	0.134481063520429	false	false	false	true	false
1b4290fa-e931-4749-86bc-9eccee5acd70	2026-09-18 13:00	2026-09-18 12:59	2026-09-18 12:59	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	109.5900	109.2000	109.8000	7623.9800	109590.00	98630.00	0.00	10	5	5273	151	34.9205298013245	0.119649503118482	0.119768635740883	false	false	false	true	false
9ddf3633-4b1d-438d-9514-7de5e4cc9e17	2026-09-18 12:59	2026-09-18 12:59	2026-09-18 12:59	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	109.5000	109.2000	109.7000	7623.8900	2003850.00	2003850.00	0.00	183	3	5263	151	34.8543046357616	0.119706720807247	0.119706720807247	false	true	false	true	false
58d3614f-9ee7-496f-b17d-a5887770d7d8	2026-09-18 12:58	2026-09-18 12:58	2026-09-18 12:58	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	109.2000	109.3000	109.8000	7624.0600	3822000.00	0.00	3822000.00	350	6	5057	151	33.4900662251656	0.119241220821418	0.119241220821418	false	true	false	true	false
ad17de87-169e-48e2-b3f0-e1a958376ccd	2026-09-18 12:53	2026-09-18 12:53	2026-09-18 12:53	SPX	SPX261218P06400000	put	6400.0000	2026-12-18	31.1000	30.9000	31.2000	7624.9800	419850.00	320330.00	99520.00	135	9	325	19867	0.0163587859264106	0.260422212561255	0.260422212561255	false	false	false	true	false
531b1abe-5410-4760-bf6f-59a34578b898	2026-09-18 12:49	2026-09-18 12:49	2026-09-18 12:49	SPX	SPX270917P05100000	put	5100.0000	2027-09-17	56.9000	56.6000	57.2000	7620.5900	176390.00	79660.00	17070.00	31	5	181	382	0.473821989528796	0.302728982279527	0.302727697424946	false	false	false	true	false
482a1810-149b-47c6-bc1c-0a143e06b2b1	2026-09-18 12:42	2026-09-18 12:42	2026-09-18 12:42	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	106.5000	107.2000	107.8000	7620.5800	1948950.00	0.00	1948950.00	183	4	4093	151	27.1059602649007	0.118227397061116	0.118227397061116	false	true	false	true	false
516635fa-10ad-46fe-a849-9e578db21ac0	2026-09-18 12:39	2026-09-18 12:39	2026-09-18 12:39	SPX	SPX261218P06900000	put	6900.0000	2026-12-18	58.9000	58.9000	59.3000	7619.1900	294500.00	0.00	294500.00	50	6	100	33830	0.00295595625184747	0.211543377646498	0.211543377646498	true	false	false	true	false
1e7d2f86-5745-491f-84d0-bb6db436e3b2	2026-09-18 12:31	2026-09-18 12:31	2026-09-18 12:31	SPX	SPX261016C07730000	call	7730.0000	2026-10-16	55.0000	54.9000	55.0000	7618.7800	313500.00	313500.00	0.00	57	5	1115	1909	0.584075432163436	0.109021707325687	0.109021707325687	false	false	false	true	false
5f79b53b-2c12-4a6b-b9d3-23ef70acadfb	2026-09-18 12:28	2026-09-18 12:27	2026-09-18 12:27	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	104.0000	104.4000	104.8000	7614.5600	1903200.00	0.00	1903200.00	183	4	3478	151	23.0331125827815	0.119004404135247	0.119004404135247	false	true	false	true	false
3485e373-702c-4440-a409-34c896c7fc65	2026-09-18 12:21	2026-09-18 12:21	2026-09-18 12:21	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	107.0000	107.0000	107.6000	7600.0000	4280000.00	0.00	4280000.00	400	7	3130	151	20.7284768211921	0.118633854839416	0.118633854839416	false	true	false	true	false
017304a7-7773-4de6-abd7-72238042c092	2026-09-18 12:17	2026-09-18 12:17	2026-09-18 12:17	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	107.5000	107.0000	107.6000	7600.0000	1967250.00	1967250.00	0.00	183	2	2603	151	17.2384105960265	0.119373986394938	0.119373986394938	false	true	false	true	false
c54f8630-28ce-4ca3-9ff6-6fecc44fe1bd	2026-09-18 12:05	2026-09-18 12:05	2026-09-18 12:05	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	106.5000	106.7000	107.2000	7600.0000	1948950.00	0.00	1948950.00	183	10	2098	151	13.8940397350993	0.118742743659754	0.118742743659754	false	true	false	true	false
777ff9ee-3335-46bd-a053-0512fc1110be	2026-09-18 12:01	2026-09-18 12:01	2026-09-18 12:01	SPX	SPX261016P07100000	put	7100.0000	2026-10-16	16.8000	16.6000	17.0000	7618.9100	127680.00	18480.00	0.00	76	5	78	18984	0.00410872313527181	0.19811854311343	0.19811854311343	false	false	false	true	false
2e759806-849b-46d2-be21-0d0067132a0a	2026-09-18 11:59	2026-09-18 11:59	2026-09-18 11:59	SPX	SPX270617P07800000	put	7800.0000	2027-06-17	390.2000	390.2000	391.2000	7619.5200	195100.00	0.00	195100.00	5	5	356	8227	0.0432721526680442	0.162786182807322	0.162786182807322	false	false	false	true	false
6043bef2-00fc-45ac-9ff6-510368b03a49	2026-09-18 11:56	2026-09-18 11:56	2026-09-18 11:56	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	107.3000	107.9000	108.4000	7621.7600	1963590.00	0.00	1963590.00	183	8	1699	151	11.2516556291391	0.118436025867298	0.118436025867298	false	true	false	true	false
8ec904da-d4c6-4eff-9b7e-d43ff46f2151	2026-09-18 11:54	2026-09-18 11:54	2026-09-18 11:54	SPX	SPX261016P07000000	put	7000.0000	2026-10-16	13.1000	12.7000	13.1000	7620.0300	131000.00	131000.00	0.00	100	25	8013	182138	0.0439941143528533	0.213798071576179	0.213798071576179	false	false	false	true	false
bd6432d7-7cbb-4364-b265-179ea8d11ed3	2026-09-18 11:48	2026-09-18 11:48	2026-09-18 11:48	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	108.4000	108.1000	108.7000	7621.6300	1214080.00	1105680.00	0.00	112	5	1297	151	8.58940397350993	0.119828030154751	0.119828030154751	false	false	false	true	false
79d21e39-ec34-4adf-985a-bfaac6c5fad2	2026-09-18 11:44	2026-09-18 11:44	2026-09-18 11:44	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	109.0000	108.3000	108.9000	7622.7200	1994700.00	1994700.00	0.00	183	7	1162	151	7.6953642384106	0.119853469415515	0.119853469415515	false	true	false	true	false
97cab6a4-0e46-443e-bee1-616a6c956f27	2026-09-18 11:41	2026-09-18 11:40	2026-09-18 11:40	SPX	SPX261218P07695000	put	7695.0000	2026-12-18	212.5000	213.4000	214.1000	7621.5900	9775000.00	0.00	0.00	460	9	1580	1796	0.879732739420935	0.142462689157322	0.142462689157322	false	false	false	true	false
85bab752-3d50-4bdf-9226-304a67aaaaab	2026-09-18 11:41	2026-09-18 11:40	2026-09-18 11:40	SPX	SPX261218C07695000	call	7695.0000	2026-12-18	207.5000	205.8000	206.5000	7621.5900	9545000.00	0.00	0.00	460	9	1583	2267	0.698279664755183	0.134341423051485	0.134341423051485	false	false	false	true	false
aa158b14-0fba-43a1-a1f8-72426ba09484	2026-09-18 11:39	2026-09-18 11:39	2026-09-18 11:39	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	109.3000	108.5000	109.1000	7623.5000	3279000.00	3279000.00	0.00	300	6	818	151	5.41721854304636	0.119716222314091	0.119716222314091	false	true	false	true	false
29bb2cbf-c10f-4c7f-bf5f-cf743b6aab2f	2026-09-18 11:35	2026-09-18 11:35	2026-09-18 11:35	SPX	SPX261016C07630000	call	7630.0000	2026-10-16	110.5000	111.1000	111.5000	7628.8800	2022150.00	0.00	2022150.00	183	11	360	151	2.3841059602649	0.117700258193024	0.117700258193024	false	true	false	true	false
6848535c-8d09-4b9e-971b-d84d5a874dec	2026-09-18 11:31	2026-09-18 11:30	2026-09-18 11:30	SPX	SPX261016C07925000	call	7925.0000	2026-10-16	10.1000	10.1000	10.5000	7631.1900	109080.00	0.00	109080.00	108	10	614	2640	0.232575757575758	0.0982160679112557	0.0982160679112557	false	false	false	true	false
beb8dbf1-192c-4f0b-9a61-77052120d66c	2026-09-18 11:23	2026-09-18 11:23	2026-09-18 11:23	SPX	SPX261218P07695000	put	7695.0000	2026-12-18	212.0000	210.3000	211.1000	7629.1300	1144800.00	0.00	0.00	54	7	611	1796	0.340200445434298	0.144507660146633	0.144507660146633	false	false	false	true	false
7892cddd-39be-4c07-b9c0-bed0df8811ac	2026-09-18 11:23	2026-09-18 11:23	2026-09-18 11:23	SPX	SPX261218C07695000	call	7695.0000	2026-12-18	208.0000	209.2000	209.9000	7629.1300	1123200.00	0.00	0.00	54	6	614	2267	0.270842523158359	0.132076004858124	0.132076004858124	false	false	false	true	false
0c506510-1438-44d1-944a-03ad54f2ee60	2026-09-18 11:08	2026-09-18 11:08	2026-09-18 11:08	SPX	SPX270319C08300000	call	8300.0000	2027-03-19	95.6000	95.2000	95.7000	7628.7900	812600.00	812600.00	0.00	85	6	166	8473	0.0195916440457925	0.123565206823981	0.123565206823981	false	false	false	true	false
f6df13d4-3ffb-40a3-a523-31eafa9cac42	2026-09-18 10:57	2026-09-18 10:57	2026-09-18 10:57	SPX	SPX270319C07700000	call	7700.0000	2027-03-19	360.5000	360.1000	361.1000	7627.9100	21630000.00	0.00	0.00	600	10	600	5049	0.11883541295306	0.14555572075593	0.14555572075593	false	false	false	true	false
eed4aac2-592f-4e8f-8be7-33f4b9021039	2026-09-18 10:57	2026-09-18 10:57	2026-09-18 10:57	SPX	SPX270319P07450000	put	7450.0000	2027-03-19	214.5000	214.1000	215.0000	7627.9100	21450000.00	0.00	0.00	1000	10	1008	4121	0.244600825042465	0.1710178317373	0.1710178317373	false	false	false	true	false
d17e4f40-69ad-4234-805e-832bf45d3fec	2026-09-18 10:55	2026-09-18 10:55	2026-09-18 10:55	SPX	SPX261016C07800000	call	7800.0000	2026-10-16	33.6000	33.4000	33.9000	7628.7800	336000.00	84000.00	252000.00	100	5	538	24513	0.0219475380410394	0.103958141515207	0.103958141515207	false	false	false	true	false
5dd97e02-efb0-4cf7-bf99-9b14223a9aa7	2026-09-18 10:52	2026-09-18 10:52	2026-09-18 10:52	SPX	SPX261016C07800000	call	7800.0000	2026-10-16	33.0000	32.6000	33.3000	7627.8600	1069200.00	257400.00	811800.00	324	6	438	24513	0.0178680700036715	0.10342293097879	0.10342293097879	false	false	false	true	false
f0be9071-75d7-4000-bbaf-3d00ae9d9dd7	2026-09-18 10:42	2026-09-18 10:42	2026-09-18 10:42	SPX	SPX261218P07685000	put	7685.0000	2026-12-18	209.0000	209.3000	210.0000	7622.4400	3553000.00	0.00	0.00	170	7	1024	2941	0.348180890853451	0.143717332947118	0.143717332947118	false	false	false	true	false
a26c25eb-4c78-49a4-9ad8-0068f302df1a	2026-09-18 10:42	2026-09-18 10:42	2026-09-18 10:42	SPX	SPX261218C08100000	call	8100.0000	2026-12-18	48.3600	47.8000	48.3000	7622.4400	2418000.00	0.00	0.00	500	7	517	22929	0.022547865148938	0.116089325920118	0.116089325920118	false	false	false	true	false
4d239493-3799-46c7-8a24-b28a4983741a	2026-09-18 10:42	2026-09-18 10:42	2026-09-18 10:42	SPX	SPX261218P07100000	put	7100.0000	2026-12-18	77.7400	77.7000	78.2000	7622.4400	3887000.00	0.00	0.00	500	8	702	23723	0.0295915356405176	0.192717242632556	0.192717242632556	false	false	false	true	false
06a44533-a2f0-47ab-bf3a-970f1fa2f261	2026-09-18 10:42	2026-09-18 10:42	2026-09-18 10:42	SPX	SPX261218C07685000	call	7685.0000	2026-12-18	213.0000	211.8000	212.6000	7622.4400	3621000.00	0.00	0.00	170	8	1001	2800	0.3575	0.134435178261469	0.134435178261469	false	false	false	true	false
f1f8e7b3-5bf0-448e-af65-86ccd804c481	2026-09-18 10:39	2026-09-18 10:39	2026-09-18 10:39	SPX	SPX261016C08000000	call	8000.0000	2026-10-16	5.0000	4.5000	5.0000	7625.2400	250000.00	250000.00	0.00	500	8	956	176066	0.0054297820135631	0.101016358114062	0.101016358114062	false	false	false	true	false
edffd180-2856-4248-88e6-c891f3af9b3b	2026-09-18 10:33	2026-09-18 10:33	2026-09-18 10:33	SPX	SPX261016P06840000	put	6840.0000	2026-10-16	9.4000	9.0000	9.4000	7622.9600	108100.00	0.00	0.00	115	11	119	1014	0.117357001972387	0.240602853337592	0.240602853337592	false	false	false	true	false
e1188cd5-66e5-4c6d-81d0-c4a061ced7b7	2026-09-18 10:33	2026-09-18 10:33	2026-09-18 10:33	SPX	SPX261218P07275000	put	7275.0000	2026-12-18	101.9300	101.9000	102.5000	7622.9600	601387.00	0.00	0.00	59	11	59	5489	0.0107487702678083	0.176934288696269	0.176934288696269	false	false	false	true	false
95f5a01d-91b2-403a-b55d-8d627de91d25	2026-09-18 10:33	2026-09-18 10:33	2026-09-18 10:33	SPX	SPX261016P07440000	put	7440.0000	2026-10-16	46.8300	46.8000	47.4000	7622.9600	538545.00	0.00	0.00	115	11	116	676	0.171597633136095	0.148416739852931	0.148416739852931	false	false	false	true	false