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:alert_rule = RepeatedHitsDescendingFill×ticker = ORCL×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	expiry

23b2587f-4a4a-42c1-b67c-fb7ac8d9800f	2026-08-17 11:02	2026-08-17 11:02	2026-08-17 11:02	ORCL	ORCL260911C00190000	call	190.0000	2026-09-11	1.6700	1.6000	1.7300	147.1350	83450.00	58450.00	16650.00	500	24	2542	612	4.15359477124183	0.76927463736591	0.76927463736591	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	437806735440.00	2026-12-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2f12bd8c-5ccc-4148-82b9-a4d02342696c	2026-08-17 12:24	2026-08-17 12:23	2026-08-17 12:23	ORCL	ORCL261218P00155000	put	155.0000	2026-12-18	24.4000	24.1500	24.5500	148.6100	107370.00	104930.00	2440.00	44	10	48	1512	0.0317460317460317	0.639948512869446	0.638352371339155	false	false	false
480e57c5-8210-4f3d-a057-13d44e7c016a	2026-08-17 12:26	2026-08-17 12:26	2026-08-17 12:26	ORCL	ORCL260821P00145000	put	145.0000	2026-08-21	2.1600	2.1200	2.1700	148.3700	104849.00	104849.00	0.00	485	40	3574	10400	0.343653846153846	0.592827419251127	0.592827419251127	false	false	false
a81650f0-82c1-4dcc-92d3-9df07b32f8b7	2026-08-17 13:32	2026-08-17 13:32	2026-08-17 13:32	ORCL	ORCL260918P00135000	put	135.0000	2026-09-18	6.2000	6.0500	6.2500	146.9000	667074.00	375674.00	288300.00	1076	71	1228	6916	0.177559282822441	0.682744859259928	0.682545940944214	true	false	false
7bfcc8a4-84db-4442-b8b6-15bf125ce220	2026-08-17 15:44	2026-08-17 15:44	2026-08-17 15:44	ORCL	ORCL260821C00157500	call	157.5000	2026-08-21	0.8000	0.7800	0.8500	147.5200	117188.00	8400.00	97254.00	1466	70	3782	3484	1.08553386911596	0.617293583149302	0.614678980341452	true	false	false
55092c06-4ff3-47cc-b97b-c0bf369a896b	2026-08-18 09:32	2026-08-18 09:32	2026-08-18 09:32	ORCL	ORCL280915C00150000	call	150.0000	2028-09-15	51.4900	49.5000	52.8500	142.9000	87535.00	5155.00	30910.00	17	17	17	591	0.0287648054145516	0.624154876853427	0.624295967454126	false	false	false
31d1cb9e-cdaf-4af4-8507-39d7eac05754	2026-08-18 10:04	2026-08-18 10:04	2026-08-18 10:04	ORCL	ORCL270319C00290000	call	290.0000	2027-03-19	4.2500	3.9500	4.3000	145.2100	130465.00	130040.00	425.00	307	23	312	588	0.530612244897959	0.65751832917583	0.65751832917583	false	false	false
578655ee-1518-4144-9e3a-ccfc0c368d59	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	ORCL	ORCL261016C00150000	call	150.0000	2026-10-16	12.4800	12.4000	12.7000	143.9600	175979.00	0.00	175979.00	141	5	963	8239	0.116883116883117	0.636191330275963	0.636191330275963	false	false	false
2ddf28e0-b1a3-4130-a371-856174e39748	2026-08-18 12:32	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL260821C00150000	call	150.0000	2026-08-21	1.1000	1.0900	1.1300	143.8200	67564.00	0.00	67564.00	616	72	5635	18832	0.299224723874257	0.621656654606123	0.61858462186398	false	false	false
6e314ed8-2d05-48b1-8826-4c78b9805075	2026-08-18 12:32	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL260918C00160000	call	160.0000	2026-09-18	6.0100	6.0000	6.1500	143.6500	336610.00	73810.00	262800.00	560	16	1600	19945	0.0802206066683379	0.702099426909153	0.701740562848838	false	false	false
0ed3d825-52ff-4119-8727-da8d83a91d9e	2026-08-18 12:33	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL260918C00160000	call	160.0000	2026-09-18	5.7700	5.7500	6.0000	143.6100	358395.00	151965.00	206430.00	621	26	6065	19945	0.304086237152168	0.689571711986883	0.692842009801697	true	false	false
77108e9f-3d33-4df7-8bc7-4c02bf842e0c	2026-08-19 11:06	2026-08-19 11:05	2026-08-19 11:05	ORCL	ORCL260904P00142000	put	142.0000	2026-09-04	6.6500	6.5000	6.7500	141.7020	66528.00	24975.00	41553.00	100	11	305	234	1.3034188034188	0.567848093831102	0.554309414805087	false	false	false
d3900229-dc6a-42ec-879e-4ee6bd0d7b74	2026-08-19 11:19	2026-08-19 11:19	2026-08-19 11:19	ORCL	ORCL270617P00110000	put	110.0000	2027-06-17	13.5400	13.2000	13.7500	141.7950	63658.00	38046.00	25612.00	47	5	69	8871	0.00777815353398715	0.629941384523909	0.626230406289387	false	false	false
e05d96be-61e6-4475-8298-33890db0c2cb	2026-08-19 12:43	2026-08-19 12:42	2026-08-19 12:42	ORCL	ORCL260821C00146000	call	146.0000	2026-08-21	2.6200	2.4900	2.6300	145.5150	110203.00	96376.00	10956.00	421	57	1560	581	2.68502581755594	0.659216027017868	0.657970327548799	false	false	false
515f4a6a-ad22-48b8-8717-507631f84a52	2026-08-19 13:12	2026-08-19 13:12	2026-08-19 13:12	ORCL	ORCL261218C00125000	call	125.0000	2026-12-18	31.2600	31.2500	31.9500	143.9700	440725.00	15675.00	425050.00	141	10	151	516	0.292635658914729	0.634453935983213	0.630820777389776	false	false	false
334ffc96-dabf-44bd-8d64-2cb093a89aba	2026-08-19 14:54	2026-08-19 14:53	2026-08-19 14:53	ORCL	ORCL261016C00160000	call	160.0000	2026-10-16	8.9800	8.8000	9.0000	143.6899	75436.00	75436.00	0.00	84	5	795	4797	0.165728580362727	0.645268808761874	0.644362016686552	true	false	false	true
caa802b5-3578-4276-94be-ebe05b320200	2026-08-19 15:08	2026-08-19 15:07	2026-08-19 15:07	ORCL	ORCL261120P00130000	put	130.0000	2026-11-20	10.7000	10.7000	10.9000	143.6233	634568.00	0.00	634568.00	593	37	838	4675	0.179251336898396	0.631562165821914	0.627918506505187	false	false	false
7cb47566-efbc-47b2-8da2-88eb572a4903	2026-08-19 15:52	2026-08-19 15:52	2026-08-19 15:52	ORCL	ORCL260828C00145000	call	145.0000	2026-08-28	4.3500	4.3000	4.5000	143.2600	63575.00	5720.00	57855.00	146	14	2086	2757	0.756619513964454	0.572269701532166	0.566680554852338	false	false	false
0af0eefe-28b5-4a5d-b14c-03b2c4f9eb43	2026-08-20 09:32	2026-08-20 09:32	2026-08-20 09:32	ORCL	ORCL280915C00150000	call	150.0000	2028-09-15	51.4200	49.6000	52.4500	143.7500	51425.00	10285.00	36000.00	10	10	44	632	0.069620253164557	0.615841717265894	0.616548555925063	false	false	false
4637d3b4-d569-480c-b6cb-2f4d4d5aa647	2026-08-20 10:40	2026-08-20 10:40	2026-08-20 10:40	ORCL	ORCL270917C00200000	call	200.0000	2027-09-17	21.9900	21.2500	23.3500	142.6300	263850.00	224250.00	39600.00	120	5	122	871	0.140068886337543	0.620943801784331	0.620943801784331	false	false	false
8395435d-1f44-4678-b3e7-02784cf8e8a2	2026-08-20 10:59	2026-08-20 10:59	2026-08-20 10:59	ORCL	ORCL260821P00143000	put	143.0000	2026-08-21	2.5100	2.5100	2.5500	142.0800	162062.00	13972.00	148090.00	645	18	1532	1558	0.983311938382542	0.683513073092242	0.694155578538897	true	false	false
69b60766-f840-4438-965b-e9549d9efb55	2026-08-21 10:52	2026-08-21 10:52	2026-08-21 10:52	ORCL	ORCL261120P00115000	put	115.0000	2026-11-20	5.0000	4.8500	5.0000	147.0550	380982.00	380982.00	0.00	762	34	823	4204	0.195765937202664	0.643412129001783	0.643412129001783	false	false	false
4287de8a-496f-4372-b1ca-562916f7b77b	2026-08-21 11:24	2026-08-21 11:24	2026-08-21 11:24	ORCL	ORCL261120P00155000	put	155.0000	2026-11-20	22.3000	22.0500	22.3000	147.4900	582010.00	582010.00	0.00	261	30	271	1943	0.139475038600103	0.641945595699505	0.641283947702169	false	false	false
3bbd65e2-3c60-463f-84c8-1d6f503ddf94	2026-08-21 11:44	2026-08-21 11:44	2026-08-21 11:44	ORCL	ORCL261120P00150000	put	150.0000	2026-11-20	19.3500	19.0000	19.3500	147.2750	971345.00	971345.00	0.00	502	57	502	4283	0.117207564791034	0.638740271226511	0.637433756636439	false	false	false
c7431c4a-55fa-49cb-9c1d-60af5a4b72f5	2026-08-21 13:20	2026-08-21 13:20	2026-08-21 13:20	ORCL	ORCL260821C00130000	call	130.0000	2026-08-21	17.1700	16.9500	18.1500	147.1900	85834.00	0.00	85834.00	50	5	123	8410	0.0146254458977408	6.27001269301814	6.27001269301814	false	false	false
0a6b30eb-1f77-47ab-a629-663923676b04	2026-08-21 14:22	2026-08-21 14:22	2026-08-21 14:22	ORCL	ORCL260918C00180000	call	180.0000	2026-09-18	2.6100	2.5300	2.6600	145.0000	65434.00	42123.00	23311.00	251	33	2213	20195	0.109581579598911	0.731328850462262	0.733225579069503	true	false	false
9eb3283c-7cff-4290-aa30-735d2f607d08	2026-08-21 15:51	2026-08-21 15:51	2026-08-21 15:51	ORCL	ORCL280915P00115000	put	115.0000	2028-09-15	26.9100	24.9500	28.3500	146.8488	344450.00	126560.00	217890.00	128	22	160	962	0.166320166320166	0.644185406230195	0.643354858666354	false	false	false
b8436faa-757e-44ef-9c39-7f2fc39d9bd7	2026-08-24 09:51	2026-08-24 09:51	2026-08-24 09:51	ORCL	ORCL261120C00165000	call	165.0000	2026-11-20	9.9100	9.9000	10.3000	142.1200	146690.00	0.00	146690.00	148	8	157	4281	0.036673674375146	0.627771157529981	0.627771157529981	false	false	false
48945f80-f1ce-4eec-b3c5-d0376876fb0b	2026-08-24 09:51	2026-08-24 09:51	2026-08-24 09:51	ORCL	ORCL260918C00155000	call	155.0000	2026-09-18	6.3200	6.0500	6.6000	142.1498	126318.00	65056.00	48032.00	200	11	213	13909	0.0153138255805594	0.743094868254927	0.743094868254927	true	false	false
42120936-e35d-419a-9822-fcd3cf4e7c0b	2026-08-24 10:38	2026-08-24 10:38	2026-08-24 10:38	ORCL	ORCL270115P00150000	put	150.0000	2027-01-15	25.5500	25.0000	25.6500	142.6200	102180.00	97080.00	5100.00	40	19	123	14357	0.00856724942536742	0.635151554428963	0.633295066585377	false	false	false
678697b7-8882-460e-890b-fe9a2b608f87	2026-08-24 13:35	2026-08-24 13:35	2026-08-24 13:35	ORCL	ORCL270617P00145000	put	145.0000	2027-06-17	30.2100	30.0000	30.4000	143.3450	120824.00	72504.00	0.00	40	6	80	1858	0.0430570505920344	0.629412027805303	0.629412027805303	false	false	false
1b58af32-19d2-4e2c-bb1a-617841918d7d	2026-08-24 13:36	2026-08-24 13:36	2026-08-24 13:36	ORCL	ORCL270617P00145000	put	145.0000	2027-06-17	30.1900	30.0000	30.4000	143.3650	120776.00	0.00	72456.00	40	5	120	1858	0.0645855758880517	0.629360549146616	0.629360549146616	false	false	false
86244eba-af1e-46de-8006-10e9f5eef12f	2026-08-24 15:12	2026-08-24 15:12	2026-08-24 15:12	ORCL	ORCL261120P00135000	put	135.0000	2026-11-20	12.6900	12.3000	12.7500	143.4000	322410.00	319885.00	2525.00	254	47	265	2031	0.130477597242738	0.632617744600285	0.630703247540641	false	false	false
d0ab71e9-1f0e-423c-a7d6-c0574a1cd24c	2026-08-25 09:42	2026-08-25 09:42	2026-08-25 09:42	ORCL	ORCL260828P00145000	put	145.0000	2026-08-28	3.1500	2.9600	3.1500	146.1000	349620.00	349620.00	0.00	1110	65	1179	1631	0.722869405272839	0.702015517775563	0.702015517775563	false	false	false
7046d345-0c12-4443-9f7a-32837de159d6	2026-08-25 10:42	2026-08-25 10:42	2026-08-25 10:42	ORCL	ORCL270319P00120000	put	120.0000	2027-03-19	13.1600	13.1500	13.7500	145.3200	57925.00	0.00	57925.00	44	5	156	7659	0.0203681942812378	0.636748654478181	0.63529479265988	false	false	false
334f07eb-ec75-4e33-bce2-04dd10e85b1e	2026-08-25 12:33	2026-08-25 12:33	2026-08-25 12:33	ORCL	ORCL261002P00120000	put	120.0000	2026-10-02	2.6500	2.5800	2.7400	145.2200	108967.00	3497.00	105470.00	411	18	1973	112	17.6160714285714	0.655946809850433	0.652316945234221	false	false	false
15b25b34-13df-44d2-96b9-c94ef0e2178e	2026-08-26 10:43	2026-08-26 10:43	2026-08-26 10:43	ORCL	ORCL270319C00230000	call	230.0000	2027-03-19	8.6500	8.6000	9.5000	147.4050	53645.00	0.00	53645.00	62	13	62	5246	0.0118185284025925	0.635813902070189	0.634407855370958	false	false	false
964cf6d0-ce31-40a3-999b-d2e6a2b72976	2026-08-27 15:28	2026-08-27 15:28	2026-08-27 15:28	ORCL	ORCL260911C00150000	call	150.0000	2026-09-11	10.3200	10.1500	10.5500	150.0000	60865.00	0.00	60865.00	59	5	475	1196	0.397157190635452	0.806345509746218	0.806345509746218	false	false	false
e1387826-d6de-47fe-89c0-a731430028d2	2026-08-28 09:46	2026-08-28 09:46	2026-08-28 09:46	ORCL	ORCL270319C00210000	call	210.0000	2027-03-19	12.7900	12.7500	13.6500	152.5000	547525.00	0.00	105925.00	428	27	429	3041	0.141072015784281	0.625138629552255	0.622018568970794	false	false	false
5ee82172-a0dc-4012-84ab-376a4813a7ac	2026-08-28 09:47	2026-08-28 09:47	2026-08-28 09:47	ORCL	ORCL270319C00210000	call	210.0000	2027-03-19	13.0800	13.0500	13.2000	152.8400	313950.00	0.00	65450.00	240	36	1536	3041	0.505097007563302	0.628163663654282	0.626397698585002	false	false	false
dadf30d5-a3d7-4854-b0e9-d52431c7d47e	2026-08-28 10:53	2026-08-28 10:53	2026-08-28 10:53	ORCL	ORCL261120C00180000	call	180.0000	2026-11-20	9.5000	9.2000	9.6500	153.1500	949957.00	948057.00	0.00	1000	75	1011	6039	0.167411823149528	0.625696942726861	0.621127613236161	false	false	false
a735254e-44ef-48f1-b3d1-6e8f401f1944	2026-08-28 11:16	2026-08-28 11:16	2026-08-28 11:16	ORCL	ORCL260904P00145000	put	145.0000	2026-09-04	1.3300	1.2400	1.3500	153.2300	66739.00	66739.00	0.00	500	26	1107	1947	0.568567026194145	0.521517208501226	0.516215922922165	true	false	false	true
89540022-aaed-4e8a-8a55-1239ccafad96	2026-08-28 11:23	2026-08-28 11:22	2026-08-28 11:22	ORCL	ORCL260918C00170000	call	170.0000	2026-09-18	4.8700	4.7500	5.0000	152.7750	82365.00	39200.00	43165.00	169	5	1494	15375	0.0971707317073171	0.740627274080583	0.740627274080583	false	false	false
350ae95b-c264-4eae-8bd6-32093b327b44	2026-08-28 12:45	2026-08-28 12:44	2026-08-28 12:44	ORCL	ORCL260904P00143000	put	143.0000	2026-09-04	1.4300	1.3300	1.4400	150.1900	71631.00	71631.00	0.00	500	30	755	231	3.26839826839827	0.508303012138553	0.501162166970581	true	false	false	true
ea894650-47e2-43ff-9360-722b7eb88948	2026-08-31 10:52	2026-08-31 10:52	2026-08-31 10:52	ORCL	ORCL260904C00150000	call	150.0000	2026-09-04	3.2000	3.1000	3.4000	149.1600	193262.00	191022.00	2240.00	604	58	1442	3866	0.372995344024832	0.578615166522217	0.57249110598562	false	false	false
dfe23c79-c64d-47d3-a830-a5cebc081f75	2026-08-31 14:05	2026-08-31 14:05	2026-08-31 14:05	ORCL	ORCL261002C00160000	call	160.0000	2026-10-02	8.1000	7.8500	8.2000	150.0000	1619925.00	1008375.00	251910.00	2000	32	2340	130	18	0.668342858401576	0.667860658022276	true	false	false	true
db8ddaa1-a913-4504-a4d1-4dce5027b797	2026-08-31 14:37	2026-08-31 14:37	2026-08-31 14:37	ORCL	ORCL270319C00330000	call	330.0000	2027-03-19	2.5500	2.4200	2.5600	150.3900	169268.00	139328.00	1012.00	664	56	664	1133	0.586054721977052	0.653768515735711	0.65211687420525	true	false	false
a05a222a-0a75-45b9-9676-009703bea3dc	2026-08-31 14:40	2026-08-31 14:40	2026-08-31 14:40	ORCL	ORCL270319C00340000	call	340.0000	2027-03-19	2.3200	2.1300	2.3300	150.4734	125837.00	101412.00	1824.00	543	17	543	720	0.754166666666667	0.658365309972024	0.655423066532665	true	false	false
308cceb5-7da3-4712-aa42-8f376a9304ab	2026-08-31 15:19	2026-08-31 15:19	2026-08-31 15:19	ORCL	ORCL260904P00150000	put	150.0000	2026-09-04	3.2900	3.2000	3.3000	150.4400	82287.00	82287.00	0.00	250	21	1012	1288	0.785714285714286	0.565401796953097	0.565401796953097	false	false	false
7edc575b-a912-4514-b40b-2cefd355915a	2026-09-01 10:43	2026-09-01 10:42	2026-09-01 10:42	ORCL	ORCL260904C00139000	call	139.0000	2026-09-04	5.5500	5.3500	6.0500	143.0500	810266.00	809711.00	555.00	1460	67	1462	85	17.2	0.619886370083828	0.604027224710954	false	false	false	true