PREVIEW / stock_1hour / 2004-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-12.parquet
  size:    508 KB
  rows:    23,403
  symbols: 1,713

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2004-01-12 08:00:00	AAPL	Stock	0.4155	0.4196	0.4134	0.4177	604800.0
2004-01-12 09:00:00	AAPL	Stock	0.417	0.4182	0.4109	0.4161	48520528.0
2004-01-12 10:00:00	AAPL	Stock	0.4161	0.425	0.4152	0.4238	146273344.0
2004-01-12 11:00:00	AAPL	Stock	0.4241	0.4248	0.4216	0.4239	49735896.0
2004-01-12 12:00:00	AAPL	Stock	0.4241	0.4255	0.4213	0.4236	33140744.0
2004-01-12 13:00:00	AAPL	Stock	0.4238	0.4241	0.4211	0.423	17290840.0
2004-01-12 14:00:00	AAPL	Stock	0.4232	0.4239	0.4196	0.4223	36970640.0
2004-01-12 15:00:00	AAPL	Stock	0.4223	0.4286	0.422	0.4241	110162528.0
2004-01-12 16:00:00	AAPL	Stock	0.425	0.427	0.4238	0.4238	7952504.0
2004-01-12 17:00:00	AAPL	Stock	0.425	0.425	0.4238	0.425	61600.0
2004-01-12 18:00:00	AAPL	Stock	0.4254	0.4254	0.4254	0.4254	280000.0
2004-01-12 08:00:00	MSFT	Stock	27.7	27.8	27.7	27.7	46100.0
2004-01-12 09:00:00	MSFT	Stock	27.7	27.74	27.46	27.47	6733826.0
2004-01-12 10:00:00	MSFT	Stock	27.469	27.56	27.39	27.43	13615178.0
2004-01-12 11:00:00	MSFT	Stock	27.43	27.49	27.35	27.45	9518130.0
2004-01-12 12:00:00	MSFT	Stock	27.46	27.6	27.45	27.51	4952590.0
2004-01-12 13:00:00	MSFT	Stock	27.52	27.6	27.45	27.54	3770816.0
2004-01-12 14:00:00	MSFT	Stock	27.54	27.57	27.46	27.54	5275022.0
2004-01-12 15:00:00	MSFT	Stock	27.54	27.64	27.5	27.57	7764572.0
2004-01-12 16:00:00	MSFT	Stock	27.56	27.61	27.54	27.58	1581387.0
2004-01-12 17:00:00	MSFT	Stock	27.57	27.58	27.55	27.56	25677.0
2004-01-12 18:00:00	MSFT	Stock	27.56	27.57	27.52	27.52	15093.0
2004-01-12 08:00:00	NVDA	Stock	0.2128	0.2129	0.2128	0.2129	240000.0
2004-01-12 09:00:00	NVDA	Stock	0.2129	0.2133	0.211	0.212	89882520.0
2004-01-12 10:00:00	NVDA	Stock	0.2118	0.2134	0.2114	0.2122	99066840.0
2004-01-12 11:00:00	NVDA	Stock	0.2122	0.2127	0.2117	0.2126	46004880.0
2004-01-12 12:00:00	NVDA	Stock	0.2124	0.2132	0.2122	0.2122	28428360.0
2004-01-12 13:00:00	NVDA	Stock	0.2122	0.2129	0.2112	0.2129	45138720.0
2004-01-12 14:00:00	NVDA	Stock	0.2128	0.2132	0.2117	0.2129	42958800.0
2004-01-12 15:00:00	NVDA	Stock	0.2128	0.2153	0.2125	0.2145	128950560.0
2004-01-12 16:00:00	NVDA	Stock	0.2145	0.2154	0.2139	0.2142	9237000.0
2004-01-12 17:00:00	NVDA	Stock	0.2144	0.2144	0.2144	0.2144	36000.0
2004-01-12 08:00:00	AMZN	Stock	2.58	2.5986	2.58	2.585	76000.0
2004-01-12 09:00:00	AMZN	Stock	2.5875	2.607	2.5735	2.5775	23486980.0
2004-01-12 10:00:00	AMZN	Stock	2.5775	2.58	2.54	2.5575	39849300.0
2004-01-12 11:00:00	AMZN	Stock	2.5575	2.564	2.552	2.56	16326840.0
2004-01-12 12:00:00	AMZN	Stock	2.5605	2.593	2.5585	2.5835	23558400.0
2004-01-12 13:00:00	AMZN	Stock	2.5835	2.597	2.577	2.588	14140260.0
2004-01-12 14:00:00	AMZN	Stock	2.588	2.6	2.57	2.597	17132420.0
2004-01-12 15:00:00	AMZN	Stock	2.597	2.65	2.594	2.65	48087280.0
2004-01-12 16:00:00	AMZN	Stock	2.65	2.6515	2.6405	2.6425	2813520.0
2004-01-12 17:00:00	AMZN	Stock	2.6425	2.648	2.6275	2.648	70000.0
2004-01-12 18:00:00	AMZN	Stock	2.645	2.645	2.645	2.645	8000.0
2004-01-12 09:00:00	CL	Stock	25.29	25.32	25.21	25.25	611000.0
2004-01-12 10:00:00	CL	Stock	25.245	25.275	25.15	25.25	894000.0
2004-01-12 11:00:00	CL	Stock	25.25	25.25	25.05	25.125	948200.0
2004-01-12 12:00:00	CL	Stock	25.12	25.19	25.1	25.185	1024600.0
2004-01-12 13:00:00	CL	Stock	25.185	25.265	25.18	25.195	557400.0
2004-01-12 14:00:00	CL	Stock	25.2	25.255	25.165	25.255	666800.0
2004-01-12 15:00:00	CL	Stock	25.255	25.26	25.155	25.2	1111000.0

> showing 50 of 23,403 rows — these rows as CSV

> unlock the full archive -- $79 one-time