PREVIEW / stock_1hour / 2014-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-06.parquet
  size:    1.0 MB
  rows:    49,288
  symbols: 3,530

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
2014-05-06 04:00:00	AAPL	Stock	21.5354	21.5821	21.4911	21.5289	90160.0
2014-05-06 05:00:00	AAPL	Stock	21.5286	21.5286	21.5286	21.5286	12880.0
2014-05-06 06:00:00	AAPL	Stock	21.5357	21.5357	21.5	21.5	98280.0
2014-05-06 07:00:00	AAPL	Stock	21.5	21.5243	21.4904	21.4964	412636.0
2014-05-06 08:00:00	AAPL	Stock	21.4982	21.5304	21.4357	21.4604	1359036.0
2014-05-06 09:00:00	AAPL	Stock	21.4643	21.5786	21.4175	21.5779	57272992.0
2014-05-06 10:00:00	AAPL	Stock	21.5793	21.5861	21.3429	21.3471	62335336.0
2014-05-06 11:00:00	AAPL	Stock	21.3436	21.4796	21.3304	21.4657	28950404.0
2014-05-06 12:00:00	AAPL	Stock	21.4639	21.4721	21.395	21.417	16984044.0
2014-05-06 13:00:00	AAPL	Stock	21.415	21.42	21.3071	21.3091	20832840.0
2014-05-06 14:00:00	AAPL	Stock	21.3093	21.3321	21.2629	21.3018	25473532.0
2014-05-06 15:00:00	AAPL	Stock	21.3018	21.3018	21.2289	21.2296	39349884.0
2014-05-06 16:00:00	AAPL	Stock	21.23	21.4629	21.1429	21.1961	18780972.0
2014-05-06 17:00:00	AAPL	Stock	21.1964	21.2649	21.1964	21.2214	2238068.0
2014-05-06 18:00:00	AAPL	Stock	21.225	21.2321	21.2107	21.2171	423556.0
2014-05-06 19:00:00	AAPL	Stock	21.2171	21.2321	21.2171	21.2286	103768.0
2014-05-06 08:00:00	MSFT	Stock	39.4	39.4	39.24	39.29	6026.0
2014-05-06 09:00:00	MSFT	Stock	39.29	39.35	39.14	39.23	3036899.0
2014-05-06 10:00:00	MSFT	Stock	39.23	39.25	39.16	39.18	4132216.0
2014-05-06 11:00:00	MSFT	Stock	39.18	39.225	39.05	39.2	3772107.0
2014-05-06 12:00:00	MSFT	Stock	39.21	39.27	39.15	39.245	1793596.0
2014-05-06 13:00:00	MSFT	Stock	39.245	39.25	38.95	39.0	2645745.0
2014-05-06 14:00:00	MSFT	Stock	39.005	39.07	38.97	39.02	2615654.0
2014-05-06 15:00:00	MSFT	Stock	39.01	39.17	38.98	39.07	5302414.0
2014-05-06 16:00:00	MSFT	Stock	39.06	39.2	39.03	39.07	2400170.0
2014-05-06 17:00:00	MSFT	Stock	39.109	39.109	39.06	39.09	649193.0
2014-05-06 18:00:00	MSFT	Stock	39.1	39.1	39.09	39.1	2780.0
2014-05-06 19:00:00	MSFT	Stock	39.1	39.1	39.06	39.06	1550.0
2014-05-06 04:00:00	NVDA	Stock	0.455	0.455	0.455	0.455	4000.0
2014-05-06 08:00:00	NVDA	Stock	0.4673	0.4673	0.467	0.467	16000.0
2014-05-06 09:00:00	NVDA	Stock	0.467	0.4872	0.461	0.4615	98696400.0
2014-05-06 10:00:00	NVDA	Stock	0.4615	0.4633	0.4558	0.4558	83581720.0
2014-05-06 11:00:00	NVDA	Stock	0.4558	0.4603	0.455	0.46	41555520.0
2014-05-06 12:00:00	NVDA	Stock	0.4602	0.461	0.4582	0.4593	27095080.0
2014-05-06 13:00:00	NVDA	Stock	0.4591	0.46	0.4552	0.4576	38029760.0
2014-05-06 14:00:00	NVDA	Stock	0.4575	0.4598	0.4555	0.4565	34759440.0
2014-05-06 15:00:00	NVDA	Stock	0.4565	0.4585	0.4558	0.4565	64936280.0
2014-05-06 16:00:00	NVDA	Stock	0.4562	0.4572	0.4548	0.4558	17270560.0
2014-05-06 17:00:00	NVDA	Stock	0.4568	0.4568	0.4558	0.4558	1822520.0
2014-05-06 18:00:00	NVDA	Stock	0.458	0.4585	0.458	0.4585	80000.0
2014-05-06 08:00:00	AMZN	Stock	15.535	15.535	15.4545	15.4545	81320.0
2014-05-06 09:00:00	AMZN	Stock	15.475	15.5	15.2505	15.2803	11332580.0
2014-05-06 10:00:00	AMZN	Stock	15.283	15.283	15.185	15.201	15078780.0
2014-05-06 11:00:00	AMZN	Stock	15.1955	15.2365	15.169	15.2135	7592940.0
2014-05-06 12:00:00	AMZN	Stock	15.205	15.232	15.151	15.166	6188740.0
2014-05-06 13:00:00	AMZN	Stock	15.1665	15.1785	15.003	15.0075	11345320.0
2014-05-06 14:00:00	AMZN	Stock	15.008	15.032	14.945	14.9455	10715160.0
2014-05-06 15:00:00	AMZN	Stock	14.9485	14.9745	14.852	14.8645	18074560.0
2014-05-06 16:00:00	AMZN	Stock	14.869	15.1886	14.83	14.83	2956060.0
2014-05-06 17:00:00	AMZN	Stock	14.858	14.9118	14.845	14.849	658560.0

> showing 50 of 49,288 rows — these rows as CSV

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