PREVIEW / stock_1hour / 2016-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-01.parquet
  size:    1.0 MB
  rows:    47,841
  symbols: 3,228

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-09-01 04:00:00	AAPL	Stock	26.5675	26.5825	26.5675	26.5825	3556.0
2016-09-01 05:00:00	AAPL	Stock	26.615	26.615	26.5275	26.565	7644.0
2016-09-01 06:00:00	AAPL	Stock	26.565	26.61	26.56	26.5775	28292.0
2016-09-01 07:00:00	AAPL	Stock	26.6075	26.62	26.575	26.6125	88480.0
2016-09-01 08:00:00	AAPL	Stock	26.61	26.61	26.5425	26.55	150384.0
2016-09-01 09:00:00	AAPL	Stock	26.55	26.6175	26.4875	26.5512	12965972.0
2016-09-01 10:00:00	AAPL	Stock	26.55	26.5862	26.405	26.4865	17768312.0
2016-09-01 11:00:00	AAPL	Stock	26.485	26.5525	26.4375	26.5475	9871944.0
2016-09-01 12:00:00	AAPL	Stock	26.5472	26.6475	26.53	26.635	10800320.0
2016-09-01 13:00:00	AAPL	Stock	26.6362	26.7	26.6225	26.6625	8502724.0
2016-09-01 14:00:00	AAPL	Stock	26.66	26.6725	26.6175	26.655	7938116.0
2016-09-01 15:00:00	AAPL	Stock	26.6575	26.6825	26.5775	26.6825	14073352.0
2016-09-01 16:00:00	AAPL	Stock	26.6775	26.6875	26.56	26.655	5354032.0
2016-09-01 17:00:00	AAPL	Stock	26.6775	26.685	26.625	26.625	34020.0
2016-09-01 18:00:00	AAPL	Stock	26.6775	26.6825	26.675	26.6775	5400.0
2016-09-01 19:00:00	AAPL	Stock	26.6625	26.685	26.6625	26.685	20876.0
2016-09-01 05:00:00	MSFT	Stock	57.6	57.6	57.42	57.48	4453.0
2016-09-01 06:00:00	MSFT	Stock	57.5	57.76	57.5	57.54	16236.0
2016-09-01 07:00:00	MSFT	Stock	57.68	57.68	57.5	57.52	6267.0
2016-09-01 08:00:00	MSFT	Stock	57.52	57.52	57.28	57.39	17537.0
2016-09-01 09:00:00	MSFT	Stock	57.35	57.71	57.01	57.51	3598277.0
2016-09-01 10:00:00	MSFT	Stock	57.505	57.58	57.152	57.24	3553966.0
2016-09-01 11:00:00	MSFT	Stock	57.245	57.5	57.14	57.43	2551743.0
2016-09-01 12:00:00	MSFT	Stock	57.43	57.78	57.405	57.704	2589614.0
2016-09-01 13:00:00	MSFT	Stock	57.7	57.82	57.63	57.64	2239095.0
2016-09-01 14:00:00	MSFT	Stock	57.645	57.65	57.46	57.52	2857248.0
2016-09-01 15:00:00	MSFT	Stock	57.52	57.65	57.33	57.59	5148878.0
2016-09-01 16:00:00	MSFT	Stock	57.58	57.6	57.49	57.49	1516191.0
2016-09-01 17:00:00	MSFT	Stock	57.51	57.51	57.51	57.51	200.0
2016-09-01 18:00:00	MSFT	Stock	57.51	57.51	57.51	57.51	980.0
2016-09-01 19:00:00	MSFT	Stock	57.55	57.55	57.55	57.55	1000.0
2016-09-01 08:00:00	NVDA	Stock	1.5403	1.5468	1.5395	1.5398	326800.0
2016-09-01 09:00:00	NVDA	Stock	1.541	1.5738	1.533	1.5732	76632440.0
2016-09-01 10:00:00	NVDA	Stock	1.573	1.573	1.5545	1.5602	55529880.0
2016-09-01 11:00:00	NVDA	Stock	1.5604	1.5675	1.5552	1.5652	38431480.0
2016-09-01 12:00:00	NVDA	Stock	1.5655	1.5762	1.5655	1.5741	74944320.0
2016-09-01 13:00:00	NVDA	Stock	1.5743	1.581	1.574	1.58	40893160.0
2016-09-01 14:00:00	NVDA	Stock	1.5798	1.5845	1.5752	1.5839	42051120.0
2016-09-01 15:00:00	NVDA	Stock	1.5838	1.5842	1.575	1.5785	82339760.0
2016-09-01 16:00:00	NVDA	Stock	1.5788	1.5823	1.571	1.5788	7639720.0
2016-09-01 17:00:00	NVDA	Stock	1.5775	1.5785	1.5775	1.5785	147200.0
2016-09-01 18:00:00	NVDA	Stock	1.5775	1.5775	1.5775	1.5775	82240.0
2016-09-01 19:00:00	NVDA	Stock	1.5775	1.5788	1.5775	1.5788	24000.0
2016-09-01 04:00:00	AMZN	Stock	38.565	38.565	38.565	38.565	2000.0
2016-09-01 07:00:00	AMZN	Stock	38.5625	38.5875	38.5625	38.5875	16460.0
2016-09-01 08:00:00	AMZN	Stock	38.458	38.5125	38.458	38.4985	132620.0
2016-09-01 09:00:00	AMZN	Stock	38.5	38.575	38.4075	38.485	4262900.0
2016-09-01 10:00:00	AMZN	Stock	38.479	38.5615	38.3655	38.408	5792700.0
2016-09-01 11:00:00	AMZN	Stock	38.4025	38.4455	38.3375	38.4035	3361220.0
2016-09-01 12:00:00	AMZN	Stock	38.402	38.55	38.394	38.5325	3706780.0

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

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