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:source = uw_flow_alerts×ticker = B×

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

47d9ebbe-313a-4a9f-9eb2-741a4c0570c9	2026-08-27 12:21	2026-08-27 12:21	2026-08-27 12:21	B	B260918C00051000	call	51.0000	2026-09-18	0.8100	0.8100	0.9000	47.3900	105624.00	0.00	105624.00	1304	35	1334	253	5.27272727272727	0.439500354731074	0.439500354731074	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	Industrials	71085541560.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4bd4210d-7d14-4342-9240-c3b619d48d16	2026-08-27 11:55	2026-08-27 11:55	2026-08-27 11:55	B	B260904C00047000	call	47.0000	2026-09-04	1.4000	1.4000	1.4100	47.4950	60480.00	0.00	60480.00	432	48	447	130	3.43846153846154	0.398971962072477	0.398971962072477	false	false	false	true
c5918b6b-d046-409a-ada8-8989c043e6a7	2026-08-27 10:15	2026-08-27 10:15	2026-08-27 10:15	B	B260904P00047000	put	47.0000	2026-09-04	1.2700	1.2600	1.5600	47.0700	144399.00	0.00	144399.00	1137	63	1180	301	3.9202657807309	0.476810436840626	0.476810436840626	false	false	false	true
112df639-f5b5-4213-b885-10a4e7d3b1ad	2026-08-26 15:38	2026-08-26 15:38	2026-08-26 15:38	B	B261016C00050000	call	50.0000	2026-10-16	2.2400	2.2400	2.2800	47.3900	64736.00	0.00	64736.00	289	20	424	2345	0.180810234541578	0.45324066128168	0.45384790314259	false	false	false	true
db204dac-9d81-41dc-ace6-135c98ec4c94	2026-08-25 14:44	2026-08-25 14:44	2026-08-25 14:44	B	B261218C00055000	call	55.0000	2026-12-18	3.1500	3.1500	3.3000	48.5900	85365.00	0.00	85365.00	271	21	556	1623	0.342575477510782	0.483922005160393	0.483959385231703	false	false	false	true
f96da147-1d9a-45f0-a7be-2256839f5fde	2026-08-25 14:41	2026-08-25 14:41	2026-08-25 14:41	B	B270115C00055000	call	55.0000	2027-01-15	3.6600	3.6500	3.8500	48.5850	91548.00	0.00	91548.00	250	14	1403	11842	0.118476608680966	0.47222741353127	0.476446929999173	false	false	false	true
73ea3ad2-35bf-4a91-be97-e625ea0c518f	2026-08-25 12:56	2026-08-25 12:56	2026-08-25 12:56	B	B260918P00048000	put	48.0000	2026-09-18	2.0000	1.9600	2.0400	48.8200	58599.00	53600.00	4999.00	293	34	440	639	0.688575899843505	0.493863247240367	0.493863247240367	true	false	false	true
890c3264-d46c-4fc6-96ba-71f775f37c6a	2026-08-25 12:38	2026-08-25 12:38	2026-08-25 12:38	B	B261218C00050000	call	50.0000	2026-12-18	5.1500	4.9500	5.2000	49.0400	472135.00	393855.00	60770.00	917	58	1210	17521	0.0690599851606643	0.483643902768425	0.484480623412603	false	false	false	true
cd105385-6a59-4489-8f54-6ce18eeb50e4	2026-08-25 11:17	2026-08-25 11:17	2026-08-25 11:17	B	B260918P00046000	put	46.0000	2026-09-18	1.2000	1.1900	1.2500	48.5500	53520.00	2280.00	46680.00	446	6	510	1620	0.314814814814815	0.47447938711909	0.47447938711909	false	false	false	true	false
ef5d607a-dbf5-42dc-b807-f1c07a085cf0	2026-08-25 10:42	2026-08-25 10:42	2026-08-25 10:42	B	B261016C00043000	call	43.0000	2026-10-16	6.6500	6.6500	6.8000	48.3850	65180.00	0.00	65180.00	98	10	116	1754	0.0661345496009122	0.448057926111095	0.446143750121176	false	false	false	true
0298cbb4-76ec-495b-ae0f-418dd421cb99	2026-08-25 09:35	2026-08-25 09:35	2026-08-25 09:35	B	B260918C00045000	call	45.0000	2026-09-18	3.9000	3.9000	4.1500	47.9000	78000.00	0.00	78000.00	200	5	200	11492	0.0174034110685694	0.432708382902641	0.432708382902641	false	false	false	true
90c05294-df18-4805-ad49-e791ccb344c6	2026-08-21 15:49	2026-08-21 15:49	2026-08-21 15:49	B	B270115C00050000	call	50.0000	2027-01-15	4.9000	4.8000	5.0000	47.7650	245082.00	23602.00	0.00	500	8	700	9032	0.0775022143489814	0.458977898194291	0.458977898194291	false	false	false	true
937bba24-2586-4ad0-a74e-1b94fc3cc004	2026-08-21 14:39	2026-08-21 14:39	2026-08-21 14:39	B	B270115C00060000	call	60.0000	2027-01-15	2.1800	2.1700	2.3400	47.5250	86764.00	0.00	86764.00	398	23	1865	8529	0.218665728690351	0.47412292572467	0.47412292572467	false	false	false	true
233bbcf5-7187-4b74-9f0e-6e41a70d4890	2026-08-21 14:35	2026-08-21 14:35	2026-08-21 14:35	B	B270115C00060000	call	60.0000	2027-01-15	2.2100	2.2100	2.2400	47.5550	76024.00	0.00	76024.00	344	20	1458	8529	0.170946183608864	0.476218143531028	0.476218143531028	false	false	false	true
43133c31-9b18-4355-9510-64d8904ad798	2026-08-21 14:01	2026-08-21 14:01	2026-08-21 14:01	B	B261218P00050000	put	50.0000	2026-12-18	6.2500	6.2500	6.3500	47.6000	60625.00	0.00	60625.00	97	10	297	687	0.432314410480349	0.4830230014899	0.4830230014899	false	false	false	true	false
5c891feb-ac40-4c05-95e2-edabf5cd16bf	2026-08-21 12:23	2026-08-21 12:23	2026-08-21 12:23	B	B261218P00045000	put	45.0000	2026-12-18	3.6000	3.5000	3.6000	47.6950	110160.00	110160.00	0.00	306	25	324	2148	0.150837988826816	0.48435886183057	0.48435886183057	false	false	false	true
3249ea47-b6bc-4f9b-b493-b1fe0964c76a	2026-08-21 10:06	2026-08-21 10:06	2026-08-21 10:06	B	B261016C00045000	call	45.0000	2026-10-16	4.6000	4.6000	4.8000	47.2100	138000.00	0.00	138000.00	300	20	312	2785	0.112028725314183	0.448137226368241	0.448137226368241	false	false	false	true
7989777e-be50-4bc4-a455-3c0e60c20ac6	2026-08-21 10:00	2026-08-21 10:00	2026-08-21 10:00	B	B261218C00050000	call	50.0000	2026-12-18	4.2500	4.0000	4.2500	47.0400	425000.00	425000.00	0.00	1000	13	1046	16837	0.0621250816653798	0.487497668654689	0.487497668654689	true	false	false	true
d2d4e5ab-11bb-4d72-8fbd-b233503b694c	2026-08-20 14:24	2026-08-20 14:24	2026-08-20 14:24	B	B261218C00045000	call	45.0000	2026-12-18	5.7000	5.7000	5.8000	46.2101	85500.00	0.00	71820.00	150	7	226	6156	0.0367121507472385	0.46024479646176	0.46024479646176	false	false	false	true
a77e8bf5-d659-470f-81ae-c558a2c46e9b	2026-08-20 13:48	2026-08-20 13:48	2026-08-20 13:48	B	B280121C00050000	call	50.0000	2028-01-21	9.3000	9.1500	9.5500	46.2550	106950.00	91140.00	15810.00	115	10	139	4310	0.0322505800464037	0.442827137214771	0.442827137214771	false	false	false	true
53ab52a9-2106-442f-bc23-c8a7bba19792	2026-08-20 12:45	2026-08-20 12:45	2026-08-20 12:45	B	B270319P00047000	put	47.0000	2027-03-19	6.8000	6.5500	6.9000	46.1650	267240.00	229840.00	37400.00	393	5	397	1497	0.265197060788243	0.498363156758357	0.498363156758357	false	false	false	true
581ccd0b-bb46-4e0c-87ab-2a9486d630cd	2026-08-20 11:54	2026-08-20 11:54	2026-08-20 11:54	B	B261002C00051000	call	51.0000	2026-10-02	1.4100	1.2500	1.4100	46.2150	96162.00	96162.00	0.00	682	38	684	1	684	0.480229706858377	0.480229706858377	false	false	false	true	false
d08eb708-b52c-4dda-9d7d-a58aaf6cfb99	2026-08-20 10:15	2026-08-20 10:15	2026-08-20 10:15	B	B260821C00042000	call	42.0000	2026-08-21	3.4500	3.2500	3.9500	45.4150	103500.00	91080.00	12420.00	300	10	309	3489	0.0885640584694755	0.849814222530587	0.849814222530587	false	false	false	true
d608fbd4-45f9-4b8a-98e0-7c3a3e1b2a9e	2026-08-20 10:14	2026-08-20 10:13	2026-08-20 10:13	B	B260918C00045000	call	45.0000	2026-09-18	2.6000	2.6000	2.7000	45.5100	73320.00	0.00	73320.00	282	11	311	12019	0.0258756968133788	0.445672519483476	0.445672519483476	false	false	false	true
13de2eaa-5eff-4024-a22d-110a0dfed9be	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	B	B261218C00047000	call	47.0000	2026-12-18	4.6500	4.6500	4.7500	45.6875	59985.00	0.00	4185.00	129	21	143	5435	0.0263109475620975	0.476210978681102	0.476210978681102	false	false	false	true
dd97b1fb-6f80-416a-8d86-e526d80cddc4	2026-08-19 15:04	2026-08-19 15:04	2026-08-19 15:04	B	B260821C00039000	call	39.0000	2026-08-21	5.7800	5.3500	5.9500	44.7700	50286.00	50286.00	0.00	87	5	116	1240	0.0935483870967742	0.68008195628505	0.68008195628505	false	false	false	true
d5303d6e-30be-43cb-9037-83c9a221d619	2026-08-19 14:07	2026-08-19 14:07	2026-08-19 14:07	B	B260828C00045000	call	45.0000	2026-08-28	1.0600	1.0600	1.1600	44.4601	109816.00	0.00	109816.00	1036	22	1122	527	2.12903225806452	0.45876806807484	0.462034703852248	false	false	false	true
29765e3c-7a8f-47ba-8b4f-16978ce5db7c	2026-08-19 13:02	2026-08-19 13:02	2026-08-19 13:02	B	B261218C00050000	call	50.0000	2026-12-18	3.2500	3.0500	3.2500	44.9300	162500.00	162500.00	0.00	500	20	2617	16975	0.154167893961708	0.478598333504982	0.478598333504982	true	false	false	true
18d43b01-5d7f-4d88-8caa-9519eed7d302	2026-08-19 12:18	2026-08-19 12:17	2026-08-19 12:17	B	B270115C00045000	call	45.0000	2027-01-15	5.8000	5.8000	5.8500	45.5200	99760.00	0.00	99180.00	172	6	224	4338	0.0516366989396035	0.452222573257184	0.452222573257184	false	false	false	true
69c36c41-4dab-41c0-904f-3d58feaef7d4	2026-08-19 10:59	2026-08-19 10:58	2026-08-19 10:58	B	B261218P00047000	put	47.0000	2026-12-18	5.7500	5.6500	5.7500	45.2000	81075.00	81075.00	0.00	141	14	152	91	1.67032967032967	0.489617940114428	0.489617940114428	false	false	false	true	false
3d9e16a6-fdc5-4d5d-b1e7-fd9001e9a633	2026-08-19 10:57	2026-08-19 10:57	2026-08-19 10:57	B	B261218C00050000	call	50.0000	2026-12-18	3.4000	3.1500	3.4500	45.2200	221340.00	221340.00	0.00	651	49	2009	16975	0.118350515463918	0.482077764014273	0.481237253976911	true	false	false	true
732adb6f-b9e5-4db0-a8b8-6a69981df5d7	2026-08-19 10:57	2026-08-19 10:57	2026-08-19 10:57	B	B261218C00050000	call	50.0000	2026-12-18	3.3500	3.3500	3.4500	45.1901	68340.00	0.00	47235.00	204	21	1286	16975	0.0757584683357879	0.477597730078468	0.477597730078468	false	false	false	true
f3e396ac-16e3-4800-afd7-37afd6e3af41	2026-08-19 10:53	2026-08-19 10:52	2026-08-19 10:52	B	B270617C00050000	call	50.0000	2027-06-17	6.0600	6.0500	6.3000	45.2500	198661.00	26840.00	171821.00	328	16	486	4386	0.110807113543092	0.444791662978323	0.445262430538941	true	false	false	true
a580a49d-e576-4966-b5fe-d08921a6c487	2026-08-19 10:40	2026-08-19 10:39	2026-08-19 10:39	B	B261218C00050000	call	50.0000	2026-12-18	3.4500	3.3000	3.5000	45.5050	205619.00	184229.00	0.00	596	34	1074	16975	0.0632695139911635	0.474515533105634	0.474092862828965	true	false	false	true
2df7f6cf-6397-4775-ab14-89198826aa17	2026-08-19 10:39	2026-08-19 10:39	2026-08-19 10:39	B	B261218C00050000	call	50.0000	2026-12-18	3.4000	3.2500	3.4500	45.4950	126140.00	95540.00	28900.00	371	25	466	16975	0.0274521354933726	0.469666566901404	0.469666566901404	true	false	false	true
b44c2f03-ce4d-4701-8ee8-9deb68c23de2	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	B	B270319C00045000	call	45.0000	2027-03-19	6.2000	6.2000	6.3000	44.4800	62000.00	0.00	62000.00	100	13	114	450	0.253333333333333	0.443957917099754	0.443957917099754	false	false	false	true
fcf63ac5-b87b-42fa-8bb0-26dc65f79be0	2026-08-19 09:30	2026-08-19 09:30	2026-08-19 09:30	B	B260918C00045000	call	45.0000	2026-09-18	1.9800	1.7400	1.9950	44.2500	61861.00	61861.00	0.00	312	20	324	11777	0.0275112507429736	0.446190626287985	0.448168322460559	true	false	false	true
eb5b32ea-2250-40c9-99e6-5ab7d8563631	2026-08-18 15:43	2026-08-18 15:43	2026-08-18 15:43	B	B280121P00040000	put	40.0000	2028-01-21	7.0500	7.0500	7.2500	42.1550	63450.00	0.00	63450.00	90	5	90	1169	0.076988879384089	0.486307427234904	0.486307427234904	false	false	false	true	false
d8dcc719-d495-420b-a8eb-8a515ceff985	2026-08-18 15:39	2026-08-18 15:39	2026-08-18 15:39	B	B261016C00055000	call	55.0000	2026-10-16	0.3800	0.3200	0.3800	42.1150	73568.00	73568.00	0.00	1936	34	1986	7609	0.261006702589039	0.481137426471837	0.481137426471837	false	false	false	true
aebf8038-b7aa-4448-80cd-20bb02c52170	2026-08-18 14:37	2026-08-18 14:37	2026-08-18 14:37	B	B280121C00060000	call	60.0000	2028-01-21	4.7500	4.7500	4.8500	42.0550	113050.00	0.00	81700.00	238	12	238	6568	0.0362362971985384	0.452399914801703	0.452399914801703	false	false	false	true
5d435806-8eed-4525-b73e-debe9b2ffbaa	2026-08-18 14:11	2026-08-18 14:11	2026-08-18 14:11	B	B280121P00035000	put	35.0000	2028-01-21	4.6500	4.4000	4.7000	41.8700	56265.00	3720.00	17205.00	121	8	178	632	0.281645569620253	0.477214749217018	0.477214749217018	false	false	false	true
f49f52e4-0065-4942-8acc-183fd2d5cfa1	2026-08-18 12:04	2026-08-18 12:04	2026-08-18 12:04	B	B270115C00050000	call	50.0000	2027-01-15	2.4000	2.3500	2.4000	42.0450	137280.00	137280.00	0.00	572	16	685	9062	0.0755903774001324	0.449324988278221	0.449324988278221	true	false	false	true
b7cf6b97-29f5-48fa-a4f6-040793ab9e11	2026-08-18 11:09	2026-08-18 11:09	2026-08-18 11:09	B	B270319P00045000	put	45.0000	2027-03-19	7.5000	7.5000	7.6500	41.7250	150050.00	0.00	150050.00	200	5	202	768	0.263020833333333	0.486841556473401	0.486841556473401	false	false	false	true
5597347b-eb7d-4d94-bc03-9a2a1edc7a45	2026-08-18 10:36	2026-08-18 10:36	2026-08-18 10:36	B	B261016P00038000	put	38.0000	2026-10-16	1.1100	1.0200	1.1100	42.2350	58941.00	58941.00	0.00	531	15	538	280	1.92142857142857	0.43653233457021	0.43653233457021	false	false	false	true	false
07454672-4021-4a2c-883b-992140744d42	2026-08-17 14:49	2026-08-17 14:48	2026-08-17 14:48	B	B261218C00045000	call	45.0000	2026-12-18	3.6000	3.4500	3.6000	42.6099	411100.00	411100.00	0.00	1142	44	1340	5376	0.249255952380952	0.441921932185886	0.441921932185886	false	false	false	true
66c2bb55-e19f-4cd9-9a3d-90a652c628f4	2026-08-17 11:47	2026-08-17 11:47	2026-08-17 11:47	B	B261218C00050000	call	50.0000	2026-12-18	2.2000	2.0300	2.2000	42.8350	97460.00	97460.00	0.00	443	31	485	14446	0.0335733074899626	0.448172204271992	0.448172204271992	false	false	false	true
fa01e0e7-e87d-4f10-8ccb-d5356a5e8c08	2026-08-17 11:12	2026-08-17 11:12	2026-08-17 11:12	B	B260918C00048000	call	48.0000	2026-09-18	0.6400	0.5700	0.6500	42.8050	61184.00	51520.00	9664.00	956	14	1008	2135	0.472131147540984	0.439094189424182	0.439094189424182	false	false	false	true