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:endpoint = /api/option-trades/flow-alerts×ticker = IBB×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

587e0eec-1eb2-48de-aecb-e36dbdcd91fb	2026-08-17 10:28	2026-08-17 10:28	2026-08-17 10:28	IBB	IBB261218C00190000	call	190.0000	2026-12-18	18.0000	17.3000	18.0000	200.9041	27000.00	27000.00	0.00	15	6	15	56	0.267857142857143	0.219829846492282	0.219829846492282	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	10445369031.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
70c4865f-6cfa-4b83-b622-5ecd305de501	2026-08-17 12:35	2026-08-17 12:35	2026-08-17 12:35	IBB	IBB260918C00210000	call	210.0000	2026-09-18	1.7500	1.5500	1.8000	201.8450	45150.00	45150.00	0.00	258	15	264	176	1.5	0.186835764926484	0.186835764926484	false	false	false
95c2f873-55bf-415d-9e9a-ef4cb9312a7f	2026-08-17 13:22	2026-08-17 13:22	2026-08-17 13:22	IBB	IBB270319P00205000	put	205.0000	2027-03-19	14.4000	12.1000	14.4000	201.8600	40317.00	40317.00	0.00	28	18	28	2	14	0.247537347840807	0.247373658313791	false	false	false	true
38dc3e54-7f64-4720-8424-0bc5cdfa577a	2026-08-17 14:24	2026-08-17 14:24	2026-08-17 14:24	IBB	IBB260918P00205000	put	205.0000	2026-09-18	6.4000	6.3000	6.6000	201.5900	56960.00	56320.00	640.00	89	21	90	0	0	0.205134429905303	0.205134429905303	false	false	false	true
c883d6ce-027f-4fdc-b493-187133680995	2026-08-17 14:24	2026-08-17 14:24	2026-08-17 14:24	IBB	IBB260918P00205000	put	205.0000	2026-09-18	6.4000	6.3000	6.4000	201.5900	17280.00	17280.00	0.00	27	17	117	0	0	0.205134429905303	0.205134429905303	false	false	false	true
38058edb-fdc9-4a22-b30f-9eaa5d9354e4	2026-08-17 14:52	2026-08-17 14:52	2026-08-17 14:52	IBB	IBB261218C00200000	call	200.0000	2026-12-18	12.3000	12.0000	12.5000	201.6800	71340.00	70110.00	1230.00	58	9	69	307	0.224755700325733	0.216337260225075	0.216337260225075	false	false	false
dd550984-03f2-4606-a597-d9815e613d67	2026-08-17 15:32	2026-08-17 15:32	2026-08-17 15:32	IBB	IBB260918C00205000	call	205.0000	2026-09-18	3.5100	3.4000	4.0000	201.7600	16126.00	1400.00	14726.00	46	5	182	1719	0.10587550901687	0.194329021537469	0.194628606354633	true	false	false
18bd056f-9223-4a6c-8fc7-24930cab0c9e	2026-08-17 15:32	2026-08-17 15:32	2026-08-17 15:32	IBB	IBB260918C00205000	call	205.0000	2026-09-18	3.5000	3.3000	3.8000	201.8000	21700.00	700.00	21000.00	62	22	136	1719	0.0791157649796393	0.193902124219734	0.193902124219734	false	false	false
194db677-b63f-4a3c-bffc-45eaf2df7387	2026-08-18 10:06	2026-08-18 10:05	2026-08-18 10:05	IBB	IBB260821P00205000	put	205.0000	2026-08-21	3.0000	2.7500	3.0000	203.2400	12000.00	12000.00	0.00	40	5	41	129	0.317829457364341	0.276479840956694	0.276479840956694	false	false	false
70984096-0da2-4904-9045-7f6fde2b2642	2026-08-18 12:19	2026-08-18 12:19	2026-08-18 12:19	IBB	IBB261218P00205000	put	205.0000	2026-12-18	10.2000	9.7000	10.2000	203.8035	26510.00	26510.00	0.00	26	14	26	21	1.23809523809524	0.233553703636531	0.233553703636531	false	false	false
1946656c-046d-4028-bd60-44407e214f85	2026-08-18 13:23	2026-08-18 13:23	2026-08-18 13:23	IBB	IBB261218P00205000	put	205.0000	2026-12-18	10.4000	9.5000	10.8000	203.4200	150800.00	145600.00	5200.00	145	34	182	21	8.66666666666667	0.234106832815646	0.234106832815646	false	false	false
3d01d99f-78cc-4b23-a81e-a4ee9fe1810f	2026-08-18 15:43	2026-08-18 15:43	2026-08-18 15:43	IBB	IBB261218P00190000	put	190.0000	2026-12-18	4.8000	3.9000	5.3000	203.8800	28320.00	27840.00	0.00	59	13	59	211	0.279620853080569	0.246750458310266	0.246750458310266	false	false	false
86f952b5-f326-4d97-aabf-dc65602d459d	2026-08-19 09:37	2026-08-19 09:37	2026-08-19 09:37	IBB	IBB260821C00215000	call	215.0000	2026-08-21	0.6000	0.1500	0.6000	211.2850	15240.00	15240.00	0.00	254	34	254	17	14.9411764705882	0.30133331532417	0.30133331532417	true	false	false
67cbffa9-e5a1-4181-bcd7-7816019cb74a	2026-08-19 09:48	2026-08-19 09:48	2026-08-19 09:48	IBB	IBB260918P00210000	put	210.0000	2026-09-18	4.0000	3.5000	5.4000	213.1200	40000.00	32800.00	7200.00	100	12	100	52	1.92307692307692	0.235480347926508	0.235480347926508	false	false	false
070bda1a-00d7-4cd3-9eb2-ac6151ee0440	2026-08-19 10:02	2026-08-19 10:02	2026-08-19 10:02	IBB	IBB260918P00210000	put	210.0000	2026-09-18	3.8000	3.5000	4.1000	213.6999	95000.00	82460.00	12540.00	250	5	450	52	8.65384615384615	0.236239647675105	0.236239647675105	false	false	false
35f867f4-7731-4d5d-adeb-a9d8340838a3	2026-08-19 10:28	2026-08-19 10:28	2026-08-19 10:28	IBB	IBB261218P00210000	put	210.0000	2026-12-18	8.6000	6.9000	8.6000	214.5750	40420.00	40420.00	0.00	47	19	47	0	0	0.245751537251402	0.245751537251402	false	false	false	true
e66f4d99-a253-4d37-8bb0-fba0e8d6a50a	2026-08-19 11:42	2026-08-19 11:42	2026-08-19 11:42	IBB	IBB260821C00215000	call	215.0000	2026-08-21	1.1000	1.1000	1.5500	212.7800	60280.00	0.00	60280.00	548	36	818	17	48.1176470588235	0.317084582915509	0.317084582915509	false	false	false
39391df4-f948-405d-8ead-b21ada81013c	2026-08-19 11:42	2026-08-19 11:42	2026-08-19 11:42	IBB	IBB261218C00220000	call	220.0000	2026-12-18	9.4600	9.3000	9.5000	212.7500	243070.00	52640.00	48880.00	257	33	286	48	5.95833333333333	0.232368348747972	0.232368348747972	false	false	false
26c2cc11-0eba-4d29-a3dc-a8bad842080f	2026-08-19 11:42	2026-08-19 11:42	2026-08-19 11:42	IBB	IBB261218C00200000	call	200.0000	2026-12-18	20.7000	20.7000	20.8000	212.7500	74521.00	0.00	74521.00	36	20	39	352	0.110795454545455	0.242858841733221	0.242858841733221	false	false	false
11a26858-a3a8-4377-bb5e-71d9f04b53ba	2026-08-19 11:46	2026-08-19 11:46	2026-08-19 11:46	IBB	IBB260918C00200000	call	200.0000	2026-09-18	14.4800	14.0000	15.8000	212.6700	11582.00	0.00	11582.00	8	5	83	4849	0.0171169313260466	0.234215031211894	0.234215031211894	false	false	false
84d90b41-c164-45d1-80ed-4bf9b9c59845	2026-08-19 13:51	2026-08-19 13:51	2026-08-19 13:51	IBB	IBB260821P00215000	put	215.0000	2026-08-21	2.1500	1.9500	2.1500	214.3200	29455.00	29455.00	0.00	137	29	141	0	0	0.28628624619398	0.28628624619398	false	false	false	true
f850a85a-3774-4107-b1cf-08488d8ee9cc	2026-08-19 14:20	2026-08-19 14:20	2026-08-19 14:20	IBB	IBB260918P00215000	put	215.0000	2026-09-18	5.7000	5.4000	5.7000	214.4400	107158.00	107158.00	0.00	188	30	233	16	14.5625	0.234680994832835	0.234680994832835	false	false	false
eb787d63-172f-48e1-ac83-78009eac3abe	2026-08-19 14:48	2026-08-19 14:48	2026-08-19 14:48	IBB	IBB260918C00225000	call	225.0000	2026-09-18	2.2000	2.0000	2.2000	215.0800	43780.00	43780.00	0.00	199	16	283	246	1.15040650406504	0.225118135364998	0.225118135364998	false	false	false
7b2e7f1d-f4ed-4c82-a73f-f319aa61aa90	2026-08-19 14:53	2026-08-19 14:53	2026-08-19 14:53	IBB	IBB260918C00205000	call	205.0000	2026-09-18	12.9000	12.0000	13.2000	215.3050	250258.00	185758.00	64500.00	194	18	276	1659	0.166365280289331	0.245111962400119	0.244011977533643	false	false	false
48fdc4b8-79db-46bc-a9d6-985233e23f5b	2026-08-19 14:53	2026-08-19 14:53	2026-08-19 14:53	IBB	IBB260918C00205000	call	205.0000	2026-09-18	12.9000	12.0000	12.9000	215.3050	265740.00	265740.00	0.00	206	31	482	1659	0.290536467751658	0.245111962400119	0.245111962400119	false	false	false
9740d50c-d72c-4099-aa99-5b1c2b1a2439	2026-08-19 14:55	2026-08-19 14:55	2026-08-19 14:55	IBB	IBB260918C00205000	call	205.0000	2026-09-18	12.8000	12.2000	12.8000	215.2400	17919.00	17919.00	0.00	14	11	582	1659	0.350813743218806	0.242406970930461	0.242406970930461	false	false	false
dbe3f382-7871-40d4-ab60-a2f83751890c	2026-08-19 15:04	2026-08-19 15:03	2026-08-19 15:03	IBB	IBB260918C00205000	call	205.0000	2026-09-18	12.9000	12.3000	13.0000	215.2150	129000.00	67080.00	61920.00	100	6	771	1659	0.464737793851718	0.248939153495942	0.248939153495942	false	false	false
93bc10e4-e7d5-4e9d-a97e-0cc0e10fc1b6	2026-08-19 15:35	2026-08-19 15:34	2026-08-19 15:34	IBB	IBB270115C00240000	call	240.0000	2027-01-15	5.9900	5.4000	6.2000	216.3100	75420.00	75420.00	0.00	126	24	168	4	42	0.236119291067784	0.237972942355628	true	false	false	true
855b09f8-a0c8-4d27-80bb-ce1cd1913eb5	2026-08-20 10:32	2026-08-20 10:32	2026-08-20 10:32	IBB	IBB260918C00225000	call	225.0000	2026-09-18	1.6500	1.6500	2.0500	212.3200	10087.00	0.00	10087.00	61	11	172	363	0.473829201101928	0.235815535776169	0.235240847223486	false	false	false
68068bcd-005c-4997-977e-a413b7285e4c	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	IBB	IBB261218C00182000	call	182.0000	2026-12-18	33.6000	33.6000	35.7000	211.9000	278880.00	0.00	278880.00	83	19	83	1	83	0.234522439975515	0.234522439975515	false	false	false
d6ff71ff-b819-4201-993e-07323414be83	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	IBB	IBB261218C00182000	call	182.0000	2026-12-18	33.6000	33.6000	35.7000	211.9300	258720.00	0.00	258720.00	77	21	160	1	160	0.23322697857854	0.23322697857854	false	false	false
3d109c9b-b44e-4178-bf00-91f2db2f2db5	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	IBB	IBB261218C00190000	call	190.0000	2026-12-18	27.0000	27.0000	29.2000	211.9300	156600.00	0.00	156600.00	58	14	58	71	0.816901408450704	0.234782329951653	0.234782329951653	false	false	false
b2091b1e-e874-44bc-9598-28efc8a4e17f	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	IBB	IBB261218C00190000	call	190.0000	2026-12-18	27.0000	27.0000	29.2000	211.8900	67500.00	0.00	67500.00	25	10	83	71	1.16901408450704	0.235885063857402	0.235885063857402	false	false	false
18d4e7ea-c9ce-4bf4-b9b5-d14ee0f4eb3e	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	IBB	IBB260918C00205000	call	205.0000	2026-09-18	10.0100	9.9000	11.1000	211.8600	302439.00	2010.00	300429.00	302	30	320	2037	0.157093765341188	0.240238993839718	0.233816301772159	true	false	false
3af0ce83-75f9-447c-8303-bbdad9315d92	2026-08-20 10:36	2026-08-20 10:36	2026-08-20 10:36	IBB	IBB261218C00182000	call	182.0000	2026-12-18	33.2000	33.1000	35.6000	211.5900	106240.00	0.00	106240.00	32	7	192	1	192	0.228743345377701	0.228743345377701	false	false	false
3cb26893-fe52-4511-9e49-0a903ad96847	2026-08-20 10:38	2026-08-20 10:38	2026-08-20 10:38	IBB	IBB261218C00182000	call	182.0000	2026-12-18	33.0000	33.0000	35.3000	211.4000	49500.00	0.00	49500.00	15	10	207	1	207	0.22737460142654	0.22737460142654	false	false	false
ee560097-2969-4f6c-a489-3d51f9c45bc5	2026-08-20 10:38	2026-08-20 10:38	2026-08-20 10:38	IBB	IBB261218C00190000	call	190.0000	2026-12-18	26.4000	26.4000	28.8000	211.2350	50160.00	0.00	50160.00	19	10	102	71	1.43661971830986	0.234070198478906	0.234070198478906	false	false	false
bb30f4da-46d4-4ad4-b214-65c5421906c7	2026-08-20 10:38	2026-08-20 10:38	2026-08-20 10:38	IBB	IBB261218C00182000	call	182.0000	2026-12-18	33.0000	33.0000	35.3000	211.2350	52800.00	0.00	52800.00	16	8	223	1	223	0.234452858074631	0.234452858074631	false	false	false
6f7cdff8-f651-4ea7-9e6e-25d5eb3b042d	2026-08-20 11:20	2026-08-20 11:20	2026-08-20 11:20	IBB	IBB261218P00220000	put	220.0000	2026-12-18	14.5000	13.9000	14.5000	213.2900	69600.00	69600.00	0.00	48	18	52	0	0	0.252900641312794	0.252900641312794	false	false	false	true
8f1f212e-ab6a-4b1d-8d12-d751e321c410	2026-08-20 11:36	2026-08-20 11:36	2026-08-20 11:36	IBB	IBB260918C00205000	call	205.0000	2026-09-18	10.9000	10.9000	12.1000	213.1800	54515.00	0.00	54515.00	50	23	372	2037	0.182621502209131	0.231784021588392	0.230207612124657	true	false	false
a48afcce-5e48-4aed-8ab8-5b5e74ea885d	2026-08-20 12:16	2026-08-20 12:16	2026-08-20 12:16	IBB	IBB260918C00200000	call	200.0000	2026-09-18	14.2000	14.1000	14.8000	212.3200	11360.00	0.00	11360.00	8	5	25	4844	0.00516102394715112	0.236951796231909	0.236951796231909	true	false	false
87bea0c7-f60a-4f9e-9792-7d0811752a58	2026-08-20 12:22	2026-08-20 12:22	2026-08-20 12:22	IBB	IBB261016C00190000	call	190.0000	2026-10-16	24.4000	24.4000	26.4000	212.0000	19520.00	0.00	19520.00	8	5	8	0	0	0.255751267481697	0.255751267481697	false	false	false	true
c517c189-4fd2-4a7d-91fa-7cccfaeee8f2	2026-08-20 13:47	2026-08-20 13:46	2026-08-20 13:46	IBB	IBB260918C00205000	call	205.0000	2026-09-18	9.8000	9.1000	9.8000	211.5316	24500.00	24500.00	0.00	25	11	398	2037	0.195385370643103	0.235509942159437	0.235509942159437	true	false	false
b52224d0-eb8c-4979-b50a-e365daad98e1	2026-08-20 13:48	2026-08-20 13:48	2026-08-20 13:48	IBB	IBB260918P00220000	put	220.0000	2026-09-18	10.5000	10.4000	11.1000	211.5500	12600.00	1050.00	11550.00	12	11	14	94	0.148936170212766	0.239012617464289	0.239012617464289	false	false	false
5eef1244-40f7-45b9-8ab4-3abef6f997df	2026-08-20 13:51	2026-08-20 13:50	2026-08-20 13:50	IBB	IBB260918P00220000	put	220.0000	2026-09-18	10.4000	9.8000	11.1000	211.6900	15600.00	0.00	15600.00	15	5	30	94	0.319148936170213	0.238857005764974	0.238857005764974	false	false	false
64cd7030-8c57-4a2b-a3e4-987cf06a6754	2026-08-20 15:45	2026-08-20 15:45	2026-08-20 15:45	IBB	IBB260918P00210000	put	210.0000	2026-09-18	4.9000	4.9000	5.1000	210.4900	14211.00	0.00	14211.00	29	10	531	504	1.05357142857143	0.230939820853091	0.230514566940318	false	false	false
75caf79b-b727-4140-bd21-db2443082b8c	2026-08-20 15:47	2026-08-20 15:46	2026-08-20 15:46	IBB	IBB260918C00205000	call	205.0000	2026-09-18	8.9000	8.8000	9.5000	210.3900	16021.00	0.00	16021.00	18	10	499	2037	0.244968090328915	0.23046699344711	0.23046699344711	false	false	false
aa5799c3-6f26-4863-880a-5baf7f5dad96	2026-08-20 15:47	2026-08-20 15:47	2026-08-20 15:47	IBB	IBB260918C00205000	call	205.0000	2026-09-18	8.8000	8.8000	9.5000	210.3100	41360.00	0.00	41360.00	47	7	546	2037	0.268041237113402	0.228319534057564	0.228319534057564	false	false	false
6777e57c-2931-41b7-805b-21021c385b7d	2026-08-21 10:03	2026-08-21 10:03	2026-08-21 10:03	IBB	IBB260918C00185000	call	185.0000	2026-09-18	29.6000	27.4000	29.6000	213.7000	35520.00	35520.00	0.00	12	12	20	145	0.137931034482759	0.321310584690263	0.321310584690263	true	false	false
ab4cf39a-c245-48ac-8995-e074f98f795e	2026-08-21 10:23	2026-08-21 10:23	2026-08-21 10:23	IBB	IBB261218C00230000	call	230.0000	2026-12-18	7.2000	6.6000	7.2000	215.4400	23040.00	23040.00	0.00	32	13	34	9	3.77777777777778	0.241369259574505	0.241369259574505	false	false	false