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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = PCG×

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

cee23377-3945-4f5b-a85b-b52bdc977f37	2026-09-28 15:31	2026-09-28 15:31	2026-09-28 15:31	PCG	PCG270917P00013000	put	13.0000	2027-09-17	2.3300	2.2900	2.5000	12.0050	13048.00	3029.00	10019.00	56	7	3773	6238	0.604841295286951	0.441299891488023	0.441299891488023	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Utilities	32027320427.00	2026-10-22	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T19:36:53.342339Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
1dff1317-6cbc-4fbe-958e-f6a3737746a5	2026-09-28 15:21	2026-09-28 15:20	2026-09-28 15:20	PCG	PCG270917P00013000	put	13.0000	2027-09-17	2.3500	2.3500	2.3600	12.0150	22325.00	0.00	22325.00	95	11	3697	6238	0.592657903174094	0.446531507600066	0.446531507600066	false	false	false
53bfc7d8-4764-4056-9abd-e881976f07f7	2026-09-28 13:46	2026-09-28 13:46	2026-09-28 13:46	PCG	PCG270917P00013000	put	13.0000	2027-09-17	2.3400	2.3400	2.3900	12.0350	34398.00	0.00	34398.00	147	5	3592	6238	0.575825585123437	0.446290493018999	0.446290493018999	false	false	false
9ecb899d-e34b-4f2e-8882-a951b4887596	2026-09-28 12:25	2026-09-28 12:25	2026-09-28 12:25	PCG	PCG261218C00013000	call	13.0000	2026-12-18	0.6400	0.6200	0.6400	11.9950	16448.00	16448.00	0.00	257	9	843	2813	0.299680056878777	0.437984022960424	0.437984022960424	true	false	false
4af5f5f5-eb41-4b93-9420-3d2bdcd69ef4	2026-09-28 11:21	2026-09-28 11:20	2026-09-28 11:20	PCG	PCG270917P00010000	put	10.0000	2027-09-17	1.0400	0.9500	1.0400	11.0000	10400.00	10400.00	0.00	100	7	101	11162	0.00904855760616377	0.480207004514767	0.480207004514767	false	false	false
2a2e7d76-4c12-48f0-a068-f2489d1589c4	2026-09-28 10:45	2026-09-28 10:45	2026-09-28 10:45	PCG	PCG261016C00012000	call	12.0000	2026-10-16	0.3800	0.3800	0.4200	12.0000	89452.00	0.00	89452.00	2354	18	2830	8367	0.33823353651249	0.331471303902784	0.331471303902784	true	false	false
529a9bfe-4fa0-4850-a400-71ffc98c2fc8	2026-09-25 12:56	2026-09-25 12:56	2026-09-25 12:56	PCG	PCG270319C00013000	call	13.0000	2027-03-19	1.2700	1.2300	1.2800	12.2300	17272.00	2794.00	14478.00	136	10	443	901	0.491675915649279	0.439085846318937	0.439085846318937	true	false	false
9e244df9-909d-4216-8def-15544129cf24	2026-09-25 11:09	2026-09-25 11:09	2026-09-25 11:09	PCG	PCG261016P00012000	put	12.0000	2026-10-16	0.3400	0.3000	0.3500	12.1850	12886.00	136.00	12750.00	379	16	414	14635	0.028288349846259	0.380997013314559	0.37921040718313	false	false	false
8f6d2e1a-cca3-4c5b-a7c9-5322dcc0a1a7	2026-09-25 10:42	2026-09-25 10:42	2026-09-25 10:42	PCG	PCG270617P00013000	put	13.0000	2027-06-17	2.1100	2.1100	2.3700	12.2842	21944.00	0.00	21944.00	104	6	539	4775	0.112879581151832	0.466347010712716	0.466347010712716	false	false	false
08a0137f-5006-4530-b283-8dbaad65fe4a	2026-09-25 10:42	2026-09-25 10:42	2026-09-25 10:42	PCG	PCG270617P00013000	put	13.0000	2027-06-17	2.1100	2.1100	2.3700	12.2801	43888.00	0.00	43888.00	208	8	435	4775	0.0910994764397906	0.465905713086568	0.465905713086568	false	false	false
bbb390e8-91fd-4213-a0ff-16626ceccef6	2026-09-25 10:37	2026-09-25 10:37	2026-09-25 10:37	PCG	PCG270617P00013000	put	13.0000	2027-06-17	2.1300	2.1200	2.2200	12.2750	10224.00	0.00	10224.00	48	16	226	4775	0.0473298429319372	0.470194738219522	0.470194738219522	false	false	false
90dc0460-0a35-41ca-9df0-b132bebef3ad	2026-09-24 14:53	2026-09-24 14:53	2026-09-24 14:53	PCG	PCG280121C00015000	call	15.0000	2028-01-21	1.4700	1.4700	1.5300	12.2150	11025.00	0.00	11025.00	75	6	607	6689	0.0907460008969951	0.380796396669543	0.380796396669543	false	false	false
fc952fe1-afb4-45db-9cbb-f615a231055d	2026-09-24 14:53	2026-09-24 14:53	2026-09-24 14:53	PCG	PCG280121C00015000	call	15.0000	2028-01-21	1.4700	1.4700	1.5300	12.2150	16317.00	0.00	16317.00	111	7	532	6689	0.0795335625654059	0.380796396669543	0.380796396669543	false	false	false
63d2c21c-622c-4c3f-b191-5fc07f88ef15	2026-09-24 14:50	2026-09-24 14:50	2026-09-24 14:50	PCG	PCG270115C00013000	call	13.0000	2027-01-15	1.0400	1.0400	1.0700	12.0000	12792.00	0.00	12792.00	123	9	258	3897	0.0662047729022325	0.478741340383151	0.478741340383151	false	false	false
28a65f01-af61-495d-ae57-cf13b330af89	2026-09-24 12:03	2026-09-24 12:03	2026-09-24 12:03	PCG	PCG261120C00014000	call	14.0000	2026-11-20	0.4000	0.3200	0.4200	12.1850	19840.00	19800.00	40.00	496	31	1591	6419	0.247857921794672	0.509853870392954	0.508959158005042	true	false	false
147af8d8-fa3f-42b0-a975-1bc304d4e178	2026-09-24 12:02	2026-09-24 12:02	2026-09-24 12:02	PCG	PCG261120C00014000	call	14.0000	2026-11-20	0.3900	0.3100	0.3900	12.1600	22347.00	22347.00	0.00	573	33	896	6419	0.13958560523446	0.508093397295469	0.507221440249122	true	false	false
03c07584-f46a-40d8-b324-9e8de3016845	2026-09-24 11:59	2026-09-24 11:59	2026-09-24 11:59	PCG	PCG270115C00015000	call	15.0000	2027-01-15	0.4900	0.4600	0.5000	12.0600	53375.00	53327.00	48.00	1088	35	18606	29958	0.621069497296215	0.497129314543531	0.501597059750885	false	false	false
9f5a528f-261c-4518-b068-aaa6c25a6dbc	2026-09-24 11:59	2026-09-24 11:59	2026-09-24 11:59	PCG	PCG270115C00015000	call	15.0000	2027-01-15	0.4900	0.4600	0.4900	12.0550	11515.00	11515.00	0.00	235	8	17518	29958	0.584751986113893	0.497741772644846	0.497741772644846	true	false	false
b52737dc-e641-48c3-b25b-40b525d0f8b1	2026-09-24 11:59	2026-09-24 11:58	2026-09-24 11:58	PCG	PCG270115C00015000	call	15.0000	2027-01-15	0.4800	0.4600	0.4900	12.0521	10811.00	8256.00	2555.00	226	11	17247	29958	0.575705988383737	0.493603204912049	0.493603204912049	true	false	false
99a6500b-55c3-46eb-9f65-6fdb981b3490	2026-09-24 11:55	2026-09-24 11:55	2026-09-24 11:55	PCG	PCG270115C00015000	call	15.0000	2027-01-15	0.4800	0.4500	0.4800	12.0248	20880.00	20880.00	0.00	435	25	16740	29958	0.558782295213299	0.496932895957564	0.496932895957564	true	false	false
52f0c13f-96e3-4751-adf7-cd41e6306b72	2026-09-24 11:55	2026-09-24 11:55	2026-09-24 11:55	PCG	PCG270115C00015000	call	15.0000	2027-01-15	0.4800	0.4500	0.4900	12.0250	11280.00	624.00	3216.00	235	13	16975	29958	0.566626610588157	0.49690849186903	0.49690849186903	true	false	false
f400908f-0e57-4b14-820e-b0095dee86e5	2026-09-24 11:55	2026-09-24 11:55	2026-09-24 11:55	PCG	PCG270115C00017000	call	17.0000	2027-01-15	0.2000	0.2000	0.2500	12.0250	43300.00	0.00	43300.00	2165	31	4397	61952	0.0709743026859504	0.48543867723327	0.48543867723327	true	false	false
f83a7717-f7b2-4b52-a5b0-5c0eebba2964	2026-09-24 11:55	2026-09-24 11:55	2026-09-24 11:55	PCG	PCG270115C00017000	call	17.0000	2027-01-15	0.2200	0.2200	0.2500	12.0400	38390.00	0.00	38390.00	1745	54	2196	61952	0.0354467975206612	0.497424338919516	0.497424338919516	true	false	false
6ab31dea-1b48-4a46-a451-4d3fad515530	2026-09-24 11:54	2026-09-24 11:53	2026-09-24 11:53	PCG	PCG270115C00015000	call	15.0000	2027-01-15	0.4800	0.4600	0.4800	12.0350	22464.00	22464.00	0.00	468	22	16149	29958	0.539054676547166	0.495688490901637	0.495688490901637	true	false	false
0ec94009-1af6-4b4f-a1a2-fb6e3ac7dd53	2026-09-24 11:40	2026-09-24 11:40	2026-09-24 11:40	PCG	PCG261120C00013000	call	13.0000	2026-11-20	0.6000	0.6000	0.6300	12.1150	10200.00	0.00	10200.00	170	11	1721	5711	0.301348275258274	0.481075667184298	0.481075667184298	false	false	false
1b46b685-2c96-48ab-875a-1c3c2a70789c	2026-09-24 11:33	2026-09-24 11:33	2026-09-24 11:33	PCG	PCG280121C00013000	call	13.0000	2028-01-21	2.0500	2.0500	2.1900	12.1200	29725.00	0.00	29725.00	145	11	172	4226	0.04070042593469	0.376301636996775	0.376301636996775	false	false	false
aabcfa04-bde5-4519-a64d-720129f4720f	2026-09-24 11:14	2026-09-24 11:14	2026-09-24 11:14	PCG	PCG270115C00015000	call	15.0000	2027-01-15	0.5100	0.4600	0.5100	12.1072	16218.00	16218.00	0.00	318	11	15120	29958	0.504706589224915	0.500211831156658	0.500211831156658	true	false	false
ad660908-9b33-475d-a4b5-b7b848d1df7e	2026-09-24 11:10	2026-09-24 11:10	2026-09-24 11:10	PCG	PCG261016P00012000	put	12.0000	2026-10-16	0.3800	0.3800	0.4200	12.0000	12920.00	0.00	12920.00	340	55	432	14154	0.0305214073760068	0.38015905196561	0.38015905196561	false	false	false
f2d24d30-db6c-49bb-b8a3-54507cdd40e6	2026-09-24 10:46	2026-09-24 10:46	2026-09-24 10:46	PCG	PCG270115C00015000	call	15.0000	2027-01-15	0.5100	0.4800	0.5200	12.0000	24429.00	24174.00	51.00	479	15	14530	29958	0.485012350624207	0.499248820051348	0.499248820051348	true	false	false
91693f65-4c53-4f43-8f1a-8dda08ae4503	2026-09-24 10:34	2026-09-24 10:34	2026-09-24 10:34	PCG	PCG261120P00011000	put	11.0000	2026-11-20	0.4000	0.3500	0.4800	12.1950	12440.00	440.00	12000.00	311	6	318	18136	0.0175341861490957	0.491565527082738	0.491565527082738	false	false	false
565f9fe1-907b-4d5b-abdb-cdf06c06c5fb	2026-09-24 10:29	2026-09-24 10:29	2026-09-24 10:29	PCG	PCG270917P00013000	put	13.0000	2027-09-17	2.2800	2.2800	2.3700	12.2500	17328.00	0.00	17328.00	76	11	132	6200	0.0212903225806452	0.451458148736414	0.451458148736414	false	false	false
3e5fd6f9-f17a-40fc-ab53-55da492f2981	2026-09-24 09:54	2026-09-24 09:54	2026-09-24 09:54	PCG	PCG261016P00013000	put	13.0000	2026-10-16	0.9800	0.8600	0.9900	12.2700	19600.00	11564.00	8036.00	200	5	202	29422	0.00686561076745293	0.455836423378885	0.455836423378885	false	false	false
e426d270-35ac-4d6e-bea7-6b72fcb51a85	2026-09-23 15:38	2026-09-23 15:38	2026-09-23 15:38	PCG	PCG270617C00013000	call	13.0000	2027-06-17	1.8300	1.7500	1.8300	12.4496	73200.00	73200.00	0.00	400	11	518	191	2.71204188481675	0.446897886009498	0.446897886009498	false	false	false
610f1bca-d769-4060-97fa-3a5de5b4506f	2026-09-23 15:02	2026-09-23 15:02	2026-09-23 15:02	PCG	PCG261218C00014000	call	14.0000	2026-12-18	0.6100	0.5800	0.6100	12.4400	40016.00	40016.00	0.00	656	6	1726	13568	0.12721108490566	0.46816025220256	0.46816025220256	true	false	false
da715663-3830-4f22-bd37-af50ccf64081	2026-09-23 13:53	2026-09-23 13:53	2026-09-23 13:53	PCG	PCG261120C00013000	call	13.0000	2026-11-20	0.8100	0.7700	0.8200	12.5250	81081.00	80919.00	0.00	1001	25	2214	3413	0.648696161734544	0.491789931794355	0.491789931794355	true	false	false
a33def8d-0d62-44a5-8c63-eda7cd5d0985	2026-09-23 13:31	2026-09-23 13:31	2026-09-23 13:31	PCG	PCG270319P00014000	put	14.0000	2027-03-19	2.4000	2.3000	2.4100	12.5350	27360.00	20400.00	6960.00	114	8	114	3675	0.0310204081632653	0.481918377731926	0.481918377731926	false	false	false
195fc5c0-0c2f-46bb-a1e7-aaab63ed1381	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	PCG	PCG261120C00013000	call	13.0000	2026-11-20	0.7900	0.7700	0.8000	12.0000	16085.00	13667.00	2418.00	204	6	764	3413	0.223849985350132	0.479341278012939	0.479341278012939	true	false	false
6b1ad7ec-5586-4c80-90f2-851e6e17bf2e	2026-09-23 12:18	2026-09-23 12:18	2026-09-23 12:18	PCG	PCG261120P00013000	put	13.0000	2026-11-20	1.1600	1.1600	1.2200	12.5500	35380.00	0.00	35380.00	305	8	1213	4542	0.26706296785557	0.47917532209795	0.477866908163243	false	false	false
170ffde2-9f3d-4bd5-b419-87de0d7f34f9	2026-09-23 12:18	2026-09-23 12:18	2026-09-23 12:18	PCG	PCG261120P00013000	put	13.0000	2026-11-20	1.1600	1.1600	1.2300	12.5450	25520.00	0.00	25520.00	220	8	908	4542	0.199911933069133	0.476555006259663	0.476555006259663	false	false	false
d9759d2c-ba28-4351-aaae-b5544ea1e58b	2026-09-23 12:13	2026-09-23 12:13	2026-09-23 12:13	PCG	PCG261120P00013000	put	13.0000	2026-11-20	1.1800	1.1800	1.2800	12.5300	23129.00	0.00	23129.00	196	9	561	4542	0.123513870541612	0.483972421421001	0.48265563852305	false	false	false
9d412fce-8111-4b34-8e17-f417f7e9249d	2026-09-23 11:00	2026-09-23 11:00	2026-09-23 11:00	PCG	PCG270917C00013000	call	13.0000	2027-09-17	1.9700	1.9700	2.0700	12.0000	28960.00	198.00	28762.00	147	18	180	499	0.360721442885772	0.391273760281859	0.393335880012887	false	false	false
44824173-b93f-45a9-84ec-0a3cb3a22807	2026-09-23 10:59	2026-09-23 10:59	2026-09-23 10:59	PCG	PCG261016C00014000	call	14.0000	2026-10-16	0.0800	0.0800	0.1400	12.0000	11657.00	0.00	11657.00	1457	10	1726	17319	0.0996593336797737	0.375687248433744	0.375687248433744	false	false	false
39ec2ea1-f8d2-4407-9d14-4713947aebf6	2026-09-22 14:35	2026-09-22 14:35	2026-09-22 14:35	PCG	PCG261218C00018000	call	18.0000	2026-12-18	0.2300	0.1900	0.2400	12.9950	11408.00	11293.00	115.00	496	6	12397	82431	0.150392449442564	0.543718452631138	0.543718452631138	true	false	false
4e0fb409-b973-43aa-a6f4-aabdaf7f8145	2026-09-22 14:35	2026-09-22 14:35	2026-09-22 14:35	PCG	PCG261218C00018000	call	18.0000	2026-12-18	0.2300	0.1900	0.2400	12.9950	10856.00	3588.00	0.00	472	11	11602	82431	0.14074801955575	0.543718452631138	0.543718452631138	true	false	false
cda6fc56-5100-46a0-b624-009dddac3223	2026-09-22 14:34	2026-09-22 14:33	2026-09-22 14:33	PCG	PCG261218C00018000	call	18.0000	2026-12-18	0.2300	0.2200	0.2400	12.9950	20102.00	3703.00	0.00	874	6	9596	82431	0.116412514709272	0.543718452631138	0.543718452631138	true	false	false
fee0b352-21d9-4374-8115-d513f3e95f60	2026-09-22 14:34	2026-09-22 14:33	2026-09-22 14:33	PCG	PCG261218C00018000	call	18.0000	2026-12-18	0.2300	0.1800	0.2400	12.9950	12098.00	11983.00	115.00	526	6	8681	82431	0.105312321820674	0.543718452631138	0.543718452631138	true	false	false
e9ae1a27-756d-4e3b-adf9-c7664bd956b0	2026-09-22 14:25	2026-09-22 14:25	2026-09-22 14:25	PCG	PCG261218P00014000	put	14.0000	2026-12-18	1.7800	1.6900	1.7800	13.0000	19580.00	19580.00	0.00	110	9	111	2717	0.0408538829591461	0.502185958099104	0.499973607773566	true	false	false
21f32ea4-6ad2-4e9c-bb59-c05c987bea80	2026-09-22 11:03	2026-09-22 11:03	2026-09-22 11:03	PCG	PCG261016C00013500	call	13.5000	2026-10-16	0.3100	0.3100	0.3800	13.0250	11005.00	0.00	11005.00	355	37	355	40	8.875	0.368769235215191	0.368769235215191	false	false	false
2921aa53-fde9-49da-aa68-de6c7f872e3d	2026-09-22 10:37	2026-09-22 10:36	2026-09-22 10:36	PCG	PCG261218C00014000	call	14.0000	2026-12-18	0.8900	0.8500	0.8900	13.0477	21449.00	21449.00	0.00	241	8	723	13502	0.0535476225744334	0.480208985484926	0.480208985484926	true	false	false
52b3ac9a-4c4e-4978-89e3-1450cbd90284	2026-09-21 15:22	2026-09-21 15:22	2026-09-21 15:22	PCG	PCG280121C00015000	call	15.0000	2028-01-21	1.8200	1.8200	1.9000	13.0201	18200.00	0.00	18200.00	100	5	1318	5139	0.256470130375559	0.373055456017635	0.373055456017635	false	false	false