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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Consumer Defensive×source = uw_flow_alerts×ticker = PG×

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

3a6f9ecb-a73b-428f-8f13-098682db301d	2026-09-22 12:28	2026-09-22 12:28	2026-09-22 12:28	PG	PG270219C00170000	call	170.0000	2027-02-19	1.5500	1.4500	1.5500	147.7900	11780.00	11780.00	0.00	76	23	81	173	0.468208092485549	0.188909703690237	0.188909703690237	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	344527468153.00	2026-10-22	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T16:35:05.886735Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
525b2ea9-7dbe-4821-8ece-96711e662359	2026-09-22 11:05	2026-09-22 11:05	2026-09-22 11:05	PG	PG261218C00155000	call	155.0000	2026-12-18	2.8500	2.8200	2.8500	147.0000	70110.00	70110.00	0.00	246	8	2761	3012	0.916666666666667	0.181848761433465	0.181848761433465	false	false	false	true
1101cdc0-b816-44f0-92e4-276b31e5553b	2026-09-22 11:05	2026-09-22 11:05	2026-09-22 11:05	PG	PG261218C00155000	call	155.0000	2026-12-18	2.8500	2.8000	3.2000	147.0000	14807.00	3692.00	11115.00	52	16	2515	3012	0.834993359893758	0.181848761433465	0.181470548324349	false	false	false
6846a4a2-5573-4dd4-ac8a-3ca84d4b56db	2026-09-22 11:04	2026-09-22 11:04	2026-09-22 11:04	PG	PG261218C00155000	call	155.0000	2026-12-18	2.9000	2.8700	2.9000	147.5200	333500.00	333500.00	0.00	1150	14	1830	3012	0.607569721115538	0.182827609720254	0.182827609720254	true	false	false
845e7166-deda-42c5-8957-c885357cdcaa	2026-09-22 11:04	2026-09-22 11:04	2026-09-22 11:04	PG	PG261218C00155000	call	155.0000	2026-12-18	3.0000	2.9900	3.2500	147.6000	73192.00	70500.00	2692.00	244	8	263	3012	0.0873173970783533	0.185539338046368	0.185164656809862	true	false	false	true
75d9e6ee-9707-4fe7-8243-d81817b05393	2026-09-21 15:57	2026-09-21 15:57	2026-09-21 15:57	PG	PG261016P00147000	put	147.0000	2026-10-16	2.9200	2.9200	2.9400	146.2100	42654.00	5860.00	36501.00	146	13	202	0	0	0.178621405918688	0.178621405918688	false	false	false	true
99446ef3-109d-4a34-be92-df99ce91992e	2026-09-21 15:56	2026-09-21 15:56	2026-09-21 15:56	PG	PG261009C00145000	call	145.0000	2026-10-09	3.2500	2.8500	3.5500	146.3000	75725.00	74100.00	1625.00	233	5	233	127	1.83464566929134	0.18422429488693	0.18422429488693	false	false	false	true
622f8230-08ad-4376-a7a4-4c124520c3e3	2026-09-21 14:26	2026-09-21 14:26	2026-09-21 14:26	PG	PG261016C00149000	call	149.0000	2026-10-16	1.7800	1.7200	1.7800	146.3600	27590.00	27590.00	0.00	155	22	237	0	0	0.178914005174405	0.178914005174405	false	false	false	true
3949a1b2-e5f0-4426-9e04-a0648c8a4490	2026-09-21 14:24	2026-09-21 14:24	2026-09-21 14:24	PG	PG261016C00147000	call	147.0000	2026-10-16	2.6300	2.5600	2.6300	146.3300	17884.00	17884.00	0.00	68	7	274	0	0	0.1807173774306	0.1807173774306	true	false	false	true
3bcf256f-93f3-4789-a395-193116ba5b10	2026-09-21 12:33	2026-09-21 12:33	2026-09-21 12:33	PG	PG261016C00152500	call	152.5000	2026-10-16	0.8300	0.8300	0.9000	146.6150	20750.00	0.00	20750.00	250	5	263	0	0	0.175695894905892	0.175695894905892	false	false	false	true
0090324c-02e0-4a24-991a-cf5c123f2035	2026-09-21 12:18	2026-09-21 12:18	2026-09-21 12:18	PG	PG261218P00130000	put	130.0000	2026-12-18	1.1500	1.1500	1.2100	146.0000	19090.00	0.00	19090.00	166	20	173	2482	0.0697018533440774	0.243076343913189	0.243076343913189	false	false	false	true
234ed212-8a68-4a33-b430-689e14a37bf0	2026-09-21 11:17	2026-09-21 11:17	2026-09-21 11:17	PG	PG270617P00130000	put	130.0000	2027-06-17	4.3000	4.3000	4.4500	146.2101	125130.00	0.00	106640.00	291	26	291	1875	0.1552	0.254254428820019	0.254254428820019	false	false	false	true
752b3022-5c60-4258-936e-31c136e61e51	2026-09-21 10:38	2026-09-21 10:38	2026-09-21 10:38	PG	PG260925C00145000	call	145.0000	2026-09-25	1.9500	1.7100	1.9500	146.1200	14235.00	14235.00	0.00	73	8	142	128	1.109375	0.210324641605808	0.209274800981527	true	false	false	true
550853f7-4146-4278-952d-a0323cb47ff5	2026-09-21 10:29	2026-09-21 10:29	2026-09-21 10:29	PG	PG270617C00160000	call	160.0000	2027-06-17	5.8500	5.8500	6.0500	146.0650	117000.00	0.00	117000.00	200	36	200	675	0.296296296296296	0.186711616183971	0.186752012203208	false	false	false	true
bcfaa34d-6ee2-4900-9c1a-e33ad0736770	2026-09-21 10:08	2026-09-21 10:08	2026-09-21 10:08	PG	PG270917P00130000	put	130.0000	2027-09-17	5.6500	5.3500	5.7000	145.8350	35030.00	25990.00	9040.00	62	11	65	318	0.20440251572327	0.258564997036851	0.258564997036851	false	false	false	true
28744c6c-5111-4f63-a123-8cbbd096bf4e	2026-09-18 14:47	2026-09-18 14:47	2026-09-18 14:47	PG	PG270115C00155000	call	155.0000	2027-01-15	3.7100	3.7000	3.8500	146.5200	90850.00	0.00	90850.00	245	18	276	7597	0.0363301303145979	0.18724593569258	0.188516699171087	false	false	false	true
78417598-d1ee-4015-b2c3-597406398554	2026-09-18 13:19	2026-09-18 13:19	2026-09-18 13:19	PG	PG261009P00146000	put	146.0000	2026-10-09	2.2000	2.1600	2.3400	146.2800	53706.00	21536.00	32170.00	244	11	334	10	33.4	0.177880731226035	0.175721979322638	true	false	false	true
d24aee2a-b2c0-4aa0-8f7e-724f1adcd283	2026-09-17 15:56	2026-09-17 15:56	2026-09-17 15:56	PG	PG261016C00150000	call	150.0000	2026-10-16	2.2300	2.2200	2.2500	147.0000	60954.00	26100.00	34854.00	273	22	575	5095	0.112855740922473	0.184224655274106	0.184224655274106	false	false	false
8fe4537c-b29a-4ff8-a416-ee185e35a996	2026-09-17 14:26	2026-09-17 14:26	2026-09-17 14:26	PG	PG260925C00146000	call	146.0000	2026-09-25	2.5600	2.5600	2.6700	147.5200	113664.00	0.00	113664.00	444	22	450	167	2.69461077844311	0.185136405620153	0.185136405620153	false	false	false	true
6d20bf64-59b0-4d3f-91d7-875b2f6250b9	2026-09-17 13:52	2026-09-17 13:52	2026-09-17 13:52	PG	PG261218C00150000	call	150.0000	2026-12-18	5.1500	5.1000	5.3000	147.4400	67980.00	1030.00	66950.00	132	28	220	1087	0.202391904323827	0.189746578860173	0.189746578860173	true	false	false
04e85042-4d74-423e-aa20-2e1ebb653e7e	2026-09-15 14:04	2026-09-15 14:03	2026-09-15 14:03	PG	PG261016C00145000	call	145.0000	2026-10-16	4.8500	4.7000	4.8500	147.0800	64491.00	64491.00	0.00	133	29	211	3214	0.0656502800248911	0.20098796171764	0.20098796171764	false	false	false	true
97546dcb-16f0-4b5f-b552-1c4e158649ce	2026-09-15 10:25	2026-09-15 10:25	2026-09-15 10:25	PG	PG270219C00150000	call	150.0000	2027-02-19	6.6500	6.6500	6.9500	145.8900	51870.00	0.00	51870.00	78	26	78	155	0.503225806451613	0.191637157218988	0.191637157218988	false	false	false	true
2fbf24b5-0321-4ffe-ba75-3f70bd28069d	2026-09-11 10:22	2026-09-11 10:22	2026-09-11 10:22	PG	PG261120C00135000	call	135.0000	2026-11-20	11.6200	11.5500	12.2000	144.5700	111555.00	1180.00	110375.00	96	11	148	149	0.993288590604027	0.18244758838694	0.191892792805522	true	false	false
67640bee-6f25-45c4-8cd8-8347ba95b3e9	2026-09-10 13:54	2026-09-10 13:54	2026-09-10 13:54	PG	PG270617P00130000	put	130.0000	2027-06-17	5.2000	5.1000	5.3500	142.8901	57200.00	52000.00	5200.00	110	13	167	1660	0.100602409638554	0.252070730408992	0.252070730408992	false	false	false	true
985c3280-6544-46b8-bc84-338568df0d12	2026-09-10 10:51	2026-09-10 10:51	2026-09-10 10:51	PG	PG280121C00145000	call	145.0000	2028-01-21	14.2000	14.2000	14.8500	142.2950	90880.00	0.00	90880.00	64	9	65	744	0.0873655913978495	0.170558733310708	0.170558733310708	false	false	false	true
077b1e79-8ceb-42d3-bff4-b37ae0e12fb8	2026-09-10 10:28	2026-09-10 10:28	2026-09-10 10:28	PG	PG261218C00170000	call	170.0000	2026-12-18	0.4000	0.4000	0.5500	142.5300	76840.00	0.00	76840.00	1921	38	1922	632	3.04113924050633	0.202444865073547	0.202444865073547	false	false	false	true
8c667c83-22d0-44c4-8287-7f294a469d65	2026-09-04 15:55	2026-09-04 15:55	2026-09-04 15:55	PG	PG270319P00135000	put	135.0000	2027-03-19	4.3000	4.3000	4.4000	146.2650	101480.00	0.00	101480.00	236	30	258	1636	0.157701711491443	0.241711156821615	0.241711156821615	false	false	false	true
ea00f62b-a66c-4457-b149-7b2b390d10d9	2026-09-03 12:00	2026-09-03 12:00	2026-09-03 12:00	PG	PG261016P00150000	put	150.0000	2026-10-16	4.7500	4.7500	4.9500	147.5500	151052.00	0.00	151052.00	318	44	447	1381	0.32367849384504	0.186018885718067	0.187144981004708	false	false	false	true
c3f5065d-4acb-4461-aa14-b045e0149982	2026-08-31 14:34	2026-08-31 14:34	2026-08-31 14:34	PG	PG261016C00155000	call	155.0000	2026-10-16	1.1000	0.9900	1.1000	145.8800	54010.00	54010.00	0.00	491	36	1012	3823	0.26471357572587	0.186045716120195	0.186045716120195	false	false	false	true
1e776915-659b-474c-8f3d-cdaf2d498801	2026-08-31 11:49	2026-08-31 11:49	2026-08-31 11:49	PG	PG261016C00145000	call	145.0000	2026-10-16	4.1500	4.0500	4.1500	144.7500	60171.00	60171.00	0.00	145	28	211	3156	0.0668567807351077	0.191504139685823	0.191504139685823	false	false	false	true
79b290fd-1634-4c8f-a8e6-842216a011e6	2026-08-31 11:35	2026-08-31 11:35	2026-08-31 11:35	PG	PG270115C00140000	call	140.0000	2027-01-15	10.5100	10.5000	10.8000	144.7400	64085.00	1055.00	63030.00	61	9	205	472	0.434322033898305	0.188886492061816	0.190468265940476	false	false	false
6b2cd606-e5d8-4647-8964-fb23db6162c0	2026-08-28 13:33	2026-08-28 13:33	2026-08-28 13:33	PG	PG261218P00140000	put	140.0000	2026-12-18	4.8000	4.8000	5.0000	143.2100	66725.00	0.00	66725.00	139	28	191	1056	0.180871212121212	0.224033073714693	0.224033073714693	false	false	false	true
ced3e965-7a85-4c14-9bed-cfa54b85dcbf	2026-08-28 11:46	2026-08-28 11:46	2026-08-28 11:46	PG	PG261218P00145000	put	145.0000	2026-12-18	7.1000	7.1000	7.3500	143.0000	128510.00	0.00	128510.00	181	25	212	1426	0.148667601683029	0.224011891974414	0.224011891974414	false	false	false	true
e172b046-c72a-47ad-b57c-14ebd7220741	2026-08-28 10:05	2026-08-28 10:05	2026-08-28 10:05	PG	PG261016P00140000	put	140.0000	2026-10-16	2.0800	2.0800	2.2700	143.7900	82369.00	209.00	82160.00	396	39	506	11671	0.0433553251649387	0.189922532770847	0.189922532770847	false	false	false	true
a5efeb12-6925-4d18-bff4-8fb74fbcea31	2026-08-27 15:23	2026-08-27 15:23	2026-08-27 15:23	PG	PG270416P00130000	put	130.0000	2027-04-16	4.0500	3.8000	4.2500	143.0000	90720.00	18225.00	72495.00	224	5	280	6	46.6666666666667	0.241061740939329	0.241061740939329	false	false	false	true
0adf2f5d-cd59-4fd4-b2e4-9833d5486bc3	2026-08-26 11:19	2026-08-26 11:18	2026-08-26 11:18	PG	PG270617C00155000	call	155.0000	2027-06-17	7.8500	7.4000	7.8500	145.1400	60445.00	60445.00	0.00	77	41	206	626	0.329073482428115	0.195673762028743	0.195761051504586	false	false	false	true
603de4fd-0f6d-41f3-8919-cae8c37cdbe1	2026-08-25 14:41	2026-08-25 14:41	2026-08-25 14:41	PG	PG261218P00145000	put	145.0000	2026-12-18	6.3000	6.3000	6.4000	145.5150	146799.00	0.00	146799.00	233	31	412	1128	0.365248226950355	0.228644621563476	0.228644621563476	false	false	false	true
aee72cbe-044b-41c9-a661-97c7cfc1eb61	2026-08-25 13:17	2026-08-25 13:17	2026-08-25 13:17	PG	PG261218P00145000	put	145.0000	2026-12-18	6.3500	6.3500	6.5000	145.3750	99695.00	0.00	99695.00	157	27	165	1128	0.146276595744681	0.228338893419624	0.228338893419624	false	false	false	true
60d791cf-df1e-4bba-9043-47443c400251	2026-08-24 14:14	2026-08-24 14:14	2026-08-24 14:14	PG	PG261120C00160000	call	160.0000	2026-11-20	1.6200	1.5800	1.6500	146.0055	51192.00	10206.00	40986.00	316	8	678	2748	0.246724890829694	0.197071529270805	0.197071529270805	false	false	false
1bf77312-c011-45d3-984c-22db30ef265a	2026-08-24 10:56	2026-08-24 10:56	2026-08-24 10:56	PG	PG270219P00140000	put	140.0000	2027-02-19	5.6000	5.6000	5.9000	146.3600	56000.00	0.00	56000.00	100	7	103	0	0	0.238624410654024	0.238624410654024	false	false	false	true
8f69aa5e-7d54-4dfa-b90f-4b2b14b806c2	2026-08-18 13:17	2026-08-18 13:17	2026-08-18 13:17	PG	PG261016C00145000	call	145.0000	2026-10-16	4.2500	4.1500	4.2500	143.6400	53550.00	53550.00	0.00	126	20	467	2665	0.175234521575985	0.19417833369753	0.19417833369753	false	false	false	true
50166a8c-34c7-44b3-9853-f750d3a3a9f8	2026-08-18 11:10	2026-08-18 11:10	2026-08-18 11:10	PG	PG261120P00140000	put	140.0000	2026-11-20	4.1000	3.9000	4.1500	144.3000	51666.00	3695.00	46741.00	126	28	141	1078	0.130797773654917	0.229160249751227	0.229160249751227	true	false	false	true
d857cbc0-43c2-4b49-8a15-1b8e96757c41	2026-08-18 11:00	2026-08-18 11:00	2026-08-18 11:00	PG	PG261016C00145000	call	145.0000	2026-10-16	4.6000	4.4500	4.7000	144.2771	110392.00	104872.00	5520.00	240	32	250	2665	0.0938086303939962	0.197104420539804	0.195255818925391	false	false	false
59fffbb2-22bc-49e7-a02c-d1e8518f437e	2026-08-17 10:11	2026-08-17 10:10	2026-08-17 10:10	PG	PG270617C00145000	call	145.0000	2027-06-17	11.4000	11.1000	12.1500	143.2900	699960.00	0.00	699960.00	614	6	614	398	1.5427135678392	0.190432267362363	0.190432267362363	false	false	false	true