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:sector = Consumer Cyclical×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

5687576d-1208-461c-9ba8-15a04393cee0	2026-09-22 14:39	2026-09-22 14:39	2026-09-22 14:39	JD	JD270617P00028000	put	28.0000	2027-06-17	3.7500	3.7000	3.8000	27.4100	19500.00	19125.00	0.00	52	13	930	2303	0.403821102909249	0.421199645156378	0.421199645156378	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Consumer Cyclical	33216836940.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
6a89948e-b0b1-46d8-a90d-ebff90b92ab1	2026-09-22 14:38	2026-09-22 14:38	2026-09-22 14:38	JD	JD270617P00028000	put	28.0000	2027-06-17	3.7500	3.6500	3.7500	27.4050	24000.00	24000.00	0.00	64	24	773	2303	0.335649153278333	0.420972514352543	0.420972514352543	false	false	false	true
098de9f5-e7e6-4d3d-9639-d36af94d35ec	2026-09-22 13:59	2026-09-22 13:59	2026-09-22 13:59	JD	JD261016P00028000	put	28.0000	2026-10-16	1.1400	1.1400	1.2400	27.4100	32376.00	0.00	32376.00	284	33	468	2076	0.225433526011561	0.302749540229706	0.302749540229706	false	false	false	true
3eacb1b6-9f9e-4ff0-ba8c-c443d027a52c	2026-09-22 13:55	2026-09-22 13:54	2026-09-22 13:54	JD	JD261009P00027000	put	27.0000	2026-10-09	0.4900	0.3300	0.5200	27.4200	10973.00	196.00	10777.00	224	35	259	105	2.46666666666667	0.296560361845487	0.294673184233878	true	false	false	true
1023e15f-4ca5-4a67-a87e-121274888535	2026-09-22 13:55	2026-09-22 13:54	2026-09-22 13:54	JD	JD261009P00026500	put	26.5000	2026-10-09	0.3000	0.3000	0.3300	27.4200	41061.00	6501.00	34560.00	1349	23	1350	5	270	0.289912927609832	0.291999831315435	false	false	false	true
966467d4-598c-45e2-911d-2afb510602e6	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	JD	JD260925P00027000	put	27.0000	2026-09-25	0.2400	0.2400	0.2600	27.2750	10200.00	0.00	10200.00	425	25	491	2007	0.244643746885899	0.371395703789787	0.371395703789787	true	false	false	true
6057b906-898e-4c19-9cc2-b6b37f4ac09b	2026-09-22 11:07	2026-09-22 11:07	2026-09-22 11:07	JD	JD270319C00027000	call	27.0000	2027-03-19	3.1700	3.1500	3.2500	27.0000	15533.00	0.00	15533.00	49	8	49	428	0.114485981308411	0.36235026929845	0.36235026929845	false	false	false	true
9c8c4b3a-7734-4902-9e6c-ac6c57c37cb9	2026-09-22 10:54	2026-09-22 10:54	2026-09-22 10:54	JD	JD270617C00028000	call	28.0000	2027-06-17	3.2500	3.1000	3.3000	27.3750	260000.00	66950.00	91650.00	800	16	2802	2049	1.36749633967789	0.335220251714074	0.335220251714074	true	false	false	true
b2ec9b3f-b471-451e-8626-7918f794748d	2026-09-22 09:46	2026-09-22 09:46	2026-09-22 09:46	JD	JD280121C00028000	call	28.0000	2028-01-21	4.7200	4.7000	4.8000	27.6200	49555.00	9500.00	30080.00	105	20	299	6864	0.0435606060606061	0.323916020148872	0.328055395219241	false	false	false	true
f3f99b6f-0317-4d6c-af81-4789f93e6b11	2026-09-22 09:46	2026-09-22 09:46	2026-09-22 09:46	JD	JD280121C00028000	call	28.0000	2028-01-21	4.7200	4.7000	4.8000	27.6200	62750.00	22800.00	39950.00	133	23	193	6864	0.0281177156177156	0.323916020148872	0.328055395219241	false	false	false	true
fded9ccb-fcd3-4d4f-b3a1-e72f186109a9	2026-09-22 09:46	2026-09-22 09:46	2026-09-22 09:46	JD	JD280121C00028000	call	28.0000	2028-01-21	4.7500	4.6000	4.7500	27.6200	25175.00	16625.00	0.00	53	16	54	6864	0.00786713286713287	0.328055395219241	0.328055395219241	false	false	false	true
01f750d5-d8d8-4e1e-a8f8-9daab3e7f96a	2026-09-22 09:41	2026-09-22 09:41	2026-09-22 09:41	JD	JD261016P00029000	put	29.0000	2026-10-16	1.6600	1.5200	1.6800	27.6600	29888.00	2830.00	27058.00	180	32	180	8507	0.0211590454919478	0.306997759573707	0.306997759573707	false	false	false	true
fb5392d7-0f30-49d2-ae2b-b18ee953d3d6	2026-09-21 15:56	2026-09-21 15:55	2026-09-21 15:55	JD	JD270115C00030000	call	30.0000	2027-01-15	1.3300	1.2600	1.3900	27.0000	13965.00	11837.00	2128.00	105	18	1205	21305	0.0565594930767426	0.3636724864226	0.363346697465856	true	false	false	true
29b97473-e0ea-48ec-983f-4ba891ff61d4	2026-09-21 15:54	2026-09-21 15:54	2026-09-21 15:54	JD	JD270115C00030000	call	30.0000	2027-01-15	1.3000	1.2500	1.4000	27.0000	47450.00	5850.00	41600.00	365	13	1100	21305	0.0516310725181882	0.359191219225751	0.359191219225751	false	false	false	true
e80bfebf-8423-4581-8c60-860a760fc055	2026-09-21 11:12	2026-09-21 11:12	2026-09-21 11:12	JD	JD261120C00025000	call	25.0000	2026-11-20	2.8900	2.6600	2.8900	26.0000	10109.00	10109.00	0.00	35	5	73	39	1.87179487179487	0.391189200002646	0.391189200002646	false	false	false	true
fd8497b5-15b5-4439-8c08-6b9b65dcac42	2026-09-21 10:32	2026-09-21 10:32	2026-09-21 10:32	JD	JD270617C00028000	call	28.0000	2027-06-17	2.8800	2.8200	2.8800	26.8600	55296.00	33984.00	0.00	192	32	211	1875	0.112533333333333	0.325495472486656	0.325495472486656	false	false	false	true
4a1a4ba0-610f-4fc3-89bb-a5067b0c755c	2026-09-21 10:31	2026-09-21 10:31	2026-09-21 10:31	JD	JD261218P00026000	put	26.0000	2026-12-18	1.2600	1.2600	1.3000	26.8650	49140.00	0.00	49140.00	390	36	692	5863	0.118028313150264	0.343016995424553	0.343016995424553	false	false	false	true
15a0feb3-d9e5-4f72-899d-d5cc78975e57	2026-09-21 10:25	2026-09-21 10:24	2026-09-21 10:24	JD	JD271217C00035000	call	35.0000	2027-12-17	2.2500	2.0200	2.2500	26.8850	22500.00	22500.00	0.00	100	6	100	2692	0.037147102526003	0.356033079564862	0.356033079564862	false	false	false	true
804a2c29-4698-47ea-b960-38bc208ba93e	2026-09-21 10:06	2026-09-21 10:06	2026-09-21 10:06	JD	JD261218P00026000	put	26.0000	2026-12-18	1.3000	1.2700	1.3000	26.8200	10400.00	10400.00	0.00	80	16	151	5863	0.0257547330718062	0.347708499878498	0.347708499878498	false	false	false	true
3c99985e-3815-40bc-b35c-275fda7aebf7	2026-09-21 10:06	2026-09-21 10:06	2026-09-21 10:06	JD	JD261002C00027500	call	27.5000	2026-10-02	0.3300	0.3200	0.3700	26.8000	21879.00	825.00	21054.00	663	10	694	52	13.3461538461538	0.319564098159221	0.322563371801742	false	false	false	true
653a87c8-05d9-4f26-b481-df25d378327e	2026-09-18 15:57	2026-09-18 15:56	2026-09-18 15:56	JD	JD261002C00024000	call	24.0000	2026-10-02	2.9700	2.9700	3.4000	26.0000	29700.00	0.00	29700.00	100	9	626	2	313	0.340859405908215	0.340859405908215	true	false	false	true
cd930896-37e9-4e4c-91e2-70cd696c95a5	2026-09-18 15:54	2026-09-18 15:54	2026-09-18 15:54	JD	JD261002C00025000	call	25.0000	2026-10-02	2.0900	1.9800	2.0900	26.0000	22154.00	22154.00	0.00	106	13	463	38	12.1842105263158	0.35935140380019	0.35935140380019	false	false	false	true
a428ab0a-6325-4953-b8a1-47e31e3e36a1	2026-09-18 15:49	2026-09-18 15:49	2026-09-18 15:49	JD	JD260918C00024000	call	24.0000	2026-09-18	2.8900	2.8800	3.0000	26.8950	43580.00	0.00	43580.00	151	18	1048	1284	0.81619937694704	19.3790145744192	19.3937808785407	false	false	false	true
92c8a1b1-76c6-47e7-9723-c37514799de6	2026-09-18 15:49	2026-09-18 15:49	2026-09-18 15:49	JD	JD260918C00024000	call	24.0000	2026-09-18	2.8800	2.8800	3.0000	26.8950	29952.00	0.00	29952.00	104	14	1157	1284	0.901090342679128	19.3937808785407	19.3937808785407	false	false	false	true
68541f88-e744-4f6c-9165-ddae901f2839	2026-09-18 11:22	2026-09-18 11:22	2026-09-18 11:22	JD	JD270319P00025000	put	25.0000	2027-03-19	1.4700	1.4700	1.5100	26.9600	11172.00	0.00	11172.00	76	6	279	1737	0.160621761658031	0.350019994948074	0.350019994948074	false	false	false	true
93f0945e-de56-4b52-82c3-a77e5635161b	2026-09-18 11:22	2026-09-18 11:22	2026-09-18 11:22	JD	JD270319P00025000	put	25.0000	2027-03-19	1.4800	1.4700	1.5100	26.9600	14504.00	444.00	14060.00	98	6	198	1737	0.113989637305699	0.351525059865211	0.351525059865211	false	false	false	true
6a8bb4b1-543e-4bcc-ac8e-976f82ed9314	2026-09-18 10:10	2026-09-18 10:10	2026-09-18 10:10	JD	JD260925C00028000	call	28.0000	2026-09-25	0.1400	0.1300	0.1400	26.9650	11382.00	11382.00	0.00	813	6	2667	6787	0.392957123913364	0.321823818639758	0.321823818639758	false	false	false	true
a0b2031d-f9fa-449f-9f70-cce4294506ae	2026-09-17 15:46	2026-09-17 15:46	2026-09-17 15:46	JD	JD261218C00033000	call	33.0000	2026-12-18	0.4700	0.4400	0.4700	26.6450	17719.00	17719.00	0.00	377	37	437	23467	0.0186218945753611	0.396916394400374	0.396916394400374	false	false	false	true
c993d83e-be9d-4769-b733-e6283ea8b1e5	2026-09-17 14:34	2026-09-17 14:34	2026-09-17 14:34	JD	JD261016C00028000	call	28.0000	2026-10-16	0.5000	0.4700	0.5300	26.7100	15000.00	0.00	0.00	300	8	514	940	0.546808510638298	0.321453432628088	0.321453432628088	false	false	false	true
aa678888-2dce-4a18-b041-30bc70365bac	2026-09-17 13:32	2026-09-17 13:31	2026-09-17 13:31	JD	JD261218P00028000	put	28.0000	2026-12-18	2.3600	2.3600	2.4700	26.8150	26432.00	0.00	26432.00	112	24	120	3889	0.0308562612496786	0.345385504520288	0.345385504520288	false	false	false	true
b22c2ef3-85b5-426a-9c79-1278fa0d0a6f	2026-09-17 12:39	2026-09-17 12:39	2026-09-17 12:39	JD	JD270115C00035000	call	35.0000	2027-01-15	0.4300	0.4100	0.4400	26.8500	15179.00	15179.00	0.00	353	10	373	15482	0.0240924945097533	0.386074452873035	0.386074452873035	false	false	false	true
a8ac5f4e-34c4-475f-bf3b-20ca1c3c246c	2026-09-17 11:36	2026-09-17 11:36	2026-09-17 11:36	JD	JD261218C00036000	call	36.0000	2026-12-18	0.2600	0.2300	0.2600	26.7950	15808.00	15808.00	0.00	608	32	611	5115	0.119452590420332	0.417765473224014	0.417765473224014	false	false	false	true
52519760-2f1c-46a8-846c-fea7010b5172	2026-09-16 14:22	2026-09-16 14:22	2026-09-16 14:22	JD	JD261218P00027000	put	27.0000	2026-12-18	1.7300	1.7200	1.7300	26.9400	16262.00	16262.00	0.00	94	5	689	5218	0.132042928325029	0.341235194489386	0.341235194489386	false	false	false	true
f7854f98-c74a-4c03-90a8-bf4ffafdc855	2026-09-16 14:21	2026-09-16 14:21	2026-09-16 14:21	JD	JD261218P00026000	put	26.0000	2026-12-18	1.2500	1.2200	1.2500	26.9450	18750.00	18750.00	0.00	150	15	162	5833	0.0277730156008915	0.338925273348592	0.338925273348592	false	false	false	true
ca618d0b-f6c1-4858-bd9f-34f69a31eaf6	2026-09-16 14:21	2026-09-16 14:21	2026-09-16 14:21	JD	JD261218P00025000	put	25.0000	2026-12-18	0.8800	0.8600	0.8800	26.9450	11704.00	11704.00	0.00	133	17	175	14556	0.0120225336630943	0.340783081898569	0.340783081898569	false	false	false	true
d6a14861-b713-49ef-91d0-462cfe49e842	2026-09-16 13:26	2026-09-16 13:26	2026-09-16 13:26	JD	JD270319C00028000	call	28.0000	2027-03-19	2.4300	2.4300	2.5100	26.9400	23571.00	0.00	23571.00	97	7	1417	1292	1.09674922600619	0.344970710175639	0.344970710175639	false	false	false	true
a81c8110-4b82-40a3-a8b2-ad37d711f199	2026-09-16 12:35	2026-09-16 12:34	2026-09-16 12:34	JD	JD270617C00035000	call	35.0000	2027-06-17	1.1700	1.1700	1.2400	26.9450	17550.00	0.00	17550.00	150	5	159	5815	0.0273430782459157	0.347974543771077	0.347974543771077	false	false	false	true
ec09c27b-675d-475d-b5de-6e2783dc7492	2026-09-16 12:33	2026-09-16 12:33	2026-09-16 12:33	JD	JD270115P00027000	put	27.0000	2027-01-15	1.9300	1.9300	1.9900	26.9300	45162.00	0.00	45162.00	234	19	286	10701	0.0267264741612933	0.338173097626594	0.338173097626594	false	false	false	true
1f17182f-9c18-4a14-8473-ca1a95ff5334	2026-09-16 12:25	2026-09-16 12:25	2026-09-16 12:25	JD	JD270319P00028000	put	28.0000	2027-03-19	2.9100	2.9000	2.9900	26.9250	51480.00	14650.00	36830.00	177	12	946	362	2.61325966850829	0.350967808438117	0.347028182074749	false	false	false	true
1a8f79fa-61a7-42a4-a483-e517a351febf	2026-09-16 12:24	2026-09-16 12:24	2026-09-16 12:24	JD	JD270319P00028000	put	28.0000	2027-03-19	2.9200	2.9200	2.9900	26.9150	50517.00	293.00	50224.00	173	11	429	362	1.18508287292818	0.350340079681355	0.349026463457161	false	false	false	true
e33d28b8-db3f-4f74-86a3-67d65b8cb3b4	2026-09-16 12:23	2026-09-16 12:23	2026-09-16 12:23	JD	JD270319P00028000	put	28.0000	2027-03-19	2.9200	2.9200	2.9900	26.9150	21025.00	293.00	20732.00	72	15	256	362	0.707182320441989	0.349026463457161	0.349026463457161	false	false	false	true
5a92637b-a606-492d-acb0-9a19d09e6ba2	2026-09-16 12:23	2026-09-16 12:23	2026-09-16 12:23	JD	JD270319P00028000	put	28.0000	2027-03-19	2.9200	2.9200	2.9900	26.9150	31828.00	0.00	31828.00	109	27	184	362	0.50828729281768	0.349026463457161	0.349026463457161	false	false	false	true
58f9a01e-78b9-46b9-97be-9439c67415d8	2026-09-16 12:23	2026-09-16 12:23	2026-09-16 12:23	JD	JD270319C00028000	call	28.0000	2027-03-19	2.4600	2.4600	2.5300	26.9150	44282.00	248.00	44034.00	180	22	255	1292	0.197368421052632	0.353250551787323	0.350623139706033	false	false	false	true
bcfaddda-7d99-462d-baf4-e435b7615fd1	2026-09-16 10:28	2026-09-16 10:28	2026-09-16 10:28	JD	JD261218P00023000	put	23.0000	2026-12-18	0.4300	0.4300	0.5000	26.0000	12169.00	0.00	12169.00	283	16	1080	13976	0.0772753291356611	0.357706482371786	0.357946616327726	false	false	false	true
9349cc84-dfee-4ebd-8e97-cd557742938e	2026-09-16 10:26	2026-09-16 10:26	2026-09-16 10:26	JD	JD270617P00025000	put	25.0000	2027-06-17	2.3400	2.3400	2.4100	26.0000	21999.00	705.00	21294.00	94	6	795	9766	0.0814048740528364	0.401978771141295	0.400773044362479	false	false	false	true
33d214b5-cfc4-4657-b051-4a6e5b5b2dda	2026-09-16 10:26	2026-09-16 10:26	2026-09-16 10:26	JD	JD270617P00025000	put	25.0000	2027-06-17	2.3400	2.3200	2.4000	26.0000	43758.00	0.00	38844.00	187	12	701	9766	0.0717796436616834	0.400769217919841	0.400769217919841	false	false	false	true
d84b5878-fd71-4053-9636-a233c4383e0b	2026-09-16 10:26	2026-09-16 10:26	2026-09-16 10:26	JD	JD270617P00025000	put	25.0000	2027-06-17	2.3400	2.3300	2.4300	26.0000	24553.00	2574.00	21745.00	105	21	424	9766	0.0434159328281794	0.400581675913026	0.399375776550637	true	false	false	true
c8c73119-c508-4287-b9d8-093afc711bc4	2026-09-16 10:26	2026-09-16 10:26	2026-09-16 10:26	JD	JD270617P00025000	put	25.0000	2027-06-17	2.3400	2.3300	2.4300	26.0000	10278.00	0.00	10278.00	44	11	473	9766	0.0484333401597379	0.400769217919841	0.400769217919841	false	false	false	true
b47937e3-d499-4fb8-aa08-0c877117e73f	2026-09-16 10:26	2026-09-16 10:26	2026-09-16 10:26	JD	JD270617P00025000	put	25.0000	2027-06-17	2.3200	2.3200	2.4300	26.0000	20880.00	0.00	20880.00	90	6	218	9766	0.0223223428220356	0.398552102734694	0.398552102734694	false	false	false	true
16e54371-d272-4f61-9ec1-b33acc3677e6	2026-09-16 10:07	2026-09-16 10:07	2026-09-16 10:07	JD	JD261030C00025000	call	25.0000	2026-10-30	2.4300	2.3100	2.4600	26.8050	24334.00	24334.00	0.00	100	5	100	4	25	0.355413931463697	0.331566812170456	false	false	false	true