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: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	price

a3cc3380-e9d0-4caa-b11b-9794c7906066	2026-09-01 12:11	2026-09-01 12:11	2026-09-01 12:11	BNO	BNO270115C00055000	call	55.0000	2027-01-15	6.1900	5.9000	6.3000	54.1850	21653.00	21653.00	0.00	35	5	383	9951	0.0384885941111446	0.470077096603153	0.470077096603153	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	Financial Services	215640000.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T16:27:11.873526Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
42c9ffe2-120e-4011-ae08-0ed7f8fdce47	2026-09-01 14:02	2026-09-01 14:02	2026-09-01 14:02	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.3000	2.3000	2.4500	55.0997	665182.00	0.00	665182.00	2892	56	3903	25341	0.154019178406535	0.525166171070944	0.525166171070944	false	false	false	true	false
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	false
2ca6247f-19d0-456b-bf76-bcda28c2f8c3	2026-09-01 15:23	2026-09-01 15:23	2026-09-01 15:23	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.4700	2.4500	2.5000	55.5300	15083.00	3968.00	11115.00	61	5	4407	25341	0.173907896294542	0.527787508654023	0.527787508654023	false	false	false	true	false
f0bc885e-b767-4c1c-aef1-72340f28002d	2026-09-01 15:26	2026-09-01 15:26	2026-09-01 15:26	BNO	BNO270115C00055000	call	55.0000	2027-01-15	7.0100	6.9000	7.3000	55.5800	63112.00	32752.00	30360.00	90	6	648	9951	0.0651190835091951	0.463904589000724	0.480602788118562	false	false	false	true	false
9af66c2a-d21a-481b-865a-ea766eaca06f	2026-09-01 15:32	2026-09-01 15:32	2026-09-01 15:32	BNO	BNO270115C00050000	call	50.0000	2027-01-15	9.6700	9.5000	9.7000	55.5700	48374.00	48374.00	0.00	50	6	620	8729	0.0710276091190285	0.474504950891935	0.474504950891935	false	false	false	true	false
63bf8039-6e1f-44da-986a-40e2b0c32b36	2026-09-01 15:33	2026-09-01 15:33	2026-09-01 15:33	BNO	BNO270115C00050000	call	50.0000	2027-01-15	9.6800	9.5000	10.0000	55.5700	48410.00	0.00	48410.00	50	5	720	8729	0.0824836751059686	0.474504950891935	0.474504950891935	false	false	false	true	false
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	false
a86a1fa2-2bd7-41d4-97ba-98d13dc70726	2026-09-02 09:41	2026-09-02 09:41	2026-09-02 09:41	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.1200	2.1000	2.3000	54.9300	42937.00	0.00	42937.00	203	21	267	27664	0.00965153267784847	0.511331184096274	0.515569020669445	false	false	false	true	false
5559a3ca-fb5f-4bf2-a785-b230df4f94f3	2026-09-02 12:08	2026-09-02 12:07	2026-09-02 12:07	BNO	BNO270416C00060000	call	60.0000	2027-04-16	7.0000	6.5000	7.3000	55.8300	14002.00	14002.00	0.00	20	8	25	1722	0.0145180023228804	0.463145683700091	0.462574230341673	false	false	false	true	false
b7920879-391f-4dc5-b957-72bfc60da144	2026-09-02 13:30	2026-09-02 13:30	2026-09-02 13:30	BNO	BNO270416P00048000	put	48.0000	2027-04-16	3.7800	3.4000	4.6000	55.9100	18890.00	0.00	18890.00	50	5	50	82	0.609756097560976	0.466343800777656	0.469194012256655	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
067ab08a-28b6-4d69-a322-2ac94fc8dedf	2026-09-03 13:32	2026-09-03 13:32	2026-09-03 13:32	BNO	BNO261016C00065000	call	65.0000	2026-10-16	1.3200	1.3000	1.5000	55.9400	14504.00	0.00	14504.00	110	16	251	12887	0.0194769923178397	0.527908623783729	0.532941814823226	false	false	false	true	false
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	false
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	false
2f876ca6-5372-4c19-b246-c33324a24874	2026-09-04 11:42	2026-09-04 11:42	2026-09-04 11:42	BNO	BNO270115C00055000	call	55.0000	2027-01-15	6.7600	6.6000	7.0000	55.6650	27028.00	0.00	27028.00	40	7	183	10229	0.0178903118584417	0.456225936861037	0.456225936861037	false	false	false	true	false
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	false
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	false
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	false
b76ce3fb-1180-4e53-b91b-d787e165a4a7	2026-09-08 09:32	2026-09-08 09:32	2026-09-08 09:32	BNO	BNO270115C00065000	call	65.0000	2027-01-15	4.2700	3.5000	4.7000	57.2700	12796.00	12796.00	0.00	30	11	31	4005	0.00774032459425718	0.499105619981803	0.499105619981803	false	false	false	true	false
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	false
8ec9942b-cc6b-4c5c-8ba8-fde456013a4b	2026-09-08 10:05	2026-09-08 10:05	2026-09-08 10:05	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.7500	5.4000	5.8000	57.3500	34486.00	34486.00	0.00	60	7	78	33752	0.00231097416449396	0.478345298665795	0.478345298665795	false	false	false	true	false
a82a6a8f-5cda-45ff-a232-ecbde842176d	2026-09-08 10:40	2026-09-08 10:40	2026-09-08 10:40	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.6000	5.5000	5.7000	57.2201	55980.00	10110.00	2750.00	100	8	237	33752	0.00702180611519317	0.467027420544646	0.474397732215504	false	false	false	true	false
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	false
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	false
2276bb23-4383-4216-ae23-82abeb925092	2026-09-08 11:56	2026-09-08 11:56	2026-09-08 11:56	BNO	BNO270115C00050000	call	50.0000	2027-01-15	10.2600	10.2000	10.7000	56.9350	20530.00	0.00	20530.00	20	7	230	7803	0.0294758426246316	0.444272562326935	0.462795966157285	false	false	false	true	false
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	false
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
b43c3820-0e10-4729-956c-910db7ed669c	2026-09-08 13:24	2026-09-08 13:24	2026-09-08 13:24	BNO	BNO261016C00060000	call	60.0000	2026-10-16	2.3500	2.3000	2.5000	56.6100	577160.00	574810.00	2350.00	2456	9	3399	24676	0.137745177500405	0.496437706396494	0.496437706396494	false	false	false	true	false
d69b171d-c082-417c-8a3b-2c1809bb8a21	2026-09-08 14:34	2026-09-08 14:33	2026-09-08 14:33	BNO	BNO260918C00055000	call	55.0000	2026-09-18	2.9100	2.9000	3.2000	57.0800	180376.00	0.00	180376.00	619	41	1946	8771	0.221867517956903	0.435709023839733	0.451197358348543	true	false	false	true	false
8e3793a2-09c3-4e37-a692-55307fc36869	2026-09-08 14:41	2026-09-08 14:40	2026-09-08 14:40	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.7000	5.5000	5.7000	57.0550	528960.00	528960.00	0.00	928	14	1747	33752	0.0517598957098839	0.48797558063861	0.48797558063861	false	false	false	true	false
f76cd1df-c55a-4dab-8794-33e4b0e6ad92	2026-09-08 14:45	2026-09-08 14:44	2026-09-08 14:44	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.7000	5.5000	5.7000	57.0800	427500.00	427500.00	0.00	750	12	2603	33752	0.0771213557715098	0.48703668915416	0.48703668915416	false	false	false	true	false
8b366c79-ee68-4ec5-9198-ffc922291ade	2026-09-08 14:47	2026-09-08 14:47	2026-09-08 14:47	BNO	BNO260918C00050000	call	50.0000	2026-09-18	7.3000	7.1000	7.4000	57.1200	37230.00	5840.00	31390.00	51	15	246	3673	0.0669752246120338	0.529837642184667	0.529837642184667	false	false	false	true	false
043b92bc-7f7b-40aa-9e6f-a478f435a5fe	2026-09-08 14:50	2026-09-08 14:50	2026-09-08 14:50	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.8000	5.6000	5.9000	57.3900	11592.00	11592.00	0.00	20	6	3176	33752	0.0940981275183693	0.481981250573189	0.481981250573189	false	false	false	true	false
f46d07fe-2412-4969-811d-6963e2924684	2026-09-08 14:50	2026-09-08 14:50	2026-09-08 14:50	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.8000	5.6000	5.8000	57.3900	11600.00	11600.00	0.00	20	5	3236	33752	0.0958757999525954	0.48271645474049	0.48271645474049	false	false	false	true	false
840f2cc3-31d7-4754-bae3-3a5218954db7	2026-09-08 14:50	2026-09-08 14:50	2026-09-08 14:50	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.8000	5.6000	5.9000	57.3900	11592.00	9272.00	2320.00	20	6	3216	33752	0.09528324247452	0.48271645474049	0.481981250573189	false	false	false	true	false
235afcff-aa60-4775-8821-ca3e98cd4249	2026-09-08 14:51	2026-09-08 14:51	2026-09-08 14:51	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.7900	5.7000	5.8000	57.3900	11586.00	11586.00	0.00	20	6	3336	33752	0.0988385873429723	0.481246056794338	0.481246056794338	false	false	false	true	false
d52fef34-11b0-49ab-a987-89a5ca45ca67	2026-09-08 15:17	2026-09-08 15:17	2026-09-08 15:17	BNO	BNO270115C00065000	call	65.0000	2027-01-15	4.3600	4.3000	4.5000	57.6000	32716.00	0.00	32716.00	75	6	354	4005	0.0883895131086142	0.497899599658726	0.497899599658726	false	false	false	true	false
7ecc89b7-662e-4e82-992a-73b6ca06249e	2026-09-08 15:29	2026-09-08 15:28	2026-09-08 15:28	BNO	BNO270115C00060000	call	60.0000	2027-01-15	5.9000	5.8000	5.9000	57.6250	50150.00	50150.00	0.00	85	5	3790	33752	0.112289642095283	0.481127714094601	0.481127714094601	false	false	false	true	false
0b160087-64f2-4705-9574-c9dce20ab4bd	2026-09-09 09:54	2026-09-09 09:54	2026-09-09 09:54	BNO	BNO270115C00060000	call	60.0000	2027-01-15	6.6900	6.5000	6.7000	58.8300	66205.00	66205.00	0.00	99	5	186	34899	0.00532966560646437	0.494359522485036	0.492908905116112	false	false	false	true	false
e04ccb1d-81ed-438d-b74f-c7d659f7c4c0	2026-09-09 09:55	2026-09-09 09:55	2026-09-09 09:55	BNO	BNO270115P00055000	put	55.0000	2027-01-15	4.4400	4.2000	4.5000	58.8200	84397.00	84397.00	0.00	190	27	190	254	0.748031496062992	0.49163244003812	0.482966184502326	false	false	false	true	false