PREVIEW / stock_1hour / 2014-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-05.parquet
  size:    1.0 MB
  rows:    48,788
  symbols: 3,586

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-08-05 05:00:00	AAPL	Stock	23.9325	23.9325	23.925	23.925	5000.0
2014-08-05 06:00:00	AAPL	Stock	23.9175	23.9225	23.875	23.875	8776.0
2014-08-05 07:00:00	AAPL	Stock	23.9175	23.9175	23.865	23.8775	64936.0
2014-08-05 08:00:00	AAPL	Stock	23.8825	23.9325	23.8325	23.8675	557096.0
2014-08-05 09:00:00	AAPL	Stock	23.8775	23.8975	23.59	23.6225	29097816.0
2014-08-05 10:00:00	AAPL	Stock	23.6225	23.7975	23.6025	23.7275	27187176.0
2014-08-05 11:00:00	AAPL	Stock	23.73	23.765	23.6675	23.6975	15473364.0
2014-08-05 12:00:00	AAPL	Stock	23.6975	23.7475	23.6575	23.7325	13481760.0
2014-08-05 13:00:00	AAPL	Stock	23.73	23.92	23.6675	23.76	45944764.0
2014-08-05 14:00:00	AAPL	Stock	23.7575	23.82	23.63	23.7575	27674324.0
2014-08-05 15:00:00	AAPL	Stock	23.7575	23.845	23.705	23.785	28787200.0
2014-08-05 16:00:00	AAPL	Stock	23.78	23.7975	23.6862	23.78	9157120.0
2014-08-05 17:00:00	AAPL	Stock	23.79	23.7975	23.78	23.7925	77112.0
2014-08-05 18:00:00	AAPL	Stock	23.7925	23.83	23.7925	23.83	80292.0
2014-08-05 19:00:00	AAPL	Stock	23.835	23.8725	23.8175	23.8625	130632.0
2014-08-05 05:00:00	MSFT	Stock	43.3	43.3	43.3	43.3	100.0
2014-08-05 06:00:00	MSFT	Stock	43.3	43.3	43.3	43.3	300.0
2014-08-05 08:00:00	MSFT	Stock	43.35	43.39	43.2	43.3	13007.0
2014-08-05 09:00:00	MSFT	Stock	43.3	43.46	43.0	43.05	2853260.0
2014-08-05 10:00:00	MSFT	Stock	43.06	43.18	42.885	43.12	4115688.0
2014-08-05 11:00:00	MSFT	Stock	43.11	43.31	43.005	43.18	2333159.0
2014-08-05 12:00:00	MSFT	Stock	43.165	43.21	43.05	43.17	1943975.0
2014-08-05 13:00:00	MSFT	Stock	43.165	43.28	42.85	42.905	2917525.0
2014-08-05 14:00:00	MSFT	Stock	42.91	43.07	42.83	42.92	2654447.0
2014-08-05 15:00:00	MSFT	Stock	42.925	43.14	42.855	43.08	4839004.0
2014-08-05 16:00:00	MSFT	Stock	43.085	43.096	43.0	43.0	3633688.0
2014-08-05 17:00:00	MSFT	Stock	43.06	43.08	43.06	43.08	7532.0
2014-08-05 18:00:00	MSFT	Stock	43.04	43.04	43.04	43.04	100.0
2014-08-05 19:00:00	MSFT	Stock	43.03	43.1	43.01	43.1	844.0
2014-08-05 08:00:00	NVDA	Stock	0.44	0.44	0.44	0.44	40000.0
2014-08-05 09:00:00	NVDA	Stock	0.4388	0.444	0.4362	0.4429	45756960.0
2014-08-05 10:00:00	NVDA	Stock	0.4428	0.4468	0.4425	0.4452	43783800.0
2014-08-05 11:00:00	NVDA	Stock	0.4455	0.448	0.4435	0.4442	32617600.0
2014-08-05 12:00:00	NVDA	Stock	0.4445	0.4475	0.4405	0.443	38202280.0
2014-08-05 13:00:00	NVDA	Stock	0.4432	0.4432	0.4382	0.4395	39291680.0
2014-08-05 14:00:00	NVDA	Stock	0.4398	0.4422	0.4385	0.441	23952880.0
2014-08-05 15:00:00	NVDA	Stock	0.441	0.4426	0.4399	0.4418	51894840.0
2014-08-05 16:00:00	NVDA	Stock	0.4415	0.4415	0.4414	0.4415	1649560.0
2014-08-05 07:00:00	AMZN	Stock	15.666	15.666	15.666	15.666	2140.0
2014-08-05 08:00:00	AMZN	Stock	15.662	15.6825	15.5875	15.6135	124500.0
2014-08-05 09:00:00	AMZN	Stock	15.625	15.714	15.568	15.5885	8185340.0
2014-08-05 10:00:00	AMZN	Stock	15.587	15.7275	15.5535	15.679	8539600.0
2014-08-05 11:00:00	AMZN	Stock	15.6855	15.7135	15.604	15.619	4059520.0
2014-08-05 12:00:00	AMZN	Stock	15.608	15.6275	15.566	15.6025	3785180.0
2014-08-05 13:00:00	AMZN	Stock	15.6	15.634	15.511	15.559	7076380.0
2014-08-05 14:00:00	AMZN	Stock	15.5565	15.582	15.512	15.5355	7094240.0
2014-08-05 15:00:00	AMZN	Stock	15.536	15.635	15.503	15.6165	9972380.0
2014-08-05 16:00:00	AMZN	Stock	15.616	15.7123	15.5475	15.7123	2475660.0
2014-08-05 18:00:00	AMZN	Stock	15.6125	15.6135	15.6125	15.6135	5900.0
2014-08-05 19:00:00	AMZN	Stock	15.625	15.625	15.625	15.625	4000.0

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

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