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

a7ec8d65-6db5-4b66-8141-0ce2c4fc22f1	2026-09-17 10:51	2026-09-17 10:51	2026-09-17 10:51	XBI	XBI260918P00158000	put	158.0000	2026-09-18	0.7500	0.7500	0.8800	160.0500	16500.00	0.00	16500.00	220	15	3357	11324	0.296450017661604	0.473469345531611	0.473469345531611	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	10392887206.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
a7bb1756-1ecf-4967-8d04-57efb0ee0a05	2026-09-17 10:49	2026-09-17 10:49	2026-09-17 10:49	XBI	XBI261016C00168000	call	168.0000	2026-10-16	2.4500	2.4500	2.4900	159.7900	11025.00	0.00	11025.00	45	15	567	1526	0.371559633027523	0.296418555721565	0.296418555721565	false	false	false	true
d9d6ca17-a72c-4ea9-9a67-fb2a063c5857	2026-09-17 10:49	2026-09-17 10:49	2026-09-17 10:49	XBI	XBI261016C00168000	call	168.0000	2026-10-16	2.4600	2.4600	2.5000	159.7900	10086.00	0.00	984.00	41	16	522	1526	0.342070773263434	0.297055514139142	0.297055514139142	false	false	false	true
ada17a06-b431-402f-94ad-294e10ded456	2026-09-17 10:49	2026-09-17 10:49	2026-09-17 10:49	XBI	XBI261016C00168000	call	168.0000	2026-10-16	2.4500	2.4500	2.5000	159.7650	12005.00	0.00	1470.00	49	16	481	1526	0.315203145478375	0.29689864655174	0.29689864655174	false	false	false	true
fee941bc-0403-425c-b277-3ccfaecfdfa8	2026-09-17 10:49	2026-09-17 10:49	2026-09-17 10:49	XBI	XBI261016C00168000	call	168.0000	2026-10-16	2.4100	2.4100	2.4500	159.7100	13978.00	0.00	8194.00	58	19	375	1526	0.245740498034076	0.295396880103293	0.295396880103293	false	false	false	true
8e8501e4-095e-444c-bfd8-942956a8dddf	2026-09-17 10:49	2026-09-17 10:49	2026-09-17 10:49	XBI	XBI261016C00168000	call	168.0000	2026-10-16	2.4000	2.4000	2.4400	159.7100	13680.00	0.00	11520.00	57	15	432	1526	0.283093053735256	0.294756449472658	0.294756449472658	false	false	false	true
1e635ecc-a1c6-4525-a47a-fa7903031af7	2026-09-17 10:47	2026-09-17 10:47	2026-09-17 10:47	XBI	XBI261016C00168000	call	168.0000	2026-10-16	2.4000	2.4000	2.4400	159.7900	12000.00	0.00	960.00	50	26	112	1526	0.073394495412844	0.293227241773342	0.293227241773342	true	false	false	true
f32ae2bb-ba74-480b-a477-13600030c456	2026-09-17 10:45	2026-09-17 10:45	2026-09-17 10:45	XBI	XBI260918P00155000	put	155.0000	2026-09-18	0.2400	0.2400	0.3200	159.6200	23736.00	0.00	23736.00	989	46	1347	9334	0.14431112063424	0.483566771123336	0.483566771123336	false	false	false	true
97713012-de2e-438b-b047-935d505a6da2	2026-09-17 10:42	2026-09-17 10:41	2026-09-17 10:41	XBI	XBI260918P00158000	put	158.0000	2026-09-18	0.8800	0.8800	1.1000	159.7228	42856.00	0.00	42856.00	487	5	2517	11324	0.222271282232427	0.482935707252986	0.482935707252986	true	false	false	true
1cdccbad-9c3a-44bb-bf2a-ab6adc99180d	2026-09-17 10:36	2026-09-17 10:36	2026-09-17 10:36	XBI	XBI260918C00157000	call	157.0000	2026-09-18	3.1000	3.0500	3.6500	159.4600	12400.00	0.00	11160.00	40	9	2102	2762	0.761042722664736	0.471654011409916	0.471654011409916	false	false	false	true
3c32c447-5420-4a81-a7c8-0965dd34ec38	2026-09-17 10:35	2026-09-17 10:35	2026-09-17 10:35	XBI	XBI260918P00158000	put	158.0000	2026-09-18	0.9500	0.8200	0.9500	159.6800	38000.00	38000.00	0.00	400	30	500	11324	0.0441540091840339	0.501302545088848	0.501302545088848	true	false	false	true
e8309a9c-c07c-470a-bb1f-7014e306d428	2026-09-17 10:30	2026-09-17 10:30	2026-09-17 10:30	XBI	XBI260918C00157000	call	157.0000	2026-09-18	3.3500	3.2750	3.3500	159.6700	227465.00	227465.00	0.00	679	5	1926	2762	0.697320782041999	0.506556305496044	0.506556305496044	false	false	false	true
c94fdc41-192e-45c6-8307-94731a1d5ac2	2026-09-17 10:16	2026-09-17 10:16	2026-09-17 10:16	XBI	XBI260925P00150000	put	150.0000	2026-09-25	0.4700	0.4700	0.5500	158.6300	29634.00	3408.00	26226.00	629	10	1071	11498	0.0931466341972517	0.333040566252109	0.335164766452918	false	false	false	true
c6a9cce5-44c9-4bb7-ad5a-8072e5517a74	2026-09-17 10:13	2026-09-17 10:13	2026-09-17 10:13	XBI	XBI261016P00150000	put	150.0000	2026-10-16	2.2100	2.0400	2.2100	158.4000	345865.00	345865.00	0.00	1565	21	1590	16257	0.0978040228824506	0.321037697814155	0.321037697814155	false	false	false	true
b3e481d2-369f-4651-9ad4-30b7368ea9d9	2026-09-17 10:03	2026-09-17 10:03	2026-09-17 10:03	XBI	XBI260918P00156000	put	156.0000	2026-09-18	0.7200	0.6300	0.7200	158.1650	28800.00	28800.00	0.00	400	13	4223	3201	1.31927522649172	0.480693397172549	0.480693397172549	true	false	false	true
82e2993d-82ed-4f2c-bf4b-a30ced982bc5	2026-09-17 10:03	2026-09-17 10:02	2026-09-17 10:02	XBI	XBI260918P00156000	put	156.0000	2026-09-18	0.7400	0.7400	0.7900	158.0300	21460.00	0.00	21460.00	290	5	3723	3201	1.1630740393627	0.473907552966699	0.473907552966699	true	false	false	true
401753c8-68e4-4e34-99dd-facd98a62ef0	2026-09-17 10:02	2026-09-17 10:01	2026-09-17 10:01	XBI	XBI261016C00155000	call	155.0000	2026-10-16	7.4000	7.4000	7.6000	158.2700	14800.00	0.00	14800.00	20	7	881	215	4.09767441860465	0.302128128535621	0.302128128535621	true	false	false	true
c8ca8286-64b5-4b10-aa8d-da682adf04a5	2026-09-17 10:00	2026-09-17 10:00	2026-09-17 10:00	XBI	XBI260925P00157500	put	157.5000	2026-09-25	2.5000	2.3000	3.3000	158.2700	50000.00	0.00	50000.00	200	14	300	64	4.6875	0.314484652237594	0.314484652237594	false	false	false	true
b345d0b1-5af2-4ec0-9a6d-6c6e59071eab	2026-09-17 09:57	2026-09-17 09:56	2026-09-17 09:56	XBI	XBI260918P00156000	put	156.0000	2026-09-18	0.7800	0.6100	0.7800	158.1000	70200.00	70200.00	0.00	900	38	2623	3201	0.81943142767885	0.495143814088533	0.495143814088533	true	false	false	true
a178dd9d-3002-46e4-8a12-e5799725b7d6	2026-09-17 09:56	2026-09-17 09:56	2026-09-17 09:56	XBI	XBI261016C00155000	call	155.0000	2026-10-16	7.6400	7.4000	7.6500	158.2400	11465.00	11465.00	0.00	15	5	789	215	3.66976744186047	0.318010265627843	0.318010265627843	false	false	false	true
b99f46bc-2b03-4e79-a668-3878219d03c4	2026-09-17 09:45	2026-09-17 09:45	2026-09-17 09:45	XBI	XBI260918P00151000	put	151.0000	2026-09-18	0.0800	0.0800	0.1700	157.8500	10112.00	0.00	10112.00	1264	40	1670	5951	0.280625105024366	0.507713830207687	0.507713830207687	false	false	false	true
a6212a62-dae1-4c8f-9af8-934f1de34af8	2026-09-16 15:35	2026-09-16 15:35	2026-09-16 15:35	XBI	XBI260918P00150000	put	150.0000	2026-09-18	0.6500	0.6500	0.8200	153.6050	12351.00	0.00	12351.00	190	11	3536	10359	0.341345689738392	0.435764616107172	0.435764616107172	true	false	false	true
d1f2e057-e335-43a1-a39c-3f531475bc1b	2026-09-16 15:29	2026-09-16 15:29	2026-09-16 15:29	XBI	XBI260918P00150000	put	150.0000	2026-09-18	0.7500	0.7500	0.8200	152.8750	37125.00	0.00	37125.00	495	23	3332	10359	0.321652669176561	0.414164216147843	0.414164216147843	false	false	false	true
056c1746-f9de-4119-94f9-73b072bbc150	2026-09-16 15:29	2026-09-16 15:29	2026-09-16 15:29	XBI	XBI260918P00155000	put	155.0000	2026-09-18	2.9400	2.9400	3.2000	152.8750	52332.00	0.00	52332.00	178	30	2510	12163	0.206363561621311	0.372382841081863	0.372382841081863	false	false	false	true
a604146d-24c9-418a-a1f7-462a87cf11a3	2026-09-16 15:29	2026-09-16 15:29	2026-09-16 15:29	XBI	XBI260918P00150000	put	150.0000	2026-09-18	0.8000	0.7500	0.8000	152.8750	16560.00	16560.00	0.00	207	9	2837	10359	0.273868133989767	0.427686642539422	0.427686642539422	false	false	false	true
2c468d84-f110-4257-85f0-ae47d6658731	2026-09-16 15:29	2026-09-16 15:29	2026-09-16 15:29	XBI	XBI260918P00150000	put	150.0000	2026-09-18	0.8000	0.8000	0.9000	152.8750	11440.00	0.00	11440.00	143	6	2258	10359	0.217974707983396	0.427686642539422	0.427686642539422	true	false	false	true
02bda4ce-ea38-4781-938b-50eee9a7b76a	2026-09-16 15:29	2026-09-16 15:29	2026-09-16 15:29	XBI	XBI260918P00154000	put	154.0000	2026-09-18	2.4500	2.4500	2.5700	152.7000	33075.00	0.00	33075.00	135	18	3212	1750	1.83542857142857	0.385133526354645	0.385133526354645	false	false	false	true
de61dbe3-3439-4c21-b646-d0943c0c50a7	2026-09-16 15:29	2026-09-16 15:28	2026-09-16 15:28	XBI	XBI260918P00154000	put	154.0000	2026-09-18	2.5100	2.5100	2.5800	152.6600	15060.00	0.00	15060.00	60	17	3004	1750	1.71657142857143	0.393346354414692	0.393346354414692	false	false	false	true
1e26abb6-b6fb-4619-8725-c616c2e86047	2026-09-16 15:22	2026-09-16 15:22	2026-09-16 15:22	XBI	XBI260918P00155000	put	155.0000	2026-09-18	3.0500	2.9500	3.0500	152.9950	40870.00	40870.00	0.00	134	6	2211	12163	0.181780810655266	0.418738023953634	0.418738023953634	true	false	false	true
0b73a082-5209-4f5a-8146-4f3c435b6362	2026-09-16 15:13	2026-09-16 15:13	2026-09-16 15:13	XBI	XBI260918P00154000	put	154.0000	2026-09-18	2.2500	2.2500	2.4600	153.1700	10125.00	0.00	10125.00	45	11	2462	1750	1.40685714285714	0.402206094543146	0.402206094543146	false	false	false	true
5e2b7003-6909-4f3f-979a-71fae988ec97	2026-09-16 15:08	2026-09-16 15:07	2026-09-16 15:07	XBI	XBI260918P00153000	put	153.0000	2026-09-18	1.8000	1.8000	1.8600	153.3300	16380.00	0.00	7200.00	91	22	1431	1785	0.801680672268908	0.436970313953142	0.436970313953142	true	false	false	true
94ce9539-db91-4b85-85f4-a610c42a1e6e	2026-09-16 15:07	2026-09-16 15:07	2026-09-16 15:07	XBI	XBI260918P00153000	put	153.0000	2026-09-18	1.7500	1.7500	1.7900	153.3500	21000.00	0.00	21000.00	120	22	1330	1785	0.745098039215686	0.427936699953027	0.427936699953027	true	false	false	true
89564451-0b04-4d21-a5ba-43acf6a6d585	2026-09-16 15:07	2026-09-16 15:07	2026-09-16 15:07	XBI	XBI260918P00153000	put	153.0000	2026-09-18	1.7200	1.7200	1.7900	153.3800	25284.00	0.00	25284.00	147	22	1210	1785	0.677871148459384	0.424348557509527	0.424348557509527	true	false	false	true
6f5e7da7-4800-4a06-a921-893eb54a1970	2026-09-16 15:07	2026-09-16 15:07	2026-09-16 15:07	XBI	XBI260918P00153000	put	153.0000	2026-09-18	1.7200	1.7200	1.7900	153.3800	18920.00	0.00	16512.00	110	16	1018	1785	0.5703081232493	0.424348557509527	0.424348557509527	true	false	false	true
94112117-fac3-4f15-a9bf-c4587bedf78f	2026-09-16 14:59	2026-09-16 14:59	2026-09-16 14:59	XBI	XBI260925P00150000	put	150.0000	2026-09-25	1.7200	1.4900	1.7200	153.6400	121776.00	121776.00	0.00	708	10	7591	3100	2.44870967741935	0.344048775245347	0.344048775245347	false	false	false	true
c601a641-1176-4e14-a7f9-7fbd8a3ca416	2026-09-16 14:59	2026-09-16 14:59	2026-09-16 14:59	XBI	XBI260925P00150000	put	150.0000	2026-09-25	1.6900	1.6900	1.7900	153.7100	12506.00	0.00	2535.00	74	5	6676	3100	2.15354838709677	0.343081453393406	0.343081453393406	false	false	false	true
c5869b5f-ab04-4585-a4ea-7298d53d69e4	2026-09-16 14:59	2026-09-16 14:59	2026-09-16 14:59	XBI	XBI260925P00150000	put	150.0000	2026-09-25	1.7000	1.4900	1.7800	153.7400	17170.00	680.00	14960.00	101	8	6777	3100	2.18612903225806	0.345347413611094	0.345347413611094	false	false	false	true
f1cb2dc2-949c-40ef-9784-ac870c28ba2c	2026-09-16 14:58	2026-09-16 14:58	2026-09-16 14:58	XBI	XBI260925P00150000	put	150.0000	2026-09-25	1.6600	1.6600	1.8000	153.8000	67728.00	0.00	62416.00	408	10	6560	3100	2.11612903225806	0.342803244507877	0.342803244507877	false	false	false	true
64ce8a3e-8799-49c8-bdce-de8e4b30a280	2026-09-16 14:57	2026-09-16 14:57	2026-09-16 14:57	XBI	XBI260918P00152000	put	152.0000	2026-09-18	0.9500	0.4200	0.9500	154.0750	16244.00	16244.00	0.00	171	21	233	1159	0.201035375323555	0.401052821631089	0.401052821631089	true	false	false	true
234d059f-dc26-4dc4-b224-d780234d984a	2026-09-16 14:35	2026-09-16 14:35	2026-09-16 14:35	XBI	XBI260925P00150000	put	150.0000	2026-09-25	1.2800	1.2100	1.2900	154.9100	182165.00	124437.00	0.00	1423	26	5517	3100	1.77967741935484	0.334311215799508	0.335589998697902	false	false	false	true
54193c91-4d5b-4952-bb9c-3381205aa12f	2026-09-16 14:27	2026-09-16 14:27	2026-09-16 14:27	XBI	XBI260918C00155000	call	155.0000	2026-09-18	1.6600	1.5400	1.7600	154.9800	83000.00	79680.00	3320.00	500	6	565	10751	0.0525532508603851	0.361268543219473	0.361268543219473	true	false	false	true
f9245b09-3bad-437a-9d54-4e517facdf51	2026-09-16 14:14	2026-09-16 14:14	2026-09-16 14:14	XBI	XBI260925P00150000	put	150.0000	2026-09-25	1.3000	1.0900	1.3000	154.7000	288340.00	288340.00	0.00	2218	11	2502	3100	0.807096774193548	0.329957037498752	0.329957037498752	false	false	false	true
a847a31b-4cbf-4203-b6d2-987be9ee88d1	2026-09-16 14:11	2026-09-16 14:11	2026-09-16 14:11	XBI	XBI260918C00157000	call	157.0000	2026-09-18	0.8600	0.8600	0.9300	154.9750	37915.00	6525.00	31390.00	440	19	1845	975	1.89230769230769	0.36262513919354	0.365054654067518	false	false	false	true
db7dc648-49b2-454c-8231-77ff4038eb4a	2026-09-16 13:39	2026-09-16 13:39	2026-09-16 13:39	XBI	XBI260918P00154000	put	154.0000	2026-09-18	1.2300	1.1500	1.2300	155.2400	123000.00	123000.00	0.00	1000	35	1007	1750	0.575428571428571	0.393218112103145	0.393218112103145	false	false	false	true
d7dab0ff-4b01-4f05-b046-7264fa06829c	2026-09-16 13:04	2026-09-16 13:04	2026-09-16 13:04	XBI	XBI261218C00181000	call	181.0000	2026-12-18	2.1600	1.9500	2.4300	155.1864	73008.00	72576.00	432.00	338	28	338	39	8.66666666666667	0.292145006272046	0.292145006272046	false	false	false	true
9539ad8f-8fd1-4290-abd3-dd4ab77298fa	2026-09-16 13:04	2026-09-16 13:04	2026-09-16 13:04	XBI	XBI261218C00180000	call	180.0000	2026-12-18	2.3500	2.1000	2.3500	155.1864	21620.00	21620.00	0.00	92	28	94	4062	0.0231413096996553	0.29395342962356	0.29395342962356	false	false	false	true
e63b47b1-a0b6-4672-8b80-6f1eb181bd85	2026-09-16 12:57	2026-09-16 12:57	2026-09-16 12:57	XBI	XBI261218C00175000	call	175.0000	2026-12-18	3.2000	3.1500	3.2000	155.1950	33280.00	33280.00	0.00	104	16	507	4327	0.117171250288884	0.291766117059235	0.291766117059235	false	false	false	true
d22d38e7-4e57-4d39-91f9-019b855277c8	2026-09-16 12:43	2026-09-16 12:43	2026-09-16 12:43	XBI	XBI261218C00175000	call	175.0000	2026-12-18	3.2000	3.1500	3.2000	155.2350	45120.00	45120.00	0.00	141	11	142	4327	0.0328171943609891	0.291363162214863	0.291363162214863	false	false	false	true
43a72646-cd02-4af9-a951-7fb61a120942	2026-09-16 12:03	2026-09-16 12:03	2026-09-16 12:03	XBI	XBI270115C00190000	call	190.0000	2027-01-15	1.9400	1.7300	1.9400	155.4550	42874.00	42874.00	0.00	221	32	224	4584	0.0488656195462478	0.29290969186397	0.29290969186397	false	false	false	true
67a3de0c-85d6-449c-8728-0ea24f047484	2026-09-16 12:00	2026-09-16 12:00	2026-09-16 12:00	XBI	XBI261016C00154000	call	154.0000	2026-10-16	5.8800	5.8500	6.5500	155.3800	29395.00	0.00	12285.00	50	5	50	77	0.649350649350649	0.274874196498255	0.274874196498255	false	false	false	true