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

dd16a011-52fe-4feb-9ed3-d92a8351b076	2026-09-24 09:59	2026-09-24 09:59	2026-09-24 09:59	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.2000	1.2000	1.2100	337.4200	12600.00	0.00	12600.00	105	5	14927	18540	0.80512405609493	0.317598636560495	0.317598636560495	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	4918530543600.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
376e406f-6e1b-401b-96ed-87aa54cd28a2	2026-09-24 09:59	2026-09-24 09:59	2026-09-24 09:59	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1800	1.1600	1.1800	337.3621	19189.00	14160.00	232.00	163	14	15450	18540	0.833333333333333	0.314279482391665	0.317429921814641	false	false	false	true
62768ddb-3b33-41d2-b34e-1f8f7d2f497f	2026-09-24 10:00	2026-09-24 09:59	2026-09-24 09:59	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1900	1.1700	1.2000	337.3600	10833.00	3587.00	6651.00	91	32	16743	18540	0.903074433656958	0.317572585001497	0.320681392873651	true	false	false	true
4f7dfda9-2c73-45b4-b42d-58627e5204a0	2026-09-24 10:00	2026-09-24 09:59	2026-09-24 09:59	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1800	1.1700	1.2000	337.3900	29289.00	9048.00	15756.00	248	62	16652	18540	0.898166127292341	0.317025872546441	0.319141505785605	false	false	false	true
2bdb1297-4795-41e6-b654-d6743d999810	2026-09-24 10:00	2026-09-24 09:59	2026-09-24 09:59	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1800	1.1600	1.2000	337.3300	48761.00	12132.00	31287.00	412	98	17164	18540	0.925782092772384	0.319110162485598	0.317492708609895	true	false	false	true
c763f451-18de-4d60-a2b3-927da28c9e35	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1800	1.1600	1.2000	337.3100	13962.00	9296.00	3024.00	118	44	17305	18540	0.933387270765912	0.322729997481064	0.318511056382567	true	false	false	true
bf1895fb-1757-46e1-89a9-bd9633f1b5ea	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1700	1.1500	1.1900	337.2800	16843.00	5539.00	10602.00	144	47	17449	18540	0.941154261057174	0.316930876775428	0.321616972231126	true	false	false	true
9cb5b7ce-82ab-460f-8979-f6f5e39029ef	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1700	1.1500	1.1800	337.2450	16937.00	7415.00	6714.00	145	37	17594	18540	0.948975188781014	0.318453624573571	0.320226555252531	false	false	false	true
8b298f92-1f5d-402a-9731-b47292e310d5	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1800	1.1500	1.1900	337.3500	11666.00	356.00	9672.00	99	13	17755	18540	0.957659115426106	0.316473066059124	0.318048385676023	true	false	false	true
ef61ae79-aa89-4806-940b-61a7db9de744	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.2400	1.2400	1.2600	337.4950	10809.00	1378.00	8681.00	87	24	19505	18540	1.05204962243797	0.31916677243001	0.321509990233203	false	false	false	true
dec3e24a-75c3-4313-9a75-c0fa3bcae4f5	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.2400	1.2100	1.2600	337.4500	24431.00	9388.00	10579.00	197	51	19352	18540	1.04379719525351	0.3212335237893	0.320736430890503	true	false	false	true
2024869c-2530-41e5-940e-f6fa1a75d6c5	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.2900	1.2600	1.2900	337.6199	13926.00	13926.00	0.00	108	5	19732	18540	1.06429341963323	0.319598985480019	0.319598985480019	false	false	false	true
82a0c6ee-b5d4-40bb-aed2-6105c1df87c7	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.2800	1.2700	1.3000	337.6300	28519.00	5707.00	19716.00	222	51	20098	18540	1.08403451995685	0.321081583468209	0.320604169897711	true	false	false	true
f6f30aa7-9173-4fd5-84e2-f559909ee44c	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.2800	1.2600	1.3000	337.5400	15085.00	4254.00	3711.00	118	32	20297	18540	1.09476806903991	0.318425934393078	0.322257708605234	false	false	false	true
11183447-f706-4889-8192-1e37c5c31d2c	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.2500	1.2300	1.2800	337.4500	14495.00	876.00	11751.00	116	41	20498	18540	1.10560949298813	0.321995604893571	0.322294666311679	true	false	false	true
93b12364-a9f8-4353-9d18-5c33b84fd4d1	2026-09-24 10:01	2026-09-24 10:01	2026-09-24 10:01	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.2600	1.2400	1.2700	337.4401	10562.00	7810.00	2627.00	84	21	20991	18540	1.13220064724919	0.322540042633133	0.32280813009879	true	false	false	true
202845db-1ce1-470d-b80b-d4c3336268b5	2026-09-24 10:01	2026-09-24 10:01	2026-09-24 10:01	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.2000	1.1900	1.2400	337.4100	32968.00	1597.00	30037.00	275	47	21421	18540	1.15539374325782	0.321254334857761	0.316545878524719	true	false	false	true
6489382a-3277-4226-aedf-7c9c21765ddf	2026-09-24 10:01	2026-09-24 10:01	2026-09-24 10:01	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1300	1.1000	1.2000	337.2400	23384.00	2254.00	21130.00	207	71	22265	18540	1.20091693635383	0.314488446115311	0.31889200651168	true	false	false	true
00fb6ea8-63bb-4010-b8e7-b82b370a5877	2026-09-24 10:01	2026-09-24 10:01	2026-09-24 10:01	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1100	1.1000	1.1300	337.2500	14664.00	1011.00	13653.00	132	9	22470	18540	1.21197411003236	0.313776801639704	0.312021328253748	false	false	false	true
dceaec75-893b-48e3-87df-a4596b5ef7a4	2026-09-24 10:01	2026-09-24 10:01	2026-09-24 10:01	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1000	1.0600	1.1200	337.1400	12616.00	1437.00	10313.00	115	36	22688	18540	1.22373247033441	0.313364048609105	0.312703611251959	true	false	false	true
d3d1a017-379d-4eb4-9518-11a4c13e88ef	2026-09-24 10:02	2026-09-24 10:02	2026-09-24 10:02	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1000	1.0900	1.1100	337.2550	34649.00	34540.00	109.00	315	21	23321	18540	1.25787486515642	0.313177469806135	0.308576693557597	true	false	false	true
9a1fd0bd-b0d4-4745-8b53-e58ce9a761b2	2026-09-24 10:02	2026-09-24 10:02	2026-09-24 10:02	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.0400	1.0400	1.0700	337.1100	28116.00	1276.00	26840.00	270	18	23718	18540	1.27928802588997	0.309341605842187	0.312576718179773	false	false	false	true
1eb39d20-59ef-496a-a37e-fbe320fa575d	2026-09-24 10:02	2026-09-24 10:02	2026-09-24 10:02	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1100	1.1100	1.1200	337.2250	23532.00	0.00	23532.00	212	6	24256	18540	1.30830636461704	0.313275626775563	0.313275626775563	true	false	false	true
bd9a41d9-57c7-4122-a3c3-bf667d7afb31	2026-09-24 10:02	2026-09-24 10:02	2026-09-24 10:02	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.0100	1.0000	1.0300	336.8900	27499.00	1214.00	26285.00	271	36	24777	18540	1.33640776699029	0.30838307520324	0.31353641567308	true	false	false	true
f44e0a22-deff-4cbf-9ebd-9d2e554ac4f6	2026-09-24 10:02	2026-09-24 10:02	2026-09-24 10:02	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	0.9700	0.9400	0.9900	336.8700	17443.00	12191.00	4294.00	180	51	25492	18540	1.37497303128371	0.308827362185722	0.309536700169625	true	false	false	true
2a2381d6-2333-4c05-9e02-bf3767a27b92	2026-09-24 10:03	2026-09-24 10:03	2026-09-24 10:03	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	0.9400	0.9300	0.9600	336.8800	11980.00	11696.00	94.00	127	14	26649	18540	1.4373786407767	0.302400604258297	0.30406910269037	false	false	false	true
e3c08688-2be5-4b11-b536-b7a67805cc49	2026-09-24 10:03	2026-09-24 10:03	2026-09-24 10:03	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	0.9700	0.9500	1.0000	337.0600	21316.00	20542.00	480.00	220	32	26913	18540	1.45161812297735	0.300944701629326	0.3020129911102	true	false	false	true
815ba41e-2e5c-436b-9bce-1edc1fc41661	2026-09-24 10:05	2026-09-24 10:05	2026-09-24 10:05	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.0800	1.0700	1.0900	337.2100	13062.00	1620.00	11442.00	121	9	28805	18540	1.55366774541532	0.307226734083708	0.307616929511005	true	false	false	true
ed4b4982-3a3a-46d4-8234-949cd2289c38	2026-09-24 10:06	2026-09-24 10:06	2026-09-24 10:06	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1200	1.1000	1.1300	337.3100	11054.00	451.00	10492.00	99	23	29204	18540	1.57518878101402	0.30990094923473	0.307411772583241	true	false	false	true
1dd6f0f7-ef85-439e-a27e-55c7c9710b57	2026-09-24 10:07	2026-09-24 10:07	2026-09-24 10:07	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1500	1.1100	1.1700	337.5200	17138.00	16448.00	690.00	149	18	30262	18540	1.63225458468177	0.306642652120991	0.304623503995235	true	false	false	true
dc8b63f7-717d-4616-88ce-13aced4b59be	2026-09-24 10:08	2026-09-24 10:07	2026-09-24 10:07	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3100	1.2900	1.3100	337.8750	17025.00	16375.00	0.00	130	12	30907	18540	1.66704422869471	0.309765072597842	0.310574866582549	false	false	false	true
72299166-1c80-429d-a01c-1a54ba719f8d	2026-09-24 10:08	2026-09-24 10:07	2026-09-24 10:07	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3100	1.3000	1.3400	337.8800	15491.00	1460.00	14031.00	118	22	31100	18540	1.67745415318231	0.310915797732024	0.31030503643509	false	false	false	true
bbab8f81-7397-4eb1-83b1-050d8eb38615	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3100	1.2800	1.3300	337.9000	14541.00	5538.00	8743.00	111	31	31771	18540	1.71364617044229	0.308142736526426	0.307707662974294	false	false	false	true
d1c17fb2-0155-498b-bb97-f5c0499289d4	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3000	1.2900	1.3300	337.9050	18392.00	661.00	17599.00	141	19	32199	18540	1.73673139158576	0.308300859562237	0.310470009231529	true	false	false	true
ed8bb4cc-2ed3-4c87-aca1-601533305c1a	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3800	1.3600	1.3900	338.0650	16107.00	10354.00	4520.00	117	16	32644	18540	1.76073354908306	0.307762521750134	0.309262660871424	true	false	false	true
32c7b28f-dd90-44f7-91fb-8e569de6d056	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.4600	1.4500	1.4700	338.2250	10350.00	1171.00	3631.00	71	23	33513	18540	1.80760517799353	0.313472116425544	0.313754363689674	true	false	false	true
65f082d8-5363-451a-8447-2c232740559e	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.4400	1.4100	1.4500	338.1400	20820.00	860.00	19817.00	145	22	33719	18540	1.81871628910464	0.312474853246523	0.312577613626327	true	false	false	true
e0791859-9450-4c9b-af2d-56fcb5c6a691	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3900	1.3600	1.4200	338.0200	19488.00	2230.00	15454.00	140	37	33973	18540	1.8324163969795	0.31424978594633	0.313242489386959	true	false	false	true
2b711f22-dc3a-4023-b468-f3efacb6d5f4	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3400	1.3200	1.3500	337.9600	17158.00	17026.00	132.00	128	9	35021	18540	1.88894282632147	0.313650804226195	0.312015386640333	false	false	false	true
1e8a38d0-2ba6-42ec-9325-3e58e542affb	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3700	1.3600	1.3800	338.0500	13571.00	1104.00	11919.00	99	20	35348	18540	1.90658036677454	0.311589756359765	0.310089514621099	false	false	false	true
0350afd4-9b34-491b-b985-70146a1dc453	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3700	1.3500	1.3700	338.0100	16688.00	14522.00	1350.00	122	11	35718	18540	1.92653721682848	0.310923024042257	0.310785966249576	false	false	false	true
cfd40552-f379-4750-b634-2b9e765468e7	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3000	1.3000	1.3200	337.9000	25745.00	264.00	25350.00	198	24	36104	18540	1.94735706580367	0.309224702541081	0.307707662974294	false	false	false	true
b0e99756-b1ee-426c-aa0f-89410317f172	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.3200	1.3000	1.3300	337.9200	14258.00	266.00	13992.00	108	8	35881	18540	1.93532901833873	0.309657350432245	0.311170941082517	false	false	false	true
328ff968-555b-49f2-9cdc-97f187951f23	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1000	1.0900	1.1200	337.4000	10780.00	10450.00	220.00	98	8	38963	18540	2.10156418554477	0.304639371175095	0.302869959552945	true	false	false	true
03c7594d-4924-4fd0-9332-2e7318eb335f	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.0000	0.9900	1.0200	337.0500	12094.00	2206.00	9888.00	121	34	39369	18540	2.12346278317152	0.303163711821799	0.305773434086741	false	false	false	true
1670be9e-d610-462f-a85e-642772944b7b	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.0300	1.0000	1.0300	337.0948	11433.00	11433.00	0.00	111	11	39929	18540	2.15366774541532	0.306843276945692	0.306843276945692	true	false	false	true
878eb4c9-fa62-45b4-931c-b8162b308215	2026-09-24 10:15	2026-09-24 10:15	2026-09-24 10:15	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1200	1.1000	1.1400	337.4000	11445.00	4552.00	6893.00	102	5	41847	18540	2.25711974110032	0.305068438049441	0.304453688128884	true	false	false	true
faf10df7-c223-4634-ab57-71cfc15991d4	2026-09-24 10:19	2026-09-24 10:19	2026-09-24 10:19	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.1600	1.1500	1.1600	337.6400	11600.00	11600.00	0.00	100	6	43400	18540	2.34088457389428	0.299981952699198	0.299981952699198	false	false	false	true
48cb276f-a549-49db-845d-ebaa639b4aaa	2026-09-24 10:21	2026-09-24 10:21	2026-09-24 10:21	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.0600	1.0300	1.0900	337.3920	58398.00	1298.00	56788.00	551	53	44692	18540	2.41057173678533	0.299199714382541	0.293727362036145	true	false	false	true
56bc7b22-a401-4e50-8d2f-ce9c6f8e4bfb	2026-09-24 10:21	2026-09-24 10:21	2026-09-24 10:21	AAPL	AAPL260925C00340000	call	340.0000	2026-09-25	1.0300	1.0300	1.0500	337.3939	10452.00	0.00	5356.00	101	17	44857	18540	2.41947141316073	0.291228706932001	0.293632219695285	false	false	false	true