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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = SPX×

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

6654eb9f-3153-491b-919b-fef3635d79f9	2026-09-25 16:14	2026-09-25 16:14	2026-09-25 16:14	SPX	SPX261016P07650000	put	7650.0000	2026-10-16	48.5000	48.3000	48.5000	7720.0000	417100.00	417100.00	0.00	86	5	1915	12970	0.147648419429453	0.12743407685193	0.12743407685193	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
8bdeedec-ef91-49be-b1ca-496806da35bc	2026-09-25 16:09	2026-09-25 16:09	2026-09-25 16:09	SPX	SPX261120P06200000	put	6200.0000	2026-11-20	9.0000	9.0000	9.2000	7720.0000	22500.00	0.00	22500.00	25	5	1011	6780	0.149115044247788	0.306303006019666	0.306303006019666	false	false	false	true
c2d3f151-f180-4055-a912-6f3c16594dc7	2026-09-25 16:09	2026-09-25 16:08	2026-09-25 16:08	SPX	SPX261120P06200000	put	6200.0000	2026-11-20	9.0000	9.0000	9.2000	7720.0000	22500.00	0.00	22500.00	25	6	986	6780	0.145427728613569	0.306303006019666	0.306303006019666	false	false	false	true
8e7c98b6-7bca-4981-9df5-ca6706281869	2026-09-25 16:08	2026-09-25 16:08	2026-09-25 16:08	SPX	SPX261120P06200000	put	6200.0000	2026-11-20	9.0000	9.0000	9.2000	7720.0000	22500.00	0.00	22500.00	25	7	961	6780	0.141740412979351	0.306303006019666	0.306303006019666	false	false	false	true
25297a81-ad93-4a1d-a4db-29ed68f9e660	2026-09-25 16:08	2026-09-25 16:08	2026-09-25 16:08	SPX	SPX261120P06200000	put	6200.0000	2026-11-20	9.0000	9.0000	9.2000	7720.0000	22500.00	0.00	22500.00	25	7	936	6780	0.138053097345133	0.306303006019666	0.306303006019666	false	false	false	true
e3bab4eb-c65f-4d24-b589-65834f65414d	2026-09-25 16:08	2026-09-25 16:08	2026-09-25 16:08	SPX	SPX261120P06200000	put	6200.0000	2026-11-20	9.0000	9.0000	9.2000	7720.0000	22500.00	0.00	22500.00	25	8	911	6780	0.134365781710914	0.306303006019666	0.306303006019666	false	false	false	true
b4079317-68e3-4912-9c2e-4ce8f963384b	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	150.4000	149.7000	150.4000	7725.0000	120320.00	120320.00	0.00	8	5	530	4440	0.119369369369369	0.134399497085118	0.134399497085118	false	false	false
d1fc84e5-b562-4fdd-92c2-7ad4e6520ef4	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPX	SPX270617C08700000	call	8700.0000	2027-06-17	114.6000	114.6000	115.2000	7725.0000	57300.00	0.00	57300.00	5	5	417	11319	0.0368407103100981	0.129097315047903	0.129097315047903	false	false	false
e3964e31-cad4-4e66-b683-f458a4b97bca	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	150.6000	149.8000	150.6000	7725.0000	135540.00	135540.00	0.00	9	6	502	4440	0.113063063063063	0.134391455430526	0.134391455430526	false	false	false
1e586028-4914-4b8d-ba68-1ed10856c36e	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	150.6000	149.8000	150.6000	7745.3100	150600.00	150600.00	0.00	10	6	493	4440	0.111036036036036	0.134430089437252	0.134430089437252	false	false	false
1dd8943c-f487-4e37-b550-163af8011fb5	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SPX	SPX270319C08125000	call	8125.0000	2027-03-19	191.0000	190.3000	191.3000	7745.4200	13370000.00	13370000.00	0.00	700	6	713	749	0.951935914552737	0.131283994827037	0.131283994827037	false	true	false
f15f1ecf-6b97-4692-809b-918735d22432	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPX	SPX261218P08125000	put	8125.0000	2026-12-18	381.1300	380.6000	382.0000	7744.3900	228680.00	76240.00	114320.00	6	6	112	102	1.09803921568627	0.128414522465441	0.128551857725048	false	false	false
24a80433-e275-422e-9167-7f7e15e2995d	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPX	SPX261218P08125000	put	8125.0000	2026-12-18	381.0000	380.6000	381.6000	7744.1900	190500.00	0.00	190500.00	5	5	118	102	1.15686274509804	0.128391329123224	0.128275286638846	false	false	false	true
cdd231d8-5397-4ab1-b577-9202e2e1b475	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPX	SPX261218P08125000	put	8125.0000	2026-12-18	381.0000	380.2000	382.0000	7744.4900	228600.00	0.00	228600.00	6	6	106	102	1.03921568627451	0.128449303025617	0.128449303025617	false	false	false	true
9cdf201e-77bc-4520-8499-6586c0f0add4	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	150.2600	150.1000	150.5000	7744.5900	195340.00	120220.00	15020.00	13	7	433	4440	0.0975225225225225	0.134384180276911	0.134343806311557	false	false	false
1e3f70b9-ebde-448d-b5dd-f8e767c5e295	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPX	SPX270617P05775000	put	5775.0000	2027-06-17	57.8000	57.8000	58.4000	7744.8400	57800.00	0.00	57800.00	10	5	55	1427	0.0385423966362999	0.275683924138865	0.275683924138865	true	false	false	true
f87e00e8-c8c0-4309-9f21-505c5b8c7097	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	150.6000	149.5000	150.6000	7745.2700	135540.00	135540.00	0.00	9	5	420	4440	0.0945945945945946	0.134434266008416	0.134434266008416	false	false	false
0a6231de-2010-44c5-a32a-542129947800	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	150.3000	149.4000	150.3000	7744.3600	195390.00	195390.00	0.00	13	6	395	4440	0.088963963963964	0.13440818359663	0.13440818359663	false	false	false
d9c91206-6434-49b9-8e9b-2db5bd14b2cc	2026-09-25 15:57	2026-09-25 15:57	2026-09-25 15:57	SPX	SPX270617C08700000	call	8700.0000	2027-06-17	114.4000	114.4000	114.6000	7744.5500	125840.00	0.00	125840.00	11	5	273	11319	0.0241187384044527	0.129083094912242	0.129083094912242	false	false	false
bc5024c6-c6cc-4597-8f00-8d35212ccdb5	2026-09-25 15:57	2026-09-25 15:56	2026-09-25 15:56	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	150.3000	149.4000	150.3000	7744.1400	135270.00	135270.00	0.00	9	6	380	4440	0.0855855855855856	0.134431142823581	0.134431142823581	false	false	false
50ccaacb-5f9f-4930-aa0e-ccaf3dabf222	2026-09-25 15:57	2026-09-25 15:56	2026-09-25 15:56	SPX	SPX270617C08700000	call	8700.0000	2027-06-17	114.1000	114.1000	114.9000	7744.2000	171150.00	0.00	171150.00	15	6	260	11319	0.0229702270518597	0.128977897927031	0.128977897927031	false	false	false
fc123ca3-fa79-4619-a720-dce42f8dd725	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPX	SPX270617C08700000	call	8700.0000	2027-06-17	114.1000	114.1000	114.9000	7743.9200	193970.00	0.00	193970.00	17	6	243	11319	0.0214683275907766	0.129010660982816	0.129010660982816	false	false	false
cc6071c8-7420-426b-8028-ff936d9120a1	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPX	SPX270617C08700000	call	8700.0000	2027-06-17	114.3700	114.1000	114.7000	7743.9400	251610.00	45720.00	34290.00	22	7	206	11319	0.0181994875872427	0.129154512105122	0.129105792258587	false	false	false
1a9067ed-cd5c-4195-b46d-a059535d0d4e	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	149.8400	149.5000	150.0000	7744.9200	134860.00	119870.00	0.00	9	5	301	4440	0.0677927927927928	0.134147832905358	0.134188226607295	false	false	false
08ab7acd-eed5-45f2-b897-b8e8ce5983e9	2026-09-25 15:56	2026-09-25 15:55	2026-09-25 15:55	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	150.3000	149.6000	150.3000	7746.4700	300600.00	300600.00	0.00	20	5	282	4440	0.0635135135135135	0.134187960335108	0.134187960335108	false	false	false
979edcd0-9f95-4312-a8d3-3ef28e6d3d3c	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	150.2500	149.3000	150.3000	7745.8500	375630.00	375630.00	0.00	25	5	240	4440	0.0540540540540541	0.134212319537144	0.134252674894674	false	false	false
a3391469-e2ed-4589-ab95-008fb1198d69	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	SPX	SPX270617C08700000	call	8700.0000	2027-06-17	114.9500	114.6000	115.5000	7747.7200	252900.00	57500.00	195400.00	22	6	73	11319	0.00644933297994523	0.129012868142029	0.129003487674862	false	false	false
da46b800-2914-49bd-a3f3-c8c84a3ec7de	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	SPX	SPX261016P06800000	put	6800.0000	2026-10-16	3.4000	3.2000	3.4000	7750.8000	17000.00	17000.00	0.00	50	5	156	13714	0.0113752369841038	0.269736295460911	0.269736295460911	true	false	false	true
fdc19527-3500-4df7-9b80-324942b2adaf	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	SPX	SPX261218P07200000	put	7200.0000	2026-12-18	64.4000	63.7000	64.4000	7751.8700	322000.00	322000.00	0.00	50	8	1164	25768	0.0451723067370382	0.188406763000062	0.188406763000062	false	false	false	true
aa264fb7-bf75-42f5-8c7a-7004f2bb7ffa	2026-09-25 15:47	2026-09-25 15:47	2026-09-25 15:47	SPX	SPX261218P06650000	put	6650.0000	2026-12-18	30.2000	29.8000	30.2000	7725.0000	151000.00	151000.00	0.00	50	5	300	11679	0.0256871307474955	0.24178962614581	0.24178962614581	true	false	false	true
ecec5a4c-6965-401a-b4b3-b530238afc61	2026-09-25 15:47	2026-09-25 15:47	2026-09-25 15:47	SPX	SPX261218P06650000	put	6650.0000	2026-12-18	30.2000	29.8000	30.2000	7725.0000	151000.00	151000.00	0.00	50	5	250	11679	0.0214059422895796	0.241793862946482	0.241793862946482	true	false	false	true
ab28b771-f30b-437f-8f10-f033c153c82b	2026-09-25 15:47	2026-09-25 15:47	2026-09-25 15:47	SPX	SPX261218P06650000	put	6650.0000	2026-12-18	30.2000	29.7000	30.2000	7725.0000	151000.00	151000.00	0.00	50	5	200	11679	0.0171247538316637	0.241793862946482	0.241793862946482	true	false	false	true
ebd4232f-ec6c-43cd-acef-21a496eec667	2026-09-25 15:47	2026-09-25 15:47	2026-09-25 15:47	SPX	SPX261120P07500000	put	7500.0000	2026-11-20	74.1000	73.7000	74.5000	7725.0000	44460.00	0.00	0.00	6	5	950	19622	0.048415044337988	0.156640793869831	0.156640793869831	false	false	false	true
f928c4de-22ad-4a0c-8934-2918f98057f7	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	SPX	SPX261016P07400000	put	7400.0000	2026-10-16	15.1000	14.6000	15.1000	7725.0000	54360.00	54360.00	0.00	36	7	5678	19154	0.296439386029028	0.161614992825561	0.161614992825561	false	false	false	true
73e40f6a-0bd0-445f-9998-ad01cc8771ac	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	SPX	SPX261016P07400000	put	7400.0000	2026-10-16	15.0000	14.6000	15.0000	7725.0000	348000.00	348000.00	0.00	232	6	5642	19154	0.294559883053148	0.161380908078894	0.161380908078894	false	false	false	true
0549a92c-39c1-4f87-9d30-df58f7598c6f	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SPX	SPX261218P07485000	put	7485.0000	2026-12-18	108.1000	108.1000	108.7000	7710.0000	151340.00	0.00	151340.00	14	5	180	308	0.584415584415584	0.161556844182207	0.161556844182207	true	false	false	true
cae05893-3f71-4040-86f4-38179b8a39fe	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SPX	SPX261218P07485000	put	7485.0000	2026-12-18	108.1000	108.1000	108.7000	7710.0000	270250.00	0.00	270250.00	25	5	166	308	0.538961038961039	0.161612874840254	0.161612874840254	true	false	false	true
2d5bc5e9-94fe-4534-b2db-eb88521c9171	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SPX	SPX261218P07485000	put	7485.0000	2026-12-18	108.0000	108.0000	108.7000	7710.0000	259200.00	0.00	259200.00	24	5	141	308	0.457792207792208	0.16161787055059	0.16161787055059	true	false	false	true
fa3f6237-d74e-479a-8e96-c941ca2a1a86	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SPX	SPX261218P07485000	put	7485.0000	2026-12-18	108.0000	108.0000	108.7000	7710.0000	194400.00	0.00	194400.00	18	5	92	308	0.298701298701299	0.161638030385753	0.161638030385753	true	false	false	true
a91f94d8-852d-46f4-a4c3-a75b3e8b6ecc	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SPX	SPX261218P07485000	put	7485.0000	2026-12-18	107.9000	107.9000	108.6000	7710.0000	258960.00	0.00	258960.00	24	5	49	308	0.159090909090909	0.161544426438333	0.161544426438333	true	false	false	true
595f4fe2-dbd9-4fd1-be38-932f124dce60	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SPX	SPX261218P07485000	put	7485.0000	2026-12-18	108.0000	108.0000	108.7000	7710.0000	270000.00	0.00	270000.00	25	5	74	308	0.24025974025974	0.161624590642165	0.161624590642165	true	false	false	true
3cc9d06e-d9f7-4977-a94e-9c9bac01cd21	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SPX	SPX270319P06450000	put	6450.0000	2027-03-19	62.8000	62.8000	63.3000	7710.0000	69080.00	0.00	69080.00	11	5	147	4693	0.0313232473897294	0.239976239242965	0.239976239242965	true	false	false	true
aa9e8411-e671-464c-a746-ffb048aafee2	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SPX	SPX270319P06450000	put	6450.0000	2027-03-19	62.8000	62.8000	63.3000	7710.0000	157000.00	0.00	157000.00	25	5	136	4693	0.0289793309183891	0.239976239242965	0.239976239242965	true	false	false	true
12e39394-7d3b-45c5-bc24-19e0f6e1b98d	2026-09-25 15:27	2026-09-25 15:27	2026-09-25 15:27	SPX	SPX270319P07075000	put	7075.0000	2027-03-19	118.5000	118.4000	119.0000	7734.1800	296250.00	0.00	296250.00	25	6	25	878	0.0284738041002278	0.196866375917092	0.196866375917092	true	false	false	true
f97739ea-c608-4788-a9c8-42c7b50c8cff	2026-09-25 15:24	2026-09-25 15:24	2026-09-25 15:24	SPX	SPX270319P07125000	put	7125.0000	2027-03-19	125.1000	124.8000	125.5000	7735.4400	75060.00	0.00	75060.00	6	5	6	1194	0.0050251256281407	0.193693139048798	0.193693139048798	false	false	false	true
7ef6a2d9-adb2-40ca-adcc-6e2db760b92b	2026-09-25 15:21	2026-09-25 15:21	2026-09-25 15:21	SPX	SPX261120C08360000	call	8360.0000	2026-11-20	7.8000	7.5000	7.8000	7737.0400	38220.00	38220.00	0.00	49	6	69	69	1	0.111961316807671	0.111961316807671	false	false	false	true
33ea9ba1-4a43-44c3-a1a2-91c816d65e1c	2026-09-25 15:16	2026-09-25 15:16	2026-09-25 15:16	SPX	SPX261120P06620000	put	6620.0000	2026-11-20	15.6000	15.3000	15.6000	7740.3000	40560.00	40560.00	0.00	26	5	26	127	0.204724409448819	0.255568224922545	0.255568224922545	false	false	false	true
72127847-731d-4f9b-8741-8bae9c95d430	2026-09-25 14:54	2026-09-25 14:54	2026-09-25 14:54	SPX	SPX261120C08010000	call	8010.0000	2026-11-20	57.1000	57.1000	57.6000	7715.0000	508190.00	0.00	508190.00	89	5	170	524	0.324427480916031	0.115241423003629	0.115241423003629	false	false	false	true
e22fd5f6-32fb-4925-a6b6-be5721633ab6	2026-09-25 14:49	2026-09-25 14:49	2026-09-25 14:49	SPX	SPX261016C07775000	call	7775.0000	2026-10-16	72.3000	72.1000	72.7000	7715.0000	72300.00	0.00	72300.00	10	5	121	2114	0.0572374645222327	0.109426597430369	0.109426597430369	false	false	false	true
70c64333-b5c3-43af-9a5f-f78843b31bf0	2026-09-25 14:41	2026-09-25 14:40	2026-09-25 14:40	SPX	SPX261016P07400000	put	7400.0000	2026-10-16	16.8000	16.6000	16.9000	7735.5600	168000.00	168000.00	0.00	100	5	2282	19154	0.119139605304375	0.162989677795477	0.162989677795477	false	false	false	true