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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

16a47bcf-c8bc-475c-bd51-2ce74ac44e61	2026-08-25 11:43	2026-08-25 11:43	2026-08-25 11:43	IBB	IBB260918C00210000	call	210.0000	2026-09-18	9.3000	8.9000	10.0000	216.5099	24181.00	0.00	24181.00	26	9	30	470	0.0638297872340425	0.230419737248367	0.230956370896405	true	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-25T16:00:53.835343Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7691eeed-7d46-4e03-8235-0a5318d76cd7	2026-08-25 11:05	2026-08-25 11:05	2026-08-25 11:05	IBB	IBB261016C00225000	call	225.0000	2026-10-16	4.8800	4.6000	5.0000	216.8850	38088.00	38088.00	0.00	78	17	104	6	17.3333333333333	0.233564710426583	0.237417509132593	true	false	false	true
55e56234-349a-434a-9bf9-d76aa5abef86	2026-08-25 10:50	2026-08-25 10:50	2026-08-25 10:50	IBB	IBB260918C00220000	call	220.0000	2026-09-18	3.5000	3.4000	3.8000	216.2400	10152.00	1750.00	8402.00	29	5	76	304	0.25	0.221746189269741	0.221746189269741	false	false	false	true
aa86874d-535c-4203-aaa2-b0100dc3fa61	2026-08-25 10:18	2026-08-25 10:18	2026-08-25 10:18	IBB	IBB261218C00215000	call	215.0000	2026-12-18	13.4000	12.2000	13.4000	215.7800	117920.00	117920.00	0.00	88	30	89	65	1.36923076923077	0.242541197498763	0.242541197498763	false	false	false	true
92c81743-9a6e-469f-8850-f0ecb62d1a90	2026-08-24 11:23	2026-08-24 11:23	2026-08-24 11:23	IBB	IBB261016P00210000	put	210.0000	2026-10-16	6.4000	6.0000	6.4000	211.4850	40320.00	40320.00	0.00	63	19	142	6	23.6666666666667	0.239460383459171	0.239460383459171	false	false	false	true
4e032667-b69d-434a-81d5-6d2f2adfda16	2026-08-24 10:21	2026-08-24 10:20	2026-08-24 10:20	IBB	IBB261016P00210000	put	210.0000	2026-10-16	6.6000	6.2000	6.6000	211.0950	44879.00	44879.00	0.00	68	25	68	6	11.3333333333333	0.240465016453715	0.240465016453715	false	false	false	true
31b510a8-526c-4bb2-88a9-d509f0c0935d	2026-08-21 15:02	2026-08-21 15:02	2026-08-21 15:02	IBB	IBB260918C00215000	call	215.0000	2026-09-18	4.9000	4.6000	4.9000	213.4800	34790.00	34790.00	0.00	71	7	180	174	1.03448275862069	0.22574118902854	0.22574118902854	true	false	false	true
fab91868-bc6d-458d-acf3-6b9aa677725f	2026-08-21 14:10	2026-08-21 14:10	2026-08-21 14:10	IBB	IBB260918C00205000	call	205.0000	2026-09-18	11.2100	11.2000	11.8000	213.0000	22420.00	0.00	22420.00	20	11	47	1822	0.0257958287596048	0.227631954988112	0.233169259778455	false	false	false	true
d1fe177d-be3c-4aa1-b517-683e2d523c73	2026-08-21 11:28	2026-08-21 11:27	2026-08-21 11:27	IBB	IBB260918C00215000	call	215.0000	2026-09-18	5.5000	5.5000	5.8000	214.6200	36300.00	0.00	36300.00	66	22	79	174	0.454022988505747	0.226872686943128	0.226872686943128	false	false	false	true
c06596e7-f312-4d7a-8938-4e9a7d3a7b2c	2026-08-21 10:52	2026-08-21 10:51	2026-08-21 10:51	IBB	IBB270319P00205000	put	205.0000	2027-03-19	10.1000	9.7000	10.2000	214.4000	34340.00	34340.00	0.00	34	9	34	40	0.85	0.258090093117724	0.258090093117724	false	false	false	true
8b91002a-c0bd-4a2e-bc87-d27bd80bf30f	2026-08-21 10:47	2026-08-21 10:47	2026-08-21 10:47	IBB	IBB260918C00210000	call	210.0000	2026-09-18	8.5000	8.2000	9.2000	214.6600	43350.00	850.00	42500.00	51	22	58	362	0.160220994475138	0.233309351636421	0.233309351636421	true	false	false	true
78e1a1ea-5772-4b4e-bbbd-7cd90cbbe035	2026-08-21 10:25	2026-08-21 10:24	2026-08-21 10:24	IBB	IBB260821C00215000	call	215.0000	2026-08-21	1.0300	0.7000	1.4000	215.3100	10324.00	0.00	10324.00	100	10	402	612	0.656862745098039	0.4030056880128	0.4030056880128	false	false	false	true
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	true
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	true
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	true
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	true
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	true
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	true
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	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	true
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
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	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	true
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
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	true
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	true
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	true
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	true
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	true
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
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	true
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	true
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	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	true
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
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
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	true
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	true
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	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	true
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
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	true
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	true
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	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	true
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
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	true
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	true
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	true