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 = XLU×

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

c9b63f35-565a-4ffa-93cd-ab6d85c54ea5	2026-09-08 11:43	2026-09-08 11:43	2026-09-08 11:43	XLU	XLU260918P00043500	put	43.5000	2026-09-18	0.4100	0.4100	0.4900	43.5950	36203.00	0.00	36203.00	883	9	1415	7881	0.179545742926025	0.165900231837471	0.165900231837471	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	21723451602.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3985c794-0d7c-43c2-929d-079f3306cf03	2026-09-08 11:43	2026-09-08 11:43	2026-09-08 11:43	XLU	XLU260918P00043500	put	43.5000	2026-09-18	0.4100	0.4100	0.4900	43.5950	20869.00	0.00	20869.00	509	39	532	7881	0.067504123842152	0.165900231837471	0.165900231837471	true	false	false	true
0d5c609a-ab66-46b0-a985-eacface139ad	2026-09-08 10:40	2026-09-08 10:40	2026-09-08 10:40	XLU	XLU280121P00045000	put	45.0000	2028-01-21	3.8000	3.7000	3.9500	43.6550	19380.00	13680.00	5700.00	51	7	51	5280	0.00965909090909091	0.219955391002588	0.219955391002588	false	false	false	true
7fc226a8-8828-440d-8903-f794c0fadf3d	2026-09-08 10:03	2026-09-08 10:03	2026-09-08 10:03	XLU	XLU261016C00043000	call	43.0000	2026-10-16	1.0500	1.0000	1.0600	43.4350	16601.00	16601.00	0.00	158	11	426	5090	0.0836935166994106	0.126784107151125	0.128694713808174	true	false	false	true
d11339a4-0561-45b3-aa7e-0ce9447fa678	2026-09-04 13:22	2026-09-04 13:21	2026-09-04 13:21	XLU	XLU260918C00044000	call	44.0000	2026-09-18	0.1800	0.1700	0.1800	42.9900	10044.00	10044.00	0.00	558	30	741	3435	0.215720524017467	0.153760865253307	0.153760865253307	false	false	false	true
d79a5648-5d67-45ff-aa44-338e98856ebb	2026-09-04 13:19	2026-09-04 13:19	2026-09-04 13:19	XLU	XLU261218P00038500	put	38.5000	2026-12-18	0.2100	0.2100	0.2300	43.0000	13608.00	0.00	13608.00	648	25	1210	1984	0.609879032258065	0.184597153146231	0.184597153146231	false	false	false	true
d02c4969-a125-4207-b5f7-756a9b61351b	2026-09-04 11:53	2026-09-04 11:53	2026-09-04 11:53	XLU	XLU260918P00043000	put	43.0000	2026-09-18	0.4300	0.4000	0.4400	43.0850	21500.00	21500.00	0.00	500	9	635	11433	0.055540977871075	0.148963706310517	0.148963706310517	false	false	false	true
923675f0-a0ff-4009-be92-ff4b2840541e	2026-09-04 11:19	2026-09-04 11:19	2026-09-04 11:19	XLU	XLU260911C00043000	call	43.0000	2026-09-11	0.4700	0.4300	0.4800	43.2100	14100.00	14100.00	0.00	300	9	971	444	2.18693693693694	0.141030215591426	0.141030215591426	false	false	false	true
72f1c1e3-683b-46ed-97d6-330190bcf5e6	2026-09-03 12:27	2026-09-03 12:27	2026-09-03 12:27	XLU	XLU261218C00044000	call	44.0000	2026-12-18	1.1200	1.1200	1.1700	43.0450	12208.00	0.00	12208.00	109	5	2163	41460	0.0521707670043415	0.14305618658547	0.14305618658547	false	false	false	true
d604a62f-4d86-4361-be30-6345b93a4a4a	2026-09-03 11:26	2026-09-03 11:26	2026-09-03 11:26	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.8600	0.8600	0.9000	42.9850	101050.00	0.00	101050.00	1175	9	1617	6134	0.263612650798826	0.130388662089295	0.130388662089295	false	false	false	true
612dd4ec-4688-44c7-bc18-4cfe205a8060	2026-09-03 11:18	2026-09-03 11:17	2026-09-03 11:17	XLU	XLU261016C00045000	call	45.0000	2026-10-16	0.2300	0.2200	0.2500	42.9650	11500.00	2599.00	8901.00	500	18	667	5343	0.124836234325285	0.141326171251407	0.141326171251407	true	false	false	true
d168bcbf-0094-47c2-ae08-4451971c0410	2026-09-03 10:43	2026-09-03 10:43	2026-09-03 10:43	XLU	XLU261218C00044000	call	44.0000	2026-12-18	1.1000	1.1000	1.1800	42.9400	44000.00	0.00	44000.00	400	41	1104	41460	0.0266280752532561	0.14609975738248	0.14609975738248	false	false	false	true
3603e357-02d8-4dda-923b-de1069039cf4	2026-09-03 10:33	2026-09-03 10:33	2026-09-03 10:33	XLU	XLU261218C00044000	call	44.0000	2026-12-18	1.0500	1.0500	1.1500	42.8151	12810.00	0.00	7245.00	122	12	486	41460	0.0117221418234443	0.146701421367584	0.146701421367584	false	false	false	true
f6b11e3a-99d8-448f-bd46-7a8344e74a6c	2026-09-02 15:32	2026-09-02 15:32	2026-09-02 15:32	XLU	XLU270115C00043000	call	43.0000	2027-01-15	1.5800	1.5300	1.6000	42.6403	31600.00	31600.00	0.00	200	5	206	1221	0.168714168714169	0.142709932325095	0.142709932325095	false	false	false	true
a5780de8-64d6-4d59-b5f9-f747cd9c2e97	2026-09-02 11:35	2026-09-02 11:35	2026-09-02 11:35	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.7000	0.6800	0.7100	42.4600	14000.00	14000.00	0.00	200	7	1430	4623	0.309322950465066	0.145459092806964	0.145459092806964	false	false	false	true
7de23d10-6470-4c4b-8ca1-7178ce8b83c0	2026-09-01 14:49	2026-09-01 14:49	2026-09-01 14:49	XLU	XLU261016C00045000	call	45.0000	2026-10-16	0.2000	0.1600	0.2000	42.3899	10000.00	10000.00	0.00	500	8	1140	4499	0.253389642142698	0.156687067220845	0.156687067220845	false	false	false	true
26727e64-1e4f-4051-b510-01d1e9211c6f	2026-09-01 14:14	2026-09-01 14:14	2026-09-01 14:14	XLU	XLU261218P00039000	put	39.0000	2026-12-18	0.3600	0.3600	0.4000	42.4000	13428.00	0.00	13428.00	373	30	379	693	0.546897546897547	0.182440431055303	0.182440431055303	false	false	false	true
5814a4ce-f872-4665-9881-55da7af0a7b5	2026-09-01 13:19	2026-09-01 13:19	2026-09-01 13:19	XLU	XLU260918C00043500	call	43.5000	2026-09-18	0.1800	0.1700	0.1900	42.2550	10206.00	216.00	0.00	567	8	1652	2213	0.746497966561229	0.159538404094915	0.159538404094915	true	false	false	true
e8cc3c88-93b4-42ef-9261-316b003015d7	2026-09-01 13:02	2026-09-01 13:02	2026-09-01 13:02	XLU	XLU261218C00046000	call	46.0000	2026-12-18	0.4200	0.4200	0.4300	42.2350	28140.00	0.00	28140.00	670	11	2031	4593	0.442194644023514	0.159728268138921	0.159728268138921	false	false	false	true
ef6407bd-756b-4c80-81cb-af23df967ab9	2026-09-01 11:36	2026-09-01 11:35	2026-09-01 11:35	XLU	XLU261218P00040000	put	40.0000	2026-12-18	0.5500	0.5500	0.5900	42.4499	16170.00	0.00	16170.00	294	36	305	10590	0.0288007554296506	0.180096949125322	0.180415286163003	false	false	false	true
b4f3fe18-0c2e-4e57-8342-bf6d106c340f	2026-09-01 10:56	2026-09-01 10:56	2026-09-01 10:56	XLU	XLU261218C00043000	call	43.0000	2026-12-18	1.3900	1.3600	1.4000	42.4350	10425.00	4448.00	5977.00	75	6	298	1250	0.2384	0.154050978091864	0.154327864797873	false	false	false	true
6a3d1501-5f75-437e-a5f9-b763380d2aa9	2026-09-01 10:55	2026-09-01 10:55	2026-09-01 10:55	XLU	XLU261016C00044000	call	44.0000	2026-10-16	0.3500	0.3200	0.3600	42.4400	26810.00	140.00	26670.00	766	19	5754	1879	3.06226716338478	0.142759629503736	0.142759629503736	false	false	false	true
1207d182-b8d1-47cc-b1b2-ba564976d32b	2026-09-01 10:28	2026-09-01 10:28	2026-09-01 10:28	XLU	XLU261016C00044000	call	44.0000	2026-10-16	0.3400	0.3400	0.3500	42.3400	68612.00	0.00	68612.00	2018	18	4945	1879	2.6317189994678	0.146203728575222	0.146203728575222	false	false	false	true
ab51ae77-354b-40e0-bbf5-4414d53cde0b	2026-09-01 10:08	2026-09-01 10:08	2026-09-01 10:08	XLU	XLU261016C00044000	call	44.0000	2026-10-16	0.3300	0.3300	0.3700	42.3000	92103.00	0.00	92103.00	2791	25	2894	1879	1.5401809473124	0.14629748319294	0.14629748319294	false	false	false	true
2ad15e99-dc6e-4add-9906-7bbd5a941a00	2026-08-31 14:40	2026-08-31 14:39	2026-08-31 14:39	XLU	XLU260918C00044000	call	44.0000	2026-09-18	0.1300	0.1200	0.1300	42.2788	34398.00	34398.00	0.00	2646	8	3006	5498	0.546744270643871	0.168356473554804	0.168356473554804	true	false	false	true
2c9ea128-3bb5-4cc4-bde9-3c7c42d319ae	2026-08-31 13:40	2026-08-31 13:40	2026-08-31 13:40	XLU	XLU261218P00040000	put	40.0000	2026-12-18	0.6300	0.6300	0.6600	42.2000	14805.00	0.00	14805.00	235	30	1224	9582	0.12773951158422	0.182860727305978	0.182860727305978	false	false	false	true
4490fc94-e707-4574-a509-f3b4c66f083c	2026-08-31 12:42	2026-08-31 12:42	2026-08-31 12:42	XLU	XLU261218P00041000	put	41.0000	2026-12-18	0.9200	0.9100	0.9600	42.2401	26128.00	92.00	26036.00	284	33	1322	668	1.97904191616766	0.181698741399925	0.181698741399925	false	false	false	true
8073c52a-a4d1-4e50-8b7e-be8e420674bc	2026-08-31 11:50	2026-08-31 11:50	2026-08-31 11:50	XLU	XLU261218P00040000	put	40.0000	2026-12-18	0.6200	0.6200	0.6600	42.3000	28954.00	0.00	28954.00	467	24	986	9582	0.102901273220622	0.18479417867982	0.18479417867982	false	false	false	true
c382fbc9-78e2-4aef-a3e3-f038d74f1b80	2026-08-31 11:05	2026-08-31 11:05	2026-08-31 11:05	XLU	XLU260918P00044000	put	44.0000	2026-09-18	1.8300	1.8300	1.8700	42.2050	27450.00	0.00	27450.00	150	7	662	3331	0.198739117382168	0.168161269023472	0.168161269023472	false	false	false	true
7c2b8450-05dd-4f33-a192-1c5d93e42c3e	2026-08-31 11:05	2026-08-31 11:05	2026-08-31 11:05	XLU	XLU260918P00044000	put	44.0000	2026-09-18	1.8300	1.8200	1.8700	42.2150	22875.00	4575.00	13725.00	125	5	387	3331	0.11618132692885	0.172020798134949	0.172020798134949	true	false	false	true
baeea87d-67cd-4169-8137-6d01e638bef4	2026-08-31 11:02	2026-08-31 11:02	2026-08-31 11:02	XLU	XLU261218P00041000	put	41.0000	2026-12-18	0.9400	0.9400	0.9800	42.1900	50290.00	0.00	50290.00	535	12	1036	668	1.55089820359281	0.182165625608732	0.182165625608732	false	false	false	true
47e0edfa-a1a3-4af1-a3a5-a82b5dee3c85	2026-08-31 11:02	2026-08-31 11:02	2026-08-31 11:02	XLU	XLU261218P00041000	put	41.0000	2026-12-18	0.9800	0.9400	0.9800	42.1950	16856.00	16856.00	0.00	172	5	501	668	0.75	0.187176263492713	0.187176263492713	false	false	false	true
55b0577d-6f56-49fe-8bd3-de1e5502f1b7	2026-08-31 10:54	2026-08-31 10:54	2026-08-31 10:54	XLU	XLU260904C00040000	call	40.0000	2026-09-04	2.2200	2.2200	2.3500	42.1800	11100.00	0.00	11100.00	50	9	61	5	12.2	0.299416324374199	0.299416324374199	true	false	false	true
99ec2cef-8965-4bc5-9a7e-3a69ce46adf6	2026-08-31 10:14	2026-08-31 10:14	2026-08-31 10:14	XLU	XLU261218C00044000	call	44.0000	2026-12-18	0.8400	0.8100	0.8600	42.0200	10500.00	10500.00	0.00	125	6	175	41316	0.00423564720689321	0.155958286577771	0.1563775394448	false	false	false	true
62ca6450-9746-47c8-9c0f-96d7a1c8c9de	2026-08-31 10:11	2026-08-31 10:11	2026-08-31 10:11	XLU	XLU261218P00040000	put	40.0000	2026-12-18	0.6800	0.6800	0.7300	42.0450	28832.00	0.00	28832.00	424	15	447	9582	0.0466499686912962	0.18446156290371	0.18446156290371	false	false	false	true
e21ef105-ea7a-4ad5-abb8-fa36fa22e92d	2026-08-31 09:38	2026-08-31 09:38	2026-08-31 09:38	XLU	XLU270115C00043000	call	43.0000	2027-01-15	1.3500	1.3200	1.3500	41.9900	13500.00	13500.00	0.00	100	8	939	694	1.35302593659942	0.150908182506811	0.150908182506811	false	false	false	true
91909ffe-2b86-4db0-b786-f4f02fc19054	2026-08-28 15:41	2026-08-28 15:41	2026-08-28 15:41	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.8000	0.8000	0.8600	42.6650	26720.00	0.00	26720.00	334	41	1018	1557	0.653821451509313	0.137179053755069	0.137179053755069	true	false	false	true
b86b8b87-207e-463c-ac3d-1a2d5c8a9cad	2026-08-28 14:49	2026-08-28 14:49	2026-08-28 14:49	XLU	XLU260904C00043000	call	43.0000	2026-09-04	0.2400	0.2400	0.2600	42.6350	12000.00	0.00	12000.00	500	26	1170	712	1.64325842696629	0.162376373875063	0.162376373875063	true	false	false	true
cc46cdb0-140c-42ed-b707-db7cdd1564e2	2026-08-28 12:58	2026-08-28 12:58	2026-08-28 12:58	XLU	XLU260918P00043000	put	43.0000	2026-09-18	0.7700	0.7300	0.7700	42.6400	310695.00	310695.00	0.00	4035	22	4272	7716	0.553654743390358	0.153477211400275	0.153477211400275	false	false	false	true
de97fd86-ae90-43a7-ada5-ffdd20442069	2026-08-28 12:38	2026-08-28 12:38	2026-08-28 12:38	XLU	XLU260911C00042500	call	42.5000	2026-09-11	0.7800	0.7700	0.7850	42.9350	102180.00	102180.00	0.00	1310	12	1319	22	59.9545454545455	0.1475381818163	0.1475381818163	false	false	false	true
da00c0b4-9afe-4533-91c9-804a90ed607d	2026-08-28 12:19	2026-08-28 12:19	2026-08-28 12:19	XLU	XLU260904C00043000	call	43.0000	2026-09-04	0.4100	0.3000	0.4100	43.0550	10537.00	10537.00	0.00	257	26	443	712	0.622191011235955	0.15367506169586	0.15367506169586	true	false	false	true
1c69c9d9-db97-4f0f-af72-018f7a32a805	2026-08-27 15:46	2026-08-27 15:46	2026-08-27 15:46	XLU	XLU261016P00042000	put	42.0000	2026-10-16	0.5500	0.3500	0.5700	43.2150	11000.00	2750.00	8250.00	200	5	2145	12373	0.173361351329508	0.179204403938986	0.179204403938986	false	false	false	true
1bd4477d-f933-4b5d-8973-12d3bf3b6d12	2026-08-27 15:03	2026-08-27 15:03	2026-08-27 15:03	XLU	XLU271217C00060000	call	60.0000	2027-12-17	0.4100	0.3900	0.4300	43.1199	43132.00	17056.00	26076.00	1052	17	1052	6690	0.157249626307922	0.178392545684827	0.178392545684827	false	false	false	true
b9d63d8f-b521-4840-91cb-c17f4cf725e9	2026-08-27 13:33	2026-08-27 13:33	2026-08-27 13:33	XLU	XLU260918P00042000	put	42.0000	2026-09-18	0.2300	0.2100	0.2300	43.1499	18170.00	18170.00	0.00	790	34	1305	13488	0.0967526690391459	0.162962209675945	0.162962209675945	false	false	false	true
6773d147-f16a-45f3-b9d2-5094e833a9ec	2026-08-27 13:31	2026-08-27 13:30	2026-08-27 13:30	XLU	XLU260911C00044500	call	44.5000	2026-09-11	0.1300	0.1300	0.1500	43.1650	18135.00	0.00	18135.00	1395	9	1414	113	12.5132743362832	0.15358136413966	0.15358136413966	false	false	false	true
89d4c3aa-311f-45b4-b27a-a0a81b6f9315	2026-08-27 11:55	2026-08-27 11:55	2026-08-27 11:55	XLU	XLU270115C00043000	call	43.0000	2027-01-15	1.7900	1.7900	1.8800	42.9800	13427.00	0.00	13427.00	75	5	144	727	0.198074277854195	0.137447750584832	0.13936812005538	false	false	false	true
e4cc2568-c951-4d02-9672-8c9934819fe0	2026-08-27 10:56	2026-08-27 10:55	2026-08-27 10:55	XLU	XLU261016C00043000	call	43.0000	2026-10-16	1.0000	0.9400	1.0800	43.0300	25000.00	21700.00	3300.00	250	5	1005	154	6.52597402597403	0.136954158950497	0.136954158950497	false	false	false	true
ed6384db-4538-41a1-a3fe-b2d986c84384	2026-08-27 10:53	2026-08-27 10:53	2026-08-27 10:53	XLU	XLU260918C00044500	call	44.5000	2026-09-18	0.2100	0.2000	0.2200	43.0900	12789.00	0.00	10983.00	609	30	689	2660	0.259022556390977	0.156565191878026	0.156565191878026	false	false	false	true
f4f74089-a42f-4033-9a89-24167a65bd0a	2026-08-27 09:56	2026-08-27 09:56	2026-08-27 09:56	XLU	XLU260904C00044000	call	44.0000	2026-09-04	0.1100	0.1000	0.1500	43.0400	13750.00	0.00	13750.00	1250	29	1293	1789	0.722750139742873	0.163336365394078	0.163336365394078	false	false	false	true
be3c4590-38c9-4531-83cf-bd5eab25c52f	2026-08-26 13:10	2026-08-26 13:10	2026-08-26 13:10	XLU	XLU260904C00044000	call	44.0000	2026-09-04	0.2700	0.2500	0.2700	43.5390	10206.00	10206.00	0.00	378	10	561	585	0.958974358974359	0.163858860607926	0.163858860607926	false	false	false	true