PREVIEW / stock_1hour / 2011-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-07.parquet
  size:    934 KB
  rows:    44,314
  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
2011-06-07 04:00:00	AAPL	Stock	12.1107	12.1425	12.1107	12.1425	8400.0
2011-06-07 06:00:00	AAPL	Stock	12.1382	12.1425	12.1354	12.1354	16800.0
2011-06-07 07:00:00	AAPL	Stock	12.1107	12.1332	12.0893	12.1161	616392.0
2011-06-07 08:00:00	AAPL	Stock	12.1175	12.1214	12.0929	12.1114	1550136.0
2011-06-07 09:00:00	AAPL	Stock	12.1118	12.1243	11.9046	11.9229	124045600.0
2011-06-07 10:00:00	AAPL	Stock	11.9214	11.9939	11.9075	11.94	81285232.0
2011-06-07 11:00:00	AAPL	Stock	11.9396	11.9457	11.8811	11.9232	65865436.0
2011-06-07 12:00:00	AAPL	Stock	11.9229	11.9268	11.8714	11.9031	40468428.0
2011-06-07 13:00:00	AAPL	Stock	11.9057	11.9579	11.9007	11.916	48589548.0
2011-06-07 14:00:00	AAPL	Stock	11.9168	12.0	11.9036	11.9182	59530828.0
2011-06-07 15:00:00	AAPL	Stock	11.9161	11.9336	11.8536	11.8539	80277316.0
2011-06-07 16:00:00	AAPL	Stock	11.8539	11.9384	11.8504	11.8796	19661936.0
2011-06-07 17:00:00	AAPL	Stock	11.9144	11.9144	11.8754	11.8925	262416.0
2011-06-07 18:00:00	AAPL	Stock	11.8929	11.8964	11.8586	11.8929	364196.0
2011-06-07 19:00:00	AAPL	Stock	11.8929	11.8957	11.8886	11.8957	81452.0
2011-06-07 04:00:00	MSFT	Stock	24.2	24.2	24.2	24.2	400.0
2011-06-07 05:00:00	MSFT	Stock	24.2	24.2	24.2	24.2	200.0
2011-06-07 06:00:00	MSFT	Stock	24.19	24.19	24.19	24.19	600.0
2011-06-07 07:00:00	MSFT	Stock	24.1	24.1	24.08	24.08	1825.0
2011-06-07 08:00:00	MSFT	Stock	24.06	24.14	24.05	24.13	64104.0
2011-06-07 09:00:00	MSFT	Stock	24.13	24.17	23.98	24.02	4699007.0
2011-06-07 10:00:00	MSFT	Stock	24.03	24.14	23.94	24.097	7563398.0
2011-06-07 11:00:00	MSFT	Stock	24.09	24.1	23.9	23.978	4359789.0
2011-06-07 12:00:00	MSFT	Stock	23.98	24.01	23.93	23.995	2934858.0
2011-06-07 13:00:00	MSFT	Stock	24.0	24.08	23.99	24.049	2714549.0
2011-06-07 14:00:00	MSFT	Stock	24.045	24.1	24.02	24.04	3314825.0
2011-06-07 15:00:00	MSFT	Stock	24.04	24.06	23.93	24.05	11867448.0
2011-06-07 16:00:00	MSFT	Stock	24.05	24.08	23.96	24.032	3415423.0
2011-06-07 17:00:00	MSFT	Stock	24.03	24.05	24.03	24.05	28060.0
2011-06-07 18:00:00	MSFT	Stock	24.05	24.06	24.04	24.05	13800.0
2011-06-07 19:00:00	MSFT	Stock	24.06	24.06	24.02	24.02	3813.0
2011-06-07 07:00:00	NVDA	Stock	0.454	0.454	0.454	0.454	4000.0
2011-06-07 08:00:00	NVDA	Stock	0.4545	0.457	0.4542	0.457	230000.0
2011-06-07 09:00:00	NVDA	Stock	0.457	0.4588	0.4502	0.4525	51997840.0
2011-06-07 10:00:00	NVDA	Stock	0.4522	0.4555	0.4522	0.4545	69958200.0
2011-06-07 11:00:00	NVDA	Stock	0.4545	0.455	0.4508	0.4512	65345880.0
2011-06-07 12:00:00	NVDA	Stock	0.4515	0.4522	0.4495	0.4501	43296480.0
2011-06-07 13:00:00	NVDA	Stock	0.4504	0.4548	0.4504	0.4542	39694240.0
2011-06-07 14:00:00	NVDA	Stock	0.4542	0.4578	0.4535	0.4538	55099840.0
2011-06-07 15:00:00	NVDA	Stock	0.454	0.4545	0.4515	0.4518	93443600.0
2011-06-07 16:00:00	NVDA	Stock	0.4515	0.4532	0.4512	0.4527	13767200.0
2011-06-07 17:00:00	NVDA	Stock	0.4525	0.4538	0.4525	0.4538	40000.0
2011-06-07 18:00:00	NVDA	Stock	0.4525	0.4542	0.4525	0.4542	60000.0
2011-06-07 19:00:00	NVDA	Stock	0.4545	0.455	0.4542	0.455	102000.0
2011-06-07 08:00:00	AMZN	Stock	9.334	9.3375	9.315	9.32	66400.0
2011-06-07 09:00:00	AMZN	Stock	9.315	9.3985	9.276	9.392	12073420.0
2011-06-07 10:00:00	AMZN	Stock	9.393	9.523	9.3765	9.5155	23485540.0
2011-06-07 11:00:00	AMZN	Stock	9.5136	9.5315	9.4255	9.4475	21805220.0
2011-06-07 12:00:00	AMZN	Stock	9.4505	9.4615	9.376	9.3941	6204840.0
2011-06-07 13:00:00	AMZN	Stock	9.395	9.486	9.388	9.4785	6673560.0

> showing 50 of 44,314 rows — these rows as CSV

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