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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = HOOD×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

570cd29f-888f-4dfa-9546-2f1056cdf4f6	2026-08-27 09:59	2026-08-27 09:59	2026-08-27 09:59	HOOD	HOOD261016C00105000	call	105.0000	2026-10-16	13.9600	13.7500	14.0500	111.6800	279292.00	215674.00	63618.00	200	6	244	4549	0.0536381622334579	0.615924123118981	0.615924123118981	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	90392754653.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T14:00:28.149501Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
03a2804c-222a-472a-8b9d-6ee98433faa8	2026-08-26 10:00	2026-08-26 10:00	2026-08-26 10:00	HOOD	HOOD260918P00110000	put	110.0000	2026-09-18	6.5100	6.4500	6.7000	110.6100	126250.00	122380.00	3870.00	194	6	1600	5313	0.301148127235084	0.623970211704159	0.633073449026363	false	false	false	true
09a2025d-34df-4b91-9bf7-e126795af2cf	2026-08-25 13:57	2026-08-25 13:56	2026-08-25 13:56	HOOD	HOOD260918C00125000	call	125.0000	2026-09-18	2.9500	2.8500	2.9800	111.2126	449873.00	238969.00	210313.00	1525	53	2703	4391	0.615577317239809	0.658599865851591	0.658959417328235	true	false	false	true
d3fc9127-bafc-48d4-ab4c-1fe579e019a5	2026-08-25 12:32	2026-08-25 12:31	2026-08-25 12:31	HOOD	HOOD260918C00125000	call	125.0000	2026-09-18	2.8000	2.8000	2.9100	110.7350	97513.00	20513.00	77000.00	348	28	932	4391	0.2122523343202	0.656838963733956	0.656838963733956	false	false	false	true
51b80e73-a7a3-405e-aaaf-a47bc5e9b932	2026-08-25 10:46	2026-08-25 10:45	2026-08-25 10:45	HOOD	HOOD260904C00106000	call	106.0000	2026-09-04	7.2000	7.2000	7.6000	110.0200	118863.00	0.00	118863.00	165	10	317	1056	0.300189393939394	0.682502015036345	0.704243616481573	false	false	false	true
ecd5aab4-a6b3-4876-a8e0-dcd993dd6d33	2026-08-25 10:42	2026-08-25 10:42	2026-08-25 10:42	HOOD	HOOD260828C00100000	call	100.0000	2026-08-28	10.3800	10.2500	10.5250	109.9800	116215.00	22830.00	93385.00	112	6	425	4449	0.0955270847381434	0.802700562774346	0.832915918568492	false	false	false	true
7f1352ec-6eb5-47ab-95fa-ad56f5013da2	2026-08-25 10:38	2026-08-25 10:38	2026-08-25 10:38	HOOD	HOOD260828C00110000	call	110.0000	2026-08-28	3.7200	3.6000	3.7500	110.4550	74373.00	53653.00	20720.00	200	15	10908	15695	0.694998407136031	0.853548731307332	0.873240389684854	true	false	false	true
2cb7bae9-444d-4abc-a74e-ce7b43dd0fd3	2026-08-25 10:36	2026-08-25 10:36	2026-08-25 10:36	HOOD	HOOD261016C00130000	call	130.0000	2026-10-16	4.5600	4.3000	4.6500	109.4400	113900.00	113900.00	0.00	250	5	470	2555	0.183953033268102	0.667796176380944	0.667796176380944	false	false	false	true
7ab6a447-6baa-44f3-84dd-ab00609aef3b	2026-08-25 10:28	2026-08-25 10:28	2026-08-25 10:28	HOOD	HOOD261002C00120000	call	120.0000	2026-10-02	5.0500	4.6500	5.2000	108.5400	50469.00	30469.00	20000.00	100	7	137	269	0.509293680297398	0.648854591747843	0.651141349790016	false	false	false	true
5e18f973-8556-4e27-a9b4-67eb6629f7d0	2026-08-24 15:40	2026-08-24 15:40	2026-08-24 15:40	HOOD	HOOD261120C00135000	call	135.0000	2026-11-20	5.0100	5.0000	5.2000	104.1665	250334.00	0.00	250334.00	500	14	547	793	0.689785624211854	0.671800490093519	0.675300715541602	true	false	false	true
7fe96bb1-d510-411b-8cfe-41678da98e3b	2026-08-24 12:02	2026-08-24 12:02	2026-08-24 12:02	HOOD	HOOD260828P00106000	put	106.0000	2026-08-28	2.8700	2.8600	2.8700	107.0000	160693.00	152971.00	7722.00	560	13	1665	1191	1.39798488664987	0.754949016080054	0.754949016080054	false	false	false	true
245d5ca1-b6ed-4e67-9c8e-40f5136d5926	2026-08-24 12:02	2026-08-24 12:02	2026-08-24 12:02	HOOD	HOOD260828P00107000	put	107.0000	2026-08-28	3.3000	3.3000	3.5000	107.0000	130407.00	0.00	130407.00	395	40	4745	366	12.9644808743169	0.743792947569668	0.743792947569668	false	false	false	true
320d3f13-014d-4684-8c01-df75560d925c	2026-08-21 15:54	2026-08-21 15:54	2026-08-21 15:54	HOOD	HOOD260828C00115000	call	115.0000	2026-08-28	1.9200	1.8400	1.9400	108.1850	61568.00	4604.00	56964.00	321	10	18057	1798	10.0428253615128	0.727395493301803	0.732131465151537	true	false	false	true
ac8ba943-9a33-4374-a7fc-fc0488790a6c	2026-08-21 15:54	2026-08-21 15:54	2026-08-21 15:54	HOOD	HOOD260828C00115000	call	115.0000	2026-08-28	1.8700	1.8100	1.8900	108.1100	65624.00	35310.00	30314.00	350	13	17637	1798	9.80923248053393	0.726644125545103	0.726644125545103	false	false	false	true
c65acfb3-7598-4ce6-b895-227c0361c98a	2026-08-21 14:53	2026-08-21 14:53	2026-08-21 14:53	HOOD	HOOD271217C00120000	call	120.0000	2027-12-17	31.0600	31.0500	32.4500	107.5700	413082.00	0.00	413082.00	133	11	191	5762	0.0331482124262409	0.686239288709203	0.68670894078285	false	false	false	true
ab1f710e-08f9-408b-b011-ab84796a3d9f	2026-08-21 14:49	2026-08-21 14:49	2026-08-21 14:49	HOOD	HOOD260821C00100000	call	100.0000	2026-08-21	7.5000	7.4000	7.8000	107.5800	435051.00	0.00	435051.00	580	15	18967	25167	0.753645647077522	4.34011625858416	4.62949727278803	true	false	false	true
6c7c6ec9-b156-4849-a029-3a9e3f3221b5	2026-08-21 14:32	2026-08-21 14:32	2026-08-21 14:32	HOOD	HOOD280121C00200000	call	200.0000	2028-01-21	16.9400	16.5000	16.9500	108.4750	276140.00	274455.00	1685.00	163	12	622	4045	0.153770086526576	0.692848645908012	0.691043852172614	false	false	false	true
2e60e748-d345-4705-bee1-1d64b408a51c	2026-08-21 10:28	2026-08-21 10:28	2026-08-21 10:28	HOOD	HOOD260911P00101000	put	101.0000	2026-09-11	4.2100	4.2000	4.4000	106.5183	68152.00	0.00	68152.00	162	19	167	292	0.571917808219178	0.674503784388319	0.674503784388319	false	false	false	true
fb8b8b95-3002-4986-92f0-3512f4ab970c	2026-08-21 10:26	2026-08-21 10:26	2026-08-21 10:26	HOOD	HOOD260821C00107000	call	107.0000	2026-08-21	1.2200	1.1800	1.2300	106.2050	61074.00	9224.00	51850.00	500	15	11070	1651	6.70502725620836	1.47829982409275	1.48921146648294	true	false	false	true
5786e2af-d508-4e5e-b68e-72a7df4ad218	2026-08-21 10:20	2026-08-21 10:20	2026-08-21 10:20	HOOD	HOOD260821P00106000	put	106.0000	2026-08-21	1.6200	1.5100	1.6400	105.9500	141783.00	141311.00	472.00	877	84	7754	32	242.3125	1.45305227147714	1.50431871076747	false	false	false	true
cca8a703-4ef4-4440-8217-51430c4fd1d4	2026-08-21 10:20	2026-08-21 10:20	2026-08-21 10:20	HOOD	HOOD260828C00110000	call	110.0000	2026-08-28	3.0600	3.0500	3.1000	106.1600	61242.00	0.00	61242.00	200	9	16612	3983	4.17072558373086	0.786571891543607	0.786571891543607	true	false	false	true
e6319289-be2a-426f-a644-2f60e14a5ed4	2026-08-21 10:16	2026-08-21 10:15	2026-08-21 10:16	HOOD	HOOD270319P00100000	put	100.0000	2027-03-19	17.0600	17.0000	17.6500	106.6500	116035.00	30885.00	85150.00	68	27	78	331	0.235649546827795	0.693091400769798	0.696035267334657	false	false	false	true
08aaf133-e845-4f3a-8d97-6737f08fe076	2026-08-21 10:08	2026-08-21 10:08	2026-08-21 10:08	HOOD	HOOD280121C00100000	call	100.0000	2028-01-21	40.9200	40.5000	41.8500	108.9000	249585.00	122850.00	126735.00	61	7	195	9240	0.0211038961038961	0.705615451981741	0.706100772303312	false	false	false	true
f39f434e-3edc-4e40-87d8-206475affec4	2026-08-21 10:08	2026-08-21 10:07	2026-08-21 10:07	HOOD	HOOD271217C00095000	call	95.0000	2027-12-17	41.8500	41.5500	42.2500	108.9150	133935.00	20975.00	92010.00	32	7	63	3850	0.0163636363636364	0.709704378330896	0.708884944816184	false	false	false	true
01b1c2ba-2668-4161-9511-03202e1cbf2a	2026-08-21 10:06	2026-08-21 10:06	2026-08-21 10:06	HOOD	HOOD260828C00110000	call	110.0000	2026-08-28	4.8600	4.7500	4.9000	109.6486	60273.00	60273.00	0.00	124	10	13765	3983	3.45593773537535	0.820047587005695	0.822242813187157	true	false	false	true
9cf0c0a8-198a-4b8d-b3b8-2ae6edca9a8c	2026-08-21 09:57	2026-08-21 09:57	2026-08-21 09:57	HOOD	HOOD260821C00100000	call	100.0000	2026-08-21	7.6100	7.3000	7.7000	107.5000	114960.00	114960.00	0.00	151	6	11262	25167	0.447490761711765	1.82873443518145	1.96881600135953	true	false	false	true
120f0331-44b9-4786-95c8-2a240f2c190f	2026-08-21 09:54	2026-08-21 09:53	2026-08-21 09:53	HOOD	HOOD260821C00102000	call	102.0000	2026-08-21	5.0800	5.0500	5.2000	106.9100	62980.00	18540.00	16665.00	124	8	6112	11039	0.553673339976447	1.2938188687962	1.49960661508472	false	false	false	true
9aa2240f-a0a0-46e2-bcfa-767aeee2e7ad	2026-08-21 09:44	2026-08-21 09:44	2026-08-21 09:44	HOOD	HOOD270617C00100000	call	100.0000	2027-06-17	30.0200	29.7000	30.2500	106.0750	96065.00	45150.00	50915.00	32	6	486	5616	0.0865384615384615	0.693941203472576	0.693941203472576	false	false	false	true
a6315402-e684-460f-be8c-e08c8ee0b2ee	2026-08-21 09:44	2026-08-21 09:44	2026-08-21 09:44	HOOD	HOOD270617C00100000	call	100.0000	2027-06-17	29.7800	28.8500	30.1000	106.1050	50630.00	20915.00	29715.00	17	6	116	5616	0.0206552706552707	0.686111210950367	0.686111210950367	false	false	false	true
966e1c8a-afd3-4cc0-82b1-59bfb8889846	2026-08-21 09:44	2026-08-21 09:44	2026-08-21 09:44	HOOD	HOOD270617C00100000	call	100.0000	2027-06-17	29.8500	28.8500	30.1000	106.2150	107460.00	53820.00	53640.00	36	12	201	5616	0.0357905982905983	0.687143814044847	0.689744798436285	false	false	false	true
588e0da2-5da4-425e-adb8-c1fa4c550d54	2026-08-21 09:44	2026-08-21 09:44	2026-08-21 09:44	HOOD	HOOD270617C00100000	call	100.0000	2027-06-17	29.8300	28.8500	30.0500	106.1450	53700.00	26910.00	26790.00	18	6	165	5616	0.0293803418803419	0.686382669470233	0.69111859979971	false	false	false	true
286b5e2a-a75e-4b82-8072-aa3e9f0fb8d3	2026-08-21 09:44	2026-08-21 09:44	2026-08-21 09:44	HOOD	HOOD270617C00100000	call	100.0000	2027-06-17	29.7900	28.8500	30.0000	106.1477	83400.00	35880.00	47520.00	28	12	147	5616	0.0261752136752137	0.685425282355973	0.691065611805554	false	false	false	true
6b42f612-622a-4d0c-be46-c288e893cd30	2026-08-21 09:42	2026-08-21 09:42	2026-08-21 09:42	HOOD	HOOD260925C00130000	call	130.0000	2026-09-25	2.2400	1.7400	2.5500	105.1550	51188.00	24946.00	26242.00	229	13	256	273	0.937728937728938	0.683666000839821	0.695825491667463	false	false	false	true
11c82682-ca57-456f-8e20-8bc24afbf31c	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	HOOD	HOOD260904C00107000	call	107.0000	2026-09-04	4.7200	4.4000	4.8000	104.1300	94410.00	94410.00	0.00	200	6	203	174	1.16666666666667	0.722418646335509	0.722418646335509	false	false	false	true
5dd9460d-ae74-4517-a08e-b38087dd869b	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	HOOD	HOOD261218C00120000	call	120.0000	2026-12-18	10.7300	10.2000	10.9000	104.2733	536686.00	536686.00	0.00	500	10	524	8202	0.0638868568641795	0.668784937620118	0.668784937620118	false	false	false	true
d93a8c03-44a2-48ea-a2fe-1f0e285a5de4	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	HOOD	HOOD260904C00110000	call	110.0000	2026-09-04	3.0600	2.9000	3.1000	103.0050	61198.00	61198.00	0.00	200	6	840	2365	0.355179704016913	0.713873675577848	0.70478036380093	false	false	false	true
df3c2dcd-f1d4-41fe-80e9-4eae169d1a36	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	HOOD	HOOD260821C00100000	call	100.0000	2026-08-21	2.6500	2.6200	2.9800	102.3600	62095.00	5088.00	54117.00	234	20	1784	25167	0.0708864783247904	1.11792290705744	1.28881940605677	true	false	false	true
32c1f8af-2e35-4210-ab87-47225418c3c6	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	HOOD	HOOD260828C00106000	call	106.0000	2026-08-28	2.6300	2.1300	2.7000	102.4200	51303.00	29328.00	21975.00	195	15	265	613	0.432300163132137	0.716188217409849	0.726665921546361	true	false	false	true
5c3105b0-0362-44c9-924b-81eb63c1e29b	2026-08-20 12:41	2026-08-20 12:41	2026-08-20 12:41	HOOD	HOOD261016C00110000	call	110.0000	2026-10-16	4.4500	4.2500	4.6500	95.2850	93462.00	445.00	93017.00	210	9	1355	3438	0.39412449098313	0.618208449590732	0.623045682429364	false	false	false	true
d07b0913-ca46-4e25-96fd-7dba47e91c17	2026-08-20 12:19	2026-08-20 12:19	2026-08-20 12:19	HOOD	HOOD270115C00100000	call	100.0000	2027-01-15	13.5800	13.3500	13.7500	94.3700	54310.00	21680.00	32630.00	40	6	241	12900	0.0186821705426357	0.637384353468634	0.639046168140825	false	false	false	true
890a44c1-820a-446d-95b5-2b38314851d8	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	HOOD	HOOD260904C00105000	call	105.0000	2026-09-04	1.8700	1.7400	1.9100	95.3550	93343.00	93343.00	0.00	500	6	1086	1133	0.958517210944395	0.656590426569728	0.656590426569728	false	false	false	true
b6282748-511a-4a6b-99b5-35bdf8d961f5	2026-08-20 10:29	2026-08-20 10:29	2026-08-20 10:29	HOOD	HOOD261016C00110000	call	110.0000	2026-10-16	4.2500	4.2000	4.5000	94.6550	316645.00	0.00	316645.00	745	45	963	3438	0.280104712041885	0.618993321209108	0.618993321209108	false	false	false	true
4e0df00b-b428-47ca-9dad-2b85ac8f283c	2026-08-20 10:26	2026-08-20 10:26	2026-08-20 10:26	HOOD	HOOD260821P00097000	put	97.0000	2026-08-21	2.8300	2.8300	2.9400	95.2300	64526.00	284.00	64242.00	228	25	961	1197	0.802840434419382	0.904942709801527	0.910311471527834	true	false	false	true
63de34a2-4cff-4260-bd1c-9bd020082ea6	2026-08-20 10:08	2026-08-20 10:08	2026-08-20 10:08	HOOD	HOOD260904C00101000	call	101.0000	2026-09-04	3.6500	3.3500	3.8500	97.3300	182399.00	182399.00	0.00	500	6	512	237	2.16033755274262	0.650607916917388	0.650607916917388	false	false	false	true
0684e62e-d787-400d-a03f-8a8d2e693573	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	HOOD	HOOD261002C00125000	call	125.0000	2026-10-02	1.8100	1.0500	2.0000	97.9600	70420.00	70420.00	0.00	390	6	390	86	4.53488372093023	0.644393206411374	0.644393206411374	false	false	false	true
2fd16d29-d0f1-48f6-aa43-7b4348c2e429	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	HOOD	HOOD260904C00110000	call	110.0000	2026-09-04	1.5900	1.4100	1.6400	98.0650	79460.00	79460.00	0.00	500	5	1139	1304	0.873466257668712	0.667879243116555	0.667879243116555	false	false	false	true
0e9dc872-c923-4e24-b781-a32277603b5d	2026-08-19 15:26	2026-08-19 15:26	2026-08-19 15:26	HOOD	HOOD260821C00096000	call	96.0000	2026-08-21	1.8200	1.7400	1.8400	95.5000	81983.00	25985.00	54717.00	450	28	8775	3046	2.88082731451083	0.718450714985167	0.729111978578844	true	false	false	true
334933a8-b048-4536-8575-b86b528d0b92	2026-08-19 15:16	2026-08-19 15:15	2026-08-19 15:15	HOOD	HOOD260821C00096000	call	96.0000	2026-08-21	1.7800	1.7200	1.7900	95.4200	81226.00	81226.00	0.00	457	12	5269	3046	1.72980958634274	0.722569659828576	0.728275301648445	true	false	false	true
e3f5b094-ab45-4802-b777-116914661ed9	2026-08-19 15:14	2026-08-19 15:14	2026-08-19 15:14	HOOD	HOOD260821C00098000	call	98.0000	2026-08-21	1.0600	1.0400	1.1000	95.5000	59802.00	55226.00	4576.00	565	14	8931	4046	2.2073652990608	0.716005682463524	0.716005682463524	false	false	false	true
cd70aeac-f01a-43d2-968c-36479aa37fc1	2026-08-19 15:14	2026-08-19 15:14	2026-08-19 15:14	HOOD	HOOD260821C00097000	call	97.0000	2026-08-21	1.3800	1.3600	1.4250	95.5000	150040.00	133584.00	16456.00	1089	21	5380	3439	1.5644082582146	0.708746954994003	0.708746954994003	false	false	false	true