PREVIEW / stock_1hour / 2008-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-04.parquet
  size:    829 KB
  rows:    41,382
  symbols: 3,316

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
2008-11-04 05:00:00	AAPL	Stock	3.8904	3.8904	3.8904	3.8904	8400.0
2008-11-04 06:00:00	AAPL	Stock	3.8786	3.9239	3.8786	3.9239	16800.0
2008-11-04 07:00:00	AAPL	Stock	3.9239	3.9268	3.8911	3.8911	962080.0
2008-11-04 08:00:00	AAPL	Stock	3.8918	3.9029	3.8696	3.8982	4802728.0
2008-11-04 09:00:00	AAPL	Stock	3.8989	3.9282	3.8096	3.8321	172760588.0
2008-11-04 10:00:00	AAPL	Stock	3.8321	3.8814	3.8204	3.8536	202119736.0
2008-11-04 11:00:00	AAPL	Stock	3.8536	3.9264	3.8336	3.9157	223891052.0
2008-11-04 12:00:00	AAPL	Stock	3.9157	3.9554	3.9018	3.9268	171168564.0
2008-11-04 13:00:00	AAPL	Stock	3.9271	3.9925	3.9214	3.9732	148548064.0
2008-11-04 14:00:00	AAPL	Stock	3.9729	3.9743	3.9057	3.9129	159972820.0
2008-11-04 15:00:00	AAPL	Stock	3.9132	3.9696	3.88	3.9589	260673980.0
2008-11-04 16:00:00	AAPL	Stock	3.9589	3.9671	3.903	3.9546	22005312.0
2008-11-04 17:00:00	AAPL	Stock	3.9568	3.9625	3.9568	3.9604	254296.0
2008-11-04 18:00:00	AAPL	Stock	3.9604	3.9643	3.9279	3.9632	837312.0
2008-11-04 19:00:00	AAPL	Stock	3.9632	3.9729	3.9618	3.9714	475048.0
2008-11-04 20:00:00	AAPL	Stock	3.9696	3.9696	3.9696	3.9696	2800.0
2008-11-04 07:00:00	MSFT	Stock	23.0	23.05	23.0	23.05	2600.0
2008-11-04 08:00:00	MSFT	Stock	23.04	23.19	22.62	23.16	68411.0
2008-11-04 09:00:00	MSFT	Stock	23.15	23.24	22.9	22.97	6226701.0
2008-11-04 10:00:00	MSFT	Stock	22.97	23.36	22.87	23.34	10484880.0
2008-11-04 11:00:00	MSFT	Stock	23.34	23.66	23.0	23.6	9792278.0
2008-11-04 12:00:00	MSFT	Stock	23.6	23.63	23.35	23.39	5211973.0
2008-11-04 13:00:00	MSFT	Stock	23.39	23.5	23.15	23.4	6959840.0
2008-11-04 14:00:00	MSFT	Stock	23.4	23.46	23.06	23.14	7790625.0
2008-11-04 15:00:00	MSFT	Stock	23.13	23.62	23.0	23.54	19894316.0
2008-11-04 16:00:00	MSFT	Stock	23.53	23.554	23.225	23.5	3973464.0
2008-11-04 17:00:00	MSFT	Stock	23.46	23.53	23.42	23.5	13688.0
2008-11-04 18:00:00	MSFT	Stock	23.52	23.546	23.52	23.54	65430.0
2008-11-04 19:00:00	MSFT	Stock	23.54	23.55	23.53	23.53	6090.0
2008-11-04 08:00:00	NVDA	Stock	0.2215	0.2215	0.2195	0.22	373400.0
2008-11-04 09:00:00	NVDA	Stock	0.22	0.2223	0.2125	0.2175	67291360.0
2008-11-04 10:00:00	NVDA	Stock	0.2175	0.2225	0.2152	0.221	113928960.0
2008-11-04 11:00:00	NVDA	Stock	0.221	0.2235	0.2195	0.2224	87851000.0
2008-11-04 12:00:00	NVDA	Stock	0.2223	0.2235	0.2198	0.2235	55014800.0
2008-11-04 13:00:00	NVDA	Stock	0.2232	0.224	0.2208	0.2218	63127240.0
2008-11-04 14:00:00	NVDA	Stock	0.222	0.222	0.2185	0.2196	68467680.0
2008-11-04 15:00:00	NVDA	Stock	0.2195	0.2243	0.218	0.2243	140527800.0
2008-11-04 16:00:00	NVDA	Stock	0.2243	0.2245	0.219	0.223	14458160.0
2008-11-04 17:00:00	NVDA	Stock	0.2208	0.2245	0.2208	0.2245	1433000.0
2008-11-04 18:00:00	NVDA	Stock	0.2232	0.2232	0.2232	0.2232	5000.0
2008-11-04 19:00:00	NVDA	Stock	0.2245	0.2245	0.2243	0.2243	16200.0
2008-11-04 07:00:00	AMZN	Stock	2.7285	2.7285	2.7285	2.7285	6000.0
2008-11-04 08:00:00	AMZN	Stock	2.825	2.85	2.825	2.84	23000.0
2008-11-04 09:00:00	AMZN	Stock	2.84	2.8995	2.767	2.7705	17746020.0
2008-11-04 10:00:00	AMZN	Stock	2.7725	2.86	2.761	2.8398	24002900.0
2008-11-04 11:00:00	AMZN	Stock	2.841	2.923	2.84	2.9175	27006860.0
2008-11-04 12:00:00	AMZN	Stock	2.9185	2.9295	2.864	2.906	15545600.0
2008-11-04 13:00:00	AMZN	Stock	2.9055	2.9145	2.8795	2.8905	12494600.0
2008-11-04 14:00:00	AMZN	Stock	2.892	2.9015	2.8595	2.8725	15046540.0
2008-11-04 15:00:00	AMZN	Stock	2.872	2.9365	2.8485	2.925	33000480.0

> showing 50 of 41,382 rows — these rows as CSV

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