PREVIEW / stock_1hour / 2015-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-30.parquet
  size:    1.1 MB
  rows:    50,262
  symbols: 3,447

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
2015-11-30 04:00:00	AAPL	Stock	29.4525	29.47	29.4475	29.4625	6932.0
2015-11-30 05:00:00	AAPL	Stock	29.46	29.46	29.45	29.45	4796.0
2015-11-30 06:00:00	AAPL	Stock	29.45	29.5575	29.45	29.5	61148.0
2015-11-30 07:00:00	AAPL	Stock	29.4875	29.53	29.485	29.52	89628.0
2015-11-30 08:00:00	AAPL	Stock	29.51	29.5325	29.4725	29.505	286020.0
2015-11-30 09:00:00	AAPL	Stock	29.505	29.8125	29.4375	29.7025	21516884.0
2015-11-30 10:00:00	AAPL	Stock	29.7075	29.8548	29.6615	29.7378	24281168.0
2015-11-30 11:00:00	AAPL	Stock	29.745	29.7575	29.5125	29.5525	16327308.0
2015-11-30 12:00:00	AAPL	Stock	29.555	29.67	29.5375	29.655	8294300.0
2015-11-30 13:00:00	AAPL	Stock	29.6538	29.7375	29.5828	29.7312	8655580.0
2015-11-30 14:00:00	AAPL	Stock	29.7325	29.785	29.6642	29.6725	11865868.0
2015-11-30 15:00:00	AAPL	Stock	29.671	29.6975	29.5725	29.5925	23904968.0
2015-11-30 16:00:00	AAPL	Stock	29.575	29.64	29.572	29.6	25298060.0
2015-11-30 17:00:00	AAPL	Stock	29.575	29.6175	29.575	29.605	630404.0
2015-11-30 18:00:00	AAPL	Stock	29.61	29.635	29.575	29.625	114848.0
2015-11-30 19:00:00	AAPL	Stock	29.625	29.635	29.61	29.6325	92312.0
2015-11-30 04:00:00	MSFT	Stock	54.0	54.0	54.0	54.0	300.0
2015-11-30 05:00:00	MSFT	Stock	54.0	54.0	54.0	54.0	4000.0
2015-11-30 06:00:00	MSFT	Stock	54.07	54.07	54.07	54.07	100.0
2015-11-30 07:00:00	MSFT	Stock	54.17	54.67	54.11	54.51	84381.0
2015-11-30 08:00:00	MSFT	Stock	54.52	54.7	54.02	54.56	92161.0
2015-11-30 09:00:00	MSFT	Stock	54.54	54.82	54.37	54.405	6693702.0
2015-11-30 10:00:00	MSFT	Stock	54.4	54.54	54.09	54.399	6047336.0
2015-11-30 11:00:00	MSFT	Stock	54.4	54.61	54.02	54.1	4315259.0
2015-11-30 12:00:00	MSFT	Stock	54.1	54.36	54.0	54.35	3695028.0
2015-11-30 13:00:00	MSFT	Stock	54.342	54.96	54.23	54.871	5384868.0
2015-11-30 14:00:00	MSFT	Stock	54.87	54.95	54.62	54.635	5450904.0
2015-11-30 15:00:00	MSFT	Stock	54.63	54.7	54.35	54.36	11504078.0
2015-11-30 16:00:00	MSFT	Stock	54.36	54.55	54.345	54.5	8097162.0
2015-11-30 17:00:00	MSFT	Stock	54.35	54.49	54.35	54.49	31704.0
2015-11-30 18:00:00	MSFT	Stock	54.49	54.58	54.35	54.58	12800.0
2015-11-30 19:00:00	MSFT	Stock	54.58	54.58	54.58	54.58	1165.0
2015-11-30 08:00:00	NVDA	Stock	0.7895	0.7895	0.7895	0.7895	4000.0
2015-11-30 09:00:00	NVDA	Stock	0.7898	0.7965	0.7848	0.7886	32814800.0
2015-11-30 10:00:00	NVDA	Stock	0.7885	0.7942	0.7874	0.7906	33354440.0
2015-11-30 11:00:00	NVDA	Stock	0.7908	0.7945	0.7885	0.7898	29812680.0
2015-11-30 12:00:00	NVDA	Stock	0.7898	0.7929	0.7892	0.7908	20073800.0
2015-11-30 13:00:00	NVDA	Stock	0.7908	0.795	0.7908	0.7945	42082760.0
2015-11-30 14:00:00	NVDA	Stock	0.7945	0.7949	0.7923	0.7923	27151920.0
2015-11-30 15:00:00	NVDA	Stock	0.7923	0.7938	0.79	0.7928	58214480.0
2015-11-30 16:00:00	NVDA	Stock	0.793	0.7963	0.7929	0.7963	63036400.0
2015-11-30 17:00:00	NVDA	Stock	0.793	0.793	0.793	0.793	33240.0
2015-11-30 18:00:00	NVDA	Stock	0.793	0.793	0.793	0.793	485920.0
2015-11-30 19:00:00	NVDA	Stock	0.7963	0.7963	0.7963	0.7963	4000.0
2015-11-30 04:00:00	AMZN	Stock	33.7	33.8	33.7	33.8	20000.0
2015-11-30 05:00:00	AMZN	Stock	33.76	33.76	33.75	33.75	4800.0
2015-11-30 07:00:00	AMZN	Stock	33.82	33.831	33.81	33.825	25900.0
2015-11-30 08:00:00	AMZN	Stock	33.825	33.8255	33.698	33.784	500480.0
2015-11-30 09:00:00	AMZN	Stock	33.7835	34.0645	33.6755	33.749	19108980.0
2015-11-30 10:00:00	AMZN	Stock	33.749	33.8425	33.625	33.6975	14874040.0

> showing 50 of 50,262 rows — these rows as CSV

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