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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = PINS×

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

bb88a0f9-ddd6-4d4c-bc7c-db1801ea95c3	2026-09-28 14:49	2026-09-28 14:49	2026-09-28 14:49	PINS	PINS270617P00016000	put	16.0000	2027-06-17	1.9300	1.8600	1.9400	18.5250	29722.00	29722.00	0.00	154	5	312	0	0	0.567402759917794	0.567402759917794	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	9061365327.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T18:52:01.773916Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
d5bbc3bc-8f43-4630-8087-1b47645d862b	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	PINS	PINS270617P00015000	put	15.0000	2027-06-17	1.5500	1.5100	1.5600	18.5050	10850.00	5270.00	5580.00	70	7	157	96	1.63541666666667	0.572376517636776	0.572376517636776	false	false	false
2f517087-6fd5-41a0-92a8-82c07d4ce2f9	2026-09-28 12:53	2026-09-28 12:53	2026-09-28 12:53	PINS	PINS270319C00020000	call	20.0000	2027-03-19	2.3000	2.2900	2.3600	18.4750	23230.00	5520.00	17710.00	101	13	169	656	0.257621951219512	0.545269487214219	0.545269487214219	false	false	false
b168903c-818a-42b9-9712-143dd330cf81	2026-09-28 12:53	2026-09-28 12:52	2026-09-28 12:52	PINS	PINS270319C00020000	call	20.0000	2027-03-19	2.3000	2.2900	2.3800	18.4750	13800.00	0.00	7820.00	60	18	68	656	0.103658536585366	0.545269487214219	0.545269487214219	false	false	false
f2a84acf-c15f-438e-b91d-ddae19343329	2026-09-28 12:42	2026-09-28 12:41	2026-09-28 12:41	PINS	PINS261030C00017500	call	17.5000	2026-10-30	1.6500	1.6500	1.7400	18.0000	235125.00	0.00	235125.00	1425	31	1425	0	0	0.483108886231988	0.483108886231988	false	false	false
b1fedaf0-79b2-4879-b5f9-e27c06800abe	2026-09-25 14:26	2026-09-25 14:26	2026-09-25 14:26	PINS	PINS270115P00017000	put	17.0000	2027-01-15	1.2700	1.2300	1.3900	18.7500	11303.00	10160.00	1143.00	89	5	135	222	0.608108108108108	0.540599009814386	0.540599009814386	false	false	false
7c103b4b-a6e4-4b14-8eda-69d1eda7bc26	2026-09-25 12:27	2026-09-25 12:27	2026-09-25 12:27	PINS	PINS270115P00019000	put	19.0000	2027-01-15	2.1600	2.0800	2.3400	18.0000	10152.00	8424.00	1728.00	47	10	47	714	0.0658263305322129	0.537055641028435	0.537580405676001	false	false	false
a06b6cbd-debf-4502-8705-a3df34f2024e	2026-09-25 10:26	2026-09-25 10:26	2026-09-25 10:26	PINS	PINS270115P00018000	put	18.0000	2027-01-15	1.6600	1.6100	1.8400	18.9450	13944.00	11786.00	2158.00	84	7	84	9337	0.00899646567419942	0.544883117717021	0.544883117717021	false	false	false
c29c17cc-0e42-4d45-bcc2-2377caa899c3	2026-09-24 14:33	2026-09-24 14:33	2026-09-24 14:33	PINS	PINS280121C00020000	call	20.0000	2028-01-21	4.5000	4.4000	4.5000	18.3700	19800.00	19800.00	0.00	44	11	384	2121	0.181046676096181	0.559497902256008	0.559497902256008	false	false	false
60655767-9d10-482b-9f0e-35750d0006f3	2026-09-24 14:32	2026-09-24 14:32	2026-09-24 14:32	PINS	PINS280121C00020000	call	20.0000	2028-01-21	4.5000	4.4000	4.5000	18.3700	29700.00	29700.00	0.00	66	28	340	2121	0.16030174446016	0.559497902256008	0.559497902256008	false	false	false
6238f2d0-5d85-4f10-b374-abe399f0c0ca	2026-09-24 12:21	2026-09-24 12:21	2026-09-24 12:21	PINS	PINS261002P00018500	put	18.5000	2026-10-02	0.4600	0.4600	0.5300	18.5950	13800.00	0.00	13800.00	300	6	311	628	0.495222929936306	0.469213104639611	0.469213104639611	false	false	false
ce2b7251-a873-42db-a563-c6388cb313f7	2026-09-23 15:57	2026-09-23 15:57	2026-09-23 15:57	PINS	PINS261016P00017000	put	17.0000	2026-10-16	0.3000	0.1900	0.3000	18.4650	59130.00	59130.00	0.00	1971	10	14903	525	28.3866666666667	0.479397933259144	0.479397933259144	false	false	false
4fbb4f8c-c0df-4a10-a006-35bcbf68b2e2	2026-09-23 15:57	2026-09-23 15:57	2026-09-23 15:57	PINS	PINS261016P00017000	put	17.0000	2026-10-16	0.3000	0.1900	0.3200	18.4850	12540.00	2460.00	3330.00	418	7	12932	525	24.632380952381	0.482605833928096	0.482605833928096	false	false	false
64048285-0189-44d5-8713-155cb68269de	2026-09-23 15:51	2026-09-23 15:51	2026-09-23 15:51	PINS	PINS261016P00017000	put	17.0000	2026-10-16	0.3000	0.2300	0.3400	18.5300	274500.00	198930.00	75570.00	9150	67	9309	525	17.7314285714286	0.492158557666933	0.489780220604494	false	false	false
3cb6b917-77a8-4ebb-95de-419c9e442238	2026-09-23 15:45	2026-09-23 15:45	2026-09-23 15:45	PINS	PINS261016C00018000	call	18.0000	2026-10-16	1.1400	1.1400	1.2200	18.0000	11400.00	0.00	11400.00	100	6	110	242	0.454545454545455	0.436760542039832	0.436760542039832	false	false	false
6e098e9f-6a75-414e-9d90-796b70930d14	2026-09-23 15:23	2026-09-23 15:22	2026-09-23 15:22	PINS	PINS261002P00018500	put	18.5000	2026-10-02	0.5600	0.5250	0.5600	18.4850	16800.00	16800.00	0.00	300	5	338	338	1	0.487180676330866	0.485092749979976	false	false	false
af4aa461-8f88-4730-b2ac-222867a81ae7	2026-09-22 15:44	2026-09-22 15:44	2026-09-22 15:44	PINS	PINS270115C00020000	call	20.0000	2027-01-15	1.8000	1.5000	1.8000	18.4250	54000.00	54000.00	0.00	300	13	345	2461	0.14018691588785	0.563742757828266	0.563742757828266	false	false	false
48f1f650-7a02-48d6-abe7-9605e0d7fc96	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	PINS	PINS270319C00022000	call	22.0000	2027-03-19	2.0100	1.8400	2.0300	19.0000	22110.00	5025.00	17085.00	110	5	130	3589	0.0362217887991084	0.534543630760763	0.534543630760763	false	false	false
5d5d5fea-fb8c-4836-8b1b-a70c0d48a6de	2026-09-21 13:22	2026-09-21 13:22	2026-09-21 13:22	PINS	PINS270917C00022000	call	22.0000	2027-09-17	3.4000	3.1000	3.5000	19.0000	32300.00	8160.00	24140.00	95	8	96	170	0.564705882352941	0.538218845186346	0.538218845186346	false	false	false
5df3aa74-2b7c-4e34-97ac-c15416cdc99e	2026-09-18 10:49	2026-09-18 10:49	2026-09-18 10:49	PINS	PINS270219C00018000	call	18.0000	2027-02-19	3.1500	3.1000	3.2000	18.6950	10710.00	2835.00	7875.00	34	11	117	259	0.451737451737452	0.557615612440016	0.557615612440016	false	false	false
620c98ad-e5d0-43f2-9cb0-99ef3abdedfd	2026-09-18 10:37	2026-09-18 10:37	2026-09-18 10:37	PINS	PINS270219P00020000	put	20.0000	2027-02-19	3.2500	3.2500	3.4000	18.6400	12350.00	0.00	12350.00	38	7	101	615	0.164227642276423	0.550498310863756	0.550498310863756	false	false	false
5c34a1d3-6df5-4ac6-9d14-0f5dd11b61e0	2026-09-16 10:37	2026-09-16 10:37	2026-09-16 10:37	PINS	PINS270219P00021000	put	21.0000	2027-02-19	3.9500	3.8500	4.0000	18.5699	16195.00	8295.00	7900.00	41	7	41	295	0.138983050847458	0.551391488788431	0.551391488788431	false	false	false
0b40fd74-1445-4bd2-a714-dd6c1213fd81	2026-09-16 10:01	2026-09-16 10:01	2026-09-16 10:01	PINS	PINS261009C00018000	call	18.0000	2026-10-09	1.2900	1.2700	1.3800	18.6800	78948.00	129.00	78819.00	612	9	616	5	123.2	0.480467253126341	0.480467253126341	false	false	false
c4da1b0c-2c49-41eb-8b7b-c9898fdbb56b	2026-09-15 14:22	2026-09-15 14:22	2026-09-15 14:22	PINS	PINS280121C00020000	call	20.0000	2028-01-21	4.7500	4.7500	4.9500	18.9150	29454.00	479.00	28975.00	62	7	244	1835	0.132970027247956	0.544886998085014	0.549701846859978	false	false	false
ded128ca-b687-432d-a2ac-6ad5bf8eaa42	2026-09-15 13:55	2026-09-15 13:55	2026-09-15 13:55	PINS	PINS270319P00017000	put	17.0000	2027-03-19	1.8500	1.8300	1.8500	18.8750	34040.00	34040.00	0.00	184	29	189	192	0.984375	0.566477193892087	0.566477193892087	false	false	false
e49236e3-1868-4d95-b8ca-21a05a4b173f	2026-09-15 11:31	2026-09-15 11:31	2026-09-15 11:31	PINS	PINS270319C00020000	call	20.0000	2027-03-19	2.6600	2.6100	2.6600	18.8250	12768.00	12768.00	0.00	48	17	146	508	0.28740157480315	0.55660246800046	0.55660246800046	false	false	false
80332336-ac63-4d6e-a2bc-d7974f1d55f5	2026-09-14 12:46	2026-09-14 12:46	2026-09-14 12:46	PINS	PINS270319C00022000	call	22.0000	2027-03-19	2.2800	2.2100	2.2800	19.5300	15504.00	15504.00	0.00	68	7	164	3187	0.0514590524003765	0.552452007053766	0.552452007053766	false	false	false
950bd810-888d-4054-9c69-2beec8499dcc	2026-09-14 12:46	2026-09-14 12:46	2026-09-14 12:46	PINS	PINS270319P00020000	put	20.0000	2027-03-19	3.1000	3.0000	3.1000	19.5400	18290.00	18290.00	0.00	59	5	59	6274	0.00940388906598661	0.549797917738293	0.549797917738293	false	false	false
067bdf91-e275-4c01-80f1-42d2fdf1a067	2026-09-14 12:46	2026-09-14 12:46	2026-09-14 12:46	PINS	PINS270617P00022000	put	22.0000	2027-06-17	4.8500	4.7000	4.9000	19.5500	45105.00	35405.00	9700.00	93	5	314	247	1.27125506072874	0.546162878119001	0.546162878119001	false	false	false
e31ef640-6b1b-4db4-818b-13ba0d034cb4	2026-09-14 12:45	2026-09-14 12:44	2026-09-14 12:44	PINS	PINS270917P00022000	put	22.0000	2027-09-17	5.3000	5.0000	5.4500	19.5165	15370.00	5830.00	9010.00	29	5	134	3	44.6666666666667	0.546192888891813	0.546192888891813	false	false	false
88608ed4-87a1-4d13-bf4a-518c027475c8	2026-09-14 12:43	2026-09-14 12:43	2026-09-14 12:43	PINS	PINS270617P00022000	put	22.0000	2027-06-17	4.8500	4.7000	5.2500	19.5350	66930.00	42680.00	24250.00	138	6	138	247	0.558704453441296	0.545094261036607	0.545094261036607	false	false	false
19be7bce-06dd-4aba-b1b1-35979c1c06df	2026-09-14 12:43	2026-09-14 12:43	2026-09-14 12:43	PINS	PINS270917C00022000	call	22.0000	2027-09-17	3.7500	3.5500	3.9500	19.5350	44625.00	35625.00	9000.00	119	6	129	93	1.38709677419355	0.564127936621069	0.564127936621069	false	false	false
235cfaf9-609b-4e30-87c5-78e88f40ea32	2026-09-14 12:42	2026-09-14 12:42	2026-09-14 12:42	PINS	PINS270319P00021000	put	21.0000	2027-03-19	3.7000	3.5000	3.7000	19.5150	14800.00	14800.00	0.00	40	6	114	2	57	0.548290508285663	0.548290508285663	false	false	false
e507ee68-7756-466a-95c6-a851c12c3fd4	2026-09-14 12:42	2026-09-14 12:42	2026-09-14 12:42	PINS	PINS270319P00021000	put	21.0000	2027-03-19	3.7000	3.5000	3.9500	19.5200	27380.00	20720.00	6660.00	74	8	74	2	37	0.548721293090999	0.548721293090999	false	false	false
98adb33c-fd65-43bc-b606-0f7e30a0144a	2026-09-14 12:41	2026-09-14 12:41	2026-09-14 12:41	PINS	PINS270319P00022000	put	22.0000	2027-03-19	4.3000	4.2000	4.4000	19.5150	12040.00	9460.00	2580.00	28	5	123	3410	0.0360703812316716	0.54061335442275	0.54061335442275	false	false	false
9e343959-2502-497c-a089-f2996d3ef84b	2026-09-14 12:41	2026-09-14 12:41	2026-09-14 12:41	PINS	PINS270917P00022000	put	22.0000	2027-09-17	5.3000	4.9500	5.7500	19.5100	47700.00	36570.00	11130.00	90	9	91	3	30.3333333333333	0.546396454606272	0.545814543034649	false	false	false
e4ac5e8c-1497-423a-a374-38b88697f33c	2026-09-14 12:23	2026-09-14 12:23	2026-09-14 12:23	PINS	PINS261016P00019000	put	19.0000	2026-10-16	0.8200	0.8200	0.8600	19.4550	13366.00	0.00	13366.00	163	8	325	400	0.8125	0.468268717820923	0.468268717820923	false	false	false
32d02b6b-b8e3-4918-82b5-4bb24513266c	2026-09-14 12:23	2026-09-14 12:23	2026-09-14 12:23	PINS	PINS261016P00018000	put	18.0000	2026-10-16	0.4500	0.4500	0.4800	19.4550	14085.00	0.00	14085.00	313	22	347	391	0.887468030690537	0.470344655644009	0.470344655644009	false	false	false
513c1b5b-afc9-4365-bf51-a4bbe2ea84d0	2026-09-14 11:51	2026-09-14 11:51	2026-09-14 11:51	PINS	PINS261016P00019000	put	19.0000	2026-10-16	0.8300	0.8300	0.9100	19.4300	13031.00	0.00	13031.00	157	27	162	400	0.405	0.468301872601222	0.468301872601222	false	false	false
eba88c4c-e80b-4066-b5fb-6e6b51e7a5e5	2026-09-14 11:08	2026-09-14 11:08	2026-09-14 11:08	PINS	PINS261009C00019000	call	19.0000	2026-10-09	1.3000	1.0400	1.2900	19.2650	50758.00	50758.00	0.00	390	19	390	19	20.5263157894737	0.585144326674079	0.590200623250292	true	false	false
b4ec75fe-6571-413e-b98c-ce061b287a22	2026-09-14 11:08	2026-09-14 11:08	2026-09-14 11:08	PINS	PINS260925C00019500	call	19.5000	2026-09-25	0.6600	0.4900	0.6600	19.2650	60852.00	60852.00	0.00	922	24	929	419	2.21718377088306	0.567973333588823	0.567973333588823	true	false	false
9af178b0-e900-4e13-aef4-de513046eb2f	2026-09-14 11:08	2026-09-14 11:08	2026-09-14 11:08	PINS	PINS261002C00019000	call	19.0000	2026-10-02	1.4200	0.5100	4.8000	19.4550	16188.00	142.00	9372.00	114	6	130	90	1.44444444444444	0.746938113637901	0.680860567524116	true	false	false
998f9154-ff6e-40ef-b8ca-ce01affb8a07	2026-09-10 13:01	2026-09-10 13:01	2026-09-10 13:01	PINS	PINS261002C00019500	call	19.5000	2026-10-02	0.6000	0.5700	0.6400	18.0000	228420.00	60.00	228360.00	3807	27	3807	6	634.5	0.461486778052292	0.468351507467934	false	false	false
a8672f9c-2a4f-49c2-a17e-b5018cef6fd3	2026-09-10 11:16	2026-09-10 11:16	2026-09-10 11:16	PINS	PINS260925C00019000	call	19.0000	2026-09-25	0.6000	0.6000	0.6200	18.7150	18540.00	0.00	18540.00	309	22	313	6	52.1666666666667	0.472962348856819	0.472962348856819	false	false	false
a821e88a-f6ce-4a73-b081-082647af7fab	2026-09-10 09:38	2026-09-10 09:37	2026-09-10 09:37	PINS	PINS261218P00020000	put	20.0000	2026-12-18	3.0500	2.9600	3.0500	18.2500	14335.00	14335.00	0.00	47	13	48	592	0.0810810810810811	0.555486532396077	0.555486532396077	false	false	false
3e19f65a-afaa-4ea4-9df2-e956618bc3e5	2026-09-09 12:58	2026-09-09 12:58	2026-09-09 12:58	PINS	PINS270115P00015000	put	15.0000	2027-01-15	0.7700	0.7300	0.7700	18.0000	78848.00	78848.00	0.00	1024	41	1028	2606	0.39447429009977	0.546955638541901	0.546955638541901	false	false	false
57a61dda-c0e4-45c6-922c-72d091da89b5	2026-09-09 11:55	2026-09-09 11:55	2026-09-09 11:55	PINS	PINS260918P00018500	put	18.5000	2026-09-18	0.3900	0.3000	0.4100	19.0350	136500.00	136500.00	0.00	3500	8	3751	21	178.619047619048	0.534522084760046	0.534522084760046	false	false	false
7c8451b4-9ab9-4242-b0b7-47a2e411ff19	2026-09-09 11:50	2026-09-09 11:50	2026-09-09 11:50	PINS	PINS260925C00019500	call	19.5000	2026-09-25	0.6000	0.5400	0.6000	19.0050	12000.00	12000.00	0.00	200	19	240	141	1.70212765957447	0.504648622428139	0.504648622428139	false	false	false
e9b254d0-14db-47f1-9cf9-7cb617169c8f	2026-09-09 11:31	2026-09-09 11:31	2026-09-09 11:31	PINS	PINS270115P00017000	put	17.0000	2027-01-15	1.1500	1.1000	1.1500	19.3800	11730.00	11730.00	0.00	102	14	103	48	2.14583333333333	0.519984362913405	0.519984362913405	false	false	false
d27e7012-b74a-444e-bee0-a3ba70d34a09	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	PINS	PINS260918C00020000	call	20.0000	2026-09-18	0.6200	0.5600	0.7400	19.9450	23064.00	16554.00	6510.00	372	18	378	1744	0.216743119266055	0.532331464153458	0.510255017545843	true	false	false