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

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

23fabb1a-bf7f-4b17-8b60-1c5ae642b1c2	2026-09-21 15:33	2026-09-21 15:33	2026-09-21 15:33	SJM	SJM270115P00120000	put	120.0000	2027-01-15	7.1300	7.1000	7.4000	119.0000	52018.00	12958.00	39060.00	73	19	94	150	0.626666666666667	0.297606122524377	0.297606122524377	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Defensive	12805963178.00	2026-11-24	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
c12f5633-298a-4738-894a-955c80b73711	2026-09-21 15:33	2026-09-21 15:33	2026-09-21 15:33	SJM	SJM270115P00115000	put	115.0000	2027-01-15	4.9000	4.8000	5.0000	119.0000	12250.00	7350.00	0.00	25	7	102	172	0.593023255813954	0.294662082874324	0.294662082874324	false	false	false	true
19a1b553-3031-4185-8c81-5b439b920041	2026-09-21 14:15	2026-09-21 14:15	2026-09-21 14:15	SJM	SJM270115P00115000	put	115.0000	2027-01-15	4.6000	4.5000	4.6000	120.8800	26680.00	26680.00	0.00	58	21	76	172	0.441860465116279	0.294582256375997	0.294582256375997	false	false	false	true
b921773a-d031-4722-82dc-be011560bc6c	2026-09-09 11:04	2026-09-09 11:04	2026-09-09 11:04	SJM	SJM270115C00120000	call	120.0000	2027-01-15	11.0000	10.5000	11.3000	124.6100	40689.00	40689.00	0.00	37	10	142	250	0.568	0.261466032939572	0.261466032939572	false	false	false	true
c525aaa0-90fb-4354-8fa8-b88c2792461f	2026-09-09 11:01	2026-09-09 11:01	2026-09-09 11:01	SJM	SJM260918C00115000	call	115.0000	2026-09-18	10.0000	9.7000	10.0000	124.6100	46000.00	46000.00	0.00	46	9	710	1396	0.508595988538682	0.378929942591666	0.378929942591666	false	false	false	true
71df9b62-b57c-485b-b742-45681678a803	2026-09-03 12:01	2026-09-03 12:01	2026-09-03 12:01	SJM	SJM260918P00130000	put	130.0000	2026-09-18	3.3000	3.3000	3.6000	128.2100	19470.00	0.00	19470.00	59	14	92	947	0.0971488912354805	0.232479887094824	0.232479887094824	false	false	false	true
aa25c94f-cd50-418f-badc-fd662eaa2de5	2026-09-02 13:00	2026-09-02 13:00	2026-09-02 13:00	SJM	SJM270416P00130000	put	130.0000	2027-04-16	9.8900	9.3000	10.0000	132.2800	29680.00	27700.00	1980.00	30	14	59	2286	0.0258092738407699	0.308373624888529	0.308373624888529	false	false	false	true
f0844863-ec3a-4c90-8f98-f0f13170b3b8	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	SJM	SJM261016C00140000	call	140.0000	2026-10-16	2.2000	2.0000	2.5000	132.5900	14520.00	0.00	10560.00	66	6	90	98	0.918367346938776	0.2430597783094	0.2430597783094	false	false	false	true
c2afc814-3a68-4050-b90d-d1be583968ec	2026-08-27 13:21	2026-08-27 13:21	2026-08-27 13:21	SJM	SJM270416C00150000	call	150.0000	2027-04-16	6.4900	5.8000	6.5000	133.8600	46740.00	45480.00	1260.00	72	14	78	11	7.09090909090909	0.262216408927653	0.259744006537255	false	false	false	true
6940f124-5fe0-45dc-be8b-4b5e6a5fb44e	2026-08-26 10:02	2026-08-26 10:02	2026-08-26 10:02	SJM	SJM260918P00130000	put	130.0000	2026-09-18	3.4000	3.0000	3.6000	130.4600	308020.00	307680.00	340.00	906	44	908	5	181.6	0.289674514708133	0.289674514708133	false	false	false	true
77d14041-e35c-4264-ba0c-9ba825aa177d	2026-08-25 15:46	2026-08-25 15:46	2026-08-25 15:46	SJM	SJM261016P00110000	put	110.0000	2026-10-16	1.0500	1.0500	1.1500	124.8000	13650.00	0.00	13650.00	130	31	133	124	1.07258064516129	0.326451187303619	0.326451187303619	false	false	false	true
3344ec3c-c874-4cc4-bd83-532bb5ef4145	2026-08-25 15:27	2026-08-25 15:27	2026-08-25 15:27	SJM	SJM260918C00130000	call	130.0000	2026-09-18	2.6000	2.2000	2.6000	124.7300	10920.00	10920.00	0.00	42	15	624	413	1.51089588377724	0.358411746256528	0.358411746256528	true	false	false	true
e3d6ac57-202c-4a3b-9349-3afb09b69e94	2026-08-25 14:34	2026-08-25 14:34	2026-08-25 14:34	SJM	SJM260918C00130000	call	130.0000	2026-09-18	2.6000	2.5000	2.6500	124.8750	16120.00	13260.00	1560.00	62	17	402	413	0.973365617433414	0.354096606126478	0.354096606126478	true	false	false	true
a591f673-a67e-4c78-b337-b4cadae9a70f	2026-08-24 10:02	2026-08-24 10:02	2026-08-24 10:02	SJM	SJM270416P00135000	put	135.0000	2027-04-16	16.6700	15.2000	17.9000	125.6150	3810762.00	3810762.00	0.00	2286	2	2286	0	0	0.32900119952038	0.32900119952038	false	true	true	false
9ec0a105-fc58-46ba-9b80-f7f2c178b401	2026-08-19 09:46	2026-08-19 09:45	2026-08-19 09:45	SJM	SJM260821C00120000	call	120.0000	2026-08-21	2.5000	2.2500	2.9000	122.2200	29750.00	15000.00	14750.00	119	6	373	887	0.420518602029312	0.280208639078575	0.280208639078575	false	false	false	true