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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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×

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

eb0f56b2-170f-4c08-be26-5e2e76441a5a	2026-09-08 13:24	2026-09-08 13:24	2026-09-08 13:24	BNO	BNO270115C00065000	call	65.0000	2027-01-15	4.2400	3.9000	4.3000	56.6501	10610.00	8600.00	2010.00	25	9	277	4005	0.06916354556804	0.522091117688685	0.50056682090787	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-09-08T17:42:35.153326Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2d88a1b5-841c-4603-bb8e-7138a2ffa47f	2026-09-08 13:22	2026-09-08 13:22	2026-09-08 13:22	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.3000	2.3000	2.5500	56.6400	16100.00	0.00	16100.00	70	5	883	24676	0.0357837574971632	0.487650351724604	0.487650351724604	false	false	false	true
b7ce945f-766e-4387-9f54-23b7ac74a526	2026-09-08 11:25	2026-09-08 11:24	2026-09-08 11:24	BNO	BNO261016C00055000	call	55.0000	2026-10-16	4.7000	4.7000	4.9000	57.3299	47000.00	0.00	47000.00	100	29	414	11243	0.0368229120341546	0.453143203032021	0.453143203032021	false	false	false	true
0c3bc03f-c491-45f8-8338-8e472e037624	2026-09-08 10:56	2026-09-08 10:56	2026-09-08 10:56	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.6000	5.4000	5.7000	57.0750	40320.00	33040.00	7280.00	72	6	411	33752	0.0121770561744489	0.479835716854476	0.479835716854476	true	false	false	true
94646cb6-3554-492d-8fd9-b2c7d70c11c7	2026-09-08 09:39	2026-09-08 09:39	2026-09-08 09:39	BNO	BNO261016P00059000	put	59.0000	2026-10-16	4.4000	4.3000	4.4000	57.4250	854480.00	854480.00	0.00	1942	36	1962	18	109	0.494488878442362	0.494488878442362	false	false	false	true
45b2a47a-6acd-4371-8940-f5e44da1900d	2026-09-04 15:35	2026-09-04 15:34	2026-09-04 15:34	BNO	BNO261016C00065000	call	65.0000	2026-10-16	1.2500	1.2500	1.3500	56.2400	24875.00	0.00	24875.00	199	5	455	12780	0.0356025039123631	0.513711197409224	0.513711197409224	false	false	false	true
9b72450e-f5c3-4db7-8b0f-979cad26c744	2026-09-04 14:28	2026-09-04 14:28	2026-09-04 14:28	BNO	BNO261016C00059000	call	59.0000	2026-10-16	2.5500	2.4500	2.5500	56.1500	10965.00	10965.00	0.00	43	16	54	292	0.184931506849315	0.476536865465154	0.476536865465154	false	false	false	true
0c3069d0-d999-46ef-9a51-9b6370b6eafb	2026-09-04 13:00	2026-09-04 13:00	2026-09-04 13:00	BNO	BNO261016C00052000	call	52.0000	2026-10-16	5.9000	5.5000	5.9000	56.0600	26550.00	26550.00	0.00	45	6	72	2969	0.0242505894240485	0.455894853729479	0.455894853729479	false	false	false	true
5bce0066-d570-4224-8e9b-2fee2841f11f	2026-09-04 10:18	2026-09-04 10:18	2026-09-04 10:18	BNO	BNO261016C00056000	call	56.0000	2026-10-16	3.1000	3.0000	3.1000	54.8950	24180.00	24180.00	0.00	78	25	94	296	0.317567567567568	0.469382459610496	0.469382459610496	false	false	false	true
a1083ab4-e06d-433c-9f34-8d12d4a214f3	2026-09-04 09:40	2026-09-04 09:39	2026-09-04 09:39	BNO	BNO270115C00055000	call	55.0000	2027-01-15	6.2000	6.2000	6.4000	54.7300	41540.00	0.00	41540.00	67	5	77	10229	0.00752761755792355	0.454121381786234	0.454121381786234	false	false	false	true
c0913e15-f637-4131-bd91-a4100ade112c	2026-09-03 13:26	2026-09-03 13:26	2026-09-03 13:26	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.4000	2.4000	2.5000	56.0550	520560.00	0.00	520560.00	2169	21	2823	24997	0.112933552026243	0.501378608963461	0.501378608963461	false	false	false	true
7f1016b4-85f4-4f30-965e-a6ea086c8d9f	2026-09-03 12:51	2026-09-03 12:50	2026-09-03 12:50	BNO	BNO261002P00046000	put	46.0000	2026-10-02	0.2000	0.2000	0.3000	55.9250	15260.00	0.00	15260.00	763	35	763	2	381.5	0.471424983744847	0.471424983744847	false	false	false	true
d6012d5f-a0f7-4b19-946d-7739bd1b9a3a	2026-09-03 11:58	2026-09-03 11:58	2026-09-03 11:58	BNO	BNO261016C00055000	call	55.0000	2026-10-16	4.1000	4.1000	4.2000	55.7900	20500.00	0.00	20500.00	50	5	1641	11714	0.140088782653235	0.470265887421998	0.470265887421998	false	false	false	true
414a5276-2352-436b-8177-81a27229a3ec	2026-09-03 11:54	2026-09-03 11:54	2026-09-03 11:54	BNO	BNO260918C00050000	call	50.0000	2026-09-18	6.2000	6.2000	6.8000	55.8615	13020.00	0.00	13020.00	21	5	204	3946	0.0516979219462747	0.453613576356274	0.453613576356274	false	false	false	true
3522056a-6911-4f53-bb0d-a61f3b2abc03	2026-09-03 09:58	2026-09-03 09:58	2026-09-03 09:58	BNO	BNO260911C00055000	call	55.0000	2026-09-11	2.2000	2.2000	2.4000	56.1550	288200.00	0.00	288200.00	1310	29	1310	240	5.45833333333333	0.464805169190932	0.464805169190932	false	false	false	true
a7bed6c4-2b32-4b74-9ff0-c1e41e54558b	2026-09-02 15:55	2026-09-02 15:55	2026-09-02 15:55	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.3500	2.3500	2.4500	55.7250	55930.00	0.00	55930.00	238	15	814	27664	0.0294245228455755	0.5057310596158	0.5057310596158	false	false	false	true
2646a36d-c0c7-4ba5-b16c-406f096e80d7	2026-09-02 15:55	2026-09-02 15:55	2026-09-02 15:55	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.3500	2.3500	2.4500	55.7250	78725.00	0.00	78725.00	335	15	1149	27664	0.0415341237709659	0.5057310596158	0.5057310596158	false	false	false	true
ba907914-8c49-4daf-a716-f02644bf6aea	2026-09-02 13:39	2026-09-02 13:38	2026-09-02 13:38	BNO	BNO261016C00050000	call	50.0000	2026-10-16	7.4000	7.4000	7.5000	55.9648	1701260.00	0.00	1701260.00	2299	22	2866	13751	0.208421205730492	0.472294712635653	0.472294712635653	false	false	false	true
b9dc53bb-0996-4e81-8914-02253606c97e	2026-09-01 15:44	2026-09-01 15:44	2026-09-01 15:44	BNO	BNO260918C00055000	call	55.0000	2026-09-18	2.5500	2.5500	2.7500	55.5200	25500.00	0.00	25500.00	100	17	474	10008	0.0473621103117506	0.468918351192827	0.468918351192827	false	false	false	true
bca50f29-1c03-4fb7-8212-b1429d3a2d36	2026-09-01 14:44	2026-09-01 14:44	2026-09-01 14:44	BNO	BNO261016C00070000	call	70.0000	2026-10-16	0.9000	0.9000	0.9500	55.4350	281279.00	0.00	281279.00	3125	30	3623	8479	0.427290954121948	0.595588811560527	0.595588811560527	false	false	false	true
1d501af9-0594-4756-a908-2ac19ded7099	2026-09-01 13:24	2026-09-01 13:24	2026-09-01 13:24	BNO	BNO261016C00075000	call	75.0000	2026-10-16	0.5000	0.5000	0.5500	54.9400	26605.00	0.00	26605.00	532	23	627	7270	0.0862448418156809	0.620163187137666	0.620163187137666	false	false	false	true
e1612e73-216c-4250-a86a-e983b99e5e71	2026-09-01 12:24	2026-09-01 12:24	2026-09-01 12:24	BNO	BNO261016C00058000	call	58.0000	2026-10-16	2.8000	2.7500	2.8000	54.9200	1002400.00	1002400.00	0.00	3580	37	8699	629	13.8298887122417	0.51444634000281	0.51444634000281	false	false	false	true
c3232096-ab5d-43b1-b9a9-0b345a44f4b2	2026-09-01 09:53	2026-09-01 09:53	2026-09-01 09:53	BNO	BNO270115C00050000	call	50.0000	2027-01-15	8.4000	8.3000	8.6000	54.1000	168000.00	19320.00	148680.00	200	7	413	8729	0.0473135525260625	0.451072228327785	0.451072228327785	false	false	false	true
f41d2aa4-a126-4694-9caf-5c765a243142	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	BNO	BNO261016C00050000	call	50.0000	2026-10-16	6.0000	5.9000	6.0000	54.1700	33000.00	33000.00	0.00	55	5	55	14127	0.00389325405252354	0.46228492839639	0.461136243386623	false	false	false	true
2bd2823c-40c1-462f-a996-fd59b4a6d055	2026-08-31 14:27	2026-08-31 14:27	2026-08-31 14:27	BNO	BNO261016C00060000	call	60.0000	2026-10-16	1.5000	1.4500	1.6000	52.8700	32700.00	1350.00	31350.00	218	5	292	25293	0.0115446961609932	0.506761046742548	0.506761046742548	true	false	false	true
54a4cebe-b888-49dc-b0e6-1f8c160c54e8	2026-08-31 09:40	2026-08-31 09:40	2026-08-31 09:40	BNO	BNO260925C00055000	call	55.0000	2026-09-25	2.2500	1.5500	2.2500	53.0950	22500.00	22500.00	0.00	100	8	100	124	0.806451612903226	0.54167325779679	0.54167325779679	false	false	false	true
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
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
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	true
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
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