PREVIEW / stock_1hour / 2012-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-30.parquet
  size:    888 KB
  rows:    42,024
  symbols: 3,429

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
2012-08-30 04:00:00	AAPL	Stock	24.0268	24.0268	24.0	24.0107	14000.0
2012-08-30 05:00:00	AAPL	Stock	23.9821	23.9893	23.9768	23.9893	42000.0
2012-08-30 06:00:00	AAPL	Stock	23.9768	23.9768	23.9318	23.9325	224812.0
2012-08-30 07:00:00	AAPL	Stock	23.9464	24.0293	23.9464	23.9768	235340.0
2012-08-30 08:00:00	AAPL	Stock	23.9957	24.0464	23.9643	23.9664	1109528.0
2012-08-30 09:00:00	AAPL	Stock	23.9664	23.9841	23.8661	23.8971	53802448.0
2012-08-30 10:00:00	AAPL	Stock	23.8968	23.9196	23.7932	23.8357	61268564.0
2012-08-30 11:00:00	AAPL	Stock	23.8325	23.9093	23.8221	23.8529	26247788.0
2012-08-30 12:00:00	AAPL	Stock	23.8564	23.8786	23.7889	23.7982	18837308.0
2012-08-30 13:00:00	AAPL	Stock	23.7954	23.7982	23.6875	23.765	39954096.0
2012-08-30 14:00:00	AAPL	Stock	23.7668	23.8071	23.7282	23.8011	22977248.0
2012-08-30 15:00:00	AAPL	Stock	23.8011	23.8346	23.6733	23.7111	48592348.0
2012-08-30 16:00:00	AAPL	Stock	23.7164	23.8245	23.6857	23.7096	20450024.0
2012-08-30 17:00:00	AAPL	Stock	23.7179	23.7214	23.6964	23.7	394324.0
2012-08-30 18:00:00	AAPL	Stock	23.7	23.7018	23.6911	23.6964	163072.0
2012-08-30 19:00:00	AAPL	Stock	23.6936	23.7161	23.6832	23.6839	232904.0
2012-08-30 05:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	100.0
2012-08-30 07:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	500.0
2012-08-30 08:00:00	MSFT	Stock	30.68	30.68	30.54	30.56	5900.0
2012-08-30 09:00:00	MSFT	Stock	30.56	30.67	30.35	30.37	3032988.0
2012-08-30 10:00:00	MSFT	Stock	30.36	30.38	30.22	30.31	5181072.0
2012-08-30 11:00:00	MSFT	Stock	30.31	30.34	30.24	30.27	2975290.0
2012-08-30 12:00:00	MSFT	Stock	30.27	30.31	30.26	30.285	1654795.0
2012-08-30 13:00:00	MSFT	Stock	30.28	30.34	30.26	30.325	2235518.0
2012-08-30 14:00:00	MSFT	Stock	30.33	30.38	30.32	30.365	1475259.0
2012-08-30 15:00:00	MSFT	Stock	30.37	30.43	30.31	30.34	4792473.0
2012-08-30 16:00:00	MSFT	Stock	30.34	30.67	30.28	30.32	2288769.0
2012-08-30 17:00:00	MSFT	Stock	30.34	30.34	30.242	30.3	14469.0
2012-08-30 18:00:00	MSFT	Stock	30.34	30.34	30.34	30.34	700.0
2012-08-30 19:00:00	MSFT	Stock	30.31	30.31	30.3	30.3	9990.0
2012-08-30 08:00:00	NVDA	Stock	0.3575	0.3575	0.3568	0.3568	80000.0
2012-08-30 09:00:00	NVDA	Stock	0.3568	0.3585	0.3535	0.3555	26544520.0
2012-08-30 10:00:00	NVDA	Stock	0.3557	0.3557	0.3513	0.352	40175520.0
2012-08-30 11:00:00	NVDA	Stock	0.352	0.3522	0.3513	0.3514	20244040.0
2012-08-30 12:00:00	NVDA	Stock	0.3513	0.3513	0.3495	0.3511	38461680.0
2012-08-30 13:00:00	NVDA	Stock	0.3511	0.3518	0.3508	0.3508	32978800.0
2012-08-30 14:00:00	NVDA	Stock	0.351	0.352	0.3506	0.3513	13835640.0
2012-08-30 15:00:00	NVDA	Stock	0.3513	0.352	0.35	0.351	90790240.0
2012-08-30 16:00:00	NVDA	Stock	0.3513	0.358	0.3505	0.3513	4624320.0
2012-08-30 19:00:00	NVDA	Stock	0.352	0.352	0.3508	0.3508	25240.0
2012-08-30 08:00:00	AMZN	Stock	12.325	12.3425	12.299	12.305	171480.0
2012-08-30 09:00:00	AMZN	Stock	12.3	12.5	12.3	12.4555	18954660.0
2012-08-30 10:00:00	AMZN	Stock	12.4518	12.4645	12.283	12.3214	13719440.0
2012-08-30 11:00:00	AMZN	Stock	12.3216	12.375	12.3135	12.3159	10515560.0
2012-08-30 12:00:00	AMZN	Stock	12.32	12.322	12.2625	12.2965	7656220.0
2012-08-30 13:00:00	AMZN	Stock	12.2925	12.3395	12.271	12.3312	4884560.0
2012-08-30 14:00:00	AMZN	Stock	12.333	12.37	12.3205	12.361	5559200.0
2012-08-30 15:00:00	AMZN	Stock	12.363	12.3715	12.2961	12.311	8810200.0
2012-08-30 16:00:00	AMZN	Stock	12.3125	12.3736	12.3	12.311	823420.0
2012-08-30 17:00:00	AMZN	Stock	12.3195	12.322	12.2855	12.322	19700.0

> showing 50 of 42,024 rows — these rows as CSV

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