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:source = uw_flow_alerts×ticker = OLLI×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

87b21bcf-bfe1-470f-81d8-0f965a063d61	2026-09-14 12:25	2026-09-14 12:25	2026-09-14 12:25	OLLI	OLLI261016C00080000	call	80.0000	2026-10-16	3.5000	3.3000	3.5000	77.5800	36397.00	36397.00	0.00	104	33	118	757	0.155878467635403	0.483478144297437	0.483478144297437	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	4575173079.00	2026-12-08	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4c9ae2d7-c1f2-4712-8d5f-a45401f1ff86	2026-09-14 12:07	2026-09-14 12:07	2026-09-14 12:07	OLLI	OLLI270115C00080000	call	80.0000	2027-01-15	8.0000	7.8000	8.1000	77.1250	11200.00	8800.00	2400.00	14	14	48	81	0.592592592592593	0.493009492080397	0.491978473949631	true	false	false	true
6b68915e-5382-4e58-8c80-7599b0e1964a	2026-09-14 12:05	2026-09-14 12:05	2026-09-14 12:05	OLLI	OLLI270115C00085000	call	85.0000	2027-01-15	6.0000	5.8000	6.0000	77.0050	11999.00	11999.00	0.00	20	20	67	1034	0.0647969052224371	0.485319270617706	0.485319270617706	false	false	false	true
5ae01387-bb4c-4f4a-bc0a-aab1f4dd115b	2026-09-08 10:31	2026-09-08 10:31	2026-09-08 10:31	OLLI	OLLI260918C00070000	call	70.0000	2026-09-18	6.4000	6.4000	6.6000	75.7800	44800.00	0.00	44800.00	70	19	70	7004	0.00999428897772701	0.505830040194129	0.505830040194129	false	false	false	true
770e7bcb-638d-4d86-b1ad-5d71df5d250d	2026-09-04 12:10	2026-09-04 12:10	2026-09-04 12:10	OLLI	OLLI261016C00080000	call	80.0000	2026-10-16	3.3000	3.2000	3.5000	76.3400	113180.00	330.00	112850.00	343	9	350	454	0.770925110132159	0.452440690775843	0.442559569285023	false	false	false	true
2b601c49-4cd6-4f07-ae75-e1ab7e395a0d	2026-09-04 10:58	2026-09-04 10:58	2026-09-04 10:58	OLLI	OLLI260918P00075000	put	75.0000	2026-09-18	2.3000	2.3000	2.3500	76.2500	52210.00	0.00	52210.00	227	17	429	535	0.801869158878505	0.496439205095142	0.496439205095142	false	false	false	true
5c6c0ef4-8798-4c95-87b4-64084cc7b510	2026-09-04 10:58	2026-09-04 10:58	2026-09-04 10:58	OLLI	OLLI260918P00075000	put	75.0000	2026-09-18	2.1500	2.1500	2.2000	76.6400	11180.00	0.00	11180.00	52	15	154	535	0.28785046728972	0.49730984701561	0.49730984701561	false	false	false	true
655ac922-bd88-4e02-ad81-e7da1f7a6dcd	2026-09-04 10:57	2026-09-04 10:57	2026-09-04 10:57	OLLI	OLLI260918P00075000	put	75.0000	2026-09-18	2.0000	2.0000	2.1000	76.6600	13000.00	0.00	12000.00	65	14	102	535	0.190654205607477	0.472512898094887	0.472512898094887	false	false	false	true
2e281712-aadb-40c1-a076-d5fd7c32c378	2026-09-04 10:48	2026-09-04 10:48	2026-09-04 10:48	OLLI	OLLI270115P00080000	put	80.0000	2027-01-15	9.5000	9.5000	10.9000	77.0300	15202.00	0.00	15202.00	16	5	37	74	0.5	0.457275174585144	0.457275174585144	false	false	false	true
c78ef505-6d17-401f-9fdb-04fbe47401f4	2026-09-04 10:47	2026-09-04 10:47	2026-09-04 10:47	OLLI	OLLI270115P00080000	put	80.0000	2027-01-15	9.9700	9.4000	11.4000	77.1500	20940.00	0.00	20940.00	21	8	21	74	0.283783783783784	0.454974306761043	0.508932181212445	false	false	false	true
aeb79041-b1d3-43a2-a39b-7b7bbc0abedc	2026-09-03 14:14	2026-09-03 14:14	2026-09-03 14:14	OLLI	OLLI260918P00070000	put	70.0000	2026-09-18	1.2500	1.2500	1.4000	73.8900	25375.00	0.00	25375.00	203	17	263	566	0.464664310954064	0.483370989820084	0.483370989820084	false	false	false	true
1fb31310-b0ee-462a-b12f-cb5b7687ac3c	2026-09-03 13:28	2026-09-03 13:28	2026-09-03 13:28	OLLI	OLLI261016P00070000	put	70.0000	2026-10-16	2.9500	2.9500	3.3000	73.3700	19175.00	0.00	19175.00	65	23	194	399	0.486215538847118	0.466136514337712	0.466136514337712	false	false	false	true
c2183ef2-5619-4a12-adfe-8c543e02a508	2026-09-03 10:26	2026-09-03 10:26	2026-09-03 10:26	OLLI	OLLI261016P00070000	put	70.0000	2026-10-16	3.8000	3.8000	4.4000	71.2100	41420.00	0.00	41420.00	109	33	111	399	0.278195488721804	0.469518810211136	0.469518810211136	false	false	false	true
e158709b-440f-4ac6-a4db-e28d2046da0f	2026-09-02 13:59	2026-09-02 13:59	2026-09-02 13:59	OLLI	OLLI270319C00075000	call	75.0000	2027-03-19	11.4000	10.7000	11.4000	74.3400	14820.00	14820.00	0.00	13	5	81	1	81	0.504508719202887	0.504508719202887	false	false	false	true
915a66ad-0d87-417b-a969-1f6b5cc9dfa6	2026-09-02 11:37	2026-09-02 11:37	2026-09-02 11:37	OLLI	OLLI270115C00075000	call	75.0000	2027-01-15	10.0000	9.8000	10.0000	75.4500	13000.00	7000.00	0.00	13	13	33	171	0.192982456140351	0.510040496772048	0.510040496772048	false	false	false	true
390a2f90-41f4-432e-bb0a-d78b9c0df7ca	2026-09-02 11:33	2026-09-02 11:33	2026-09-02 11:33	OLLI	OLLI270115C00082500	call	82.5000	2027-01-15	6.8000	6.7000	6.8000	75.5700	10880.00	2720.00	0.00	16	16	47	119	0.394957983193277	0.495194765290787	0.495194765290787	false	false	false	true
d314f865-a093-40d2-99cc-6aae73357117	2026-09-02 10:50	2026-09-02 10:49	2026-09-02 10:49	OLLI	OLLI260918C00080000	call	80.0000	2026-09-18	2.1600	1.9500	2.2500	77.5700	108000.00	22000.00	86000.00	500	14	662	3185	0.207849293563579	0.471099045580983	0.489705179502544	false	true	false	true
e351cdc0-1e6c-488c-84da-0d820ec8257b	2026-09-02 10:23	2026-09-02 10:23	2026-09-02 10:23	OLLI	OLLI270115P00085000	put	85.0000	2027-01-15	13.0200	12.5000	14.3000	77.7900	20826.00	0.00	20826.00	16	6	16	67	0.238805970149254	0.500761693930306	0.500761693930306	false	false	false	true
fd46f846-ffa0-4da0-a4e8-23b389e0512a	2026-09-01 15:47	2026-09-01 15:47	2026-09-01 15:47	OLLI	OLLI260918P00070000	put	70.0000	2026-09-18	3.4000	3.0000	3.5000	72.3200	10869.00	10199.00	330.00	32	14	397	370	1.07297297297297	0.739368253620109	0.73873088796869	true	false	false	true
b1edf20a-5be4-4e48-a4e2-0e59574f25b3	2026-09-01 14:44	2026-09-01 14:44	2026-09-01 14:44	OLLI	OLLI260918C00080000	call	80.0000	2026-09-18	2.0000	1.9000	2.0000	72.1600	13800.00	13800.00	0.00	69	12	2339	749	3.12283044058745	0.753434694365397	0.753434694365397	true	false	false	true
f283b2f5-aaf8-4292-b830-69dc80673265	2026-09-01 13:44	2026-09-01 13:44	2026-09-01 13:44	OLLI	OLLI270115P00082500	put	82.5000	2027-01-15	15.2000	15.1000	16.1000	71.8400	15204.00	1520.00	13684.00	10	5	10	25	0.4	0.526447147927006	0.526447147927006	true	false	false	true
541cba8f-f741-432c-82a4-ddbbe0083b3d	2026-09-01 10:31	2026-09-01 10:31	2026-09-01 10:31	OLLI	OLLI260918C00080000	call	80.0000	2026-09-18	2.7500	2.3000	2.7500	75.8500	16225.00	16225.00	0.00	59	19	1469	749	1.96128170894526	0.667822466618088	0.667822466618088	false	false	false	true
3c6648da-e08c-4b68-a42e-faff64bbc418	2026-09-01 10:24	2026-09-01 10:24	2026-09-01 10:24	OLLI	OLLI260918C00080000	call	80.0000	2026-09-18	2.6500	2.0500	2.6500	75.2400	19875.00	19875.00	0.00	75	10	81	749	0.108144192256342	0.689039607233173	0.689039607233173	false	false	false	true
cdc76982-7226-47da-aa77-953187ea1bc2	2026-08-31 15:35	2026-08-31 15:35	2026-08-31 15:35	OLLI	OLLI270115C00082500	call	82.5000	2027-01-15	7.2000	6.9000	7.3000	75.0900	14398.00	13678.00	720.00	20	20	78	98	0.795918367346939	0.526623142391941	0.525093642970126	true	false	false	true
a84e2aa9-1d0d-46be-9a4a-c657dcbf43de	2026-08-28 10:11	2026-08-28 10:11	2026-08-28 10:11	OLLI	OLLI260918C00080000	call	80.0000	2026-09-18	1.4000	0.9500	2.0000	70.9000	51520.00	16660.00	4620.00	368	42	368	390	0.943589743589744	0.645076249678024	0.629681186896353	false	false	false	true
8c37d82c-51ee-4a0c-8178-d38ffc76ab90	2026-08-24 14:42	2026-08-24 14:42	2026-08-24 14:42	OLLI	OLLI261016C00090000	call	90.0000	2026-10-16	1.9000	1.8000	2.0000	76.0850	19380.00	19000.00	380.00	102	17	107	54	1.98148148148148	0.520844238174088	0.520844238174088	false	false	false	true
46f26ad5-d063-49e4-a9c1-eed194b0b219	2026-08-24 10:09	2026-08-24 10:09	2026-08-24 10:09	OLLI	OLLI270115C00075000	call	75.0000	2027-01-15	11.3000	10.5000	11.3000	76.2650	16950.00	16950.00	0.00	15	15	35	149	0.23489932885906	0.536486173229982	0.536486173229982	false	false	false	true
37eae6e2-a418-4650-aa2b-ff7208565b3b	2026-08-24 10:04	2026-08-24 10:04	2026-08-24 10:04	OLLI	OLLI270115C00082500	call	82.5000	2027-01-15	8.2000	7.4000	8.2000	76.1700	15577.00	15577.00	0.00	19	18	43	75	0.573333333333333	0.536939099320161	0.536939099320161	false	false	false	true
36322ae7-3022-4900-ba98-0df786fb3a28	2026-08-24 10:04	2026-08-24 10:04	2026-08-24 10:04	OLLI	OLLI270115C00082500	call	82.5000	2027-01-15	7.8500	7.5500	8.0500	76.1200	12560.00	7050.00	1560.00	16	16	24	75	0.32	0.52249172494581	0.51724570130567	false	false	false	true
f6642692-4f70-4033-a9df-a8572eb47a69	2026-08-20 09:50	2026-08-20 09:49	2026-08-20 09:49	OLLI	OLLI270115C00082500	call	82.5000	2027-01-15	7.7100	6.6000	9.6000	76.8700	57817.00	0.00	57817.00	75	9	75	109	0.688073394495413	0.488690588571533	0.488690588571533	false	false	false	true