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: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	expirydate	price

10336c88-d35c-4fcc-9300-11403d634d60	2026-09-03 12:54	2026-09-03 12:54	2026-09-03 12:54	PCG	PCG270319C00019000	call	19.0000	2027-03-19	0.7500	0.7500	0.7600	13.9650	17846.00	5396.00	12450.00	237	16	282	51	5.52941176470588	0.507774475003793	0.507774475003793	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Utilities	36449502746.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
30dc15af-36ec-432d-8a62-8f3d501aa5f8	2026-09-03 12:52	2026-09-03 12:52	2026-09-03 12:52	PCG	PCG270115C00020000	call	20.0000	2027-01-15	0.4800	0.4400	0.4800	13.9700	43440.00	43440.00	0.00	905	34	3227	10901	0.296027887349784	0.572011061503063	0.571583994538108	true	false	false	true	false
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	false
1b7b8207-01b7-4bbe-9ac8-20f7d9b8a37c	2026-09-03 12:51	2026-09-03 12:51	2026-09-03 12:51	PCG	PCG261016P00013000	put	13.0000	2026-10-16	0.6500	0.5400	0.6700	13.9600	135786.00	135786.00	0.00	2089	20	2236	12395	0.180395320693828	0.5909700695638	0.601743025436144	true	false	false	true	false
66e6bc30-7c43-4589-9f98-e6a4cbc5083a	2026-09-03 12:49	2026-09-03 12:49	2026-09-03 12:49	PCG	PCG261218C00017000	call	17.0000	2026-12-18	0.7600	0.7100	0.7700	13.9700	20672.00	4408.00	16264.00	272	13	2748	27976	0.0982270517586503	0.559277627280428	0.559874464507063	true	false	false	true	false
ebc140f6-f74f-4b90-9d44-fab739fa08bb	2026-09-03 12:49	2026-09-03 12:49	2026-09-03 12:49	PCG	PCG261218C00017000	call	17.0000	2026-12-18	0.7600	0.6900	0.7700	13.9673	29412.00	21812.00	7600.00	387	9	2287	27976	0.0817486416928796	0.56019678507371	0.56019678507371	true	false	false	true	false
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	false
e0be61bf-246d-4ace-b619-ee9f0171697d	2026-09-03 12:36	2026-09-03 12:36	2026-09-03 12:36	PCG	PCG270115C00016000	call	16.0000	2027-01-15	1.0600	0.8600	1.0700	13.8650	17066.00	15900.00	0.00	161	5	1786	4129	0.432550254298862	0.521709321743317	0.521709321743317	false	false	false	true	false
2cbb2d2a-ff3f-42bf-818b-1a132b559d7d	2026-09-03 12:22	2026-09-03 12:22	2026-09-03 12:22	PCG	PCG270115C00016000	call	16.0000	2027-01-15	1.0600	0.9900	1.1800	13.8762	15158.00	0.00	15158.00	143	13	1493	4129	0.361588762412206	0.520324324983243	0.520324324983243	false	false	false	true	false
ac22e25e-1055-43f2-8828-9e104cd3742b	2026-09-03 12:12	2026-09-03 12:12	2026-09-03 12:12	PCG	PCG270115C00020000	call	20.0000	2027-01-15	0.4600	0.4100	0.4600	13.9050	24012.00	24012.00	0.00	522	13	2101	10901	0.192734611503532	0.56873922314742	0.56873922314742	true	false	false	true	false
7fea16aa-e7bc-4b51-aa1f-f7cbdcd83728	2026-09-03 12:00	2026-09-03 12:00	2026-09-03 12:00	PCG	PCG261120C00015000	call	15.0000	2026-11-20	0.8700	0.8400	0.8700	13.7400	16965.00	16965.00	0.00	195	6	873	0	0	0.518038721225861	0.518038721225861	false	false	false	true	false
edf50047-987d-434f-b85e-866bbfb12429	2026-09-03 11:56	2026-09-03 11:56	2026-09-03 11:56	PCG	PCG270115C00019000	call	19.0000	2027-01-15	0.5100	0.4200	0.5100	13.7750	76550.00	76500.00	50.00	1501	35	3302	1798	1.83648498331479	0.549342649715642	0.544883122182788	true	false	false	true	false
db3be329-39c9-4fbf-95fa-659fce675f7a	2026-09-03 11:56	2026-09-03 11:56	2026-09-03 11:56	PCG	PCG270115C00020000	call	20.0000	2027-01-15	0.4100	0.3900	0.4100	13.7650	43091.00	43091.00	0.00	1051	34	1230	10901	0.112833684983029	0.558778695269986	0.558778695269986	true	false	false	true	false
35e4455a-421a-4bbc-9ea2-0b346c5f5cb7	2026-09-03 11:54	2026-09-03 11:54	2026-09-03 11:54	PCG	PCG270115C00019000	call	19.0000	2027-01-15	0.4800	0.3300	0.5300	13.7550	37534.00	37534.00	0.00	782	46	1785	1798	0.992769744160178	0.538559376377559	0.530339106774843	true	false	false	true	false
f4510aa7-eae7-4d25-ba09-5013a9d164de	2026-09-03 11:54	2026-09-03 11:53	2026-09-03 11:53	PCG	PCG270917P00015000	put	15.0000	2027-09-17	2.8200	2.8200	2.8900	13.7300	19176.00	0.00	19176.00	68	14	199	76	2.61842105263158	0.443469830826497	0.443469830826497	false	false	false	true	false
d4da6948-bfcc-45ea-9e4e-784ab62bf648	2026-09-03 11:51	2026-09-03 11:51	2026-09-03 11:51	PCG	PCG270917P00015000	put	15.0000	2027-09-17	2.8500	2.8300	2.9600	13.7350	13110.00	1995.00	9975.00	46	11	103	76	1.35526315789474	0.449295692606963	0.449295692606963	false	false	false	true	false
a3f42c79-f851-4712-afae-330fc52c4a79	2026-09-03 11:31	2026-09-03 11:31	2026-09-03 11:31	PCG	PCG261016C00014000	call	14.0000	2026-10-16	0.9800	0.8900	0.9900	13.7400	39792.00	39694.00	98.00	406	10	2756	12840	0.214641744548287	0.573638836919575	0.573638836919575	true	false	false	true	false
8d1c4c9b-3f1e-4afa-9ca4-9d85d84799e6	2026-09-03 11:11	2026-09-03 11:11	2026-09-03 11:11	PCG	PCG261218C00015000	call	15.0000	2026-12-18	1.0900	1.0400	1.0900	13.6550	87745.00	87745.00	0.00	805	16	1120	28861	0.0388066941547417	0.527315762602226	0.527315762602226	false	false	false	true	false
4641795f-53c6-4e58-bf96-39cab81618a9	2026-09-03 11:02	2026-09-03 11:02	2026-09-03 11:02	PCG	PCG261016C00014000	call	14.0000	2026-10-16	0.9400	0.8700	1.0100	13.7000	92120.00	87608.00	4418.00	980	13	2321	12840	0.180763239875389	0.556468539116391	0.557808713553502	true	false	false	true	false
bb07dbc3-e2cf-4f36-8e63-a6cffb6458a2	2026-09-03 11:01	2026-09-03 11:01	2026-09-03 11:01	PCG	PCG270115C00016000	call	16.0000	2027-01-15	0.9300	0.8900	0.9300	13.6700	12462.00	12462.00	0.00	134	5	1225	4129	0.296682005328167	0.504812902688059	0.504812902688059	true	false	false	true	false
286b77a4-e51f-472e-923d-2c860f053f24	2026-09-03 10:58	2026-09-03 10:58	2026-09-03 10:58	PCG	PCG270115C00016000	call	16.0000	2027-01-15	0.9200	0.8900	0.9300	13.6250	39560.00	39560.00	0.00	430	9	1090	4129	0.263986437394042	0.507010253486842	0.507010253486842	true	false	false	true	false
5f77885d-62d3-44da-b018-94b25bd22789	2026-09-03 10:58	2026-09-03 10:58	2026-09-03 10:58	PCG	PCG261016C00014000	call	14.0000	2026-10-16	0.9000	0.9000	0.9700	13.6400	51750.00	0.00	51750.00	575	11	1336	12840	0.10404984423676	0.552390607471643	0.552390607471643	true	false	false	true	false
3b9eda0c-6d8d-44ff-8e3e-16867fba58fa	2026-09-03 10:47	2026-09-03 10:47	2026-09-03 10:47	PCG	PCG270115C00016000	call	16.0000	2027-01-15	0.9200	0.9000	0.9300	13.5990	29681.00	25392.00	4289.00	323	8	332	4129	0.0804068781787358	0.510118794731427	0.510118794731427	true	false	false	true	false
cb03f171-b0bd-49b1-912f-a756e61b5b9c	2026-09-03 10:32	2026-09-03 10:32	2026-09-03 10:32	PCG	PCG261218C00019000	call	19.0000	2026-12-18	0.4000	0.3400	0.4000	13.5550	37280.00	37280.00	0.00	932	23	2137	25640	0.0833463338533541	0.590302590797493	0.590302590797493	true	false	false	true	false
1fd33115-2b0e-485f-9868-1546fb806294	2026-09-03 10:32	2026-09-03 10:32	2026-09-03 10:32	PCG	PCG270115C00019000	call	19.0000	2027-01-15	0.4800	0.3300	0.4800	13.5523	31296.00	31296.00	0.00	652	20	1003	1798	0.557842046718576	0.556623780492972	0.556623780492972	true	false	false	true	false
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	false
2ee4f374-bd9b-4f54-8f6c-c51de706bfc6	2026-09-03 10:09	2026-09-03 10:09	2026-09-03 10:09	PCG	PCG260904P00014000	put	14.0000	2026-09-04	0.4200	0.4200	0.5400	13.7400	19866.00	0.00	19866.00	473	38	1363	21294	0.0640086409317179	0.937121642889684	0.937121642889684	true	false	false	true	false
a89e1b3f-2f50-41cf-bb2e-e34005ab40ad	2026-09-03 10:02	2026-09-03 10:02	2026-09-03 10:02	PCG	PCG260904P00014000	put	14.0000	2026-09-04	0.5000	0.5000	1.2700	13.6250	40650.00	0.00	40650.00	813	30	813	21294	0.0381797689489997	0.948908965370753	0.948908965370753	true	false	false	true	false
e1bb6c13-968d-49f6-95f3-787821039d68	2026-09-03 10:00	2026-09-03 10:00	2026-09-03 10:00	PCG	PCG270115C00017000	call	17.0000	2027-01-15	0.7100	0.6500	0.7100	13.6100	12070.00	12070.00	0.00	170	12	588	58356	0.0100760847213654	0.515559261245772	0.515559261245772	true	false	false	true	false
55c94290-b9e3-4d8d-8c9e-4c434646fad8	2026-09-03 09:59	2026-09-03 09:59	2026-09-03 09:59	PCG	PCG270115C00017000	call	17.0000	2027-01-15	0.7100	0.6700	0.7200	13.6150	12141.00	11289.00	71.00	171	9	310	58356	0.00531222153677428	0.515030916027313	0.515030916027313	true	false	false	true	false
cadc718f-1563-40ab-a636-05b59818dc19	2026-09-02 15:58	2026-09-02 15:58	2026-09-02 15:58	PCG	PCG270319C00014000	call	14.0000	2027-03-19	1.7700	1.5100	1.7700	13.3700	10620.00	10620.00	0.00	60	8	285	605	0.471074380165289	0.486627354021871	0.486627354021871	false	false	false	true	false
187c1c8b-3a19-4af5-8242-cb7967386933	2026-09-02 15:58	2026-09-02 15:57	2026-09-02 15:57	PCG	PCG270115P00015000	put	15.0000	2027-01-15	2.5700	2.5600	2.5700	13.3700	12850.00	12850.00	0.00	50	9	88	7809	0.0112690485337431	0.522965932490214	0.522965932490214	false	false	false	true	false
08e40bd5-8d5e-44c3-b5d0-181cc270bc6e	2026-09-02 15:57	2026-09-02 15:57	2026-09-02 15:57	PCG	PCG270115C00015000	call	15.0000	2027-01-15	1.1000	1.0000	1.1000	13.3750	110108.00	110108.00	0.00	1001	45	10362	17879	0.579562615358801	0.503452826873955	0.500323911504073	false	false	false	true	false
f9a18b68-447c-489b-aedf-c0439a419e5b	2026-09-02 15:47	2026-09-02 15:47	2026-09-02 15:47	PCG	PCG270115C00017000	call	17.0000	2027-01-15	0.6100	0.5000	0.6100	13.2900	61360.00	61360.00	0.00	1006	47	58038	20639	2.81205484761859	0.511143980098648	0.511143980098648	true	false	false	true	false
75a90582-5cdc-4f68-8b85-0cfed47079a1	2026-09-02 15:45	2026-09-02 15:44	2026-09-02 15:44	PCG	PCG270115C00016000	call	16.0000	2027-01-15	0.7600	0.6700	0.7600	13.2900	75994.00	75994.00	0.00	1000	16	1021	4063	0.251292148658627	0.49154230539696	0.49154230539696	true	false	false	true	false
12bad398-11ff-449c-8fde-cd64bc53d63c	2026-09-02 15:44	2026-09-02 15:44	2026-09-02 15:44	PCG	PCG261016C00015000	call	15.0000	2026-10-16	0.5700	0.5400	0.5800	13.3050	19035.00	171.00	18864.00	334	16	21062	7010	3.00456490727532	0.6223453198687	0.604454540452853	true	false	false	true	false
a178b473-f811-47c6-9ed8-0ec37e955d96	2026-09-02 15:43	2026-09-02 15:43	2026-09-02 15:43	PCG	PCG270115C00020000	call	20.0000	2027-01-15	0.2800	0.2000	0.2900	13.2850	27692.00	27608.00	0.00	989	23	2261	10174	0.222233143306467	0.531937737191325	0.531937737191325	true	false	false	true	false
51781259-c3a2-4af0-8eb6-8a7fbf38c220	2026-09-02 15:41	2026-09-02 15:41	2026-09-02 15:41	PCG	PCG270115C00015000	call	15.0000	2027-01-15	0.9900	0.9100	0.9900	13.2950	98109.00	98109.00	0.00	991	12	9359	17879	0.523463280944124	0.479453756768145	0.479453756768145	true	false	false	true	false
29c11b86-9198-4910-849c-111aecc93b93	2026-09-02 15:35	2026-09-02 15:35	2026-09-02 15:35	PCG	PCG270115C00014000	call	14.0000	2027-01-15	1.2500	1.2100	1.4500	13.2100	32375.00	500.00	31875.00	259	5	899	2165	0.415242494226328	0.466972333598852	0.466972333598852	false	false	false	true	false
0247c217-687b-426d-a226-5d1d87e99f79	2026-09-02 15:31	2026-09-02 15:31	2026-09-02 15:31	PCG	PCG280121C00013000	call	13.0000	2028-01-21	2.7100	2.7100	2.8200	13.2210	55013.00	0.00	55013.00	203	12	3434	1441	2.38306731436502	0.367730307503882	0.367730307503882	false	false	false	true	false
25f0723f-aacc-448c-9ee9-32b8b1925752	2026-09-02 15:19	2026-09-02 15:19	2026-09-02 15:19	PCG	PCG261016C00013000	call	13.0000	2026-10-16	1.1000	0.9100	1.1600	13.2550	25080.00	23430.00	1650.00	228	9	1579	1196	1.32023411371237	0.510399443064599	0.515343787749958	true	false	false	true	false
e892736d-cb1d-4ab5-bddc-b46feea06f59	2026-09-02 14:58	2026-09-02 14:58	2026-09-02 14:58	PCG	PCG280121C00013000	call	13.0000	2028-01-21	2.7900	2.7900	2.8800	13.3350	50220.00	0.00	50220.00	180	23	3228	1441	2.24011103400416	0.368606635510687	0.368606635510687	false	false	false	true	false
59ab4e0f-55ea-49a6-8e84-74d83f9f8184	2026-09-02 14:55	2026-09-02 14:55	2026-09-02 14:55	PCG	PCG260904C00014000	call	14.0000	2026-09-04	0.1400	0.1400	0.1800	13.3550	16324.00	0.00	16324.00	1166	5	11299	14315	0.789311910583304	0.934486873638047	0.934486873638047	false	false	false	true	false
844a67e1-ce5c-41f9-bbd8-20e5c108a96c	2026-09-02 14:09	2026-09-02 14:08	2026-09-02 14:08	PCG	PCG270115C00017000	call	17.0000	2027-01-15	0.5600	0.5100	0.5700	13.3650	17518.00	3864.00	13654.00	313	19	55668	20639	2.69722370269877	0.484993577127607	0.481252604902998	true	false	false	true	false
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	false
7c27c67c-24c1-4a4a-b998-2318d3af01fc	2026-09-02 13:51	2026-09-02 13:50	2026-09-02 13:50	PCG	PCG270917C00015000	call	15.0000	2027-09-17	1.7000	1.7000	2.0300	13.3699	45054.00	0.00	45054.00	265	9	1147	622	1.84405144694534	0.383214117354367	0.385051905131528	false	false	false	true	false
07a230c5-332e-4187-9468-7f3cb87c93c0	2026-09-02 13:46	2026-09-02 13:46	2026-09-02 13:46	PCG	PCG270319C00017000	call	17.0000	2027-03-19	0.6800	0.6700	0.6800	13.3050	10880.00	10880.00	0.00	160	22	490	4359	0.112411103464097	0.434259535316708	0.434259535316708	false	false	false	true	false
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	false
4c706104-5b44-449b-b542-4d9c9c5ca224	2026-09-02 12:32	2026-09-02 12:32	2026-09-02 12:32	PCG	PCG260918C00014500	call	14.5000	2026-09-18	0.2100	0.2000	0.3400	13.0700	52521.00	3885.00	48426.00	2501	19	9107	1006	9.05268389662028	0.608792694253618	0.608792694253618	true	false	false	true	false
1e293806-a6a9-4c8a-b6d1-1c6a5b440bd2	2026-09-02 11:31	2026-09-02 11:31	2026-09-02 11:31	PCG	PCG261218C00017000	call	17.0000	2026-12-18	0.3700	0.3600	0.3700	12.9250	106005.00	106005.00	0.00	2865	8	9380	22416	0.418451106352605	0.509926420403629	0.509926420403629	false	false	false	true	false