PREVIEW / stock_1hour / 2014-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-31.parquet
  size:    1.1 MB
  rows:    49,443
  symbols: 3,560

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-31 04:00:00	AAPL	Stock	28.2225	28.2225	28.2225	28.2225	4000.0
2014-12-31 07:00:00	AAPL	Stock	28.2125	28.2125	28.1875	28.2125	30684.0
2014-12-31 08:00:00	AAPL	Stock	28.2125	28.28	28.1825	28.2675	306952.0
2014-12-31 09:00:00	AAPL	Stock	28.2625	28.2825	28.1325	28.1925	12516536.0
2014-12-31 10:00:00	AAPL	Stock	28.1925	28.2025	28.0875	28.1748	12758516.0
2014-12-31 11:00:00	AAPL	Stock	28.1725	28.1798	27.9225	27.9775	20491336.0
2014-12-31 12:00:00	AAPL	Stock	27.9775	27.9825	27.7925	27.8215	23478360.0
2014-12-31 13:00:00	AAPL	Stock	27.82	27.895	27.8	27.825	12629448.0
2014-12-31 14:00:00	AAPL	Stock	27.8225	27.8255	27.64	27.6675	22465144.0
2014-12-31 15:00:00	AAPL	Stock	27.67	27.745	27.5525	27.5975	37651532.0
2014-12-31 16:00:00	AAPL	Stock	27.605	27.9192	27.0695	27.6575	14398528.0
2014-12-31 17:00:00	AAPL	Stock	27.66	27.6975	27.595	27.675	256188.0
2014-12-31 18:00:00	AAPL	Stock	27.685	27.695	27.6625	27.6875	100304.0
2014-12-31 19:00:00	AAPL	Stock	27.6875	27.7	27.67	27.675	83664.0
2014-12-31 08:00:00	MSFT	Stock	47.05	47.2	47.0	47.2	2800.0
2014-12-31 09:00:00	MSFT	Stock	47.2	47.2	46.71	47.07	2443857.0
2014-12-31 10:00:00	MSFT	Stock	47.075	47.44	46.98	47.38	2012366.0
2014-12-31 11:00:00	MSFT	Stock	47.385	47.4	47.19	47.23	1188267.0
2014-12-31 12:00:00	MSFT	Stock	47.24	47.27	46.83	46.9	1680752.0
2014-12-31 13:00:00	MSFT	Stock	46.905	47.02	46.875	46.97	1111917.0
2014-12-31 14:00:00	MSFT	Stock	46.97	46.98	46.68	46.74	2156402.0
2014-12-31 15:00:00	MSFT	Stock	46.74	46.74	46.46	46.46	6028114.0
2014-12-31 16:00:00	MSFT	Stock	46.45	47.111	46.41	46.45	3796928.0
2014-12-31 17:00:00	MSFT	Stock	46.48	46.48	46.48	46.48	800.0
2014-12-31 18:00:00	MSFT	Stock	46.48	46.54	46.47	46.47	864.0
2014-12-31 19:00:00	MSFT	Stock	46.57	46.57	46.57	46.57	300.0
2014-12-31 09:00:00	NVDA	Stock	0.51	0.512	0.5065	0.5093	10721000.0
2014-12-31 10:00:00	NVDA	Stock	0.5093	0.5128	0.5089	0.5125	13679160.0
2014-12-31 11:00:00	NVDA	Stock	0.5125	0.5128	0.5095	0.5095	13535720.0
2014-12-31 12:00:00	NVDA	Stock	0.5096	0.5098	0.505	0.505	20930240.0
2014-12-31 13:00:00	NVDA	Stock	0.5053	0.506	0.5035	0.5038	17780080.0
2014-12-31 14:00:00	NVDA	Stock	0.5038	0.5043	0.501	0.5015	19242960.0
2014-12-31 15:00:00	NVDA	Stock	0.5015	0.5025	0.4998	0.5013	47473880.0
2014-12-31 16:00:00	NVDA	Stock	0.5013	0.5039	0.4998	0.5013	14915440.0
2014-12-31 08:00:00	AMZN	Stock	15.553	15.5725	15.515	15.5725	19700.0
2014-12-31 09:00:00	AMZN	Stock	15.5995	15.649	15.5345	15.5455	3676800.0
2014-12-31 10:00:00	AMZN	Stock	15.536	15.6475	15.536	15.6442	6029080.0
2014-12-31 11:00:00	AMZN	Stock	15.6475	15.6475	15.5746	15.6295	4265320.0
2014-12-31 12:00:00	AMZN	Stock	15.6335	15.6475	15.5425	15.548	3736700.0
2014-12-31 13:00:00	AMZN	Stock	15.5485	15.6405	15.537	15.602	3262580.0
2014-12-31 14:00:00	AMZN	Stock	15.597	15.602	15.516	15.5595	4862440.0
2014-12-31 15:00:00	AMZN	Stock	15.5625	15.587	15.5005	15.518	8642100.0
2014-12-31 16:00:00	AMZN	Stock	15.5175	15.5742	15.491	15.5742	1041240.0
2014-12-31 17:00:00	AMZN	Stock	15.5175	15.54	15.5175	15.54	174060.0
2014-12-31 08:00:00	GOOGL	Stock	26.764	26.764	26.764	26.764	7180.0
2014-12-31 09:00:00	GOOGL	Stock	26.8905	26.898	26.747	26.75	1156120.0
2014-12-31 10:00:00	GOOGL	Stock	26.756	26.888	26.7545	26.8865	1702860.0
2014-12-31 11:00:00	GOOGL	Stock	26.8875	26.92	26.8008	26.817	1780480.0
2014-12-31 12:00:00	GOOGL	Stock	26.8225	26.8324	26.675	26.7148	1775680.0
2014-12-31 13:00:00	GOOGL	Stock	26.724	26.7625	26.699	26.7215	1186740.0

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

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