PREVIEW / stock_1hour / 2015-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-29.parquet
  size:    1.0 MB
  rows:    48,442
  symbols: 3,463

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
2015-09-29 04:00:00	AAPL	Stock	28.1075	28.3425	28.1075	28.3125	45796.0
2015-09-29 05:00:00	AAPL	Stock	28.3125	28.3125	28.25	28.25	9488.0
2015-09-29 06:00:00	AAPL	Stock	28.2525	28.3375	28.2525	28.3375	31908.0
2015-09-29 07:00:00	AAPL	Stock	28.3	28.3375	28.205	28.205	176920.0
2015-09-29 08:00:00	AAPL	Stock	28.235	28.3375	28.2075	28.29	569408.0
2015-09-29 09:00:00	AAPL	Stock	28.2875	28.329	28.15	28.275	23143756.0
2015-09-29 10:00:00	AAPL	Stock	28.282	28.3775	28.1375	28.2225	29538540.0
2015-09-29 11:00:00	AAPL	Stock	28.2222	28.25	27.7925	27.795	31052092.0
2015-09-29 12:00:00	AAPL	Stock	27.795	27.8682	27.568	27.5825	43832816.0
2015-09-29 13:00:00	AAPL	Stock	27.5825	27.76	27.5425	27.719	26667540.0
2015-09-29 14:00:00	AAPL	Stock	27.72	27.735	27.355	27.3575	31041060.0
2015-09-29 15:00:00	AAPL	Stock	27.36	27.4432	26.965	27.265	77107444.0
2015-09-29 16:00:00	AAPL	Stock	27.265	28.1625	27.22	27.2625	8984236.0
2015-09-29 17:00:00	AAPL	Stock	27.265	27.2875	27.23	27.275	130832.0
2015-09-29 18:00:00	AAPL	Stock	27.2875	27.2875	27.225	27.2375	126548.0
2015-09-29 19:00:00	AAPL	Stock	27.225	27.2725	27.2125	27.2475	181684.0
2015-09-29 07:00:00	MSFT	Stock	43.48	43.48	43.42	43.42	2200.0
2015-09-29 08:00:00	MSFT	Stock	43.42	43.6	43.42	43.6	2725.0
2015-09-29 09:00:00	MSFT	Stock	43.6	43.6	43.19	43.36	2898541.0
2015-09-29 10:00:00	MSFT	Stock	43.36	43.54	43.195	43.52	4378574.0
2015-09-29 11:00:00	MSFT	Stock	43.53	43.57	43.36	43.5	2744108.0
2015-09-29 12:00:00	MSFT	Stock	43.49	43.51	43.28	43.285	2279838.0
2015-09-29 13:00:00	MSFT	Stock	43.29	43.54	43.23	43.52	2329461.0
2015-09-29 14:00:00	MSFT	Stock	43.51	43.531	43.22	43.27	3230789.0
2015-09-29 15:00:00	MSFT	Stock	43.28	43.57	43.05	43.44	7861850.0
2015-09-29 16:00:00	MSFT	Stock	43.44	43.48	43.295	43.45	5918360.0
2015-09-29 17:00:00	MSFT	Stock	43.45	43.45	43.45	43.45	200.0
2015-09-29 19:00:00	MSFT	Stock	43.5	43.5	43.5	43.5	322.0
2015-09-29 08:00:00	NVDA	Stock	0.5872	0.5905	0.5872	0.5905	32000.0
2015-09-29 09:00:00	NVDA	Stock	0.5875	0.5895	0.5805	0.5859	37171360.0
2015-09-29 10:00:00	NVDA	Stock	0.5859	0.5933	0.5851	0.5893	50201160.0
2015-09-29 11:00:00	NVDA	Stock	0.5894	0.5928	0.5855	0.5912	35518480.0
2015-09-29 12:00:00	NVDA	Stock	0.5911	0.5918	0.5845	0.5846	46992440.0
2015-09-29 13:00:00	NVDA	Stock	0.5846	0.5895	0.5845	0.5883	21732480.0
2015-09-29 14:00:00	NVDA	Stock	0.588	0.5886	0.5855	0.5865	27638080.0
2015-09-29 15:00:00	NVDA	Stock	0.5864	0.5938	0.5848	0.5928	110581320.0
2015-09-29 16:00:00	NVDA	Stock	0.5928	0.5928	0.5912	0.5928	44685080.0
2015-09-29 17:00:00	NVDA	Stock	0.592	0.592	0.592	0.592	28000.0
2015-09-29 18:00:00	NVDA	Stock	0.5912	0.5912	0.5912	0.5912	4000.0
2015-09-29 19:00:00	NVDA	Stock	0.5923	0.5923	0.5923	0.5923	24000.0
2015-09-29 04:00:00	AMZN	Stock	25.3445	25.3445	25.3445	25.3445	4000.0
2015-09-29 05:00:00	AMZN	Stock	25.3375	25.3375	25.3375	25.3375	5000.0
2015-09-29 06:00:00	AMZN	Stock	25.3205	25.3205	25.3205	25.3205	3940.0
2015-09-29 07:00:00	AMZN	Stock	25.304	25.325	25.301	25.301	16920.0
2015-09-29 08:00:00	AMZN	Stock	25.3125	25.3895	25.29	25.3515	93120.0
2015-09-29 09:00:00	AMZN	Stock	25.355	25.4795	24.9275	25.4105	14391640.0
2015-09-29 10:00:00	AMZN	Stock	25.4	25.574	25.1745	25.2593	12074380.0
2015-09-29 11:00:00	AMZN	Stock	25.2495	25.339	25.083	25.2355	7603780.0
2015-09-29 12:00:00	AMZN	Stock	25.2245	25.2608	24.97	24.987	7916580.0
2015-09-29 13:00:00	AMZN	Stock	24.9985	25.25	24.987	25.221	5535840.0

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

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