PREVIEW / stock_1hour / 2017-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-08.parquet
  size:    1.0 MB
  rows:    47,788
  symbols: 3,027

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-08 04:00:00	AAPL	Stock	38.9175	38.9175	38.9175	38.9175	436.0
2017-06-08 05:00:00	AAPL	Stock	38.92	38.94	38.92	38.94	10296.0
2017-06-08 06:00:00	AAPL	Stock	38.9125	38.965	38.9125	38.95	27964.0
2017-06-08 07:00:00	AAPL	Stock	38.9575	38.9625	38.9375	38.9475	12748.0
2017-06-08 08:00:00	AAPL	Stock	38.925	38.97	38.8875	38.9	185824.0
2017-06-08 09:00:00	AAPL	Stock	38.9	38.9175	38.6125	38.6875	12184796.0
2017-06-08 10:00:00	AAPL	Stock	38.6875	38.7575	38.6	38.7463	12748656.0
2017-06-08 11:00:00	AAPL	Stock	38.7475	38.795	38.7202	38.775	7699528.0
2017-06-08 12:00:00	AAPL	Stock	38.775	38.7972	38.71	38.7525	6109788.0
2017-06-08 13:00:00	AAPL	Stock	38.7525	38.77	38.645	38.7058	6264820.0
2017-06-08 14:00:00	AAPL	Stock	38.7052	38.7225	38.6325	38.6565	6677764.0
2017-06-08 15:00:00	AAPL	Stock	38.6575	38.7875	38.655	38.73	11049844.0
2017-06-08 16:00:00	AAPL	Stock	38.745	38.7475	38.7	38.7325	9775768.0
2017-06-08 17:00:00	AAPL	Stock	38.7175	38.7175	38.6825	38.6975	32596.0
2017-06-08 18:00:00	AAPL	Stock	38.6975	38.7	38.675	38.6875	27604.0
2017-06-08 19:00:00	AAPL	Stock	38.6825	38.7	38.6625	38.675	36844.0
2017-06-08 05:00:00	MSFT	Stock	72.3	72.3	72.3	72.3	1400.0
2017-06-08 06:00:00	MSFT	Stock	72.2	72.2	72.2	72.2	500.0
2017-06-08 07:00:00	MSFT	Stock	72.44	72.44	72.38	72.38	800.0
2017-06-08 08:00:00	MSFT	Stock	72.39	72.5	72.38	72.41	13136.0
2017-06-08 09:00:00	MSFT	Stock	72.41	72.58	71.93	72.025	2612689.0
2017-06-08 10:00:00	MSFT	Stock	72.025	72.23	71.84	72.07	2753535.0
2017-06-08 11:00:00	MSFT	Stock	72.07	72.12	71.95	71.98	2617927.0
2017-06-08 12:00:00	MSFT	Stock	71.99	72.09	71.94	72.08	1725862.0
2017-06-08 13:00:00	MSFT	Stock	72.08	72.09	71.7	71.78	2407370.0
2017-06-08 14:00:00	MSFT	Stock	71.78	71.815	71.5	71.545	2471251.0
2017-06-08 15:00:00	MSFT	Stock	71.545	71.96	71.545	71.93	5187707.0
2017-06-08 16:00:00	MSFT	Stock	71.95	71.95	71.78	71.93	2126143.0
2017-06-08 17:00:00	MSFT	Stock	71.94	71.95	71.8	71.8	3279.0
2017-06-08 18:00:00	MSFT	Stock	71.85	71.88	71.83	71.85	3939.0
2017-06-08 19:00:00	MSFT	Stock	71.84	71.87	71.83	71.87	1339.0
2017-06-08 04:00:00	NVDA	Stock	3.7375	3.7375	3.7375	3.7375	4000.0
2017-06-08 05:00:00	NVDA	Stock	3.746	3.8058	3.746	3.7992	553480.0
2017-06-08 06:00:00	NVDA	Stock	3.7938	3.825	3.7875	3.825	1233720.0
2017-06-08 07:00:00	NVDA	Stock	3.83	3.845	3.83	3.842	1778120.0
2017-06-08 08:00:00	NVDA	Stock	3.8388	3.8625	3.8248	3.8565	8553240.0
2017-06-08 09:00:00	NVDA	Stock	3.8565	3.859	3.7948	3.8202	177057760.0
2017-06-08 10:00:00	NVDA	Stock	3.8218	3.847	3.7975	3.8419	135555680.0
2017-06-08 11:00:00	NVDA	Stock	3.842	3.913	3.8418	3.9112	159183840.0
2017-06-08 12:00:00	NVDA	Stock	3.911	3.9642	3.9078	3.9583	205242560.0
2017-06-08 13:00:00	NVDA	Stock	3.9581	3.9722	3.9395	3.969	123244920.0
2017-06-08 14:00:00	NVDA	Stock	3.968	3.9702	3.942	3.9598	95747520.0
2017-06-08 15:00:00	NVDA	Stock	3.96	4.0	3.9462	3.9985	196235960.0
2017-06-08 16:00:00	NVDA	Stock	3.9998	4.0632	3.9962	4.0505	28360840.0
2017-06-08 17:00:00	NVDA	Stock	4.0525	4.055	4.0262	4.0492	3663840.0
2017-06-08 18:00:00	NVDA	Stock	4.0475	4.0582	4.0338	4.05	3771000.0
2017-06-08 19:00:00	NVDA	Stock	4.05	4.0525	4.0303	4.0425	5752800.0
2017-06-08 04:00:00	AMZN	Stock	50.735	50.735	50.6	50.6	7620.0
2017-06-08 05:00:00	AMZN	Stock	50.6	50.6	50.6	50.6	10000.0
2017-06-08 06:00:00	AMZN	Stock	50.625	50.7	50.625	50.675	81440.0

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

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