PREVIEW / stock_1hour / 2015-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-29.parquet
  size:    1.0 MB
  rows:    48,943
  symbols: 3,429

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-12-29 04:00:00	AAPL	Stock	26.75	26.875	26.75	26.875	6000.0
2015-12-29 05:00:00	AAPL	Stock	26.8375	26.8525	26.8275	26.845	3928.0
2015-12-29 06:00:00	AAPL	Stock	26.8375	26.85	26.78	26.785	26296.0
2015-12-29 07:00:00	AAPL	Stock	26.7975	26.87	26.78	26.8	112120.0
2015-12-29 08:00:00	AAPL	Stock	26.7825	26.85	26.725	26.8125	483644.0
2015-12-29 09:00:00	AAPL	Stock	26.8125	26.925	26.715	26.8425	14434984.0
2015-12-29 10:00:00	AAPL	Stock	26.8425	26.9472	26.8325	26.875	14394248.0
2015-12-29 11:00:00	AAPL	Stock	26.875	27.0125	26.875	26.9702	13259080.0
2015-12-29 12:00:00	AAPL	Stock	26.9712	27.1525	26.9705	27.1335	13654156.0
2015-12-29 13:00:00	AAPL	Stock	27.135	27.2925	27.1325	27.2675	15426168.0
2015-12-29 14:00:00	AAPL	Stock	27.27	27.3575	27.2542	27.3075	15114200.0
2015-12-29 15:00:00	AAPL	Stock	27.309	27.3275	27.155	27.185	20732200.0
2015-12-29 16:00:00	AAPL	Stock	27.1825	27.2	26.956	27.1775	5496856.0
2015-12-29 17:00:00	AAPL	Stock	27.1775	27.19	27.175	27.1875	168468.0
2015-12-29 18:00:00	AAPL	Stock	27.1875	27.19	27.1775	27.1775	28080.0
2015-12-29 19:00:00	AAPL	Stock	27.18	27.1875	27.175	27.175	20212.0
2015-12-29 07:00:00	MSFT	Stock	56.08	56.15	56.08	56.15	1029.0
2015-12-29 08:00:00	MSFT	Stock	56.16	56.4	56.16	56.39	19875.0
2015-12-29 09:00:00	MSFT	Stock	56.34	56.4	56.06	56.4	3305244.0
2015-12-29 10:00:00	MSFT	Stock	56.4	56.64	56.14	56.41	5165615.0
2015-12-29 11:00:00	MSFT	Stock	56.42	56.59	56.39	56.548	2223789.0
2015-12-29 12:00:00	MSFT	Stock	56.54	56.635	56.47	56.605	1906834.0
2015-12-29 13:00:00	MSFT	Stock	56.6	56.85	56.48	56.804	2783854.0
2015-12-29 14:00:00	MSFT	Stock	56.81	56.85	56.66	56.756	2709984.0
2015-12-29 15:00:00	MSFT	Stock	56.752	56.84	56.53	56.55	4714012.0
2015-12-29 16:00:00	MSFT	Stock	56.55	56.56	56.5	56.55	3177103.0
2015-12-29 17:00:00	MSFT	Stock	56.61	56.61	56.55	56.56	97059.0
2015-12-29 18:00:00	MSFT	Stock	56.55	56.55	56.55	56.55	400.0
2015-12-29 19:00:00	MSFT	Stock	56.55	56.56	56.55	56.56	1500.0
2015-12-29 09:00:00	NVDA	Stock	0.8308	0.834	0.8268	0.8331	24855000.0
2015-12-29 10:00:00	NVDA	Stock	0.833	0.8368	0.833	0.8363	26879200.0
2015-12-29 11:00:00	NVDA	Stock	0.836	0.8388	0.8358	0.8388	32037360.0
2015-12-29 12:00:00	NVDA	Stock	0.8382	0.839	0.8375	0.8389	13092680.0
2015-12-29 13:00:00	NVDA	Stock	0.8388	0.841	0.8385	0.841	16069800.0
2015-12-29 14:00:00	NVDA	Stock	0.841	0.844	0.84	0.844	20984200.0
2015-12-29 15:00:00	NVDA	Stock	0.8439	0.8445	0.8415	0.8419	52296280.0
2015-12-29 16:00:00	NVDA	Stock	0.842	0.8435	0.842	0.8435	8368320.0
2015-12-29 17:00:00	NVDA	Stock	0.8445	0.8445	0.8445	0.8445	16000.0
2015-12-29 18:00:00	NVDA	Stock	0.846	0.846	0.846	0.846	4000.0
2015-12-29 19:00:00	NVDA	Stock	0.8445	0.8445	0.8445	0.8445	4000.0
2015-12-29 05:00:00	AMZN	Stock	33.946	33.946	33.946	33.946	4000.0
2015-12-29 06:00:00	AMZN	Stock	33.942	33.942	33.8975	33.8975	8420.0
2015-12-29 07:00:00	AMZN	Stock	33.9	33.925	33.898	33.925	71280.0
2015-12-29 08:00:00	AMZN	Stock	33.8735	33.945	33.8605	33.8915	1075160.0
2015-12-29 09:00:00	AMZN	Stock	33.8875	34.3015	33.8565	34.2975	17198840.0
2015-12-29 10:00:00	AMZN	Stock	34.2975	34.4875	34.238	34.373	19450140.0
2015-12-29 11:00:00	AMZN	Stock	34.382	34.642	34.3655	34.6344	16459440.0
2015-12-29 12:00:00	AMZN	Stock	34.6258	34.745	34.5625	34.6	12056200.0
2015-12-29 13:00:00	AMZN	Stock	34.5965	34.722	34.567	34.704	7352080.0
2015-12-29 14:00:00	AMZN	Stock	34.7035	34.7935	34.6435	34.793	9318480.0

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

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