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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	expirydate	pricenumeric

313a1d01-4582-4c12-89cc-b6546a7c7a21	2026-09-09 14:05	2026-09-09 14:05	2026-09-09 14:05	XRT	XRT261218P00082000	put	82.0000	2026-12-18	2.8600	2.7000	3.2000	84.6700	25708.00	0.00	25708.00	90	13	90	2066	0.0435624394966118	0.254190451255719	0.254190451255719	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	292617327.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a3136728-080e-4013-83a4-487c99a12924	2026-09-09 15:31	2026-09-09 15:31	2026-09-09 15:31	XRT	XRT270115P00070000	put	70.0000	2027-01-15	0.6900	0.6600	0.8900	84.6450	22218.00	69.00	22149.00	322	36	323	236	1.36864406779661	0.281357325083731	0.281357325083731	false	false	false	true	false
189503c3-c07f-4127-86a2-805592a9611a	2026-09-10 09:43	2026-09-10 09:43	2026-09-10 09:43	XRT	XRT260918P00090000	put	90.0000	2026-09-18	6.0500	5.9500	6.1500	83.9200	26620.00	1815.00	0.00	44	6	44	371	0.118598382749326	0.25685822359278	0.25685822359278	false	false	false	true	false
5d395158-592a-4843-bf8b-4907ca9bbc6b	2026-09-10 09:43	2026-09-10 09:43	2026-09-10 09:43	XRT	XRT260918P00090000	put	90.0000	2026-09-18	6.0500	5.9500	6.1500	83.9700	18755.00	18150.00	605.00	31	9	75	371	0.202156334231806	0.295158028822818	0.295158028822818	false	false	false	true	false
225c8265-593d-4f05-a311-2381405ea1c2	2026-09-10 11:00	2026-09-10 11:00	2026-09-10 11:00	XRT	XRT261016P00085000	put	85.0000	2026-10-16	3.0500	2.9500	3.0500	83.6850	76250.00	15250.00	0.00	250	5	751	12020	0.0624792013311148	0.239599782745774	0.239599782745774	false	false	false	true	false
f7061636-24f0-4366-966a-62846b8ec2bd	2026-09-10 11:00	2026-09-10 11:00	2026-09-10 11:00	XRT	XRT261016P00085000	put	85.0000	2026-10-16	3.0000	3.0000	3.1500	83.6850	30900.00	0.00	30900.00	103	16	854	12020	0.0710482529118136	0.234796523070576	0.234796523070576	false	false	false	true	false
6e07cf2c-fa49-4a44-8c0f-1b95ccc9abdf	2026-09-10 11:01	2026-09-10 11:01	2026-09-10 11:01	XRT	XRT261016P00085000	put	85.0000	2026-10-16	3.0500	3.0500	3.1500	83.6700	12810.00	0.00	12810.00	42	10	970	12020	0.0806988352745424	0.238810686363077	0.238810686363077	false	false	false	true	false
abf4d404-a782-4613-ac73-9a106e1cda52	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	XRT	XRT261016P00085000	put	85.0000	2026-10-16	2.6000	2.6000	2.7500	84.3950	130000.00	0.00	130000.00	500	9	506	10480	0.0482824427480916	0.235430952854882	0.235430952854882	false	false	false	true	false
e39f66ca-1eee-423a-96d4-f49efca1cad3	2026-09-11 10:40	2026-09-11 10:40	2026-09-11 10:40	XRT	XRT261016P00085000	put	85.0000	2026-10-16	2.6000	2.5200	2.6000	84.4000	112446.00	95160.00	17286.00	433	12	939	10480	0.0895992366412214	0.235672335991573	0.233754088809126	false	false	false	true	false
6c81cfc6-99f8-4f12-b2d3-251277b35548	2026-09-14 11:05	2026-09-14 11:05	2026-09-14 11:05	XRT	XRT260925P00096000	put	96.0000	2026-09-25	10.4500	10.4500	12.5000	85.5400	17765.00	0.00	17765.00	17	14	17	0	0	0.378705511793732	0.378705511793732	true	false	false	true	false
9b354c4e-4b60-4a72-bbfd-9bda878690d3	2026-09-14 11:11	2026-09-14 11:11	2026-09-14 11:11	XRT	XRT260925C00083500	call	83.5000	2026-09-25	2.6300	2.6300	2.8500	85.5800	30246.00	264.00	29982.00	115	25	115	0	0	0.214252715457259	0.214252715457259	true	false	false	true	false
faf3874c-7b09-436f-8cb8-a5799be79542	2026-09-14 12:02	2026-09-14 12:02	2026-09-14 12:02	XRT	XRT261016C00089000	call	89.0000	2026-10-16	0.9400	0.9300	1.0000	85.7300	72944.00	0.00	72944.00	776	5	888	1062	0.836158192090395	0.203328686408539	0.203328686408539	false	false	false	true	false
b1fd2ebb-6d6a-4e2c-8c2d-a6ea8a2fff14	2026-09-14 12:19	2026-09-14 12:19	2026-09-14 12:19	XRT	XRT261016P00096000	put	96.0000	2026-10-16	10.2000	10.0500	11.4000	85.9550	24480.00	3060.00	21420.00	24	10	24	0	0	0.308997590569707	0.308997590569707	true	false	false	true	false
6848c71e-4795-4eaf-870d-bf11bd88e2e3	2026-09-14 13:33	2026-09-14 13:33	2026-09-14 13:33	XRT	XRT261016C00091000	call	91.0000	2026-10-16	0.5800	0.5100	0.6600	85.9150	52200.00	50286.00	1914.00	900	26	1002	131	7.64885496183206	0.209375225424949	0.209375225424949	false	false	false	true	false
76762e78-6cd8-4b0d-90c9-8c1d70c242c1	2026-09-14 13:46	2026-09-14 13:46	2026-09-14 13:46	XRT	XRT261016P00085000	put	85.0000	2026-10-16	1.7900	1.7800	1.7900	85.9405	50478.00	50478.00	0.00	282	7	987	10930	0.0903019213174748	0.234124192261042	0.234124192261042	true	false	false	true	false
e5f35de2-93ae-4e0c-a508-187dea6d9f82	2026-09-15 11:24	2026-09-15 11:24	2026-09-15 11:24	XRT	XRT261016P00080000	put	80.0000	2026-10-16	0.8300	0.8300	0.8400	83.8100	159277.00	0.00	159277.00	1919	21	1954	1816	1.07599118942731	0.24449860067494	0.24449860067494	false	false	false	true	false
7b28cc52-f75d-4a51-a304-cf72e3dfe602	2026-09-15 13:59	2026-09-15 13:59	2026-09-15 13:59	XRT	XRT260918C00084500	call	84.5000	2026-09-18	0.7000	0.4400	2.0500	83.7850	70000.00	62510.00	5110.00	1000	20	1000	0	0	0.330854608989743	0.330854608989743	false	false	false	true	false
5091fdcd-8635-4833-bc7e-664e5cebcd25	2026-09-15 14:30	2026-09-15 14:30	2026-09-15 14:30	XRT	XRT261016P00085000	put	85.0000	2026-10-16	2.8500	2.8400	2.9000	83.7100	11676.00	9120.00	2556.00	41	6	513	11198	0.045811752098589	0.235694418732419	0.236731689336367	true	false	false	true	false
7bbde2b3-d86b-4d4f-92f2-9ca77907be95	2026-09-15 14:38	2026-09-15 14:38	2026-09-15 14:38	XRT	XRT261016P00085000	put	85.0000	2026-10-16	2.8800	2.8800	2.9600	83.6600	12672.00	0.00	7776.00	44	17	1164	11198	0.103947133416682	0.236958887400732	0.236958887400732	true	false	false	true	false
a957889c-8e4a-43ce-bfa8-fcf173d6c1c5	2026-09-15 15:08	2026-09-15 15:07	2026-09-15 15:07	XRT	XRT261016P00085000	put	85.0000	2026-10-16	2.8800	2.8800	2.9500	83.6200	29664.00	0.00	29664.00	103	13	2109	11198	0.188337203071977	0.234630527889609	0.234630527889609	false	false	false	true	false
cf96cd96-968b-4134-bcc7-8d60e5795c4e	2026-09-15 15:08	2026-09-15 15:07	2026-09-15 15:07	XRT	XRT261016P00085000	put	85.0000	2026-10-16	2.8800	2.8800	2.9500	83.6082	23040.00	0.00	23040.00	80	15	2189	11198	0.195481335952849	0.233939948871002	0.233939948871002	false	false	false	true	false
534b5a44-9cd4-4768-948a-07c0d88cca29	2026-09-16 11:07	2026-09-16 11:07	2026-09-16 11:07	XRT	XRT261016P00092000	put	92.0000	2026-10-16	8.3500	8.3500	9.1500	83.8200	28390.00	0.00	28390.00	34	18	34	5	6.8	0.280480336736872	0.280480336736872	true	false	false	true	false
d4e9d285-a8c3-4e27-9799-deed90c0b06d	2026-09-16 12:39	2026-09-16 12:39	2026-09-16 12:39	XRT	XRT261218P00085000	put	85.0000	2026-12-18	4.4500	4.4000	4.4500	83.7100	154860.00	154860.00	0.00	348	24	362	5119	0.0707169369017386	0.25191502148718	0.25191502148718	false	false	false	true	false
f3b69f22-acc1-4b60-9ac1-74229fe2c027	2026-09-16 15:31	2026-09-16 15:31	2026-09-16 15:31	XRT	XRT260918P00085000	put	85.0000	2026-09-18	2.4700	2.3400	2.6000	82.5500	61750.00	12350.00	12350.00	250	6	1502	16622	0.0903621706172542	0.249364556014216	0.249364556014216	false	false	false	true	false
81e82ecc-9e9c-4553-8db2-be16bb08beb7	2026-09-17 10:37	2026-09-17 10:37	2026-09-17 10:37	XRT	XRT261016P00087000	put	87.0000	2026-10-16	4.4500	4.4500	4.6500	83.2100	17355.00	0.00	17355.00	39	9	39	49	0.795918367346939	0.237832894745885	0.237832894745885	false	false	false	true	false
64ffa468-566d-480b-b0f3-488feb3b0481	2026-09-17 10:53	2026-09-17 10:53	2026-09-17 10:53	XRT	XRT261016C00087000	call	87.0000	2026-10-16	0.7700	0.6100	0.7700	83.2600	269500.00	269500.00	0.00	3500	6	3503	1081	3.24051803885291	0.215045055811226	0.215045055811226	false	true	false	true	false
088e65d1-461e-4325-8e86-4d1f4045fa16	2026-09-17 10:53	2026-09-17 10:53	2026-09-17 10:53	XRT	XRT261016C00087000	call	87.0000	2026-10-16	0.7700	0.6100	0.7700	83.2600	269500.00	269500.00	0.00	3500	6	3503	1081	3.24051803885291	0.215045055811226	0.215045055811226	false	true	false	true	false
5f48675a-2f73-450c-878d-4806bdd8f660	2026-09-17 10:58	2026-09-17 10:58	2026-09-17 10:58	XRT	XRT261016C00087000	call	87.0000	2026-10-16	0.6700	0.6100	0.6800	83.1600	30136.00	23771.00	0.00	449	24	4456	1081	4.12210915818686	0.206395606167992	0.205033890262604	false	false	false	true	false
809c5879-bbc0-42d7-ab84-a3320808690a	2026-09-17 10:59	2026-09-17 10:59	2026-09-17 10:59	XRT	XRT261016C00087000	call	87.0000	2026-10-16	0.6800	0.6200	0.6800	83.1750	22447.00	19968.00	0.00	332	26	5243	1081	4.85013876040703	0.2058974658095	0.204537217168685	false	false	false	true	false
c22592b9-bf5d-4b97-be8f-e47f65e341c5	2026-09-17 11:01	2026-09-17 11:01	2026-09-17 11:01	XRT	XRT261016C00087000	call	87.0000	2026-10-16	0.7000	0.6600	0.7000	83.2000	23940.00	23940.00	0.00	342	29	6154	1081	5.69287696577243	0.207768461955707	0.207768461955707	false	false	false	true	false
4a99c3bd-6ce4-4a01-b6ed-8914fd499147	2026-09-17 11:02	2026-09-17 11:02	2026-09-17 11:02	XRT	XRT261016C00087000	call	87.0000	2026-10-16	0.7200	0.6600	0.7200	83.1900	100800.00	100800.00	0.00	1400	43	8984	1081	8.31082331174838	0.210789088081866	0.210789088081866	false	false	false	true	false
d40a5819-3fe4-4235-9ca7-3ddc48ab10e9	2026-09-17 11:16	2026-09-17 11:16	2026-09-17 11:16	XRT	XRT270917P00070000	put	70.0000	2027-09-17	2.7500	2.7500	2.9500	83.2500	12100.00	0.00	10450.00	44	17	84	0	0	0.28698802549809	0.28698802549809	false	false	false	true	false
a1bf795e-a721-4e9e-99de-d73ca0cf4d58	2026-09-17 11:17	2026-09-17 11:16	2026-09-17 11:16	XRT	XRT270917P00070000	put	70.0000	2027-09-17	2.8700	2.8600	2.9500	83.2300	24362.00	0.00	8010.00	85	35	170	0	0	0.292223110711269	0.291775092025424	false	false	false	true	false
55239765-e3ae-41da-b286-8d2e4aea1895	2026-09-17 11:17	2026-09-17 11:16	2026-09-17 11:16	XRT	XRT270917P00070000	put	70.0000	2027-09-17	2.8400	2.3200	2.8700	83.2300	27842.00	285.00	18168.00	98	52	268	0	0	0.291326705014687	0.290428816379033	true	false	false	true	false
4c9c9e1e-9898-4fcd-be31-901dda7cfeca	2026-09-17 11:26	2026-09-17 11:25	2026-09-17 11:25	XRT	XRT261016C00085000	call	85.0000	2026-10-16	1.2500	1.1800	1.2500	83.1300	24875.00	24875.00	0.00	199	18	199	77	2.58441558441558	0.206370609979977	0.206370609979977	false	false	false	true	false
3915098e-f88e-443a-aeff-b4b5b662573c	2026-09-17 11:26	2026-09-17 11:25	2026-09-17 11:25	XRT	XRT261016C00085000	call	85.0000	2026-10-16	1.2500	1.1800	1.2500	83.1300	11625.00	11625.00	0.00	93	9	292	77	3.79220779220779	0.206370609979977	0.206370609979977	false	false	false	true	false
6df30857-2cec-4d56-bc27-ec34a9651654	2026-09-18 12:11	2026-09-18 12:11	2026-09-18 12:11	XRT	XRT260925C00083500	call	83.5000	2026-09-25	0.5000	0.4100	0.5700	82.0000	60000.00	44700.00	15300.00	1200	26	1209	85	14.2235294117647	0.210457182518462	0.210457182518462	false	false	false	true	false
3c16bc71-a86b-4ff0-abdc-911a026a2ac8	2026-09-21 13:29	2026-09-21 13:29	2026-09-21 13:29	XRT	XRT261002P00083500	put	83.5000	2026-10-02	1.5500	1.3700	1.5500	82.9800	10075.00	10075.00	0.00	65	14	65	1	65	0.230751041990368	0.230751041990368	true	false	false	true	false