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

ace4fb9f-6151-48e9-bf77-f7149daf479e	2026-09-02 09:56	2026-09-02 09:56	2026-09-02 09:56	XBI	XBI261002C00164000	call	164.0000	2026-10-02	6.9000	6.9000	8.5000	165.7350	16560.00	0.00	16560.00	24	12	24	2	12	0.303005331597956	0.303005331597956	true	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-09-02T14:11:00.326314Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c84a3311-994a-4941-9039-2a873a75929d	2026-09-02 09:51	2026-09-02 09:51	2026-09-02 09:51	XBI	XBI260911C00160000	call	160.0000	2026-09-11	7.3500	7.3500	8.9000	166.3550	30870.00	0.00	30870.00	42	12	46	45	1.02222222222222	0.299456989010641	0.299456989010641	true	false	false	true
6fb46f3c-1c01-4880-9985-8f8965082f44	2026-09-02 09:51	2026-09-02 09:51	2026-09-02 09:51	XBI	XBI260911C00162000	call	162.0000	2026-09-11	5.8000	5.8000	7.4500	166.3550	24360.00	0.00	24360.00	42	13	43	87	0.494252873563218	0.294662067988735	0.294662067988735	true	false	false	true
0e351891-356a-496f-8c69-75aec1198d29	2026-09-01 15:39	2026-09-01 15:39	2026-09-01 15:39	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.3000	6.2500	6.4000	163.1800	44100.00	36540.00	7560.00	70	9	1412	1752	0.805936073059361	0.296853927203194	0.296853927203194	false	false	false	true
41beeab8-1429-483e-99e6-ca292af948c7	2026-09-01 15:36	2026-09-01 15:36	2026-09-01 15:36	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.2500	6.2500	6.3000	163.0650	12500.00	0.00	12500.00	20	5	1322	1752	0.754566210045662	0.297158639012326	0.297158639012326	false	false	false	true
151577af-69e2-4805-a0c6-0c5b78467c49	2026-09-01 15:32	2026-09-01 15:32	2026-09-01 15:32	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.2000	6.1500	6.2500	162.9900	107880.00	0.00	107260.00	174	16	1227	1752	0.700342465753425	0.296588433192734	0.296588433192734	false	false	false	true
786edab8-703c-45d0-bbeb-d6c1d70d0c77	2026-09-01 15:28	2026-09-01 15:27	2026-09-01 15:27	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.2500	6.2000	6.3000	163.1250	72505.00	72505.00	0.00	116	5	960	1752	0.547945205479452	0.295859563231984	0.298047873069853	false	false	false	true
7eb2378f-f5ae-49de-bd4a-c999eced72bc	2026-09-01 15:27	2026-09-01 15:27	2026-09-01 15:27	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.2000	6.2000	6.2500	163.0800	56426.00	0.00	56426.00	91	9	779	1752	0.444634703196347	0.294645112533044	0.295082915597042	false	false	false	true
a5b63a55-493c-4bf3-9f66-fc1035433f0a	2026-09-01 15:27	2026-09-01 15:27	2026-09-01 15:27	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.2500	6.2000	6.3000	163.1150	29365.00	13115.00	0.00	47	6	678	1752	0.386986301369863	0.296076258867765	0.296076258867765	false	false	false	true
c50aad9f-e1d4-43e2-973e-2dfc1e879c7a	2026-09-01 15:26	2026-09-01 15:26	2026-09-01 15:26	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.3000	6.3000	6.4500	163.1300	45360.00	0.00	45360.00	72	24	486	1752	0.277397260273973	0.297939424269356	0.297939424269356	false	false	false	true
0a7d4ab3-7f8e-4f33-9527-b7c1167d043b	2026-09-01 15:16	2026-09-01 15:15	2026-09-01 15:15	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.4000	6.4000	6.6000	163.3000	15360.00	0.00	15360.00	24	11	255	1752	0.145547945205479	0.298612786777611	0.298612786777611	false	false	false	true
f8224e81-1d81-42de-8602-332345430523	2026-09-01 15:14	2026-09-01 15:14	2026-09-01 15:14	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.2600	1.2600	1.3200	163.3300	119070.00	0.00	119070.00	945	27	1370	14151	0.096812946081549	0.310273295456488	0.310273295456488	false	false	false	true
b0f195e5-9f33-46ac-af26-da28337d4717	2026-09-01 15:01	2026-09-01 15:01	2026-09-01 15:01	XBI	XBI261016C00165000	call	165.0000	2026-10-16	6.2500	6.2500	6.4500	163.0250	35000.00	0.00	35000.00	56	17	202	1752	0.115296803652968	0.298023235626196	0.298023235626196	false	false	false	true
4466f488-2ed4-4515-8435-c712da78c5a7	2026-09-01 13:58	2026-09-01 13:58	2026-09-01 13:58	XBI	XBI261016C00169000	call	169.0000	2026-10-16	4.5500	4.5500	4.7500	162.8250	22750.00	0.00	22750.00	50	15	53	254	0.208661417322835	0.297982412970457	0.297982412970457	false	false	false	true
3fc5e74b-1dab-466e-8614-8f7633fea3e5	2026-09-01 13:02	2026-09-01 13:02	2026-09-01 13:02	XBI	XBI261016P00150000	put	150.0000	2026-10-16	2.2500	2.0700	2.3200	162.7050	103505.00	225.00	103280.00	460	9	475	371	1.28032345013477	0.321526292103576	0.321146661201462	false	false	false	true
8db9352b-0178-46a1-b5a8-8f2526b62adc	2026-09-01 12:57	2026-09-01 12:57	2026-09-01 12:57	XBI	XBI261016P00165000	put	165.0000	2026-10-16	8.0000	8.0000	8.6000	162.7100	82400.00	0.00	82400.00	103	10	103	2298	0.0448215839860748	0.315652196884067	0.315652196884067	true	false	false	true
6eefbe9c-665e-4ed5-9297-6653757651af	2026-09-01 12:27	2026-09-01 12:27	2026-09-01 12:27	XBI	XBI261218C00200000	call	200.0000	2026-12-18	1.6200	1.6200	1.7800	162.2900	115668.00	0.00	115668.00	714	24	1352	9539	0.141733934374672	0.300796793079337	0.300657406673504	false	false	false	true
6bbabb62-874e-49f3-b0cf-88ef3761468d	2026-09-01 12:00	2026-09-01 12:00	2026-09-01 12:00	XBI	XBI261016P00145000	put	145.0000	2026-10-16	1.2800	1.2800	1.3700	162.9400	111104.00	0.00	111104.00	868	11	879	1115	0.788340807174888	0.32441984696575	0.32441984696575	false	false	false	true
2e790c9c-0eff-408b-b06b-82408924e61a	2026-09-01 10:56	2026-09-01 10:56	2026-09-01 10:56	XBI	XBI261016C00200000	call	200.0000	2026-10-16	0.1700	0.1700	0.2200	162.4700	14501.00	0.00	14501.00	853	28	3939	6187	0.636657507677388	0.293448969224209	0.293448969224209	false	false	false	true
d9c07a53-fa77-44a8-9039-2c75cdc834b9	2026-09-01 10:48	2026-09-01 10:48	2026-09-01 10:48	XBI	XBI261016P00140000	put	140.0000	2026-10-16	0.7500	0.7500	0.9800	162.7700	64350.00	0.00	64350.00	858	29	859	44	19.5227272727273	0.332840066997903	0.332840066997903	false	false	false	true
9c097b76-dd20-4a5e-bc46-bd63d4b5f4fe	2026-09-01 10:37	2026-09-01 10:37	2026-09-01 10:37	XBI	XBI260918C00170000	call	170.0000	2026-09-18	1.4200	1.4200	1.5100	162.2500	16188.00	0.00	16188.00	114	21	1695	9967	0.170061201966489	0.288057141612844	0.288057141612844	false	false	false	true
783b8f06-88e7-4dd5-88d4-6576ccab7000	2026-09-01 10:37	2026-09-01 10:37	2026-09-01 10:37	XBI	XBI260918C00170000	call	170.0000	2026-09-18	1.4200	1.4200	1.5100	162.2500	57652.00	0.00	57652.00	406	23	1581	9967	0.158623457409451	0.288057141612844	0.288057141612844	false	false	false	true
4b941c17-7fdd-4a17-9ee4-36c25dba8b2d	2026-09-01 10:27	2026-09-01 10:27	2026-09-01 10:27	XBI	XBI261016C00200000	call	200.0000	2026-10-16	0.1500	0.1500	0.2400	161.9150	21240.00	0.00	21240.00	1416	51	1437	6187	0.232261192823663	0.291856334013943	0.291856334013943	false	false	false	true
444318b9-ad37-435d-aae2-c6fdc482734f	2026-09-01 10:25	2026-09-01 10:25	2026-09-01 10:25	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.5200	1.4200	1.5300	162.1300	41496.00	152.00	41344.00	273	15	281	14151	0.0198572539043177	0.310376297818342	0.310376297818342	false	false	false	true
1fdb274d-9c3f-4e80-bf1a-12848d0bf1bc	2026-09-01 10:00	2026-09-01 10:00	2026-09-01 10:00	XBI	XBI260918C00148000	call	148.0000	2026-09-18	14.3000	13.9000	14.4500	161.4900	90090.00	1430.00	88660.00	63	7	63	69	0.91304347826087	0.328124303209992	0.328124303209992	false	false	false	true
eb4055e1-0ac7-40ed-9c4a-3b3cc65fa3dd	2026-09-01 09:58	2026-09-01 09:58	2026-09-01 09:58	XBI	XBI270115P00150000	put	150.0000	2027-01-15	7.1500	6.4000	7.1500	161.4700	20020.00	20020.00	0.00	28	7	29	3996	0.00725725725725726	0.342081548739467	0.342081548739467	false	false	false	true
b753a74a-bdbd-4ee5-b42f-d9749f141760	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	XBI	XBI260904P00182000	put	182.0000	2026-09-04	18.9500	18.9500	21.3000	162.9600	22741.00	0.00	22741.00	12	7	12	0	0	1.2144534632931	1.2144534632931	true	false	false	true
85e2a4d3-1545-4748-ab3d-f779384cead8	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	XBI	XBI260904P00176000	put	176.0000	2026-09-04	12.9500	12.9500	15.2500	162.9600	15540.00	0.00	15540.00	12	7	12	0	0	0.978602460864882	0.978602460864882	true	false	false	true
47ba500a-bda0-4a7b-bc85-43bbf845b94b	2026-08-31 15:35	2026-08-31 15:35	2026-08-31 15:35	XBI	XBI260911C00165000	call	165.0000	2026-09-11	1.9000	1.5400	1.9000	161.6400	18239.00	18239.00	0.00	96	7	106	59	1.79661016949153	0.286844423003327	0.286844423003327	true	false	false	true
b79470ed-90bc-44bd-b3b0-e29f46cd01c6	2026-08-31 13:15	2026-08-31 13:15	2026-08-31 13:15	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.8400	1.7300	1.8400	161.3550	220800.00	220800.00	0.00	1200	6	1203	15010	0.0801465689540306	0.313365146502331	0.313365146502331	true	false	false	true
8e4284ca-4c4b-493b-939e-9f07c9fe2d1d	2026-08-31 13:05	2026-08-31 13:05	2026-08-31 13:05	XBI	XBI260911P00155000	put	155.0000	2026-09-11	1.0100	1.0100	1.0900	161.2700	126755.00	0.00	126755.00	1255	22	1664	49	33.9591836734694	0.298944816616049	0.298944816616049	false	false	false	true
2f2953d4-d6f8-421e-8009-b9b4b35f29db	2026-08-31 11:32	2026-08-31 11:32	2026-08-31 11:32	XBI	XBI260911P00155000	put	155.0000	2026-09-11	1.1800	1.0900	1.3900	160.8600	45077.00	118.00	44959.00	382	18	403	49	8.22448979591837	0.308664830654266	0.308664830654266	true	false	false	true
91fc825f-36bb-4dbb-93dd-815f14f76977	2026-08-31 11:09	2026-08-31 11:08	2026-08-31 11:08	XBI	XBI261218C00170000	call	170.0000	2026-12-18	7.6000	7.3000	7.9500	160.3450	79800.00	19000.00	60800.00	105	10	178	3851	0.0462217605816671	0.308058619566226	0.308058619566226	false	false	false	true
1132d87f-1f43-45e8-9674-94d8906a6f8e	2026-08-31 09:33	2026-08-31 09:33	2026-08-31 09:33	XBI	XBI261016P00156000	put	156.0000	2026-10-16	4.9000	4.3000	5.1000	160.3100	16170.00	16170.00	0.00	33	5	34	400	0.085	0.320162524495604	0.320162524495604	false	false	false	true
a55d6283-8749-4784-a6ca-483ba54de605	2026-08-28 15:18	2026-08-28 15:18	2026-08-28 15:18	XBI	XBI260828P00166000	put	166.0000	2026-08-28	3.4500	3.4000	3.6500	162.5062	68695.00	0.00	68695.00	199	16	517	1384	0.373554913294798	1.97466016793897	1.97466016793897	false	false	false	true
d4d6c037-9478-4d3d-99c4-275f443fb8e1	2026-08-28 14:09	2026-08-28 14:09	2026-08-28 14:09	XBI	XBI260828P00165000	put	165.0000	2026-08-28	1.9900	1.9200	2.0600	163.0000	19900.00	15920.00	3980.00	100	5	5128	2595	1.97610789980732	0.301480267921097	0.624636472018775	false	false	false	true
9cf5cdfb-673e-439c-b2ed-2e797de76ef0	2026-08-28 14:09	2026-08-28 14:09	2026-08-28 14:09	XBI	XBI260828P00165000	put	165.0000	2026-08-28	2.1000	2.0500	2.1800	162.8900	21000.00	16800.00	4200.00	100	5	4927	2595	1.89865125240848	0.301480267921097	0.675116041744184	false	false	false	true
3b7a19b3-1ef2-44a8-a001-f351ada4e6b2	2026-08-28 14:09	2026-08-28 14:09	2026-08-28 14:09	XBI	XBI260828P00165000	put	165.0000	2026-08-28	2.1000	1.6400	2.1000	162.8900	21000.00	15120.00	0.00	100	8	4827	2595	1.86011560693642	0.301480267921097	0.301480267921097	false	false	false	true
fd5123be-b60b-488f-908c-1163f13b6336	2026-08-28 14:02	2026-08-28 14:02	2026-08-28 14:02	XBI	XBI261218P00160000	put	160.0000	2026-12-18	9.3500	9.3500	9.5000	162.8500	54230.00	0.00	54230.00	58	6	76	3589	0.021175814990248	0.326639828721269	0.326639828721269	false	false	false	true
95fd9d5f-e5d4-42be-b61e-b6845d0badee	2026-08-28 13:50	2026-08-28 13:49	2026-08-28 13:49	XBI	XBI261016P00161000	put	161.0000	2026-10-16	6.0000	6.0000	6.1500	163.1250	47400.00	0.00	47400.00	79	19	192	264	0.727272727272727	0.312500115116384	0.312500115116384	false	false	false	true
3231e88a-55b6-4f36-a025-d9ce790563eb	2026-08-28 13:34	2026-08-28 13:34	2026-08-28 13:34	XBI	XBI260828P00165000	put	165.0000	2026-08-28	1.7000	1.5400	1.7000	163.3300	16830.00	16830.00	0.00	99	6	4694	2595	1.80886319845857	0.404395712974597	0.404395712974597	false	false	false	true
c36409b4-df3e-4ac6-8f27-e27433ce8f65	2026-08-28 12:16	2026-08-28 12:16	2026-08-28 12:16	XBI	XBI270115C00200000	call	200.0000	2027-01-15	3.1000	3.0500	3.8000	163.0500	12400.00	2480.00	9610.00	40	11	195	3178	0.0613593455003147	0.31584609846986	0.31584609846986	false	false	false	true
ee9a9ad8-ac47-4f6f-8f2b-268a2fd3c537	2026-08-28 12:03	2026-08-28 12:03	2026-08-28 12:03	XBI	XBI261016P00165000	put	165.0000	2026-10-16	7.9500	7.9000	8.3500	163.0000	10335.00	795.00	9540.00	13	11	105	2171	0.0483648088438508	0.309930615592972	0.309930615592972	true	false	false	true
06bc5455-d98e-432e-835b-6ec82025f896	2026-08-28 12:00	2026-08-28 12:00	2026-08-28 12:00	XBI	XBI261016P00165000	put	165.0000	2026-10-16	8.1500	7.9500	8.3000	163.0000	53790.00	6520.00	44825.00	66	11	92	2171	0.0423767848917549	0.317062176008823	0.317062176008823	true	false	false	true
31a28bea-a6b0-4a34-8a0e-1ddac4f3fb66	2026-08-28 11:14	2026-08-28 11:14	2026-08-28 11:14	XBI	XBI260828P00166000	put	166.0000	2026-08-28	1.8100	1.7400	2.0400	164.2351	32037.00	0.00	32037.00	177	26	214	1384	0.154624277456647	0.330826129474658	0.330826129474658	false	false	false	true
7b485965-ee4f-4d36-8134-600bc1839a88	2026-08-28 11:12	2026-08-28 11:12	2026-08-28 11:12	XBI	XBI260828P00165000	put	165.0000	2026-08-28	1.1100	1.1000	1.4100	164.1200	17094.00	333.00	16761.00	154	9	4439	2595	1.71059730250482	0.369170324059043	0.369170324059043	true	false	false	true
8a42ef82-b643-431a-a363-ed6675b25515	2026-08-28 10:39	2026-08-28 10:39	2026-08-28 10:39	XBI	XBI260904P00168000	put	168.0000	2026-09-04	4.2500	4.1000	4.2500	165.1300	15300.00	15300.00	0.00	36	11	177	276	0.641304347826087	0.289986850840169	0.288444642232027	true	false	false	true
293a9f6e-6959-4aa7-a3c3-353b34d38b9b	2026-08-28 10:36	2026-08-28 10:36	2026-08-28 10:36	XBI	XBI260918P00155000	put	155.0000	2026-09-18	1.4000	1.2000	1.6200	164.7300	31920.00	0.00	23660.00	228	14	729	13938	0.0523030563925958	0.317945666239679	0.318485180093716	false	false	false	true
79522aee-0057-40c1-84e6-d2ef5057aff9	2026-08-28 10:35	2026-08-28 10:35	2026-08-28 10:35	XBI	XBI260904P00170000	put	170.0000	2026-09-04	6.2500	6.2000	6.2500	164.4400	76875.00	76875.00	0.00	123	24	226	251	0.900398406374502	0.29318218649725	0.29318218649725	false	false	false	true
239a5743-aa26-4dd2-b37c-12f3b42d850d	2026-08-28 10:35	2026-08-28 10:35	2026-08-28 10:35	XBI	XBI260904P00170000	put	170.0000	2026-09-04	6.2500	5.4500	6.2500	164.4575	63750.00	54375.00	0.00	102	17	103	251	0.410358565737052	0.295216698907384	0.295216698907384	true	false	false	true