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

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	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-19T15:49:41.153087Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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	false
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	false
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	false
35441e86-b4d5-416a-9836-9651179ec6bd	2026-08-19 10:41	2026-08-19 10:41	2026-08-19 10:41	AS	AS260918C00035000	call	35.0000	2026-09-18	1.3900	1.3000	1.4500	33.9700	51524.00	50969.00	280.00	370	47	5805	30308	0.191533588491487	0.453385728877604	0.463501090768348	false	false	false	true	false
d52940a6-6449-44bb-b09d-7d4c866b92b5	2026-08-19 10:40	2026-08-19 10:40	2026-08-19 10:40	AS	AS260918C00035000	call	35.0000	2026-09-18	1.3500	1.3000	1.4000	33.9500	147926.00	147791.00	0.00	1092	28	5434	30308	0.179292596014254	0.452810565978777	0.465817615220442	false	false	false	true	false
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	false
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	false
7c10471b-3adc-4a4b-8eb4-6b5b729f1b52	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.0500	24760.00	12000.00	12760.00	168	10	3365	30308	0.111026791606177	0.482401298795848	0.467124062846733	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
d04d42fb-adec-44f8-ba49-d7c5032ab7a1	2026-08-19 09:55	2026-08-19 09:54	2026-08-19 09:54	AS	AS260918C00035000	call	35.0000	2026-09-18	1.4000	1.2500	1.5500	34.0600	102520.00	98880.00	3640.00	734	49	970	30308	0.0320047512207998	0.454260692303157	0.453026061857035	false	false	false	true	false
d2cc440a-a9ac-48bb-8a39-f4852d3ff0fd	2026-08-18 15:58	2026-08-18 15:58	2026-08-18 15:58	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2600	1.2500	1.4000	33.0000	26170.00	0.00	26170.00	208	10	11899	29524	0.403028044980355	0.538682842388222	0.485686595950341	false	false	false	true	false
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	false
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	false
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	false
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	false
7454cea8-61be-4794-a470-32181bcb7ba3	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	12375.00	12375.00	0.00	99	10	9511	29524	0.322144695840672	0.533276053314067	0.533276053314067	false	false	false	true	false
2959353b-8b29-4002-94f4-7f60235ce49f	2026-08-18 15:57	2026-08-18 15:56	2026-08-18 15:56	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.2000	1.2500	33.0000	17500.00	17500.00	0.00	140	14	9322	29524	0.315743124237908	0.481467753036577	0.481467753036577	false	false	false	true	false
ac4136dd-8074-4527-94c2-291191b71fc9	2026-08-18 15:56	2026-08-18 15:56	2026-08-18 15:56	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.2000	1.2500	33.0000	16375.00	15125.00	0.00	131	15	8334	29524	0.282278824007587	0.506147861085257	0.506147861085257	true	false	false	true	false
6fb28ef8-a15a-4dcf-80b3-2ae2e6054328	2026-08-18 15:56	2026-08-18 15:56	2026-08-18 15:56	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.2000	1.2500	33.0000	68750.00	68750.00	0.00	550	17	8884	29524	0.300907736079122	0.533276053314067	0.533276053314067	true	false	false	true	false
44ec38f9-0b5c-4aea-8f47-616e75747b17	2026-08-18 15:56	2026-08-18 15:56	2026-08-18 15:56	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.2000	1.2500	33.0000	13250.00	13250.00	0.00	106	19	8170	29524	0.276724021135347	0.47720269317819	0.47720269317819	true	false	false	true	false
c785ad30-a050-483f-8818-fa2bb3672426	2026-08-18 15:55	2026-08-18 15:55	2026-08-18 15:55	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.2000	1.2500	33.0000	167000.00	167000.00	0.00	1336	22	7832	29524	0.265275707898659	0.533276053314067	0.533276053314067	true	false	false	true	false
c1d9dee0-0fbf-48a2-a436-2ae701840070	2026-08-18 15:55	2026-08-18 15:54	2026-08-18 15:54	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.2000	1.2500	33.0000	12750.00	12750.00	0.00	102	19	4495	29524	0.152249017748273	0.580038428672336	0.558964196875669	true	false	false	true	false
8ae8ee54-8a29-4b12-b8f6-ef54d687aaf2	2026-08-18 15:54	2026-08-18 15:54	2026-08-18 15:54	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2100	1.2000	1.3000	33.0000	10071.00	0.00	10071.00	83	6	4393	29524	0.148794201327733	0.561314580367378	0.561314580367378	false	false	false	true	false
1a7b4c23-47e2-40a0-8c8f-90e199b67537	2026-08-18 15:54	2026-08-18 15:54	2026-08-18 15:54	AS	AS260821C00032500	call	32.5000	2026-08-21	1.2500	1.2500	1.3500	33.0000	11125.00	0.00	11125.00	89	6	4237	29524	0.143510364449262	0.559679803965808	0.559679803965808	false	false	false	true	false
847c92b2-fb5d-426c-a52b-5b718823e89d	2026-08-18 15:47	2026-08-18 15:47	2026-08-18 15:47	AS	AS260821C00035000	call	35.0000	2026-08-21	0.2500	0.1500	0.3500	33.0000	44112.00	44087.00	25.00	1765	47	6554	10841	0.604556775205239	0.622241365651125	0.608423550950742	true	false	false	true	false
bcf18773-35bc-4e3d-a83f-070cd17add76	2026-08-18 14:19	2026-08-18 14:19	2026-08-18 14:19	AS	AS270115P00037500	put	37.5000	2027-01-15	6.0000	5.9000	6.2000	33.5400	21600.00	0.00	21600.00	36	5	58	518	0.111969111969112	0.457799640297974	0.457799640297974	false	false	false	true	false
7451298a-8ff7-453e-a60e-17b1e3775a78	2026-08-18 13:26	2026-08-18 13:25	2026-08-18 13:25	AS	AS260918C00035000	call	35.0000	2026-09-18	1.1000	1.0000	1.1000	33.3700	54994.00	54994.00	0.00	500	11	5057	29022	0.174247122872304	0.437326053346659	0.440009437247461	false	false	false	true	false
05a87f5d-2018-444f-a4ef-84fee965f184	2026-08-18 11:13	2026-08-18 11:13	2026-08-18 11:13	AS	AS260821C00032500	call	32.5000	2026-08-21	1.3000	1.1500	1.3000	33.3700	38958.00	38958.00	0.00	300	27	2729	29524	0.0924332746240347	0.647800041263506	0.657103716654748	false	false	false	true	false
bc6a574d-192c-4fb5-940b-911e4dc4da7e	2026-08-18 11:11	2026-08-18 11:11	2026-08-18 11:11	AS	AS260918C00035000	call	35.0000	2026-09-18	1.2000	1.1500	1.2000	33.4700	59995.00	59995.00	0.00	500	8	2822	29022	0.0972365791468541	0.453456199259192	0.456105278920097	false	false	false	true	false
948f0caf-6c00-4175-ae5f-2559ffcb0880	2026-08-18 11:10	2026-08-18 11:10	2026-08-18 11:10	AS	AS260918C00040000	call	40.0000	2026-09-18	0.2500	0.2000	0.3000	33.4100	15266.00	616.00	13825.00	608	19	47993	5299	9.05699188526137	0.47972212403954	0.47972212403954	false	false	false	true	false
881072ef-8c7e-426e-995d-c16f716fa5ca	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	AS	AS260918C00030000	call	30.0000	2026-09-18	4.1900	4.1000	4.5000	33.7200	29340.00	0.00	29340.00	70	7	171	3316	0.0515681544028951	0.419049170660801	0.440548663864833	false	false	false	true	false
1a5bc120-8445-42d0-a4d5-bccba3af9854	2026-08-18 10:50	2026-08-18 10:50	2026-08-18 10:50	AS	AS260821C00032500	call	32.5000	2026-08-21	1.6100	1.5000	1.8000	33.8900	80531.00	0.00	80531.00	500	9	2408	29524	0.0815607641241024	0.592631585183985	0.592631585183985	false	false	false	true	false
74a85ebc-4e8c-46e2-a271-da515634940c	2026-08-18 10:39	2026-08-18 10:39	2026-08-18 10:39	AS	AS260918C00037500	call	37.5000	2026-09-18	0.6500	0.5500	0.7000	33.7800	19890.00	19370.00	520.00	306	20	602	3985	0.151066499372647	0.467688609765381	0.470092537673974	true	false	false	true	false
5d11eda4-cac6-4e87-8787-71bd72598cef	2026-08-18 10:32	2026-08-18 10:32	2026-08-18 10:32	AS	AS260821C00032500	call	32.5000	2026-08-21	1.8000	1.6500	1.8000	34.0100	12060.00	12060.00	0.00	67	6	1707	29524	0.0578173689202005	0.68796028657574	0.68796028657574	true	false	false	true	false
13c77ed1-bddc-43a2-8b4f-65095d61c085	2026-08-18 10:25	2026-08-18 10:25	2026-08-18 10:25	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3500	0.3500	0.4000	34.1600	31053.00	0.00	31053.00	887	18	45551	5299	8.59615021702208	0.479925789628276	0.479925789628276	false	false	false	true	false
39c96628-d610-46fb-bd59-ddb61683bfaa	2026-08-18 10:16	2026-08-18 10:16	2026-08-18 10:16	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3000	0.3000	0.3500	33.9200	45104.00	0.00	45104.00	1500	24	43892	5299	8.28307227778826	0.480149618491346	0.472851874843708	false	false	false	true	false
eea9aa49-d290-4c0e-ab4b-3525f2aeabf1	2026-08-18 10:13	2026-08-18 10:13	2026-08-18 10:13	AS	AS260918C00037500	call	37.5000	2026-09-18	0.7500	0.6500	0.8000	34.0000	12600.00	6300.00	6300.00	168	19	217	3985	0.0544542032622334	0.483225601945763	0.483225601945763	true	false	false	true	false
eadab151-5536-40fc-976c-ee9f864332f7	2026-08-18 10:09	2026-08-18 10:09	2026-08-18 10:09	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3000	0.2500	0.3500	33.7950	80916.00	3032.00	77884.00	2693	8	41340	5299	7.8014719758445	0.480713061087371	0.480713061087371	false	false	false	true	false
49dd6db7-453d-4716-b1ad-fb5c72ee5ff2	2026-08-18 10:09	2026-08-18 10:09	2026-08-18 10:09	AS	AS260821C00035000	call	35.0000	2026-08-21	0.2000	0.1500	0.4500	33.8150	63682.00	4050.00	59532.00	3142	75	3413	10841	0.314823355778987	0.467643947816527	0.548472184975603	true	false	false	true	false
2cf1c08b-f818-4f72-b4e2-12e23cf6d029	2026-08-18 10:08	2026-08-18 10:08	2026-08-18 10:08	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3500	0.3000	0.3500	33.9250	11655.00	11655.00	0.00	333	10	38097	5299	7.18946971126628	0.495127363583488	0.495127363583488	true	false	false	true	false
13af02f3-0dd5-43e6-8033-1469d3780044	2026-08-18 10:08	2026-08-18 10:08	2026-08-18 10:08	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3000	0.2500	0.3500	33.7200	19080.00	150.00	18900.00	636	6	37713	5299	7.11700320815248	0.485432364633667	0.485432364633667	false	false	false	true	false
f6361f64-9729-40c4-98e2-e903670743ca	2026-08-18 10:08	2026-08-18 10:08	2026-08-18 10:08	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3000	0.2000	0.3000	33.6900	29760.00	29760.00	0.00	992	23	37077	5299	6.99698056237026	0.48732067674415	0.48732067674415	true	false	false	true	false
7a8ff5dc-1bf3-4cad-a407-beafbaa24821	2026-08-18 10:08	2026-08-18 10:08	2026-08-18 10:08	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3000	0.2000	0.3000	33.6200	169497.00	169497.00	0.00	5650	43	35857	5299	6.76674844310247	0.491728127958133	0.491728127958133	true	false	false	true	false