PREVIEW / stock_1hour / 2014-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-04.parquet
  size:    1.0 MB
  rows:    47,909
  symbols: 3,533

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-06-04 04:00:00	AAPL	Stock	22.8143	22.8289	22.8143	22.8236	39704.0
2014-06-04 05:00:00	AAPL	Stock	22.8036	22.8036	22.7625	22.7643	28000.0
2014-06-04 06:00:00	AAPL	Stock	22.7643	22.7857	22.7643	22.7739	25648.0
2014-06-04 07:00:00	AAPL	Stock	22.8036	22.8196	22.7418	22.7536	273364.0
2014-06-04 08:00:00	AAPL	Stock	22.7657	22.8196	22.7146	22.7304	958748.0
2014-06-04 09:00:00	AAPL	Stock	22.7311	22.9354	22.7182	22.9143	48699140.0
2014-06-04 10:00:00	AAPL	Stock	22.9164	22.9461	22.8361	22.9389	35493416.0
2014-06-04 11:00:00	AAPL	Stock	22.9429	23.0362	22.9389	23.0075	37868628.0
2014-06-04 12:00:00	AAPL	Stock	23.0075	23.0852	22.9918	23.0754	31826424.0
2014-06-04 13:00:00	AAPL	Stock	23.0779	23.1186	23.0382	23.0979	26568752.0
2014-06-04 14:00:00	AAPL	Stock	23.0979	23.1389	23.0571	23.0857	31146052.0
2014-06-04 15:00:00	AAPL	Stock	23.0846	23.1	23.0093	23.0293	39751292.0
2014-06-04 16:00:00	AAPL	Stock	23.0293	23.0364	22.9841	23.0261	14059500.0
2014-06-04 17:00:00	AAPL	Stock	23.0268	23.0375	22.9425	23.0375	210700.0
2014-06-04 18:00:00	AAPL	Stock	23.0396	23.0396	23.0125	23.0346	165536.0
2014-06-04 19:00:00	AAPL	Stock	23.0314	23.0354	23.0236	23.0321	58744.0
2014-06-04 06:00:00	MSFT	Stock	40.27	40.27	40.27	40.27	200.0
2014-06-04 08:00:00	MSFT	Stock	40.29	40.29	40.16	40.2	7079.0
2014-06-04 09:00:00	MSFT	Stock	40.2	40.33	40.09	40.114	1762732.0
2014-06-04 10:00:00	MSFT	Stock	40.11	40.135	39.86	39.978	4594636.0
2014-06-04 11:00:00	MSFT	Stock	39.975	40.168	39.97	40.1	3165541.0
2014-06-04 12:00:00	MSFT	Stock	40.095	40.26	40.09	40.235	1579365.0
2014-06-04 13:00:00	MSFT	Stock	40.235	40.29	40.19	40.28	2111653.0
2014-06-04 14:00:00	MSFT	Stock	40.276	40.28	40.17	40.215	2484996.0
2014-06-04 15:00:00	MSFT	Stock	40.215	40.37	40.21	40.32	5121052.0
2014-06-04 16:00:00	MSFT	Stock	40.32	40.34	40.167	40.33	1776252.0
2014-06-04 17:00:00	MSFT	Stock	40.33	40.36	40.012	40.012	13799.0
2014-06-04 18:00:00	MSFT	Stock	40.3	40.3	40.3	40.3	100.0
2014-06-04 19:00:00	MSFT	Stock	40.3	40.32	40.3	40.32	1194.0
2014-06-04 09:00:00	NVDA	Stock	0.4702	0.4732	0.47	0.4725	13095800.0
2014-06-04 10:00:00	NVDA	Stock	0.4723	0.4735	0.4705	0.4728	33319400.0
2014-06-04 11:00:00	NVDA	Stock	0.4728	0.475	0.4728	0.4748	14215000.0
2014-06-04 12:00:00	NVDA	Stock	0.4748	0.4755	0.4738	0.4745	16953360.0
2014-06-04 13:00:00	NVDA	Stock	0.4745	0.4748	0.471	0.4716	23712880.0
2014-06-04 14:00:00	NVDA	Stock	0.4716	0.4723	0.4708	0.4715	18542320.0
2014-06-04 15:00:00	NVDA	Stock	0.4713	0.4728	0.4708	0.472	29279400.0
2014-06-04 16:00:00	NVDA	Stock	0.472	0.4724	0.472	0.472	7815520.0
2014-06-04 17:00:00	NVDA	Stock	0.4729	0.4729	0.4729	0.4729	328720.0
2014-06-04 05:00:00	AMZN	Stock	15.3125	15.3125	15.3125	15.3125	4000.0
2014-06-04 08:00:00	AMZN	Stock	15.3125	15.3125	15.2505	15.255	101420.0
2014-06-04 09:00:00	AMZN	Stock	15.255	15.355	15.192	15.342	7684300.0
2014-06-04 10:00:00	AMZN	Stock	15.3385	15.428	15.316	15.3875	9055500.0
2014-06-04 11:00:00	AMZN	Stock	15.387	15.398	15.315	15.353	3558840.0
2014-06-04 12:00:00	AMZN	Stock	15.3613	15.446	15.3495	15.428	2817060.0
2014-06-04 13:00:00	AMZN	Stock	15.4225	15.4738	15.4155	15.46	2625320.0
2014-06-04 14:00:00	AMZN	Stock	15.462	15.475	15.3935	15.4005	3387200.0
2014-06-04 15:00:00	AMZN	Stock	15.3995	15.401	15.327	15.3425	7291700.0
2014-06-04 16:00:00	AMZN	Stock	15.339	15.375	15.339	15.3695	2147420.0
2014-06-04 17:00:00	AMZN	Stock	15.37	15.37	15.355	15.36	46000.0
2014-06-04 18:00:00	AMZN	Stock	15.37	15.37	15.339	15.339	71140.0

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

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