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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	expirydate	pricenumeric

97a83ae7-e68b-43e1-808a-4354139849a5	2026-08-27 09:31	2026-08-27 09:31	2026-08-27 09:31	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.9100	0.8900	1.0500	17.9600	18200.00	819.00	7553.00	200	15	1635	75316	0.0217085347071007	0.517349966490585	0.517349966490585	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-08-27T13:38:22.111482Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
47bfbd19-08ff-4ceb-8f62-c718521b359c	2026-08-27 09:31	2026-08-27 09:31	2026-08-27 09:31	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.9200	0.8700	0.9200	17.9800	55574.00	51526.00	0.00	603	6	1435	75316	0.0190530564554676	0.517039452899847	0.517039452899847	false	false	false	true	false
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	false
459af899-d9e1-4bbf-afd3-ef92c7379313	2026-08-27 09:32	2026-08-27 09:32	2026-08-27 09:32	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.8600	0.8600	0.9100	17.8800	51514.00	0.00	51514.00	599	20	2271	75316	0.0301529555472941	0.512484142311831	0.512484142311831	false	false	false	true	false
39b81a03-8ea8-44f5-8603-7406fd997111	2026-08-27 09:32	2026-08-27 09:32	2026-08-27 09:32	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.8400	0.8000	1.0000	17.8600	53340.00	2100.00	6048.00	635	9	3031	75316	0.0402437729034999	0.506873701788077	0.506873701788077	false	false	false	true	false
fb000a6d-d4d2-4434-a589-088beddf7a8e	2026-08-27 09:32	2026-08-27 09:32	2026-08-27 09:32	PCG	PCG260925C00018000	call	18.0000	2026-09-25	0.8700	0.8200	0.9200	17.8000	17400.00	16356.00	0.00	200	6	3970	12413	0.319825988882623	0.468644687650571	0.468644687650571	false	false	false	true	false
6b02bfd1-c2aa-4203-9c07-4f808368de3d	2026-08-27 09:32	2026-08-27 09:32	2026-08-27 09:32	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.8000	0.7700	0.8000	17.7901	57280.00	57280.00	0.00	716	6	3930	75316	0.0521801476445908	0.504009313429217	0.504009313429217	false	false	false	true	false
3f4779d7-26d3-4347-99ba-303d67127dfb	2026-08-27 09:42	2026-08-27 09:42	2026-08-27 09:42	PCG	PCG260918C00019000	call	19.0000	2026-09-18	0.4200	0.4200	0.4300	17.6999	58044.00	0.00	58044.00	1382	33	1463	166683	0.00877713984029565	0.509801902030794	0.509801902030794	false	false	false	true	false
9b1bf660-5800-45b3-b11b-d14cb72c8d68	2026-08-27 10:19	2026-08-27 10:19	2026-08-27 10:19	PCG	PCG260904C00019000	call	19.0000	2026-09-04	0.2900	0.2900	0.4000	17.7150	70180.00	0.00	70180.00	2420	47	2420	4203	0.575779205329527	0.704043925728774	0.704043925728774	false	false	false	true	false
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	false
f3b72e7e-c7ff-4810-8da9-30ffa7b58eb5	2026-08-27 10:51	2026-08-27 10:51	2026-08-27 10:51	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.7200	0.7200	0.7500	17.7250	125784.00	0.00	125784.00	1747	24	10210	75316	0.135562164745871	0.47620687632448	0.47620687632448	false	false	false	true	false
88a6e18e-2e43-44cd-a1e9-87e5908316ba	2026-08-27 11:52	2026-08-27 11:52	2026-08-27 11:52	PCG	PCG261016C00018000	call	18.0000	2026-10-16	0.8600	0.7900	0.8700	17.6450	18920.00	18662.00	0.00	220	30	1745	20996	0.0831110687750048	0.37568861640613	0.37568861640613	true	false	false	true	false
7933de07-daab-4045-bf54-3471db292ae0	2026-08-27 11:52	2026-08-27 11:52	2026-08-27 11:52	PCG	PCG261016C00018000	call	18.0000	2026-10-16	0.8600	0.8600	0.8700	17.6450	10320.00	0.00	10320.00	120	6	1865	20996	0.0888264431320251	0.37568861640613	0.37568861640613	false	false	false	true	false
a5afad2d-1828-4032-8e9f-920c60db61af	2026-08-27 14:02	2026-08-27 14:02	2026-08-27 14:02	PCG	PCG261218C00023000	call	23.0000	2026-12-18	0.2500	0.2000	0.2500	18.0000	18750.00	18750.00	0.00	750	31	904	6322	0.142992723821575	0.362682768434375	0.362682768434375	false	false	false	true	false
71a76d9c-4870-4201-a473-e7aeb2e78a39	2026-08-27 14:15	2026-08-27 14:15	2026-08-27 14:15	PCG	PCG261016P00019000	put	19.0000	2026-10-16	1.5400	1.5400	1.5500	18.0350	10626.00	0.00	10626.00	69	15	69	950	0.0726315789473684	0.385620572114953	0.385620572114953	false	false	false	true	false
7987c259-197b-46c7-86b7-e8cdbff46416	2026-08-27 14:31	2026-08-27 14:31	2026-08-27 14:31	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.4100	0.4000	0.4100	18.0850	18450.00	18450.00	0.00	450	5	246488	63024	3.91101802487941	0.386896712622298	0.386896712622298	false	false	false	true	false
6017bc6c-e050-4d4a-a53d-e459630d706d	2026-08-27 14:32	2026-08-27 14:32	2026-08-27 14:32	PCG	PCG261218C00020000	call	20.0000	2026-12-18	0.7700	0.7400	0.7700	18.0850	12012.00	12012.00	0.00	156	22	334	18220	0.0183315038419319	0.3477112009536	0.3477112009536	false	false	false	true	false
aefe63bf-ac8c-4f9f-b95e-35085667e40c	2026-08-27 14:47	2026-08-27 14:47	2026-08-27 14:47	PCG	PCG261218C00021000	call	21.0000	2026-12-18	0.5400	0.4900	0.5400	18.0250	12690.00	12690.00	0.00	235	31	472	324	1.45679012345679	0.357172470252484	0.357172470252484	false	false	false	true	false
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	false
ff75b0b5-51ef-47b8-862b-7928d4d55d7c	2026-08-27 14:59	2026-08-27 14:59	2026-08-27 14:59	PCG	PCG261016P00018000	put	18.0000	2026-10-16	1.0300	1.0300	1.0700	17.9850	18437.00	0.00	18437.00	179	11	645	3176	0.20308564231738	0.403717664544127	0.403717664544127	false	false	false	true	false
be2b45ca-344b-4714-9c01-3e5967752eea	2026-08-27 14:59	2026-08-27 14:59	2026-08-27 14:59	PCG	PCG261016P00018000	put	18.0000	2026-10-16	1.0300	1.0300	1.0700	17.9850	14420.00	0.00	14420.00	140	7	1985	3176	0.625	0.403717664544127	0.403717664544127	false	false	false	true	false
578df4ec-54e4-4476-9105-b3607e440dd2	2026-08-27 14:59	2026-08-27 14:59	2026-08-27 14:59	PCG	PCG261016P00018000	put	18.0000	2026-10-16	1.0300	1.0300	1.0700	17.9850	10300.00	0.00	10300.00	100	5	2085	3176	0.656486146095718	0.403717664544127	0.403717664544127	false	false	false	true	false
2b3bc876-c80a-4522-a52e-2243e21494d8	2026-08-27 14:59	2026-08-27 14:59	2026-08-27 14:59	PCG	PCG261016P00018000	put	18.0000	2026-10-16	1.0300	1.0300	1.0700	17.9850	20600.00	0.00	20600.00	200	10	1845	3176	0.580919395465995	0.403717664544127	0.403717664544127	false	false	false	true	false
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	false
fc177dc7-fef9-4124-8a20-022c248f8ca3	2026-08-27 15:06	2026-08-27 15:06	2026-08-27 15:06	PCG	PCG260918C00017500	call	17.5000	2026-09-18	1.1600	1.1600	1.1900	17.9500	18560.00	0.00	18560.00	160	8	322	50	6.44	0.515740549815726	0.515740549815726	false	false	false	true	false
040826e8-9ea3-46ef-8910-afda4144a122	2026-08-27 15:06	2026-08-27 15:06	2026-08-27 15:06	PCG	PCG260918C00017500	call	17.5000	2026-09-18	1.1600	1.1600	1.1900	17.9500	16240.00	0.00	16240.00	140	7	482	50	9.64	0.515740549815726	0.515740549815726	false	false	false	true	false
f4d45d5f-03e5-465c-8ccf-8c5a51ab9d1f	2026-08-27 15:07	2026-08-27 15:06	2026-08-27 15:06	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.9100	0.8300	0.9300	17.9650	16471.00	13286.00	1911.00	181	21	11829	75316	0.157058261192841	0.517349966490585	0.515852108365077	true	false	false	true	false
54d242a4-e5b9-4f33-abcc-83dfd48212dc	2026-08-27 15:07	2026-08-27 15:07	2026-08-27 15:07	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.9200	0.8300	0.9400	17.9650	27140.00	12512.00	14628.00	295	10	12145	75316	0.161253916830421	0.521547904883392	0.521547904883392	false	false	false	true	false
20c46c63-73dd-4e9c-b9ea-f17d84d3c450	2026-08-27 15:07	2026-08-27 15:07	2026-08-27 15:07	PCG	PCG260904C00018500	call	18.5000	2026-09-04	0.4700	0.3800	0.5200	17.9650	25897.00	799.00	25098.00	551	21	9322	918	10.1546840958606	0.649962935331898	0.649962935331898	false	false	false	true	false
20ceb59d-bba0-4887-ad9c-8296123bc265	2026-08-27 15:32	2026-08-27 15:32	2026-08-27 15:32	PCG	PCG261218C00020000	call	20.0000	2026-12-18	0.7400	0.6800	0.7400	17.0000	110334.00	110334.00	0.00	1491	22	2240	18220	0.122941822173436	0.356221256274674	0.356221256274674	false	false	false	true	false
86546322-a8ff-439b-9eab-f6a34bbe688e	2026-08-27 15:45	2026-08-27 15:44	2026-08-27 15:44	PCG	PCG261002C00018500	call	18.5000	2026-10-02	0.7100	0.7100	0.7400	17.9350	12425.00	0.00	12425.00	175	15	376	12	31.3333333333333	0.411658487819375	0.411658487819375	false	false	false	true	false
2a8bd97d-e540-4a09-8961-d3329fc7aec6	2026-08-27 15:57	2026-08-27 15:57	2026-08-27 15:57	PCG	PCG261218C00021000	call	21.0000	2026-12-18	0.5400	0.4400	0.5500	17.9250	341736.00	335742.00	5994.00	6315	74	6788	324	20.9506172839506	0.369189015060103	0.365333537098469	true	false	false	true	false
2d608ea2-f4a2-4909-8f8e-f89ef21cca19	2026-08-27 15:58	2026-08-27 15:57	2026-08-27 15:58	PCG	PCG261218C00021000	call	21.0000	2026-12-18	0.5600	0.0000	0.0000	17.9300	1292404.00	1292404.00	0.00	23183	37	26789	324	82.6820987654321	0	0	true	true	false	true	false
cee58663-b850-4447-98c9-acacd95711da	2026-08-28 09:37	2026-08-28 09:37	2026-08-28 09:37	PCG	PCG260828C00018500	call	18.5000	2026-08-28	0.2000	0.1700	0.2100	18.2450	51140.00	640.00	50500.00	2557	15	2709	1352	2.00369822485207	1.5716894869055	1.5716894869055	false	false	false	true	false
adb2c2b6-a9f4-48b4-b64b-ca4f804307db	2026-08-28 10:07	2026-08-28 10:06	2026-08-28 10:06	PCG	PCG260904P00017500	put	17.5000	2026-09-04	0.3600	0.2600	0.3800	18.2400	17980.00	17980.00	0.00	500	6	559	10660	0.0524390243902439	0.679443552943433	0.679443552943433	false	false	false	true	false
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	false
35037c96-23d7-4f7b-ad6c-6090ac4eb322	2026-08-28 10:07	2026-08-28 10:07	2026-08-28 10:07	PCG	PCG260904P00017500	put	17.5000	2026-09-04	0.3800	0.2600	0.4600	18.1900	12881.00	12691.00	190.00	339	11	3398	10660	0.318761726078799	0.684127848269702	0.684127848269702	false	false	false	true	false
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	false
c538728a-e955-4779-b3eb-c1a09e3b3850	2026-08-28 12:11	2026-08-28 12:11	2026-08-28 12:11	PCG	PCG260904P00017000	put	17.0000	2026-09-04	0.2500	0.2200	0.2600	18.0950	11250.00	11250.00	0.00	450	5	2910	1293	2.25058004640371	0.682969593192327	0.682969593192327	false	false	false	true	false
568622fa-8e49-430d-9e81-ad35bea7a8dd	2026-08-28 12:44	2026-08-28 12:44	2026-08-28 12:44	PCG	PCG261016C00018000	call	18.0000	2026-10-16	0.9100	0.8500	0.9100	17.6450	12012.00	12012.00	0.00	132	7	738	22668	0.0325569084171519	0.399170090711393	0.399170090711393	true	false	false	true	false
5becdfb9-e7e3-4e43-a287-c7929d1e5c0b	2026-08-28 12:59	2026-08-28 12:59	2026-08-28 12:59	PCG	PCG260918P00016000	put	16.0000	2026-09-18	0.6000	0.4600	0.7000	16.2950	13680.00	9720.00	3960.00	228	7	5864	26643	0.220095334609466	0.48310424243217	0.488500254589411	false	false	false	true	false
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	false
2fb2541b-7a39-4982-8e0b-f4890b74f9a4	2026-08-28 13:01	2026-08-28 13:01	2026-08-28 13:01	PCG	PCG261016P00015000	put	15.0000	2026-10-16	0.4000	0.2200	0.6700	16.4450	10040.00	0.00	10040.00	251	5	769	651	1.18125960061444	0.426834595977303	0.427478627265864	false	false	false	true	false
53c25914-92f1-413d-bc62-08a37e796e76	2026-08-28 13:05	2026-08-28 13:05	2026-08-28 13:05	PCG	PCG260828C00017000	call	17.0000	2026-08-28	0.1800	0.0600	0.1800	16.4994	23202.00	23202.00	0.00	1289	32	2624	1815	1.44573002754821	3.10715971482827	3.10715971482827	true	false	false	true	false
50313311-ca48-4859-978c-60bff5b7c748	2026-08-28 13:06	2026-08-28 13:05	2026-08-28 13:05	PCG	PCG260904C00018000	call	18.0000	2026-09-04	0.2100	0.0500	0.2200	16.4100	19929.00	19929.00	0.00	949	11	1642	2403	0.683312526009155	0.78885183576815	0.78885183576815	true	false	false	true	false
a8d95401-c63a-496a-985e-5a67d190b082	2026-08-28 13:06	2026-08-28 13:06	2026-08-28 13:06	PCG	PCG261016C00017000	call	17.0000	2026-10-16	0.7700	0.7700	0.7900	16.3400	10549.00	0.00	7392.00	137	18	263	3725	0.0706040268456376	0.424849268772468	0.424849268772468	false	false	false	true	false
aa3fa435-d66c-4c05-bdd2-0426f3ff8e92	2026-08-28 13:06	2026-08-28 13:06	2026-08-28 13:06	PCG	PCG261016C00017000	call	17.0000	2026-10-16	0.7700	0.7700	0.9700	16.3750	11550.00	0.00	11550.00	150	16	515	3725	0.138255033557047	0.41827641415407	0.41827641415407	true	false	false	true	false
16286407-6a3a-4df0-9425-9fe41e9890bb	2026-08-28 13:07	2026-08-28 13:06	2026-08-28 13:06	PCG	PCG261016C00017000	call	17.0000	2026-10-16	0.8500	0.8500	0.8500	16.4210	19380.00	0.00	0.00	228	16	1677	3725	0.450201342281879	0.443124398926865	0.443124398926865	false	false	false	true	false
15cec997-23f1-4ab6-8591-308d58dc8b93	2026-08-28 13:07	2026-08-28 13:06	2026-08-28 13:06	PCG	PCG261016C00017000	call	17.0000	2026-10-16	0.8500	0.8500	0.8600	16.4000	41735.00	0.00	8245.00	491	67	1449	3725	0.388993288590604	0.447162525126505	0.447162525126505	true	false	false	true	false
3b3551f4-d0e7-404b-a6d2-eb9c1dd35591	2026-08-28 13:07	2026-08-28 13:07	2026-08-28 13:07	PCG	PCG260828C00016500	call	16.5000	2026-08-28	0.3800	0.3400	0.5000	16.4500	56202.00	0.00	56202.00	1479	13	1756	166	10.578313253012	3.39433339803051	3.39433339803051	false	false	false	true	false