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

1cc8c103-661c-4c69-b093-2d017a21d4da	2026-08-19 12:58	2026-08-19 12:58	2026-08-19 12:58	AAPL	AAPL260918C00310000	call	310.0000	2026-09-18	12.0500	12.0500	12.2000	314.6600	255509.00	0.00	255509.00	212	12	2988	20368	0.146700706991359	0.249493269939554	0.25127139432204	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-19T17:16:43.855599Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bb2108ee-362b-40f8-9dda-c5c883d8ac8d	2026-08-19 13:05	2026-08-19 13:05	2026-08-19 13:05	AAPL	AAPL260819P00315000	put	315.0000	2026-08-19	0.8300	0.8100	0.8400	314.8700	120516.00	119852.00	664.00	1452	47	92283	266	346.928571428571	0.339857644956823	0.3345953983609	false	false	false	true	false
d448dff2-bfe9-4685-94ff-a5d26341087f	2026-08-19 13:28	2026-08-19 13:27	2026-08-19 13:27	AAPL	AAPL260821P00317500	put	317.5000	2026-08-21	4.0500	3.9000	4.1500	314.9400	1196743.00	1158673.00	3645.00	2955	89	8733	1328	6.57605421686747	0.289654142161292	0.280158204649756	false	false	false	true	false
88da41db-e297-490e-bcad-ba785bb1dd23	2026-08-19 13:44	2026-08-19 13:44	2026-08-19 13:44	AAPL	AAPL260819C00315000	call	315.0000	2026-08-19	0.9500	0.9500	0.9900	315.4600	169775.00	0.00	169290.00	1787	61	129588	9708	13.3485784919654	0.332446671985581	0.34356472246308	false	false	false	true	false
98b533a2-3dfd-4244-a7cf-191ae6f3e598	2026-08-19 13:51	2026-08-19 13:51	2026-08-19 13:51	AAPL	AAPL260918P00325000	put	325.0000	2026-09-18	13.7500	13.7500	14.0500	315.3000	170500.00	0.00	170500.00	124	6	178	2721	0.0654171260565968	0.238686339464672	0.238686339464672	false	false	false	true	false
930cdd21-8069-497c-9066-193a1d66b11b	2026-08-19 14:04	2026-08-19 14:04	2026-08-19 14:04	AAPL	AAPL261218C00310000	call	310.0000	2026-12-18	24.4000	23.9500	24.5000	315.6250	187880.00	51240.00	136640.00	77	18	369	6675	0.0552808988764045	0.269115653606299	0.269115653606299	false	false	false	true	false
cbd76c8a-2883-4811-8f1c-d90cca6ead0a	2026-08-19 14:12	2026-08-19 14:12	2026-08-19 14:12	AAPL	AAPL260918P00315000	put	315.0000	2026-09-18	8.0000	8.0000	8.1000	315.5300	104000.00	0.00	104000.00	130	19	1108	6117	0.181134543076672	0.24261594987444	0.24261594987444	true	false	false	true	false
61c914ab-b9a0-4b7d-b181-f234269b8f3d	2026-08-19 14:19	2026-08-19 14:19	2026-08-19 14:19	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6100	3.6000	3.8000	314.8500	154842.00	0.00	154842.00	429	16	20892	27225	0.767382920110193	0.243016865074059	0.243016865074059	false	false	false	true	false
a5f1d261-683a-4fed-a5d3-1d2a6fb84d15	2026-08-19 14:19	2026-08-19 14:19	2026-08-19 14:19	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.6000	3.8000	314.8400	180000.00	0.00	180000.00	500	14	21463	27225	0.788356290174472	0.242833940229568	0.243108314459423	false	false	false	true	false
641faf82-df36-4393-a396-a4ff8e900b85	2026-08-19 14:19	2026-08-19 14:19	2026-08-19 14:19	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.6000	3.8000	314.9600	180000.00	0.00	180000.00	500	8	21963	27225	0.806721763085399	0.242010346417964	0.242010346417964	false	false	false	true	false
0a9d91c2-2d9a-4961-b61e-c49d0ecd7752	2026-08-19 14:31	2026-08-19 14:31	2026-08-19 14:31	AAPL	AAPL261016C00330000	call	330.0000	2026-10-16	6.9000	6.9000	7.0000	314.5700	317405.00	0.00	316710.00	460	9	10888	11597	0.938863499180823	0.244533037453447	0.244457434769223	false	false	false	true	false
8b9d2b82-06bf-45ed-95bd-08ecab8724d3	2026-08-19 15:18	2026-08-19 15:18	2026-08-19 15:18	AAPL	AAPL270319C00350000	call	350.0000	2027-03-19	15.7500	15.5500	15.8000	315.9200	226800.00	226800.00	0.00	144	5	436	5494	0.0793593010556971	0.268451550975466	0.268451550975466	false	false	false	true	false
13e64579-cbb0-4b05-bf7b-2a90647be2e3	2026-08-19 15:32	2026-08-19 15:32	2026-08-19 15:32	AAPL	AAPL260918C00320000	call	320.0000	2026-09-18	7.8000	7.7000	7.8000	316.4100	372840.00	372840.00	0.00	478	17	8492	35287	0.240655198798424	0.248816039626923	0.248816039626923	false	false	false	true	false
3dfa370f-8a6e-4132-89af-4411d4b5079c	2026-08-20 09:31	2026-08-20 09:31	2026-08-20 09:31	AAPL	AAPL260821C00320000	call	320.0000	2026-08-21	2.5800	2.4800	2.6500	319.6370	135377.00	49760.00	78641.00	525	132	5171	32695	0.158158739868481	0.414541002727783	0.407585299038039	true	false	false	true	false
fab8e775-b977-4152-ab65-9c078ce0339e	2026-08-20 09:31	2026-08-20 09:31	2026-08-20 09:31	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	5.2500	4.9500	5.2500	319.0500	262500.00	262500.00	0.00	500	6	651	32252	0.0201847947414114	0.258157203165858	0.258157203165858	false	false	false	true	false
02fbfa06-e9fc-4056-8a95-15bc33c700fe	2026-08-20 09:31	2026-08-20 09:31	2026-08-20 09:31	AAPL	AAPL260821C00320000	call	320.0000	2026-08-21	2.2900	2.2200	2.4300	319.0100	149468.00	40177.00	107702.00	654	165	6195	32695	0.18947851353418	0.416547792666168	0.412519299436842	true	false	false	true	false
2057e8cd-a2c1-49ac-affa-17a5113cd02a	2026-08-20 09:31	2026-08-20 09:31	2026-08-20 09:31	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	5.1500	5.1500	5.3500	319.0800	257500.00	0.00	257500.00	500	6	1166	32252	0.0361527967257844	0.254837050701688	0.254837050701688	true	false	false	true	false
e2968b48-a16c-4c6f-a46d-f1b223cee082	2026-08-20 09:33	2026-08-20 09:32	2026-08-20 09:33	AAPL	AAPL260821C00320000	call	320.0000	2026-08-21	2.5900	2.4500	2.6800	319.9600	201462.00	135842.00	59007.00	779	160	13011	32695	0.397950756996483	0.397360707292457	0.391166473171104	true	false	false	true	false
39ad1765-bda1-49ee-8143-329a326c3a7b	2026-08-20 09:33	2026-08-20 09:33	2026-08-20 09:33	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	5.4000	5.2500	5.4000	319.7000	270000.00	270000.00	0.00	500	6	1771	32252	0.0549113233287858	0.255762870106384	0.255762870106384	false	false	false	true	false
af7293eb-2eba-4d1c-8403-7f7f1bbff934	2026-08-20 09:34	2026-08-20 09:34	2026-08-20 09:34	AAPL	AAPL260821C00320000	call	320.0000	2026-08-21	2.7700	2.7200	2.8300	320.1400	107634.00	52972.00	42186.00	389	113	17955	32695	0.549166539226181	0.402591186189923	0.401398326740149	true	false	false	true	false
61756150-ecda-4dc1-be01-f5c55340b958	2026-08-20 09:35	2026-08-20 09:35	2026-08-20 09:35	AAPL	AAPL260918C00305000	call	305.0000	2026-09-18	18.4700	18.2000	18.7500	318.7750	415680.00	365730.00	49950.00	225	9	241	18217	0.0132294011088544	0.270272412551308	0.266340931736812	false	false	false	true	false
72876e69-71b0-49bb-b6a2-dca96eaea7ae	2026-08-20 09:55	2026-08-20 09:55	2026-08-20 09:55	AAPL	AAPL281215C00500000	call	500.0000	2028-12-15	19.1700	18.5000	19.2000	318.0500	272200.00	270285.00	1915.00	142	8	167	1617	0.103277674706246	0.286079088431894	0.286122654236175	false	false	false	true	false
463a5733-901c-4c3c-a2e0-77ca49086972	2026-08-20 10:00	2026-08-20 10:00	2026-08-20 10:00	AAPL	AAPL260821P00330000	put	330.0000	2026-08-21	12.9000	12.7500	12.9000	317.1500	138030.00	138030.00	0.00	107	11	116	1817	0.0638414969730325	0.406598593284438	0.406598593284438	false	false	false	true	false
c50b2abd-1181-488b-84f8-0214ea500876	2026-08-20 10:04	2026-08-20 10:04	2026-08-20 10:04	AAPL	AAPL260821C00315000	call	315.0000	2026-08-21	3.6000	3.6000	3.8500	317.2800	1502383.00	0.00	1502383.00	4173	90	6481	20872	0.310511690302798	0.342040739603644	0.342040739603644	false	false	false	true	false
9f8abb50-9496-4ff1-8652-5d42c6864da5	2026-08-20 10:34	2026-08-20 10:33	2026-08-20 10:33	AAPL	AAPL260828C00320000	call	320.0000	2026-08-28	3.3000	3.2500	3.3500	316.5000	255420.00	233970.00	21450.00	774	31	3017	5110	0.59041095890411	0.252470417370459	0.252470417370459	false	false	false	true	false
4f1aa627-e6e1-4fae-875b-9377d01fb77f	2026-08-20 10:48	2026-08-20 10:48	2026-08-20 10:48	AAPL	AAPL260821C00315000	call	315.0000	2026-08-21	3.1500	3.0500	3.1500	316.6000	587746.00	587746.00	0.00	1866	79	9934	20872	0.475948639325412	0.339659052041928	0.339659052041928	false	false	false	true	false
be1d6915-7c35-4ed5-92d4-6f14157732d1	2026-08-20 10:55	2026-08-20 10:55	2026-08-20 10:55	AAPL	AAPL260821C00317500	call	317.5000	2026-08-21	1.9400	1.9000	1.9400	316.9875	112516.00	112132.00	0.00	580	37	19425	10793	1.79977763365144	0.32780546792815	0.32780546792815	true	false	false	true	false
3783e030-3384-4bf7-81a5-e6661cdc742a	2026-08-20 11:24	2026-08-20 11:24	2026-08-20 11:24	AAPL	AAPL260824C00317500	call	317.5000	2026-08-24	2.4900	2.4100	2.4900	316.5399	129729.00	129729.00	0.00	521	66	3104	1440	2.15555555555556	0.219385457735773	0.217995388306289	false	false	false	true	false
36f569f9-8907-4893-bbcb-5dda619bb441	2026-08-20 11:31	2026-08-20 11:31	2026-08-20 11:31	AAPL	AAPL260918C00320000	call	320.0000	2026-09-18	7.8500	7.8000	8.0000	317.0000	162495.00	0.00	162495.00	207	20	1873	32921	0.0568937760092342	0.246534769535321	0.247071307985591	true	false	false	true	false
5aee8496-9074-45bc-a626-ef9b64c74a3b	2026-08-20 11:40	2026-08-20 11:40	2026-08-20 11:40	AAPL	AAPL260821C00280000	call	280.0000	2026-08-21	36.4000	36.4000	36.5000	316.2500	196560.00	0.00	105560.00	54	5	68	6538	0.0104007341694708	1.12194322253074	1.12194322253074	false	false	false	true	false
91f7ca54-cc78-4c74-b72a-a46a2339d6a5	2026-08-20 11:40	2026-08-20 11:40	2026-08-20 11:40	AAPL	AAPL260821C00280000	call	280.0000	2026-08-21	36.4000	36.2500	36.4000	316.2402	182000.00	54600.00	0.00	50	5	118	6538	0.0180483328234934	1.1349432611382	1.1349432611382	false	false	false	true	false
23ab78a1-500a-4e2c-bc69-dc3cfbb9c985	2026-08-20 11:40	2026-08-20 11:40	2026-08-20 11:40	AAPL	AAPL260821C00280000	call	280.0000	2026-08-21	36.5500	36.4000	36.5500	316.3850	171785.00	32895.00	0.00	47	6	246	6538	0.0376261853777914	1.14530465350103	1.14530465350103	false	false	false	true	false
abf01c7f-f99f-42f4-a936-8eb9b42769dd	2026-08-20 11:41	2026-08-20 11:40	2026-08-20 11:40	AAPL	AAPL260821C00280000	call	280.0000	2026-08-21	36.5500	36.4000	36.5500	316.3706	186405.00	186405.00	0.00	51	7	297	6538	0.0454267360048945	1.16291081984239	1.16291081984239	true	false	false	true	false
a3aad8cc-fa0e-4dfc-b840-59880f380825	2026-08-20 11:41	2026-08-20 11:41	2026-08-20 11:41	AAPL	AAPL260821C00280000	call	280.0000	2026-08-21	36.6000	36.6000	36.7000	316.4950	168360.00	0.00	168360.00	46	6	387	6538	0.0591924135821352	1.05565439524783	1.05565439524783	false	false	false	true	false
030a8e50-efdd-4d5e-bd19-797aeb467512	2026-08-20 11:41	2026-08-20 11:41	2026-08-20 11:41	AAPL	AAPL260821C00280000	call	280.0000	2026-08-21	36.6000	36.5000	36.6000	316.4600	157380.00	128100.00	0.00	43	6	340	6538	0.0520036708473539	1.11279161664068	1.11279161664068	false	false	false	true	false
e7ea3e16-1223-4f19-bef4-9f60ba891c99	2026-08-20 11:45	2026-08-20 11:45	2026-08-20 11:45	AAPL	AAPL261120C00310000	call	310.0000	2026-11-20	22.3000	22.2000	22.4500	316.6050	350110.00	0.00	350110.00	157	5	231	12566	0.0183829380869012	0.273402582289713	0.273402582289713	false	false	false	true	false
89308987-246f-4fbf-80ea-ec7aabc3cef4	2026-08-20 11:58	2026-08-20 11:58	2026-08-20 11:58	AAPL	AAPL260826C00320000	call	320.0000	2026-08-26	2.5800	2.4600	2.6500	316.8100	1237369.00	1234278.00	3091.00	4796	89	6400	1796	3.56347438752784	0.244149907314577	0.243068612183593	false	false	false	true	false
fd9aacc2-b0cb-4b97-a2d1-81f75c709f83	2026-08-20 12:06	2026-08-20 12:06	2026-08-20 12:06	AAPL	AAPL270115P00310000	put	310.0000	2027-01-15	16.0500	15.8500	16.0750	316.5746	104325.00	77040.00	0.00	65	7	154	23298	0.00661000944287063	0.270148793430138	0.270148793430138	false	false	false	true	false
d4424c80-9db1-4ae5-a5af-82eb5d7ada33	2026-08-20 12:44	2026-08-20 12:43	2026-08-20 12:43	AAPL	AAPL281215P00320000	put	320.0000	2028-12-15	44.5500	44.4000	45.6000	317.1900	369765.00	204930.00	66825.00	83	10	83	864	0.0960648148148148	0.311597787399158	0.311597787399158	false	false	false	true	false
39a7eafd-b433-4f2f-a251-0988c18e581a	2026-08-20 13:36	2026-08-20 13:36	2026-08-20 13:36	AAPL	AAPL261016P00315000	put	315.0000	2026-10-16	10.6200	10.5500	10.7500	316.7900	106210.00	0.00	30595.00	100	7	325	4208	0.0772338403041825	0.247668382246368	0.24969890688386	false	false	false	true	false
95a9a87a-c27e-4823-9818-2d2c73e5c060	2026-08-20 13:48	2026-08-20 13:48	2026-08-20 13:48	AAPL	AAPL260821C00315000	call	315.0000	2026-08-21	2.8000	2.8000	2.8500	316.3300	344680.00	0.00	344680.00	1231	49	17253	20872	0.826609812188578	0.302844963086238	0.310564462556784	false	false	false	true	false
d32c8b3d-f54a-4e1f-8176-a45f6f01676c	2026-08-20 13:57	2026-08-20 13:57	2026-08-20 13:57	AAPL	AAPL270416P00290000	put	290.0000	2027-04-16	14.0000	14.0000	14.3500	316.4040	140000.00	0.00	140000.00	100	5	119	0	0	0.287646494224148	0.287646494224148	false	false	false	true	false
2784df07-e75c-4fa7-accc-104bf3133be2	2026-08-20 14:04	2026-08-20 14:04	2026-08-20 14:04	AAPL	AAPL270115C00330000	call	330.0000	2027-01-15	17.4500	17.4500	17.6000	316.0500	115170.00	0.00	115170.00	66	6	773	20810	0.0371456030754445	0.264746495296817	0.26483443605805	false	false	false	true	false
93b46e32-fbfb-41ed-8cf3-4a6018078b93	2026-08-20 14:20	2026-08-20 14:19	2026-08-20 14:19	AAPL	AAPL270617P00310000	put	310.0000	2027-06-17	24.8500	24.7500	24.9500	315.6100	149100.00	144130.00	4970.00	60	9	127	2364	0.0537225042301184	0.288570580234187	0.288570580234187	false	false	false	true	false
0242c2ab-e3ff-4c32-b28d-8b9bb5f3bb92	2026-08-20 14:25	2026-08-20 14:25	2026-08-20 14:25	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.6000	3.7000	315.1950	180000.00	0.00	180000.00	500	18	5101	32252	0.158160734218033	0.244271354915122	0.244271354915122	false	false	false	true	false
dc28af60-9d4d-4e15-9a15-7f802a0ae151	2026-08-20 14:25	2026-08-20 14:25	2026-08-20 14:25	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.6000	3.7000	315.1900	162720.00	0.00	162720.00	452	14	5601	32252	0.173663648765968	0.244317995246059	0.244317995246059	false	false	false	true	false
53124eab-eb7f-4f1c-9960-f0a1cdb4ae34	2026-08-20 14:27	2026-08-20 14:27	2026-08-20 14:27	AAPL	AAPL270617P00310000	put	310.0000	2027-06-17	25.1000	24.9500	25.3000	315.0200	371480.00	358930.00	10040.00	148	10	352	2364	0.148900169204738	0.288824742874655	0.288842033974467	false	false	false	true	false
72bb39b7-52a7-4acb-8cb1-a336ca163f8c	2026-08-20 14:47	2026-08-20 14:47	2026-08-20 14:47	AAPL	AAPL270115C00350000	call	350.0000	2027-01-15	10.1600	10.1500	10.4000	315.1900	1016306.00	0.00	1016306.00	1000	11	1496	32509	0.046018025777477	0.259758533158173	0.260492058396541	false	false	false	true	false
7fa36580-45d5-4d90-a99f-757f75dfec17	2026-08-20 14:49	2026-08-20 14:48	2026-08-20 14:48	AAPL	AAPL270115C00350000	call	350.0000	2027-01-15	10.1200	10.1000	10.3500	315.2400	1012052.00	0.00	1012052.00	1000	19	2496	32509	0.0767787381955766	0.258609585710159	0.259436738515045	false	false	false	true	false
bfb54d36-b82e-4d50-8a8b-384b160a31c5	2026-08-20 14:50	2026-08-20 14:49	2026-08-20 14:49	AAPL	AAPL270115C00350000	call	350.0000	2027-01-15	10.1500	10.1500	10.2000	315.2700	121825.00	5100.00	116725.00	120	5	4583	32509	0.14097634501215	0.25930178948286	0.259993475052932	false	false	false	true	false