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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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 = APO×

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

8d97a435-b827-45d8-8965-ec864bc47c39	2026-09-24 14:52	2026-09-24 14:52	2026-09-24 14:52	APO	APO270115C00125000	call	125.0000	2027-01-15	7.7000	7.3000	7.7000	119.7400	140140.00	140140.00	0.00	182	11	311	743	0.4185733512786	0.348742766860338	0.348742766860338	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	73439947253.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T18:57:49.526864Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
11f93041-f4aa-40b3-a12c-60d9e6184d11	2026-09-24 13:17	2026-09-24 13:17	2026-09-24 13:17	APO	APO270917P00100000	put	100.0000	2027-09-17	7.5000	7.5000	8.0000	120.0500	18000.00	0.00	18000.00	24	7	66	5	13.2	0.402540657816329	0.402540657816329	false	false	false	true
1aee02be-c9aa-43ec-8ca7-4ea83eae3044	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	APO	APO261016P00116000	put	116.0000	2026-10-16	2.4000	2.1500	2.4000	120.0000	18480.00	18480.00	0.00	77	8	77	0	0	0.371357699444062	0.371357699444062	false	false	false	true
8b879f1c-91ab-4686-b94a-40d532ddfc36	2026-09-24 10:15	2026-09-24 10:14	2026-09-24 10:14	APO	APO261120P00120000	put	120.0000	2026-11-20	7.0000	6.6000	7.0000	120.5300	36400.00	36400.00	0.00	52	11	98	142	0.690140845070423	0.404165667043247	0.404165667043247	false	false	false	true
21159ccd-7262-4ba0-b4ba-c8bc1a1c7832	2026-09-24 09:43	2026-09-24 09:43	2026-09-24 09:43	APO	APO261002P00122000	put	122.0000	2026-10-02	3.1000	3.1000	3.5000	121.1900	31000.00	0.00	31000.00	100	6	1242	17	73.0588235294118	0.380901912397617	0.380901912397617	false	false	false	true
e218831d-8b53-4789-b756-71883f063c3a	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	APO	APO261002P00122000	put	122.0000	2026-10-02	3.1000	3.1000	3.3000	121.5400	56420.00	0.00	56420.00	182	6	1050	17	61.7647058823529	0.406235644838823	0.406235644838823	false	false	false	true
e593f400-d227-4354-b39c-5588ebe18c44	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	APO	APO261002P00122000	put	122.0000	2026-10-02	3.1000	2.7500	3.2000	121.5400	15810.00	3410.00	12400.00	51	11	726	17	42.7058823529412	0.406235644838823	0.406235644838823	false	false	false	true
43aeadde-062a-404e-8429-435fab9dc857	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	APO	APO261002P00122000	put	122.0000	2026-10-02	3.1000	2.7500	3.2000	121.3900	18600.00	18290.00	310.00	60	12	807	17	47.4705882352941	0.395528594188121	0.395528594188121	false	false	false	true
4dfcf345-5fcf-41c7-aadb-cd14989827a9	2026-09-24 09:42	2026-09-24 09:41	2026-09-24 09:41	APO	APO261002P00122000	put	122.0000	2026-10-02	3.1000	2.7000	3.2000	121.5400	57660.00	12090.00	45570.00	186	5	675	17	39.7058823529412	0.406235644838823	0.406235644838823	false	false	false	true
f2c0ae39-8fe2-48b1-b63a-6f5c49cd1f3f	2026-09-24 09:42	2026-09-24 09:41	2026-09-24 09:41	APO	APO261002P00122000	put	122.0000	2026-10-02	2.9000	2.3000	3.0000	121.8100	38570.00	6380.00	32190.00	133	6	262	17	15.4117647058824	0.397195454339494	0.397195454339494	false	false	false	true
224de029-0b4c-4039-b014-dbffcc998f1f	2026-09-24 09:42	2026-09-24 09:41	2026-09-24 09:41	APO	APO261002P00122000	put	122.0000	2026-10-02	2.9000	2.3000	3.0000	121.6900	44660.00	9860.00	34800.00	154	7	416	17	24.4705882352941	0.397195454339494	0.38890988991514	false	false	false	true
91c56008-40f6-4a1e-93c8-9f2e7046f3cc	2026-09-23 11:48	2026-09-23 11:48	2026-09-23 11:48	APO	APO261120C00145000	call	145.0000	2026-11-20	1.4600	1.3000	1.6000	124.0000	18250.00	3750.00	0.00	125	2	135	994	0.135814889336016	0.355119357788254	0.355119357788254	false	true	false	true
ac3c41f3-f84c-4087-9b73-8361416b13d6	2026-09-23 11:29	2026-09-23 11:29	2026-09-23 11:29	APO	APO261218P00120000	put	120.0000	2026-12-18	6.4000	6.3000	6.4000	123.0000	64000.00	64000.00	0.00	100	20	101	1834	0.0550708833151581	0.370455106616823	0.370455106616823	true	false	false	true
d203f5c8-527e-451f-9023-c4b500a5c4e1	2026-09-23 11:05	2026-09-23 11:04	2026-09-23 11:04	APO	APO270917P00135000	put	135.0000	2027-09-17	22.1000	21.2000	22.1000	123.5950	22100.00	22100.00	0.00	10	8	10	40	0.25	0.385113620492036	0.385113620492036	false	false	false	true
79b609e5-8ceb-4b6b-b832-84b5fe89baad	2026-09-22 12:30	2026-09-22 12:30	2026-09-22 12:30	APO	APO261016P00127000	put	127.0000	2026-10-16	4.6000	4.4000	4.8000	126.2400	24380.00	8740.00	15640.00	53	6	53	45	1.17777777777778	0.338830309040725	0.338830309040725	false	false	false	true
6bdf88c5-32ad-485a-88a8-3a4e3c68a6d4	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	APO	APO270319P00130000	put	130.0000	2027-03-19	13.2000	12.8000	13.3000	127.7700	95040.00	1320.00	93720.00	72	13	81	248	0.326612903225806	0.377748508725046	0.377748508725046	true	false	false	true
2f49c881-81e2-437e-b2c1-d8232e860b1e	2026-09-21 14:12	2026-09-21 14:12	2026-09-21 14:12	APO	APO261016P00130000	put	130.0000	2026-10-16	5.6000	5.4000	5.7000	127.6950	19600.00	6160.00	13440.00	35	7	35	1373	0.0254916241806264	0.339372603488254	0.339372603488254	true	false	false	true
23d5096b-33a5-478a-a65c-1cbcbdc2783d	2026-09-21 10:49	2026-09-21 10:49	2026-09-21 10:49	APO	APO261016P00127000	put	127.0000	2026-10-16	4.6000	4.3000	4.6000	126.7400	19320.00	19320.00	0.00	42	5	44	0	0	0.351062915607811	0.351062915607811	true	false	false	true
242a7964-0495-4224-86c2-d716f6ffe3de	2026-09-21 10:47	2026-09-21 10:47	2026-09-21 10:47	APO	APO261016C00128000	call	128.0000	2026-10-16	4.3000	3.6000	4.3000	126.9700	17200.00	17200.00	0.00	40	5	40	0	0	0.348685330171843	0.348685330171843	false	false	false	true
008e0f5c-0ea0-4544-8e8b-2621e990d42f	2026-09-18 11:51	2026-09-18 11:51	2026-09-18 11:51	APO	APO261016P00125000	put	125.0000	2026-10-16	4.0600	3.8000	4.2000	126.3900	203000.00	123000.00	0.00	500	2	504	10483	0.0480778403128875	0.355985636025347	0.355985636025347	false	true	false	true
1ef1197b-621e-4e28-8111-7ee53f7fc4d3	2026-09-18 11:45	2026-09-18 11:45	2026-09-18 11:45	APO	APO270617C00145000	call	145.0000	2027-06-17	9.7000	9.7000	9.8000	126.0550	116400.00	0.00	116400.00	120	6	388	929	0.417653390742734	0.346533913309042	0.346533913309042	false	false	false	true
eeb3fe69-4c71-40f5-813a-7f7685c6dfbf	2026-09-18 11:44	2026-09-18 11:44	2026-09-18 11:44	APO	APO270617C00145000	call	145.0000	2027-06-17	9.7000	9.3000	9.8000	125.9800	138710.00	99910.00	38800.00	143	15	143	929	0.153928955866523	0.347270689264478	0.347270689264478	true	false	false	true
f6284200-df24-4eb4-9ea0-8ab821940dd4	2026-09-15 14:12	2026-09-15 14:12	2026-09-15 14:12	APO	APO280121C00180000	call	180.0000	2028-01-21	7.6000	7.4000	8.5000	127.7000	76000.00	0.00	76000.00	100	7	100	673	0.148588410104012	0.339207213437215	0.339207213437215	false	true	false	true
ccaa3b2a-5d85-47f0-874f-921badb0f050	2026-09-09 14:55	2026-09-09 14:54	2026-09-09 14:54	APO	APO261016C00140000	call	140.0000	2026-10-16	2.5600	2.5500	2.8000	130.6150	117248.00	0.00	0.00	458	8	461	693	0.665223665223665	0.348046195398137	0.348046195398137	false	false	false	true
a1377f92-4f21-40a5-bd06-2fe9dbcbcb9a	2026-09-09 14:55	2026-09-09 14:54	2026-09-09 14:54	APO	APO261120C00145000	call	145.0000	2026-11-20	3.7400	3.7000	4.0000	130.6150	171292.00	0.00	0.00	458	8	465	606	0.767326732673267	0.363871738603951	0.363871738603951	false	false	false	true
9bc08c0d-ec9b-4cac-baed-e36bd1f53c59	2026-09-09 14:55	2026-09-09 14:54	2026-09-09 14:54	APO	APO261218C00150000	call	150.0000	2026-12-18	3.6700	3.5000	4.2000	130.6150	168453.00	0.00	0.00	459	8	468	306	1.52941176470588	0.350243956049041	0.350243956049041	false	false	false	true
bff3cf1e-31dd-4989-8428-d5c8c51951c5	2026-08-28 09:43	2026-08-28 09:43	2026-08-28 09:43	APO	APO280121C00120000	call	120.0000	2028-01-21	32.7000	32.2000	33.9000	133.4700	235440.00	22890.00	71940.00	72	8	72	468	0.153846153846154	0.36427386131	0.36427386131	false	false	false	true
1ed9a33f-b6ac-42c7-84a8-7da90397d7db	2026-08-27 12:01	2026-08-27 12:01	2026-08-27 12:01	APO	APO261016P00135000	put	135.0000	2026-10-16	6.5000	6.2000	6.5000	135.1000	98800.00	98800.00	0.00	152	20	156	45	3.46666666666667	0.346813665098217	0.346813665098217	false	false	false	true
441a70aa-4b34-4692-9934-d8ff2469b648	2026-08-19 11:21	2026-08-19 11:21	2026-08-19 11:21	APO	APO260828C00135000	call	135.0000	2026-08-28	3.4000	3.4000	3.7000	135.2950	78540.00	0.00	78540.00	231	9	231	12	19.25	0.376451130429414	0.376451130429414	false	false	false	true
77880ba1-d8db-4947-a502-1cf2bf44067d	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	APO	APO270115C00160000	call	160.0000	2027-01-15	3.9000	3.6000	4.1000	132.0000	59670.00	11700.00	47970.00	153	7	253	5378	0.0470435105987356	0.342507306687018	0.342507306687018	false	false	false	true
017f68c0-0235-4650-8928-73101d14a4b0	2026-08-17 11:30	2026-08-17 11:29	2026-08-17 11:29	APO	APO261016C00130000	call	130.0000	2026-10-16	11.8000	11.5000	11.8000	136.5700	135700.00	135700.00	0.00	115	22	117	1841	0.0635524171645845	0.351264773005363	0.351264773005363	false	false	false	true
45e4379d-c068-4437-b776-48a823e423f8	2026-08-17 11:14	2026-08-17 11:14	2026-08-17 11:14	APO	APO261016P00130000	put	130.0000	2026-10-16	4.7000	4.3000	4.7000	137.0900	68150.00	68150.00	0.00	145	15	877	317	2.76656151419558	0.373845164713168	0.373845164713168	false	false	false	true