PREVIEW / stock_1hour / 2014-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-16.parquet
  size:    1.1 MB
  rows:    49,943
  symbols: 3,541

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
2014-12-16 04:00:00	AAPL	Stock	26.975	26.975	26.77	26.945	51892.0
2014-12-16 05:00:00	AAPL	Stock	26.9525	27.025	26.945	27.025	23104.0
2014-12-16 06:00:00	AAPL	Stock	26.985	27.05	26.8275	26.8275	74556.0
2014-12-16 07:00:00	AAPL	Stock	26.825	26.8275	26.55	26.555	757884.0
2014-12-16 08:00:00	AAPL	Stock	26.555	26.8125	26.525	26.6525	2293696.0
2014-12-16 09:00:00	AAPL	Stock	26.66	27.11	26.565	26.8325	35325740.0
2014-12-16 10:00:00	AAPL	Stock	26.825	27.17	26.6825	27.155	38491196.0
2014-12-16 11:00:00	AAPL	Stock	27.155	27.54	27.13	27.31	35243480.0
2014-12-16 12:00:00	AAPL	Stock	27.3075	27.375	27.15	27.1582	17091708.0
2014-12-16 13:00:00	AAPL	Stock	27.1578	27.2275	26.9025	27.0625	23360428.0
2014-12-16 14:00:00	AAPL	Stock	27.0575	27.172	26.93	26.9725	15307260.0
2014-12-16 15:00:00	AAPL	Stock	26.9725	27.02	26.6625	26.685	40996008.0
2014-12-16 16:00:00	AAPL	Stock	26.6862	27.287	26.6028	26.6625	18105692.0
2014-12-16 17:00:00	AAPL	Stock	26.6725	26.6875	26.6375	26.6375	191660.0
2014-12-16 18:00:00	AAPL	Stock	26.64	26.6875	26.6125	26.6548	223976.0
2014-12-16 19:00:00	AAPL	Stock	26.6525	26.735	26.6475	26.725	191700.0
2014-12-16 04:00:00	MSFT	Stock	46.6	46.81	46.6	46.81	600.0
2014-12-16 05:00:00	MSFT	Stock	46.84	46.84	46.84	46.84	200.0
2014-12-16 06:00:00	MSFT	Stock	46.76	46.76	46.05	46.05	26700.0
2014-12-16 07:00:00	MSFT	Stock	46.06	46.06	45.85	46.06	50132.0
2014-12-16 08:00:00	MSFT	Stock	46.04	46.13	45.95	46.0	68466.0
2014-12-16 09:00:00	MSFT	Stock	45.98	46.05	45.47	45.8	6357868.0
2014-12-16 10:00:00	MSFT	Stock	45.8	45.975	45.59	45.85	7720053.0
2014-12-16 11:00:00	MSFT	Stock	45.85	46.34	45.795	46.01	6757202.0
2014-12-16 12:00:00	MSFT	Stock	46.01	46.19	45.87	45.89	2867499.0
2014-12-16 13:00:00	MSFT	Stock	45.88	46.09	45.62	45.88	4153680.0
2014-12-16 14:00:00	MSFT	Stock	45.88	45.98	45.59	45.661	2883610.0
2014-12-16 15:00:00	MSFT	Stock	45.67	45.75	45.13	45.16	11353345.0
2014-12-16 16:00:00	MSFT	Stock	45.16	46.098	45.155	45.856	4148838.0
2014-12-16 17:00:00	MSFT	Stock	45.16	45.22	45.16	45.21	38216.0
2014-12-16 18:00:00	MSFT	Stock	45.22	45.22	45.17	45.2	3787.0
2014-12-16 19:00:00	MSFT	Stock	45.18	45.22	45.17	45.22	22795.0
2014-12-16 06:00:00	NVDA	Stock	0.4892	0.4892	0.4892	0.4892	16000.0
2014-12-16 07:00:00	NVDA	Stock	0.4875	0.4875	0.4875	0.4875	17600.0
2014-12-16 09:00:00	NVDA	Stock	0.4862	0.4918	0.485	0.4888	20564000.0
2014-12-16 10:00:00	NVDA	Stock	0.4888	0.4919	0.4855	0.4915	27095760.0
2014-12-16 11:00:00	NVDA	Stock	0.4915	0.4965	0.4898	0.4932	24468080.0
2014-12-16 12:00:00	NVDA	Stock	0.4935	0.4952	0.4928	0.493	11549160.0
2014-12-16 13:00:00	NVDA	Stock	0.4928	0.4932	0.4878	0.49	11499880.0
2014-12-16 14:00:00	NVDA	Stock	0.49	0.4918	0.4885	0.4895	11300040.0
2014-12-16 15:00:00	NVDA	Stock	0.4895	0.4905	0.4835	0.4835	57414120.0
2014-12-16 16:00:00	NVDA	Stock	0.4838	0.4838	0.4836	0.4836	1017840.0
2014-12-16 04:00:00	AMZN	Stock	15.3	15.3	15.3	15.3	2880.0
2014-12-16 07:00:00	AMZN	Stock	15.2085	15.249	15.18	15.2125	94060.0
2014-12-16 08:00:00	AMZN	Stock	15.2295	15.25	15.2125	15.235	44600.0
2014-12-16 09:00:00	AMZN	Stock	15.2125	15.25	15.002	15.0972	17218380.0
2014-12-16 10:00:00	AMZN	Stock	15.1015	15.1265	14.876	14.95	24412420.0
2014-12-16 11:00:00	AMZN	Stock	14.9455	15.052	14.927	14.9412	15555220.0
2014-12-16 12:00:00	AMZN	Stock	14.9485	15.0065	14.931	14.98	9367940.0
2014-12-16 13:00:00	AMZN	Stock	14.979	15.015	14.825	14.9064	17517800.0

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

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