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:endpoint = /api/option-trades/flow-alerts×er_time = unknown×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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	99166375920.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T18:26:21.590036Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
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
59adfca5-43f1-4d4b-a2e3-0269195b2840	2026-09-24 12:29	2026-09-24 12:28	2026-09-24 12:28	CNQ	CNQ261009P00046000	put	46.0000	2026-10-09	0.5300	0.3500	0.5500	48.1700	211883.00	211794.00	44.00	4000	6	4000	5	800	0.330269991821448	0.330269991821448	false	false	false
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
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
cc82a9ce-2717-455c-a9b7-8a65e6538935	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CNQ	CNQ260925P00048500	put	48.5000	2026-09-25	0.9500	0.6500	1.1000	48.0900	96398.00	89298.00	7100.00	1017	46	1017	11	92.4545454545455	0.514057136907188	0.514057136907188	false	false	false
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
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
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
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
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
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
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
6fecdca9-5da3-4268-8d69-10dce4fd62ac	2026-08-31 11:02	2026-08-31 11:02	2026-08-31 11:02	CNQ	CNQ270115C00050000	call	50.0000	2027-01-15	3.2200	3.2000	3.3000	49.6900	805004.00	0.00	805004.00	2500	5	2520	7659	0.329024676850764	0.249642717614715	0.249642717614715	false	false	false
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