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:alert_rule = RepeatedHits×ticker = AS×sorted by created_at ↑×

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

614f9152-e10d-44ad-bf10-ad9c456f8e7b	2026-08-17 09:34	2026-08-17 09:34	2026-08-17 09:34	AS	AS260821P00032500	put	32.5000	2026-08-21	1.4000	1.3000	1.4500	33.3400	19320.00	18480.00	840.00	138	17	364	10853	0.0335391136091403	1.30662792497826	1.30662792497826	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-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
442a3e14-2da8-4e52-b6a6-3cfa089524f0	2026-08-17 09:35	2026-08-17 09:34	2026-08-17 09:34	AS	AS260821P00032500	put	32.5000	2026-08-21	1.4000	1.3000	1.4500	33.3250	33040.00	280.00	27860.00	236	19	652	10853	0.0600755551460426	1.30218734631774	1.30218734631774	false	false	false	true
cb550861-bfc1-4938-8991-2902f5eac0cc	2026-08-17 10:14	2026-08-17 10:14	2026-08-17 10:14	AS	AS260918P00030000	put	30.0000	2026-09-18	1.0500	1.0500	1.1500	32.2750	11340.00	0.00	11340.00	108	6	354	6346	0.0557831705011031	0.550742597287634	0.550742597287634	false	false	false	true
292c9c76-b739-451b-9dec-d181d404bab5	2026-08-17 12:38	2026-08-17 12:38	2026-08-17 12:38	AS	AS260821P00030000	put	30.0000	2026-08-21	0.6800	0.6500	0.7500	32.4600	13210.00	7350.00	5790.00	195	21	475	10876	0.0436741449062155	1.26681275241853	1.26681275241853	false	false	false	true
3037b2b0-6a26-4e5c-97cc-1c1dfccb9526	2026-08-17 13:20	2026-08-17 13:20	2026-08-17 13:20	AS	AS260821P00032500	put	32.5000	2026-08-21	1.7400	1.5500	1.8000	32.4600	17355.00	17355.00	0.00	100	5	1018	10853	0.0937989495991892	1.27415793050999	1.28154819813128	false	false	false	true
c9ea3d70-83a5-4c24-ba00-893bc1a8b04a	2026-08-17 13:54	2026-08-17 13:54	2026-08-17 13:54	AS	AS260821P00032500	put	32.5000	2026-08-21	1.7000	1.5000	1.7500	32.0000	17000.00	16660.00	340.00	100	12	1339	10853	0.123376025062195	1.27424309662027	1.27424309662027	false	false	false	true
7b24a261-58ec-4dda-a0ea-3733674297e6	2026-08-17 13:56	2026-08-17 13:56	2026-08-17 13:56	AS	AS270319P00022500	put	22.5000	2027-03-19	0.8600	0.6500	0.9000	32.0000	14310.00	3855.00	10455.00	166	22	166	8	20.75	0.510726846252272	0.510726846252272	false	false	false	true
48544992-3d56-46e4-9584-72f0f280aa5c	2026-08-17 15:28	2026-08-17 15:28	2026-08-17 15:28	AS	AS261218C00037500	call	37.5000	2026-12-18	2.1000	2.0500	2.2000	32.4700	47250.00	0.00	34230.00	225	5	279	75	3.72	0.494254144248481	0.494781416320289	false	false	false	true
a5573018-8112-48e9-9358-9810fd4ce09f	2026-08-17 15:30	2026-08-17 15:30	2026-08-17 15:30	AS	AS261218C00037500	call	37.5000	2026-12-18	2.0500	2.0500	2.2000	32.3900	99015.00	0.00	99015.00	483	8	1051	75	14.0133333333333	0.490413145859453	0.491985683366112	false	false	false	true
8ee841f0-38af-443a-92d8-1fe8862fec23	2026-08-17 15:34	2026-08-17 15:34	2026-08-17 15:34	AS	AS261218C00037500	call	37.5000	2026-12-18	2.0500	2.0000	2.1500	32.3700	32595.00	5330.00	6765.00	159	8	1263	75	16.84	0.493034067664318	0.493034067664318	false	false	false	true
69945bb3-1ad5-41e0-a4fe-c93d481498a8	2026-08-17 15:34	2026-08-17 15:34	2026-08-17 15:34	AS	AS261218C00037500	call	37.5000	2026-12-18	2.0500	2.0000	2.1500	32.3700	10660.00	8610.00	2050.00	52	5	1104	75	14.72	0.493034067664318	0.493034067664318	false	false	false	true
a2878325-1b84-46e3-b977-f765acd3fc72	2026-08-17 15:43	2026-08-17 15:43	2026-08-17 15:43	AS	AS260918C00032500	call	32.5000	2026-09-18	2.1500	2.1500	2.3500	32.3000	21286.00	0.00	21286.00	99	23	8744	909	9.61936193619362	0.575311765549459	0.575311765549459	true	false	false	true
e82050c5-f958-44a9-96ca-a73a11ea602c	2026-08-17 15:45	2026-08-17 15:44	2026-08-17 15:44	AS	AS260918C00032500	call	32.5000	2026-09-18	2.1500	2.1500	2.3500	32.3300	17630.00	0.00	17630.00	82	30	8826	909	9.70957095709571	0.571149551020481	0.571149551020481	true	false	false	true
66290342-fedf-4110-86f4-cd87cfa17d11	2026-08-17 15:47	2026-08-17 15:47	2026-08-17 15:47	AS	AS261218C00037500	call	37.5000	2026-12-18	2.0000	1.9500	2.0000	32.3900	18600.00	4800.00	0.00	93	5	1431	75	19.08	0.484951852911617	0.484951852911617	false	false	false	true
340ecd2c-19f7-4032-8a65-238217acc23c	2026-08-18 10:03	2026-08-18 10:03	2026-08-18 10:03	AS	AS260918C00040000	call	40.0000	2026-09-18	0.2500	0.2000	0.3000	33.8100	24525.00	16075.00	8450.00	981	33	26582	5299	5.01641819211172	0.459610411539531	0.455350170705129	false	false	false	true
9d7ceac6-adc7-4c31-9afb-3176c9293617	2026-08-18 10:03	2026-08-18 10:03	2026-08-18 10:03	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3000	0.2500	0.3500	33.8500	48927.00	37887.00	11040.00	1631	37	28823	5299	5.43932817512738	0.47915927857996	0.477253506312024	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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