PREVIEW / stock_1hour / 2011-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-13.parquet
  size:    904 KB
  rows:    43,810
  symbols: 3,483

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-09-13 04:00:00	AAPL	Stock	13.5029	13.5029	13.4325	13.4964	50400.0
2011-09-13 07:00:00	AAPL	Stock	13.5032	13.6589	13.5	13.6046	1986656.0
2011-09-13 08:00:00	AAPL	Stock	13.5893	13.6518	13.5446	13.6036	3037020.0
2011-09-13 09:00:00	AAPL	Stock	13.6029	13.6661	13.5804	13.6343	72046576.0
2011-09-13 10:00:00	AAPL	Stock	13.6343	13.6964	13.6193	13.6407	73145856.0
2011-09-13 11:00:00	AAPL	Stock	13.6364	13.6618	13.6175	13.6421	32911844.0
2011-09-13 12:00:00	AAPL	Stock	13.6396	13.6868	13.6196	13.6755	29254708.0
2011-09-13 13:00:00	AAPL	Stock	13.6768	13.7679	13.6768	13.7557	59164560.0
2011-09-13 14:00:00	AAPL	Stock	13.7539	13.7932	13.7232	13.7664	68438832.0
2011-09-13 15:00:00	AAPL	Stock	13.7654	13.7804	13.6964	13.7314	89685568.0
2011-09-13 16:00:00	AAPL	Stock	13.7339	13.7705	13.6989	13.7029	8546412.0
2011-09-13 17:00:00	AAPL	Stock	13.7121	13.7536	13.7061	13.7479	886984.0
2011-09-13 18:00:00	AAPL	Stock	13.7446	13.7461	13.7214	13.7321	231112.0
2011-09-13 19:00:00	AAPL	Stock	13.7436	13.7436	13.7239	13.7357	125888.0
2011-09-13 07:00:00	MSFT	Stock	25.84	25.84	25.83	25.83	6000.0
2011-09-13 08:00:00	MSFT	Stock	25.81	25.99	25.81	25.95	13660.0
2011-09-13 09:00:00	MSFT	Stock	25.95	26.0	25.81	25.98	5348962.0
2011-09-13 10:00:00	MSFT	Stock	25.97	26.07	25.85	25.91	7610834.0
2011-09-13 11:00:00	MSFT	Stock	25.9	25.95	25.81	25.91	4871263.0
2011-09-13 12:00:00	MSFT	Stock	25.9	26.0	25.84	25.99	4366986.0
2011-09-13 13:00:00	MSFT	Stock	25.985	26.17	25.985	26.122	4981381.0
2011-09-13 14:00:00	MSFT	Stock	26.121	26.185	26.01	26.04	6519438.0
2011-09-13 15:00:00	MSFT	Stock	26.035	26.12	25.91	26.04	11244574.0
2011-09-13 16:00:00	MSFT	Stock	26.04	26.102	25.89	26.03	2657965.0
2011-09-13 17:00:00	MSFT	Stock	26.03	26.03	26.01	26.03	1850.0
2011-09-13 18:00:00	MSFT	Stock	26.04	26.04	26.01	26.01	12517.0
2011-09-13 19:00:00	MSFT	Stock	26.01	26.01	26.01	26.01	600.0
2011-09-13 08:00:00	NVDA	Stock	0.36	0.36	0.3562	0.3588	412480.0
2011-09-13 09:00:00	NVDA	Stock	0.3578	0.3638	0.3528	0.3598	159787520.0
2011-09-13 10:00:00	NVDA	Stock	0.3598	0.365	0.3598	0.362	167260760.0
2011-09-13 11:00:00	NVDA	Stock	0.362	0.363	0.3571	0.3615	109835240.0
2011-09-13 12:00:00	NVDA	Stock	0.3615	0.365	0.3602	0.3604	105112120.0
2011-09-13 13:00:00	NVDA	Stock	0.3604	0.362	0.3595	0.3618	77086160.0
2011-09-13 14:00:00	NVDA	Stock	0.3618	0.3632	0.36	0.361	70313320.0
2011-09-13 15:00:00	NVDA	Stock	0.3608	0.3642	0.359	0.363	127913360.0
2011-09-13 16:00:00	NVDA	Stock	0.3628	0.3638	0.3609	0.3628	3135960.0
2011-09-13 17:00:00	NVDA	Stock	0.3625	0.3632	0.3622	0.3632	335280.0
2011-09-13 18:00:00	NVDA	Stock	0.3638	0.3728	0.3638	0.3703	4320120.0
2011-09-13 19:00:00	NVDA	Stock	0.3703	0.3713	0.369	0.3695	1387480.0
2011-09-13 04:00:00	AMZN	Stock	10.8155	10.8155	10.761	10.761	6000.0
2011-09-13 06:00:00	AMZN	Stock	10.7625	10.7625	10.7625	10.7625	4000.0
2011-09-13 07:00:00	AMZN	Stock	10.7625	10.85	10.7625	10.816	76000.0
2011-09-13 08:00:00	AMZN	Stock	10.805	10.9175	10.775	10.8665	238360.0
2011-09-13 09:00:00	AMZN	Stock	10.864	10.8965	10.7505	10.8085	12716040.0
2011-09-13 10:00:00	AMZN	Stock	10.803	10.912	10.7625	10.8325	20446760.0
2011-09-13 11:00:00	AMZN	Stock	10.831	10.85	10.78	10.805	9981960.0
2011-09-13 12:00:00	AMZN	Stock	10.804	10.8705	10.77	10.8495	6224180.0
2011-09-13 13:00:00	AMZN	Stock	10.8615	10.925	10.8445	10.915	8989520.0
2011-09-13 14:00:00	AMZN	Stock	10.915	10.9715	10.8935	10.9155	12358640.0
2011-09-13 15:00:00	AMZN	Stock	10.9195	10.9975	10.8656	10.974	22071900.0

> showing 50 of 43,810 rows — these rows as CSV

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