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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T13:57:37.705940Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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
45993d16-eb4a-47d1-8364-e45a42ae820d	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	148.6000	148.5000	148.6000	7669.7600	237760.00	237760.00	0.00	16	5	419	6594	0.0635426144980285	0.133633544561509	0.133633544561509	false	false	false	true
8cbad09c-6a58-42b5-989d-9f5e7883744e	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	148.9000	148.7000	149.1000	7670.1500	327580.00	148900.00	134010.00	22	7	402	6594	0.0609645131938126	0.133714588166809	0.133714588166809	false	false	false	true
3624a560-a453-4c05-a25a-a6ad26971209	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	107.6000	107.6000	108.4000	7670.1900	204440.00	0.00	204440.00	19	5	110	958	0.11482254697286	0.127999585163573	0.127999585163573	false	false	false	true
0bcdc295-1e38-4242-9e61-57da831ec354	2026-09-29 15:51	2026-09-29 15:51	2026-09-29 15:51	SPX	SPX261218P07400000	put	7400.0000	2026-12-18	104.1000	103.5000	104.1000	7673.4500	770340.00	770340.00	0.00	74	5	2970	33034	0.0899073681661319	0.169241408110865	0.169241408110865	false	false	false	true
5eefc119-ec42-4c1f-aac6-ab313b3abb0c	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	20.7000	20.6000	20.9000	7650.0000	22770.00	0.00	22770.00	11	9	558	27856	0.0200315910396324	0.275713508216619	0.275713508216619	false	false	false	true
4dcd76a0-6063-4676-a045-c64184a347e9	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	198.0000	197.5000	198.1000	7655.0000	2376000.00	0.00	0.00	120	22	1287	1695	0.75929203539823	0.133777673935399	0.133777673935399	false	false	false	true
23de4281-638b-4df1-b940-384e8fa96de2	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	198.0000	197.5000	198.2000	7655.0000	2376000.00	0.00	0.00	120	22	1282	1609	0.796768178993163	0.142645642394481	0.142645642394481	false	false	false	true
a944873b-b5b3-47b7-a47e-0c584c836b7a	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	198.1000	198.4000	199.0000	7655.0000	336770.00	0.00	0.00	17	6	1162	1609	0.722187694220012	0.142348698197749	0.142348698197749	false	false	false	true
a385d46d-708e-4cfc-8f8a-593ce94cc0fc	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	198.1000	197.3000	198.0000	7655.0000	336770.00	0.00	0.00	17	5	1167	1695	0.688495575221239	0.134249200232937	0.134249200232937	false	false	false	true
72b9e9ee-42c3-48df-92c5-b818b8781617	2026-09-29 15:36	2026-09-29 15:36	2026-09-29 15:36	SPX	SPX270319P06525000	put	6525.0000	2027-03-19	71.2900	71.2000	71.3000	7674.3800	114070.00	106950.00	7120.00	16	8	16	2544	0.00628930817610063	0.234658582124976	0.234658582124976	false	false	false	true
7a684bff-ffc1-44fc-87cf-5145f24aa30e	2026-09-29 15:29	2026-09-29 15:29	2026-09-29 15:29	SPX	SPX261218P06375000	put	6375.0000	2026-12-18	22.5000	22.5000	22.9000	7673.7900	13500.00	0.00	13500.00	6	5	7	4159	0.00168309689829286	0.267622933658008	0.267622933658008	false	false	false	true
5ff40745-0f73-4439-beb3-c6b04f96316e	2026-09-29 15:29	2026-09-29 15:29	2026-09-29 15:29	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	20.7000	20.6000	20.9000	7673.8700	18630.00	2070.00	16560.00	9	9	534	27856	0.0191700172314762	0.275761678796232	0.275761678796232	false	false	false	true
ef38e89c-9438-47b8-a703-a098641461bb	2026-09-29 15:26	2026-09-29 15:26	2026-09-29 15:26	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	197.7000	197.6000	198.3000	7655.0000	118620.00	0.00	0.00	6	6	945	1609	0.587321317588564	0.142262693757975	0.142262693757975	false	false	false	true
d652b811-c964-45e2-9a2a-6d536fc062eb	2026-09-29 15:26	2026-09-29 15:26	2026-09-29 15:26	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	197.7000	197.3000	197.9000	7655.0000	138390.00	0.00	0.00	7	5	951	1695	0.561061946902655	0.133758010859255	0.133758010859255	false	false	false	true
01fcdb58-b5b1-4066-968e-37da71a2e2e1	2026-09-29 15:03	2026-09-29 15:03	2026-09-29 15:03	SPX	SPX261218P06810000	put	6810.0000	2026-12-18	39.6000	39.6000	40.0000	7678.6400	31680.00	0.00	31680.00	8	5	133	73	1.82191780821918	0.22428494435112	0.22428494435112	true	false	false	true
6967362b-4c36-4c82-bd99-e6db17ea43e8	2026-09-29 15:02	2026-09-29 15:02	2026-09-29 15:02	SPX	SPX270319P07250000	put	7250.0000	2027-03-19	152.5000	152.5000	153.3000	7678.1300	76250.00	0.00	76250.00	5	5	566	3934	0.143873919674631	0.18444668010212	0.18444668010212	true	false	false	true
b20afa38-3467-4535-972b-6e1e9cb234c6	2026-09-29 15:00	2026-09-29 15:00	2026-09-29 15:00	SPX	SPX270319P07250000	put	7250.0000	2027-03-19	152.6000	152.6000	153.2000	7678.0900	76300.00	0.00	76300.00	5	5	511	3934	0.129893238434164	0.184500864846369	0.184500864846369	true	false	false	true
14bb9d27-5776-497a-9d39-eeaa92e10f2f	2026-09-29 14:56	2026-09-29 14:56	2026-09-29 14:56	SPX	SPX270917P07800000	put	7800.0000	2027-09-17	412.1000	412.1000	413.3000	7676.2400	824200.00	0.00	824200.00	20	5	32	1651	0.0193821926105391	0.172776632187007	0.172776632187007	false	false	false	true
50bd7973-148a-4944-83f8-24072e178a4e	2026-09-29 14:31	2026-09-29 14:31	2026-09-29 14:31	SPX	SPX261120P06510000	put	6510.0000	2026-11-20	14.0000	13.7000	14.0000	7645.0000	70000.00	70000.00	0.00	50	6	50	6	8.33333333333333	0.268859314381537	0.268859314381537	false	false	false	true
adeb67b4-7f9e-4a1d-94d3-8d6a64b4c61f	2026-09-29 14:13	2026-09-29 14:13	2026-09-29 14:13	SPX	SPX271217P07000000	put	7000.0000	2027-12-17	260.0000	258.6000	260.9000	7662.9500	572000.00	26000.00	546000.00	22	7	84	108906	0.000771307365985345	0.211888568922251	0.211888568922251	false	false	false	true
ef6b76aa-860b-46ec-934b-3c246a207cfc	2026-09-29 14:12	2026-09-29 14:12	2026-09-29 14:12	SPX	SPX270115P06625000	put	6625.0000	2027-01-15	46.5000	46.4000	46.9000	7660.0800	65100.00	0.00	65100.00	14	5	14	1490	0.00939597315436242	0.234197442789725	0.234197442789725	false	false	false	true
9f0227b2-3a38-411a-a69f-3b8de7af3bdc	2026-09-29 14:12	2026-09-29 14:12	2026-09-29 14:12	SPX	SPX261218P06800000	put	6800.0000	2026-12-18	41.1000	41.1000	41.5000	7660.0600	102750.00	0.00	102750.00	25	6	576	25793	0.0223316403675416	0.225583396692506	0.225583396692506	false	false	false	true