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

a1eb35b0-2aac-4bca-8104-daed5aaf855d	2026-08-27 12:57	2026-08-27 12:57	2026-08-27 12:57	IGV	IGV261218C00140000	call	140.0000	2026-12-18	0.9100	0.7400	0.9100	109.5850	15197.00	15197.00	0.00	167	20	169	231	0.731601731601732	0.314023093517641	0.314023093517641	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	14038397136.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9a9f5fe7-cb3b-4fb3-b558-8b28bbd4c249	2026-08-27 12:42	2026-08-27 12:42	2026-08-27 12:42	IGV	IGV260904P00105000	put	105.0000	2026-09-04	0.5900	0.5700	0.6500	109.5050	16697.00	1121.00	13511.00	283	14	2946	177	16.6440677966102	0.339546841354013	0.339546841354013	true	false	false	true
1796e94f-5d4a-46bc-b193-7f71866cee29	2026-08-27 12:42	2026-08-27 12:42	2026-08-27 12:42	IGV	IGV261120P00108000	put	108.0000	2026-11-20	5.5500	5.5500	5.9000	109.4900	16095.00	0.00	16095.00	29	9	55	0	0	0.322064711587772	0.322064711587772	false	false	false	true
5cfa1e13-403b-4a0c-9788-6804df21698c	2026-08-27 12:34	2026-08-27 12:33	2026-08-27 12:33	IGV	IGV261016C00100000	call	100.0000	2026-10-16	11.3500	10.7000	11.3500	109.3450	128255.00	128255.00	0.00	113	5	287	11707	0.0245152472879474	0.319812545319512	0.319812545319512	false	false	false	true
8dac4150-57aa-4f0e-ac54-fe86afcfc6ef	2026-08-27 12:32	2026-08-27 12:32	2026-08-27 12:32	IGV	IGV261120C00100000	call	100.0000	2026-11-20	12.8500	12.4000	12.9000	109.2920	42404.00	41119.00	1285.00	33	10	338	21740	0.0155473781048758	0.32629037343373	0.32629037343373	false	false	false	true
4e3bb2f3-50ae-46b7-87c5-bb8393504648	2026-08-27 12:32	2026-08-27 12:32	2026-08-27 12:32	IGV	IGV260828P00109000	put	109.0000	2026-08-28	0.7700	0.7700	0.7900	109.2700	105413.00	0.00	105413.00	1369	5	3325	12	277.083333333333	0.396582165812161	0.396582165812161	false	false	false	true
efbb5865-fda0-494f-a5df-0a03875ecfd6	2026-08-27 12:29	2026-08-27 12:29	2026-08-27 12:29	IGV	IGV270319C00120000	call	120.0000	2027-03-19	7.0000	6.8500	7.0000	109.1720	142100.00	142100.00	0.00	203	10	226	151	1.49668874172185	0.314200672510486	0.314200672510486	false	false	false	true
3e1052f9-973a-4709-8232-8274d4f88ad0	2026-08-27 12:24	2026-08-27 12:24	2026-08-27 12:24	IGV	IGV260828C00109000	call	109.0000	2026-08-28	1.0000	0.8900	1.0600	109.1200	19900.00	14900.00	5000.00	199	5	1020	94	10.8510638297872	0.409652857401678	0.409652857401678	false	false	false	true
5462b848-b7a2-4d2e-ad15-a9933d008aea	2026-08-27 12:16	2026-08-27 12:16	2026-08-27 12:16	IGV	IGV260828C00110000	call	110.0000	2026-08-28	0.5000	0.5000	0.5500	109.0200	113750.00	0.00	113750.00	2275	20	3316	2677	1.23870003735525	0.394839957272336	0.394839957272336	false	false	false	true
50b6a07b-2e9c-4c9f-9db7-1c34989074f7	2026-08-27 12:03	2026-08-27 12:03	2026-08-27 12:03	IGV	IGV260828P00109000	put	109.0000	2026-08-28	0.8800	0.8800	0.9700	108.9750	144232.00	0.00	144232.00	1639	33	1932	12	161	0.383691139073484	0.383691139073484	false	false	false	true
3f0a327c-ee2b-4dbb-acfc-dd07e9ba78cb	2026-08-27 11:48	2026-08-27 11:48	2026-08-27 11:48	IGV	IGV260828P00107000	put	107.0000	2026-08-28	0.3300	0.2000	0.3500	108.6100	41250.00	33000.00	8250.00	1250	24	1312	52	25.2307692307692	0.411302108913505	0.409949168280094	false	false	false	true
aa8343cb-20d9-4452-b4e2-ad523dfbde94	2026-08-27 11:29	2026-08-27 11:29	2026-08-27 11:29	IGV	IGV260828P00108000	put	108.0000	2026-08-28	0.4400	0.4400	0.5000	109.1271	68156.00	0.00	68156.00	1549	10	4042	87	46.4597701149425	0.395514359585033	0.395514359585033	false	false	false	true
cc314a49-7c6f-496a-930e-13703cefc17e	2026-08-27 11:26	2026-08-27 11:26	2026-08-27 11:26	IGV	IGV261016C00105000	call	105.0000	2026-10-16	7.6000	7.5500	7.6500	109.2250	37240.00	36480.00	760.00	49	5	100	651	0.153609831029186	0.307633188557792	0.3074022985935	false	false	false	true
d8e61968-c529-4c17-80f5-14f9ac6d628a	2026-08-27 11:15	2026-08-27 11:15	2026-08-27 11:15	IGV	IGV260918C00115000	call	115.0000	2026-09-18	1.1700	1.1700	1.2500	109.1813	111384.00	0.00	111384.00	952	42	2874	8932	0.321764442454098	0.293086121520563	0.293047493400531	true	false	false	true
6994de2a-b8dd-45d5-b9fd-def7e135e0a1	2026-08-27 11:15	2026-08-27 11:14	2026-08-27 11:14	IGV	IGV260828P00108000	put	108.0000	2026-08-28	0.4900	0.4200	0.5000	109.1500	24500.00	19600.00	4900.00	500	16	2491	87	28.632183908046	0.423937105592023	0.423937105592023	false	false	false	true
7f52c200-d1ec-4ec2-bac9-59475c5fc5d2	2026-08-27 11:06	2026-08-27 11:06	2026-08-27 11:06	IGV	IGV261218C00105000	call	105.0000	2026-12-18	10.7000	10.1000	10.9500	109.2700	263220.00	258940.00	4280.00	246	34	269	6022	0.0446695450016606	0.322887792627641	0.322887792627641	true	false	false	true
28c09973-73b1-411e-9002-8a10d01ca036	2026-08-27 11:04	2026-08-27 11:03	2026-08-27 11:03	IGV	IGV260925C00115000	call	115.0000	2026-09-25	1.6900	1.3700	1.6900	109.1650	17745.00	17745.00	0.00	105	24	406	19	21.3684210526316	0.304016490762432	0.304016490762432	false	false	false	true
0bda247a-c582-45fc-a3f8-b42ae51625dd	2026-08-27 10:54	2026-08-27 10:54	2026-08-27 10:54	IGV	IGV261016P00095000	put	95.0000	2026-10-16	0.7600	0.7600	0.8100	108.8600	79800.00	0.00	79800.00	1050	19	1082	3183	0.339930882814954	0.330433751764123	0.330433751764123	true	false	false	true
72379db0-7766-487a-98d0-5362e620ad8c	2026-08-27 10:53	2026-08-27 10:53	2026-08-27 10:53	IGV	IGV260904C00103000	call	103.0000	2026-09-04	6.3000	5.8000	6.3000	108.8599	24570.00	24570.00	0.00	39	8	76	251	0.302788844621514	0.340035664305406	0.340035664305406	false	false	false	true
c440f5e1-7864-45a9-85ba-add520f45f39	2026-08-27 10:51	2026-08-27 10:50	2026-08-27 10:50	IGV	IGV270319P00115000	put	115.0000	2027-03-19	12.7000	12.2500	12.7000	108.7550	15240.00	15240.00	0.00	12	7	16	2	8	0.326867981589841	0.326867981589841	false	false	false	true
7a707ab3-ec98-499f-8ed4-191ecb923175	2026-08-27 10:42	2026-08-27 10:41	2026-08-27 10:41	IGV	IGV261016P00100000	put	100.0000	2026-10-16	1.5700	1.5700	1.7300	108.8900	36895.00	0.00	36895.00	235	22	661	2070	0.319323671497585	0.319203457376043	0.319203457376043	false	false	false	true
d415ef38-77ef-48d9-bfc4-e4011f527a13	2026-08-27 10:41	2026-08-27 10:41	2026-08-27 10:41	IGV	IGV261218C00095000	call	95.0000	2026-12-18	17.2000	16.8000	17.2000	108.9295	342280.00	342280.00	0.00	199	39	227	11802	0.0192340281308253	0.326955605840237	0.326955605840237	false	false	false	true
1566e45c-0bf3-4e47-be2c-a40f8aac9386	2026-08-27 10:39	2026-08-27 10:38	2026-08-27 10:38	IGV	IGV261120C00125000	call	125.0000	2026-11-20	1.8500	1.6600	1.8500	108.8550	14244.00	14244.00	0.00	77	25	86	2098	0.0409914204003813	0.309482444563979	0.308829332002474	false	false	false	true
3fb32860-8dc0-433d-b0c5-c88e311802e4	2026-08-27 10:34	2026-08-27 10:34	2026-08-27 10:34	IGV	IGV260918C00104000	call	104.0000	2026-09-18	6.1500	6.1500	6.5500	108.6000	23985.00	0.00	23985.00	39	5	107	336	0.318452380952381	0.303893793330704	0.303893793330704	false	false	false	true
269fd5e6-894e-4062-9a45-d8577900b48d	2026-08-27 10:31	2026-08-27 10:31	2026-08-27 10:31	IGV	IGV260925C00115000	call	115.0000	2026-09-25	1.5300	1.5100	1.5500	108.7800	42840.00	0.00	42687.00	280	13	286	19	15.0526315789474	0.29939249697669	0.29939249697669	false	false	false	true
d025627a-c133-4896-995d-f7628f40277a	2026-08-27 10:31	2026-08-27 10:31	2026-08-27 10:31	IGV	IGV260918C00110000	call	110.0000	2026-09-18	2.8000	2.7000	2.8100	108.8100	18479.00	18200.00	279.00	66	16	1265	5990	0.21118530884808	0.303498141073023	0.303498141073023	false	false	false	true
dbfe5f4c-55b1-482d-a9bc-0db2e9c114cf	2026-08-27 10:21	2026-08-27 10:21	2026-08-27 10:21	IGV	IGV260918C00120000	call	120.0000	2026-09-18	0.4600	0.4200	0.4600	109.0250	51106.00	51106.00	0.00	1111	36	4115	2196	1.87386156648452	0.310345918224775	0.310345918224775	false	false	false	true
75bcf1f8-6c60-4b34-b10b-859256378917	2026-08-27 10:17	2026-08-27 10:17	2026-08-27 10:17	IGV	IGV260918P00110000	put	110.0000	2026-09-18	3.5000	3.3500	3.7000	109.1750	70040.00	4200.00	47640.00	200	20	203	46	4.41304347826087	0.299028506195294	0.299028506195294	true	false	false	true
9003af71-76c2-46e7-9647-7ec658d4ac5a	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	IGV	IGV260828C00103000	call	103.0000	2026-08-28	6.2500	6.2000	6.3500	109.2600	10625.00	1250.00	625.00	17	17	200	590	0.338983050847458	0.301585339614091	0.301585339614091	false	false	false	true
8b3d1b0c-79a6-4296-a055-8b7b15c0bfdc	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	IGV	IGV260918P00107000	put	107.0000	2026-09-18	2.1900	2.1900	2.5400	109.2450	75774.00	0.00	75774.00	346	9	351	4	87.75	0.310727660474064	0.310727660474064	false	false	false	true
08a28c9d-0690-4d43-beae-5ada1fe77f83	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	IGV	IGV260918P00105000	put	105.0000	2026-09-18	1.5300	1.5300	1.6900	109.2450	25398.00	0.00	25398.00	166	16	247	2730	0.0904761904761905	0.314898759840146	0.314898759840146	false	false	false	true
29d04c82-8ada-46e8-9086-2b2bfab22865	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	IGV	IGV260904P00105000	put	105.0000	2026-09-04	0.7300	0.6400	0.7300	109.0800	16060.00	16060.00	0.00	220	8	309	177	1.74576271186441	0.3511106426169	0.3511106426169	false	false	false	true
46a3ebff-4090-4571-8004-5271872fc316	2026-08-27 10:05	2026-08-27 10:05	2026-08-27 10:05	IGV	IGV260918C00120000	call	120.0000	2026-09-18	0.3800	0.3000	0.3800	108.8800	100966.00	100966.00	0.00	2657	23	2939	2196	1.33834244080146	0.29761809686884	0.29761809686884	false	false	false	true
7a59e02c-bafd-4d16-827e-0f2a4828beb2	2026-08-27 10:04	2026-08-27 10:04	2026-08-27 10:04	IGV	IGV261016P00105000	put	105.0000	2026-10-16	3.2500	3.0000	3.2500	108.8200	97500.00	97500.00	0.00	300	7	353	283	1.24734982332155	0.326710154258378	0.326710154258378	false	false	false	true
b43651f5-682b-4df2-b4cf-a8fa0de98b2b	2026-08-27 10:04	2026-08-27 10:04	2026-08-27 10:04	IGV	IGV260828P00109000	put	109.0000	2026-08-28	1.0600	1.0600	1.3400	108.7750	10176.00	0.00	10176.00	96	11	104	12	8.66666666666667	0.417557296588115	0.417557296588115	false	false	false	true
e3a6d343-9449-4dcd-93d0-464eb05c4dfc	2026-08-27 09:54	2026-08-27 09:54	2026-08-27 09:54	IGV	IGV261016P00085000	put	85.0000	2026-10-16	0.2300	0.1300	0.2300	108.2500	23736.00	23736.00	0.00	1032	27	1053	3133	0.336099585062241	0.385223150196906	0.385223150196906	true	false	false	true
cdde0ff2-e87d-49dd-b3a8-9b3e4cc67ae6	2026-08-27 09:50	2026-08-27 09:50	2026-08-27 09:50	IGV	IGV261218C00125000	call	125.0000	2026-12-18	2.4000	2.0500	2.6000	108.2850	60239.00	60239.00	0.00	251	20	253	970	0.260824742268041	0.301857604597739	0.301857604597739	false	false	false	true
eccb643b-82c1-443d-8be3-be9776a14287	2026-08-27 09:49	2026-08-27 09:49	2026-08-27 09:49	IGV	IGV260918P00100000	put	100.0000	2026-09-18	0.7400	0.6600	0.7800	107.9401	154808.00	2220.00	152588.00	2092	20	2248	3531	0.636646842254319	0.330132989698099	0.330132989698099	false	false	false	true
a0784b49-2844-4b40-bca4-b5eb431b66b7	2026-08-27 09:47	2026-08-27 09:47	2026-08-27 09:47	IGV	IGV261120C00115000	call	115.0000	2026-11-20	4.0000	3.9000	4.2500	107.9300	22000.00	0.00	22000.00	55	6	55	1223	0.044971381847915	0.308656215422942	0.308656215422942	false	false	false	true
f3bf01b7-5109-4015-a77b-79de1e4cb446	2026-08-27 09:39	2026-08-27 09:39	2026-08-27 09:39	IGV	IGV260904C00110000	call	110.0000	2026-09-04	1.0000	0.7700	1.0200	107.2250	10000.00	10000.00	0.00	100	6	110	2085	0.052757793764988	0.323030974064716	0.323030974064716	false	false	false	true
21bb0e7d-2155-482b-9c96-c087b11ce0be	2026-08-27 09:37	2026-08-27 09:37	2026-08-27 09:37	IGV	IGV260918C00107000	call	107.0000	2026-09-18	3.4000	3.1000	3.4500	107.0400	84877.00	63457.00	21420.00	250	9	540	499	1.08216432865731	0.311025964948923	0.311025964948923	false	false	false	true
1fbe5f09-44ae-44b4-b40c-664cfdde6c5d	2026-08-27 09:36	2026-08-27 09:36	2026-08-27 09:36	IGV	IGV260918C00095000	call	95.0000	2026-09-18	12.6000	12.6000	12.8000	107.0500	18900.00	0.00	18900.00	15	15	16	9025	0.00177285318559557	0.357259609421287	0.357259609421287	false	false	false	true
9e97a4f7-f8a2-4d6b-bd18-98350f186e01	2026-08-26 15:35	2026-08-26 15:35	2026-08-26 15:35	IGV	IGV260904C00100000	call	100.0000	2026-09-04	3.7500	3.6000	3.8000	102.6350	120000.00	375.00	119625.00	320	11	322	70	4.6	0.332850292482869	0.332850292482869	false	false	false	true
9e8c3775-000f-48b5-bb3c-867eacd8546e	2026-08-26 15:05	2026-08-26 15:05	2026-08-26 15:05	IGV	IGV260828C00101000	call	101.0000	2026-08-28	2.1900	2.1100	2.2300	102.6250	32850.00	24528.00	8322.00	150	10	189	144	1.3125	0.395973356095857	0.395973356095857	false	false	false	true
2a10e924-55dd-458d-95e0-a412b5deeb9a	2026-08-26 14:25	2026-08-26 14:25	2026-08-26 14:25	IGV	IGV260828P00102000	put	102.0000	2026-08-28	0.9400	0.9200	0.9600	102.4200	206424.00	0.00	192700.00	2196	12	6906	2467	2.79935143899473	0.380097107835164	0.380097107835164	false	false	false	true
269bc6ec-2461-4198-9e9a-6676ec2b3f2c	2026-08-26 14:23	2026-08-26 14:23	2026-08-26 14:23	IGV	IGV260828P00102000	put	102.0000	2026-08-28	0.9600	0.9200	0.9800	102.4250	72000.00	57600.00	14400.00	750	15	4660	2467	1.88893392784759	0.387529304506086	0.387529304506086	false	false	false	true
25141383-db1c-4a64-a588-5169fa90afda	2026-08-26 14:21	2026-08-26 14:20	2026-08-26 14:20	IGV	IGV260828P00102000	put	102.0000	2026-08-28	0.9500	0.9500	0.9800	102.4300	124830.00	0.00	124830.00	1314	16	3860	2467	1.56465342521281	0.384902877031156	0.384902877031156	false	false	false	true
4ea01325-2436-41f2-bb6d-77d1242b4989	2026-08-26 14:20	2026-08-26 14:20	2026-08-26 14:20	IGV	IGV261120C00094000	call	94.0000	2026-11-20	11.9500	10.9000	12.0000	102.4000	54965.00	53775.00	1190.00	46	14	46	44	1.04545454545455	0.331670929731935	0.331670929731935	false	false	false	true
d5b0a463-885e-4d6f-a862-82bea4b03e6f	2026-08-26 14:20	2026-08-26 14:20	2026-08-26 14:20	IGV	IGV261016P00092000	put	92.0000	2026-10-16	1.2100	1.2100	1.2900	102.4000	12826.00	0.00	12826.00	106	8	110	55	2	0.333836820730392	0.333836820730392	false	false	false	true
0c3e2b85-8d25-47ae-9b2d-9673b9bc327b	2026-08-26 14:05	2026-08-26 14:05	2026-08-26 14:05	IGV	IGV261218C00102000	call	102.0000	2026-12-18	7.9500	7.6000	8.0000	102.3100	63600.00	31800.00	31800.00	80	6	801	48	16.6875	0.316368845924159	0.316368845924159	false	false	false	true