PREVIEW / stock_1hour / 2015-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-07.parquet
  size:    1.1 MB
  rows:    49,557
  symbols: 3,529

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-07 04:00:00	AAPL	Stock	26.6875	26.7	26.6375	26.685	4000.0
2015-01-07 05:00:00	AAPL	Stock	26.685	26.7925	26.65	26.7825	9436.0
2015-01-07 06:00:00	AAPL	Stock	26.7875	26.8225	26.7	26.72	61448.0
2015-01-07 07:00:00	AAPL	Stock	26.7175	26.785	26.7025	26.775	204924.0
2015-01-07 08:00:00	AAPL	Stock	26.765	26.835	26.7075	26.7375	823888.0
2015-01-07 09:00:00	AAPL	Stock	26.7475	26.9825	26.6738	26.96	28099596.0
2015-01-07 10:00:00	AAPL	Stock	26.9575	27.05	26.82	26.96	28872672.0
2015-01-07 11:00:00	AAPL	Stock	26.96	27.0125	26.7775	26.989	19792312.0
2015-01-07 12:00:00	AAPL	Stock	26.99	27.025	26.91	26.945	14351460.0
2015-01-07 13:00:00	AAPL	Stock	26.9475	26.99	26.8375	26.95	11549620.0
2015-01-07 14:00:00	AAPL	Stock	26.9512	26.99	26.84	26.8625	14922484.0
2015-01-07 15:00:00	AAPL	Stock	26.8625	26.9675	26.845	26.9375	20838128.0
2015-01-07 16:00:00	AAPL	Stock	26.9375	26.98	26.817	26.975	6419964.0
2015-01-07 17:00:00	AAPL	Stock	26.9408	27.045	26.9168	27.025	842616.0
2015-01-07 18:00:00	AAPL	Stock	27.0375	27.0375	27.01	27.0275	129028.0
2015-01-07 19:00:00	AAPL	Stock	27.015	27.0375	26.9975	27.0375	168296.0
2015-01-07 06:00:00	MSFT	Stock	46.05	46.3	46.02	46.27	9450.0
2015-01-07 07:00:00	MSFT	Stock	46.22	46.24	46.11	46.16	12331.0
2015-01-07 08:00:00	MSFT	Stock	46.11	46.3	46.07	46.12	40804.0
2015-01-07 09:00:00	MSFT	Stock	46.14	46.15	45.49	45.74	3918633.0
2015-01-07 10:00:00	MSFT	Stock	45.74	45.92	45.635	45.85	3735696.0
2015-01-07 11:00:00	MSFT	Stock	45.85	46.32	45.68	46.29	3730160.0
2015-01-07 12:00:00	MSFT	Stock	46.28	46.46	46.21	46.4	3481250.0
2015-01-07 13:00:00	MSFT	Stock	46.4	46.44	46.25	46.322	2680461.0
2015-01-07 14:00:00	MSFT	Stock	46.33	46.396	46.105	46.124	2808856.0
2015-01-07 15:00:00	MSFT	Stock	46.123	46.28	46.09	46.23	4627027.0
2015-01-07 16:00:00	MSFT	Stock	46.23	46.26	45.809	46.236	2338233.0
2015-01-07 17:00:00	MSFT	Stock	46.21	46.236	46.106	46.23	203404.0
2015-01-07 18:00:00	MSFT	Stock	46.22	46.23	46.22	46.23	2051.0
2015-01-07 19:00:00	MSFT	Stock	46.23	46.23	46.23	46.23	1600.0
2015-01-07 08:00:00	NVDA	Stock	0.4798	0.4798	0.4798	0.4798	312000.0
2015-01-07 09:00:00	NVDA	Stock	0.4835	0.4835	0.4782	0.4822	17466120.0
2015-01-07 10:00:00	NVDA	Stock	0.4821	0.485	0.4809	0.4815	23869280.0
2015-01-07 11:00:00	NVDA	Stock	0.4815	0.4843	0.48	0.4838	18199760.0
2015-01-07 12:00:00	NVDA	Stock	0.4838	0.4865	0.483	0.4865	14824000.0
2015-01-07 13:00:00	NVDA	Stock	0.4865	0.4875	0.4828	0.4832	24580280.0
2015-01-07 14:00:00	NVDA	Stock	0.4832	0.4839	0.4803	0.4805	26980640.0
2015-01-07 15:00:00	NVDA	Stock	0.4808	0.4821	0.477	0.4785	117660400.0
2015-01-07 16:00:00	NVDA	Stock	0.4784	0.4785	0.478	0.4784	68421160.0
2015-01-07 17:00:00	NVDA	Stock	0.4784	0.4827	0.4784	0.4827	1639360.0
2015-01-07 06:00:00	AMZN	Stock	14.8695	14.887	14.8695	14.887	4000.0
2015-01-07 07:00:00	AMZN	Stock	14.87	14.87	14.8495	14.85	8840.0
2015-01-07 08:00:00	AMZN	Stock	14.887	14.887	14.8395	14.862	95640.0
2015-01-07 09:00:00	AMZN	Stock	14.8625	14.99	14.7665	14.982	9108520.0
2015-01-07 10:00:00	AMZN	Stock	14.985	15.041	14.9092	15.0145	10577420.0
2015-01-07 11:00:00	AMZN	Stock	15.007	15.035	14.926	14.9965	4579820.0
2015-01-07 12:00:00	AMZN	Stock	14.998	15.064	14.94	14.943	5750080.0
2015-01-07 13:00:00	AMZN	Stock	14.949	14.986	14.8465	14.935	5177480.0
2015-01-07 14:00:00	AMZN	Stock	14.9445	14.9615	14.839	14.848	3368420.0
2015-01-07 15:00:00	AMZN	Stock	14.8505	14.9335	14.849	14.921	7412620.0

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

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