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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = IGV×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	price

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	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-27T15:23:19.203737Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
04d512ef-6fdb-41ff-acd3-766ab101657f	2026-08-27 11:17	2026-08-27 11:17	2026-08-27 11:17	IGV	IGV261016P00088000	put	88.0000	2026-10-16	0.2500	0.2400	0.2800	109.2800	10367.00	0.00	10367.00	415	10	1552	219	7.08675799086758	0.354531503927195	0.357393453595027	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
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	false
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	false
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	false
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	false
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	false
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	false
1a20b576-c2d1-42c8-8a84-546066fdd3e0	2026-08-27 14:12	2026-08-27 14:12	2026-08-27 14:12	IGV	IGV270617C00100000	call	100.0000	2027-06-17	19.6500	19.5000	20.0000	109.6600	53052.00	1960.00	51092.00	27	5	62	2022	0.0306627101879327	0.331286422971442	0.329190807355563	false	false	false	true	false
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	false
45896eaa-4f99-4b93-ac50-e91fdd77b8e3	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.3400	0.4500	109.8600	355456.00	352472.00	2984.00	8116	122	8371	712	11.7570224719101	0.361731955148512	0.361148236091988	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
6d53f3e7-1c31-407f-af23-2b7656bd1e78	2026-08-27 15:00	2026-08-27 14:59	2026-08-27 14:59	IGV	IGV260904C00110000	call	110.0000	2026-09-04	2.0800	1.8800	2.1600	110.0000	37046.00	37046.00	0.00	178	6	547	2085	0.262350119904077	0.313216295506843	0.313216295506843	false	false	false	true	false
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	false
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	false
3df77268-3161-4a98-862a-5a6e85906200	2026-08-27 15:28	2026-08-27 15:28	2026-08-27 15:28	IGV	IGV260918C00115000	call	115.0000	2026-09-18	1.5500	1.4900	1.5500	110.0000	405478.00	405324.00	154.00	2616	21	8833	8932	0.988916256157635	0.302802727960255	0.302802727960255	true	false	false	true	false
bf12e753-6ad1-4376-992d-99061d9eedc1	2026-08-27 15:36	2026-08-27 15:36	2026-08-27 15:36	IGV	IGV261218C00100000	call	100.0000	2026-12-18	14.6700	14.5500	14.8000	110.2200	36687.00	36687.00	0.00	25	9	144	6386	0.0225493266520514	0.33087832663938	0.330361079809899	false	false	false	true	false
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	false
c8e5681b-e0d6-42f7-88e6-a4f8496c35fd	2026-08-27 15:38	2026-08-27 15:38	2026-08-27 15:38	IGV	IGV260918C00115000	call	115.0000	2026-09-18	1.5900	1.5500	1.7500	110.3300	15939.00	6837.00	6382.00	100	7	9005	8932	1.00817286162114	0.304302334392153	0.303259984002258	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false