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:alert_rule = RepeatedHitsDescendingFill×endpoint = /api/option-trades/flow-alerts×ticker = BHP×

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

ea788a96-3046-4935-a3cd-c2a5d30f62dc	2026-10-01 11:02	2026-10-01 11:02	2026-10-01 11:02	BHP	BHP261120C00085000	call	85.0000	2026-11-20	3.9000	3.6000	4.0000	83.5300	420940.00	391150.00	29790.00	1080	32	1080	109	9.90825688073394	0.359688744016991	0.352956435029555	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ADR	Basic Materials	215069903956.00	2026-11-17	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T15:03:17.920227Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
9f656f54-7735-499f-af96-b0808392b396	2026-10-01 11:02	2026-10-01 11:02	2026-10-01 11:02	BHP	BHP261120C00082500	call	82.5000	2026-11-20	5.1000	4.9000	5.1000	83.3600	439607.00	439607.00	0.00	862	45	862	317	2.7192429022082	0.360929135829925	0.360929135829925	false	false
45d8aaaa-5abc-405c-a38f-c84f6e5aad14	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	BHP	BHP261218C00087500	call	87.5000	2026-12-18	5.0000	4.7000	5.2000	85.0000	378980.00	362480.00	16500.00	758	42	758	1574	0.481575603557814	0.344470912334029	0.344470912334029	false	false
d6d43ab3-d880-48ca-b7fc-22d8f8a1c788	2026-09-25 12:34	2026-09-25 12:34	2026-09-25 12:34	BHP	BHP261218P00085000	put	85.0000	2026-12-18	5.1000	4.8000	5.1000	85.0500	21920.00	21920.00	0.00	43	9	783	440	1.77954545454545	0.341677007401176	0.341677007401176	false	false
f0366dc9-1239-45a9-8421-94d33c963057	2026-09-25 09:30	2026-09-25 09:30	2026-09-25 09:30	BHP	BHP261218C00090000	call	90.0000	2026-12-18	3.7400	3.5000	3.9000	84.4500	35900.00	4850.00	5960.00	96	39	239	614	0.389250814332248	0.352268945823687	0.345903819673781	true	false
3c557672-250c-4692-b7db-41befe114317	2026-09-25 09:30	2026-09-25 09:30	2026-09-25 09:30	BHP	BHP261218C00090000	call	90.0000	2026-12-18	3.6800	3.5000	3.7000	84.4600	23950.00	20350.00	2160.00	65	24	135	614	0.219869706840391	0.345646119738005	0.339270821510691	false	false
52075985-9611-4590-a616-4f4ecd6bae33	2026-09-23 14:03	2026-09-23 14:03	2026-09-23 14:03	BHP	BHP270115P00085000	put	85.0000	2027-01-15	5.8000	5.4000	5.8000	85.3408	1198247.00	1198247.00	0.00	2066	51	2092	255	8.20392156862745	0.34543194261992	0.34543194261992	false	false
036f9310-9dfb-4ff9-9af3-0575cc71970d	2026-08-19 09:47	2026-08-19 09:47	2026-08-19 09:47	BHP	BHP260918P00090000	put	90.0000	2026-09-18	3.3000	3.1000	3.3000	92.3600	50808.00	50808.00	0.00	154	20	154	2003	0.0768846729905142	0.432177570176847	0.432177570176847	false	false
8ccbc5d7-5b88-4bf8-9051-637060b75341	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	BHP	BHP261218P00085000	put	85.0000	2026-12-18	5.3000	5.0000	5.3000	89.0000	86910.00	86910.00	0.00	164	21	164	87	1.88505747126437	0.395735391177357	0.395735391177357	false	false