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

e1366936-3254-4a18-9f44-db94b96881e7	2026-09-25 14:37	2026-09-25 14:37	2026-09-25 14:37	SPX	SPX270319P06775000	put	6775.0000	2027-03-19	86.7000	86.7000	87.3000	7738.1400	69360.00	0.00	69360.00	8	5	8	1590	0.0050314465408805	0.217879716550393	0.217879716550393	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-25T18:38:37.498256Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
37e699b8-f08e-4b96-9275-dde0b4cc94c7	2026-09-25 14:36	2026-09-25 14:36	2026-09-25 14:36	SPX	SPX261016C08000000	call	8000.0000	2026-10-16	9.5000	9.1000	9.5000	7741.7500	19000.00	19000.00	0.00	20	5	5108	186262	0.0274237364572484	0.101150960526094	0.101150960526094	false	false	false	true
373b3a06-dac7-497a-b294-b1ebb2ed2f93	2026-09-25 14:31	2026-09-25 14:31	2026-09-25 14:31	SPX	SPX261016P05200000	put	5200.0000	2026-10-16	0.4500	0.3500	0.4500	7742.9900	40005.00	0.00	0.00	889	6	892	3846	0.231929277171087	0.57306214899099	0.57306214899099	false	false	false	true
60ef5a81-b983-4a2f-8085-b59024af035b	2026-09-25 14:26	2026-09-25 14:26	2026-09-25 14:26	SPX	SPX261016P07770000	put	7770.0000	2026-10-16	91.1000	87.2000	95.8000	7740.9900	865450.00	546600.00	318850.00	95	5	160	565	0.283185840707965	0.115254651102748	0.115254651102748	false	false	false	true
4c8fd64b-a95d-4005-b0a4-3b1a565a4e90	2026-09-25 14:10	2026-09-25 14:10	2026-09-25 14:10	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	21.0000	20.7000	21.0000	7720.0000	176400.00	176400.00	0.00	84	6	1056	26680	0.0395802098950525	0.279100754305542	0.279100754305542	false	false	false	true
6fda0b3b-f448-4b61-82ba-ef69ca68f652	2026-09-25 14:10	2026-09-25 14:10	2026-09-25 14:10	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	21.0000	20.7000	21.0000	7720.0000	182700.00	182700.00	0.00	87	6	972	26680	0.036431784107946	0.279098179948089	0.279098179948089	false	false	false	true
907180bd-c87f-4a04-babd-ff9334cd4db3	2026-09-25 14:09	2026-09-25 14:09	2026-09-25 14:09	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	20.9000	20.6000	20.9000	7720.0000	238260.00	238260.00	0.00	114	6	670	26680	0.0251124437781109	0.278752175614689	0.278752175614689	false	false	false	true
c63b73d2-16a0-437d-bff6-aae3db4914a0	2026-09-25 14:05	2026-09-25 14:05	2026-09-25 14:05	SPX	SPX261120P06600000	put	6600.0000	2026-11-20	15.4000	15.3000	15.5000	7720.0000	70840.00	0.00	0.00	46	5	61	12424	0.00490985189954926	0.258785558255347	0.258785558255347	false	false	false	true
5353a210-0f9a-4fe2-991d-5d26abf11b51	2026-09-25 13:46	2026-09-25 13:46	2026-09-25 13:46	SPX	SPX261120C07800000	call	7800.0000	2026-11-20	147.6000	146.1000	146.8000	7739.1200	14760000.00	0.00	0.00	1000	7	3903	8007	0.487448482577744	0.126475721860345	0.126475721860345	false	false	false
30595ff8-f034-498b-a778-cab14ccd47b9	2026-09-25 13:46	2026-09-25 13:46	2026-09-25 13:46	SPX	SPX261218C07805000	call	7805.0000	2026-12-18	198.5000	196.7000	197.6000	7739.1200	12108500.00	0.00	0.00	610	7	1357	1594	0.851317440401506	0.130751481630836	0.130751481630836	false	false	false
1c740887-ce56-4f1f-a629-e0d246b22f5c	2026-09-25 13:46	2026-09-25 13:46	2026-09-25 13:46	SPX	SPX261218P07805000	put	7805.0000	2026-12-18	200.5000	201.2000	202.0000	7739.1200	12230500.00	0.00	0.00	610	7	1358	1554	0.873873873873874	0.138803092698726	0.138803092698726	false	false	false	true
dac09294-0769-4acf-9035-58ad605ad3d4	2026-09-25 13:31	2026-09-25 13:31	2026-09-25 13:31	SPX	SPX270416P07500000	put	7500.0000	2027-04-16	212.3000	211.8000	212.8000	7741.6000	148610.00	106250.00	42360.00	7	7	39	1919	0.020323084940073	0.174057090516375	0.174057090516375	false	false	false
6b1d3e8d-dcb3-4b2d-8b3b-133dd5fc98ca	2026-09-25 13:29	2026-09-25 13:29	2026-09-25 13:29	SPX	SPX270319P07725000	put	7725.0000	2027-03-19	252.1000	251.1000	252.1000	7742.2700	1084030.00	1084030.00	0.00	43	5	86	1507	0.0570670205706702	0.157518365790604	0.157518365790604	false	false	false
e0a301ae-c59b-4bfd-b808-b4f3e0c1b0bc	2026-09-25 13:28	2026-09-25 13:27	2026-09-25 13:27	SPX	SPX261218P07800000	put	7800.0000	2026-12-18	198.0000	197.8000	198.6000	7741.6900	693000.00	0.00	0.00	35	7	4338	21709	0.199824957390944	0.139623456738299	0.139623456738299	false	false	false	true
6569c659-9d44-4227-aff5-1e42a7244291	2026-09-25 13:28	2026-09-25 13:27	2026-09-25 13:27	SPX	SPX261218C07800000	call	7800.0000	2026-12-18	201.0000	200.7000	201.4000	7741.6900	703500.00	0.00	0.00	35	7	4344	32995	0.131656311562358	0.129861625763784	0.129861625763784	false	false	false	true
c6ac9630-b0b8-4a97-a508-1cdb7624dc71	2026-09-25 13:22	2026-09-25 13:22	2026-09-25 13:22	SPX	SPX261120P06200000	put	6200.0000	2026-11-20	9.3000	9.3000	9.5000	7720.0000	17670.00	0.00	17670.00	19	7	236	6780	0.0348082595870206	0.307493430312792	0.307493430312792	false	false	false	true
18180ac8-9d83-471b-99d3-585809db4f2f	2026-09-25 13:22	2026-09-25 13:22	2026-09-25 13:22	SPX	SPX261120C08000000	call	8000.0000	2026-11-20	61.2000	60.7000	61.2000	7720.0000	189720.00	189720.00	0.00	31	5	3728	75710	0.0492405230484744	0.115844629948657	0.115844629948657	false	false	false
1e71506a-e0a5-47b0-9443-96c8ffe970d7	2026-09-25 12:59	2026-09-25 12:59	2026-09-25 12:59	SPX	SPX270115P07930000	put	7930.0000	2027-01-15	279.3700	279.3000	280.6000	7733.7600	1760040.00	0.00	1760040.00	63	5	63	0	0	0.134238084685885	0.134179142723804	false	false	false	true
52ad8d98-32b0-4a4c-90dd-abb01dd15427	2026-09-25 12:59	2026-09-25 12:59	2026-09-25 12:59	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.3000	6.3000	6.6000	7731.8900	14490.00	0.00	14490.00	23	5	637	8292	0.0768210323203087	0.126445854527843	0.126445854527843	false	false	false	true
59233584-a9c3-445a-b145-bd3b1e6f7e15	2026-09-25 12:58	2026-09-25 12:58	2026-09-25 12:58	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.4000	6.4000	6.7000	7735.7800	15360.00	0.00	15360.00	24	5	593	8292	0.0715147129763628	0.126496337940415	0.126496337940415	false	false	false	true
0e3ecebc-2312-48ad-a384-f1d156bd0bae	2026-09-25 12:58	2026-09-25 12:58	2026-09-25 12:58	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.4000	6.4000	6.7000	7736.3400	11520.00	0.00	11520.00	18	5	557	8292	0.0671731789676797	0.126460860460404	0.126460860460404	false	false	false	true
76fe9aaa-c51e-4a8a-af37-f37e574bb39e	2026-09-25 12:58	2026-09-25 12:57	2026-09-25 12:57	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.4000	6.4000	6.7000	7736.0800	16640.00	0.00	16640.00	26	6	539	8292	0.0650024119633382	0.126477331948619	0.126477331948619	false	false	false	true
43eaac42-2911-427f-856c-a1f7aec0115a	2026-09-25 12:57	2026-09-25 12:57	2026-09-25 12:57	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.4000	6.4000	6.7000	7736.8100	14080.00	0.00	14080.00	22	6	513	8292	0.0618668596237337	0.126431085952696	0.126431085952696	false	false	false	true
933da733-0212-400d-8ed5-f7a5acb2cb41	2026-09-25 12:57	2026-09-25 12:57	2026-09-25 12:57	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	253.1200	252.8000	253.6000	7736.8000	151870.00	25310.00	25310.00	6	6	163	3654	0.0446086480569239	0.134788641335174	0.134719182644176	false	false	false
94a86d06-b771-4960-ad3a-2682162c712c	2026-09-25 12:57	2026-09-25 12:57	2026-09-25 12:57	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7738.6400	15600.00	0.00	15600.00	24	5	464	8292	0.0559575494452484	0.12660837754705	0.12660837754705	false	false	false	true
b97f9881-e119-43db-9205-7d9b616e2ab7	2026-09-25 12:56	2026-09-25 12:56	2026-09-25 12:56	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7738.3900	18850.00	0.00	18850.00	29	6	440	8292	0.0530631934394597	0.126624241590652	0.126624241590652	false	false	false	true
5a49a71c-b852-4aef-8fcf-4f9265c52aa2	2026-09-25 12:56	2026-09-25 12:56	2026-09-25 12:56	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7739.6100	19500.00	0.00	19500.00	30	7	411	8292	0.0495658465991317	0.126546828071387	0.126546828071387	false	false	false	true
6df75c1b-62c4-40f8-a3fc-29cb0af4b067	2026-09-25 12:56	2026-09-25 12:56	2026-09-25 12:56	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	254.8600	254.6000	255.4000	7739.5700	127430.00	25480.00	101950.00	5	5	156	3654	0.0426929392446634	0.134825255806385	0.134755730561366	false	false	false
16899e7e-4c06-4838-8f66-aaa2ad0a2897	2026-09-25 12:55	2026-09-25 12:55	2026-09-25 12:55	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7738.7800	14950.00	0.00	14950.00	23	7	381	8292	0.0459479015918958	0.126599493821699	0.126599493821699	false	false	false	true
6ab6725a-dcf1-4b3a-9ebf-e2786de0f902	2026-09-25 12:55	2026-09-25 12:55	2026-09-25 12:55	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	254.3000	254.1000	254.7000	7738.8900	152580.00	50860.00	101720.00	6	6	144	3654	0.0394088669950739	0.134689669680174	0.134689669680174	false	false	false
dc93bf5c-2fb2-4b94-8b3f-64fe915d95f6	2026-09-25 12:55	2026-09-25 12:55	2026-09-25 12:55	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7739.0300	11050.00	0.00	11050.00	17	6	358	8292	0.043174143753015	0.126583630274724	0.126583630274724	false	false	false	true
94738b36-3554-47f0-87ae-83183c926d40	2026-09-25 12:55	2026-09-25 12:55	2026-09-25 12:55	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7738.2400	13650.00	0.00	13650.00	21	5	341	8292	0.0411239749155813	0.126633760169653	0.126633760169653	false	false	false	true
3d31daf5-0e16-4735-a4a0-dcd56a3eb3e6	2026-09-25 12:54	2026-09-25 12:54	2026-09-25 12:54	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.8000	7738.4500	18850.00	0.00	18850.00	29	6	320	8292	0.0385914134105162	0.126620434191149	0.126620434191149	false	false	false	true
e6d43b3a-3440-4296-a8a6-ffd8583614a4	2026-09-25 12:54	2026-09-25 12:53	2026-09-25 12:53	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7737.3900	18200.00	0.00	18200.00	28	6	254	8292	0.0306319343945972	0.126687700949885	0.126687700949885	false	false	false	true
c074924f-afe7-485c-a0f1-aa87b31a6a8c	2026-09-25 12:53	2026-09-25 12:53	2026-09-25 12:53	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7738.1900	13000.00	0.00	13000.00	20	5	202	8292	0.0243608297153883	0.126636933054796	0.126636933054796	false	false	false	true
8e8aec02-9d84-47c6-9e82-d6c741edaf45	2026-09-25 12:53	2026-09-25 12:53	2026-09-25 12:53	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	253.6400	253.3000	254.2000	7737.7700	177550.00	50730.00	25370.00	7	7	123	3654	0.0336617405582923	0.13473570407255	0.13473570407255	false	false	false
42b573ea-1d62-4626-a319-cfa4088f9437	2026-09-25 12:52	2026-09-25 12:51	2026-09-25 12:51	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7737.3200	15600.00	0.00	15600.00	24	7	121	8292	0.0145923781958514	0.126692143295927	0.126692143295927	false	false	false	true
b49ec946-a31c-4174-a344-450083dd0d2e	2026-09-25 12:51	2026-09-25 12:51	2026-09-25 12:51	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7736.2100	14300.00	0.00	14300.00	22	6	97	8292	0.0116980221900627	0.126762589551765	0.126762589551765	false	false	false	true
90a80d3f-33fe-44b1-a4b2-8738cfdc9a00	2026-09-25 12:51	2026-09-25 12:51	2026-09-25 12:51	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7736.7000	14950.00	0.00	14950.00	23	5	75	8292	0.00904486251808972	0.126731490880216	0.126731490880216	false	false	false	true
9fe5dc7c-27ab-4d1c-9fae-e933b263d50a	2026-09-25 12:51	2026-09-25 12:51	2026-09-25 12:51	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7737.1100	11050.00	0.00	11050.00	17	5	52	8292	0.00627110467920888	0.126705470483962	0.126705470483962	false	false	false	true
3ab01bb3-37df-4f31-a954-a083c607e777	2026-09-25 12:50	2026-09-25 12:50	2026-09-25 12:50	SPX	SPX270617C10000000	call	10000.0000	2027-06-17	6.5000	6.5000	6.9000	7736.4000	22750.00	0.00	22750.00	35	5	35	8292	0.00422093584177521	0.126750530737797	0.126750530737797	false	false	false	true
dd35d944-bab4-4dbe-b8e5-c7bb15db9ece	2026-09-25 12:46	2026-09-25 12:46	2026-09-25 12:46	SPX	SPX261016P07650000	put	7650.0000	2026-10-16	50.4000	49.8000	50.6000	7739.8300	1552320.00	846720.00	705600.00	308	15	1296	12970	0.099922898997687	0.128567225779444	0.128596128563166	false	false	false
d4e15648-4e6a-4dd2-8159-6e3aaa151e9c	2026-09-25 12:46	2026-09-25 12:46	2026-09-25 12:46	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	255.0600	254.6000	255.9000	7739.9100	127530.00	25510.00	25510.00	5	5	93	3654	0.0254515599343186	0.134823445730864	0.134823445730864	false	false	false
11982182-a88a-4c4b-830f-d9ebe36ba8c5	2026-09-25 12:36	2026-09-25 12:36	2026-09-25 12:36	SPX	SPX270219P07625000	put	7625.0000	2027-02-19	196.9000	196.1000	197.4000	7738.0800	275660.00	275660.00	0.00	14	6	30	3490	0.00859598853868195	0.157711628507037	0.157694152422946	false	false	false
46a495b0-9cad-4d87-8bf6-d088dea88813	2026-09-25 12:34	2026-09-25 12:34	2026-09-25 12:34	SPX	SPX261016P07670000	put	7670.0000	2026-10-16	53.3000	52.5000	53.3000	7747.3500	490360.00	490360.00	0.00	92	5	103	474	0.217299578059072	0.126508535653245	0.126508535653245	false	false	false	true
2bec24d7-1dfb-4f8a-9710-0d42929b32e1	2026-09-25 12:27	2026-09-25 12:27	2026-09-25 12:27	SPX	SPX270115P07200000	put	7200.0000	2027-01-15	87.1000	87.1000	88.1000	7720.0000	130650.00	0.00	130650.00	15	8	864	5999	0.144024004000667	0.186631236407672	0.186631236407672	false	false	false	true
fce7a29c-9b26-461c-ba69-3289d76e5e3b	2026-09-25 12:24	2026-09-25 12:24	2026-09-25 12:24	SPX	SPX261016P07505000	put	7505.0000	2026-10-16	27.0000	27.0000	27.8000	7733.6500	297000.00	0.00	297000.00	110	6	116	382	0.303664921465969	0.148797923758288	0.148797923758288	false	false	false	true
b172998e-f9ea-40ed-afea-17787bbfae63	2026-09-25 12:14	2026-09-25 12:14	2026-09-25 12:14	SPX	SPX261120C08100000	call	8100.0000	2026-11-20	37.5000	37.0000	37.9000	7743.4100	75000.00	26250.00	33750.00	20	6	93	14413	0.00645250815236245	0.113682993844983	0.113704156830146	false	false	false
57994b83-847a-4d67-bf46-04449fc52f52	2026-09-25 12:13	2026-09-25 12:13	2026-09-25 12:13	SPX	SPX270617C08950000	call	8950.0000	2027-06-17	69.8000	69.1000	69.8000	7725.0000	774780.00	774780.00	0.00	111	5	3000	1487	2.01748486886348	0.127200052498116	0.127200052498116	false	false	false
caa859fc-f049-40ef-879a-16def97a75f9	2026-09-25 12:13	2026-09-25 12:13	2026-09-25 12:13	SPX	SPX261218P07800000	put	7800.0000	2026-12-18	196.0000	197.0000	198.1000	7725.0000	588000.00	0.00	0.00	30	10	486	21709	0.022387028421392	0.139674058566076	0.139674058566076	false	false	false	true