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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = DIA×

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

9a64e72a-3e53-4014-8b54-c7c086293862	2026-08-24 14:20	2026-08-24 14:20	2026-08-24 14:20	DIA	DIA260911C00534000	call	534.0000	2026-09-11	5.9000	5.9000	6.0000	533.4900	45430.00	0.00	45430.00	77	21	174	45	3.86666666666667	0.119637757481423	0.119637757481423	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	45734349245.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c9b3abcc-57d3-4ac2-86c2-34ba3144f50a	2026-08-24 14:20	2026-08-24 14:20	2026-08-24 14:20	DIA	DIA260925P00501000	put	501.0000	2026-09-25	1.2500	1.2400	1.3400	533.4900	12875.00	0.00	12875.00	103	28	103	4	25.75	0.173946915104708	0.173946915104708	false	false	false	true
1d206b89-72ec-42da-9944-b19873176858	2026-08-24 13:55	2026-08-24 13:55	2026-08-24 13:55	DIA	DIA260918P00500000	put	500.0000	2026-09-18	0.8600	0.8400	0.9300	532.8200	28122.00	0.00	28122.00	327	43	1260	5584	0.225644699140401	0.178954773212494	0.178954773212494	false	false	false	true
7ba5f3d6-7083-4ac3-abfb-66e7e2c6d1d8	2026-08-24 13:46	2026-08-24 13:46	2026-08-24 13:46	DIA	DIA260918P00524000	put	524.0000	2026-09-18	3.8200	3.7000	3.8500	532.6100	38229.00	38229.00	0.00	100	21	105	128	0.8203125	0.142490661016799	0.141457438425287	false	false	false	true
0a54af7a-94a3-4d7c-a50c-243b1574e42e	2026-08-24 13:24	2026-08-24 13:24	2026-08-24 13:24	DIA	DIA260918C00552000	call	552.0000	2026-09-18	1.0100	1.0100	1.0600	532.9254	135744.00	0.00	135744.00	1344	23	1374	59	23.2881355932203	0.110143791013034	0.110143791013034	false	false	false	true
66737554-910c-4b84-9b3e-2e727c3e5f62	2026-08-24 13:18	2026-08-24 13:18	2026-08-24 13:18	DIA	DIA260918P00500000	put	500.0000	2026-09-18	0.8100	0.8100	0.8600	533.5950	31593.00	0.00	31593.00	390	42	931	5584	0.166726361031519	0.180871158323901	0.179311229790827	false	false	false	true
f7e2cf99-3cf8-422b-9776-7136551b2fff	2026-08-24 13:13	2026-08-24 13:13	2026-08-24 13:13	DIA	DIA260918P00500000	put	500.0000	2026-09-18	0.8000	0.7800	0.8800	533.5800	30081.00	81.00	30000.00	376	46	541	5584	0.0968839541547278	0.178728789733725	0.179254950682768	false	false	false	true
608b42fe-a71d-4db5-9eb0-3ae822940231	2026-08-24 13:08	2026-08-24 13:08	2026-08-24 13:08	DIA	DIA260904C00536000	call	536.0000	2026-09-04	3.6500	3.5500	3.6500	533.6400	23360.00	23360.00	0.00	64	13	72	73	0.986301369863014	0.120727325642307	0.120727325642307	false	false	false	true
8041ad91-7ae0-493b-b3e1-b25e4b3a8ef6	2026-08-24 11:49	2026-08-24 11:49	2026-08-24 11:49	DIA	DIA260911P00533000	put	533.0000	2026-09-11	4.9000	4.7500	4.9500	533.6800	85750.00	70070.00	15680.00	175	5	179	17	10.5294117647059	0.120744292829406	0.120744292829406	false	false	false	true
843f2158-8363-4e94-9cb2-412d9a626e4e	2026-08-24 11:28	2026-08-24 11:28	2026-08-24 11:28	DIA	DIA260828P00519000	put	519.0000	2026-08-28	0.2300	0.2200	0.2600	533.6000	10074.00	0.00	9959.00	438	28	444	2073	0.214182344428365	0.170496304921378	0.170496304921378	false	false	false	true
92ac6ec4-88b0-47fb-a67e-a22acbcfa24f	2026-08-24 11:20	2026-08-24 11:20	2026-08-24 11:20	DIA	DIA260828C00544000	call	544.0000	2026-08-28	0.2100	0.2000	0.2200	532.8200	21315.00	0.00	9555.00	1015	11	1075	75	14.3333333333333	0.129039156885435	0.129039156885435	false	false	false	true
d5bece66-093f-4137-a0fe-f440d068e7de	2026-08-24 10:28	2026-08-24 10:28	2026-08-24 10:28	DIA	DIA260828P00517000	put	517.0000	2026-08-28	0.1900	0.1900	0.2000	533.6300	10013.00	0.00	10013.00	527	35	581	454	1.27973568281938	0.181919754727504	0.181919754727504	false	false	false	true
2b2312af-be39-4f7f-bcb2-f386a97d94cf	2026-08-24 10:23	2026-08-24 10:23	2026-08-24 10:23	DIA	DIA260828C00535000	call	535.0000	2026-08-28	2.6000	2.4900	2.6200	533.6800	62193.00	43359.00	18834.00	239	18	445	283	1.57243816254417	0.140655369504551	0.138844733239217	false	false	false	true
bcf4881a-74ad-493b-99d6-77b34065dece	2026-08-24 10:13	2026-08-24 10:13	2026-08-24 10:13	DIA	DIA270617P00240000	put	240.0000	2027-06-17	0.6800	0.2100	1.0000	533.2700	17816.00	17748.00	68.00	262	6	277	485	0.571134020618557	0.422332086309829	0.422332086309829	false	false	false	true
261fe7f8-e4c5-4e48-9208-8c9d80b82787	2026-08-24 10:03	2026-08-24 10:02	2026-08-24 10:02	DIA	DIA260828P00533000	put	533.0000	2026-08-28	2.5800	2.4600	2.5800	534.1300	36378.00	36378.00	0.00	141	7	261	949	0.275026343519494	0.144119363685882	0.144119363685882	false	false	false	true
16f8e6b9-0980-460b-a6d5-abb52b729320	2026-08-24 10:03	2026-08-24 10:02	2026-08-24 10:02	DIA	DIA260828P00532000	put	532.0000	2026-08-28	2.2200	2.1000	2.2200	534.1300	47508.00	47508.00	0.00	214	13	306	635	0.481889763779528	0.146546134662396	0.146546134662396	false	false	false	true
12fc44bc-b331-4d06-b1a8-3742e464af03	2026-08-24 10:03	2026-08-24 10:02	2026-08-24 10:02	DIA	DIA260911C00537000	call	537.0000	2026-09-11	4.6500	4.6500	4.8000	534.1300	10240.00	0.00	10240.00	22	6	25	26	0.961538461538462	0.116713184979283	0.11692607309169	false	false	false	true
a9712ec6-f649-41a4-9e99-e270c0b11bab	2026-08-24 10:01	2026-08-24 10:01	2026-08-24 10:01	DIA	DIA260904C00534000	call	534.0000	2026-09-04	5.0700	4.9500	5.1500	533.9600	10140.00	10140.00	0.00	20	5	25	80	0.3125	0.129302650863021	0.129302650863021	false	false	false	true
26871900-83ae-41f6-85d2-0c9fa76adae8	2026-08-24 09:57	2026-08-24 09:57	2026-08-24 09:57	DIA	DIA260828C00534000	call	534.0000	2026-08-28	3.2000	3.2000	3.4000	533.8600	160210.00	13650.00	146560.00	500	22	599	871	0.687715269804822	0.141683670496665	0.143926610881319	false	false	false	true
95988476-ea82-4b26-9d73-96883c1164c6	2026-08-24 09:49	2026-08-24 09:49	2026-08-24 09:49	DIA	DIA260828C00540000	call	540.0000	2026-08-28	1.0700	0.9700	1.0700	534.1450	10700.00	10700.00	0.00	100	7	407	2366	0.172020287404903	0.138540505818723	0.138540505818723	false	false	false	true
1c844cc8-4b77-40b4-b1b1-8afc8a7ba765	2026-08-24 09:46	2026-08-24 09:46	2026-08-24 09:46	DIA	DIA260918P00510000	put	510.0000	2026-09-18	1.5500	1.5400	1.6500	533.6000	298840.00	2325.00	248620.00	1928	19	1940	6934	0.279780790308624	0.166021444190104	0.166021444190104	false	false	false	true
4271468e-9aa7-4d8f-a29a-b1af90f5eb62	2026-08-24 09:42	2026-08-24 09:42	2026-08-24 09:42	DIA	DIA260828P00535000	put	535.0000	2026-08-28	3.8500	3.7500	3.9000	533.2498	38500.00	9625.00	28875.00	100	7	221	289	0.764705882352941	0.135643429797242	0.135643429797242	true	false	false	true
89a6ff03-3931-423f-9e90-300a35a95748	2026-08-24 09:38	2026-08-24 09:38	2026-08-24 09:38	DIA	DIA260828P00547000	put	547.0000	2026-08-28	14.0500	13.7500	14.0500	533.0600	15455.00	15455.00	0.00	11	5	11	0	0	0.170734217826976	0.170734217826976	false	false	false	true	false
e33c0366-595b-4db7-8d9e-a071734b170e	2026-08-24 09:34	2026-08-24 09:33	2026-08-24 09:33	DIA	DIA260828C00530000	call	530.0000	2026-08-28	5.1500	5.1000	5.1500	532.7800	13390.00	13390.00	0.00	26	11	103	404	0.254950495049505	0.155206742070911	0.155206742070911	false	false	false	true
c13389f0-db07-4f3b-9c44-4a0487a548d5	2026-08-24 09:33	2026-08-24 09:33	2026-08-24 09:33	DIA	DIA260828C00530000	call	530.0000	2026-08-28	5.2500	5.1000	5.2500	532.9200	38325.00	38325.00	0.00	73	5	75	404	0.185643564356436	0.155693867602243	0.155693867602243	false	false	false	true
f973fc31-34bc-45a0-a779-7195d860a25c	2026-08-21 15:34	2026-08-21 15:34	2026-08-21 15:34	DIA	DIA260828P00532000	put	532.0000	2026-08-28	2.9000	2.8300	2.9000	532.5100	26970.00	26970.00	0.00	93	16	635	187	3.39572192513369	0.113270086446353	0.113270086446353	false	false	false	true
e4e592e0-40e0-4936-94e0-877c4b0a6475	2026-08-21 15:34	2026-08-21 15:34	2026-08-21 15:34	DIA	DIA260828P00531000	put	531.0000	2026-08-28	2.5100	2.4500	2.5200	532.5100	53210.00	52960.00	250.00	212	33	518	514	1.00778210116732	0.114887327481802	0.114538102866979	false	false	false	true
c07fed33-063f-4f8f-b180-acd0758c2ba3	2026-08-21 15:30	2026-08-21 15:30	2026-08-21 15:30	DIA	DIA260828P00535000	put	535.0000	2026-08-28	4.2500	4.1500	4.3000	532.6600	39525.00	39525.00	0.00	93	18	155	260	0.596153846153846	0.108902885482131	0.107869335491717	false	false	false	true
d9cba9d9-ce4d-4899-addb-42019561a851	2026-08-21 15:29	2026-08-21 15:29	2026-08-21 15:29	DIA	DIA260828P00533000	put	533.0000	2026-08-28	3.2500	3.1500	3.2500	532.6100	26975.00	26975.00	0.00	83	11	514	555	0.926126126126126	0.110420762077478	0.110420762077478	false	false	false	true
80523198-1ad6-42df-9515-a7f2494711f5	2026-08-21 15:29	2026-08-21 15:29	2026-08-21 15:29	DIA	DIA260828P00532000	put	532.0000	2026-08-28	2.8200	2.7200	2.8300	532.6100	64855.00	64012.00	843.00	230	40	537	187	2.8716577540107	0.112076679414711	0.111734009525365	false	false	false	true
4c9d52ec-7762-469c-97cf-dfaf5c34f839	2026-08-21 15:29	2026-08-21 15:29	2026-08-21 15:29	DIA	DIA260828P00533000	put	533.0000	2026-08-28	3.2500	3.1500	3.3000	532.6100	11050.00	325.00	3900.00	34	7	551	555	0.992792792792793	0.110420762077478	0.110420762077478	false	false	false	true
aa09b19a-b981-4ce7-bc4c-78c8c0b2eee1	2026-08-21 15:29	2026-08-21 15:28	2026-08-21 15:28	DIA	DIA260828C00530000	call	530.0000	2026-08-28	5.0500	4.9500	5.0500	532.4400	11615.00	11615.00	0.00	23	7	362	460	0.78695652173913	0.117753058503878	0.117753058503878	true	false	false	true
160fabc1-b9d6-4b5c-bcf0-0a34c58b947b	2026-08-21 15:27	2026-08-21 15:27	2026-08-21 15:27	DIA	DIA280121P00230000	put	230.0000	2028-01-21	1.2100	0.7800	1.5200	532.3399	11694.00	9894.00	1800.00	97	7	204	133	1.53383458646617	0.373816893242098	0.374302128429939	false	false	false	true
1aa35a94-cbf3-46b6-a32b-9588ad5e39fa	2026-08-21 15:26	2026-08-21 15:26	2026-08-21 15:26	DIA	DIA260904C00532000	call	532.0000	2026-09-04	5.5500	5.5500	5.6500	532.5600	30525.00	0.00	30525.00	55	16	514	84	6.11904761904762	0.11652378107107	0.116789429653305	false	false	false	true
1090ec43-c1bd-4606-8699-2a2087efe7fb	2026-08-21 15:26	2026-08-21 15:26	2026-08-21 15:26	DIA	DIA260904C00532500	call	532.5000	2026-09-04	5.2500	5.2500	5.3500	532.5600	25735.00	0.00	25735.00	49	15	52	12	4.33333333333333	0.115691323693939	0.11594808600854	false	false	false	true
675e06c0-cb1b-44cb-b1b6-6c8e84e76f5d	2026-08-21 15:24	2026-08-21 15:24	2026-08-21 15:24	DIA	DIA260828P00533000	put	533.0000	2026-08-28	3.2000	3.1500	3.2000	532.7200	89280.00	89280.00	0.00	279	5	402	555	0.724324324324324	0.110569525983154	0.110569525983154	false	false	false	true
3afb78e8-4e71-4b82-b63b-8e157eb8c650	2026-08-21 15:21	2026-08-21 15:21	2026-08-21 15:21	DIA	DIA260828C00534000	call	534.0000	2026-08-28	2.8300	2.7800	2.8400	532.7300	43299.00	25470.00	17829.00	153	8	1006	164	6.13414634146341	0.110385276732766	0.110385276732766	true	false	false	true
46473eee-23a1-4b7d-a9a1-c1ea0a2603ef	2026-08-21 15:17	2026-08-21 15:17	2026-08-21 15:17	DIA	DIA260828P00522000	put	522.0000	2026-08-28	0.6000	0.6000	0.6300	532.6208	12120.00	0.00	12120.00	202	22	238	720	0.330555555555556	0.131445208866167	0.131445208866167	false	false	false	true
963dcdbd-565c-4c0d-8f6b-a1d2807cd5e5	2026-08-21 14:52	2026-08-21 14:52	2026-08-21 14:52	DIA	DIA260821P00532000	put	532.0000	2026-08-21	0.3200	0.2700	0.3400	531.9850	26752.00	26752.00	0.00	836	13	1657	569	2.91212653778559	0.130167561066058	0.130183428225342	false	false	false	true
a046c0da-c7af-46aa-99ea-e35cad69d35f	2026-08-21 14:38	2026-08-21 14:38	2026-08-21 14:38	DIA	DIA260828C00534000	call	534.0000	2026-08-28	2.3900	2.3000	2.4200	531.8200	84367.00	33221.00	14579.00	353	12	531	164	3.23780487804878	0.108940136396922	0.108940136396922	true	false	false	true
e40995a6-cbfe-413a-a5ff-cfeaf460463b	2026-08-21 13:47	2026-08-21 13:47	2026-08-21 13:47	DIA	DIA260828C00532000	call	532.0000	2026-08-28	3.2000	3.1000	3.2250	531.4700	14400.00	14400.00	0.00	45	5	118	75	1.57333333333333	0.11137782460769	0.11137782460769	false	false	false	true
4ad75ddd-20be-44bc-94c7-7f4db8a556ba	2026-08-21 12:53	2026-08-21 12:53	2026-08-21 12:53	DIA	DIA260918P00500000	put	500.0000	2026-09-18	1.0500	1.0400	1.1000	530.9600	27720.00	735.00	26985.00	264	10	342	5174	0.0660997294163123	0.171417587228904	0.171417587228904	false	false	false	true
570c5956-83eb-4898-84e1-ed7cac03d68a	2026-08-21 12:52	2026-08-21 12:52	2026-08-21 12:52	DIA	DIA270630C00680000	call	680.0000	2027-06-30	1.6000	1.6000	3.5500	530.9750	31840.00	0.00	15040.00	199	7	200	494	0.404858299595142	0.140000722509056	0.140000722509056	false	false	false	true
bbcce53e-f7c3-447d-9fc2-58f5e747ee7b	2026-08-21 12:02	2026-08-21 12:02	2026-08-21 12:02	DIA	DIA270115P00535000	put	535.0000	2027-01-15	18.5100	18.2000	18.6000	531.2800	12960.00	12960.00	0.00	7	7	8	1119	0.00714924039320822	0.15517272785961	0.155890075311724	false	false	false	true
3df0b5ba-45c5-4fdd-98ac-68d098097b2c	2026-08-21 12:00	2026-08-21 12:00	2026-08-21 12:00	DIA	DIA261120P00535000	put	535.0000	2026-11-20	14.6000	14.4000	14.6000	531.3900	17520.00	17520.00	0.00	12	9	16	0	0	0.145331200507499	0.145331200507499	false	false	false	true	false
aacdbec0-f094-4fa0-a9ca-9657d68ba60b	2026-08-21 11:39	2026-08-21 11:39	2026-08-21 11:39	DIA	DIA261016C00545000	call	545.0000	2026-10-16	5.4000	5.2500	5.5000	531.2500	10800.00	10800.00	0.00	20	11	24	1660	0.0144578313253012	0.116876768835622	0.116876768835622	false	false	false	true
88958237-016b-4bef-bd59-70e0a48d7775	2026-08-21 11:01	2026-08-21 11:01	2026-08-21 11:01	DIA	DIA260828P00530000	put	530.0000	2026-08-28	2.7300	2.6800	2.7300	531.1200	316134.00	316134.00	0.00	1158	20	1356	1098	1.23497267759563	0.117079833897922	0.117079833897922	false	false	false	true
cfb8da6b-170e-4214-84de-80548f270d56	2026-08-21 10:43	2026-08-21 10:43	2026-08-21 10:43	DIA	DIA261120C00530000	call	530.0000	2026-11-20	17.0000	16.9500	17.0000	530.3000	32300.00	32300.00	0.00	19	6	50	1	50	0.134521138259271	0.134521138259271	false	false	false	true
f3b09157-4620-4f62-9169-932acd9ae5eb	2026-08-21 10:36	2026-08-21 10:35	2026-08-21 10:35	DIA	DIA260911P00519000	put	519.0000	2026-09-11	2.2800	2.1600	2.3000	530.3700	20748.00	20520.00	228.00	91	23	91	25	3.64	0.135073684988599	0.135073684988599	true	false	false	true
87c334a9-6b25-4127-81da-7307a29bb5e3	2026-08-21 10:14	2026-08-21 10:14	2026-08-21 10:14	DIA	DIA260904C00535000	call	535.0000	2026-09-04	3.2500	3.1500	3.3500	530.7500	64020.00	49720.00	14300.00	197	22	200	305	0.655737704918033	0.11524756314143	0.11505188136767	false	false	false	true