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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T14:23:56.441043Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
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
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
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
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
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
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
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
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
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
8ceab6eb-5eed-4d8f-98c0-082f6dbc0883	2026-09-30 09:56	2026-09-30 09:56	2026-09-30 09:56	SPX	SPX261016P07700000	put	7700.0000	2026-10-16	72.4000	71.6000	72.4000	7702.0700	123080.00	123080.00	0.00	17	5	556	22656	0.0245409604519774	0.124487692939153	0.124487692939153	false	false	false	true
22b4fa6c-5c26-4ffd-8fbe-6df05adcb77d	2026-09-30 09:55	2026-09-30 09:55	2026-09-30 09:55	SPX	SPX270617P07000000	put	7000.0000	2027-06-17	165.9500	165.7000	166.8000	7704.1100	1327600.00	0.00	1327600.00	80	5	310	96266	0.00322024390750628	0.205088427579158	0.205142769345219	false	false	false
f5d0ecf5-4127-4670-955d-f1bbe21a4ccb	2026-09-30 09:53	2026-09-30 09:52	2026-09-30 09:52	SPX	SPX271217C09100000	call	9100.0000	2027-12-17	159.8700	160.0000	161.4000	7698.0000	11990250.00	0.00	0.00	750	10	750	1847	0.406063887384949	0.133139801441473	0.133139801441473	false	false	false
cf77e077-a300-4ad5-b403-30a316687cac	2026-09-30 09:53	2026-09-30 09:52	2026-09-30 09:52	SPX	SPX261218C07755000	call	7755.0000	2026-12-18	194.5000	195.5000	196.4000	7698.0000	739100.00	0.00	0.00	38	10	2051	1832	1.11954148471616	0.131312642450329	0.131312642450329	false	false	false	true
6fc4ddc1-3cc9-4ef9-b844-2dd0f66c432f	2026-09-30 09:53	2026-09-30 09:52	2026-09-30 09:52	SPX	SPX271217P06800000	put	6800.0000	2027-12-17	221.1300	219.8000	221.0000	7698.0000	16584750.00	0.00	0.00	750	10	750	6388	0.117407639323732	0.220579565565085	0.220579565565085	false	false	false	true
1142af0e-c4fc-4465-b7d0-e066e3ef077b	2026-09-30 09:53	2026-09-30 09:52	2026-09-30 09:52	SPX	SPX261218P07755000	put	7755.0000	2026-12-18	196.5000	194.4000	195.3000	7698.0000	746700.00	0.00	0.00	38	10	2047	1795	1.14038997214485	0.142537569043674	0.142537569043674	false	false	false	true
b442f8f3-39ed-4fef-a826-51d9e4e6b5ad	2026-09-30 09:51	2026-09-30 09:51	2026-09-30 09:51	SPX	SPX270319P05850000	put	5850.0000	2027-03-19	36.7000	36.3000	36.7000	7680.0000	33030.00	33030.00	0.00	9	7	9	799	0.0112640801001252	0.285935003921804	0.285935003921804	false	false	false	true
5fb1cb4f-333c-408a-aa3a-9bc652f26f40	2026-09-29 16:27	2026-09-29 16:22	2026-09-29 16:22	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	197.0000	196.8000	197.9000	7650.0000	315200.00	0.00	0.00	16	7	2464	1609	1.5313859540087	0.140398253552822	0.140398253552822	false	false	false	true
3bbdc637-5221-4dc2-8ec3-b05f29731f85	2026-09-29 16:27	2026-09-29 16:22	2026-09-29 16:22	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	199.0000	197.9000	199.1000	7650.0000	318400.00	0.00	0.00	16	7	2469	1695	1.45663716814159	0.136162476329827	0.136162476329827	false	false	false	true
631c108a-1c94-42de-9194-7a4ba081f2db	2026-09-29 16:05	2026-09-29 16:05	2026-09-29 16:05	SPX	SPX261218P07740000	put	7740.0000	2026-12-18	199.0000	199.6000	200.7000	7650.0000	28656000.00	0.00	0.00	1440	8	3922	1984	1.97681451612903	0.140035232023249	0.140035232023249	false	false	false	true
3498df0c-00a7-42f0-9725-3880d4fc6613	2026-09-29 16:05	2026-09-29 16:05	2026-09-29 16:05	SPX	SPX261218C07740000	call	7740.0000	2026-12-18	195.0000	193.9000	194.9000	7650.0000	28080000.00	0.00	0.00	1440	10	3902	1874	2.08217716115261	0.135070205407184	0.135070205407184	false	false	false
969e5a70-b01e-4440-86d3-60bddbe45b1d	2026-09-29 16:02	2026-09-29 16:02	2026-09-29 16:02	SPX	SPX261120P06200000	put	6200.0000	2026-11-20	8.7000	8.7000	9.0000	7650.0000	25230.00	0.00	25230.00	29	8	142	7248	0.0195916114790287	0.304974548815864	0.304974548815864	true	false	false	true
ac178896-0429-4f8c-a784-c77e7b2526de	2026-09-29 16:02	2026-09-29 16:01	2026-09-29 16:01	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	136.8000	136.7000	137.5000	7650.0000	2736000.00	2448720.00	287280.00	200	11	1040	5562	0.186983099604459	0.131784617032538	0.131784617032538	false	false	false
f37d3154-f4f2-4376-9c6e-d7d1d118604c	2026-09-29 16:01	2026-09-29 16:01	2026-09-29 16:01	SPX	SPX261218P05550000	put	5550.0000	2026-12-18	9.4000	9.2000	9.4000	7650.0000	17860.00	17860.00	0.00	19	6	1869	1680	1.1125	0.357171547235521	0.357171547235521	true	false	false	true
ed3b512d-be55-4106-b1ad-3079f9196cbc	2026-09-29 16:01	2026-09-29 16:01	2026-09-29 16:01	SPX	SPX261218P05650000	put	5650.0000	2026-12-18	10.4000	10.1000	10.4000	7650.0000	48880.00	48880.00	0.00	47	6	49	5747	0.00852618757612668	0.346105146535361	0.346105146535361	true	false	false	true
617b495d-0ac5-457b-b1cc-0536720df860	2026-09-29 16:01	2026-09-29 16:01	2026-09-29 16:01	SPX	SPX261218P05550000	put	5550.0000	2026-12-18	9.4000	9.2000	9.4000	7650.0000	47000.00	47000.00	0.00	50	5	1850	1680	1.10119047619048	0.357171547235521	0.357171547235521	true	false	false	true
500de926-cfab-40cc-9b9a-5eadd722bdbe	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	149.6000	149.1000	149.6000	7650.0000	104720.00	104720.00	0.00	7	5	655	6594	0.0993327267212618	0.133753169731852	0.133753169731852	false	false	false
ed0fd36f-4002-4c90-8da4-6bc4664c5c04	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	108.1000	108.1000	108.8000	7650.0000	97290.00	0.00	97290.00	9	5	423	958	0.441544885177453	0.128075600633987	0.128075600633987	false	false	false	true
1a229a81-67eb-4a3a-9cdf-d2b51387a148	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	149.4000	148.8000	149.4000	7650.0000	119520.00	119520.00	0.00	8	5	635	6594	0.0962996663633606	0.133789837805097	0.133789837805097	false	false	false
7ef7ac31-7e10-4dde-a3d2-2e69ed2c8f0c	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	108.1000	108.1000	108.8000	7650.0000	108100.00	0.00	108100.00	10	5	387	958	0.403966597077244	0.128035563146758	0.128035563146758	false	false	false
92b863bd-fccc-4c88-9795-aa8bb28076c6	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	108.1000	108.1000	108.8000	7650.0000	140530.00	0.00	140530.00	13	6	377	958	0.393528183716075	0.128030852741451	0.128030852741451	false	false	false
566521d4-165a-4870-8917-527582aceb38	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	108.0000	108.0000	108.7000	7650.0000	140400.00	0.00	140400.00	13	5	331	958	0.345511482254697	0.128013593977117	0.128013593977117	false	false	false
a0866950-c449-4ccf-83b5-ed0550c5c20d	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	107.9000	107.9000	108.5000	7650.0000	118690.00	0.00	118690.00	11	5	318	958	0.331941544885177	0.128116363143282	0.128116363143282	false	false	false
26fb0296-beac-4896-bdeb-acb02bed5b9b	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPX	SPX261218P05775000	put	5775.0000	2026-12-18	11.7000	11.7000	12.0000	7650.0000	10530.00	0.00	10530.00	9	5	63	2253	0.0279627163781625	0.331749115568814	0.331749115568814	false	false	false	true
eae0878e-7ba5-4505-b317-37564c9dc8d0	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	149.2000	148.5000	149.2000	7650.0000	134280.00	134280.00	0.00	9	5	524	6594	0.0794661813770094	0.13384342834366	0.13384342834366	false	false	false
da25da73-ae91-4726-a577-816650fa2d85	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	107.3000	107.3000	108.0000	7668.7900	128760.00	0.00	128760.00	12	5	259	958	0.27035490605428	0.128013128185391	0.128013128185391	false	false	false
584ae967-4b9c-4d37-b5a7-5e0f8c0dbdb8	2026-09-29 15:57	2026-09-29 15:57	2026-09-29 15:57	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	107.3000	107.3000	108.0000	7668.8100	214600.00	0.00	214600.00	20	7	247	958	0.257828810020877	0.128010777543796	0.128010777543796	false	false	false
0ffa54c1-a225-4d34-8f13-a0261d975647	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	107.3000	107.3000	108.0000	7668.7500	107300.00	0.00	107300.00	10	5	227	958	0.236951983298539	0.128017829451016	0.128017829451016	false	false	false
c6943a6e-238d-4d8c-918b-e54d273ae869	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPX	SPX261218C08550000	call	8550.0000	2026-12-18	6.2000	5.9000	6.2000	7668.1100	62000.00	62000.00	0.00	100	6	101	9955	0.0101456554495229	0.117520374572956	0.117520374572956	false	false	false	true