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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Basic Materials×source = uw_flow_alerts×ticker = RIO×

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

df3b1e21-5a60-43b7-80cb-c65d53380e80	2026-09-22 14:49	2026-09-22 14:49	2026-09-22 14:49	RIO	RIO261016C00100000	call	100.0000	2026-10-16	1.9500	1.8500	1.9500	97.5900	19299.00	19299.00	0.00	99	25	168	3182	0.0527969830295412	0.287298489139113	0.287298489139113	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Basic Materials	122448445512.00	—	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
b4243bf3-c029-4773-8b0b-e7462cbc83b9	2026-09-22 14:49	2026-09-22 14:49	2026-09-22 14:49	RIO	RIO261016C00105000	call	105.0000	2026-10-16	0.7000	0.6000	0.7000	97.5900	11620.00	11620.00	0.00	166	15	309	1462	0.211354309165527	0.291651355145065	0.291651355145065	false	false	false	true
fc26d816-d62c-4cc9-9201-39b8c8f6db07	2026-09-22 13:58	2026-09-22 13:58	2026-09-22 13:58	RIO	RIO261016C00097500	call	97.5000	2026-10-16	3.0000	2.9000	3.0000	97.4350	11700.00	11700.00	0.00	39	11	42	774	0.0542635658914729	0.291774262579803	0.291774262579803	false	false	false	true
d9986ec1-5ab6-42dc-8513-0d6848496156	2026-09-22 11:53	2026-09-22 11:53	2026-09-22 11:53	RIO	RIO270917P00070000	put	70.0000	2027-09-17	2.8000	2.5500	2.8000	96.6300	19040.00	4480.00	0.00	68	24	68	11	6.18181818181818	0.387853648096689	0.387853648096689	false	false	false	true
d10988a5-a861-468e-ba29-0bec92b05c5a	2026-09-21 13:02	2026-09-21 13:02	2026-09-21 13:02	RIO	RIO261016C00100000	call	100.0000	2026-10-16	1.7500	1.7000	1.8500	97.1000	154000.00	2100.00	123200.00	880	6	1684	1657	1.01629450814725	0.279887612528752	0.279887612528752	false	false	false	true
766b3b6a-f6f4-4fcc-a7c4-02b63806570e	2026-09-21 13:02	2026-09-21 13:02	2026-09-21 13:02	RIO	RIO261016C00100000	call	100.0000	2026-10-16	1.8000	1.7000	1.8500	97.1300	111600.00	14400.00	76860.00	620	19	804	1657	0.485214242607121	0.283919224130883	0.283919224130883	false	false	false
8ffb8518-e273-4566-add4-aa4da5524fac	2026-09-21 12:42	2026-09-21 12:42	2026-09-21 12:42	RIO	RIO270115C00110000	call	110.0000	2027-01-15	2.4500	2.3500	2.6500	96.9900	215686.00	490.00	214951.00	880	37	890	984	0.904471544715447	0.28970628365522	0.290381726948482	false	false	false	true
42dd78d5-ceb1-41f9-9a8a-34979212c527	2026-09-21 12:42	2026-09-21 12:42	2026-09-21 12:42	RIO	RIO270115C00120000	call	120.0000	2027-01-15	1.0500	1.0500	1.3000	97.0350	23417.00	0.00	23417.00	223	23	227	1112	0.204136690647482	0.298765516961446	0.298765516961446	false	false	false	true
a19d26a0-331c-4794-ba75-30b5c07b8b92	2026-09-21 12:31	2026-09-21 12:31	2026-09-21 12:31	RIO	RIO261120C00115000	call	115.0000	2026-11-20	0.5600	0.5000	0.6500	97.0000	57027.00	0.00	46302.00	1026	12	1029	0	0	0.301172616050169	0.303992738084938	false	false	false	true
ae500378-9be9-4881-bf1c-6f8a8f890695	2026-09-21 11:05	2026-09-21 11:05	2026-09-21 11:05	RIO	RIO261016C00100000	call	100.0000	2026-10-16	1.7500	1.6500	2.0000	97.0100	17850.00	1750.00	350.00	102	10	145	1657	0.0875075437537719	0.283359918819106	0.283359918819106	false	false	false	true
669e77f6-9ce7-411d-b14f-e6103d263d1f	2026-09-17 10:05	2026-09-17 10:05	2026-09-17 10:05	RIO	RIO261016P00087500	put	87.5000	2026-10-16	0.4500	0.4000	0.7000	98.0000	135000.00	0.00	135000.00	3000	1	3000	1384	2.16763005780347	0.333606318305265	0.333606318305265	false	true	false	true
8942ee61-405d-444d-beea-6d53e3e02607	2026-09-16 11:01	2026-09-16 11:00	2026-09-16 11:00	RIO	RIO270115P00090000	put	90.0000	2027-01-15	3.4000	3.4000	3.6000	97.3900	57460.00	0.00	57460.00	169	19	169	761	0.222076215505913	0.321948490597909	0.321948490597909	false	false	false	true
366d49db-ffff-4524-8690-0aa85cf872dc	2026-09-02 09:42	2026-09-02 09:42	2026-09-02 09:42	RIO	RIO261016C00100000	call	100.0000	2026-10-16	6.4900	6.3000	6.5000	103.1200	64862.00	64862.00	0.00	100	5	100	1337	0.074794315632012	0.317848943591714	0.317848943591714	false	false	false	true
d2fde1dd-1780-4e40-8463-986706206b8e	2026-09-01 15:15	2026-09-01 15:14	2026-09-01 15:14	RIO	RIO261218P00095000	put	95.0000	2026-12-18	3.6000	3.5000	3.7000	102.0650	52200.00	1800.00	22320.00	145	8	149	455	0.327472527472527	0.326698866250586	0.326698866250586	false	false	false	true
3779b7ce-5710-4785-83f3-51d6d1cf56e4	2026-08-28 11:53	2026-08-28 11:53	2026-08-28 11:53	RIO	RIO261016P00100000	put	100.0000	2026-10-16	2.7500	2.7000	2.9000	103.0000	51150.00	275.00	50875.00	186	17	191	474	0.40295358649789	0.309389608497665	0.309389608497665	false	false	false	true
99812381-a359-4d2e-a607-15fe594b5f2c	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	RIO	RIO261218P00100000	put	100.0000	2026-12-18	4.8000	4.8000	5.1000	104.3000	56650.00	0.00	56650.00	118	28	248	375	0.661333333333333	0.319400202349609	0.319400202349609	false	false	false	true
14e66399-6f53-4967-b304-4024d2a5b698	2026-08-26 14:53	2026-08-26 14:52	2026-08-26 14:52	RIO	RIO270917C00105000	call	105.0000	2027-09-17	13.9800	13.4000	14.8000	104.8200	114670.00	0.00	114670.00	82	9	123	0	0	0.277038077126117	0.278249708016016	true	false	false	true
bfa3c6d4-ba7c-483b-ac69-ff35976e10f8	2026-08-24 09:47	2026-08-24 09:46	2026-08-24 09:46	RIO	RIO261218C00110000	call	110.0000	2026-12-18	6.0000	5.6000	6.0000	105.4000	133195.00	133195.00	0.00	222	35	222	668	0.332335329341317	0.312490951284641	0.312490951284641	false	false	false	true
0d34bbcf-36b2-4258-bc8c-49eed5ba517a	2026-08-19 10:40	2026-08-19 10:40	2026-08-19 10:40	RIO	RIO260821C00100000	call	100.0000	2026-08-21	1.6000	1.4500	1.6500	100.7850	77920.00	73600.00	4320.00	487	33	519	2069	0.250845819236346	0.388835661435248	0.388835661435248	false	false	false
3d7211d3-e536-40e1-8f8c-55a4dbe0d26c	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	RIO	RIO260918C00100000	call	100.0000	2026-09-18	3.2000	3.1000	3.2000	99.4900	65600.00	65600.00	0.00	205	29	224	1485	0.150841750841751	0.289707182830773	0.289707182830773	false	false	false	true
15c6d820-790d-4c94-9f41-579c0bb8dce5	2026-08-18 13:09	2026-08-18 13:09	2026-08-18 13:09	RIO	RIO270115C00090000	call	90.0000	2027-01-15	12.7000	12.3000	12.7000	97.0600	66040.00	66040.00	0.00	52	11	64	1073	0.059645852749301	0.325656930439894	0.325656930439894	false	false	false	true
f8e8e539-0437-4b80-beee-1051598ec66c	2026-08-17 12:34	2026-08-17 12:34	2026-08-17 12:34	RIO	RIO270115C00087500	call	87.5000	2027-01-15	14.3000	13.9000	14.4000	96.7550	62919.00	40039.00	21450.00	44	12	44	202	0.217821782178218	0.334983722007337	0.334983722007337	false	false	false	true