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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = PH×

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

6d56a46f-4da2-4f72-85b9-8277bea8aa77	2026-09-30 15:46	2026-09-30 15:46	2026-09-30 15:46	PH	PH261120C01060000	call	1060.0000	2026-11-20	15.4000	12.6000	15.4000	959.5050	126279.00	126279.00	0.00	82	24	83	85	0.976470588235294	0.324900452677607	0.324900452677607	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	122312682494.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T19:46:40.965849Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
08f1f07c-7077-4eac-8c6f-b82fa24d8da9	2026-09-30 15:46	2026-09-30 15:46	2026-09-30 15:46	PH	PH261120C01060000	call	1060.0000	2026-11-20	15.3000	12.6000	15.3000	959.5200	88740.00	88740.00	0.00	58	15	148	85	1.74117647058824	0.323967477888531	0.323967477888531	true	false	false
b907ecf0-768d-4989-9946-4031ed78d676	2026-09-25 13:10	2026-09-25 13:10	2026-09-25 13:10	PH	PH261016C00980000	call	980.0000	2026-10-16	23.5000	21.9000	23.5000	976.2500	230300.00	230300.00	0.00	98	28	98	24	4.08333333333333	0.25930446144754	0.25930446144754	false	false	false
741e0687-ea0a-4d3b-bc54-2a4f01f68ce8	2026-09-23 15:06	2026-09-23 15:06	2026-09-23 15:06	PH	PH270521C01050000	call	1050.0000	2027-05-21	68.5000	68.0000	68.6000	975.0700	609650.00	335650.00	0.00	89	7	89	7	12.7142857142857	0.276778829627789	0.276778829627789	false	false	false
d002a2dd-9622-427b-9a1e-ba51665ae892	2026-09-22 11:23	2026-09-22 11:22	2026-09-22 11:22	PH	PH261120C01080000	call	1080.0000	2026-11-20	9.9500	9.7000	13.5000	957.0000	253730.00	0.00	253730.00	255	2	255	75	3.4	0.287556597029865	0.287556597029865	false	true	false
dd6639ea-853c-4c4a-9b0b-2f60a0031658	2026-09-21 14:52	2026-09-21 14:52	2026-09-21 14:52	PH	PH261016C00970000	call	970.0000	2026-10-16	23.7000	21.1000	25.0000	962.9450	35550.00	11850.00	14220.00	15	7	22	26	0.846153846153846	0.253324569224759	0.256577036124133	false	false	false
9aefa5b3-6893-4748-b937-a8e436947a0e	2026-09-17 14:13	2026-09-17 14:13	2026-09-17 14:13	PH	PH261016P00890000	put	890.0000	2026-10-16	11.1000	11.1000	13.5000	926.9150	54390.00	0.00	54390.00	49	15	54	6	9	0.25821437233183	0.25821437233183	false	false	false
57fc659b-e97a-4f76-879a-320bef69d5b8	2026-09-02 10:16	2026-09-02 10:16	2026-09-02 10:16	PH	PH260918P00990000	put	990.0000	2026-09-18	40.6000	39.0000	40.6000	955.2600	56840.00	8120.00	0.00	14	12	30	307	0.0977198697068404	0.244363478889988	0.244363478889988	false	false	false
d0d9aa92-8513-4e2f-a834-f42d8e1ec146	2026-09-02 10:16	2026-09-02 10:16	2026-09-02 10:16	PH	PH260918P00990000	put	990.0000	2026-09-18	41.8000	39.5000	41.8000	955.3100	58520.00	58520.00	0.00	14	14	14	307	0.0456026058631922	0.263075277720326	0.263075277720326	false	false	false
cb94222b-c122-408a-b803-ecdd521dac99	2026-09-01 12:28	2026-09-01 12:27	2026-09-01 12:27	PH	PH261120C00990000	call	990.0000	2026-11-20	42.4800	41.7000	46.0000	955.7325	437510.00	433260.00	4250.00	103	20	103	7	14.7142857142857	0.301173609207201	0.301173609207201	false	false	false
156af34d-ece7-4572-9812-4d199c967154	2026-08-31 11:47	2026-08-31 11:47	2026-08-31 11:47	PH	PH270219C01120000	call	1120.0000	2027-02-19	30.5000	30.5000	35.3000	977.4300	51850.00	0.00	51850.00	17	9	64	46	1.39130434782609	0.269327981513228	0.269327981513228	false	false	false
205496d9-3ec7-4c6b-ab91-dcf3a12cd6a3	2026-08-27 10:03	2026-08-27 10:03	2026-08-27 10:03	PH	PH261016P00990000	put	990.0000	2026-10-16	23.9000	19.9000	23.9000	1021.6900	81260.00	81260.00	0.00	34	14	34	1	34	0.267601220609177	0.267601220609177	false	false	false
367bf01c-1193-4cb8-9510-79485a2c94cf	2026-08-25 09:32	2026-08-25 09:32	2026-08-25 09:32	PH	PH260918P01120000	put	1120.0000	2026-09-18	101.0000	91.0000	101.0000	1023.5100	50500.00	50500.00	0.00	5	5	5	0	0	0.333956262541755	0.333956262541755	false	false	false