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

c22bfeca-85f5-4046-8dcd-313fdc0cd390	2026-08-27 09:44	2026-08-27 09:44	2026-08-27 09:44	DIA	DIA260828P00534000	put	534.0000	2026-08-28	1.4800	1.4800	1.5900	534.4550	20720.00	0.00	20720.00	140	23	211	1420	0.148591549295775	0.148091452258218	0.154485426670656	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-27T13:49:05.616113Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
473e7e6c-a4ea-4c9d-a1bf-551756cda128	2026-08-27 09:44	2026-08-27 09:44	2026-08-27 09:44	DIA	DIA260828P00533000	put	533.0000	2026-08-28	1.0900	1.0900	1.1900	534.5600	27250.00	0.00	27250.00	250	21	348	997	0.349047141424273	0.150907045853013	0.159927806959746	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
2631aef9-4c5f-4c3e-bb88-b30656c1d733	2026-08-27 09:30	2026-08-27 09:30	2026-08-27 09:30	DIA	DIA260828C00534000	call	534.0000	2026-08-28	1.5400	1.5400	1.6300	533.3500	10626.00	0.00	10626.00	69	12	102	649	0.157164869029276	0.163486697952088	0.163486697952088	false	false	false	true
393eb15e-f7eb-4625-9ad0-afd69590d75c	2026-08-26 15:22	2026-08-26 15:22	2026-08-26 15:22	DIA	DIA260925P00500000	put	500.0000	2026-09-25	0.9500	0.9500	1.0300	534.6300	13680.00	0.00	13680.00	144	26	154	17	9.05882352941176	0.174727793012367	0.174727793012367	false	false	false	true
d509b263-da0d-4ecc-862a-ffceec9b4daf	2026-08-26 14:23	2026-08-26 14:23	2026-08-26 14:23	DIA	DIA260918P00550000	put	550.0000	2026-09-18	16.7000	16.5000	16.9000	534.1600	83500.00	31730.00	35070.00	50	9	100	58	1.72413793103448	0.133351379737205	0.133351379737205	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
ad9d3af8-64af-411f-9ffb-3568cb71c49f	2026-08-26 13:38	2026-08-26 13:38	2026-08-26 13:38	DIA	DIA260828C00540000	call	540.0000	2026-08-28	0.4200	0.4100	0.4500	534.2600	14028.00	42.00	13986.00	334	25	646	2792	0.231375358166189	0.136382906020407	0.136382906020407	false	false	false	true
5d608e61-9301-4bbc-a44e-2287c4bd44ae	2026-08-26 13:30	2026-08-26 13:30	2026-08-26 13:30	DIA	DIA260828C00535000	call	535.0000	2026-08-28	2.0000	2.0000	2.0000	534.2300	60000.00	0.00	0.00	300	5	869	970	0.895876288659794	0.146619838597914	0.146619838597914	false	false	false	true
e0d2429b-91ee-4825-ae8e-7520e6382b66	2026-08-26 13:15	2026-08-26 13:15	2026-08-26 13:15	DIA	DIA260911P00533000	put	533.0000	2026-09-11	4.3000	4.2500	4.4000	534.0500	58068.00	7740.00	50328.00	135	5	282	221	1.27601809954751	0.117019312213211	0.117019312213211	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
14b13d86-d1dc-46cc-ba23-de39f8e77e2b	2026-08-26 09:56	2026-08-26 09:56	2026-08-26 09:56	DIA	DIA260828C00515000	call	515.0000	2026-08-28	20.8500	20.6000	20.8500	535.5700	27105.00	27105.00	0.00	13	5	13	94	0.138297872340426	0.298411411723658	0.298411411723658	false	false	false	true
ae56576b-5d9b-4fca-b7f7-9963718bf456	2026-08-26 09:50	2026-08-26 09:50	2026-08-26 09:50	DIA	DIA260925P00507000	put	507.0000	2026-09-25	1.4500	1.4500	1.5400	534.8800	102515.00	0.00	102515.00	707	19	717	8	89.625	0.167160865580652	0.167160865580652	false	false	false	true
875f58e8-0ae6-4f41-80d7-ca54d6867466	2026-08-26 09:46	2026-08-26 09:46	2026-08-26 09:46	DIA	DIA260904P00534000	put	534.0000	2026-09-04	3.2000	3.0500	3.2500	535.6900	64310.00	64310.00	0.00	201	14	227	134	1.69402985074627	0.125534821238112	0.125534821238112	false	false	false	true
1c2c16d0-5604-424e-97e9-f9dc6f013c57	2026-08-26 09:46	2026-08-26 09:46	2026-08-26 09:46	DIA	DIA260904P00536000	put	536.0000	2026-09-04	4.0000	3.8500	4.0500	535.6900	78000.00	76000.00	2000.00	195	21	227	107	2.1214953271028	0.122039373825579	0.122039373825579	false	false	false	true
e7a8cddc-87c7-409c-afe0-a81b0f399ffb	2026-08-26 09:46	2026-08-26 09:46	2026-08-26 09:46	DIA	DIA260904P00537000	put	537.0000	2026-09-04	4.4000	4.2500	4.4500	535.6900	18040.00	18040.00	0.00	41	5	42	75	0.56	0.118594227531448	0.118594227531448	false	false	false	true
d38cb960-c3a0-49b2-8d1e-3beede3e5589	2026-08-26 09:43	2026-08-26 09:43	2026-08-26 09:43	DIA	DIA260904C00537000	call	537.0000	2026-09-04	3.8000	3.6500	3.8000	535.8700	82820.00	82820.00	0.00	218	19	316	228	1.3859649122807	0.125665611509887	0.122260114463084	false	false	false	true
ae3aea1b-2669-4e63-b24c-de60d9fa731e	2026-08-26 09:38	2026-08-26 09:37	2026-08-26 09:37	DIA	DIA260828C00537000	call	537.0000	2026-08-28	1.7300	1.6500	1.7500	535.2600	18511.00	17473.00	1038.00	107	24	193	633	0.304897314375987	0.157401702625975	0.155325536109793	false	false	false	true
89d58926-ce82-4cc3-8958-5cfa31a5136e	2026-08-26 09:38	2026-08-26 09:37	2026-08-26 09:37	DIA	DIA260904C00539000	call	539.0000	2026-09-04	2.6800	2.6000	2.6800	535.2600	31088.00	31088.00	0.00	116	17	116	101	1.14851485148515	0.122750077623535	0.121801919151515	false	false	false	true
5061940b-7fcf-418b-8ef6-cc31674250d8	2026-08-26 09:38	2026-08-26 09:37	2026-08-26 09:37	DIA	DIA260904C00537000	call	537.0000	2026-09-04	3.6000	3.5000	3.6000	535.2600	35280.00	35280.00	0.00	98	12	98	228	0.429824561403509	0.125912904678688	0.124818900788378	false	false	false	true
28a0569c-e895-4b46-8f6a-dbba0aa36909	2026-08-26 09:38	2026-08-26 09:37	2026-08-26 09:37	DIA	DIA260828C00536000	call	536.0000	2026-08-28	2.1900	2.1000	2.2100	535.2600	11382.00	10074.00	1308.00	52	6	53	209	0.253588516746411	0.15988577756929	0.156910120158505	false	false	false	true
16c85ce3-791b-41d6-bd70-e36609aa8159	2026-08-25 15:53	2026-08-25 15:53	2026-08-25 15:53	DIA	DIA260904C00533000	call	533.0000	2026-09-04	6.0500	6.0000	6.1000	535.3400	12705.00	3025.00	6655.00	21	5	52	193	0.269430051813472	0.126360681710163	0.126360681710163	false	false	false	true
612412b7-1aba-4bb0-8b12-a3e622db3064	2026-08-25 15:42	2026-08-25 15:42	2026-08-25 15:42	DIA	DIA260904C00542000	call	542.0000	2026-09-04	1.7000	1.6600	1.7000	535.4200	10370.00	10370.00	0.00	61	14	130	317	0.410094637223975	0.113378262766623	0.112817801420615	false	false	false	true
25533867-1f78-4b4f-b582-f24318fdc9fd	2026-08-25 15:42	2026-08-25 15:42	2026-08-25 15:42	DIA	DIA260904C00538000	call	538.0000	2026-09-04	3.2500	3.1500	3.2500	535.3600	26000.00	26000.00	0.00	80	12	88	122	0.721311475409836	0.118836737960243	0.118836737960243	false	false	false	true
18c29078-96c4-4530-ab22-6ec325016028	2026-08-25 14:49	2026-08-25 14:49	2026-08-25 14:49	DIA	DIA260828C00535000	call	535.0000	2026-08-28	2.8600	2.8200	2.8600	535.2200	57200.00	57200.00	0.00	200	11	1248	530	2.35471698113208	0.137577282540615	0.137577282540615	false	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
52dbd431-9027-4d20-9705-5361695a600a	2026-08-25 13:14	2026-08-25 13:14	2026-08-25 13:14	DIA	DIA270319C00575000	call	575.0000	2027-03-19	10.5500	8.6000	10.5500	534.4300	15825.00	15825.00	0.00	15	5	15	6	2.5	0.131576127565616	0.131576127565616	false	false	false	true
8ad5258a-3950-434b-b0d2-d5775e117da0	2026-08-25 13:08	2026-08-25 13:08	2026-08-25 13:08	DIA	DIA261218P00536000	put	536.0000	2026-12-18	15.7500	15.6000	15.7500	534.3050	22050.00	22050.00	0.00	14	10	17	22	0.772727272727273	0.151779455557254	0.151779455557254	false	false	false	true
cb5e3148-d96f-4ee3-9638-be89de6bb592	2026-08-25 12:59	2026-08-25 12:59	2026-08-25 12:59	DIA	DIA260904C00539000	call	539.0000	2026-09-04	2.5800	2.5300	2.5800	534.7300	10578.00	10578.00	0.00	41	6	60	54	1.11111111111111	0.118123674302088	0.117849460367118	false	false	false	true
27c8082c-2c26-41b0-8c91-422f4bfca1fe	2026-08-25 12:13	2026-08-25 12:13	2026-08-25 12:13	DIA	DIA260918C00545000	call	545.0000	2026-09-18	2.6800	2.6100	2.6800	534.4000	13400.00	13400.00	0.00	50	8	251	6306	0.0398033618775769	0.113230659092951	0.113230659092951	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
d50f992f-974b-43b1-aa04-24479abbf45d	2026-08-25 11:35	2026-08-25 11:35	2026-08-25 11:35	DIA	DIA260828C00532500	call	532.5000	2026-08-28	3.7500	3.7500	3.9000	534.0200	14250.00	0.00	14250.00	38	9	76	99	0.767676767676768	0.14113234338937	0.146623735541542	false	false	false	true
fcb77514-79c5-4716-add5-a58ec2626d2a	2026-08-25 11:35	2026-08-25 11:35	2026-08-25 11:35	DIA	DIA260911C00537000	call	537.0000	2026-09-11	4.5000	4.3500	4.5000	534.0100	28350.00	28350.00	0.00	63	6	92	46	2	0.118548908460724	0.118548908460724	false	false	false	true
caa7f7d1-2c72-4ee6-a1fb-84d09bbc18e2	2026-08-25 11:35	2026-08-25 11:35	2026-08-25 11:35	DIA	DIA260904C00535000	call	535.0000	2026-09-04	4.2000	4.1000	4.2000	534.0100	11340.00	11340.00	0.00	27	6	58	548	0.105839416058394	0.125126133556355	0.125126133556355	false	false	false	true
9a3c349c-75a8-4044-b843-7f5b4ac72f23	2026-08-25 11:35	2026-08-25 11:35	2026-08-25 11:35	DIA	DIA260918C00541000	call	541.0000	2026-09-18	3.9500	3.7500	3.9500	534.0100	29610.00	29610.00	0.00	75	8	77	30	2.56666666666667	0.116152624742461	0.115183016600087	false	false	false	true
3dc47816-e7a5-4e9b-81fb-91613d6aaf71	2026-08-25 10:56	2026-08-25 10:56	2026-08-25 10:56	DIA	DIA260828C00535000	call	535.0000	2026-08-28	2.3400	2.3400	2.3400	533.9500	117000.00	0.00	0.00	500	5	937	530	1.76792452830189	0.142759135109929	0.142759135109929	false	false	false	true
9fe0d45c-c86a-4568-b553-3bff89d39d6b	2026-08-25 10:34	2026-08-25 10:34	2026-08-25 10:34	DIA	DIA271217P00520000	put	520.0000	2027-12-17	26.7000	24.1500	28.5000	534.3100	475270.00	472600.00	2670.00	178	8	180	8	22.5	0.191838900868788	0.191377838028966	false	false	false	true
999fc543-254c-420e-86d2-de8952ea46d1	2026-08-25 10:31	2026-08-25 10:31	2026-08-25 10:31	DIA	DIA280121P00230000	put	230.0000	2028-01-21	1.5000	1.1400	2.9700	533.8605	23250.00	750.00	22500.00	155	5	775	353	2.19546742209632	0.389958037833915	0.389958037833915	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
855c1d55-cde8-4c96-bb4d-e533c5a9da97	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	DIA	DIA260828C00532500	call	532.5000	2026-08-28	3.8500	3.7000	3.8500	533.9900	13090.00	13090.00	0.00	34	7	36	99	0.363636363636364	0.152898651334339	0.152898651334339	false	false	false	true
e5eaeba5-d98a-4318-a177-1504fbb8fa8e	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	DIA	DIA260828P00535000	put	535.0000	2026-08-28	3.3500	2.3900	3.3500	533.6950	10385.00	10385.00	0.00	31	6	154	407	0.378378378378378	0.141970367827682	0.141970367827682	true	false	false	true
4d77c82d-0c6f-41ce-b28c-66d6b3575edc	2026-08-25 10:17	2026-08-25 10:17	2026-08-25 10:17	DIA	DIA260828C00535000	call	535.0000	2026-08-28	2.5600	2.5400	2.6100	534.4100	25600.00	0.00	25600.00	100	5	349	530	0.658490566037736	0.143076310508852	0.143076310508852	false	false	false	true
e4e831be-7fce-4542-aa5e-c49d59e421dc	2026-08-25 09:46	2026-08-25 09:46	2026-08-25 09:46	DIA	DIA260911C00537000	call	537.0000	2026-09-11	4.5000	4.5000	4.6000	534.1600	12150.00	0.00	12150.00	27	7	27	46	0.58695652173913	0.117076304744209	0.117076304744209	false	false	false	true
dd79c4ed-0c7f-4591-9a0c-89ae502a92ee	2026-08-25 09:33	2026-08-25 09:33	2026-08-25 09:33	DIA	DIA260918C00550000	call	550.0000	2026-09-18	1.6100	1.6000	1.7500	534.6800	16101.00	162.00	15939.00	100	18	100	1096	0.0912408759124088	0.113047038488332	0.113314667491797	true	false	false	true
f79ec921-8a96-4346-9bc9-393394e67fc6	2026-08-25 09:32	2026-08-25 09:32	2026-08-25 09:32	DIA	DIA260828C00532000	call	532.0000	2026-08-28	4.5000	4.5000	5.2500	534.7700	13500.00	0.00	13500.00	30	10	30	213	0.140845070422535	0.144640907973336	0.144640907973336	false	false	false	true
34cbe710-684b-4259-b41f-6378d8a1ecf4	2026-08-25 09:32	2026-08-25 09:32	2026-08-25 09:32	DIA	DIA260828C00535000	call	535.0000	2026-08-28	2.7100	2.7100	3.1500	534.8500	10843.00	0.00	10027.00	40	11	50	530	0.0943396226415094	0.139664739983928	0.139664739983928	false	false	false	true
b2d9dd9a-9012-457c-a29b-f59afea3f4f6	2026-08-25 09:30	2026-08-25 09:30	2026-08-25 09:30	DIA	DIA280121P00260000	put	260.0000	2028-01-21	2.0000	2.0000	4.5500	535.5000	83400.00	0.00	83400.00	417	8	417	5	83.4	0.359791289452712	0.359791289452712	false	false	false	true
3a723ee6-6794-4a1f-bec2-7a73f81829b0	2026-08-25 09:30	2026-08-25 09:30	2026-08-25 09:30	DIA	DIA271217P00265000	put	265.0000	2027-12-17	2.0000	2.0000	4.8000	535.5000	52601.00	0.00	52601.00	263	8	263	1	263	0.362814421149507	0.362814421149507	false	false	false	true
e461103a-5924-48cb-9548-6c527b2318d8	2026-08-24 15:39	2026-08-24 15:39	2026-08-24 15:39	DIA	DIA260925C00527000	call	527.0000	2026-09-25	12.7500	12.6500	12.9000	533.8300	12750.00	3825.00	6375.00	10	5	90	154	0.584415584415584	0.123278106516098	0.123278106516098	false	false	false	true