PREVIEW / stock_1hour / 2013-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-13.parquet
  size:    996 KB
  rows:    46,060
  symbols: 3,511

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-09-13 04:00:00	AAPL	Stock	16.9286	16.9539	16.8961	16.8961	93800.0
2013-09-13 05:00:00	AAPL	Stock	16.9039	16.9043	16.9039	16.9043	5600.0
2013-09-13 06:00:00	AAPL	Stock	16.8839	16.8839	16.7518	16.765	369740.0
2013-09-13 07:00:00	AAPL	Stock	16.765	16.8214	16.7518	16.7786	602784.0
2013-09-13 08:00:00	AAPL	Stock	16.7786	16.8357	16.7557	16.7786	2402260.0
2013-09-13 09:00:00	AAPL	Stock	16.7786	16.851	16.7043	16.7043	60051096.0
2013-09-13 10:00:00	AAPL	Stock	16.705	16.7318	16.6586	16.6918	55210736.0
2013-09-13 11:00:00	AAPL	Stock	16.6918	16.7564	16.6807	16.7052	26133464.0
2013-09-13 12:00:00	AAPL	Stock	16.7064	16.7211	16.6679	16.6729	20552196.0
2013-09-13 13:00:00	AAPL	Stock	16.6729	16.6954	16.6607	16.6815	17656604.0
2013-09-13 14:00:00	AAPL	Stock	16.6836	16.685	16.6179	16.621	32470088.0
2013-09-13 15:00:00	AAPL	Stock	16.6204	16.6475	16.5964	16.6036	68253416.0
2013-09-13 16:00:00	AAPL	Stock	16.6036	16.8818	16.6004	16.6064	11985708.0
2013-09-13 17:00:00	AAPL	Stock	16.6043	16.6089	16.5496	16.5693	1368220.0
2013-09-13 18:00:00	AAPL	Stock	16.5664	16.5664	16.5396	16.5468	354900.0
2013-09-13 19:00:00	AAPL	Stock	16.5464	16.5546	16.5464	16.5536	163240.0
2013-09-13 06:00:00	MSFT	Stock	32.66	32.66	32.66	32.66	100.0
2013-09-13 07:00:00	MSFT	Stock	32.6	32.66	32.6	32.66	1700.0
2013-09-13 08:00:00	MSFT	Stock	32.67	32.67	32.66	32.66	5290.0
2013-09-13 09:00:00	MSFT	Stock	32.68	32.84	32.53	32.6	4472095.0
2013-09-13 10:00:00	MSFT	Stock	32.602	32.71	32.505	32.563	7191866.0
2013-09-13 11:00:00	MSFT	Stock	32.564	32.74	32.56	32.74	4068481.0
2013-09-13 12:00:00	MSFT	Stock	32.735	32.84	32.7	32.75	2500031.0
2013-09-13 13:00:00	MSFT	Stock	32.755	33.07	32.755	33.04	5236675.0
2013-09-13 14:00:00	MSFT	Stock	33.04	33.055	32.91	32.99	4180471.0
2013-09-13 15:00:00	MSFT	Stock	32.99	33.05	32.83	33.03	10392824.0
2013-09-13 16:00:00	MSFT	Stock	33.03	33.1	32.71	33.1	2519848.0
2013-09-13 17:00:00	MSFT	Stock	33.07	33.1	32.933	33.03	4831.0
2013-09-13 18:00:00	MSFT	Stock	32.95	33.06	32.95	32.97	6494.0
2013-09-13 19:00:00	MSFT	Stock	33.0	33.0	33.0	33.0	405.0
2013-09-13 09:00:00	NVDA	Stock	0.3925	0.3968	0.3925	0.3962	28966680.0
2013-09-13 10:00:00	NVDA	Stock	0.3962	0.3965	0.3913	0.3915	24823960.0
2013-09-13 11:00:00	NVDA	Stock	0.3915	0.3933	0.391	0.393	13290200.0
2013-09-13 12:00:00	NVDA	Stock	0.393	0.3948	0.3928	0.3946	15467200.0
2013-09-13 13:00:00	NVDA	Stock	0.3945	0.3955	0.3938	0.3946	14464440.0
2013-09-13 14:00:00	NVDA	Stock	0.3948	0.3948	0.394	0.3945	14029000.0
2013-09-13 15:00:00	NVDA	Stock	0.3945	0.3958	0.3942	0.395	39041200.0
2013-09-13 16:00:00	NVDA	Stock	0.395	0.3958	0.3922	0.3958	9293400.0
2013-09-13 08:00:00	AMZN	Stock	14.9135	14.943	14.9135	14.943	180000.0
2013-09-13 09:00:00	AMZN	Stock	14.982	15.036	14.9035	14.9602	4029320.0
2013-09-13 10:00:00	AMZN	Stock	14.9435	14.944	14.8101	14.8713	7612300.0
2013-09-13 11:00:00	AMZN	Stock	14.867	14.91	14.8485	14.8805	1990740.0
2013-09-13 12:00:00	AMZN	Stock	14.888	14.946	14.8815	14.908	1483840.0
2013-09-13 13:00:00	AMZN	Stock	14.9085	14.9402	14.8845	14.8885	1430660.0
2013-09-13 14:00:00	AMZN	Stock	14.8924	14.925	14.8851	14.9105	1860620.0
2013-09-13 15:00:00	AMZN	Stock	14.9095	14.9155	14.845	14.8925	6101640.0
2013-09-13 16:00:00	AMZN	Stock	14.896	14.9	14.861	14.9	205060.0
2013-09-13 17:00:00	AMZN	Stock	14.9005	14.9005	14.9	14.9	20780.0
2013-09-13 04:00:00	META	Stock	45.0	45.16	44.99	44.99	6300.0
2013-09-13 05:00:00	META	Stock	45.12	45.12	45.07	45.09	985.0

> showing 50 of 46,060 rows — these rows as CSV

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