PREVIEW / stock_1hour / 2011-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-15.parquet
  size:    925 KB
  rows:    44,249
  symbols: 3,548

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
2011-12-15 04:00:00	AAPL	Stock	13.5393	13.63	13.5393	13.63	50400.0
2011-12-15 06:00:00	AAPL	Stock	13.6439	13.6439	13.6439	13.6439	15792.0
2011-12-15 07:00:00	AAPL	Stock	13.6436	13.7143	13.6393	13.705	711872.0
2011-12-15 08:00:00	AAPL	Stock	13.6943	13.7321	13.6743	13.7214	2420712.0
2011-12-15 09:00:00	AAPL	Stock	13.7196	13.7211	13.5893	13.6121	40652164.0
2011-12-15 10:00:00	AAPL	Stock	13.6136	13.6379	13.554	13.5793	50399552.0
2011-12-15 11:00:00	AAPL	Stock	13.5789	13.5996	13.5264	13.5446	31042732.0
2011-12-15 12:00:00	AAPL	Stock	13.5461	13.5931	13.5407	13.5572	23034620.0
2011-12-15 13:00:00	AAPL	Stock	13.5586	13.5804	13.5429	13.5646	18847808.0
2011-12-15 14:00:00	AAPL	Stock	13.5629	13.5768	13.5389	13.5418	25108412.0
2011-12-15 15:00:00	AAPL	Stock	13.5421	13.5593	13.5111	13.5314	50516368.0
2011-12-15 16:00:00	AAPL	Stock	13.5325	13.5793	13.5261	13.5436	11832408.0
2011-12-15 17:00:00	AAPL	Stock	13.5443	13.5529	13.5429	13.5521	86324.0
2011-12-15 18:00:00	AAPL	Stock	13.5336	13.5536	13.5336	13.5536	63112.0
2011-12-15 19:00:00	AAPL	Stock	13.5536	13.5714	13.5536	13.5714	182224.0
2011-12-15 08:00:00	MSFT	Stock	25.72	25.82	25.67	25.78	13824.0
2011-12-15 09:00:00	MSFT	Stock	25.8	25.88	25.59	25.785	6035982.0
2011-12-15 10:00:00	MSFT	Stock	25.78	25.82	25.62	25.66	6086184.0
2011-12-15 11:00:00	MSFT	Stock	25.665	25.71	25.56	25.64	5277850.0
2011-12-15 12:00:00	MSFT	Stock	25.64	25.72	25.63	25.72	4828186.0
2011-12-15 13:00:00	MSFT	Stock	25.71	25.74	25.655	25.7	4632898.0
2011-12-15 14:00:00	MSFT	Stock	25.7	25.735	25.645	25.65	4259013.0
2011-12-15 15:00:00	MSFT	Stock	25.65	25.78	25.54	25.57	9899012.0
2011-12-15 16:00:00	MSFT	Stock	25.55	25.705	25.534	25.55	4396739.0
2011-12-15 17:00:00	MSFT	Stock	25.705	25.705	25.56	25.6	100626.0
2011-12-15 18:00:00	MSFT	Stock	25.6	25.6	25.56	25.56	5859.0
2011-12-15 19:00:00	MSFT	Stock	25.63	25.65	25.63	25.65	3099.0
2011-12-15 06:00:00	NVDA	Stock	0.3578	0.358	0.3578	0.358	32000.0
2011-12-15 07:00:00	NVDA	Stock	0.3545	0.3545	0.3545	0.3545	4000.0
2011-12-15 08:00:00	NVDA	Stock	0.3473	0.3485	0.345	0.3485	225200.0
2011-12-15 09:00:00	NVDA	Stock	0.3485	0.3485	0.3408	0.3413	52266960.0
2011-12-15 10:00:00	NVDA	Stock	0.3413	0.3445	0.34	0.3413	65561240.0
2011-12-15 11:00:00	NVDA	Stock	0.3413	0.342	0.338	0.3388	45317640.0
2011-12-15 12:00:00	NVDA	Stock	0.3388	0.3395	0.338	0.3395	38628560.0
2011-12-15 13:00:00	NVDA	Stock	0.3395	0.3425	0.3393	0.34	47471000.0
2011-12-15 14:00:00	NVDA	Stock	0.3398	0.3402	0.336	0.3362	50662080.0
2011-12-15 15:00:00	NVDA	Stock	0.3362	0.3385	0.3358	0.3368	111251000.0
2011-12-15 16:00:00	NVDA	Stock	0.337	0.3398	0.3357	0.3365	1809560.0
2011-12-15 17:00:00	NVDA	Stock	0.34	0.34	0.3377	0.3377	506560.0
2011-12-15 18:00:00	NVDA	Stock	0.3365	0.3365	0.3365	0.3365	203440.0
2011-12-15 19:00:00	NVDA	Stock	0.3398	0.34	0.3398	0.3398	124000.0
2011-12-15 06:00:00	AMZN	Stock	9.06	9.06	9.06	9.06	2000.0
2011-12-15 07:00:00	AMZN	Stock	9.025	9.0725	9.025	9.0625	20000.0
2011-12-15 08:00:00	AMZN	Stock	9.0625	9.1225	9.055	9.11	883980.0
2011-12-15 09:00:00	AMZN	Stock	9.114	9.24	9.054	9.152	46253960.0
2011-12-15 10:00:00	AMZN	Stock	9.152	9.171	8.9765	9.0155	25291740.0
2011-12-15 11:00:00	AMZN	Stock	9.0175	9.1275	9.0154	9.0635	18836160.0
2011-12-15 12:00:00	AMZN	Stock	9.068	9.165	9.0635	9.1515	12283360.0
2011-12-15 13:00:00	AMZN	Stock	9.151	9.1875	9.0845	9.095	11666580.0
2011-12-15 14:00:00	AMZN	Stock	9.096	9.1294	9.081	9.096	7095660.0

> showing 50 of 44,249 rows — these rows as CSV

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