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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = AR×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	pricenumeric

c4957e0a-1bcb-4ef5-ba6c-f9f7ce418588	2026-08-17 11:21	2026-08-17 11:21	2026-08-17 11:21	AR	AR261120C00044000	call	44.0000	2026-11-20	0.6800	0.6500	0.8000	36.2300	11242.00	0.00	11242.00	166	22	401	3415	0.117423133235725	0.369560629378853	0.369560629378853	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	11713425900.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ae70dba8-cc2d-4e02-981c-6c6e75834f0a	2026-08-17 13:35	2026-08-17 13:35	2026-08-17 13:35	AR	AR260821P00037000	put	37.0000	2026-08-21	1.0000	0.9500	1.0000	36.2300	42500.00	42500.00	0.00	425	10	540	2216	0.243682310469314	0.353906044341098	0.353906044341098	false	false	false	true	false
d9269040-2da6-4380-9ccc-d392e4082b25	2026-08-18 15:45	2026-08-18 15:45	2026-08-18 15:45	AR	AR270115C00046000	call	46.0000	2027-01-15	1.1000	1.0000	1.1500	37.3025	11000.00	11000.00	0.00	100	5	101	50	2.02	0.365194006526295	0.365194006526295	false	false	false	true	false
3e3e3b08-4cc3-442a-909f-4eb032f223a9	2026-08-21 13:11	2026-08-21 13:11	2026-08-21 13:11	AR	AR280121P00037000	put	37.0000	2028-01-21	5.2000	5.0000	5.2000	38.0100	15600.00	15600.00	0.00	30	8	30	142	0.211267605633803	0.387970881708721	0.387970881708721	true	false	false	true	false
1460b231-d88a-4659-bb79-4069cf696969	2026-08-21 14:04	2026-08-21 14:04	2026-08-21 14:04	AR	AR260821C00033500	call	33.5000	2026-08-21	4.5000	3.9000	4.5000	37.0000	45000.00	45000.00	0.00	100	5	100	178	0.561797752808989	3.50610794449923	3.50610794449923	false	false	false	true	false
9eb57bd5-a94b-465f-a830-88bcf768732c	2026-08-26 12:04	2026-08-26 12:03	2026-08-26 12:03	AR	AR261016C00040000	call	40.0000	2026-10-16	1.6000	1.5500	1.6500	38.7700	16000.00	2400.00	13600.00	100	7	106	52	2.03846153846154	0.353560968911924	0.353560968911924	false	false	false	true	false
437d6a38-93ef-4b7d-ada6-a897f5fa76a8	2026-08-26 12:33	2026-08-26 12:33	2026-08-26 12:33	AR	AR260925P00037000	put	37.0000	2026-09-25	0.7000	0.6500	0.7000	38.7400	17074.00	17074.00	0.00	244	24	370	58	6.37931034482759	0.333517435636931	0.333517435636931	false	false	false	true	false
1dcc791e-27a8-41d2-91e7-f665ad068857	2026-08-26 13:19	2026-08-26 13:19	2026-08-26 13:19	AR	AR280121C00035000	call	35.0000	2028-01-21	9.8000	9.5000	11.3000	38.8081	29400.00	12740.00	16660.00	30	5	33	1012	0.0326086956521739	0.395690817383741	0.395690817383741	false	false	false	true	false
49d074f4-33d6-445d-b1c3-2289170d814e	2026-08-28 15:37	2026-08-28 15:37	2026-08-28 15:37	AR	AR261016C00041000	call	41.0000	2026-10-16	1.0500	1.0500	1.1000	38.4550	22050.00	0.00	22050.00	210	29	218	38	5.73684210526316	0.346551053782152	0.346551053782152	false	false	false	true	false
cc8307e9-b6d7-4a48-9c50-3cd46c8c29ec	2026-09-02 14:32	2026-09-02 14:32	2026-09-02 14:32	AR	AR261120P00040000	put	40.0000	2026-11-20	2.6000	2.5000	2.6500	39.9700	14300.00	14300.00	0.00	55	12	97	113	0.858407079646018	0.372767027388372	0.372767027388372	false	false	false	true	false
6f889f16-7f6d-4f85-b28c-d991b266f1ea	2026-09-03 11:16	2026-09-03 11:16	2026-09-03 11:16	AR	AR261120P00040000	put	40.0000	2026-11-20	2.6000	2.5000	2.6500	39.9500	24179.00	18459.00	5720.00	93	17	113	273	0.413919413919414	0.374847664583978	0.373619948615636	false	false	false	true	false
3f1ff593-67cb-4577-8656-e0fa3d02293f	2026-09-08 13:03	2026-09-08 13:03	2026-09-08 13:03	AR	AR261120C00040000	call	40.0000	2026-11-20	2.6000	2.6000	2.6500	39.5300	35620.00	0.00	35620.00	137	31	140	291	0.481099656357388	0.379477576784415	0.379477576784415	false	false	false	true	false
f57db614-7107-4a30-980a-1222f72cfeb0	2026-09-08 13:14	2026-09-08 13:14	2026-09-08 13:14	AR	AR280121P00040000	put	40.0000	2028-01-21	6.1000	5.8000	6.1000	39.3900	36584.00	36584.00	0.00	60	12	61	354	0.172316384180791	0.388499192445248	0.387032675701016	false	false	false	true	false
7f84bac8-2f4a-43a9-9dea-c0e56b628e80	2026-09-10 12:22	2026-09-10 12:22	2026-09-10 12:22	AR	AR270219C00045000	call	45.0000	2027-02-19	2.2000	2.1500	2.2000	39.2300	42460.00	42460.00	0.00	193	10	235	56	4.19642857142857	0.38524776060123	0.38524776060123	false	false	false	true	false
6cc945ed-1002-40f4-9f8d-3927511dd2b0	2026-09-10 12:22	2026-09-10 12:22	2026-09-10 12:22	AR	AR270115C00047000	call	47.0000	2027-01-15	1.3000	1.2500	1.3000	39.2300	15990.00	15990.00	0.00	123	14	123	35	3.51428571428571	0.386645628756994	0.386645628756994	false	false	false	true	false
03ef1ebf-819b-4fc5-8cbf-1e82e5ff5ff7	2026-09-10 12:31	2026-09-10 12:31	2026-09-10 12:31	AR	AR270115C00042000	call	42.0000	2027-01-15	2.7500	2.6500	2.8000	39.4800	259325.00	12650.00	246675.00	943	15	952	326	2.92024539877301	0.38531481891249	0.38531481891249	false	false	false	true	false
ecba38e5-2a0b-40a4-8a46-74f32851a051	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	AR	AR260918C00037000	call	37.0000	2026-09-18	1.3000	1.3000	1.3500	38.1000	13392.00	0.00	13392.00	103	12	124	926	0.133909287257019	0.369604661904921	0.369604661904921	false	false	false	true	false
0dd99b57-3d49-47be-8a60-b4aa60b25af0	2026-09-15 14:04	2026-09-15 14:04	2026-09-15 14:04	AR	AR270115C00042000	call	42.0000	2027-01-15	2.5500	2.5500	2.6500	39.1750	27795.00	0.00	27795.00	109	16	116	1275	0.0909803921568627	0.38385061298924	0.38385061298924	false	false	false	true	false
fe64f9b3-465e-4731-98a8-b1e1e92a231a	2026-09-16 10:50	2026-09-16 10:50	2026-09-16 10:50	AR	AR260918C00036500	call	36.5000	2026-09-18	0.7500	0.6500	0.7500	36.9500	11475.00	11475.00	0.00	153	15	153	3	51	0.449327286200445	0.449327286200445	false	false	false	true	false
56b2bb0f-2b73-44d2-b87a-2ccdbc625115	2026-09-16 12:05	2026-09-16 12:04	2026-09-16 12:04	AR	AR270115C00045000	call	45.0000	2027-01-15	1.0000	1.0000	1.0500	36.8350	10300.00	0.00	10300.00	103	9	106	3662	0.0289459311851447	0.385263584406426	0.385263584406426	false	false	false	true	false
e7adace1-24c5-4a9a-83ab-80971425ae96	2026-09-16 12:51	2026-09-16 12:51	2026-09-16 12:51	AR	AR270115C00042000	call	42.0000	2027-01-15	1.7000	1.7000	1.7500	37.0499	31280.00	0.00	31280.00	184	20	221	1377	0.160493827160494	0.384576280812963	0.384576280812963	false	false	false	true	false
97c8bb0c-693d-4ce6-b956-2fa89b859d19	2026-09-17 10:38	2026-09-17 10:38	2026-09-17 10:38	AR	AR270115C00040000	call	40.0000	2027-01-15	1.7500	1.7500	1.8500	35.7400	57575.00	0.00	57575.00	329	30	332	4523	0.0734026088879063	0.381905350012809	0.381905350012809	false	false	false	true	false
702ec1dd-ebf8-4a3d-802a-39088a6d2eff	2026-09-17 10:38	2026-09-17 10:38	2026-09-17 10:38	AR	AR270115C00042000	call	42.0000	2027-01-15	1.2500	1.2500	1.3500	35.7400	17375.00	0.00	17375.00	139	16	139	1479	0.0939824205544287	0.381226390289459	0.381226390289459	false	false	false	true	false
78b9b663-89f9-4885-a15d-35d1361cb18f	2026-09-17 11:37	2026-09-17 11:37	2026-09-17 11:37	AR	AR270115C00041000	call	41.0000	2027-01-15	1.5000	1.5000	1.6000	35.7450	17260.00	0.00	17260.00	115	14	119	154	0.772727272727273	0.3837309283687	0.3837309283687	false	false	false	true	false
2bb1113c-e2a7-43ef-82fa-84f1401b5f00	2026-09-17 11:37	2026-09-17 11:37	2026-09-17 11:37	AR	AR270115C00038000	call	38.0000	2027-01-15	2.4000	2.4000	2.4500	35.7450	32400.00	0.00	32400.00	135	20	211	443	0.476297968397291	0.381784210772489	0.381784210772489	false	false	false	true	false
c5c188a4-42ea-4156-b9e7-ef127d303778	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	AR	AR270115C00045000	call	45.0000	2027-01-15	0.7000	0.6000	0.7000	35.1100	14000.00	14000.00	0.00	200	7	222	3839	0.057827559260224	0.39782878169132	0.39782878169132	false	false	false	true	false
20069588-aeac-455b-bbf5-741b29f35eab	2026-09-21 10:59	2026-09-21 10:59	2026-09-21 10:59	AR	AR261016P00033000	put	33.0000	2026-10-16	0.8000	0.7500	0.8500	33.7800	20000.00	2800.00	17200.00	250	11	513	321	1.5981308411215	0.34031650515493	0.34031650515493	false	false	false	true	false
55588151-bf2e-4688-9329-9c8558ba1351	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	AR	AR270115P00033000	put	33.0000	2027-01-15	2.2500	2.2000	2.3000	33.0000	12825.00	0.00	10125.00	57	5	58	385	0.150649350649351	0.378093883130598	0.378093883130598	false	false	false	true	false
42bf9fda-d720-44fd-bb27-dccf04bf6e89	2026-09-21 15:32	2026-09-21 15:32	2026-09-21 15:32	AR	AR261120C00035000	call	35.0000	2026-11-20	1.8000	1.7500	1.8500	33.0000	29340.00	29160.00	0.00	163	8	253	343	0.737609329446064	0.393307203199438	0.391580956388287	false	false	false	true	false
7dd1c815-33f6-4ce5-a153-118b17a51a87	2026-09-22 12:57	2026-09-22 12:57	2026-09-22 12:57	AR	AR261120P00035000	put	35.0000	2026-11-20	2.1000	2.0500	2.2000	34.7250	68040.00	210.00	67830.00	324	40	497	818	0.60757946210269	0.373208741233369	0.373208741233369	false	false	false	true	false