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 = Financial Services×source = uw_flow_alerts×ticker = RY×

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

973e461b-7f27-46dc-b75f-f17918d140d5	2026-09-22 11:14	2026-09-22 11:14	2026-09-22 11:14	RY	RY270115P00210000	put	210.0000	2027-01-15	12.5000	10.8000	12.5000	203.4700	15000.00	15000.00	0.00	12	8	12	189	0.0634920634920635	0.229171137322628	0.229171137322628	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	285491500945.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T15:15:45.651673Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
56072e43-d54d-4afc-bbf4-79935198470c	2026-09-21 13:21	2026-09-21 13:21	2026-09-21 13:21	RY	RY270115C00180000	call	180.0000	2027-01-15	28.7000	28.7000	29.5000	205.0000	37310.00	0.00	37310.00	13	5	49	154	0.318181818181818	0.186710592481884	0.186710592481884	false	false	false	true
ab4a0ab1-4cae-4f57-b698-8fea8c6e0016	2026-09-21 12:53	2026-09-21 12:53	2026-09-21 12:53	RY	RY261120P00200000	put	200.0000	2026-11-20	4.2000	4.2000	4.5000	205.0000	62580.00	0.00	62580.00	149	19	153	26	5.88461538461539	0.215758809912655	0.215758809912655	false	false	false	true
d81d79d0-c6f9-4439-aea9-bed832aa6435	2026-09-21 11:41	2026-09-21 11:41	2026-09-21 11:41	RY	RY261120C00210000	call	210.0000	2026-11-20	4.3000	3.9000	4.3000	205.1150	138883.00	138883.00	0.00	323	32	323	23	14.0434782608696	0.175617878334839	0.175617878334839	false	false	false	true
dfd56671-de25-4136-a46d-5aed5746a369	2026-09-21 10:09	2026-09-21 10:09	2026-09-21 10:09	RY	RY261120C00230000	call	230.0000	2026-11-20	0.6200	0.4500	0.7500	205.2500	10080.00	3900.00	6180.00	163	26	163	3	54.3333333333333	0.191909243470667	0.188154348186911	false	false	false	true
1316554f-b831-4379-8b2d-728015b28a59	2026-09-21 10:07	2026-09-21 10:07	2026-09-21 10:07	RY	RY270115P00210000	put	210.0000	2027-01-15	11.5000	11.4000	11.9000	205.2850	21850.00	0.00	21850.00	19	6	19	186	0.102150537634409	0.226973546430643	0.226973546430643	true	false	false	true
66ddd2a4-ec09-41cd-a75f-a84522e6ac5d	2026-09-11 12:38	2026-09-11 12:38	2026-09-11 12:38	RY	RY270115C00200000	call	200.0000	2027-01-15	15.0000	13.5000	15.2000	206.1800	60000.00	60000.00	0.00	40	6	40	1770	0.0225988700564972	0.209007948975075	0.209007948975075	false	false	false	true
d78198fb-5448-423c-a5f5-c24732927c76	2026-09-03 14:16	2026-09-03 14:15	2026-09-03 14:15	RY	RY270115C00200000	call	200.0000	2027-01-15	19.0100	19.0000	19.2000	211.7500	95026.00	3826.00	91200.00	50	13	72	1853	0.0388559093362115	0.202663357777898	0.205784270246053	false	false	false
9e100b12-d86d-4c67-800e-f3d8d707e1dc	2026-09-02 09:59	2026-09-02 09:59	2026-09-02 09:59	RY	RY270115C00220000	call	220.0000	2027-01-15	5.8000	4.2000	6.2000	205.3000	71361.00	58000.00	13361.00	123	6	123	1874	0.0656350053361793	0.206398117028425	0.206613105985984	false	false	false
cae230f3-be75-4d15-a5a0-91ec77158310	2026-08-27 10:22	2026-08-27 10:21	2026-08-27 10:21	RY	RY270115P00195000	put	195.0000	2027-01-15	7.2000	5.7000	8.5000	202.6500	180740.00	36730.00	90010.00	251	14	251	312	0.80448717948718	0.239554842845379	0.242485638842413	false	false	false	true
c20af7cd-bb5b-43ff-888d-801b3212c8d7	2026-08-25 13:22	2026-08-25 13:21	2026-08-25 13:21	RY	RY261016C00210000	call	210.0000	2026-10-16	5.6000	5.1000	6.0000	206.7200	131040.00	131040.00	0.00	234	27	236	138	1.71014492753623	0.211560982680166	0.211560982680166	false	false	false	true
36d40e39-6459-4992-b348-efc5148113f1	2026-08-25 11:23	2026-08-25 11:23	2026-08-25 11:23	RY	RY261016C00200000	call	200.0000	2026-10-16	11.2000	10.4000	11.7000	206.3400	92960.00	90720.00	2240.00	83	28	83	295	0.28135593220339	0.224965685204646	0.224965685204646	false	false	false
203cef92-234f-48d2-89d5-13a5bcf267f0	2026-08-21 13:12	2026-08-21 13:12	2026-08-21 13:12	RY	RY261016P00210000	put	210.0000	2026-10-16	8.7000	8.4000	8.8000	204.9600	199290.00	33120.00	166170.00	229	20	434	694	0.62536023054755	0.204653418878296	0.204653418878296	false	false	false	true
29bee966-a5d1-4d2d-88ae-d763085b84e9	2026-08-21 09:56	2026-08-21 09:56	2026-08-21 09:56	RY	RY261016P00210000	put	210.0000	2026-10-16	7.5000	7.0000	7.6000	207.5000	149250.00	1500.00	147750.00	199	13	200	694	0.288184438040346	0.208442175900181	0.210350091139524	true	false	false	true
fcdbd316-066b-4525-835d-5f590e8d61b5	2026-08-18 11:29	2026-08-18 11:29	2026-08-18 11:29	RY	RY261016C00220000	call	220.0000	2026-10-16	4.2000	4.0000	4.7000	212.9150	85320.00	5890.00	79430.00	203	23	261	439	0.594533029612756	0.192127164366458	0.193003496690791	false	false	false
48945e2f-3841-42cf-aa3c-b5f0df617fe8	2026-08-18 11:25	2026-08-18 11:25	2026-08-18 11:25	RY	RY260918C00210000	call	210.0000	2026-09-18	7.2000	6.8000	7.6000	212.9400	97200.00	96480.00	0.00	135	31	142	307	0.462540716612378	0.211481435318428	0.211481435318428	false	false	false	true
7a7af1ab-154f-43bb-86de-2e95e3b5b07d	2026-08-17 11:10	2026-08-17 11:10	2026-08-17 11:10	RY	RY270115C00220000	call	220.0000	2027-01-15	12.0800	11.6000	12.1000	217.1408	120750.00	120750.00	0.00	100	9	275	1408	0.1953125	0.211270265161603	0.210369092718173	false	false	false	true