PREVIEW / stock_1hour / 2013-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-13.parquet
  size:    1012 KB
  rows:    46,741
  symbols: 3,512

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
2013-08-13 04:00:00	AAPL	Stock	16.76	16.76	16.7579	16.7579	8400.0
2013-08-13 05:00:00	AAPL	Stock	16.7571	16.7857	16.75	16.7571	108360.0
2013-08-13 06:00:00	AAPL	Stock	16.7571	16.7679	16.7536	16.7557	54544.0
2013-08-13 07:00:00	AAPL	Stock	16.7643	16.7964	16.7589	16.7736	622860.0
2013-08-13 08:00:00	AAPL	Stock	16.7736	16.8161	16.7593	16.8107	2989140.0
2013-08-13 09:00:00	AAPL	Stock	16.8121	16.9389	16.7864	16.8446	82200384.0
2013-08-13 10:00:00	AAPL	Stock	16.8436	16.8746	16.7161	16.8421	74419072.0
2013-08-13 11:00:00	AAPL	Stock	16.8421	16.9154	16.8321	16.8809	32291336.0
2013-08-13 12:00:00	AAPL	Stock	16.8807	16.9636	16.8665	16.9377	43613556.0
2013-08-13 13:00:00	AAPL	Stock	16.9375	16.9911	16.9279	16.9704	35441476.0
2013-08-13 14:00:00	AAPL	Stock	16.9704	17.4532	16.97	17.4262	319930744.0
2013-08-13 15:00:00	AAPL	Stock	17.4264	17.6664	17.4079	17.4904	266515564.0
2013-08-13 16:00:00	AAPL	Stock	17.4884	17.6162	16.7634	17.5236	14106904.0
2013-08-13 17:00:00	AAPL	Stock	17.525	17.5693	17.4846	17.5682	3202668.0
2013-08-13 18:00:00	AAPL	Stock	17.5696	17.6125	17.5657	17.6089	1496264.0
2013-08-13 19:00:00	AAPL	Stock	17.6068	17.655	17.6	17.6357	1903580.0
2013-08-13 04:00:00	MSFT	Stock	32.87	32.87	32.87	32.87	100.0
2013-08-13 05:00:00	MSFT	Stock	32.81	32.81	32.7	32.75	2310.0
2013-08-13 06:00:00	MSFT	Stock	32.72	32.75	32.61	32.63	17169.0
2013-08-13 07:00:00	MSFT	Stock	32.62	32.65	32.41	32.57	26870.0
2013-08-13 08:00:00	MSFT	Stock	32.57	32.6	32.52	32.52	381110.0
2013-08-13 09:00:00	MSFT	Stock	32.52	32.52	32.26	32.47	6309162.0
2013-08-13 10:00:00	MSFT	Stock	32.47	32.5	32.25	32.26	9351347.0
2013-08-13 11:00:00	MSFT	Stock	32.26	32.335	32.21	32.27	4018687.0
2013-08-13 12:00:00	MSFT	Stock	32.27	32.43	32.23	32.39	3480621.0
2013-08-13 13:00:00	MSFT	Stock	32.395	32.55	32.38	32.408	2759707.0
2013-08-13 14:00:00	MSFT	Stock	32.405	32.44	32.25	32.29	3797720.0
2013-08-13 15:00:00	MSFT	Stock	32.281	32.35	32.21	32.22	6033565.0
2013-08-13 16:00:00	MSFT	Stock	32.23	32.344	32.09	32.2	2071789.0
2013-08-13 17:00:00	MSFT	Stock	32.19	32.23	32.15	32.15	118392.0
2013-08-13 18:00:00	MSFT	Stock	32.44	32.44	32.15	32.19	5104.0
2013-08-13 19:00:00	MSFT	Stock	32.17	32.19	32.17	32.19	3615.0
2013-08-13 09:00:00	NVDA	Stock	0.3595	0.3605	0.3575	0.3602	16364080.0
2013-08-13 10:00:00	NVDA	Stock	0.3602	0.3602	0.358	0.3595	41624360.0
2013-08-13 11:00:00	NVDA	Stock	0.3595	0.361	0.3589	0.3592	27995840.0
2013-08-13 12:00:00	NVDA	Stock	0.359	0.3612	0.3588	0.3608	17638680.0
2013-08-13 13:00:00	NVDA	Stock	0.3608	0.3619	0.3608	0.3615	16312080.0
2013-08-13 14:00:00	NVDA	Stock	0.3615	0.3615	0.3605	0.361	19828120.0
2013-08-13 15:00:00	NVDA	Stock	0.361	0.362	0.36	0.3605	42970120.0
2013-08-13 16:00:00	NVDA	Stock	0.3605	0.3608	0.36	0.3606	8380880.0
2013-08-13 18:00:00	NVDA	Stock	0.3605	0.3605	0.3605	0.3605	211560.0
2013-08-13 05:00:00	AMZN	Stock	14.8795	14.8795	14.8795	14.8795	2000.0
2013-08-13 07:00:00	AMZN	Stock	14.9	14.9	14.8875	14.9	6000.0
2013-08-13 08:00:00	AMZN	Stock	14.9245	14.9245	14.865	14.865	20000.0
2013-08-13 09:00:00	AMZN	Stock	14.8675	14.8675	14.614	14.6575	9594900.0
2013-08-13 10:00:00	AMZN	Stock	14.6498	14.6602	14.5335	14.623	12783800.0
2013-08-13 11:00:00	AMZN	Stock	14.623	14.6885	14.61	14.6613	4753400.0
2013-08-13 12:00:00	AMZN	Stock	14.6613	14.7355	14.6235	14.696	4219480.0
2013-08-13 13:00:00	AMZN	Stock	14.6949	14.747	14.6895	14.727	4354840.0
2013-08-13 14:00:00	AMZN	Stock	14.729	14.757	14.696	14.7	3165680.0

> showing 50 of 46,741 rows — these rows as CSV

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