PREVIEW / stock_1hour / 2013-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-23.parquet
  size:    1.0 MB
  rows:    47,259
  symbols: 3,536

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
2013-10-23 04:00:00	AAPL	Stock	18.4954	18.5268	18.4954	18.5268	33600.0
2013-10-23 05:00:00	AAPL	Stock	18.5357	18.5357	18.4954	18.4954	64400.0
2013-10-23 06:00:00	AAPL	Stock	18.4771	18.5	18.4589	18.4589	103600.0
2013-10-23 07:00:00	AAPL	Stock	18.4679	18.5179	18.4504	18.4911	369880.0
2013-10-23 08:00:00	AAPL	Stock	18.5168	18.6336	18.4571	18.6246	2091992.0
2013-10-23 09:00:00	AAPL	Stock	18.6293	18.75	18.5357	18.5854	63549332.0
2013-10-23 10:00:00	AAPL	Stock	18.5871	18.7143	18.5454	18.6429	52493672.0
2013-10-23 11:00:00	AAPL	Stock	18.6493	18.7079	18.6454	18.6704	24762752.0
2013-10-23 12:00:00	AAPL	Stock	18.6761	18.7143	18.6504	18.7133	19502784.0
2013-10-23 13:00:00	AAPL	Stock	18.7093	18.7361	18.7036	18.7054	21378196.0
2013-10-23 14:00:00	AAPL	Stock	18.7076	18.7275	18.6586	18.7086	22495172.0
2013-10-23 15:00:00	AAPL	Stock	18.7087	18.7739	18.6625	18.7482	77810796.0
2013-10-23 16:00:00	AAPL	Stock	18.7486	18.7643	18.661	18.7536	6665316.0
2013-10-23 17:00:00	AAPL	Stock	18.75	18.75	18.7232	18.7339	332472.0
2013-10-23 18:00:00	AAPL	Stock	18.7357	18.7486	18.7321	18.7468	302904.0
2013-10-23 19:00:00	AAPL	Stock	18.7436	18.7607	18.7425	18.7589	334964.0
2013-10-23 06:00:00	MSFT	Stock	34.46	34.46	34.46	34.46	400.0
2013-10-23 08:00:00	MSFT	Stock	34.48	34.55	34.3	34.43	21555.0
2013-10-23 09:00:00	MSFT	Stock	34.48	34.49	34.11	34.215	6928714.0
2013-10-23 10:00:00	MSFT	Stock	34.215	34.3	33.91	33.96	11116687.0
2013-10-23 11:00:00	MSFT	Stock	33.964	34.03	33.75	33.99	8495483.0
2013-10-23 12:00:00	MSFT	Stock	33.985	34.1	33.88	34.085	3276857.0
2013-10-23 13:00:00	MSFT	Stock	34.089	34.16	34.02	34.038	2881135.0
2013-10-23 14:00:00	MSFT	Stock	34.035	34.085	33.94	33.98	4076596.0
2013-10-23 15:00:00	MSFT	Stock	33.98	33.99	33.674	33.77	15826314.0
2013-10-23 16:00:00	MSFT	Stock	33.745	34.223	33.7	33.82	2342136.0
2013-10-23 17:00:00	MSFT	Stock	33.78	33.8	33.76	33.77	153735.0
2013-10-23 18:00:00	MSFT	Stock	33.79	33.79	33.77	33.78	19815.0
2013-10-23 19:00:00	MSFT	Stock	33.78	33.79	33.76	33.76	5486.0
2013-10-23 09:00:00	NVDA	Stock	0.3933	0.3935	0.3868	0.3899	46371680.0
2013-10-23 10:00:00	NVDA	Stock	0.3898	0.3908	0.388	0.388	48443520.0
2013-10-23 11:00:00	NVDA	Stock	0.388	0.3888	0.3863	0.3871	49941440.0
2013-10-23 12:00:00	NVDA	Stock	0.3873	0.3879	0.3868	0.3876	12563720.0
2013-10-23 13:00:00	NVDA	Stock	0.3876	0.3882	0.3868	0.3868	35978600.0
2013-10-23 14:00:00	NVDA	Stock	0.3868	0.3873	0.3862	0.3866	14110800.0
2013-10-23 15:00:00	NVDA	Stock	0.3866	0.3878	0.3865	0.3878	32151280.0
2013-10-23 16:00:00	NVDA	Stock	0.3878	0.39	0.3868	0.39	10045640.0
2013-10-23 19:00:00	NVDA	Stock	0.3808	0.3808	0.3808	0.3808	16000.0
2013-10-23 04:00:00	AMZN	Stock	16.5	16.5125	16.498	16.5125	13040.0
2013-10-23 06:00:00	AMZN	Stock	16.5325	16.5325	16.5265	16.5295	10600.0
2013-10-23 07:00:00	AMZN	Stock	16.5255	16.5305	16.4625	16.497	100840.0
2013-10-23 08:00:00	AMZN	Stock	16.5	16.5	16.4375	16.5	180540.0
2013-10-23 09:00:00	AMZN	Stock	16.503	16.586	16.341	16.345	10887260.0
2013-10-23 10:00:00	AMZN	Stock	16.3465	16.397	16.203	16.257	14791560.0
2013-10-23 11:00:00	AMZN	Stock	16.2518	16.299	16.211	16.259	5837100.0
2013-10-23 12:00:00	AMZN	Stock	16.2565	16.3175	16.2075	16.314	4248600.0
2013-10-23 13:00:00	AMZN	Stock	16.31	16.352	16.293	16.3345	4044800.0
2013-10-23 14:00:00	AMZN	Stock	16.3303	16.38	16.2901	16.375	5438520.0
2013-10-23 15:00:00	AMZN	Stock	16.376	16.3795	16.3035	16.3485	8311340.0
2013-10-23 16:00:00	AMZN	Stock	16.3485	16.446	16.2642	16.349	1870280.0

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

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