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 = AS×

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

476e33a2-b038-4ab8-8e9e-2aff6b2f083d	2026-09-21 12:07	2026-09-21 12:07	2026-09-21 12:07	AS	AS261120P00027500	put	27.5000	2026-11-20	2.2000	2.1500	2.2500	27.2300	21340.00	440.00	20900.00	97	16	118	429	0.275058275058275	0.490327812095508	0.489796401808456	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	15307969773.00	2026-11-17	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
dc7795dd-d675-43b1-8ac1-759cd57c0a99	2026-09-21 10:23	2026-09-21 10:23	2026-09-21 10:23	AS	AS261030P00022000	put	22.0000	2026-10-30	0.1700	0.0500	0.3500	27.0000	183150.00	0.00	116550.00	11100	2	11100	0	0	0.519422066775254	0.519422066775254	false	true	false	true	true
fabe8402-8b33-4090-8dc1-ae6187d9b44f	2026-09-18 15:06	2026-09-18 15:06	2026-09-18 15:06	AS	AS261016P00027500	put	27.5000	2026-10-16	1.6000	1.5000	1.6000	26.8800	14720.00	14720.00	0.00	92	11	166	1000	0.166	0.43846572195564	0.43846572195564	false	false	false	true	false
7e52f36f-8be8-464e-95b0-2ddd35a9dabc	2026-09-18 15:06	2026-09-18 15:06	2026-09-18 15:06	AS	AS261016C00027500	call	27.5000	2026-10-16	1.0500	1.0000	1.0500	26.8650	10499.00	10499.00	0.00	100	27	340	9577	0.0355017228777279	0.436180021226607	0.436180021226607	false	false	false	true	false
8f3b60f5-acb8-4b93-b163-da1cb8d9e84d	2026-09-18 13:24	2026-09-18 13:24	2026-09-18 13:24	AS	AS261120C00027500	call	27.5000	2026-11-20	2.0000	1.9500	2.0000	26.8355	11000.00	11000.00	0.00	55	5	2567	97	26.4639175257732	0.497237603604095	0.497237603604095	false	false	false	true	false
1079ef7f-d9d1-4e06-b1aa-aa98bad20454	2026-09-18 13:14	2026-09-18 13:14	2026-09-18 13:14	AS	AS261016C00027500	call	27.5000	2026-10-16	1.0500	0.9500	1.0500	26.8000	10500.00	10500.00	0.00	100	8	233	9577	0.0243291218544429	0.446204035178036	0.446204035178036	false	false	false	true	false
04d9b577-cf3f-4136-9cf7-b39501c9e216	2026-09-18 13:08	2026-09-18 13:08	2026-09-18 13:08	AS	AS260918P00027000	put	27.0000	2026-09-18	0.1300	0.1000	0.9500	26.9150	16315.00	0.00	16315.00	1255	2	1255	1343	0.934475055845123	0.525770685284505	0.525770685284505	false	true	false	true	false
cac041c8-62f4-4283-8bd6-2cc0978bb400	2026-09-18 13:05	2026-09-18 13:05	2026-09-18 13:05	AS	AS261016C00027500	call	27.5000	2026-10-16	1.1000	1.0000	1.1000	26.9150	11000.00	11000.00	0.00	100	5	133	9577	0.0138874386551112	0.445293301510234	0.445293301510234	false	false	false	true	false
5298f1b2-e32d-4934-aa73-a62a9854ecf2	2026-09-18 12:03	2026-09-18 12:03	2026-09-18 12:03	AS	AS261120C00027500	call	27.5000	2026-11-20	2.0500	2.0000	2.0500	26.0000	12095.00	12095.00	0.00	59	6	883	97	9.10309278350515	0.49531014091283	0.49531014091283	false	false	false	true	false
4b33fa9b-e0c0-4ac0-bd16-d2067edece52	2026-09-18 11:43	2026-09-18 11:43	2026-09-18 11:43	AS	AS261120C00027500	call	27.5000	2026-11-20	2.0500	1.9500	2.0500	26.9350	12095.00	12095.00	0.00	59	9	726	97	7.48453608247423	0.497042136049386	0.497042136049386	false	false	false	true	false
4d50839c-8aa5-463b-a48f-7fecb16ac542	2026-09-18 10:16	2026-09-18 10:16	2026-09-18 10:16	AS	AS270115P00025000	put	25.0000	2027-01-15	1.8000	1.7500	1.8500	26.7200	10260.00	6120.00	3960.00	57	5	125	6421	0.0194673726833826	0.46422694501331	0.46422694501331	false	false	false	true	false
40d74ae2-72a6-4de5-9d6b-40315d7ceaf3	2026-09-18 10:11	2026-09-18 10:11	2026-09-18 10:11	AS	AS261120C00027500	call	27.5000	2026-11-20	1.9000	1.8500	1.9500	26.6650	10640.00	5130.00	0.00	56	5	119	97	1.22680412371134	0.49395986202911	0.49395986202911	false	false	false	true	false
f7369ad5-fac5-4476-8fa7-4aac218ebfab	2026-09-18 10:01	2026-09-18 10:01	2026-09-18 10:01	AS	AS261120C00027500	call	27.5000	2026-11-20	1.9000	1.8500	1.9000	26.6500	10640.00	10640.00	0.00	56	12	59	97	0.608247422680412	0.495638575822179	0.495638575822179	false	false	false	true	false
0fd5b17a-6df5-4252-8567-efc393a82bab	2026-09-17 14:32	2026-09-17 14:32	2026-09-17 14:32	AS	AS260918P00030000	put	30.0000	2026-09-18	3.4000	3.4000	3.7000	26.4750	2688100.00	0.00	2688100.00	7900	2	17619	7438	2.36878193062651	2.03597093660534	2.03597093660534	false	true	true	false	false
3e725668-1af4-4e99-904d-ee9e19d69466	2026-09-17 14:31	2026-09-17 14:30	2026-09-17 14:30	AS	AS260918P00030000	put	30.0000	2026-09-18	3.5400	3.4000	3.7000	26.4900	2858904.00	0.00	2858904.00	8076	1	8187	7438	1.10069911266469	1.36410652250115	1.36410652250115	false	true	true	false	true
be92b4b4-10e2-46bd-8c1f-023d5d879e84	2026-09-17 13:41	2026-09-17 13:41	2026-09-17 13:41	AS	AS261218C00027500	call	27.5000	2026-12-18	2.2000	2.1000	2.2000	26.5300	10340.00	10340.00	0.00	47	9	117	87	1.3448275862069	0.471617857801385	0.470194296064085	true	false	false	true	false
0d0939bc-9990-45ba-9cd1-6b3592d968d5	2026-09-17 12:57	2026-09-17 12:57	2026-09-17 12:57	AS	AS260918P00030000	put	30.0000	2026-09-18	3.4800	3.2000	3.6000	26.5700	34830.00	34830.00	0.00	100	8	100	7438	0.013444474321054	1.40750231261594	1.40750231261594	false	false	false	true	false
12e02cb4-f353-48da-8aec-be3bf17a98cf	2026-09-17 12:52	2026-09-17 12:52	2026-09-17 12:52	AS	AS261120P00025000	put	25.0000	2026-11-20	1.2500	1.1000	1.4000	26.6200	12500.00	375.00	625.00	100	7	101	0	0	0.472095210967137	0.472095210967137	false	false	false	true	false
a9a7ae7d-ebc3-44ae-872d-f51cc0a00c34	2026-09-17 10:48	2026-09-17 10:48	2026-09-17 10:48	AS	AS261016P00022500	put	22.5000	2026-10-16	0.1400	0.1000	0.2500	26.3750	319000.00	0.00	319000.00	22000	2	22000	5	4400	0.452397218833433	0.452397218833433	false	true	false	true	false
65997734-22b6-42a0-a012-2b4bc7567782	2026-09-17 10:48	2026-09-17 10:48	2026-09-17 10:48	AS	AS261016P00022500	put	22.5000	2026-10-16	0.1400	0.1000	0.2500	26.3750	319000.00	0.00	319000.00	22000	2	22000	5	4400	0.452397218833433	0.452397218833433	false	true	false	true	false
48c4d629-8db2-4174-bfb1-f43145139f5e	2026-09-16 15:32	2026-09-16 15:32	2026-09-16 15:32	AS	AS260918C00027500	call	27.5000	2026-09-18	0.5500	0.4000	0.5500	27.0700	19965.00	19965.00	0.00	363	8	3077	202	15.2326732673267	0.922237364344769	0.922237364344769	false	false	false	true	false
6296cfcf-ed1e-4ed6-99e7-9536f74ad033	2026-09-16 15:31	2026-09-16 15:31	2026-09-16 15:31	AS	AS260918C00027500	call	27.5000	2026-09-18	0.5000	0.4000	0.5000	27.0000	24850.00	24850.00	0.00	497	13	2613	202	12.9356435643564	0.895297745773468	0.895297745773468	false	false	false	true	false
c92c000b-ccce-4950-9748-ae8e6df6b8cc	2026-09-16 15:17	2026-09-16 15:16	2026-09-16 15:16	AS	AS260918P00028000	put	28.0000	2026-09-18	1.1000	1.1000	1.2000	27.2200	102630.00	0.00	102630.00	933	32	4149	4180	0.992583732057416	0.785106081571823	0.785106081571823	true	false	false	true	false
0273afe3-30ee-4b07-bbcf-b4a3f42783f7	2026-09-16 15:17	2026-09-16 15:16	2026-09-16 15:16	AS	AS260918P00028000	put	28.0000	2026-09-18	1.1500	1.1000	1.2500	27.2200	120419.00	230.00	109264.00	1047	63	3196	4180	0.764593301435407	0.802664887733152	0.853403412566077	true	false	false	true	false
406591fb-b527-43a4-98d2-3c82b11d482e	2026-09-16 15:12	2026-09-16 15:11	2026-09-16 15:11	AS	AS261016C00030000	call	30.0000	2026-10-16	0.5500	0.5000	0.6000	27.1400	41960.00	41245.00	715.00	763	48	10925	4697	2.3259527357888	0.478005338573622	0.478005338573622	true	false	false	true	false
9a9bbbda-4a20-4cff-b4f5-74d9b823569b	2026-09-16 15:02	2026-09-16 15:02	2026-09-16 15:02	AS	AS260918C00028000	call	28.0000	2026-09-18	0.4500	0.3500	0.4500	27.2500	13230.00	13230.00	0.00	294	18	514	728	0.706043956043956	0.938243512326387	0.938243512326387	true	false	false	true	false
244e6c4a-d96b-402b-9656-7bd296dcda09	2026-09-16 15:01	2026-09-16 15:00	2026-09-16 15:00	AS	AS261016C00030000	call	30.0000	2026-10-16	0.5800	0.5000	0.6000	27.2800	579875.00	360700.00	0.00	10000	6	10082	4697	2.14647647434533	0.46351884333892	0.46351884333892	true	true	false	true	false
ed605c8d-e82a-4076-9216-85afe405c59c	2026-09-16 14:36	2026-09-16 14:36	2026-09-16 14:36	AS	AS261016C00027500	call	27.5000	2026-10-16	1.4000	1.4000	1.5000	27.4400	109620.00	0.00	109620.00	783	17	1478	9181	0.160984642195839	0.442028502529145	0.442028502529145	false	false	false	true	false
706c4005-3b04-497f-9dd4-cae140b26d40	2026-09-16 14:09	2026-09-16 14:09	2026-09-16 14:09	AS	AS260918P00028000	put	28.0000	2026-09-18	0.8200	0.7500	0.9500	27.7450	171119.00	0.00	171119.00	2080	62	2145	4180	0.513157894736842	0.745847722596638	0.811954311842548	true	false	false	true	false
400a262e-5e32-4fec-941d-dc7e7035629a	2026-09-16 11:37	2026-09-16 11:37	2026-09-16 11:37	AS	AS260918P00027500	put	27.5000	2026-09-18	0.7000	0.6000	0.7000	27.5400	27230.00	27230.00	0.00	389	44	420	638	0.658307210031348	0.889556175245097	0.889556175245097	true	false	false	true	false
018a7082-c927-4f7e-b2d6-26d1cfa4664d	2026-09-16 11:37	2026-09-16 11:36	2026-09-16 11:36	AS	AS260918P00026500	put	26.5000	2026-09-18	0.3000	0.2000	0.3000	27.6300	11390.00	11390.00	0.00	380	47	382	427	0.894613583138173	0.920063985800897	0.920063985800897	true	false	false	true	false
50e6dfc9-5db7-45ac-a5c7-7d98dae22221	2026-09-16 10:12	2026-09-16 10:12	2026-09-16 10:12	AS	AS261002C00027000	call	27.0000	2026-10-02	1.2500	1.2500	1.4000	27.2400	43500.00	0.00	43500.00	348	22	3261	5914	0.551403449442002	0.481591575416603	0.486601410843629	false	false	false	true	false
2a2dbe32-03e3-4f2d-85ea-fdd2b9834816	2026-09-16 10:10	2026-09-16 10:10	2026-09-16 10:10	AS	AS261002C00027000	call	27.0000	2026-10-02	1.3000	1.3000	1.4000	27.3600	377933.00	0.00	377933.00	2905	70	2913	5914	0.492560027054447	0.496240080569563	0.478391213259712	false	false	false	true	false
6b64a5cb-7efc-4869-994f-8393f8470bdf	2026-09-15 14:38	2026-09-15 14:38	2026-09-15 14:38	AS	AS261016C00027500	call	27.5000	2026-10-16	1.1000	1.1000	1.1500	26.5900	10232.00	0.00	10232.00	93	24	2842	6061	0.4688995215311	0.46932206553591	0.46932206553591	false	false	false	true	false
43726c98-7491-4497-8feb-78ef0fff4921	2026-09-15 13:57	2026-09-15 13:57	2026-09-15 13:57	AS	AS260925C00028000	call	28.0000	2026-09-25	0.4500	0.4000	0.5000	26.6750	17640.00	720.00	0.00	392	9	2515	82	30.6707317073171	0.533446590276318	0.533446590276318	false	false	false	true	false
2924f67d-d86e-4a2b-90b0-15ca5f1a7cad	2026-09-15 13:57	2026-09-15 13:57	2026-09-15 13:57	AS	AS260925C00028000	call	28.0000	2026-09-25	0.4500	0.4000	0.5000	26.7000	92609.00	89729.00	2880.00	2058	49	2073	82	25.280487804878	0.530453091253991	0.528454999629196	false	false	false	true	false
83fe74d5-471b-492c-a607-7ae2b3213b35	2026-09-15 13:22	2026-09-15 13:22	2026-09-15 13:22	AS	AS261016C00027500	call	27.5000	2026-10-16	1.1500	1.1500	1.2000	26.7600	11178.00	0.00	11178.00	97	19	2527	6061	0.41692789968652	0.46729574986593	0.460829391528728	false	false	false	true	false
a9e25d43-f515-41ca-ac57-d768c0663611	2026-09-15 12:40	2026-09-15 12:40	2026-09-15 12:40	AS	AS261016C00027500	call	27.5000	2026-10-16	1.2000	1.1500	1.2500	26.0000	22440.00	21360.00	0.00	187	13	2343	6061	0.386569872958258	0.464313336024981	0.463563674413284	false	false	false	true	false
1dfe8acc-eeab-4443-9432-9377cffb7c0e	2026-09-15 11:05	2026-09-15 11:05	2026-09-15 11:05	AS	AS261016C00027500	call	27.5000	2026-10-16	1.1500	1.1000	1.2000	26.0000	13697.00	6210.00	7487.00	119	23	1686	6061	0.278171918825276	0.46009173059899	0.46009173059899	false	false	false	true	false
6fbe1ff3-8a7c-4919-b0cd-57d52e989201	2026-09-14 14:45	2026-09-14 14:45	2026-09-14 14:45	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5200	1.5000	1.6000	27.7000	11281.00	0.00	11281.00	74	11	13394	17971	0.745311891380558	0.469360242735043	0.447911133894177	false	false	false	true	false
3a4193d1-cfb3-4c10-a6cc-a1f77ff26088	2026-09-14 14:41	2026-09-14 14:41	2026-09-14 14:41	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5500	1.5500	1.6000	27.7000	10851.00	0.00	10851.00	70	25	13256	17971	0.73763285292972	0.469360242735043	0.469360242735043	false	false	false	true	false
5144cd27-9b7d-44d7-8d34-0b1c0fdf6a0c	2026-09-14 14:40	2026-09-14 14:40	2026-09-14 14:40	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5500	1.5500	1.6000	27.7100	10850.00	0.00	10850.00	70	18	13186	17971	0.733737688498136	0.466683070807759	0.466683070807759	false	false	false	true	false
2dd68ea9-8b39-4d1a-a304-88f490185ef4	2026-09-14 14:38	2026-09-14 14:37	2026-09-14 14:37	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5500	1.5500	1.6000	27.7300	11164.00	0.00	11164.00	72	11	13054	17971	0.726392521284291	0.465592770414717	0.465592770414717	false	false	false	true	false
e33c0642-b0c0-4732-92c0-b456a164b0b0	2026-09-14 14:36	2026-09-14 14:36	2026-09-14 14:36	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5700	1.5500	1.6500	27.7550	10205.00	0.00	10205.00	65	5	12982	17971	0.722386066440376	0.463116599531496	0.463116599531496	false	false	false	true	false
2735e9b1-c64e-4866-8571-852e221ca4cd	2026-09-14 14:29	2026-09-14 14:29	2026-09-14 14:29	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5100	1.5000	1.5500	27.6650	10872.00	0.00	10872.00	72	7	12700	17971	0.706694118301708	0.461560797455862	0.461560797455862	false	false	false	true	false
87ab50a4-ceb9-4e5e-8635-f47b9adaf58c	2026-09-14 14:22	2026-09-14 14:22	2026-09-14 14:22	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5000	1.5000	1.5500	27.6400	10806.00	0.00	10806.00	72	10	12429	17971	0.691614267430861	0.472427448070359	0.463896006530436	false	false	false	true	false
5cd7bae9-fe6b-4cba-9fe9-44f75a7538d1	2026-09-14 14:21	2026-09-14 14:21	2026-09-14 14:21	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5000	1.5000	1.5500	27.6300	10050.00	0.00	10050.00	67	5	12357	17971	0.687607812586946	0.463896006530436	0.46652330001242	false	false	false	true	false
f9d35c80-8121-4f00-b519-62776ff0c271	2026-09-14 14:18	2026-09-14 14:18	2026-09-14 14:18	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5000	1.5000	1.5500	27.6350	11850.00	0.00	11850.00	79	11	12225	17971	0.680262645373101	0.463896006530436	0.465210911711093	false	false	false	true	false
6ea4ae34-7f15-4d36-b51d-af7864387e54	2026-09-14 14:07	2026-09-14 14:07	2026-09-14 14:07	AS	AS261002C00027000	call	27.0000	2026-10-02	1.4500	1.4000	1.5000	27.5700	10440.00	0.00	0.00	72	5	11716	17971	0.651939235434867	0.460855253286929	0.460855253286929	false	false	false	true	false
d4421714-53f8-47c9-974f-6eb99eb4fbe4	2026-09-14 14:06	2026-09-14 14:05	2026-09-14 14:05	AS	AS261002C00027000	call	27.0000	2026-10-02	1.4500	1.4000	1.5000	27.5600	11165.00	0.00	0.00	77	5	11644	17971	0.647932780590952	0.463433634415269	0.463433634415269	false	false	false	true	false