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

f0f95447-5a9f-4693-9886-2da420ebf35e	2026-08-25 11:26	2026-08-25 11:26	2026-08-25 11:26	AS	AS261016P00030000	put	30.0000	2026-10-16	1.4000	1.3000	1.4500	31.0700	15960.00	140.00	15820.00	114	23	122	196	0.622448979591837	0.426734327556144	0.426734327556144	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	15363736512.00	2026-11-17	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d5f0e9fa-65c7-42f2-81ba-8b13542aeb41	2026-08-25 09:48	2026-08-25 09:48	2026-08-25 09:48	AS	AS261218C00040000	call	40.0000	2026-12-18	0.9000	0.7500	0.9000	30.9850	43020.00	43020.00	0.00	478	21	500	1205	0.4149377593361	0.472665834050992	0.472665834050992	false	false	false	true
e3fec532-a2aa-4e81-8c87-ea3eab615d79	2026-08-25 09:45	2026-08-25 09:44	2026-08-25 09:44	AS	AS260918C00032500	call	32.5000	2026-09-18	0.8000	0.6500	0.8000	30.7700	72240.00	72240.00	0.00	903	23	1115	17055	0.0653767223688068	0.458513354387335	0.458513354387335	false	false	false	true
fdb4e17e-a7be-495a-9d62-e47d0f882e38	2026-08-24 15:49	2026-08-24 15:49	2026-08-24 15:49	AS	AS260918C00032500	call	32.5000	2026-09-18	0.9500	0.9500	1.0000	31.2750	22705.00	0.00	22705.00	239	8	6886	11048	0.623280231716148	0.436213710056903	0.436213710056903	false	false	false	true
020cb1ad-ee49-4072-b511-c51a40db9270	2026-08-24 15:49	2026-08-24 15:49	2026-08-24 15:49	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0000	0.8500	1.0000	31.2810	76100.00	76100.00	0.00	761	13	7647	11048	0.692161477190442	0.451248024855243	0.451248024855243	false	false	false	true
9ddd47e4-9769-49a5-8cce-2c73fda8cc26	2026-08-24 12:42	2026-08-24 12:42	2026-08-24 12:42	AS	AS260918C00030000	call	30.0000	2026-09-18	2.3500	2.3500	2.4000	31.4750	192935.00	0.00	192935.00	821	7	6695	3409	1.96391903784101	0.450400774145203	0.450400774145203	false	false	false	true
7b3cef7c-41ba-4e87-8a47-3b3ce4c4ce20	2026-08-24 12:04	2026-08-24 12:04	2026-08-24 12:04	AS	AS260918C00030000	call	30.0000	2026-09-18	2.2500	2.2000	2.2500	31.3550	120375.00	118575.00	0.00	535	15	5517	3409	1.61836315635084	0.444220646623911	0.444220646623911	false	false	false	true
037ba0a8-f47e-4489-aec0-f7f829e549f2	2026-08-24 12:00	2026-08-24 12:00	2026-08-24 12:00	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0000	0.9000	1.0000	31.3300	49999.00	49999.00	0.00	500	22	3213	11048	0.290821868211441	0.444989607368589	0.444989607368589	false	false	false	true
26b4bb29-50f5-4209-86d9-79b55891e08c	2026-08-24 11:58	2026-08-24 11:58	2026-08-24 11:58	AS	AS260918C00030000	call	30.0000	2026-09-18	2.2000	2.1500	2.2500	31.2500	211420.00	88000.00	35420.00	961	23	4852	3409	1.42329128776767	0.451138111876647	0.451138111876647	false	false	false	true
840690c3-667f-456f-b77d-6f029d764244	2026-08-24 10:31	2026-08-24 10:30	2026-08-24 10:30	AS	AS260918C00032500	call	32.5000	2026-09-18	1.2500	1.1500	1.3000	31.9700	38125.00	7625.00	18000.00	305	10	320	11048	0.0289645184648805	0.438042980733828	0.435199245189991	false	false	false	true
2fe1cb24-3e65-4495-bff9-31adf198a761	2026-08-21 14:34	2026-08-21 14:34	2026-08-21 14:34	AS	AS260918C00030000	call	30.0000	2026-09-18	3.2900	3.2000	3.3000	32.5700	56842.00	56842.00	0.00	173	7	272	3227	0.0842888131391385	0.468587531160735	0.468587531160735	false	false	false	true
1a9d37a7-9aa4-4277-b7ed-89d7d5e3577b	2026-08-21 12:24	2026-08-21 12:24	2026-08-21 12:24	AS	AS260918C00035000	call	35.0000	2026-09-18	0.7500	0.7500	0.8000	32.6200	10425.00	0.00	10425.00	139	11	951	27309	0.0348236844996155	0.441185057714396	0.441185057714396	false	false	false	true
6f57608e-201c-439d-bd12-fa66a8dcb8fa	2026-08-20 15:53	2026-08-20 15:52	2026-08-20 15:52	AS	AS260918C00035000	call	35.0000	2026-09-18	0.8500	0.8000	0.8500	32.7600	10540.00	10540.00	0.00	124	6	20856	33146	0.62921619501599	0.44991038616345	0.44991038616345	false	false	false	true
f0ef219e-ffb7-4629-a05d-d12a773c4817	2026-08-20 15:52	2026-08-20 15:52	2026-08-20 15:52	AS	AS260918C00035000	call	35.0000	2026-09-18	0.8500	0.8000	0.8500	32.7610	10540.00	10540.00	0.00	124	6	20714	33146	0.624932118506004	0.44991038616345	0.449811351806374	false	false	false	true
0f17c948-d16a-445e-bace-62484b9b4e16	2026-08-20 15:51	2026-08-20 15:51	2026-08-20 15:51	AS	AS260918C00035000	call	35.0000	2026-09-18	0.8500	0.8000	0.8500	32.7850	11390.00	11390.00	0.00	134	15	20127	33146	0.607222590961202	0.447433131136891	0.447433131136891	false	false	false	true
13f97986-019f-4f21-904d-fbb7fe4e894c	2026-08-20 15:47	2026-08-20 15:46	2026-08-20 15:46	AS	AS260918C00032500	call	32.5000	2026-09-18	1.8000	1.7500	1.8000	32.6500	46980.00	12600.00	0.00	261	5	4104	7723	0.531399715136605	0.457855905236815	0.457855905236815	false	false	false	true
00758c09-3e54-412e-b645-85dca46cb9f8	2026-08-20 11:52	2026-08-20 11:51	2026-08-20 11:51	AS	AS260918C00035000	call	35.0000	2026-09-18	0.7500	0.7000	0.7500	32.4000	22575.00	22575.00	0.00	301	25	4811	33146	0.145145718940445	0.454273553409009	0.454273553409009	false	false	false	true
d63b4ad3-abec-44c5-a482-49030fe87938	2026-08-20 11:51	2026-08-20 11:51	2026-08-20 11:51	AS	AS260918C00035000	call	35.0000	2026-09-18	0.7000	0.6500	0.7500	32.3400	101430.00	63840.00	12530.00	1449	22	4510	33146	0.13606468352139	0.445053505083371	0.444119320788428	false	false	false	true
ebd0d7d6-5a5e-4664-8f27-84aa323a521b	2026-08-20 11:14	2026-08-20 11:14	2026-08-20 11:14	AS	AS270115C00037500	call	37.5000	2027-01-15	2.1000	2.1000	2.2000	32.5500	10500.00	0.00	10500.00	50	10	65	1295	0.0501930501930502	0.443748079584516	0.443748079584516	false	false	false	true
1916ca7c-cd7e-46dd-9f0c-e470570d0eb5	2026-08-20 10:53	2026-08-20 10:53	2026-08-20 10:53	AS	AS260918C00032500	call	32.5000	2026-09-18	1.7500	1.7000	1.8000	32.6550	30450.00	30100.00	0.00	174	10	2342	7723	0.30325003237084	0.445639134427025	0.443379789426812	true	false	false	true
2a105fa1-d2b9-48ce-ac9c-7074e0bb9ae0	2026-08-20 10:10	2026-08-20 10:09	2026-08-20 10:09	AS	AS260918C00032500	call	32.5000	2026-09-18	2.0000	1.8000	2.0000	32.9800	86000.00	86000.00	0.00	430	16	1996	7723	0.258448789330571	0.461628993702628	0.461628993702628	false	false	false	true
b354d225-8243-4f7c-9e3c-0f2f158cb0c2	2026-08-20 09:47	2026-08-20 09:46	2026-08-20 09:46	AS	AS260918C00032500	call	32.5000	2026-09-18	2.2000	2.1000	2.2500	33.2950	109900.00	109900.00	0.00	500	5	1001	7723	0.12961284474945	0.465221718827006	0.465221718827006	false	false	false	true
5bc2fc0a-1e78-4582-87be-e2cb4f8b85b0	2026-08-20 09:34	2026-08-20 09:34	2026-08-20 09:34	AS	AS260918C00032500	call	32.5000	2026-09-18	2.1000	1.6000	2.3000	33.1400	104770.00	104770.00	0.00	500	5	501	7723	0.0648711640554189	0.474353059037232	0.474353059037232	false	false	false	true
1bc8d3c1-33ac-45b1-9bf5-573042865a29	2026-08-19 14:21	2026-08-19 14:21	2026-08-19 14:21	AS	AS260918C00035000	call	35.0000	2026-09-18	1.6000	1.6000	1.6500	34.6400	16000.00	0.00	16000.00	100	6	7825	30308	0.258182658044081	0.432283610254208	0.433550452042501	false	false	false	true
27c8eb72-2fb0-48c9-b08b-e4af8c428f69	2026-08-19 13:46	2026-08-19 13:46	2026-08-19 13:46	AS	AS260821C00032500	call	32.5000	2026-08-21	2.2000	2.1500	2.2500	34.6900	26622.00	22000.00	3742.00	121	12	6872	21255	0.323312161844272	0.380941001289162	0.380941001289162	false	false	false	true
146bfd20-63c5-4e69-b75f-3a836cc49107	2026-08-19 12:37	2026-08-19 12:37	2026-08-19 12:37	AS	AS260821C00032500	call	32.5000	2026-08-21	1.9500	1.9000	1.9500	34.4000	118365.00	118365.00	0.00	607	10	5315	21255	0.250058809691837	0.531656153990522	0.531656153990522	false	false	false	true
8446cbfa-b98c-4397-9762-47ab6a1c35bf	2026-08-19 12:36	2026-08-19 12:36	2026-08-19 12:36	AS	AS260821C00032500	call	32.5000	2026-08-21	1.9500	1.8500	1.9500	34.4400	68835.00	68835.00	0.00	353	26	4689	21255	0.22060691601976	0.344147576390613	0.344147576390613	false	false	false	true
9cbdfa69-d5d7-4e99-9b8e-37dd0f280534	2026-08-19 12:36	2026-08-19 12:36	2026-08-19 12:36	AS	AS260821C00032500	call	32.5000	2026-08-21	1.9000	1.8500	1.9000	34.3700	40280.00	40280.00	0.00	212	7	4336	21255	0.203999059044931	0.458948734833586	0.458948734833586	false	false	false	true
dc116bb5-5ccf-47f0-bad1-c3242abc8363	2026-08-19 12:34	2026-08-19 12:34	2026-08-19 12:34	AS	AS260821C00032500	call	32.5000	2026-08-21	1.9000	1.8500	1.9000	34.3400	10830.00	10830.00	0.00	57	7	3574	21255	0.168148670900964	0.546369710341877	0.546369710341877	false	false	false	true
fbbc1571-8f50-4f2f-b2c5-0fd220d28821	2026-08-19 12:06	2026-08-19 12:06	2026-08-19 12:06	AS	AS260821C00032500	call	32.5000	2026-08-21	1.9000	1.8000	1.9000	34.3400	114950.00	114950.00	0.00	605	7	3423	21255	0.161044460127029	0.546369710341877	0.546369710341877	false	false	false	true
e7b46c43-4e74-4e45-9a47-e700f90b6098	2026-08-19 12:04	2026-08-19 12:04	2026-08-19 12:04	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3500	0.2500	0.3500	34.2900	35000.00	35000.00	0.00	1000	7	6964	46272	0.150501383125864	0.479604455292382	0.479604455292382	false	false	false	true
442759c8-44df-454d-af5b-a82eb425e5d1	2026-08-19 12:02	2026-08-19 12:02	2026-08-19 12:02	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3500	0.2500	0.3500	34.2650	35000.00	35000.00	0.00	1000	40	5943	46272	0.128436203319502	0.481246995141661	0.481246995141661	false	false	false	true
fde90f7d-5f9d-45af-9362-9cb1a4eb6898	2026-08-19 11:39	2026-08-19 11:39	2026-08-19 11:39	AS	AS260821C00032500	call	32.5000	2026-08-21	1.9000	1.8500	1.9000	34.3550	84550.00	84550.00	0.00	445	6	2156	21255	0.101434956480828	0.507643847326876	0.507643847326876	false	false	false	true
a4d45d69-8707-489a-8683-d39e3a8b388b	2026-08-19 11:38	2026-08-19 11:38	2026-08-19 11:38	AS	AS260821C00032500	call	32.5000	2026-08-21	1.9000	1.8500	1.9000	34.3850	65170.00	65170.00	0.00	343	13	1506	21255	0.0708539167254764	0.579524229597993	0.384006112619914	false	false	false	true
be9e7a3c-14ad-4ce7-91f5-b2c7477f3364	2026-08-19 11:38	2026-08-19 11:37	2026-08-19 11:37	AS	AS260821C00032500	call	32.5000	2026-08-21	1.9000	1.8500	1.9000	34.3400	60990.00	60990.00	0.00	321	13	1051	21255	0.0494471888967302	0.589701856839232	0.546369710341877	false	false	false	true
df44418c-ca69-4035-9a1c-7ea12e29b43f	2026-08-19 11:32	2026-08-19 11:32	2026-08-19 11:32	AS	AS261218C00045000	call	45.0000	2026-12-18	0.9500	0.8500	1.0000	34.1600	36480.00	35625.00	855.00	384	22	11451	129	88.7674418604651	0.474698344219897	0.474698344219897	true	false	false	true
c0741345-8c23-4199-980e-2e2eb78c4b16	2026-08-19 11:08	2026-08-19 11:08	2026-08-19 11:08	AS	AS261218C00045000	call	45.0000	2026-12-18	0.9000	0.9000	0.9500	34.0600	54360.00	0.00	54360.00	604	14	11013	129	85.3720930232558	0.469663183394452	0.46930003876749	true	false	false	true
82a21ec0-c0d5-46ef-b0a1-c5ddff8fdfcf	2026-08-19 11:02	2026-08-19 11:02	2026-08-19 11:02	AS	AS260918C00035000	call	35.0000	2026-09-18	1.4000	1.3000	1.4500	34.1300	13300.00	13020.00	0.00	95	11	6262	30308	0.206612115613039	0.444818532140492	0.444818532140492	false	false	false	true
3e0a1630-f687-4c12-b35c-fd6a58dfb861	2026-08-19 10:42	2026-08-19 10:42	2026-08-19 10:42	AS	AS260918C00035000	call	35.0000	2026-09-18	1.4000	1.3500	1.4500	33.9900	15260.00	8120.00	420.00	109	14	5918	30308	0.195261977035766	0.463501090768348	0.461180551024791	false	false	false	true
fb08e0ed-8e1c-43c8-b730-6a7e982cc435	2026-08-19 10:34	2026-08-19 10:34	2026-08-19 10:34	AS	AS260918C00035000	call	35.0000	2026-09-18	1.3000	1.2500	1.3500	33.8350	11310.00	10530.00	0.00	87	9	4308	30308	0.142140688927016	0.452874251565669	0.452874251565669	false	false	false	true
62c44ed3-8d90-4365-ac0b-a94f1b654cec	2026-08-19 10:29	2026-08-19 10:29	2026-08-19 10:29	AS	AS270115P00032500	put	32.5000	2027-01-15	3.0000	2.7500	3.1000	33.8500	12900.00	2400.00	10500.00	43	13	43	182	0.236263736263736	0.463076455340779	0.462176122488603	false	false	false	true
36909af2-245e-4bf9-85d7-8910497aa60f	2026-08-19 10:06	2026-08-19 10:06	2026-08-19 10:06	AS	AS260918C00035000	call	35.0000	2026-09-18	1.4700	1.4000	1.5000	34.0300	21065.00	9900.00	11165.00	143	8	3197	30308	0.10548370067309	0.482401298795848	0.469469574466787	true	false	false	true
000d7727-1f10-45c1-a7e0-8a5662cd0b3e	2026-08-19 10:06	2026-08-19 10:06	2026-08-19 10:06	AS	AS260918C00035000	call	35.0000	2026-09-18	1.4900	1.3000	1.5000	34.0400	39375.00	39375.00	0.00	265	15	3034	30308	0.10010558268444	0.481222994279419	0.468297338392817	true	false	false	true
b6b0076e-8a1b-446c-9de1-151491ee151a	2026-08-19 10:06	2026-08-19 10:06	2026-08-19 10:06	AS	AS260918C00035000	call	35.0000	2026-09-18	1.4500	1.3000	1.4500	33.9300	69035.00	69035.00	0.00	477	19	2565	30308	0.0846311204962386	0.481136602227459	0.468130189893509	true	false	false	true
90a01c32-2f33-4cfd-b8f2-d9ba437fe8c1	2026-08-19 10:01	2026-08-19 10:01	2026-08-19 10:01	AS	AS260918C00035000	call	35.0000	2026-09-18	1.4000	1.4000	1.4500	33.9050	50960.00	0.00	50960.00	364	7	2043	30308	0.0674079450970041	0.471015451437961	0.471015451437961	true	false	false	true
7172e4ff-233a-4f94-88d4-6c09d2c33cbc	2026-08-19 09:58	2026-08-19 09:58	2026-08-19 09:58	AS	AS260918C00035000	call	35.0000	2026-09-18	1.4000	1.3000	1.4000	34.0600	73220.00	73220.00	0.00	523	31	1558	30308	0.0514055694866042	0.453026061857035	0.453026061857035	false	false	false	true
5c8d4091-3d86-4e98-931c-b4fa03948a6e	2026-08-18 15:57	2026-08-18 15:57	2026-08-18 15:57	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.2000	1.2500	33.0000	37500.00	37500.00	0.00	300	12	10796	29524	0.365668608589622	0.517971448600735	0.517971448600735	false	false	false	true
d34ba709-276f-43c2-adc6-80c383577b88	2026-08-18 15:57	2026-08-18 15:57	2026-08-18 15:57	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.1500	1.2500	33.0000	37500.00	37500.00	0.00	300	13	10476	29524	0.354829968838911	0.540749274201926	0.540749274201926	false	false	false	true
e5b0f7c6-2a13-49bd-bcc1-01beafd4840e	2026-08-18 15:57	2026-08-18 15:57	2026-08-18 15:57	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.1500	1.2500	33.0000	37500.00	37500.00	0.00	300	12	10172	29524	0.344533261075735	0.566078095992641	0.566078095992641	false	false	false	true
fb615ee1-8284-49c0-a592-93b7c79d4eab	2026-08-18 15:57	2026-08-18 15:57	2026-08-18 15:57	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.2000	1.2500	33.0000	37500.00	37500.00	0.00	300	12	9872	29524	0.334372036309443	0.551754698375866	0.551754698375866	false	false	false	true