PREVIEW / stock_1hour / 2014-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-17.parquet
  size:    1.0 MB
  rows:    48,815
  symbols: 3,562

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-07-17 04:00:00	AAPL	Stock	23.7875	23.7875	23.6975	23.7225	22800.0
2014-07-17 05:00:00	AAPL	Stock	23.72	23.72	23.7075	23.7075	8000.0
2014-07-17 06:00:00	AAPL	Stock	23.725	23.725	23.625	23.635	57132.0
2014-07-17 07:00:00	AAPL	Stock	23.6375	23.74	23.61	23.6275	135888.0
2014-07-17 08:00:00	AAPL	Stock	23.6475	23.78	23.6	23.75	602072.0
2014-07-17 09:00:00	AAPL	Stock	23.7475	23.8198	23.64	23.68	24513104.0
2014-07-17 10:00:00	AAPL	Stock	23.68	23.7225	23.515	23.6625	30795404.0
2014-07-17 11:00:00	AAPL	Stock	23.6625	23.6625	23.3875	23.41	26514800.0
2014-07-17 12:00:00	AAPL	Stock	23.4125	23.475	23.2675	23.3888	29180232.0
2014-07-17 13:00:00	AAPL	Stock	23.39	23.495	23.3625	23.3843	16932552.0
2014-07-17 14:00:00	AAPL	Stock	23.385	23.435	23.3	23.3475	20124340.0
2014-07-17 15:00:00	AAPL	Stock	23.3475	23.3475	23.1425	23.27	50267980.0
2014-07-17 16:00:00	AAPL	Stock	23.27	23.4152	23.2675	23.2875	7343656.0
2014-07-17 17:00:00	AAPL	Stock	23.29	23.4375	23.255	23.2875	734396.0
2014-07-17 18:00:00	AAPL	Stock	23.295	23.3125	23.2	23.215	400508.0
2014-07-17 19:00:00	AAPL	Stock	23.235	23.24	23.2	23.225	238096.0
2014-07-17 07:00:00	MSFT	Stock	43.85	43.89	43.85	43.88	3370.0
2014-07-17 08:00:00	MSFT	Stock	43.85	45.56	43.8	45.34	4268852.0
2014-07-17 09:00:00	MSFT	Stock	45.34	45.8	45.22	45.27	20258198.0
2014-07-17 10:00:00	MSFT	Stock	45.28	45.44	44.61	44.611	18415100.0
2014-07-17 11:00:00	MSFT	Stock	44.61	44.65	44.29	44.38	10153905.0
2014-07-17 12:00:00	MSFT	Stock	44.385	44.82	44.25	44.765	5948887.0
2014-07-17 13:00:00	MSFT	Stock	44.77	44.97	44.7	44.86	5166095.0
2014-07-17 14:00:00	MSFT	Stock	44.855	44.86	44.6	44.68	4268541.0
2014-07-17 15:00:00	MSFT	Stock	44.685	44.785	44.3	44.54	9808593.0
2014-07-17 16:00:00	MSFT	Stock	44.53	44.906	44.001	44.35	1977564.0
2014-07-17 17:00:00	MSFT	Stock	44.4	44.88	44.29	44.29	36655.0
2014-07-17 18:00:00	MSFT	Stock	44.29	44.53	44.19	44.2	22540.0
2014-07-17 19:00:00	MSFT	Stock	44.2	44.29	44.1	44.14	7815.0
2014-07-17 09:00:00	NVDA	Stock	0.4822	0.4838	0.4782	0.4838	15194760.0
2014-07-17 10:00:00	NVDA	Stock	0.4835	0.4868	0.4825	0.4861	32565360.0
2014-07-17 11:00:00	NVDA	Stock	0.486	0.4866	0.4824	0.483	50162360.0
2014-07-17 12:00:00	NVDA	Stock	0.483	0.485	0.482	0.4849	21583320.0
2014-07-17 13:00:00	NVDA	Stock	0.485	0.4875	0.485	0.4858	19290680.0
2014-07-17 14:00:00	NVDA	Stock	0.4858	0.4859	0.4838	0.4841	18592000.0
2014-07-17 15:00:00	NVDA	Stock	0.484	0.4846	0.481	0.4825	141527840.0
2014-07-17 16:00:00	NVDA	Stock	0.4825	0.4835	0.482	0.482	4706280.0
2014-07-17 17:00:00	NVDA	Stock	0.4825	0.4825	0.4825	0.4825	1049280.0
2014-07-17 18:00:00	NVDA	Stock	0.4775	0.4778	0.4753	0.4753	86040.0
2014-07-17 07:00:00	AMZN	Stock	17.646	17.646	17.646	17.646	2000.0
2014-07-17 08:00:00	AMZN	Stock	17.715	17.722	17.6605	17.67	107560.0
2014-07-17 09:00:00	AMZN	Stock	17.6675	17.848	17.661	17.8125	9676820.0
2014-07-17 10:00:00	AMZN	Stock	17.8135	17.8405	17.734	17.8025	8985120.0
2014-07-17 11:00:00	AMZN	Stock	17.796	17.814	17.6111	17.6205	12081920.0
2014-07-17 12:00:00	AMZN	Stock	17.6251	17.688	17.581	17.6843	6279480.0
2014-07-17 13:00:00	AMZN	Stock	17.672	17.7135	17.6185	17.619	5132140.0
2014-07-17 14:00:00	AMZN	Stock	17.6275	17.694	17.5955	17.6605	5743900.0
2014-07-17 15:00:00	AMZN	Stock	17.6605	17.6682	17.569	17.6195	13704180.0
2014-07-17 16:00:00	AMZN	Stock	17.6195	17.6852	17.569	17.6195	3054720.0
2014-07-17 17:00:00	AMZN	Stock	17.6195	17.6195	17.6195	17.6195	24500.0

> showing 50 of 48,815 rows — these rows as CSV

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