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:alert_rule = RepeatedHitsAscendingFill×source = uw_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

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	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:58:21.779683Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
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
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
8ef1fea6-4e98-432f-993f-7e3a6959f396	2026-09-25 09:39	2026-09-25 09:39	2026-09-25 09:39	SPX	SPX261218P08125000	put	8125.0000	2026-12-18	397.0700	396.6000	397.6000	7705.0000	238240.00	0.00	119100.00	6	6	69	102	0.676470588235294	0.130171140789115	0.130335044475511	false	false	false
1227888c-c9bf-4370-a2ef-f2517d652a64	2026-09-24 14:20	2026-09-24 14:20	2026-09-24 14:20	SPX	SPX261218C07760000	call	7760.0000	2026-12-18	208.7800	206.4000	207.2000	7699.2900	187904.00	0.00	0.00	9	7	689	772	0.892487046632124	0.136010786686136	0.136017546052642	false	false	false
972b1950-b878-492e-a90b-f7f6baabba26	2026-09-24 12:58	2026-09-24 12:58	2026-09-24 12:58	SPX	SPX261218C07660000	call	7660.0000	2026-12-18	279.2400	278.6000	279.9000	7695.0000	139620.00	55840.00	83780.00	5	5	96	2124	0.0451977401129944	0.140567960076766	0.140638094853063	false	false	false
e2d23e84-1043-465a-801b-e8ed530b65f7	2026-09-24 12:50	2026-09-24 12:50	2026-09-24 12:50	SPX	SPX261016C07810000	call	7810.0000	2026-10-16	53.1100	52.4000	53.4000	7715.8900	839130.00	839130.00	0.00	158	11	454	453	1.00220750551876	0.112514024216129	0.112794187082577	false	false	false
5743c521-b332-4078-838d-69d7eca5ad4a	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	SPX	SPX261016P07625000	put	7625.0000	2026-10-16	56.7600	56.1000	57.5000	7685.0000	85140.00	0.00	68070.00	15	5	520	3890	0.133676092544987	0.132693122341844	0.132983052567231	false	false	false
a512e969-455c-4f91-a37d-23778404a20c	2026-09-24 10:44	2026-09-24 10:43	2026-09-24 10:43	SPX	SPX261218P06775000	put	6775.0000	2026-12-18	41.7400	41.6000	42.1000	7683.6400	50090.00	0.00	50090.00	12	7	12	2151	0.00557880055788006	0.228463799430708	0.228618106237935	false	false	false
553f1fef-4e3b-4892-b724-f1775e6e73be	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SPX	SPX270917C08900000	call	8900.0000	2027-09-17	141.8300	141.1000	142.1000	7702.2600	198560.00	156000.00	42560.00	14	7	293	3678	0.0796628602501359	0.135294493406694	0.135301656359182	false	false	false
464549d8-768e-4582-b6b8-02a0b8fd442c	2026-09-23 13:35	2026-09-23 13:35	2026-09-23 13:35	SPX	SPX261218P07765000	put	7765.0000	2026-12-18	202.6500	202.3000	203.1000	7704.7600	2269696.00	0.00	0.00	112	10	2932	1032	2.84108527131783	0.141125702276884	0.141132418229284	false	false	false
e7b98ca3-2163-4075-afe5-4a5708f3cb7f	2026-09-23 13:05	2026-09-23 13:05	2026-09-23 13:05	SPX	SPX261016P07625000	put	7625.0000	2026-10-16	61.1800	60.8000	61.4000	7697.8100	67300.00	55080.00	12220.00	11	5	168	3854	0.0435910742086144	0.131049245701417	0.131188741001549	false	false	false
46ebc060-5d60-4252-a5de-7838b507ffbf	2026-09-23 12:37	2026-09-23 12:37	2026-09-23 12:37	SPX	SPX261218C07660000	call	7660.0000	2026-12-18	276.7800	276.6000	277.2000	7714.4600	138390.00	27680.00	110710.00	5	5	33	2096	0.0157442748091603	0.138880490780723	0.138950187623529	false	false	false
e8a29112-efec-4e23-b9fa-f1c61e89e13d	2026-09-23 11:10	2026-09-23 11:10	2026-09-23 11:10	SPX	SPX271217C08600000	call	8600.0000	2027-12-17	341.2300	340.4000	342.7000	7729.1100	20473500.00	0.00	0.00	600	14	600	2836	0.211565585331453	0.145826373176029	0.145841334172384	false	false	false
d2da9871-867e-43c6-9f73-5b15a1222081	2026-09-22 15:56	2026-09-22 15:56	2026-09-22 15:56	SPX	SPX270617C08725000	call	8725.0000	2027-06-17	121.7600	121.4000	122.4000	7767.4700	97410.00	12190.00	73050.00	8	7	400	600	0.666666666666667	0.131682004338926	0.131777174733469	false	false	false
79183f76-9b5f-4fd5-bd15-2f88d7637ae7	2026-09-22 15:56	2026-09-22 15:55	2026-09-22 15:55	SPX	SPX270617C08725000	call	8725.0000	2027-06-17	121.7800	121.3000	122.3000	7768.3300	97420.00	0.00	73040.00	8	6	383	600	0.638333333333333	0.131580935881323	0.131676071689443	false	false	false
f672ce6a-73ff-41b0-85f6-bfba504e15f4	2026-09-22 12:34	2026-09-22 12:34	2026-09-22 12:34	SPX	SPX261016C07800000	call	7800.0000	2026-10-16	76.9100	76.4000	77.0000	7762.0100	646040.00	354200.00	291840.00	84	7	1301	24753	0.0525592857431422	0.107383014635229	0.107635488519626	true	false	false
0097eaea-6cbd-43b7-9e35-8142933cac5b	2026-09-22 12:30	2026-09-22 12:30	2026-09-22 12:30	SPX	SPX270115C07525000	call	7525.0000	2027-01-15	463.9400	462.6000	464.5000	7759.9400	417550.00	0.00	0.00	9	6	9	609	0.0147783251231527	0.154774095105563	0.154780796228391	false	false	false
af0411ce-3473-4598-b4c1-3fa6a8d45d49	2026-09-22 10:46	2026-09-22 10:46	2026-09-22 10:46	SPX	SPX261218P08000000	put	8000.0000	2026-12-18	287.9200	288.4000	289.2000	7761.7800	17275500.00	0.00	0.00	600	16	657	266872	0.00246185437213346	0.129852066394891	0.129886543887299	false	false	false
0cbaa07d-6848-444d-997e-66b10655db52	2026-09-22 10:33	2026-09-22 10:33	2026-09-22 10:33	SPX	SPX261016P07140000	put	7140.0000	2026-10-16	8.1900	7.8000	8.1000	7770.8600	97476.00	0.00	0.00	119	18	124	1806	0.0686600221483942	0.206636698617272	0.20668771311411	false	false	false
1dfdcb31-bf4d-4ad7-b9f8-5cea8a73dbc8	2026-09-21 12:14	2026-09-21 12:14	2026-09-21 12:14	SPX	SPX261016C07900000	call	7900.0000	2026-10-16	37.4000	37.5000	38.1000	7745.0800	373982.00	0.00	0.00	100	26	1246	19306	0.0645395213923133	0.108619673996586	0.10863436351607	false	false	false
9dcdb013-f13c-466d-9092-75cd309caedc	2026-09-21 11:53	2026-09-21 11:53	2026-09-21 11:53	SPX	SPX261016C07850000	call	7850.0000	2026-10-16	51.2800	51.0000	51.7000	7738.1000	25640.00	15420.00	10220.00	5	5	75	10753	0.0069747977308658	0.109595960184808	0.110130262683639	false	false	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
5c0b258e-5a4b-474f-926c-3cfae07c1e5a	2026-09-18 10:33	2026-09-18 10:33	2026-09-18 10:33	SPX	SPX261218P06025000	put	6025.0000	2026-12-18	20.4700	20.1000	20.5000	7623.0500	120794.00	0.00	0.00	59	22	183	3353	0.054577989859827	0.297721762766386	0.297762133414972	false	false	false
1976ece9-547b-433b-b6a4-b663c361ae88	2026-09-17 16:53	2026-09-17 16:26	2026-09-17 16:26	SPX	SPX260918P07540000	put	7540.0000	2026-09-18	1.7000	1.5000	1.7500	7615.0000	135897.00	135897.00	0.00	800	6	2722	7744	0.351497933884298	0.159457231509525	0.160924241922867	false	false	false
ecd99724-d823-4498-a7ef-44d0e74a3431	2026-09-17 15:14	2026-09-17 15:13	2026-09-17 15:13	SPX	SPX260918C07640000	call	7640.0000	2026-09-18	18.2500	17.9000	18.4000	7640.1100	146030.00	146030.00	0.00	80	6	2510	7841	0.320112230582834	0.111119437623806	0.112373419190265	true	false	false
c278840f-a84e-414a-9844-2cff0d872648	2026-09-17 15:13	2026-09-17 15:13	2026-09-17 15:13	SPX	SPX260918P07630000	put	7630.0000	2026-09-18	12.3200	11.9000	12.5500	7639.3800	123220.00	103540.00	19680.00	100	5	2523	5284	0.477479182437547	0.10546706936986	0.106112919602299	false	false	false
5dd3dd7c-ad26-46b2-900f-fdd0c00741ef	2026-09-17 14:47	2026-09-17 14:46	2026-09-17 14:46	SPX	SPX260918C07650000	call	7650.0000	2026-09-18	11.3800	10.9000	14.0000	7635.6000	341530.00	157600.00	183930.00	300	11	6401	38759	0.165148739647566	0.108142602359281	0.109358929507355	false	false	false
22aaf786-239f-46fc-9664-f4aeaf650d17	2026-09-17 10:51	2026-09-17 10:51	2026-09-17 10:51	SPX	SPX261218P05800000	put	5800.0000	2026-12-18	16.7100	16.5000	16.8000	7622.9400	132031.00	0.00	0.00	79	18	79	16340	0.00483476132190942	0.321091382249119	0.321127121855993	false	false	false
8417b9ef-8539-4d5a-9a49-118b6dd643d7	2026-09-17 10:02	2026-09-17 10:02	2026-09-17 10:02	SPX	SPX260918C07625000	call	7625.0000	2026-09-18	18.5300	18.0000	18.6000	7616.0800	170470.00	170470.00	0.00	92	7	450	6718	0.0669842214944924	0.140228910223642	0.140863952802982	false	false	false
650e03ee-4bf8-4b02-a5b4-7987eea979cd	2026-09-16 16:59	2026-09-16 16:55	2026-09-16 16:55	SPX	SPX261218P07650000	put	7650.0000	2026-12-18	234.8100	234.2000	236.3000	7530.0000	821835.00	0.00	821835.00	35	7	2267	29253	0.0774963251632311	0.148592653649848	0.148691292438301	false	false	false
b28f0edb-37db-4cb6-bd32-4191759b40aa	2026-09-16 16:18	2026-09-16 16:16	2026-09-16 16:16	SPX	SPX261016P07300000	put	7300.0000	2026-10-16	51.4900	50.8000	52.2000	7530.0000	257445.00	61848.00	97747.00	50	7	2858	16502	0.173191128348079	0.177837381174278	0.177837381174278	false	false	false
f07177bc-3ebd-4972-88bc-4f4b204ba529	2026-09-16 15:58	2026-09-16 15:58	2026-09-16 15:58	SPX	SPX270617C08450000	call	8450.0000	2027-06-17	128.3400	127.8000	128.5000	7530.0000	102670.00	38510.00	64160.00	8	6	181	336	0.538690476190476	0.131616247211689	0.131663302998554	false	false	false
7c41ae0e-d203-458d-ae43-9bc84f4da546	2026-09-16 15:57	2026-09-16 15:57	2026-09-16 15:57	SPX	SPX261218C08050000	call	8050.0000	2026-12-18	50.9500	50.2000	51.4000	7535.0000	2048380.00	499370.00	1549010.00	402	16	2312	10155	0.22767109798129	0.121318263581459	0.121411286083207	false	false	false
27fb122a-b220-4143-aeac-b6d7dfc5f04f	2026-09-16 15:53	2026-09-16 15:53	2026-09-16 15:53	SPX	SPX261218C07600000	call	7600.0000	2026-12-18	234.7500	233.8000	234.9000	7530.0000	305180.00	305180.00	0.00	13	11	6726	28737	0.234053659045829	0.144712004249743	0.144778055997733	false	false	false
5daae287-8480-4a81-a57c-de5e79f3d50a	2026-09-16 15:53	2026-09-16 15:53	2026-09-16 15:53	SPX	SPX261120P07725000	put	7725.0000	2026-11-20	241.0600	240.4000	241.8000	7530.0000	265170.00	48180.00	168790.00	11	10	82	695	0.117985611510791	0.136633021002738	0.136977363318576	false	false	false
f4ded2d1-4dd6-49f6-8e68-384c47588aa3	2026-09-16 15:47	2026-09-16 15:47	2026-09-16 15:47	SPX	SPX261120C07725000	call	7725.0000	2026-11-20	113.6300	113.3000	114.3000	7520.0000	249990.00	22730.00	227260.00	22	19	117	1498	0.0781041388518024	0.131887478363479	0.131969094782083	false	false	false
dc93a472-335a-484f-9b79-9570a58bd54c	2026-09-16 15:43	2026-09-16 15:43	2026-09-16 15:43	SPX	SPX261120C07725000	call	7725.0000	2026-11-20	108.7200	108.4000	109.6000	7532.1200	250050.00	0.00	239170.00	23	20	95	1498	0.0634178905206943	0.131496307599159	0.131578697957879	false	false	false
d18e0e1e-d70c-4ac0-9f66-1d8b5c19ce72	2026-09-16 15:38	2026-09-16 15:38	2026-09-16 15:38	SPX	SPX261120P07725000	put	7725.0000	2026-11-20	251.8500	251.5000	253.1000	7532.2900	151110.00	0.00	151110.00	6	6	42	695	0.060431654676259	0.136970721216814	0.137052766119798	false	false	false
eba58257-0780-4f19-83ce-cde7ba3e3b16	2026-09-16 15:37	2026-09-16 15:37	2026-09-16 15:37	SPX	SPX261120C07725000	call	7725.0000	2026-11-20	107.6900	107.2000	108.6000	7527.9300	258460.00	0.00	258460.00	24	21	72	1498	0.048064085447263	0.131940527338765	0.131909100376984	false	false	false
90593707-1302-4724-839b-d88242d052cb	2026-09-16 15:32	2026-09-16 15:32	2026-09-16 15:32	SPX	SPX261120C07725000	call	7725.0000	2026-11-20	108.4200	108.1000	109.1000	7529.3800	162630.00	0.00	162630.00	15	12	40	1498	0.0267022696929239	0.132223871970643	0.132031057556536	false	false	false
b72237c6-99ac-4c55-906c-b3ac39f11e78	2026-09-16 15:26	2026-09-16 15:26	2026-09-16 15:26	SPX	SPX261120P07725000	put	7725.0000	2026-11-20	268.3400	267.5000	269.1000	7509.2600	214670.00	80520.00	0.00	8	6	8	695	0.0115107913669065	0.138772336687344	0.138809112485404	false	false	false
9781257a-a4c4-4152-af41-3477555dca29	2026-09-16 15:26	2026-09-16 15:26	2026-09-16 15:26	SPX	SPX261218C07600000	call	7600.0000	2026-12-18	215.5300	214.9000	216.0000	7509.1200	150870.00	150870.00	0.00	7	5	5609	28737	0.19518390924592	0.145786369112862	0.145852511431618	false	false	false
08425365-9fd8-4241-95e2-e5620b98f089	2026-09-16 15:22	2026-09-16 15:22	2026-09-16 15:22	SPX	SPX260918P07500000	put	7500.0000	2026-09-18	33.0600	32.9000	35.0000	7516.0400	158700.00	3300.00	155400.00	48	11	11817	76536	0.154397930385701	0.185964838426846	0.185964838426846	false	false	false
73f33d06-55cf-4152-9349-ac4f50804c9c	2026-09-16 10:40	2026-09-16 10:40	2026-09-16 10:40	SPX	SPX261016C07750000	call	7750.0000	2026-10-16	56.1200	55.2000	57.3000	7604.5400	1122330.00	357760.00	764570.00	200	9	356	9739	0.0365540609918883	0.120192182847699	0.120698360699952	false	false	false
bec8faee-25ce-45a8-9afb-b121ce47ccfc	2026-09-16 10:35	2026-09-16 10:35	2026-09-16 10:35	SPX	SPX270319P07550000	put	7550.0000	2027-03-19	253.8500	253.5000	253.9000	7603.0900	609230.00	609230.00	0.00	24	5	78	3115	0.0250401284109149	0.166057061307603	0.166105721949302	false	false	false
1da1a5b9-154e-4da9-918c-257d20581072	2026-09-15 15:57	2026-09-15 15:57	2026-09-15 15:57	SPX	SPX270617C08500000	call	8500.0000	2027-06-17	123.4400	123.0000	123.7000	7560.0000	123440.00	49380.00	24700.00	10	5	834	17054	0.048903483053829	0.130462179870527	0.130509641120204	false	false	false
dee1a04f-8a0f-4684-9560-84db629426af	2026-09-15 10:36	2026-09-15 10:36	2026-09-15 10:36	SPX	SPX261016P07750000	put	7750.0000	2026-10-16	190.5700	190.2000	191.1000	7585.6000	1276820.00	742950.00	533870.00	67	9	128	7555	0.0169424222369292	0.121293785863085	0.121567189885146	false	false	false
d17fd2f4-148c-49fd-90ad-01cb549eba4d	2026-09-15 10:29	2026-09-15 10:29	2026-09-15 10:29	SPX	SPX261218P05925000	put	5925.0000	2026-12-18	22.6200	22.4000	22.7000	7587.6000	133461.00	0.00	0.00	59	12	59	989	0.0596562184024267	0.311496965214148	0.311525135738948	false	false	false
55497672-dccd-440a-9990-bb65f0e039e7	2026-09-15 10:26	2026-09-15 10:26	2026-09-15 10:26	SPX	SPX261218P05700000	put	5700.0000	2026-12-18	18.0500	17.8000	18.1000	7587.3900	140814.00	0.00	0.00	78	18	78	12190	0.00639868744872847	0.334736360705531	0.334770056085189	false	false	false