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 = DIA×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	expirydate	price

cce8122a-dd83-43d5-b52a-cdf500882314	2026-08-17 09:30	2026-08-17 09:30	2026-08-17 09:30	DIA	DIA260821C00540000	call	540.0000	2026-08-21	0.8600	0.7000	0.8600	535.5400	17166.00	17166.00	0.00	200	9	202	1732	0.11662817551963	0.107249382193959	0.107249382193959	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	45734349245.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f2d340f2-8b0c-4e2a-bd00-0764f83b3122	2026-08-17 09:32	2026-08-17 09:32	2026-08-17 09:32	DIA	DIA260821P00534000	put	534.0000	2026-08-21	1.9000	1.7600	1.9500	535.2800	190000.00	62700.00	127300.00	1000	10	1014	1105	0.917647058823529	0.117137261139593	0.115648051324333	false	false	false	true	false
ef443585-5cd5-448d-a9bf-377fc6d0c3a0	2026-08-17 09:49	2026-08-17 09:49	2026-08-17 09:49	DIA	DIA260828C00545000	call	545.0000	2026-08-28	1.0400	0.9700	1.0400	535.8200	32136.00	32136.00	0.00	309	34	445	1141	0.390008764241893	0.10478198792	0.10478198792	false	false	false	true	false
6b1b1820-6592-444f-b343-0071c221db79	2026-08-17 09:52	2026-08-17 09:52	2026-08-17 09:52	DIA	DIA260828P00539000	put	539.0000	2026-08-28	6.1000	5.9500	6.1000	535.2700	10370.00	10370.00	0.00	17	5	23	125	0.184	0.117463225238713	0.117463225238713	false	false	false	true	false
83017952-48aa-4156-901f-9b524fbc3108	2026-08-17 10:06	2026-08-17 10:06	2026-08-17 10:06	DIA	DIA260904C00553000	call	553.0000	2026-09-04	0.6800	0.6200	0.6800	535.4300	15368.00	15368.00	0.00	226	33	241	21	11.4761904761905	0.110070884263986	0.110070884263986	false	false	false	true	false
35a660a1-92cf-4d0c-883c-576744dcd0d1	2026-08-17 10:38	2026-08-17 10:37	2026-08-17 10:37	DIA	DIA260821P00530000	put	530.0000	2026-08-21	0.8300	0.8200	0.8900	534.6800	16932.00	2158.00	14774.00	204	29	391	1672	0.233851674641148	0.115650245775991	0.115650245775991	false	false	false	true	false
2c1844e5-4c74-465a-8644-668a323a84ae	2026-08-17 10:38	2026-08-17 10:37	2026-08-17 10:37	DIA	DIA260821P00531000	put	531.0000	2026-08-21	1.0500	1.0400	1.1200	534.6800	18379.00	1159.00	17220.00	175	15	234	557	0.420107719928187	0.114056105327836	0.114056105327836	false	false	false	true	false
d7bd7e62-111d-4d82-a911-359f2b7cd8a1	2026-08-17 10:39	2026-08-17 10:39	2026-08-17 10:39	DIA	DIA260918C00540000	call	540.0000	2026-09-18	5.4700	5.3000	5.5500	534.5600	27350.00	27350.00	0.00	50	5	117	383	0.305483028720627	0.11273687215961	0.11273687215961	false	false	false	true	false
1ffe4f08-1511-45af-8adf-7740b886cdfa	2026-08-17 10:49	2026-08-17 10:49	2026-08-17 10:49	DIA	DIA260918C00538000	call	538.0000	2026-09-18	6.4800	6.4000	6.5500	534.8300	16200.00	16200.00	0.00	25	6	53	71	0.746478873239437	0.112986168046519	0.112986168046519	false	false	false	true	false
7c3f519e-1445-4ae1-85c3-e5032b342628	2026-08-17 10:55	2026-08-17 10:55	2026-08-17 10:55	DIA	DIA260918C00538000	call	538.0000	2026-09-18	6.2000	6.2000	6.4500	534.5300	31010.00	0.00	31010.00	50	11	103	71	1.45070422535211	0.112379577369503	0.110790963880693	false	false	false	true	false
dc0c319a-1b3a-4f98-b1b7-f38731def962	2026-08-17 11:05	2026-08-17 11:05	2026-08-17 11:05	DIA	DIA260821C00535000	call	535.0000	2026-08-21	2.0400	2.0100	2.0800	534.4500	196656.00	196452.00	204.00	964	12	1228	1537	0.798959011060507	0.0985365039212773	0.0985365039212773	false	false	false	true	false
56ed5d95-1b7e-444e-a866-e74d931a1504	2026-08-17 11:09	2026-08-17 11:09	2026-08-17 11:09	DIA	DIA260918C00538000	call	538.0000	2026-09-18	6.4400	6.3000	6.5000	534.7200	32200.00	32200.00	0.00	50	5	253	71	3.56338028169014	0.113180227574593	0.113180227574593	false	false	false	true	false
d23787cf-76d7-4e16-abfc-976c922eb3bf	2026-08-17 11:16	2026-08-17 11:16	2026-08-17 11:16	DIA	DIA260918C00538000	call	538.0000	2026-09-18	6.5300	6.3500	6.6000	534.9200	32650.00	32650.00	0.00	50	5	303	71	4.26760563380282	0.113098156433572	0.113098156433572	false	false	false	true	false
dbcd0416-2514-4aa6-ad2b-84c8f5349c54	2026-08-17 11:34	2026-08-17 11:34	2026-08-17 11:34	DIA	DIA261016P00450000	put	450.0000	2026-10-16	0.7300	0.7300	0.8000	534.6801	14607.00	0.00	12417.00	200	14	350	377	0.928381962864722	0.247215482415184	0.247833213712498	false	false	false	true	false
7c582f7d-8b15-423b-8448-2f49ae34a8b9	2026-08-17 11:54	2026-08-17 11:54	2026-08-17 11:54	DIA	DIA260821C00535000	call	535.0000	2026-08-21	2.2000	2.1500	2.2000	534.7877	278740.00	278740.00	0.00	1267	19	2635	1537	1.71437865972674	0.0982829880672236	0.0982829880672236	false	false	false	true	false
72b44b78-9510-4006-8dce-680b7abc9f9c	2026-08-17 11:58	2026-08-17 11:58	2026-08-17 11:58	DIA	DIA260918C00538000	call	538.0000	2026-09-18	6.3300	6.2500	6.4500	534.6200	63300.00	0.00	63300.00	100	5	409	71	5.76056338028169	0.112184091338387	0.112184091338387	false	false	false	true	false
bb214a29-e73e-4164-900e-b08002de8db7	2026-08-17 12:03	2026-08-17 12:03	2026-08-17 12:03	DIA	DIA260918C00538000	call	538.0000	2026-09-18	6.5500	6.3500	6.6000	534.8391	32750.00	32750.00	0.00	50	7	459	71	6.46478873239437	0.114027394353104	0.114027394353104	false	false	false	true	false
1c1962e0-c766-4614-9043-d58177c52227	2026-08-17 12:13	2026-08-17 12:13	2026-08-17 12:13	DIA	DIA260821P00535000	put	535.0000	2026-08-21	2.1400	2.1400	2.2000	535.4200	27392.00	0.00	27392.00	128	19	744	3560	0.208988764044944	0.107776802877116	0.109529353123777	false	false	false	true	false
a0e76ff0-6da4-42ae-9eef-4123a80c46ea	2026-08-17 12:21	2026-08-17 12:21	2026-08-17 12:21	DIA	DIA260918P00534000	put	534.0000	2026-09-18	6.6500	6.6500	6.7500	535.6000	55195.00	0.00	55195.00	83	17	98	41	2.39024390243902	0.129403239822402	0.130505027839935	false	false	false	true	false
50a625ea-413e-4809-a9e2-84e2e9b90a4d	2026-08-17 12:21	2026-08-17 12:21	2026-08-17 12:21	DIA	DIA260918P00533000	put	533.0000	2026-09-18	6.2500	6.2500	6.3500	535.4400	14375.00	0.00	14375.00	23	9	158	55	2.87272727272727	0.129953125731127	0.129953125731127	false	false	false	true	false
4d502a2e-b348-48c0-a322-cb7d3f9920ed	2026-08-17 12:44	2026-08-17 12:44	2026-08-17 12:44	DIA	DIA270319P00525000	put	525.0000	2027-03-19	17.6000	17.3500	19.1500	535.0900	220000.00	214720.00	5280.00	125	35	127	653	0.194486983154671	0.170541775297576	0.170541775297576	false	false	false	true	false
068331a6-42d0-4c70-8f44-d24f87cb5d41	2026-08-17 12:46	2026-08-17 12:46	2026-08-17 12:46	DIA	DIA260828C00543000	call	543.0000	2026-08-28	1.2100	1.1500	1.2100	535.0200	12826.00	12826.00	0.00	106	18	115	44	2.61363636363636	0.102177252913185	0.102177252913185	false	false	false	true	false
534ae3d5-f05b-49c5-b372-5268d24981f2	2026-08-17 12:57	2026-08-17 12:57	2026-08-17 12:57	DIA	DIA260918C00558000	call	558.0000	2026-09-18	0.9600	0.9100	1.0500	534.5950	11136.00	192.00	10944.00	116	29	116	14	8.28571428571429	0.109679016605131	0.109679016605131	true	false	false	true	false
65937abd-526b-424c-b834-280490d9f990	2026-08-17 13:25	2026-08-17 13:25	2026-08-17 13:25	DIA	DIA261218P00538000	put	538.0000	2026-12-18	17.6500	17.4000	17.6500	534.2800	24710.00	24710.00	0.00	14	8	16	34	0.470588235294118	0.156989294610988	0.156528063212155	false	false	false	true	false
83b00df2-64e1-4166-90da-5308a2368609	2026-08-17 13:36	2026-08-17 13:36	2026-08-17 13:36	DIA	DIA270115P00540000	put	540.0000	2027-01-15	20.4500	19.5000	21.8000	533.7200	38855.00	16360.00	22495.00	19	5	20	169	0.118343195266272	0.158622607060056	0.158622607060056	false	false	false	true	false
b04a48f6-77b0-4889-8106-d3e9d80bdbec	2026-08-17 14:16	2026-08-17 14:16	2026-08-17 14:16	DIA	DIA260828C00545000	call	545.0000	2026-08-28	0.7200	0.6500	0.7200	534.2700	13392.00	13392.00	0.00	186	26	705	1141	0.617879053461876	0.102425122047246	0.102425122047246	false	false	false	true	false
04a06c1f-7179-44d5-a084-d6107302aa58	2026-08-17 14:38	2026-08-17 14:37	2026-08-17 14:37	DIA	DIA260828C00542000	call	542.0000	2026-08-28	1.2900	1.2100	1.2900	534.2950	43086.00	43086.00	0.00	334	32	343	204	1.68137254901961	0.102990962229802	0.102990962229802	false	false	false	true	false
f62f5c19-37ca-43ba-aac7-b294aadbc412	2026-08-17 15:17	2026-08-17 15:17	2026-08-17 15:17	DIA	DIA261218C00550000	call	550.0000	2026-12-18	12.5500	12.5500	12.7500	534.5700	22590.00	0.00	22590.00	18	5	23	846	0.0271867612293144	0.130741238593943	0.130741238593943	false	false	false	true	false
363e7337-c7c5-4828-8bf4-aa373b7f10ef	2026-08-17 15:18	2026-08-17 15:18	2026-08-17 15:18	DIA	DIA261016C00550000	call	550.0000	2026-10-16	5.5000	5.3500	5.5000	534.6300	110000.00	110000.00	0.00	200	13	252	5085	0.0495575221238938	0.118910458778116	0.118910458778116	false	false	false	true	false
08f7bcfc-9894-4e49-b0a2-2d14f392d69d	2026-08-17 15:32	2026-08-17 15:32	2026-08-17 15:32	DIA	DIA261016C00550000	call	550.0000	2026-10-16	5.4000	5.4000	5.5500	534.0500	26460.00	0.00	26460.00	49	5	588	5085	0.115634218289086	0.120069346289655	0.120069346289655	false	false	false	true	false
3f8c9f8e-19fc-406f-af02-535cb1a8a4b8	2026-08-17 15:33	2026-08-17 15:32	2026-08-17 15:32	DIA	DIA260821P00534000	put	534.0000	2026-08-21	2.4900	2.3900	2.5200	533.9900	18414.00	16424.00	1990.00	74	14	2607	1105	2.35927601809955	0.116363143892125	0.116363143892125	false	false	false	true	false
0bd1a40f-c997-4e5c-990a-b97c523de85e	2026-08-17 15:34	2026-08-17 15:33	2026-08-17 15:33	DIA	DIA260821P00534000	put	534.0000	2026-08-21	2.4300	2.4300	2.4900	534.0300	36207.00	0.00	36207.00	149	21	2830	1105	2.56108597285068	0.114321515466705	0.114537949723444	false	false	false	true	false
b2a77106-77a6-4f19-835a-09ec311e81f7	2026-08-17 15:42	2026-08-17 15:42	2026-08-17 15:42	DIA	DIA260918C00537000	call	537.0000	2026-09-18	6.6500	6.5500	6.8500	533.9700	66500.00	0.00	66500.00	100	6	202	41	4.92682926829268	0.114859518296617	0.114859518296617	false	false	false	true	false
c60648f6-e0da-4858-bf80-4972b387a3be	2026-08-18 09:30	2026-08-18 09:30	2026-08-18 09:30	DIA	DIA260821P00530000	put	530.0000	2026-08-21	1.6900	1.5400	1.7600	532.4100	16930.00	16930.00	0.00	100	11	116	1883	0.0616038236856081	0.14916226646969	0.144712343099406	false	false	false	true	false
59ec7d7d-26b9-41a9-b106-6f5d113f5941	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	DIA	DIA260918P00539000	put	539.0000	2026-09-18	10.3500	10.3500	10.5000	533.0000	25875.00	0.00	25875.00	25	9	34	768	0.0442708333333333	0.134068715195068	0.134068715195068	false	false	false	true	false
f14f4e5c-c844-45d6-b8c0-34f74dc0e759	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	DIA	DIA260918C00565000	call	565.0000	2026-09-18	0.3800	0.3700	0.4300	533.0000	35378.00	0.00	35378.00	931	33	1127	1694	0.665289256198347	0.112251073202239	0.112251073202239	false	false	false	true	false
f3943a50-37d5-499c-a7b7-14bab986ee49	2026-08-18 10:07	2026-08-18 10:07	2026-08-18 10:07	DIA	DIA260904C00536000	call	536.0000	2026-09-04	4.7500	4.6500	4.8000	533.6900	11400.00	11400.00	0.00	24	5	25	49	0.510204081632653	0.117481946346681	0.117481946346681	false	false	false	true	false
5f76da64-5d16-4eff-bb70-d02aa1771e3b	2026-08-18 10:17	2026-08-18 10:17	2026-08-18 10:17	DIA	DIA260918C00545000	call	545.0000	2026-09-18	3.3000	3.3000	3.5000	533.7400	251136.00	0.00	251136.00	761	57	762	5575	0.136681614349776	0.112681726361063	0.112681726361063	false	false	false	true	false
d379d071-f807-486d-ab8f-56fa127a20de	2026-08-18 10:24	2026-08-18 10:24	2026-08-18 10:24	DIA	DIA260918P00537000	put	537.0000	2026-09-18	9.1500	9.1000	9.3500	533.5300	12810.00	915.00	11895.00	14	6	15	25	0.6	0.132206407772012	0.132886979384706	true	false	false	true	false
b0a69dfb-05fd-40a1-8451-ef71a9147194	2026-08-18 10:38	2026-08-18 10:38	2026-08-18 10:38	DIA	DIA260918C00545000	call	545.0000	2026-09-18	3.2000	3.1500	3.3500	533.7200	474560.00	320.00	474240.00	1483	31	2281	5575	0.40914798206278	0.110942560613467	0.110942560613467	false	false	false	true	false
12c2182a-01a1-4c56-a122-4e857046cddd	2026-08-18 10:39	2026-08-18 10:39	2026-08-18 10:39	DIA	DIA260904C00536000	call	536.0000	2026-09-04	4.6900	4.5500	4.7500	533.8000	11725.00	11725.00	0.00	25	5	50	49	1.02040816326531	0.115051827733068	0.115051827733068	false	false	false	true	false
ee11dc1a-0d1f-46b9-accc-7903d546c49d	2026-08-18 10:58	2026-08-18 10:58	2026-08-18 10:58	DIA	DIA260821P00528000	put	528.0000	2026-08-21	0.8000	0.7600	0.8000	533.6600	135840.00	135840.00	0.00	1698	36	1811	547	3.31078610603291	0.145852771129822	0.145852771129822	true	false	false	true	false
2c9ad895-5c5f-43d1-a16f-65392b7ec05e	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	DIA	DIA260821C00535000	call	535.0000	2026-08-21	1.7300	1.6600	1.7300	533.6500	18165.00	18165.00	0.00	105	5	219	3631	0.060313963095566	0.117627045517426	0.117627045517426	false	false	false	true	false
82cd656c-9c8a-4eb5-9504-7c550f8a2d8c	2026-08-18 11:03	2026-08-18 11:03	2026-08-18 11:03	DIA	DIA260904P00535000	put	535.0000	2026-09-04	6.0000	5.8000	6.0000	533.6000	21000.00	21000.00	0.00	35	7	39	556	0.0701438848920863	0.125521135268281	0.125521135268281	false	false	false	true	false
f82ff846-7202-4313-bd04-597bb57929c0	2026-08-18 11:12	2026-08-18 11:12	2026-08-18 11:12	DIA	DIA260821C00540000	call	540.0000	2026-08-21	0.3500	0.3500	0.3900	533.4700	11865.00	0.00	11865.00	339	8	586	1974	0.296859169199595	0.114346800580087	0.114346800580087	false	false	false	true	false
51ad360f-a11c-4907-87e1-b19bcae82cec	2026-08-18 11:17	2026-08-18 11:17	2026-08-18 11:17	DIA	DIA260828C00533000	call	533.0000	2026-08-28	4.4000	4.3000	4.4500	533.1300	17600.00	17600.00	0.00	40	7	307	42	7.30952380952381	0.115096777370458	0.115096777370458	false	false	false	true	false
f8529397-723c-4af7-8151-edb449cde6cf	2026-08-18 11:20	2026-08-18 11:20	2026-08-18 11:20	DIA	DIA261218P00537000	put	537.0000	2026-12-18	17.7500	17.5500	17.7500	532.9200	23075.00	23075.00	0.00	13	9	13	4	3.25	0.156655897874719	0.156655897874719	false	false	false	true	false
9d16e75d-ae58-4552-87d6-a12fa3d61c5c	2026-08-18 11:20	2026-08-18 11:20	2026-08-18 11:20	DIA	DIA261218P00539000	put	539.0000	2026-12-18	18.7000	18.4500	18.7000	532.9200	20570.00	20570.00	0.00	11	8	13	13	1	0.156327859836671	0.156327859836671	false	false	false	true	false
3851c12a-797e-4628-981e-5c790d337c15	2026-08-18 11:20	2026-08-18 11:20	2026-08-18 11:20	DIA	DIA261218P00534000	put	534.0000	2026-12-18	16.4500	16.2500	16.4500	532.9200	19740.00	19740.00	0.00	12	8	12	10	1.2	0.157684332446011	0.157684332446011	false	false	false	true	false
320836e1-1453-499f-908c-c32a2f653e9f	2026-08-18 11:25	2026-08-18 11:24	2026-08-18 11:24	DIA	DIA260821C00525000	call	525.0000	2026-08-21	8.3000	8.1500	8.4500	532.7900	49800.00	0.00	0.00	60	6	164	1982	0.082744702320888	0.135488090852636	0.135488090852636	false	false	false	true	false