PREVIEW / stock_1hour / 2015-01-05

all stock 1-hour files

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

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-05 04:00:00	AAPL	Stock	27.3225	27.3225	27.28	27.28	4600.0
2015-01-05 05:00:00	AAPL	Stock	27.3	27.3	27.1375	27.28	59876.0
2015-01-05 06:00:00	AAPL	Stock	27.2875	27.3	27.225	27.225	33456.0
2015-01-05 07:00:00	AAPL	Stock	27.25	27.3	27.25	27.2875	35248.0
2015-01-05 08:00:00	AAPL	Stock	27.29	27.3	27.1375	27.1475	520660.0
2015-01-05 09:00:00	AAPL	Stock	27.155	27.175	26.8525	26.8938	32317936.0
2015-01-05 10:00:00	AAPL	Stock	26.8925	27.0475	26.8325	26.855	30699068.0
2015-01-05 11:00:00	AAPL	Stock	26.8562	26.8825	26.6375	26.7182	34403800.0
2015-01-05 12:00:00	AAPL	Stock	26.7175	26.745	26.61	26.6688	20032184.0
2015-01-05 13:00:00	AAPL	Stock	26.6675	26.6875	26.575	26.601	16625120.0
2015-01-05 14:00:00	AAPL	Stock	26.6	26.63	26.3525	26.4088	29910164.0
2015-01-05 15:00:00	AAPL	Stock	26.4075	26.6325	26.38	26.5625	37084964.0
2015-01-05 16:00:00	AAPL	Stock	26.5625	27.3912	26.5135	26.65	31364572.0
2015-01-05 17:00:00	AAPL	Stock	26.65	26.65	26.5925	26.5925	1666248.0
2015-01-05 18:00:00	AAPL	Stock	26.6075	26.6275	26.5625	26.59	107028.0
2015-01-05 19:00:00	AAPL	Stock	26.6	26.61	26.565	26.59	107244.0
2015-01-05 05:00:00	MSFT	Stock	46.65	46.7	46.64	46.7	700.0
2015-01-05 07:00:00	MSFT	Stock	46.67	46.67	46.6	46.61	12300.0
2015-01-05 08:00:00	MSFT	Stock	46.61	46.61	46.43	46.45	29725.0
2015-01-05 09:00:00	MSFT	Stock	46.45	46.73	46.29	46.45	4683458.0
2015-01-05 10:00:00	MSFT	Stock	46.44	46.57	46.35	46.48	5325147.0
2015-01-05 11:00:00	MSFT	Stock	46.47	46.495	46.26	46.38	3378260.0
2015-01-05 12:00:00	MSFT	Stock	46.384	46.49	46.3	46.36	3376918.0
2015-01-05 13:00:00	MSFT	Stock	46.36	46.435	46.25	46.4	2536030.0
2015-01-05 14:00:00	MSFT	Stock	46.395	46.475	46.25	46.385	3652621.0
2015-01-05 15:00:00	MSFT	Stock	46.39	46.625	46.3	46.33	8066594.0
2015-01-05 16:00:00	MSFT	Stock	46.325	46.49	46.3	46.401	6701299.0
2015-01-05 17:00:00	MSFT	Stock	46.35	46.35	46.35	46.35	300.0
2015-01-05 18:00:00	MSFT	Stock	46.42	46.42	46.35	46.42	3925.0
2015-01-05 19:00:00	MSFT	Stock	46.42	46.42	46.35	46.35	1740.0
2015-01-05 07:00:00	NVDA	Stock	0.505	0.505	0.505	0.505	12000.0
2015-01-05 08:00:00	NVDA	Stock	0.5085	0.5085	0.5	0.5013	178800.0
2015-01-05 09:00:00	NVDA	Stock	0.5032	0.5048	0.4975	0.498	19849200.0
2015-01-05 10:00:00	NVDA	Stock	0.498	0.5014	0.4968	0.4995	18785840.0
2015-01-05 11:00:00	NVDA	Stock	0.4995	0.5	0.4972	0.4978	15694640.0
2015-01-05 12:00:00	NVDA	Stock	0.498	0.4982	0.496	0.497	13149640.0
2015-01-05 13:00:00	NVDA	Stock	0.497	0.4972	0.495	0.496	16894800.0
2015-01-05 14:00:00	NVDA	Stock	0.496	0.497	0.4925	0.4925	23853840.0
2015-01-05 15:00:00	NVDA	Stock	0.4928	0.4964	0.4925	0.495	44055840.0
2015-01-05 16:00:00	NVDA	Stock	0.4948	0.4971	0.4942	0.4971	39769160.0
2015-01-05 17:00:00	NVDA	Stock	0.4948	0.4948	0.4948	0.4948	1040000.0
2015-01-05 18:00:00	NVDA	Stock	0.495	0.495	0.495	0.495	20000.0
2015-01-05 19:00:00	NVDA	Stock	0.4975	0.4975	0.4975	0.4975	12000.0
2015-01-05 08:00:00	AMZN	Stock	15.391	15.391	15.35	15.35	183500.0
2015-01-05 09:00:00	AMZN	Stock	15.353	15.419	15.1575	15.1915	6643740.0
2015-01-05 10:00:00	AMZN	Stock	15.1795	15.2675	15.1356	15.1645	8390080.0
2015-01-05 11:00:00	AMZN	Stock	15.161	15.2225	15.137	15.153	5378640.0
2015-01-05 12:00:00	AMZN	Stock	15.153	15.17	15.063	15.0805	4903260.0
2015-01-05 13:00:00	AMZN	Stock	15.085	15.1595	15.0455	15.1515	5489460.0
2015-01-05 14:00:00	AMZN	Stock	15.1455	15.146	15.0425	15.0845	5053260.0

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

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