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 = RepeatedHits×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	expirydate

19ef0e45-68b9-4297-94a2-b85dddc54bac	2026-08-17 09:34	2026-08-17 09:34	2026-08-17 09:34	ORCL	ORCL261120C00150000	call	150.0000	2026-11-20	19.2500	18.7500	20.2500	149.1000	385000.00	0.00	385000.00	200	6	491	10116	0.0485369711348359	0.628246365816171	0.628246365816171	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	437806735440.00	2026-12-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
dcf387d7-62cb-4ebc-94c8-05da996e9f11	2026-08-17 09:46	2026-08-17 09:46	2026-08-17 09:46	ORCL	ORCL281215C00140000	call	140.0000	2028-12-15	59.7000	59.5000	62.5000	146.2600	232845.00	5985.00	226860.00	39	6	39	308	0.126623376623377	0.617709554423418	0.619751936567295	false	false	false	true
8127af96-279b-4f73-9745-07fba9ed393c	2026-08-17 09:51	2026-08-17 09:51	2026-08-17 09:51	ORCL	ORCL270617C00150000	call	150.0000	2027-06-17	33.2500	32.4500	35.1500	146.4650	123025.00	3325.00	119700.00	37	5	43	2516	0.0170906200317965	0.62182188646984	0.62182188646984	false	false	false	true
a0c330a9-48df-443e-b7d5-b0742b7fcc0c	2026-08-17 09:53	2026-08-17 09:52	2026-08-17 09:52	ORCL	ORCL260821C00150000	call	150.0000	2026-08-21	2.7100	2.5900	2.7100	146.8050	54200.00	54200.00	0.00	200	10	1477	24508	0.0602660355802187	0.659682705960109	0.659682705960109	false	false	false	true
5a258cae-c7e3-4347-ba8a-31d01d2c2bbb	2026-08-17 10:00	2026-08-17 09:59	2026-08-17 09:59	ORCL	ORCL260918C00140000	call	140.0000	2026-09-18	15.0500	15.0500	15.7000	146.1500	165550.00	0.00	165550.00	110	11	131	9363	0.0139912421232511	0.679168832341371	0.679168832341371	false	false	false	true
3b648c9b-b88c-40e3-a249-d841e995b2bb	2026-08-17 10:05	2026-08-17 10:05	2026-08-17 10:05	ORCL	ORCL261218C00250000	call	250.0000	2026-12-18	3.2500	3.0000	3.4500	146.0000	162497.00	12672.00	102050.00	500	8	516	25501	0.0202345006078193	0.684803982345809	0.684803982345809	true	false	false	true
f81df6b7-69ce-4c9f-9dfa-32dbf11c7923	2026-08-17 10:10	2026-08-17 10:10	2026-08-17 10:10	ORCL	ORCL280915C00370000	call	370.0000	2028-09-15	18.3000	16.2500	20.0000	147.2000	316590.00	36600.00	279990.00	173	7	199	2433	0.0817920263049733	0.627229889103988	0.627229889103988	false	false	false	true
70096d64-d200-4b9e-80c3-e291315cf5a6	2026-08-17 10:11	2026-08-17 10:11	2026-08-17 10:11	ORCL	ORCL260821C00150000	call	150.0000	2026-08-21	2.8200	2.7500	2.8200	147.4151	56400.00	56400.00	0.00	200	7	2572	24508	0.104945323975845	0.636917005913766	0.636917005913766	false	false	false	true
c676e927-637d-411a-91ed-7be0e766f111	2026-08-17 10:16	2026-08-17 10:16	2026-08-17 10:16	ORCL	ORCL260821P00145000	put	145.0000	2026-08-21	2.7700	2.7700	2.8500	147.0500	250685.00	0.00	250685.00	905	50	2172	10400	0.208846153846154	0.610613351025771	0.611955275783657	false	false	false	true
ee002809-233a-42ad-a0c9-7be2f0bab324	2026-08-17 10:24	2026-08-17 10:24	2026-08-17 10:24	ORCL	ORCL270617C00300000	call	300.0000	2027-06-17	7.2000	6.9500	7.2000	147.1200	144000.00	144000.00	0.00	200	5	241	7083	0.0340251305943809	0.642881071630582	0.642881071630582	false	false	false	true
f27ccf3a-585e-46b4-a945-2a71203d7cc9	2026-08-17 10:50	2026-08-17 10:49	2026-08-17 10:49	ORCL	ORCL270617P00090000	put	90.0000	2027-06-17	6.5000	6.1500	6.7500	147.4800	93600.00	650.00	92950.00	144	10	149	4902	0.0303957568339453	0.641972076699644	0.641972076699644	false	false	false	true
c9658d93-5566-4bd6-86d3-ca2f911f8bd5	2026-08-17 11:05	2026-08-17 11:05	2026-08-17 11:05	ORCL	ORCL260911C00190000	call	190.0000	2026-09-11	1.6400	1.6400	1.6700	146.7500	64944.00	0.00	64944.00	396	5	3042	612	4.97058823529412	0.771485885743002	0.771485885743002	false	false	false	true
e19da887-8a26-4f4a-9a27-9621c57c3b45	2026-08-17 11:56	2026-08-17 11:56	2026-08-17 11:56	ORCL	ORCL260821C00155000	call	155.0000	2026-08-21	1.6000	1.5600	1.6000	148.8600	66080.00	66080.00	0.00	413	5	3366	7748	0.434434692823955	0.616489898882066	0.616489898882066	true	false	false	true
ec1cfaaf-25a3-4345-9f41-52a0f3b418f5	2026-08-17 12:04	2026-08-17 12:04	2026-08-17 12:04	ORCL	ORCL280915P00120000	put	120.0000	2028-09-15	29.6500	29.6500	30.6500	148.6950	94880.00	0.00	94880.00	32	15	323	1276	0.253134796238245	0.651669726116973	0.651669726116973	false	false	false	true
fc22a778-d162-4bb5-9528-63ed21d8d98d	2026-08-17 12:04	2026-08-17 12:04	2026-08-17 12:04	ORCL	ORCL280915P00120000	put	120.0000	2028-09-15	29.6500	29.5500	30.6500	148.7200	118600.00	53370.00	65230.00	40	12	363	1276	0.28448275862069	0.651669726116973	0.651755384020918	false	false	false	true
0139b6a9-a6a7-4a48-ae76-e33d8b33c3ca	2026-08-17 12:24	2026-08-17 12:24	2026-08-17 12:24	ORCL	ORCL270115C00200000	call	200.0000	2027-01-15	9.8000	9.8000	10.2000	148.4500	83300.00	0.00	83300.00	85	22	411	20124	0.0204233750745379	0.628224960122035	0.628224960122035	false	false	false	true
8b878974-e31c-4b52-b95d-0c23d0e93790	2026-08-17 13:14	2026-08-17 13:14	2026-08-17 13:14	ORCL	ORCL261218P00130000	put	130.0000	2026-12-18	12.0500	11.6500	12.1000	147.3101	57840.00	55430.00	2410.00	48	17	113	4791	0.0235858902108119	0.636411968059088	0.636067569035252	false	false	false	true
2b7b282d-29f4-4ade-b39b-c599908c66e2	2026-08-17 13:14	2026-08-17 13:14	2026-08-17 13:14	ORCL	ORCL261218P00140000	put	140.0000	2026-12-18	16.6500	16.2500	16.7000	147.3101	79920.00	78255.00	1665.00	48	16	143	4869	0.0293694803861162	0.636867179386267	0.63647461069326	false	false	false	true
5303c7dc-3f53-44a6-9bbd-b1c9b19cc45e	2026-08-17 14:29	2026-08-17 14:29	2026-08-17 14:29	ORCL	ORCL260911C00165000	call	165.0000	2026-09-11	5.3000	5.2000	5.4000	147.6400	98050.00	42400.00	37630.00	185	8	899	310	2.9	0.731863751777684	0.731863751777684	false	false	false	true
df2e91c7-622d-41fd-a0c6-e5ac1fcc05e0	2026-08-17 14:40	2026-08-17 14:40	2026-08-17 14:40	ORCL	ORCL260828P00148000	put	148.0000	2026-08-28	5.8000	5.6500	5.8000	147.6800	84680.00	84680.00	0.00	146	38	189	147	1.28571428571429	0.559601148360882	0.559601148360882	false	false	false	true
1d39c2d2-d36c-4d36-8cb9-fe42fd3adf09	2026-08-17 15:02	2026-08-17 15:02	2026-08-17 15:02	ORCL	ORCL281215P00130000	put	130.0000	2028-12-15	37.1100	37.0500	38.9500	148.0000	55665.00	0.00	55665.00	15	11	19	59	0.322033898305085	0.655108093699131	0.655023728017614	true	false	false	true
930f19dd-8972-4b8f-94b7-c2efe1657bd5	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	ORCL	ORCL281215P00125000	put	125.0000	2028-12-15	34.2000	34.1000	34.2000	148.1000	58140.00	58140.00	0.00	17	6	102	345	0.295652173913043	0.65271756635166	0.65271756635166	false	false	false	true
1aee6727-ca7d-40d3-87b2-c22c1136f1ef	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	ORCL	ORCL281215P00125000	put	125.0000	2028-12-15	34.2000	34.1000	34.7500	148.1000	54720.00	51300.00	3420.00	16	6	81	345	0.234782608695652	0.65271756635166	0.65271756635166	false	false	false	true
08b7a729-b09a-42c9-94c9-e5f2fdbb469f	2026-08-17 15:09	2026-08-17 15:08	2026-08-17 15:08	ORCL	ORCL281215P00125000	put	125.0000	2028-12-15	34.1000	34.0000	34.6500	148.4400	64790.00	13640.00	51150.00	19	7	195	345	0.565217391304348	0.652383590129314	0.652350735436542	true	false	false	true
9c5e3df9-cc8c-4e58-b1ea-d03e528ee223	2026-08-17 15:09	2026-08-17 15:08	2026-08-17 15:08	ORCL	ORCL281215P00125000	put	125.0000	2028-12-15	34.1000	34.0500	34.1000	148.4400	105710.00	105710.00	0.00	31	6	226	345	0.655072463768116	0.652350735436542	0.652350735436542	false	false	false	true
3b18a1c0-0871-454a-b224-279d15bb172f	2026-08-17 15:22	2026-08-17 15:22	2026-08-17 15:22	ORCL	ORCL281215P00130000	put	130.0000	2028-12-15	36.9500	36.7500	36.9500	148.2800	55425.00	55425.00	0.00	15	6	207	59	3.50847457627119	0.653801469824877	0.653801469824877	true	false	false	true
5729042c-fe67-41af-ac98-adf621838be1	2026-08-17 15:22	2026-08-17 15:22	2026-08-17 15:22	ORCL	ORCL281215P00130000	put	130.0000	2028-12-15	36.9500	36.8500	38.0500	148.2530	62815.00	44340.00	18475.00	17	8	224	59	3.79661016949153	0.653877868462327	0.653710573227454	true	false	false	true
548cf497-aaa5-409f-b590-ee98571c31f9	2026-08-18 09:32	2026-08-18 09:31	2026-08-18 09:31	ORCL	ORCL260911C00160000	call	160.0000	2026-09-11	5.0000	4.9500	5.6000	143.2800	55515.00	3515.00	52000.00	111	6	146	1410	0.10354609929078	0.731444322578677	0.745312836556759	false	false	false	true
7547baea-a6bc-4930-9cc1-c073f7a5cc74	2026-08-18 09:45	2026-08-18 09:45	2026-08-18 09:45	ORCL	ORCL270617P00090000	put	90.0000	2027-06-17	6.8000	6.6000	7.5000	144.0000	262480.00	5440.00	257040.00	386	5	386	5004	0.0771382893685052	0.642817349807419	0.642817349807419	false	false	false	true
8af39ced-f820-470b-961a-d6e1bfda878b	2026-08-18 09:48	2026-08-18 09:48	2026-08-18 09:48	ORCL	ORCL261218C00125000	call	125.0000	2026-12-18	31.8000	31.2000	32.3500	144.0000	111300.00	3180.00	108120.00	35	5	36	482	0.0746887966804979	0.630856667873398	0.630856667873398	false	false	false	true
6111de55-1983-4be4-9aa4-fe1d19aaa2b7	2026-08-18 09:52	2026-08-18 09:51	2026-08-18 09:51	ORCL	ORCL260821P00143000	put	143.0000	2026-08-21	2.9200	2.8400	2.9500	143.7000	292000.00	289080.00	2920.00	1000	14	1195	1109	1.0775473399459	0.633469245332254	0.632592725592349	false	false	false	true
e906b877-d8e8-4fde-8126-5184a7b2ed1d	2026-08-18 10:08	2026-08-18 10:08	2026-08-18 10:08	ORCL	ORCL270319C00135000	call	135.0000	2027-03-19	32.5000	32.0000	32.5000	144.8200	211250.00	78000.00	0.00	65	7	77	1553	0.0495814552479073	0.611022942443449	0.611022942443449	false	false	false	true
67c5f6eb-111e-46c1-a325-ee1501d245c4	2026-08-18 10:37	2026-08-18 10:37	2026-08-18 10:37	ORCL	ORCL270115C00320000	call	320.0000	2027-01-15	1.5200	1.2200	1.6100	143.5900	304000.00	297920.00	6080.00	2000	69	2000	6449	0.310125600868352	0.700389722812635	0.700389722812635	false	false	false	true
da261c80-7a08-4862-903c-fb9671b1596b	2026-08-18 10:46	2026-08-18 10:46	2026-08-18 10:46	ORCL	ORCL260821P00143000	put	143.0000	2026-08-21	3.0000	2.9100	3.0500	143.2250	300000.00	211800.00	74400.00	1000	12	2567	1109	2.31469792605951	0.605438829753109	0.605438829753109	false	false	false	true
f2a20a64-c0f8-4e0d-b142-01159b02ac65	2026-08-18 12:09	2026-08-18 12:08	2026-08-18 12:08	ORCL	ORCL260821P00145000	put	145.0000	2026-08-21	3.5800	3.5000	3.6000	144.1600	73730.00	73730.00	0.00	206	8	950	11455	0.0829332169358359	0.605759760996453	0.599990527961361	false	false	false	true
67d0c7f6-ff9c-47f3-a064-0ce6d40f9f9b	2026-08-18 12:09	2026-08-18 12:09	2026-08-18 12:09	ORCL	ORCL260821C00145000	call	145.0000	2026-08-21	2.8800	2.8800	2.9000	144.2300	57600.00	0.00	57600.00	200	7	1678	6732	0.249257278669043	0.617619066776992	0.617619066776992	false	false	false	true
16083905-c87d-4d99-910d-78f99c102f5b	2026-08-18 12:32	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL260821C00150000	call	150.0000	2026-08-21	1.0800	1.0700	1.1200	143.8200	56808.00	108.00	56700.00	526	12	6359	18832	0.337669923534409	0.616096579243134	0.616096579243134	false	false	false	true
33eefdc7-69a7-4ab9-8d9d-c52c9c141083	2026-08-18 12:32	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL260918C00160000	call	160.0000	2026-09-18	6.0500	6.0000	6.2000	143.7800	298870.00	41140.00	257730.00	494	21	900	19945	0.0451240912509401	0.702310959406353	0.702099426909153	false	false	false	true
d080316e-d831-43e7-a077-8e6f938f3c29	2026-08-18 12:32	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL261016C00165000	call	165.0000	2026-10-16	7.6000	7.5500	8.1000	143.6000	72203.00	760.00	71443.00	95	18	147	6403	0.0229579884429174	0.640647536007514	0.640647536007514	false	false	false	true
cb53102e-d2bc-4849-8994-d7550ec1ad15	2026-08-18 12:32	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL260918C00160000	call	160.0000	2026-09-18	5.9000	5.8500	6.1500	143.6500	250750.00	1180.00	249570.00	425	53	2025	19945	0.101529205314615	0.69500175314263	0.695223076753117	false	false	false	true
3199db06-eecc-413b-ad95-0f5bb5a9f6b0	2026-08-18 12:32	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL260918C00160000	call	160.0000	2026-09-18	5.9000	5.8500	6.1500	143.6000	75520.00	69030.00	6490.00	128	8	2643	19945	0.132514414640261	0.696329601744387	0.696329601744387	false	false	false	true
d52855ca-0000-452d-9be1-8feab1a4b401	2026-08-18 12:33	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL260918C00160000	call	160.0000	2026-09-18	5.8500	5.7500	6.1000	143.5950	520196.00	155190.00	365006.00	889	36	4336	19945	0.217397844071196	0.693725433395643	0.696440245757676	true	false	false	true
4d079bc2-872e-42c6-b35a-b53f2b1f26c6	2026-08-18 12:33	2026-08-18 12:32	2026-08-18 12:32	ORCL	ORCL260918C00160000	call	160.0000	2026-09-18	5.8100	5.7500	6.0000	143.6100	410030.00	102630.00	307400.00	706	16	5444	19945	0.27295061418902	0.689571711986883	0.689571711986883	false	false	false	true
e206aeac-13d6-42b7-b29e-c22a75f555cc	2026-08-18 12:34	2026-08-18 12:34	2026-08-18 12:34	ORCL	ORCL261016C00180000	call	180.0000	2026-10-16	4.4500	4.4000	4.7500	143.4850	85482.00	0.00	85482.00	192	6	1183	8080	0.146410891089109	0.639807283688249	0.639807283688249	false	false	false	true
71a57717-601a-4345-bb34-4c9989e67019	2026-08-18 12:34	2026-08-18 12:34	2026-08-18 12:34	ORCL	ORCL261016C00180000	call	180.0000	2026-10-16	4.4500	4.4000	4.7500	143.4850	242550.00	0.00	242550.00	545	25	861	8080	0.106559405940594	0.639807283688249	0.639807283688249	false	false	false	true
25b90609-9130-4f52-ba54-19b29fefa25f	2026-08-18 12:36	2026-08-18 12:36	2026-08-18 12:36	ORCL	ORCL260918C00145000	call	145.0000	2026-09-18	11.0500	11.0500	11.2000	143.4900	716040.00	0.00	716040.00	648	5	855	9925	0.0861460957178841	0.691765777933307	0.691765777933307	false	false	false	true
00e8e460-35ff-4391-9207-2d0cb4763b8e	2026-08-18 12:54	2026-08-18 12:54	2026-08-18 12:54	ORCL	ORCL261218C00200000	call	200.0000	2026-12-18	6.8000	6.8000	6.9500	143.8350	390389.00	0.00	390389.00	574	30	755	10276	0.0734721681588167	0.64293689181228	0.64293689181228	false	false	false	true
84d8fe2f-2047-440b-82a8-cb5802fc6ed6	2026-08-18 12:59	2026-08-18 12:59	2026-08-18 12:59	ORCL	ORCL270115P00130000	put	130.0000	2027-01-15	14.5500	14.5000	14.8000	143.7600	88755.00	0.00	88755.00	61	16	69	15166	0.00454965053408941	0.625365469456297	0.625365469456297	false	false	false	true
7bdf9196-1d0a-44f2-8f94-74eac4b68ae0	2026-08-18 13:15	2026-08-18 13:15	2026-08-18 13:15	ORCL	ORCL261016C00175000	call	175.0000	2026-10-16	5.4000	5.3000	5.5000	143.7150	55620.00	16740.00	38880.00	103	9	183	4547	0.0402463162524742	0.640539722744425	0.640539722744425	false	false	false	true
44c90e7f-742a-48a8-bf91-47d05f80a1b4	2026-08-18 13:16	2026-08-18 13:16	2026-08-18 13:16	ORCL	ORCL260821C00137000	call	137.0000	2026-08-21	7.3500	7.3500	7.4000	143.2302	159516.00	0.00	159516.00	217	15	247	1006	0.245526838966203	0.653507525601732	0.653507525601732	false	false	false	true