PREVIEW / stock_1hour / 2014-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-10.parquet
  size:    1.1 MB
  rows:    49,396
  symbols: 3,545

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-12-10 04:00:00	AAPL	Stock	28.59	28.645	28.5875	28.645	27892.0
2014-12-10 05:00:00	AAPL	Stock	28.655	28.675	28.6075	28.62	14768.0
2014-12-10 06:00:00	AAPL	Stock	28.605	28.675	28.575	28.65	131452.0
2014-12-10 07:00:00	AAPL	Stock	28.6375	28.65	28.5525	28.6	228476.0
2014-12-10 08:00:00	AAPL	Stock	28.5975	28.6475	28.53	28.6375	737848.0
2014-12-10 09:00:00	AAPL	Stock	28.6475	28.7125	28.2795	28.3882	27939156.0
2014-12-10 10:00:00	AAPL	Stock	28.39	28.445	28.19	28.4175	26345276.0
2014-12-10 11:00:00	AAPL	Stock	28.42	28.4375	28.31	28.4025	13713264.0
2014-12-10 12:00:00	AAPL	Stock	28.4025	28.4025	28.2525	28.2598	11082508.0
2014-12-10 13:00:00	AAPL	Stock	28.2588	28.37	28.1275	28.1325	16462084.0
2014-12-10 14:00:00	AAPL	Stock	28.135	28.18	27.95	27.9525	23858516.0
2014-12-10 15:00:00	AAPL	Stock	27.955	28.1262	27.885	27.99	35261720.0
2014-12-10 16:00:00	AAPL	Stock	27.9875	28.3308	27.9742	27.9825	8254748.0
2014-12-10 17:00:00	AAPL	Stock	27.9775	28.2395	27.97	28.0025	146964.0
2014-12-10 18:00:00	AAPL	Stock	28.0075	28.455	27.9675	27.985	81100.0
2014-12-10 19:00:00	AAPL	Stock	27.985	27.9975	27.945	27.97	131924.0
2014-12-10 09:00:00	MSFT	Stock	47.46	47.59	47.11	47.11	2812150.0
2014-12-10 10:00:00	MSFT	Stock	47.12	47.39	46.94	47.39	4717461.0
2014-12-10 11:00:00	MSFT	Stock	47.39	47.66	47.27	47.615	2928556.0
2014-12-10 12:00:00	MSFT	Stock	47.61	47.61	47.29	47.325	1850629.0
2014-12-10 13:00:00	MSFT	Stock	47.32	47.36	46.94	46.95	2457187.0
2014-12-10 14:00:00	MSFT	Stock	46.95	46.97	46.7	46.8	3953231.0
2014-12-10 15:00:00	MSFT	Stock	46.8	47.02	46.75	46.92	6477491.0
2014-12-10 16:00:00	MSFT	Stock	46.9	47.08	46.88	46.93	3776465.0
2014-12-10 17:00:00	MSFT	Stock	46.9	46.91	46.89	46.89	3601.0
2014-12-10 18:00:00	MSFT	Stock	47.245	47.245	46.9	46.9	68097.0
2014-12-10 09:00:00	NVDA	Stock	0.5162	0.5188	0.514	0.5178	15573840.0
2014-12-10 10:00:00	NVDA	Stock	0.5175	0.5184	0.5141	0.5169	25375360.0
2014-12-10 11:00:00	NVDA	Stock	0.517	0.5173	0.5154	0.5154	21135680.0
2014-12-10 12:00:00	NVDA	Stock	0.5154	0.5154	0.5128	0.5133	16602000.0
2014-12-10 13:00:00	NVDA	Stock	0.5133	0.5145	0.5102	0.5102	14757120.0
2014-12-10 14:00:00	NVDA	Stock	0.5102	0.5108	0.5068	0.5069	24681960.0
2014-12-10 15:00:00	NVDA	Stock	0.5068	0.51	0.5061	0.5066	59112680.0
2014-12-10 16:00:00	NVDA	Stock	0.5068	0.5116	0.5065	0.5068	23043080.0
2014-12-10 17:00:00	NVDA	Stock	0.5068	0.5068	0.5068	0.5068	106680.0
2014-12-10 04:00:00	AMZN	Stock	15.6255	15.6255	15.6255	15.6255	2000.0
2014-12-10 06:00:00	AMZN	Stock	15.6705	15.6705	15.6625	15.6625	4000.0
2014-12-10 07:00:00	AMZN	Stock	15.6505	15.6515	15.65	15.6515	13000.0
2014-12-10 08:00:00	AMZN	Stock	15.625	15.625	15.571	15.571	99960.0
2014-12-10 09:00:00	AMZN	Stock	15.57	15.6595	15.4255	15.4826	7516900.0
2014-12-10 10:00:00	AMZN	Stock	15.4855	15.509	15.364	15.4845	7642680.0
2014-12-10 11:00:00	AMZN	Stock	15.4895	15.5415	15.4125	15.5002	5617600.0
2014-12-10 12:00:00	AMZN	Stock	15.4995	15.4995	15.381	15.434	3686400.0
2014-12-10 13:00:00	AMZN	Stock	15.4255	15.4538	15.3775	15.385	4173400.0
2014-12-10 14:00:00	AMZN	Stock	15.3822	15.3845	15.2885	15.2915	9567960.0
2014-12-10 15:00:00	AMZN	Stock	15.2925	15.3715	15.234	15.292	16139900.0
2014-12-10 16:00:00	AMZN	Stock	15.292	15.4014	15.275	15.275	5169860.0
2014-12-10 17:00:00	AMZN	Stock	15.2315	15.292	15.225	15.292	173300.0
2014-12-10 18:00:00	AMZN	Stock	15.4945	15.4945	15.25	15.2555	13560.0
2014-12-10 19:00:00	AMZN	Stock	15.314	15.314	15.289	15.29	12600.0

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

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