PREVIEW / stock_1hour / 2013-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-15.parquet
  size:    1.0 MB
  rows:    47,576
  symbols: 3,551

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-08-15 04:00:00	AAPL	Stock	17.7414	17.8925	17.7414	17.8461	93996.0
2013-08-15 05:00:00	AAPL	Stock	17.8571	17.8818	17.8471	17.875	92960.0
2013-08-15 06:00:00	AAPL	Stock	17.875	17.8854	17.8286	17.8286	162904.0
2013-08-15 07:00:00	AAPL	Stock	17.8214	17.855	17.7536	17.7657	1160124.0
2013-08-15 08:00:00	AAPL	Stock	17.7554	17.8557	17.5932	17.6286	6500592.0
2013-08-15 09:00:00	AAPL	Stock	17.6343	17.85	17.6296	17.7329	100454228.0
2013-08-15 10:00:00	AAPL	Stock	17.7264	17.7618	17.6379	17.7152	75845196.0
2013-08-15 11:00:00	AAPL	Stock	17.7089	17.9214	17.6936	17.8754	74523484.0
2013-08-15 12:00:00	AAPL	Stock	17.8719	17.9428	17.8493	17.9111	38382064.0
2013-08-15 13:00:00	AAPL	Stock	17.9071	17.9179	17.77	17.8182	44431212.0
2013-08-15 14:00:00	AAPL	Stock	17.8175	17.8839	17.7704	17.8554	37336320.0
2013-08-15 15:00:00	AAPL	Stock	17.8571	17.8575	17.7372	17.782	55981352.0
2013-08-15 16:00:00	AAPL	Stock	17.7854	17.8933	17.7611	17.7711	42610540.0
2013-08-15 17:00:00	AAPL	Stock	17.7893	17.7893	17.7696	17.7818	471324.0
2013-08-15 18:00:00	AAPL	Stock	17.7821	17.8018	17.7786	17.7857	346584.0
2013-08-15 19:00:00	AAPL	Stock	17.7918	17.8054	17.7789	17.7911	179872.0
2013-08-15 05:00:00	MSFT	Stock	32.22	32.22	32.2	32.2	1700.0
2013-08-15 06:00:00	MSFT	Stock	32.1	32.1	32.1	32.1	200.0
2013-08-15 07:00:00	MSFT	Stock	32.12	32.12	32.01	32.01	892.0
2013-08-15 08:00:00	MSFT	Stock	32.01	32.15	32.01	32.02	72477.0
2013-08-15 09:00:00	MSFT	Stock	32.0	32.18	31.75	31.818	4502053.0
2013-08-15 10:00:00	MSFT	Stock	31.81	31.885	31.66	31.775	7655957.0
2013-08-15 11:00:00	MSFT	Stock	31.78	32.0	31.77	31.83	4037752.0
2013-08-15 12:00:00	MSFT	Stock	31.84	31.97	31.822	31.84	2469619.0
2013-08-15 13:00:00	MSFT	Stock	31.84	31.87	30.84	31.765	2384043.0
2013-08-15 14:00:00	MSFT	Stock	31.76	31.83	31.65	31.79	3403396.0
2013-08-15 15:00:00	MSFT	Stock	31.795	31.83	31.68	31.78	4982595.0
2013-08-15 16:00:00	MSFT	Stock	31.76	31.807	31.72	31.79	1356555.0
2013-08-15 17:00:00	MSFT	Stock	31.79	31.79	31.592	31.592	196621.0
2013-08-15 18:00:00	MSFT	Stock	31.78	31.78	31.67	31.67	2637.0
2013-08-15 19:00:00	MSFT	Stock	31.72	31.72	31.72	31.72	100.0
2013-08-15 08:00:00	NVDA	Stock	0.3725	0.373	0.3725	0.3725	44000.0
2013-08-15 09:00:00	NVDA	Stock	0.37	0.3738	0.37	0.3738	37203160.0
2013-08-15 10:00:00	NVDA	Stock	0.3735	0.3805	0.3734	0.3793	160534640.0
2013-08-15 11:00:00	NVDA	Stock	0.379	0.3813	0.377	0.379	118076040.0
2013-08-15 12:00:00	NVDA	Stock	0.379	0.3793	0.376	0.376	60312240.0
2013-08-15 13:00:00	NVDA	Stock	0.376	0.3773	0.3758	0.3763	49263040.0
2013-08-15 14:00:00	NVDA	Stock	0.3763	0.377	0.3758	0.3765	68761960.0
2013-08-15 15:00:00	NVDA	Stock	0.3765	0.3793	0.3763	0.3783	215859760.0
2013-08-15 16:00:00	NVDA	Stock	0.378	0.3788	0.3774	0.3783	11013240.0
2013-08-15 17:00:00	NVDA	Stock	0.378	0.378	0.378	0.378	78200.0
2013-08-15 06:00:00	AMZN	Stock	14.537	14.542	14.522	14.522	10000.0
2013-08-15 07:00:00	AMZN	Stock	14.528	14.528	14.5105	14.5105	34000.0
2013-08-15 08:00:00	AMZN	Stock	14.515	14.525	14.4635	14.4895	261800.0
2013-08-15 09:00:00	AMZN	Stock	14.494	14.4945	14.3146	14.3325	8662260.0
2013-08-15 10:00:00	AMZN	Stock	14.3335	14.372	14.2575	14.316	9068520.0
2013-08-15 11:00:00	AMZN	Stock	14.315	14.4045	14.3065	14.3758	5628400.0
2013-08-15 12:00:00	AMZN	Stock	14.3762	14.405	14.314	14.315	3283500.0
2013-08-15 13:00:00	AMZN	Stock	14.315	14.336	14.266	14.32	4248760.0
2013-08-15 14:00:00	AMZN	Stock	14.32	14.361	14.287	14.3215	4570420.0

> showing 50 of 47,576 rows — these rows as CSV

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