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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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 = PM×

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

ed6663a9-f8af-49a9-8795-e635b341571c	2026-09-30 15:59	2026-09-30 15:59	2026-09-30 15:59	PM	PM261120C00200000	call	200.0000	2026-11-20	4.7000	4.7000	4.8000	191.0000	10810.00	0.00	10810.00	23	12	1383	2025	0.682962962962963	0.270927193940857	0.270927193940857	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	302215145822.00	2026-10-20	premarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
e52cd7f1-71c2-4f6b-b91b-6239808faffa	2026-09-30 14:45	2026-09-30 14:45	2026-09-30 14:45	PM	PM270319P00165000	put	165.0000	2027-03-19	5.2000	5.2000	5.5000	191.4550	45760.00	0.00	45760.00	88	22	196	676	0.289940828402367	0.330718459059178	0.330718459059178	false	false	false
6c0d2dd8-854e-4a81-8f83-632786e7bbe3	2026-09-30 14:43	2026-09-30 14:43	2026-09-30 14:43	PM	PM270319P00165000	put	165.0000	2027-03-19	5.2000	5.0000	5.5000	191.3000	23400.00	13000.00	10400.00	45	7	49	676	0.0724852071005917	0.329879604716961	0.329879604716961	false	false	false
5811d9fb-953a-4784-b00b-a52473638f6c	2026-09-30 11:00	2026-09-30 11:00	2026-09-30 11:00	PM	PM261002P00190000	put	190.0000	2026-10-02	1.2500	0.8000	1.2500	192.7600	10750.00	10750.00	0.00	86	10	88	356	0.247191011235955	0.42379907627757	0.42379907627757	false	false	false
66401a7f-1dfb-4824-a509-dd2cb4574bb1	2026-09-30 09:30	2026-09-30 09:30	2026-09-30 09:30	PM	PM261218C00200000	call	200.0000	2026-12-18	7.9000	7.2000	9.0000	195.0000	23700.00	9480.00	5530.00	30	30	30	2648	0.0113293051359517	0.257778756893287	0.257778756893287	false	false	false
470e959b-c658-42ae-acef-69a70c5089d4	2026-09-29 13:19	2026-09-29 13:19	2026-09-29 13:19	PM	PM261016C00192500	call	192.5000	2026-10-16	3.9000	3.5000	3.9000	192.6000	23010.00	23010.00	0.00	59	5	149	52	2.86538461538462	0.221271061975982	0.221271061975982	false	false	false
2fcc9954-b1ad-46ad-8fcd-c6b00c98938b	2026-09-29 13:13	2026-09-29 13:13	2026-09-29 13:13	PM	PM261016P00192500	put	192.5000	2026-10-16	4.9000	4.4000	4.9000	192.7750	31850.00	31850.00	0.00	65	12	97	10	9.7	0.31462117466269	0.31462117466269	false	false	false
26f3f20c-8094-4a18-bab1-c2a42d6f6ed5	2026-09-29 13:06	2026-09-29 13:06	2026-09-29 13:06	PM	PM261120C00210000	call	210.0000	2026-11-20	2.5500	2.5500	2.7500	192.7400	21165.00	0.00	21165.00	83	15	898	6887	0.130390590968491	0.270881917169828	0.270881917169828	false	false	false
fdc3dbd7-cc80-4b76-82b7-5a06b862d1a0	2026-09-29 12:50	2026-09-29 12:50	2026-09-29 12:50	PM	PM270617P00185000	put	185.0000	2027-06-17	14.6000	14.1000	15.4000	192.5250	166438.00	157678.00	8760.00	114	11	114	405	0.281481481481481	0.330730073417213	0.330730073417213	false	false	false
417714ab-2dd1-4295-bf6c-0d4908ca00e4	2026-09-29 11:11	2026-09-29 11:11	2026-09-29 11:11	PM	PM261023P00195000	put	195.0000	2026-10-23	8.8000	8.8000	9.0000	191.0000	26400.00	0.00	26400.00	30	9	30	2	15	0.375929365240828	0.375929365240828	false	false	false
d02da96e-2921-4824-9866-da682ea59678	2026-09-29 10:32	2026-09-29 10:32	2026-09-29 10:32	PM	PM270917P00170000	put	170.0000	2027-09-17	11.5000	11.1000	11.5000	191.6200	34500.00	34500.00	0.00	30	13	36	7	5.14285714285714	0.335708777042465	0.335708777042465	false	false	false
e21eee7e-2472-4171-b8fd-b97da7a3e3b7	2026-09-28 14:37	2026-09-28 14:37	2026-09-28 14:37	PM	PM270617C00185000	call	185.0000	2027-06-17	23.2000	23.2000	24.1000	192.8350	55680.00	0.00	55680.00	24	5	64	279	0.229390681003584	0.245208523618524	0.245208523618524	false	false	false
106eb379-a2e9-492c-8eb1-774aea09beb4	2026-09-28 14:25	2026-09-28 14:25	2026-09-28 14:25	PM	PM270617C00185000	call	185.0000	2027-06-17	23.3000	23.3000	24.2000	192.7500	90880.00	2340.00	88540.00	39	11	40	279	0.14336917562724	0.247890429032798	0.247890429032798	false	false	false
029914d7-be80-4810-832c-0aa84762236b	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	PM	PM261002C00195000	call	195.0000	2026-10-02	0.7500	0.7500	1.9500	190.9150	13432.00	0.00	13432.00	179	9	179	309	0.579288025889968	0.272282734967866	0.272282734967866	false	false	false
6dda18d0-7f9d-418d-adbe-ec8520131560	2026-09-25 13:11	2026-09-25 13:11	2026-09-25 13:11	PM	PM261002P00190000	put	190.0000	2026-10-02	3.9000	3.7000	3.9000	189.3600	92430.00	92430.00	0.00	237	5	260	62	4.19354838709677	0.348253621476108	0.348253621476108	false	false	false
f521dd05-8684-451c-9fd7-d680265dab6f	2026-09-25 12:59	2026-09-25 12:59	2026-09-25 12:59	PM	PM261120C00185000	call	185.0000	2026-11-20	10.7000	10.7000	11.1000	189.2750	18190.00	0.00	18190.00	17	8	17	463	0.0367170626349892	0.26304667014083	0.26304667014083	false	false	false
9b2a0c85-a45e-4b00-885a-75f4e621f42d	2026-09-25 12:45	2026-09-25 12:44	2026-09-25 12:44	PM	PM261009C00195000	call	195.0000	2026-10-09	1.3000	1.1000	1.3000	189.2800	17675.00	17675.00	0.00	136	25	144	17	8.47058823529412	0.222166840356853	0.222166840356853	false	false	false
f904a2e7-f00c-499e-8195-6684bddbc755	2026-09-25 11:59	2026-09-25 11:59	2026-09-25 11:59	PM	PM261218C00195000	call	195.0000	2026-12-18	7.2000	7.2000	7.4000	187.0000	38160.00	0.00	37440.00	53	6	203	1976	0.102732793522267	0.262056250323921	0.262056250323921	false	false	false
958ffadc-b45c-4633-bce4-56e9dedc609f	2026-09-25 11:54	2026-09-25 11:54	2026-09-25 11:54	PM	PM270319C00190000	call	190.0000	2027-03-19	14.0000	13.9000	14.1000	188.0000	43400.00	9800.00	16800.00	31	16	31	103	0.300970873786408	0.252881735386196	0.251469574676288	false	false	false
38459ebd-ed34-477e-9c78-6402e0a96390	2026-09-25 11:52	2026-09-25 11:52	2026-09-25 11:52	PM	PM261218C00195000	call	195.0000	2026-12-18	7.1000	6.9000	7.1000	187.0000	67450.00	67450.00	0.00	95	6	149	1976	0.0754048582995951	0.26133820757658	0.26133820757658	false	false	false
e18f050d-8e7c-4d25-887d-d2d941c564c4	2026-09-25 11:18	2026-09-25 11:18	2026-09-25 11:18	PM	PM260925P00190000	put	190.0000	2026-09-25	1.8500	1.8500	2.2000	188.4600	13320.00	0.00	13320.00	72	24	75	370	0.202702702702703	0.501293670963442	0.501293670963442	false	false	false
8dfa97ca-941a-4343-9ab3-857a1d696cde	2026-09-25 10:09	2026-09-25 10:09	2026-09-25 10:09	PM	PM270319C00195000	call	195.0000	2027-03-19	12.7000	12.4000	13.0000	189.5500	33020.00	1270.00	31750.00	26	5	53	2266	0.0233892321270962	0.255379654555367	0.255379654555367	false	false	false
02d2100e-2262-448e-a033-a0b7299cfae4	2026-09-24 15:28	2026-09-24 15:28	2026-09-24 15:28	PM	PM270319C00195000	call	195.0000	2027-03-19	14.1000	13.9000	14.1000	191.9600	11280.00	11280.00	0.00	8	8	1252	1284	0.975077881619938	0.256906482421057	0.256906482421057	false	false	false
9f4e72b1-752f-4ca3-b396-230c1de4ded0	2026-09-24 12:51	2026-09-24 12:51	2026-09-24 12:51	PM	PM261218C00200000	call	200.0000	2026-12-18	7.2000	7.2000	7.8000	191.0000	21600.00	0.00	21600.00	30	7	31	1123	0.0276046304541407	0.26490447211668	0.26490447211668	false	false	false
875b5ba8-95f2-4288-b0a7-cfcda5680f3f	2026-09-24 11:54	2026-09-24 11:54	2026-09-24 11:54	PM	PM270115C00220000	call	220.0000	2027-01-15	3.1900	2.9000	3.5000	192.3650	159500.00	0.00	15500.00	500	2	501	983	0.509664292980671	0.255923695781587	0.255923695781587	false	true	false
97760086-0a20-42b7-ad31-5dcf2e0fc137	2026-09-24 11:33	2026-09-24 11:33	2026-09-24 11:33	PM	PM270319C00200000	call	200.0000	2027-03-19	12.4000	12.1000	12.4000	192.5400	68200.00	27280.00	0.00	55	7	66	1064	0.0620300751879699	0.26075457300338	0.26075457300338	false	false	false
ad4d9652-75c6-4296-897f-5f33f94169f0	2026-09-24 11:24	2026-09-24 11:24	2026-09-24 11:24	PM	PM261218P00190000	put	190.0000	2026-12-18	9.2000	9.1000	9.5000	192.0000	34040.00	0.00	20240.00	37	14	80	221	0.361990950226244	0.312281468804559	0.312281468804559	false	false	false
6b17b3c7-8d09-49b0-95e3-00f9a14a9425	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	PM	PM270319P00195000	put	195.0000	2027-03-19	16.5900	16.1000	16.7000	193.1050	54740.00	8260.00	46480.00	33	8	98	1057	0.0927152317880795	0.332262008065781	0.330367701890162	false	false	false
31223631-2d41-4b57-ab15-390658f11d0b	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	PM	PM270319C00195000	call	195.0000	2027-03-19	14.9700	14.5000	15.3000	193.1050	47910.00	35990.00	11920.00	32	6	97	1284	0.0755451713395639	0.260051622351263	0.260051622351263	false	false	false
bdcbd297-3547-4951-b335-aeede11d1cef	2026-09-23 15:49	2026-09-23 15:49	2026-09-23 15:49	PM	PM261016C00172500	call	172.5000	2026-10-16	19.2000	16.6000	20.4000	190.7051	192000.00	109440.00	82560.00	100	15	100	0	0	0.303427062274251	0.303427062274251	true	false	false
84e51124-ba60-430f-ba0d-e9fe6f2ceedc	2026-09-23 15:49	2026-09-23 15:49	2026-09-23 15:49	PM	PM261016C00185000	call	185.0000	2026-10-16	8.2000	8.2000	8.5000	190.7051	98400.00	0.00	98400.00	120	5	135	96	1.40625	0.237077664110963	0.237077664110963	false	false	false
711a33ab-46e7-453b-8790-d703d529a250	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	PM	PM261016C00195000	call	195.0000	2026-10-16	2.4500	2.3000	2.4500	189.5800	38220.00	38220.00	0.00	156	25	183	769	0.237971391417425	0.233616156934872	0.233616156934872	false	false	false
65428b65-a452-467b-81fe-5390bff92a82	2026-09-23 14:15	2026-09-23 14:14	2026-09-23 14:14	PM	PM270115C00175000	call	175.0000	2027-01-15	21.0000	20.7000	23.2000	190.0300	16800.00	0.00	16800.00	8	5	10	638	0.0156739811912226	0.248520178224961	0.248520178224961	false	false	false
c469aa48-3ab7-4258-a6a5-b21de3729e85	2026-09-22 15:00	2026-09-22 15:00	2026-09-22 15:00	PM	PM270115C00195000	call	195.0000	2027-01-15	10.0000	9.5000	10.1000	190.5600	56001.00	44000.00	12001.00	56	12	62	857	0.0723453908984831	0.254318655627099	0.254318655627099	true	false	false
512b09d7-6c46-40db-be6e-d28f1e9b615d	2026-09-22 15:00	2026-09-22 15:00	2026-09-22 15:00	PM	PM270115P00190000	put	190.0000	2027-01-15	12.1000	11.8000	12.3000	190.5600	135520.00	4840.00	130680.00	112	25	122	461	0.264642082429501	0.321537485329073	0.321537485329073	true	false	false
c77f4da1-db32-4bce-8d2f-3ace65c3d44b	2026-09-22 15:00	2026-09-22 15:00	2026-09-22 15:00	PM	PM270115C00200000	call	200.0000	2027-01-15	8.0000	7.6000	8.1000	190.5600	20000.00	9600.00	10400.00	25	8	25	2058	0.0121477162293489	0.254862073108224	0.254862073108224	false	false	false
1c6344ea-f7bb-428e-af39-85abc1a16d1a	2026-09-22 15:00	2026-09-22 15:00	2026-09-22 15:00	PM	PM270115P00195000	put	195.0000	2027-01-15	14.8000	14.5000	14.8000	190.5600	62160.00	62160.00	0.00	42	5	44	129	0.341085271317829	0.323699268875073	0.323699268875073	false	false	false
a3966676-f234-4a15-9a14-cf61a47ff164	2026-09-22 14:08	2026-09-22 14:08	2026-09-22 14:08	PM	PM270319C00195000	call	195.0000	2027-03-19	13.6000	13.6000	14.1000	190.0900	136000.00	0.00	136000.00	100	9	143	198	0.722222222222222	0.264894950897964	0.264894950897964	true	false	false
497af186-e3d0-4629-ace3-4f0e45f9fd7c	2026-09-22 11:32	2026-09-22 11:32	2026-09-22 11:32	PM	PM270917P00195000	put	195.0000	2027-09-17	24.0000	24.0000	24.2000	188.0000	12000.00	0.00	12000.00	5	5	10	11	0.909090909090909	0.339193112697362	0.339193112697362	false	false	false
9c2bb4a5-82ce-4d24-89dd-bf6c1b9cbdb2	2026-09-22 10:41	2026-09-22 10:41	2026-09-22 10:41	PM	PM270319C00190000	call	190.0000	2027-03-19	15.0000	14.7000	15.4000	188.3800	24000.00	9000.00	15000.00	16	5	25	94	0.265957446808511	0.265362569956925	0.265362569956925	false	false	false
43dac1f9-f6ef-498d-b6b5-01af29e1d451	2026-09-22 10:18	2026-09-22 10:18	2026-09-22 10:18	PM	PM261002P00190000	put	190.0000	2026-10-02	5.1000	5.1000	6.5000	188.2100	10710.00	0.00	10710.00	21	5	21	29	0.724137931034483	0.341481151506558	0.341481151506558	true	false	false
4e34c902-4ba0-4197-97b6-ae6d5ba06ad8	2026-09-21 12:13	2026-09-21 12:13	2026-09-21 12:13	PM	PM261120P00170000	put	170.0000	2026-11-20	3.0000	2.9000	3.2000	187.7450	30600.00	1200.00	13200.00	102	29	123	1020	0.120588235294118	0.334829886382389	0.334829886382389	false	false	false
78067cc9-8303-4628-b2f7-7149ddabc5ba	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	PM	PM261016C00190000	call	190.0000	2026-10-16	3.9000	3.6000	3.9000	187.8550	86580.00	86580.00	0.00	222	34	243	537	0.452513966480447	0.237080387954888	0.237080387954888	false	false	false
dab389d0-a554-4bbf-9008-47af970195de	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	PM	PM261218C00210000	call	210.0000	2026-12-18	3.2000	3.2000	3.5000	186.0000	13120.00	0.00	13120.00	41	7	46	736	0.0625	0.272470175308659	0.272470175308659	false	false	false
7c73c564-8697-4025-8c89-4bf1207dec6f	2026-09-17 14:50	2026-09-17 14:50	2026-09-17 14:50	PM	PM270115P00180000	put	180.0000	2027-01-15	8.5000	8.5000	8.8000	189.7600	141950.00	0.00	141950.00	167	20	172	708	0.242937853107345	0.324979722749445	0.324979722749445	false	false	false
b9be0979-eb9f-4a5c-95bb-982132cee8ec	2026-09-15 12:45	2026-09-15 12:45	2026-09-15 12:45	PM	PM261120C00210000	call	210.0000	2026-11-20	4.1800	4.0000	4.6000	194.0000	2069100.00	0.00	2069100.00	4950	2	5055	1984	2.54788306451613	0.277006600298032	0.277006600298032	false	true	false
ce2ca9c1-130e-433e-adee-6f23916f8889	2026-09-09 15:17	2026-09-09 15:17	2026-09-09 15:17	PM	PM270115C00195000	call	195.0000	2027-01-15	8.9000	8.9000	9.2000	185.8950	187790.00	0.00	187790.00	211	8	211	632	0.333860759493671	0.264906365943875	0.264906365943875	false	false	false
635e334b-34b9-4b14-b55f-84d4924ba416	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	PM	PM270115C00200000	call	200.0000	2027-01-15	6.1000	5.9000	6.1000	183.6700	108580.00	13420.00	0.00	178	17	1181	2460	0.480081300813008	0.259077447689409	0.259077447689409	false	false	false
3352f066-59fc-4c47-aaad-668fde94c24a	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	PM	PM270115C00200000	call	200.0000	2027-01-15	6.1000	5.9000	6.1000	183.0925	104310.00	11590.00	0.00	171	19	1003	2460	0.407723577235772	0.264079958056171	0.264079958056171	false	false	false
081a0800-3541-45fa-b4dd-06c10344cf2f	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	PM	PM270115C00200000	call	200.0000	2027-01-15	6.5000	6.0000	6.5000	184.2700	81900.00	9100.00	0.00	126	18	243	2460	0.0987804878048781	0.263687411629565	0.263687411629565	false	false	false