PREVIEW / stock_1hour / 2012-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-29.parquet
  size:    966 KB
  rows:    45,655
  symbols: 3,540

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-06-29 04:00:00	AAPL	Stock	20.3393	20.4643	20.3393	20.4496	61600.0
2012-06-29 05:00:00	AAPL	Stock	20.4554	20.4554	20.4286	20.4539	34440.0
2012-06-29 06:00:00	AAPL	Stock	20.4464	20.4839	20.4464	20.4646	67200.0
2012-06-29 07:00:00	AAPL	Stock	20.4732	20.5354	20.4646	20.5107	918372.0
2012-06-29 08:00:00	AAPL	Stock	20.5107	20.6525	20.4893	20.6086	5710292.0
2012-06-29 09:00:00	AAPL	Stock	20.6161	20.6607	20.5089	20.5637	63990080.0
2012-06-29 10:00:00	AAPL	Stock	20.5636	20.6829	20.5636	20.6479	70201936.0
2012-06-29 11:00:00	AAPL	Stock	20.645	20.7268	20.6321	20.7189	47946500.0
2012-06-29 12:00:00	AAPL	Stock	20.7211	20.745	20.6929	20.7071	36609748.0
2012-06-29 13:00:00	AAPL	Stock	20.7068	20.7339	20.7029	20.7301	27344212.0
2012-06-29 14:00:00	AAPL	Stock	20.7282	20.8464	20.7218	20.8307	59105312.0
2012-06-29 15:00:00	AAPL	Stock	20.83	20.8571	20.7789	20.8571	75720148.0
2012-06-29 16:00:00	AAPL	Stock	20.8571	20.8613	20.7149	20.8254	25426940.0
2012-06-29 17:00:00	AAPL	Stock	20.8571	20.8571	20.8218	20.8321	246400.0
2012-06-29 18:00:00	AAPL	Stock	20.8321	20.8321	20.8232	20.8321	383488.0
2012-06-29 19:00:00	AAPL	Stock	20.8289	20.8339	20.825	20.8268	414064.0
2012-06-29 06:00:00	MSFT	Stock	30.18	30.18	30.18	30.18	200.0
2012-06-29 07:00:00	MSFT	Stock	30.39	30.42	30.27	30.42	6457.0
2012-06-29 08:00:00	MSFT	Stock	30.33	30.4	30.2	30.37	42383.0
2012-06-29 09:00:00	MSFT	Stock	30.37	30.69	30.14	30.26	7190619.0
2012-06-29 10:00:00	MSFT	Stock	30.26	30.56	30.26	30.495	7262795.0
2012-06-29 11:00:00	MSFT	Stock	30.5	30.58	30.43	30.455	4776596.0
2012-06-29 12:00:00	MSFT	Stock	30.451	30.53	30.43	30.53	3704823.0
2012-06-29 13:00:00	MSFT	Stock	30.525	30.55	30.47	30.5	2980732.0
2012-06-29 14:00:00	MSFT	Stock	30.49	30.58	30.46	30.495	4995633.0
2012-06-29 15:00:00	MSFT	Stock	30.495	30.59	30.38	30.58	15322721.0
2012-06-29 16:00:00	MSFT	Stock	30.58	30.596	30.437	30.57	7890585.0
2012-06-29 17:00:00	MSFT	Stock	30.57	30.59	30.55	30.59	27332.0
2012-06-29 18:00:00	MSFT	Stock	30.54	30.59	30.489	30.489	18668.0
2012-06-29 19:00:00	MSFT	Stock	30.52	30.57	30.48	30.48	6797.0
2012-06-29 07:00:00	NVDA	Stock	0.331	0.34	0.331	0.3398	80000.0
2012-06-29 08:00:00	NVDA	Stock	0.34	0.3415	0.3325	0.34	1514800.0
2012-06-29 09:00:00	NVDA	Stock	0.34	0.3435	0.3385	0.3418	82421360.0
2012-06-29 10:00:00	NVDA	Stock	0.3418	0.345	0.3415	0.3441	122488200.0
2012-06-29 11:00:00	NVDA	Stock	0.3442	0.3455	0.343	0.3435	73036680.0
2012-06-29 12:00:00	NVDA	Stock	0.3434	0.3442	0.3415	0.3438	68195920.0
2012-06-29 13:00:00	NVDA	Stock	0.3436	0.345	0.3435	0.345	33654240.0
2012-06-29 14:00:00	NVDA	Stock	0.345	0.3462	0.3442	0.345	47674840.0
2012-06-29 15:00:00	NVDA	Stock	0.345	0.3458	0.3425	0.3455	130064720.0
2012-06-29 16:00:00	NVDA	Stock	0.3455	0.3462	0.3427	0.3455	9151000.0
2012-06-29 17:00:00	NVDA	Stock	0.3453	0.3458	0.343	0.343	94880.0
2012-06-29 19:00:00	NVDA	Stock	0.345	0.3455	0.3445	0.3455	80000.0
2012-06-29 07:00:00	AMZN	Stock	11.2175	11.2245	11.2175	11.2245	11500.0
2012-06-29 08:00:00	AMZN	Stock	11.181	11.24	11.151	11.2085	381680.0
2012-06-29 09:00:00	AMZN	Stock	11.2135	11.3	11.1855	11.2565	10980560.0
2012-06-29 10:00:00	AMZN	Stock	11.2635	11.312	11.2485	11.2905	10734920.0
2012-06-29 11:00:00	AMZN	Stock	11.2905	11.377	11.2835	11.3455	11123400.0
2012-06-29 12:00:00	AMZN	Stock	11.342	11.359	11.3305	11.359	4629700.0
2012-06-29 13:00:00	AMZN	Stock	11.3575	11.3875	11.3535	11.382	5908100.0
2012-06-29 14:00:00	AMZN	Stock	11.383	11.4165	11.379	11.4152	7102560.0

> showing 50 of 45,655 rows — these rows as CSV

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