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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = PTC×

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

d4e128d2-aadc-4318-ad0e-969d9161ff4a	2026-10-02 15:32	2026-10-02 15:32	2026-10-02 15:32	PTC	PTC261016P00140000	put	140.0000	2026-10-16	3.7000	3.4000	3.8000	143.0000	34408.00	34038.00	370.00	93	42	1393	916	1.5207423580786	0.493136966934548	0.493136966934548	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	15628156772.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:35:44.377882Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
d810cd61-eb69-4715-8496-f9c84623e459	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	PTC	PTC261016P00140000	put	140.0000	2026-10-16	2.9500	2.9500	3.6000	144.1250	10325.00	0.00	10325.00	35	10	1264	916	1.37991266375546	0.434108428466568	0.434108428466568	false	false	false	true
1522b90f-718f-4daa-a054-e061fad8dcf2	2026-10-02 11:29	2026-10-02 11:29	2026-10-02 11:29	PTC	PTC261016P00140000	put	140.0000	2026-10-16	3.3000	2.8000	3.3000	145.0000	26730.00	26730.00	0.00	81	15	457	916	0.498908296943231	0.510967222613643	0.510967222613643	false	false	false	true
dec5d80e-8a65-4de8-979a-5e15d7a90a87	2026-10-02 10:42	2026-10-02 10:42	2026-10-02 10:42	PTC	PTC261016P00140000	put	140.0000	2026-10-16	3.2000	2.8000	3.2000	145.0000	41598.00	41598.00	0.00	130	32	315	916	0.343886462882096	0.497733782404262	0.497733782404262	false	false	false	true
eda15954-e564-451b-a60e-36c80613867d	2026-10-02 10:42	2026-10-02 10:41	2026-10-02 10:41	PTC	PTC261016P00140000	put	140.0000	2026-10-16	3.1000	2.8000	3.2000	145.2500	34720.00	33480.00	0.00	112	29	147	916	0.160480349344978	0.485123144323859	0.485123144323859	false	false	false	true
5bd12ab0-82fb-4ca6-bd2e-8ab1403e6d1d	2026-10-01 14:32	2026-10-01 14:32	2026-10-01 14:32	PTC	PTC261016P00140000	put	140.0000	2026-10-16	2.9000	2.6000	2.9500	146.9400	20590.00	20010.00	0.00	71	26	693	119	5.82352941176471	0.500002695313467	0.500002695313467	false	false	false	true
be7f5d86-2668-479d-8d25-d65b444d0913	2026-10-01 14:31	2026-10-01 14:31	2026-10-01 14:31	PTC	PTC261016P00140000	put	140.0000	2026-10-16	2.9000	2.6000	2.9500	146.9700	35090.00	35090.00	0.00	121	5	452	119	3.79831932773109	0.500860385523632	0.500860385523632	false	false	false	true
8c855494-4227-4d3c-bd13-a4b706e3cb64	2026-10-01 14:31	2026-10-01 14:31	2026-10-01 14:31	PTC	PTC261016P00140000	put	140.0000	2026-10-16	2.9000	2.6000	2.9500	146.9700	10150.00	7250.00	580.00	35	9	331	119	2.78151260504202	0.500860385523632	0.500860385523632	false	false	false	true
444e2aa1-c647-42da-b5cb-17961675594a	2026-10-01 14:31	2026-10-01 14:31	2026-10-01 14:31	PTC	PTC261120C00140000	call	140.0000	2026-11-20	14.5000	13.8000	15.1000	146.9500	13050.00	13050.00	0.00	9	5	18	72	0.25	0.481722556753686	0.481722556753686	false	false	false	true
67c410e0-35a2-4686-9a82-94ebe8763553	2026-10-01 13:34	2026-10-01 13:34	2026-10-01 13:34	PTC	PTC261016P00140000	put	140.0000	2026-10-16	3.0900	2.6000	3.2000	147.0000	40811.00	40501.00	310.00	132	32	189	119	1.58823529411765	0.524188113753234	0.525193732146714	false	false	false	true
42627ab8-a46b-4682-bac4-442611c99809	2026-10-01 13:29	2026-10-01 13:29	2026-10-01 13:29	PTC	PTC261016C00150000	call	150.0000	2026-10-16	4.0000	3.2000	4.4000	146.6750	36400.00	2000.00	34400.00	91	12	91	232	0.392241379310345	0.450651614578409	0.450651614578409	false	false	false	true
0be32d63-bbf4-4312-8ba9-082e89ee9780	2026-09-30 11:55	2026-09-30 11:55	2026-09-30 11:55	PTC	PTC261120P00120000	put	120.0000	2026-11-20	2.8500	2.5500	3.4000	139.0000	171000.00	0.00	171000.00	600	1	606	900	0.673333333333333	0.510481097987492	0.510481097987492	false	true	true	false
f17424b3-2f6c-47cd-aeda-4cbc28f7c940	2026-09-14 14:33	2026-09-14 14:33	2026-09-14 14:33	PTC	PTC260918P00150000	put	150.0000	2026-09-18	12.8000	12.7000	14.2000	137.5050	48640.00	7680.00	40960.00	38	6	117	151	0.774834437086093	0.609575117406635	0.609575117406635	false	false	false	true
6ef14adc-49e1-4964-8d32-d12e7c2cd9f3	2026-09-14 14:33	2026-09-14 14:33	2026-09-14 14:33	PTC	PTC260918P00150000	put	150.0000	2026-09-18	12.7000	12.4000	12.7000	137.4500	53340.00	5080.00	0.00	42	6	77	151	0.509933774834437	0.53819146194192	0.53819146194192	false	false	false	true
e101d490-fd0f-4066-a7e2-54e69dc95383	2026-09-14 14:33	2026-09-14 14:33	2026-09-14 14:33	PTC	PTC260918P00150000	put	150.0000	2026-09-18	12.7000	12.3000	14.2000	137.3000	44450.00	3810.00	2540.00	35	7	35	151	0.231788079470199	0.433238020191618	0.433238020191618	false	false	false	true
46d5021e-cde2-449e-aec7-1b235c8deda5	2026-09-08 11:33	2026-09-08 11:33	2026-09-08 11:33	PTC	PTC260918P00130000	put	130.0000	2026-09-18	3.0000	2.2000	3.1000	133.9300	45000.00	35700.00	300.00	150	12	153	310	0.493548387096774	0.546611547947464	0.546611547947464	false	false	false	true
b9fc9c06-aefe-471e-b346-ccac11e0ecdb	2026-09-08 11:04	2026-09-08 11:04	2026-09-08 11:04	PTC	PTC260918P00140000	put	140.0000	2026-09-18	8.6000	8.5000	8.6000	134.0100	17198.00	17198.00	0.00	20	11	393	462	0.850649350649351	0.56968768764898	0.57091434517811	true	false	false	true
38bebdcc-a895-4351-b6aa-604a6e5e9ae1	2026-09-08 10:12	2026-09-08 10:11	2026-09-08 10:11	PTC	PTC260918P00140000	put	140.0000	2026-09-18	7.7000	7.1000	7.7000	135.3400	16930.00	16930.00	0.00	22	9	153	462	0.331168831168831	0.564822143629145	0.553087554142952	false	false	false	true
c3a6bcdd-6580-4ee0-87be-0fec29c757aa	2026-09-04 15:45	2026-09-04 15:44	2026-09-04 15:44	PTC	PTC260918P00140000	put	140.0000	2026-09-18	4.6000	3.3000	4.6000	141.5250	23460.00	23460.00	0.00	51	5	503	4	125.75	0.493497779413482	0.493497779413482	false	false	false	true
a9858334-5804-474c-b197-f0bc6c97ebb5	2026-09-04 14:01	2026-09-04 14:01	2026-09-04 14:01	PTC	PTC260918P00140000	put	140.0000	2026-09-18	4.0000	2.2500	4.0000	142.3850	19200.00	19200.00	0.00	48	20	362	4	90.5	0.471238802810168	0.471238802810168	false	false	false	true
1c8b31cf-5018-4827-a9eb-bfb639703c65	2026-09-04 13:23	2026-09-04 13:23	2026-09-04 13:23	PTC	PTC260918C00160000	call	160.0000	2026-09-18	0.8500	0.4500	1.0000	142.1600	12155.00	10455.00	1700.00	143	15	200	24	8.33333333333333	0.501645121727449	0.501645121727449	false	false	false	true
0fdeb267-2f2d-4e0d-b01e-eee1c21b4a55	2026-09-04 12:03	2026-09-04 12:02	2026-09-04 12:02	PTC	PTC260918P00140000	put	140.0000	2026-09-18	4.2000	3.2000	4.2000	141.6850	21000.00	21000.00	0.00	50	9	312	4	78	0.463003241671217	0.463003241671217	false	false	false	true
69025b79-ed1e-4856-bce1-4f76d33ae1c8	2026-09-04 10:25	2026-09-04 10:25	2026-09-04 10:25	PTC	PTC260918P00140000	put	140.0000	2026-09-18	4.1000	4.0000	4.4000	141.8800	39770.00	10250.00	410.00	97	5	262	4	65.5	0.461340300878475	0.461340300878475	false	false	false	true
2f4cd9d7-ddaf-4b80-9908-de459a99526e	2026-09-04 10:13	2026-09-04 10:12	2026-09-04 10:12	PTC	PTC260918P00140000	put	140.0000	2026-09-18	4.5000	4.4000	4.6000	141.1200	51300.00	49950.00	450.00	114	8	116	4	29	0.468134881894413	0.468134881894413	false	false	false	true
91134a72-5729-470a-8c12-4d115ab23841	2026-09-03 15:29	2026-09-03 15:29	2026-09-03 15:29	PTC	PTC260918P00145000	put	145.0000	2026-09-18	2.6500	1.8500	2.6500	150.2100	46103.00	45843.00	260.00	174	35	179	5	35.8	0.417571408273556	0.410628504864158	false	false	false	true
fae92200-eeef-47d5-894f-1498b71a060f	2026-09-02 14:04	2026-09-02 14:04	2026-09-02 14:04	PTC	PTC260918P00150000	put	150.0000	2026-09-18	5.0000	4.6000	5.2000	149.2800	25000.00	25000.00	0.00	50	9	84	1	84	0.383882568374273	0.381483897224749	false	false	false	true
9297a0a6-7cc2-4cef-833a-c2d483730e87	2026-08-31 13:41	2026-08-31 13:41	2026-08-31 13:41	PTC	PTC270416C00195000	call	195.0000	2027-04-16	8.4000	7.7000	9.1000	156.8800	24360.00	10920.00	10920.00	29	6	50	0	0	0.38526045828643	0.38526045828643	false	false	false	true
8a4845d3-5aad-4624-a89b-4c11304dfcd7	2026-08-31 13:39	2026-08-31 13:39	2026-08-31 13:39	PTC	PTC270416C00180000	call	180.0000	2027-04-16	12.7000	11.6000	13.4000	156.7700	63500.00	13970.00	11430.00	50	6	50	0	0	0.397180512422998	0.397180512422998	false	false	false	true