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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = XLF×

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

9eeabcac-f80d-444c-95b5-e2f7bb4f5ecf	2026-08-24 10:00	2026-08-24 10:00	2026-08-24 10:00	XLF	XLF270115C00062000	call	62.0000	2027-01-15	1.0500	1.0000	1.0500	58.2400	58695.00	58695.00	0.00	559	9	1400	3283	0.426439232409382	0.145208319531459	0.145208319531459	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	54976867713.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f3196089-9511-45db-b80f-a78dc9851a6b	2026-08-24 09:54	2026-08-24 09:54	2026-08-24 09:54	XLF	XLF261120C00060000	call	60.0000	2026-11-20	1.1800	1.1500	1.2300	58.3268	59000.00	0.00	59000.00	500	5	2177	6170	0.352836304700162	0.145573851469149	0.145573851469149	false	false	false	true
d66a84b2-f44c-4bbb-99eb-1b543f2a8c1b	2026-08-21 14:40	2026-08-21 14:40	2026-08-21 14:40	XLF	XLF260925P00055000	put	55.0000	2026-09-25	0.3000	0.2900	0.3100	57.4450	78750.00	0.00	54690.00	2625	19	2632	757	3.47688243064729	0.170182064913738	0.170182064913738	false	false	false	true
ff91674f-6f12-4152-87c0-19f648bf1ecf	2026-08-21 12:38	2026-08-21 12:38	2026-08-21 12:38	XLF	XLF260918P00056000	put	56.0000	2026-09-18	0.3700	0.3600	0.3700	57.4550	58645.00	58645.00	0.00	1585	12	2027	96708	0.02096000330893	0.155359291849113	0.155359291849113	false	false	false	true
917abb20-7e0a-4b7f-9daf-02f50b3a5381	2026-08-21 11:38	2026-08-21 11:38	2026-08-21 11:38	XLF	XLF260918C00059000	call	59.0000	2026-09-18	0.3600	0.3500	0.3600	57.4950	72000.00	72000.00	0.00	2000	33	2230	27421	0.0813245322927683	0.135186494869981	0.135186494869981	true	false	false	true
298a318e-890e-4c6f-870d-2c176584d142	2026-08-21 11:20	2026-08-21 11:20	2026-08-21 11:20	XLF	XLF270319P00053000	put	53.0000	2027-03-19	1.2200	1.2200	1.2500	57.4150	89670.00	0.00	89670.00	735	18	1252	1744	0.717889908256881	0.199758120240833	0.199758120240833	false	false	false	true
e4eaa241-f6bb-4431-9e65-e97254c0a1e7	2026-08-21 11:20	2026-08-21 11:19	2026-08-21 11:19	XLF	XLF270319P00054000	put	54.0000	2027-03-19	1.4400	1.3700	1.4600	57.4250	59328.00	30240.00	29088.00	412	14	413	4250	0.0971764705882353	0.195189653564383	0.195189653564383	false	false	false	true
1430a88c-9b6a-4720-8fe6-a1163f4b9577	2026-08-21 10:44	2026-08-21 10:44	2026-08-21 10:44	XLF	XLF270319P00057000	put	57.0000	2027-03-19	2.3500	2.3500	2.4000	57.4440	97525.00	0.00	97525.00	415	26	2043	2182	0.936296975252062	0.183731108618257	0.183731108618257	false	false	false	true
ffccaed0-5100-4d07-abbc-a331b71101e3	2026-08-21 10:43	2026-08-21 10:42	2026-08-21 10:42	XLF	XLF270319P00057000	put	57.0000	2027-03-19	2.3500	2.3300	2.3900	57.4550	67445.00	28670.00	38775.00	287	11	554	2182	0.253895508707608	0.183985661072179	0.183985661072179	false	false	false	true
80dc761c-bb10-4634-9077-cd2fbc645d80	2026-08-20 15:54	2026-08-20 15:53	2026-08-20 15:53	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.7800	0.7800	0.8100	57.0550	135408.00	0.00	135018.00	1736	34	8726	61060	0.142908614477563	0.138719003100042	0.138719003100042	false	false	false	true
d7d76b63-5c2a-475f-8db3-f9ce76f75874	2026-08-20 15:47	2026-08-20 15:47	2026-08-20 15:47	XLF	XLF260930P00057000	put	57.0000	2026-09-30	1.0700	0.9700	1.0700	57.0350	107000.00	107000.00	0.00	1000	24	1002	196	5.11224489795918	0.158298130372163	0.158298130372163	false	false	false	true
b738ea57-6625-4b90-8721-2d8922232a67	2026-08-20 15:46	2026-08-20 15:45	2026-08-20 15:45	XLF	XLF260828P00058000	put	58.0000	2026-08-28	1.1000	1.0500	1.1000	57.0200	79090.00	79090.00	0.00	719	25	3321	991	3.35116044399596	0.147936760744759	0.147936760744759	false	false	false	true
8020660d-78f0-4431-a614-86d2f388e89c	2026-08-20 15:45	2026-08-20 15:45	2026-08-20 15:45	XLF	XLF260828P00058000	put	58.0000	2026-08-28	1.1000	1.0500	1.1000	57.0150	217800.00	217800.00	0.00	1980	59	2390	991	2.4117053481332	0.146440850160211	0.146440850160211	false	false	false	true
3088a5b9-e0f0-48d6-a961-d16f6e762d08	2026-08-20 15:38	2026-08-20 15:37	2026-08-20 15:37	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.5400	0.5400	0.5700	57.0400	158220.00	0.00	158166.00	2930	38	6357	52743	0.120527842557306	0.135921529585332	0.135921529585332	false	false	false	true
bb64dff4-7329-4864-af13-dfce731e0809	2026-08-20 14:36	2026-08-20 14:36	2026-08-20 14:36	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.6400	0.6000	0.6400	57.2400	135552.00	135552.00	0.00	2118	50	2320	52743	0.0439868797755152	0.139603385617112	0.139603385617112	true	false	false	true
25467f69-f773-49b5-a78b-c11a8af1267e	2026-08-20 14:36	2026-08-20 14:36	2026-08-20 14:36	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.6400	0.6000	0.6400	57.2400	55168.00	55168.00	0.00	862	7	3202	52743	0.0607094780349999	0.139603385617112	0.139603385617112	true	false	false	true
7787d977-7a60-4b80-bf62-58197ac481f3	2026-08-20 14:36	2026-08-20 14:36	2026-08-20 14:36	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.7200	0.6900	0.7200	57.2400	135360.00	135360.00	0.00	1880	64	5518	61060	0.0903701277432034	0.141982288764099	0.141982288764099	true	false	false	true
95c87027-de2f-4b5a-82b9-69de429329e6	2026-08-20 12:23	2026-08-20 12:23	2026-08-20 12:23	XLF	XLF261120P00058000	put	58.0000	2026-11-20	1.9500	1.8900	1.9500	57.3312	83850.00	83850.00	0.00	430	12	529	1270	0.416535433070866	0.165132909456711	0.165132909456711	true	false	false	true
c3aa900c-669a-4a4c-9eaf-f88bf073be10	2026-08-19 15:45	2026-08-19 15:45	2026-08-19 15:45	XLF	XLF260821P00057500	put	57.5000	2026-08-21	0.2700	0.2300	0.2700	57.4950	130274.00	130248.00	26.00	4825	80	6112	8809	0.693835849699171	0.162507616475873	0.155167618623789	true	false	false	true
c375850f-e740-430a-ba6a-861f7ac1bb05	2026-08-19 15:24	2026-08-19 15:24	2026-08-19 15:24	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.7300	0.7300	0.7500	57.5300	115778.00	0.00	115778.00	1586	9	4230	59417	0.0711917464698655	0.131492162854899	0.131492162854899	false	false	false	true
8aa8ba04-c2c8-4c07-a998-b23260dd9c25	2026-08-19 12:34	2026-08-19 12:34	2026-08-19 12:34	XLF	XLF260918C00060000	call	60.0000	2026-09-18	0.2200	0.2200	0.2400	57.8300	53372.00	0.00	53372.00	2426	40	5187	35035	0.148051948051948	0.130424900073131	0.130424900073131	true	false	false	true
b542553c-d70b-4d6c-82d0-b31475d27fb6	2026-08-19 12:15	2026-08-19 12:15	2026-08-19 12:15	XLF	XLF270319P00056000	put	56.0000	2027-03-19	1.8800	1.8800	1.9900	57.9400	93624.00	0.00	93624.00	498	14	1558	351	4.43874643874644	0.189375848058907	0.189375848058907	false	false	false	true
740c5c15-51d5-4a0b-812d-96f8a27975e1	2026-08-19 12:13	2026-08-19 12:13	2026-08-19 12:13	XLF	XLF270319P00054000	put	54.0000	2027-03-19	1.3700	1.3600	1.4300	57.9200	91105.00	13837.00	77268.00	665	22	1729	1223	1.41373671300082	0.198415706029621	0.198415706029621	false	false	false	true
aa15a4b5-2962-42e7-a208-3843e4bc4ab4	2026-08-19 12:04	2026-08-19 12:04	2026-08-19 12:04	XLF	XLF270319P00056000	put	56.0000	2027-03-19	1.9100	1.9100	1.9700	57.8500	94163.00	0.00	94163.00	493	21	948	351	2.7008547008547	0.189442698124625	0.189442698124625	false	false	false	true
914d38dd-3075-4b2f-8e1c-ddac8ec6c7b7	2026-08-19 11:58	2026-08-19 11:58	2026-08-19 11:58	XLF	XLF270319P00054000	put	54.0000	2027-03-19	1.4100	1.3800	1.4500	57.7900	50619.00	18894.00	31725.00	359	16	527	1223	0.43090760425184	0.198982944075242	0.198982944075242	false	false	false	true
e75808bb-638d-465e-a7f8-ba68e028b4bb	2026-08-18 15:23	2026-08-18 15:23	2026-08-18 15:23	XLF	XLF270319P00057000	put	57.0000	2027-03-19	2.2700	2.2700	2.3000	57.9500	87849.00	0.00	87849.00	387	38	545	1307	0.416985462892119	0.189547685301654	0.189547685301654	false	false	false	true
27905bec-13e9-4dd0-976f-82152095d133	2026-08-18 12:58	2026-08-18 12:58	2026-08-18 12:58	XLF	XLF270630C00058000	call	58.0000	2027-06-30	4.5000	4.3500	4.6000	57.8150	837450.00	13950.00	823500.00	1861	121	1861	5	372.2	0.167422230372943	0.167422230372943	true	false	false	true
12401863-9325-4577-a212-1948c0e9a4eb	2026-08-18 12:36	2026-08-18 12:36	2026-08-18 12:36	XLF	XLF270319C00058000	call	58.0000	2027-03-19	3.4500	3.4500	3.5000	57.7700	60720.00	0.00	60720.00	176	11	177	571	0.309982486865149	0.164237203705626	0.164237203705626	false	false	false	true
909027aa-e8f6-4d41-8adf-8e31a1faa025	2026-08-18 12:03	2026-08-18 12:03	2026-08-18 12:03	XLF	XLF270115C00053000	call	53.0000	2027-01-15	6.2000	6.0500	6.2000	57.7700	500340.00	500340.00	0.00	807	22	1597	7575	0.210825082508251	0.172082680703298	0.172082680703298	true	false	false	true
39f6fa03-12a1-4902-a86c-40a16567d824	2026-08-18 12:03	2026-08-18 12:03	2026-08-18 12:03	XLF	XLF270115C00053000	call	53.0000	2027-01-15	6.2000	6.0500	6.3500	57.7700	489712.00	476050.00	13662.00	790	54	790	7575	0.104290429042904	0.173177518324314	0.172082680703298	true	false	false	true
a8fbbdb2-2d0a-4568-bc30-d24d2967b6be	2026-08-18 11:38	2026-08-18 11:38	2026-08-18 11:38	XLF	XLF260918C00059000	call	59.0000	2026-09-18	0.5000	0.4700	0.5100	57.8350	67800.00	150.00	67650.00	1356	13	1387	21136	0.0656226343679031	0.133727411394864	0.133446277216534	false	false	false	true
94eb8d96-c9bb-4d77-af03-b93291896201	2026-08-18 10:55	2026-08-18 10:55	2026-08-18 10:55	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.9500	0.9500	0.9800	57.8450	278445.00	0.00	278445.00	2931	11	3169	56872	0.0557216204810803	0.138849593951266	0.138849593951266	false	false	false	true
5fce5685-f8fe-4701-99a0-5cbd54b6ace5	2026-08-18 10:12	2026-08-18 10:12	2026-08-18 10:12	XLF	XLF261120C00058000	call	58.0000	2026-11-20	2.0600	2.0200	2.0900	57.9150	70452.00	20188.00	50264.00	342	6	342	12236	0.0279503105590062	0.154444299791002	0.154444299791002	false	false	false	true
fdb79fe8-92e1-47a6-8500-a53b817ea1ba	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	XLF	XLF270319P00058000	put	58.0000	2027-03-19	2.7500	2.7100	2.7500	57.8700	55000.00	55000.00	0.00	200	7	285	11460	0.024869109947644	0.190360476986664	0.190360476986664	false	false	false	true
4c9af731-95e7-4494-bd09-00c12641bad8	2026-08-18 09:51	2026-08-18 09:51	2026-08-18 09:51	XLF	XLF260821C00056000	call	56.0000	2026-08-21	1.8600	1.8500	1.9500	57.8400	51609.00	34371.00	17238.00	277	12	480	55163	0.00870148469082537	0.305669819047421	0.194433711615584	true	false	false	true
2ec3dc11-2f9b-449b-a796-89141bca5eec	2026-08-18 09:40	2026-08-18 09:40	2026-08-18 09:40	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5500	0.5500	0.5700	57.0000	55000.00	0.00	55000.00	1000	6	1021	47182	0.0216396083252088	0.141031109775953	0.141031109775953	false	false	false	true
a86290bd-0027-4abb-be0f-39f960e4a492	2026-08-17 15:58	2026-08-17 15:58	2026-08-17 15:58	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5900	0.5700	0.5900	57.6150	10561.00	10561.00	0.00	179	8	12677	35440	0.35770316027088	0.138819947518205	0.138819947518205	false	false	false	true
b0eae1f7-0d85-495c-9d5e-36149ee7a0e1	2026-08-17 15:58	2026-08-17 15:58	2026-08-17 15:58	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5900	0.5700	0.6000	57.6150	68440.00	68440.00	0.00	1160	40	11466	35440	0.323532731376975	0.138819947518205	0.138819947518205	false	false	false	true
2e46347b-298f-487c-9fc9-330aefc65f75	2026-08-17 15:58	2026-08-17 15:58	2026-08-17 15:58	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5900	0.5700	0.6000	57.6150	51743.00	41359.00	10384.00	877	21	12343	35440	0.348278781038375	0.138819947518205	0.138819947518205	false	false	false	true
a8e43712-945e-426c-9da4-64f2547135de	2026-08-17 15:44	2026-08-17 15:44	2026-08-17 15:44	XLF	XLF260918C00056000	call	56.0000	2026-09-18	2.1700	2.1600	2.2000	57.6251	601524.00	0.00	601524.00	2772	11	18011	43749	0.411689410043658	0.151915131752816	0.151915131752816	false	false	false	true
c86464fc-e7d4-4aab-81b0-ae4286993e35	2026-08-17 15:30	2026-08-17 15:30	2026-08-17 15:30	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5600	0.5500	0.5600	57.7150	13552.00	13552.00	0.00	242	13	9582	35440	0.270372460496614	0.139623647017604	0.139623647017604	false	false	false	true
67bf812f-a8f4-4bd7-a9a3-3817a2a972d4	2026-08-17 15:30	2026-08-17 15:30	2026-08-17 15:30	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.5600	0.5500	0.5600	57.7250	13384.00	13384.00	0.00	239	17	9340	35440	0.263544018058691	0.140169523394037	0.140169523394037	false	false	false	true
a63e5729-a472-4dd4-8d8e-2ce6a1855ce8	2026-08-17 15:28	2026-08-17 15:28	2026-08-17 15:28	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.9500	0.9300	0.9500	57.7450	28310.00	28310.00	0.00	298	22	30453	62001	0.491169497266173	0.134648666392123	0.134648666392123	false	false	false	true
4d4580c2-1532-4264-bec7-5e29882f52df	2026-08-17 15:26	2026-08-17 15:26	2026-08-17 15:26	XLF	XLF260918P00055000	put	55.0000	2026-09-18	0.1900	0.1800	0.1900	57.7300	11077.00	11077.00	0.00	583	23	3783	16190	0.233662754786905	0.161263346055859	0.161263346055859	false	false	false	true
828b1531-16a1-4d1f-959d-3415a97fe054	2026-08-17 15:14	2026-08-17 15:14	2026-08-17 15:14	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.8900	0.8900	0.9000	57.7500	33903.00	0.00	33903.00	381	9	1036	56220	0.0184276058342227	0.133050609836807	0.134516544606244	false	false	false	true
b1cc41ed-4f59-4adc-9de8-7bf041a273f8	2026-08-17 15:11	2026-08-17 15:11	2026-08-17 15:11	XLF	XLF270115C00065000	call	65.0000	2027-01-15	0.4200	0.4100	0.4300	57.7450	25494.00	0.00	25158.00	607	5	1025	46083	0.0222424755332769	0.148066416166656	0.148066416166656	false	false	false	true
a0b0924f-1785-43b8-b390-7dbeff806e6b	2026-08-17 15:00	2026-08-17 15:00	2026-08-17 15:00	XLF	XLF260918P00056000	put	56.0000	2026-09-18	0.3100	0.2800	0.3100	57.7615	10850.00	10850.00	0.00	350	11	7858	85844	0.0915381389497227	0.148377641582214	0.148377641582214	false	false	false	true
8a100ad1-2078-487d-9f2d-9c8603985636	2026-08-17 14:56	2026-08-17 14:56	2026-08-17 14:56	XLF	XLF260918P00052000	put	52.0000	2026-09-18	0.0600	0.0500	0.0700	57.7500	17400.00	17394.00	6.00	2900	25	13881	40389	0.343682685879819	0.212547911381975	0.212547911381975	true	false	false	true
050a2c26-68ce-47f5-bb9a-a7ef7460813a	2026-08-17 14:49	2026-08-17 14:49	2026-08-17 14:49	XLF	XLF270319P00058000	put	58.0000	2027-03-19	2.7400	2.7400	2.7500	57.8050	15344.00	0.00	1644.00	56	19	1095	11001	0.0995364057812926	0.187761288236303	0.187761288236303	false	false	false	true
4acc2ac8-6836-49ef-bad0-d0a9e4c2147c	2026-08-17 13:31	2026-08-17 13:31	2026-08-17 13:31	XLF	XLF270319P00053000	put	53.0000	2027-03-19	1.2500	1.2200	1.2500	57.8900	25000.00	25000.00	0.00	200	16	204	781	0.261203585147247	0.208591276866819	0.208591276866819	false	false	false	true