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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×endpoint = /api/option-trades/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	strike

f28bc3c9-4bee-4bc5-9315-1a0f2f021aa8	2026-10-01 15:59	2026-10-01 15:59	2026-10-01 15:59	B	B261002C00039000	call	39.0000	2026-10-02	1.1400	0.9800	1.1400	40.0000	11400.00	11400.00	0.00	100	9	182	50	3.64	0.545467254125655	0.545467254125655	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	Industrials	67181951840.00	2026-11-09	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
13db166c-0e31-4d02-a8e8-d2dacacc754b	2026-10-01 14:06	2026-10-01 14:05	2026-10-01 14:05	B	B261030C00043000	call	43.0000	2026-10-30	0.7400	0.6900	0.7400	39.9750	25752.00	25752.00	0.00	348	25	1267	503	2.51888667992048	0.394001699114911	0.394001699114911	false	false	false
62509018-800f-415d-9239-10fe7a7d6c17	2026-10-01 12:51	2026-10-01 12:51	2026-10-01 12:51	B	B270617C00050000	call	50.0000	2027-06-17	2.6100	2.6100	2.8000	40.1700	16182.00	0.00	16182.00	62	7	64	4554	0.0140535792709706	0.394493801157942	0.394493801157942	false	false	false
9de96221-ba67-4914-a286-9e4422674378	2026-10-01 12:36	2026-10-01 12:36	2026-10-01 12:36	B	B261030C00043000	call	43.0000	2026-10-30	0.8300	0.7800	0.8500	40.2301	49152.00	43575.00	5577.00	593	9	798	503	1.58648111332008	0.397827918518313	0.397827918518313	false	false	false
8c3e8cdd-19d1-4631-ad70-c7df8d7dd7da	2026-10-01 11:32	2026-10-01 11:32	2026-10-01 11:32	B	B281215C00035000	call	35.0000	2028-12-15	12.8500	12.6000	12.8500	40.1250	226159.00	226159.00	0.00	176	8	1127	3365	0.334918276374443	0.371109971880055	0.371109971880055	false	false	false
19129191-1f08-4ea1-98f3-2bf396452318	2026-10-01 11:27	2026-10-01 11:27	2026-10-01 11:27	B	B281215C00035000	call	35.0000	2028-12-15	12.8500	12.5000	13.3000	40.0000	115650.00	5140.00	87380.00	90	8	90	3365	0.0267459138187221	0.367776864824327	0.367776864824327	true	false	false
53ab8d87-63df-4ead-83ed-36684477b1b8	2026-10-01 10:10	2026-10-01 10:10	2026-10-01 10:10	B	B261030P00039000	put	39.0000	2026-10-30	1.2000	1.0400	1.2000	40.0000	32760.00	32760.00	0.00	273	19	274	45	6.08888888888889	0.390438710943472	0.390438710943472	false	false	false
51022169-2760-4e0e-bd12-97e52f6dcb69	2026-09-30 15:49	2026-09-30 15:49	2026-09-30 15:49	B	B261120C00044000	call	44.0000	2026-11-20	1.3700	1.3200	1.3900	40.7700	17673.00	14933.00	2740.00	129	13	4859	316	15.376582278481	0.411244759825898	0.411555764198207	true	false	false
b2a41f30-6f71-4a32-b75b-d41a73da0631	2026-09-30 15:41	2026-09-30 15:41	2026-09-30 15:41	B	B270115C00047000	call	47.0000	2027-01-15	1.5600	1.5600	1.6300	40.8150	24180.00	0.00	24180.00	155	21	161	2671	0.0602770497940846	0.394595793560132	0.394595793560132	false	false	false
61ea53b1-9ad9-44f5-8824-354182b5167f	2026-09-30 15:41	2026-09-30 15:41	2026-09-30 15:41	B	B270115C00046000	call	46.0000	2027-01-15	1.8000	1.8000	1.9000	40.8150	140760.00	0.00	140760.00	782	30	804	635	1.26614173228346	0.393108310119957	0.393108310119957	false	false	false
f3b4e640-8768-4653-9a7a-46e9433999a1	2026-09-30 14:25	2026-09-30 14:24	2026-09-30 14:24	B	B261218P00040000	put	40.0000	2026-12-18	2.4900	2.4900	2.5800	40.8400	56772.00	0.00	56772.00	228	22	233	4897	0.0475801511129263	0.40977322174472	0.40977322174472	false	false	false
b31a45db-0405-4b5e-ae98-7058b68bff53	2026-09-30 14:25	2026-09-30 14:24	2026-09-30 14:24	B	B261218P00038000	put	38.0000	2026-12-18	1.6400	1.6400	1.7300	40.8400	119720.00	0.00	119720.00	730	33	735	1675	0.438805970149254	0.407936630943489	0.407936630943489	false	false	false
5a6c0a3a-5f04-4c71-8b66-678d8997ddbd	2026-09-30 12:48	2026-09-30 12:47	2026-09-30 12:47	B	B261120C00042000	call	42.0000	2026-11-20	2.1600	2.1600	2.2600	40.0000	126576.00	0.00	126576.00	586	21	596	140	4.25714285714286	0.417421941535967	0.419686880087903	false	false	false
908d2717-55ff-40b5-8d7d-f90ab9392a76	2026-09-30 12:32	2026-09-30 12:31	2026-09-30 12:31	B	B270617P00040000	put	40.0000	2027-06-17	5.0000	5.0000	5.1500	40.8600	10500.00	0.00	10500.00	21	7	85	5636	0.0150816181689141	0.451529787606741	0.451529787606741	false	false	false
1f3e7143-92b8-4ecf-b131-9320ce1f0df0	2026-09-29 13:53	2026-09-29 13:53	2026-09-29 13:53	B	B261120C00041000	call	41.0000	2026-11-20	2.6900	2.6000	2.8700	40.8550	245059.00	228381.00	16678.00	911	19	2004	75	26.72	0.430114671873187	0.430114671873187	true	false	false
0b38492c-ccb9-4062-bd9c-48a990eb184a	2026-09-29 11:22	2026-09-29 11:22	2026-09-29 11:22	B	B281215C00055000	call	55.0000	2028-12-15	6.9500	6.9500	7.5000	40.7800	107725.00	0.00	107725.00	155	12	155	1847	0.083919870059556	0.406817642135664	0.406817642135664	false	false	false
0009e4ef-a63b-4b68-b3df-332cf940a837	2026-09-28 11:25	2026-09-28 11:25	2026-09-28 11:25	B	B261002P00042500	put	42.5000	2026-10-02	1.5800	1.5800	1.8700	41.0000	13747.00	159.00	13588.00	87	14	92	155	0.593548387096774	0.455141384223519	0.460201747350341	true	false	false
d598c573-8cf1-4b4f-8ff4-ba1fbbe89b89	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	B	B261002C00040000	call	40.0000	2026-10-02	1.3000	1.3000	1.3700	40.8300	17290.00	0.00	17290.00	133	6	158	199	0.793969849246231	0.47784307852267	0.47784307852267	false	false	false
66697b79-2af6-4198-b0c2-a246d4e4e480	2026-09-25 15:06	2026-09-25 15:06	2026-09-25 15:06	B	B260925C00040000	call	40.0000	2026-09-25	2.8400	2.4700	2.8400	42.0000	11360.00	11360.00	0.00	40	7	100	108	0.925925925925926	2.96813033450053	2.96813033450053	false	false	false
4535d91f-51ea-47cd-928c-cec54d64ba4e	2026-09-25 13:16	2026-09-25 13:16	2026-09-25 13:16	B	B261218C00046000	call	46.0000	2026-12-18	2.2500	2.2500	2.3400	42.0000	16200.00	0.00	16200.00	72	23	78	391	0.199488491048593	0.413641327888149	0.413641327888149	false	false	false
6c5d543c-e6b3-4798-b08b-39ac147ad0d5	2026-09-25 11:25	2026-09-25 11:25	2026-09-25 11:25	B	B261016P00042500	put	42.5000	2026-10-16	1.5100	1.5000	1.5100	42.0000	25066.00	25066.00	0.00	166	42	2936	103	28.504854368932	0.377942847436682	0.377942847436682	true	false	false
42bf7acf-7235-4139-88c0-e799f04149f3	2026-09-25 11:25	2026-09-25 11:24	2026-09-25 11:24	B	B261016P00042500	put	42.5000	2026-10-16	1.5100	1.4900	1.5100	42.0000	14043.00	14043.00	0.00	93	17	2589	103	25.1359223300971	0.377942847436682	0.377942847436682	false	false	false
eb90c4c7-cf6d-4b30-acbe-bc42a9615237	2026-09-25 11:24	2026-09-25 11:24	2026-09-25 11:24	B	B261016P00042500	put	42.5000	2026-10-16	1.5100	1.4900	1.5100	42.4500	45300.00	21291.00	0.00	300	64	2302	103	22.3495145631068	0.377942847436682	0.377942847436682	false	false	false
b801526a-a694-4108-b9c0-28840783009b	2026-09-25 11:24	2026-09-25 11:24	2026-09-25 11:24	B	B261016P00042500	put	42.5000	2026-10-16	1.5100	1.4900	1.5100	42.4600	45904.00	45904.00	0.00	304	18	2002	103	19.4368932038835	0.379117604269475	0.379117604269475	false	false	false
8b6bf559-1e75-4979-8249-b40d2ce36a60	2026-09-25 11:24	2026-09-25 11:24	2026-09-25 11:24	B	B261016P00042500	put	42.5000	2026-10-16	1.5100	1.4900	1.5100	42.4500	11929.00	11929.00	0.00	79	18	1620	103	15.7281553398058	0.377942847436682	0.377942847436682	true	false	false
eebfbe42-2c75-4a94-a4a4-c578d4e3c435	2026-09-25 11:24	2026-09-25 11:24	2026-09-25 11:24	B	B261016P00042500	put	42.5000	2026-10-16	1.5100	1.5000	1.5100	42.4550	12080.00	12080.00	0.00	80	15	1533	103	14.8834951456311	0.378530567557058	0.378530567557058	true	false	false
d6125bbe-7364-4606-a03e-b6f3c2e4a2dd	2026-09-25 11:23	2026-09-25 11:23	2026-09-25 11:23	B	B261016P00042500	put	42.5000	2026-10-16	1.5200	1.3900	1.5200	42.4300	152000.00	127832.00	0.00	1000	60	1000	103	9.70873786407767	0.37805140387556	0.37805140387556	true	false	false
817fa71f-399f-4b9f-ad08-ab1dad60456b	2026-09-25 10:44	2026-09-25 10:44	2026-09-25 10:44	B	B261120P00040000	put	40.0000	2026-11-20	1.5900	1.3900	1.6300	42.3700	24804.00	159.00	24645.00	156	13	156	108	1.44444444444444	0.421827263542149	0.421827263542149	true	false	false
e0770b9e-2bcd-427b-a932-f2d8ee615270	2026-09-24 11:47	2026-09-24 11:47	2026-09-24 11:47	B	B260925P00042000	put	42.0000	2026-09-25	0.6200	0.5700	0.6800	41.6200	21018.00	5332.00	15314.00	339	11	493	959	0.5140771637122	0.46382218216954	0.46382218216954	false	false	false
42db6860-ef3b-4142-980a-6688f83f720d	2026-09-24 11:45	2026-09-24 11:45	2026-09-24 11:45	B	B261218P00036000	put	36.0000	2026-12-18	1.0100	1.0100	1.0900	41.6500	10100.00	0.00	10100.00	100	9	389	677	0.574593796159527	0.423450623496465	0.423450623496465	false	false	false
c92490c8-5a4f-4a4a-a90c-e9fad3e0a04a	2026-09-24 11:45	2026-09-24 11:45	2026-09-24 11:45	B	B261218P00036000	put	36.0000	2026-12-18	1.0100	1.0100	1.0900	41.6500	10403.00	0.00	10403.00	103	6	208	677	0.307237813884786	0.423450623496465	0.423450623496465	false	false	false
00056011-7d3c-4de4-be57-e1d841cb474a	2026-09-24 11:02	2026-09-24 11:02	2026-09-24 11:02	B	B261016C00040000	call	40.0000	2026-10-16	2.7000	2.7000	2.9500	41.7500	42930.00	0.00	42930.00	159	7	761	2608	0.291794478527607	0.403246581820289	0.403246581820289	false	false	false
34f2c91d-29d1-4b55-9e75-df164ce71751	2026-09-24 11:02	2026-09-24 11:02	2026-09-24 11:02	B	B261016C00040000	call	40.0000	2026-10-16	2.7000	2.7000	2.9500	41.7600	33210.00	0.00	33210.00	123	11	569	2608	0.218174846625767	0.401314126210675	0.401314126210675	false	false	false
d51431cb-bb8e-46ef-93e0-84ccaa22cca9	2026-09-24 11:02	2026-09-24 11:02	2026-09-24 11:02	B	B261016C00040000	call	40.0000	2026-10-16	2.7000	2.7000	2.9500	41.7600	12960.00	0.00	12960.00	48	8	422	2608	0.16180981595092	0.401314126210675	0.401314126210675	false	false	false
6ec1e8a3-4171-4518-b97d-5a0055e20903	2026-09-24 10:39	2026-09-24 10:39	2026-09-24 10:39	B	B261218C00050000	call	50.0000	2026-12-18	1.1100	1.1100	1.1400	41.8000	81696.00	0.00	81696.00	736	11	964	16091	0.0599092660493444	0.431726067301032	0.431726067301032	false	false	false
05779b19-2c6b-42a3-97a5-ac3ed9c592a5	2026-09-24 10:07	2026-09-24 10:07	2026-09-24 10:07	B	B261002C00044000	call	44.0000	2026-10-02	0.3000	0.3000	0.3200	41.8650	24030.00	0.00	24030.00	801	10	804	240	3.35	0.404423265279147	0.404423265279147	false	false	false
71f64e1f-2b64-402c-85d8-a100b261c719	2026-09-23 15:36	2026-09-23 15:36	2026-09-23 15:36	B	B270617C00045000	call	45.0000	2027-06-17	5.5000	5.5000	5.8500	42.6200	92400.00	0.00	92400.00	168	12	216	1970	0.109644670050761	0.407456922431599	0.407456922431599	false	false	false
245151c7-6cc6-4466-92cc-28eb60c2e1b1	2026-09-23 15:36	2026-09-23 15:36	2026-09-23 15:36	B	B270617P00045000	put	45.0000	2027-06-17	7.3500	7.0000	7.4500	42.6200	102165.00	44100.00	58065.00	139	6	187	1919	0.0974465867639396	0.470205348323649	0.470205348323649	false	false	false
727d435c-05f6-4b47-b5f1-94f5b680dc9a	2026-09-23 10:52	2026-09-23 10:52	2026-09-23 10:52	B	B261016C00043000	call	43.0000	2026-10-16	1.6000	1.6000	1.6200	42.6100	16960.00	0.00	16960.00	106	7	159	1908	0.0833333333333333	0.406040467886355	0.406040467886355	false	false	false
dd400599-19b2-44c9-8323-f85982db55b0	2026-09-23 10:18	2026-09-23 10:18	2026-09-23 10:18	B	B280121P00027000	put	27.0000	2028-01-21	1.4900	1.4100	1.5000	42.0000	18327.00	149.00	18178.00	123	6	363	850	0.427058823529412	0.457867765246395	0.457867765246395	false	false	false
c49732bc-942d-43ac-b30c-5acc8967cad2	2026-09-22 15:35	2026-09-22 15:35	2026-09-22 15:35	B	B261218C00050000	call	50.0000	2026-12-18	1.8200	1.8100	1.9900	43.9950	23638.00	16198.00	7440.00	130	5	356	19438	0.0183146414240148	0.438834937605454	0.438834937605454	false	false	false
58d91605-b6cd-44b0-a5f2-a68fe607bfa1	2026-09-22 15:35	2026-09-22 15:35	2026-09-22 15:35	B	B261120C00050000	call	50.0000	2026-11-20	1.2500	1.2300	1.2500	43.9950	11375.00	9500.00	0.00	91	9	158	223	0.708520179372197	0.447162725028743	0.447162725028743	false	false	false
cfa016d3-1a0b-410f-95d8-025fbf4d9e70	2026-09-22 14:50	2026-09-22 14:50	2026-09-22 14:50	B	B270617C00055000	call	55.0000	2027-06-17	3.2500	3.2500	3.6000	43.9050	65000.00	0.00	65000.00	200	9	261	1156	0.225778546712803	0.421513949075047	0.421513949075047	false	false	false
dde10df2-756e-4b2d-bc67-82bd3ca6ef09	2026-09-22 13:54	2026-09-22 13:54	2026-09-22 13:54	B	B261016C00040000	call	40.0000	2026-10-16	4.3500	4.0000	4.3500	43.8500	70905.00	70905.00	0.00	163	16	765	2134	0.358481724461106	0.393527161417024	0.393527161417024	false	false	false
d6276056-6968-4eb2-9f58-85ef05de8bdf	2026-09-22 13:54	2026-09-22 13:54	2026-09-22 13:54	B	B261016C00040000	call	40.0000	2026-10-16	4.3500	4.0000	4.3500	43.8300	51765.00	51765.00	0.00	119	10	484	2134	0.22680412371134	0.399541222981181	0.399541222981181	false	false	false
502c648d-9841-4b4f-8c52-394eae0225c3	2026-09-22 12:32	2026-09-22 12:32	2026-09-22 12:32	B	B261030C00050000	call	50.0000	2026-10-30	0.5100	0.5100	0.5700	43.4000	26979.00	0.00	26979.00	529	15	543	67	8.1044776119403	0.419690197148288	0.419690197148288	false	false	false
3d92ea95-1d0d-4edd-b4e8-4c5f81b3186c	2026-09-22 10:40	2026-09-22 10:40	2026-09-22 10:40	B	B270115C00050000	call	50.0000	2027-01-15	1.9100	1.9100	2.0700	43.0200	126251.00	0.00	126251.00	661	21	664	9897	0.0670910376881883	0.423160182639969	0.423160182639969	false	false	false
6abfaaad-e5cc-4131-8dff-e0dee467307e	2026-09-21 14:53	2026-09-21 14:53	2026-09-21 14:53	B	B261002C00042000	call	42.0000	2026-10-02	1.6900	1.6900	1.8200	42.8750	16055.00	0.00	16055.00	95	22	102	39	2.61538461538462	0.398289011657368	0.398289011657368	false	false	false
0db3d6c1-c9db-4fd0-97e9-33bf2bc9b996	2026-09-21 14:53	2026-09-21 14:53	2026-09-21 14:53	B	B261002C00043500	call	43.5000	2026-10-02	0.9200	0.9200	1.0500	42.8750	18492.00	0.00	18492.00	201	21	269	61	4.40983606557377	0.396344019817976	0.396344019817976	false	false	false
65d204a2-555c-4709-9445-028ff475fb2b	2026-09-21 13:23	2026-09-21 13:23	2026-09-21 13:23	B	B260925P00043000	put	43.0000	2026-09-25	0.9600	0.9600	1.0500	42.0000	11040.00	0.00	11040.00	115	18	490	303	1.61716171617162	0.431688836416339	0.431688836416339	false	false	false