PREVIEW / stock_1hour / 2016-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-26.parquet
  size:    1.0 MB
  rows:    47,616
  symbols: 3,246

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
2016-08-26 04:00:00	AAPL	Stock	26.9525	26.9525	26.905	26.905	2000.0
2016-08-26 05:00:00	AAPL	Stock	26.9025	26.9025	26.9	26.9	1600.0
2016-08-26 06:00:00	AAPL	Stock	26.8975	26.8975	26.8975	26.8975	400.0
2016-08-26 07:00:00	AAPL	Stock	26.8575	26.875	26.8375	26.8375	11920.0
2016-08-26 08:00:00	AAPL	Stock	26.8375	26.8625	26.825	26.85	54520.0
2016-08-26 09:00:00	AAPL	Stock	26.86	26.9725	26.8025	26.805	11778144.0
2016-08-26 10:00:00	AAPL	Stock	26.8025	26.9875	26.7575	26.8912	19496440.0
2016-08-26 11:00:00	AAPL	Stock	26.8925	26.92	26.735	26.76	11608136.0
2016-08-26 12:00:00	AAPL	Stock	26.7605	26.77	26.5775	26.7425	18374652.0
2016-08-26 13:00:00	AAPL	Stock	26.74	26.7825	26.6708	26.69	7548228.0
2016-08-26 14:00:00	AAPL	Stock	26.6925	26.7225	26.63	26.6725	9867484.0
2016-08-26 15:00:00	AAPL	Stock	26.6725	26.775	26.6562	26.735	16619060.0
2016-08-26 16:00:00	AAPL	Stock	26.735	26.8932	26.735	26.7475	7791116.0
2016-08-26 17:00:00	AAPL	Stock	26.7375	26.745	26.73	26.73	41372.0
2016-08-26 18:00:00	AAPL	Stock	26.73	26.7325	26.725	26.725	7868.0
2016-08-26 19:00:00	AAPL	Stock	26.725	26.7325	26.72	26.725	15780.0
2016-08-26 05:00:00	MSFT	Stock	58.1	58.1	58.1	58.1	206.0
2016-08-26 07:00:00	MSFT	Stock	58.1	58.1	58.1	58.1	197.0
2016-08-26 08:00:00	MSFT	Stock	58.1	58.16	58.1	58.16	1768.0
2016-08-26 09:00:00	MSFT	Stock	58.14	58.6	58.1	58.34	2674703.0
2016-08-26 10:00:00	MSFT	Stock	58.34	58.7	58.09	58.58	2688277.0
2016-08-26 11:00:00	MSFT	Stock	58.57	58.58	58.11	58.125	2251156.0
2016-08-26 12:00:00	MSFT	Stock	58.12	58.125	57.81	57.93	2672973.0
2016-08-26 13:00:00	MSFT	Stock	57.94	58.01	57.78	57.82	1666176.0
2016-08-26 14:00:00	MSFT	Stock	57.82	57.9	57.69	57.835	2093826.0
2016-08-26 15:00:00	MSFT	Stock	57.83	58.11	57.81	58.04	4151753.0
2016-08-26 16:00:00	MSFT	Stock	58.04	58.07	57.94	58.0	1678739.0
2016-08-26 17:00:00	MSFT	Stock	58.0	58.03	58.0	58.03	615.0
2016-08-26 19:00:00	MSFT	Stock	58.0	58.0	58.0	58.0	200.0
2016-08-26 07:00:00	NVDA	Stock	1.5388	1.5388	1.5388	1.5388	8000.0
2016-08-26 08:00:00	NVDA	Stock	1.5385	1.5472	1.5383	1.54	137160.0
2016-08-26 09:00:00	NVDA	Stock	1.5412	1.5528	1.5412	1.5485	29958520.0
2016-08-26 10:00:00	NVDA	Stock	1.5483	1.5592	1.5408	1.5552	61228440.0
2016-08-26 11:00:00	NVDA	Stock	1.5554	1.5595	1.5428	1.544	38075280.0
2016-08-26 12:00:00	NVDA	Stock	1.5435	1.5458	1.53	1.5453	43694480.0
2016-08-26 13:00:00	NVDA	Stock	1.5455	1.5475	1.5395	1.5412	27655360.0
2016-08-26 14:00:00	NVDA	Stock	1.541	1.5453	1.537	1.542	32328320.0
2016-08-26 15:00:00	NVDA	Stock	1.542	1.5523	1.5412	1.5508	52812720.0
2016-08-26 16:00:00	NVDA	Stock	1.5508	1.5523	1.549	1.5508	7010840.0
2016-08-26 17:00:00	NVDA	Stock	1.5475	1.5505	1.5475	1.5475	30000.0
2016-08-26 18:00:00	NVDA	Stock	1.55	1.5508	1.5488	1.549	99560.0
2016-08-26 19:00:00	NVDA	Stock	1.549	1.5515	1.5488	1.5488	70800.0
2016-08-26 08:00:00	AMZN	Stock	37.875	37.875	37.875	37.875	2840.0
2016-08-26 09:00:00	AMZN	Stock	37.905	38.244	37.905	38.1305	4897360.0
2016-08-26 10:00:00	AMZN	Stock	38.114	38.417	38.0155	38.3856	9184760.0
2016-08-26 11:00:00	AMZN	Stock	38.3915	38.43	38.22	38.2745	5417420.0
2016-08-26 12:00:00	AMZN	Stock	38.2655	38.2805	38.1005	38.212	4799340.0
2016-08-26 13:00:00	AMZN	Stock	38.209	38.2525	38.1725	38.219	2417980.0
2016-08-26 14:00:00	AMZN	Stock	38.212	38.2652	38.1664	38.265	4376760.0
2016-08-26 15:00:00	AMZN	Stock	38.27	38.5	38.239	38.452	11183420.0

> showing 50 of 47,616 rows — these rows as CSV

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