PREVIEW / stock_1hour / 2014-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-25.parquet
  size:    1.0 MB
  rows:    49,514
  symbols: 3,564

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-09-25 04:00:00	AAPL	Stock	25.2625	25.3175	25.1225	25.295	61992.0
2014-09-25 05:00:00	AAPL	Stock	25.305	25.305	25.25	25.265	77108.0
2014-09-25 06:00:00	AAPL	Stock	25.275	25.2875	25.2	25.28	85144.0
2014-09-25 07:00:00	AAPL	Stock	25.2875	25.32	25.24	25.29	205508.0
2014-09-25 08:00:00	AAPL	Stock	25.295	25.4375	25.1375	25.155	2509748.0
2014-09-25 09:00:00	AAPL	Stock	25.15	25.4375	24.775	24.8675	69207240.0
2014-09-25 10:00:00	AAPL	Stock	24.8725	24.925	24.43	24.55	104484512.0
2014-09-25 11:00:00	AAPL	Stock	24.5525	24.7125	24.515	24.64	50578652.0
2014-09-25 12:00:00	AAPL	Stock	24.64	24.7375	24.5925	24.655	29541836.0
2014-09-25 13:00:00	AAPL	Stock	24.6562	24.715	24.57	24.61	26850476.0
2014-09-25 14:00:00	AAPL	Stock	24.6112	24.6375	24.5325	24.5422	30145996.0
2014-09-25 15:00:00	AAPL	Stock	24.5413	24.6175	24.465	24.4675	53781536.0
2014-09-25 16:00:00	AAPL	Stock	24.4675	24.6925	24.4625	24.51	11539828.0
2014-09-25 17:00:00	AAPL	Stock	24.5225	24.55	24.4675	24.4675	1009464.0
2014-09-25 18:00:00	AAPL	Stock	24.515	24.5875	24.4675	24.5875	403736.0
2014-09-25 19:00:00	AAPL	Stock	24.575	24.61	24.565	24.5675	294124.0
2014-09-25 04:00:00	MSFT	Stock	47.17	47.2	47.17	47.2	1035.0
2014-09-25 05:00:00	MSFT	Stock	47.18	47.18	47.18	47.18	100.0
2014-09-25 06:00:00	MSFT	Stock	47.18	47.18	47.18	47.18	300.0
2014-09-25 07:00:00	MSFT	Stock	47.16	47.16	47.08	47.08	500.0
2014-09-25 08:00:00	MSFT	Stock	47.1	47.1	47.0	47.01	2600.0
2014-09-25 09:00:00	MSFT	Stock	47.04	47.09	46.65	46.71	3435102.0
2014-09-25 10:00:00	MSFT	Stock	46.71	46.76	46.45	46.58	5109562.0
2014-09-25 11:00:00	MSFT	Stock	46.57	46.58	46.23	46.25	5437906.0
2014-09-25 12:00:00	MSFT	Stock	46.245	46.31	46.17	46.21	2877500.0
2014-09-25 13:00:00	MSFT	Stock	46.213	46.28	46.09	46.131	2878531.0
2014-09-25 14:00:00	MSFT	Stock	46.13	46.24	46.03	46.16	2716173.0
2014-09-25 15:00:00	MSFT	Stock	46.155	46.218	46.04	46.04	6283606.0
2014-09-25 16:00:00	MSFT	Stock	46.05	46.503	46.031	46.1	3259943.0
2014-09-25 17:00:00	MSFT	Stock	46.04	46.1	46.0	46.04	113792.0
2014-09-25 18:00:00	MSFT	Stock	46.04	46.09	46.04	46.09	51502.0
2014-09-25 19:00:00	MSFT	Stock	46.09	46.15	46.09	46.12	6700.0
2014-09-25 09:00:00	NVDA	Stock	0.4725	0.4738	0.469	0.4698	21837200.0
2014-09-25 10:00:00	NVDA	Stock	0.4698	0.4698	0.466	0.4683	52358240.0
2014-09-25 11:00:00	NVDA	Stock	0.4684	0.4684	0.4662	0.4664	55864560.0
2014-09-25 12:00:00	NVDA	Stock	0.4665	0.4673	0.463	0.465	38273000.0
2014-09-25 13:00:00	NVDA	Stock	0.4648	0.4655	0.4618	0.4626	25326920.0
2014-09-25 14:00:00	NVDA	Stock	0.4625	0.4652	0.462	0.4639	17388040.0
2014-09-25 15:00:00	NVDA	Stock	0.4638	0.4655	0.4625	0.4628	68451840.0
2014-09-25 16:00:00	NVDA	Stock	0.463	0.466	0.4626	0.4648	2190720.0
2014-09-25 17:00:00	NVDA	Stock	0.4628	0.4628	0.4628	0.4628	189720.0
2014-09-25 09:00:00	AMZN	Stock	16.3995	16.427	16.2375	16.2585	6449840.0
2014-09-25 10:00:00	AMZN	Stock	16.2621	16.282	16.1339	16.243	9340660.0
2014-09-25 11:00:00	AMZN	Stock	16.2425	16.243	16.0976	16.132	7496200.0
2014-09-25 12:00:00	AMZN	Stock	16.1305	16.173	16.0995	16.129	6567620.0
2014-09-25 13:00:00	AMZN	Stock	16.138	16.1984	16.0845	16.114	5885520.0
2014-09-25 14:00:00	AMZN	Stock	16.1138	16.1425	16.0805	16.1065	4813040.0
2014-09-25 15:00:00	AMZN	Stock	16.1075	16.158	16.07	16.0981	10614420.0
2014-09-25 16:00:00	AMZN	Stock	16.0965	16.165	16.0933	16.0965	429640.0
2014-09-25 17:00:00	AMZN	Stock	16.125	16.125	16.0965	16.0965	74960.0

> showing 50 of 49,514 rows — these rows as CSV

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