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

ff9e7e27-d858-406e-835a-a6f46297c72e	2026-08-28 10:33	2026-08-28 10:33	2026-08-28 10:33	XBI	XBI261016P00157000	put	157.0000	2026-10-16	4.0000	4.0000	4.3000	164.4000	43200.00	0.00	43200.00	108	15	114	158	0.721518987341772	0.31553550864114	0.31553550864114	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-28T14:38:22.875878Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c95ce65b-13ec-4d8e-80c0-159cdd0db24d	2026-08-28 10:24	2026-08-28 10:24	2026-08-28 10:24	XBI	XBI260828P00165000	put	165.0000	2026-08-28	1.0500	1.0400	1.3100	164.3300	10500.00	6615.00	1995.00	100	7	3640	2595	1.40269749518304	0.400259544053895	0.400259544053895	false	false	false	true
067a4e46-100c-4388-a89b-a6d1d1e835ce	2026-08-28 10:24	2026-08-28 10:24	2026-08-28 10:24	XBI	XBI260828P00165000	put	165.0000	2026-08-28	1.1300	0.9800	1.1300	164.3325	10057.00	10057.00	0.00	89	6	3246	2595	1.25086705202312	0.452858319045865	0.452858319045865	false	false	false	true
bde8e481-1a9f-45f0-acd0-20fe0ea2d197	2026-08-28 10:18	2026-08-28 10:18	2026-08-28 10:18	XBI	XBI260828P00165000	put	165.0000	2026-08-28	1.1000	1.0900	1.1000	164.3900	11000.00	11000.00	0.00	100	7	2978	2595	1.147591522158	0.453001068945591	0.453001068945591	false	false	false	true
b13300ba-996f-4132-9436-450e3db7234f	2026-08-28 10:18	2026-08-28 10:18	2026-08-28 10:18	XBI	XBI260828P00165000	put	165.0000	2026-08-28	1.1000	1.0700	1.3600	164.3900	11000.00	9240.00	1760.00	100	6	3078	2595	1.18612716763006	0.453001068945591	0.453001068945591	false	false	false	true
a339614d-310e-400b-8f3d-a41536108268	2026-08-28 10:18	2026-08-28 10:18	2026-08-28 10:18	XBI	XBI260828P00165000	put	165.0000	2026-08-28	1.1100	1.0800	1.3600	164.4400	11100.00	7104.00	2109.00	100	6	2777	2595	1.07013487475915	0.478388787254374	0.478388787254374	false	false	false	true
b5c4d506-282f-4416-a221-58fb6a20d3aa	2026-08-28 10:16	2026-08-28 10:16	2026-08-28 10:16	XBI	XBI260904P00163000	put	163.0000	2026-09-04	2.2600	2.2600	2.4500	164.2400	11752.00	0.00	9492.00	52	7	1335	31	43.0645161290323	0.319715793919931	0.319715793919931	true	false	false	true
c2067ecd-47fd-41ca-8ce1-e7b03a4098f6	2026-08-28 10:16	2026-08-28 10:16	2026-08-28 10:16	XBI	XBI260904P00163000	put	163.0000	2026-09-04	2.2200	2.2200	2.3900	164.2400	26196.00	0.00	26196.00	118	11	1234	31	39.8064516129032	0.315208301782032	0.315208301782032	true	false	false	true
14f353ff-f3e7-4477-ac38-55f1136147a4	2026-08-28 10:16	2026-08-28 10:16	2026-08-28 10:16	XBI	XBI260904P00163000	put	163.0000	2026-09-04	2.2100	2.2100	2.3900	164.2000	18785.00	0.00	18785.00	85	11	1116	31	36	0.312203015113033	0.312203015113033	true	false	false	true
7ff5385d-0375-4604-b450-cba7fa8699a5	2026-08-28 10:14	2026-08-28 10:14	2026-08-28 10:14	XBI	XBI261218P00175000	put	175.0000	2026-12-18	17.1500	16.9500	17.1500	163.9300	13720.00	13720.00	0.00	8	5	59	900	0.0655555555555556	0.326218339306646	0.326218339306646	false	false	false	true
896fdf3f-74ab-4658-a637-96e4a7786291	2026-08-28 10:12	2026-08-28 10:12	2026-08-28 10:12	XBI	XBI260828C00145000	call	145.0000	2026-08-28	19.0000	19.0000	21.3000	164.0606	24700.00	0.00	24700.00	13	10	56	87	0.64367816091954	5.44419612188384	5.10847581120513	true	false	false	true
0ae639b6-7f10-4d7e-8cdf-f724d803749b	2026-08-28 10:11	2026-08-28 10:11	2026-08-28 10:11	XBI	XBI260904C00168000	call	168.0000	2026-09-04	1.4300	1.4300	1.6500	164.2550	117689.00	0.00	117689.00	823	46	827	40	20.675	0.314686356199941	0.314686356199941	false	false	false	true
1dad835c-a5cb-40a6-9dfa-6aac61a6e32e	2026-08-28 10:05	2026-08-28 10:04	2026-08-28 10:04	XBI	XBI261016C00185000	call	185.0000	2026-10-16	1.7500	1.5900	2.0700	165.1673	19426.00	11025.00	8401.00	111	8	113	6138	0.0184099055066797	0.306884661010156	0.306884661010156	false	false	false	true
c5c33cf8-7e8d-4ef0-b40e-1c201f964e01	2026-08-28 09:48	2026-08-28 09:48	2026-08-28 09:48	XBI	XBI260918C00175000	call	175.0000	2026-09-18	1.9300	1.9300	2.1300	166.1200	67936.00	0.00	67936.00	352	18	379	9084	0.0417217084984588	0.312325388677543	0.312325388677543	false	false	false	true
100d64a4-3fde-435c-9b1b-dca8201d53ac	2026-08-28 09:43	2026-08-28 09:43	2026-08-28 09:43	XBI	XBI260828C00170000	call	170.0000	2026-08-28	0.0500	0.0100	0.0500	165.4700	13285.00	13285.00	0.00	2657	45	3141	3824	0.821391213389121	0.59636147064741	0.59636147064741	false	false	false	true
6a1747cd-dd63-4e74-a786-db64bb77f6a3	2026-08-28 09:41	2026-08-28 09:41	2026-08-28 09:41	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6700	1.5800	1.9300	165.7700	16700.00	13861.00	2839.00	100	6	595	4001	0.148712821794551	0.523286354755285	0.523286354755285	false	false	false	true
8fd3c108-833c-426f-8476-569187102112	2026-08-28 09:41	2026-08-28 09:41	2026-08-28 09:41	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6700	1.3600	1.6700	165.8100	14195.00	14195.00	0.00	85	7	380	4001	0.094976255936016	0.54089544769279	0.54089544769279	false	false	false	true
103f1146-654a-4612-b416-343c616a0d93	2026-08-28 09:41	2026-08-28 09:41	2026-08-28 09:41	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6700	1.3700	1.6700	165.7700	15531.00	8016.00	0.00	93	6	488	4001	0.121969507623094	0.523240625651235	0.523240625651235	false	false	false	true
908f0b1b-7d63-4979-b08d-a79a946a5d0e	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.7300	165.9100	12283.00	12283.00	0.00	71	9	295	4001	0.0737315671082229	0.619120669719523	0.619120669719523	false	false	false	true
a447f34c-c612-42c8-9ce3-5d71048049fb	2026-08-27 15:54	2026-08-27 15:54	2026-08-27 15:54	XBI	XBI260904P00168000	put	168.0000	2026-09-04	2.8300	2.8300	2.9800	168.4800	16980.00	0.00	16980.00	60	5	79	22	3.59090909090909	0.315174009662373	0.315174009662373	false	false	false	true
72d147d0-bc1a-4ddd-86a7-74493158ca96	2026-08-27 13:20	2026-08-27 13:20	2026-08-27 13:20	XBI	XBI261218C00170000	call	170.0000	2026-12-18	12.4500	12.4000	12.4500	168.9800	263905.00	263905.00	0.00	212	8	254	3581	0.0709299078469701	0.319651591715709	0.319651591715709	false	false	false	true
2a9ab27c-dd6c-4d98-9e3a-45abb8910f22	2026-08-27 12:36	2026-08-27 12:36	2026-08-27 12:36	XBI	XBI261016C00180000	call	180.0000	2026-10-16	3.9500	3.9500	4.3500	169.0943	22910.00	0.00	22910.00	58	6	250	283	0.88339222614841	0.310015891782793	0.310015891782793	true	false	false	true
880e0e4c-0524-4cb1-84c2-21a96f14f9c0	2026-08-27 12:28	2026-08-27 12:28	2026-08-27 12:28	XBI	XBI260828P00165000	put	165.0000	2026-08-28	0.2100	0.2100	0.3100	168.9700	13944.00	0.00	13944.00	664	45	1203	1670	0.720359281437126	0.393752306158056	0.393752306158056	true	false	false	true
d8494739-088a-41e2-95e6-0c26918a92dd	2026-08-27 11:56	2026-08-27 11:56	2026-08-27 11:56	XBI	XBI260828P00168000	put	168.0000	2026-08-28	1.1900	1.1900	1.5500	168.5400	25823.00	0.00	25823.00	217	33	751	22	34.1363636363636	0.413190631422588	0.413190631422588	false	false	false	true
d62c245e-48a9-4035-b4c6-81b306e5ac82	2026-08-27 11:46	2026-08-27 11:46	2026-08-27 11:46	XBI	XBI260828P00165000	put	165.0000	2026-08-28	0.4100	0.4100	0.6100	168.1400	17630.00	0.00	17630.00	430	28	452	1670	0.270658682634731	0.426693929292543	0.426693929292543	false	false	false	true
8093d8f1-686f-467b-a55a-02a36fc17a5e	2026-08-27 11:44	2026-08-27 11:44	2026-08-27 11:44	XBI	XBI261218C00175000	call	175.0000	2026-12-18	9.5000	9.1000	10.4500	168.2100	48450.00	34200.00	14250.00	51	9	51	212	0.240566037735849	0.309442075408258	0.309442075408258	false	false	false	true
31de3f7c-ea42-45b6-9005-d362dcbf0252	2026-08-27 11:16	2026-08-27 11:16	2026-08-27 11:16	XBI	XBI260828P00168000	put	168.0000	2026-08-28	1.2200	1.2200	1.5800	168.5200	31110.00	0.00	31110.00	255	32	534	22	24.2727272727273	0.419313688659193	0.419313688659193	false	false	false	true
79e32271-ff6d-4e1b-a0e4-421407530ce6	2026-08-27 11:02	2026-08-27 11:02	2026-08-27 11:02	XBI	XBI260828P00168000	put	168.0000	2026-08-28	1.2200	1.2200	1.6000	168.5500	32574.00	0.00	32574.00	267	31	279	22	12.6818181818182	0.423082171100783	0.423082171100783	false	false	false	true
3c17e6c2-fc7c-4ca3-932f-8e84e207e773	2026-08-27 10:22	2026-08-27 10:22	2026-08-27 10:22	XBI	XBI260918C00177000	call	177.0000	2026-09-18	1.9000	1.7000	1.9200	167.7250	34770.00	570.00	34200.00	183	17	183	211	0.867298578199052	0.306685075953363	0.306685075953363	true	false	false	true
6e88215d-bdc4-4d01-9b1c-68c2d1d5690a	2026-08-27 10:09	2026-08-27 10:09	2026-08-27 10:09	XBI	XBI270617C00175000	call	175.0000	2027-06-17	18.0500	17.3500	18.0500	167.4400	12635.00	12635.00	0.00	7	6	7	122	0.0573770491803279	0.316548820788276	0.316548820788276	false	false	false	true
ff26104c-82ca-4456-b99b-8fb5e373e504	2026-08-26 15:40	2026-08-26 15:40	2026-08-26 15:40	XBI	XBI261218P00175000	put	175.0000	2026-12-18	14.6500	14.6500	15.2000	168.6700	62995.00	0.00	62995.00	43	17	107	796	0.134422110552764	0.326871692222244	0.326871692222244	false	false	false	true
af86160d-3a00-43a1-910e-b1b55392d58e	2026-08-26 15:40	2026-08-26 15:40	2026-08-26 15:40	XBI	XBI260828P00166000	put	166.0000	2026-08-28	0.7900	0.7900	0.9200	168.6700	16985.00	0.00	16985.00	215	28	464	979	0.473953013278856	0.371126947009062	0.371126947009062	false	false	false	true
ce848d81-60c1-4653-b32b-7628683365b8	2026-08-26 15:30	2026-08-26 15:30	2026-08-26 15:30	XBI	XBI261218P00175000	put	175.0000	2026-12-18	14.7500	14.7500	15.2500	168.5500	94400.00	0.00	94400.00	64	16	64	796	0.0804020100502513	0.327878948868149	0.327878948868149	false	false	false	true
6d001988-435e-4c1b-8763-03433cacbd37	2026-08-26 14:52	2026-08-26 14:52	2026-08-26 14:52	XBI	XBI261016C00168000	call	168.0000	2026-10-16	8.4500	8.4500	9.0000	168.2100	16900.00	0.00	16900.00	20	5	20	254	0.078740157480315	0.315675329553446	0.315675329553446	true	false	false	true
66ea7827-ac63-440a-ba53-d8211063e5aa	2026-08-26 13:00	2026-08-26 13:00	2026-08-26 13:00	XBI	XBI260828P00165000	put	165.0000	2026-08-28	0.7000	0.7000	0.8200	168.2200	19110.00	0.00	19110.00	273	27	1518	1214	1.2504118616145	0.386248045694335	0.386248045694335	false	false	false	true
71e6a5e2-7384-401d-ae31-9387d165a1b4	2026-08-26 12:21	2026-08-26 12:20	2026-08-26 12:20	XBI	XBI260828C00171000	call	171.0000	2026-08-28	0.7300	0.7300	0.8200	167.7900	21535.00	0.00	21535.00	295	31	298	34	8.76470588235294	0.382407167661982	0.382407167661982	false	false	false	true
1d5d81bd-d58c-43d0-91a0-f93bf0694a81	2026-08-26 11:51	2026-08-26 11:51	2026-08-26 11:51	XBI	XBI260828C00170000	call	170.0000	2026-08-28	0.8800	0.8800	0.9800	167.2800	10912.00	0.00	10912.00	124	17	636	778	0.817480719794344	0.388204164535389	0.388204164535389	false	false	false	true
f3bc6a86-48f5-4490-9b25-cb2a8c782ae0	2026-08-26 11:45	2026-08-26 11:45	2026-08-26 11:45	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6500	1.6500	1.8400	167.7100	16500.00	0.00	5940.00	100	6	861	32	26.90625	0.404802979848588	0.404802979848588	false	false	false	true
61a258e0-f224-4da0-af8c-f90818c34931	2026-08-26 11:45	2026-08-26 11:45	2026-08-26 11:45	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6500	1.5900	1.6500	167.7100	24750.00	24750.00	0.00	150	9	1011	32	31.59375	0.404802979848588	0.404802979848588	true	false	false	true
b24ba758-c4fe-4f14-b992-78419bb7271f	2026-08-26 11:43	2026-08-26 11:43	2026-08-26 11:43	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6100	1.6100	1.7900	167.7200	13202.00	0.00	1932.00	82	5	537	32	16.78125	0.397503835177383	0.397503835177383	false	false	false	true
532d0006-f60f-4608-b498-cad5febebcc0	2026-08-26 11:43	2026-08-26 11:43	2026-08-26 11:43	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6100	1.4700	1.7900	167.7600	36064.00	34454.00	1610.00	224	6	761	32	23.78125	0.401043524678455	0.401043524678455	true	false	false	true
4e6b3113-f18d-4daa-bf03-13eddd38e8e6	2026-08-26 11:43	2026-08-26 11:43	2026-08-26 11:43	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6000	1.6000	1.8000	167.7300	13120.00	0.00	11200.00	82	5	455	32	14.21875	0.396342226022925	0.396342226022925	false	false	false	true
8a91af79-f521-495e-91c3-d84e2aeacf0c	2026-08-26 11:43	2026-08-26 11:43	2026-08-26 11:43	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6000	1.5300	1.8300	167.7000	11840.00	960.00	5120.00	74	12	339	32	10.59375	0.393680062311958	0.393680062311958	false	false	false	true
35593b63-bc3f-420f-9797-c35efb04b88a	2026-08-26 11:43	2026-08-26 11:43	2026-08-26 11:43	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.6000	1.6000	1.8300	167.7000	16960.00	0.00	9280.00	106	8	265	32	8.28125	0.393680062311958	0.393680062311958	false	false	false	true
e7e0e874-6522-4238-93ea-736c70948f2d	2026-08-26 11:43	2026-08-26 11:43	2026-08-26 11:43	XBI	XBI260828P00167000	put	167.0000	2026-08-28	1.5700	1.5700	1.8300	167.7100	15857.00	0.00	15857.00	101	7	104	32	3.25	0.388425131238991	0.388425131238991	false	false	false	true
39f307f4-9ebd-4fb8-9934-8170e9f5ae68	2026-08-26 11:40	2026-08-26 11:40	2026-08-26 11:40	XBI	XBI260828P00166000	put	166.0000	2026-08-28	1.2300	1.2200	1.4700	167.6700	28781.00	0.00	28781.00	234	31	235	979	0.240040858018386	0.399057137934951	0.396901114181415	false	false	false	true
015d7a0f-ee14-4d58-8266-cd2fa54b430c	2026-08-26 11:13	2026-08-26 11:13	2026-08-26 11:13	XBI	XBI261218C00174000	call	174.0000	2026-12-18	9.7500	9.7500	10.1000	167.3200	19500.00	0.00	19500.00	20	12	22	1	22	0.315099903903472	0.315099903903472	false	false	false	true
e21bc999-3c69-4b6c-8b21-a80697c6e4f9	2026-08-26 10:48	2026-08-26 10:47	2026-08-26 10:47	XBI	XBI260918P00160000	put	160.0000	2026-09-18	2.3200	2.1900	2.3300	167.4900	63336.00	232.00	63104.00	273	17	319	9996	0.0319127651060424	0.32749886930102	0.32749886930102	false	false	false	true
044c6daf-49ae-47ce-8462-1ad0b7e7be4f	2026-08-26 10:43	2026-08-26 10:42	2026-08-26 10:42	XBI	XBI260828C00168000	call	168.0000	2026-08-28	1.6000	1.6000	2.5000	167.0100	26881.00	0.00	26881.00	168	19	173	544	0.318014705882353	0.412891920756823	0.412891920756823	true	false	false	true
b215d2f6-f231-4613-b4b8-fbaf7fcbb289	2026-08-26 10:29	2026-08-26 10:29	2026-08-26 10:29	XBI	XBI260828C00172500	call	172.5000	2026-08-28	0.4500	0.4300	0.6000	167.4950	57195.00	0.00	57195.00	1271	38	1771	14	126.5	0.40662621087792	0.40662621087792	false	false	false	true