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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = SPXW×

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

d6c84c1d-7000-4b09-b928-9f89aca7086d	2026-10-02 15:16	2026-10-02 15:16	2026-10-02 15:16	SPXW	SPXW261002P07720000	put	7720.0000	2026-10-02	3.6000	3.6000	3.8000	7720.0700	11170.00	0.00	10800.00	31	16	121137	1382	87.6534008683068	0.129747794479136	0.133304807504659	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-10-02T19:23:39.651516Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
4228e28c-f7e7-42f7-a1fc-a377d58ce03f	2026-10-02 15:16	2026-10-02 15:16	2026-10-02 15:16	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.1000	20.0000	20.3000	7719.9300	20100.00	0.00	20100.00	10	5	16614	7148	2.32428651371013	0.154904060647244	0.154904060647244	false	false	false	true
8722c0a5-f647-40e6-ab63-16d0fc63d23e	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	SPXW	SPXW261009C07725000	call	7725.0000	2026-10-09	44.9000	44.8000	45.1000	7720.0100	22450.00	4490.00	17960.00	5	5	1430	3914	0.365355135411344	0.104077345073791	0.104077345073791	false	false	false	true
784ba4a2-88fc-4dd9-9429-0cb773909864	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	SPXW	SPXW261002C07700000	call	7700.0000	2026-10-02	20.1000	19.9000	20.2000	7719.7200	20100.00	20100.00	0.00	10	6	16591	7148	2.32106883044208	0.182540637652981	0.182540637652981	false	false	false	true
7cc729b0-7635-4de7-ac8d-fbdcacc8c722	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	SPXW	SPXW261002P07730000	put	7730.0000	2026-10-02	10.9000	10.8000	10.9000	7719.8300	21800.00	21800.00	0.00	20	5	60489	487	124.207392197125	0.137838807785554	0.137838807785554	false	false	false	true
f1810130-f669-4fa7-94a3-5c7a03853467	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	6.5000	6.5000	6.6000	7719.7700	10400.00	0.00	10400.00	16	11	58418	1901	30.7301420305103	0.121814766762857	0.127370859963574	false	false	false	true
74347627-dedd-407a-acdd-78fc00bf5b7d	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	SPXW	SPXW261009P07635000	put	7635.0000	2026-10-09	17.6000	17.5000	17.7000	7720.0700	14080.00	1760.00	0.00	8	6	532	2151	0.247326824732682	0.119389442155997	0.119375163044613	false	false	false	true
54bf1076-5d4e-4e10-9792-df67adf324ed	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	7.1000	7.0000	7.3000	7720.5600	28400.00	5680.00	22720.00	40	8	58357	1901	30.6980536559705	0.128452426802737	0.128452426802737	false	false	false	true
eab69df4-969e-412b-9210-ac53454d062d	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	SPXW	SPXW261005C07720000	call	7720.0000	2026-10-05	22.0000	21.9000	22.0000	7720.5700	52800.00	52800.00	0.00	24	6	4651	507	9.17357001972387	0.073030036550284	0.073030036550284	false	false	false	true
66f34cac-a1dc-43e1-b608-60edbd20eabb	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	SPXW	SPXW261005C07720000	call	7720.0000	2026-10-05	22.0000	21.8000	22.0000	7720.5400	57200.00	57200.00	0.00	26	6	4677	507	9.22485207100592	0.0730866367656744	0.0730866367656744	false	false	false	true
82ee376f-b50c-4694-a1d7-aa54bb6eeb25	2026-10-02 15:14	2026-10-02 15:14	2026-10-02 15:14	SPXW	SPXW261005C07725000	call	7725.0000	2026-10-05	19.0000	19.0000	19.2000	7719.9900	19000.00	0.00	19000.00	10	5	4006	734	5.45776566757493	0.0723089336164145	0.0723089336164145	false	false	false	true
7546abb1-28a3-4e33-8833-f7a19c06665e	2026-10-02 15:14	2026-10-02 15:14	2026-10-02 15:14	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	6.9000	6.8000	7.1000	7720.0000	27600.00	6900.00	20700.00	40	12	58124	1901	30.5754865860074	0.135071345794055	0.135071345794055	false	false	false	true
d3596944-8078-4488-ab5f-71b1b65dd62e	2026-10-02 15:14	2026-10-02 15:14	2026-10-02 15:14	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	7.1000	7.0000	7.1000	7719.9800	28400.00	28400.00	0.00	40	5	58084	1901	30.5544450289321	0.143458159122387	0.143458159122387	false	false	false	true
36da850b-df0a-4b0a-93a6-2d10dfb5ef3c	2026-10-02 15:14	2026-10-02 15:14	2026-10-02 15:14	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	3.7000	3.7000	3.8000	7719.8800	20720.00	0.00	20720.00	56	13	104651	2945	35.5351443123939	0.130089751071302	0.130089751071302	false	false	false	true
f77e50c9-29dd-4cff-ad3a-2eed7742309c	2026-10-02 15:14	2026-10-02 15:13	2026-10-02 15:13	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	7.0000	6.9000	7.0000	7719.4800	18900.00	18900.00	0.00	27	11	58015	1901	30.5181483429774	0.152130726668672	0.152130726668672	false	false	false	true
a8f18ff8-55c6-4c4c-b1d6-692845fd425d	2026-10-02 15:14	2026-10-02 15:13	2026-10-02 15:13	SPXW	SPXW261009P07720000	put	7720.0000	2026-10-09	42.7000	42.6000	42.8000	7719.4100	72590.00	46970.00	0.00	17	5	1157	1615	0.71640866873065	0.106392738315456	0.106392738315456	false	false	false	true
9af1632b-96ae-4c6e-a35e-3352180bd08c	2026-10-02 15:14	2026-10-02 15:13	2026-10-02 15:13	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	3.7000	3.6000	3.8000	7719.4800	19240.00	18870.00	0.00	52	6	104496	2945	35.4825127334465	0.136774989762568	0.136774989762568	false	false	false	true
e00cf6ec-8e58-4c57-b78f-1051599f49ce	2026-10-02 15:13	2026-10-02 15:13	2026-10-02 15:13	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	6.9900	6.9000	7.0000	7719.4700	20960.00	18200.00	2760.00	30	6	78453	2308	33.9917677642981	0.124641667710988	0.124641667710988	false	false	false	true
911e9547-c785-4e60-b389-d6c77a9ccab8	2026-10-02 15:13	2026-10-02 15:13	2026-10-02 15:13	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	3.7000	3.6000	3.8000	7719.4700	18500.00	0.00	14430.00	50	12	104369	2945	35.4393887945671	0.136692861513899	0.136692861513899	false	false	false	true
6f3c20ab-87e5-429f-8273-b718b14f03b8	2026-10-02 15:13	2026-10-02 15:13	2026-10-02 15:13	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	3.7000	3.6000	3.8000	7719.6500	10730.00	8880.00	0.00	29	5	104286	2945	35.4112054329372	0.133530295640739	0.133530295640739	false	false	false	true
244a52dd-2306-42c7-a199-43a8002afee9	2026-10-02 15:13	2026-10-02 15:13	2026-10-02 15:13	SPXW	SPXW261002P07700000	put	7700.0000	2026-10-02	0.4000	0.4000	0.4500	7719.4400	21000.00	0.00	21000.00	525	29	182368	4177	43.660043093129	0.181329245697159	0.181329245697159	false	false	false	true
c1cb8a62-61c3-4670-816a-85a6c1e08306	2026-10-02 15:13	2026-10-02 15:13	2026-10-02 15:13	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	3.8000	3.7000	3.8000	7719.5600	25460.00	25460.00	0.00	67	6	103864	2945	35.2679117147708	0.137561239048688	0.137561239048688	false	false	false	true
04e94abe-592a-4a50-8b31-5ff0cdb19b10	2026-10-02 15:13	2026-10-02 15:13	2026-10-02 15:13	SPXW	SPXW261002P07720000	put	7720.0000	2026-10-02	4.0000	4.0000	4.1000	7719.1700	13200.00	0.00	13200.00	33	7	120019	1382	86.8444283646889	0.123158132316709	0.123158132316709	false	false	false	true
5244e67c-9a0e-4e3a-a8cc-915f1bdac866	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	SPXW	SPXW261002C07710000	call	7710.0000	2026-10-02	10.6000	10.4000	10.6000	7719.1000	26500.00	26500.00	0.00	25	6	30586	2735	11.1831809872029	0.160884029066579	0.160884029066579	false	false	false	true
0122192b-7b25-4f74-b608-cd9e3b52822a	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	SPXW	SPXW261005P07660000	put	7660.0000	2026-10-05	5.5000	5.5000	5.6000	7719.5900	16500.00	0.00	16500.00	30	5	1568	582	2.69415807560137	0.0910486700839013	0.0910486700839013	true	false	false	true
0f9ded11-9da9-4c26-a477-4c85fa26dc0c	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	SPXW	SPXW261005C07715000	call	7715.0000	2026-10-05	24.3000	24.2000	24.3000	7719.4000	24300.00	24300.00	0.00	10	5	1880	242	7.76859504132231	0.0739087628518227	0.0739087628518227	false	false	false	true
37044143-0c71-426a-9d7e-7e6228d2e520	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	SPXW	SPXW261103P06200000	put	6200.0000	2026-11-03	3.3000	3.2000	3.4000	7718.5900	13200.00	0.00	0.00	40	5	393	14	28.0714285714286	0.340310331324421	0.340310331324421	false	false	false	true
6b68720d-c104-4e84-ba9a-1898d3437cef	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	6.5000	6.4000	6.6000	7718.7200	13660.00	13660.00	0.00	21	6	57782	1901	30.3955812730142	0.149249109012844	0.152862966043495	false	false	false	true
011dcbab-d853-4095-884a-e1c79e40fcdc	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	SPXW	SPXW261002P07715000	put	7715.0000	2026-10-02	2.4000	2.3500	2.4000	7718.4700	17280.00	17280.00	0.00	72	26	123451	712	173.386235955056	0.132965710254477	0.132965710254477	false	false	false	true
d7616408-f15c-453d-a2fc-6dcda66816e0	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	SPXW	SPXW261002P07720000	put	7720.0000	2026-10-02	4.5000	4.4000	4.5000	7718.6800	15750.00	15750.00	0.00	35	7	119564	1382	86.5151953690304	0.129990578938103	0.129990578938103	false	false	false	true
46b85283-62e5-4c3d-8088-9d18989740d4	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	SPXW	SPXW261002P07720000	put	7720.0000	2026-10-02	4.5000	4.4000	4.6000	7718.4900	15750.00	0.00	10350.00	35	5	119509	1382	86.4753979739508	0.12618968926206	0.12618968926206	false	false	false	true
824851e7-205c-401b-9ea5-0d9abc8bf930	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	7.8000	7.7000	7.9000	7718.5000	14040.00	0.00	11700.00	18	6	78278	2308	33.9159445407279	0.125618444647491	0.125618444647491	false	false	false	true
a7bb02c0-872a-4934-ae18-d89b662ba442	2026-10-02 15:11	2026-10-02 15:11	2026-10-02 15:11	SPXW	SPXW261002P07715000	put	7715.0000	2026-10-02	2.5000	2.4500	2.5000	7718.7300	46500.00	46500.00	0.00	186	46	123135	712	172.942415730337	0.139295683394915	0.139295683394915	false	false	false	true
5d44e9a3-559f-4087-8692-fb15b302d3ae	2026-10-02 15:11	2026-10-02 15:11	2026-10-02 15:11	SPXW	SPXW261007P07425000	put	7425.0000	2026-10-07	0.9000	0.9000	0.9500	7718.6900	11790.00	0.00	11790.00	131	7	329	518	0.635135135135135	0.159645711224407	0.159645711224407	true	false	false	true
2e122ebc-1f60-4c07-af41-8d68847158bd	2026-10-02 15:11	2026-10-02 15:11	2026-10-02 15:11	SPXW	SPXW261002P07700000	put	7700.0000	2026-10-02	0.5000	0.4500	0.5500	7719.0300	11700.00	10000.00	50.00	234	18	181237	4177	43.3892745989945	0.184086154580149	0.184086154580149	false	false	false	true
e2cbd119-5d9c-4254-b9ff-ce884f292065	2026-10-02 15:11	2026-10-02 15:11	2026-10-02 15:11	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	6.5000	6.5000	6.6000	7719.0700	21450.00	0.00	21450.00	33	11	57544	1901	30.2703840084166	0.139567088160981	0.139567088160981	false	false	false	true
c0778258-ef83-46ca-8a97-4684922ebe2d	2026-10-02 15:11	2026-10-02 15:11	2026-10-02 15:11	SPXW	SPXW261013C07825000	call	7825.0000	2026-10-13	14.5000	14.5000	14.8000	7718.7000	130500.00	0.00	130500.00	90	6	207	3253	0.0636335690132186	0.089587907049998	0.089587907049998	true	false	false	true
60ee59b5-bbad-4b0c-9724-e55772d08a5b	2026-10-02 15:10	2026-10-02 15:10	2026-10-02 15:10	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	0.7000	0.7000	0.7500	7718.7000	16800.00	0.00	16800.00	240	34	116512	2310	50.4380952380952	0.136772025293474	0.136772025293474	false	false	false	true
6377413d-7913-4a51-894e-f308d27ee0a6	2026-10-02 15:10	2026-10-02 15:10	2026-10-02 15:10	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	1.6500	1.5500	1.6500	7718.8300	24750.00	24750.00	0.00	150	21	119187	4450	26.783595505618	0.13370754989574	0.13370754989574	false	false	false	true
782b1ecd-1c6a-44d5-8ab9-a4ec9616f8b1	2026-10-02 15:10	2026-10-02 15:10	2026-10-02 15:10	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	3.2000	3.2000	3.3000	7718.9100	11840.00	0.00	11840.00	37	17	102600	2945	34.8387096774194	0.123965653644656	0.123965653644656	false	false	false	true
bc305569-d802-4221-a497-e96db558ebc6	2026-10-02 15:10	2026-10-02 15:10	2026-10-02 15:10	SPXW	SPXW261002P07715000	put	7715.0000	2026-10-02	2.4000	2.4000	2.4500	7718.7900	16320.00	0.00	16320.00	68	9	122167	712	171.582865168539	0.134375043067732	0.134375043067732	false	false	false	true
f314d845-cf3a-43a8-8948-2621ee295593	2026-10-02 15:10	2026-10-02 15:10	2026-10-02 15:10	SPXW	SPXW261002P07735000	put	7735.0000	2026-10-02	17.0000	16.7000	17.0000	7718.4600	17000.00	17000.00	0.00	10	6	38635	711	54.3389592123769	0.161476614193692	0.161476614193692	false	false	false	true
4913bd21-97b8-4bbb-aea3-8333b46af92e	2026-10-02 15:10	2026-10-02 15:09	2026-10-02 15:09	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	3.4000	3.3000	3.4000	7718.4900	16660.00	16660.00	0.00	49	16	102223	2945	34.7106960950764	0.136377985996247	0.136377985996247	false	false	false	true
fc9602dc-9d40-49bf-bdbe-7e8c03ef590e	2026-10-02 15:09	2026-10-02 15:09	2026-10-02 15:09	SPXW	SPXW261009C07750000	call	7750.0000	2026-10-09	31.7000	31.6000	31.9000	7718.9800	25360.00	0.00	25360.00	8	5	2369	3297	0.718531998786776	0.100774220497105	0.100774220497105	false	false	false	true
4600e084-c5e8-439c-ae37-eb1add4ac804	2026-10-02 15:09	2026-10-02 15:09	2026-10-02 15:09	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	7.4000	7.4000	7.6000	7718.8400	12580.00	0.00	12580.00	17	6	78010	2308	33.7998266897747	0.116418653529033	0.116418653529033	false	false	false	true
5d90fc62-cd96-4c41-b06c-92e1e47e2043	2026-10-02 15:09	2026-10-02 15:09	2026-10-02 15:09	SPXW	SPXW261002P07730000	put	7730.0000	2026-10-02	11.7000	11.7000	11.8000	7718.6500	12870.00	0.00	12870.00	11	5	59797	487	122.786447638604	0.113254482549087	0.113254482549087	false	false	false	true
70939cb3-bb57-4ab8-ba1c-a3b320c461e6	2026-10-02 15:09	2026-10-02 15:08	2026-10-02 15:08	SPXW	SPXW261002C07710000	call	7710.0000	2026-10-02	10.3000	10.3000	10.5000	7718.6400	10300.00	0.00	10300.00	10	5	30361	2735	11.1009140767825	0.156780014183265	0.156780014183265	false	false	false	true
3d1d8544-5299-425b-b1f8-6a922698a84c	2026-10-02 15:08	2026-10-02 15:08	2026-10-02 15:08	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	6.3000	6.3000	6.4000	7718.5200	12600.00	0.00	12600.00	20	8	57037	1901	30.0036822724882	0.141109777476746	0.141109777476746	true	false	false	true
b5df9b42-adc6-48d3-ae9b-61665445ddfe	2026-10-02 15:08	2026-10-02 15:08	2026-10-02 15:08	SPXW	SPXW261002P07720000	put	7720.0000	2026-10-02	5.0000	4.9000	5.1000	7718.4600	19000.00	18500.00	0.00	38	16	117935	1382	85.3364688856729	0.137591768903267	0.137591768903267	false	false	false	true
7e30c0fc-0283-4d63-88ad-07e18816fd8c	2026-10-02 15:08	2026-10-02 15:08	2026-10-02 15:08	SPXW	SPXW261002P07715000	put	7715.0000	2026-10-02	2.9000	2.8500	2.9000	7718.3000	14210.00	14210.00	0.00	49	7	121024	712	169.977528089888	0.142977107987048	0.142977107987048	false	false	false	true