PREVIEW / stock_1hour / 2017-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-05.parquet
  size:    1.0 MB
  rows:    48,051
  symbols: 3,050

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-05 04:00:00	AAPL	Stock	38.6	38.6	38.465	38.465	70720.0
2017-06-05 05:00:00	AAPL	Stock	38.5675	38.5675	38.545	38.545	2724.0
2017-06-05 06:00:00	AAPL	Stock	38.5275	38.54	38.465	38.525	35596.0
2017-06-05 07:00:00	AAPL	Stock	38.535	38.575	38.51	38.55	237948.0
2017-06-05 08:00:00	AAPL	Stock	38.57	38.8625	38.49	38.59	1070436.0
2017-06-05 09:00:00	AAPL	Stock	38.58	38.6225	38.365	38.525	20641472.0
2017-06-05 10:00:00	AAPL	Stock	38.525	38.595	38.415	38.4475	15609584.0
2017-06-05 11:00:00	AAPL	Stock	38.45	38.515	38.42	38.455	10342572.0
2017-06-05 12:00:00	AAPL	Stock	38.4525	38.4875	38.4288	38.4575	6501156.0
2017-06-05 13:00:00	AAPL	Stock	38.46	38.5425	38.4275	38.4325	7843456.0
2017-06-05 14:00:00	AAPL	Stock	38.43	38.49	38.415	38.44	6534940.0
2017-06-05 15:00:00	AAPL	Stock	38.4425	38.49	38.3975	38.4825	14264012.0
2017-06-05 16:00:00	AAPL	Stock	38.4825	38.5025	38.4425	38.485	6418056.0
2017-06-05 17:00:00	AAPL	Stock	38.4975	38.4975	38.465	38.475	85052.0
2017-06-05 18:00:00	AAPL	Stock	38.4725	38.5	38.4725	38.5	64108.0
2017-06-05 19:00:00	AAPL	Stock	38.48	38.5	38.4775	38.5	57688.0
2017-06-05 07:00:00	MSFT	Stock	71.98	71.99	71.43	71.83	2521.0
2017-06-05 08:00:00	MSFT	Stock	71.76	71.76	71.68	71.68	28692.0
2017-06-05 09:00:00	MSFT	Stock	71.7	72.418	71.61	72.38	3083318.0
2017-06-05 10:00:00	MSFT	Stock	72.38	72.89	72.31	72.61	5107145.0
2017-06-05 11:00:00	MSFT	Stock	72.615	72.81	72.51	72.68	3752523.0
2017-06-05 12:00:00	MSFT	Stock	72.69	72.78	72.24	72.3	2221928.0
2017-06-05 13:00:00	MSFT	Stock	72.31	72.485	72.265	72.288	2134919.0
2017-06-05 14:00:00	MSFT	Stock	72.29	72.455	72.255	72.36	2470683.0
2017-06-05 15:00:00	MSFT	Stock	72.37	72.445	72.27	72.28	6053945.0
2017-06-05 16:00:00	MSFT	Stock	72.29	72.725	72.25	72.37	4921259.0
2017-06-05 17:00:00	MSFT	Stock	72.38	72.38	72.28	72.38	3989.0
2017-06-05 18:00:00	MSFT	Stock	72.38	72.38	72.28	72.38	970.0
2017-06-05 19:00:00	MSFT	Stock	72.35	72.35	72.31	72.31	1398.0
2017-06-05 07:00:00	NVDA	Stock	3.575	3.5812	3.5702	3.58	57760.0
2017-06-05 08:00:00	NVDA	Stock	3.5768	3.591	3.565	3.5675	1421880.0
2017-06-05 09:00:00	NVDA	Stock	3.5718	3.6472	3.5625	3.6455	138206800.0
2017-06-05 10:00:00	NVDA	Stock	3.6454	3.6925	3.6392	3.665	204736000.0
2017-06-05 11:00:00	NVDA	Stock	3.665	3.6888	3.6648	3.6755	96774800.0
2017-06-05 12:00:00	NVDA	Stock	3.675	3.6945	3.6725	3.6878	70094440.0
2017-06-05 13:00:00	NVDA	Stock	3.6875	3.699	3.681	3.6964	86187760.0
2017-06-05 14:00:00	NVDA	Stock	3.6964	3.7133	3.688	3.7035	82237040.0
2017-06-05 15:00:00	NVDA	Stock	3.7032	3.707	3.6892	3.7002	90091400.0
2017-06-05 16:00:00	NVDA	Stock	3.7002	3.7013	3.697	3.6975	15653200.0
2017-06-05 17:00:00	NVDA	Stock	3.6988	3.7013	3.6978	3.7	306680.0
2017-06-05 18:00:00	NVDA	Stock	3.7	3.705	3.698	3.705	378200.0
2017-06-05 19:00:00	NVDA	Stock	3.7013	3.7053	3.7013	3.7048	217560.0
2017-06-05 07:00:00	AMZN	Stock	50.265	50.265	50.265	50.265	3000.0
2017-06-05 08:00:00	AMZN	Stock	50.265	50.3365	50.249	50.25	119440.0
2017-06-05 09:00:00	AMZN	Stock	50.245	50.475	50.1755	50.375	13096320.0
2017-06-05 10:00:00	AMZN	Stock	50.375	50.6255	50.3555	50.5285	7720940.0
2017-06-05 11:00:00	AMZN	Stock	50.535	50.6018	50.4765	50.5675	4501720.0
2017-06-05 12:00:00	AMZN	Stock	50.561	50.613	50.502	50.556	2803360.0
2017-06-05 13:00:00	AMZN	Stock	50.556	50.6195	50.5475	50.555	3333120.0
2017-06-05 14:00:00	AMZN	Stock	50.5575	50.66	50.5575	50.6125	3936140.0

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

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