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:source = uw_flow_alerts×ticker = XLI×

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

cc44ab6d-135c-4886-ac38-51cfefa05586	2026-08-24 12:40	2026-08-24 12:39	2026-08-24 12:39	XLI	XLI270115P00170000	put	170.0000	2027-01-15	4.4000	4.4000	4.4500	178.5400	36960.00	0.00	36960.00	84	5	85	3232	0.026299504950495	0.20535465637852	0.20535465637852	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30796170295.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T16:44:07.615841Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a17cd118-1225-476a-92b6-b4b83e94ed8b	2026-08-24 12:39	2026-08-24 12:39	2026-08-24 12:39	XLI	XLI280121P00180000	put	180.0000	2028-01-21	15.0000	14.9500	15.3500	178.5600	15000.00	1500.00	13500.00	10	5	101	142	0.711267605633803	0.233252277158374	0.233216083084058	false	false	false	true
ff3f8852-1c6a-4c96-85cb-719de8d68fce	2026-08-24 12:38	2026-08-24 12:37	2026-08-24 12:37	XLI	XLI280121P00180000	put	180.0000	2028-01-21	15.0000	15.0000	15.8500	178.6500	60000.00	0.00	60000.00	40	6	90	142	0.633802816901408	0.233633383258774	0.233633383258774	false	false	false	true
d7d224ec-d344-49ce-8841-134ff1a534af	2026-08-24 12:37	2026-08-24 12:37	2026-08-24 12:37	XLI	XLI280121P00180000	put	180.0000	2028-01-21	15.0000	15.0000	15.8500	178.6650	60000.00	0.00	60000.00	40	17	50	142	0.352112676056338	0.23370286448087	0.23370286448087	false	false	false	true
ff218325-3d80-4d22-8056-9fbd285b0cec	2026-08-24 12:27	2026-08-24 12:27	2026-08-24 12:27	XLI	XLI260918C00185000	call	185.0000	2026-09-18	1.0700	1.0700	1.0900	178.7600	26001.00	0.00	26001.00	243	15	349	3585	0.097350069735007	0.165913840083884	0.165913840083884	false	false	false	true
84815516-29c1-46db-b022-b9fc91b43b17	2026-08-24 12:13	2026-08-24 12:13	2026-08-24 12:13	XLI	XLI261120P00175000	put	175.0000	2026-11-20	4.4300	4.2500	4.4500	178.9900	2215000.00	2215000.00	0.00	5000	2	5130	55255	0.0928422767170392	0.199379463310234	0.199379463310234	false	true	true	false
c477bf01-270c-438e-84c1-0777cbd1b1bd	2026-08-24 11:07	2026-08-24 11:06	2026-08-24 11:06	XLI	XLI260911C00183000	call	183.0000	2026-09-11	1.1400	1.1400	1.2700	178.7695	14022.00	0.00	14022.00	123	38	123	67	1.83582089552239	0.164985547514812	0.164985547514812	false	false	false	true
9cf5635c-1d65-4d42-bff2-17fb90e8ebb6	2026-08-24 10:46	2026-08-24 10:46	2026-08-24 10:46	XLI	XLI261120C00175000	call	175.0000	2026-11-20	9.6000	9.4000	10.0500	179.0700	25912.00	0.00	25912.00	27	5	27	192	0.140625	0.183338680909358	0.183957276325647	false	false	false	true
549d76d9-b32a-4df9-8a78-6774c887b243	2026-08-24 10:22	2026-08-24 10:22	2026-08-24 10:22	XLI	XLI260918C00190000	call	190.0000	2026-09-18	0.4400	0.4400	0.4800	179.2300	19536.00	0.00	19536.00	444	22	660	6520	0.101226993865031	0.173141009492173	0.173141009492173	false	false	false	true
70851cef-0a21-4575-8643-f893ec44308f	2026-08-21 14:33	2026-08-21 14:32	2026-08-21 14:32	XLI	XLI261218P00180000	put	180.0000	2026-12-18	6.7000	6.5500	6.7000	180.4100	205690.00	205690.00	0.00	307	43	308	172	1.7906976744186	0.19536795483032	0.19536795483032	false	false	false	true
0d851611-16e9-4535-8cc0-c279b8d6b2b6	2026-08-21 14:10	2026-08-21 14:10	2026-08-21 14:10	XLI	XLI260918C00185000	call	185.0000	2026-09-18	1.6300	1.6300	1.7000	180.0000	12062.00	0.00	12062.00	74	20	324	3372	0.096085409252669	0.164050158233707	0.164050158233707	false	false	false	true
1032647b-1873-4a7b-9772-59f17a08367b	2026-08-21 13:44	2026-08-21 13:44	2026-08-21 13:44	XLI	XLI260918C00185000	call	185.0000	2026-09-18	1.6000	1.6000	1.6700	180.1700	19360.00	0.00	19360.00	121	23	225	3372	0.0667259786476868	0.164477727493724	0.164477727493724	false	false	false	true
4ec705e6-af0a-40ce-a3ff-13024d57da62	2026-08-21 12:24	2026-08-21 12:23	2026-08-21 12:23	XLI	XLI260904C00188000	call	188.0000	2026-09-04	0.3200	0.3200	0.4400	180.0300	37376.00	0.00	37376.00	1168	20	1170	56	20.8928571428571	0.172293170171636	0.172293170171636	false	false	false	true
c3e979d3-011f-4311-934e-ca0be891c560	2026-08-21 10:06	2026-08-21 10:06	2026-08-21 10:06	XLI	XLI260821C00181000	call	181.0000	2026-08-21	0.2100	0.2100	0.3800	180.2600	10122.00	0.00	10122.00	482	33	632	191	3.30890052356021	0.263721696308036	0.263721696308036	false	false	false	true
c1e42926-f8f4-42be-8599-4bbcbccea80e	2026-08-21 10:06	2026-08-21 10:06	2026-08-21 10:06	XLI	XLI260828C00182000	call	182.0000	2026-08-28	1.0400	1.0100	1.2600	180.3400	10838.00	104.00	10734.00	104	14	107	29	3.68965517241379	0.170513378030225	0.16944759408304	true	false	false	true
5522d3ee-5fce-4287-b011-590199aa0cd4	2026-08-21 10:00	2026-08-21 10:00	2026-08-21 10:00	XLI	XLI260828C00189000	call	189.0000	2026-08-28	0.0800	0.0800	0.1300	180.4850	10880.00	0.00	10880.00	1360	22	1363	131	10.4045801526718	0.188373805603908	0.188373805603908	false	false	false	true
f5a47507-4d94-4d4a-8646-0745513b6aab	2026-08-20 15:22	2026-08-20 15:22	2026-08-20 15:22	XLI	XLI260821P00179000	put	179.0000	2026-08-21	0.4200	0.4200	0.6200	179.8900	10416.00	0.00	10416.00	248	23	251	112	2.24107142857143	0.211593185118282	0.211593185118282	false	false	false	true
96010497-d36f-4733-8376-09d46a8a22e2	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.6600	1.6100	1.6600	179.7100	21414.00	21414.00	0.00	129	37	1328	4486	0.296032099866251	0.185995391699108	0.185995391699108	false	false	false	true
6ecf2583-c5ff-455e-ad4a-286fd0a53713	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.5800	1.5800	1.6200	179.9300	10902.00	0.00	10902.00	69	10	1104	4486	0.246098974587606	0.18481421917917	0.18481421917917	true	false	false	true
c5dcb81a-9bc3-4e9b-94b4-6ee207dff3c5	2026-08-20 13:08	2026-08-20 13:08	2026-08-20 13:08	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.4700	1.3800	1.4700	180.3110	18081.00	18081.00	0.00	123	23	769	4486	0.17142220240749	0.184191313199969	0.184191313199969	false	false	false	true
59a493bf-39ba-41c7-bc42-c1b525814239	2026-08-20 13:00	2026-08-20 13:00	2026-08-20 13:00	XLI	XLI260821C00182000	call	182.0000	2026-08-21	0.3000	0.3000	0.4300	180.4750	10680.00	0.00	10680.00	356	49	781	343	2.27696793002915	0.224318178781705	0.224318178781705	false	false	false	true
90f9e1b3-f41f-4eb0-b225-d5b07671804b	2026-08-20 12:49	2026-08-20 12:49	2026-08-20 12:49	XLI	XLI260918C00180000	call	180.0000	2026-09-18	4.1500	4.1500	4.3000	180.6100	19920.00	0.00	19920.00	48	5	78	8642	0.00902568849803286	0.175184654782026	0.175184654782026	true	false	false	true
e95558a0-38e9-48d2-93da-2917a4a75549	2026-08-20 12:35	2026-08-20 12:35	2026-08-20 12:35	XLI	XLI260821C00182000	call	182.0000	2026-08-21	0.3500	0.3500	0.4900	180.5400	14665.00	0.00	14665.00	419	45	423	343	1.2332361516035	0.235493544399967	0.235493544399967	false	false	false	true
691d1a34-aeb1-47a1-b46c-4779e46176e7	2026-08-20 11:31	2026-08-20 11:31	2026-08-20 11:31	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.2300	1.1600	1.2400	181.6100	34071.00	33948.00	123.00	277	33	463	4486	0.103209986625056	0.188404641810106	0.188404641810106	true	false	false	true
39cc6e6d-2a38-4ff3-bfed-b4895d01403c	2026-08-20 11:22	2026-08-20 11:22	2026-08-20 11:22	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.2200	1.1300	1.2300	181.5700	12566.00	12322.00	244.00	103	28	172	4486	0.0383415069103879	0.187162489805252	0.187162489805252	true	false	false	true
b5f75dce-89ca-4779-bfad-d3d035e75a57	2026-08-20 10:54	2026-08-20 10:54	2026-08-20 10:54	XLI	XLI260918P00180000	put	180.0000	2026-09-18	2.4800	2.3100	2.5800	181.8300	35462.00	35216.00	246.00	143	32	233	2096	0.111164122137405	0.174226372530249	0.173205558571017	false	false	false	true
fd6b8683-7175-493d-8e51-6f44713a6cdf	2026-08-20 10:50	2026-08-20 10:49	2026-08-20 10:49	XLI	XLI260918P00180000	put	180.0000	2026-09-18	2.4500	2.3100	2.4600	181.7900	14455.00	13720.00	735.00	59	16	60	2096	0.0286259541984733	0.171908620366634	0.171908620366634	false	false	false	true
428bc00e-a762-4667-b3de-afcd9c028f9b	2026-08-20 10:27	2026-08-20 10:27	2026-08-20 10:27	XLI	XLI260918P00176000	put	176.0000	2026-09-18	1.3600	1.2400	1.3600	181.6700	47736.00	47736.00	0.00	351	44	359	2092	0.171606118546845	0.181911826298206	0.181911826298206	false	false	false	true
d86bfd40-cfc4-4de5-897e-198450e6bb12	2026-08-20 09:47	2026-08-20 09:47	2026-08-20 09:47	XLI	XLI260918P00182000	put	182.0000	2026-09-18	3.6500	3.3000	3.6500	180.7800	93440.00	93440.00	0.00	256	41	256	452	0.566371681415929	0.162099725430699	0.162099725430699	false	false	false	true
acf1d61c-f8e4-4d47-b511-35a2ba5c76dd	2026-08-20 09:41	2026-08-20 09:41	2026-08-20 09:41	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.5000	5.3500	5.5000	181.2050	15398.00	15398.00	0.00	28	16	5687	10402	0.546721784272255	0.190568411423468	0.191132925740194	true	false	false	true
b676f254-b3d4-4b76-a530-3271f48505ed	2026-08-20 09:41	2026-08-20 09:40	2026-08-20 09:40	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.3000	5.3000	5.3500	181.2250	143630.00	0.00	143630.00	271	11	5659	10402	0.544029994231878	0.185718159211378	0.185718159211378	false	false	false	true
c071cae4-19c8-4b34-8757-a1946c63ff83	2026-08-20 09:41	2026-08-20 09:40	2026-08-20 09:40	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.3000	5.2500	5.4500	181.2250	75799.00	0.00	75269.00	143	28	5377	10402	0.51691982311094	0.185718159211378	0.185718159211378	false	false	false	true
228ce61d-3ff4-4784-bfd0-c5a492b8a90b	2026-08-20 09:40	2026-08-20 09:40	2026-08-20 09:40	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.3500	5.3000	5.4500	181.2300	75435.00	11235.00	64200.00	141	5	4904	10402	0.471447798500288	0.187188718903834	0.187188718903834	false	false	false	true
0b70c99c-9257-4cfb-851b-9ebb6ac2ed5e	2026-08-20 09:39	2026-08-20 09:39	2026-08-20 09:39	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.4000	5.4000	5.4500	181.1850	12420.00	0.00	12420.00	23	6	4572	10402	0.439530859450106	0.188076884287219	0.188076884287219	true	false	false	true
eb3d641a-25ca-464a-b360-42a6ece8c0ff	2026-08-20 09:39	2026-08-20 09:39	2026-08-20 09:39	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.4000	5.4000	5.5000	181.1500	277065.00	0.00	277065.00	513	23	4181	10402	0.401941934243415	0.187668645449139	0.187668645449139	false	false	false	true
a7ff7b15-27a0-4030-a042-cf088c297548	2026-08-20 09:39	2026-08-20 09:38	2026-08-20 09:38	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.5000	5.5000	5.6500	180.8928	415274.00	0.00	415274.00	755	38	3370	10402	0.323976158431071	0.187468205948164	0.187468205948164	false	false	false	true
affdf22c-26c2-44aa-8cae-d3c98ee2456a	2026-08-20 09:38	2026-08-20 09:38	2026-08-20 09:38	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.5500	5.5500	5.7000	180.7400	306415.00	0.00	306415.00	552	46	1978	10402	0.190155739280908	0.187064329614264	0.187064329614264	false	false	false	true
4b8b3cb0-fdbe-40be-b6d1-39b5965ef6ce	2026-08-20 09:38	2026-08-20 09:38	2026-08-20 09:38	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.6000	5.6000	5.7500	180.7900	87360.00	0.00	87360.00	156	19	1175	10402	0.112959046337243	0.189066693834031	0.189066693834031	false	false	false	true
acb015e8-1c37-4fa4-a656-e2d03220892b	2026-08-20 09:37	2026-08-20 09:37	2026-08-20 09:37	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.6000	5.6000	5.8000	180.9300	10640.00	0.00	10640.00	19	6	279	10402	0.0268217650451836	0.190725338857114	0.190725338857114	false	false	false	true
6f5e6559-bb32-44ae-97c7-53a4c82844ab	2026-08-19 15:23	2026-08-19 15:23	2026-08-19 15:23	XLI	XLI260828C00187000	call	187.0000	2026-08-28	0.4300	0.3900	0.4800	181.9700	31474.00	84.00	31390.00	732	32	737	19	38.7894736842105	0.171306161395437	0.168487364787002	false	false	false	true
f5eb8345-f2e7-49ea-91e3-2e9b381c7edb	2026-08-19 14:45	2026-08-19 14:45	2026-08-19 14:45	XLI	XLI260918C00185000	call	185.0000	2026-09-18	2.3400	2.3400	2.4100	182.2400	33696.00	0.00	33696.00	144	28	174	3246	0.0536044362292052	0.158307811784743	0.158307811784743	false	false	false	true
68ce918c-dfa0-4dec-9cd4-5d20703da0ab	2026-08-19 13:46	2026-08-19 13:46	2026-08-19 13:46	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.1000	5.0500	5.2000	182.5000	53040.00	0.00	53040.00	104	6	1346	11046	0.121854064819844	0.193635865678012	0.193635865678012	false	false	false	true
045485c6-087d-4848-a5f7-5bbabbdec6f4	2026-08-19 13:46	2026-08-19 13:46	2026-08-19 13:46	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.1000	4.8500	5.1000	182.4900	143310.00	143310.00	0.00	281	6	281	11046	0.0254390729675901	0.193526416353382	0.193526416353382	false	false	false	true
7aa5aae5-acbe-4dc1-abb5-cccf08b5c367	2026-08-19 10:20	2026-08-19 10:20	2026-08-19 10:20	XLI	XLI260904C00181000	call	181.0000	2026-09-04	4.0500	3.5000	4.0500	183.0300	25110.00	25110.00	0.00	62	17	62	5	12.4	0.179623746337526	0.179623746337526	true	false	false	true
152c7738-ef51-4a18-99c3-b21f62d6688c	2026-08-19 10:12	2026-08-19 10:11	2026-08-19 10:11	XLI	XLI260828P00180000	put	180.0000	2026-08-28	0.9000	0.6500	0.9000	182.5150	19259.00	19259.00	0.00	214	27	214	128	1.671875	0.172313011903425	0.172313011903425	true	false	false	true
813468ec-e58a-45f0-97b2-b48bd09135e4	2026-08-19 09:56	2026-08-19 09:56	2026-08-19 09:56	XLI	XLI260904C00182000	call	182.0000	2026-09-04	3.7500	3.2500	3.7500	183.5000	10125.00	10125.00	0.00	27	8	27	1	27	0.180723469173954	0.180723469173954	true	false	false	true	false
15edb301-38c2-41cb-ab84-7018d3f80bc6	2026-08-19 09:40	2026-08-19 09:40	2026-08-19 09:40	XLI	XLI261120C00180000	call	180.0000	2026-11-20	9.6000	9.5000	10.3000	183.1900	11520.00	960.00	10560.00	12	7	12	401	0.029925187032419	0.187909957482574	0.187909957482574	false	false	false	true
d379c8cd-755f-4a07-b9f2-ea25557b5b27	2026-08-18 15:44	2026-08-18 15:44	2026-08-18 15:44	XLI	XLI261016C00183000	call	183.0000	2026-10-16	6.2200	6.0000	6.6000	183.7600	18664.00	0.00	18664.00	30	10	42	0	0	0.177802351233176	0.177802351233176	false	false	false	true
eefb0959-8b7c-41ba-ada0-ae4734fc5292	2026-08-18 15:29	2026-08-18 15:29	2026-08-18 15:29	XLI	XLI261002C00197500	call	197.5000	2026-10-02	0.7700	0.7700	0.9800	183.7950	83776.00	0.00	83776.00	1088	24	1091	0	0	0.172161547954555	0.172161547954555	false	false	false	true
b27c4963-5fe2-4c4b-81e9-6ecbec70db49	2026-08-18 14:52	2026-08-18 14:52	2026-08-18 14:52	XLI	XLI260918P00175000	put	175.0000	2026-09-18	0.9900	0.9300	0.9900	183.7400	15444.00	15444.00	0.00	156	30	539	3931	0.137115237852964	0.194683713030896	0.194683713030896	false	false	false	true