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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×er_time = premarket×ticker = PM×

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

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	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	296884687861.00	2026-10-20	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T17:13:31.947650Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true