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:endpoint = /api/option-trades/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	expiry

cacbd22f-9364-4bb8-a425-344274b64b54	2026-09-21 14:05	2026-09-21 14:05	2026-09-21 14:05	DIA	DIA260930P00502000	put	502.0000	2026-09-30	0.4300	0.4200	0.5200	519.0000	18430.00	2820.00	15610.00	428	25	430	20	21.5	0.156754223440775	0.156754223440775	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	45460200686.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:09:57.736377Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
06359267-4660-4b6e-912f-15e91dd25623	2026-09-21 14:05	2026-09-21 14:05	2026-09-21 14:05	DIA	DIA260930P00501000	put	501.0000	2026-09-30	0.4000	0.3900	0.4800	519.0000	18360.00	520.00	17840.00	459	35	1368	26	52.6153846153846	0.160783644491805	0.160783644491805	false	false	false	true
f23aa1db-89fd-4105-b6e5-c73d6d2527ae	2026-09-21 13:45	2026-09-21 13:45	2026-09-21 13:45	DIA	DIA261231C00550000	call	550.0000	2026-12-31	5.0500	4.9000	5.3000	519.0000	15150.00	4545.00	10605.00	30	5	62	281	0.220640569395018	0.125367206834449	0.125367206834449	false	false	false	true
717036d0-aadb-4465-bfeb-e7de9697fa71	2026-09-21 13:19	2026-09-21 13:19	2026-09-21 13:19	DIA	DIA260930C00510000	call	510.0000	2026-09-30	11.4000	11.3000	11.5500	519.0000	17100.00	7980.00	9120.00	15	6	18	334	0.0538922155688623	0.137784766208658	0.137784766208658	false	false	false	true
20d1bd1e-d4c5-436c-9043-54e83bbcf09f	2026-09-21 12:27	2026-09-21 12:27	2026-09-21 12:27	DIA	DIA261002C00523000	call	523.0000	2026-10-02	2.9000	2.8500	2.9000	518.9500	326540.00	326540.00	0.00	1126	6	1710	161	10.6211180124224	0.122079389943256	0.122079389943256	false	false	false	true
f1e1e6fd-982a-40d6-ab64-166f676008b6	2026-09-21 12:10	2026-09-21 12:10	2026-09-21 12:10	DIA	DIA280121C00620000	call	620.0000	2028-01-21	10.9200	8.1000	11.7500	519.0900	16375.00	15285.00	1090.00	15	7	20	1914	0.0104493207941484	0.132782753004233	0.131473306824728	false	false	false	true
548df47f-1a29-4587-ba7b-f10117966e7a	2026-09-21 12:10	2026-09-21 12:10	2026-09-21 12:10	DIA	DIA280121C00625000	call	625.0000	2028-01-21	10.2000	7.0500	10.2000	519.0900	14280.00	14280.00	0.00	14	6	14	78	0.179487179487179	0.132682484766689	0.132682484766689	false	false	false	true
e93038a8-28f7-439b-affe-f4f1dd75deed	2026-09-21 12:04	2026-09-21 12:03	2026-09-21 12:03	DIA	DIA260930P00501000	put	501.0000	2026-09-30	0.4100	0.4000	0.5100	518.4750	37270.00	0.00	37270.00	909	50	909	26	34.9615384615385	0.15519304264051	0.15519304264051	true	false	false	true
a135bc05-482f-46ad-a4c1-00d17bb5b7f2	2026-09-21 12:04	2026-09-21 12:03	2026-09-21 12:03	DIA	DIA260930P00497000	put	497.0000	2026-09-30	0.2900	0.2900	0.3700	518.4750	11110.00	32.00	11078.00	383	31	397	266	1.49248120300752	0.168903425460697	0.172382586085896	true	false	false	true
dd303ce8-c681-46a6-bdc7-215d2e4d3924	2026-09-21 11:14	2026-09-21 11:14	2026-09-21 11:14	DIA	DIA261016P00517000	put	517.0000	2026-10-16	5.3500	5.3500	5.5000	518.4900	13910.00	0.00	13910.00	26	5	26	0	0	0.123835289546382	0.124075292038848	false	false	false	true
b6eb6b11-d5ef-438b-807e-ae2892f2289f	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	DIA	DIA261218P00550000	put	550.0000	2026-12-18	32.6800	32.1500	32.7000	518.0000	29415.00	26150.00	3265.00	9	9	34	36	0.944444444444444	0.155816877983796	0.155816877983796	true	false	false	true
f2269b3a-cc01-4588-a85a-8633bce2a36a	2026-09-21 11:06	2026-09-21 11:06	2026-09-21 11:06	DIA	DIA280121C00460000	call	460.0000	2028-01-21	92.8000	92.8000	94.7500	518.2450	46400.00	0.00	18560.00	5	5	11	15	0.733333333333333	0.150936748673476	0.150936748673476	false	false	false	true
816c6310-b108-4108-9111-b4f81718c4f8	2026-09-21 11:06	2026-09-21 11:06	2026-09-21 11:06	DIA	DIA261016C00518000	call	518.0000	2026-10-16	7.6000	7.4500	7.7000	518.2350	15192.00	12912.00	2280.00	20	10	31	0	0	0.124906833215884	0.124906833215884	false	false	false	true
311f96fe-6cc9-4fb9-a200-fb311b62446c	2026-09-21 11:06	2026-09-21 11:05	2026-09-21 11:05	DIA	DIA280121C00520000	call	520.0000	2028-01-21	50.5000	48.7500	50.5000	518.2127	25250.00	25250.00	0.00	5	5	5	12	0.416666666666667	0.143549887741181	0.143549887741181	false	false	false	true
11bdeb45-7ea8-4452-a7e7-75e1691a379c	2026-09-21 10:43	2026-09-21 10:43	2026-09-21 10:43	DIA	DIA260925C00521000	call	521.0000	2026-09-25	1.5500	1.5400	1.6100	518.0000	30928.00	0.00	30928.00	200	6	1780	873	2.0389461626575	0.121460813606718	0.121460813606718	false	false	false	true
b8631592-2c92-4c76-9b4c-cca20b773a41	2026-09-21 10:41	2026-09-21 10:41	2026-09-21 10:41	DIA	DIA261002P00519000	put	519.0000	2026-10-02	4.1000	4.0500	4.2000	518.3700	11480.00	0.00	11480.00	28	14	30	14	2.14285714285714	0.114074297553959	0.114074297553959	false	false	false	true
a8b1b460-58b1-421d-a7d4-e4eb51f66c08	2026-09-21 10:38	2026-09-21 10:38	2026-09-21 10:38	DIA	DIA260925P00516000	put	516.0000	2026-09-25	1.6600	1.6600	1.7100	518.3000	11952.00	0.00	11952.00	72	16	189	142	1.33098591549296	0.126853363448193	0.126853363448193	false	false	false	true
a7351bf1-3931-4d97-949f-9dad5a1c39c7	2026-09-21 10:34	2026-09-21 10:34	2026-09-21 10:34	DIA	DIA261218C00540000	call	540.0000	2026-12-18	6.5200	6.4000	6.7500	518.2300	16294.00	0.00	16294.00	25	10	532	1877	0.283431006925946	0.127081402923404	0.127081402923404	false	false	false	true
579b6483-1133-4352-b5b7-e569defbc8c2	2026-09-21 10:33	2026-09-21 10:33	2026-09-21 10:33	DIA	DIA260925C00521000	call	521.0000	2026-09-25	1.5900	1.5500	1.6400	518.3200	12720.00	0.00	12720.00	80	5	1019	873	1.16723940435281	0.121538692594902	0.121538692594902	false	false	false	true
cd9e10c3-30c2-43ae-bb79-07e6cbc45b02	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	DIA	DIA260925C00523000	call	523.0000	2026-09-25	0.9400	0.8600	0.9400	518.1300	10152.00	6298.00	0.00	108	12	167	408	0.409313725490196	0.121569008560262	0.121282754692429	false	false	false	true
847be66d-44f6-443b-a019-4e01124d07ff	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	DIA	DIA260925C00522000	call	522.0000	2026-09-25	1.2000	1.1200	1.2000	518.1300	305040.00	305040.00	0.00	2542	35	2628	322	8.16149068322981	0.121421551727481	0.121107921046636	false	false	false	true
95a40bd9-4602-4f9b-b873-53bb395dd012	2026-09-21 10:04	2026-09-21 10:04	2026-09-21 10:04	DIA	DIA261120C00522000	call	522.0000	2026-11-20	10.7000	10.5500	10.7000	517.5700	39590.00	39590.00	0.00	37	7	37	37	1	0.133154642612057	0.133154642612057	false	false	false	true
ef863b53-2491-4590-8bb8-e2fa553b1026	2026-09-21 09:59	2026-09-21 09:59	2026-09-21 09:59	DIA	DIA270630C00535000	call	535.0000	2027-06-30	25.5200	24.3000	26.8000	517.3350	510400.00	0.00	510400.00	200	2	201	216	0.930555555555556	0.139775528300773	0.139775528300773	false	true	true	false
2d36eb84-0b10-4a84-8ffd-3a7625d99c26	2026-09-21 09:57	2026-09-21 09:57	2026-09-21 09:57	DIA	DIA270630C00545000	call	545.0000	2027-06-30	20.5500	19.6000	21.6000	517.3550	205500.00	0.00	205500.00	100	2	1352	942	1.43524416135881	0.136171465693229	0.136171465693229	false	true	true	false
0358368c-b7ed-4424-9e5b-60db83bf75bf	2026-09-21 09:54	2026-09-21 09:54	2026-09-21 09:54	DIA	DIA270630C00545000	call	545.0000	2027-06-30	20.5500	19.6000	21.6000	517.4955	411000.00	0.00	411000.00	200	2	922	942	0.978768577494692	0.135809934977183	0.135809934977183	false	true	true	false
38243d42-8c2e-49be-a9af-30cad7cecfc1	2026-09-21 09:54	2026-09-21 09:54	2026-09-21 09:54	DIA	DIA270630C00545000	call	545.0000	2027-06-30	20.5600	19.6000	21.6500	517.4850	411200.00	0.00	411200.00	200	2	552	942	0.585987261146497	0.135892282521039	0.135892282521039	false	true	true	false
07e420ce-80c5-46c7-a48d-8754a0aeed4a	2026-09-21 09:53	2026-09-21 09:52	2026-09-21 09:52	DIA	DIA261218P00548000	put	548.0000	2026-12-18	31.3800	30.9500	31.5000	517.6000	40795.00	25120.00	15675.00	13	5	13	11	1.18181818181818	0.153213718028176	0.153213718028176	true	false	false	true
d89bda4f-6f04-4c22-b25a-d3e6ea5361b3	2026-09-21 09:52	2026-09-21 09:52	2026-09-21 09:52	DIA	DIA261218P00551000	put	551.0000	2026-12-18	34.1500	33.6000	34.1500	517.4550	30735.00	30735.00	0.00	9	8	9	3	3	0.157982975878303	0.157982975878303	false	false	false	true
c2db2bf6-bea9-493e-8acb-5e77e2df0bde	2026-09-21 09:49	2026-09-21 09:49	2026-09-21 09:49	DIA	DIA261009C00512000	call	512.0000	2026-10-09	9.6500	9.5500	9.6500	517.1300	22195.00	22195.00	0.00	23	6	23	0	0	0.133954904953137	0.133954904953137	false	false	false	true
4d0416e5-a030-4e4c-91bd-d36d24cbed3a	2026-09-21 09:48	2026-09-21 09:48	2026-09-21 09:48	DIA	DIA261218C00540000	call	540.0000	2026-12-18	6.1400	5.9500	6.1500	516.0000	184302.00	182457.00	0.00	300	45	305	1877	0.162493340436867	0.127796994462198	0.127796994462198	true	false	false	true
9e78be49-1b01-4889-bb6d-65428477aa70	2026-09-21 09:48	2026-09-21 09:48	2026-09-21 09:48	DIA	DIA260925C00521000	call	521.0000	2026-09-25	1.1600	1.1300	1.2100	517.0000	10324.00	3364.00	6960.00	89	5	518	873	0.593356242840779	0.120750136032364	0.120750136032364	false	false	false	true
f398c71c-9928-4bd5-8b70-589a7f9bae2c	2026-09-21 09:39	2026-09-21 09:39	2026-09-21 09:39	DIA	DIA260930P00540000	put	540.0000	2026-09-30	21.8500	21.8500	22.2000	518.0050	21850.00	0.00	21850.00	10	5	10	13	0.769230769230769	0.168965637160698	0.168965637160698	false	false	false	true
fa9571a4-b4b2-4002-bc25-23783b3556da	2026-09-21 09:37	2026-09-21 09:37	2026-09-21 09:37	DIA	DIA261120P00545000	put	545.0000	2026-11-20	27.6200	25.4000	27.6500	517.8300	33145.00	33145.00	0.00	12	5	32	1	32	0.146484531325187	0.145710973746809	true	false	false	true
bbb144ff-3b05-495d-9f82-078b114c3a76	2026-09-21 09:35	2026-09-21 09:35	2026-09-21 09:35	DIA	DIA260930C00516000	call	516.0000	2026-09-30	5.4000	5.3000	5.4000	518.2200	10800.00	10800.00	0.00	20	7	38	806	0.0471464019851117	0.12101880769474	0.120036389538113	false	false	false	true
428e10b2-bd4e-414e-9f70-b0dbcc5d3a29	2026-09-21 09:31	2026-09-21 09:30	2026-09-21 09:30	DIA	DIA270617P00355000	put	355.0000	2027-06-17	2.2800	0.2400	2.2800	519.2200	10487.00	10487.00	0.00	46	9	46	75	0.613333333333333	0.294502183891343	0.294237378942175	false	false	false	true
d59e2086-54cb-4a74-8d10-72c551b80258	2026-09-18 15:44	2026-09-18 15:44	2026-09-18 15:44	DIA	DIA261009C00524000	call	524.0000	2026-10-09	2.8500	2.7700	2.8500	516.3300	16244.00	16244.00	0.00	57	13	58	4	14.5	0.110440456804116	0.110440456804116	false	false	false	true
7d2e090a-a7cc-45ba-a206-99241364c6ba	2026-09-18 15:43	2026-09-18 15:43	2026-09-18 15:43	DIA	DIA261016P00485000	put	485.0000	2026-10-16	1.0700	1.0300	1.1600	516.2500	18511.00	107.00	18404.00	173	34	2290	202	11.3366336633663	0.178640820059867	0.178640820059867	true	false	false	true
2d02acd3-5d4b-40ba-a398-9b43e3f97420	2026-09-18 15:37	2026-09-18 15:37	2026-09-18 15:37	DIA	DIA270630C00545000	call	545.0000	2027-06-30	19.3900	17.6500	21.1000	516.0800	193900.00	193900.00	0.00	100	2	1834	0	0	0.132222809281275	0.132222809281275	false	true	true	false
4ce49f7b-66d4-4e49-a5ca-657875262fda	2026-09-18 15:22	2026-09-18 15:22	2026-09-18 15:22	DIA	DIA261016C00525000	call	525.0000	2026-10-16	3.6000	3.4500	3.6000	516.1400	19080.00	19080.00	0.00	53	6	1833	677	2.70753323485968	0.115033668219737	0.115033668219737	false	false	false	true
1574fddb-14ec-437c-a1d8-094d8b030e66	2026-09-18 15:11	2026-09-18 15:11	2026-09-18 15:11	DIA	DIA260930C00516000	call	516.0000	2026-09-30	4.6000	4.5000	4.6500	516.2900	345460.00	342240.00	0.00	751	24	779	10	77.9	0.10990069021656	0.10990069021656	false	false	false	true
971f0f5d-5aa3-4038-a097-c5161829eecc	2026-09-18 14:57	2026-09-18 14:57	2026-09-18 14:57	DIA	DIA260930C00520000	call	520.0000	2026-09-30	2.6400	2.5400	2.6400	516.4900	23232.00	23232.00	0.00	88	22	278	169	1.64497041420118	0.103919736526952	0.103919736526952	false	false	false	true
423d6c52-a342-4d30-9e75-2fdedff7eaad	2026-09-18 14:47	2026-09-18 14:47	2026-09-18 14:47	DIA	DIA260918P00520000	put	520.0000	2026-09-18	3.5000	3.5000	3.7500	516.4900	26250.00	0.00	26250.00	75	5	338	3829	0.088273700705145	0.524853055938306	0.540756525929716	false	false	false	true
04cc99d8-5fff-48e5-bf84-4e7ffc277c41	2026-09-18 14:46	2026-09-18 14:46	2026-09-18 14:46	DIA	DIA261002P00495000	put	495.0000	2026-10-02	0.6600	0.6600	0.7200	516.1500	29304.00	0.00	29304.00	444	38	452	1125	0.401777777777778	0.163790119125434	0.163790119125434	false	false	false	true
3017fbaa-2615-427f-90eb-1765fe59d8ab	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	DIA	DIA270630C00545000	call	545.0000	2027-06-30	19.2900	17.4500	21.1000	515.9000	192900.00	192900.00	0.00	100	2	1634	0	0	0.132121552142643	0.132121552142643	false	true	true	false
2a411e18-5c3f-456c-b567-b588c7b29abc	2026-09-18 14:31	2026-09-18 14:31	2026-09-18 14:31	DIA	DIA260925C00521000	call	521.0000	2026-09-25	1.1900	1.1100	1.1900	515.8700	35537.00	35537.00	0.00	299	45	414	494	0.838056680161943	0.103983777664035	0.103983777664035	true	false	false	true
2e759583-1e72-473a-baa9-ff8225241546	2026-09-18 14:19	2026-09-18 14:18	2026-09-18 14:18	DIA	DIA261009C00514000	call	514.0000	2026-10-09	7.6000	7.5000	7.6000	515.5500	99560.00	99560.00	0.00	131	25	135	3	45	0.124851245906458	0.124851245906458	false	false	false	true
8433d12f-3c75-4efe-8bd6-79e7367cb1d4	2026-09-18 14:14	2026-09-18 14:14	2026-09-18 14:14	DIA	DIA260930C00519000	call	519.0000	2026-09-30	2.6600	2.5800	2.6700	515.4700	48678.00	48678.00	0.00	183	22	189	21	9	0.104909909131747	0.104909909131747	false	false	false	true
67bde41d-9748-4228-864f-21e526bc1a99	2026-09-18 14:10	2026-09-18 14:10	2026-09-18 14:10	DIA	DIA260918C00516000	call	516.0000	2026-09-18	0.2100	0.1700	0.2200	515.3800	16333.00	15534.00	799.00	789	68	1849	52	35.5576923076923	0.140818136052453	0.152694275336193	false	false	false	true
68880a90-4349-4563-a32b-c5719cb968b1	2026-09-18 14:08	2026-09-18 14:08	2026-09-18 14:08	DIA	DIA261120P00515000	put	515.0000	2026-11-20	10.1500	9.9500	10.2500	515.4000	22336.00	22336.00	0.00	22	6	223	275	0.810909090909091	0.141716476160686	0.141716476160686	false	false	false	true
b96b2db7-c266-4010-b42b-847671545c13	2026-09-18 14:01	2026-09-18 14:01	2026-09-18 14:01	DIA	DIA261009C00523000	call	523.0000	2026-10-09	2.9500	2.8700	2.9500	515.2000	23600.00	23600.00	0.00	80	11	80	14	5.71428571428571	0.113867959956394	0.113867959956394	false	false	false	true