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: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	expirydate	price

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	10834097622.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
e14fa8a9-aa8a-4992-b4b0-66c70be0631b	2026-08-31 13:14	2026-08-31 13:14	2026-08-31 13:14	XBI	XBI260918C00175000	call	175.0000	2026-09-18	0.6700	0.6200	0.6700	161.3450	30951.00	26661.00	4290.00	463	18	715	8590	0.0832363213038417	0.304218037624674	0.302872979651673	true	false	false	true	false
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	false
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	false
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	false
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	false
58ab6144-0300-437d-be41-d95937eff066	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	XBI	XBI260918C00175000	call	175.0000	2026-09-18	0.8200	0.5500	0.9600	162.9200	18830.00	3875.00	6876.00	229	12	1306	8590	0.152037252619325	0.296725681500761	0.294374997499129	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
cec2bb0b-0ac2-4573-a209-68129f48a922	2026-09-01 12:22	2026-09-01 12:22	2026-09-01 12:22	XBI	XBI261218C00200000	call	200.0000	2026-12-18	1.7700	1.6300	1.7800	162.3550	84293.00	34565.00	0.00	475	34	525	9539	0.0550372156410525	0.308575429904444	0.308061510051859	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
1b16a270-c657-435e-af14-272e5580c5d0	2026-09-02 09:57	2026-09-02 09:57	2026-09-02 09:57	XBI	XBI261009C00160000	call	160.0000	2026-10-09	9.7500	9.7500	11.8500	165.4500	16575.00	0.00	16575.00	17	5	17	0	0	0.303790474089346	0.303790474089346	true	false	false	true	false