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: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

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	false	FloorTradeLargeCap	85cc2f90-fef8-4e3c-8c5c-01d1ead51af1	2	ETF	—	45287006880.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
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
5eb3c390-eb60-44c1-aea8-9bbd2a65767d	2026-09-18 14:01	2026-09-18 14:01	2026-09-18 14:01	DIA	DIA261009C00518000	call	518.0000	2026-10-09	5.1500	5.0500	5.1500	515.2000	52530.00	52530.00	0.00	102	20	103	19	5.42105263157895	0.11997648504391	0.11997648504391	false	false	false	true
f5ca3d3e-6647-4f4a-be2f-e3c1b646e0ec	2026-09-18 14:01	2026-09-18 14:01	2026-09-18 14:01	DIA	DIA261231C00540000	call	540.0000	2026-12-31	6.5000	6.3500	6.7500	515.2000	13000.00	3900.00	9100.00	20	7	50	38	1.31578947368421	0.123329013197502	0.123329013197502	false	false	false	true
64a02e7b-33e3-4426-8e17-dd9e5a90513a	2026-09-18 13:59	2026-09-18 13:59	2026-09-18 13:59	DIA	DIA260930C00515000	call	515.0000	2026-09-30	4.6500	4.5500	4.6500	515.2900	38130.00	38130.00	0.00	82	24	109	123	0.886178861788618	0.111481496045631	0.111481496045631	false	false	false	true
d2c86596-2d22-4f2c-8f02-074b57af3040	2026-09-18 13:44	2026-09-18 13:44	2026-09-18 13:44	DIA	DIA261009C00517000	call	517.0000	2026-10-09	5.6000	5.5000	5.6000	515.1458	33040.00	33040.00	0.00	59	9	65	2	32.5	0.120246327903157	0.120246327903157	false	false	false	true
4763efdc-398c-4603-afe9-bc9063cd12c7	2026-09-18 13:37	2026-09-18 13:37	2026-09-18 13:37	DIA	DIA261016P00480000	put	480.0000	2026-10-16	0.9800	0.9000	1.0600	515.1300	98980.00	392.00	98588.00	1010	11	1215	1800	0.675	0.191080569989022	0.191080569989022	false	false	false	true
7aa7aec0-3a23-4d9c-baf3-43c87470a531	2026-09-18 13:37	2026-09-18 13:37	2026-09-18 13:37	DIA	DIA261016C00522000	call	522.0000	2026-10-16	4.4000	4.3500	4.4500	515.1300	17600.00	16280.00	0.00	40	8	61	143	0.426573426573427	0.117347442566051	0.117347442566051	false	false	false	true
dca996cf-11ef-4da7-b04d-44e8b1c77606	2026-09-18 13:16	2026-09-18 13:16	2026-09-18 13:16	DIA	DIA260925C00516000	call	516.0000	2026-09-25	2.8000	2.7500	2.8300	514.8350	817880.00	808920.00	8960.00	2921	36	3011	36	83.6388888888889	0.111408891700125	0.111408891700125	false	false	false	true
4b0af1a6-e80e-4087-9b9f-9fc7008daefd	2026-09-18 12:58	2026-09-18 12:58	2026-09-18 12:58	DIA	DIA260925P00500000	put	500.0000	2026-09-25	0.4000	0.4000	0.4500	515.2000	55160.00	0.00	55160.00	1379	18	1667	1787	0.932848349188584	0.157621377128798	0.157621377128798	false	false	false	true
759c3a12-dde9-4d55-b38a-d6c681cae62a	2026-09-18 12:28	2026-09-18 12:28	2026-09-18 12:28	DIA	DIA261120P00515000	put	515.0000	2026-11-20	10.6900	10.4500	10.8000	514.3900	53438.00	53438.00	0.00	50	5	122	275	0.443636363636364	0.14282738828245	0.14282738828245	false	false	false	true
5640a8d6-839c-45e7-9f3a-e95d157a3d9f	2026-09-18 12:16	2026-09-18 12:16	2026-09-18 12:16	DIA	DIA260925C00515000	call	515.0000	2026-09-25	3.2000	3.2000	3.4000	514.0000	37120.00	0.00	37120.00	116	5	391	99	3.94949494949495	0.111098923154342	0.111098923154342	false	false	false	true
45c51ecc-4dd1-4ea5-95a4-d390f122380d	2026-09-18 12:13	2026-09-18 12:13	2026-09-18 12:13	DIA	DIA270630C00540000	call	540.0000	2027-06-30	21.0400	19.5000	22.6000	514.0000	210400.00	0.00	210400.00	100	2	300	14	21.4285714285714	0.133452418412971	0.133452418412971	false	true	true	false
f3f28f55-8bb5-4442-8b62-68487b285b38	2026-09-18 11:31	2026-09-18 11:30	2026-09-18 11:30	DIA	DIA260925P00514000	put	514.0000	2026-09-25	2.7000	2.5600	2.7000	515.1480	25649.00	25649.00	0.00	95	10	242	194	1.24742268041237	0.120154814663337	0.119797160306232	false	false	false	true
19f805b4-f033-4821-817b-388291a5c85c	2026-09-18 11:31	2026-09-18 11:30	2026-09-18 11:30	DIA	DIA260925P00515000	put	515.0000	2026-09-25	3.1000	2.9500	3.1000	515.0800	12090.00	12090.00	0.00	39	5	355	452	0.785398230088496	0.118229351205578	0.117097186326761	false	false	false	true
7de13fb3-c587-471e-be76-03ef5428edd8	2026-09-18 11:30	2026-09-18 11:30	2026-09-18 11:30	DIA	DIA261016P00480000	put	480.0000	2026-10-16	1.0000	0.9900	1.0700	515.1480	19000.00	0.00	17100.00	190	23	205	1800	0.113888888888889	0.192104751147752	0.192104751147752	false	false	false	true
c44f1f22-49ee-4a1b-8640-103179ce2627	2026-09-18 10:50	2026-09-18 10:50	2026-09-18 10:50	DIA	DIA261016C00525000	call	525.0000	2026-10-16	3.3000	3.2500	3.3000	514.6100	547800.00	547800.00	0.00	1660	18	1674	677	2.47267355982275	0.118810383842004	0.118810383842004	false	false	false	true
2e0dc4ca-4f5c-4873-9b27-58da54553371	2026-09-18 10:34	2026-09-18 10:34	2026-09-18 10:34	DIA	DIA261016C00515000	call	515.0000	2026-10-16	8.2000	8.1000	8.2500	514.9950	756860.00	756860.00	0.00	923	26	959	254	3.7755905511811	0.130128784038613	0.130128784038613	false	false	false	true
64506dac-5b77-466c-b76d-534dbd1bbf15	2026-09-18 10:20	2026-09-18 10:20	2026-09-18 10:20	DIA	DIA260918C00515000	call	515.0000	2026-09-18	0.9600	0.8900	0.9600	515.1500	14400.00	14400.00	0.00	150	11	942	50	18.84	0.167769555683607	0.167769555683607	false	false	false	true
54704f62-8933-4d07-9f82-387c516159aa	2026-09-18 10:02	2026-09-18 10:02	2026-09-18 10:02	DIA	DIA260918P00515000	put	515.0000	2026-09-18	1.0500	1.0200	1.0600	514.7200	101115.00	6825.00	94290.00	963	5	2780	2312	1.20242214532872	0.173035568677717	0.169979931077612	false	false	false	true
9f3b67d0-3005-4b01-9b89-cbfd916080a8	2026-09-18 09:57	2026-09-18 09:57	2026-09-18 09:57	DIA	DIA260918P00515000	put	515.0000	2026-09-18	0.9400	0.8900	0.9700	514.8950	97948.00	94.00	97854.00	1042	6	1759	2312	0.760813148788927	0.165606669093745	0.165606669093745	false	false	false	true
96888e6a-1c43-4bd9-a34e-a90ee9358e20	2026-09-18 09:54	2026-09-18 09:54	2026-09-18 09:54	DIA	DIA260918P00516000	put	516.0000	2026-09-18	1.2900	1.2900	1.3400	515.2900	12384.00	0.00	10449.00	96	5	657	2140	0.307009345794393	0.165802767869298	0.165802767869298	false	false	false	true
80d3f955-992e-4626-a70f-06fd1ae4ea71	2026-09-18 09:48	2026-09-18 09:47	2026-09-18 09:47	DIA	DIA261218P00550000	put	550.0000	2026-12-18	34.9000	34.4500	34.9000	515.7600	104700.00	104700.00	0.00	30	5	31	11	2.81818181818182	0.161175590255671	0.161175590255671	false	false	false	true
c4a28bfd-c4b0-46c3-858f-53ddd2655a86	2026-09-18 09:46	2026-09-18 09:46	2026-09-18 09:46	DIA	DIA261016P00530000	put	530.0000	2026-10-16	15.2700	15.1000	15.5000	515.6001	142011.00	62607.00	79404.00	93	6	97	771	0.125810635538262	0.123511013425182	0.123511013425182	false	false	false	true
edf3b9d6-1e23-448c-9991-c9b7b10a3e99	2026-09-18 09:44	2026-09-18 09:44	2026-09-18 09:44	DIA	DIA260918P00516000	put	516.0000	2026-09-18	1.0900	1.0000	1.0900	515.8100	10873.00	9469.00	0.00	100	10	487	2140	0.227570093457944	0.181638935709361	0.179817830666024	false	false	false	true
8facfd44-0745-4b5d-b468-8e692da2d21a	2026-09-18 09:40	2026-09-18 09:40	2026-09-18 09:40	DIA	DIA260918P00516000	put	516.0000	2026-09-18	1.1400	1.1300	1.2000	515.6500	11539.00	116.00	7889.00	101	5	310	2140	0.144859813084112	0.174255578135165	0.177908483406869	true	false	false	true
826d1a71-dd99-49c7-ad1d-925cf5bce541	2026-09-18 09:37	2026-09-18 09:37	2026-09-18 09:37	DIA	DIA261002C00511000	call	511.0000	2026-10-02	8.5500	8.4500	8.7000	515.6600	10260.00	9405.00	855.00	12	12	81	83	0.975903614457831	0.134780683900627	0.134780683900627	false	false	false	true
bef65750-746a-4d77-8ce6-f02f351c3455	2026-09-18 09:37	2026-09-18 09:37	2026-09-18 09:37	DIA	DIA261002C00511000	call	511.0000	2026-10-02	8.4500	8.3500	8.4500	515.6000	19435.00	1690.00	0.00	23	19	69	83	0.831325301204819	0.133148131484571	0.133148131484571	false	false	false	true
d6d2a2c6-569a-484b-a47d-3c5533a4d6b0	2026-09-18 09:36	2026-09-18 09:36	2026-09-18 09:36	DIA	DIA261002C00511000	call	511.0000	2026-10-02	8.3500	8.2500	8.5000	515.4100	19205.00	18370.00	835.00	23	19	46	83	0.55421686746988	0.133999155720184	0.133823102108429	false	false	false	true
7b6e119b-917d-42b6-99a0-a7560bc61546	2026-09-18 09:33	2026-09-18 09:33	2026-09-18 09:33	DIA	DIA261016C00526000	call	526.0000	2026-10-16	3.7000	3.7000	3.8500	516.6900	45140.00	0.00	45140.00	122	17	122	167	0.730538922155689	0.119600741737528	0.119600741737528	false	false	false	true
827eca0d-5db3-4432-aaab-7554a1914475	2026-09-18 09:33	2026-09-18 09:33	2026-09-18 09:33	DIA	DIA261002C00511000	call	511.0000	2026-10-02	9.3500	9.2000	9.5000	516.8000	21505.00	20570.00	0.00	23	19	23	83	0.27710843373494	0.1356037745753	0.1356037745753	true	false	false	true
eca80a02-b151-4fe9-be3c-67365d682c48	2026-09-17 15:54	2026-09-17 15:53	2026-09-17 15:53	DIA	DIA261016P00515000	put	515.0000	2026-10-16	5.7500	5.7500	5.9500	518.0000	80500.00	0.00	80500.00	140	8	337	577	0.584055459272097	0.138955343737157	0.138955343737157	false	false	false	true
1f0f60c4-cd5a-457c-a2fb-1b1135ddf426	2026-09-17 15:50	2026-09-17 15:50	2026-09-17 15:50	DIA	DIA260925C00518000	call	518.0000	2026-09-25	3.6000	3.5000	3.7000	518.0000	22320.00	15840.00	0.00	62	6	443	66	6.71212121212121	0.105868069915378	0.105868069915378	true	false	false	true
f9b4447b-d5e6-4f39-8f3a-93c2d51189cf	2026-09-17 15:44	2026-09-17 15:44	2026-09-17 15:44	DIA	DIA260925C00518000	call	518.0000	2026-09-25	3.6500	3.5500	3.6500	518.3700	21535.00	21535.00	0.00	59	14	369	66	5.59090909090909	0.105380295961299	0.105380295961299	false	false	false	true
e67addba-67a8-4e3e-b9ed-2ebaa8bd87bd	2026-09-17 15:00	2026-09-17 15:00	2026-09-17 15:00	DIA	DIA261016P00480000	put	480.0000	2026-10-16	1.0000	1.0000	1.0800	518.6600	22300.00	0.00	22300.00	223	32	251	1752	0.143264840182648	0.201790233541097	0.201790233541097	false	false	false	true
ded4ca9c-362f-45eb-be12-cbacf905b5a7	2026-09-17 14:49	2026-09-17 14:48	2026-09-17 14:48	DIA	DIA261016C00525000	call	525.0000	2026-10-16	4.7500	4.6000	4.8000	518.5900	237500.00	237500.00	0.00	500	1	640	198	3.23232323232323	0.117265986373806	0.117265986373806	false	true	false	true
2e3765af-d362-469e-b58a-37b0f8b679ed	2026-09-17 14:47	2026-09-17 14:47	2026-09-17 14:47	DIA	DIA261016C00525000	call	525.0000	2026-10-16	4.7000	4.6000	4.7500	518.5400	14100.00	13160.00	940.00	30	7	79	198	0.398989898989899	0.11674742775978	0.116730558539284	false	false	false	true
169e7a59-a913-453e-968e-fd0d3161186b	2026-09-17 13:36	2026-09-17 13:36	2026-09-17 13:36	DIA	DIA270319C00595000	call	595.0000	2027-03-19	2.2300	2.2300	2.2500	518.3700	19847.00	0.00	19847.00	89	6	211	132	1.59848484848485	0.125674478704809	0.125674478704809	false	false	false	true
3cb87cd6-5167-46fb-a2a2-da6443e4145c	2026-09-17 13:13	2026-09-17 13:13	2026-09-17 13:13	DIA	DIA260918C00513000	call	513.0000	2026-09-18	5.5000	5.3500	5.5000	518.4800	13750.00	13750.00	0.00	25	18	1987	996	1.99497991967871	0.0595869590454853	0.0595869590454853	true	false	false	true
d61341d1-d944-4be9-82b6-0e3c9d95c4a1	2026-09-17 13:04	2026-09-17 13:03	2026-09-17 13:03	DIA	DIA261016C00535000	call	535.0000	2026-10-16	1.8200	1.8200	1.9200	518.4700	101738.00	0.00	101738.00	559	9	612	1113	0.549865229110512	0.11539028946963	0.11539028946963	false	false	false	true
632d1785-d33c-432f-9134-380ba38fc640	2026-09-17 12:49	2026-09-17 12:49	2026-09-17 12:49	DIA	DIA261002C00511000	call	511.0000	2026-10-02	10.4000	10.3000	10.6000	518.7200	11440.00	0.00	11440.00	11	11	80	4	20	0.120302720150233	0.120302720150233	false	false	false	true
1f05b36e-b7f9-49fc-ad6a-5d4e57231457	2026-09-17 12:48	2026-09-17 12:48	2026-09-17 12:48	DIA	DIA261002C00511000	call	511.0000	2026-10-02	10.4000	10.4000	10.6000	518.7200	12480.00	0.00	4160.00	12	10	69	4	17.25	0.120302720150233	0.120302720150233	false	false	false	true
ffdfb459-9138-4d1c-bd2b-11be212d3679	2026-09-17 12:34	2026-09-17 12:34	2026-09-17 12:34	DIA	DIA261002C00511000	call	511.0000	2026-10-02	10.3500	10.3000	10.4000	518.5700	23805.00	1035.00	1035.00	23	18	48	4	12	0.122195511641192	0.122195511641192	false	false	false	true
aaeae233-f3cd-4439-8e4c-2c1c1a9df2ea	2026-09-17 12:34	2026-09-17 12:33	2026-09-17 12:33	DIA	DIA261002C00511000	call	511.0000	2026-10-02	10.4000	10.2000	10.5000	518.5000	23920.00	3120.00	1040.00	23	18	25	4	6.25	0.125227959217617	0.125227959217617	false	false	false	true
e84af54e-7bec-4226-abd8-af3f7fd16b4e	2026-09-17 12:14	2026-09-17 12:14	2026-09-17 12:14	DIA	DIA270630C00474000	call	474.0000	2027-06-30	67.3000	65.8500	69.4000	518.4566	33650.00	0.00	33650.00	5	5	5	0	0	0.154906682212311	0.154906682212311	false	false	false	true