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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×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	expiry

1df5ca38-cab4-48f3-8e54-ac5adcaf6177	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	DIA	DIA270115C00540000	call	540.0000	2027-01-15	12.9200	12.5500	13.0000	526.0300	12918.00	12918.00	0.00	10	5	15	2688	0.00558035714285714	0.131267018870335	0.131267018870335	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	45539393146.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-11T13:30:31.573730Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d5dad627-a266-4919-8ca3-71e5d832d7e3	2026-09-10 09:42	2026-09-10 09:42	2026-09-10 09:42	DIA	DIA260911C00525000	call	525.0000	2026-09-11	1.2200	1.1600	1.2600	522.3000	12238.00	5750.00	6488.00	100	14	464	1362	0.340675477239354	0.208794027222336	0.209811208424025	false	false	false	true
3db669fa-2d49-4684-8624-cea82ba64617	2026-09-10 09:38	2026-09-10 09:38	2026-09-10 09:38	DIA	DIA260911C00525000	call	525.0000	2026-09-11	1.2000	1.1400	1.2500	522.2600	16614.00	5395.00	11219.00	139	9	311	1362	0.228340675477239	0.20806942931091	0.209090735021103	false	false	false	true
d1aa1322-7725-4fc1-a2f6-6000d6213b88	2026-09-09 14:59	2026-09-09 14:59	2026-09-09 14:59	DIA	DIA260911C00530000	call	530.0000	2026-09-11	0.5600	0.5500	0.5800	524.6500	26079.00	9462.00	14907.00	467	16	2049	1079	1.89898053753475	0.145786997599401	0.147738667636058	false	false	false	true
082966a7-69ca-442d-b7b9-b9445abff8ae	2026-09-09 11:19	2026-09-09 11:19	2026-09-09 11:19	DIA	DIA261016C00515000	call	515.0000	2026-10-16	15.2300	15.0500	15.2500	523.6300	10658.00	9138.00	1520.00	7	5	113	71	1.59154929577465	0.134659573589406	0.135170849931481	false	false	false	true
24912ed4-df9c-4923-80eb-68901b49218f	2026-09-09 10:11	2026-09-09 10:11	2026-09-09 10:11	DIA	DIA261016C00520000	call	520.0000	2026-10-16	11.8100	11.7500	11.9000	523.8700	10627.00	1181.00	9446.00	9	7	25	431	0.0580046403712297	0.128631265340737	0.128788379300698	false	false	false	true
22b3c585-01eb-4f10-ba62-66e21d02ef87	2026-09-09 09:52	2026-09-09 09:52	2026-09-09 09:52	DIA	DIA260911C00530000	call	530.0000	2026-09-11	0.6000	0.5900	0.6200	523.9600	12476.00	4514.00	5583.00	207	12	666	1079	0.617238183503244	0.161883477359842	0.163870401698996	false	false	false	true
75c04836-a68b-4b66-9cbf-8a4b4f091397	2026-09-08 11:09	2026-09-08 11:09	2026-09-08 11:09	DIA	DIA261016P00529000	put	529.0000	2026-10-16	8.2800	8.1000	8.3500	528.9000	34763.00	34763.00	0.00	42	5	73	33	2.21212121212121	0.136079561759295	0.136079561759295	false	false	false	true
0c12010c-2ec9-42e3-b792-f0d4c9009200	2026-09-08 10:27	2026-09-08 10:27	2026-09-08 10:27	DIA	DIA261120C00528000	call	528.0000	2026-11-20	14.2100	13.9500	14.4000	527.6500	28418.00	24167.00	4251.00	20	10	20	12	1.66666666666667	0.130038390050784	0.130038390050784	false	false	false	true
c31d0397-407b-4fe5-ac4c-b627b373e3e1	2026-09-04 11:45	2026-09-04 11:45	2026-09-04 11:45	DIA	DIA260904C00534000	call	534.0000	2026-09-04	0.5000	0.4400	0.5000	533.7000	26415.00	24829.00	1537.00	532	43	4682	1615	2.89907120743034	0.133194991369919	0.135364696659935	false	false	false	true
277ed4a5-ebd1-4ab7-96f5-476607738532	2026-09-03 15:25	2026-09-03 15:25	2026-09-03 15:25	DIA	DIA260904P00534000	put	534.0000	2026-09-04	0.4900	0.4500	0.4900	536.6200	10990.00	10990.00	0.00	225	8	1556	362	4.29834254143646	0.12874592989645	0.129920880678959	false	false	false	true
69b5cb5d-35b1-4264-a9a2-f2dac87b1c2f	2026-09-03 13:07	2026-09-03 13:06	2026-09-03 13:06	DIA	DIA261016C00562000	call	562.0000	2026-10-16	1.4800	1.4700	1.5900	536.5850	14773.00	0.00	14028.00	100	20	200	516	0.387596899224806	0.111889143197834	0.112130524402223	false	false	false	true
5c5f9d86-5198-4ccb-8c54-688217be2329	2026-09-03 11:59	2026-09-03 11:58	2026-09-03 11:58	DIA	DIA261016C00562000	call	562.0000	2026-10-16	1.6000	1.5400	1.6900	537.2200	16006.00	0.00	16006.00	100	8	100	516	0.193798449612403	0.111365558609739	0.112765174886466	false	false	false	true
ff9c76c9-55a1-495b-8904-3b5b2bc1d84f	2026-09-03 10:02	2026-09-03 10:02	2026-09-03 10:02	DIA	DIA260930P00525000	put	525.0000	2026-09-30	3.4500	3.0500	3.6500	534.0000	168034.00	345.00	167689.00	487	44	488	150	3.25333333333333	0.131747822474273	0.131747822474273	false	false	false	true
0dadcc8f-f55a-4430-887d-62c22dc2f3bf	2026-09-03 09:41	2026-09-03 09:41	2026-09-03 09:41	DIA	DIA260918P00523000	put	523.0000	2026-09-18	1.7600	1.7600	1.8700	534.3600	38033.00	717.00	37316.00	216	39	216	94	2.29787234042553	0.139849233650292	0.141148152946112	false	false	false	true
dfa3bd3d-5c47-4c1d-ae03-326c87fb762e	2026-09-03 09:36	2026-09-03 09:36	2026-09-03 09:36	DIA	DIA261016C00535000	call	535.0000	2026-10-16	9.7000	9.5000	9.8500	535.0300	35904.00	35904.00	0.00	37	14	37	295	0.125423728813559	0.115499806962225	0.115499806962225	false	false	false	true
9baf505e-701e-4bd5-8f37-b3c54649a91c	2026-09-02 10:49	2026-09-02 10:49	2026-09-02 10:49	DIA	DIA260904P00526000	put	526.0000	2026-09-04	0.4300	0.3800	0.4300	531.9300	17422.00	17422.00	0.00	406	6	798	202	3.95049504950495	0.145227771385356	0.14634873790983	false	false	false	true
298ddde7-fa8f-4c09-8512-7845eb0bbd70	2026-09-01 11:18	2026-09-01 11:18	2026-09-01 11:18	DIA	DIA261016P00530000	put	530.0000	2026-10-16	8.6200	8.4500	8.7000	529.6642	70655.00	70655.00	0.00	82	6	139	460	0.302173913043478	0.130305584227354	0.130305584227354	false	false	false	true
e820b179-6439-45df-b0dc-8c8315a14360	2026-08-31 10:41	2026-08-31 10:41	2026-08-31 10:41	DIA	DIA260918P00525000	put	525.0000	2026-09-18	3.0500	3.0500	3.2500	531.6850	544480.00	0.00	544480.00	1785	49	1805	1905	0.94750656167979	0.131317920738842	0.131317920738842	false	false	false	true
77244140-bbbc-4cff-8d58-9d8e69d3a2f1	2026-08-31 09:47	2026-08-31 09:47	2026-08-31 09:47	DIA	DIA260911P00532000	put	532.0000	2026-09-11	3.9000	3.9000	4.1000	531.5450	44466.00	0.00	44466.00	114	19	161	85	1.89411764705882	0.108122373977571	0.108122373977571	false	false	false	true
331f1aa4-1a0f-4c5b-998a-369d3897cdcc	2026-08-28 15:05	2026-08-28 15:05	2026-08-28 15:05	DIA	DIA261218P00515000	put	515.0000	2026-12-18	8.0700	7.8500	8.1500	534.9200	40358.00	40358.00	0.00	50	9	263	1150	0.228695652173913	0.157533873488134	0.157533873488134	false	false	false	true
506ed948-486b-4153-9873-7841d465cf7d	2026-08-28 11:35	2026-08-28 11:35	2026-08-28 11:35	DIA	DIA260828C00535000	call	535.0000	2026-08-28	2.0600	1.9900	2.2400	537.0210	22452.00	8307.00	14145.00	109	28	349	1161	0.300602928509905	0.0964372739315927	0.128697968500606	true	false	false	true
aa0382c5-09ce-4f4a-982c-e1939663d56a	2026-08-28 10:51	2026-08-28 10:51	2026-08-28 10:51	DIA	DIA260904P00530000	put	530.0000	2026-09-04	0.9500	0.9100	0.9600	536.4300	31165.00	31070.00	95.00	327	14	1803	928	1.94288793103448	0.111455419650819	0.111933417021987	true	false	false	true
a4de5099-d593-42cc-9083-7378331c5cde	2026-08-28 10:51	2026-08-28 10:51	2026-08-28 10:51	DIA	DIA260904P00530000	put	530.0000	2026-09-04	0.9400	0.9000	0.9500	536.4300	21404.00	21404.00	0.00	227	8	1465	928	1.57866379310345	0.111455419650819	0.111933417021987	true	false	false	true
6f22db88-a3f1-441f-961a-6abe95d55896	2026-08-28 10:51	2026-08-28 10:51	2026-08-28 10:51	DIA	DIA260904P00530000	put	530.0000	2026-09-04	0.9400	0.8800	0.9400	536.4300	84322.00	84322.00	0.00	900	19	1231	928	1.32650862068966	0.11145694293273	0.111455419650819	true	false	false	true
cbe84d58-a176-4564-9369-68f5eb915e6c	2026-08-28 10:16	2026-08-28 10:16	2026-08-28 10:16	DIA	DIA260828C00536000	call	536.0000	2026-08-28	0.7700	0.7300	0.8200	535.5200	14994.00	4050.00	10944.00	194	11	349	1009	0.345887016848365	0.178435830226064	0.187740282343662	false	false	false	true
fa6acf42-b06a-48c4-9c35-4516d656e22c	2026-08-27 12:28	2026-08-27 12:28	2026-08-27 12:28	DIA	DIA260911P00535000	put	535.0000	2026-09-11	3.7500	3.7500	3.8500	535.8300	60069.00	0.00	60069.00	160	6	369	262	1.40839694656489	0.10478879861064	0.105256031168574	false	false	false	true
699f3201-df66-44cb-a35b-57e1aa93adf3	2026-08-27 11:56	2026-08-27 11:55	2026-08-27 11:55	DIA	DIA280121P00230000	put	230.0000	2028-01-21	1.2600	1.1500	1.8700	535.8400	14530.00	0.00	14530.00	115	7	848	351	2.41595441595442	0.380771880588701	0.381246682448335	false	false	false	true
56d8781e-b2c4-4148-afcd-7567249d0008	2026-08-27 09:37	2026-08-27 09:37	2026-08-27 09:37	DIA	DIA261016P00535000	put	535.0000	2026-10-16	9.7000	9.5000	9.8500	534.1800	92122.00	92122.00	0.00	95	5	104	270	0.385185185185185	0.135162348228767	0.135162348228767	false	false	false	true
e725b08d-ad7a-45e1-8135-ba4bfb2e141a	2026-08-27 09:35	2026-08-27 09:35	2026-08-27 09:35	DIA	DIA260911C00540000	call	540.0000	2026-09-11	2.5200	2.4700	2.6100	533.9000	39620.00	25200.00	14420.00	157	5	500	196	2.55102040816327	0.108022265584007	0.108276952494155	false	false	false	true
710e99eb-6422-4f85-9ea3-7b6761897e28	2026-08-26 14:16	2026-08-26 14:16	2026-08-26 14:16	DIA	DIA261218C00535000	call	535.0000	2026-12-18	18.9200	18.5500	18.9500	534.0500	56760.00	56760.00	0.00	30	8	30	451	0.0665188470066519	0.134968530838822	0.134968530838822	false	false	false	true
705ebb1b-5f76-4078-a0a4-c66e85631ae5	2026-08-26 12:18	2026-08-26 12:18	2026-08-26 12:18	DIA	DIA260918C00545000	call	545.0000	2026-09-18	2.2800	2.2800	2.4100	533.8700	58673.00	232.00	58441.00	257	10	357	6340	0.0563091482649842	0.110222515838616	0.111142367823761	true	false	false	true
47d988ee-bada-4f4c-bbb4-22bb3c40ffa0	2026-08-25 14:47	2026-08-25 14:47	2026-08-25 14:47	DIA	DIA261016C00545000	call	545.0000	2026-10-16	6.6400	6.5000	6.7500	535.2300	19248.00	19248.00	0.00	29	5	33	1663	0.0198436560432953	0.119140349551477	0.119140349551477	false	false	false	true
afd94c08-b210-4abf-b90c-f914711f839f	2026-08-25 12:11	2026-08-25 12:11	2026-08-25 12:11	DIA	DIA270630C00680000	call	680.0000	2027-06-30	1.4100	0.4000	3.8000	534.5200	11991.00	5016.00	6975.00	85	19	100	594	0.168350168350168	0.133478247295383	0.133855482483236	false	false	false	true
62df7306-b7d5-4335-9c25-58364ea38940	2026-08-25 10:31	2026-08-25 10:31	2026-08-25 10:31	DIA	DIA280121P00230000	put	230.0000	2028-01-21	1.9700	1.1400	2.9900	534.0351	56668.00	5356.00	51312.00	287	10	620	353	1.75637393767705	0.379288728103015	0.411661437828483	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
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
845a4952-26c0-431a-aed6-ced9af2f04fd	2026-08-20 15:28	2026-08-20 15:28	2026-08-20 15:28	DIA	DIA260828C00530000	call	530.0000	2026-08-28	2.8900	2.8200	2.9500	527.9300	22573.00	15637.00	6936.00	78	7	343	90	3.81111111111111	0.116821772934956	0.117147129691226	false	false	false	true
126b71e5-f394-410a-a717-bab3ead67f09	2026-08-20 15:10	2026-08-20 15:09	2026-08-20 15:09	DIA	DIA261120C00525000	call	525.0000	2026-11-20	18.6800	18.4500	18.7500	527.9100	37354.00	37354.00	0.00	20	8	42	0	0	0.136151551010757	0.136151551010757	false	false	false	true
37ab0095-6d54-490d-bb10-a48758064a18	2026-08-20 14:02	2026-08-20 14:02	2026-08-20 14:02	DIA	DIA270115C00530000	call	530.0000	2027-01-15	21.8600	21.3500	23.9500	528.6300	133329.00	2195.00	131134.00	61	16	61	1944	0.0313786008230453	0.132220455752225	0.136626002622307	false	false	false	true
cc3a6f05-a0d1-4cff-802e-9d3d07a5eb26	2026-08-20 14:00	2026-08-20 14:00	2026-08-20 14:00	DIA	DIA260911C00543000	call	543.0000	2026-09-11	1.2900	1.2900	1.3600	528.6400	16256.00	130.00	16126.00	126	25	140	2	70	0.105811197666413	0.105916068039412	false	false	false	true
f5f8de00-f541-4c55-81f6-93215b367461	2026-08-20 09:33	2026-08-20 09:33	2026-08-20 09:33	DIA	DIA260821C00530000	call	530.0000	2026-08-21	1.8400	1.8500	1.9400	530.4600	20646.00	372.00	20274.00	112	23	373	1471	0.25356900067981	0.141735091941167	0.143556884854368	true	false	false	true
5fa5e658-7544-430a-9834-a639716c645d	2026-08-19 12:55	2026-08-19 12:54	2026-08-19 12:54	DIA	DIA280121P00230000	put	230.0000	2028-01-21	1.4100	1.2000	1.5000	533.9350	16888.00	16888.00	0.00	120	6	120	16	7.5	0.383416754402695	0.383416754402695	false	false	false	true
bb3c3f69-bdf6-4c6f-a24c-2476bd1a9361	2026-08-19 10:45	2026-08-19 10:45	2026-08-19 10:45	DIA	DIA261218P00544000	put	544.0000	2026-12-18	19.3700	19.1000	19.4000	536.0300	11620.00	11620.00	0.00	6	6	23	9	2.55555555555556	0.153350115610779	0.153350115610779	false	false	false	true
6a4a12ac-1097-471d-b646-88ec0f2e5ad1	2026-08-19 09:59	2026-08-19 09:59	2026-08-19 09:59	DIA	DIA261016C00550000	call	550.0000	2026-10-16	5.5800	5.4000	5.6500	535.5900	55773.00	55773.00	0.00	100	6	620	5762	0.107601527247484	0.117871451558053	0.117871451558053	false	false	false	true
0a63dcd4-e28b-4c07-a01e-6b069e61dce5	2026-08-19 09:54	2026-08-19 09:54	2026-08-19 09:54	DIA	DIA261016C00550000	call	550.0000	2026-10-16	5.3300	5.2000	5.4000	534.8250	53258.00	49018.00	0.00	100	9	401	5762	0.069593891010066	0.117947769871171	0.117947769871171	false	false	false	true
0db37317-67cf-401c-b65f-5ec6e0076087	2026-08-18 16:00	2026-08-18 15:59	2026-08-18 15:59	DIA	DIA260930P00535000	put	535.0000	2026-09-30	9.8100	9.1000	10.9000	532.0000	73554.00	10780.00	62774.00	75	5	80	130	0.615384615384615	0.13554611598397	0.135348388309562	false	false	false	true
dd72073e-4fda-4d68-b0f2-a1361296d4df	2026-08-18 13:10	2026-08-18 13:10	2026-08-18 13:10	DIA	DIA260918C00536000	call	536.0000	2026-09-18	6.8200	6.7000	6.9000	533.4700	68157.00	53197.00	0.00	100	6	502	20	25.1	0.115842661289261	0.115842661289261	false	false	false	true