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 = 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

7cf2c86a-806a-40f5-86f9-daa746b0b0c5	2026-09-30 15:26	2026-09-30 15:26	2026-09-30 15:26	SPX	SPX270115P07400000	put	7400.0000	2027-01-15	123.1000	122.8000	123.4000	7692.6100	18465000.00	0.00	0.00	1500	8	1834	4857	0.377599341157093	0.169038349470366	0.169038349470366	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-30T19:31:21.867797Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
667325fc-3199-4989-86bc-e1a1dbc81b45	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPX	SPX261218P07755000	put	7755.0000	2026-12-18	196.3000	195.3000	196.1000	7696.4800	2748200.00	0.00	0.00	140	6	2533	1795	1.41114206128134	0.141889531642405	0.141889531642405	false	false	false	true
1836bd1c-25f3-45c0-ba08-1e0624f10ac3	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPX	SPX261218C07755000	call	7755.0000	2026-12-18	194.8000	194.8000	195.5000	7696.4800	2727200.00	0.00	0.00	140	7	2546	1832	1.38973799126638	0.132080874004453	0.132080874004453	false	false	false	true
ec243abe-4543-4be0-b4c7-d46ef7daf66a	2026-09-30 15:02	2026-09-30 15:02	2026-09-30 15:02	SPX	SPX270319P03800000	put	3800.0000	2027-03-19	7.8000	7.5000	7.8000	7696.5000	780000.00	780000.00	0.00	1000	11	5000	10565	0.473260766682442	0.477627333831766	0.477627333831766	false	true	false	true
df209870-959b-43c2-85c1-e00835e257a4	2026-09-30 14:44	2026-09-30 14:43	2026-09-30 14:43	SPX	SPX261218P06500000	put	6500.0000	2026-12-18	25.9000	25.5000	25.9000	7697.8200	1139600.00	1139600.00	0.00	440	8	454	27718	0.0163792481420016	0.258804308787607	0.258804308787607	true	false	false	true
38daa7d2-919e-487e-952c-c7674fb4e739	2026-09-30 14:04	2026-09-30 14:04	2026-09-30 14:04	SPX	SPX261016P07400000	put	7400.0000	2026-10-16	14.7000	14.4000	14.7000	7702.4100	22050.00	22050.00	0.00	15	7	839	20431	0.0410650482110518	0.166312742566644	0.166312742566644	false	false	false	true
f50359be-778f-4380-8d74-a4b22a7356c6	2026-09-30 13:33	2026-09-30 13:33	2026-09-30 13:33	SPX	SPX261016P07600000	put	7600.0000	2026-10-16	42.5000	41.9000	42.5000	7701.4300	191250.00	191250.00	0.00	45	5	1292	15376	0.0840270551508845	0.138315531941565	0.138315531941565	false	false	false	true
b31b2dfd-4e71-4489-8d66-3e513bd83039	2026-09-30 12:42	2026-09-30 12:42	2026-09-30 12:42	SPX	SPX261218C07775000	call	7775.0000	2026-12-18	191.9000	192.8000	193.6000	7690.0000	326230.00	0.00	0.00	17	5	1951	3661	0.532914504233816	0.131452777143715	0.131452777143715	false	false	false	true
3fe7aff8-112f-4fb6-a131-f96301396992	2026-09-30 12:42	2026-09-30 12:42	2026-09-30 12:42	SPX	SPX261218P07775000	put	7775.0000	2026-12-18	200.0000	198.5000	199.2000	7690.0000	340000.00	0.00	0.00	17	5	1944	3185	0.610361067503925	0.142512520257567	0.142512520257567	false	false	false	true
b66c92a1-124b-4177-b408-efb3cc4b5319	2026-09-30 12:42	2026-09-30 12:42	2026-09-30 12:42	SPX	SPX261218C07775000	call	7775.0000	2026-12-18	191.9000	192.8000	193.5000	7690.0000	268660.00	0.00	0.00	14	5	1934	3661	0.528270964217427	0.131478173252998	0.131478173252998	false	false	false	true
b5e6106c-12b9-43f1-a8fe-a868d89685b0	2026-09-30 12:42	2026-09-30 12:42	2026-09-30 12:42	SPX	SPX261016C07815000	call	7815.0000	2026-10-16	35.8000	36.1000	36.7000	7690.0000	254180.00	0.00	0.00	71	5	954	536	1.77985074626866	0.111039243502243	0.111039243502243	false	false	false	true
ac9b6f7b-5682-46e0-b31e-6ec2a39c567b	2026-09-30 12:42	2026-09-30 12:42	2026-09-30 12:42	SPX	SPX261016C07930000	call	7930.0000	2026-10-16	9.9700	10.3000	10.6000	7690.0000	69790.00	0.00	0.00	70	5	1369	1620	0.845061728395062	0.105461572380552	0.105461572380552	false	false	false	true
7c6aaf06-8f43-4238-ace1-7ee8cb1ddf38	2026-09-30 12:42	2026-09-30 12:42	2026-09-30 12:42	SPX	SPX261218P07775000	put	7775.0000	2026-12-18	200.0000	198.7000	199.4000	7690.0000	280000.00	0.00	0.00	14	5	1927	3185	0.605023547880691	0.142488978316961	0.142488978316961	false	false	false	true
1e8ad707-4652-4239-a33b-7d2b3efa473a	2026-09-30 12:42	2026-09-30 12:42	2026-09-30 12:42	SPX	SPX261120P06350000	put	6350.0000	2026-11-20	10.0000	9.9000	10.3000	7690.0000	106000.00	0.00	0.00	106	5	1426	3623	0.393596467016285	0.292079531180726	0.292079531180726	false	false	false	true
05075eb4-9538-478f-a7ab-70b316afb14a	2026-09-30 12:42	2026-09-30 12:42	2026-09-30 12:42	SPX	SPX261120P07375000	put	7375.0000	2026-11-20	60.3000	59.3000	60.0000	7690.0000	639180.00	0.00	0.00	106	5	1440	3791	0.379847006067001	0.172752274111175	0.172752274111175	false	false	false	true
afdcf756-5e87-442c-a817-d4497e048ebc	2026-09-30 12:40	2026-09-30 12:40	2026-09-30 12:40	SPX	SPX261120P07500000	put	7500.0000	2026-11-20	81.5000	81.2000	81.7000	7685.0000	929100.00	733500.00	195600.00	114	7	657	20068	0.0327386884592386	0.159337697467945	0.159337697467945	false	false	false	true
231c382e-1a14-44c9-b3d4-a7fe589118bc	2026-09-30 12:38	2026-09-30 12:38	2026-09-30 12:38	SPX	SPX261016P06900000	put	6900.0000	2026-10-16	3.0000	2.8500	3.1000	7685.0000	311700.00	247800.00	63900.00	1039	8	4284	20665	0.207307040890394	0.262797886651282	0.262797886651282	false	false	false	true
19e735a5-20c2-446c-8734-8d4d2879e670	2026-09-30 12:09	2026-09-30 12:08	2026-09-30 12:08	SPX	SPX261120C08100000	call	8100.0000	2026-11-20	29.9000	29.8000	30.3000	7716.6800	17940.00	0.00	17940.00	6	5	57	16417	0.00347201072059451	0.116705007433967	0.116705007433967	false	false	false	true
05f2e337-3697-4f5b-ad20-839016c91c48	2026-09-30 11:24	2026-09-30 11:24	2026-09-30 11:24	SPX	SPX261120C08400000	call	8400.0000	2026-11-20	4.9000	4.7000	5.0000	7710.0500	368480.00	368480.00	0.00	752	3	1004	9042	0.111037381110374	0.117925281186661	0.117925281186661	false	true	false	true
568e6c3f-75f1-4afe-b8f8-6db27a7520f0	2026-09-30 10:59	2026-09-30 10:59	2026-09-30 10:59	SPX	SPX261016P07050000	put	7050.0000	2026-10-16	4.0000	4.0000	4.2000	7715.5300	174400.00	0.00	174400.00	436	7	437	8718	0.0501261757283781	0.231783422316764	0.231783422316764	false	false	false	true
d2a99169-77ca-4d5b-b1e9-c169cb02eb0b	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPX	SPX261016C07690000	call	7690.0000	2026-10-16	105.0000	104.2000	105.0000	7700.0000	819000.00	819000.00	0.00	78	6	157	467	0.336188436830835	0.126678629995956	0.126678629995956	false	false	false	true
ab55e404-342c-4cd1-9827-a7a7877cd739	2026-09-30 10:52	2026-09-30 10:52	2026-09-30 10:52	SPX	SPX261120P07000000	put	7000.0000	2026-11-20	26.6000	26.5000	26.9000	7695.0000	77140.00	0.00	77140.00	29	6	742	81796	0.00907134823218739	0.212831372836955	0.212831372836955	false	false	false	true
f388504e-d1c6-450e-ac23-9c682f795995	2026-09-30 10:39	2026-09-30 10:39	2026-09-30 10:39	SPX	SPX261016P07300000	put	7300.0000	2026-10-16	9.3000	9.3000	9.5000	7707.1500	23250.00	0.00	23250.00	25	6	305	18591	0.0164057877467592	0.183675011440119	0.183675011440119	false	false	false	true
531aaab4-c5b7-43d3-9032-53fc1a57b705	2026-09-30 10:36	2026-09-30 10:36	2026-09-30 10:36	SPX	SPX261016P07650000	put	7650.0000	2026-10-16	54.4000	54.4000	55.0000	7705.1800	70720.00	0.00	70720.00	13	5	1775	13619	0.130332623540642	0.131641518089236	0.131641518089236	false	false	false	true
d81419ad-63ba-4277-898b-4a8d6194228d	2026-09-30 10:31	2026-09-30 10:31	2026-09-30 10:31	SPX	SPX261218P07410000	put	7410.0000	2026-12-18	97.0400	97.1000	97.7000	7709.3300	10189200.00	0.00	0.00	1050	9	1050	1214	0.864909390444811	0.169536422748997	0.169536422748997	false	false	false	true
d4114f9b-a654-4c9a-baed-781b5a183c06	2026-09-30 10:31	2026-09-30 10:31	2026-09-30 10:31	SPX	SPX261218C07770000	call	7770.0000	2026-12-18	195.5000	195.3000	196.1000	7709.3300	1075250.00	0.00	0.00	55	10	922	2940	0.313605442176871	0.133051084951336	0.133051084951336	false	false	false	true
c0522741-8a1e-4429-8857-2aa1393ec56b	2026-09-30 10:31	2026-09-30 10:31	2026-09-30 10:31	SPX	SPX261218P06625000	put	6625.0000	2026-12-18	28.9700	28.9000	29.3000	7709.3300	2795605.00	0.00	0.00	965	10	965	8148	0.118433971526755	0.244912409725598	0.244912409725598	false	false	false	true
9ce9cf81-70dd-4705-8cf6-ae8327348ff1	2026-09-30 10:31	2026-09-30 10:31	2026-09-30 10:31	SPX	SPX261218P07770000	put	7770.0000	2026-12-18	196.5000	196.9000	197.5000	7709.3300	1080750.00	0.00	0.00	55	9	922	2892	0.31881051175657	0.141082604907832	0.141082604907832	false	false	false	true
938a01df-0c05-49b1-b866-f3aa703d426a	2026-09-30 10:27	2026-09-30 10:27	2026-09-30 10:27	SPX	SPX261218P07600000	put	7600.0000	2026-12-18	139.1000	139.1000	139.8000	7709.7400	389480.00	0.00	389480.00	28	6	69	37040	0.00186285097192225	0.153531783362516	0.153531783362516	false	false	false	true
c19031b3-f172-4904-88e6-405173a62216	2026-09-30 10:22	2026-09-30 10:22	2026-09-30 10:22	SPX	SPX261218C07770000	call	7770.0000	2026-12-18	196.0900	199.6000	200.2000	7717.4700	4313980.00	0.00	0.00	220	10	793	2940	0.269727891156463	0.130476006779091	0.130476006779091	false	false	false	true
4e98a59c-2889-4c6a-9f9d-2057750861f9	2026-09-30 10:22	2026-09-30 10:22	2026-09-30 10:22	SPX	SPX261218P07770000	put	7770.0000	2026-12-18	194.9900	192.9000	193.6000	7717.4700	4289780.00	0.00	0.00	220	11	793	2892	0.274204702627939	0.14273434934671	0.14273434934671	false	false	false	true
3125edf1-eb95-4c02-b8e4-3df0e10af57e	2026-09-30 10:22	2026-09-30 10:22	2026-09-30 10:22	SPX	SPX261218C08150000	call	8150.0000	2026-12-18	49.2200	50.3000	50.8000	7717.4700	5414200.00	0.00	0.00	1100	11	2500	7606	0.32868787799106	0.117481786258702	0.117481786258702	false	false	false	true
c3680fed-2ddc-425b-b088-c4cc4c40d679	2026-09-30 10:19	2026-09-30 10:19	2026-09-30 10:19	SPX	SPX270115P06100000	put	6100.0000	2027-01-15	23.6000	23.6000	24.0000	7714.9300	11800.00	0.00	11800.00	5	5	18	4264	0.00422138836772983	0.28356203603499	0.28356203603499	false	false	false	true
e9d34f09-1c39-449e-a1f7-42d67b1ac4cc	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPX	SPX270115C08000000	call	8000.0000	2027-01-15	122.4600	129.4000	130.3000	7685.0000	24002160.00	0.00	0.00	1960	10	5984	71332	0.0838894184938036	0.120876610697355	0.120876610697355	false	false	false	true
e57ef4f8-7fa4-4a0f-806c-1aacb28988e3	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPX	SPX261016P08000000	put	8000.0000	2026-10-16	299.3200	280.9000	282.8000	7685.0000	58666720.00	0.00	0.00	1960	10	5226	205065	0.0254846024431278	0.167479170466659	0.167479170466659	false	false	false	true
d2c9f867-9296-451b-8b95-36d79dae553a	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPX	SPX261016C08000000	call	8000.0000	2026-10-16	3.8300	4.5000	4.9000	7685.0000	750680.00	0.00	0.00	1960	10	5284	217540	0.024289785786522	0.104195622415323	0.104195622415323	false	false	false	true
bf7c358b-e166-4cb9-b765-c34e09719d47	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPX	SPX261016P07000000	put	7000.0000	2026-10-16	3.6900	3.4000	3.6000	7685.0000	723240.00	0.00	0.00	1960	10	5278	226088	0.0233448922543434	0.2418358522023	0.2418358522023	false	false	false	true
abfcccec-59ed-4440-9111-cb9c88554b19	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPX	SPX270115P07000000	put	7000.0000	2027-01-15	69.6200	66.9000	67.5000	7685.0000	13645520.00	0.00	0.00	1960	10	5242	99112	0.0528896601824199	0.204971933997589	0.204971933997589	false	false	false	true
37003c94-2d95-468a-975d-ef0e30e9fdab	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPX	SPX261016C07000000	call	7000.0000	2026-10-16	706.6100	723.4000	725.5000	7685.0000	138495560.00	0.00	0.00	1960	10	5226	206642	0.0252901152718228	0.244095550960692	0.244095550960692	false	false	false	true
34151d2b-b59c-4a32-8c1d-6825dab61fb2	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPX	SPX270115C07000000	call	7000.0000	2027-01-15	839.7100	854.6000	856.4000	7685.0000	164583160.00	0.00	0.00	1960	10	5226	92803	0.056312834714395	0.175032745991826	0.175032745991826	false	false	false	true
22d53c85-2162-4058-8df4-3238dac0f8ab	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPX	SPX270115P08000000	put	8000.0000	2027-01-15	338.7300	327.2000	328.3000	7685.0000	66391080.00	0.00	0.00	1960	10	5226	68194	0.0766343080036367	0.137092065749345	0.137092065749345	false	false	false	true
d660eedf-a964-405e-bb1f-f7129a2b5d75	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	SPX	SPX261016P07440000	put	7440.0000	2026-10-16	17.4000	16.9000	17.4000	7709.6900	36540.00	36540.00	0.00	21	8	21	684	0.0307017543859649	0.161593605842834	0.161593605842834	false	false	false	true
f3e4db4f-a135-4aaa-be3a-87251e1f281d	2026-09-30 10:10	2026-09-30 10:10	2026-09-30 10:10	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	157.9000	152.6000	153.7000	7711.5800	2052700.00	2052700.00	0.00	130	10	130	6038	0.0215303080490229	0.134440208326084	0.134440208326084	false	true	false	true
de439383-1bb0-4426-b01d-a15d6ee8bd1e	2026-09-30 10:08	2026-09-30 10:08	2026-09-30 10:08	SPX	SPX270115C08550000	call	8550.0000	2027-01-15	17.4000	17.1000	17.5000	7695.0000	10440.00	6960.00	3480.00	6	6	74	710	0.104225352112676	0.116094661061358	0.116094661061358	false	false	false	true
e47d276c-00bf-4749-8b5b-e6638808f4fd	2026-09-30 10:07	2026-09-30 10:07	2026-09-30 10:07	SPX	SPX261016C08025000	call	8025.0000	2026-10-16	3.9000	3.8000	4.1000	7695.0000	156000.00	38220.00	117780.00	400	7	411	2211	0.185888738127544	0.108799624113452	0.108799624113452	false	false	false	true
d85451a7-839e-4f88-b902-8a63729a9076	2026-09-30 10:07	2026-09-30 10:06	2026-09-30 10:06	SPX	SPX261016P07100000	put	7100.0000	2026-10-16	4.4400	4.2000	4.4000	7719.5500	915528.00	0.00	0.00	2062	13	2071	21714	0.095376254950723	0.221856836157629	0.221856836157629	false	false	false	true
d4c94c6b-61a1-4d27-95f3-2a8d89719e60	2026-09-30 10:07	2026-09-30 10:06	2026-09-30 10:06	SPX	SPX261016P07500000	put	7500.0000	2026-10-16	22.5600	21.9000	22.4000	7719.5500	5840784.00	0.00	0.00	2589	11	2711	36481	0.0743126559030728	0.154274289446442	0.154274289446442	false	false	false	true
8fba63db-9e9a-418b-ae42-d1c868c06ba0	2026-09-30 10:07	2026-09-30 10:06	2026-09-30 10:06	SPX	SPX261016C07800000	call	7800.0000	2026-10-16	42.7700	44.8000	45.5000	7719.5500	6629350.00	0.00	0.00	1550	13	1724	25162	0.0685160162149273	0.109930446365172	0.109930446365172	false	false	false	true
855edbb5-f5e2-4629-ab25-ff2f51c66749	2026-09-30 10:07	2026-09-30 10:06	2026-09-30 10:06	SPX	SPX261218P07750000	put	7750.0000	2026-12-18	186.0000	183.4000	184.2000	7719.5500	17298000.00	0.00	0.00	930	13	1298	19392	0.0669348184818482	0.14392039805063	0.14392039805063	false	false	false	true
76b2a014-4c2d-47f5-8aca-c0b186f55c3d	2026-09-30 10:07	2026-09-30 10:06	2026-09-30 10:06	SPX	SPX261218C07750000	call	7750.0000	2026-12-18	208.0000	211.2000	212.0000	7719.5500	19344000.00	0.00	0.00	930	11	1296	20134	0.0643687295122678	0.130914661562002	0.130914661562002	false	false	false	true