PREVIEW / stock_1hour / 2016-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-22.parquet
  size:    1.0 MB
  rows:    47,948
  symbols: 3,332

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-03-22 04:00:00	AAPL	Stock	26.49	26.49	26.3025	26.3025	18644.0
2016-03-22 05:00:00	AAPL	Stock	26.395	26.425	26.395	26.425	1600.0
2016-03-22 06:00:00	AAPL	Stock	26.425	26.45	26.38	26.385	7228.0
2016-03-22 07:00:00	AAPL	Stock	26.3825	26.435	26.355	26.3975	76180.0
2016-03-22 08:00:00	AAPL	Stock	26.395	26.43	26.38	26.4025	220428.0
2016-03-22 09:00:00	AAPL	Stock	26.4	26.705	26.3025	26.66	20609236.0
2016-03-22 10:00:00	AAPL	Stock	26.66	26.8225	26.6585	26.775	23161476.0
2016-03-22 11:00:00	AAPL	Stock	26.7725	26.79	26.6775	26.745	17407732.0
2016-03-22 12:00:00	AAPL	Stock	26.7425	26.7525	26.68	26.7075	8000140.0
2016-03-22 13:00:00	AAPL	Stock	26.705	26.7125	26.6505	26.7025	8929676.0
2016-03-22 14:00:00	AAPL	Stock	26.7025	26.785	26.7	26.7125	11637024.0
2016-03-22 15:00:00	AAPL	Stock	26.7125	26.74	26.6675	26.685	16986052.0
2016-03-22 16:00:00	AAPL	Stock	26.68	26.6825	26.3928	26.64	9357344.0
2016-03-22 17:00:00	AAPL	Stock	26.635	26.64	26.6	26.6125	80460.0
2016-03-22 18:00:00	AAPL	Stock	26.625	26.635	26.6175	26.625	23036.0
2016-03-22 19:00:00	AAPL	Stock	26.625	26.6475	26.625	26.64	32336.0
2016-03-22 05:00:00	MSFT	Stock	53.7	53.7	53.7	53.7	2000.0
2016-03-22 07:00:00	MSFT	Stock	53.67	53.67	53.67	53.67	100.0
2016-03-22 08:00:00	MSFT	Stock	53.55	53.6	53.5	53.53	5060.0
2016-03-22 09:00:00	MSFT	Stock	53.64	53.83	53.46	53.54	2753227.0
2016-03-22 10:00:00	MSFT	Stock	53.535	53.85	53.53	53.805	2887446.0
2016-03-22 11:00:00	MSFT	Stock	53.8	53.96	53.66	53.765	2033581.0
2016-03-22 12:00:00	MSFT	Stock	53.76	54.12	53.75	54.07	1446592.0
2016-03-22 13:00:00	MSFT	Stock	54.07	54.17	53.995	54.11	1670270.0
2016-03-22 14:00:00	MSFT	Stock	54.11	54.25	54.05	54.13	2221593.0
2016-03-22 15:00:00	MSFT	Stock	54.135	54.195	54.015	54.09	4719929.0
2016-03-22 16:00:00	MSFT	Stock	54.07	54.16	53.908	54.07	2729525.0
2016-03-22 17:00:00	MSFT	Stock	54.16	54.16	54.03	54.05	8800.0
2016-03-22 18:00:00	MSFT	Stock	54.1	54.1	54.1	54.1	5646.0
2016-03-22 19:00:00	MSFT	Stock	54.05	54.05	53.96	53.96	5400.0
2016-03-22 07:00:00	NVDA	Stock	0.8375	0.8375	0.8375	0.8375	40000.0
2016-03-22 08:00:00	NVDA	Stock	0.8375	0.8438	0.8375	0.8438	39640.0
2016-03-22 09:00:00	NVDA	Stock	0.8458	0.8458	0.8358	0.8408	28990040.0
2016-03-22 10:00:00	NVDA	Stock	0.8408	0.851	0.8405	0.847	40171440.0
2016-03-22 11:00:00	NVDA	Stock	0.847	0.8512	0.8462	0.8475	17488480.0
2016-03-22 12:00:00	NVDA	Stock	0.8474	0.8521	0.8459	0.8511	30024240.0
2016-03-22 13:00:00	NVDA	Stock	0.8512	0.8515	0.8492	0.85	17963680.0
2016-03-22 14:00:00	NVDA	Stock	0.85	0.851	0.8478	0.848	16925760.0
2016-03-22 15:00:00	NVDA	Stock	0.8478	0.8488	0.8455	0.8462	59910400.0
2016-03-22 16:00:00	NVDA	Stock	0.8462	0.848	0.8462	0.848	1210960.0
2016-03-22 18:00:00	NVDA	Stock	0.8475	0.8475	0.8452	0.8452	32000.0
2016-03-22 19:00:00	NVDA	Stock	0.8475	0.8475	0.8475	0.8475	4000.0
2016-03-22 04:00:00	AMZN	Stock	27.35	27.35	27.253	27.253	4480.0
2016-03-22 06:00:00	AMZN	Stock	27.3355	27.342	27.3355	27.34	14860.0
2016-03-22 07:00:00	AMZN	Stock	27.3475	27.451	27.3285	27.3285	146700.0
2016-03-22 08:00:00	AMZN	Stock	27.3625	27.4	27.25	27.301	188780.0
2016-03-22 09:00:00	AMZN	Stock	27.3	27.9355	27.2005	27.897	13451380.0
2016-03-22 10:00:00	AMZN	Stock	27.897	27.9625	27.7275	27.835	11428040.0
2016-03-22 11:00:00	AMZN	Stock	27.836	27.935	27.835	27.888	5372180.0
2016-03-22 12:00:00	AMZN	Stock	27.8988	28.11	27.81	28.063	9306960.0

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

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