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 = AAP×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	price

4154f181-2b41-4272-9418-e93766b749f8	2026-08-17 13:44	2026-08-17 13:44	2026-08-17 13:44	AAP	AAP260821C00056000	call	56.0000	2026-08-21	3.9000	3.7000	3.9000	56.0000	107250.00	107250.00	0.00	275	13	328	160	2.05	1.50762637237873	1.50762637237873	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2718604000.00	2026-10-29	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1158d7aa-ab8c-445e-8ba3-f6ca0959db02	2026-08-18 09:49	2026-08-18 09:49	2026-08-18 09:49	AAP	AAP260821P00049000	put	49.0000	2026-08-21	0.5000	0.4500	0.6500	59.0000	11810.00	0.00	11810.00	236	12	236	437	0.540045766590389	1.770691745889	1.75021996546803	false	false	false	true	false
caf335c0-b233-4fbd-803f-7a8231067447	2026-08-18 13:02	2026-08-18 13:02	2026-08-18 13:02	AAP	AAP260821P00052000	put	52.0000	2026-08-21	0.9500	0.9500	1.1500	58.8100	81515.00	0.00	81515.00	858	42	1009	279	3.61648745519713	1.650045780351	1.650045780351	false	false	false	true	false
a77d0144-e2e8-44fd-90de-3f511543df36	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	AAP	AAP260821P00051000	put	51.0000	2026-08-21	1.0000	0.9500	1.1000	58.3600	17900.00	11700.00	300.00	179	30	200	180	1.11111111111111	2.19634990625612	2.18920688511017	false	false	false	true	false
65e94f49-5996-427b-b08f-f8fa5174d698	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	AAP	AAP260821P00051000	put	51.0000	2026-08-21	1.0000	1.0000	1.1000	58.3600	27600.00	0.00	2800.00	276	37	532	180	2.95555555555556	2.18920688511017	2.18920688511017	false	false	false	true	false
959c21f8-7454-44b4-bf29-1b73015487d6	2026-08-19 11:03	2026-08-19 11:03	2026-08-19 11:03	AAP	AAP260828C00058000	call	58.0000	2026-08-28	4.1000	3.9000	4.5000	58.3550	166460.00	37310.00	117260.00	406	10	418	226	1.84955752212389	1.06967957548888	1.06967957548888	false	false	false	true	false
93a58c2c-3470-4105-99db-f1240201981e	2026-08-19 14:18	2026-08-19 14:18	2026-08-19 14:18	AAP	AAP260918P00052500	put	52.5000	2026-09-18	2.7600	2.5500	2.8000	56.5550	22898.00	22898.00	0.00	83	18	211	281	0.750889679715303	0.732599348931707	0.741242165518608	false	false	false	true	false
f17bab7f-277b-4c9b-9887-32fcd6e600eb	2026-08-19 15:46	2026-08-19 15:46	2026-08-19 15:46	AAP	AAP260821C00053000	call	53.0000	2026-08-21	5.7000	5.7000	6.2000	56.6850	58710.00	0.00	54150.00	103	14	954	10200	0.0935294117647059	2.19550934666763	2.19550934666763	false	false	false	true	false
e1a8e53d-fd8b-4d2b-9475-666654792993	2026-08-19 15:46	2026-08-19 15:46	2026-08-19 15:46	AAP	AAP260821C00053000	call	53.0000	2026-08-21	5.8000	5.8000	6.2000	56.8100	57420.00	0.00	43500.00	99	14	1053	10200	0.103235294117647	2.24670399258975	2.20462786386072	false	false	false	true	false
22c3cafd-6374-4733-a53f-5322ef366571	2026-08-20 10:43	2026-08-20 10:43	2026-08-20 10:43	AAP	AAP270115C00050000	call	50.0000	2027-01-15	4.0000	4.0000	4.2000	43.9411	26800.00	0.00	26800.00	67	6	77	444	0.173423423423423	0.534366847614074	0.534366847614074	false	false	false	true	false
e734828a-9a44-4f8b-99de-4baee0c6c355	2026-08-20 10:52	2026-08-20 10:52	2026-08-20 10:52	AAP	AAP260918C00045000	call	45.0000	2026-09-18	2.1500	1.8500	2.2000	43.9200	11825.00	2580.00	9245.00	55	5	87	19	4.57894736842105	0.520387708070037	0.520387708070037	true	false	false	true	false
cc8d7cc2-8f50-4b10-823c-732df80ec688	2026-08-20 11:54	2026-08-20 11:54	2026-08-20 11:54	AAP	AAP260821C00042000	call	42.0000	2026-08-21	1.1500	0.8500	1.1500	42.5300	73140.00	73140.00	0.00	636	42	640	7	91.4285714285714	0.988924548955691	0.97056835456101	false	false	false	true	false
f65d668d-ba57-4d04-9bee-28bbb869de38	2026-08-20 12:29	2026-08-20 12:29	2026-08-20 12:29	AAP	AAP270917P00040000	put	40.0000	2027-09-17	8.1000	8.1000	8.5000	41.9600	24300.00	0.00	24300.00	30	6	30	0	0	0.603582959340039	0.603582959340039	false	false	false	true	false
a92504cd-862a-4ee1-baf8-387048cb53b8	2026-08-20 13:02	2026-08-20 13:02	2026-08-20 13:02	AAP	AAP261002P00047000	put	47.0000	2026-10-02	6.5000	6.3000	6.5000	41.6001	41600.00	41600.00	0.00	64	22	66	1	66	0.541954515544881	0.541954515544881	true	false	false	true	false
c38a5061-d742-44f8-beae-c5e320a2df48	2026-08-20 13:23	2026-08-20 13:23	2026-08-20 13:23	AAP	AAP260821C00041000	call	41.0000	2026-08-21	0.7500	0.6000	1.2500	40.8950	32850.00	32775.00	75.00	438	31	494	13	38	0.938751334023059	0.935026660635548	false	false	false	true	false
9ef62c4b-70e5-4d27-8049-d17207e6f6c2	2026-08-21 09:35	2026-08-21 09:35	2026-08-21 09:35	AAP	AAP260918P00042500	put	42.5000	2026-09-18	1.9000	1.8000	2.1000	43.4100	13300.00	5320.00	7980.00	70	8	105	476	0.220588235294118	0.502855865149939	0.502855865149939	false	false	false	true	false
1ae3d358-0bec-4acf-a435-44bffc9965a2	2026-08-21 09:46	2026-08-21 09:46	2026-08-21 09:46	AAP	AAP261016P00042500	put	42.5000	2026-10-16	2.5500	2.5500	3.2000	43.4700	51000.00	0.00	51000.00	200	9	201	35	5.74285714285714	0.466590847434918	0.466590847434918	false	false	false	true	false
2a5c3f4b-c6c1-48bd-8ed5-1e1914d3bc6f	2026-08-21 10:23	2026-08-21 10:23	2026-08-21 10:23	AAP	AAP270115P00045000	put	45.0000	2027-01-15	6.8000	6.7000	6.9000	42.8250	14960.00	3400.00	11560.00	22	13	52	1132	0.0459363957597173	0.550392032238431	0.550392032238431	false	false	false	true	false
ed5043a7-9341-4031-ad3b-d237decf1b19	2026-08-21 15:06	2026-08-21 15:06	2026-08-21 15:06	AAP	AAP260925P00046000	put	46.0000	2026-09-25	4.4000	4.2000	4.5000	42.9301	12320.00	11880.00	0.00	28	7	38	13	2.92307692307692	0.493875261384553	0.493875261384553	true	false	false	true	false
e5b81ea5-7bc8-40e3-8210-6e38f49a5957	2026-08-21 15:07	2026-08-21 15:07	2026-08-21 15:07	AAP	AAP260911C00045000	call	45.0000	2026-09-11	1.2000	1.0500	1.2000	42.9400	22080.00	22080.00	0.00	184	22	316	68	4.64705882352941	0.486691496913296	0.483829775244596	true	false	false	true	false
46ace8ee-5890-4604-a21b-beddccbc98d7	2026-08-25 10:02	2026-08-25 10:02	2026-08-25 10:02	AAP	AAP260828P00045000	put	45.0000	2026-08-28	1.8000	1.6500	1.8000	43.7500	61553.00	61553.00	0.00	342	39	344	84	4.09523809523809	0.667186985206372	0.667186985206372	false	false	false	true	false
30e6b960-e97d-4afc-b0bb-3bb96761b415	2026-08-25 11:43	2026-08-25 11:43	2026-08-25 11:43	AAP	AAP260828P00043000	put	43.0000	2026-08-28	0.7500	0.7000	0.7500	43.4500	87825.00	87750.00	0.00	1171	59	1224	323	3.78947368421053	0.616817973107721	0.616817973107721	false	false	false	true	false
a690762d-f35e-447f-90ee-b8b6abb895d1	2026-08-25 13:40	2026-08-25 13:40	2026-08-25 13:40	AAP	AAP270319C00055000	call	55.0000	2027-03-19	3.7000	3.3000	3.7000	43.3900	24050.00	24050.00	0.00	65	7	68	117	0.581196581196581	0.542583739207278	0.542583739207278	false	false	false	true	false
8ba57f1a-77e9-4d51-bcc3-d478a4d0113f	2026-08-25 13:50	2026-08-25 13:50	2026-08-25 13:50	AAP	AAP270617P00030000	put	30.0000	2027-06-17	2.4600	2.4500	3.6000	43.6000	10320.00	0.00	10320.00	42	10	45	57	0.789473684210526	0.604508232541787	0.59913103426393	false	false	false	true	false
6ae84723-a594-440c-b549-af069d79545d	2026-08-25 13:50	2026-08-25 13:50	2026-08-25 13:50	AAP	AAP271217P00030000	put	30.0000	2027-12-17	3.9700	3.8000	5.5000	43.6000	12700.00	0.00	12700.00	32	10	32	86	0.372093023255814	0.600656558609256	0.616640390120522	false	false	false	true	false
1679b7b5-2a4f-4d7a-9d8a-7c7c966921cd	2026-08-25 13:50	2026-08-25 13:50	2026-08-25 13:50	AAP	AAP271217P00032500	put	32.5000	2027-12-17	4.9000	4.9000	7.4000	43.6000	27440.00	0.00	27440.00	56	17	56	23	2.43478260869565	0.6096311546228	0.6096311546228	false	false	false	true	false
f747bfe9-d3a0-49b6-be6c-57a751cc4c2f	2026-08-25 15:32	2026-08-25 15:31	2026-08-25 15:31	AAP	AAP270115P00032500	put	32.5000	2027-01-15	1.5000	1.4500	1.5000	43.6000	16200.00	16200.00	0.00	108	8	180	826	0.217917675544794	0.584525261101754	0.584525261101754	false	false	false	true	false
43a67b2a-380e-4371-85e6-1329bafd210c	2026-08-25 15:59	2026-08-25 15:58	2026-08-25 15:58	AAP	AAP270115C00050000	call	50.0000	2027-01-15	3.6700	3.6000	3.8000	43.6600	18336.00	0.00	18336.00	50	6	54	657	0.0821917808219178	0.526644998574714	0.526644998574714	false	false	false	true	false
5853508a-f9db-4545-8a73-a6523f70a8f2	2026-08-26 13:38	2026-08-26 13:38	2026-08-26 13:38	AAP	AAP270115C00055000	call	55.0000	2027-01-15	2.5000	2.4000	2.5500	43.8900	10000.00	8750.00	1250.00	40	6	45	608	0.0740131578947368	0.525552426526779	0.525552426526779	false	false	false	true	false
5ec55e38-1a56-4ff4-b446-1241ec72e23c	2026-08-26 13:42	2026-08-26 13:42	2026-08-26 13:42	AAP	AAP270115C00047500	call	47.5000	2027-01-15	4.6000	4.5000	4.6000	43.9200	14260.00	14260.00	0.00	31	6	132	187	0.705882352941177	0.527040445161501	0.527040445161501	false	false	false	true	false
d1e19c14-62a8-40b6-9681-707a1ef7e32a	2026-08-27 10:46	2026-08-27 10:46	2026-08-27 10:46	AAP	AAP260904C00043500	call	43.5000	2026-09-04	1.1500	1.1000	1.3000	43.3850	19320.00	0.00	19320.00	168	32	178	17	10.4705882352941	0.463677990709917	0.463677990709917	false	false	false	true	false
a1a2caa1-1d44-4025-8095-9abbe6b060b8	2026-08-27 14:10	2026-08-27 14:10	2026-08-27 14:10	AAP	AAP260904C00042000	call	42.0000	2026-09-04	1.8500	1.8500	1.9500	43.2200	17028.00	0.00	17028.00	92	22	92	11	8.36363636363636	0.442009697048615	0.442009697048615	false	false	false	true	false
aff11411-db63-4ec7-be63-d0ed2b6edd55	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	AAP	AAP260911P00046500	put	46.5000	2026-09-11	4.0000	4.0000	4.8000	42.6250	30800.00	0.00	30800.00	77	5	92	0	0	0.428874171899898	0.428874171899898	false	false	false	true	false
b05a1050-95c9-49c6-9479-b113b872b98d	2026-09-01 11:56	2026-09-01 11:55	2026-09-01 11:55	AAP	AAP260904P00044000	put	44.0000	2026-09-04	1.3000	1.1500	1.3000	43.1650	27289.00	27289.00	0.00	210	32	210	71	2.95774647887324	0.523600796256378	0.523600796256378	false	false	false	true	false
8f352181-3d13-4488-a625-0afbe3719478	2026-09-01 12:39	2026-09-01 12:39	2026-09-01 12:39	AAP	AAP261218P00042500	put	42.5000	2026-12-18	4.6000	4.4000	4.6000	42.8600	32193.00	32193.00	0.00	70	26	80	138	0.579710144927536	0.544640512674286	0.544640512674286	false	false	false	true	false
1fa6ed24-6a7b-4346-8c96-0bc067460b2a	2026-09-03 11:25	2026-09-03 11:24	2026-09-03 11:24	AAP	AAP260904C00042000	call	42.0000	2026-09-04	1.0000	1.0000	1.1500	42.8900	35905.00	0.00	35905.00	359	36	360	115	3.1304347826087	0.457146721440638	0.457146721440638	false	false	false	true	false
23363340-7c45-4cc3-9d34-2273e312d26a	2026-09-03 11:38	2026-09-03 11:38	2026-09-03 11:38	AAP	AAP270617P00045000	put	45.0000	2027-06-17	8.7000	8.5000	9.2000	43.1300	11310.00	3480.00	7830.00	13	8	13	18	0.722222222222222	0.550438150875593	0.550438150875593	false	false	false	true	false
d2574ae6-d5d5-4bca-9402-77a23be997e4	2026-09-09 13:54	2026-09-09 13:53	2026-09-09 13:53	AAP	AAP260925C00043000	call	43.0000	2026-09-25	1.8500	1.6500	1.8500	43.0000	10360.00	10360.00	0.00	56	7	268	97	2.76288659793814	0.50569162586876	0.50569162586876	false	false	false	true	false
9dc884dc-53ac-41e8-9996-bd69e4151dd0	2026-09-09 14:57	2026-09-09 14:57	2026-09-09 14:57	AAP	AAP261002C00045000	call	45.0000	2026-10-02	1.3000	1.2500	1.3500	43.2350	216580.00	0.00	0.00	1666	2	1700	9	188.888888888889	0.458390473053239	0.458390473053239	false	true	true	false	true
57a8e491-5ee2-4186-b94f-0d61b16fd3cc	2026-09-09 14:58	2026-09-09 14:58	2026-09-09 14:58	AAP	AAP261016C00045000	call	45.0000	2026-10-16	1.8000	1.6500	1.8000	43.2500	32930.00	32930.00	0.00	183	24	311	301	1.03322259136213	0.44881731257067	0.44881731257067	true	false	false	true	false
a8387a56-3ec5-4bdc-b376-676b8d6479dc	2026-09-09 14:58	2026-09-09 14:58	2026-09-09 14:58	AAP	AAP261016C00045000	call	45.0000	2026-10-16	1.9000	1.8000	1.9000	43.3800	56047.00	56047.00	0.00	295	32	621	301	2.06312292358804	0.456837598187959	0.456837598187959	true	false	false	true	false
fc594c42-7c4b-4b95-8d3c-f4cd49cb2f18	2026-09-09 15:08	2026-09-09 15:08	2026-09-09 15:08	AAP	AAP261016C00045000	call	45.0000	2026-10-16	2.0000	1.8500	2.0000	43.5000	34000.00	34000.00	0.00	170	9	896	301	2.97674418604651	0.465380837966992	0.465380837966992	true	false	false	true	false
b7fbef5a-53b1-4bd2-a3aa-277b8bf320b4	2026-09-09 15:11	2026-09-09 15:10	2026-09-09 15:10	AAP	AAP260925C00043000	call	43.0000	2026-09-25	2.2500	2.2500	2.3000	43.6900	45675.00	0.00	23175.00	203	13	564	97	5.81443298969072	0.510044576356966	0.510044576356966	false	false	false	true	false
1a28bae4-13e2-4f8a-b191-f9b38a68c023	2026-09-09 15:11	2026-09-09 15:11	2026-09-09 15:11	AAP	AAP260925C00043000	call	43.0000	2026-09-25	2.3500	2.1000	2.3500	43.8275	31254.00	31254.00	0.00	133	31	697	97	7.18556701030928	0.515280757403673	0.515280757403673	true	false	false	true	false
33a21783-4b33-45ec-a554-34681d83ec8b	2026-09-09 15:15	2026-09-09 15:15	2026-09-09 15:15	AAP	AAP261016C00045000	call	45.0000	2026-10-16	2.0500	2.0000	2.2000	43.7600	16605.00	0.00	15990.00	81	18	982	301	3.2624584717608	0.452944931595962	0.452944931595962	true	false	false	true	false
4f43c4da-1aae-41ec-b166-4ff885977056	2026-09-10 10:50	2026-09-10 10:50	2026-09-10 10:50	AAP	AAP260911P00043000	put	43.0000	2026-09-11	0.5500	0.5500	0.7500	42.8900	38775.00	0.00	38775.00	705	43	707	161	4.39130434782609	0.55252395801841	0.55252395801841	false	false	false	true	false
90108d53-e8dd-4b07-98c3-348b1936a735	2026-09-11 09:51	2026-09-11 09:51	2026-09-11 09:51	AAP	AAP260925C00043000	call	43.0000	2026-09-25	2.2700	1.8500	2.6500	43.0000	69402.00	54938.00	13564.00	306	8	306	727	0.420907840440165	0.48514666136191	0.48514666136191	false	false	false	true	false
c67ea9c1-c81e-454c-a47a-730fedf282ea	2026-09-11 14:52	2026-09-11 14:52	2026-09-11 14:52	AAP	AAP261016C00045000	call	45.0000	2026-10-16	2.4000	2.1500	2.4000	44.8400	18000.00	18000.00	0.00	75	11	84	1180	0.0711864406779661	0.433564757530951	0.433564757530951	false	false	false	true	false
81024441-6cf5-4fa5-be52-2a8df62be726	2026-09-14 09:44	2026-09-14 09:44	2026-09-14 09:44	AAP	AAP260918P00050000	put	50.0000	2026-09-18	5.0000	4.9000	5.6000	44.0000	10500.00	0.00	10500.00	21	7	22	1466	0.0150068212824011	1.13351591176418	1.13351591176418	true	false	false	true	false
0c80e97d-1cf3-4f94-8b88-7c1d5b9a18fe	2026-09-15 10:56	2026-09-15 10:55	2026-09-15 10:55	AAP	AAP261016C00045000	call	45.0000	2026-10-16	2.3000	2.3000	2.4000	44.0000	11730.00	0.00	11730.00	51	9	112	1257	0.0891010342084328	0.436888603814158	0.436888603814158	false	false	false	true	false