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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = 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

c66b5c59-b2e8-4a47-a65b-084acd2941d2	2026-09-28 11:27	2026-09-28 11:27	2026-09-28 11:27	SPX	SPX261120C09400000	call	9400.0000	2026-11-20	0.1500	0.0500	0.2000	7678.4800	70500.00	70500.00	0.00	4700	10	4700	544	8.63970588235294	0.166716257404275	0.166716257404275	false	true	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T15:32:36.194150Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
ac021a81-72f8-46c8-8f77-a68ebc842123	2026-09-28 11:24	2026-09-28 11:24	2026-09-28 11:24	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	140.6000	139.6000	140.6000	7655.0000	140600.00	140600.00	0.00	10	5	84	5324	0.0157776108189331	0.131250665214562	0.131250665214562	false	false	false	true
1edbf42c-4817-423a-88c5-b75ba4c11de7	2026-09-28 11:17	2026-09-28 11:17	2026-09-28 11:17	SPX	SPX261016P07475000	put	7475.0000	2026-10-16	30.2000	30.2000	30.3000	7655.0000	126840.00	0.00	126840.00	42	6	268	3434	0.0780430984274898	0.157075378526038	0.157075378526038	false	false	false	true
ca172507-0732-470c-9d0c-73227bb7f27e	2026-09-28 11:08	2026-09-28 11:08	2026-09-28 11:08	SPX	SPX270319C08600000	call	8600.0000	2027-03-19	45.6000	45.3000	46.1000	7682.0700	15048000.00	0.00	15048000.00	3300	8	3300	3772	0.874867444326617	0.121804051949853	0.121804051949853	false	true	false	true
5b8d2a6d-132d-4a62-9242-11103b69ac1c	2026-09-28 10:51	2026-09-28 10:51	2026-09-28 10:51	SPX	SPX261016P07500000	put	7500.0000	2026-10-16	33.8000	33.8000	34.4000	7676.3600	486720.00	0.00	486720.00	144	5	247	35951	0.00687046257405914	0.152201182160535	0.152201182160535	false	false	false	true
bdec918a-7bda-452f-9fac-071604e1e761	2026-09-28 10:50	2026-09-28 10:50	2026-09-28 10:50	SPX	SPX270219C08400000	call	8400.0000	2027-02-19	54.0000	52.8000	54.0000	7650.0000	135000.00	135000.00	0.00	25	5	27	2457	0.010989010989011	0.121285716241794	0.121285716241794	false	false	false	true
c6e6812e-d759-43e0-8798-e8a4cdf5949b	2026-09-28 10:49	2026-09-28 10:49	2026-09-28 10:49	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	138.6000	137.7000	138.6000	7650.0000	138600.00	138600.00	0.00	10	5	73	5324	0.0137114951164538	0.13197967297125	0.13197967297125	false	false	false	true
549b2af0-92fc-4e88-98eb-6a9806b5bd34	2026-09-28 10:45	2026-09-28 10:45	2026-09-28 10:45	SPX	SPX261016P07600000	put	7600.0000	2026-10-16	54.0000	54.0000	54.8000	7678.0600	167400.00	0.00	167400.00	31	5	603	14937	0.0403695521188994	0.13797855632852	0.13797855632852	false	false	false	true
c75c2917-303c-4649-8fc3-0217ffbd2197	2026-09-28 10:44	2026-09-28 10:44	2026-09-28 10:44	SPX	SPX261016P07650000	put	7650.0000	2026-10-16	67.5000	67.1000	67.8000	7681.7800	627750.00	209250.00	418500.00	93	5	536	13113	0.0408754670937238	0.13123476041749	0.13123476041749	false	false	false	true
43e15532-7155-4f09-8b15-ee160202ac74	2026-09-28 10:26	2026-09-28 10:26	2026-09-28 10:26	SPX	SPX270219P07675000	put	7675.0000	2027-02-19	219.5000	219.3000	220.1000	7685.0000	285350.00	65850.00	219500.00	13	5	188	560	0.335714285714286	0.153522344903662	0.153522344903662	false	false	false	true
def60272-2a91-47c8-b42f-9c8d4dcb4634	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	SPX	SPX261120P06100000	put	6100.0000	2026-11-20	8.3000	8.3000	8.5000	7685.0000	15770.00	0.00	15770.00	19	6	28	3717	0.00753295668549906	0.323779306279875	0.323779306279875	false	false	false	true
5589641d-5c16-4831-989c-ad418b0e8a1d	2026-09-28 10:22	2026-09-28 10:22	2026-09-28 10:22	SPX	SPX261016P07600000	put	7600.0000	2026-10-16	43.5000	43.5000	44.2000	7685.0000	52200.00	0.00	52200.00	12	7	562	14937	0.0376246903662047	0.135855045034339	0.135855045034339	false	false	false	true
ac7ba78e-244d-4052-8823-219e02a123f7	2026-09-28 09:52	2026-09-28 09:52	2026-09-28 09:52	SPX	SPX261218P06200000	put	6200.0000	2026-12-18	19.3000	19.3000	19.7000	7685.0000	17370.00	0.00	17370.00	9	5	9	29357	0.000306570834894574	0.291391734739373	0.291391734739373	true	false	false	true
7cdf999d-289a-404e-be3b-88061bd25a68	2026-09-28 09:49	2026-09-28 09:49	2026-09-28 09:49	SPX	SPX261120C10000000	call	10000.0000	2026-11-20	0.0500	0.0000	0.1500	7710.8200	63750.00	0.00	63750.00	12750	2	12750	126	101.190476190476	0.194250326463998	0.194250326463998	false	true	false	true
38f33494-aa61-4d3c-b059-0d9a876a6021	2026-09-28 09:48	2026-09-28 09:48	2026-09-28 09:48	SPX	SPX261016C07970000	call	7970.0000	2026-10-16	8.0000	8.0000	8.4000	7708.2000	37600.00	0.00	37600.00	47	5	47	1184	0.0396959459459459	0.106703580681255	0.106703580681255	false	false	false	true
25df90fa-7d84-4839-b9b4-0a67a42c9566	2026-09-28 09:39	2026-09-28 09:39	2026-09-28 09:39	SPX	SPX261120P07000000	put	7000.0000	2026-11-20	30.2000	30.2000	30.7000	7703.2400	93620.00	0.00	93620.00	31	7	38	80165	0.000474022328946548	0.21387662071525	0.21387662071525	false	false	false	true
0499f0f0-d036-419c-bbb9-d98a2222acf5	2026-09-28 09:39	2026-09-28 09:39	2026-09-28 09:39	SPX	SPX261218C08450000	call	8450.0000	2026-12-18	12.9000	12.5000	12.9000	7705.2100	129000.00	129000.00	0.00	100	5	100	6104	0.0163826998689384	0.11706187464564	0.11706187464564	false	false	false	true
954be86d-75a5-4fd4-942d-45e47fce4ffb	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	SPX	SPX270319C08300000	call	8300.0000	2027-03-19	114.4000	113.2000	114.4000	7707.3300	80080.00	80080.00	0.00	7	6	7	9337	0.000749705472849952	0.127550127689978	0.127550127689978	false	false	false	true
932fc821-afec-4cca-b493-fcd7462ee32c	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	SPX	SPX261218C08300000	call	8300.0000	2026-12-18	25.7000	25.7000	26.3000	7707.3300	15420.00	0.00	15420.00	6	6	6	15896	0.000377453447408153	0.116623917491182	0.116623917491182	false	false	false	true
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
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	true
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	true
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	true
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	true
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	true
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
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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