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:alert_rule = RepeatedHitsAscendingFill×ticker = BE×

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

0a5c2b1b-5cba-47aa-87ea-d64d65949b2a	2026-09-21 10:43	2026-09-21 10:43	2026-09-21 10:43	BE	BE260925C00280000	call	280.0000	2026-09-25	7.5000	7.2500	7.5000	273.0000	39725.00	39725.00	0.00	53	11	1125	2571	0.43757292882147	0.891820073816304	0.896282443329913	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Industrials	80373567450.00	2026-10-27	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T14:45:07.990945Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
9add4734-5445-4a6f-bc05-b95b2364b777	2026-09-21 10:13	2026-09-21 10:13	2026-09-21 10:13	BE	BE260925C00285000	call	285.0000	2026-09-25	3.4900	3.4500	3.5500	266.2600	11173.00	0.00	3473.00	32	9	339	786	0.431297709923664	0.884401985766878	0.88327992962158	false	false	false	true
ca0f2df7-ebe7-436f-b97d-98b7f7ea325f	2026-09-21 10:11	2026-09-21 10:11	2026-09-21 10:11	BE	BE261016P00247500	put	247.5000	2026-10-16	12.0100	11.7000	12.1000	267.0000	15615.00	12010.00	3605.00	13	10	16	0	0	0.771141141342466	0.77316689836992	true	false	false	true
0cf61b27-1f5d-4d5c-a9ea-45ba6cabf465	2026-09-21 10:11	2026-09-21 10:11	2026-09-21 10:11	BE	BE261016P00265000	put	265.0000	2026-10-16	19.9300	19.6500	20.0500	267.0000	11959.00	9964.00	1995.00	6	6	54	0	0	0.772077810397148	0.773891655439577	true	false	false	true
412b12e3-d8c2-46d8-b350-1c23e499ebaf	2026-09-21 10:06	2026-09-21 10:06	2026-09-21 10:06	BE	BE260925P00275000	put	275.0000	2026-09-25	14.4500	14.4000	14.5500	266.6900	14445.00	13005.00	1440.00	10	6	213	363	0.586776859504132	0.863672708690163	0.868352455134089	false	false	false	true
c84f8e2d-873b-48f5-81ec-e46f2eaf07d7	2026-09-21 09:56	2026-09-21 09:56	2026-09-21 09:56	BE	BE261002C00310000	call	310.0000	2026-10-02	3.1400	3.0500	4.3000	267.2750	21042.00	0.00	21042.00	67	5	75	194	0.38659793814433	0.803910042563393	0.82551624348084	true	false	false	true
7fae4268-33e6-4528-ade4-67c925fce493	2026-09-21 09:54	2026-09-21 09:54	2026-09-21 09:54	BE	BE260925C00262500	call	262.5000	2026-09-25	12.6000	12.1000	12.6000	267.5400	20156.00	20156.00	0.00	16	10	33	178	0.185393258426966	0.885778547629709	0.886703364935364	false	false	false	true
b840a293-720a-47d3-a5c0-60b92cf1def3	2026-09-21 09:52	2026-09-21 09:52	2026-09-21 09:52	BE	BE261016C00280000	call	280.0000	2026-10-16	17.3800	17.1000	17.7000	269.2300	889868.00	520260.00	369608.00	512	12	971	9037	0.107447161668695	0.763661936114131	0.768798848041734	true	false	false	true
359a4b77-721f-4fd9-993c-7f148764ba23	2026-09-21 09:41	2026-09-21 09:41	2026-09-21 09:41	BE	BE261016C00240000	call	240.0000	2026-10-16	39.1600	38.5000	39.4500	269.2125	101803.00	54825.00	46978.00	26	10	48	1174	0.0408858603066439	0.790435526927215	0.791368691982225	true	false	false	true
4e2d08b4-ae77-4fd8-9c57-fb635db39bec	2026-09-18 15:56	2026-09-18 15:56	2026-09-18 15:56	BE	BE260925P00260000	put	260.0000	2026-09-25	7.5000	7.5000	8.3000	267.0000	58515.00	760.00	57755.00	78	10	3262	1953	1.67025089605735	0.728190765293221	0.747957202517715	false	false	false	true
ce520758-1d85-4f60-9d7e-0a6b8fe6f200	2026-09-18 15:41	2026-09-18 15:40	2026-09-18 15:40	BE	BE260918C00262500	call	262.5000	2026-09-18	8.0200	6.4000	9.4500	270.1450	120235.00	49650.00	70585.00	150	12	671	1714	0.391481913652275	3.96150146828138	4.26712794264582	false	false	false	true
14bbbf8a-4bca-4a34-83fb-91d58a2aa38b	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	BE	BE260918C00272500	call	272.5000	2026-09-18	1.6800	1.6500	1.6800	268.8950	76701.00	72576.00	4125.00	457	19	2179	474	4.59704641350211	4.65429736056187	4.65429736056187	false	false	false	true
1e66db5d-d3dd-4111-bebf-9178b674cb69	2026-09-18 15:14	2026-09-18 15:14	2026-09-18 15:14	BE	BE280121C00280000	call	280.0000	2028-01-21	106.8200	104.7500	106.8500	271.1150	192285.00	192285.00	0.00	18	10	23	159	0.144654088050314	0.871082314945956	0.867498196111677	true	false	false	true
a27e3df6-5eb9-4c8f-9b10-a6283aa954ee	2026-09-18 11:11	2026-09-18 11:11	2026-09-18 11:11	BE	BE260918C00275000	call	275.0000	2026-09-18	1.5000	1.5000	1.8200	270.1300	96605.00	154.00	96451.00	644	33	1804	7755	0.232624113475177	1.3318197796852	1.3502807014506	true	false	false	true
61699909-901b-4009-a64c-6d9aab48164e	2026-09-18 10:55	2026-09-18 10:55	2026-09-18 10:55	BE	BE270115C00400000	call	400.0000	2027-01-15	18.4000	18.4000	19.3500	271.1650	2546589.00	0.00	2546589.00	1384	56	1387	1147	1.20924149956408	0.825917503906224	0.825917503906224	false	false	false	true
e0f68be5-fa3d-44ec-8f56-6c40ff7c3b55	2026-09-18 10:36	2026-09-18 10:36	2026-09-18 10:36	BE	BE261016C00270000	call	270.0000	2026-10-16	24.2600	23.8000	24.4500	271.5300	320270.00	89630.00	230640.00	132	8	524	7648	0.0685146443514644	0.771005254024042	0.774950537495311	false	false	false	true
b611c908-b8f4-44b0-b035-9b963b02f54c	2026-09-18 09:37	2026-09-18 09:37	2026-09-18 09:37	BE	BE260918C00265000	call	265.0000	2026-09-18	12.2900	12.2500	15.3500	277.6050	245770.00	0.00	115390.00	200	6	230	1508	0.152519893899204	2.53245545566581	0	false	false	false	true
9e61d500-46c4-4788-af4d-ac4455fa5d08	2026-09-17 15:12	2026-09-17 15:12	2026-09-17 15:12	BE	BE261016C00270000	call	270.0000	2026-10-16	30.0500	29.2500	30.0500	280.2700	81130.00	81130.00	0.00	27	9	425	7722	0.055037555037555	0.780321572024835	0.781977754112658	true	false	false	true
2339d0de-69be-4d19-ae96-50b2ea0aa7a4	2026-09-17 13:57	2026-09-17 13:57	2026-09-17 13:57	BE	BE260918C00285000	call	285.0000	2026-09-18	4.0000	4.0000	4.1500	281.4901	135604.00	0.00	135604.00	339	40	2836	1609	1.76258545680547	0.931489638196721	0.941548109806346	false	false	false	true
4e250229-af47-43df-ad1d-85d0e4645ae1	2026-09-17 13:46	2026-09-17 13:45	2026-09-17 13:45	BE	BE260918C00280000	call	280.0000	2026-09-18	5.7000	5.7000	5.8500	280.2675	173853.00	0.00	173853.00	305	39	3872	8654	0.447423156921655	0.949007320509877	0.949007320509877	false	false	false	true
12ad5a2a-95ce-421f-b6fb-99ccb7df0948	2026-09-17 11:49	2026-09-17 11:49	2026-09-17 11:49	BE	BE261016C00370000	call	370.0000	2026-10-16	4.5500	4.5500	4.7000	281.1000	187976.00	0.00	187976.00	413	44	459	1064	0.431390977443609	0.829917753240799	0.83007945244173	false	false	false	true
bc16553e-487f-422a-9be8-2d11962859b3	2026-09-17 11:43	2026-09-17 11:43	2026-09-17 11:43	BE	BE260918C00282500	call	282.5000	2026-09-18	5.3500	5.3500	5.5500	280.5650	152489.00	0.00	152489.00	285	39	709	511	1.38747553816047	1.06447659636759	1.06447659636759	false	false	false	true
5959646f-d8b0-4d84-9915-db7e9d984b9c	2026-09-17 10:37	2026-09-17 10:36	2026-09-17 10:36	BE	BE260925C00270000	call	270.0000	2026-09-25	19.0300	18.3000	19.9500	280.3179	83720.00	1900.00	81820.00	44	10	171	698	0.244985673352436	0.820200607017552	0.803969689611134	false	false	false	true
8961b6ba-6d94-4469-bf47-bddad7b5538b	2026-09-17 10:31	2026-09-17 10:31	2026-09-17 10:31	BE	BE261016C00280000	call	280.0000	2026-10-16	24.8000	24.5000	25.1000	278.6000	748950.00	2475.00	746475.00	302	24	1865	9938	0.18766351378547	0.797025861833554	0.799807167016464	true	false	false	true
09047a9f-4816-48df-89e7-3c9f7862eb32	2026-09-17 10:13	2026-09-17 10:13	2026-09-17 10:13	BE	BE261016P00290000	put	290.0000	2026-10-16	31.6700	31.5500	31.7000	277.6075	231225.00	228060.00	3165.00	73	7	127	686	0.185131195335277	0.801272732126118	0.801272732126118	false	false	false	true
a95aa884-8a53-4412-9c6c-4ddec45461bf	2026-09-17 10:06	2026-09-17 10:06	2026-09-17 10:06	BE	BE260925P00260000	put	260.0000	2026-09-25	5.7500	5.4000	6.0000	279.2200	57460.00	57460.00	0.00	100	12	710	631	1.12519809825674	0.833666585925963	0.833666585925963	false	false	false	true
ab6e3815-c5f7-44a5-a81d-50f639d02344	2026-09-17 10:00	2026-09-17 10:00	2026-09-17 10:00	BE	BE261016C00280000	call	280.0000	2026-10-16	26.7600	26.5500	27.0500	282.2500	125776.00	8035.00	117741.00	47	14	1516	9938	0.152545783859932	0.79924233710068	0.79924233710068	true	false	false	true
08d2318c-d5b6-4fb7-ae2b-d755582ab1d4	2026-09-17 09:57	2026-09-17 09:56	2026-09-17 09:56	BE	BE261016P00270000	put	270.0000	2026-10-16	18.3800	18.2000	18.4500	282.8500	62480.00	62480.00	0.00	34	11	65	1212	0.0536303630363036	0.794590350134768	0.795331375920607	true	false	false	true
da3b8df4-ae9f-4c7a-acc6-9d36e11e1767	2026-09-17 09:40	2026-09-17 09:39	2026-09-17 09:39	BE	BE260918C00280000	call	280.0000	2026-09-18	7.1800	7.1000	7.6000	280.5250	73995.00	0.00	57505.00	103	10	609	8654	0.0703720822740929	1.16549073555879	1.17404325216903	true	false	false	true
c9b731f5-f9cd-4f04-aa73-399da8f8a7f3	2026-09-17 09:39	2026-09-17 09:39	2026-09-17 09:39	BE	BE260918C00275000	call	275.0000	2026-09-18	10.2900	9.7500	10.3000	280.9700	54545.00	53540.00	1005.00	53	6	913	8059	0.113289490011168	1.19383798848091	1.18712653786991	true	false	false	true
505761f1-da46-4aca-a413-12fcca8098ad	2026-09-17 09:37	2026-09-17 09:37	2026-09-17 09:37	BE	BE261016C00280000	call	280.0000	2026-10-16	27.6600	27.5000	28.1000	284.1000	168730.00	83030.00	85700.00	61	8	578	9938	0.0581605956932984	0.792491187967715	0.789545320460809	false	false	false	true
6f358e9d-4d12-450f-bdf0-742c0a4d0630	2026-09-17 09:37	2026-09-17 09:37	2026-09-17 09:37	BE	BE260918C00270000	call	270.0000	2026-09-18	16.7700	16.7000	17.4500	284.5851	167736.00	35196.00	132540.00	100	9	245	5570	0.0439856373429084	1.24744903889583	1.25700378441967	false	false	false	true
3a230d57-411e-4a79-ba41-c48533c16fd4	2026-09-17 09:37	2026-09-17 09:37	2026-09-17 09:37	BE	BE260918P00285000	put	285.0000	2026-09-18	7.4900	7.2000	7.5500	284.6400	74878.00	74878.00	0.00	100	7	159	40	3.975	1.22828239950465	1.22828239950465	false	false	false	true
a1567d37-0dd6-43c5-8219-a807f0172ed6	2026-09-17 09:35	2026-09-17 09:35	2026-09-17 09:35	BE	BE260918C00275000	call	275.0000	2026-09-18	14.5300	14.4000	14.7500	286.1349	159800.00	130950.00	28850.00	110	7	429	8059	0.0532324109691029	1.28745474931577	1.31783784646782	false	false	false	true
eab167fe-25a0-4cd5-8938-bc8470628835	2026-09-17 09:35	2026-09-17 09:35	2026-09-17 09:35	BE	BE260918C00275000	call	275.0000	2026-09-18	14.5200	14.5000	15.0000	286.4800	145202.00	0.00	145202.00	100	10	309	8059	0.0383422260826405	1.25562147492646	1.25562147492646	false	false	false	true
ddac6045-6880-45f0-aba6-74ba282ada8b	2026-09-17 09:30	2026-09-17 09:30	2026-09-17 09:30	BE	BE260925C00270000	call	270.0000	2026-09-25	22.6800	20.8000	23.0000	284.3280	54420.00	27300.00	27120.00	24	7	57	698	0.0816618911174785	0.865066739230045	0.875054226872034	false	false	false	true
fd19bcd5-f554-40db-bc32-a8bafc3115cd	2026-09-16 15:26	2026-09-16 15:26	2026-09-16 15:26	BE	BE260918C00280000	call	280.0000	2026-09-18	2.2500	2.2300	2.3600	262.7800	112565.00	464.00	112101.00	500	33	4392	8376	0.524355300859599	1.00792671540861	1.02338982604307	true	false	false	true
b2d96d4a-8457-40e4-a077-0ccb92eb5a48	2026-09-16 15:26	2026-09-16 15:26	2026-09-16 15:26	BE	BE260918C00295000	call	295.0000	2026-09-18	0.5600	0.5400	0.7300	262.8000	87842.00	5394.00	45213.00	1577	36	3815	1463	2.60765550239234	1.00598645733829	1.03630704965337	true	false	false	true
a0600dae-78b6-4aa7-aee2-64b18daaf9a6	2026-09-16 14:49	2026-09-16 14:49	2026-09-16 14:49	BE	BE260925C00267500	call	267.5000	2026-09-25	13.6000	13.1500	13.7500	266.6100	106101.00	6800.00	99301.00	78	17	359	54	6.64814814814815	0.832957925968779	0.832646941422196	false	false	false	true
5e1d1209-81be-421e-bcec-8cab915a9ad9	2026-09-16 14:49	2026-09-16 14:49	2026-09-16 14:49	BE	BE260925C00270000	call	270.0000	2026-09-25	12.5300	12.5000	12.6500	266.6100	110246.00	16445.00	93801.00	88	21	756	633	1.19431279620853	0.834764033861699	0.834470219544626	false	false	false	true
04d8ede4-2b2d-40ac-bfdc-cfa4f1e85d2b	2026-09-16 14:49	2026-09-16 14:49	2026-09-16 14:49	BE	BE260925C00265000	call	265.0000	2026-09-25	14.7500	14.7500	14.9000	266.6100	175555.00	2980.00	172575.00	119	19	315	262	1.20229007633588	0.829878214984108	0.829548172162496	false	false	false	true
c5511acd-5efc-47b3-be5f-3d2615896ae0	2026-09-16 13:09	2026-09-16 13:08	2026-09-16 13:08	BE	BE261016C00280000	call	280.0000	2026-10-16	21.1000	21.0000	21.7500	270.1110	65425.00	8455.00	56970.00	31	13	886	9310	0.0951664876476907	0.806553388335907	0.808692550320563	true	false	false	true
4fd51a42-97da-4fc8-8a95-a638b59d550e	2026-09-16 10:39	2026-09-16 10:39	2026-09-16 10:39	BE	BE270219P00240000	put	240.0000	2027-02-19	41.1100	41.0000	42.6000	267.3862	65780.00	24720.00	41060.00	16	5	16	200	0.08	0.856228755805272	0.859486471858131	true	false	false	true
ff42bbce-542e-4003-98c6-c68e44fb02aa	2026-09-16 09:39	2026-09-16 09:38	2026-09-16 09:38	BE	BE261002C00270000	call	270.0000	2026-10-02	18.7900	18.6500	18.8500	270.0700	388955.00	110841.00	233114.00	207	21	4252	1804	2.3569844789357	0.821106955535426	0.821106955535426	true	false	false	true
7c6fa81b-a850-444a-ac21-7406f9d1a2e3	2026-09-16 09:35	2026-09-16 09:35	2026-09-16 09:35	BE	BE261120C00270000	call	270.0000	2026-11-20	39.5900	37.6000	40.5500	267.0000	130635.00	130635.00	0.00	33	9	35	682	0.0513196480938416	0.893952495518078	0.893952495518078	false	false	false	true
5e108962-7e0e-4959-947f-82f309d1d4dd	2026-09-15 14:57	2026-09-15 14:56	2026-09-15 14:56	BE	BE270219P00200000	put	200.0000	2027-02-19	24.6800	24.2000	24.7500	258.9200	98736.00	98736.00	0.00	40	7	96	1578	0.0608365019011407	0.848068493026097	0.848068493026097	false	false	false	true
e91c404a-e504-49c5-abb3-a1a42aea8726	2026-09-15 14:28	2026-09-15 14:28	2026-09-15 14:28	BE	BE261016P00270000	put	270.0000	2026-10-16	29.5800	29.5000	29.6500	259.6050	73947.00	29645.00	44302.00	25	8	224	1120	0.2	0.799302356457523	0.803280812958673	false	false	false	true
7b48e905-0975-4942-81d5-5a2d843ff4de	2026-09-15 13:33	2026-09-15 13:33	2026-09-15 13:33	BE	BE270115P00260000	put	260.0000	2027-01-15	46.9000	46.9000	47.4000	262.2200	328309.00	0.00	328309.00	70	22	75	1296	0.0578703703703704	0.835341480482392	0.835341480482392	false	false	false	true
32a19e13-896a-40e8-8d4a-68b50fa99737	2026-09-15 10:33	2026-09-15 10:33	2026-09-15 10:33	BE	BE260918P00255000	put	255.0000	2026-09-18	4.6900	4.6500	4.7000	265.9500	103086.00	73320.00	29766.00	220	29	482	902	0.534368070953437	0.974193317467296	0.969195974335967	false	false	false	true
e79a4790-8182-4c4c-94e1-37eb4e014390	2026-09-15 09:36	2026-09-15 09:35	2026-09-15 09:35	BE	BE260918C00265000	call	265.0000	2026-09-18	10.3100	10.0000	10.4500	266.7900	71155.00	58795.00	12360.00	69	15	188	753	0.249667994687915	0.972798355354829	0.976083754649916	false	false	false	true