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

4c239e8a-2f34-4f2c-9c5a-32ca8b2866ad	2026-08-18 09:42	2026-08-18 09:42	2026-08-18 09:42	APA	APA260918P00040000	put	40.0000	2026-09-18	1.2500	1.1600	1.2500	41.0000	12375.00	12375.00	0.00	99	23	119	818	0.145476772616137	0.407166301578448	0.407166301578448	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	15776328495.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
52858f6e-10a3-4877-aee8-8314c825a5e1	2026-08-18 10:57	2026-08-18 10:57	2026-08-18 10:57	APA	APA261218C00052500	call	52.5000	2026-12-18	1.1600	1.1300	1.1600	41.5100	19140.00	19140.00	0.00	165	34	166	126	1.31746031746032	0.428587736711536	0.428587736711536	false	false	false	true
a9c711fc-edfd-434b-b9b7-f3c43ff21c22	2026-08-18 12:43	2026-08-18 12:43	2026-08-18 12:43	APA	APA261016P00042500	put	42.5000	2026-10-16	2.8500	2.8500	3.1000	41.8500	14820.00	0.00	14820.00	52	9	146	111	1.31531531531532	0.393565112420797	0.393565112420797	false	false	false	true
0f5d50eb-08f2-4e02-bd83-e8cdabdf8c94	2026-08-18 12:43	2026-08-18 12:43	2026-08-18 12:43	APA	APA261016P00042500	put	42.5000	2026-10-16	2.8500	2.8500	3.1000	41.8500	12540.00	0.00	12540.00	44	8	94	111	0.846846846846847	0.393565112420797	0.393565112420797	false	false	false	true
d0bf8aec-243a-48bc-88d7-f7003a732144	2026-08-18 14:05	2026-08-18 14:04	2026-08-18 14:04	APA	APA261016C00042500	call	42.5000	2026-10-16	2.6500	2.5500	2.6500	42.0300	13250.00	13250.00	0.00	50	5	86	5506	0.0156193243734108	0.407810844289446	0.407810844289446	false	false	false	true
0c54348f-71de-40c3-8862-7bdccf5d1276	2026-08-18 14:55	2026-08-18 14:54	2026-08-18 14:54	APA	APA261016C00042500	call	42.5000	2026-10-16	2.6800	2.6200	2.6800	42.0700	17420.00	17420.00	0.00	65	12	216	5506	0.0392299309843807	0.40916573401043	0.40916573401043	false	false	false	true
397350a2-5458-48eb-9a42-4a4fdc6bd079	2026-08-18 15:59	2026-08-18 15:59	2026-08-18 15:59	APA	APA261218C00045000	call	45.0000	2026-12-18	3.3000	3.0000	3.4500	42.0000	36960.00	16170.00	20460.00	112	10	114	711	0.160337552742616	0.425028529517559	0.425028529517559	false	false	false	true
df21dfa4-a722-483c-b168-97d81e1dd955	2026-08-19 09:43	2026-08-19 09:43	2026-08-19 09:43	APA	APA260828C00046000	call	46.0000	2026-08-28	0.5100	0.4100	0.5100	43.9600	21930.00	21930.00	0.00	430	40	430	11	39.0909090909091	0.449595681493707	0.449595681493707	false	false	false	true
4bac94ea-7864-4013-9256-ac2e554cd3ab	2026-08-19 10:48	2026-08-19 10:47	2026-08-19 10:47	APA	APA261016P00037500	put	37.5000	2026-10-16	0.6000	0.4000	0.7000	44.3900	17460.00	600.00	16860.00	291	14	294	280	1.05	0.440718977415226	0.440718977415226	false	false	false	true
f877502f-13c8-4a9e-a4a3-2797f2e7bc3e	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	APA	APA260821C00039000	call	39.0000	2026-08-21	5.2500	5.2500	5.6000	44.2700	12600.00	0.00	12600.00	24	10	24	453	0.0529801324503311	1.54899144421379	1.54899144421379	false	false	false	true
0372fe39-eb4e-446f-a02a-ad09ac6b0f15	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	APA	APA260821C00038500	call	38.5000	2026-08-21	5.7500	5.7500	6.1000	44.2700	14950.00	0.00	14950.00	26	9	26	82	0.317073170731707	1.65973395663134	1.65973395663134	true	false	false	true
3084cee9-f275-4b43-a503-2350f84b2e1b	2026-08-19 11:32	2026-08-19 11:32	2026-08-19 11:32	APA	APA260828C00038000	call	38.0000	2026-08-28	6.5700	6.4500	6.7500	44.4800	13140.00	0.00	13140.00	20	6	20	164	0.121951219512195	0.566192210258148	0.566192210258148	false	false	false	true
942d4c98-16a6-43a4-af00-a41359644684	2026-08-19 12:18	2026-08-19 12:18	2026-08-19 12:18	APA	APA261218C00050000	call	50.0000	2026-12-18	2.7200	2.6500	2.7200	44.4150	11968.00	11968.00	0.00	44	12	101	610	0.165573770491803	0.446323365174371	0.446323365174371	false	false	false	true
d9e14ccc-942a-4749-ad61-00251df85471	2026-08-19 12:22	2026-08-19 12:22	2026-08-19 12:22	APA	APA261016C00055000	call	55.0000	2026-10-16	0.5300	0.5200	0.5300	44.4000	15158.00	15158.00	0.00	286	32	794	10395	0.0763828763828764	0.448286513571672	0.448286513571672	false	false	false	true
21be5d2b-4a17-46eb-9169-464eb25d4989	2026-08-19 14:59	2026-08-19 14:59	2026-08-19 14:59	APA	APA260918C00045000	call	45.0000	2026-09-18	1.5500	1.5100	1.5500	43.6000	18755.00	18755.00	0.00	121	26	335	1385	0.24187725631769	0.419529933367639	0.419529933367639	false	false	false	true
ad6a838e-35e6-47ec-99bd-e345a2a4521e	2026-08-20 10:00	2026-08-20 10:00	2026-08-20 10:00	APA	APA260821C00042500	call	42.5000	2026-08-21	2.3800	2.0400	2.3800	44.8078	21420.00	21420.00	0.00	90	11	92	468	0.196581196581197	0.743681927507167	0.743681927507167	false	false	false	true
d230fda1-e6dd-465d-937c-3a3233771e5a	2026-08-25 10:03	2026-08-25 10:02	2026-08-25 10:02	APA	APA260828P00044500	put	44.5000	2026-08-28	2.5400	2.5400	2.9100	42.0700	13970.00	0.00	13970.00	55	5	56	9	6.22222222222222	0.527388672900276	0.527388672900276	false	false	false	true
8cc9a463-c1f2-4d9c-ba6b-d6e394eab831	2026-08-25 10:03	2026-08-25 10:02	2026-08-25 10:02	APA	APA260828P00043500	put	43.5000	2026-08-28	1.6800	1.6800	2.0300	42.0700	39480.00	0.00	39480.00	235	28	245	148	1.65540540540541	0.500509163562181	0.500509163562181	false	false	false	true
0a501889-735f-4ab3-85a2-6741bd1700a7	2026-08-25 15:44	2026-08-25 15:44	2026-08-25 15:44	APA	APA280121C00037500	call	37.5000	2028-01-21	10.6000	10.6000	11.1000	41.4650	32861.00	0.00	32861.00	31	6	52	258	0.201550387596899	0.395773326446321	0.396374622703291	false	false	false	true
9152c86a-f427-4dd4-894d-38a0edead1fe	2026-08-26 11:35	2026-08-26 11:35	2026-08-26 11:35	APA	APA260918C00040000	call	40.0000	2026-09-18	2.6800	2.6700	2.7800	41.5750	62176.00	0.00	62176.00	232	23	417	5090	0.0819253438113949	0.421120445823821	0.421120445823821	false	false	false	true
e5e8e9f7-7495-4d59-a29c-9bda04ff1ed0	2026-08-26 15:37	2026-08-26 15:36	2026-08-26 15:36	APA	APA270115C00045000	call	45.0000	2027-01-15	3.2000	3.2000	3.5500	41.3850	41600.00	0.00	41600.00	130	10	131	1506	0.0869853917662683	0.424763825669941	0.424763825669941	false	false	false	true
b7c38f10-137c-460b-8408-afa9737cdb6b	2026-08-27 11:01	2026-08-27 11:01	2026-08-27 11:01	APA	APA261016P00040000	put	40.0000	2026-10-16	1.9600	1.9600	2.0100	40.9900	45864.00	0.00	45864.00	234	35	234	466	0.502145922746781	0.421917551440147	0.421917551440147	false	false	false	true
002cbfc5-5aa2-419f-966e-985558e8c279	2026-08-27 13:06	2026-08-27 13:06	2026-08-27 13:06	APA	APA261016C00045000	call	45.0000	2026-10-16	1.4000	1.3600	1.4500	41.5300	52920.00	31780.00	7140.00	378	52	470	11184	0.0420243204577969	0.428334926436312	0.427114234632577	false	false	false	true
6d7d81ca-ad6e-42aa-93a0-31f863820b78	2026-08-27 13:09	2026-08-27 13:08	2026-08-27 13:08	APA	APA260918C00043000	call	43.0000	2026-09-18	1.1300	1.1200	1.1300	41.5900	10283.00	10283.00	0.00	91	20	95	80	1.1875	0.412563847568212	0.412563847568212	false	false	false	true
598d84d1-a056-409e-8849-5db28c0dbb51	2026-08-27 13:19	2026-08-27 13:19	2026-08-27 13:19	APA	APA261016C00042500	call	42.5000	2026-10-16	2.4000	2.3100	2.4000	41.7400	15600.00	15600.00	0.00	65	5	100	5501	0.0181785129976368	0.429443522426874	0.429443522426874	false	false	false	true
d9a9a069-d560-4e73-a376-2332afc1c43a	2026-08-27 13:20	2026-08-27 13:20	2026-08-27 13:20	APA	APA261218C00045000	call	45.0000	2026-12-18	2.9600	2.8600	3.0500	41.7300	31968.00	31968.00	0.00	108	26	127	790	0.160759493670886	0.438723339609569	0.438723339609569	false	false	false	true
3b0507f8-0fe0-4206-9de5-2836bcf62362	2026-08-27 13:40	2026-08-27 13:40	2026-08-27 13:40	APA	APA261016C00045000	call	45.0000	2026-10-16	1.5500	1.5500	1.5800	41.7950	31000.00	0.00	31000.00	200	5	5314	11184	0.475143061516452	0.436809464557209	0.436809464557209	true	false	false	true
449bfaaf-9e44-4cbb-9dfd-bb5839ca9f7c	2026-08-27 14:08	2026-08-27 14:08	2026-08-27 14:08	APA	APA261218C00050000	call	50.0000	2026-12-18	1.8400	1.7900	1.8400	42.3900	27048.00	27048.00	0.00	147	26	223	664	0.335843373493976	0.44413810154996	0.44413810154996	false	false	false	true
8409d350-439e-4ce7-a724-7a17a85e8a75	2026-08-27 14:50	2026-08-27 14:50	2026-08-27 14:50	APA	APA261016C00045000	call	45.0000	2026-10-16	1.8000	1.7100	1.8000	42.4400	21420.00	21420.00	0.00	119	20	5447	11184	0.487035050071531	0.437247872067742	0.437247872067742	false	false	false	true
e12cbbd6-d485-456c-8d83-5dd111343964	2026-08-28 09:53	2026-08-28 09:52	2026-08-28 09:52	APA	APA261016C00045000	call	45.0000	2026-10-16	1.7400	1.7400	1.9700	42.5900	34800.00	0.00	34800.00	200	5	222	16461	0.0134864224530709	0.42195017754059	0.42195017754059	false	false	false	true
78ce2884-88f2-4a5c-b30e-709b34eb8aa4	2026-08-31 10:15	2026-08-31 10:15	2026-08-31 10:15	APA	APA261016C00045000	call	45.0000	2026-10-16	1.9500	1.8800	2.0500	43.1600	11505.00	2145.00	2340.00	59	6	119	16270	0.0073140749846343	0.431339169159775	0.431339169159775	false	false	false	true
50078b71-3af5-476f-8e18-9fbaf11e4b4d	2026-08-31 11:18	2026-08-31 11:18	2026-08-31 11:18	APA	APA261016C00045000	call	45.0000	2026-10-16	1.6800	1.6300	1.7300	42.5000	27552.00	0.00	16800.00	164	9	336	16270	0.0206515058389674	0.432023323730244	0.432023323730244	false	false	false	true
dd64e78f-8327-474a-aa0f-258fcd068cdd	2026-08-31 12:48	2026-08-31 12:48	2026-08-31 12:48	APA	APA261016C00045000	call	45.0000	2026-10-16	1.7100	1.6900	1.7100	42.6150	15390.00	8550.00	0.00	90	6	641	16270	0.0393976644130301	0.429305614490137	0.429305614490137	false	false	false	true
c419994c-74ad-4522-8aa5-a3a275da321d	2026-08-31 13:09	2026-08-31 13:09	2026-08-31 13:09	APA	APA261016C00045000	call	45.0000	2026-10-16	1.8000	1.7600	1.8000	42.7700	18000.00	9180.00	0.00	100	6	752	16270	0.046220036877689	0.433881562916362	0.433881562916362	false	false	false	true
17d08833-9d7e-4624-9d7c-5e1005331903	2026-08-31 13:27	2026-08-31 13:26	2026-08-31 13:26	APA	APA261016C00045000	call	45.0000	2026-10-16	1.7700	1.7200	1.7700	42.8000	17700.00	7257.00	0.00	100	5	862	16270	0.052980946527351	0.426715718179483	0.426715718179483	false	false	false	true
377e2dca-59e0-4865-b310-2274896cb335	2026-08-31 14:04	2026-08-31 14:04	2026-08-31 14:04	APA	APA261016C00045000	call	45.0000	2026-10-16	1.8500	1.7800	1.8700	42.0000	16650.00	16650.00	0.00	90	7	967	16270	0.0594345421020283	0.430367045582552	0.430367045582552	false	false	false	true
c52dadfe-ea0e-4349-aea6-93bef2a99ff1	2026-08-31 14:19	2026-08-31 14:18	2026-08-31 14:18	APA	APA261016C00045000	call	45.0000	2026-10-16	1.8300	1.7800	1.8300	42.0000	12810.00	12810.00	0.00	70	5	1037	16270	0.0637369391518132	0.434749794213118	0.434749794213118	false	false	false	true
ab3087c4-770a-45eb-84fc-3799698086f7	2026-08-31 15:35	2026-08-31 15:35	2026-08-31 15:35	APA	APA261016C00045000	call	45.0000	2026-10-16	1.8600	1.8000	1.9600	42.9900	16926.00	3720.00	3906.00	91	5	1216	16270	0.0747387830362631	0.42850323085094	0.42850323085094	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
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
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
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
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
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
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
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
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
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
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
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