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

bdfa4dec-0cfd-4439-a073-4d559c5b5030	2026-08-19 15:41	2026-08-19 15:41	2026-08-19 15:41	XBI	XBI260821C00170000	call	170.0000	2026-08-21	1.8000	1.7000	1.8400	169.5500	79200.00	20160.00	59040.00	440	6	2505	5594	0.44780121558813	0.399079541924322	0.399079541924322	false	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-19T19:47:06.720571Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
79448c01-e608-4a50-9b6b-d7e76fc00049	2026-08-19 15:59	2026-08-19 15:58	2026-08-19 15:58	XBI	XBI260918P00160000	put	160.0000	2026-09-18	2.3700	2.1700	2.4000	169.4550	30810.00	6873.00	23937.00	130	20	1392	1612	0.863523573200993	0.32431348785315	0.32431348785315	false	false	false	true	false
0a545dc9-8ef8-4030-a4e7-f80e8d2ce839	2026-08-19 15:59	2026-08-19 15:58	2026-08-19 15:58	XBI	XBI260918P00160000	put	160.0000	2026-09-18	2.3700	2.3700	2.7600	169.4550	212589.00	0.00	13746.00	897	70	1262	1612	0.78287841191067	0.32431348785315	0.32431348785315	false	false	false	true	false
7ce7ef9f-d304-49b3-9ce6-e7a6f48dd029	2026-08-19 15:59	2026-08-19 15:59	2026-08-19 15:59	XBI	XBI260918P00160000	put	160.0000	2026-09-18	2.3200	2.3200	2.5900	169.5750	17864.00	0.00	17864.00	77	15	2207	1612	1.36910669975186	0.3229233207942	0.3229233207942	false	false	false	true	false
b7ac8134-f14d-4811-bf45-6d7071d56578	2026-08-19 15:59	2026-08-19 15:59	2026-08-19 15:59	XBI	XBI260918P00160000	put	160.0000	2026-09-18	2.3700	2.3700	2.5900	169.5750	113523.00	0.00	40053.00	479	36	2686	1612	1.66625310173697	0.326227527247226	0.326227527247226	false	false	false	true	false
61d5f922-a9e8-4725-bbf2-e92305e837eb	2026-08-19 15:59	2026-08-19 15:59	2026-08-19 15:59	XBI	XBI260918P00160000	put	160.0000	2026-09-18	2.3700	2.1700	2.4700	169.5700	125373.00	111153.00	14220.00	529	13	3215	1612	1.99441687344913	0.32614789327695	0.32614789327695	false	false	false	true	false
604da1e5-3ddd-4cea-bd06-03df07dfbea5	2026-08-20 09:47	2026-08-20 09:47	2026-08-20 09:47	XBI	XBI261016P00159000	put	159.0000	2026-10-16	5.0000	4.2500	5.0750	165.4100	36500.00	36500.00	0.00	73	12	109	22	4.95454545454545	0.320789299299831	0.320084849550174	false	false	false	true	false
b80f77fb-a8e5-4fe8-b4d2-bb25749dab83	2026-08-20 09:47	2026-08-20 09:47	2026-08-20 09:47	XBI	XBI270115C00150000	call	150.0000	2027-01-15	23.9500	22.7500	23.9500	165.1400	23950.00	23950.00	0.00	10	5	10	3658	0.00273373428102788	0.338581323263704	0.338581323263704	false	false	false	true	false
40c375e4-c0c2-49af-b97a-264702e7eda3	2026-08-20 09:50	2026-08-20 09:50	2026-08-20 09:50	XBI	XBI260821P00162000	put	162.0000	2026-08-21	0.4100	0.4100	0.5800	165.9000	33456.00	0.00	33456.00	816	12	862	134	6.43283582089552	0.495218317864632	0.495218317864632	false	false	false	true	false
674cc754-96b0-4180-b1da-00c69e993248	2026-08-20 10:10	2026-08-20 10:10	2026-08-20 10:10	XBI	XBI260821C00168000	call	168.0000	2026-08-21	0.5500	0.5500	0.7100	164.8700	17600.00	0.00	17600.00	320	27	608	8950	0.0679329608938548	0.478594016685625	0.478594016685625	false	false	false	true	false
a09158dd-7616-4bbf-baaf-b50817fbe532	2026-08-20 11:05	2026-08-20 11:05	2026-08-20 11:05	XBI	XBI260821C00168000	call	168.0000	2026-08-21	0.4500	0.3500	0.6200	164.9100	32940.00	0.00	32940.00	732	18	1540	8950	0.172067039106145	0.436227300204357	0.436227300204357	false	false	false	true	false
4a2476f6-05b7-48ba-9d77-3c59b94a3112	2026-08-20 11:05	2026-08-20 11:05	2026-08-20 11:05	XBI	XBI261016C00165000	call	165.0000	2026-10-16	8.5000	8.5000	8.7500	164.9000	38250.00	0.00	38250.00	45	7	195	995	0.195979899497487	0.310789767875604	0.310789767875604	false	false	false	true	false
b3286225-777f-426b-8153-cbc2b81d2b57	2026-08-20 11:05	2026-08-20 11:05	2026-08-20 11:05	XBI	XBI261016C00165000	call	165.0000	2026-10-16	8.6000	8.5000	8.6000	164.9300	68800.00	68800.00	0.00	80	7	295	995	0.296482412060302	0.31402856046293	0.31402856046293	false	false	false	true	false
adc8fced-301a-4137-a2e3-46bd93f7493d	2026-08-20 11:06	2026-08-20 11:06	2026-08-20 11:06	XBI	XBI261016C00165000	call	165.0000	2026-10-16	8.6400	8.5500	8.7000	164.9900	77785.00	0.00	77785.00	90	5	657	995	0.660301507537688	0.312768448030045	0.31470226151786	false	false	false	true	false
bc8f7379-c24f-4708-bd8a-6dec672335c9	2026-08-20 12:29	2026-08-20 12:29	2026-08-20 12:29	XBI	XBI260821C00166000	call	166.0000	2026-08-21	0.5400	0.5400	0.6200	163.5500	12474.00	0.00	12474.00	231	22	683	861	0.793263646922184	0.418981529120587	0.418981529120587	false	false	false	true	false
c833a69f-688c-4c57-88b7-ba9a8b7e9638	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.5200	2.2200	2.5300	163.3650	26748.00	26748.00	0.00	106	7	1154	8286	0.139271059618634	0.331838545839845	0.331169925732751	true	false	false	true	false
3916bd26-3034-4fe9-8186-821c3a771b79	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.5200	2.2600	2.5300	163.3650	14134.00	14134.00	0.00	56	7	1210	8286	0.146029447260439	0.331838545839845	0.331169925732751	true	false	false	true	false
6230346d-dc7f-4cb9-9a34-dfa12b15c41f	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.5200	2.2600	2.5200	163.5200	59976.00	59976.00	0.00	238	17	1534	8286	0.185131547188028	0.333864598011178	0.333864598011178	true	false	false	true	false
14b85037-af40-4aa1-87b9-fc4418faf5fb	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.5200	2.2600	2.5300	163.5200	30777.00	8349.00	22428.00	122	12	1823	8286	0.220009654839488	0.334535020356964	0.333864598011178	true	false	false	true	false
f325d53f-f46a-44d9-9fd8-ed491eb356df	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.5300	2.2600	2.5300	163.5000	12638.00	12638.00	0.00	50	9	1873	8286	0.226043929519672	0.334187747648417	0.333517557526989	true	false	false	true	false
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	false
d11f2eed-f009-47d2-a52f-5dda5ec881c1	2026-08-20 13:30	2026-08-20 13:30	2026-08-20 13:30	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.6100	2.6000	2.8300	162.6500	31544.00	0.00	31544.00	121	6	4022	8286	0.485397055273956	0.325165920847968	0.323852701205994	false	false	false	true	false
25e2fdab-5066-482c-9543-fdd20eba0bd7	2026-08-20 13:30	2026-08-20 13:30	2026-08-20 13:30	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.6000	2.6000	2.8200	162.6100	40897.00	0.00	40897.00	157	8	4279	8286	0.516413227130099	0.323793288807684	0.323136930162526	false	false	false	true	false
28e1d99b-b284-4cd2-8677-d8705f7a8bb0	2026-08-20 13:30	2026-08-20 13:30	2026-08-20 13:30	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.6600	2.3500	2.7000	162.6550	19940.00	2385.00	17555.00	75	5	4540	8286	0.547912140960657	0.327877214814702	0.327222377469398	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
4084a02d-c1ac-46f8-8085-21c4950b0682	2026-08-21 10:31	2026-08-21 10:31	2026-08-21 10:31	XBI	XBI260918C00178000	call	178.0000	2026-09-18	2.0000	1.3400	2.4600	167.6350	53420.00	2018.00	51402.00	267	11	267	63	4.23809523809524	0.293154506996615	0.297842462192518	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
4143e393-6380-44cf-902a-c7f9cd3b4fd6	2026-08-21 14:24	2026-08-21 14:23	2026-08-21 14:23	XBI	XBI260918C00160000	call	160.0000	2026-09-18	8.9000	8.8500	9.6500	165.0000	267000.00	0.00	267000.00	300	2	312	3986	0.078273958855996	0.294521769871806	0.294521769871806	false	true	true	false	false
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	false