PREVIEW / stock_1hour / 2016-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-13.parquet
  size:    1.0 MB
  rows:    48,068
  symbols: 3,242

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-07-13 04:00:00	AAPL	Stock	24.3775	24.4325	24.37	24.39	8240.0
2016-07-13 06:00:00	AAPL	Stock	24.4475	24.47	24.42	24.46	7144.0
2016-07-13 07:00:00	AAPL	Stock	24.4425	24.4575	24.4	24.405	21384.0
2016-07-13 08:00:00	AAPL	Stock	24.4	24.4125	24.365	24.4075	187888.0
2016-07-13 09:00:00	AAPL	Stock	24.4025	24.4175	24.295	24.3175	14925336.0
2016-07-13 10:00:00	AAPL	Stock	24.3175	24.37	24.295	24.3382	13385272.0
2016-07-13 11:00:00	AAPL	Stock	24.3375	24.3638	24.26	24.2675	10778820.0
2016-07-13 12:00:00	AAPL	Stock	24.27	24.2975	24.2325	24.285	8642404.0
2016-07-13 13:00:00	AAPL	Stock	24.2825	24.3175	24.26	24.2908	7305208.0
2016-07-13 14:00:00	AAPL	Stock	24.2925	24.3225	24.2425	24.2472	9773876.0
2016-07-13 15:00:00	AAPL	Stock	24.245	24.275	24.21	24.2175	16968420.0
2016-07-13 16:00:00	AAPL	Stock	24.2175	24.242	24.2025	24.2125	12663708.0
2016-07-13 17:00:00	AAPL	Stock	24.2125	24.225	24.2075	24.2075	881540.0
2016-07-13 18:00:00	AAPL	Stock	24.21	24.21	24.1775	24.19	18776.0
2016-07-13 19:00:00	AAPL	Stock	24.1975	24.21	24.1825	24.2	17984.0
2016-07-13 04:00:00	MSFT	Stock	53.28	53.28	53.28	53.28	260.0
2016-07-13 05:00:00	MSFT	Stock	53.48	53.48	53.48	53.48	260.0
2016-07-13 06:00:00	MSFT	Stock	53.47	53.47	53.47	53.47	120.0
2016-07-13 08:00:00	MSFT	Stock	53.4	53.42	53.37	53.4	9613.0
2016-07-13 09:00:00	MSFT	Stock	53.35	53.56	53.18	53.49	2389061.0
2016-07-13 10:00:00	MSFT	Stock	53.49	53.63	53.41	53.54	2904083.0
2016-07-13 11:00:00	MSFT	Stock	53.54	53.585	53.47	53.57	2985988.0
2016-07-13 12:00:00	MSFT	Stock	53.57	53.66	53.52	53.595	1960313.0
2016-07-13 13:00:00	MSFT	Stock	53.59	53.72	53.53	53.62	1794595.0
2016-07-13 14:00:00	MSFT	Stock	53.615	53.8	53.6	53.76	2404139.0
2016-07-13 15:00:00	MSFT	Stock	53.755	53.86	53.5	53.511	6752281.0
2016-07-13 16:00:00	MSFT	Stock	53.51	53.62	53.191	53.51	2800713.0
2016-07-13 17:00:00	MSFT	Stock	53.52	53.52	53.52	53.52	106244.0
2016-07-13 18:00:00	MSFT	Stock	53.52	53.52	53.4	53.41	3524.0
2016-07-13 19:00:00	MSFT	Stock	53.41	53.55	53.41	53.55	6700.0
2016-07-13 04:00:00	NVDA	Stock	1.32	1.32	1.32	1.32	4000.0
2016-07-13 08:00:00	NVDA	Stock	1.3245	1.3245	1.3212	1.3212	88640.0
2016-07-13 09:00:00	NVDA	Stock	1.3228	1.33	1.3182	1.3248	64708560.0
2016-07-13 10:00:00	NVDA	Stock	1.3248	1.3271	1.3185	1.3245	47241200.0
2016-07-13 11:00:00	NVDA	Stock	1.3248	1.327	1.3208	1.3224	36049200.0
2016-07-13 12:00:00	NVDA	Stock	1.3223	1.3251	1.3223	1.3248	18231200.0
2016-07-13 13:00:00	NVDA	Stock	1.3248	1.3273	1.3238	1.3252	23855880.0
2016-07-13 14:00:00	NVDA	Stock	1.3252	1.3252	1.322	1.324	22233360.0
2016-07-13 15:00:00	NVDA	Stock	1.3238	1.3249	1.3175	1.3195	52593840.0
2016-07-13 16:00:00	NVDA	Stock	1.3195	1.3195	1.3195	1.3195	37081480.0
2016-07-13 17:00:00	NVDA	Stock	1.32	1.32	1.32	1.32	4000.0
2016-07-13 18:00:00	NVDA	Stock	1.32	1.32	1.3175	1.3175	105200.0
2016-07-13 19:00:00	NVDA	Stock	1.3188	1.3188	1.3188	1.3188	42000.0
2016-07-13 04:00:00	AMZN	Stock	37.3645	37.3645	37.325	37.325	7380.0
2016-07-13 06:00:00	AMZN	Stock	37.415	37.415	37.41	37.41	14120.0
2016-07-13 07:00:00	AMZN	Stock	37.375	37.375	37.2875	37.2875	32420.0
2016-07-13 08:00:00	AMZN	Stock	37.25	37.357	37.25	37.35	100800.0
2016-07-13 09:00:00	AMZN	Stock	37.326	37.8435	37.0625	37.566	26621120.0
2016-07-13 10:00:00	AMZN	Stock	37.6	37.758	37.5315	37.5832	12032180.0
2016-07-13 11:00:00	AMZN	Stock	37.585	37.634	37.1435	37.2775	10019040.0

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

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