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:alert_rule = RepeatedHits×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

2ac71948-ab8d-4894-a487-99524df17121	2026-08-27 12:18	2026-08-27 12:18	2026-08-27 12:18	XLI	XLI261120C00185000	call	185.0000	2026-11-20	4.1000	4.1000	4.3500	178.8600	130380.00	0.00	130380.00	318	36	319	2683	0.118896757361163	0.17451876866918	0.17451876866918	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-27T16:30:57.923324Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
646b0972-319d-402d-b695-626bcd96c8f9	2026-08-27 12:10	2026-08-27 12:10	2026-08-27 12:10	XLI	XLI261016C00180000	call	180.0000	2026-10-16	4.4000	4.4000	4.7500	178.9600	17160.00	0.00	17160.00	39	13	45	70	0.642857142857143	0.168478402530532	0.168478402530532	false	false	false	true
8094ef31-1cd0-4d51-a71f-f88bf1a1af1a	2026-08-27 11:39	2026-08-27 11:39	2026-08-27 11:39	XLI	XLI260918C00184000	call	184.0000	2026-09-18	1.0100	1.0100	1.1300	179.0600	55550.00	0.00	55550.00	550	42	582	393	1.48091603053435	0.151279136067347	0.151279136067347	false	false	false	true
3938d2e2-8f70-4a23-bbf7-23bcace4a12a	2026-08-27 11:06	2026-08-27 11:05	2026-08-27 11:05	XLI	XLI260828P00177000	put	177.0000	2026-08-28	0.2100	0.2100	0.2900	179.0600	14511.00	0.00	14511.00	691	20	713	166	4.29518072289157	0.238861189658682	0.238861189658682	false	false	false	true
fd5dbe6b-9ecb-433d-b34f-39a4efc84a01	2026-08-27 10:46	2026-08-27 10:46	2026-08-27 10:46	XLI	XLI260918C00185000	call	185.0000	2026-09-18	0.8200	0.8100	0.9100	179.0923	52398.00	82.00	52316.00	639	53	1044	3724	0.280343716433942	0.153272865148145	0.153272865148145	false	false	false	true
a0a527de-911f-4b09-a371-076c8f6599ca	2026-08-27 10:43	2026-08-27 10:43	2026-08-27 10:43	XLI	XLI260918C00185000	call	185.0000	2026-09-18	0.8000	0.7800	0.9100	178.8350	28080.00	4800.00	23280.00	351	41	405	3724	0.10875402792696	0.156004836096407	0.156004836096407	false	false	false	true
8e2360e5-d041-404c-b645-e8da8dd812b7	2026-08-27 10:07	2026-08-27 10:07	2026-08-27 10:07	XLI	XLI260911P00178000	put	178.0000	2026-09-11	2.0200	1.8900	2.0200	178.2000	41208.00	41208.00	0.00	204	28	207	14	14.7857142857143	0.156395206856212	0.156395206856212	false	false	false	true
cb88976b-6b49-4604-9a4d-4c4f06b6a588	2026-08-26 10:26	2026-08-26 10:26	2026-08-26 10:26	XLI	XLI261218P00160000	put	160.0000	2026-12-18	1.6400	1.5200	1.6400	180.5600	11480.00	11480.00	0.00	70	22	227	3571	0.0635676281153739	0.227736120614155	0.227736120614155	false	false	false	true
a512065b-9062-4798-852f-e2c7756765a3	2026-08-26 10:11	2026-08-26 10:11	2026-08-26 10:11	XLI	XLI260828C00183000	call	183.0000	2026-08-28	0.2900	0.1600	0.2900	180.8300	11890.00	11890.00	0.00	410	46	412	43	9.58139534883721	0.19004568231326	0.19004568231326	false	false	false	true
1dcc57b2-34e9-4720-a68d-ab8fb505ac53	2026-08-26 10:03	2026-08-26 10:03	2026-08-26 10:03	XLI	XLI261218P00160000	put	160.0000	2026-12-18	1.6300	1.5300	1.6300	180.6599	25428.00	25428.00	0.00	156	26	157	3571	0.0439652758331	0.227888906543366	0.227888906543366	false	false	false	true
e15fd55b-80b7-4b19-9d6a-10b76bb6ca83	2026-08-25 15:12	2026-08-25 15:11	2026-08-25 15:11	XLI	XLI270115P00175000	put	175.0000	2027-01-15	6.2000	6.0500	6.2000	178.4400	27280.00	27280.00	0.00	44	7	44	1538	0.0286085825747724	0.204169043843481	0.204169043843481	true	false	false	true
85af0f7a-a567-49f5-b2d7-345ae03b859f	2026-08-25 15:12	2026-08-25 15:11	2026-08-25 15:11	XLI	XLI270115P00175000	put	175.0000	2027-01-15	6.2000	6.0500	6.2000	178.4250	27280.00	27280.00	0.00	44	5	88	1538	0.0572171651495449	0.204037928054123	0.204037928054123	true	false	false	true
a3173357-ee3a-45bd-afc7-900b00f5f177	2026-08-25 14:12	2026-08-25 14:12	2026-08-25 14:12	XLI	XLI260904C00175000	call	175.0000	2026-09-04	4.3000	4.1000	4.3500	178.0000	18060.00	17630.00	0.00	42	15	42	2	21	0.177795005474505	0.177795005474505	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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