PREVIEW / stock_1hour / 2011-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-27.parquet
  size:    939 KB
  rows:    44,646
  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
2011-06-27 04:00:00	AAPL	Stock	11.6789	11.6789	11.6789	11.6789	8400.0
2011-06-27 05:00:00	AAPL	Stock	11.7046	11.7046	11.6839	11.6839	5600.0
2011-06-27 06:00:00	AAPL	Stock	11.7104	11.7232	11.7104	11.7143	36400.0
2011-06-27 07:00:00	AAPL	Stock	11.7082	11.7661	11.7082	11.7446	700420.0
2011-06-27 08:00:00	AAPL	Stock	11.7457	11.75	11.7143	11.7343	1296932.0
2011-06-27 09:00:00	AAPL	Stock	11.7339	11.7975	11.6864	11.7739	53803960.0
2011-06-27 10:00:00	AAPL	Stock	11.7771	11.8529	11.7589	11.8175	53487028.0
2011-06-27 11:00:00	AAPL	Stock	11.8182	11.8714	11.8143	11.8679	35365680.0
2011-06-27 12:00:00	AAPL	Stock	11.8675	11.8846	11.843	11.8722	28195524.0
2011-06-27 13:00:00	AAPL	Stock	11.8728	11.8911	11.85	11.8686	25759580.0
2011-06-27 14:00:00	AAPL	Stock	11.8693	11.925	11.8686	11.8964	39067784.0
2011-06-27 15:00:00	AAPL	Stock	11.8971	11.9107	11.8514	11.86	57296288.0
2011-06-27 16:00:00	AAPL	Stock	11.8586	11.8862	11.8389	11.8679	39344564.0
2011-06-27 17:00:00	AAPL	Stock	11.8704	11.8732	11.8693	11.8714	104832.0
2011-06-27 18:00:00	AAPL	Stock	11.8707	11.8864	11.8586	11.8714	566020.0
2011-06-27 19:00:00	AAPL	Stock	11.8786	11.8857	11.8732	11.8857	110852.0
2011-06-27 06:00:00	MSFT	Stock	24.39	24.39	24.39	24.39	800.0
2011-06-27 07:00:00	MSFT	Stock	24.35	24.36	24.35	24.36	2847.0
2011-06-27 08:00:00	MSFT	Stock	24.37	24.37	24.29	24.29	44625.0
2011-06-27 09:00:00	MSFT	Stock	24.31	24.7	24.22	24.675	7131944.0
2011-06-27 10:00:00	MSFT	Stock	24.68	25.04	24.67	25.015	16003853.0
2011-06-27 11:00:00	MSFT	Stock	25.01	25.289	25.0	25.26	12056089.0
2011-06-27 12:00:00	MSFT	Stock	25.25	25.29	25.19	25.27	9731373.0
2011-06-27 13:00:00	MSFT	Stock	25.27	25.295	25.23	25.27	6703246.0
2011-06-27 14:00:00	MSFT	Stock	25.28	25.405	25.272	25.38	9053963.0
2011-06-27 15:00:00	MSFT	Stock	25.375	25.46	25.18	25.19	20105662.0
2011-06-27 16:00:00	MSFT	Stock	25.18	25.418	25.126	25.28	10699839.0
2011-06-27 17:00:00	MSFT	Stock	25.29	25.29	25.25	25.28	4500.0
2011-06-27 18:00:00	MSFT	Stock	25.28	25.28	25.2	25.28	98012.0
2011-06-27 19:00:00	MSFT	Stock	25.27	25.29	25.27	25.29	6445.0
2011-06-27 04:00:00	NVDA	Stock	0.4148	0.415	0.4072	0.4072	28000.0
2011-06-27 06:00:00	NVDA	Stock	0.3955	0.3955	0.3955	0.3955	4000.0
2011-06-27 08:00:00	NVDA	Stock	0.395	0.3958	0.395	0.3958	72000.0
2011-06-27 09:00:00	NVDA	Stock	0.395	0.396	0.3833	0.3888	97713920.0
2011-06-27 10:00:00	NVDA	Stock	0.389	0.3913	0.386	0.3878	90632440.0
2011-06-27 11:00:00	NVDA	Stock	0.388	0.389	0.383	0.3845	109090800.0
2011-06-27 12:00:00	NVDA	Stock	0.3845	0.3875	0.3775	0.3778	162740760.0
2011-06-27 13:00:00	NVDA	Stock	0.3775	0.382	0.3715	0.3818	312101160.0
2011-06-27 14:00:00	NVDA	Stock	0.382	0.388	0.3818	0.3838	182589920.0
2011-06-27 15:00:00	NVDA	Stock	0.3838	0.3868	0.3833	0.3853	164350400.0
2011-06-27 16:00:00	NVDA	Stock	0.3853	0.3853	0.3824	0.3853	13744120.0
2011-06-27 17:00:00	NVDA	Stock	0.385	0.385	0.3833	0.3842	59200.0
2011-06-27 18:00:00	NVDA	Stock	0.3842	0.3853	0.3842	0.3853	218400.0
2011-06-27 19:00:00	NVDA	Stock	0.3853	0.3853	0.3853	0.3853	400480.0
2011-06-27 04:00:00	AMZN	Stock	9.648	9.65	9.648	9.65	10000.0
2011-06-27 06:00:00	AMZN	Stock	9.7505	9.7505	9.7175	9.7255	12000.0
2011-06-27 07:00:00	AMZN	Stock	9.7255	9.769	9.7255	9.751	140000.0
2011-06-27 08:00:00	AMZN	Stock	9.7525	9.772	9.7125	9.7215	409820.0
2011-06-27 09:00:00	AMZN	Stock	9.7195	9.8625	9.7015	9.8555	19690380.0
2011-06-27 10:00:00	AMZN	Stock	9.8565	9.93	9.8435	9.918	16109740.0

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

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