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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 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 = JEF×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	expiry

f53d9b0d-608c-43db-b1cc-8218515db09f	2026-08-19 14:55	2026-08-19 14:55	2026-08-19 14:55	JEF	JEF270115P00045000	put	45.0000	2027-01-15	1.8500	1.6000	1.8500	53.6650	14615.00	14615.00	0.00	79	9	184	99	1.85858585858586	0.42427951524242	0.42427951524242	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	9706508769.00	2026-10-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d025f745-fe9f-4390-84ed-0652bdb35129	2026-08-20 15:18	2026-08-20 15:18	2026-08-20 15:18	JEF	JEF260918P00052500	put	52.5000	2026-09-18	2.2000	1.9000	2.2500	52.0200	19780.00	19780.00	0.00	90	9	216	439	0.492027334851936	0.343427840389252	0.343427840389252	false	false	false
edfab7fa-5e80-4a35-a4df-705c1279f903	2026-08-20 15:56	2026-08-20 15:55	2026-08-20 15:55	JEF	JEF270115P00045000	put	45.0000	2027-01-15	2.3000	2.1250	2.3000	51.9800	11500.00	11500.00	0.00	50	13	122	366	0.333333333333333	0.434001405037902	0.434001405037902	false	false	false
f9464303-485f-48d5-bad2-5e6f96b703a4	2026-08-20 15:56	2026-08-20 15:56	2026-08-20 15:56	JEF	JEF270115P00045000	put	45.0000	2027-01-15	2.3000	2.0000	2.3000	51.9600	37950.00	37950.00	0.00	165	20	287	366	0.784153005464481	0.433537835937741	0.433537835937741	false	false	false
7705e9fb-eb17-43d9-8269-0f7b73838b2c	2026-08-24 15:58	2026-08-24 15:58	2026-08-24 15:58	JEF	JEF260918P00052500	put	52.5000	2026-09-18	2.1500	1.7000	2.2000	51.9700	15480.00	13760.00	0.00	72	12	325	725	0.448275862068966	0.359473702131761	0.357583966071103	false	false	false
a87c6aac-de85-4afa-abad-4ce95b0b309b	2026-09-01 12:42	2026-09-01 12:41	2026-09-01 12:41	JEF	JEF260918P00050000	put	50.0000	2026-09-18	0.6500	0.6000	0.7000	52.3650	10465.00	6175.00	0.00	161	14	298	10601	0.0281105556079615	0.359899725528171	0.359899725528171	false	false	false
27bceede-caba-411a-879c-38044fdabf18	2026-09-01 12:54	2026-09-01 12:54	2026-09-01 12:54	JEF	JEF260918P00050000	put	50.0000	2026-09-18	0.7500	0.7000	0.9500	52.2300	56768.00	56693.00	75.00	757	43	1063	10601	0.100273559098198	0.377257999326477	0.377257999326477	false	false	false
d9533053-00ee-4895-ae29-850ea691c9f0	2026-09-01 12:55	2026-09-01 12:55	2026-09-01 12:55	JEF	JEF260918P00050000	put	50.0000	2026-09-18	0.7500	0.7000	0.8000	52.1750	13275.00	0.00	7425.00	177	13	1306	10601	0.123195924912744	0.373227449269093	0.373227449269093	false	false	false
3d937386-9691-4ce6-876c-140a0e933686	2026-09-01 13:32	2026-09-01 13:32	2026-09-01 13:32	JEF	JEF260918P00050000	put	50.0000	2026-09-18	0.7500	0.5500	0.8000	52.1600	13800.00	12225.00	1425.00	184	10	3223	10601	0.304027921894161	0.372124218740998	0.372124218740998	false	false	false
a0360068-4134-4563-b858-bd53497e6b57	2026-09-03 12:20	2026-09-03 12:20	2026-09-03 12:20	JEF	JEF261016C00055000	call	55.0000	2026-10-16	2.4000	2.2000	2.4000	53.5700	64800.00	64800.00	0.00	270	24	330	61	5.40983606557377	0.398369675311069	0.398369675311069	false	false	false
048ebf47-d726-4816-a9cf-9f70a5fc9201	2026-09-04 11:40	2026-09-04 11:40	2026-09-04 11:40	JEF	JEF270115P00045000	put	45.0000	2027-01-15	1.2000	1.2000	1.5500	55.7600	47052.00	0.00	47052.00	392	32	675	713	0.946704067321178	0.413057457544024	0.413057457544024	false	false	false
6878ed3b-a729-43a9-a4fe-dd30a2a861b4	2026-09-14 15:42	2026-09-14 15:42	2026-09-14 15:42	JEF	JEF260918P00050000	put	50.0000	2026-09-18	1.1500	0.9000	1.2500	49.7250	10120.00	3450.00	6670.00	88	11	570	8641	0.0659645874320102	0.489134167916649	0.489134167916649	true	false	false
58268c7d-8837-40bb-8059-9c9bfbede53f	2026-09-14 15:42	2026-09-14 15:42	2026-09-14 15:42	JEF	JEF260918P00050000	put	50.0000	2026-09-18	1.1500	0.9000	1.2000	49.8000	40710.00	29440.00	7245.00	354	27	985	8641	0.113991436176368	0.51297993070008	0.508029610829064	false	false	false
1df2fb98-b2ae-4e84-a694-06a0beef3e93	2026-09-14 15:42	2026-09-14 15:42	2026-09-14 15:42	JEF	JEF260918P00050000	put	50.0000	2026-09-18	1.1500	0.9500	1.2000	49.8000	42205.00	32200.00	3335.00	367	23	1353	8641	0.156579099641245	0.508029610829064	0.508029610829064	true	false	false
64a87f75-d4c0-4328-8f72-9137a6b912ed	2026-09-14 15:42	2026-09-14 15:42	2026-09-14 15:42	JEF	JEF260918P00050000	put	50.0000	2026-09-18	1.1500	0.9500	1.2000	49.8150	42435.00	39905.00	2530.00	369	8	1851	8641	0.214211318134475	0.511745685938146	0.511745685938146	false	false	false
0db3584a-c62d-4d50-8743-f87e96f7859a	2026-09-14 15:42	2026-09-14 15:42	2026-09-14 15:42	JEF	JEF260918P00050000	put	50.0000	2026-09-18	1.1500	1.0000	1.2000	49.8150	23000.00	6785.00	16215.00	200	14	2051	8641	0.237356787408865	0.511745685938146	0.511745685938146	true	false	false
15eaf6d3-c338-44cf-a433-6a835a983715	2026-09-14 15:43	2026-09-14 15:43	2026-09-14 15:43	JEF	JEF260918P00050000	put	50.0000	2026-09-18	1.1500	1.0000	1.2000	49.8050	16675.00	3565.00	13110.00	145	19	2196	8641	0.254137252632797	0.509270542522353	0.509270542522353	false	false	false
dc7bed21-0023-4575-8ffb-4f16258ad073	2026-09-14 15:44	2026-09-14 15:44	2026-09-14 15:44	JEF	JEF260918P00050000	put	50.0000	2026-09-18	1.1500	0.9000	1.2000	49.8300	16790.00	1035.00	15755.00	146	18	2493	8641	0.288508274505266	0.503043088557613	0.515441847359739	false	false	false
ccdf2a6a-be91-40a4-9e0c-4af9ebc48092	2026-09-14 15:44	2026-09-14 15:44	2026-09-14 15:44	JEF	JEF260918P00050000	put	50.0000	2026-09-18	1.1500	1.0000	1.2000	49.8400	16905.00	16905.00	0.00	147	5	2640	8641	0.305520194421942	0.517895105862855	0.517895105862855	false	false	false
f01d3004-6ee7-47ba-a5dd-fd08abb52e74	2026-09-16 14:46	2026-09-16 14:46	2026-09-16 14:46	JEF	JEF270115C00065000	call	65.0000	2027-01-15	0.6000	0.5500	0.8000	48.7100	11820.00	0.00	11820.00	197	12	200	743	0.269179004037685	0.3784438891623	0.3784438891623	true	false	false
aeeeaec3-d50e-4fbe-8446-f17e5de50f09	2026-09-21 15:52	2026-09-21 15:52	2026-09-21 15:52	JEF	JEF261016P00045000	put	45.0000	2026-10-16	1.1500	1.1000	1.1500	47.8700	20930.00	20930.00	0.00	182	14	235	102	2.30392156862745	0.485680233505133	0.485680233505133	false	false	false
46d12d2d-29d1-44f0-af7b-628b62b945e1	2026-09-22 15:26	2026-09-22 15:26	2026-09-22 15:26	JEF	JEF261016P00047500	put	47.5000	2026-10-16	2.2500	2.1000	2.2500	47.5300	22500.00	22500.00	0.00	100	6	237	102	2.32352941176471	0.479446205393213	0.479446205393213	false	false	false
64bc1769-57b8-4e2b-a582-08071130cb5a	2026-09-23 15:31	2026-09-23 15:31	2026-09-23 15:31	JEF	JEF261016P00047500	put	47.5000	2026-10-16	2.4000	2.3000	2.4000	47.1900	11280.00	11280.00	0.00	47	12	166	570	0.291228070175439	0.486655550245933	0.486655550245933	false	false	false
6dce0ce8-6682-4906-97ff-c2ebab652c59	2026-09-23 15:31	2026-09-23 15:31	2026-09-23 15:31	JEF	JEF261016P00047500	put	47.5000	2026-10-16	2.4000	2.2500	2.4500	47.2000	18000.00	18000.00	0.00	75	6	241	570	0.42280701754386	0.487689473727264	0.487689473727264	false	false	false
3d4aa2e2-80d6-41fb-832e-92dfa8848b6e	2026-09-23 15:31	2026-09-23 15:31	2026-09-23 15:31	JEF	JEF261016P00047500	put	47.5000	2026-10-16	2.4000	2.3000	2.4000	47.1900	18960.00	18960.00	0.00	79	10	320	570	0.56140350877193	0.486655550245933	0.486655550245933	false	false	false
8b550c0b-af2c-4505-ac42-e5be7d9d128c	2026-09-23 15:32	2026-09-23 15:32	2026-09-23 15:32	JEF	JEF261016P00047500	put	47.5000	2026-10-16	2.4000	2.2000	2.4000	47.2000	19200.00	19200.00	0.00	80	11	400	570	0.701754385964912	0.487689473727264	0.487689473727264	false	false	false
02201a96-016b-4993-8106-e49214df5acb	2026-09-28 15:25	2026-09-28 15:25	2026-09-28 15:25	JEF	JEF261016P00045000	put	45.0000	2026-10-16	1.2500	1.1500	1.2500	47.1800	54369.00	54369.00	0.00	435	44	720	324	2.22222222222222	0.540022997662927	0.540022997662927	false	false	false
d2ef5b16-f5a8-45c9-9aed-71766189d5d4	2026-09-28 15:27	2026-09-28 15:27	2026-09-28 15:27	JEF	JEF261016P00042500	put	42.5000	2026-10-16	0.6000	0.6000	0.7000	47.0650	18000.00	0.00	18000.00	300	8	1237	193	6.40932642487047	0.550839226029301	0.550839226029301	false	false	false
55e02cae-1b16-4c77-895a-c36f3bb04ae9	2026-09-30 13:39	2026-09-30 13:39	2026-09-30 13:39	JEF	JEF270319P00037500	put	37.5000	2027-03-19	1.7000	1.6500	1.8500	45.0000	11220.00	0.00	11220.00	66	5	930	101	9.20792079207921	0.444687465588749	0.444687465588749	false	false	false
f1e8c5cb-a1eb-4cf6-81a0-2ff754b6ff82	2026-10-01 15:18	2026-10-01 15:18	2026-10-01 15:18	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.6400	4.2000	5.2000	45.0000	26469.00	0.00	26469.00	57	6	114	851	0.133960047003525	0.436602458299812	0.436602458299812	false	false	false
b14a8a71-f138-4dda-91b1-72e3c1583b43	2026-10-01 15:19	2026-10-01 15:19	2026-10-01 15:19	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.7800	4.3000	5.2000	45.0000	19100.00	19100.00	0.00	40	6	373	851	0.438307873090482	0.440307365883392	0.440307365883392	false	false	false
44e6b496-3459-4707-951d-79afc1ab6ce2	2026-10-01 15:19	2026-10-01 15:19	2026-10-01 15:19	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.7800	4.3000	5.2000	45.0000	13392.00	13392.00	0.00	28	5	434	851	0.509988249118684	0.441743160319599	0.441743160319599	false	false	false
5d9c6e35-6844-4193-920a-81a3dc7cc3cd	2026-10-01 15:20	2026-10-01 15:20	2026-10-01 15:20	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.7800	4.3000	5.2000	45.0000	11005.00	11005.00	0.00	23	5	457	851	0.537015276145711	0.442719178506663	0.442719178506663	false	false	false
a5680d8e-9f8f-43de-8eff-5e4fbfc83f50	2026-10-01 15:20	2026-10-01 15:20	2026-10-01 15:20	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.7900	4.3000	5.2000	45.0000	10531.00	10531.00	0.00	22	6	479	851	0.562867215041128	0.442719178506663	0.445130601722758	false	false	false