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: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	price

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	73315933190.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T16:35:05.886735Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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	false
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	false
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	false
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	false
f234029c-f835-4f29-8270-ef2cb17463d1	2026-09-18 12:07	2026-09-18 12:06	2026-09-18 12:06	APO	APO270617C00145000	call	145.0000	2027-06-17	9.8500	9.7000	10.1000	126.0000	66946.00	16728.00	50218.00	68	5	727	929	0.782561894510226	0.347943246041387	0.34770857948433	false	false	false	true	false
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	false
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	false
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	false
f93c878c-ec7a-4f8b-8f53-fbf01f7f1443	2026-09-17 11:06	2026-09-17 11:06	2026-09-17 11:06	APO	APO270617P00120000	put	120.0000	2027-06-17	11.8400	11.3000	11.9000	127.3750	52112.00	52112.00	0.00	44	5	220	545	0.403669724770642	0.404594662736851	0.404594662736851	false	false	false	true	false
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	false
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	false
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	false
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	false
5e6e0318-860c-4781-8718-75ec3aad54a5	2026-09-08 15:05	2026-09-08 15:05	2026-09-08 15:05	APO	APO260918C00135000	call	135.0000	2026-09-18	2.1500	2.0000	2.3500	132.3150	50528.00	22575.00	27953.00	235	23	291	1607	0.181082762912259	0.372680670502777	0.370300708023617	true	false	false	true	false
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	false
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	false
eb69759b-2051-4836-97d5-3862570b6390	2026-08-26 10:43	2026-08-26 10:43	2026-08-26 10:43	APO	APO261120P00115000	put	115.0000	2026-11-20	2.7500	2.5500	2.9000	133.8750	490600.00	490600.00	0.00	1784	7	1792	261	6.86590038314176	0.401305709409065	0.401305709409065	false	true	false	true	false
30ef781e-1e64-4b6a-82d4-70bc8d582563	2026-08-24 14:59	2026-08-24 14:59	2026-08-24 14:59	APO	APO270617C00145000	call	145.0000	2027-06-17	13.7000	13.1000	14.7000	132.7200	696034.00	31510.00	664524.00	508	38	508	28	18.1428571428571	0.352375950049333	0.352375950049333	true	false	false	true	false
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	false
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	false
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	false
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	false