PREVIEW / stock_1hour / 2017-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-16.parquet
  size:    1.0 MB
  rows:    48,261
  symbols: 3,022

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
2017-06-16 04:00:00	AAPL	Stock	36.175	36.19	36.11	36.19	32872.0
2017-06-16 06:00:00	AAPL	Stock	36.125	36.1625	36.1125	36.125	8076.0
2017-06-16 07:00:00	AAPL	Stock	36.1375	36.1625	36.1375	36.14	18700.0
2017-06-16 08:00:00	AAPL	Stock	36.1275	36.145	35.9575	35.9775	202052.0
2017-06-16 09:00:00	AAPL	Stock	35.98	36.125	35.8375	36.0912	45413444.0
2017-06-16 10:00:00	AAPL	Stock	36.0875	36.095	35.75	35.7925	15094520.0
2017-06-16 11:00:00	AAPL	Stock	35.7925	35.9025	35.7472	35.8425	11712140.0
2017-06-16 12:00:00	AAPL	Stock	35.8425	35.872	35.75	35.755	7167300.0
2017-06-16 13:00:00	AAPL	Stock	35.7575	35.82	35.675	35.81	10191948.0
2017-06-16 14:00:00	AAPL	Stock	35.81	35.8725	35.735	35.7362	9515480.0
2017-06-16 15:00:00	AAPL	Stock	35.7375	35.7625	35.55	35.5625	32884460.0
2017-06-16 16:00:00	AAPL	Stock	35.5625	35.6125	35.5425	35.575	45066040.0
2017-06-16 17:00:00	AAPL	Stock	35.6	35.61	35.5675	35.6	90588.0
2017-06-16 18:00:00	AAPL	Stock	35.6	35.61	35.6	35.6075	17084.0
2017-06-16 19:00:00	AAPL	Stock	35.6075	35.6125	35.59	35.6125	36956.0
2017-06-16 05:00:00	MSFT	Stock	70.29	70.29	70.29	70.29	100.0
2017-06-16 08:00:00	MSFT	Stock	70.1	70.15	69.9	69.9	15452.0
2017-06-16 09:00:00	MSFT	Stock	69.85	70.0	69.52	69.755	14012727.0
2017-06-16 10:00:00	MSFT	Stock	69.75	69.81	69.22	69.385	3570784.0
2017-06-16 11:00:00	MSFT	Stock	69.38	69.705	69.29	69.7	2045934.0
2017-06-16 12:00:00	MSFT	Stock	69.7	69.91	69.69	69.815	1496768.0
2017-06-16 13:00:00	MSFT	Stock	69.815	69.93	69.71	69.93	1377083.0
2017-06-16 14:00:00	MSFT	Stock	69.93	70.02	69.88	69.965	1392887.0
2017-06-16 15:00:00	MSFT	Stock	69.96	70.025	69.77	69.99	6349163.0
2017-06-16 16:00:00	MSFT	Stock	69.99	70.009	69.74	70.0	14305086.0
2017-06-16 17:00:00	MSFT	Stock	69.84	69.91	69.83	69.9	9898.0
2017-06-16 18:00:00	MSFT	Stock	69.93	69.93	69.88	69.88	765.0
2017-06-16 19:00:00	MSFT	Stock	69.93	69.98	69.93	69.98	2700.0
2017-06-16 04:00:00	NVDA	Stock	3.8263	3.8508	3.8263	3.8485	59080.0
2017-06-16 05:00:00	NVDA	Stock	3.8468	3.8468	3.837	3.837	134160.0
2017-06-16 06:00:00	NVDA	Stock	3.8445	3.8525	3.8362	3.8362	397880.0
2017-06-16 07:00:00	NVDA	Stock	3.8375	3.844	3.8312	3.84	444520.0
2017-06-16 08:00:00	NVDA	Stock	3.8413	3.8422	3.8025	3.8115	4924800.0
2017-06-16 09:00:00	NVDA	Stock	3.81	3.8675	3.756	3.8583	175532920.0
2017-06-16 10:00:00	NVDA	Stock	3.8565	3.8638	3.7825	3.7923	149218320.0
2017-06-16 11:00:00	NVDA	Stock	3.7918	3.8202	3.7688	3.8112	116343640.0
2017-06-16 12:00:00	NVDA	Stock	3.8132	3.815	3.7975	3.8015	51907160.0
2017-06-16 13:00:00	NVDA	Stock	3.802	3.808	3.775	3.793	54443120.0
2017-06-16 14:00:00	NVDA	Stock	3.793	3.8272	3.7845	3.8105	60839240.0
2017-06-16 15:00:00	NVDA	Stock	3.8104	3.8148	3.7775	3.7875	91168280.0
2017-06-16 16:00:00	NVDA	Stock	3.7905	3.8097	3.7838	3.7888	135840320.0
2017-06-16 17:00:00	NVDA	Stock	3.7888	3.7888	3.7835	3.787	199920.0
2017-06-16 18:00:00	NVDA	Stock	3.7845	3.7888	3.7828	3.7888	62360.0
2017-06-16 19:00:00	NVDA	Stock	3.7888	3.7888	3.785	3.785	323040.0
2017-06-16 04:00:00	AMZN	Stock	48.4795	48.4795	48.421	48.425	21740.0
2017-06-16 06:00:00	AMZN	Stock	48.405	48.525	48.405	48.525	17300.0
2017-06-16 07:00:00	AMZN	Stock	48.4075	48.45	48.4075	48.45	18520.0
2017-06-16 08:00:00	AMZN	Stock	48.45	48.45	48.24	48.24	179760.0
2017-06-16 09:00:00	AMZN	Stock	48.287	49.9135	47.308	49.8675	74630720.0
2017-06-16 10:00:00	AMZN	Stock	49.877	49.975	49.5275	49.75	33090000.0

> showing 50 of 48,261 rows — these rows as CSV

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