PREVIEW / stock_1hour / 2016-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-03.parquet
  size:    1.0 MB
  rows:    47,674
  symbols: 3,173

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-11-03 04:00:00	AAPL	Stock	27.685	27.685	27.6625	27.6825	9120.0
2016-11-03 05:00:00	AAPL	Stock	27.6825	27.7325	27.6825	27.7325	12004.0
2016-11-03 06:00:00	AAPL	Stock	27.73	27.7325	27.7	27.7125	15084.0
2016-11-03 07:00:00	AAPL	Stock	27.7225	27.7925	27.7225	27.79	48796.0
2016-11-03 08:00:00	AAPL	Stock	27.735	27.8	27.7	27.7425	300864.0
2016-11-03 09:00:00	AAPL	Stock	27.725	27.865	27.675	27.75	10187304.0
2016-11-03 10:00:00	AAPL	Stock	27.7475	27.76	27.675	27.7175	10447672.0
2016-11-03 11:00:00	AAPL	Stock	27.7175	27.725	27.5875	27.61	9790244.0
2016-11-03 12:00:00	AAPL	Stock	27.6118	27.635	27.57	27.5768	9721796.0
2016-11-03 13:00:00	AAPL	Stock	27.575	27.5825	27.4475	27.5138	15793052.0
2016-11-03 14:00:00	AAPL	Stock	27.5125	27.5375	27.455	27.4875	11652300.0
2016-11-03 15:00:00	AAPL	Stock	27.4875	27.4975	27.3875	27.455	19853164.0
2016-11-03 16:00:00	AAPL	Stock	27.45	27.4575	27.3825	27.4075	8263336.0
2016-11-03 17:00:00	AAPL	Stock	27.425	27.4625	27.3825	27.3825	143372.0
2016-11-03 18:00:00	AAPL	Stock	27.395	27.4075	27.3575	27.4075	218284.0
2016-11-03 19:00:00	AAPL	Stock	27.405	27.4125	27.385	27.4125	1289176.0
2016-11-03 05:00:00	MSFT	Stock	59.3	59.33	59.3	59.33	2600.0
2016-11-03 07:00:00	MSFT	Stock	59.34	59.57	59.34	59.57	6465.0
2016-11-03 08:00:00	MSFT	Stock	59.53	59.57	59.45	59.54	5797.0
2016-11-03 09:00:00	MSFT	Stock	59.55	59.69	59.35	59.35	1931241.0
2016-11-03 10:00:00	MSFT	Stock	59.35	59.41	59.24	59.34	2808863.0
2016-11-03 11:00:00	MSFT	Stock	59.33	59.37	59.24	59.34	1913130.0
2016-11-03 12:00:00	MSFT	Stock	59.34	59.34	59.13	59.22	1877232.0
2016-11-03 13:00:00	MSFT	Stock	59.21	59.28	59.11	59.145	1708206.0
2016-11-03 14:00:00	MSFT	Stock	59.15	59.28	59.11	59.27	2030031.0
2016-11-03 15:00:00	MSFT	Stock	59.26	59.273	59.12	59.2	4433985.0
2016-11-03 16:00:00	MSFT	Stock	59.21	59.25	59.15	59.25	3134558.0
2016-11-03 17:00:00	MSFT	Stock	59.15	59.19	59.15	59.19	350.0
2016-11-03 18:00:00	MSFT	Stock	59.21	59.21	59.19	59.205	149502.0
2016-11-03 19:00:00	MSFT	Stock	59.2	59.25	59.2	59.25	1456.0
2016-11-03 04:00:00	NVDA	Stock	1.7012	1.7012	1.7012	1.7012	4000.0
2016-11-03 06:00:00	NVDA	Stock	1.7075	1.7075	1.7062	1.7062	40000.0
2016-11-03 07:00:00	NVDA	Stock	1.7168	1.7175	1.7168	1.7175	16760.0
2016-11-03 08:00:00	NVDA	Stock	1.7175	1.7365	1.7175	1.7325	591560.0
2016-11-03 09:00:00	NVDA	Stock	1.7312	1.7312	1.672	1.674	51230200.0
2016-11-03 10:00:00	NVDA	Stock	1.6738	1.698	1.666	1.695	73447920.0
2016-11-03 11:00:00	NVDA	Stock	1.695	1.716	1.6948	1.71	33531680.0
2016-11-03 12:00:00	NVDA	Stock	1.7099	1.7106	1.7038	1.7055	25807920.0
2016-11-03 13:00:00	NVDA	Stock	1.7052	1.7053	1.6958	1.6965	28585200.0
2016-11-03 14:00:00	NVDA	Stock	1.6968	1.7095	1.6951	1.7085	28860240.0
2016-11-03 15:00:00	NVDA	Stock	1.7082	1.709	1.6962	1.6992	52973280.0
2016-11-03 16:00:00	NVDA	Stock	1.699	1.7035	1.697	1.6988	8305800.0
2016-11-03 17:00:00	NVDA	Stock	1.6975	1.699	1.6965	1.699	283880.0
2016-11-03 18:00:00	NVDA	Stock	1.705	1.7112	1.7048	1.7058	293600.0
2016-11-03 19:00:00	NVDA	Stock	1.7058	1.7058	1.703	1.703	32000.0
2016-11-03 05:00:00	AMZN	Stock	37.9835	37.9835	37.9605	37.9605	13000.0
2016-11-03 06:00:00	AMZN	Stock	38.024	38.0915	38.024	38.05	10000.0
2016-11-03 07:00:00	AMZN	Stock	38.0305	38.301	38.0085	38.3	374000.0
2016-11-03 08:00:00	AMZN	Stock	38.283	38.445	38.2265	38.4125	360120.0
2016-11-03 09:00:00	AMZN	Stock	38.45	38.6	38.2275	38.5248	13331080.0

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

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