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

8cefc316-6274-4429-8ac5-baf6486de7cb	2026-08-24 11:40	2026-08-24 11:40	2026-08-24 11:40	XBI	XBI260918C00162500	call	162.5000	2026-09-18	6.7000	5.7500	6.7000	164.3350	16080.00	16080.00	0.00	24	7	24	0	0	0.322735680065748	0.322735680065748	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	10834097622.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b30bd311-148a-4aa8-89a2-d6da108bbc5c	2026-08-24 11:38	2026-08-24 11:38	2026-08-24 11:38	XBI	XBI260918C00173000	call	173.0000	2026-09-18	2.3700	2.1300	2.7300	164.2700	65176.00	3319.00	61857.00	275	14	282	261	1.08045977011494	0.316139184980709	0.316139184980709	false	false	false	true
fcdc2ce0-32c8-4ee7-b334-1daab641efdc	2026-08-24 11:29	2026-08-24 11:29	2026-08-24 11:29	XBI	XBI261016C00167000	call	167.0000	2026-10-16	6.8000	6.6000	6.8000	163.5850	57800.00	57800.00	0.00	85	11	87	122	0.713114754098361	0.318904427767763	0.318904427767763	false	false	false	true
02140072-1437-408f-a9b0-325ffacba682	2026-08-24 11:25	2026-08-24 11:25	2026-08-24 11:25	XBI	XBI261016C00175000	call	175.0000	2026-10-16	4.1500	4.1500	4.4500	163.8800	43160.00	0.00	43160.00	104	5	106	287	0.369337979094077	0.321624918625255	0.321624918625255	true	false	false	true
f04fe67a-b130-4cd3-8b5c-8900b594df32	2026-08-24 11:21	2026-08-24 11:21	2026-08-24 11:21	XBI	XBI260918P00160000	put	160.0000	2026-09-18	3.7000	3.4500	3.7000	163.8400	275650.00	275650.00	0.00	745	25	4806	6247	0.769329278053466	0.330091352744225	0.330091352744225	false	false	false	true
2ee87443-1ae2-482b-82ed-422da9e16d72	2026-08-24 11:15	2026-08-24 11:15	2026-08-24 11:15	XBI	XBI261016C00165000	call	165.0000	2026-10-16	7.8500	7.6500	7.9500	163.8800	22765.00	3140.00	8635.00	29	7	437	1928	0.226659751037344	0.319324019890213	0.319324019890213	false	false	false	true
b376f2ce-9d7a-4bfc-844d-44aea478ab1c	2026-08-24 11:15	2026-08-24 11:15	2026-08-24 11:15	XBI	XBI261016C00165000	call	165.0000	2026-10-16	7.8500	7.6500	8.0000	163.8800	13345.00	3140.00	8635.00	17	5	408	1928	0.211618257261411	0.319324019890213	0.319324019890213	false	false	false	true
87950081-d675-450b-9dff-1b3dce35bbd9	2026-08-24 11:15	2026-08-24 11:14	2026-08-24 11:14	XBI	XBI261016C00165000	call	165.0000	2026-10-16	7.8300	7.6500	8.0500	163.9200	14885.00	3140.00	11745.00	19	7	391	1928	0.202800829875519	0.318487506119348	0.316478322882581	false	false	false	true
f6d6466f-46cf-4b82-8ad9-2ca874935beb	2026-08-24 11:14	2026-08-24 11:14	2026-08-24 11:14	XBI	XBI261016C00165000	call	165.0000	2026-10-16	7.8000	7.6000	7.9000	163.9050	230880.00	222300.00	3900.00	296	9	372	1928	0.192946058091286	0.31679202489271	0.31679202489271	false	false	false	true
cdcb4c8c-bb6e-4100-8586-f10e43e6b401	2026-08-24 11:14	2026-08-24 11:14	2026-08-24 11:14	XBI	XBI261016C00165000	call	165.0000	2026-10-16	7.8000	7.6000	7.9000	163.9050	12480.00	780.00	8580.00	16	5	76	1928	0.0394190871369295	0.31679202489271	0.31679202489271	false	false	false	true
26b986b0-46a4-488e-892b-b23d2b06a480	2026-08-24 10:45	2026-08-24 10:45	2026-08-24 10:45	XBI	XBI260918P00158000	put	158.0000	2026-09-18	3.2000	2.9300	3.2000	163.1550	166070.00	166070.00	0.00	519	42	1275	340	3.75	0.331241976844807	0.331241976844807	false	false	false	true
f080874a-0956-4975-b5ae-6b0d927ae354	2026-08-24 10:30	2026-08-24 10:30	2026-08-24 10:30	XBI	XBI260828P00162500	put	162.5000	2026-08-28	2.3300	2.3300	2.8000	163.0200	28892.00	0.00	28892.00	124	6	269	19	14.1578947368421	0.384566378200947	0.384566378200947	true	false	false	true
1738b907-7409-443c-8534-083547035222	2026-08-24 10:20	2026-08-24 10:20	2026-08-24 10:20	XBI	XBI260828P00162500	put	162.5000	2026-08-28	2.3400	2.3400	2.9300	163.0000	14040.00	0.00	14040.00	60	10	64	19	3.36842105263158	0.384693802463084	0.384693802463084	true	false	false	true
6be16064-9aef-4af6-a37c-1fdbc3f4c6b1	2026-08-24 10:04	2026-08-24 10:04	2026-08-24 10:04	XBI	XBI261016C00166000	call	166.0000	2026-10-16	6.3000	5.8500	6.4000	162.1250	13860.00	13230.00	630.00	22	10	26	60	0.433333333333333	0.309386091506951	0.309386091506951	true	false	false	true
71ce3d36-a122-40d9-add2-757082b6d256	2026-08-24 10:04	2026-08-24 10:04	2026-08-24 10:04	XBI	XBI260918P00150000	put	150.0000	2026-09-18	1.4000	1.1000	1.4500	161.7750	171080.00	171080.00	0.00	1222	36	1267	13871	0.091341648042679	0.33590440235676	0.33590440235676	false	false	false	true
6b724649-1d0d-4768-9cf4-04048e40e479	2026-08-24 09:58	2026-08-24 09:58	2026-08-24 09:58	XBI	XBI260904P00155000	put	155.0000	2026-09-04	0.5000	0.5000	1.7100	162.4300	10000.00	0.00	10000.00	200	14	200	35	5.71428571428571	0.255410061344423	0.255410061344423	false	false	false	true
2a100f4b-45e7-414b-b381-66381bcc47b9	2026-08-24 09:54	2026-08-24 09:54	2026-08-24 09:54	XBI	XBI260918C00160000	call	160.0000	2026-09-18	6.6000	6.5500	7.0500	162.0900	77880.00	7260.00	70620.00	118	16	505	4565	0.110624315443593	0.312860829033236	0.312860829033236	true	false	false	true
42fd8cc7-10b6-46b3-b18c-ea31cf0c3877	2026-08-24 09:54	2026-08-24 09:54	2026-08-24 09:54	XBI	XBI260918C00160000	call	160.0000	2026-09-18	6.6000	6.4500	6.6000	161.9800	50820.00	50820.00	0.00	77	23	379	4565	0.0830230010952902	0.316792931320926	0.316792931320926	true	false	false	true
18acc1fd-7736-4766-bdb2-9ab7bbe0ae9a	2026-08-24 09:53	2026-08-24 09:53	2026-08-24 09:53	XBI	XBI260918C00160000	call	160.0000	2026-09-18	6.6000	6.5500	6.7000	161.8500	68640.00	55440.00	13200.00	104	7	231	4565	0.0506024096385542	0.321399305959929	0.321399305959929	true	false	false	true
15d8d977-8b7e-4843-89e8-ea7cbb6d6866	2026-08-24 09:53	2026-08-24 09:53	2026-08-24 09:53	XBI	XBI260918C00160000	call	160.0000	2026-09-18	6.6000	6.5500	6.7000	162.0100	46860.00	40260.00	6600.00	71	10	302	4565	0.0661555312157722	0.315723731457836	0.315723731457836	true	false	false	true
51065e89-9590-477f-a9ba-e3c29cfc553d	2026-08-24 09:53	2026-08-24 09:53	2026-08-24 09:53	XBI	XBI260918C00160000	call	160.0000	2026-09-18	6.6000	6.5000	6.7000	161.8500	80520.00	67980.00	660.00	122	11	126	4565	0.0276013143483023	0.321399305959929	0.321399305959929	false	false	false	true
bae3edde-38b5-4008-a357-5c8b907e279c	2026-08-24 09:33	2026-08-24 09:32	2026-08-24 09:32	XBI	XBI270115C00150000	call	150.0000	2027-01-15	21.2000	21.0000	23.6000	162.7400	424000.00	72080.00	351920.00	200	5	200	3920	0.0510204081632653	0.315032039471161	0.315032039471161	false	false	false	true
b7fb06b3-ae8a-426d-a4e8-0aebeb1190e5	2026-08-21 15:22	2026-08-21 15:22	2026-08-21 15:22	XBI	XBI260821C00156000	call	156.0000	2026-08-21	9.9000	9.2500	10.1500	165.8800	11880.00	11880.00	0.00	12	8	53	434	0.122119815668203	3.25668719567653	3.25668719567653	false	false	false	true
4ece20fd-f188-47ae-93d4-b5dfded88ad2	2026-08-21 15:05	2026-08-21 15:05	2026-08-21 15:05	XBI	XBI261016P00165000	put	165.0000	2026-10-16	7.7500	7.5500	7.7500	165.3200	43400.00	43400.00	0.00	56	9	100	2001	0.0499750124937531	0.325586526956696	0.325586526956696	false	false	false	true
bee20dd9-60c4-4d18-915e-34481c8b8445	2026-08-21 15:00	2026-08-21 15:00	2026-08-21 15:00	XBI	XBI261016P00160000	put	160.0000	2026-10-16	5.4000	5.4000	5.5500	165.3400	25920.00	0.00	25920.00	48	16	236	68	3.47058823529412	0.32192557162313	0.32192557162313	false	false	false	true
a2db7462-78f9-4b83-9141-9107f9c32608	2026-08-21 14:51	2026-08-21 14:51	2026-08-21 14:51	XBI	XBI261016P00173000	put	173.0000	2026-10-16	12.2500	12.0500	12.7000	165.3900	19600.00	0.00	19600.00	16	6	16	0	0	0.32434509691067	0.32434509691067	false	false	false	true
193bee62-541f-4ffc-bd07-0f9e1994711a	2026-08-21 14:16	2026-08-21 14:16	2026-08-21 14:16	XBI	XBI261016P00160000	put	160.0000	2026-10-16	5.3500	5.3000	5.7500	165.0000	27285.00	12305.00	14980.00	51	11	188	68	2.76470588235294	0.321470679334088	0.321470679334088	false	false	false	true
1f19dca5-3a0d-4c65-85c6-bbed389dd6cc	2026-08-21 14:15	2026-08-21 14:15	2026-08-21 14:15	XBI	XBI260925C00164000	call	164.0000	2026-09-25	7.4500	7.4500	8.1500	165.0000	20115.00	0.00	20115.00	27	7	27	3	9	0.313704153508394	0.313704153508394	true	false	false	true
d12f76da-7396-4ed9-8f0f-792e51ae9561	2026-08-21 13:53	2026-08-21 13:53	2026-08-21 13:53	XBI	XBI260828C00170000	call	170.0000	2026-08-28	1.3900	1.3300	1.5000	165.9550	73670.00	139.00	73531.00	530	27	619	173	3.57803468208092	0.317446652077731	0.317446652077731	false	false	false	true
0a9862d7-519b-4591-8685-d94682ba08ee	2026-08-21 13:48	2026-08-21 13:48	2026-08-21 13:48	XBI	XBI261016P00172000	put	172.0000	2026-10-16	11.2000	11.2000	11.5500	166.2100	72800.00	0.00	72800.00	65	14	120	0	0	0.326343008245052	0.326343008245052	false	false	false	true
f7823e2d-3a35-489c-8905-ef54c129ebc4	2026-08-21 13:38	2026-08-21 13:38	2026-08-21 13:38	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.8300	1.7100	1.8600	165.9750	91500.00	7503.00	66978.00	500	13	2641	12524	0.210875119770042	0.330985448503773	0.330750130468607	true	false	false	true
0dca6f37-dc23-436f-a1ca-e4d08746b01a	2026-08-21 13:27	2026-08-21 13:26	2026-08-21 13:26	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.8100	1.7000	1.8500	166.1100	11222.00	181.00	11041.00	62	6	2141	12524	0.170951772596615	0.331561039734391	0.331326911091951	false	false	false	true
26c81943-549b-4216-bb66-48872643efbf	2026-08-21 12:58	2026-08-21 12:58	2026-08-21 12:58	XBI	XBI260918P00160000	put	160.0000	2026-09-18	2.9700	2.9700	3.0000	166.8000	33858.00	0.00	33858.00	114	20	270	5691	0.0474433315761729	0.327716052404197	0.327716052404197	false	false	false	true
65cff582-d98c-4e75-8746-fc9b91539e87	2026-08-21 11:46	2026-08-21 11:46	2026-08-21 11:46	XBI	XBI260821C00166000	call	166.0000	2026-08-21	1.1600	1.1600	1.4500	166.9150	47560.00	0.00	47560.00	410	35	871	1590	0.547798742138365	0.405375540920224	0.405375540920224	false	false	false	true
94edcc89-cd8e-4039-8c58-b1b1dcaa0a71	2026-08-21 11:46	2026-08-21 11:46	2026-08-21 11:46	XBI	XBI260821C00166000	call	166.0000	2026-08-21	1.1600	1.0500	1.1700	166.9150	10440.00	6960.00	1740.00	90	6	461	1590	0.289937106918239	0.405348631138157	0.405348631138157	false	false	false	true
532df0da-dbb3-47df-b49c-5114824b1365	2026-08-21 11:31	2026-08-21 11:31	2026-08-21 11:31	XBI	XBI260821P00167000	put	167.0000	2026-08-21	0.8900	0.8900	1.2000	166.6700	10235.00	0.00	10235.00	115	27	116	36	3.22222222222222	0.475294825430929	0.475294825430929	true	false	false	true
e12bffe8-93b8-4ad0-b013-fd523394d1be	2026-08-21 11:04	2026-08-21 11:04	2026-08-21 11:04	XBI	XBI260828P00166000	put	166.0000	2026-08-28	2.7900	2.7900	2.8200	166.7400	13113.00	0.00	13113.00	47	9	608	46	13.2173913043478	0.348532426240702	0.348532426240702	false	false	false	true
73260e4b-8c5c-42a8-9b93-7a3413d17331	2026-08-21 11:04	2026-08-21 11:04	2026-08-21 11:04	XBI	XBI260828P00166000	put	166.0000	2026-08-28	2.7700	2.7700	2.8400	166.7500	44320.00	0.00	18282.00	160	13	481	46	10.4565217391304	0.346832274687372	0.346832274687372	true	false	false	true
e52baea5-b0c2-4a5d-84a0-49b052811688	2026-08-21 11:04	2026-08-21 11:04	2026-08-21 11:04	XBI	XBI260828P00166000	put	166.0000	2026-08-28	2.7400	2.7400	2.8400	166.7000	20002.00	0.00	14248.00	73	6	313	46	6.80434782608696	0.341094529696075	0.341094529696075	false	false	false	true
b5552a24-021e-4bdd-a330-1bb54548d6d3	2026-08-21 11:04	2026-08-21 11:04	2026-08-21 11:04	XBI	XBI260828P00166000	put	166.0000	2026-08-28	2.7300	2.7300	2.8400	166.6800	59787.00	0.00	59787.00	219	9	240	46	5.21739130434783	0.33901589264197	0.33901589264197	true	false	false	true
1bb43bbf-3871-49ea-b595-9c8f7202a1aa	2026-08-21 10:37	2026-08-21 10:37	2026-08-21 10:37	XBI	XBI260918C00170000	call	170.0000	2026-09-18	4.9500	4.8500	4.9500	167.5800	24750.00	24750.00	0.00	50	7	836	7651	0.109266762514704	0.314891700385442	0.314891700385442	true	false	false	true
547e6d48-390c-4b74-8151-334b03c4da7b	2026-08-21 10:27	2026-08-21 10:26	2026-08-21 10:26	XBI	XBI260918C00170000	call	170.0000	2026-09-18	5.0000	5.0000	5.2000	167.5000	25000.00	0.00	25000.00	50	12	779	7651	0.101816755979611	0.318737349466866	0.319619075163969	true	false	false	true
8cee9a19-4f55-4cb8-a186-cbe6ef9d2a94	2026-08-21 10:23	2026-08-21 10:23	2026-08-21 10:23	XBI	XBI270319C00181000	call	181.0000	2027-03-19	12.2500	10.2000	12.8000	167.6300	60034.00	40425.00	19609.00	49	5	49	0	0	0.316992026088804	0.316764750952535	false	false	false	true
b89ff7ff-50f4-433b-ac66-02a5e503ccef	2026-08-21 10:10	2026-08-21 10:10	2026-08-21 10:10	XBI	XBI260918C00175000	call	175.0000	2026-09-18	2.8500	2.4200	3.1500	166.8150	38190.00	285.00	37905.00	134	7	134	6384	0.0209899749373434	0.313780577029404	0.3136841604889	false	false	false	true
f882173b-a3c1-4f6e-9186-37259efde8e8	2026-08-20 15:50	2026-08-20 15:50	2026-08-20 15:50	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.5000	2.2900	2.7100	163.3150	125000.00	0.00	112750.00	500	11	5605	8286	0.676442191648564	0.328960658999389	0.328960658999389	true	false	false	true
3515db39-0ecd-4dd7-892d-e23b014ef99a	2026-08-20 14:39	2026-08-20 14:39	2026-08-20 14:39	XBI	XBI260918P00146000	put	146.0000	2026-09-18	0.7800	0.7000	0.7800	163.1300	109902.00	109902.00	0.00	1409	32	2026	2515	0.805566600397614	0.33202043204921	0.33202043204921	true	false	false	true
1af62f0a-0140-427f-b599-84bdb3399909	2026-08-20 14:18	2026-08-20 14:18	2026-08-20 14:18	XBI	XBI260821C00165000	call	165.0000	2026-08-21	0.6300	0.6300	0.7300	163.1500	145215.00	0.00	145215.00	2305	33	2568	3466	0.740911713791114	0.39512077406231	0.39512077406231	false	false	false	true
104a6289-47e5-4f87-99a3-009c4d82ada1	2026-08-20 14:12	2026-08-20 14:12	2026-08-20 14:12	XBI	XBI261016C00160000	call	160.0000	2026-10-16	10.2000	9.9500	10.3500	163.0300	17340.00	12240.00	0.00	17	5	227	227	1	0.317474712154871	0.317474712154871	true	false	false	true
eebda410-ae87-4049-95d9-6f1ba5fe478c	2026-08-20 13:45	2026-08-20 13:45	2026-08-20 13:45	XBI	XBI261016C00160000	call	160.0000	2026-10-16	10.3000	9.7000	10.6000	163.2300	30900.00	16480.00	14420.00	30	7	207	227	0.911894273127753	0.316633831882948	0.316633831882948	false	false	false	true
d4b24b1a-e07e-4bcf-a522-42a00613b6fc	2026-08-20 13:09	2026-08-20 13:09	2026-08-20 13:09	XBI	XBI260821C00165000	call	165.0000	2026-08-21	0.6600	0.6600	0.8500	163.1500	11748.00	0.00	11748.00	178	30	235	3466	0.067801500288517	0.405216915979482	0.405216915979482	false	false	false	true