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:alert_rule = RepeatedHits×ticker = APA×

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

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	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	14819868873.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
1af6370f-dd05-42fc-adc7-29a34a2460de	2026-09-14 13:07	2026-09-14 13:07	2026-09-14 13:07	APA	APA260918C00046500	call	46.5000	2026-09-18	0.6600	0.6200	0.7800	45.7000	19008.00	18942.00	66.00	288	43	363	289	1.2560553633218	0.52074615524118	0.52074615524118	false	false	false	true
60e94436-f271-4f45-89fc-7ed7cf958376	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	APA	APA260918C00040000	call	40.0000	2026-09-18	5.7500	5.7500	6.1500	45.6600	23575.00	0.00	23575.00	41	5	92	4812	0.0191188694929343	0.773443492406732	0.773443492406732	false	false	false	true
73164ed3-af7b-49a2-af0d-b8dff20afa77	2026-09-14 12:14	2026-09-14 12:13	2026-09-14 12:13	APA	APA261016C00047500	call	47.5000	2026-10-16	1.9200	1.8500	1.9200	46.0500	10368.00	10368.00	0.00	54	18	110	369	0.29810298102981	0.455784683416394	0.455784683416394	false	false	false	true
c1170805-fb46-4560-a2f1-d849e78832f7	2026-09-14 11:19	2026-09-14 11:19	2026-09-14 11:19	APA	APA260918C00046000	call	46.0000	2026-09-18	1.0500	0.9900	1.0500	46.0650	21315.00	21315.00	0.00	203	31	266	307	0.866449511400652	0.524105619802226	0.524105619802226	false	false	false	true
b77cd506-fd6a-420f-b582-c5fd52b75d32	2026-09-11 15:10	2026-09-11 15:09	2026-09-11 15:09	APA	APA261016C00055000	call	55.0000	2026-10-16	0.2500	0.2400	0.3000	44.7600	11650.00	0.00	11650.00	466	6	1223	3733	0.327618537369408	0.460961676477996	0.461161268426978	false	false	false	true
64d2834f-2b02-4526-bf0b-64f2ea654d19	2026-09-11 12:46	2026-09-11 12:46	2026-09-11 12:46	APA	APA261016C00045000	call	45.0000	2026-10-16	2.3000	2.3000	2.3900	44.6200	12190.00	0.00	12190.00	53	5	839	9747	0.0860777675182107	0.435119059427852	0.435119059427852	false	false	false	true
5d8dd782-681c-4082-845b-63bbe98c856e	2026-09-11 12:40	2026-09-11 12:40	2026-09-11 12:40	APA	APA261016C00045000	call	45.0000	2026-10-16	2.3200	2.3200	2.3500	44.5950	17632.00	0.00	17632.00	76	9	696	9747	0.0714065866420437	0.441076857922746	0.441076857922746	false	false	false	true
36c38b36-4949-4243-810a-0ff88c31520f	2026-09-10 14:23	2026-09-10 14:23	2026-09-10 14:23	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3000	1.2700	1.3000	45.0100	11050.00	11050.00	0.00	85	14	139	609	0.22824302134647	0.439886728889437	0.439886728889437	false	false	false	true
7ab77a24-d11d-4b79-bdb4-ff444313cf7c	2026-09-09 15:19	2026-09-09 15:19	2026-09-09 15:19	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3500	1.3100	1.3500	44.8500	10935.00	10935.00	0.00	81	18	108	520	0.207692307692308	0.434288265808631	0.434288265808631	false	false	false	true
4e77849e-d97b-4a83-aa81-93a81b67d542	2026-09-09 14:49	2026-09-09 14:49	2026-09-09 14:49	APA	APA260911C00043000	call	43.0000	2026-09-11	1.9300	1.5600	1.9300	44.7750	17370.00	17370.00	0.00	90	7	100	185	0.540540540540541	0.54597488338286	0.54597488338286	false	false	false	true
65bd8bb7-4e04-4644-bd28-e94316c8a3a6	2026-09-09 13:32	2026-09-09 13:32	2026-09-09 13:32	APA	APA270115C00050000	call	50.0000	2027-01-15	2.8000	2.7500	2.8000	44.4029	10360.00	10360.00	0.00	37	13	323	1841	0.175448126018468	0.44093950388617	0.44093950388617	false	false	false	true
0c89d5b4-d2c9-4ab4-b2a7-04792a4a3c18	2026-09-09 11:20	2026-09-09 11:20	2026-09-09 11:20	APA	APA270115C00050000	call	50.0000	2027-01-15	2.8700	2.8100	2.8700	44.4950	38171.00	38171.00	0.00	133	22	186	1841	0.101032047800109	0.444248532891063	0.444248532891063	false	false	false	true
06fe3f8d-a9af-4073-ac17-da2911a4ab8b	2026-09-09 10:18	2026-09-09 10:18	2026-09-09 10:18	APA	APA270115C00050000	call	50.0000	2027-01-15	2.7700	2.6900	2.7700	44.2950	14681.00	14681.00	0.00	53	12	53	1841	0.0287887017925041	0.442157421078218	0.442157421078218	false	false	false	true
34390436-fc33-496e-a269-21c82683e142	2026-09-09 09:43	2026-09-09 09:42	2026-09-09 09:42	APA	APA280121C00040000	call	40.0000	2028-01-21	11.7500	11.4500	11.7500	44.5700	47000.00	47000.00	0.00	40	12	50	427	0.117096018735363	0.412650626285908	0.412650626285908	false	false	false	true
0ff84fdd-bd81-4ac0-bd8b-9cfdf88d460f	2026-09-08 15:11	2026-09-08 15:10	2026-09-08 15:10	APA	APA260911C00044500	call	44.5000	2026-09-11	0.4400	0.3600	0.4500	43.8050	29040.00	28996.00	44.00	660	19	715	28	25.5357142857143	0.469743384449973	0.457630376842946	false	false	false	true
4595fd61-68b0-4ee3-933e-9c74dd480a83	2026-09-08 11:01	2026-09-08 11:01	2026-09-08 11:01	APA	APA260918P00042500	put	42.5000	2026-09-18	0.7700	0.7300	0.7700	43.6400	19096.00	19096.00	0.00	248	35	257	425	0.604705882352941	0.448863992594584	0.448863992594584	false	false	false	true
7f3dc10c-7609-4140-a576-00ea26e064f8	2026-09-08 10:27	2026-09-08 10:27	2026-09-08 10:27	APA	APA270115P00040000	put	40.0000	2027-01-15	2.6000	2.5000	2.6000	44.1000	10400.00	10400.00	0.00	40	6	66	872	0.0756880733944954	0.461751894065211	0.461751894065211	false	false	false	true
80380001-7571-4652-adf0-a510fab87c4d	2026-09-04 15:20	2026-09-04 15:20	2026-09-04 15:20	APA	APA261218C00040000	call	40.0000	2026-12-18	5.7000	5.6500	5.8000	42.9300	13680.00	9120.00	4560.00	24	6	53	2055	0.0257907542579075	0.428110675101877	0.428110675101877	false	false	false	true
c4e013f6-e94b-4011-bb8e-cbda6b7ae13b	2026-09-03 11:56	2026-09-03 11:56	2026-09-03 11:56	APA	APA260911C00038000	call	38.0000	2026-09-11	6.4000	6.4000	6.6000	44.3500	10880.00	0.00	10880.00	17	7	19	45	0.422222222222222	0.493920631136273	0.493920631136273	false	false	false	true
55474e8b-a0c0-452c-980e-1244404b7494	2026-09-02 14:33	2026-09-02 14:33	2026-09-02 14:33	APA	APA261016C00045000	call	45.0000	2026-10-16	2.7500	2.7400	2.9200	45.0600	54978.00	48950.00	6028.00	200	6	290	11939	0.0242901415528939	0.418599422863315	0.418599422863315	false	false	false	true
5580ae92-7517-43a4-a536-9bd62eb2e5b3	2026-09-02 14:27	2026-09-02 14:27	2026-09-02 14:27	APA	APA270319C00052500	call	52.5000	2027-03-19	3.4000	3.2500	3.4000	45.0850	24480.00	24480.00	0.00	72	13	72	95	0.757894736842105	0.426741193983372	0.426741193983372	false	false	false	true
1da7c10a-c0ee-4c86-8fc7-d2a9958bf307	2026-09-01 13:55	2026-09-01 13:55	2026-09-01 13:55	APA	APA260918P00045000	put	45.0000	2026-09-18	1.9700	1.9000	1.9900	44.2250	159570.00	159373.00	197.00	810	39	814	708	1.14971751412429	0.416789471064799	0.416789471064799	false	false	false	true
e15825e8-7a18-4543-9374-e666151fcf40	2026-09-01 11:16	2026-09-01 11:16	2026-09-01 11:16	APA	APA280121C00065000	call	65.0000	2028-01-21	3.6000	3.4500	3.6000	43.7800	10440.00	10440.00	0.00	29	9	52	289	0.179930795847751	0.418235018059281	0.418235018059281	false	false	false	true
15c1eb34-d030-4cda-a343-6f412de9c16b	2026-08-31 15:53	2026-08-31 15:53	2026-08-31 15:53	APA	APA261016C00045000	call	45.0000	2026-10-16	1.9200	1.9200	1.9800	43.1400	14592.00	0.00	2496.00	76	6	1292	16270	0.0794099569760295	0.427800170821173	0.427800170821173	false	false	false	true