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:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = APA×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strike

dbb7656e-bcba-4aea-8878-1ae1813692fe	2026-10-01 15:49	2026-10-01 15:49	2026-10-01 15:49	APA	APA261120C00045000	call	45.0000	2026-11-20	2.3000	2.3000	2.3500	43.3500	14490.00	0.00	14490.00	63	19	131	244	0.536885245901639	0.453346152540751	0.453346152540751	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	15184234443.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:52:25.884700Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
2e121d6a-c25b-4f57-8557-b853cff6dc44	2026-10-01 13:19	2026-10-01 13:19	2026-10-01 13:19	APA	APA270115P00040000	put	40.0000	2027-01-15	2.6400	2.5900	2.7000	42.8350	27985.00	265.00	27720.00	106	31	203	1426	0.142356241234222	0.463691711387575	0.464892534422941	false	false	false
be87b251-b65b-41ce-801d-863e9711113f	2026-10-01 12:24	2026-10-01 12:24	2026-10-01 12:24	APA	APA270115P00042500	put	42.5000	2027-01-15	3.8500	3.8500	3.9000	42.0000	43890.00	0.00	43890.00	114	25	137	752	0.18218085106383	0.467666555425708	0.467666555425708	false	false	false
9f1fb49a-9774-49c0-a634-7326fe32a383	2026-10-01 10:24	2026-10-01 10:24	2026-10-01 10:24	APA	APA261016P00044000	put	44.0000	2026-10-16	2.1600	2.0300	2.2100	42.7750	44064.00	2592.00	41472.00	204	7	204	311	0.655948553054662	0.432160042406361	0.432160042406361	false	false	false
71ed21c7-5f18-4afa-8fee-fbc2d7bddee8	2026-09-30 15:18	2026-09-30 15:18	2026-09-30 15:18	APA	APA261016C00042500	call	42.5000	2026-10-16	1.2000	1.1300	1.2900	41.0000	42121.00	120.00	41880.00	351	14	355	4163	0.0852750420369926	0.440353149729759	0.440353149729759	true	false	false
f342f46f-4629-42fd-b2fe-a70eb94c058f	2026-09-30 12:01	2026-09-30 12:01	2026-09-30 12:01	APA	APA261218C00047500	call	47.5000	2026-12-18	1.9200	1.8700	1.9600	42.6200	32640.00	26688.00	5952.00	170	5	246	803	0.306351183063512	0.449666419714242	0.449185010919459	false	false	false
7ce970c2-8743-473e-ae8e-a853a7b53e91	2026-09-30 11:56	2026-09-30 11:56	2026-09-30 11:56	APA	APA261016P00042500	put	42.5000	2026-10-16	1.4600	1.4300	1.5500	42.0000	270100.00	0.00	270100.00	1850	4	1850	3027	0.611166171126528	0.432915176366008	0.432915176366008	false	true	false
4d26540a-f79d-496b-a103-8a6abaa0de31	2026-09-29 13:51	2026-09-29 13:51	2026-09-29 13:51	APA	APA270115P00037500	put	37.5000	2027-01-15	1.9200	1.9200	2.0200	42.0400	15168.00	0.00	15168.00	79	22	239	398	0.600502512562814	0.459887765668263	0.459887765668263	false	false	false
d8465b3c-4837-441f-bf3b-397f290f75f1	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	APA	APA270115P00035000	put	35.0000	2027-01-15	1.2000	1.1800	1.2900	42.2300	16561.00	120.00	16320.00	138	24	207	1086	0.19060773480663	0.469039911412859	0.4699378477036	false	false	false
c3c18030-40d5-4f45-a37f-6218c8308776	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	APA	APA270115P00037500	put	37.5000	2027-01-15	1.9100	1.9100	2.0200	42.2000	20437.00	0.00	20437.00	107	17	117	398	0.293969849246231	0.464158714494611	0.464158714494611	false	false	false
6b5ca90a-2fe2-4ba7-bc32-3b3fec84c9c5	2026-09-29 10:54	2026-09-29 10:54	2026-09-29 10:54	APA	APA261016P00043000	put	43.0000	2026-10-16	1.9600	1.9500	1.9600	42.3200	40572.00	40572.00	0.00	207	29	215	39	5.51282051282051	0.447953119163454	0.447953119163454	false	false	false
1026cc1a-da65-4299-978b-86066d82ee77	2026-09-28 12:33	2026-09-28 12:32	2026-09-28 12:32	APA	APA261016C00040500	call	40.5000	2026-10-16	3.2000	3.1500	3.2000	42.8000	11520.00	11520.00	0.00	36	12	36	30	1.2	0.477634344708672	0.477634344708672	false	false	false
b1c9d99a-6606-4e23-8cdb-b35cc4b3dbd9	2026-09-28 12:17	2026-09-28 12:16	2026-09-28 12:16	APA	APA261002P00043000	put	43.0000	2026-10-02	1.0600	0.9600	1.0600	42.7500	14416.00	14416.00	0.00	136	19	136	202	0.673267326732673	0.52515107285214	0.52515107285214	false	false	false
3b487aed-6885-41c8-bb0f-aa486f942750	2026-09-25 10:20	2026-09-25 10:20	2026-09-25 10:20	APA	APA261016C00042500	call	42.5000	2026-10-16	2.1500	2.0100	2.2000	43.0400	22575.00	1290.00	21285.00	105	5	112	4045	0.0276885043263288	0.443755138212946	0.443755138212946	false	false	false
8deaf101-f4c5-4352-872c-d48b0203e552	2026-09-25 10:12	2026-09-25 10:11	2026-09-25 10:11	APA	APA261218C00055000	call	55.0000	2026-12-18	0.7800	0.7800	0.8400	43.0600	10062.00	0.00	10062.00	129	36	129	301	0.428571428571429	0.459486797343412	0.459486797343412	false	false	false
ccccb893-8061-4092-af49-50a4f00b154a	2026-09-24 09:57	2026-09-24 09:57	2026-09-24 09:57	APA	APA261016C00042500	call	42.5000	2026-10-16	3.1000	2.8800	3.2500	44.4300	30070.00	310.00	29760.00	97	5	101	3956	0.025530839231547	0.450645542658576	0.450645542658576	false	false	false
db0c85ec-4838-4b3e-a264-7ed5062a63dd	2026-09-24 09:46	2026-09-24 09:46	2026-09-24 09:46	APA	APA261002C00047000	call	47.0000	2026-10-02	0.3900	0.1900	0.4700	44.2800	31395.00	1170.00	30225.00	805	18	825	160	5.15625	0.489631813169391	0.489631813169391	false	false	false
a9794ceb-0ab7-46c7-b094-a728339424a4	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3500	1.3500	1.3900	43.7500	49815.00	0.00	49815.00	369	13	1589	1312	1.21112804878049	0.453205791199614	0.453205791199614	true	false	false
e630a69f-ad14-4fda-a041-ada50587b5b2	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3400	1.3400	1.3500	43.7450	16348.00	0.00	16348.00	122	17	1085	1312	0.826981707317073	0.450346865445716	0.450346865445716	true	false	false
7d55b6b2-8fac-49a6-b90a-ba1726b5375e	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3300	1.3300	1.3500	43.7500	24472.00	0.00	24472.00	184	10	855	1312	0.651676829268293	0.448377732451776	0.448377732451776	true	false	false
4a0401e6-9c79-478b-b852-aa1b8e15627f	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3400	1.3400	1.3500	43.7450	14472.00	0.00	14472.00	108	16	963	1312	0.733993902439024	0.450346865445716	0.450346865445716	true	false	false
df1bf284-42c4-4f8a-a35e-357604b5d5ae	2026-09-23 15:52	2026-09-23 15:52	2026-09-23 15:52	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3000	1.2600	1.3600	43.8050	63180.00	0.00	63180.00	486	10	668	1312	0.509146341463415	0.44599171673138	0.44599171673138	false	false	false
65290167-cf74-4407-a271-3b8e52235ea6	2026-09-23 14:34	2026-09-23 14:34	2026-09-23 14:34	APA	APA261016C00050000	call	50.0000	2026-10-16	0.3200	0.2900	0.3400	43.7600	11552.00	32.00	11520.00	361	17	383	2167	0.176742039686202	0.449079414029445	0.449079414029445	false	false	false
50f23dcf-05b8-4070-a19c-e6ec979617e3	2026-09-23 12:47	2026-09-23 12:47	2026-09-23 12:47	APA	APA261016P00042500	put	42.5000	2026-10-16	1.2300	1.1600	1.2300	43.9200	14514.00	14514.00	0.00	118	5	176	1312	0.134146341463415	0.439000402783732	0.439000402783732	false	false	false
1c1191c7-6759-4d0e-9697-04fb517bd55e	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	APA	APA260925P00041500	put	41.5000	2026-09-25	0.3600	0.2400	0.4900	42.7100	17964.00	17928.00	36.00	499	31	520	49	10.6122448979592	0.55116408617263	0.546949004648761	false	false	false
3883671c-181f-43ac-8252-f78ddc008556	2026-09-22 10:51	2026-09-22 10:50	2026-09-22 10:50	APA	APA261120P00037500	put	37.5000	2026-11-20	1.0200	1.0200	1.0800	43.1800	14790.00	0.00	14790.00	145	22	146	3	48.6666666666667	0.487039426697267	0.487039426697267	false	false	false
b368a934-206f-4ffc-b188-8e0a7e2f6665	2026-09-21 13:05	2026-09-21 13:05	2026-09-21 13:05	APA	APA270115P00045000	put	45.0000	2027-01-15	5.0000	5.0000	5.1000	43.7800	64500.00	0.00	64500.00	129	8	196	319	0.614420062695925	0.47386553860522	0.47386553860522	false	false	false
b0bac049-9e36-474b-82b2-8ee075890f3d	2026-09-21 10:52	2026-09-21 10:52	2026-09-21 10:52	APA	APA261218P00037500	put	37.5000	2026-12-18	1.3700	1.3700	1.4800	43.7300	25619.00	0.00	25619.00	187	28	189	184	1.02717391304348	0.480921878779805	0.480921878779805	false	false	false
6916bfe5-56a2-4eee-9aec-63500e0e2204	2026-09-18 15:03	2026-09-18 15:03	2026-09-18 15:03	APA	APA260925P00047000	put	47.0000	2026-09-25	2.3400	2.3250	2.3900	45.0200	26676.00	0.00	26676.00	114	6	164	24	6.83333333333333	0.435668816062649	0.435668816062649	false	false	false
f24b7577-bb3c-4ea2-831a-1aeaee860361	2026-09-18 14:53	2026-09-18 14:53	2026-09-18 14:53	APA	APA261218C00050000	call	50.0000	2026-12-18	2.4500	2.4500	2.5800	45.1150	34300.00	0.00	34300.00	140	36	163	1147	0.142109851787271	0.455776461582216	0.455776461582216	false	false	false
69083b73-0295-45ca-9904-39f51724fb05	2026-09-18 14:53	2026-09-18 14:53	2026-09-18 14:53	APA	APA261218C00045000	call	45.0000	2026-12-18	4.3500	4.3250	4.4000	45.1150	82215.00	0.00	82215.00	189	16	216	5069	0.0426119550207141	0.45455775702414	0.45455775702414	false	false	false
6eb1923f-3036-47bf-ad63-f9bae84359e7	2026-09-18 10:42	2026-09-18 10:42	2026-09-18 10:42	APA	APA260918P00045000	put	45.0000	2026-09-18	0.1900	0.1900	0.3000	45.1300	11286.00	0.00	11286.00	594	49	594	1604	0.370324189526185	0.565880706576136	0.565880706576136	false	false	false
b4b13b5c-c839-4240-8f6c-446628bfe2d6	2026-09-17 14:33	2026-09-17 14:32	2026-09-17 14:32	APA	APA261218C00047500	call	47.5000	2026-12-18	3.5000	3.5000	3.6000	45.4000	35700.00	0.00	35700.00	102	29	105	695	0.151079136690647	0.460383579979118	0.460383579979118	false	false	false
9cafa9f9-2dc7-4808-9245-73ba5c5a95f0	2026-09-17 14:10	2026-09-17 14:10	2026-09-17 14:10	APA	APA260918C00040000	call	40.0000	2026-09-18	5.3200	5.3000	5.5000	45.3300	17024.00	0.00	17024.00	32	8	92	4685	0.0196371398078975	1.78371427218922	1.78371427218922	false	false	false
e63370ff-b9ba-4c4d-afe6-28b6fd994b41	2026-09-17 11:44	2026-09-17 11:44	2026-09-17 11:44	APA	APA261016P00042500	put	42.5000	2026-10-16	1.1700	1.1600	1.2000	44.9800	12285.00	0.00	12168.00	105	7	119	997	0.119358074222668	0.456194355970457	0.456194355970457	false	false	false
efa8b275-80c5-4b1f-85c3-431cd99fccc0	2026-09-17 10:42	2026-09-17 10:42	2026-09-17 10:42	APA	APA270115P00040000	put	40.0000	2027-01-15	2.3900	2.3900	2.4600	45.1300	58794.00	0.00	58794.00	246	29	251	1020	0.246078431372549	0.487641667047305	0.487641667047305	false	false	false
dafbf214-1214-438a-97e4-1e62fac58b5f	2026-09-16 15:05	2026-09-16 15:05	2026-09-16 15:05	APA	APA261016C00050000	call	50.0000	2026-10-16	0.8100	0.7800	0.9100	44.9550	55242.00	0.00	55242.00	682	24	790	1571	0.502864417568428	0.469129754628794	0.469129754628794	false	false	false
a91c58a4-0f4c-4130-b8ae-3b36502ba16a	2026-09-16 13:23	2026-09-16 13:23	2026-09-16 13:23	APA	APA281215P00045000	put	45.0000	2028-12-15	10.2000	9.9500	10.2000	45.4000	81600.00	81600.00	0.00	80	11	956	1000	0.956	0.497878351167775	0.497878351167775	true	false	false
2163e31b-7974-4904-b321-d26169b44036	2026-09-16 13:17	2026-09-16 13:17	2026-09-16 13:17	APA	APA281215C00045000	call	45.0000	2028-12-15	12.8800	12.4500	12.9000	45.3800	471410.00	471410.00	0.00	366	2	515	1063	0.48447789275635	0.40686125666645	0.40686125666645	false	true	false
3884f657-ab3e-4047-8df6-b6540ebc7227	2026-09-16 13:10	2026-09-16 13:10	2026-09-16 13:10	APA	APA281215C00045000	call	45.0000	2028-12-15	12.8000	12.4500	12.8500	45.2900	57600.00	57600.00	0.00	45	14	112	1063	0.105362182502352	0.405420339198867	0.40735568245939	true	false	false
52d1fb6e-dd46-4c6d-9f03-43e733487ac7	2026-09-16 10:48	2026-09-16 10:48	2026-09-16 10:48	APA	APA260918C00043500	call	43.5000	2026-09-18	1.4800	1.3500	1.4800	44.6200	138084.00	138084.00	0.00	933	32	933	155	6.01935483870968	0.607500069707327	0.607500069707327	false	false	false
913fb729-89cf-4d82-87f3-299259667033	2026-09-15 15:35	2026-09-15 15:35	2026-09-15 15:35	APA	APA261218C00045000	call	45.0000	2026-12-18	5.9000	5.7500	5.9500	47.3700	14750.00	14750.00	0.00	25	18	265	4872	0.0543924466338259	0.472767073304349	0.46988283781924	false	false	false
0df2c900-c3b4-4bf0-857f-5ad3536c4099	2026-09-15 13:38	2026-09-15 13:37	2026-09-15 13:37	APA	APA261016C00050000	call	50.0000	2026-10-16	1.5100	1.4600	1.5100	47.1600	22348.00	22348.00	0.00	148	27	550	1395	0.39426523297491	0.468115667051681	0.468115667051681	false	false	false
2e58ada2-0048-48aa-a659-ccd535a59d39	2026-09-15 10:36	2026-09-15 10:36	2026-09-15 10:36	APA	APA261016C00050000	call	50.0000	2026-10-16	1.3000	1.2200	1.3300	46.6900	39910.00	39910.00	0.00	307	9	344	1395	0.246594982078853	0.459379091193017	0.459379091193017	false	false	false
badbec0c-c21f-4a32-9310-e42d29153861	2026-09-15 09:49	2026-09-15 09:49	2026-09-15 09:49	APA	APA261016C00045000	call	45.0000	2026-10-16	3.2200	3.2000	3.5000	46.3900	1290900.00	0.00	1290900.00	4009	2	5008	8381	0.597542059420117	0.444353131301482	0.444353131301482	false	true	false
17fb9e9e-f40f-424b-a2b0-87d505fcc007	2026-09-15 09:47	2026-09-15 09:47	2026-09-15 09:47	APA	APA261016C00045000	call	45.0000	2026-10-16	3.3500	3.3500	3.5000	46.5300	147735.00	0.00	147735.00	441	16	949	8381	0.11323231118005	0.456435279332818	0.456435279332818	false	false	false
ddd64c69-4381-4eed-af26-d4479991e26d	2026-09-15 09:47	2026-09-15 09:47	2026-09-15 09:47	APA	APA261016C00045000	call	45.0000	2026-10-16	3.3000	3.2000	3.3000	46.5250	165000.00	165000.00	0.00	500	17	508	8381	0.060613291969932	0.447252949127989	0.447252949127989	true	false	false
6c077df9-9150-47ee-9733-a0eb8933df13	2026-09-14 15:35	2026-09-14 15:35	2026-09-14 15:35	APA	APA261016P00045000	put	45.0000	2026-10-16	2.2700	2.1900	2.2700	45.1300	11123.00	11123.00	0.00	49	10	239	590	0.405084745762712	0.453608486008052	0.453608486008052	false	false	false
cefbc45e-fb7a-476e-82dc-d9c650e122e7	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	APA	APA260925P00045000	put	45.0000	2026-09-25	1.4000	1.1700	1.4000	45.2400	23520.00	23520.00	0.00	168	21	369	97	3.80412371134021	0.493971431235601	0.493971431235601	true	false	false
35e8c0db-0248-4b07-908b-ab4cbcf5bd9a	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	APA	APA261002P00045000	put	45.0000	2026-10-02	1.7700	1.5900	1.7700	45.1800	198767.00	198767.00	0.00	1123	32	1176	26	45.2307692307692	0.483091477425777	0.473727675700114	false	false	false