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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

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

4e75c8e9-a478-4dd8-910a-f6eef2e14b25	2026-08-28 13:03	2026-08-28 13:03	2026-08-28 13:03	DIA	DIA260904C00540000	call	540.0000	2026-09-04	1.2000	1.1300	1.2000	534.7600	60000.00	60000.00	0.00	500	22	1232	3143	0.391982182628062	0.101941712892779	0.101941712892779	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-28T17:15:24.821907Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7600b7f9-7d73-4950-977b-fba400f9c741	2026-08-28 13:00	2026-08-28 13:00	2026-08-28 13:00	DIA	DIA260925C00551000	call	551.0000	2026-09-25	1.3000	1.3000	1.4100	534.8900	21970.00	0.00	21970.00	169	29	169	24	7.04166666666667	0.0990815716480479	0.0990815716480479	false	false	false	true
f16b2d0b-3384-410e-bea2-4c69897da869	2026-08-28 13:00	2026-08-28 13:00	2026-08-28 13:00	DIA	DIA270319P00515000	put	515.0000	2027-03-19	13.1300	11.4000	13.4000	534.9200	32825.00	19725.00	13100.00	25	5	57	85	0.670588235294118	0.167573394052538	0.167573394052538	false	false	false	true
c294a1a3-5e14-4739-8cbb-18cd40652494	2026-08-28 13:00	2026-08-28 13:00	2026-08-28 13:00	DIA	DIA270319P00520000	put	520.0000	2027-03-19	14.5600	13.0500	14.7500	534.9200	14560.00	13090.00	1470.00	10	6	32	630	0.0507936507936508	0.165349157623685	0.166402820740662	false	false	false	true
005160f2-52d7-48a0-a142-4f3b8418e408	2026-08-28 13:00	2026-08-28 13:00	2026-08-28 13:00	DIA	DIA270319P00515000	put	515.0000	2027-03-19	13.1400	11.2000	14.6000	534.9200	40745.00	21095.00	19650.00	31	7	32	85	0.376470588235294	0.16793796793167	0.167208637780145	false	false	false	true
d8b1b32b-8c14-4495-b2f0-052920dcb560	2026-08-28 12:18	2026-08-28 12:18	2026-08-28 12:18	DIA	DIA260918C00552000	call	552.0000	2026-09-18	0.7500	0.7500	0.8200	535.2700	37425.00	0.00	37425.00	499	39	500	1481	0.337609723160027	0.100267601938798	0.100267601938798	false	false	false	true
a7d021f4-da53-48de-8ab6-ea1ce109d9bf	2026-08-28 12:17	2026-08-28 12:17	2026-08-28 12:17	DIA	DIA280121P00230000	put	230.0000	2028-01-21	1.3000	1.1700	2.0800	535.3200	13000.00	11700.00	1300.00	100	6	496	1107	0.448057813911472	0.382722156684195	0.382722156684195	false	false	false	true
728fc4ce-eba4-4f3d-9e52-621c10f69ef1	2026-08-28 12:14	2026-08-28 12:14	2026-08-28 12:14	DIA	DIA261218C00545000	call	545.0000	2026-12-18	13.7000	13.5000	13.9000	535.8200	43840.00	12330.00	10960.00	32	6	32	474	0.0675105485232067	0.126596440642987	0.126596440642987	false	false	false	true
285ee3dd-b756-4595-9e06-6a279f6997e1	2026-08-28 11:52	2026-08-28 11:52	2026-08-28 11:52	DIA	DIA261002C00555000	call	555.0000	2026-10-02	1.5300	1.5300	1.6500	535.0000	18666.00	0.00	18666.00	122	25	122	13	9.38461538461539	0.103735447788553	0.103735447788553	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
86b88237-8aa3-4687-aacd-13cd85744d66	2026-08-28 11:27	2026-08-28 11:27	2026-08-28 11:27	DIA	DIA260904P00530000	put	530.0000	2026-09-04	0.7500	0.6900	0.7600	537.6900	22500.00	19275.00	3225.00	300	5	2451	928	2.64116379310345	0.113526371982666	0.113526371982666	false	false	false	true
9af9fb4d-331d-4dbb-b220-e2e7123a69fd	2026-08-28 11:20	2026-08-28 11:20	2026-08-28 11:20	DIA	DIA260911P00536000	put	536.0000	2026-09-11	3.2000	3.1000	3.3000	537.4533	287040.00	286400.00	640.00	897	6	938	51	18.3921568627451	0.100805699564667	0.100805699564667	false	false	false	true
93841aed-cff7-43b7-ad98-6ba01ef546bc	2026-08-28 11:12	2026-08-28 11:12	2026-08-28 11:12	DIA	DIA260828C00536000	call	536.0000	2026-08-28	1.1800	1.1800	1.3300	536.9400	29501.00	0.00	29501.00	250	6	1709	1009	1.69375619425173	0.116999581884477	0.11945364933296	false	false	false	true
7e996924-b3d7-4cab-95a6-6c48ffe5b0a8	2026-08-28 10:56	2026-08-28 10:56	2026-08-28 10:56	DIA	DIA260828C00536000	call	536.0000	2026-08-28	1.3200	1.2600	1.3900	536.9100	18960.00	11792.00	7168.00	144	13	1298	1009	1.28642220019822	0.154678418833801	0.141569330123702	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
0dbd9559-ccf5-4b11-a184-73369e90afe4	2026-08-28 10:44	2026-08-28 10:44	2026-08-28 10:44	DIA	DIA260904C00539000	call	539.0000	2026-09-04	1.8100	1.7200	1.8100	536.0700	28779.00	28779.00	0.00	159	22	190	210	0.904761904761905	0.0978098787327906	0.0978098787327906	false	false	false	true
81676551-dcd4-41e4-9f5a-f94c1f49f4d7	2026-08-28 10:34	2026-08-28 10:34	2026-08-28 10:34	DIA	DIA260828C00536000	call	536.0000	2026-08-28	0.6900	0.6200	0.7100	535.5400	17250.00	17250.00	0.00	250	5	945	1009	0.936570862239841	0.16837081125977	0.16837081125977	false	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
cbdab6e5-a6ae-4d7c-ad83-978dd5f74e1e	2026-08-28 09:49	2026-08-28 09:49	2026-08-28 09:49	DIA	DIA260904P00536000	put	536.0000	2026-09-04	2.7900	2.7000	2.8100	536.4200	22846.00	11761.00	11085.00	82	8	99	384	0.2578125	0.107573630772104	0.107699884901973	false	false	false	true
a24ee815-bc49-4625-96ea-520c0a93bb6c	2026-08-28 09:49	2026-08-28 09:49	2026-08-28 09:49	DIA	DIA260904P00535000	put	535.0000	2026-09-04	2.4100	2.3200	2.4400	536.4200	26310.00	17879.00	8431.00	109	15	149	854	0.174473067915691	0.109267112491087	0.109346158631874	false	false	false	true
08c31314-e67a-4315-9927-1f4bc8604755	2026-08-28 09:49	2026-08-28 09:49	2026-08-28 09:49	DIA	DIA260911P00537000	put	537.0000	2026-09-11	4.3000	4.1500	4.3000	536.3900	62778.00	62778.00	0.00	146	15	146	20	7.3	0.104686814585444	0.104686814585444	false	false	false	true
7667b9e5-5712-49e2-b28a-b859a391980c	2026-08-28 09:46	2026-08-28 09:46	2026-08-28 09:46	DIA	DIA260918P00525000	put	525.0000	2026-09-18	2.3000	2.2200	2.3100	536.0100	376280.00	375590.00	690.00	1636	36	1640	300	5.46666666666667	0.132047173398213	0.132047173398213	false	false	false	true
e9eb67a1-8090-4ad9-b866-1f770148cfee	2026-08-27 15:08	2026-08-27 15:08	2026-08-27 15:08	DIA	DIA260828P00532000	put	532.0000	2026-08-28	0.5000	0.4900	0.5400	534.9800	12250.00	0.00	12250.00	245	24	515	717	0.718270571827057	0.14124629973842	0.14124629973842	false	false	false	true
247e28ab-db81-4ca6-9972-64dfbbbe1bac	2026-08-27 15:04	2026-08-27 15:04	2026-08-27 15:04	DIA	DIA260828P00535000	put	535.0000	2026-08-28	1.4100	1.4100	1.4500	534.9900	24675.00	0.00	24675.00	175	8	1285	470	2.73404255319149	0.128255203165456	0.128255203165456	true	false	false	true
211e0baf-9c20-42e6-9e10-5f046e05d2f7	2026-08-27 14:52	2026-08-27 14:52	2026-08-27 14:52	DIA	DIA260904C00541000	call	541.0000	2026-09-04	1.1700	1.1600	1.2400	534.7800	24570.00	0.00	24570.00	210	33	237	259	0.915057915057915	0.103240889028113	0.103240889028113	false	false	false	true
60304713-2337-4024-8e57-6dcc84f502c5	2026-08-27 14:51	2026-08-27 14:51	2026-08-27 14:51	DIA	DIA261016P00535000	put	535.0000	2026-10-16	9.1000	8.9500	9.2000	534.7950	70954.00	70954.00	0.00	78	7	308	270	1.14074074074074	0.132490552892824	0.130831691996577	false	false	false	true
601e9309-1e30-41e6-b977-bb017fce26a9	2026-08-27 14:50	2026-08-27 14:49	2026-08-27 14:49	DIA	DIA260930C00547000	call	547.0000	2026-09-30	2.8600	2.8600	2.9700	534.9600	50908.00	0.00	50908.00	178	27	181	12	15.0833333333333	0.102553845259471	0.102553845259471	false	false	false	true
38152c6c-bfa6-401e-be32-01dab628e14f	2026-08-27 14:27	2026-08-27 14:27	2026-08-27 14:27	DIA	DIA260930C00553000	call	553.0000	2026-09-30	1.6000	1.6000	1.6800	534.9400	19201.00	0.00	19201.00	120	25	122	5	24.4	0.103441665675967	0.103441665675967	false	false	false	true
4d196c3d-780f-465b-b1bf-14cf7211fa39	2026-08-27 13:13	2026-08-27 13:13	2026-08-27 13:13	DIA	DIA261016P00534000	put	534.0000	2026-10-16	7.8500	7.8500	8.1000	536.1600	83210.00	0.00	83210.00	106	5	222	53	4.18867924528302	0.128506759320355	0.128506759320355	false	false	false	true
e501829a-6e96-4588-b98c-a07a07efba25	2026-08-27 12:57	2026-08-27 12:57	2026-08-27 12:57	DIA	DIA260911C00544000	call	544.0000	2026-09-11	1.7800	1.7200	1.7800	536.1750	22606.00	22606.00	0.00	127	12	137	192	0.713541666666667	0.101267501477467	0.101267501477467	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
c694e15f-b2b6-4a71-8e7b-2b51b3634e8f	2026-08-27 12:03	2026-08-27 12:03	2026-08-27 12:03	DIA	DIA260911P00535000	put	535.0000	2026-09-11	3.9000	3.8500	3.9000	535.6363	62400.00	62400.00	0.00	160	7	207	262	0.790076335877863	0.106294372563455	0.106294372563455	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
5cbc1995-d60e-4a0b-9006-e16230e3bb2f	2026-08-27 11:41	2026-08-27 11:41	2026-08-27 11:41	DIA	DIA260904C00544000	call	544.0000	2026-09-04	0.7900	0.7400	0.7900	535.9600	37130.00	37130.00	0.00	470	28	488	188	2.59574468085106	0.10280703888106	0.10280703888106	false	false	false	true
3b897edf-91b4-4991-a123-be7b992b2eba	2026-08-27 11:37	2026-08-27 11:37	2026-08-27 11:37	DIA	DIA260828P00534000	put	534.0000	2026-08-28	0.8000	0.8000	0.8400	535.8800	14080.00	0.00	14080.00	176	25	1126	1420	0.792957746478873	0.141732345823208	0.141732345823208	false	false	false	true
c9173a43-590c-4792-8c3a-460ed471b50b	2026-08-27 11:33	2026-08-27 11:33	2026-08-27 11:33	DIA	DIA280121P00230000	put	230.0000	2028-01-21	1.2500	1.1600	2.0500	535.9100	12500.00	2500.00	10000.00	100	6	498	351	1.41880341880342	0.380337438590421	0.380337438590421	false	false	false	true
04b46a03-1df3-4f41-97c2-b834edfcc5a9	2026-08-27 11:28	2026-08-27 11:28	2026-08-27 11:28	DIA	DIA260828P00539000	put	539.0000	2026-08-28	3.1200	2.9800	3.2000	536.2601	15600.00	9984.00	5616.00	50	7	50	173	0.289017341040462	0.123219086619903	0.123219086619903	false	false	false	true
d995db4e-9779-4836-b822-32fc630441e9	2026-08-27 11:15	2026-08-27 11:15	2026-08-27 11:15	DIA	DIA260828C00537000	call	537.0000	2026-08-28	1.2600	1.1900	1.2600	536.1900	12348.00	12348.00	0.00	98	21	1010	605	1.66942148760331	0.143605436818093	0.143605436818093	true	false	false	true
fc833517-68fd-45b5-b33c-0267e8782121	2026-08-27 10:48	2026-08-27 10:48	2026-08-27 10:48	DIA	DIA260828C00520000	call	520.0000	2026-08-28	15.8000	15.6500	15.9000	535.6100	36340.00	14220.00	0.00	23	5	443	593	0.747048903878583	0.320236600081199	0.320236600081199	false	false	false	true
47362367-6b73-4ef1-b02c-1c9ed76f8321	2026-08-27 10:39	2026-08-27 10:39	2026-08-27 10:39	DIA	DIA260828C00537000	call	537.0000	2026-08-28	0.8500	0.7800	0.8500	535.1400	17000.00	17000.00	0.00	200	8	422	605	0.697520661157025	0.142234039226721	0.142234039226721	false	false	false	true
10904906-126c-404d-ac9c-8096ba2385aa	2026-08-27 10:38	2026-08-27 10:38	2026-08-27 10:38	DIA	DIA260911C00537000	call	537.0000	2026-09-11	4.1500	4.0000	4.1500	535.1900	20750.00	20750.00	0.00	50	10	51	118	0.432203389830508	0.106639096042273	0.106639096042273	false	false	false	true
0f063933-70ea-4f96-83f0-06cac9b17b5b	2026-08-27 10:34	2026-08-27 10:34	2026-08-27 10:34	DIA	DIA260828P00531000	put	531.0000	2026-08-28	0.4600	0.4600	0.5000	534.5200	40894.00	0.00	40894.00	889	38	971	831	1.16847172081829	0.15051400635863	0.15051400635863	false	false	false	true
373c6ecc-f4d2-4b5a-806d-5f4d3af8b40b	2026-08-27 10:23	2026-08-27 10:23	2026-08-27 10:23	DIA	DIA261120P00534000	put	534.0000	2026-11-20	12.2000	12.2000	12.4000	534.3050	12200.00	0.00	12200.00	10	10	10	15	0.666666666666667	0.14259896467422	0.14259896467422	false	false	false	true
a839fdb3-2953-4d6d-9169-7ea9a720acf5	2026-08-27 10:23	2026-08-27 10:23	2026-08-27 10:23	DIA	DIA260925P00529000	put	529.0000	2026-09-25	4.7000	4.7000	4.9500	534.2600	290465.00	0.00	290465.00	618	45	618	40	15.45	0.128053435920455	0.128053435920455	false	false	false	true
09049099-0332-47f8-bcd5-f9928e86306f	2026-08-27 10:19	2026-08-27 10:19	2026-08-27 10:19	DIA	DIA260925C00544000	call	544.0000	2026-09-25	3.0000	3.0000	3.2000	534.0800	201605.00	0.00	201605.00	672	52	673	11	61.1818181818182	0.103971581209901	0.103971581209901	false	false	false	true
7a9fe903-0543-4e14-bcd7-83afceffdf25	2026-08-27 10:09	2026-08-27 10:08	2026-08-27 10:08	DIA	DIA260828P00530000	put	530.0000	2026-08-28	0.5000	0.5000	0.5400	533.7100	43700.00	0.00	43700.00	874	23	983	2135	0.460421545667447	0.160784074636276	0.160784074636276	false	false	false	true
3344fb9d-4859-4a60-b745-31416c7e42b4	2026-08-27 09:59	2026-08-27 09:59	2026-08-27 09:59	DIA	DIA260828P00534000	put	534.0000	2026-08-28	1.6200	1.5600	1.6700	534.1300	80838.00	13122.00	67716.00	499	6	768	1420	0.540845070422535	0.153449451643713	0.153449451643713	false	false	false	true
45fe9403-a350-4d2f-9899-5dc0753938c3	2026-08-27 09:48	2026-08-27 09:48	2026-08-27 09:48	DIA	DIA260904P00530000	put	530.0000	2026-09-04	1.9400	1.8700	1.9700	534.4150	14550.00	14550.00	0.00	75	6	177	694	0.255043227665706	0.124003122951829	0.124003122951829	false	false	false	true