PREVIEW / stock_1hour / 2013-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-26.parquet
  size:    970 KB
  rows:    44,822
  symbols: 3,454

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
2013-04-26 04:00:00	AAPL	Stock	14.5996	14.5996	14.57	14.57	16800.0
2013-04-26 06:00:00	AAPL	Stock	14.5386	14.5386	14.5357	14.5357	30800.0
2013-04-26 07:00:00	AAPL	Stock	14.5296	14.5714	14.5296	14.5504	282744.0
2013-04-26 08:00:00	AAPL	Stock	14.5621	14.6957	14.5218	14.6607	2850512.0
2013-04-26 09:00:00	AAPL	Stock	14.6679	14.7939	14.5804	14.7929	86665572.0
2013-04-26 10:00:00	AAPL	Stock	14.7929	14.8175	14.7057	14.7843	81326140.0
2013-04-26 11:00:00	AAPL	Stock	14.7855	14.8304	14.7161	14.7379	63396564.0
2013-04-26 12:00:00	AAPL	Stock	14.7379	14.7918	14.7189	14.7809	31251332.0
2013-04-26 13:00:00	AAPL	Stock	14.7768	14.8614	14.775	14.8393	49029232.0
2013-04-26 14:00:00	AAPL	Stock	14.8379	14.9243	14.8218	14.8943	63962052.0
2013-04-26 15:00:00	AAPL	Stock	14.8936	14.956	14.8936	14.8975	90134296.0
2013-04-26 16:00:00	AAPL	Stock	14.8968	14.934	14.7732	14.8721	130220272.0
2013-04-26 17:00:00	AAPL	Stock	14.8775	14.9	14.8732	14.8854	369796.0
2013-04-26 18:00:00	AAPL	Stock	14.8861	14.8893	14.8793	14.8793	106540.0
2013-04-26 19:00:00	AAPL	Stock	14.8821	14.8893	14.875	14.8854	145292.0
2013-04-26 06:00:00	MSFT	Stock	31.76	31.76	31.76	31.76	1000.0
2013-04-26 07:00:00	MSFT	Stock	31.8	31.87	31.8	31.85	3315.0
2013-04-26 08:00:00	MSFT	Stock	31.85	31.91	31.82	31.82	34002.0
2013-04-26 09:00:00	MSFT	Stock	31.85	31.965	31.64	31.65	5567898.0
2013-04-26 10:00:00	MSFT	Stock	31.655	31.67	31.45	31.635	11798988.0
2013-04-26 11:00:00	MSFT	Stock	31.63	31.71	31.53	31.585	4776680.0
2013-04-26 12:00:00	MSFT	Stock	31.58	31.72	31.52	31.711	3647896.0
2013-04-26 13:00:00	MSFT	Stock	31.71	31.89	31.7	31.88	3334168.0
2013-04-26 14:00:00	MSFT	Stock	31.88	31.97	31.81	31.95	3173970.0
2013-04-26 15:00:00	MSFT	Stock	31.955	31.98	31.77	31.79	7104644.0
2013-04-26 16:00:00	MSFT	Stock	31.79	31.96	31.525	31.78	7029346.0
2013-04-26 17:00:00	MSFT	Stock	31.78	31.88	31.78	31.88	8567.0
2013-04-26 18:00:00	MSFT	Stock	31.8	31.8	31.8	31.8	500.0
2013-04-26 19:00:00	MSFT	Stock	31.78	31.8	31.78	31.8	3100.0
2013-04-26 09:00:00	NVDA	Stock	0.3342	0.3368	0.3334	0.336	25327520.0
2013-04-26 10:00:00	NVDA	Stock	0.336	0.3365	0.334	0.3353	90607480.0
2013-04-26 11:00:00	NVDA	Stock	0.335	0.3362	0.3345	0.3355	45734960.0
2013-04-26 12:00:00	NVDA	Stock	0.3353	0.3355	0.3342	0.335	22768920.0
2013-04-26 13:00:00	NVDA	Stock	0.3351	0.3362	0.335	0.3355	15386920.0
2013-04-26 14:00:00	NVDA	Stock	0.3355	0.3362	0.3353	0.3356	23649840.0
2013-04-26 15:00:00	NVDA	Stock	0.3356	0.3366	0.3348	0.3353	71380520.0
2013-04-26 16:00:00	NVDA	Stock	0.3353	0.3362	0.3345	0.3362	28340960.0
2013-04-26 18:00:00	NVDA	Stock	0.3342	0.3342	0.3342	0.3342	4000.0
2013-04-26 19:00:00	NVDA	Stock	0.3342	0.3342	0.3342	0.3342	16000.0
2013-04-26 07:00:00	AMZN	Stock	13.34	13.422	13.3125	13.4185	147700.0
2013-04-26 08:00:00	AMZN	Stock	13.415	13.688	13.3025	13.6	2336100.0
2013-04-26 09:00:00	AMZN	Stock	13.5955	13.601	12.9875	13.008	52843580.0
2013-04-26 10:00:00	AMZN	Stock	13.01	13.068	12.815	12.82	62488700.0
2013-04-26 11:00:00	AMZN	Stock	12.8225	12.8345	12.6775	12.7153	40658380.0
2013-04-26 12:00:00	AMZN	Stock	12.705	12.762	12.6405	12.68	23804860.0
2013-04-26 13:00:00	AMZN	Stock	12.682	12.825	12.65	12.7325	23216720.0
2013-04-26 14:00:00	AMZN	Stock	12.735	12.912	12.726	12.839	31595540.0
2013-04-26 15:00:00	AMZN	Stock	12.839	12.874	12.7385	12.7405	35109200.0
2013-04-26 16:00:00	AMZN	Stock	12.7405	12.8923	12.6755	12.69	7443760.0
2013-04-26 17:00:00	AMZN	Stock	12.6895	12.7405	12.675	12.6945	258680.0

> showing 50 of 44,822 rows — these rows as CSV

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