PREVIEW / stock_1hour / 2013-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-24.parquet
  size:    1.0 MB
  rows:    47,393
  symbols: 3,511

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-09-24 04:00:00	AAPL	Stock	17.6421	17.6786	17.6071	17.64	158396.0
2013-09-24 05:00:00	AAPL	Stock	17.6286	17.6286	17.5811	17.5811	282100.0
2013-09-24 06:00:00	AAPL	Stock	17.5857	17.675	17.5536	17.6164	487760.0
2013-09-24 07:00:00	AAPL	Stock	17.6179	17.6607	17.5964	17.5964	1401092.0
2013-09-24 08:00:00	AAPL	Stock	17.6039	17.6679	17.5243	17.6654	6076952.0
2013-09-24 09:00:00	AAPL	Stock	17.6668	17.7025	17.5286	17.5286	94191272.0
2013-09-24 10:00:00	AAPL	Stock	17.5318	17.6039	17.4221	17.5871	81030264.0
2013-09-24 11:00:00	AAPL	Stock	17.585	17.6036	17.5221	17.5637	34293280.0
2013-09-24 12:00:00	AAPL	Stock	17.5678	17.5754	17.4761	17.5389	33822544.0
2013-09-24 13:00:00	AAPL	Stock	17.5407	17.5536	17.5043	17.5325	20650196.0
2013-09-24 14:00:00	AAPL	Stock	17.5393	17.5481	17.4755	17.5136	24918264.0
2013-09-24 15:00:00	AAPL	Stock	17.5136	17.5411	17.4443	17.475	49668444.0
2013-09-24 16:00:00	AAPL	Stock	17.4679	17.5563	17.46	17.47	12313392.0
2013-09-24 17:00:00	AAPL	Stock	17.4696	17.4857	17.4643	17.4857	700448.0
2013-09-24 18:00:00	AAPL	Stock	17.4857	17.4957	17.4679	17.4771	251580.0
2013-09-24 19:00:00	AAPL	Stock	17.4736	17.4814	17.4618	17.4768	1682408.0
2013-09-24 04:00:00	MSFT	Stock	32.76	32.76	32.76	32.76	100.0
2013-09-24 07:00:00	MSFT	Stock	32.74	32.8	32.5	32.72	7070.0
2013-09-24 08:00:00	MSFT	Stock	32.6	32.64	32.6	32.63	1051.0
2013-09-24 09:00:00	MSFT	Stock	32.65	32.87	32.33	32.33	4672601.0
2013-09-24 10:00:00	MSFT	Stock	32.333	32.5	32.15	32.43	9290420.0
2013-09-24 11:00:00	MSFT	Stock	32.43	32.54	32.38	32.465	3932342.0
2013-09-24 12:00:00	MSFT	Stock	32.46	32.54	32.43	32.52	2814792.0
2013-09-24 13:00:00	MSFT	Stock	32.52	32.65	32.5	32.52	2831377.0
2013-09-24 14:00:00	MSFT	Stock	32.525	32.53	32.44	32.49	3169330.0
2013-09-24 15:00:00	MSFT	Stock	32.485	32.53	32.36	32.46	6862293.0
2013-09-24 16:00:00	MSFT	Stock	32.46	32.6	32.39	32.5	5577056.0
2013-09-24 17:00:00	MSFT	Stock	32.48	32.61	32.46	32.46	90687.0
2013-09-24 18:00:00	MSFT	Stock	32.55	32.55	32.49	32.5	1292.0
2013-09-24 19:00:00	MSFT	Stock	32.46	32.46	32.46	32.46	438516.0
2013-09-24 09:00:00	NVDA	Stock	0.3913	0.392	0.39	0.3901	14917760.0
2013-09-24 10:00:00	NVDA	Stock	0.39	0.3911	0.389	0.3898	26064600.0
2013-09-24 11:00:00	NVDA	Stock	0.3898	0.3915	0.3898	0.3911	19891280.0
2013-09-24 12:00:00	NVDA	Stock	0.3911	0.3928	0.3902	0.3916	29155680.0
2013-09-24 13:00:00	NVDA	Stock	0.3916	0.394	0.3913	0.392	32888800.0
2013-09-24 14:00:00	NVDA	Stock	0.392	0.3925	0.3916	0.3925	22601240.0
2013-09-24 15:00:00	NVDA	Stock	0.3923	0.3933	0.3915	0.3925	53437320.0
2013-09-24 16:00:00	NVDA	Stock	0.3925	0.393	0.3918	0.3928	28210560.0
2013-09-24 17:00:00	NVDA	Stock	0.3925	0.3925	0.3925	0.3925	956800.0
2013-09-24 19:00:00	NVDA	Stock	0.3925	0.3925	0.3925	0.3925	1300000.0
2013-09-24 05:00:00	AMZN	Stock	15.5825	15.5825	15.575	15.575	6000.0
2013-09-24 06:00:00	AMZN	Stock	15.5715	15.5715	15.5715	15.5715	2000.0
2013-09-24 08:00:00	AMZN	Stock	15.557	15.564	15.55	15.55	18000.0
2013-09-24 09:00:00	AMZN	Stock	15.55	15.795	15.545	15.7508	5624440.0
2013-09-24 10:00:00	AMZN	Stock	15.732	15.8325	15.564	15.8205	8526880.0
2013-09-24 11:00:00	AMZN	Stock	15.822	15.867	15.783	15.82	5087440.0
2013-09-24 12:00:00	AMZN	Stock	15.815	15.8195	15.7625	15.7815	2299820.0
2013-09-24 13:00:00	AMZN	Stock	15.7825	15.904	15.7795	15.825	4361640.0
2013-09-24 14:00:00	AMZN	Stock	15.829	15.855	15.774	15.8132	3413200.0
2013-09-24 15:00:00	AMZN	Stock	15.8052	15.8055	15.6692	15.71	7842360.0

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

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