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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = SFM×

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

6abc7635-36d8-4b99-9708-40a3699fee24	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.2000	1.0000	1.2500	84.8300	22680.00	9840.00	11520.00	189	10	931	1591	0.585166561910748	0.419716243995344	0.419716243995344	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	7001964161.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f3dcb843-eb61-409a-96e7-429c3690c60a	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.1500	1.0500	1.2000	84.4600	23460.00	11270.00	4715.00	204	7	308	1591	0.193588937774984	0.421487605774762	0.421487605774762	true	false	false	true
dfa08adc-580c-4775-ba10-f1991ff5cadd	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.2000	0.8500	1.2000	84.7900	45720.00	18120.00	0.00	381	8	690	1591	0.433689503456945	0.420568716736448	0.420568716736448	false	false	false	true
ddb5625f-90ac-4f28-bbac-58819590371c	2026-08-25 12:27	2026-08-25 12:27	2026-08-25 12:27	SFM	SFM270319C00080000	call	80.0000	2027-03-19	15.5000	15.5000	16.0000	85.1900	40305.00	0.00	40305.00	26	9	29	151	0.19205298013245	0.479565572957149	0.479992969946601	false	false	false	true
acc42456-241a-4a8d-b7d9-bb4ff5774efe	2026-08-24 15:56	2026-08-24 15:56	2026-08-24 15:56	SFM	SFM260918C00090000	call	90.0000	2026-09-18	2.1200	2.1000	2.2500	85.7850	37090.00	14405.00	22685.00	175	21	514	1004	0.51195219123506	0.416515286857804	0.416515286857804	false	false	false	true
6b7d833d-6fef-41b9-af47-9dbb7043149c	2026-08-24 14:04	2026-08-24 14:03	2026-08-24 14:03	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.0500	0.9000	1.1500	84.3500	52466.00	27686.00	24780.00	500	24	1511	48	31.4791666666667	0.405916335436696	0.40718375986437	false	false	false	true
d348d53a-51f3-4a14-b389-90b80b7dfaee	2026-08-21 11:08	2026-08-21 11:08	2026-08-21 11:08	SFM	SFM270319P00055000	put	55.0000	2027-03-19	1.9500	1.6500	1.9500	80.5900	39000.00	39000.00	0.00	200	20	201	8	25.125	0.513073793766157	0.513073793766157	false	false	false	true
ec473504-e914-40de-9d32-211f53656edf	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	SFM	SFM270115C00075000	call	75.0000	2027-01-15	11.9000	11.6000	12.7000	79.3500	121380.00	20230.00	101150.00	102	5	103	281	0.366548042704626	0.458835998061548	0.458835998061548	false	false	false	true
a153782e-131b-4c0a-8d96-148a1bf3b524	2026-08-18 15:45	2026-08-18 15:45	2026-08-18 15:45	SFM	SFM270319C00095000	call	95.0000	2027-03-19	5.7000	5.7000	6.7000	78.5750	11404.00	0.00	11404.00	20	5	30	110	0.272727272727273	0.441838413434803	0.440957876366472	false	false	false	true
f2abb7ee-60bc-4f39-b2aa-920aca0fd01a	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	SFM	SFM270115C00100000	call	100.0000	2027-01-15	3.3000	2.9000	3.3000	79.5400	41910.00	41910.00	0.00	127	10	652	1542	0.422827496757458	0.444035458416734	0.444035458416734	false	false	false	true
8e4b7fc7-0c79-4b40-99f7-bf4f33097243	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	SFM	SFM261218C00090000	call	90.0000	2026-12-18	4.7000	4.7000	5.2000	79.5750	96362.00	0.00	96362.00	205	31	653	140	4.66428571428571	0.442428922887098	0.441288196626306	false	false	false	true
f4d6add9-1dcf-4b1c-8859-81c2b0db55fa	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	SFM	SFM270115C00100000	call	100.0000	2027-01-15	3.3000	2.9000	3.3000	79.6500	20790.00	20790.00	0.00	63	6	525	1542	0.340466926070039	0.442265706887252	0.442265706887252	false	false	false	true
6d9b8018-f6a0-43ea-8c05-c01a9aa6dffd	2026-08-18 11:54	2026-08-18 11:54	2026-08-18 11:54	SFM	SFM270115C00100000	call	100.0000	2027-01-15	3.3000	2.9000	3.3000	79.5200	99000.00	99000.00	0.00	300	37	408	1542	0.264591439688716	0.444357340784861	0.444357340784861	false	false	false	true
2f281bd0-6d0d-43ba-b10d-bc7049765aed	2026-08-18 11:26	2026-08-18 11:26	2026-08-18 11:26	SFM	SFM260918C00085000	call	85.0000	2026-09-18	1.9000	1.7500	1.9000	79.7300	150647.00	150647.00	0.00	793	50	794	1373	0.578295702840495	0.408206130411858	0.408206130411858	false	false	false	true
d2c3fcdc-3467-424e-9ad9-cd42ae5da903	2026-08-18 10:05	2026-08-18 10:05	2026-08-18 10:05	SFM	SFM261218P00080000	put	80.0000	2026-12-18	7.6000	7.6000	8.2000	80.1150	41806.00	0.00	41806.00	55	23	61	158	0.386075949367089	0.446568419708446	0.446568419708446	false	false	false	true
9a59504f-76d9-434e-9941-cb78ad30002f	2026-08-17 13:06	2026-08-17 13:06	2026-08-17 13:06	SFM	SFM261218P00080000	put	80.0000	2026-12-18	7.7000	7.7000	7.9000	80.5900	10010.00	0.00	3850.00	13	13	60	109	0.55045871559633	0.461445066412561	0.461445066412561	false	false	false	true
10596db0-4784-4038-a80e-6fb3c9a543eb	2026-08-17 13:06	2026-08-17 13:06	2026-08-17 13:06	SFM	SFM261218P00080000	put	80.0000	2026-12-18	7.7000	7.4000	7.7000	80.6650	10010.00	10010.00	0.00	13	13	47	109	0.431192660550459	0.463153069308287	0.463153069308287	false	false	false	true
2d416834-aced-48c4-a07f-0abfc6f9c4b0	2026-08-17 13:06	2026-08-17 13:06	2026-08-17 13:06	SFM	SFM261218P00080000	put	80.0000	2026-12-18	7.7000	7.5000	7.8000	80.6650	10010.00	1540.00	2310.00	13	13	34	109	0.311926605504587	0.463153069308287	0.463153069308287	false	false	false	true
7ca67b67-5180-48b2-9972-5b7136f960cc	2026-08-17 13:06	2026-08-17 13:06	2026-08-17 13:06	SFM	SFM261218P00080000	put	80.0000	2026-12-18	7.7000	7.5000	7.8000	80.6750	10010.00	770.00	2310.00	13	13	21	109	0.192660550458716	0.463380340414018	0.463380340414018	false	false	false	true