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

167df493-87fa-4aa5-b194-2776adf49c68	2026-08-21 14:28	2026-08-21 14:28	2026-08-21 14:28	PCG	PCG280121C00015000	call	15.0000	2028-01-21	4.5500	4.4000	4.5500	17.6350	58671.00	58671.00	0.00	129	13	130	898	0.144766146993318	0.321833493842069	0.321833493842069	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Utilities	36449502746.00	2026-10-22	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
171219cc-b602-4624-98e2-fd2d76b191b6	2026-08-24 10:10	2026-08-24 10:10	2026-08-24 10:10	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.6600	0.6600	0.6900	18.0250	33990.00	0.00	33990.00	515	16	757	58949	0.0128416088483265	0.486597048924569	0.486597048924569	false	false	false	true	false
ce0b75b5-359d-47c2-8f57-5442e0f89dad	2026-08-24 10:11	2026-08-24 10:10	2026-08-24 10:10	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.6500	0.6400	0.6900	18.0300	97500.00	35230.00	62270.00	1500	76	2257	58949	0.0382873331184583	0.481251415847287	0.481913351749086	false	false	false	true	false
2eb2b698-a586-49e2-a3d5-9cabba40a728	2026-08-24 10:12	2026-08-24 10:12	2026-08-24 10:12	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.6600	0.6400	0.6900	18.0750	10560.00	0.00	10560.00	160	5	2520	58949	0.0427488167738214	0.479951533585605	0.479951533585605	false	false	false	true	false
82a7e7b1-4200-4c27-8a51-67ccfdadfbd9	2026-08-24 10:14	2026-08-24 10:14	2026-08-24 10:14	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.6600	0.6600	0.6800	18.0650	13200.00	0.00	13200.00	200	12	2921	58949	0.0495513070620367	0.481281457365196	0.481281457365196	false	false	false	true	false
c1413570-9910-441b-86c7-3ab826fdec9b	2026-08-24 10:31	2026-08-24 10:31	2026-08-24 10:31	PCG	PCG261016P00019000	put	19.0000	2026-10-16	1.8400	1.8100	1.8400	17.9950	21344.00	21344.00	0.00	116	5	116	221	0.524886877828054	0.479347179231181	0.479347179231181	false	false	false	true	false
8fb15b55-7a3c-4eaa-81d0-20658863baa5	2026-08-24 10:40	2026-08-24 10:40	2026-08-24 10:40	PCG	PCG260918C00020000	call	20.0000	2026-09-18	0.4800	0.4800	0.5000	17.9650	40032.00	0.00	40032.00	834	38	1144	315921	0.0036211584541705	0.619915389718335	0.619915389718335	false	false	false	true	false
8b3fe798-932a-441a-8ce1-093ae2541542	2026-08-24 10:56	2026-08-24 10:56	2026-08-24 10:56	PCG	PCG261016P00018000	put	18.0000	2026-10-16	1.1800	1.1700	1.2200	17.9900	20651.00	13924.00	6727.00	175	9	476	1792	0.265625	0.44921947836986	0.44921947836986	false	false	false	true	false
d06ad191-aff5-45b0-a3fb-57fa3b86b2fa	2026-08-24 11:05	2026-08-24 11:05	2026-08-24 11:05	PCG	PCG261016P00018000	put	18.0000	2026-10-16	1.1900	1.1800	1.2200	17.9400	18326.00	9163.00	9163.00	154	18	655	1792	0.365513392857143	0.444473828896412	0.444473828896412	false	false	false	true	false
cce0d374-4250-413a-b98b-8cbf295fdc31	2026-08-24 11:13	2026-08-24 11:13	2026-08-24 11:13	PCG	PCG260918C00019000	call	19.0000	2026-09-18	0.7000	0.6900	0.7500	17.9100	56000.00	0.00	56000.00	800	6	1171	163701	0.0071532855633136	0.596270677081366	0.596270677081366	false	false	false	true	false
077dc8c5-5074-4f9b-8181-7b6faeb6c22b	2026-08-24 11:58	2026-08-24 11:58	2026-08-24 11:58	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.5500	0.5500	0.5900	17.9350	10285.00	0.00	10285.00	187	11	3368	58949	0.057134132894536	0.453252005526052	0.453252005526052	false	false	false	true	false
06f21d64-8ea0-4431-83f4-ccd20854e24a	2026-08-24 12:33	2026-08-24 12:33	2026-08-24 12:33	PCG	PCG261016P00018000	put	18.0000	2026-10-16	1.1600	1.1600	1.1700	17.9950	10324.00	0.00	10324.00	89	12	752	1792	0.419642857142857	0.442694801738762	0.442694801738762	false	false	false	true	false
13ffa769-09f7-49ab-9418-94d5341c2394	2026-08-24 12:49	2026-08-24 12:49	2026-08-24 12:49	PCG	PCG261016P00018000	put	18.0000	2026-10-16	1.1300	1.1200	1.1600	18.0500	28702.00	15029.00	13673.00	254	13	1024	1792	0.571428571428571	0.438303092271563	0.440774049099045	false	false	false	true	false
3a25e06a-148f-4ff7-9e5c-d1b041859fae	2026-08-24 13:23	2026-08-24 13:23	2026-08-24 13:23	PCG	PCG260904C00019000	call	19.0000	2026-09-04	0.5300	0.5300	0.6000	18.0550	150679.00	0.00	150679.00	2843	31	2893	306	9.45424836601307	0.71706062635973	0.71706062635973	false	false	false	true	false
6af4ad57-bd0a-41b1-abcc-70ca18f7a34b	2026-08-24 13:39	2026-08-24 13:39	2026-08-24 13:39	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.5200	0.5100	0.5500	17.9700	104988.00	66352.00	38636.00	2019	36	5833	58949	0.0989499397784526	0.435612336953129	0.436241155267763	false	false	false	true	false
b58accb3-8e52-4c95-946b-213312f73cfc	2026-08-24 13:41	2026-08-24 13:40	2026-08-24 13:40	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.5200	0.5100	0.5500	17.9700	51012.00	6188.00	44824.00	981	28	7362	58949	0.124887614717807	0.436241155267763	0.436241155267763	true	false	false	true	false
52c59c32-fcf4-4213-a67f-054b479c184e	2026-08-24 13:41	2026-08-24 13:41	2026-08-24 13:41	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.5200	0.5100	0.5500	17.9684	50440.00	0.00	50440.00	970	16	8361	58949	0.141834467081715	0.436442357329079	0.436442357329079	false	false	false	true	false
d5d67319-88ca-47ba-8693-2d9e7ee0b8c2	2026-08-24 13:45	2026-08-24 13:45	2026-08-24 13:45	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.5200	0.5200	0.5400	17.9500	26000.00	0.00	26000.00	500	19	8863	58949	0.150350302804119	0.438755500891313	0.438755500891313	false	false	false	true	false
d2760ad4-ea5e-4f46-b28c-e76c63632c8a	2026-08-24 13:47	2026-08-24 13:46	2026-08-24 13:46	PCG	PCG261016C00020000	call	20.0000	2026-10-16	0.5300	0.5200	0.5700	17.9750	26500.00	0.00	26500.00	500	5	9365	58949	0.158866138526523	0.439809436862668	0.439809436862668	false	false	false	true	false
2af5f8bf-784b-4ea7-9cc5-82a125044c27	2026-08-24 15:09	2026-08-24 15:09	2026-08-24 15:09	PCG	PCG270917C00017000	call	17.0000	2027-09-17	3.3500	3.1500	3.3500	18.0850	24790.00	24790.00	0.00	74	6	124	24	5.16666666666667	0.32962784552384	0.32962784552384	false	false	false	true	false
a9c5efe0-f1c6-4ef6-bbb5-afc6668cb093	2026-08-24 15:18	2026-08-24 15:18	2026-08-24 15:18	PCG	PCG261016C00021000	call	21.0000	2026-10-16	0.3800	0.3600	0.3800	18.0900	34123.00	34086.00	0.00	898	17	950	8904	0.106693620844564	0.452942753956464	0.452942753956464	true	false	false	true	false
47d47020-91e9-4940-b8d6-4a4e4ea3db7e	2026-08-24 15:40	2026-08-24 15:40	2026-08-24 15:40	PCG	PCG260918C00022000	call	22.0000	2026-09-18	0.1500	0.1300	0.1900	18.1150	24970.00	0.00	24970.00	1620	19	1663	99140	0.0167742586241678	0.591872656731262	0.581366260034909	true	false	false	true	false
e9c829ea-a77b-433d-a882-8bc96af2cff2	2026-08-25 09:36	2026-08-25 09:36	2026-08-25 09:36	PCG	PCG260904P00018000	put	18.0000	2026-09-04	0.7500	0.7000	0.9300	18.1400	113250.00	225.00	113025.00	1510	29	1516	840	1.8047619047619	0.693756036023189	0.693756036023189	true	false	false	true	false
b3c8a5b2-56b3-4625-9a92-53d5fc2c5096	2026-08-25 10:47	2026-08-25 10:47	2026-08-25 10:47	PCG	PCG260918C00018000	call	18.0000	2026-09-18	1.1200	1.1200	1.1500	18.1650	14448.00	0.00	14448.00	129	22	427	64910	0.00657833923894623	0.548022355216951	0.548022355216951	false	false	false	true	false
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	false
9abd6da7-54d4-46d1-85bf-eb067be66021	2026-08-25 10:50	2026-08-25 10:50	2026-08-25 10:50	PCG	PCG260828C00019000	call	19.0000	2026-08-28	0.3700	0.3000	0.3900	18.1610	78524.00	72703.00	1147.00	2118	15	2553	3865	0.660543337645537	1.07410614404417	1.05750675851263	true	false	false	true	false
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	false
2dc02cb8-b057-4123-b412-1f0008054e94	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.4500	0.6300	18.1750	10679.00	6253.00	2380.00	173	26	184	3222	0.0571073867163253	0.799958345285538	0.77404948824745	true	false	false	true	false
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	false
9c90bfca-e7e2-47f3-b5f2-00cc8119454f	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.7400	18.1850	14565.00	14260.00	305.00	235	5	1334	3222	0.414028553693358	0.787918006578415	0.77929236685915	true	false	false	true	false
08ee7981-a795-421d-bafe-e9b16ceb2aac	2026-08-25 11:00	2026-08-25 11:00	2026-08-25 11:00	PCG	PCG260911C00019500	call	19.5000	2026-09-11	0.5800	0.4700	0.6300	18.2010	60581.00	57398.00	2878.00	1040	39	1040	199	5.22613065326633	0.713638233102446	0.678286181875137	true	false	false	true	false
a660dbb2-8bcb-419f-973f-607e8255547f	2026-08-25 11:00	2026-08-25 11:00	2026-08-25 11:00	PCG	PCG260911C00019500	call	19.5000	2026-09-11	0.6100	0.4800	0.6100	18.2050	61000.00	61000.00	0.00	1000	33	2040	199	10.251256281407	0.697874106230743	0.697874106230743	true	false	false	true	false
21e84fb5-4891-468a-8eed-64ac61875228	2026-08-25 11:02	2026-08-25 11:02	2026-08-25 11:02	PCG	PCG260911C00019500	call	19.5000	2026-09-11	0.5700	0.5700	0.5800	18.1919	21660.00	0.00	21660.00	380	19	2832	199	14.2311557788945	0.673584656183988	0.673584656183988	false	false	false	true	false
b217c41a-462e-4ba1-9c06-562a1a61775f	2026-08-25 11:10	2026-08-25 11:09	2026-08-25 11:09	PCG	PCG261016C00021000	call	21.0000	2026-10-16	0.4400	0.3300	0.4700	18.1850	22800.00	22000.00	800.00	520	5	860	8055	0.106765983860956	0.475148542025285	0.456485030428488	false	false	false	true	false
691de3c6-94bf-4536-b4ec-6d3df11208c1	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	PCG	PCG261016C00021000	call	21.0000	2026-10-16	0.4400	0.4300	0.4600	18.1880	13107.00	0.00	259.00	298	5	1158	8055	0.143761638733706	0.474806356891833	0.470184564821491	false	false	false	true	false
265b5c1e-c602-4509-97d7-5c8f7824b4ab	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	PCG	PCG261016C00021000	call	21.0000	2026-10-16	0.4400	0.3700	0.4700	18.1880	14146.00	13857.00	289.00	322	38	1480	8055	0.183736809435133	0.474806356891833	0.465535356314624	true	false	false	true	false
e9a19478-bd8f-4894-97b8-91ba5f8f3168	2026-08-25 11:39	2026-08-25 11:38	2026-08-25 11:38	PCG	PCG260911C00019000	call	19.0000	2026-09-11	0.7300	0.7300	0.7700	18.1800	11680.00	0.00	11680.00	160	8	306	155	1.9741935483871	0.674761722622594	0.674761722622594	false	false	false	true	false
2219a51c-4d69-4005-aa49-de81a4958b0f	2026-08-25 13:07	2026-08-25 13:07	2026-08-25 13:07	PCG	PCG260918P00018000	put	18.0000	2026-09-18	0.9300	0.8900	0.9400	18.1150	13950.00	9765.00	4185.00	150	7	8071	19281	0.418598620403506	0.546740939248611	0.546740939248611	false	false	false	true	false
9720d7fa-81a6-42f2-9830-7bf3fd4d61e2	2026-08-25 13:13	2026-08-25 13:13	2026-08-25 13:13	PCG	PCG260918P00018000	put	18.0000	2026-09-18	0.9400	0.9000	0.9500	18.0921	11374.00	8084.00	3290.00	121	7	8193	19281	0.424926093044967	0.54659030034229	0.54659030034229	true	false	false	true	false
6f562129-688f-4866-95f6-3fbff2f71a08	2026-08-25 14:16	2026-08-25 14:16	2026-08-25 14:16	PCG	PCG260828C00019000	call	19.0000	2026-08-28	0.3100	0.3100	0.3900	18.0000	64697.00	0.00	64697.00	2087	24	5127	3865	1.32652005174644	0.934878390370402	0.934878390370402	false	false	false	true	false
e1e28484-2236-4aad-870d-698f8ef4af6f	2026-08-25 14:19	2026-08-25 14:19	2026-08-25 14:19	PCG	PCG260828C00019500	call	19.5000	2026-08-28	0.2400	0.1200	0.3000	18.0000	47328.00	47232.00	96.00	1972	12	2043	705	2.89787234042553	1.03693687846209	1.03693687846209	true	false	false	true	false
34ef98c4-caa1-4b19-8629-c0c767374e8e	2026-08-25 14:59	2026-08-25 14:59	2026-08-25 14:59	PCG	PCG260918P00017000	put	17.0000	2026-09-18	0.5100	0.4600	0.5100	18.2050	38607.00	37689.00	0.00	757	55	810	43470	0.0186335403726708	0.566290563439386	0.564488166163812	true	false	false	true	false
08f89dfd-a38f-49ea-b4ac-e496aa033773	2026-08-25 15:00	2026-08-25 14:59	2026-08-25 14:59	PCG	PCG260918P00018000	put	18.0000	2026-09-18	0.8900	0.8600	0.9000	18.2050	12994.00	4450.00	8544.00	146	17	8621	19281	0.447124111819926	0.546522844413645	0.546522844413645	true	false	false	true	false
07f6f74a-199a-4213-acf2-a6aa13979df8	2026-08-25 15:00	2026-08-25 14:59	2026-08-25 14:59	PCG	PCG260918P00018000	put	18.0000	2026-09-18	0.8900	0.8900	0.9000	18.2050	15486.00	0.00	15486.00	174	13	8795	19281	0.456148540013485	0.546522844413645	0.546522844413645	false	false	false	true	false
41956f77-1fc8-44c4-9728-b22c0124ff49	2026-08-25 15:03	2026-08-25 15:03	2026-08-25 15:03	PCG	PCG260918P00018000	put	18.0000	2026-09-18	0.9100	0.8500	0.9100	18.2199	12103.00	12103.00	0.00	133	9	9328	19281	0.483792334422488	0.560922259677999	0.560922259677999	true	false	false	true	false
e5b0eeb9-bd43-437f-a7b4-0a34aae5d9f6	2026-08-26 13:51	2026-08-26 13:51	2026-08-26 13:51	PCG	PCG260904P00017500	put	17.5000	2026-09-04	0.5000	0.4000	0.6700	18.2550	450000.00	0.00	0.00	9000	7	9043	764	11.836387434555	0.741293638111001	0.741293638111001	false	false	false	true	false
3bd5fb24-cc36-459e-bc8f-c9f98b3f9bf9	2026-08-26 15:03	2026-08-26 15:03	2026-08-26 15:03	PCG	PCG260918C00019000	call	19.0000	2026-09-18	0.6900	0.6900	0.7400	18.2600	61824.00	0.00	58581.00	896	51	3016	164447	0.0183402555230561	0.53896302581005	0.536657206938521	false	false	false	true	false
c408fdf3-b9e8-4cb1-bfc3-4d73459dd81a	2026-08-27 09:31	2026-08-27 09:31	2026-08-27 09:31	PCG	PCG260925C00018000	call	18.0000	2026-09-25	1.0200	0.9600	1.0800	18.0100	57452.00	36134.00	17340.00	561	18	621	12413	0.0500281962458713	0.488941125431154	0.483981334341789	true	false	false	true	false
e9a1ae78-0058-4c07-98ae-1b52cd6dab52	2026-08-27 09:31	2026-08-27 09:31	2026-08-27 09:31	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.9500	0.9400	1.0500	17.9700	38380.00	19285.00	5510.00	404	16	830	75316	0.0110202347442774	0.537133643079312	0.537133643079312	false	false	false	true	false
850f96b8-07a8-43c3-a87d-8cb082c47d3e	2026-08-27 09:31	2026-08-27 09:31	2026-08-27 09:31	PCG	PCG260918C00018000	call	18.0000	2026-09-18	0.9700	0.9400	1.0500	18.0000	34920.00	11058.00	19691.00	360	13	426	75316	0.00565616867597854	0.539455734578934	0.539455734578934	false	false	false	true	false