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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = PH×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

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	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	117076670631.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T13:41:46.514863Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true