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

a7fd2fc9-c909-4f6b-bc7a-f2374ed89a8b	2026-08-19 10:03	2026-08-19 10:03	2026-08-19 10:03	AAPL	AAPL260821C00315000	call	315.0000	2026-08-21	4.0200	4.0000	4.1000	316.8900	269787.00	407.00	269380.00	671	10	27752	23027	1.20519390280975	0.32064100326168	0.31620267250824	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	4861029474400.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bf787a0a-5719-42ab-853e-002c69adf026	2026-08-19 10:03	2026-08-19 10:03	2026-08-19 10:03	AAPL	AAPL260821C00315000	call	315.0000	2026-08-21	4.2000	4.1000	4.2500	317.1300	1149541.00	1148715.00	826.00	2737	78	30577	23027	1.32787597168541	0.321891011914127	0.324302128180855	false	false	false	true	false
2f712683-5958-4a7e-bc91-733148d8e7f4	2026-08-19 10:03	2026-08-19 10:03	2026-08-19 10:03	AAPL	AAPL260821C00312500	call	312.5000	2026-08-21	5.9000	5.7500	5.9500	317.1300	182231.00	182231.00	0.00	309	11	15402	10023	1.53666566896139	0.336034441259664	0.327467073660374	false	false	false	true	false
22c789f6-b742-423e-87fa-286c77ad6be7	2026-08-19 10:03	2026-08-19 10:03	2026-08-19 10:03	AAPL	AAPL260918C00320000	call	320.0000	2026-09-18	8.0000	7.8500	8.0500	317.1300	185600.00	185600.00	0.00	232	16	2242	35287	0.063536146456202	0.247016388826403	0.244898887677233	false	false	false	true	false
a80a2692-31c1-4772-ba46-2ac6aec427f9	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	AAPL	AAPL260918C00310000	call	310.0000	2026-09-18	13.4400	13.4500	13.6000	316.9250	147815.00	0.00	49630.00	110	6	1135	20368	0.0557246661429694	0.248878477522755	0.248878477522755	true	false	false	true	false
244a4810-bd29-469f-92c9-029f217fa800	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.4000	4.2000	4.4000	317.2500	219899.00	219899.00	0.00	500	7	7851	27225	0.288374655647383	0.245430726156522	0.245903007432907	false	false	false	true	false
fa881d6d-1f45-4f71-adad-0b3f73aa66a0	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.4000	4.2500	4.4500	317.3600	220125.00	220125.00	0.00	500	11	8351	27225	0.30674012855831	0.244828410474768	0.24637068155441	true	false	false	true	false
3af1ad0f-ed01-4066-bb0e-685f454bd8e5	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.4500	4.3000	4.4500	317.4436	222500.00	222500.00	0.00	500	5	8858	27225	0.325362718089991	0.245551242000775	0.245551242000775	false	false	false	true	false
eac6d720-1992-415b-a318-f62a8ce418c9	2026-08-19 10:05	2026-08-19 10:05	2026-08-19 10:05	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	7.8000	7.8000	8.0000	317.0200	103740.00	0.00	103740.00	133	14	6919	11597	0.596619815469518	0.244487135014418	0.244487135014418	true	false	false	true	false
d0101701-7386-4d32-bb42-4ec3b3ced7c6	2026-08-19 10:08	2026-08-19 10:08	2026-08-19 10:08	AAPL	AAPL260911C00330000	call	330.0000	2026-09-11	3.2000	3.0500	3.2500	316.5600	104640.00	77120.00	27520.00	327	9	1280	2787	0.459275206315034	0.247232309404013	0.24692191322662	false	false	false	true	false
0faec758-a66b-4222-85a3-4e6836b77ae2	2026-08-19 10:14	2026-08-19 10:14	2026-08-19 10:14	AAPL	AAPL260918C00340000	call	340.0000	2026-09-18	2.1700	2.1600	2.2500	317.4600	217089.00	0.00	217089.00	1000	13	2906	16537	0.175727157283667	0.244209547377702	0.245446003437035	true	false	false	true	false
215b40d9-b5ce-4d97-ba32-dcd405926f75	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	AAPL	AAPL281215C00380000	call	380.0000	2028-12-15	45.1900	43.2000	45.2000	317.4488	402172.00	361537.00	40635.00	89	8	117	1144	0.102272727272727	0.289225697838154	0.289484715318007	false	false	false	true	false
6ca8049d-08d0-436d-99b0-5c9bae421f01	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	AAPL	AAPL281215C00380000	call	380.0000	2028-12-15	45.4700	44.7500	45.5500	317.4700	100025.00	50055.00	49970.00	22	6	216	1144	0.188811188811189	0.290982382289696	0.290464344356776	false	false	false	true	false
330be60e-ad8f-47d3-802d-e8cd53131af8	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	AAPL	AAPL281215C00380000	call	380.0000	2028-12-15	45.4900	44.7500	45.5500	317.4750	195605.00	100160.00	95445.00	43	6	267	1144	0.233391608391608	0.29096905531471	0.290710038576599	false	false	false	true	false
7d94799e-3b0a-430b-afef-f76ac7d64c8f	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	AAPL	AAPL281215C00400000	call	400.0000	2028-12-15	39.3500	38.8500	39.4000	317.4800	125910.00	74820.00	51090.00	32	8	234	4603	0.0508364110362807	0.289505970647297	0.288986530522214	false	false	false	true	false
8810be51-a05e-4764-a22d-05be5ae16e52	2026-08-19 10:19	2026-08-19 10:19	2026-08-19 10:19	AAPL	AAPL260821C00307500	call	307.5000	2026-08-21	10.5100	10.4500	10.6000	317.5250	105100.00	0.00	105100.00	100	5	966	8804	0.109722853248523	0.352029858136086	0.352029858136086	false	false	false	true	false
6965c407-df60-4fa6-a4da-62885443bc3a	2026-08-19 10:19	2026-08-19 10:19	2026-08-19 10:19	AAPL	AAPL281215C00380000	call	380.0000	2028-12-15	45.7000	45.3000	45.7000	317.6650	114240.00	105110.00	9130.00	25	5	382	1144	0.333916083916084	0.291498157247026	0.291239275300594	false	false	false	true	false
51da44dc-8352-423a-be59-383ad3ea0422	2026-08-19 10:28	2026-08-19 10:28	2026-08-19 10:28	AAPL	AAPL260821P00320000	put	320.0000	2026-08-21	5.1500	5.1500	5.3000	316.1100	1465015.00	90480.00	1374535.00	2843	83	4215	9285	0.453957996768982	0.282497533290896	0.302168022372627	false	false	false	true	false
feefe694-2fff-4ea9-a745-456a440a0e04	2026-08-19 10:35	2026-08-19 10:35	2026-08-19 10:35	AAPL	AAPL270115C00380000	call	380.0000	2027-01-15	4.3500	4.3500	4.5500	316.6700	592905.00	0.00	592905.00	1363	34	1427	7029	0.203016076255513	0.252406669934624	0.252406669934624	false	false	false	true	false
45423757-99b3-4bb8-9e7e-ace85e605d9e	2026-08-19 10:39	2026-08-19 10:39	2026-08-19 10:39	AAPL	AAPL261016C00355000	call	355.0000	2026-10-16	2.1000	2.1000	2.1200	316.1400	108360.00	0.00	108360.00	516	8	1905	4639	0.41064884673421	0.243982679012671	0.243982679012671	false	false	false	true	false
b5665703-4ffb-4f73-a95f-9203929164a4	2026-08-19 10:43	2026-08-19 10:42	2026-08-19 10:42	AAPL	AAPL261120C00365000	call	365.0000	2026-11-20	3.4500	3.3500	3.5500	316.0300	429525.00	192165.00	104535.00	1245	13	1333	4453	0.299348753649225	0.257858411217865	0.257858411217865	true	false	false	true	false
c5c84c4d-3f58-4a79-ac27-48d4f55e0274	2026-08-19 10:43	2026-08-19 10:43	2026-08-19 10:43	AAPL	AAPL261120C00365000	call	365.0000	2026-11-20	3.5000	3.4500	3.6500	316.1100	114100.00	101500.00	12600.00	326	23	2214	4453	0.497192903660454	0.258771922118756	0.258771922118756	false	false	false	true	false
8de03e22-499a-448c-a659-bbf1d395cf64	2026-08-19 10:43	2026-08-19 10:43	2026-08-19 10:43	AAPL	AAPL261120C00370000	call	370.0000	2026-11-20	2.9100	2.8800	2.9100	316.1100	323883.00	323883.00	0.00	1113	44	1178	4001	0.29442639340165	0.259796952455117	0.259796952455117	false	false	false	true	false
048defb2-1458-4aed-81be-ca798dd3822f	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	AAPL	AAPL260904C00320000	call	320.0000	2026-09-04	5.5000	5.3000	5.5000	317.0800	121550.00	121550.00	0.00	221	5	1247	6953	0.179347044441248	0.249296767537313	0.249296767537313	true	false	false	true	false
e1920087-ede2-4b13-b534-381d980ed707	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.5500	4.5000	4.5500	317.5900	221585.00	221585.00	0.00	487	6	12173	27225	0.44712580348944	0.247181575947682	0.247181575947682	false	false	false	true	false
4d11c430-2beb-4375-a1f2-1f730053735d	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.6000	4.5000	4.6000	317.6100	223100.00	223100.00	0.00	485	14	12674	27225	0.465528007346189	0.248513918451629	0.248513918451629	false	false	false	true	false
804ee68f-6ace-41ca-9f0f-e050ba877da4	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.6000	4.5500	4.6000	317.6800	223100.00	223100.00	0.00	485	10	13165	27225	0.48356290174472	0.24782131709975	0.24782131709975	false	false	false	true	false
872ce5e6-38c0-402e-8e3d-27b107bbb91b	2026-08-19 10:57	2026-08-19 10:56	2026-08-19 10:56	AAPL	AAPL260821C00317500	call	317.5000	2026-08-21	3.1500	3.0500	3.2000	317.9400	957255.00	955705.00	0.00	3039	80	22336	9111	2.45154209197673	0.311744505085523	0.313407080840598	false	false	false	true	false
63f681dc-1b95-4ea6-a8a3-1a16ce61707c	2026-08-19 10:57	2026-08-19 10:56	2026-08-19 10:56	AAPL	AAPL270115C00350000	call	350.0000	2027-01-15	11.0000	10.8000	11.0000	317.9400	129783.00	129783.00	0.00	118	16	1922	32585	0.0589841951818321	0.257782153321343	0.257717251212743	false	false	false	true	false
ec443c0f-f7f4-49b3-af9f-34e6489b9c5d	2026-08-19 10:57	2026-08-19 10:57	2026-08-19 10:57	AAPL	AAPL270617P00150000	put	150.0000	2027-06-17	0.6100	0.5100	0.6100	318.0400	121550.00	121550.00	0.00	2000	26	2001	4489	0.44575629316106	0.419549909518808	0.421675655768109	false	false	false	true	false
ae29773d-6d26-4bde-a794-16b7415a4ced	2026-08-19 10:58	2026-08-19 10:58	2026-08-19 10:58	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.8000	4.7000	4.8000	318.2220	144000.00	144000.00	0.00	300	8	14746	27225	0.541634527089073	0.248484563935364	0.248484563935364	false	false	false	true	false
d525374f-1e8b-4980-948d-f4ba701d109f	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	AAPL	AAPL260821P00315000	put	315.0000	2026-08-21	1.5900	1.5700	1.6400	318.0200	109710.00	14310.00	95400.00	690	5	11909	20018	0.594914576880807	0.307407779033767	0.307407779033767	false	false	false	true	false
ef2a67c7-0b8e-4353-b236-8f53af464388	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.8000	4.7000	4.8000	318.0700	234240.00	234240.00	0.00	488	5	15556	27225	0.571386593204775	0.25001030892821	0.25001030892821	false	false	false	true	false
c7523b79-131a-41d6-9086-94c346611486	2026-08-19 11:02	2026-08-19 11:02	2026-08-19 11:02	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.9000	4.8000	4.9000	318.4899	222950.00	222950.00	0.00	455	15	16624	27225	0.610615243342516	0.248788566369904	0.248788566369904	false	false	false	true	false
1f6ef2d2-d49f-4656-aad1-1aabac11d690	2026-08-19 11:04	2026-08-19 11:04	2026-08-19 11:04	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	8.6000	8.5000	8.6500	318.5850	249400.00	201240.00	48160.00	290	18	7887	11597	0.680089678365094	0.248299048896966	0.248299048896966	false	false	false	true	false
2d8915ec-cf2b-4a2b-9841-07c3a868b891	2026-08-19 11:04	2026-08-19 11:04	2026-08-19 11:04	AAPL	AAPL260821C00320000	call	320.0000	2026-08-21	2.4200	2.4100	2.4400	318.8372	112752.00	0.00	112752.00	465	6	41660	30598	1.36152689718282	0.311727076878031	0.311266673981041	false	false	false	true	false
71721e87-9ab4-4ad5-a105-64930bfe11de	2026-08-19 11:04	2026-08-19 11:04	2026-08-19 11:04	AAPL	AAPL260821C00320000	call	320.0000	2026-08-21	2.4300	2.3900	2.4400	318.8400	110076.00	242.00	109834.00	453	7	42224	30598	1.37995947447546	0.312205029074445	0.312205029074445	true	false	false	true	false
d0ccaaa8-8f3c-4a6b-bb59-0d6ec798212f	2026-08-19 11:06	2026-08-19 11:06	2026-08-19 11:06	AAPL	AAPL260821C00320000	call	320.0000	2026-08-21	2.6300	2.6100	2.6300	319.2000	118350.00	118350.00	0.00	450	5	44584	30598	1.45708869860775	0.316047092480963	0.316047092480963	false	false	false	true	false
a9969b72-5f9a-4268-a2da-f691274a8673	2026-08-19 11:08	2026-08-19 11:08	2026-08-19 11:08	AAPL	AAPL260821C00320000	call	320.0000	2026-08-21	2.3700	2.3200	2.3700	318.6950	177985.00	177985.00	0.00	751	33	46969	30598	1.53503496960586	0.312876988838256	0.310490162873234	false	false	false	true	false
9efc51d9-f283-4964-9ed5-6ea1e4a3d627	2026-08-19 11:20	2026-08-19 11:20	2026-08-19 11:20	AAPL	AAPL270219C00310000	call	310.0000	2027-02-19	32.6000	32.3500	32.8000	318.7400	325999.00	88019.00	237980.00	100	8	161	1532	0.10509138381201	0.277264844986076	0.277370710977134	false	false	false	true	false
e9f9e002-4860-4de8-a403-3cd726866484	2026-08-19 11:33	2026-08-19 11:33	2026-08-19 11:33	AAPL	AAPL260819C00317500	call	317.5000	2026-08-19	1.1400	1.1400	1.2000	317.6400	245561.00	119.00	245442.00	2154	88	115174	3975	28.9745911949686	0.365617653669542	0.373379912304299	false	false	false	true	false
1f955735-f876-45bf-86f9-c70107b748e8	2026-08-19 11:33	2026-08-19 11:33	2026-08-19 11:33	AAPL	AAPL260821C00317500	call	317.5000	2026-08-21	2.9500	2.9000	2.9500	317.6300	111508.00	111508.00	0.00	378	21	25009	9111	2.74492371858193	0.301918417616359	0.304052224419755	false	false	false	true	false
9ddecd9f-aff8-49f6-b02c-4378a05eae26	2026-08-19 11:37	2026-08-19 11:37	2026-08-19 11:37	AAPL	AAPL261016P00310000	put	310.0000	2026-10-16	8.5500	8.3000	8.5500	316.8300	156465.00	156465.00	0.00	183	22	538	5349	0.100579547578987	0.250065026250719	0.250065026250719	false	false	false	true	false
18926bfa-0198-428b-bce2-39ae9c9f4927	2026-08-19 11:39	2026-08-19 11:39	2026-08-19 11:39	AAPL	AAPL270115C00320000	call	320.0000	2027-01-15	22.1600	22.1500	22.5000	316.9050	132970.00	0.00	117395.00	60	9	1026	36140	0.0283895960154953	0.262720087346071	0.262720087346071	false	false	false	true	false
a9b56174-bb70-43a7-91c4-cd888eb80ab6	2026-08-19 11:43	2026-08-19 11:43	2026-08-19 11:43	AAPL	AAPL260828C00315000	call	315.0000	2026-08-28	6.0000	5.9500	6.0000	316.4816	261000.00	261000.00	0.00	435	30	5100	6867	0.742682394058541	0.256110255051778	0.256110255051778	false	false	false	true	false
4e8bf6ea-0ae1-48ed-954c-6f71c2b187ae	2026-08-19 11:58	2026-08-19 11:57	2026-08-19 11:57	AAPL	AAPL260918C00315000	call	315.0000	2026-09-18	10.0500	9.9500	10.0500	315.9700	102510.00	102510.00	0.00	102	7	3285	10580	0.310491493383743	0.251062577487332	0.251062577487332	false	false	false	true	false
25a86221-e3cf-4d95-8bfa-5d544890ed85	2026-08-19 12:08	2026-08-19 12:08	2026-08-19 12:08	AAPL	AAPL270115C00320000	call	320.0000	2027-01-15	22.3900	22.2500	22.5000	316.9500	111959.00	94039.00	17920.00	50	6	1117	36140	0.0309075816270061	0.265530147073629	0.265405424013828	false	false	false	true	false
eb88dc0c-e206-46f4-83b1-46aa8781f69c	2026-08-19 12:14	2026-08-19 12:13	2026-08-19 12:13	AAPL	AAPL260821C00320000	call	320.0000	2026-08-21	1.5900	1.5900	1.6100	317.0600	101919.00	0.00	101919.00	641	32	59885	30598	1.95715406235702	0.295773523301994	0.297170978694938	false	false	false	true	false
59ad1559-c33b-4838-b3f7-bde2520db1d8	2026-08-19 12:32	2026-08-19 12:32	2026-08-19 12:32	AAPL	AAPL260911P00315000	put	315.0000	2026-09-11	6.7500	6.6500	6.7500	316.3000	105300.00	105300.00	0.00	156	8	392	477	0.821802935010482	0.244915962244832	0.244915962244832	false	false	false	true	false
25068479-5889-407a-aef6-676f86e8d561	2026-08-19 12:37	2026-08-19 12:36	2026-08-19 12:36	AAPL	AAPL281215C00330000	call	330.0000	2028-12-15	63.7500	63.5000	65.5000	315.7358	637500.00	0.00	637500.00	100	6	103	2923	0.0352377694149846	0.297451523758109	0.297451523758109	false	false	false	true	false