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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = NN×

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

af7e9e82-b4bf-4965-ae69-200101565693	2026-09-21 15:29	2026-09-21 15:29	2026-09-21 15:29	NN	NN261016P00013000	put	13.0000	2026-10-16	0.6000	0.6000	0.6500	15.2900	18060.00	0.00	18060.00	301	5	311	757	0.410832232496697	1.00947930677445	1.00947930677445	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	2643563191.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
66fe728f-b7e9-427c-aac7-0a2af8760fc8	2026-09-21 13:43	2026-09-21 13:43	2026-09-21 13:43	NN	NN261120C00017000	call	17.0000	2026-11-20	2.0000	2.0000	2.1500	15.5950	19800.00	0.00	19800.00	99	14	124	11088	0.0111832611832612	0.994894356317973	0.994894356317973	false	false	false	true
0820555a-4d31-49dc-8444-d2d1deefbaa5	2026-09-21 12:44	2026-09-21 12:44	2026-09-21 12:44	NN	NN261218C00022000	call	22.0000	2026-12-18	1.4000	1.1000	1.4500	15.4800	37940.00	140.00	37800.00	271	7	271	9304	0.0291272570937231	1.04477673390869	1.04477673390869	false	false	false	true
9cafa325-26ef-49eb-877f-0a00320b7047	2026-09-21 11:41	2026-09-21 11:41	2026-09-21 11:41	NN	NN261218P00015000	put	15.0000	2026-12-18	2.6500	2.6500	2.7500	15.4200	17490.00	0.00	17490.00	66	14	288	646	0.445820433436532	0.996768284661301	0.996768284661301	false	false	false	true
ced53bff-f7fb-4e11-bb47-a2c1f01e84f2	2026-09-21 11:27	2026-09-21 11:27	2026-09-21 11:27	NN	NN261120C00020000	call	20.0000	2026-11-20	1.2000	1.1000	1.2000	15.3100	26876.00	26876.00	0.00	224	30	228	102	2.23529411764706	1.0441768974307	1.0441768974307	false	false	false	true
6d0cf9c4-eb24-4d3e-89a2-12e0404f09ea	2026-09-21 10:33	2026-09-21 10:33	2026-09-21 10:33	NN	NN261218P00015000	put	15.0000	2026-12-18	2.8000	2.7500	2.8500	15.1000	25201.00	11200.00	14001.00	90	9	91	646	0.140866873065015	1.00652467254993	1.00652467254993	false	false	false	true
7d9cc8bb-f335-4b8c-968b-d208e13dd8ec	2026-09-18 15:57	2026-09-18 15:57	2026-09-18 15:57	NN	NN261009C00021000	call	21.0000	2026-10-09	0.3000	0.2500	0.3500	14.0000	15570.00	5730.00	9840.00	519	22	2935	1810	1.62154696132597	1.33756813048165	1.33756813048165	false	false	false	true
7276a81f-8e78-48a5-bd70-fb5d859e2c0c	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	NN	NN261009C00021000	call	21.0000	2026-10-09	0.3000	0.3000	0.3500	14.4200	30000.00	0.00	6000.00	1000	7	1790	1810	0.988950276243094	1.29659943842252	1.29659943842252	false	false	false	true
005e300a-1766-4456-b89e-37aca47652d5	2026-09-18 12:25	2026-09-18 12:25	2026-09-18 12:25	NN	NN270115C00015000	call	15.0000	2027-01-15	2.8000	2.6500	2.8500	13.8800	14000.00	10920.00	2800.00	50	5	50	15428	0.00324086077262121	1.00502540723621	1.00502540723621	false	false	false	true
1ad47c46-93ac-4f5c-9fd8-245ca06d5278	2026-09-18 12:06	2026-09-18 12:06	2026-09-18 12:06	NN	NN261016C00020000	call	20.0000	2026-10-16	0.3000	0.2500	0.3500	13.0000	24000.00	14970.00	9000.00	800	25	2392	10937	0.21870714089787	1.12700062027915	1.11938448692935	false	false	false	true
bd412fca-1ffe-4478-ae7a-88009c846c4a	2026-09-18 11:59	2026-09-18 11:59	2026-09-18 11:59	NN	NN270115C00020000	call	20.0000	2027-01-15	1.6000	1.4000	1.6000	13.7450	16000.00	16000.00	0.00	100	7	100	8805	0.0113571834185122	1.0437729027248	1.0437729027248	false	false	false	true
c314eea5-5860-4411-90d6-5957b0356fd0	2026-09-18 11:54	2026-09-18 11:54	2026-09-18 11:54	NN	NN261218C00017000	call	17.0000	2026-12-18	1.7500	1.7000	1.8000	13.6800	12950.00	10500.00	2275.00	74	11	183	9530	0.019202518363064	1.0246720188346	1.0246720188346	false	false	false	true
01084deb-435b-464a-bb03-b9caa6fb4d3a	2026-09-18 11:05	2026-09-18 11:05	2026-09-18 11:05	NN	NN270115C00017000	call	17.0000	2027-01-15	2.1500	2.0000	2.3000	14.0600	11180.00	3440.00	7740.00	52	6	107	3716	0.028794402583423	0.9628519040622	0.9628519040622	false	false	false	true
94314115-6420-458e-bf09-368091c01cd7	2026-09-16 15:17	2026-09-16 15:17	2026-09-16 15:17	NN	NN261016C00017000	call	17.0000	2026-10-16	0.9000	0.8000	0.9500	14.5150	13320.00	13140.00	0.00	148	25	4160	35793	0.116223842650798	1.04489928844322	1.04489928844322	false	false	false	true
55184031-3fe9-4534-87a8-f6eb38419a48	2026-09-16 14:24	2026-09-16 14:24	2026-09-16 14:24	NN	NN261016C00017000	call	17.0000	2026-10-16	0.9000	0.8500	0.9500	14.6000	36360.00	900.00	8460.00	404	14	3626	35793	0.10130472438745	1.02536678332071	1.02536678332071	true	false	false	true
8f2afc7c-22bd-4f18-8a58-110aa2699c9d	2026-09-16 14:22	2026-09-16 14:21	2026-09-16 14:21	NN	NN261016C00017000	call	17.0000	2026-10-16	0.9000	0.9000	0.9500	14.6400	13770.00	0.00	180.00	153	5	2701	35793	0.0754616824518761	1.01618081264253	1.01618081264253	true	false	false	true
79ccc1d9-9617-4db4-8fc9-022f4724fe51	2026-09-16 14:11	2026-09-16 14:11	2026-09-16 14:11	NN	NN261030C00016000	call	16.0000	2026-10-30	1.5000	1.3500	1.7500	14.7300	27300.00	0.00	27300.00	182	9	250	0	0	0.968681018410026	0.966351107221152	false	false	false	true	false
178a9177-c389-40f7-9d04-59cce2b43792	2026-09-16 14:11	2026-09-16 14:11	2026-09-16 14:11	NN	NN261030C00016000	call	16.0000	2026-10-30	1.5000	1.4000	1.7500	14.7300	17400.00	0.00	17400.00	116	5	463	0	0	0.966351107221152	0.966351107221152	false	false	false	true	false
03e6cac1-48f6-4f5e-9296-00faddbca18f	2026-09-16 14:09	2026-09-16 14:08	2026-09-16 14:08	NN	NN261002C00016000	call	16.0000	2026-10-02	0.6000	0.5000	0.8500	14.7400	11460.00	9660.00	1800.00	191	10	458	389	1.17737789203085	0.866254713611719	0.866254713611719	false	false	false	true
0b0ea116-d903-47f4-9ca4-ca439c5726d0	2026-09-16 13:59	2026-09-16 13:59	2026-09-16 13:59	NN	NN261016C00017000	call	17.0000	2026-10-16	0.8500	0.8500	0.9000	14.0000	18700.00	0.00	18700.00	220	5	1588	35793	0.0443662168580449	0.989903769081567	0.989903769081567	false	false	false	true
7e3cef71-797c-412a-909f-4d35efc6da10	2026-09-16 13:58	2026-09-16 13:58	2026-09-16 13:58	NN	NN261016C00017000	call	17.0000	2026-10-16	0.8000	0.7500	0.9000	14.0000	29360.00	20640.00	8720.00	367	24	1363	35793	0.0380800715223647	0.953161631131769	0.953161631131769	false	false	false	true
27f71dfa-40a7-459c-a4af-3639ff68f25a	2026-09-16 13:58	2026-09-16 13:58	2026-09-16 13:58	NN	NN261016C00017000	call	17.0000	2026-10-16	0.8000	0.8000	0.8500	14.0000	58240.00	0.00	58240.00	728	47	996	35793	0.0278266700192775	0.937551502992764	0.937551502992764	false	false	false	true
4f7b3ad3-4e3b-4bb7-b900-299c5c3e37a2	2026-09-16 12:02	2026-09-16 12:02	2026-09-16 12:02	NN	NN261218C00017000	call	17.0000	2026-12-18	2.2500	2.1000	2.3000	14.7900	25425.00	13500.00	11925.00	113	25	113	9468	0.0119349387410224	1.01048242404362	1.00544225169859	false	false	false	true
c62df917-b86b-4946-98c9-686e1dc371f2	2026-09-15 15:55	2026-09-15 15:55	2026-09-15 15:55	NN	NN261016C00017000	call	17.0000	2026-10-16	1.0000	0.5000	1.2000	14.0000	105500.00	8900.00	96600.00	1055	12	2407	32778	0.0734334004515224	0.998704420149408	0.998704420149408	false	false	false	true
aae3ac6a-8629-4844-9838-eabee28f2500	2026-09-15 15:02	2026-09-15 15:02	2026-09-15 15:02	NN	NN261016C00017000	call	17.0000	2026-10-16	0.9500	0.8000	1.0000	14.8900	30305.00	30305.00	0.00	319	8	322	32778	0.00982366221245958	0.973039948176606	0.973039948176606	false	false	false	true
580d9118-6979-417f-b134-06e096f791a0	2026-09-15 13:56	2026-09-15 13:56	2026-09-15 13:56	NN	NN261009C00020000	call	20.0000	2026-10-09	0.4000	0.2000	0.4000	14.8500	30912.00	30912.00	0.00	774	45	1731	1845	0.938211382113821	1.13276978014643	1.1318474119945	false	false	false	true
7cb61488-50b1-4f31-ac4e-95cf3cd3bd01	2026-09-15 10:30	2026-09-15 10:29	2026-09-15 10:29	NN	NN261218C00017000	call	17.0000	2026-12-18	2.4000	2.4000	2.5000	15.0400	23520.00	0.00	1200.00	98	9	98	9458	0.0103615986466483	1.00758331428001	1.00758331428001	false	false	false	true
df46810d-b813-48af-a6c3-87392f2939f4	2026-09-14 14:59	2026-09-14 14:59	2026-09-14 14:59	NN	NN261218P00015000	put	15.0000	2026-12-18	2.6500	2.6000	2.7500	15.5700	11130.00	2650.00	8480.00	42	5	62	495	0.125252525252525	0.980212485643977	0.980212485643977	false	false	false	true
1b18c161-3ea5-4d81-8b0f-846f12257cc0	2026-09-14 12:15	2026-09-14 12:15	2026-09-14 12:15	NN	NN261120P00016000	put	16.0000	2026-11-20	2.8500	2.7000	2.9000	15.3000	11115.00	2280.00	7695.00	39	11	214	1356	0.157817109144543	0.960844286813953	0.963469163179768	false	false	false	true
56cdcf3b-fc5f-483b-8d4a-9eeb4301e06d	2026-09-14 10:37	2026-09-14 10:36	2026-09-14 10:36	NN	NN261218P00017000	put	17.0000	2026-12-18	4.2000	4.1000	4.3000	15.0500	14700.00	0.00	8400.00	35	5	60	11	5.45454545454545	1.01118265031678	1.01118265031678	false	false	false	true
2780e980-61af-458d-97a4-ddfe9aad8ad6	2026-09-14 10:01	2026-09-14 10:01	2026-09-14 10:01	NN	NN261120P00014000	put	14.0000	2026-11-20	2.0500	1.8250	2.1000	14.8100	19270.00	410.00	17015.00	94	7	94	171	0.549707602339181	1.01943058583132	1.01943058583132	false	false	false	true
2dea3b45-edda-4b0f-a7f5-73556bd1cdd9	2026-09-11 14:52	2026-09-11 14:51	2026-09-11 14:51	NN	NN261218P00016000	put	16.0000	2026-12-18	3.6000	3.4000	3.7000	15.0800	86760.00	14400.00	26640.00	241	6	301	93	3.23655913978495	1.01809138974369	1.01809138974369	false	false	false	true
bb542598-4dab-4d43-9b3e-f511bb7ab149	2026-09-09 15:01	2026-09-09 15:01	2026-09-09 15:01	NN	NN261016C00017000	call	17.0000	2026-10-16	1.3000	1.1000	1.3500	15.1000	13780.00	13650.00	130.00	106	10	4979	27724	0.179591689510893	1.04030544171404	1.03351317373377	false	false	false	true
ae287ce0-2ca8-49df-be5b-9012ad50c7ba	2026-09-09 15:01	2026-09-09 15:01	2026-09-09 15:01	NN	NN261016C00017000	call	17.0000	2026-10-16	1.3000	1.2500	1.3500	15.1150	149240.00	0.00	140270.00	1148	13	4853	27724	0.175046890780551	1.01992900539654	1.03011712887349	false	false	false	true
5201ed64-5337-4705-901e-2f30c897909f	2026-09-09 14:39	2026-09-09 14:39	2026-09-09 14:39	NN	NN261016C00017000	call	17.0000	2026-10-16	1.3000	1.3000	1.3500	15.2500	180960.00	0.00	180960.00	1392	7	3309	27724	0.119355071418266	1.01313663945466	0.999550148807521	false	false	false	true
0afc65b4-4eca-4c48-a6a8-6e75f888803e	2026-09-09 14:38	2026-09-09 14:38	2026-09-09 14:38	NN	NN261002C00016000	call	16.0000	2026-10-02	1.0000	1.0000	1.2500	15.2600	17986.00	0.00	17986.00	180	18	337	85	3.96470588235294	0.846972683687751	0.814050357510879	true	false	false	true
0b23bafe-789e-48c6-ac7c-722c10e3b7e9	2026-09-09 12:28	2026-09-09 12:28	2026-09-09 12:28	NN	NN261218C00018000	call	18.0000	2026-12-18	2.3500	2.3500	2.5500	15.1800	14805.00	0.00	14805.00	63	17	332	32560	0.0101965601965602	1.0343608823597	1.0343608823597	false	false	false	true
102f5b8a-ef2d-4f2e-8790-670e43cdac65	2026-09-09 11:53	2026-09-09 11:53	2026-09-09 11:53	NN	NN261120C00017000	call	17.0000	2026-11-20	2.2500	2.0500	2.4000	15.1500	113625.00	37350.00	53550.00	505	9	2257	8351	0.270267033888157	1.08114349884581	1.08114349884581	true	false	false	true
c854d366-017a-407a-b482-941b83f5825c	2026-09-09 11:48	2026-09-09 11:48	2026-09-09 11:48	NN	NN261016C00017000	call	17.0000	2026-10-16	1.3000	1.1000	1.4000	15.1400	219310.00	35490.00	183820.00	1687	7	1716	27724	0.0618958303275141	1.02445708693432	1.02445708693432	false	false	false	true
0aee422a-d071-43ed-ae2c-d1e67e659e72	2026-09-09 11:46	2026-09-09 11:46	2026-09-09 11:46	NN	NN261002C00016000	call	16.0000	2026-10-02	1.2000	1.0000	1.2000	15.3100	18720.00	18720.00	0.00	156	16	156	85	1.83529411764706	0.962671008221242	0.962671008221242	true	false	false	true
09b48057-5363-4876-9fcd-df76822d6470	2026-09-09 11:35	2026-09-09 11:34	2026-09-09 11:34	NN	NN261120C00017000	call	17.0000	2026-11-20	2.0000	1.6500	2.1500	14.7200	343400.00	135600.00	207800.00	1717	31	1721	8351	0.206083103819902	1.07780717782296	1.06675490862387	true	false	false	true
0078cc33-ce19-42be-875c-febc9dc11109	2026-09-09 11:33	2026-09-09 11:33	2026-09-09 11:33	NN	NN261016C00018000	call	18.0000	2026-10-16	0.8500	0.7000	0.8500	14.6900	17079.00	16994.00	0.00	201	17	201	1185	0.169620253164557	1.01826304409195	1.01248274417596	false	false	false	true
eb9a8581-8bec-41d7-80dc-97ed06844c00	2026-09-09 11:11	2026-09-09 11:10	2026-09-09 11:10	NN	NN261120C00016000	call	16.0000	2026-11-20	2.3000	2.3000	2.4500	14.7500	59570.00	0.00	25990.00	259	15	284	25	11.36	1.05304871014815	1.05304871014815	false	false	false	true
9d5b161a-6425-4b56-a3ed-c45a4f907be0	2026-09-09 10:05	2026-09-09 10:05	2026-09-09 10:05	NN	NN260911C00015500	call	15.5000	2026-09-11	0.5500	0.3000	0.6000	15.3800	11605.00	11605.00	0.00	211	21	225	1261	0.178429817605075	1.35785891382337	1.33105427209424	true	false	false	true
679cc096-2a8f-4aa3-99d0-1fa0ed93e033	2026-09-08 15:01	2026-09-08 15:01	2026-09-08 15:01	NN	NN261120P00013000	put	13.0000	2026-11-20	1.6500	1.6500	1.7000	15.1400	49995.00	0.00	49995.00	303	8	317	176	1.80113636363636	1.05934397201788	1.05934397201788	false	false	false	true
38afbcba-f9f5-49b8-bf90-b8c2a19adc40	2026-09-08 14:53	2026-09-08 14:53	2026-09-08 14:53	NN	NN261016C00017000	call	17.0000	2026-10-16	1.3500	1.3500	1.4000	14.8900	143505.00	0.00	143505.00	1063	6	28155	494	56.9939271255061	1.0925794591887	1.0925794591887	false	false	false	true
fa6b91cb-dc80-40ff-ae93-d6c23134f3c3	2026-09-08 14:53	2026-09-08 14:52	2026-09-08 14:52	NN	NN261016C00017000	call	17.0000	2026-10-16	1.3500	1.3500	1.4000	14.8900	32940.00	0.00	32940.00	244	11	27036	494	54.7287449392713	1.0925794591887	1.0925794591887	true	false	false	true
9bea8727-e60e-42d0-a90e-25acdca21f86	2026-09-08 14:53	2026-09-08 14:52	2026-09-08 14:52	NN	NN260925C00015000	call	15.0000	2026-09-25	1.2000	1.2000	1.5000	14.9600	17040.00	0.00	17040.00	142	8	402	259	1.55212355212355	0.938093346158749	0.938093346158749	true	false	false	true
4f5ddb6f-aec2-490c-b04e-8033d89f38bf	2026-09-08 14:53	2026-09-08 14:52	2026-09-08 14:52	NN	NN260918C00015500	call	15.5000	2026-09-18	0.8000	0.8000	0.9000	14.9600	10370.00	0.00	10370.00	129	7	131	225	0.582222222222222	1.03707792362632	1.03707792362632	true	false	false	true
4d9b8d88-3379-4220-9798-645843af6181	2026-09-08 14:53	2026-09-08 14:52	2026-09-08 14:52	NN	NN260918C00015000	call	15.0000	2026-09-18	1.0000	1.0000	1.1000	14.9600	52900.00	0.00	52900.00	529	20	852	6172	0.138042773817239	1.02500080640954	1.02500080640954	false	false	false	true