PREVIEW / stock_1hour / 2015-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-06.parquet
  size:    1.1 MB
  rows:    49,543
  symbols: 3,546

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-01-06 04:00:00	AAPL	Stock	26.5	26.55	26.5	26.5	29632.0
2015-01-06 05:00:00	AAPL	Stock	26.5	26.5125	26.4625	26.5	13300.0
2015-01-06 06:00:00	AAPL	Stock	26.5	26.75	26.5	26.7475	36632.0
2015-01-06 07:00:00	AAPL	Stock	26.73	26.805	26.675	26.6875	118644.0
2015-01-06 08:00:00	AAPL	Stock	26.6975	26.7525	26.5	26.59	818724.0
2015-01-06 09:00:00	AAPL	Stock	26.585	26.69	26.32	26.4075	28613272.0
2015-01-06 10:00:00	AAPL	Stock	26.4075	26.8	26.375	26.525	41088052.0
2015-01-06 11:00:00	AAPL	Stock	26.5225	26.5382	26.1575	26.3225	35291792.0
2015-01-06 12:00:00	AAPL	Stock	26.3225	26.595	26.2178	26.5825	29473204.0
2015-01-06 13:00:00	AAPL	Stock	26.58	26.6075	26.2825	26.6025	24468832.0
2015-01-06 14:00:00	AAPL	Stock	26.6025	26.7625	26.46	26.705	32778060.0
2015-01-06 15:00:00	AAPL	Stock	26.7025	26.8575	26.5125	26.5575	46488404.0
2015-01-06 16:00:00	AAPL	Stock	26.565	26.6302	26.4568	26.565	6860512.0
2015-01-06 17:00:00	AAPL	Stock	26.5625	26.575	26.54	26.575	85896.0
2015-01-06 18:00:00	AAPL	Stock	26.57	26.595	26.565	26.5925	186212.0
2015-01-06 19:00:00	AAPL	Stock	26.5975	26.6525	26.5975	26.645	181636.0
2015-01-06 07:00:00	MSFT	Stock	46.5	46.5	46.5	46.5	900.0
2015-01-06 08:00:00	MSFT	Stock	46.325	46.5	46.325	46.4	23442.0
2015-01-06 09:00:00	MSFT	Stock	46.4	46.749	46.29	46.54	2998760.0
2015-01-06 10:00:00	MSFT	Stock	46.54	46.68	46.36	46.389	4934179.0
2015-01-06 11:00:00	MSFT	Stock	46.38	46.395	46.18	46.185	3446883.0
2015-01-06 12:00:00	MSFT	Stock	46.18	46.21	45.83	46.17	4321014.0
2015-01-06 13:00:00	MSFT	Stock	46.16	46.17	45.64	45.817	3598087.0
2015-01-06 14:00:00	MSFT	Stock	45.81	45.986	45.54	45.86	4137178.0
2015-01-06 15:00:00	MSFT	Stock	45.855	46.065	45.56	45.6	7646508.0
2015-01-06 16:00:00	MSFT	Stock	45.65	46.596	45.57	45.61	2363532.0
2015-01-06 17:00:00	MSFT	Stock	45.61	45.65	45.61	45.65	9895.0
2015-01-06 18:00:00	MSFT	Stock	45.65	45.65	45.65	45.65	217.0
2015-01-06 19:00:00	MSFT	Stock	45.65	45.73	45.62	45.73	2632.0
2015-01-06 04:00:00	NVDA	Stock	0.499	0.499	0.499	0.499	4000.0
2015-01-06 08:00:00	NVDA	Stock	0.4988	0.4988	0.4988	0.4988	4000.0
2015-01-06 09:00:00	NVDA	Stock	0.5015	0.5015	0.489	0.4899	17281040.0
2015-01-06 10:00:00	NVDA	Stock	0.4898	0.4918	0.488	0.4885	25654640.0
2015-01-06 11:00:00	NVDA	Stock	0.4887	0.4895	0.4845	0.4858	20563920.0
2015-01-06 12:00:00	NVDA	Stock	0.4858	0.4859	0.481	0.4836	27298800.0
2015-01-06 13:00:00	NVDA	Stock	0.4835	0.4838	0.4793	0.4822	16474840.0
2015-01-06 14:00:00	NVDA	Stock	0.4822	0.4848	0.48	0.4835	27342240.0
2015-01-06 15:00:00	NVDA	Stock	0.4835	0.4852	0.4793	0.4795	48922760.0
2015-01-06 16:00:00	NVDA	Stock	0.4798	0.485	0.4798	0.4798	11516600.0
2015-01-06 06:00:00	AMZN	Stock	15.07	15.07	15.07	15.07	4000.0
2015-01-06 08:00:00	AMZN	Stock	15.1095	15.117	15.1	15.1	173480.0
2015-01-06 09:00:00	AMZN	Stock	15.12	15.15	14.9565	14.9985	6782480.0
2015-01-06 10:00:00	AMZN	Stock	14.9985	15.1195	14.9075	14.935	9961260.0
2015-01-06 11:00:00	AMZN	Stock	14.9318	14.9525	14.711	14.7982	10255220.0
2015-01-06 12:00:00	AMZN	Stock	14.799	14.799	14.714	14.7875	6528260.0
2015-01-06 13:00:00	AMZN	Stock	14.788	14.7914	14.619	14.7114	6994100.0
2015-01-06 14:00:00	AMZN	Stock	14.715	14.906	14.7065	14.8634	9589680.0
2015-01-06 15:00:00	AMZN	Stock	14.8645	14.944	14.762	14.7645	11723360.0
2015-01-06 16:00:00	AMZN	Stock	14.755	15.1095	14.7115	14.7375	454160.0
2015-01-06 17:00:00	AMZN	Stock	14.72	14.7575	14.72	14.7575	12000.0

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

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