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:er_time = unknown×ticker = JD×

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

741b3a10-c08f-48ff-b2f8-90f254773884	2026-09-09 12:02	2026-09-09 12:02	2026-09-09 12:02	JD	JD260911C00027000	call	27.0000	2026-09-11	0.2100	0.1900	0.2100	26.8700	10500.00	10500.00	0.00	500	11	692	520	1.33076923076923	0.339219102808298	0.33646580484352	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Consumer Cyclical	33071255478.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d7f1538f-b623-4f8a-84a4-2437e54cca87	2026-09-09 11:56	2026-09-09 11:56	2026-09-09 11:56	JD	JD261016C00028000	call	28.0000	2026-10-16	0.6800	0.6700	0.6800	26.8600	13260.00	13260.00	0.00	195	20	305	367	0.831062670299727	0.322347078845397	0.322347078845397	false	false	false	true	false
45a18080-f889-4c42-b272-b5a20c839a89	2026-09-09 11:50	2026-09-09 11:49	2026-09-09 11:49	JD	JD260918P00027500	put	27.5000	2026-09-18	0.8800	0.8600	0.8800	26.8650	11176.00	11176.00	0.00	127	10	171	521	0.328214971209213	0.30531828868836	0.30531828868836	false	false	false	true	false
d6862508-08ad-4505-a590-f834579c2411	2026-09-09 11:28	2026-09-09 11:28	2026-09-09 11:28	JD	JD270115P00027000	put	27.0000	2027-01-15	2.0700	2.0600	2.0900	26.9150	13248.00	828.00	12420.00	64	5	71	10600	0.00669811320754717	0.350476209676505	0.350476209676505	false	false	false	true	false
f0846216-e919-40a1-948f-547da782c645	2026-09-09 11:17	2026-09-09 11:17	2026-09-09 11:17	JD	JD270115C00025000	call	25.0000	2027-01-15	3.5500	3.5000	3.6000	26.9300	231460.00	218680.00	12780.00	652	30	967	4556	0.212247585601405	0.367249182228986	0.366623921073567	false	false	false	true	false
7746d201-f1ba-4f09-9d9d-97256e1407a2	2026-09-09 11:07	2026-09-09 11:06	2026-09-09 11:06	JD	JD280121P00030000	put	30.0000	2028-01-21	6.1000	6.0000	6.1000	26.9700	90280.00	90280.00	0.00	148	8	149	6945	0.0214542836573074	0.426416356740004	0.426416356740004	false	false	false	true	false
6cd29fb4-b5ee-4bd2-b80e-22f69ac6d94a	2026-09-09 11:04	2026-09-09 11:04	2026-09-09 11:04	JD	JD270115C00025000	call	25.0000	2027-01-15	3.6400	3.5500	3.6500	27.0200	94654.00	94654.00	0.00	260	6	285	4556	0.0625548726953468	0.370325395033494	0.369694053958993	false	false	false	true	false
566cc3c5-34e3-4a16-8a1d-79bd28b411b1	2026-09-08 15:33	2026-09-08 15:33	2026-09-08 15:33	JD	JD270115C00034000	call	34.0000	2027-01-15	0.7100	0.6300	0.7200	27.6950	14180.00	14180.00	0.00	200	9	226	302	0.748344370860927	0.365870213129479	0.365870213129479	false	false	false	true	false
81b4eea2-ca53-4906-bd01-972006529dc3	2026-09-08 11:55	2026-09-08 11:55	2026-09-08 11:55	JD	JD261218P00027000	put	27.0000	2026-12-18	1.6100	1.5900	1.6600	27.5300	28014.00	27531.00	483.00	174	24	192	3795	0.0505928853754941	0.351349999448875	0.351349999448875	false	false	false	true	false
dd470e8b-c13b-4928-b34c-1ee113a2497b	2026-09-08 11:30	2026-09-08 11:30	2026-09-08 11:30	JD	JD261218P00030000	put	30.0000	2026-12-18	3.3500	3.3000	3.4000	27.5850	20100.00	11725.00	8375.00	60	7	179	8255	0.0216838279830406	0.358334213857195	0.358334213857195	false	false	false	true	false
0da556aa-25b0-4831-801b-87fdcd002d44	2026-09-08 11:10	2026-09-08 11:10	2026-09-08 11:10	JD	JD270115C00030000	call	30.0000	2027-01-15	1.5500	1.5100	1.5500	27.6250	170803.00	169725.00	1078.00	1102	47	1282	20262	0.0632711479617017	0.354929409145671	0.354929409145671	false	false	false	true
454c9078-f3b3-4c80-81ce-f50d190668b8	2026-09-08 10:23	2026-09-08 10:23	2026-09-08 10:23	JD	JD270115P00023000	put	23.0000	2027-01-15	0.5000	0.4500	0.5100	27.7350	25450.00	25450.00	0.00	509	12	612	7393	0.0827810090626268	0.360392396929309	0.360392396929309	false	false	false	true	false
03e85fb8-b9f3-4306-abc0-c2bb3778ad43	2026-09-08 09:32	2026-09-08 09:32	2026-09-08 09:32	JD	JD260925P00027000	put	27.0000	2026-09-25	0.4100	0.2600	0.4500	27.7500	13202.00	1722.00	11480.00	322	21	323	974	0.331622176591376	0.314993026767425	0.314993026767425	false	false	false	true	false
7d531f68-a477-44a5-9482-fe07dce24e5a	2026-09-04 14:44	2026-09-04 14:44	2026-09-04 14:44	JD	JD281215C00027000	call	27.0000	2028-12-15	7.1000	6.9500	7.1000	28.2150	35488.00	35488.00	0.00	50	13	61	66	0.924242424242424	0.318348757080956	0.318348757080956	false	false	false	true	false
e8a01733-41cc-4337-86c0-7093bb08d82d	2026-09-04 11:16	2026-09-04 11:16	2026-09-04 11:16	JD	JD261218C00029000	call	29.0000	2026-12-18	1.8900	1.8300	1.9600	28.2300	80325.00	80136.00	189.00	425	40	425	2762	0.153874004344678	0.34584163833434	0.34584163833434	false	false	false	true	false
bf6bdc49-1f68-4333-b79e-9b5a83c8e35e	2026-09-04 09:38	2026-09-04 09:38	2026-09-04 09:38	JD	JD261218P00028000	put	28.0000	2026-12-18	1.7900	1.7900	1.8200	28.1500	31504.00	0.00	21838.00	176	26	500	3902	0.128139415684264	0.337996774509077	0.337996774509077	false	false	false	true	false
f472a3b6-eec5-465f-895f-d40e2c98e12d	2026-09-04 09:37	2026-09-04 09:37	2026-09-04 09:37	JD	JD261218P00028000	put	28.0000	2026-12-18	1.8000	1.6000	1.8000	28.1500	16200.00	16200.00	0.00	90	15	234	3902	0.0599692465402358	0.339685150574697	0.339685150574697	false	false	false	true	false
f7a6b4c2-c92c-4339-a33e-eb3e8bff1455	2026-09-04 09:37	2026-09-04 09:37	2026-09-04 09:37	JD	JD261218P00028000	put	28.0000	2026-12-18	1.8000	1.5900	1.8000	28.1500	14040.00	14040.00	0.00	78	13	144	3902	0.0369041517170682	0.339685150574697	0.339685150574697	false	false	false	true	false
bf41447d-9df1-4a2b-b92d-8971ae1c4a9b	2026-09-04 09:37	2026-09-04 09:36	2026-09-04 09:36	JD	JD261218P00028000	put	28.0000	2026-12-18	1.8000	1.5800	1.8000	28.1689	11880.00	11880.00	0.00	66	11	66	3902	0.0169144028703229	0.341046173130654	0.341046173130654	false	false	false	true	false
6d063824-aac7-4217-9ac2-30c87bbef594	2026-09-04 09:35	2026-09-04 09:35	2026-09-04 09:35	JD	JD260904C00028000	call	28.0000	2026-09-04	0.2200	0.1900	0.2500	28.1500	10142.00	0.00	7942.00	461	24	936	1554	0.602316602316602	0.432560622098728	0.432560622098728	false	false	false	true	false
d43a172b-7786-4524-9edb-4e0e801dfe54	2026-09-03 14:37	2026-09-03 14:37	2026-09-03 14:37	JD	JD261218P00028000	put	28.0000	2026-12-18	1.9700	1.9500	1.9700	27.7850	38218.00	38218.00	0.00	194	18	194	3768	0.0514861995753716	0.340065786323734	0.340065786323734	false	false	false	true	false
ab09a0b7-d7d0-4674-809f-a297fe221a16	2026-09-02 13:15	2026-09-02 13:15	2026-09-02 13:15	JD	JD270115P00029000	put	29.0000	2027-01-15	2.7000	2.6600	2.7400	27.8600	57510.00	38070.00	19440.00	213	10	215	340	0.632352941176471	0.340309589930189	0.340309589930189	false	false	false	true	false
65436279-99ea-40f0-a681-49f7bba152c9	2026-09-02 10:30	2026-09-02 10:30	2026-09-02 10:30	JD	JD261218P00026000	put	26.0000	2026-12-18	1.0800	1.0800	1.1200	27.8650	21708.00	0.00	21708.00	201	5	201	5009	0.0401277700139748	0.342719972986119	0.342434962233853	false	false	false	true	false
d0d99945-df3b-48fb-b7d5-ec596cd4f4a4	2026-09-02 10:11	2026-09-02 10:11	2026-09-02 10:11	JD	JD261016C00030000	call	30.0000	2026-10-16	0.4900	0.4800	0.5000	27.9250	16023.00	0.00	15827.00	327	33	331	2247	0.147307521139297	0.305417716669265	0.305417716669265	false	false	false	true	false
00b795e3-ed3d-4a81-a12b-21604db8ebb0	2026-09-01 14:04	2026-09-01 14:04	2026-09-01 14:04	JD	JD270115C00029000	call	29.0000	2027-01-15	2.1000	2.0300	2.1000	27.8497	32130.00	32130.00	0.00	153	12	266	128	2.078125	0.356507169138217	0.356507169138217	false	false	false	true	false
d0a8b480-6f7c-4b83-9429-93909da6adc1	2026-09-01 13:25	2026-09-01 13:25	2026-09-01 13:25	JD	JD270115C00029000	call	29.0000	2027-01-15	2.0900	2.0600	2.0900	27.9050	19019.00	19019.00	0.00	91	9	113	128	0.8828125	0.350980615928877	0.350980615928877	false	false	false	true	false
7a6a4ad7-77fe-4760-bd6d-c6d10a35ec10	2026-09-01 09:40	2026-09-01 09:40	2026-09-01 09:40	JD	JD270617C00030000	call	30.0000	2027-06-17	2.9300	2.6200	2.9500	27.7950	44482.00	44482.00	0.00	152	6	152	2098	0.0724499523355577	0.351711817302708	0.347657318604151	false	false	false	true	false
a411a1cc-04a7-4720-8902-c4a45fca0db0	2026-08-31 15:34	2026-08-31 15:34	2026-08-31 15:34	JD	JD270115C00030000	call	30.0000	2027-01-15	1.9000	1.9000	1.9600	28.2950	10830.00	0.00	10830.00	57	6	269	19872	0.0135366344605475	0.351183403338852	0.351183403338852	false	false	false	true	false
dde24c71-3c91-4980-902a-620509f8fe1b	2026-08-31 15:27	2026-08-31 15:27	2026-08-31 15:27	JD	JD261002P00029000	put	29.0000	2026-10-02	1.3300	1.2500	1.3500	28.3150	44688.00	44555.00	133.00	336	13	351	38	9.23684210526316	0.298816312420814	0.298816312420814	false	false	false	true	false
b033c32c-42c6-4387-8344-3ffc455a4450	2026-08-31 13:55	2026-08-31 13:55	2026-08-31 13:55	JD	JD261218C00032000	call	32.0000	2026-12-18	1.0500	1.0500	1.0600	28.0000	12495.00	0.00	12495.00	119	13	230	3532	0.065118912797282	0.357732205578141	0.357732205578141	false	false	false	true	false
a1df3959-d935-49f4-8d8f-931dc585bccf	2026-08-31 10:17	2026-08-31 10:17	2026-08-31 10:17	JD	JD261218P00027000	put	27.0000	2026-12-18	1.3100	1.3100	1.4100	28.5100	11418.00	2772.00	8646.00	87	7	248	3652	0.067907995618839	0.349318327244889	0.349318327244889	false	false	false	true	false
c56a1594-3e8b-4a3e-ac29-44b52ea938b4	2026-08-31 09:44	2026-08-31 09:44	2026-08-31 09:44	JD	JD260918C00033000	call	33.0000	2026-09-18	0.0300	0.0300	0.0600	28.5500	12618.00	0.00	12618.00	4206	44	4207	21681	0.194040865273742	0.348417638571046	0.348417638571046	false	false	false	true	false
715fe7d5-c9b9-40a3-86c0-f5dd654295e3	2026-08-28 14:35	2026-08-28 14:34	2026-08-28 14:34	JD	JD261016P00030000	put	30.0000	2026-10-16	2.0700	2.0700	2.1200	28.5800	65205.00	0.00	65205.00	315	20	447	712	0.627808988764045	0.314610764189253	0.314610764189253	false	false	false	true	false
86000edb-ea4b-4587-a28c-3fb7eb4c0fa8	2026-08-27 15:46	2026-08-27 15:46	2026-08-27 15:46	JD	JD261016C00029000	call	29.0000	2026-10-16	1.1600	1.1400	1.1600	28.4400	28072.00	28072.00	0.00	242	8	574	277	2.07220216606498	0.320531368064302	0.320531368064302	false	false	false	true	false
da2e635d-9e53-496c-b388-f75df550ff25	2026-08-27 15:31	2026-08-27 15:31	2026-08-27 15:31	JD	JD260904C00029000	call	29.0000	2026-09-04	0.2700	0.2600	0.2900	28.0000	36936.00	0.00	35802.00	1368	13	1467	321	4.57009345794393	0.291434182614331	0.291434182614331	false	false	false	true	false
f87efaf7-a240-4801-85df-7737837b55ba	2026-08-27 15:29	2026-08-27 15:29	2026-08-27 15:29	JD	JD281215P00015000	put	15.0000	2028-12-15	1.0000	0.9900	1.0500	28.0000	19800.00	3600.00	16200.00	198	12	200	120	1.66666666666667	0.461164517337063	0.461164517337063	false	false	false	true	false
292c1ac9-7072-45cd-8eeb-2e869455a0e1	2026-08-27 15:27	2026-08-27 15:27	2026-08-27 15:27	JD	JD261016C00030000	call	30.0000	2026-10-16	0.8200	0.7700	0.8200	28.0000	20500.00	20500.00	0.00	250	32	340	2023	0.168067226890756	0.32944493174643	0.32944493174643	false	false	false	true	false
6818f0bc-9749-43f5-a04a-7ba1425106c6	2026-08-27 14:57	2026-08-27 14:57	2026-08-27 14:57	JD	JD270115C00029000	call	29.0000	2027-01-15	2.5000	2.4400	2.5000	28.4400	18000.00	18000.00	0.00	72	7	73	67	1.08955223880597	0.363091276176038	0.363091276176038	false	false	false	true	false
763e958b-087b-4ff6-a324-5fabc9be3882	2026-08-27 12:54	2026-08-27 12:54	2026-08-27 12:54	JD	JD270319C00032000	call	32.0000	2027-03-19	2.1300	1.9800	2.1600	28.3400	10657.00	8424.00	0.00	50	5	51	1335	0.0382022471910112	0.387965824141832	0.372254386175113	false	false	false	true	false
46d0f2da-0a6f-42da-b8bd-5a54a7a3cf3d	2026-08-27 12:05	2026-08-27 12:04	2026-08-27 12:04	JD	JD260925C00031000	call	31.0000	2026-09-25	0.2500	0.2500	0.2800	28.3600	25250.00	0.00	25250.00	1010	20	1012	4076	0.248282630029441	0.323381042144471	0.323381042144471	false	false	false	true	false
cc1ff306-ff5d-4455-a108-6ef28f4df6cc	2026-08-27 10:05	2026-08-27 10:05	2026-08-27 10:05	JD	JD270617P00025000	put	25.0000	2027-06-17	2.1400	2.0500	2.3700	28.3850	214000.00	0.00	214000.00	1000	2	1008	8505	0.118518518518519	0.415106424283998	0.415106424283998	false	true	true	false	false
995d9e48-2453-46ef-a8c8-60f8075a51e0	2026-08-26 12:01	2026-08-26 12:01	2026-08-26 12:01	JD	JD260918C00030000	call	30.0000	2026-09-18	0.4800	0.4700	0.5000	28.8200	12960.00	0.00	12960.00	270	10	515	10275	0.0501216545012165	0.316658123986236	0.316658123986236	false	false	false	true	false
c81560e9-a8a5-46fc-b385-3295e2344f99	2026-08-25 14:10	2026-08-25 14:10	2026-08-25 14:10	JD	JD270617P00028000	put	28.0000	2027-06-17	3.2000	3.2000	3.2500	29.0000	13120.00	0.00	13120.00	41	8	802	2211	0.362731795567616	0.41698029808609	0.41698029808609	false	false	false	true	false
2ef00fa6-235b-4b28-88ed-14bf285be6f4	2026-08-25 11:24	2026-08-25 11:23	2026-08-25 11:23	JD	JD270617P00025000	put	25.0000	2027-06-17	2.0600	1.9200	2.2300	29.1250	42142.00	5131.00	20726.00	205	32	218	8300	0.0262650602409639	0.429897335938437	0.423897389515048	false	false	false	true	false
a1afa6a6-2d4d-4dc9-8058-cffd25b4b0e4	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	JD	JD270617P00028000	put	28.0000	2027-06-17	3.3000	3.2000	3.3500	29.1300	86130.00	84810.00	1320.00	261	8	744	2211	0.336499321573948	0.4224050539139	0.4224050539139	false	false	false	true	false
b311b9c8-1839-4e86-b8b4-66181a536685	2026-08-25 11:03	2026-08-25 11:03	2026-08-25 11:03	JD	JD270617P00028000	put	28.0000	2027-06-17	3.3000	3.1500	3.4000	29.0950	50820.00	49170.00	1650.00	154	6	441	2211	0.199457259158752	0.421137955413746	0.421137955413746	false	false	false	true	false
c5b04aab-6447-4b2c-a36f-bf1a409dc19a	2026-08-24 14:59	2026-08-24 14:58	2026-08-24 14:58	JD	JD270917P00027000	put	27.0000	2027-09-17	3.2500	3.1500	3.3000	29.1100	11700.00	11050.00	650.00	36	7	104	5	20.8	0.421052075781379	0.421052075781379	false	false	false	true	false
15817a27-e2c5-418e-b5f6-ae74ae04b0c5	2026-08-24 14:52	2026-08-24 14:52	2026-08-24 14:52	JD	JD270917P00032000	put	32.0000	2027-09-17	6.0500	5.9500	6.1500	29.1150	21780.00	20570.00	1210.00	36	6	110	0	0	0.433301905712726	0.433301905712726	false	false	false	true	false
30ca3f17-7065-4391-99af-147a2972f3b4	2026-08-24 14:08	2026-08-24 14:08	2026-08-24 14:08	JD	JD281215C00025000	call	25.0000	2028-12-15	8.7500	8.6500	8.8000	29.0500	51625.00	51625.00	0.00	59	12	100	404	0.247524752475248	0.317193296585696	0.317778441667983	true	false	false	true	false
ac28021d-226f-42f4-b327-c94a8d012d7d	2026-08-24 13:58	2026-08-24 13:58	2026-08-24 13:58	JD	JD261218P00025000	put	25.0000	2026-12-18	0.7100	0.6500	0.7300	29.1000	105932.00	105861.00	71.00	1492	43	1508	14012	0.107622038252926	0.375686473066158	0.375686473066158	false	false	false	true	false