PREVIEW / stock_1hour / 2014-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-07.parquet
  size:    1.0 MB
  rows:    47,872
  symbols: 3,531

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-02-07 04:00:00	AAPL	Stock	18.3893	18.7107	18.3893	18.6561	247380.0
2014-02-07 05:00:00	AAPL	Stock	18.6632	18.7321	18.6521	18.7232	118692.0
2014-02-07 06:00:00	AAPL	Stock	18.7189	18.7943	18.6979	18.7189	1107120.0
2014-02-07 07:00:00	AAPL	Stock	18.6943	18.7143	18.5904	18.6243	2244984.0
2014-02-07 08:00:00	AAPL	Stock	18.6232	18.7143	18.5004	18.6143	8227940.0
2014-02-07 09:00:00	AAPL	Stock	18.6179	18.6579	18.5536	18.5818	64374100.0
2014-02-07 10:00:00	AAPL	Stock	18.5818	18.6143	18.4779	18.5518	51098348.0
2014-02-07 11:00:00	AAPL	Stock	18.5514	18.63	18.5111	18.6289	28804020.0
2014-02-07 12:00:00	AAPL	Stock	18.6314	18.6761	18.6036	18.6171	34536600.0
2014-02-07 13:00:00	AAPL	Stock	18.6168	18.6514	18.5971	18.6217	21912688.0
2014-02-07 14:00:00	AAPL	Stock	18.6218	18.6339	18.5882	18.5929	24142132.0
2014-02-07 15:00:00	AAPL	Stock	18.5954	18.6129	18.5521	18.5625	56815864.0
2014-02-07 16:00:00	AAPL	Stock	18.5629	18.5908	18.5382	18.5736	12885684.0
2014-02-07 17:00:00	AAPL	Stock	18.5714	18.5911	18.5675	18.5857	427588.0
2014-02-07 18:00:00	AAPL	Stock	18.5875	18.5982	18.5861	18.5982	90972.0
2014-02-07 19:00:00	AAPL	Stock	18.6039	18.6064	18.5982	18.6064	140504.0
2014-02-07 04:00:00	MSFT	Stock	36.32	36.32	36.32	36.32	100.0
2014-02-07 06:00:00	MSFT	Stock	36.35	36.35	36.32	36.32	600.0
2014-02-07 07:00:00	MSFT	Stock	36.2	36.28	36.2	36.28	600.0
2014-02-07 08:00:00	MSFT	Stock	36.35	36.35	36.05	36.3	14656.0
2014-02-07 09:00:00	MSFT	Stock	36.3	36.4	36.07	36.18	4599772.0
2014-02-07 10:00:00	MSFT	Stock	36.19	36.33	36.01	36.13	5497169.0
2014-02-07 11:00:00	MSFT	Stock	36.133	36.39	36.07	36.35	3486549.0
2014-02-07 12:00:00	MSFT	Stock	36.35	36.43	36.28	36.33	2101561.0
2014-02-07 13:00:00	MSFT	Stock	36.33	36.5	36.325	36.485	1855783.0
2014-02-07 14:00:00	MSFT	Stock	36.484	36.585	36.43	36.53	2752177.0
2014-02-07 15:00:00	MSFT	Stock	36.54	36.59	36.47	36.58	6675183.0
2014-02-07 16:00:00	MSFT	Stock	36.545	36.58	36.15	36.372	5519652.0
2014-02-07 17:00:00	MSFT	Stock	36.514	36.58	36.51	36.52	13410.0
2014-02-07 18:00:00	MSFT	Stock	36.55	36.56	36.53	36.56	1500.0
2014-02-07 19:00:00	MSFT	Stock	36.56	36.56	36.53	36.53	7223.0
2014-02-07 06:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	20000.0
2014-02-07 08:00:00	NVDA	Stock	0.3858	0.3858	0.3858	0.3858	20000.0
2014-02-07 09:00:00	NVDA	Stock	0.3922	0.3949	0.3905	0.3925	24990880.0
2014-02-07 10:00:00	NVDA	Stock	0.3925	0.393	0.3885	0.3899	21325560.0
2014-02-07 11:00:00	NVDA	Stock	0.39	0.3915	0.3895	0.3915	12485520.0
2014-02-07 12:00:00	NVDA	Stock	0.3915	0.393	0.3915	0.3928	9764200.0
2014-02-07 13:00:00	NVDA	Stock	0.393	0.394	0.3925	0.3936	10910160.0
2014-02-07 14:00:00	NVDA	Stock	0.3935	0.3942	0.393	0.3941	8622840.0
2014-02-07 15:00:00	NVDA	Stock	0.3942	0.3973	0.3941	0.3965	52467760.0
2014-02-07 16:00:00	NVDA	Stock	0.397	0.397	0.3967	0.3967	3338600.0
2014-02-07 04:00:00	AMZN	Stock	17.7995	17.7995	17.7995	17.7995	2000.0
2014-02-07 05:00:00	AMZN	Stock	17.8045	17.869	17.8	17.869	16500.0
2014-02-07 06:00:00	AMZN	Stock	17.8685	17.8685	17.849	17.849	8000.0
2014-02-07 07:00:00	AMZN	Stock	17.85	17.85	17.825	17.825	13680.0
2014-02-07 08:00:00	AMZN	Stock	17.83	17.85	17.65	17.8135	579100.0
2014-02-07 09:00:00	AMZN	Stock	17.8185	17.95	17.7375	17.805	14801380.0
2014-02-07 10:00:00	AMZN	Stock	17.803	17.8255	17.6245	17.725	16247900.0
2014-02-07 11:00:00	AMZN	Stock	17.7259	17.7975	17.696	17.765	8997380.0
2014-02-07 12:00:00	AMZN	Stock	17.7695	17.84	17.745	17.84	5551180.0

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

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