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 = IGV×

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

ca85ff74-7280-4d23-aa22-f47dc2ee9f84	2026-08-28 11:57	2026-08-28 11:57	2026-08-28 11:57	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7600	0.7600	1.0200	109.0000	31388.00	0.00	31388.00	413	19	5143	5034	1.02165276122368	0.298107228142843	0.298107228142843	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	14038397136.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
eb529d8f-6b74-4171-bd5c-3d2085873bff	2026-08-28 11:57	2026-08-28 11:57	2026-08-28 11:57	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7600	0.7600	0.8100	109.0000	16340.00	0.00	16340.00	215	13	4669	5034	0.927493047278506	0.298107228142843	0.298107228142843	false	false	false	true
c2017ff7-cfee-43b5-b407-2955af031cf9	2026-08-28 11:57	2026-08-28 11:56	2026-08-28 11:56	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7600	0.7600	0.8200	109.0000	14136.00	0.00	14136.00	186	12	4404	5034	0.874851013110846	0.29918082036731	0.29918082036731	false	false	false	true
0952c504-64bf-47c1-8f0f-73a85ea3ae18	2026-08-28 11:56	2026-08-28 11:56	2026-08-28 11:56	IGV	IGV260918C00120000	call	120.0000	2026-09-18	0.4300	0.4300	0.5000	109.0000	28294.00	0.00	28294.00	658	25	1120	5923	0.189093364848894	0.29922676417884	0.29922676417884	false	false	false	true
20e1ceab-5d72-4e67-9796-08d94c3e9e43	2026-08-28 11:56	2026-08-28 11:56	2026-08-28 11:56	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7600	0.7600	0.8300	109.0000	10944.00	0.00	10944.00	144	5	4218	5034	0.837902264600715	0.299716968086282	0.299716968086282	false	false	false	true
ee7e7585-6f95-461e-a961-2ede215cd447	2026-08-28 11:56	2026-08-28 11:56	2026-08-28 11:56	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7700	0.7700	1.0200	109.0000	51051.00	0.00	51051.00	663	6	4074	5034	0.809296781883194	0.300908366808942	0.300908366808942	false	false	false	true
029f9ee7-03d8-4238-8260-b4f5c564365f	2026-08-28 11:54	2026-08-28 11:54	2026-08-28 11:54	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7600	0.7300	0.7600	109.0000	11476.00	11476.00	0.00	151	11	2775	5034	0.551251489868891	0.305055059035277	0.305055059035277	true	false	false	true
83a52d67-bb1a-4949-bd25-0912231b0db8	2026-08-28 11:53	2026-08-28 11:53	2026-08-28 11:53	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7600	0.7600	0.8000	109.0000	20672.00	0.00	20672.00	272	5	2568	5034	0.510131108462455	0.306648338974495	0.306648338974495	false	false	false	true
4b281108-66e5-4696-8166-8f65f4de8d06	2026-08-28 11:53	2026-08-28 11:53	2026-08-28 11:53	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7600	0.7600	0.8000	109.0000	80788.00	0.00	80788.00	1063	12	2296	5034	0.456098529996027	0.306383049421332	0.306383049421332	false	false	false	true
8acb3439-1bd3-49d6-906a-a630ef38f112	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	IGV	IGV260904C00111000	call	111.0000	2026-09-04	1.3400	1.3300	1.4000	109.0000	13802.00	134.00	13668.00	103	13	198	298	0.664429530201342	0.300656443662031	0.300656443662031	true	false	false	true
2451bb6e-5d91-4aa8-a81e-7f6ab684c08b	2026-08-28 11:45	2026-08-28 11:45	2026-08-28 11:45	IGV	IGV261016P00100000	put	100.0000	2026-10-16	1.4000	1.4000	1.4600	109.0000	38220.00	0.00	38220.00	273	9	360	5951	0.0604940346160309	0.323826798375687	0.323826798375687	false	false	false	true
bb8c433f-e3d4-4de4-bd4b-95593a84af4f	2026-08-28 11:44	2026-08-28 11:44	2026-08-28 11:44	IGV	IGV260904C00110000	call	110.0000	2026-09-04	1.8400	1.8400	2.0700	109.0000	31648.00	0.00	31648.00	172	21	441	2490	0.17710843373494	0.303653778182185	0.303653778182185	true	false	false	true
c1b6bf3b-0193-4c00-9bf3-9172d3d8f01b	2026-08-28 11:40	2026-08-28 11:39	2026-08-28 11:39	IGV	IGV260918P00115000	put	115.0000	2026-09-18	6.1000	6.1000	6.1500	110.0000	17080.00	0.00	17080.00	28	6	29	9	3.22222222222222	0.307201705306444	0.307201705306444	false	false	false	true
c701b8fb-af97-4e22-a875-c41325fd1209	2026-08-28 11:35	2026-08-28 11:35	2026-08-28 11:35	IGV	IGV260828C00110000	call	110.0000	2026-08-28	0.6000	0.6000	0.6800	110.3650	79920.00	0.00	79920.00	1332	18	2085	7683	0.271378367825068	0.394414711118462	0.394414711118462	false	false	false	true
aee9b2b5-599b-4ccc-9835-eb85ff4ed691	2026-08-28 11:33	2026-08-28 11:33	2026-08-28 11:33	IGV	IGV260904P00105000	put	105.0000	2026-09-04	0.3300	0.3200	0.3300	110.3700	12573.00	12573.00	0.00	381	6	1924	3453	0.557196640602375	0.32922516460307	0.32922516460307	false	false	false	true
0e137e3d-93cb-4f68-ab63-26d8b70b5001	2026-08-28 11:33	2026-08-28 11:32	2026-08-28 11:32	IGV	IGV261120C00115000	call	115.0000	2026-11-20	5.0500	5.0500	5.2500	110.3300	10100.00	0.00	10100.00	20	5	150	2429	0.0617538081515027	0.313444948165999	0.313444948165999	false	false	false	true
569b4da4-71ac-482c-8d2b-c8b60cdc8ed3	2026-08-28 11:17	2026-08-28 11:17	2026-08-28 11:17	IGV	IGV260918P00104000	put	104.0000	2026-09-18	0.8700	0.8700	1.1300	110.1800	15225.00	0.00	15225.00	175	8	175	574	0.304878048780488	0.299647998577725	0.299647998577725	false	false	false	true
dbf263a8-a868-4a86-9c54-dc401f9a4a5e	2026-08-28 11:16	2026-08-28 11:16	2026-08-28 11:16	IGV	IGV260925C00116000	call	116.0000	2026-09-25	1.5500	1.5500	1.6100	110.2600	292020.00	0.00	292020.00	1884	12	1885	11	171.363636363636	0.290959864505293	0.290959864505293	false	false	false	true
26051d3f-cb22-442c-b520-e5f4dea2b458	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	IGV	IGV261002P00107000	put	107.0000	2026-10-02	2.6800	2.6800	3.3000	109.9350	15545.00	0.00	15545.00	58	17	59	1	59	0.309019428897119	0.309807468077195	false	false	false	true
a1622162-e63e-454f-a72b-31f5c2fda426	2026-08-28 10:57	2026-08-28 10:57	2026-08-28 10:57	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7600	0.7000	0.8000	109.7100	25536.00	25536.00	0.00	336	5	879	5034	0.1746126340882	0.305055059035277	0.305055059035277	false	false	false	true
0ad25baa-a5f9-41b8-bd18-90fbc1c42c30	2026-08-28 10:57	2026-08-28 10:57	2026-08-28 10:57	IGV	IGV260904P00107000	put	107.0000	2026-09-04	0.7700	0.6800	0.7700	109.6950	20944.00	20944.00	0.00	272	7	543	5034	0.107866507747318	0.306265308421097	0.306265308421097	false	false	false	true
d472df54-944b-4e17-8d96-6b9515a01a46	2026-08-28 10:47	2026-08-28 10:47	2026-08-28 10:47	IGV	IGV261002P00108000	put	108.0000	2026-10-02	3.2000	3.1500	3.9000	109.5300	14395.00	0.00	14395.00	45	14	50	1	50	0.305077113514158	0.301277822387792	true	false	false	true
9e88576f-99e6-4958-ba04-a094d562e451	2026-08-28 10:33	2026-08-28 10:33	2026-08-28 10:33	IGV	IGV261120C00120000	call	120.0000	2026-11-20	2.9900	2.7600	2.9900	109.1700	14950.00	14950.00	0.00	50	19	177	2579	0.0686312524234199	0.311390331107677	0.311390331107677	false	false	false	true
e648e24b-3160-4099-9cb7-a7f36e3287ba	2026-08-28 10:32	2026-08-28 10:32	2026-08-28 10:32	IGV	IGV260828C00109000	call	109.0000	2026-08-28	0.4500	0.4500	0.5400	108.9400	67680.00	0.00	67680.00	1504	12	1750	682	2.56598240469208	0.440313135294902	0.440313135294902	false	false	false	true
54f543b2-f5a2-4baf-99f7-a6cf293b357d	2026-08-28 10:28	2026-08-28 10:28	2026-08-28 10:28	IGV	IGV261218C00105000	call	105.0000	2026-12-18	10.2500	10.2500	10.4500	108.7778	50225.00	0.00	50225.00	49	9	124	6070	0.0204283360790774	0.318685884718479	0.318685884718479	false	false	false	true
77078f9b-a137-461d-a74e-b1960b3aaa0e	2026-08-28 10:06	2026-08-28 10:05	2026-08-28 10:05	IGV	IGV260904C00110000	call	110.0000	2026-09-04	1.3300	1.3300	1.7700	108.6600	10374.00	0.00	10374.00	78	6	143	2490	0.057429718875502	0.313631141381035	0.313631141381035	false	false	false	true
bfb62757-df64-467f-81b6-bd41ceeb2cc3	2026-08-28 10:05	2026-08-28 10:05	2026-08-28 10:05	IGV	IGV261016C00106000	call	106.0000	2026-10-16	6.6000	6.6000	7.1000	108.7200	49500.00	0.00	49500.00	75	13	111	58	1.91379310344828	0.306456058136541	0.306456058136541	false	false	false	true
cd8ad9be-2dc8-4af4-b640-5bc08367a481	2026-08-28 09:58	2026-08-28 09:58	2026-08-28 09:58	IGV	IGV270115C00096000	call	96.0000	2027-01-15	17.5500	17.5500	18.0500	109.2500	154440.00	0.00	154440.00	88	20	96	186	0.516129032258065	0.326031109506318	0.326031109506318	false	false	false	true
f9505802-758c-4913-8cfd-93a7ba0a7477	2026-08-28 09:53	2026-08-28 09:53	2026-08-28 09:53	IGV	IGV260828P00109000	put	109.0000	2026-08-28	0.5000	0.5000	0.5400	109.2900	92200.00	0.00	92200.00	1844	7	4146	3697	1.12144982418177	0.552761964092882	0.552761964092882	false	false	false	true
812a6909-a821-4764-a3d4-17ef2c21fc3d	2026-08-28 09:42	2026-08-28 09:42	2026-08-28 09:42	IGV	IGV260828P00109000	put	109.0000	2026-08-28	0.4400	0.2900	0.5000	109.4600	95568.00	2200.00	93368.00	2172	19	2197	3697	0.5942656207736	0.55257692839487	0.552589083814317	false	false	false	true
44755baf-8ff8-49ce-a607-32bc513e3c37	2026-08-27 15:52	2026-08-27 15:52	2026-08-27 15:52	IGV	IGV261120P00097000	put	97.0000	2026-11-20	1.9000	1.9000	2.0700	110.2200	14061.00	0.00	14061.00	74	6	93	12503	0.00743821482844117	0.339304010186769	0.339304010186769	false	false	false	true
5a98c4af-6e45-4aed-9949-4cba76affdc2	2026-08-27 15:52	2026-08-27 15:52	2026-08-27 15:52	IGV	IGV261016P00100000	put	100.0000	2026-10-16	1.3200	1.3200	1.6100	110.2150	341484.00	0.00	341484.00	2587	40	6544	2070	3.16135265700483	0.319469223915094	0.319469223915094	true	false	false	true
bb48c84f-ad62-4dca-929a-c046f418660d	2026-08-27 15:52	2026-08-27 15:52	2026-08-27 15:52	IGV	IGV261016P00100000	put	100.0000	2026-10-16	1.3500	1.3500	1.6600	110.2350	42255.00	0.00	42255.00	313	36	3896	2070	1.88212560386473	0.32262518223165	0.32262518223165	true	false	false	true
d474dc6a-1a8f-4bad-bb6e-e29e647b0662	2026-08-27 15:47	2026-08-27 15:46	2026-08-27 15:46	IGV	IGV261016P00110000	put	110.0000	2026-10-16	4.7500	4.6000	4.7500	110.3100	118750.00	118750.00	0.00	250	6	316	62	5.09677419354839	0.319407172031263	0.319407172031263	false	false	false	true
0cba8b6c-bb0b-4956-ac95-9db1be4ec0d5	2026-08-27 15:38	2026-08-27 15:38	2026-08-27 15:38	IGV	IGV260828C00111000	call	111.0000	2026-08-28	0.5900	0.4900	0.5900	110.3250	10679.00	10679.00	0.00	181	10	510	27	18.8888888888889	0.38184984826828	0.38184984826828	true	false	false	true
2779c496-59d6-42a9-aafa-2b41376517d9	2026-08-27 15:01	2026-08-27 15:01	2026-08-27 15:01	IGV	IGV260911C00112000	call	112.0000	2026-09-11	1.9000	1.5500	1.9000	110.0500	14250.00	14250.00	0.00	75	19	98	1	98	0.300443291835844	0.300443291835844	false	false	false	true
860a918e-04d1-45ba-baa9-e020f339ec80	2026-08-27 15:01	2026-08-27 15:00	2026-08-27 15:00	IGV	IGV260911C00110000	call	110.0000	2026-09-11	2.7300	2.5500	2.7800	109.9900	428883.00	428610.00	273.00	1571	6	1658	458	3.62008733624454	0.297992327790295	0.297992327790295	false	false	false	true
6d1ac830-a2fb-4bb9-8550-cf2cfce7110e	2026-08-27 14:49	2026-08-27 14:49	2026-08-27 14:49	IGV	IGV261016C00112000	call	112.0000	2026-10-16	4.3500	4.1000	4.3500	109.9401	217500.00	217500.00	0.00	500	36	663	424	1.56367924528302	0.309482013075711	0.309482013075711	false	false	false	true
e879746e-b48d-4f37-9619-64124382576e	2026-08-27 14:48	2026-08-27 14:48	2026-08-27 14:48	IGV	IGV260904C00108000	call	108.0000	2026-09-04	3.2500	2.9500	3.3000	109.9300	30875.00	26325.00	0.00	95	19	557	226	2.4646017699115	0.324354609797436	0.324354609797436	true	false	false	true
27b69977-40df-455f-b06c-9563e437477f	2026-08-27 14:48	2026-08-27 14:48	2026-08-27 14:48	IGV	IGV260918C00110000	call	110.0000	2026-09-18	3.3000	3.2000	3.3000	109.9050	11880.00	11880.00	0.00	36	11	2548	5990	0.425375626043406	0.299512282908947	0.299512282908947	false	false	false	true
bda61099-f010-4d2d-8259-5dc8d44a5c4e	2026-08-27 14:43	2026-08-27 14:43	2026-08-27 14:43	IGV	IGV260918C00113000	call	113.0000	2026-09-18	1.9700	1.8500	2.0400	109.7250	351448.00	351251.00	197.00	1784	21	2202	425	5.18117647058824	0.298996057546409	0.299181521008016	false	false	false	true
7b3431e1-b0a0-4460-a05a-23b03f38e77d	2026-08-27 14:37	2026-08-27 14:37	2026-08-27 14:37	IGV	IGV261016P00103000	put	103.0000	2026-10-16	2.1600	2.1200	2.1600	109.8400	12096.00	12096.00	0.00	56	7	77	306	0.251633986928105	0.319764241148447	0.319764241148447	false	false	false	true
eff40535-012a-4686-af2e-17b03d8bc950	2026-08-27 14:34	2026-08-27 14:34	2026-08-27 14:34	IGV	IGV260904P00104000	put	104.0000	2026-09-04	0.4400	0.3800	0.4500	109.8700	36827.00	29612.00	6599.00	837	63	9208	712	12.9325842696629	0.361537421290797	0.361537421290797	true	false	false	true
7affa899-0fdc-4a14-8575-0243aca7068c	2026-08-27 14:13	2026-08-27 14:13	2026-08-27 14:13	IGV	IGV260918C00115000	call	115.0000	2026-09-18	1.3500	1.3000	1.4000	109.6150	247995.00	241245.00	0.00	1837	21	6054	8932	0.677787729511867	0.300235590092935	0.300235590092935	false	false	false	true
47aa4931-19be-4b4a-a726-d9d32371fe30	2026-08-27 14:03	2026-08-27 14:03	2026-08-27 14:03	IGV	IGV260904C00108000	call	108.0000	2026-09-04	3.0000	3.0000	3.2500	109.6600	16500.00	0.00	16500.00	55	6	454	226	2.00884955752212	0.312046971094312	0.312046971094312	false	false	false	true
8a63acfe-def5-4066-8611-5e91c8cbd7a1	2026-08-27 13:53	2026-08-27 13:53	2026-08-27 13:53	IGV	IGV260918C00120000	call	120.0000	2026-09-18	0.5100	0.4500	0.5500	109.7650	46461.00	45441.00	1020.00	911	8	5776	2196	2.63023679417122	0.302855727308946	0.302855727308946	false	false	false	true
d42b46ed-3490-4d99-ae7b-ed9844f2e3f7	2026-08-27 13:29	2026-08-27 13:29	2026-08-27 13:29	IGV	IGV260828C00110000	call	110.0000	2026-08-28	0.7000	0.7000	0.7400	109.6000	170800.00	0.00	170800.00	2440	11	6208	2677	2.31901382144191	0.384128472027038	0.384128472027038	false	false	false	true
c2cbd08d-6120-4a48-acf5-d5d4f3bf597b	2026-08-27 13:14	2026-08-27 13:14	2026-08-27 13:14	IGV	IGV260918C00115000	call	115.0000	2026-09-18	1.4000	1.3200	1.4000	109.7500	157080.00	157080.00	0.00	1122	5	4198	8932	0.46999552171966	0.30152444249918	0.30152444249918	false	false	false	true
4300a8e4-4b54-46d8-b454-d31dfd8d5111	2026-08-27 13:02	2026-08-27 13:02	2026-08-27 13:02	IGV	IGV260918C00120000	call	120.0000	2026-09-18	0.5000	0.4500	0.5600	109.6400	15510.00	15000.00	510.00	310	11	4844	2196	2.20582877959927	0.303917958768877	0.305698422993807	false	false	false	true
0f9914a7-186c-417f-9c02-ece18588b82c	2026-08-27 13:00	2026-08-27 13:00	2026-08-27 13:00	IGV	IGV260918C00112000	call	112.0000	2026-09-18	2.2500	1.9000	2.3800	109.5650	10793.00	1125.00	9668.00	48	6	154	159	0.968553459119497	0.297447836499557	0.297447836499557	false	false	false	true