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:alert_rule = RepeatedHits×source = uw_flow_alerts×ticker = ROK×

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

92440c99-8064-42f4-af25-b163c9de6a04	2026-09-25 12:13	2026-09-25 12:13	2026-09-25 12:13	ROK	ROK261016P00470000	put	470.0000	2026-10-16	32.9000	32.9000	36.0000	437.0000	141471.00	0.00	141471.00	43	17	43	16	2.6875	0.241434480096866	0.241434480096866	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	48211782685.00	2026-11-05	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T16:14:10.282260Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
857d6e87-d2a0-400e-a347-5a1a504c6d90	2026-09-25 12:13	2026-09-25 12:13	2026-09-25 12:13	ROK	ROK261016C00400000	call	400.0000	2026-10-16	40.3800	37.4000	40.3000	437.0000	40380.00	40380.00	0.00	10	6	10	10	1	0.328807775196927	0.323820541022022	true	false	false	true
fd93a844-1d74-4be1-b4ad-56d76602e58f	2026-09-25 12:13	2026-09-25 12:13	2026-09-25 12:13	ROK	ROK261016C00460000	call	460.0000	2026-10-16	3.5000	3.0000	3.6000	437.0000	10850.00	10150.00	350.00	31	15	104	43	2.41860465116279	0.261806685365149	0.261806685365149	false	false	false	true
6c2ffdb4-1d4b-41e9-bcb5-9d27992b1a6e	2026-09-23 11:21	2026-09-23 11:21	2026-09-23 11:21	ROK	ROK261016P00420000	put	420.0000	2026-10-16	5.7000	5.1000	5.7000	434.2250	30780.00	30780.00	0.00	54	20	63	528	0.119318181818182	0.276241751925899	0.276241751925899	false	false	false	true
bfdff60c-29d0-42f2-bc4d-c58a47feec16	2026-09-21 13:04	2026-09-21 13:03	2026-09-21 13:03	ROK	ROK261016C00430000	call	430.0000	2026-10-16	9.3000	9.2000	9.3000	422.5400	41850.00	41850.00	0.00	45	14	53	20	2.65	0.274303337773739	0.274303337773739	false	false	false	true
8ad1b270-f364-46f3-bc0b-af0afb19edd4	2026-09-17 10:05	2026-09-17 10:05	2026-09-17 10:05	ROK	ROK261016P00410000	put	410.0000	2026-10-16	8.8900	7.7000	8.9000	417.9850	44450.00	40050.00	0.00	50	16	50	34	1.47058823529412	0.280071924327016	0.280071924327016	false	false	false	true
e4690605-c5eb-472f-b573-06bd05316a84	2026-09-16 12:27	2026-09-16 12:27	2026-09-16 12:27	ROK	ROK260918P00420000	put	420.0000	2026-09-18	3.1000	2.2500	3.1000	423.2800	17980.00	17980.00	0.00	58	15	59	309	0.190938511326861	0.368656320302879	0.368656320302879	false	false	false	true
4400b3b1-0f17-4c04-b8ef-d705c40efefd	2026-09-15 11:02	2026-09-15 11:02	2026-09-15 11:02	ROK	ROK261016P00380000	put	380.0000	2026-10-16	2.4500	1.8000	2.4500	415.0000	11515.00	11515.00	0.00	47	17	52	100	0.52	0.295580714041921	0.295580714041921	false	false	false	true
427ca54d-c767-42d5-9c71-2a47574f3d31	2026-09-03 11:28	2026-09-03 11:28	2026-09-03 11:28	ROK	ROK261016C00390000	call	390.0000	2026-10-16	43.8000	40.5000	43.8000	427.4500	78840.00	78840.00	0.00	18	6	18	3	6	0.318491588061342	0.318491588061342	false	false	false	true
f94fe0b1-d13a-47e9-94ba-93b27311325e	2026-09-02 11:56	2026-09-02 11:56	2026-09-02 11:56	ROK	ROK261120C00470000	call	470.0000	2026-11-20	10.0000	9.5000	12.2000	424.8800	25000.00	1000.00	3000.00	25	18	25	29	0.862068965517241	0.308404852390598	0.308404852390598	false	false	false	true
24c9d7a3-219e-4f7e-95cb-667a2b2c802f	2026-08-28 11:03	2026-08-28 11:03	2026-08-28 11:03	ROK	ROK270219P00360000	put	360.0000	2027-02-19	11.4000	11.4000	12.5000	429.7400	12540.00	0.00	12540.00	11	5	58	3	19.3333333333333	0.353481327023693	0.353481327023693	false	false	false	true
c2a1303c-6f34-462c-b12b-1478a4b34b52	2026-08-28 11:03	2026-08-28 11:03	2026-08-28 11:03	ROK	ROK270219P00390000	put	390.0000	2027-02-19	19.7000	19.7000	21.1000	429.9350	27580.00	0.00	27580.00	14	7	39	19	2.05263157894737	0.347199636069324	0.347199636069324	false	false	false	true
a9cde953-c7bc-4c38-9305-6dfa433b2c82	2026-08-28 11:03	2026-08-28 11:03	2026-08-28 11:03	ROK	ROK270219P00390000	put	390.0000	2027-02-19	19.7000	19.7000	20.9000	429.6000	21670.00	0.00	21670.00	11	5	23	19	1.21052631578947	0.346274909906238	0.346274909906238	false	false	false	true
7b399100-f5be-4d75-a31c-4fc0ce3b2fb8	2026-08-28 11:03	2026-08-28 11:03	2026-08-28 11:03	ROK	ROK270219P00360000	put	360.0000	2027-02-19	11.4000	11.4000	12.5000	429.6000	18240.00	0.00	18240.00	16	8	47	3	15.6666666666667	0.353159805619517	0.353159805619517	false	false	false	true
9d0deddf-81b3-475a-9260-62b63a605927	2026-08-27 09:55	2026-08-27 09:55	2026-08-27 09:55	ROK	ROK260918P00490000	put	490.0000	2026-09-18	55.4000	55.4000	59.9000	432.8850	55400.00	0.00	55400.00	10	8	10	0	0	0.466910145517821	0.466910145517821	false	false	false	true
7dd910bd-26e2-42fd-96e9-7d49e804b873	2026-08-26 11:50	2026-08-26 11:49	2026-08-26 11:49	ROK	ROK261120P00390000	put	390.0000	2026-11-20	11.4000	11.3000	13.0000	431.0100	11400.00	3420.00	7980.00	10	5	10	28	0.357142857142857	0.357855586379647	0.357855586379647	false	false	false	true
479b1d25-dce9-4d17-867c-985bfd1a62b6	2026-08-25 12:43	2026-08-25 12:43	2026-08-25 12:43	ROK	ROK270219P00400000	put	400.0000	2027-02-19	23.7000	23.0000	25.7000	432.8900	54510.00	23700.00	30810.00	23	5	23	21	1.0952380952381	0.356183606319772	0.356183606319772	false	false	false	true
77e57704-431b-4334-b950-44b8b5c09827	2026-08-20 13:02	2026-08-20 13:02	2026-08-20 13:02	ROK	ROK261120C00480000	call	480.0000	2026-11-20	14.5000	14.5000	17.2000	434.3200	42050.00	0.00	42050.00	29	13	29	44	0.659090909090909	0.338215471989321	0.338215471989321	false	false	false	true
24c403c0-8aee-46f5-850d-7a0e967c16cb	2026-08-19 11:54	2026-08-19 11:54	2026-08-19 11:54	ROK	ROK261120C00460000	call	460.0000	2026-11-20	20.9000	20.9000	24.0000	433.4400	119130.00	0.00	119130.00	57	21	58	41	1.41463414634146	0.343126120805846	0.343126120805846	false	false	false
420fa3dc-8ec0-45a3-abfb-8bf6de73c5d3	2026-08-19 09:43	2026-08-19 09:43	2026-08-19 09:43	ROK	ROK261016P00430000	put	430.0000	2026-10-16	14.4000	14.4000	16.3000	439.2550	63360.00	0.00	63360.00	44	14	44	9	4.88888888888889	0.286994585223747	0.286994585223747	false	false	false	true
550624d2-0405-4068-a858-06a7e1e316f1	2026-08-17 15:15	2026-08-17 15:15	2026-08-17 15:15	ROK	ROK260918P00420000	put	420.0000	2026-09-18	5.1000	5.1000	5.8000	445.2800	25506.00	0.00	25506.00	50	17	55	37	1.48648648648649	0.289475974376425	0.289475974376425	false	false	false	true