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:alert_rule = RepeatedHitsAscendingFill×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	expiry

72075f1d-2ce1-4769-925e-34d8ada1504b	2026-08-18 09:56	2026-08-18 09:56	2026-08-18 09:56	XBI	XBI260821C00160000	call	160.0000	2026-08-21	1.9400	1.5000	2.2000	160.0000	70789.00	36905.00	33884.00	364	10	369	7121	0.0518185648083134	0.3240672758135	0.334438897773384	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	10834097622.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
62e767a5-83a1-479d-879a-3d252f6b7b8d	2026-08-19 09:30	2026-08-19 09:30	2026-08-19 09:30	XBI	XBI260821C00165000	call	165.0000	2026-08-21	2.6900	2.1400	2.7700	166.0700	38770.00	34675.00	4095.00	144	20	160	3461	0.0462294134643167	0.423767792857216	0.438407249099235	true	false	false	true
7a0ff08d-ae9b-4d70-83e3-5bc7516c23bd	2026-08-19 09:31	2026-08-19 09:31	2026-08-19 09:31	XBI	XBI260821P00163000	put	163.0000	2026-08-21	0.9000	0.9000	0.9600	165.9240	13689.00	819.00	990.00	152	15	1410	2	705	0.42176719198987	0.424196218817362	true	false	false	true
c38d5ffb-80bb-4014-b110-286147c3fbc7	2026-08-19 11:31	2026-08-19 11:31	2026-08-19 11:31	XBI	XBI260918C00165000	call	165.0000	2026-09-18	7.2000	7.1500	7.5500	166.8400	526376.00	0.00	526376.00	731	28	1319	4598	0.2868638538495	0.314150415323103	0.314150415323103	false	false	false	true
a6d95ded-0bcf-44ea-b3dc-ad6526b2459f	2026-08-19 13:26	2026-08-19 13:25	2026-08-19 13:25	XBI	XBI260918C00165000	call	165.0000	2026-09-18	7.2000	7.2000	7.3000	167.0800	215297.00	0.00	215297.00	299	35	3370	4598	0.732927359721618	0.306643368359282	0.306643368359282	false	false	false	true
fa63dda5-5749-4e09-a16b-03254020e95e	2026-08-19 14:20	2026-08-19 14:19	2026-08-19 14:19	XBI	XBI260918C00160000	call	160.0000	2026-09-18	10.4000	10.3500	10.9000	167.2600	45773.00	3120.00	42653.00	44	5	250	4150	0.0602409638554217	0.305310089330553	0.305930648214997	false	false	false	true
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
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
fdb8cba3-fa57-4c0c-8017-7cd1f45366b9	2026-08-25 10:48	2026-08-25 10:48	2026-08-25 10:48	XBI	XBI260828C00170000	call	170.0000	2026-08-28	2.2500	2.0800	2.3700	169.3300	22470.00	22470.00	0.00	100	7	109	761	0.14323258869908	0.413454297464191	0.413454297464191	false	false	false	true
34a771d9-f545-44ce-9464-f885055aec88	2026-08-25 14:45	2026-08-25 14:45	2026-08-25 14:45	XBI	XBI261016C00165000	call	165.0000	2026-10-16	10.4900	10.4000	10.5500	168.6250	78639.00	67155.00	11484.00	75	17	303	2342	0.129376601195559	0.317918328412124	0.321199931077842	false	false	false	true
ff15bbc2-949e-4406-a3da-010ce84e6d34	2026-08-25 15:50	2026-08-25 15:50	2026-08-25 15:50	XBI	XBI260904P00165000	put	165.0000	2026-09-04	2.2500	2.0200	2.2500	168.8200	22722.00	22498.00	224.00	101	14	322	27	11.9259259259259	0.355580636087074	0.356566874499906	false	false	false	true
bdd6979c-5d50-425a-9251-f0a297e4d88c	2026-08-26 09:35	2026-08-26 09:35	2026-08-26 09:35	XBI	XBI260918C00175000	call	175.0000	2026-09-18	2.5400	2.5300	2.6700	167.0600	105283.00	255.00	105028.00	414	15	501	7891	0.0634900519579268	0.32180053218812	0.32180053218812	false	false	false	true
5e1f2661-d44b-4b7c-8ce5-e2457502a03f	2026-08-27 09:58	2026-08-27 09:57	2026-08-27 09:57	XBI	XBI260918C00175000	call	175.0000	2026-09-18	2.4000	2.3900	2.6200	167.3300	14629.00	8400.00	1917.00	61	16	102	8772	0.0116279069767442	0.313203750523405	0.313900077174258	false	false	false	true
9927c912-20b1-4a81-aebc-bb6279bd88c0	2026-08-27 15:24	2026-08-27 15:24	2026-08-27 15:24	XBI	XBI261016P00155000	put	155.0000	2026-10-16	2.6500	2.6500	2.7500	168.0000	42982.00	6675.00	36307.00	162	32	203	168	1.20833333333333	0.327046388144971	0.328143775600626	false	false	false	true
29ea1b30-ee4c-4810-b539-064ca110f632	2026-08-28 09:41	2026-08-28 09:41	2026-08-28 09:41	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.7300	1.3500	1.7400	165.9100	30471.00	30471.00	0.00	176	26	195	4001	0.0487378155461135	0.619107122925454	0.625162795462536	true	false	false	true
be3e500d-7458-49ed-8065-14b7ebfcbd1d	2026-08-28 10:04	2026-08-28 10:04	2026-08-28 10:04	XBI	XBI261016P00159000	put	159.0000	2026-10-16	4.5500	4.5500	4.7000	165.1300	169735.00	0.00	169735.00	373	34	447	172	2.59883720930233	0.318307648900119	0.318307648900119	false	false	false	true
e42b754d-cd3f-444c-aa77-b6e893468c7f	2026-08-28 10:47	2026-08-28 10:47	2026-08-28 10:47	XBI	XBI260918P00150000	put	150.0000	2026-09-18	0.6900	0.4700	0.6900	164.2600	22274.00	22207.00	67.00	325	20	503	15191	0.033111710881443	0.321552112657395	0.321552112657395	false	false	false	true
af57af68-3851-4a4a-8016-1808ba2800b4	2026-08-28 15:23	2026-08-28 15:23	2026-08-28 15:23	XBI	XBI271217P00140000	put	140.0000	2027-12-17	10.8200	9.6000	11.1500	162.5950	19475.00	17300.00	2175.00	18	7	25	48	0.520833333333333	0.341547174208408	0.342421024924916	false	false	false	true
1f9e3c10-3694-48a3-84d7-e84f166cc7aa	2026-08-31 09:31	2026-08-31 09:31	2026-08-31 09:31	XBI	XBI261016C00185000	call	185.0000	2026-10-16	1.0100	0.8700	1.3100	160.8900	40505.00	0.00	30605.00	400	7	500	6690	0.0747384155455904	0.309214203998193	0.311816873665354	false	false	false	true
2b14fa5f-9620-4c2a-9744-9174b67b99f7	2026-09-01 14:30	2026-09-01 14:29	2026-09-01 14:29	XBI	XBI261218C00165000	call	165.0000	2026-12-18	10.9000	10.4500	10.9000	162.7550	34868.00	34868.00	0.00	32	8	47	2394	0.0196324143692565	0.31266556815366	0.31266556815366	false	false	false	true
8711a74d-a0f4-449c-93b6-4c77fe53216a	2026-09-02 11:29	2026-09-02 11:29	2026-09-02 11:29	XBI	XBI260918P00158000	put	158.0000	2026-09-18	2.3800	1.8100	2.2800	162.6900	1196065.00	1190809.00	5256.00	5024	26	10398	1560	6.66538461538462	0.320702924388274	0.317373081247968	true	false	false	true
c6065669-da4b-4508-b94f-4d858ea92e0b	2026-09-03 12:54	2026-09-03 12:54	2026-09-03 12:54	XBI	XBI270115P00150000	put	150.0000	2027-01-15	5.8900	5.7000	6.1500	164.3350	88342.00	0.00	88342.00	150	5	300	4024	0.0745526838966203	0.330430443688485	0.330430443688485	false	false	false	true
23d1a81a-f016-496c-9de3-f3e6cf192305	2026-09-08 09:30	2026-09-08 09:30	2026-09-08 09:30	XBI	XBI260918P00158000	put	158.0000	2026-09-18	3.0200	2.2100	3.0500	159.0400	32345.00	30845.00	1500.00	107	18	134	16919	0.00792008983982505	0.34124887132983	0.34607280455752	true	false	false	true
54be5bf1-fad9-4bc9-a34f-f8cb4ea25f0c	2026-09-10 09:55	2026-09-10 09:55	2026-09-10 09:55	XBI	XBI261218C00185000	call	185.0000	2026-12-18	2.1000	1.9200	2.2800	157.4400	31470.00	29380.00	2090.00	150	19	167	1140	0.146491228070175	0.287109271262993	0.287580162443015	false	false	false	true
da8bd940-dd3a-420d-a116-4917d3ba03a1	2026-09-10 09:55	2026-09-10 09:55	2026-09-10 09:55	XBI	XBI261218C00185000	call	185.0000	2026-12-18	2.1300	1.9400	2.2300	157.4400	141033.00	11271.00	90094.00	662	91	829	1140	0.72719298245614	0.287580162443015	0.289923179524081	true	false	false	true
3298b900-aaba-49f9-9923-f1912ee4b212	2026-09-10 09:55	2026-09-10 09:55	2026-09-10 09:55	XBI	XBI261218C00185000	call	185.0000	2026-12-18	2.1100	2.0900	2.1400	157.5550	36124.00	5724.00	27008.00	171	34	1000	1140	0.87719298245614	0.287094172042705	0.287562622267332	false	false	false	true
4b6b1e83-c00c-4955-a47e-b9cbf2417c03	2026-09-10 10:11	2026-09-10 10:11	2026-09-10 10:11	XBI	XBI260918P00175000	put	175.0000	2026-09-18	17.1700	16.9000	19.3000	157.8400	51510.00	3430.00	41220.00	30	8	30	211	0.14218009478673	0.382292590476456	0.384784833624907	true	false	false	true
051d0d70-00c5-449f-bd6a-10ee42e6c345	2026-09-10 10:20	2026-09-10 10:20	2026-09-10 10:20	XBI	XBI261016C00169000	call	169.0000	2026-10-16	2.0600	1.7100	2.3300	157.9200	16310.00	1890.00	14420.00	79	7	79	301	0.262458471760797	0.286644247131602	0.289788502925235	false	false	false	true
61d4ceb1-3725-4b19-be1e-325b3c2968a5	2026-09-11 09:33	2026-09-11 09:33	2026-09-11 09:33	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.2900	1.0900	1.3000	158.0000	11628.00	11628.00	0.00	90	6	368	15405	0.0238883479389808	0.324017180311681	0.32535811342878	false	false	false	true
1eab3666-f1ef-496f-a829-0e76e56cd0c1	2026-09-11 09:33	2026-09-11 09:33	2026-09-11 09:33	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.2300	1.1700	1.5400	158.0000	17078.00	9334.00	369.00	139	25	959	15405	0.0622525154170724	0.318347890610956	0.319706460812119	false	false	false	true
b6aed4bc-0336-415c-831c-3c4751e91af3	2026-09-11 09:33	2026-09-11 09:33	2026-09-11 09:33	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.2300	1.1700	1.2300	158.0000	12028.00	9090.00	0.00	98	12	1072	15405	0.0695877961700747	0.319286018151041	0.320645942020487	false	false	false	true
18f0c33e-37f1-4962-b2cf-37e0b9b7a2d6	2026-09-11 09:34	2026-09-11 09:33	2026-09-11 09:33	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.2500	1.2400	1.5400	158.0000	49886.00	127.00	49759.00	399	8	1501	15405	0.0974358974358974	0.318422033247628	0.321122501293596	false	false	false	true
7a193211-4b9d-4e4e-925f-619a199ebb9b	2026-09-11 09:36	2026-09-11 09:36	2026-09-11 09:36	XBI	XBI260918C00162000	call	162.0000	2026-09-18	1.6200	1.3700	1.7500	159.0000	194027.00	194027.00	0.00	1200	16	1204	237	5.08016877637131	0.314701858096184	0.319602642262985	false	false	false	true
3b779365-5e72-4e3c-b311-31fb7fc38ca4	2026-09-11 14:46	2026-09-11 14:46	2026-09-11 14:46	XBI	XBI260918P00154000	put	154.0000	2026-09-18	1.2600	1.1400	1.3900	157.2900	31589.00	17660.00	13929.00	250	20	1280	626	2.04472843450479	0.30325827035638	0.30325827035638	false	false	false	true
cc19f359-5085-4d99-9ec5-291f7ce7aff1	2026-09-15 11:21	2026-09-15 11:20	2026-09-15 11:20	XBI	XBI260918P00155000	put	155.0000	2026-09-18	3.0000	2.9900	3.1000	153.2800	351611.00	50400.00	301211.00	1172	65	10302	20445	0.503888481291269	0.369273002520326	0.369273002520326	true	false	false	true
a7c0cd39-c048-4261-87cf-6ab2f7ef973c	2026-09-16 14:17	2026-09-16 14:17	2026-09-16 14:17	XBI	XBI260918C00160000	call	160.0000	2026-09-18	0.2000	0.2000	0.3400	154.6100	21275.00	1224.00	20051.00	1051	41	1435	3591	0.399610136452242	0.360023066232075	0.378734072548457	false	false	false	true
b1492306-ad44-41ce-8ec9-ae8dd25b0b55	2026-09-16 15:21	2026-09-16 15:21	2026-09-16 15:21	XBI	XBI260918P00150000	put	150.0000	2026-09-18	0.8200	0.6800	0.8300	152.9301	89047.00	85712.00	3335.00	1087	42	2007	10359	0.193744569939183	0.433052909028795	0.43701392457881	true	false	false	true
f1c9e5e0-94b2-413b-a714-8715d7b9fd9e	2026-09-18 11:58	2026-09-18 11:58	2026-09-18 11:58	XBI	XBI261016P00155000	put	155.0000	2026-10-16	4.2400	4.1000	4.3000	156.7300	16976.00	16976.00	0.00	40	5	40	823	0.0486026731470231	0.306421069382073	0.306421069382073	false	false	false	true
8c8f8cfc-ead2-4863-b4ef-97d5dbeb32d4	2026-09-18 14:22	2026-09-18 14:22	2026-09-18 14:22	XBI	XBI261016P00155000	put	155.0000	2026-10-16	4.3000	4.2500	4.4000	156.6100	35255.00	27085.00	3010.00	82	9	439	823	0.533414337788578	0.306404939919475	0.306994490874803	false	false	false	true
4c9d9841-cb82-4cd4-81aa-9a4f9469522c	2026-09-22 14:14	2026-09-22 14:14	2026-09-22 14:14	XBI	XBI261016P00153000	put	153.0000	2026-10-16	1.6500	1.6100	1.6500	162.0500	12371.00	12210.00	161.00	75	5	750	6367	0.117794879849223	0.308935476696277	0.312242736945401	false	false	false	true