PREVIEW / stock_1hour / 2013-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-26.parquet
  size:    965 KB
  rows:    45,001
  symbols: 3,484

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-03-26 05:00:00	AAPL	Stock	16.5704	16.5704	16.5704	16.5704	7000.0
2013-03-26 06:00:00	AAPL	Stock	16.5761	16.5761	16.5761	16.5761	2800.0
2013-03-26 07:00:00	AAPL	Stock	16.5893	16.6568	16.5821	16.5821	673288.0
2013-03-26 08:00:00	AAPL	Stock	16.585	16.6464	16.5339	16.5836	1818152.0
2013-03-26 09:00:00	AAPL	Stock	16.5836	16.6371	16.4843	16.5143	56154336.0
2013-03-26 10:00:00	AAPL	Stock	16.5154	16.5664	16.45	16.5168	67452000.0
2013-03-26 11:00:00	AAPL	Stock	16.5171	16.5575	16.4839	16.51	30117668.0
2013-03-26 12:00:00	AAPL	Stock	16.5139	16.5357	16.4893	16.5131	22131620.0
2013-03-26 13:00:00	AAPL	Stock	16.5132	16.5721	16.5104	16.5457	22357216.0
2013-03-26 14:00:00	AAPL	Stock	16.5471	16.5532	16.4714	16.4882	27870220.0
2013-03-26 15:00:00	AAPL	Stock	16.4882	16.4936	16.4475	16.4689	49405188.0
2013-03-26 16:00:00	AAPL	Stock	16.4671	16.5564	16.465	16.4786	10478104.0
2013-03-26 17:00:00	AAPL	Stock	16.4691	16.4821	16.4607	16.4607	227948.0
2013-03-26 18:00:00	AAPL	Stock	16.4611	16.4693	16.4607	16.4693	224812.0
2013-03-26 19:00:00	AAPL	Stock	16.4696	16.4696	16.4571	16.4618	356048.0
2013-03-26 08:00:00	MSFT	Stock	28.23	28.3	28.11	28.26	60350.0
2013-03-26 09:00:00	MSFT	Stock	28.26	28.34	28.21	28.29	2967783.0
2013-03-26 10:00:00	MSFT	Stock	28.29	28.3	28.2	28.26	4193673.0
2013-03-26 11:00:00	MSFT	Stock	28.27	28.287	28.23	28.25	2609169.0
2013-03-26 12:00:00	MSFT	Stock	28.245	28.255	28.11	28.12	2978078.0
2013-03-26 13:00:00	MSFT	Stock	28.12	28.18	28.12	28.16	2996899.0
2013-03-26 14:00:00	MSFT	Stock	28.15	28.169	28.12	28.16	3380839.0
2013-03-26 15:00:00	MSFT	Stock	28.15	28.2	28.11	28.15	7212245.0
2013-03-26 16:00:00	MSFT	Stock	28.15	28.219	28.118	28.12	1230311.0
2013-03-26 17:00:00	MSFT	Stock	28.155	28.16	28.155	28.16	23212.0
2013-03-26 18:00:00	MSFT	Stock	28.17	28.17	28.16	28.16	2200.0
2013-03-26 19:00:00	MSFT	Stock	28.16	28.16	28.15	28.16	7300.0
2013-03-26 08:00:00	NVDA	Stock	0.3103	0.312	0.3103	0.312	48000.0
2013-03-26 09:00:00	NVDA	Stock	0.3103	0.312	0.3103	0.311	15184640.0
2013-03-26 10:00:00	NVDA	Stock	0.311	0.3115	0.3098	0.3108	35937600.0
2013-03-26 11:00:00	NVDA	Stock	0.311	0.3113	0.3103	0.3103	21101480.0
2013-03-26 12:00:00	NVDA	Stock	0.3103	0.3108	0.3098	0.31	18227360.0
2013-03-26 13:00:00	NVDA	Stock	0.31	0.311	0.3098	0.311	19278600.0
2013-03-26 14:00:00	NVDA	Stock	0.311	0.3113	0.3108	0.3113	19684240.0
2013-03-26 15:00:00	NVDA	Stock	0.3113	0.3128	0.311	0.3128	86832320.0
2013-03-26 16:00:00	NVDA	Stock	0.3125	0.3128	0.3114	0.3125	11242480.0
2013-03-26 19:00:00	NVDA	Stock	0.313	0.313	0.3125	0.3125	24000.0
2013-03-26 07:00:00	AMZN	Stock	12.8895	12.8895	12.8895	12.8895	2000.0
2013-03-26 08:00:00	AMZN	Stock	12.8795	12.88	12.833	12.833	96300.0
2013-03-26 09:00:00	AMZN	Stock	12.8303	12.918	12.7925	12.875	6698500.0
2013-03-26 10:00:00	AMZN	Stock	12.8745	12.909	12.814	12.8995	6730840.0
2013-03-26 11:00:00	AMZN	Stock	12.8978	13.022	12.8915	12.9785	8343420.0
2013-03-26 12:00:00	AMZN	Stock	12.9795	13.0265	12.9673	12.979	5198480.0
2013-03-26 13:00:00	AMZN	Stock	12.981	13.074	12.9805	13.0072	5700600.0
2013-03-26 14:00:00	AMZN	Stock	13.014	13.033	12.967	12.982	5190280.0
2013-03-26 15:00:00	AMZN	Stock	12.9845	13.0204	12.9595	13.0135	8906960.0
2013-03-26 16:00:00	AMZN	Stock	13.016	13.0168	12.801	12.995	238900.0
2013-03-26 17:00:00	AMZN	Stock	13.0155	13.0155	13.007	13.007	27340.0
2013-03-26 18:00:00	AMZN	Stock	12.995	12.995	12.995	12.995	9120.0
2013-03-26 19:00:00	AMZN	Stock	12.9825	12.986	12.9825	12.986	4000.0

> showing 50 of 45,001 rows — these rows as CSV

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