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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = FloorTradeLargeCap×ticker = CCJ×

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

3638c156-f543-403c-b23d-04456dc3a501	2026-09-04 15:58	2026-09-04 15:58	2026-09-04 15:58	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	3.2300	3.1000	3.2500	100.8050	1990003.00	1990003.00	0.00	6161	2	15324	5589	2.74181427804616	0.47166723587977	0.47166723587977	false	true	true	false	false	FloorTradeLargeCap	85cc2f90-fef8-4e3c-8c5c-01d1ead51af1	2	Common Stock	Energy	40610811028.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
15949357-60c5-4907-bb77-b4f4d5017b93	2026-09-01 15:29	2026-09-01 15:29	2026-09-01 15:29	CCJ	CCJ270617P00085000	put	85.0000	2027-06-17	9.2000	8.8500	10.0000	96.5500	230000.00	0.00	230000.00	250	1	250	126	1.98412698412698	0.486931004570565	0.486931004570565	false	true	false	true
303c906d-1990-4d10-8783-31e301fe8a7d	2026-08-28 10:10	2026-08-28 10:09	2026-08-28 10:09	CCJ	CCJ261016C00125000	call	125.0000	2026-10-16	1.3600	1.2300	1.4200	102.2680	139672.00	139672.00	0.00	1027	1	1028	1532	0.671018276762402	0.483922445172878	0.483922445172878	false	true	false	true
c4c3d807-49bb-4e8d-9afa-308a1cfff7d8	2026-08-21 15:54	2026-08-21 15:54	2026-08-21 15:54	CCJ	CCJ260918C00125000	call	125.0000	2026-09-18	0.6400	0.4000	0.7600	102.6200	96000.00	96000.00	0.00	1500	1	1523	1584	0.961489898989899	0.514845313962971	0.514845313962971	false	true	false	true
d83a85cd-9add-4285-9ac4-9aabee869d8d	2026-08-21 10:32	2026-08-21 10:32	2026-08-21 10:32	CCJ	CCJ270115C00100000	call	100.0000	2027-01-15	13.4000	13.0000	14.7000	100.2800	1340000.00	0.00	1340000.00	1000	2	1004	1257	0.798727128082737	0.497059177477769	0.497059177477769	false	true	true	false
f3df78c9-12f8-42b3-b9d8-61d7d808e534	2026-08-18 12:55	2026-08-18 12:55	2026-08-18 12:55	CCJ	CCJ260821P00080000	put	80.0000	2026-08-21	0.0100	0.0000	0.1800	95.8750	2257.00	0.00	2257.00	1505	2	17306	36619	0.472596193233021	0.778755291573971	0.778755291573971	false	true	false	true