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

1869b24b-6b7e-4090-9051-e33a9d79a694	2026-10-01 10:09	2026-10-01 10:09	2026-10-01 10:09	SPX	SPX261120P06150000	put	6150.0000	2026-11-20	9.6000	9.6000	10.0000	7620.0000	24000.00	0.00	24000.00	25	6	97	5428	0.0178703021370671	0.320961586481359	0.320961586481359	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T14:10:48.155850Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
318c4156-c54a-4544-a5fc-e458babc1555	2026-10-01 10:09	2026-10-01 10:08	2026-10-01 10:08	SPX	SPX261120P06200000	put	6200.0000	2026-11-20	10.2000	10.2000	10.7000	7615.0000	25500.00	0.00	25500.00	25	7	99	7696	0.0128638253638254	0.314306713355885	0.314306713355885	false	false	false	true
dcd59214-36c1-4955-a701-9ad59880168b	2026-10-01 10:04	2026-10-01 10:04	2026-10-01 10:04	SPX	SPX261218P07500000	put	7500.0000	2026-12-18	142.9000	142.5000	143.5000	7632.5600	14290000.00	0.00	0.00	1000	11	1125	36862	0.0305192338994086	0.164879889366531	0.164879889366531	false	false	false	true
60973326-9239-46ba-b2ff-7349879f2303	2026-10-01 10:04	2026-10-01 10:04	2026-10-01 10:04	SPX	SPX261218C07710000	call	7710.0000	2026-12-18	193.0000	191.8000	192.9000	7632.5600	12545000.00	0.00	0.00	650	11	682	3734	0.182645956079272	0.14007428242332	0.14007428242332	false	false	false	true
428083e3-1b21-4651-bc59-dc69ba0364d0	2026-10-01 10:04	2026-10-01 10:04	2026-10-01 10:04	SPX	SPX261218P07710000	put	7710.0000	2026-12-18	213.0000	212.4000	213.6000	7632.5600	13845000.00	0.00	0.00	650	11	688	3816	0.180293501048218	0.148209964069164	0.148209964069164	false	false	false	true
daf9280b-539c-46b7-805a-248d252cdb46	2026-10-01 10:01	2026-10-01 10:01	2026-10-01 10:01	SPX	SPX261016P07250000	put	7250.0000	2026-10-16	13.7000	13.3000	13.7000	7633.2000	21920.00	21920.00	0.00	16	5	30	11839	0.00253399780386857	0.201181468299383	0.201181468299383	false	false	false	true
1d03576e-705f-4e9c-92a2-c64694ba28c9	2026-10-01 09:56	2026-10-01 09:56	2026-10-01 09:56	SPX	SPX261016C07750000	call	7750.0000	2026-10-16	44.3000	43.6000	44.3000	7662.4000	53160.00	53160.00	0.00	12	5	343	13485	0.0254356692621431	0.121908465018362	0.121908465018362	false	false	false	true
7876e70d-5e6c-4ea0-96ce-1561c0f9d33b	2026-10-01 09:56	2026-10-01 09:55	2026-10-01 09:55	SPX	SPX261016C07750000	call	7750.0000	2026-10-16	44.3000	43.6000	44.3000	7662.4000	53160.00	53160.00	0.00	12	5	331	13485	0.0245457916203189	0.121908465018362	0.121908465018362	false	false	false	true
e5f8f042-7ad9-4c4c-bb27-f1a8aa78892e	2026-10-01 09:51	2026-10-01 09:51	2026-10-01 09:51	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	207.0000	207.6000	208.5000	7660.5500	641700.00	0.00	0.00	31	7	31	3082	0.0100584036340039	0.144600962750775	0.144600962750775	false	false	false	true
b7700cc9-7872-47cb-a364-f46ab6638fa3	2026-10-01 09:51	2026-10-01 09:51	2026-10-01 09:51	SPX	SPX271217P05700000	put	5700.0000	2027-12-17	104.9400	104.3000	105.4000	7660.5500	4197600.00	0.00	0.00	400	7	402	4909	0.0818904053778774	0.26811815483741	0.26811815483741	false	false	false	true
b0ca3620-19fd-4f90-833d-ae2f53abd2fe	2026-10-01 09:51	2026-10-01 09:51	2026-10-01 09:51	SPX	SPX261218P04900000	put	4900.0000	2026-12-18	5.2000	5.1000	5.4000	7660.5500	208000.00	0.00	0.00	400	7	400	11836	0.0337952010814464	0.438121183709942	0.438121183709942	false	false	false	true
aa555936-6bcc-4cee-907f-886c6e18d30a	2026-10-01 09:51	2026-10-01 09:51	2026-10-01 09:51	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	191.0000	190.4000	191.1000	7660.5500	592100.00	0.00	0.00	31	7	31	3086	0.0100453661697991	0.137051104455173	0.137051104455173	false	false	false	true
85f0662c-35a5-4e9f-ab36-b9523684794f	2026-10-01 09:48	2026-10-01 09:47	2026-10-01 09:47	SPX	SPX261016P07550000	put	7550.0000	2026-10-16	43.5000	43.1000	43.7000	7640.0000	65250.00	39150.00	0.00	15	5	16	6476	0.00247066090179123	0.150163237209376	0.150163237209376	false	false	false	true
c7df5692-b77a-4d3d-a1af-5d8d69242aa8	2026-10-01 09:43	2026-10-01 09:43	2026-10-01 09:43	SPX	SPX261218P06700000	put	6700.0000	2026-12-18	36.3000	36.3000	36.7000	7665.7100	762300.00	0.00	762300.00	210	6	4352	26801	0.162382000671617	0.23979104693562	0.23979104693562	true	false	false	true
f2370d14-1bfe-45ff-9270-fe8917154de0	2026-10-01 09:38	2026-10-01 09:38	2026-10-01 09:38	SPX	SPX270115P05075000	put	5075.0000	2027-01-15	10.6000	10.3000	10.6000	7655.0000	10600.00	10600.00	0.00	10	5	10	522	0.0191570881226054	0.392337287827914	0.392337287827914	false	false	false	true
6ec275f3-24ec-4a97-a53d-1e926d345f88	2026-10-01 09:37	2026-10-01 09:37	2026-10-01 09:37	SPX	SPX261218P07720000	put	7720.0000	2026-12-18	193.1000	192.0000	193.0000	7675.0000	8689500.00	0.00	0.00	450	10	450	3804	0.118296529968454	0.144991397942133	0.144991397942133	false	false	false	true
03061419-c334-453f-b07f-628770123202	2026-10-01 09:37	2026-10-01 09:37	2026-10-01 09:37	SPX	SPX261218C07720000	call	7720.0000	2026-12-18	207.6000	208.2000	209.2000	7675.0000	9342000.00	0.00	0.00	450	11	450	3926	0.114620478858889	0.138272309923832	0.138272309923832	false	false	false	true
805ff91f-291f-4e0d-ada1-27215f557314	2026-09-30 16:21	2026-09-30 16:16	2026-09-30 16:16	SPX	SPX261218P07720000	put	7720.0000	2026-12-18	200.0000	196.6000	198.3000	7630.0000	600000.00	0.00	0.00	30	7	314	3578	0.0877585243152599	0.141662092091687	0.141662092091687	false	false	false	true
71333be3-cca9-44b2-a008-618039fb9f52	2026-09-30 16:21	2026-09-30 16:16	2026-09-30 16:16	SPX	SPX261218C07720000	call	7720.0000	2026-12-18	198.0000	199.0000	200.4000	7630.0000	594000.00	0.00	0.00	30	7	302	3687	0.0819094114456198	0.138682972497957	0.138682972497957	false	false	false	true
9daad3f8-e677-414f-9ed6-61bc8085f4e5	2026-09-30 16:16	2026-09-30 16:15	2026-09-30 16:15	SPX	SPX261120P07600000	put	7600.0000	2026-11-20	122.6300	119.5000	121.4000	7630.0000	24526000.00	0.00	0.00	2000	13	5295	10710	0.494397759103641	0.146554300579175	0.146554300579175	false	false	false	true
5158b9e1-9d04-4832-80f8-94d2aff05ceb	2026-09-30 16:16	2026-09-30 16:15	2026-09-30 16:15	SPX	SPX261218C07715000	call	7715.0000	2026-12-18	200.5000	201.6000	203.5000	7630.0000	26065000.00	0.00	0.00	1300	13	1824	1266	1.44075829383886	0.1387307699393	0.1387307699393	false	false	false	true
1a6074e6-99ce-4242-972b-5228610280e8	2026-09-30 16:16	2026-09-30 16:15	2026-09-30 16:15	SPX	SPX261218P07715000	put	7715.0000	2026-12-18	198.5000	194.7000	197.1000	7630.0000	25805000.00	0.00	0.00	1300	12	1824	1188	1.53535353535354	0.142383811517721	0.142383811517721	false	false	false	true
0b021263-c445-4e88-b7d5-2a5aaa570da1	2026-09-30 16:16	2026-09-30 16:15	2026-09-30 16:15	SPX	SPX270319C08200000	call	8200.0000	2027-03-19	124.6300	125.1000	126.7000	7630.0000	24926000.00	0.00	0.00	2000	12	2324	9779	0.23765211166786	0.128802613872781	0.128802613872781	false	false	false	true
d2ec9a17-1b0b-4bbb-aa08-ecec80448e68	2026-09-30 16:08	2026-09-30 16:08	2026-09-30 16:08	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	206.0000	205.4000	206.6000	7630.0000	14420000.00	0.00	0.00	700	9	1035	2525	0.40990099009901	0.1404735873316	0.1404735873316	false	false	false	true
0b7c1d1d-b603-44f3-b1d8-95b06d745677	2026-09-30 16:08	2026-09-30 16:08	2026-09-30 16:08	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	187.2000	187.7000	188.9000	7630.0000	13104000.00	0.00	0.00	700	9	1032	2561	0.40296759078485	0.136132210822311	0.136132210822311	false	false	false	true
8e1059b9-6ad8-4fb0-9982-4349931d589d	2026-09-30 16:03	2026-09-30 16:03	2026-09-30 16:03	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	205.0000	207.0000	209.6000	7630.0000	6150000.00	0.00	0.00	300	6	335	2525	0.132673267326733	0.139919881595934	0.139919881595934	false	false	false	true
2e8af831-4dcb-48e1-ab88-f04625b7aa47	2026-09-30 16:03	2026-09-30 16:03	2026-09-30 16:03	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	189.0000	184.0000	186.5000	7630.0000	5670000.00	0.00	0.00	300	6	332	2561	0.129636860601328	0.137247541943438	0.137247541943438	false	false	false	true
cee851f3-f18c-4772-a7a7-ddaf9f5b1137	2026-09-30 16:00	2026-09-30 15:59	2026-09-30 15:59	SPX	SPX261016P06000000	put	6000.0000	2026-10-16	0.9000	0.8500	1.0000	7630.0000	54000.00	0.00	54000.00	600	6	1010	31280	0.0322890025575448	0.448485916578372	0.448485916578372	false	true	false	true
5c4e0dc4-af18-4671-8211-4312c43246ad	2026-09-30 16:00	2026-09-30 15:59	2026-09-30 15:59	SPX	SPX261016P06000000	put	6000.0000	2026-10-16	0.9000	0.8000	1.0000	7630.0000	36000.00	0.00	0.00	400	2	410	31280	0.0131074168797954	0.448525890118785	0.448525890118785	false	true	false	true
a8f9976f-80ad-4ff8-ae52-975a76b4f1b5	2026-09-30 15:58	2026-09-30 15:58	2026-09-30 15:58	SPX	SPX270617C08575000	call	8575.0000	2027-06-17	119.0000	119.0000	119.9000	7664.5500	95200.00	0.00	95200.00	8	5	532	1111	0.478847884788479	0.129716134697042	0.129716134697042	false	false	false	true
6113270b-5bf7-4a82-939b-a3c954351793	2026-09-30 15:58	2026-09-30 15:58	2026-09-30 15:58	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	149.9000	149.3000	149.9000	7665.8100	74950.00	74950.00	0.00	5	5	2651	7352	0.360582154515778	0.134943776081529	0.134943776081529	false	false	false	true
d2a5c11a-3e53-4301-af29-1c3a98067da0	2026-09-30 15:57	2026-09-30 15:57	2026-09-30 15:57	SPX	SPX261218P06325000	put	6325.0000	2026-12-18	22.3000	22.0000	22.3000	7667.8200	17840.00	17840.00	0.00	8	5	2408	3664	0.657205240174673	0.276503180719023	0.276503180719023	false	false	false	true
367c12ca-e90a-4e75-8940-16686f5e64e9	2026-09-30 15:57	2026-09-30 15:57	2026-09-30 15:57	SPX	SPX270617C08575000	call	8575.0000	2027-06-17	119.9000	119.9000	120.9000	7667.8200	155870.00	0.00	155870.00	13	6	440	1111	0.396039603960396	0.129754116632467	0.129754116632467	false	false	false	true
7e279efa-877e-4497-ab55-8ef0cd199bb7	2026-09-30 15:57	2026-09-30 15:57	2026-09-30 15:57	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	150.2000	149.7000	150.2000	7667.1900	120160.00	120160.00	0.00	8	5	2592	7352	0.352557127312296	0.134919313330345	0.134919313330345	false	false	false	true
be973b0d-3bf8-4ad8-81c9-d1c3ce905729	2026-09-30 15:57	2026-09-30 15:57	2026-09-30 15:57	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	150.0000	149.5000	150.0000	7666.6100	225000.00	225000.00	0.00	15	5	2574	7352	0.350108813928183	0.134899397627945	0.134899397627945	false	false	false	true
9c3f9a3f-034a-49aa-ac5c-29d00978607b	2026-09-30 15:57	2026-09-30 15:57	2026-09-30 15:57	SPX	SPX270617C08575000	call	8575.0000	2027-06-17	119.6000	119.6000	120.4000	7667.0500	119600.00	0.00	119600.00	10	5	395	1111	0.355535553555356	0.129702684128286	0.129702684128286	false	false	false	true
8c643db3-4cce-4995-bfbd-87466cd48121	2026-09-30 15:57	2026-09-30 15:57	2026-09-30 15:57	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	21.7000	21.5000	21.7000	7667.6400	13020.00	13020.00	0.00	6	5	200	28678	0.00697398702838413	0.279230006738748	0.279230006738748	false	false	false	true
da16304a-b2f6-41bc-9baf-691d8df75d89	2026-09-30 15:56	2026-09-30 15:56	2026-09-30 15:56	SPX	SPX270617C08575000	call	8575.0000	2027-06-17	119.7000	119.7000	120.5000	7666.9500	179550.00	0.00	179550.00	15	5	363	1111	0.326732673267327	0.129763346295747	0.129763346295747	false	false	false	true
2782fe48-66a0-4d5a-958a-16153edc5496	2026-09-30 15:56	2026-09-30 15:56	2026-09-30 15:56	SPX	SPX261016P07550000	put	7550.0000	2026-10-16	40.1000	39.9000	40.5000	7667.1000	80200.00	0.00	80200.00	20	5	519	6236	0.0832264271969211	0.143027112493164	0.143027112493164	false	false	false	true
120587fa-c00d-479e-94e5-d02fda1ef811	2026-09-30 15:56	2026-09-30 15:56	2026-09-30 15:56	SPX	SPX270617C08575000	call	8575.0000	2027-06-17	119.8000	119.7000	119.9000	7667.0500	239600.00	0.00	203660.00	20	7	327	1111	0.294329432943294	0.129799608901305	0.129799608901305	false	false	false	true
16d34708-5a70-44b6-8399-e0037fc46cc0	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPX	SPX270617C08575000	call	8575.0000	2027-06-17	119.1000	119.1000	119.9000	7664.4000	190560.00	0.00	190560.00	16	5	273	1111	0.245724572457246	0.129782978800392	0.129782978800392	false	false	false	true
417217c2-2f3c-4254-b52d-cd1fc7ebed34	2026-09-30 15:54	2026-09-30 15:54	2026-09-30 15:54	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	21.7000	21.4000	21.7000	7669.6100	10850.00	10850.00	0.00	5	5	135	28678	0.00470744124415929	0.279497313491576	0.279497313491576	false	false	false	true
de39178b-7fef-47ec-9445-f2663d8ac273	2026-09-30 15:51	2026-09-30 15:51	2026-09-30 15:51	SPX	SPX261120C07925000	call	7925.0000	2026-11-20	61.1000	60.6000	61.4000	7650.0000	293280.00	293280.00	0.00	48	10	5232	1818	2.87788778877888	0.121080082373071	0.121080082373071	false	false	false	true
f6480a1a-3b06-499c-a469-af70553ede96	2026-09-30 15:42	2026-09-30 15:42	2026-09-30 15:42	SPX	SPX261016P06750000	put	6750.0000	2026-10-16	2.5500	2.3500	2.5500	7687.4200	293250.00	293250.00	0.00	1150	8	1150	7212	0.159456461453134	0.293948839666466	0.293948839666466	false	false	false	true
32848f55-77b3-482b-8a83-ae39d9fb09b2	2026-09-30 15:39	2026-09-30 15:39	2026-09-30 15:39	SPX	SPX270319P04650000	put	4650.0000	2027-03-19	14.9000	14.8000	15.1000	7687.5700	13410.00	1490.00	11920.00	9	6	105	1334	0.0787106446776612	0.391391237206568	0.391391237206568	false	false	false	true
4ca967bb-9e9e-4f1a-8e80-4345a8bc375d	2026-09-30 15:38	2026-09-30 15:38	2026-09-30 15:38	SPX	SPX261016P06920000	put	6920.0000	2026-10-16	3.3000	3.3000	3.5000	7687.7500	33000.00	0.00	33000.00	100	5	512	1891	0.270756213643575	0.255381793610767	0.255381793610767	false	false	false	true
d7d652c1-941e-4389-a49d-ae6eab2364de	2026-09-30 15:32	2026-09-30 15:32	2026-09-30 15:32	SPX	SPX271217P06900000	put	6900.0000	2027-12-17	238.9400	238.4000	240.2000	7691.7700	119470000.00	0.00	0.00	5000	18	5000	6512	0.767813267813268	0.216762580062156	0.216762580062156	false	false	false	true
7a45382c-494f-478f-ba3b-130b630c3b12	2026-09-30 15:32	2026-09-30 15:32	2026-09-30 15:32	SPX	SPX261218P07755000	put	7755.0000	2026-12-18	198.0000	198.1000	198.8000	7691.7700	4950000.00	0.00	0.00	250	12	3760	1795	2.09470752089136	0.14149994914676	0.14149994914676	false	false	false	true
3580bf45-9606-47bf-ab73-d6c0a0bafd99	2026-09-30 15:32	2026-09-30 15:32	2026-09-30 15:32	SPX	SPX271217P05800000	put	5800.0000	2027-12-17	108.2900	107.8000	109.1000	7691.7700	94753750.00	0.00	0.00	8750	12	8799	6251	1.40761478163494	0.262338071823739	0.262338071823739	false	false	false	true
0d5cb932-27a9-48bf-baaf-266013337e6c	2026-09-30 15:32	2026-09-30 15:32	2026-09-30 15:32	SPX	SPX261218C07755000	call	7755.0000	2026-12-18	193.3500	192.5000	193.4000	7691.7700	4833750.00	0.00	0.00	250	18	3773	1832	2.05949781659389	0.132784230288262	0.132784230288262	false	false	false	true