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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = XRT270115P00085000×ticker = XRT×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

0fd75b58-a493-41de-840c-0d3b0d35ad16	2026-08-17 10:37	2026-08-17 10:37	2026-08-17 10:37	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8000	3.5500	3.8000	88.1900	42560.00	1520.00	0.00	112	8	112	12518	0.00894711615274005	0.263492141726148	0.263492141726148	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	273660796.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9d7a44f1-3aa0-4baa-9c42-ad16588441ea	2026-08-17 10:37	2026-08-17 10:37	2026-08-17 10:37	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.7900	3.6500	3.8000	88.1600	758395.00	639145.00	119250.00	2000	54	2500	12518	0.199712414123662	0.260934059868045	0.262996456057392	false	false	false	true
f54c89c0-2b38-43dc-9a25-a3322b37129a	2026-08-17 12:56	2026-08-17 12:55	2026-08-17 12:55	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.9500	3.8500	4.0000	87.8500	617780.00	574330.00	41080.00	1564	73	4065	12518	0.324732385365074	0.264978588566417	0.264978588566417	false	false	false	true
890935a3-f0c7-4352-9f97-13b643ba8bb9	2026-08-17 14:56	2026-08-17 14:56	2026-08-17 14:56	XRT	XRT270115P00085000	put	85.0000	2027-01-15	4.0000	4.0000	4.0500	87.6450	22400.00	0.00	9600.00	56	18	4596	12518	0.36715130212494	0.263882699021885	0.263882699021885	false	false	false	true
6ebf78c4-f62d-4452-91c3-55b04db6b8ad	2026-08-17 14:56	2026-08-17 14:56	2026-08-17 14:56	XRT	XRT270115P00085000	put	85.0000	2027-01-15	4.0000	3.9500	4.0500	87.6400	17200.00	13200.00	4000.00	43	5	4639	12518	0.370586355647867	0.263797527481546	0.263797527481546	false	false	false	true
f1933815-840c-4c4e-abbd-99d6e75df7f5	2026-08-18 10:33	2026-08-18 10:33	2026-08-18 10:33	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.9000	3.7500	3.9000	88.1600	94732.00	94732.00	0.00	243	10	425	17520	0.0242579908675799	0.268487703739725	0.268487703739725	true	false	false	true
a429f65b-4f06-47ae-9d98-17f4241e46d4	2026-08-18 10:33	2026-08-18 10:33	2026-08-18 10:33	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.9500	3.7500	3.9500	88.1600	313910.00	304940.00	8970.00	795	21	1250	17520	0.0713470319634703	0.270881942861912	0.268487703739725	true	false	false	true
14f2a8f0-01b6-432a-87bd-67e96a151a95	2026-08-18 10:33	2026-08-18 10:33	2026-08-18 10:33	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.9000	3.7500	3.9000	88.1600	11700.00	11700.00	0.00	30	7	455	17520	0.0259703196347032	0.268487703739725	0.268487703739725	true	false	false	true
e1820e38-9a13-4f91-84d0-105eab8076ce	2026-08-27 10:34	2026-08-27 10:34	2026-08-27 10:34	XRT	XRT270115P00085000	put	85.0000	2027-01-15	4.0500	3.8500	4.0500	87.0150	247050.00	247050.00	0.00	610	15	750	18770	0.039957378795951	0.262240989139138	0.262240989139138	false	false	false	true
d449e54c-13b2-4a99-b048-b73d34417c3e	2026-08-27 11:32	2026-08-27 11:32	2026-08-27 11:32	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.9500	3.9500	4.1500	87.1300	21725.00	0.00	21725.00	55	5	805	18770	0.0428875865743207	0.259454699166086	0.259454699166086	false	false	false	true
b9911c16-96e8-45f4-826e-3d1ece978f47	2026-08-27 11:32	2026-08-27 11:32	2026-08-27 11:32	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.9500	3.8000	3.9500	87.1300	68335.00	68335.00	0.00	173	27	1000	18770	0.053276505061268	0.259454699166086	0.259454699166086	false	false	false	true
03707a9e-1e1c-4fbf-8e02-4afca75243db	2026-08-27 15:44	2026-08-27 15:44	2026-08-27 15:44	XRT	XRT270115P00085000	put	85.0000	2027-01-15	4.1500	4.1500	4.2500	86.5850	23240.00	0.00	23240.00	56	7	1056	18770	0.056259989344699	0.259145667207261	0.259145667207261	false	false	false	true
31b0fb2e-6764-46a4-bab3-2b446e40a9e6	2026-08-27 15:45	2026-08-27 15:45	2026-08-27 15:45	XRT	XRT270115P00085000	put	85.0000	2027-01-15	4.1500	4.1500	4.2500	86.6500	29880.00	0.00	29880.00	72	10	1128	18770	0.0600958977091103	0.26036226155085	0.26036226155085	false	false	false	true
e9233fe0-bae8-4752-acd2-c067e1232b02	2026-08-27 15:46	2026-08-27 15:46	2026-08-27 15:46	XRT	XRT270115P00085000	put	85.0000	2027-01-15	4.1500	4.0000	4.2500	86.6700	154380.00	153550.00	830.00	372	13	1500	18770	0.079914757591902	0.260735724967379	0.260735724967379	false	false	false	true
4fde1a41-1922-4819-98b7-c06a36ea165d	2026-08-31 10:11	2026-08-31 10:11	2026-08-31 10:11	XRT	XRT270115P00085000	put	85.0000	2027-01-15	4.2500	4.2500	4.3000	86.3500	16150.00	0.00	16150.00	38	6	179	21020	0.00851569933396765	0.260178904168961	0.260178904168961	false	false	false	true
c42a2270-bc7e-4244-9131-485b90742b6b	2026-09-04 10:11	2026-09-04 10:11	2026-09-04 10:11	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8500	3.7500	3.8500	87.1100	195965.00	78155.00	0.00	509	5	513	24020	0.0213572023313905	0.257969074304698	0.257969074304698	true	false	false	true
f7a97056-cf7a-4bbd-bb6d-1cdcf6810f71	2026-09-04 10:11	2026-09-04 10:11	2026-09-04 10:11	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8500	3.7000	3.8500	87.1100	229460.00	98560.00	0.00	596	8	1109	24020	0.0461698584512906	0.257969074304698	0.257969074304698	true	false	false	true
a8564885-3224-492f-8c7d-dbfbc980660e	2026-09-04 10:12	2026-09-04 10:11	2026-09-04 10:11	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8500	3.7000	3.8500	87.1100	52360.00	52360.00	0.00	136	6	1245	24020	0.0518318068276436	0.257969074304698	0.257969074304698	false	false	false	true
6aafcedc-8772-4d6c-a8b1-bb562e700d45	2026-09-04 10:12	2026-09-04 10:11	2026-09-04 10:11	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8500	3.7000	3.9000	87.1100	228305.00	111650.00	80080.00	593	5	1838	24020	0.0765195670274771	0.257969074304698	0.257969074304698	false	false	false	true
99c18fd2-904e-4a23-9eac-9a5d0f2aaa19	2026-09-04 10:14	2026-09-04 10:14	2026-09-04 10:14	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8500	3.7500	3.9000	87.0500	385770.00	52360.00	333410.00	1002	14	3164	24020	0.131723563696919	0.256839713714041	0.256839713714041	false	false	false	true
d4ddbda7-a1a4-48d2-a6e8-eb80af1928bb	2026-09-04 10:15	2026-09-04 10:15	2026-09-04 10:15	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8500	3.8000	3.9000	87.1100	31185.00	21175.00	7700.00	81	5	3379	24020	0.14067443796836	0.257969074304698	0.257969074304698	false	false	false	true
c9df6059-3006-4fcc-83e2-e9760badbbb4	2026-09-04 10:29	2026-09-04 10:28	2026-09-04 10:28	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.7000	3.6500	3.9000	87.4699	36635.00	5185.00	31450.00	99	17	3703	24020	0.154163197335554	0.257112184584351	0.257112184584351	false	false	false	true
3d147885-2266-4b81-be48-3b969e6c166b	2026-09-04 11:37	2026-09-04 11:37	2026-09-04 11:37	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8000	3.6500	3.9000	87.2800	77520.00	77140.00	380.00	204	6	3910	24020	0.16278101582015	0.258636329537526	0.258636329537526	true	false	false	true
ba89b627-2134-42e8-8ddc-124ba682678e	2026-09-04 11:37	2026-09-04 11:37	2026-09-04 11:37	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8000	3.6500	3.8000	87.2800	120080.00	120080.00	0.00	316	20	4226	24020	0.1759367194005	0.258636329537526	0.258636329537526	false	false	false	true
ca5b0e7c-8efc-4aa5-a39f-0fa3848063ff	2026-09-04 11:37	2026-09-04 11:37	2026-09-04 11:37	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8000	3.6500	3.8500	87.2800	104880.00	64980.00	11020.00	276	6	4502	24020	0.187427144046628	0.258636329537526	0.258636329537526	false	false	false	true
f4d55464-4922-4fd7-b5dd-2851249f991c	2026-09-04 11:37	2026-09-04 11:37	2026-09-04 11:37	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8000	3.6500	3.8500	87.2900	96140.00	5700.00	15200.00	253	6	4755	24020	0.197960033305579	0.258822278078	0.258822278078	false	false	false	true
b145783b-0143-45af-ac34-19f1598d552b	2026-09-04 11:38	2026-09-04 11:38	2026-09-04 11:38	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8000	3.8000	3.8500	87.2800	83980.00	0.00	83980.00	221	6	5260	24020	0.218984179850125	0.258636329537526	0.258636329537526	false	false	false	true
d9cba0cd-482b-44da-a9f0-e055e55bca31	2026-09-04 11:38	2026-09-04 11:38	2026-09-04 11:38	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8000	3.8000	3.8500	87.2900	83980.00	0.00	83980.00	221	6	5706	24020	0.237552039966694	0.258822278078	0.258822278078	false	false	false	true
720610d1-26ab-41e3-8c12-1c591c75b1a7	2026-09-04 11:38	2026-09-04 11:38	2026-09-04 11:38	XRT	XRT270115P00085000	put	85.0000	2027-01-15	3.8000	3.7500	3.8500	87.2900	85500.00	0.00	79040.00	225	5	5485	24020	0.228351373855121	0.258822278078	0.258822278078	false	false	false	true
053ce5da-f702-46a1-ab7c-ea090d7f8bc6	2026-09-08 11:08	2026-09-08 11:08	2026-09-08 11:08	XRT	XRT270115P00085000	put	85.0000	2027-01-15	4.3500	3.5000	4.4000	85.8800	12615000.00	12615000.00	0.00	29000	1	29000	29023	0.999207525066327	0.264652222821904	0.264652222821904	false	true	false	true