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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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

38dcd0b4-5981-4a9b-8fbc-a8c2e341eb35	2026-09-21 10:35	2026-09-21 10:35	2026-09-21 10:35	XBI	XBI261030C00161000	call	161.0000	2026-10-30	5.8000	5.5000	5.8000	159.1500	45240.00	45240.00	0.00	78	6	277	13	21.3076923076923	0.305315140659952	0.305315140659952	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	10339868055.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
6821d0c9-f267-4b0f-a6bd-e15697275f06	2026-09-21 10:23	2026-09-21 10:23	2026-09-21 10:23	XBI	XBI261016C00168000	call	168.0000	2026-10-16	1.8200	1.8200	1.8400	158.0000	46228.00	0.00	46228.00	254	9	268	1096	0.244525547445255	0.294330545150453	0.294330545150453	false	false	false	true
f6fb1dab-ac48-4ba5-a9be-923861df606e	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	XBI	XBI261016C00165000	call	165.0000	2026-10-16	2.7000	2.5700	2.7500	158.9500	13770.00	270.00	13500.00	51	9	64	2299	0.0278381905176164	0.297810235627999	0.296803366616822	true	false	false	true
5ee2a24b-2cba-4e6f-bc9c-045c7de24f76	2026-09-18 15:53	2026-09-18 15:53	2026-09-18 15:53	XBI	XBI261016C00143000	call	143.0000	2026-10-16	14.5000	14.5000	15.7500	156.0000	47850.00	0.00	47850.00	33	6	35	355	0.0985915492957746	0.311327696740694	0.311327696740694	false	false	false	true
f0c84c34-ddb8-44fb-8353-0cca7357a6bf	2026-09-18 15:04	2026-09-18 15:04	2026-09-18 15:04	XBI	XBI261218C00175000	call	175.0000	2026-12-18	3.6000	3.4000	3.6000	156.6700	54720.00	54720.00	0.00	152	15	177	3383	0.0523204256577003	0.295670027490309	0.295670027490309	false	false	false	true
1b91cb6f-0645-44fc-b846-ea0291d93306	2026-09-18 14:32	2026-09-18 14:31	2026-09-18 14:31	XBI	XBI270115C00175000	call	175.0000	2027-01-15	4.8500	4.8000	4.9500	156.7800	29585.00	29100.00	485.00	61	13	433	4038	0.107231302625062	0.293733749188965	0.293733749188965	false	false	false	true
80891428-7a72-405a-bde1-6b60cc06eed6	2026-09-18 14:21	2026-09-18 14:21	2026-09-18 14:21	XBI	XBI270115C00175000	call	175.0000	2027-01-15	4.8500	4.7500	4.9500	156.6300	148895.00	145985.00	2910.00	307	28	311	4038	0.0770183259039128	0.29521177156686	0.29521177156686	false	false	false	true
2f38bc16-3e5c-432c-b033-a6e45de06b05	2026-09-18 13:40	2026-09-18 13:40	2026-09-18 13:40	XBI	XBI261218C00170000	call	170.0000	2026-12-18	4.7000	4.6000	4.7000	156.3600	141470.00	141470.00	0.00	301	29	328	6052	0.0541969596827495	0.293365893689358	0.293365893689358	false	false	false	true
d344b103-0c0f-47c2-af8d-cc5ddf5c4bce	2026-09-18 13:11	2026-09-18 13:11	2026-09-18 13:11	XBI	XBI261016P00150000	put	150.0000	2026-10-16	2.6500	2.5800	2.8600	156.2650	21464.00	16164.00	5300.00	81	19	432	17682	0.0244316253817441	0.316871040964859	0.316297519467894	true	false	false	true
16f9584f-d045-4846-879f-acb9bdde6304	2026-09-18 13:08	2026-09-18 13:07	2026-09-18 13:07	XBI	XBI261016P00155000	put	155.0000	2026-10-16	4.3500	4.3000	4.3500	156.4350	20445.00	20445.00	0.00	47	5	339	823	0.411907654921021	0.305576296717995	0.305576296717995	false	false	false	true
79e5268a-9779-4719-9bb8-a77ea21561a0	2026-09-18 13:08	2026-09-18 13:07	2026-09-18 13:07	XBI	XBI261016P00155000	put	155.0000	2026-10-16	4.4000	4.3000	4.4000	156.4400	25960.00	25960.00	0.00	59	18	259	823	0.314702308626974	0.308645189269812	0.308645189269812	false	false	false	true
ac6c3253-0a33-4c9e-89c3-ffae66e58157	2026-09-18 12:33	2026-09-18 12:32	2026-09-18 12:32	XBI	XBI261016P00150000	put	150.0000	2026-10-16	2.6000	2.5500	2.6000	156.0100	78000.00	78000.00	0.00	300	5	316	17682	0.0178712815292388	0.308580447307505	0.308580447307505	false	false	false	true
1ad741b5-30fd-4403-924b-f94174794f3b	2026-09-18 12:18	2026-09-18 12:18	2026-09-18 12:18	XBI	XBI260918C00155000	call	155.0000	2026-09-18	1.3500	1.1000	1.3900	156.0000	135405.00	135405.00	0.00	1003	17	1549	9892	0.156591184795795	0.371179642269973	0.371179642269973	false	false	false	true
99f1b2b8-7fdd-4dad-ba0e-77e1b52c164f	2026-09-18 12:17	2026-09-18 12:17	2026-09-18 12:17	XBI	XBI260918C00155000	call	155.0000	2026-09-18	1.3700	1.3700	1.3800	156.0000	28496.00	0.00	28496.00	208	7	507	9892	0.0512535382126971	0.374731740665608	0.374731740665608	true	false	false	true
da25fb1d-4386-458e-b19d-349f593bf0af	2026-09-18 12:17	2026-09-18 12:17	2026-09-18 12:17	XBI	XBI260918C00155000	call	155.0000	2026-09-18	1.3700	1.2500	1.5000	156.0000	16851.00	14659.00	2192.00	123	14	298	9892	0.0301253538212697	0.374717459911722	0.374717459911722	false	false	false	true
f81ea840-90f1-4a0d-8783-9d1f8c9d807d	2026-09-18 12:01	2026-09-18 12:01	2026-09-18 12:01	XBI	XBI260918C00134000	call	134.0000	2026-09-18	22.6000	22.6000	22.9500	156.6050	472340.00	0.00	472340.00	209	9	251	372	0.674731182795699	4.60217864488616	4.61578670514609	true	false	false	true
42975225-8bb5-40c8-b135-cd24ae3becae	2026-09-18 11:42	2026-09-18 11:42	2026-09-18 11:42	XBI	XBI270115C00160000	call	160.0000	2027-01-15	10.4000	10.3500	10.6500	157.0700	38480.00	18720.00	19760.00	37	6	1990	1182	1.68358714043993	0.300543856349931	0.300543856349931	false	false	false	true
9b7c733b-fb54-469c-85a1-6ec43afd9149	2026-09-18 11:40	2026-09-18 11:40	2026-09-18 11:40	XBI	XBI270115C00160000	call	160.0000	2027-01-15	10.3500	10.2000	10.4000	157.0900	1592855.00	1591830.00	1025.00	1539	43	1808	1182	1.52961082910321	0.298851072355455	0.296051794101991	false	false	false	true
79c1b784-6852-487d-89b5-e99a889b1a03	2026-09-17 14:05	2026-09-17 14:05	2026-09-17 14:05	XBI	XBI260918P00156000	put	156.0000	2026-09-18	0.5900	0.5900	0.7000	157.8100	21063.00	0.00	21063.00	357	25	15332	3201	4.78975320212434	0.396831461303682	0.398356350881434	false	false	false	true
6dfa2577-27be-4695-8e38-5ddfa8cd5eaf	2026-09-17 13:57	2026-09-17 13:57	2026-09-17 13:57	XBI	XBI261016C00165000	call	165.0000	2026-10-16	2.6500	2.5200	2.7100	157.6800	166950.00	128525.00	38425.00	630	5	1225	1675	0.73134328358209	0.29718772914424	0.29718772914424	false	false	false	true
f187fb57-f2e5-4887-bfd3-8b47a0a280a5	2026-09-17 13:51	2026-09-17 13:51	2026-09-17 13:51	XBI	XBI260918P00158000	put	158.0000	2026-09-18	1.5300	1.4900	1.6700	157.6300	12546.00	0.00	12546.00	82	7	7734	11324	0.682974214058637	0.408540638368039	0.408540638368039	false	false	false	true
4f7a8a0b-1d37-4e34-b692-83952ca924a6	2026-09-17 13:31	2026-09-17 13:31	2026-09-17 13:31	XBI	XBI260918P00158000	put	158.0000	2026-09-18	1.6100	1.6100	1.7600	157.5100	12397.00	0.00	12397.00	77	16	7203	11324	0.636082656305193	0.413036418884113	0.413036418884113	false	false	false	true
cbbb6b6f-3b98-4bce-b64a-5c4a994da6bb	2026-09-17 13:11	2026-09-17 13:11	2026-09-17 13:11	XBI	XBI260918P00158000	put	158.0000	2026-09-18	1.5500	1.5500	1.6400	157.6000	17050.00	0.00	17050.00	110	13	7126	11324	0.629282938890851	0.40970909448875	0.40970909448875	false	false	false	true
dcaf8c35-cb78-4271-b9e2-4b7716a5a1e0	2026-09-17 12:28	2026-09-17 12:28	2026-09-17 12:28	XBI	XBI260918C00158000	call	158.0000	2026-09-18	1.4300	1.4300	1.6700	157.9800	75504.00	0.00	75504.00	528	39	579	775	0.747096774193548	0.433919821268882	0.433919821268882	false	false	false	true
4a1d9718-8bbd-4e8d-a203-2a66684db3bd	2026-09-17 12:20	2026-09-17 12:20	2026-09-17 12:20	XBI	XBI260925P00150000	put	150.0000	2026-09-25	0.4700	0.4700	0.5000	158.3900	15245.00	0.00	15245.00	323	10	2658	11498	0.231170638371891	0.32689578311241	0.328998288704829	false	false	false	true
2b8c236e-29c5-4f46-a49c-2302e4e3a95b	2026-09-17 12:19	2026-09-17 12:19	2026-09-17 12:19	XBI	XBI260918C00160000	call	160.0000	2026-09-18	0.8500	0.8500	1.0000	158.5400	24905.00	0.00	24905.00	293	25	1041	4479	0.232417950435365	0.438809608606361	0.438809608606361	false	false	false	true
5d5aa75c-e3d4-4ffd-a3c1-638ab8c970d4	2026-09-17 11:57	2026-09-17 11:57	2026-09-17 11:57	XBI	XBI261016C00155000	call	155.0000	2026-10-16	7.9000	7.9000	8.2000	158.7250	13430.00	0.00	13430.00	17	5	1047	215	4.86976744186047	0.314750300133212	0.314750300133212	false	false	false	true
dd28b595-a0d9-4672-abfd-0e55a4e88d5d	2026-09-17 11:46	2026-09-17 11:46	2026-09-17 11:46	XBI	XBI260918P00158000	put	158.0000	2026-09-18	1.0000	1.0000	1.1600	159.2400	70400.00	0.00	70400.00	704	17	6177	11324	0.545478629459555	0.467406742231762	0.467406742231762	true	false	false	true
8bb774af-821d-48af-b657-3ed5badd676e	2026-09-17 11:39	2026-09-17 11:39	2026-09-17 11:39	XBI	XBI260918P00156000	put	156.0000	2026-09-18	0.3400	0.3400	0.3800	159.2750	33626.00	0.00	33626.00	989	42	9327	3201	2.91377694470478	0.430740481618152	0.430740481618152	true	false	false	true
0ca6dc9b-d11c-4ec8-98b6-f474b481c26d	2026-09-17 11:39	2026-09-17 11:39	2026-09-17 11:39	XBI	XBI260918P00156000	put	156.0000	2026-09-18	0.3800	0.3600	0.4200	159.2591	42142.00	1824.00	38342.00	1109	19	7468	3201	2.33302093095908	0.44742055231521	0.447761087538235	false	false	false	true
1935b417-e6a1-44d7-a57b-723c8a56e1c6	2026-09-17 11:32	2026-09-17 11:32	2026-09-17 11:32	XBI	XBI260918P00156000	put	156.0000	2026-09-18	0.3700	0.3700	0.4800	159.2200	29230.00	0.00	29230.00	790	34	6291	3201	1.96532333645736	0.440005024174688	0.440005024174688	true	false	false	true
ed698011-b18d-40b5-9741-12206e11b269	2026-09-17 11:28	2026-09-17 11:28	2026-09-17 11:28	XBI	XBI260918P00158000	put	158.0000	2026-09-18	1.0400	1.0400	1.1800	159.0400	50648.00	0.00	50648.00	487	35	4890	11324	0.431826209819852	0.456227224029425	0.456227224029425	false	false	false	true
ba997811-6d64-46a4-ac0a-5d3c352d953f	2026-09-17 11:28	2026-09-17 11:28	2026-09-17 11:28	XBI	XBI260918P00160000	put	160.0000	2026-09-18	2.0000	2.0000	2.2100	159.0400	15800.00	0.00	15800.00	79	21	315	9407	0.0334857021367067	0.444701047090339	0.444701047090339	false	false	false	true
7c9f4da5-03d9-4cd7-99ff-ede4aa5a2f18	2026-09-17 11:17	2026-09-17 11:17	2026-09-17 11:17	XBI	XBI260918P00158000	put	158.0000	2026-09-18	0.9800	0.9800	1.1300	159.2700	43904.00	0.00	43904.00	448	35	4357	11324	0.384758036029672	0.464537134212615	0.464537134212615	false	false	false	true
8b4487f9-1a67-48d5-aedd-4e434dd367b8	2026-09-17 11:09	2026-09-17 11:09	2026-09-17 11:09	XBI	XBI261002P00158000	put	158.0000	2026-10-02	3.4000	2.9900	3.4000	159.1800	33999.00	33999.00	0.00	100	13	100	37	2.7027027027027	0.318286100697013	0.318286100697013	false	false	false	true
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
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