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 = XBI×

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

8843e313-1734-489f-95b3-21bb942079c2	2026-09-09 14:21	2026-09-09 14:21	2026-09-09 14:21	XBI	XBI261218C00200000	call	200.0000	2026-12-18	1.0900	0.8900	1.0900	159.9700	19620.00	19620.00	0.00	180	29	232	9487	0.0244545167070728	0.296957745858228	0.296957745858228	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	10369971822.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7873dafc-0e2c-457c-9471-030b3b3c735d	2026-09-09 11:47	2026-09-09 11:47	2026-09-09 11:47	XBI	XBI260911P00159000	put	159.0000	2026-09-11	1.1600	1.1600	1.2300	160.2600	54984.00	0.00	54984.00	474	21	3358	922	3.64208242950108	0.367070024280699	0.367070024280699	false	false	false	true
36c17f3d-cbad-4bf0-9c65-725543241a1a	2026-09-09 11:00	2026-09-09 10:59	2026-09-09 10:59	XBI	XBI260925P00154000	put	154.0000	2026-09-25	1.7000	1.7000	1.8500	160.5550	184790.00	0.00	184790.00	1087	19	1090	99	11.010101010101	0.32529905694457	0.32529905694457	false	false	false	true
14504e7c-23f8-4460-941a-52a0bf8d3e49	2026-09-09 10:59	2026-09-09 10:59	2026-09-09 10:59	XBI	XBI261016P00165000	put	165.0000	2026-10-16	8.4000	8.3500	8.7500	160.4500	31921.00	840.00	31081.00	38	16	135	2400	0.05625	0.303573316138085	0.303573316138085	true	false	false	true
019bdb7b-9729-4856-8e16-ee8fbaa929bf	2026-09-09 10:47	2026-09-09 10:47	2026-09-09 10:47	XBI	XBI261016P00165000	put	165.0000	2026-10-16	8.4000	8.0500	8.7500	160.2500	10075.00	8400.00	1675.00	12	11	96	2400	0.04	0.297426808345824	0.297722152980576	true	false	false	true
ae57bb6a-7e5b-4c41-8e16-7a32e687c43c	2026-09-09 10:45	2026-09-09 10:45	2026-09-09 10:45	XBI	XBI260918P00157000	put	157.0000	2026-09-18	1.8000	1.5200	1.8000	160.3600	27000.00	27000.00	0.00	150	14	152	2283	0.0665790626368813	0.327927198695242	0.327927198695242	true	false	false	true
0ac8e319-f3c2-437c-aecb-d423c6d774e7	2026-09-09 10:36	2026-09-09 10:36	2026-09-09 10:36	XBI	XBI261016P00165000	put	165.0000	2026-10-16	8.4000	7.9500	8.4000	160.0000	26035.00	26035.00	0.00	31	18	74	2400	0.0308333333333333	0.301828927574065	0.301828927574065	false	false	false	true
40f288a6-1fa5-4698-bbc7-589df4eebeb2	2026-09-09 10:32	2026-09-09 10:32	2026-09-09 10:32	XBI	XBI261016P00165000	put	165.0000	2026-10-16	8.4000	7.8000	8.4000	160.0000	25200.00	25200.00	0.00	30	18	30	2400	0.0125	0.305019991863654	0.305019991863654	false	false	false	true
93d1ec2b-0287-422e-8585-1b0b16336b30	2026-09-09 10:23	2026-09-09 10:23	2026-09-09 10:23	XBI	XBI261016P00152000	put	152.0000	2026-10-16	2.6600	2.5100	2.6700	160.8150	16492.00	266.00	16226.00	62	20	122	75	1.62666666666667	0.316763657683442	0.316763657683442	false	false	false	true
b18827f5-6d65-43c0-98b7-ceb0e52bf59f	2026-09-09 10:23	2026-09-09 10:23	2026-09-09 10:23	XBI	XBI261016P00152000	put	152.0000	2026-10-16	2.6700	2.2700	2.6900	160.8450	13884.00	4806.00	9078.00	52	9	52	75	0.693333333333333	0.317835906138289	0.317835906138289	false	false	false	true
f0f7d756-c77c-4d75-9083-1aa4ec589246	2026-09-09 10:20	2026-09-09 10:20	2026-09-09 10:20	XBI	XBI261016P00149000	put	149.0000	2026-10-16	2.0000	1.5800	2.2000	160.9800	41800.00	200.00	41600.00	209	10	209	3439	0.0607734806629834	0.328752014045979	0.327073351544652	false	false	false	true
ecabbadd-cd80-4272-9755-bf6d834cec5a	2026-09-09 10:19	2026-09-09 10:19	2026-09-09 10:19	XBI	XBI261016C00154000	call	154.0000	2026-10-16	10.8000	10.8000	12.4500	161.0850	12960.00	0.00	12960.00	12	7	12	5	2.4	0.311088569710232	0.311088569710232	true	false	false	true
f3654b09-fa9d-469b-9978-fb5d0f132b4e	2026-09-09 09:55	2026-09-09 09:54	2026-09-09 09:54	XBI	XBI260911P00157500	put	157.5000	2026-09-11	0.3600	0.3600	0.4700	162.8600	24624.00	0.00	24624.00	684	26	688	77	8.93506493506493	0.422576262099841	0.422576262099841	false	false	false	true
2619fd06-395f-4a7f-80be-e9f2512ca949	2026-09-08 15:53	2026-09-08 15:53	2026-09-08 15:53	XBI	XBI260911C00170000	call	170.0000	2026-09-11	0.1600	0.1500	0.1600	161.9200	11040.00	11040.00	0.00	690	22	1667	1862	0.895273899033298	0.357430037172937	0.357430037172937	false	false	false	true
65c85815-818f-48bf-b0a9-ed480e093535	2026-09-08 15:48	2026-09-08 15:48	2026-09-08 15:48	XBI	XBI260918C00150000	call	150.0000	2026-09-18	12.6500	12.6500	13.4000	162.1800	11385.00	0.00	11385.00	9	5	34	3949	0.00860977462648772	0.339150741708806	0.339150741708806	false	false	false	true
0680c693-0256-4eaa-9074-eb3e962b25b8	2026-09-08 15:32	2026-09-08 15:32	2026-09-08 15:32	XBI	XBI260918C00165000	call	165.0000	2026-09-18	2.4000	2.3100	2.4000	162.6200	11520.00	11520.00	0.00	48	8	64	4281	0.0149497780892315	0.313649191249865	0.313649191249865	false	false	false	true
7aa0786d-df05-4ae0-ab8c-0cef4589315b	2026-09-08 12:01	2026-09-08 12:01	2026-09-08 12:01	XBI	XBI261016P00140000	put	140.0000	2026-10-16	0.6300	0.6300	0.7300	162.9600	28476.00	0.00	28476.00	452	38	461	911	0.506037321624588	0.347234541577882	0.347234541577882	false	false	false	true
8e73fc95-9191-41fa-9cbb-268ed6e06aaa	2026-09-08 11:30	2026-09-08 11:30	2026-09-08 11:30	XBI	XBI261218C00170000	call	170.0000	2026-12-18	7.7500	7.7000	8.1500	162.4100	411525.00	340225.00	71300.00	531	9	562	3876	0.14499484004128	0.299018659578974	0.299018659578974	false	false	false	true
3f5ece0f-63fc-4b1e-a259-9b5b42390d5d	2026-09-08 10:41	2026-09-08 10:41	2026-09-08 10:41	XBI	XBI260918P00143000	put	143.0000	2026-09-18	0.1100	0.1100	0.1300	162.4600	26928.00	0.00	26928.00	2448	26	2468	3620	0.681767955801105	0.406580010249234	0.406580010249234	false	false	false	true
9d5ffc17-1faf-4f25-948a-effa59f22249	2026-09-08 09:30	2026-09-08 09:30	2026-09-08 09:30	XBI	XBI260911P00159000	put	159.0000	2026-09-11	2.1700	1.8100	2.1700	159.1450	12585.00	12585.00	0.00	58	18	82	919	0.0892274211099021	0.393929300567085	0.393929300567085	true	false	false	true
cf630ca7-9250-443f-bfd4-c2a58dbf2ffc	2026-09-04 15:26	2026-09-04 15:26	2026-09-04 15:26	XBI	XBI260911P00163000	put	163.0000	2026-09-11	1.9100	1.9100	1.9200	163.8500	11078.00	0.00	9932.00	58	19	1594	31	51.4193548387097	0.261778488637881	0.261778488637881	false	false	false	true
2252305d-b370-4ca7-9aba-36f87aa1799c	2026-09-04 15:26	2026-09-04 15:26	2026-09-04 15:26	XBI	XBI260911P00163000	put	163.0000	2026-09-11	1.8800	1.7800	2.0600	163.8550	153402.00	149272.00	4130.00	816	34	1411	31	45.5161290322581	0.258648643431162	0.258648643431162	false	false	false	true
996d4df5-ca67-4388-9f73-6f93ee9a1642	2026-09-04 15:06	2026-09-04 15:06	2026-09-04 15:06	XBI	XBI260911P00162000	put	162.0000	2026-09-11	1.5000	1.5000	1.5100	163.7368	45000.00	0.00	45000.00	300	25	330	1127	0.292812777284827	0.256791002121008	0.256791002121008	false	false	false	true
3e33af79-49cc-42b7-89b3-6d382c2e8d8a	2026-09-04 14:00	2026-09-04 14:00	2026-09-04 14:00	XBI	XBI261218C00200000	call	200.0000	2026-12-18	1.6000	1.3300	1.6000	163.7400	19360.00	19360.00	0.00	121	21	133	9399	0.0141504415363337	0.293881884606601	0.293881884606601	false	false	false	true
9c25e8c6-0524-4bb7-a1a1-9ba59e31518c	2026-09-04 12:11	2026-09-04 12:11	2026-09-04 12:11	XBI	XBI260911P00163000	put	163.0000	2026-09-11	2.0800	1.8800	2.0800	163.5200	47424.00	47424.00	0.00	228	22	553	31	17.8387096774194	0.26458613291427	0.26458613291427	false	false	false	true
387cd1bc-d455-4a40-840a-65f8ba6baedc	2026-09-04 10:20	2026-09-04 10:20	2026-09-04 10:20	XBI	XBI261016P00153000	put	153.0000	2026-10-16	2.5000	2.2400	2.5400	163.6200	33000.00	1500.00	31500.00	132	10	132	42	3.14285714285714	0.313100013367825	0.313100013367825	false	false	false	true
886e294d-08bc-4727-8618-2f70dc01db37	2026-09-03 15:29	2026-09-03 15:29	2026-09-03 15:29	XBI	XBI261016C00160000	call	160.0000	2026-10-16	9.0500	9.0500	9.2500	163.4500	60635.00	0.00	60635.00	67	9	68	246	0.276422764227642	0.305850474188474	0.305850474188474	false	false	false	true
d70c797e-059a-4fdf-acfd-e0614a7ae04a	2026-09-03 15:16	2026-09-03 15:16	2026-09-03 15:16	XBI	XBI270115C00145000	call	145.0000	2027-01-15	24.7500	24.3000	25.1500	163.5500	37125.00	9900.00	27225.00	15	6	71	219	0.324200913242009	0.314374817104605	0.314374817104605	false	false	false	true
c78696ba-2123-4458-8230-21bb7d4d53dc	2026-09-03 14:34	2026-09-03 14:33	2026-09-03 14:33	XBI	XBI270115C00145000	call	145.0000	2027-01-15	24.7500	24.5000	25.0500	163.5600	37125.00	7425.00	29700.00	15	8	49	219	0.223744292237443	0.314098746362938	0.314098746362938	false	false	false	true
3f68f44a-9339-4a3f-8809-351f32b4c88c	2026-09-03 13:11	2026-09-03 13:10	2026-09-03 13:10	XBI	XBI260911P00162000	put	162.0000	2026-09-11	1.7200	1.6600	1.7200	163.9500	15480.00	15480.00	0.00	90	6	403	1002	0.402195608782435	0.273627269980311	0.273627269980311	true	false	false	true
022036e0-6c28-47f2-9732-dd9ff90a83ec	2026-09-03 09:31	2026-09-03 09:31	2026-09-03 09:31	XBI	XBI260918C00165000	call	165.0000	2026-09-18	4.0000	3.7500	4.0000	164.7050	40000.00	40000.00	0.00	100	14	100	4254	0.0235072872590503	0.301637241249865	0.301637241249865	false	false	false	true
d1d8652b-1434-4c83-a54a-ce447b4b6fa7	2026-09-02 15:32	2026-09-02 15:32	2026-09-02 15:32	XBI	XBI270319C00200000	call	200.0000	2027-03-19	5.4000	5.0500	5.5500	164.9400	31860.00	31860.00	0.00	59	6	466	27	17.2592592592593	0.31322859096204	0.31322859096204	true	false	false	true
af2af8c8-343f-493d-8a6d-99a2d02b254a	2026-09-02 15:31	2026-09-02 15:31	2026-09-02 15:31	XBI	XBI270319C00200000	call	200.0000	2027-03-19	5.4000	4.9500	5.6500	164.9100	77220.00	76680.00	540.00	143	6	407	27	15.0740740740741	0.313427292609792	0.313427292609792	true	false	false	true
0a14f9b7-2f67-4c72-ba1a-d3f28b16d1c9	2026-09-02 15:23	2026-09-02 15:23	2026-09-02 15:23	XBI	XBI260911P00154000	put	154.0000	2026-09-11	0.2600	0.2500	0.3000	164.8550	34476.00	208.00	34268.00	1326	31	1490	372	4.00537634408602	0.306425403641798	0.306425403641798	false	false	false	true
70cc03af-1e65-4b4b-a4e8-25b3ccce0e18	2026-09-02 14:36	2026-09-02 14:36	2026-09-02 14:36	XBI	XBI260911P00162000	put	162.0000	2026-09-11	1.9100	1.9100	1.9200	164.3300	19100.00	0.00	9168.00	100	7	1075	11	97.7272727272727	0.29249575325647	0.29249575325647	false	false	false	true
b65e6c95-b55a-4436-90be-f28a78445005	2026-09-02 14:36	2026-09-02 14:36	2026-09-02 14:36	XBI	XBI260911P00162000	put	162.0000	2026-09-11	1.9000	1.6800	1.9600	164.3400	19000.00	7600.00	7790.00	100	6	803	11	73	0.291834866097906	0.291834866097906	false	false	false	true
1bce4563-0248-4db0-b022-dd945ecd651e	2026-09-02 14:36	2026-09-02 14:36	2026-09-02 14:36	XBI	XBI260911P00162000	put	162.0000	2026-09-11	1.9000	1.9000	1.9100	164.3200	15960.00	0.00	15960.00	84	6	687	11	62.4545454545455	0.291087425092354	0.291087425092354	false	false	false	true
fd1e8282-6b41-407d-9ab2-6a2e995e8cfa	2026-09-02 14:36	2026-09-02 14:36	2026-09-02 14:36	XBI	XBI260911P00162000	put	162.0000	2026-09-11	1.9500	1.9500	2.1000	164.2400	19500.00	0.00	7020.00	100	6	127	11	11.5454545454545	0.293243243178013	0.293243243178013	false	false	false	true
97727ab0-41a2-4bc7-b41d-02c450f87287	2026-09-02 14:36	2026-09-02 14:36	2026-09-02 14:36	XBI	XBI260911P00162000	put	162.0000	2026-09-11	1.9400	1.8300	1.9500	164.2400	92192.00	77600.00	14592.00	476	23	603	11	54.8181818181818	0.292212771145559	0.290150714698482	true	false	false	true
2e50de68-2a19-4dac-a42e-a3532508aaa6	2026-09-02 14:29	2026-09-02 14:29	2026-09-02 14:29	XBI	XBI260904P00162000	put	162.0000	2026-09-04	0.8800	0.8200	0.8800	163.9701	69872.00	69872.00	0.00	794	36	1133	213	5.31924882629108	0.352669274601577	0.352669274601577	true	false	false	true
55c2660f-dcc2-4901-9c04-13d6e8493768	2026-09-02 13:44	2026-09-02 13:43	2026-09-02 13:43	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.4500	6.4500	6.6500	163.4200	13545.00	0.00	13545.00	21	9	264	1634	0.16156670746634	0.301854304493177	0.301854304493177	false	false	false	true
ee018f32-f410-4f87-b4fd-8889d1131fca	2026-09-02 12:07	2026-09-02 12:06	2026-09-02 12:06	XBI	XBI260918P00158000	put	158.0000	2026-09-18	2.0700	2.0400	2.2300	163.3700	71415.00	38088.00	33327.00	345	16	11258	1560	7.21666666666667	0.321880944287896	0.321880944287896	false	false	false	true
8f9c0eee-30c7-4804-aa19-a7c8f0c2c8f0	2026-09-02 12:05	2026-09-02 12:05	2026-09-02 12:05	XBI	XBI260925P00157500	put	157.5000	2026-09-25	2.6400	2.6300	3.7000	163.3300	11616.00	0.00	11616.00	44	5	54	0	0	0.321687607960925	0.321687607960925	false	false	false	true
793ace1e-501c-41a0-914c-d8413096cb53	2026-09-02 12:03	2026-09-02 12:03	2026-09-02 12:03	XBI	XBI260925P00159000	put	159.0000	2026-09-25	3.2000	3.0500	3.2000	163.3400	14720.00	14720.00	0.00	46	14	50	20	2.5	0.324130745491517	0.324130745491517	false	false	false	true
aeef2815-20c1-48b2-9640-c32a026fc32e	2026-09-02 11:52	2026-09-02 11:52	2026-09-02 11:52	XBI	XBI270115C00150000	call	150.0000	2027-01-15	20.9000	20.5500	21.2000	163.0700	33440.00	8360.00	25080.00	16	5	86	3810	0.0225721784776903	0.31561721383301	0.31561721383301	false	false	false	true
3ca516ac-0a9b-4edc-85fb-3b7beb3e10cf	2026-09-02 11:25	2026-09-02 11:25	2026-09-02 11:25	XBI	XBI260904P00163000	put	163.0000	2026-09-04	1.9000	1.7200	1.9000	162.5100	19000.00	19000.00	0.00	100	5	1115	1503	0.741849634065203	0.345895489165668	0.345895489165668	true	false	false	true
e0b9877f-2c51-4124-a68f-f3bd153d1178	2026-09-02 11:24	2026-09-02 11:23	2026-09-02 11:23	XBI	XBI260911C00164000	call	164.0000	2026-09-11	2.3000	2.3000	2.4200	162.6000	10350.00	0.00	10350.00	45	5	45	30	1.5	0.281756697826077	0.281756697826077	true	false	false	true
02e4f815-a375-45dc-ab2d-efd215ba2691	2026-09-02 11:15	2026-09-02 11:15	2026-09-02 11:15	XBI	XBI260918P00160000	put	160.0000	2026-09-18	2.8900	2.7300	2.8900	162.3600	19074.00	19074.00	0.00	66	20	414	10183	0.0406559952862614	0.302658099464777	0.302658099464777	false	false	false	true
4041b0af-44ff-46dc-91db-791f6b34d242	2026-09-02 11:02	2026-09-02 11:02	2026-09-02 11:02	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.3300	1.1700	1.3300	162.4700	12901.00	12901.00	0.00	97	23	254	13663	0.0185903535094782	0.308328807798879	0.308328807798879	false	false	false	true
1b16a270-c657-435e-af14-272e5580c5d0	2026-09-02 09:57	2026-09-02 09:57	2026-09-02 09:57	XBI	XBI261009C00160000	call	160.0000	2026-10-09	9.7500	9.7500	11.8500	165.4500	16575.00	0.00	16575.00	17	5	17	0	0	0.303790474089346	0.303790474089346	true	false	false	true