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: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	price

4b3ad556-c983-4019-8a04-629b3e2e9382	2026-09-16 09:51	2026-09-16 09:50	2026-09-16 09:50	JD	JD261016C00027000	call	27.0000	2026-10-16	0.9800	0.9200	1.0000	26.8700	24500.00	12544.00	588.00	250	45	250	1019	0.245338567222767	0.326512249515867	0.325679738332756	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Consumer Cyclical	32634511092.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
99c2cfbb-7845-4cc7-9098-68c4d81ea2a4	2026-09-15 15:27	2026-09-15 15:27	2026-09-15 15:27	JD	JD261218C00030000	call	30.0000	2026-12-18	1.0500	1.0500	1.1100	27.0850	15750.00	0.00	15750.00	150	10	515	10526	0.0489264677940338	0.365654970417716	0.365654970417716	false	false	false	true	false
1fb1839b-97a0-452f-bdcd-f9ba1b74dd88	2026-09-15 15:25	2026-09-15 15:25	2026-09-15 15:25	JD	JD261218C00030000	call	30.0000	2026-12-18	1.0500	1.0500	1.1100	27.0750	15750.00	0.00	15750.00	150	5	178	10526	0.0169105073152195	0.366335594930807	0.366335594930807	false	false	false	true	false
3f3fc013-c300-4583-83de-992e357f3ae7	2026-09-15 15:25	2026-09-15 15:25	2026-09-15 15:25	JD	JD261218C00029000	call	29.0000	2026-12-18	1.3300	1.3100	1.4100	27.0750	24871.00	0.00	24871.00	187	5	1311	2899	0.452224905139703	0.361325469419157	0.361325469419157	false	false	false	true	false
5d8484ab-fb31-4390-adec-5ad0c88b8db5	2026-09-15 13:17	2026-09-15 13:17	2026-09-15 13:17	JD	JD270115P00025000	put	25.0000	2027-01-15	1.0600	1.0400	1.0600	27.1900	10812.00	10812.00	0.00	102	14	534	26725	0.0199812909260992	0.350088198940607	0.350088198940607	false	false	false	true	false
cde25a4b-aaa2-45f8-8913-be6bc4bce29e	2026-09-15 12:11	2026-09-15 12:11	2026-09-15 12:11	JD	JD270115P00025000	put	25.0000	2027-01-15	1.0800	1.0500	1.0800	27.1900	32940.00	32940.00	0.00	305	36	381	26725	0.0142563143124415	0.353868279533261	0.353868279533261	false	false	false	true	false
928843f5-d1fe-4609-9514-fb413802c947	2026-09-15 11:33	2026-09-15 11:33	2026-09-15 11:33	JD	JD261218C00029000	call	29.0000	2026-12-18	1.3500	1.3300	1.4900	27.1450	25245.00	0.00	25245.00	187	7	1124	2899	0.387719903414971	0.359654035196684	0.359654035196684	false	false	false	true	false
a5508a89-b882-4246-a822-7acdb1411efa	2026-09-15 11:32	2026-09-15 11:32	2026-09-15 11:32	JD	JD261218P00026000	put	26.0000	2026-12-18	1.2600	1.2200	1.2600	27.1500	15246.00	15246.00	0.00	121	29	589	5621	0.104785625333571	0.353486408265592	0.353486408265592	false	false	false	true	false
8b9db146-ce0c-4f9f-b012-004300a0de75	2026-09-15 11:09	2026-09-15 11:09	2026-09-15 11:09	JD	JD270319P00027000	put	27.0000	2027-03-19	2.3800	2.3800	2.5000	27.0000	12614.00	0.00	12614.00	53	53	53	685	0.0773722627737226	0.357574345113831	0.357574345113831	false	false	false	true	false
022326d3-7647-4b41-9354-e8379b65e23d	2026-09-15 10:55	2026-09-15 10:55	2026-09-15 10:55	JD	JD261218C00029000	call	29.0000	2026-12-18	1.3300	1.3200	1.4800	27.0000	24921.00	0.00	24921.00	187	9	376	2899	0.12969989651604	0.361268135475329	0.361268135475329	false	false	false	true	false
66683169-fd40-43c8-ad0f-66db63f3e182	2026-09-15 10:54	2026-09-15 10:54	2026-09-15 10:54	JD	JD261218P00029000	put	29.0000	2026-12-18	2.9100	2.9000	2.9100	27.0000	54417.00	54417.00	0.00	187	8	257	1424	0.180477528089888	0.360909830352168	0.360909830352168	true	false	false	true	false
e1046621-2f4a-4e9e-b38a-4a99d1c17d74	2026-09-15 10:52	2026-09-15 10:52	2026-09-15 10:52	JD	JD261218P00026000	put	26.0000	2026-12-18	1.2700	1.2200	1.2700	27.1350	35560.00	35560.00	0.00	280	39	280	5621	0.049813200498132	0.354422985740342	0.354422985740342	false	false	false	true	false
75c88308-af17-4754-a5ed-0191a975068f	2026-09-14 15:25	2026-09-14 15:25	2026-09-14 15:25	JD	JD270319P00029000	put	29.0000	2027-03-19	3.3500	3.3000	3.4500	27.3250	104285.00	0.00	96815.00	311	17	1558	33	47.2121212121212	0.35081139035408	0.344712224284763	false	false	false	true	false
4340e9b0-1ff3-43ba-a18d-764019832e13	2026-09-14 15:25	2026-09-14 15:25	2026-09-14 15:25	JD	JD270319C00029000	call	29.0000	2027-03-19	2.3400	2.2900	2.4000	27.3250	83143.00	70669.00	12474.00	356	19	1506	137	10.992700729927	0.364058082428979	0.366315577694435	true	false	false	true	false
9ae7fac5-9c1b-4826-ae13-84a8abd24d73	2026-09-14 15:23	2026-09-14 15:23	2026-09-14 15:23	JD	JD270115P00024000	put	24.0000	2027-01-15	0.8000	0.7500	0.8000	27.3250	24720.00	24720.00	0.00	309	33	588	462	1.27272727272727	0.363233377255765	0.363233377255765	false	false	false	true	false
e67db64a-e05c-4295-8c33-1f3a5ffbab01	2026-09-14 14:34	2026-09-14 14:34	2026-09-14 14:34	JD	JD261218P00027000	put	27.0000	2026-12-18	1.6500	1.6100	1.6600	27.3750	13695.00	13695.00	0.00	83	26	1267	3881	0.326462251996908	0.357466846926146	0.357466846926146	false	false	false	true	false
afe00413-50fa-4743-ab81-db91824e0a2a	2026-09-14 14:34	2026-09-14 14:34	2026-09-14 14:34	JD	JD270319P00029000	put	29.0000	2027-03-19	3.3500	3.3500	3.4500	27.3750	100500.00	0.00	100500.00	300	13	919	33	27.8484848484848	0.348028446879792	0.348028446879792	false	false	false	true	false
4a801adb-8ff0-4f8c-8d2c-e352480e6e0a	2026-09-14 14:34	2026-09-14 14:34	2026-09-14 14:34	JD	JD270319C00029000	call	29.0000	2027-03-19	2.3300	2.3300	2.6000	27.3750	69956.00	1920.00	68036.00	300	10	821	137	5.99270072992701	0.368302659555761	0.359321366943816	false	false	false	true	false
e61dcfe9-0438-4468-8ce8-f275231d7fef	2026-09-14 14:22	2026-09-14 14:21	2026-09-14 14:21	JD	JD261218P00027000	put	27.0000	2026-12-18	1.6600	1.6500	1.6600	27.3650	21580.00	21580.00	0.00	130	16	1054	3881	0.271579489822211	0.358551294710678	0.358551294710678	false	false	false	true	false
d0083b0e-ee88-47e7-a450-6e738770d6bc	2026-09-14 14:15	2026-09-14 14:14	2026-09-14 14:14	JD	JD270115C00037000	call	37.0000	2027-01-15	0.3700	0.3500	0.4300	27.3750	49136.00	46435.00	2701.00	1328	52	1337	2393	0.558712912661931	0.398911225762935	0.398911225762935	false	false	false	true	false
47df6734-a83f-4263-ab87-edb36845d627	2026-09-14 14:13	2026-09-14 14:13	2026-09-14 14:13	JD	JD270115P00026000	put	26.0000	2027-01-15	1.3700	1.2800	1.3900	27.3750	31424.00	5754.00	22792.00	229	36	236	628	0.375796178343949	0.345476153812469	0.34375448220398	true	false	false	true	false
4736936c-845e-4243-a216-8955bc42dcd5	2026-09-14 14:13	2026-09-14 14:13	2026-09-14 14:13	JD	JD270115P00025000	put	25.0000	2027-01-15	1.0300	0.9900	1.0400	27.3750	24571.00	17520.00	7051.00	238	13	259	26659	0.0097152931467797	0.349698272132444	0.347798842560377	true	false	false	true	false
f3b98585-9907-42f3-b99a-23a5daed7f37	2026-09-14 12:50	2026-09-14 12:50	2026-09-14 12:50	JD	JD281215C00030000	call	30.0000	2028-12-15	5.5000	5.4000	5.6000	27.4850	56650.00	25850.00	16500.00	103	13	123	795	0.154716981132075	0.342001950498028	0.342001950498028	true	false	false	true	false
6a450fee-98fc-48a8-8c9a-3c259c0ef611	2026-09-14 11:47	2026-09-14 11:47	2026-09-14 11:47	JD	JD261218P00027000	put	27.0000	2026-12-18	1.6900	1.6800	1.6900	27.3200	14196.00	14196.00	0.00	84	9	306	3881	0.0788456583354805	0.360650790035771	0.360650790035771	false	false	false	true	false
def25113-c766-425f-ba6c-32ece503fa34	2026-09-14 10:37	2026-09-14 10:37	2026-09-14 10:37	JD	JD270115P00024000	put	24.0000	2027-01-15	0.8400	0.8000	0.8400	27.1250	23016.00	23016.00	0.00	274	26	274	462	0.593073593073593	0.362253801090976	0.362253801090976	false	false	false	true	false
bbf47e9c-f8c1-42be-ae31-66987ee451f9	2026-09-11 15:24	2026-09-11 15:24	2026-09-11 15:24	JD	JD280121C00028000	call	28.0000	2028-01-21	4.6000	4.5000	4.6000	27.1350	161000.00	161000.00	0.00	350	24	352	6515	0.0540291634689179	0.350530811931627	0.350530811931627	true	false	false	true	false
f17cec75-2829-41d4-a611-ad977e1e94dc	2026-09-11 14:50	2026-09-11 14:49	2026-09-11 14:49	JD	JD261218P00028000	put	28.0000	2026-12-18	2.2900	2.2900	2.3400	27.1150	57937.00	0.00	57937.00	253	11	253	4085	0.0619339045287638	0.351397744683678	0.351397744683678	false	false	false	true	false
eff51742-ed8a-43dd-b731-d8b90eebdc4b	2026-09-11 14:28	2026-09-11 14:28	2026-09-11 14:28	JD	JD261016P00030000	put	30.0000	2026-10-16	3.0000	2.9800	3.0500	27.1200	23415.00	4800.00	13815.00	78	16	166	1110	0.14954954954955	0.315862886281545	0.315862886281545	false	false	false	true	false
c8fb12d8-19b2-43e9-89bb-619edfaf6254	2026-09-11 12:45	2026-09-11 12:45	2026-09-11 12:45	JD	JD270115P00027000	put	27.0000	2027-01-15	1.9500	1.9500	1.9800	27.1400	50895.00	0.00	50895.00	261	23	270	10586	0.0255053844700548	0.34615104918436	0.34615104918436	false	false	false	true	false
8bb06b4b-e965-4a06-ac7e-b332f842f851	2026-09-11 12:45	2026-09-11 12:45	2026-09-11 12:45	JD	JD270115P00028000	put	28.0000	2027-01-15	2.4800	2.4800	2.5000	27.1400	15128.00	0.00	15128.00	61	17	131	4203	0.0311682131810611	0.345361534424707	0.345361534424707	false	false	false	true	false
93637a43-a356-48fa-b738-16333452a050	2026-09-11 12:01	2026-09-11 12:01	2026-09-11 12:01	JD	JD261218P00030000	put	30.0000	2026-12-18	3.6500	3.5500	3.6500	27.1650	10215.00	9855.00	360.00	28	5	139	8301	0.0167449704854837	0.370362767152858	0.360824118066109	false	false	false	true	false
2b3b21e4-65b4-46b6-b8fe-ae09d58c9263	2026-09-11 12:01	2026-09-11 12:01	2026-09-11 12:01	JD	JD261218P00030000	put	30.0000	2026-12-18	3.6300	3.5500	3.6500	27.1650	10175.00	6935.00	3240.00	28	13	111	8301	0.013371882905674	0.370362767152858	0.360824118066109	false	false	false	true	false
b228a197-1e9a-4fc1-ac64-24566508b4b1	2026-09-11 12:01	2026-09-11 12:01	2026-09-11 12:01	JD	JD261218P00030000	put	30.0000	2026-12-18	3.6200	3.5500	3.6500	27.1650	13410.00	6570.00	3960.00	37	20	65	8301	0.007830381881701	0.370362767152858	0.360824118066109	false	false	false	true	false
65d99c2e-dd27-468b-b180-d3b2c26088f2	2026-09-11 11:50	2026-09-11 11:50	2026-09-11 11:50	JD	JD261218P00025000	put	25.0000	2026-12-18	0.9400	0.9400	0.9600	27.1400	31020.00	0.00	31020.00	330	15	394	14756	0.0267010029818379	0.356917648967451	0.356917648967451	false	false	false	true	false
e5c0de32-3e79-4ba5-a078-f863af802b92	2026-09-11 11:11	2026-09-11 11:11	2026-09-11 11:11	JD	JD270115C00029000	call	29.0000	2027-01-15	1.6900	1.6900	1.7300	27.1950	11661.00	0.00	11661.00	69	18	71	525	0.135238095238095	0.358676271461772	0.358676271461772	false	false	false	true	false
1468a188-f941-4425-9027-5dddf7d10ba4	2026-09-11 10:58	2026-09-11 10:58	2026-09-11 10:58	JD	JD261016P00030000	put	30.0000	2026-10-16	2.9200	2.8500	3.0000	27.2105	15768.00	13140.00	1752.00	54	10	56	1110	0.0504504504504504	0.31336774281153	0.31336774281153	true	false	false	true	false
d587594f-950e-4f7c-a3d9-a5f5779de98b	2026-09-11 10:46	2026-09-11 10:46	2026-09-11 10:46	JD	JD261016C00024000	call	24.0000	2026-10-16	3.4300	3.3500	3.5000	27.2181	16807.00	16807.00	0.00	49	6	49	215	0.227906976744186	0.325090626839378	0.325090626839378	false	false	false	true	false
163ae774-bb7d-4385-b32d-d412f27c5fb9	2026-09-11 09:49	2026-09-11 09:49	2026-09-11 09:49	JD	JD260925C00028000	call	28.0000	2026-09-25	0.3500	0.3100	0.3500	27.0000	18480.00	18480.00	0.00	528	13	1530	624	2.45192307692308	0.301872139013708	0.301872139013708	false	false	false	true	false
b583062b-f773-4421-bcbb-1707b2b99a8d	2026-09-10 13:52	2026-09-10 13:52	2026-09-10 13:52	JD	JD270115C00032000	call	32.0000	2027-01-15	0.8600	0.8600	0.8800	27.0300	18060.00	0.00	18060.00	210	21	303	4603	0.0658266348033891	0.365409783067767	0.365409783067767	false	false	false	true	false
debc1308-b76a-49f7-add5-5fe292788baf	2026-09-10 12:43	2026-09-10 12:43	2026-09-10 12:43	JD	JD261016C00029000	call	29.0000	2026-10-16	0.4100	0.4100	0.4400	27.0000	13858.00	0.00	13858.00	338	21	807	3480	0.231896551724138	0.315066097592296	0.315066097592296	false	false	false	true	false
7535fabb-7f9b-43ac-a7e0-cfdd047f4960	2026-09-10 11:24	2026-09-10 11:24	2026-09-10 11:24	JD	JD261016C00029000	call	29.0000	2026-10-16	0.4100	0.4100	0.4300	26.9850	10661.00	0.00	10619.00	260	22	433	3480	0.124425287356322	0.317924632231249	0.317924632231249	false	false	false	true	false
5caa8099-1d52-406b-9215-d7fc7242191e	2026-09-10 10:26	2026-09-10 10:26	2026-09-10 10:26	JD	JD260925C00029000	call	29.0000	2026-09-25	0.1300	0.1300	0.1600	27.0000	13117.00	0.00	13117.00	1009	24	1010	383	2.63707571801567	0.319978295142944	0.319978295142944	false	false	false	true	false
cde76fb4-57e8-44ed-b523-d7d5d5f181d0	2026-09-10 09:37	2026-09-10 09:37	2026-09-10 09:37	JD	JD261016P00027000	put	27.0000	2026-10-16	1.0500	1.0400	1.1400	26.8700	120330.00	105.00	120225.00	1146	23	1176	3053	0.385194890271864	0.308058539007187	0.308058539007187	false	false	false	true	false
712c52fa-7780-4684-bf5f-34e828f5f504	2026-09-09 13:28	2026-09-09 13:28	2026-09-09 13:28	JD	JD261016C00029000	call	29.0000	2026-10-16	0.4400	0.4400	0.4600	26.9800	11220.00	0.00	11220.00	255	16	302	3287	0.0918770915728628	0.324474160801951	0.324474160801951	false	false	false	true	false
f7d16439-db95-4c23-9ab1-d25850046102	2026-09-09 13:02	2026-09-09 13:02	2026-09-09 13:02	JD	JD261016C00027000	call	27.0000	2026-10-16	1.1200	1.1200	1.1600	26.0000	22480.00	0.00	22480.00	200	32	471	786	0.599236641221374	0.315215475304564	0.312287785771208	false	false	false	true	false
deab2d15-b1ba-4373-a629-4d46a1b49c98	2026-09-09 13:02	2026-09-09 13:02	2026-09-09 13:02	JD	JD261016P00027000	put	27.0000	2026-10-16	1.0100	1.0100	1.0300	26.0000	18584.00	0.00	18584.00	184	13	485	2657	0.182536695521265	0.307156128500891	0.307156128500891	false	false	false	true	false
0a00eee0-32d0-48a2-bc09-b21a2b7f2204	2026-09-09 13:02	2026-09-09 13:01	2026-09-09 13:01	JD	JD261016P00027000	put	27.0000	2026-10-16	1.0100	1.0100	1.0300	26.0000	18589.00	0.00	18079.00	184	8	301	2657	0.113285660519383	0.310084088851263	0.307156128500891	false	false	false	true	false
f20f2acd-416e-4c36-80c7-01c6e138ff6a	2026-09-09 12:08	2026-09-09 12:07	2026-09-09 12:07	JD	JD270115P00023000	put	23.0000	2027-01-15	0.6300	0.6300	0.6500	26.9250	14175.00	0.00	14175.00	225	16	714	6891	0.103613408794079	0.361012762275897	0.361012762275897	false	false	false	true	false
0f6b4cbc-7e40-427f-83ad-35f60282bc49	2026-09-09 12:06	2026-09-09 12:06	2026-09-09 12:06	JD	JD270115C00025000	call	25.0000	2027-01-15	3.5500	3.5000	3.6500	26.9350	581490.00	581135.00	355.00	1638	43	2786	4556	0.611501316944688	0.369120504649133	0.365997907911995	false	false	false	true	false
0f7bc58f-e2ce-4dc8-ba6b-86637f1a4827	2026-09-09 12:02	2026-09-09 12:02	2026-09-09 12:02	JD	JD260911C00027000	call	27.0000	2026-09-11	0.2200	0.1900	0.2200	26.8850	10978.00	10978.00	0.00	499	8	1191	520	2.29038461538462	0.340877395136921	0.340877395136921	false	false	false	true	false