PREVIEW / stock_1hour / 2013-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-25.parquet
  size:    960 KB
  rows:    45,037
  symbols: 3,469

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
2013-01-25 04:00:00	AAPL	Stock	16.0711	16.1964	16.0711	16.1964	398356.0
2013-01-25 05:00:00	AAPL	Stock	16.1839	16.1911	16.125	16.1429	141260.0
2013-01-25 06:00:00	AAPL	Stock	16.1493	16.1679	16.125	16.1429	156044.0
2013-01-25 07:00:00	AAPL	Stock	16.1307	16.1996	16.1221	16.1821	1950340.0
2013-01-25 08:00:00	AAPL	Stock	16.1871	16.2118	16.1161	16.1696	5899236.0
2013-01-25 09:00:00	AAPL	Stock	16.1686	16.2939	16.0143	16.1704	165614736.0
2013-01-25 10:00:00	AAPL	Stock	16.1768	16.1982	15.8636	15.9202	172755576.0
2013-01-25 11:00:00	AAPL	Stock	15.92	15.9864	15.7346	15.7471	136385424.0
2013-01-25 12:00:00	AAPL	Stock	15.75	15.7986	15.6182	15.6796	178824912.0
2013-01-25 13:00:00	AAPL	Stock	15.6793	15.9736	15.6471	15.9025	185706920.0
2013-01-25 14:00:00	AAPL	Stock	15.9054	15.9764	15.7775	15.9286	113646288.0
2013-01-25 15:00:00	AAPL	Stock	15.9286	15.9864	15.5357	15.7089	176909544.0
2013-01-25 16:00:00	AAPL	Stock	15.7089	16.0016	15.6404	15.6879	40972008.0
2013-01-25 17:00:00	AAPL	Stock	15.6875	15.9243	15.6875	15.7214	1993992.0
2013-01-25 18:00:00	AAPL	Stock	15.7214	15.7375	15.7	15.7286	440748.0
2013-01-25 19:00:00	AAPL	Stock	15.7268	15.75	15.7232	15.75	449288.0
2013-01-25 04:00:00	MSFT	Stock	27.27	27.27	27.27	27.27	100.0
2013-01-25 05:00:00	MSFT	Stock	27.25	27.25	27.19	27.19	7170.0
2013-01-25 06:00:00	MSFT	Stock	27.35	27.35	27.35	27.35	220.0
2013-01-25 07:00:00	MSFT	Stock	27.21	27.42	27.21	27.4	45580.0
2013-01-25 08:00:00	MSFT	Stock	27.37	27.63	27.25	27.45	453546.0
2013-01-25 09:00:00	MSFT	Stock	27.45	28.23	27.37	28.18	20202180.0
2013-01-25 10:00:00	MSFT	Stock	28.17	28.19	27.71	27.9	17519824.0
2013-01-25 11:00:00	MSFT	Stock	27.895	27.99	27.85	27.85	8902930.0
2013-01-25 12:00:00	MSFT	Stock	27.85	27.91	27.8	27.862	6410832.0
2013-01-25 13:00:00	MSFT	Stock	27.865	27.94	27.84	27.925	5060377.0
2013-01-25 14:00:00	MSFT	Stock	27.925	27.97	27.89	27.92	5654948.0
2013-01-25 15:00:00	MSFT	Stock	27.915	27.929	27.68	27.885	13142099.0
2013-01-25 16:00:00	MSFT	Stock	27.88	28.156	27.745	27.85	3143600.0
2013-01-25 17:00:00	MSFT	Stock	27.88	27.9	27.82	27.89	36567.0
2013-01-25 18:00:00	MSFT	Stock	27.84	27.89	27.84	27.89	2741.0
2013-01-25 19:00:00	MSFT	Stock	27.89	27.89	27.86	27.89	3460.0
2013-01-25 08:00:00	NVDA	Stock	0.3062	0.3085	0.3062	0.3085	292000.0
2013-01-25 09:00:00	NVDA	Stock	0.3078	0.3088	0.305	0.307	33766600.0
2013-01-25 10:00:00	NVDA	Stock	0.307	0.3075	0.3045	0.3046	41455680.0
2013-01-25 11:00:00	NVDA	Stock	0.3045	0.3058	0.3038	0.3052	53658680.0
2013-01-25 12:00:00	NVDA	Stock	0.3048	0.3075	0.3048	0.3075	35045240.0
2013-01-25 13:00:00	NVDA	Stock	0.3075	0.3095	0.3073	0.309	58437000.0
2013-01-25 14:00:00	NVDA	Stock	0.309	0.3105	0.3088	0.3098	55310480.0
2013-01-25 15:00:00	NVDA	Stock	0.3098	0.3105	0.3095	0.3104	100951000.0
2013-01-25 16:00:00	NVDA	Stock	0.3103	0.3105	0.308	0.3103	14917520.0
2013-01-25 17:00:00	NVDA	Stock	0.3103	0.3103	0.3064	0.3064	60000.0
2013-01-25 07:00:00	AMZN	Stock	13.795	13.795	13.751	13.751	4000.0
2013-01-25 08:00:00	AMZN	Stock	13.7515	13.7625	13.7025	13.73	184580.0
2013-01-25 09:00:00	AMZN	Stock	13.73	13.8185	13.718	13.785	10407920.0
2013-01-25 10:00:00	AMZN	Stock	13.782	13.879	13.765	13.8355	16043900.0
2013-01-25 11:00:00	AMZN	Stock	13.8318	13.8875	13.8318	13.8595	10942900.0
2013-01-25 12:00:00	AMZN	Stock	13.854	14.0655	13.854	14.024	13457900.0
2013-01-25 13:00:00	AMZN	Stock	14.0265	14.188	14.0225	14.1818	14930660.0
2013-01-25 14:00:00	AMZN	Stock	14.1808	14.236	14.1215	14.1566	12349000.0

> showing 50 of 45,037 rows — these rows as CSV

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