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:alert_rule = RepeatedHits×ticker = BNO×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

47ea7597-0be3-4114-acf7-02bc46cd30cb	2026-08-17 09:33	2026-08-17 09:33	2026-08-17 09:33	BNO	BNO270115C00060000	call	60.0000	2027-01-15	3.7000	3.3000	3.7000	50.9200	37000.00	37000.00	0.00	100	7	110	27917	0.00394025145968406	0.500839490686281	0.500839490686281	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	Financial Services	215640000.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b0d17cbf-60d9-4843-b224-bb82975a1728	2026-08-17 12:35	2026-08-17 12:35	2026-08-17 12:35	BNO	BNO260904P00055000	put	55.0000	2026-09-04	5.0000	5.0000	5.5000	50.9400	23000.00	0.00	23000.00	46	5	68	180	0.377777777777778	0.543898972282895	0.543898972282895	false	false	false	true
c10a5f88-c81c-4c91-aa72-65f8ca14457b	2026-08-17 13:04	2026-08-17 13:04	2026-08-17 13:04	BNO	BNO260821C00052500	call	52.5000	2026-08-21	0.7000	0.6500	0.7000	51.1300	34440.00	34440.00	0.00	492	7	588	1800	0.326666666666667	0.583025828650931	0.583025828650931	false	false	false	true
8baa273a-7a89-489a-a03f-7e4ddaa52a58	2026-08-17 13:29	2026-08-17 13:29	2026-08-17 13:29	BNO	BNO261016C00085000	call	85.0000	2026-10-16	0.4000	0.3000	0.4000	51.7050	10400.00	10400.00	0.00	260	12	410	11142	0.0367977023873631	0.732824428896658	0.732824428896658	true	false	false	true
4c9669de-1ae9-4c42-a257-a713bdb1feab	2026-08-17 13:50	2026-08-17 13:50	2026-08-17 13:50	BNO	BNO270115C00060000	call	60.0000	2027-01-15	4.0000	3.9000	4.0000	51.0000	10000.00	10000.00	0.00	25	9	245	27917	0.00877601461475087	0.498983058392782	0.498983058392782	false	false	false	true
9ec860a9-a78e-4c96-a10c-6ae8a1f921d7	2026-08-17 14:21	2026-08-17 14:21	2026-08-17 14:21	BNO	BNO260821C00050000	call	50.0000	2026-08-21	2.4500	2.4500	2.6500	52.0750	12265.00	750.00	11515.00	50	6	647	7816	0.0827789150460594	0.515577292665983	0.515577292665983	false	false	false	true
5c7676c2-4761-46b7-a065-27b0ee2e71c0	2026-08-17 14:29	2026-08-17 14:29	2026-08-17 14:29	BNO	BNO260821C00045000	call	45.0000	2026-08-21	6.9000	6.9000	7.2000	51.9850	69002.00	0.00	69002.00	100	6	136	5732	0.0237264480111654	1.0045336376942	1.0045336376942	false	false	false	true
4b14cbcf-0f62-4f9b-a7ab-d7c13909c443	2026-08-18 09:59	2026-08-18 09:59	2026-08-18 09:59	BNO	BNO261016C00050000	call	50.0000	2026-10-16	5.5000	5.5000	5.8000	52.2700	24750.00	0.00	24750.00	45	6	47	13819	0.00340111440769954	0.500178206488459	0.500178206488459	false	false	false	true
21569007-d0e1-4987-8698-1fd33681ac49	2026-08-18 10:23	2026-08-18 10:23	2026-08-18 10:23	BNO	BNO260918C00055000	call	55.0000	2026-09-18	2.1000	2.1000	2.2000	52.0400	19740.00	0.00	19740.00	94	21	119	8247	0.0144294895113375	0.532908638455638	0.532908638455638	false	false	false	true
543a652e-512a-433e-a3d4-fae4531b9f1b	2026-08-18 11:18	2026-08-18 11:18	2026-08-18 11:18	BNO	BNO261016C00058000	call	58.0000	2026-10-16	2.7500	2.6000	2.7500	52.4350	24200.00	24200.00	0.00	88	21	141	523	0.269598470363289	0.559121834610055	0.559121834610055	true	false	false	true
6f88569a-1df8-4cf6-ba12-35f24d87ccaf	2026-08-18 15:23	2026-08-18 15:23	2026-08-18 15:23	BNO	BNO260828C00055000	call	55.0000	2026-08-28	0.7500	0.7500	0.8500	52.1499	190125.00	0.00	190125.00	2535	35	3012	6641	0.453546152687848	0.513527271423639	0.513527271423639	false	false	false	true
1c6d5be1-18a4-42ee-a28a-d9192fc57515	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	BNO	BNO270115C00070000	call	70.0000	2027-01-15	2.4500	2.3000	2.4500	52.3100	245000.00	198450.00	0.00	1000	23	1001	13067	0.0766051886431469	0.53746203189073	0.53746203189073	true	false	false	true
5f78ecf6-18ac-4684-a567-e4fe20f2d1d1	2026-08-19 09:37	2026-08-19 09:37	2026-08-19 09:37	BNO	BNO270115C00070000	call	70.0000	2027-01-15	2.5000	2.3500	2.5000	52.3350	245000.00	245000.00	0.00	980	17	2001	13067	0.153133848626311	0.541415299527354	0.541415299527354	false	false	false	true
2f7afa09-f1d4-4e74-a207-f9dfcd79c985	2026-08-19 09:38	2026-08-19 09:38	2026-08-19 09:38	BNO	BNO270115C00070000	call	70.0000	2027-01-15	2.5500	2.3500	2.5500	52.2700	102000.00	102000.00	0.00	400	5	2401	13067	0.183745312619576	0.547537628293944	0.547537628293944	false	false	false	true
cd6d6935-4706-49cc-bd2e-b5a595248f72	2026-08-19 09:39	2026-08-19 09:39	2026-08-19 09:39	BNO	BNO270115C00070000	call	70.0000	2027-01-15	2.5500	2.3500	2.5500	52.2700	75735.00	75735.00	0.00	297	11	3298	13067	0.252391520624474	0.547537628293944	0.547537628293944	false	false	false	true
94a9993e-7d0c-4542-9a7f-ebfe291de637	2026-08-19 09:46	2026-08-19 09:46	2026-08-19 09:46	BNO	BNO270115C00070000	call	70.0000	2027-01-15	2.5500	2.3500	2.5500	52.3677	73950.00	73950.00	0.00	290	5	4488	13067	0.343460626004439	0.545151863140305	0.545151863140305	false	false	false	true
543cca5b-a9e6-4424-b251-fc66bd6e92e3	2026-08-19 09:59	2026-08-19 09:59	2026-08-19 09:59	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.1000	2.1000	2.2000	52.3700	13020.00	0.00	13020.00	62	17	145	24082	0.0060210945934723	0.552064552064264	0.552064552064264	false	false	false	true
baa23ef9-193c-492e-a9e2-41f3d794b82d	2026-08-19 10:41	2026-08-19 10:40	2026-08-19 10:40	BNO	BNO270115C00070000	call	70.0000	2027-01-15	2.6000	2.4000	2.6000	52.4600	228800.00	228800.00	0.00	880	6	6892	13067	0.527435524603964	0.547398364782323	0.547398364782323	false	false	false	true
6fadcd2d-6634-47ef-b137-7a86e11c752f	2026-08-19 11:05	2026-08-19 11:04	2026-08-19 11:04	BNO	BNO260828C00055000	call	55.0000	2026-08-28	0.8500	0.8500	0.9500	52.7400	269720.00	0.00	269720.00	3173	21	3240	6090	0.532019704433498	0.514683739727456	0.514683739727456	false	false	false	true
ca69fc56-502e-45cb-93f4-dfff5709eca7	2026-08-19 15:28	2026-08-19 15:28	2026-08-19 15:28	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.0500	2.0000	2.0500	52.2400	29724.00	29724.00	0.00	145	11	1350	24082	0.0560584669047421	0.550807539430078	0.550807539430078	true	false	false	true
d97c1446-98dc-461d-96de-cade8f9fa567	2026-08-19 15:43	2026-08-19 15:43	2026-08-19 15:43	BNO	BNO270115C00070000	call	70.0000	2027-01-15	2.5500	2.4500	2.5500	52.1700	12750.00	12750.00	0.00	50	8	7906	13067	0.605035585826892	0.549982454196592	0.549982454196592	false	false	false	true
479b70c6-e1ed-4d12-9baa-cffb09aca641	2026-08-20 09:30	2026-08-20 09:30	2026-08-20 09:30	BNO	BNO260925C00057000	call	57.0000	2026-09-25	2.6000	1.8000	2.6500	53.5500	87360.00	62140.00	25220.00	336	6	336	15	22.4	0.582156298916005	0.581436496903137	false	false	false	true
e104194b-235c-400c-ac83-8e8125690162	2026-08-20 09:33	2026-08-20 09:33	2026-08-20 09:33	BNO	BNO260821C00055000	call	55.0000	2026-08-21	0.3000	0.2500	0.4000	53.6900	21780.00	7800.00	13980.00	726	12	778	8524	0.0912717034256218	0.692673379271277	0.692673379271277	true	false	false	true
fb8c761b-921e-47f1-a0d6-b886ff9fe780	2026-08-20 09:49	2026-08-20 09:49	2026-08-20 09:49	BNO	BNO260918P00055000	put	55.0000	2026-09-18	3.9000	3.8000	3.9000	53.4300	446160.00	446160.00	0.00	1144	20	1144	138	8.28985507246377	0.519801750736167	0.517539334714277	false	false	false	true
d8134928-850d-4009-aaf5-e01f1c3e80b0	2026-08-20 10:05	2026-08-20 10:05	2026-08-20 10:05	BNO	BNO270115C00060000	call	60.0000	2027-01-15	4.6500	4.6000	4.9000	53.6300	64635.00	0.00	33945.00	139	5	206	35447	0.00581149321522273	0.493569544549843	0.493569544549843	false	false	false	true
d4c9227f-ffe7-418c-ac83-1380403671fa	2026-08-20 15:36	2026-08-20 15:35	2026-08-20 15:35	BNO	BNO260918C00055000	call	55.0000	2026-09-18	2.5500	2.4500	2.5500	53.5150	46920.00	46920.00	0.00	184	38	685	8712	0.0786271808999082	0.520272281007494	0.520272281007494	true	false	false	true
5f0de817-c576-4f79-8483-5af16365f22d	2026-08-20 15:58	2026-08-20 15:58	2026-08-20 15:58	BNO	BNO261016C00085000	call	85.0000	2026-10-16	0.4500	0.3000	0.4500	53.4886	11250.00	11250.00	0.00	250	6	354	11417	0.0310063939738986	0.725478986756482	0.725478986756482	false	false	false	true
b015b0ef-2ba9-485d-9f0e-8d0e31ded3b0	2026-08-21 09:50	2026-08-21 09:50	2026-08-21 09:50	BNO	BNO260828C00055000	call	55.0000	2026-08-28	1.0500	1.0500	1.2000	53.8100	21105.00	0.00	21105.00	201	11	226	2485	0.0909456740442656	0.518631598224494	0.518631598224494	false	false	false	true
f3803067-dbd9-4344-afca-7dc464344eb3	2026-08-21 09:53	2026-08-21 09:53	2026-08-21 09:53	BNO	BNO270115C00060000	call	60.0000	2027-01-15	4.6000	4.6000	4.9000	53.7860	11040.00	0.00	11040.00	24	5	64	35360	0.00180995475113122	0.486566042554465	0.486566042554465	false	false	false	true
d2923445-3864-4569-8954-2d8ed98cd957	2026-08-21 12:39	2026-08-21 12:39	2026-08-21 12:39	BNO	BNO260828C00057000	call	57.0000	2026-08-28	0.6000	0.6000	0.6500	53.9250	194400.00	0.00	194400.00	3240	19	3256	57	57.1228070175439	0.556671920267367	0.556671920267367	false	false	false	true
a592831a-8c5b-4e85-b309-3f2aec4cb5ce	2026-08-21 13:12	2026-08-21 13:12	2026-08-21 13:12	BNO	BNO260828C00055000	call	55.0000	2026-08-28	1.2000	1.1500	1.2000	54.1450	21000.00	21000.00	0.00	175	7	965	2485	0.388329979879276	0.522375760893805	0.522375760893805	true	false	false	true
692dda67-5b25-486d-9011-5fa3acffc5e8	2026-08-21 13:53	2026-08-21 13:53	2026-08-21 13:53	BNO	BNO260828P00049000	put	49.0000	2026-08-28	0.2400	0.1500	0.2500	54.1100	16985.00	15425.00	0.00	695	20	1001	30	33.3666666666667	0.608247603137927	0.571025293425295	true	false	false	true
487ac407-6bd9-428a-8b9e-e9b7e47e3b24	2026-08-21 14:10	2026-08-21 14:10	2026-08-21 14:10	BNO	BNO260828P00049000	put	49.0000	2026-08-28	0.2400	0.1500	0.2500	54.0000	11935.00	10575.00	0.00	491	16	1993	30	66.4333333333333	0.604248713809197	0.567166336806023	true	false	false	true
b78865cf-b78f-4fbf-847f-188e165d345a	2026-08-21 14:27	2026-08-21 14:27	2026-08-21 14:27	BNO	BNO270115C00060000	call	60.0000	2027-01-15	4.9300	4.8000	5.0000	54.1800	147900.00	147900.00	0.00	300	10	744	35360	0.0210407239819005	0.497901688983859	0.497901688983859	false	false	false	true
c67f7337-f459-468f-9219-8a107e56e5db	2026-08-21 14:51	2026-08-21 14:51	2026-08-21 14:51	BNO	BNO260918C00055000	call	55.0000	2026-09-18	2.6500	2.6000	2.6500	54.0100	48230.00	48230.00	0.00	182	9	586	8466	0.0692180486652492	0.507101021777256	0.507101021777256	false	false	false	true
ef7a929c-6d41-44e7-bf07-867dbcdc7e69	2026-08-24 10:28	2026-08-24 10:28	2026-08-24 10:28	BNO	BNO260918P00055000	put	55.0000	2026-09-18	4.0000	3.7000	4.0000	52.9500	12400.00	12400.00	0.00	31	7	38	1310	0.0290076335877863	0.527077081854491	0.524436294090763	false	false	false	true
888761bb-dfbe-4fb8-b171-24d077ed1efc	2026-08-24 10:56	2026-08-24 10:56	2026-08-24 10:56	BNO	BNO270115C00060000	call	60.0000	2027-01-15	4.5000	4.1000	4.5000	52.9401	22500.00	22500.00	0.00	50	5	340	35184	0.00966348340154616	0.512309616080214	0.512309616080214	false	false	false	true
1803224c-9727-4348-b3e1-18e4589ee5fe	2026-08-24 11:18	2026-08-24 11:18	2026-08-24 11:18	BNO	BNO261016P00040000	put	40.0000	2026-10-16	0.2500	0.2500	0.3500	53.0000	16975.00	0.00	16975.00	679	29	681	856	0.795560747663551	0.499061653116379	0.499061653116379	true	false	false	true
c9a431f9-7847-4436-9b17-541c761e8a1a	2026-08-24 14:38	2026-08-24 14:38	2026-08-24 14:38	BNO	BNO261016C00060000	call	60.0000	2026-10-16	1.9000	1.9000	2.0000	52.8400	20520.00	0.00	20520.00	108	7	299	25546	0.0117043764190088	0.529759602355091	0.529759602355091	false	false	false	true
0adc55bf-ff13-4a32-b7c7-864dcfa90159	2026-08-25 11:35	2026-08-25 11:35	2026-08-25 11:35	BNO	BNO261016C00044000	call	44.0000	2026-10-16	8.0000	8.0000	8.3000	50.9700	16000.00	0.00	16000.00	20	6	22	376	0.0585106382978723	0.446836358863671	0.446836358863671	false	false	false	true
4fb40ef4-c97a-44b5-ad25-11388d4c11f3	2026-08-25 12:24	2026-08-25 12:24	2026-08-25 12:24	BNO	BNO261016C00045000	call	45.0000	2026-10-16	7.3000	7.2000	7.4000	50.9600	146000.00	14600.00	131400.00	200	16	1225	3316	0.369420989143546	0.461319344084415	0.461319344084415	false	false	false	true
f10f0ca6-00d5-4808-8cf5-d305ab2e08ad	2026-08-25 12:25	2026-08-25 12:24	2026-08-25 12:24	BNO	BNO261016C00045000	call	45.0000	2026-10-16	7.3000	7.3000	7.4000	50.9950	56210.00	0.00	56210.00	77	6	1425	3316	0.429734620024125	0.456142739470672	0.456142739470672	false	false	false	true
bcf7b706-8c26-4ff0-b01c-a0e795951253	2026-08-25 12:25	2026-08-25 12:24	2026-08-25 12:24	BNO	BNO261016C00045000	call	45.0000	2026-10-16	7.3000	7.3000	7.4000	50.9950	88330.00	0.00	39420.00	121	18	1346	3316	0.405910735826297	0.456142739470672	0.456142739470672	false	false	false	true
c8d7627d-7cf3-4e0f-b970-488323e2ef19	2026-08-25 12:31	2026-08-25 12:31	2026-08-25 12:31	BNO	BNO261016C00050000	call	50.0000	2026-10-16	4.3000	4.2000	4.3000	51.0200	86000.00	86000.00	0.00	200	13	1481	13415	0.110398807305255	0.47770370529164	0.47770370529164	false	false	false	true
a83065a1-2ff4-409f-b24c-4dbf72e9cba0	2026-08-25 12:32	2026-08-25 12:32	2026-08-25 12:32	BNO	BNO261016C00050000	call	50.0000	2026-10-16	4.3000	4.1000	4.3000	50.9850	86000.00	86000.00	0.00	200	15	1881	13415	0.140216175922475	0.480469403647594	0.480469403647594	false	false	false	true
e57e2349-9b24-4566-a8fd-09d7f235ca08	2026-08-25 12:33	2026-08-25 12:33	2026-08-25 12:33	BNO	BNO261016C00050000	call	50.0000	2026-10-16	4.3000	4.2000	4.3000	50.9850	86000.00	86000.00	0.00	200	6	2081	13415	0.155124860231085	0.480469403647594	0.480469403647594	false	false	false	true
7650c736-9e5b-4f34-bbdf-35c406b60f46	2026-08-25 15:08	2026-08-25 15:07	2026-08-25 15:07	BNO	BNO260904P00049000	put	49.0000	2026-09-04	0.7500	0.7500	0.8500	50.9350	20325.00	0.00	20325.00	271	33	273	103	2.6504854368932	0.468369816182554	0.468369816182554	false	false	false	true
408ccff9-9b2a-4a49-a6b9-9ac5c60a90bb	2026-08-26 10:02	2026-08-26 10:02	2026-08-26 10:02	BNO	BNO270416C00060000	call	60.0000	2027-04-16	4.6000	4.2000	4.6000	50.4200	46000.00	46000.00	0.00	100	16	102	927	0.110032362459547	0.464018835533734	0.464018835533734	false	false	false	true
7cc49f52-17ee-47d9-aaf9-5a2fda34cfa9	2026-08-26 11:01	2026-08-26 11:00	2026-08-26 11:00	BNO	BNO260911C00051500	call	51.5000	2026-09-11	1.6000	1.5250	1.7000	50.6900	424480.00	160.00	424320.00	2653	20	2687	6	447.833333333333	0.455310461944055	0.455310461944055	false	false	false	true
8251ecfb-7251-44af-9185-d945006aaa69	2026-08-26 11:41	2026-08-26 11:41	2026-08-26 11:41	BNO	BNO270115C00065000	call	65.0000	2027-01-15	2.5000	2.4000	2.5000	50.8550	25000.00	1000.00	0.00	100	29	113	3877	0.0291462470982719	0.512316010804399	0.512316010804399	false	false	false	true