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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Consumer Defensive×ticker = BJ×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

2202262b-ad90-48da-8672-e1fdb982879a	2026-08-18 13:46	2026-08-18 13:46	2026-08-18 13:46	BJ	BJ260821P00095000	put	95.0000	2026-08-21	3.1500	2.8500	3.6000	93.7400	236250.00	0.00	236250.00	750	2	751	1004	0.74800796812749	0.728758247695355	0.728758247695355	false	true	true	false	false	LowHistoricVolumeFloor	b356ec2b-92e1-458a-934a-7719f71c40bc	2	Common Stock	Consumer Defensive	12039053295.00	2026-11-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b32d65e7-7faa-48f0-ada4-98e10aab0a87	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	BJ	BJ260821C00100000	call	100.0000	2026-08-21	1.1500	0.9000	1.2000	94.9650	19780.00	14490.00	345.00	172	28	452	252	1.79365079365079	1.04872658025146	1.04872658025146	false	false	false	true
969149f3-eea6-48f9-852b-2d38fc91be79	2026-08-19 10:57	2026-08-19 10:57	2026-08-19 10:57	BJ	BJ260821P00095000	put	95.0000	2026-08-21	2.8600	2.8500	3.1000	95.0500	143410.00	9735.00	15115.00	502	18	535	974	0.549281314168378	1.06400225580107	1.06400225580107	false	false	false	true
68ecf5c0-ab1a-4e6b-bd67-2373b42d2da5	2026-08-19 10:57	2026-08-19 10:57	2026-08-19 10:57	BJ	BJ260821C00095000	call	95.0000	2026-08-21	3.0000	2.9500	3.1000	95.0500	15300.00	15000.00	300.00	51	13	100	167	0.598802395209581	1.05698464091124	1.05698464091124	false	false	false	true
e32b0280-d644-437c-873c-106292fdd529	2026-08-19 14:41	2026-08-19 14:41	2026-08-19 14:41	BJ	BJ260918P00090000	put	90.0000	2026-09-18	2.2500	1.5500	2.4000	94.0800	56125.00	56125.00	0.00	250	14	253	342	0.739766081871345	0.386819145984536	0.386819145984536	false	false	false	true
ee6c0772-c16b-4e9b-b368-8cc126db14be	2026-08-19 14:42	2026-08-19 14:42	2026-08-19 14:42	BJ	BJ260821P00090000	put	90.0000	2026-08-21	1.3500	1.2500	1.5500	93.9900	13760.00	13365.00	260.00	102	13	138	390	0.353846153846154	1.08405751787503	1.07839735954492	false	false	false	true
34584822-3b1e-42cd-950f-56dafd857c4b	2026-08-20 15:56	2026-08-20 15:56	2026-08-20 15:56	BJ	BJ261120P00080000	put	80.0000	2026-11-20	1.9200	1.6000	2.2000	91.3850	49264.00	49264.00	0.00	256	22	297	93	3.19354838709677	0.373854620940338	0.373854620940338	false	false	false	true
e4c628f9-b502-4548-bfce-31117c26ae1c	2026-08-20 15:57	2026-08-20 15:57	2026-08-20 15:57	BJ	BJ261120P00080000	put	80.0000	2026-11-20	1.9000	1.7500	2.6500	91.2200	38000.00	0.00	38000.00	200	9	497	93	5.34408602150538	0.359408311259601	0.359408311259601	false	false	false	true
c95d089b-1721-4a97-8d44-b842b3f2479c	2026-08-21 12:13	2026-08-21 12:13	2026-08-21 12:13	BJ	BJ261120P00095000	put	95.0000	2026-11-20	5.1000	5.1000	5.5000	95.6895	28050.00	0.00	28050.00	55	13	55	86	0.63953488372093	0.310728019075985	0.310728019075985	false	false	false	true
6a1a5ed9-aa84-4787-bcb2-9889aef205a9	2026-08-21 12:14	2026-08-21 12:13	2026-08-21 12:13	BJ	BJ261120C00095000	call	95.0000	2026-11-20	7.0000	5.8000	8.6000	96.0000	14700.00	8400.00	6300.00	21	7	22	35	0.628571428571429	0.322056379280311	0.316949959769328	false	false	false	true
1a13a5af-d131-4ccb-b4a2-ac114af6ebaa	2026-08-24 11:30	2026-08-24 11:29	2026-08-24 11:29	BJ	BJ260918C00105000	call	105.0000	2026-09-18	1.1000	0.9000	1.3000	99.9250	37180.00	33440.00	3740.00	338	23	395	211	1.87203791469194	0.270419025976674	0.270419025976674	false	false	false	true
ad14afa6-b187-46a2-bc50-ed84345e932c	2026-08-26 11:15	2026-08-26 11:15	2026-08-26 11:15	BJ	BJ260918P00090000	put	90.0000	2026-09-18	1.1500	0.9500	1.2500	93.3100	55545.00	50830.00	4715.00	483	14	486	371	1.3099730458221	0.276219531371925	0.276219531371925	false	false	false	true
9be4700c-b66d-40f6-bd70-d443c52cd514	2026-08-26 11:18	2026-08-26 11:17	2026-08-26 11:17	BJ	BJ260918P00090000	put	90.0000	2026-09-18	1.2000	1.2000	1.2500	93.1000	15720.00	0.00	15720.00	131	5	676	371	1.82210242587601	0.275035438988127	0.275035438988127	false	false	false	true
1657371e-af23-4377-ab9f-47af1585174a	2026-08-27 15:14	2026-08-27 15:14	2026-08-27 15:14	BJ	BJ261120C00095000	call	95.0000	2026-11-20	3.7000	3.7000	4.3000	90.0000	14062.00	0.00	14062.00	38	12	39	52	0.75	0.298334707019016	0.298334707019016	false	false	false	true
fdf8bf39-e7a4-43a5-9635-50490c94c8ba	2026-08-31 13:43	2026-08-31 13:43	2026-08-31 13:43	BJ	BJ260918C00095000	call	95.0000	2026-09-18	0.8000	0.6000	0.8000	90.6400	26270.00	25520.00	750.00	329	26	413	386	1.0699481865285	0.281750571676431	0.281750571676431	true	false	false	true
cbff35e5-2da0-4a5a-838a-9cf0fc08b20d	2026-09-01 10:19	2026-09-01 10:19	2026-09-01 10:19	BJ	BJ280121C00090000	call	90.0000	2028-01-21	18.0000	16.6000	18.9000	91.9150	54000.00	54000.00	0.00	30	5	30	98	0.306122448979592	0.342509777352946	0.342509777352946	false	false	false	true
b38e38ae-299c-44da-a72a-ef81d09b321d	2026-09-11 13:18	2026-09-11 13:18	2026-09-11 13:18	BJ	BJ261016C00095000	call	95.0000	2026-10-16	1.8000	1.5500	1.8000	91.3700	12780.00	12780.00	0.00	71	19	88	130	0.676923076923077	0.276711804738918	0.276711804738918	false	false	false	true
085ff872-78ea-46b7-8ad5-3eb2d2286758	2026-09-15 14:08	2026-09-15 14:08	2026-09-15 14:08	BJ	BJ260918C00090000	call	90.0000	2026-09-18	6.0000	6.0000	6.3000	95.9300	42000.00	0.00	24000.00	70	7	70	158	0.443037974683544	0.382980764356347	0.382980764356347	false	false	false	true