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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = GIS×

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

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	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-09-08T18:15:47.972880Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
f958f515-9542-4608-9157-ad4dcad500c9	2026-08-31 11:53	2026-08-31 11:53	2026-08-31 11:53	GIS	GIS260918C00037500	call	37.5000	2026-09-18	4.5000	4.4000	4.5000	41.8350	19350.00	19350.00	0.00	43	5	75	5197	0.0144314027323456	0.341011456637787	0.341011456637787	false	false	false	true
c6ccd4e8-8769-4831-a905-4cb5f4600f90	2026-08-28 12:09	2026-08-28 12:08	2026-08-28 12:08	GIS	GIS270319C00045000	call	45.0000	2027-03-19	2.2500	2.2500	2.3500	41.0700	10350.00	0.00	10350.00	46	6	193	426	0.453051643192488	0.278994778115179	0.278994778115179	false	false	false	true
971e8301-57ad-4ea0-8050-e22726b2dd16	2026-08-28 12:09	2026-08-28 12:08	2026-08-28 12:08	GIS	GIS270319C00045000	call	45.0000	2027-03-19	2.2500	2.2500	2.3500	41.1050	12600.00	0.00	12600.00	56	12	101	426	0.237089201877934	0.277788819009089	0.277788819009089	false	false	false	true
7966f749-f95f-4cf4-8be8-7e995fedae63	2026-08-28 12:09	2026-08-28 12:08	2026-08-28 12:08	GIS	GIS270319C00045000	call	45.0000	2027-03-19	2.2500	2.2500	2.3500	41.1000	10350.00	0.00	10350.00	46	6	147	426	0.345070422535211	0.277961154549485	0.277961154549485	false	false	false	true
6a967f6f-3db2-469f-8317-b6246afa9d3a	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	GIS	GIS261218C00045000	call	45.0000	2026-12-18	1.4500	1.4500	1.5000	41.4100	10295.00	0.00	10295.00	71	17	449	1654	0.271463119709794	0.285867311702402	0.285867311702402	false	false	false	true
ffc0d36e-4daa-4f8b-a493-f8e86ea2b7b5	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	GIS	GIS261016C00042500	call	42.5000	2026-10-16	1.4000	1.4000	1.4500	41.4250	11060.00	0.00	11060.00	79	12	419	3807	0.110060415024954	0.293811182228312	0.293811182228312	false	false	false	true
044a2f2c-ad97-43e6-a64a-28aec7c1de68	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	GIS	GIS261218C00045000	call	45.0000	2026-12-18	1.4500	1.4500	1.5500	41.4150	10150.00	0.00	10150.00	70	6	378	1654	0.228536880290206	0.285659281845048	0.285659281845048	false	false	false	true
6c68e619-1eac-41a6-8dff-39c527ae6a1d	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	GIS	GIS261016C00042500	call	42.5000	2026-10-16	1.4000	1.4000	1.4500	41.4300	10920.00	0.00	10920.00	78	6	340	3807	0.0893091673233517	0.293439642485573	0.293439642485573	false	false	false	true
925cde45-01b5-4730-990b-9c77fef94f99	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	GIS	GIS261016C00042500	call	42.5000	2026-10-16	1.4500	1.4000	1.5000	41.4501	10585.00	0.00	6815.00	73	10	242	3807	0.0635671132125033	0.30026581352614	0.30026581352614	true	false	false	true
7301d4d3-eebb-48d5-a70d-198e6e877916	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	GIS	GIS261218C00045000	call	45.0000	2026-12-18	1.5000	1.4500	1.5000	41.4501	11250.00	11250.00	0.00	75	8	281	1654	0.169891172914148	0.290026883083641	0.290026883083641	false	false	false	true
ac335f1d-4621-48d3-9aff-c3b6efffd285	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	GIS	GIS261016C00042500	call	42.5000	2026-10-16	1.4500	1.4500	1.5500	41.4800	11165.00	0.00	11165.00	77	14	155	3807	0.0407144733385868	0.29802455400156	0.29802455400156	false	false	false	true
75a37ac6-642a-46da-af05-86aa58126b8a	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	GIS	GIS261218C00045000	call	45.0000	2026-12-18	1.5000	1.5000	1.6000	41.5050	10650.00	0.00	10650.00	71	10	135	1654	0.0816203143893591	0.287722124546648	0.287722124546648	false	false	false	true
b51a0008-7a3a-4ed2-80ad-8d06f124c25b	2026-08-27 13:13	2026-08-27 13:13	2026-08-27 13:13	GIS	GIS261218P00040000	put	40.0000	2026-12-18	2.5500	2.4500	2.7000	40.4703	28305.00	28050.00	255.00	111	19	132	626	0.210862619808307	0.339366728002673	0.338440075104048	false	false	false	true
3544f1db-c53d-428d-893e-89fa5d47f3ab	2026-08-26 14:18	2026-08-26 14:18	2026-08-26 14:18	GIS	GIS260918C00040000	call	40.0000	2026-09-18	1.3500	1.2500	1.6000	40.2150	449688.00	7695.00	15528.00	3331	38	3473	7948	0.436965274282838	0.296284463355546	0.303807530816035	true	false	false	true
8e59c970-1d0f-43f4-b7fa-6c7e61590a68	2026-08-25 14:16	2026-08-25 14:16	2026-08-25 14:16	GIS	GIS260918C00040000	call	40.0000	2026-09-18	1.3000	1.2000	1.3000	40.0000	12480.00	12480.00	0.00	96	21	435	7875	0.0552380952380952	0.296041313256012	0.296041313256012	true	false	false	true
34e2d636-ee08-424c-9826-68fb361066c2	2026-08-25 14:11	2026-08-25 14:10	2026-08-25 14:10	GIS	GIS260918C00040000	call	40.0000	2026-09-18	1.2500	1.1500	1.2500	40.0000	21000.00	21000.00	0.00	168	16	299	7875	0.037968253968254	0.292291835981809	0.292291835981809	false	false	false	true
05c3caed-f7ab-48c1-88c4-e6754db3a881	2026-08-25 11:47	2026-08-25 11:47	2026-08-25 11:47	GIS	GIS270617C00045000	call	45.0000	2027-06-17	2.5500	2.5000	2.7500	39.9100	15542.00	9677.00	5865.00	61	6	65	557	0.116696588868941	0.275449242349946	0.275449242349946	false	false	false	true
65a340c2-cfdd-4e11-8f84-6ffe78f819d9	2026-08-24 12:35	2026-08-24 12:34	2026-08-24 12:34	GIS	GIS261016C00040000	call	40.0000	2026-10-16	2.4500	2.2500	2.4500	40.8250	24500.00	24500.00	0.00	100	10	205	6026	0.0340192499170262	0.307276502504446	0.307276502504446	false	false	false	true
f0a23469-370b-4116-92ce-ac2cf99c69d1	2026-08-24 09:37	2026-08-24 09:37	2026-08-24 09:37	GIS	GIS260918C00037500	call	37.5000	2026-09-18	3.5000	3.3000	3.6000	40.6300	17500.00	11550.00	3500.00	50	6	77	5223	0.0147424851617844	0.327853737073556	0.31781445521352	false	false	false	true
2c059564-8bff-4596-8ef3-a4ef268d8efc	2026-08-20 15:04	2026-08-20 15:04	2026-08-20 15:04	GIS	GIS270617P00040000	put	40.0000	2027-06-17	4.3000	4.3000	4.4000	39.9200	61490.00	0.00	61490.00	143	6	640	121	5.28925619834711	0.344420613670987	0.344420613670987	false	false	false	true
c2ff356c-2117-4ef0-9035-e4e170393b31	2026-08-20 14:12	2026-08-20 14:11	2026-08-20 14:11	GIS	GIS270617P00040000	put	40.0000	2027-06-17	4.3000	4.2000	4.4000	39.9600	37840.00	6020.00	18060.00	88	10	497	121	4.10743801652893	0.345559366569057	0.345559366569057	false	false	false	true
1629603f-4cc6-4862-95af-7b3b449cea77	2026-08-20 14:09	2026-08-20 14:09	2026-08-20 14:09	GIS	GIS270617P00040000	put	40.0000	2027-06-17	4.3000	4.3000	4.4000	39.9100	53750.00	0.00	53750.00	125	9	131	121	1.08264462809917	0.344135317747346	0.344135317747346	false	false	false	true
7bd5bade-3dee-44c3-b3a2-74e3acf78ab1	2026-08-20 10:41	2026-08-20 10:41	2026-08-20 10:41	GIS	GIS261218C00040000	call	40.0000	2026-12-18	2.5500	2.5000	2.6000	39.3150	10710.00	2550.00	7650.00	42	6	215	4517	0.0475979632499447	0.293020749857286	0.293020749857286	false	false	false	true
50b02a29-c79f-49ab-bf11-4bd478a4dcd5	2026-08-19 13:39	2026-08-19 13:39	2026-08-19 13:39	GIS	GIS261218C00040000	call	40.0000	2026-12-18	2.5500	2.5000	2.6000	39.4200	10965.00	0.00	4590.00	43	6	129	4401	0.0293115201090661	0.285074651006996	0.285074651006996	false	false	false	true
471c7ff0-b41a-45c3-b630-faafeebe008a	2026-08-19 12:48	2026-08-19 12:48	2026-08-19 12:48	GIS	GIS270617P00040000	put	40.0000	2027-06-17	4.7000	4.6000	5.0000	39.2850	48880.00	25850.00	23030.00	104	8	105	18	5.83333333333333	0.353937050386537	0.353937050386537	false	false	false	true
2bd068bf-37e1-4144-b233-50af12f746d6	2026-08-19 10:02	2026-08-19 10:02	2026-08-19 10:02	GIS	GIS270617C00050000	call	50.0000	2027-06-17	1.3500	1.3000	1.3500	39.3000	12285.00	12285.00	0.00	91	5	111	235	0.472340425531915	0.285137416583006	0.285137416583006	false	false	false	true
527e0a87-8f16-4bd6-90b8-a1245a912b43	2026-08-18 15:42	2026-08-18 15:41	2026-08-18 15:41	GIS	GIS261016C00040000	call	40.0000	2026-10-16	1.2500	1.2000	1.3000	38.2700	91125.00	250.00	90875.00	729	25	851	5541	0.153582385850929	0.303940887763461	0.303940887763461	false	false	false	true
060e26be-d391-4ca4-8feb-8ff99cf90a66	2026-08-18 14:07	2026-08-18 14:07	2026-08-18 14:07	GIS	GIS280121P00037500	put	37.5000	2028-01-21	4.9000	4.7000	5.0000	38.5450	36260.00	36260.00	0.00	74	6	127	771	0.164721141374838	0.365651104338546	0.365651104338546	false	false	false	true
5799e593-1e5f-4b1d-b92c-5d513ac97a8c	2026-08-18 13:03	2026-08-18 13:03	2026-08-18 13:03	GIS	GIS260918P00037500	put	37.5000	2026-09-18	0.8500	0.8000	0.8500	38.4900	13430.00	13430.00	0.00	158	31	239	6237	0.0383197049863717	0.302278715230579	0.302278715230579	false	false	false	true
0d4f294b-9664-4e2e-9f37-d1a4e57de1db	2026-08-17 15:30	2026-08-17 15:30	2026-08-17 15:30	GIS	GIS261016C00037500	call	37.5000	2026-10-16	2.3500	2.3500	2.4000	38.1410	10105.00	0.00	10105.00	43	5	139	2149	0.0646812470916705	0.308507907771739	0.308507907771739	false	false	false	true
258013dd-0e4d-47a9-81d5-8b96518d9c98	2026-08-17 14:15	2026-08-17 14:15	2026-08-17 14:15	GIS	GIS260918P00037500	put	37.5000	2026-09-18	0.8500	0.8000	0.8500	38.4600	26675.00	26675.00	0.00	314	24	4005	2375	1.68631578947368	0.295338036430316	0.295338036430316	false	false	false	true
f64d3f5f-ebbb-406f-9cb3-948f51509056	2026-08-17 13:45	2026-08-17 13:44	2026-08-17 13:44	GIS	GIS261016P00037500	put	37.5000	2026-10-16	1.6500	1.6000	1.6500	38.0000	11220.00	11220.00	0.00	68	11	140	1032	0.135658914728682	0.352991837112434	0.352991837112434	false	false	false	true