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:er_time = unknown×ticker = PCT×

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

22ae2d1d-d61d-4bc0-889c-c7c83650720a	2026-09-24 15:53	2026-09-24 15:53	2026-09-24 15:53	PCT	PCT280121C00010000	call	10.0000	2028-01-21	1.2500	1.2000	1.3000	4.8850	12500.00	0.00	10000.00	100	5	2135	32626	0.0654386072457549	0.989865614751791	0.989865614751791	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	1034659772.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:53:57.742588Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
d1372f97-a45f-47ce-b925-76b6c22a99dc	2026-09-24 12:19	2026-09-24 12:19	2026-09-24 12:19	PCT	PCT270115P00005000	put	5.0000	2027-01-15	1.0000	0.9500	1.0500	5.0450	19400.00	0.00	15900.00	194	5	535	35940	0.0148859209794101	0.963697757448107	0.963697757448107	false	false	false	true	false
afccfcbc-5681-4cb3-9224-8aa80754bb0d	2026-09-24 11:37	2026-09-24 11:36	2026-09-24 11:36	PCT	PCT270319C00006000	call	6.0000	2027-03-19	1.0000	0.9500	1.0000	4.0000	26500.00	26500.00	0.00	265	5	3913	31	126.225806451613	0.954069056903051	0.954069056903051	false	false	false	true	false
56afe1f7-f469-4923-a376-dfbe80566c98	2026-09-24 11:37	2026-09-24 11:36	2026-09-24 11:36	PCT	PCT270319C00006000	call	6.0000	2027-03-19	1.0000	1.0000	1.0500	4.0000	24800.00	0.00	24800.00	248	6	4161	31	134.225806451613	0.956005337128384	0.959882157987725	true	false	false	true	false
ea17bf82-8476-419d-8201-b09f4f35d764	2026-09-24 11:36	2026-09-24 11:36	2026-09-24 11:36	PCT	PCT270319C00006000	call	6.0000	2027-03-19	1.0000	0.9500	1.0000	4.0000	26500.00	26500.00	0.00	265	5	3648	31	117.677419354839	0.959882157987725	0.959882157987725	false	false	false	true	false
d4a97da9-6ad5-4585-b281-7267ec6545f4	2026-09-24 11:36	2026-09-24 11:36	2026-09-24 11:36	PCT	PCT270319C00006000	call	6.0000	2027-03-19	1.0000	0.9500	1.0500	4.0000	75700.00	46100.00	21300.00	757	22	3383	31	109.129032258065	0.96376471636661	0.959882157987725	false	false	false	true	false
a5ddd965-3d3c-4d12-b821-80889468f6ed	2026-09-24 11:36	2026-09-24 11:36	2026-09-24 11:36	PCT	PCT270319C00006000	call	6.0000	2027-03-19	1.0000	0.9500	1.0000	4.0000	46500.00	46500.00	0.00	465	8	2626	31	84.7096774193548	0.967653080655545	0.967653080655545	false	false	false	true	false
a05ba41d-39f1-4b02-aa61-e1f808a1b976	2026-09-24 11:33	2026-09-24 11:33	2026-09-24 11:33	PCT	PCT270319C00006000	call	6.0000	2027-03-19	1.0000	0.9000	1.0000	4.9250	26600.00	26600.00	0.00	266	19	2008	31	64.7741935483871	0.973496662856516	0.973496662856516	false	false	false	true	false
9249e510-e91e-43fb-959c-5cf69c296abb	2026-09-24 11:33	2026-09-24 11:33	2026-09-24 11:33	PCT	PCT270319C00006000	call	6.0000	2027-03-19	1.0000	0.9500	1.0000	4.9200	27700.00	27700.00	0.00	277	25	1742	31	56.1935483870968	0.975447500696824	0.975447500696824	false	false	false	true	false
1e1a1247-570e-4b05-ad56-b57ed5c6f55e	2026-09-24 11:33	2026-09-24 11:33	2026-09-24 11:33	PCT	PCT270319C00006000	call	6.0000	2027-03-19	1.0000	0.9000	1.0000	4.9150	31000.00	31000.00	0.00	310	19	1465	31	47.258064516129	0.977399841364445	0.977399841364445	false	false	false	true	false
1a7c1545-691f-42e5-9684-76387eff1d06	2026-09-24 11:33	2026-09-24 11:33	2026-09-24 11:33	PCT	PCT270319C00006000	call	6.0000	2027-03-19	1.0000	0.9000	1.0000	4.9050	29600.00	29600.00	0.00	296	7	1155	31	37.258064516129	0.981309065465065	0.981309065465065	false	false	false	true	false
a58b8bca-3a66-4e0e-bcc1-1cabfb7df8b9	2026-09-24 11:31	2026-09-24 11:31	2026-09-24 11:31	PCT	PCT270319C00006000	call	6.0000	2027-03-19	0.9500	0.9000	0.9500	4.8750	48070.00	48070.00	0.00	506	18	859	31	27.7096774193548	0.955977849323457	0.955977849323457	false	false	false	true	false
e3126dc5-2ccb-4b1c-b80f-199d25d4eaeb	2026-09-24 09:46	2026-09-24 09:46	2026-09-24 09:46	PCT	PCT261120P00005000	put	5.0000	2026-11-20	0.8000	0.6500	0.8000	5.0350	23990.00	23990.00	0.00	300	16	350	3867	0.0905094388414792	0.999491606452199	1.06427119625478	false	false	false	true	false
8c21ffe0-469c-4898-a784-056c6f32524c	2026-09-24 09:45	2026-09-24 09:45	2026-09-24 09:45	PCT	PCT270319P00004000	put	4.0000	2027-03-19	0.6500	0.6500	0.8000	5.0192	19500.00	0.00	19500.00	300	5	300	160	1.875	0.921007710360728	0.921007710360728	false	false	false	true	false
8df1fa29-ecb6-43e6-bb76-cefd7095addf	2026-09-23 15:33	2026-09-23 15:32	2026-09-23 15:32	PCT	PCT280121C00010000	call	10.0000	2028-01-21	1.3000	1.2500	1.3500	5.1350	25870.00	22230.00	260.00	199	6	3399	30418	0.111743046880137	0.9571664316671	0.9571664316671	false	false	false	true	false
29dc995d-ee71-48b0-8d48-587b2ebf9f48	2026-09-23 13:50	2026-09-23 13:50	2026-09-23 13:50	PCT	PCT270319C00008000	call	8.0000	2027-03-19	0.7000	0.6500	0.7000	5.2150	10500.00	10500.00	0.00	150	5	3023	10455	0.289143950263032	0.967821168194317	0.967821168194317	false	false	false	true
14080a3a-9094-45b8-aa82-811473818205	2026-09-23 13:49	2026-09-23 13:49	2026-09-23 13:49	PCT	PCT270319C00008000	call	8.0000	2027-03-19	0.7000	0.6000	0.7000	5.1450	148680.00	148680.00	0.00	2124	22	2774	10455	0.265327594452415	0.987711092903483	0.987711092903483	false	false	false	true
8fa0aab1-28a9-46f8-95fd-fb4e53f6bf4b	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.3000	2.2500	2.4500	5.0000	13570.00	1380.00	10810.00	59	5	1197	2568	0.466121495327103	0.89957025307274	0.89957025307274	false	false	false	true	false
0d8b3c2a-7d51-45e3-add0-c410b6026cf8	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.3000	2.2500	2.3000	5.0000	21390.00	21160.00	0.00	93	7	1020	2568	0.397196261682243	0.88849489787549	0.88849489787549	false	false	false	true	false
49b0b67c-bf79-4b37-a1b2-cd8fa1d0d711	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.3000	2.3000	2.5500	5.0000	13110.00	0.00	13110.00	57	5	814	2568	0.316978193146417	0.88849489787549	0.88849489787549	false	false	false	true	false
a3e6f2ee-70a6-46a1-9cbb-4f68a9a6a6d8	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.3000	2.2500	2.5500	5.0000	33580.00	5750.00	14950.00	146	11	757	2568	0.294781931464174	0.886654326838616	0.886654326838616	true	false	false	true
19b4c91c-87b1-4aa6-93af-0bce9bc98cf5	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	PCT	PCT280121C00005000	call	5.0000	2028-01-21	2.3000	2.3000	2.5500	5.0000	32201.00	0.00	32201.00	140	28	611	2568	0.237928348909657	0.881141494080018	0.881141494080018	false	false	false	true	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	true
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	true	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	true	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	true
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	true
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	true
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	true
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	true	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	true	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	true	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	true
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	true
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	true	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	true	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	true	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	true
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	true
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	true	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	true	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	true	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	true	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	true	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	true
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	true
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	true
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	true
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	true	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	true	false