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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = BE×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	pricenumeric

3fc2f2d8-5acb-4c79-8a73-02bea3444d5d	2026-09-29 12:15	2026-09-29 12:15	2026-09-29 12:15	BE	BE261016P00290000	put	290.0000	2026-10-16	17.1500	17.1000	17.2000	296.6800	15435.00	13720.00	1715.00	9	6	570	759	0.75098814229249	0.815959629663628	0.815959629663628	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	85781089523.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T16:22:19.511373Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
3daeba01-45d8-45ce-8c6e-c845dee8d8d9	2026-09-29 12:15	2026-09-29 12:15	2026-09-29 12:15	BE	BE261016P00230000	put	230.0000	2026-10-16	1.6900	1.6000	1.6900	296.6800	65403.00	65403.00	0.00	387	41	1888	3479	0.542684679505605	0.842633598179414	0.84186927636167	false	false	false	true	false
21ff80ca-4cc8-4a30-856a-c5fc6eb531fb	2026-09-29 12:16	2026-09-29 12:16	2026-09-29 12:16	BE	BE261016C00265000	call	265.0000	2026-10-16	40.3000	40.0000	40.7000	297.4700	40300.00	0.00	40300.00	10	5	174	628	0.277070063694268	0.81014604398538	0.81014604398538	false	false	false	true	false
82dad919-c232-4a74-8156-bf4deb5e8d99	2026-09-29 12:16	2026-09-29 12:16	2026-09-29 12:16	BE	BE261016C00290000	call	290.0000	2026-10-16	24.9500	24.9500	25.2000	297.7900	14970.00	0.00	14970.00	6	6	983	4508	0.218056787932564	0.81254545879176	0.81254545879176	false	false	false	true	false
e838f75d-deb7-4004-a7da-ee207c72d289	2026-09-29 12:17	2026-09-29 12:17	2026-09-29 12:17	BE	BE261016P00297500	put	297.5000	2026-10-16	20.7000	20.4500	20.7000	297.6300	10350.00	10350.00	0.00	5	5	186	7	26.5714285714286	0.823215744164171	0.823215744164171	false	false	false	true	false
e6346edd-07f6-43ba-b877-1a07ae6e6708	2026-09-29 12:17	2026-09-29 12:17	2026-09-29 12:17	BE	BE261016P00305000	put	305.0000	2026-10-16	24.9400	24.7000	24.9500	297.1600	17455.00	14965.00	2490.00	7	5	215	71	3.02816901408451	0.826047357107003	0.81654398780696	true	false	false	true	false
bf1b1598-7cd9-4ff2-b1ba-78a0d34d6583	2026-09-29 12:18	2026-09-29 12:18	2026-09-29 12:18	BE	BE261016C00320000	call	320.0000	2026-10-16	12.7900	12.6500	12.8000	297.6320	19178.00	19178.00	0.00	15	6	898	2489	0.360787464845319	0.828524942851978	0.828524942851978	false	false	false	true	false
539168fe-001c-4ebf-b9c2-0b5f28828078	2026-09-29 12:28	2026-09-29 12:28	2026-09-29 12:28	BE	BE261009C00300000	call	300.0000	2026-10-09	15.6400	15.2000	16.9000	297.9700	12514.00	0.00	12514.00	8	8	883	718	1.22980501392758	0.836628264422775	0.836628264422775	false	false	false	true	false
30da43b7-f24f-4221-b183-1fc56c6d2d62	2026-09-29 12:28	2026-09-29 12:28	2026-09-29 12:28	BE	BE261002P00290000	put	290.0000	2026-10-02	6.5500	6.5500	6.8000	298.2050	19650.00	0.00	19650.00	30	8	5072	1622	3.12700369913687	0.956225185053307	0.956225185053307	false	false	false	true	false
34b461bf-9df4-423c-bb10-9294f8774f3d	2026-09-29 12:31	2026-09-29 12:31	2026-09-29 12:31	BE	BE261002C00300000	call	300.0000	2026-10-02	9.6200	9.5000	9.7000	298.0000	20202.00	20202.00	0.00	21	5	9238	3991	2.31470809320972	0.970855030242624	0.970855030242624	false	false	false	true	false
af7d65d9-717b-4a78-8cce-cbe29cd84b2e	2026-09-29 12:39	2026-09-29 12:39	2026-09-29 12:39	BE	BE261002C00300000	call	300.0000	2026-10-02	10.0000	9.8000	10.1000	298.0000	14000.00	14000.00	0.00	14	5	9325	3991	2.3365071410674	0.973917163550891	0.973917163550891	false	false	false	true	false
ef0e9f44-1941-44df-a46c-c5771d5fc1e9	2026-09-29 12:40	2026-09-29 12:40	2026-09-29 12:40	BE	BE261016C00297500	call	297.5000	2026-10-16	21.6100	21.6000	21.9500	298.5209	47535.00	0.00	47535.00	22	6	234	84	2.78571428571429	0.814445587575349	0.812486601995062	true	false	false	true	false
e1ad6812-0932-4965-98e6-565d175d0d97	2026-09-29 12:40	2026-09-29 12:40	2026-09-29 12:40	BE	BE261016C00305000	call	305.0000	2026-10-16	18.3400	18.1000	18.6000	298.5209	29350.00	1830.00	27520.00	16	6	522	114	4.57894736842105	0.816767196887129	0.814821279216264	true	false	false	true	false
bcf824f8-e275-43ee-87ec-5551d44d1bef	2026-09-29 12:40	2026-09-29 12:40	2026-09-29 12:40	BE	BE261120C00350000	call	350.0000	2026-11-20	22.8500	22.8500	23.7500	298.5209	2691958.00	6870.00	2685088.00	1178	48	1472	1126	1.30728241563055	0.891900833177216	0.891900833177216	true	false	false	true	false
94825ac5-e7bf-4154-91ff-20046b3391ed	2026-09-29 12:40	2026-09-29 12:40	2026-09-29 12:40	BE	BE261016C00310000	call	310.0000	2026-10-16	16.3500	16.1500	16.6500	298.5209	42511.00	3271.00	37605.00	26	7	1076	2234	0.481647269471799	0.817218058350104	0.817218058350104	false	false	false	true	false
217420dc-064b-4cc5-9688-fdaede64e946	2026-09-29 12:40	2026-09-29 12:40	2026-09-29 12:40	BE	BE261120C00370000	call	370.0000	2026-11-20	18.3500	18.3500	19.3500	298.0700	47710.00	0.00	47710.00	26	8	1638	350	4.68	0.90231288693073	0.90231288693073	true	false	false	true	false
7c2d0df9-807a-4203-b4f2-6fb06b43f8ba	2026-09-29 12:44	2026-09-29 12:44	2026-09-29 12:44	BE	BE261016P00235000	put	235.0000	2026-10-16	2.1500	2.0800	2.1700	296.0000	30074.00	21576.00	8498.00	140	20	769	710	1.0830985915493	0.836992843197522	0.833901257463305	true	false	false	true	false
fe069e17-bfe4-47fd-88a2-95d4d58e631b	2026-09-29 12:55	2026-09-29 12:55	2026-09-29 12:55	BE	BE261120C00350000	call	350.0000	2026-11-20	21.6500	21.6500	22.3500	295.0000	119085.00	2170.00	116915.00	55	11	1547	1126	1.37388987566607	0.890804720012136	0.889623784474938	true	false	false	true	false
10834a02-c4a9-4614-b500-63a0a0ccdde9	2026-09-29 12:56	2026-09-29 12:56	2026-09-29 12:56	BE	BE261016P00305000	put	305.0000	2026-10-16	25.8000	25.7500	25.8500	295.0000	82555.00	72240.00	10315.00	32	14	255	71	3.59154929577465	0.815423693858056	0.815423693858056	false	false	false	true	false
e6595904-f951-4e25-af02-d891ef1d41b0	2026-09-29 13:06	2026-09-29 13:06	2026-09-29 13:06	BE	BE261002P00290000	put	290.0000	2026-10-02	6.7000	6.7000	6.8000	297.6500	10050.00	0.00	10050.00	15	15	5329	1622	3.28545006165228	0.951306147462264	0.951306147462264	false	false	false	true	false
ade79c80-b69e-46bf-b29d-e916d6815116	2026-09-29 13:11	2026-09-29 13:11	2026-09-29 13:11	BE	BE261016P00220000	put	220.0000	2026-10-16	1.0100	0.9600	1.0100	295.8000	19493.00	19493.00	0.00	193	30	1096	2974	0.36852723604573	0.847765264784858	0.847765264784858	false	false	false	true	false
e8649c4d-bfa3-4fb8-956a-4604c7ea256c	2026-09-29 13:12	2026-09-29 13:12	2026-09-29 13:12	BE	BE270115P00180000	put	180.0000	2027-01-15	6.5100	6.4000	7.0500	296.1208	162750.00	0.00	162750.00	250	2	394	1718	0.229336437718277	0.827230298754362	0.827230298754362	false	true	false	true	false
beaf5af0-b401-4103-b569-2e36b0f05032	2026-09-29 13:13	2026-09-29 13:13	2026-09-29 13:13	BE	BE261016P00305000	put	305.0000	2026-10-16	25.7500	25.7000	25.7500	295.3901	72092.00	66950.00	5142.00	28	10	283	71	3.98591549295775	0.813878130730555	0.81135683571143	false	false	false	true	false
9895cab3-8200-47f7-b4a5-aaf119fd8732	2026-09-29 13:13	2026-09-29 13:13	2026-09-29 13:13	BE	BE261016C00272500	call	272.5000	2026-10-16	33.4700	32.5000	33.5000	295.3901	415010.00	154100.00	260910.00	124	16	216	104	2.07692307692308	0.798426874067598	0.804679346199545	true	false	false	true	false
787298cc-5146-4d8c-804e-6b94bd5f2ccf	2026-09-29 13:13	2026-09-29 13:13	2026-09-29 13:13	BE	BE261016C00270000	call	270.0000	2026-10-16	35.1000	35.1000	35.1500	295.3901	287820.00	0.00	287820.00	82	7	966	9162	0.10543549443353	0.802343914343556	0.802343914343556	true	false	false	true	false
71e52666-6d03-4d6b-a2ab-0e3c0bc220d4	2026-09-29 13:26	2026-09-29 13:26	2026-09-29 13:26	BE	BE261016P00270000	put	270.0000	2026-10-16	9.1000	9.1000	9.2000	295.5025	22750.00	0.00	22750.00	25	5	565	1710	0.330409356725146	0.798907240123792	0.798907240123792	false	false	false	true	false
1a370ab5-1c62-48f6-8b14-780edc67c593	2026-09-29 13:38	2026-09-29 13:38	2026-09-29 13:38	BE	BE261002C00290000	call	290.0000	2026-10-02	12.3000	12.2000	12.3000	294.1600	28290.00	28290.00	0.00	23	5	4687	2130	2.20046948356807	0.949775881813992	0.949775881813992	false	false	false	true	false
fd3e36d5-6e21-4b2a-b13a-7de626b8ba1d	2026-09-29 13:41	2026-09-29 13:41	2026-09-29 13:41	BE	BE261218P00330000	put	330.0000	2026-12-18	67.5500	67.5500	68.6500	293.7000	2256184.00	0.00	2256184.00	334	23	337	25	13.48	0.85479106728498	0.85479106728498	false	false	false	true	false
ee27742c-8340-42cf-b636-4f00e9240285	2026-09-29 13:41	2026-09-29 13:41	2026-09-29 13:41	BE	BE261218P00320000	put	320.0000	2026-12-18	60.9000	60.9000	62.2000	293.7000	42630.00	0.00	42630.00	7	7	69	123	0.560975609756098	0.853879228010066	0.853879228010066	false	false	false	true	false
8534fc10-11c9-4d04-87a3-5ad640deb385	2026-09-29 13:54	2026-09-29 13:54	2026-09-29 13:54	BE	BE261016C00280000	call	280.0000	2026-10-16	27.0000	26.9000	27.3000	293.0750	677773.00	0.00	677773.00	251	16	1525	7528	0.202577045696068	0.790121550597131	0.790121550597131	true	false	false	true	false
dcb88d4c-fe66-4bcf-9439-1fc4c96f6962	2026-09-29 13:54	2026-09-29 13:54	2026-09-29 13:54	BE	BE261016C00280000	call	280.0000	2026-10-16	26.8000	26.7500	27.0500	292.7600	514563.00	511888.00	2675.00	192	10	1777	7528	0.236052072263549	0.791892436571535	0.788085975094324	true	false	false	true	false
a7c1b1b2-44c8-4a69-bb80-9c6fd5ca698b	2026-09-29 13:54	2026-09-29 13:54	2026-09-29 13:54	BE	BE261016C00280000	call	280.0000	2026-10-16	26.6800	26.6500	27.0500	292.7600	160075.00	2675.00	157400.00	60	11	1585	7528	0.210547290116897	0.783855119946167	0.785970740483293	true	false	false	true	false
8742f574-1aa0-46b5-8e38-c0a1dc2e018e	2026-09-29 13:56	2026-09-29 13:56	2026-09-29 13:56	BE	BE261016C00270000	call	270.0000	2026-10-16	32.6700	32.6000	32.9500	292.3900	849390.00	176310.00	489750.00	260	24	1233	9162	0.134577603143418	0.789059714478316	0.793713928500126	true	false	false	true	false
9bec3f35-c5f5-4e3d-9704-526381d7a66e	2026-09-29 14:00	2026-09-29 14:00	2026-09-29 14:00	BE	BE261016C00350000	call	350.0000	2026-10-16	4.9000	4.7500	4.9000	292.5600	18620.00	18620.00	0.00	38	5	1503	2157	0.696801112656467	0.833102353759334	0.833102353759334	false	false	false	true	false
af7f3543-8ceb-44cd-89e0-b0fcadf90ea2	2026-09-29 14:00	2026-09-29 14:00	2026-09-29 14:00	BE	BE261016C00320000	call	320.0000	2026-10-16	10.8700	10.6500	10.9000	293.8100	10868.00	7613.00	3255.00	10	8	972	2489	0.390518280433909	0.806590027230129	0.808114457281465	false	false	false	true	false
de692cf8-ef5a-4c6b-8e9e-fe4861045702	2026-09-29 14:06	2026-09-29 14:06	2026-09-29 14:06	BE	BE261002C00350000	call	350.0000	2026-10-02	0.3900	0.3100	0.3900	293.8550	43758.00	43758.00	0.00	1122	46	2909	907	3.20727673649394	1.04523635621587	1.04523635621587	false	false	false	true	false
61112f8d-f973-4ded-82a4-bc93f53173e6	2026-09-29 14:15	2026-09-29 14:15	2026-09-29 14:15	BE	BE261218P00230000	put	230.0000	2026-12-18	15.8500	15.4500	16.4500	293.0000	14263.00	0.00	14263.00	9	5	73	1860	0.039247311827957	0.839730598309577	0.839730598309577	false	false	false	true	false
9f8e12df-de0a-4fdf-be52-92a2f347340d	2026-09-29 14:21	2026-09-29 14:21	2026-09-29 14:21	BE	BE270219P00210000	put	210.0000	2027-02-19	18.2400	17.7500	18.2500	294.0000	56554.00	56554.00	0.00	31	5	133	390	0.341025641025641	0.824505154724702	0.825143334258034	false	false	false	true	false
9c07de2e-0335-4e31-8029-197302b187be	2026-09-29 14:24	2026-09-29 14:24	2026-09-29 14:24	BE	BE281215C00420000	call	420.0000	2028-12-15	119.3000	117.2500	120.1750	294.0000	131225.00	131225.00	0.00	11	5	22	150	0.146666666666667	0.843997969713871	0.843053840933887	false	false	false	true	false
323a5d79-d4ce-4591-aba3-5c8b023ed71b	2026-09-29 14:24	2026-09-29 14:24	2026-09-29 14:24	BE	BE261002C00300000	call	300.0000	2026-10-02	7.9000	7.7000	7.9000	294.0000	78964.00	78964.00	0.00	100	5	10391	3991	2.6036081182661	0.951218460512149	0.948371653961528	false	false	false	true	false
3e0965cc-6ad4-450e-9aec-b20e89aba4e8	2026-09-29 14:25	2026-09-29 14:24	2026-09-29 14:24	BE	BE261002P00262500	put	262.5000	2026-10-02	0.9400	0.8900	0.9400	294.0000	13066.00	13066.00	0.00	139	28	922	530	1.73962264150943	0.944306169869262	0.944306169869262	false	false	false	true	false
f8bdd1fd-ddb2-455d-aed0-2e8d3001da03	2026-09-29 14:26	2026-09-29 14:26	2026-09-29 14:26	BE	BE270115C00320000	call	320.0000	2027-01-15	43.8200	42.0000	44.9500	295.0000	258550.00	61385.00	197165.00	59	16	267	1406	0.189900426742532	0.812599551612386	0.823553664689258	true	false	false	true	false
ead6ae75-45e9-49b0-92e2-2d7260d2ecfe	2026-09-29 14:37	2026-09-29 14:37	2026-09-29 14:37	BE	BE261002P00295000	put	295.0000	2026-10-02	10.3000	10.3000	10.6000	293.0000	103000.00	0.00	103000.00	100	5	3036	221	13.737556561086	0.917421708690786	0.917421708690786	false	false	false	true	false
d110c65e-9516-4d8a-a6f8-bd318f1e9857	2026-09-29 14:44	2026-09-29 14:44	2026-09-29 14:44	BE	BE261002P00247500	put	247.5000	2026-10-02	0.2600	0.2000	0.2600	293.5450	14456.00	14456.00	0.00	556	40	841	902	0.932372505543237	0.987510991171978	0.987510991171978	false	false	false	true	false
2c7dcdab-c3e6-442c-bbff-2b4f0a2fcbac	2026-09-29 14:46	2026-09-29 14:46	2026-09-29 14:46	BE	BE261120P00270000	put	270.0000	2026-11-20	25.3100	24.7500	25.8000	293.3100	12655.00	5065.00	7590.00	5	5	77	424	0.181603773584906	0.865388361267051	0.866632824138408	false	false	false	true	false
233ae1e0-6e35-4203-b8d6-c357fe1117b4	2026-09-29 14:53	2026-09-29 14:53	2026-09-29 14:53	BE	BE261016C00290000	call	290.0000	2026-10-16	21.8700	21.6000	21.9000	293.2950	13120.00	13120.00	0.00	6	5	1054	4508	0.233806566104703	0.795079449282865	0.79307304780008	false	false	false	true	false
ed6a4a6f-afdd-4b12-82ba-fd7df409c2bd	2026-09-29 15:17	2026-09-29 15:17	2026-09-29 15:17	BE	BE261002C00310000	call	310.0000	2026-10-02	4.2000	4.2000	4.3500	293.0100	72303.00	0.00	72303.00	172	36	5113	932	5.48605150214592	0.969623266886684	0.969623266886684	false	false	false	true	false
5f0bb902-bdb3-473d-8ed3-1d1fab27a6d9	2026-09-29 15:24	2026-09-29 15:24	2026-09-29 15:24	BE	BE261002P00275000	put	275.0000	2026-10-02	3.1000	3.0500	3.1500	292.0000	20460.00	0.00	20150.00	66	8	5170	735	7.03401360544218	0.915225422135408	0.915225422135408	false	false	false	true	false
5e733f4d-85fa-4fe5-8fc6-872cc2f4a221	2026-09-29 15:24	2026-09-29 15:24	2026-09-29 15:24	BE	BE261002P00280000	put	280.0000	2026-10-02	4.5000	4.5000	4.5500	292.0000	47705.00	455.00	47250.00	106	6	4131	1337	3.08975317875841	0.917648252095021	0.923204249405453	false	false	false	true	false
56656726-753b-46d1-aa04-1342662398be	2026-09-29 15:24	2026-09-29 15:24	2026-09-29 15:24	BE	BE261002C00285000	call	285.0000	2026-10-02	13.6100	13.6000	13.8000	292.0000	68027.00	0.00	68027.00	50	8	2440	1467	1.66325835037491	0.920111028724236	0.920111028724236	false	false	false	true	false