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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = PCG×

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

3873d1b1-bd8b-4c64-9f8c-e13d7bcaeac0	2026-09-01 14:18	2026-09-01 14:18	2026-09-01 14:18	PCG	PCG260904C00013500	call	13.5000	2026-09-04	1.3300	1.0900	1.5000	14.6100	14002.00	6118.00	7884.00	105	5	4602	2910	1.58144329896907	1.22109031549015	1.24645193111756	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Utilities	36449502746.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
da8b87fd-fc2b-45d4-9c88-ebd22faec3c5	2026-09-01 12:05	2026-09-01 12:05	2026-09-01 12:05	PCG	PCG270115C00014000	call	14.0000	2027-01-15	1.1800	1.1400	1.1900	13.4999	42433.00	24858.00	16756.00	361	24	894	508	1.75984251968504	0.399501238882407	0.401145910326175	false	false	false	true
e3a7fa71-79c8-4e37-b6f0-dabad66a515e	2026-09-01 09:33	2026-09-01 09:33	2026-09-01 09:33	PCG	PCG260904C00014000	call	14.0000	2026-09-04	0.1900	0.1400	0.2400	13.1100	20692.00	18088.00	1350.00	1093	26	2351	7724	0.304375970999482	1.02766057930117	1.05436712591898	true	false	false	true
fc244abe-c05c-415c-8244-15e268b5deb2	2026-08-31 15:40	2026-08-31 15:40	2026-08-31 15:40	PCG	PCG261016P00014000	put	14.0000	2026-10-16	1.2400	1.1000	1.2600	13.4450	11425.00	1708.00	4842.00	92	22	10628	1547	6.87007110536522	0.494228384049893	0.51007990448906	true	false	false	true
59729e58-c777-4a21-8aba-04be8f3b9078	2026-08-31 15:30	2026-08-31 15:30	2026-08-31 15:30	PCG	PCG261016P00014000	put	14.0000	2026-10-16	1.1400	1.0400	1.2200	13.5350	119463.00	69931.00	18068.00	1046	60	9703	1547	6.2721396250808	0.480500556116974	0.482946887183657	true	false	false	true
d0980d95-eaa9-411b-b3a1-803fcca73e61	2026-08-31 15:01	2026-08-31 15:01	2026-08-31 15:01	PCG	PCG261016P00015000	put	15.0000	2026-10-16	2.0000	1.8600	2.0000	13.3500	12380.00	12181.00	199.00	62	15	483	11339	0.0425963488843813	0.506513659837764	0.512590231165072	true	false	false	true
8ec2217f-8193-4aa9-9012-a4df1d3b132a	2026-08-31 15:00	2026-08-31 15:00	2026-08-31 15:00	PCG	PCG261016P00014000	put	14.0000	2026-10-16	1.2300	1.1000	1.4300	13.3500	54883.00	45227.00	7543.00	445	38	7523	1547	4.86296056884292	0.475939437948414	0.487474825715321	true	false	false	true
44708ebe-fdeb-4984-8f5c-ec0dbb3563d6	2026-08-31 12:42	2026-08-31 12:42	2026-08-31 12:42	PCG	PCG261016P00014000	put	14.0000	2026-10-16	1.1200	1.0400	1.1300	13.4000	32422.00	29846.00	1232.00	289	40	929	1547	0.600517129928895	0.427687450578553	0.433041344626596	true	false	false	true
50ccfa23-a9f0-4e63-a98e-509cf9407e0b	2026-08-31 10:28	2026-08-31 10:28	2026-08-31 10:28	PCG	PCG260918P00013000	put	13.0000	2026-09-18	0.4000	0.3800	0.4300	13.2650	11074.00	5207.00	5259.00	280	9	2605	16166	0.161140665594457	0.440515973362325	0.466988019698309	true	false	false	true
d4660a1a-cb65-4bf3-8dd0-88b4d67467d3	2026-08-31 10:28	2026-08-31 10:27	2026-08-31 10:27	PCG	PCG260918P00015000	put	15.0000	2026-09-18	1.8700	1.7100	1.9000	13.2750	32828.00	28758.00	555.00	176	28	352	10607	0.0331856321297257	0.562820506780865	0.557600856958831	true	false	false	true
3ef1ae5b-7976-4b68-94ae-56fb773aedf1	2026-08-31 10:28	2026-08-31 10:27	2026-08-31 10:27	PCG	PCG261218P00014000	put	14.0000	2026-12-18	1.4100	1.4000	1.4700	13.2750	30203.00	12845.00	17358.00	214	18	599	449	1.33407572383074	0.37616677892436	0.375231110981086	true	false	false	true
223d7053-16c6-47a3-9374-0ef73599dc28	2026-08-31 10:15	2026-08-31 10:15	2026-08-31 10:15	PCG	PCG260918P00013000	put	13.0000	2026-09-18	0.4500	0.2900	0.5000	13.3501	16238.00	11698.00	4540.00	358	20	2028	16166	0.125448472101942	0.520930404202622	0.531500656390911	true	false	false	true
5c6a2dc5-d1b0-484a-80bf-faf5b0500d2b	2026-08-31 10:06	2026-08-31 10:06	2026-08-31 10:06	PCG	PCG261218P00013000	put	13.0000	2026-12-18	0.8400	0.6200	0.8500	13.4750	57511.00	42669.00	14842.00	685	26	744	4074	0.182621502209131	0.386013554443394	0.386013554443394	false	false	false	true
c13fad4e-ca4d-43e0-8189-f65ccf3c175e	2026-08-31 09:58	2026-08-31 09:58	2026-08-31 09:58	PCG	PCG270115C00014000	call	14.0000	2027-01-15	1.1400	1.0200	1.3700	13.5700	11189.00	9234.00	1955.00	98	5	136	21	6.47619047619048	0.37379592555271	0.37681403031534	false	false	false	true
e0749075-60b8-493f-8334-0b1444c92f50	2026-08-31 09:54	2026-08-31 09:54	2026-08-31 09:54	PCG	PCG260904P00014000	put	14.0000	2026-09-04	0.7500	0.7500	1.0500	13.5701	33996.00	82.00	33914.00	453	52	1246	14122	0.0882311287353066	0.886805522276986	0.90516193192146	true	false	false	true
cafe1b37-1d40-42e0-9b5a-f4c039ec8278	2026-08-28 14:07	2026-08-28 14:06	2026-08-28 14:06	PCG	PCG260918C00017500	call	17.5000	2026-09-18	0.5000	0.4300	0.5000	16.5050	49513.00	46937.00	2576.00	1000	5	9078	543	16.7182320441989	0.526279523479546	0.526279523479546	false	false	false	true
b4e211eb-54ea-4fb9-ab3f-785ba387fe1c	2026-08-28 13:35	2026-08-28 13:35	2026-08-28 13:35	PCG	PCG261016P00016000	put	16.0000	2026-10-16	0.7300	0.6400	0.7400	16.5000	39228.00	38446.00	489.00	538	34	1037	1308	0.792813455657492	0.416739767963844	0.415574045966201	true	false	false	true
dc204ac8-b0d0-452d-809f-522d992588ac	2026-08-28 13:11	2026-08-28 13:11	2026-08-28 13:11	PCG	PCG261016P00016000	put	16.0000	2026-10-16	0.8300	0.7000	0.9100	16.2450	20734.00	20734.00	0.00	250	7	326	1308	0.249235474006116	0.410719103805237	0.410719103805237	false	false	false	true
307e388f-3841-4871-b15c-1b7c5e96c7ed	2026-08-28 13:00	2026-08-28 13:00	2026-08-28 13:00	PCG	PCG260828P00016500	put	16.5000	2026-08-28	0.7100	0.6000	1.0100	15.9200	18280.00	7150.00	11130.00	259	14	938	2068	0.45357833655706	2.43827988826382	2.78590999417951	false	false	false	true
7c8acf19-75e6-44e8-9e8e-a0d1c11bdeac	2026-08-28 12:06	2026-08-28 12:06	2026-08-28 12:06	PCG	PCG260904P00017000	put	17.0000	2026-09-04	0.2500	0.2000	0.3300	18.0000	37064.00	32150.00	868.00	1474	177	2308	1293	1.78499613302398	0.665940831951885	0.677584450505143	true	false	false	true
5bcab4fc-7990-4a90-924c-6748ef0294b3	2026-08-28 10:07	2026-08-28 10:07	2026-08-28 10:07	PCG	PCG260904P00017500	put	17.5000	2026-09-04	0.3600	0.2600	0.3800	18.2700	17980.00	17980.00	0.00	500	5	1059	10660	0.099343339587242	0.667237934284564	0.667237934284564	false	false	false	true
63fb8296-387b-4e5f-8868-627b6b240440	2026-08-27 15:02	2026-08-27 15:02	2026-08-27 15:02	PCG	PCG261016P00017000	put	17.0000	2026-10-16	0.6000	0.5000	0.6100	17.9550	56035.00	55798.00	178.00	934	29	6537	3951	1.6545178435839	0.400058633209934	0.404284220264697	true	false	false	true
982c8d65-cc6e-4bf4-b720-0fc1b212962f	2026-08-27 14:58	2026-08-27 14:57	2026-08-27 14:57	PCG	PCG260918P00018000	put	18.0000	2026-09-18	0.8800	0.8100	0.9300	18.0050	171768.00	522.00	171246.00	1952	22	2099	26542	0.0790822093286113	0.507309421370668	0.512999685962253	true	false	false	true
62636440-49e9-476f-a380-1d112d42ca76	2026-08-27 10:34	2026-08-27 10:34	2026-08-27 10:34	PCG	PCG261016P00017000	put	17.0000	2026-10-16	0.6700	0.6500	0.6800	17.7350	10310.00	9782.00	264.00	154	15	1125	3951	0.284738041002278	0.398877274651384	0.403005054410322	false	false	false	true
a825e93f-f475-4870-81b3-6ee9f86143ea	2026-08-27 09:32	2026-08-27 09:31	2026-08-27 09:32	PCG	PCG260925C00018000	call	18.0000	2026-09-25	0.8800	0.8100	1.2200	17.8800	215897.00	49748.00	165081.00	2448	65	3383	12413	0.272536856521389	0.448248315991484	0.463331072904829	false	false	false	true
69f3ca0b-71c8-4ee5-b9dd-6f1398189ad7	2026-08-25 10:53	2026-08-25 10:52	2026-08-25 10:52	PCG	PCG260904C00019000	call	19.0000	2026-09-04	0.6200	0.5000	0.7600	18.1850	10939.00	10354.00	585.00	177	12	1071	3222	0.332402234636872	0.762010312043083	0.753353102368851	true	false	false	true
2f43758f-565e-40ce-acc4-5dc8712ff386	2026-08-25 10:53	2026-08-25 10:52	2026-08-25 10:52	PCG	PCG260904C00019000	call	19.0000	2026-09-04	0.6300	0.4500	0.6300	18.1850	31283.00	30978.00	305.00	497	35	681	3222	0.211359404096834	0.782695934178458	0.796533885902197	true	false	false	true
b789e6c7-51e7-4dab-9a84-0b32de490f7b	2026-08-25 10:50	2026-08-25 10:50	2026-08-25 10:50	PCG	PCG260828C00019000	call	19.0000	2026-08-28	0.3800	0.2000	0.3800	18.1550	15611.00	15438.00	71.00	415	41	435	3865	0.11254851228978	1.02746123567594	1.07748746057768	true	false	false	true
3f567ec1-897f-41fd-a2ce-ac79ab7a1354	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	PCG	PCG260918C00018000	call	18.0000	2026-09-18	1.2000	1.1900	1.2700	18.0350	29762.00	2642.00	2640.00	248	9	1572	66855	0.0235135741530177	0.571556270420377	0.576517816134556	false	false	false	true