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×option_symbol = XLF260923P00056000×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	expiry

508cb3fa-a8ea-48e9-b7b7-24e7ce342b34	2026-09-21 09:35	2026-09-21 09:35	2026-09-21 09:35	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.2400	0.2000	0.2400	56.0500	14664.00	14664.00	0.00	611	27	611	16	38.1875	0.163182988186319	0.163182988186319	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	50017249837.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T13:35:57.878174Z"}	2026-10-03	2026-10-03 00:25	2026-10-03 00:25
00c381c5-b8a3-402f-a2d9-a200c99fee50	2026-09-22 09:47	2026-09-22 09:47	2026-09-22 09:47	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5300	0.5200	0.5900	55.5501	28090.00	0.00	28090.00	530	8	708	715	0.99020979020979	0.212323065889986	0.212323065889986	true	false	false	true
c845ab82-e9e6-46fd-a3c3-4be72898beea	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5600	0.5200	0.5800	55.5150	35168.00	4256.00	30912.00	628	8	1631	715	2.28111888111888	0.215749561385855	0.215749561385855	true	false	false	true
9abbc1f3-920a-473b-933f-eb2819d8dcf6	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5600	0.5600	0.5800	55.5150	17416.00	0.00	17416.00	311	9	2022	715	2.82797202797203	0.215749561385855	0.215749561385855	true	false	false	true
b60d0ce1-7643-4726-b641-419ec829abe6	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5700	0.5400	0.5800	55.5150	23997.00	4503.00	19494.00	421	13	2701	715	3.77762237762238	0.227056297445596	0.227056297445596	true	false	false	true
e8e2e904-0d7e-4dd5-b8af-db2a27a523a4	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5700	0.5300	0.5800	55.5101	13452.00	3762.00	9405.00	236	32	3187	715	4.45734265734266	0.222834663421613	0.222834663421613	false	false	false	true
a4125c96-4c7c-4522-b76a-7f642be5a7f2	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5700	0.5200	0.5800	55.5101	32034.00	7011.00	25023.00	562	10	3877	715	5.42237762237762	0.222834663421613	0.222834663421613	true	false	false	true
9caf552e-11ea-46b2-ac24-5a32733e33d1	2026-09-22 09:49	2026-09-22 09:49	2026-09-22 09:49	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.5600	0.4900	0.6300	55.5500	88312.00	79800.00	4704.00	1577	11	7074	715	9.89370629370629	0.244425493813521	0.244425493813521	false	false	false	true
955e439c-58b1-4582-b3de-44041591a9b5	2026-09-22 09:50	2026-09-22 09:49	2026-09-22 09:49	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.6200	0.5900	0.6600	55.4893	100006.00	90148.00	9796.00	1613	17	8817	715	12.3314685314685	0.260495925407109	0.260495925407109	true	false	false	true
dadb287c-4e26-43dd-85c7-2b06cd098c08	2026-09-22 09:50	2026-09-22 09:50	2026-09-22 09:50	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.6400	0.5700	0.6600	55.4850	27264.00	25344.00	1920.00	426	23	10036	715	14.0363636363636	0.278294991178121	0.278294991178121	false	false	false	true
609e5ef7-15e4-4b6e-99e6-d73a133331f6	2026-09-23 09:47	2026-09-23 09:47	2026-09-23 09:47	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.2600	1.0900	1.2600	54.0000	49392.00	49392.00	0.00	392	8	392	20012	0.0195882470517689	0.745706117764162	0.745706117764162	false	false	false	true
c5bd86df-eadb-4780-8b27-950c8cdda48a	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.2600	1.0900	1.2600	54.0000	123732.00	123732.00	0.00	982	21	1374	20012	0.0686588047171697	0.696678042721908	0.696678042721908	false	false	false	true
fbdae3f8-79ff-45ba-95b8-2f5fffa02c01	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0400	0.9300	1.0500	54.9500	38584.00	38376.00	0.00	371	8	1746	20012	0.0872476514091545	0.263442926253347	0.263442926253347	false	false	false	true
f7d55a51-e0d8-43a7-b993-45f5fb17a5fc	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0500	1.0400	1.0600	54.9400	73290.00	67830.00	0.00	698	20	2784	20012	0.139116530081951	0.263442926253347	0.322671826716728	true	false	false	true
aeb56c76-f5b9-4089-851d-0192c01db842	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0400	1.0400	1.0500	54.9420	35360.00	0.00	35360.00	340	29	2086	20012	0.104237457525485	0.263442926253347	0.263442926253347	false	false	false	true
f00127b3-60f9-4d02-9257-bb43fbdbeef6	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0400	1.0400	1.0500	54.9350	44616.00	0.00	44616.00	429	8	4174	20012	0.208574855086948	0.263442926253347	0.263442926253347	false	false	false	true
06cf4f6b-c911-4e9f-bf96-b697ba32ac70	2026-09-23 10:33	2026-09-23 10:33	2026-09-23 10:33	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9600	0.9200	0.9600	55.0200	54624.00	43296.00	0.00	569	13	4815	20012	0.240605636618029	0.51612060024984	0.51612060024984	true	false	false	true
0f343cd1-f8af-4fd3-a920-8d8ec83e33f8	2026-09-23 10:34	2026-09-23 10:34	2026-09-23 10:34	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9700	0.9700	1.0100	55.0200	121056.00	0.00	121056.00	1248	31	6375	20012	0.318558864681191	0.532105563403244	0.532105563403244	false	false	false	true
bd9666bc-2efc-46e7-a8e2-5aa3ecd606e3	2026-09-23 10:37	2026-09-23 10:37	2026-09-23 10:37	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9400	0.8700	0.9400	55.0450	38634.00	38634.00	0.00	411	5	6804	20012	0.339996002398561	0.427387072149694	0.427387072149694	true	false	false	true
4ac98b55-1c0e-4f4e-90c0-8ea0d5e7ffcc	2026-09-23 10:38	2026-09-23 10:38	2026-09-23 10:38	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9600	0.9300	0.9600	55.0100	31488.00	31488.00	0.00	328	6	7203	20012	0.359934039576254	0.449115611559019	0.449115611559019	true	false	false	true
d20ada76-545a-45ff-9f1a-8fa1be00067b	2026-09-23 10:38	2026-09-23 10:38	2026-09-23 10:38	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9600	0.9600	1.0100	55.0150	160512.00	0.00	160512.00	1672	34	8875	20012	0.443483909654207	0.514546912008804	0.514546912008804	false	false	false	true
e2f09ae3-3412-42d3-b1fa-66d4c85c22c0	2026-09-23 10:38	2026-09-23 10:38	2026-09-23 10:38	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9700	0.9700	1.0700	55.0050	242500.00	0.00	242500.00	2500	6	11375	20012	0.568408954627224	0.704604136045605	0.704604136045605	false	false	false	true
a97d43fc-df31-4ca5-8d1e-b574bc588753	2026-09-23 11:01	2026-09-23 11:01	2026-09-23 11:01	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.1600	1.1600	1.2200	54.8000	115768.00	0.00	115768.00	998	27	12375	20012	0.61837897261643	0.59271869297997	0.59271869297997	false	false	false	true
e0568ccb-8ceb-4275-85c5-4c4e68b3fb03	2026-09-23 13:12	2026-09-23 13:12	2026-09-23 13:12	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.2600	1.1700	1.3200	54.0000	199584.00	18900.00	180684.00	1584	28	17963	20012	0.897611433140116	0.360758864632218	0.996945774907823	true	false	false