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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 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 = CNQ×

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

656a5a90-dcf0-4934-8eb2-1af63ccf382f	2026-09-29 15:46	2026-09-29 15:46	2026-09-29 15:46	CNQ	CNQ261009P00046000	put	46.0000	2026-10-09	0.5500	0.4500	0.5500	47.0450	20790.00	20790.00	0.00	378	6	4517	4006	1.12755866200699	0.327135209410426	0.327135209410426	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	98188034260.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T19:48:27.886669Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
bd9c466f-7bbc-4144-8409-d16c1e1a31d7	2026-09-29 14:25	2026-09-29 14:25	2026-09-29 14:25	CNQ	CNQ261016C00047500	call	47.5000	2026-10-16	1.1000	1.0500	1.1500	47.0000	33880.00	33770.00	110.00	308	21	318	599	0.530884808013356	0.301216882006009	0.301216882006009	false	false	false	true
9c339ad1-676f-4780-b190-2859280c3c2f	2026-09-29 13:48	2026-09-29 13:48	2026-09-29 13:48	CNQ	CNQ261016P00047000	put	47.0000	2026-10-16	1.1200	1.0000	1.2000	47.0450	11200.00	11200.00	0.00	100	6	124	167	0.74251497005988	0.293145094321557	0.293145094321557	false	false	false	true
6b5b3ff1-7989-4134-ba94-61aaa66e3e39	2026-09-29 13:37	2026-09-29 13:37	2026-09-29 13:37	CNQ	CNQ270115C00047500	call	47.5000	2027-01-15	3.1000	3.0000	3.2000	47.1250	17360.00	16120.00	0.00	56	10	65	456	0.142543859649123	0.292788879576851	0.292788879576851	false	false	false	true
3b1c2a75-6a11-4d9d-bb04-64f79964400d	2026-09-29 12:51	2026-09-29 12:51	2026-09-29 12:51	CNQ	CNQ270115C00050000	call	50.0000	2027-01-15	2.2000	2.1000	2.2000	47.3200	18040.00	18040.00	0.00	82	13	117	10038	0.011655708308428	0.297368280379157	0.297368280379157	false	false	false	true
68f06b36-ca58-413a-9af2-7b9bd7321444	2026-09-24 14:25	2026-09-24 14:25	2026-09-24 14:25	CNQ	CNQ270115C00050000	call	50.0000	2027-01-15	2.6000	2.5000	2.6000	48.0950	47060.00	47060.00	0.00	181	21	442	10187	0.0433886325709237	0.294717116859848	0.294717116859848	false	false	false	true
22fb7017-e360-438b-9d5d-14b8cd186404	2026-09-24 12:48	2026-09-24 12:48	2026-09-24 12:48	CNQ	CNQ270115C00050000	call	50.0000	2027-01-15	2.7000	2.6000	2.8500	48.1000	16740.00	7020.00	9720.00	62	9	138	10187	0.0135466771375282	0.303884717405726	0.303884717405726	false	false	false	true
b9bc9d89-800e-463c-a59e-a4e71192e3f8	2026-09-24 10:43	2026-09-24 10:43	2026-09-24 10:43	CNQ	CNQ270115P00050000	put	50.0000	2027-01-15	4.0000	3.8000	4.0000	48.4850	14000.00	14000.00	0.00	35	11	47	313	0.150159744408946	0.328062378473421	0.328062378473421	false	false	false	true
6bbbeaf9-83be-47cb-a37b-993251129007	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	CNQ	CNQ261016C00050000	call	50.0000	2026-10-16	0.7500	0.6500	0.7500	48.2400	12825.00	12825.00	0.00	171	24	171	687	0.248908296943231	0.296040707950744	0.296040707950744	false	false	false	true
2f3cb287-0d5a-4ec1-9b77-10787779fa94	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CNQ	CNQ261002P00047000	put	47.0000	2026-10-02	0.5500	0.4500	0.7000	48.0150	10780.00	10120.00	660.00	196	9	201	16	12.5625	0.342290152328372	0.333365101461538	false	false	false	true
e57650a2-5d7b-4172-aac4-24de1d74039d	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	CNQ	CNQ270115P00045000	put	45.0000	2027-01-15	2.0000	2.0000	2.1000	47.7624	157800.00	0.00	157800.00	789	38	801	1246	0.642857142857143	0.332206791408019	0.332206791408019	false	false	false	true
a5c343bb-6e3b-4872-b1f7-464f98aa4cf7	2026-09-15 12:18	2026-09-15 12:17	2026-09-15 12:17	CNQ	CNQ260918C00045000	call	45.0000	2026-09-18	5.7000	5.7000	6.5000	51.3200	85500.00	0.00	85500.00	150	6	153	277	0.552346570397112	1.03760533879961	1.03760533879961	false	false	false	true
32061b61-634c-44cf-98ec-7c6ff6e96af4	2026-09-15 11:22	2026-09-15 11:22	2026-09-15 11:22	CNQ	CNQ261016C00052500	call	52.5000	2026-10-16	1.5000	1.4000	1.5000	51.1950	72290.00	72290.00	0.00	482	35	487	1930	0.252331606217617	0.334564907349159	0.334564907349159	false	false	false	true
5c73bf13-d3b1-4f82-9733-9fb4a50339af	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	CNQ	CNQ260918P00055000	put	55.0000	2026-09-18	4.8000	3.6000	4.8000	50.3500	118080.00	118080.00	0.00	246	7	247	116	2.12931034482759	0.65821367824055	0.65821367824055	false	false	false	true
1a9684d4-8c90-40f6-a818-ec617bc0425b	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	CNQ	CNQ261016C00045000	call	45.0000	2026-10-16	5.7000	5.7000	7.0000	50.3500	82650.00	0.00	82650.00	145	8	145	21	6.90476190476191	0.300147148265989	0.300147148265989	false	false	false	true
79ba5bbe-80f1-489b-bfd7-bd81474d26f8	2026-09-11 09:38	2026-09-11 09:38	2026-09-11 09:38	CNQ	CNQ261016C00047500	call	47.5000	2026-10-16	3.4000	3.3000	3.6000	49.7600	64600.00	0.00	60520.00	190	10	191	399	0.478696741854637	0.323581342396718	0.323581342396718	true	false	false	true
39ff6b6b-be2f-47c3-9cde-945fa04ed96d	2026-08-17 13:12	2026-08-17 13:12	2026-08-17 13:12	CNQ	CNQ270115C00050000	call	50.0000	2027-01-15	3.2000	2.9000	3.2000	48.8300	69090.00	69090.00	0.00	216	8	427	7654	0.0557878233603345	0.26884759314887	0.26884759314887	false	false	false	true