PREVIEW / stock_1hour / 2013-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-06.parquet
  size:    1017 KB
  rows:    46,885
  symbols: 3,512

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-08-06 04:00:00	AAPL	Stock	16.7739	16.7768	16.7739	16.7768	11200.0
2013-08-06 05:00:00	AAPL	Stock	16.7257	16.7321	16.7257	16.7321	8400.0
2013-08-06 06:00:00	AAPL	Stock	16.7679	16.7768	16.6964	16.6964	107464.0
2013-08-06 07:00:00	AAPL	Stock	16.7139	16.7429	16.6964	16.7143	64372.0
2013-08-06 08:00:00	AAPL	Stock	16.705	16.7479	16.705	16.7314	843472.0
2013-08-06 09:00:00	AAPL	Stock	16.7314	16.8532	16.7068	16.805	58219084.0
2013-08-06 10:00:00	AAPL	Stock	16.8054	16.8218	16.5711	16.5714	66817604.0
2013-08-06 11:00:00	AAPL	Stock	16.5739	16.6786	16.55	16.6143	45717644.0
2013-08-06 12:00:00	AAPL	Stock	16.6171	16.6514	16.5964	16.6268	18079348.0
2013-08-06 13:00:00	AAPL	Stock	16.6293	16.6314	16.575	16.5814	17896480.0
2013-08-06 14:00:00	AAPL	Stock	16.5814	16.6125	16.5061	16.5875	39830616.0
2013-08-06 15:00:00	AAPL	Stock	16.5904	16.7143	16.5821	16.615	46629576.0
2013-08-06 16:00:00	AAPL	Stock	16.6161	16.796	16.6154	16.6161	23180360.0
2013-08-06 17:00:00	AAPL	Stock	16.6182	16.6207	16.6071	16.6071	155288.0
2013-08-06 18:00:00	AAPL	Stock	16.6071	16.6154	16.6071	16.6154	19908.0
2013-08-06 19:00:00	AAPL	Stock	16.6161	16.6182	16.6014	16.6143	35280.0
2013-08-06 06:00:00	MSFT	Stock	31.7	31.7	31.69	31.69	413.0
2013-08-06 08:00:00	MSFT	Stock	31.69	31.69	31.66	31.69	5589.0
2013-08-06 09:00:00	MSFT	Stock	31.68	31.74	31.47	31.54	4151271.0
2013-08-06 10:00:00	MSFT	Stock	31.53	31.55	31.42	31.455	6560828.0
2013-08-06 11:00:00	MSFT	Stock	31.456	31.53	31.44	31.52	4420603.0
2013-08-06 12:00:00	MSFT	Stock	31.52	31.54	31.46	31.5	3409231.0
2013-08-06 13:00:00	MSFT	Stock	31.5	31.51	31.39	31.4	2917433.0
2013-08-06 14:00:00	MSFT	Stock	31.4	31.445	31.38	31.435	3311640.0
2013-08-06 15:00:00	MSFT	Stock	31.44	31.61	31.43	31.58	9259972.0
2013-08-06 16:00:00	MSFT	Stock	31.57	31.656	31.447	31.58	1982862.0
2013-08-06 17:00:00	MSFT	Stock	31.52	31.58	31.51	31.52	19945.0
2013-08-06 18:00:00	MSFT	Stock	31.51	31.53	31.439	31.53	1948.0
2013-08-06 19:00:00	MSFT	Stock	31.53	31.53	31.52	31.52	1400.0
2013-08-06 09:00:00	NVDA	Stock	0.371	0.3718	0.3678	0.3685	20659200.0
2013-08-06 10:00:00	NVDA	Stock	0.3682	0.369	0.3658	0.3663	40492560.0
2013-08-06 11:00:00	NVDA	Stock	0.3662	0.3665	0.3658	0.3661	18875720.0
2013-08-06 12:00:00	NVDA	Stock	0.366	0.367	0.3658	0.3662	17311120.0
2013-08-06 13:00:00	NVDA	Stock	0.3662	0.3668	0.3655	0.3658	19651960.0
2013-08-06 14:00:00	NVDA	Stock	0.3658	0.366	0.3645	0.3659	30269520.0
2013-08-06 15:00:00	NVDA	Stock	0.3659	0.366	0.3648	0.3655	45894800.0
2013-08-06 16:00:00	NVDA	Stock	0.3652	0.3702	0.3649	0.3652	12692360.0
2013-08-06 07:00:00	AMZN	Stock	15.049	15.049	15.049	15.049	2000.0
2013-08-06 08:00:00	AMZN	Stock	15.0035	15.0495	15.0035	15.0495	46000.0
2013-08-06 09:00:00	AMZN	Stock	15.03	15.0495	14.927	14.9878	7176460.0
2013-08-06 10:00:00	AMZN	Stock	14.9965	15.014	14.883	14.883	5985960.0
2013-08-06 11:00:00	AMZN	Stock	14.887	15.01	14.876	14.9882	5413860.0
2013-08-06 12:00:00	AMZN	Stock	14.9895	15.068	14.9785	15.0499	4473100.0
2013-08-06 13:00:00	AMZN	Stock	15.049	15.0665	15.0	15.0175	2932500.0
2013-08-06 14:00:00	AMZN	Stock	15.0105	15.065	14.9965	15.0472	2936260.0
2013-08-06 15:00:00	AMZN	Stock	15.0462	15.0585	15.004	15.037	5445640.0
2013-08-06 16:00:00	AMZN	Stock	15.0375	15.0706	14.9972	15.0375	859480.0
2013-08-06 19:00:00	AMZN	Stock	15.0	15.0	15.0	15.0	16900.0
2013-08-06 04:00:00	META	Stock	37.9	39.37	37.9	39.23	7929.0
2013-08-06 05:00:00	META	Stock	39.23	39.34	39.23	39.34	3700.0

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

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