PREVIEW / stock_1hour / 2013-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-07.parquet
  size:    1015 KB
  rows:    47,311
  symbols: 3,543

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-10-07 04:00:00	AAPL	Stock	17.33	17.3504	17.2896	17.3504	688100.0
2013-10-07 05:00:00	AAPL	Stock	17.3268	17.3932	17.325	17.3886	295820.0
2013-10-07 06:00:00	AAPL	Stock	17.3779	17.3789	17.3539	17.3729	248248.0
2013-10-07 07:00:00	AAPL	Stock	17.3696	17.3886	17.3325	17.3679	1354360.0
2013-10-07 08:00:00	AAPL	Stock	17.3625	17.3907	17.2143	17.3789	4624620.0
2013-10-07 09:00:00	AAPL	Stock	17.3789	17.5514	17.3339	17.5314	78907640.0
2013-10-07 10:00:00	AAPL	Stock	17.5343	17.5882	17.4747	17.5614	62088096.0
2013-10-07 11:00:00	AAPL	Stock	17.5614	17.5907	17.5079	17.5693	29528044.0
2013-10-07 12:00:00	AAPL	Stock	17.5657	17.5946	17.5268	17.5341	25490164.0
2013-10-07 13:00:00	AAPL	Stock	17.5346	17.5696	17.5082	17.5693	19746832.0
2013-10-07 14:00:00	AAPL	Stock	17.5668	17.5686	17.5118	17.5254	17274936.0
2013-10-07 15:00:00	AAPL	Stock	17.5236	17.526	17.3754	17.4196	60296600.0
2013-10-07 16:00:00	AAPL	Stock	17.4196	17.5417	17.3929	17.4125	6279392.0
2013-10-07 17:00:00	AAPL	Stock	17.4125	17.4196	17.3936	17.4143	167440.0
2013-10-07 18:00:00	AAPL	Stock	17.4086	17.4229	17.3839	17.4229	370244.0
2013-10-07 19:00:00	AAPL	Stock	17.4193	17.4246	17.4143	17.4232	242648.0
2013-10-07 04:00:00	MSFT	Stock	33.61	33.61	33.61	33.61	100.0
2013-10-07 05:00:00	MSFT	Stock	33.61	33.61	33.61	33.61	100.0
2013-10-07 06:00:00	MSFT	Stock	33.56	33.56	33.55	33.55	400.0
2013-10-07 07:00:00	MSFT	Stock	33.56	33.58	33.55	33.55	600.0
2013-10-07 08:00:00	MSFT	Stock	33.7	33.7	33.63	33.67	10030.0
2013-10-07 09:00:00	MSFT	Stock	33.67	33.71	33.38	33.572	4989000.0
2013-10-07 10:00:00	MSFT	Stock	33.572	33.67	33.46	33.58	4531169.0
2013-10-07 11:00:00	MSFT	Stock	33.58	33.588	33.48	33.49	2361264.0
2013-10-07 12:00:00	MSFT	Stock	33.49	33.52	33.3	33.34	3851953.0
2013-10-07 13:00:00	MSFT	Stock	33.343	33.47	33.31	33.45	4616905.0
2013-10-07 14:00:00	MSFT	Stock	33.45	33.48	33.34	33.46	3270503.0
2013-10-07 15:00:00	MSFT	Stock	33.451	33.46	33.2	33.32	8829998.0
2013-10-07 16:00:00	MSFT	Stock	33.33	33.829	33.25	33.33	2254144.0
2013-10-07 17:00:00	MSFT	Stock	33.25	33.88	33.25	33.33	19469.0
2013-10-07 18:00:00	MSFT	Stock	33.3	33.35	33.25	33.35	1555.0
2013-10-07 19:00:00	MSFT	Stock	33.38	33.38	33.3	33.3	600.0
2013-10-07 09:00:00	NVDA	Stock	0.387	0.3908	0.3862	0.3893	27790800.0
2013-10-07 10:00:00	NVDA	Stock	0.3893	0.392	0.3888	0.391	23687320.0
2013-10-07 11:00:00	NVDA	Stock	0.3908	0.391	0.3895	0.3899	15698000.0
2013-10-07 12:00:00	NVDA	Stock	0.3898	0.39	0.3881	0.3885	14538200.0
2013-10-07 13:00:00	NVDA	Stock	0.3885	0.3908	0.3884	0.3908	16756440.0
2013-10-07 14:00:00	NVDA	Stock	0.3908	0.3924	0.3902	0.3922	22848680.0
2013-10-07 15:00:00	NVDA	Stock	0.3922	0.3925	0.3895	0.3898	42385920.0
2013-10-07 16:00:00	NVDA	Stock	0.3898	0.3903	0.389	0.3898	1732560.0
2013-10-07 04:00:00	AMZN	Stock	15.715	15.746	15.715	15.746	6320.0
2013-10-07 05:00:00	AMZN	Stock	15.751	15.8125	15.751	15.8005	8000.0
2013-10-07 07:00:00	AMZN	Stock	15.7605	15.7845	15.7335	15.7845	46880.0
2013-10-07 08:00:00	AMZN	Stock	15.7935	15.9	15.78	15.7975	72540.0
2013-10-07 09:00:00	AMZN	Stock	15.804	15.804	15.7	15.7	5256120.0
2013-10-07 10:00:00	AMZN	Stock	15.706	15.7548	15.6695	15.675	5762860.0
2013-10-07 11:00:00	AMZN	Stock	15.676	15.712	15.6165	15.6935	4603840.0
2013-10-07 12:00:00	AMZN	Stock	15.693	15.725	15.55	15.5515	8570660.0
2013-10-07 13:00:00	AMZN	Stock	15.552	15.5945	15.5142	15.592	3474220.0
2013-10-07 14:00:00	AMZN	Stock	15.5945	15.6	15.538	15.5675	3603500.0

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

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