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

8adba95d-1278-438a-83cf-5751ffd91f1d	2026-08-21 14:32	2026-08-21 14:32	2026-08-21 14:32	AAPL	AAPL270115C00320000	call	320.0000	2027-01-15	17.8000	17.7000	17.8500	308.8000	204700.00	197580.00	7120.00	115	5	319	36373	0.00877024166277184	0.262919540830669	0.262919540830669	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-21T18:49:22.677317Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4942b336-f503-4386-8452-a7618d849849	2026-08-21 14:41	2026-08-21 14:41	2026-08-21 14:41	AAPL	AAPL260828C00310000	call	310.0000	2026-08-28	3.6000	3.6000	3.7000	308.8300	1031427.00	0.00	1031427.00	2865	66	16417	5084	3.22915027537372	0.237286086738502	0.237286086738502	false	false	false	true	false
95d03153-ab0d-4e66-937c-9c88d21badbd	2026-08-21 15:08	2026-08-21 15:08	2026-08-21 15:08	AAPL	AAPL260824C00310000	call	310.0000	2026-08-24	1.1900	1.1800	1.1900	308.5000	100793.00	100793.00	0.00	847	38	19042	1743	10.924842226047	0.161449621163229	0.161449621163229	false	false	false	true	false
9ace2379-368c-4f3b-a0ee-ea6a371dbbc2	2026-08-21 15:23	2026-08-21 15:23	2026-08-21 15:23	AAPL	AAPL270319C00340000	call	340.0000	2027-03-19	16.3000	15.9500	16.3000	309.5600	117360.00	117360.00	0.00	72	9	151	3991	0.0378351290403408	0.269376748350227	0.269376748350227	false	false	false	true	false
01c7982b-b0f0-4daf-af7a-62e502d2c8ac	2026-08-21 15:27	2026-08-21 15:27	2026-08-21 15:27	AAPL	AAPL270617P00300000	put	300.0000	2027-06-17	22.3500	22.3000	22.7500	309.6600	210095.00	58115.00	151980.00	94	9	164	5695	0.0287971905179982	0.287232588946774	0.287232588946774	false	false	false	true	false
57c50044-c886-4fcb-9bbf-2e3d8616ed15	2026-08-21 15:29	2026-08-21 15:29	2026-08-21 15:29	AAPL	AAPL270219C00330000	call	330.0000	2027-02-19	17.8500	17.5000	17.8500	309.8000	103524.00	101744.00	1780.00	58	12	172	2361	0.072850487081745	0.270423861512857	0.270423861512857	false	false	false	true	false
75b198e3-cd69-49a4-971f-6b4d181da6ef	2026-08-21 15:32	2026-08-21 15:32	2026-08-21 15:32	AAPL	AAPL260824C00307500	call	307.5000	2026-08-24	3.2000	3.2000	3.3000	309.7300	256000.00	0.00	256000.00	800	37	6393	499	12.811623246493	0.158697069379285	0.161591312186736	false	false	false	true	false
891bf7c8-1b6d-43ba-95ae-b7f7f40044f9	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	AAPL	AAPL260826C00312500	call	312.5000	2026-08-26	2.5000	2.2000	2.6100	311.4400	190809.00	128014.00	62795.00	763	53	776	1203	0.645054031587697	0.321926033459225	0.334572406205315	true	false	false	true	false
2aebfd27-634d-4d19-89c3-dbb299aee00d	2026-08-24 09:32	2026-08-24 09:32	2026-08-24 09:32	AAPL	AAPL260918P00340000	put	340.0000	2026-09-18	30.0000	28.5000	30.0000	310.3448	642000.00	642000.00	0.00	214	5	214	2976	0.0719086021505376	0.275163450287834	0.275163450287834	true	false	false	true	false
8bfa4b16-006e-499b-96a8-23a5127b4e13	2026-08-24 09:36	2026-08-24 09:36	2026-08-24 09:36	AAPL	AAPL261218C00320000	call	320.0000	2026-12-18	16.2500	16.0000	16.4500	310.9100	113750.00	108875.00	0.00	70	6	112	8861	0.0126396569235978	0.266071120862788	0.265653859306397	false	false	false	true	false
b972bea7-203f-4ca0-8715-e6a79495abd6	2026-08-24 09:41	2026-08-24 09:41	2026-08-24 09:41	AAPL	AAPL270219C00350000	call	350.0000	2027-02-19	12.2000	12.0000	12.3000	311.8863	118340.00	118340.00	0.00	97	6	652	4866	0.133990957665434	0.271615605060049	0.271615605060049	false	false	false	true	false
72402535-1ecf-439d-9190-e844f33befb0	2026-08-24 09:47	2026-08-24 09:47	2026-08-24 09:47	AAPL	AAPL260828C00310000	call	310.0000	2026-08-28	4.3000	4.3000	4.6000	311.1700	2799522.00	440.00	2798637.00	6510	82	7132	14953	0.476961144920752	0.290322925219703	0.278640219622748	false	false	false	true	false
b27cd870-5dd8-47ec-b254-542c180e39fb	2026-08-24 09:49	2026-08-24 09:49	2026-08-24 09:49	AAPL	AAPL270617P00340000	put	340.0000	2027-06-17	42.5000	42.4500	42.7500	311.3350	323000.00	161650.00	161350.00	76	6	124	1139	0.108867427568042	0.285926200632574	0.286374092726515	false	false	false	true	false
ae680566-98f9-425f-afed-e7886ad00402	2026-08-24 09:49	2026-08-24 09:49	2026-08-24 09:49	AAPL	AAPL260828C00312500	call	312.5000	2026-08-28	3.1000	3.1000	3.3500	311.3600	536806.00	0.00	536806.00	1731	49	3496	3445	1.01480406386067	0.275054505207559	0.275054505207559	false	false	false	true	false
9bda03d2-f908-4759-ba9e-b42c3535f4ab	2026-08-24 10:00	2026-08-24 10:00	2026-08-24 10:00	AAPL	AAPL260918C00322500	call	322.5000	2026-09-18	4.3000	4.1000	4.3000	312.3300	137600.00	137600.00	0.00	320	9	336	0	0	0.246706300210621	0.245638114105816	false	false	false	true	false
76a8e6a9-dcc9-428d-bfa0-20e5b7360b05	2026-08-24 10:00	2026-08-24 10:00	2026-08-24 10:00	AAPL	AAPL261218P00295000	put	295.0000	2026-12-18	9.9500	9.8500	10.2000	312.5000	109450.00	11940.00	97510.00	110	9	215	3968	0.0541834677419355	0.274748677466603	0.274919601576629	false	false	false	true	false
2697f81c-26b7-40ba-9702-427dbc89b713	2026-08-24 10:02	2026-08-24 10:02	2026-08-24 10:02	AAPL	AAPL260918C00310000	call	310.0000	2026-09-18	10.1000	10.0000	10.2000	312.7000	101000.00	0.00	70700.00	100	5	540	20058	0.0269219264134011	0.253504693015875	0.253504693015875	false	false	false	true	false
90dabd66-fcd2-4409-80ab-0bb37246f06a	2026-08-24 10:13	2026-08-24 10:13	2026-08-24 10:13	AAPL	AAPL260824P00312500	put	312.5000	2026-08-24	1.4400	1.4000	1.4500	311.9678	203906.00	201026.00	0.00	1416	50	5900	851	6.93301997649824	0.362282089213625	0.365458844716853	false	false	false	true	false
2e1d3cb7-da5d-436b-b267-2ec61163b2b4	2026-08-24 10:16	2026-08-24 10:16	2026-08-24 10:16	AAPL	AAPL261120C00315000	call	315.0000	2026-11-20	16.5000	16.4000	16.5000	312.3400	297000.00	297000.00	0.00	180	11	300	5740	0.0522648083623693	0.267754876430336	0.267754876430336	false	false	false	true	false
2c2b2b79-def5-4cdc-9fac-e5082bba9d15	2026-08-24 10:17	2026-08-24 10:17	2026-08-24 10:17	AAPL	AAPL260826C00310000	call	310.0000	2026-08-26	4.2500	4.1500	4.3000	312.8300	172980.00	172980.00	0.00	407	29	1544	851	1.81433607520564	0.284862914833997	0.282807064800422	true	false	false	true	false
17fb0cfa-9b57-497d-8fda-cc0826e01654	2026-08-24 10:17	2026-08-24 10:17	2026-08-24 10:17	AAPL	AAPL260918C00310000	call	310.0000	2026-09-18	10.2500	10.0500	10.2500	312.9400	106600.00	106600.00	0.00	104	5	782	20058	0.0389869378801476	0.253822380791087	0.253822380791087	false	false	false	true	false
825cee18-410d-4fee-b8fd-4ad6308d47c3	2026-08-24 10:17	2026-08-24 10:17	2026-08-24 10:17	AAPL	AAPL260918P00320000	put	320.0000	2026-09-18	11.6500	11.4000	11.7000	312.9400	109510.00	108345.00	0.00	94	19	202	5034	0.0401271354787445	0.24792851548781	0.247350589157644	true	false	false	true	false
9c6951c6-5910-469f-af29-db7d35f5e012	2026-08-24 10:17	2026-08-24 10:17	2026-08-24 10:17	AAPL	AAPL270219C00330000	call	330.0000	2027-02-19	19.2000	18.8000	19.2000	312.9483	111335.00	111335.00	0.00	58	6	329	2526	0.130245447347585	0.272263884438048	0.272378639432745	false	false	false	true	false
6b033227-2db0-45dc-83cf-19522cfc1c05	2026-08-24 10:33	2026-08-24 10:32	2026-08-24 10:32	AAPL	AAPL260828C00315000	call	315.0000	2026-08-28	2.8900	2.8600	2.9200	313.2750	142191.00	72543.00	69648.00	492	9	9970	12589	0.791961235999682	0.278578420900374	0.276864458130548	false	false	false	true	false
7b6769c7-ff7a-4597-94ee-f5240d9e610f	2026-08-24 11:05	2026-08-24 11:05	2026-08-24 11:05	AAPL	AAPL260828P00310000	put	310.0000	2026-08-28	2.3500	2.2800	2.3600	312.3775	104810.00	104810.00	0.00	446	25	2080	7747	0.268491028785336	0.267625070866513	0.266278616205576	true	false	false	true	false
b50877c5-c807-4de7-8521-6d5fb3d17f5d	2026-08-24 11:29	2026-08-24 11:29	2026-08-24 11:29	AAPL	AAPL260828C00310000	call	310.0000	2026-08-28	4.8000	4.7500	4.8500	312.2000	169440.00	480.00	168960.00	353	46	10142	14953	0.6782585434361	0.269014825189561	0.270476359642113	false	false	false	true	false
fcc8a6b9-92bb-440f-8d22-452566e9f728	2026-08-24 12:46	2026-08-24 12:46	2026-08-24 12:46	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.2800	2.2300	2.2800	312.2700	326263.00	325128.00	1135.00	1431	64	3513	29599	0.118686442109531	0.241261983932057	0.240726333780184	false	false	false	true	false
8335ab39-3517-4ffc-8e9e-458449f9088a	2026-08-24 12:46	2026-08-24 12:46	2026-08-24 12:46	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.4300	2.3600	2.4400	312.4393	183708.00	16038.00	167670.00	756	11	6670	29599	0.225345450859826	0.245451432647498	0.245493081869006	false	false	false	true	false
5eb483ff-db3e-4ad0-8dec-0685d0ac6d5d	2026-08-24 12:46	2026-08-24 12:46	2026-08-24 12:46	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.4100	2.3400	2.4100	312.4299	120014.00	120014.00	0.00	498	45	5019	29599	0.169566539410115	0.244836507999498	0.244747029431852	false	false	false	true	false
87888f37-7d7f-4b5f-8bb8-43dfb1a79511	2026-08-24 12:46	2026-08-24 12:46	2026-08-24 12:46	AAPL	AAPL260918C00325000	call	325.0000	2026-09-18	3.6500	3.5500	3.7000	312.5495	711710.00	684700.00	27010.00	1950	65	2567	20623	0.124472676138292	0.246719270102789	0.246043295339142	false	false	false	true	false
121ec633-448a-4e58-a2cb-efe6e411f580	2026-08-24 12:46	2026-08-24 12:46	2026-08-24 12:46	AAPL	AAPL260918C00325000	call	325.0000	2026-09-18	3.7000	3.6500	3.7000	312.6100	802530.00	802530.00	0.00	2169	23	5146	20623	0.249527226882607	0.247277255131297	0.247172058277219	false	false	false	true	false
f768eb15-7ad5-4771-9a11-a98bce9bf6e6	2026-08-24 12:49	2026-08-24 12:49	2026-08-24 12:49	AAPL	AAPL260918C00340000	call	340.0000	2026-09-18	1.1300	1.0900	1.1300	312.8900	105542.00	105542.00	0.00	934	31	3839	22157	0.173263528456018	0.25047363218835	0.250437367049361	false	false	false	true	false
17a35cc6-ea1c-49ad-83f5-ac9e7bd7936a	2026-08-24 12:49	2026-08-24 12:49	2026-08-24 12:49	AAPL	AAPL260918C00340000	call	340.0000	2026-09-18	1.1700	1.1400	1.1700	312.9899	103896.00	103896.00	0.00	888	25	6172	22157	0.278557566457553	0.252191229909176	0.252191229909176	false	false	false	true	false
8d9ebb82-c0ae-47a9-8217-0d664b110f5c	2026-08-24 12:49	2026-08-24 12:49	2026-08-24 12:49	AAPL	AAPL260918C00340000	call	340.0000	2026-09-18	1.2000	1.1400	1.2000	313.1000	285623.00	145679.00	139944.00	2390	20	9669	22157	0.436385792300402	0.252977072854115	0.253219448226952	false	false	false	true	false
018fdaf7-abd9-49dd-b333-402aff1602cf	2026-08-24 12:49	2026-08-24 12:49	2026-08-24 12:49	AAPL	AAPL260918C00340000	call	340.0000	2026-09-18	1.2100	1.1100	1.2400	313.0950	133203.00	41598.00	91605.00	1097	10	12014	22157	0.542221419867311	0.255669538442805	0.254466936965623	false	false	false	true	false
d460d28f-7ca0-46f7-8302-3b16d68e4861	2026-08-24 13:35	2026-08-24 13:34	2026-08-24 13:34	AAPL	AAPL270115P00320000	put	320.0000	2027-01-15	22.2500	21.9500	22.2500	312.0300	111250.00	111250.00	0.00	50	10	128	6825	0.0187545787545788	0.263823908097552	0.263823908097552	false	false	false	true	false
8fc025a0-4a7f-4d32-af77-a1e132043a32	2026-08-24 13:53	2026-08-24 13:53	2026-08-24 13:53	AAPL	AAPL260918C00310000	call	310.0000	2026-09-18	9.4000	9.3500	9.6500	311.8200	469937.00	15055.00	435142.00	500	36	2434	20058	0.121348090537441	0.247008304178046	0.245833064628866	false	false	false	true	false
17aeed44-1012-4348-af50-aa60edaa5a38	2026-08-24 14:32	2026-08-24 14:32	2026-08-24 14:32	AAPL	AAPL260918P00300000	put	300.0000	2026-09-18	3.3500	3.2500	3.3500	311.8000	155775.00	155775.00	0.00	465	9	1363	25571	0.0533025693168042	0.255275388989047	0.255275388989047	false	false	false	true	false
d9c73f01-423f-4887-9041-c091bc634ede	2026-08-24 14:47	2026-08-24 14:47	2026-08-24 14:47	AAPL	AAPL260824P00312500	put	312.5000	2026-08-24	1.1600	1.1600	1.2500	311.3900	127832.00	0.00	121220.00	1102	49	49512	851	58.1809635722679	0.252395211766193	0.252395211766193	false	false	false	true	false
eb370adc-8271-4611-9de5-558648a3f555	2026-08-24 15:34	2026-08-24 15:34	2026-08-24 15:34	AAPL	AAPL261120C00330000	call	330.0000	2026-11-20	9.7000	9.6500	9.7000	311.0850	240560.00	240560.00	0.00	248	13	2189	7011	0.312223648552275	0.262996499425389	0.262996499425389	false	false	false	true	false
4029e5d2-58de-4844-9cfb-3db48bd6dfcc	2026-08-24 15:35	2026-08-24 15:35	2026-08-24 15:35	AAPL	AAPL261120P00330000	put	330.0000	2026-11-20	25.8000	25.6000	25.8500	311.0400	464400.00	7740.00	268320.00	180	32	295	2005	0.14713216957606	0.266849770689197	0.266957303044493	true	false	false	true	false
8d59c1c2-d7f4-4019-9c50-118a34fc1c8d	2026-08-24 15:35	2026-08-24 15:35	2026-08-24 15:35	AAPL	AAPL261120C00330000	call	330.0000	2026-11-20	9.7000	9.6000	9.7500	310.9300	145464.00	34884.00	32010.00	150	17	2339	7011	0.333618599343888	0.263998524556717	0.263825583214374	true	false	false	true	false
73033489-8a0d-46b9-9579-55578639dff4	2026-08-24 15:46	2026-08-24 15:46	2026-08-24 15:46	AAPL	AAPL260828C00317500	call	317.5000	2026-08-28	1.0700	1.0700	1.0900	310.5500	107000.00	0.00	107000.00	1000	5	4641	3323	1.39662955160999	0.264074193216617	0.264074193216617	false	false	false	true	false
1e9e861c-0c0f-4249-b4cc-efd1f811eeac	2026-08-24 15:49	2026-08-24 15:49	2026-08-24 15:49	AAPL	AAPL270115C00330000	call	330.0000	2027-01-15	14.2400	14.2000	14.4500	310.7900	1422155.00	81225.00	1340930.00	999	15	1374	20933	0.0656379878660488	0.257100337885493	0.258185444158397	false	false	false	true	false
10e9bb28-4c77-4739-9af1-af0d44514168	2026-08-24 15:52	2026-08-24 15:52	2026-08-24 15:52	AAPL	AAPL260826C00310000	call	310.0000	2026-08-26	2.8000	2.7400	2.8200	310.7200	106962.00	106962.00	0.00	382	31	4254	851	4.99882491186839	0.260497789599363	0.262698955163018	false	false	false	true	false
db0c8672-b255-4c79-ba08-513f7e90c0c8	2026-08-24 15:59	2026-08-24 15:59	2026-08-24 15:59	AAPL	AAPL260918C00335000	call	335.0000	2026-09-18	1.3000	1.3000	1.3300	310.3950	142220.00	0.00	15990.00	1094	23	4828	14570	0.331365820178449	0.245908845777863	0.245908845777863	true	false	false	true	false
474e8e47-c362-40d8-9869-0f4e45668216	2026-08-25 09:30	2026-08-25 09:30	2026-08-25 09:30	AAPL	AAPL260826C00315000	call	315.0000	2026-08-26	1.5500	1.3800	1.5500	313.1450	172462.00	172160.00	302.00	1115	18	2650	5714	0.463773188659433	0.347973469136921	0.358281254074139	true	false	false	true	false
a53f903f-b155-419c-8260-31d8dc0edeff	2026-08-25 09:33	2026-08-25 09:33	2026-08-25 09:33	AAPL	AAPL260918C00315000	call	315.0000	2026-09-18	7.1000	7.0000	7.2000	312.3500	124250.00	1420.00	122830.00	175	10	209	10887	0.0191972076788831	0.24961518536669	0.24961518536669	true	false	false	true	false
89f08a43-144e-4f2a-986f-3bfd6b8ff2c7	2026-08-25 09:37	2026-08-25 09:36	2026-08-25 09:36	AAPL	AAPL260826C00310000	call	310.0000	2026-08-26	2.8800	2.7600	2.8800	311.0800	143999.00	143999.00	0.00	500	10	1450	1854	0.782092772384035	0.351764054373173	0.350192193214005	false	false	false	true	false
1025924c-14f3-4a6f-9fab-a803e3c48044	2026-08-25 09:59	2026-08-25 09:59	2026-08-25 09:59	AAPL	AAPL260826C00312500	call	312.5000	2026-08-26	1.0600	1.0600	1.0900	310.3000	131228.00	0.00	131228.00	1238	54	16490	3689	4.47004608294931	0.300772796565751	0.300772796565751	false	false	false	true	false