PREVIEW / stock_1hour / 2014-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-26.parquet
  size:    1.0 MB
  rows:    47,896
  symbols: 3,560

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-06-26 05:00:00	AAPL	Stock	22.59	22.6275	22.59	22.6275	1468.0
2014-06-26 06:00:00	AAPL	Stock	22.6375	22.675	22.635	22.65	24192.0
2014-06-26 07:00:00	AAPL	Stock	22.65	22.65	22.6325	22.635	40920.0
2014-06-26 08:00:00	AAPL	Stock	22.65	22.65	22.5775	22.595	482504.0
2014-06-26 09:00:00	AAPL	Stock	22.5875	22.635	22.45	22.4925	23801436.0
2014-06-26 10:00:00	AAPL	Stock	22.4925	22.555	22.4538	22.5275	23468376.0
2014-06-26 11:00:00	AAPL	Stock	22.53	22.59	22.5025	22.545	15102832.0
2014-06-26 12:00:00	AAPL	Stock	22.545	22.5775	22.5325	22.54	6730120.0
2014-06-26 13:00:00	AAPL	Stock	22.54	22.615	22.5325	22.5875	11623296.0
2014-06-26 14:00:00	AAPL	Stock	22.585	22.6125	22.5525	22.605	8464988.0
2014-06-26 15:00:00	AAPL	Stock	22.6075	22.7625	22.5875	22.73	27791948.0
2014-06-26 16:00:00	AAPL	Stock	22.725	22.74	22.5285	22.72	4845048.0
2014-06-26 17:00:00	AAPL	Stock	22.72	22.7275	22.6228	22.7275	351396.0
2014-06-26 18:00:00	AAPL	Stock	22.725	22.7275	22.72	22.7225	42340.0
2014-06-26 19:00:00	AAPL	Stock	22.7275	22.7425	22.7125	22.7425	94056.0
2014-06-26 06:00:00	MSFT	Stock	41.97	41.97	41.97	41.97	300.0
2014-06-26 07:00:00	MSFT	Stock	41.93	41.93	41.93	41.93	100.0
2014-06-26 08:00:00	MSFT	Stock	41.92	41.92	41.85	41.85	10182.0
2014-06-26 09:00:00	MSFT	Stock	41.86	41.97	41.51	41.53	4202052.0
2014-06-26 10:00:00	MSFT	Stock	41.53	41.66	41.49	41.51	4496571.0
2014-06-26 11:00:00	MSFT	Stock	41.505	41.55	41.46	41.48	2758462.0
2014-06-26 12:00:00	MSFT	Stock	41.48	41.54	41.43	41.525	2050368.0
2014-06-26 13:00:00	MSFT	Stock	41.525	41.72	41.52	41.72	1853037.0
2014-06-26 14:00:00	MSFT	Stock	41.712	41.73	41.57	41.655	1791421.0
2014-06-26 15:00:00	MSFT	Stock	41.655	41.75	41.65	41.73	4232221.0
2014-06-26 16:00:00	MSFT	Stock	41.72	41.766	41.583	41.72	1519937.0
2014-06-26 17:00:00	MSFT	Stock	41.678	41.68	41.678	41.68	621.0
2014-06-26 07:00:00	NVDA	Stock	0.4582	0.4633	0.425	0.4633	58000.0
2014-06-26 08:00:00	NVDA	Stock	0.465	0.465	0.465	0.465	4000.0
2014-06-26 09:00:00	NVDA	Stock	0.463	0.4655	0.4581	0.461	26347760.0
2014-06-26 10:00:00	NVDA	Stock	0.461	0.462	0.4582	0.4585	50722480.0
2014-06-26 11:00:00	NVDA	Stock	0.4588	0.4612	0.4582	0.4595	28671280.0
2014-06-26 12:00:00	NVDA	Stock	0.4598	0.46	0.4578	0.4578	36434200.0
2014-06-26 13:00:00	NVDA	Stock	0.4578	0.4601	0.4575	0.4593	31700240.0
2014-06-26 14:00:00	NVDA	Stock	0.4593	0.4612	0.4593	0.4609	21738120.0
2014-06-26 15:00:00	NVDA	Stock	0.4608	0.4622	0.4588	0.4593	44747720.0
2014-06-26 16:00:00	NVDA	Stock	0.459	0.4597	0.4585	0.459	11608160.0
2014-06-26 08:00:00	AMZN	Stock	16.3835	16.3945	16.375	16.3875	31280.0
2014-06-26 09:00:00	AMZN	Stock	16.4	16.4325	16.167	16.225	7837940.0
2014-06-26 10:00:00	AMZN	Stock	16.226	16.284	16.175	16.2	8279420.0
2014-06-26 11:00:00	AMZN	Stock	16.1995	16.2635	16.1885	16.231	5618220.0
2014-06-26 12:00:00	AMZN	Stock	16.229	16.2325	16.1065	16.128	7762540.0
2014-06-26 13:00:00	AMZN	Stock	16.1295	16.206	16.1205	16.1514	3742860.0
2014-06-26 14:00:00	AMZN	Stock	16.153	16.24	16.1335	16.2331	4305500.0
2014-06-26 15:00:00	AMZN	Stock	16.2338	16.2875	16.221	16.2845	10523340.0
2014-06-26 16:00:00	AMZN	Stock	16.2845	16.3	16.2105	16.2845	766140.0
2014-06-26 17:00:00	AMZN	Stock	16.287	16.2875	16.255	16.255	12000.0
2014-06-26 18:00:00	AMZN	Stock	16.26	16.265	16.26	16.265	8000.0
2014-06-26 19:00:00	AMZN	Stock	16.255	16.27	16.255	16.27	4000.0
2014-06-26 08:00:00	GOOGL	Stock	29.355	29.4575	29.3425	29.44	145980.0

> showing 50 of 47,896 rows — these rows as CSV

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