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:alert_rule = RepeatedHitsAscendingFill×ticker = PCG×sorted by created_at ↑×

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

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	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-08-20T13:54:26.267880Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
9af12fa8-d668-4ce6-8105-15096d2a3644	2026-09-01 14:21	2026-09-01 14:21	2026-09-01 14:21	PCG	PCG260904C00013500	call	13.5000	2026-09-04	1.0100	0.7800	1.0900	14.1750	23576.00	10648.00	6060.00	234	46	4882	2910	1.67766323024055	1.21558320586999	1.22242077574952	false	false	false	true
cfc737f0-1eb5-490b-ab47-2eb43d4240ab	2026-09-01 14:40	2026-09-01 14:40	2026-09-01 14:40	PCG	PCG260904C00014000	call	14.0000	2026-09-04	0.4600	0.4400	0.5900	13.9050	48220.00	4711.00	43509.00	1047	25	27254	7724	3.52848265147592	0.97933759326548	1.03900884725097	true	false	false	true
60b643bb-3e90-4a4d-8255-f034ffa0ad59	2026-09-02 13:35	2026-09-02 13:35	2026-09-02 13:35	PCG	PCG260925C00013000	call	13.0000	2026-09-25	0.8700	0.8100	0.9200	13.2250	12657.00	12569.00	88.00	145	6	401	191	2.09947643979058	0.560599152782855	0.568316512684955	true	false	false	true
d75bb553-5635-4a8e-98e0-82f73724fe57	2026-09-02 14:08	2026-09-02 14:08	2026-09-02 14:08	PCG	PCG270115C00017000	call	17.0000	2027-01-15	0.5500	0.5100	0.5800	13.3650	10617.00	5500.00	5061.00	193	31	54733	20639	2.65192112020931	0.481252604902998	0.481252604902998	true	false	false	true
b648d610-cf15-4636-99e0-a248a34d2a8a	2026-09-03 10:17	2026-09-03 10:17	2026-09-03 10:17	PCG	PCG261218C00019000	call	19.0000	2026-12-18	0.4100	0.3200	0.4100	13.7450	36860.00	33980.00	2880.00	901	27	1135	25640	0.0442667706708268	0.572058486447864	0.572058486447864	true	false	false	true
152beb7b-35e0-4895-a6be-4223b5d7ed1c	2026-09-03 12:48	2026-09-03 12:48	2026-09-03 12:48	PCG	PCG261218C00017000	call	17.0000	2026-12-18	0.7500	0.6700	0.7700	13.9800	122496.00	102280.00	20216.00	1625	48	1797	27976	0.0642336288247069	0.555572295620855	0.558680858153495	false	false	false	true
4705d367-9f54-4791-a76a-4d19348dfa6f	2026-09-03 12:51	2026-09-03 12:51	2026-09-03 12:51	PCG	PCG261218C00014000	call	14.0000	2026-12-18	1.6300	1.5600	1.6300	13.9501	14661.00	14661.00	0.00	90	6	288	11103	0.0259389354228587	0.525032878075213	0.528415993464654	false	false	false	true
dd12a2a7-b000-4b51-b4c0-bf5a2a56e7ef	2026-09-03 13:09	2026-09-03 13:09	2026-09-03 13:09	PCG	PCG260918C00013000	call	13.0000	2026-09-18	1.2500	1.1700	1.2700	13.9400	25238.00	738.00	24500.00	202	9	939	4407	0.213070115724983	0.586759966928775	0.608670367644434	true	false	false	true
d89bf490-5a8c-46b1-b899-2dcbb27968d7	2026-09-03 15:04	2026-09-03 15:03	2026-09-03 15:03	PCG	PCG261218C00016000	call	16.0000	2026-12-18	1.1100	0.9900	1.1200	14.0650	11548.00	11548.00	0.00	104	25	771	20662	0.0373148775529958	0.577145466485893	0.583919086903705	false	false	false	true
03fdac94-6a14-4034-a893-fcc9df6e9c44	2026-09-03 15:36	2026-09-03 15:36	2026-09-03 15:36	PCG	PCG270115C00014000	call	14.0000	2027-01-15	1.8500	1.8000	1.8500	13.9350	16637.00	16637.00	0.00	90	5	829	2909	0.284977655551736	0.530261400400857	0.533285538354864	false	false	false	true
00e1f123-7615-4926-886e-29188f951fc6	2026-09-04 09:34	2026-09-04 09:34	2026-09-04 09:34	PCG	PCG260918C00014500	call	14.5000	2026-09-18	0.4000	0.3400	0.4800	13.8500	78356.00	36.00	78242.00	1960	36	1970	8095	0.243360098826436	0.569975271309941	0.564917302536524	true	false	false	true
ccb9ec44-1bb4-4494-ab6c-b63a95189f32	2026-09-04 09:54	2026-09-04 09:54	2026-09-04 09:54	PCG	PCG270617C00020000	call	20.0000	2027-06-17	0.9500	0.9300	1.0000	13.9500	60192.00	7464.00	52728.00	631	13	631	3675	0.171700680272109	0.494111791837768	0.501099708777374	false	false	false	true
8f4ee1c1-7396-41aa-8c88-c9d99b36a0b0	2026-09-04 11:23	2026-09-04 11:23	2026-09-04 11:23	PCG	PCG270115C00016000	call	16.0000	2027-01-15	1.3500	1.2600	1.3600	14.0550	14448.00	14448.00	0.00	107	9	36070	6755	5.33974833456699	0.587722612325206	0.590708785856975	true	false	false	true
c44772d9-9ffc-492f-ba54-d91868e3e338	2026-09-04 13:56	2026-09-04 13:56	2026-09-04 13:56	PCG	PCG260911P00014500	put	14.5000	2026-09-11	0.7500	0.7500	0.8700	13.9099	76504.00	1386.00	75118.00	1018	36	1029	54	19.0555555555556	0.49762067171257	0.532921366982772	true	false	false	true
03b10071-1221-484e-9897-775e8d2e1516	2026-09-04 13:59	2026-09-04 13:59	2026-09-04 13:59	PCG	PCG260918P00014000	put	14.0000	2026-09-18	0.6200	0.6200	0.8700	13.9076	124385.00	378.00	124007.00	2006	16	2251	15811	0.142369236607425	0.535595799960058	0.544798678790819	true	false	false	true
40d3994c-a4a9-4de8-a4d5-a1a6dab60606	2026-09-08 10:49	2026-09-08 10:49	2026-09-08 10:49	PCG	PCG270115C00015000	call	15.0000	2027-01-15	2.0500	1.9800	2.0900	14.5850	20518.00	20518.00	0.00	100	9	683	23472	0.0290985003408316	0.621056946870341	0.626902239262703	false	false	false	true
9ce7ec6a-4d24-441b-9c69-c923eb901115	2026-09-08 12:30	2026-09-08 12:29	2026-09-08 12:29	PCG	PCG270917P00013000	put	13.0000	2027-09-17	1.9400	1.8000	1.9500	14.7450	42713.00	41549.00	1164.00	220	28	1144	2521	0.453788179293931	0.546265049485058	0.548536400637059	true	false	false	true
95f55e00-fd79-48d7-a9b7-aba6b90239c9	2026-09-08 14:55	2026-09-08 14:55	2026-09-08 14:55	PCG	PCG261016C00017000	call	17.0000	2026-10-16	0.5200	0.5100	0.6100	14.8450	46776.00	108.00	46668.00	898	49	3144	9724	0.323323735088441	0.640948259664638	0.652964605826221	false	false	false	true
7378f5b8-a36f-47a2-a9b8-b5b212019704	2026-09-08 14:58	2026-09-08 14:58	2026-09-08 14:58	PCG	PCG261016C00017000	call	17.0000	2026-10-16	0.4800	0.4600	0.6000	14.8450	49832.00	3724.00	46108.00	1035	41	5618	9724	0.577745783628137	0.616640563699712	0.622754054696229	true	false	false	true
ff486d32-8220-4d46-b99a-6467ac873659	2026-09-08 14:59	2026-09-08 14:59	2026-09-08 14:59	PCG	PCG261016C00017000	call	17.0000	2026-10-16	0.4500	0.4400	0.5800	14.7950	13136.00	190.00	11146.00	290	36	6239	9724	0.641608391608392	0.606810310410069	0.606810310410069	true	false	false	true
48786447-c2f7-493d-a56c-748dac23c0f7	2026-09-08 15:00	2026-09-08 15:00	2026-09-08 15:00	PCG	PCG261016C00016000	call	16.0000	2026-10-16	0.6900	0.6900	0.7500	14.8200	139974.00	70.00	139904.00	2016	34	7105	5994	1.18535201868535	0.585787062447741	0.588960450401204	false	false	false	true