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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = RGLD×

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

61c24b1a-0152-48b6-931d-463f60b9341a	2026-09-23 12:40	2026-09-23 12:40	2026-09-23 12:40	RGLD	RGLD261016C00250000	call	250.0000	2026-10-16	11.8000	11.3000	12.1000	254.0000	14160.00	5900.00	8260.00	12	7	16	333	0.048048048048048	0.359576259373251	0.359576259373251	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	21417507692.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T16:43:49.845741Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
10e3c457-cac9-4a10-8bc7-b1be5900c954	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	RGLD	RGLD280121C00250000	call	250.0000	2028-01-21	58.5000	56.5000	59.5000	258.0000	117000.00	17550.00	99450.00	20	5	20	359	0.0557103064066852	0.404641449136423	0.404641449136423	false	false	false
883d053d-4c75-4cb2-a58b-f1da94fa9666	2026-09-21 11:24	2026-09-21 11:24	2026-09-21 11:24	RGLD	RGLD261016C00260000	call	260.0000	2026-10-16	5.2000	4.8000	5.5000	247.5200	27040.00	26520.00	0.00	52	5	64	115	0.556521739130435	0.378339374590041	0.378339374590041	false	false	false	true
1c88574d-b23d-4847-9bd3-3ed8663bbe69	2026-09-17 13:50	2026-09-17 13:49	2026-09-17 13:49	RGLD	RGLD261016C00250000	call	250.0000	2026-10-16	11.9900	11.8000	12.0000	251.9700	20390.00	10800.00	1190.00	17	5	52	135	0.385185185185185	0.37510592738708	0.371532802267039	false	false	false
5cf7e798-fce3-4900-90f4-d1043d08e8ad	2026-09-17 13:46	2026-09-17 13:46	2026-09-17 13:46	RGLD	RGLD261016C00250000	call	250.0000	2026-10-16	12.2000	11.3000	13.1000	252.4000	24400.00	6100.00	4880.00	20	5	35	135	0.259259259259259	0.373562172511079	0.373562172511079	false	false	false
c71de831-b70f-42c1-9f61-6e3ff49652ad	2026-09-16 14:33	2026-09-16 14:33	2026-09-16 14:33	RGLD	RGLD261016C00280000	call	280.0000	2026-10-16	1.9500	1.9500	2.5000	244.9800	12895.00	0.00	11895.00	66	21	67	158	0.424050632911392	0.402573605496133	0.402573605496133	false	false	false	true
165b694a-f5a5-4bd1-a1be-4c95d7d7d3d9	2026-09-16 11:49	2026-09-16 11:49	2026-09-16 11:49	RGLD	RGLD260918P00250000	put	250.0000	2026-09-18	3.5000	2.8000	3.5000	251.1600	39550.00	39550.00	0.00	113	32	113	206	0.548543689320388	0.551214925189422	0.551214925189422	false	false	false	true
7dd29222-3c05-43b5-ae43-33e0454bc48b	2026-09-14 14:50	2026-09-14 14:50	2026-09-14 14:50	RGLD	RGLD280121C00440000	call	440.0000	2028-01-21	12.2000	10.6000	13.2000	248.7700	24400.00	7320.00	17080.00	20	5	20	8	2.5	0.423708344170932	0.423708344170932	false	false	false	true
658afa2e-4141-4376-b182-6d06ca58a0da	2026-09-14 14:40	2026-09-14 14:40	2026-09-14 14:40	RGLD	RGLD270115P00190000	put	190.0000	2027-01-15	2.9000	2.9000	3.2000	248.8800	13051.00	0.00	13051.00	45	19	58	70	0.828571428571429	0.409420687264662	0.409420687264662	false	false	false	true
417d07ee-1b45-4439-8086-77d15b0a80b0	2026-09-11 11:55	2026-09-11 11:55	2026-09-11 11:55	RGLD	RGLD261218C00300000	call	300.0000	2026-12-18	7.7000	7.7000	8.1000	253.8200	81620.00	0.00	81620.00	106	29	109	225	0.484444444444444	0.407122563379138	0.407122563379138	false	false	false
dd1f3a54-6373-4a42-8663-6f4700c625b0	2026-09-10 12:03	2026-09-10 12:03	2026-09-10 12:03	RGLD	RGLD261218C00260000	call	260.0000	2026-12-18	21.6000	21.6000	22.6000	257.1900	90720.00	0.00	90720.00	42	16	43	85	0.505882352941176	0.404647230931094	0.404647230931094	false	false	false
43dea637-e27d-4ff1-b8d7-d0b9b81bf097	2026-09-04 15:31	2026-09-04 15:31	2026-09-04 15:31	RGLD	RGLD270115P00260000	put	260.0000	2027-01-15	22.5100	22.0000	22.5000	262.8000	22510.00	22510.00	0.00	10	5	10	52	0.192307692307692	0.411883462214329	0.411073109385476	true	false	false	true
fb946681-2da8-4bfc-a30e-04bdc3166227	2026-09-03 10:30	2026-09-03 10:30	2026-09-03 10:30	RGLD	RGLD261016P00270000	put	270.0000	2026-10-16	17.1000	17.1000	17.7000	263.4250	13680.00	0.00	13680.00	8	5	8	157	0.0509554140127389	0.391100552229919	0.391100552229919	true	false	false	true
c38d3116-5096-4b29-bbf9-e1aef12d1784	2026-09-01 12:25	2026-09-01 12:25	2026-09-01 12:25	RGLD	RGLD260918P00240000	put	240.0000	2026-09-18	2.4500	2.2000	2.7500	257.6900	12985.00	12740.00	245.00	53	20	54	233	0.231759656652361	0.404636595681584	0.404636595681584	false	false	false	true
4c256c04-461e-4b98-ae07-94c209f68973	2026-08-31 11:00	2026-08-31 11:00	2026-08-31 11:00	RGLD	RGLD270416C00280000	call	280.0000	2027-04-16	27.8000	27.3000	27.8000	259.0500	55600.00	55600.00	0.00	20	6	100	126	0.793650793650794	0.410357866351958	0.410357866351958	false	false	false
249812af-88ad-4961-b630-6259812751e7	2026-08-31 10:58	2026-08-31 10:57	2026-08-31 10:57	RGLD	RGLD270416C00280000	call	280.0000	2027-04-16	27.7000	27.0000	28.3000	259.2000	52630.00	5540.00	38780.00	19	8	75	126	0.595238095238095	0.408214237653795	0.408214237653795	false	false	false
ae402d20-fc49-4ae4-a76c-25ed30ffff87	2026-08-31 10:57	2026-08-31 10:57	2026-08-31 10:57	RGLD	RGLD270416C00280000	call	280.0000	2027-04-16	28.0000	27.0000	28.6000	259.4150	58800.00	5600.00	42000.00	21	9	49	126	0.388888888888889	0.410563844781863	0.410563844781863	false	false	false
d55d78a9-594d-4292-826d-3e04ceaf2ef4	2026-08-31 10:57	2026-08-31 10:57	2026-08-31 10:57	RGLD	RGLD270416C00280000	call	280.0000	2027-04-16	28.0300	26.6000	28.1000	259.3100	75670.00	19670.00	0.00	27	7	27	126	0.214285714285714	0.412432225917449	0.411209134346231	false	false	false
f8014021-d6c3-4e95-8372-85844d64ae49	2026-08-28 12:12	2026-08-28 12:12	2026-08-28 12:12	RGLD	RGLD270416C00280000	call	280.0000	2027-04-16	30.2000	29.9000	30.2000	263.8100	60400.00	57380.00	0.00	20	5	124	4	31	0.407689676820437	0.407689676820437	false	false	false	true
d4561edc-3566-4887-9112-0903015dafd8	2026-08-28 12:12	2026-08-28 12:12	2026-08-28 12:12	RGLD	RGLD270416C00280000	call	280.0000	2027-04-16	30.2000	29.9000	31.9000	263.8100	154020.00	6040.00	144960.00	51	9	103	4	25.75	0.407689676820437	0.407689676820437	false	false	false	true
e732e0d0-9266-4b8a-acf0-78da28a230c2	2026-08-28 12:12	2026-08-28 12:12	2026-08-28 12:12	RGLD	RGLD270416C00280000	call	280.0000	2027-04-16	30.4000	29.9000	31.0000	263.7850	133760.00	6080.00	127680.00	44	6	48	4	12	0.410239037250262	0.410239037250262	false	false	false	true
c05a70da-9be0-47c3-9a4d-2cd4e07a0d8a	2026-08-27 15:17	2026-08-27 15:17	2026-08-27 15:17	RGLD	RGLD260918C00300000	call	300.0000	2026-09-18	2.0500	2.0500	2.3000	268.0000	27265.00	0.00	27265.00	133	33	150	507	0.29585798816568	0.413657554535845	0.413657554535845	false	false	false
8e6a8c4b-64a8-45b9-9e40-c03195f4dbfb	2026-08-27 09:57	2026-08-27 09:57	2026-08-27 09:57	RGLD	RGLD261218C00300000	call	300.0000	2026-12-18	14.6000	12.9000	14.6000	268.4900	29200.00	29200.00	0.00	20	11	20	188	0.106382978723404	0.420693674467699	0.420693674467699	false	false	false
3890aec9-e603-42b6-b205-e04a147d004b	2026-08-26 10:48	2026-08-26 10:48	2026-08-26 10:48	RGLD	RGLD270115P00240000	put	240.0000	2027-01-15	14.0000	13.4000	14.0000	266.3425	11200.00	11200.00	0.00	8	8	8	109	0.073394495412844	0.42265819414103	0.42265819414103	false	false	false	true
a54f778c-c4c6-4550-befe-92f7e0b4fdda	2026-08-25 12:03	2026-08-25 12:03	2026-08-25 12:03	RGLD	RGLD261016P00270000	put	270.0000	2026-10-16	18.3000	17.7000	18.3000	265.7100	40259.00	40259.00	0.00	22	22	30	109	0.275229357798165	0.419249000686265	0.419249000686265	false	false	false	true
40597b78-4465-42d9-8f20-eaf3ddb2d60f	2026-08-24 12:26	2026-08-24 12:26	2026-08-24 12:26	RGLD	RGLD261218C00300000	call	300.0000	2026-12-18	12.8000	11.9000	12.8000	261.1300	35840.00	35840.00	0.00	28	11	32	165	0.193939393939394	0.429065925529551	0.429065925529551	false	false	false
e60962da-dc52-4596-9c46-74cd42c6a084	2026-08-24 11:30	2026-08-24 11:30	2026-08-24 11:30	RGLD	RGLD261218P00280000	put	280.0000	2026-12-18	34.6000	33.2000	34.6000	260.8700	287180.00	287180.00	0.00	83	23	83	20	4.15	0.431589327483704	0.431589327483704	false	false	false	true
0c80a95c-73b9-49f5-ad89-115d6cda170a	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	RGLD	RGLD270115C00300000	call	300.0000	2027-01-15	15.3000	14.0000	15.3000	262.4000	107095.00	107095.00	0.00	70	25	70	268	0.261194029850746	0.416633928117631	0.41424405707066	false	false	false
50587167-e489-43b1-96a4-a8ae3111e804	2026-08-21 10:08	2026-08-21 10:08	2026-08-21 10:08	RGLD	RGLD261218C00260000	call	260.0000	2026-12-18	23.2000	22.9000	23.2000	256.3650	11600.00	6960.00	0.00	5	5	12	67	0.17910447761194	0.400996160774406	0.400996160774406	false	false	false	true
7bdb1a31-5428-4b35-b6fa-b8ccc9025fe9	2026-08-21 10:07	2026-08-21 10:07	2026-08-21 10:07	RGLD	RGLD261218C00260000	call	260.0000	2026-12-18	23.6000	22.6000	23.6000	256.5400	16520.00	7080.00	0.00	7	7	7	67	0.104477611940299	0.406245734383086	0.406245734383086	false	false	false	true
2d23cb0f-bc66-497e-ac30-b5dac10158f5	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	RGLD	RGLD260821C00250000	call	250.0000	2026-08-21	9.7000	7.1000	9.7000	258.5560	106691.00	106691.00	0.00	110	26	110	615	0.178861788617886	1.47300183293539	1.47300183293539	false	false	false
3fdc9934-4fb6-4117-83db-cf6c38b66544	2026-08-20 15:21	2026-08-20 15:21	2026-08-20 15:21	RGLD	RGLD280121C00250000	call	250.0000	2028-01-21	55.8000	55.8000	58.8000	252.2250	362703.00	0.00	362703.00	65	10	104	280	0.371428571428571	0.409265531481679	0.409175804326627	false	false	false
d7be3d26-6ded-4920-a608-4371a38313d9	2026-08-20 14:55	2026-08-20 14:55	2026-08-20 14:55	RGLD	RGLD260918C00250000	call	250.0000	2026-09-18	12.4000	11.9000	12.4000	252.4700	24800.00	6200.00	0.00	20	5	185	274	0.675182481751825	0.379999240960843	0.379999240960843	false	false	false
20178379-1248-46a5-ae00-55cfe84340f6	2026-08-20 14:55	2026-08-20 14:54	2026-08-20 14:54	RGLD	RGLD260821C00220000	call	220.0000	2026-08-21	32.7000	32.7000	32.8000	252.3000	29430.00	0.00	19620.00	9	5	30	452	0.0663716814159292	1.5660301688502	1.5660301688502	false	false	false	true
733a30a2-d462-4fd7-9c9f-624176f03df5	2026-08-20 14:54	2026-08-20 14:54	2026-08-20 14:54	RGLD	RGLD260821C00220000	call	220.0000	2026-08-21	32.5000	32.5000	33.5000	252.2700	48750.00	0.00	13000.00	15	5	15	452	0.0331858407079646	1.40088286974993	1.40088286974993	false	false	false
686c2a80-8e9e-4875-aeea-a00170790c0a	2026-08-17 15:59	2026-08-17 15:59	2026-08-17 15:59	RGLD	RGLD260918C00250000	call	250.0000	2026-09-18	6.0000	5.9000	6.1000	236.5700	13805.00	0.00	8400.00	23	15	259	245	1.05714285714286	0.390292974435438	0.390292974435438	false	false	false	true
cbed3068-f355-40c7-a2a1-2e9a145eb16b	2026-08-17 15:14	2026-08-17 15:14	2026-08-17 15:14	RGLD	RGLD260918P00230000	put	230.0000	2026-09-18	7.5000	7.4000	8.0000	235.2800	75000.00	0.00	48000.00	100	25	130	119	1.09243697478992	0.373479608901985	0.373479608901985	false	false	false	true
b0115245-44e6-4d17-9dff-661c91d1cef3	2026-08-17 14:50	2026-08-17 14:50	2026-08-17 14:50	RGLD	RGLD260918P00230000	put	230.0000	2026-09-18	7.7000	7.7000	7.8000	234.8878	14630.00	0.00	14630.00	19	9	24	119	0.201680672268908	0.375262374898096	0.375262374898096	false	false	false	true