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

1fcb60c0-03e1-4a6f-977e-169427813d61	2026-09-01 10:52	2026-09-01 10:51	2026-09-01 10:51	IGV	IGV260918C00107000	call	107.0000	2026-09-18	3.2500	3.2000	3.5500	107.6400	10725.00	0.00	10725.00	33	5	190	552	0.344202898550725	0.304943453288883	0.304943453288883	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-09-01T14:59:17.018627Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ea2fd175-ac20-413e-8f79-52a6e7ec254e	2026-09-01 10:33	2026-09-01 10:33	2026-09-01 10:33	IGV	IGV260918P00106000	put	106.0000	2026-09-18	1.8700	1.8600	1.8700	107.9800	22627.00	9911.00	0.00	121	6	1125	2854	0.394183601962158	0.306831931749175	0.306831931749175	true	false	false	true
8b053894-d29f-4744-a53d-0d0518f7dee5	2026-09-01 10:33	2026-09-01 10:33	2026-09-01 10:33	IGV	IGV260918P00106000	put	106.0000	2026-09-18	1.8600	1.8600	1.9400	107.9800	25296.00	0.00	25296.00	136	7	1261	2854	0.441836019621584	0.305692213329092	0.305692213329092	false	false	false	true
10ac7510-fd02-466b-9fcf-f5a323640a5a	2026-09-01 10:33	2026-09-01 10:33	2026-09-01 10:33	IGV	IGV260918P00106000	put	106.0000	2026-09-18	1.8800	1.8700	1.8800	108.0000	46248.00	46248.00	0.00	246	7	257	2854	0.0900490539593553	0.308807700293365	0.308807700293365	false	false	false	true
725562a6-b8e7-4b9d-aeaf-128e8217cb9f	2026-09-01 09:58	2026-09-01 09:57	2026-09-01 09:57	IGV	IGV260904P00105000	put	105.0000	2026-09-04	0.5600	0.5600	0.6000	107.2600	16800.00	0.00	16800.00	300	18	1158	5246	0.220739611132291	0.370566095699856	0.370566095699856	true	false	false	true
afc59f07-c575-493f-874c-83a96d0bd7d1	2026-09-01 09:46	2026-09-01 09:46	2026-09-01 09:46	IGV	IGV261120P00100000	put	100.0000	2026-11-20	2.8500	2.8500	2.8700	108.6100	20235.00	0.00	20235.00	71	10	507	863	0.587485515643105	0.336527377766675	0.336527377766675	false	false	false	true
0fcbbf7b-c636-4a71-b151-4ad67c1c69e5	2026-09-01 09:46	2026-09-01 09:45	2026-09-01 09:45	IGV	IGV261120P00100000	put	100.0000	2026-11-20	2.8500	2.8500	2.8700	108.5605	56145.00	0.00	56145.00	197	8	436	863	0.505214368482039	0.335753051327152	0.335753051327152	false	false	false	true
5fdfd002-540d-4ce0-b210-7a43b3cf77a9	2026-09-01 09:38	2026-09-01 09:38	2026-09-01 09:38	IGV	IGV261218C00120000	call	120.0000	2026-12-18	3.5000	3.5000	3.8500	108.0405	11900.00	0.00	11900.00	34	5	44	893	0.0492721164613662	0.311629044105979	0.311629044105979	false	false	false	true
64be5b32-3c3b-48ab-9dd8-e0c34007a112	2026-09-01 09:32	2026-09-01 09:32	2026-09-01 09:32	IGV	IGV260918C00110000	call	110.0000	2026-09-18	2.2500	2.0900	2.4000	108.4700	42975.00	8100.00	32850.00	191	12	202	6233	0.0324081501684582	0.307585723282301	0.305209810686014	true	false	false	true
768da873-2cd7-46dc-8a25-a747997b8c97	2026-09-01 09:31	2026-09-01 09:31	2026-09-01 09:31	IGV	IGV261218P00100000	put	100.0000	2026-12-18	3.7000	3.7000	3.7500	108.5000	111370.00	0.00	52910.00	301	10	301	4659	0.064606138656364	0.337270717684378	0.337270717684378	true	false	false	true
bcc170f2-c590-48c9-821a-6ab89bb0a2c7	2026-08-31 15:41	2026-08-31 15:41	2026-08-31 15:41	IGV	IGV270115C00130000	call	130.0000	2027-01-15	2.7500	2.6600	2.7500	110.2800	17875.00	17875.00	0.00	65	7	730	3539	0.206272958462843	0.309077940416806	0.309077940416806	false	false	false	true
c86e0213-ba91-474b-b6ac-89a9ba11f2b2	2026-08-31 15:04	2026-08-31 15:04	2026-08-31 15:04	IGV	IGV261016C00110000	call	110.0000	2026-10-16	5.1500	5.0000	5.3500	110.4650	25750.00	12875.00	3090.00	50	5	482	2634	0.182991647684131	0.297654202679291	0.297654202679291	false	false	false	true
0810f8ec-e297-42f3-827a-7b9df95a4bdf	2026-08-31 15:02	2026-08-31 15:02	2026-08-31 15:02	IGV	IGV260925P00109000	put	109.0000	2026-09-25	2.7100	2.7100	2.7500	110.4500	30352.00	0.00	30352.00	112	23	249	632	0.393987341772152	0.306876663294437	0.306876663294437	false	false	false	true
26961fc3-e589-466a-ac2a-208a25a1892d	2026-08-31 14:56	2026-08-31 14:56	2026-08-31 14:56	IGV	IGV261218P00105000	put	105.0000	2026-12-18	4.8000	4.6000	5.3500	110.4050	23040.00	13440.00	9600.00	48	5	261	126	2.07142857142857	0.328830904144814	0.328830904144814	false	false	false	true
ed15046b-df8e-4801-8b88-96fa6c0fe6f3	2026-08-31 14:06	2026-08-31 14:06	2026-08-31 14:06	IGV	IGV261002P00103000	put	103.0000	2026-10-02	1.3500	1.2200	1.5000	110.0000	32944.00	1350.00	31050.00	244	35	262	2	131	0.323449390929905	0.323449390929905	true	false	false	true
9e0607ce-bbc1-4c03-bdbd-7d3a34a6fcd2	2026-08-31 14:01	2026-08-31 14:01	2026-08-31 14:01	IGV	IGV260911P00114000	put	114.0000	2026-09-11	4.7000	4.7000	5.5000	110.0000	19270.00	0.00	19270.00	41	11	41	0	0	0.302627447121996	0.302627447121996	false	false	false	true
4e80dba8-d349-40d0-a309-56739b08b41d	2026-08-31 13:31	2026-08-31 13:31	2026-08-31 13:31	IGV	IGV260918C00110000	call	110.0000	2026-09-18	2.9100	2.9100	3.0000	109.7700	50634.00	0.00	50634.00	174	23	660	6368	0.103643216080402	0.300382841802826	0.300382841802826	false	false	false	true
cafda0b6-606c-405e-a540-2d98edd3c52b	2026-08-31 13:05	2026-08-31 13:05	2026-08-31 13:05	IGV	IGV270319P00105000	put	105.0000	2027-03-19	7.1000	7.0000	7.3500	109.9600	36920.00	36210.00	710.00	52	8	362	326	1.11042944785276	0.330696337125262	0.330696337125262	false	false	false	true
f58bf0c2-45f0-491b-8107-1df6e53f90e0	2026-08-31 12:46	2026-08-31 12:46	2026-08-31 12:46	IGV	IGV260904C00110000	call	110.0000	2026-09-04	1.6600	1.5500	1.6600	109.9550	83000.00	83000.00	0.00	500	40	921	2416	0.381208609271523	0.361376845405906	0.361376845405906	true	false	false	true
a8b64cf4-d192-4d84-8699-487dc4afa7c8	2026-08-31 11:38	2026-08-31 11:38	2026-08-31 11:38	IGV	IGV261218C00110000	call	110.0000	2026-12-18	7.9000	7.9000	8.0000	109.5600	80580.00	0.00	80580.00	102	8	126	12529	0.0100566685290127	0.314305573497454	0.314305573497454	false	false	false	true
78099e88-70b7-43c9-8d52-ef8de84f596e	2026-08-31 11:26	2026-08-31 11:26	2026-08-31 11:26	IGV	IGV261002C00115000	call	115.0000	2026-10-02	1.9400	1.9400	2.1200	109.6550	65184.00	0.00	65184.00	336	31	351	58	6.05172413793103	0.296933714129516	0.296933714129516	false	false	false	true
856399b5-a161-497d-a7fb-0e37109ae147	2026-08-31 11:00	2026-08-31 11:00	2026-08-31 11:00	IGV	IGV261120C00115000	call	115.0000	2026-11-20	4.6000	4.3500	4.6500	109.6300	17940.00	17480.00	460.00	39	12	42	2327	0.0180489901160292	0.312397287938376	0.312397287938376	false	false	false	true
fdfe7aef-bf83-42a9-8d67-ccf3d0d4502a	2026-08-31 10:43	2026-08-31 10:43	2026-08-31 10:43	IGV	IGV260918P00106000	put	106.0000	2026-09-18	1.5500	1.3500	1.8900	109.5100	67115.00	155.00	66960.00	433	7	2728	181	15.0718232044199	0.320236896570851	0.320236896570851	false	false	false	true
e68f324c-d1fa-4066-849d-9c6d4f40b853	2026-08-31 10:31	2026-08-31 10:30	2026-08-31 10:30	IGV	IGV261016C00110000	call	110.0000	2026-10-16	4.7000	4.7000	4.8000	109.4000	39010.00	0.00	39010.00	83	6	220	2634	0.0835231586940015	0.305534297356014	0.305534297356014	false	false	false	true
07141c60-e7e9-4d4f-a95c-95f557be0583	2026-08-31 10:05	2026-08-31 10:05	2026-08-31 10:05	IGV	IGV261016P00105000	put	105.0000	2026-10-16	2.8000	2.7600	2.8800	109.2150	21000.00	3640.00	17360.00	75	10	243	3171	0.076631977294229	0.317183122477848	0.317183122477848	false	false	false	true
863133f7-e9cc-4743-8fd7-c06a9bb8dc67	2026-08-31 10:02	2026-08-31 10:02	2026-08-31 10:02	IGV	IGV261218P00105000	put	105.0000	2026-12-18	5.2500	4.8500	5.2500	109.1450	26775.00	26775.00	0.00	51	12	161	126	1.27777777777778	0.329600158167808	0.329600158167808	false	false	false	true
165cdf05-15e2-4292-91f4-dcc08b827cf3	2026-08-31 09:54	2026-08-31 09:54	2026-08-31 09:54	IGV	IGV260918P00106000	put	106.0000	2026-09-18	1.5100	1.3100	1.5100	109.6480	18120.00	18120.00	0.00	120	18	2120	181	11.7127071823204	0.320376534649396	0.320376534649396	false	false	false	true
5be213e1-778f-4468-a34f-dcc5f2f4fb2c	2026-08-31 09:54	2026-08-31 09:54	2026-08-31 09:54	IGV	IGV260918P00106000	put	106.0000	2026-09-18	1.5100	1.5100	1.5600	109.6000	49377.00	0.00	49377.00	327	9	1827	181	10.0939226519337	0.318687635606271	0.318687635606271	false	false	false	true
bfec5aea-ca01-4684-b49b-d970e89e457f	2026-08-31 09:54	2026-08-31 09:54	2026-08-31 09:54	IGV	IGV260918P00106000	put	106.0000	2026-09-18	1.5700	1.3100	1.5700	109.5500	235500.00	24649.00	0.00	1500	7	1500	181	8.28729281767956	0.324019330980676	0.324019330980676	false	false	false	true
2e7643f6-9707-4e76-a131-602998c6e2e7	2026-08-31 09:48	2026-08-31 09:48	2026-08-31 09:48	IGV	IGV261120P00103000	put	103.0000	2026-11-20	3.5000	3.5000	3.5500	109.7050	70000.00	0.00	70000.00	200	8	4294	18490	0.2322336398053	0.332812078869682	0.332812078869682	false	false	false	true
33a0b442-c44d-46d2-ad08-6731edfae7c8	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	IGV	IGV261120P00103000	put	103.0000	2026-11-20	3.4500	3.4500	3.5000	109.9600	69000.00	0.00	69000.00	200	10	2714	18490	0.146782044348296	0.334210080989442	0.334210080989442	false	false	false	true
67fc7431-8662-41f6-8866-9b5cf7a0ae87	2026-08-31 09:40	2026-08-31 09:40	2026-08-31 09:40	IGV	IGV261120P00103000	put	103.0000	2026-11-20	3.5500	3.5500	3.6000	109.5800	236430.00	0.00	225780.00	666	29	1667	18490	0.0901568415359654	0.333528820893169	0.333528820893169	false	false	false	true
59fb9284-4988-4c0e-8b37-0b6096bf8e1b	2026-08-31 09:39	2026-08-31 09:39	2026-08-31 09:39	IGV	IGV261120P00103000	put	103.0000	2026-11-20	3.5500	3.4500	3.6000	109.5600	88750.00	88750.00	0.00	250	6	601	18490	0.0325040562466198	0.33319512787458	0.33319512787458	false	false	false	true
d45e3546-7b5d-4a2e-b0c6-52b16531d9d1	2026-08-31 09:39	2026-08-31 09:38	2026-08-31 09:38	IGV	IGV261120P00103000	put	103.0000	2026-11-20	3.5500	3.5500	3.6500	109.4800	79165.00	0.00	79165.00	223	8	224	18490	0.0121146565711195	0.331858064746747	0.331858064746747	true	false	false	true
b9adeb0c-1f4f-4451-8d19-360cd0455aa0	2026-08-31 09:39	2026-08-31 09:39	2026-08-31 09:39	IGV	IGV261120P00103000	put	103.0000	2026-11-20	3.5500	3.5500	3.6000	109.4800	27335.00	0.00	27335.00	77	5	301	18490	0.0162790697674419	0.331858064746747	0.331858064746747	true	false	false	true
c1997412-47fa-4c48-8ada-b407854eeb59	2026-08-28 15:22	2026-08-28 15:22	2026-08-28 15:22	IGV	IGV270115C00117000	call	117.0000	2027-01-15	6.0000	5.7500	6.0000	109.6100	58800.00	58800.00	0.00	98	22	99	15	6.6	0.307107367499975	0.307107367499975	false	false	false	true
9aa082e2-4309-4320-826b-bdada67570d0	2026-08-28 14:44	2026-08-28 14:43	2026-08-28 14:43	IGV	IGV260918C00115000	call	115.0000	2026-09-18	1.1000	1.1000	1.1600	109.3650	52800.00	0.00	52800.00	480	40	2075	14924	0.139037791476816	0.286371824466142	0.286371824466142	false	false	false	true
161aa090-a0c1-42b9-a362-79e784c74c0e	2026-08-28 14:41	2026-08-28 14:40	2026-08-28 14:40	IGV	IGV261120P00097000	put	97.0000	2026-11-20	1.9900	1.9900	2.1900	109.4400	19502.00	0.00	19502.00	98	15	12599	12550	1.00390438247012	0.337283735103017	0.337283735103017	false	false	false	true
a84cb926-cfb6-431e-a92a-790d009d77f7	2026-08-28 14:03	2026-08-28 14:03	2026-08-28 14:03	IGV	IGV261016P00095000	put	95.0000	2026-10-16	0.6900	0.6900	0.7100	109.6400	11937.00	0.00	11937.00	173	5	220	2311	0.0951968844655993	0.335451464875732	0.335451464875732	false	false	false	true
efc20909-b532-4f7b-ac51-e3f9adf59ee1	2026-08-28 13:53	2026-08-28 13:53	2026-08-28 13:53	IGV	IGV260925P00106000	put	106.0000	2026-09-25	2.0600	2.0300	2.0600	109.4950	83842.00	83842.00	0.00	407	11	903	3	301	0.307166938922468	0.307166938922468	true	false	false	true
5fcf35ab-73d1-42ad-965b-58649a37eb2f	2026-08-28 13:53	2026-08-28 13:53	2026-08-28 13:53	IGV	IGV260925P00106000	put	106.0000	2026-09-25	2.0600	2.0300	2.0600	109.4950	20600.00	3708.00	0.00	100	6	496	3	165.333333333333	0.307166938922468	0.307166938922468	false	false	false	true
0ab3affa-6461-479b-967d-bc33baf330ad	2026-08-28 13:53	2026-08-28 13:53	2026-08-28 13:53	IGV	IGV260925P00106000	put	106.0000	2026-09-25	2.0400	2.0400	2.1200	109.4900	16728.00	0.00	16728.00	82	5	367	3	122.333333333333	0.305181908972598	0.305181908972598	false	false	false	true
c9baab12-2448-4cf4-8b8e-378ff7ea0d84	2026-08-28 13:53	2026-08-28 13:53	2026-08-28 13:53	IGV	IGV260925P00106000	put	106.0000	2026-09-25	2.0300	2.0300	2.1200	109.4900	16646.00	0.00	7511.00	82	5	285	3	95	0.304262927097082	0.304262927097082	false	false	false	true
39606da9-29e6-4638-9142-5bae2caa9289	2026-08-28 13:53	2026-08-28 13:53	2026-08-28 13:53	IGV	IGV260925P00106000	put	106.0000	2026-09-25	2.0300	1.9800	2.1200	109.4900	20504.00	0.00	20504.00	101	6	202	3	67.3333333333333	0.304262927097082	0.304262927097082	false	false	false	true
b1a6ed83-4b77-46f8-89c1-b6bd5f5b3658	2026-08-28 13:32	2026-08-28 13:32	2026-08-28 13:32	IGV	IGV260828P00109000	put	109.0000	2026-08-28	0.1500	0.1500	0.1800	109.3550	15030.00	0.00	15030.00	1002	33	5947	3697	1.6086015688396	0.403873748411738	0.403873748411738	false	false	false	true
02eff9f5-22c3-4f78-8923-0e753807cd82	2026-08-28 13:13	2026-08-28 13:13	2026-08-28 13:13	IGV	IGV260911P00107000	put	107.0000	2026-09-11	1.4100	1.2000	1.6200	109.3000	50055.00	4089.00	45966.00	355	13	358	0	0	0.289471928317381	0.289471928317381	false	false	false	true
be205c19-86b3-48a9-bdae-9cc8465271b9	2026-08-28 13:01	2026-08-28 13:01	2026-08-28 13:01	IGV	IGV260918P00100000	put	100.0000	2026-09-18	0.4800	0.4400	0.4800	109.3500	15168.00	15168.00	0.00	316	24	1912	5273	0.362601934382704	0.324841492702181	0.324841492702181	false	false	false	true
ffe95f39-d571-4cd5-890d-8069a088d96a	2026-08-28 12:24	2026-08-28 12:24	2026-08-28 12:24	IGV	IGV261016P00100000	put	100.0000	2026-10-16	1.4700	1.4700	1.5200	109.3450	12495.00	0.00	12495.00	85	8	573	5951	0.0962863384305159	0.321441733166252	0.321441733166252	false	false	false	true
eff4064c-7bbc-4416-be84-008a957725b4	2026-08-28 12:07	2026-08-28 12:06	2026-08-28 12:06	IGV	IGV260925P00109000	put	109.0000	2026-09-25	3.3500	3.1000	3.3500	109.0000	35175.00	35175.00	0.00	105	6	583	5	116.6	0.315684983278292	0.315684983278292	false	false	false	true
752910f9-ad66-46b0-ab7b-6a7f53802c4e	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	IGV	IGV260904C00106000	call	106.0000	2026-09-04	4.1000	4.1000	5.0500	109.0000	13530.00	0.00	13530.00	33	8	44	63	0.698412698412698	0.30724590102462	0.30724590102462	false	false	false	true