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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = GIS×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	pricenumeric

10ca66e2-e6a6-4d85-8f30-6ce8c0e9d809	2026-08-31 14:44	2026-08-31 14:44	2026-08-31 14:44	GIS	GIS261016P00042500	put	42.5000	2026-10-16	2.5000	2.4000	2.5500	41.6750	17750.00	15000.00	2750.00	71	9	294	306	0.96078431372549	0.366328165915148	0.366328165915148	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	19464345202.00	2026-09-23	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f394fd1b-2dae-4dc4-b53a-738ae67be4ec	2026-09-01 11:34	2026-09-01 11:34	2026-09-01 11:34	GIS	GIS260918P00037500	put	37.5000	2026-09-18	0.1400	0.1000	0.1500	41.3600	40132.00	39872.00	260.00	2870	8	2972	6598	0.450439527129433	0.328006635501808	0.328006635501808	false	false	false	true	false
d2c25d9c-6caf-4c2a-ae81-27a0da438609	2026-09-01 14:32	2026-09-01 14:32	2026-09-01 14:32	GIS	GIS270319C00045000	call	45.0000	2027-03-19	2.1600	2.1500	2.3000	41.0550	29143.00	0.00	29143.00	135	8	154	627	0.245614035087719	0.273546080328419	0.273546080328419	false	false	false	true	false
895192d3-ca64-40c8-ab25-d250a48a7d42	2026-09-02 11:13	2026-09-02 11:12	2026-09-02 11:12	GIS	GIS261016P00040000	put	40.0000	2026-10-16	1.3500	1.3000	1.4000	41.2500	16740.00	12555.00	4185.00	124	7	129	2249	0.0573588261449533	0.353743119405662	0.354081130573218	false	false	false	true	false
b883e4cf-f341-4e83-8f2a-0b584e2840f5	2026-09-03 09:47	2026-09-03 09:47	2026-09-03 09:47	GIS	GIS270115P00040000	put	40.0000	2027-01-15	3.6000	3.2000	3.6000	38.9600	19080.00	19080.00	0.00	53	5	63	1289	0.0488750969743988	0.356095607397214	0.356095607397214	false	false	false	true	false
9db70d43-cf7d-47b6-a3ca-50dbcdea5845	2026-09-03 09:55	2026-09-03 09:55	2026-09-03 09:55	GIS	GIS260918C00037500	call	37.5000	2026-09-18	1.7400	1.5000	1.7500	38.7100	15276.00	15276.00	0.00	88	6	253	5086	0.0497443963822257	0.313717257043662	0.313717257043662	false	false	false	true	false
c737c8c4-9d67-43d9-b1a6-8e8f8d6907bc	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	GIS	GIS261016C00040000	call	40.0000	2026-10-16	1.3500	1.2000	1.3500	39.0400	47790.00	47790.00	0.00	354	13	696	5866	0.118649846573474	0.316994684048235	0.316994684048235	false	false	false	true	false
2e6afff3-b207-4776-a129-72017cea0793	2026-09-03 10:38	2026-09-03 10:38	2026-09-03 10:38	GIS	GIS261016C00037500	call	37.5000	2026-10-16	2.5500	2.5000	2.6000	38.9100	51000.00	45900.00	5100.00	200	7	207	1680	0.123214285714286	0.314267782724577	0.314267782724577	false	false	false	true	false
76088f9a-2fff-40d2-b24b-7dce7b36abd8	2026-09-03 10:39	2026-09-03 10:39	2026-09-03 10:39	GIS	GIS270115P00040000	put	40.0000	2027-01-15	3.6000	3.6000	3.7000	38.9350	18000.00	0.00	18000.00	50	5	267	1289	0.207137315748642	0.354821266225052	0.354821266225052	false	false	false	true	false
440dd28e-2682-4c6f-a3f2-e2fa0c417794	2026-09-03 10:40	2026-09-03 10:40	2026-09-03 10:40	GIS	GIS270115P00040000	put	40.0000	2027-01-15	3.6100	3.6000	3.7000	38.9300	18054.00	0.00	18054.00	50	6	367	1289	0.284716834755625	0.354565873571454	0.354565873571454	false	false	false	true	false
c8e85b38-c0fc-4130-b84c-1b680cb11e88	2026-09-03 10:42	2026-09-03 10:41	2026-09-03 10:41	GIS	GIS270617P00037500	put	37.5000	2027-06-17	3.4000	3.3000	3.4000	38.9500	17340.00	17340.00	0.00	51	7	56	478	0.117154811715481	0.34767581237599	0.34767581237599	false	false	false	true	false
6f6310e1-1a22-49e0-a09b-5b92a1dad733	2026-09-03 11:38	2026-09-03 11:38	2026-09-03 11:38	GIS	GIS260918P00037500	put	37.5000	2026-09-18	0.4500	0.4000	0.5000	38.7500	13590.00	13545.00	0.00	302	302	769	4825	0.159378238341969	0.312812774911752	0.313879793984371	true	false	false	true	false
5987c009-1e69-467c-9bbf-08f758a25ca6	2026-09-03 11:52	2026-09-03 11:52	2026-09-03 11:52	GIS	GIS260918P00037500	put	37.5000	2026-09-18	0.4500	0.4000	0.4500	38.7600	11015.00	11015.00	0.00	245	242	1590	4825	0.329533678756477	0.315476913668095	0.314944992739203	true	false	false	true	false
cc71efda-af7d-462c-94bd-e51c8e362547	2026-09-03 13:29	2026-09-03 13:29	2026-09-03 13:29	GIS	GIS261016C00040000	call	40.0000	2026-10-16	1.3000	1.2500	1.3000	38.9500	19630.00	19630.00	0.00	151	11	1066	5866	0.181725196045005	0.315114763494464	0.315114763494464	false	false	false	true	false
84f0c096-118e-4c75-abf6-f4fa8d5a780d	2026-09-03 14:27	2026-09-03 14:27	2026-09-03 14:27	GIS	GIS261016C00037500	call	37.5000	2026-10-16	2.6500	2.6500	2.7500	39.1200	42422.00	0.00	42422.00	160	7	821	1680	0.488690476190476	0.307420410871092	0.307420410871092	false	false	false	true	false
070a2d2a-115d-4a44-b915-0571c1637b3e	2026-09-03 15:38	2026-09-03 15:38	2026-09-03 15:38	GIS	GIS261218P00037500	put	37.5000	2026-12-18	1.8000	1.7500	1.8000	39.2200	10980.00	10980.00	0.00	61	17	113	848	0.133254716981132	0.335170938699812	0.335170938699812	false	false	false	true	false
28ae14b7-0603-40a0-9caf-acfe8ea7721d	2026-09-04 11:57	2026-09-04 11:57	2026-09-04 11:57	GIS	GIS261218P00032500	put	32.5000	2026-12-18	0.5500	0.5500	0.6000	38.5790	23980.00	0.00	23980.00	436	11	437	1572	0.277989821882952	0.344331045913516	0.344331045913516	false	false	false	true	false
850bcec2-aa83-4f31-8f78-3a39ebdf5cfc	2026-09-04 13:06	2026-09-04 13:06	2026-09-04 13:06	GIS	GIS261016C00040000	call	40.0000	2026-10-16	1.1500	1.1000	1.1500	38.6950	17250.00	17250.00	0.00	150	7	345	6975	0.0494623655913978	0.311135349106686	0.311135349106686	false	false	false	true	false
fa6cbbfa-2b80-4168-8d21-792fa9801683	2026-09-04 13:22	2026-09-04 13:22	2026-09-04 13:22	GIS	GIS261218C00047500	call	47.5000	2026-12-18	0.4500	0.4000	0.5000	38.6000	27306.00	26766.00	540.00	610	50	612	2595	0.235838150289017	0.317863868503066	0.317863868503066	false	false	false	true	false
e7f257ca-af97-4686-b646-4cd04f3af6dc	2026-09-04 13:22	2026-09-04 13:22	2026-09-04 13:22	GIS	GIS261218C00045000	call	45.0000	2026-12-18	0.7500	0.7000	0.7500	38.6000	29925.00	29925.00	0.00	399	18	417	2507	0.16633426406063	0.309804093135795	0.309804093135795	false	false	false	true	false
d07b7a7d-1100-454e-8511-f010bba8bc26	2026-09-04 14:43	2026-09-04 14:42	2026-09-04 14:42	GIS	GIS261016P00037500	put	37.5000	2026-10-16	1.4500	1.3500	1.4500	38.4400	13775.00	13775.00	0.00	95	11	194	14377	0.0134937747791612	0.381482174946451	0.381482174946451	false	false	false	true	false
4a021f00-cd41-404d-9be2-12c15856ee67	2026-09-08 09:43	2026-09-08 09:43	2026-09-08 09:43	GIS	GIS261016C00042500	call	42.5000	2026-10-16	0.2500	0.2000	0.4000	37.0950	48000.00	47975.00	25.00	1920	35	2020	4472	0.45169946332737	0.343138165018666	0.343138165018666	false	false	false	true	false
a1bfd346-723d-4c65-9f12-ac11295262b5	2026-09-08 10:23	2026-09-08 10:23	2026-09-08 10:23	GIS	GIS261016C00037500	call	37.5000	2026-10-16	1.5100	1.4500	1.5500	37.1550	16170.00	15420.00	0.00	107	5	148	1678	0.0882002383790226	0.343175011842601	0.334811301057768	false	false	false	true	false
c8accace-521f-4b6e-bfe7-839e44438541	2026-09-08 10:31	2026-09-08 10:31	2026-09-08 10:31	GIS	GIS260918C00040000	call	40.0000	2026-09-18	0.1500	0.1500	0.2000	37.2300	25866.00	18.00	25848.00	1720	49	2036	12048	0.168990703851262	0.373630072479518	0.373630072479518	false	false	false	true	false
22c56d91-e128-4b87-aa28-05a25c96ee0a	2026-09-08 11:15	2026-09-08 11:15	2026-09-08 11:15	GIS	GIS261016C00035000	call	35.0000	2026-10-16	3.0200	3.0000	3.2000	37.2650	38708.00	0.00	38708.00	128	7	875	2816	0.310724431818182	0.33114421655507	0.33114421655507	false	false	false	true	false
334543bc-2104-4ac8-9eb1-ce51bbae7431	2026-09-08 11:25	2026-09-08 11:25	2026-09-08 11:25	GIS	GIS261218P00037500	put	37.5000	2026-12-18	2.7500	2.7000	2.7500	37.2200	25850.00	25850.00	0.00	94	23	112	942	0.118895966029724	0.3616977054879	0.3616977054879	false	false	false	true	false
bfccdad0-ca58-4490-981a-791786f6ed1a	2026-09-08 14:08	2026-09-08 14:07	2026-09-08 14:07	GIS	GIS261016P00037500	put	37.5000	2026-10-16	2.1500	2.0500	2.2000	37.0100	41495.00	41065.00	215.00	193	41	330	14459	0.0228231551282938	0.413276665396852	0.413276665396852	false	false	false	true	false
bbe32bd0-70c1-47ba-8d84-68dae701d7f9	2026-09-08 15:13	2026-09-08 15:13	2026-09-08 15:13	GIS	GIS270115P00037500	put	37.5000	2027-01-15	2.9500	2.8500	2.9500	37.6300	45135.00	45135.00	0.00	153	26	195	3556	0.0548368953880765	0.367137570960953	0.367137570960953	false	false	false	true	false
d83f1591-4488-4e7a-a01a-7cb10628f3d7	2026-09-09 10:31	2026-09-09 10:31	2026-09-09 10:31	GIS	GIS261016P00037500	put	37.5000	2026-10-16	1.8500	1.8000	1.9000	37.0000	36253.00	36068.00	0.00	196	41	202	14521	0.0139108876799119	0.409707873106686	0.409707873106686	false	false	false	true	false
71abad29-6ec7-4867-a6ed-4ed0a3864c0f	2026-09-09 11:11	2026-09-09 11:11	2026-09-09 11:11	GIS	GIS261016P00035000	put	35.0000	2026-10-16	0.9000	0.8000	0.9000	37.2100	22230.00	22230.00	0.00	247	23	334	3217	0.103823437985701	0.402591407730587	0.402591407730587	false	false	false	true	false
ff3a6a38-027d-44af-97a8-494ddcc51721	2026-09-09 11:17	2026-09-09 11:17	2026-09-09 11:17	GIS	GIS270416P00037500	put	37.5000	2027-04-16	3.8000	3.6000	3.9000	37.2350	38000.00	6840.00	31160.00	100	6	102	27	3.77777777777778	0.362472128417604	0.362472128417604	false	false	false	true	false
473f187a-a662-43c8-9e10-edae1eb892f3	2026-09-09 13:42	2026-09-09 13:42	2026-09-09 13:42	GIS	GIS261218P00037500	put	37.5000	2026-12-18	2.7500	2.7000	2.7500	37.2250	14850.00	14850.00	0.00	54	9	61	1014	0.0601577909270217	0.363656445285511	0.363656445285511	false	false	false	true	false
54ad2e77-158a-4028-a0cc-8ed00b4e43e2	2026-09-09 14:11	2026-09-09 14:11	2026-09-09 14:11	GIS	GIS260918C00035000	call	35.0000	2026-09-18	2.5000	2.4000	2.5000	37.2800	11250.00	11250.00	0.00	45	5	48	3681	0.013039934800326	0.403873727855814	0.403873727855814	false	false	false	true	false
f0ec80be-ccb4-4558-968e-26f04e8295c2	2026-09-10 09:49	2026-09-10 09:49	2026-09-10 09:49	GIS	GIS261016P00035000	put	35.0000	2026-10-16	1.2000	1.1000	1.2000	36.2815	49440.00	49440.00	0.00	412	33	456	3660	0.124590163934426	0.409010249960565	0.409010249960565	false	false	false	true	false
186e3d1e-a63b-4715-8396-1c842c8e06c5	2026-09-10 10:35	2026-09-10 10:34	2026-09-10 10:34	GIS	GIS261016P00035000	put	35.0000	2026-10-16	1.2000	1.1000	1.2500	36.2850	42120.00	42000.00	120.00	351	31	825	3660	0.225409836065574	0.410553859965591	0.409302587319245	false	false	false	true	false
18bff3e5-9f94-4b49-8459-ce47f315b8c9	2026-09-10 11:40	2026-09-10 11:40	2026-09-10 11:40	GIS	GIS261016C00035000	call	35.0000	2026-10-16	2.2500	2.2000	2.3000	36.1400	45000.00	36900.00	8100.00	200	12	204	3094	0.0659340659340659	0.345354434103918	0.343808791955493	true	false	false	true	false
b2113c5a-f000-47d3-91ba-d5c301f5d514	2026-09-10 11:44	2026-09-10 11:44	2026-09-10 11:44	GIS	GIS270115P00035000	put	35.0000	2027-01-15	2.4000	2.3000	2.4000	36.1100	34800.00	34800.00	0.00	145	19	160	3067	0.052168242582328	0.37787656395173	0.37787656395173	false	false	false	true	false
3cea0941-8404-4040-b682-40e68d71ce57	2026-09-10 14:30	2026-09-10 14:30	2026-09-10 14:30	GIS	GIS261016P00035000	put	35.0000	2026-10-16	1.3500	1.3000	1.3500	35.9050	43335.00	43335.00	0.00	321	38	1282	3660	0.350273224043716	0.411553438769438	0.411553438769438	false	false	false	true	false
5c5ab239-34c0-4bca-a699-2a07e6ff7ed4	2026-09-11 11:20	2026-09-11 11:19	2026-09-11 11:19	GIS	GIS261218C00037500	call	37.5000	2026-12-18	1.7000	1.6500	1.7500	35.6400	74280.00	72580.00	0.00	437	15	450	1649	0.272892662219527	0.313491173193895	0.313491173193895	false	false	false	true	false
baee7c8f-8996-412c-b0fb-ad131860050f	2026-09-11 12:23	2026-09-11 12:23	2026-09-11 12:23	GIS	GIS260918C00035000	call	35.0000	2026-09-18	1.3000	1.1500	1.3000	35.8750	13000.00	13000.00	0.00	100	5	210	3763	0.0558065373372309	0.391758531902546	0.391758531902546	false	false	false	true	false
c58fbc5f-a9bf-4058-b32b-c4b924c7fd68	2026-09-11 14:07	2026-09-11 14:07	2026-09-11 14:07	GIS	GIS261218P00035000	put	35.0000	2026-12-18	2.0700	2.0500	2.1500	35.8200	207000.00	0.00	123000.00	1000	2	1061	2776	0.382204610951009	0.365790886790141	0.365790886790141	false	true	false	true	false
94a739b6-d61f-4cb7-8739-3bbde44409d6	2026-09-11 14:41	2026-09-11 14:41	2026-09-11 14:41	GIS	GIS261016P00035000	put	35.0000	2026-10-16	1.4000	1.3500	1.4000	35.6950	14560.00	14560.00	0.00	104	23	591	4392	0.134562841530055	0.40963113653126	0.40963113653126	false	false	false	true	false
41a04c18-8f21-49f1-9b48-6b49059a0019	2026-09-14 10:32	2026-09-14 10:32	2026-09-14 10:32	GIS	GIS270115P00037500	put	37.5000	2027-01-15	3.4000	3.3000	3.4000	36.6900	23120.00	23120.00	0.00	68	10	73	3640	0.0200549450549451	0.381918064412676	0.381918064412676	false	false	false	true	false
e7995582-4f55-4668-879e-2a07dc316a98	2026-09-14 10:41	2026-09-14 10:41	2026-09-14 10:41	GIS	GIS261218C00037500	call	37.5000	2026-12-18	2.1000	2.1000	2.3000	36.8450	31500.00	0.00	31500.00	150	11	156	2108	0.0740037950664137	0.295814873439662	0.295814873439662	false	false	false	true	false
1a669439-a5bc-4838-8e5d-23ef5540fe85	2026-09-14 11:36	2026-09-14 11:36	2026-09-14 11:36	GIS	GIS270115C00042500	call	42.5000	2027-01-15	0.9500	0.9000	1.0000	36.6000	11590.00	11115.00	0.00	122	11	124	1411	0.0878809355067328	0.314829645300159	0.314829645300159	false	false	false	true	false
7544b965-9410-4329-82ba-61302a339d13	2026-09-14 11:42	2026-09-14 11:42	2026-09-14 11:42	GIS	GIS270917P00032500	put	32.5000	2027-09-17	2.6500	2.5000	2.7500	36.7202	21995.00	18020.00	3975.00	83	7	83	458	0.181222707423581	0.370922892590831	0.370922892590831	false	false	false	true	false
eb731579-86d8-4587-8345-a7931dafe759	2026-09-14 12:16	2026-09-14 12:16	2026-09-14 12:16	GIS	GIS261218P00037500	put	37.5000	2026-12-18	2.9500	2.9500	3.1000	36.7550	18291.00	0.00	18291.00	62	10	84	1042	0.0806142034548944	0.369864293856636	0.369864293856636	false	false	false	true	false
4aa348e7-9ba3-472c-9cdc-532f7b0a9e87	2026-09-14 13:22	2026-09-14 13:22	2026-09-14 13:22	GIS	GIS270115C00042500	call	42.5000	2027-01-15	1.0000	0.9500	1.0000	36.6000	28700.00	28700.00	0.00	287	11	516	1411	0.365698086463501	0.322073813357955	0.322073813357955	false	false	false	true	false
fa417337-c8b8-469d-95e3-cd75bb5c35fe	2026-09-14 13:46	2026-09-14 13:46	2026-09-14 13:46	GIS	GIS270115C00042500	call	42.5000	2027-01-15	1.0500	0.9500	1.0500	36.5550	40950.00	40950.00	0.00	390	9	926	1411	0.656272147413182	0.330963038211128	0.330963038211128	false	false	false	true	false
559fac80-799a-45cd-9f15-e79d7a87a2df	2026-09-14 13:47	2026-09-14 13:47	2026-09-14 13:47	GIS	GIS270115C00042500	call	42.5000	2027-01-15	1.0500	0.9500	1.0500	36.5500	15434.00	15434.00	0.00	147	11	1541	1411	1.0921332388377	0.329725111056867	0.331155070425047	false	false	false	true	false