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

a3c9e569-076d-4549-89c8-00cc61b281f2	2026-08-20 14:55	2026-08-20 14:54	2026-08-20 14:54	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	7.2500	7.1500	7.2500	315.4650	1087500.00	1087500.00	0.00	1500	5	3044	15839	0.19218384999053	0.247515149717506	0.247515149717506	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	4861029474400.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e233bb7f-ba54-4464-98b5-d89af2d3fd49	2026-08-20 15:14	2026-08-20 15:14	2026-08-20 15:14	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	6.8500	6.8500	6.9500	314.6100	685000.00	0.00	685000.00	1000	30	4076	15839	0.257339478502431	0.245473838567361	0.245473838567361	false	false	false	true	false
5acb7c92-816f-49d6-ad8a-63bba543a1eb	2026-08-20 15:15	2026-08-20 15:15	2026-08-20 15:15	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	6.8000	6.8000	6.9500	314.5599	680000.00	0.00	680000.00	1000	13	5076	15839	0.320474777448071	0.24476968030894	0.24476968030894	false	false	false	true	false
213f6b5d-dfae-4f6a-ac8e-bfa6d98b4579	2026-08-20 15:15	2026-08-20 15:15	2026-08-20 15:15	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	6.8000	6.8000	6.9500	314.4400	680680.00	0.00	680680.00	1001	26	6077	15839	0.383673211692657	0.245300795533787	0.245680505615686	false	false	false	true	false
3817ec53-1ede-4109-9cd5-191bbf6239bb	2026-08-20 15:41	2026-08-20 15:41	2026-08-20 15:41	AAPL	AAPL261016P00310000	put	310.0000	2026-10-16	9.9500	9.8500	10.0000	313.2750	131340.00	6965.00	124375.00	132	9	457	5615	0.0813891362422084	0.251994615689544	0.251994615689544	true	false	false	true	false
285ea0f2-21ed-47a5-8080-070cf22ee7b7	2026-08-20 15:49	2026-08-20 15:49	2026-08-20 15:49	AAPL	AAPL261016C00275000	call	275.0000	2026-10-16	41.0000	41.0000	42.1500	312.5800	287000.00	0.00	287000.00	70	7	86	1497	0.0574482297929192	0.280805493274602	0.280805493274602	false	false	false	true	false
06b5b01d-de4b-423c-8d50-74fba069003e	2026-08-20 15:58	2026-08-20 15:57	2026-08-20 15:57	AAPL	AAPL260821P00315000	put	315.0000	2026-08-21	4.6500	4.6500	4.7500	310.7700	125098.00	0.00	125098.00	269	18	58350	19918	2.92951099507983	0.281140141406433	0.281140141406433	true	false	false	true	false
ed3d8ddb-c1bc-4209-b8e5-d7632b1c7f57	2026-08-20 15:59	2026-08-20 15:59	2026-08-20 15:59	AAPL	AAPL260821C00317500	call	317.5000	2026-08-21	0.2800	0.2700	0.3000	311.3800	138831.00	0.00	138691.00	4910	137	73220	10793	6.78402668396183	0.310107770320691	0.303622653150555	true	false	false	true	false
17973e79-36e8-462c-add0-dad356ff00dc	2026-08-20 15:59	2026-08-20 15:59	2026-08-20 15:59	AAPL	AAPL260828C00322500	call	322.5000	2026-08-28	1.1500	1.0900	1.1600	311.3074	324642.00	324529.00	113.00	2823	43	6672	1401	4.76231263383298	0.253572415067439	0.251674464271208	false	false	false	true	false
dbad0513-be7f-4a21-8ae4-bdc94afdb468	2026-08-21 09:36	2026-08-21 09:35	2026-08-21 09:35	AAPL	AAPL260828P00300000	put	300.0000	2026-08-28	1.6000	1.5900	1.6000	308.2100	104480.00	104480.00	0.00	653	5	891	4953	0.179890975166566	0.276814500902376	0.276814500902376	true	false	false	true	false
111b89c4-1b12-4379-ac78-9e372bcedee9	2026-08-21 09:38	2026-08-21 09:38	2026-08-21 09:38	AAPL	AAPL260821C00310000	call	310.0000	2026-08-21	1.0000	0.9900	1.0000	308.8488	108200.00	108200.00	0.00	1082	11	7602	30535	0.248960209595546	0.451815919991055	0.451815919991055	true	false	false	true	false
d056a319-27af-4474-90a2-91d2b2e317c0	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	AAPL	AAPL260821C00310000	call	310.0000	2026-08-21	0.8800	0.8600	0.9000	308.4300	165691.00	0.00	165430.00	1883	10	9893	30535	0.323988865236614	0.454900684169062	0.459552885900357	true	false	false	true	false
d08429d6-e02b-4cc9-9d15-e97e274e25e5	2026-08-21 09:40	2026-08-21 09:40	2026-08-21 09:40	AAPL	AAPL260821P00325000	put	325.0000	2026-08-21	16.7500	15.9500	16.9500	308.2050	167500.00	6700.00	127300.00	100	20	100	2810	0.0355871886120996	0.650054762354698	1.13972599986446	false	false	false	true	false
b3f1864e-3e72-4b5f-9da8-ed577f2240b8	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	AAPL	AAPL260821P00310000	put	310.0000	2026-08-21	3.2000	3.0500	3.2000	307.1300	487669.00	487669.00	0.00	1524	69	10175	13879	0.73312198285179	0.455697356344664	0.39643136399151	false	false	false	true	false
2ddfdc24-1385-4c96-a17a-9ec230e256bd	2026-08-21 09:59	2026-08-21 09:59	2026-08-21 09:59	AAPL	AAPL261120P00290000	put	290.0000	2026-11-20	8.5000	8.4000	8.8000	307.4100	181050.00	76500.00	104550.00	213	5	223	4893	0.0455753116697323	0.282251858569977	0.282193889888621	false	false	false	true	false
3fe4718e-1144-4075-845a-a7e8d325dc3e	2026-08-21 10:03	2026-08-21 10:03	2026-08-21 10:03	AAPL	AAPL260821P00330000	put	330.0000	2026-08-21	22.5500	22.5500	22.7500	307.4400	360800.00	0.00	90200.00	160	22	166	1514	0.109643328929987	0.830337951362157	1.53962552477217	false	false	false	true	false
97ebe097-f395-4a8c-801b-933781021d01	2026-08-21 10:18	2026-08-21 10:18	2026-08-21 10:18	AAPL	AAPL260826P00305000	put	305.0000	2026-08-26	2.1600	2.0800	2.1600	307.8600	235872.00	235872.00	0.00	1092	43	2071	307	6.74592833876221	0.242033635667533	0.242033635667533	false	false	false	true	false
e3bda8bb-27c5-424f-972c-a629f3331140	2026-08-21 10:22	2026-08-21 10:22	2026-08-21 10:22	AAPL	AAPL261120C00315000	call	315.0000	2026-11-20	14.3000	14.2500	14.3500	307.5100	268840.00	20020.00	248820.00	188	5	332	5536	0.059971098265896	0.266417372990587	0.266535861990701	false	false	false	true	false
30f6546c-91b5-49cf-8a34-ec7074665f6f	2026-08-21 10:35	2026-08-21 10:35	2026-08-21 10:35	AAPL	AAPL270115C00300000	call	300.0000	2027-01-15	27.8700	27.8500	27.9000	308.1350	1315516.00	516150.00	799366.00	472	45	611	66283	0.00921804987704238	0.272575542803866	0.272575542803866	false	false	false	true	false
67d6cc23-fff8-440e-a156-b042aa572bd8	2026-08-21 10:54	2026-08-21 10:54	2026-08-21 10:54	AAPL	AAPL260821C00310000	call	310.0000	2026-08-21	0.5000	0.4900	0.5100	308.9501	162150.00	161750.00	0.00	3243	42	61721	30535	2.02131979695431	0.312387056703804	0.312387056703804	false	false	false	true	false
07b78ae4-8b2c-4e4a-993e-01d0e8461d39	2026-08-21 10:56	2026-08-21 10:56	2026-08-21 10:56	AAPL	AAPL260925C00320000	call	320.0000	2026-09-25	5.3500	5.1000	5.3500	309.1100	123050.00	123050.00	0.00	230	15	480	798	0.601503759398496	0.243108727413816	0.243108727413816	false	false	false	true	false
fce597e1-ee10-4724-b9bd-18793f78b6e3	2026-08-21 10:58	2026-08-21 10:58	2026-08-21 10:58	AAPL	AAPL260821P00310000	put	310.0000	2026-08-21	1.3200	1.2200	1.3200	309.3500	255420.00	255420.00	0.00	1935	67	15825	13879	1.14021183082355	0.325912306385081	0.325912306385081	false	false	false	true	false
01700beb-3e6f-4885-a032-cf460a68a114	2026-08-21 11:01	2026-08-21 11:00	2026-08-21 11:00	AAPL	AAPL260821P00330000	put	330.0000	2026-08-21	20.4000	20.2500	20.4000	309.6585	310080.00	310080.00	0.00	152	14	331	1514	0.218626155878468	1.27849175810201	1.27849175810201	true	false	false	true	false
86535405-ce11-4d09-9d5f-13ecbb57537f	2026-08-21 11:01	2026-08-21 11:01	2026-08-21 11:01	AAPL	AAPL260826C00307500	call	307.5000	2026-08-26	4.5000	4.4000	4.5500	309.6500	366305.00	366305.00	0.00	814	6	2670	241	11.0788381742739	0.224897756620134	0.226730384502219	true	false	false	true	false
bfc3193a-c87c-4ae3-8c7b-6ee4432ba24e	2026-08-21 11:06	2026-08-21 11:06	2026-08-21 11:06	AAPL	AAPL260904C00310000	call	310.0000	2026-09-04	6.0000	5.9000	6.0000	309.7800	228000.00	228000.00	0.00	380	15	1622	1916	0.846555323590814	0.243197846549317	0.243197846549317	false	false	false	true	false
39b2a72a-f044-44cd-810a-c4a092405496	2026-08-21 11:07	2026-08-21 11:07	2026-08-21 11:07	AAPL	AAPL271217P00300000	put	300.0000	2027-12-17	28.7500	28.7500	29.2000	309.9000	207032.00	0.00	207032.00	72	14	76	1533	0.0495759947814742	0.298640097149039	0.298640097149039	false	false	false	true	false
ef868d6f-0cad-44a7-b2e2-936c05bde63e	2026-08-21 11:24	2026-08-21 11:24	2026-08-21 11:24	AAPL	AAPL260918C00310000	call	310.0000	2026-09-18	8.7000	8.7000	8.7500	309.8300	182762.00	0.00	182762.00	210	10	2495	19873	0.125547224877975	0.243153230833866	0.243616767686815	true	false	false	true	false
0d4be7a3-41e1-4658-a161-87cb75829367	2026-08-21 11:29	2026-08-21 11:29	2026-08-21 11:29	AAPL	AAPL260824P00307500	put	307.5000	2026-08-24	0.8500	0.8400	0.9100	310.6150	114751.00	37910.00	20741.00	1350	22	6938	578	12.0034602076125	0.184065252586221	0.185360912152176	true	false	false	true	false
0d579467-80db-4aaa-b686-221f2d142024	2026-08-21 11:29	2026-08-21 11:29	2026-08-21 11:29	AAPL	AAPL260904C00310000	call	310.0000	2026-09-04	6.3000	6.2500	6.3000	310.5200	315000.00	315000.00	0.00	500	6	2813	1916	1.46816283924843	0.239512699734881	0.239512699734881	true	false	false	true	false
57e2d1c6-7661-424d-9f85-05519d678452	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	AAPL	AAPL260911P00310000	put	310.0000	2026-09-11	6.6000	6.5000	6.6000	310.5850	495000.00	495000.00	0.00	750	8	1588	1545	1.02783171521036	0.243239618589798	0.243239618589798	false	false	false	true	false
86dbeb4f-360c-4716-ac19-0a861c3d94b6	2026-08-21 11:32	2026-08-21 11:32	2026-08-21 11:32	AAPL	AAPL260821P00312500	put	312.5000	2026-08-21	1.9600	1.9500	1.9600	310.8400	249481.00	244804.00	4677.00	1273	16	3141	3999	0.785446361590398	0.316850903244168	0.321528622407993	true	false	false	true	false
93830897-4bc1-4ea8-83a3-e3cefb96bd3b	2026-08-21 11:33	2026-08-21 11:33	2026-08-21 11:33	AAPL	AAPL260925C00320000	call	320.0000	2026-09-25	5.8000	5.8000	6.1500	311.1700	185600.00	0.00	185600.00	320	14	817	798	1.02380952380952	0.234588121926694	0.234588121926694	false	false	false	true	false
bf5ec15b-c648-48eb-9123-0cc9d06ea405	2026-08-21 11:49	2026-08-21 11:48	2026-08-21 11:48	AAPL	AAPL260821C00310000	call	310.0000	2026-08-21	1.5000	1.4500	1.5300	311.0500	281250.00	281250.00	0.00	1875	5	100812	30535	3.30152284263959	0.322233714450643	0.322233714450643	true	false	false	true	false
f39ba0e8-f394-4bb0-8047-9b4784ebe25f	2026-08-21 11:52	2026-08-21 11:51	2026-08-21 11:51	AAPL	AAPL260824P00310000	put	310.0000	2026-08-24	1.3100	1.3100	1.4200	311.6900	272087.00	0.00	272087.00	2077	60	4844	2270	2.13392070484581	0.18355584140657	0.185271505070314	false	false	false	true	false
821d94af-96ee-4229-a147-14b04fbefca4	2026-08-21 11:54	2026-08-21 11:54	2026-08-21 11:54	AAPL	AAPL260911C00320000	call	320.0000	2026-09-11	4.1500	4.1000	4.2000	311.8200	143588.00	122838.00	0.00	346	27	1224	2728	0.448680351906158	0.241773087494774	0.241392953326561	false	false	false	true	false
93239411-3ed3-4dd0-ad8d-c78b081b9ee2	2026-08-21 11:55	2026-08-21 11:54	2026-08-21 11:54	AAPL	AAPL260911C00320000	call	320.0000	2026-09-11	4.1500	4.1000	4.2000	311.7550	118690.00	0.00	14110.00	286	9	1510	2728	0.553519061583578	0.242153010165913	0.242216310112047	false	false	false	true	false
3626ff5f-960b-43e7-9287-75bd5c26e233	2026-08-21 12:42	2026-08-21 12:42	2026-08-21 12:42	AAPL	AAPL260828C00315000	call	315.0000	2026-08-28	2.4200	2.3900	2.4400	310.7650	108900.00	45496.00	56628.00	450	16	8874	6765	1.31175166297118	0.238238802078051	0.238238802078051	true	false	false	true	false
bdf671ca-dad8-431a-98f7-e4af3963c019	2026-08-21 13:03	2026-08-21 13:03	2026-08-21 13:03	AAPL	AAPL270319C00310000	call	310.0000	2027-03-19	29.9000	29.9000	30.2500	310.9550	293020.00	0.00	293020.00	98	6	149	4240	0.0351415094339623	0.277286349985177	0.277286349985177	false	false	false	true	false
eb6c5bc4-f96d-4418-91eb-087afa5ac7a1	2026-08-21 13:14	2026-08-21 13:14	2026-08-21 13:14	AAPL	AAPL260821P00315000	put	315.0000	2026-08-21	3.5000	3.4500	3.6000	311.5400	350000.00	298900.00	51100.00	1000	13	2534	19346	0.130983148971364	0.290170044027409	0.377403458213338	true	false	false	true	false
1f3bdaae-5d89-4713-b3bf-dd85e826338e	2026-08-21 13:18	2026-08-21 13:18	2026-08-21 13:18	AAPL	AAPL260821P00315000	put	315.0000	2026-08-21	3.7000	3.5500	3.7500	311.3400	370000.00	370000.00	0.00	1000	8	4589	19346	0.23720665770702	0.399984658959491	0.399810975925957	false	false	false	true	false
ead21c79-0035-44e1-93df-c7f536b86919	2026-08-21 13:24	2026-08-21 13:24	2026-08-21 13:24	AAPL	AAPL260821P00315000	put	315.0000	2026-08-21	3.9000	3.5500	3.9000	311.1300	779610.00	779610.00	0.00	1999	5	6714	19346	0.347048485475034	0.405628717984061	0.405628717984061	false	false	false	true	false
832d9a7e-66d4-4631-a835-9e19435efb73	2026-08-21 13:34	2026-08-21 13:33	2026-08-21 13:33	AAPL	AAPL260821C00310000	call	310.0000	2026-08-21	1.3000	1.3000	1.3100	311.0050	179491.00	45981.00	133510.00	1378	13	116168	30535	3.80442115605043	0.335227876758101	0.335227876758101	false	false	false	true	false
128f6466-3d61-4a66-a48e-ed684f945777	2026-08-21 13:35	2026-08-21 13:35	2026-08-21 13:35	AAPL	AAPL260821P00315000	put	315.0000	2026-08-21	4.4000	4.1000	4.4000	310.5000	876920.00	547800.00	0.00	1993	7	11846	19346	0.612322960818774	0.25889261578555	0	true	false	false	true	false
e36ccbcd-9ba9-4c82-b9d1-331f9474f37d	2026-08-21 13:49	2026-08-21 13:48	2026-08-21 13:48	AAPL	AAPL260828C00310000	call	310.0000	2026-08-28	4.0500	4.0500	4.1500	309.8550	939645.00	0.00	939645.00	2320	77	12310	5084	2.4213217938631	0.234255402844266	0.234255402844266	false	false	false	true	false
01431c67-5486-4395-a796-f36fe5f71ea3	2026-08-21 13:51	2026-08-21 13:51	2026-08-21 13:51	AAPL	AAPL261218C00300000	call	300.0000	2026-12-18	26.2400	26.0000	26.2500	309.6350	162674.00	162674.00	0.00	62	11	198	24279	0.00815519584826393	0.272631536402643	0.272631536402643	false	false	false	true	false
33853eef-86a0-43e7-9d88-cc7f29890384	2026-08-21 14:02	2026-08-21 14:02	2026-08-21 14:02	AAPL	AAPL260918C00275000	call	275.0000	2026-09-18	36.0000	35.7000	37.2500	309.4400	345600.00	0.00	345600.00	96	6	205	4278	0.0479195885928004	0.297732469844718	0.297732469844718	false	false	false	true	false
53e48f47-e593-42d9-96ff-f8e1439b75bc	2026-08-21 14:03	2026-08-21 14:03	2026-08-21 14:03	AAPL	AAPL260828P00305000	put	305.0000	2026-08-28	2.1500	2.1400	2.2000	309.0000	248320.00	0.00	248320.00	1155	10	4088	2264	1.80565371024735	0.238595466937204	0.239250092953055	false	false	false	true	false
f8872bac-cc1d-4ffb-847b-1bd00aaf4469	2026-08-21 14:23	2026-08-21 14:23	2026-08-21 14:23	AAPL	AAPL260828P00310000	put	310.0000	2026-08-28	4.6000	4.4500	4.6000	308.0000	2166501.00	2166501.00	0.00	4710	87	7077	4530	1.56225165562914	0.242121465379088	0.237124010059675	false	false	false	true	false
4941a2e2-c482-485c-8317-1fb3b8bc3c60	2026-08-21 14:26	2026-08-21 14:26	2026-08-21 14:26	AAPL	AAPL260918C00315000	call	315.0000	2026-09-18	5.8000	5.8000	5.8500	308.5100	144420.00	0.00	144420.00	249	20	1932	9804	0.197062423500612	0.24106786187877	0.24106786187877	true	false	false	true	false
3af9381d-eb14-4826-8457-ad366bc65f6a	2026-08-21 14:27	2026-08-21 14:27	2026-08-21 14:27	AAPL	AAPL260918P00305000	put	305.0000	2026-09-18	6.3500	6.3000	6.4000	308.4900	114300.00	99060.00	0.00	180	5	695	7019	0.0990169539820487	0.246976023655163	0.246976023655163	true	false	false	true	false