PREVIEW / stock_1hour / 2013-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-29.parquet
  size:    690 KB
  rows:    29,411
  symbols: 3,448

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-11-29 04:00:00	AAPL	Stock	19.5754	19.6332	19.5754	19.6157	109564.0
2013-11-29 05:00:00	AAPL	Stock	19.6421	19.6607	19.6157	19.6182	50064.0
2013-11-29 06:00:00	AAPL	Stock	19.6425	19.6821	19.6236	19.6536	513016.0
2013-11-29 07:00:00	AAPL	Stock	19.6536	19.6607	19.6293	19.6393	882336.0
2013-11-29 08:00:00	AAPL	Stock	19.6379	19.6939	19.4821	19.65	3530716.0
2013-11-29 09:00:00	AAPL	Stock	19.6482	19.6607	19.5646	19.6445	66203312.0
2013-11-29 10:00:00	AAPL	Stock	19.6483	19.7089	19.6204	19.7079	50926876.0
2013-11-29 11:00:00	AAPL	Stock	19.7082	19.9046	19.6964	19.8554	82455968.0
2013-11-29 12:00:00	AAPL	Stock	19.8571	19.9404	19.8475	19.86	76603660.0
2013-11-29 13:00:00	AAPL	Stock	19.8596	19.8929	19.7634	19.8929	33405708.0
2013-11-29 14:00:00	AAPL	Stock	19.8929	19.8929	19.8596	19.8843	601188.0
2013-11-29 15:00:00	AAPL	Stock	19.8839	19.8886	19.8814	19.8814	204596.0
2013-11-29 16:00:00	AAPL	Stock	19.8779	19.8814	19.8607	19.8607	285292.0
2013-11-29 04:00:00	MSFT	Stock	37.75	37.75	37.75	37.75	400.0
2013-11-29 07:00:00	MSFT	Stock	37.82	37.85	37.82	37.85	4470.0
2013-11-29 08:00:00	MSFT	Stock	37.83	37.87	37.8	37.85	12882.0
2013-11-29 09:00:00	MSFT	Stock	37.86	38.189	37.8	38.15	4953051.0
2013-11-29 10:00:00	MSFT	Stock	38.157	38.29	38.11	38.25	4594280.0
2013-11-29 11:00:00	MSFT	Stock	38.24	38.29	38.14	38.15	3348977.0
2013-11-29 12:00:00	MSFT	Stock	38.15	38.24	38.1	38.13	4999235.0
2013-11-29 13:00:00	MSFT	Stock	38.13	38.224	38.04	38.04	3935305.0
2013-11-29 14:00:00	MSFT	Stock	38.03	38.03	38.0	38.0	6445.0
2013-11-29 15:00:00	MSFT	Stock	38.12	38.12	38.12	38.12	1000.0
2013-11-29 16:00:00	MSFT	Stock	38.186	38.186	38.186	38.186	37600.0
2013-11-29 09:00:00	NVDA	Stock	0.3925	0.3935	0.39	0.3918	11928400.0
2013-11-29 10:00:00	NVDA	Stock	0.3918	0.3925	0.3905	0.3905	16388840.0
2013-11-29 11:00:00	NVDA	Stock	0.3905	0.3915	0.3902	0.3902	13876760.0
2013-11-29 12:00:00	NVDA	Stock	0.3902	0.3908	0.3875	0.3902	55815120.0
2013-11-29 13:00:00	NVDA	Stock	0.39	0.3913	0.3862	0.39	15526000.0
2013-11-29 04:00:00	AMZN	Stock	19.462	19.462	19.462	19.462	2000.0
2013-11-29 06:00:00	AMZN	Stock	19.495	19.495	19.495	19.495	6000.0
2013-11-29 07:00:00	AMZN	Stock	19.4995	19.5375	19.4905	19.4905	157620.0
2013-11-29 08:00:00	AMZN	Stock	19.5	19.5345	19.4615	19.4615	351260.0
2013-11-29 09:00:00	AMZN	Stock	19.4625	19.623	19.431	19.532	12053760.0
2013-11-29 10:00:00	AMZN	Stock	19.5341	19.65	19.517	19.5755	11082660.0
2013-11-29 11:00:00	AMZN	Stock	19.576	19.6557	19.5535	19.637	7543460.0
2013-11-29 12:00:00	AMZN	Stock	19.6375	19.705	19.6276	19.681	13084300.0
2013-11-29 13:00:00	AMZN	Stock	19.681	19.697	19.5985	19.69	3490880.0
2013-11-29 14:00:00	AMZN	Stock	19.69	19.697	19.685	19.69	90320.0
2013-11-29 15:00:00	AMZN	Stock	19.6875	19.6985	19.6875	19.69	41100.0
2013-11-29 16:00:00	AMZN	Stock	19.6535	19.6535	19.6535	19.6535	14000.0
2013-11-29 04:00:00	META	Stock	46.49	46.49	46.49	46.49	135.0
2013-11-29 05:00:00	META	Stock	46.54	46.54	46.49	46.49	1170.0
2013-11-29 06:00:00	META	Stock	46.49	46.6	46.49	46.6	1750.0
2013-11-29 07:00:00	META	Stock	46.59	46.69	46.53	46.53	15600.0
2013-11-29 08:00:00	META	Stock	46.55	46.69	46.52	46.65	107516.0
2013-11-29 09:00:00	META	Stock	46.64	47.15	46.5	47.036	6613496.0
2013-11-29 10:00:00	META	Stock	47.04	47.21	46.85	47.09	6336751.0
2013-11-29 11:00:00	META	Stock	47.08	47.19	46.94	46.98	3412753.0
2013-11-29 12:00:00	META	Stock	46.98	47.08	46.86	47.01	5203393.0

> showing 50 of 29,411 rows — these rows as CSV

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