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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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

998ad8ed-fd0d-475c-aa4e-bec70d67c43d	2026-08-17 09:32	2026-08-17 09:32	2026-08-17 09:32	AAPL	AAPL260821P00302500	put	302.5000	2026-08-21	1.4900	1.4900	1.5900	306.7150	166284.00	0.00	166284.00	1116	40	1150	1516	0.758575197889182	0.251870502173885	0.251870502173885	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-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
96002b82-1c89-4bc8-9d82-51b9b3111cc6	2026-08-17 09:32	2026-08-17 09:32	2026-08-17 09:32	AAPL	AAPL260821C00315000	call	315.0000	2026-08-21	0.7300	0.7300	0.7800	306.6125	167097.00	0.00	167097.00	2289	59	2430	19329	0.125717833307465	0.257001277791351	0.259135112479495	false	false	false	true
59b0480b-8e32-4b52-9422-39bdf3a8aeb6	2026-08-17 09:41	2026-08-17 09:41	2026-08-17 09:41	AAPL	AAPL270917C00325000	call	325.0000	2027-09-17	32.0000	31.9000	32.5500	304.0900	105600.00	0.00	105600.00	33	13	33	409	0.0806845965770171	0.276336060608598	0.276336060608598	false	false	false	true
63a06a2b-b877-43f1-bb9b-aab4cb0e8547	2026-08-17 09:47	2026-08-17 09:47	2026-08-17 09:47	AAPL	AAPL260821C00310000	call	310.0000	2026-08-21	1.5400	1.5100	1.5400	305.4450	115962.00	115962.00	0.00	753	27	4958	35004	0.141640955319392	0.256095304465528	0.256095304465528	false	false	false	true
1d0fca22-4099-4cdd-ac60-12c1148bd3a0	2026-08-17 09:49	2026-08-17 09:49	2026-08-17 09:49	AAPL	AAPL260918C00320000	call	320.0000	2026-09-18	3.6500	3.5000	3.6500	305.7000	362080.00	362080.00	0.00	992	7	1408	36248	0.0388435224012359	0.236301930170272	0.236301930170272	false	false	false	true
5bb749cb-2d08-4a79-8a4c-268100482d66	2026-08-17 09:58	2026-08-17 09:58	2026-08-17 09:58	AAPL	AAPL260821C00305000	call	305.0000	2026-08-21	3.6000	3.5000	3.6000	305.6400	102600.00	102600.00	0.00	285	21	2195	10488	0.209286803966438	0.251180434606551	0.251180434606551	true	false	false	true
49ae192c-4ddd-4b8e-a94a-1d756d9a1a80	2026-08-17 10:46	2026-08-17 10:46	2026-08-17 10:46	AAPL	AAPL270219C00310000	call	310.0000	2027-02-19	23.4500	23.3500	23.7000	304.4300	351750.00	295470.00	56280.00	150	12	183	1440	0.127083333333333	0.267383702210001	0.267383702210001	false	false	false	true
1822019c-8d58-4f66-9b2f-bb7f47c3c35e	2026-08-17 11:01	2026-08-17 11:01	2026-08-17 11:01	AAPL	AAPL260918P00290000	put	290.0000	2026-09-18	2.8800	2.8800	2.9500	303.9300	432000.00	0.00	432000.00	1500	37	1840	11090	0.165915238954013	0.236709001681887	0.236624659912247	false	false	false	true
0b3741e9-5386-4e83-af6f-40d7743ceb2f	2026-08-17 11:04	2026-08-17 11:04	2026-08-17 11:04	AAPL	AAPL260821P00295000	put	295.0000	2026-08-21	0.4700	0.4500	0.4700	304.0700	140389.00	140389.00	0.00	2987	70	4543	14581	0.311569851176188	0.251331341154227	0.250861971997462	false	false	false	true
ebf1a071-a3d2-4f99-895b-448068cbe1e2	2026-08-17 11:22	2026-08-17 11:22	2026-08-17 11:22	AAPL	AAPL261120C00365000	call	365.0000	2026-11-20	1.9600	1.9500	2.0200	304.6300	348488.00	130732.00	17836.00	1778	37	1781	2290	0.777729257641921	0.256664504340304	0.256673113636633	true	false	false	true
fb2a0bc5-b82f-4fb6-bcbe-6b6bef26bcec	2026-08-17 11:30	2026-08-17 11:30	2026-08-17 11:30	AAPL	AAPL260819C00297500	call	297.5000	2026-08-19	7.3000	7.3000	7.4500	304.5650	1219100.00	0.00	1219100.00	1670	62	1881	38	49.5	0.224381965442971	0.224381965442971	false	false	false	true
df32d060-1013-4d7d-adc1-177c4ed68715	2026-08-17 11:51	2026-08-17 11:51	2026-08-17 11:51	AAPL	AAPL260821C00275000	call	275.0000	2026-08-21	29.1500	28.1000	29.1500	303.2500	131175.00	131175.00	0.00	45	19	108	4482	0.0240963855421687	0.679543505616595	0.679543505616595	false	false	false	true
d62b0398-c67e-49be-a678-b662748846ee	2026-08-17 12:48	2026-08-17 12:48	2026-08-17 12:48	AAPL	AAPL260817C00302500	call	302.5000	2026-08-17	1.3200	1.2300	1.3200	303.6900	240636.00	240636.00	0.00	1823	79	10367	1511	6.86101919258769	0.263261423508783	0.224614764311749	false	false	false	true
f20d1891-7107-49a4-981a-9559425bc32e	2026-08-17 13:07	2026-08-17 13:07	2026-08-17 13:07	AAPL	AAPL261218C00285000	call	285.0000	2026-12-18	31.5500	31.0000	31.5500	303.5700	258710.00	258710.00	0.00	82	5	101	2145	0.0470862470862471	0.269864540393799	0.269864540393799	false	false	false	true
72f3e458-e0f0-4bbc-aa89-e2049cd832c8	2026-08-17 13:07	2026-08-17 13:07	2026-08-17 13:07	AAPL	AAPL260918C00310000	call	310.0000	2026-09-18	6.0500	6.0500	6.1500	303.6000	453792.00	0.00	453792.00	750	55	2946	20177	0.14600783069832	0.233992571393069	0.233992571393069	false	false	false	true
c6f333eb-bbd0-4e3f-a284-d8d9fabaf7e7	2026-08-17 13:47	2026-08-17 13:47	2026-08-17 13:47	AAPL	AAPL260821C00305000	call	305.0000	2026-08-21	3.0500	3.0000	3.1000	304.0000	103090.00	102785.00	0.00	338	8	10966	10488	1.0455758962624	0.249454833612678	0.249454833612678	false	false	false	true
513f62ee-4573-48cf-8705-ff2803584b7b	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	AAPL	AAPL260821C00305000	call	305.0000	2026-08-21	3.1500	3.1000	3.1500	304.7700	675989.00	675989.00	0.00	2146	86	13879	10488	1.32332189168574	0.251486161336748	0.251486161336748	false	false	false	true
53ea9209-0767-40b0-b9b0-2c0547db84c7	2026-08-17 14:44	2026-08-17 14:43	2026-08-17 14:43	AAPL	AAPL281215C00440000	call	440.0000	2028-12-15	23.8000	23.5000	23.8000	305.4700	168980.00	168980.00	0.00	71	7	121	1182	0.102368866328257	0.279814354042945	0.279814354042945	false	false	false	true
d2343601-6be5-48ba-90a9-bf2e25b590ca	2026-08-17 15:21	2026-08-17 15:21	2026-08-17 15:21	AAPL	AAPL280121C00350000	call	350.0000	2028-01-21	31.5500	31.3000	31.6000	305.9300	309190.00	242935.00	66255.00	98	12	228	8360	0.0272727272727273	0.281028700379738	0.281028700379738	false	false	false	true
06448151-669e-4a3a-ba69-d7a58980f0d3	2026-08-18 09:30	2026-08-18 09:30	2026-08-18 09:30	AAPL	AAPL260918C00310000	call	310.0000	2026-09-18	7.6500	7.3500	7.6500	306.7350	108630.00	108630.00	0.00	142	7	171	20311	0.00841908325537886	0.244059931004838	0.244059931004838	true	false	false	true
9292ad5c-4989-49d5-81de-eaf60f6eee15	2026-08-18 09:38	2026-08-18 09:38	2026-08-18 09:38	AAPL	AAPL261016P00320000	put	320.0000	2026-10-16	18.5000	18.5000	18.5000	306.0000	370000.00	0.00	0.00	200	15	201	3494	0.0575271894676588	0.241776034728529	0.241776034728529	false	false	false	true
41984560-561a-4a4b-b3e3-c414bc5c521a	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	AAPL	AAPL260819C00305000	call	305.0000	2026-08-19	3.2000	3.1500	3.3500	306.0000	928616.00	1600.00	927016.00	2902	81	4630	3009	1.53871718178797	0.291524253895365	0.311651205227556	true	false	false	true
d21bcafa-03af-49e1-b1bd-82865aebd4bf	2026-08-18 09:53	2026-08-18 09:53	2026-08-18 09:53	AAPL	AAPL260819P00307500	put	307.5000	2026-08-19	2.6300	2.6300	2.7400	306.2500	763752.00	0.00	763752.00	2904	72	4620	4264	1.08348968105066	0.286379025607334	0.306051352175957	false	false	false	true
68d3560d-72e2-4321-85a0-0c8624ae0cbd	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	AAPL	AAPL260821C00310000	call	310.0000	2026-08-21	2.0000	1.9500	2.0000	307.5000	138000.00	138000.00	0.00	690	14	5596	38967	0.143608694536403	0.273391085801536	0.273391085801536	false	false	false	true
a61de183-764e-405a-a32e-2015c33268cf	2026-08-18 10:01	2026-08-18 10:00	2026-08-18 10:00	AAPL	AAPL260925C00300000	call	300.0000	2026-09-25	14.5000	14.0500	14.9000	307.5250	661210.00	659750.00	1460.00	456	6	505	1293	0.390564578499613	0.244587730089781	0.246607649817272	false	false	false	true
e3fd49cf-cf03-466c-b39e-88da176ec7db	2026-08-18 10:02	2026-08-18 10:01	2026-08-18 10:01	AAPL	AAPL270917C00365000	call	365.0000	2027-09-17	20.4800	20.1500	20.6500	308.4300	210900.00	108650.00	102250.00	103	5	121	1617	0.0748299319727891	0.275025108830672	0.274505626108833	false	false	false	true
504e726d-d4e3-4739-99e7-6c716f75ac1c	2026-08-18 10:06	2026-08-18 10:05	2026-08-18 10:05	AAPL	AAPL260911C00305000	call	305.0000	2026-09-11	10.2600	10.2500	10.8000	309.3000	512755.00	0.00	460225.00	500	15	1218	4021	0.302909723949266	0.23739521364035	0.23739521364035	false	false	false	true
fa110dd6-8f7f-4181-ac2d-4b001a961d62	2026-08-18 10:06	2026-08-18 10:06	2026-08-18 10:06	AAPL	AAPL270617C00280000	call	280.0000	2027-06-17	53.9500	52.0000	53.9500	309.0400	107900.00	107900.00	0.00	20	6	21	8101	0.00259227255894334	0.297492425909185	0.297492425909185	false	false	false	true
8893d332-aa28-4015-8f3f-a5660a0bf7ac	2026-08-18 10:07	2026-08-18 10:07	2026-08-18 10:07	AAPL	AAPL280121C00350000	call	350.0000	2028-01-21	33.3000	32.9000	33.3000	309.2550	129870.00	129870.00	0.00	39	9	42	8458	0.00496571293449988	0.282103593085445	0.282103593085445	false	false	false	true
85eb671f-d611-422e-98cb-f8c1cbf685e3	2026-08-18 10:08	2026-08-18 10:08	2026-08-18 10:08	AAPL	AAPL260821C00305000	call	305.0000	2026-08-21	6.0000	5.8500	6.0000	309.5500	339000.00	339000.00	0.00	565	12	3235	13525	0.239186691312384	0.283241730642704	0.283241730642704	true	false	false	true
5ed64e64-95d2-4e8d-ba31-e6d4dc73511e	2026-08-18 10:10	2026-08-18 10:09	2026-08-18 10:09	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.3800	2.3100	2.3800	309.6300	105196.00	105196.00	0.00	442	10	1410	24367	0.0578651454836459	0.23959862798851	0.23959862798851	false	false	false	true
5d426f75-d160-4d2e-b2b2-1ab1be4298ae	2026-08-18 10:10	2026-08-18 10:10	2026-08-18 10:10	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.4400	2.3700	2.4400	309.8003	122000.00	122000.00	0.00	500	11	1993	24367	0.081790946772274	0.240580776709244	0.240580776709244	false	false	false	true
c7a4b78a-b1d9-4ce7-81f8-c033cb6c6a58	2026-08-18 10:10	2026-08-18 10:10	2026-08-18 10:10	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.4500	2.3700	2.4500	309.8400	122500.00	122500.00	0.00	500	8	2493	24367	0.102310501908319	0.240650667949765	0.240650667949765	false	false	false	true
3814a1dd-2e43-4b1b-82fa-15715d438b19	2026-08-18 10:10	2026-08-18 10:10	2026-08-18 10:10	AAPL	AAPL260821C00300000	call	300.0000	2026-08-21	10.5000	10.2000	10.5000	309.8770	631050.00	631050.00	0.00	601	5	2549	15165	0.168084404879657	0.312132578282212	0.312132578282212	false	false	false	true
1cf7e7d0-2c66-4934-a82d-0b3861c34e13	2026-08-18 10:12	2026-08-18 10:11	2026-08-18 10:11	AAPL	AAPL260821P00310000	put	310.0000	2026-08-21	3.2500	3.2000	3.3000	309.4850	479050.00	443625.00	0.00	1474	7	1835	7978	0.230007520681875	0.271070512104661	0.271070512104661	true	false	false	true
4a78190b-0f45-48cc-a54d-791e11220d51	2026-08-18 10:18	2026-08-18 10:18	2026-08-18 10:18	AAPL	AAPL260918C00320000	call	320.0000	2026-09-18	4.8000	4.7500	4.8500	309.6100	541440.00	0.00	466080.00	1128	9	3231	38328	0.0842986850344396	0.237711654305344	0.237815722631766	false	false	false	true
edcd0ca9-a307-4748-8c34-e840bf26f9ab	2026-08-18 10:24	2026-08-18 10:24	2026-08-18 10:24	AAPL	AAPL260918C00320000	call	320.0000	2026-09-18	4.6500	4.6500	4.7000	308.9300	109275.00	0.00	109275.00	235	11	4402	38328	0.114850761845126	0.240302965149251	0.240302965149251	false	false	false	true
e6251f1c-6f70-4736-ad0f-da52997c5e21	2026-08-18 10:26	2026-08-18 10:26	2026-08-18 10:26	AAPL	AAPL260821P00307500	put	307.5000	2026-08-21	2.2500	2.2100	2.2500	308.8600	100332.00	96300.00	4032.00	446	31	5350	1972	2.71298174442191	0.262048266553345	0.262048266553345	false	false	false	true
adb22866-69e6-4d74-81f7-2b2553a0a2b0	2026-08-18 10:31	2026-08-18 10:31	2026-08-18 10:31	AAPL	AAPL260821C00310000	call	310.0000	2026-08-21	3.1000	3.1000	3.1500	309.9400	115630.00	0.00	115630.00	373	11	19643	38967	0.504093207072651	0.274931078066762	0.274931078066762	false	false	false	true
830fa3bd-414e-4675-8e8d-d95499c8ce7d	2026-08-18 10:34	2026-08-18 10:34	2026-08-18 10:34	AAPL	AAPL260821C00305000	call	305.0000	2026-08-21	7.0000	6.8500	7.0500	310.8550	145600.00	145600.00	0.00	208	8	5070	13525	0.374861367837338	0.287651639562752	0.285359019215473	false	false	false	true
fb9892fd-be6c-407d-8f42-177cda970ae7	2026-08-18 10:34	2026-08-18 10:34	2026-08-18 10:34	AAPL	AAPL270115C00350000	call	350.0000	2027-01-15	8.8500	8.8000	8.9500	310.9703	107085.00	0.00	107085.00	121	15	1127	32454	0.0347260738275713	0.25775447601041	0.25775447601041	false	false	false	true
4730f63d-3edb-4da2-a0b8-ec09dbed3793	2026-08-18 10:35	2026-08-18 10:35	2026-08-18 10:35	AAPL	AAPL280121C00380000	call	380.0000	2028-01-21	24.9000	24.6500	24.9500	311.1800	112050.00	72210.00	39840.00	45	6	77	4693	0.0164074152993821	0.280316424475179	0.280316424475179	false	false	false	true
13ba8d47-f070-49ca-920f-eff185b45fc2	2026-08-18 10:41	2026-08-18 10:41	2026-08-18 10:41	AAPL	AAPL270917C00355000	call	355.0000	2027-09-17	25.2000	25.0000	25.2500	311.3700	108360.00	25200.00	83160.00	43	7	242	509	0.475442043222004	0.278958402789222	0.278958402789222	false	false	false	true
c96f1371-232e-435e-8e0d-5a055cfb684e	2026-08-18 10:41	2026-08-18 10:41	2026-08-18 10:41	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	5.9500	5.8500	5.9500	311.3750	252280.00	252280.00	0.00	424	11	2055	11340	0.181216931216931	0.244700229045909	0.244700229045909	false	false	false	true
35dacf9d-f1a5-4978-94b9-47f242a5ace5	2026-08-18 10:44	2026-08-18 10:44	2026-08-18 10:44	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	5.7000	5.7000	5.8000	310.9150	577431.00	0.00	577431.00	1013	44	3108	11340	0.274074074074074	0.242300229870056	0.242300229870056	false	false	false	true
a165d8ce-e79d-475f-87bc-2e69e3ca6fb0	2026-08-18 10:55	2026-08-18 10:55	2026-08-18 10:55	AAPL	AAPL270115C00330000	call	330.0000	2027-01-15	14.6000	14.6000	14.6500	310.4000	194180.00	0.00	194180.00	133	9	830	21387	0.03880862206013	0.25860077167672	0.25860077167672	false	false	false	true
5a4f7d4f-8397-418c-b22d-93d1193e4b9f	2026-08-18 11:03	2026-08-18 11:03	2026-08-18 11:03	AAPL	AAPL260821C00310000	call	310.0000	2026-08-21	3.1500	3.1000	3.2000	310.0158	378000.00	309645.00	0.00	1200	5	26042	38967	0.668309082043781	0.275950991551518	0.275950991551518	true	false	false	true
e1c2b56b-8eee-4583-b3f2-7dc1ca2016af	2026-08-18 11:05	2026-08-18 11:05	2026-08-18 11:05	AAPL	AAPL260821C00307500	call	307.5000	2026-08-21	5.1500	4.9000	5.1500	310.6100	2360245.00	2360245.00	0.00	4583	70	13364	7930	1.68524590163934	0.295509034099101	0.295509034099101	false	false	false	true
3018fca5-fa3a-4708-a490-dce31a357f35	2026-08-18 11:37	2026-08-18 11:37	2026-08-18 11:37	AAPL	AAPL270115C00285000	call	285.0000	2027-01-15	39.2000	38.3500	39.2000	310.2600	364560.00	364560.00	0.00	93	5	142	3004	0.0472703062583222	0.279594761912741	0.278434135870838	false	false	false	true
93b1bc16-5d6a-484b-88f1-3daafd4c7a32	2026-08-18 11:49	2026-08-18 11:49	2026-08-18 11:49	AAPL	AAPL260828P00310000	put	310.0000	2026-08-28	4.9000	4.8500	4.9000	309.5300	147000.00	147000.00	0.00	300	5	1815	1457	1.24571036376115	0.236047540796988	0.236047540796988	true	false	false	true