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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = PCT×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

c88ae7a8-e716-4c7b-b88e-8e6e028676d9	2026-08-17 14:13	2026-08-17 14:13	2026-08-17 14:13	PCT	PCT270115P00005000	put	5.0000	2027-01-15	0.6000	0.5500	0.6500	7.1100	12900.00	12840.00	0.00	215	7	724	36686	0.0197350487924549	0.956960741505807	0.956960741505807	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	1175293139.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5a6742c5-761e-4d92-ba8e-1fbe9eb4c6a4	2026-08-18 10:43	2026-08-18 10:43	2026-08-18 10:43	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.8000	0.8000	0.8500	6.9699	24720.00	0.00	24720.00	309	9	326	42182	0.00772841496372861	0.905138691565887	0.905138691565887	false	false	false
e4cf7f7d-93b3-4845-9e74-fa363d7973be	2026-08-18 10:43	2026-08-18 10:43	2026-08-18 10:43	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.8000	0.8000	0.8500	6.9300	24320.00	0.00	24320.00	304	9	946	42182	0.0224266274714333	0.914082075551542	0.914082075551542	false	false	false
795e5dbe-cb3a-48d0-8d82-bb9635a7f0f0	2026-08-18 10:43	2026-08-18 10:43	2026-08-18 10:43	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.8000	0.8000	0.8500	6.9300	25280.00	0.00	25280.00	316	17	642	42182	0.0152197619837846	0.914082075551542	0.914082075551542	false	false	false
77450c4c-631c-4633-85f0-803628d03ff1	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	PCT	PCT260925C00009000	call	9.0000	2026-09-25	0.2000	0.2000	0.3000	6.9600	93178.00	0.00	93178.00	4649	48	4754	5014	0.948145193458317	0.823992775716476	0.838621947717661	false	false	false
6eee7205-aaa0-4510-a1f0-436a7172cdd9	2026-08-19 09:57	2026-08-19 09:57	2026-08-19 09:57	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.8500	0.8500	0.9500	7.0950	13770.00	0.00	13770.00	162	5	363	42004	0.00864203409199124	0.909287839680863	0.909287839680863	false	false	false
50b9f664-2979-457f-bacb-6980911fbb0b	2026-08-19 11:29	2026-08-19 11:29	2026-08-19 11:29	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.9500	0.8500	0.9500	7.2250	19000.00	19000.00	0.00	200	9	1800	42004	0.0428530616131797	0.936146210685348	0.936146210685348	false	false	false
216a399e-47d4-4099-b0ef-8c33a63639cd	2026-08-19 13:30	2026-08-19 13:30	2026-08-19 13:30	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.9000	0.9000	0.9500	7.2600	33840.00	0.00	33840.00	376	15	2258	42004	0.0537567850680888	0.900372059082217	0.900372059082217	false	false	false
0cc54c9b-2944-419e-8c2b-94098a1f3851	2026-08-19 13:36	2026-08-19 13:36	2026-08-19 13:36	PCT	PCT270319C00010000	call	10.0000	2027-03-19	1.3000	1.2500	1.3000	7.2700	52130.00	52130.00	0.00	401	43	439	11303	0.0388392462178183	0.933597578273289	0.929287913826007	true	false	false
9283f683-1082-44aa-8c16-bbb7fa819be0	2026-08-19 14:59	2026-08-19 14:59	2026-08-19 14:59	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.9000	0.9000	0.9500	7.2500	21330.00	0.00	21330.00	237	18	2879	42004	0.0685410913246357	0.901498266203558	0.902625108205679	true	false	false
97ef8261-0ce6-45b1-a8a6-c35088067c75	2026-08-19 14:59	2026-08-19 14:59	2026-08-19 14:59	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.9000	0.9000	0.9500	7.2500	15390.00	0.00	15390.00	171	7	3050	42004	0.0726121321778878	0.902625108205679	0.902625108205679	false	false	false
0be9b84b-f03a-4383-999e-ca6f30d1cf98	2026-08-19 14:59	2026-08-19 14:59	2026-08-19 14:59	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.9000	0.8500	0.9500	7.2250	11340.00	9720.00	0.00	126	5	3177	42004	0.0756356537472622	0.90826890389667	0.90826890389667	false	false	false
bc248acd-3472-4c2c-b10e-3c1a10c23413	2026-08-20 15:32	2026-08-20 15:32	2026-08-20 15:32	PCT	PCT270115C00007000	call	7.0000	2027-01-15	1.4500	1.4000	1.4500	6.6950	42920.00	42920.00	0.00	296	12	327	20089	0.0162775648364777	0.908041088560793	0.908041088560793	false	false	false
015d364f-747a-4c20-8e5e-182564e927ed	2026-08-24 11:33	2026-08-24 11:33	2026-08-24 11:33	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.7500	0.6500	0.7500	6.7850	74960.00	74960.00	0.00	1000	11	1147	40786	0.02812239493944	0.929973209442346	0.929973209442346	false	false	false
fda197ab-e1d9-4cde-a329-85899cf93e66	2026-08-24 15:55	2026-08-24 15:54	2026-08-24 15:54	PCT	PCT261120P00005000	put	5.0000	2026-11-20	0.5000	0.4000	0.5500	6.6650	107157.00	106907.00	250.00	2145	22	2145	755	2.84105960264901	1.03842589294549	1.03842589294549	false	false	false
7449dd07-74d6-466b-b1ef-340027cf5d1c	2026-08-24 15:55	2026-08-24 15:55	2026-08-24 15:55	PCT	PCT260918P00007000	put	7.0000	2026-09-18	0.8000	0.7500	0.8000	6.6050	12960.00	12960.00	0.00	162	23	398	628	0.633757961783439	0.83742459081361	0.83742459081361	false	false	false
dfd1b491-c7a3-41e4-ac9a-ad55a9df715f	2026-08-27 12:46	2026-08-27 12:46	2026-08-27 12:46	PCT	PCT280121C00010000	call	10.0000	2028-01-21	2.2500	2.2000	2.3000	6.7350	11250.00	9900.00	1350.00	50	7	97	19329	0.00501836618552434	0.960135323865429	0.960135323865429	false	false	false
40026d92-0f71-4ace-a5d0-b4f6d3a557ec	2026-08-31 13:06	2026-08-31 13:05	2026-08-31 13:05	PCT	PCT280121C00010000	call	10.0000	2028-01-21	2.1500	2.0000	2.2000	6.4600	1075000.00	1075000.00	0.00	5000	3	5012	19488	0.257183908045977	0.979904405609257	0.979904405609257	false	true	true
1f988358-2d10-44fb-8705-8cfef786ceaf	2026-09-01 14:55	2026-09-01 14:55	2026-09-01 14:55	PCT	PCT261016P00006000	put	6.0000	2026-10-16	0.6000	0.6000	0.7000	6.1400	59940.00	0.00	59940.00	999	19	1054	255	4.13333333333333	0.805536735523574	0.805536735523574	false	false	false
06e028c8-12fa-4eb5-ba63-a06c8e97cedb	2026-09-01 15:00	2026-09-01 15:00	2026-09-01 15:00	PCT	PCT261016C00007000	call	7.0000	2026-10-16	0.4000	0.4000	0.4500	6.1700	39960.00	0.00	39960.00	999	35	1511	810	1.86543209876543	0.797218151650548	0.797218151650548	false	false	false
2921233b-e262-4d30-bf6c-8afb5698be00	2026-09-03 10:28	2026-09-03 10:28	2026-09-03 10:28	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.4000	1.2500	1.4000	6.2100	350000.00	350000.00	0.00	2500	13	2521	5030	0.501192842942346	0.916157531645141	0.904911235380751	false	false	false
576a8b98-2e99-4f80-a368-e1fce06793d7	2026-09-03 14:20	2026-09-03 14:20	2026-09-03 14:20	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.4500	1.4000	1.5000	6.3050	16965.00	0.00	14355.00	117	5	2929	5030	0.582306163021869	0.902181366513848	0.902181366513848	false	false	false
a4394ec3-0291-448d-8834-3dbd460c9490	2026-09-03 14:21	2026-09-03 14:21	2026-09-03 14:21	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.4500	1.2000	1.4500	6.3150	35815.00	35815.00	0.00	247	24	3176	5030	0.631411530815109	0.898963717880844	0.898963717880844	true	false	false
96a91d55-96fc-4563-8a4d-f16696676a9e	2026-09-04 11:11	2026-09-04 11:11	2026-09-04 11:11	PCT	PCT270219P00007000	put	7.0000	2027-02-19	1.8500	1.8500	1.9000	6.3900	12765.00	0.00	12765.00	69	5	118	443	0.266365688487585	0.903722736812665	0.903722736812665	true	false	false
eb29bf5a-6abf-4323-8f3c-40f639e815c9	2026-09-08 09:56	2026-09-08 09:56	2026-09-08 09:56	PCT	PCT270115C00007000	call	7.0000	2027-01-15	1.1500	1.1500	1.2000	6.4300	11730.00	0.00	11730.00	102	8	381	16972	0.0224487390996936	0.878829078193439	0.878829078193439	false	false	false
3657aa7a-e6a2-47ae-a8ab-4fa5ae877513	2026-09-08 11:43	2026-09-08 11:43	2026-09-08 11:43	PCT	PCT270115C00007000	call	7.0000	2027-01-15	1.2000	1.1500	1.2000	6.5305	16920.00	3600.00	0.00	141	6	1148	16972	0.0676408201744049	0.874998158227997	0.874998158227997	false	false	false
a1820fe3-49c9-4533-8af5-fd6fbf267c92	2026-09-08 11:44	2026-09-08 11:44	2026-09-08 11:44	PCT	PCT270115C00008000	call	8.0000	2027-01-15	0.9300	0.8500	0.9500	6.5100	28041.00	28041.00	0.00	300	6	319	13938	0.0228870713158272	0.904205913111199	0.904205913111199	false	false	false
ccda5cd5-b6c5-4c15-86c2-cebd70553462	2026-09-08 12:01	2026-09-08 12:01	2026-09-08 12:01	PCT	PCT270115C00008000	call	8.0000	2027-01-15	0.9400	0.8500	0.9500	6.5200	31178.00	31178.00	0.00	333	5	652	13938	0.0467785909025685	0.907675973364944	0.901185441096207	false	false	false
3f30ea33-5404-4e02-a42f-fb21f2a2a921	2026-09-08 15:09	2026-09-08 15:09	2026-09-08 15:09	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.5500	1.5000	1.5500	6.5000	11315.00	11315.00	0.00	73	5	180	8228	0.0218765192027224	0.906401185133412	0.906401185133412	false	false	false
e12f58c0-d34b-424f-9416-91f1872cb454	2026-09-09 11:20	2026-09-09 11:20	2026-09-09 11:20	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.5000	1.4500	1.5000	6.3850	16800.00	16800.00	0.00	112	16	238	8671	0.0274478145542613	0.92299648191295	0.92299648191295	false	false	false
52eefc20-26ad-433e-97d9-f4ee888af639	2026-09-09 14:36	2026-09-09 14:36	2026-09-09 14:36	PCT	PCT270115C00007000	call	7.0000	2027-01-15	1.1000	1.0500	1.1500	6.3400	11440.00	6710.00	550.00	104	5	264	14751	0.0178970917225951	0.88378147524968	0.88378147524968	false	false	false
b8cad510-c304-46ea-bee1-84ff0514f447	2026-09-10 10:29	2026-09-10 10:29	2026-09-10 10:29	PCT	PCT280121C00008000	call	8.0000	2028-01-21	2.1100	2.1000	2.2500	6.1250	20905.00	4945.00	15960.00	99	6	958	4931	0.194281078888664	0.906696604088278	0.925268837525296	true	false	false
2068a181-7c7f-4665-bdbf-81684866644c	2026-09-10 10:33	2026-09-10 10:33	2026-09-10 10:33	PCT	PCT280121C00008000	call	8.0000	2028-01-21	2.0500	2.0500	2.1000	6.0800	20309.00	0.00	20309.00	99	6	2262	4931	0.458730480632732	0.902355072948901	0.902355072948901	false	false	false
9fb54cf8-6261-467a-8ae1-8493549afe33	2026-09-10 10:38	2026-09-10 10:38	2026-09-10 10:38	PCT	PCT280121C00008000	call	8.0000	2028-01-21	2.0000	2.0000	2.1500	6.0200	191000.00	0.00	191000.00	955	11	3833	4931	0.777327114175624	0.893942176441213	0.893942176441213	true	false	false
64280ed1-a731-4953-95c2-738c4f3bb5d8	2026-09-10 12:36	2026-09-10 12:36	2026-09-10 12:36	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.2500	1.0500	1.3500	5.9450	20000.00	1375.00	18625.00	160	9	202	9110	0.0221734357848518	0.921521576725803	0.921521576725803	false	false	false
d0cd8944-259a-4693-9ad3-d82ecefd1ca6	2026-09-10 14:36	2026-09-10 14:35	2026-09-10 14:35	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.1500	1.1000	1.1500	5.7650	11040.00	11040.00	0.00	96	11	898	9110	0.0985729967069155	0.91965421985008	0.91965421985008	false	false	false
50b1665f-af4d-4899-bcf7-576215bc0768	2026-09-10 14:36	2026-09-10 14:35	2026-09-10 14:35	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.1500	1.1000	1.1500	5.7650	13225.00	13225.00	0.00	115	15	1013	9110	0.111196487376509	0.91965421985008	0.91965421985008	false	false	false
1a80902b-4de7-4334-b872-456860c4391d	2026-09-10 14:36	2026-09-10 14:35	2026-09-10 14:35	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.1500	1.1000	1.1500	5.7650	13685.00	13685.00	0.00	119	17	1132	9110	0.124259055982437	0.91965421985008	0.91965421985008	false	false	false
a5e1fc38-3f82-4068-99c2-7ee04e8111d3	2026-09-11 11:09	2026-09-11 11:08	2026-09-11 11:08	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.4000	0.3500	0.4000	6.0450	24480.00	24480.00	0.00	612	15	674	39598	0.0170210616697813	0.916274496993272	0.915144499104286	false	false	false
9ae62205-100f-4833-bd35-2b430ccea4da	2026-09-11 11:09	2026-09-11 11:08	2026-09-11 11:08	PCT	PCT270115C00010000	call	10.0000	2027-01-15	0.4000	0.3500	0.4000	6.0750	24760.00	24760.00	0.00	619	12	1293	39598	0.0326531643012273	0.910633265676216	0.908382875151045	false	false	false
ece66e95-4d7d-47a4-9db1-00c3edae169f	2026-09-15 09:39	2026-09-15 09:39	2026-09-15 09:39	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.6000	2.6000	2.8000	5.7200	38740.00	0.00	38740.00	149	13	864	1711	0.504967855055523	0.888514140606776	0.888514140606776	true	false	false
b9f80f04-b2e3-45c8-8bd2-109b5c4e2a72	2026-09-15 09:39	2026-09-15 09:39	2026-09-15 09:39	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.6000	2.6000	2.8000	5.7200	31200.00	0.00	31200.00	120	16	984	1711	0.57510227936879	0.888514140606776	0.888514140606776	true	false	false
fd31e48f-9864-4a55-8260-b9640f73fb9a	2026-09-15 09:39	2026-09-15 09:39	2026-09-15 09:39	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.6000	2.6000	2.8000	5.7200	10400.00	0.00	10400.00	40	8	1024	1711	0.598480420806546	0.888514140606776	0.888514140606776	true	false	false
58ae7509-e7a5-4eca-acd3-c81f9097270b	2026-09-17 10:27	2026-09-17 10:27	2026-09-17 10:27	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.1000	1.1000	1.1500	5.6850	11000.00	0.00	11000.00	100	6	2314	11028	0.209829524845847	0.931368101115791	0.931368101115791	false	false	false
b175f4d2-ce3d-49b6-abff-2953f3753460	2026-09-17 10:27	2026-09-17 10:27	2026-09-17 10:27	PCT	PCT270319C00007000	call	7.0000	2027-03-19	1.1000	0.8500	1.1000	5.6850	22220.00	22220.00	0.00	202	7	2536	11028	0.229960101559666	0.931368101115791	0.931368101115791	false	false	false
1a5df8d5-9cdc-4a47-aa22-1389d58c047d	2026-09-18 14:15	2026-09-18 14:15	2026-09-18 14:15	PCT	PCT270319C00010000	call	10.0000	2027-03-19	0.6000	0.5500	0.6000	5.7600	30000.00	30000.00	0.00	500	15	500	9529	0.0524714030853185	0.952399606627782	0.952399606627782	true	false	false
f558f0e5-1c86-4a95-b6ea-07fddf299a88	2026-09-22 10:21	2026-09-22 10:21	2026-09-22 10:21	PCT	PCT270319C00010000	call	10.0000	2027-03-19	0.5500	0.4500	0.5500	5.5250	12870.00	12870.00	0.00	234	6	674	9708	0.0694272764730119	0.981688041848383	0.981688041848383	false	false	false
49191bdd-bfc9-4420-87d6-1c512d4e7e70	2026-09-23 10:54	2026-09-23 10:53	2026-09-23 10:53	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.3500	2.2500	2.3500	5.0000	31255.00	27025.00	0.00	133	7	154	2568	0.0599688473520249	0.902489935506245	0.902489935506245	false	false	false
986a688b-29f1-4fb3-b9c3-2f947f5ef913	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.3500	2.3500	2.3500	5.0000	15980.00	0.00	0.00	68	6	253	2568	0.0985202492211838	0.902489935506245	0.904233342041701	true	false	false
7440a277-c312-4cb4-942b-0886e9ab73b4	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.3100	2.3000	2.5500	5.0000	50320.00	8460.00	41860.00	218	8	471	2568	0.183411214953271	0.881141494080018	0.906089538281347	false	false	false