PREVIEW / stock_1hour / 2017-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-06.parquet
  size:    1.0 MB
  rows:    47,914
  symbols: 3,038

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-06 05:00:00	AAPL	Stock	38.5	38.5225	38.5	38.5225	4944.0
2017-06-06 06:00:00	AAPL	Stock	38.5225	38.525	38.4625	38.4825	26492.0
2017-06-06 07:00:00	AAPL	Stock	38.495	38.5	38.375	38.42	102548.0
2017-06-06 08:00:00	AAPL	Stock	38.42	38.475	38.32	38.4	174728.0
2017-06-06 09:00:00	AAPL	Stock	38.41	38.7025	38.4	38.4825	15663780.0
2017-06-06 10:00:00	AAPL	Stock	38.485	38.685	38.45	38.6585	13363392.0
2017-06-06 11:00:00	AAPL	Stock	38.6562	38.6925	38.545	38.591	8241916.0
2017-06-06 12:00:00	AAPL	Stock	38.5908	38.7	38.5725	38.6775	6358436.0
2017-06-06 13:00:00	AAPL	Stock	38.6763	38.7	38.625	38.6975	5119052.0
2017-06-06 14:00:00	AAPL	Stock	38.6985	38.935	38.685	38.915	13748880.0
2017-06-06 15:00:00	AAPL	Stock	38.916	38.9525	38.5475	38.6125	23399588.0
2017-06-06 16:00:00	AAPL	Stock	38.6125	38.838	38.6	38.6075	9591044.0
2017-06-06 17:00:00	AAPL	Stock	38.6125	38.6175	38.6075	38.6125	41712.0
2017-06-06 18:00:00	AAPL	Stock	38.6125	38.625	38.6	38.62	18532.0
2017-06-06 19:00:00	AAPL	Stock	38.625	38.635	38.6025	38.635	40152.0
2017-06-06 04:00:00	MSFT	Stock	72.28	72.28	72.28	72.28	200.0
2017-06-06 05:00:00	MSFT	Stock	72.26	72.26	72.26	72.26	1800.0
2017-06-06 06:00:00	MSFT	Stock	72.35	72.39	72.35	72.39	2331.0
2017-06-06 07:00:00	MSFT	Stock	72.21	72.25	72.21	72.25	3098.0
2017-06-06 08:00:00	MSFT	Stock	72.22	72.29	72.16	72.28	24356.0
2017-06-06 09:00:00	MSFT	Stock	72.27	72.54	72.15	72.49	3676504.0
2017-06-06 10:00:00	MSFT	Stock	72.49	72.62	72.405	72.565	4480690.0
2017-06-06 11:00:00	MSFT	Stock	72.565	72.59	72.43	72.44	3280434.0
2017-06-06 12:00:00	MSFT	Stock	72.435	72.45	72.31	72.37	2232822.0
2017-06-06 13:00:00	MSFT	Stock	72.363	72.46	72.29	72.331	1478831.0
2017-06-06 14:00:00	MSFT	Stock	72.34	72.59	72.31	72.555	2853302.0
2017-06-06 15:00:00	MSFT	Stock	72.55	72.615	72.33	72.52	7577484.0
2017-06-06 16:00:00	MSFT	Stock	72.52	72.54	72.47	72.54	2452446.0
2017-06-06 17:00:00	MSFT	Stock	72.52	72.59	72.48	72.48	390.0
2017-06-06 18:00:00	MSFT	Stock	72.48	72.55	72.48	72.55	1068.0
2017-06-06 19:00:00	MSFT	Stock	72.55	72.59	72.51	72.59	2896.0
2017-06-06 04:00:00	NVDA	Stock	3.675	3.6825	3.675	3.6825	39400.0
2017-06-06 05:00:00	NVDA	Stock	3.6825	3.6825	3.6752	3.6775	60080.0
2017-06-06 06:00:00	NVDA	Stock	3.6825	3.6838	3.6702	3.6752	137360.0
2017-06-06 07:00:00	NVDA	Stock	3.6775	3.6873	3.67	3.675	663120.0
2017-06-06 08:00:00	NVDA	Stock	3.6752	3.6862	3.6725	3.6825	2737840.0
2017-06-06 09:00:00	NVDA	Stock	3.6838	3.7362	3.6808	3.7115	169621200.0
2017-06-06 10:00:00	NVDA	Stock	3.7128	3.7422	3.6992	3.7304	134110080.0
2017-06-06 11:00:00	NVDA	Stock	3.7312	3.7342	3.7155	3.72	74375440.0
2017-06-06 12:00:00	NVDA	Stock	3.7202	3.729	3.7095	3.7195	44539720.0
2017-06-06 13:00:00	NVDA	Stock	3.719	3.7215	3.6888	3.6962	58057320.0
2017-06-06 14:00:00	NVDA	Stock	3.696	3.7218	3.6918	3.7178	59299200.0
2017-06-06 15:00:00	NVDA	Stock	3.718	3.7212	3.67	3.6838	121757760.0
2017-06-06 16:00:00	NVDA	Stock	3.6835	3.685	3.675	3.6795	2497800.0
2017-06-06 17:00:00	NVDA	Stock	3.682	3.6838	3.6812	3.6812	182840.0
2017-06-06 18:00:00	NVDA	Stock	3.6825	3.6835	3.68	3.682	247720.0
2017-06-06 19:00:00	NVDA	Stock	3.682	3.685	3.6803	3.6825	127840.0
2017-06-06 06:00:00	AMZN	Stock	50.538	50.538	50.538	50.538	4000.0
2017-06-06 07:00:00	AMZN	Stock	50.5	50.5	50.4	50.4	25920.0
2017-06-06 08:00:00	AMZN	Stock	50.4	50.567	50.4	50.567	162720.0

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

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