PREVIEW / stock_1hour / 2013-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-30.parquet
  size:    996 KB
  rows:    45,923
  symbols: 3,487

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-30 04:00:00	AAPL	Stock	15.3571	15.4196	15.3571	15.4196	53256.0
2013-04-30 05:00:00	AAPL	Stock	15.4268	15.4268	15.4268	15.4268	2800.0
2013-04-30 06:00:00	AAPL	Stock	15.4496	15.4521	15.4186	15.4214	23800.0
2013-04-30 07:00:00	AAPL	Stock	15.4186	15.4286	15.3886	15.405	324996.0
2013-04-30 08:00:00	AAPL	Stock	15.3986	15.4857	15.3536	15.4854	4511444.0
2013-04-30 09:00:00	AAPL	Stock	15.4832	15.6654	15.4311	15.4696	134115408.0
2013-04-30 10:00:00	AAPL	Stock	15.4716	15.5961	15.4621	15.5821	81918704.0
2013-04-30 11:00:00	AAPL	Stock	15.5807	15.7371	15.5779	15.6975	97553316.0
2013-04-30 12:00:00	AAPL	Stock	15.6979	15.8032	15.6539	15.7882	70526008.0
2013-04-30 13:00:00	AAPL	Stock	15.7868	15.9018	15.7868	15.8564	99762040.0
2013-04-30 14:00:00	AAPL	Stock	15.8514	15.8639	15.7701	15.8604	65263240.0
2013-04-30 15:00:00	AAPL	Stock	15.8554	15.8693	15.7843	15.8143	84290500.0
2013-04-30 16:00:00	AAPL	Stock	15.8143	15.8317	15.5237	15.8132	17634204.0
2013-04-30 17:00:00	AAPL	Stock	15.8132	15.8136	15.7857	15.8071	705488.0
2013-04-30 18:00:00	AAPL	Stock	15.8054	15.8132	15.8036	15.8132	156800.0
2013-04-30 19:00:00	AAPL	Stock	15.8114	15.8211	15.8114	15.8211	430248.0
2013-04-30 06:00:00	MSFT	Stock	32.59	32.59	32.59	32.59	1900.0
2013-04-30 07:00:00	MSFT	Stock	32.59	32.69	32.58	32.61	8839.0
2013-04-30 08:00:00	MSFT	Stock	32.62	32.7	32.61	32.63	87808.0
2013-04-30 09:00:00	MSFT	Stock	32.63	32.68	32.28	32.48	10720563.0
2013-04-30 10:00:00	MSFT	Stock	32.48	32.88	32.44	32.834	11114517.0
2013-04-30 11:00:00	MSFT	Stock	32.84	32.9	32.81	32.83	5447463.0
2013-04-30 12:00:00	MSFT	Stock	32.83	32.9	32.77	32.866	4295089.0
2013-04-30 13:00:00	MSFT	Stock	32.87	32.95	32.83	32.925	4528835.0
2013-04-30 14:00:00	MSFT	Stock	32.925	32.98	32.875	32.975	12660696.0
2013-04-30 15:00:00	MSFT	Stock	32.97	33.11	32.88	33.09	17507584.0
2013-04-30 16:00:00	MSFT	Stock	33.09	33.103	32.796	33.01	6090595.0
2013-04-30 17:00:00	MSFT	Stock	33.1	33.1	33.01	33.01	14899.0
2013-04-30 18:00:00	MSFT	Stock	33.1	33.1	33.02	33.02	49796.0
2013-04-30 19:00:00	MSFT	Stock	33.02	33.04	33.02	33.02	900.0
2013-04-30 08:00:00	NVDA	Stock	0.3395	0.3418	0.3395	0.3395	60000.0
2013-04-30 09:00:00	NVDA	Stock	0.3402	0.3408	0.3378	0.339	34120680.0
2013-04-30 10:00:00	NVDA	Stock	0.3393	0.3435	0.339	0.3433	49669640.0
2013-04-30 11:00:00	NVDA	Stock	0.3433	0.3438	0.3415	0.3422	30917400.0
2013-04-30 12:00:00	NVDA	Stock	0.342	0.343	0.3413	0.3422	27409840.0
2013-04-30 13:00:00	NVDA	Stock	0.3422	0.3425	0.3413	0.3422	12561520.0
2013-04-30 14:00:00	NVDA	Stock	0.3421	0.3442	0.3415	0.344	25084480.0
2013-04-30 15:00:00	NVDA	Stock	0.3441	0.3442	0.3428	0.3439	61365240.0
2013-04-30 16:00:00	NVDA	Stock	0.3442	0.3448	0.3433	0.3448	30410640.0
2013-04-30 17:00:00	NVDA	Stock	0.3442	0.3442	0.3442	0.3442	3467680.0
2013-04-30 18:00:00	NVDA	Stock	0.3435	0.3435	0.3435	0.3435	8000.0
2013-04-30 19:00:00	NVDA	Stock	0.3438	0.3438	0.3438	0.3438	4000.0
2013-04-30 04:00:00	AMZN	Stock	12.4995	12.5	12.495	12.495	6000.0
2013-04-30 07:00:00	AMZN	Stock	12.46	12.46	12.45	12.45	8000.0
2013-04-30 08:00:00	AMZN	Stock	12.4755	12.575	12.45	12.475	745580.0
2013-04-30 09:00:00	AMZN	Stock	12.474	12.68	12.428	12.5965	21422140.0
2013-04-30 10:00:00	AMZN	Stock	12.605	12.734	12.55	12.7169	16054100.0
2013-04-30 11:00:00	AMZN	Stock	12.7125	12.7289	12.6827	12.706	8179400.0
2013-04-30 12:00:00	AMZN	Stock	12.7075	12.7102	12.6325	12.68	7991360.0
2013-04-30 13:00:00	AMZN	Stock	12.678	12.6995	12.666	12.6715	4737700.0

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

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