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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = AAPL260923C00342500×

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

d39ec06e-6b12-45ff-bba2-db057ea6d77b	2026-09-22 10:49	2026-09-22 10:49	2026-09-22 10:49	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.6800	1.6800	1.7000	341.7362	14115.00	170.00	13776.00	84	6	47142	6696	7.04032258064516	0.283135508076631	0.283135508076631	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	4958372655000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
b95c0702-428e-48e1-8a6b-2350d7e67cc0	2026-09-22 10:49	2026-09-22 10:49	2026-09-22 10:49	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.6800	1.6700	1.7200	341.6600	14480.00	338.00	13462.00	86	15	47030	6696	7.02359617682198	0.287024133468262	0.287919962988525	true	false	false	true
94202d2a-db3f-4bb4-bd36-1380e0f0d31e	2026-09-22 10:49	2026-09-22 10:49	2026-09-22 10:49	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.5900	1.5700	1.6300	341.4450	17524.00	10671.00	6533.00	110	27	46309	6696	6.91591995221027	0.288874469688873	0.289785767959576	true	false	false	true
27de7162-b5ad-4f9d-8924-8cd0d30dec13	2026-09-22 10:49	2026-09-22 10:49	2026-09-22 10:49	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.6300	1.6000	1.6600	341.5150	10461.00	5255.00	5206.00	64	8	46107	6696	6.88575268817204	0.285794361752407	0.291216940959821	false	false	false	true
01c1c5ec-4756-48ec-8dc2-1eda562c570a	2026-09-22 10:49	2026-09-22 10:49	2026-09-22 10:49	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.6100	1.6000	1.6400	341.5000	10768.00	486.00	10282.00	67	14	46174	6696	6.89575866188769	0.28786224593622	0.28786224593622	false	false	false	true
4faa7e23-79b4-433a-80eb-ea87a20b6a39	2026-09-22 10:49	2026-09-22 10:48	2026-09-22 10:48	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7100	1.6800	1.7500	341.6250	27506.00	1032.00	26474.00	161	32	45710	6696	6.82646356033453	0.293274492112614	0.290103368570653	true	false	false	true
b2158526-58d5-42d6-8e17-c9c4dcf16e82	2026-09-22 10:48	2026-09-22 10:48	2026-09-22 10:48	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7000	1.6700	1.7000	341.6950	71051.00	71051.00	0.00	418	6	45173	6696	6.74626642771804	0.289337015975383	0.288559073290876	false	false	false	true
f4defa00-fe83-44c5-a23b-c93c301f74ab	2026-09-22 10:48	2026-09-22 10:48	2026-09-22 10:48	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.6000	1.5900	1.6300	341.4900	21610.00	21610.00	0.00	135	11	44469	6696	6.64112903225806	0.290695600411361	0.291323492711123	false	false	false	true
1562881f-9406-4e21-93d0-5ee5d78da255	2026-09-22 10:48	2026-09-22 10:48	2026-09-22 10:48	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.5000	1.4700	1.5200	341.2500	20563.00	20114.00	449.00	137	11	43644	6696	6.51792114695341	0.288149613005047	0.287117976050287	false	false	false	true
cd2f5977-f7f6-428a-bcd4-371ee6d54e42	2026-09-22 10:47	2026-09-22 10:47	2026-09-22 10:47	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.4900	1.4700	1.5100	341.2050	45609.00	0.00	44564.00	306	25	43303	6696	6.46699522102748	0.287353939784098	0.285436668790806	false	false	false	true
ed8bd8c2-d64d-4dd3-bc55-587f64c03a0d	2026-09-22 10:47	2026-09-22 10:47	2026-09-22 10:47	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.5000	1.4900	1.5000	341.2150	22050.00	22050.00	0.00	147	11	42640	6696	6.36798088410992	0.289179434154395	0.289179434154395	false	false	false	true
aa8e7b35-6a85-4ac1-9b7c-58d2ad6e8f1d	2026-09-22 10:46	2026-09-22 10:46	2026-09-22 10:46	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.3000	1.2900	1.3000	340.7136	15600.00	15600.00	0.00	120	6	41037	6696	6.12858422939068	0.288440062812233	0.288440062812233	false	false	false	true
b39498a6-6a1d-4ea7-88b8-635bd3b557ec	2026-09-22 10:33	2026-09-22 10:33	2026-09-22 10:33	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.0700	1.0500	1.0800	340.1100	12306.00	12199.00	107.00	115	8	37024	6696	5.52927120669056	0.291913638602987	0.286911078877902	false	false	false	true
ca925b3c-e1c8-4c01-97af-c71808f513cd	2026-09-22 10:31	2026-09-22 10:31	2026-09-22 10:31	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.1700	1.1600	1.1900	340.2900	11934.00	4680.00	7020.00	102	6	36209	6696	5.40755675029869	0.288406745251822	0.291540597523909	true	false	false	true
ef130014-3537-4d06-85b8-e6638d18c305	2026-09-22 10:28	2026-09-22 10:27	2026-09-22 10:27	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.3400	1.3300	1.3800	340.7650	15408.00	134.00	12862.00	115	11	33871	6696	5.05839307048984	0.29152853473792	0.29152853473792	false	false	false	true
df0eac2b-46ab-451b-850b-4f736b070068	2026-09-22 10:27	2026-09-22 10:27	2026-09-22 10:27	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.2500	1.2200	1.2700	340.5200	14365.00	13621.00	375.00	115	12	33286	6696	4.97102747909199	0.296391164219296	0.291490782167125	false	false	false	true
afb2ae2e-b6f8-4087-92d3-fb0a977bc3f4	2026-09-22 10:27	2026-09-22 10:27	2026-09-22 10:27	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.2700	1.2400	1.2900	340.5300	13207.00	12953.00	254.00	104	5	33395	6696	4.98730585424134	0.292492989876975	0.293956357234137	false	false	false	true
fe1fca3d-6138-484d-91ba-ec4e33d6df6f	2026-09-22 10:16	2026-09-22 10:16	2026-09-22 10:16	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.0400	1.0200	1.0500	339.8100	27999.00	27999.00	0.00	269	17	28631	6696	4.27583632019116	0.298107830648233	0.297231713146294	true	false	false	true
450d00c3-6c55-4e56-94b0-f16f7d8e26f6	2026-09-22 10:08	2026-09-22 10:08	2026-09-22 10:08	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	0.9800	0.9600	0.9800	339.4599	10088.00	9800.00	288.00	103	9	26210	6696	3.91427718040621	0.30297565810113	0.299692523265883	false	false	false	true
8a00e4d3-a343-4d54-b3da-d420b854a09f	2026-09-22 10:07	2026-09-22 10:07	2026-09-22 10:07	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	0.8500	0.8200	0.8500	338.9200	16127.00	16043.00	0.00	190	7	25662	6696	3.83243727598566	0.305816724112904	0.306200334786068	true	false	false	true
e06cf673-c23f-43ca-8089-5944dd6aff87	2026-09-22 10:02	2026-09-22 10:02	2026-09-22 10:02	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.3000	1.3000	1.3300	340.4250	14820.00	0.00	14820.00	114	6	22727	6696	3.39411589008363	0.304113956370275	0.304113956370275	false	false	false	true
0e0fe33a-aabc-4dc9-8ebe-dc1f7a09a334	2026-09-22 09:58	2026-09-22 09:58	2026-09-22 09:58	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.5000	1.5000	1.5300	340.9900	13202.00	152.00	13050.00	88	6	21518	6696	3.21356033452808	0.306325501640648	0.302265553491434	true	false	false	true
0fe86b75-af26-4aeb-820e-4daf83df2a2e	2026-09-22 09:57	2026-09-22 09:57	2026-09-22 09:57	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.5500	1.5100	1.5500	341.0900	27900.00	27900.00	0.00	180	13	20820	6696	3.10931899641577	0.303723014943497	0.303723014943497	true	false	false	true
814637e9-bc7e-4492-93c1-490bb97f9596	2026-09-22 09:56	2026-09-22 09:56	2026-09-22 09:56	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.3800	1.3700	1.4100	340.6800	13798.00	0.00	13798.00	100	16	20417	6696	3.04913381123059	0.302154726263125	0.300673786008202	true	false	false	true
6319ed09-e7db-4ef6-b5d6-aa1753f37221	2026-09-22 09:55	2026-09-22 09:54	2026-09-22 09:54	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.4500	1.4200	1.4600	340.7500	11162.00	722.00	0.00	77	5	19663	6696	2.93652927120669	0.305642096582432	0.30858572488876	true	false	false	true	false
edb5b95c-5f40-4265-8f93-7ee72e5a0bc1	2026-09-22 09:49	2026-09-22 09:48	2026-09-22 09:48	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.7200	1.6800	1.7200	341.3500	20812.00	20812.00	0.00	121	9	17222	6696	2.57198327359618	0.312687503133073	0.312687503133073	true	false	false	true
310dcf95-3696-4ee0-b7e4-fae202ccbc90	2026-09-22 09:46	2026-09-22 09:46	2026-09-22 09:46	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9400	1.8800	1.9800	341.0000	16699.00	10042.00	6277.00	86	21	16169	6696	2.41472520908005	0.310065405066256	0.313521655667513	false	false	false	true
9147719a-fc67-4040-ba28-9099bb3b5379	2026-09-22 09:45	2026-09-22 09:45	2026-09-22 09:45	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9900	1.9400	2.0100	342.0000	17294.00	16297.00	597.00	87	24	15460	6696	2.30884109916368	0.312276224802601	0.307867280632723	false	false	false	true
767a336c-ceac-4eb0-af35-fd16cb04fa54	2026-09-22 09:45	2026-09-22 09:45	2026-09-22 09:45	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9600	1.9600	1.9800	341.0000	13328.00	0.00	13328.00	68	6	15303	6696	2.28539426523297	0.313416352593616	0.313416352593616	false	false	false	true
6ba95710-ba89-4cca-883e-7e81a1902041	2026-09-22 09:45	2026-09-22 09:45	2026-09-22 09:45	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9700	1.9300	2.0000	341.0000	13812.00	10887.00	2925.00	70	7	15373	6696	2.29584826762246	0.311462997392358	0.312407603819751	false	false	false	true
25bc4eca-0095-4a72-b17e-3066506a7230	2026-09-22 09:45	2026-09-22 09:45	2026-09-22 09:45	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.9500	1.9300	1.9700	341.0000	10514.00	9542.00	972.00	54	5	15085	6696	2.25283751493429	0.30784175356202	0.311250967379898	false	false	false	true
46c29289-5932-42c9-b553-f3a493014ac1	2026-09-22 09:39	2026-09-22 09:39	2026-09-22 09:39	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	1.8000	1.8000	1.8500	341.2500	24660.00	0.00	24660.00	137	13	10716	6696	1.60035842293907	0.33017574512515	0.33017574512515	false	false	false	true
a00d452c-b3b3-4ecf-bbf6-cd0ecf2bf289	2026-09-22 09:36	2026-09-22 09:36	2026-09-22 09:36	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.0700	2.0500	2.1100	341.8160	41698.00	4642.00	37056.00	201	6	8973	6696	1.34005376344086	0.338496744651267	0.337277228881846	false	false	false	true
01276f6e-19a8-46d7-96cd-d99f13026865	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.3500	2.3000	2.4700	342.3000	28254.00	18720.00	7419.00	120	12	8404	6696	1.25507765830346	0.327948009329326	0.332970900611581	true	false	false	true
de5db206-f4b6-45b8-ab30-05e77dba4ced	2026-09-22 09:34	2026-09-22 09:34	2026-09-22 09:34	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.6000	2.5000	2.7800	342.5700	37645.00	0.00	16505.00	145	17	7673	6696	1.14590800477897	0.331101096385844	0.34199971637614	true	false	false	true	false
e5046713-1704-4bdb-ac1f-5f145e34a05f	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	3.6500	3.6000	3.7500	344.5550	14966.00	0.00	14966.00	41	10	6766	6696	1.01045400238949	0.33877681673099	0.344975948696346	false	false	false	true	false
28d0c01c-023e-4824-ace5-3099e9b305ee	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	3.9000	3.7500	3.9000	344.8450	13646.00	13646.00	0.00	35	5	6410	6696	0.957287933094385	0.351447004334335	0.351447004334335	false	false	false	true
dd84b785-ec19-4213-9491-a02d5c1f57d6	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	3.8600	3.7500	4.0500	344.7850	14298.00	1178.00	13120.00	37	8	6182	6696	0.923237753882915	0.352456677205882	0.373561109273602	false	false	false	true
1d150b29-0ef3-4291-ade3-425cbeda6c54	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	3.9800	3.9000	4.0500	344.9500	17494.00	15920.00	1574.00	44	5	6145	6696	0.917712066905615	0.354666703148932	0.347137486635838	false	false	false	true
e01313eb-b59e-4890-ab37-1680d6637500	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	3.5300	3.4500	3.7000	344.4400	14483.00	6348.00	7070.00	41	9	6002	6696	0.896356033452808	0.33404175246676	0.339495738281895	false	false	false	true
d0d00bb5-71f0-4729-883a-95f97e33c030	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	3.4400	3.4000	3.5000	344.1500	10312.00	349.00	9963.00	30	6	5869	6696	0.876493428912784	0.356885036112024	0.348212840683258	false	false	false	true
80129d68-1245-4cf9-bfd7-e945702395a7	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	3.1000	3.0500	3.2000	343.6000	26644.00	9300.00	14244.00	86	7	5117	6696	0.764187574671446	0.344211299607273	0.346232812241753	false	false	false	true
221c8ced-2e79-4b27-85c7-8f4a31faa0d1	2026-09-22 09:32	2026-09-22 09:31	2026-09-22 09:31	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.9100	2.8700	3.0500	343.1900	18614.00	0.00	18614.00	64	42	4914	6696	0.733870967741935	0.354797433267962	0.347766052555013	true	false	false	true
84635972-dde6-4ee3-a22b-3bb6caccb944	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	3.1300	3.0000	3.2000	343.5670	15940.00	13530.00	2410.00	51	7	4756	6696	0.710274790919952	0.354953329659386	0.357429343109363	false	false	false	true
ff5a8a46-29ce-45cb-87df-99d9070fdc90	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	3.1400	3.0500	3.3000	343.8700	21662.00	2562.00	19100.00	69	7	4620	6696	0.689964157706093	0.350244329337957	0.346542306094567	true	false	false	true
5730c80d-2a7e-4640-83fc-7904e0fcf2f2	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.9800	2.8600	3.0500	343.3500	10143.00	8383.00	1760.00	34	14	4363	6696	0.651583034647551	0.354657436736356	0.352166118880861	true	false	false	true
4a9c776e-f793-4185-a860-93f323c23170	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.5300	2.2700	2.6900	342.9700	10889.00	10889.00	0.00	43	14	3994	6696	0.59647550776583	0.346784108625527	0.339277676061293	true	false	false	true	false
8a327e5b-112a-45c9-8453-17030258fce1	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.3600	2.2600	2.5200	341.9890	19796.00	481.00	19315.00	84	17	3710	6696	0.554062126642772	0.339964494765353	0.348405544239246	true	false	false	true
2b906412-0a19-4b7f-aa77-04ea629d4ef9	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.5700	2.4400	2.6900	342.4000	15172.00	4878.00	8969.00	59	33	3568	6696	0.532855436081243	0.345901252924328	0.354007240988418	true	false	false	true
dc128264-2fc5-42e2-845d-fb226ccc26b2	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	AAPL	AAPL260923C00342500	call	342.5000	2026-09-23	2.7000	2.6500	2.7500	342.7200	95581.00	271.00	95310.00	354	17	3464	6696	0.517323775388292	0.350371095007297	0.360563658007225	true	false	false	true