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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

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	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-20T13:45:25.718532Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	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	false
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	false
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	false
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	false
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	false
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	false
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
2b9db468-5198-4707-8379-fc6fbcdb610d	2026-08-24 13:51	2026-08-24 13:51	2026-08-24 13:51	XLI	XLI260904C00186000	call	186.0000	2026-09-04	0.2100	0.1900	0.3300	178.3900	26963.00	315.00	26648.00	1284	23	1285	45	28.5555555555556	0.170546909412498	0.16638259190408	false	false	false	true	false
7f3bc6a3-f269-4d4a-a374-02d16afd40fa	2026-08-24 14:31	2026-08-24 14:31	2026-08-24 14:31	XLI	XLI261218C00177000	call	177.0000	2026-12-18	9.6000	9.4000	9.6000	178.8200	25920.00	25920.00	0.00	27	12	27	6	4.5	0.186909759780636	0.186909759780636	true	false	false	true	false
6b9ef96f-4661-4099-832d-7da67576266a	2026-08-25 09:45	2026-08-25 09:45	2026-08-25 09:45	XLI	XLI260904P00179000	put	179.0000	2026-09-04	1.7400	1.5900	1.8200	179.4400	49415.00	49068.00	174.00	284	45	284	35	8.11428571428571	0.172270683008387	0.172270683008387	false	false	false	true	false
d13d0af0-230c-44bd-8eaa-374385f3f32d	2026-08-25 10:29	2026-08-25 10:28	2026-08-25 10:28	XLI	XLI260918P00174000	put	174.0000	2026-09-18	1.2800	1.2200	1.2800	179.0100	80000.00	80000.00	0.00	625	53	634	5998	0.105701900633545	0.183830846754371	0.183830846754371	false	false	false	true	false
dd350274-be2a-4eb0-82bd-6852f0bd40ca	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	XLI	XLI261016C00172000	call	172.0000	2026-10-16	9.5500	8.5500	9.5500	178.6700	16235.00	16235.00	0.00	17	9	36	5	7.2	0.184499323033684	0.183466578739783	true	false	false	true	false
53a4df88-21c3-4359-9de9-245c3f78e423	2026-08-25 11:33	2026-08-25 11:33	2026-08-25 11:33	XLI	XLI260911P00180000	put	180.0000	2026-09-11	2.9000	2.9000	3.2000	178.9400	12470.00	0.00	12470.00	43	12	47	13	3.61538461538462	0.162675373060493	0.162675373060493	true	false	false	true	false
61223db1-7192-4bd8-8558-e8c71dcb0a93	2026-08-25 12:09	2026-08-25 12:09	2026-08-25 12:09	XLI	XLI261218P00170000	put	170.0000	2026-12-18	3.6000	3.6000	3.7500	178.8350	25920.00	0.00	25920.00	72	11	300	8107	0.0370050573578389	0.203228414634659	0.203228414634659	false	false	false	true	false
29a0e255-d23d-4427-947e-206487d28451	2026-08-25 12:10	2026-08-25 12:10	2026-08-25 12:10	XLI	XLI261218P00170000	put	170.0000	2026-12-18	3.6000	3.5500	3.7000	178.8200	36720.00	360.00	36360.00	102	40	402	8107	0.0495867768595041	0.203106078336042	0.203106078336042	false	false	false	true	false
9abf9c69-133b-4ccc-b6b8-18d4b7249677	2026-08-25 13:14	2026-08-25 13:14	2026-08-25 13:14	XLI	XLI260904C00182500	call	182.5000	2026-09-04	0.5700	0.5500	0.6500	178.4950	22000.00	112.00	21888.00	386	48	402	19	21.1578947368421	0.159351595998553	0.158190902269447	false	false	false	true	false
9b40acfd-0b5c-41cf-b362-73c8b0141bab	2026-08-25 13:48	2026-08-25 13:48	2026-08-25 13:48	XLI	XLI260904C00176000	call	176.0000	2026-09-04	3.4500	3.4500	3.5500	178.2800	17250.00	0.00	17250.00	50	20	50	2	25	0.169349068457802	0.169349068457802	false	false	false	true	false
bd277035-741f-445e-8b53-b070713c81a3	2026-08-25 14:05	2026-08-25 14:05	2026-08-25 14:05	XLI	XLI260904C00176000	call	176.0000	2026-09-04	3.3500	3.3500	3.5000	178.0000	80755.00	0.00	80755.00	241	48	291	2	145.5	0.166380089166062	0.166380089166062	false	false	false	true	false