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:alert_rule = RepeatedHits×ticker = RJF×

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

1bc3c89c-582c-40e2-9aeb-bd226dc79c7e	2026-09-22 10:56	2026-09-22 10:56	2026-09-22 10:56	RJF	RJF261016P00155000	put	155.0000	2026-10-16	3.6000	3.6000	3.9000	156.7250	101520.00	0.00	101520.00	282	8	282	6	47	0.288044308747854	0.288044308747854	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	30660533116.00	2026-10-28	postmarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
4d5b576d-7b9b-4bd1-b50b-8d25c24d4ad0	2026-09-11 11:52	2026-09-11 11:52	2026-09-11 11:52	RJF	RJF261120P00180000	put	180.0000	2026-11-20	10.5000	10.5000	11.8000	173.0500	24150.00	0.00	24150.00	23	6	44	144	0.305555555555556	0.240371298178552	0.240371298178552	false	false	false	true
89879035-01da-4262-9871-a0414b06fcb3	2026-09-11 11:47	2026-09-11 11:47	2026-09-11 11:47	RJF	RJF261120P00185000	put	185.0000	2026-11-20	14.7100	14.7000	15.0000	172.6700	51470.00	0.00	51470.00	35	6	159	367	0.433242506811989	0.260448683118941	0.260448683118941	false	false	false	true
f4721afe-5f8e-4e72-b09c-fc1577a2f527	2026-09-11 11:45	2026-09-11 11:45	2026-09-11 11:45	RJF	RJF261120P00185000	put	185.0000	2026-11-20	14.5400	14.5000	15.0000	172.6700	36355.00	4455.00	31900.00	25	5	54	367	0.147138964577657	0.252976386694045	0.266012674743272	false	false	false	true
82805a8a-dd4f-4ef7-8ca1-a92b5f4a6833	2026-09-10 11:50	2026-09-10 11:50	2026-09-10 11:50	RJF	RJF261120P00185000	put	185.0000	2026-11-20	13.4000	13.2000	13.4000	175.2300	28140.00	28140.00	0.00	21	5	83	158	0.525316455696203	0.272143914977855	0.272143914977855	false	false	false	true
d88117c6-6767-488f-ab1c-9f1172dafb13	2026-09-10 11:50	2026-09-10 11:50	2026-09-10 11:50	RJF	RJF261120P00185000	put	185.0000	2026-11-20	13.4000	13.2000	13.4000	175.2300	28140.00	28140.00	0.00	21	5	62	158	0.392405063291139	0.272143914977855	0.272143914977855	false	false	false	true
85d7b2fe-0456-4f7d-acea-6213f459e0f6	2026-09-09 14:30	2026-09-09 14:30	2026-09-09 14:30	RJF	RJF261120P00190000	put	190.0000	2026-11-20	16.7000	16.4000	16.8500	175.2800	61790.00	30060.00	0.00	37	5	168	478	0.351464435146443	0.26335047238009	0.26335047238009	false	false	false	true
4b86a037-18f8-43b1-b0cb-c93d27c3f683	2026-09-03 09:47	2026-09-03 09:46	2026-09-03 09:46	RJF	RJF261120P00190000	put	190.0000	2026-11-20	13.8000	13.4000	13.8000	180.1600	56580.00	56580.00	0.00	41	6	271	37	7.32432432432432	0.265575472884446	0.265575472884446	false	false	false	true
bb4a2ff6-7615-4544-ae13-4bb9003fd8b9	2026-09-01 13:19	2026-09-01 13:19	2026-09-01 13:19	RJF	RJF261120P00180000	put	180.0000	2026-11-20	11.1000	11.1000	12.1000	172.4000	45512.00	0.00	45512.00	41	15	742	230	3.22608695652174	0.234857742358065	0.234857742358065	false	false	false	true
f00dfc77-f031-474d-879a-5eb114ee369c	2026-09-01 13:19	2026-09-01 13:19	2026-09-01 13:19	RJF	RJF261120P00180000	put	180.0000	2026-11-20	11.0300	11.0000	12.1000	172.4000	44120.00	0.00	30800.00	40	10	701	230	3.04782608695652	0.231643653591507	0.231643653591507	false	false	false	true
82d89a5a-77e4-4789-9431-6f09c56a7d81	2026-09-01 13:18	2026-09-01 13:17	2026-09-01 13:17	RJF	RJF261120P00180000	put	180.0000	2026-11-20	9.7000	9.7000	12.2000	172.4450	23280.00	0.00	23280.00	24	6	603	230	2.62173913043478	0.190307020336078	0.190307020336078	false	false	false	true
dc993b8d-7349-40dc-bc63-8e6780857d24	2026-09-01 09:33	2026-09-01 09:33	2026-09-01 09:33	RJF	RJF261120P00190000	put	190.0000	2026-11-20	14.6000	14.6000	17.5000	176.6400	86140.00	0.00	86140.00	59	10	59	59	1	0.213524618487084	0.213524618487084	false	false	false	true
93c7e0bc-1372-4b32-8d17-d5e6d593ecbd	2026-09-01 09:32	2026-09-01 09:32	2026-09-01 09:32	RJF	RJF261120P00180000	put	180.0000	2026-11-20	8.7000	8.7000	10.6000	175.5801	45240.00	0.00	45240.00	52	11	97	230	0.421739130434783	0.216835083751774	0.216835083751774	false	false	false	true
a1929fbc-8b6f-4c7f-aa98-287435632271	2026-08-27 10:03	2026-08-27 10:03	2026-08-27 10:03	RJF	RJF270219C00175000	call	175.0000	2027-02-19	13.6000	13.6000	15.1000	176.5300	13600.00	0.00	13600.00	10	5	10	11	0.909090909090909	0.228734549833362	0.228734549833362	false	false	false	true
b49526d5-9738-483d-aa9d-fd4f13c1e8e7	2026-08-26 10:02	2026-08-26 10:02	2026-08-26 10:02	RJF	RJF261016C00170000	call	170.0000	2026-10-16	8.0000	6.7000	8.4000	173.4200	96810.00	79200.00	17610.00	121	9	122	2	61	0.222030748328278	0.22249610192605	false	false	false	true
17288387-2a64-4da7-a7ff-9d541e38fb87	2026-08-26 09:34	2026-08-26 09:34	2026-08-26 09:34	RJF	RJF261120P00180000	put	180.0000	2026-11-20	11.1000	11.1000	12.9000	171.5300	59942.00	0.00	59942.00	54	6	396	429	0.923076923076923	0.211652017173614	0.211652017173614	false	false	false	true
cd8a658a-fb07-447c-9bab-1d915c4684c9	2026-08-25 09:46	2026-08-25 09:46	2026-08-25 09:46	RJF	RJF261120P00180000	put	180.0000	2026-11-20	8.4000	8.4000	11.0000	174.8100	10080.00	0.00	10080.00	12	5	12	456	0.0263157894736842	0.1884371158191	0.1884371158191	false	false	false	true
82813be9-f06e-40e0-b88a-597c7913db56	2026-08-24 15:22	2026-08-24 15:22	2026-08-24 15:22	RJF	RJF261120P00185000	put	185.0000	2026-11-20	12.6000	11.6000	12.6000	176.3600	23940.00	23940.00	0.00	19	7	63	0	0	0.247387463950013	0.247387463950013	false	false	false	true
38b09808-0198-4e86-a2d4-667a6afc2801	2026-08-24 15:11	2026-08-24 15:11	2026-08-24 15:11	RJF	RJF261120P00180000	put	180.0000	2026-11-20	9.5000	9.2000	9.5000	176.6800	42750.00	42750.00	0.00	45	5	193	35	5.51428571428571	0.249022666940924	0.249022666940924	false	false	false	true
be8396da-4bc7-403f-a2aa-56076d13b2eb	2026-08-24 15:09	2026-08-24 15:09	2026-08-24 15:09	RJF	RJF261120P00180000	put	180.0000	2026-11-20	9.3700	9.0000	9.5000	176.7200	42150.00	19950.00	0.00	45	7	148	35	4.22857142857143	0.249606771443222	0.242384151436724	false	false	false	true
eca27eeb-edb9-40fe-ba3d-621b9cbf853c	2026-08-14 15:54	2026-08-14 15:53	2026-08-14 15:53	RJF	RJF261120C00180000	call	180.0000	2026-11-20	9.3000	8.8000	9.3000	180.6400	25110.00	25110.00	0.00	27	8	27	335	0.0805970149253731	0.215441246765014	0.215441246765014	false	false	false	true