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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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 = BNO×

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

ad3de13f-beec-4b8c-b903-c67798e8b9d8	2026-08-31 09:38	2026-08-31 09:38	2026-08-31 09:38	BNO	BNO260904C00051500	call	51.5000	2026-09-04	2.2800	2.2000	2.4000	53.2610	14800.00	0.00	3300.00	65	6	70	205	0.341463414634146	0.495387899585761	0.550910075632184	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-31T13:47:44.562652Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
204591fa-21a7-4c6e-a3d2-69f5a77500f8	2026-08-28 14:53	2026-08-28 14:53	2026-08-28 14:53	BNO	BNO261016C00060000	call	60.0000	2026-10-16	1.2000	1.2000	1.3000	51.3200	131640.00	0.00	131640.00	1097	40	1989	25465	0.078107205968977	0.506417489450845	0.506417489450845	false	false	false	true
5994ede6-e7f0-4e53-8d95-50f11d297273	2026-08-28 13:24	2026-08-28 13:24	2026-08-28 13:24	BNO	BNO261016C00060000	call	60.0000	2026-10-16	1.2500	1.2500	1.3000	51.4350	10000.00	0.00	10000.00	80	14	891	25465	0.0349892008639309	0.510298756391675	0.510298756391675	true	false	false	true
3dbd46c4-2f54-4aae-97fb-262c8f5aff4a	2026-08-28 13:21	2026-08-28 13:21	2026-08-28 13:21	BNO	BNO261016C00060000	call	60.0000	2026-10-16	1.2500	1.2500	1.3000	51.4250	30000.00	0.00	30000.00	240	16	811	25465	0.0318476340074612	0.511119689053906	0.510709221976129	false	false	false	true
6fc1947a-906e-4648-8345-9eab6f1113e1	2026-08-28 11:30	2026-08-28 11:30	2026-08-28 11:30	BNO	BNO260918P00047000	put	47.0000	2026-09-18	0.6900	0.5500	0.7000	51.4999	20100.00	20100.00	0.00	292	7	733	65	11.2769230769231	0.490638989833561	0.475880739321285	true	false	false	true
9020437e-bd2c-4c9a-832d-5401d41d34c4	2026-08-28 09:57	2026-08-28 09:57	2026-08-28 09:57	BNO	BNO261016C00050000	call	50.0000	2026-10-16	4.0600	4.0000	4.3000	51.0500	20312.00	0.00	20312.00	50	8	60	14435	0.00415656390717007	0.460416644087202	0.460416644087202	false	false	false	true
c2fb8061-504b-4d6b-a436-9695b1dd0464	2026-08-28 09:48	2026-08-28 09:48	2026-08-28 09:48	BNO	BNO261016C00060000	call	60.0000	2026-10-16	1.2600	1.2500	1.4000	51.1000	20172.00	0.00	20172.00	160	11	160	25465	0.00628313371293933	0.527497546389864	0.527497546389864	false	false	false	true
1b065d93-f742-4c60-b191-755dd4409a70	2026-08-27 14:49	2026-08-27 14:49	2026-08-27 14:49	BNO	BNO270416C00060000	call	60.0000	2027-04-16	5.0500	4.8000	5.1000	51.8000	25250.00	15150.00	0.00	50	7	151	1229	0.12286411716843	0.456330081681907	0.456330081681907	false	false	false	true
c72683af-7697-4367-8f0a-5d50f17597e3	2026-08-27 14:44	2026-08-27 14:44	2026-08-27 14:44	BNO	BNO270115C00060000	call	60.0000	2027-01-15	3.7000	3.5000	3.7000	51.7700	31450.00	31450.00	0.00	85	6	371	34693	0.0106937999019975	0.49287391213377	0.49287391213377	false	false	false	true
0e3cb15e-11d3-4c71-a588-13dabd6e93e7	2026-08-27 14:31	2026-08-27 14:30	2026-08-27 14:30	BNO	BNO261016C00050000	call	50.0000	2026-10-16	4.5000	4.5000	4.7000	51.7300	29250.00	0.00	29250.00	65	16	117	14538	0.00804787453569955	0.456237843266909	0.456237843266909	false	false	false	true
c6139e23-e797-4094-bf42-abdb37565a05	2026-08-27 13:57	2026-08-27 13:57	2026-08-27 13:57	BNO	BNO260918C00051500	call	51.5000	2026-09-18	2.5500	1.9500	2.5500	51.6800	16320.00	16320.00	0.00	64	6	64	2	32	0.47542185173394	0.47542185173394	true	false	false	true
de6d8914-3428-40f1-a92d-d79887acd45f	2026-08-27 13:47	2026-08-27 13:47	2026-08-27 13:47	BNO	BNO261016C00056000	call	56.0000	2026-10-16	2.2000	2.1500	2.2000	51.3800	12100.00	12100.00	0.00	55	22	55	267	0.205992509363296	0.506597678101358	0.506597678101358	false	false	false	true
1bc746b4-064a-45ec-9511-f4cba65849df	2026-08-27 10:59	2026-08-27 10:59	2026-08-27 10:59	BNO	BNO260918C00045000	call	45.0000	2026-09-18	6.2000	6.2000	7.1000	50.7550	64480.00	0.00	64480.00	104	8	104	304	0.342105263157895	0.445071746874861	0.445071746874861	false	false	false	true
b64aa58b-5dd4-4dd4-89bb-df246556d488	2026-08-26 15:57	2026-08-26 15:57	2026-08-26 15:57	BNO	BNO261016C00055000	call	55.0000	2026-10-16	2.1500	2.1500	2.3000	50.5400	36335.00	0.00	36335.00	169	9	496	11033	0.0449560409680051	0.495849616992922	0.495849616992922	false	false	false	true
5c95a71d-4ff3-413d-a3c7-a7963ebc4d6f	2026-08-26 15:07	2026-08-26 15:07	2026-08-26 15:07	BNO	BNO270115C00070000	call	70.0000	2027-01-15	1.8500	1.8500	1.9500	50.5400	141340.00	0.00	141340.00	764	5	5801	20634	0.281137927692159	0.534429916998497	0.534429916998497	false	false	false	true
0d9624af-2f7d-45eb-9244-e228a0ca8962	2026-08-26 15:06	2026-08-26 15:06	2026-08-26 15:06	BNO	BNO270115C00070000	call	70.0000	2027-01-15	1.8500	1.8500	1.9500	50.5300	185000.00	0.00	185000.00	1000	5	4037	20634	0.195647959678201	0.534666691824758	0.534666691824758	false	false	false	true
db4e2d8a-caf8-470b-bdfc-1ea19bbc1191	2026-08-26 15:02	2026-08-26 15:02	2026-08-26 15:02	BNO	BNO270115C00050000	call	50.0000	2027-01-15	6.4000	6.3000	6.6000	50.5500	640000.00	28800.00	590080.00	1000	31	2195	10767	0.203863657471905	0.462333416810691	0.462333416810691	false	false	false
9f948d86-6e54-42d0-ba84-71e0e8402efb	2026-08-26 14:49	2026-08-26 14:49	2026-08-26 14:49	BNO	BNO261016C00050000	call	50.0000	2026-10-16	4.0000	4.0000	4.1000	50.6200	30800.00	0.00	30800.00	77	9	345	14896	0.0231605800214823	0.473725214817531	0.473725214817531	false	false	false	true
28c6facf-a293-4d96-b543-822c6b99f6fe	2026-08-26 14:49	2026-08-26 14:48	2026-08-26 14:48	BNO	BNO270416C00050000	call	50.0000	2027-04-16	8.0000	8.0000	8.2000	50.6300	16000.00	0.00	16000.00	20	5	40	3	13.3333333333333	0.445205236897145	0.445205236897145	false	false	false	true
0ac19927-1872-47f9-a3fd-97d53d4f8fb3	2026-08-26 12:37	2026-08-26 12:37	2026-08-26 12:37	BNO	BNO260904P00050000	put	50.0000	2026-09-04	0.9500	0.9500	1.0500	51.3300	177745.00	0.00	177745.00	1871	40	1875	101	18.5643564356436	0.486062868870425	0.486062868870425	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
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
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
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
7dc6dbf9-0b86-4e59-90d1-ec131a4fbf19	2026-08-25 14:24	2026-08-25 14:24	2026-08-25 14:24	BNO	BNO270115C00048000	call	48.0000	2027-01-15	7.6100	7.2000	8.5000	50.0000	22824.00	0.00	22824.00	30	8	30	1433	0.0209351011863224	0.460380770020602	0.460380770020602	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
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
e5cc0944-385b-4b30-9653-8594acd5f036	2026-08-25 12:32	2026-08-25 12:31	2026-08-25 12:31	BNO	BNO261016C00050000	call	50.0000	2026-10-16	4.2900	4.1000	4.3000	50.9950	85866.00	85866.00	0.00	200	14	1681	13415	0.125307491613865	0.479680031028424	0.479680031028424	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
9baec4cd-1a2d-49e6-b9e5-07d944517761	2026-08-25 12:28	2026-08-25 12:27	2026-08-25 12:27	BNO	BNO261016C00050000	call	50.0000	2026-10-16	4.2500	4.0000	4.3000	50.9800	76482.00	76482.00	0.00	180	5	881	13415	0.065672754379426	0.472842147154417	0.472842147154417	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
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
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
add8fc4a-6577-4021-9be4-b2e992f7a40b	2026-08-25 11:24	2026-08-25 11:24	2026-08-25 11:24	BNO	BNO260828C00051500	call	51.5000	2026-08-28	0.8100	0.7500	1.7000	51.1807	40455.00	1360.00	39095.00	500	6	1041	79	13.1772151898734	0.513584124297716	0.508445584286419	false	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
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
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
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
0801298e-7599-4cdb-87e3-2edfbf9ce1c9	2026-08-24 10:28	2026-08-24 10:28	2026-08-24 10:28	BNO	BNO261016C00055000	call	55.0000	2026-10-16	3.4000	3.3000	3.6000	52.9912	149423.00	61023.00	88400.00	440	7	487	11283	0.0431622795355845	0.513727214446184	0.512483293237022	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
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
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
c20bd589-2bc4-4b40-9146-b72ff8cc2a9b	2026-08-21 13:59	2026-08-21 13:59	2026-08-21 13:59	BNO	BNO260918P00049000	put	49.0000	2026-09-18	1.0500	0.9000	1.0500	54.1800	10457.00	10457.00	0.00	100	5	155	30	5.16666666666667	0.521058118092021	0.52560760339142	false	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
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
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
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
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
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